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 id, company_name FROM group_companies ORDER BY company_name ASC")->fetchAll(); $officers = $pdo->query("SELECT id, full_name FROM users WHERE role IN ('Admin', 'Staff') ORDER BY full_name ASC")->fetchAll(); // --- Execute Selected Report Query --- $report_title = "Legal Report"; $report_data = []; try { switch ($report_type) { // ========================================== // REPORT 1: Master Case Register // ========================================== case 'master_case_register': $report_title = "Master Case Register"; $sql = "SELECT cc.case_number, cc.case_parties, gc.company_name, cr.room_name as court_name, cc.case_status, cc.next_hearing_date, u.full_name as officer_name FROM court_cases cc LEFT JOIN group_companies gc ON cc.group_company_id = gc.id LEFT JOIN court_rooms cr ON cc.court_id = cr.id LEFT JOIN users u ON cc.assigned_officer_id = u.id WHERE 1=1"; $params = []; if ($company_id !== 'All') { $sql .= " AND cc.group_company_id = :cid"; $params[':cid'] = $company_id; } if ($officer_id !== 'All') { $sql .= " AND cc.assigned_officer_id = :oid"; $params[':oid'] = $officer_id; } $sql .= " ORDER BY cc.created_at DESC"; $stmt = $pdo->prepare($sql); $stmt->execute($params); $report_data = $stmt->fetchAll(); break; // ========================================== // REPORT 2: Upcoming Hearings Schedule // ========================================== case 'upcoming_hearings': $report_title = "Upcoming Court Hearings Schedule ({$start_date} to {$end_date})"; $sql = "SELECT cc.next_hearing_date, cc.case_number, cc.case_parties, gc.company_name, cr.room_name as court_name, u.full_name as officer_name, cc.case_description FROM court_cases cc LEFT JOIN group_companies gc ON cc.group_company_id = gc.id LEFT JOIN court_rooms cr ON cc.court_id = cr.id LEFT JOIN users u ON cc.assigned_officer_id = u.id WHERE cc.next_hearing_date BETWEEN :sdate AND :edate AND cc.case_status != 'Settled'"; $params = [':sdate' => $start_date, ':edate' => $end_date]; if ($company_id !== 'All') { $sql .= " AND cc.group_company_id = :cid"; $params[':cid'] = $company_id; } if ($officer_id !== 'All') { $sql .= " AND cc.assigned_officer_id = :oid"; $params[':oid'] = $officer_id; } $sql .= " ORDER BY cc.next_hearing_date ASC"; $stmt = $pdo->prepare($sql); $stmt->execute($params); $report_data = $stmt->fetchAll(); break; // ========================================== // REPORT 3: Next Steps & Deadlines // ========================================== case 'next_steps_due': $report_title = "Procedural Action Steps Due ({$start_date} to {$end_date})"; $sql = "SELECT cc.next_step_date, cc.case_number, cc.case_parties, cc.next_step_description, gc.company_name, u.full_name as officer_name, cc.case_status FROM court_cases cc LEFT JOIN group_companies gc ON cc.group_company_id = gc.id LEFT JOIN users u ON cc.assigned_officer_id = u.id WHERE cc.next_step_date BETWEEN :sdate AND :edate AND cc.case_status != 'Settled'"; $params = [':sdate' => $start_date, ':edate' => $end_date]; if ($company_id !== 'All') { $sql .= " AND cc.group_company_id = :cid"; $params[':cid'] = $company_id; } if ($officer_id !== 'All') { $sql .= " AND cc.assigned_officer_id = :oid"; $params[':oid'] = $officer_id; } $sql .= " ORDER BY cc.next_step_date ASC"; $stmt = $pdo->prepare($sql); $stmt->execute($params); $report_data = $stmt->fetchAll(); break; // ========================================== // REPORT 4: Legal Officer Workload // ========================================== case 'officer_workload': $report_title = "Legal Officer Workload Summary"; $sql = "SELECT u.full_name as officer_name, u.email, COUNT(cc.id) as total_cases, SUM(CASE WHEN cc.case_status != 'Settled' THEN 1 ELSE 0 END) as active_cases, SUM(CASE WHEN cc.case_status = 'Settled' THEN 1 ELSE 0 END) as settled_cases FROM users u LEFT JOIN court_cases cc ON cc.assigned_officer_id = u.id WHERE u.role IN ('Admin', 'Staff') GROUP BY u.id ORDER BY active_cases DESC"; $stmt = $pdo->query($sql); $report_data = $stmt->fetchAll(); break; // ========================================== // REPORT 5: Group Entity Risk Exposure // ========================================== case 'company_exposure': $report_title = "Group Company Litigation Risk & Exposure"; $sql = "SELECT gc.company_name, COUNT(cc.id) as total_cases, SUM(CASE WHEN cc.case_status != 'Settled' THEN 1 ELSE 0 END) as active_cases, SUM(CASE WHEN cc.case_status = 'Settled' THEN 1 ELSE 0 END) as settled_cases FROM group_companies gc LEFT JOIN court_cases cc ON cc.group_company_id = gc.id GROUP BY gc.id ORDER BY active_cases DESC"; $stmt = $pdo->query($sql); $report_data = $stmt->fetchAll(); break; default: $report_data = []; break; } } catch (PDOException $e) { $error_msg = "Error generating report: " . $e->getMessage(); } ?>

BEN HOLDINGS - LEGAL MANAGEMENT SYSTEM

Generated on:

Legal Reporting Parameters

Generate detailed, real-time analytics and summaries across all corporate litigation records.

No records matching the specified criteria were found in the database archive.
CASE REF PARTIES GROUP ENTITY COURT ROOM STATUS NEXT HEARING RESPONSIBLE OFFICER HEARING DATE CASE REF PARTIES GROUP ENTITY COURT ROOM RESPONSIBLE OFFICER TARGET DUE DATE CASE REF PARTIES REQUIRED ACTION GROUP ENTITY RESPONSIBLE OFFICER LEGAL OFFICER EMAIL ADDRESS TOTAL MATTERS ACTIVE MATTERS SETTLED MATTERS GROUP COMPANY ENTITY TOTAL MATTERS ACTIVE MATTERS SETTLED MATTERS