000

@extends('dashboard.layouts.app')
@section('title','Freight Payments')
@section('content')

<div class="main-content">
	<div class="main-content-inner">
		<div class="breadcrumbs ace-save-state" id="breadcrumbs">
			<ul class="breadcrumb">
				<li>
					<i class="ace-icon fa fa-home home-icon"></i>
					<a href="#">{{__('messages.Home')}}</a>
				</li>
				<li class="active">{{__('messages.FreightPayment')}}</li>
			</ul>
		</div>

<div class="page-content">
			<h3 class="header smaller lighter blue">{{__('messages.FreightPayment')}}  <div id="google_translate_element"></div></h3>
			<div class="row">
				<div class="col-xs-12">
					<form action="" method="POST" role="form">
						<div class="row">
							{{csrf_field()}}
							<div class="col-md-3">
								<div class="form-group">
									<label for="master_rake_id">{{__('messages.masterrake')}}</label>
									<select class="form-control select2" name="master_rake_id" id="master_rake_id">
										<option value="">{{__('messages.SelectMasterRake')}}</option>
										@foreach($master_rakes as $master_rake)
										<option value="{{$master_rake->id}}" {{isset($master_rake_id) && $master_rake_id==$master_rake->id ? "selected":""}}>{{$master_rake->name}}</option>
										@endforeach()
									</select>
									@if ($errors->has('master_rake_id'))
									<span class="label label-danger">{{ $errors->first('master_rake_id') }}</span>
									@endif
								</div>
							</div>

<div class="col-md-3">
								<div class="form-group">
									<label for="paid_by">Paid By</label>
									<select class="form-control select2" name="paid_by" id="paid_by">
										<option value="">Select User</option>
										@foreach($users as $user)
										<option value="{{$user->id}}" {{isset($paid_by) && $paid_by==$user->id ? "selected":""}}>{{$user->name}}</option>
										@endforeach()
									</select>
									@if ($errors->has('paid_by'))
									<span class="label label-danger">{{ $errors->first('paid_by') }}</span>
									@endif
								</div>
							</div>
							
							<div class="col-md-3">
								<div class="form-group">
									<label for="date">Date</label>
									<input type="text" class="form-control date-picker" name="date" id="" placeholder="Date" readonly="readonly" value="{{isset($date) ? $date : ''}}">
								</div>
							</div>

<div class="col-md-3">
								<div class="form-group">
									<button type="submit" class="btn btn-primary">Submit</button>
								</div>
							</div>
						</div>
					</form>
				</div>
			</div>

@if (session('success'))
					<div class="alert alert-success">
						{{ session('success') }}
					</div>
					@endif
					@if (session('error'))
					<div class="alert alert-danger">
						{{ session('error') }}
					</div>
					@endif

<div class="table-header">
						Results for Latest Generated Freight Payments
						<div class="widget-toolbar no-border">
						@if(\Auth::user()->role_id != 7)
							<a class="btn btn-xs bigger btn-danger" href="{{URL('/user/product-loading')}}">
								{{__('messages.generateNew')}}
								<i class="ace-icon fa fa-plus icon-on-right"></i>
							</a>
							@endif
						</div>

</div>

<div class="table-responsive">
						<div class="dataTables_borderWrap">
							<table id="dynamic-table" class="table table-striped table-bordered table-hover">
								<thead>
									<tr>
										<th>{{__('messages.LoadingSlip')}}#</th>
										<th>{{__('messages.Token')}}</th>
										<th>{{__('messages.ProductCompany')}}</th>
										<th>{{__('messages.Wagon')}}</th>
										<th>{{__('messages.Product')}} </th>
										<th>{{__('messages.Quantity')}}</th>
										<th>{{__('messages.Transporter')}}</th>
										<th>{{__('messages.Retailers')}}</th>
										<th>{{__('messages.PartyName')}}</th>
										<th>{{__('messages.Truck')}}</th>
										<th>Freight</th>
										<th>{{__('messages.PaymentStatus')}}</th>
										<th>{{__('messages.PaidBy')}}</th>
										<th>{{__('messages.PaidAmount')}}</th>
										<th>{{__('messages.Payment')}}<br>{{__('messages.Date')}}</th>
									</tr>
								</thead>

<tbody>
									@if(isset($product_loadings))

@php
									$total_to_pay = 0;
									$total_paid = 0;
									$total_toll_tax_paid = 0;
									@endphp

@foreach($product_loadings as $product_loading)
									<tr id="tr_{{$product_loading->id}}">

<td>{{$product_loading->id}}</td>
										<td>{{$product_loading->token_id}}</td>
										<td>{{$product_loading->product_company_name}}</td>
										<td>{{$product_loading->wagon_number}}</td>
										<td>{{ $product_loading->product_name}}</td>
										<td>{{$product_loading->quantity}}</td>
										<td>{{$product_loading->transporter_name}}</td>
										
										<td>
											@if(!is_null($product_loading->retailer_id))
											{{$product_loading->retailer_name}}			
											@endif	
										</td>
										<td>
											@if($product_loading->loading_slip_type ==1)
											{{getModelById('Dealer',$product_loading->dealer_id)->name}}
											({{getModelById('Dealer',$product_loading->dealer_id)->address1}})				
											@else
											{{getModelById('Warehouse',$product_loading->warehouse_id)->name}}				
											@endif	
										</td>
										<td>{{$product_loading->truck_number}}</td>
										<td>{{$product_loading->freight}}</td>
										<td>
											@if($product_loading->is_freight_paid == 0)
											<span class="label label-warning">Not Paid</span>
											@else
											<span class="label label-success">Paid</span>
											@endif
										</td>
										<td>
											@if($product_loading->is_freight_paid == 1)
											{{ getModelById('User',$product_loading->freight_paid_by)->name}}
											@else
											--
											@endif
										</td>
										<td>
											@if($product_loading->is_freight_paid == 1)
											{{$product_loading->freight_paid_amount}}
											@else
											--
											@endif
										</td>

<td>
											@if($product_loading->is_freight_paid == 1)
											{{date('d/m/Y',strtotime($product_loading->freight_pay_date))}}
											@else
											--
											@endif
										</td>

@php
										if($product_loading->is_freight_paid == 1){
										$total_paid = $total_paid + ($product_loading->quantity * $product_loading->freight);
										$total_toll_tax_paid = $total_toll_tax_paid + ($product_loading->toll_tax);
									}
									$total_to_pay = $total_to_pay + ($product_loading->quantity * $product_loading->freight);
									@endphp
								</tr>
								@endforeach

<tr>
									<td></td>
									<td></td>
									<td></td>
									<td></td>
									<td></td>
									<td></td>
									<td></td>
									<td></td>
									<td></td>
									<td>{{$total_toll_tax_paid}}</td>
									<td>{{$total_paid}}</td>
									<td>{{$total_paid + $total_toll_tax_paid}}/{{$total_to_pay}}</td>
									<td></td>
									<td></td>
									<td></td>

</tr>

@endif
							</tbody>
						</table>
					</div>
				</div>
			</div>
		</div>
	</div>
	
</div>
</div>

@section('script')

{{ Html::script("assets/js/jquery.dataTables.min.js")}}
{{ Html::script("assets/js/jquery.dataTables.bootstrap.min.js")}}
{{ Html::script("assets/js/dataTables.buttons.min.js")}}
{{ Html::script("assets/js/buttons.flash.min.js")}}
{{ Html::script("assets/js/buttons.html5.min.js")}}
{{ Html::script("assets/js/buttons.print.min.js")}}
{{ Html::script("assets/js/buttons.colVis.min.js")}}
{{ Html::script("assets/js/dataTables.select.min.js")}}
{{ Html::script("assets/js/ace-elements.min.js")}}
{{ Html::script("assets/js/ace.min.js")}}
{{ Html::script("assets/js/bootstrap-datepicker.min.js")}}

jQuery(function($) {

$('.date-picker').datepicker({
			autoclose: true,
			todayHighlight: true
		})
		.next().on(ace.click_event, function(){
			$(this).prev().focus();
		});

//initiate dataTables plugin
var myTable = 
$('#dynamic-table').DataTable( {
	bAutoWidth: false,
	"aaSorting": [],
} );

$.fn.dataTable.Buttons.defaults.dom.container.className = 'dt-buttons btn-overlap btn-group btn-overlap';

new $.fn.dataTable.Buttons( myTable, {
	buttons: [
	{
		"extend": "colvis",
		"text": "<i class='fa fa-search bigger-110 blue'></i> <span class='hidden'>Show/hide columns</span>",
		"className": "btn btn-white btn-primary btn-bold",
		columns: ':not(:first):not(:last)'
	},
	{
		"extend": "copy",
		"text": "<i class='fa fa-copy bigger-110 pink'></i> <span class='hidden'>Copy to clipboard</span>",
		"className": "btn btn-white btn-primary btn-bold"
	},
	{
		"extend": "csv",
		"text": "<i class='fa fa-database bigger-110 orange'></i> <span class='hidden'>Export to CSV</span>",
		"className": "btn btn-white btn-primary btn-bold"
	},
	{
		"extend": "excel",
		"text": "<i class='fa fa-file-excel-o bigger-110 green'></i> <span class='hidden'>Export to Excel</span>",
		"className": "btn btn-white btn-primary btn-bold"
	},
	{
		"extend": "pdf",
		"text": "<i class='fa fa-file-pdf-o bigger-110 red'></i> <span class='hidden'>Export to PDF</span>",
		"className": "btn btn-white btn-primary btn-bold"
	},
	{
		"extend": "print",
		"text": "<i class='fa fa-print bigger-110 grey'></i> <span class='hidden'>Print</span>",
		"className": "btn btn-white btn-primary btn-bold",
		autoPrint: true,
		message: 'IManager',
		exportOptions: {
			columns: ':visible'
		}
	}		  
	]
} );
myTable.buttons().container().appendTo( $('.tableTools-container') );

//style the message box
var defaultCopyAction = myTable.button(1).action();
myTable.button(1).action(function (e, dt, button, config) {
	defaultCopyAction(e, dt, button, config);
	$('.dt-button-info').addClass('gritter-item-wrapper gritter-info gritter-center white');
});

var defaultColvisAction = myTable.button(0).action();
myTable.button(0).action(function (e, dt, button, config) {

defaultColvisAction(e, dt, button, config);

if($('.dt-button-collection > .dropdown-menu').length == 0) {
		$('.dt-button-collection')
		.wrapInner('<ul class="dropdown-menu dropdown-light dropdown-caret dropdown-caret" />')
		.find('a').attr('href', '#').wrap("<li />")
	}
	$('.dt-button-collection').appendTo('.tableTools-container .dt-buttons')
});

})
</script>

@endsection
@endsection