31 lines
1.3 KiB
PHP
31 lines
1.3 KiB
PHP
<?php include("../koneksi.php"); ?>
|
|
<select class="form-control" name="cari_adm_pengadaan" id="cari_adm_pengadaan"
|
|
style="font-family:Arial;margin-top:-2px;border:0px;border-radius:0px;border-bottom: 1px solid #ccd3d6;font-weight:bold">
|
|
<option value=""><span>-- ALL --</span></option>
|
|
<?php
|
|
|
|
$d=pg_query("SELECT DISTINCT l.adm_pengadaan
|
|
FROM pekerjaan p
|
|
INNER JOIN sub_kegiatan s ON (s.id=p.sub_kegiatan_id)
|
|
INNER JOIN rekanan k ON (k.id=p.rekanan_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.tgl_setor_verif IS NOT NULL AND l.nama_verfikator IS NULL
|
|
");
|
|
while($r=pg_fetch_array($d)) {
|
|
?>
|
|
<option value="<?php echo $r[0];?>"><?php echo $r[0];?></option>
|
|
<?php } ?>
|
|
</select>
|
|
<br>
|
|
<div id="tabel_setoran"></div>
|
|
|
|
<script>
|
|
var cari_adm_pengadaan=$('#cari_adm_pengadaan').val();
|
|
$('#tabel_setoran').load("app/kendali/tabel_setoran.php",{cari_adm_pengadaan:cari_adm_pengadaan});
|
|
|
|
$('#cari_adm_pengadaan').change(function(){
|
|
var cari_adm_pengadaan=$('#cari_adm_pengadaan').val();
|
|
$('#tabel_setoran').load("app/kendali/tabel_setoran.php",{cari_adm_pengadaan:cari_adm_pengadaan});
|
|
});
|
|
</script>
|