File: /var/www/content-sp/work-sp/new_nqb_proofread_access_previous.php
<?php
include_once('nqb_proofread_section.php');
// error_reporting(0);
// error_reporting(E_ALL);
// ini_set('display_errors', 'On');
//check edit permissions
$fileName = 'nqb_proofread_access_previous';
if (in_array($fileName, $pageArray)) {
$adminId = $editor_id;
$curDate = date('Y-m-d H:i:s');
$SP_MEDIUM = 'csp_sp_medium';
$SP_QUESTION = 'csp_sp_question';
$SP_EDITORS = 'csp_editors';
$SP_MASTER_PROOF_READ_ACCESS = 'csp_proofread_access';
$SP_TEAM_ACCESS = 'csp_team_user_access';
$TT_PREVIOUS_EXAM_TABLE = 'csp_sp_previous_exam';
$spaceArray = array(" & ");
$replaceArray = array(" and ");
$allExmQuery = "SELECT pe.id, pe.exam_name from $TT_PREVIOUS_EXAM_TABLE as pe order by pe.exam_name";
$allExmData = $conn->query($allExmQuery);
$allMedium = $conn->query("SELECT medium_id, medium_name from $SP_MEDIUM order by medium_id");
?>
<style>
.m-0 {
margin: 0;
}
.proofread-section .form-box {
background: #fff;
padding: 20px;
border: 1px solid #cccccc;
}
.proofread-section .form-box form .select-master {
width: 10%;
}
.proofread-section .form-box form label {
margin: 0;
font-size: 13px;
font-weight: 700;
color: #000;
margin-right: 6px;
}
.proofread-section .form-box form select {
width: 58%;
padding: 8px;
border: 1px solid #cccccc;
font-weight: 600;
font-size: 14px;
color: #000;
margin-bottom: 20px;
}
.proofread-section .form-box form .first-row .form-box-div label {
width: 70%;
margin: 0;
margin-bottom: 10px;
font-size: 13px;
}
.proofread-section .form-box form .form-box-div input {
margin: 0;
}
.proofread-section .form-box form h4 {
margin: 0;
font-size: 14px;
color: #0c0c0c;
padding-bottom: 8px;
}
.proofread-section .form-box form p {
margin: 0;
font-size: 13px;
font-weight: 600;
padding-bottom: 6px;
}
.proofread-section .form-box form p span {
color: #ee3137;
}
.proofread-section .form-box form .sub-topics-div label {
width: 100%;
padding-bottom: 10px;
font-size: 13px;
}
.proofread-section .form-box form .sub-topics-div input {
width: 100%;
padding: 6px;
border: 1px solid #cccccc;
font-weight: 600;
font-size: 14px;
color: #000;
}
.proofread-section .form-box form .sub-topics-div select {
margin: 0;
width: 70%;
padding: 6px;
float: left;
}
.proofread-section .form-box form .sub-topics-div p {
float: left;
line-height: 18px;
margin-top: 8px;
color: #ef3138;
}
.proofread-section .form-box form .first-row {
float: left;
width: 100%;
border-top: 1px solid #d4d4d4;
padding: 20px 0;
border-bottom: 1px solid #d4d4d4
}
.proofread-section .form-box form .first-row div.checker span {
position: relative;
top: -2px;
}
/* .proofread-section .form-box form .first-row label {
width: 80%;
margin: 0;
font-size: 16px;
margin-bottom: 14px;
font-weight: bold;
} */
.proofread-section .form-box form .first-row .sub-topics-div button {
width: 28%;
background: #ef3138;
color: #fff;
border: none;
padding: 10px 0;
font-weight: 600;
float: right;
font-size: 11px;
text-align: center;
}
th, td {
padding: 6px;
text-align: center;
}
</style>
<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();
function enableSelect2() {
jq('.editors-dropdown').select2();
}
</script>
<section class="proofread-section">
<div class="container">
<div class="row">
<div class="col-md-12 col-sm-12 col-xs-12">
<div class="panel panel-info">
<div class="panel-heading clearfix">
<h4 class="panel-title">Assign Topic To Proof Read from Previous Exams</h4>
</div>
</div>
</div>
<div class="col-md-12 col-sm-12 col-xs-12">
<div class="form-box">
<form action="" class="row m-0">
<div class="col-md-12 col-sm-12 col-xs-12">
<label for="master" class="select-master">Select Previous Exam</label>
<select name="prev_exam" id="prev_exam">
<option value="M">-Previous Exams-</option>
<?php while ($cat = $allExmData->fetch_assoc()) { ?>
<option value="<?php echo str_replace($spaceArray, $replaceArray, $cat['exam_name']); ?>"><?php echo $cat['exam_name']; ?></option>
<?php } ?>
</select>
</div>
<div class="col-md-6 col-sm-6 col-xs-12">
<label for="medium">Select Source</label>
<select name="medium" id="medium">
<option value="MD">-Source Medium-</option>
<?php foreach ($allMedium as $md) { ?>
<option value="<?php echo $md['medium_id']; ?>"><?php echo $md['medium_name']; ?></option>
<?php } ?>
</select>
</div>
<div class="col-md-6 col-sm-6 col-xs-12">
<label for="target_medium">Select Target</label>
<select name="target_medium" id="target_medium">
<option value="TM">-Target Medium-</option>
<?php foreach ($allMedium as $md) { ?>
<option value="<?php echo $md['medium_id']; ?>"><?php echo $md['medium_name']; ?></option>
<?php } ?>
</select>
</div>
<section class="first-row" id="sub_topic">
</section>
</form>
</div>
</div>
</div>
</div>
</section>
<div class="page-footer">
<p class="no-s">Graposs Connect ©</p>
</div>
<script type="text/javascript">
jQuery.noConflict();
jQuery(document).ready(function() {
jQuery('#prev_exam').on('change', function() {
var mid = jQuery("#prev_exam").val();
var med_id = jQuery("#medium").val();
var t_med_id = jQuery("#target_medium").val();
if (med_id != 'MD' && t_med_id != 'TM') {
jQuery("#sub_topic").html("<i class='fa fa-spinner fa-spin' style='font-size:50px;padding:10px 0 10px 0;margin-left:50%;'></i>");
var loadUrl = "ajax_call/new_nqb_proofread_access_previous_view.php?eid=" + mid;
var jqxhr = jQuery.get(loadUrl);
jqxhr.success(function(data) {
jQuery("#sub_topic").html(data);
jQuery("#show_topic_name").html(jQuery("#prev_exam option:selected").text());
enableSelect2();
});
}
});
jQuery('#medium').on('change', function() {
var med_id = jQuery("#medium").val();
var t_med_id = jQuery("#target_medium").val();
if (med_id == t_med_id) {
alert("source and target medium can not be same");
jQuery("#target_medium").val('MD');
jQuery("#medium").val('MD');
jQuery("#sub_topic").empty();
return false;
}
jQuery("#sub_topic").empty();
});
jQuery('#target_medium').on('change', function() {
jQuery("#sub_topic").html("<i class='fa fa-spinner fa-spin' style='font-size:50px;padding:10px 0 10px 0;margin-left:50%;'></i>");
var mid = jQuery("#prev_exam").val();
var med_id = jQuery("#medium").val();
var t_med_id = jQuery("#target_medium").val();
if (med_id == t_med_id) {
alert("source and target medium can not be same");
jQuery("#target_medium").val('TM');
return false;
} else if (med_id != 'MD' && t_med_id != 'TM') {
var loadUrl = "ajax_call/new_nqb_proofread_access_previous_view.php?eid=" + mid;
var jqxhr = jQuery.get(loadUrl);
jqxhr.success(function(data) {
jQuery("#sub_topic").html(data);
jQuery("#show_topic_name").html(jQuery("#prev_exam option:selected").text());
enableSelect2();
});
}
});
jQuery(document).on('click', '.sub-topics-id', function() {
var auto_id = this.id.substr(7);
if (jQuery("#fromid-" + auto_id).is(':checked')) {
var med_id = jQuery("#medium").val();
var t_med_id = jQuery("#target_medium").val();
var prev_exam = jQuery("#prev_exam").val();
var prev_year = jQuery("#pre_year_" + auto_id).val();
var any_shift = jQuery("#exam_shift_" + auto_id).val();
jQuery("#ques-data-" + auto_id).html("<i class='fa fa-spinner fa-spin' style='font-size:50px;padding:10px 0 10px 0;margin-left:50%;'></i>");
if (med_id == 'MD') {
alert("Please select source medium.");
} else if (t_med_id == 'TM') {
alert("Please select target medium.");
} else if (med_id == t_med_id) {
alert("source and target medium can not be same");
} else {
var loadUrl = "ajax_call/nqb_proofread_medium_prev_count.php?med_id=" + med_id + "&t_med_id=" + t_med_id + "&prev_exam=" + prev_exam + "&prev_year=" + prev_year + "&any_shift=" + any_shift;
var jqxhr = jQuery.get(loadUrl);
jqxhr.success(function(data) {
jQuery("#ques-data-" + auto_id).html(data);
jQuery("#btnshow-" + auto_id).show();
});
}
}
});
/**assign button */
jQuery(document).on('click', '.assign-submit', function() {
var btn_id = this.id.substr(4);
var qtyp_proof = jQuery("#qtyp_proof-" + btn_id).is(':checked') ? jQuery("#qtyp_proof-" + btn_id).val() : '';
var qtyp_nproof = jQuery("#qtyp_nproof-" + btn_id).is(':checked') ? jQuery("#qtyp_nproof-" + btn_id).val() : '';
var ttype = jQuery("input[name='ttype-" + btn_id + "']").is(':checked') ? jQuery("input[name='ttype-" + btn_id + "']:checked").val() : '';
var limit_ques = jQuery("#limit_ques-" + btn_id).val();
var assignee = jQuery("#assignee-" + btn_id).val();
var prev_exam = jQuery("#prev_exam").val();
var prev_year = jQuery("#pre_year_" + btn_id).val();
var any_shift = jQuery("#exam_shift_" + btn_id).val();
var medium = jQuery("#medium").val();
var target_medium = jQuery("#target_medium").val();
if (assignee == 'AS') {
alert("Please select assignee");
} else if (jQuery("input[name='ttype-" + btn_id + "']").is(':checked') == false) {
alert("Please select assignee role");
} else {
var r = confirm("Are you sure to assign this topic ?");
if (r == true) {
jQuery("#btn-" + btn_id).attr("disabled", "disabled");
var arr = {
"qtyp_proof": qtyp_proof,
"qtyp_nproof": qtyp_nproof,
"ttype": ttype,
"limit_ques": limit_ques,
"assignee": assignee,
"prev_exam": prev_exam,
"prev_year": prev_year,
"any_shift": any_shift,
"medium": medium,
"target_medium": target_medium,
"master_type": "sp",
"assign_type": "previous",
}
jQuery.ajax({
type: "POST",
url: "ajax_call/new_nqb_previous_assign_questions.php",
data: JSON.stringify(arr),
contentType: 'application/json; charset=utf-8',
dataType: 'Json',
success: function(data) {
if (data.status == '1') {
jQuery("#btn-" + btn_id).remove();
jQuery("#btnshow-" + btn_id).html(data.message);
jQuery("#btnshow-" + btn_id).css("color", "green");
} else {
alert(data.message);
}
}
});
} else {
return false;
}
}
});
});
</script>
<?php
} else {
echo "<script type='text/javascript'>alert('You dont have access to assign');</script>";
echo "<script type='text/javascript'>location.href='/work-sp';</script>";
}
include_once('footer.php');
?>