@extends('layouts.app')

@section('title')
    {{__('Purchase 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-invoice-dollar"></i>
          {{__("Purchases 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">{{__('Purchase 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">{{__('Purchase 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.purchase')}}">
            <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 -->

                      <!-- suppliers -->
                      <div class="col-lg-3 col-md-3 col-sm-3 col-xs-3">
                          <div class="form-group">
                              <label>{{__('Supplier')}}</label>
                              <select class="form-control" name="supplier_id[]" id="supplier" multiple>
                                  @if(isset($suppliers))
                                    @foreach($suppliers as $supplier)
                                      <option value="{{$supplier['id']}}" selected>{{$supplier['name']}}</option>
                                    @endforeach
                                  @endif
                              </select>
                          </div>
                      </div>
                      <!-- \suppliers -->
                      <!-- suppliers -->
                      <div class="col-lg-3 col-md-3 col-sm-3 col-xs-3">
                          <div class="form-group">
                              <label>{{__('Products')}}</label>
                              <select class="form-control" name="product_id[]" id="product_id" multiple>
                                  @if(isset($products))
                                    @foreach($products as $product)
                                      <option value="{{$product['id']}}" selected>{{$product['name']}}</option>
                                    @endforeach
                                  @endif
                              </select>
                          </div>
                      </div>
                      <!-- \suppliers -->
                  </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="printable">

      <!-- Report summary -->
      <div class="card card-primary">
        <div class="card-header">
          <h5 class="card-title">
            {{__('Summary')}}
          </h5>
        </div>
        <div class="card-body">
          <div class="row">
            <div class="col-lg-2 col-sm-12 col-xs-12 mt-4 mb-4 custom-info-box">
              <div class="row">
                <div class="col-3 col-sm-4 col-xs-4">
                  <span class="icon">
                    <span class="text-center">
                      <i class="fa fa-money-bill-wave"></i>
                    </span>
                  </span>
                </div>
                <div class="col-7 col-sm-8 col-xs-8">
                  <h4 class="m-0">
                    {{formated_price($total)}}
                  </h4>
                  <span>
                    {{__('Total Cost')}}
                  </span>
                </div>
              </div>
            </div>
            {{-- <div class="col-lg-2 col-sm-12 col-xs-12 mt-4 mb-4 custom-success-box">
              <div class="row">
                <div class="col-3 col-sm-4 col-xs-4">
                  <span class="icon">
                    <span class="text-center">
                      <i class="fa fa-money-bill-wave"></i>
                    </span>
                  </span>
                </div>
                <div class="col-7 col-sm-8 col-xs-8">
                  <h4 class="m-0">
                    {{formated_price($paid)}}
                  </h4>
                  <span>
                    {{__('Paid')}}
                  </span>
                </div>
              </div>
            </div>
            <div class="col-lg-2 col-sm-12 col-xs-12 mt-4 mb-4 custom-danger-box">
              <div class="row">
                <div class="col-3 col-sm-4 col-xs-4">
                  <span class="icon">
                    <span class="text-center">
                      <i class="fa fa-money-bill-wave"></i>
                    </span>
                  </span>
                </div>
                <div class="col-7 col-sm-8 col-xs-8">
                  <h4 class="m-0">
                    {{formated_price($due)}}
                  </h4>
                  <span>
                    {{__('Due')}}
                  </span>
                </div>
              </div>
            </div> --}}
            
          </div>
        </div>
      </div>
      <!-- \Report summary -->
      
      <!-- Report Details -->
      <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-payments-tab" data-toggle="pill" href="#custom-tabs-one-payments" role="tab" aria-controls="custom-tabs-one-payments" aria-selected="false">{{__('Payments')}}</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 width="10px">#</th>
                        <th>{{__('Laboratory')}}</th>
                        <th>{{__('Request No.')}}</th>
                        <th>{{__('Supplier')}}</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>{{__('Requested By')}}</th>
                        <th>{{__('Approved By')}}</th>
                        <th>{{__('Completed By')}}</th>
                      </tr>
                    </thead>
                    <tbody>
                      @foreach($purchases as $key => $purchase)
                      <tr>
                        <td class="text-center">{{$key+1}}</td>
                        {{-- <td>{{$purchase['supplier']['name']}}</td> --}}
                        <td>{{$purchase['purchase_product']['branch']['name']}}</td>
                        <td>{{$purchase['purchase_product']['purchase']['request_no']}}</td>
                        <td>{{$purchase['supplier']['name']}}</td>
                        <td>{{$purchase['purchase_product']['product']['code']}}</td>
                        <td>
                          {{isset($purchase['purchase_product']['product']['product_type']['name']) ? $purchase['purchase_product']['product']['product_type']['name'] : ''}}
                        </td>
                        <td>
                          {{$purchase['purchase_product']['product']['name']}}
                           {{-- {{isset($purchase['purchase_product']['product']['product_category']['name']) ? $purchase['purchase_product']['product']['product_category']['name'] : ''}}  --}}
                           {{$purchase['purchase_product']['product']['description']}}
                        </td>
                        <td>
                           {{isset($purchase['purchase_product']['product']['product_unit']['name']) ? $purchase['purchase_product']['product']['product_unit']['name'] : ''}}
                        </td>
                        {{-- <td>{{$purchase['purchase_product']['product']['product_type']['name']}}</td>
                        <td>{{$purchase['purchase_product']['product']['product_category']['name']}} {{$purchase['purchase_product']['product']['name']}} {{$purchase['purchase_product']['product']['description']}}</td>
                        <td>{{$purchase['purchase_product']['product']['product_unit']['name']}}</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>{{isset($purchase->purchase_product->purchase->requestor_user->name) ? $purchase->purchase_product->purchase->requestor_user->name : ''}} {{isset($purchase->purchase_product->purchase->requestor_user->last_name) ? $purchase->purchase_product->purchase->requestor_user->last_name : ''}}</td>
                        <td>{{isset($purchase->purchase_product->purchase->approver_user->name) ? $purchase->purchase_product->purchase->approver_user->name : ''}} {{isset($purchase->purchase_product->purchase->approver_user->last_name) ? $purchase->purchase_product->purchase->approver_user->last_name : ''}}</td>
                        <td>{{isset($purchase->purchase_product->purchase->completed_user->name) ? $purchase->purchase_product->purchase->completed_user->name : ''}} {{isset($purchase->purchase_product->purchase->completed_user->last_name) ? $purchase->purchase_product->purchase->completed_user->last_name : ''}}</td>
                      </tr>
                      @endforeach
                    </tbody>
                  </table>
                </div>
              </div>
            </div>
            {{-- <div class="tab-pane fade" id="custom-tabs-one-payments" role="tabpanel" aria-labelledby="custom-tabs-one-payments-tab">
              <div class="row">
                <div class="col-lg-12 table-responsive">
                  <table class="table table-striped table-bordered datatable">
                    <thead>
                      <tr>
                        <th width="10px" class="text-center">#</th>
                        <th width="10px" class="text-center">#{{__('Purchase')}}</th>
                        <th class="text-center">{{__('Supplier')}}</th>
                        <th class="text-center">{{__('Branch')}}</th>
                        <th>{{__('Date')}}</th>
                        <th>{{__('Amount')}}</th>
                        <th>{{__('Payment method')}}</th>
                      </tr>
                    </thead>
                    <tbody>
                      @foreach($payments as $key => $payment)
                      <tr>
                        <td class="text-center">{{$key+1}}</td>
                        <td class="text-center">{{$payment['purchase_id']}}</td>
                        <td class="text-center">{{$payment['purchase']['supplier']['name']}}</td>
                        <td class="text-center">{{$payment['purchase']['branch']['name']}}</td>
                        <td>{{date('Y-m-d',strtotime($payment['date']))}}</td>
                        <td>{{formated_price($payment['amount'])}}</td>
                        <td>{{$payment['payment_method']['name']}}</td>
                      </tr>
                      @endforeach
                    </tbody>
                  </table>
                </div>
              </div>
            </div> --}}
          </div>
        </div>
      </div>
      <!-- \Report Details -->
    </div>
    @endif
  </div>
  <!-- /.card-body -->

  <!-- card-footer -->
  {{-- @if(request()->has('date'))
    <div class="card-footer">
      <a href="{{request()->fullUrl()}}&pdf=true" class="btn btn-danger" target="_blank">
        <i class="fas fa-file-pdf"></i> {{__('PDF')}}
      </a>
    </div>
  @endif --}}
  @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
  <!-- /.card-footer -->
</div>

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