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

@section('content')
    @include('layouts.navbars.auth.topnav', ['title' => ''])
    <div class="container-fluid py-4">

        <div class="row">
            <div class="col-12">
                <div class="card mb-4">
                    <div class="card-body">
                        <div class="d-flex justify-content-between align-items-center">
                            <h5 class="mb-0">{{ $title_menu }}</h5>
                            <button class="btn btn-secondary btn mb-0" onclick="history.back()">
                                <i class="fas fa-arrow-left me-1"></i> Kembali
                            </button>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        @if ($table_result && $table_result->count() > 0)
            <div class="row">
                <div class="col-xl-4 col-sm-6 mb-4">
                    <div class="card">
                        <div class="card-body p-3">
                            <div class="row">
                                <div class="col-8">
                                    <div class="numbers">
                                        <p class="text-sm mb-0 text-uppercase font-weight-bold">Total Permintaan</p>
                                        <h5 class="font-weight-bolder mb-0">
                                            {{ number_format($kpi['total_permintaan']) }}
                                        </h5>
                                    </div>
                                </div>
                                <div class="col-4 text-end">
                                    <div
                                        class="icon icon-shape bg-gradient-primary shadow-primary text-center rounded-circle">
                                        <i class="ni ni-paper-diploma text-lg opacity-10"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="col-xl-4 col-sm-6 mb-4">
                    <div class="card">
                        <div class="card-body p-3">
                            <div class="row">
                                <div class="col-8">
                                    <div class="numbers">
                                        <p class="text-sm mb-0 text-uppercase font-weight-bold">Total Item</p>
                                        <h5 class="font-weight-bolder mb-0">
                                            {{ number_format($kpi['total_item']) }}
                                        </h5>
                                    </div>
                                </div>
                                <div class="col-4 text-end">
                                    <div
                                        class="icon icon-shape bg-gradient-danger shadow-danger text-center rounded-circle">
                                        <i class="ni ni-box-2 text-lg opacity-10"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="col-xl-4 col-sm-6 mb-4">
                    <div class="card">
                        <div class="card-body p-3">
                            <div class="row">
                                <div class="col-8">
                                    <div class="numbers">
                                        <p class="text-sm mb-0 text-uppercase font-weight-bold">Total Qty Diminta</p>
                                        <h5 class="font-weight-bolder mb-0">
                                            {{ number_format($kpi['total_qty_diminta']) }}
                                        </h5>
                                    </div>
                                </div>
                                <div class="col-4 text-end">
                                    <div
                                        class="icon icon-shape bg-gradient-success shadow-success text-center rounded-circle">
                                        <i class="ni ni-cart text-lg opacity-10"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>

            <div class="row">
                <div class="col-12">
                    <div class="card mb-4">
                        <div class="card-header cursor-pointer" data-bs-toggle="collapse" data-bs-target="#collapseDetail">
                            <div class="d-flex justify-content-between align-items-center">
                                <h6 class="mb-0">Hasil Report Permintaan Barang</h6>
                                <i class="fas fa-chevron-up toggle-icon"></i>
                            </div>
                        </div>
                        <div class="collapse show" id="collapseDetail">
                            <div class="card-body px-0 pt-0 pb-2">
                                <div class="table-responsive p-4 pt-0">
                                    <div class="row mt-3">
                                        <table class="table align-items-center mb-0" id="tableMain">
                                            <thead class="bg-primary text-white">
                                                <tr>
                                                    <th
                                                        class="text-uppercase text-xxs font-weight-bolder opacity-7 text-center">
                                                        Action</th>
                                                    <th class="text-uppercase text-xxs font-weight-bolder opacity-7">
                                                        No
                                                    </th>
                                                    <th class="text-uppercase text-xxs font-weight-bolder opacity-7">
                                                        ID Permintaan
                                                    </th>
                                                    <th class="text-uppercase text-xxs font-weight-bolder opacity-7">
                                                        Tgl
                                                        Pengajuan</th>
                                                    <th class="text-uppercase text-xxs font-weight-bolder opacity-7">
                                                        Tgl
                                                        Completed</th>
                                                    <th class="text-uppercase text-xxs font-weight-bolder opacity-7">
                                                        Departemen</th>
                                                    <th class="text-uppercase text-xxs font-weight-bolder opacity-7">
                                                        Pengaju
                                                    </th>
                                                    <th
                                                        class="text-uppercase text-xxs font-weight-bolder opacity-7 text-center">
                                                        Total Item</th>
                                                    <th
                                                        class="text-uppercase text-xxs font-weight-bolder opacity-7 text-center">
                                                        Qty Diminta</th>
                                                    <th class="text-uppercase text-xxs font-weight-bolder opacity-7">
                                                        Approval Head</th>
                                                    <th class="text-uppercase text-xxs font-weight-bolder opacity-7">
                                                        Approval Admin</th>

                                                </tr>
                                            </thead>
                                            <tbody>
                                                @foreach ($table_result as $row)
                                                    <tr @if ($row->status === 'rejected') class="table-danger" @endif>
                                                        <td class="text-center">
                                                            <button class="btn btn-link text-info btn-sm mb-0"
                                                                data-bs-toggle="modal"
                                                                data-bs-target="#modalDetail{{ $row->id }}">
                                                                <i class="fas fa-eye me-1"></i> Detail
                                                            </button>
                                                        </td>
                                                        <td class="text-xs font-weight-bold ps-3">{{ $loop->iteration }}
                                                        </td>
                                                        <td class="text-xs">{{ $row->id }}</td>

                                                        <td class="text-xs">
                                                            {{ date('d/m/Y', strtotime($row->tanggal_pengajuan)) }}
                                                        </td>
                                                        <td class="text-xs">
                                                            {{ date('d/m/Y', strtotime($row->tanggal_completed)) }}
                                                        </td>
                                                        <td class="text-xs">{{ $row->departemen_nama }}</td>
                                                        <td class="text-xs">{{ $row->user_nama }}</td>
                                                        <td class="text-xs text-center">{{ $row->total_item }}</td>
                                                        <td class="text-xs text-center">
                                                            {{ number_format($row->total_qty_diminta) }}
                                                        </td>
                                                        <td class="text-xs">
                                                            @if (isset($approval_head[$row->id]))
                                                                @php $head = $approval_head[$row->id]->first(); @endphp
                                                                {{ $head->head_nama }}<br>
                                                                <small
                                                                    class="text-muted">{{ date('d/m/Y', strtotime($head->tanggal_approve)) }}</small>
                                                            @else
                                                                <span class="text-muted">-</span>
                                                            @endif
                                                        </td>
                                                        <td class="text-xs">
                                                            @if (isset($approval_admin[$row->id]))
                                                                @php $admin = $approval_admin[$row->id]->first(); @endphp
                                                                {{ $admin->admin_nama }}<br>
                                                                <small
                                                                    class="text-muted">{{ date('d/m/Y', strtotime($admin->tanggal_approve)) }}</small>
                                                            @else
                                                                <span class="text-muted">-</span>
                                                            @endif
                                                        </td>

                                                    </tr>
                                                @endforeach
                                            </tbody>
                                        </table>
                                    </div>
                                    <div class="mt-2">
                                        <code>Note :
                                            <i aria-hidden="true" style="color:#ffc2cd;" class="fas fa-circle"></i> Data Rejected
                                        </code>
                                    </div>
                                </div>
                                
                            </div>
                            
                        </div>
                        
                    </div>
                    
                </div>
                
            </div>

            <div class="row">
                <div class="col-12">
                    <div class="card mb-4">
                        <div class="card-header cursor-pointer" data-bs-toggle="collapse" data-bs-target="#collapseCharts">
                            <div class="d-flex justify-content-between align-items-center">
                                <h6 class="mb-0">Grafik Analisa Top 10 Barang</h6>
                                <i class="fas fa-chevron-down toggle-icon"></i>
                            </div>
                        </div>
                        <div class="collapse" id="collapseCharts">
                            <div class="card-body">
                                <div class="row">
                                    <div class="col-lg-6 mb-4">
                                        <div class="card h-100">
                                            <div class="card-header pb-0">
                                                <h6>Top 10 Barang Paling Banyak Diminta</h6>
                                            </div>
                                            <div class="card-body">
                                                <div id="chartTopBarang" style="height: 400px;"></div>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-lg-6 mb-4">
                                        <div class="card h-100">
                                            <div class="card-header pb-0">
                                                <h6>Top 10 Barang: Diminta vs Disetujui</h6>
                                            </div>
                                            <div class="card-body">
                                                <div id="chartComparison" style="height: 400px;"></div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>

            <div class="row">
                <div class="col-12">
                    <div class="card mb-4">
                        <div class="card-header cursor-pointer" data-bs-toggle="collapse"
                            data-bs-target="#collapseTrend">
                            <div class="d-flex justify-content-between align-items-center">
                                <h6 class="mb-0">Trend & Distribusi Permintaan</h6>
                                <i class="fas fa-chevron-down toggle-icon"></i>
                            </div>
                        </div>
                        <div class="collapse" id="collapseTrend">
                            <div class="card-body">
                                <div class="row">
                                    <div class="col-lg-6 mb-4">
                                        <div class="card h-100">
                                            <div class="card-header pb-0">
                                                <h6>Trend Permintaan Harian</h6>
                                            </div>
                                            <div class="card-body">
                                                <div id="chartTrend" style="height: 400px;"></div>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-lg-6 mb-4">
                                        <div class="card h-100">
                                            <div class="card-header pb-0">
                                                <h6>Distribusi Permintaan per Departemen</h6>
                                            </div>
                                            <div class="card-body">
                                                <div id="chartDepartemen" style="height: 400px;"></div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>

            @foreach ($table_result as $row)
                <div class="modal fade" id="modalDetail{{ $row->id }}" tabindex="-1" aria-hidden="true">
                    <div class="modal-dialog modal-xl modal-dialog-centered modal-dialog-scrollable">
                        <div class="modal-content">
                            <div class="modal-header bg-gradient-primary">
                                <h5 class="modal-title text-white">
                                    <i class="fas fa-box me-2"></i>
                                    Detail Item Permintaan - {{ $row->departemen_nama }}
                                </h5>
                                <button type="button" class="btn-close" data-bs-dismiss="modal"
                                    aria-label="Close"></button>
                            </div>
                            <div class="modal-body">
                                <div class="row mb-3">
                                    <div class="col-md-6">
                                        <p class="text-sm mb-1"><strong>Tanggal Pengajuan:</strong>
                                            {{ date('d/m/Y', strtotime($row->tanggal_pengajuan)) }}</p>
                                        <p class="text-sm mb-1"><strong>Tanggal Completed:</strong>
                                            {{ date('d/m/Y', strtotime($row->tanggal_completed)) }}</p>
                                    </div>
                                    <div class="col-md-6">
                                        <p class="text-sm mb-1"><strong>User:</strong> {{ $row->user_nama }}</p>
                                        <p class="text-sm mb-1"><strong>Total Item:</strong> {{ $row->total_item }}</p>
                                    </div>
                                </div>
                                <hr>
                                <h6 class="text-sm mb-3">Daftar Item Barang</h6>
                                <div class="table-responsive">
                                    <table class="table table-sm table-bordered table-hover align-items-center mb-0">
                                        <thead class="thead-light">
                                            <tr>
                                                <th class="text-xs">No</th>
                                                <th class="text-xs">Nama Barang</th>
                                                <th class="text-xs text-center">Qty Diminta</th>
                                                <th class="text-xs text-center">Qty Disetujui</th>
                                                <th class="text-xs">UOM</th>
                                                <th class="text-xs">Penerima</th>
                                                <th class="text-xs">Keterangan</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            @if (isset($items[$row->id]))
                                                @foreach ($items[$row->id] as $item)
                                                    <tr>
                                                        <td class="text-xs">{{ $loop->iteration }}</td>
                                                        <td class="text-xs">
                                                            {{ $item->nama_barang ?? $item->nama_barang_master }}</td>
                                                        <td class="text-xs text-center">
                                                            <span
                                                                class="badge badge-sm bg-gradient-info">{{ $item->qty_diminta }}</span>
                                                        </td>
                                                        <td class="text-xs text-center">
                                                            <span
                                                                class="badge badge-sm bg-gradient-success">{{ $item->qty_disetujui }}</span>
                                                        </td>
                                                        <td class="text-xs">{{ $item->unit_name ?? '-' }}</td>

                                                        <td class="text-xs">
                                                            {{ $item->penerima_nama ?? ($item->penerima ?? '-') }}
                                                        </td>
                                                        <td class="text-xs">{{ $item->keterangan ?? '-' }}</td>
                                                    </tr>
                                                @endforeach
                                            @else
                                                <tr>
                                                    <td colspan="8" class="text-center text-xs text-muted py-3">
                                                        <i class="fas fa-inbox fa-2x mb-2"></i><br>
                                                        Tidak ada data item
                                                    </td>
                                                </tr>
                                            @endif
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                            <div class="modal-footer">
                                <button type="button" class="btn btn-secondary btn-sm"
                                    data-bs-dismiss="modal">Tutup</button>
                            </div>
                        </div>
                    </div>
                </div>
            @endforeach

            <div class="row">
                <div class="col-12">
                    <div class="card mb-4">
                        <div class="card-header cursor-pointer" data-bs-toggle="collapse"
                            data-bs-target="#collapseTopBarang">
                            <div class="d-flex justify-content-between align-items-center">
                                <h6 class="mb-0">Tabel Top 10 Barang Paling Banyak Diminta</h6>
                                <i class="fas fa-chevron-down toggle-icon"></i>
                            </div>
                        </div>
                        <div class="collapse" id="collapseTopBarang">
                            <div class="card-body px-0 pt-0 pb-2">
                                <div class="table-responsive p-4">
                                    <table class="table align-items-center mb-0" id="tableTopBarang">
                                        <thead class="bg-primary text-white">
                                            <tr>
                                                <th class="text-uppercas text-xxs font-weight-bolder opacity-7">
                                                    No
                                                </th>
                                                <th class="text-uppercas text-xxs font-weight-bolder opacity-7">
                                                    Nama
                                                    Barang</th>
                                                <th
                                                    class="text-uppercas text-xxs font-weight-bolder opacity-7 text-center">
                                                    Frekuensi</th>
                                                <th
                                                    class="text-uppercas text-xxs font-weight-bolder opacity-7 text-center">
                                                    Total Diminta</th>
                                                <th
                                                    class="text-uppercas text-xxs font-weight-bolder opacity-7 text-center">
                                                    Total Disetujui</th>
                                                <th
                                                    class="text-uppercas text-xxs font-weight-bolder opacity-7 text-center">
                                                    Total Ditolak</th>
                                                <th
                                                    class="text-uppercas text-xxs font-weight-bolder opacity-7 text-center">
                                                    Stock Saat Ini</th>
                                                <th
                                                    class="text-uppercas text-xxs font-weight-bolder opacity-7 text-center">
                                                    Status</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            @foreach ($top_barang as $barang)
                                                <tr>
                                                    <td class="text-xs font-weight-bold ps-4">{{ $loop->iteration }}</td>
                                                    <td class="text-xs">{{ $barang['nama_barang'] }}</td>
                                                    <td class="text-xs text-center">{{ $barang['frekuensi'] }}x</td>
                                                    <td class="text-xs text-center">
                                                        {{ number_format($barang['total_qty_diminta']) }}
                                                    </td>
                                                    <td class="text-xs text-center">
                                                        {{ number_format($barang['total_qty_disetujui']) }}
                                                    </td>
                                                    <td class="text-xs text-center">
                                                        {{ number_format($barang['total_qty_ditolak']) }}
                                                    </td>
                                                    <td class="text-xs text-center font-weight-bold">
                                                        {{ number_format($barang['stock_saat_ini']) }}
                                                    </td>
                                                    <td class="text-xs text-center">
                                                        @if ($barang['stock_saat_ini'] <= 0)
                                                            <span class="badge badge-sm bg-secondary">Habis</span>
                                                        @elseif($barang['stock_saat_ini'] <= 10)
                                                            <span class="badge badge-sm bg-danger">Kritis</span>
                                                        @elseif($barang['stock_saat_ini'] <= 20)
                                                            <span class="badge badge-sm bg-warning">Menipis</span>
                                                        @else
                                                            <span class="badge badge-sm bg-success">Aman</span>
                                                        @endif
                                                    </td>
                                                </tr>
                                            @endforeach
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>

            <div class="row">
                <div class="col-12">
                    <div class="card mb-4">
                        <div class="card-header cursor-pointer" data-bs-toggle="collapse"
                            data-bs-target="#collapseStatDept">
                            <div class="d-flex justify-content-between align-items-center">
                                <h6 class="mb-0">Tabel Statistik per Departemen</h6>
                                <i class="fas fa-chevron-down toggle-icon"></i>
                            </div>
                        </div>
                        <div class="collapse" id="collapseStatDept">
                            <div class="card-body px-0 pt-0 pb-2">
                                <div class="table-responsive p-4">
                                    <table class="table align-items-center mb-0" id="tableStatDept">
                                        <thead class="bg-primary text-white">
                                            <tr>
                                                <th class="text-uppercase text-xxs font-weight-bolder opacity-7">
                                                    No
                                                </th>
                                                <th class="text-uppercase text-xxs font-weight-bolder opacity-7">
                                                    Departemen</th>
                                                <th
                                                    class="text-uppercase text-xxs font-weight-bolder opacity-7 text-center">
                                                    Total Permintaan</th>
                                                <th
                                                    class="text-uppercase text-xxs font-weight-bolder opacity-7 text-center">
                                                    Total Item</th>
                                                <th
                                                    class="text-uppercase text-xxs font-weight-bolder opacity-7 text-center">
                                                    Total Qty Diminta</th>
                                                <th
                                                    class="text-uppercase text-xxs font-weight-bolder opacity-7 text-center">
                                                    Total Qty Disetujui</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            @foreach ($stat_departemen as $dept)
                                                <tr>
                                                    <td class="text-xs font-weight-bold ps-4">{{ $loop->iteration }}</td>
                                                    <td class="text-xs">{{ $dept['departemen_nama'] }}</td>
                                                    <td class="text-xs text-center">
                                                        {{ number_format($dept['total_permintaan']) }}
                                                    </td>
                                                    <td class="text-xs text-center">
                                                        {{ number_format($dept['total_item']) }}</td>
                                                    <td class="text-xs text-center">
                                                        {{ number_format($dept['total_qty_diminta']) }}
                                                    </td>
                                                    <td class="text-xs text-center">
                                                        {{ number_format($dept['total_qty_disetujui']) }}
                                                    </td>
                                                </tr>
                                            @endforeach
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>

            <div class="row">
                <div class="col-12">
                    <div class="card mb-4">
                        <div class="card-header cursor-pointer" data-bs-toggle="collapse"
                            data-bs-target="#collapseTopUser">
                            <div class="d-flex justify-content-between align-items-center">
                                <h6 class="mb-0">Tabel Top 10 Penerima Paling Banyak Permintaan Barang</h6>
                                <i class="fas fa-chevron-down toggle-icon"></i>
                            </div>
                        </div>
                        <div class="collapse" id="collapseTopUser">
                            <div class="card-body px-0 pt-0 pb-2">
                                <div class="table-responsive p-4">
                                    <table class="table align-items-center mb-0" id="tableTopUser">
                                        <thead class="bg-primary text-white">
                                            <tr>
                                                <th class="text-uppercase text-xxs font-weight-bolder opacity-7">
                                                    No
                                                </th>
                                                <th class="text-uppercase text-xxs font-weight-bolder opacity-7">
                                                    Penerima</th>
                                                <th class="text-uppercase text-xxs font-weight-bolder opacity-7">
                                                    Departemen</th>
                                                <th
                                                    class="text-uppercase text-xxs font-weight-bolder opacity-7 text-center">
                                                    Total Permintaan</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            @foreach ($top_user as $user)
                                                <tr>
                                                    <td class="text-xs font-weight-bold ps-4">{{ $loop->iteration }}</td>
                                                    <td class="text-xs">{{ $user['user_nama'] }}</td>
                                                    <td class="text-xs">{{ $user['departemen'] }}</td>
                                                    <td class="text-xs text-center">
                                                        {{ number_format($user['total_permintaan']) }}
                                                    </td>
                                                </tr>
                                            @endforeach
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        @else
            <div class="row">
                <div class="col-12">
                    <div class="card">
                        <div class="card-body text-center py-5">
                            <i class="fas fa-inbox fa-4x text-secondary mb-3"></i>
                            <h5>Tidak Ada Data</h5>
                            <p class="text-muted">Tidak ada data permintaan barang yang completed pada periode yang
                                dipilih.</p>
                        </div>
                    </div>
                </div>
            </div>
        @endif

    </div>
    <div class="modal fade" id="modalDetailBarang" tabindex="-1" aria-hidden="true">
        <div class="modal-dialog modal-lg modal-dialog-centered modal-dialog-scrollable">
            <div class="modal-content">
                <div class="modal-header bg-info">
                    <h5 class="modal-title text-white"><i class="fas fa-box me-2"></i> Detail Permintaan - <span
                            id="modalBarangNama"></span></h5>
                    <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
                </div>
                <div class="modal-body">
                    <div class="mb-2">
                        <span class="badge bg-info me-1">Frekuensi: <strong id="modalBarangFrekuensi"></strong></span>
                        <span class="badge bg-primary me-1">Total Diminta: <strong
                                id="modalBarangDiminta"></strong></span>
                        <span class="badge bg-success me-1">Total Disetujui: <strong
                                id="modalBarangDisetujui"></strong></span>
                        <span class="badge bg-warning me-1">Total Ditolak: <strong
                                id="modalBarangDitolak"></strong></span>
                        <span class="badge bg-secondary">Stock: <strong id="modalBarangStock"></strong></span>
                    </div>
                    <hr>
                    <h6 class="text-sm">Riwayat Permintaan Barang Ini</h6>
                    <div class="table-responsive">
                        <table class="table table-sm table-bordered table-hover mb-0" id="tableModalBarang">
                            <thead class="thead-light">
                                <tr>
                                    <th class="text-xs">No</th>
                                    <th class="text-xs">ID Permintaan</th>
                                    <th class="text-xs">Tgl Pengajuan</th>
                                    <th class="text-xs">Tgl Completed</th>
                                    <th class="text-xs">Departemen</th>
                                    <th class="text-xs">Penerima</th>
                                    <th class="text-xs text-center">Qty Diminta</th>
                                    <th class="text-xs text-center">Qty Disetujui</th>
                                   
                                    <th class="text-xs">Keterangan</th>
                                </tr>
                            </thead>
                            <tbody id="bodyModalBarang"></tbody>
                        </table>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary btn-sm" data-bs-dismiss="modal">Tutup</button>
                </div>
            </div>
        </div>
    </div>

    <div class="modal fade" id="modalDetailDept" tabindex="-1" aria-hidden="true">
        <div class="modal-dialog modal-lg modal-dialog-centered modal-dialog-scrollable">
            <div class="modal-content">
                <div class="modal-header bg-info">
                    <h5 class="modal-title text-white"><i class="fas fa-building me-2"></i> Detail Permintaan - <span
                            id="modalDeptNama"></span></h5>
                    <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
                </div>
                <div class="modal-body">
                    <div class="mb-2">
                        <span class="badge bg-primary me-1">Total Permintaan: <strong id="modalDeptTotal"></strong></span>
                        <span class="badge bg-info me-1">Total Item: <strong id="modalDeptItem"></strong></span>
                        <span class="badge bg-success me-1">Qty Diminta: <strong id="modalDeptDiminta"></strong></span>
                        <span class="badge bg-warning">Qty Disetujui: <strong id="modalDeptDisetujui"></strong></span>
                    </div>
                    <hr>
                    <h6 class="text-sm">Daftar Permintaan Departemen Ini</h6>
                    <div class="table-responsive">
                        <table class="table table-sm table-bordered table-hover mb-0" id="tableModalDept">
                            <thead class="thead-light">
                                <tr>
                                    <th class="text-xs">No</th>
                                    <th class="text-xs">ID</th>
                                    <th class="text-xs">Tgl Pengajuan</th>
                                    <th class="text-xs">Tgl Completed</th>
                                    <th class="text-xs">Penerima</th>
                                    <th class="text-xs text-center">Total Item</th>
                                    <th class="text-xs text-center">Qty Diminta</th>
                                </tr>
                            </thead>
                            <tbody id="bodyModalDept"></tbody>
                        </table>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary btn-sm" data-bs-dismiss="modal">Tutup</button>
                </div>
            </div>
        </div>
    </div>

    <div class="modal fade" id="modalDetailStock" tabindex="-1" aria-hidden="true">
        <div class="modal-dialog modal-lg modal-dialog-centered modal-dialog-scrollable">
            <div class="modal-content">
                <div class="modal-header bg-info">
                    <h5 class="modal-title text-white"><i class="fas fa-exclamation-triangle me-2"></i> Analisa Stock -
                        <span id="modalStockNama"></span>
                    </h5>
                    <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
                </div>
                <div class="modal-body">
                    <div class="mb-2">
                        <span class="badge bg-secondary me-1">Stock Saat Ini: <strong
                                id="modalStockJumlah"></strong></span>
                        <span class="badge bg-primary me-1">Total Diminta: <strong id="modalStockDiminta"></strong></span>
                        <span id="modalStockBadge"></span>
                    </div>
                    <hr>
                    <h6 class="text-sm">Riwayat Permintaan Barang Ini</h6>
                    <div class="table-responsive">
                        <table class="table table-sm table-bordered table-hover mb-0" id="tableModalStock">
                            <thead class="thead-light">
                                <tr>
                                    <th class="text-xs">No</th>
                                    <th class="text-xs">ID Permintaan</th>
                                    <th class="text-xs">Tgl Pengajuan</th>
                                    <th class="text-xs">Tgl Completed</th>
                                    <th class="text-xs">Departemen</th>
                                    <th class="text-xs">User</th>
                                    <th class="text-xs text-center">Qty Diminta</th>
                                    <th class="text-xs text-center">Qty Disetujui</th>
                                </tr>
                            </thead>
                            <tbody id="bodyModalStock"></tbody>
                        </table>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary btn-sm" data-bs-dismiss="modal">Tutup</button>
                </div>
            </div>
        </div>
    </div>

    <div class="modal fade" id="modalDetailUser" tabindex="-1" aria-hidden="true">
        <div class="modal-dialog modal-xl modal-dialog-centered modal-dialog-scrollable">
            <div class="modal-content">
                <div class="modal-header bg-info">
                    <h5 class="modal-title text-white"><i class="fas fa-user me-2"></i> Detail Penerima - <span
                            id="modalUserNama"></span></h5>
                    <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
                </div>
                <div class="modal-body">
    <div class="mb-2">
        <span class="badge bg-warning me-1">Total Qty Diminta: <strong id="modalUserDiminta"></strong></span>
    </div>
    <hr>
    <h6 class="text-sm">Daftar Barang yang Diminta Penerima Ini</h6>
    <div class="table-responsive">
        <table class="table table-sm table-bordered table-hover mb-0" id="tableModalUser">
            <thead class="thead-light">
                <tr>
                    <th class="text-xs">No</th>
                    <th class="text-xs">ID Permintaan</th>
                    <th class="text-xs">Tgl Pengajuan</th>
                    <th class="text-xs">Tgl Completed</th>
                    <th class="text-xs">Nama Barang</th>
                    <th class="text-xs text-center">Qty Diminta</th>
                    <th class="text-xs text-center">Qty Disetujui</th>
                    <th class="text-xs">Keterangan</th>
                </tr>
            </thead>
            <tbody id="bodyModalUser"></tbody>
        </table>
    </div>
</div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary btn-sm" data-bs-dismiss="modal">Tutup</button>
                </div>
            </div>
        </div>
    </div>
@endsection

@push('js')
    <script src="{{ asset('/') }}assets/js/vendor/echarts.min.js"></script>

    <script>
        $(document).ready(function() {

            @if ($table_result && $table_result->count() > 0)


                var tableMain = $('#tableMain').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)"
                    },
                    "order": [
                        [1, "asc"]
                    ],
                    "pageLength": 25,
                    "createdRow": function(row, data, dataIndex) {
                        if ($(row).hasClass('detail-row')) {
                            return false;
                        }
                    }
                });

                $('#tableTopBarang, #tableStatDept, #tableStockKritis, #tableTopUser').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)"
                    },

                    "pageLength": 10,
                    "info": false
                });


                let chartTopBarang = echarts.init(document.getElementById('chartTopBarang'));
                let topBarangData = @json($top_barang);

                let optionTopBarang = {
                    tooltip: {
                        trigger: 'axis',
                        axisPointer: {
                            type: 'shadow'
                        }
                    },
                    grid: {
                        left: '3%',
                        right: '4%',
                        bottom: '3%',
                        containLabel: true
                    },
                    xAxis: {
                        type: 'value',
                        name: 'Total Qty Diminta'
                    },
                    yAxis: {
                        type: 'category',
                        data: topBarangData.map(item => item.nama_barang).reverse(),
                        axisLabel: {
                            fontSize: 10,
                            formatter: function(value) {
                                return value.length > 20 ? value.substring(0, 20) + '...' : value;
                            }
                        }
                    },
                    series: [{
                        name: 'Qty Diminta',
                        type: 'bar',
                        data: topBarangData.map(item => item.total_qty_diminta).reverse(),
                        itemStyle: {
                            color: function(params) {
                                let colors = ['#5470c6', '#91cc75', '#fac858', '#ee6666', '#73c0de',
                                    '#3ba272', '#fc8452', '#9a60b4', '#ea7ccc', '#d4a35f'
                                ];
                                return colors[params.dataIndex % colors.length];
                            }
                        },
                        label: {
                            show: true,
                            position: 'right',
                            formatter: '{c}'
                        }
                    }]
                };
                chartTopBarang.setOption(optionTopBarang);

                let chartDepartemen = echarts.init(document.getElementById('chartDepartemen'));
                let statDeptData = @json($stat_departemen);

                let optionDepartemen = {
                    tooltip: {
                        trigger: 'item',
                        formatter: '{a} <br/>{b}: {c} ({d}%)'
                    },
                    legend: {
                        orient: 'horizontal',
                        top: 'bottom',
                        formatter: function(name) {
                            return name.length > 15 ? name.substring(0, 15) + '...' : name;
                        }
                    },
                    series: [{
                        name: 'Permintaan',
                        type: 'pie',
                        radius: ['20%', '50%'],
                        avoidLabelOverlap: false,
                        itemStyle: {
                            borderRadius: 10,
                            borderColor: '#fff',
                            borderWidth: 2
                        },
                        label: {
                            show: true,
                            position: 'outside',
                            formatter: '{b}: {c}'

                        },
                        emphasis: {
                            label: {
                                show: true,
                                fontSize: 20,
                                fontWeight: 'bold'
                            }
                        },
                        labelLine: {
                            show: true
                        },
                        data: statDeptData.map(item => ({
                            value: item.total_permintaan,
                            name: item.departemen_nama
                        }))
                    }]
                };
                chartDepartemen.setOption(optionDepartemen);

                let chartTrend = echarts.init(document.getElementById('chartTrend'));
                let trendData = @json($trend_permintaan);

                let optionTrend = {
                    tooltip: {
                        trigger: 'axis'
                    },
                    grid: {
                        left: '3%',
                        right: '4%',
                        bottom: '3%',
                        containLabel: true
                    },
                    xAxis: {
                        type: 'category',
                        boundaryGap: false,
                        data: trendData.map(item => {
                            let date = new Date(item.tanggal);
                            return date.toLocaleDateString('id-ID', {
                                day: '2-digit',
                                month: 'short'
                            });
                        })
                    },
                    yAxis: {
                        type: 'value',
                        name: 'Jumlah'
                    },
                    series: [{
                        name: 'Permintaan',
                        type: 'line',
                        smooth: true,
                        areaStyle: {
                            color: 'rgba(84, 112, 198, 0.2)'
                        },
                        itemStyle: {
                            color: '#5470c6'
                        },
                        data: trendData.map(item => item.jumlah)
                    }]
                };
                chartTrend.setOption(optionTrend);

                let chartComparison = echarts.init(document.getElementById('chartComparison'));

                let optionComparison = {
                    tooltip: {
                        trigger: 'axis',
                        axisPointer: {
                            type: 'shadow'
                        }
                    },
                    legend: {
                        data: ['Qty Diminta', 'Qty Disetujui']
                    },
                    grid: {
                        left: '3%',
                        right: '4%',
                        bottom: '3%',
                        containLabel: true
                    },
                    xAxis: {
                        type: 'category',
                        data: topBarangData.slice(0, 10).map(item => {
                            return item.nama_barang.length > 15 ? item.nama_barang.substring(0, 15) +
                                '...' : item.nama_barang;
                        }),
                        axisLabel: {
                            rotate: 45,
                            fontSize: 9
                        }
                    },
                    yAxis: {
                        type: 'value',
                        name: 'Quantity'
                    },
                    series: [{
                            name: 'Qty Diminta',
                            type: 'bar',
                            data: topBarangData.slice(0, 10).map(item => item.total_qty_diminta),
                            itemStyle: {
                                color: '#5470c6'
                            }
                        },
                        {
                            name: 'Qty Disetujui',
                            type: 'bar',
                            data: topBarangData.slice(0, 10).map(item => item.total_qty_disetujui),
                            itemStyle: {
                                color: '#91cc75'
                            }
                        }
                    ]
                };
                chartComparison.setOption(optionComparison);



                document.querySelectorAll('[id^="collapse"]').forEach(function(collapseEl) {
                    collapseEl.addEventListener('shown.bs.collapse', function() {
                        setTimeout(() => {
                            if (typeof chartTopBarang !== 'undefined') chartTopBarang
                                .resize();
                            if (typeof chartDepartemen !== 'undefined') chartDepartemen
                                .resize();
                            if (typeof chartTrend !== 'undefined') chartTrend.resize();
                            if (typeof chartComparison !== 'undefined') chartComparison
                                .resize();
                        }, 300);
                    });
                });

                window.addEventListener('resize', function() {
                    chartTopBarang.resize();
                    chartDepartemen.resize();
                    chartTrend.resize();
                    chartComparison.resize();
                });
            @endif

        });
        document.querySelectorAll('.collapse').forEach(function(collapseEl) {

            collapseEl.addEventListener('show.bs.collapse', function() {
                let icon = this.previousElementSibling.querySelector('.toggle-icon');
                if (icon) {
                    icon.classList.remove('fa-chevron-down');
                    icon.classList.add('fa-chevron-up');
                }
            });

            collapseEl.addEventListener('hide.bs.collapse', function() {
                let icon = this.previousElementSibling.querySelector('.toggle-icon');
                if (icon) {
                    icon.classList.remove('fa-chevron-up');
                    icon.classList.add('fa-chevron-down');
                }
            });

        });

        const allItems = @json($items);
        const tableResult = @json($table_result);
        const topBarangData2 = @json($top_barang);
        const statDeptData2 = @json($stat_departemen);
        const stockKritisData = @json($stock_kritis);

        function fmtDate(str) {
            if (!str) return '-';
            let d = new Date(str);
            return ('0' + d.getDate()).slice(-2) + '/' + ('0' + (d.getMonth() + 1)).slice(-2) + '/' + d.getFullYear();
        }

        function buildItemRows(barangId) {
            let rows = [];
            tableResult.forEach(pb => {
                let pbId = pb.id;
                let pbItems = allItems[pbId] || [];
                pbItems.forEach(item => {
                    if (item.barang_id == barangId) {
                        rows.push({
                            pb,
                            item
                        });
                    }
                });
            });
            return rows;
        }

        $('#tableTopBarang tbody').on('click', 'tr', function() {
            let idx = $(this).index();
            let dtRow = $('#tableTopBarang').DataTable().row(this).index();
            let namaBarang = $(this).find('td').eq(1).text().trim();
            let barang = topBarangData2.find(b => b.nama_barang === namaBarang);
            if (!barang) return;

            $('#modalBarangNama').text(barang.nama_barang);
            $('#modalBarangFrekuensi').text(barang.frekuensi + 'x');
            $('#modalBarangDiminta').text(Number(barang.total_qty_diminta).toLocaleString('id-ID'));
            $('#modalBarangDisetujui').text(Number(barang.total_qty_disetujui).toLocaleString('id-ID'));
            $('#modalBarangDitolak').text(Number(barang.total_qty_ditolak).toLocaleString('id-ID'));
            $('#modalBarangStock').text(Number(barang.stock_saat_ini).toLocaleString('id-ID'));

            let rows = buildItemRows(barang.barang_id);
            let html = '';
            if (rows.length === 0) {
                html = '<tr><td colspan="10" class="text-center text-muted py-3">Tidak ada data</td></tr>';
            } else {
                rows.forEach((r, i) => {
                    html += `<tr>
                    <td class="text-xs">${i + 1}</td>
                    <td class="text-xs">${r.pb.id}</td>
                    <td class="text-xs">${fmtDate(r.pb.tanggal_pengajuan)}</td>
                    <td class="text-xs">${fmtDate(r.pb.tanggal_completed)}</td>
                    <td class="text-xs">${r.pb.departemen_nama ?? '-'}</td>
                    <td class="text-xs">${r.item.penerima_nama || r.item.penerima || '-'}</td>
                    <td class="text-xs text-center"><span class="badge bg-gradient-info">${r.item.qty_diminta}</span></td>
                    <td class="text-xs text-center"><span class="badge bg-gradient-success">${r.item.qty_disetujui}</span></td>
                    
                    <td class="text-xs">${r.item.keterangan ?? '-'}</td>
                </tr>`;
                });
            }
            $('#bodyModalBarang').html(html);
            new bootstrap.Modal(document.getElementById('modalDetailBarang')).show();
        });

        $('#tableTopBarang tbody').css('cursor', 'pointer');

        $('#tableStatDept tbody').on('click', 'tr', function() {
            let namaDept = $(this).find('td').eq(1).text().trim();
            let dept = statDeptData2.find(d => d.departemen_nama === namaDept);
            if (!dept) return;

            $('#modalDeptNama').text(dept.departemen_nama);
            $('#modalDeptTotal').text(Number(dept.total_permintaan).toLocaleString('id-ID'));
            $('#modalDeptItem').text(Number(dept.total_item).toLocaleString('id-ID'));
            $('#modalDeptDiminta').text(Number(dept.total_qty_diminta).toLocaleString('id-ID'));
            $('#modalDeptDisetujui').text(Number(dept.total_qty_disetujui).toLocaleString('id-ID'));

            let pbDept = tableResult.filter(pb => pb.departemen_nama === namaDept);
            let html = '';
            if (pbDept.length === 0) {
                html = '<tr><td colspan="7" class="text-center text-muted py-3">Tidak ada data</td></tr>';
            } else {
                pbDept.forEach((pb, i) => {
                    html += `<tr>
                    <td class="text-xs">${i + 1}</td>
                    <td class="text-xs">${pb.id}</td>
                    <td class="text-xs">${fmtDate(pb.tanggal_pengajuan)}</td>
                    <td class="text-xs">${fmtDate(pb.tanggal_completed)}</td>
                    <td class="text-xs">${(() => {
                        let pbItems = allItems[pb.id] || [];
                        let penerima = pbItems.map(i => i.penerima_nama || i.penerima).filter(Boolean);
                        let unique = [...new Set(penerima)];
                        return unique.length > 0 ? unique.join(', ') : '-';
                    })()}</td>
                    <td class="text-xs text-center">${pb.total_item}</td>
                    <td class="text-xs text-center">${Number(pb.total_qty_diminta).toLocaleString('id-ID')}</td>
                </tr>`;
                });
            }
            $('#bodyModalDept').html(html);
            new bootstrap.Modal(document.getElementById('modalDetailDept')).show();
        });

        $('#tableStatDept tbody').css('cursor', 'pointer')
        $('#tableStockKritis tbody').on('click', 'tr', function() {
            let namaBarang = $(this).find('td').eq(1).text().trim();
            let stock = stockKritisData.find(s => s.nama_barang === namaBarang);
            if (!stock) return;

            $('#modalStockNama').text(stock.nama_barang);
            $('#modalStockJumlah').text(Number(stock.stock_saat_ini).toLocaleString('id-ID'));
            $('#modalStockDiminta').text(Number(stock.total_diminta).toLocaleString('id-ID'));
            $('#modalStockBadge').html(`<span class="badge bg-${stock.status_class}">${stock.status}</span>`);

            let rows = buildItemRows(stock.barang_id);
            let html = '';
            if (rows.length === 0) {
                html =
                    '<tr><td colspan="8" class="text-center text-muted py-3">Tidak ada data riwayat permintaan</td></tr>';
            } else {
                rows.forEach((r, i) => {
                    html += `<tr>
                    <td class="text-xs">${i + 1}</td>
                    <td class="text-xs">${r.pb.id}</td>
                    <td class="text-xs">${fmtDate(r.pb.tanggal_pengajuan)}</td>
                    <td class="text-xs">${fmtDate(r.pb.tanggal_completed)}</td>
                    <td class="text-xs">${r.pb.departemen_nama ?? '-'}</td>
                    <td class="text-xs">${r.pb.user_nama ?? '-'}</td>
                    <td class="text-xs text-center"><span class="badge bg-gradient-info">${r.item.qty_diminta}</span></td>
                    <td class="text-xs text-center"><span class="badge bg-gradient-success">${r.item.qty_disetujui}</span></td>
                </tr>`;
                });
            }
            $('#bodyModalStock').html(html);
            new bootstrap.Modal(document.getElementById('modalDetailStock')).show();
        });

        $('#tableStockKritis tbody').css('cursor', 'pointer');

        const topUserData2 = @json($top_user);

        $('#tableTopUser tbody').on('click', 'tr', function() {
    let namaUser = $(this).find('td').eq(1).text().trim();
    let user = topUserData2.find(u => u.user_nama === namaUser);
    if (!user) return;

    $('#modalUserNama').text(user.user_nama);
    $('#modalUserTotal').text(Number(user.total_permintaan).toLocaleString('id-ID'));
    $('#modalUserDiminta').text(Number(user.total_qty_diminta).toLocaleString('id-ID'));
    $('#modalUserAvgWaktu').text(user.avg_waktu_proses);

    let html = '';
    let no = 1;
    let permintaanIds = user.permintaan_barang_id || [];

    permintaanIds.forEach(pbId => {
        let pb = tableResult.find(p => p.id === pbId);
        let pbItems = allItems[pbId] || [];

        let filtered = pbItems.filter(item =>
            (item.penerima_nama || item.penerima) === user.user_nama
        );

        filtered.forEach(item => {
            html += `<tr>
                <td class="text-xs">${no++}</td>
                <td class="text-xs">${pbId}</td>
                <td class="text-xs">${pb ? fmtDate(pb.tanggal_pengajuan) : '-'}</td>
                <td class="text-xs">${pb ? fmtDate(pb.tanggal_completed) : '-'}</td>
                <td class="text-xs">${item.nama_barang ?? item.nama_barang_master ?? '-'}</td>
                <td class="text-xs text-center">
                    <span class="badge bg-gradient-info">${item.qty_diminta}</span>
                </td>
                <td class="text-xs text-center">
                    <span class="badge bg-gradient-success">${item.qty_disetujui}</span>
                </td>
                <td class="text-xs">${item.keterangan ?? '-'}</td>
            </tr>`;
        });
    });

    if (html === '') {
        html = '<tr><td colspan="9" class="text-center text-muted py-3">Tidak ada data</td></tr>';
    }

    $('#bodyModalUser').html(html);
    new bootstrap.Modal(document.getElementById('modalDetailUser')).show();
});

        $('#tableTopUser tbody').css('cursor', 'pointer');
    </script>

    <style>
        #tableMain tbody tr.table-danger td {
            background-color: #ffe4e6 !important;
        }
        @media print {

            .btn,
            .nav-wrapper,
            .card-header button {
                display: none !important;
            }

            .card {
                page-break-inside: avoid;
            }
        }

        .progress-custom {
            height: 30px !important;
            background-color: #e9ecef;
            border-radius: 8px;
        }

        .progress-custom .progress-bar {
            height: 100% !important;
            font-size: 12px;
            font-weight: 700;
            display: flex;
            align-items: center;
            justify-content: center;
            line-height: 1;
            border-radius: 8px;
        }

        .badge {
            font-size: 11px;
        }

        .bg-warning {
            background-color: #ffbb00 !important;
        }

        .cursor-pointer {
            cursor: pointer;
            user-select: none;
        }

        .cursor-pointer:hover {
            background-color: rgba(0, 0, 0, 0.02);
        }

        .collapsing {
            transition: height 0.35s ease;
        }

        .modal .table tbody tr:last-child td {
            border-bottom: 1px solid #dee2e6 !important;
            border-right: 1px solid #dee2e6 !important;
            border-left: 1px solid #dee2e6 !important;
        }

        #tableTopBarang tbody tr:hover,
        #tableStatDept tbody tr:hover,
        #tableStockKritis tbody tr:hover {
            background-color: rgba(84, 112, 198, 0.08);
            transition: background 0.2s;
        }
    </style>
@endpush