<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Menus {
public $listMenus;
public $listSeo;
public function __construct(){
$this->CI =& get_instance();
$this->CI->load->database('default');
$this->set();
}
public function set(){
$query = $this->CI->db->select('*')->from( "menu" )->where("parente", 0)->where("ativo", 1)->order_by('posicao', 'asc')->get();
$menusPai = ( $query->num_rows() > 0 )? $query->result_array() : false;
$query2 = $this->CI->db->select('*')->from( "menu" )->where("parente > 0")->where("ativo", 1)->order_by('posicao', 'asc')->get();
$menusFilhos = ( $query2->num_rows() > 0 )? $query2->result_array() : false;
$menus = array();
foreach ( $menusPai as $key => $value) {
$this->listSeo[$value['link']]['pagina_titulo'] = $value['pagina_titulo'];
$this->listSeo[$value['link']]['pagina_keywords'] = $value['pagina_keywords'];
$this->listSeo[$value['link']]['pagina_description'] = $value['pagina_description'];
$menus[$value['id']]['filhos'] = array();
$menus[$value['id']]['dados'] = $value;
if($menusFilhos){
foreach ($menusFilhos as $k => $v) {
if($v['parente'] == $value['id']){
$this->listSeo[$v['link']]['pagina_titulo'] = $v['pagina_titulo'];
$this->listSeo[$v['link']]['pagina_keywords'] = $v['pagina_keywords'];
$this->listSeo[$v['link']]['pagina_description'] = $v['pagina_description'];
$menus[$value['id']]['filhos'][] = $v;
}
}
}
}
$this->listMenus = $menus;
}
public function get(){
return $this->listMenus;
}
public function seo($tag){
$uri = ($this->CI->uri->uri_string() == '')? '/' : $this->CI->uri->uri_string();
return $this->listSeo[$uri][$tag];
}
}