MR K IS HERE

MRKShell
Server IP : 172.67.193.120 / Your IP : 104.23.243.234
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/Evento_md.php
<?php

class Evento_md extends CI_Model {

    function __construct() {
        parent::__construct();
        $this->load->database();
        $this->load->library('VariosLibrary_lb.php');
        //valores por defecto de las variables

        $this->tipo = 1;
        $this->titulo = "";
        $this->descripcion = "";
        $this->habilitado = "0";
        $this->fechaAlta = date("Y-m-d H:i:s");
        $this->fechamod = date("Y-m-d H:i:s");
        $this->url = "";
        $this->user_id = "";
        $this->acceso_cultural = 0;
        $this->descripcion_acceso = "";
    }

    public function add() {

        /* $urlAmig = new ObtenerUrl_lb();
          $this->url=$urlAmig->urls_amigables($this->titulo); */
        $urlAmig = new VariosLibrary_lb();
        $url = $urlAmig->limpiarurl($this->titulo);
        $url = $urlAmig->amigar_cadena($url);
        $var = filter_var($url, FILTER_SANITIZE_STRING, FILTER_FLAG_STRIP_LOW);
        $this->url = trim($var) . ".html";

        $sql = "INSERT INTO evento (tipo,subtipo,titulo,descripcion,habilitado,url,fechaAlta,fechamod,user_id,acceso_cultural,descripcion_acceso) VALUE (?,?,?,?,?,?,?,?,?,?,?)";
        $this->db->query($sql, array($this->tipo, $this->subtipo, $this->titulo, $this->descripcion, $this->habilitado, $this->url, $this->fechaAlta, $this->fechamod, $this->user_id, $this->acceso_cultural, $this->descripcion_acceso));
    }

    public function delById($id) {
        $sql = 'DELETE FROM evento WHERE id=?';
        $query = $this->db->query($sql, array($id));
    }

    public function del() {
        $sql = $this->db->query('DELETE FROM evento WHERE id=$this->id');
    }

    public function update($id) {

        $urlAmig = new VariosLibrary_lb();
        $url = $urlAmig->limpiarurl(html_entity_decode($this->titulo));
        $url = $urlAmig->amigar_cadena($url);
        $var = filter_var($url, FILTER_SANITIZE_STRING, FILTER_FLAG_STRIP_LOW);
        $this->url = trim($var) . ".html";

        $sql = 'UPDATE evento SET tipo=?, subtipo=?,
								 titulo=?,
								descripcion=?,
								 habilitado=?,
								 url=?,
								 fechamod=?,
								 user_id=?,
								 acceso_cultural=?
								 WHERE id=?';
        $this->db->query($sql, array($this->tipo, $this->subtipo, $this->titulo, $this->descripcion, $this->habilitado, $this->url, $this->fechamod, $this->user_id, $this->acceso_cultural, $id));
    }

    public function setHora($id) {
        $sql = 'UPDATE evento SET fechamod=? WHERE id=?';
        $this->db->query($sql, array($this->fechamod, $id));
    }

    public function getById($id) {
        $sql = "SELECT * 
				FROM evento as e
				INNER JOIN agenda as a
				ON a.evento_id=e.id
				where e.id=?";
        $query = $this->db->query($sql, array($id));
        return $query->result();
    }
    
    public function getByIdRel($id) {
        $sql = "SELECT e.id, DATE_FORMAT(a.fechai,'%d/%m/%Y') as fecha, e.titulo 
				FROM evento as e
				INNER JOIN agenda as a
				ON a.evento_id=e.id
				where e.id=?";
        $query = $this->db->query($sql, array($id));
        return $query->result();
    }

    public function countAllFROMToday() {
        $sql = $this->db->query('SELECT count(*) as c FROM evento WHERE date(fechaAlta)=date(NOW())');
        return $sql->result();
    }

    public function getAll() {
        $sql = $this->db->query('SELECT * FROM evento  ORDER BY fechaAlta DESC');
        return $sql->result();
    }

    public function getPorFecha($fecha) {
        $sql = "SELECT e.id,e.titulo,e.habilitada,e.usuario_id,e.id_seccion,e.id_subseccion,e.fechaAlta 
				FROM evento as e INNER JOIN agenda as ev ON e.id=ev.id_evento
				WHERE ev.fechai=? ORDER BY ev.fechai DESC";
        $query = $this->db->query($sql, array($fecha));
        $res = $query->result_array();
        if ($query->num_rows() > 0)
            return $res;
        else
            return false;
    }

    public function getPorId() {
        $sql = "SELECT n.id,n.titulo,n.habilitado,DATE_FORMAT(n.fechamod, '%H:%i') as hora,n.user_id,DATE_FORMAT(n.fechaAlta, '%d/%m/%Y') as fechaAlta,n.url,e.fechai 
				FROM evento n 
				INNER JOIN agenda e ON e.evento_id=n.id
				ORDER BY n.id DESC LIMIT 50";
        $query = $this->db->query($sql);
        $res = $query->result_array();
        if ($query->num_rows() > 0)
            return $res;
        else
            return false;
    }

    public function getLast1() {
        $sql = 'SELECT id FROM evento ORDER BY fechaAlta DESC limit 1';
        $query = $this->db->query($sql);
        if ($query->num_rows() > 0) {
            $res = $query->result_array();
            return $res[0]['id'];
        } else
            return false;
    }

    public function getLike($q) {
        $sql = $this->db->query("SELECT DISTINCT e.id, DATE_FORMAT(a.fechai,'%d/%m/%Y') as fecha, e.titulo FROM evento e INNER JOIN agenda a ON e.id = a.evento_id WHERE (e.titulo like '%$q%' or e.descripcion like '%$q%') GROUP BY e.id DESC limit 1");
        return $sql->result();
    }

    /* consultas para la paginacion */

    public function total_paginados($por_pagina, $segmento) {
        $consulta = "SELECT id, DATE_FORMAT(fechaAlta,'%d-%m-%Y') as fecha
    				   FROM evento ORDER BY id DESC";
        //LIMIT ".$por_pagina." OFFSET ".$segmento;

        $query = $this->db->query($consulta);

        if ($query->num_rows() > 0) {
            foreach ($query->result() as $fila) {
                $data[] = $fila;
            }
            return $data;
        }
    }

    public function contadorNotas() {
        //	$consulta = $this->db->get('evento');
        //	return  $consulta->num_rows() ;
    }

    public function traerNotaPorEdicion($id) {

        $consulta = "SELECT nt.*, ed.fecha FROM evento AS nt
				   join edicion AS ed ON nt.edicion_id=ed.id
				   WHERE ed.id=" . $id;
        $query = $this->db->query($consulta);
        $res = $query->result_array();

        if ($query->num_rows() > 0)
            return $res;
        else
            return false;
    }

    public function cambiarEdicion($nota_id, $edicion_id) {

        $sql = "update evento set edicion_id = '" . $edicion_id . "' where id = '" . $nota_id . "'";
        $query = $this->db->query($sql);
    }

    public function setTitulo($titulo, $id) {
        $sql = "UPDATE evento SET titulo = ? WHERE id = ? ";
        $query = $this->db->query($sql, array($titulo, $id));
    }

    public function buscador($q) {
        $consulta = "SELECT e.id, e.titulo, e.habilitado, e.user_id, DATE_FORMAT(e.fechaAlta,'%d-%m-%Y') AS fechaAlta
                     FROM lugar l
                     INNER JOIN relacion_evento re ON re.objeto_id=l.id
                     INNER JOIN evento e ON e.id = re.evento_id
                     WHERE re.tipo = 45 AND (l.nombre LIKE '%$q%')

                     UNION

                     SELECT e.id, e.titulo, e.habilitado, e.user_id, DATE_FORMAT(e.fechaAlta,'%d-%m-%Y') AS fechaAlta
                     FROM entidad en
                     INNER JOIN relacion_evento re ON re.objeto_id=en.id
                     INNER JOIN evento e ON e.id = re.evento_id
                     WHERE re.tipo = 44 AND (en.nombre LIKE '%$q%')

                     UNION

                     SELECT e.id, e.titulo, e.habilitado, e.user_id, DATE_FORMAT(e.fechaAlta,'%d-%m-%Y') AS fechaAlta
                     FROM evento e
                     INNER JOIN agenda ev ON e.id=ev.evento_id
                     WHERE e.id LIKE '%$q%' OR e.titulo LIKE '%$q%' OR ev.fechai LIKE '%$q%' OR DATE_FORMAT(ev.fechai, '%d-%m-%Y') LIKE '%$q%' OR DATE_FORMAT(ev.fechai, '%d/%m/%Y') LIKE '%$q%'

                     ORDER BY fechaAlta Desc";

        $query = $this->db->query($consulta);

        if ($query->num_rows() > 0) {
            foreach ($query->result() as $fila) {
                $data[] = $fila;
            }
            return $data;
        }
    }

    public function listadoPorId($id) {
        $sql = 'SELECT * FROM evento WHERE id=?';
        $query = $this->db->query($sql, array($id));
        if ($query->num_rows() > 0) {
            foreach ($query->result() as $fila) {
                $data[] = $fila;
            }
            return $data;
        }
    }

    public function listado() {
        $sql = 'SELECT * FROM evento where habilitado=1 GROUP BY id DESC limit 10';
        $query = $this->db->query($sql);
        if ($query->num_rows() > 0) {
            foreach ($query->result() as $fila) {
                $data[] = $fila;
            }
            return $data;
        } else {
            return false;
        }
    }

    public function setHabilitar($hab, $id) {
        $sql = "UPDATE evento SET habilitado = ? WHERE id = ? ";
        $query = $this->db->query($sql, array($hab, $id));
    }

    public function addTipo($nombre) {

        if ($this->db->insert("tipo_evento", $nombre))
            return true;
        else
            return false;
    }

    public function agregarRelacionNota($nota_id, $evento_id) {
        //$orden = $this->dameOrdenRelacionNota($nota_id);
        $datos['nota_id'] = $nota_id;
        $datos['objeto_id'] = $evento_id;
        $datos['tipo'] = 36;
        $datos['orden'] = 1;
        $datos['descripcion'] = 'Evento relacionada';
        if ($this->db->insert("relacion", $datos))
            return true;
        else
            return false;
    }

    public function dameNombreEvento($id) {
        $sql = 'SELECT titulo FROM evento where id=?';
        $query = $this->db->query($sql, array($id));
        if ($query->num_rows() > 0) {
            $res = $query->result_array();
            return $res[0]['titulo'];
        } else
            return false;
    }

}

?>
Anon7 - 2022
AnonSec Team