File: /var/www/content-sp/work-sp/nqb_masters_oly.php
<?php
// ini_set('display_errors',1);
// ini_set('display_startup_errors',1);
// error_reporting(E_ALL);
include_once('nqb_master_section_oly.php');
$fileName = 'nqb_masters';
//check master permissions
if(in_array($fileName,$pageArray)) {
$masterType = 'oly';
$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';
$checkAssignedMaster = $conn->query("SELECT q_masters FROM $SP_EDITORS where editor_id='$editor_id'");
$fm = $checkAssignedMaster->fetch_assoc();
if($fm['q_masters'] == '') {
$mQuery = '';
} else {
$mastersAsgn = $fm['q_masters'];
$mQuery = "and mc.master_id IN($mastersAsgn)";
}
$allMaster = $conn->query("select mc.master_id, mc.master_name from $SP_MASTER_CATEGORY as mc WHERE mc.source='OLY' $mQuery order by mc.master_name asc");
$allMedium = $conn->query("select medium_id,medium_name from $SP_MEDIUM order by medium_id");
$allMediumT = $conn->query("select medium_id,medium_name from $SP_MEDIUM order by medium_id");
if (isset($_POST['submit'])) {
unset($_SESSION['oly_ms_catId']);
unset($_SESSION['oly_ms_masterID']);
$master = $_REQUEST['master'];
$subject = $_REQUEST['subject'];
$source_med = $_REQUEST['source_medium'];
$target_med = $_REQUEST['target_medium'];
if($source_med == 'SM')
{
$msg = '<div class="alert alert-danger alert-dismissible"><button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button><h4><i class="icon fa fa-ban"></i> Error!</h4>Please select source medium.</div>';
}
else if($target_med == 'TM')
{
$msg = '<div class="alert alert-danger alert-dismissible"><button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button><h4><i class="icon fa fa-ban"></i> Error!</h4>Please select target medium.</div>';
}
else{
if ($subject != '') {
$_SESSION['oly_ms_catId'] = $subject;
$_SESSION['oly_ms_masterID'] = $master;
$_SESSION['SRC_MED'] = $source_med;
$_SESSION['TAR_MED'] = $target_med;
}
}
}
?>
<script>
function validateForm() {
if (jQuery('#subject').val() == "") {
alert("Select Subject");
jQuery('#subject').focus();
jQuery(":focus").css("background-color", "#f1d9d9");
return false;
}
}
</script>
<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: 26%;
float: left;
font-size: 14px;
margin: 0 0 0 -19px;
}
</style>
<?php if (isset($msg)) { ?>
<div class="row">
<div class="col-sm-12">
<?php echo $msg; ?>
</div>
</div>
<?php } ?>
<div class="row">
<div class="col-md-12">
<div class="panel panel-white">
<div class="panel-heading clearfix">
<h4 class="panel-title"></font>
</h4>
</div>
<div class="panel-body">
<form class="form-inline" method="post" onSubmit="return validateForm();">
<div class="form-group">
<select name="master" class="form-control" id="master">
<option value="">--Select Master--</option>
<?php while ($ms = $allMaster->fetch_assoc()) { ?>
<option value="<?php echo $ms['master_id']; ?>" <?php if(@$_SESSION['oly_ms_masterID'] == $ms['master_id']) { echo "selected"; } ?>><?php echo $ms['master_name']; ?></option>
<?php } ?>
</select>
</div>
<div class="form-group">
<select name="subject" class="form-control" id="subject">
<option value="S">--Select Subject--</option>
<?php if(isset($_SESSION['oly_ms_catId'])) {
$getSubject = $conn->query("SELECT sub_id,category_name from $SP_MASTER_STRUCTURE where master_id='".$_SESSION['oly_ms_masterID']."' and parent_id=0 order by category_name asc");
foreach($getSubject as $sb){
?>
<option value="<?php echo $sb['sub_id']; ?>" <?php if(@$_SESSION['oly_ms_catId'] == $sb['sub_id']) { echo "selected"; } ?>><?php echo $sb['category_name']; ?></option>
<?php } } ?>
</select>
</div>
<div class="form-group">
<select name="source_medium" class="form-control" id="source_medium">
<option value="SM">--Select Source Medium--</option>
<?php
while ($md = $allMedium->fetch_assoc()) {
?><option value='<?php echo $md['medium_id'] ?>' <?php if(@$_SESSION['SRC_MED'] == $md['medium_id']) { echo "selected"; } else if($md['medium_id']==1) { echo "selected"; } ?>><?php echo $md['medium_name'] ?></option>
<?php } ?>
</select>
</div>
<div class="form-group">
<select name="target_medium" class="form-control" id="target_medium">
<option value="TM">--Select Target Medium--</option>
<?php
while ($mdt = $allMediumT->fetch_assoc()) {
?><option value='<?php echo $mdt['medium_id'] ?>' <?php if(@$_SESSION['TAR_MED'] == $mdt['medium_id']) { echo "selected"; } else if($mdt['medium_id']==2) { echo "selected"; } ?>><?php echo $mdt['medium_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-12">
<div class="panel panel-info">
<?php
if (isset($_SESSION['oly_ms_catId'])) {
$from_id = $_SESSION['oly_ms_catId'];
$masterID = $_SESSION['oly_ms_masterID'];
$src_med = $_SESSION['SRC_MED'];
$tar_med = $_SESSION['TAR_MED'];
$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'].' - '.$masterID; ?> ]</h4>
</div>
<div class="panel-body">
<?php
$path = '../work-sp/nqb_masters_treeview_dummy.php'; //new_question_bank_structure.php
include_once($path);?>
</div>
<?php } ?>
</div>
</div>
</div>
</div><!-- Main Wrapper -->
<!---------view tutorial---------->
<div class="modal fade bs-example-modal-lg1" tabindex="-1" role="dialog" aria-labelledby="myLargeModalLabel" aria-hidden="true">
<div class="modal-dialog modal-lg">
<div class="modal-content">
<div class="modal-header" style="padding: 5px 10px 0px 0px; height: 20px;">
<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
</div>
<div class="modal-body" id="modal_body1">
</div>
</div>
</div>
</div>
<!---------------->
<!--------- view question status modal ---------->
<div class="modal fade" id="quesStatusModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
<div class="modal-dialog">
<div class="modal-content" style="border: 3px solid #ccc;">
<div class="modal-header" style="padding: 5px 10px 0px 0px; height: 20px;">
<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
</div>
<div class="modal-body" id="ques_status_modal"></div>
</div>
</div>
</div>
<!-------- question status modal -------->
<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);
});
});
jQuery('#quesStatusModal').on('show.bs.modal', function (event) {
var button = $(event.relatedTarget);
var tpcId = button.data('id');
//alert(tpcId);
var url = "ajax_call/nqb_question_status_popup.php";
jQuery.ajax({
url: url,
type:'POST',
data: {tpcId:tpcId},
success:function(data){
document.getElementById("ques_status_modal").innerHTML = data;
}
});
});
});
function view_tut(topic_id, master_id) {
var site = "/work-sp/sp_master_view_tutorial.php?topic_id=" + topic_id + "&master_id=" + master_id;
jQuery.ajax({
url: site,
type: 'POST',
data: 'html',
success: function(data) {
document.getElementById("modal_body1").innerHTML = data;
}
});
}
</script>
<div class="page-footer">
<p class="no-s">Graposs Connect ©</p>
</div>
</div><!-- Page Inner -->
<?php
} else {
echo "<script>alert('You dont have access for master');</script>";
echo "<script type='text/javascript'>location.href='/work-sp';</script>";
}
include_once('footer.php');
?>