23 lines
877 B
PHP
23 lines
877 B
PHP
<?php
|
|
include('../koneksi.php');
|
|
$key=$_POST['key'];
|
|
if ($key=='cek_sp') {
|
|
$no_sp=strtolower($_POST['no_sp']);
|
|
$d=pg_query("SELECT p.id,COALESCE(n.nama,p.cad1),COALESCE(n.id,0)
|
|
FROM pekerjaan p
|
|
INNER JOIN sub_kegiatan s ON (s.id=p.sub_kegiatan_id)
|
|
LEFT OUTER JOIN rekanan n ON (n.id=p.rekanan_id)
|
|
WHERE (LOWER(p.no_sp)='$no_sp' OR LOWER(p.no_spp)='$no_sp')");
|
|
while($r=pg_fetch_array($d)) {$pekerjaan_id=$r[0];$nm_rekanan=$r[1];$rekanan_id=$r[2];}
|
|
|
|
$thn=date('Y');
|
|
$d=pg_query("SELECT COALESCE(COUNT(*),0) FROM pekerjaan p
|
|
INNER JOIN sub_kegiatan s ON (p.sub_kegiatan_id=s.id)
|
|
LEFT OUTER JOIN vr_realisasi r ON (r.pekerjaan_id=p.id)
|
|
LEFT OUTER JOIN vr_pelunasan l ON (l.vr_realisasi_id=r.id)
|
|
WHERE s.thn='$thn' AND p.rekanan_id=$rekanan_id
|
|
");
|
|
while($r=pg_fetch_array($d)) {$jml_belanja=$r[0];}
|
|
echo $pekerjaan_id.'$%^'.$nm_rekanan.'$%^'.$rekanan_id.'$%^'.$jml_belanja;
|
|
}
|
|
?>
|