Lead Dashboard

1, 'name' => 'Alice Johnson', 'company' => 'Innovate Corp', 'status' => 'New', 'value' => 5000, 'tag' => 'prospect'], ['id' => 2, 'name' => 'Bob Williams', 'company' => 'Solutions Inc.', 'status' => 'New', 'value' => 3000, 'tag' => 'prospect'], ['id' => 3, 'name' => 'Charlie Brown', 'company' => 'Data Systems', 'status' => 'Contacted', 'value' => 7500, 'tag' => 'deal'], ['id' => 4, 'name' => 'Diana Miller', 'company' => 'Creative Minds', 'status' => 'Qualified', 'value' => 12000, 'tag' => 'deal'], ['id' => 5, 'name' => 'Ethan Davis', 'company' => 'Tech Forward', 'status' => 'New', 'value' => 2500, 'tag' => 'prospect'], ['id' => 6, 'name' => 'Fiona Garcia', 'company' => 'Global Connect', 'status' => 'Contacted', 'value' => 6000, 'tag' => 'deal'], ]; $pdo = db(); // Check if leads table is empty $stmt = $pdo->query("SELECT COUNT(*) FROM leads"); $lead_count = $stmt->fetchColumn(); if ($lead_count == 0) { $stmt = $pdo->prepare("INSERT INTO leads (name, company, status, value, tag) VALUES (?, ?, ?, ?, ?)"); foreach ($sample_leads as $lead) { $stmt->execute([$lead['name'], $lead['company'], $lead['status'], $lead['value'], $lead['tag']]); } } $stmt = $pdo->query("SELECT * FROM leads"); $leads = $stmt->fetchAll(); $columns = ['New', 'Contacted', 'Qualified', 'Closed']; function getLeadsByStatus($leads, $status) { $filtered_leads = []; foreach ($leads as $lead) { if ($lead['status'] === $status) { $filtered_leads[] = $lead; } } return $filtered_leads; } ?> Lead Dashboard