public function get_messages()
{
$web_rules = PSU_Student_Finaid::web_rules($this->aid_year);
$args = array('pidm' => $this->pidm, 'aidy' => $this->aid_year, 'fund_zero_amt' => $web_rules['fund_zero_amount']);
$sql = "\n SELECT rfrmesg_fund_code,\n rtvmesg_mesg_desc,\n rfrbase_fund_title,\n rfrbase_fund_title_long,\n rprawrd_activity_date\n FROM rfrmesg,\n rtvmesg,\n rfrbase,\n rprawrd,\n rtvawst\n WHERE rfrbase_info_access_ind = 'Y'\n AND rprawrd_fund_code = rfrbase_fund_code\n AND rprawrd_awst_code = rtvawst_code\n AND rtvmesg_info_access_ind = 'Y'\n AND rfrmesg_mesg_code = rtvmesg_code\n AND rprawrd_fund_code = rfrmesg_fund_code\n AND rprawrd_aidy_code = rfrmesg_aidy_code\n AND rprawrd_aidy_code = :aidy\n AND rprawrd_pidm = :pidm\n AND NVL(rprawrd_info_access_ind, 'Y') = 'Y'\n AND ( (:fund_zero_amt = 'N' AND rprawrd_offer_amt > 0) OR :fund_zero_amt = 'Y')\n AND rtvawst_info_access_ind = 'Y'\n AND NVL (rprawrd_offer_amt, 0) > 0\n ORDER BY rprawrd_fund_code ASC\n\t\t";
$rset = PSU::db('banner')->Execute($sql, $args);
return $rset;
}
public static function aid_years()
{
if (!self::$aid_years) {
$aid_years = new PSU_Student_Finaid_AidYears($aid_year);
$aid_years->load();
self::$aid_years = $aid_years;
}
//end if
return self::$aid_years;
}
/**
* initialize default, selected, and available aid years
*
* @param $selected_aid_year int The selected aid year
*/
private function _init_aid_years($selected_aid_year)
{
if (!isset($selected_aid_year) || !$selected_aid_year) {
if ($this->target->student->finaid) {
$selected_aid_year = $this->target->student->finaid->max_aid_year;
}
if (!$selected_aid_year) {
$selected_aid_year = PSUStudent::getAidYear(PSUStudent::getCurrentTerm('UG'));
}
}
$this->aid_years = PSU_Student_Finaid::aid_years();
$this->aid_year = $this->aid_years[$selected_aid_year];
$this->target->student->finaid->aid_year = $this->aid_year->aidy_code;
$this->tpl->assign('aid_years', $this->aid_years);
$this->tpl->assign('aid_year', $this->aid_year);
$this->tpl->assign('student_aid_year', $this->target->student->aidyears[$this->aid_year->aidy_code]);
return $selected_aid_year;
}