41 lines
1.9 KiB
PHP
41 lines
1.9 KiB
PHP
<?php
|
|
include("../koneksi.php");
|
|
$key=$_POST['key'];
|
|
if ($key=='total_proses') {
|
|
$thn=$_POST['thn'];
|
|
$axx=$_POST['axx'];
|
|
$bxx=$_POST['bxx'];
|
|
$cxx=$_POST['cxx'];
|
|
$jenis=$_POST['jenis'];
|
|
$cari_verifikator=$_POST['cari_verifikator'];
|
|
$nama_verifikator=$_POST['nama_verifikator'];
|
|
$tm1=$_POST['m'];
|
|
$tm1=str_replace('/','-',$tm1);
|
|
$tt1=date('Y',strtotime($tm1));
|
|
$bb1=date('m',strtotime($tm1));
|
|
$hh1=date('d',strtotime($tm1));
|
|
|
|
$ts1=$_POST['s'];
|
|
$ts1=str_replace('/','-',$ts1);
|
|
$tt2=date('Y',strtotime($ts1));
|
|
$bb2=date('m',strtotime($ts1));
|
|
$hh2=date('d',strtotime($ts1));
|
|
$d=pg_query("SELECT
|
|
SUM(l.nilai_pelunasan)
|
|
FROM pekerjaan p
|
|
INNER JOIN sub_kegiatan s ON (p.sub_kegiatan_id=s.id)
|
|
INNER JOIN vr_realisasi r ON (r.pekerjaan_id=p.id)
|
|
INNER JOIN vr_pelunasan l ON (l.vr_realisasi_id=r.id)
|
|
INNER JOIN kpa a1 ON (s.kpa_id=a1.id)
|
|
INNER JOIN ppkom a2 ON (s.ppkom_id=a2.id)
|
|
INNER JOIN pptk a3 ON (s.pptk_id=a3.id)
|
|
WHERE s.thn='$thn' AND l.status_berkas IN ('FIX','PROSES') AND l.tanggal_setor IS NULL AND p.status_setor IS NULL
|
|
".($tm1 == null ? "" : "AND l.tgl_terima_verif::DATE BETWEEN '$tt1-$bb1-$hh1' AND '$tt2-$bb2-$hh2'")."
|
|
".($axx == '' ? "" : "AND s.kpa_id='$axx'")."
|
|
".($bxx == '' ? "" : "AND s.ppkom_id='$bxx'")."
|
|
".($cxx == '' ? "" : "AND s.pptk_id='$cxx'")."
|
|
".($cari_verifikator == '' ? "" : "AND COALESCE(p.user_nama,l.nama_verfikator)='$cari_verifikator'")."
|
|
");
|
|
while($r=pg_fetch_array($d)) {echo number_format($r[0],0,',','.');}
|
|
}
|
|
?>
|