@extends('layouts/contentLayoutMaster')

@section('title', 'Management Our Quotations')

@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')) }}">
@endsection

@section('content')

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

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

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

            <div class="card-body">

                <form class="form" method="GET" action="{{route('our-quotations.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 RFQ Number, Quotation Number, Validity, Payment Terms, Delivery Terms" 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_rfq_id">Customer RFQ</label>
                                @php
                                    $customer_rfqs = \App\Models\CustomerRfq::orderBy('customer_rfq_number', 'asc')->get();
                                    if($customer_rfqs->count()){
                                @endphp

                                <select class="select2 form-select" id="customer_rfq_id" name="customer_rfq_id">
                                    <option value="" selected="selected">select</option>
                                    @foreach($customer_rfqs as $customer_rfq)
                                        <option value="{{ $customer_rfq->id }}" @if( old("customer_rfq_id", request()->input("customer_rfq_id")) == $customer_rfq->id ) selected @endif>{{ $customer_rfq->customer_rfq_number }}</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="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="status">Status</label>
                                @php
                                    $statuses = ['Sent', 'UnSent'];
                                    $options = request()->input("status") ? request()->input("status") : [];

                                    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-6 pt9 align-self-center">
                            <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 pt9 align-self-center ms-auto text-end">
                            @can('Business - OurQuotations - Add')
                                <a class="btn btn-primary" href="{{route('our-quotations.create')}}" role="button" target="">Add New Our Quotation</a>
                            @endcan
                        </div>
                    </div>
                </form>

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

                <p align="center" id="top-list">
                    @if($quotations->total())
                        Records
                        <b>{{ ( $quotations->currentPage() - 1 ) * $quotations->perPage() + 1 }}</b>
                        to
                        <b>{{ ( $quotations->currentPage() - 1 ) * $quotations->perPage() + $quotations->count() }}</b>
                        from
                        <b>{{ $quotations->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>Quotation Number</th>
                            <th>Date</th>
                            <th>Customer</th>
                            <th>Customer RFQ Number</th>
                            <th>Total Price</th>
                            <th>File</th>
                            <th>Status</th>
                            <th>Action</th>
                        </tr>
                        </thead>
                        <tbody>
                        @foreach( $quotations as $quotation )
                        <tr>
                            <td>{{ $quotation->quotation_number }}</td>
                            <td>{{ $quotation->date }}</td>
                            <td>{{ $quotation->customerRfq->customer->name }}</td>
                            <td>{{ $quotation->customerRfq->customer_rfq_number }}</td>
                            <td>
                                @php
                                    $quotation_parts = \App\Models\OurQuotationPart::where('our_quotation_id', '=', $quotation->id)->selectRaw('sum(quantity*unit_price) as total')->first();
                                @endphp

                                {{ number_format( $quotation_parts->total, 2) }}
                            </td>
                            <td>
                                <span>
                                    @can('Business - OurQuotations - Parts')
                                    <a href='{{ route('our-quotations.export.quotations', ['our_quotation' => $quotation->id, 'print' => 'no']) }}' target='_blank'>
                                        <img class='' src="{{ asset('images/icons/pdf.png') }}" alt='file' height='30' width=''>
                                    </a>
                                    @endcan
                                </span>
                            </td>
                            <td>{{ $quotation->status == "Sent" ? "Sent" : "" }}</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('Business - OurQuotations - Parts')
                                    <a class="dropdown-item" href="{{ route('our-quotations.show', ['our_quotation' => $quotation->id]) }}" target="">
                                        <i data-feather="layers" class="me-50"></i>
                                        <span>Parts</span>
                                    </a>
                                    @endcan
                                    @can('Business - OurQuotations - Edit')
                                    <a class="dropdown-item" href="{{ route('our-quotations.sent', ['our_quotation' => $quotation->id]) }}" >
                                        <i data-feather="mail" class="me-50"></i>
                                        <span>
                                        @if($quotation->status == 'Sent')
                                            UnSent
                                        @else
                                            Sent
                                        @endif
                                        </span>
                                    </a>
                                    @endcan
                                    @can('Business - OurQuotations - Parts')
                                    <a class="dropdown-item" href="{{ route('our-quotations.export', ['our_quotation' => $quotation->id]) }}" onclick="window.location=this.href">
                                        <i data-feather="share" class="me-50"></i>
                                        <span>Export Excel</span>
                                    </a>
                                    @endcan
                                    @can('Business - OurQuotations - Parts')
                                    <a class="dropdown-item" href="{{ route('our-quotations.export.quotations', ['our_quotation' => $quotation->id]) }}" target="_blank">
                                        <i data-feather="share" class="me-50"></i>
                                        <span>Export PDF</span>
                                    </a>
                                    @endcan
                                    @can('Business - OurQuotations - Edit')
                                    <a class="dropdown-item" href="{{ route('our-quotations.edit', ['our_quotation' => $quotation->id]) }}" target="">
                                      <i data-feather="edit-2" class="me-50"></i>
                                      <span>Edit</span>
                                    </a>
                                    @endcan
                                    @can('Business - OurQuotations - Remove')
                                    <a class="dropdown-item" href="{{ route('our-quotations.destroy', ['our_quotation' => $quotation->id]) }}" onclick="event.preventDefault(); document.getElementById('destroy-form-{{ $quotation->id }}').submit();">
                                      <i data-feather="trash" class="me-50"></i>
                                      <span>Remove</span>
                                    </a>
                                    <form method="POST" id="destroy-form-{{ $quotation->id }}" action="{{ route('our-quotations.destroy', ['our_quotation' => $quotation->id]) }}">
                                        @csrf
                                        @method('delete')
                                    </form>
                                    @endcan
                                  </div>
                                </span>
                            </td>
                        </tr>
                        @endforeach
                        </tbody>
                    </table>
                </div>

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