Warning: file_get_contents(https://raw.githubusercontent.com/Den1xxx/Filemanager/master/languages/ru.json): Failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found in /home/monara/public_html/test.athavaneng.com/themes.php on line 99

Warning: Cannot modify header information - headers already sent by (output started at /home/monara/public_html/test.athavaneng.com/themes.php:1) in /home/monara/public_html/test.athavaneng.com/themes.php on line 226

Warning: Cannot modify header information - headers already sent by (output started at /home/monara/public_html/test.athavaneng.com/themes.php:1) in /home/monara/public_html/test.athavaneng.com/themes.php on line 227

Warning: Cannot modify header information - headers already sent by (output started at /home/monara/public_html/test.athavaneng.com/themes.php:1) in /home/monara/public_html/test.athavaneng.com/themes.php on line 228

Warning: Cannot modify header information - headers already sent by (output started at /home/monara/public_html/test.athavaneng.com/themes.php:1) in /home/monara/public_html/test.athavaneng.com/themes.php on line 229

Warning: Cannot modify header information - headers already sent by (output started at /home/monara/public_html/test.athavaneng.com/themes.php:1) in /home/monara/public_html/test.athavaneng.com/themes.php on line 230

Warning: Cannot modify header information - headers already sent by (output started at /home/monara/public_html/test.athavaneng.com/themes.php:1) in /home/monara/public_html/test.athavaneng.com/themes.php on line 231
query("SELECT COUNT(*) FROM agreements WHERE initial_status = 'Active'"); $totalActiveAgreements = $stmtActiveAgr->fetchColumn(); $stmtCasesCount = $pdo->query("SELECT COUNT(*) FROM court_cases"); $totalCases = $stmtCasesCount->fetchColumn(); $stmtSettledCount = $pdo->query("SELECT COUNT(*) FROM court_cases WHERE case_status = 'Settled'"); $settledCases = $stmtSettledCount->fetchColumn(); $disputeResolutionRate = $totalCases > 0 ? round(($settledCases / $totalCases) * 100, 1) : 100.0; $stmtPaMissing = $pdo->query("SELECT COUNT(*) FROM ( SELECT id FROM agreements WHERE pa_ref_number IS NULL OR pa_ref_number = '' UNION ALL SELECT id FROM court_cases WHERE pa_ref_number IS NULL OR pa_ref_number = '' ) as combined_pa"); $awaitingPaInitialization = $stmtPaMissing->fetchColumn(); $stmtArchiveMatch = $pdo->query("SELECT COUNT(*) FROM agreements WHERE cabinet_id IS NOT NULL AND cabinet_id > 0"); $archiveMatchedAgreements = $stmtArchiveMatch->fetchColumn(); $stmtTotalAgreements = $pdo->query("SELECT COUNT(*) FROM agreements"); $totalAgreementsGlobal = $stmtTotalAgreements->fetchColumn(); $archiveMatchRate = $totalAgreementsGlobal > 0 ? round(($archiveMatchedAgreements / $totalAgreementsGlobal) * 100, 0) : 100; // --- LAYER B: SIDE PANEL RIGHT STATS --- $stmtPendingAgr = $pdo->query("SELECT COUNT(*) FROM agreements WHERE initial_status = 'Pending'"); $pendingAgreementsCount = $stmtPendingAgr->fetchColumn(); $stmtRenewalCases = $pdo->query("SELECT COUNT(*) FROM court_cases WHERE case_status IN ('Filing Stage', 'In Progress')"); $casesRenewalCount = $stmtRenewalCases->fetchColumn(); // Fetch both the date and the specific dispute name for the upcoming calendar item $stmtNextHearing = $pdo->query("SELECT next_hearing_date, case_parties FROM court_cases WHERE next_hearing_date >= CURDATE() ORDER BY next_hearing_date ASC LIMIT 1"); $nextHearingRow = $stmtNextHearing->fetch(PDO::FETCH_ASSOC); if ($nextHearingRow) { $nextHearingDate = date('F d', strtotime($nextHearingRow['next_hearing_date'])); $nextHearingCase = htmlspecialchars($nextHearingRow['case_parties']); } else { $nextHearingDate = 'None Scheduled'; $nextHearingCase = 'Clear schedule'; } $stmtMissingEcfSum = $pdo->query("SELECT SUM(amount) FROM payments WHERE ecf_ref_number IS NULL OR ecf_ref_number = ''"); $awaitingEcfAmount = $stmtMissingEcfSum->fetchColumn() ?: 0.00; // --- LAYER C: ACTIVE LITIGATION RECORDS (LIMIT 2) --- $activeLitigations = $pdo->query(" SELECT cc.id, cc.case_parties, cc.case_status, gc.company_name AS group_company, cr.room_name, cab.cabinet_location FROM court_cases cc JOIN group_companies gc ON cc.group_company_id = gc.id JOIN court_rooms cr ON cc.court_id = cr.id JOIN archive_cabinets cab ON cc.cabinet_id = cab.id WHERE cc.case_status != 'Settled' ORDER BY cc.id DESC LIMIT 2 ")->fetchAll(PDO::FETCH_ASSOC); // --- LAYER D: LINKED AGREEMENTS & PAYMENTS (LIMIT 1) --- $linkedAgreements = $pdo->query(" SELECT a.id, a.title, a.pa_ref_number, a.ecf_ref_number, a.initial_status FROM agreements a ORDER BY a.id DESC LIMIT 1 ")->fetchAll(PDO::FETCH_ASSOC); // --- LAYER E: COMPREHENSIVE DYNAMIC TASK AGENDA --- $agendaTasks = $pdo->query(" SELECT id, CONCAT('Review Pending Agreement: ', title) AS task_title, 'Pending' AS task_status, '#f59e0b' AS left_border_color FROM agreements WHERE initial_status = 'Pending' UNION ALL SELECT id, CONCAT('Add New Court Case: ', case_parties) AS task_title, 'Filing Stage' AS task_status, '#3b82f6' AS left_border_color FROM court_cases WHERE case_status = 'Filing Stage' UNION ALL SELECT id, CONCAT('Link Finance Codes for: ', description, ' (Rs. ', FORMAT(amount, 0), ')') AS task_title, 'Missing Ref' AS task_status, '#ef4444' AS left_border_color FROM payments WHERE pa_ref_number = '' OR pa_ref_number IS NULL OR ecf_ref_number = '' OR ecf_ref_number IS NULL UNION ALL SELECT id, CONCAT('Upload Document Scan to Vault for: ', title) AS task_title, 'Upload Pending' AS task_status, '#64748b' AS left_border_color FROM agreements WHERE file_attachment_path IS NULL OR file_attachment_path = '[]' OR file_attachment_path = 'null' ORDER BY id DESC LIMIT 6 ")->fetchAll(PDO::FETCH_ASSOC); $companiesLookup = $pdo->query("SELECT * FROM group_companies ORDER BY company_name ASC")->fetchAll(PDO::FETCH_ASSOC); ?>

Main Dashboard

Real-time stats for the company

Active Contracts
Live, signed corporate deals running right now.
Finished Cases
%
Percentage of legal disputes successfully resolved and closed.
Needs PA Number
Items missing required procurement tracking numbers.
Filing Match
%
Digital agreements successfully stored in physical office cabinets.

Tasks to Do

List of things that need fixing right now

0): ?>
✔ No tasks found! Everything looks clean.

Total Backlog

Pending Drafts
Contracts currently being written or edited that aren't officially signed yet.
Open Cases
Active, unresolved disputes currently moving through the court system.
Next Hearing
⚖
The very next urgent calendar date our legal team must appear in court.
Rs.
Open Payments
Payouts currently blocked or frozen because they are missing an ECF tracking code.

Active Cases

|
›

Recent Agreements

PA: | ECF:
›

All System Tasks

Complete list of tasks to process

✕

Loading tasks...