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