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-3">
            	<h4 class="card-title">Consumption Report MR-OMC</h4>
          	</div>
        	<div class="col-lg-2">
        		<small>Warehouse</small>
            <select class="form-control mr" id="warehouse">
                <option value=""> -- Select Warehouse --</option>                
                @foreach($warehouses as $warehouse)
                <option value="{{$warehouse}}" {{$current_warehouse == $warehouse ? 'selected':''}}>{{$warehouse}}</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>Circle Name</th>
		                <th>Customer Name</th>
		                <th>MR/OMC No.</th>
		                <th>MR/OMC Date</th>
		                <th>ATS Invoice No.</th>
		                <th>ATS Invoice Date</th>
		                <th>ATS Invoice Basic Value</th>
		                <th>Site ID</th>
		                <th>Site Name</th>
		                <th>Customer PO No.</th>
		                <th>Customer PO Date</th>
		                <th>Item Code</th>
		                <th>Description</th>
		                <th>Per Pcs Rate</th>		                
		                <th>Type</th>
		                <th>OMC/MR Qty.</th>		                
		                <th>Total Value</th>
		                <th>Spare Type</th>
		                <th>Complain Closure Date</th>
		                <th>Customer Open PO Status</th>
		                <th>Open PO Amount</th>
		                <th>Invoice Value</th>
                        <th>Remark</th>
		              </tr>
		            </thead>
		            <tbody>		           
                    @foreach($all_omc_mr as $key=>$omc_mr) 
                      <tr>
                        <td>{{ $omc_mr->warehouse }}</td>
                        <td>{{ $omc_mr->customer_name }}</td>
                        <td>{{ $omc_mr->mr_no }}</td>
                        <td>{{ $omc_mr->created_at }}</td>
                        <td>{{ $omc_mr->invoice_no }}</td>
                        <td>{{ $omc_mr->invoice_date }}</td>
                        <td>{{ $omc_mr->invoice_basic_value }}</td>
                        <td>{{ $omc_mr->site_id }}</td>
                        <td>{{ $omc_mr->site_name }}</td>
                        <td>{{ $omc_mr->po_no }}</td>
                        <td>{{ $omc_mr->cutomer_po_date }}</td>
                        <td>{{ $omc_mr->spare_code }}</td>
                        <td>{{ $omc_mr->description }}</td>
                        <td>{{ $omc_mr->rate }}</td>
                        <td>{{ $omc_mr->omc_type }}</td>
                        <td>{{ $omc_mr->fresh_qty + $omc_mr->repaired_qty }}</td>
                        <td>{{ $omc_mr->fresh_qty*$omc_mr->rate + $omc_mr->repaired_qty*$omc_mr->rate }}</td>
                        <td>
                            @if($omc_mr->fresh_qty > 0)
                               Fresh Spare
                            @elseif($omc_mr->repaired_qty > 0)
                               Repaired Spare
                            @else
                               N/A
                            @endif
                        </td> 
                        <td>{{ $omc_mr->complaint_closure_date }}</td>
                        <td>{{ $omc_mr->cust_open_po_status }}</td>
                        <td>{{ $omc_mr->open_po_amount }}</td>
                        <td>{{ $omc_mr->invoice_value }}</td>
                        <td>{{ $omc_mr->status }}</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+"/circle-store/consumption-report-mr-omc?warehouse="+warehouse+"&fromdate="+fromdate+"&todate="+todate+"&action_type="+action_type;
  	 	window.location.href= url;
  	}
  }
  </script>
@endpush