Server : Apache System : Linux server2.corals.io 4.18.0-348.2.1.el8_5.x86_64 #1 SMP Mon Nov 15 09:17:08 EST 2021 x86_64 User : corals ( 1002) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system Directory : /home/corals/mcoil.corals.io/resources/views/admin/orders/ |
@extends('layouts.admin.app')
@section('stylesheets')
<link href="{{ asset('css/sweetalert2.min.css') }}" rel="stylesheet" type="text/css" />
@endsection
@section('css')
<style type="text/css">
@media only print {
table, .modal, .modal-dialog, .modal-content, .deliveries-temp {
height: auto !important;
overflow: visible !important;
display: block;
}
body, html, #wrapper {
width: 100% !important;
}
</style>
<link rel="stylesheet" href="//code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css">
<style>
.red{
background-color:red !important;
}
fieldset{
border: 1px solid #ddd !important;
margin: 0;
min-width: 0;
padding: 10px;
position: relative;
border-radius:4px;
background-color:#f5f5f5;
padding-left:10px!important;
}
legend{
font-size:14px;
font-weight:bold;
margin-bottom: 0px;
width: 35%;
border: 1px solid #ddd;
border-radius: 4px;
padding: 5px 5px 5px 10px;
background-color: #ffffff;
}
.search_btn{
margin-top: 11%;
}
.csv_css_cls{
margin-top: 26px;
}
.panel1 {
margin-bottom: 20px;
background-color: #fff;
border: 1px solid transparent;
border-radius: 4px;
-webkit-box-shadow: 0 1px 1px rgba(0, 0, 0, 0.05);
box-shadow: 0 1px 1px rgba(0, 0, 0, 0.05);
}
</style>
@endsection
@section('content')
<div class="row hidden-print">
<div class="col-md-12">
<section class="content">
@include('layouts.errors-and-messages')
<div class="box">
<div class="box-body">
<div class="col-md-12">
<div class="panel1 panel-default">
<div class="panel-body">
<fieldset class="col-md-12">
<legend>Filter By</legend>
<div class="panel1 panel-default">
<form name="training_filter" id="training_filter" action="{{route('admin.orders.filterOrdersReport')}}" method="get" class="">
<div class="panel-body">
<div class="row">
<div class="col-md-6">
<div class="form-group">
<label for="">From</label>
<input type="text" name="from_date" readonly autocomplete="off" id="datepicker1" class="form-control input-lg" value="<?php if(isset($filter_data) && !empty($filter_data['from_date'])){ echo date("d/m/Y",strtotime($filter_data['from_date'])); } ?>" >
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label for="">To</label>
<input type="text" name="to_date" readonly autocomplete="off" id="datepicker2" class="form-control input-lg" value="<?php if(isset($filter_data) && !empty($filter_data['to_date'])){ echo date("d/m/Y",strtotime($filter_data['to_date'])); } ?>">
</div>
</div>
</div>
<div class="row">
<div class="col-md-4">
<div class="form-group">
<label for="">Order Status</label>
<select name="order_status" id="order_status" class="form-control input-lg custom-select">
<option value="">Choose Option</option>
<?php
if(isset($filter_data)){ ?>
<option <?php if(isset($filter_data['order_status']) && $filter_data['order_status'] == '0'){ echo "selected"; } ?> value="0">Pending</option>
<option <?php if(isset($filter_data['order_status']) && $filter_data['order_status'] == '1'){ echo "selected"; } ?> value="1">Completed</option>
<?php } else{ ?>
<option value="0">Pending</option>
<option value="1">Completed</option>
<?php } ?>
</select>
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label for="">Payment Status</label>
<select name="payment_status" id="payment_status" class="form-control input-lg custom-select">
<option value="">Choose Option</option>
<?php
if(isset($filter_data)){ ?>
@foreach($orderStatuses as $payment)
<option <?php if(isset($filter_data['payment_status']) && $filter_data['payment_status'] == $payment->id){ echo "selected"; } ?> value="{{$payment->id}}">{{ucwords($payment->name)}}</option>
@endforeach
<?php } else{ ?>
@foreach($orderStatuses as $payment)
<option value="{{$payment->id}}">{{ucwords($payment->name)}}</option>
@endforeach
<?php } ?>
</select>
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label for="">Driver</label>
<select name="driver" id="driver" class="form-control input-lg custom-select">
<option value="">Choose Option</option>
<?php
if(isset($filter_data)){ ?>
@foreach($drivers as $driver)
<option <?php if(isset($filter_data['driver']) && $filter_data['driver'] == $driver->id){ echo "selected"; } ?> value="{{$driver->id}}">{{$driver->name}}</option>
@endforeach
<?php } else{ ?>
@foreach($drivers as $driver)
<option value="{{$driver->id}}">{{$driver->name}}</option>
@endforeach
<?php } ?>
</select>
</div>
</div>
</div>
<div class="row">
<div class="col-md-6">
<div class="form-group">
<button type="submit" class="btn btn-dark btn-lg btn-block"><i class="fa fa-search"></i> Search</button>
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<a href="{{ route('admin.orders.endOfDayReport') }}" class="btn btn-default btn-lg btn-block"><i class="fa fa-refresh"> Reset</i></a>
</div>
</div>
</div>
</div>
</form>
</div>
</fieldset>
<div class="clearfix"></div>
</div>
</div>
<h3 class="bold">End of Day Report <span class="font-black">|</span> <form target="_blank" name="training_filter" action="{{route('admin.orders.printFilterOrdersReport')}}" method="get" style="display:inline-block">
<input type="hidden" name="from_date" value="<?php if(isset($filter_data) && !empty($filter_data['from_date'])){ echo date("Y-m-d",strtotime($filter_data['from_date'])); } ?>">
<input type="hidden" name="to_date" value="<?php if(isset($filter_data) && !empty($filter_data['to_date'])){ echo date("Y-m-d",strtotime($filter_data['to_date'])); } ?>">
<input type="hidden" name="order_status" value="<?php if(isset($filter_data) && !empty($filter_data['order_status'])){ echo $filter_data['order_status']; } ?>">
<input type="hidden" name="driver" value="<?php if(isset($filter_data) && !empty($filter_data['driver'])){ echo $filter_data['driver']; } ?>">
<input type="hidden" name="payment_status" value="<?php if(isset($filter_data) && !empty($filter_data['payment_status'])){ echo $filter_data['payment_status']; } ?>">
<button type="submit" class="btn btn-dark btn-with-icon"><i class="fa fa-print"></i> Download Report</button>
</form></h3>
<!--<h3 class="bold">End of Day Report <span class="font-black">|</span> <a class="btn btn-dark btn-with-icon" href="#modalPrint" data-toggle="modal"><i class="fa fa-print"></i> View & Print</a> <span id="buttons"></span></h3>-->
<table class="table table-striped table-hover table-checkable dataTable table-responsive table-responsive-md responsive" id="order_table2">
<thead class="thead-dark">
<tr>
<th scope="col" class="all">ID</th>
<th scope="col" class="desktop">Customer</th>
<th scope="col" class="desktop">Address</th>
<th scope="col" class="min-mobile-l">Products</th>
<th scope="col" class="min-tablet-l">Date</th>
<th scope="col" class="min-tablet-l">Total</th>
<th scope="col" class="min-mobile-l">P.Status</th>
<th scope="col" class="min-tablet-l">O.Status</th>
<th scope="col" class="desktop">Delivery</th>
<th scope="col" class="desktop">Driver</th>
</tr>
</thead>
<tbody>
@foreach ($oilOrders as $order)
<tr>
<td class="dtr-control">{{$order->id}}</td>
<td>{{$order->customer->name}}</td>
<td>{{$order->address->address_1}} {{$order->address->address_2}} {{$order->address->address_2}} {{$order->address->town}} {{$order->address->town}} {{$order->address->county}}</td>
<td>
@if( isset( $order->products ) )
@foreach( $order->products as $product )
<a title="Show order" href="{{ route('admin.orders.show', $order->id) }}">
@if(isset($product->cover))
<img src="{{ URL::asset('/public/storage/'.$product->cover) }}" style="height: 15px;width: 15px; margin-right:5px" />
@else
<img src="{{ url('/images/default.jpg') }}" style="height: 15px;width: 15px; margin-right:5px" />
@endif
{{ $product->name }}</a> (@if(empty($product['pivot']['quantity'])){{ ('Fill the Tank') }}@else{{ $product['pivot']['quantity'] }}@endif)
@endforeach
@endif
</td>
<td data-sort="{{ date('Ymd', strtotime($order->created_at)) }}">{{ date('d/m/Y h:i a', strtotime($order->created_at)) }}</td>
<td>{{ config('cart.currency_symbol') }}{{ $order->total }} </td>
<td><span class="badge font-badge @if($order->status->name == 'paid') badge-success @elseif($order->status->name == 'pending') badge-warning @elseif($order->status->name == 'awaiting payment') badge-awaiting @elseif($order->status->name == 'error') badge-danger @else @endif">{{ $order->status->name }}</span></td>
<td>
<span class="badge font-badge @if($order->order_status == '1') badge-success @else badge-warning @endif">{{ ($order->order_status == '1') ? 'Completed' : 'Pending' }}</span>
</td>
<td data-sort="{{ date('Ymd', strtotime($order->delivery_date)) }}">{{ date('d/m/Y', strtotime($order->delivery_date)) }}</td>
@if($order->driver_id == '')
<td class="redbg"></td>
@else
@foreach($drivers as $driver)
@if($driver->id == $order->driver_id)
@if($driver->status == '1')
<td>{{ $driver->name}}</td>
@else
<td class="redbg">{{ $driver->name}}</td>
@endif
@endif
@endforeach
@endif
</tr>
@endforeach
</tbody>
</table>
</div>
</div>
</div>
</section>
</div>
</div>
<div id="modalPrint" class="modal fade" tabindex="-1" role="dialog" aria-labelledby="TodaysDeliveries">
<div class="modal-dialog deliveries-modal" role="document">
<div class="modal-content">
<div class="modal-header toolbar hidden-print">
<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
<div class="col-md-2 text-left">
<form target="_blank" name="training_filter" action="{{route('admin.orders.printFilterOrdersReport')}}" method="get" class="">
<input type="hidden" name="from_date" value="<?php if(isset($filter_data) && !empty($filter_data['from_date'])){ echo date("Y-m-d",strtotime($filter_data['from_date'])); } ?>">
<input type="hidden" name="to_date" value="<?php if(isset($filter_data) && !empty($filter_data['to_date'])){ echo date("Y-m-d",strtotime($filter_data['to_date'])); } ?>">
<input type="hidden" name="order_status" value="<?php if(isset($filter_data) && !empty($filter_data['order_status'])){ echo date("Y-m-d",strtotime($filter_data['order_status'])); } ?>">
<input type="hidden" name="payment_status" value="<?php if(isset($filter_data) && !empty($filter_data['payment_status'])){ echo date("Y-m-d",strtotime($filter_data['payment_status'])); } ?>">
<button type="submit" class="btn btn-dark btn-lg btn-block font-black printdeliveries-temp1 btn-with-icon-bg"><i class="fa fa-print"></i> Print</button>
</form>
</div>
</div>
<div class="modal-body" id="">
<div class="deliveries-temp ">
<table class="table table-striped table-hover">
<thead class="thead-dark">
<tr>
<th>ID</th>
<th>Customer</th>
<th>Address</th>
<th>Product</th>
<th>Date</th>
<th>Total</th>
<th>P.Status</th>
<th>O.Status</th>
<th>Delivery</th>
<th>Driver</th>
</tr>
</thead>
<tbody>
@foreach ($oilOrders as $order)
<tr>
<td class="dtr-control">{{$order->id}}</td>
<td>{{$order->customer->name}}</td>
<td>{{$order->address->address_1}} {{$order->address->address_2}} {{$order->address->address_2}} {{$order->address->town}} {{$order->address->town}} {{$order->address->county}}
</td>
<td>
@if( isset( $order->products ) )
@foreach( $order->products as $product )
<a title="Show order" href="{{ route('admin.orders.show', $order->id) }}">
@if(isset($product->cover))
<img src="{{ URL::asset('/public/storage/'.$product->cover) }}" style="height: 15px;width: 15px; margin-right:5px" />
@else
<img src="{{ url('/images/default.jpg') }}" style="height: 15px;width: 15px; margin-right:5px" />
@endif
{{ $product->name }}</a>
(@if(empty($product['pivot']['quantity'])){{ ('Fill the Tank') }}@else{{ $product['pivot']['quantity'] }}@endif)
@endforeach
@endif
</td>
<td data-sort="{{ date('Ymd', strtotime($order->created_at)) }}">{{ date('d/m/Y h:i a', strtotime($order->created_at)) }}</td>
<td>{{ config('cart.currency_symbol') }}{{ $order->total }} </td>
<td><span class="badge font-badge @if($order->status->name == 'paid') badge-success @elseif($order->status->name == 'pending') badge-warning @elseif($order->status->name == 'awaiting payment') badge-awaiting @elseif($order->status->name == 'error') badge-danger @else @endif">{{ $order->status->name }}</span></td>
<td>
<span class="badge font-badge @if($order->order_status == '1') badge-success @else badge-warning @endif">{{ ($order->order_status == '1') ? 'Completed' : 'Pending' }}</span>
</td>
<td data-sort="{{ date('Ymd', strtotime($order->delivery_date)) }}">{{ date('d/m/Y', strtotime($order->delivery_date)) }}</td>
@if($order->driver_id == '')
<td class="redbg"></td>
@else
@foreach($drivers as $driver)
@if($driver->id == $order->driver_id)
@if($driver->status == '1')
<td>{{ $driver->name}}</td>
@else
<td class="redbg">{{ $driver->name}}</td>
@endif
@endif
@endforeach
@endif
</tr>
@endforeach
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
@endsection
@section('js')
<script src="{{ asset('js/sweetalert2.all.min.js') }}"></script>
<script src="https://code.jquery.com/ui/1.12.1/jquery-ui.js"></script>
<script type="text/javascript" src="https://cdn.datatables.net/buttons/1.6.2/js/dataTables.buttons.min.js"></script>
<script type="text/javascript" src="https://cdn.datatables.net/buttons/1.6.2/js/buttons.html5.min.js"></script>
<script type="text/javascript">
$.fn.dataTable.ext.order['dom-text'] = function ( settings, col ) {
return this.api().column( col, {order:'index'} ).nodes().map( function ( td, i ) {
return $('input', td).val();
} );
}
$(document).ready( function () {
$.fn.DataTable.ext.pager.numbers_length = 5;
var table = $('#order_table2').DataTable({
"responsive": true,
"order": [[ 0, "desc" ]],
"bAutoWidth": false,
"rowReorder": {
selector: 'td:nth-child(2)'
},
"columns": [
null,
null,
null,
null,
null,
null,
{ "orderDataType": "dom-text", type: 'string' },
{ "orderDataType": "dom-text", type: 'string' },
null,
null,
],
dom: 'Blfrtip',
buttons: [
{
extend: 'csv',
title: 'Enf of Day Report ({{ date("d-m-Y") }})',
exportOptions: {
columns: "thead th:not(.noExport)"
}
}
]
});
var buttons = new $.fn.dataTable.Buttons(table, {
buttons: [
{
extend: 'csvHtml5',
title: 'Enf of Day Report ({{ date("d-m-Y") }})',
exportOptions: {
columns: "thead th:not(.noExport)"
}
}
]
}).container().appendTo($('#buttons'));
$('#order_table2_wrapper').find('.dt-buttons').remove();
$('.dt-button').addClass('btn btn-dark btn-with-icon');
$('.dt-button').prepend('<i class="fa fa-download"></i> Download ');
/*$('#order_table2').DataTable({
"responsive": true,
"order": [[ 0, "desc" ]],
"bAutoWidth": false,
"rowReorder": {
selector: 'td:nth-child(2)'
},
"columnDefs": [
{ "width": "130px", "targets": 2 },
{ "width": "130px", "targets": 10 }
]
});*/
$('#order_table_completed').DataTable({
"responsive": true,
"order": [[ 0, "desc" ]],
"bAutoWidth": false,
"rowReorder": {
selector: 'td:nth-child(2)'
},
"columnDefs": [
{ "width": "130px", "targets": 2 },
{ "width": "130px", "targets": 10 }
]
});
$('.delete_submit').on('click',function(e) {
var refer = $(this).attr("id");
var step_remove_url = $(this).closest("#remove-from-form").attr('action');
e.preventDefault();
e.stopPropagation();
if (refer != '') {
Swal.fire({
title: 'Are you sure?',
text: "You won't be able to revert this!",
type: 'warning',
showCancelButton: true,
confirmButtonColor: '#3085d6',
cancelButtonColor: '#d33',
confirmButtonText: 'Yes, delete it!'
}).then((result) => {
if (result.value) {
Swal.fire({
title: 'Deleted!',
text: "Your order has been deleted.",
type: 'success',
showConfirmButton: false,
timer: 1500
});
$.ajax({
url: step_remove_url,
method: "POST",
data: {
"_token": "{{ csrf_token() }}",
"_method": "delete",
id: refer
},
success:function(response){
setTimeout(function(){
window.location.reload();
}, 1500);
}
});
}
});
}
});
$( "#datepicker1" ).datepicker({
dateFormat: 'dd/mm/yy'
});
$( "#datepicker2" ).datepicker({
dateFormat: 'dd/mm/yy'
});
$('.printdeliveries-temp').click(function() {
$.ajax({
url: step_remove_url,
method: "POST",
data: {
"_token": "{{ csrf_token() }}",
"_method": "delete",
id: refer
},
success:function(response){
setTimeout(function(){
window.location.reload();
}, 1500);
}
});
/*var outerHTML_text = $(this).closest('.modal-content').find('.deliveries-temp').prop('outerHTML');
Popup($(this).closest('.modal-content').find('.deliveries-temp').prop('outerHTML', outerHTML_text));
function Popup(data) {
window.print();
return true;
}*/
});
});
</script>
@endsection