File: /var/www/content-sp/work-sp/nqb_question_search.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_QUESTION = 'csp_sp_question';
$SP_QUESTION_MEDIUM_WISE = 'csp_sp_question_medium_wise';
$SP_EDITORS = 'csp_editors';
$SP_MASTER_CATEGORY = 'csp_sp_master_category';
$protocol = ((!empty($_SERVER['HTTPS']) && $_SERVER['HTTPS'] != 'off') || $_SERVER['SERVER_PORT'] == 443) ? "https://" : "http://";
$root_link = $protocol . $_SERVER['HTTP_HOST'] . '/';
$ques_view_url = '/work-sp/nqb_single_question_view';
?>
<link rel="stylesheet" type="text/css" href="https://ajax.googleapis.com/ajax/libs/jqueryui/1.8/themes/base/jquery-ui.css" />
<script src="assets/plugins/jquery/jquery-2.1.3.min.js"></script>
<script src="assets/plugins/jquery-ui/jquery-ui.min.js"></script>
<link href="assets/plugins/datatables/css/jquery.datatables.min.css" rel="stylesheet">
<link href="assets/plugins/datatables/css/responsive.datatables.min.css" rel="stylesheet">
<script src="assets/plugins/datatables/js/jquery.datatables.min.js"></script>
<script src="assets/plugins/datatables/js/jquery.datatables.js"></script>
<script src="assets/plugins/datatables/js/datatables.responsive.min.js"></script>
<script type="text/javascript">
jQuery(function($) {
$(".search_term").keydown(function(event) {
var search_type = "";
//var search_type = $("#cmbSearchType option:selected").value();
var search_type = $("#cmbSearchType").val();
var qType = $("#cmbQtype").val();
//alert(search_type);
$("#" + event.target.id).autocomplete({
source: 'ajax_call/nqb_question_search_json.php?type=' + search_type + '&qType=' + qType,
minLength: 5,
});
});
});
jQuery.noConflict();
jQuery(function($) {
$('#question_search').dataTable({
"bPaginate": true,
bFilter: true,
"responsive": true,
"iDisplayLength": 50
});
});
</script>
<style>
.table-hover th,
td {
font-size: 13px;
padding: 9px !important;
}
.modal-backdrop.in {
opacity: 0.9 !important;
z-index: 9 !important;
}
table.dataTable.dtr-inline.collapsed>tbody>tr[role="row"]>td:first-child,
table.dataTable.dtr-inline.collapsed>tbody>tr[role="row"]>th:first-child {
padding-left: 30px !important;
}
select.form-control {
width: 15em !important;
}
</style>
<div class="page-inner">
<div class="page-title">
<h3>Search Questions</h3>
</div>
<div id="main-wrapper">
<div class="row">
<div class="col-md-12">
<div class="panel panel-info">
<div class="panel-heading clearfix">
<h4 class="panel-title"> Search in New Question Master:</h4>
</div>
<div class="spacer"></div>
<div class="panel-body">
<form class="form-horizontal" method="post">
<div class="row">
<div class="form-group">
<div class="col-sm-4">
<select name="ques_of" id="ques_of" class="form-control">
<option value="sp">SP</option>
<option value="oly">OLY</option>
</select>
</div>
</div>
</div>
<div class="row">
<div class="form-group">
<div class="col-sm-4">
<select name="cmbSearchType" id="cmbSearchType" class="form-control">
<option value="8">Question Id</option>
<option value="1">Question Statement</option>
<option value="3">Option1</option>
<option value="4">Option2</option>
<option value="5">Option3</option>
<option value="6">Option4</option>
<option value="7">Option5</option>
</select>
</div>
</div>
</div>
<div class="row">
<div class="form-group">
<div class="col-sm-3">
<select name="cmbQtype" id="cmbQtype" class="form-control">
<option value="1">Primary</option>
<option value="1">Secondary</option>
</select>
</div>
<div class="col-sm-7">
<input type="text" id="search_term" name="search_term" class="form-control search_term" value="" placeholder="Question,Instruction,Option" required />
</div>
<div class="col-sm-2">
<button class="btn btn-success" type="submit" name="search_question">Search</button>
</div>
</div>
</div>
</form>
</div>
</div>
</div>
<?php
if (isset($_REQUEST['search_question'])) {
// $mType = $_REQUEST['ques_of'];
$search_type = $_REQUEST['cmbSearchType'];
$cmbQtype = $_REQUEST['cmbQtype'];
$search_term = str_replace('=> ', '', $_REQUEST['search_term']);
$_SESSION['type'] = $search_type;
$_SESSION['term'] = $search_term;
if ($search_type == 1) {
$column = "sq.question_statement";
} else if ($search_type == 2) {
$column = "sq.question_instruction";
} else if ($search_type == 3) {
$column = "sq.option_1";
} else if ($search_type == 4) {
$column = "sq.option_2";
} else if ($search_type == 5) {
$column = "sq.option_3";
} else if ($search_type == 6) {
$column = "sq.option_4";
} else {
$column = "sq.option_5";
}
# table check
if ($cmbQtype == 1) {
$table = $SP_QUESTION;
} else if ($cmbQtype == 2) {
$table = $SP_QUESTION_MEDIUM_WISE;
} else {
$table = $SP_QUESTION;
}
if ($search_type == 8) {
$getDataQuery = "SELECT sq.question_id,sq.medium_id,sq.question_statement, sq.option_1, sq.option_2, sq.option_3, sq.option_4, sq.option_5, sq.question_solution, sq.medium_id, sq.status,u.contact_name as add_by,sq.add_date, sq.master_id FROM $table as sq LEFT join $SP_EDITORS as u on u.editor_id=sq.add_by where question_id IN($search_term)";
} else {
$getDataQuery = "SELECT sq.question_id,sq.medium_id,sq.question_statement, sq.option_1, sq.option_2, sq.option_3, sq.option_4, sq.option_5, sq.question_solution, sq.medium_id, sq.status,u.contact_name as add_by, sq.add_date, sq.master_id FROM $table as sq LEFT join $SP_EDITORS as u on u.editor_id=sq.add_by where $column LIKE '%" . $search_term . "%' ";
}
$allData = $conn->query($getDataQuery);
if (!empty($_SESSION['type']) && !empty($_SESSION['term'])) {
?>
<div class="col-md-12">
<div class="panel panel-info">
<div class="panel-heading clearfix">
<h4 class="panel-title">Search Results
</h4>
</div>
<div class="panel-body">
<div class="table-responsive">
<table id="question_search" class="display table" style="width: 100%; cellspacing: 0;">
<thead>
<tr>
<th>Ques Id</th>
<th>Question Statement</th>
<th>Option1</th>
<th>Option2</th>
<th>Option3</th>
<th>Option4</th>
<th>Option5</th>
<th>Add By</th>
<th>Add Date</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
$i = 1;
while ($ql = $allData->fetch_assoc()) {
$mid = $ql['master_id'];
$mTypeQ=$conn->query("select source from $SP_MASTER_CATEGORY where master_id=$mid");
$mdataR = $mTypeQ->fetch_assoc();
$mType = strtolower($mdataR['source']);
include_once 'str_replace_type.php';
$qId = $ql['question_id'];
$question = str_replace('../', $root_link, $ql['question_statement']);
$question = str_replace($spaceArray, $replaceSpaceArray, $question);
$option1 = str_replace('../', $root_link, $ql['option_1']);
$option2 = str_replace('../', $root_link, $ql['option_2']);
$option1 = str_replace($spaceArray, $replaceSpaceArray, $option1);
$option2 = str_replace($spaceArray, $replaceSpaceArray, $option2);
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 = "";
}
$addBy = $ql['add_by'];
$addDate = $ql['add_date'];
if ($cmbQtype == 1) {
$secMed = '2';
} else {
$secMed = $ql['medium_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);
?>
<tr>
<td><?php echo $qId; ?></td>
<td><?php echo strtr($question, $varRep); ?> </td>
<td><?php echo $option1; ?></td>
<td><?php echo $option2; ?></td>
<td><?php echo $option3; ?></td>
<td><?php echo $option4; ?></td>
<td><?php echo $option5; ?></td>
<td><?php echo $addBy; ?></td>
<td><?php echo $addDate; ?></td>
<td>
<a style="padding: 2px;border: 1px solid #12afcb;display: inline-block;" target="_blank" href="nqb_question_edit?action=edit&quesId=<?php echo $qId; ?>&mType=<?php echo $mType; ?>">
<i style="font-size:25px; color:#12AFCB; cursor:pointer;" class="fa fa-edit" title="Edit Question"></i></a>
<a style="padding: 2px;border: 1px solid #12afcb;display: inline-block;" target="_blank" href="<?php echo $ques_view_url . '?qId=' . $qId . '&secMed=' . $secMed; ?>">
<i style="font-size:25px; color:#12AFCB; cursor:pointer;" class="fa fa-eye" title="View Question"></i></a>
</td>
</tr>
<?php $i++;
} ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
<?php } ?>
</div>
</div>
<!----------delete ques modal---------->
<div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
</div>
<div class="modal-body" id="modal_body">
</div>
</div>
</div>
</div>
<?php } ?>
</div>
<div class="page-footer">
<p class="no-s">Graposs Connect ©</p>
</div>
<script>
</script>
<?php
} else {
echo "<script type='text/javascript'>alert('You dont have access to search question');</script>";
echo "<script type='text/javascript'>location.href='/work-sp';</script>";
}
include_once('footer.php');
?>