<?php session_start();
include("connection.php");
error_reporting(E_ERROR | E_PARSE); 
if($_SESSION["user_id"]==true) {
} else {?><script> window.location.href='login/'; </script> <?php } 


 $bill_no=$_REQUEST["bill_no"];


 $bill=mysqli_query($con,"select * from onshop where `bill_no`='".$bill_no."' and `status`='active' and `bill_status`='pending' "); $billr=mysqli_fetch_array($bill,MYSQLI_ASSOC);
  $billn=mysqli_num_rows($bill);

?>

<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<!-- /Added by HTTrack --><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<!--
<link type="text/css" rel="stylesheet" href="javax.faces.resource/themeab55.css?ln=primefaces-aristo" />
<link type="text/css" rel="stylesheet" href="javax.faces.resource/dist-butterfaces-bootstrap.min4e5d.css?ln=butterfaces-dist-css" />
-->
<link type="text/css" rel="stylesheet" href="javax.faces.resource/css/default.css" />
<link type="text/css" rel="stylesheet" href="javax.faces.resource/css/cssLayout.css" />
<link type="text/css" rel="stylesheet" href="javax.faces.resource/css/bootstrap.css" />
<link type="text/css" rel="stylesheet" href="javax.faces.resource/css/bootstrap.min.css" />
<link type="text/css" rel="stylesheet" href="javax.faces.resource/css/popup.css" />
<link type="text/css" rel="stylesheet" href="javax.faces.resource/css/menu.css" />
<!--
<script type="text/javascript" src="javax.faces.resource/butterfaces-all-with-jquery-and-bootstrap-bundle.min686a.js?ln=butterfaces-dist-bundle-js"></script>
<script type="text/javascript" src="javax.faces.resource/js/jquery-3.4.0.min.js"></script>
<script type="text/javascript" src="javax.faces.resource/js/bootstrap.js"></script>
<script type="text/javascript" src="javax.faces.resource/js/jquery-1.11.2.js"></script>
<script type="text/javascript" src="javax.faces.resource/js/jssor.slider-27.5.0.min.js"></script>
<script type="text/javascript" src="javax.faces.resource/jquery8490.js?ln=js"></script>
<script type="text/javascript" src="javax.faces.resource/menu8490.js?ln=js"></script>
<script type="text/javascript" src="javax.faces.resource/js/canvasjs.min.js"></script>
        
  -->     
        <script type="text/javascript">
            $(function() {
                $('ul.nav li.dropdown').hover(function() {
                    $(this).find('.dropdown-menu').stop(true, true).delay(100).fadeIn(500);
                }, function() {
                    $(this).find('.dropdown-menu').stop(true, true).delay(100).fadeOut(500);
                });
            });
        </script>
        <script type="text/javascript">
            $(function() {
                $("#notice").fadeIn("slow").append('');
                $(".dismis").click(function() {
                    $("#notice").fadeOut("slow");
                });
            });
        </script>
		
<script>
function lfn_SelectSection(p_Class)
    {
        document.getElementById('cusname').disabled=false;
		
  
        $.ajax({
		
                    type: "GET",
                    url: "ajax_location.html?classID=" + p_Class,
                    success: function(state) {
                    document.getElementById('cusname').innerHTML=state;    
					
                    }
        });
		
	 
		
		
    }

</script>
<style> 
        input.largerCheckbox { 
            width: 20px; 
            height: 20px; 
			
        } 
    </style> 
        <title>Katha O Cafe</title></head><body>

        <div id="top">


                    <div class="container-fluid text-center" style="margin-left: 5px"> 
                        <div class="row">
                            <div class="col-sm-1">
							<!-- Logo -->
							
							
                            </div>                           
                                       
                           
                        </div>
                    </div>

                    <!-- Menu start  -->

                    <nav class="navbar navbar-expand-lg header-m" role="navigation">
                        <div class="container-fluid">
                            <div class="navbar-header">
                                <button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1">
                                    <span class="sr-only">Toggle navigation</span>
                                    <span class="icon-bar" style="background-color: #fff;"></span>
                                    <span class="icon-bar" style="background-color: #fff;"></span>
                                    <span class="icon-bar" style="background-color: #fff;"></span>
                                </button>
                                <a class="navbar-brand" href="#"></a>
                            </div>

                            <!-- Collect the nav links, forms, and other content for toggling -->
                            <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
                                <?php include("include/header.php"); ?>
                            </div>

                            <!-- /.navbar-collapse -->
                        </div>
                        <!-- /.container-fluid -->
                    </nav>

        </div>

        <div id="content" class="center_content" style="background-image:url(wall.jpg)">

                    <div class="container-fluid text-center">    
                        <div class="row">
                            <div class="col-sm-2" style="padding-right: 0px;">
							
							
							
							
							
                                <?php include("include/left.php"); ?>

                                </div>

                            </div>

                            <div class="col-sm-8" style="padding-right: 2px; padding-left:2px;">

                                <div class="row" >
                                    <div class="col-sm-12" >

                                        <div class="panel panel-primary" style="background-color: rgb(186,233,254);border: 1px solid #000; margin-bottom: 0px; background-image:url(wall.jpg) ">
                                            <div class="panel-heading" style="font-size: 20px; font-family: serif; background-color: #007de8; color:#CCFF00"> <b>Edit Attendance</b></div>
                                        <div class="panel-body" style="text-align: justify;padding-bottom: 0px; padding-top: 6px;"><p style="font-family: Cambria;"><strong>
										 <font color="#FF0000"> <h4><b>Select Date : <input type="date" style="width:40%; height:30px;" onChange="att_date()" id="at_date" value="<?php echo $_REQUEST['att_date']; ?>"></b></h4></font>
										</strong>
<script>
function att_date() {
var v=document.getElementById("at_date").value;
 window.location.href="?att_date="+v;
}
</script>
<form method="post" action="#" >
<table style="width:100%" border="1">
<tr style="background-color:#CC6600; color:#FFFFFF; height:30px;"> <td align="center">Sl No</td><td align="center">Emp. Name</td><td align="center">Designation</td><td align="center">Present</td><td align="center">Absent</td><td align="center">Half Day</td><td align="center">Time</td>
</tr>
 <?php $i=1; if($_REQUEST["att_date"]!="") { $uid=$_REQUEST["emp_id"]; $row_id=$_REQUEST["row_id"]; $att_type=$_REQUEST["att_type"];   $e=mysqli_query($con,"select * from user where `id`='".$uid."' "); } else {} while($er=mysqli_fetch_array($e,MYSQLI_ASSOC)) { ?>
 <tr>
        										     <td align="center"><b><?php echo $i; ?></b></td>
                                                     <td>&nbsp;<b><?php echo $er["name"]; ?></b>
													 <input type="hidden" name="u_id<?php echo $i; ?>" value="<?php echo $er["id"]; ?>">
													 </td>
                                                     
                                                     <td>&nbsp;<b><?php echo $er["type"]; ?></b> </td>
                                                     
                                           
                                                    <td>&nbsp;
                                                      <input type="radio" name="present<?php echo $i; ?>" value="1" <?php if($att_type=="1") {?> checked="checked" <?php } else {}?>> <font color="green"><b>Present</b></font> 
                                                    </td>
                                                    <td>&nbsp;
                                                      <input type="radio" name="present<?php echo $i; ?>" value="0" <?php if($att_type=="0") {?> checked="checked" <?php } else {}?>> <font color="red"><b>Absent</b></font> </td>
                                                     <td>&nbsp;
													  <input type="radio" name="present<?php echo $i; ?>" value="2" <?php if($att_type=="2") {?> checked="checked" <?php } else {}?> > <font color="brown"><b>Half Day</b></font>
                                                    </td>
                                                     <td>&nbsp;
													  <input type="time" name="time<?php echo $i; ?>" >
                                                    </td>
  </tr>

                                        <?php $i++; } ?>
										<input type="hidden" name="total_row" value="<?php echo $i-1; ?>">
<tr style="height:38px; background-color:#FFFF99"><td colspan="7" align="center"><input type="submit" name="click" value="Update" style="width:100px; height:30px;"></td></tr>
</table>
</form>




<?php   if(isset($_POST["click"]))
        {
			$n=$_POST["total_row"];
			$date=$_REQUEST["att_date"];
			$month=substr($date,5,2);
$year=substr($date,0,4);

			for($i=1;$i<=$n;$i++) {
$emp_id=$_POST["u_id".$i];
$uid=$_REQUEST["id"];
$present=$_POST["present".$i];
$time=$_POST["time".$i];
mysqli_query($con,"update attendance set `present`='".$present."',`time`='".$time."' where `id`='".$row_id."'");
//mysqli_query($con,"insert into attendance (`emp_id`,`date`,`month`,`year`,`present`) values ('".$emp_id."','".$date."','".$month."','".$year."','".$present."')");

			}



?><script>
alert("Successfully Updated");
window.location.href="show_attendance.php";
</script><?php 
	
			
		} ?>			









<hr>

			


<p>&nbsp;</p>					 
				
					 
					 
					 
	<!--				 					
											 <select name="class" id="class" class="form-control" onChange="lfn_SelectSection(this.value);">
                                            <option value="">--- Please Select Class ----</option>
                                             <option value="A">A</option>
											 <option value="B">B</option>
											 <option value="C">C</option>
                                             </select>
											Section
											 <select type="text" name="secname" id="secname" class="form-control" >
                                        	<option value="0">------select Section_o------</option>

                                        </select> -->	
										
                                                    </strong></p></div>
                                        </div>



                                    </div>
                                </div>

                            <!--   <div class="well" style="padding: 5px;background-color: rgb(186,233,254); border: 1px solid #000; margin-bottom: 1px;">
                                    <div class="row">
                                        
                                        
                                       
                                        
                                        
                                        
                                    </div> 
                                </div>-->
                                <div class="row">
                                   <!-- <div class="col-sm-2">
                                        <div class="panel panel-primary" style="background-color: antiquewhite;">
                                            <div class="panel-body" style="border: 1px solid #000"><img src="javax.faces.resource/school-educatione0f8.png?ln=img" width="50" />  </div>
                                            <div class="panel-footer" style="padding: 1px 2px; background-color: #007de8; font-size: 13px;"><a href="../e_Pension/AdminLogin.html"> School Education Department Users</a>  </div>
                                        </div>
                                    </div>
                                    <div class="col-sm-2">
                                        <div class="panel panel-primary" style="background-color: #7c5a5e;">
                                            <div class="panel-body" style="border: 1px solid #000"><img src="javax.faces.resource/villagee0f8.png?ln=img" width="50" /></div>
                                            <div class="panel-footer" style="padding: 1px 2px;background-color: #007de8; font-size: 13px;"><a href="../e_Pension/AdminLogin.html">P &amp; R D Department Users</a>  </div>
                                        </div>
                                    </div>
                                    <div class="col-sm-2">
                                        <div class="panel panel-primary" style="background-color: #f6f191;">
                                            <div class="panel-body" style="border: 1px solid #000"><img src="javax.faces.resource/librarye0f8.png?ln=img" width="50" /></div>
                                            <div class="panel-footer" style="padding: 1px 2px;background-color: #007de8; font-size: 13px;"><a href="../e_Pension/AdminLogin.html">UD &amp; MA Department Users</a>  </div>
                                        </div>
                                    </div>
                                    <div class="col-sm-2">
                                        <div class="panel panel-primary" style="background-color: #fff;">
                                            <div class="panel-body" style="border: 1px solid #000"><img src="javax.faces.resource/images6e0f8.png?ln=img" width="50" /></div>
                                            <div class="panel-footer" style="padding: 1px 2px;background-color: #007de8; font-size: 13px;"><a href="../e_Pension/AdminLogin.html"> MEE &amp; LS Department Users</a>  </div>
                                        </div>
                                    </div>
                                    <div class="col-sm-2">
                                        <div class="panel panel-primary" style="background-color: #ffdc6a;">
                                            <div class="panel-body" style="border: 1px solid #000"><img src="javax.faces.resource/treasurye0f8.png?ln=img" width="50" /></div>
                                            <div class="panel-footer" style="padding: 10px 5px;background-color: #007de8; font-size: 13px;"><a href="../e_Pension/AdminLogin.html">Treasury Users</a>  </div>
                                        </div>
                                    </div>
                                    <div class="col-sm-2">
                                        <div class="panel panel-primary" style="background-color: #5cfef2;">
                                            <div class="panel-body" style="border: 1px solid #000"><img src="javax.faces.resource/users-groupe0f8.png?ln=img" width="50" /></div>
                                            <div class="panel-footer" style="padding: 1px 2px;background-color: #007de8; font-size: 12px;"><a href="../e_Pension/AdminLogin.html">Other Departments Users</a>  </div>
                                        </div>
                                    </div>    -->
                                </div>
                            
                               

                            </div>
                            <div class="col-sm-2" style="padding-left:0px;">
                                <?php include("include/right.php"); ?>
                            </div>                     
                        </div>

                    </div>
</form>
        </div>


       <?php include("include/footer.php"); ?>

                       

		
		
		</body>



</html>