/** * Function getRolesBySystem * access public */ function getRolesBySystem($SysUid, $UsrUid) { $con = Propel::getConnection(UsersRolesPeer::DATABASE_NAME); try { $c = new Criteria('rbac'); $c->clearSelectColumns(); $c->addSelectColumn(RolesPeer::ROL_UID); $c->addSelectColumn(RolesPeer::ROL_CODE); $c->addJoin(UsersRolesPeer::ROL_UID, RolesPeer::ROL_UID); $c->add(UsersRolesPeer::USR_UID, $UsrUid); $c->add(RolesPeer::ROL_SYSTEM, $SysUid); $rs = UsersRolesPeer::doSelectRs($c); $rs->setFetchmode(ResultSet::FETCHMODE_ASSOC); $rs->next(); $row = $rs->getRow(); /* return only the first row, no other rows can be permitted while ( is_array ( $row ) ) { $rows[] = $row; $rs->next(); $row = $rs->getRow(); } */ return $row; } catch (Exception $oError) { throw $oError; } }
/** * 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 = UsersRolesPeer::getFieldNames($keyType); if (array_key_exists($keys[0], $arr)) { $this->setUsrUid($arr[$keys[0]]); } if (array_key_exists($keys[1], $arr)) { $this->setRolUid($arr[$keys[1]]); } }
/** * remove a role from an user * * @access public * @param array $sUserUID * @return void */ public function removeRolesFromUser($sUserUID = '') { $oCriteria = new Criteria('rbac'); $oCriteria->add(UsersRolesPeer::USR_UID, $sUserUID); UsersRolesPeer::doDelete($oCriteria); }
function deleteUserRole($ROL_UID, $USR_UID) { $crit = new Criteria(); $crit->add(UsersRolesPeer::USR_UID, $USR_UID); if ($ROL_UID != '%') { $crit->add(UsersRolesPeer::ROL_UID, $ROL_UID); } UsersRolesPeer::doDelete($crit); $rol = $this->load($ROL_UID); $oUsersRbac = new RbacUsers(); $user = $oUsersRbac->load($USR_UID); G::auditLog("DeleteUserToRole", "Delete user " . $user['USR_USERNAME'] . " (" . $USR_UID . ") to Role " . $rol['ROL_NAME'] . " (" . $ROL_UID . ") "); }
/** * Retrieve object using using composite pkey values. * @param string $usr_uid @param string $rol_uid * @param Connection $con * @return UsersRoles */ public static function retrieveByPK($usr_uid, $rol_uid, $con = null) { if ($con === null) { $con = Propel::getConnection(self::DATABASE_NAME); } $criteria = new Criteria(); $criteria->add(UsersRolesPeer::USR_UID, $usr_uid); $criteria->add(UsersRolesPeer::ROL_UID, $rol_uid); $v = UsersRolesPeer::doSelect($criteria, $con); return !empty($v) ? $v[0] : null; }
function deleteUserRole($ROL_UID, $USR_UID) { $crit = new Criteria(); $crit->add(UsersRolesPeer::USR_UID, $USR_UID); if ($ROL_UID != '%') { $crit->add(UsersRolesPeer::ROL_UID, $ROL_UID); } UsersRolesPeer::doDelete($crit); }
public function getUserRole($UsrUid) { $con = Propel::getConnection(UsersRolesPeer::DATABASE_NAME); try { $c = new Criteria('rbac'); $c->clearSelectColumns(); $c->addSelectColumn(RolesPeer::ROL_UID); $c->addSelectColumn(RolesPeer::ROL_CODE); $c->addSelectColumn(RolesPeer::ROL_STATUS); $c->addJoin(UsersRolesPeer::ROL_UID, RolesPeer::ROL_UID); $c->add(UsersRolesPeer::USR_UID, $UsrUid); $rs = UsersRolesPeer::doSelectRs($c); $rs->setFetchmode(ResultSet::FETCHMODE_ASSOC); $rs->next(); $row = $rs->getRow(); return $row; } catch (Exception $oError) { throw $oError; } }
/** * Verify if not it's assigned the User to Role * * @param string $roleUid Unique id of Role * @param string $userUid Unique id of User * @param string $fieldNameForException Field name for the exception * * return void Throw exception if not it's assigned the User to Role */ public function throwExceptionIfNotItsAssignedUserToRole($roleUid, $userUid, $fieldNameForException) { try { $obj = \UsersRolesPeer::retrieveByPK($userUid, $roleUid); if (is_null($obj)) { throw new \Exception(\G::LoadTranslation("ID_ROLE_USER_IS_NOT_ASSIGNED", array($fieldNameForException, $userUid))); } } catch (\Exception $e) { throw $e; } }