@extends('layouts.admin-Lti')
@section('title', '-Historico')
@section('content')

    <section class="content">
        <ol class="breadcrumb">
            <li class="breadcrumb-item"><a><span>{{session()->get('infosession')[0]->TIpoSistema }}</span></a></li>
            <li class="breadcrumb-item "><a href=""><span><b>Relatório </b></span></a>
            </li>
            <li class="breadcrumb-item active"><a><span><b>Armazém </b></span></a></li>

        </ol>

        <div class="container container-fluid">

        <div class="card ">

           <div class="card-body">


         <div class="summary-box p-3" style="border: 2px solid #007bff; background: linear-gradient(135deg, #f8f9fa 0%, #e9ecef 100%); border-radius: 8px;">
                            <h6 class="font-weight-bold mb-3"><i class="fas fa-chart-bar"></i> 📊 RESUMO GERAL dos Armazém</h6>
                            <div class="row g-3">
                                <div class="col-md-2 col-6">
                                    <div class="p-2 bg-white rounded shadow-sm text-center">
                                        <small class="text-muted d-block">Total Farmacos </small>
                                        <strong class="fs-5 QuantidadeItem"></strong>
                                    </div>
                                </div>
                                <div class="col-md-2 col-6">
                                    <div class="p-2 bg-white rounded shadow-sm text-center">
                                        <small class="text-muted d-block">Custo de Compra</small>
                                        <strong class="fs-5 valorCompra" ></strong>
                                    </div>
                                </div>
                                <div class="col-md-2 col-6">
                                    <div class="p-2 bg-white rounded shadow-sm text-center">
                                        <small class="text-muted d-block">Custo Venda</small>
                                        <strong class="fs-5 text-danger valorVenda">MZN</strong>
                                    </div>
                                </div>
                                <div class="col-md-2 col-6">
                                    <div class="p-2 bg-white rounded shadow-sm text-center">
                                        <small class="text-muted d-block">Iva Esperado</small>
                                        <strong class="fs-5 text-primary ivaEsperado"> MZN</strong>
                                    </div>
                                </div>
                                <div class="col-md-2 col-6">
                                    <div class="p-2 bg-white rounded shadow-sm text-center">
                                        <small class="text-muted d-block">Lucro Esperado</small>
                                        <strong class="fs-5 TotalLucro {{   0 ? 'text-success' : 'text-danger' }}">
                                             MZN
                                        </strong>
                                    </div>
                                </div>
                                <div class="col-md-2 col-6">
                                    <div class="p-2 bg-white rounded shadow-sm text-center">
                                        <small class="text-muted d-block" > Estado de Validade</small>

                                        <p class="fs-5 prest1" style="display: none"
                                        >hh </p>

                                        <p class="fs-5 prest2" style="display: none"
                                        > hh</p>

                                        <p class="fs-5 prest3" style="display: none" > gg</p>

                                        <p class="fs-5 prest4"  style="display: none" >gt </p>


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

         <!-- CARD COM FILTROS E BOTÕES -->
         <div class="card">

            <div class="card-body">
                <div class="row">
                    <div class="col-md-4">

                        <label>Farmacia </label>
                <select value="" type="text" class="form-control farmacia">
            <optgroup>
              @foreach ($produtosArmazem as $item)
                     <option>{{ $item->Descricao }}</option>
              @endforeach

            </optgroup>
                </select>
                    </div>

                    <div class="col-md-4">
                           <label> </label>
            <button class="btn btn-primary col-md-12" id="btnImprimir">
                <i class="fa fa-print" aria-hidden="true"></i> Imprimir
            </button>

                    </div>

                    <div class="col-md-4">
                           <label> </label>
            <button class="btn btn-secondary col-md-12" id="btnExcel">
               📊 Excel
            </button>

                    </div>
                </div>

            </div>
         </div>

          <table class="table" id="tabelaProdutos">
            <thead>
                <tr>
                    <th>Nr</th>
                    <th>Armazem</th>
                    <th>N.Generico</th>
                    <th>N.Comercial</th>
                    <th>Concetracao</th>
                    <th>Categoria</th>
                    <th>Iva</th>
                    <th>Qntd</th>
                    <th>pr.Compra/Unidade</th>
                    <th>pr.compra/farmaco</th>
                    <th>pr.Venda/Unidade</th>
                    <th>pr.Venda/Farmaco</th>
                    <th>lucro</th>
                    <th>Validade</th>
                    <th>Data Validade</th>
                </tr>
            </thead>

            <tbody>
            @foreach ($produtosArmazem as $item)

            @php
             $dados=($item["produtosCompra"])
            @endphp

            @foreach ( $dados as $key=>$item2)

            @php
             $hoje = \Carbon\Carbon::now();
                $validade = \Carbon\Carbon::parse(($item2->data_validade))->format('d-m-Y');
                $diasRestantes = $hoje->diffInDays($validade, false);

                $estado="dentro";
                if($diasRestantes<60&&$diasRestantes>31){
                    $estado="expira em 60 Dias";
                }
                elseif($diasRestantes<31&&$diasRestantes>15){
                     $estado="expira em 30 Dias";
                } elseif($diasRestantes< 15 &&$diasRestantes>1){
                     $estado="expira em 1 a 5 Dias";
                }
                elseif($diasRestantes< 0){
                     $estado="Vencido";
                }

            @endphp
                <tr>

                    <td>{{ $key+1}}</td>
                    <td>{{ $item->Descricao }}</td>
                    <td>{{ $item2->produtos->nome_generico }}</td>
                    <td>{{ $item2->produtos->nome }}</td>
                    <td>{{ $item2->produtos->Concentracao }}</td>
                    <td>{{ $item2->produtos->categoria->Descricao }}</td>
                    <td>{{ $item2->iva }}</td>
                    <td>{{ $item2->Quantidade }}</td>
                    <td>{{ $item2->preco_compra }}</td>
                    <td>{{ ( ($item2->Quantidade)*($item2->preco_compra)) }}</td>
                    <td>{{ ($item2->preco_venda) }}</td>
                    <td>{{ ( ($item2->Quantidade)*($item2->preco_venda)) }}</td>
                    <td>{{ ((( ($item2->Quantidade)*($item2->preco_venda))- ($item2->Quantidade)*($item2->preco_compra))) }}</td>
                    <td>{{ $estado}}</td>
                    <td>{{ $validade}}</td>
              </tr>

            @endforeach

            @endforeach

            </tbody>
                    <tfoot>
                        <tr>
                    <th>Nr</th>
                    <th>Armazem</th>
                    <th>N.Generico</th>
                    <th>N.Comercial</th>
                    <th>Concetracao</th>
                    <th>Categoria</th>
                    <th>Iva</th>
                    <th>Qntd</th>
                    <th>pr.Compra/Unidade</th>
                    <th>pr.compra/farmaco</th>
                    <th>pr.Venda/Unidade</th>
                    <th>pr.Venda/Farmaco</th>
                    <th>lucro</th>
                    <th>validade</th>
                    <th>Data validade</th>
                </tr>
                    </tfoot>
          </table>

        <footer class="col">

        </footer>

    </div>
    </section>

    @push('style')
        <link rel="stylesheet" href="{{ asset('perfilView/assets/bootstrap/css/bootstrap.min.css') }}">
        <link rel="stylesheet" href="{{ asset('perfilView/assets/fonts/ionicons.min.css') }}">
        <link rel="stylesheet" href="{{ asset('perfilView/assets/css/styles.min.css') }}">
    @endpush

    <!-- DataTables CSS -->
    <link rel="stylesheet" href="{{ asset('Datatable/css/responsive.bootstrap4.min.css') }}">

    @push('scripts')
        <script src="{{ asset('Datatable/js/jquery.dataTables.min.js') }}"></script>
        <script src="{{ asset('Datatable/js/dataTables.buttons.min.js') }}"></script>
        <script src="{{ asset('Datatable/js/buttons.flash.min.js') }}"></script>
        <script src="{{ asset('Datatable/js/jszip.min.js') }}"></script>
        <script src="{{ asset('Datatable/js/pdfmake.min.js') }}"></script>
        <script src="{{ asset('Datatable/js/vfs_fonts.js') }}"></script>
        <script src="{{ asset('Datatable/js/buttons.html5.min.js') }}"></script>
        <script src="{{ asset('Datatable/js/buttons.print.min.js') }}"></script>
        <script src="{{ asset('Datatable/js/buttons.colVis.min.js') }}"></script>
        <script src="{{ asset('Datatable/js/dataTables.responsive.min.js') }}"></script>
        <script src="{{ asset('MyJs/registarcliente.js') }}"></script>
        <script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.18.5/xlsx.full.min.js"></script>

        <script>

 // ============================================================
            // DATATABLES
            // ============================================================
            const table = $('#tabelaProdutos').DataTable({
                dom: 'Bfrtip',
                buttons: [
                    { extend: 'copy', text: '<i class="fa fa-copy"></i> Copiar', className: 'btn btn-primary' },
                    { extend: 'excel', text: '<i class="fa fa-file-xls"></i> excel', className: 'btn btn-info' },
                    { extend: 'pdf', text: '<i class="fa fa-file-pdf"></i> pdf', className: 'btn btn-danger' },
                    { extend: 'print', text: '<i class="fa fa-print"></i> Imprimir', className: 'btn btn-success' }
                ],
                responsive: true,
                columnDefs: [
                    { responsivePriority: 1, targets: 0 },
                    { responsivePriority: 13, targets: 1 },
                    { responsivePriority: 2, targets: 2},
                    { responsivePriority: 3, targets: 3 },
                    { responsivePriority: 9, targets: 4 },
                    { responsivePriority: 12, targets: 5 },
                    { responsivePriority: 4, targets: 6 },
                    { responsivePriority: 5, targets: 7 },
                    { responsivePriority: 11, targets: 8 },
                    { responsivePriority: 7, targets: 9 },
                    { responsivePriority: 10, targets: 10 },
                    { responsivePriority: 8, targets: 11 },
                    { responsivePriority: 10, targets: 12 },
                    { responsivePriority: 4, targets: 13 },

                ],
                "paging": true,
                "lengthChange": true,
                "searching": true,
                "ordering": true,
                "info": true,
                "autoWidth": true,
                "lengthMenu": [[4, 10, 25, 50, 100, -1], [4, 10, 25, 50, 100, "All"]],
                language: {
                    "lengthMenu": "visualizar _MENU_ ",
                    "zeroRecords": "Nada foi encontado",
                    "info": "mostrara pagina por pagina",
                    "processing": "processando..",
                    "infoEmpty": "Nada tem ",
                    "infoFiltered": "(filtered from _MAX_ total records)",
                    "loadingRecords": "processando...",
                    "search": "pesquisar:",
                    "paginate": {
                        "first": "primera",
                        "last": "ultima",
                        "next": "proxima",
                        "previous": " Anterior"
                    },
                },
                initComplete: function() {
                    this.api().columns([2,3,7,13]).every(function() {
                        var column = this;
                        var select = $('<select class="SelectorSerach"><option value=""></option></select>')
                            .appendTo($(column.footer()).empty())
                            .on('change', function() {
                                var val = $.fn.dataTable.util.escapeRegex($(this).val());
                                column.search(val ? '^' + val + '$' : '', true, false).draw();
                            });
                        column.data().unique().sort().each(function(d, j) {
                            select.append('<option value="' + d + '">' + d + '</option>');
                        });
                    });
                },

                dom:
            '<"row"<"col-sm-12 col-md-6"l><"col-sm-12 col-md-6"f>>' +
            '<"row"<"col-sm-12"tr>>' +
            '<"row"<"col-sm-12 col-md-5"i><"col-sm-12 col-md-7"p>>',

      drawCallback: function () {

    const api = this.api();

    let TotalItem = 0;
    let TotalCompra = 0;
    let TotalVenda = 0;
    let TotalIva = 0;
    let TotalLucro = 0;

    // IMPORTANTE:
    // zerar sempre que houver novo filtro
    let prestesprimeiro = 0;
    let prestessegundo = 0;
    let prestess3 = 0;
    let fora = 0;

    // =========================================================
    // PEGAR SOMENTE AS LINHAS FILTRADAS
    // =========================================================

    api.rows({
        search: 'applied'
    }).every(function () {

        const rowData = this.data();

        // Colunas
        const qtd = parseFloat(rowData[7]) || 0;

        const precoCompra = parseFloat(rowData[9]) || 0;

        const precoVenda = parseFloat(rowData[11]) || 0;

        const iva = parseFloat(rowData[6]) || 0;

        const lucro = parseFloat(rowData[12]) || 0;

        // COLUNA 13 = VALIDADE
        const validade = String(rowData[13] || '').trim();

        // =====================================================
        // VALIDADE
        // =====================================================

        if (validade === 'expira em 60 Dias') {

            prestesprimeiro++;

        }

        else if (validade === 'expira em 30 Dias') {

            prestessegundo++;

        }

        else if (validade === 'expira em 1 a 5 Dias') {

            prestess3++;

        }

        else if (validade === 'Vencido') {

            fora++;

        }

        // =====================================================
        // TOTAIS
        // =====================================================

        TotalItem += qtd;

        TotalCompra += precoCompra;

        TotalVenda += precoVenda;

        TotalIva += (iva / 100) * precoVenda;

        TotalLucro += lucro;

    });


    // =========================================================
    // ATUALIZAR RESUMO
    // =========================================================

    $('.QuantidadeItem')
        .html(`<strong>${TotalItem}</strong>`);

    $('.valorCompra')
        .html(`<strong>${TotalCompra.toFixed(2)} MZN</strong>`);

    $('.valorVenda')
        .html(`<strong>${TotalVenda.toFixed(2)} MZN</strong>`);

    $('.ivaEsperado')
        .html(`<strong>${TotalIva.toFixed(2)} MZN</strong>`);

    $('.TotalLucro')
        .html(`<strong>${TotalLucro.toFixed(2)} MZN</strong>`);


    // =========================================================
    // PRIMEIRO: ESCONDER TODOS
    // =========================================================

    $('.prest1').hide().html('');
    $('.prest2').hide().html('');
    $('.prest3').hide().html('');
    $('.prest4').hide().html('');


    // =========================================================
    // MOSTRAR SOMENTE OS QUE EXISTEM NO FILTRO ATUAL
    // =========================================================

    if (prestesprimeiro > 0) {

        $('.prest1')
            .html(
                `<strong>${prestesprimeiro}: em 60 Dias</strong>`
            )
            .show();

    }

    if (prestessegundo > 0) {

        $('.prest2')
            .html(
                `<strong>${prestessegundo}: em 30 Dias</strong>`
            )
            .show();

    }

    if (prestess3 > 0) {

        $('.prest3')
            .html(
                `<strong>${prestess3}: em 1 a 15 Dias</strong>`
            )
            .show();

    }

    if (fora > 0) {

        $('.prest4')
            .html(
                `<strong>${fora}: Vencido</strong>`
            )
            .show();

    }

}
            });

            // ============================================================
            // FILTRO POR FARMÁCIA
            // ============================================================
            $(document).on("change", ".farmacia", function(e){
                var loja=$(this).val();
                table.column(1).search(loja).draw();
            });

            $(document).ready(function(e){
                var loja=$(".farmacia").val();
                table.column(1).search(loja).draw();
            });

            // ============================================================
            // BOTÃO IMPRIMIR
            // ============================================================
            $('#btnImprimir').on('click', function () {

                const dados = table.rows({
                    search: 'applied'
                }).data().toArray();

                if (dados.length === 0) {
                    alert('Não existem dados para imprimir.');
                    return;
                }

                const quantidade = $('.QuantidadeItem').text().trim();
                const valorCompra = $('.valorCompra').text().trim();
                const valorVenda = $('.valorVenda').text().trim();
                const ivaEsperado = $('.ivaEsperado').text().trim();
                const lucro = $('.TotalLucro').text().trim();

                let farmacia = $('.farmacia option:selected').text().trim();
                if (!farmacia) {
                    farmacia = 'Todos os armazéns';
                }

                const agora = new Date();
                const data = agora.toLocaleDateString('pt-PT');
                const hora = agora.toLocaleTimeString('pt-PT', {
                    hour: '2-digit',
                    minute: '2-digit'
                });

                const janela = window.open('', '_blank', 'width=1600,height=900');

                let html = `
<!DOCTYPE html>
<html lang="pt">
<head>
<meta charset="UTF-8">
<title>Relatório de Armazém</title>
<style>
@page { size: A4 landscape; margin: 8mm; }
* { box-sizing: border-box; }
body { font-family: Arial, Helvetica, sans-serif; margin: 0; padding: 0; color: #000; font-size: 9px; }
.cabecalho { width: 100%; text-align: center; margin-bottom: 8px; }
.cabecalho h1 { font-size: 18px; margin: 0; font-weight: bold; }
.cabecalho h2 { font-size: 13px; margin: 3px 0; }
.cabecalho .info { font-size: 9px; margin-top: 5px; }
.summary-box { width: 100%; border: 1px solid #000; padding: 7px; margin-bottom: 10px; }
.summary-title { text-align: center; font-size: 12px; font-weight: bold; margin-bottom: 7px; }
.resumo { display: flex; width: 100%; gap: 5px; }
.box { flex: 1; border: 1px solid #999; padding: 6px; text-align: center; }
.box span { display: block; font-size: 8px; margin-bottom: 3px; }
.box strong { display: block; font-size: 11px; }
table { width: 100%; border-collapse: collapse; table-layout: auto; }
thead { display: table-header-group; }
tfoot { display: table-footer-group; }
th { background: #e9ecef; border: 1px solid #000; padding: 4px; font-size: 8px; font-weight: bold; text-align: center; white-space: nowrap; }
td { border: 1px solid #000; padding: 3px 4px; font-size: 8px; text-align: center; white-space: nowrap; }
tr { page-break-inside: avoid; }
.rodape { margin-top: 10px; border-top: 1px solid #000; padding-top: 5px; font-size: 8px; display: flex; justify-content: space-between; }
@media print { body { width: 100%; } .no-print { display: none !important; } }
</style>
</head>
<body>

<div class="cabecalho">
    <h1>RELATÓRIO DE ARMAZÉM</h1>
    <h2>${farmacia}</h2>
    <div class="info">Data: ${data} &nbsp;&nbsp;&nbsp; Hora: ${hora}</div>
</div>

<div class="summary-box">
    <div class="summary-title">RESUMO GERAL DOS ARMAZÉNS</div>
    <div class="resumo">
        <div class="box"><span>Total Fármacos</span><strong>${quantidade}</strong></div>
        <div class="box"><span>Custo de Compra</span><strong>${valorCompra} MZN</strong></div>
        <div class="box"><span>Custo de Venda</span><strong>${valorVenda} MZN</strong></div>
        <div class="box"><span>IVA Esperado</span><strong>${ivaEsperado} MZN</strong></div>
        <div class="box"><span>Lucro Esperado</span><strong>${lucro} MZN</strong></div>
    </div>
</div>

<table>
<thead>
<tr>
<th>Nr</th><th>Armazém</th><th>N. Genérico</th><th>N. Comercial</th>
<th>Concentração</th><th>Categoria</th><th>IVA</th><th>Qntd</th>
<th>Pr. Compra/Un.</th><th>Pr. Compra/Fármaco</th>
<th>Pr. Venda/Un.</th><th>Pr. Venda/Fármaco</th><th>Lucro</th>
<th>Validade</th><th>Data Validade</th>
</tr>
</thead>
<tbody>`;

                dados.forEach(function (row) {
                    html += `<tr>
                        <td>${row[0] ?? ''}</td>
                        <td>${row[1] ?? ''}</td>
                        <td>${row[2] ?? ''}</td>
                        <td>${row[3] ?? ''}</td>
                        <td>${row[4] ?? ''}</td>
                        <td>${row[5] ?? ''}</td>
                        <td>${row[6] ?? ''}</td>
                        <td>${row[7] ?? ''}</td>
                        <td>${row[8] ?? ''}</td>
                        <td>${row[9] ?? ''}</td>
                        <td>${row[10] ?? ''}</td>
                        <td>${row[11] ?? ''}</td>
                        <td>${row[12] ?? ''}</td>
                        <td>${row[13] ?? ''}</td>
                        <td>${row[14] ?? ''}</td>
                    </tr>`;
                });

                html += `
</tbody>
</table>
<div class="rodape">
    <span>Total de registros: ${dados.length}</span>
    <span>Relatório gerado pelo sistema</span>
</div>
<script>
window.onload = function () { setTimeout(function () { window.print(); }, 500); };
window.onafterprint = function () { window.close(); };
<\/script>
</body>
</html>`;

                janela.document.open();
                janela.document.write(html);
                janela.document.close();

            });

            // ============================================================
            // BOTÃO EXCEL
            // ============================================================
            $('#btnExcel').on('click', function () {

                let dados = table.rows({
                    search: 'applied'
                }).data().toArray();

                if (dados.length === 0) {
                    alert('Não existem dados filtrados para exportar.');
                    return;
                }

                const quantidade = $('.QuantidadeItem').text().trim();
                const valorCompra = $('.valorCompra').text().trim();
                const valorVenda = $('.valorVenda').text().trim();
                const ivaEsperado = $('.ivaEsperado').text().trim();
                const lucro = $('.TotalLucro').text().trim();

                let farmacia = $('.farmacia option:selected').text().trim();
                if (!farmacia) {
                    farmacia = 'Todos os armazéns';
                }

                if (typeof XLSX !== 'undefined') {

                    const cabecalho = [
                        'Nr', 'Armazém', 'N. Genérico', 'N. Comercial',
                        'Concentração', 'Categoria', 'IVA', 'Qntd',
                        'Pr. Compra/Un.', 'Pr. Compra/Fármaco',
                        'Pr. Venda/Un.', 'Pr. Venda/Fármaco', 'Lucro',
                        'Validade', 'Data Validade'
                    ];

                    const dadosExcel = dados.map(row => {
                        return row.slice(0, 15);
                    });

                    const dadosCompletos = [
                        ['RELATÓRIO DE ARMAZÉM'],
                        [`Armazém: ${farmacia}`],
                        [`Data: ${new Date().toLocaleDateString('pt-PT')}`],
                        [],
                        ['RESUMO GERAL'],
                        ['Total Fármacos', 'Custo Compra', 'Custo Venda', 'IVA Esperado', 'Lucro Esperado'],
                        [quantidade, valorCompra, valorVenda, ivaEsperado, lucro],
                        [],
                        ['DETALHES DO ARMAZÉM'],
                        cabecalho,
                        ...dadosExcel
                    ];

                    const ws = XLSX.utils.aoa_to_sheet(dadosCompletos);

                    const colWidths = [
                        { wch: 8 }, { wch: 18 }, { wch: 18 }, { wch: 18 },
                        { wch: 15 }, { wch: 15 }, { wch: 8 }, { wch: 8 },
                        { wch: 16 }, { wch: 18 }, { wch: 16 }, { wch: 18 },
                        { wch: 12 }, { wch: 15 }, { wch: 14 }
                    ];
                    ws['!cols'] = colWidths;

                    const wb = XLSX.utils.book_new();
                    XLSX.utils.book_append_sheet(wb, ws, 'Armazem');

                    XLSX.writeFile(wb, 'Relatorio_Armazem.xlsx');

                    return;
                }

                // Fallback HTML
                let html = `
                <html>
                <head><meta charset="UTF-8">
                <style>
                    table { border-collapse: collapse; font-family: Arial, sans-serif; font-size: 11px; }
                    th, td { border: 1px solid #000; padding: 5px 8px; text-align: center; }
                    th { background: #e9ecef; font-weight: bold; }
                    .titulo { font-size: 16px; font-weight: bold; text-align: center; }
                    .resumo-box { border: 1px solid #000; padding: 8px; margin-bottom: 15px; }
                </style>
                </head>
                <body>
                <h2 class="titulo">RELATÓRIO DE ARMAZÉM</h2>
                <p><strong>Armazém:</strong> ${farmacia}</p>
                <p><strong>Data:</strong> ${new Date().toLocaleDateString('pt-PT')}</p>
                <div class="resumo-box">
                    <p><strong>RESUMO GERAL</strong></p>
                    <table>
                        <tr>
                            <td><strong>Total Fármacos</strong></td>
                            <td><strong>Custo Compra</strong></td>
                            <td><strong>Custo Venda</strong></td>
                            <td><strong>IVA Esperado</strong></td>
                            <td><strong>Lucro Esperado</strong></td>
                        </tr>
                        <tr>
                            <td>${quantidade}</td>
                            <td>${valorCompra} MZN</td>
                            <td>${valorVenda} MZN</td>
                            <td>${ivaEsperado} MZN</td>
                            <td>${lucro} MZN</td>
                        </tr>
                    </table>
                </div>
                <br>
                <p><strong>DETALHES DO ARMAZÉM</strong></p>
                <table>
                    <thead>
                        <tr>
                            <th>Nr</th><th>Armazém</th><th>N. Genérico</th><th>N. Comercial</th>
                            <th>Concentração</th><th>Categoria</th><th>IVA</th><th>Qntd</th>
                            <th>Pr. Compra/Un.</th><th>Pr. Compra/Fármaco</th>
                            <th>Pr. Venda/Un.</th><th>Pr. Venda/Fármaco</th><th>Lucro</th>
                            <th>Validade</th><th>Data Validade</th>
                        </tr>
                    </thead>
                    <tbody>`;

                dados.forEach(row => {
                    html += '<tr>';
                    for (let i = 0; i < 15; i++) {
                        html += `<td>${row[i] ?? ''}</td>`;
                    }
                    html += '</tr>';
                });

                html += `
                    </tbody>
                </table>
                <br>
                <p><em>Total de registros: ${dados.length}</em></p>
                </body>
                </html>`;

                const blob = new Blob([html], {
                    type: 'application/vnd.ms-excel;charset=utf-8'
                });

                const link = document.createElement('a');
                link.href = URL.createObjectURL(blob);
                link.download = 'Relatorio_Armazem.xls';
                document.body.appendChild(link);
                link.click();
                document.body.removeChild(link);

                setTimeout(() => {
                    URL.revokeObjectURL(link.href);
                }, 100);
            });

        </script>

    @endpush

    <style>
        .dataTables_filter {
            display: none;
        }
    </style>

@endsection