|
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/rabbithabit.com/public_html/application/views/admin/orders/ |
Upload File : |
<style>
.chosen-container, .chosen-container-single{
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>
<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="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>
<script type="text/javascript" src="https://www.rabbithabit.com/assets/admin/js/jquery.dataTables.js"></script>
<script type="text/javascript" src="https://www.rabbithabit.com/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'); }
}
});
});
$(".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',
}
});
$('#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 class="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="chosen-select" id="dataEnter"><?php if($customers != null): ?><?php foreach ($customers as $customer):?><option value="<?= $customer->customer_id;?>"><?php
$customer_detail = $this->db->select('name,email')->from('customers')->where('id_customers',$customer->customer_id)->get()->row();
if(count($customer_detail) > 0){
echo ucfirst(str_replace("'",'',$customer_detail->name))." ( ".str_replace("'",'',$customer_detail->email)." )";
}
?>
</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" 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>