<div class="row">
<div class="col-xs-12">
<!-- PAGE CONTENT BEGINS -->
<div class="row">
<div class="col-xs-12"> <?php
if(isset($_GET['skid'])){
require_once "view_sk_internal_detail.php";
}else{
/* PAGINATION */
$batas = 20;
$pg = isset( $_GET['halaman'] ) ? $_GET['halaman'] : "";
if(empty($pg)){
$posisi = 0;
$pg = 1;
}else{
$posisi = ($pg-1) * $batas;
}
/* END PAGINATION */
if(isset($_GET['keyword'])){
$keyword = "%".$_GET['keyword']."%";
$params = array(
':pembuat' => $keyword,
':noref' => $keyword,
':perihal' => $keyword
);
$admins = $_SESSION['hakakses'] == "Admin" ? "" : "AND tujuan LIKE '%".$_SESSION['id_user_help']."%'";
$arsip_sk = $this->model->selectprepare("surat_keluar_internal", $field=null, $params, "pembuat LIKE :pembuat
OR (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 surat_keluar_internal 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 = surat_keluar_internal.id_sk) LIKE :noref
OR perihal LIKE :perihal", $admins." order by tgl_agenda DESC LIMIT $posisi, $batas");
$arsip_sk2 = $this->model->selectprepare("surat_keluar_internal", $field=null, $params, "pembuat LIKE :pembuat
OR (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 surat_keluar_internal 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 = surat_keluar_internal.id_sk) LIKE :noref
OR perihal LIKE :perihal", $admins);
}else{
$field = array("id_sk","DATE_FORMAT(tgl_agenda, '%Y') as thn");
$lastData = $this->model->selectprepare("surat_keluar_internal", $field, $params=null, $where=null, "GROUP BY DATE_FORMAT(tgl_agenda, '%Y') order by DATE_FORMAT(tgl_agenda, '%Y') DESC LIMIT 1");
$dataLast = $lastData->fetch(PDO::FETCH_OBJ);
if(isset($_GET['yearsk'])){
$params = array(':year' => $_GET['yearsk']);
}else{
$params = array(':year' => $dataLast->thn);
}
$admins = $_SESSION['hakakses'] == "Admin" ? "" : "AND tujuan LIKE '%".$_SESSION['id_user_help']."%'";
$arsip_sk = $this->model->selectprepare("surat_keluar_internal", $field=null, $params, "DATE_FORMAT(tgl_agenda, '%Y')=:year", $admins." order by tgl_agenda DESC LIMIT $posisi, $batas");
$arsip_sk2 = $this->model->selectprepare("surat_keluar_internal", $field=null, $params, "DATE_FORMAT(tgl_agenda, '%Y')=:year", $admins." order by tgl_agenda DESC");
}
if($arsip_sk->rowCount() >= 1){
while($data_sk = $arsip_sk->fetch(PDO::FETCH_OBJ)){
$dump_sk[]=$data_sk;
}?>
<!--Modal Preview PDF-->
<div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
<div class="modal-dialog modal-lg">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal"><span aria-hidden="true">×</span><span class="sr-only">Close</span></button>
<h4 class="modal-title" id="myModalLabel">Preview Surat Keluar</h4>
</div>
<div class="modal-body" style="height: 450px;"></div>
<div class="modal-footer">
<button type="button" class="btn btn-primary" data-dismiss="modal">Close</button>
</div>
</div>
</div>
</div>
<!--Modal Preview PDF-->
<table id="simple-table" class="table table-bordered table-hover">
<thead>
<tr>
<th width="50">No</th>
<th width="200">No Agenda</th>
<th>Perihal</th>
<th width="100">Tgl Surat</th>
<th class="detail-col" width="40">Detail</th>
</tr>
</thead>
<tbody><?php
$no=1+$posisi;
foreach($dump_sk as $key => $object){
$tglsrt = explode("-", $object->tgl_agenda);
$tglsrt = $tglsrt[2]."-".$tglsrt[1]."-".$tglsrt[0];
$tujuan = json_decode($object->tujuan, true); ?>
<tr>
<td><?php echo $no;?></td>
<td><a href="./index.php?op=sk_internal&skid=<?php echo $object->id_sk;?>"><?php echo $this->model->noref_sm($object->id_sk, "internal"); ?></a></td>
<td><?php echo $object->perihal;?></td>
<td><?php echo $tglsrt;?></td>
<td class="center">
<div class="action-buttons">
<a href="#" class="green bigger-140 show-details-btn" title="Show Details">
<i class="ace-icon fa fa-angle-double-down"></i>
<span class="sr-only">Details</span>
</a>
</div>
</td>
</tr>
<tr class="detail-row">
<td colspan="12">
<div class="table-detail">
<div class="row">
<div class="col-xs-12 col-sm-12">
<div class="space visible-xs"></div>
<div class="profile-user-info profile-user-info-striped">
<div class="profile-info-row">
<div class="profile-info-name"> No Agenda </div>
<div class="profile-info-value"><span><a href="./index.php?op=sk_internal&skid=<?php echo $object->id_sk;?>"><?php echo $this->model->noref_sm($object->id_sk, "internal");?></a></span></div>
</div>
<div class="profile-info-row">
<div class="profile-info-name"> Tgl Surat </div>
<div class="profile-info-value"><span><?php echo $tglsrt;?></span></div>
</div>
<div class="profile-info-row">
<div class="profile-info-name"> Pembuat </div>
<div class="profile-info-value"><span><?php echo $object->pembuat;?></span></div>
</div>
<div class="profile-info-row">
<div class="profile-info-name"> Perihal </div>
<div class="profile-info-value"><span><?php echo $object->perihal;?></span></div>
</div>
<div class="profile-info-row">
<div class="profile-info-name"> Tujuan </div>
<div class="profile-info-value"><span>
<?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/>';
}
}?>
</span></div>
</div>
<div class="profile-info-row">
<div class="profile-info-name"> File Surat </div>
<div class="profile-info-value">
<span><?php
if($object->file != ""){?>
<a href="./berkas/<?php echo $object->file;?>" target="_blank">Lihat File Surat</a><?php
}else{ ?>
- <?php
}?>
</span>
</div>
</div>
</div>
</div>
</div>
</div>
</td>
</tr><?php
$no++;
}?>
</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>
</div><?php
}
/* PAGINATION */
//hitung jumlah data
if(isset($_GET['keyword'])){
$jml_data = $arsip_sk2->rowCount();
$link_order="&keyword=$_GET[keyword]";
}else{
if(isset($_GET['yearsk'])){
$params = array(':year' => $_GET['yearsk']);
$link_order="&yearsk=$_GET[yearsk]";
}else{
$params = array(':year' => $dataLast->thn);
$link_order="";
}
//$jlhdata = $this->model->selectprepare("surat_keluar_internal", $field=null, $params, "DATE_FORMAT(tgl_agenda, '%Y')=:year", $other=null);
$jml_data = $arsip_sk2->rowCount();
}
//Jumlah halaman
$JmlHalaman = ceil($jml_data/$batas);
//Navigasi ke sebelumnya
if($pg > 1){
$link = $pg-1;
$prev = "index.php?op=sk_internal&halaman=$link$link_order";
$prev_disable = " ";
}else{
$prev = "#";
$prev_disable = "disabled";
}
//Navigasi ke selanjutnya
if($pg < $JmlHalaman){
$link = $pg + 1;
$next = "index.php?op=sk_internal&halaman=$link$link_order";
$next_disable = " ";
}else{
$next = "#";
$next_disable = "disabled";
}
if($batas < $jml_data){?>
<ul class="pager">
<li class="previous <?php echo $prev_disable;?>"><a href="<?php echo $prev;?>">← Sebelumnya </a></li>
<li class="next <?php echo $next_disable;?>"><a href="<?php echo $next;?>">Selanjutnya →</a></li>
</ul>
<span class="text-muted">Halaman <?php echo $pg;?> dari <?php echo $JmlHalaman;?> (Total : <?php echo $jml_data;?> records)</span> <?php
}
/* END PAGINATION */
}?>
</div><!-- /.span -->
</div><!-- /.row -->
<!-- PAGE CONTENT ENDS -->
</div><!-- /.col -->
</div><!-- /.row -->
<script src="assets/js/jquery-2.1.4.min.js"></script>
<!-- page specific plugin scripts -->
<script src="assets/js/jquery.dataTables.min.js"></script>
<script src="assets/js/jquery.dataTables.bootstrap.min.js"></script>
<script src="assets/js/dataTables.buttons.min.js"></script>
<script src="assets/js/buttons.flash.min.js"></script>
<script src="assets/js/buttons.html5.min.js"></script>
<script src="assets/js/buttons.print.min.js"></script>
<script src="assets/js/buttons.colVis.min.js"></script>
<script src="assets/js/dataTables.select.min.js"></script>
<!-- inline scripts related to this page -->
<script type="text/javascript">
jQuery(function($) {
//select/deselect a row when the checkbox is checked/unchecked
$('#simple-table').on('click', 'td input[type=checkbox]' , function(){
var $row = $(this).closest('tr');
if($row.is('.detail-row ')) return;
if(this.checked) $row.addClass(active_class);
else $row.removeClass(active_class);
});
/***************/
$('.show-details-btn').on('click', function(e) {
e.preventDefault();
$(this).closest('tr').next().toggleClass('open');
$(this).find(ace.vars['.icon']).toggleClass('fa-angle-double-down').toggleClass('fa-angle-double-up');
});
/***************/
})
</script>