<?php
if (session_status() == PHP_SESSION_NONE) { session_start(); }
include_once '../db/koneksi.php'; // Pastikan koneksi benar

// Pastikan variabel $db terdefinisi
$db = $koneksi ?? $conn ?? $db_connect ?? $link ?? null;

// Daftar Pasaran (HARUS SAMA dengan yang ada di togel.php)
$master_pasaran = [
    ['key' => 'Sydney Pools', 'param' => 'SYDNEY'],
    ['key' => 'Singapore', 'param' => 'SINGAPORE'],
    ['key' => 'Hongkong Pools', 'param' => 'HONGKONG POOLS'],
    ['key' => 'Hongkong lotto', 'param' => 'HONGKONG LOTTO'],
    ['key' => 'Sydney Lotto', 'param' => 'SYDNEY LOTTO'],
    ['key' => 'TOTO MACAU 13', 'param' => 'TOTO MACAU 13'],
    ['key' => 'TOTO MACAU 16', 'param' => 'TOTO MACAU 16'],
    ['key' => 'TOTO MACAU 19', 'param' => 'TOTO MACAU 19'], 
    ['key' => 'TOTO MACAU 22', 'param' => 'TOTO MACAU 22'],
    ['key' => 'Toto Macau 23', 'param' => 'TOTO MACAU 23'],
    ['key' => 'Toto Macau 00', 'param' => 'TOTO MACAU 00'], 
    ['key' => 'CALIFORNIA D4', 'param' => 'CALIFORNIA D4'],
    ['key' => 'FLORIDA EVE', 'param' => 'FLORIDA EVE'],
    ['key' => 'MISSOURI EVE', 'param' => 'MISSOURI EVE'], 
    ['key' => 'KENTUCKY EVE', 'param' => 'KENTUCKY EVE'],
    ['key' => 'NEW YORK EVE', 'param' => 'NEW YORK EVE'], 
    ['key' => 'CAROLINE EVE', 'param' => 'CAROLINA EVE'],
    ['key' => 'MAGNUM CAMBODIA', 'param' => 'MAGNUM CAMBODIA'], 
    ['key' => 'BULLSEYE', 'param' => 'BULLSEYE'],
    ['key' => 'OREGON 7 PM', 'param' => 'OREGON 7 PM'],
    ['key' => 'OREGON 10 PM', 'param' => 'OREGON 10 PM'], 
    ['key' => 'CHINA POOLS', 'param' => 'CHINA POOLS'],
    ['key' => 'JAPAN POOLS', 'param' => 'JAPAN POOLS'], 
    ['key' => 'TAIWAN', 'param' => 'TAIWAN'],
    ['key' => 'NEW YORK MID', 'param' => 'NEW YORK MID'],
    ['key' => 'MISSOURI MID', 'param' => 'MISSOURI MID'], 
    ['key' => 'KENTUCKY MID', 'param' => 'KENTUCKY MID'],
    ['key' => 'CAROLINA DAY', 'param' => 'CAROLINA DAY'], 
    ['key' => 'CAROLINE EVE', 'param' => 'CAROLINA EVE'],
    ['key' => 'PCSO', 'param' => 'PCSO'], 
    ['key' => 'MOROCCO 4', 'param' => 'MOROCCO 4'],
    ['key' => 'OREGON 1 PM', 'param' => 'OREGON 1 PM'],
    ['key' => 'GEORGIA C4 MID', 'param' => 'GEORGIA C4 MID'], 
    ['key' => 'MARYLAND MID', 'param' => 'MARYLAND MID'],
    ['key' => 'NEW JERSEY MID', 'param' => 'NEW JERSEY MID'], 
    ['key' => 'GERMANY PLUS', 'param' => 'GERMANY PLUS'],
];

// Proses Simpan
if (isset($_POST['simpan'])) {
    $pasaran = $_POST['pasaran']; // Ini akan menyimpan nilai 'param' (misal: SYDNEY)
    $hari    = mysqli_real_escape_string($db, $_POST['hari']);
    $tanggal = mysqli_real_escape_string($db, $_POST['tanggal']);
    $hasil   = mysqli_real_escape_string($db, $_POST['hasil']);

    // Cek apakah data sudah ada (Update) atau belum (Insert)
    $cek = mysqli_query($db, "SELECT id FROM pengeluaran_togel WHERE pasaran = '$pasaran' AND tanggal = '$tanggal'");
    
    if (mysqli_num_rows($cek) > 0) {
        $query = "UPDATE pengeluaran_togel SET hasil = '$hasil', hari = '$hari' WHERE pasaran = '$pasaran' AND tanggal = '$tanggal'";
    } else {
        $query = "INSERT INTO pengeluaran_togel (pasaran, hari, tanggal, hasil) VALUES ('$pasaran', '$hari', '$tanggal', '$hasil')";
    }

    if (mysqli_query($db, $query)) {
        echo "<script>alert('Berhasil Update Result'); window.location.href='?page=input_manual_result';</script>";
    }
} 
// Proses Hapus Data
if (isset($_GET['hapus'])) {
    $id_hapus = mysqli_real_escape_string($db, $_GET['hapus']);
    mysqli_query($db, "DELETE FROM pengeluaran_togel WHERE id = '$id_hapus'");
    echo "<script>alert('Data berhasil dihapus'); window.location.href='?page=input_manual_result';</script>";
}
?> 
<div class="card mb-4">
  <h5 class="card-header">Form Input Result Manual</h5>
  <div class="card-body">
    <form action="" method="POST">
      <div class="row">
        <div class="col-md-6 mb-3">
          <label class="form-label">Pilih Pasaran</label>
          <select name="pasaran" class="form-select" required>
            <option value="">-- Pilih Pasaran --</option>
            <?php foreach ($master_pasaran as $p) { ?>
              <option value="<?php echo $p['param']; ?>"><?php echo $p['key']; ?></option>
            <?php } ?>
          </select>
        </div>
        <div class="col-md-6 mb-3">
          <label class="form-label">Hari</label>
          <input type="text" name="hari" class="form-control" placeholder="Contoh: Senin" required>
        </div>
      </div>
      <div class="row">
        <div class="col-md-6 mb-3">
          <label class="form-label">Tanggal</label>
          <input type="date" name="tanggal" class="form-control" required>
        </div>
        <div class="col-md-6 mb-3">
          <label class="form-label">Hasil (Angka)</label>
          <input type="text" name="hasil" class="form-control" placeholder="Contoh: 1234" required>
        </div>
      </div>
      <button type="submit" name="simpan" class="btn btn-primary">Simpan Result</button>
    </form>
  </div>
</div>

<!-- Tabel Daftar Pengeluaran (Sama seperti sebelumnya) -->
<div class="card">
  <h5 class="card-header">Daftar Pengeluaran Togel</h5>
  <div class="table-responsive text-nowrap">
    <table class="table table-hover">
      <thead>
        <tr>
          <th>No</th>
          <th>Pasaran</th>
          <th>Hari</th>
          <th>Tanggal</th>
          <th>Hasil</th>
          <th>Aksi</th>
        </tr>
      </thead>
      <tbody>
        <?php 
        $query = mysqli_query($db, "SELECT * FROM pengeluaran_togel ORDER BY id DESC LIMIT 50");
        $no = 1;
        while ($row = mysqli_fetch_assoc($query)) { ?>
          <tr>
            <td><?php echo $no++; ?></td>
            <td><?php echo $row['pasaran']; ?></td>
            <td><?php echo $row['hari']; ?></td>
            <td><?php echo $row['tanggal']; ?></td>
            <td><span class="badge bg-label-primary"><?php echo $row['hasil']; ?></span></td>
            <td>
  <a href="?page=input_manual_result&hapus=<?php echo $row['id']; ?>" 
     class="btn btn-sm btn-danger" 
     onclick="return confirm('Apakah Anda yakin ingin menghapus data ini?')">
     Hapus
  </a>
</td>
          </tr>
        <?php } ?>
      </tbody>
    </table>
  </div>
</div>