/** * constructor init all data */ public function __construct($username) { $this->_auth = Vi_Auth::getInstance(); $dbPrefix = Vi_Registry::getDBPrefix(); $db = Vi_Registry::getDB(); $sqlSelectPermission = "\r\n\t\t\t\tSELECT p.name as pkey, r.enabled as penabled, r.expand_table_id, p.module as module_name FROM\r\n\t\t\t\t\t(SELECT * FROM {$dbPrefix}user WHERE username = {$db->quote($username)}) u,\r\n\t\t\t\t\t{$dbPrefix}group_permission r,\r\n\t\t\t\t\t{$dbPrefix}permission p\r\n\t\t\t\tWHERE r.permission_id = p.permission_id AND u.group_id = r.group_id;"; $db = Vi_Registry::getDB(); $permissions = $db->fetchAll($sqlSelectPermission); $results = array(); foreach ($permissions as $per) { if (null == $per['expand_table_id']) { $results[$per['module_name']][$per['pkey']] = $per['penabled'] == '1' ? true : false; } else { $results[$per['module_name']][$per['pkey']][$per['expand_table_id']] = $per['penabled'] == '1' ? true : false; } } $this->_permissions = $results; }
private function getStickers($holderName, $pageName = "") { $result = array(); $prefix = Vi_Registry::getDBPrefix(); $stmt = $this->_db->query("SELECT s.* FROM {$prefix}sticker s, {$prefix}holder h\r\n\t\t\tWHERE s.holder_id = h.holder_id AND h.name = ? AND s.enabled = ? order by priority asc", array($holderName, '1')); $rows = $stmt->fetchAll(); foreach ($rows as $r) { $r['params'] = json_decode($r['params']); $result[] = $r; } return $result; }