@extends('theme.sneat.admin')
@section('contenido')
<meta name="csrf-token" content="{{ csrf_token() }}" />
<h4 class="fw-bold py-2"><span class="text-muted fw-light">Informe de </span> compras factura</h4>
<p class="text-muted mb-4">Detalle por línea de producto. Use los filtros y pulse <strong>Generar</strong>.</p>

<div class="row">
  <div class="col-xl">
    <div class="card mb-4">
      <div class="card-header d-flex justify-content-between align-items-center">
        <span>Filtros</span>
        <small class="text-muted">Informes</small>
      </div>
      <div class="card-body">
        <div class="row g-3">
          <div class="col-md-3 col-lg-2">
            <label class="form-label" for="f_desde">Fecha desde</label>
            <input type="date" class="form-control" id="f_desde" value="{{ date('Y-m-01') }}" />
          </div>
          <div class="col-md-3 col-lg-2">
            <label class="form-label" for="f_hasta">Fecha hasta</label>
            <input type="date" class="form-control" id="f_hasta" value="{{ date('Y-m-d') }}" />
          </div>
          <div class="col-md-3 col-lg-2">
            <label class="form-label" for="f_factura">N° factura / ref.</label>
            <input type="text" class="form-control" id="f_factura" placeholder="Contiene…" autocomplete="off" />
          </div>
          <div class="col-md-3 col-lg-2">
            <label class="form-label" for="f_cheque">N° cheque</label>
            <input type="text" class="form-control" id="f_cheque" placeholder="Contiene…" autocomplete="off" />
          </div>
          <div class="col-md-6 col-lg-4">
            <label class="form-label" for="f_proveedor">Proveedor</label>
            <select class="form-select" id="f_proveedor">
              <option value="">Todos</option>
              @foreach ($proveedores as $prov)
                <option value="{{ $prov->id }}">{{ $prov->nombre }}</option>
              @endforeach
            </select>
          </div>
          <div class="col-md-6 col-lg-4">
            <label class="form-label" for="f_categoria">Categoría</label>
            <select class="form-select" id="f_categoria">
              <option value="">Todas</option>
              @foreach ($categorias as $cat)
                <option value="{{ $cat->id }}">{{ $cat->nombre }}</option>
              @endforeach
            </select>
          </div>
          <div class="col-md-6 col-lg-4">
            <label class="form-label" for="f_producto">Producto</label>
            <select id="f_producto" placeholder="Buscar producto…"></select>
          </div>
          <div class="col-12 d-flex flex-wrap gap-2 align-items-end">
            <button type="button" class="btn btn-primary" id="btn_generar">Generar</button>
            <button type="button" class="btn btn-outline-secondary" id="btn_limpiar">Limpiar filtros</button>
          </div>
        </div>
      </div>
    </div>
  </div>
</div>

<div class="row g-3 mb-4" id="bloque_totales">
  <div class="col-6 col-md-4 col-xl">
    <div class="card border border-primary border-opacity-25 shadow-none h-100">
      <div class="card-body py-3">
        <div class="small text-muted text-uppercase">Líneas (filtradas)</div>
        <div class="fs-4 fw-semibold" id="sum_registros">—</div>
      </div>
    </div>
  </div>
  <div class="col-6 col-md-4 col-xl">
    <div class="card border shadow-none h-100">
      <div class="card-body py-3">
        <div class="small text-muted text-uppercase">Cantidad</div>
        <div class="fs-4 fw-semibold text-primary" id="sum_cantidad">—</div>
      </div>
    </div>
  </div>
  <div class="col-6 col-md-4 col-xl">
    <div class="card border shadow-none h-100">
      <div class="card-body py-3">
        <div class="small text-muted text-uppercase">Neto</div>
        <div class="fs-4 fw-semibold" id="sum_neto">—</div>
      </div>
    </div>
  </div>
  <div class="col-6 col-md-4 col-xl">
    <div class="card border shadow-none h-100">
      <div class="card-body py-3">
        <div class="small text-muted text-uppercase">IVA</div>
        <div class="fs-4 fw-semibold" id="sum_iva">—</div>
      </div>
    </div>
  </div>
  <div class="col-6 col-md-4 col-xl">
    <div class="card border border-success border-opacity-50 shadow-none h-100">
      <div class="card-body py-3">
        <div class="small text-muted text-uppercase">Total</div>
        <div class="fs-4 fw-semibold text-success" id="sum_total">—</div>
      </div>
    </div>
  </div>
</div>

<div class="card">
  <div class="card-header p-3">
    <div class="d-flex flex-wrap justify-content-between align-items-center gap-2">
      <span class="fw-medium">Detalle por producto</span>
      <div class="btn-group" role="group">
        <button type="button" class="btn btn-outline-secondary dropdown-toggle" data-bs-toggle="dropdown">Exportar</button>
        <div class="dropdown-menu dropdown-menu-end">
          <a class="dropdown-item" href="javascript:void(0)" id="exp_excel">Excel</a>
          <a class="dropdown-item" href="javascript:void(0)" id="exp_pdf">PDF</a>
        </div>
      </div>
    </div>
  </div>
  <div class="table-responsive text-nowrap" style="min-height: 320px;">
    <table id="tabla_informe_cf" class="table table-bordered table-sm table-striped w-100 mb-0">
      <thead class="table-light">
        <tr>
          <th class="text-center">ID compra</th>
          <th class="text-center">Fecha</th>
          <th>Factura / ref.</th>
          <th>Cheque</th>
          <th>Proveedor</th>
          <th>Producto</th>
          <th>Categoría</th>
          <th class="text-end">Cant.</th>
          <th class="text-end">Costo u.</th>
          <th class="text-end">Imp. carne</th>
          <th class="text-end">Imp. harina</th>
          <th class="text-end">Imp. ILA</th>
          <th class="text-end">Imp. flete</th>
          <th class="text-end">Neto</th>
          <th class="text-end">IVA</th>
          <th class="text-end">Total</th>
        </tr>
      </thead>
      <tfoot class="table-secondary">
        <tr>
          <th colspan="7" class="text-end">Totales (filtro actual)</th>
          <th class="text-end" id="foot_cantidad">—</th>
          <th class="text-end text-muted" id="foot_costo_u">—</th>
          <th class="text-end" id="foot_imp_carne">—</th>
          <th class="text-end" id="foot_imp_harina">—</th>
          <th class="text-end" id="foot_imp_ila">—</th>
          <th class="text-end" id="foot_imp_flete">—</th>
          <th class="text-end" id="foot_neto">—</th>
          <th class="text-end" id="foot_iva">—</th>
          <th class="text-end fw-bold" id="foot_total">—</th>
        </tr>
      </tfoot>
    </table>
  </div>
</div>
@endsection

@section('scripts')
<script>
(function () {
  function numOrNull(n) {
    if (n === null || n === undefined || n === '') return null;
    const x = Number(n);
    return isNaN(x) ? null : x;
  }

  const fmt = {
    /** Montos: separador de miles; decimales (,) solo si no es entero (sin “,00”). */
    money: function (n) {
      const num = numOrNull(n);
      if (num === null) return '—';
      const r = Math.round(num * 100) / 100;
      if (Math.abs(r - Math.round(r)) < 1e-9) {
        return Math.round(r).toLocaleString('es-CL', { maximumFractionDigits: 0 });
      }
      return r.toLocaleString('es-CL', { minimumFractionDigits: 0, maximumFractionDigits: 2 });
    },
    /** Cantidades: hasta 4 decimales; sin decimales si es entero. */
    qty: function (n) {
      const num = numOrNull(n);
      if (num === null) return '—';
      const r = Math.round(num * 10000) / 10000;
      if (Math.abs(r - Math.round(r)) < 1e-9) {
        return Math.round(r).toLocaleString('es-CL', { maximumFractionDigits: 0 });
      }
      return r.toLocaleString('es-CL', { minimumFractionDigits: 0, maximumFractionDigits: 4 });
    },
    intStr: function (n) {
      const num = numOrNull(n);
      if (num === null) return '—';
      return Math.round(num).toLocaleString('es-CL', { maximumFractionDigits: 0 });
    },
    /** Costo unitario: entero, sin puntos de miles (misma lectura que en Compras facturas). */
    costoU: function (n) {
      const num = numOrNull(n);
      if (num === null) return '—';
      return String(Math.round(num));
    }
  };

  function renderMoney(d, type) {
    if (type === 'sort' || type === 'type' || type === 'export' || type === 'filter') {
      return numOrNull(d) ?? 0;
    }
    return fmt.money(d);
  }
  function renderQty(d, type) {
    if (type === 'sort' || type === 'type' || type === 'export' || type === 'filter') {
      return numOrNull(d) ?? 0;
    }
    return fmt.qty(d);
  }
  function renderCostoU(d, type) {
    if (type === 'sort' || type === 'type' || type === 'export' || type === 'filter') {
      return numOrNull(d) ?? 0;
    }
    return fmt.costoU(d);
  }

  let ultimosTotales = null;

  function aplicarTotales(t) {
    if (!t) return;
    ultimosTotales = t;
    $('#sum_registros').text(fmt.intStr(t.registros_filtrados));
    $('#sum_cantidad').text(fmt.qty(t.cantidad));
    $('#sum_neto').text(fmt.money(t.neto));
    $('#sum_iva').text(fmt.money(t.iva));
    $('#sum_total').text(fmt.money(t.total));
    $('#foot_cantidad').text(fmt.qty(t.cantidad));
    $('#foot_costo_u').text('—');
    $('#foot_imp_carne').text(fmt.money(t.imp_carne));
    $('#foot_imp_harina').text(fmt.money(t.imp_harina));
    $('#foot_imp_ila').text(fmt.money(t.imp_ila));
    $('#foot_imp_flete').text(fmt.money(t.imp_flete));
    $('#foot_neto').text(fmt.money(t.neto));
    $('#foot_iva').text(fmt.money(t.iva));
    $('#foot_total').text(fmt.money(t.total));
  }

  /** Pie de Excel: devolver número (no texto con puntos/comas). */
  function footerExportNum(columnIdx) {
    if (!ultimosTotales) return '';
    const map = {
      7: ultimosTotales.cantidad,
      9: ultimosTotales.imp_carne,
      10: ultimosTotales.imp_harina,
      11: ultimosTotales.imp_ila,
      12: ultimosTotales.imp_flete,
      13: ultimosTotales.neto,
      14: ultimosTotales.iva,
      15: ultimosTotales.total
    };
    if (!(columnIdx in map)) {
      return columnIdx === 0 ? 'Totales' : '';
    }
    return numOrNull(map[columnIdx]) ?? 0;
  }

  let tabla = null;

  function destruirTabla() {
    if ($.fn.DataTable.isDataTable('#tabla_informe_cf')) {
      $('#tabla_informe_cf').DataTable().destroy();
    }
  }

  function generar() {
    destruirTabla();
    tabla = $('#tabla_informe_cf').DataTable({
      processing: true,
      serverSide: true,
      searching: false,
      paging: false,
      lengthChange: false,
      info: false,
      dom: 'Brt',
      ajax: {
        url: "{{ url('compras-facturas/informe-lineas-listado') }}",
        data: function (d) {
          d.start = 0;
          d.length = -1;
          d.fecha_desde = $('#f_desde').val();
          d.fecha_hasta = $('#f_hasta').val();
          d.facturas = $('#f_factura').val();
          d.numero_cheque = $('#f_cheque').val();
          d.proveedor_id = $('#f_proveedor').val();
          d.categoria_producto_id = $('#f_categoria').val();
          var elP = document.getElementById('f_producto');
          var pid = (elP && elP.selectize) ? elP.selectize.getValue() : ($(elP).val() || '');
          d.producto_id = pid || '';
        },
        dataSrc: function (json) {
          aplicarTotales(json.totales || {});
          return json.data;
        }
      },
      columns: [
        { data: 'compra_id', className: 'text-center' },
        { data: 'fecha', className: 'text-center' },
        { data: 'facturas' },
        { data: 'numero_cheque' },
        { data: 'proveedor_nombre' },
        { data: 'producto_nombre' },
        { data: 'categoria_nombre' },
        { data: 'cantidad', className: 'text-end', render: renderQty },
        { data: 'costo_unitario', className: 'text-end', render: renderCostoU },
        { data: 'imp_carne', className: 'text-end', render: renderMoney },
        { data: 'imp_harina', className: 'text-end', render: renderMoney },
        { data: 'imp_ila', className: 'text-end', render: renderMoney },
        { data: 'imp_flete', className: 'text-end', render: renderMoney },
        { data: 'neto', className: 'text-end', render: renderMoney },
        { data: 'iva', className: 'text-end', render: renderMoney },
        { data: 'total', className: 'text-end', render: renderMoney }
      ],
      order: [[1, 'desc']],
      buttons: [
        {
          extend: 'excelHtml5',
          footer: true,
          title: 'Informe compras facturas',
          className: 'btn-excel-cf d-none',
          exportOptions: {
            columns: ':visible',
            orthogonal: 'export',
            format: {
              footer: function (data, node, columnIdx) {
                return footerExportNum(columnIdx);
              }
            }
          },
          customize: function (xlsx) {
            // Forzar celdas numéricas en columnas de montos/cantidad (Excel suma sin triángulo verde)
            var sheet = xlsx.xl.worksheets['sheet1.xml'];
            var numCols = ['H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P']; // cantidad … total
            $('row c', sheet).each(function () {
              var cell = $(this);
              var ref = cell.attr('r') || '';
              var col = ref.replace(/[0-9]/g, '');
              if (numCols.indexOf(col) === -1) return;
              var v = $('v', cell).text();
              if (v === '' || isNaN(Number(v))) return;
              cell.attr('t', 'n');
              cell.removeAttr('s');
            });
          }
        },
        {
          extend: 'pdfHtml5',
          orientation: 'landscape',
          pageSize: 'LEGAL',
          footer: true,
          exportOptions: { columns: ':visible' },
          className: 'btn-pdf-cf d-none'
        }
      ],
      language: {
        sProcessing: 'Procesando…',
        sZeroRecords: 'Sin resultados',
        sEmptyTable: 'Sin datos'
      },
      initComplete: function () {
        $('.dt-buttons').hide();
      }
    });
  }

  $('#exp_excel').on('click', function () {
    if (tabla) $('.btn-excel-cf').trigger('click');
  });
  $('#exp_pdf').on('click', function () {
    if (tabla) $('.btn-pdf-cf').trigger('click');
  });

  $('#btn_generar').on('click', generar);

  $('#btn_limpiar').on('click', function () {
    $('#f_desde').val('{{ date('Y-m-01') }}');
    $('#f_hasta').val('{{ date('Y-m-d') }}');
    $('#f_factura').val('');
    $('#f_cheque').val('');
    $('#f_proveedor').val('');
    $('#f_categoria').val('');
    if ($('#f_producto')[0] && $('#f_producto')[0].selectize) {
      $('#f_producto')[0].selectize.clear();
    }
  });

  $.ajax({
    url: "{{ url('compras-facturas/productos-opciones') }}",
    type: 'GET'
  }).done(function (rows) {
    const opts = (rows || []).map(function (r) {
      return { value: r.id, text: r.nombre + (r.unidad_medida ? ' (' + r.unidad_medida + ')' : '') };
    });
    $('#f_producto').selectize({
      valueField: 'value',
      labelField: 'text',
      searchField: ['text'],
      options: opts,
      placeholder: 'Todos los productos',
      allowEmptyOption: true,
      create: false
    });
  });

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