Files
eletter-backup/app/kirim/tabel_kepada1.php
2024-05-31 14:18:00 +07:00

69 lines
2.5 KiB
PHP

<?php
include("../koneksi.php");
$surat_id=$_POST['surat_id'];
?>
<script type="text/javascript">$("#tabel_data_kepada_kr").DataTable({"paging": false,"lengthChange": false,"searching": false,"ordering": false,"info": false,"autoWidth": false});</script>
<input type="hidden" id="surat_idxxx" value="<?php echo $surat_id;?>">
<table id="tabel_data_kepada_kr" class="table table-striped table-condensed" cellpadding="1">
<thead>
<tr>
<td><b>Kepada</b></td>
<td align="center"><b>Tools</b></td>
</tr>
</thead>
<tbody style="color:black">
<?php
$d=pg_query("SELECT
(SELECT j.nama FROM jabatan_pegawai j WHERE j.id=k.kepada),k.id
FROM kirim k INNER JOIN surat s ON (k.surat_id=s.id)
WHERE k.kepada IS NOT NULL AND k.surat_id='$surat_id'
ORDER BY k.id ASC");
while($r=pg_fetch_array($d)) {
?>
<tr>
<td class="kiri"><b><?php echo $r[0]; ?></b></td>
<td class="kanan md_kpd" align="center">
<button type="button" name="delete_kepada_kr" style="height:22px;"class="btn btn-danger btn-xs delete_kepada_kr" id="<?php echo $r['id'];?>" data-content="Hapus" rel="popover" data-placement="top" data-trigger="hover"
><i class="fa fa-remove"></i></button>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
<script>
$('button[name="delete_kepada_kr"]').popover();
$("#tabel_data_kepada_kr").on('click','.delete_kepada_kr',function(){
var x = confirm("Anda yakin ingin menghapus ?");
if (x) {
var key = "delete_kepada_kr";
var id = $(this).attr('id');
var rowElement = $(this).parent().parent();
$.ajax({
type: "POST",
url: "app/kirim/crud.php",
data: 'id='+id
+'&key='+key,
success: function(data){
rowElement.fadeOut(500).remove();
var key="jumlah_kepada";
var surat_id = $('#surat_idxxx').val();
$.ajax({
type: "POST",
url: "app/kirim/crud.php",
data: 'surat_id='+surat_id
+'&key='+key,
success: function(data){
$('.sp'+surat_id).html(' ('+data+')');
}
});
}
});
} else {}
});
</script>