|
Server : Apache/2.4.18 (Ubuntu) System : Linux canvaswebdesign 3.13.0-71-generic #114-Ubuntu SMP Tue Dec 1 02:34:22 UTC 2015 x86_64 User : oppastar ( 1041) PHP Version : 7.0.33-0ubuntu0.16.04.15 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, Directory : /var/www/laciasmara.com/public_html/shop/application/views/admin/orders/ |
Upload File : |
<link rel="stylesheet" href="<?= base_url('assets/admin/chosen_js/chosen.css'); ?>">
<style>
.chosen-container,
.chosen-container-single {
width: 100% !important;
}
.table>tbody>tr>td>.chosen-container {
width: 100% !important;
}
@media only screen and (min-width: 768px) {
.dataTables_filter {
text-align: right;
}
.dataTables_paginate {
text-align: right;
}
.dataTables_info {
padding-top: 25px;
}
.export {
text-align: right;
}
.addBtn {
width: 300px;
text-align: center;
}
.divAdd {
text-align: left;
}
}
@media only screen and (max-width: 768px) {
.divAdd {
text-align: center;
}
.addBtn {
width: 100%;
text-align: center;
}
.export {
text-align: right;
padding: 15px 0;
}
}
</style>
<div class="row">
<div class="col-sm-12">
<p><a href="<?= base_url('admin/dashboard'); ?>"><i class="fa fa-arrow-left" aria-hidden="true"></i> Kembali ke Dashboard</a></p><br>
<h2>Penjualan</h2>
<?= $this->session->flashdata('success'); //to display success message
?>
<?= $this->session->flashdata('result'); //to display result message
?>
</div><!-- end class="col-sm-12" -->
</div> <!-- end row -->
<form method="post" action="javascript:void(0);" id="filterData">
<div class="row">
<div class="col-md-12 col-xs-12" style="border:1px solid #ccc; margin-top: 10px;">
<div class="col-md-12 col-xs-12">
<h3>Filter Order</h3>
<div class="form-group row">
<div class="col-md-12 col-xs-12">
<label for="NoPemesanan" class="col-sm-2 col-form-label">Filter</label>
<div class="col-sm-10">
<select class="form-control" name="filter_key" id="filterkey">
<option value="id_orders">ID Order</option>
<option value="voucher">Voucher</option>
<option value="payment_status">Status Pembayaran</option>
<option value="payment_type">Tipe Pembayaran</option>
<option value="sale">Sale</option>
<option value="date">Tanggal</option>
<option value="totalorder">Total Order</option>
<option value="customer_id">Pelanggan</option>
<option value="product">Produk</option>
</select>
</div>
</div>
</div>
<div id="myform"></div>
<div class="col-md-12 col-xs-12" style="margin: 5px 0;">
<input class="btn btn-primary form-control" type="submit" name="submit" value="Filter">
</div>
<div class="col-md-12 col-xs-12" style="margin: 5px 0; text-align: right;">
<a href="<?php echo base_url('admin/orders'); ?>" style="color:#f00">Reset Filter</a>
</div>
</div><!-- end class="col-sm-12" -->
</div>
</div> <!-- end row -->
</form>
<a class="btn btn-success" href="<?= base_url('admin/orders/add_order'); ?>"><i class="fa fa-plus" aria-hidden="true"></i> BUAT ORDER BARU</a>
<div class="row">
<div class="col-md-12 col-xs-12">
<!-- <div class="col-md-6 col-xs-12 divAdd">
<a href="<?php echo base_url('admin/orders/add_order'); ?>" class="btn btn-success addBtn"><i class="fa fa-plus" aria-hidden="true"></i> Add New Order</a>
</div> -->
<!-- <div class="col-md-6 col-xs-12 export">
<p><a href="<?= base_url('admin/order_excel_export/alldata'); ?>" id="linkExport"><img src="<?= base_url('assets/admin/img/excel-icon.png'); ?>"> EXPORT TO MS EXCEL</a></p>
<p>(Export this to excel file)</p>
</div> -->
<!-- <div class="col-md-12 col-xs-12" style="text-align: center;">
<p><a class="btn btn-danger" href="<?= base_url('admin/orders/sync_all_orders'); ?>" onclick="return confirm('***Order dengan status OPEN dan DELIVERED akan di sync.***\nApakah anda yakin untuk melakukan ini?');">SYNC SEMUA ORDER KE JURNAL.ID</a></p>
<p>Order yang akan di sync adalah order dengan status OPEN dan DELIVERED.</p>
</div> -->
</div>
</div>
<div class="tab-content">
<style>
.nav-tabs li a {
position: relative;
border-radius: 4px;
margin-right: 5px;
padding-right: 30px;
}
.nav-tabs li a .badge {
position: absolute;
top: -10px;
left: -10px;
background-color: red;
color: white;
border-radius: 50%;
padding: 5px 10px;
}
</style>
<ul class="nav nav-tabs" role="tablist">
<li role="presentation" class="active">
<a aria-controls="incoming" href="#incoming" role="tab" data-toggle="tab" class="btn btn-danger">
Incoming <span class="badge"><?= $total_incoming_order; ?></span>
</a>
</li>
<li role="presentation">
<a href="#processing" aria-controls="processing" role="tab" data-toggle="tab" class="btn btn-warning">Processing</a>
</li>
<li role="presentation">
<a href="#completed" aria-controls="completed" role="tab" data-toggle="tab" class="btn btn-success">Completed</a>
</li>
<li role="presentation">
<a href="#all" aria-controls="all" role="tab" data-toggle="tab" class="btn btn-primary">All Order</a>
</li>
</ul>
<div role="tabpanel" class="tab-pane active" id="incoming">
<br>
<h3 style="text-align: center;"><b>Incoming Order</b></h3>
<div class="row">
<div class="col-md-12" id="table1">
<div class="table-responsive">
<table class="table table-striped table-desa1" style="width:100%">
<thead>
<tr>
<th style="width:50px">No</th>
<th>ID Order</th>
<th>Tanggal Order</th>
<th>Pelanggan</th>
<th>Jumlah (Rp)</th>
<th>Tipe Pembayaran</th>
<th>Status Order</th>
<th>Info Tambahan</th>
<th>Produk Indent</th>
<th>Lihat Detail</th>
<th>Dibuat Oleh</th>
</tr>
</thead>
</table>
</div>
</div>
</div>
</div>
<div role="tabpanel" class="tab-pane" id="processing">
<br>
<h3 style="text-align: center;"><b>Order Processing</b></h3>
<div class="row">
<div class="col-md-12" id="table2">
<div class="table-responsive">
<table class="table table-striped table-desa2" style="width:100%">
<thead>
<tr>
<th style="width:50px">No</th>
<th>ID Order</th>
<th>Tanggal Order</th>
<th>Pelanggan</th>
<th>Jumlah (Rp)</th>
<th>Tipe Pembayaran</th>
<th>Status Order</th>
<th>Info Tambahan</th>
<th>Produk Indent</th>
<th>Lihat Detail</th>
<th>Dibuat Oleh</th>
</tr>
</thead>
</table>
</div>
</div>
</div>
</div>
<div role="tabpanel" class="tab-pane" id="completed">
<br>
<h3 style="text-align: center;"><b>Completed Order</b></h3>
<div class="row">
<div class="col-md-12" id="table3">
<div class="table-responsive">
<table class="table table-striped table-desa3" style="width:100%">
<thead>
<tr>
<th style="width:50px">No</th>
<th>ID Order</th>
<th>Tanggal Order</th>
<th>Pelanggan</th>
<th>Jumlah (Rp)</th>
<th>Tipe Pembayaran</th>
<th>Status Order</th>
<th>Info Tambahan</th>
<th>Produk Indent</th>
<th>Lihat Detail</th>
<th>Dibuat Oleh</th>
</tr>
</thead>
</table>
</div>
</div>
</div>
</div>
<div role="tabpanel" class="tab-pane" id="all">
<br>
<h3 style="text-align: center;"><b>All Order</b></h3>
<div class="row">
<div class="col-md-12" id="table">
<div class="table-responsive">
<table class="table table-striped table-desa" style="width:100%">
<thead>
<tr>
<th style="width:50px">No</th>
<th>ID Order</th>
<th>Tanggal Order</th>
<th>Pelanggan</th>
<th>Jumlah (Rp)</th>
<th>Tipe Pembayaran</th>
<th>Status Order</th>
<th>Info Tambahan</th>
<th>Produk Indent</th>
<th>Lihat Detail</th>
<th>Dibuat Oleh</th>
</tr>
</thead>
</table>
</div>
</div>
</div>
</div>
</div>
<script type="text/javascript" src="https://www.laciasmara.com/shop/assets/admin/js/jquery.dataTables.js"></script>
<script type="text/javascript" src="https://www.laciasmara.com/shop/assets/admin/js/dataTables.bootstrap.js"></script>
<script type="text/javascript">
$(document).ready(function() {
var myHtml = '<div class="form-group row"><div class="col-md-12 col-xs-12"><label for="NoPemesanan" class="col-sm-2 col-form-label">Enter</label><div class="col-sm-10"><input class="form-control" type="text" id="dataEnter" placeholder="Enter"></div></div></div>';
$('#myform').html(myHtml);
$("#filterData").submit(function() {
var filterkey = $('#filterkey').val();
if (filterkey == 'date') {
var startDate = $('#startDate').val();
var endDate = $('#endDate').val();
var dataEnter = startDate + '_' + endDate;
} else if (filterkey == 'totalorder') {
var startMoney = $('#startMoney').val();
var endMoney = $('#endMoney').val();
var dataEnter = startMoney + '_' + endMoney;
} else {
var dataEnter = $('#dataEnter').val();
}
$('#table').html('<table class="table table-striped table-desa" style="width:100%"><thead><tr><th style="width:50px">No</th><th>ID Order</th><th>Tanggal Order</th><th>Pelanggan</th><th>Jumlah (Rp)</th><th>Tipe Pembayaran</th><th>Status Order</th><th>Info Tambahan</th><th>Produk Indent</th><th>Lihat Detail</th><th>Dibuat Oleh</th></tr></thead></table>');
$(".table-desa").DataTable({
ordering: false,
responsive: {
Warehouse: false
},
oLanguage: {
sSearch: "Filter results:"
},
//pageLength: 100,
processing: true,
serverSide: true,
ajax: {
url: "<?php echo base_url('admin/orders/alldata') ?>",
data: {
'<?= $this->security->get_csrf_token_name(); ?>': '<?= $this->security->get_csrf_hash(); ?>',
'filterkey': filterkey,
'dataenter': dataEnter
},
language: {
'search': 'Cari Order ID'
},
type: 'POST',
complete: function() {
$('#linkExport').removeAttr('href');
$('#linkExport').attr('href', '<?= base_url('admin/order_excel_export/index'); ?>/' + filterkey + '/' + dataEnter);
},
error: function() {
console.log('failure');
}
}
});
// Menambahkan kode untuk membuka tab "All Order"
$('.nav-tabs a[href="#all"]').tab('show');
});
$(".table-desa").DataTable({
ordering: false,
responsive: {
Warehouse: false
},
oLanguage: {
sSearch: "Filter results:"
},
//pageLength: 100,
processing: true,
serverSide: true,
ajax: {
url: "<?php echo base_url('admin/orders/alldata') ?>",
data: {
'<?= $this->security->get_csrf_token_name(); ?>': '<?= $this->security->get_csrf_hash(); ?>'
},
type: 'POST',
}
});
$(".table-desa1").DataTable({
ordering: false,
responsive: {
Warehouse: false
},
oLanguage: {
sSearch: "Filter results:"
},
//pageLength: 100,
processing: true,
serverSide: true,
ajax: {
url: "<?php echo base_url('admin/orders/incoming') ?>",
data: {
'<?= $this->security->get_csrf_token_name(); ?>': '<?= $this->security->get_csrf_hash(); ?>'
},
type: 'POST',
}
});
$(".table-desa2").DataTable({
ordering: false,
responsive: {
Warehouse: false
},
oLanguage: {
sSearch: "Filter results:"
},
//pageLength: 100,
processing: true,
serverSide: true,
ajax: {
url: "<?php echo base_url('admin/orders/processing') ?>",
data: {
'<?= $this->security->get_csrf_token_name(); ?>': '<?= $this->security->get_csrf_hash(); ?>'
},
type: 'POST',
}
});
$(".table-desa3").DataTable({
ordering: false,
responsive: {
Warehouse: false
},
oLanguage: {
sSearch: "Filter results:"
},
//pageLength: 100,
processing: true,
serverSide: true,
ajax: {
url: "<?php echo base_url('admin/orders/completed') ?>",
data: {
'<?= $this->security->get_csrf_token_name(); ?>': '<?= $this->security->get_csrf_hash(); ?>'
},
type: 'POST',
}
});
$('#filterkey').change(function() {
var filter_key = $(this).val();
if (filter_key == 'id_orders') {
var myHtml = '<div class="form-group row"><div class="col-md-12 col-xs-12"><label for="NoPemesanan" class="col-sm-2 col-form-label">Enter</label><div class="col-sm-10"><input class="form-control" type="text" id="dataEnter" placeholder="Enter"></div></div></div>';
$('#myform').html(myHtml);
}
if (filter_key == 'voucher') {
var myHtml = '<div class="form-group row"><div class="col-md-12 col-xs-12"><label for="NoPemesanan" class="col-sm-2 col-form-label">Use Voucher</label><div class="col-sm-10"><select class="form-control" name="dataEnter" id="dataEnter"><option value="0">No</option><option value="1">Yes</option></select></div></div></div>';
$('#myform').html(myHtml);
}
if ((filter_key == 'flashsale') || (filter_key == 'sale')) {
var myHtml = '<div class="form-group row" id="formSelect"><div class="col-md-12 col-xs-12"><label for="NoPemesanan" class="col-sm-2 col-form-label">Select Data</label><div class="col-sm-10"><select class="form-control" name="dataEnter" id="dataEnter"><option value="no">No</option><option value="yes">Yes</option></select></div></div></div>';
$('#myform').html(myHtml);
}
if (filter_key == 'payment_status') {
var myHtml = '<div class="form-group row"><div class="col-md-12 col-xs-12" style="margin: 5px 0;"><label for="exampleInputEmail1" class="col-sm-2 col-form-label">Status Payment</label><div class="col-sm-10"><select class="form-control" id="dataEnter"><option value="0">Pending</option><option value="1">Not Paid</option><option value="2">Cancel</option><option value="3">Paid</option><option value="4">Process</option><option value="5">Delivered</option></select></div></div></div>';
$('#myform').html(myHtml);
}
if (filter_key == 'payment_type') {
var myHtml = '<div class="form-group row"><div class9="col-md-12 col-xs-12" style="margin: 5px 0;"><label for="exampleInputEmail1" class="col-sm-2 col-form-label">Status Type</label><div class="col-sm-10"><select class="form-control" id="dataEnter"><option value="bank transfer BCA">BCA</option><option value="bank transfer MANDIRI">MANDIRI</option><option value="midtrans">MIDTRANS</option><option value="top">TOP</option></select></div></div></div>';
$('#myform').html(myHtml);
}
if (filter_key == 'date') {
var myHtml = '<div class="form-group row"><div class="col-md-12 col-xs-12" style="margin: 5px 0;"><label for="exampleInputEmail1" class="col-sm-2 col-form-label">Start Date</label><div class="col-sm-10"><div class="input-group date"><input class="datepickers form-control" type="text" name="startDate" placeholder="Start Date" id="startDate"><span class="input-group-addon"><span class="fa fa-calendar"></span></span></div></div></div></div><div class="form-group row"><div class="col-md-12 col-xs-12" style="margin: 5px 0;"><label for="exampleInputEmail1" class="col-sm-2 col-form-label">End Date</label><div class="col-sm-10"><div class="input-group date"><input class="datepickers form-control" type="text" name="endDate" placeholder="End Date" id="endDate"><span class="input-group-addon"><span class="fa fa-calendar"></span></span></div></div></div></div><script>$(document).ready(function(){ $(".datepickers").datepicker({dateFormat: \'yy-mm-dd\'}); $(".datepickers").attr("autocomplete", "off"); });<\/script>';
$('#myform').html(myHtml);
}
if (filter_key == 'totalorder') {
var myHtml = '<div class="form-group row"><div class="col-md-12 col-xs-12" style="margin: 5px 0;"><label for="exampleInputEmail1" class="col-sm-2 col-form-label">From</label><div class="col-sm-10"><div class="input-group"><span class="input-group-addon">Rp.</span><input class="form-control" type="number" min="0" name="startMoney" value="0" id="startMoney"></div></div></div></div><div class="form-group row"><div class="col-md-12 col-xs-12" style="margin: 5px 0;"><label for="exampleInputEmail1" class="col-sm-2 col-form-label">To</label><div class="col-sm-10"><div class="input-group"><span class="input-group-addon">Rp.</span><input class="form-control" type="number" min="0" name="endMoney" value="0" id="endMoney"></div></div></div></div>';
$('#myform').html(myHtml);
}
if (filter_key == 'marketplace_name') {
var myHtml = '<div class="form-group row"><div class="col-md-12 col-xs-12" style="margin: 5px 0;"><label for="exampleInputEmail1" class="col-sm-2 col-form-label">Market Place</label><div class="col-sm-10"><select class="form-control" id="dataEnter"><?php if ($marketplaces != null) : ?><?php foreach ($marketplaces as $marketplace) : ?><option value="<?= $marketplace->marketplace_name; ?>"><?= ucfirst($marketplace->marketplace_name); ?></option><?php endforeach; ?><?php endif; ?></select></div></div></div>';
$('#myform').html(myHtml);
}
if (filter_key == 'customer_id') {
var myHtml = '<div class="form-group row"><div class="col-md-12 col-xs-12" style="margin: 5px 0;"><label for="exampleInputEmail1" class="col-sm-2 col-form-label">Customer</label><div class="col-sm-10"><select class=" form-control" id="dataEnter"><?php if ($customers != null) : ?><?php foreach ($customers as $customer) : ?><option value="<?= $customer->customer_id; ?>"><?php
$customer_count = $this->db->select('name,email')->from('customers')->where('id_customers', $customer->customer_id)->get()->num_rows();
if ($customer_count > 0) {
$customer_detail = $this->db->select('name,email,DATE_FORMAT(join_date, "%d-%m-%Y") as date')->from('customers')->where('id_customers', $customer->customer_id)->get()->row();
echo ucfirst(str_replace("'", '', $customer_detail->name)) . " ( " . str_replace("'", '', $customer_detail->email) . " ) sejak " . str_replace("'", '', $customer_detail->date) . " ";
}
?> </option><?php endforeach; ?>
<?php endif; ?> < /select></div > < /div></div > < script > $(".chosen-select").chosen(); < \/script>';
$('#myform').html(myHtml);
}
if (filter_key == 'product') {
var myHtml = '<div class="form-group row" id="selectProd"><div class="col-md-12 col-xs-12" style="margin: 5px 0;"><label for="exampleInputEmail1" class="col-sm-2 col-form-label">Product</label><div class="col-sm-10"><select class="chosen-select form-control" id="dataEnter"><?php if ($product != null) : ?><?php foreach ($product as $result) : ?><option value="<?= $result->id_products; ?>"><?= str_replace("'", '', $result->title); ?></option><?php endforeach; ?><?php endif; ?></select></div></div></div><script>$(".chosen-select").chosen();<\/script>';
$('#myform').html(myHtml);
}
if (filter_key == 'sync') {
var myHtml = '';
$('#myform').html(myHtml);
}
if (filter_key == 'open') {
var myHtml = '';
$('#myform').html(myHtml);
}
});
});
</script>
<script src="<?= base_url('assets/admin/chosen_js/chosen.jquery.js'); ?>" type="text/javascript"></script>
<script src="<?= base_url('assets/admin/chosen_js/prism.js'); ?>" type="text/javascript" charset="utf-8"></script>
<script src="<?= base_url('assets/admin/chosen_js/init.js'); ?>" type="text/javascript" charset="utf-8"></script>