<?php
include_once __DIR__ . "/../../../../function/connect.php";

// default saldo
$saldo_agent = 0;

// ambil agent & token
$q = mysqli_query($koneksi, "SELECT * FROM tb_integrasi LIMIT 1");
$d = mysqli_fetch_assoc($q);

$agent = $d['agent_code'] ?? '';
$token = $d['token_code'] ?? '';

if (!empty($agent) && !empty($token)) {

    $postData = json_encode([
        "method" => "money_info",
        "agent_code" => $agent,
        "agent_token" => $token
    ]);

    $ch = curl_init();

    curl_setopt_array($ch, [
        CURLOPT_URL => "https://api.nexusggr.com",
        CURLOPT_RETURNTRANSFER => true,
        CURLOPT_POST => true,
        CURLOPT_POSTFIELDS => $postData,
        CURLOPT_HTTPHEADER => ["Content-Type: application/json"],
        CURLOPT_SSL_VERIFYPEER => false,

        // 🔥 WAJIB (BIAR GA MUTER)
        CURLOPT_TIMEOUT => 3,
        CURLOPT_CONNECTTIMEOUT => 3
    ]);

    $response = curl_exec($ch);

    // kalau error → jangan bikin dashboard hang
    if (!curl_errno($ch) && $response) {
        $res = json_decode($response, true);

        if (isset($res['user']['balance'])) {
            $saldo_agent = (float)$res['user']['balance'];
        } elseif (isset($res['balance'])) {
            $saldo_agent = (float)$res['balance'];
        }
    }

    curl_close($ch);
}
?>
<div class="page-breadcrumb">
    <div class="row">
        <div class="col-5 align-self-center">
            <h4 class="page-title">Dashboard Page</h4>
        </div>
        <div class="col-7 align-self-center">
            <div class="d-flex align-items-center justify-content-end">
                <nav aria-label="breadcrumb">
                    <ol class="breadcrumb">
                        <li class="breadcrumb-item">
                            <a href="#">Home</a>
                        </li>
                        <li class="breadcrumb-item active" aria-current="page">Dashboard</li>
                    </ol>
                </nav>
            </div>
        </div>
    </div>
</div>

<div class="container-fluid">
    <div class="card-group">
        <div class="card">
            <div class="card-body">
                <div class="row">
                    <div class="col-md-12">
                        <div class="d-flex no-block align-items-center">
                            <div>
                                <i class="mdi mdi-emoticon font-20 text-muted"></i>
                                <p class="font-16 m-b-5">Jumlah Member</p>
                            </div>
                            <div class="ml-auto">
                                <?php 
                                $query = mysqli_query($koneksi, "SELECT * FROM tb_user WHERE status = 'active' ");
                                $hitung_user = mysqli_num_rows($query);
                                ?>
                                <h1 class="font-light text-right"><?php echo number_format($hitung_user); ?></h1>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div> 
        <div class="card">

            <div class="card-body">

                <div class="row">

                    <div class="col-md-12">

                        <div class="d-flex no-block align-items-center">

                            <div>

                                <i class="mdi mdi-poll font-20 text-muted"></i>

                                <p class="font-16 m-b-5">Coin Agent</p>

                            </div>

                            <div class="ml-auto"> 
                            <h4 class="font-20 m-b-0 text-success">
    Rp. <span id="saldoAgent">Loading...</span>
</h4>
							</div>



                        </div>

                    </div>

                </div>

            </div>

        </div> 
        
        <!-- Column -->
        <!-- Column -->
        <div class="card">
            <div class="card-body">
                <div class="row">
                    <div class="col-md-12">
                        <div class="d-flex no-block align-items-center">
                            <div>
                                <i class="mdi mdi-image font-20  text-muted"></i>
                                <p class="font-16 m-b-5">Total Bonus</p>
                                <?php 
                                $query1 = mysqli_query($koneksi, "SELECT * FROM tb_bonus");
                                $bonus = mysqli_num_rows($query1);
                                ?>
                            </div>
                            <div class="ml-auto">
                                <h1 class="font-light text-right"><?php echo number_format($bonus); ?></h1>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <!-- Column -->
        <!-- Column -->
        <div class="card">
            <div class="card-body">
                <div class="row">
                    <div class="col-md-12">
                        <div class="d-flex no-block align-items-center">
                            <div>
                                <i class="mdi mdi-currency-eur font-20 text-muted"></i>
                                <p class="font-16 m-b-5">Total Rekening</p>
                            </div>
                            <div class="ml-auto">
                                <?php 
                                $query2 = mysqli_query($koneksi, "SELECT * FROM tb_bank WHERE level = 'admin' ");
                                $rek = mysqli_num_rows($query2);
                                ?>
                                <h1 class="font-light text-right"><?php echo number_format($rek); ?></h1>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <!-- Column -->
        <!-- Column -->
        <div class="card">
            <div class="card-body">
                <div class="row">
                    <div class="col-md-12">
                        <div class="d-flex no-block align-items-center">
                            <div>
                                <i class="mdi mdi-poll font-20 text-muted"></i>
                                <p class="font-16 m-b-5">Total Admin</p>
                            </div>
                            <div class="ml-auto">
                                <?php 
                                $query3 = mysqli_query($koneksi, "SELECT * FROM tb_admin");
                                $ad = mysqli_num_rows($query3);
                                ?>
                                <h1 class="font-light text-right"><?php echo number_format($ad); ?></h1>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <div class="col-lg-12 col-md-12">
        <div class="card">
            <div class="card-body bg-light">
                <div class="row align-items-center">
                    <div class="col-xs-12 col-md-6">
                        <h3 class="m-b-0 font-light">Data Deposit Bulan Ini</h3>
                        <span class="font-14 text-muted">Total Deposit</span>
                    </div>
                    <?php 
// Dapatkan bulan dan tahun sekarang
                    $bulan_sekarang = date("m");
                    $tahun_sekarang = date("Y");

// Query untuk mengambil data transaksi sesuai bulan sekarang
                    $sql = mysqli_query($koneksi, "SELECT * FROM tb_transaksi WHERE MONTH(tanggal) = '$bulan_sekarang' AND YEAR(tanggal) = '$tahun_sekarang' AND transaksi = 'Top Up' AND status = 'Sukses' ");
                    $result = mysqli_num_rows($sql);

                    if ($result > 0) {
    // Output data transaksi
                        while ($row = mysqli_fetch_array($sql)) {
                            $total_pendapatan += $row["total"];
                        }
                    }
                    ?>
                    <div class="col-xs-12 col-md-6 align-self-center display-6 text-info text-right">Rp. <?php echo number_format($total_pendapatan); ?></div>
                </div>
            </div>

            <div class="table-responsive">
                <table id="zero_config" class="table table-striped table-bordered ">
                    <thead>
                        <tr>
                            <th class="border-top-0">Tanggal</th>
                            <th class="border-top-0">STATUS</th>
                            <th class="border-top-0">Total</th>
                            <th class="border-top-0">Pembayaran Ke</th>
                        </tr>
                    </thead>
                    <?php 
// Dapatkan bulan dan tahun sekarang
                    $bulan_sekarang = date("m");
                    $tahun_sekarang = date("Y");

// Query untuk mengambil data transaksi sesuai bulan sekarang
                    $sql = mysqli_query($koneksi, "SELECT * FROM tb_transaksi WHERE MONTH(tanggal) = '$bulan_sekarang' AND YEAR(tanggal) = '$tahun_sekarang' AND transaksi = 'Top Up' AND status = 'Sukses' ");
                    $result = mysqli_num_rows($sql);

                    if ($result > 0) {
    // Output data transaksi
                        while ($row = mysqli_fetch_array($sql)) {
                            echo "<tr>";
                            echo "<td class='txt-oflo'>" . $row["tanggal"] . "</td>";
                            echo "<td><span class='label label-success label-rounded'>" . $row["status"] . "</span></td>";
                            echo "<td class='txt-oflo'>Rp. " . number_format($row["total"]) . "</td>";
                            echo "<td><span class='font-medium'>" . $row["metode"] . "</span></td>";
                            echo "</tr>";

                            $total_pendapatan += $row["total"];
                        }
                    } else {
                        echo "Tidak ada data transaksi untuk bulan ini.";
                    }
                    ?>

                </table>
            </div>
        </div>
    </div>
</div> 
<script>
function loadSaldo(){
    fetch('/get_saldo_agent.php')
    .then(res => res.text())
    .then(data => {
        document.getElementById('saldoAgent').innerHTML = data;
    })
    .catch(() => {
        document.getElementById('saldoAgent').innerHTML = '0';
    });
}

loadSaldo();
setInterval(loadSaldo, 5000); // auto refresh tiap 5 detik
</script>