simpro-rssa/app/st_jbel/tabel_daftar.php

<?php 
include("../koneksi.php");
$riwayat_jbel_id=$_POST['riwayat_jbel_id'];
$data_pegawai_id=$_POST['data_pegawai_id'];
$filter = isset($_POST['filter'])?$_POST['filter']:'';
?>
<br>
<table class="table table-bordered table-condensed"  id="tabel_data_daftar_us" style="font-family:'RubReg';font-size:13px">
<thead>
<tr style="text-align:center;color:black;font-weight:bold">
<td width="30px;">NO</td>
<td width="400px;">BERKAS</td>
<td width="10px;">#</td>
<td width="10px;">UPL</td>
<td width="160px;">STATUS BERKAS</td>
<td width="80px;">TGL UPLOAD</td>
<td width="80px;">TGL CEK</td>
<td width="70px;" style="display:none">CEKLIST</td>
<td width="140px;">KETERANGAN</td>

</tr>
</thead>
<tbody style="color:black">
<?php
$no=1;
/*
$d=pg_query("SELECT s.id,s.berkas,r1.st_ceklist,r1.status,r2.id,COALESCE(r1.id,0),r1.ket 
FROM syarat_jbel s
LEFT OUTER JOIN riwayat_syarat_jbel r1 ON (s.id=r1.syarat_jbel_id)
LEFT OUTER JOIN riwayat_jbel r2 ON (r2.id=$riwayat_jbel_id)
AND r2.data_pegawai_id=$data_pegawai_id
WHERE s.id IS NOT NULL
ORDER BY s.id ASC
");
*/
$where_sql = '';
if ($filter=='pns') {
	$where_sql = "WHERE s.asn='y'";
} else if ($filter=='pppk') {
	$where_sql = "WHERE s.pppk='y'";
}
$d=pg_query("SELECT s.id,s.berkas,b.st_ceklist,b.status,a.id,COALESCE(b.id,0),b.ket,a.data_pegawai_id,b.tgl_upload_dok,b.tgl_cek_dok
FROM syarat_jbel s
LEFT OUTER JOIN (
SELECT r1.*,r2.syarat_jbel_id
FROM riwayat_jbel r1
INNER JOIN riwayat_syarat_jbel r2 ON (r1.id=r2.riwayat_jbel_id)
WHERE r1.id=$riwayat_jbel_id
) a ON (s.id=a.syarat_jbel_id)
LEFT OUTER JOIN (
SELECT r2.*
FROM riwayat_jbel r1
INNER JOIN riwayat_syarat_jbel r2 ON (r1.id=r2.riwayat_jbel_id)
WHERE r1.id=$riwayat_jbel_id
) b ON (s.id=b.syarat_jbel_id)
" . $where_sql . " ORDER BY s.id ASC");
while($r=pg_fetch_array($d)) {
$syarat_jbel_id=$r[0];
$riwayat_jbel_id=$r[4];
$riwayat_syarat_jbel_id=$r[5];

$l=pg_query("SELECT COUNT(*)
FROM dok_syarat_jbel k INNER JOIN riwayat_syarat_jbel s ON (k.riwayat_syarat_jbel_id=s.id)
WHERE k.riwayat_syarat_jbel_id=$riwayat_syarat_jbel_id AND k.file NOT IN ('')");
while($rl=pg_fetch_array($l)) {$tf=$rl[0];}

$m=pg_query("SELECT COUNT(*)
FROM pesan_syarat_jbel k INNER JOIN riwayat_syarat_jbel s ON (k.riwayat_syarat_jbel_id=s.id)
WHERE k.riwayat_syarat_jbel_id=$riwayat_syarat_jbel_id AND k.baca='f'");
while($rm=pg_fetch_array($m)) {$tp=$rm[0];}
                              
?>
<tr
<?php 
if ($tf==0) {echo 'style="color:grey"';} else {echo 'style="color:black"';}    
?>    
>
<td align="center" class="kiri"><?php echo $no; ?></td>
<td><?php echo $r['berkas']; ?></td>

<td align="center">
<button type="button" name="file_contoh" style="height:22px;"class="btn btn-default btn-xs file_contoh" id="<?php echo $syarat_jbel_id;?>" data-content="Download Contoh Berkas" rel="popover" data-placement="top" data-trigger="hover"
>
<i class="fa fa-bars m-r-5"></i><span class="sr<?php echo $riwayat_syarat_jbel_id;?>" idne="pdf<?php echo $syarat_jbel_id;?>"></span>
</button>
</td>

<td align="center">
<button type="button" name="file_daftar" style="height:22px;"class="btn btn-default btn-xs file_daftar" id="<?php echo $syarat_jbel_id;?>" data-content="Upload Berkas" rel="popover" data-placement="top" data-trigger="hover"
>
<i class="fa fa-file m-r-5"></i><span class="sr<?php echo $riwayat_syarat_jbel_id;?>" idne="pdf<?php echo $syarat_jbel_id;?>"></span>
</button>
</td>
<td align="center">
<?php 
if (($tf!=0) && (($r['status']==NULL) || ($r['status']==''))) {
echo 'Belum verifikasi';
} else {
echo $r['status'];
}
?>
</td>
<td align="center"><?php 
if (($r['tgl_upload_dok']==null) || ($r['tgl_upload_dok']=='1970-01-01 00:00:00')) {} else {
echo date('d-m-Y',strtotime($r['tgl_upload_dok'])); }
?>
</td>
<td align="center"><?php 
if (($r['tgl_cek_dok']==null) || ($r['tgl_cek_dok']=='1970-01-01 00:00:00')) {} else {
echo date('d-m-Y',strtotime($r['tgl_cek_dok'])); }
?>
</td>
<td style="display:none"><?php echo $r['st_ceklist']; ?></td>
<td class="kanan"><?php echo $r['ket']; ?></td>
<tr>
<?php
$no++;
}
?>
</tbody>
</table>

<script>
$('button[name="file_daftar"]').popover();
$('button[name="file_contoh"]').popover();

$("#tabel_data_daftar_us").on('click','.file_daftar',function(){
	var syarat_jbel_id = $(this).attr('id');
	var riwayat_jbel_id=$('#riwayat_jbel_id').val();
	var data_pegawai_id=$('#data_pegawai_id').val();
	$('#modal_file').modal('show');
	$('#modal_body_file').html("");
	$.ajax({
		type: "POST",
		url: "app/st_jbel/upd_file.php",
		data: 'syarat_jbel_id='+syarat_jbel_id
    	+'&riwayat_jbel_id='+riwayat_jbel_id
    	+'&data_pegawai_id='+data_pegawai_id,
		success: function(data){
			$('#modal_body_file').html(data);
		}
	});
});

$("#tabel_data_daftar_us").on('click','.file_contoh',function(){
	var syarat_jbel_id = $(this).attr('id');
	var currentRow=$(this).closest("tr");
	var berkas = currentRow.find("td:eq(1)").text();
	$('#modal_view').modal('show');
	$('#modal_body_view').html("");
	$.ajax({
		type: "POST",
		url: "app/st_jbel/modal_view.php",
		data: 'syarat_jbel_id='+syarat_jbel_id
    	+'&berkas='+berkas,
		success: function(data){
			$('#modal_body_view').html(data);
        	$('#modal_head_view').html('Download Contoh Berkas');
		}
	});
});

// reload table when filter changes
$(document).on('change','#filter_pns_pppk',function(){
	var filter = $(this).val();
	var riwayat_jbel_id = $('#riwayat_jbel_id').val();
	var data_pegawai_id = $('#data_pegawai_id').val();
	if (filter=='') {
		$('#tabel_daftar_wrapper').hide();
	} else {
		$('#tabel_daftar_wrapper').show();
	}
});
var filter = $('#filter_pns_pppk').val() || '';
if (filter=='') {
	$('#tabel_daftar_wrapper').hide();
}
</script>