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);
}
}
