<?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 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, 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";
	$getTotSubWiseQ = "SELECT q.subject_id, q.medium_id, q.subject_id, ms.category_name, count(q.question_id) as stpq, 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' and q.question_type='0' and q.question_id NOT IN(select question_id from $SP_QUESTION_MEDIUM_WISE where (case when q.medium_id=1 then medium_id=2 when q.medium_id=2 then medium_id=1 end)) group by q.subject_id, q.medium_id order by q.subject_id";
	$getTotSubWiseD = $conn->query($getTotSubWiseQ);
}

?>
<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['source'] . '-' . $ms['master_name']; ?></option>
							<?php } ?>
						</select>
					</div>
					<input class="btn btn-info" type="submit" value="SELECT Master" name="submit" />
				</form>
			</div>
		</div>
	</div>


	<div class="col-md-4">
		<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>&nbsp;</th>
				</tr>
				<tr>
					<th>Master Name</th>
					<td><?php echo @$getMaster['master_name']; ?></td>
					<th>&nbsp;</th>
				</tr>
				<tr>
					<th>Question Flagged</th>
					<td><?php echo $flgCount['tpq']; ?></td>
					<th>&nbsp;</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>
	</div>


	<div class="col-md-4">
		<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>
				</tr>
				<?php
				$i = 1;
				$j = 0;
				$array = array();
				while ($spq = $getTotSubWiseD->fetch_assoc()) {
					if ($spq['medium_id'] == 1) {
						$tmedium = 2;
					} else if ($spq['medium_id'] == 2) {
						$tmedium = 1;
					}

				?>
					<tr>
						<th><?php echo $i; ?></th>
						<th><?php echo $spq['category_name']; ?></th>
						<th><?php echo $spq['medium_name']; ?></th>
						<td><a href="nqb_question_not_translated_view.php?topic_id=<?php echo $spq['subject_id']; ?>&smedium=<?php echo $spq['medium_id']; ?>&tmedium=<?php echo $tmedium; ?>&mType=sp" target="_blank"><?php echo $spq['stpq']; ?></a></td>
					</tr>
				<?php $i++;
				} ?>
			</table>
		</div>
	</div>

</div>

</div><!-- Main Wrapper -->

<div class="page-footer">
	<p class="no-s">Graposs Connect &#169;</p>
</div>
</div><!-- Page Inner -->

<?php
include_once('footer.php');
?>