public function checkLoggedUser()
{
if ($_SESSION['session']) {
$user = cDb::select(array('core_authentications', array('user', '=', 'core_users.id', 'LEFT'), 'core_users', array('role', '=', 'core_roles.id', 'LEFT'), 'core_roles'), array('core_users.*', 'session', 'core_roles.name as rolename'), array(array('session', '=', $_SESSION['session']), 'AND', array('ip', '=', $_SERVER['REMOTE_ADDR']), 'AND', array('core_users.active', '=', 1)), null, 1);
if (count($user)) {
return $user[0];
}
}
return false;
}
public function setUserAccount()
{
$result = cDb::select('useraccount', '*', array('user', '=', self::getUserData('id')));
cCfg::$aUserData['account'] = array();
if (is_array($result) && count($result)) {
//cCfg::$idActiveUseraccount = $result[0]['id'];
cCfg::$aUserData['account'] = $result[0];
}
$aDod = cDb::select('dodavatele', '*', array('useracc', '=', $result[0]['id']));
cCfg::$aUserData['dodavatele'] = array();
foreach ($aDod as $dod) {
cCfg::$aUserData['dodavatele'][$dod['id']] = $dod;
if (is_null(cCfg::$idActiveUseraccount)) {
cCfg::$idActiveUseraccount = $dod['id'];
}
}
cCfg::$logs->addLog(cCfg::$aUserData, 'aUserData');
}
/**
* get all data from DB about the page
* @param mixed $paramValue - can be number or string; value of column to be selected from DB
* @param string $paramName[optional][default 'name'] - name of column in table core_pages; the query is based on it;
* <p><strong>allowed: id, name</strong></p>
* @return array - if no record about this pageName, returns empty array otherwise return the first record
*/
public function getPageData($paramValue, $paramName = 'name')
{
$paramValue = get_magic_quotes_gpc() ? $paramValue : addslashes($paramValue);
if (in_array($paramName, array("id", "name"))) {
$aPageVal = array($paramName, '=', $paramValue);
} else {
return array();
}
$result = cDb::select('core_pages', '*', array($aPageVal));
if (is_array($result) && count($result)) {
return $result[0];
} else {
return array();
}
}
function admin_getAllCapabWithRights()
{
$aData = cDb::select(array('core_capabilities as c', array('c.id', '=', 'capability', 'LEFT'), 'core_role_capability as rc'), array('rc.id', 'rc.role as roleid', 'c.id as capid', 'c.name', 'description'));
if (is_array($aData)) {
return admin_parseCapabData($aData);
}
return array();
}
/**
* Funkce vrati data odberatele dle ID a v pripade zadani druheho parametru
* i v zavislosti na ID uzivatelskeho uctu. Pokud takoveho odberatele nenalezne, vrati prazdne pole.
* Pokud je $id null a je nastaven druhy parametr, vrati odberatele pro dany uz. ucet.
* Pokud jsou oba parametry NULL, vrati vsechny odberatele v db.
* @param int $id[optional][default null] - id odberatele
* @param int $userAccountId[optional][default null] - id uzivatelskeho uctu, pod kterym je odberatel ulozen
* @return array
*/
public function getOdberatel($id = null, $userAccountId = null)
{
if (is_null($userAccountId) && is_null($id)) {
return cDb::select('odberatele', '*');
} else {
if (is_null($userAccountId)) {
$where = array('id', '=', trim($id));
} else {
if (is_null($id)) {
$where = array('useracc', '=', trim($userAccountId));
} else {
$where = array(array('id', '=', trim($id)), 'AND', array('useracc', '=', trim($userAccountId)));
}
}
}
return cDb::select('odberatele', '*', $where);
}
