Gecko [ 37julay.space ]

Name	Size	Permission	Date
.htaccess	237 B	-r-xr-xr-x	2025-09-01 07:26
error_log	8.31 MB	-rw-r--r--	2025-08-29 06:29
fetch_data_for_bio.php	611 B	-rw-r--r--	2024-10-25 15:16
fetch_pending_file_bio.php	911 B	-rw-r--r--	2024-10-31 14:22
fetch_total_order_summery.php	4.38 KB	-rw-r--r--	2025-05-29 16:41
fetch_total_succes_order.php	2.68 KB	-rw-r--r--	2024-11-15 09:54
fetch_total_summery.php	2.34 KB	-rw-r--r--	2024-11-15 13:11
fetch_user_data.php	558 B	-rw-r--r--	2024-11-15 14:50
file_order_cancel.php	666 B	-rw-r--r--	2024-10-27 18:28
file_order_completed.php	666 B	-rw-r--r--	2024-10-28 08:59
file_order_pending.php	784 B	-rw-r--r--	2024-11-15 18:22
list_of_bio_order.php	1.31 KB	-rw-r--r--	2024-11-15 17:43
list_order_cancel.php	665 B	-rw-r--r--	2024-10-26 15:38
list_order_completed.php	708 B	-rw-r--r--	2024-10-28 08:58
nid_order_pending.php	770 B	-rw-r--r--	2024-11-15 18:40
sign_order_pending.php	772 B	-rw-r--r--	2024-11-15 18:41

Rename

<?php
include '../../includes/configuration.php';
session_start();
$user = base64_decode($_SESSION["user_id"]);

// Get the start date from the request; default to today's date if not set
$start_date = isset($_GET['start_date']) ? $_GET['start_date'] : date('Y-m-d');  // Default to today's date

// List of specific order_types to show
$specificOrderTypes = ['কার্ড মেইক', 'সার্ভার কপি', 'অটো টিন'];

// Build the SQL query for the specific date filter (no date range)
$sql = "SELECT order_type, COUNT(*) AS totalOrders, SUM(price) AS totalPrice 
        FROM history_work 
        WHERE order_time >= ? 
          AND order_time < DATE_ADD(?, INTERVAL 1 DAY)
          AND order_type IN (?, ?, ?)  -- Filter by specific order types
        GROUP BY order_type";

$stmt = $conn->prepare($sql);

// Bind parameters for the selected date and the specific order types
$stmt->bind_param("sssss", $start_date, $start_date, $specificOrderTypes[0], $specificOrderTypes[1], $specificOrderTypes[2]);

$stmt->execute();
$result = $stmt->get_result();

// Fetch the order type data (counts and total price)
$orderSummary = [];
while ($row = $result->fetch_assoc()) {
    $orderSummary[] = [
        'order_type' => $row['order_type'],
        'totalOrders' => (int)$row['totalOrders'],
        'totalPrice' => (float)$row['totalPrice']
    ];
}

// Query for the overall total (no grouping by order_type)
$sqlTotal = "SELECT COUNT(*) AS totalOrders, SUM(price) AS totalPrice 
             FROM history_work 
             WHERE order_time >= ? 
               AND order_time < DATE_ADD(?, INTERVAL 1 DAY) 
               AND order_type IN (?, ?, ?)";

$stmtTotal = $conn->prepare($sqlTotal);
$stmtTotal->bind_param("sssss", $start_date, $start_date, $specificOrderTypes[0], $specificOrderTypes[1], $specificOrderTypes[2]);
$stmtTotal->execute();
$resultTotal = $stmtTotal->get_result();
$summaryTotal = $resultTotal->fetch_assoc();

// Default values if no results
$totalOrders = $summaryTotal['totalOrders'] ?? 0;
$totalPrice = $summaryTotal['totalPrice'] ?? 0;

// Return both overall total and per order_type totals
header('Content-Type: application/json');
echo json_encode([
    'totalOrders' => $totalOrders,
    'totalPrice' => $totalPrice,
    'orderSummary' => $orderSummary
]);
?>