@extends('layouts/contentLayoutMaster')

@section('title', 'Management Invoices')

@section('vendor-style')
  {{-- Page Css files --}}
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.4/css/all.min.css" integrity="sha512-..." crossorigin="anonymous" />
  <link rel="stylesheet" href="{{ asset(mix('vendors/css/forms/select/select2.min.css')) }}">
  <link rel="stylesheet" href="{{ asset(mix('vendors/css/pickers/flatpickr/flatpickr.min.css')) }}">
  <link rel="stylesheet" href="{{ asset(mix('vendors/css/tables/datatable/dataTables.bootstrap5.min.css')) }}">
  <link rel="stylesheet" href="{{ asset(mix('vendors/css/tables/datatable/responsive.bootstrap5.min.css')) }}">
  <link rel="stylesheet" href="{{ asset(mix('vendors/css/tables/datatable/buttons.bootstrap5.min.css')) }}">
  <link rel="stylesheet" href="{{ asset(mix('vendors/css/tables/datatable/rowGroup.bootstrap5.min.css')) }}">
  <link rel="stylesheet" href="{{ asset('tablesorter/dist/css/jquery-ui.css') }}">
  <link rel="stylesheet" href="{{ asset('tablesorter/dist/css/theme.jui.min.css') }}">
@endsection

@section('page-style')
  {{-- Page Css files --}}
  <link rel="stylesheet" href="{{ asset(mix('css/base/plugins/forms/form-validation.css')) }}">
  <link rel="stylesheet" href="{{ asset(mix('css/base/plugins/forms/pickers/form-flat-pickr.css')) }}">
  <link rel="stylesheet" href="{{ asset('vendors/css/ui/gray-themes.css') }}">
@endsection

@section('content')

<!-- list start -->
<section class="app-user-list">

@include('content.partial.form-message')

<!-- Striped rows start -->
<div class="row financialTheme invoicesList">
    <div class="col-12">
        <div class="card">
            <div class="card-header">
                <h4 class="card-title">Invoices List</h4>
            </div>

            <div class="card-body">

                <form class="form" method="GET" action="{{route('invoices.index')}}" enctype="multipart/form-data">
                    <div class="row">
                        <div class="col-md-2">
                            <div class="mb-1">
                                <label class="form-label" for="date">Date</label>
                                <input type="text" id="date" autocomplete="off" class="form-control" placeholder="{{ date('Y-m-d') }}" name="date" value="{{ old("date", request()->input("date")) }}"/>
                            </div>
                        </div>
                        <div class="col-md-2">
                            <div class="mb-1">
                                <label class="form-label" for="search">Search</label>
                                <input type="text" id="search" class="form-control" placeholder="Invoice Number" name="search" value="{{ old("search", request()->input("search")) }}"/>
                            </div>
                        </div>
                        <div class="col-md-2">
                            <div class="mb-1">
                                <label class="form-label" for="customer_id">Customer</label>
                                @php
                                    $customers = \App\Models\Customer::orderBy('name', 'asc')->get();
                                    if($customers->count()){
                                @endphp

                                <select class="select2 form-select" id="customer_id" name="customer_id">
                                    <option value="" selected="selected">select</option>
                                    @foreach($customers as $customer)
                                        <option value="{{ $customer->id }}" @if( old("customer_id", request()->input("customer_id")) == $customer->id ) selected @endif>{{ $customer->name }}</option>
                                    @endforeach
                                </select>

                                @php
                                    }
                                @endphp
                            </div>
                        </div>
                        <div class="col-md-2">
                            <div class="mb-1">
                                <label class="form-label" for="inventory_id">Part Number</label>
                                @php
                                    $inventories = \App\Models\Inventory::orderBy('part_number', 'asc')->get();
                                    if($inventories->count()){
                                @endphp

                                <select class="select2 form-select" id="inventory_id" name="inventory_id">
                                    <option value="" selected="selected">select</option>
                                    @foreach($inventories as $inventory)
                                        <option value="{{ $inventory->id }}" @if( old("inventory_id", request()->input("inventory_id")) == $inventory->id ) selected @endif>{{ $inventory->part_number }}</option>
                                    @endforeach
                                </select>

                                @php
                                    }
                                @endphp
                            </div>
                        </div>
                        <div class="col-md-2">
                            <div class="mb-1">
                                <label class="form-label" for="our_quotation_id">Customer PO Number</label>
                                @php
                                    $customer_pos = \App\Models\CustomerPO::orderBy('customer_po_number', 'asc')->get();
                                    if($customer_pos->count()){
                                @endphp

                                <select class="select2 form-select" id="customer_po_id" name="customer_po_id">
                                    <option value="" selected="selected">select</option>
                                    @foreach($customer_pos as $customer_po)
                                        <option value="{{ $customer_po->id }}" @if( old("customer_po_id", request()->input("customer_po_id")) == $customer_po->id ) selected @endif>{{ $customer_po->customer_po_number }}</option>
                                    @endforeach
                                </select>

                                @php
                                    }
                                @endphp
                            </div>
                        </div>
                        <div class="col-md-6 pt9 align-self-center min-width220">
                            <button type="submit" class="btn btn-primary me-1" onclick="this.form.submit()">Search</button>
                            <a class="btn btn-outline-secondary" href="{{url()->current()}}" role="button">Reset</a>
                        </div>
                        <div class="col-md-6 end-form-btn align-self-center justify-content-end mt-1 row">
                            <div class="col-auto pe-0 mb-1 mb-sm-0">
                                @can('Order - Invoices - Add')
                                <a class="btn btn-primary" href="{{route('invoices.create')}}" role="button" target="">Add New Invoice</a>
                                @endcan
                            </div>
                            <div class="col-auto pe-0">
                                <a class="btn excelBtn" href="{{ route('invoices.export.all', $_REQUEST) }}" role="button" onclick="window.location=this.href">
                                    Export Excel <i class="fa fa-file-excel pl4"></i>
                                </a>
                            </div>

                        </div>
                    </div>
                    <p style="height: 20px;"></p>


                </form>

                <p style="height: 20px;"></p>

                <p align="center" id="top-list">
                    @if($invoices->total())
                        Records
                        <b>{{ ( $invoices->currentPage() - 1 ) * $invoices->perPage() + 1 }}</b>
                        to
                        <b>{{ ( $invoices->currentPage() - 1 ) * $invoices->perPage() + $invoices->count() }}</b>
                        from
                        <b>{{ $invoices->total() }}</b>
                        Records
                    @else
                        No Record
                    @endif
                </p>

                <div class="table-responsive">
                    <table id="tablesorter" class="table" cellpadding="5" cellspacing="0" style="border-collapse: collapse;" border="0" bordercolor="#666666">
                        <thead>
                        <tr>
                            <th>Invoice#</th>
                            <th>Date</th>
                            <th>Customer</th>
                            <th>Customer PO</th>
                            <th>AWB</th>
                            <th>Sub Total</th>
                            <th>Total Price</th>
                            <th>File</th>
                            <th>Action</th>
                        </tr>
                        </thead>
                        <tbody>
                        @foreach( $invoices as $invoice )
                            @php
                                $invoice_parts = \App\Models\InvoicePart::where('invoice_id', '=', $invoice->id)->selectRaw('sum(quantity*unit_price) as total')->first();
                            @endphp
                        <tr>
                            <td>{{ $invoice->invoice_number }}</td>
                            <td>{{ $invoice->date }}</td>
                            <td>{{ $invoice->customerPO->customer->name }}</td>
                            <td>{{ $invoice->customerPO->customer_po_number }}</td>
                            <td>{{ $invoice->awb }}</td>
                            <td>{{ number_format( $invoice_parts->total, 2) }}</td>
                            <td>{{ number_format( $invoice_parts->total + $invoice->shipping_cost + $invoice->clearance + $invoice->sales_tax, 2) }}</td>
                            <td>
                                <span>
                                    @php
                                        if( is_file(public_path('storage/' . $invoice->file_path)) ){
                                            echo "<a href='" . asset("storage/$invoice->file_path") . "' target='_blank'>";
                                    @endphp
                                    <img src="{{ asset('storage/images/invoices/pdf.png') }}" alt='file' height='20' width='20'>
                                    @php
                                        echo "</a>";
                                    }
                                    @endphp
                                </span>
                            </td>
                            <td class="actionTD">
                                <span class="dropdown">
                                  <button type="button" class="btn btn-sm dropdown-toggle hide-arrow py-0" data-bs-toggle="dropdown">
                                    <i data-feather="more-vertical"></i>
                                  </button>
                                  <div class="dropdown-menu dropdown-menu-end">
                                    @can('Order - Invoices - Parts')
                                    <a class="dropdown-item" href="{{ route('invoices.export', ['invoice' => $invoice->id]) }}" target="_blank">
                                        <i data-feather="share" class="me-50"></i>
                                        <span>Export PDF</span>
                                    </a>
                                    @endcan
                                    @can('Order - Invoices - Parts')
                                    <a class="dropdown-item" href="{{ route('invoices.delivery', ['invoice' => $invoice->id]) }}" target="_blank">
                                        <i data-feather="share" class="me-50"></i>
                                        <span>Delivery Note</span>
                                    </a>
                                    @endcan
                                    @can('Order - Invoices - Parts')
                                    <a class="dropdown-item" href="{{ route('invoices.packing', ['invoice' => $invoice->id]) }}" target="_blank">
                                        <i data-feather="share" class="me-50"></i>
                                        <span>Packing List</span>
                                    </a>
                                    @endcan
                                    @can('Order - Invoices - Parts')
                                    <a class="dropdown-item" href="{{ route('invoices.export.parts', ['invoice' => $invoice->id]) }}" onclick="window.location=this.href">
                                        <i data-feather="share" class="me-50"></i>
                                        <span>Export Excel</span>
                                    </a>
                                    @endcan
                                    @can('Order - Invoices - Parts')
                                    <a class="dropdown-item" href="{{ route('invoices.show', ['invoice' => $invoice->id]) }}" target="">
                                        <i data-feather="layers" class="me-50"></i>
                                        <span>Parts</span>
                                    </a>
                                    @endcan
                                    @can('Order - Invoices - Edit')
                                    <a class="dropdown-item" href="{{ route('invoices.edit', ['invoice' => $invoice->id]) }}" target="">
                                      <i data-feather="edit-2" class="me-50"></i>
                                      <span>Edit</span>
                                    </a>
                                    @endcan
                                    @can('Order - Invoices - Remove')
                                    <a class="dropdown-item" href="{{ route('invoices.destroy', ['invoice' => $invoice->id]) }}" onclick="event.preventDefault(); document.getElementById('destroy-form-{{ $invoice->id }}').submit();">
                                      <i data-feather="trash" class="me-50"></i>
                                      <span>Remove</span>
                                    </a>
                                    <form method="POST" id="destroy-form-{{ $invoice->id }}" action="{{ route('invoices.destroy', ['invoice' => $invoice->id]) }}">
                                        @csrf
                                        @method('delete')
                                    </form>
                                    @endcan
                                  </div>
                                </span>
                            </td>
                        </tr>
                        @endforeach
                        </tbody>
                    </table>
                </div>

                {{ $invoices->appends($_REQUEST)->fragment('top-list')->links('vendor.pagination.bootstrap-5') }}

            </div>
        </div>
    </div>
</div>
<!-- Striped rows end -->
</section>
<!-- list ends -->
@endsection

@section('vendor-script')
  {{-- Vendor js files --}}
  <script src="{{ asset(mix('vendors/js/forms/select/select2.full.min.js')) }}"></script>
  <script src="{{ asset(mix('vendors/js/tables/datatable/jquery.dataTables.min.js')) }}"></script>
  <script src="{{ asset(mix('vendors/js/tables/datatable/dataTables.bootstrap5.min.js')) }}"></script>
  <script src="{{ asset(mix('vendors/js/tables/datatable/dataTables.responsive.min.js')) }}"></script>
  <script src="{{ asset(mix('vendors/js/tables/datatable/responsive.bootstrap5.js')) }}"></script>
  <script src="{{ asset(mix('vendors/js/tables/datatable/datatables.buttons.min.js')) }}"></script>
  <script src="{{ asset(mix('vendors/js/tables/datatable/jszip.min.js')) }}"></script>
  <script src="{{ asset(mix('vendors/js/tables/datatable/pdfmake.min.js')) }}"></script>
  <script src="{{ asset(mix('vendors/js/tables/datatable/vfs_fonts.js')) }}"></script>
  <script src="{{ asset(mix('vendors/js/tables/datatable/buttons.html5.min.js')) }}"></script>
  <script src="{{ asset(mix('vendors/js/tables/datatable/buttons.print.min.js')) }}"></script>
  <script src="{{ asset(mix('vendors/js/tables/datatable/dataTables.rowGroup.min.js')) }}"></script>
  <script src="{{ asset(mix('vendors/js/forms/validation/jquery.validate.min.js')) }}"></script>
  <script src="{{ asset(mix('vendors/js/forms/cleave/cleave.min.js')) }}"></script>
  <script src="{{ asset(mix('vendors/js/forms/cleave/addons/cleave-phone.us.js')) }}"></script>
  <script src="{{ asset(mix('vendors/js/pickers/flatpickr/flatpickr.min.js')) }}"></script>
  <script src="{{ asset('tablesorter/dist/js/jquery.tablesorter.min.js') }}"></script>
  <script src="{{ asset('tablesorter/dist/js/jquery.tablesorter.widgets.min.js') }}"></script>
@endsection

@section('page-script')
  <script src="{{ asset(mix('js/scripts/forms/form-select2.js')) }}"></script>
  <script type="text/javascript">
      $(function() {
          // Extend the themes to change any of the default class names
          $.extend($.tablesorter.themes.jui, {
              // change default jQuery uitheme icons - find the full list of icons at
              // http://jqueryui.com/themeroller/ (hover over them for their name)
              table        : 'ui-widget ui-widget-content ui-corner-all', // table classes
              caption      : 'ui-widget-content',
              // header class names
              header       : 'ui-widget-header ui-corner-all ui-state-default', // header classes
              sortNone     : '',
              sortAsc      : '',
              sortDesc     : '',
              active       : 'ui-state-active', // applied when column is sorted
              hover        : 'ui-state-hover',  // hover class
              // icon class names
              icons        : 'ui-icon', // icon class added to the <i> in the header
              iconSortNone : 'ui-icon-carat-2-n-s ui-icon-caret-2-n-s', // class name added to icon when column is not sorted
              iconSortAsc  : 'ui-icon-carat-1-n ui-icon-caret-1-n', // class name added to icon when column has ascending sort
              iconSortDesc : 'ui-icon-carat-1-s ui-icon-caret-1-s', // class name added to icon when column has descending sort
              filterRow    : '',
              footerRow    : '',
              footerCells  : '',
              even         : 'ui-widget-content', // even row zebra striping
              odd          : 'ui-state-default'   // odd row zebra striping
          });

          // call the tablesorter plugin and apply the ui theme widget
          $("#tablesorter").tablesorter({
              theme : 'jui', // theme "jui" and "bootstrap" override the uitheme widget option in v2.7+
              headerTemplate : '{content} {icon}', // needed to add icon for jui theme
              // widget code now contained in the jquery.tablesorter.widgets.js file
              widgets : ['uitheme', 'filter', 'zebra'],
              widgetOptions : {
                  // zebra striping class names - the uitheme widget adds the class names defined in
                  // $.tablesorter.themes to the zebra widget class names
                  zebra   : ["even", "odd"],

                  // set the uitheme widget to use the jQuery UI theme class names
                  // ** this is now optional, and will be overridden if the theme name exists in $.tablesorter.themes **
                  // uitheme : 'jui'
              }
          });
      });
  </script>

  <script>
      $('#date').flatpickr();
  </script>
@endsection