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";