File: /var/www/content-sp/work-sp/nqb_master_print_structure.php
<?php
include_once('nqb_master_section.php');
//check master permissions
$fileName = 'nqb_master_create_structure';
if (in_array($fileName, $pageArray)) {
$curDate = date('Y-m-d H:i:s');
$SP_MASTER_CATEGORY = 'csp_sp_master_category';
$SP_MASTER_STRUCTURE = 'csp_sp_master_structure';
$SP_MEDIUM = 'csp_sp_medium';
$allMaster = $conn->query("SELECT mc.master_id, mc.master_name,mc.source from $SP_MASTER_CATEGORY as mc order by mc.master_name asc");
$getMediums = $conn->query("SELECT medium_id,medium_name FROM $SP_MEDIUM order by medium_id");
if (isset($_POST['submit'])) {
unset($_SESSION['page_masterID']);
unset($_SESSION['page_catID']);
$master = $_REQUEST['master'];
$subject = $_REQUEST['subject'];
if ($master != '' && $subject != '') {
$_SESSION['page_masterID'] = $master;
$_SESSION['page_catID'] = $subject;
}
}
?>
<style>
.table-hover th,
td {
font-size: 13px;
}
.redClass {
background-color: #ff6d6d !important;
}
.orangeClass {
background-color: #ff7607 !important;
}
.modal-backdrop.in {
opacity: 0.9 !important;
z-index: 9 !important;
}
.topic {
width: 20%;
float: left;
font-size: 14px;
margin: 0 0 0 0;
}
.sub_topic {
width: 16%;
float: left;
font-size: 14px;
margin: 0 0 0 8px;
}
</style>
<div class="row">
<?php if (isset($message)) { ?>
<div class="col-md-12">
<?php echo $message; ?>
</div>
<?php } ?>
<div class="col-md-12">
<div class="panel panel-info">
<div class="panel-heading clearfix">
<h4 class="panel-title">Select Master</font>
</h4>
</div>
<div class="clearfix"></div>
<div class="panel-body">
<form class="form-inline" method="post">
<div class="form-group">
<select name="master" id="master" class="form-control">
<option value="">--Master--</option>
<?php while ($ms = $allMaster->fetch_assoc()) { ?>
<option value="<?php echo $ms['master_id']; ?>"><?php echo $ms['source'] . '-' . $ms['master_name']; ?></option>
<?php } ?>
</select>
</div>
<div class="form-group">
<select name="subject" class="form-control" id="subject">
<option value="S">--Subject--</option>
</select>
</div>
<input class="btn btn-info" type="submit" value="Select Master" name="submit" />
</form>
</div>
</div>
</div>
<div class="col-md-12">
<div class="panel panel-info">
<?php
if (isset($_SESSION['page_masterID'])) {
$from_id = $_SESSION['page_catID'];
$showName = $conn->query("SELECT mc.master_name,ms.category_name from $SP_MASTER_STRUCTURE as ms LEFT JOIN $SP_MASTER_CATEGORY as mc on mc.master_id=ms.master_id where ms.sub_id=$from_id");
$result = $showName->fetch_assoc();
?>
<div class="panel-heading clearfix">
<h4 class="panel-title" style="width: 100%;">Master Structure [ <?php echo $result['master_name'] . " - " . $result['category_name'] . ' - ' . $_SESSION['page_masterID']; ?> ]
<?php
if (isset($_SESSION['page_masterID'])) { ?>
<button style="float: right;margin: -8px 0px 0px 0px;" type="button" class="btn btn-danger btn-rounded" data-toggle="modal" data-target=".bs-example-modal-lg">Add Subjects</button>
<?php } ?>
</h4>
</div>
<div class="panel-body">
<?php
$path = '../work-sp/nqb_master_print_structure_treeview.php'; //new_question_bank_structure.php
include_once($path); ?>
</div>
<?php }
?>
</div>
</div>
<div class="page-footer">
<p class="no-s">Graposs Connect ©</p>
</div>
</div><!-- Page Inner -->
<script>
jQuery.noConflict();
jQuery(document).ready(function() {
jQuery('#master').on('change', function() {
var mid = jQuery("#master").val();
var loadUrl = "ajax_call/nqb_master_topics.php?eid=" + mid + "&type=master";
var jqxhr = jQuery.get(loadUrl);
jqxhr.success(function(data) {
jQuery("#subject").html(data);
});
});
});
</script>
<?php
} else {
echo "<script>alert('You dont have access for create master structure');</script>";
echo "<script type='text/javascript'>location.href='/work-sp';</script>";
}
include_once('footer.php');
?>