/**
* Retrieves the message corresponding to a give id.
*
* @param {integer/string} id The message code.
* @return {string} The message corresponding to the provided
* id if it exists, "Message: <id>" otherwise.
*/
public function getMessage($id)
{
parent::verifyTypes($id, array("integer", "string"));
$id = intval($id);
$table = DataAccessConfig::messageData();
$values = array($table->messageText);
$target = array($table->messageId => $id);
$result = $this->selectRows($table->tableName, $values, $target);
if (count($result) != 1) {
return "Message ID: " . $id;
}
return $result[0][$table->messageText];
}
public static function mapResult($result)
{
$config = DataAccessConfig::userData();
$userId = (int) $result[$config->id];
$email = $result[$config->email];
$pin = $result[$config->pin];
$name = $result[$config->name];
$birthday = new DateTime($result[$config->birthday]);
$user = new User($email, $pin);
$user->setUserId($userId);
$user->setPin($pin);
$user->setName($name);
$user->setBirthday($birthday);
return $user;
}
private function usernameExists($email)
{
parent::verifyType($email, "string");
$table = DataAccessConfig::userData();
$values = array($table->userId);
$target = array($table->email => "'" . $email . "'");
$result = $this->selectRows($table->tableName, $values, $target);
return count($result) == 1;
}
public static function joinTables($table1, $table2, $table3, $joinCondition1, $joinCondition2)
{
$join = DataAccessConfig::joinTable($table1, $table2, $joinCondition1);
return DataAccessConfig::joinTable($join, $table3, $joinCondition2);
}
