Tul xxx Tul

Viewing: AdminModel.php

<?php
class AdminModel extends Query{
    public function __construct() {
        parent::__construct();
    }
    public function getDatos($table)
    {
        $sql = "SELECT * FROM $table";
        return $this->select($sql);
    }

    public function getCompraVenta($table, $id_sucursal) {
        $sql = "SELECT COUNT(id) AS total FROM $table WHERE estado = 1 AND id_sucursal = $id_sucursal";
        return $this->select($sql);
    }

    public function getTotales($table, $id_sucursal)
    {
        $sql = "SELECT COUNT(*) AS total FROM $table WHERE estado = 1 AND id_sucursal = $id_sucursal";
        return $this->select($sql);
    }

    public function getTotalesDatos($table)
    {
        $sql = "SELECT COUNT(*) AS total FROM $table WHERE estado = 1";
        return $this->select($sql);
    }

    public function calcularVentas($table, $desde, $hasta, $id_sucursal)
    {
        $sql = "SELECT SUM(IF(MONTH(fecha) = 1, totalConImpuesto, 0)) AS ene,
        SUM(IF(MONTH(fecha) = 2, totalConImpuesto, 0)) AS feb,
        SUM(IF(MONTH(fecha) = 3, totalConImpuesto, 0)) AS mar,
        SUM(IF(MONTH(fecha) = 4, totalConImpuesto, 0)) AS abr,
        SUM(IF(MONTH(fecha) = 5, totalConImpuesto, 0)) AS may,
        SUM(IF(MONTH(fecha) = 6, totalConImpuesto, 0)) AS jun,
        SUM(IF(MONTH(fecha) = 7, totalConImpuesto, 0)) AS jul,
        SUM(IF(MONTH(fecha) = 8, totalConImpuesto, 0)) AS ago,
        SUM(IF(MONTH(fecha) = 9, totalConImpuesto, 0)) AS sep,
        SUM(IF(MONTH(fecha) = 10, totalConImpuesto, 0)) AS oct,
        SUM(IF(MONTH(fecha) = 11, totalConImpuesto, 0)) AS nov,
        SUM(IF(MONTH(fecha) = 12, totalConImpuesto, 0)) AS dic 
        FROM $table WHERE fecha BETWEEN '$desde' AND '$hasta' AND estado = 1 AND id_sucursal = $id_sucursal";
        return $this->select($sql);
    }

    public function calcularCompras($table, $desde, $hasta, $id_sucursal)
    {
        $sql = "SELECT SUM(IF(MONTH(fecha) = 1, total, 0)) AS ene,
        SUM(IF(MONTH(fecha) = 2, total, 0)) AS feb,
        SUM(IF(MONTH(fecha) = 3, total, 0)) AS mar,
        SUM(IF(MONTH(fecha) = 4, total, 0)) AS abr,
        SUM(IF(MONTH(fecha) = 5, total, 0)) AS may,
        SUM(IF(MONTH(fecha) = 6, total, 0)) AS jun,
        SUM(IF(MONTH(fecha) = 7, total, 0)) AS jul,
        SUM(IF(MONTH(fecha) = 8, total, 0)) AS ago,
        SUM(IF(MONTH(fecha) = 9, total, 0)) AS sep,
        SUM(IF(MONTH(fecha) = 10, total, 0)) AS oct,
        SUM(IF(MONTH(fecha) = 11, total, 0)) AS nov,
        SUM(IF(MONTH(fecha) = 12, total, 0)) AS dic 
        FROM $table WHERE fecha BETWEEN '$desde' AND '$hasta' AND estado = 1 AND id_sucursal = $id_sucursal";
        return $this->select($sql);
    }

    public function totalVentasCompras($table, $desde, $hasta, $id_sucursal)
    {
        $sql = "SELECT COUNT(id) AS total FROM $table WHERE fecha BETWEEN '$desde' AND '$hasta' AND estado = 1 AND id_sucursal = $id_sucursal";
        return $this->select($sql);
    }

    public function topProductos($cantidad, $id_sucursal)
    {
        $sql = "SELECT p.*, c.categoria FROM productos p INNER JOIN categorias c ON p.id_categoria = c.id WHERE p.id_sucursal = $id_sucursal ORDER BY p.ventas DESC LIMIT $cantidad";
        return $this->selectAll($sql);
    }

    public function nuevosProductos($cantidad, $id_sucursal)
    {
        $sql = "SELECT p.*, c.categoria FROM productos p INNER JOIN categorias c ON p.id_categoria = c.id WHERE p.id_sucursal = $id_sucursal ORDER BY p.id DESC LIMIT $cantidad";
        return $this->selectAll($sql);
    }

    public function calcularGatos($desde, $hasta, $id_sucursal)
    {
        $sql = "SELECT SUM(IF(MONTH(fecha) = 1, monto, 0)) AS ene,
        SUM(IF(MONTH(fecha) = 2, monto, 0)) AS feb,
        SUM(IF(MONTH(fecha) = 3, monto, 0)) AS mar,
        SUM(IF(MONTH(fecha) = 4, monto, 0)) AS abr,
        SUM(IF(MONTH(fecha) = 5, monto, 0)) AS may,
        SUM(IF(MONTH(fecha) = 6, monto, 0)) AS jun,
        SUM(IF(MONTH(fecha) = 7, monto, 0)) AS jul,
        SUM(IF(MONTH(fecha) = 8, monto, 0)) AS ago,
        SUM(IF(MONTH(fecha) = 9, monto, 0)) AS sep,
        SUM(IF(MONTH(fecha) = 10, monto, 0)) AS oct,
        SUM(IF(MONTH(fecha) = 11, monto, 0)) AS nov,
        SUM(IF(MONTH(fecha) = 12, monto, 0)) AS dic 
        FROM gastos WHERE fecha BETWEEN '$desde' AND '$hasta' AND id_sucursal = $id_sucursal";
        return $this->select($sql);
    }

    public function minimosProductos($id_sucursal)
    {
        $sql = "SELECT descripcion, cantidad FROM productos WHERE cantidad < 15 AND id_sucursal = $id_sucursal LIMIT 4";
        return $this->selectAll($sql);
    }

    //reporte pdf
    public function minimosProductosPDF($id_sucursal)
    {
        $sql = "SELECT p.*, c.categoria FROM productos p INNER JOIN categorias c ON p.id_categoria = c.id WHERE p.cantidad < 15 AND p.id_sucursal = $id_sucursal";
        return $this->selectAll($sql);
    }

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


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

    public function limpiraDatos()
    {
        $sql = "TRUNCATE acceso";
        return $this->select($sql);
    }

    // BACKUP

    public function getTables() {
        return $this->selectColum("SHOW TABLES");
    }
    
    public function getTableStructure($table) {
        $tableData = $this->select("SHOW CREATE TABLE $table");
        return $tableData['Create Table'];
    }
    
    public function getTableData($table) {
        return $this->selectAll("SELECT * FROM $table");
    }
    
    public function quoteValue($value) {
        return $this->quoteValueQuery($value);
    }
}
?>
User / IP	: 216.73.216.146
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