File: /var/www/nclive/technc/physical_eligibility_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 List </h2>
<div class="table-responsive">
<table id="physical_list" class="table table-striped table-bordered dt-responsive nowrap" style="width: 100%; cellspacing: 0;">
<thead>
<tr class="danger">
<th>S.no</th>
<th>status</th>
<th>Action</th>
<th>Exam Name</th>
<th>gender</th>
<th>categories</th>
<th>height</th>
<th>chest</th>
<th>race</th>
<th>time</th>
<th>long_jump</th>
<th>high_jump</th>
<th>short_put</th>
<th>chances</th>
</tr>
</thead>
</table>
<script type="text/javascript">
jQuery(function($) {
jQuery('#physical_list').dataTable({
"dom" : "Bfrtip",
"pagingType": "full_numbers",
"processing": true,
"serverSide": true,
"responsive": true,
"ajax": "/technc/physical_eligibility_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><button class="btn btn-danger" style="cursor:pointer;" id='+row.id+' onclick="deletePhysical(id)"> Delete </button>';
return ret;
}
},
{"data": "exam_name"},
{"data": "gender"},
{"data": "categories"},
{"data": "height"},
{"data": "chest"},
{"data": "race"},
{"data": "time"},
{"data": "long_jump"},
{"data": "high_jump"},
{"data": "short_put"},
{"data": "chances"}
],
"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>
</main>
<!-------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 Physical Description Details ? </h4>
</div>
<div class="modal-body">
<?php
if(isset($_REQUEST['submit'])){
$curDate = date('Y-m-d H:i:s');
$id=$_REQUEST['id'];
$exam_id=$_REQUEST['exam_id'];
$gender= $_REQUEST['gender'];
$category= $_REQUEST['categories'];
$height=$_REQUEST['height'];
$chest=$_REQUEST['chest'];
$race=$_REQUEST['race'];
$long_jump=$_REQUEST['long_jump'];
$high_jump=$_REQUEST['high_jump'];
$short_put=$_REQUEST['short_put'];
$chances=$_REQUEST['chances'];
$description=$_REQUEST['description'];
$query1="UPDATE sp_physical_eligibility SET gender='$gender',categories='$category',height='$height',chest='$chest',race='$race',long_jump='$long_jump',high_jump='$high_jump',short_put='$short_put', chances='$chances' where id='$id'";
$sql1 = $db->prepare($query1);
$sql1->execute();
$query12="INSERT INTO sp_exam_update SET type='AL', exam_id='$exam_id', user_id='$id',date='$curDate', description='$description'";
$sql2=$db->prepare($query12);
$sql2->execute();
if($sql1->execute()){
echo '<h3 style="color:green;">Data Update successfully</h3>';
echo "<meta http-equiv='refresh' content='0'>";
} else {echo "Something Wrong!";}
}
?>
<form class="js-validation-bootstrap form-horizontal" action="" method="post" id="form">
<div class="form-group">
<label class="col-md-2 control-label" for="val-select2">Select Exam</label>
<div class="col-md-10">
<input type="hidden" name="id" id="id">
<select class="js-select2 form-control" name="examname" style="width: 100%;">
<?php
$sql = $db->prepare("SELECT exam_id,exam_name FROM sp_exam");
$sql->execute();
?>
<option selected="selected" id="exam_name">--Select exam--</option>
<?php while($row=$sql->fetch(PDO::FETCH_ASSOC)) { ?>
<option value="<?php echo $row['exam_id']; ?>"><?php echo $row['exam_name']; ?></option>
<?php } ?>
</select>
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-password"> Gender <span class="text-danger">*</span></label>
<div class="col-md-10">
<select name="gender" class="form-control">
<option selected="selected" id="gender">--Select exam--</option>
<option value="M">Male</option>
<option value="F">Female</option>
<option value="O">Others</option>
</select>
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-username">exam id <span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="text" name="exam_id" id="exam_id" readonly="readonly">
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-username">category <span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="text" name="categories" id="categories">
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-username"> height <span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="text" id="height" name="height" value="" >
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-username"> Chest <span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="text" name="chest" id="chest">
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-username"> Race <span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="text" name="race" id="race">
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-username"> Long Jump <span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="text" name="long_jump" id="long_jump">
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-username"> High Jump <span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="text" name="high_jump" id="high_jump">
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-username"> Short put <span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="text" name="short_put" id="short_put">
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-username"> Chance <span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="number" name="chances" id="chances">
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-email">Description<span class="text-danger">*</span></label>
<div class="col-md-10">
<textarea class="ckeditor" name="description" ></textarea>
</div>
</div>
<div class="form-group">
<div class="col-md-10 col-md-offset-2">
<button class="btn btn-sm btn-primary" type="submit" name="submit">Submit</button>
</div>
</div>
</form>
</div>
</div>
</div>
</div>
<script type="text/javascript" charset="utf-8">
function selectData(id) {
var base_url = window.location.origin;
$.ajax('physical_eligibility_list_select.php', {
type: 'POST', // http method
data: { id:id }, // data to submit
success: function (data, status, xhr) {
document.getElementById('id').value= data.id;
document.getElementById('exam_id').value= data.exam_id;
document.getElementById('exam_name').innerHTML = data.exam_name;
document.getElementById('categories').value = data.categories;
document.getElementById('height').value = data.height;
document.getElementById('chest').value = data.chest;
document.getElementById('race').value = data.race;
document.getElementById('long_jump').value = data.long_jump;
document.getElementById('high_jump').value = data.high_jump;
document.getElementById('short_put').value = data.short_put;
document.getElementById('chances').value = data.chances;
document.getElementById('gender').value = data.gender;
if(data.gender=='M'){
document.getElementById('gender').innerHTML="Male";
} else if(data.gender=='F'){
document.getElementById('gender').innerHTML="Female";
} else if(data.gender=='O'){
document.getElementById('gender').innerHTML="Others";
}
},
error: function (jqXhr, textStatus, errorMessage) { }
});
jQuery("#statusModel").modal();
}
function cleanArray(actual) {
var newArray = new Array();
for (var i = 0; i < actual.length; i++) {
if (actual[i]) {
newArray.push(actual[i]);
}
}
return newArray;
}
jQuery(document).ready(function($) {
$('.dates_opted').each(function(index){
var dates=[];
$(this).datepicker({
dateFormat: "yy-mm-dd",
onSelect: function(){
dates=cleanArray(dates);
dates.push($(this).val());
//console.log(dates);
$(this).val(dates);
},showAnim :'clip',
changeYear:true,
changeMonth:true,
yearRange:"2000:2030"
}).keyup(function(e) {
if(e.keyCode == 8 || e.keyCode == 46) {
var datesString=$(this).val().split(",");
dates=[];
for(var i=0 ; i<datesString.length-1;i++){
dates.push(datesString[i]);
}
$(this).blur();
$(this).val(dates);
}
});
});
});
function update(id){
var txt;
var r = confirm("Do you want to change status ?");
if (r == true) {
var str = id;
var array = str.split(',');
var status = array[1];
$.ajax('status_active_physical.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 deletePhysical(id){
var txt;
var r = confirm("Do you want to Delete ?");
if (r == true) {
$.ajax('delete_exam_physical.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'; ?>