<?php
include('session.php');
date_default_timezone_set('Asia/Jakarta');

$todayStart = date('Y-m-d 00:00:00');
$todayEnd   = date('Y-m-d 23:59:59');

// ====== CEK DEPOSIT BARU ======
$getDeposit = mysqli_query($conn,"
    SELECT * FROM tb_transaksi 
    WHERE date BETWEEN '$todayStart' AND '$todayEnd'
    AND jenis = '1' 
    AND status = 0 
    ORDER BY cuid DESC 
    LIMIT 1
") or die(mysqli_error($conn));

if (mysqli_num_rows($getDeposit) > 0) {
    $gd = mysqli_fetch_assoc($getDeposit);
    $userID = $gd['userID'];
    $getUser = mysqli_query($conn,"SELECT * FROM tb_user WHERE cuid = '$userID'") or die(mysqli_error($conn));
    $gu = mysqli_fetch_assoc($getUser);

    echo '
    <div class="alert alert-dismissible text-dark" role="alert" id="notifDeposit" 
     style="background-color:#fff3cd; border:1px solid #ffeeba;">
        ðŸ”” <b>Permintaan Deposit Baru!</b><br>
        Dari: <b>'.$gu['user'].'</b><br>
        Jumlah: Rp '.number_format($gd['total']).'<br>
        <button type="button" class="btn btn-sm btn-primary mt-2 bukaDeposit" data-id="'.$gd['cuid'].'">Buka</button>
        <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close" onclick="stopSound()"></button>
    </div>
    <script>playSound();</script>
    ';
}

// ====== CEK WITHDRAW BARU ======
$getWithdraw = mysqli_query($conn,"
    SELECT * FROM tb_transaksi 
    WHERE date BETWEEN '$todayStart' AND '$todayEnd'
    AND jenis = '2' 
    AND status = 0 
    ORDER BY cuid DESC 
    LIMIT 1
") or die(mysqli_error($conn));

if (mysqli_num_rows($getWithdraw) > 0) {
    $gw = mysqli_fetch_assoc($getWithdraw);
    $userID = $gw['userID'];
    $getUser = mysqli_query($conn,"SELECT * FROM tb_user WHERE cuid = '$userID'") or die(mysqli_error($conn));
    $gu = mysqli_fetch_assoc($getUser);

    echo '
        <div class="alert alert-dismissible text-dark" role="alert" id="notifWithdraw" 
     style="background-color:#fff3cd; border:1px solid #ffeeba;">
        🔔 <b>Permintaan Penarikan Baru!</b><br>
        Dari: <b>'.$gu['user'].'</b><br>
        Jumlah: Rp '.number_format($gw['total']).'<br>
        <button type="button" class="btn btn-sm btn-danger mt-2 bukaWithdraw" data-id="'.$gw['cuid'].'">Buka</button>
        <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close" onclick="stopSound()"></button>
    </div>
    <script>playSound();</script>
    ';
}
?>
