public static function CheckGroupPagesPermissions($groupID, $pageID, $permission)
{
if ($groupID == null) {
return false;
}
$groupPagePermission = new ExtranetGroupsPagesPermissions();
$select = $groupPagePermission->select()->setIntegrityCheck(false);
$select->from('Extranet_Groups_Pages_Permissions')->where('EGPP_GroupID = ?', $groupID)->where('EGPP_PageID = ?', $pageID);
if ($permission == "structure") {
$select->where('EGPP_Structure = "Y"');
} elseif ($permission == "data") {
$select->where('EGPP_Data = "Y"');
}
$row = $groupPagePermission->fetchRow($select);
if (count($row) == 0) {
return false;
} else {
return true;
}
}
function saveGroupPagesPermissions($groupID, $pagesArray, $checkboxArray, $permission)
{
//$pageAssociate = "";
foreach ($pagesArray as $page) {
if (count($page['child'] > 0)) {
//$pageAssociate .= $this->checkboxVerify($page['child'], $checkboxArray, $name);
$this->saveGroupPagesPermissions($groupID, $page['child'], $checkboxArray, $permission);
}
if (!empty($_POST["checkbox_" . $permission . "_" . $page['P_ID']])) {
$groupPagePermission = new ExtranetGroupsPagesPermissions();
$select = $groupPagePermission->select()->setIntegrityCheck(false);
$select->from('Extranet_Groups_Pages_Permissions')->where('EGPP_GroupID = ?', $groupID)->where('EGPP_PageID = ?', $page['P_ID']);
$row = $groupPagePermission->fetchRow($select);
if (count($row) == 0) {
$createPagePermission = new ExtranetGroupsPagesPermissions();
$GPP = $createPagePermission->createRow();
$GPP->EGPP_GroupID = $groupID;
$GPP->EGPP_PageID = $page['P_ID'];
if ($permission == "structure") {
$GPP->EGPP_Structure = 'Y';
} elseif ($permission == "data") {
$GPP->EGPP_Data = 'Y';
}
$GPP->save();
} else {
if ($permission == "structure") {
$row->EGPP_Structure = 'Y';
} elseif ($permission == "data") {
$row->EGPP_Data = 'Y';
}
$row->save();
}
}
}
//return $pageAssociate;
}
