query("SELECT * FROM drr_sales ORDER BY id DESC")->fetchAll() : $_SESSION['drr_sales'] ?? []; $employees = $db ? $db->query("SELECT * FROM employees")->fetchAll() : $_SESSION['employees'] ?? []; $partners = $db ? $db->query("SELECT * FROM partners WHERE status='Active'")->fetchAll() : array_filter($_SESSION['partners'] ?? [], fn($p) => $p['status'] === 'Active'); $totalRev = array_sum(array_column($sales, 'revenue')); $approved = array_filter($sales, fn($s) => $s['status'] === 'Approved'); $pending = array_filter($sales, fn($s) => $s['status'] === 'Pending'); $rejected = array_filter($sales, fn($s) => $s['status'] === 'Rejected'); $approvedRev = array_sum(array_column(array_values($approved), 'revenue')); $totalUnits = array_sum(array_column($sales, 'qty')); $activeEmps = array_filter($employees, fn($e) => $e['status'] === 'Active'); include 'header.php'; ?>

Total Sales

total units

Total Revenue

AED — all sales

Approved Revenue

approved sales

Pending Sales

Awaiting approval

Active Employees

of total

Rejected Sales

This period

Partner Performance

Revenue & sales by partner

$s['partner'] === $p['name']); $pa = array_filter($ps, fn($s) => $s['status'] === 'Approved'); ?>

Partner	Sales	Units	Revenue (AED)	Appr. Rev

Agent Performance

Sales by agent

0,'rev'=>0,'appr'=>0]; $agents[$a]['cnt']++; $agents[$a]['rev'] += $s['revenue']; if ($s['status']==='Approved') $agents[$a]['appr']++; } arsort($agents); foreach ($agents as $name => $d): ?>

Agent	Sales	Revenue (AED)	Approved
			appr.

Recent DRR Sales

Latest 7 entries

Add Sale

Date	Agent	Customer	Package	Zone	Partner	Revenue	Status
						AED	'green','Pending'=>'orange','Rejected'=>'red'][$s['status']]??'gray'; ?>

Dashboard