Viewing file:  new_requests.php (15.07 KB) -rw-rw-r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php session_start();
include('includes/header.php');
?>
<?php
// Storing session data
$_SESSION["role"];
if(!isset($_SESSION["role"]))
{
header("location:admin_login.php");
?>
<script type="text/javascript">
window.location.href = "admin_login.php";
</script>
<?php
}
else
{
?>
<div class="page-container">
<div class="left-content">
<div class="mother-grid-inner">
<!--header start here-->
<div class="header-main">
<div class="header-left">
<div class="logo-name">
<a href="admin_index.php"> <h3>SICS ADMIN</h3>
</br>
</a>
</div>
<div class="clearfix"> </div>
</div>
<!--notification menu end -->
<div class="profile_details">
<ul>
<li class="dropdown profile_details_drop">
<a href="#" class="dropdown-toggle" data-toggle="dropdown" aria-expanded="false">
<div class="profile_img">
<span class="prfil-img"><!-- <img src="images/p1.png" alt=""> --> </span>
<div class="user-name">
<p>Srishti Innovative</p>
<span><?php echo $_SESSION["name"];?></span>
</div>
<i class="fa fa-angle-down lnr"></i>
<i class="fa fa-angle-up lnr"></i>
<div class="clearfix"></div>
</div>
</a>
<ul class="dropdown-menu drp-mnu">
<!-- <li> <a href="#"><i class="fa fa-cog"></i> Settings</a> </li>
<li> <a href="#"><i class="fa fa-user"></i> Profile</a> </li> -->
<li> <a href="logout.php"><i class="fa fa-sign-out"></i> Logout</a> </li>
</ul>
</li>
</ul>
</div>
</div>
<div class="inner-block">
<h3 style="text-align: left;color: #337ab7;margin-bottom: 1%;">Course Requests</h3>
<?php
$query = "select ud.name,ud.email,ud.phone,en.*,date(en.created_at) as encreated_at from enrolldetails en left join user_details ud on en.user_id=ud.user_id order by en.enrollid desc";
$result = $con->query($query);
?>
<div class="table-responsive">
<table id="requests" class="table table-striped table-bordered table-condensed">
<thead style="background: #7ab9f3;">
<tr>
<th>Sl.No</th>
<th>Name</th>
<th>Email</th>
<th>Contact</th>
<th>Course</th>
<th>Cost</th>
<th>Payment status</th>
<th>Purchase Number</th>
<th>Date</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
$i=1;
while ($row = $result->fetch_assoc()) {
?>
<tr id="row_<?php echo $row["enrollid"]; ?>">
<td><?php echo $i; ?></td>
<td><?php echo $row["name"]; ?></td>
<td><?php echo $row["email"]; ?></td>
<td><?php echo $row["phone"]; ?></td>
<td><?php echo $row["course"]; ?></td>
<td><?php
$amount = ltrim($row["amount"], "0");
echo $amount ?></td>
<td><?php echo $row["paymentstatus"]; ?></td>
<td><?php echo $row["enrollid"]; ?></td>
<td>
<?php echo $row["encreated_at"]; ?>
<!-- <?php //if($row["encreated_at"]!='0000-00-00'){ echo date('d-m-Y',strtotime($row["encreated_at"])); } ?> -->
</td>
<td>
<?php if($row["admin_status"]==0){ ?>
<!-- <button type="button" data-id="<?php echo $row["enrollid"]; ?>" class="btn btn-success statuschange">Activate </button> -->
<a href="" data-toggle="modal" data-target="#myModal" class="btn btn-success" > Activate</a>
<div id="myModal" class="modal fade" role="dialog">
<div class="modal-dialog">
<!-- Modal content-->
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">×</button>
<h4 class="modal-title">Upload Batch Plan</h4>
</div>
<div class="modal-body">
<form action="activate_action.php" method="post">
<input type="hidden" name="enrollid" value="<?php echo $row["enrollid"]; ?>">
<label> Days</label><br><br>
<input type="checkbox" name="days[]" value="Sunday">Sunday
<input type="checkbox" name="days[]" value="Monday">Monday
<input type="checkbox" name="days[]" value="Tuesday">Tuesday
<br><input type="checkbox" name="days[]" value="Wednesday">Wednesday
<input type="checkbox" name="days[]" value="Thursday">Thursday
<input type="checkbox" name="days[]" value="Friday">Friday <input type="checkbox" name="days[]" value="Saturday">Saturday
<br><br>
<label>Start Date</label><br><br><input type="date" name="startdate" placeholder="Start date">
<br><br>
<label>End Date</label><br><br><input type="date" name="enddate" placeholder="End date">
<br><br>
<div class="field_wrapper">
<label>Exam Date</label><br><br><input type="date" name="exam_date[]" placeholder="Exam date"><a href="javascript:void(0);" class="add_button" title="Add field" style="font-size: 29px;color: black;text-align: center;">+</a>
</div>
<br><br>
<input type="submit" class="btn btn-primary" name="submit" value="Submit">
</form>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
</div>
</div>
</div>
</div>
<?php } else{?>
<button type="button" data-id="<?php echo $row["enrollid"]; ?>" class="btn btn-warning statuschange">Deactivate </button>
<?php }?>
<br><br>
<button type="button" data-id="<?php echo $row["enrollid"]; ?>" class="btn btn-danger delete" >Delete </button>
<br><br>
<?php
$uid=$row["user_id"];
$sql11 = "select * from student_reg where user_id='$uid'";
$result11 = $con->query($sql11);
// print_r($result11);
// $row11 = $result11->fetch_assoc();
while ($row11 = $result11->fetch_assoc()) {
$uname = $row11['name'];
$uname = str_replace(' ', '', $uname);
if($uname=='')
{
echo"Profile Not Completed";
}
else
{
?>
<a target="_blank" href="https://www.srishticampus.com/Profile/<?php echo $uname.'_'.$uid;?>"><button type="button" data-id="<?php echo $row["enrollid"]; ?>" class="btn btn-info" >Generate Resume </button></a>
<?php
}
}
?>
</td>
<?php
$i++;
}
?>
</tr>
</tbody>
</table>
</div>
</div>
</div>
<!--heder end here-->
<!-- script-for sticky-nav -->
<div class="inner-block">
</section>
</div>
</div>
</div>
<!--slider menu-->
<?php include('includes/sidebar.php'); ?>
<!--slide bar menu end here-->
<?php include('includes/footer.php'); ?>
<?php
if(isset($_GET['id']))
{
$t = $_GET['id'];
if($t=='success')
{
?>
<script type="text/javascript">
//alert("Course request activated Successfully!");
swal("Course request activated Successfully!");
</script>
<script type="text/javascript">
window.location = 'https://www.srishticampus.com/admin/new_requests.php';
</script>
<?php
}
}
?>
<script>
$(document).ready(function () {
$('#requests').DataTable({
"fnInitComplete": function(){
// Disable TBODY scoll bars
$('.dataTables_scrollBody').css({
'overflow': 'hidden',
'border': '0'
});
// Enable TFOOT scoll bars
$('.dataTables_scrollFoot').css('overflow', 'auto');
$('.dataTables_scrollHead').css('overflow', 'auto');
// Sync TFOOT scrolling with TBODY
$('.dataTables_scrollFoot').on('scroll', function () {
$('.dataTables_scrollBody').scrollLeft($(this).scrollLeft());
});
$('.dataTables_scrollHead').on('scroll', function () {
$('.dataTables_scrollBody').scrollLeft($(this).scrollLeft());
});
},
"scrollX": true,
"scrollCollapse": true,
"colResize": {
"tableWidthFixed": true,
//"handleWidth": 10,
"resizeCallback": function(column)
{
}
},
"searching": true,
"paging": true,
"info": true,
"deferRender": true,
"sScrollX": "190%"
});
var navoffeset = $(".header-main").offset().top;
$(window).scroll(function () {
var scrollpos = $(window).scrollTop();
if (scrollpos >= navoffeset) {
$(".header-main").addClass("fixed");
$(".sidebar-menu").addClass("fixed");
} else {
$(".header-main").removeClass("fixed");
$(".sidebar-menu").removeClass("fixed");
}
});
$(document).on("click",".delete",function() {
var id= $(this).data('id');
swal({
title: "Are you sure?",
text: "You want to delete this request?",
type: "warning",
showCancelButton: true,
confirmButtonColor: "#DD6B55",
confirmButtonText: "Yes",
cancelButtonText: "No",
closeOnConfirm: false,
closeOnCancel: false
},
function(isConfirm){
if (isConfirm) {
$.ajax({
url: 'delete_request.php',
type: "POST",
data: { id:id },
success: function(response) {
if(response!=0){
swal("Successfully deleted !","","success");
$('#row_'+id).hide();
} else{
swal("Something went wrong !", "", "error");
}
}
});
} else {
swal("Cancelled", "", "error");
}
});
});
$(document).on("click",".statuschange",function() {
var id= $(this).data('id');
var current=$(this);
$.ajax({
url: 'statuschange_request.php',
type: "POST",
data: { id:id },
success: function(response) {
if(response==1){
$(current).removeClass("btn-success");
$(current).addClass("btn-warning");
$(current).html("Deactivate");
swal("Successfully Activated !","","success");
} else{
$(current).removeClass("btn-warning");
$(current).addClass("btn-success");
$(current).html("Activate");
swal("Successfully Deactivated !","","success");
}
}
});
});
var x = 1;
var maxField = 3;
//Input fields increment limitation
var addButton = $('.add_button'); //Add button selector
var wrapper = $('.field_wrapper'); //Input field wrapper
var c=2
//New input field html
//Initial field counter is 1
//Once add button is clicked
$(addButton).click(function(){
//Check maximum number of input fields
var fieldHTML = '<br><br><div class="no"><input type="date" name="exam_date[]" placeholder="Exam date"><a href="javascript:void(0);" class="remove_button" style="font-size: 29px;color: black;text-align: center;">-</a></div>';
if(x <= maxField){
x=x+1;
c++; //Increment field counter
$(wrapper).append(fieldHTML); //Add field html
}
});
//Once remove button is clicked
$(wrapper).on('click', '.remove_button', function(e){
e.preventDefault();
$(this).parents('.no').remove(); //Remove field html
x--;
//Decrement field counter
});
});
</script>
<?php
}
?>
|