@extends('layouts/contentLayoutMaster')

@section('title', 'Customer PO Parts')

@section('vendor-style')
    <!-- vendor 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 customerPOParts">
            <div class="col-12">
                <div class="card">
                    <div class="card-header">
                        <h4 class="card-title">Customer PO Parts</h4>
                        <div class="float-sm-left">
                            <a class="btn btnCustomStyle" href="{{ route('customer-pos.index') }}" role="button">Return to Customer POs List</a>
                        </div>
                    </div>

                    <div class="card-body">

                        @if($customer_po_part->inventory_id)
                        <form class="form" method="POST" action="{{route('customer-pos.update.part', ['customer_po' => $customer_po->id, 'customer_po_part' => $customer_po_part->id])}}" enctype="multipart/form-data">
                            @csrf
                            @method('patch')
                        @else
                        <form class="form" method="POST" action="{{route('customer-pos.add.part', ['customer_po' => $customer_po->id])}}" enctype="multipart/form-data">
                            @csrf
                            @method('put')
                        @endif

                            <div class="row firstRow justify-content-between">
                                <div class="col-md-10 row order-md-1 order-2">
                                    <div class="row col-md-12">
                                        <div class="col-sm-1 pe-sm-0">
                                            <label class="col-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" required disabled>
                                                <option value="" selected="selected">select</option>
                                                @foreach($customers as $customer)
                                                <option value="{{ $customer->id }}" @if( old("customer_id", $customer_po->customer_id) == $customer->id ) selected @endif>{{ $customer->name }}</option>
                                                @endforeach
                                            </select>

                                            @php
                                            }
                                            @endphp

                                            @error('customer_id')
                                            <div class="invalid-feedback">{{ $message }}</div>
                                            @enderror
                                        </div>
                                        <div class="col-sm-1 pe-sm-0">
                                            <label class="col-form-label" for="status">Status *</label>
                                            @php
                                            $statuses = ['No Action', 'Under Process', 'In Shipping', 'Delivered', 'Invoiced', 'Cancelled', 'Hold'];
                                            if(!empty($statuses)){
                                            @endphp

                                            <select class="select2 form-select" id="status" name="status" required disabled>
                                                <option value="" selected="selected">select</option>
                                                @foreach($statuses as $status)
                                                <option value="{{ $status }}" @if( old("status", $customer_po->status) == $status ) selected @endif>{{ $status }}</option>
                                                @endforeach
                                            </select>

                                            @php
                                            }
                                            @endphp

                                            @error('customer_id')
                                            <div class="invalid-feedback">{{ $message }}</div>
                                            @enderror
                                        </div>
                                        <div class="col-sm-auto text-end align-self-end end-form-btn pe-0">
                                            @php
                                            if( is_file(public_path('storage/' . $customer_po->file_path)) ){
                                            echo "<a class='btn btn-primary' href='" . asset("storage/$customer_po->file_path") . "' target='_blank'>Attachment</a>";
                                            }
                                            @endphp
                                        </div>
                                    </div>
                                    <div class="row col-md-12">
                                        <div class="col-sm-1 pe-sm-0">
                                            <label class="col-form-label dropLabel" for="our_quotation_id">Our Quotation *</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" required>
                                                <option value="" selected="selected">select</option>
                                                @foreach($our_quotations as $our_quotation)
                                                <option value="{{ $our_quotation->id }}" @if( old("our_quotation_id", $customer_po_part->our_quotation_id) == $our_quotation->id ) selected @endif>{{ $our_quotation->quotation_number }}</option>
                                                @endforeach
                                            </select>

                                            @php
                                            }
                                            @endphp

                                            @error('our_quotation_id')
                                            <div class="invalid-feedback">{{ $message }}</div>
                                            @enderror
                                        </div>
                                        <div class="col-sm-1 numericFields pe-sm-0">
                                            <label class="col-form-label dropLabel" for="vendor_id">Part NO. *</label>
                                            @php
                                            $parts = \App\Models\Inventory::orderBy('part_number', 'asc')->get();
                                            if($parts->count()){
                                            @endphp

                                            <select class="select2 form-select" id="inventory_id" name="inventory_id" required>
                                                <option value="" selected="selected">select</option>
                                                @foreach($parts as $part)
                                                <option value="{{ $part->id }}" @if( old("inventory_id", $customer_po_part->inventory_id) == $part->id ) selected @endif>{{ $part->part_number }}</option>
                                                @endforeach
                                            </select>

                                            @php
                                            }
                                            @endphp

                                            @error('inventory_id')
                                            <div class="invalid-feedback">{{ $message }}</div>
                                            @enderror
                                        </div>
                                        <div class="col-sm-1 numericFields pe-sm-0">
                                            <label class="col-form-label" for="quantity">Quantity *</label>
                                            <input type="text" id="quantity" class="form-control @error('quantity') is-invalid @enderror" name="quantity" placeholder="Quantity" value="{{ old('quantity', $customer_po_part->quantity) }}" required/>
                                            @error('quantity')
                                            <div class="invalid-feedback">{{ $message }}</div>
                                            @enderror
                                        </div>
                                        <div class="col-sm-1 numericFields pe-sm-0">
                                            <label class="col-form-label" for="condition">Condition</label>
                                            <input type="text" id="condition" class="form-control @error('condition') is-invalid @enderror" name="condition" placeholder="Condition" value="{{ old('condition', $customer_po_part->condition) }}" />
                                            @error('condition')
                                            <div class="invalid-feedback">{{ $message }}</div>
                                            @enderror
                                        </div>
                                        <div class="col-sm-1 pe-sm-0">
                                            <label class="col-form-label" for="cert">Cert</label>
                                            <input type="text" id="cert" class="form-control @error('cert') is-invalid @enderror" name="cert" placeholder="Cert" value="{{ old('cert', $customer_po_part->cert) }}" />
                                            @error('cert')
                                            <div class="invalid-feedback">{{ $message }}</div>
                                            @enderror
                                        </div>
                                        <div class="col-sm-1 pe-sm-0">
                                            <label class="col-form-label" for="tag_date">Tag Date</label>
                                            <input type="text" id="tag_date" class="form-control @error('tag_date') is-invalid @enderror" name="tag_date" placeholder="Tag Date" value="{{ old('tag_date', $customer_po_part->tag_date) }}" />
                                            @error('tag_date')
                                            <div class="invalid-feedback">{{ $message }}</div>
                                            @enderror
                                        </div>
                                    </div>
                                    <div class="row col-md-12">
                                        <div class="col-sm-1 pe-sm-0">
                                            <label class="col-form-label" for="lead_time">Lead Time</label>
                                            <input type="text" id="lead_time" class="form-control @error('lead_time') is-invalid @enderror" name="lead_time" placeholder="Lead Time" value="{{ old('lead_time', $customer_po_part->lead_time) }}" />
                                            @error('lead_time')
                                            <div class="invalid-feedback">{{ $message }}</div>
                                            @enderror
                                        </div>
                                        <div class="col-sm-1 pe-sm-0">
                                            <label class="col-form-label" for="unit_price">Unit Price *</label>
                                            <input type="text" id="unit_price" class="form-control @error('unit_price') is-invalid @enderror" name="unit_price" placeholder="Unit Price" value="{{ old('unit_price', $customer_po_part->unit_price) }}" required/>
                                            @error('unit_price')
                                            <div class="invalid-feedback">{{ $message }}</div>
                                            @enderror
                                        </div>
                                        <div class="col-sm-3 min-width360 pe-sm-0">
                                            <label class="col-form-label" for="note">Note</label>
                                            <input type="text" id="note" class="form-control @error('note') is-invalid @enderror" name="note" placeholder="Note" value="{{ old('note', $customer_po_part->note) }}" />
                                            @error('note')
                                            <div class="invalid-feedback">{{ $message }}</div>
                                            @enderror
                                        </div>
                                        <div class="col-sm-auto align-self-end mt-ms-0 mt-2">
                                            @if($customer_po_part->inventory_id)
                                            <button type="submit" class="btn btn-primary me-1" onclick="this.form.submit()">Update Part</button>
                                            @else
                                            <button type="submit" class="btn btn-primary me-1" onclick="this.form.submit()">Add Part</button>
                                            @endif
                                            <a class="btn btn-outline-secondary" href="{{url()->current()}}" role="button">Reset</a>
                                        </div>
                                    </div>

                                </div>
                                <div class="col-md-2 row justify-content-end  order-md-2 order-1">
                                    <div class="col-sm-1 min-width197">
                                        <label class="col-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", $customer_po->date) }}" required disabled/>
                                        @error('date')
                                        <div class="invalid-feedback">{{ $message }}</div>
                                        @enderror
                                    </div>
                                    <div class="col-sm-1 min-width197">
                                        <label class="col-form-label" for="edd">EDD *</label>
                                        <input type="text" id="edd" autocomplete="off" class="form-control" placeholder="{{ date('Y-m-d') }}" name="edd" value="{{ old("edd", $customer_po->edd) }}" required disabled/>
                                        @error('edd')
                                        <div class="invalid-feedback">{{ $message }}</div>
                                        @enderror
                                    </div>
                                    <div class="col-sm-1 min-width197">
                                        <label class="col-form-label" for="customer_po_number">Customer PO NO. *</label>
                                        <input type="text" id="customer_po_number" class="form-control @error('customer_po_number') is-invalid @enderror" name="customer_po_number" placeholder="Customer PO Number" value="{{ old('customer_po_number', $customer_po->customer_po_number) }}" required disabled/>
                                        @error('customer_po_number')
                                        <div class="invalid-feedback">{{ $message }}</div>
                                        @enderror
                                    </div>
                                    <div class="col-sm-1 text-end ms-auto mt-2">
                                        @can('Order - Invoices - Add')
                                        <a class="btn btn-outline-secondary" href="{{ route('invoices.create', ['customer_po_id' => $customer_po->id]) }}" target="_blank">
                                            Add Invoice
                                        </a>
                                        @endcan
                                    </div>
                                </div>
                            </div>

                        </form>



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

                        <ul class="nav nav-pills" role="tablist">
                            <li class="nav-item" role="presentation">
                                <button class="nav-link active" id="parts-tab" data-bs-toggle="pill" data-bs-target="#parts" type="button" role="tab" aria-controls="parts" aria-selected="true">Parts</button>
                            </li>
                            <li class="nav-item" role="presentation">
                                <button class="nav-link" id="delivery-tab" data-bs-toggle="pill" data-bs-target="#delivery" type="button" role="tab" aria-controls="delivery" aria-selected="false">Delivery Note</button>
                            </li>
                        </ul>

                        <div class="tab-content">

                            <div class="tab-pane fade show active" id="parts" role="tabpanel" aria-labelledby="parts-tab">
                                <div class="table-responsive">
                                    <table id="tablesorter" class="table" cellpadding="5" cellspacing="0" style="border-collapse: collapse;" border="0" bordercolor="#666666">
                                        <thead>
                                        <tr>
                                            <th>Row</th>
                                            <th>Our Quotation</th>
                                            <th>Part Number</th>
                                            <th>Description</th>
                                            <th>Quantity</th>
                                            <th>Condition</th>
                                            <th>Cert</th>
                                            <th>Tag Date</th>
                                            <th>Lead Time</th>
                                            <th>Unit Price</th>
                                            <th>Total Price</th>
                                            <th>Note</th>
                                            <th>Action</th>
                                        </tr>
                                        </thead>
                                        <tbody>
                                        @php
                                            $i = 0;
                                            $sub_total = 0;
                                        @endphp
                                        @foreach( $customerPOParts as $customerPOPart )
                                            @php
                                                $sub_total += $customerPOPart->unit_price * $customerPOPart->quantity;
                                            @endphp
                                            <tr>
                                                <td>{{ ++$i }}</td>
                                                <td>{{ $customerPOPart->ourQuotation->quotation_number }}</td>
                                                <td>
                                                    @can('Business - Inventories - List')
                                                        <a href="{{ route('inventories.show', ['inventory' => $customerPOPart->inventory->id]) }}" target="_blank">
                                                            @endcan
                                                            {{ $customerPOPart->inventory->part_number }}
                                                            @can('Business - Inventories - List')
                                                        </a>
                                                    @endcan
                                                </td>
                                                <td>{{ $customerPOPart->inventory->description }}</td>
                                                <td>{{ $customerPOPart->quantity }}</td>
                                                <td>{{ $customerPOPart->condition }}</td>
                                                <td>{{ $customerPOPart->cert }}</td>
                                                <td>{{ $customerPOPart->tag_date }}</td>
                                                <td>{{ $customerPOPart->lead_time }}</td>
                                                <td>{{ number_format($customerPOPart->unit_price, 2) }}</td>
                                                <td>{{ number_format($customerPOPart->unit_price * $customerPOPart->quantity, 2) }}</td>
                                                <td>{{ $customerPOPart->note }}</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 - CustomerPOs - Parts')
                                                            <a class="dropdown-item" href="{{ route('customer-pos.edit.part', ['customer_po' => $customer_po->id, 'customer_po_part' => $customerPOPart->id]) }}">
                                                              <i data-feather="edit-2" class="me-50"></i>
                                                              <span>Edit</span>
                                                            </a>
                                                          @endcan
                                                          @can('Order - CustomerPOs - Parts')
                                                          @if($customer_po_part->id != $customerPOPart->id)
                                                            <a class="dropdown-item" href="{{ route('customer-pos.remove.part', ['customer_po' => $customer_po->id, 'customer_po_part' => $customerPOPart->id]) }}" onclick="event.preventDefault(); document.getElementById('destroy-form-{{ $customerPOPart->id }}').submit();">
                                                              <i data-feather="trash" class="me-50"></i>
                                                              <span>Remove</span>
                                                            </a>
                                                            <form method="POST" id="destroy-form-{{ $customerPOPart->id }}" action="{{ route('customer-pos.remove.part', ['customer_po' => $customer_po->id, 'customer_po_part' => $customerPOPart->id]) }}">
                                                                @csrf
                                                                @method('delete')
                                                            </form>
                                                          @endif
                                                          @endcan
                                                      </div>
                                                    </span>
                                                </td>
                                            </tr>
                                        @endforeach
                                        </tbody>
                                        <thfoot>
                                            <tr style="background-color: #d1f8e1 !important; ; font-weight: bold; font-size: 14px;">
                                                <td colspan="9"></td>
                                                <td>Sub Total:</td>
                                                <td>{{ number_format($sub_total, 2) }}</td>
                                                <td colspan="2"></td>
                                            </tr>
                                        </thfoot>
                                    </table>
                                </div>
                            </div>

                            <div class="tab-pane fade" id="delivery" role="tabpanel" aria-labelledby="delivery-tab">
                                <div class="table-responsive">
                                    <table class="table" cellpadding="5" cellspacing="0" style="border-collapse: collapse;" border="0" bordercolor="#666666">
                                        <thead>
                                        <tr >
                                            <th>Row</th>
                                            <th>Part Number</th>
                                            <th>Description</th>
                                            <th>Quantity</th>
                                            <th>Ordered</th>
                                            <th>Shipped</th>
                                            <th>Received</th>
                                            <th>Invoiced</th>
                                        </tr>
                                        </thead>
                                        <tbody>
                                        @php
                                            $i = 0;
                                        @endphp
                                        @foreach( $customerPOParts as $customerPOPart )
                                            @php
                                                $ordered_no = \App\Models\VendorPOPart::where('customer_po_id', '=', $customerPOPart->customer_po_id)
                                                                    ->where('inventory_id', '=', $customerPOPart->inventory_id)->sum('quantity');
                                                $shipped_no = \App\Models\VendorPOPart::where('customer_po_id', '=', $customerPOPart->customer_po_id)
                                                                    ->where('inventory_id', '=', $customerPOPart->inventory_id)->sum('shipped_no');
                                                $received_no = \App\Models\VendorPOPart::where('customer_po_id', '=', $customerPOPart->customer_po_id)
                                                                    ->where('inventory_id', '=', $customerPOPart->inventory_id)->sum('received_no');
                                                $invoiced_no = DB::table('invoice_parts')->join('invoices', 'invoice_parts.invoice_id', '=', 'invoices.id')
                                                    ->where('invoices.customer_po_id', '=', $customerPOPart->customer_po_id)
                                                    ->where('invoice_parts.inventory_id', '=', $customerPOPart->inventory_id)->sum('invoice_parts.quantity');
                                            @endphp
                                            <tr>
                                                <td>{{ ++$i }}</td>
                                                <td>
                                                    @can('Business - Inventories - List')
                                                        <a href="{{ route('inventories.show', ['inventory' => $customerPOPart->inventory->id]) }}" target="_blank">
                                                            @endcan
                                                            {{ $customerPOPart->inventory->part_number }}
                                                            @can('Business - Inventories - List')
                                                        </a>
                                                    @endcan
                                                </td>
                                                <td>{{ $customerPOPart->inventory->description }}</td>
                                                <td>{{ $customerPOPart->quantity }}</td>
                                                <td>{{ $ordered_no }}</td>
                                                <td>{{ $shipped_no }}</td>
                                                <td>{{ $received_no }}</td>
                                                <td>{{ $invoiced_no }}</td>
                                            </tr>
                                        @endforeach
                                        </tbody>
                                    </table>
                                </div>
                            </div>

                        </div>
                    </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')
    <!-- Page js files -->
    <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