protected function __construct() { self::$_db = dbMysql::getInstance(); if (!self::$_db) { return NULL; } }
public static function getMenuWithOneActive($params) { //title, type, active, href, id, imgSrc self::$_db = dbMysql::getInstance(); if (self::$_db) { if (self::_exists("gallerySections", "href", $params["params"]["name"])) { $sql = "select request as \"href\", html_id as \"id\", imgSrc,"; $sql .= " ( select term from dic_data where up = " . self::DIC_MENU_ITEM_TYPE . " and code = type ) as \"type\","; $sql .= " case when href = '" . $params["params"]["name"] . "' then 'true' else 'false' end as \"active\""; $sql .= " from gallerySections order by type, ord"; $res = self::$_db->fireSQL($sql); $vars = Request::getAllVar(); for ($i = 0; $i < count($res); $i++) { //$vars[ "params" ][ "name" ] = $res[ $i ][ "href" ]; //$vars[ "show" ] = "gallery"; $res[$i]["href"] = $_SERVER["PHP_SELF"] . "?" . $res[$i]["href"]; //Registry::get( "requestTemplate" )->getRequestString( $vars ); } //print_r( $res ); die; return $res; } } return NULL; }
private function __construct() { self::$_db = dbMysql::getInstance(); }