private static function getByUser(User $user)
{
global $db;
$query = "SELECT a.id as `award_receipt_id`, a.* \n\t\t\t\tFROM `" . DATABASE_NAME . "`.`student_awards_external` a \n\t\t\t\tWHERE a.`user_id` = " . $db->qstr($user->getID()) . " \n\t\t\t\torder by a.year desc";
$results = $db->GetAll($query);
$receipts = array();
if ($results) {
foreach ($results as $result) {
$award = ExternalAward::fromArray($result);
$result['award'] = $award;
$receipt = ExternalAwardReceipt::fromArray($result);
$receipts[] = $receipt;
}
}
return new self($receipts);
}
/**
*
* @param int $award_receipt_id
* @return ExternalAwardRecipient
*/
public static function get($award_receipt_id)
{
global $db;
$query = "SELECT a.id as `award_receipt_id`, user_id, a.title, a.award_terms, a.awarding_body, a.status, a.year \n\t\t\t\tFROM `" . DATABASE_NAME . "`.`student_awards_external` a \n\t\t\t\tWHERE a.id = " . $db->qstr($award_receipt_id);
$result = $db->GetRow($query);
if ($result) {
$award = ExternalAward::fromArray($result);
$result['award'] = $award;
return ExternalAwardReceipt::fromArray($result);
} else {
add_error("Failed to retreive award receipt from database.");
application_log("error", "Unable to retrieve a student_awards_external record. Database said: " . $db->ErrorMsg());
}
}
