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

// matikan error html
error_reporting(0);
ini_set('display_errors', 0);

// cek parameter
if (!isset($_GET['cuid']) || empty($_GET['cuid'])) {
    header('Location: ' . $urlweb . '/topup.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 . '/topup.php?notif=7');
    exit;
}

// jika sudah diproses
if($trx['status'] != 0){
    header('Location: ' . $urlweb . '/topup.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']);

}

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


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


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


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

?>