@extends('layouts.master')

@section('title', 'Laporan Pemakaian Barang')

@section('styles')
<link rel="stylesheet" href="{{ asset('build/assets/libs/flatpickr/flatpickr.min.css') }}">
<style>
    .grn-summary-card { border-radius: 8px; padding: 10px 14px; display: flex; align-items: center; gap: 10px; }
    .grn-summary-card .icon-wrap { width: 36px; height: 36px; border-radius: 7px; display: flex; align-items: center; justify-content: center; font-size: 1rem; flex-shrink: 0; }
    .grn-summary-card .label { font-size: .7rem; color: #888; font-weight: 600; text-transform: uppercase; letter-spacing: .4px; }
    .grn-summary-card .value { font-size: 1.1rem; font-weight: 700; line-height: 1.2; color: #222; }
    .grn-summary-card.total  .icon-wrap { background: #ede9fe; color: #7c3aed; }
    .grn-summary-card.pasien .icon-wrap { background: #dbeafe; color: #1d6fdf; }
    .grn-summary-card.qty    .icon-wrap { background: #d1fae5; color: #059669; }
    .grn-summary-card.nilai  .icon-wrap { background: #fef3c7; color: #d97706; }
    #tblRekap th, #tblRekap td,
    #tblRincian th, #tblRincian td { vertical-align: middle; font-size: .82rem; border-color: #e9ecef !important; white-space: nowrap; }
    .dataTables_scrollBody { overflow-x: scroll !important; }
    .dataTables_scrollBody::-webkit-scrollbar { height: 8px; }
    .dataTables_scrollBody::-webkit-scrollbar-track { background: rgba(132,90,223,.12); border-radius: 4px; }
    .dataTables_scrollBody::-webkit-scrollbar-thumb { background: rgba(132,90,223,.55); border-radius: 4px; }
    .dataTables_scrollBody::-webkit-scrollbar-thumb:hover { background: rgb(132,90,223); }
    #tblRekap thead th, #tblRincian thead th { background: #f8f9fa; }
    #tblRekap_wrapper .dataTables_filter input,
    #tblRincian_wrapper .dataTables_filter input { border-color: #c8c8c8 !important; border-radius: 6px; padding: 4px 10px; }
    #tblRekap_wrapper .dataTables_filter input:focus,
    #tblRincian_wrapper .dataTables_filter input:focus { border-color: #a15adf !important; box-shadow: 0 0 0 0.18rem rgba(161,90,223,.15) !important; }
    #tblRekap_wrapper .dataTables_length select,
    #tblRincian_wrapper .dataTables_length select { border-color: #c8c8c8 !important; border-radius: 6px; padding: 4px 8px; min-width: 70px; }
    #tblRekap_wrapper .dataTables_filter label,
    #tblRekap_wrapper .dataTables_length label,
    #tblRincian_wrapper .dataTables_filter label,
    #tblRincian_wrapper .dataTables_length label { font-size: .875rem; color: #6c757d; }
    #tblRekap_wrapper .dataTables_info,
    #tblRincian_wrapper .dataTables_info { font-size: .8rem; color: #6c757d; }
    .nav-tabs .nav-link { font-size: .875rem; }
    /* Sticky columns */
    #tblRekap td.sticky-col, #tblRincian td.sticky-col { position: sticky; z-index: 2; background: #f8f9fa; }
    #tblRekap tbody td.sticky-col, #tblRincian tbody td.sticky-col { background: #fff; }
    .dataTables_scrollHead th.sticky-col { position: relative !important; z-index: 3; background: #f8f9fa; }
    #tblRekap td.sticky-col-last, #tblRincian td.sticky-col-last,
    .dataTables_scrollHead th.sticky-col-last { box-shadow: 2px 0 4px rgba(0,0,0,.07); }
    #tblRekap tr:hover td, #tblRincian tr:hover td { background: #f0f4ff !important; }
</style>
@endsection

@section('content')
<div class="container-fluid">
    <div class="d-md-flex d-block align-items-center justify-content-between my-4 page-header-breadcrumb">
        <div>
            <p class="fw-semibold fs-18 mb-0">Laporan Pemakaian Barang</p>
            <span class="fs-13 text-muted">Laporan &rarr; Pemakaian Barang</span>
        </div>
    </div>

    {{-- Summary Cards --}}
    <div class="row g-2 mb-3">
        <div class="col-6 col-md-3">
            <div class="card custom-card mb-0">
                <div class="card-body p-2">
                    <div class="grn-summary-card total">
                        <div class="icon-wrap"><i class="bx bx-file"></i></div>
                        <div><div class="label">Total Dokumen</div><div class="value" id="sumTotal">—</div></div>
                    </div>
                </div>
            </div>
        </div>
        <div class="col-6 col-md-3">
            <div class="card custom-card mb-0">
                <div class="card-body p-2">
                    <div class="grn-summary-card pasien">
                        <div class="icon-wrap"><i class="bx bx-user"></i></div>
                        <div><div class="label">Total Pasien</div><div class="value" id="sumPasien">—</div></div>
                    </div>
                </div>
            </div>
        </div>
        <div class="col-6 col-md-3">
            <div class="card custom-card mb-0">
                <div class="card-body p-2">
                    <div class="grn-summary-card qty">
                        <div class="icon-wrap"><i class="bx bx-box"></i></div>
                        <div><div class="label">Total Qty Barang</div><div class="value" id="sumQty">—</div></div>
                    </div>
                </div>
            </div>
        </div>
        <div class="col-6 col-md-3">
            <div class="card custom-card mb-0">
                <div class="card-body p-2">
                    <div class="grn-summary-card nilai">
                        <div class="icon-wrap"><i class="bx bx-money"></i></div>
                        <div><div class="label">Total Nilai</div><div class="value" id="sumNilai">—</div></div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <div class="card custom-card">
        {{-- Tabs --}}
        <div class="card-body pb-0 pt-3">
            <ul class="nav nav-tabs" id="tabLaporan" role="tablist">
                <li class="nav-item">
                    <button class="nav-link active" id="tab-rekap" data-bs-toggle="tab" data-bs-target="#paneRekap" type="button">
                        <i class="bx bx-list-ul me-1"></i> Rekap Pemakaian
                    </button>
                </li>
                <li class="nav-item">
                    <button class="nav-link" id="tab-rincian" data-bs-toggle="tab" data-bs-target="#paneRincian" type="button">
                        <i class="bx bx-detail me-1"></i> Rincian Pemakaian
                    </button>
                </li>
            </ul>
        </div>

        <div class="tab-content">
            {{-- TAB REKAP --}}
            <div class="tab-pane fade show active" id="paneRekap">
                <div class="card-body border-bottom pb-3 pt-3">
                    <div class="row g-2 align-items-end">
                        <div class="col-md-2">
                            <label class="form-label mb-1 small fw-semibold">Dari</label>
                            <input type="text" id="rekapDari" class="form-control form-control-sm flatpickr" placeholder="dd-mm-yyyy" readonly>
                        </div>
                        <div class="col-md-2">
                            <label class="form-label mb-1 small fw-semibold">Sampai</label>
                            <input type="text" id="rekapSampai" class="form-control form-control-sm flatpickr" placeholder="dd-mm-yyyy" readonly>
                        </div>
                        <div class="col-md-3">
                            <label class="form-label mb-1 small fw-semibold">Fasilitas Kesehatan</label>
                            <select id="rekapFaskes" class="form-select form-select-sm" style="width:100%">
                                <option value="">Semua Faskes</option>
                                @foreach($faskesList as $f)
                                <option value="{{ $f->id }}">{{ $f->nama }}</option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-md-2">
                            <label class="form-label mb-1 small fw-semibold">Sales / Pembuat</label>
                            <select id="rekapSales" class="form-select form-select-sm" style="width:100%">
                                <option value="">Semua Sales</option>
                                @foreach($salesList as $s)
                                <option value="{{ $s->id }}">{{ $s->nama }}</option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-md-auto d-flex gap-2">
                            <button type="button" class="btn btn-primary btn-sm px-2 py-1" id="btnRekapFilter">
                                <i class="bx bx-search me-1"></i> Tampilkan
                            </button>
                            <div class="dropdown">
                                <button class="btn btn-secondary btn-sm px-2 py-1 dropdown-toggle" type="button" data-bs-toggle="dropdown">
                                    <i class="bx bx-download me-1"></i> Unduh
                                </button>
                                <ul class="dropdown-menu dropdown-menu-end">
                                    <li><a class="dropdown-item" href="#" id="btnRekapExcel"><i class="bx bx-spreadsheet me-2 text-success"></i>Excel (.xlsx)</a></li>
                                    <li><a class="dropdown-item" href="#" id="btnRekapPdf"><i class="bx bx-download me-2 text-danger"></i>PDF</a></li>
                                </ul>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="card-body">
                    <div class="table-responsive">
                        <table id="tblRekap" class="table table-hover table-bordered align-middle mb-0" style="width:100%">
                            <thead class="table-light">
                                <tr>
                                    <th class="text-center" style="width:50px">Aksi</th>
                                    <th>No. Pemakaian</th>
                                    <th>Tgl. Transaksi</th>
                                    <th>Tgl. Pemakaian</th>
                                    <th>Fasilitas Kesehatan</th>
                                    <th>Nama Pasien</th>
                                    <th>Dokter</th>
                                    <th>Sales / Pembuat</th>
                                    <th class="text-center">Item</th>
                                    <th class="text-center">Total Qty</th>
                                    <th class="text-end">Total Nilai</th>
                                    <th>Status</th>
                                    <th>Status Invoice</th>
                                </tr>
                            </thead>
                            <tbody></tbody>
                        </table>
                    </div>
                </div>
            </div>

            {{-- TAB RINCIAN --}}
            <div class="tab-pane fade" id="paneRincian">
                <div class="card-body border-bottom pb-3 pt-3">
                    <div class="row g-2 align-items-end">
                        <div class="col-md-2">
                            <label class="form-label mb-1 small fw-semibold">Dari</label>
                            <input type="text" id="rincianDari" class="form-control form-control-sm flatpickr" placeholder="dd-mm-yyyy" readonly>
                        </div>
                        <div class="col-md-2">
                            <label class="form-label mb-1 small fw-semibold">Sampai</label>
                            <input type="text" id="rincianSampai" class="form-control form-control-sm flatpickr" placeholder="dd-mm-yyyy" readonly>
                        </div>
                        <div class="col-md-3">
                            <label class="form-label mb-1 small fw-semibold">Fasilitas Kesehatan</label>
                            <select id="rincianFaskes" class="form-select form-select-sm" style="width:100%">
                                <option value="">Semua Faskes</option>
                                @foreach($faskesList as $f)
                                <option value="{{ $f->id }}">{{ $f->nama }}</option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-md-2">
                            <label class="form-label mb-1 small fw-semibold">Sales / Pembuat</label>
                            <select id="rincianSales" class="form-select form-select-sm" style="width:100%">
                                <option value="">Semua Sales</option>
                                @foreach($salesList as $s)
                                <option value="{{ $s->id }}">{{ $s->nama }}</option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-md-2">
                            <label class="form-label mb-1 small fw-semibold">Kode Barang</label>
                            <input type="text" id="rincianKodeBarang" class="form-control form-control-sm" placeholder="Cari kode barang...">
                        </div>
                        <div class="col-md-auto d-flex gap-2">
                            <button type="button" class="btn btn-primary btn-sm px-2 py-1" id="btnRincianFilter">
                                <i class="bx bx-search me-1"></i> Tampilkan
                            </button>
                            <div class="dropdown">
                                <button class="btn btn-secondary btn-sm px-2 py-1 dropdown-toggle" type="button" data-bs-toggle="dropdown">
                                    <i class="bx bx-download me-1"></i> Unduh
                                </button>
                                <ul class="dropdown-menu dropdown-menu-end">
                                    <li><a class="dropdown-item" href="#" id="btnRincianExcel"><i class="bx bx-spreadsheet me-2 text-success"></i>Excel (.xlsx)</a></li>
                                    <li><a class="dropdown-item" href="#" id="btnRincianPdf"><i class="bx bx-download me-2 text-danger"></i>PDF</a></li>
                                </ul>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="card-body">
                    <div class="table-responsive">
                        <table id="tblRincian" class="table table-hover table-bordered align-middle mb-0" style="width:100%">
                            <thead class="table-light">
                                <tr>
                                    <th class="text-center" style="width:50px">Aksi</th>
                                    <th>No. Pemakaian</th>
                                    <th>No. Transaksi</th>
                                    <th>Tgl. Transaksi</th>
                                    <th>Tgl. Pemakaian</th>
                                    <th>No. Surat Kirim</th>
                                    <th>Tgl. Pengiriman</th>
                                    <th>Fasilitas Kesehatan</th>
                                    <th>Nama Pasien</th>
                                    <th>Dokter</th>
                                    <th>Sales / Pembuat</th>
                                    <th>Status</th>
                                    <th>Status Invoice</th>
                                    <th>Kode</th>
                                    <th>Nama Barang</th>
                                    <th>Jenis</th>
                                    <th>Merek</th>
                                    <th>Ukuran</th>
                                    <th>No. LOT</th>
                                    <th>No. Serial</th>
                                    <th>Tgl. Kedaluwarsa</th>
                                    <th class="text-center">Masa ED (Bln)</th>
                                    <th>Satuan</th>
                                    <th class="text-center">Qty</th>
                                    <th class="text-end">Harga</th>
                                    <th class="text-end">Nilai</th>
                                </tr>
                            </thead>
                            <tbody></tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection

@section('scripts')
<script src="{{ asset('build/assets/libs/flatpickr/flatpickr.min.js') }}"></script>
<script>
const BASE_URL = '{{ url('') }}';

function fmt(n) {
    return 'Rp ' + parseFloat(n || 0).toLocaleString('id-ID', { minimumFractionDigits: 0, maximumFractionDigits: 0 });
}

function fmtShort(n) {
    n = parseFloat(n || 0);
    if (n >= 1e9) return 'Rp ' + (n / 1e9).toFixed(1) + 'M';
    if (n >= 1e6) return 'Rp ' + (n / 1e6).toFixed(1) + 'jt';
    if (n >= 1e3) return 'Rp ' + (n / 1e3).toFixed(0) + 'rb';
    return 'Rp ' + n;
}

function getRekapFilters() {
    return {
        dari:   $('#rekapDari').val(),
        sampai: $('#rekapSampai').val(),
        faskes: $('#rekapFaskes').val(),
        sales:  $('#rekapSales').val(),
    };
}

function getRincianFilters() {
    return {
        dari:        $('#rincianDari').val(),
        sampai:      $('#rincianSampai').val(),
        faskes:      $('#rincianFaskes').val(),
        sales:       $('#rincianSales').val(),
        kode_barang: $('#rincianKodeBarang').val(),
    };
}

function applyStickyColumns(tableId, stickyCount) {
    const table = document.getElementById(tableId);
    const wrapper = document.getElementById(tableId + '_wrapper');
    if (!table || !wrapper) return;

    table.querySelectorAll('tbody .sticky-col').forEach(el => {
        el.classList.remove('sticky-col', 'sticky-col-last');
        el.style.left = '';
    });
    wrapper.querySelectorAll('.dataTables_scrollHead .sticky-col').forEach(el => {
        el.classList.remove('sticky-col', 'sticky-col-last');
        el.style.transform = '';
    });

    const headCells = wrapper.querySelectorAll('.dataTables_scrollHead thead tr:first-child th');
    const offsets = [];
    let cum = 0;
    headCells.forEach((th, i) => {
        if (i < stickyCount) { offsets.push(cum); cum += th.offsetWidth; }
    });

    table.querySelectorAll('tbody tr').forEach(row => {
        row.querySelectorAll('td').forEach((cell, i) => {
            if (i < stickyCount) {
                cell.classList.add('sticky-col');
                cell.style.left = offsets[i] + 'px';
                if (i === stickyCount - 1) cell.classList.add('sticky-col-last');
            }
        });
    });

    const stickyCells = Array.from(headCells).slice(0, stickyCount);
    stickyCells.forEach((th, i) => {
        th.classList.add('sticky-col');
        if (i === stickyCount - 1) th.classList.add('sticky-col-last');
    });

    const scrollBody = wrapper.querySelector('.dataTables_scrollBody');
    if (scrollBody && stickyCells.length) {
        if (wrapper._stickyHandler) scrollBody.removeEventListener('scroll', wrapper._stickyHandler);
        wrapper._stickyHandler = function() {
            const left = scrollBody.scrollLeft;
            stickyCells.forEach((th) => { th.style.transform = 'translateX(' + left + 'px)'; });
        };
        scrollBody.addEventListener('scroll', wrapper._stickyHandler, { passive: true });
        wrapper._stickyHandler();
    }
}

function loadSummary() {
    $.get(BASE_URL + '/laporan/pemakaian/summary', getRekapFilters(), function(d) {
        $('#sumTotal').text(d.total_dokumen.toLocaleString('id-ID'));
        $('#sumPasien').text(d.total_pasien.toLocaleString('id-ID'));
        $('#sumQty').text(d.total_qty.toLocaleString('id-ID'));
        $('#sumNilai').text(fmtShort(d.total_nilai));
    });
}

$(function () {
    flatpickr('.flatpickr', { dateFormat: 'd-m-Y', locale: 'id' });
    $('#rekapFaskes, #rincianFaskes').select2({ placeholder: 'Semua Faskes', allowClear: true, width: '100%' });
    $('#rekapSales, #rincianSales').select2({ placeholder: 'Semua Sales', allowClear: true, width: '100%' });

    const tblRekap = $('#tblRekap').DataTable({
        processing: true,
        serverSide: true,
        ajax: {
            url: BASE_URL + '/laporan/pemakaian/rekap',
            data: function(d) { Object.assign(d, getRekapFilters()); },
        },
        columns: [
            { data: null, orderable: false, className: 'text-center',
              render: (_, __, row) => `<a href="${BASE_URL}/pemakaian-barang/${row.id}" target="_blank" class="btn btn-info btn-sm px-2 py-1"><i class="bx bx-show fs-14"></i></a>` },
            { data: 'nomor' },
            { data: 'tgl_transaksi' },
            { data: 'tgl_pemakaian' },
            { data: 'nama_faskes' },
            { data: 'nama_pasien' },
            { data: 'nama_dokter' },
            { data: 'nama_sales' },
            { data: 'jumlah_item', className: 'text-center' },
            { data: 'total_qty', className: 'text-center' },
            { data: 'total_nilai', className: 'text-end', render: (v) => fmt(v) },
            { data: 'status_badge', orderable: false },
            { data: 'invoice_badge', orderable: false },
        ],
        order: [[2, 'desc']],
        language: { url: '//cdn.datatables.net/plug-ins/1.13.6/i18n/id.json' },
        scrollX: true,
        drawCallback: function() { applyStickyColumns('tblRekap', 4); },
        initComplete: function() { applyStickyColumns('tblRekap', 4); },
    });

    const tblRincian = $('#tblRincian').DataTable({
        processing: true,
        serverSide: true,
        ajax: {
            url: BASE_URL + '/laporan/pemakaian/rincian',
            data: function(d) { Object.assign(d, getRincianFilters()); },
        },
        columns: [
            { data: null, orderable: false, className: 'text-center',
              render: (_, __, row) => `<a href="${BASE_URL}/pemakaian-barang/${row.id}" target="_blank" class="btn btn-info btn-sm px-2 py-1"><i class="bx bx-show fs-14"></i></a>` },
            { data: 'nomor' },
            { data: 'no_transaksi' },
            { data: 'tgl_transaksi' },
            { data: 'tgl_pemakaian' },
            { data: 'no_surat_kirim' },
            { data: 'tgl_pengiriman' },
            { data: 'nama_faskes' },
            { data: 'nama_pasien' },
            { data: 'nama_dokter' },
            { data: 'nama_sales' },
            { data: 'status_badge', orderable: false },
            { data: 'invoice_badge', orderable: false },
            { data: 'kode_barang' },
            { data: 'nama_barang' },
            { data: 'jenis_barang' },
            { data: 'merek_barang' },
            { data: 'ukuran' },
            { data: 'no_lot' },
            { data: 'no_serial' },
            { data: 'tgl_kedaluwarsa' },
            {
                data: 'masa_ed', className: 'text-center',
                render: function (val) {
                    if (val === null || val === undefined) return '<span class="text-muted">—</span>';
                    if (val < 0)   return `<span class="badge bg-danger">Lewat ${Math.abs(val)} bln</span>`;
                    if (val <= 1)  return `<span class="badge bg-warning text-dark">${val} bln</span>`;
                    if (val <= 3)  return `<span class="badge bg-info">${val} bln</span>`;
                    return `<span class="badge bg-success">${val} bln</span>`;
                }
            },
            { data: 'satuan' },
            { data: 'qty', className: 'text-center' },
            { data: 'harga', className: 'text-end', render: (v) => fmt(v) },
            { data: 'nilai', className: 'text-end', render: (v) => fmt(v) },
        ],
        order: [[3, 'desc']],
        language: { url: '//cdn.datatables.net/plug-ins/1.13.6/i18n/id.json' },
        scrollX: true,
        drawCallback: function() { applyStickyColumns('tblRincian', 4); },
        initComplete: function() { applyStickyColumns('tblRincian', 4); },
    });

    function rekapExportUrl(format) {
        const p = new URLSearchParams(Object.assign(getRekapFilters(), { format }));
        return BASE_URL + '/laporan/pemakaian/rekap/export?' + p.toString();
    }
    function rincianExportUrl(format) {
        const p = new URLSearchParams(Object.assign(getRincianFilters(), { format }));
        return BASE_URL + '/laporan/pemakaian/rincian/export?' + p.toString();
    }

    $('#btnRekapExcel').on('click',   function(e) { e.preventDefault(); window.location.href = rekapExportUrl('excel'); });
    $('#btnRekapPdf').on('click',     function(e) { e.preventDefault(); window.location.href = rekapExportUrl('pdf'); });
    $('#btnRincianExcel').on('click', function(e) { e.preventDefault(); window.location.href = rincianExportUrl('excel'); });
    $('#btnRincianPdf').on('click',   function(e) { e.preventDefault(); window.location.href = rincianExportUrl('pdf'); });

    $('#btnRekapFilter').on('click', function () {
        loadSummary();
        tblRekap.ajax.reload();
    });

    $('#btnRincianFilter').on('click', function () {
        tblRincian.ajax.reload();
    });

    $('#tab-rincian').on('shown.bs.tab', function () {
        tblRincian.columns.adjust();
        applyStickyColumns('tblRincian', 4);
    });

    loadSummary();
});
</script>
@endsection