Tul xxx Tul

Viewing: cuentas_cobrar.php

<?php include_once 'views/templates/header.php'; ?>

<div class="card">
    <div class="card-body">
        <h4 class="card-title text-center mb-4">Reporte de Cuentas por Cobrar</h4>
        
        <form method="GET" action="<?php echo BASE_URL; ?>reportes/cuentas_cobrar" class="mb-4">
            <div class="row align-items-end">
                <div class="col-md-2">
                    <label for="desde" class="form-label">Desde:</label>
                    <input type="date" class="form-control" name="desde" id="desde" value="<?php echo isset($_GET['desde']) ? $_GET['desde'] : ''; ?>">
                </div>
                <div class="col-md-2">
                    <label for="hasta" class="form-label">Hasta:</label>
                    <input type="date" class="form-control" name="hasta" id="hasta" value="<?php echo isset($_GET['hasta']) ? $_GET['hasta'] : ''; ?>">
                </div>
                <div class="col-md-4">
                    <label for="cliente" class="form-label">Cliente:</label>
                    <select class="form-select" name="cliente" id="cliente">
                        <option value="todos">Todos</option>
                        <?php if(!empty($data['clientes'])) { foreach($data['clientes'] as $cli) { ?>
                            <option value="<?php echo $cli['id']; ?>" <?php echo (isset($_GET['cliente']) && $_GET['cliente'] == $cli['id']) ? 'selected' : ''; ?>>
                                <?php echo htmlspecialchars($cli['identidad'] . ' - ' . $cli['nombre']); ?>
                            </option>
                        <?php } } ?>
                    </select>
                </div>
                <div class="col-md-2">
                    <label for="estado" class="form-label">Estado:</label>
                    <select class="form-select" name="estado" id="estado">
                        <option value="todos">Todos</option>
                        <option value="1" <?php echo (isset($_GET['estado']) && $_GET['estado'] == '1') ? 'selected' : ''; ?>>Pendiente</option>
                        <option value="0" <?php echo (isset($_GET['estado']) && $_GET['estado'] == '0') ? 'selected' : ''; ?>>Pagado</option>
                    </select>
                </div>
                <div class="col-md-2">
                    <button type="submit" class="btn btn-primary w-100 mt-4">Filtrar</button>
                </div>
            </div>
        </form>

        <div class="table-responsive">
            <table class="table table-bordered table-striped table-hover align-middle nowrap" style="width: 100%;" id="tbl_cuentas_cobrar">
                <thead style="color: black; font-weight: bold; font-size: 0.9em;">
                    <tr>
                        <th>FECHA</th>
                        <th>SERIE VENTA</th>
                        <th>CLIENTE</th>
                        <th>MONTO CRÉDITO</th>
                        <th>ABONADO</th>
                        <th>RESTANTE</th>
                        <th>ESTADO</th>
                    </tr>
                </thead>
                <tbody style="font-size: 0.9em;">
<?php if(!empty($data['lista'])) { foreach ($data['lista'] as $row) { ?>
                    <tr>
                        <td><?php echo isset($row['fecha_venta']) ? htmlspecialchars($row['fecha_venta']) : ''; ?></td>
                        <td><?php echo isset($row['serie']) ? htmlspecialchars($row['serie']) : ''; ?></td>
                        <td><?php echo isset($row['cliente']) ? htmlspecialchars($row['cliente']) : ''; ?></td>
                        <td><?php echo isset($row['monto']) ? number_format((float)$row['monto'], 2) : '0.00'; ?></td>
                        <td><?php echo isset($row['abono']) ? number_format((float)$row['abono'], 2) : '0.00'; ?></td>
                        <td><?php echo isset($row['restante']) ? number_format((float)$row['restante'], 2) : '0.00'; ?></td>
                        <td><?php echo isset($row['estado_lbl']) ? htmlspecialchars($row['estado_lbl']) : ''; ?></td>
                    </tr>
<?php } } ?>
                </tbody>
            </table>
        </div>
    </div>
</div>

<script>
document.addEventListener('DOMContentLoaded', function () {
    var defaultButtons = buttons.filter(btn => btn.extend === 'excelHtml5' || btn.extend === 'pdfHtml5');
    
    var myButtons = defaultButtons.map(function(btn) {
        if (btn.extend === 'pdfHtml5') {
            return {
                text: btn.text || '<i class="fas fa-file-pdf"></i> PDF',
                className: btn.className || 'btn btn-danger',
                action: function ( e, dt, node, config ) {
                    var params = new URLSearchParams(window.location.search);
                    window.open(base_url + 'reportes/generarCuentasCobrar?' + params.toString(), '_blank');
                }
            };
        }
        if (btn.extend === 'excelHtml5') {
            return {
                text: btn.text || '<i class="fas fa-file-excel"></i> Excel',
                className: btn.className || 'btn btn-success',
                action: function ( e, dt, node, config ) {
                    var params = new URLSearchParams(window.location.search);
                    window.location.href = base_url + 'reportes/excelCuentasCobrar?' + params.toString();
                }
            };
        }
        return btn;
    });

    $('#tbl_cuentas_cobrar').DataTable({
        language: {
            url: base_url + 'assets/js/espanol.json'
        },
        dom: dom,
        buttons: myButtons,
        responsive: true,
        order: [[0, 'desc']]
    });
});
</script>

<?php include_once 'views/templates/footer.php'; ?>
User / IP	: 216.73.217.33
Host / Server	: 45.84.207.204 / aircan.me
System	: Linux lt-bnk-web1726.main-hosting.eu 5.14.0-611.36.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Mar 3 11:23:52 EST 2026 x86_64