<table width="100%" align="center"  bgcolor="#996633" border="7" width="1000" border="1" cellspacing="5" cellpadding="7" bordercolour="#FF4500">
<th bgcolor="#FFCC66" align="center" width="10%">FULL NAME</th>
<th bgcolor="#FFCC66" align="center" width="10%">CALL STATUS</th>
<th bgcolor="#FFCC66" align="center" width="10%">CALLS TODAY</th>
<th bgcolor="#FFCC66" align="center" width="10%">TALKTIME TODAY</th>
<th bgcolor="#FFCC66" align="center" width="10%">SALES TODAY</th>
<th bgcolor="#FFCC66" align="center" width="10%">SALES MONTH</th>
<th bgcolor="#FFCC66" align="center" width="10%">COST TO SALES T</th>
<th bgcolor="#FFCC66" align="center" width="10%">COST TO SALES M</th>
<th bgcolor="#FFCC66" align="center" width="10%">CALLCOST TODAY</th>
<th bgcolor="#FFCC66" align="center" width="10%">CALLCOST MONTH</th>
<th bgcolor="#FFCC66" align="center" width="10%">CALL CREDIT</th>

<?php

$dbhost = '192.168.1.2';
$db_name = 'asterisk';
$dbuser = 'dave';
$dbpass = '1234';


mysql_connect("$dbhost", "$dbuser", "$dbpass")
         or die(mysql_error());
//echo "Connected to MySQL<br />";

mysql_select_db("$db_name")
	or die("cannot select DB");
//echo "Connected to asterisk database<br />";

$query  = "SELECT user, status, calls_today FROM vicidial_live_agents";
$result = mysql_query($query);

while($rows = mysql_fetch_array($result)){
?>

<tr align="center">
<td BGCOLOR="#DFDF00" align="center" width="16%"><? $full_name=$rows['user']; echo getFULLNAME($full_name); ?></td>
<td BGCOLOR="#FFFF66" align="center" width="16%"><? echo $rows['status']; ?></td>
<td BGCOLOR="#DFDF00" align="center" width="16%"><? $call_today=$rows['user']; echo getCALLSTODAY($call_today); ?></td>
<td BGCOLOR="#FFFF66" align="center" width="16%"><? $calltime=$rows['user']; echo getCALLtime($calltime); echo "Min"; ?></td>
<td BGCOLOR="#DFDF00" align="center" width="16%"><? $sales=$rows['user']; echo getSalesday($sales); ?></td>
<td BGCOLOR="#FFFF66" align="center" width="16%"><? $sales=$rows['user']; echo getSalesmonth($sales); ?></td>
<?

//$cost=$rows['user'];
$cost=$rows['user'];
$meter=get_sale_ratio_day($cost);

if($meter <= 50) {$colour="#339900";}
else if($meter <= 100) {$colour="#33FF00";}
else if($meter <= 150) {$colour="#66FF66";}
else if($meter <= 200) {$colour="#33FF99";}
else if($meter <= 250) {$colour="#FFFF00";}
else if($meter <= 300) {$colour="#FFCC00";}
else if($meter <= 350) {$colour="#FF9900";}
else if($meter <= 400) {$colour="#FF6600";}
else if($meter <= 450) {$colour="#FF3300";}
else if($meter <= 500) {$colour="#FF0000";}
else if($meter > 500) {$colour="#FF00CC";}
?>
<? echo "<td BGCOLOR=\"$colour\" align=\"center\" width=\"16%\">"; ?>

<? echo $meter; ?>
<? echo "</td>"; ?>


<td BGCOLOR="#FFFF66" align="center" width="16%"><? $cost=$rows['user']; echo get_sale_ratio_month($cost); ?></td>
<td BGCOLOR="#DFDF00" align="center" width="16%"><? $cost=$rows['user']; echo getCOST($cost); ?></td>
<td BGCOLOR="#FFFF66" align="center" width="16%"><? $cost=$rows['user']; echo getCOSTmonth($cost); ?></td>
<td BGCOLOR="#DFDF00" align="center" width="16%"><? $agent=$rows['user']; echo getCallCredit($agent); ?></td>


</tr>


<?
}
mysql_close();
?>



<tr align="center">
<td BGCOLOR="#000000" align="center" ></td>
<td BGCOLOR="#FF9933" align="center" ><h1>TOTALS</h1></td>
<td BGCOLOR="#000000" align="center" ></td>
<td BGCOLOR="#FF9933" align="center" ><h1><?php include("bottom_call_time_day.php"); ?></h1></td>
<td BGCOLOR="#FF9933" align="center" ><h1><?php include("bottom_sales_count_day.php"); ?></h1></td>
<td BGCOLOR="#FF9933" align="center" ><h1><?php include("bottom_sales_month.php"); ?></h1></td>
<td BGCOLOR="#FF9933" align="center" ><h1><?php include("bottom_cost2sales_day.php"); ?></h1></td>
<td BGCOLOR="#FF9933" align="center" ><h1><?php include("bottom_cost2sales_month.php"); ?></h1></td>
<td BGCOLOR="#FF9933" align="center" ><h1><?php include("bottom_cost_day.php"); ?></h1></td>
<td BGCOLOR="#FF9933" align="center" ><h1><?php include("bottom_cost_month.php"); ?></h1></td>
<td BGCOLOR="#000000" align="center" ></td>
</tr>

</table>