Viewing file:  mark_attendance.php (8.33 KB) -rw-rw-r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
include 'header.php';
$s=$package_id=$val='';
if(isset($_GET['s']))
{
$s = $_GET['s'];
}
if(isset($_GET['id']))
{
$package_id = $_GET['id'];
$val = $_GET['id'];
}
?>
<style type="text/css">
.swal-body {
background-color: rgba(63,255,106,0.69);
border: 3px solid red;
}
.sweet-alert p {
color: #797979;
font-size: 16px;
text-align: center;
font-weight: 300;
position: initial;
text-align: left;
float: none;
margin: 0px 27px 0px;
padding: 0;
line-height: normal;
}
.sweet-alert .sa-icon {
width: 80px;
height: 66px;
}
.project-banner, .bnner_sec-new, .bnner_sec-rs.gallery {
margin: 0 0 0px;
}
.login-box {
margin: 0px auto;
}
.login-box {
padding: 24px;
}
.login-reg {
padding: 1px 0px;
}
button.btn.main-btn.btn-block.mb-3.skillactz-bluebg:hover {
background: #fff;
color: #1a57b3;
}
</style>
<style type="text/css">
.grids-bx.placBx
{
height: 260px;
}
</style>
<section class="project-banner">
<div class="container">
<div class="banner-sec">
<div class="projectheading">
<h3>Mark Attendance</h3>
</div>
</div>
</div>
</section>
<section>
<div class="container">
</div>
</div>
</div>
</section>
<section class="dashboard">
<div class="container" style="max-width: 960px;float: right;">
<div class="col-lg-12" style="padding: 10px">
<select class="form-control" style="width:40%;" id="course">
<option value="">Select Course</option>
<?php
echo $u_id;
$cart="SELECT cd.*,en.`admin_status`,en.course_id FROM course_details cd LEFT JOIN enrolldetails en ON cd.`id`=en.`course_id` WHERE en.`user_id`=$u_id ORDER BY en.enrollid DESC ";
$query = mysqli_query($con, $cart) or die("database error:" . mysqli_error($con));
echo $count = $query->num_rows;
if ($count > 0) {
while ($row = $query->fetch_assoc()) {
$my_packages[] = $row['course_id'];
$cart_new="SELECT name from course_details where id=".$row['course_id']." ";
$query_new = mysqli_query($con, $cart_new) or die("database error:" . mysqli_error($con));
$count_new = $query_new->num_rows;
if ($count_new > 0) {
$query_new = mysqli_query($con, $cart_new) or die("database error:" . mysqli_error($con));
while ($row2_new = $query_new->fetch_assoc()) {
?>
<!-- <option value="<?php echo $row['course_id']; ?>"><?php echo $row2_new['name']; ?></option> -->
<option value="<?php echo $row2_new['name']; ?>"><?php echo $row2_new['name']; ?></option>
<?php
}
}
}
}
?>
</select>
</div>
<div class="col-lg-12" style="padding: 10px">
<select class="form-control" style="width:40%;" id="staff">
<option value="">Select Staff</option>
<?php
$staff="SELECT name,id,email from admin where role='staff' ";
$query_new_s = mysqli_query($con, $staff) or die("database error:" . mysqli_error($con));
$count_new_s = $query_new_s->num_rows;
if ($count_new_s > 0) {
$query_new_s = mysqli_query($con, $staff) or die("database error:" . mysqli_error($con));
while ($row2_new_s = $query_new_s->fetch_assoc()) {
?>
<!-- <option value="<?php echo $row2_new_s['id']; ?>"><?php echo $row2_new_s['name']; ?></option> -->
<option value="<?php echo $row2_new_s['name']; ?>--<?php echo $row2_new_s['email']; ?>"><?php echo $row2_new_s['name']; ?></option>
<?php
}
}
?>
</select>
</div>
<div class="col-lg-12" style="padding: 10px">
<input type="date" id="current_date" class="form-control" style="width:40%;">
</div>
<div class="col-lg-12" style="padding: 10px">
<textarea col="4" row="10" class="form-control" style="width:40%;" id="comments">
</textarea>
</div>
<div class="col-lg-12" style="padding: 10px;margin-left: 10%;">
<button onclick="submit_attendance()" style=" border: 1px solid #105ea3;
padding: 6px 15px;
min-width: 110px;
text-align: center;
color: #fff;
font-size: 13px;
border-radius: 60px;
display: inline-block;
margin: 6px 10px 0 0;
background: #105ea3;">Submit your Attendance</button>
</div>
</div>
</section>
<?php
// $sql = "select * from student_reg where user_id='$u_id'";
$sql = "select * from user_details where user_id='$u_id'";
$result = $con->query($sql);
$row = $result->fetch_assoc();
$uname = $row['name'];
$email = $row['email'];
//$uname = str_replace(' ', '', $uname);
?>
<input type="hidden" name="uname" id="uname" value="<?php echo $uname; ?>">
<input type="hidden" name="s_email" id="s_email" value="<?php echo $email; ?>">
<input type="hidden" name="s" id="student_id" value="<?php echo $u_id; ?>">
<?php include 'footer.php'; ?>
<?php $baseurl="https://srishticampus.com/"; ?>
<script type="text/javascript">
function submit_attendance()
{
var course=$("#course").val();
// alert(course);
// return false;
var staff_f=$("#staff").val();
const myArray = staff_f.split("--");
var staff=myArray[0];
var staff_email=myArray[1];
// alert(staff);
// alert(staff_email);
var current_date=$("#current_date").val();
//alert(current_date);
var comments=$("#comments").val();
//alert(comments);
var student_id=$("#student_id").val();
var student_email=$("#s_email").val();
var uname=$("#uname").val();
if(course=='')
{
swal('Please Select Course!!','','error');
}
else if(staff=='')
{
swal('Please Select Staff!!','','error');
}
else if(current_date=='')
{
swal('Please Select Date!!','','error');
}
else
{
var data = {
course: $("#course").val(),
date: $("#current_date").val(),
comments: $("#comments").val(),
staff: staff,
staff_email: staff_email,
student_id: $("#student_id").val(),
student_email:$("#s_email").val(),
uname:$("#uname").val()
}
$.ajax({
url: '<?php echo $baseurl; ?>save_attendance.php',
type: "POST",
data: data,
success: function (response) {
if(response==1){
swal('Successfully Added !!','','success');
}else{
swal('Already Marked !!','','error');
}
}
});
}
}
</script>
|