function getAllPermissions($sRolUid, $sUsrUid) { $con = Propel::getConnection(RolesPermissionsPeer::DATABASE_NAME); try { $c = new Criteria('rbac'); // $c->clearSelectColumns(); $c->addSelectColumn(RolesPermissionsPeer::PER_UID); $c->addSelectColumn(PermissionsPeer::PER_CODE); $c->addJoin(RolesPermissionsPeer::PER_UID, PermissionsPeer::PER_UID); $c->add(RolesPermissionsPeer::ROL_UID, $sRolUid); $rs = RolesPermissionsPeer::doSelectRs($c); $rs->setFetchmode(ResultSet::FETCHMODE_ASSOC); $rs->next(); $row = $rs->getRow(); $rows = array(); while (is_array($row)) { $rows[] = $row; $rs->next(); $row = $rs->getRow(); } return $rows; } catch (Exception $oError) { throw $oError; } }
function create($aData) { try { $oCriteria = new Criteria('rbac'); $oCriteria->add(RolesPermissionsPeer::ROL_UID, $aData['ROL_UID']); $oCriteria->add(RolesPermissionsPeer::PER_UID, $aData['PER_UID']); $oDataset = RolesPermissionsPeer::doSelectRS($oCriteria); $oDataset->setFetchmode(ResultSet::FETCHMODE_ASSOC); $oDataset->next(); $aRow = $oDataset->getRow(); if (is_array($aRow)) { return true; } $oRolesPermissions = new RolesPermissions(); $oRolesPermissions->fromArray($aData, BasePeer::TYPE_FIELDNAME); $iResult = $oRolesPermissions->save(); return true; } catch (Exception $oError) { throw $oError; } }
function deletePermissionRole($ROL_UID, $PER_UID) { $crit = new Criteria(); $crit->add(RolesPermissionsPeer::ROL_UID, $ROL_UID); $crit->add(RolesPermissionsPeer::PER_UID, $PER_UID); RolesPermissionsPeer::doDelete($crit); $o = new RolesPermissions(); $o->setPerUid($PER_UID); $permission = $o->getPermissionName($PER_UID); $role = $this->load($ROL_UID); G::auditLog("DeletePermissionToRole", "Delete Permission " . $permission . " (" . $PER_UID . ") from Role " . $role['ROL_NAME'] . " (" . $ROL_UID . ") "); }
/** * Retrieve object using using composite pkey values. * @param string $rol_uid @param string $per_uid * @param Connection $con * @return RolesPermissions */ public static function retrieveByPK($rol_uid, $per_uid, $con = null) { if ($con === null) { $con = Propel::getConnection(self::DATABASE_NAME); } $criteria = new Criteria(); $criteria->add(RolesPermissionsPeer::ROL_UID, $rol_uid); $criteria->add(RolesPermissionsPeer::PER_UID, $per_uid); $v = RolesPermissionsPeer::doSelect($criteria, $con); return !empty($v) ? $v[0] : null; }
function deletePermissionRole($ROL_UID, $PER_UID) { $crit = new Criteria(); $crit->add(RolesPermissionsPeer::ROL_UID, $ROL_UID); $crit->add(RolesPermissionsPeer::PER_UID, $PER_UID); RolesPermissionsPeer::doDelete($crit); }
/** * Verify if not it's assigned the Permission to Role * * @param string $roleUid Unique id of Role * @param string $permissionUid Unique id of Permission * @param string $fieldNameForException Field name for the exception * * return void Throw exception if not it's assigned the Permission to Role */ public function throwExceptionIfNotItsAssignedPermissionToRole($roleUid, $permissionUid, $fieldNameForException) { try { $obj = \RolesPermissionsPeer::retrieveByPK($roleUid, $permissionUid); if (is_null($obj)) { throw new \Exception(\G::LoadTranslation("ID_ROLE_PERMISSION_IS_NOT_ASSIGNED", array($fieldNameForException, $permissionUid))); } } catch (\Exception $e) { throw $e; } }
/** * Populates the object using an array. * * This is particularly useful when populating an object from one of the * request arrays (e.g. $_POST). This method goes through the column * names, checking to see whether a matching key exists in populated * array. If so the setByName() method is called for that column. * * You can specify the key type of the array by additionally passing one * of the class type constants TYPE_PHPNAME, TYPE_COLNAME, TYPE_FIELDNAME, * TYPE_NUM. The default key type is the column's phpname (e.g. 'authorId') * * @param array $arr An array to populate the object from. * @param string $keyType The type of keys the array uses. * @return void */ public function fromArray($arr, $keyType = BasePeer::TYPE_PHPNAME) { $keys = RolesPermissionsPeer::getFieldNames($keyType); if (array_key_exists($keys[0], $arr)) { $this->setRolUid($arr[$keys[0]]); } if (array_key_exists($keys[1], $arr)) { $this->setPerUid($arr[$keys[1]]); } }