File: /var/www/nclive/technc/exam_pattern_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="pattern_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>Subject Name</th>
<th>No. Of Question</th>
<th>Marks For Subject</th>
<th>Date</th>
</tr>
</thead>
</table>
<script type="text/javascript">
jQuery(function($) {
jQuery('#pattern_list').dataTable({
"dom" : "Bfrtip",
"pagingType": "full_numbers",
"processing": true,
"serverSide": true,
"responsive": true,
"ajax": "/technc/exam_pattern_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 '<a style="cursor:pointer;" id='+row.id+','+row.status+' onclick="update(id)"><span id="status">Active</span></a>';
} else if (row.status == '0') {
return '<a style="cursor:pointer;" id='+row.id+','+row.status+' onclick="update(id)"><span id="status">Deactive</span></a>';
}
},
},
{"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="deletePattern(id)"><button class="btn btn-danger">Delete</button></a>';
return ret;
}
},
{"data": "exam_name"},
{"data": "subject_name"},
{"data": "no_of_question"},
{"data": "marks_for_subject"},
{"data": "date_added"}
],
"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>
<?php
if(isset($_REQUEST['update'])){
$sub=$_REQUEST['subject'];
$questions=$_REQUEST['que'];
$marks=$_REQUEST['marks'];
$id=$_REQUEST['id'];
$query="UPDATE sp_exam_pattern SET subject_name='$sub',no_of_question='$questions',marks_for_subject='$marks' WHERE id='$id'";
$sql = $db->prepare($query);
if($sql->execute()){
echo '<b><span style="color:green;">Updated</span></b>';
}
else{
echo '<b><span style="color:red;">Something Wrong!</span></b>';
}
}
?>
<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">Add more Subject</h4>
</div>
<div class="modal-body">
<form class="js-validation-bootstrap form-horizontal" method="post" id="serial">
<input type="hidden" name="id" id="id">
<div class="form-group">
<label class="col-md-4 control-label" for="val-username">Subject Name<span class="text-danger">*</span></label>
<div class="col-md-7">
<input class="form-control" type="text" id="subject" name="subject" value="" required/>
</div>
</div>
<div class="form-group">
<label class="col-md-4 control-label" for="val-email"> No. of Questions<span class="text-danger">*</span></label>
<div class="col-md-7">
<input class="form-control" type="number" id="que" name="que" value="">
</div>
</div>
<div class="form-group">
<label class="col-md-4 control-label" for="val-email">Marks for Subject<span class="text-danger">*</span></label>
<div class="col-md-7">
<input class="form-control" type="number" id="marks" name="marks" value="" >
</div>
</div>
<div class="col-md-6"></div>
<button type="submit" class="btn btn-success" name="update">Update</button>
</form>
</div>
</div>
</div>
</div>
</main>
<script type="text/javascript" charset="utf-8">
$(document).ready(function(){
$('.radio').on('change', function() {
if (this.value == 'N') {
$("#normal").css('display','block');
$("#fromto").css('display','none');
} else if (this.value == 'FT') {
$("#fromto").css('display','block');
$("#normal").css('display','none');
}
});
});
function selectData(id) {
$.ajax('exam_question_pattern_update.php', {
type: 'POST',
dataType: 'json',
data: { id:id },
success: function (data) {
document.getElementById("subject").value=data.subname;
document.getElementById("que").value=data.ques;
document.getElementById("marks").value=data.mark;
document.getElementById("id").value=id;
},
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_pattern.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 deletePattern(id){
var txt;
var r = confirm("Do you want to Delete ?");
if (r == true) {
$.ajax('delete_exam_pattern.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'; ?>