292 lines
12 KiB
PHP
292 lines
12 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>Piutang Dagang | </strong><b style="color:Chartreuse">Filter (<?=$title?>)</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 href="<?php echo base_url('') ?>index.php" class="text-dark"><strong>Kembali</strong><i class="fa fa-backward"></i></a>
|
|
</div>
|
|
<h2 class="panel-title" style="color:DarkGreen"><b>DATA PIUTANG DAGANG</b></h2>
|
|
</header>
|
|
<div class="panel-body">
|
|
|
|
<div class="row">
|
|
<?=form_open('Menu/IN_Sub7_PiutangDagang_1');?>
|
|
<h4><label class="col-md-2 control-label"><b style="color:DarkSlateGray">Kelompok</b></label></h4>
|
|
<div class="col-md-4">
|
|
<select data-plugin-selectTwo name="id_kelompok" id="ID_KELOMPOK" class="form-control populate" onchange="this.form.submit();">
|
|
<option value="" selected>Tanpa Filter</option>
|
|
<?php if (is_array($kelompok) || is_object($kelompok)) {
|
|
foreach ($kelompok as $key) { ?>
|
|
<?php if ($id_kelompok == $key['ID_KELOMPOK']) { ?>
|
|
<option value="<?= $key['ID_KELOMPOK'] ?>" selected><?= $key['NAMA_KELOMPOK'] ?></option>
|
|
<?php } else { ?>
|
|
<option value="<?= $key['ID_KELOMPOK'] ?>" ><?= $key['NAMA_KELOMPOK'] ?></option>
|
|
<?php } ?>
|
|
<?php }
|
|
} ?>
|
|
</select>
|
|
<small class="help-block"></small>
|
|
</div>
|
|
<?=form_close();?>
|
|
</div>
|
|
|
|
<table class="table table-bordered table-striped mb-none" id="datatable-default">
|
|
<thead>
|
|
|
|
<th class="center default">No</th>
|
|
<th class="default">Pelanggan</th>
|
|
<th class="text-right default">Akumulasi</th>
|
|
<th class="default">Jatuh Tempo</th>
|
|
<th width="120px" class="center default">Lihat Data</th>
|
|
|
|
</thead>
|
|
<tbody>
|
|
<?php
|
|
if (is_array($informasi) || is_object($informasi)) {
|
|
$no = 1;
|
|
foreach ($informasi as $key) { ?>
|
|
<tr>
|
|
<td class="center"><?= $no++; ?></td>
|
|
<?php if ($key['TYPE_PELANGGAN']=="0") { ?>
|
|
<td><strong style="color:Blue">Corporate</strong> : <br><?= $key['NAMA_PELANGGAN'] ?><br><i>(<?= $key['NAMA_KOTA'] ?>)</i></td>
|
|
<?php } else if ($key['TYPE_PELANGGAN']=="1") { ?>
|
|
<td><strong style="color:Green">Dealer</strong> : <br><?= $key['NAMA_PELANGGAN'] ?><br><i>(<?= $key['NAMA_KOTA'] ?>)</i></td>
|
|
<?php } else if ($key['TYPE_PELANGGAN']=="2") { ?>
|
|
<td><strong style="color:DarkOrange">User</strong> : <br><?= $key['NAMA_PELANGGAN'] ?><br><i>(<?= $key['NAMA_KOTA'] ?>)</i></td>
|
|
<?php } ?>
|
|
<td class="text-right" style="color:Red"><strong><?= $key['TOTAL']; ?></strong></td>
|
|
<td>
|
|
<?php foreach ($key['PDA'] as $dat) { ?>
|
|
<strong style="Color:SlateGray">[<?= $dat['TEMPO']; ?>] <i style="Color:Teal"><?= $dat['INV_PENJUALAN']; ?></i> | <b style="Color:Chocolate"><?= number_format($dat['TOTAL'],2); ?></b><?php if ($dat['NAMA_PANGGILAN_KARYAWAN']!=NULL) { ?> | <b style="Color:Blue"><?= $dat['NAMA_PANGGILAN_KARYAWAN']; ?></b><?php } ?></strong><br>
|
|
<?php } ?>
|
|
</td>
|
|
<td class="actions center">
|
|
<span data-toggle="modal" data-target="#modalLihatPda"><button type="button" onclick="isiPda('<?=$key['PELANGGAN_ID']?>')" class="btn btn-xs btn-primary" title="" data-toggle="tooltip" data-trigger="hover" data-original-title="Tombol untuk Lihat Data"><i class="fa fa-reorder"></i></button></span>
|
|
</td>
|
|
</tr>
|
|
<?php }
|
|
} ?>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
</section>
|
|
</div>
|
|
<!-- end: page -->
|
|
</section>
|
|
|
|
<div id="modalLihatPda" 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>Lihat 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">Jatuh 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>
|
|
$('#datatable-default').dataTable( {
|
|
"paging": false
|
|
} );
|
|
|
|
function openTab(id) {
|
|
window.open('IN_Sub7_PiutangDagang_2/'+id, '_blank');
|
|
}
|
|
|
|
function isiPda(id) {
|
|
var JUMLAHPDA = "";
|
|
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 = '';
|
|
|
|
now = new Date();
|
|
day = ("0" + now.getDate()).slice(-2);
|
|
month = ("0" + (now.getMonth() + 1)).slice(-2);
|
|
today = now.getFullYear()+"-"+(month)+"-"+(day) ;
|
|
|
|
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'];
|
|
var tempo_penjualan = response.data[i - 1]['TEMPO_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>';
|
|
}
|
|
if (tempo_penjualan<=today) {
|
|
baris += '<td class="text-left text-center" style="vertical-align: middle;"><b style="color:Red">' + tempo + ' <i class="fa fa-check"></i></td>';
|
|
} else {
|
|
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>
|