connect_error) {
die("Connection failed: " . $conn->connect_error);
}
// Get current month's start and end dates
$current_month_start = date('Y-m-01');
$current_month_end = date('Y-m-t');
// Get filter values from request or set defaults
$start_date = isset($_GET['start_date']) ? $_GET['start_date'] : $current_month_start;
$end_date = isset($_GET['end_date']) ? $_GET['end_date'] : $current_month_end;
$source_filter = isset($_GET['sourcee']) ? $_GET['sourcee'] : '';
// Build query with filters
$sql = "SELECT DATE_FORMAT(created_at,'%Y-%m-%d') as lead_date, sourcee, COUNT(id) as lead_count
FROM leads2
WHERE message = 'Added Successfully'
AND DATE(created_at) BETWEEN '$start_date' AND '$end_date'";
if (!empty($source_filter)) {
$sql .= " AND sourcee = '$source_filter'";
}
$sql .= " GROUP BY DATE_FORMAT(created_at,'%Y-%m-%d'), sourcee WITH ROLLUP";
$result = $conn->query($sql);
if (!$result) {
die("Query failed: " . $conn->error);
}
$leads_data = [];
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
$leads_data[] = $row;
}
}
$conn->close();
?>
Leads Dashboard
Leads Dashboard