File: /var/www/content-sp/work-sp/nqb_question_duplicate_statement_odia_specific.php
<?php
// ini_set('display_errors', 1);
// ini_set('display_startup_errors', 1);
// error_reporting(E_ALL);
include_once('nqb_master_section.php');
include_once 'pagination.php';
$SP_QUESTION = 'csp_sp_question';
$SP_QUESTION_MEDIUM_WISE = 'csp_sp_question_medium_wise';
$TT_PREVIOUS_EXAM_TABLE = 'csp_sp_previous_exam';
$SP_MASTER_CATEGORY = 'csp_sp_master_category';
$fileName = str_replace('.php', '', basename($_SERVER['REQUEST_URI'], '?' . $_SERVER['QUERY_STRING']));
if (in_array($fileName, $pageArray)) {
$protocol = ((!empty($_SERVER['HTTPS']) && $_SERVER['HTTPS'] != 'off') || $_SERVER['SERVER_PORT'] == 443) ? "https://" : "http://";
$root_link = $protocol . 'content.grapossconnect.com' . '/';
$pagination_link = 'nqb_question_duplicate_statement_odia_specific';
/***search */
if (isset($_REQUEST['submit'])) {
$dup_val = $_REQUEST['dup_val'];
$_SESSION['DPO_QUERY'] = $dup_val;
}
/**Session */
if (!empty($_SESSION['DPO_QUERY'])) {
$ssQuery = $_SESSION['DPO_QUERY'];
$limit = 100;
$pageNo = isset($_GET['pageN']) ? $_GET['pageN'] : 1;
$indexN = ($pageNo - 1) * $limit;
$countQuery = $conn->query("SELECT count(sp.question_id) as total FROM $SP_QUESTION as sp LEFT JOIN $SP_MASTER_CATEGORY as m on m.master_id=sp.master_id where sp.master_id='13' and sp.subject_id='14034' group by $ssQuery HAVING count(sp.question_id) > 2");
$cQuery = $countQuery->fetch_assoc();
$count = mysqli_num_rows($countQuery);
$noOfPages = ceil($count / $limit);
$getQuestions = $conn->query("SELECT count(sp.question_id) as total,$ssQuery,m.source FROM $SP_QUESTION as sp LEFT JOIN $SP_MASTER_CATEGORY as m on m.master_id=sp.master_id where sp.master_id='13' and sp.subject_id='14034' group by $ssQuery HAVING count(sp.question_id) > 2 order by count(sp.question_id) desc limit $indexN, $limit");
$expQ = str_replace(" ", "", explode(",", $ssQuery));
}
?>
<style>
.table-hover th,
td {
font-size: 13px;
}
.redClass {
background-color: #ff6d6d !important;
}
.orangeClass {
background-color: #ff7607 !important;
}
.modal-backdrop.in {
opacity: 0.9 !important;
z-index: 9 !important;
}
.topic {
width: 20%;
float: left;
font-size: 14px;
margin: 0 0 0 0;
}
.sub_topic {
width: 26%;
float: left;
font-size: 14px;
margin: 0 0 0 -19px;
}
</style>
<?php if (isset($msg)) { ?>
<div class="row">
<div class="col-sm-12">
<?php echo $msg; ?>
</div>
</div>
<?php } ?>
<div class="row">
<div class="col-md-12">
<div class="panel panel-primary">
<div class="panel-heading clearfix">
<h4 class="panel-title">Search Duplicate Instruction/Statement/Options</h4>
</div>
<div class="spacer"></div>
<div class="panel-body">
<form class="form-horizontal" method="post">
<label for="editor" class="col-sm-2">Filters :</label>
<div class="col-sm-10">
<div class="form-group">
<input type="checkbox" class="dup_query" value="question_instruction" name="dup_box" id="question_instruction">Instruction
<input type="checkbox" class="dup_query" value="question_statement" name="dup_box" id="question_statement">Question Statement
<input type="checkbox" class="dup_query" value="option_1" name="dup_box" id="question_instruction">Option (A)
<input type="checkbox" class="dup_query" value="option_2" name="dup_box" id="option_2">Option (B)
<input type="checkbox" class="dup_query" value="option_3" name="dup_box" id="option_3">Option (C)
<input type="checkbox" class="dup_query" value="option_4" name="dup_box" id="option_4">Option (D)
<input type="hidden" name="dup_val" id="dup_val">
</div>
</div>
<input class="btn btn-info" type="submit" value="Search" name="submit" />
</form>
</div>
</div>
</div>
<?php if (!empty($_SESSION['DPO_QUERY'])) { ?>
<div class="col-md-12">
<?php echo pagination($limit, $pageNo, $pagination_link . "?pageN=", $count); ?>
</div>
<div class="col-md-12">
<div class="panel panel-info">
<div class="col-md-12">
<div class="panel panel-info">
<div class="panel-heading clearfix">
<h4 class="panel-title">Total [ <?php echo $count; ?> ]</h4>
</div>
<table class="table table-hover">
<tr>
<th>S.No.</th>
<?php if (in_array("question_instruction", $expQ)) { ?>
<th>Instruction</th>
<?php } ?>
<?php if (in_array("question_statement", $expQ)) { ?>
<th>Question</th>
<?php } ?>
<?php if (in_array("option_1", $expQ)) { ?>
<th>Option A</th>
<?php } ?>
<?php if (in_array("option_2", $expQ)) { ?>
<th>Option B</th>
<?php } ?>
<?php if (in_array("option_3", $expQ)) { ?>
<th>Option C</th>
<?php } ?>
<?php if (in_array("option_4", $expQ)) { ?>
<th>Option D</th>
<?php } ?>
<th>Total</th>
<th>View</th>
</tr>
<?php
$i = 1;
foreach ($getQuestions as $qb) {
$mType = strtolower($qb['source']);
include_once('str_replace_type.php');
?>
<tr>
<td><?php echo $i + $indexN; ?></td>
<?php if (in_array("question_instruction", $expQ)) { ?>
<td><?php
$instructions = str_replace('../', $root_link, $qb['question_instruction']);
echo $instructions = str_replace($spaceArray, $replaceSpaceArray, $instructions); ?></td>
<?php } ?>
<?php if (in_array("question_statement", $expQ)) { ?>
<td><?php
$question_statement = str_replace('../', $root_link, $qb['question_statement']);
echo $question_statement = str_replace($spaceArray, $replaceSpaceArray, $question_statement);
?></td>
<?php } ?>
<?php if (in_array("option_1", $expQ)) { ?>
<td><?php
$option1 = str_replace('../', $root_link, $qb['option_1']);
echo $option1 = str_replace($spaceArray, $replaceSpaceArray, $option1);
?></td>
<?php } ?>
<?php if (in_array("option_2", $expQ)) { ?>
<td><?php
$option2 = str_replace('../', $root_link, $qb['option_2']);
echo $option2 = str_replace($spaceArray, $replaceSpaceArray, $option2);
?></td>
<?php } ?>
<?php if (in_array("option_3", $expQ)) { ?>
<td><?php
$option3 = str_replace('../', $root_link, $qb['option_3']);
echo $option3 = str_replace($spaceArray, $replaceSpaceArray, $option3);
?></td>
<?php } ?>
<?php if (in_array("option_4", $expQ)) { ?>
<td><?php
$option4 = str_replace('../', $root_link, $qb['option_4']);
echo $option4 = str_replace($spaceArray, $replaceSpaceArray, $option4);
?></td>
<?php } ?>
<td><?php echo $qb['total']; ?></td>
<td>
<form target="_blank" action="nqb_question_duplicate_statement_view" method="post">
<?php if (in_array("question_instruction", $expQ)) { ?>
<input type="hidden" name="q_ins" value="<?php echo base64_encode($qb['question_instruction']); ?>">
<?php } ?>
<?php if (in_array("question_statement", $expQ)) { ?>
<input type="hidden" name="q_s" value="<?php echo base64_encode($qb['question_statement']); ?>">
<?php } ?>
<?php if (in_array("option_1", $expQ)) { ?>
<input type="hidden" name="q_1" value="<?php echo base64_encode($qb['option_1']); ?>">
<?php } ?>
<?php if (in_array("option_2", $expQ)) { ?>
<input type="hidden" name="q_2" value="<?php echo base64_encode($qb['option_2']); ?>">
<?php } ?>
<?php if (in_array("option_3", $expQ)) { ?>
<input type="hidden" name="q_3" value="<?php echo base64_encode($qb['option_3']); ?>">
<?php } ?>
<?php if (in_array("option_4", $expQ)) { ?>
<input type="hidden" name="q_4" value="<?php echo base64_encode($qb['option_4']); ?>">
<?php } ?>
<input type="hidden" name="q_str" value="<?php echo $ssQuery; ?>">
<button type="submit" class="btn btn-sm btn-info">View</button>
</form>
</td>
</tr>
<?php $i++;
} ?>
</table>
</div>
</div>
</div>
</div>
<div class="col-md-12">
<?php echo pagination($limit, $pageNo, $pagination_link . "?pageN=", $count); ?>
</div>
<?php } ?>
<div class="page-footer">
<p class="no-s">Graposs Connect ©</p>
</div>
</div>
<script type="text/javascript">
jQuery('.dup_query').click(function() {
var dup_box = jQuery("input[name='dup_box']:checked").map(function() {
return this.value;
}).get().join(',');
jQuery("#dup_val").val(dup_box);
});
</script>
<?php
} else {
echo "<script type='text/javascript'>alert('You dont have access to this link');</script>";
echo "<script type='text/javascript'>location.href='/work-sp';</script>";
}
include_once('footer.php');
?>