@extends('layouts.app')

@section('title')
    {{__('Supplier 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-contract"></i>
          {{__("Suppliers 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">{{__('Supplier 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">{{__('Supplier 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.supplier')}}">
            <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>
                              {{-- <span>{{ $input_date }}</span> --}}
                              <input type="text" name="date" id="date" autocomplete="off" class="form-control float-right datepickerrange"
                              @if(isset($input_date)) value="{{$input_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 -->

                      <!-- 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" required>
                                  @if(isset($supplier))
                                      <option value="{{$supplier['id']}}" selected>{{$supplier['name']}}</option>
                                  @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">{{__('Equipment')}}</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>{{__('Product Code')}}</th>
                        <th>{{__('Product Type')}}</th>
                        <th>{{__('Paticulars')}}</th>
                        <th>{{__('Product Unit')}}</th>
                        <th>{{__('DR No.')}}</th>
                        <th>{{__('Delivery Date')}}</th>
                        <th>{{__('SI No.')}}</th>
                        <th>{{__('PO No.')}}</th>
                        <th>{{__('PO Date')}}</th>
                        <th>{{__('Received By')}}</th>
                        <th>{{__('Lot No./Batch No.')}}</th>
                        <th>{{__('Expiry Date')}}</th>
                        <th>{{__('Quantity')}}</th>
                        <th>{{__('Cost')}}</th>
                        <th>{{__('Total Cost')}}</th>
                      </tr>
                    </thead>
                    <tbody>
                      @foreach($purchases as $key => $purchase)
                      <tr>
                        <td>{{$key+1}}</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->name}}
                            {{-- {{$purchase->purchase_product->product->product_category->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->delivery_date}}</td>
                        <td>{{$purchase->sales_invoice}}</td>
                        <td>{{$purchase->purchase_product->po_no}}</td>
                        <td>{{$purchase->purchase_product->po_date}}</td>
                        <td>
                          @if(isset($purchase->purchase_product->purchase->completed_user->name))
                          {{$purchase->purchase_product->purchase->completed_user->name}} {{$purchase->purchase_product->purchase->completed_user->last_name}}</td>
                          @endif
                        <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['id']}}
                        </td>
                        <td>
                          {{$purchase['date']}}
                        </td>
                        <td>{{formated_price($purchase['total'])}}</td>
                        <td>{{formated_price($purchase['paid'])}}</td>
                        <td>{{formated_price($purchase['due'])}}</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-resposive">
                  <table class="table table-striped table-bordered datatable">
                    <thead>
                      <tr>
                        <th>#</th>
                        <th>Name</th>
                        <th>{{__('Category')}}</th>
                        <th>{{__('Equipment / Property No')}}</th>
                        <th>{{__('Serial Number')}}</th>
                        <th>{{__('Status')}}</th>
                      </tr>
                    </thead>
                    <tbody>
                      @foreach($equipment as $key => $eq)
                      <tr>
                        <td>{{$key+1}}</td>
                        <td>{{$eq->name}}</td>
                        <td>{{$eq->equipment_category->category_name}}</td>
                        <td>{{$eq->property_no}}</td>
                        <td>{{$eq->serial_no}}</td>
                        <td>@if($eq->status == 1)
                          Good Condition
                      @elseif($eq->status == 2)
                           For Repair
                      
                      @elseif($eq->status == 3)
                           For Condemn
                      
                      @elseif($eq->status == 4)
                           Condemned
                      
                      @elseif($eq->status == 5)
                           Not in use
                      
                      @elseif($eq->status == 6)
                           Transferred
                      
                      @elseif($eq->status == 7)
                           Donated
                      @elseif($eq->status == 8)
                           Public Auction
                      
                      @elseif($eq->status == 9)
                           'Negotiated/Private Sale
                      
                      @elseif($eq->status == 10)
                          Barter
                      @endif</td>
                        {{-- <td>{{$payment['id']}}</td>
                        <td>{{$payment['purchase_id']}}</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/supplier_report.js')}}"></script>
@endsection