0 ORDER BY `id` DESC LIMIT 1"); if (mysqli_num_rows($query_depo) > 0) { $data_depo = mysqli_fetch_assoc($query_depo); $promo_name = "BONUS NEW MEMBER 50+50 (TO X 15)"; // ========================================================== // PERBAIKAN PERKALIAN TO: Diubah menjadi 15 sesuai target promo // ========================================================== $perkalianto = 15; $target_turnover = ($data_depo['jumlah'] + $data_depo['bonus']) * $perkalianto; // OTOMATISASI KUNCI WAKTU: Tanggal & jam pencarian dikunci sejak deposit sukses masuk $datetime_start = $data_depo['created_at']; $from_date = date('Y-m-d', strtotime($datetime_start)); $from_hour = date('H:i', strtotime($datetime_start)); } } // BACA DATA DARI tb_play: Hitung total transaksi bermain member $total_turnover = 0; $total_win = 0; if(!empty($username_login) && isset($koneksi)) { $sql_bet = "SELECT SUM(CAST(JSON_EXTRACT(tc, '$.bet') AS DECIMAL(15,2))) as total_to, SUM(CAST(JSON_EXTRACT(tc, '$.win') AS DECIMAL(15,2))) as total_win FROM `tb_play` WHERE `user` = '" . mysqli_real_escape_string($koneksi, $username_login) . "' AND `gamestart` BETWEEN '$datetime_start' AND '$datetime_end'"; if(!empty($type)) { $sql_bet .= " AND `type` = '$type'"; } if(!empty($providers_id)) { $sql_bet .= " AND `provider` = '$providers_id'"; } $query_bet = mysqli_query($koneksi, $sql_bet); if ($query_bet) { $res_bet = mysqli_fetch_assoc($query_bet); $total_turnover = $res_bet['total_to'] ?? 0; $total_win = $res_bet['total_win'] ?? 0; } } // Hitung sisa target turnover $sisa_to = $target_turnover - $total_turnover; if ($sisa_to < 0) { $sisa_to = 0; } $p_query = isset($_GET['p']) ? $_GET['p'] : null; ?>
PENGECEKAN TURN OVER
Status Bonus Deposit Anda
Promo Teraktif :
Target Turnover : Rp
Turnover Tercapai : Rp
Status Kelayakan WD : 0): ?> 0): ?> Terkunci (Sisa TO: Rp ) ✓ TO Terpenuhi (Bisa WD) Tidak terikat target promo
Tipe
Provider
Dari Tanggal
Sampai Tanggal
Dari Jam
Sampai Jam
0): ?>
Periode Pencarian Total Turn Over Total Win
Rp Rp
Tidak ada data turnover ditemukan pada periode ini.