<?php
include_once __DIR__ . "/../../../../main/API/functions.php";

if (isset($_GET['id'])) {
    $id = mysqli_real_escape_string($koneksi, $_GET['id']);
    $tanggal = date('Y-m-d H:i:s');
    
    // 1. Ambil data transaksi
    $query_trans = mysqli_query($koneksi, "SELECT * FROM tb_transaksi WHERE id = '$id'");
    $data = mysqli_fetch_array($query_trans);

    if ($data) {
        $val_user = $data['id_user'];
        $total = (float)$data['total'];

        // 2. Cari data User
        $query_user = mysqli_query($koneksi, "SELECT * FROM tb_user WHERE id = '$val_user' OR username = '$val_user' LIMIT 1");
        $u = mysqli_fetch_array($query_user);

        if ($u) {
            // PENTING: samakan dengan tb_saldo (username)
            $username_api = $u['username'];
            $id_user_fix = $username_api;

            if (!isset($SGX)) {
                die("<script>alert('Error: Object API SGX tidak ditemukan!'); window.history.back();</script>");
            }

            // Deposit ke API
            $resAPI = $SGX->deposit($username_api, $total);

            if (isset($resAPI['status']) && ($resAPI['status'] == 1 || $resAPI['status'] == 'success')) {
                
                // CEK SALDO USER
                $cek_s = mysqli_query($koneksi, "SELECT * FROM tb_saldo WHERE id_user = '$id_user_fix'");
                $s = mysqli_fetch_array($cek_s);

                if ($s) {
                    $saldo_sekarang = (float)trim($s['active']);
                    $pending_sekarang = (float)trim($s['pending']);
                    
                    $saldo_baru = $saldo_sekarang + $total;
                    $pending_baru = $pending_sekarang - $total;
                    if ($pending_baru < 0) $pending_baru = 0;

                    mysqli_query($koneksi, "UPDATE tb_saldo SET active = '$saldo_baru', pending = '$pending_baru' WHERE id_user = '$id_user_fix'");
                } else {
                    // kalau belum ada di tb_saldo → insert baru
                    mysqli_query($koneksi, "INSERT INTO tb_saldo (id_user, active, pending, transfer, payout) 
                    VALUES ('$id_user_fix', '$total', '0', '0', '0')");
                }

                // Update transaksi
                mysqli_query($koneksi, "UPDATE tb_transaksi SET status = 'Sukses' WHERE id = '$id'");

                // Referral
                $cek_reff = mysqli_query($koneksi, "SELECT * FROM tb_refferal WHERE id_user = '$id_user_fix'");
                if ($cek_reff && mysqli_num_rows($cek_reff) > 0) {
                    $liat = mysqli_fetch_array($cek_reff);
                    $reff = $liat['user_refferal'];
                    $persen = $total * 0.001;

                    mysqli_query($koneksi, "UPDATE tb_saldo SET active = active + $persen WHERE id_user = '$reff'");
                }

                echo "<script>alert('Konfirmasi Berhasil!'); window.location='?page=permintaan_deposit';</script>";
                exit;

            } else {
                $err = isset($resAPI['msg']) ? $resAPI['msg'] : 'Timeout atau API Down';
                echo "<script>alert('Gagal API: $err'); window.location='?page=permintaan_deposit';</script>";
                exit;
            }

        } else {
            echo "<script>alert('User tidak ditemukan!'); window.location='?page=permintaan_deposit';</script>";
            exit;
        }
    }
}
?>