File: /var/www/content-sp/work-sp/nqb_mock_user_report_question_csc.php
<?php
include_once('nqb_master_section.php');
include_once('csc_config.php');
error_reporting(0);
error_reporting(E_ALL);
ini_set('display_errors', 'On');
$adminId = $editor_id;
$curDate = date('Y-m-d H:i:s');
$toDate = date('Y-m-d');
//check edit permissions
$fileName = str_replace('.php', '', basename($_SERVER['REQUEST_URI'], '?' . $_SERVER['QUERY_STRING']));
if (in_array($fileName, $pageArray)) {
$TT_QUESTION_PROBLEM = 'wp_aat93akkcv_tt_question_problem';
$TT_EXAMS = 'wp_shine_tt_exam_categories';
$pagination_link = 'nqb_mock_user_report_question_csc';
include_once 'pagination.php';
/***remove filter */
if (isset($_REQUEST['remove_filter'])) {
unset($_SESSION['report_subQuery']);
}
/**search **/
if (isset($_REQUEST['search_data'])) {
$es_ondate = $_REQUEST['es_ondate'];
$es_fromdate = $_REQUEST['es_fromdate'];
$es_todate = $_REQUEST['es_todate'];
$subQuery = '';
if ($es_ondate != '') {
$q_date = date('Y-m-d', strtotime($es_ondate));
$subQuery .= "and date(p.report_date)='$q_date'";
}
if ($es_fromdate != '' && $es_todate != '') {
$fromDate = date('Y-m-d', strtotime($es_fromdate));
$toDate = date('Y-m-d', strtotime($es_todate));
$subQuery .= "and (date(p.report_date) BETWEEN '$fromDate' AND '$toDate')";
}
$_SESSION['report_subQuery'] = $subQuery;
}
if (!empty($_SESSION['report_subQuery'])) {
$mergeFilter = $_SESSION['report_subQuery'];
} else {
$mergeFilter = "";
}
// $mergeFilter = "";
$limit = 20;
$pageNo = isset($_GET['pageN']) ? $_GET['pageN'] : 1;
$indexN = ($pageNo - 1) * $limit;
$countQuery = $spConn->query("SELECT count(p.id) as total FROM $TT_QUESTION_PROBLEM as p LEFT JOIN $TT_EXAMS as s on s.exam_category_id=p.subject_id WHERE p.reply='N' $mergeFilter group by p.subject_id");
// $cQuery = $countQuery->fetch_assoc();
$count = mysqli_num_rows($countQuery);
$noOfPages = ceil($count / $limit);
/***master questions */
$getReportedQuestions = "SELECT s.category_name,count(p.id) as rep_ques,p.subject_id FROM $TT_QUESTION_PROBLEM as p LEFT JOIN $TT_EXAMS as s on s.exam_category_id=p.subject_id WHERE p.reply='N' $mergeFilter group by p.subject_id order by rep_ques desc limit $indexN, $limit";
$getWorkData = $spConn->query($getReportedQuestions);
$ifData = mysqli_num_rows($getWorkData);
?>
<style>
table {
font-size: 13px;
}
.loading_image {
display: block;
position: fixed;
z-index: 1000;
top: 0;
left: 0;
height: 100%;
width: 100%;
background: rgba(255, 255, 255, .8) url('/work-sp/assets/images/reload.GIF') 50% 50% no-repeat;
}
.modal-backdrop.in {
opacity: 0.9 !important;
z-index: 9 !important;
}
</style>
<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>
<link href="assets/plugins/select2/css/select2.min.css" rel="stylesheet">
<script src="assets/plugins/select2/js/select2.min.js"></script>
<script type="text/javascript">
var jq = jQuery.noConflict();
jq(document).ready(function() {
jq('#repques_table').dataTable({
"bPaginate": false,
bFilter: false,
"responsive": true
});
jq("#date").datepicker({
changeMonth: true,
changeYear: true,
dateFormat: 'dd-mm-yy'
});
jq("#todate").datepicker({
changeMonth: true,
changeYear: true,
dateFormat: 'dd-mm-yy'
});
jq("#fromdate").datepicker({
changeMonth: true,
changeYear: true,
dateFormat: 'dd-mm-yy'
});
jq('.editors-dropdown').select2();
});
function dataTableLoad() {
jq('#repques_table_list').dataTable({
"bPaginate": false,
bFilter: false,
"responsive": true
});
}
</script>
<div class="row">
<div class="col-md-12">
<div class="panel panel-info">
<div class="panel-heading clearfix">
<h4 class="panel-title">Search Filter</h4>
</div>
<div class="spacer"></div>
<div class="panel-body">
<form class="form-horizontal" method="post" onSubmit="return validateForm();">
<div class="form-group">
<label for="date" class="col-sm-2">On date</label>
<div class="col-sm-4">
<input type="text" class="form-control" name="es_ondate" id="date" placeholder="On Date" value="<?php echo @$es_ondate; ?>">
</div>
</div>
<div class="form-group">
<label for="date" class="col-sm-2">From/To Date</label>
<div class="col-sm-4">
<input type="text" class="form-control" name="es_fromdate" id="fromdate" placeholder="From Date" value="<?php echo @$es_fromdate; ?>">
</div>
<div class="col-sm-4">
<input type="text" class="form-control" name="es_todate" id="todate" placeholder="To Date" value="<?php echo @$es_todate; ?>">
</div>
</div>
<div class="form-group">
<input type="submit" class="btn btn-primary" value="Search" name="search_data">
</div>
</form>
<form class="form-horizontal" method="post">
<div class="form-group">
<input type="submit" class="btn btn-danger" value="Reset Filter" name="remove_filter">
</div>
</form>
</div>
</div>
</div>
<?php //if (!empty($_SESSION['report_subQuery'])) { ?>
<?php if ($ifData > 0) { ?>
<div class="col-md-4">
<div class="panel panel-info">
<div class="panel-heading clearfix">
<h4 class="panel-title">Reported Questions</h4>
</div>
<div class="spacer"></div>
<div class="panel-body">
<div class="table-responsive">
<table id="repques_table" class="table table-hover">
<thead>
<tr>
<th>#</th>
<th>Subject</th>
<th>Open Count</th>
<th>View</th>
</tr>
</thead>
<tbody>
<?php
$i = 1+$indexN;
while ($gwd = $getWorkData->fetch_assoc()) {
?>
<tr id="tr_<?php echo $i; ?>">
<td><?php echo $i; ?></td>
<td><?php echo $gwd['category_name']; ?></td>
<td><?php echo $gwd['rep_ques']; ?></td>
<td style="cursor:pointer;font-size:22px;color:darkslategray;" onclick="viewList('<?php echo $gwd['subject_id']; ?>','<?php echo $i; ?>')">
<span class="glyphicon glyphicon-tasks"></span>
</td>
</tr>
<?php $i++;
} ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
<div class="col-md-8">
<div class="panel panel-info">
<div class="panel-heading clearfix">
<h4 class="panel-title">Reported Questions List</h4>
</div>
<div class="spacer"></div>
<div class="panel-body" id="view_list">
</div>
</div>
</div>
<div class="col-md-12">
<?php echo pagination($limit, $pageNo, $pagination_link . "?pageN=", $count); ?>
</div>
<?php } ?>
</div>
<!-----Reply 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>
<!-----Reply Modal END------>
<div class="page-footer">
<p class="no-s">Graposs Connect ©</p>
</div>
</div><!-- Page Inner -->
<script type="text/javascript">
jQuery.noConflict();
function viewList(sub,tr) {
jQuery("#repques_table").find(".danger").removeClass("danger");
jQuery("#tr_"+tr).addClass("danger");
jQuery("#loading").addClass("loading_image");
var site = "/work-sp/ajax_call/nqb_mock_user_report_question_list_csc.php?sub=" + sub+"&tr_id="+tr;
jQuery.ajax({
url: site,
type: 'POST',
data: 'html',
success: function(data) {
jQuery("#loading").removeClass("loading_image");
document.getElementById("view_list").innerHTML = data;
dataTableLoad();
}
});
}
function ajaxPagination(page) {
jQuery("#loading").addClass("loading_image");
var sub = jQuery("#sub_id").val();
var site = "/work-sp/ajax_call/nqb_mock_user_report_question_list_csc.php?sub=" + sub + "&pageN=" + page;
jQuery.ajax({
url: site,
type: 'POST',
data: 'html',
success: function(data) {
jQuery("#loading").removeClass("loading_image");
document.getElementById("view_list").innerHTML = data;
dataTableLoad();
}
});
}
function reply(id) {
var site = "/work-sp/ajax_call/nqb_mock_user_report_question_reply_csc.php?qid=" + id;
jQuery.ajax({
url: site,
type: 'POST',
data: 'html',
success: function(data) {
document.getElementById("modal_body").innerHTML = data;
}
});
}
jQuery(document).on("click", ".msg1", function() {
var msg1 = 'Dear Aspirant,\nThank you for your feedback on the question. The issue has been noted and resolved. It is our endeavour to provide error free and quality test prep material.\nWe appreciate your continued support.';
var msg2 = 'Dear Aspirant,\nThank you for your feedback on the question. We looked at the question and found no error.\nIt is our endeavour to provide error free and quality test prep material. We appreciate your continued support.\nRegards\nTeam Sarkari Pariksha';
if (this.value == 1) {
var msg = msg1;
} else {
var msg = msg2;
}
jQuery("#rep_comment").val(msg);
})
function replyToreport() {
jQuery("#loading").addClass("loading_image");
var repl_pro_id = jQuery("#repl_pro_id").val();
var repl_user_id = jQuery("#repl_user_id").val();
var repl_q_id = jQuery("#repl_q_id").val();
var repl_head = jQuery("#repl_head").val();
var repl_msg1 = jQuery('input[name="repl_msg1"]:checked').val();
var rep_comment = jQuery("#rep_comment").val();
var repl_solution_type = jQuery("#repl_solution_type").val();
var sub = jQuery("#sub_id").val();
var tr_id = jQuery("#tr_id").val();
var arr = {
"repl_pro_id":repl_pro_id,
"repl_user_id":repl_user_id,
"repl_q_id":repl_q_id,
"repl_head":repl_head,
"repl_msg1":repl_msg1,
"rep_comment":rep_comment,
"repl_solution_type":repl_solution_type
}
jQuery.ajax('/work-sp/ajax_call/nqb_mock_user_report_question_reply_add_csc.php', {
type: 'POST',
data: JSON.stringify(arr),
contentType: 'application/json; charset=utf-8',
dataType: 'json',
success: function (data) {
var status = data.status;
if(status == 1) {
jQuery("#myModal").modal('toggle');
viewList(sub,tr_id);
} else if(status == 0) {
jQuery("#loading").removeClass("loading_image");
jQuery("#myModal").modal('toggle');
} else {
}
},
error: function (jqXhrs, textStatus, errorMessage) { }
});
}
</script>
<?php
} else {
echo "<script type='text/javascript'>alert('You dont have access of this feature');</script>";
echo "<script type='text/javascript'>location.href='/work-sp';</script>";
}
include_once('footer.php');
?>