@extends('layouts.location')

@section('title', 'SO Approval')
@section('page-title', 'SO Approval')

@section('content')
<div class="card">
    <div class="card-header">
        <ul class="nav nav-tabs card-header-tabs" id="soApprovalTabs" role="tablist">
            <li class="nav-item" role="presentation">
                <button class="nav-link active" id="picklist-tab" data-bs-toggle="tab" data-bs-target="#picklist" type="button" role="tab" aria-controls="picklist" aria-selected="true">Picklist</button>
            </li>
            <li class="nav-item" role="presentation">
                <button class="nav-link" id="packlist-tab" data-bs-toggle="tab" data-bs-target="#packlist" type="button" role="tab" aria-controls="packlist" aria-selected="false">Packlist</button>
            </li>
        </ul>
    </div>
    <div class="card-body">
        <div class="tab-content" id="soApprovalTabsContent">
            <div class="tab-pane fade show active" id="picklist" role="tabpanel" aria-labelledby="picklist-tab">
                @php
                    $picklistGroups = collect($picklistRows ?? [])->groupBy('pic_id');
                @endphp
                <div class="table-responsive">
                    <table class="table table-sm table-bordered table-hover align-middle">
                        <thead class="table-light">
                            <tr>
                                <th style="width: 40px;"></th>
                                <th>SO No(s)</th>
                                <th>PIC ID</th>
                                <th>Status</th>
                                <th>Accept Remark</th>
                                <th>Reject Remark</th>
                                <th>Action</th>
                            </tr>
                        </thead>
                        <tbody>
                        @forelse($picklistGroups as $picId => $rows)
                            @php
                                $firstRow = $rows->first();
                                $soLabel = $rows->pluck('sales_order_number')
                                    ->filter()
                                    ->flatMap(function ($v) {
                                        return array_filter(array_map('trim', explode(',', (string) $v)));
                                    })
                                    ->unique()
                                    ->values()
                                    ->implode(',');
                            @endphp
                            <tr class="pick-summary-row" data-pic-id="{{ $picId }}">
                                <td>
                                    <button type="button" class="btn btn-link btn-sm p-0 text-decoration-none toggle-pick-details" data-pic-id="{{ $picId }}">▶</button>
                                </td>
                                <td>{{ $soLabel ?: '-' }}</td>
                                <td>{{ $picId ?? '-' }}</td>
                                <td>{{ $firstRow->status ?? '-' }}</td>
                                <td>{{ $firstRow->accept_remark_account ?? '' }}</td>
                                <td>{{ $firstRow->reject_remark_account ?? '' }}</td>
                                <td>
                                    <div class="d-flex gap-1">
                                        <button type="button" class="btn btn-success btn-sm" data-bs-toggle="modal" data-bs-target="#remarkModal" data-type="picklist-group" data-id="{{ $picId }}" data-action="accept">
                                            Accept All
                                        </button>
                                        <button type="button" class="btn btn-danger btn-sm" data-bs-toggle="modal" data-bs-target="#remarkModal" data-type="picklist-group" data-id="{{ $picId }}" data-action="reject">
                                            Reject All
                                        </button>
                                    </div>
                                </td>
                            </tr>
                            <tr class="pick-details-row d-none" data-parent-pic-id="{{ $picId }}">
                                <td></td>
                                <td colspan="6">
                                    <div class="table-responsive">
                                        <table class="table table-sm table-bordered mb-0">
                                            <thead class="table-secondary">
                                                <tr>
                                                    <th>SO No(s)</th>
                                                    <th>SKU</th>
                                                    <th class="text-end">Require Qty</th>
                                                    <th class="text-end">Pick Qty</th>
                                                    <th class="text-end">Short Qty</th>
                                                    <th style="width: 160px;">Action</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                @foreach($rows as $row)
                                                    @php
                                                        $requireQty = (float) ($row->required_qty_calc ?? $row->required_qty ?? 0);
                                                        $pickedQty = (float) ($row->pick_qty ?? 0);
                                                        $shortQty = $requireQty - $pickedQty;
                                                    @endphp
                                                    <tr>
                                                        <td>{{ $row->sales_order_number ?? '-' }}</td>
                                                        <td>{{ $row->sku ?? '-' }}</td>
                                                        <td class="text-end">{{ $requireQty }}</td>
                                                        <td class="text-end">{{ $pickedQty }}</td>
                                                        <td class="text-end">{{ $shortQty }}</td>
                                                        <td>
                                                            <div class="d-flex gap-1">
                                                                <button type="button" class="btn btn-success btn-sm" data-bs-toggle="modal" data-bs-target="#remarkModal" data-type="picklist" data-id="{{ $row->id }}" data-action="accept">
                                                                    Accept
                                                                </button>
                                                                <button type="button" class="btn btn-danger btn-sm" data-bs-toggle="modal" data-bs-target="#remarkModal" data-type="picklist" data-id="{{ $row->id }}" data-action="reject">
                                                                    Reject
                                                                </button>
                                                            </div>
                                                        </td>
                                                    </tr>
                                                @endforeach
                                            </tbody>
                                        </table>
                                    </div>
                                </td>
                            </tr>
                        @empty
                            <tr>
                                <td colspan="7" class="text-center text-muted">No picklist records with status = inv-completed.</td>
                            </tr>
                        @endforelse
                        </tbody>
                    </table>
                </div>
            </div>
            <div class="tab-pane fade" id="packlist" role="tabpanel" aria-labelledby="packlist-tab">
                @php
                    $packlistGroups = collect($packlistRows ?? [])->groupBy('so_no');
                @endphp
                <div class="table-responsive">
                    <table class="table table-sm table-bordered table-hover align-middle">
                        <thead class="table-light">
                            <tr>
                                <th style="width: 40px;"></th>
                                <th>SO No</th>
                                <th>Total Boxes</th>
                                <th>Total Weight</th>
                                <th>Status</th>
                                <th>Accept Remark</th>
                                <th>Reject Remark</th>
                                <th>Action</th>
                            </tr>
                        </thead>
                        <tbody>
                        @forelse($packlistGroups as $soNo => $rows)
                            @php
                                $boxCount = $rows->count();
                                $totalWeight = $rows->sum(function ($r) {
                                    return (float) ($r->weight ?? 0);
                                });
                                $firstRow = $rows->first();
                                $diffsForSo = collect($shortPackDiffs[$soNo] ?? []);

                                $normalizePackName = function ($name) {
                                    $name = trim((string) $name);
                                    if ($name === '') {
                                        return $name;
                                    }
                                    $parts = preg_split('/\s+/', $name);
                                    if (count($parts) > 1) {
                                        $last = end($parts);
                                        $cleanLast = preg_replace('/[^A-Z0-9-]/', '', strtoupper($last));
                                        $looksLikeSku = (
                                            $cleanLast !== ''
                                            && preg_match('/^[A-Z0-9-]+$/', $cleanLast)
                                            && (str_contains($cleanLast, '-') || (preg_match('/[A-Z]/', $cleanLast) && preg_match('/[0-9]/', $cleanLast)))
                                        );
                                        if ($looksLikeSku) {
                                            array_pop($parts);
                                            $name = implode(' ', $parts);
                                        }
                                    }
                                    $name = str_replace(["*", "/", "\\", "×"], ' ', $name);
                                    $name = preg_replace('/\s+/', ' ', trim($name));
                                    return $name;
                                };

                                $boxKeysByPackId = [];
                                $allBoxKeys = collect();
                                foreach ($rows as $row) {
                                    $keys = collect();
                                    try {
                                        $items = json_decode($row->items, true);
                                        if (is_array($items)) {
                                            foreach ($items as $it) {
                                                if (is_string($it)) {
                                                    $decoded = json_decode($it, true);
                                                    $it = is_array($decoded) ? $decoded : $it;
                                                }
                                                if (is_array($it) && isset($it['item'])) {
                                                    $rawName = (string) ($it['item'] ?? '');
                                                    $sku = trim((string) ($it['sku'] ?? ''));
                                                    $key = $sku !== '' ? ('SKU:' . $sku) : ('NAME:' . $normalizePackName($rawName));
                                                    if ($key !== 'NAME:' && $key !== 'SKU:') {
                                                        $keys->push($key);
                                                    }
                                                }
                                            }
                                        }
                                    } catch (\Throwable $e) {
                                    }
                                    $keys = $keys->filter()->unique()->values();
                                    $boxKeysByPackId[(string) $row->id] = $keys;
                                    $allBoxKeys = $allBoxKeys->merge($keys);
                                }
                                $allBoxKeys = $allBoxKeys->filter()->unique()->values();
                            @endphp
                            <tr class="pack-summary-row" data-so-no="{{ $soNo }}">
                                <td>
                                    <button type="button" class="btn btn-link btn-sm p-0 text-decoration-none toggle-pack-details" data-so-no="{{ $soNo }}">▶</button>
                                </td>
                                <td>{{ $soNo }}</td>
                                <td>{{ $boxCount }}</td>
                                <td>{{ $totalWeight }}</td>
                                <td>{{ $firstRow->status ?? '-' }}</td>
                                <td>{{ $firstRow->accept_remark_account ?? '' }}</td>
                                <td>{{ $firstRow->reject_remark_account ?? '' }}</td>
                                <td>
                                    <div class="d-flex gap-1">
                                        <button type="button" class="btn btn-success btn-sm" data-bs-toggle="modal" data-bs-target="#remarkModal" data-type="packlist" data-id="{{ $soNo }}" data-action="accept">
                                            Accept All
                                        </button>
                                        <button type="button" class="btn btn-danger btn-sm" data-bs-toggle="modal" data-bs-target="#remarkModal" data-type="packlist" data-id="{{ $soNo }}" data-action="reject">
                                            Reject All
                                        </button>
                                    </div>
                                </td>
                            </tr>
                            <tr class="pack-details-row d-none" data-parent-so-no="{{ $soNo }}">
                                <td></td>
                                <td colspan="7">
                                    <div class="small">
                                        <strong>Short / Difference items for SO {{ $soNo }}:</strong>

                                        @php
                                            $unboxedDiffs = $diffsForSo->filter(function ($d) use ($allBoxKeys) {
                                                $k = isset($d['item_key']) ? (string) $d['item_key'] : '';
                                                return $k !== '' && !$allBoxKeys->contains($k);
                                            })->values();
                                        @endphp

                                        @if($rows->isNotEmpty())
                                            @foreach($rows as $r)
                                                @php
                                                    $packId = (string) $r->id;
                                                    $keysForBox = isset($boxKeysByPackId[$packId]) ? $boxKeysByPackId[$packId] : collect();
                                                    if (!$keysForBox instanceof \Illuminate\Support\Collection) {
                                                        $keysForBox = collect($keysForBox);
                                                    }
                                                    $diffsForBox = $diffsForSo->filter(function ($d) use ($keysForBox) {
                                                        $k = isset($d['item_key']) ? (string) $d['item_key'] : '';
                                                        return $k !== '' && $keysForBox->contains($k);
                                                    })->values();

                                                    $boxVal = $r->box;
                                                    $boxDecoded = null;
                                                    try {
                                                        $boxDecoded = json_decode($r->box, true);
                                                    } catch (\Throwable $e) {
                                                    }
                                                    if (is_array($boxDecoded)) {
                                                        $boxVal = implode(', ', $boxDecoded);
                                                    }
                                                @endphp

                                                <div class="mt-2">
                                                    <div class="mb-1"><strong>Box:</strong> {{ $boxVal }}</div>
                                                    @if($diffsForBox->isNotEmpty())
                                                        <div class="table-responsive mt-2">
                                                            <table class="table table-sm table-bordered mb-0">
                                                                <thead class="table-secondary">
                                                                    <tr>
                                                                        <th>Item</th>
                                                                        <th class="text-end">SO Qty</th>
                                                                        <th class="text-end">Packed Qty</th>
                                                                        <th class="text-end">Diff</th>
                                                                    </tr>
                                                                </thead>
                                                                <tbody>
                                                                @foreach($diffsForBox as $d)
                                                                    <tr>
                                                                        <td>{{ $d['item_name'] ?? '' }}</td>
                                                                        <td class="text-end">{{ $d['so_qty'] ?? 0 }}</td>
                                                                        <td class="text-end">{{ $d['packed_qty'] ?? 0 }}</td>
                                                                        <td class="text-end">{{ $d['diff'] ?? 0 }}</td>
                                                                    </tr>
                                                                @endforeach
                                                                </tbody>
                                                            </table>
                                                        </div>
                                                    @else
                                                        <div class="mt-2 text-muted">No quantity differences for this box.</div>
                                                    @endif
                                                </div>
                                            @endforeach
                                        @endif

                                        @if($unboxedDiffs->isNotEmpty())
                                            <div class="mt-3">
                                                <div class="mb-1"><strong>Box:</strong> -</div>
                                                <div class="table-responsive mt-2">
                                                    <table class="table table-sm table-bordered mb-0">
                                                        <thead class="table-secondary">
                                                            <tr>
                                                                <th>Item</th>
                                                                <th class="text-end">SO Qty</th>
                                                                <th class="text-end">Packed Qty</th>
                                                                <th class="text-end">Diff</th>
                                                            </tr>
                                                        </thead>
                                                        <tbody>
                                                        @foreach($unboxedDiffs as $d)
                                                            <tr>
                                                                <td>{{ $d['item_name'] ?? '' }}</td>
                                                                <td class="text-end">{{ $d['so_qty'] ?? 0 }}</td>
                                                                <td class="text-end">{{ $d['packed_qty'] ?? 0 }}</td>
                                                                <td class="text-end">{{ $d['diff'] ?? 0 }}</td>
                                                            </tr>
                                                        @endforeach
                                                        </tbody>
                                                    </table>
                                                </div>
                                            </div>
                                        @endif

                                        @if($diffsForSo->isEmpty())
                                            <div class="mt-2 text-muted">No quantity differences for this SO.</div>
                                        @endif
                                    </div>
                                </td>
                            </tr>
                        @empty
                            <tr>
                                <td colspan="8" class="text-center text-muted">No packlist records with status = inv-completed.</td>
                            </tr>
                        @endforelse
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
</div>

<div class="modal fade" id="remarkModal" tabindex="-1" aria-hidden="true">
    <div class="modal-dialog">
        <form method="POST" id="remarkForm">
            @csrf
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title" id="remarkModalLabel">Add Remark</h5>
                    <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                </div>
                <div class="modal-body">
                    <div class="mb-3">
                        <label for="remark" class="form-label">Remark</label>
                        <textarea class="form-control" id="remark" name="remark" rows="3" required></textarea>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                    <button type="submit" class="btn btn-primary">Save</button>
                </div>
            </div>
        </form>
    </div>
</div>
@endsection

@push('scripts')
<script>
    document.addEventListener('DOMContentLoaded', function () {
        var remarkModal = document.getElementById('remarkModal');
        if (remarkModal) {
            remarkModal.addEventListener('show.bs.modal', function (event) {
                var button = event.relatedTarget;
                var type = button.getAttribute('data-type');
                var id = button.getAttribute('data-id');
                var action = button.getAttribute('data-action');

                var form = document.getElementById('remarkForm');
                var label = document.getElementById('remarkModalLabel');
                var remark = document.getElementById('remark');

                remark.value = '';

                if (action === 'accept') {
                    label.textContent = 'Accept Remark';
                } else {
                    label.textContent = 'Reject Remark';
                }

                var baseUrl = '';
                if (type === 'picklist') {
                    baseUrl = '{{ url('location-user/so-approval/picklist') }}';
                } else if (type === 'picklist-group') {
                    baseUrl = '{{ url('location-user/so-approval/picklist-group') }}';
                } else {
                    baseUrl = '{{ url('location-user/so-approval/packlist') }}';
                }

                form.action = baseUrl + '/' + id + '/' + action;
            });
        }

        var toggles = document.querySelectorAll('.toggle-pack-details');
        toggles.forEach(function (btn) {
            btn.addEventListener('click', function () {
                var soNo = btn.getAttribute('data-so-no');
                var rows = document.querySelectorAll('.pack-details-row[data-parent-so-no="' + soNo + '"]');
                var isOpen = btn.classList.contains('open');

                rows.forEach(function (tr) {
                    tr.classList.toggle('d-none', isOpen);
                });

                btn.classList.toggle('open', !isOpen);
                btn.textContent = isOpen ? '▶' : '▼';
            });
        });

        var pickToggles = document.querySelectorAll('.toggle-pick-details');
        pickToggles.forEach(function (btn) {
            btn.addEventListener('click', function () {
                var picId = btn.getAttribute('data-pic-id');
                var rows = document.querySelectorAll('.pick-details-row[data-parent-pic-id="' + picId + '"]');
                var isOpen = btn.classList.contains('open');

                rows.forEach(function (tr) {
                    tr.classList.toggle('d-none', isOpen);
                });

                btn.classList.toggle('open', !isOpen);
                btn.textContent = isOpen ? '▶' : '▼';
            });
        });
    });
</script>
@endpush