Tul xxx Tul

Viewing: CreditosModel.php

<?php
class CreditosModel extends Query{
    public function __construct() {
        parent::__construct();
    }
    public function getCreditos($id_sucursal)
    {
        $sql = "SELECT cr.*, cl.nombre FROM creditos cr INNER JOIN ventas v ON cr.id_venta = v.id INNER JOIN clientes cl ON v.id_cliente = cl.id WHERE v.id_sucursal = $id_sucursal";
        return $this->selectAll($sql);
    }
    public function getAbono($idCredito)
    {
        $sql = "SELECT SUM(abono) AS total FROM abonos WHERE id_credito = $idCredito";
        return $this->select($sql);
    }

    public function buscarPorNombre($valor)
    {
        $sql = "SELECT cr.*, cl.nombre, cl.telefono, cl.direccion FROM creditos cr INNER JOIN ventas v ON cr.id_venta = v.id INNER JOIN clientes cl ON v.id_cliente = cl.id WHERE cl.nombre LIKE '%".$valor."%' AND cr.estado = 1 LIMIT 10";
        return $this->selectAll($sql);
    }

    public function getCaja($id_sucursal)
    {
        $idUsuario = isset($_SESSION['id_usuario']) ? (int)$_SESSION['id_usuario'] : 0;
        $filtroUsuario = empty($_SESSION['rol']) ? '' : " AND id_usuario = $idUsuario";
        $idCajaActiva = isset($_SESSION['id_caja_activa']) ? (int)$_SESSION['id_caja_activa'] : 0;
        if ($idCajaActiva > 0) {
            $sql = "SELECT * FROM cajas WHERE estado = 1 AND id_sucursal = $id_sucursal AND id = $idCajaActiva" . $filtroUsuario . " ORDER BY id DESC";
            $cajaActiva = $this->select($sql);
            if (!empty($cajaActiva)) {
                return $cajaActiva;
            }
        }
        $sql = "SELECT * FROM cajas WHERE estado = 1 AND id_sucursal = $id_sucursal" . $filtroUsuario . " ORDER BY id DESC";
        return $this->select($sql);
    }

    public function registrarAbono($monto, $fecha, $id_caja, $idCredito, $id_usuario, $id_formapago)
    {
        $sql = "INSERT INTO abonos (abono, fecha, id_caja, id_credito, id_usuario, id_formapago) VALUES (?,?,?,?,?,?)";
        $array = array($monto, $fecha, $id_caja, $idCredito, $id_usuario, $id_formapago);
        return $this->insertar($sql, $array);
    }
    public function getCredito($idCredito)
    {
        $sql = "SELECT cr.*, v.productos, cl.identidad, cl.num_identidad, cl.nombre, cl.telefono, cl.direccion FROM creditos cr INNER JOIN ventas v ON cr.id_venta = v.id INNER JOIN clientes cl ON v.id_cliente = cl.id WHERE cr.id = $idCredito";
        return $this->select($sql);
    }

    public function actualizarCredito($estado, $idCredito)
    {
        $sql = "UPDATE creditos SET estado = ? WHERE id = ?";
        $array = array($estado, $idCredito);
        return $this->save($sql, $array);
    }

    public function getAbonos($idCredito)
    {
        $sql = "SELECT * FROM abonos WHERE id_credito = $idCredito";
        return $this->selectAll($sql);
    }

    public function getHistorialAbonos()
    {
        $sql = "SELECT * FROM abonos";
        return $this->selectAll($sql);
    }

    public function getEmpresa()
    {
        $sql = "SELECT * FROM sucursales";
        return $this->select($sql);
    }

    public function getFormapagosActivos()
    {
        $sql = "SELECT id, formapago FROM formapagos WHERE estado = 1 ORDER BY id ASC";
        return $this->selectAll($sql);
    }
}

?>
User / IP	: 216.73.216.227
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