File: /var/www/content-sp/work-sp/new_nqb_proofread_exam_wise_oly.php
<?php
include_once('nqb_master_section_oly.php');
error_reporting(0);
error_reporting(E_ALL);
ini_set('display_errors', 'On');
//check edit permissions
$fileName = 'nqb_proofread_exam_wise_oly';
if (in_array($fileName, $pageArray)) {
$adminId = $editor_id;
$curDate = date('Y-m-d H:i:s');
$SP_EXAM_QUESTION_LINKAGE = 'shineoly_2022.wp_shine_sp_exam_question_linkage';
$SP_MASTER_CATEGORY = 'csp_sp_master_category';
$SP_MASTER_STRUCTURE = 'csp_sp_master_structure';
$SP_MEDIUM = 'csp_sp_medium';
$SP_QUESTION = 'contentserver_202130.csp_sp_question';
$SP_QUESTION_MEDIUM_WISE = 'contentserver_202130.csp_sp_question_medium_wise';
$SP_EDITORS = 'csp_editors';
$SP_MASTER_PROOF_READ_ACCESS = 'csp_proofread_access';
$SP_TEAM_ACCESS = 'csp_team_user_access';
$getAssignee = $conn->query("SELECT editor_id, contact_name from $SP_EDITORS where team_id='3' and editor_status='1' order by contact_name asc");
/**live config */
include_once '../cron/config.php';
$allExam = $live->query("SELECT e.exam_category_id, e.category_name,e.app_status from shineoly_2022.wp_shine_tt_exam_categories as e Inner join shineoly_2022.wp_shine_tt_all_exams as ae on ae.exam_category_id=e.exam_category_id where ae.status='1' order by e.category_name asc");
$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>
<script src="assets/plugins/jquery/jquery-2.1.3.min.js"></script>
<script src="assets/plugins/jquery-ui/jquery-ui.min.js"></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 Olympiad 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="examm" class="select-master">Select Exam</label>
<select name="examm" id="examm">
<option value="E">-Exam-</option>
<?php foreach ($allExam as $exm) { ?>
<option value="<?php echo $exm['exam_category_id']; ?>"><?php echo $exm['category_name']; ?></option>
<?php } ?>
</select>
</div>
<div class="col-md-6 col-sm-6 col-xs-12">
<label for="subject">Select Subject</label>
<select name="subject" id="subject">
<option value="S">-Subject-</option>
</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>
<script type="text/javascript">
jQuery.noConflict();
jQuery(document).ready(function() {
jQuery('#examm').on('change', function() {
var exam_id = jQuery("#examm").val();
var loadUrl = "ajax_call/nqb_cscoly_topics.php?exam_id=" + exam_id + "&type=S";
var jqxhr = jQuery.get(loadUrl);
jqxhr.success(function(data) {
jQuery("#subject").html(data);
jQuery("#sub_topic").empty();
});
});
jQuery('#subject').on('change', function() {
var med_id = jQuery("#medium").val();
var t_med_id = jQuery("#target_medium").val();
if (med_id != 'MD' && t_med_id != 'TM') {
var sub_id = jQuery("#subject").val();
var loadUrl = "ajax_call/new_nqb_proofread_exam_wise_topics_view.php?eid=" + sub_id;
var jqxhr = jQuery.get(loadUrl);
jqxhr.success(function(data) {
jQuery("#sub_topic").html(data);
jQuery("#show_topic_name").html(jQuery("#subject 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() {
var med_id = jQuery("#medium").val();
var t_med_id = jQuery("#target_medium").val();
var sub_id = jQuery("#subject").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_exam_wise_topics_view.php?eid=" + sub_id;
var jqxhr = jQuery.get(loadUrl);
jqxhr.success(function(data) {
jQuery("#sub_topic").html(data);
jQuery("#show_topic_name").html(jQuery("#subject option:selected").text());
enableSelect2();
});
}
});
jQuery(document).on('click', '.sub-topics-id', function() {
var sub_tpc_id = this.id.substr(7);
if (jQuery("#fromid-" + sub_tpc_id).is(':checked')) {
var med_id = jQuery("#medium").val();
var t_med_id = jQuery("#target_medium").val();
var exam_id = jQuery("#examm").val();
jQuery("#ques-data-" + sub_tpc_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 (exam_id == 'E') {
alert("Please select subject");
} else if (med_id == t_med_id) {
alert("source and target medium can not be same");
} else {
var loadUrl = "ajax_call/nqb_oly_exam_wise_trns_prf_ques.php?med_id=" + med_id + "&t_med_id=" + t_med_id + "&exm_id=" + exam_id + "&tpc_id=" + sub_tpc_id;
var jqxhr = jQuery.get(loadUrl);
jqxhr.success(function(data) {
jQuery("#ques-data-" + sub_tpc_id).html(data);
jQuery("#btnshow-"+sub_tpc_id).show();
});
}
}
})
/**assign button */
jQuery(document).on('click', '.assign-submit', function() {
var btn_id = this.id.substr(4);
var assign_s_id = jQuery("#fromid-" + btn_id).val();
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 master = jQuery("#examm").val();
var subject = jQuery("#subject").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 = {
"assign_s_id": '0',
"qtyp_proof": qtyp_proof,
"qtyp_nproof": qtyp_nproof,
"ttype": ttype,
"limit_ques": limit_ques,
"assignee": assignee,
"master": master,
"subject": subject,
"topic": assign_s_id,
"medium": medium,
"target_medium": target_medium,
"master_type": "oly",
"assign_type": "exam",
}
jQuery.ajax({
type: "POST",
url: "ajax_call/new_nqb_exam_wise_oly_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');
?>