000

@extends('layout.master')

@push('plugin-styles')
  
@endpush

@section('content')

<div class="row">
  <div class="col-lg-12 grid-margin">
    <div class="card">
      <div class="card-body">
        
        <div class="row">
        	
          	<div class="col-lg-2">
            	<h4 class="card-title">GRN Report</h4>
          	</div>
        	<div class="col-lg-2">
        		<small>Warehouse</small>
              <select class="form-control mr" id="warehouse" onchange="get_ware_house(this)">
                <option value=""> -- Select Warehouse --</option>
				<option value="all" {{$current_warehouse == "all" ? 'selected':''}}>All</option>
			
			@foreach($warehouses as $warehouse)
			
			<option value="{{$warehouse->ware_house}}" {{$current_warehouse == $warehouse->ware_house ? 'selected':''}}>{{$warehouse->ware_house}}</option>
			@endforeach
              </select>
            </div>
            <div class="col-lg-2">
            	<small>From Date</small>
               <input  class="form-control mr" type="date" name="fromdate" value="{{$fromdate}}" id="fromdate">
            </div>
            <div class="col-lg-2">
            	<small>To Date</small>
               <input  class="form-control mr" type="date" name="todate" value="{{$todate}}" id="todate">
            </div>
            <div class="col-lg-2">
            	<small>Action Type</small>
              	 <select class="form-control mr" name="action_type" id="action_type">
                	<option value="search">Search</option>
                	<option value="export">Export In Excel</option>
            	</select>
            </div>
            <div class="col-lg-1">
              	<a href="#" style="margin-top: 25px;" class="btn brn-sm btn-info" onclick="submit_now()">Submit</a>
            </div>
          </div>
        
      </div>
    </div>
  </div>
  	<div class="col-lg-12 grid-margin">
	    <div class="card">
	      <div class="card-body">
	      		<div class="table-responsive">
		          <table class="table table-striped">
		            <thead>
		              <tr>
		                <th>GRN No</th>
		                <th>GRN Date</th>
		                <th>Ref DocNo</th>
		                <th>Item Code</th>
		                <th>Item Description</th>
		                <th>Supplier Name</th>
										<th>Supplier Invoice Number</th>
		                <th>Supplier Invoice Date</th>
		                <th>Delivery Qty</th>
		                <th>Rate</th>
		                <th>Amount<br>Excluding Tax</th>
		                <th>Tax Amount</th>
		                <th>Fright Amount</th>
		                <th>Sup Code</th>
		                <th>Ware House </th>		                
		                <th>Transporter Details</th>
		                <th>E Way Bill</th>		              
		              </tr>
		            </thead>
		            <tbody>									
		             @foreach($grns as $grn)	
								 
									@php
								 	  $supplier_name = '';
								 	  $supplier_code = '';										
							  	 	if(array_key_exists($grn->reference_number, $all_suppliers)) {
							  		 	$supplier_name = $all_suppliers[$grn->reference_number]['vendor_name'];
							  		 	$supplier_code = $all_suppliers[$grn->reference_number]['vendor_code'];
							  	 	}									 
							 	  @endphp
		             <tr>
		             	<td>{{$grn->grn_no}}</td>
		             	<td>{{$grn->grn_date}}</td>
		             	<td>{{$grn->reference_number}}</td>
		             	<td>{{$grn->item_code}}</td>
		             	<td>{{$grn->item_discription}}</td>
		             	<td>{{ $supplier_name }}</td>
									<td>{{$grn->invoice_number}}</td>
		             	<td>{{$grn->invoice_date}}</td>
		             	<td>{{$grn->quantity}}</td>
		             	<td>{{$grn->rate}}</td>
		             	<td>{{$grn->amount}}</td>
		             	<td>{{$grn->tax_amount}}</td>										
									@if($grn_no != $grn->grn_no)
										<td>{{$grn->freightCharges}}</td>
									@else 
										<td></td>
									@endif		             	
									@php
										$grn_no = $grn->grn_no;
									@endphp
									<td>{{ $supplier_code }}</td>
		             	<td>{{$grn->warehouse}}</td>
		             	<td>{{ $grn->transporter_details }}</td>
		             	<td>{{ $grn->eway_bill_no }}</td>		             
		             </tr>
		             @endforeach
		            </tbody>
		          </table>
		        </div>
	      </div>
	    </div>
   	</div>
</div>

@endsection

@push('plugin-scripts')
  {!! Html::script('/assets/plugins/chartjs/chart.min.js') !!}
  {!! Html::script('/assets/plugins/jquery-sparkline/jquery.sparkline.min.js') !!}
@endpush

@push('custom-scripts')
  {!! Html::script('/assets/js/dashboard.js') !!}
  <script type="text/javascript">
  function submit_now() {
  	 var warehouse = $('#warehouse').val();
  	 var fromdate = $('#fromdate').val();
  	 var todate = $('#todate').val();
  	 var action_type = $('#action_type').val();

if(warehouse == ""){
  	 	swal('Please Select the warehouse', {  icon: "error", });
  	 }else{
  	 	var url = window.location.origin+"/admin/mrn-reports?warehouse="+warehouse+"&fromdate="+fromdate+"&todate="+todate+"&action_type="+action_type;
  	 	window.location.href= url;
  	 }
  }
  </script>
@endpush