public static function sendNoticeOfUpdatedUser($user)
{
$obj = new ObjectBase();
$obj->verifyType($user, "User");
$to = $user->getEmail();
$from = self::$ADMIN;
$subject = "Account Updated";
$message = "\n\nYou have successfully updated your account information. If you have any questions\nregarding this change, or experience difficulties using your account, send a message\nto our IT peeps and they'll get your everything sorted out.\n\nIT: " . self::$ADMIN . "\n";
return self::sendEmail($from, $to, null, $subject, $message);
}
/**
* Selects any number of rows from a database table.
*
* @param {string} table The table to target.
* @param {key=>value} values Key-value pairs identifying which
* database fields you want returned.
* @param {key=>value} target Key-value pairs identifying the
* columns and values you are targeting.
* @param {array(string,int)} orderby=NULL This is an array of
* size 2.
* index 0: The column to order by
* index 1: DatabaseUser::ORDER_BY_ASC or
* DatabaseUser::ORDER_BY_DESC
* @param {resource} dbhandle=false Optional database
* connection handle.
* @return {array{key=>value}} Each entry of the returned array
* contains a single row indexed by column name. For
* example, if you expect your query to return a single
* row [$result = selectRows(...)], and you want to
* access the value for 'firstName', use the following
* syntax:
* $result[0]["firstName"]
*/
public function selectRows($table, $values, $target, $orderby = NULL, $mapper = NULL, $dbhandle = false)
{
$target_size = count($target);
$values_size = count($values);
if ($values_size == 0) {
return false;
}
$values = self::encodeValues($values);
$target = self::encodeValues($target);
$query = "SELECT ";
foreach ($values as $key => $value) {
$values[$key] = $value . " AS '" . $value . "'";
}
$query .= implode(', ', $values);
$query .= " FROM {$table}";
if ($target_size > 0) {
$query .= " WHERE ";
$key_values = array();
foreach ($target as $key => $value) {
$key_values[] = $key . "=" . $value;
}
$query .= implode(" AND ", $key_values);
}
if (!is_null($orderby) && is_array($orderby) && count($orderby) == 2) {
$query .= " ORDER BY " . $orderby[0];
if ($orderby[1] == self::ORDER_BY_ASC) {
$query .= " ASC";
}
if ($orderby[1] == self::ORDER_BY_DESC) {
$query .= " DESC";
}
}
Logger::debug(get_class(), __FUNCTION__, $query);
if (is_null($mapper)) {
return self::sendQuery($query, $dbhandle);
} else {
parent::verifyType($mapper, "Mapper");
$results = self::sendQuery($query, $dbhandle);
$mappedObjs = array();
foreach ($results as $result) {
$mappedObjs[] = $mapper->mapResult($result);
}
return $mappedObjs;
}
}
public static function compareTo($thisRange, $thatRange)
{
$objBase = new ObjectBase();
$objBase->verifyType($thisRange, "Range");
$objBase->verifyType($thatRange, "Range");
if ($thisRange->lessThan($thatRange)) {
return -1;
} else {
if ($thisRange->greaterThan($thatRange)) {
return 1;
} else {
return 0;
}
}
}
public static function compareTo($thisUser, $thatUser)
{
$objBase = new ObjectBase();
$objBase->verifyType($thisUser, "User");
$objBase->verifyType($thatUser, "User");
return strcmp($thisUser->getEmail(), $thatUser->getEmail());
}
