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

@push('styles')
    <style>
        .master-table-wrapper {
            overflow-x: auto;
            overflow-y: visible;
            scrollbar-gutter: stable both-edges;
            padding-bottom: 10px;
            border: 1px solid #e9ecef;
            border-radius: 0.5rem;
        }

        #list_rptstk_master {
            min-width: 1240px;
            margin-bottom: 0;
        }

        #list_rptstk_master th,
        #list_rptstk_master td {
            white-space: nowrap;
            vertical-align: middle;
            background: #fff;
        }

        #list_rptstk_master tbody td {
            font-size: 0.875rem;
        }

        #list_rptstk_master thead th {
            background-color: #00b7bd4f;
            font-size: 0.76rem;
            text-transform: uppercase;
            letter-spacing: 0.02em;
        }

        #list_rptstk_master .col-no,
        #list_rptstk_master .col-no-head {
            position: sticky;
            left: 0;
            min-width: 70px;
            width: 70px;
            z-index: 4;
            text-align: center;
        }

        #list_rptstk_master .col-bag,
        #list_rptstk_master .col-bag-head {
            position: sticky;
            left: 70px;
            min-width: 280px;
            z-index: 4;
        }

        #list_rptstk_master thead .col-no-head,
        #list_rptstk_master thead .col-bag-head {
            z-index: 8;
            background-color: #d6eef0;
        }

        #list_rptstk_master_wrapper .dt-buttons {
            display: none;
        }

        .summary-card {
            border: 1px solid #e9ecef;
            border-radius: 0.5rem;
            padding: 0.85rem 1rem;
            background: #fff;
        }

        .summary-card .label {
            font-size: 0.78rem;
            color: #6c757d;
            text-transform: uppercase;
            letter-spacing: 0.03em;
            margin-bottom: 0.2rem;
        }

        .summary-card .value {
            font-size: 1.05rem;
            font-weight: 700;
            color: #344767;
        }
    </style>
@endpush

@section('content')
    @include('layouts.navbars.auth.topnav', ['title' => 'Report Stok per Layout'])

    <div class="container-fluid py-4">
        @php
            $rows = collect($table_result ?? []);
            $totalTransactions = $rows->count();
            $totalBags = $rows->sum(function ($row) {
                $value = $row->{'TOTAL BAG'} ?? ($row->total_bag ?? ($row->total_bags ?? 0));
                $numeric = preg_replace('/[^0-9.\-]/', '', (string) $value);
                return (float) ($numeric !== '' ? $numeric : 0);
            });
            $totalWeight = $rows->sum(function ($row) {
                $value = $row->{'TOTAL BERAT'} ?? ($row->total_berat ?? 0);
                $numeric = preg_replace('/[^0-9.\-]/', '', (string) $value);
                return (float) ($numeric !== '' ? $numeric : 0);
            });

            $headers = $rows->isNotEmpty() ? array_keys((array) $rows->first()) : [];
            $bagKey = in_array('BAG ID', $headers, true)
                ? 'BAG ID'
                : (in_array('LAYOUT ID', $headers, true)
                    ? 'LAYOUT ID'
                    : $headers[0] ?? null);
            $dynamicHeaders = array_values(array_filter($headers, fn($h) => $bagKey === null ? true : $h !== $bagKey));
        @endphp

        <div class="card">
            <div class="card-header pb-0">
                <div class="d-flex justify-content-between align-items-center flex-wrap gap-2">
                    <h5 class="mb-0">Result {{ $title_menu ?? 'Stok per Layout' }}</h5>
                    <div class="d-flex gap-2 flex-wrap">
                        <a href="{{ url($dmenu ?? 'rptstk') }}" class="btn btn-secondary btn-sm mb-0">
                            <i class="fas fa-arrow-left me-1"></i>
                            Kembali Filter
                        </a>
                        @if (($authorize->excel ?? '0') == '1')
                            <button type="button" class="btn btn-outline-success btn-sm mb-0" id="btn_rptstk_excel">
                                <i class="fas fa-file-excel me-1"></i>
                                Excel
                            </button>
                        @endif
                    </div>
                </div>
            </div>
            <div class="card-body pt-3">
                <div class="master-table-wrapper">
                    <table class="table align-items-center mb-0" id="list_rptstk_master">
                        <thead class="thead-light">
                            <tr>
                                <th class="col-no-head">NO</th>
                                <th class="col-bag-head">BAG ID</th>
                                @foreach ($dynamicHeaders as $header)
                                    <th>{{ $header }}</th>
                                @endforeach
                            </tr>
                        </thead>
                        <tbody>
                            @foreach ($rows as $index => $item)
                                <tr>
                                    <td class="col-no">{{ $index + 1 }}</td>
                                    <td class="col-bag">{{ $bagKey !== null ? $item->{$bagKey} ?? '-' : '-' }}</td>

                                    @foreach ($dynamicHeaders as $header)
                                        @php
                                            $cellValue = $item->{$header} ?? '';
                                            $alignClass = '';

                                            if (
                                                stripos((string) $header, 'TOTAL') !== false ||
                                                stripos((string) $header, 'BERAT') !== false ||
                                                stripos((string) $header, 'QTY') !== false
                                            ) {
                                                $alignClass = 'text-end';
                                            }
                                        @endphp

                                        <td class="{{ $alignClass }}">{{ $cellValue }}</td>
                                    @endforeach
                                </tr>
                            @endforeach
                        </tbody>
                    </table>
                </div>
                @if ($rows->isEmpty())
                    <div class="text-center py-3 text-muted">
                        Tidak ada data
                    </div>
                @endif
            </div>
        </div>

        @if ($rows->isNotEmpty())
            <div class="row g-2 mt-2">
                <div class="col-md-4">
                    <div class="summary-card">
                        <div class="label">Total Transaksi</div>
                        <div class="value">{{ number_format($totalTransactions) }}</div>
                    </div>
                </div>
                <div class="col-md-4">
                    <div class="summary-card">
                        <div class="label">Total Bag Unik</div>
                        <div class="value">{{ number_format($totalBags) }}</div>
                    </div>
                </div>
                <div class="col-md-4">
                    <div class="summary-card">
                        <div class="label">Total Berat (Per Bag ID)</div>
                        <div class="value">{{ number_format((float) $totalWeight, 2) }} kg</div>
                    </div>
                </div>
            </div>
        @endif
    </div>
@endsection

@push('js')
    <script>
        $(document).ready(function() {
            const $table = $('#list_rptstk_master');
            const hasRows = {{ $rows->isNotEmpty() ? 'true' : 'false' }};

            if (!hasRows || !$.fn.DataTable) {
                return;
            }

            const dt = $table.DataTable({
                language: {
                    search: 'Cari :',
                    lengthMenu: 'Tampilkan _MENU_ baris',
                    zeroRecords: 'Maaf - Data tidak ada',
                    info: 'Data _START_ - _END_ dari _TOTAL_',
                    infoEmpty: 'Tidak ada data',
                    infoFiltered: '(pencarian dari _MAX_ data)',
                    emptyTable: 'Data tidak ditemukan'
                },
                dom: 'Bfrtip',
                buttons: [{
                    extend: 'excelHtml5',
                    autoFilter: true,
                    sheetName: 'Exported data',
                    exportOptions: {
                        columns: ':visible'
                    }
                }],
                pageLength: 10,
                lengthMenu: [
                    [10, 25, 50, 100],
                    [10, 25, 50, 100]
                ],
                order: [],
                autoWidth: false,
                columnDefs: [{
                    targets: 0,
                    orderable: false,
                    searchable: false
                }]
            });

            $('#btn_rptstk_excel').on('click', function() {
                if (dt && dt.button) {
                    dt.button('.buttons-excel').trigger();
                }
            });
        });
    </script>
@endpush