/**
* Returns all award receipts for the given award
* @param Award $award
* @return InternalAwardReceipts
*/
private static function getByAward(Award $award)
{
global $db;
$query = "SELECT a.`id` as `award_receipt_id`, a.`user_id`, a.`year` \n\t\t\t\tFROM `" . DATABASE_NAME . "`.`student_awards_internal` a \n\t\t\t\tWHERE a.`award_id` = " . $db->qstr($award->getID()) . " \n\t\t\t\torder by a.year desc";
$results = $db->GetAll($query);
$receipts = array();
if ($results) {
foreach ($results as $result) {
$receipt = new InternalAwardReceipt($result['user_id'], $award, $result['award_receipt_id'], $result['year']);
$receipts[] = $receipt;
}
}
return new self($receipts);
}
