<?php 
error_reporting(0);
@session_start();
include("common-left.php"); 
include("config.php");


//if($_SESSION[username]=="")
//{header("../login.php");exit();}
	
 

?>

     
        <!-- START: Main Content-->
        <main>
            <div class="container-fluid">
                <!-- START: Breadcrumbs-->
                <div class="row ">
                   <div class="col-12  align-self-center">
                        <div class="sub-header mt-3 py-3 px-3 align-self-center d-sm-flex w-100 rounded">
                            <a href="top-10-emp-reg.php"> <div class="w-sm-100 mr-auto"><h4 class="mb-0"><b><font color="blue">Top 10 Employees <small>(New Registration)</a></small></font> </b></h4></div>

                      <a href="merged-records.php"> <button type="button" class="btn1"> Back to Record </button></a>
                        </div>
                    </div>
                </div>
                <!-- END: Breadcrumbs-->

                <!-- START: Card Data-->
           <div class="row">
                    <div class="col-12 mt-3">
                        <div class="card">
                            
                            <div class="card-body">
                                <div class="table-responsive">
                                    <table id="example" class="display table dataTable table-striped table-bordered" >
                                        <thead>
                                            <tr>
   <th>Sr</th>
    <th>EmpID</th>
    <th>Employee Name</th>
    <th><center>Registration</center></th>
    <th><center>Branch</center></th>
  </tr>
                                        </thead>
                                        <tbody>
										<?php
									 //$que9="SELECT count(eid) AS RE ,eid FROM record  where ctype='new'  group by employee ORDER BY RE DESC  limit 0,10";	
$que9="SELECT count(eid) AS RE,eid   FROM record  where ctype='new'  group by employee ORDER BY RE DESC  limit 0,10";										 
if (!($page_res9 = mysql_query($que9))) { echo "FOR QUERY: $strsql<BR>".mysql_error(); exit;}
while($row9=mysql_fetch_array($page_res9)){  
 $rcount = $row9[RE];
$eeid = $row9[eid];
$count ++;
 $resultB1 = mysql_query("SELECT * FROM employee where id='$eeid'") or die(mysql_error());
while($rowsB1 = mysql_fetch_array($resultB1)){
	//$emob = $rowsB1[emp_mobile];

	
		
	?>
                                         <tr>
   <td><b><?php echo $count;?> </b></td>
     <td><b><?php echo ucwords($rowsB1[id]);?> </b></td>
    <td><b><?php echo ucwords($rowsB1[emp_name]);?> </b></td>
    <td><center><b> <?php echo $rcount;?>   </b></center></td>
    <td><center><b>         <?php if($rowsB1[branch]=='B1'){?> GNA <?php } ?>
							<?php if($rowsB1[branch]=='B2'){?> RSM <?php } ?>
							<?php if($rowsB1[branch]=='B3'){?> JHU <?php } ?>
							<?php if($rowsB1[branch]=='B4'){?> GNAP <?php } ?>
							<?php if($rowsB1[branch]=='B5'){?> JHUP <?php } ?></b></center></td>
  </tr>
<?php  } }?>	
                                          
                                           
                                        </tbody>
                            
                                    </table>
                                </div>
                            </div>
                        </div> 

                    </div>                  
                </div>
                <!-- END: Card DATA-->
            </div>
        </main>
        <!-- END: Content-->

      
        <!-- START: Back to top-->
        <a href="#" class="scrollup text-center"> 
            <i class="icon-arrow-up"></i>
        </a>
        <!-- END: Back to top-->

        <!-- START: Template JS-->
        <script src="dist/vendors/jquery/jquery-3.3.1.min.js"></script>
        <script src="dist/vendors/jquery-ui/jquery-ui.min.js"></script>
        <script src="dist/vendors/moment/moment.js"></script>
        <!--  <script src="dist/vendors/bootstrap/js/bootstrap.bundle.min.js"></script> -->  
        <script src="dist/vendors/slimscroll/jquery.slimscroll.min.js"></script>
        <script src="dist/vendors/flag-select/js/jquery.flagstrap.min.js"></script> 
        <!-- END: Template JS-->
        
        <!-- START: APP JS-->
        <script src="dist/js/app.js"></script>
        <!-- END: APP JS-->

        <!-- START: Page Vendor JS-->
        <script src="dist/vendors/datatable/js/jquery.dataTables.min.js"></script> 
        <script src="dist/vendors/datatable/js/dataTables.bootstrap4.min.js"></script>
        <script src="dist/vendors/datatable/jszip/jszip.min.js"></script>
        <script src="dist/vendors/datatable/pdfmake/pdfmake.min.js"></script>
        <script src="dist/vendors/datatable/pdfmake/vfs_fonts.js"></script>
        <script src="dist/vendors/datatable/buttons/js/dataTables.buttons.min.js"></script>
        <script src="dist/vendors/datatable/buttons/js/buttons.bootstrap4.min.js"></script>
        <script src="dist/vendors/datatable/buttons/js/buttons.colVis.min.js"></script>
        <script src="dist/vendors/datatable/buttons/js/buttons.flash.min.js"></script>
        <script src="dist/vendors/datatable/buttons/js/buttons.html5.min.js"></script>
        <script src="dist/vendors/datatable/buttons/js/buttons.print.min.js"></script>
        <!-- END: Page Vendor JS-->

        <!-- START: Page Script JS-->        
        <script src="dist/js/datatable.script.js"></script>
		<style>
		.btn1{
			padding:2px;
			background-color:#e91e63;
			color:#fff;
			border-radius:20px;
			padding-left:10px;padding-right:10px;
			border:2px solid #e91e63;
			box-shadow:0 4px 10px 0 rgba(0,0,0,0.3);
			width:240px;
		}
		</style>
        <!-- END: Page Script JS-->
    </body>
   
</html>