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);
foreach($response_ids as $response_id){
$query = "SELECT * FROM results WHERE `study_id`='".$study_id."' AND `subj_id`='".$subj_id."' AND `response_id`='".$response_id."'";
$result = mysql_query($query);
confirm_query($result);
while ($row = mysql_fetch_assoc($result)) {
$data['subj_id'] = $subj_id;
$data['subj_name'] = get_subj_name($subj_id);
if($study_type == '360') {
$data['rel_subj_name'] = get_subj_name(get_rel_subj_id($subj_id, $response_id));
$data['relation'] = $relatii[get_relation($subj_id, $response_id)];
}
$data[$row['question_id']] = $row['data'];
}
fputcsv($outstream, $data);
}
}
fclose($outstream);
}
?>
if ($action == "add") {
$mesaj = array();
$query = "INSERT INTO liste (`name`, `desc`, `public`)\n VALUES ('" . $list_name . "', '" . $list_desc . "', '" . $list_public . "')";
$result = mysql_query($query, $dbconnect);
confirm_query($result);
$list_id = mysql_insert_id();
if (mysql_affected_rows() == 1) {
$list_name = get_list_name($list_id, $lang);
$mesaj[] = "List {$list_name} has been created.";
}
foreach ($sel_subjects as $subj_id) {
$query = "INSERT INTO rel_subj_list (`list_id`, `subj_id`) VALUES ('" . $list_id . "', '" . $subj_id . "')";
$result = mysql_query($query, $dbconnect);
confirm_query($result);
if (mysql_affected_rows() == 1) {
$subj_name = get_subj_name($subj_id);
$mesaj[] = "Subject {$subj_name} has been added to list.";
}
}
$_SESSION["mesaj"] = $mesaj;
//output_message(); exit;
redirect("view_list.php?list_id=" . $list_id);
redirect("manage_lists.php");
}
/* end add list */
/* delete list*/
if ($action == "delete") {
$mesaj = array();
$list_name = get_list_name($list_id, $lang);
$query = "DELETE FROM liste WHERE list_id = '" . $list_id . "'";
$result = mysql_query($query, $dbconnect);
<?php require_once("../includes/header.php") ?>
<?php
if(isset($_GET["quest_id"]) && isset($_GET["subj_id"]) && isset($_GET["study_id"]))
{
$quest_id = $_GET["quest_id"];
$subject_id = $_GET["subj_id"];
$subject_name = get_subj_name($subject_id);
$quest_name = get_questionnaire_name($quest_id, $lang);
$study_id = $_GET["study_id"];
$study_name = get_study_name($study_id, $lang);
?>
<h1 class="quest"><?php __("Scoring")?> - <?php echo $quest_name ?></h1>
<p><strong><?php __("Subject name") ?></strong>: <?php echo $subject_name; ?></p>
<div id="list_details">
<ul>
<?
$query = "SELECT * FROM results WHERE results.subj_id = ".$subject_id." AND results.study_id = ".$study_id.' AND questionnaire_id='.$quest_id;
$result = mysql_query($query, $dbconnect);
$quest = array();
while($row = mysql_fetch_assoc($result))
{
$quest[] = $row;
}
//urat dar repede
if ($quest_id == 4 || $quest_id == 7)// E-RIBS & M-RIBS
{
$max = 5;
$map = array(
//
if (mysql_numrows($tester) == 0) {
$subj = mysql_fetch_array($tester);
$sub_neevaluati[] = $rel_subject_id;
}
}
if (count($sub_neevaluati) != 0) {
?>
<p><strong><em><?php
__('Person being evaluated.');
?>
</em></strong></p>
<select name="sub_evaluat">
<?php
foreach ($sub_neevaluati as $subj_id) {
$subject_name = get_subj_name($subj_id) . "<br />";
?>
<option value="<?php
echo $subj_id;
?>
"><?php
echo $subject_name;
?>
</option>
<?php
}
?>
</select>
<?php
} else {
?>
$mesaj[] = "{$subj_first_name} {$subj_last_name} was added to database.";
}
foreach ($sel_lists as $list_id) {
$query = "INSERT INTO rel_subj_list (`list_id`, `subj_id`) VALUES ('" . $list_id . "', '" . $subj_id . "')";
$result = mysql_query($query, $dbconnect);
if (mysql_affected_rows() == 1) {
$list_name = get_list_name($list_id, $lang);
$mesaj[] = "Subject has been added to list {$list_name}.";
}
}
$_SESSION["mesaj"] = $mesaj;
redirect("view_subject.php?subj_id=" . $subj_id);
}
// delete subject
if ($action == "delete") {
$subj_name = get_subj_name($subj_id, $lang);
$mesaj = array();
$query = "DELETE FROM subjects WHERE subj_id = '" . $subj_id . "' ";
//echo $query; exit;
$result = mysql_query($query, $dbconnect);
confirm_query($result);
if (mysql_affected_rows() == 1) {
$mesaj[] = "Subject {$subj_name} has been deleted.";
}
$query = "DELETE FROM rel_subj_list WHERE subj_id = '" . $subj_id . "' ";
$result = mysql_query($query, $dbconnect);
confirm_query($result);
if (mysql_affected_rows() >= 1) {
$mesaj[] = "Relations to {$subj_name} were removed.";
}
$_SESSION["mesaj"] = $mesaj;
$list_id = $row["list_id"];
$subjects = get_subj_for_list($list_id);
while ($subject = mysql_fetch_array($subjects)) {
$subj_ids[] = $subject["subj_id"];
}
}
if (!empty($subj_ids)) {
$subj_ids = array_unique($subj_ids);
foreach ($subj_ids as $subj_id) {
?>
<li>
<a href="view_subject.php?subj_id=<?php
echo $subj_id;
?>
"><?php
echo get_subj_name($subj_id);
?>
</a>
<?php
$check = "SELECT * FROM results WHERE study_id = " . $study_id . " AND subj_id = " . $subj_id;
$result = mysql_query($check, $dbconnect);
if (mysql_num_rows($result) == 0) {
?>
<a href="../fill.php?data=<?php
echo base64_encode(implode(',', array($study_id, $subj_id)));
?>
"><?php
__("[fill]");
?>
</a>
