<?php

	$tgl_pinjam= date("d-m-Y");
	$tujuh_hari= mktime(0,0,0, date("n"), date("j")+3, date("Y"));
	$kembali = date("d-m-Y", $tujuh_hari);


?>


<div class="panel panel-default">
 <div class="panel panel-primary">
  <div class="panel-heading">
    Tambah Data
 </div>
 <div class="panel-body">
    <div class="row">
      <div class="col-md-12">



      <form action="" method="POST">
        <div class="form-group">

        	<div class="form-group">
                      <label>Judul Buku</label>

          <select class="form-control"  id= "buku" name="buku" onchange='changeValue(this.value)'""/>

                  <?php
                      $sql =mysqli_query($conn,"SELECT * FROM tb_buku order by id asc");
                      $result = mysqli_query($conn,"SELECT * FROM tb_buku");
                      $jsArray = "var prdName = new Array();\n";
                        echo "<option>--Pilih Buku--</option>";

      while ($row = mysqli_fetch_array($result)){
      echo '<option name="id"  value="'.$row['judul'].'">'.$row['judul'].'</option>';
      $jsArray .= "prdName['". $row['judul']."'] = {miez:'".addslashes($row['kategori'])."'};\n";  }
                echo"
                    </select>
                    </tr>

                    <tr><br>

                    <label>Kategori</label>
                    <td><input name='kategori' id='kategori' disabled='' class='form-control'></td>

                    </tr>

                    ";
                            ?>

                            <script type="text/javascript">

                            <?php echo $jsArray; ?>

                            function changeValue(id){

                            document.getElementById('kategori').value = prdName[id].miez;

                            };
                            </script>
                  </div>


                   <div  class="form-group">
                      <label>Nama</label>
                    <select class="form-control" name="nama"/>
                    <option>--Pilih Nama--</option>
                      <?php
                     	$sql =mysqli_query($conn,"SELECT * FROM tb_anggota order by nis");
                     	while($row=mysqli_fetch_array($sql)){
                     		echo "<option value='$row[nis].$row[nama]'>$row[nama].$row[nis]</option>";
                     	}?>

                    </select>
                  </div>

                  <div class="form-group">
                      <label>Kelas / Mengajar Kelas</label>
                    <select class="form-control" name="kelas"/>
                      <option>--Pilih Kelas--</option>
                      <option value="Kelas 1">Kelas 1</option>
                      <option value=" Kelas 2">Kelas 2</option>
                      <option value=" Kelas 3">Kelas 3</option>
                      <option value="Kelas 4">Kelas 4</option>
                      <option value=" Kelas 5">Kelas 5</option>
                      <option value=" Kelas 6">Kelas 6</option>
                    </select>
                  </div>



                   <div class="form-group">
              <label>Tanggal Pinjam</label>
                <input class="form-control" type="text" name="tgl_pinjam" id="tgl" value="<?php echo $tgl_pinjam; ?>" readonly/>
                </div>

                 <div class="form-group">
              <label>Tanggal Kembali</label>
                <input class="form-control" type="text" name="tgl_kembali" id="tgl" value="<?php echo $kembali; ?>" readonly/>
                </div>


                <div>
                  <input type="submit" name="simpan" value="Simpan" class="btn btn-primary" style="margin-left:92.5%"/>
                </div>
              </div>
          </form>

<?php


if(isset($_POST['simpan'])){
  include 'koneksi.php';

$tgl_pinjam=$_POST['tgl_pinjam'];
$tgl_kembali=$_POST['tgl_kembali'];


$buku =$_POST['buku'];


$kategori =$_POST['kategori'];

$nama =$_POST['nama'];
$pecah_nama = explode(".", $nama);
$nis  =$pecah_nama[0];
$nama =$pecah_nama[1];
$kelas=$_POST['kelas'];

$sql=mysqli_query($conn,"select * from tb_buku where judul='$judul'");
while($row=mysqli_fetch_array($sql)){

	$sisa =$row['jumlah_buku'];


	if($sisa==0){
		?>
		<script type="text/javascript">
			alert("Stock Buku Habis, Transaksi Tidak Dapat Dilakukan");
			window.location.href="?page=transaksi&aksi=tambah";
		</script>
	<?php
	}else{

    $sql=mysqli_query($conn,"INSERT INTO tb_transaksi (judul, kategori, nis, nama, kelas, tgl_pinjam, tgl_kembali, status)
        VALUES(

          '$judul',
          '$kategori',
          '$nis',
          '$nama',
          '$kelas',
          '$tgl_pinjam',
          '$tgl_kembali',
          'Pinjam')");

      $update =mysqli_query($conn, "UPDATE tb_buku SET jumlah_buku =(jumlah_buku-1) WHERE judul='$judul'");

    ?>
    <script type="text/javascript">
        alert("Proses Transaksi Berhasil Dilakukan");
        window.location.href="?page=transaksi";
    </script>
    <?php

    }
     }
       }
?>
        </div>
      </div>
    </div>
  </div>