467 lines
19 KiB
PHP
467 lines
19 KiB
PHP
<!doctype html>
|
|
<html class="fixed sidebar-left-collapsed">
|
|
<head>
|
|
|
|
<!-- Basic -->
|
|
<meta charset="UTF-8">
|
|
|
|
<title>LAPORAN | HUTANG DAGANG</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" />
|
|
<link rel="stylesheet" href="<?php echo base_url('')?>assets/vendor/bootstrap-timepicker/css/bootstrap-timepicker.css" />
|
|
|
|
<!-- Specific Page Vendor CSS -->
|
|
<link rel="stylesheet" href="<?php echo base_url('') ?>assets/vendor/jquery-ui/css/ui-lightness/jquery-ui-1.10.4.custom.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" />
|
|
<link rel="stylesheet" href="<?php echo base_url('') ?>assets/vendor/summernote/summernote.css" />
|
|
<link rel="stylesheet" href="<?php echo base_url('') ?>assets/vendor/summernote/summernote-bs3.css" />
|
|
<link rel="stylesheet" href="<?php echo base_url('') ?>assets/vendor/codemirror/lib/codemirror.css" />
|
|
<link rel="stylesheet" href="<?php echo base_url('') ?>assets/vendor/codemirror/theme/monokai.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>Hutang Dagang | <?=$title?></strong></h2>
|
|
|
|
<div class="right-wrapper pull-right">
|
|
<ol class="breadcrumbs">
|
|
<li>
|
|
<a href="<?php echo base_url() ?>index.php">
|
|
<i class="fa fa-home"></i>
|
|
</a>
|
|
</li>
|
|
<li><span>Hutang Dagang</span></li>
|
|
</ol>
|
|
|
|
<a class="sidebar-right-toggle" data-open="sidebar-right"><i class="fa fa-chevron-left"></i></a>
|
|
</div>
|
|
</header>
|
|
|
|
<!-- start: page -->
|
|
<section class="panel panel-featured panel-featured-primary">
|
|
<header class="panel-heading">
|
|
<div class="panel-actions">
|
|
<a href="<?php echo base_url('') ?>index.php"><strong>Kembali</strong><i class="fa fa-backward"></i></a>
|
|
</div>
|
|
<?php if ($all!=1) { ?>
|
|
<h2 class="panel-title"><strong>DATA HUTANG DAGANG | PERIODE (<?=$awal?> s/d <?=$akhir?>)</strong></h2>
|
|
<?php } else { ?>
|
|
<h2 class="panel-title"><strong>DATA HUTANG DAGANG | TOTAL KESELURUHAN</strong></h2>
|
|
<?php } ?>
|
|
</header>
|
|
<div class="panel-body">
|
|
<div class="row">
|
|
<?=form_open('ManageLaporan/dataHutangDagang_Keuangan_A1');?>
|
|
<div class="col-sm-2">
|
|
<div class="mb-md">
|
|
<div class="form-group">
|
|
<input type="date" name="tanggal_awal" id="TANGGAL_AWAL" class="form-control" value="<?=$tgl?>" required>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
<div class="col-md-1">
|
|
<div class="mb-md">
|
|
<div class="form-group">
|
|
<h4><label position="center"><strong>SAMPAI</strong></label></h4>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
<div class="col-sm-2">
|
|
<div class="mb-md">
|
|
<div class="form-group">
|
|
<input type="date" name="tanggal_akhir" id="TANGGAL_AKHIR" class="form-control" value="<?=$tgl?>" required>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
<div class="col-sm-4">
|
|
<div class="mb-md">
|
|
<div class="form-group">
|
|
<select data-plugin-selectTwo name="id_supplier" id="ID_SUPPLIER" class="form-control populate" data-plugin-options='{ "minimumInputLength": 2 }'>
|
|
<option value="" selected>Nama Supplier/Kosongi untuk Semua Supplier</option>
|
|
<?php if (is_array($supplier) || is_object($supplier)) {
|
|
foreach ($supplier as $key) { ?>
|
|
<option value="<?= $key['ID_SUPPLIER'] ?>" ><?= $key['NAMA_SUPPLIER'] ?> (<?= $key['NAMA_KOTA'] ?>)</option>
|
|
<?php }
|
|
} ?>
|
|
</select>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
<input type="hidden" name="kondisi" value="ada">
|
|
<div class="col-sm-3 pull-left">
|
|
<div class="mb-md">
|
|
<button type="submit" class="btn btn-default"><strong>Cari Data </strong><i class="fa fa-search"></i></button>
|
|
<a href="<?php echo base_url('') ?>index.php/ManageLaporan/dataHutangDagang_Keuangan_A1"><button type="button" class="btn btn-info text-default"><strong>Reset View <i class="fa fa-rotate-left"></i></strong></button></a><br></br>
|
|
</div>
|
|
</div>
|
|
<?=form_close();?>
|
|
|
|
</div>
|
|
|
|
<table class="table table-bordered table-striped mb-none" id="datatable-default" >
|
|
<thead>
|
|
<?php if ($all==1) { ?>
|
|
<th class="dark center">No</th>
|
|
<th class="dark">Supplier</th>
|
|
<th class="center dark">DEBET</th>
|
|
<th class="center dark">KREDIT</th>
|
|
<th class="center dark">SALDO</th>
|
|
<?php } else { ?>
|
|
<th class="dark center">No</th>
|
|
<th class="dark">Tanggal</th>
|
|
<th class="dark">Kode Bukti</th>
|
|
<th class="dark">Transaksi</th>
|
|
<th class="center dark">DEBET</th>
|
|
<th class="center dark">KREDIT</th>
|
|
<th class="center dark">SALDO</th>
|
|
<th class="dark">Keterangan</th>
|
|
<?php } ?>
|
|
</thead>
|
|
<tbody>
|
|
<?php if (is_array($laporan) || is_object($laporan)) {
|
|
$no = 1;
|
|
$saldo = $saldo_awal;
|
|
$set = 0;
|
|
$nama_supplier = NULL;
|
|
foreach ($laporan as $key) {
|
|
if ($nama_supplier!=$key['NAMA_SUPPLIER']) {
|
|
$nama_supplier = $key['NAMA_SUPPLIER'];
|
|
$set = 1;
|
|
}
|
|
?>
|
|
<?php if ($set==1 AND $all!=1) { ?>
|
|
<tr>
|
|
<td class="center"><?= $no++ ?></td>
|
|
<td><?= $tgl_awal ?></td>
|
|
<td>----</td>
|
|
<td class="text-dark"><strong>Saldo Awal</strong></td>
|
|
<?php $nilai_saldo = number_format($saldo,2); ?>
|
|
<td> </td>
|
|
<td> </td>
|
|
<td>Rp <?= $nilai_saldo ?></td>
|
|
<td> </td>
|
|
</tr>
|
|
<?php $set = 0; ?>
|
|
<?php } ?>
|
|
|
|
<?php if ($all!=1) { ?>
|
|
<tr>
|
|
<td class="center"><?= $no++ ?></td>
|
|
<td><?= $key['TANGGAL'] ?></td>
|
|
<td><?= $key['KODE_BUKTI'] ?></td>
|
|
<?php if ($key['TRANSAKSI_HDA']=="0") { ?>
|
|
<td class="text-dark"><strong>Pembelian</strong></td>
|
|
<?php } else if ($key['TRANSAKSI_HDA']=="1") { ?>
|
|
<td class="text-dark"><strong>Pelunasan</strong></td>
|
|
<?php } else if ($key['TRANSAKSI_HDA']=="2") { ?>
|
|
<td class="text-dark"><strong>RETUR</strong></td>
|
|
<?php } ?>
|
|
<?php $debet = $key['DEBET'];
|
|
$kredit = $key['KREDIT'];
|
|
$saldo = $saldo-$key['DEBET_HDA']+$key['KREDIT_HDA'];
|
|
$debet = number_format($debet,2);
|
|
$kredit = number_format($kredit,2);
|
|
$nilai_saldo = number_format($saldo,2);
|
|
?>
|
|
<td>Rp <?= $debet ?></td>
|
|
<td>Rp <?= $kredit ?></td>
|
|
<td>Rp <?= $nilai_saldo ?></td>
|
|
<td><?= $key['KET_HDA'] ?></td>
|
|
</tr>
|
|
<?php } else { ?>
|
|
<tr>
|
|
<td class="center"><?= $no++ ?></td>
|
|
<td><?= $key['NAMA_SUPPLIER'] ?> (<?= $key['NAMA_KOTA'] ?>)</td>
|
|
<?php $debet = $key['DEBET'];
|
|
$kredit = $key['KREDIT'];
|
|
$saldo = $key['SALDO'];
|
|
$debet = number_format($debet,2);
|
|
$kredit = number_format($kredit,2);
|
|
$nilai_saldo = number_format($saldo,2);
|
|
?>
|
|
<td>Rp <?= $debet ?></td>
|
|
<td>Rp <?= $kredit ?></td>
|
|
<td>Rp <?= $nilai_saldo ?></td>
|
|
</tr>
|
|
<?php } ?>
|
|
|
|
<?php }
|
|
} ?>
|
|
|
|
<?php if ($laporan==FALSE AND $all=="2") {?>
|
|
<tr>
|
|
<td class="center"><?= $no++ ?></td>
|
|
<td><?= $tgl_awal ?></td>
|
|
<td>----</td>
|
|
<td class="text-dark"><strong>Saldo Awal</strong></td>
|
|
<?php $nilai_saldo = number_format($saldo,2); ?>
|
|
<td> </td>
|
|
<td> </td>
|
|
<td>Rp <?= $nilai_saldo ?></td>
|
|
<td> </td>
|
|
</tr>
|
|
<?php } ?>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
<?php if ($all=="1") { ?>
|
|
<footer class="panel-footer">
|
|
<div class="row">
|
|
<div class="col-md-12 text-right">
|
|
<button type="button" class="btn btn-default text-dark" data-toggle="modal" data-target="#modal-cetak"><strong>Buat Excel</strong> <i class="fa fa-file-excel-o"></i></button>
|
|
</div>
|
|
</div>
|
|
</footer>
|
|
<?php } else if ($all=="2") { ?>
|
|
<footer class="panel-footer">
|
|
<div class="row">
|
|
<div class="col-md-12 text-right">
|
|
<button type="button" class="btn btn-default" data-toggle="modal" data-target="#modal-cetak-SUP"><strong>Buat Excel</strong> <i class="fa fa-file-excel-o"></i></button>
|
|
</div>
|
|
</div>
|
|
</footer>
|
|
<?php } ?>
|
|
</section>
|
|
<!-- end: page -->
|
|
</section>
|
|
</div>
|
|
</section>
|
|
|
|
<!-- modal Cetak -->
|
|
<div id="modal-cetak" class="modal fade" tabindex="-1" role="dialog">
|
|
<div class="modal-dialog">
|
|
<?= form_open('ManageLaporan/simpan_excel_hutangdagang', array('method' => 'post'), array('id' => 'formlaporan')); ?>
|
|
<div class="modal-content">
|
|
<header class="panel-heading">
|
|
<h2 class="panel-title"><strong>Buat Excel</strong></h2>
|
|
</header>
|
|
<div class="panel-body">
|
|
<div class="modal-wrapper">
|
|
<div class="modal-text">
|
|
<input type="hidden" name="start" class="form-control" value="<?= $tanggal_awal; ?>">
|
|
<input type="hidden" name="end" class="form-control" value="<?= $tanggal_akhir; ?>">
|
|
<h4>Apakah ingin membuat Data?</h4>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
<footer class="panel-footer">
|
|
<div class="row">
|
|
<div class="col-md-12 text-right">
|
|
<button type="button" class="btn btn-default pull-left" data-dismiss="modal">Close</button>
|
|
<button type="submit" name="SubmitCetak" id="SubmitCetak" formtarget="_blank" class="btn btn-default"><strong>Laporan</strong> <i class="fa fa-file-excel-o"></i></a></button>
|
|
</div>
|
|
</div>
|
|
</footer>
|
|
</div>
|
|
<?= form_close(); ?>
|
|
</div>
|
|
</div>
|
|
<!-- modal Cetak -->
|
|
|
|
<!-- modal Cetak sup-->
|
|
<div id="modal-cetak-SUP" class="modal fade" tabindex="-1" role="dialog">
|
|
<div class="modal-dialog">
|
|
<?= form_open('ManageLaporan/simpan_excel_hutangdagang_sup', array('method' => 'post'), array('id' => 'formlaporan')); ?>
|
|
<div class="modal-content">
|
|
<header class="panel-heading">
|
|
<h2 class="panel-title"><strong>Buat Excel</strong></h2>
|
|
</header>
|
|
<div class="modal-body ">
|
|
|
|
<div class="form-group">
|
|
<div class="col-md-2">
|
|
<label><strong>Tanggal</strong></label>
|
|
</div>
|
|
<div class="col-md-10">
|
|
<div class="input-daterange input-group">
|
|
<span class="input-group-addon">
|
|
<i class="fa fa-calendar"></i>
|
|
</span>
|
|
<input type="date" class="form-control" id="start_sup" name="start_sup" value="<?=$tanggal_awal?>" autocomplete="off" required>
|
|
<span class="input-group-addon">to</span>
|
|
<input type="date" class="form-control" id="end_sup" name="end_sup" value="<?=$tanggal_akhir?>" autocomplete="off" required>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
|
|
<div class="form-group">
|
|
<input type="hidden" name="id_supplier" class="form-control" value="<?= $id_supplier; ?>">
|
|
<label class="col-md-2 control-label"><strong>Supplier</strong></label>
|
|
<div class="col-md-10">
|
|
<select disabled data-plugin-selectTwo name="m_supplier" class="form-control populate" data-plugin-options='{ "minimumInputLength": 2 }'>
|
|
<?php if (is_array($supplier) || is_object($supplier)) {
|
|
foreach ($supplier as $key) { ?>
|
|
<option value="<?= $key['ID_SUPPLIER'] ?>" ><?= $key['NAMA_SUPPLIER'] ?> (<?= $key['NAMA_KOTA'] ?>)</option>
|
|
<?php }
|
|
} ?>
|
|
</select>
|
|
</div>
|
|
</div>
|
|
|
|
</div>
|
|
<footer class="panel-footer">
|
|
<div class="row">
|
|
<div class="col-md-12 text-right">
|
|
<button type="button" class="btn btn-default pull-left" data-dismiss="modal">Close</button>
|
|
<button type="submit" name="SubmitCetakSup" id="SubmitCetakSup" formtarget="_blank" class="btn btn-default"><strong>Laporan</strong> <i class="fa fa-file-excel-o"></i></a></button>
|
|
</div>
|
|
</div>
|
|
</footer>
|
|
</div>
|
|
<?= form_close(); ?>
|
|
</div>
|
|
</div>
|
|
|
|
<script>
|
|
|
|
</script>
|
|
|
|
<?php $this->load->view('template/sidebar_right'); ?>
|
|
<!-- Vendor -->
|
|
<script src="<?php echo base_url('')?>assets/vendor/jquery/jquery.js"></script>
|
|
<script src="<?php echo base_url('')?>assets/vendor/jquery-browser-mobile/jquery.browser.mobile.js"></script>
|
|
<script src="<?php echo base_url('')?>assets/vendor/bootstrap/js/bootstrap.js"></script>
|
|
<script src="<?php echo base_url('')?>assets/vendor/nanoscroller/nanoscroller.js"></script>
|
|
<script src="<?php echo base_url('')?>assets/vendor/bootstrap-datepicker/js/bootstrap-datepicker.js"></script>
|
|
<script src="<?php echo base_url('')?>assets/vendor/bootstrap-timepicker/js/bootstrap-timepicker.js"></script>
|
|
<script src="<?php echo base_url('')?>assets/vendor/magnific-popup/magnific-popup.js"></script>
|
|
<script src="<?php echo base_url('')?>assets/vendor/jquery-placeholder/jquery.placeholder.js"></script>
|
|
|
|
<!-- Specific Page Vendor -->
|
|
<script src="<?php echo base_url('') ?>assets/vendor/jquery-ui/js/jquery-ui-1.10.4.custom.js"></script>
|
|
<script src="<?php echo base_url('') ?>assets/vendor/select2/select2.js"></script>
|
|
<script src="<?php echo base_url('') ?>assets/vendor/jquery-datatables/media/js/jquery.dataTables.js"></script>
|
|
<script src="<?php echo base_url('') ?>assets/vendor/jquery-datatables-bs3/assets/js/datatables.js"></script>
|
|
<script src="<?php echo base_url('') ?>assets/vendor/bootstrap-multiselect/bootstrap-multiselect.js"></script>
|
|
<script src="<?php echo base_url('') ?>assets/vendor/summernote/summernote.js"></script>
|
|
<script src="<?php echo base_url('') ?>assets/vendor/fuelux/js/spinner.js"></script>
|
|
<!-- Specific Page Vendor -->
|
|
<script src="<?php echo base_url('')?>assets/vendor/pnotify/pnotify.custom.js"></script>
|
|
|
|
<!-- Theme Base, Components and Settings -->
|
|
<script src="<?php echo base_url('')?>assets/javascripts/theme.js"></script>
|
|
|
|
<!-- Theme Custom -->
|
|
<script src="<?php echo base_url('')?>assets/javascripts/theme.custom.js"></script>
|
|
|
|
<!-- Theme Initialization Files -->
|
|
<script src="<?php echo base_url('')?>assets/javascripts/theme.init.js"></script>
|
|
|
|
|
|
<!-- Examples -->
|
|
<!-- Examples -->
|
|
<script src="<?php echo base_url('')?>assets/javascripts/tables/examples.datatables.default.js"></script>
|
|
<script src="<?php echo base_url('')?>assets/javascripts/tables/examples.datatables.row.with.details.js"></script>
|
|
<script src="<?php echo base_url('')?>assets/javascripts/tables/examples.datatables.tabletools.js"></script>
|
|
<!-- <script src="<?php echo base_url('')?>assets/javascripts/tables/examples.datatables.editable.js"></script> -->
|
|
<script src="<?php echo base_url('')?>assets/javascripts/ui-elements/examples.notifications.js"></script>
|
|
<?php $this->load->view('template/notification'); ?>
|
|
|
|
<script>
|
|
function multiselect_selected($el) {
|
|
var ret = true;
|
|
$('option', $el).each(function(element) {
|
|
if (!!!$(this).prop('selected')) {
|
|
ret = false;
|
|
}
|
|
});
|
|
return ret;
|
|
}
|
|
|
|
function multiselect_selectAll($el) {
|
|
$('option', $el).each(function(element) {
|
|
$el.multiselect('select', $(this).val());
|
|
});
|
|
}
|
|
|
|
function multiselect_deselectAll($el) {
|
|
$('option', $el).each(function(element) {
|
|
$el.multiselect('deselect', $(this).val());
|
|
});
|
|
}
|
|
|
|
function multiselect_toggle($el, $btn) {
|
|
if (multiselect_selected($el)) {
|
|
multiselect_deselectAll($el);
|
|
$btn.text("Select All");
|
|
} else {
|
|
multiselect_selectAll($el);
|
|
$btn.text("Deselect All");
|
|
}
|
|
}
|
|
|
|
$("#ms_example7-toggle").click(function(e) {
|
|
e.preventDefault();
|
|
multiselect_toggle($("#ms_example7"), $(this));
|
|
});
|
|
|
|
$("#ms_examplesup-toggle").click(function(e) {
|
|
e.preventDefault();
|
|
multiselect_toggle($("#ms_examplesup"), $(this));
|
|
});
|
|
|
|
$('#SubmitCetak').click(function() {
|
|
var st = $('#start').val();
|
|
var en = $('#end').val();
|
|
|
|
if (st != '' && en != '') {
|
|
$('#modal-cetak').modal('toggle');
|
|
}
|
|
});
|
|
|
|
$('#SubmitCetakSup').click(function() {
|
|
var st = $('#start_sup').val();
|
|
var en = $('#end_sup').val();
|
|
|
|
if (st != '' && en != '') {
|
|
$('#modal-cetak-SUP').modal('toggle');
|
|
}
|
|
});
|
|
</script>
|
|
|
|
</body>
|
|
</html>
|