@extends('layouts.app', ['class' => 'g-sidenav-show bg-gray-100'])

@section('content')
@include('layouts.navbars.auth.topnav', ['title' => 'Last PO Item Detail'])

@php
    $bsart = $bsart ?? request('bsart');
    $matnr = $matnr ?? request('matnr');
    $rows = $lastPoRows ?? [];

    $formatDate = function ($date) {
        return !empty($date) && $date !== '0000-00-00'
            ? \Carbon\Carbon::parse($date)->format('d-m-Y')
            : '-';
    };

    $dateOrder = function ($date) {
        return !empty($date) && $date !== '0000-00-00'
            ? $date
            : '1900-01-01';
    };
@endphp

<div class="container-fluid py-4">
    <div class="row mt-4">
        <div class="col-12">
            <div class="card mb-4 shadow-sm">
                <div class="card-header p-3 d-flex justify-content-between align-items-center">
                    <div>
                        <h6 class="mb-0">
                            Last PO Detail
                            @if($bsart)
                                - {{ $bsart }} ({{ getBsartLabel($bsart) }})
                            @elseif($matnr)
                                - {{ $matnr }}
                            @endif
                        </h6>

                        <small class="text-muted">
                            @if($bsart)
                                {{ $bsart }}
                            @elseif($matnr)
                                Material: {{ $matnr }}
                            @else
                                All Data
                            @endif
                        </small>
                    </div>

                    <a href="{{ url()->previous() }}" class="btn btn-sm btn-secondary mb-0">
                        Back
                    </a>
                </div>

                <div class="card-body px-3 pt-0 pb-3">
                    <div class="table-responsive">
                        <table class="table table-bordered table-sm align-items-center mb-0" id="my-table">
                            <thead>
                                <tr>
                                    <th class="text-center">No</th>
                                    <th class="text-center">Date</th>
                                    <th class="text-center">PO</th>
                                    <th class="text-center">Item</th>
                                    <th class="text-center">Code</th>
                                    <th class="text-center">Text</th>
                                    <th class="text-center">Vendor Code</th>
                                    <th class="text-center">Vendor Name</th>
                                    <th class="text-center">Qty</th>
                                    <th class="text-center">Cur</th>
                                    <th class="text-center">Net Price</th>
                                    <th class="text-center">Price Qty</th>
                                    <th class="text-center">Net Order</th>
                                    <th class="text-center">Unit</th>
                                    <th class="text-center">Last GR Date</th>
                                    <th class="text-center">GR Qty</th>
                                    <th class="text-center">GR Unit</th>
                                    <th class="text-center">Type</th>
                                </tr>
                            </thead>

                            <tbody>
                                @forelse ($rows as $row)
                                    <tr>
                                        <td class="text-end row-number"></td>

                                        <td class="text-center" data-order="{{ $dateOrder($row['BEDAT'] ?? null) }}">
                                            {{ $formatDate($row['BEDAT'] ?? null) }}
                                        </td>

                                        <td class="text-center fw-bold">{{ $row['EBELN'] ?? '-' }}</td>

                                        <td class="text-end">
                                            {{ isset($row['EBELP']) ? number_format((float) $row['EBELP'], 0, '', '') : '-' }}
                                        </td>

                                        <td>{{ !empty($row['MATNR']) ? $row['MATNR'] : '-' }}</td>

                                        <td>{{ $row['TXZ01'] ?? '-' }}</td>

                                        <td class="text-center">
                                            {{ !empty($row['LIFNR']) ? substr($row['LIFNR'], 3, 7) : '-' }}
                                        </td>

                                        <td>{{ $row['NAME1'] ?? '-' }}</td>

                                        <td class="text-end">
                                            {{ number_format((float) ($row['MENGE'] ?? 0), 2, ',', '.') }}
                                        </td>

                                        <td class="text-center">{{ $row['WAERS'] ?? '-' }}</td>

                                        <td class="text-end">
                                            {{ number_format((float) ($row['NETPR'] ?? 0), 2, ',', '.') }}
                                        </td>

                                        <td class="text-end">
                                            {{ number_format((float) ($row['PEINH'] ?? 0), 2, ',', '.') }}
                                        </td>

                                        <td class="text-end">
                                            {{ number_format((float) ($row['NETWR'] ?? 0), 2, ',', '.') }}
                                        </td>

                                        <td>{{ $row['MEINS'] ?? '-' }}</td>

                                        <td class="text-center" data-order="{{ $dateOrder($row['BUDAT'] ?? null) }}">
                                            {{ $formatDate($row['BUDAT'] ?? null) }}
                                        </td>

                                        <td class="text-end">
                                            {{ number_format((float) ($row['QTY_GR'] ?? 0), 2, ',', '.') }}
                                        </td>

                                        <td>{{ $row['MEINS'] ?? '-' }}</td>

                                        <td class="text-center">
                                            <strong>{{ $row['BSART'] ?? '-' }}</strong>
                                        </td>
                                    </tr>
                                @empty
                                    <tr>
                                        <td class="text-center">-</td>
                                        <td class="text-center">-</td>
                                        <td class="text-center">-</td>
                                        <td class="text-center">-</td>
                                        <td class="text-center">-</td>
                                        <td class="text-center">No data</td>
                                        <td class="text-center">-</td>
                                        <td class="text-center">-</td>
                                        <td class="text-center">-</td>
                                        <td class="text-center">-</td>
                                        <td class="text-center">-</td>
                                        <td class="text-center">-</td>
                                        <td class="text-center">-</td>
                                        <td class="text-center">-</td>
                                        <td class="text-center">-</td>
                                        <td class="text-center">-</td>
                                        <td class="text-center">-</td>
                                        <td class="text-center">-</td>
                                    </tr>
                                @endforelse
                            </tbody>
                        </table>
                    </div>
                </div>

            </div>
        </div>
    </div>
</div>

<style>
    #my-table thead th {
        background-color: #b8ecec !important;
        text-align: center;
        white-space: nowrap;
    }

    #my-table td {
        vertical-align: middle;
        white-space: nowrap;
    }
</style>
@endsection
@push('js')
<script>
    $(document).ready(function () {
        if ($.fn.DataTable.isDataTable('#my-table')) {
            $('#my-table').DataTable().destroy();
        }

        const table = $('#my-table').DataTable({
            pageLength: 10,
            scrollX: true,
            autoWidth: false,
            order: [[1, 'desc'], [2, 'desc']],
            columnDefs: [
                { targets: 0, orderable: false, searchable: false },

                // Right align number columns:
                // No, Item, Qty, Net Price, Price Qty, Net Order, GR Qty
                { targets: [0, 3, 8, 10, 11, 12, 15], className: 'text-end' },

                // Center align selected columns:
                // Date, PO, Vendor Code, Cur, Last GR Date, Type
                { targets: [1, 2, 6, 9, 14, 17], className: 'text-center' }
            ],
            drawCallback: function () {
                const api = this.api();
                const pageInfo = api.page.info();

                api.column(0, { page: 'current' }).nodes().each(function (cell, i) {
                    cell.innerHTML = pageInfo.start + i + 1;
                });
            }
        });
    });
</script>
@endpush