Server IP : 2a02:4780:3:1378:0:3736:a38e:10 / Your IP : 18.221.201.67 Web Server : LiteSpeed System : Linux sg-nme-web1278.main-hosting.eu 4.18.0-513.11.1.lve.el8.x86_64 #1 SMP Thu Jan 18 16:21:02 UTC 2024 x86_64 User : u926327694 ( 926327694) PHP Version : 7.4.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF Directory (0755) : /home/u926327694/domains/smsoft.in/public_html/demo/ |
[ Home ] | [ C0mmand ] | [ Upload File ] |
---|
<?php session_start(); ?> <?php // Everything below this point in the file is secured by the login system // We can display the user's username to them by reading it from the session array. Remember that because // a username is user submitted content we must use htmlentities on it before displaying it to the user. ?> <?php include "config/config.php"; ?> <?php $res1=mysqli_query($con,"select Class from master where `Class` IS NOT NULL"); $res13=mysqli_query($con,"select Division from master where `Division` IS NOT NULL"); ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1"> <meta name="description" content=""> <meta name="author" content=""> <!-- Bootstrap Core CSS --> <title>Student Attendance List</title> <!-- Bootstrap Core CSS --> <link href="../vendor/bootstrap/css/bootstrap.min.css" rel="stylesheet"> <!-- MetisMenu CSS --> <link href="../vendor/metisMenu/metisMenu.min.css" rel="stylesheet"> <!-- DataTables CSS --> <link href="../vendor/datatables-plugins/dataTables.bootstrap.css" rel="stylesheet"> <!-- DataTables Responsive CSS --> <link href="../vendor/datatables-responsive/dataTables.responsive.css" rel="stylesheet"> <!-- Custom CSS --> <link href="../dist/css/sb-admin-2.css" rel="stylesheet"> <!-- Custom Fonts --> <link href="../vendor/font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css"> <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries --> <!-- WARNING: Respond.js doesn't work if you view the page via file:// --> <!--[if lt IE 9]> <script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script> <script src="https://oss.maxcdn.com/libs/respond.js/1.4.2/respond.min.js"></script> <![endif]--> <style> .others { color:green } .others1 { color:red } </style> </head> <body> <div id="wrapper"> <!-- Navigation --> <nav class="navbar navbar-default navbar-static-top" role="navigation" style="margin-bottom: 0"> <div class="navbar-header"> <button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-collapse"> <span class="sr-only">Toggle navigation</span> <span class="icon-bar"></span> <span class="icon-bar"></span> <span class="icon-bar"></span> </button> <a class="navbar-brand" href="dashboard.php">Student Attendence System</a> </div> <!-- /.navbar-header --> <!-- /.navbar-top-links --> <?php include "header.php"; ?> <!-- /.navbar-static-side --> </nav> <div id="page-wrapper"> <div class="row"> <div class="col-lg-12"> <h1 class="page-header">Attendance Report</h1> </div> <!-- /.col-lg-12 --> </div> <!-- /.row --> <div class="row"> <div class="col-lg-12"> <div class="panel panel-default"> <div class="panel-heading"> Attendance Report </div> <div class="panel-body"> <div class="row"> <form role="form" action="apreport.php" method="post"> <div class="col-lg-6"> <div class="form-group"> <label>Date(From)</label> <?php date_default_timezone_set('Asia/Kolkata'); $timestamp = time(); $date_time = date("Y-m-d", $timestamp); ?> <input type="date" name="date_from" class="form-control" value="<?php echo $date_time; ?>" required /> </div> </div><div class="col-lg-6"> <div class="form-group"> <label>Date(To)</label> <input type="date" name="date_to" class="form-control" value="<?php echo $date_time; ?>" required /> </div> </div> <center> <button type="submit" class="btn btn-default">Submit Button</button> <button type="reset" class="btn btn-default">Reset Button</button></center></form> <!-- /.col-lg-6 (nested) --> <!-- /.col-lg-6 (nested) --> </div> <!-- /.row (nested) --> </div> <!-- /.panel-body --> </div> <!-- /.panel --> </div> <!-- /.col-lg-12 --> </div> <form class="form" style="max-width: none; width: 1005px;" method="post"> <?php if($_SERVER['REQUEST_METHOD'] == 'POST') { $subject=$_POST['subject']; $date_from=$_POST['date_from']; $date_to=$_POST['date_to']; ?> <div class="row"> <div class="col-lg-12"> <div class="panel panel-default"> <div class="panel-heading"> All Student information <b>(<?php echo $subject; echo ", "; echo "From:".$date_from; echo ", "; echo "To:".$date_to; ?>)</b> </div> <!-- /.panel-heading --> <div class="panel-body"> <table width="100%" class="table table-striped table-bordered table-hover" id="example"> <thead> <tr> <tr> <th>Student Name</th> <th>USN</th> <?php if(!$class_res=mysqli_query($con,"SELECT DISTINCT(`date`) FROM `$subject` where `date` >= '$date_from' AND `date` <= '$date_to' ")) { echo("Error description: " . mysqli_error($con)); } while ($class=mysqli_fetch_array($class_res)) { ?> <th><?php echo "$class[0]"; ; ?> </th> <?php } if(!$class_res11=mysqli_query($con,"SELECT DISTINCT(`date`) FROM `$subject` where `date` >= '$date_from' AND `date` <= '$date_to' ")) { echo("Error description: " . mysqli_error($con)); } if(!$heads_res1=mysqli_query($con,"SELECT DISTINCT(`student_id`) FROM `$subject` where `date` >= '$date_from' AND `date` <= '$date_to'")) { echo("Error description: " . mysqli_error($con)); } $count=0; while ($heads1=mysqli_fetch_array($heads_res1)) { while($class1=mysqli_fetch_array($class_res11)) { if(!$class_res111=mysqli_query($con,"SELECT count(`student_id`) FROM `$subject` where `date`='$class1[0]' and `student_id`='$heads1[0]' ")) { echo("Error description: " . mysqli_error($con)); } $class1111=mysqli_fetch_array($class_res111); ?> <?php $count=$count+$class1111[0]; } } ?> <th><?php echo "$count"; ?> </th> <th>% age</th> </tr> </tr> </thead> <?php if(!$heads_res=mysqli_query($con,"SELECT DISTINCT(`student_id`) FROM `$subject` where `date` >= '$date_from' AND `date` <= '$date_to'")) { echo("Error description: " . mysqli_error($con)); } while ($heads=mysqli_fetch_array($heads_res)) { $heads_res3=mysqli_query($con,"SELECT * FROM `student` where `stud_id`='$heads[0]' "); $heads3=mysqli_fetch_array($heads_res3); ?> <tr class="odd gradeX"> <td class="center"><?php echo "$heads3[Name]"; ?> </td> <td class="center"><?php echo "$heads3[USN]";?> </td> <?php $class_res=mysqli_query($con,"SELECT DISTINCT(`date`) FROM `$subject` where `date` >= '$date_from' AND `date` <= '$date_to'"); while ($class=mysqli_fetch_array($class_res)) { $count_res=mysqli_query($con,"SELECT count(`status`) FROM `$subject` where `student_id`='$heads[0]' and `status`='1' and `date`='$class[0]'"); $cnt=mysqli_fetch_array($count_res); ?> <td> <?php echo "$cnt[0]"; ?> </td> <?php } ?><?php $count_res1=mysqli_query($con,"SELECT count(`status`) FROM `$subject` where `student_id`='$heads[0]' and `status`='1' and `date` >= '$date_from' AND `date` <= '$date_to' "); $cnt1=mysqli_fetch_array($count_res1); ?> <td class="center"><?php echo "$cnt1[0]";?> </td> <td class="center"><?php $p=$cnt1[0]*100; $p1=$p/$count; echo (round($p1))."%"; ?> </td> </tr> <?php } ?> </tbody> </table> <!-- /.table-responsive --> <center> </div> <!-- /.panel-body --> </div> <!-- /.panel --> </div> <!-- /.col-lg-12 --> </div> <?PHP } ?> </form> </div> <!-- /#page-wrapper --> </div> <!-- /#wrapper --> <!-- jQuery --> <script src="../vendor/jquery/jquery.min.js"></script> <!-- Bootstrap Core JavaScript --> <script src="../vendor/bootstrap/js/bootstrap.min.js"></script> <!-- Metis Menu Plugin JavaScript --> <script src="../vendor/metisMenu/metisMenu.min.js"></script> <!-- DataTables JavaScript --> <!-- Custom Theme JavaScript --> <script src="../dist/js/sb-admin-2.js"></script> <!-- Page-Level Demo Scripts - Tables - Use for reference --> <script src="report_js/jquery.dataTables.min.js"></script> <script src="report_js/dataTables.bootstrap.min.js"></script> <script src="report_js/dataTables.buttons.min.js"></script> <script src="report_js/buttons.bootstrap.min.js"></script> <script src="report_js/jszip.min.js"></script> <script src="report_js/pdfmake.min.js"></script> <script src="report_js/vfs_fonts.js"></script> <script src="report_js/buttons.html5.min.js"></script> <script src="report_js/buttons.print.min.js"></script> <script src="report_js/buttons.colVis.min.js"></script> <script> $(document).ready(function() { var table = $('#example').DataTable( { lengthChange: false, buttons: [ 'copy', 'excel', 'pdf', 'colvis' ] } ); table.buttons().container() .appendTo( '#example_wrapper .col-sm-6:eq(0)' ); } ); </script> </body> </html>