234 lines
7.5 KiB
PHP
234 lines
7.5 KiB
PHP
<?php
|
|
include ('../../koneksi.php');
|
|
$sub_kegiatan_id=$_POST['id'];
|
|
$data=pg_query("SELECT p1,k1,sk1,sub_kegiatan,kegiatan,kpa,pptk,ra,rb,rc,rd,re,rf,rg,rh,anggaran FROM sub_kegiatan WHERE id=$sub_kegiatan_id");
|
|
while($row=pg_fetch_array($data)) {
|
|
$p1=$row['p1'];
|
|
$k1=$row['k1'];
|
|
$sk1=$row['sk1'];
|
|
$sub_kegiatan=$row['sub_kegiatan'];
|
|
$kegiatan=$row['kegiatan'];
|
|
$kpa=$row['kpa'];
|
|
$pptk=$row['pptk'];
|
|
$ra=$row['ra'];
|
|
$rb=$row['rb'];
|
|
$rc=$row['rc'];
|
|
$rd=$row['rd'];
|
|
$re=$row['re'];
|
|
$rf=$row['rf'];
|
|
$rg=$row['rg'];
|
|
$rh=$row['rh'];
|
|
$anggaran=$row['anggaran'];
|
|
}
|
|
$arr1 = str_split($rc);
|
|
?>
|
|
|
|
<input type="hidden" value="<?php echo $sub_kegiatan_id; ?>" id="pr_sub_kegiatan_id">
|
|
|
|
<div class="form-group">
|
|
<label for="exampleInputEmail1">Fungsional / Subsidi</label>
|
|
<select class="form-control" name="pb_fs" id="pb_fs">
|
|
<option value="f">FUNGSIONAL</option>
|
|
<option value="s">SUBSIDI</option>
|
|
</select>
|
|
</div>
|
|
|
|
<div class="form-group">
|
|
<label for="exampleInputEmail1">Program</label>
|
|
<input type="text" class="form-control" list="br_p1" name="browser" id="pb_p1" value="<?php echo $p1; ?>">
|
|
<datalist id="br_p1">
|
|
<?php
|
|
$d=pg_query("SELECT p1 FROM sub_kegiatan WHERE CAST(thn AS INTEGER)>=2024
|
|
GROUP BY p1
|
|
ORDER BY p1 ASC");
|
|
while($rows=pg_fetch_array($d)) {
|
|
?>
|
|
<option value="<?php echo $rows[0]; ?>"><?php echo $rows[0]; ?></option>
|
|
<?php
|
|
}
|
|
?>
|
|
</datalist>
|
|
</div>
|
|
|
|
<div class="form-group">
|
|
<label for="exampleInputEmail1">Kegiatan</label>
|
|
<input type="text" class="form-control" list="br_k1" name="browser" id="pb_k1" value="<?php echo $k1; ?>">
|
|
<datalist id="br_k1">
|
|
<?php
|
|
$d=pg_query("SELECT k1 FROM sub_kegiatan WHERE CAST(thn AS INTEGER)>=2024
|
|
GROUP BY k1
|
|
ORDER BY k1 ASC");
|
|
while($rows=pg_fetch_array($d)) {
|
|
?>
|
|
<option value="<?php echo $rows[0]; ?>"><?php echo $rows[0]; ?></option>
|
|
<?php
|
|
}
|
|
?>
|
|
</datalist>
|
|
</div>
|
|
|
|
<div class="form-group">
|
|
<label for="exampleInputEmail1">Sub Kegiatan</label>
|
|
<input type="text" class="form-control" list="br_sk1" name="browser" id="pb_sk1" value="<?php echo $sk1; ?>">
|
|
<datalist id="br_sk1">
|
|
<?php
|
|
$d=pg_query("SELECT sk1 FROM sub_kegiatan WHERE CAST(thn AS INTEGER)>=2024
|
|
GROUP BY sk1
|
|
ORDER BY sk1 ASC");
|
|
while($rows=pg_fetch_array($d)) {
|
|
?>
|
|
<option value="<?php echo $rows[0]; ?>"><?php echo $rows[0]; ?></option>
|
|
<?php
|
|
}
|
|
?>
|
|
</datalist>
|
|
</div>
|
|
|
|
<div class="form-group">
|
|
<label for="exampleInputEmail1">Sub Sub Kegiatan</label>
|
|
<input type="text" class="form-control" list="br_sub_kegiatan" name="browser" id="pb_sub_kegiatan" value="<?php echo $sub_kegiatan; ?>">
|
|
<datalist id="br_sub_kegiatan">
|
|
<?php
|
|
$d=pg_query("SELECT sub_kegiatan FROM sub_kegiatan WHERE CAST(thn AS INTEGER)>=2024
|
|
GROUP BY sub_kegiatan
|
|
ORDER BY sub_kegiatan ASC");
|
|
while($rows=pg_fetch_array($d)) {
|
|
?>
|
|
<option value="<?php echo $rows[0]; ?>"><?php echo $rows[0]; ?></option>
|
|
<?php
|
|
}
|
|
?>
|
|
</datalist>
|
|
</div>
|
|
|
|
<div class="form-group">
|
|
<label for="exampleInputEmail1">Belanja</label>
|
|
<input type="text" class="form-control" list="br_kegiatan" name="browser" id="pb_kegiatan" value="<?php echo $kegiatan; ?>">
|
|
<datalist id="br_kegiatan">
|
|
<?php
|
|
$d=pg_query("SELECT kegiatan FROM sub_kegiatan WHERE CAST(thn AS INTEGER)>=2024
|
|
GROUP BY kegiatan
|
|
ORDER BY kegiatan ASC");
|
|
while($rows=pg_fetch_array($d)) {
|
|
?>
|
|
<option value="<?php echo $rows[0]; ?>"><?php echo $rows[0]; ?></option>
|
|
<?php
|
|
}
|
|
?>
|
|
</datalist>
|
|
</div>
|
|
|
|
|
|
|
|
<div class="row">
|
|
<div class="col-lg-1">
|
|
<div class="form-group">
|
|
<label for="exampleInputEmail1">A</label>
|
|
<input type="text" class="form-control reks" value="<?php echo $kpa; ?>" id="pr_kpa">
|
|
</div>
|
|
</div>
|
|
<div class="col-lg-1">
|
|
<div class="form-group">
|
|
<label for="exampleInputEmail1">B</label>
|
|
<input type="text" class="form-control reks" value="<?php echo $pptk; ?>" id="pr_pptk">
|
|
</div>
|
|
</div>
|
|
<div class="col-lg-1">
|
|
<div class="form-group">
|
|
<label for="exampleInputEmail1">C</label>
|
|
<input type="text" class="form-control reks" value="<?php echo $ra; ?>" id="pr_ra">
|
|
</div>
|
|
</div>
|
|
<div class="col-lg-1">
|
|
<div class="form-group">
|
|
<label for="exampleInputEmail1">D</label>
|
|
<input type="text" class="form-control reks" value="<?php echo $rb; ?>" id="pr_rb">
|
|
</div>
|
|
</div>
|
|
<div class="col-lg-1">
|
|
<div class="form-group">
|
|
<label for="exampleInputEmail1">E</label>
|
|
<input type="text" class="form-control reks" value="<?php echo $arr1[0]; ?>" id="pr_rc1">
|
|
</div>
|
|
</div>
|
|
<div class="col-lg-1">
|
|
<div class="form-group">
|
|
<label for="exampleInputEmail1">F</label>
|
|
<input type="text" class="form-control reks" value="<?php echo $arr1[1]; ?>" id="pr_rc2">
|
|
</div>
|
|
</div>
|
|
<div class="col-lg-1">
|
|
<div class="form-group">
|
|
<label for="exampleInputEmail1">G</label>
|
|
<input type="text" class="form-control reks" value="<?php echo $rd; ?>" id="pr_rd">
|
|
</div>
|
|
</div>
|
|
<div class="col-lg-1">
|
|
<div class="form-group">
|
|
<label for="exampleInputEmail1">H</label>
|
|
<input type="text" class="form-control reks" value="<?php echo $re; ?>" id="pr_re">
|
|
</div>
|
|
</div>
|
|
<div class="col-lg-1">
|
|
<div class="form-group">
|
|
<label for="exampleInputEmail1">I</label>
|
|
<input type="text" class="form-control reks" value="<?php echo $rf; ?>" id="pr_rf">
|
|
</div>
|
|
</div>
|
|
<div class="col-lg-2">
|
|
<div class="form-group">
|
|
<label for="exampleInputEmail1">J</label>
|
|
<input type="text" class="form-control reks" value="<?php echo $rg; ?>" id="pr_rg">
|
|
</div>
|
|
</div>
|
|
<div class="col-lg-1">
|
|
<div class="form-group">
|
|
<label for="exampleInputEmail1">K</label>
|
|
<input type="text" class="form-control reks" value="<?php echo $rh; ?>" id="pr_rh">
|
|
</div>
|
|
</div>
|
|
</div>
|
|
|
|
<div class="form-group">
|
|
<label for="exampleInputEmail1">Anggaran</label>
|
|
<input type="text" class="form-control" id="pa_anggaran" onkeyup="formatAngka(this,'.')" value="<?php echo number_format($anggaran,0,",","."); ?>">
|
|
</div>
|
|
|
|
<script>
|
|
function formatAngka(objek, separator) {
|
|
a = objek.value;b = a.replace(/[^\d]/g,"");c="";panjang=b.length;j=0;
|
|
for(i=panjang;i>0;i--) {j=j+1;if(((j%3)==1)&&(j!=1)) {c=b.substr(i-1,1)+separator+c;} else {c=b.substr(i-1,1)+c;}}objek.value=c;
|
|
}
|
|
|
|
function validAngka(a) {
|
|
if(!/^[0-9.]+$/.test(a.value)){a.value = a.value.substring(0,a.value.length-1000);}
|
|
}
|
|
|
|
$('#pb_kegiatan').change(function(){
|
|
var a=$('#pb_kegiatan').val();
|
|
var key='cek_rek';
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/master/pr_anggaran/crud.php",
|
|
data: 'kegiatan='+a
|
|
+'&key='+key,
|
|
success: function(data){
|
|
var b = data.split('!@#$');
|
|
$('#pr_kpa').val(b[0]);
|
|
$('#pr_pptk').val(b[1]);
|
|
$('#pr_ra').val(b[2]);
|
|
$('#pr_rb').val(b[3]);
|
|
$('#pr_rc1').val(b[4]);
|
|
$('#pr_rc2').val(b[5]);
|
|
$('#pr_rd').val(b[6]);
|
|
$('#pr_re').val(b[7]);
|
|
$('#pr_rf').val(b[8]);
|
|
$('#pr_rg').val(b[9]);
|
|
$('#pr_rh').val(b[10]);
|
|
}
|
|
});
|
|
});
|
|
|
|
</script>
|
|
|