/**
* @access public
* @static
* Retourne la liste des langues disponible
*/
public function setAvailableLang()
{
$sql = 'SELECT l.idlang, l.iso, l.language
FROM mc_lang AS l
WHERE l.active_lang = 1
ORDER BY l.idlang';
return component_routing_db::layer()->fetchAll($sql);
}
/**
* @static
* @throws Exception
* @return db_layer
*/
public static function layer()
{
if (class_exists('db_layer')) {
self::$layer = new db_layer();
if (self::$layer instanceof db_layer) {
return self::$layer;
} else {
throw new Exception('Error Layer Database connect');
}
} else {
throw new Exception('Class db_layer is not exist');
}
}
public function fetch($where = array())
{
$clause['where'] = '';
$values = array();
$buildedWhere = self::buildClauseWhere($where);
if ($buildedWhere) {
$clause['where'] = $buildedWhere['clause'];
$values = $buildedWhere['values'];
}
$query = 'SELECT attr_name,status FROM mc_config
WHERE attr_name = :attr_name';
$query .= $clause['where'];
return component_routing_db::layer()->fetch($query, $values);
}
public function fetch($idSetting)
{
$sql = 'SELECT setting_label,setting_value
FROM mc_setting WHERE setting_id = :idSetting';
return component_routing_db::layer()->fetch($sql, array(':idSetting' => $idSetting));
}
/**
* @access protected
* Collecte les pages de second niveaux (enfants)
* @param string $lang_iso
* @param string|int $sort_id
* @param string $sort_type
* @param int $limit
* @param int $level
*/
protected function s_page_child($lang_iso, $sort_id, $sort_type = null, $limit = null)
{
if (isset($sort_id)) {
$where_clause = 'AND p.idcat_p ';
$where_clause .= $sort_type != 'exclude' ? ' IN (' : ' NOT IN (';
$where_clause .= $sort_id;
$where_clause .= ') ';
} else {
$where_clause = 'AND p.idcat_p != 0 ';
}
$limit_clause = null;
if (is_int($limit)) {
$limit_clause = 'LIMIT ' . $limit;
}
// ### Querry
$select = "\r\n SELECT p.idpage,p.title_page,p.uri_page,p.content_page,lang.iso,p.idcat_p,page_p.uri_page_p\r\n \tFROM mc_cms_pages AS p\r\n JOIN (\r\n SELECT idpage AS idpage_p, uri_page AS uri_page_p\r\n FROM mc_cms_pages\r\n ) as page_p on (page_p.idpage_p = p.idcat_p)\r\n \tJOIN mc_lang AS lang ON(p.idlang = lang.idlang)\r\n \tWHERE lang.iso = :lang_iso AND p.sidebar_page = 1\r\n \t {$where_clause}\r\n \tORDER BY p.order_page\r\n \t {$limit_clause}";
return component_routing_db::layer()->fetchAll($select, array(':lang_iso' => $lang_iso));
}
