Tul xxx Tul

Viewing: PrincipalModel.php

<?php
class PrincipalModel extends Query{
    public function __construct() {
        parent::__construct();
    }
    //datos para login
    public function getDatos($correo)
    {
        $sql = "SELECT u.id, u.nombre, u.correo, u.perfil, u.clave, u.estado, u.rol, u.id_sucursal, r.nombre AS rol_name, r.permisos FROM usuarios u LEFT JOIN roles r ON u.rol = r.id WHERE u.correo = '$correo' AND u.estado = 1";
        return $this->select($sql);
    }

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

    public function getProductosPublicos()
    {
        $sql = "SELECT p.id, p.descripcion, p.precio_venta, p.foto, c.categoria, mar.marca 
                FROM productos p 
                INNER JOIN categorias c ON p.id_categoria = c.id 
                INNER JOIN marcas mar ON p.id_marca = mar.id 
                WHERE p.estado = 1";
        return $this->selectAll($sql);
    }

    public function getPermisos()
    {
        return $this->selectAll("SELECT * FROM permisos");
    }

    public function verificarCorreo($correo)
    {
        $sql = "SELECT id FROM usuarios WHERE correo = '$correo' AND estado = 1";
        return $this->select($sql);
    }

    public function registrarToken($token, $correo)
    {
        $sql = "UPDATE usuarios SET token = ? WHERE correo = ?";
        $array = array($token, $correo);
        return $this->save($sql, $array);
    }

    public function verificarToken($token)
    {
        $sql = "SELECT id, token FROM usuarios WHERE token = '$token' AND estado = 1";
        return $this->select($sql);
    }

    public function modificarClave($clave, $token)
    {
        $sql = "UPDATE usuarios SET clave = ?, token = ? WHERE token = ?";
        $array = array($clave, null, $token);
        return $this->save($sql, $array);
    }

    //registrar log
    public function registrarAcceso($evento, $ip, $detalle)
    {
        $sql = "INSERT INTO acceso (evento, ip, detalle) VALUES (?,?,?)";
        $array = array($evento, $ip, $detalle);
        return $this->insertar($sql, $array);
    }

    public function getReparacion($id)
    {
        $sql = "SELECT r.*, c.nombre AS cliente, c.telefono, c.direccion, m.marca
                FROM reparaciones r
                LEFT JOIN clientes c ON r.id_cliente = c.id
                LEFT JOIN marcas m ON r.id_marca = m.id
                WHERE r.id = $id";
        return $this->select($sql);
    }
}

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