88 lines
4.6 KiB
PHP
88 lines
4.6 KiB
PHP
<?php
|
|
include('../../koneksi.php');
|
|
?>
|
|
|
|
<script type="text/javascript">$("#tabel_data_rekening").DataTable({"stateSave": true,"paging": true,"lengthChange": true,"searching": true,"ordering": true,"info": true,"autoWidth": false});</script>
|
|
<table id="tabel_data_rekening" class="table table-striped table-bordered table-condensed tb_master" cellpadding="1">
|
|
<thead style="font-weight:bold">
|
|
<tr>
|
|
<td align="center" width="150px;" align="center">Kode Panggil</td>
|
|
<td align="center">Kegiatan</td>
|
|
<td align="center">Sub Kegiatan</td>
|
|
<td align="center" width="150px;">Jenis Anggaran</td>
|
|
<td align="center" width="150px;">Jenis SPPD</td>
|
|
<td align="center" width="50px;">Aktif</td>
|
|
<td align="center" width="50px;">Tools</td>
|
|
</tr>
|
|
</thead>
|
|
<tbody style="color:black">
|
|
<?php
|
|
$data = pg_query("SELECT u.id,u.sub_kegiatan_id,u.jenis_anggaran,u.jenis_sppd,u.aktif,p.kd_panggil,p.kegiatan,p.sub_kegiatan
|
|
FROM sp_rek u
|
|
INNER JOIN sub_kegiatan p ON (p.id=u.sub_kegiatan_id)
|
|
");
|
|
while($row=pg_fetch_array($data)) {
|
|
?>
|
|
<tr>
|
|
<td class="kiri"><?php echo $row['kd_panggil']; ?></td>
|
|
<td><?php echo $row['kegiatan']; ?></td>
|
|
<td><?php echo $row['sub_kegiatan']; ?></td>
|
|
<td><?php echo $row['jenis_anggaran']; ?></td>
|
|
<td><?php echo $row['jenis_sppd'].' PROPINSI'; ?></td>
|
|
<td align="center"><?php if ($row[4]=='t') {echo 'ON';} else {echo 'OFF';} ?></td>
|
|
<td align="center" class="kanan">
|
|
<button type="button" name="edit_rekening" style="height:22px;" class="btn btn-teal btn-xs edit_rekening" id="<?php echo $row['id'];?>" data-content="Edit" rel="popover" data-placement="top" data-trigger="hover">
|
|
<i class="fa fa fa-pencil"></i>
|
|
</button>
|
|
<!-- <button type="button" name="delete_rekening" style="height:22px;"class="btn btn-danger btn-xs delete_rekening" id="<?php echo $row['id'];?>" data-content="Hapus" rel="popover" data-placement="bottom" data-trigger="hover">
|
|
<i class="fa fa-remove"></i>
|
|
</button> -->
|
|
</td>
|
|
</tr>
|
|
<?php
|
|
}
|
|
?>
|
|
</tbody>
|
|
</table>
|
|
|
|
|
|
|
|
<script type="text/javascript">
|
|
|
|
$('button[name="edit_rekening"]').popover();
|
|
$("#tabel_data_rekening").on('click','.edit_rekening',function(){
|
|
var id = $(this).attr('id');
|
|
$('#modal_rekening').modal('show');
|
|
$('#modal_body_rekening').html("");
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/master/rek/modal.php",
|
|
data: 'id='+id,
|
|
success: function(data){
|
|
$('#modal_body_rekening').html(data);
|
|
$('#nama').first().focus().selected();
|
|
}
|
|
});
|
|
});
|
|
|
|
|
|
$("#tabel_data_rekening").on('click','.delete_rekening',function(){
|
|
var x = confirm("Anda yakin ingin menghapus ?");
|
|
if (x) {
|
|
var key = "delete_rekening";
|
|
var id = $(this).attr('id');
|
|
var rowElement = $(this).parent().parent();
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/master/rek/crud.php",
|
|
data: 'id='+id
|
|
+'&key='+key,
|
|
success: function(data){
|
|
rowElement.fadeOut(500).remove();
|
|
}
|
|
});
|
|
} else {}
|
|
});
|
|
</script>
|
|
|