File: /var/www/content-sp/work-sp/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 = str_replace('.php', '', basename($_SERVER['REQUEST_URI'], '?' . $_SERVER['QUERY_STRING']));
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 ");
$getAssignee = $conn->query("SELECT editor_id, contact_name from $SP_EDITORS where team_id='3' and editor_status='1' order by contact_name asc");
$getExamShift = $conn->query("SELECT exam_shift FROM $SP_QUESTION where exam_shift IS NOT NULL group by exam_shift");
$allExmQuery = "SELECT pe.id, pe.exam_name from $TT_PREVIOUS_EXAM_TABLE as pe order by pe.exam_name asc";
$allExmData = $conn->query($allExmQuery);
$allMedium = $conn->query("SELECT medium_id, medium_name from $SP_MEDIUM order by medium_id");
$tarMedium = $conn->query("SELECT medium_id, medium_name from $SP_MEDIUM order by medium_id");
if (isset($_POST["submit"])) {
$submit_replaceArray = array(" & ");
$submit_spaceArray = array(" and ");
$prev_exam = $_POST["prev_exam"];
$preExam = str_replace($submit_spaceArray, $submit_replaceArray, $prev_exam);
$prev_year = $_POST["prev_year"];
$assignee = $_POST["assignee"];
$any_shift = str_replace($submit_spaceArray, $submit_replaceArray,$_REQUEST['any_shift']);
$medium = $_POST["medium"];
$target_medium = $_POST["target_medium"];
$qtyp_proof = $_POST["qtyp_proof"];
$qtyp_nproof = @$_POST["qtyp_nproof"];
$ttype = $_POST["ttype"];
$limit_ques = $_POST['limit_ques'];
if ($limit_ques == '') {
$limit = '50';
} else {
$limit = $limit_ques;
}
if ($qtyp_proof != '' && $qtyp_nproof != '') {
$showQuesType = $qtyp_proof . "," . $qtyp_nproof;
} else if ($qtyp_proof != '' && $qtyp_nproof == '') {
$showQuesType = $qtyp_proof;
} else if ($qtyp_proof == '' && $qtyp_nproof != '') {
$showQuesType = $qtyp_nproof;
} else {
$showQuesType = $qtyp_proof;
}
if ($any_shift != '') {
$qryShift = "and sq.exam_shift='$any_shift'";
} else {
$qryShift = "and sq.exam_shift=''";
}
if ($ttype == '1') {
$level_status = 1;
} else {
$level_status = 0;
}
//print_r($_POST);
if ($prev_exam != '') {
//echo "SELECT sq.question_id FROM $SP_QUESTION as sq where sq.previous_exam_name='$preExam' and sq.previous_exam_year='$prev_year' and sq.medium_id='$medium' $qryShift and sq.status IN($showQuesType) limit $limit";
$questionIds = $conn->query("SELECT sq.question_id FROM $SP_QUESTION as sq where sq.previous_exam_name='$preExam' and sq.previous_exam_year='$prev_year' and sq.medium_id='$medium' $qryShift and sq.status IN($showQuesType) limit $limit");
} else {
$questionIds = array();
}
$ques_ids = array();
while ($q_arr = $questionIds->fetch_assoc()) {
$ques_ids[] = $q_arr['question_id'];
}
$makeCommaQues = implode(",", $ques_ids);
if ($makeCommaQues != '') {
// $checkAccess = $conn->query("SELECT count(id) as total from $SP_MASTER_PROOF_READ_ACCESS where assign_to='$assignee' and status IN('0', '1')");
// $cA = $checkAccess->fetch_assoc();
$checkProofReader = $conn->query("SELECT count(id) as total from $SP_TEAM_ACCESS where editor_id='$assignee' and work_id='8'");
$cpf = $checkProofReader->fetch_assoc();
if ($cpf['total'] == 0) {
$conn->query("INSERT into $SP_TEAM_ACCESS set editor_id='$assignee', team_id='3', work_id='8', status='1', added_date='$curDate'");
}
//23912
// if ($cA['total'] < 11) {
$insertQuery = "INSERT into $SP_MASTER_PROOF_READ_ACCESS set master_type='sp',master_id='0', subject_id='0', topic_id='0', sub_topic_id='0', medium_id='$medium', target_medium='$target_medium', ques_type='$showQuesType', assign_type='previous', assign_to='$assignee', level_status='$level_status', status='1', assign_by='$adminId', assign_date='$curDate', questions='$makeCommaQues', limit_ques='$limit_ques'";
if ($conn->query($insertQuery)) {
$msg = '<font style="color:green;">Success: Assigned successfully</font>';
} else {
$msg = '<font style="color:red;">Error: Topic already assigned</font>';
}
// } else {
// $msg = '<font style="color:red;">Error: You can not assign more then 10 topic to a single user</font>';
// }
} else {
$msg = '<font style="color:red;">Error: Not have questions</font>';
}
}
?>
<style>
.form-group select {
height: 34px;
}
.modal-backdrop {
z-index: 999 !important;
}
.radio_ans {
top: -2px;
left: 11px;
height: 15px !important;
width: 25px !important;
background-color: #eee !important;
border-radius: 50%;
position: relative !important;
opacity: 1 !important;
}
select.form-control {
width: 15em !important;
}
table.dataTable {
font-size: 13px;
}
.delWork {
color: red;
font-size: 15px;
cursor: pointer;
margin-left: 4px;
}
.tddd {
cursor: pointer;
}
</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();
jq(document).ready(function() {
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>
<script type="text/javascript">
function validateFrm() {
var prev_exam = document.assForm.prev_exam.value;
var medium = document.assForm.medium.value;
var target_medium = document.assForm.target_medium.value;
var assignee = document.assForm.assignee.value;
if (prev_exam == 'M') {
alert("Select Exam");
document.assForm.prev_exam.focus();
return false;
}
if (medium == 'MD') {
alert("Select Medium");
document.assForm.medium.focus();
return false;
}
if (target_medium == 'TM') {
alert("Select Target Medium");
document.assForm.target_medium.focus();
return false;
}
if (assignee == 'AS') {
alert("Select Assignee");
document.assForm.assignee.focus();
return false;
}
return true;
}
</script>
<?php
?>
<div class="row">
<div class="col-md-6">
<div class="panel panel-info">
<div class="panel-heading clearfix">
<h4 class="panel-title">Assign Topic To Proof Read
<a href="new_<?php echo $fileName; ?>" target="_blank" rel="noopener noreferrer" style="margin: -8px 0px 0px 0px;" class="btn btn-danger btn-rounded">New Form for assign</a>
</h4>
</div>
<form class="form-inline" name="assForm" method="post" onsubmit="return validateFrm();">
<?php if (isset($msg)) echo $msg; ?>
<table class="table table-hover">
<tr>
<th>Select Previous Exam*</th>
<td>
<select name="prev_exam" class="form-control" 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>
</td>
</tr>
<tr>
<th>Select Year*</th>
<td>
<select name="prev_year" class="form-control" id="prev_year">
<option value="">-Year-</option>
<?php
for ($pyear = 2000; $pyear < date('Y'); $pyear++) {
?>
<option value="<?php echo $pyear ?>"><?php echo $pyear ?></option>
<?php } ?>
</select>
</td>
</tr>
<tr>
<th>Exam Shift</th>
<td>
<select name="any_shift" class="form-control editors-dropdown" id="any_shift">
<option value="">-Any Exam Shift-</option>
<?php
foreach ($getExamShift as $e) {
?>
<option value="<?php echo $e['exam_shift']; ?>"><?php echo str_replace($spaceArray, $replaceArray,$e['exam_shift']); ?></option>
<?php } ?>
</select>
</td>
</tr>
<tr>
<th>Source Medium*</th>
<td>
<select name="medium" class="form-control" id="medium">
<option value="MD">-Source Medium-</option>
<?php while ($md = $allMedium->fetch_assoc()) { ?>
<option value="<?php echo $md['medium_id']; ?>"><?php echo $md['medium_name']; ?></option>
<?php } ?>
</select>
</td>
</tr>
<tr>
<th>Target Medium*</th>
<td>
<select name="target_medium" class="form-control" id="target_medium">
<option value="TM">-Target Medium-</option>
<?php while ($md = $tarMedium->fetch_assoc()) { ?>
<option value="<?php echo $md['medium_id']; ?>"><?php echo $md['medium_name']; ?></option>
<?php } ?>
</select>
</td>
</tr>
<tr>
<td colspan="2" id="medium_text"></td>
</tr>
<tr>
<th>Show Ques Type*</th>
<td>
<input type="checkbox" name="qtyp_proof" value="3,4">Proof Read
<input type="checkbox" name="qtyp_nproof" value="1,2">Non Proof Read
</td>
</tr>
<tr>
<th>Type*</th>
<td>
<input type="radio" name="ttype" value="0">Proof Reader
<input type="radio" name="ttype" value="1">Translator
</td>
</tr>
<tr>
<th>Limit</th>
<td><input type="number" name="limit_ques" class="form-control"></td>
</tr>
<tr>
<th>Select Assignee*</th>
<td>
<select name="assignee" class="form-control editors-dropdown" id="assignee">
<option value="AS">-Assignee-</option>
<?php while ($assgn = $getAssignee->fetch_assoc()) { ?>
<option value="<?php echo $assgn['editor_id']; ?>"><?php echo $assgn['contact_name']; ?></option>
<?php } ?>
</select>
</td>
</tr>
<tr>
<td colspan="2">
<button type="submit" class="btn btn-info" name="submit">Submit</button>
</td>
</tr>
</table>
</form>
</div>
</div>
</div>
<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() {
jQuery("#target_medium").val('TM');
jQuery("#medium").val('MD');
jQuery("#medium_text").html('');
});
jQuery('#prev_year').on('change', function() {
jQuery("#target_medium").val('TM');
jQuery("#medium").val('MD');
jQuery("#medium_text").html('');
});
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("#medium_text").html('');
return false;
}
jQuery("#medium_text").html('');
});
jQuery('#target_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_text").html('');
return false;
} else {
var prev_exam = jQuery("#prev_exam").val();
var prev_year = jQuery("#prev_year").val();
var any_shift = jQuery("#any_shift").val();
if (prev_exam == 'M') {
alert("Please select prev.");
} else {
var loadUrl = "ajax_call/nqb_proofread_medium_prev_count.php?prev_exam=" + prev_exam + "&prev_year=" + prev_year + "&med_id=" + med_id + "&t_med_id=" + t_med_id + "&any_shift=" + any_shift;
var jqxhr = jQuery.get(loadUrl);
jqxhr.success(function(data) {
jQuery("#medium_text").html(data);
});
}
}
});
});
</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');
?>