@extends('layouts.app')

@section('title', \App\CPU\translate('KBD Details List'))

@push('css_or_js')
    <link rel="stylesheet" href="{{ asset('assets') }}/css/bootstrap-datepicker.min.css" />
@endpush

@section('content')
    <div id="kt_app_content" class="app-content flex-column-fluid">
        <div id="kt_app_content_container" class="app-container container-xxxl">
            <div id="kt_app_toolbar" class="app-toolbar py-3 py-lg-6">
                <div id="kt_app_toolbar_container" class="app-container container-xxxl d-flex flex-stack">
                    <div class="page-title d-flex flex-column justify-content-center flex-wrap me-3">
                        <h1 class="page-heading d-flex text-dark fw-bold fs-3 flex-column justify-content-center my-0">Back
                            To Back
                            List</h1>
                        <ul class="breadcrumb breadcrumb-separatorless fw-semibold fs-7 my-0 pt-1">
                            <li class="breadcrumb-item text-muted">
                                <a href="" class="text-muted text-hover-primary">Dashboard</a>
                            </li>
                            <li class="breadcrumb-item">
                                <span class="bullet bg-gray-400 w-5px h-2px"></span>
                            </li>
                            <li class="breadcrumb-item text-muted">List</li>
                            <li class="breadcrumb-item">
                                <span class="bullet bg-gray-400 w-5px h-2px"></span>
                            </li>
                            <li class="breadcrumb-item text-muted">{{ \App\CPU\translate('Back To Back List') }}</li>
                        </ul>
                    </div>
                </div>
            </div>
            <div class="card">
                {{-- Header Buttons --}}
                <div class="card-header justify-content-end">
                    <div class="d-flex align-items-center gap-2 gap-lg-3">
                        {{-- Display Button --}}
                        <button type="submit" form="searchForm"
                            class="filterBtn btn btn-sm fw-bold btn-primary">
                            <i class="fas fa-search me-1"></i> {{ \App\CPU\translate('Display') }}
                        </button>

                <a href="{{ route('admin.b2b.export', array_merge(['action' => 'export'], request()->all())) }}"
                class="btn btn-sm fw-bold btn-primary d-flex align-items-center">
                    <i class="fas fa-file-export me-2"></i>
                    {{ \App\CPU\translate('Export') }}
                </a>

                    </div>
                </div>

{{-- Form Section --}}
<div class="card-header justify-content-center pt-5">
    <form class="row w-100" action="{{ url()->current() }}" method="GET" id="searchForm">
        <div class="row col-12">
            <div class="row col-12 align-items-center">
                <div class="col-4 form-group">
                    <label for="date_from"
                        class="title-color fw-semibold text-muted">{{ \App\CPU\translate('Date From') }}</label>
                    <input placeholder="Date Start From"
                        class="form-control form-control-solid startdate input dateSelect"
                        id="startdate" type="text" name="search_start_date"
                        value="{{ request()->search_start_date ?? '' }}" readonly="readonly">
                </div>

                <div class="col-4 form-group">
                    <label for="date_to"
                        class="title-color fw-semibold text-muted">{{ \App\CPU\translate('Date To') }}</label>
                    <input placeholder="Date End To"
                        class="form-control form-control-solid enddate input dateSelect"
                        id="enddate" type="text" name="search_end_date"
                        value="{{ request()->search_to_date ?? '' }}" readonly="readonly">
                </div>

                <div class="col-4 form-group">
                    <label for="select_item"
                        class="title-color fw-semibold text-muted">{{ \App\CPU\translate('Items') }}</label>
                    <select id="item_select" name="select_item" data-control="select2"
                        class="form-select form-select-sm form-select-solid">
                        <option value="0" selected disabled>Item Number</option>
                        <option value="no">no select</option>
                        @foreach ($items as $item)
                            <option value="{{ $item->item_number }}"
                                {{ request()->select_item == $item->item_number ? 'selected' : '' }}>
                                {{ $item->item_number }}
                            </option>
                        @endforeach
                    </select>
                </div>

                <div class="col-4 form-group">
                    <label for="select_order_number"
                        class="title-color fw-semibold text-muted">{{ \App\CPU\translate('Orders') }}</label>
                    <select id="order_number" name="select_order_number" data-control="select2"
                        class="form-select form-select-sm form-select-solid">
                        <option value="0" selected disabled>Order Number</option>
                        <option value="no">no select</option>
                        @foreach ($order_numbers as $order)
                            <option value="{{ $order->order_number }}"
                                {{ request()->select_order_number == $order->order_number ? 'selected' : '' }}>
                                {{ $order->order_number }}
                            </option>
                        @endforeach
                    </select>
                </div>

                <div class="col-4 form-group">
                    <label for="select_document_name"
                        class="title-color fw-semibold text-muted">{{ \App\CPU\translate('Agreements') }}</label>
                    <select id="sales_document_name" name="select_document_name" data-control="select2"
                        class="form-select form-select-sm form-select-solid">
                        <option value="0" selected disabled>Agreement Name</option>
                        <option value="no">no select</option>
                        @foreach ($document_names as $doc)
                            <option value="{{ $doc->sales_document_name }}"
                                {{ request()->select_document_name == $doc->sales_document_name ? 'selected' : '' }}>
                                {{ $doc->sales_document_name }}
                            </option>
                        @endforeach
                    </select>
                </div>
            </div>
        </div>
    </form>
</div>
                <div class="px-3 py-4">
                    <div class="row flex-grow-1">
                        <div class="row col-12 align-items-center">
                            <div class="col-md-4 form-group">
                                <h3 class="card-title text-gray-800 fw-bold">{{ \App\CPU\translate('Creation Date') }}
                                </h3>
                                <input type="text" value="{{ $creation_date }}" disabled class="form-control">
                            </div>
                        </div>
                    </div>
                </div>
                {{-- <div class="px-3 py-4">
                    <div class="row flex-grow-1">
                        <div class="row col-12 align-items-center">
                            <div class="col-md-4 form-group">
                                <h3 class="card-title text-gray-800 fw-bold">{{ \App\CPU\translate('Claim Amount') }}
                                </h3>
                                <input type="text" value="{{ number_format($total_claim, 2) }}" disabled
                                    class="form-control">
                            </div>
                            <div class="col-md-4 form-group">
                                <h3 class="card-title text-gray-800 fw-bold">{{ \App\CPU\translate('Claimed') }}</h3>
                                <input type="text" value="{{ number_format($total_claimed, 2) }}" disabled
                                    class="form-control">
                            </div>
                            <div class="col-md-4 form-group">
                                <h3 class="card-title text-gray-800 fw-bold">{{ \App\CPU\translate('Remaining') }}
                                </h3>
                                <input type="text" value="{{ number_format($total_remaining, 2) }}" disabled
                                    class="form-control">
                            </div>
                        </div>
                    </div>
                </div> --}}

                <div class="card-body pt-0">
                    <div id="kt_customers_table_wrapper" class="dataTables_wrapper dt-bootstrap4 no-footer"
                        style="overflow-x:auto">
                        <table class="table align-middle table-row-dashed fs-6 gy-5 dataTable no-footer">
                            <thead>
                                <tr class="text-start text-gray-400 fw-bold fs-7  gs-0">
                                    <th>Agreement Name</th>
                                    <th>Sales Order</th>
                                    <th>Order Date</th>
                                    <th>Customer Number</th>
                                    <th>Customer Name</th>
                                    <th>Ship to City</th>
                                    <th>Ship to Number</th>
                                    <th>Ship to Name</th>

                                    <th>Ordered Qty</th>
                                    <th>Line Status</th>
                                    <th>Ordered UOM</th>
                                    <th>Vendor Catalog</th>
                                    <th>Ordered Item </th>
                                    <th>Item Description </th>

                                    <th>Fullfilled Qty</th>
                                    <th>Remaining Qty</th>
                                    <th>Remaining Amount</th>
                                    <th>Promise Date</th>
                                    <th>Request Date</th>
                                    <th>Unit Sellng Price</th>
                                    <th>Customer Po Number</th>


                                    <th>Lot Number</th>
                                    <th>WHS</th>
                                    <th>PO Number</th>
                                    <th>Production Date</th>
                                    <th>Delivery Lot Expiry</th>
                                    <th>Delivery Number</th>
                                    <th>Delivery Date</th>
                                    <th>Received Date</th>
                                    <th>PO Line Qty</th>
                                    <th>QTY Received</th>
                                    <th>Item Shelf</th>
                                    <th>AP Invoice Number</th>
                                    <th>AR Invoice Number</th>
                                    <th>Date Of The Received</th>
                                </tr>
                            </thead>
                            <tbody>
                                @foreach ($data as $data_index => $val)
                                    <tr>
                                        <td> {{ $val->sales_document_name ?? null }} </td>
                                        <td> {{ $val->order_number ?? null }} </td>
                                        <td> {{ $val->ordered_date ?? null }} </td>
                                        <td> {{ $val->customer_number ?? null }} </td>
                                        <td> {{ $val->customer_name ?? null }} </td>
                                        <td> {{ $val->city ?? null }} </td>
                                        <td> {{ $val->ship_to ?? null }} </td>
                                        <td> {{ $val->address1 ?? null }} </td>

                                        <td> {{ $val->ordered_quantity ?? null }} </td>
                                        <td> {{ $val->line_flow_status_code ?? null }} </td>
                                        <td> {{ $val->order_quantity_uom ?? null }} </td>
                                        <td> {{ $val->item_catalog ?? null }} </td>
                                        <td> {{ $val->item_number ?? null }} </td>
                                        <td> {{ $val->description ?? null }} </td>

                                        <td> {{ $val->fulfilled_quantity ?? null }} </td>
                                        <td> {{ $val->ordered_quantity - $val->fulfilled_quantity ?? null }} </td>
                                        <td> {{ ($val->ordered_quantity - $val->fulfilled_quantity) * $val->unit_selling_price ?? null }}
                                        </td>
                                        <td> {{ $val->promise_date ?? null }} </td>
                                        <td> {{ $val->request_date ?? null }} </td>
                                        <td> {{ $val->unit_selling_price ?? null }} </td>
                                        <td> {{ $val->cust_po_number ?? null }} </td>

                                        <td> {{ $val->rec_lot_number ?? null }} </td>
                                        <td> {{ $val->organization_code ?? null }} </td>
                                        <td> {{ $val->po_number ?? null }} </td>

                                        <td> {{ $val->rec_origination_date ?? null }} </td>
                                        <td> {{ $val->delivery_number ?? null }} </td>
                                        <td> {{ $val->del_date ?? null }} </td>
                                        <td> {{ $val->rec_expiration_date ?? null }} </td>
                                        <td> {{ $val->putawy_date ?? null }} </td>
                                        <td> {{ $val->po_quantity ?? null }} </td>
                                        <td> {{ $val->putawy_qty ?? null }} </td>
                                        <td> {{ $val->shelf_life_days ?? null }} </td>
                                        <td> {{ $val->ap_invoice_number ?? null }} </td>
                                        <td> {{ $val->invoice_number ?? null }} </td>
                                        <td> {{ $val->gf_customer_appointment ?? null }} </td>
                                    </tr>
                                    </a>
                                @endforeach
                            </tbody>
                        </table>

                    </div>
                </div>
                <div class="table-responsive mt-4">
                    <div class="d-flex justify-content-lg-end">
                        {{ $data->links() }}
                    </div>
                </div>
                @if (count($data) == 0)
                    <div class="text-center p-4">
                        <p class="mb-0">{{ \App\CPU\translate('No_data_to_show') }}</p>
                    </div>
                @endif
            </div>
        </div>
    </div>
    </div>
@endsection

@push('script')
    <script src="{{ asset('assets') }}/js/bootstrap-datepicker.min.js"></script>
    <script>
        //datepicker$('.datepicker').datepicker();
        rtl = false;


        if ($('#enddate').length > 0) {
            $('#enddate').datepicker({
                language: rtl ? 'ar' : 'en',
                clearBtn: true,
                autoclose: true,
            });
        }
        if ($('#startdate').length > 0) {
            $('#startdate').datepicker({
                language: rtl ? 'ar' : 'en',
                clearBtn: true,

                autoclose: true,
            });
        }




        $(document).on('change', '#select_vendor', function() {
            var vendor = $(this).val();
            $.ajaxSetup({
                headers: {
                    'X-CSRF-TOKEN': $('meta[name="_token"]').attr('content')
                }
            });
            $.ajax({
                url: "{{ route('admin.filter.vendor-business') }}",
                method: 'GET',
                data: {
                    vendor: vendor,
                },
                success: function(data) {
                    $('#select_business').empty();
                    $('#select_business').append(new Option('business', '0', true, true));
                    $('#select_business>option[value="0"]').prop('disabled', true);
                    $('#select_business').append(new Option('no select', 'no', true, true));
                    $(data).each(function(i, z) {
                        var select_business = '{{ $_GET['select_business'] ?? '' }}';
                        if (select_business != '' && select_business == z) {
                            $('#select_business').append(new Option(z, z, true, true))
                            $('#select_business').val(1).trigger('change');
                        } else {
                            $('#select_business').append(new Option(z, z, false, true))
                            $('#select_business').val(1).trigger('change');
                        }
                    })
                }
            });
        });
        $(window).ready(function() {
            $('#select_vendor').trigger("change");
        })

        $(document).on('change', 'select', function() {
            if ($(this).val() == 'no') {
                $(this).val(null).trigger("change");
            }
        })
    </script>
@endpush