File: /var/www/content-sp/work-sp/master_details.php
<?php
include_once('nqb_master_section.php');
session_start();
$SP_MASTER_CATEGORY = 'csp_sp_master_category';
$SP_MASTER_STRUCTURE = 'csp_sp_master_structure';
$SP_MEDIUM = 'csp_sp_medium';
$SP_QUESTION = 'csp_sp_question';
$SP_QUESTION_MEDIUM_WISE = 'csp_sp_question_medium_wise';
$SP_EDITORS = 'csp_editors';
$SP_QUESTION_STATUS = 'csp_sp_question_status_mode';
$allMaster = $conn->query("SELECT mc.master_id, mc.master_name,mc.source from $SP_MASTER_CATEGORY as mc order by mc.master_id asc");
if (isset($_POST['submit'])) {
unset($_SESSION['masterID']);
$master = $_REQUEST['master'];
$_SESSION['masterID'] = $master;
}
if (isset($_SESSION['masterID']) && $_SESSION['masterID'] != '') {
$mId = $_SESSION['masterID'];
$getMasterDet = $conn->query("SELECT master_id, master_name,source from $SP_MASTER_CATEGORY where master_id='$mId'");
$getMaster = $getMasterDet->fetch_assoc();
$getFlagMaster = $conn->query("SELECT count(q.question_id) as tpq from $SP_QUESTION as q where q.master_id='$mId' and q.question_flag='1'");
$flgCount = $getFlagMaster->fetch_assoc();
$getTotPQry = "SELECT q.medium_id, count(q.question_id) as tpq, m.medium_name from $SP_QUESTION as q LEFT JOIN $SP_MEDIUM as m ON m.medium_id=q.medium_id where q.master_id='$mId' group by q.medium_id order by q.medium_id";
$getTotPdata = $conn->query($getTotPQry);
$getTotSQry = "SELECT sq.medium_id, count(sq.question_id) as tsq, m.medium_name from $SP_QUESTION_MEDIUM_WISE as sq INNER JOIN $SP_QUESTION as q ON q.question_id=sq.question_id LEFT JOIN $SP_MEDIUM as m ON m.medium_id=sq.medium_id where q.master_id='$mId' group by sq.medium_id order by sq.medium_id";
$getTotSdata = $conn->query($getTotSQry);
$getTotSubWiseQ = "SELECT q.subject_id,q.medium_id, q.subject_id, ms.category_name, count(q.question_id) as stpq, count(case when q.status=4 then 1 end) AS proof, count(case when q.status!=4 then 1 end) AS nonproof, m.medium_name from $SP_QUESTION as q LEFT JOIN $SP_MEDIUM as m ON m.medium_id=q.medium_id LEFT JOIN $SP_MASTER_STRUCTURE as ms ON ms.sub_id=q.subject_id where q.master_id='$mId' group by q.subject_id, q.medium_id order by q.subject_id";
$getTotSubWiseD = $conn->query($getTotSubWiseQ);
$getTotSubWiseQS = "SELECT sq.medium_id as sqmmedium, count(sq.question_id) as stsq,count(case when q.status=4 then 1 end) AS proofS, count(case when q.status!=4 then 1 end) AS nonproofS, q.subject_id, ms.category_name, m.medium_name,q.medium_id from $SP_QUESTION_MEDIUM_WISE as sq INNER JOIN $SP_QUESTION as q ON q.question_id=sq.question_id LEFT JOIN $SP_MEDIUM as m ON m.medium_id=sq.medium_id LEFT JOIN $SP_MASTER_STRUCTURE as ms ON ms.sub_id=q.subject_id where q.master_id='$mId' group by q.subject_id, sq.medium_id order by q.subject_id";
$getTotSubWiseDS = $conn->query($getTotSubWiseQS);
$getTotLevelQ = "SELECT q.level_name, count(q.question_id) as ltpq from $SP_QUESTION as q where q.master_id='$mId' group by q.level_name order by q.level_name";
$getTotLevelD = $conn->query($getTotLevelQ);
$getTotTypeQ = "SELECT q.subject_id, q.question_type, ms.category_name, count(q.question_id) as ltpq from $SP_QUESTION as q LEFT JOIN $SP_MASTER_STRUCTURE as ms ON ms.sub_id=q.subject_id where q.master_id='$mId' group by q.subject_id, q.question_type order by q.subject_id";
$getTotTypeD = $conn->query($getTotTypeQ);
}
?>
<style>
.table {
font-size: 13px;
}
.hrhead {
font-weight: bold;
color: #2196F3;
text-align: center;
}
</style>
<div class="row">
<div class="col-md-12">
<div class="panel panel-white">
<div class="panel-heading clearfix">
<h4 class="panel-title">Select Master
</h4>
</div>
<div class="panel-body">
<form class="form-inline" method="post">
<div class="form-group" style="width: 60%;">
<select name="master" class="form-control" id="master" style="width: 100%;">
<option value="">--Master--</option>
<?php while ($ms = $allMaster->fetch_assoc()) { ?>
<option value="<?php echo $ms['master_id']; ?>" <?php if (@$mId == $ms['master_id']) echo "SELECTed"; ?>><?php echo $ms['master_name'] . '-' . $ms['source']; ?></option>
<?php } ?>
</select>
</div>
<input class="btn btn-info" type="submit" value="SELECT Master" name="submit" />
</form>
</div>
</div>
</div>
<div class="col-md-3">
<div class="panel panel-info">
<div class="panel-heading clearfix">
<h4 class="panel-title">Master Details
<i class="fa fa-info-circle" title="Informations"></i>
</h4>
</div>
<table class="table table-hover">
<tr>
<th>Master Id</th>
<td><?php echo $getMaster['master_id']; ?></td>
<th> </th>
</tr>
<tr>
<th>Master Name</th>
<td><?php echo $getMaster['master_name']; ?></td>
<th> </th>
</tr>
<tr>
<th>Question Flagged</th>
<td><?php echo $flgCount['tpq']; ?></td>
<th> </th>
</tr>
<tr>
<th colspan="3" class="hrhead">Primary Table Questions</th>
</tr>
<?php
$p = 1;
while ($pqd = $getTotPdata->fetch_assoc()) {
?>
<tr>
<th><?php echo $p; ?></th>
<th><?php echo $pqd['medium_name']; ?></th>
<td><?php echo $pqd['tpq']; ?></td>
</tr>
<?php $p++;
} ?>
<tr>
<th colspan="3" class="hrhead">Secondary Table Questions</th>
</tr>
<?php
$s = 1;
while ($sqd = $getTotSdata->fetch_assoc()) {
?>
<tr>
<th><?php echo $s; ?></th>
<th><?php echo $sqd['medium_name']; ?></th>
<td><?php echo $sqd['tsq']; ?></td>
</tr>
<?php $s++;
} ?>
</table>
<div class="panel-heading clearfix">
<h4 class="panel-title">Level Wise Questions
<i class="fa fa-info-circle" title="Informations"></i>
</h4>
</div>
<table class="table table-hover">
<tr>
<th>#N</th>
<th>Level</th>
<th>Count</th>
</tr>
<?php
$i = 1;
while ($lq = $getTotLevelD->fetch_assoc()) {
?>
<tr>
<th><?php echo $i; ?></th>
<th><?php echo $lq['level_name']; ?></th>
<td><?php echo $lq['ltpq']; ?></td>
</tr>
<?php $i++;
} ?>
</table>
<div class="panel-heading clearfix">
<h4 class="panel-title">Type Wise Questions
<i class="fa fa-info-circle" title="Informations"></i>
</h4>
</div>
<table class="table table-hover">
<tr>
<th colspan="4"><span style="font-size: 10px; color: brown;">1-questions not available for translation, 0-questions can be translated</span></th>
</tr>
<tr>
<th>#N</th>
<th>Subject</th>
<th>Type</th>
<th>Count</th>
</tr>
<?php
$o = 1;
while ($ltq = $getTotTypeD->fetch_assoc()) {
?>
<tr>
<th><?php echo $o; ?></th>
<th>
<a href="/work-sp/update_question_type_bulk.php?subject_id=<?php echo $ltq['subject_id'] ?>&q_type=<?php echo $ltq['question_type']; ?>" target="_blank" rel="noopener noreferrer" style="color:#4E5E6A;">
<?php echo $ltq['category_name']; ?></a>
</th>
<th><?php echo $ltq['question_type']; ?></th>
<td><?php echo $ltq['ltpq']; ?></td>
</tr>
<?php $o++;
} ?>
</table>
</div>
</div>
<div class="col-md-5">
<div class="panel panel-info">
<div class="panel-heading clearfix">
<h4 class="panel-title">Subject Wise Details (Primary)
<i class="fa fa-info-circle" title="Informations"></i>
</h4>
</div>
<table class="table table-hover">
<tr>
<th>#N</th>
<th>Subject</th>
<th>Medium</th>
<th>Count</th>
<th>Proof</th>
<th>Non Proof</th>
</tr>
<?php
$i = 1;
$j = 0;
$array = array();
while ($spq = $getTotSubWiseD->fetch_assoc()) {
?>
<tr>
<th><?php echo $i; ?></th>
<th>
<a href="/work-sp/nqb_questions_subject_view.php?topic_id=<?php echo $spq['subject_id'] ?>&smedium=<?php echo $spq['medium_id']; ?>&tmedium=2&mType=<?php echo strtolower($getMaster['source']) ?>&showType=p" target="_blank" rel="noopener noreferrer">
<?php echo $spq['category_name']; ?>
</a>
</th>
<th><?php echo $spq['medium_name']; ?></th>
<td><?php echo $spq['stpq']; ?></td>
<td><a href="master_questions_proof_view.php?subject=<?php echo $spq['subject_id']; ?>&medium=<?php echo $spq['medium_id']; ?>&type=proof" target="_blank"><?php echo $spq['proof']; ?></a></td>
<td><a href="master_questions_proof_view.php?subject=<?php echo $spq['subject_id']; ?>&medium=<?php echo $spq['medium_id']; ?>&type=nonproof" target="_blank"><?php echo $spq['nonproof']; ?></a></td>
</tr>
<?php $i++;
} ?>
</table>
</div>
</div>
<div class="col-md-4">
<div class="panel panel-info">
<div class="panel-heading clearfix">
<h4 class="panel-title">Subject Wise Details (Secondary)
<i class="fa fa-info-circle" title="Informations"></i>
</h4>
</div>
<table class="table table-hover">
<tr>
<th>#N</th>
<th>Subject</th>
<th>Medium</th>
<th>Count</th>
<th>Proof</th>
<th>Non Proof</th>
</tr>
<?php
$i = 1;
while ($ssq = $getTotSubWiseDS->fetch_assoc()) {
?>
<tr>
<th><?php echo $i; ?></th>
<th><a href="/work-sp/nqb_questions_subject_view.php?topic_id=<?php echo $ssq['subject_id'] ?>&smedium=<?php echo $ssq['medium_id']; ?>&tmedium=<?php echo $ssq['sqmmedium']; ?>&mType=<?php echo strtolower($getMaster['source']) ?>&showType=s" target="_blank" rel="noopener noreferrer">
<?php echo $ssq['category_name']; ?>
</a></th>
<th><?php echo $ssq['medium_name']; ?></th>
<td><?php echo $ssq['stsq']; ?></td>
<td><?php echo $ssq['proofS']; ?></td>
<td><?php echo $ssq['nonproofS']; ?></td>
</tr>
<?php $i++;
} ?>
</table>
</div>
</div>
</div>
</div><!-- Main Wrapper -->
<div class="page-footer">
<p class="no-s">Graposs Connect ©</p>
</div>
</div><!-- Page Inner -->
<?php
include_once('footer.php');
?>