516 lines
22 KiB
PHP
516 lines
22 KiB
PHP
<?php
|
|
include("../../koneksi.php");
|
|
$thn=$_POST['thn'];
|
|
$jenis=$_POST['jenis'];
|
|
$kegiatan=$_POST['kegiatan'];
|
|
$kpa=$_POST['kpa'];
|
|
$pptk=$_POST['pptk'];
|
|
$pgn=$_POST['pgn'];
|
|
$kom=$_POST['kom'];
|
|
$pejabat_pengadaan_id=$_POST['pejabat_pengadaan_id'];
|
|
$rh=$_POST['rh'];
|
|
$sub_kegiatan=$_POST['sub_kegiatan'];
|
|
?>
|
|
|
|
<style type="text/css">
|
|
input[type=checkbox] {
|
|
transform: scale(1.5);
|
|
}
|
|
|
|
.table > tbody > tr > td {
|
|
vertical-align: middle;
|
|
}
|
|
</style>
|
|
|
|
<script type="text/javascript">
|
|
$("#tabel_data_pr_anggaran").DataTable({"stateSave": false,"paging": true,"lengthChange": true,"searching": true,"ordering": false,"info": true,"autoWidth": false,
|
|
lengthMenu: [[500, -1], [500, "All"]],
|
|
"iDisplayLength": 500
|
|
});
|
|
</script>
|
|
<input type="hidden" id="awal">
|
|
<input type="hidden" id="temp_data" style="width:600px" value="<?php echo $tempdata; ?>">
|
|
|
|
<table id="tabel_data_pr_anggaran" class="table table-striped table-condensed table-bordered" cellpadding="1" style="font-family:Inter;font-size:13px">
|
|
<thead>
|
|
<tr style="color:grey;font-family:InterSB">
|
|
<td align="center" width="30">
|
|
<input type="checkbox" name="checkAll" id="checkAll" class="checkbox cb_data" aria-label="Single checkbox Two" ></td>
|
|
<td align="center" width="30px">Thn</td>
|
|
<?php
|
|
if ($jenis=='Perencanaan') {} else {
|
|
?>
|
|
<td align="center" width="30px"><button class="btn btn-block btn-xs ed_kpa">KPA</button></td>
|
|
<td align="center" width="30px"><button class="btn btn-block btn-xs ed_pptk">PPTK</button></td>
|
|
<td align="center" width="30px"><button class="btn btn-block btn-xs ed_ppkom">PPKOM</button></td>
|
|
<td align="center" width="30px"><button class="btn btn-block btn-xs ed_pejabat_pengadaan">PP</button></td>
|
|
<td align="center" width="30px"><button class="btn btn-block btn-xs ed_pkg">PKG</button></td>
|
|
<td align="center" width="35px"><button class="btn btn-block btn-xs ed_jenis">Jenis</button></td>
|
|
<?php
|
|
}
|
|
?>
|
|
<!--<td align="center">Jenis</td>-->
|
|
<td align="center" style="display:none">Kd</td>
|
|
<td align="center" width="130px">Rek</td>
|
|
<td align="center">Sub sub kegiatan / Belanja</td>
|
|
<?php
|
|
if (($jenis=='Perencanaan') || ($jenis=='Admin Utama')) {} else {
|
|
?>
|
|
<td align="center">Kode</td>
|
|
<td align="center" width="30px"><button class="btn btn-block btn-xs ed_bp">BP</button></td>
|
|
<td align="center" width="30px"><button class="btn btn-block btn-xs ed_ver">VER</button></td>
|
|
<?php
|
|
}
|
|
?>
|
|
<td align="center">Anggaran</td>
|
|
<!--<td align="center" style="color:black" width="90px">Penyerapan</td>
|
|
<td align="center" style="color:black" width="90px">Hutang</td>
|
|
<td align="center" style="color:black" width="90px">Realisasi</td>
|
|
<td align="center" width="100px">Sisa</td>-->
|
|
<td align="center" width="60">Tools</td>
|
|
</tr>
|
|
</thead>
|
|
<tbody style="color:black">
|
|
<?php
|
|
$data=pg_query("SELECT a.inisial,t.inisial,o.inisial,p.inisial,g.nama,
|
|
k.ra,k.rb,k.rc,k.rd,k.re,k.rf,k.rg,k.rh,k.sub_kegiatan,k.anggaran,
|
|
k.id,
|
|
k.kegiatan,k.kpa,k.pptk,
|
|
k.kd_panggil,b.inisial,pk.inisial,v.inisial,k.thn
|
|
FROM sub_kegiatan k
|
|
LEFT OUTER JOIN kpa a ON (a.id=k.kpa_id)
|
|
LEFT OUTER JOIN pptk t ON (t.id=k.pptk_id)
|
|
LEFT OUTER JOIN pejabat_pengadaan p ON (p.id=k.pejabat_pengadaan_id)
|
|
LEFT OUTER JOIN ppkom o ON (o.id=k.ppkom_id)
|
|
LEFT OUTER JOIN subkategori_kegiatan g ON (g.id=k.kategori_id)
|
|
LEFT OUTER JOIN bp b ON (b.id=k.bp_id)
|
|
LEFT OUTER JOIN pelaksana_kegiatan pk ON (pk.id=k.pelaksana_kegiatan_id)
|
|
LEFT OUTER JOIN verifikator v ON (v.id=k.verifikator_id)
|
|
WHERE k.thn='$thn'
|
|
".($sub_kegiatan == null ? "" : "AND k.sub_kegiatan='$sub_kegiatan'")."
|
|
".($pejabat_pengadaan_id == null ? "" : "AND k.pejabat_pengadaan_id='$pejabat_pengadaan_id'")."
|
|
".($kegiatan == null ? "" : "AND k.kegiatan='$kegiatan' AND k.rh='$rh'")."
|
|
".($kpa == null ? "" : "AND k.kpa_id='$kpa'")."
|
|
".($pptk == null ? "" : "AND k.pptk_id='$pptk'")."
|
|
".($pgn == null ? "" : "AND k.pejabat_pengadaan_id='$pgn'")."
|
|
".($kom == null ? "" : "
|
|
".($kom == "ALL" ? "AND (k.ppkom_id IS NOT NULL AND o.inisial <> 'PPK')" : "
|
|
".($kom == "NON" ? "AND (k.ppkom_id IS NULL OR o.inisial = 'PPK')" : "AND k.ppkom_id='$kom'")."
|
|
")."
|
|
")."
|
|
ORDER BY k.id DESC
|
|
");
|
|
|
|
while($r=pg_fetch_array($data)) {
|
|
?>
|
|
<tr>
|
|
<td align="center" class="kiri">
|
|
<input
|
|
type="checkbox" id='checkDelete' name='checkDelete[]' class="checkbox cb_data" value="<?php echo $r['id']; ?>"
|
|
aria-label="Single checkbox Two"
|
|
<?php
|
|
if($tempdata) {
|
|
$pizza = "$tempdata";
|
|
$pieces = explode(",", $pizza);
|
|
foreach ($pieces as $value) {
|
|
if ($r['id']==$value) {echo "checked";} else {}
|
|
}
|
|
} else {}
|
|
?>
|
|
>
|
|
</td>
|
|
<td align="center"><?php echo $r['thn']; ?></td>
|
|
<?php
|
|
if ($jenis=='Perencanaan') {} else {
|
|
?>
|
|
<td align="center"><?php if(($r[0]=='') || ($r[0]==NULL)) {echo '<i class="fa fa-ellipsis-h" ></i>';} else {echo $r[0];} ?></td>
|
|
<td align="center"><?php if(($r[1]=='') || ($r[1]==NULL)) {echo '<i class="fa fa-ellipsis-h" ></i>';} else {echo $r[1];} ?></td>
|
|
<td align="center"><?php if(($r[2]=='') || ($r[2]==NULL)) {echo '<i class="fa fa-ellipsis-h" ></i>';} else {echo $r[2];} ?></td>
|
|
<td align="center"><?php if(($r[3]=='') || ($r[3]==NULL)) {echo '<i class="fa fa-ellipsis-h" ></i>';} else {echo $r[3];} ?></td>
|
|
<td align="center"><?php if(($r[21]=='') || ($r[21]==NULL)) {echo '<i class="fa fa-ellipsis-h" ></i>';} else {echo $r[21];} ?></td>
|
|
<td align="center"><?php if(($r['nama']=='') || ($r['nama']==NULL)) {echo '<i class="fa fa-ellipsis-h" ></i>';} else {echo $r['nama'];} ?></td>
|
|
<?php
|
|
}
|
|
?>
|
|
<!--<td><?php echo $r[20]; ?></td>-->
|
|
<td align="center" class="kiri" style="display:none"><?php
|
|
if (!empty($r[12])) {
|
|
$no_pinjam=(int) substr($r[12],0,2);
|
|
$kode=sprintf("%02s",$no_pinjam);
|
|
echo $kode;
|
|
} else {echo "-";}
|
|
?></td>
|
|
<td>
|
|
<?php if(($r[5]=='') || ($r[5]==NULL)) {echo '<i class="fa fa-ellipsis-h" ></i>';} else {echo $r['kpa'].' '.$r['pptk'].' '.$r[5].' '.$r[6].' '.$r[7].' '.$r[8].' '.$r[9].' '.$r[10].' '.$r[11].' '.$r[12];} ?>
|
|
</td>
|
|
<td>
|
|
<span style="font-family:InterSB">
|
|
<?php if(($r[13]=='') || ($r[13]==NULL)) {echo '<i class="fa fa-ellipsis-h" ></i>';} else {echo $r[13];} ?>
|
|
</span><br>
|
|
<span>
|
|
<?php if(($r[16]=='') || ($r[16]==NULL)) {echo '<i class="fa fa-ellipsis-h" ></i>';} else {echo $r[16];} ?>
|
|
</span>
|
|
</td>
|
|
<?php
|
|
if (($jenis=='Perencanaan') || ($jenis=='Admin Utama')) {} else {
|
|
?>
|
|
<td>
|
|
<button class="btn btn-block btn-xs kdpanggil" style="font-family:Inter;font-size:13px;text-align: left !important;white-space: normal;word-wrap: break-word;" id="<?php echo $r['id'];?>">
|
|
<span style="font-family:InterSB">
|
|
<?php if(($r[19]=='') || ($r[19]==NULL)) {echo '<i class="fa fa-ellipsis-h" ></i>';} else {echo $r[19];} ?>
|
|
</span>
|
|
</button>
|
|
</td>
|
|
<td align="center"><?php if(($r[20]=='') || ($r[20]==NULL)) {echo '<i class="fa fa-ellipsis-h" ></i>';} else {echo $r[20];} ?></td>
|
|
<td align="center"><?php if(($r[22]=='') || ($r[22]==NULL)) {echo '<i class="fa fa-ellipsis-h" ></i>';} else {echo $r[22];} ?></td>
|
|
<?php
|
|
}
|
|
?>
|
|
<td align="right">
|
|
<span style="color:black">
|
|
<?php if(($r[14]=='') || ($r[14]==NULL)) {echo '<i class="fa fa-plus" ></i>';} else {echo number_format($r[14],0,',','.');} ?>
|
|
</span>
|
|
</td> <!-- anggaran -->
|
|
<!--<td align="right"><button class="btn btn-block btn-xs res" style="font-family:Inter;font-size:13px;text-align: right !important;" id="<?php echo $r['id'];?>"><?php echo number_format($r[15],0,',','.'); ?></button></td> <!-- Penyerapan -->
|
|
<!--<td align="right"><button class="btn btn-block btn-xs hut" style="font-family:Inter;font-size:13px;text-align: right !important;" id="<?php echo $r['id'];?>"><?php echo number_format($r[16],0,',','.'); ?></button></td> <!-- Hutang -->
|
|
<!--<td align="right"><button class="btn btn-block btn-xs res3" style="font-family:Inter;font-size:13px;text-align: right !important;" id="<?php echo $r['id'];?>"><?php echo number_format($r[17],0,',','.'); ?></button></td> <!-- Realisasi -->
|
|
|
|
<!--<td align="right" class="kanan"><span
|
|
<?php if($r[18]<0) {?>style="color:red"<?php } else { ?>style="color:green"<?php } ?>
|
|
><?php echo number_format($r[14]-($r[17]),0,',','.'); ?></span></td>-->
|
|
<td align="center" class="kanan">
|
|
<?php if ($jenis=='Perencanaan') { ?>
|
|
<button type="button" name="edit" style="height:22px;" class="btn btn-teal btn-xs edit" id="<?php echo $r['id'];?>" data-content="Edit" rel="popover" data-placement="top" data-trigger="hover">
|
|
<i class="fa fa-pencil"></i>
|
|
</button>
|
|
<button type="button" name="delete" style="height:22px;" class="btn btn-danger btn-xs delete" id="<?php echo $r['id'];?>" data-content="Hapus" rel="popover" data-placement="top" data-trigger="hover">
|
|
<i class="fa fa-remove"></i>
|
|
</button>
|
|
<?php } else {} ?>
|
|
</td>
|
|
</tr>
|
|
<?php
|
|
$totjml=$totjml+1;
|
|
$totnilai=$totnilai+$r[14];
|
|
}
|
|
?>
|
|
</tbody>
|
|
</table>
|
|
<input type="hidden" id="totnilai" value="<?php echo number_format($totnilai,0,',','.'); ?>">
|
|
|
|
|
|
|
|
<script>
|
|
|
|
$('button[name="edit"]').popover();
|
|
$('button[name="delete"]').popover();
|
|
|
|
var totnilai=$('#totnilai').val();
|
|
$('#pagu_totnilai').val(totnilai);
|
|
|
|
function getSelectedVal(){
|
|
let table=$('#tabel_data_pr_anggaran').DataTable();
|
|
let arr= [];
|
|
let checkedvalues = table.$('input:checked').each(function () {
|
|
arr.push($(this).attr('value'))
|
|
});
|
|
arr=arr.toString();
|
|
$("#temp_data").val(arr);
|
|
}
|
|
|
|
$("#checkAll").click(function () {
|
|
$('input:checkbox').not(this).prop('checked', this.checked);
|
|
});
|
|
|
|
$("input[type='checkbox']").change(function() {
|
|
getSelectedVal();
|
|
});
|
|
|
|
$("#tabel_data_pr_anggaran").on('click','.delete',function(){
|
|
var x = confirm("Anda yakin ingin menghapus ?");
|
|
if (x) {
|
|
var key = "delete_anggaran";
|
|
var id = $(this).attr('id');
|
|
var rowElement = $(this).parent().parent();
|
|
var thn=$("#thn_dpa option:selected").text();
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/master/pr_anggaran/crud.php",
|
|
data: 'id='+id
|
|
+'&key='+key,
|
|
success: function(data){
|
|
if(!$("#cari_kegiatan").val()) {
|
|
$('#tabel_anggaran').load('app/master/pr_anggaran/tabel.php',{thn:thn,jenis:jenis});
|
|
} else {
|
|
$('#cari_kegiatan').trigger('change');
|
|
}
|
|
}
|
|
});
|
|
} else {}
|
|
});
|
|
|
|
$("#tabel_data_pr_anggaran").on('click','.edit',function(){
|
|
var id = $(this).attr('id');
|
|
$('#modal_pagu').modal('show');
|
|
$('#modal_body_pagu').html("");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/master/pr_anggaran/modal_pagu.php",
|
|
data: 'id='+id,
|
|
success: function(data){
|
|
$('#modal_body_pagu').html(data);
|
|
}
|
|
});
|
|
});
|
|
|
|
|
|
$("#tabel_data_pr_anggaran").on('click','.ed_kpa',function(){
|
|
var a = $('#temp_data').val();
|
|
if (!a) {alert('Centanglah mana yang mau ditentukan');} else {
|
|
var id = $(this).attr('id');
|
|
var pil='kpa';
|
|
$('#modal_org').modal('show');
|
|
$('#modal_body_org').html("");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/master/pr_anggaran/modal_org.php",
|
|
data: 'id='+id
|
|
+'&pil='+pil,
|
|
success: function(data){
|
|
$('#modal_judul_org').html('');
|
|
$('#modal_body_org').html(data);
|
|
}
|
|
});
|
|
}
|
|
});
|
|
|
|
$("#tabel_data_pr_anggaran").on('click','.ed_pptk',function(){
|
|
var a = $('#temp_data').val();
|
|
if (!a) {alert('Centanglah mana yang mau ditentukan');} else {
|
|
var id = $(this).attr('id');
|
|
var pil='pptk';
|
|
$('#modal_org').modal('show');
|
|
$('#modal_body_org').html("");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/master/pr_anggaran/modal_org.php",
|
|
data: 'id='+id
|
|
+'&pil='+pil,
|
|
success: function(data){
|
|
$('#modal_judul_org').html('');
|
|
$('#modal_body_org').html(data);
|
|
}
|
|
});
|
|
}
|
|
});
|
|
|
|
|
|
$("#tabel_data_pr_anggaran").on('click','.ed_ppkom',function(){
|
|
var a = $('#temp_data').val();
|
|
if (!a) {alert('Centanglah mana yang mau ditentukan');} else {
|
|
var id = $(this).attr('id');
|
|
var pil='ppkom';
|
|
$('#modal_org').modal('show');
|
|
$('#modal_body_org').html("");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/master/pr_anggaran/modal_org.php",
|
|
data: 'id='+id
|
|
+'&pil='+pil,
|
|
success: function(data){
|
|
$('#modal_judul_org').html('');
|
|
$('#modal_body_org').html(data);
|
|
}
|
|
});
|
|
}
|
|
});
|
|
|
|
$("#tabel_data_pr_anggaran").on('click','.ed_pejabat_pengadaan',function(){
|
|
var a = $('#temp_data').val();
|
|
if (!a) {alert('Centanglah mana yang mau ditentukan');} else {
|
|
var id = $(this).attr('id');
|
|
var pil='pejabat_pengadaan';
|
|
$('#modal_org').modal('show');
|
|
$('#modal_body_org').html("");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/master/pr_anggaran/modal_org.php",
|
|
data: 'id='+id
|
|
+'&pil='+pil,
|
|
success: function(data){
|
|
$('#modal_judul_org').html('');
|
|
$('#modal_body_org').html(data);
|
|
}
|
|
});
|
|
}
|
|
});
|
|
|
|
$("#tabel_data_pr_anggaran").on('click','.ed_pkg',function(){
|
|
var a = $('#temp_data').val();
|
|
if (!a) {alert('Centanglah mana yang mau ditentukan');} else {
|
|
var id = $(this).attr('id');
|
|
var pil='pkg';
|
|
$('#modal_org').modal('show');
|
|
$('#modal_body_org').html("");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/master/pr_anggaran/modal_org.php",
|
|
data: 'id='+id
|
|
+'&pil='+pil,
|
|
success: function(data){
|
|
$('#modal_judul_org').html('');
|
|
$('#modal_body_org').html(data);
|
|
}
|
|
});
|
|
}
|
|
});
|
|
|
|
/*
|
|
$("#tabel_data_pr_anggaran").on('click','.ed_ppkom, .ed_pejabat_pengadaan, .ed_pkg',function(){
|
|
var a = $('#temp_data').val();
|
|
if (!a) {alert('Centanglah mana yang mau ditentukan');} else {
|
|
var id = $(this).attr('id');
|
|
var pil='kpa';
|
|
$('#modal_orgall').modal('show');
|
|
$('#modal_body_orgall').html("");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/master/pr_anggaran/modal_orgall.php",
|
|
data: 'id='+id,
|
|
success: function(data){
|
|
$('#modal_judul_orgall').html('');
|
|
$('#modal_body_orgall').html(data);
|
|
}
|
|
});
|
|
}
|
|
});
|
|
*/
|
|
|
|
$("#tabel_data_pr_anggaran").on('click','.ed_jenis',function(){
|
|
var a = $('#temp_data').val();
|
|
if (!a) {alert('Centanglah mana yang mau ditentukan');} else {
|
|
var id = $(this).attr('id');
|
|
$('#modal_jenis').modal('show');
|
|
$('#modal_body_jenis').html("");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/master/pr_anggaran/modal_jenis.php",
|
|
data: 'id='+id,
|
|
success: function(data){
|
|
$('#modal_judul_jenis').html('');
|
|
$('#modal_body_jenis').html(data);
|
|
}
|
|
});
|
|
}
|
|
});
|
|
|
|
$("#tabel_data_pr_anggaran").on('click','.ed_bp',function(){
|
|
var a = $('#temp_data').val();
|
|
if (!a) {alert('Centanglah mana yang mau ditentukan');} else {
|
|
var id = $(this).attr('id');
|
|
var pil='bp';
|
|
$('#modal_org').modal('show');
|
|
$('#modal_body_org').html("");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/master/pr_anggaran/modal_org.php",
|
|
data: 'id='+id
|
|
+'&pil='+pil,
|
|
success: function(data){
|
|
$('#modal_judul_org').html('');
|
|
$('#modal_body_org').html(data);
|
|
}
|
|
});
|
|
}
|
|
});
|
|
|
|
$("#tabel_data_pr_anggaran").on('click','.ed_ver',function(){
|
|
var a = $('#temp_data').val();
|
|
if (!a) {alert('Centanglah mana yang mau ditentukan');} else {
|
|
var id = $(this).attr('id');
|
|
var pil='ver';
|
|
$('#modal_org').modal('show');
|
|
$('#modal_body_org').html("");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/master/pr_anggaran/modal_org.php",
|
|
data: 'id='+id
|
|
+'&pil='+pil,
|
|
success: function(data){
|
|
$('#modal_judul_org').html('');
|
|
$('#modal_body_org').html(data);
|
|
}
|
|
});
|
|
}
|
|
});
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$("#tabel_data_pr_anggaran").on('click','.kdpanggil',function(){
|
|
var id = $(this).attr('id');
|
|
$('#modal_kdpanggil').modal('show');
|
|
$('#modal_body_kdpanggil').html("");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/master/pr_anggaran/modal_kdpanggil.php",
|
|
data: 'id='+id,
|
|
success: function(data){
|
|
$('#modal_body_kdpanggil').html(data);
|
|
}
|
|
});
|
|
});
|
|
/*
|
|
$("#tabel_data_pr_anggaran").on('click','.ed_anggaran',function(){
|
|
var id = $(this).attr('id');
|
|
$('#modal_anggaran').modal('show');
|
|
$('#modal_body_anggaran').html("");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/master/pr_anggaran/modal_anggaran.php",
|
|
data: 'id='+id,
|
|
success: function(data){
|
|
$('#modal_body_anggaran').html(data);
|
|
}
|
|
});
|
|
});
|
|
|
|
$("#tabel_data_pr_anggaran").on('click','.ed_belanja',function(){
|
|
var id = $(this).attr('id');
|
|
$('#modal_belanja').modal('show');
|
|
$('#modal_body_belanja').html("");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/master/pr_anggaran/modal_belanja.php",
|
|
data: 'id='+id,
|
|
success: function(data){
|
|
$('#modal_body_belanja').html(data);
|
|
}
|
|
});
|
|
});
|
|
|
|
$("#tabel_data_pr_anggaran").on('click','.ed_rek',function(){
|
|
var id = $(this).attr('id');
|
|
$('#modal_rek').modal('show');
|
|
$('#modal_body_rek').html("");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/master/pr_anggaran/modal_rek.php",
|
|
data: 'id='+id,
|
|
success: function(data){
|
|
$('#modal_body_rek').html(data);
|
|
}
|
|
});
|
|
});
|
|
*/
|
|
|
|
|
|
|
|
</script>
|
|
|
|
|