File: /var/www/content-sp/work-sp/nqb_question_search_by_id.php
<?php
include_once('nqb_master_section.php');
$SP_MASTER_CATEGORY = 'csp_sp_master_category';
$SP_MASTER_STRUCTURE = 'csp_sp_master_structure';
$SP_MEDIUM = 'csp_sp_medium';
$SP_QUESTION = 'csp_sp_question';
$SP_QUESTION_MEDIUM_WISE = 'csp_sp_question_medium_wise';
$SP_EDITORS = 'csp_editors';
$SP_QUES_HISTORY = 'csp_sp_question_history';
$fileName = str_replace('.php', '', basename($_SERVER['REQUEST_URI'], '?' . $_SERVER['QUERY_STRING']));
//check page permissions
if (in_array($fileName, $pageArray)) {
if (isset($_POST['search_question'])) {
unset($_SESSION['dual_questionID']);
unset($_SESSION['dual_cmbSearchType']);
$question = $_REQUEST['search_term'];
$cmbSearchType = $_REQUEST['cmbSearchType'];
$_SESSION['dual_questionID'] = $question;
$_SESSION['cmbSearchType'] = $cmbSearchType;
}
# qid from url for sp
if (isset($_REQUEST['sp_qid'])) {
unset($_SESSION['dual_questionID']);
unset($_SESSION['dual_cmbSearchType']);
$question = $_REQUEST['sp_qid'];
$cmbSearchType = 'sp';
$_SESSION['dual_questionID'] = $question;
$_SESSION['cmbSearchType'] = $cmbSearchType;
}
# qid from url for cscoly
if (isset($_REQUEST['oly_qid'])) {
unset($_SESSION['dual_questionID']);
unset($_SESSION['dual_cmbSearchType']);
$question = $_REQUEST['oly_qid'];
$cmbSearchType = 'oly';
$_SESSION['dual_questionID'] = $question;
$_SESSION['cmbSearchType'] = $cmbSearchType;
}
if (isset($_SESSION['dual_questionID']) && $_SESSION['dual_questionID'] != '') {
$qId = $_SESSION['dual_questionID'];
$sType = $_SESSION['cmbSearchType'];
if ($sType == 'sp') {
$getDataQuery = "SELECT sq.question_id, sq.status, u.contact_name as add_by,pu.contact_name as pf_by,sq.last_proofread_by, sq.add_date,sq.last_proofread_date, mc.master_name, m.medium_name, mc.source FROM $SP_QUESTION as sq LEFT join $SP_EDITORS as u on u.editor_id=sq.add_by LEFT join $SP_EDITORS as pu on pu.editor_id=sq.last_proofread_by LEFT JOIN $SP_MASTER_CATEGORY as mc on mc.master_id=sq.master_id LEFT JOIN $SP_MEDIUM as m ON m.medium_id=sq.medium_id where sq.question_id='$qId'";
$allData = $conn->query($getDataQuery);
$ques = $allData->fetch_assoc();
} else if ($sType == 'oly') {
$getDataQuery = "SELECT sq.question_id, sq.status, u.contact_name as add_by,pu.contact_name as pf_by,sq.last_proofread_by, sq.add_date,sq.last_proofread_date, mc.master_name, m.medium_name, mc.source FROM $SP_QUESTION as sq LEFT join $SP_EDITORS as u on u.editor_id=sq.add_by LEFT join $SP_EDITORS as pu on pu.editor_id=sq.last_proofread_by LEFT JOIN $SP_MASTER_CATEGORY as mc on mc.master_id=sq.master_id LEFT JOIN $SP_MEDIUM as m ON m.medium_id=sq.medium_id where sq.question_id='$qId'";
$allData = $conn->query($getDataQuery);
$ques = $allData->fetch_assoc();
}
$question_id = $ques['question_id'];
$mType = strtolower($ques['source']);
$getDataQuery2 = "SELECT sq.id, sq.question_id,sq.medium_id, sq.status, u.contact_name as add_by,pu.contact_name as pf_by,sq.last_proofread_by, sq.add_date,sq.last_proofread_date, m.medium_name FROM $SP_QUESTION_MEDIUM_WISE as sq LEFT join $SP_EDITORS as u on u.editor_id=sq.add_by LEFT join $SP_EDITORS as pu on pu.editor_id=sq.last_proofread_by LEFT JOIN $SP_MEDIUM as m ON m.medium_id=sq.medium_id where sq.question_id='$question_id' order by sq.id desc";
$allData2 = $conn->query($getDataQuery2);
}
$ques_edit_url = '/work-sp/nqb_question_edit';
$ques_view_url = '/work-sp/nqb_single_question_view';
$ques_edit_url_trans = '/work-sp/nqb_question_edit_secondary';
$ques_add_url_trans = '/work-sp/nqb_question_add_translated';
?>
<style>
.table {
font-size: 13px;
}
.hrhead {
font-weight: bold;
color: #2196F3;
text-align: center;
}
.fa-edit {
padding: 5px;
color: #4499d4;
width: 25px;
height: 25px;
font-weight: bold;
border: 1px solid #4499d4;
position: relative;
cursor: pointer;
font-size: 16px;
}
.fa-eye {
padding: 5px;
color: #4499d4;
width: 25px;
height: 25px;
font-weight: bold;
border: 1px solid #4499d4;
position: relative;
cursor: pointer;
font-size: 16px;
}
</style>
<div class="row">
<div class="col-md-12">
<div class="panel panel-white">
<div class="panel-heading clearfix">
<h4 class="panel-title">Search Question</font>
</h4>
</div>
<div class="panel-body">
<form class="form-inline" method="post">
<div class="form-group">
<select name="cmbSearchType" id="cmbSearchType" class="form-control">
<option value="sp">Sarkari Pariksha</option>
<option value="oly">CSC-Olympiad</option>
<option value="sp">New Oly question on this server</option>
</select>
</div>
<div class="form-group">
<input type="text" id="search_term" name="search_term" class="form-control search_term" value="<?php echo @$qId; ?>" style="width: 55em;" placeholder="Search By question id" required />
</div>
<button class="btn btn-success" type="submit" name="search_question">Search</button>
</form>
</div>
</div>
</div>
<?php if (isset($_SESSION['dual_questionID']) && $_SESSION['dual_questionID'] != '') { ?>
<?php if ($ques['question_id'] != '') {
$q = $ques['question_id'];
# get question history
$getHistory = $conn->query("SELECT h.id,m.medium_name,h.action,h.action_date,e.contact_name as action_by FROM $SP_QUES_HISTORY as h LEFT JOIN $SP_MEDIUM as m on m.medium_id=h.medium_id LEFT JOIN $SP_EDITORS as e on e.editor_id=h.action_by where h.question_id='$q' order by h.id desc");
$hisExist = mysqli_num_rows($getHistory);
?>
<div class="col-md-4">
<div class="panel panel-info">
<div class="panel-heading clearfix">
<h4 class="panel-title">Primary Language Question Details
<i class="fa fa-info-circle" title="Informations"></i>
</h4>
</div>
<table class="table table-hover">
<tr>
<th>Question Id</th>
<td><?php echo $ques['question_id']; ?></td>
</tr>
<?php if ($sType == 'oly') { ?>
<tr>
<th>Olympiad Question Id</th>
<td><?php echo $qId; ?></td>
</tr>
<?php } ?>
<tr>
<th>Medium</th>
<td><?php echo $ques['medium_name']; ?></td>
</tr>
<tr>
<th>Master</th>
<td><?php echo $ques['master_name']; ?></td>
</tr>
<tr>
<th>Source</th>
<td><?php echo $ques['source']; ?></td>
</tr>
<tr>
<th>Status</th>
<td><?php echo $ques['status']; ?></td>
</tr>
<tr>
<th>Add By</th>
<td><?php echo $ques['add_by']; ?></td>
</tr>
<tr>
<th>Add Date</th>
<td><?php echo $ques['add_date']; ?></td>
</tr>
<tr>
<th>Last ProofRead By</th>
<td><?php echo $ques['last_proofread_by'] != '' ? $ques['pf_by'] : '---'; ?></td>
</tr>
<tr>
<th>Last ProofRead Date</th>
<td><?php echo $ques['last_proofread_by'] != '' ? $ques['last_proofread_date'] : '---'; ?></td>
</tr>
<tr>
<th>Edit Question</th>
<td>
<span class="edit-btn">
<a target="_blank" style="text-decoration: none;" href="<?php echo $ques_edit_url . '?action=edit&quesId=' . $ques['question_id'] . '&mType=' . $mType; ?>"><i class="fa fa-edit"></i></a>
</span>
<span class="edit-btn">
<a target="_blank" style="text-decoration: none;" href="<?php echo $ques_view_url . '?qId=' . $ques['question_id'] . '&secMed=2'; ?>"><i class="fa fa-eye"></i></a>
</span>
</td>
</tr>
</table>
</div>
</div>
<div class="col-md-8">
<div class="panel panel-info">
<div class="panel-heading clearfix">
<h4 class="panel-title">Secondary Language Question Details
<i class="fa fa-info-circle" title="Informations"></i>
</h4>
<span><a style="color: #ffeb3b; float: right;" href="/work-sp/nqb_add_question_secondary?quesId=<?php echo $ques['question_id']; ?>&mType=<?php echo $sType; ?>&role=proofreader" target="_blank">Add Question In Secondary Language</a></span>
</div>
<table class="table table-hover">
<tr>
<th>#N</th>
<th>QuestionId</th>
<th>Ref Id</th>
<th>Medium</th>
<th>Add By</th>
<th>Add Date</th>
<th>Last PFR</th>
<th>Last PFR Date</th>
<th>Action</th>
</tr>
<?php
$i = 1;
while ($ques2 = $allData2->fetch_assoc()) {
?>
<tr>
<th><?php echo $i; ?></th>
<th><?php echo $ques2['question_id']; ?></th>
<th><?php echo $ques2['id']; ?></th>
<td><?php echo $ques2['medium_name']; ?></td>
<td><?php echo $ques2['add_by']; ?></td>
<td><?php echo $ques2['add_date']; ?></td>
<td><?php echo $ques2['last_proofread_by'] != '' ? $ques2['pf_by'] : '---'; ?></td>
<td><?php echo $ques2['last_proofread_by'] != '' ? $ques2['last_proofread_date'] : '---'; ?></td>
<td>
<span class="edit-btn">
<a target="_blank" style="text-decoration: none;" href="<?php echo $ques_edit_url_trans . '?action=edit&quesId=' . $ques2['id'] . '&mType=' . $mType; ?>"><i class="fa fa-edit"></i></a>
</span>
<span class="edit-btn">
<a target="_blank" style="text-decoration: none;" href="<?php echo $ques_view_url . '?qId=' . $ques['question_id'] . '&secMed=' . $ques2['medium_id']; ?>"><i class="fa fa-eye"></i></a>
</span>
</td>
</tr>
<?php $i++;
} ?>
</table>
</div>
</div>
<?php if ($hisExist != '0') { ?>
<div class="col-md-12">
<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">
<thead>
<tr>
<th>#</th>
<th>Medium</th>
<th>Action</th>
<th>ActionBy</th>
<th>On Date</th>
</tr>
</thead>
<tbody>
<?php foreach ($getHistory as $h) {
$action = $h['action'];
if ($action == '2' || $action == '0') {
$whatAction = 'Add';
} else if ($action == '3') {
$whatAction = 'Proof Read';
} else if ($action == '4') {
$whatAction = 'Proofread & active';
}
?>
<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['action_by']; ?></td>
<td><?php echo $h['action_date']; ?></td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
</div>
<?php } ?>
<?php } else {
echo "No question with this id found";
} ?>
<?php } ?>
</div>
</div><!-- Main Wrapper -->
<div class="page-footer">
<p class="no-s">Graposs Connect ©</p>
</div>
</div><!-- Page Inner -->
<?php
} else {
echo "<script>alert('You dont have access for this page');</script>";
echo "<script type='text/javascript'>location.href='/work-sp';</script>";
}
include_once('footer.php');
?>