| No |
Nama PNS |
NIP |
Gol |
Satuan Kerja |
Biaya |
'-'
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;
?>
|
|
|
|
|
|
|
|