<?php 
include ("include/makeSession.php");
$menu_string=mysqli_fetch_array(mysqli_query($con,"select * from admin where id='".$_SESSION["user_id"]."'"))['menuper'];
$menu_arr=explode(',',$menu_string);
if(!in_array('Attendance',$menu_arr)){
	header("location:index.php");
}
$_SESSION['page_name']="Attendance";
include('include/function.php');
include("include/header.php");
include("include/sidebar.php");

?>
<style>
    #loader{
        display:none;
        position:fixed;
        z-index:1000;
        top:0;
        left:0;
        width:100%;
        height:100%;
        background-image:url(images/uploads/loader.gif);
        background-position:50% 50%;
        background-color:rgba(255,255,255,0.6);
        background-repeat:no-repeat;
    }
    body.loading{
        overflow:hidden;
    }
    body.loading #loader{
        display:block;
    }
</style>
<div id="loader"></div>
<div class="content-wrapper">
    <section class="content-header">
        <h1>Student Attendance Report <small></small> </h1>
        <ol class="breadcrumb">
            <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
            <li><a href="#">Student Attendance Report</a></li>
        </ol> 
        <?php if(!empty($_SESSION['msg'])){
        $msg=$_SESSION["msg"];
        echo '<div class="col-md-8">
                <div class="alert alert-success alert-dismissible">
                <a href="#" class="close" data-dismiss="alert" aria-label="close">&times;</a>
                '.$msg.'
                </div>'; 
        $_SESSION["msg"]='';} ?>
    </section>
    <section class="content">
        <div class="row">
            <div class="col-md-12">
                <div class="box box-info">
                    <form method="post" action="" name="addcategory" id="addcategory" enctype="multipart/form-data"  role="form">
                        <div class="box-header">
                            <h3 class="box-title">Student Attendance Form <small></small></h3>
                            <!-- tools box -->
                            <div class="pull-right box-tools">
                                <button class="btn btn-info btn-sm" data-widget="collapse" data-toggle="tooltip" title="Collapse"><i class="fa fa-minus"></i></button>
                                <button class="btn btn-info btn-sm" data-widget="remove" data-toggle="tooltip" title="Remove"><i class="fa fa-times"></i></button>
                            </div><!-- /. tools -->
                        </div><!-- /.box-header -->
                        <div class="box-body pad">
                            <div class="col-md-12">
                                <div class="row">
                                    <div class="form-group col-md-4">
                                        <label>Starting Date *</label>                 
                                        <input name="start" value="<?php if(!empty($_REQUEST['start'])){ echo $_REQUEST['start'];}?>" type="date" class="form-control" required>
                                    </div>
                                    <div class="form-group col-md-4">
                                        <label>Ending Date *</label>                 
                                        <input name="end" value="<?php if(!empty($_REQUEST['end'])){ echo $_REQUEST['end'];}?>" type="date" class="form-control" required>
                                    </div>
                                </div>
                                <div class="row">
                                    <div class="form-group col-md-4">
                                        <input name="submit" value="Search" type="submit" class="form-control btn btn-primary" required>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <div class="box-header">
                            <h3 class="box-title">Attendance Action </h3>
                        </div><!-- /.box-header -->
                        <div class="box-body table-responsive" >
            		  		<table id="example1" class="table table-bordered table-striped">
                                <thead>
                                    <tr>
                                        <?php
                                        $start=$_REQUEST['start'];
                                        $end=$_REQUEST['end'];
                                        $change=$start;
                                        for($i=0;$change<$end;$i++){
                                            $change=date("Y-m-d",strtotime($start." +$i day"));
                                        ?>
                                        <th><?=date("d D",strtotime($change));?></th>
                                        <?php } ?>
                                    </tr>
                                </thead>
                                <tbody>
                                   
                                    <?php
                                    $newarray=array();
                                    
                                        $change=$start;
                                        for($i=0;$change<$end;$i++){
                                            
                                            $change=date("Y-m-d",strtotime($start." +$i day"));
                                            $status=mysqli_fetch_array(mysqli_query($con,"select status from attendance where date='$change'"));
                                            $individual=explode(",",$status[0]);
                                            $sub_array=array();
                                          
                                     
                                           for($k=0;$k<count($individual);$k++)
                                           {
                                            
                                            $unit_arr=explode("_",$individual[$k]);
                                            
                                            for($m=0;$m<count($unit_arr);$m++)
                                           { 
                                               
                                             $sub_array[]=$unit_arr[$m];
                                           
                                           }
                                           }
                                     
                                     
                                   $newarray[]=$sub_array; 
                                   
                                     
                                        }
                                    ?>
                                   
                                   
                              
                                </tbody>
                            </table>
                        </div><!-- /.box-body -->
                    </form>
                </div><!-- /.box -->
            </div><!-- /.col -->
        </div><!-- /.row -->
    </section><!-- /.content -->
</div>
<?php include('include/footer.php');?>
<!-- footer end -->
<script src="plugins/datatables/jquery.dataTables.min.js"  type="text/javascript"></script>
<script src="plugins/datatables/dataTables.bootstrap.min.js"  type="text/javascript"></script>
<script src="bootstrap/js/dataTables.buttons.min.js"  type="text/javascript"></script>
<script src="bootstrap/js/jszip.min.js"  type="text/javascript"></script>
<script src="bootstrap/js/pdfmake.min.js"  type="text/javascript"></script>
<script src="bootstrap/js/vfs_fonts.js"  type="text/javascript"></script>
<script src="bootstrap/js/buttons.html5.min.js"  type="text/javascript"></script>
<script src="bootstrap/js/buttons.print.min.js"  type="text/javascript"></script>
<script src="bootstrap/js/buttons.colVis.min.js"  type="text/javascript"></script>
<script src="bootstrap/js/buttons.flash.min.js"  type="text/javascript"></script>
<script  type="text/javascript">
$(document).ready(function() {
    var table=$('#example1').DataTable({
        dom: 'Bfrtip',
        columnDefs: [
            {
                targets: 1,
                className: 'noVis'
            }
        ],
        buttons: [
            {
                extend: 'colvis',
                columns: ':not(.noVis)'
            }
        ],
		 buttons: [
		     'copy',
            {
                extend: 'pdf',
                messageTop: function () {
                    return "Report from "+$("input[name='start']").val()+" to "+$("input[name='end']").val();
                },
                messageBottom: null
            },
            {
                extend: 'print',
                messageTop: function () {
                    return "Report from "+$("input[name='start']").val()+" to "+$("input[name='end']").val();
                },
                messageBottom: null,
                exportOptions: {
                    stripHtml:false,
                    stripNewlines: false
                }
            },
            { extend: 'csv', text: 'Export to CSV',
                messageTop: function () {
                    return "Report from "+$("input[name='start']").val()+" to "+$("input[name='end']").val();
                },
                messageBottom: null },
    		 { extend: 'excel', text: 'Export to Excel',
                messageTop: function () {
                    return "Report from "+$("input[name='start']").val()+" to "+$("input[name='end']").val();
                },
                messageBottom: null }
        ]
		
    });
// Do something with the 'data' variable
});
</script>
<script>
$(document).ready(function(){
    $("select[name='course_id']").change(function(){
        var course_id=$(this).val();
        $.ajax({  
            type: "POST",  
            url: "json_session.php",  
            data: {'course_id': course_id}, 
            dataType: "json",	
            beforeSend: function(){
                $("body").addClass("loading");
            },
            success: function(response) { 
                $("select[name='session_id']").html("<option value=''>- - Select - -</option>");
                $("select[name='session_id']").append(response);
            },
            complete:function(data){
                $("body").removeClass("loading");
            }
        });
    });
});
</script>