public function create($arr) { $arr['session_date'] = PSU_PASS_PASSObject::checkdate($arr['session_date']); // Setup SQL $args $params = array('request_id' => $arr['request_id'], 'session_date' => date('Y-m-d', strtotime($arr['session_date'])), 'session_duration' => $arr['session_duration'], 'session_type' => $arr['session_type'], 'tutor_pidm' => $arr['tutor_pidm']); // Setup $sql query. $sql = "INSERT INTO psu.pass_session (\n\t\t\t\t\t\t\trequest_id,\n\t\t\t\t\t\t\tsession_date,\n\t\t\t\t\t\t\tsession_duration,\n\t\t\t\t\t\t\tsession_type,\n\t\t\t\t\t\t\ttutor_pidm)\n\t\t\t\t\t\tVALUES (\n\t\t\t\t\t\t\t:request_id,\n\t\t\t\t\t\t\tto_date(:session_date,'YYYY-MM-DD'),\n\t\t\t\t\t\t\t:session_duration,\n\t\t\t\t\t\t\t:session_type,\n\t\t\t\t\t\t\t:tutor_pidm)\n\t\t\t\t\t\t"; // Execute and return results if ($results = PSU::db('banner')->Execute($sql, $params)) { $params['pidm'] = $arr['pidm']; $params['term_code'] = $arr['term_code']; PASS::update_tutor_service_counts($params); return true; } return false; }
public function extra_info($arr, $params, $extra_inserts, $extra_values, $extra_sets) { // Add more data to the insert if more than minimum amount is passed. if (strlen($arr['decision_date']) > 1) { $arr['decision_date'] = PSU_PASS_PASSObject::checkdate($arr['decision_date']); $params['decision_date'] = date('Y-m-d', strtotime($arr['decision_date'])); $extra_inserts .= "decision_date,"; $extra_values .= "to_date(:decision_date,'YYYY-MM-DD'),"; $extra_sets .= "decision_date = to_date(:decision_date,'YYYY-MM-DD'),"; } if (strlen($arr['tutor_id']) > 1) { $tutor = new PSUPerson($arr['tutor_id']); $params['assigned_tutor_pidm'] = $tutor->pidm; $extra_inserts .= "assigned_tutor_pidm,"; $extra_values .= ":assigned_tutor_pidm,"; $extra_sets .= "assigned_tutor_pidm = :assigned_tutor_pidm,"; } }