<?php 
include 'koneksi.php'; 

// Mengambil bulan dan tahun saat ini sebagai default filter
$bulan_pilihan = isset($_GET['bulan']) ? $_GET['bulan'] : date('m');
$tahun_pilihan = isset($_GET['tahun']) ? $_GET['tahun'] : date('Y');
?>
<!DOCTYPE html>
<html lang="id">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Pemasukan Toko Sepatu</title>
    <!-- Menghubungkan ke Bootstrap 5 CDN -->
    <link href="https://jsdelivr.net" rel="stylesheet">
</head>
<body class="bg-light">

    <div class="container my-5">
        <div class="row">
            <!-- Kolom Form Input (Kiri) -->
            <div class="col-lg-4 mb-4">
                <div class="card shadow-sm border-0">
                    <div class="card-header bg-primary text-white py-3">
                        <h5 class="card-title mb-0">Input Pemasukan</h5>
                    </div>
                    <div class="card-body">
                        <form action="simpan.php" method="POST">
                            <div class="mb-3">
                                <label class="form-label fw-bold">Tanggal</label>
                                <input type="date" name="tanggal" class="form-control" required>
                            </div>
                            <div class="mb-3">
                                <label class="form-label fw-bold">Nama Sepatu</label>
                                <input type="text" name="nama_sepatu" class="form-control" placeholder="Contoh: Air Max" required>
                            </div>
                            <div class="mb-3">
                                <label class="form-label fw-bold">Merk</label>
                                <input type="text" name="merk" class="form-control" placeholder="Contoh: Nike" required>
                            </div>
                            <div class="mb-3">
                                <label class="form-label fw-bold">Jumlah Terjual</label>
                                <input type="number" name="jumlah_terjual" class="form-control" required>
                            </div>
                            <div class="mb-3">
                                <label class="form-label fw-bold">Total Harga (Rp)</label>
                                <input type="number" name="total_harga" class="form-control" required>
                            </div>
                            <div class="mb-3">
                                <label class="form-label fw-bold">Keterangan</label>
                                <input type="text" name="keterangan" class="form-control" placeholder="Opsional">
                            </div>
                            <button type="submit" class="btn btn-primary w-100 py-2 shadow-sm">Simpan Data</button>
                        </form>
                    </div>
                </div>
            </div>

            <!-- Kolom Tabel & Filter (Kanan) -->
            <div class="col-lg-8">
                <!-- Box Filter Bulanan -->
                <div class="card shadow-sm border-0 mb-4">
                    <div class="card-body">
                        <form action="" method="GET" class="row g-3 align-items-center">
                            <div class="col-md-4">
                                <label class="form-label small text-muted mb-1">Filter Bulan</label>
                                <select name="bulan" class="form-select">
                                    <?php
                                    $nama_bulan = [
                                        "01"=>"Januari", "02"=>"Februari", "03"=>"Maret", "04"=>"April", 
                                        "05"=>"Mei", "06"=>"Juni", "07"=>"Juli", "08"=>"Agustus", 
                                        "09"=>"September", "10"=>"Oktober", "11"=>"November", "12"=>"Desember"
                                    ];
                                    foreach ($nama_bulan as $key => $val) {
                                        $selected = ($key == $bulan_pilihan) ? 'selected' : '';
                                        echo "<option value='$key' $selected>$val</option>";
                                    }
                                    ?>
                                </select>
                            </div>
                            <div class="col-md-4">
                                <label class="form-label small text-muted mb-1">Filter Tahun</label>
                                <select name="tahun" class="form-select">
                                    <?php
                                    $tahun_sekarang = date('Y');
                                    for ($i = $tahun_sekarang; $i >= $tahun_sekarang-5; $i--) {
                                        $selected = ($i == $tahun_pilihan) ? 'selected' : '';
                                        echo "<option value='$i' $selected>$i</option>";
                                    }
                                    ?>
                                </select>
                            </div>
                            <div class="col-md-4 pt-4">
                                <button type="submit" class="btn btn-secondary w-100">Terapkan Filter</button>
                            </div>
                        </form>
                    </div>
                </div>

                <!-- Box Riwayat Data -->
                <div class="card shadow-sm border-0">
                    <div class="card-header bg-dark text-white py-3 d-flex justify-content-between align-items-center">
                        <h5 class="mb-0">Riwayat Pemasukan</h5>
                        <span class="badge bg-secondary"><?php echo $nama_bulan[$bulan_pilihan] . " " . $tahun_pilihan; ?></span>
                    </div>
                    <div class="table-responsive">
                        <table class="table table-hover align-middle mb-0">
                            <thead class="table-light">
                                <tr>
                                    <th>No</th>
                                    <th>Tanggal</th>
                                    <th>Nama Sepatu</th>
                                    <th>Merk</th>
                                    <th>Jumlah</th>
                                    <th>Total Harga</th>
                                    <th>Keterangan</th>
                                    <th class="text-center">Aksi</th>
                                </tr>
                            </thead>
                            <tbody>
                                <?php
                                $no = 1;
                                $total_pendapatan = 0;
                                $total_sepatu_terjual = 0;

                                // Perintah SQL yang menyaring data berdasarkan bulan & tahun yang dipilih
                                $query_string = "SELECT * FROM pemasukan 
                                                 WHERE MONTH(tanggal) = '$bulan_pilihan' 
                                                 AND YEAR(tanggal) = '$tahun_pilihan' 
                                                 ORDER BY tanggal DESC";
                                
                                $query = mysqli_query($koneksi, $query_string);

                                if(mysqli_num_rows($query) == 0) {
                                    echo "<tr><td colspan='8' class='text-center text-muted py-4'>Tidak ada data pemasukan pada bulan ini.</td></tr>";
                                }

                                while($data = mysqli_fetch_array($query)) {
                                    $total_pendapatan += $data['total_harga'];
                                    $total_sepatu_terjual += $data['jumlah_terjual'];
                                    
                                    echo "<tr>
                                        <td>".$no++."</td>
                                        <td>".date('d-m-Y', strtotime($data['tanggal']))."</td>
                                        <td><strong>".$data['nama_sepatu']."</strong></td>
                                        <td><span class='badge bg-light text-dark border'>".$data['merk']."</span></td>
                                        <td>".$data['jumlah_terjual']." pasang</td>
                                        <td>Rp ".number_format($data['total_harga'], 0, ',', '.')."</td>
                                        <td class='text-muted small'>".($data['keterangan'] ? $data['keterangan'] : '-')."</td>
                                        <td class='text-center'>
                                            <a class='btn btn-danger btn-sm' href='hapus.php?id=".$data['id']."' onclick='return confirm(\"Yakin ingin menghapus data ini?\")'>Hapus</a>
                                        </td>
                                    </tr>";
                                }
                                ?>
                            </tbody>
                            <?php if($total_sepatu_terjual > 0): ?>
                            <tfoot class="table-primary fw-bold">
                                <tr>
                                    <td colspan="4" class="text-end">TOTAL:</td>
                                    <td><?php echo $total_sepatu_terjual; ?> pasang</td>
                                    <td>Rp <?php echo number_format($total_pendapatan, 0, ',', '.'); ?></td>
                                    <td colspan="2"></td>
                                </tr>
                            </tfoot>
                            <?php endif; ?>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>

</body>
</html>