@extends('layouts.app')

@section('content')
    <div class="row">
        <div class="card">
            <div class="card-header">
                <div class="d-flex justify-content-between align-items-center">
                    <div class="">
                        <h4>Report FIFO Material Request</h4>
                        <p class="f-m-light mt-1">We already set start date are 7 days before this day for database
                            performance purpose</p>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <div class="card">
        <div class="card-body">
            <div class="table-responsive">
                <table class="table table-hover table-bordered table-striped" id="export-button">
                    <thead>
                        <tr class="bg-light-primary text-dark">
                            <th>Material Fullname</th>
                            <th>Material Code</th>
                            <th>Material Type</th>
                            <th>UoM</th>
                            <th>PO Supplier Code</th>
                            <th>PO Supplier Date</th>
                            <th>Invoice No</th>
                            <th>Invoice Date</th>
                            <th>BC No</th>
                            <th>BC Date</th>
                            <th>Good Receive No</th>
                            <th>Good Receive Date</th>
                            <th>Price per Unit</th>
                            <th>Qty</th>
                            <th>Amount</th>
                            <th>PO Buyer No</th>
                            <th>PO Buyer Date</th>
                            <th>Buyer Code</th>
                            <th>Invoice PO Buyer Info
                            <th>OP No</th>
                            <th>OP Date</th>
                            <th>OB No</th>
                            <th>OB Date</th>
                            <th>BOM No</th>
                            <th>BOM Date</th>
                            <th>WO No</th>
                            <th>MR No</th>
                            <th>MR Date</th>
                            <th>MR PIC</th>
                            <th>Price per Unit</th>
                            <th>Qty</th>
                            <th>Amount</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach ($stockPoSupplierTransactions as $stockPoSupplierTransaction)
                            <tr>
                                <td>{{ $stockPoSupplierTransaction->material->formatted_material }}</td>
                                <td>{{ $stockPoSupplierTransaction->material->code }}</td>
                                <td>{{ $stockPoSupplierTransaction->material->material_type_code }}</td>
                                <td>{{ $stockPoSupplierTransaction->material->uom_code }}</td>
                                <td>{{ $stockPoSupplierTransaction->poSupplierInvoice->no }}</td>
                                <td>{{ $stockPoSupplierTransaction->poSupplierInvoice->formatted_date }}</td>
                                <td>{{ $stockPoSupplierTransaction->poSupplierInvoice->no }}</td>
                                <td>{{ $stockPoSupplierTransaction->poSupplierInvoice->formatted_date }}</td>
                                <td>{{ $stockPoSupplierTransaction->poSupplierInvoice->bc_data['no'] }}</td>
                                <td>{{ $stockPoSupplierTransaction->poSupplierInvoice->bc_data['date'] }}</td>
                                <td>{{ $stockPoSupplierTransaction->poSupplierGoodReceive->no }}</td>
                                <td>{{ $stockPoSupplierTransaction->poSupplierGoodReceive->formatted_date }}</td>
                                <td>{{ $stockPoSupplierTransaction->remark === 'GR_PO_SUPP' ? $stockPoSupplierTransaction->formatted_price_per_unit : '-' }}
                                </td>
                                <td>{{ $stockPoSupplierTransaction->remark === 'GR_PO_SUPP' ? $stockPoSupplierTransaction->qty : '-' }}
                                </td>
                                <td>{{ $stockPoSupplierTransaction->dk_code === 'DEBIT' ? $stockPoSupplierTransaction->formatted_amount : '-' }}
                                </td>


                                <td>
                                    {{ $stockPoSupplierTransaction->materialRequest->wo->dateRange->bom->op->obDetail->ob->po->no ?? '-' }}
                                </td>
                                <td>
                                    {{ $stockPoSupplierTransaction->materialRequest->wo->dateRange->bom->op->obDetail->ob->po->date ?? '-' }}
                                </td>
                                <td>
                                    {{ $stockPoSupplierTransaction->materialRequest->wo->dateRange->bom->op->obDetail->ob->po->buyer_code ?? '-' }}
                                </td>
                                <td>
                                    @if (count($stockPoSupplierTransaction->materialRequest->wo->dateRange->bom->op->obDetail->ob->po->invoices) > 0)
                                        <table class="table table-sm table-bordered mb-0">
                                            <thead>
                                                <tr class="bg-light-primary text-dark">
                                                    <th>Invoice No</th>
                                                    <th>Invoice Date</th>
                                                    <th>BC No</th>
                                                    <th>BC Date</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                @foreach ($stockPoSupplierTransaction->materialRequest->wo->dateRange->bom->op->obDetail->ob->po->invoices as $invoice)
                                                    <tr>
                                                        <td>{{ $invoice->no }}</td>
                                                        <td>{{ $invoice->formatted_date }}</td>
                                                        <td>{{ $invoice->bc_data['no'] }}</td>
                                                        <td>{{ $invoice->bc_data['date'] }}</td>
                                                    </tr>
                                                @endforeach
                                            </tbody>
                                        </table>
                                    @endif
                                </td>
                                <td>
                                    {{ $stockPoSupplierTransaction->materialRequest?->wo?->dateRange?->bom?->op?->no ?? '-' }}
                                </td>
                                <td>
                                    {{ $stockPoSupplierTransaction->remark === 'WO_MR' ? $stockPoSupplierTransaction->materialRequest->wo->dateRange->bom->op->formatted_date : '-' }}
                                </td>
                                <td>
                                    {{ $stockPoSupplierTransaction->materialRequest?->wo?->dateRange?->bom?->op?->obDetail?->ob?->no ?? '-' }}
                                </td>
                                <td>
                                    {{ $stockPoSupplierTransaction->materialRequest?->wo?->dateRange?->bom?->op?->obDetail?->ob?->formatted_date ?? '-' }}
                                </td>
                                <td>
                                    {{ $stockPoSupplierTransaction->materialRequest?->wo?->dateRange?->bom?->no ?? '-' }}
                                </td>
                                <td>
                                    {{ $stockPoSupplierTransaction->materialRequest?->wo?->dateRange?->bom?->formatted_date ?? '-' }}
                                </td>
                                <td>{{ $stockPoSupplierTransaction->materialRequest?->wo?->no ?? '-' }}</td>
                                <td>{{ $stockPoSupplierTransaction->materialRequest?->no ?? '-' }}</td>
                                <td>{{ $stockPoSupplierTransaction->materialRequest?->formatted_date ?? '-' }}</td>
                                <td>{{ $stockPoSupplierTransaction->materialRequest?->receivedBy->full_contact ?? '-' }}
                                </td>
                                <td>
                                    {{ $stockPoSupplierTransaction->remark === 'WO_MR' ? $stockPoSupplierTransaction->formatted_price_per_unit : '-' }}
                                </td>
                                <td>
                                    {{ $stockPoSupplierTransaction->remark === 'WO_MR' ? $stockPoSupplierTransaction->qty : '-' }}
                                </td>
                                <td>
                                    {{ $stockPoSupplierTransaction->remark === 'WO_MR' ? $stockPoSupplierTransaction->formatted_amount : '-' }}
                                </td>
                            </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
        </div>
    </div>
@endsection

@section('js')
    <script src="/assets/js/datatable/datatables/jquery.dataTables.min.js"></script>
    <script src="/assets/js/datatable/datatable-extension/dataTables.buttons.min.js"></script>
    <script src="/assets/js/datatable/datatable-extension/jszip.min.js"></script>
    <script src="/assets/js/datatable/datatable-extension/buttons.colVis.min.js"></script>
    <script src="/assets/js/datatable/datatable-extension/pdfmake.min.js"></script>
    <script src="/assets/js/datatable/datatable-extension/vfs_fonts.js"></script>
    <script src="/assets/js/datatable/datatable-extension/dataTables.autoFill.min.js"></script>
    <script src="/assets/js/datatable/datatable-extension/dataTables.select.min.js"></script>
    <script src="/assets/js/datatable/datatable-extension/buttons.bootstrap4.min.js"></script>
    <script src="/assets/js/datatable/datatable-extension/buttons.html5.min.js"></script>
    <script src="/assets/js/datatable/datatable-extension/buttons.print.min.js"></script>
    <script src="/assets/js/datatable/datatable-extension/custom.js"></script>
@endsection