404

D7net
:/ var / www / html / crsys / adm / app / adms / Models /
Filename : AdmsMenu_1.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("WITH recursive menu_tree AS (
                                        SELECT ma.id, 
                                               ma.nome, 
                                               ma.parent_id,
                                               ma.ordem,
                                               ma.controller, 
                                               ma.metodo,
                                                case  when  ma.icone is NULL then
                                                'far fa-address-book'
                                                else
                                                 ma.icone
                                                 end icone,
                                               ma.menu_controller,
                                               ma.menu_metodo
                                        FROM menu ma	
                                         inner join adms_empr_mod empmod
                                                     on empmod.empr_id = :user_id
                                                    and empmod.mod_id = ma.adms_mod_id
                                               inner join adm_usu_mod usumod
                                                     on usumod.empr_id = :user_id
                                                    and usumod.mod_id = ma.adms_mod_id  
                                                    and usumod.usuario_id = :usuario_id
                                                    left join adms_restricao r
                                                    on r.pag_id = ma.id
                                        WHERE ma.adms_sits_id = 1
                                          and ma.lib_menu = :lib_menu 
                                          and ma.parent_id IS NULL
                                           and r.pag_id IS NULL
                                        UNION ALL
                                        SELECT m.id, 
                                               m.nome, 
                                               m.parent_id, 
                                               m.ordem,
                                               m.controller, 
                                               m.metodo,
                                               case   when m.icone is NULL then
                                                'far fa-address-book'
                                                else
                                                 m.icone
                                                 end icone,
                                               m.menu_controller,
                                               m.menu_metodo
                                        FROM menu m
                                        JOIN menu_tree mt ON m.parent_id = mt.id
                                        where m.lib_menu = :lib_menu)
                                    SELECT * FROM menu_tree  order by 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,
                                           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();
        return $this->Resultado;
    }
}