404

D7net
:/ var / www / html / crsys_ant / adm / app / adms / Models /
Filename : AdmsMenuOriginal.php
back
<?php

namespace App\adms\Models;

if (!defined('URL')) {
    header("Location: /");
    exit();
}

/**
 * Description of AdmsMenu
 *
 * @copyright (c) year, Cesar Szpak - Celke
 */
class AdmsMenu
{
    private $Resultado;
   
    function getResultado()
    {
        return $this->Resultado;
    }

            
    public function itemMenu()
    { 
        
      
        $listItemMenu = new \App\adms\Models\helper\AdmsRead();
       //var_dump($_SESSION['id_user']);
       //var_dump($_SESSION['usuario_id']);
       // die;
        if(isset($_SESSION['id_user'])) {
            $listItemMenu->fullRead("SELECT  pg.dropdown,
                                           men.id id_men, 
                                           men.nome nome_men, 
                                           men.icone icone_men,
                                           pg.id id_pg, 
                                           pg.menu_controller, 
                                           pg.menu_metodo, 
                                           pg.nome_pagina, 
                                           pg.icone icone_pg
                                      FROM adms_paginas pg
                                      INNER JOIN adms_menus men 
                                         ON men.id= pg.menu_id
                                     
                                      inner join adms_empr_mod empmod
                                         on empmod.empr_id = :user_id
                                        and empmod.mod_id = men.adms_mod_id
                                       inner join adm_usu_mod usumod
                                         on usumod.empr_id = :user_id
                                        and usumod.mod_id = men.adms_mod_id  
                                        and usumod.usuario_id = :usuario_id
                                        left join adms_restricao r
                                        on r.pag_id = pg.id
                                  WHERE pg.lib_menu = :lib_menu
                                    and pg.adms_sits_pg_id = 1
                                    and r.pag_id  is null
                                  ORDER BY men.ordem, pg.ordem", 
                                  "usuario_id=".$_SESSION['usuario_id']."&user_id=".$_SESSION['id_user']."&lib_menu=1");
        }else{
            $listItemMenu->fullRead("SELECT pg.dropdown,
                                           men.id id_men, 
                                           men.nome nome_men, 
                                           men.icone icone_men,
                                           pg.id id_pg, 
                                           pg.menu_controller, 
                                           pg.menu_metodo, 
                                           pg.nome_pagina, 
                                           pg.icone icone_pg
                                      FROM adms_paginas pg
                                      INNER JOIN adms_menus men 
                                         ON men.id= pg.menu_id
                                     
                                     
                                       
                                  WHERE pg.lib_menu = :lib_menu
                                    and pg.adms_sits_pg_id = 1
                                   
                                  ORDER BY men.ordem, pg.ordem", 
                                  "lib_menu=1");
  } 
  
        $this->Resultado = $listItemMenu->getResultado();
     //  var_dump( $this->Resultado);
     //   die;
        return $this->Resultado;
    }
}