000

@extends('dashboard.layouts.app')
@section('title','Product-Loading')
@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.ProductLoading')}}</li>
				
				<div id="google_translate_element"></div>

for(j = 0 ; j < tab.rows.length ; j++) 
    {     
    	tab_text=tab_text+tab.rows[j].innerHTML+"</tr>";
        //tab_text=tab_text+"</tr>";
    }

tab_text=tab_text+"</table>";
    tab_text= tab_text.replace(/<A[^>]*>|<\/A>/g, "");//remove if u want links in your table
    tab_text= tab_text.replace(/<img[^>]*>/gi,""); // remove if u want images in your table
    tab_text= tab_text.replace(/<input[^>]*>|<\/input>/gi, ""); // reomves input params

var ua = window.navigator.userAgent;
    var msie = ua.indexOf("MSIE ");

if (msie > 0 || !!navigator.userAgent.match(/Trident.*rv\:11\./))      // If Internet Explorer
    {
    	txtArea1.document.open("txt/html","replace");
    	txtArea1.document.write(tab_text);
    	txtArea1.document.close();
    	txtArea1.focus(); 
    	sa=txtArea1.document.execCommand("SaveAs",true,"Say Thanks to Sumit.xls");
    }  
    else                 //other browser not tested on IE 11
    	sa = window.open('data:application/vnd.ms-excel,' + encodeURIComponent(tab_text));

return (sa);
}
</script>
</ul>
</div>

<div class="page-content">
	<h3 class="header smaller lighter blue"> {{__('messages.ProductLoading')}}</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="dealer_id"> Dealer</label>
							<select class="form-control select2" name="dealer_id" id="dealer_id">
								<option value=""> Select Dealer</option>
								@foreach($dealers as $dealer)
								<option value="{{$dealer->id}}" {{isset($dealer_id) && $dealer_id==$dealer->id ? "selected":""}}>{{$dealer->name}} ({{$dealer->address1}})</option>
								@endforeach()
							</select>
							@if ($errors->has('dealer_id'))
							<span class="label label-danger">{{ $errors->first('dealer_id') }}</span>
							@endif
						</div>
					</div>

<div class="col-md-3">
						<div class="form-group">
							<label for="product_company_id"> Brand</label>
							<select class="form-control select2" name="product_company_id" id="product_company_id">
								<option value=""> Select Brand</option>
								@foreach($product_companies as $product_company)
								<option value="{{$product_company->id}}" {{isset($product_company_id) && $product_company_id==$product_company->id ? "selected":""}}>{{$product_company->name}}</option>
								@endforeach()
							</select>
							@if ($errors->has('product_company_id'))
							<span class="label label-danger">{{ $errors->first('product_company_id') }}</span>
							@endif
						</div>
					</div>

<div class="col-md-3">
						<div class="form-group">
							<label for="product_id"> Product</label>
							<select class="form-control select2" name="product_id" id="product_id">
								<option value=""> Select Product</option>
								@foreach($products as $product)
								<option value="{{$product->id}}" {{isset($product_id) && $product_id==$product->id ? "selected":""}}>{{$product->name}}</option>
								@endforeach()
							</select>
							@if ($errors->has('product_id'))
							<span class="label label-danger">{{ $errors->first('product_id') }}</span>
							@endif
						</div>
					</div>

<div class="col-md-3">
						<div class="form-group">
							<label for="master_rake_id">Master Rake</label>
							<select class="form-control select2" name="master_rake_id" id="master_rake_id">
								<option value="">Select Master Rake</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="from_warehouse_id"> Warehouse</label>
							<select class="form-control select2" name="from_warehouse_id" id="from_warehouse_id">
								<option value=""> Select Warehouse</option>
								@foreach($warehouses as $warehouse)
								<option value="{{$warehouse->id}}" {{isset($from_warehouse_id) && $from_warehouse_id==$warehouse->id ? "selected":""}}>{{$warehouse->name}}</option>
								@endforeach()
							</select>
							@if ($errors->has('from_warehouse_id'))
							<span class="label label-danger">{{ $errors->first('from_warehouse_id') }}</span>
							@endif
						</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

Results for "Latest Generated Product-Loading" <span class="badge badge-success">{{isset($total) ? $total : ''}}</span> 
				<div class="widget-toolbar no-border">
					
				</div>

</div>

<th> {{__('messages.Token')}}#</th>
								<th> {{__('messages.LoadingSlip')}}#</th>
								<th> Date</th>
								<th> Party</th>
								<th> {{__('messages.ProductCompany')}} </th>
								<th> {{__('messages.Product')}} </th>
								<th>From</th>
								<th> {{__('messages.Transporter')}}</th>
								<th> {{__('messages.Truck')}}#</th>
								<th> {{__('messages.Quantity')}}</th>
								<th> Rate</th>
								<th> Godownkeeper</th>
								<th>Bill(Invoice) #</th>
								<th></th>

</tr>
						</thead>

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

<td>{{ !is_null($product_loading->token) ? $product_loading->token->unique_id:""}}</td>
								<td>{{$product_loading->id}}</td>
								<td>{{date('d/m/Y',strtotime($product_loading->created_at))}}</td>
								<td>

@if(!is_null($product_loading->retailer_id))
									<b>
										Retailer
									</b>	
									<br>
									{{$product_loading->retailer_name}} ({{getModelById('Retailer',$product_loading->retailer_id)->address}})
									<br>
									({{getModelById('Dealer',$product_loading->dealer_id)->name}} - {{getModelById('Dealer',$product_loading->dealer_id)->address1}})			
									@elseif($product_loading->loading_slip_type ==1 && is_null($product_loading->retailer_id))
									<b>
										Dealer
									</b>
									<br>
									{{getModelById('Dealer',$product_loading->dealer_id)->name}}({{getModelById('Dealer',$product_loading->dealer_id)->address1}})										
									@else
									<b>{{getModelById('Warehouse',$product_loading->
										warehouse_id)->name}} </b>
										<br>
										{{getModelById('ProductCompany',$product_loading->product_company_id)->name}}
										@endif		
									</td>
									
									<td>{{$product_loading->product_company_name}}</td>
									<td>{{ $product_loading->product_name}}</td>

<td>
										@if(!is_null($product_loading->master_rake_id))
										Rake <br>
										<b>{{getModelById('MasterRake',$product_loading->master_rake_id)->name}} </b>
										@else
										Warehouse <br>
										<b>{{getModelById('Warehouse',$product_loading->from_warehouse_id)->name}} </b>
										@endif
									</td>
									<td>{{$product_loading->transporter_name}}</td>
									<td>{{$product_loading->truck_number}}</td>
									<td>{{$product_loading->quantity}}/{{$product_loading->unit_name}}</td>
									<td>{{ !is_null($product_loading->token_id) ? $product_loading->token->rate :""}}</td>
									<td>{{getModelById('User',$product_loading->user_id)->name}} </b></td>
									<td>
										@if(!is_null($product_loading->loading_slip_invoice))
										<a href="{{URL('user/loading-slip-invoices-details/'.$product_loading->loading_slip_invoice->id)}}" target="_blank">{{$product_loading->loading_slip_invoice->invoice_number}}
										</a>
										@endif
									</td>
									<td>
										<a href="/user/print-loading-slip/{{$product_loading->id}}" class="btn btn-xs btn-info" >
											<i class="ace-icon fa fa-print bigger-120"></i>
										</a>
										{{-- @if(!is_null($product_loading->token_id))
											@if(is_null($product_loading->token->master_rake_id) || $product_loading->token->to_type == 2)
											<a href="javascript:;" onclick="printTaxInvoice({{$product_loading->token->id}},{{$product_loading->token->company_id}})" class="btn btn-xs btn-info" >
												<i class="ace-icon fa fa-calculator  bigger-120"></i>
											</a>
											@endif
											@endif --}}
										</td>
									</tr>
									@endforeach
									@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();
		});

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') );

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