/** * add the where condition for listing the record * @param type $dgModule * @return string */ function loadPermittedRecordWhere(ClsAuieoSQL &$objSQL, $data_item_type) { $access_level = Users::getInstance()->getUserInfo("access_level"); if ($access_level == 500) { return; } $from = $objSQL->getDefaultFrom(); if (getSharingAccess($data_item_type) <= 0) { $obj = Users::getInstance(); $objSQL->setWhereGroupStart(); $objSQL->setWhereGroupStart(); //$arrTmpWhere[]="({$dgTable}.owner = ".$_SESSION["CATS"]->getUserID()." and {$dgTable}.ownertype=0)"; $objSQL->addWhere($from, "owner", $_SESSION["CATS"]->getUserID()); $whr1 = $objSQL->addWhere($from, "ownertype", 0); $whr1->setBoolean("OR"); $objSQL->setWhereGroupEnd(); $objSQL->setWhereGroupStart(); $arrUserAllowed = $obj->getChildRolesUsers(); if ($arrUserAllowed) { foreach ($arrUserAllowed as $userAllowed) { $objSQL->setWhereGroupStart(); $objSQL->addWhere($from, "owner", $userAllowed); $whr2 = $objSQL->addWhere($from, "ownertype", 0); $whr2->setBoolean("OR"); $objSQL->setWhereGroupEnd(); } } $arrGroup = $obj->getAllGroups(); if ($arrGroup) { foreach ($arrGroup as $group) { $objSQL->setWhereGroupStart(); $objSQL->addWhere($from, "owner", $group); $whr3 = $objSQL->addWhere($from, "ownertype", 1); $whr3->setBoolean("OR"); $objSQL->setWhereGroupend(); } } $objSQL->setWhereGroupEnd(); } }