function displayRowAgent($agentId)
{
include 'php/config.php';
global $DB;
$DB = str_replace("\"", "", $DB);
$connection_string = odbc_connect($DB, "", "");
global $curDay, $prevDay, $WTD, $MTD, $YTD, $nextBizDay, $conn;
$query = "\tSELECT *\n\t\t\t\tFROM \tusi_flashagent_tbl3\n\t\t\t\tWHERE agent_id = '" . $agentId . "'\n\t\t\t\tAND runDate = '" . date("Y-m-d") . "';";
$result = mysql_query($query, $conn) or die('Query failed: ' . mysql_error());
if (mysql_num_rows($result) > 0) {
while ($rows = mysql_fetch_array($result, MYSQL_NUM)) {
$label = returnLabel($rows[2]);
echo "\t<tr align=\"left\" bgcolor=\"#FFFFFF\">";
echo "\t\t<th width=\"100\" align=\"center\">" . $label . "</th>";
echo "\t\t<td width=\"100\" align=\"center\">" . number_format($rows[3]) . "</td>";
echo "\t\t<td width=\"100\" align=\"center\">" . $rows[4] . "</td>";
echo "\t\t<td width=\"100\" align=\"center\">" . number_format($rows[5]) . "</td>";
echo "\t\t<td width=\"100\" align=\"center\">" . $rows[6] . "</td>";
echo "\t\t<td width=\"100\" align=\"center\">" . $rows[7] . "</td>";
echo "\t\t<td width=\"100\" align=\"center\">" . $rows[8] . "</td>";
echo "\t</tr>";
}
}
}
echo "<th class=\"thYellow\" width=\"700px\" colspan=\"7\">Daily Call Center Flash Agent Report On " . $dateSelect . "</th>";
echo "</tr>";
echo "<tr>";
echo "<th class=\"thYellow\" width=\"100px\"></th>";
echo "<th class=\"thBlue\" width=\"100px\">IB Offered</th>";
echo "<th class=\"thBlue\" width=\"100px\">AHT</th>";
echo "<th class=\"thBlue\" width=\"100px\">Outbound</th>";
echo "<th class=\"thBlue\" width=\"100px\">AHT</th>";
echo "<th class=\"thBlue\" width=\"100px\">Calls<br>Monitored</th>";
echo "<th class=\"thBlue\" width=\"100px\">Avg Quality<br>Score</th>";
echo "</tr>";
$query = "\tSELECT *\n\t\t\t\tFROM \tusi_flashagent_tbl3\n\t\t\t\tWHERE agent_id = '" . $clientID . "'\n\t\t\t\tAND runDate = '" . $dateSelect . "';";
$result = mysql_query($query, $conn) or die('Query failed: ' . mysql_error());
if (mysql_num_rows($result) > 0) {
while ($rows = mysql_fetch_array($result, MYSQL_NUM)) {
$label = returnLabel($rows[2]);
echo "\t<tr align=\"left\" bgcolor=\"#FFFFFF\">";
echo "\t\t<th width=\"100\" align=\"center\">" . $label . "</th>";
echo "\t\t<td width=\"100\" align=\"center\">" . number_format($rows[3]) . "</td>";
echo "\t\t<td width=\"100\" align=\"center\">" . $rows[4] . "</td>";
echo "\t\t<td width=\"100\" align=\"center\">" . number_format($rows[5]) . "</td>";
echo "\t\t<td width=\"100\" align=\"center\">" . $rows[6] . "</td>";
echo "\t\t<td width=\"100\" align=\"center\">" . $rows[7] . "</td>";
echo "\t\t<td width=\"100\" align=\"center\">" . $rows[8] . "</td>";
echo "\t</tr>";
}
}
function returnLabel($num)
{
if ($num == 0) {
return "Daily";
