81 lines
2.4 KiB
PHP
81 lines
2.4 KiB
PHP
<?php
|
|
include("../../koneksi.php");
|
|
$key=$_POST['key'];
|
|
$thn=$_POST['thn'];
|
|
if ($key=='cek_anggaran') {
|
|
$hitung=pg_query("SELECT COUNT(anggaran)
|
|
FROM sub_kegiatan
|
|
WHERE thn='$thn' AND anggaran IS NOT NULL
|
|
");
|
|
while($h=pg_fetch_array($hitung)) {$j=$h[0];}
|
|
if ($j==0) {echo "kosong";} else {echo "ada";}
|
|
} else
|
|
if ($key=='cek_kegiatan') {
|
|
$k=pg_query("SELECT DISTINCT kegiatan,CASE WHEN rh!='' THEN CONCAT(rh,' - ') ELSE '' END,
|
|
rh, NULLIF(regexp_replace(rh,'\D','','g'),'')::numeric
|
|
FROM sub_kegiatan WHERE thn='$thn'
|
|
ORDER BY NULLIF(regexp_replace(rh,'\D','','g'),'')::numeric ASC,kegiatan ASC
|
|
");
|
|
while($rk=pg_fetch_array($k)) {
|
|
echo "<option value='".$rk[0]."-".$rk[2]."'>".$rk[1]."".$rk[0]."</option>";
|
|
}
|
|
} else
|
|
if ($key=='cek_gtotal') {
|
|
$kegiatan=$_POST['kegiatan'];
|
|
$c=pg_query("SELECT SUM(anggaran) FROM sub_kegiatan WHERE thn='$thn'
|
|
AND anggaran IS NOT NULL
|
|
".($kegiatan == null ? "" : "AND kegiatan='$kegiatan'")."
|
|
");
|
|
while($rc=pg_fetch_array($c)) {echo number_format($rc[0],0,',','.'); }
|
|
} else
|
|
if ($key=='set_pejabat') {
|
|
$a=$_POST['sub_kegiatan_id'];
|
|
$pejabat_pengadaan_id=$_POST['pejabat_pengadaan_id'];
|
|
$pecah=explode(',',$a);
|
|
foreach($pecah as $selected) {
|
|
$r=pg_query("UPDATE sub_kegiatan SET pejabat_pengadaan_id='$pejabat_pengadaan_id' WHERE id='$selected'");
|
|
}
|
|
} else
|
|
if ($key=='set_kom') {
|
|
$a=$_POST['sub_kegiatan_id'];
|
|
$ppkom_id=$_POST['ppkom_id'];
|
|
$pecah=explode(',',$a);
|
|
foreach($pecah as $selected) {
|
|
$r=pg_query("UPDATE sub_kegiatan SET ppkom_id='$ppkom_id' WHERE id='$selected'");
|
|
}
|
|
} else
|
|
if ($key=='set_kat') {
|
|
$a=$_POST['sub_kegiatan_id'];
|
|
$kategori_id=$_POST['kategori_id'];
|
|
$pecah=explode(',',$a);
|
|
foreach($pecah as $selected) {
|
|
$r=pg_query("UPDATE sub_kegiatan SET kategori_id='$kategori_id' WHERE id='$selected'");
|
|
}
|
|
} else
|
|
if ($key=='simpan_anggaran') {
|
|
$id=$_POST['id'];
|
|
$thn=$_POST['thn'];
|
|
$kegiatan=$_POST['kegiatan'];
|
|
$ra=$_POST['ra'];
|
|
$rb=$_POST['rb'];
|
|
$rc=$_POST['rc'];
|
|
$rd=$_POST['rd'];
|
|
$re=$_POST['re'];
|
|
$rf=$_POST['rf'];
|
|
$rg=$_POST['rg'];
|
|
$rh=$_POST['rh'];
|
|
$sub_kegiatan=$_POST['sub_kegiatan'];
|
|
$anggaran=$_POST['anggaran'];
|
|
$anggaran_ori=$_POST['anggaran_ori'];
|
|
$kpa_id=$_POST['kpa_id'];
|
|
$ppkom_id=$_POST['ppkom_id'];
|
|
$pptk_id=$_POST['pptk_id'];
|
|
$pejabat_pengadaan_id=$_POST['pejabat_pengadaan_id'];
|
|
$kategori_id=$_POST['kategori_id'];
|
|
$u=pg_query("UPDATE sub_kegiatan SET
|
|
pejabat_pengadaan_id='$pejabat_pengadaan_id',
|
|
kategori_id='$kategori_id'
|
|
WHERE id='$id'
|
|
");
|
|
}
|
|
?>
|