public function getViewForHelperAll()
{
$globaluser = Session::getActiveUserIsGlobal();
$Data = Session::getActiveViewIds();
if ($Data == NULL) {
if ($globaluser == 1) {
$sql = 'SELECT
V.idview AS id
FROM view V
GROUP BY V.idview
';
$stmt = Db::getInstance()->prepare($sql);
$stmt->execute();
while ($rs = $stmt->fetch()) {
$Data[] = $rs['id'];
}
} else {
$sql = 'SELECT
UGV.viewid
FROM usergroupview UGV
lEFT JOIN view V ON UGV.viewid = V.idview
lEFT JOIN store S ON V.storeid = S.idstore
WHERE UGV.userid = :userid
GROUP BY UGV.viewid';
$stmt = Db::getInstance()->prepare($sql);
$stmt->bindValue('userid', Session::getActiveUserid());
$stmt->execute();
while ($rs = $stmt->fetch()) {
$Data[] = $rs['viewid'];
}
}
Session::setActiveViewIds($Data);
}
return $Data;
}
public function getLayerIdByViewId($id)
{
$globaluser = Session::getActiveUserIsGlobal();
$Stores = Session::getActiveStoreData();
if ($globaluser == 1) {
return 0;
}
if ($id == 0) {
if (isset($Stores['global'])) {
return 0;
} else {
// throw new Exception('No privileges '.$id);
}
}
foreach ($Stores as $key => $store) {
if ($key != 'global') {
foreach ($store as $storeKey => $view) {
if ($id == $view) {
return $key;
}
}
}
}
// throw new Exception('No privileges '.$id);
}
