<?php
defined('APK') or exit('Anda tidak dizinkan mengakses langsung script ini!');
?>

<?php if ($ac == ''): ?>
<div class='row'>
        <div class='col-md-12'>
             <div class="card">
             <div class="card-header">
			  <h5 class='card-title'><i class="fas fa-paper-plane"></i> Input <small>Pelanggaran</small></h5>
			  </div>    
			
						<div class="card-body">
				  <form  id="forminput"] class="form-horizontal" enctype='multipart/form-data'>
                   <div class="row mb-2">
					<label  class="col-md-3 col-form-label bold">Tahun Pelajaran</label>
							<div class="col-sm-5">
							<select  class='form-control' name="tapel" required >
							 <option value="<?= $setting['tp'] ?>"><?= $setting['tp'] ?></option>
							  
                                                    </select>   
                                            </div>
						            </div>
									<div class="row mb-2">
					<label  class="col-md-3 col-form-label bold">Tanggal</label>
							<div class="col-sm-5">
							    <input type='text' name='tanggal' class='datepicker form-control' autocomplete='off' required='true' />
                                            </div>
						            </div>
							<div class="row mb-2">
					<label  class="col-md-3 col-form-label bold">Pilih Kelas</label>
							<div class="col-sm-5">
							<select  class='form-select' name="kelas" id="kelas" required >
							 <option value="">Pilih Kelas</option>
							   <?php $qtl = mysqli_query($koneksi, "SELECT * FROM siswa GROUP BY id_kelas"); ?>
                                   <?php while ($kls = mysqli_fetch_array($qtl)) : ?>
                                      <option value="<?= $kls['id_kelas'] ?>"><?= $kls['id_kelas'] ?></option>
                                                <?php endwhile ?>
                                                    </select>   
                                            </div>
						            </div>
									<div class="row mb-2">
					<label  class="col-md-3 col-form-label bold">Nama Siswa</label>
									<div class="col-sm-9">
									  <select  class='form-select' name="nis" id="nis" required >
									  
									   </select>   
                                            </div>
						            </div>									
									<div class="row mb-2">
					<label  class="col-md-3 col-form-label bold">Kategori</label>
							<div class="col-sm-9">
							<select  class='form-select' name="kategori" id="kategori" required >
							 <option value=""></option>
							   <?php $ka = mysqli_query($koneksi, "SELECT * FROM bk_kategori"); ?>
                                   <?php while ($k = mysqli_fetch_array($ka)) : ?>
                                      <option value="<?= $k['id'] ?>"><?= $k['kategori'] ?></option>
                                                <?php endwhile ?>
                                                    </select>   
                                            </div>
						            </div>
									<div class="row mb-2">
					<label  class="col-md-3 col-form-label bold">Sub Kategori</label>
							<div class="col-sm-9">
							<select  class='form-select' name="sub" id="sub" required >
							
                                                    </select>   
                                            </div>
						            </div>
									<div class="row mb-2">
					<label  class="col-md-3 col-form-label bold">Jenis Pelanggaran</label>
							<div class="col-sm-9">
							<select  class='form-select' name="jenis" id="jenis" required >
							
                                                    </select>   
                                            </div>
						            </div>
									<div class="row mb-2">
					<label  class="col-md-3 col-form-label bold">Keterangan</label>
							<div class="col-sm-9">
								<textarea name="ket" rows="5" class="form-control" required /></textarea>
							</div>
						            </div>
									
								   <div class='right'>
									  <button type='submit'  class='btn btn-outline-primary'><i class='fa fa-check-circle'></i>Simpan</button>										 
											</div>
											
							</form>
							 </div>
						</div>
					</div>
				</div>
			</div>
			<script>
              $("#kelas").change(function() {
            var kelas = $(this).val();
            console.log(kelas);
            $.ajax({
                type: "POST",
                url: "cbtserver_bk/crud_bk.php?pg=ambil_kelas", 
                data: "kelas=" + kelas, 
                success: function(response) { 
                    $("#nis").html(response);
                    console.log(response);
                },
                error: function(xhr, status, error) {
                    console.log(error);
                }
            });
        });
		  $("#kategori").change(function() {
            var kategori = $(this).val();
            console.log(kategori);
            $.ajax({
                type: "POST",
                url: "cbtserver_bk/crud_bk.php?pg=ambil_sub", 
                data: "kategori=" + kategori, 
                success: function(response) { 
                    $("#sub").html(response);
                    console.log(response);
                },
                error: function(xhr, status, error) {
                    console.log(error);
                }
            });
        });
		 $("#sub").change(function() {
            var sub = $(this).val();
            console.log(sub);
            $.ajax({
                type: "POST",
                url: "cbtserver_bk/crud_bk.php?pg=ambil_jenis", 
                data: "sub=" + sub, 
                success: function(response) { 
                    $("#jenis").html(response);
                    console.log(response);
                },
                error: function(xhr, status, error) {
                    console.log(error);
                }
            });
        });
		</script>
		<script>
		$('#forminput').submit(function(e) {
        e.preventDefault();
        var data = new FormData(this);
      
        $.ajax({
            type: 'POST',
             url: "cbtserver_bk/crud_bk.php?pg=input_bk", 
            enctype: 'multipart/form-data',
            data: data,
            cache: false,
            contentType: false,
            processData: false,
            success: function(data) {
              iziToast.info(
					{
					title: 'Sukses!',
					message: 'Data berhasil disimpan',
					titleColor: '#FFFF00',
					messageColor: '#fff',
					backgroundColor: 'rgba(0, 0, 0, 0.5)',
				    progressBarColor: '#FFFF00',
					 position: 'topRight'				  
						});
                setTimeout(function() {
                    window.location.replace('?');
                }, 2000);

            }
        });
        return false;
    });
</script>
			
<?php elseif($ac == 'edit'): ?>	
<?php
			$id = $_GET['id'];
            $bks = mysqli_fetch_array(mysqli_query($koneksi, "SELECT * FROM bk_siswa WHERE id='$id'"));
            $siswa=fetch($koneksi,'siswa',['nis'=>$bks['nis']]);
			 $sub=fetch($koneksi,'bk_pelanggaran',['id'=>$bks['idpel']]);
			
			?>
		<div class='row'>
        <div class='col-md-12'>
             <div class="card">
             <div class="card-header">
			  <h5 class='card-title'><i class="fas fa-paper-plane"></i> Edit <small>Pelanggaran</small></h5>
			  </div>    
			 
						<div class="card-body">
				  <form  id="formedit" class="form-horizontal" enctype='multipart/form-data'>
				  <input type="hidden" name="id" value="<?= $id ?>" >   
                   <div class="row mb-2">
					<label  class="col-md-3 col-form-label bold">Tahun Pelajaran</label>
							<div class="col-sm-5">
							<select  class='form-control' name="tapel" required >
							 <option value="<?= $setting['tp'] ?>"><?= $setting['tp'] ?></option>
							  
                                                    </select>   
                                            </div>
						            </div>
									<div class="row mb-2">
					<label  class="col-md-3 col-form-label bold">Tanggal</label>
							<div class="col-sm-5">
							    <input type='text' name='tanggal' class='datepicker form-control' value="<?= $bks['tanggal'] ?>" autocomplete='off' required='true' />
                                            </div>
						            </div>
							<div class="row mb-2">
					<label  class="col-md-3 col-form-label bold">Pilih Kelas</label>
							<div class="col-sm-5">
							<select  class='form-select' name="kelas"  required >
							 <option value="<?= $siswa['id_kelas'] ?>"><?= $siswa['id_kelas'] ?></option>
	
                                                    </select>   
                                            </div>
						            </div>
									<div class="row mb-2">
					<label  class="col-md-3 col-form-label bold">Nama Siswa</label>
									<div class="col-sm-9">
									  <select  class='form-select' name="nis" id="nis" required >
									   <option value="<?= $siswa['nis'] ?>"><?= $siswa['nama'] ?></option>
									   </select>   
                                            </div>
						            </div>									
									<div class="row mb-2">
					<label  class="col-md-3 col-form-label bold">Jenis Pelanggaran</label>
							<div class="col-sm-9">
							<select  class='form-select' name="jenis"  required >
							 <option value="<?= $sub['id'] ?>"><?= $sub['pelanggaran'] ?></option>
							  
                                                    </select>   
                                            </div>
						            </div>
									<div class="row mb-2">
					<label  class="col-md-3 col-form-label bold">Keterangan</label>
							<div class="col-sm-9">
								<textarea name="ket" rows="5" class="form-control" required /><?= $bks['ket'] ?></textarea>
							</div>
						            </div>
							 <div class='right'>
									  <button type='submit'  class='btn btn-outline-primary'><i class='fa fa-check-circle'></i>Simpan</button>										 
											</div>		
							</form>
							 </div>
						</div>
					</div>
				</div>
			</div>
		<script>
		$('#formedit').submit(function(e) {
        e.preventDefault();
        var data = new FormData(this);
      
        $.ajax({
            type: 'POST',
             url: "cbtserver_bk/crud_bk.php?pg=edit_bksiswa", 
            enctype: 'multipart/form-data',
            data: data,
            cache: false,
            contentType: false,
            processData: false,
            success: function(data) {
              iziToast.info(
					{
					title: 'Sukses!',
					message: 'Data berhasil disimpan',
					titleColor: '#FFFF00',
					messageColor: '#fff',
					backgroundColor: 'rgba(0, 0, 0, 0.5)',
				    progressBarColor: '#FFFF00',
					 position: 'topRight'				  
						});
                setTimeout(function() {
                    window.location.replace('?');
                }, 2000);

            }
        });
        return false;
    });
</script>			
<?php elseif($ac == 'detail'): ?>
<?php $sub = fetch($koneksi,'bk_kategori',['id'=>$_GET['id']]); ?>
		<div class='row'>
        <div class='col-md-12'>
            <div class="card">
             <div class="card-header">
			  <h5 class='card-title'>Total <small>Pelanggaran <?= $sub['kategori'] ?></small></h5>
			  </div>    
			 
			
						<div class="card-body">	
						<div class='table-responsive'>
                        <table style="font-size: 12px" id='example1' class='table  table-hover'>
                            <thead>
                            <tr>                              
                                    <th width='5%'>No</th>					
                                    <th>Sub Kategori Pelanggaran</th>									                                                                
                                   <th width="10%">NIS</th>
                                    <th width="20%">Nama Siswa</th>
									<th width="10%">Kelas</th>
									 <th width="10%">Total Poin</th> 
									
									 </tr>
                        </thead>
                        <tbody>
                            <?php
                            $query = mysqli_query($koneksi, "select idkat,nis,idpel,idsub,tapel,SUM(poin) AS jml from bk_siswa WHERE idkat='$_GET[id]' AND tapel='$setting[tp]'");
                            $no = 0;
                            while ($bk = mysqli_fetch_array($query)) {
							$siswa=fetch($koneksi,'siswa',['nis'=>$bk['nis']]);
							$sub=fetch($koneksi,'bk_sub',['id'=>$bk['idsub']]);
							  $no++;
                              
                            ?>
                                <tr>
                                    <td><?= $no; ?></td>
									<td><?= $sub['sub_kategori'] ?></td>
									<td><?= $siswa['nis'] ?></td>							                                
									<td><b style="color:blue"><?= $siswa['nama'] ?></b></td>
									<td><?= $siswa['id_kelas'] ?></td>
									 <td class="text-center"><b style="color:red"><?= $bk['jml'] ?></b></td>
									
									</tr>
									<?php } ?>
                        </tbody>
                    </table>
					 </div>
                </div>
            </div>
        </div>
						
	<?php elseif($ac == 'rincian'): ?>
<?php $sub = fetch($koneksi,'bk_kategori',['id'=>$_GET['id']]); ?>
		<div class='row'>
        <div class='col-md-12'>
            <div class="card">
             <div class="card-header">
			  <h5 class='card-title'>Rincian <small>Pelanggaran <?= $sub['kategori'] ?></small></h5>
			  </div>    
			 
						<div class="card-body">	
						<div class='table-responsive'>
                        <table style="font-size: 12px" id='example1' class='table  table-hover'>
                            <thead>
                            <tr>                              
                                    <th width='5%'>No</th>					
                                    <th>Keterangan Pelanggaran</th>									                                                                
                                   <th width="10%">NIS</th>
                                    <th width="20%">Nama Siswa</th>
									<th width="10%">Kelas</th>
									 <th width="10%">Poin</th> 
									
									 </tr>
                        </thead>
                        <tbody>
                            <?php
                            $query = mysqli_query($koneksi, "select * from bk_siswa WHERE idkat='$_GET[id]' AND tapel='$setting[tp]'");
                            $no = 0;
                            while ($bk = mysqli_fetch_array($query)) {
							$siswa=fetch($koneksi,'siswa',['nis'=>$bk['nis']]);
							$sub=fetch($koneksi,'bk_sub',['id'=>$bk['idsub']]);
							  $no++;
                              
                            ?>
                                <tr>
                                    <td><?= $no; ?></td>
									<td><?= $bk['ket'] ?></td>
									<td><?= $siswa['nis'] ?></td>							                                
									<td><b style="color:blue"><?= $siswa['nama'] ?></b></td>
									<td><?= $siswa['id_kelas'] ?></td>
									 <td class="text-center"><b style="color:red"><?= $bk['poin'] ?></b></td>
									
									</tr>
									<?php } ?>
                        </tbody>
                    </table>
					 </div>
                </div>
            </div>
        </div>					
						
<?php endif; ?>