ryan
62 lines
4.0 KiB
PHP
62 lines
4.0 KiB
PHP
<?php
|
|
include("../koneksi.php");
|
|
$thn=$_POST['thn'];
|
|
?>
|
|
|
|
<script type="text/javascript">
|
|
$("#tabel_data_kd_panggil").DataTable({"stateSave": true,"paging": true,"lengthChange": true,"searching": true,"ordering": false,"info": true,"autoWidth": false});
|
|
</script>
|
|
<input type="text" value="<?php echo $thn; ?>">
|
|
<table id="tabel_data_kd_panggil" class="table table-striped table-condensed table-bordered" cellpadding="1">
|
|
<thead>
|
|
<tr>
|
|
<td width="20"><b>Kd</b></td>
|
|
<td width="8"><b>KPA</b></td>
|
|
<td width="10"><b>PPTK</b></td>
|
|
<td width="250"><b>Kegiatan</b></td>
|
|
<td width="120"><b>Rek</b></td>
|
|
<td width="70" align="center"><b>Anggaran</b></td>
|
|
<td width="50" align="center"><b>Tools</b></td>
|
|
</tr>
|
|
</thead>
|
|
<tbody>
|
|
<?php
|
|
$data=pg_query("SELECT a.inisial,o.inisial,t.inisial,p.inisial,g.nama,
|
|
k.ra,k.rb,k.rc,k.rd,k.re,k.rf,k.rg,k.rh,k.sub_kegiatan,k.anggaran,k.id,k.kegiatan,k.kd_panggil
|
|
FROM sub_kegiatan k
|
|
LEFT OUTER JOIN kpa a ON (a.id=k.kpa_id)
|
|
LEFT OUTER JOIN pptk t ON (t.id=k.pptk_id)
|
|
LEFT OUTER JOIN pejabat_pengadaan p ON (p.id=k.pejabat_pengadaan_id)
|
|
LEFT OUTER JOIN ppkom o ON (o.id=k.ppkom_id)
|
|
LEFT OUTER JOIN subkategori_kegiatan g ON (g.id=k.kategori_id)
|
|
WHERE k.thn='$thn' AND k.anggaran IS NOT NULL
|
|
ORDER BY k.id ASC
|
|
");
|
|
while($r=pg_fetch_array($data)) {
|
|
?>
|
|
<tr id="baris_kg<?php echo $r['id']; ?>" class="baris_kg">
|
|
<td class="kiri"><b><?php echo $r['kd_panggil']; ?></b></td>
|
|
<td><b><?php echo $r[0]; ?></b></td>
|
|
<td><b><?php echo $r[2]; ?></b></td>
|
|
<td><b><?php echo $r['kegiatan']; ?></b></td>
|
|
<td><b><?php echo $r[5].' '.$r[6].' '.$r[7].' '.$r[8].' '.$r[9].' '.$r[10].' '.$r[11].' '.$r[12]; ?></b></td>
|
|
<td align="right"><b><?php echo number_format($r[14],0,',','.'); ?></b></td>
|
|
<td class="kanan" align="center">
|
|
<button type="button" name="verifikasi" style="height:22px;" class="btn btn-danger btn-xs verifikasi" id="<?php echo $row['id'];?>" data-content="Verifikasi" rel="popover" data-placement="top" data-trigger="hover">
|
|
<i class="fa fa-check"></i>
|
|
</button>
|
|
<button type="button" name="lap_setor" style="height:22px;" class="btn btn-success btn-xs lap_setor" id="<?php echo $row['id'];?>" data-content="Lap Setor" rel="popover" data-placement="top" data-trigger="hover">
|
|
<i class="fa fa-arrow-down"></i>
|
|
</button>
|
|
</td>
|
|
</tr>
|
|
<?php
|
|
}
|
|
?>
|
|
</tbody>
|
|
</table>
|
|
|
|
<script>
|
|
$('button[name="verifikasi"]').popover();
|
|
$('button[name="lap_setor"]').popover();
|
|
</script>
|