/** * insert custom fields into Banner */ public function insertSARRQST() { // @insert sarrqst data $sql = "INSERT INTO sarrqst(\n\t\t\t\t\t\tsarrqst_aidm,\n\t\t\t\t\t\tsarrqst_appl_seqno,\n\t\t\t\t\t\tsarrqst_seqno,\n\t\t\t\t\t\tsarrqst_load_ind,\n\t\t\t\t\t\tsarrqst_activity_date,\n\t\t\t\t\t\tsarrqst_qstn_desc,\n\t\t\t\t\t\tsarrqst_qstn_cde,\n\t\t\t\t\t\tsarrqst_ansr_desc,\n\t\t\t\t\t\tsarrqst_wudq_no,\n\t\t\t\t\t\tsarrqst_resp_flag\n\t\t\t\t\t)VALUES(\n\t\t\t\t\t\t:aidm,\n\t\t\t\t\t\t:appl_seqno,\n\t\t\t\t\t\t:seqno,\n\t\t\t\t\t\t'N',\n\t\t\t\t\t\tsysdate,\n\t\t\t\t\t\t:qstn_desc,\n\t\t\t\t\t\t:qstn_cde,\n\t\t\t\t\t\t:ansr_desc,\n\t\t\t\t\t\t:wudq_no,\n\t\t\t\t\t\t:resp_flag\n\t\t\t\t\t)"; $aidm = $this->getSABNSTUAidm($this->commonapplicantclientid); $appl_seqno = $this->getSARHEADApplSeqno($aidm); $prms = "SELECT decode(max(sarrqst_seqno)+1,null,1,max(sarrqst_seqno)+1)\n\t\t\t\t\t\tFROM sarrqst\n\t\t\t\t\t WHERE sarrqst_aidm=:aidm\n\t\t\t\t\t\t AND sarrqst_appl_seqno=:appl_seqno"; $row['aidm'] = $aidm; $row['appl_seqno'] = $appl_seqno; if ($this->fulltimestudent) { $row['seqno'] = PSU::db('banner')->GetOne($prms, compact('aidm', 'appl_seqno')); if ($this->fulltimestudent == 'Y') { $row['qstn_desc'] = "Are you applying as a full-time student?"; $row['qstn_cde'] = ""; $row['ansr_desc'] = "Yes"; $row['resp_flag'] = ""; $row['wudq_no'] = "13"; } if ($this->fulltimestudent == 'N') { $row['qstn_desc'] = "Are you applying as a full-time student?"; $row['qstn_cde'] = ""; $row['ansr_desc'] = "No"; $row['resp_flag'] = ""; $row['wudq_no'] = "13"; } $rs = PSU::db('banner')->Execute($sql, $row); if ($rs) { $successfully_moved_to_banner = true; } else { $successfully_moved_to_banner = false; psu::puke($client_id . " Failed trying to insert FULL TIME STUDENT INFO into Banner table SARRQST."); } } // end if if ($this->cellareacode && $this->cellphone) { $row['seqno'] = PSU::db('banner')->GetOne($prms, compact('aidm', 'appl_seqno')); $row['qstn_desc'] = "Your cell phone number (with area code):"; $row['qstn_cde'] = ""; $phone = preg_replace("/[^a-z \\d]/i", "", $this->cellphone); $row['ansr_desc'] = $this->cellareacode . $phone; $row['wudq_no'] = "25"; $row['resp_flag'] = ""; $rs = PSU::db('banner')->Execute($sql, $row); if ($rs) { $successfully_moved_to_banner = true; } else { $successfully_moved_to_banner = false; psu::puke($client_id . " Failed trying to insert CELL PHONE into Banner table SARRQST."); } } // end if $row['seqno'] = PSU::db('banner')->GetOne($prms, compact('aidm', 'appl_seqno')); $row['qstn_cde'] = "RS"; $row['qstn_desc'] = ""; $row['ansr_desc'] = ""; $row['wudq_no'] = ""; $row['resp_flag'] = $this->resident; $rs = PSU::db('banner')->Execute($sql, $row); if ($rs) { $successfully_moved_to_banner = true; } else { $successfully_moved_to_banner = false; psu::puke($client_id . " Failed trying to insert RESIDENT INFO into Banner table SARRQST."); } if ($this->parent1degree || $this->parent1graddegree || $this->parent1othergraddegree) { $row['seqno'] = PSU::db('banner')->GetOne($prms, compact('aidm', 'appl_seqno')); $row['qstn_cde'] = ""; if ($this->parent1type == "Father") { $row['qstn_desc'] = "What is the highest level of education your father completed?:<br>Enter ONLY the ONE LETTER CODE.<br>H = High School or GED<br>A = Associate Degree<br>B = Bachelors Degree<br>G = Graduate Degree"; $row['resp_flag'] = ""; $row['wudq_no'] = "16"; } elseif ($this->parent1type == "Mother") { $row['qstn_desc'] = "What is the highest level of education your mother completed?:<br>Enter ONLY the ONE LETTER CODE.<br>H = High School or GED<br>A = Associate Degree<br>B = Bachelors Degree<br>G = Graduate Degree"; $row['resp_flag'] = ""; $row['wudq_no'] = "17"; } if ($this->parent1degree == 1) { $deg1ans = ""; $row['ansr_desc'] = ""; } elseif ($this->parent1degree == "2" || $this->parent1degree == "3") { $deg1ans = "S"; $row['ansr_desc'] = "S"; } elseif ($this->parent1degree == "4" || $this->parent1degree == "5" || $this->parent1degree == "6") { $deg1ans = "H"; $row['ansr_desc'] = "H"; } elseif ($this->parent1degree == "7") { $deg1ans = "A"; $row['ansr_desc'] = "A"; } elseif ($this->parent1degree == "8") { $deg1ans = "B"; $row['ansr_desc'] = "B"; } if ($this->parent1graddegree == "1" || $this->parent1othergraddegree == "1") { $row['ansr_desc'] = $deg1ans; } elseif ($this->parent1graddegree == "2" || $this->parent1graddegree == "3" || $this->parent1graddegree == "4" || $this->parent1othergraddegree == "2" || $this->parent1othergraddegree == "3" || $this->parent1othergraddegree == "4") { $row['ansr_desc'] = "M"; } elseif ($this->parent1graddegree == "5" || $this->parent1graddegree == "6" || $this->parent1graddegree == "7" || $this->parent1othergraddegree == "5" || $this->parent1othergraddegree == "6" || $this->parent1othergraddegree == "7") { $row['ansr_desc'] = "G"; } $rs = PSU::db('banner')->Execute($sql, $row); if ($rs) { $successfully_moved_to_banner = true; } else { $successfully_moved_to_banner = false; psu::puke($client_id . " Failed trying to insert PARENT 1 DEGREE into Banner table SARRQST."); } } if ($this->parent2degree || $this->parent2graddegree || $this->parent2othergraddegree) { $row['seqno'] = PSU::db('banner')->GetOne($prms, compact('aidm', 'appl_seqno')); $row['qstn_cde'] = ""; if ($this->parent2type == "Father") { $row['qstn_desc'] = "What is the highest level of education your father completed?:<br>Enter ONLY the ONE LETTER CODE.<br>H = High School or GED<br>A = Associate Degree<br>B = Bachelors Degree<br>G = Graduate Degree"; $row['resp_flag'] = ""; $row['wudq_no'] = "16"; } elseif ($this->parent2type == "Mother") { $row['qstn_desc'] = "What is the highest level of education your mother completed?:<br>Enter ONLY the ONE LETTER CODE.<br>H = High School or GED<br>A = Associate Degree<br>B = Bachelors Degree<br>G = Graduate Degree"; $row['resp_flag'] = ""; $row['wudq_no'] = "17"; } if ($this->parent2degree == 1) { $deg1ans = ""; $row['ansr_desc'] = ""; } elseif ($this->parent2degree == "2" || $this->parent2degree == "3") { $deg1ans = "S"; $row['ansr_desc'] = "S"; } elseif ($this->parent2degree == "4" || $this->parent2degree == "5" || $this->parent2degree == "6") { $deg1ans = "H"; $row['ansr_desc'] = "H"; } elseif ($this->parent2degree == "7") { $deg1ans = "A"; $row['ansr_desc'] = "A"; } elseif ($this->parent2degree == "8") { $deg1ans = "B"; $row['ansr_desc'] = "B"; } if ($this->parent2graddegree == "1" || $this->parent2othergraddegree == "1") { $row['ansr_desc'] = $deg1ans; } elseif ($this->parent2graddegree == "2" || $this->parent2graddegree == "3" || $this->parent2graddegree == "4" || $this->parent2othergraddegree == "2" || $this->parent2othergraddegree == "3" || $this->parent2othergraddegree == "4") { $row['ansr_desc'] = "M"; } elseif ($this->parent2graddegree == "5" || $this->parent2graddegree == "6" || $this->parent2graddegree == "7" || $this->parent2othergraddegree == "5" || $this->parent2othergraddegree == "6" || $this->parent2othergraddegree == "7") { $row['ansr_desc'] = "G"; } $rs = PSU::db('banner')->Execute($sql, $row); if ($rs) { $successfully_moved_to_banner = true; } else { $successfully_moved_to_banner = false; psu::puke($client_id . " Failed trying to insert PARENT 2 DEGREE into Banner table SARHEAD."); } } return $successfully_moved_to_banner; }