<?php
require('../session.php');

// Nonaktifkan error HTML
error_reporting(0);
ini_set('display_errors', 0);

// Validasi parameter cuid
if (!isset($_GET['cuid']) || empty($_GET['cuid'])) {
    header('Location: ' . $urlweb . '/withdraw.php?notif=7');
    exit;
}

$id = intval($_GET['cuid']);

// Ambil data transaksi
$sql = mysqli_query($conn,"SELECT * FROM tb_transaksi WHERE cuid='$id' LIMIT 1") or die(mysqli_error($conn));
$trx = mysqli_fetch_assoc($sql);

if(!$trx){
    header('Location: ' . $urlweb . '/withdraw.php?notif=7');
    exit;
}

// jika sudah diproses
if($trx['status'] != 0){
    header('Location: ' . $urlweb . '/withdraw.php?notif=6');
    exit;
}

$userID = intval($trx['userID']);
$amount = intval($trx['total']);


// cek saldo user
$cek_balance = mysqli_query($conn,"SELECT * FROM tb_balance WHERE userID='$userID' LIMIT 1");
$balance = mysqli_fetch_assoc($cek_balance);

// jika belum ada balance buat dulu
if(mysqli_num_rows($cek_balance) == 0){

    mysqli_query($conn,"
        INSERT INTO tb_balance (userID,active,pending,transfer,payout,created_date)
        VALUES ('$userID','0','0','0','0',NOW())
    ") or die(mysqli_error($conn));

    $saldo_sekarang = 0;

} else {

    $saldo_sekarang = intval($balance['active']);

}


// cek saldo cukup
if($saldo_sekarang < $amount){

    mysqli_query($conn,"
        UPDATE tb_transaksi 
        SET status = 2,
        keterangan = 'Saldo tidak mencukupi',
        update_date = NOW()
        WHERE cuid = '$id'
    ");

    header('Location: ' . $urlweb . '/withdraw.php?notif=5');
    exit;
}


// hitung saldo baru
$saldo_baru = $saldo_sekarang - $amount;


// potong saldo user
mysqli_query($conn,"
    UPDATE tb_balance
    SET active = '$saldo_baru'
    WHERE userID = '$userID'
") or die(mysqli_error($conn));


// update transaksi withdraw
mysqli_query($conn,"
    UPDATE tb_transaksi
    SET 
    status = 1,
    saldo = '$saldo_baru',
    keterangan = 'Withdraw berhasil (Manual Admin)',
    update_date = NOW()
    WHERE cuid = '$id'
") or die(mysqli_error($conn));


header('Location: ' . $urlweb . '/withdraw.php?notif=1');
exit;

?>