MAINHACK

Viewing / Editing File: sales_data.php

<?php
 include("../admin/db/db.php");
 $shopname = $_SESSION['business_name_Xw211qAAsq4'];
// Get the first day of the current week (Monday)
$startOfWeek = date("Y-m-d", strtotime("last Monday", strtotime("tomorrow"))); // Ensures Monday is always the first day
$endOfWeek = date("Y-m-d", strtotime($startOfWeek . " +6 days")); // Get Sunday

$salesData = [];

for ($i = 0; $i < 7; $i++) {  // Loop for each day of the week
    $currentDay = date("l", strtotime($startOfWeek . " +$i days")); // Get the current weekday name
    $currentDate = date("Y-m-d", strtotime($startOfWeek . " +$i days")); // Get the corresponding date

// Prepare the query
    $stmtServices = $con->prepare("
        SELECT SUM(price) as amount 
        FROM services s
        JOIN true_price sb ON s.service_id = sb.service_id
        JOIN appointments a ON sb.appointment_id = a.appointment_id
        WHERE a.canceled = '0' 
        AND a.active = 'Yes' 
        AND DAYNAME(a.created) = ? 
        AND date(a.created) BETWEEN ? AND ? 
        AND a.business_name = ?
    ");

// Execute with actual values
    $stmtServices->execute([$currentDay, $startOfWeek, $endOfWeek, $shopname]);

$row = $stmtServices->fetch();
    $saleamount = $row['amount'] ?? 0; // Use 0 if no data is found

$salesData[] = $saleamount; // Store values for Highcharts
}

// Convert array to a comma-separated string for JavaScript
echo implode(",", $salesData);
?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: sales_data.php

Server Info

System Features

User Info