<?php
$active1 = isset($_GET['sm']) ? "active" : "";
$active2 = isset($_GET['sk']) ? "active" : "";
$active3 = isset($_GET['ski']) ? "active" : "";
$active4 = isset($_GET['setting']) ? "active" : "";
$userid = $_SESSION['id_user'];
if(isset($_GET['sk']) AND isset($_GET['add_sk'])){
require_once "entry_sk.php";
}elseif(isset($_GET['sm']) AND isset($_GET['add_sm'])){
require_once "entry_sm.php";
}elseif(isset($_GET['ski']) AND isset($_GET['add_ski'])){
require_once "entry_sk_internal.php";
} else{
?>
<div class="row">
<div class="col-xs-12">
<!-- PAGE CONTENT BEGINS -->
<div class="row">
<div class="col-xs-12">
<a href="./index.php?op=surat_digital&sm" title="Surat Masuk Eksternal">
<button class="btn btn-white btn-info btn-bold <?php echo $active1; ?>">
<i class="ace-icon fa fa-cog bigger-120 blue"></i>Surat Masuk Eksternal
</button>
</a>
<a href="./index.php?op=surat_digital&ski" title="Surat Keluar Internal">
<button class="btn btn-white btn-info btn-bold <?php echo $active3; ?>">
<i class="ace-icon fa fa-cog bigger-120 blue"></i>Surat Keluar Internal
</button>
</a>
<a href="./index.php?op=surat_digital&sk" title="Surat Keluar Eksternal">
<button class="btn btn-white btn-info btn-bold <?php echo $active2; ?>">
<i class="ace-icon fa fa-cog bigger-120 blue"></i>Surat Keluar Eksternal
</button>
</a>
<a href="./index.php?op=surat_digital&setting" title="Setting Surat Masuk / Keluar">
<button class="btn btn-white btn-info btn-bold <?php echo $active4; ?>">
<i class="ace-icon fa fa-cog bigger-120 blue"></i>Setting Surat
</button>
</a>
<?php if(isset($_GET['sk'])) {
$arsip_sk = $this->model->selectprepare("surat_keluar", $field=null, $params=null, $where=null, "WHERE surat_keluar.id_user = '".$userid."' order by tgl_agenda DESC");
if($arsip_sk->rowCount() >= 1){
while($data_sk = $arsip_sk->fetch(PDO::FETCH_OBJ)){
$dump_sk[]=$data_sk;
}
?>
<hr>
<a href="./index.php?op=surat_digital&sk&add_sk" title="Tambah Surat Keluar Eksternal">
<button class="btn btn-white btn-info btn-bold <?php echo $active1; ?>">
<i class="ace-icon glyphicon glyphicon-plus"></i>Tambah
</button>
</a>
<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>
<th width="100">Aksi</th>
</tr>
</thead>
<tbody>
<?php
$no=1;
foreach($dump_sk as $key => $object){
$tglsrt = explode("-", $object->tgl_agenda);
$tglsrt = $tglsrt[2]."-".$tglsrt[1]."-".$tglsrt[0];
$tembusan = json_decode($object->tembusan, true); ?>
<tr>
<td><?php echo $no;?></td>
<td><a href="./index.php?op=sk&skid=<?php echo $object->id_sk;?>"><?php echo $this->model->noref($object->id_sk); ?></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>
<td align="center">
<?php if($HakAkses->sk == "W"){ ?>
<div class="hidden-sm hidden-xs btn-group">
<a href="./index.php?op=add_sk&skid=<?php echo $object->id_sk;?>">
<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'){?>
<a href="./index.php?op=sk&skid=<?php echo $object->id_sk;?>&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 } ?>
<a href="./index.php?op=print_sm&skid=<?php echo $object->id_sk;?>">
<button class="btn btn-minier btn-info">
<i class="ace-icon fa fa-file-o bigger-110"></i>
</button>
</a>
</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&skid=<?php echo $object->id_sk;?>"><?php echo $this->model->noref($object->id_sk);?></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 echo $object->tujuan;?></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"> Tembusan </div>
<div class="profile-info-value"><span>
<?php
if(is_array($tembusan)){
foreach($tembusan 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>
</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>
<a href="./index.php?op=surat_digital&sk&add_sk" title="Tambah Surat Keluar Eksternal">
<button class="btn btn-white btn-info btn-bold <?php echo $active1; ?>">
<i class="ace-icon glyphicon glyphicon-plus"></i>Tambah
</button>
</a>
<?php }
}elseif(isset($_GET['ski'])){
$arsip_sk = $this->model->selectprepare("surat_keluar_internal a", $field=null, $params=null, $where=null, "WHERE a.id_user= '".$userid."' order by a.tgl_agenda DESC");
if($arsip_sk->rowCount() >= 1){
while($data_sk = $arsip_sk->fetch(PDO::FETCH_OBJ)){
$dump_sk[]=$data_sk;
}
?>
<hr>
<a href="./index.php?op=surat_digital&ski&add_ski" title="Tambah Surat Keluar Internal">
<button class="btn btn-white btn-info btn-bold <?php echo $active1; ?>">
<i class="ace-icon glyphicon glyphicon-plus"></i>Tambah
</button>
</a>
<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>
<th width="100">Aksi</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);
//$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><?php echo $no;?></td>
<td><a href="./index.php?op=sk_internal&skid=<?php echo $object->id_sk;?>"><?php echo $this->model->noref($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>
<td align="center">
<?php if($HakAkses->sk_internal == "W"){ ?>
<div class="hidden-sm hidden-xs btn-group">
<a href="./index.php?op=add_sk_internal&skid=<?php echo $object->id_sk;?>">
<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'){?>
<a href="./index.php?op=sk_internal&skid=<?php echo $object->id_sk;?>&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 } ?>
<a href="./index.php?op=print_sm&skiid=<?php echo $object->id_sk;?>">
<button class="btn btn-minier btn-info">
<i class="ace-icon fa fa-file-o bigger-110"></i>
</button>
</a>
</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($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>
<a href="./index.php?op=surat_digital&ski&add_ski" title="Tambah Surat Keluar Internal">
<button class="btn btn-white btn-info btn-bold <?php echo $active1; ?>">
<i class="ace-icon glyphicon glyphicon-plus"></i>Tambah
</button>
</a>
<?php }
} elseif(isset($_GET['sm'])){
$arsip_sm = $this->model->selectprepare("surat_masuk", $field=null, $params=null, $where=null, "WHERE surat_masuk.id_user = '".$userid."' order by tgl_agenda DESC");
if($arsip_sm->rowCount() >= 1){
while($data_sm = $arsip_sm->fetch(PDO::FETCH_OBJ)){
$dump_sm[]=$data_sm;
}
?>
<hr>
<a href="./index.php?op=surat_digital&sm&add_sm" title="Tambah Surat Masuk Eksternal">
<button class="btn btn-white btn-info btn-bold">
<i class="ace-icon glyphicon glyphicon-plus"></i>Tambah
</button>
</a>
<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 = "";
}?>
<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;?>
</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"){ ?>
<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'){?>
<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 } ?>
<a href="./index.php?op=print_sm&smid=<?php echo $object->id_sm;?>">
<button class="btn btn-minier btn-info">
<i class="ace-icon fa fa-file-o bigger-110"></i>
</button>
</a>
</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', '(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>
</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>
<a href="./index.php?op=surat_digital&sm&add_sm" title="Tambah Surat Masuk Eksternal">
<button class="btn btn-white btn-info btn-bold <?php echo $active1; ?>">
<i class="ace-icon glyphicon glyphicon-plus"></i>Tambah
</button>
</a>
<?php }
} elseif(isset($_GET['setting'])){
require_once "view_surat_digital_setting.php";
}
?>
</div>
</div>
</div>
</div>
<?php } ?>
<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>