265 lines
11 KiB
PHP
265 lines
11 KiB
PHP
<!doctype html>
|
|
<html class="fixed sidebar-left-collapsed">
|
|
|
|
<head>
|
|
|
|
<!-- Basic -->
|
|
<meta charset="UTF-8">
|
|
|
|
<title>MENU INFORMASI</title>
|
|
<meta name="keywords" content="HTML5 Admin Template" />
|
|
<meta name="description" content="Porto Admin - Responsive HTML5 Template">
|
|
<meta name="author" content="okler.net">
|
|
<link rel="icon" type="image/png" href="<?php echo base_url('')?>assets/images/logoPcmBaru3.png" />
|
|
|
|
<!-- Mobile Metas -->
|
|
<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no" />
|
|
|
|
<!-- Vendor CSS -->
|
|
<link rel="stylesheet" href="<?php echo base_url('') ?>assets/vendor/bootstrap/css/bootstrap.css" />
|
|
<link rel="stylesheet" href="<?php echo base_url('') ?>assets/vendor/font-awesome/css/font-awesome.css" />
|
|
<link rel="stylesheet" href="<?php echo base_url('') ?>assets/vendor/magnific-popup/magnific-popup.css" />
|
|
<link rel="stylesheet" href="<?php echo base_url('') ?>assets/vendor/bootstrap-datepicker/css/datepicker3.css" />
|
|
|
|
<!-- Specific Page Vendor CSS -->
|
|
<link rel="stylesheet" href="<?php echo base_url('') ?>assets/vendor/select2/select2.css" />
|
|
<link rel="stylesheet" href="<?php echo base_url('') ?>assets/vendor/jquery-datatables-bs3/assets/css/datatables.css" />
|
|
<link rel="stylesheet" href="<?php echo base_url('') ?>assets/vendor/pnotify/pnotify.custom.css" />
|
|
<link rel="stylesheet" href="<?php echo base_url('') ?>assets/vendor/bootstrap-multiselect/bootstrap-multiselect.css" />
|
|
|
|
<!-- Theme CSS -->
|
|
<link rel="stylesheet" href="<?php echo base_url('') ?>assets/stylesheets/theme.css" />
|
|
|
|
<!-- Skin CSS -->
|
|
<link rel="stylesheet" href="<?php echo base_url('') ?>assets/stylesheets/skins/default.css" />
|
|
|
|
<!-- Theme Custom CSS -->
|
|
<link rel="stylesheet" href="<?php echo base_url('') ?>assets/stylesheets/theme-custom.css">
|
|
|
|
<!-- Head Libs -->
|
|
<script src="<?php echo base_url('') ?>assets/vendor/modernizr/modernizr.js"></script>
|
|
|
|
</head>
|
|
<script src="<?= base_url() ?>assets/bower_components/jquery/jquery-3.3.1.min.js"></script>
|
|
<script src="<?= base_url() ?>assets/bower_components/sweetalert2/sweetalert2.all.min.js"></script>
|
|
|
|
<script type="text/javascript">
|
|
let base_url = '<?= base_url() ?>';
|
|
</script>
|
|
|
|
<body>
|
|
<section class="body">
|
|
|
|
<!-- start: header -->
|
|
<?php $this->load->view('template/header'); ?>
|
|
<!-- end: header -->
|
|
|
|
<div class="inner-wrapper">
|
|
<!-- start: sidebar -->
|
|
<?php $this->load->view('template/sidebar'); ?>
|
|
<!-- end: sidebar -->
|
|
|
|
<section role="main" class="content-body">
|
|
<header class="page-header">
|
|
<h2><strong>Rincian Piutang Dagang | </strong><b style="color:Yellow">Nota [<?=$inv_penjualan?>]</b></h2>
|
|
|
|
<div class="right-wrapper pull-right">
|
|
<ol class="breadcrumbs">
|
|
<li><span><strong style="color:Gold">Master Data </span></strong></li>
|
|
</ol>
|
|
|
|
<a class="sidebar-right-toggle" data-open="sidebar-right"><i class="fa fa-chevron-left"></i></a>
|
|
</div>
|
|
</header>
|
|
|
|
<!-- start: page -->
|
|
<div class="col-md-12">
|
|
<section class="panel panel-featured panel-featured-success">
|
|
<header class="panel-heading">
|
|
<div class="panel-actions">
|
|
<a onclick="closeTab()" class="text-dark"><strong>Tutup Tab </strong><i class="fa fa-times"></i></a>
|
|
</div>
|
|
<h2 class="panel-title" style="color:DarkGreen"><b>DATA RINCIAN | <b style="color:FireBrick"><?=$nama_pelanggan?></b></b></h2>
|
|
</header>
|
|
<div class="panel-body">
|
|
<table class="table table-bordered table-striped mb-none" id="datatable-default">
|
|
<thead>
|
|
<th class="center default">No</th>
|
|
<th class="default">Kode Bukti</th>
|
|
<th class="default">Transaksi</th>
|
|
<th class="text-right default">Debet</th>
|
|
<th class="text-right default">Kredit</th>
|
|
<th class="text-right default">Saldo</th>
|
|
<th class="default">Keterangan</th>
|
|
</thead>
|
|
<tbody>
|
|
<?php
|
|
if (is_array($informasi) || is_object($informasi)) {
|
|
$no = 1;
|
|
$saldo_pda = 0;
|
|
foreach ($informasi as $key) { ?>
|
|
<tr>
|
|
<td class="center"><?= $no; ?></td>
|
|
<td><b style="color:DarkSlateGray"><?= $key['KODE_AKUNTANSI']; ?> <b style="color:DarkOrchid">[<?= $key['NAMA_PANGGILAN_KARYAWAN']; ?>]</b></b><br><i>(<?= $key['TIMESTAMP']; ?>)</i></td>
|
|
<?php if (strpos($key['KODE_AKUNTANSI'],"PJ")!==FALSE) { ?>
|
|
<td style="color:Navy"><strong>Penjualan</strong></td>
|
|
<?php } else if (strpos($key['KODE_AKUNTANSI'],"RJ")!==FALSE) { ?>
|
|
<td style="color:DarkOrange"><strong>RETUR</strong></td>
|
|
<?php } else { ?>
|
|
<td style="color:Chocolate"><strong>Pelunasan</strong></td>
|
|
<?php } ?>
|
|
<td class="text-right" style="color:Blue"><strong><?php echo number_format($key['DEBET_DAK'],2); ?></strong></td>
|
|
<td class="text-right" style="color:Red"><strong><?php echo number_format($key['KREDIT_DAK'],2); ?></strong></td>
|
|
<?php $saldo_pda = $saldo_pda+$key['DEBET_DAK']-$key['KREDIT_DAK']; ?>
|
|
<td class="text-right" style="color:DarkGreen"><strong><?php echo number_format($saldo_pda,2); ?></strong></td>
|
|
<td><?= $key['KET_DAK']; ?></td>
|
|
</tr>
|
|
<?php $no++;
|
|
}
|
|
} ?>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
</section>
|
|
</div>
|
|
<!-- end: page -->
|
|
</section>
|
|
|
|
<div id="modalIsiPda" class="modal fade ui-front" tabindex="-1" role="dialog">
|
|
<div class="modal-dialog modal-lg" style="width:85%">
|
|
<header class="panel-heading">
|
|
<h2 class="panel-title"><strong>Isi Data | [<b id="namapel" style="color:FireBrick"></b>]</strong></h2>
|
|
<div class="panel-actions">
|
|
<a class="text-dark" data-dismiss="modal"><strong>Tutup </strong><i class="fa fa-times"></i></a>
|
|
</div>
|
|
</header>
|
|
<div class="panel-body">
|
|
<div class="modal-wrapper">
|
|
<div class="modal-text">
|
|
<div class="row form-bordered">
|
|
<div class="form-group">
|
|
<div class="form-group">
|
|
<input type="hidden" name="pelanggan_id" id="pelanggan_id" class="form-control" value="">
|
|
<div class="col-md-8"></div>
|
|
<div class="col-md-4">
|
|
<input autocomplete="off" class="form-control" name="textSearch" id="textSearch" oninput="cariNota();" type="text" enterkeyhint="done"/ placeholder="Hanya Cari Nomor Nota">
|
|
</div>
|
|
</div>
|
|
<div class="col-md-12">
|
|
<table class="table table-bordered table-striped mb-none">
|
|
<thead>
|
|
<th class="center default">No</th>
|
|
<th class="default">Nota Penjualan</th>
|
|
<th class="center default">Tempo</th>
|
|
<th class="center default">Tanda Terima</th>
|
|
<th class="text-right default">Piutang</th>
|
|
<th class="text-right default">Terbayar</th>
|
|
<th class="text-right default">Sisa</th>
|
|
<th class="center default">Rincian</th>
|
|
</thead>
|
|
<tbody id="isitabelPiutang"></tbody>
|
|
</table>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
|
|
<?php
|
|
$this->load->view('template/sidebar_right');
|
|
$this->load->view('template/script_vendor');
|
|
$this->load->view('template/script_flashdata');
|
|
$this->load->view('template/notification');
|
|
?>
|
|
|
|
<script>
|
|
function closeTab() {
|
|
window.close();
|
|
}
|
|
|
|
$('#datatable-default').dataTable( {
|
|
"paging": false
|
|
} );
|
|
|
|
function openTab(id) {
|
|
window.open('IN_Sub7_PiutangDagang_2/'+id, '_blank');
|
|
}
|
|
|
|
function isiPda(id) {
|
|
var JUMLAHPDA = "";
|
|
var JUMLAHTSA = "";
|
|
var textSearch = document.getElementById("textSearch").value;
|
|
document.getElementById("pelanggan_id").value = id;
|
|
|
|
LoadDataPiutang(id, textSearch);
|
|
|
|
}
|
|
|
|
function cariNota() {
|
|
var textSearch = document.getElementById("textSearch").value;
|
|
var id = document.getElementById("pelanggan_id").value;
|
|
|
|
LoadDataPiutang(id, textSearch);
|
|
}
|
|
|
|
function LoadDataPiutang(id, textSearch) {
|
|
$.ajax({
|
|
type: 'POST',
|
|
data: {
|
|
id_pelanggan : id ,
|
|
textSearch : textSearch,
|
|
},
|
|
url: '<?= base_url('') ?>index.php/Menu/IN_Ambil_Sub7_A1_DataPiutang',
|
|
dataType: 'json',
|
|
success: function(response) {
|
|
JUMLAHPDA = response.total;
|
|
var baris = '';
|
|
|
|
for (var i = 1; i <= JUMLAHPDA; i++) {
|
|
if (i <= response.data.length) {
|
|
var inv_penjualan = response.data[i - 1]['INV_PENJUALAN'];
|
|
var tanggal = response.data[i - 1]['TANGGAL'];
|
|
var nama_sales = response.data[i - 1]['NAMA_PANGGILAN_KARYAWAN'];
|
|
var tempo = response.data[i - 1]['TEMPO'];
|
|
var tt = response.data[i - 1]['TT'];
|
|
var debet = response.data[i - 1]['DEBET'];
|
|
var kredit = response.data[i - 1]['KREDIT'];
|
|
var sisa = response.data[i - 1]['SISA'];
|
|
var tt = response.data[i - 1]['TT'];
|
|
var nama_pelanggan = response.data[i - 1]['NAMA_PELANGGAN'];
|
|
var id_penjualan = response.data[i - 1]['ID_PENJUALAN'];
|
|
|
|
if (tt==null) {
|
|
tt = "";
|
|
}
|
|
|
|
baris += '<tr>';
|
|
baris += '<td class="center" style="vertical-align: middle;" >' + i + '</td>';
|
|
if (nama_sales!=null) {
|
|
baris += '<td class="text-left" style="vertical-align: middle;"><b style="color:Navy">' + inv_penjualan + '</b> : [<b style="color:FireBrick">' + nama_sales + '</b>]<br>(' + tanggal + ')</td>';
|
|
} else {
|
|
baris += '<td class="text-left" style="vertical-align: middle;"><b style="color:Navy">' + inv_penjualan + '</b><br>(' + tanggal + ')</td>';
|
|
}
|
|
baris += '<td class="text-left text-center" style="vertical-align: middle;">' + tempo + '</td>';
|
|
baris += '<td class="text-left text-center" style="vertical-align: middle;">' + tt + '</td>';
|
|
baris += '<td class="text-right" style="vertical-align: middle;">' + debet + '</td>';
|
|
baris += '<td class="text-right" style="vertical-align: middle;">' + kredit + '</td>';
|
|
baris += '<td class="text-right" style="vertical-align: middle;">' + sisa + '</td>';
|
|
baris += '<td class="action center" style="vertical-align: middle;"><button type="button" class="btn btn-xs btn-success" onclick="openTab(' + id_penjualan + ')"><i class="fa fa-external-link"></i></button></td>';
|
|
baris += '</tr>';
|
|
}
|
|
}
|
|
$('#isitabelPiutang').html(baris);
|
|
$('#namapel').html(nama_pelanggan);
|
|
}
|
|
});
|
|
}
|
|
|
|
|
|
</script>
|
|
</body>
|
|
|
|
</html>
|