File: /var/www/content-sp/work-sp/nqb_master_create_structure.php
<?php
include_once('nqb_master_section.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';
$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;
}
}
##AddSubjects
if (isset($_REQUEST['add_subjects'])) {
$mediumID = $_REQUEST['medium_id'];
$master_id = $_SESSION['page_masterID'];
$sub_source = $_REQUEST['sub_source'];
if ($sub_source != '' && $master_id != '' && $master_id != '0') {
$i = 1;
foreach ($_REQUEST['sub_cat_name'] as $subject) {
$subjectName = str_replace("'", "''", $subject);
if ($subjectName != '') {
$insert = "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'";
if ($conn->query($insert)) {
$message = '<div style="background:#b6d8a8;" class="alert alert-success" role="alert">Subjects added successfully..</div>';
} else {
$message = '<div class="alert alert-danger" role="alert">Subjects not added..</div>';
}
} else {
$message = '<div class="alert alert-danger" role="alert">Please fill category name ! !</div>';
}
$i++;
}
} else {
$message = '<div class="alert alert-danger" role="alert">Something went wrong ! !</div>';
}
}
##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'];
if ($u_sub_source != '' && $u_master_id != '' && $u_master_id != '0' && $u_parent != '' && $u_parent != '0') {
$checkdisporder = $conn->query("select MAX(display_order) as cnt from $SP_MASTER_STRUCTURE where parent_id='$u_parent'");
$result = $checkdisporder->fetch_assoc();
if ($result['cnt'] != '') {
$i = $result['cnt'] + 1;
} else {
$i = 1;
}
foreach ($_REQUEST['u_sub_cat_name'] as $u_subject) {
$subjectName = str_replace("'", "''", $u_subject);
if ($subjectName != '') {
$insert = "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'";
if ($conn->query($insert)) {
$message = '<div style="background:#b6d8a8;" class="alert alert-success" role="alert">Subjects added successfully..</div>';
} else {
$message = '<div class="alert alert-danger" role="alert">Subjects not added..</div>';
}
} else {
$message = '<div class="alert alert-danger" role="alert">Please fill category name ! !</div>';
}
$i++;
}
} else {
$message = '<div class="alert alert-danger" role="alert">Something went wrong ! !</div>';
}
}
##Edit subject
if (isset($_REQUEST['edit_sub_cat'])) {
$e_sub_id = $_REQUEST['e_sub_id'];
$e_sub_cat_name = str_replace("'", "''", $_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 = "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'";
if ($conn->query($update)) {
$message = '<div style="background:#b6d8a8;" class="alert alert-success" role="alert">Subjects updated successfully..</div>';
} else {
$message = '<div class="alert alert-danger" role="alert">Subjects not updated..</div>';
}
} else {
$message = '<div class="alert alert-danger" role="alert">Please fill category name ! !</div>';
}
}
##update display order
if (isset($_POST['updatedisplayorder'])) {
$subcat_id = $_REQUEST["subqueryid"];
if(sizeof($subcat_id) > 0 && $subcat_id !=''){
foreach ($subcat_id as $cat_id) {
$display_order = $_POST["displayid_".$cat_id];
$sql_update = "UPDATE $SP_MASTER_STRUCTURE SET display_order='$display_order' WHERE sub_id='$cat_id'";
if ($conn->query($sql_update)) {
$message = "Display Order updated successfully";
} else {
$message = "Error updating record: " . $conn->error;
}
}
}
}
?>
<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_create_structure_treeview.php'; //new_question_bank_structure.php
include_once($path); ?>
</div>
<?php }
?>
</div>
</div>
<!---------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="1">--Select Medium--</option>
<?php while ($med = $getMediums->fetch_assoc()) { ?>
<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>
<option value="OLY">Olympiad</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 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;
}
});
}
function set_displayorder(sub_id) {
//alert(sub_id);
var site = "ajax_call/nqb_master_create_structure_popup.php?type=display&sid=" + sub_id;
jQuery.ajax({
url: site,
type: 'POST',
data: 'html',
success: function(data) {
document.getElementById("modal_body1").innerHTML = data;
}
});
}
function delete_structure(id, type) {
var r = confirm("Confirm Ok! before deleting");
if (r == true) {
var arr = {
"type": type,
"id": id,
};
jQuery("#" + type + "-" + id).css({
'opacity': '0.5',
'pointer-events': 'none'
});
var site = "ajax_call/nqb_master_tree_delete.php";
jQuery.ajax({
url: site,
type: 'POST',
data: JSON.stringify(arr),
contentType: 'application/json; charset=utf-8',
success: function(data) {
if (data.status == '1') {
// jQuery("#"+type+"-"+id).html('');
jQuery("#" + type + "-" + id).hide(500);
} else {
jQuery("#" + type + "-" + id).css({
'opacity': '1',
'pointer-events': ''
});
alert(data.message)
}
}
});
} else {
}
}
</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');
?>