74 lines
4.0 KiB
PHP
74 lines
4.0 KiB
PHP
<?php
|
|
include('../koneksi.php');
|
|
$thn=$_POST['thn'];
|
|
$bulan=$_POST['bulan'];
|
|
?>
|
|
|
|
<script type="text/javascript">
|
|
$("#tabel_data_pns").DataTable({"stateSave": false,"paging": true,"lengthChange": true,"searching": false,"ordering": false,"info": true,"autoWidth": false});</script>
|
|
<table id="tabel_data_pns" class="table table-striped table-condensed table-bordered" cellpadding="1" style="font-family:'RubReg';">
|
|
<thead style="font-weight:bold">
|
|
<tr>
|
|
<td width="20" align="center">No</td>
|
|
<td width="400" align="center">Nama PNS</td>
|
|
<td width="150" align="center">NIP</td>
|
|
<td width="60" align="center">Gol</td>
|
|
<td width="350" align="center">Satuan Kerja</td>
|
|
<td width="100" align="center">Biaya</td>
|
|
</tr>
|
|
</thead>
|
|
<tbody style="color:black">
|
|
<?php
|
|
$no=1;
|
|
$a=0;
|
|
$data = pg_query("SELECT COALESCE(p.nama,u.nama_non),COALESCE(p.nipb,u.nip_non),COALESCE(s.nama,'NON PEGAWAI RSSA'),
|
|
p.golongan,p.ruang,u.id
|
|
FROM data_pegawai p
|
|
RIGHT OUTER JOIN sp_peg u ON (p.id=u.data_pegawai_id)
|
|
LEFT OUTER JOIN satuan_kerja s ON (p.satuan_kerja=s.id)
|
|
INNER JOIN sp_spt t ON (t.id=u.sp_spt_id)
|
|
INNER JOIN sp_kwi k ON (k.id=t.sp_kwi_id)
|
|
WHERE p.golongan <> '-'
|
|
AND k.thn='$thn' AND k.bulan='$bulan'
|
|
ORDER BY u.id ASC");
|
|
while($row=pg_fetch_array($data)) {
|
|
$sp_peg_id=$row[5];
|
|
$total_realisasi=0;$b0=0;$tr=0;$pn=0;$bi=0;
|
|
|
|
|
|
$t1=pg_query("SELECT COALESCE(SUM(harga),0) FROM sp_transportasi WHERE sp_peg_id='$sp_peg_id'");
|
|
while($r1=pg_fetch_array($t1)) {$tr=$r1[0];}
|
|
|
|
$t2=pg_query("SELECT COALESCE((penginapan*lama),0) FROM sp_penginapan WHERE sp_peg_id='$sp_peg_id'");
|
|
while($r2=pg_fetch_array($t2)) {$pn=$r2[0];}
|
|
|
|
$t3=pg_query("SELECT COALESCE(((uang_harian*lama)+(representasi*lama)+sewa_kendaraan+bbm+tol+(bantrans*lama_bt)+pcr),0) FROM sp_biaya WHERE sp_peg_id='$sp_peg_id' AND jenis='P'");
|
|
while($r3=pg_fetch_array($t3)) {$bi=$r3[0];}
|
|
|
|
$total_realisasi=$tr+$pn+$bi;
|
|
?>
|
|
<tr>
|
|
<td class="kiri" align="center"><?php echo $no; ?></td>
|
|
<td><?php echo $row[0]; ?></td>
|
|
<td align="center"><?php echo $row[1]; ?></td>
|
|
<td align="center"><?php echo $row[3].'/'. $row[4]; ?></td>
|
|
<td><?php echo $row[2]; ?></td>
|
|
<td class="kanan" align="right"><?php echo number_format($total_realisasi,0,',','.'); ?></td>
|
|
</tr>
|
|
<?php
|
|
|
|
$no++;
|
|
$a=$a+$total_realisasi;
|
|
}
|
|
?>
|
|
</tbody>
|
|
<tr style="font-weight:bold;color:black">
|
|
<td colspan="5" style="text-align:right"></td>
|
|
<td style="text-align:right"><?php echo number_format($a,0,',','.'); ?></td>
|
|
</tr>
|
|
</table>
|
|
|
|
|
|
<script>
|
|
|
|
</script>
|