Exemplo n.º 1
0
 public static function getMenuAdmin()
 {
     echo '</pre>';
     $menu = new menuModel(self::$doctrineService);
     echo '<pre>';
     print_r($menu->findAll());
     echo '</pre>';
 }
Exemplo n.º 2
0
 public function getPages($menu_id)
 {
     if (empty(self::$conn)) {
         self::$conn = $this->connect_pdo();
     }
     $sql = "SELECT p.id,p.name,p.des,p.image_icon,p.des,p.time_on,CONCAT_WS(' ',first_name,last_name) AS user_name,p.author_id\n\t\t\t\t\tFROM pages AS p \n\t\t\t\t\tLEFT JOIN page_menu AS pmn\n\t\t\t\t\t\tON p.id=pmn.page_id \n\t\t\t\t\tLEFT JOIN users AS u\n\t\t\t\t\t\tON u.id=p.author_id\n\t\t\t\t\tWHERE pmn.menu_id =?";
     $stmt = self::$conn->prepare($sql);
     $stmt->bindParam(1, $menu_id);
     $stmt->execute();
     $stmt->setFetchMode(PDO::FETCH_ASSOC);
     $i = 0;
     $pages = array(array());
     while ($row = $stmt->fetch()) {
         $pages[$i++] = $row;
     }
     $i--;
     return $pages;
 }
Exemplo n.º 3
0
 public function delete($id)
 {
     // Connect to database ...
     if (empty(self::$conn)) {
         self::$conn = $this->connect_pdo();
     }
     $stmt = self::$conn->prepare('DELETE FROM menu WHERE id=?');
     $stmt->bindParam(1, $id);
     if ($stmt->execute()) {
         return true;
     } else {
         return false;
     }
 }
Exemplo n.º 4
0
 public function geramenu()
 {
     $objMenu = new menuModel();
     //die_a($_SESSION['user']['controllers_autorizados']);
     $retorno = $objMenu->getMenuByUsurio($_SESSION['user']['controllers_autorizados']);
     $menu_pai = null;
     foreach ($retorno as $key => $value) {
         if ($value['tipo'] == 1) {
             $menu_pai[] = array('id' => $value['id_menu'], 'descricao' => $value['descricao'], 'link' => $value['url']);
         }
     }
     $menu_filho = null;
     foreach ($retorno as $key => $value1) {
         if ($value1['parent_menu'] != 0) {
             $menu_filho[] = array('id_pai' => $value1['parent_menu'], 'descricao' => $value1['descricao'], 'link' => $value1['url']);
         }
     }
     $menu_principal = null;
     foreach ($menu_pai as $key => $value) {
         $menu_principal[] = array('id' => $value['id'], 'id_pai' => 0, 'id_filho' => 0, 'descricao' => $value['descricao'], 'link' => $value['link']);
         if (isset($menu_filho)) {
             foreach ($menu_filho as $key1 => $value1) {
                 if ($value['id'] == $value1['id_pai']) {
                     $menu_principal[$key]['filhos'][] = array('id' => $key1, 'id_pai' => $value1['id_pai'], 'id_filho' => 0, 'descricao' => $value1['descricao'], 'link' => $value1['link']);
                 }
             }
         }
     }
     $this->smarty->assign('dados_menu', $menu_principal);
     $_SESSION['user']['menu_sidebar'] = $this->smarty->fetch('comuns/sidebar_dinamico.tpl');
     $menu = $_SESSION['user']['menu_sidebar'];
     return $menu;
 }