425 lines
16 KiB
PHP
425 lines
16 KiB
PHP
<!doctype html>
|
|
<html class="fixed sidebar-left-collapsed">
|
|
|
|
<head>
|
|
|
|
<!-- Basic -->
|
|
<meta charset="UTF-8">
|
|
|
|
<title>SALES PRODUK</title>
|
|
<meta name="keywords" content="HTML5 Admin Template" />
|
|
<meta name="description" content="Porto Admin - Responsive HTML5 Template">
|
|
<meta name="author" content="okler.net">
|
|
|
|
<!-- 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" />
|
|
<link rel="stylesheet" href="<?php echo base_url('') ?>assets/vendor/base/jquery-ui.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>
|
|
|
|
<style>
|
|
.ui-front {
|
|
z-index: 9999;
|
|
}
|
|
|
|
.solid {
|
|
border-left-style: solid;
|
|
border-width: 5px;
|
|
border-color: darkcyan;
|
|
}
|
|
|
|
.f18 {
|
|
font-size: 18px;
|
|
}
|
|
|
|
</style>
|
|
|
|
<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">
|
|
|
|
<?php
|
|
$id_karyawan = $this->session->userdata('id_karyawan');
|
|
$nama_panggilan = $this->session->userdata('nama_panggilan');
|
|
$username = $this->session->userdata('username');
|
|
$tgl_now = date('d/m/Y');
|
|
|
|
$datShm = $this->Amod->getData_SetHakMenu_byKARYAWAN_byKODE_byNAMA($id_karyawan, "SP", "PUSAT DATA - Laporan");
|
|
if ($datShm==FALSE) {
|
|
$hak = 0;
|
|
$tampil = "TIDAK BERHAK";
|
|
} else {
|
|
$hak = $datShm[0]['AKSES_ID'];
|
|
$tampil = $datShm[0]['NAMA_AKSES'];
|
|
}
|
|
?>
|
|
|
|
<header class="page-header">
|
|
<h2><b>Data Analisa Stok Aging | <b style="color:LightGreen">[<?=$tampil?>]</b></b></h2>
|
|
<div class="right-wrapper pull-right">
|
|
<ol class="breadcrumbs">
|
|
<li><span><b style="color:Gold">Master Data </span></b></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 data-toggle="modal" data-target="#modalFitur" style="color:Coral"><b>Fitur </b><i class="fa fa-question-circle"></i></a>  
|
|
<a href="<?php echo base_url('') ?>index.php/Menu/SP_Sub2_Laporan_1" class="text-dark"><b>Kembali </b><i class="fa fa-backward"></i></a>
|
|
</div>
|
|
<h2 class="panel-title"><b style="color:Blue">STOK AGING | Total <b style="color:DarkRed" id="totSisa">0</b> EA | <b style="color:DarkRed" id="totPer">0.00</b></b></h2>
|
|
</header>
|
|
<div class="panel-body">
|
|
<?php if ($hak>0) { ?>
|
|
<?= form_open('Menu/SP_Excel_Sub2_DataAnalisaStokAging', array('method' => 'post'), array('id' => 'formsalesproduk')); ?>
|
|
<div class="form-group">
|
|
<h4><div class="col-md-2"><b style="color:SlateBlue">Kop</b></div></h4>
|
|
<div class="col-md-6">
|
|
<div class="form-group">
|
|
<select data-plugin-selectTwo id="id_corp" class="form-control populate" placeholder="Pilih Kop">
|
|
<option value="" selected>Semua Kop</option>
|
|
<?php if (is_array($corp) || is_object($corp)) {
|
|
foreach ($corp as $key) { ?>
|
|
<option value="<?= $key['ID_CORP'] ?>" >[<?= $key['ID_CORP'] ?>] <?= $key['NAMA_CORP'] ?></option>
|
|
<?php }
|
|
} ?>
|
|
</select>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
<div class="form-group">
|
|
<h4><div class="col-md-2"><b style="color:SlateBlue">Produk</b></div></h4>
|
|
<div class="col-md-6">
|
|
<div class="form-group">
|
|
<select data-plugin-selectTwo id="id_ssp" class="form-control populate">
|
|
<?php if ($hak>=3) { ?>
|
|
<option value="" selected>Semua Produk</option>
|
|
<?php } ?>
|
|
<?php if (is_array($ssp) || is_object($ssp)) {
|
|
foreach ($ssp as $key) { ?>
|
|
<?php if ($hak>=3) { ?>
|
|
<option value="<?= $key['ID_SSP'] ?>" ><?= $key['NAMA_MERK'] ?> <?= $key['NAMA_PRODUK'] ?></option>
|
|
<?php } else if ($key['NAMA_PANGGILAN_KARYAWAN']==$nama_panggilan) {?>
|
|
<option value="<?= $key['ID_SSP'] ?>" selected><?= $key['NAMA_MERK'] ?> <?= $key['NAMA_PRODUK'] ?></option>
|
|
<?php } ?>
|
|
<?php }
|
|
} ?>
|
|
</select>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
<div class="form-group">
|
|
<h4><div class="col-md-2"><b style="color:SlateBlue">Periode Beli</b></div></h4>
|
|
<div class="col-md-6">
|
|
<div class="input-daterange input-group">
|
|
<input type="date" class="form-control" id="tgl_awalbeli" onfocusout="cekTanggal(value, 1)" value="<?=$tgl?>" required>
|
|
<span class="input-group-addon">to</span>
|
|
<input type="date" class="form-control" id="tgl_akhirbeli" onfocusout="cekTanggal(value, 2)" value="<?=$tgl?>" required>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
<div class="form-group">
|
|
<h4><div class="col-md-2"><b style="color:SlateBlue">Periode Jual</b></div></h4>
|
|
<div class="col-md-6">
|
|
<div class="input-daterange input-group">
|
|
<input type="date" class="form-control" id="tgl_awaljual" onfocusout="cekTanggal(value, 3)" value="<?=$tgl?>" required>
|
|
<span class="input-group-addon">to</span>
|
|
<input type="date" class="form-control" id="tgl_akhirjual" onfocusout="cekTanggal(value, 4)" value="<?=$tgl?>" required>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
<div class="form-group">
|
|
<h4><div class="col-md-2"><b style="color:SlateBlue">Menu</b></div></h4>
|
|
<div class="col-md-10 btn-group">
|
|
<input type="hidden" class="form-control" id="id_corpfill" name="id_corpfill">
|
|
<input type="hidden" class="form-control" id="id_sspfill" name="id_sspfill">
|
|
<input type="hidden" class="form-control" id="tgl_awalbelifill" name="tgl_awalbelifill">
|
|
<input type="hidden" class="form-control" id="tgl_akhirbelifill" name="tgl_akhirbelifill">
|
|
<input type="hidden" class="form-control" id="tgl_awaljualfill" name="tgl_awaljualfill">
|
|
<input type="hidden" class="form-control" id="tgl_akhirjualfill" name="tgl_akhirjualfill">
|
|
<?php if ($hak>0) { ?>
|
|
<button type="button" id="lihatButton" class="btn btn-default" onclick="lihatData()"><b style="color:Indigo">Preview <i class="fa fa-search"></i></b></button>
|
|
<button type="submit" class="btn btn-default" onclick="isiData()" target="_blank"><b style="color:DarkGreen">Excel <i class="fa fa-file-excel-o"></i></b></button>
|
|
<button type="button" class="btn btn-default" onclick="reloadData()"><b style="color:FireBrick">Reset <i class="fa fa-rotate-left"></i></b></button>
|
|
<element id="progressRotate" hidden="hidden"><h4><div class="col-md-3"><b style="color:Red"><i class="fa fa-refresh fa-spin"></i> <i>Memuat Data<span id="wait">.</span></i></b></div><h4></element>
|
|
<?php } else { ?>
|
|
<button type="button" class="btn btn-default"><b style="color:Red">Tidak Berhak <i class="fa fa-times"></i></b></button>
|
|
<?php } ?>
|
|
</div>
|
|
</div>
|
|
<?= form_close(); ?>
|
|
<br>
|
|
<div id="searchView" hidden="hidden" class="form-group">
|
|
<div class="col-md-7"></div>
|
|
<div class="col-md-5">
|
|
<div><input type="text" id="searchData" oninput="cariData()" placeholder="Cari Data.." class="form-control"></div>
|
|
</div>
|
|
</div>
|
|
<div class="col-md-12">
|
|
<table class="table table-bordered table-striped mb-none">
|
|
<thead>
|
|
<th class="default center">No</th>
|
|
<th class="default">Merk</th>
|
|
<th class="default">Produk</th>
|
|
<th class="default">Barang</th>
|
|
<th class="center">Stok Terbeli</th>
|
|
<th class="center">Stok Terjual</th>
|
|
<th class="center">Sisa Stok</th>
|
|
<th class="text-right">Persediaan</th>
|
|
</thead>
|
|
<tbody id="isiTabelData"></tbody>
|
|
</table>
|
|
</div>
|
|
<?php } ?>
|
|
</div>
|
|
</section>
|
|
<!-- end: page -->
|
|
</section>
|
|
</div>
|
|
</section>
|
|
|
|
<div id="modalFitur" class="modal fade" tabindex="-1" role="dialog">
|
|
<div class="modal-dialog modal-lg" style="width:50%">
|
|
<div class="modal-content">
|
|
<header class="panel-heading">
|
|
<h4 class="panel-title"><b>Fitur Teknis</b></h4>
|
|
</header>
|
|
<div class="panel-body">
|
|
<div class="modal-wrapper">
|
|
<div class="modal-text">
|
|
<div class="form-group">
|
|
<h5>
|
|
<b style="color:DarkRed">Berikut ini adalah Daftar Menu yang dapat diakses sesuai dengan Hak Akses Anda.</b><br>
|
|
<br><b style="color:DarkGreen">AKSES PENUH</b><br><b> Bisa melihat semua Produk</b><br>
|
|
<br><b style="color:DarkGreen">OPERATOR</b><br><b>Hanya bisa melihat Produk milik Sendiri</b><br>
|
|
</h5>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
<footer class="panel-footer">
|
|
<div class="row">
|
|
<div class="col-md-12">
|
|
<button type="button" class="btn btn-default pull-right" data-dismiss="modal">Close</button>
|
|
</div>
|
|
</div>
|
|
</footer>
|
|
</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>
|
|
$(document).ready(function() {
|
|
var baris = '';
|
|
var hak = <?=$hak?>;
|
|
|
|
baris += '<tr>';
|
|
baris += '<td class="text-center" colspan="9"><h5><i><b style="color:Tomato">Data belum dipilih...</b></i></h5></td>';
|
|
baris += '</tr>';
|
|
$('#isiTabelData').html(baris);
|
|
})
|
|
|
|
var dots = window.setInterval( function() {
|
|
var wait = document.getElementById("wait");
|
|
if (wait.innerHTML.length > 3)
|
|
wait.innerHTML = "";
|
|
else
|
|
wait.innerHTML += ".";
|
|
}, 500);
|
|
|
|
function cekTanggal(value, id) {
|
|
PNotify.removeAll();
|
|
var now = "<?=$tgl?>";
|
|
|
|
if (value=="") {
|
|
notify("date_empty");
|
|
if (id==1) {
|
|
document.getElementById("tgl_awalbeli").value = now;
|
|
} else if (id==2) {
|
|
document.getElementById("tgl_akhirbeli").value = now;
|
|
} else if (id==3) {
|
|
document.getElementById("tgl_awaljual").value = now;
|
|
} else if (id==4) {
|
|
document.getElementById("tgl_akhirjual").value = now;
|
|
}
|
|
}
|
|
|
|
$.ajax({
|
|
url: "<?= base_url() ?>index.php/Menu/GE_AmbilData_CekTanggal",
|
|
type: "POST",
|
|
dataType: "json",
|
|
data: {
|
|
tgl_input : value,
|
|
},
|
|
success: function(response) {
|
|
if (response.value==1) {
|
|
notify("day_lock");
|
|
if (id==1) {
|
|
document.getElementById("tgl_awalbeli").value = now;
|
|
} else if (id==2) {
|
|
document.getElementById("tgl_akhirbeli").value = now;
|
|
} else if (id==3) {
|
|
document.getElementById("tgl_awaljual").value = now;
|
|
} else if (id==4) {
|
|
document.getElementById("tgl_akhirjual").value = now;
|
|
}
|
|
}
|
|
}
|
|
});
|
|
}
|
|
|
|
function reloadData() {
|
|
location.reload();
|
|
}
|
|
|
|
function isiData() {
|
|
document.getElementById('id_corpfill').value = document.getElementById('id_corp').value;
|
|
document.getElementById('id_sspfill').value = document.getElementById('id_ssp').value;
|
|
document.getElementById('tgl_awalbelifill').value = document.getElementById('tgl_awalbeli').value;
|
|
document.getElementById('tgl_akhirbelifill').value = document.getElementById('tgl_akhirbeli').value;
|
|
document.getElementById('tgl_awaljualfill').value = document.getElementById('tgl_awaljual').value;
|
|
document.getElementById('tgl_akhirjualfill').value = document.getElementById('tgl_akhirjual').value;
|
|
}
|
|
|
|
function lihatData() {
|
|
PNotify.removeAll();
|
|
|
|
document.getElementById('searchView').style.display = 'block';
|
|
tampilkanData(null);
|
|
}
|
|
|
|
function cariData() {
|
|
PNotify.removeAll();
|
|
var search = document.getElementById("searchData").value;
|
|
|
|
tampilkanData(search);
|
|
}
|
|
|
|
function tampilkanData(search) {
|
|
var id_corp = document.getElementById("id_corp").value;
|
|
var id_ssp = document.getElementById("id_ssp").value;
|
|
var awalbeli = document.getElementById("tgl_awalbeli").value;
|
|
var akhirbeli = document.getElementById("tgl_akhirbeli").value;
|
|
var awaljual = document.getElementById("tgl_awaljual").value;
|
|
var akhirjual = document.getElementById("tgl_akhirjual").value;
|
|
|
|
var baris = '';
|
|
|
|
baris += '<tr>';
|
|
baris += '<td class="text-center" colspan="9"><h5><i><b style="color:Tomato">Memuat Data...</b></i></h5></td>';
|
|
baris += '</tr>';
|
|
$('#isiTabelData').html(baris);
|
|
|
|
document.getElementById('progressRotate').style.display = 'block';
|
|
|
|
$.ajax({
|
|
type: 'POST',
|
|
data: {
|
|
id_corp : id_corp,
|
|
id_ssp : id_ssp,
|
|
search : search,
|
|
awalbeli : awalbeli,
|
|
akhirbeli : akhirbeli,
|
|
awaljual : awaljual,
|
|
akhirjual : akhirjual
|
|
},
|
|
url: '<?= base_url('') ?>index.php/Menu/SP_Ambil_Sub2_DataAnalisaStokAging',
|
|
dataType: 'json',
|
|
success: function(response) {
|
|
JUMLAH = response.data.length;
|
|
var baris = '';
|
|
|
|
if (JUMLAH==0) {
|
|
baris += '<tr>';
|
|
baris += '<td class="text-center" colspan="9"><h5><i><b style="color:Red">Tidak ada Data yang Sesuai.</b></i></h5></td>';
|
|
baris += '</tr>';
|
|
$('#isiTabelData').html(baris);
|
|
} else {
|
|
for (var i = 1; i <= JUMLAH; i++) {
|
|
var korang = response.data[i - 1]['KODE_BARANG'];
|
|
var narang = response.data[i - 1]['NAMA_BARANG'];
|
|
var merk = response.data[i - 1]['NAMA_MERK'];
|
|
var produk = response.data[i - 1]['NAMA_PRODUK'];
|
|
var qtybeli = response.data[i - 1]['TOTALQTY'];
|
|
var qtyjual = response.data[i - 1]['TOTALJUAL'];
|
|
var qtysisa = response.data[i - 1]['TOTALSISA'];
|
|
var persediaan = response.data[i - 1]['PERSEDIAAN'];
|
|
|
|
baris += '<tr>';
|
|
baris += '<td class="center" style="vertical-align: middle;" >' + i + '</td>';
|
|
baris += '<td class="text-left" style="vertical-align: middle;"><b style="color:Black">' + merk + '</b></td>';
|
|
baris += '<td class="text-left" style="vertical-align: middle;"><b style="color:DarkGreen">' + produk + '</b></td>';
|
|
baris += '<td class="text-left" style="vertical-align: middle;"><b style="color:Chocolate">' + korang + '</b><br>('+ narang +')</td>';
|
|
baris += '<td class="center" style="vertical-align: middle;"><b style="color:Teal">' + qtybeli + '</b></td>';
|
|
baris += '<td class="center" style="vertical-align: middle;"><b style="color:SaddleBrown">' + qtyjual + '</b></td>';
|
|
baris += '<td class="center" style="vertical-align: middle;"><b style="color:DarkOrchid">' + qtysisa + '</b></td>';
|
|
baris += '<td class="text-right" style="vertical-align: middle;"><b style="color:DarkKhaki">' + persediaan + '</b></td>';
|
|
baris += '</tr>';
|
|
}
|
|
$('#isiTabelData').html(baris);
|
|
if (search==null) {
|
|
$('#totPer').html(response.totPer);
|
|
$('#totSisa').html(response.totSisa);
|
|
}
|
|
}
|
|
document.getElementById('progressRotate').style.display = 'none';
|
|
}
|
|
});
|
|
}
|
|
|
|
</script>
|
|
</body>
|
|
|
|
</html>
|