<?php 
session_start();
include 'template/header.php'; 
require_once 'db/koneksi.php';

$username = isset($_SESSION['username']) ? $_SESSION['username'] : '';

// --- KODE VITAL: WAJIB ADA AGAR PROSES POTONG SALDO BETTING BERFUNGSI ---
$total_saldo_tampil = 0;
if (!empty($username)) {
    $query_saldo = mysqli_query($koneksi, "SELECT saldo, saldo_nexus FROM tb_user WHERE username = '$username'");
    if ($query_saldo && mysqli_num_rows($query_saldo) > 0) {
        $data_saldo = mysqli_fetch_assoc($query_saldo);
        $total_saldo_tampil = (int)$data_saldo['saldo'] + (int)$data_saldo['saldo_nexus'];
        
        // Menyinkronkan session balance web & NexusGGR agar pemotongan saldo taruhan valid
        $_SESSION['balance'] = $total_saldo_tampil; 
    }
}
?>

<div style="margin-top: 50px; font-family: sans-serif;">
    <div style="padding: 21px 0; background-color:var(--secondary-color);">
        
        <div style="width: 100%; margin: 20px auto 20px auto; overflow: hidden;">
    <div style="font-family: Teko-SemiBold; text-align: center; font-size: 24px; color: transparent !important; -webkit-background-clip: text; background-image: radial-gradient(ellipse farthest-corner at right bottom, #FEDB37 0%, #FDB931 8%, #9f7928 30%, #8A6E2F 40%, transparent 80%), radial-gradient(ellipse farthest-corner at left top, #e99c05 0%, #f4ae00 8%, #f8bf33 25%, #f8ce19 62.5%, #ffdc02 100%); padding: 5px 0;">
        HISTORY BETTINGAN
        <hr style="background: linear-gradient(#000 0 0) padding-box, linear-gradient(to left, #FEDB37, #8A6E2F) border-box; border-top: 2px solid transparent; margin: 0 auto; width: 70px;">
    </div>

        <div style="width: 90%; margin: 0 auto 20px auto; display: block; overflow: auto;">
            <table width="100%" style="font-size: 11px; border-collapse: collapse; text-align: center; color: #fff; background-color: #1a1a1a;">
                <thead>
                    <tr style="background-color: #494848; color: #fff; font-weight: bold; height: 40px;">
                        <td style="padding: 10px;">Tanggal</td>
                        <td style="padding: 10px;">Pasaran</td>
                        <td style="padding: 10px;">Mode</td>
                        <td style="padding: 10px;">Total Bayar</td>
                        <td style="padding: 10px;">Detail</td>
                    </tr>
                </thead>
                <tbody>
                    <?php
                    if (!empty($username)) {
                        // Mengambil data dengan GROUP BY agar riwayat terkelompok rapi per transaksi pasaran
                        $sql = "SELECT tanggal, pasaran, mode_taruhan, SUM(total_bayar) as total_tagihan 
                                FROM tb_taruhan_togel 
                                WHERE username = '$username' 
                                GROUP BY tanggal, pasaran, mode_taruhan 
                                ORDER BY tanggal DESC LIMIT 50";
                        
                        $result = mysqli_query($koneksi, $sql);

                        if ($result && mysqli_num_rows($result) > 0) {
                            while ($row = mysqli_fetch_assoc($result)) {
                                
                                // Diarahkan ke file detail.php yang sudah kita perbaiki tampilannya
                                $link_detail = "detail_bet.php?tgl=".urlencode($row['tanggal'])."&psn=".urlencode($row['pasaran']);

                                echo "<tr style='border-bottom: 1px solid #333; height: 50px;'>";
// PERBAIKAN DI SINI: Tanggal di atas, waktu di bawah menggunakan <br>
echo "<td>" . date('d-m-Y', strtotime($row['tanggal'])) . "<br><span style='color: #888; font-size: 11px;'>" . date('H:i:s', strtotime($row['tanggal'])) . "</span></td>";

echo "<td style='font-weight:bold;'>".strtoupper($row['pasaran'])."</td>";
echo "<td><span style='background:#333; padding:3px 8px; border-radius:4px;'>".$row['mode_taruhan']."</span></td>";
echo "<td style='color:#2ecc71;'>Rp ".number_format($row['total_tagihan'])."</td>";

// Render Kolom Detail (Icon Mata)
echo "<td>
        <a href='$link_detail' style='color: #FEDB37; font-size: 18px; text-decoration: none;'>
            <i class='fas fa-eye'></i>
        </a>
      </td>";
echo "</tr>";
                            }
                        } else {
                            // Colspan disesuaikan menjadi 5 karena kolom status sudah dihapus
                            echo "<tr><td colspan='5' style='padding: 30px; color: #888;'>Belum ada riwayat taruhan.</td></tr>";
                        }
                    }
                    ?>
                </tbody>
            </table>
        </div>
    </div>
</div>

<?php include 'template/footer.php'; ?>