<?php
include $_SERVER['DOCUMENT_ROOT'] . "/config.php";

$query = mysqli_query($conn, "SELECT id_order, status_order, tanggal_order 
                              FROM orders 
                              WHERE status_order IN ('Menunggu Pembayaran', 'Pembayaran Sukses') 
                              ORDER BY tanggal_order DESC");

$data = [];
while ($row = mysqli_fetch_assoc($query)) {
    $data[] = $row;
}

$response = [
    'total' => count($data),
    'id_order' => !empty($data) ? $data[0]['id_order'] : null, // Ambil ID order terbaru saja
    'data' => $data // Tetap kirim semua data kalau butuh
];

echo json_encode($response);
?>