tripz-llc/backend/Admin/AdminRide/getRidesPerMonth.php

<?php
require_once __DIR__ . '/../../connect.php';

$currentYear = date('Y');
$currentMonth = date('m');

// SQL to get daily ride counts
$sql = "
SELECT 
    YEAR(date) AS year,
    MONTH(date) AS month,
    DAY(date) AS day,
    COUNT(*) AS rides_count
FROM 
    ride
GROUP BY 
    YEAR(date), 
    MONTH(date), 
    DAY(date)
ORDER BY 
    YEAR(date), 
    MONTH(date), 
    DAY(date)
";
$stmt = $con->prepare($sql);
$stmt->execute();
$dailyRides = $stmt->fetchAll(PDO::FETCH_ASSOC);

// SQL to get current month's total ride count
$sqlMonth = "
SELECT COUNT(*) AS current_month_rides_count 
FROM ride 
WHERE MONTH(date) = :currentMonth AND YEAR(date) = :currentYear
";
$stmtMonth = $con->prepare($sqlMonth);
$stmtMonth->bindParam(':currentMonth', $currentMonth);
$stmtMonth->bindParam(':currentYear', $currentYear);
$stmtMonth->execute();
$monthRides = $stmtMonth->fetch(PDO::FETCH_ASSOC);

// Append current month total to each row (if needed)
foreach ($dailyRides as &$row) {
    $row['current_month_rides_count'] = $monthRides['current_month_rides_count'];
}

// Return result
if ($dailyRides) {
    jsonSuccess($dailyRides);
} else {
    jsonError("No records found");
}
?>