File: /var/www/content-sp/work-sp/nqb_questions_add_report_translated1.php
<?php
include_once('nqb_report_section1.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']));
$qtype = '';
if (in_array($fileName, $pageArray)) {
$adminId = $editor_id;
$curDate = date('Y-m-d');
$SP_MEDIUM = 'csp_sp_medium';
$SP_EDITORS = 'csp_editors';
$SP_QUESTION = 'csp_sp_question';
$SP_QUES_HISTORY = 'csp_sp_question_history';
$SP_QUESTION_MEDIUM_WISE = 'csp_sp_question_medium_wise';
$SP_MEDIUM = 'csp_sp_medium';
$SP_MASTER_CATEGORY = 'csp_sp_master_category';
$SP_MASTER_STRUCTURE = 'csp_sp_master_structure';
//editors
$editors = $conn->query("SELECT editor_id,contact_name FROM $SP_EDITORS where team_id='3' and editor_status='1' order by contact_name");
/***remove filter */
if (isset($_REQUEST['remove_filter'])) {
unset($_SESSION['addt_subQuery']);
}
$qtype = '';
/**search */
if (isset($_REQUEST['search_data'])) {
$es_editor = $_REQUEST['es_editor'];
$es_ondate = $_REQUEST['es_ondate'];
$es_fromdate = $_REQUEST['es_fromdate'];
$es_todate = $_REQUEST['es_todate'];
$subQuery = '';
if ($es_editor != '') {
$subQuery .= "and sqm.add_by='$es_editor' ";
}
if ($es_ondate != '') {
$q_date = date('Y-m-d', strtotime($es_ondate));
$subQuery .= "and date(sqm.add_date)='$q_date'";
}
if ($es_fromdate != '' && $es_todate != '') {
$fromDate = date('Y-m-d', strtotime($es_fromdate));
$toDate = date('Y-m-d', strtotime($es_todate));
$subQuery .= "and (date(sqm.add_date) BETWEEN '$fromDate' AND '$toDate')";
}
$_SESSION['addt_subQuery'] = $subQuery;
}
if (!empty($_SESSION['addt_subQuery'])) {
$mergeFilter = $_SESSION['addt_subQuery'];
} else {
$mergeFilter = "and date(sqm.add_date)='$curDate'";
}
$getAddData = "SELECT sqm.question_id,sqm.add_date,m.medium_name,ed.contact_name FROM $SP_QUESTION_MEDIUM_WISE as sqm LEFT JOIN $SP_MEDIUM as m on m.medium_id=sqm.medium_id LEFT JOIN $SP_EDITORS as ed on ed.editor_id=sqm.add_by WHERE sqm.question_id !='' $mergeFilter";
$getWorkData = $conn->query($getAddData);
$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, ed.contact_name, sqm.add_by 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 LEFT JOIN $SP_EDITORS as ed on editor_id=sqm.add_by where sqm.question_id!='' $mergeFilter group by sq.master_id, sq.subject_id, sqm.medium_id, sqm.add_by order by m.master_name, ms.category_name";
$mDataAS = $conn->query($questionAddS);
//$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, ed.contact_name, sqm.add_by 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 LEFT JOIN $SP_EDITORS as ed on editor_id=sqm.add_by where sqm.question_id!='' and sq.status!='4' and sqm.medium_id NOT IN(1,2) $mergeFilter group by sq.master_id, sq.subject_id, sqm.medium_id order by m.master_name, ms.category_name";
?>
<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/datatables/css/jquery.datatables.min.css" rel="stylesheet">
<link href="assets/plugins/datatables/css/responsive.datatables.min.css" rel="stylesheet">
<script src="assets/plugins/datatables/js/jquery.datatables.min.js"></script>
<script src="assets/plugins/datatables/js/jquery.datatables.js"></script>
<script src="assets/plugins/datatables/js/datatables.responsive.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('#assign_table').dataTable({
"bPaginate": true,
bFilter: true,
"responsive": true,
"iDisplayLength": 100,
});
jq("#date").datepicker({
changeMonth: true,
changeYear: true,
dateFormat: 'dd-mm-yy'
});
jq("#todate").datepicker({
changeMonth: true,
changeYear: true,
dateFormat: 'dd-mm-yy'
});
jq("#fromdate").datepicker({
changeMonth: true,
changeYear: true,
dateFormat: 'dd-mm-yy'
});
jq('.editors-dropdown').select2();
});
</script>
<div class="row">
<div class="col-md-12">
<div class="panel panel-info">
<div class="panel-heading clearfix">
<h4 class="panel-title">Search Filter</h4>
</div>
<div class="spacer"></div>
<div class="panel-body">
<form class="form-horizontal" method="post" onSubmit="return validateForm();">
<div class="form-group">
<label for="editor" class="col-sm-2">Select Editor</label>
<div class="col-sm-10">
<select name="es_editor" class="form-control editors-dropdown" id="editor">
<option value="">--Editors--</option>
<?php while ($ms = $editors->fetch_assoc()) { ?>
<option value="<?php echo $ms['editor_id']; ?>" <?php if (@$es_editor == $ms['editor_id']) {
echo "selected";
} ?>><?php echo $ms['editor_id'] . '|' . $ms['contact_name']; ?></option>
<?php } ?>
</select>
</div>
</div>
<div class="form-group">
<label for="date" class="col-sm-2">On Date</label>
<div class="col-sm-4">
<input type="text" class="form-control" name="es_ondate" id="date" value="<?php echo @$es_ondate ?>" placeholder="On Date">
</div>
</div>
<div class="form-group">
<label for="date" class="col-sm-2">From/To Date</label>
<div class="col-sm-4">
<input type="text" class="form-control" name="es_fromdate" id="fromdate" value="<?php echo @$es_fromdate ?>" placeholder="From Date">
</div>
<div class="col-sm-4">
<input type="text" class="form-control" name="es_todate" id="todate" value="<?php echo @$es_todate ?>" placeholder="To Date">
</div>
</div>
<div class="form-group">
<input type="submit" class="btn btn-primary" value="Search" name="search_data">
</div>
</form>
<form class="form-horizontal" method="post">
<div class="form-group">
<input type="submit" class="btn btn-danger" value="Reset Filter" name="remove_filter">
</div>
</form>
</div>
</div>
</div>
<div class="col-md-12">
<div class="panel panel-info">
<div class="panel-heading clearfix">
<h4 class="panel-title">Questions Add Data (Translated)</h4>
</div>
<div class="spacer"></div>
<div class="panel-body">
<div class="table-responsive">
<table id="assign_table" class="display table" style="width: 100%; cellspacing: 0;">
<thead>
<tr>
<th>#</th>
<th>Master</th>
<th>Subject</th>
<th>Medium</th>
<th>Editor</th>
<th>Count</th>
</tr>
</thead>
<tbody>
<?php
$i = 1;
$totalAdSec = 0;
while ($adSec = $mDataAS->fetch_assoc()) {
$totalAdSec = $totalAdSec + $adSec['totaladS'];
$source = $adSec['source'] != '' ? strtolower($adSec['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><?php echo $adSec['contact_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; ?>&editor=<?php echo $adSec['add_by']; ?>&qtype=<?php echo $qtype; ?>"><?php echo $adSec['totaladS']; ?></a></td>
</tr>
<?php $i++;
} ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
<div class="page-footer">
<p class="no-s">Graposs Connect ©</p>
</div>
</div>
<?php
} else {
echo "<script type='text/javascript'>alert('You dont have access to view this report');</script>";
echo "<script type='text/javascript'>location.href='/work-sp';</script>";
}
include_once('footer.php');
?>