$data['score'] = 'score';
$data['data'] = 'data';
// fputcsv($csv_output, $data);
foreach ($_POST as $question_id => $answer) {
$data = array();
$question_type = get_question_type($question_id);
//$check = "SELECT * FROM results WHERE study_id = ".$study_id." AND subj_id = ".$subject_id." AND question_id = ".$question_id;
//$result = mysql_query($check, $dbconnect);
// if(mysql_num_rows($result) == 0){
$questionnaire_id = get_questionnaire_for_question($question_id);
$data['subj_id'] = $subject_id;
$data['response_id'] = $response_id;
$data['study_id'] = $study_id;
$data['questionnaire_id'] = $questionnaire_id;
$data['question_id'] = $question_id;
$data['question_name'] = get_question_name($question_id, 'ro');
$data['question_type'] = $question_type;
$data['choice_id'] = null;
$data['score'] = null;
$data['data'] = null;
if ($question_type == 'choice') {
$choice_name = get_choice_name($answer, 'ro');
$query = "INSERT INTO results (`study_id`, `subj_id`, `questionnaire_id`, `question_id`, `choice_id`, `data`, `response_id`)\n\t\t\t\t\tVALUES ('" . $study_id . "', '" . $subject_id . "', '" . $questionnaire_id . "', '" . $question_id . "', '" . $answer . "', '" . $choice_name . "' , '" . $response_id . "') ";
$result = mysql_query($query, $dbconnect);
confirm_query($result);
$data['choice_id'] = $answer;
$data['score'] = get_choice_score($answer);
} elseif ($question_type == 'text') {
$query = "INSERT INTO results (`study_id`, `subj_id`, `questionnaire_id`, `question_id`, `data`, `response_id`)\n\t\t\t\t\t\t\t\t\t\tVALUES ('" . $study_id . "', '" . $subject_id . "', '" . $questionnaire_id . "', '" . $question_id . "', '" . mysql_real_escape_string(htmlspecialchars($answer)) . "', '" . $response_id . "') ";
$result = mysql_query($query, $dbconnect);
confirm_query($result);
// remove deleted choices
foreach ($rel_choices as $choice_id) {
if (!in_array((int) $choice_id, $sel_choices)) {
$query = "DELETE from choices WHERE `choice_id` = '" . $choice_id . "' ";
$result = mysql_query($query, $dbconnect);
confirm_query($result);
}
}
/*
* intrebare noua
*/
} else {
$query = "INSERT INTO questions (`questionnaire_id`,`name`,`type`)\n VALUES ('" . $questionnaire_id . "', '" . $question_name . "', '" . $question_type . "')";
if ($result = mysql_query($query, $dbconnect)) {
$question_id = mysql_insert_id();
$question_name = get_question_name($question_id, $lang);
$questionnaire_name = get_questionnaire_name($questionnaire_id, $lang);
$mesaj[] = "{$question_name} was added to {$questionnaire_name}.";
for ($index_c = 1; $index_c <= $_POST['number_of_choices_q' . $index_q]; $index_c++) {
$choice["ro"] = htmlspecialchars($_POST["question_" . $index_q . "_choice_" . $index_c . "_ro"]);
$choice["en"] = htmlspecialchars($_POST["question_" . $index_q . "_choice_" . $index_c . "_en"]);
$choice_name = mysql_real_escape_string(json_encode($choice));
$choice_score = htmlspecialchars($_POST["question_" . $index_q . "_choice_" . $index_c . "_score"]);
$query = "INSERT INTO choices (`question_id`, `name`, `score`)\n VALUES ('" . $question_id . "', '" . $choice_name . "', '" . $choice_score . "')";
$result = mysql_query($query, $dbconnect);
confirm_query($result);
}
}
}
}
for ($index_r = 1; $index_r <= 5; $index_r++) {
$query .= " AND `subj_id` = '$subject_id'";
}
$result = mysql_query($query);
confirm_query($result);
while ($row = mysql_fetch_array($result)) {
$subject_ids[] = $row['subj_id'];
$question_ids[] = $row['question_id'];
$header_data['subj_id'] = 'Subject id';
$header_data['subj_name'] = 'Subject name';
if($study_type == '360') {
$header_data['rel_subj_name'] = 'Subject evaluated';
$header_data['relation'] = 'Relation';
}
$header_data[$row['question_id']] = get_question_name($row['question_id'], $lang);
}
fputcsv($outstream, $header_data);
$subject_ids = array_unique($subject_ids);
foreach ($subject_ids as $subj_id) {
$response_ids = array();
$query = "SELECT response_id FROM results WHERE `study_id` = '".$study_id."' AND `subj_id` = '".$subj_id."'";
$result = mysql_query($query);
confirm_query($result);
while ($row = mysql_fetch_assoc($result)) {
$response_ids[] = $row['response_id'];
}
$response_ids = array_unique($response_ids);
__('Answer');
?>
</li>
<li class="score"><?php
__('Score');
?>
</li>
</ul>
</li>
<?php
$query = "SELECT * FROM results WHERE results.subj_id = " . $subject_id . " AND results.study_id = " . $study_id;
$result = mysql_query($query, $dbconnect);
while ($row = mysql_fetch_array($result)) {
$question_name = get_question_name($row['question_id'], $lang);
$question_type = get_question_type($row['question_id']);
$questionnaire_name = get_questionnaire_name($row['questionnaire_id'], $lang);
?>
<li>
<ul class="grid">
<li class="title">
<?php
echo $question_name;
?>
</li>
<li class="questionnaire_name">
<?php
echo $questionnaire_name;
?>
</li>
