<?php
session_start();
error_reporting(0);
include("class.php");
include_once("database_connection.php");
date_default_timezone_set('Asia/Calcutta');

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Dashboard:Banking</title>
<script language="javascript" type="text/javascript" src="datetimepicker.js"></script>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<!--<meta http-equiv="refresh" content="120" url="ge_dashboard.php" />-->


<link type="text/css" href="menu/menu_admin.css" rel="stylesheet" />
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js"></script>
<script language="JavaScript" src="newdate/calendar_us.js"></script>
  <link rel="stylesheet" href="newdate/calendar.css">
    <script type="text/javascript" src="menu/menu.js"></script>
	<style>
	.borderHeader{
	border:1px;
	border-style:solid;
	height:75px;
	background-color:white;
	text-align:center;
	width:100%;
}
.centerimage{
	margin-top:20px;
}
.pagename
{
	text-align:center;
	margin-top:-60px;
	color:#8B0000;
	height:100px;
	
	
}

.airtellogo
{
   margin-top:-42px;

}
#searchbutton  {
	background-color:#228B22;
	color:#FFF;
	padding:5px;
	border-radius:8px;
	font-weight:bold;
}
#searchbutton:hover  {
	background-color:#228B22;
	color:#FFF;
	padding:5px;
	border-radius:8px;
}
#salutation{
	margin-top:-10px;
	text-align:CENTER;

}
/*Footer Container Start*/
#footer-container { width:100%; height:25px; background:#343434; color:#FFFFFF; font-size:15px; text-align:center; padding-top:8px;}
/*Footer Container End*/
  </style>
  
</head>
<body>

<div class="borderHeader">
	<div align=left><img src="images/kmspl.PNG" /></div><div class="pagename"><h2>DASHBOARD NATIONAL FIELD ALLOCATION</h2></div>
</div>
<div class="content" >
<table  border="0" class="maintable" align="center" cellspacing="6" width="100%" > 
<tr>
<td colspan="7" align="center"><table border="0" width="100%" cellpadding="0" cellspacing="0" >
  <tr><td>
    
   <?php 
  
	if(($_SESSION['uniqe_id']=='S'))
	{
	include("menu/menu_superadmin.php");
	}
	if(($_SESSION['uniqe_id']=='A') or ($_SESSION['uniqe_id']=='T'))
	{
	include("menu/menu_admin.php");
	}
	else
	{
	}
   ?>	

 </td> </tr>
</table>

                    
</td>
</tr>

   <tr>
  
<form action="" method="post">

<?php
$sql="select distinct(zone),count(id) as num from allocation_tbl where status='4' and zone !=''  group by zone order by zone asc";
$result=mysqli_query($conn,$sql);

?>
<table style="width:100%"   align="center"> 
	<tr>
	<td align="center" style="width:85%;">
	<table  border="1" bgcolor="white" style="width:85%;" class="table table-striped" > 
	<thead>
	
				<?php
				$i=0;
				while($data=mysqli_fetch_array($result))
				{
				$zone=$data['zone'];
				if($i%4==0) {
	echo "<tr>";
	}
	                        ?>
				<th class="center" height="75" width="75" ><a href="" onClick="window.open('fieldpendindzone.php?id=<?php echo "$zone"; ?>','popup','width=950,height=500,scrollbars=yes,resizable=no,toolbar=no,directories=no,location=center,menubar=no,status=no,left=100,top=100'); return false"><b><?php echo $data['zone'];?> &nbsp;&nbsp;<?php echo $data['num'];?> </b></a></font></th>				
				<?php
				$i++; }
				?>
			
		 </thead>
		 <tbody>
		<?php
		
	?>


</tbody>
 </table>
</td>
</tr>
</table>

</div>
</body>
</html>			
