<?php require_once "../app/headl.php" ?>

<?php
	if (isset($_SESSION['user'])) {
		$user = mysqli_query($conn, "SELECT * FROM `tb_user` WHERE user = '" . $_SESSION['user'] . "'") or die(mysqli_error());
		$u = mysqli_fetch_array($user);
		$users = $u['user'];
		$userid = $u['user'];
		$id_user = $u['cuid'];
		$userID = $u['cuid'];
		// Ambil total komisi rabat user
$sql_rabat = mysqli_query($conn, "
    SELECT SUM(saldo) as totalRabat 
    FROM tb_transaksi 
    WHERE userID = '$userID' AND jenis = 4 AND status = 1
") or die(mysqli_error($conn));

$rabat = mysqli_fetch_array($sql_rabat);
$totalRabat = $rabat['totalRabat'] ? $rabat['totalRabat'] : 0;

		$token_id = isset($u['token_id']) ? $u['token_id'] : false;
		$level = isset($u['level']) ? $u['level'] : false;
		
		$sql_balance = mysqli_query($conn, "SELECT * FROM `tb_balance` WHERE userID = '$userID'") or die(mysqli_error());
		$sb = mysqli_fetch_array($sql_balance);
	
	if (isset($_GET['home'])) {
    include('lottery_home.php');
    exit;
    }

    if (isset($_GET['pid'])) {
    include('lottery_detail.php');
    exit;
    }
	?>
	
	<body>
		
		<?php require_once "../app/menul.php" ?>
		
        <div class="clearfix"></div>
        <style>
            body {
			font-size: 12px;
			color: #FFFFFF;
			background-color: #1b1b1b;
            }
			
            .btn {
			margin-bottom: 2px;
			font-size: 12px;
			font-weight: bold;
            }
			
            .container {
			width: 100%;
            }
			
            .glyphicon {
			margin-right: 5px;
            }
			
            .no-gutter>[class*='col-'] {
			padding-right: 5px;
			padding-left: 5px;
			padding-top: 5px;
			padding-bottom: 5px;
            }
			
            .tengahBaris {
			vertical-align: middle;
            }
			
            table {
			padding-bottom: 0px;
            }
			
            .panel {
			box-shadow: 0px 3px 5px 0px rgba(0, 0, 0, 0.3);
            }
			
            input[readonly] {
			background-color: #fff0c4 !important;
			/* any other styles */
            }
			
			
            .panel-danger>.panel-heading,
            .panel-warning>.panel-heading,
            .btn-warning {
			color: #000000;
			font-weight: bold;
			border-color: rgba(0, 0, 0, 0.6);
			background-image: -webkit-linear-gradient(#eee791, #9d8b3d 60%, #9f8435);
			background-image: -o-linear-gradient(#eee791, #9d8b3d 60%, #9f8435);
			background-image: -webkit-gradient(linear, left top, left bottom, from(#eee791), color-stop(60%, #9d8b3d), to(#9f8435));
			background-image: linear-gradient(#eee791, #9d8b3d 60%, #9f8435);
			background-repeat: no-repeat;
			filter: progid:DXImageTransform.Microsoft.gradient(startColorstr='#ff484e55', endColorstr='#ff313539', GradientType=0);
			-webkit-filter: none;
			filter: none
            }
			
            .btn-warning:hover {
			color: #000000;
			font-weight: bold;
			border-color: rgba(0, 0, 0, 0.6);
			background-image: -webkit-linear-gradient(#d7a001, #d7a001 60%, #d7a001);
			background-image: -o-linear-gradient(#d7a001, #d7a001 60%, #d7a001);
			background-image: -webkit-gradient(linear, left top, left bottom, from(#d7a001), color-stop(60%, #d7a001), to(#d7a001));
			background-image: linear-gradient(#d7a001, #d7a001 60%, #d7a001);
			background-repeat: no-repeat;
            }
			
            .login {
			color: #000000;
			font-weight: bold;
			border-color: rgba(0, 0, 0, 0.6);
			background-image: -webkit-linear-gradient(#eee791, #9d8b3d 60%, #9f8435);
			background-image: -o-linear-gradient(#eee791, #9d8b3d 60%, #9f8435);
			background-image: -webkit-gradient(linear, left top, left bottom, from(#eee791), color-stop(60%, #9d8b3d), to(#9f8435));
			background-image: linear-gradient(#eee791, #9d8b3d 60%, #9f8435);
			background-repeat: no-repeat;
			filter: progid:DXImageTransform.Microsoft.gradient(startColorstr='#ff484e55', endColorstr='#ff313539', GradientType=0);
			-webkit-filter: none;
			filter: none
            }
			
			
            .panel-default>.panel-heading {
			color: #ffffff;
			border-color: rgba(0, 0, 0, 0.6)
            }
			
            .navbar-default {
			background-color: #000000;
			border-color: #2b2e32
            }
			
            .well {
			background: #111 !important;
            }
			
			
            input[readonly] {
			background-color: #eeeecd !important;
			/* any other styles */
            }
			
            textarea[readonly] {
			background-color: #eeeecd !important;
			/* any other styles */
            }
			
            .form-control {
			height: 40px !important;
			border-radius: 3px !important;
            }
			
            .form-control#validasi {
			height: 50px !important;
			border-radius: 3px !important;
            }
			
            .form-control-login {
			height: 40px !important;
			border-radius: 3px !important;
            }
			
            .form-control#reg_username,
            #reg_pass,
            #reg_passcon,
            #reg_email,
            #reg_telpon,
            #reg_bank,
            #reg_rek,
            #reg_nama,
            #reg_ref,
            #reg_dari,
            #reg_lain {
			height: 45px !important;
			border-radius: 3px !important;
            }
			
			
            textarea {
			height: 100px !important;
			width: 100%;
			padding: 10px;
			border-radius: 5px !important;
            }
			
            td {
			padding-top: 5px !important;
			padding-bottom: 5px !important;
            }
			
            .borderbottom {
			border-bottom: 2px solid #c2c2c2;
			border-top: 2px solid #c2c2c2;
            }
			
            @media (max-width: 1200px) {
			.navbar {
			background: #32363b;
			}
			
			.navbar-header {
			float: none;
			}
			
			.navbar-left,
			.navbar-right {
			float: none !important;
			}
			
			.navbar-toggle {
			display: block;
			}
			
			.navbar-collapse {
			border-top: 1px solid transparent;
			box-shadow: inset 0 1px 0 rgba(255, 255, 255, 0.1);
			}
			
			.navbar-fixed-top {
			top: 0;
			border-width: 0 0 1px;
			}
			
			.navbar-collapse.collapse {
			display: none !important;
			}
			
			.navbar-nav {
			float: none !important;
			margin-top: 7.5px;
			}
			
			.navbar-nav>li {
			float: none;
			}
			
			.navbar-nav>li>a {
			padding-top: 10px;
			padding-bottom: 10px;
			}
			
			.collapse.in {
			display: block !important;
			}
			
			
			@media (min-width: 320px) {
			
			/* iPhone SE,6/7/8/X, Galaxy S5,  */
			.fadein {
			position: relative;
			width: 100%;
			height: 160px;
			}
			
			.fadein img {
			position: absolute;
			left: 0;
			top: 0;
			}
			
			}
			
			@media (min-width: 400px) {
			
			/* iPhone 6/7/8 Plus, Pixel 2,Pixel 2 XL,  */
			.fadein {
			position: relative;
			width: 100%;
			height: 200px;
			}
			
			.fadein img {
			position: absolute;
			left: 0;
			top: 0;
			}
			
			
			}
			
			@media (min-width: 700px) {
			
			/* iPad  */
			.fadein {
			position: relative;
			width: 100%;
			height: 380px;
			}
			
			.fadein img {
			position: absolute;
			left: 0;
			top: 0;
			}
			
			}
			
			@media (min-width: 1000px) {
			.fadein {
			position: relative;
			width: 100%;
			height: 480px;
			}
			
			.fadein img {
			position: absolute;
			left: 0;
			top: 0;
			}
			
			}
			
            }
			
            textarea {
			height: 100px !important;
			width: 100%;
			padding: 10px;
			border-radius: 5px !important;
            }
			
            .form-control {
			height: 25px !important;
			border-radius: 3px !important;
            }
			
            td {
			padding-top: 5px !important;
			padding-bottom: 5px !important;
			padding-left: 3px !important;
			padding-right: 3px !important;
            }
			
            .grabgtab {
			font-weight: bold;
			border-color: rgba(0, 0, 0, 0.6);
			background-image: -webkit-linear-gradient(#1b1b1b, #1b1b1b 60%, #10100e);
			background-image: -o-linear-gradient(#1b1b1b, #1b1b1b 60%, #10100e);
			background-image: -webkit-gradient(linear, left top, left bottom, from(#1b1b1b), color-stop(60%, #1b1b1b), to(#10100e));
			background-image: linear-gradient(#1b1b1b, #1b1b1b 60%, #10100e);
			background-repeat: no-repeat;
			filter: progid:DXImageTransform.Microsoft.gradient(startColorstr='#1b1b1b', endColorstr='#10100e', GradientType=0);
			-webkit-filter: none;
			filter: none
            }
			
            .grabgtabbottom {
			font-weight: bold;
			border-color: rgba(0, 0, 0, 0.6);
			background-image: -webkit-linear-gradient(#3e444c, #1b1b1b 60%, #1b1b1b);
			background-image: -o-linear-gradient(#3e444c, #1b1b1b 60%, #1b1b1b);
			background-image: -webkit-gradient(linear, left top, left bottom, from(#3e444c), color-stop(60%, #1b1b1b), to(#1b1b1b));
			background-image: linear-gradient(#3e444c, #1b1b1b 60%, #1b1b1b);
			background-repeat: no-repeat;
			filter: progid:DXImageTransform.Microsoft.gradient(startColorstr='#1b1b1b', endColorstr='#1b1b1b', GradientType=0);
			-webkit-filter: none;
			filter: none
            }
			
            .abel {
			font-family: 'Abel';
            }
		</style>
        <!-- MAIN TAB -->
		
        <?php require_once "../app/game.php" ?>
		
        <div style="height:10px; background-color:#FFF" class="grabgtabbottom"></div>
		
		
        <div class="tab-content">
			
            <div id="dashboard_wrap" class="tab-pane fade in active">
                <div class="row" style="margin-bottom:0px">
                    <div class="col-xs-3" style="padding-right:2px">
                        <a class="btn btn-default btn-block active" href="index.php"><span class="glyphicon glyphicon-calendar"></span>Statement</a>
					</div>
                    <div class="col-xs-3" style="padding-right:1px; padding-left: 1px;">
                        <a class="btn btn-default btn-block " href="history.php"><span class="glyphicon glyphicon-calendar"></span>History</a>
					</div>
                    <div class="col-xs-3" style="padding-right:1px; padding-left: 2px;">
                        <a class="btn btn-default btn-block " href="memo.php"><span class="glyphicon glyphicon-edit"></span>Memo<span class="badge badgeTotal" style="margin-left:5px; margin-right:10px; font-size:9px; font-weight:bold"></span></a>
					</div>
                    <div class="col-xs-3" style="padding-left:2px">
                        <a class="btn btn-default btn-block " href="refferal.php"><span class="glyphicon glyphicon-user"></span>Referal</a>
					</div>
				</div>
                <div class="row" style="margin-bottom:10px">
                    <div class="col-xs-3" style="padding-right:2px">
                        <a class="btn btn-default btn-block " href="deposit.php"><span class="glyphicon glyphicon-import"></span>Deposit</a>
					</div>
                    <div class="col-xs-3" style="padding-left:1px; padding-right:1px;">
                        <a class="btn btn-default btn-block " href="withdraw.php"><span class="glyphicon glyphicon-export"></span>Withdraw</a>
					</div>
                    <div class="col-xs-3" style="padding-left:2px; padding-right:1px">
                        <a class="btn btn-default btn-block " href="rekening.php"><span class="glyphicon glyphicon-briefcase"></span>Rekening<span style="position:absolute; font-size: 10px; margin-top: -8px; margin-left:-85px">⭐</span></a>
					</div>
                    <div class="col-xs-3" style="padding-left:2px">
                        <a class="btn btn-default btn-block " href="password.php"><span class="glyphicon glyphicon-user"></span>Password</a>
					</div>
			</div>
			
 <div class="panel panel-danger">
    <div class="panel-heading">
        <strong><span class="glyphicon glyphicon-tasks"></span>Statement (Custom Range / Last 7 days)</strong>
    </div>
    <div class="panel-body">

        <!-- Filter tanggal -->
        <form method="GET" class="form-inline" style="margin-bottom:15px;">
            <label>Dari:</label>
            <input type="date" name="start" class="form-control" value="<?php echo isset($_GET['start']) ? $_GET['start'] : date('Y-m-d', strtotime('-7 days')); ?>">
            <label>Sampai:</label>
            <input type="date" name="end" class="form-control" value="<?php echo isset($_GET['end']) ? $_GET['end'] : date('Y-m-d'); ?>">
            <button type="submit" class="btn btn-primary">Filter</button>
        </form>

        <?php
        $start = isset($_GET['start']) ? $_GET['start'] . ' 00:00:00' : date('Y-m-d 00:00:00', strtotime('-7 days'));
        $end = isset($_GET['end']) ? $_GET['end'] . ' 23:59:59' : date('Y-m-d 23:59:59');

        // Total saldo rabat di periode filter
        $sql_rabat_period = mysqli_query($conn, "
            SELECT SUM(saldo) as totalRabat
            FROM tb_transaksi
            WHERE userID = '$userID' AND jenis = 4 AND status = 1
              AND date BETWEEN '$start' AND '$end'
        ");
        $rabat_period = mysqli_fetch_array($sql_rabat_period);
        $totalRabatPeriod = $rabat_period['totalRabat'] ? $rabat_period['totalRabat'] : 0;

        // Ambil semua transaksi sesuai filter
        $sql_transaksi = mysqli_query($conn, "
            SELECT * 
            FROM tb_transaksi 
            WHERE userID = '$userID'
              AND date BETWEEN '$start' AND '$end'
            ORDER BY date DESC
        ");
        ?>

        <div class="card" style="margin-bottom:20px; padding:10px;">
            <h5>Saldo Komisi Rabat di Periode: <span style="color:yellow; font-weight:bold;">
                IDR <?php echo number_format($totalRabatPeriod,0,",","."); ?>
            </span></h5>
        </div>

        <table class="table table-hover">
            <thead>
                <tr>
                    <th style="width:120px;">Tanggal</th>
                    <th>Deskripsi</th>
                    <th style="width:120px; text-align:right">+/-</th>
                    <th style="width:120px; text-align:right">Balance</th>
                </tr>
            </thead>
            <tbody>
            <?php
            $runningBalance = $u['saldo'];

            while($t = mysqli_fetch_array($sql_transaksi)){

                if($t['saldo'] > 0){
                    $class = 'style="color:green;"';
                    $sign = '+';
                } elseif($t['saldo'] < 0){
                    $class = 'style="color:red;"';
                    $sign = '-';
                } else{
                    $class = 'style="color:blue;"';
                    $sign = '';
                }

                $amount = number_format(abs($t['saldo']),0,",",".");
                $balance = number_format($runningBalance,0,",",".");
                
                // Tambahkan badge & tooltip untuk komisi rabat
                $noteDisplay = $t['note'];
                if($t['jenis'] == 4){ // 4 = rabat
                    $noteDisplay .= ' <span class="label label-success" title="Bonus Mingguan IDR '.number_format($t['saldo'],0,",",".").'">Rabat</span>';
                }
            ?>
                <tr>
                    <td><?php echo $t['date']; ?></td>
                    <td><?php echo $noteDisplay; ?></td>
                    <td style="text-align:right;" <?php echo $class; ?>><?php echo $sign.' '.$amount; ?></td>
                    <td style="text-align:right;"><?php echo $balance; ?></td>
                </tr>
            <?php } ?>
            </tbody>
        </table>
    </div>
</div>

<script>
// Aktifkan tooltip
$(document).ready(function(){
    $('[title]').tooltip();
});
</script>

						
						<?php require_once "../app/footer.php" ?>
						
						<!-- Modal -->
						<div class="modal fade" id="myModal" role="dialog">
							<div class="modal-dialog">
								
								<!-- Modal content-->
								<div class="modal-content">
									<div class="modal-header">
										
										<h4 class="modal-title"><span class="glyphicon glyphicon-info-sign"></span>Syarat dan Ketentuan</h4>
									</div>
									<div class="modal-body">
										<ol>
											<li> MINIMAL USIA ADALAH 18 TAHUN<br>
											</li>
											<li>Harap memperhatikan jam tutup setiap pasaran karena jam tutup berbeda-beda.<br>
											</li>
											<li>Semua pasangan kan dianggap sah jika terjadi sebelum jam tutup di pasaran yang bersangkutan.<br>
											</li>
											<li>Pasangan yang sudah di konfirmasi tidak bisa dibatalkan.<br>
											</li>
											<li>Pasangan harap di cek kembali di menu history transaksi.<br>
											</li>
											<li>Semua betting yang telah dibeli adalah sah dan tidak bisa dibatalkan.<br>
											</li>
											<li>Setiap Member bertanggung jawab pada user account masing - masing.<br>
											</li>
											<li>Semua pasangan akan dibatalkan oleh pihak <?php echo $s0['instansi']; ?> jika terdeteksi adanya kecurangan atau penipuan yang dilakukan oleh member.<br>
											</li>
											<li>Pasaran dan hadiah setiap pasaran berbeda-beda dan dapat berubah sewaktu-waktu. Harap perhatikan selalu Informasi yang terbaru.<br>
											</li>
											<li>Jika terjadi kecurangan deposit dan lain sebagainya, maka kami akan memberi peringatan kepada member, jika tetap dilakukan, pihak <?php echo $s0['instansi']; ?> akan menutup akun member tersebut<br>
											</li>
											<li>Deposit dapat dilakukan setiap hari 24jam kecuali bank yang bersangkutan OFFLINE.<br>
											</li>
											<li>Withdraw dapat dilakukan setiap hari 24jam kecuali bank yang bersangkutan OFFLINE.<br>
											</li>
											<li>TIDAK MENERIMA PEMAIN INVEST DI PASARAN HONGKONG MALAM.<br>
											</li>
											<li>BATAS MAXIMAL INVEST DENGAN NOMINAL BET YANG SAMA: 
												<br>40 LINE (2D),
												<br>400 LINE (3D),
												<br>3000 LINE (4D).
											<br>Jika masih melakukan betting invest melebihi batas maximal line akan kami berikan peringatan ringan sampai terjadinya pemblokiran permanen account dan saldo tidak dikembalikan</li>
											<li>Dengan bergabung sebagai member SUZUKI4D berarti anda telah menyetujui syarat dan peraturan dari <?php echo $s0['instansi']; ?>.<br>
												SELAMAT BERMAIN DAN TERIMA KASIH.
											</li>
										</ol>        </div>
										<div class="modal-footer" >
											<button type="button" class="btn btn-success" data-dismiss="modal"><span class="glyphicon glyphicon-ok-sign"></span>Setuju</button>
											<button type="button" class="btn btn-warning  pull-left" onClick="logout()"><span class="glyphicon glyphicon-remove-sign"></span>Tidak Setuju</button>
										</div>
								</div>
								
							</div>
						</div>
						<script>
							// Cek apakah pengguna telah menyetujui syarat dan ketentuan sebelumnya
							const hasAgreed = localStorage.getItem('hasAgreed');
							
							// Fungsi untuk menampilkan modal jika belum menyetujui atau jika tidak ada catatan di local storage
							function showModal() {
								if (!hasAgreed) {
									$('#myModal').modal('show');
								}
							}
							
							// Tampilkan modal saat halaman dimuat
							$(document).ready(function() {
								showModal();
							});
							
							// Tombol "Setuju" diklik
							$('#setujuBtn').click(function() {
								// Simpan status setuju di local storage
								localStorage.setItem('hasAgreed', 'true');
								// Tutup modal
								$('#myModal').modal('hide');
							});
						</script>
					</body>
					
				</html>
			<?php } ?>			