File: /var/www/content-sp/work-sp/nqb_single_question_view.php
<?php
include_once('header.php');
$adminId = $editor_id; // print session USER_ID
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
//check search permissions
$fileName = str_replace('.php', '', basename($_SERVER['REQUEST_URI'], '?' . $_SERVER['QUERY_STRING']));
//if (in_array($fileName, $pageArray)) {
// echo "Yes";
$SP_MASTER_STRUCTURE = 'csp_sp_master_structure';
$SP_EDITORS = 'csp_editors';
$SP_QUESTION = 'csp_sp_question';
$SP_MASTER_CATEGORY = 'csp_sp_master_category';
$SP_MEDIUM = 'csp_sp_medium';
$SP_QUESTION_MEDIUM_WISE = 'csp_sp_question_medium_wise';
$SP_QUES_HISTORY = 'csp_sp_question_history';
$SP_QUESTION_STATUS_MODE = 'csp_sp_question_status_mode';
$ques_edit_url = '/work-sp/nqb_question_edit';
$ques_edit_url_live = '/work-sp/nqb_question_edit_live';
$ques_edit_url_trans = '/work-sp/nqb_question_edit_secondary';
$protocol = ((!empty($_SERVER['HTTPS']) && $_SERVER['HTTPS'] != 'off') || $_SERVER['SERVER_PORT'] == 443) ? "https://" : "http://";
$root_link = $protocol . $_SERVER['HTTP_HOST'] . '/';
$qId = $_REQUEST['qId'];
$secMed = $_REQUEST['secMed'];
if ($qId != '' && $qId != '0' && is_numeric($qId)) {
$queryQues = $conn->query("SELECT sq.question_id, sq.medium_id, sq.question_instruction, sq.question_statement, sq.option_1, sq.option_2, sq.option_3, sq.option_4, sq.option_5, sq.correct_answer, sq.question_solution, sq.add_date, sq.status,md.medium_name,ms.source FROM $SP_QUESTION as sq left join $SP_MASTER_CATEGORY as ms on ms.master_id=sq.master_id left join $SP_MEDIUM as md on md.medium_id=sq.medium_id where sq.question_id='$qId'");
$ql = $queryQues->fetch_assoc();
$getDataQuery2 = ("SELECT sq.id, sq.question_id,sq.medium_id,u.contact_name as add_by,sq.action,sq.action_date, m.medium_name FROM $SP_QUES_HISTORY as sq LEFT join $SP_EDITORS as u on u.editor_id=sq.action_by LEFT JOIN $SP_MEDIUM as m ON m.medium_id=sq.medium_id LEFT join $SP_QUESTION_STATUS_MODE as ac on ac.que_status_id= sq.action where sq.question_id='$qId' order by sq.id desc");
$allData2 = $conn->query($getDataQuery2);
$rowcount = mysqli_num_rows($allData2);
if ($ql['question_id'] != '') {
$i = 1;
$mType = strtolower($ql['source']);
include 'str_replace_type.php';
$instructions = str_replace('../', $root_link, $ql['question_instruction']);
$instructions = str_replace($spaceArray, $replaceSpaceArray, $instructions);
$question = str_replace('../', $root_link, $ql['question_statement']);
$question = str_replace($spaceArray, $replaceSpaceArray, $question);
$question_solution = str_replace('../', $root_link, $ql['question_solution']);
$question_solution = str_replace($spaceArray, $replaceSpaceArray, $question_solution);
$option1 = str_replace('../', $root_link, $ql['option_1']);
$option1 = str_replace($spaceArray, $replaceSpaceArray, $option1);
$option2 = str_replace('../', $root_link, $ql['option_2']);
$option2 = str_replace($spaceArray, $replaceSpaceArray, $option2);
$currect_ans = $ql['correct_answer'];
$medium_id = $ql['medium_id'];
if ($ql['option_3']) {
$option3 = str_replace('../', $root_link, $ql['option_3']);
$option3 = str_replace($spaceArray, $replaceSpaceArray, $option3);
} else {
$option3 = "";
}
if ($ql['option_4']) {
$option4 = str_replace('../', $root_link, $ql['option_4']);
$option4 = str_replace($spaceArray, $replaceSpaceArray, $option4);
} else {
$option4 = "";
}
if ($ql['option_5']) {
$option5 = str_replace('../', $root_link, $ql['option_5']);
$option5 = str_replace($spaceArray, $replaceSpaceArray, $option5);
} else {
$option5 = "";
}
// replacing cloze test blanks with question id
$varRep = array('{$curnt}' => $i, '{$curnt+1}' => $i + 1, '{$curnt+2}' => $i + 2, '{$curnt+3}' => $i + 3, '{$curnt+4}' => $i + 4, '{$curnt+5}' => $i + 5, '{$curnt+6}' => $i + 6, '{$curnt+7}' => $i + 7, '{$curnt+8}' => $i + 8, '{$curnt+9}' => $i + 9, '{$curnt+10}' => $i + 10, '{$curnt-1}' => $i - 1, '{$curnt-2}' => $i - 2, '{$curnt-3}' => $i - 3, '{$curnt-4}' => $i - 4, '{$curnt-5}' => $i - 5, '{$curnt-6}' => $i - 6, '{$curnt-7}' => $i - 7, '{$curnt-8}' => $i - 8, '{$curnt-9}' => $i - 9, '{$curnt-10}' => $i - 10);
$getEntity = $conn->query("SELECT m.master_name, s.category_name as subject, t.category_name as topic, st.category_name as subtopic from $SP_QUESTION as q LEFT JOIN $SP_MASTER_CATEGORY as m ON m.master_id=q.master_id LEFT JOIN $SP_MASTER_STRUCTURE as s ON s.sub_id=q.subject_id LEFT JOIN $SP_MASTER_STRUCTURE as t ON t.sub_id=q.topic_id LEFT JOIN $SP_MASTER_STRUCTURE as st ON st.sub_id=q.sub_topic_id where q.question_id='$qId'");
$entData = $getEntity->fetch_assoc();
$dispEnt = $entData['master_name'] . "->" . $entData['subject'] . "->" . $entData['topic'] . "->" . $entData['subtopic'];
}
}
?>
<link rel="stylesheet" href="assets/css/new-ques-ui.css">
<style>
.question-ui-section-box .question-ui-box .question-ui-options ul li p {
float: none !important;
top: 0 !important;
}
table {
background-color: transparent;
}
td,
th {
border: 1px solid #ddd;
width: 17%;
text-align: left;
padding: 8px !important;
}
.question-ui-box ul li {
display: inline-flex;
}
</style>
<div class="page-inner">
<div class="page-title">
<h3>View Question</h3>
</div>
<div id="main-wrapper">
<div class="row">
<?php if ($ql['question_id'] != '') { ?>
<div class="col-md-12">
<section class="question-ui-section">
<div class="container-fluid">
<div class="row question-ui-section-box mb-2">
<div class="col-md-6 col-sm-6 col-xs-12">
<div class="question-ui-box">
<h4><span>( <a target="_blank" href="sp_mock_question_view?question_id=<?php echo $qId; ?>&medium_id=<?php echo $medium_id; ?>&mtype=<?php echo $mType; ?>">Question Master Id </a>: <?php echo $qId; ?> )
<span class="edit-btn">
<a target="_blank" style="text-decoration: none;" href="<?php echo $ques_edit_url . '?action=edit&quesId=' . $qId . '&mType=' . $mType; ?>"><i class="fa fa-edit"></i></a></span>
</h4>
<h5 class="ques-topic-name"><?php echo $dispEnt; ?></h5>
<?php if ($instructions) { ?>
<div class="question-ui-instruc">
<h4>Instructions</h4>
<p><?php echo $instructions; ?></p>
</div>
<?php } ?>
<div class="question-ques-option">
<?php echo strtr((str_replace('../', $root_link, $question)), $varRep); ?>
</div>
<div class="question-ui-options">
<ul>
<li><input <?php if ($currect_ans == 1) echo "checked"; ?> id="rd_ans1<?php echo $i; ?>" type="radio" value="1" name="rd_ans<?php echo $i; ?>"><?php echo $option1; ?></li>
<li><input <?php if ($currect_ans == 2) echo "checked"; ?> id="rd_ans2<?php echo $i; ?>" type="radio" value="2" name="rd_ans<?php echo $i; ?>"><?php echo $option2; ?></li>
<?php if ($option3 != "") { ?>
<li><input <?php if ($currect_ans == 3) echo "checked"; ?> id="rd_ans3<?php echo $i; ?>" type="radio" value="3" name="rd_ans<?php echo $i; ?>"><?php echo $option3; ?></li>
<?php } ?>
<?php if ($option4 != "") { ?>
<li><input <?php if ($currect_ans == 4) echo "checked"; ?> id="rd_ans4<?php echo $i; ?>" type="radio" value="4" name="rd_ans<?php echo $i; ?>"><?php echo $option4; ?></li>
<?php } ?>
<?php if ($option5 != "") { ?>
<li><input <?php if ($currect_ans == 5) echo "checked"; ?> id="rd_ans5<?php echo $i; ?>" type="radio" value="5" name="rd_ans<?php echo $i; ?>"><?php echo $option5; ?></li>
<?php } ?>
</ul>
</div>
<div class="question-ui-options">
Solution: <?php echo $question_solution; ?>
</div>
</div>
</div>
<div class="col-md-6 col-sm-6 col-xs-12">
<div class="question-ui-box">
<?php
$secondaryQuery = $conn->query("SELECT qt.id, qt.question_id, qt.question_instruction, qt.question_statement, qt.option_1, qt.option_2, qt.option_3, qt.option_4, qt.option_5, qt.question_solution, qt.add_date, qt.status FROM $SP_QUESTION_MEDIUM_WISE AS qt where qt.question_id='$qId' and qt.medium_id='$secMed'");
$checkExists = mysqli_num_rows($secondaryQuery);
$secQues = $secondaryQuery->fetch_assoc();
if ($checkExists != '0') {
$questionID_T = $secQues['id'];
$addDate2 = $secQues['add_date'];
$ques_prf_statusT = $secQues['status'];
$instructions2 = str_replace('../', $root_link, $secQues['question_instruction']);
$instructions2 = str_replace($spaceArray, $replaceSpaceArray, $instructions2);
$question2 = str_replace('../', $root_link, $secQues['question_statement']);
$question2 = str_replace($spaceArray, $replaceSpaceArray, $question2);
$question_solution2 = str_replace('../', $root_link, $secQues['question_solution']);
$question_solution2 = str_replace($spaceArray, $replaceSpaceArray, $question_solution2);
$option1_2 = str_replace('../', $root_link, $secQues['option_1']);
$option2_2 = str_replace('../', $root_link, $secQues['option_2']);
$option1_2 = str_replace($spaceArray, $replaceSpaceArray, $option1_2);
$option2_2 = str_replace($spaceArray, $replaceSpaceArray, $option2_2);
// get question proof reading status
if ($secQues['option_3']) {
$option3_2 = str_replace('../', $root_link, $secQues['option_3']);
$option3_2 = str_replace($spaceArray, $replaceSpaceArray, $option3_2);
} else {
$option3_2 = "";
}
if ($secQues['option_4']) {
$option4_2 = str_replace('../', $root_link, $secQues['option_4']);
$option4_2 = str_replace($spaceArray, $replaceSpaceArray, $option4_2);
} else {
$option4_2 = "";
}
if ($secQues['option_5']) {
$option5_2 = str_replace('../', $root_link, $secQues['option_5']);
$option5_2 = str_replace($spaceArray, $replaceSpaceArray, $option5_2);
} else {
$option5_2 = "";
}
?>
<h4><span>( <a target="_blank" href="sp_mock_question_view?question_id=<?php echo $qId; ?>&medium_id=<?php echo $secMed; ?>&mtype=<?php echo $mType; ?>">Question Id </a>: <?php echo $qId . ' Ref. Id : ' . $questionID_T; ?> )
<span class="edit-btn">
<a target="_blank" style="text-decoration: none;" href="<?php echo $ques_edit_url_trans . '?action=edit&quesId=' . $questionID_T . '&mType=' . $mType; ?>"><i class="fa fa-edit"></i></a></span>
</h4>
<h5 class="ques-topic-name">Secondary Question</h5>
<?php if ($instructions2) { ?>
<div class="question-ui-instruc">
<h4>Instructions</h4>
<p><?php echo $instructions2; ?></p>
</div>
<?php } ?>
<div class="question-ques-option">
<?php echo strtr((str_replace('../', $root_link, $question2)), $varRep); ?>
</div>
<div class="question-ui-options">
<ul>
<li><input <?php if ($currect_ans == 1) echo "checked"; ?> id="rd_ans1sec<?php echo $i; ?>" type="radio" value="1" name="rd_anssec<?php echo $i; ?>"><?php echo $option1_2; ?></li>
<li><input <?php if ($currect_ans == 2) echo "checked"; ?> id="rd_ans2sec<?php echo $i; ?>" type="radio" value="2" name="rd_anssec<?php echo $i; ?>"><?php echo $option2_2; ?></li>
<?php if ($option3_2 != "") { ?>
<li><input <?php if ($currect_ans == 3) echo "checked"; ?> id="rd_ans3sec<?php echo $i; ?>" type="radio" value="3" name="rd_anssec<?php echo $i; ?>"><?php echo $option3_2; ?></li>
<?php } ?>
<?php if ($option4_2 != "") { ?>
<li><input <?php if ($currect_ans == 4) echo "checked"; ?> id="rd_ans4sec<?php echo $i; ?>" type="radio" value="4" name="rd_anssec<?php echo $i; ?>"><?php echo $option4_2; ?></li>
<?php } ?>
<?php if ($option5_2 != "") { ?>
<li><input <?php if ($currect_ans == 5) echo "checked"; ?> id="rd_ans5sec<?php echo $i; ?>" type="radio" value="5" name="rd_anssec<?php echo $i; ?>"><?php echo $option5_2; ?></li>
<?php } ?>
</ul>
</div>
<div class="question-ui-options">
Solution: <?php echo $question_solution2; ?>
</div>
<?php } else {
} ?>
</div>
</div>
</div>
</div>
</section>
<?php } ?>
<?php
if ($rowcount != 0) {
?>
<div class="col-md-8">
<div class="panel panel-info">
<div class="panel-heading clearfix">
<h4 class="panel-title">Question History
<i class="fa fa-info-circle" title="Informations"></i>
</h4>
</div>
<table class="table table-hover">
<tr>
<th>#</th>
<th>Medium</th>
<th>Action</th>
<th>ActionBy</th>
<th>On Date</th>
</tr>
<?php
$i = 1;
while ($h = $allData2->fetch_assoc()) {
$action = $h['action'];
if ($action == '2' || $action == '0') {
$whatAction = 'Add';
} else if ($action == '3') {
$whatAction = 'Proof Read';
} else if ($action == '4') {
$whatAction = 'Proofread & active';
} else if ($action == '1') {
$whatAction = 'Draft';
}
?>
<tr>
<td><?php echo $h['id']; ?></td>
<td><?php echo $h['medium_name']; ?></td>
<td> <span class="badge badge-success"><?php echo $whatAction; ?></span></td>
<td><?php echo $h['add_by']; ?></td>
<td><?php echo $h['action_date']; ?></td>
</tr>
<?php $i++;
} ?>
</table>
</div>
</div>
<?php } ?>
</div>
</div>
</div>
<div class="page-footer">
<p class="no-s">Graposs Connect ©</p>
</div>
</div>
<?php
include_once('footer.php');
?>