File: /var/www/content-sp/work-sp/nqb_questions_add_combine_report.php
<?php
include_once('nqb_master_section.php');
// ini_set('display_errors', 1);
// ini_set('display_startup_errors', 1);
// error_reporting(E_ALL);
$SP_EDITORS = 'csp_editors';
$SP_QUESTION = 'csp_sp_question';
$SP_QUESTION_MEDIUM_WISE = 'csp_sp_question_medium_wise';
$SP_MEDIUM = 'csp_sp_medium';
$SP_MASTER_STRUCTURE = 'csp_sp_master_structure';
$SP_MASTER_CATEGORY = 'csp_sp_master_category';
$fileName = str_replace('.php', '', basename($_SERVER['REQUEST_URI'], '?' . $_SERVER['QUERY_STRING']));
// $fileName = 'ssc_to_bank_current_affairs';
//$editor_id = 182;
//check master permissions
if (in_array($fileName, $pageArray)) {
$es_ondate = date('Y-m-d');
$subQueryAdd = " and date(sq.add_date)='$es_ondate'";
/**search */
if (isset($_REQUEST['submit'])) {
$es_ondate = $_REQUEST['es_ondate'];
$qtype = $_REQUEST['qtype'];
if ($es_ondate != '' && $qtype == 'add') {
$q_date = date('Y-m-d', strtotime($es_ondate));
$subQueryAdd = " and date(sq.add_date)='$q_date'";
$subQueryAddS = " and date(sqm.add_date)='$q_date'";
# data related to proofread by selected editor
$questionAddP = "SELECT sq.master_id, sq.subject_id, sq.medium_id, sq.add_date as datee, count(sq.question_id) as totalad, m.master_name, m.source, ms.category_name, l.medium_name,ed.contact_name,sq.add_by FROM $SP_QUESTION as sq LEFT JOIN $SP_MASTER_CATEGORY as m ON m.master_id=sq.master_id LEFT JOIN $SP_MASTER_STRUCTURE as ms ON ms.sub_id=sq.subject_id LEFT JOIN $SP_MEDIUM as l on l.medium_id=sq.medium_id LEFT JOIN $SP_EDITORS as ed on editor_id=sq.add_by where sq.question_id!='' and sq.status!='4' $subQueryAdd group by sq.master_id, sq.subject_id, sq.medium_id,sq.add_by order by m.master_name, ms.category_name";
$mDataPf = $conn->query($questionAddP);
$questionAddS = "SELECT sq.master_id, sq.subject_id, sqm.medium_id, sqm.add_date as sdatee, count(sqm.question_id) as totaladS, m.master_name, m.source, ms.category_name, l.medium_name FROM $SP_QUESTION_MEDIUM_WISE as sqm LEFT JOIN $SP_MEDIUM as l on l.medium_id=sqm.medium_id LEFT JOIN $SP_QUESTION as sq on sq.question_id=sqm.question_id LEFT JOIN $SP_MASTER_CATEGORY as m ON m.master_id=sq.master_id LEFT JOIN $SP_MASTER_STRUCTURE as ms ON ms.sub_id=sq.subject_id where sqm.question_id!='' and sq.status!='4' and sqm.medium_id NOT IN(1,2) $subQueryAddS group by sq.master_id, sq.subject_id, sqm.medium_id order by m.master_name, ms.category_name";
$mDataAS = $conn->query($questionAddS);
$textP = "[Primary] Question Add Report Subject Wise";
$textS = "[Secondary] Question Add Report Subject Wise";
} else if ($es_ondate != '' && $qtype == 'proof_read') {
$q_date = date('Y-m-d', strtotime($es_ondate));
$subQueryP = " and date(sq.last_proofread_date)='$q_date'";
$subQueryPrfS = " and date(sqm.last_proofread_date)='$q_date'";
# data related to proofread by selected editor
$questionPfr = "SELECT sq.master_id, sq.subject_id, sq.medium_id, sq.last_proofread_date as datee, count(sq.question_id) as totalad, m.master_name, m.source, ms.category_name, l.medium_name FROM $SP_QUESTION as sq LEFT JOIN $SP_MASTER_CATEGORY as m ON m.master_id=sq.master_id LEFT JOIN $SP_MASTER_STRUCTURE as ms ON ms.sub_id=sq.subject_id LEFT JOIN $SP_MEDIUM as l on l.medium_id=sq.medium_id where sq.question_id!='' and sq.last_proofread_by='$editor_id' $subQueryP group by sq.master_id, sq.subject_id, sq.medium_id order by m.master_name, ms.category_name";
$mDataPf = $conn->query($questionPfr);
$questionPrfS = "SELECT sq.master_id, sq.subject_id, sqm.medium_id, sqm.last_proofread_date as sdatee, count(sqm.question_id) as totaladS, m.master_name, m.source, ms.category_name, l.medium_name FROM $SP_QUESTION_MEDIUM_WISE as sqm LEFT JOIN $SP_MEDIUM as l on l.medium_id=sqm.medium_id LEFT JOIN $SP_QUESTION as sq on sq.question_id=sqm.question_id LEFT JOIN $SP_MASTER_CATEGORY as m ON m.master_id=sq.master_id LEFT JOIN $SP_MASTER_STRUCTURE as ms ON ms.sub_id=sq.subject_id where sqm.question_id!='' and sqm.last_proofread_by='$editor_id' and sq.status='4' $subQueryPrfS group by sq.master_id, sq.subject_id, sqm.medium_id order by m.master_name, ms.category_name";
$mDataAS = $conn->query($questionPrfS);
$textP = "[Primary] Question Proof Ready By You";
}
}
//echo "<br>";
# data related to proofread by selected editor in secondary medium
// $questionPfrS = "SELECT sqm.last_proofread_date, e.editor_id, sqm.last_proofread_by, e.contact_name, m.medium_name, count(sqm.question_id) as totalspf FROM $SP_QUESTION_MEDIUM_WISE as sqm LEFT JOIN $SP_EDITORS as e ON e.editor_id=sqm.last_proofread_by LEFT JOIN $SP_MEDIUM as m on m.medium_id=sqm.medium_id where sqm.question_id!='' $subQuery1 group by cast(sqm.last_proofread_date as date), sqm.last_proofread_by, sqm.medium_id order by count(sqm.question_id) desc";
// $mDataPfS = $conn->query($questionPfrS);
// $ifPfSData = mysqli_num_rows($mDataPfS);
?>
<style>
.table {
font-size: 13px;
}
.hrhead {
font-weight: bold;
color: #2196F3;
text-align: center;
}
div.radio:nth-child(2) {
margin-left: 17px;
}
</style>
<div class="row">
<div class="col-md-12">
<div class="panel panel-white">
<div class="panel-heading clearfix">
<h4 class="panel-title">Select Type and Date
</h4>
</div>
<div class="panel-body">
<form class="form-inline" method="post">
<div class="form-group">
<div class="col-md-6" style="margin-top: 8px;">
<input type="radio" name="qtype" value="add" checked="true">Add
<input type="radio" name="qtype" value="proof_read" style="margin-left: 20px;">Proof Read
</div>
<div class="col-md-6">
<input type="text" class="form-control" name="es_ondate" id="date" placeholder="On Date" value="<?php echo @$es_ondate; ?>" autocomplete="off">
</div>
</div>
<input class="btn btn-info" type="submit" value="Search" name="submit" />
</form>
</div>
</div>
</div>
<?php if (isset($_REQUEST['submit'])) { ?>
<div class="col-md-6">
<div class="panel panel-info">
<div class="panel-heading clearfix">
<h4 class="panel-title"><?php echo $textP; ?>
<i class="fa fa-info-circle" title="Informations"></i>
</h4>
</div>
<table class="table table-hover" id="primetable1">
<tr>
<th>#</th>
<th>Master</th>
<th>Subject</th>
<th>Medium</th>
<th>Editor</th>
<th>Count</th>
</tr>
<?php
$i = 1;
$totalq = 0;
while ($pf = $mDataPf->fetch_assoc()) {
$totalq = $totalq + $pf['totalad'];
$source = $pf['source']!='' ? strtolower($pf['source']) : 'sp';
?>
<tr>
<td><?php echo $i; ?></td>
<td><?php echo $pf['master_name']; ?></td>
<td><?php echo $pf['category_name']; ?></td>
<td><?php echo $pf['medium_name']; ?></td>
<td><?php echo $pf['contact_name']; ?></td>
<td><a target='_blank' href="nqb_questions_add_combine_report_user_view.php?subject_id=<?php echo $pf['subject_id']; ?>&date=<?php echo date('Y-m-d', strtotime($pf['datee'])); ?>&medium_id=<?php echo $pf['medium_id']; ?>&t_type=primary&mType=<?php echo $source; ?>&qtype=<?php echo $qtype; ?>&editor=<?php echo $pf['add_by']; ?>"><?php echo $pf['totalad']; ?></a></td>
</tr>
<?php $i++;
} ?>
<tr>
<td colspan="4">Total</td>
<td><?php echo $totalq; ?></td>
</tr>
</table>
</div>
</div>
<div class="col-md-6">
<div class="panel panel-info">
<div class="panel-heading clearfix">
<h4 class="panel-title"><?php echo $textS; ?>
<i class="fa fa-info-circle" title="Informations"></i>
</h4>
</div>
<table class="table table-hover">
<tr>
<th>#</th>
<th>Master</th>
<th>Subject</th>
<th>Medium</th>
<th>Count</th>
</tr>
<?php
$i = 1;
$totalAdSec = 0;
while ($adSec = $mDataAS->fetch_assoc()) {
$totalAdSec = $totalAdSec + $adSec['totaladS'];
$source = $pf['source']!='' ? strtolower($pf['source']) : 'sp';
?>
<tr>
<td><?php echo $i; ?></td>
<td><?php echo $adSec['master_name']; ?></td>
<td><?php echo $adSec['category_name']; ?></td>
<td><?php echo $adSec['medium_name']; ?></td>
<td><a target='_blank' href="nqb_questions_add_combine_report_user_view.php?subject_id=<?php echo $adSec['subject_id']; ?>&date=<?php echo date('Y-m-d', strtotime($adSec['sdatee'])); ?>&medium_id=<?php echo $adSec['medium_id']; ?>&t_type=secondary&mType=<?php echo $source; ?>&qtype=<?php echo $qtype; ?>"><?php echo $adSec['totaladS']; ?></a></td>
</tr>
<?php $i++;
} ?>
<tr>
<td colspan="4">Total</td>
<td><?php echo $totalAdSec; ?></td>
</tr>
</table>
</div>
</div>
<?php } ?>
</div>
</div><!-- Main Wrapper -->
<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>
<script type="text/javascript">
var jq = jQuery.noConflict();
jq(document).ready(function() {
jq("#date").datepicker({
changeMonth: true,
changeYear: true,
dateFormat: 'yy-mm-dd'
});
});
$(function () {
var tableRows = $("#primetable1 tr:not(:has(th))");
var tds = $(this).find('td');
var i=0;
tableRows.each(function () {
console.log(tableRows[0]);
var roww1 = $(tableRows[i]).find('td').eq(1).html();
var roww2 = $(tableRows[i+1]).find('td').eq(1).html();
if(roww1!=roww2){
$(tableRows[i+1]).css('border-top', '2px solid #b2e6ff');
} else {
$(tableRows[i+1]).css('border-top', 'none');
}
i++;
});
});
</script>
<div class="page-footer">
<p class="no-s">Graposs Connect ©</p>
</div>
</div><!-- Page Inner -->
<?php
include_once('footer.php');
} else {
echo "<script>alert('You dont have access for transfer');</script>";
echo "<script type='text/javascript'>location.href='/work-sp';</script>";
}
?>