public function query($args = array())
{
$defaults = array('identifier' => 'sourced_id', 'levl_code' => 'UG', 'majr_code' => 'NONE', 'termcode' => \PSUStudent::getCurrentTerm('UG'));
$args = PSU::params($args, $defaults);
if (is_array($args['majr_code'])) {
$majr_where = "IN (";
foreach ($args['majr_code'] as $majr) {
$majr_where .= "'" . $majr . "',";
}
//end foreach
$majr_where = rtrim($majr_where, ',');
$majr_where .= ")";
} else {
$majr_where = "= '" . $args['majr_code'] . "'";
}
//end if/else
$sql = "\n\t\t\tSELECT DISTINCT " . $args['identifier'] . "\n\t\t\t FROM v_curriculum_learner\n\t\t\t JOIN psu_identity.person_identifiers\n\t\t\t\tON pidm = pid\n\t\t\t WHERE levl_code = :levl_code\n\t\t\t AND majr_code " . $majr_where . " \n\t\t\t AND lfst_code = 'MAJOR'\n\t\t\t AND catalog_term >= :termcode\n\t\t";
$matches = PSU::db('banner')->GetCol($sql, $args);
return $matches;
}
/**
* 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;
}
