public function loadDetailed($UsrUid) { try { $result = array(); $oUser = UsersPeer::retrieveByPK($UsrUid); if (!is_null($oUser)) { $aFields = $oUser->toArray(BasePeer::TYPE_FIELDNAME); $this->fromArray($aFields, BasePeer::TYPE_FIELDNAME); $this->setNew(false); $aIsoCountry = IsoCountry::findById($aFields['USR_COUNTRY']); $aIsoSubdivision = IsoSubdivision::findById($aFields['USR_COUNTRY'], $aFields['USR_CITY']); $aIsoLocation = IsoLocation::findById($aFields['USR_COUNTRY'], $aFields['USR_CITY'], $aFields['USR_LOCATION']); $aFields["USR_COUNTRY_NAME"] = !empty($aIsoCountry["IC_NAME"]) ? $aIsoCountry["IC_NAME"] : ""; $aFields["USR_CITY_NAME"] = !empty($aIsoSubdivision["IS_NAME"]) ? $aIsoSubdivision["IS_NAME"] : ""; $aFields["USR_LOCATION_NAME"] = !empty($aIsoLocation["IL_NAME"]) ? $aIsoLocation["IL_NAME"] : ""; $result = $aFields; return $result; } else { //return $result; throw new Exception("The row '" . $UsrUid . "' in table USER doesn't exist!"); } } catch (Exception $oError) { throw $oError; } }
public function loadDetailed ($UsrUid) { try { $result = array (); $oUser = UsersPeer::retrieveByPK( $UsrUid ); if (! is_null( $oUser )) { $aFields = $oUser->toArray( BasePeer::TYPE_FIELDNAME ); $this->fromArray( $aFields, BasePeer::TYPE_FIELDNAME ); $this->setNew( false ); $aIsoCountry = IsoCountry::findById( $aFields['USR_COUNTRY'] ); $aIsoSubdivision = IsoSubdivision::findById( $aFields['USR_COUNTRY'], $aFields['USR_CITY'] ); $aIsoLocation = IsoLocation::findById( $aFields['USR_COUNTRY'], $aFields['USR_CITY'], $aFields['USR_LOCATION'] ); $aFields["USR_COUNTRY_NAME"] = (!empty($aIsoCountry["IC_NAME"]))? $aIsoCountry["IC_NAME"] : ""; $aFields["USR_CITY_NAME"] = (!empty($aIsoSubdivision["IS_NAME"]))? $aIsoSubdivision["IS_NAME"] : ""; $aFields["USR_LOCATION_NAME"] = (!empty($aIsoLocation["IL_NAME"]))? $aIsoLocation["IL_NAME"] : ""; require_once PATH_RBAC . "model/Roles.php"; $roles = new Roles(); $role = $roles->loadByCode($aFields['USR_ROLE']); $aFields['USR_ROLE_NAME'] = $role['ROL_NAME']; $result = $aFields; return $result; } else { //return $result; throw (new Exception(G::LoadTranslation("ID_USER_UID_DOESNT_EXIST", SYS_LANG, array("USR_UID" => $UsrUid)))); } } catch (Exception $oError) { throw ($oError); } }