/**
* retrieve receivables for a person
*/
public function get()
{
$args = array('pidm' => $this->pidm);
$sql = "SELECT * FROM tbraccd WHERE tbraccd_pidm = :pidm";
$rset = \PSU::db('banner')->Execute($sql, $args);
return $rset ? $rset : array();
}
/**
* retrieve phones for a person
*/
public function get()
{
$args = array('wp_id' => $this->wp_id);
$sql = "\n\t\t\tSELECT * \n\t\t\t FROM person_phone\n\t\t\t WHERE wp_id = ?\n\t\t\t ORDER BY id DESC\n\t\t";
$rset = \PSU::db('emergency_notification')->Execute($sql, $args);
return $rset ? $rset : array();
}
public function get()
{
$sql = "\n\t\t\tSELECT *\n\t\t\t FROM (\n\t\t\t\t\t\t\tSELECT f.*,\n\t\t\t\t\t\t\t\t\t\t Dense_Rank() OVER (PARTITION BY file_type ORDER BY id DESC) rank\t\n\t\t\t\t\t\t\t\tFROM payment_plan_feed f\n\t\t\t\t\t\t\t ORDER BY id DESC\n\t\t\t\t\t\t )\n\t\t\t WHERE file_type = :file_type\n\t\t\t AND rank <= :num\n\t\t";
$args = array('num' => $this->num, 'file_type' => $this->type);
$results = \PSU::db('banner')->GetAll($sql, $args);
return $results;
}
/**
* prepares arguments for DML
*/
protected function _prep_args()
{
// this is the data prepared for binding.
// these fields are ordered as they are in the table
$args = array('the_id' => $this->id, 'psu_id' => $this->psu_id, 'name' => $this->name, 'report_group' => $this->report_group, 'contract_balance' => $this->contract_balance, 'account_status' => $this->account_status, 'record_type' => $this->record_type, 'plan_type' => $this->plan_type, 'fund_not_disbursed' => $this->fund_not_disbursed, 'tms_customer_number' => $this->tms_customer_number, 'file_id' => $this->file_id, 'date_parsed' => $this->date_parsed ? \PSU::db('banner')->BindDate($this->date_parsed_timestamp()) : null, 'date_processed' => $this->date_processed ? \PSU::db('banner')->BindDate($this->date_processed_timestamp()) : null, 'summer_contract_balance' => $this->summer_contract_balance, 'fall_contract_balance' => $this->fall_contract_balance, 'winter_contract_balance' => $this->winter_contract_balance, 'spring_contract_balance' => $this->spring_contract_balance);
return $args;
}
/**
* Return the highest aid year for a person.
*/
public function max_aid_year($pidm)
{
$sql = "\n\t\t\tSELECT rcrapp1_aidy_code\n\t\t\tFROM rcrapp1\n\t\t\tWHERE rcrapp1_pidm = :pidm\n\t\t\tORDER BY rcrapp1_aidy_code DESC\n\t\t";
$args = array('pidm' => $pidm);
$aid_year = PSU::db('banner')->GetOne($sql, $args);
return $aid_year ?: null;
}
/**
* retrieve contracts
*/
public function get()
{
$args = array();
if ($this->psu_id) {
$args['psu_id'] = $this->psu_id;
$where .= " AND c.psu_id = :psu_id";
}
//end if
if ($this->processed) {
$where .= " AND c.date_processed IS NOT NULL";
} elseif (!$this->include_processed) {
$where .= " AND c.date_processed IS NULL";
}
//end if
if ($this->num_rows) {
$where .= " AND rownum <= :num_rows";
$args['num_rows'] = $this->num_rows;
}
//end if
if ($this->file_id) {
$where .= " AND c.file_id = :file_id";
$args['file_id'] = $this->file_id;
}
//end if
$sql = "\n\t\t\tSELECT c.*, \n\t\t\t b.pidm,\n\t\t f.file_name,\n\t\t f.file_type,\n\t\t\t\t\t\t f.file_sub_type,\n\t\t\t\t\t\t f.file_date\n\t\t\t\tFROM payment_plan_contract c\n\t\t\t\t\t\t JOIN payment_plan_feed f\n\t\t\t ON f.id = c.file_id\n\t\t LEFT JOIN v_bio b\n\t\t\t ON b.id = psu_id\n\t\t\t\t\t\t\tAND REGEXP_LIKE( b.id, '[0-9]{9}' )\n\t\t\t WHERE 1 = 1 {$where} \n\t\t\t ORDER BY UPPER(b.last_name), UPPER(b.first_name), b.middle_name, file_id, c.id";
$results = \PSU::db('banner')->Execute($sql, $args);
return $results ? $results : array();
}
public function get()
{
$sql = "\n\t\t\tSELECT \n\t\t\t\td.date_processed,\n\t\t\t\tt.*\n\t\t\tFROM\n\t\t\t\tpayment_plan_disbursement d\n\t\t\t\tJOIN v_bio b\n\t\t\t\t ON b.id = d.psu_id\n\t\t\t\tJOIN tbraccd t\n\t\t\t\t ON t.tbraccd_pidm = b.pidm\n\t\t\t\t AND t.tbraccd_document_number = :document_number\n\t\t\tWHERE\n\t\t\t\td.file_id = :file_id\n\t\t";
$args = array('document_number' => \PSU\AR\PaymentPlan::document_number($this->file_id), 'file_id' => $this->file_id);
$results = \PSU::db('banner')->Execute($sql, $args);
return $results;
}
public function get_rules()
{
$args = array('aidy' => $this->aid_year);
$sql = "\n\t\t\tSELECT rorwebr_coa_ind,\n\t\t\t\t\t\t rorwebr_need_calc_ind,\n\t\t\t\t\t\t rorwebr_cum_loan_ind,\n\t\t\t\t\t\t rorwebr_detail_resource_ind,\n\t\t\t\t\t\t rorwebr_acpt_partial_amt_ind,\n\t\t\t\t\t\t rorwebr_acpt_all_awards_ind,\n\t\t\t\t\t\t rorwebr_resource_info_ind,\n\t\t\t\t\t\t rorwebr_award_info_ind,\n\t\t\t\t\t\t rorwebr_enrollment_status,\n\t\t\t\t\t\t rorwebr_housing_status_ind,\n\t\t\t\t\t\t rorwebr_term_zero_awrd_ind,\n\t\t\t\t\t\t rorwebr_fund_zero_amt_ind,\n\t\t\t\t\t\t rorwebr_resource_tab_ind,\n\t\t\t\t\t\t rorwebr_terms_tab_ind,\n\t\t\t\t\t\t rorwebr_award_acpt_tab_ind,\n\t\t\t\t\t\t rorwebr_special_msg_tab_ind,\n\t\t\t\t\t\t rorwebr_terms_cond_print_ind\n\t\t\t\tFROM rorwebr\n\t\t\t WHERE rorwebr_aidy_code = :aidy\n\t\t";
$data = PSU::db('banner')->GetRow($sql, $args);
return $data;
}
public function process()
{
$success = false;
if ($this->psu_status == 'eod') {
PSU::db('banner')->StartTrans();
$person = PSUPerson::get($this->ordernumber);
if ($person->pidm) {
if ($this->status_flag == 'success') {
$appl_no = PSU::db('banner')->GetOne("SELECT appl_no FROM psu.v_ug_app WHERE pidm = " . $person->pidm);
if ($appl_no) {
$sql = "UPDATE sarchkl SET sarchkl_receive_date = sysdate WHERE sarchkl_pidm = " . $person->pidm . " AND sarchkl_appl_no = " . $appl_no . " AND sarchkl_admr_code = 'APFE'";
PSU::db('banner')->Execute($sql);
}
//end if
}
//end if
$this->psu_status = 'loaded';
$this->save();
return PSU::db('banner')->CompleteTrans() ? $this->totalamount / 100 : false;
}
//end if
}
//end if
PSU::db('banner')->CompleteTrans(false);
return false;
}
public function unenrollXML()
{
$date_str = date("Y-m-d\\TH:i:s");
$import_xml = "<enterprise>\n\t\t\t\t\t\t<properties>\n\t\t\t\t\t\t\t<datasource>Plymouth State University SCT Banner</datasource>\n\t\t\t\t\t\t\t<datetime>" . $date_str . "</datetime>\n\t\t\t\t\t\t<properties>\n";
$pre_id = "<membership>\n\t\t\t\t\t\t<sourcedid>\n\t\t\t\t\t\t\t<source>Plymouth State University SCT Banner</source>\n\t\t\t\t\t\t\t<id>" . $this->course . "</id>\n\t\t\t\t\t\t</sourcedid>\n\t\t\t\t\t\t<member>\n\t\t\t\t\t\t\t<sourcedid>\n\t\t\t\t\t\t\t\t<source>Plymouth State University SCT Banner</source>\n";
$post_id = "\t\t</sourcedid>\n\t\t\t\t\t\t\t<idtype>1</idtype>\n\t\t\t\t\t\t\t<role recstatus = \"3\" roletype = \"01\">\n\t\t\t\t\t\t\t\t<status>0</status>\n\t\t\t\t\t\t\t</role>\n\t\t\t\t\t\t</member>\n\t\t\t\t\t\t</membership>\n";
$current_enrol_query = "SELECT distinct personsourcedid\n\t\t\t\t\t\t\t\tFROM mdl_lmb_enrolments \n\t\t\t\t\t\t\t\tWHERE coursesourcedid = ? \n\t\t\t\t\t\t\t\tAND role=?";
$currently_enrolled = PSU::db('moodle')->GetCol($current_enrol_query, array($this->course, 1));
$to_be_enrolled = array();
//If no one is currently enrolled, then don't worry about deletes
if (!$currently_enrolled) {
return '';
}
//end if
$this->population->query($this->args);
foreach ($this->population as $id) {
$to_be_enrolled[] = $id->scalar;
}
//end foreach
$to_unenroll = array_diff($currently_enrolled, $to_be_enrolled);
foreach ($to_unenroll as $id) {
$import_xml .= $pre_id . "<id>" . $id . "</id>\n" . $post_id;
}
//end foreach
$import_xml .= "</enterprise>\n</enterprise>\n";
$this->import_xml = $import_xml;
return $import_xml;
}
private function _get_components()
{
$args = array('pidm' => $this->pidm, 'aidy' => $this->aid_year, 'code' => null);
$sql = "\n\t\t\tSELECT RTVCOMP_DESC,\n\t\t\t\t NVL(RBRACMP_AMT, 0) RBRACMP_AMT\n\t\t\t FROM RBRACMP, RTVCOMP\n\t\t\t WHERE RBRACMP_AIDY_CODE = :aidy\n\t\t\t AND RBRACMP_PIDM = :pidm\n\t\t\t AND RBRACMP_COMP_CODE = RTVCOMP_CODE\n\t\t\t -- 080500-5\n\t\t\t AND (( :code IS NULL\n\t\t\t\t AND NOT EXISTS\n\t\t\t\t\t (SELECT 'X'\n\t\t\t\t\t\t FROM RTVBTYP\n\t\t\t\t\t\tWHERE RTVBTYP_PELL_IND = 'Y'\n\t\t\t\t\t\t AND RBRACMP_BTYP_CODE = RTVBTYP_CODE))\n\t\t\t\t\tOR\n\t\t\t\t\t( :code = 'PELL'\n\t\t\t\t AND EXISTS\n\t\t\t\t\t (SELECT 'X'\n\t\t\t\t\t\t FROM RTVBTYP\n\t\t\t\t\t\tWHERE RTVBTYP_PELL_IND = 'Y'\n\t\t\t\t\t\t AND RBRACMP_BTYP_CODE = RTVBTYP_CODE)))\n\t\t\tORDER BY RTVCOMP_PRINT_SEQ_NO\n\t\t";
$rset = PSU::db('banner')->Execute($sql, $args);
return $rset;
}
public function get()
{
$sql = "\n\t\t\tSELECT \n\t\t\t\tc.date_processed,\n\t\t\t\tm.*\n\t\t\tFROM\n\t\t\t\tpayment_plan_contract c\n\t\t\t\tJOIN v_bio b\n\t\t\t\t ON b.id = c.psu_id\n\t\t\t\tJOIN tbrmemo m\n\t\t\t\t ON tbrmemo_pidm = b.pidm\n\t\t\t\t AND tbrmemo_create_user = '******' || c.tms_customer_number\n\t\t\t\t AND tbrmemo_data_origin = 'feed_' || :file_sub_type\n\t\t\tWHERE\n\t\t\t\tc.file_id = :file_id\n\t\t";
$args = array('file_id' => $this->file_id, 'file_sub_type' => preg_replace('/[0-9]{4}_.+_(Grads?_)?([0-9]+)[^0-9]+$/', '\\2', $this->file_name));
$results = \PSU::db('banner')->GetAll($sql, $args);
return $results;
}
public function query($args = array())
{
$args = \PSU::params($args, $defaults);
$sql = "\n\t\t\tSELECT DISTINCT pidm\n\t\t\t FROM v_account\n\t\t";
$results = \PSU::db('banner')->GetCol($sql, $args);
return $results;
}
public function get()
{
$args = array('pidm' => $this->pidm);
$sql = "\n\t\t\tSELECT rprauth_pidm pidm,\n\t\t\t\t\t\t rprauth_term_code term_code,\n\t\t\t\t\t\t rfrbase_detail_code detail_code,\n\t\t\t\t\t\t rprauth_amount amount\n\t\t\tFROM rfrbase, rprauth\n\t\t\tWHERE rprauth_pidm = :pidm\n\t\t\t\tAND rfrbase_fund_code = rprauth_fund_code\n\t\t";
$rset = \PSU::db('banner')->Execute($sql, $args);
return $rset;
}
public function get()
{
$sql = "\n\t\t\tSELECT *\n\t\t\t FROM sfrrgfe\n\t\t\t WHERE sfrrgfe_term_code = :term_code\n\t\t\t AND sfrrgfe_type = 'STUDENT'\n\t\t\t\t AND sfrrgfe_flat_fee_amount IS NOT NULL\n\t\t";
$args = array('term_code' => $this->term_code);
$results = \PSU::db('banner')->Execute($sql, $args);
return $results;
}
public function delete()
{
//this function will delete a note
$sql = "UPDATE psu_identity.person_notes \n\t\t\t\t SET deleted=1 \n WHERE id = :note_id";
$data = array('note_id' => $this->id);
return \PSU::db('banner')->Execute($sql, $data);
}
public static function Batch_Verify_SPRADDR($in)
{
$defaults = array('fn_max_verify' => 3000000, 'fb_update' => true, 'fb_only_unverified' => false, 'fv_address_type' => null, 'fn_days_back' => null, 'fb_skip_international' => true, 'fb_verify_inactive' => false, 'fd_from_date' => null, 'fd_to_date' => null, 'fb_set_activity_date_user' => false, 'fv_set_source_code' => null);
$args = array_merge($defaults, $in);
$bind = array();
$sql = "BEGIN clean_address_banner.Batch_Verify_SPRADDR(";
foreach ($args as $key => $val) {
if (NULL === $val) {
continue;
}
if (is_bool($val) || "false" == strtolower($val) || "true" == strtolower($val)) {
$val = "true" == strtolower($val) || TRUE === $val ? "true" : "false";
$sql .= "{$key} => {$val},";
} else {
$sql .= "{$key} => :{$key},";
$bind[$key] = $val;
}
}
$sql = substr($sql, 0, -1);
$sql .= "); END;\t";
$stmt = \PSU::db('banner')->PrepareSP($sql);
foreach ($bind as $key => $val) {
\PSU::db('banner')->InParameter($stmt, $args[$key], $key);
}
\PSU::db('banner')->Execute($stmt);
}
/**
* retrieve deposits for a person
*/
public function get()
{
$args = array('pidm' => $this->pidm);
$sql = "BEGIN :c_cursor := tb_deposit.f_query_all(:pidm); END;";
$rset = \PSU::db('banner')->ExecuteCursor($sql, 'c_cursor', $args);
return $rset ? $rset : array();
}
public function __construct($params = false)
{
parent::__construct($params);
$this->user = $_SESSION['username'] ? 'NELNET_' . $_SESSION['username'] : '******';
$this->bursar_term = PSU::db('banner')->GetOne("SELECT value FROM psu.gxbparm WHERE param = 'ug_default_term'");
$this->entry_date = $this->activity_date = date('Y-m-d H:i:s');
$this->trans_date = $this->effective_date = date('Y-m-d');
}
public static function load()
{
$data = array();
$sql = "SELECT * FROM tbbctrl";
$data = \PSU::db('banner')->GetRow($sql);
$data = \PSU::cleanKeys('tbbctrl_', '', $data);
return $data;
}
public function __construct($db = null)
{
if (!$db) {
$db = PSU::db('banner');
}
//end if
$this->db = $db;
}
public function get_messages()
{
$args = array('pidm' => $this->pidm, 'aidy' => $this->aid_year);
// remove: AND RTVMESG_STOP_AWRD_PROCESS = 'Y'
$sql = "\n\t\t\tSELECT RORMESG_FULL_DESC,\n\t\t\t\t RORMESG_SHORT_DESC,\n\t\t\t\t RORMESG_ACTIVITY_DATE,\n\t\t\t\t RORMESG_MESG_CODE,\n\t\t\t\t RTVMESG_MESG_DESC\n\t\t\t FROM RORMESG LEFT JOIN RTVMESG ON RORMESG_MESG_CODE = RTVMESG_CODE\n\t\t\t WHERE\n\t\t\t\t\tRORMESG_PIDM = :pidm\n\t\t\t\t\tAND RORMESG_AIDY_CODE = :aidy\n\t\t\t\t\tAND RORMESG_EXPIRATION_DATE > SYSDATE\n\t\t\t\t\tAND ( RTVMESG_INFO_ACCESS_IND = 'Y' OR RTVMESG_INFO_ACCESS_IND IS NULL )\n\t\t";
$rset = PSU::db('banner')->Execute($sql, $args);
return $rset;
}
public function query($args = array())
{
$defaults = array('type_id' => $this->type, 'attribute' => $this->attribute);
$args = \PSU::params($args, $defaults);
$sql = "\n\t\t\tSELECT distinct wp_id\n\t\t\t FROM (\n\t\t\t\t\t\tSELECT wp_id\n\t\t\t\t\t\t\tFROM v_idm_attributes\n\t\t\t\t\t\t WHERE attribute = :attribute\n\t\t\t\t\t\t\t AND type_id = :type_id\n\t\t\t\t\t\t ORDER BY lower(last_name), \n\t\t\t\t\t\t\t\t\t lower(first_name), \n\t\t\t\t\t\t\t\t\t lower(middle_name)\n\t\t\t\t\t\t\t)\n\t\t";
$results = \PSU::db('banner')->GetCol($sql, $args);
return $results;
}
public function query($args = array())
{
$defaults = array('full_part' => $this->full_part, 'residential_code' => $this->residential_code, 'rate_code' => $this->rate_code);
$args = \PSU::params($args, $defaults);
$sql = "\n\t\t\tSELECT pidm\n\t\t\t FROM v_prebilling_candidates\n\t\t\t WHERE full_part_ind = :full_part\n\t\t\t\t AND resd_code = :residential_code\n\t\t\t\t AND rate_code = :rate_code\n\t\t";
$results = \PSU::db('banner')->GetCol($sql, $args);
return $results;
}
function insert_new_entries($employee_id)
{
global $db;
foreach ($_POST['group'] as $its_group_id => $group_option) {
$insert_new_entries = PSU::db('calllog')->Execute("INSERT INTO its_employee_groups (employee_id, group_id, option_id) VALUES ({$employee_id}, {$its_group_id}, {$group_option})");
}
return $insert_new_entries;
}
public function query($args, $where = array())
{
$where[] = '1=1';
$where_sql = ' AND ' . implode(' AND ', $where);
$sql = "\n\t\t\tSELECT\n\t\t\t\trcrapp4_fath_ssn, rcrapp4_fath_last_name, rcrapp4_fath_first_name_ini, rcrapp4_fath_birth_date,\n\t\t\t\trcrapp4_moth_ssn, rcrapp4_moth_last_name, rcrapp4_moth_first_name_ini, rcrapp4_moth_birth_date\n\t\t\tFROM\n\t\t\t\trcrapp1 LEFT JOIN rcrapp4 ON\n\t\t\t\t\trcrapp1_aidy_code = rcrapp4_aidy_code AND\n\t\t\t\t\trcrapp1_pidm = rcrapp4_pidm AND\n\t\t\t\t\trcrapp1_infc_code = rcrapp4_infc_code AND\n\t\t\t\t\trcrapp1_seq_no = rcrapp4_seq_no\n\t\t\tWHERE\n\t\t\t\trcrapp1_infc_code = 'EDE'\n\t\t\t\t{$where_sql}\n\t\t";
$rset = PSU::db('banner')->GetRow($sql, $args);
return $rset;
}
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 function get_requirements()
{
$args = array('pidm' => $this->pidm, 'aidy' => $this->aid_year);
// baninst1.bwrkrhst: CURSOR web_requirement_c
$sql = "\n\t\t\t\t SELECT RRRAREQ_STAT_DATE,\n\t\t\t\t\t\tRTVTRST_CODE, RTVTRST_DESC, RTVTRST_SAT_IND,\n\t\t\t\t\t\tRTVTREQ_CODE, RTVTREQ_SHORT_DESC, RTVTREQ_LONG_DESC, RTVTREQ_INSTRUCTIONS, RTVTREQ_URL\n\t\t\t\t FROM RRRAREQ, RTVTREQ, RTVTRST\n\t\t\t\t WHERE RRRAREQ_AIDY_CODE = :aidy\n\t\t\t\t\tAND RRRAREQ_PIDM = :pidm\n\t\t\t\t\tAND RTVTRST_INFO_ACCESS_IND = 'Y'\n\t\t\t\t\tAND RTVTREQ_INFO_ACCESS_IND = 'Y'\n\t\t\t\t\tAND RRRAREQ_INFO_ACCESS_IND = 'Y'\n\t\t\t\t\tAND RRRAREQ_TREQ_CODE = RTVTREQ_CODE\n\t\t\t\t\tAND RTVTREQ_ACTIVE_IND = 'Y'\n\t\t\t\t\tAND RRRAREQ_TRST_CODE = RTVTRST_CODE\n\t\t\t\t\tAND ( RRRAREQ_FUND_CODE IS NULL\n\t\t\t\t\t\t OR ( RRRAREQ_FUND_CODE IS NOT NULL\n\t\t\t\t\t\t\t AND NOT EXISTS (\n\t\t\t\t\t\t\t\t\t SELECT 'X'\n\t\t\t\t\t\t\t\t\t FROM RFRBASE\n\t\t\t\t\t\t\t\t\t WHERE RFRBASE_FUND_CODE = RRRAREQ_FUND_CODE\n\t\t\t\t\t\t\t\t\t\tAND RFRBASE_FED_FUND_ID = 'PELL')))\n\t\t";
$rset = PSU::db('banner')->Execute($sql, $args);
return $rset;
}
public function query($args = array())
{
$defaults = array('identifier' => 'sourced_id');
$args = PSU::params($args, $defaults);
$sql = "\n\t\t\tSELECT DISTINCT idnt." . $args['identifier'] . " \n\t\t\tFROM psu_identity.person_identifiers idnt,\n\t\t\t\t psu.v_hr_psu_employee_active act \n\t\t\tWHERE idnt.pid = act.pidm\n\t\t";
$matches = PSU::db('banner')->GetCol($sql);
return $matches;
}
/**
*
*/
public function get()
{
$sql = "\n\t\t\tSELECT *\n\t\t\tFROM sortest\n\t\t\tWHERE sortest_pidm = :pidm\n\t\t";
$args = array('pidm' => $this->student->pidm);
if ($rset = \PSU::db('banner')->Execute($sql, $args)) {
return $rset;
}
return array();
}