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/vuelos/application/models/

Upload File :

[ HOME SHELL ]

Current File : /var/www/comunicacion/produccion/vuelos/application/models/Permisos_md.php

<?php
class Permisos_md extends CI_Model {

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


  function get_all(){
    $query = $this->db->get('groups');
    return $query->result();
  }

  function getAll(){
    $user_row = $this->ion_auth->user()->row();
    if (!$this->ion_auth->in_group(1, $user_row->id)){
      $query = $this->db
                    ->select('p.*, g.name AS grupo, m.descripcion AS menu')
                    ->join('groups g','p.group_id = g.id')
                    ->join('menus m', 'p.menu_id = m.id')
                    ->where('p.group_id !=', 1)
                    ->get('permisos p');
    }else{
      $query = $this->db
                    ->select('p.*, g.name AS grupo, m.descripcion AS menu')
                    ->join('groups g','p.group_id = g.id')
                    ->join('menus m', 'p.menu_id = m.id')
                    ->get('permisos p');      
    }
    
    return $query->result();
  }

  function buscar(/*$perpage,$start*/){
    $query = $this->db
    ->select('permisos.id AS id,
     menus.descripcion AS menu,
     groups.id AS id_grupo,
     groups.description 	AS grupo,
     permisos.read AS Leer,
     permisos.insert AS Insertar,
     permisos.update AS Actualizar,
     permisos.delete AS Borrar,
     permisos.exportar AS Exportar,
     permisos.imprimir AS Imprimir')
    ->join('menus', 	'menus.id = permisos.menu_id', 'inner')
    ->join('groups', 	'groups.id = permisos.group_id', 'inner');

    if($where = $this->input->post('buscar', TRUE))
      $query = $this->db->where('permisos.id =', $where)
      ->or_where("menus.descripcion LIKE '%".$where."%'")
      ->or_where("groups.description LIKE '%".$where."%'");

    $query = $this->db
    ->get('permisos');
    return $query->result('array');
  }

  function count_buscar($perpage,$start){
    $query = $this->db
    ->join('menus', 	'menus.id = permisos.menu_id', 'inner')
    ->join('groups', 	'groups.id = permisos.group_id', 'inner');
    if($where = $this->input->post('buscar', TRUE))
      $query = $this->db->where('id =', $where);
    $query = $this->db->limit($perpage,$start)
    ->get('permisos');
    return $query->num_rows();
  }

  function getByLink($link){
    $query = $this->db
    ->select('id')
    ->where('link',$link)
    ->get('menus');
    return $query->row();
  }

  function buscarPermiso($url, $perfil){
    $query = $this->db
                    ->select('p.read')
                    ->join('menus m', 'm.id = p.menu_id')
                    ->where('p.group_id', $perfil)
                    ->like('m.link', $url)
                    ->get('permisos p');
    return $query->row();
  }

  function buscarGrupo($usuario){
    $query = $this->db
                    ->select('group_id')
                    ->where('user_id', $usuario)
                    ->get('users_groups');
    return $query->row();
  }
}

Anon7 - 2022
AnonSec Team