{{\App::setLocale(Session::get('locale'))}}
@extends('admin.layouts.app')
@section('title', trans('admin.all_order'))
@section('content-heading')
	<section class="content-header">
		<h1>@lang('admin.all_order')</h1>
		<ol class="breadcrumb">
			<li><a href="{{ route('admindashboard') }}"><i class="fa fa-dashboard"></i> @lang('admin.dashboard')</a></li>
			<li><a href="{{ route('members') }}">@lang('admin.order')</a></li>
			<li class="active">@lang('admin.all_order')</li>
      </ol>
    </section>
@endsection
@section('content') 
    <section class="content">
		<div class="row">
			<div class="col-xs-12">
				<div class="box">
					<div class="box-header"></div>
					<div class="box-body">
						<table id="list_products" class="table table-bordered table-hover">
							<thead>
								<tr>
									<th>#</th>
									<th>@lang('admin.order_id')</th>
									<th>@lang('admin.customer')</th>
									<th>@lang('admin.total')</th>
									<th>@lang('admin.pay_method')</th>
									<th>@lang('admin.status') </th>
									<th>@lang('admin.date') </th>
									<th>@lang('admin.action') </th>
									
									<th>@lang('word.realname') </th>
									<th>@lang('word.phone_no') </th>
									<th>@lang('mall.province') </th>
									<th>@lang('mall.city') </th>
									<th>@lang('mall.area') </th>
									<th>@lang('mall.full_address') </th>
								</tr>
							</thead>
							<tbody>
							</tbody>
						</table>
					</div>
				</div>
			</div>
		</div>
	</section>

@endsection

@section('extra-script')

<link rel="stylesheet" href="{{asset('css/sweetalert.css')}}">
<script src="{{asset('js/sweetalert.min.js')}}"></script>
<script src="//cdn.datatables.net/1.10.15/js/jquery.dataTables.min.js"></script>
<link href="//cdn.datatables.net/1.10.15/css/jquery.dataTables.min.css" rel="stylesheet">
<script src="//cdn.datatables.net/1.10.15/js/dataTables.material.min.js"></script>
<link href="//cdn.datatables.net/responsive/2.1.1/css/responsive.bootstrap.min.css" rel="stylesheet">
<script src="//cdn.datatables.net/responsive/2.1.1/js/dataTables.responsive.min.js"></script>
<script src="//cdn.datatables.net/responsive/2.1.1/js/responsive.bootstrap.min.js"></script>
<!-- Export Buttons -->
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/buttons/1.3.1/css/buttons.dataTables.min.css">
<script type="text/javascript" language="javascript" src="https://cdn.datatables.net/buttons/1.3.1/js/dataTables.buttons.min.js"></script>
<script type="text/javascript" language="javascript" src="//cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
<script type="text/javascript" language="javascript" src="//cdn.rawgit.com/bpampuch/pdfmake/0.1.27/build/pdfmake.min.js"></script>
<script type="text/javascript" language="javascript" src="//cdn.rawgit.com/bpampuch/pdfmake/0.1.27/build/vfs_fonts.js"></script>
<script type="text/javascript" language="javascript" src="//cdn.datatables.net/buttons/1.3.1/js/buttons.html5.min.js"></script>
<script>
	jQuery(function () {
		jQuery('#list_products').DataTable({
			oLanguage: {
				sLengthMenu: "@lang('word.sLengthMenu')",
				sLoadingRecords: "@lang('word.sLoadingRecords')", 
				sSearch: "@lang('word.sSearch')",
				sZeroRecords: "@lang('word.sZeroRecords')",
				sInfoFiltered: "@lang('word.sInfoFiltered')",
				sInfoEmpty: "@lang('word.sInfoEmpty')",
				sInfo: "@lang('word.sInfo')",
				sEmptyTable: "@lang('word.sEmptyTable')",
				oPaginate: {
					sNext: "@lang('word.sNext')",
					sPrevious: "@lang('word.sPrevious')",
				}
			}, 
			responsive:true,
			processing: true,
            serverSide: true,  
            ajax: "{{ route('admin.orders.list.data') }}",
            columns: [
				{data: 'id', name: 'id'}, 
				{data: 'reference', name: 'reference'},
				{data: 'customer.username', name: 'customer.username'},
				{data: 'total_amount', name: 'total_amount'},
				{data: 'pay_method_name', name: 'pay_method_name'},
				{data: 'status_name', name: 'status_name'},
				{data: 'created_at', name: 'created_at'},
				{data: 'action', name: 'action', orderable: false, searchable: false},
				
				{data: 'address.realname', name: 'address.realname'},
				{data: 'address.phone', name: 'address.phone'},
				{data: 'address.province', name: 'address.province'},
				{data: 'address.city', name: 'address.city'},
				{data: 'address.area', name: 'address.area'},
				{data: 'address.full_address', name: 'address.full_address'},
			],
			columnDefs: [
				{"targets": [8,9,10,11,12,13],"visible": false,"searchable": false},
			],
			"aaSorting": [],
			dom: "lBfrtip",
			buttons: [{
				extend: "collection",
				text: "@lang('word.export')",
				className: "button-export",
				autoClose: !0,
				
				buttons: [
							{
						extend: "excelHtml5",
						text: "@lang('admin.export_to_excel')",
						title: "Orders",
						init: function(dt, node, config) {
							$("#filter_btns button").on('click', function() {
								var today = new Date();
								var date = today.getFullYear()+'-'+(today.getMonth()+1)+'-'+today.getDate();
								var time = today.getHours() + ":" + today.getMinutes() + ":" + today.getSeconds();
								var dateTime = date+'_'+time;
								config.title = 'Withdrawals_'+this.value.split(' ').join('_')+'_'+dateTime;
							})
						},
						exportOptions: {
							columns: [1,2,3,4,5,6,8,9,10,11,12,13],
							exportOptions: { orthogonal: 'export' },
						},
						 
					},
				]
			}]
		});
	});

</script>
@endsection