<!-- 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>