516 lines
15 KiB
PHP
516 lines
15 KiB
PHP
<?php
|
|
include('../koneksi.php');
|
|
$key=$_POST['key'];
|
|
if ($key=='simpan_databa_cari') {
|
|
$a=$_POST['riwayat_ba_id'];
|
|
$pekerjaan_id=$_POST['pekerjaan_id'];
|
|
$vr_pelunasan_id=$_POST['vr_pelunasan_id'];
|
|
$pecah=explode(',',$a);
|
|
foreach($pecah as $selected) {
|
|
pg_query("UPDATE riwayat_ba SET vr_pelunasan_id=$vr_pelunasan_id WHERE id='$selected'");
|
|
}
|
|
} else
|
|
/*
|
|
if ($key=='cek_nilai_ba') {
|
|
$nilai_ba=$_POST['nilai_ba'];
|
|
$riwayat_ba_id=$_POST['riwayat_ba_id'];
|
|
$berita_acara_id=$_POST['berita_acara_id'];
|
|
$nilai_pelunasan=$_POST['nilai_pelunasan'];
|
|
$pekerjaan_id=$_POST['pekerjaan_id'];
|
|
$dt=pg_query("SELECT LOWER(st_termin) FROM vr_realisasi WHERE pekerjaan_id=$pekerjaan_id");
|
|
while($rdt=pg_fetch_array($dt)) {$st_trm=$rdt[0];}
|
|
|
|
$d=pg_query("SELECT COALESCE(SUM(r.nilai_ba),0)
|
|
FROM riwayat_ba r
|
|
INNER JOIN berita_acara b ON (b.id=r.berita_acara_id)
|
|
WHERE r.pekerjaan_id='$pekerjaan_id' AND r.berita_acara_id=$berita_acara_id
|
|
".($st_trm == 'termin' ? "AND nilai_ba=$nilai_pelunasan" : "")."
|
|
");
|
|
|
|
while($r=pg_fetch_array($d)) {$tot_ba=$r[0];}
|
|
echo $tot_ba;
|
|
} else */
|
|
if ($key=='cek_nomor_ba') {
|
|
$nomor_ba=$_POST['nomor_ba'];
|
|
$riwayat_ba_id=$_POST['riwayat_ba_id'];
|
|
if ($riwayat_ba_id=='0') {
|
|
$cek=pg_query("SELECT COUNT(*) FROM riwayat_ba WHERE TRIM(FROM nomor_ba)='$nomor_ba'");
|
|
while($rc=pg_fetch_array($cek)) {$jml=$rc[0];}
|
|
if ($jml==0) {echo 'bisa';} else {echo 'tidak bisa';}
|
|
} else {
|
|
$d=pg_query("SELECT TRIM(FROM nomor_ba) FROM riwayat_ba WHERE id=$riwayat_ba_id");
|
|
while($r=pg_fetch_array($d)) {$nba=$r[0];}
|
|
if ($nomor_ba==$nba) {echo 'lanjut';} else {
|
|
$cek=pg_query("SELECT COUNT(*) FROM riwayat_ba WHERE TRIM(FROM nomor_ba)='$nomor_ba'");
|
|
while($rc=pg_fetch_array($cek)) {$jml=$rc[0];}
|
|
if ($jml==0) {echo 'bisa';} else {echo 'tidak bisa';}
|
|
}
|
|
}
|
|
} else
|
|
if ($key=='kendali_cari') {
|
|
$no_sp=$_POST['no_sp'];
|
|
$thn=$_POST['thn'];
|
|
/*
|
|
$d=pg_query("SELECT p.id,p.sub_kegiatan_id,s.kd_panggil FROM pekerjaan p
|
|
INNER JOIN sub_kegiatan s ON (s.id=p.sub_kegiatan_id)
|
|
INNER JOIN vr_realisasi r ON (p.id=r.pekerjaan_id)
|
|
INNER JOIN vr_pelunasan l ON (r.id=l.vr_realisasi_id)
|
|
WHERE l.st_setor_verif='SETOR' AND p.no_sp='$no_sp'
|
|
AND s.thn='$thn'
|
|
");
|
|
*/
|
|
$d=pg_query("SELECT DISTINCT p.id,p.sub_kegiatan_id,s.kd_panggil
|
|
FROM pekerjaan p
|
|
INNER JOIN sub_kegiatan s ON (s.id=p.sub_kegiatan_id)
|
|
INNER JOIN vr_realisasi r ON (p.id=r.pekerjaan_id)
|
|
INNER JOIN vr_pelunasan l ON (r.id=l.vr_realisasi_id)
|
|
LEFT OUTER JOIN (SELECT * FROM pekerjaan WHERE status_setor='ADENDUM') p1 ON (p.id=p1.adendum_pekerjaan_id)
|
|
WHERE l.st_setor_verif='SETOR' AND
|
|
((p.no_sp='$no_sp' OR p1.no_sp='$no_sp') OR (p.no_spp='$no_sp' OR p1.no_spp='$no_sp'))
|
|
AND s.thn='$thn'
|
|
");
|
|
while($r=pg_fetch_array($d)) {$pekerjaan_id=$r[0];$sub_kegiatan_id=$r[1];$kd_panggil=$r[2];}
|
|
echo $pekerjaan_id.'$%^'.$sub_kegiatan_id.'$%^'.$kd_panggil;
|
|
} else
|
|
if ($key=='simpan_st_buku') {
|
|
$id=$_POST['id'];
|
|
$pekerjaan_id=$_POST['pekerjaan_id'];
|
|
$st_buku=$_POST['st_buku'];
|
|
$cek_add=pg_query("SELECT id FROM vr_realisasi WHERE pekerjaan_id='$pekerjaan_id'");
|
|
$row_add = pg_fetch_row($cek_add);
|
|
if ($row_add[0] > 0) {
|
|
$u=pg_query("UPDATE vr_realisasi SET st_buku='$st_buku' WHERE pekerjaan_id='$pekerjaan_id'");
|
|
} else {
|
|
$i=pg_query("INSERT INTO vr_realisasi (pekerjaan_id,st_buku) VALUES ('$pekerjaan_id','$st_buku')");
|
|
}
|
|
$d=pg_query("SELECT id FROM vr_realisasi WHERE pekerjaan_id='$pekerjaan_id'");
|
|
while($r=pg_fetch_array($d)) {$vr_realisasi_id=$r[0];echo $vr_realisasi_id;}
|
|
} else
|
|
if ($key=='simpan_st_termin') {
|
|
$id=$_POST['id'];
|
|
$pekerjaan_id=$_POST['pekerjaan_id'];
|
|
$st_termin=$_POST['st_termin'];
|
|
$cek_add=pg_query("SELECT id FROM vr_realisasi WHERE pekerjaan_id='$pekerjaan_id'");
|
|
$row_add = pg_fetch_row($cek_add);
|
|
if ($row_add[0] > 0) {
|
|
$u=pg_query("UPDATE vr_realisasi SET st_termin='$st_termin' WHERE pekerjaan_id='$pekerjaan_id'");
|
|
} else {
|
|
$i=pg_query("INSERT INTO vr_realisasi (pekerjaan_id,st_termin) VALUES ('$pekerjaan_id','$st_termin')");
|
|
}
|
|
$d=pg_query("SELECT id FROM vr_realisasi WHERE pekerjaan_id='$pekerjaan_id'");
|
|
while($r=pg_fetch_array($d)) {$vr_realisasi_id=$r[0];echo $vr_realisasi_id;}
|
|
} else
|
|
if ($key=='upd_stum') {
|
|
$vr_realisasi_id=$_POST['vr_realisasi_id'];
|
|
$stum=$_POST['stum'];
|
|
if ($stum=='uang_muka') {
|
|
$u=pg_query("UPDATE vr_realisasi SET stum='$stum' WHERE id='$vr_realisasi_id'");
|
|
} else {
|
|
$u=pg_query("UPDATE vr_realisasi SET stum=NULL WHERE id='$vr_realisasi_id'");
|
|
}
|
|
} else
|
|
if ($key=='simpan_verifikasi') {
|
|
$id=$_POST['id'];
|
|
$vr_realisasi_id=$_POST['vr_realisasi_id'];
|
|
|
|
$nilai_pelunasan=$_POST['nilai_pelunasan'];
|
|
$nilai_pelunasan=str_replace('.','',$nilai_pelunasan);
|
|
$nilai_pelunasan=str_replace(',','',$nilai_pelunasan);
|
|
|
|
$ppn=$_POST['ppn'];
|
|
$ppn=str_replace('.','',$ppn);
|
|
$ppn=str_replace(',','',$ppn);
|
|
|
|
$pph_21=$_POST['pph_21'];
|
|
$pph_21=str_replace('.','',$pph_21);
|
|
$pph_21=str_replace(',','',$pph_21);
|
|
|
|
$pph_22=$_POST['pph_22'];
|
|
$pph_22=str_replace('.','',$pph_22);
|
|
$pph_22=str_replace(',','',$pph_22);
|
|
|
|
$pph_23=$_POST['pph_23'];
|
|
$pph_23=str_replace('.','',$pph_23);
|
|
$pph_23=str_replace(',','',$pph_23);
|
|
|
|
$pph_final=$_POST['pph_final'];
|
|
$pph_final=str_replace('.','',$pph_final);
|
|
$pph_final=str_replace(',','',$pph_final);
|
|
|
|
$no_faktur=$_POST['no_faktur'];
|
|
|
|
$tanggal_faktur=$_POST['tanggal_faktur'];
|
|
$tanggal_faktur=str_replace('/','-',$tanggal_faktur);
|
|
$tm=date('Y',strtotime($tanggal_faktur));
|
|
$bm=date('m',strtotime($tanggal_faktur));
|
|
$hm=date('d',strtotime($tanggal_faktur));
|
|
|
|
$kwitansi=$_POST['kwitansi'];
|
|
$faktur_penjualan=$_POST['faktur_penjualan'];
|
|
$nota_dinas=$_POST['nota_dinas'];
|
|
$faktur_pajak=$_POST['faktur_pajak'];
|
|
$ssp_ppn=$_POST['ssp_ppn'];
|
|
$ssp_pph=$_POST['ssp_pph'];
|
|
$ba_hp_admin=$_POST['ba_hp_admin'];
|
|
$ba_st=$_POST['ba_st'];
|
|
$sp_spk=$_POST['sp_spk'];
|
|
$ba_denda=$_POST['ba_denda'];
|
|
$ceklist=$_POST['ceklist'];
|
|
$status_um=$_POST['status_um'];
|
|
|
|
$tanggal_jatuh_tempo=$_POST['tanggal_jatuh_tempo'];
|
|
$tanggal_jatuh_tempo=str_replace('/','-',$tanggal_jatuh_tempo);
|
|
$ts=date('Y',strtotime($tanggal_jatuh_tempo));
|
|
$bs=date('m',strtotime($tanggal_jatuh_tempo));
|
|
$hs=date('d',strtotime($tanggal_jatuh_tempo));
|
|
|
|
$nama_verifikator=$_POST['nama_verifikator'];
|
|
$status_berkas=$_POST['status_berkas'];
|
|
$ket=$_POST['ket'];
|
|
|
|
$honor=$_POST['honor'];
|
|
$hadir=$_POST['hadir'];
|
|
$tor=$_POST['tor'];
|
|
$spt=$_POST['spt'];
|
|
$pendukung=$_POST['pendukung'];
|
|
$ba_um=$_POST['ba_um'];
|
|
$ba_ujicoba=$_POST['ba_ujicoba'];
|
|
$ba_pembayaran=$_POST['ba_pembayaran'];
|
|
$ba_kemajuan=$_POST['ba_kemajuan'];
|
|
|
|
|
|
|
|
$cek_add=pg_query("SELECT id FROM vr_pelunasan WHERE id='$id'");
|
|
$row_add = pg_fetch_row($cek_add);
|
|
if ($row_add[0] > 0) {
|
|
if ($status_berkas=='SETOR') {
|
|
$u=pg_query("UPDATE vr_pelunasan SET
|
|
nilai_pelunasan='$nilai_pelunasan',
|
|
kwitansi='$kwitansi',
|
|
faktur_penjualan='$faktur_penjualan',
|
|
nota_dinas='$nota_dinas',
|
|
faktur_pajak='$faktur_pajak',
|
|
ssp_ppn='$ssp_ppn',
|
|
ssp_pph='$ssp_pph',
|
|
ba_hp_admin='$ba_hp_admin',
|
|
ba_st='$ba_st',
|
|
sp_spk='$sp_spk',
|
|
ppn='$ppn',
|
|
pph_21='$pph_21',
|
|
pph_22='$pph_22',
|
|
pph_23='$pph_23',
|
|
pph_final='$pph_final',
|
|
no_faktur='$no_faktur',
|
|
tanggal_faktur='$tm-$bm-$hm',
|
|
tanggal_jatuh_tempo='$ts-$bs-$hs',
|
|
status_um='$status_um',
|
|
ba_denda='$ba_denda',
|
|
ceklist='$ceklist',
|
|
nama_verfikator='$nama_verifikator',
|
|
status_berkas='$status_berkas',
|
|
ket='$ket',
|
|
honor='$honor',
|
|
hadir='$hadir',
|
|
tor='$tor',
|
|
spt='$spt',
|
|
pendukung='$pendukung',
|
|
ba_um='$ba_um',
|
|
ba_ujicoba='$ba_ujicoba',
|
|
ba_pembayaran='$ba_pembayaran',
|
|
ba_kemajuan='$ba_kemajuan'
|
|
WHERE id='$id'");
|
|
} else {
|
|
$cadm=pg_query("SELECT nama_verfikator FROM vr_pelunasan WHERE id=$id");
|
|
while($rcadm=pg_fetch_array($cadm)) {$ncadm=$rcadm[0];}
|
|
if (($ncadm==null) || ($ncadm=='')) {
|
|
$u=pg_query("UPDATE vr_pelunasan SET
|
|
nilai_pelunasan='$nilai_pelunasan',
|
|
kwitansi='$kwitansi',
|
|
faktur_penjualan='$faktur_penjualan',
|
|
nota_dinas='$nota_dinas',
|
|
faktur_pajak='$faktur_pajak',
|
|
ssp_ppn='$ssp_ppn',
|
|
ssp_pph='$ssp_pph',
|
|
ba_hp_admin='$ba_hp_admin',
|
|
ba_st='$ba_st',
|
|
sp_spk='$sp_spk',
|
|
ppn='$ppn',
|
|
pph_21='$pph_21',
|
|
pph_22='$pph_22',
|
|
pph_23='$pph_23',
|
|
pph_final='$pph_final',
|
|
no_faktur='$no_faktur',
|
|
tanggal_faktur='$tm-$bm-$hm',
|
|
tanggal_jatuh_tempo='$ts-$bs-$hs',
|
|
status_um='$status_um',
|
|
ba_denda='$ba_denda',
|
|
ceklist='$ceklist',
|
|
nama_verfikator='$nama_verifikator',
|
|
status_berkas='$status_berkas',
|
|
ket='$ket',
|
|
honor='$honor',
|
|
hadir='$hadir',
|
|
tor='$tor',
|
|
spt='$spt',
|
|
pendukung='$pendukung',
|
|
ba_um='$ba_um',
|
|
ba_ujicoba='$ba_ujicoba',
|
|
ba_pembayaran='$ba_pembayaran',
|
|
ba_kemajuan='$ba_kemajuan',
|
|
tgl_terima_verif=NOW()
|
|
WHERE id='$id'");
|
|
} else {
|
|
$u=pg_query("UPDATE vr_pelunasan SET
|
|
nilai_pelunasan='$nilai_pelunasan',
|
|
kwitansi='$kwitansi',
|
|
faktur_penjualan='$faktur_penjualan',
|
|
nota_dinas='$nota_dinas',
|
|
faktur_pajak='$faktur_pajak',
|
|
ssp_ppn='$ssp_ppn',
|
|
ssp_pph='$ssp_pph',
|
|
ba_hp_admin='$ba_hp_admin',
|
|
ba_st='$ba_st',
|
|
sp_spk='$sp_spk',
|
|
ppn='$ppn',
|
|
pph_21='$pph_21',
|
|
pph_22='$pph_22',
|
|
pph_23='$pph_23',
|
|
pph_final='$pph_final',
|
|
no_faktur='$no_faktur',
|
|
tanggal_faktur='$tm-$bm-$hm',
|
|
tanggal_jatuh_tempo='$ts-$bs-$hs',
|
|
status_um='$status_um',
|
|
ba_denda='$ba_denda',
|
|
ceklist='$ceklist',
|
|
nama_verfikator='$nama_verifikator',
|
|
status_berkas='$status_berkas',
|
|
ket='$ket',
|
|
honor='$honor',
|
|
hadir='$hadir',
|
|
tor='$tor',
|
|
spt='$spt',
|
|
pendukung='$pendukung',
|
|
ba_um='$ba_um',
|
|
ba_ujicoba='$ba_ujicoba',
|
|
ba_pembayaran='$ba_pembayaran',
|
|
ba_kemajuan='$ba_kemajuan'
|
|
WHERE id='$id'");
|
|
}
|
|
}
|
|
|
|
include('../reset_akumulasi.php');
|
|
/* edit nilai pekerjaan - belanja yang diinput verifikasi */
|
|
|
|
$cid=pg_query("SELECT p.id,p.user_nama FROM pekerjaan p WHERE p.id=(SELECT r.pekerjaan_id FROM vr_realisasi r WHERE r.id='$vr_realisasi_id')");
|
|
while($rcid=pg_fetch_array($cid)) {$npekerjaan_id=$rcid[0];$nuser_nama=$rcid[1];}
|
|
if ($nuser_nama==NULL) {} else {
|
|
$up=pg_query("UPDATE pekerjaan SET nilai_sp='$nilai_pelunasan', nilai_realisasi='$nilai_pelunasan' WHERE id='$npekerjaan_id'");
|
|
}
|
|
|
|
} else {
|
|
$urut=pg_query("SELECT COALESCE(MAX(data_ke),0) FROM vr_pelunasan WHERE vr_realisasi_id='$vr_realisasi_id'");
|
|
while($rurut=pg_fetch_array($urut)) {$data_ke=$rurut[0]+1;}
|
|
$i=pg_query("INSERT INTO vr_pelunasan (
|
|
vr_realisasi_id,
|
|
tanggal_input,
|
|
nilai_pelunasan,
|
|
kwitansi,
|
|
faktur_penjualan,
|
|
nota_dinas,
|
|
faktur_pajak,
|
|
ssp_ppn,
|
|
ssp_pph,
|
|
ba_hp_admin,
|
|
ba_st,
|
|
sp_spk,
|
|
ppn,
|
|
pph_21,
|
|
pph_22,
|
|
pph_23,
|
|
pph_final,
|
|
no_faktur,
|
|
tanggal_faktur,
|
|
tanggal_jatuh_tempo,
|
|
status_um,
|
|
ba_denda,
|
|
ceklist,
|
|
nama_verfikator,
|
|
status_berkas,
|
|
data_ke,
|
|
ket,
|
|
honor,
|
|
hadir,
|
|
tor,
|
|
spt,
|
|
pendukung,
|
|
ba_um,
|
|
ba_ujicoba,
|
|
ba_pembayaran,
|
|
ba_kemajuan,
|
|
st_setor_verif,
|
|
tgl_terima_verif
|
|
) VALUES (
|
|
'$vr_realisasi_id',
|
|
NOW(),
|
|
'$nilai_pelunasan',
|
|
'$kwitansi',
|
|
'$faktur_penjualan',
|
|
'$nota_dinas',
|
|
'$faktur_pajak',
|
|
'$ssp_ppn',
|
|
'$ssp_pph',
|
|
'$ba_hp_admin',
|
|
'$ba_st',
|
|
'$sp_spk',
|
|
'$ppn',
|
|
'$pph_21',
|
|
'$pph_22',
|
|
'$pph_23',
|
|
'$pph_final',
|
|
'$no_faktur',
|
|
'$tm-$bm-$hm',
|
|
'$ts-$bs-$hs',
|
|
'$status_um',
|
|
'$ba_denda',
|
|
'$ceklist',
|
|
'$nama_verifikator',
|
|
'$status_berkas',
|
|
'$data_ke',
|
|
'$ket',
|
|
'$honor',
|
|
'$hadir',
|
|
'$tor',
|
|
'$spt',
|
|
'$pendukung',
|
|
'$ba_um',
|
|
'$ba_ujicoba',
|
|
'$ba_pembayaran',
|
|
'$ba_kemajuan',
|
|
'SETOR',
|
|
NOW()
|
|
)");
|
|
}
|
|
} else
|
|
if ($key=='delete_verif') {
|
|
$id=$_POST['id'];
|
|
$st_termin=$_POST['st_termin'];
|
|
if ($st_termin=='termin') {
|
|
pg_query("DELETE FROM pengerjaan_npd WHERE vr_pelunasan_id='$id'");
|
|
pg_query("DELETE FROM vr_ba WHERE vr_pelunasan_id='$id'");
|
|
pg_query("DELETE FROM vr_pelunasan WHERE id='$id'");
|
|
$vr_realisasi_id=$_POST['vr_realisasi_id'];
|
|
$e=pg_query("SELECT id FROM vr_pelunasan WHERE vr_realisasi_id=$vr_realisasi_id AND data_ke <> 0 ORDER BY tanggal_input ASC");
|
|
$num=pg_numrows($e);
|
|
if ($num == 0) {
|
|
exit();
|
|
} else {
|
|
$i=1;
|
|
$d=pg_query("SELECT id FROM vr_pelunasan WHERE vr_realisasi_id=$vr_realisasi_id AND data_ke <> 0 ORDER BY tanggal_input ASC");
|
|
while($r=pg_fetch_array($d)) {
|
|
$vr_pelunasan_id=$r[0];
|
|
pg_query("UPDATE vr_pelunasan SET data_ke=$i WHERE id=$vr_pelunasan_id");
|
|
$i++;
|
|
}
|
|
}
|
|
} else {
|
|
pg_query("DELETE FROM pengerjaan_npd WHERE vr_pelunasan_id='$id'");
|
|
pg_query("DELETE FROM vr_ba WHERE vr_pelunasan_id='$id'");
|
|
pg_query("DELETE FROM vr_pelunasan WHERE id='$id'");
|
|
}
|
|
include('../reset_npd_hapus.php');
|
|
} else
|
|
if ($key=='fix') {
|
|
$id=$_POST['id'];
|
|
pg_query("UPDATE vr_pelunasan SET status_berkas='FIX' WHERE id='$id'");
|
|
} else
|
|
$key=$_POST['key'];
|
|
if ($key=='simpan_databa_baru') {
|
|
$id=$_POST['id'];
|
|
$pekerjaan_id=$_POST['pekerjaan_id'];
|
|
$berita_acara_id=$_POST['berita_acara_id'];
|
|
$nomor_ba=$_POST['nomor_ba'];
|
|
|
|
$nilai_ba=$_POST['nilai_ba'];
|
|
$nilai_ba=str_replace('.','',$nilai_ba);
|
|
$nilai_ba=str_replace(',','',$nilai_ba);
|
|
|
|
$tanggal_ba=$_POST['tanggal_ba'];
|
|
$tanggal_ba=str_replace('/','-',$tanggal_ba);
|
|
$tb=date('Y',strtotime($tanggal_ba));
|
|
$bb=date('m',strtotime($tanggal_ba));
|
|
$hb=date('d',strtotime($tanggal_ba));
|
|
$st_termin=$_POST['st_termin'];
|
|
$termin_ke=$_POST['termin_ke'];
|
|
$vr_pelunasan_id=$_POST['vr_pelunasan_id'];
|
|
|
|
$cek_add=pg_query("SELECT id FROM riwayat_ba WHERE id='$id'");
|
|
$row_add = pg_fetch_row($cek_add);
|
|
if ($row_add[0] > 0) {
|
|
$upd_add = pg_query("UPDATE riwayat_ba SET
|
|
berita_acara_id='$berita_acara_id',
|
|
nomor_ba='$nomor_ba',
|
|
tanggal_ba='$tb-$bb-$hb',
|
|
nilai_ba='$nilai_ba',
|
|
modified_at=NOW(),
|
|
vr_pelunasan_id='$vr_pelunasan_id',
|
|
st_termin='$st_termin',
|
|
termin_ke='$termin_ke'
|
|
WHERE id='$id'");
|
|
} else {
|
|
$ins_add = pg_query("INSERT into riwayat_ba (
|
|
pekerjaan_id,
|
|
berita_acara_id,
|
|
tanggal_ba,
|
|
created_at,
|
|
nomor_ba,
|
|
nilai_ba,
|
|
vr_pelunasan_id,
|
|
st_termin,
|
|
termin_ke
|
|
) values(
|
|
'$pekerjaan_id',
|
|
'$berita_acara_id',
|
|
'$tb-$bb-$hb',
|
|
NOW(),
|
|
'$nomor_ba',
|
|
'$nilai_ba',
|
|
'$vr_pelunasan_id',
|
|
'$st_termin',
|
|
'$termin_ke'
|
|
)
|
|
");
|
|
}
|
|
} else
|
|
if ($key=='hapus_databa') {
|
|
$id=$_POST['id'];
|
|
//$del=pg_query("DELETE FROM riwayat_ba WHERE id='$id'");
|
|
pg_query("UPDATE riwayat_ba SET vr_pelunasan_id=NULL WHERE id=$id");
|
|
} else
|
|
if ($key=='edit_urut') {
|
|
$id=$_POST['id'];
|
|
$edit=$_POST['edit'];
|
|
$edit=pg_query("UPDATE vr_pelunasan SET data_ke='$edit' WHERE id='$id'");
|
|
} else
|
|
if ($key=='simpan_revisi') {
|
|
$vr_pelunasan_id=$_POST['vr_pelunasan_id'];
|
|
$ket=$_POST['ket'];
|
|
$pemeriksa=$_POST['pemeriksa'];
|
|
pg_query("INSERT INTO vr_revisi (vr_pelunasan_id,tgl_revisi,ket,pemeriksa) VALUES ($vr_pelunasan_id,NOW(),'$ket','$pemeriksa')");
|
|
} else
|
|
if ($key=='fix_revisi') {
|
|
$vr_revisi_id=$_POST['vr_revisi_id'];
|
|
pg_query("UPDATE vr_revisi SET status='FIX' WHERE id=$vr_revisi_id");
|
|
} else
|
|
if ($key=='batal_fix_revisi') {
|
|
$vr_revisi_id=$_POST['vr_revisi_id'];
|
|
pg_query("UPDATE vr_revisi SET status=NULL WHERE id=$vr_revisi_id");
|
|
} else
|
|
if ($key=='hapus_revisi') {
|
|
$vr_revisi_id=$_POST['vr_revisi_id'];
|
|
pg_query("DELETE FROM vr_revisi WHERE id=$vr_revisi_id");
|
|
} else
|
|
if ($key=='batal_terima') {
|
|
$id=$_POST['id'];
|
|
pg_query("UPDATE vr_pelunasan SET tanggal_setor=NULL,tgl_setor_verif=NULL,st_setor_verif=NULL,st_cek_verif=NULL,tgl_terima_verif=NULL WHERE id=$id");
|
|
}
|
|
?>
|