File: /var/www/content-sp/work-sp/my_nqb_master_structure.php
<?php
// ini_set('display_errors', 1);
// ini_set('display_startup_errors', 1);
// error_reporting(E_ALL);
include_once('my_master_sections.php');
//check master permissions
$fileName = str_replace('.php', '', basename($_SERVER['REQUEST_URI'], '?' . $_SERVER['QUERY_STRING']));
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';
$SP_EDITORS = 'csp_editors';
# check for assigned masters
$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,mc.source from $SP_MASTER_CATEGORY as mc WHERE mc.source='SP' $mQuery order by mc.master_id");
$getMediums = $conn->query("SELECT medium_id,medium_name FROM $SP_MEDIUM order by medium_id");
$message = "";
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;
}
}
##AddSubjects
if (isset($_REQUEST['add_subjects'])) {
$mediumID = $_REQUEST['medium_id'];
$master_id = $_SESSION['page_masterID'];
$sub_source = $_REQUEST['sub_source'];
if ($master_id != '') {
$i = 1;
foreach ($_REQUEST['sub_cat_name'] as $subject) {
$subjectName = $subject;
if ($subjectName != '') {
$insert = $conn->query("INSERT into $SP_MASTER_STRUCTURE set master_id='$master_id', parent_id='0', category_name='$subjectName', medium_id='$mediumID', display_order='$i', status='1',source='$sub_source', added_by='$editor_id', added_date='$curDate'");
$message .= '<div style="background:#b6d8a8;" class="alert alert-success" role="alert">Subjects added successfully..</div>';
} else {
$message .= '<div class="alert alert-danger" role="alert">Please fill category name ! !</div>';
}
$i++;
}
}
}
# before_add_subjects
if (isset($_REQUEST['before_add_subjects'])) {
$before_ms = $_REQUEST['before_ms'];
$before_medium_id = $_REQUEST['before_medium_id'];
$before_sub_source = $_REQUEST['before_sub_source'];
$before_sub_cat_name = $_REQUEST['before_sub_cat_name'];
if ($before_ms != '') {
$i = 1;
foreach ($_REQUEST['before_sub_cat_name'] as $subject) {
$subjectName = $subject;
if ($subjectName != ''
) {
$insert = $conn->query("INSERT into $SP_MASTER_STRUCTURE set master_id='$before_ms', parent_id='0', category_name='$subjectName', medium_id='$before_medium_id', display_order='$i', status='1',source='$before_sub_source', added_by='$editor_id', added_date='$curDate'");
$message .= '<div style="background:#b6d8a8;" class="alert alert-success" role="alert">Subjects added successfully..</div>';
} else {
$message .= '<div class="alert alert-danger" role="alert">Please fill category name ! !</div>';
}
$i++;
}
}
}
##add_sub_cat
if (isset($_REQUEST['add_sub_cat'])) {
$u_medium = $_REQUEST['u_medium'];
$u_master_id = $_SESSION['page_masterID'];
$u_parent = $_REQUEST['u_parent'];
$u_sub_source = $_REQUEST['u_sub_source'];
$i = 1;
foreach ($_REQUEST['u_sub_cat_name'] as $u_subject) {
$subjectName = $u_subject;
if ($subjectName != '') {
$insert = $conn->query("INSERT into $SP_MASTER_STRUCTURE set master_id='$u_master_id', parent_id='$u_parent', category_name='$subjectName', medium_id='$u_medium', display_order='$i', status='1',source='$u_sub_source', added_by='$editor_id', added_date='$curDate'");
$message .= '<div style="background:#b6d8a8;" class="alert alert-success" role="alert">Subjects added successfully..</div>';
} else {
$message .= '<div class="alert alert-danger" role="alert">Please fill category name ! !</div>';
}
$i++;
}
}
##Edit subject
if (isset($_REQUEST['edit_sub_cat'])) {
$e_sub_id = $_REQUEST['e_sub_id'];
$e_sub_cat_name = $_REQUEST['e_sub_cat_name'];
$e_display_order = $_REQUEST['e_display_order'];
$e_sub_source = $_REQUEST['e_sub_source'];
if ($e_sub_cat_name != '') {
$update = $conn->query("UPDATE $SP_MASTER_STRUCTURE set category_name='$e_sub_cat_name',display_order='$e_display_order', source='$e_sub_source' where sub_id='$e_sub_id'");
$message .= '<div style="background:#b6d8a8;" class="alert alert-success" role="alert">Subjects updated successfully..</div>';
} else {
$message .= '<div class="alert alert-danger" role="alert">Please fill category name ! !</div>';
}
}
?>
<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 -19px;
}
</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" style="width: 100%;">Select Master</font>
<?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 } else { ?>
<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-lg3">Add Subjects</button>
<?php } ?>
</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 foreach ($allMaster as $ms) { ?>
<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'];
$masterID = $_SESSION['page_masterID'];
$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']; ?> ]
</h4>
</div>
<?php if ($result['category_name'] != '') { ?>
<div class="panel-body">
<?php
$path = '../work-sp/nqb_master_create_structure_treeview.php'; //new_question_bank_structure.php
include_once($path);
?>
</div>
<?php } else {
unset($_SESSION['page_masterID']);
unset($_SESSION['page_catID']);
} ?>
<?php }
?>
</div>
</div>
<!---------add subject before submit--------->
<div class="modal fade bs-example-modal-lg3" 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">
<div class="panel panel-danger">
<div class="panel panel-white">
<div class="panel-heading clearfix">
<h4 class="panel-title">Add Subjects</h4>
</div>
<form class="form-horizontal" method="post">
<div class="panel-body">
<div class="well">
<div class="form-group">
<label for="inputPassword3" class="col-sm-2 control-label">Master :</label>
<div class="col-sm-6">
<select name="before_ms" id="before_ms" class="form-control">
<option value="">--Master--</option>
<?php foreach ($allMaster as $ms) { ?>
<option value="<?php echo $ms['master_id']; ?>"><?php echo $ms['source'] . '-' . $ms['master_name']; ?></option>
<?php } ?>
</select>
</div>
</div>
<div class="form-group">
<label for="inputPassword3" class="col-sm-2 control-label">Medium:</label>
<div class="col-sm-6">
<select name="before_medium_id" class="form-control">
<option value="0">--Select Medium--</option>
<?php foreach ($getMediums as $med) { ?>
<option value="<?php echo $med['medium_id']; ?>"><?php echo $med['medium_name']; ?></option>
<?php } ?>
</select>
</div>
</div>
<div class="form-group">
<label for="inputPassword3" class="col-sm-2 control-label">Topic of:</label>
<div class="col-sm-6">
<select name="before_sub_source" id="sub_source" class="form-control">
<option value="SP">Sarkari Pariksha</option>
</select>
</div>
</div>
<div class="form-group">
<label for="inputPassword3" class="col-sm-2 control-label">Category Name:</label>
<div class="col-sm-6 addFields2">
<input type="text" class="form-control" name="before_sub_cat_name[]" value="" placeholder="Add Subject Name.." />
</div>
<div class="col-sm-4">
<button onclick="addFields2()" type="button" class=" btn btn-info add_form_field">Add More Subjects <span style="font-size:16px; font-weight:bold;">+ </span></button>
</div>
</div>
<div class="form-group">
<label for="inputPassword3" class="col-sm-2 control-label"> </label>
<div class="col-sm-6">
<button type="submit" name="before_add_subjects" class="btn btn-primary btn-rounded">Submit</button>
</div>
</div>
</div>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
</div>
<!--------add ssubject before submit---------->
<!---------add subject--------->
<div class="modal fade bs-example-modal-lg" 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">
<div class="panel panel-danger">
<div class="panel panel-white">
<div class="panel-heading clearfix">
<h4 class="panel-title">Add Subjects</h4>
</div>
<form class="form-horizontal" name="add_sub_cat" action="" method="post" onsubmit="return validation();">
<div class="panel-body">
<div class="well">
<div class="form-group">
<label for="inputPassword3" class="col-sm-2 control-label">Parent Category:</label>
<div class="col-sm-6">
<input type="text" class="form-control" value="<?php echo $result['master_name']; ?>" disabled />
</div>
</div>
<div class="form-group">
<label for="inputPassword3" class="col-sm-2 control-label">Medium:</label>
<div class="col-sm-6">
<select name="medium_id" class="form-control">
<option value="0">--Select Medium--</option>
<?php foreach ($getMediums as $med) { ?>
<option value="<?php echo $med['medium_id']; ?>"><?php echo $med['medium_name']; ?></option>
<?php } ?>
</select>
</div>
</div>
<div class="form-group">
<label for="inputPassword3" class="col-sm-2 control-label">Topic of:</label>
<div class="col-sm-6">
<select name="sub_source" id="sub_source" class="form-control">
<option value="SP">Sarkari Pariksha</option>
</select>
</div>
</div>
<div class="form-group">
<label for="inputPassword3" class="col-sm-2 control-label">Category Name:</label>
<div class="col-sm-6 addFields">
<input type="text" class="form-control" name="sub_cat_name[]" value="" placeholder="Add Subject Name.." />
</div>
<div class="col-sm-4">
<button onclick="addFields()" type="button" class=" btn btn-info add_form_field">Add More Subjects <span style="font-size:16px; font-weight:bold;">+ </span></button>
</div>
</div>
<div class="form-group">
<label for="inputPassword3" class="col-sm-2 control-label"> </label>
<div class="col-sm-6">
<button type="submit" name="add_subjects" class="btn btn-primary btn-rounded">Submit</button>
</div>
</div>
</div>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
</div>
<!--------add sub topics---------->
<!---------add subject--------->
<div class="modal fade bs-example-modal-lg1" tabindex="-1" role="dialog" aria-labelledby="myLargeModalLabel" aria-hidden="true">
<div class="modal-dialog modal-lg1">
<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="sub_topics">
</div>
</div>
</div>
</div>
<!-------edit subject---------->
<div class="modal fade bs-example-modal-lg2" tabindex="-1" role="dialog" aria-labelledby="myLargeModalLabel" aria-hidden="true">
<div class="modal-dialog modal-lg2">
<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>
<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);
});
});
});
function addFields() {
var wrapper = $(".addFields");
$(wrapper).append('<br><div><input type="text" class="form-control" name="sub_cat_name[]" id="sub_cat_name" value="" placeholder="Add other Subject Name.." /></div>'); //add input box
}
function addFields1() {
var wrapper = $(".addFields1");
$(wrapper).append('<br><div><input type="text" class="form-control" name="u_sub_cat_name[]" id="sub_cat_name" value="" placeholder="Add other Topic Name.." /></div>'); //add input box
}
function addFields2() {
var wrapper = $(".addFields2");
$(wrapper).append('<br><div><input type="text" class="form-control" name="before_sub_cat_name[]" id="sub_cat_name" value="" placeholder="Add other Topic Name.." /></div>'); //add input box
}
function add_sub(sub_id) {
var site = "ajax_call/nqb_master_create_structure_popup.php?type=a&sid=" + sub_id;
jQuery.ajax({
url: site,
type: 'POST',
data: 'html',
success: function(data) {
document.getElementById("sub_topics").innerHTML = data;
}
});
}
function edit_sub(sub_id) {
var site = "ajax_call/nqb_master_create_structure_popup.php?type=e&sid=" + sub_id;
jQuery.ajax({
url: site,
type: 'POST',
data: 'html',
success: function(data) {
document.getElementById("modal_body1").innerHTML = 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');
?>