walas.php

<?php include 'index.php'; ?>

<style>
    .modal-body {
        max-height: 70vh;
        overflow-y: auto;
    }

    .btn-outline-primary{
      margin-left: 5px;
    }
</style>

<?php
include 'config.php'; // Pastikan file koneksi sudah sesuai

// Jika id_kelas belum dipilih, tampilkan dropdown
if (!isset($_GET['id_kelas'])): ?>
    <div class="container mt-4">
        <form method="get">
            <div class="form-group mt-3">
                <label for="kelas">Pilih Kelas</label>
                <select class="form-control" name="id_kelas" id="kelas" required>
                    <option value="" disabled selected>-- Pilih Kelas --</option>
                    <?php
                    // Mengambil data kelas menggunakan PDO
                    $stmt = $pdo->query("SELECT id_kelas, nama_kelas FROM tb_kelas ORDER BY nama_kelas ASC");
                    while ($row = $stmt->fetch()) {
                        echo "<option value='{$row['id_kelas']}'>{$row['nama_kelas']}</option>";
                    }
                    ?>
                </select>
            </div>
            <br>
            <button type="submit" class="btn btn-success">Lanjut</button>
        </form>
    </div>
<?php
    exit; // Hentikan script jika id_kelas belum diinputkan
endif;

// Jika id_kelas sudah dipilih
$id_kelas = $_GET['id_kelas'];
$stmt = $pdo->prepare("SELECT nama_kelas FROM tb_kelas WHERE id_kelas = :id_kelas");
$stmt->execute(['id_kelas' => $id_kelas]);
$d_kelas = $stmt->fetch();

if ($d_kelas) {
    $nama_kelas = $d_kelas['nama_kelas'];
    // Menggunakan PDO untuk mengambil data siswa berdasarkan id_kelas
    $stmt_siswa = $pdo->prepare("SELECT * FROM tb_siswa WHERE id_kelas = :id_kelas");
    $stmt_siswa->execute(['id_kelas' => $id_kelas]);

    echo "<div class='container mt-4'>";

    // Tombol untuk kembali dan aksi
    echo "<a href='walas.php' class='btn btn-outline-danger mb-3'>Kembali</a> ";
    echo "<button type='button' class='btn btn-outline-success mb-3' data-bs-toggle='modal' data-bs-target='#modalNilai'>Input Nilai</button>";
    echo "<a href='nilai_walas.php' class='btn btn-outline-primary mb-3'>Tabel Nilai Siswa</a> ";

    echo "<h4>Daftar Siswa Kelas <strong>$nama_kelas</strong></h4>";
    echo "<table class='table table-bordered'>";
    echo "<thead><tr><th>No</th><th>NIS</th><th>Nama</th><th>Jenis Kelamin</th></tr></thead><tbody>";

    $no = 1;
    while ($siswa = $stmt_siswa->fetch()) {
        echo "<tr>";
        echo "<td>{$no}</td>";
        echo "<td>{$siswa['nis']}</td>";
        echo "<td>{$siswa['nama']}</td>";
        echo "<td>{$siswa['jk']}</td>";
        echo "</tr>";
        $no++;
    }

    echo "</tbody></table>";

    // Modal Input Nilai
    echo <<<HTML
<!-- Modal -->
<div class="modal fade" id="modalNilai" tabindex="-1" aria-labelledby="modalNilaiLabel" aria-hidden="true">
  <div class="modal-dialog modal-xl modal-dialog-scrollable">
    <div class="modal-content">
      <form action="simpan_nilai.php" method="post">
        <div class="modal-header">
          <h5 class="modal-title" id="modalNilaiLabel">Input Nilai - Kelas $nama_kelas</h5>
          <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
        </div>
        <div class="modal-body">
          <input type="hidden" name="id_kelas" value="$id_kelas">
          <div class="form-group mb-3">
            <label for="id_mapel">Mata Pelajaran</label>
            <select class="form-control" name="id_mapel" required>
              <option value="" disabled selected>-- Pilih Mapel --</option>
HTML;

    $stmt_mapel = $pdo->query("SELECT * FROM tb_mapel ORDER BY nama_mapel");
    while ($mapel = $stmt_mapel->fetch()) {
        echo "<option value='{$mapel['id_mapel']}'>{$mapel['nama_mapel']}</option>";
    }

    echo <<<HTML
            </select>
          </div>
          <div class="table-responsive">
            <table class="table table-sm table-bordered">
              <thead>
                <tr>
                  <th>No</th>
                  <th>NIS</th>
                  <th>Nama</th>
                  <th>Nilai</th>
                </tr>
              </thead>
              <tbody>
HTML;

    // Fetch lagi siswa karena hasil sebelumnya sudah habis
    $stmt_siswa->execute(['id_kelas' => $id_kelas]);
    $no = 1;
    while ($s = $stmt_siswa->fetch()) {
        // Pastikan nilai terdefinisikan
        $nilai = isset($_POST['nilai'][$s['nis']]) ? $_POST['nilai'][$s['nis']] : '';

        echo "<tr>
                <td>{$no}</td>
                <td>{$s['nis']}</td>
                <td>{$s['nama']}</td>
                <td><input type='number' name='nilai[{$s['nis']}]' class='form-control' value='{$nilai}' min='0' max='100'></td>
              </tr>";
        $no++;
    }

    echo <<<HTML
              </tbody>
            </table>
          </div>
        </div>
        <div class="modal-footer">
          <button type="submit" class="btn btn-success">Simpan Nilai</button>
        </div>
      </form>
    </div>
  </div>
</div>
HTML;

    echo "</div>";
} else {
    echo "<div class='alert alert-warning'>Kelas tidak ditemukan.</div>";
}
?>