132 lines
4.2 KiB
PHP
132 lines
4.2 KiB
PHP
<?php
|
|
include("../koneksi.php");
|
|
$key=$_POST['key'];
|
|
if ($key=='simpan_penginput') {
|
|
$id=$_POST['id'];
|
|
$pembuat=$_POST['pembuat'];
|
|
$upd=pg_query("UPDATE sp_kwi SET pembuat='$pembuat' WHERE id=$id");
|
|
} else
|
|
if ($key=='setor') {
|
|
$thn=$_POST['thn'];
|
|
$nama_verifikator=$_POST['nama_verifikator'];
|
|
$a=strtoupper($_POST['a']);
|
|
$b=strtoupper($_POST['b']);
|
|
$c=strtoupper($_POST['c']);
|
|
$d=pg_query("SELECT l.id
|
|
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)
|
|
WHERE s.thn='$thn' AND l.nama_verfikator='$nama_verifikator' AND l.status_berkas='FIX'
|
|
".($a == 'ALL' ? "" : "
|
|
".($a == 'FUNGSIONAL' ? "AND LEFT(s.kegiatan,2) NOT IN ('**')" : "AND LEFT(s.kegiatan,2) IN ('**')")."
|
|
")."
|
|
".($b == 'ALL' ? "" : "
|
|
".($b == 'NON UANG MUKA' ? "AND l.status_um='Non Uang Muka'" : "AND l.status_um='Uang Muka'")."
|
|
")."
|
|
".($b == 'ALL' ? "" : "AND l.tanggal_setor IS NULL")."
|
|
");
|
|
while(($r=pg_fetch_array($d)) !== FALSE) {
|
|
$id=$r[0];
|
|
pg_query("UPDATE vr_pelunasan SET tanggal_setor=NOW()");
|
|
}
|
|
} else
|
|
if ($key=='delete_kwi') {
|
|
$id=$_POST['id'];
|
|
|
|
$cek=pg_query("SELECT COUNT(*) FROM sp_peg p WHERE p.pekerjaan_id IS NOT NULL AND p.sp_spt_id IN (
|
|
SELECT t.id FROM sp_spt t WHERE t.sp_kwi_id IN (
|
|
SELECT k.id FROM sp_kwi k WHERE k.id='$id'
|
|
)
|
|
)
|
|
");
|
|
while($rc=pg_fetch_array($cek)) {$jml=$rc[0];}
|
|
|
|
if ($jml==0) {
|
|
pg_query("DELETE FROM sp_lap_saran s WHERE s.sp_peg_id IN (
|
|
SELECT p.id FROM sp_peg p WHERE p.sp_spt_id IN (
|
|
SELECT t.id FROM sp_spt t WHERE t.sp_kwi_id IN (
|
|
SELECT k.id FROM sp_kwi k WHERE k.id='$id'
|
|
)
|
|
)
|
|
)");
|
|
|
|
pg_query("DELETE FROM sp_lap_masalah s WHERE s.sp_peg_id IN (
|
|
SELECT p.id FROM sp_peg p WHERE p.sp_spt_id IN (
|
|
SELECT t.id FROM sp_spt t WHERE t.sp_kwi_id IN (
|
|
SELECT k.id FROM sp_kwi k WHERE k.id='$id'
|
|
)
|
|
)
|
|
)");
|
|
|
|
pg_query("DELETE FROM sp_lap_arahan s WHERE s.sp_peg_id IN (
|
|
SELECT p.id FROM sp_peg p WHERE p.sp_spt_id IN (
|
|
SELECT t.id FROM sp_spt t WHERE t.sp_kwi_id IN (
|
|
SELECT k.id FROM sp_kwi k WHERE k.id='$id'
|
|
)
|
|
)
|
|
)");
|
|
|
|
pg_query("DELETE FROM sp_penginapan s WHERE s.sp_peg_id IN (
|
|
SELECT p.id FROM sp_peg p WHERE p.sp_spt_id IN (
|
|
SELECT t.id FROM sp_spt t WHERE t.sp_kwi_id IN (
|
|
SELECT k.id FROM sp_kwi k WHERE k.id='$id'
|
|
)
|
|
)
|
|
)");
|
|
|
|
pg_query("DELETE FROM sp_biaya s WHERE s.sp_peg_id IN (
|
|
SELECT p.id FROM sp_peg p WHERE p.sp_spt_id IN (
|
|
SELECT t.id FROM sp_spt t WHERE t.sp_kwi_id IN (
|
|
SELECT k.id FROM sp_kwi k WHERE k.id='$id'
|
|
)
|
|
)
|
|
)");
|
|
|
|
pg_query("DELETE FROM sp_transportasi s WHERE s.sp_peg_id IN (
|
|
SELECT p.id FROM sp_peg p WHERE p.sp_spt_id IN (
|
|
SELECT t.id FROM sp_spt t WHERE t.sp_kwi_id IN (
|
|
SELECT k.id FROM sp_kwi k WHERE k.id='$id'
|
|
)
|
|
)
|
|
)");
|
|
|
|
pg_query("DELETE FROM sp_ttd s WHERE s.sp_peg_id IN (
|
|
SELECT p.id FROM sp_peg p WHERE p.sp_spt_id IN (
|
|
SELECT t.id FROM sp_spt t WHERE t.sp_kwi_id IN (
|
|
SELECT k.id FROM sp_kwi k WHERE k.id='$id'
|
|
)
|
|
)
|
|
)");
|
|
|
|
pg_query("DELETE FROM sp_rincian s WHERE s.sp_peg_id IN (
|
|
SELECT p.id FROM sp_peg p WHERE p.sp_spt_id IN (
|
|
SELECT t.id FROM sp_spt t WHERE t.sp_kwi_id IN (
|
|
SELECT k.id FROM sp_kwi k WHERE k.id='$id'
|
|
)
|
|
)
|
|
)");
|
|
|
|
pg_query("DELETE FROM sp_realisasi s WHERE s.sp_peg_id IN (
|
|
SELECT p.id FROM sp_peg p WHERE p.sp_spt_id IN (
|
|
SELECT t.id FROM sp_spt t WHERE t.sp_kwi_id IN (
|
|
SELECT k.id FROM sp_kwi k WHERE k.id='$id'
|
|
)
|
|
)
|
|
)");
|
|
|
|
|
|
pg_query("DELETE FROM sp_peg p WHERE p.sp_spt_id IN (
|
|
SELECT t.id FROM sp_spt t WHERE t.sp_kwi_id IN (
|
|
SELECT k.id FROM sp_kwi k WHERE k.id='$id'
|
|
)
|
|
)
|
|
");
|
|
|
|
pg_query("DELETE FROM sp_spt t WHERE t.sp_kwi_id IN (SELECT k.id FROM sp_kwi k WHERE k.id='$id')");
|
|
pg_query("DELETE FROM sp_kwi WHERE id='$id'");
|
|
} else {
|
|
echo 'gakiso';
|
|
}
|
|
}
|
|
?>
|