@extends('layouts/contentLayoutMaster')

@section('title', 'Management Customer POs')

@section('vendor-style')
  {{-- Page Css files --}}
  <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/customer-themes.css') }}">
@endsection

@section('content')

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

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

<!-- Striped rows start -->
<div class="row customerThemes customerPOsList">
    <div class="col-12">
        <div class="card">
            <div class="card-header">
                <h4 class="card-title">Customer POs List</h4>
            </div>

            <div class="card-body">

                <form class="form" method="GET" action="{{route('customer-pos.index')}}" enctype="multipart/form-data">
                    <div class="row">
                        <div class="col-md-2 col-12">
                            <div class="mb-1">
                                <label class="form-label" for="search">Search</label>
                                <input type="text" id="search" class="form-control" placeholder="Customer PO Number" name="search" value="{{ old("search", request()->input("search")) }}"/>
                            </div>
                        </div>
                        <div class="col-md-2 col-12">
                            <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 col-12">
                            <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 col-12">
                            <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 col-12">
                            <div class="mb-1">
                                <label class="form-label" for="our_quotation_id">Our Quotation Number</label>
                                @php
                                    $our_quotations = \App\Models\OurQuotation::orderBy('quotation_number', 'asc')->get();
                                    if($our_quotations->count()){
                                @endphp

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

                                @php
                                    }
                                @endphp
                            </div>
                        </div>
                        <div class="col-md-auto col-12">
                            <div class="mb-1">
                                <label class="form-label" for="status">Status</label>
                                @php
                                    $statuses = ['No Action', 'Semi Under Process', 'Under Process', 'In Shipping', 'Shipped', 'Received', 'Invoiced', 'Cancelled', 'Hold'];
                                    $options = request()->input("status") ? request()->input("status") : ['No Action', 'Semi Under Process', 'Under Process', 'In Shipping', 'Shipped', 'Received', 'Hold'];

                                    if(!empty($statuses)){
                                @endphp

                                <select class="select2 form-select" id="status" name="status[]" multiple>
                                    @foreach($statuses as $status)
                                        <option value="{{ $status }}" @if( in_array($status, $options) ) selected @endif>{{ $status }}</option>
                                    @endforeach
                                </select>

                                @php
                                    }
                                @endphp
                            </div>
                        </div>
                        <div class="col-md-auto align-self-center pt9">
                            <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-auto align-self-center pt9 ms-auto">
                            @can('Order - CustomerPOs - Add')
                            <a class="btn btnCustomStyle" href="{{route('customer-pos.create')}}" role="button" target="">Add New Customer PO</a>
                            @endcan

                            <a class="btn excelBtn" href="{{ route('customer-pos.export.all', $_REQUEST) }}" role="button" onclick="window.location=this.href">
                                Export Excel <i class="fa fa-file-excel pl4"></i>
                            </a>
                        </div>
                    </div>

                </form>

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

                <p align="center" id="top-list">
                    @if($orders->total())
                        Records
                        <b>{{ ( $orders->currentPage() - 1 ) * $orders->perPage() + 1 }}</b>
                        to
                        <b>{{ ( $orders->currentPage() - 1 ) * $orders->perPage() + $orders->count() }}</b>
                        from
                        <b>{{ $orders->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>CPO#</th>
                            <th>Date</th>
                            <th>Customer</th>
                            <th>Vendor POs</th>
                            <th>Our Quotations</th>
                            <th>Total Price</th>
                            <th>File</th>
                            <th>Invoices</th>
                            <th>EDD</th>
                            <th>Status</th>
                            <th>Action</th>
                        </tr>
                        </thead>
                        <tbody>
                        @foreach( $orders as $order )
                        <tr>
                            <td>{{ $order->customer_po_number }}</td>
                            <td>{{ $order->date }}</td>
                            <td>{{ $order->customer->name }}</td>
                            <td>
                                @php
                                    $vendor_pos = \App\Models\VendorPOCustomerPO::where('customer_po_id', '=', $order->id)->orderBy('vendor_po_id', 'asc')->get();
                                @endphp

                                @foreach( $vendor_pos as $vendor_po)
                                    <a href='{{ route('vendor-pos.show', $vendor_po->vendor_po_id) }}' target='_blank' title='{{ $vendor_po->vendorPO->our_po_number }}'>
                                        {{ $vendor_po->vendorPO->vendor->name }}
                                    </a><br>
                                @endforeach
                            </td>
                            <td>
                                @php
                                    $our_quotations = \App\Models\CustomerPOOurQuotation::where('customer_po_id', '=', $order->id)->orderBy('our_quotation_id', 'asc')->get();
                                @endphp

                                @foreach( $our_quotations as $our_quotation)
                                    <a href='{{ route('our-quotations.show', $our_quotation->our_quotation_id) }}' target='_blank'>
                                        {{ $our_quotation->ourQuotation->quotation_number }}
                                    </a><br>
                                @endforeach
                            </td>
                            <td>
                                @php
                                    $customer_parts = \App\Models\CustomerPOPart::where('customer_po_id', '=', $order->id)->selectRaw('sum(quantity*unit_price) as total')->first();
                                @endphp

                                {{ number_format( $customer_parts->total, 2) }}
                            </td>
                            <td>
                                <span>
                                    @php
                                        if( is_file(public_path('storage/' . $order->file_path)) ){
                                            echo "<a href='" . asset("storage/$order->file_path") . "' target='_blank'>";
                                    @endphp
                                    <img class='round' src="{{ asset('storage/images/customer-pos/file.png') }}" alt='file' height='20' width='20'>
                                    @php
                                        echo "</a>";
                                    }
                                    @endphp
                                </span>
                            </td>
                            <td>
                                @foreach( $order->invoices as $invoice )
                                    @can('Order - Invoices - List')
                                    @php
                                        if( is_file(public_path('storage/' . $invoice->file_path)) ){
                                            echo "<a href='" . asset("storage/$invoice->file_path") . "' target='_blank'>";
                                        }
                                    @endphp
                                    @endcan

                                    #{{ $invoice->invoice_number }}

                                    @can('Order - Invoices - List')
                                    @php
                                        if( is_file(public_path('storage/' . $invoice->file_path)) ){
                                            echo "</a>";
                                        }
                                    @endphp
                                    @endcan
                                @endforeach
                            </td>
                            <td>{{ $order->edd }}</td>
                            <td>{{ $order->status }}</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 - Add')
                                    <a class="dropdown-item" href="{{ route('invoices.create', ['customer_po_id' => $order->id]) }}" target="_blank">
                                        <i data-feather="printer" class="me-50"></i>
                                        <span>Add Invoice</span>
                                    </a>
                                    @endcan
                                    @can('Order - CustomerPOs - Parts')
                                    <a class="dropdown-item" href="{{ route('customer-pos.show', ['customer_po' => $order->id]) }}" target="">
                                        <i data-feather="layers" class="me-50"></i>
                                        <span>Parts</span>
                                    </a>
                                    @endcan
                                    @can('Order - CustomerPOs - Edit')
                                    <a class="dropdown-item" href="{{ route('customer-pos.our-quotation', ['customer_po' => $order->id]) }}" target="">
                                        <i data-feather="phone-forwarded" class="me-50"></i>
                                        <span>Our Quotations</span>
                                    </a>
                                    @endcan
                                    @can('Order - CustomerPOs - Parts')
                                    <a class="dropdown-item" href="{{ route('customer-pos.export', ['customer_po' => $order->id]) }}" onclick="window.location=this.href">
                                        <i data-feather="share" class="me-50"></i>
                                        <span>Export Excel</span>
                                    </a>
                                    @endcan
                                    @can('exportPfi', $order)
                                    <a class="dropdown-item" href="{{ route('customer-pos.export.pfi', ['customer_po' => $order->id]) }}" target="_blank">
                                        <i data-feather="file-text" class="me-50"></i>
                                        <span>Export PFI Neba Altia</span>
                                    </a>
                                    @endcan
                                    @can('Order - CustomerPOs - Edit')
                                    <a class="dropdown-item" href="{{ route('customer-pos.edit', ['customer_po' => $order->id]) }}" target="">
                                      <i data-feather="edit-2" class="me-50"></i>
                                      <span>Edit</span>
                                    </a>
                                    @endcan
                                    @can('Order - CustomerPOs - Remove')
                                    <a class="dropdown-item" href="{{ route('customer-pos.destroy', ['customer_po' => $order->id]) }}" onclick="event.preventDefault(); document.getElementById('destroy-form-{{ $order->id }}').submit();">
                                      <i data-feather="trash" class="me-50"></i>
                                      <span>Remove</span>
                                    </a>
                                    <form method="POST" id="destroy-form-{{ $order->id }}" action="{{ route('customer-pos.destroy', ['customer_po' => $order->id]) }}">
                                        @csrf
                                        @method('delete')
                                    </form>
                                    @endcan
                                  </div>
                                </span>
                            </td>
                        </tr>
                        @endforeach
                        </tbody>
                    </table>
                </div>

                {{ $orders->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