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()); } }