File: /var/www/content-sp/work-sp/nqb_master_add_edit.php
<?php
// ini_set('display_errors', 1);
// ini_set('display_startup_errors', 1);
// error_reporting(E_ALL);
include_once('nqb_master_section.php');
$SP_MASTER_CATEGORY = 'csp_sp_master_category';
$SP_MEDIUM = 'csp_sp_medium';
$SP_MASTER_STRUCTURE = 'csp_sp_master_structure';
$getMediums = $conn->query("SELECT medium_id,medium_name FROM $SP_MEDIUM order by medium_id");
$curDate = date('Y-m-d H:i:s');
//form submit
if (isset($_REQUEST['add_master'])) {
$master_name = $_REQUEST['master_name'];
$master_of = $_REQUEST['master_of'];
$master_desc = $_REQUEST['master_desc'];
if ($master_name != '') {
$checkName = $conn->query("SELECT master_id FROM $SP_MASTER_CATEGORY where master_name='$master_name'");
$ifexist = mysqli_num_rows($checkName);
if ($ifexist == 0) {
$insertQuery = "INSERT into $SP_MASTER_CATEGORY set master_name='$master_name',medium_id='1', source='$master_of', master_description='$master_desc', status='1', added_date='$curDate'";
if ($conn->query($insertQuery)) {
$msg = '<div class="alert alert-success alert-dismissible" role="alert">Master created successfully<button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">×</span></button></div>';
} else {
$msg = '<div class="alert alert-danger alert-dismissible" role="alert">Error in master creation<button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">×</span></button></div>';
}
} else {
$msg = '<div class="alert alert-danger alert-dismissible" role="alert">This master name already exist<button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">×</span></button></div>';
}
}
}
if (isset($_REQUEST['edit_m'])) {
$e_m_id = $_REQUEST['e_m_id'];
$e_master = $_REQUEST['e_master'];
if ($e_master != '') {
$checkName = $conn->query("SELECT master_id FROM $SP_MASTER_CATEGORY where master_name='$e_master' and master_id!='$e_m_id'");
$ifexist = mysqli_num_rows($checkName);
if ($ifexist == 0) {
$updateQuery = "UPDATE $SP_MASTER_CATEGORY set master_name='$e_master' where master_id='$e_m_id'";
if ($conn->query($updateQuery)) {
$msg = '<div class="alert alert-success alert-dismissible" role="alert">Master updated successfully<button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">×</span></button></div>';
} else {
$msg = '<div class="alert alert-danger alert-dismissible" role="alert">Error in master updation<button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">×</span></button></div>';
}
} else {
$msg = '<div class="alert alert-danger alert-dismissible" role="alert">This master name already exist<button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">×</span></button></div>';
}
}
}
##AddSubjects
if (isset($_REQUEST['add_subjects'])) {
$mediumID = $_REQUEST['medium_id'];
$master_id = $_REQUEST['in_master_id'];
$sub_source = $_REQUEST['sub_source'];
if ($sub_source != '' && $master_id != '' && $master_id != '0') {
$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'");
$msg = '<div style="background:#b6d8a8;" class="alert alert-success" role="alert">Subjects added successfully..</div>';
} else {
$msg = '<div class="alert alert-danger" role="alert">Please fill category name ! !</div>';
}
$i++;
}
} else {
$msg = '<div class="alert alert-danger" role="alert">Something went wrong ! !</div>';
}
}
$allMaster = $conn->query("SELECT c.master_name,c.master_id,c.source FROM $SP_MASTER_CATEGORY as c order by c.master_name");
?>
<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;
}
.ta {
background: #6873f9;
color: #fff;
font-weight: bold;
}
.tb {
background: #f9b868;
color: #fff;
font-weight: bold;
}
</style>
<link rel="stylesheet" type="text/css" href="https://ajax.googleapis.com/ajax/libs/jqueryui/1.8/themes/base/jquery-ui.css" />
<script src="assets/plugins/jquery/jquery-2.1.3.min.js"></script>
<script src="assets/plugins/jquery-ui/jquery-ui.min.js"></script>
<link href="assets/plugins/datatables/css/jquery.datatables.min.css" rel="stylesheet">
<link href="assets/plugins/datatables/css/responsive.datatables.min.css" rel="stylesheet">
<script src="assets/plugins/datatables/js/jquery.datatables.min.js"></script>
<script src="assets/plugins/datatables/js/jquery.datatables.js"></script>
<script src="assets/plugins/datatables/js/datatables.responsive.min.js"></script>
<script type="text/javascript">
var jq = jQuery.noConflict();
jq(document).ready(function() {
jq('#medium_table').dataTable({
"processing": true,
"serverSide": false,
"responsive": true,
"bPaginate": true,
"iDisplayLength": 100,
"lengthMenu": [
[50, 100, 300, 500, 1000],
[50, 100, 300, 1000, "All"]
],
});
});
</script>
<div class="row">
<div class="col-md-12">
<div class="panel panel-white">
<div class="panel-heading clearfix">
<h4 class="panel-title">Add Master Category</font>
</h4>
</div>
<div class="panel-body">
<span id="alert1" style="display: block;"><?php if (isset($msg)) {
echo $msg;
} ?></span>
<form class="form-inline" method="post">
<div class="form-group">
<input class="form-control" type="text" name="master_name" placeholder="Master Name" id="master_name" required />
</div>
<div class="form-group">
<select name="master_of" class="form-control">
<option value="">--Master of--</option>
<option value="SP">Sarkari Pariksha</option>
<option value="OLY">CSC-Olympiad</option>
</select>
</div>
<div class="form-group">
<input class="form-control" type="text" name="master_desc" placeholder="Description" id="master_desc" required />
</div>
<input class="btn btn-info" type="submit" value="Add Master" name="add_master" />
</form>
</div>
</div>
</div>
<div class="col-md-12">
<div class="panel panel-info">
<div class="panel-heading clearfix">
<h4 class="panel-title" style="width: 100%;">Master Category List</h4>
</div>
<div class="panel-body">
<div class="table-responsive">
<table id="medium_table" class="display table" style="width: 100%; cellspacing: 0;">
<thead>
<tr>
<th>MId</th>
<th>Master Of</th>
<th>MName</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php while ($ms = $allMaster->fetch_assoc()) { ?>
<tr>
<td><?php echo $ms['master_id']; ?></td>
<td><?php echo $ms['source']; ?></td>
<td><?php echo $ms['master_name']; ?></td>
<td> <i style="cursor:pointer;font-size:15px;" data-toggle="modal" data-target=".bs-example-modal-lg2" class="fa fa-edit" onclick="editMaster('<?php echo $ms['master_id']; ?>')"></i> <button type="button" class="btn btn-success" onclick="addMasterId('<?php echo $ms['master_id']; ?>')" data-toggle="modal" data-target=".bs-example-modal-lg">Add Subjects</button></td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
</div>
</div>
</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">Medium:</label>
<div class="col-sm-6">
<input type="hidden" name="in_master_id" id="in_master_id">
<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---------->
<!-------edit master---------->
<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><!-- Main Wrapper -->
<div class="page-footer">
<p class="no-s">Graposs Connect ©</p>
</div>
</div><!-- Page Inner -->
<script>
function editMaster(sub_id) {
var site = "ajax_call/nqb_master_edit.php?type=e&sid=" + sub_id;
jQuery.ajax({
url: site,
type: 'POST',
data: 'html',
success: function(data) {
document.getElementById("modal_body1").innerHTML = data;
}
});
}
function addMasterId(id) {
jQuery("#in_master_id").val(id);
}
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
}
</script>
<?php
include_once('footer.php');
?>