/**
* 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;
}
