<div class="row">
<div class="col-xs-12">
<!-- PAGE CONTENT BEGINS -->
<div class="row">
<div class="col-xs-12"><?php
if(isset($_GET['smid'])){
require_once "view_sm_detail_sekretaris.php";
}else{
/* PAGINATION */
$batas = 15;
$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(':noref' => $keyword, ':no_sm' => $keyword, ':asal_sm' => $keyword, ':perihal' => $keyword);
$arsip_sm = $this->model->selectprepare("surat_masuk", $field=null, $params, "no_sm LIKE :no_sm OR asal_sm LIKE :asal_sm
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_masuk a left join kode_masalah b ON b.id = a.kodemasalahid left join unit_kerja c ON c.id = a.unitkerjaid WHERE a.id_sm = surat_masuk.id_sm) LIKE :noref
OR perihal LIKE :perihal OR no_sm LIKE :no_sm and (unitkerjaid='".$_SESSION['unitkerjaid']."' or unitkerjaid = (SELECT unitkerjaid FROM user WHERE id_user='".$_SESSION['id_user']."') or id_user = '".$_SESSION['id_user']."' )", "order by tgl_agenda DESC LIMIT $posisi, $batas");
$arsip_sm2 = $this->model->selectprepare("surat_masuk", $field=null, $params, "no_sm LIKE :no_sm OR asal_sm LIKE :asal_sm
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_masuk a left join kode_masalah b ON b.id = a.kodemasalahid left join unit_kerja c ON c.id = a.unitkerjaid WHERE a.id_sm = surat_masuk.id_sm) LIKE :noref
OR perihal LIKE :perihal OR no_sm LIKE :no_sm and (unitkerjaid='".$_SESSION['unitkerjaid']."' or unitkerjaid = (SELECT unitkerjaid FROM user WHERE id_user='".$_SESSION['id_user']."') or id_user = '".$_SESSION['id_user']."' )", $other=null);
}else{
$field = array("id_sm","DATE_FORMAT(tgl_agenda, '%Y') as thn");
$lastData = $this->model->selectprepare("surat_masuk", $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['yearsm'])){
$params = array(':year' => $_GET['yearsm']);
}else{
$params = array(':year' => $dataLast->thn);
}
$arsip_sm = $this->model->selectprepare("surat_masuk", $field=null, $params, "(status_draft <> 0 or id_user = '".$_SESSION['id_user']."') and DATE_FORMAT(tgl_agenda, '%Y')=:year and (unitkerjaid='".$_SESSION['unitkerjaid']."' or unitkerjaid = (SELECT unitkerjaid FROM user WHERE id_user='".$_SESSION['id_user']."') or (id_user = '".$_SESSION['id_user']."' OR tujuan_surat LIKE '%".$_SESSION['nip']."%') )", "order by id_sm DESC LIMIT $posisi, $batas");
}
if($arsip_sm->rowCount() >= 1){
while($data_sm = $arsip_sm->fetch(PDO::FETCH_OBJ)){
$dump_sm[]=$data_sm;
}?>
<!--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 Masuk</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>
<?php if($HakAkses->sm == "W"){ ?>
<a href="./index.php?op=add_sm" title="Tambah Surat Eksternal">
<button class="btn btn-white btn-info btn-bold">
<i class="ace-icon glyphicon glyphicon-plus"></i>Tambah Surat
</button>
</a>
<?php } ?>
<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="120">Tgl Terima</th>
<th class="detail-col">Details</th>
<th width="100">Aksi</th>
</tr>
</thead>
<tbody><?php
$no=1+$posisi;
foreach($dump_sm as $key => $object){
$params = array(':id_sm' => $object->id_sm, ':status' => '0');
$cekDisposisi = $this->model->selectprepare("memo a join user b on a.id_user=b.id_user", $field=null, $params, "a.id_sm=:id_sm AND a.status=:status");
$tglSrt = explode("-", $object->tgl_sm);
$tglSrt = $tglSrt[2]."-".$tglSrt[1]."-".$tglSrt[0];
$tgltrm = explode("-", $object->tgl_terima);
$tgltrm = $tgltrm[2]."-".$tgltrm[1]."-".$tgltrm[0];
$tujuan = json_decode($object->tujuan_surat, true);
$params = array(':id_sm' => $object->id_sm, ':kode' => 'SM');
$lihat_sm = $this->model->selectprepare("surat_read", $field=null, $params, "id_sm=:id_sm AND kode=:kode");
if($lihat_sm->rowCount() <= 0){
$labelstatus = "";
}else{
$labelstatus = "<i class=\"ace-icon fa fa-check bigger-110 green\" title=\"was read\"></i>";
}
$params1 = array(':id_sm' => $object->id_sm, ':status' => '0');
$CekStatFinish = $this->model->selectprepare("status_surat a join user b on a.id_user=b.id_user", $field=null, $params1, "a.id_sm=:id_sm AND a.status=:status", "ORDER BY a.id_status DESC LIMIT 1");
if($CekStatFinish->rowCount() >= 1){
$dataCekStatFinish = $CekStatFinish->fetch(PDO::FETCH_OBJ);
if($dataCekStatFinish->statsurat == 1){
$ProgresStat = " <i class=\"ace-icon fa fa-history bigger-110 green\" title=\"Surat sedang ditindaklanjuti\"></i>";
}elseif($dataCekStatFinish->statsurat == 2){
$ProgresStat = " <i class=\"ace-icon fa fa-thumbs-o-up bigger-110 green\" title=\"Surat sudah selesai ditindaklanjuti\"></i>";
}elseif($dataCekStatFinish->statsurat == 0){
$ProgresStat = " <i class=\"ace-icon fa fa-times bigger-110 green\" title=\"Surat tidak dapat diproses\"></i>";
}
}else{
$ProgresStat = " <i class=\"ace-icon fa fa-info bigger-110 green\" title=\"Surat belum diproses\"></i>";
}
if($cekDisposisi->rowCount() >= 1){
//$data_cek = $cek_memo->fetch(PDO::FETCH_OBJ);
$labelDis = " <i class=\"ace-icon fa fa-share bigger-110 green\" title=\"Telah di Disposisi\"></i>";
}else{
$labelDis = "";
}
$draft = "";
if($object->status_draft == 0){
$draft = " <span style='color:#ff0000'>draft</span>";
}
?>
<tr>
<td><?php echo $no;?></td>
<td>
<a href="./index.php?op=sm&smid=<?php echo $object->id_sm;?>"><?php echo $this->model->noref_sm($object->id_sm); ?></a>
<?php echo $labelstatus;?>
<?php echo $labelDis;?>
<?php echo $ProgresStat;?>
<?php echo $draft;?>
</td>
<td><?php echo $object->perihal;?></td>
<td><?php echo $tgltrm;?></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>
<td align="center">
<?php if($HakAkses->sm == "W" and $object->status_draft == "0"){ ?>
<div class="hidden-sm hidden-xs btn-group">
<a href="./index.php?op=add_sm&smid=<?php echo $object->id_sm;?>">
<button class="btn btn-minier btn-info">
<i class="ace-icon fa fa-pencil bigger-100"></i>
</button>
</a>
<?php if(($_SESSION['id_user'] == '1' or $_SESSION['hakakses'] == 'Admin') AND $object->status_draft == "0"){?>
<a href="./index.php?op=sm&smid=<?php echo $object->id_sm;?>&act=del" onclick="return confirm('Anda yakin akan menghapus data ini??')">
<button class="btn btn-minier btn-danger">
<i class="ace-icon fa fa-trash-o bigger-110"></i>
</button>
</a>
<?php } ?>
</div>
<?php } ?>
</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=sm&smid=<?php echo $object->id_sm;?>"><?php echo $this->model->noref_sm($object->id_sm);?></a></span></div>
</div>
<div class="profile-info-row">
<div class="profile-info-name"> Nomor surat </div>
<div class="profile-info-value"><span><?php echo $object->no_sm;?></span></div>
</div>
<div class="profile-info-row">
<div class="profile-info-name"> Asal Surat </div>
<div class="profile-info-value"><span><?php echo $object->asal_sm;?></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"> Tanggal Surat </div>
<div class="profile-info-value"><span><?php echo $tglSrt;?></span></div>
</div>
<div class="profile-info-row">
<div class="profile-info-name"> Tanggal Terima </div>
<div class="profile-info-value"><span><?php echo $tgltrm;?></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 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_user', 'jabatan');
$GetUserDis = $this->model->selectprepare("tag", $field, $params=null, $where=null, "WHERE nip='".$value."' ")->fetch(PDO::FETCH_OBJ);
echo '- '.$GetUserDis->nama_user.' ('.$GetUserDis->jabatan.') <br/>';
}
}?>
</span></div>
</div>
<div class="profile-info-row">
<div class="profile-info-name"> Tembusan surat </div>
<div class="profile-info-value"><span>
<?php
$cekTembusan = $this->model->selectprepare("tbl_tembusan_sm", $field=null, $params=null, $where=null, "WHERE id_sm='".$object->id_sm."' ");
//var_dump($cekTembusan);
$arrtembusan = $cekTembusan->fetch(PDO::FETCH_OBJ);
$tembusan = json_decode($arrtembusan->tembusan, true);
if(is_array($tembusan)){
foreach($tembusan as $field => $value){
$field = array('nama_user', 'jabatan');
$GetUserDis = $this->model->selectprepare("tag", $field, $params=null, $where=null, "WHERE nip='".$value."' ")->fetch(PDO::FETCH_OBJ);
echo '- '.$GetUserDis->nama_user.' ('.$GetUserDis->jabatan.') <br/>';
}
}
?>
</span></div>
</div>
</div>
</div>
</div>
</div>
</td>
</tr><?php
$no++;
}?>
</tbody>
</table><?php
}else{
if($HakAkses->sm == "W"){ ?>
<a href="./index.php?op=add_sm" title="Tambah Surat Eksternal">
<button class="btn btn-white btn-info btn-bold">
<i class="ace-icon glyphicon glyphicon-plus"></i>Tambah Surat
</button>
</a>
<?php } ?>
<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_sm2->rowCount();
$link_order="&keyword=$_GET[keyword]";
}else{
if(isset($_GET['yearsm'])){
$params = array(':year' => $_GET['yearsm']);
$link_order="&yearsm=$_GET[yearsm]";
}else{
$params = array(':year' => $dataLast->thn);
$link_order="";
}
$jlhdata = $this->model->selectprepare("surat_masuk", $field=null, $params, "DATE_FORMAT(tgl_agenda, '%Y')=:year", $other=null);
$jml_data = $jlhdata->rowCount();
}
//Jumlah halaman
$JmlHalaman = ceil($jml_data/$batas);
//Navigasi ke sebelumnya
if($pg > 1){
$link = $pg-1;
$prev = "index.php?op=sm&halaman=$link$link_order";
$prev_disable = " ";
}else{
$prev = "#";
$prev_disable = "disabled";
}
//Navigasi ke selanjutnya
if($pg < $JmlHalaman){
$link = $pg + 1;
$next = "index.php?op=sm&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>