public function executeCreate(sfWebRequest $request)
{
//$this->forward404Unless($request->isMethod(sfRequest::POST));
//if($request->isMethod(sfRequest::POST)){
$data = $request->getParameterHolder()->getAll();
//get all the data from request post/get
$data_array = json_decode($data['data'], true);
//convert the json string to array
//$accessToken = $data_array['accessToken'];
$activity_id = $data_array['activity_id'];
$assessments = $data_array['assessments'];
$device_id = $data_array['device_id'];
$option_email = $data_array['email'];
/*
echo "<pre>";
print_r($assessments);
exit();
*/
$response = array();
$assessmentAutoId = array();
// $activity_type_id = Doctrine::getTable('Activities')->func_getActivityTypeId($activity_id);
$student_obj = Doctrine::getTable('Students');
if (is_array($assessments) && count($assessments)) {
$tbl_format = '<table width="100%">';
foreach ($assessments as $assessment) {
$auto_id = $assessment['auto_id'];
$found_it = $assessment['found_it'];
$taps = $assessment['Taps'];
$target_word = $assessment['target_word'];
$incorrect_word_taps = $assessment['incorrect_word_taps'];
unset($assessment['auto_id']);
unset($assessment['found_it']);
unset($assessment['Taps']);
unset($assessment['incorrect_word_taps']);
$device_session_id = $assessment['device_session_id'];
$device_session_id_explode = explode('_', $device_session_id);
$student_id = $device_session_id_explode[0];
unset($assessment['device_session_id']);
$authenticated = $student_obj->func_checkStudentId($student_id);
if ($authenticated[0]['student_id'] != '') {
foreach ($assessment as $assessment_parameter => $value) {
$this->table = 'AssessmentResultsWordHunt';
$tbl_format .= '<tr><td>' . $assessment_parameter . '</td><td>' . $value . '</td></tr>';
$ass_table = new $this->table();
$assessmentData = Doctrine::getTable($this->table)->func_checkActivityAutoId($device_id, $auto_id, $activity_id, $student_id, $device_session_id);
if ($assessmentData['auto_id'] == '') {
$getMaxTryNo = Doctrine_Manager::getInstance()->getConnection('doctrine')->getDbh()->query("SELECT max(try_number) as 'max' from `assessment_results_word_hunt` where activity_id='" . $activity_id . "' and student_id='" . $student_id . "' and device_id='" . $device_id . "' and target_word='" . trim($target_word) . "'")->fetchAll();
$try_number = 1 + $getMaxTryNo['0']['max'];
$ass_table->activity_id = $activity_id;
$ass_table->student_id = $student_id;
$ass_table->found_it = $found_it;
$ass_table->auto_id = $auto_id;
$ass_table->taps = $taps;
$ass_table->try_number = $try_number;
$ass_table->incorrect_word_taps = $incorrect_word_taps;
$ass_table->found_it = $found_it;
$ass_table->target_word = $target_word;
$ass_table->device_id = $device_id;
$ass_table->device_session_id = $device_session_id;
$ass_table->time_stamp = date("Y-m-d h:i:s", time());
$ass_table->save();
$assessmentAutoId[$auto_id] = 1;
} else {
$assessmentAutoId[$auto_id] = 0;
}
unset($this->table);
unset($assessmentData);
}
} else {
$response['STATUS'] = 0;
$response['MESSAGE'] = "Login Required!";
$json = json_encode($response);
return $this->renderText($json);
}
}
$objCommon = new CommonFunctions();
$objCommon->func_graphGenerate($student_id, $option_email);
$response['STATUS'] = 1;
$response['MESSAGE'] = "Data Inserted Successfully!";
$response['autoIds'] = $assessmentAutoId;
} else {
$response['STATUS'] = 0;
$response['MESSAGE'] = "No data Found!";
}
// end of if() that checks accessToken dg fdgd f
/* } // end of if() that checks POST method
else
{
$response['STATUS'] = 0;
$response['MESSAGE'] = "You are not using post method!";
$response['accessToken'] = null;
} */
$json = json_encode($response);
$obj_CommonFunctions = new CommonFunctions();
//$obj_CommonFunctions->get_BookRelatedDataToMail($student_id, $tbl_format);
return $this->renderText($json);
//$this->setTemplate('getdata');
}