<?php
session_start();
require_once("../LoginManager.php");
require_once("../DBManager.php");
include("workdeskmenu.php");
include("header.php");
?>
  <style>

 
 
 .p{
     color: black;
          font-weight: 900;
 }
/* Automatic Serial Number Row */
.css-serial {
     font-weight: 900;
       color: black;
 counter-reset: serial-number; /* Set the serial number counter to 0 */
}
.css-serial td:first-child:before {
 counter-increment: serial-number; /* Increment the serial number counter */
 content: counter(serial-number); /* Display the counter */
}
</style>
 <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">

<table class="table table-bordered table-hover">
                 
                  <tr>
               <td bgcolor="1e73be"><strong><span style="color:white">Name</span></strong></td>
            <td bgcolor="1e73be"><strong><span style="color:white">Punch In </span></strong></td>
              <td bgcolor="1e73be"><strong><span style="color:white">Punch Out </span></strong></td>
            <td bgcolor="1e73be"><strong><span style="color:white">Action</span></strong></td>              
        </tr>
      
                 
<?php
include("dbconnection.php");
 $narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sqlpatient12 = "SELECT * FROM site_users WHERE userno='$harilal'";
	$qsqlpatient12 = mysqli_query($con,$sqlpatient12);
	while($rsn2 = mysqli_fetch_array($qsqlpatient12))
	{
$sqlpatient1 = "SELECT * FROM atten WHERE hsid='$rsn2[entered_by]'";
	$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
	while($rsn = mysqli_fetch_array($qsqlpatient1))
	{
	    $sqlpatient123 = "SELECT * FROM site_users WHERE userno='$rsn[userno]'";
	$qsqlpatient123 = mysqli_query($con,$sqlpatient123);
	while($rsn23 = mysqli_fetch_array($qsqlpatient123))
	{
	    
            echo "
          
            <tr>   <td>&nbsp;$rsn23[name]</td>
              		<td>&nbsp;$rsn[punch]</td>
              		 <td>&nbsp;$rsn[punchsp]</td>
<td>
</td>

    </tr> 
";
}
}
}
?> 



        </table>
        
        <?php
        include'attendanceemployee.php';
        ?>