public function getAllRowsLike($word)
{
try {
$c = new Criteria('workflow');
$c->addSelectColumn(IsoLocationPeer::IC_UID);
$c->addSelectColumn(IsoLocationPeer::IL_NORMAL_NAME);
$c->add(IsoLocationPeer::IL_NORMAL_NAME, $word . "%", Criteria::LIKE);
$rs = IsoLocationPeer::doSelectRS($c);
//$rs->setFetchmode(ResultSet::FETCHMODE_ASSOC);
$rows = array();
while ($rs->next()) {
array_push($rows, $rs->getRow());
}
return $rows;
} catch (Exception $oException) {
throw $oException;
}
}
/**
* Method to do selects.
*
* @param Criteria $criteria The Criteria object used to build the SELECT statement.
* @param Connection $con
* @return array Array of selected Objects
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function doSelect(Criteria $criteria, $con = null)
{
return IsoLocationPeer::populateObjects(IsoLocationPeer::doSelectRS($criteria, $con));
}
public function getAllInformation($userUid)
{
if (!isset($userUid) || $userUid == "") {
throw new Exception("{$userUid} is empty.");
}
try {
require_once "classes/model/IsoCountry.php";
require_once "classes/model/IsoLocation.php";
require_once "classes/model/IsoSubdivision.php";
require_once "classes/model/Language.php";
G::LoadClass("calendar");
$aFields = $this->load($userUid);
$c = new Criteria("workflow");
$c->add(IsoCountryPeer::IC_UID, $aFields["USR_COUNTRY"]);
$rs = IsoCountryPeer::doSelectRS($c);
$rs->setFetchmode(ResultSet::FETCHMODE_ASSOC);
$rs->next();
$rowC = $rs->getRow();
$c->clearSelectColumns();
$c->add(IsoSubdivisionPeer::IC_UID, $aFields["USR_COUNTRY"]);
$c->add(IsoSubdivisionPeer::IS_UID, $aFields["USR_CITY"]);
$rs = IsoSubdivisionPeer::doSelectRS($c);
$rs->setFetchmode(ResultSet::FETCHMODE_ASSOC);
$rs->next();
$rowS = $rs->getRow();
$c->clearSelectColumns();
$c->add(IsoLocationPeer::IC_UID, $aFields["USR_COUNTRY"]);
$c->add(IsoLocationPeer::IL_UID, $aFields["USR_LOCATION"]);
$rs = IsoLocationPeer::doSelectRS($c);
$rs->setFetchmode(ResultSet::FETCHMODE_ASSOC);
$rs->next();
$rowL = $rs->getRow();
//Calendar
$calendar = new Calendar();
$calendarInfo = $calendar->getCalendarFor($userUid, $userUid, $userUid);
$aFields["USR_CALENDAR"] = $calendarInfo["CALENDAR_APPLIED"] != "DEFAULT" ? $calendarInfo["CALENDAR_UID"] : "";
//Photo
$pathPhoto = PATH_IMAGES_ENVIRONMENT_USERS . $userUid . ".gif";
if (!file_exists($pathPhoto)) {
$pathPhoto = PATH_HOME . "public_html" . PATH_SEP . "images" . PATH_SEP . "user.gif";
}
//Data
$arrayData = array();
$arrayData["username"] = $aFields["USR_USERNAME"];
$arrayData["firstname"] = $aFields["USR_FIRSTNAME"];
$arrayData["lastname"] = $aFields["USR_LASTNAME"];
$arrayData["mail"] = $aFields["USR_EMAIL"];
$arrayData["address"] = $aFields["USR_ADDRESS"];
$arrayData["zipcode"] = $aFields["USR_ZIP_CODE"];
$arrayData["country"] = $rowC["IC_NAME"];
$arrayData["state"] = $rowS["IS_NAME"];
$arrayData["location"] = $rowL["IL_NAME"];
$arrayData["phone"] = $aFields["USR_PHONE"];
$arrayData["fax"] = $aFields["USR_FAX"];
$arrayData["cellular"] = $aFields["USR_CELLULAR"];
$arrayData["birthday"] = $aFields["USR_BIRTHDAY"];
$arrayData["position"] = $aFields["USR_POSITION"];
$arrayData["replacedby"] = $aFields["USR_REPLACED_BY"];
$arrayData["duedate"] = $aFields["USR_DUE_DATE"];
$arrayData["calendar"] = $aFields["USR_CALENDAR"];
$arrayData["status"] = $aFields["USR_STATUS"];
$arrayData["department"] = $aFields["DEP_UID"];
$arrayData["reportsto"] = $aFields["USR_REPORTS_TO"];
$arrayData["userexperience"] = $aFields["USR_UX"];
$arrayData["photo"] = $pathPhoto;
return $arrayData;
} catch (Exception $e) {
throw $e;
}
}
