/**
* Create a new tutor request given an array of information
*/
public function create($arr)
{
// Get sequence number for insert.
if (!$arr['course_id'] || !$arr['request_date']) {
//return false;
}
$arr['request_date'] = PSU_PASS_PASSObject::checkdate($arr['request_date']);
// Setup SQL $args
$params = array('term_code' => $arr['term_code'], 'student_pidm' => $arr['student_pidm'], 'course_id' => $arr['course_id'], 'request_date' => date('Y-m-d', strtotime($arr['request_date'])), 'request_status' => $arr['request_status']);
self::extra_info(&$arr, &$params, &$extra_inserts, &$extra_values, &$extra_sets);
// Setup $sql query.
$sql = "INSERT INTO psu.pass_tutor_request (\n\t\t\t\t\t\t\tterm_code,\n\t\t\t\t\t\t\tstudent_pidm,\n\t\t\t\t\t\t\tcourse_id,\n\t\t\t\t\t\t\trequest_date,\n\t\t\t\t\t\t\t{$extra_inserts}\t\n\t\t\t\t\t\t\trequest_status)\n\t\t\t\t\t\tVALUES (\n\t\t\t\t\t\t\t:term_code,\n\t\t\t\t\t\t\t:student_pidm,\n\t\t\t\t\t\t\t:course_id,\n\t\t\t\t\t\t\tto_date(:request_date,'YYYY-MM-DD'),\n\t\t\t\t\t\t\t{$extra_values}\n\t\t\t\t\t\t\t:request_status)\n\t\t\t\t\t\t";
// Execute and return results
if ($results = PSU::db('banner')->Execute($sql, $params)) {
$params['pidm'] = $arr['student_pidm'];
$params['session_type'] = 'ZTUR';
PASS::update_tutor_service_counts($params);
$params['session_type'] = 'PF';
PASS::update_tutor_service_counts($params);
PASS::update_tutor_service_counts($params);
$params['session_type'] = 'CA';
PASS::update_tutor_service_counts($params);
return true;
}
return false;
}
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;
}
