59 lines
3.0 KiB
PHP
59 lines
3.0 KiB
PHP
<?php
|
|
include("../koneksi.php");
|
|
$key=$_POST['key'];
|
|
if ($key=='setor') {
|
|
$thn=$_POST['thn'];
|
|
$nama_verifikator=$_POST['nama_verifikator'];
|
|
$a=strtoupper($_POST['a']);
|
|
$b=strtoupper($_POST['b']);
|
|
$c=strtoupper($_POST['c']);
|
|
|
|
$tgl_modal_setor=$_POST['tgl_modal_setor'];
|
|
$tgl_modal_setor=str_replace('/','-',$tgl_modal_setor);
|
|
$ts=date('Y',strtotime($tgl_modal_setor));
|
|
$bs=date('m',strtotime($tgl_modal_setor));
|
|
$hs=date('d',strtotime($tgl_modal_setor));
|
|
|
|
$maxi=pg_query("SELECT COALESCE(MAX(setor_ke),0) FROM vr_pelunasan WHERE tanggal_setor='$ts-$bs-$hs' AND nama_verfikator='$nama_verifikator'");
|
|
while($rmax=pg_fetch_array($maxi)) {$maxset=$rmax[0];$setor_ke=$maxset+1;}
|
|
|
|
$a=$_POST['vr_pelunasan_id'];
|
|
$pecah=explode(',',$a);
|
|
foreach($pecah as $selected) {
|
|
pg_query("UPDATE vr_pelunasan SET tanggal_setor='$ts-$bs-$hs', setor_ke='$setor_ke' WHERE id='$selected'");
|
|
}
|
|
/*
|
|
$d=pg_query("SELECT l.id,l.tanggal_setor
|
|
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 rekanan n ON (n.id=p.rekanan_id)
|
|
WHERE s.thn='$thn' AND l.nama_verfikator='$nama_verifikator' AND l.status_berkas='FIX' AND l.tanggal_lunas IS NULL
|
|
".($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'")."
|
|
")."
|
|
".($c == 'ALL' ? "" : "AND l.tanggal_setor IS NULL")."
|
|
");
|
|
while(($r=pg_fetch_array($d)) !== FALSE) {
|
|
$id=$r[0];
|
|
$tanggal_setor=$r[1];
|
|
if ($tanggal_setor==NULL) {
|
|
pg_query("UPDATE vr_pelunasan SET tanggal_setor='$ts-$bs-$hs', setor_ke='$setor_ke' WHERE id='$id'");
|
|
} else {}
|
|
}
|
|
*/
|
|
} else
|
|
if ($key=='edit_tanggal_setor') {
|
|
$edit_tgl_modal_setor=$_POST['edit_tgl_modal_setor'];
|
|
$edit_tgl_modal_setor=str_replace('/','-',$edit_tgl_modal_setor);
|
|
$ts=date('Y',strtotime($edit_tgl_modal_setor));
|
|
$bs=date('m',strtotime($edit_tgl_modal_setor));
|
|
$hs=date('d',strtotime($edit_tgl_modal_setor));
|
|
$vr_pelunasan_id=$_POST['vr_pelunasan_id'];
|
|
pg_query("UPDATE vr_pelunasan SET tanggal_setor='$ts-$bs-$hs' WHERE id='$vr_pelunasan_id'");
|
|
}
|
|
?>
|