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,";
}
}
