= '$date_from'"; } if($date_to) { $where .= " AND o.order_date <= '$date_to'"; } if($search) { $where .= " AND (o.order_number LIKE '%$search%' OR p.first_name LIKE '%$search%' OR p.last_name LIKE '%$search%' OR p.patient_id LIKE '%$search%')"; } $orders_query = "SELECT o.*, p.first_name, p.last_name, p.patient_id as pid, p.phone, (SELECT COUNT(*) FROM test_order_details WHERE order_id = o.id) as test_count FROM test_orders o JOIN patients p ON o.patient_id = p.id $where ORDER BY o.id DESC"; $orders = mysqli_query($conn, $orders_query); // Statistics $total_orders = mysqli_fetch_assoc(mysqli_query($conn, "SELECT COUNT(*) as total FROM test_orders"))['total']; $pending_orders = mysqli_fetch_assoc(mysqli_query($conn, "SELECT COUNT(*) as total FROM test_orders WHERE status='Pending'"))['total']; $completed_orders = mysqli_fetch_assoc(mysqli_query($conn, "SELECT COUNT(*) as total FROM test_orders WHERE status='Completed'"))['total']; $today_revenue = mysqli_fetch_assoc(mysqli_query($conn, "SELECT COALESCE(SUM(net_amount), 0) as total FROM test_orders WHERE DATE(order_date) = CURDATE()"))['total']; $msg = isset($_GET['msg']) ? $_GET['msg'] : ''; ?>

Test Orders

New Order Pending Orders 0): ?>
Total Orders
Pending Orders
Completed Orders
₹
Today's Revenue
Reset
0): ?>
Order No. Patient Date Tests Amount Payment Status Actions

|
tests
Dr.
₹ 0): ?>
Discount: ₹
No Orders Found

Create New Order