query("
SELECT
d.id, d.title, d.value, d.stage, d.close_date,
c.name as contact_name, c.email as contact_email
FROM deals d
JOIN contacts c ON d.contact_id = c.id
ORDER BY d.created_at DESC
");
$all_deals = $deals_result ? $deals_result->fetchAll() : [];
// --- KPI Calculations ---
$total_value = 0;
$deals_won = 0;
$deals_lost = 0;
$deals_in_progress = 0;
$deals_by_stage = [
'Lead' => [],
'Contact Made' => [],
'Proposal' => [],
'Won' => [],
'Lost' => [],
];
foreach ($all_deals as $deal) {
$total_value += $deal['value'];
if ($deal['stage'] == 'Won') {
$deals_won++;
} elseif ($deal['stage'] == 'Lost') {
$deals_lost++;
} else {
$deals_in_progress++;
}
if (array_key_exists($deal['stage'], $deals_by_stage)) {
$deals_by_stage[$deal['stage']][] = $deal;
}
}
?>
' . htmlspecialchars($_SESSION['success_message']) . '';
unset($_SESSION['success_message']);
}
if (isset($_SESSION['error_message'])) {
echo '' . htmlspecialchars($_SESSION['error_message']) . '
';
unset($_SESSION['error_message']);
}
?>
Deal Pipeline
Add New Deal