Beispiel #1
0
function displayPage($date)
{
    global $DB, $connection_string, $conn;
    // ******************************************************************************************************
    // *****		 						DAILY CALL ACTIVITY REPORT 									*****
    // ******************************************************************************************************
    echo "<div id=\"tabs\" class=\"tabs\" style=\"font-size:x-small; visibility:visible\">";
    echo "<h4 style=\"font-variant: small-caps; font-size:large\">daily call center flash activity report</h4>";
    // ******************* Create All The Tabs *************************
    echo "  <ul>";
    echo "\t\t<li><a href=\"#callTotal\"<span>Total</span></a></li>";
    $query = "\tSELECT DISTINCT\t\tclientGroup\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\tFROM\t\t\t\tusi_tbl_activequeue";
    $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)) {
            echo "<li><a href=\"#" . "Call" . $rows[0] . "\"<span>" . $rows[0] . "</span></a></li>";
        }
    }
    echo "\t</ul>";
    // ****************** DISPLAY CALL TOTALS ****************************
    echo "    <div id=\"callTotal\">";
    displayHeader("Total");
    displayRowFlash(-1, $date);
    displayEnd();
    echo "    </div>";
    // ****************** DISPLAY ALL CLIENT DIVS ************************
    $query = "\tSELECT DISTINCT\t\tclientGroup\t\t\t\t\t\t\t\t\t\n\t\t\t\t\tFROM\t\t\t\tusi_tbl_activequeue";
    $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)) {
            echo "\t<div id=\"" . "Call" . $rows[0] . "\">";
            displayHeader($rows[0]);
            displayRowFlash($rows[0], $date);
            displayEnd();
            echo "\t</div>";
        }
    }
    echo "</div>";
    echo "<br>";
    echo "<br>";
    // ******************************************************************************************************
    // *****		 						DAILY APPT SCHEDULE REPORT 									*****
    // ******************************************************************************************************
    echo "<div id=\"tabs2\" class=\"tabs2\" style=\"font-size:x-small; visibility:visible\">";
    echo "<h4 style=\"font-variant: small-caps; font-size:large\">daily appointment scheduling flash report</h4>";
    // ******************* Create All The Tabs *************************
    echo "  <ul>";
    echo "\t\t<li><a href=\"#callTotal2\"<span>Total</span></a></li>";
    $employer_query = "Exec usp_USI_GetEmployerGroups";
    $process = odbc_exec($connection_string, $employer_query);
    while (odbc_fetch_row($process)) {
        // Restitch and strip charactars to remove errors when choosing tabs
        $words = explode(' ', odbc_result($process, "employergroup_nm"));
        $words_sewn = implode("-", $words);
        $words_sewn = str_replace(",", "", $words_sewn);
        $words_sewn = str_replace(".", "", $words_sewn);
        echo "<li><a href=\"#" . "Appt" . $words_sewn . "\"<span>" . $words_sewn . "</span></a></li>";
    }
    echo "\t</ul>";
    // ****************** DISPLAY CLIENT TOTALS **************************
    echo "    <div id=\"callTotal2\">";
    displayApptHeader("Total");
    displayRowAppt(-1, $date);
    displayEnd();
    echo "    </div>";
    // ****************** DISPLAY ALL CLIENT DIVS ************************
    $employer_arr = array();
    $employer_query = "Exec usp_USI_GetEmployerGroups";
    $process = odbc_exec($connection_string, $employer_query);
    while (odbc_fetch_row($process)) {
        $words = explode(' ', odbc_result($process, "employergroup_nm"));
        $words_sewn = implode("-", $words);
        $words_sewn = str_replace(",", "", $words_sewn);
        $words_sewn = str_replace(".", "", $words_sewn);
        $employer_arr[odbc_result($process, "employergroup_id")] = $words_sewn;
    }
    foreach ($employer_arr as $empl_id => $empl_nm) {
        echo "\t<div id=\"" . "Appt" . $empl_nm . "\">";
        displayApptHeader($empl_nm);
        displayRowAppt($empl_id, $date);
        displayEnd();
        echo "\t</div>";
    }
    echo "</div>";
    echo "<br>";
    echo "<br>";
    // ******************************************************************************************************
    // *****		 						DAILY APPT SCHEDULE REPORT 									*****
    // ******************************************************************************************************
    echo "<div id=\"tabs3\" class=\"tabs3\" style=\"font-size:x-small; visibility:visible\">";
    echo "<h4 style=\"font-variant: small-caps; font-size:large\">daily call center flash agent report</h4>";
    // ******************* Create All The Tabs *************************
    echo "  <ul>";
    echo "\t\t<li><a href=\"#callTotal3\"<span>Total</span></a></li>";
    $query = "\tSELECT \t\t\t\tconcat(substring(firstname,1,1),'-', lastname)\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\tFROM\t\t\t\ttbl_callagents\n\t\t\t\t\t\t\t\t\t\tORDER BY\t\t\tagent_id";
    $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)) {
            echo "<li><a href=\"#" . "Agent" . $rows[0] . "\"<span>" . $rows[0] . "</span></a></li>";
        }
    }
    echo "\t</ul>";
    // ****************** DISPLAY CLIENT TOTALS **************************
    echo "\t<div id=\"callTotal3\">";
    displayAgentHeader("Total");
    displayRowAgent(-1, $date);
    displayEnd();
    echo "\t</div>";
    // ****************** DISPLAY ALL CLIENT DIVS ************************
    $query = "\tSELECT \t\t\t\tconcat(substring(firstname,1,1),'-', lastname), agent_id\n\t\t\t\t\tFROM\t\t\t\ttbl_callagents\n\t\t\t\t\tORDER BY\t\t\tagent_id";
    $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)) {
            echo "\t<div id=\"Agent" . $rows[0] . "\"";
            displayAgentHeader($rows[0]);
            displayRowAgent($rows[1], $date);
            displayEnd();
            echo "\t</div>";
        }
    }
    echo "</div>";
}
Beispiel #2
0
    $words_sewn = implode("-", $words);
    $words_sewn = str_replace(",", "", $words_sewn);
    $words_sewn = str_replace(".", "", $words_sewn);
    $employer_arr[odbc_result($process, "employergroup_id")] = $words_sewn;
}
foreach ($employer_arr as $empl_id => $empl_nm) {
    displayRowAppt($empl_id);
}
// Total Agent Report
displayRowAgent(-1);
// Individual
$query = "\tSELECT \t\t\t\tconcat(substring(firstname,1,1),'-', lastname), agent_id\n\t\t\t\tFROM\t\t\t\ttbl_callagents";
$result = mysql_query($query, $conn) or die('Query failed: ' . $query . mysql_error());
if (mysql_num_rows($result) > 0) {
    while ($rows = mysql_fetch_array($result, MYSQL_NUM)) {
        displayRowAgent($rows[1]);
    }
}
function flashAgentInsert($clientGroup)
{
    include 'config.php';
    global $DB;
    $DB = str_replace("\"", "", $DB);
    $connection_string = odbc_connect($DB, "", "");
    global $curDay, $prevDay, $WTD, $MTD, $YTD, $beginWk, $endWk, $nextBizDay, $conn;
    global $curDay_ts, $prevDay_ts, $WTD_ts, $MTD_ts, $YTD_ts, $beginWk_ts, $endWk_ts;
    $empl_tbl = array();
    for ($i = 0; $i < 4; $i++) {
        // *********************** IB OFFERED *****************************
        $query = "\tSELECT      count(*), sum(C.hold_time)/count(*), sum(C.duration)/count(*) \n\t\t\t\t\tFROM        usi_tbl_callqueue as C\n\t\t\t\t\tJOIN        usi_tbl_activequeue as Q\n\t\t\t\t\tON          C.queue_label = Q.client_queue\n\t\t\t\t\tJOIN        tbl_callagents as A\n\t\t\t\t\tON          A.ext = substr(C.destination,12,3)\n\t\t\t\t\tAND         call_type <> 'CONNECT'\n\t\t\t\t\tAND\t\t\tcall_type <> 'TRANSFER'\n\t\t\t\t\tAND         Q.active = '1' \n\t\t\t\t\tAND         C.end_type <> '0' ";
        if ($i == 0) {