예제 #1
0
 /**
  * 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();
 }
예제 #2
0
 /**
  * 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();
 }
예제 #3
0
 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;
 }
예제 #4
0
 /**
  * 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;
 }
예제 #5
0
 /**
  * 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;
 }
예제 #6
0
 /**
  * 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();
 }
예제 #7
0
 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;
 }
예제 #8
0
 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;
 }
예제 #10
0
 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;
 }
예제 #11
0
 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;
 }
예제 #12
0
 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;
 }
예제 #13
0
 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;
 }
예제 #16
0
 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);
 }
예제 #18
0
 /**
  * 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;
 }
예제 #21
0
 public function __construct($db = null)
 {
     if (!$db) {
         $db = PSU::db('banner');
     }
     //end if
     $this->db = $db;
 }
예제 #22
0
 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;
 }
예제 #23
0
 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;
 }
예제 #24
0
 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;
}
예제 #26
0
 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;
 }
예제 #27
0
 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;
 }
예제 #28
0
 /**
  *
  */
 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;
 }
예제 #29
0
 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;
 }
예제 #30
0
 /**
  *
  */
 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();
 }