<?php
include_once '../db/koneksi.php';
header('Content-Type: application/json');

$id_downline = $_GET['id'] ?? 0;

// 1. Ambil data downline
$q = mysqli_query($koneksi, "SELECT username, referral FROM tb_user WHERE id = '$id_downline'");
$data = mysqli_fetch_assoc($q);

if (!$data) {
    echo json_encode(["status" => "error", "message" => "Downline tidak ditemukan."]);
    exit;
}

$upline = $data['referral'];
$nama_downline = $data['username'];

// 2. Ambil deposit pertama
$depo_q = mysqli_query($koneksi, "SELECT jumlah FROM tb_deposit WHERE username = '$nama_downline' AND status = 'Sukses' ORDER BY id ASC LIMIT 1");
$depo_data = mysqli_fetch_assoc($depo_q);
$jumlah_depo = $depo_data['jumlah'] ?? 0;

if ($jumlah_depo <= 0) {
    echo json_encode(["status" => "error", "message" => "Downline belum memiliki deposit sukses."]);
    exit;
}

// Hitung 1% dan bulatkan ke angka bulat (karena kolom saldo Anda tipe INT)
$bonus = (int)($jumlah_depo * 0.01);

// 3. Eksekusi Update
mysqli_begin_transaction($koneksi);
try {
    // Tambah saldo upline
    mysqli_query($koneksi, "UPDATE tb_user SET saldo = saldo + $bonus WHERE username = '$upline'");
    
    // Update status klaim downline
    mysqli_query($koneksi, "UPDATE tb_user SET claimed = 1 WHERE id = '$id_downline'");

    mysqli_commit($koneksi);
    echo json_encode(["status" => "success", "message" => "Bonus Rp$bonus berhasil dikirim ke $upline"]);
} catch (Exception $e) {
    mysqli_rollback($koneksi);
    echo json_encode(["status" => "error", "message" => "Terjadi kesalahan sistem."]);
}
?>