isenk

<?php if ( ! defined('CMS')) exit('Akses Ditolak Silahkan Gunakan Aplikasi dengan Bijak...');

// buat tanggal sekarang
$tanggal = date('Y-m-d');
$tanggal_arr = explode(' ', $tanggal);
$txt_tanggal = tgl_indo($tanggal_arr[0]);
?>


<!-- tampilkan form -->
<?php if(empty($ok)) { ?>

<form method="POST" action="">
<div class="box box-primary">
    <div class="box-header">
            <h3 class="box-title"><b/>REKAP DATA ABSENSI</h3>
    </div>
    <div class="box-body" >
    <div class="form-group">
      <label class="control-label" >Dari : </label>
      <div class="input-group date dtpicker col-md-5" style="z-index: 9999 !important;">
        <div class="input-group-addon"><i class="fa fa-calendar"></i></div>
        <input type="text" name="tgl_lahir_txt" id="tgl_lahir_txt" value="<?php echo $txt_tanggal ?>" required="true" readonly="readonly" class="form-control" style="width:50%" /><br>
        <input type="hidden" name="tgl1" id="tgl1" value="<?php echo $tanggal ?>"  />
      </div>
    </div>
    <div class="form-group">
      <label class="control-label" >Sampai Dengan : </label>
      <div class="input-group date dtpicker col-md-5" style="z-index: 9999 !important;">
        <div class="input-group-addon"><i class="fa fa-calendar"></i></div>
        <input type="text" name="tgl_lahir_txt" id="tgl_lahir_txt" value="<?php echo $txt_tanggal ?>" required="true" readonly="readonly" class="form-control" style="width:50%" /><br>
        <input type="hidden" name="tgl2" id="tgl2" value="<?php echo $tanggal ?>"  />
      </div>
    </div>
        <div class="box-footer">
            <input class="btn btn-success" type="submit" name="rekap" value="Rekap" >
            <input type="button"  class="btn btn-warning " value="Batal" onclick="history.go(-1)">
        </div>
    </div>
</div>
</form>

<div class="box">
  <div class="box-header">
    <h3 class="box-title">REKAP DATA ABSENSI</h3>
  </div><!-- /.box-header -->
  <div class="box-body">
    <table id="example1" class="table table-bordered table-striped">
      <thead>
        <tr>
          <th class="header_kolom" style="width:5%"> No.</th>
          <th class="header_kolom" style="width:45%"> ID/NISN</th>
          <th class="header_kolom" style="width:10%"> Hadir</th>
          <th class="header_kolom" style="width:10%"> Alpha</th>
          <th class="header_kolom" style="width:10%"> Sakit</th>
          <th class="header_kolom" style="width:10%"> Izin</th>
          <th class="header_kolom" style="width:10%"> Bolos</th>
        </tr>
      </thead>
      <tbody>
        <?php
        //SIMPAN DATA
if ($_POST) {
    $error = array(); // variabel jika error
    $ok = array(); // variabel jika berhasil

    //variabel kiriman POST
    $tgl1               =$_POST['tgl1'];
    $tgl2               =$_POST['tgl2'];

    // validasi data kosong
    if (empty($tgl1) || empty($tgl2)) {
    $error[] = 'Tanggal Harus Diisi!';
    }

    if(empty($error)) { // gak ada error

        // SQLi Query rekap hadir
        $hadir = "SELECT*FROM tbl_absensi WHERE keterangan='Masuk' AND tgl_absensi BETWEEN '$tgl1' AND '$tgl2'";
        $rkp_hadir = mysqli_query($konek, $hadir);
        $jml_hadir = mysqli_num_rows($rkp_hadir);

        // SQLi Query rekap alpha
        $alpha = "SELECT*FROM tbl_absensi WHERE keterangan='Alpha' AND tgl_absensi BETWEEN '$tgl1' AND '$tgl2'";
        $rkp_alpha = mysqli_query($konek, $alpha);
        $jml_alpha = mysqli_num_rows($rkp_alpha);

        // SQLi Query rekap sakit
        $sakit = "SELECT*FROM tbl_absensi WHERE keterangan='Sakit' AND tgl_absensi BETWEEN '$tgl1' AND '$tgl2'";
        $rkp_sakit = mysqli_query($konek, $sakit);
        $jml_sakit = mysqli_num_rows($rkp_sakit);

        // SQLi Query rekap izin
        $izin = "SELECT*FROM tbl_absensi WHERE keterangan='Izin' AND tgl_absensi BETWEEN '$tgl1' AND '$tgl2'";
        $rkp_izin = mysqli_query($konek, $izin);
        $jml_izin = mysqli_num_rows($rkp_izin);

        // SQLi Query rekap bolos
        $bolos = "SELECT*FROM tbl_absensi WHERE keterangan='Bolos' AND tgl_absensi BETWEEN '$tgl1' AND '$tgl2'";
        $rkp_bolos = mysqli_query($konek, $bolos);
        $jml_bolos = mysqli_num_rows($rkp_bolos);

        //validasi hasil rekap
        if ($jml_hadir || $jml_alpha || $jml_sakit || $jml_izin || $jml_bolos) {
            $ok[] = 'Berhasil, Data Sudah Disimpan !';
        }


    // tampilkan jika pesan error
    if(!empty($error)) {
        echo '<div class="alert alert-danger alert-dismissable">
        <button aria-hidden="true" data-dismiss="alert" class="close" type="button">×</button>
        <ul>';
    foreach ($error as $val) {
        echo '<li>'.$val.'</li>';
    }
        echo '</ul></div>';
    }
    } // akhir post

        $tampil = "SELECT * FROM tbl_absensi ORDER BY id_siswa ASC";
        $hasil = mysqli_query($konek, $tampil);
        $no = 1;
        while ($data = mysqli_fetch_array($hasil)) {
/*
lakukan query pencarian berapa kali hadir dll..
manfaatkan count
$sakit = "SELECT count(*) hitung
FROM tbl_absensi
WHERE
keterangan='Sakit'
AND (tgl_absensi BETWEEN '$tgl1' AND '$tgl2')
and id_siswa= $data['id_siswa']";
*/
        echo "
        <tr>
          <td class='h_tengah'> $no</td>
          <td class='h_tengah'> $data[nama_siswa] <!--kyknya harusnya nama bukan id--></td>
          <td class='h_tengah'> $jml_hadir</td>
          <td class='h_tengah'> $jml_alpha</td>
          <td class='h_tengah'> $jml_sakit</td>
          <td class='h_tengah'> $jml_izin </td>
          <td class='h_tengah'> $jml_bolos</td>
          </tr>";
          $no++;
        }
    }
        ?>
      </tbody>
    </table>
  </div>
</div>

<!-- page script -->
<script type="text/javascript">
$(document).ready(function() {
    $('#tgl1').focus();
});
</script>

<!-- Tanggal Picker -->
<link href="../template/bootstrap_date_time/css/bootstrap-datetimepicker.min.css" rel="stylesheet" type="text/css" />
<script src="../template/bootstrap_date_time/js/bootstrap-datetimepicker.min.js" type="text/javascript"></script>
<script src="../template/bootstrap_date_time/js/locales/bootstrap-datetimepicker.id.js" type="text/javascript"></script>

<script type="text/javascript">
$(document).ready(function() {
$(".dtpicker").datetimepicker({
    language:  'id',
    weekStart: 1,
    autoclose: true,
    todayBtn: true,
    todayHighlight: true,
    pickerPosition: 'bottom-right',
    format: "dd MM yyyy",
    linkField: "tgl_lahir",
    linkFormat: "yyyy-mm-dd",
    startView: 2,
     minView: 2
  });
}); // ready
</script>

<?php
} // if ok empty ?>