File: /var/www/content-sp/work-sp/nqb_proofread_access_datewise.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';
$spaceArray = array("&");
$replaceArray = array("and");
$getAssignee = $conn->query("SELECT editor_id, contact_name from $SP_EDITORS where team_id='3' and editor_status='1'");
$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"])) {
$es_ondate = date('Y-m-d',strtotime($_POST["es_ondate"]));
$assignee = $_POST["assignee"];
$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 ($ttype == '1') {
$level_status = 1;
} else {
$level_status = 0;
}
//print_r($_POST);
if ($es_ondate != '') {
$questionIds = $conn->query("SELECT sq.question_id FROM $SP_QUESTION as sq where date(sq.add_date)='$es_ondate' and sq.medium_id='$medium' 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='datewise', 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 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/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("#date").datepicker({
changeMonth: true,
changeYear: true,
dateFormat: 'dd-mm-yy'
});
jq('.editors-dropdown').select2();
});
function validateFrm() {
var medium = document.assForm.medium.value;
var target_medium = document.assForm.target_medium.value;
var assignee = document.assForm.assignee.value;
if (masterN == 'M' && masterL > 1) {
alert("Select Master");
document.assForm.master.focus();
return false;
}
if (subjectN == '' && subjectL > 1) {
alert("Select Subject");
document.assForm.subject.focus();
return false;
}
if (topicN == '' && topicL > 1) {
alert("Select Topic");
document.assForm.topic.focus();
return false;
}
if (sub_topicN == '' && sub_topicL > 1) {
alert("Select SubTopic");
document.assForm.sub_topic.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</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>
<td colspan="2">You can assign maximun 10 topic to a single user.</td>
</tr>
<tr>
<th>Select Add Date*</th>
<td>
<input type="text" class="form-control" name="es_ondate" id="date" placeholder="On Date" value="" autocomplete="off">
</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('#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('TM');
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('TM');
jQuery("#medium_text").html('');
return false;
} else {
var on_date = jQuery("#date").val();
if (on_date == '') {
alert("Please select on date.");
} else {
var loadUrl = "ajax_call/nqb_proofread_medium_datewise_count.php?on_date=" + on_date+ "&med_id=" + med_id + "&t_med_id=" + t_med_id;
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');
?>