File: /var/www/nclive/technc/exam_cutoff_list.php
<?php include 'header.php'; ?>
<style>
.total_ques_div
{
background-color: white;
border-color: #C8D5E0;
border-image: none;
border-style: solid;
border-width: 1px 1px 2px;
color: #1E598E;
font-weight: bold;
padding: 8px 10px;
text-decoration: none;
}
.form-table td
{
padding:0px !important;
}
.extLink{
text-decoration: none;
cursor: pointer;
}
.fancybox-skin
{ margin-left: 400px!important;
width: 500px!important;
}
.form-table td {
padding: 5px !important;
}
</style>
<script type="text/javascript" charset="utf8" src="assets/js/jquery-1.4.1.min.js"></script>
<script type="text/javascript" charset="utf8" src="assets/js/jquery.dataTables.min.js"></script>
<link rel="stylesheet" href="assets/css/jquery.dataTables.min.css">
<main id="main-container">
<div class="content content-narrow">
<div class="row">
<div class="col-lg-12">
<h2 class="content-heading">Exam Cutoff List</h2>
<div class="table-responsive">
<table id="cutoff_list" class="table table-striped table-bordered dt-responsive nowrap" style="width: 100%; cellspacing: 0;">
<thead>
<tr>
<th>S.no</th>
<th>Status</th>
<th>Edit</th>
<th>Exam Name</th>
<th>Year</th>
<th>O.B.C</th>
<th>Ex-Service Man</th>
<th>Comments</th>
<th>Date</th>
<th>Display Order</th>
</tr>
</thead>
</table>
<script type="text/javascript">
jQuery(function($) {
jQuery('#cutoff_list').dataTable({
"dom" : "Bfrtip",
"pagingType": "full_numbers",
"processing": true,
"serverSide": true,
"responsive": true,
"ajax": "/technc/exam_cutoff_list_data.php",
"columns": [
{"data": "id",
render: function(data, type, row, meta) {
return meta.row + meta.settings._iDisplayStart + 1;
}
},
{"data": "status",
render: function(data, type, row, meta) {
if (row.status == '1') {
return '<td><a style="cursor:pointer;" id='+row.id+','+row.status+' onclick="update(id)"><span id="status">Active</span></a></td>';
} else if (row.status == '0') {
return '<td><a style="cursor:pointer;" id='+row.id+','+row.status+' onclick="update(id)"><span id="status">Deactive</span></a></td>';
}
},
},
{"data": "action",
render: function(data, type, row, meta) {
var ret = '';
ret += '<button name="update" class="btn btn-info" onclick="selectData('+row.id+')" data-toggle="tooltip" title="Edit this exam">Edit </button><a style="cursor:pointer;" id='+row.id+' onclick="deleteCutoff(id)"><button class="btn btn-danger">Delete</button></a>';
return ret;
}
},
{"data": "exam_name"},
{"data": "year"},
{"data": "obc"},
{"data": "ex_servicemen"},
{"data": "comment"},
{"data": "added_date"},
{"data": "display_order"}
],
"order": [
[0, 'desc']
],
"bPaginate": true,
"iDisplayLength": 50,
"bProcessing" : true,
"bServerSide" : true,
"lengthMenu": [
[50, 100, 200, 300, 1000],
[50, 100, 200, 300, "All"]
]
});
});
</script>
</div>
</div>
</div>
</div>
<!-------STATUS MODEL------------------------------->
<div class=" modal fade" id="statusModel" role="dialog">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">×</button>
<h4 class="modal-title">Do you want to change Exams Cutoff Details ? </h4>
</div>
<div class="modal-body">
<form class="js-validation-bootstrap form-horizontal" action="exam_cutoff_list.php" method="post" id="form">
<input type="hidden" name="id" value="" id="id">
<div class="form-group">
<label class="col-md-2 control-label" for="val-select2">Exams</label>
<div class="col-md-10">
<input class="form-control" type="text" name="exam_name" id="exam_name" value="" readonly/>
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-username">Year<span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="text" name="year" id="year" value="" placeholder="">
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-password">General<span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="text" name="general" id="general" value="" placeholder="">
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-password">OBC<span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="text" name="obc" id="obc" value="" placeholder="">
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-password">SC/ST<span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="text" name="scst" id="scst" value="" placeholder="">
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-password">Ex-Servicemen<span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="text" name="exserv" id="exserv" value="" placeholder="">
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-password">Women<span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="text" value="" name="women" id="women" placeholder="">
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-password">Others<span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="text" value="" name="other" id="other" placeholder="">
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-password">Comments<span class="text-danger">*</span></label>
<div class="col-md-10">
<textarea class="form-control" placeholder="Comments" value="" name="comment" cols="20" id="comment"></textarea>
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-password">Display Order<span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" placeholder="" value="" name="display_order" type="text" id="display_order">
</div>
</div>
<div class="form-group">
<div class="col-md-10 col-md-offset-2">
<button class="btn btn-success" type="submit" name="update">Update</button>
</div>
</div>
</form>
</div>
</div>
</div>
</div>
</main>
<?php
$ide=$_REQUEST['id'];
if(isset($_REQUEST['update'])){
$year=$_REQUEST['year'];
$general=$_REQUEST['general'];
$obc=$_REQUEST['obc'];
$sc=$_REQUEST['scst'];
$ex=$_REQUEST['exserv'];
$wo=$_REQUEST['women'];
$comment=$_REQUEST['comment'];
$ot=$_REQUEST['other'];
$display_order=$_REQUEST['display_order'];
$updateQuery="UPDATE sp_exam_cutoff SET year='$year',st_sc='$sc',obc='$obc',gen='$general',women='$wo',ex_servicemen='$ex',others='$ot',comment='$comment',display_order='$display_order'WHERE id='$ide'";
$sql1 = $db->prepare($updateQuery);
$sql1->execute();
}
?>
<script type="text/javascript">
function selectData(id) {
var base_url = window.location.origin;
$.ajax({
url:'update_cutoff.php',
type: 'POST',
data: { id:id },
success: function (data, status, xhr) {
document.getElementById('id').value=data.id;
document.getElementById('exam_name').value=data.exam_name;
document.getElementById('year').value=data.year;
document.getElementById('general').value=data.gen;
document.getElementById('obc').value=data.obc;
document.getElementById('scst').value=data.st_sc;
document.getElementById('exserv').value=data.ex_servicemen;
document.getElementById('women').value=data.women;
document.getElementById('comment').value=data.comment;
document.getElementById('other').value=data.others;
document.getElementById('display_order').value=data.display_order;
},
error: function (jqXhr, textStatus, errorMessage) { }
});
jQuery("#statusModel").modal();
}
function update(id){
var str = id;
var array = str.split(',');
var status = array[1];
$.ajax('cutoff_status_active.php', {
type: 'POST', // http method
data: { id:id }, // data to submit
success: function (data, status, xhr) {
var update_id=data.st;
if(status!=update_id){
location.reload();
}
},
error: function (jqXhr, textStatus, errorMessage) { }
});
}
function deleteCutoff(id){
var txt;
var r = confirm("Do you want to Delete ?");
if (r == true) {
$.ajax('delete_exam_cutoff.php', {
type: 'POST', // http method
data: { id:id }, // data to submit
success: function (response) {
var obj = jQuery.parseJSON(response);
if(obj.status == '1'){
alert(obj.msg);
location.reload();
} else {
alert(obj.msg);
}
},
error: function (jqXhr, textStatus, errorMessage) {
}
});
}
}
</script>
<?php include 'footer.php'; ?>