69 lines
2.7 KiB
PHP
69 lines
2.7 KiB
PHP
<?php
|
|
include('../../koneksi.php');
|
|
if ($_POST['surat_idzz']) {
|
|
$surat_id = $_POST['surat_idzz'];
|
|
} else {
|
|
$surat_id = '0';
|
|
}
|
|
?>
|
|
<input type="hidden" value="<?php echo $surat_id; ?>" id="surat_idxz" style="margin-bottom:6px">
|
|
<?php
|
|
$data_pdf = pg_query($koneksi, "SELECT file,id FROM scan WHERE surat_id='$surat_id'
|
|
AND LOWER(file) NOT LIKE '%.jpg'
|
|
AND LOWER(file) NOT LIKE '%.JPG'
|
|
AND LOWER(file) NOT LIKE '%.png'
|
|
AND LOWER(file) NOT LIKE '%.PNG'
|
|
AND LOWER(file) NOT LIKE '%.jpeg'
|
|
AND LOWER(file) NOT LIKE '%.JPEG'
|
|
ORDER BY id DESC");
|
|
while ($rdata_pdf = pg_fetch_array($data_pdf)) {
|
|
$pdf = $rdata_pdf[0];
|
|
if (($pdf == NULL) || ($pdf == '')) {/*echo "File PDF belum diupload..";*/
|
|
} else {
|
|
?>
|
|
<div class="thumb" style="background-color:#ece9d8;padding:8px;margin-top:6px">
|
|
<a href='app/kirim/pdf/pdf/<?php echo $pdf; ?>' target='_blank'><?php echo $pdf; ?></a>
|
|
<!--<embed src="app/kirim/pdf/pdf/<?php echo $pdf; ?>#toolbar=0" width="100%" height="300"></embed>-->
|
|
<button type="button" name="cv_deletse" style="height:22px;border-radius: 50%" class="btn btn-danger btn-xs pull-right" id="<?php echo $rdata_pdf[1]; ?>" data-content="Hapus" rel="popover" data-placement="bottom" data-trigger="hover">
|
|
<i class="fa fa-remove"></i>
|
|
</button>
|
|
</div>
|
|
<?php
|
|
}
|
|
}
|
|
?>
|
|
|
|
<script>
|
|
$('button[name="cv_deletse"]').click(function() {
|
|
var x = confirm("Anda yakin ingin menghapus ?");
|
|
if (x) {
|
|
var key = "delete_cv";
|
|
var id = $(this).attr('id');
|
|
var rowElement = $(this).parent().parent();
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/kirim/pdf/crud.php",
|
|
data: 'id=' + id +
|
|
'&key=' + key,
|
|
success: function(data) {
|
|
var surat_id = $('#surat_idxz').val();
|
|
$('#tabel_upl_cvz').load("app/kirim/pdf/tabel_upl_cv.php", {
|
|
surat_idzz: surat_id
|
|
});
|
|
var key = "jumlah_nonjpg";
|
|
$.ajax({
|
|
type: "POST",
|
|
url: "app/kirim/crud.php",
|
|
data: 'surat_id=' + surat_id +
|
|
'&key=' + key,
|
|
success: function(data) {
|
|
$('.sr' + surat_id).html(' (' + data + ')');
|
|
$('.xr' + surat_id).html(data);
|
|
}
|
|
});
|
|
|
|
}
|
|
});
|
|
} else {}
|
|
});
|
|
</script>
|