MR K IS HERE

MRKShell

Server IP : 104.21.73.244 / 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/Foto_md.php

<?php

class Foto_md extends CI_Model {

    function __construct() {
        parent::__construct();
        $this->load->database();
        $this->created_at = date("Y-m-d H:i:s");
    }

    public function add() {

        $sql = 'INSERT INTO foto (ruta,imagen,descripcion,fechaalta,usuario_id) value (?,?,?,?,?)';
        $this->db->query($sql, array($this->ruta, $this->imagen, $this->descripcion, $this->created_at, $this->usuario_id));
    }

    public function addEditor() {

        $sql = "INSERT INTO foto (ruta,imagen,fechaalta,usuario_id) VALUE (?,?,?,?)";
        $this->db->query($sql, array($this->ruta, $this->imagen, $this->created_at, $this->usuario_id));
    }

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

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

    public function getById($id) {
        $sql = 'SELECT * FROM foto WHERE id=?';
        $query = $this->db->query($sql, array($id));
        return $query->result();
    }

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

    public function getAll() {
        $sql = $this->db->query('SELECT * FROM foto order by fechaalta desc');
        return $sql->result();
    }

    public function getLast() {
        $sql = $this->db->query('SELECT * FROM foto order by fechaalta desc limit 1');
        return $sql->result();
    }

    public function idsFotosRelacionadas($nota_id) {
        $sql = "SELECT f.id as idF, f.descripcion as descripcion, f.ruta as ruta, f.imagen as imagen FROM foto f INNER JOIN relacion r on (r.objeto_id = f.id) 
		where r.tipo = 30 and r.nota_id = " . $nota_id;

        $query = $this->db->query($sql, array($nota_id));

        if ($query->num_rows() > 0) {
            $result = $query->result();
            return $result;
        } else {
            return false;
        }
    }

    public function idsFotosRelacionadasEvento($evento_id) {
        $sql = "SELECT f.id as idF, f.descripcion as descripcion, f.ruta as ruta, f.imagen as imagen FROM foto f INNER JOIN relacion_evento r on (r.objeto_id = f.id) 
		where r.tipo = 30 and r.evento_id = " . $evento_id;

        $query = $this->db->query($sql, array($evento_id));

        if ($query->num_rows() > 0) {
            $result = $query->result();
            return $result;
        } else {
            return false;
        }
    }

    public function buscarFotosRelacionadas($nota_id) {
        $this->db->select(" f.descripcion as descripcion, f.rutas as ruta");
        $this->db->from("foto f");
        $this->db->join("relacion r", "r.objeto_id = f.id", "inner");
        $this->db->where("r.nota_id", $nota_id);
        $this->db->where("r.tipo", 30);
        $this->db->order_by("r.orden asc");
        $query = $this->db->get();
        if ($query->num_rows() > 0) {
            $res = $query->result_array();
            return $res;
        } else
            return false;
    }

    public function buscar_foto_descripcion($busqueda) {

        if($busqueda == 'lasultimasveintefotos'){

            $this->db->select("id, CONCAT('fotos/', ruta, imagen) AS ruta, descripcion");
            $this->db->from("foto");
            $this->db->where("habilitada", 1);
            $this->db->limit(20,0);
            $this->db->order_by("fechaalta desc");
    
            $query = $this->db->get();
            if ($query->num_rows() > 0) {
                $res = $query->result_array();
                return $res;
            } else
                return false;

        }else {

       
        $this->db->select("id, CONCAT('fotos/', ruta, imagen) AS ruta, descripcion");
        $this->db->from("foto");
        $this->db->where("habilitada", 1);
        $this->db->like("descripcion", $busqueda);
        $this->db->order_by("fechaalta desc");

        $query = $this->db->get();
        if ($query->num_rows() > 0) {
            $res = $query->result_array();
            return $res;
        } else
            return false;
    } }



    public function updateDescripcion($id, $desc) {

        $sql = "UPDATE foto SET descripcion=?	WHERE id=?";
        $query = $this->db->query($sql, array($id, $desc));
    }

}

?>

Anon7 - 2022
AnonSec Team