MR K IS HERE

MRKShell

Server IP : 172.67.193.120 / Your IP : 172.71.28.167
Web Server : nginx/1.14.1
System : Linux comtuc2-s-2vcpu-8gb-160gb-intel-nyc3 4.18.0-348.7.1.el8_5.x86_64 #1 SMP Wed Dec 22 13:25:12 UTC 2021 x86_64
User : nginx ( 991)
PHP Version : 7.2.34
Disable Function : NONE
MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON
Directory : /var/www/comunicacion/produccion/hitadmin/application/models/

Upload File :

[ HOME SHELL ]

Current File : /var/www/comunicacion/produccion/hitadmin/application/models/Eventos_md.php

<?php

class Eventos_md extends CI_Model {

    function __construct() {
        parent::__construct();
    }

    function getUltimosEventos() {
        $query = $this->db->query("
                        SELECT e.id, e.titulo, e.habilitado, DATE_FORMAT(a.fechai, '%d/%m/%Y') AS fecha, t.nombre AS seccion
                        FROM evento e
                        INNER JOIN agenda AS a ON e.id = a.evento_id
                        INNER JOIN tipo_evento AS t ON e.tipo = t.id
                        ORDER BY e.id DESC LIMIT 100");
        return $query->result();
    }

    //, e.user_id, u.nombre AS nombre, u.apellido AS apellido
    //    INNER JOIN users AS u ON e.user_id = u.id

    function getHistorialPorEvento($evento) {
        $query = $this->db->query("
                        SELECT u.usuario_nombre, u.operacion_id, u.operacion, u.objeto_id, DATE_FORMAT(u.fecha, '%H:%i %d-%m-%Y') AS fecha, au.descripcion
                        FROM usuario_historial u
                        INNER JOIN accion_auditoria au ON u.operacion_id = au.id
                        WHERE u.objeto_id = $evento
                        ORDER BY u.fecha DESC");
        return $query->result();
    }

    function getLike($texto) {
        $sql = $this->db->query("
                SELECT DISTINCT id, DATE_FORMAT(fechaAlta,'%d/%m/%Y') as fecha, titulo
                FROM nota
                WHERE (titulo like '%$texto%' /*or texto like '%$texto%'*/ or id like '%$texto%')
                GROUP BY id DESC limit 10");
        return $sql->result();
    }

    function getEntidad($texto) {
        $sql = $this->db->query("
                SELECT DISTINCT e.id, e.nombre
                FROM entidad e
                WHERE (e.nombre like '%$texto%' /*or e.descripcion like '%$texto%'*/ or e.id like '%$texto%')
                GROUP BY e.id DESC limit 10");
        return $sql->result();
    }

    function getEventoFoto($evento) {
        $query = $this->db->query("
                        SELECT f.id, f.ruta, f.imagen, f.titulo
                        FROM efoto f
                        INNER JOIN relacion_evento r ON f.id = r.objeto_id
                        WHERE r.evento_id = $evento AND r.tipo = 30
                        LIMIT 1");
        return $query->row();
    }

    function getEventoVideo($evento) {
        $query = $this->db->query("
                        SELECT v.id, v.video, v.codigo, v.titulo
                        FROM evideo v
                        INNER JOIN relacion_evento r ON v.id = r.objeto_id
                        WHERE r.evento_id = $evento AND r.tipo = 2
                        LIMIT 1");
        return $query->row();
    }

    function getEventoLugar($evento) {
        $query = $this->db->query("
                        SELECT l.id, r.id as rel
                        FROM lugar l
                        INNER JOIN relacion_evento r ON l.id = r.objeto_id
                        WHERE r.evento_id = $evento AND r.tipo = 45
                        LIMIT 1");
        return $query->row();
    }
    
    function getEventoRelLugar($evento) {
        $query = $this->db->query("
                        SELECT r.id
                        FROM relacion_evento r
                        WHERE r.evento_id = $evento AND r.tipo = 45
                        LIMIT 1");
        return $query->row();
    }

    function getArtistasRelacionados($evento) {
        $query = $this->db->query("
                        SELECT e.id, e.nombre
                        FROM entidad e
                        INNER JOIN relacion_evento r ON e.id = r.objeto_id
                        WHERE r.evento_id = $evento AND r.tipo = 44");
        return $query->result();
    }

    function delRelacionEntidad($evento, $entidad) {
        $this->db->where('evento_id', $evento);
        $this->db->where('objeto_id', $entidad);
        $this->db->where('tipo', '44');
        $this->db->delete('relacion_evento');
        if ($this->db->affected_rows() == '1') {
            return TRUE;
        } else {
            return FALSE;
        }
    }

    function getBuscarEvento($busqueda) {
        $texto = explode("%20", $busqueda);
        $total = count($texto);
        $consulta = "SELECT e.id, e.titulo, e.tipo, e.subtipo, e.habilitado, DATE_FORMAT(a.fechai, '%d/%m/%Y') AS fecha, e.user_id, t.nombre AS tipo, u.nombre AS nombre, u.apellido AS apellido
               FROM evento e
               INNER JOIN agenda AS a ON e.id = a.evento_id
               INNER JOIN tipo_evento AS t ON e.tipo = t.id
               INNER JOIN users AS u ON e.user_id = u.id";

        if ($total == 1) {
            $consulta .= " WHERE (e.titulo like '%$texto[0]%' or e.descripcion like '%$texto[0]%')";
        } else {
            $i = 1;
            $ii = 0;
            while ($i < $total) {
                if ($i == 1) {
                    $consulta .= " WHERE ";
                } else {
                    $consulta .= " AND ";
                }
                $consulta .= "(e.titulo like '%$texto[$ii]%' or e.descripcion like '%$texto[$ii]%')";
                $i++;
                $ii++;
            }
        }

        $consulta .= "ORDER BY e.id DESC limit 50";

        $sql = $this->db->query($consulta);
        return $sql->result();
    }

}

Anon7 - 2022
AnonSec Team