/** * 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; } }
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; } }