<!-- PAGE CONTENT BEGINS -->
<form class="form-horizontal" role="form" method="POST" name="formku" action="<?php echo $_SESSION['url'];?>">
<div class="row">
<div class="col-sm-12">
<div class="widget-box">
<div class="widget-header">
<h4 class="widget-title">Laporan Surat Keluar</h4>
<span class="widget-toolbar">
<a href="#" data-action="collapse">
<i class="ace-icon fa fa-chevron-up"></i>
</a>
<a href="#" data-action="close">
<i class="ace-icon fa fa-times"></i>
</a>
</span>
</div>
<div class="widget-body">
<div class="widget-main">
<div class="row">
<div class="col-xs-6 col-sm-6">
<label>Pilih Surat Keluar</label>
<select class="form-control" id="jenis_surat" name="jenis_surat">
<!--option value="">== Pilih ==</option-->
<option value="surat_keluar_internal" <?php if(isset($_POST['jenis_surat'])){
echo $_POST['jenis_surat'] == "surat_keluar_internal" ? "selected='selected'" : "";
}?>>Surat Keluar Internal</option>
<option value="surat_keluar" <?php if(isset($_POST['jenis_surat'])){
echo $_POST['jenis_surat'] == "surat_keluar" ? "selected='selected'" : "";
}?>>Surat Keluar Eksternal</option>
</select>
</div>
<div class="col-xs-5 col-sm-5">
<label>Filter berdasarkan Range Tanggal</label>
<div class="input-group">
<span class="input-group-addon">
<i class="fa fa-calendar bigger-110"></i>
</span>
<input class="form-control" type="text" name="rangetgl" id="rangetgl" value="<?= isset($_POST['rangetgl']) ? $_POST['rangetgl'] : ""; ?>" disabled="disabled" />
<input type="hidden" name="rangetgl_hid" value="<?= isset($_POST['rangetgl']) ? $_POST['rangetgl'] : ""; ?>">
</div>
</div>
<div class="col-xs-1 col-sm-1">
<label><br></label>
<div class="">
<input name="checkrangetgl" id="checkrangetgl" type="checkbox" class="ace" value="1" checked='checked'/>
<span class="lbl"> </span>
<span class="help-button" data-rel="popover" data-trigger="hover" data-placement="left" data-content="Checklist pada tombol yang tersedia untuk mengaktifkan filter tanggal seluruhnya." title="Filter Tanggal">?</span>
</div>
</div>
</div>
<div class="space-6"></div>
<div class="row">
<div class="col-xs-4 col-sm-4">
<label>Filter Nomor Agenda</label>
<div class="">
<input class="form-control" placeholder="Nomor Agenda" type="text" name="no_agenda" id="no_agenda" value="<?= isset($_POST['no_agenda']) ? $_POST['no_agenda'] : ''; ?>" />
</div>
</div>
<div class="col-xs-2 col-sm-2">
<label><br/></label>
<select class="form-control" id="andor_no_agenda" name="andor_no_agenda">
<option value="AND" <?php if(isset($_POST['andor_no_agenda'])){
echo $_POST['andor_no_agenda'] == "AND" ? "selected='selected'" : "";
}?> >AND</option>
<option value="OR" <?php if(isset($_POST['andor_no_agenda'])){
echo $_POST['andor_no_agenda'] == "OR" ? "selected='selected'" : "";
}?>>OR</option>
</select>
</div>
<div class="col-xs-4 col-sm-4">
<label>Filter Perihal</label>
<div class="">
<input class="form-control" placeholder="Perihal Surat" type="text" name="perihal" id="perihal" value="<?= isset($_POST['perihal']) ? $_POST['perihal'] : ''; ?>"/>
</div>
</div>
<div class="col-xs-2 col-sm-2">
<label><br/></label>
<select class="form-control" id="andor_perihal" name="andor_perihal">
<option value="AND" <?php if(isset($_POST['andor_perihal'])){
echo $_POST['andor_perihal'] == "AND" ? "selected='selected'" : "";
}?>>AND</option>
<option value="OR" <?php if(isset($_POST['andor_perihal'])){
echo $_POST['andor_perihal'] == "OR" ? "selected='selected'" : "";
}?>>OR</option>
</select>
</div>
</div>
<div class="space-6"></div>
<div class="row">
<div class="col-xs-12 col-sm-12">
<div class="input-group">
<button type="submit" class="btn btn-info" type="button">
<i class="ace-icon fa fa-check bigger-110"></i>
Submit
</button>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</form>
<?php
if($_SERVER["REQUEST_METHOD"] == "POST"){?>
<div class="row">
<div class="col-sm-12">
<div class="widget-box">
<div class="widget-body">
<div class="widget-main"><?php
$jenis_surat = $_POST['jenis_surat'];
$checkrangetgl = isset($_POST['checkrangetgl']) ? $_POST['checkrangetgl'] : '0';
$where_go = " ";
$where_tgl = "";
if($checkrangetgl == 0){
$from = explode("/", substr($_POST['rangetgl'],0,10));
$tglfrom = htmlspecialchars($from[2]."-".$from[0]."-".$from[1]);
$to = explode("/", substr($_POST['rangetgl'],-10));
$tglto = htmlspecialchars($to[2]."-".$to[0]."-".$to[1]);
$where_go = "where ";
$where__ .= " tgl_agenda between '".$tglfrom."' and '".$tglto."' ";
}
if ($_POST['no_agenda'] != "") {
$where_go = "where ";
$where__ .= $checkrangetgl == 0 ? $_POST['andor_no_agenda'] : "";
$where__ .= " (SELECT (CONCAT(b.kode_masalah, '.', b.primer, '.', b.sekunder, '/', c.kode1, '.', c.kode2, '.', lpad(a.no_agenda,5,'0'), '/', DATE_FORMAT(a.tgl_agenda, '%Y'))) as noref FROM ".$jenis_surat." a left join kode_masalah b ON b.id = a.kodemasalahid left join unit_kerja c ON c.id = a.unitkerjaid WHERE a.id_sk = ".$jenis_surat.".id_sk) LIKE '%".$_POST['no_agenda']."%' ";
}
if ($_POST['perihal'] != "") {
$where_go = "where ";
$where__ .= $checkrangetgl == 0 || $_POST['no_agenda'] != "" ? $_POST['andor_perihal'] : "";
$where__ .= " perihal LIKE '%".$_POST['perihal']."%'";
}
$field = array("*", "'".$_POST['jenis_surat']."' as jenis_surat");
$arsip_sm = $this->model->selectprepare($jenis_surat, $field, $params=null, $where=null, $where_go.$where__." order by tgl_agenda ASC");
if($arsip_sm->rowCount() >= 1){
while($data_sm = $arsip_sm->fetch(PDO::FETCH_OBJ)){
$dump_sm[]=$data_sm;
}?>
<center><h4>Data Surat Keluar <b><?php if(isset($_POST['rangetgl'])){ echo tgl_indo($tglfrom);?></b> s/d <b><?php echo tgl_indo($tglto); }?></b></h4></center>
<table id="simple-table" class="table table-bordered table-hover">
<thead>
<tr>
<th width="40">No</th>
<th width="200">No Agenda</th>
<th width="150">Tgl Surat</th>
<th width="140">Pengolah</th> <th width="200">Tujuan Surat</th>
<th width="200">Perihal</th>
</tr>
</thead>
<tbody><?php
$no=1;
foreach($dump_sm as $key => $object){
if ($object->jenis_surat == 'surat_keluar') {
$no_agenda = $this->model->noref($object->id_sk);
$tujuan = $object->tujuan;
} else {
$no_agenda = $this->model->noref($object->id_sk, "internal");
$tujuan = json_decode($object->tujuan, true);
}
$tglsurat = explode("-", $object->tgl_agenda);
$tglsurat = $tglsurat[2]."/".$tglsurat[1]."/".$tglsurat[0];
//$CekKlasifikasi = $this->model->selectprepare("klasifikasi_sk", $field=null, $params=null, $where=null, "WHERE id_klas='$object->klasifikasi'");
//$ViewKlasifikasi = $CekKlasifikasi->fetch(PDO::FETCH_OBJ);?>
<tr>
<td><center><?php echo $no;?></center></td>
<td><?php echo $no_agenda;?></td>
<td><?php echo $tglsurat;?></td>
<td><?php echo $object->pembuat;?></td>
<td><?php
if(is_array($tujuan)){
foreach($tujuan as $field => $value){
$field = array('nama', '(SELECT nama FROM unit_kerja WHERE unit_kerja.id = user.unitkerjaid) as unit_kerja');
$GetUserDis = $this->model->selectprepare("user", $field, $params=null, $where=null, "WHERE id_user='".$value."' ")->fetch(PDO::FETCH_OBJ);
echo '- '.$GetUserDis->nama.' ('.$GetUserDis->unit_kerja.') <br/>';
}
} else {
echo $tujuan;
}?>
</td>
<td><?php echo $object->perihal;?></td>
</tr><?php
$no++;
}?>
<tr>
<td colspan='6'>
<form method="POST" name="formku" action="./index.php?op=report_sk_print">
<input type="hidden" name="jenis_surat" value="<?=$jenis_surat;?>">
<input type="hidden" name="tglfrom" value="<?=$tglfrom;?>">
<input type="hidden" name="tglto" value="<?=$tglto;?>">
<input type="hidden" name="checkrangetgl" value="<?=$checkrangetgl;?>">
<input type="hidden" name="no_agenda" value="<?=$_POST['no_agenda'];?>">
<input type="hidden" name="andor_no_agenda" value="<?=$_POST['andor_no_agenda'];?>">
<input type="hidden" name="perihal" value="<?=$_POST['perihal'];?>">
<input type="hidden" name="andor_perihal" value="<?=$_POST['andor_perihal'];?>">
<button type="submit" name="print" value="print" class="label label-xs label-primary label-white middle" type="button">
<b>Print</b> <i class="ace-icon fa fa-print align-top bigger-125 icon-on-right"></i>
</button>
<button type="submit" name="print" value="pdf" class="label label-xs label-danger label-white middle" type="button">
<b>Pdf</b> <i class="ace-icon fa fa-file-pdf-o align-top bigger-125 icon-on-right"></i>
</button>
</form>
</td>
</tr>
</tbody>
</table><?php
}else{?>
<div class="alert alert-danger">
<button type="button" class="close" data-dismiss="alert">
<i class="ace-icon fa fa-times"></i>
</button>
<p>
<strong><i class="ace-icon fa fa-check"></i>Perhatian!</strong>
Data tidak ditemukan. Terimakasih.
</p>
<p>
<a href="./index.php?op=report_sk"><button class="btn btn-minier btn-danger">Kembali</button></a>
</p>
</div><?php
}?>
</div>
</div>
</div>
</div>
</div><?php
}?>
<script src="assets/js/jquery-2.1.4.min.js"></script>
<script type="text/javascript">
$(document).ready(function() {
$('#checkrangetgl').on('click', function(e){
if(this.checked == true){
$("#rangetgl").attr("disabled",true);
}else{
$("#rangetgl").removeAttr("disabled");
}
});
});
</script>