MAINHACK

Viewing / Editing File: getDailyChartData.php

<?php
 include("../admin/includes/functions/functions.php");
 include("../admin/db/db.php");
header('Content-Type: application/json');

$startDate = $_GET['startDate'];
$endDate = $_GET['endDate'];
$shopname = $_GET['shopname'];

// Database connections (assuming $con and $new are set up)
$categories = [];
$salesData = [];
$discountData = [];
$commissionData = [];
$expensesData = [];

$date = new DateTime($startDate);
$end = new DateTime($endDate);
$interval = new DateInterval('P1D');
$period = new DatePeriod($date, $interval, $end->modify('+1 day'));

foreach ($period as $currentDate) {
    $currentDay = $currentDate->format('l');
    $currentDateStr = $currentDate->format('Y-m-d');
    $categories[] = $currentDay;

// Sales
    $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) = ? 
        AND a.business_name = ?
    ");
    $stmtServices->execute([$currentDay, $currentDateStr, $shopname]);
    $row = $stmtServices->fetch();
    $salesData[] = floatval($row['amount'] ?? 0);

// Discounts
    $disQuery = mysqli_query($new, "
        SELECT discount 
        FROM appointments 
        WHERE canceled = '0' 
        AND active = 'Yes' 
        AND DAYNAME(created) = '$currentDay' 
        AND date(created) = '$currentDateStr' 
        AND business_name = '$shopname'
    ");
    $discountPercent = mysqli_fetch_array($disQuery)['discount'] ?? 0;
    $discountAmount = ($discountPercent / 100) * ($row['amount'] ?? 0);
    $discountData[] = floatval($discountAmount);

// Commissions
    $comQuery = mysqli_query($new, "
        SELECT comRate 
        FROM appointments 
        WHERE canceled = '0' 
        AND active = 'Yes' 
        AND DAYNAME(created) = '$currentDay' 
        AND date(created) = '$currentDateStr' 
        AND business_name = '$shopname'
    ");
    $commissionRate = mysqli_fetch_array($comQuery)['comRate'] ?? 0;
    $afterDiscount = ($row['amount'] ?? 0) - $discountAmount;
    $commissionAmount = ($commissionRate / 100) * $afterDiscount;
    $commissionData[] = floatval($commissionAmount);

// Expenses
    $stmtExpenses = $con->prepare("
        SELECT SUM(item_amount) as amount 
        FROM expenses 
        WHERE DAYNAME(date) = ? 
        AND date(date) = ?
    ");
    $stmtExpenses->execute([$currentDay, $currentDateStr]);
    $expenseRow = $stmtExpenses->fetch();
    $expensesData[] = floatval($expenseRow['amount'] ?? 0);
}

echo json_encode([
    'categories' => $categories,
    'sales' => $salesData,
    'discounts' => $discountData,
    'commissions' => $commissionData,
    'expenses' => $expensesData
]);
?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: getDailyChartData.php

Server Info

System Features

User Info