@extends('layouts.app')

@section('title')
    {{__('Inventory Report')}}
@endsection

@section('breadcrumb')
<div class="content-header">
  <div class="container-fluid">
    <div class="row mb-2">
      <div class="col-sm-6">
        <h1 class="m-0 text-dark">
        <i class="fas fa-file-import"></i>
          {{__('Inventories Report')}}
        </h1>
      </div><!-- /.col -->
      <div class="col-sm-6">
        <ol class="breadcrumb float-sm-right">
          <li class="breadcrumb-item"><a href="{{route('admin.index')}}">{{__('Home')}}</a></li>
          <li class="breadcrumb-item active">{{__('Inventory report')}}</li>
        </ol>
      </div><!-- /.col -->
    </div><!-- /.row -->
  </div><!-- /.container-fluid -->
</div>
@endsection

@section('content')
<div class="card card-primary">
  <!-- card-header -->
  <div class="card-header">
    <!-- <h3 class="card-title">{{__('Inventory report')}}</h3> -->
  </div>
  <!-- /.card-header -->
  <!-- card-body -->
  <div class="card-body">

    <!-- Filtering Form -->
    <div id="accordion">
      <div class="card card-info">
          <a data-toggle="collapse" data-parent="#accordion" href="#collapseOne" class="btn btn-primary collapsed"
              aria-expanded="false">
              <i class="fas fa-filter"></i> {{__('Filters')}}
          </a>
          <form method="get" action="{{route('admin.reports.inventory')}}">
            <div id="collapseOne" class="panel-collapse in collapse show">
                <div class="card-body">
                    <div class="row">
                        <!-- date range -->
                        <div class="col-lg-3 col-md-3 col-sm-3 col-xs-3">
                            <label>{{__('Date range')}}:</label>
                            <div class="input-group">
                                <div class="input-group-prepend">
                                    <span class="input-group-text">
                                        <i class="far fa-calendar-alt"></i>
                                    </span>
                                </div>
                                
                                <input type="text" name="date" id="date" autocomplete="off" class="form-control float-right datepickerrange"
                                    @if(request()->has('date')) value="{{request()->get('date')}}" @else value="{{ date('F d, Y', strtotime('-1month')) . ' - ' . date('F d, Y') }}" @endif id="date" required>
                                <div class="input-group-append">
                                  <button class="btn btn-outline-secondary clear_date" type="button">Clear</button>
                                </div>
                            </div>
                        </div>
                        <!-- \date range -->

                        <!-- branches/department -->
                        <div class="col-lg-3 col-md-3 col-sm-3 col-xs-3">
                            <div class="form-group">
                                <label>{{__('Laboratory')}}</label>
                                <select class="form-control" name="branch_id[]" id="branch" multiple>
                                    @if(isset($branches))
                                      @foreach($branches as $branch)
                                        <option value="{{$branch['id']}}" selected>{{$branch['name']}}</option>
                                      @endforeach
                                    @endif
                                </select>
                            </div>
                        </div>
                        <!-- \branches /department-->
                    </div>
                </div>
                <div class="card-footer">
                  <button type="submit" class="btn btn-primary">
                    <i class="fas fa-cog"></i>
                    {{__('Generate')}}
                  </button>
                </div>
            </div>
          </form>
      </div>
    </div>
    <!-- Filtering Form -->

    @if(request()->has('date'))
    <div class="card card-primary card-tabs">
      <div class="card-header p-0">
        <ul class="nav nav-tabs" id="custom-tabs-one-tab" role="tablist">
          <li class="nav-item">
            <a class="nav-link active" id="custom-tabs-one-purchases-tab" data-toggle="pill" href="#custom-tabs-one-purchases" role="tab" aria-controls="custom-tabs-one-purchases" aria-selected="false">{{__('Purchases')}}</a>
          </li>
          <li class="nav-item">
            <a class="nav-link" id="custom-tabs-one-adjustments-tab" data-toggle="pill" href="#custom-tabs-one-adjustments" role="tab" aria-controls="custom-tabs-one-adjustments" aria-selected="false">{{__('Adjustments')}}</a>
          </li>
          <li class="nav-item">
            <a class="nav-link" id="custom-tabs-one-transfers-tab" data-toggle="pill" href="#custom-tabs-one-transfers" role="tab" aria-controls="custom-tabs-one-transfers" aria-selected="false">{{__('Transfers')}}</a>
          </li>
          <li class="nav-item">
            <a class="nav-link" id="custom-tabs-one-disposal-tab" data-toggle="pill" href="#custom-tabs-one-disposal" role="tab" aria-controls="custom-tabs-one-disposal" aria-selected="false">{{__('Disposals')}}</a>
          </li>
          {{-- <li class="nav-item">
            <a class="nav-link" id="custom-tabs-one-consumptions-tab" data-toggle="pill" href="#custom-tabs-one-consumptions" role="tab" aria-controls="custom-tabs-one-consumptions" aria-selected="false">{{__('Consumptions')}}</a>
          </li> --}}
          <li class="nav-item">
            <a class="nav-link" id="custom-tabs-one-summary-tab" data-toggle="pill" href="#custom-tabs-one-summary" role="tab" aria-controls="custom-tabs-one-summary" aria-selected="false">{{__('Summary')}}</a>
          </li>
        </ul>
      </div>
      <div class="card-body">
        <div class="tab-content" id="custom-tabs-one-tabContent">
          <div class="tab-pane fade active show" id="custom-tabs-one-purchases" role="tabpanel" aria-labelledby="custom-tabs-one-purchases-tab">
            <div class="row">
              <div class="col-lg-12 table-responsive">
                <table class="table table-striped table-bordered datatable">
                  <thead>
                    <tr>
                      <th>{{__('#')}}</th>
                      <th>{{__('Laboratory')}}</th>
                      <th>{{__('Product Code')}}</th>
                      <th>{{__('Product Type')}}</th>
                      <th>{{__('Particulars')}}</th>
                      <th>{{__('Product Unit')}}</th>
                      <th>{{__('Delivery Receipt No.')}}</th>
                      <th>{{__('Sales Invoice')}}</th>
                      {{-- <th>{{__('PO No.')}}</th> --}}
                      <th>{{__('Lot No./Batch No.')}}</th>
                      <th>{{__('Expiry Date')}}</th>
                      <th>{{__('Quantity')}}</th>
                      <th>{{__('Cost')}}</th>
                      <th>{{__('Total Cost')}}</th>
                      {{-- <th>{{__('Quantity')}}</th>
                      <th>{{__('Total price')}}</th> --}}
                    </tr>
                  </thead>
                  <tbody>
                    @foreach($purchase_products as $key => $purchase)
                      <tr>
                        <td>
                          {{$key+1}}
                        </td>
                        <td>{{$purchase['purchase_product']['purchase']['branch']['name']}}</td>
                        <td>{{$purchase['purchase_product']['product']['code']}}</td>
                        <td>
                          @if(isset($purchase['purchase_product']['product']['product_type']['name']))
                          {{$purchase['purchase_product']['product']['product_type']['name']}}
                          @endif
                        </td>
                        <td>
                          {{-- {{$purchase['purchase_product']['product']['product_category']['name']}}  --}}
                          {{$purchase['purchase_product']['product']['name']}} 
                          {{$purchase['purchase_product']['product']['description']}}</td>
                        <td>
                          @if(isset($purchase['purchase_product']['product']['product_unit']['name']))
                          {{$purchase['purchase_product']['product']['product_unit']['name']}}
                          @endif
                        </td>
                        <td>{{$purchase['delivery_receipt_no']}}</td>
                        <td>{{$purchase['sales_invoice']}}</td>
                        {{-- <td>
                          {{$purchase['purchase_order_no']}}
                        </td> --}}
                        <td>
                          {{$purchase['batch_no']}}
                        </td>
                        <td>
                          {{$purchase['expiry_date']}}
                        </td>
                        <td>{{$purchase['quantity']}}</td>
                        <td>{{$purchase['cost']}}</td>
                        <td>{{$purchase['quantity'] * $purchase['cost']}}</td>
                        {{-- <td>
                          {{$purchase['purchase']['branch']['name']}}
                        </td> --}}
                        {{-- <td>{{$purchase['purchase_product']['branch']['name']}}</td> --}}

                        {{-- <td> --}}
                          {{-- {{$purchase['purchase']['supplier']['name']}} --}}
                        {{-- </td> --}}
                        {{-- <td>
                          {{$purchase['product']['name']}}
                        </td> --}}
                        {{-- <td>{{$purchase['purchase_product']['product']['name']}}</td> --}}
                        {{-- <td>
                          {{formated_price($purchase['price'])}}
                        </td>
                        <td>
                          {{$purchase['quantity']}}
                        </td>
                        <td>
                          {{formated_price($purchase['total_price'])}}  
                        </td>
                        </tr> --}}
                      </tr>
                    @endforeach
                  </tbody>  
                </table>
              </div>
            </div>
          </div>
          <div class="tab-pane fade" id="custom-tabs-one-adjustments" role="tabpanel" aria-labelledby="custom-tabs-one-adjustments-tab">
            <div class="row">
              <div class="col-lg-12 table-responsive">
                <table class="table table-striped table-bordered datatable">
                  <thead>
                    <tr>
                      <th>{{__('#')}}</th>
                      <th>{{__('Laboratory')}}</th>
                      <th>{{__('Particulars')}}</th>
                      <th>{{__('Transaction type')}}</th>
                      <th>{{__('Unit')}}</th>
                      <th>{{__('Type')}}</th>
                      <th>{{__('Code')}}</th>
                      <th>{{__('Quantity')}}</th>
                    </tr>
                  </thead>
                  <tbody>
                    @foreach($adjustment_products as $key => $adjustment)
                      <tr>
                        <td>
                          {{$key+1}}
                        </td>
                        <td>{{$adjustment->adjustment->branch->name}}</td>
                        <td>
                          {{-- {{$adjustment['adjustment']['branch']['name']}} --}}
                         {{-- {{$adjustment['product']['product_category']['name']}}  --}}
                         {{$adjustment['product']['name']}}
                          {{$adjustment['product']['description']}}

                        </td>
                        <td>
                          {{-- {{$adjustment['type']}} --}}
                          @if($adjustment['type']==1)
                              In
                            {{-- <span class="badge badge-success">
                              {{__('In stock')}}
                            </span> --}}
                          @else 
                          Out
                            {{-- <span class="badge badge-danger">
                              {{__('Out stock')}}
                            </span> --}}
                          @endif
                        </td>
                        <td>
                          @if(isset($adjustment['product']['product_unit']['name']))
                          {{$adjustment['product']['product_unit']['name']}}
                          @endif
                        </td>
                        <td>
                          @if(isset($adjustment['product']['product_type']['name']))
                          {{$adjustment['product']['product_type']['name']}}
                          @endif
                        </td>
                        <td>{{$adjustment['product']['code']}}</td>
                        <td>
                          {{$adjustment['quantity']}}
                        </td>
                      </tr>
                    @endforeach
                  </tbody>
                </table>
              </div>
            </div>
          </div>
          <div class="tab-pane fade" id="custom-tabs-one-transfers" role="tabpanel" aria-labelledby="custom-tabs-one-transfers-tab">
            <div class="row">
              <div class="col-lg-12 table-responsive">
                <table class="table table-striped table-bordered datatable">
                  <thead>
                    <tr>
                      <th>{{__('#')}}</th>
                      {{-- <th>{{__('From branch')}}</th> --}}
                      <th>{{__('Designated Laboratory')}}</th>
                      <th>{{__('Paticulars')}}</th>
                      <th>{{__('Unit')}}</th>
                      <th>{{__('Type')}}</th>
                      <th>{{__('Code')}}</th>
                      <th>{{__('Quantity')}}</th>
                    </tr>
                  </thead>
                  <tbody>
                    @foreach($transfer_products as $key => $transfer)
                      <tr>
                        <td>
                        {{$key+1}}
                        </td>
                        {{-- <td>
                          {{$transfer['from_branch']['name']}}
                        </td> --}}
                        <td>
                          {{$transfer['to_branch']['name']}}
                        </td>
                        <td>
                          {{-- {{$transfer['product']['product_category']['name']}}  --}}
                          {{$transfer['product']['name']}} 
                          {{$transfer['product']['description']}}
                        </td>
                        <td>
                          @if(isset($transfer['product']['product_unit']['name']))
                          {{$transfer['product']['product_unit']['name']}}
                          @endif
                        </td>
                        <td>
                          @if($transfer['product']['product_type']['name'])
                          {{$transfer['product']['product_type']['name']}}
                          @endif
                        </td>
                        <td>{{$transfer['product']['code']}}</td>
                        <td>
                          {{$transfer['quantity']}}
                        </td>
                      </tr>
                    @endforeach
                  </tbody>
                </table>
              </div>
            </div>
          </div>
          {{-- <div class="tab-pane fade" id="custom-tabs-one-consumptions" role="tabpanel" aria-labelledby="custom-tabs-one-consumptions-tab">
            <div class="row">
              <div class="col-lg-12 table-responsive">
                <table class="table table-striped table-bordered datatable">
                  <thead>
                    <tr>
                      <th>{{__('#')}}</th>
                      <th>{{__('Branch')}}</th>
                      <th>{{__('Test')}}</th>
                      <th>{{__('Product')}}</th>
                      <th>{{__('Quantity')}}</th>
                    </tr>
                  </thead>
                  <tbody>
                    @foreach($consumption_products as $key => $consumption)
                      <tr>
                        <td>
                          {{$key+1}}
                        </td>
                        <td>
                          {{$consumption['branch']['name']}}
                        </td>
                        <td> --}}
                          {{-- {{$consumption['testable']['name']}} --}}
                        {{-- </td>
                        <td>
                          {{$consumption['product']['name']}}
                        </td>
                        <td>
                          {{$consumption['quantity']}}
                        </td>
                      </tr>
                    @endforeach
                  </tbody>
                </table>
              </div> --}}
            {{-- </div>
          </div> --}}
          <style>
            .table_summary td,
            .table_summary th,
            .table_summary {
                border: 1px solid !important;
            }

          </style>
          <div class="tab-pane fade" id="custom-tabs-one-summary" role="tabpanel" aria-labelledby="custom-tabs-one-summary-tab">
            <div class="row">
              <div class="col-lg-12 table-responsive">
                <table class="table table-striped table-bordered table_summary">
                  <thead>
                    <tr>
                      <th rowspan="2">{{__('#')}}</th>
                      <th rowspan="2">{{__('Product Type')}}</th>
                      <th rowspan="2">{{__('Product Code')}}</th>
                      <th rowspan="2">{{__('Paticulars')}}</th>
                      {{-- <th rowspan="2">{{__('Description')}}</th> --}}
                      <th colspan="2" class="text-center">{{__('Beginning Balance')}}</th>
                      <th colspan="5" class="text-center">{{__('Delivery')}}</th>
                      <th colspan="2" class="text-center">{{__('Total')}}</th>
                      <th colspan="2" class="text-center">{{__('Consumption')}}</th>
                      <th colspan="2" class="text-center">{{__('End Balance')}}</th>
                      <th  rowspan="2" class="text-center">{{__('Total Cost (Used)')}}</th>
                      <th  rowspan="2" class="text-center">{{__('Supplies On Hand')}}</th>
                    </tr>
                    <tr>
                      <th class="text-center">{{__('Qty')}}</th>
                      <th class="text-center">{{__('Cost/unit')}}</th>
                      <th class="text-center">{{__('Supplier')}}</th>
                      <th class="text-center">{{__('SI No.')}}</th>
                      <th class="text-center">{{__('DR No.')}}</th>
                      <th class="text-center">{{__('Qty Delivered')}}</th>
                      <th class="text-center">{{__('Cost/unit')}}</th>
                      <th class="text-center">{{__('No. of Units')}}</th>
                      <th class="text-center">{{__('Cost/unit')}}</th>
                      <th class="text-center">{{__('No. of Units')}}</th>
                      <th class="text-center">{{__('Cost/unit')}}</th>
                      <th class="text-center">{{__('No. of Units')}}</th>
                      <th class="text-center">{{__('Cost/unit')}}</th>
                    </tr>
                  </thead>
                  <tbody>
                    @foreach($product_summary as $key => $product)
                    <tr>
                    <td>{{$key+1}}</td>
                    {{-- <td>{{$product->product->product_type->name}}</td>
                    <td>{{$product->product->code}}</td>
                    <td>{{$product->product->product_category->name}}{{ $product->name}}</td>
                    <td>{{ $product->product->description}}</td> --}}
                    <td>{{$product['product_type']}}</td>
                    <td>{{$product['code']}}</td>
                    <td>{{$product['particulars']}}</td>
                    {{-- <td>{{$product['description']}}</td> --}}
                    <td>{{$product['beginning_qty']}}</td>
                    <td width="8%">
                      @foreach($product['beginning_cost_list'] as $bcl)
                      {{$bcl}}<br>
                      @endforeach
                    </td>
                    <td>{{$product['supplier']}}</td>
                    <td>{{$product['si_no']}}</td>
                    <td>{{$product['dr_no']}}</td>
                    <td>{{$product['total_in']}}</td>
                    <td>{{$product['delivery_cost']}}</td>
                    <td>{{$product['total_qty']}}</td>
                    {{-- <td>{{$product['total_out_cost']}}</td> --}}
                    <td width="8%">
                      @foreach($product['total_out_cost'] as $bcl)
                      {{$bcl}}<br>
                      @endforeach
                    </td>
                    <td>{{$product['consumption']}}</td>
                    {{-- <td>{{$product['consumption_cost']}}</td> --}}
                    <td width="8%">
                      @foreach($product['consumption_cost'] as $bcl)
                      {{$bcl}}<br>
                      @endforeach
                    </td>
                    <td>{{$product['end_balance']}}</td>
                    {{-- <td>{{$product['end_balance_cost']}}</td> --}}
                    <td width="8%">
                      @foreach($product['end_balance_cost'] as $bcl)
                      {{$bcl}}<br>
                      @endforeach
                    </td>
                    <td>{{number_format((float)$product['total_cost'], 2, '.', '')}}</td>
                    <td>{{number_format((float)$product['supplies'], 2, '.', '')}}</td>
                    {{-- <td>{{$product['consumption'] * $product['consumption_cost']}}</td> --}}
                    {{-- <td></td> --}}
                    </tr>
                    @endforeach
                    {{-- @foreach($consumption_products as $key => $consumption)
                      <tr>
                        <td>
                          {{$key+1}}
                        </td>
                        <td>
                          {{$consumption['branch']['name']}}
                        </td>
                        <td>
                          {{$consumption['testable']['name']}}
                        </td>
                        <td>
                          {{$consumption['product']['name']}}
                        </td>
                        <td>
                          {{$consumption['quantity']}}
                        </td>
                      </tr>
                    @endforeach --}}
                  </tbody>
                </table>
              </div>
            </div>
          </div>

          <div class="tab-pane fade" id="custom-tabs-one-disposal" role="tabpanel" aria-labelledby="custom-tabs-one-disposal-tab">
            <div class="row">
              <div class="col-lg-12 table-responsive">
                <table class="table table-striped table-bordered datatable">
                  <thead>
                    <tr>
                      <th>{{__('#')}}</th>
                      <th>{{__('Laboratory')}}</th>
                      <th>{{__('Paticulars')}}</th>
                      <th>{{__('Unit')}}</th>
                      <th>{{__('Type')}}</th>
                      <th>{{__('Code')}}</th>
                      <th>{{__('Quantity')}}</th>
                      <th>{{__('Requested By')}}</th>
                      <th>{{__('Approved By')}}</th>
                    </tr>
                  </thead>
                  <tbody>
                    @foreach($disposal as $key => $dispose)
                    <tr>
                      <td>{{$key+1}}</td>
                      <td>{{$dispose->disposal_product->branch->name}}</td>
                      <td>
                        {{-- {{$dispose['product']['product_category']['name']}} --}}
                        {{$dispose['product']['name']}} 
                        {{$dispose['product']['description']}}
                      </td>
                      <td>
                        @if(isset($dispose['product']['product_unit']['name']))
                        {{$dispose['product']['product_unit']['name']}}
                        @endif
                      </td>
                      <td>
                        {{$dispose['product']['code']}}

                      </td>
                      <td>
                        @if(isset($dispose['product']['product_type']['name']))
                        {{$dispose['product']['product_type']['name']}}
                        @endif
                      </td>
                      <td>{{$dispose->quantity_deducted}}</td>
                      <td>{{isset($dispose->disposal_product->requestor_user->name) ?$dispose->disposal_product->requestor_user->name:'' }} {{isset($dispose->disposal_product->requestor_user->last_name) ? $dispose->disposal_product->requestor_user->last_name : ''}}</td>
                      <td>{{isset($dispose->disposal_product->issuer_user->name)? $dispose->disposal_product->issuer_user->name: ''}} {{isset($dispose->disposal_product->issuer_user->last_name) ? $dispose->disposal_product->issuer_user->last_name : ''}}</td>
                    </tr>
                    @endforeach
                  </tbody>
                </table>
              </div>
            </div>
           
          </div>

        </div>
      </div>
      <!-- /.card -->
    </div>
    @endif

   
  </div>
  <!-- /.card-body -->
  @if(request()->has('date'))
  <div class="card-footer">
  <a href="{{request()->fullUrl()}}&excel=true" class="btn btn-success">
      <i class="fas fa-file-excel mr-1"></i> {{__('Excel')}}
  </a>
  </div>
@endif

</div>

@endsection
@section('scripts')
    {{-- <script src="{{url('plugins/daterangepicker/daterangepicker.js')}}"></script> --}}
    <script src="{{url('js/admin/inventory_report.js')}}"></script>
@endsection