/**
* 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;
}
