Select Campaigns: ";
$o=0;
while ($groups_to_print > $o)
{
if (ereg("\|$LISTgroups[$o]\|",$group_string))
{$select_list .= "$LISTgroups[$o] - $LISTnames[$o] ";}
else
{$select_list .= "$LISTgroups[$o] - $LISTnames[$o] ";}
$o++;
}
$select_list .= " ";
$select_list .= "(To select more than 1 campaign, hold down the Ctrl key and click)";
$select_list .= " ";
$select_list .= "Close Panel ";
$select_list .= "";
$select_list .= "Inbound: ";
$select_list .= "";
$select_list .= " ";
$select_list .= "Select User Group: ";
$select_list .= "";
$select_list .= "ALL USER GROUPS ";
$o=0;
while ($usergroups_to_print > $o)
{
if ($usergroups[$o] == $usergroup) {$select_list .= "$usergroups[$o] ";}
else {$select_list .= "$usergroups[$o] ";}
$o++;
}
$select_list .= " ";
$select_list .= "Dialable Leads Alert: ";
$select_list .= " 0)
{
$row=mysql_fetch_row($rslt);
$presets_enabled = $row[0];
}
if ($presets_enabled > 0)
{
$select_list .= "";
$select_list .= "Show Presets Stats: ";
$select_list .= " ";
$select_list .= " ";
$select_list .= " ";
$select_list .= " ";
$select_list .= "";
$select_list .= "VERSION: $version BUILD: $build ";
$select_list .= "
";
$open_list = "";
?>
0)
{
echo "\n";
}
else
{
?>
\n";
echo "$report_name: $group \n";
$short_header=1;
require("admin_header.php");
}
$stmt = "select count(*) from vicidial_campaigns where active='Y' and campaign_allow_inbound='Y' $group_SQLand;";
$rslt=mysql_query($stmt, $link);
if ($DB) {echo "$stmt\n";}
$row=mysql_fetch_row($rslt);
$campaign_allow_inbound = $row[0];
if ($RTajax < 1)
{
echo "";
echo "\n"; exit;}
else
{
$multi_drop=0;
### Gather list of all Closer group ids for exclusion from stats
$stmt = "select group_id from vicidial_inbound_groups;";
$rslt=mysql_query($stmt, $link);
$ingroups_to_print = mysql_num_rows($rslt);
while ($ingroups_to_print > $c)
{
$row=mysql_fetch_row($rslt);
$ALLcloser_campaignsSQL .= "'$row[0]',";
$c++;
}
$ALLcloser_campaignsSQL = preg_replace("/,$/","",$ALLcloser_campaignsSQL);
if (strlen($ALLcloser_campaignsSQL)<2)
{$ALLcloser_campaignsSQL="''";}
if ($DB > 0) {echo "\n|$ALLcloser_campaignsSQL|$stmt|\n";}
##### INBOUND #####
if ( ( ereg('Y',$with_inbound) or ereg('O',$with_inbound) ) and ($campaign_allow_inbound > 0) )
{
### Gather list of Closer group ids
$stmt = "select closer_campaigns from vicidial_campaigns where active='Y' $group_SQLand;";
$rslt=mysql_query($stmt, $link);
$ccamps_to_print = mysql_num_rows($rslt);
$c=0;
while ($ccamps_to_print > $c)
{
$row=mysql_fetch_row($rslt);
$closer_campaigns = $row[0];
$closer_campaigns = preg_replace("/^ | -$/","",$closer_campaigns);
$closer_campaigns = preg_replace("/ /","','",$closer_campaigns);
$closer_campaignsSQL .= "'$closer_campaigns',";
$c++;
}
$closer_campaignsSQL = preg_replace("/,$/","",$closer_campaignsSQL);
}
if (strlen($closer_campaignsSQL)<2)
{$closer_campaignsSQL="''";}
if ($DB > 0) {echo "\n|$closer_campaigns|$closer_campaignsSQL|$stmt|\n";}
##### SHOW IN-GROUP STATS OR INBOUND ONLY WITH VIEW-MORE ###
if ( ($ALLINGROUPstats > 0) or ( (ereg('O',$with_inbound)) and ($adastats > 1) ) )
{
$stmtB="select calls_today,drops_today,answers_today,status_category_1,status_category_count_1,status_category_2,status_category_count_2,status_category_3,status_category_count_3,status_category_4,status_category_count_4,hold_sec_stat_one,hold_sec_stat_two,hold_sec_answer_calls,hold_sec_drop_calls,hold_sec_queue_calls,campaign_id from vicidial_campaign_stats where campaign_id IN ($closer_campaignsSQL) order by campaign_id;";
if ($DB > 0) {echo "\n|$stmtB|\n";}
$r=0;
$rslt=mysql_query($stmtB, $link);
$ingroups_to_print = mysql_num_rows($rslt);
if ($ingroups_to_print > 0)
{$ingroup_detail .= "";}
while ($ingroups_to_print > $r)
{
$row=mysql_fetch_row($rslt);
$callsTODAY = $row[0];
$dropsTODAY = $row[1];
$answersTODAY = $row[2];
$VSCcat1 = $row[3];
$VSCcat1tally = $row[4];
$VSCcat2 = $row[5];
$VSCcat2tally = $row[6];
$VSCcat3 = $row[7];
$VSCcat3tally = $row[8];
$VSCcat4 = $row[9];
$VSCcat4tally = $row[10];
$hold_sec_stat_one = $row[11];
$hold_sec_stat_two = $row[12];
$hold_sec_answer_calls = $row[13];
$hold_sec_drop_calls = $row[14];
$hold_sec_queue_calls = $row[15];
$ingroupdetail = $row[16];
if ( ($dropsTODAY > 0) and ($answersTODAY > 0) )
{
$drpctTODAY = ( ($dropsTODAY / $answersTODAY) * 100);
$drpctTODAY = round($drpctTODAY, 2);
$drpctTODAY = sprintf("%01.2f", $drpctTODAY);
}
else
{$drpctTODAY=0;}
if ($callsTODAY > 0)
{
$AVGhold_sec_queue_calls = ($hold_sec_queue_calls / $callsTODAY);
$AVGhold_sec_queue_calls = round($AVGhold_sec_queue_calls, 0);
}
else
{$AVGhold_sec_queue_calls=0;}
if ($dropsTODAY > 0)
{
$AVGhold_sec_drop_calls = ($hold_sec_drop_calls / $dropsTODAY);
$AVGhold_sec_drop_calls = round($AVGhold_sec_drop_calls, 0);
}
else
{$AVGhold_sec_drop_calls=0;}
if ($answersTODAY > 0)
{
$PCThold_sec_stat_one = ( ($hold_sec_stat_one / $answersTODAY) * 100);
$PCThold_sec_stat_one = round($PCThold_sec_stat_one, 2);
$PCThold_sec_stat_one = sprintf("%01.2f", $PCThold_sec_stat_one);
$PCThold_sec_stat_two = ( ($hold_sec_stat_two / $answersTODAY) * 100);
$PCThold_sec_stat_two = round($PCThold_sec_stat_two, 2);
$PCThold_sec_stat_two = sprintf("%01.2f", $PCThold_sec_stat_two);
$AVGhold_sec_answer_calls = ($hold_sec_answer_calls / $answersTODAY);
$AVGhold_sec_answer_calls = round($AVGhold_sec_answer_calls, 0);
if ($agent_non_pause_sec > 0)
{
$AVG_ANSWERagent_non_pause_sec = (($answersTODAY / $agent_non_pause_sec) * 60);
$AVG_ANSWERagent_non_pause_sec = round($AVG_ANSWERagent_non_pause_sec, 2);
$AVG_ANSWERagent_non_pause_sec = sprintf("%01.2f", $AVG_ANSWERagent_non_pause_sec);
}
else
{$AVG_ANSWERagent_non_pause_sec=0;}
}
else
{
$PCThold_sec_stat_one=0;
$PCThold_sec_stat_two=0;
$AVGhold_sec_answer_calls=0;
$AVG_ANSWERagent_non_pause_sec=0;
}
if (ereg("0$|2$|4$|6$|8$",$r)) {$bgcolor='#E6E6E6';}
else {$bgcolor='white';}
$ingroup_detail .= "";
$ingroup_detail .= " $ingroupdetail CALLS TODAY: $callsTODAY TMA 1: $PCThold_sec_stat_one% Average Hold time for Answered Calls: $AVGhold_sec_answer_calls ";
$ingroup_detail .= "";
$ingroup_detail .= "DROPS TODAY: $dropsTODAY TMA 2: $PCThold_sec_stat_two% Average Hold time for Dropped Calls: $AVGhold_sec_drop_calls ";
$ingroup_detail .= "";
$ingroup_detail .= "ANSWERS TODAY: $answersTODAY DROP PERCENT: $drpctTODAY% Average Hold time for All Calls: $AVGhold_sec_queue_calls ";
$r++;
}
if ($ingroups_to_print > 0)
{$ingroup_detail .= "
";}
}
##### DROP IN-GROUP ONLY TOTALS ROW ###
$DROPINGROUPstatsHTML='';
if ( ($DROPINGROUPstats > 0) and (!preg_match("/ALL-ACTIVE/",$group_string)) )
{
$DIGcampaigns='';
$stmtB="select drop_inbound_group from vicidial_campaigns where campaign_id IN($group_SQL) and drop_inbound_group NOT IN('---NONE---','');";
if ($DB > 0) {echo "\n|$stmtB|\n";}
$rslt=mysql_query($stmtB, $link);
$dig_to_print = mysql_num_rows($rslt);
$dtp=0;
while ($dig_to_print > $dtp)
{
$row=mysql_fetch_row($rslt);
$DIGcampaigns .= "'$row[0]',";
$dtp++;
}
$DIGcampaigns = preg_replace("/,$/",'',$DIGcampaigns);
if (strlen($DIGcampaigns) < 2) {$DIGcampaigns = "''";}
$stmtB="select sum(calls_today),sum(drops_today),sum(answers_today) from vicidial_campaign_stats where campaign_id IN($DIGcampaigns);";
if ($DB > 0) {echo "\n|$stmtB|\n";}
$rslt=mysql_query($stmtB, $link);
$row=mysql_fetch_row($rslt);
$callsTODAY = $row[0];
$dropsTODAY = $row[1];
$answersTODAY = $row[2];
if ( ($dropsTODAY > 0) and ($callsTODAY > 0) )
{
$drpctTODAY = ( ($dropsTODAY / $callsTODAY) * 100);
$drpctTODAY = round($drpctTODAY, 2);
$drpctTODAY = sprintf("%01.2f", $drpctTODAY);
}
else
{$drpctTODAY=0;}
$DROPINGROUPstatsHTML .= " ";
$DROPINGROUPstatsHTML .= "DROP IN-GROUP STATS - DROP PERCENT: $drpctTODAY% CALLS: $callsTODAY DROPS/ANSWERS: $dropsTODAY / $answersTODAY ";
}
##### CARRIER STATS TOTALS ###
$CARRIERstatsHTML='';
if ($CARRIERstats > 0)
{
$stmtB="select dialstatus,count(*) from vicidial_carrier_log where call_date >= \"$timeTWENTYFOURhoursAGO\" group by dialstatus;";
if ($DB > 0) {echo "\n|$stmtB|\n";}
$rslt=mysql_query($stmtB, $link);
$car_to_print = mysql_num_rows($rslt);
$ctp=0;
while ($car_to_print > $ctp)
{
$row=mysql_fetch_row($rslt);
$TFhour_status[$ctp] = $row[0];
$TFhour_count[$ctp] = $row[1];
$dialstatuses .= "'$row[0]',";
$ctp++;
}
$dialstatuses = preg_replace("/,$/",'',$dialstatuses);
$CARRIERstatsHTML .= "";
$CARRIERstatsHTML .= "";
$CARRIERstatsHTML .= "";
$CARRIERstatsHTML .= "CARRIER STATS: HANGUP STATUS 24 HOURS 6 HOURS 1 HOUR 15 MIN 5 MIN 1 MIN ";
if (strlen($dialstatuses) > 1)
{
$stmtB="select dialstatus,count(*) from vicidial_carrier_log where call_date >= \"$timeSIXhoursAGO\" group by dialstatus;";
if ($DB > 0) {echo "\n|$stmtB|\n";}
$rslt=mysql_query($stmtB, $link);
$scar_to_print = mysql_num_rows($rslt);
$print_sctp=0;
while ($scar_to_print > $print_sctp)
{
$row=mysql_fetch_row($rslt);
$print_ctp=0;
while ($print_ctp < $ctp)
{
if ($TFhour_status[$print_ctp] == $row[0])
{$SIXhour_count[$print_ctp] = $row[1];}
$print_ctp++;
}
$print_sctp++;
}
$stmtB="select dialstatus,count(*) from vicidial_carrier_log where call_date >= \"$timeONEhourAGO\" group by dialstatus;";
if ($DB > 0) {echo "\n|$stmtB|\n";}
$rslt=mysql_query($stmtB, $link);
$scar_to_print = mysql_num_rows($rslt);
$print_sctp=0;
while ($scar_to_print > $print_sctp)
{
$row=mysql_fetch_row($rslt);
$print_ctp=0;
while ($print_ctp < $ctp)
{
if ($TFhour_status[$print_ctp] == $row[0])
{$ONEhour_count[$print_ctp] = $row[1];}
$print_ctp++;
}
$print_sctp++;
}
$stmtB="select dialstatus,count(*) from vicidial_carrier_log where call_date >= \"$timeFIFTEENminutesAGO\" group by dialstatus;";
if ($DB > 0) {echo "\n|$stmtB|\n";}
$rslt=mysql_query($stmtB, $link);
$scar_to_print = mysql_num_rows($rslt);
$print_sctp=0;
while ($scar_to_print > $print_sctp)
{
$row=mysql_fetch_row($rslt);
$print_ctp=0;
while ($print_ctp < $ctp)
{
if ($TFhour_status[$print_ctp] == $row[0])
{$FTminute_count[$print_ctp] = $row[1];}
$print_ctp++;
}
$print_sctp++;
}
$stmtB="select dialstatus,count(*) from vicidial_carrier_log where call_date >= \"$timeFIVEminutesAGO\" group by dialstatus;";
if ($DB > 0) {echo "\n|$stmtB|\n";}
$rslt=mysql_query($stmtB, $link);
$scar_to_print = mysql_num_rows($rslt);
$print_sctp=0;
while ($scar_to_print > $print_sctp)
{
$row=mysql_fetch_row($rslt);
$print_ctp=0;
while ($print_ctp < $ctp)
{
if ($TFhour_status[$print_ctp] == $row[0])
{$FIVEminute_count[$print_ctp] = $row[1];}
$print_ctp++;
}
$print_sctp++;
}
$stmtB="select dialstatus,count(*) from vicidial_carrier_log where call_date >= \"$timeONEminuteAGO\" group by dialstatus;";
if ($DB > 0) {echo "\n|$stmtB|\n";}
$rslt=mysql_query($stmtB, $link);
$scar_to_print = mysql_num_rows($rslt);
$print_sctp=0;
while ($scar_to_print > $print_sctp)
{
$row=mysql_fetch_row($rslt);
$print_ctp=0;
while ($print_ctp < $ctp)
{
if ($TFhour_status[$print_ctp] == $row[0])
{$ONEminute_count[$print_ctp] = $row[1];}
$print_ctp++;
}
$print_sctp++;
}
$print_ctp=0;
while ($print_ctp < $ctp)
{
if (strlen($TFhour_count[$print_ctp])<1) {$TFhour_count[$print_ctp]=0;}
if (strlen($SIXhour_count[$print_ctp])<1) {$SIXhour_count[$print_ctp]=0;}
if (strlen($ONEhour_count[$print_ctp])<1) {$ONEhour_count[$print_ctp]=0;}
if (strlen($FTminute_count[$print_ctp])<1) {$FTminute_count[$print_ctp]=0;}
if (strlen($FIVEminute_count[$print_ctp])<1) {$FIVEminute_count[$print_ctp]=0;}
if (strlen($ONEminute_count[$print_ctp])<1) {$ONEminute_count[$print_ctp]=0;}
$CARRIERstatsHTML .= "";
$CARRIERstatsHTML .= " $TFhour_status[$print_ctp] $TFhour_count[$print_ctp] $SIXhour_count[$print_ctp] $ONEhour_count[$print_ctp] $FTminute_count[$print_ctp] $FIVEminute_count[$print_ctp] $ONEminute_count[$print_ctp] ";
$print_ctp++;
}
}
else
{
$CARRIERstatsHTML .= "no log entries
";
$CARRIERstatsHTML .= " ";
$PRESETstatsHTML .= "";
$PRESETstatsHTML .= "";
$PRESETstatsHTML .= " AGENT DIAL PRESETS: PRESET NAMES CALLS ";
$stmtB="select preset_name,xfer_count from vicidial_xfer_stats where preset_name!='' and preset_name is not NULL $group_SQLand order by preset_name;";
if ($DB > 0) {echo "\n|$stmtB|\n";}
$rslt=mysql_query($stmtB, $link);
$pre_to_print = mysql_num_rows($rslt);
$ctp=0;
while ($pre_to_print > $ctp)
{
$row=mysql_fetch_row($rslt);
$PRESETstatsHTML .= "";
$PRESETstatsHTML .= " $row[0] $row[1] ";
$ctp++;
}
if ($ctp < 1)
{
$PRESETstatsHTML .= "no log entries
";
$PRESETstatsHTML .= " ";
echo "CALLS TODAY: $callsTODAY TMA 1: $PCThold_sec_stat_one% Average Hold time for Answered Calls: $AVGhold_sec_answer_calls TIME: $NOW_TIME ";
echo "";
echo "DROPS TODAY: $dropsTODAY TMA 2: $PCThold_sec_stat_two% Average Hold time for Dropped Calls: $AVGhold_sec_drop_calls ";
echo "";
echo "ANSWERS TODAY: $answersTODAY (Agent non-pause time / Answers) Average Hold time for All Calls: $AVGhold_sec_queue_calls ";
echo "";
echo "DROP PERCENT: $drpctTODAY% PRODUCTIVITY: $AVG_ANSWERagent_non_pause_sec ";
}
##### NOT INBOUND ONLY ###
else
{
if (eregi('ALL-ACTIVE',$group_string))
{
$non_inboundSQL='';
if (ereg('N',$with_inbound))
{$non_inboundSQL = "and campaign_id NOT IN($ALLcloser_campaignsSQL)";}
else
{$non_inboundSQL = "and campaign_id IN($group_SQL,$closer_campaignsSQL)";}
$multi_drop++;
$stmt="select avg(auto_dial_level),min(dial_status_a),min(dial_status_b),min(dial_status_c),min(dial_status_d),min(dial_status_e),min(lead_order),min(lead_filter_id),sum(hopper_level),min(dial_method),avg(adaptive_maximum_level),avg(adaptive_dropped_percentage),avg(adaptive_dl_diff_target),avg(adaptive_intensity),min(available_only_ratio_tally),min(adaptive_latest_server_time),min(local_call_time),avg(dial_timeout),min(dial_statuses),max(agent_pause_codes_active),max(list_order_mix),max(auto_hopper_level) from vicidial_campaigns where active='Y' $group_SQLand;";
$stmtB="select sum(dialable_leads),sum(calls_today),sum(drops_today),avg(drops_answers_today_pct),avg(differential_onemin),avg(agents_average_onemin),sum(balance_trunk_fill),sum(answers_today),max(status_category_1),sum(status_category_count_1),max(status_category_2),sum(status_category_count_2),max(status_category_3),sum(status_category_count_3),max(status_category_4),sum(status_category_count_4),sum(agent_calls_today),sum(agent_wait_today),sum(agent_custtalk_today),sum(agent_acw_today),sum(agent_pause_today) from vicidial_campaign_stats where calls_today > -1 $non_inboundSQL;";
}
else
{
if ($DB > 0) {echo "\n|$with_inbound|$campaign_allow_inbound|\n";}
if ( (ereg('Y',$with_inbound)) and ($campaign_allow_inbound > 0) )
{
$multi_drop++;
if ($DB) {echo "with_inbound|$with_inbound|$campaign_allow_inbound\n";}
$stmt="select auto_dial_level,dial_status_a,dial_status_b,dial_status_c,dial_status_d,dial_status_e,lead_order,lead_filter_id,hopper_level,dial_method,adaptive_maximum_level,adaptive_dropped_percentage,adaptive_dl_diff_target,adaptive_intensity,available_only_ratio_tally,adaptive_latest_server_time,local_call_time,dial_timeout,dial_statuses,agent_pause_codes_active,list_order_mix,auto_hopper_level from vicidial_campaigns where campaign_id IN ($group_SQL,$closer_campaignsSQL);";
$stmtB="select sum(dialable_leads),sum(calls_today),sum(drops_today),avg(drops_answers_today_pct),avg(differential_onemin),avg(agents_average_onemin),sum(balance_trunk_fill),sum(answers_today),max(status_category_1),sum(status_category_count_1),max(status_category_2),sum(status_category_count_2),max(status_category_3),sum(status_category_count_3),max(status_category_4),sum(status_category_count_4),sum(agent_calls_today),sum(agent_wait_today),sum(agent_custtalk_today),sum(agent_acw_today),sum(agent_pause_today) from vicidial_campaign_stats where campaign_id IN ($group_SQL,$closer_campaignsSQL);";
}
else
{
$stmt="select avg(auto_dial_level),max(dial_status_a),max(dial_status_b),max(dial_status_c),max(dial_status_d),max(dial_status_e),max(lead_order),max(lead_filter_id),max(hopper_level),max(dial_method),max(adaptive_maximum_level),avg(adaptive_dropped_percentage),avg(adaptive_dl_diff_target),avg(adaptive_intensity),max(available_only_ratio_tally),max(adaptive_latest_server_time),max(local_call_time),max(dial_timeout),max(dial_statuses),max(agent_pause_codes_active),max(list_order_mix),max(auto_hopper_level) from vicidial_campaigns where campaign_id IN($group_SQL);";
$stmtB="select sum(dialable_leads),sum(calls_today),sum(drops_today),avg(drops_answers_today_pct),avg(differential_onemin),avg(agents_average_onemin),sum(balance_trunk_fill),sum(answers_today),max(status_category_1),sum(status_category_count_1),max(status_category_2),sum(status_category_count_2),max(status_category_3),sum(status_category_count_3),max(status_category_4),sum(status_category_count_4),sum(agent_calls_today),sum(agent_wait_today),sum(agent_custtalk_today),sum(agent_acw_today),sum(agent_pause_today) from vicidial_campaign_stats where campaign_id IN($group_SQL);";
}
}
if ($DB > 0) {echo "\n|$stmt|$stmtB|\n";}
$rslt=mysql_query($stmt, $link);
$row=mysql_fetch_row($rslt);
$DIALlev = $row[0];
$DIALstatusA = $row[1];
$DIALstatusB = $row[2];
$DIALstatusC = $row[3];
$DIALstatusD = $row[4];
$DIALstatusE = $row[5];
$DIALorder = $row[6];
$DIALfilter = $row[7];
$HOPlev = $row[8];
$DIALmethod = $row[9];
$maxDIALlev = $row[10];
$DROPmax = $row[11];
$targetDIFF = $row[12];
$ADAintense = $row[13];
$ADAavailonly = $row[14];
$TAPERtime = $row[15];
$CALLtime = $row[16];
$DIALtimeout = $row[17];
$DIALstatuses = $row[18];
$agent_pause_codes_active = $row[19];
$DIALmix = $row[20];
$AHOPlev = $row[21];
$stmt="select count(*) from vicidial_hopper $group_SQLwhere;";
$rslt=mysql_query($stmt, $link);
$row=mysql_fetch_row($rslt);
$VDhop = $row[0];
$rslt=mysql_query($stmtB, $link);
$row=mysql_fetch_row($rslt);
$DAleads = $row[0];
$callsTODAY = $row[1];
$dropsTODAY = $row[2];
$drpctTODAY = $row[3];
$diffONEMIN = $row[4];
$agentsONEMIN = $row[5];
$balanceFILL = $row[6];
$answersTODAY = $row[7];
if ($multi_drop > 0)
{
if ( ($dropsTODAY > 0) and ($answersTODAY > 0) )
{
$drpctTODAY = ( ($dropsTODAY / $answersTODAY) * 100);
$drpctTODAY = round($drpctTODAY, 2);
$drpctTODAY = sprintf("%01.2f", $drpctTODAY);
}
else
{$drpctTODAY=0;}
}
$VSCcat1 = $row[8];
$VSCcat1tally = $row[9];
$VSCcat2 = $row[10];
$VSCcat2tally = $row[11];
$VSCcat3 = $row[12];
$VSCcat3tally = $row[13];
$VSCcat4 = $row[14];
$VSCcat4tally = $row[15];
$VSCagentcalls = $row[16];
$VSCagentwait = $row[17];
$VSCagentcust = $row[18];
$VSCagentacw = $row[19];
$VSCagentpause = $row[20];
if ( ($diffONEMIN != 0) and ($agentsONEMIN > 0) )
{
$diffpctONEMIN = ( ($diffONEMIN / $agentsONEMIN) * 100);
$diffpctONEMIN = sprintf("%01.2f", $diffpctONEMIN);
}
else {$diffpctONEMIN = '0.00';}
$stmt="select sum(local_trunk_shortage) from vicidial_campaign_server_stats $group_SQLwhere;";
$rslt=mysql_query($stmt, $link);
$row=mysql_fetch_row($rslt);
$balanceSHORT = $row[0];
if (ereg('DISABLED',$DIALmix))
{
$DIALstatuses = (preg_replace("/ -$|^ /","",$DIALstatuses));
$DIALstatuses = (ereg_replace(' ',', ',$DIALstatuses));
}
else
{
$stmt="select vcl_id from vicidial_campaigns_list_mix where status='ACTIVE' $group_SQLand limit 1;";
$rslt=mysql_query($stmt, $link);
$Lmix_to_print = mysql_num_rows($rslt);
if ($Lmix_to_print > 0)
{
$row=mysql_fetch_row($rslt);
$DIALstatuses = "List Mix: $row[0]";
$DIALorder = "List Mix: $row[0]";
}
}
$DIALlev = sprintf("%01.3f", $DIALlev);
$agentsONEMIN = sprintf("%01.2f", $agentsONEMIN);
$diffONEMIN = sprintf("%01.2f", $diffONEMIN);
echo "";
echo "DIAL LEVEL: $DIALlev TRUNK SHORT/FILL: $balanceSHORT / $balanceFILL FILTER: $DIALfilter TIME: $NOW_TIME ";
if ($adastats>1)
{
$min_link='- min ";
echo "$min_link MAX LEVEL: $maxDIALlev DROPPED MAX: $DROPmax% TARGET DIFF: $targetDIFF INTENSITY: $ADAintense ";
echo "";
echo "DIAL TIMEOUT: $DIALtimeout TAPER TIME: $TAPERtime LOCAL TIME: $CALLtime AVAIL ONLY: $ADAavailonly ";
}
echo "";
echo "DIALABLE LEADS: $DAleads CALLS TODAY: $callsTODAY AVG AGENTS: $agentsONEMIN DIAL METHOD: $DIALmethod ";
echo "";
echo "HOPPER ( min/auto ) : $HOPlev / $AHOPlev DROPPED / ANSWERED: $dropsTODAY / $answersTODAY DL DIFF: $diffONEMIN STATUSES: $DIALstatuses ";
echo "";
echo "LEADS IN HOPPER: $VDhop DROPPED PERCENT: ";
if ($drpctTODAY >= $DROPmax)
{echo "$drpctTODAY% DIFF: $diffpctONEMIN% ORDER: $DIALorder ";
if ($AGENTtimeSTATS>0)
{
if ( ($VSCagentcalls > 0) and ($VSCagentpause > 0) )
{
$avgpauseTODAY = ($VSCagentpause / $VSCagentcalls);
$avgpauseTODAY = round($avgpauseTODAY, 0);
$avgpauseTODAY = sprintf("%01.0f", $avgpauseTODAY);
}
else
{$avgpauseTODAY=0;}
if ( ($VSCagentcalls > 0) and ($VSCagentwait > 0) )
{
$avgwaitTODAY = ($VSCagentwait / $VSCagentcalls);
$avgwaitTODAY = round($avgwaitTODAY, 0);
$avgwaitTODAY = sprintf("%01.0f", $avgwaitTODAY);
}
else
{$avgwaitTODAY=0;}
if ( ($VSCagentcalls > 0) and ($VSCagentcust > 0) )
{
$avgcustTODAY = ($VSCagentcust / $VSCagentcalls);
$avgcustTODAY = round($avgcustTODAY, 0);
$avgcustTODAY = sprintf("%01.0f", $avgcustTODAY);
}
else
{$avgcustTODAY=0;}
if ( ($VSCagentcalls > 0) and ($VSCagentacw > 0) )
{
$avgacwTODAY = ($VSCagentacw / $VSCagentcalls);
$avgacwTODAY = round($avgacwTODAY, 0);
$avgacwTODAY = sprintf("%01.0f", $avgacwTODAY);
}
else
{$avgacwTODAY=0;}
echo "";
echo "AGENT AVG WAIT: $avgwaitTODAY AVG CUSTTIME: $avgcustTODAY AVG ACW: $avgacwTODAY AVG PAUSE: $avgpauseTODAY ";
}
echo "$DROPINGROUPstatsHTML\n";
echo "$CARRIERstatsHTML\n";
echo "$PRESETstatsHTML\n";
}
echo "";
echo "";
if ( (!eregi('NULL',$VSCcat1)) and (strlen($VSCcat1)>0) )
{echo "$VSCcat1: $VSCcat1tally \n";}
if ( (!eregi('NULL',$VSCcat2)) and (strlen($VSCcat2)>0) )
{echo "$VSCcat2: $VSCcat2tally \n";}
if ( (!eregi('NULL',$VSCcat3)) and (strlen($VSCcat3)>0) )
{echo "$VSCcat3: $VSCcat3tally \n";}
if ( (!eregi('NULL',$VSCcat4)) and (strlen($VSCcat4)>0) )
{echo "$VSCcat4: $VSCcat4tally \n";}
echo " ";
echo "";
echo "";
echo "$ingroup_detail";
if ($RTajax < 1)
{
if ($adastats<2)
{
echo "+ VIEW MORE + VIEW LESS HIDE USER GROUP VIEW USER GROUP HIDE SERVER INFO SHOW SERVER INFO HIDE WAITING CALLS SHOW WAITING CALLS HIDE IN-GROUP STATS SHOW IN-GROUP STATS HIDE PHONES SHOW PHONES HIDE CUSTPHONES SHOW CUSTPHONES ";
echo " ";
echo "
";
echo "\n\n";
##### check for campaigns with no dialable leads if enabled #####
if ( ($with_inbound != 'O') and ($NOLEADSalert == 'YES') )
{
$NDLcampaigns='';
$stmtB="select campaign_id from vicidial_campaign_stats where campaign_id IN($group_SQL) and dialable_leads < 1 order by campaign_id;";
if ($DB > 0) {echo "\n|$stmt|$stmtB|\n";}
$rslt=mysql_query($stmtB, $link);
$campaigns_to_print = mysql_num_rows($rslt);
$ctp=0;
while ($campaigns_to_print > $ctp)
{
$row=mysql_fetch_row($rslt);
$NDLcampaigns .= " $row[0] ";
$ctp++;
if (preg_match("/0$|5$/",$ctp))
{$NDLcampaigns .= "\n";
echo "\n";
echo "Close Alert ";
echo "Campaigns with no dialable leads:
\n";
echo " \n";
}
}
}
###################################################################################
###### INBOUND/OUTBOUND CALLS
###################################################################################
if ($campaign_allow_inbound > 0)
{
if (eregi('ALL-ACTIVE',$group_string))
{
$stmt="select closer_campaigns from vicidial_campaigns where active='Y' $group_SQLand";
$rslt=mysql_query($stmt, $link);
$closer_campaigns="";
while ($row=mysql_fetch_row($rslt))
{
$closer_campaigns.="$row[0]";
}
$closer_campaigns = preg_replace("/^ | -$/","",$closer_campaigns);
$closer_campaigns = preg_replace("/ - /"," ",$closer_campaigns);
$closer_campaigns = preg_replace("/ /","','",$closer_campaigns);
$closer_campaignsSQL = "'$closer_campaigns'";
}
$stmtB="from vicidial_auto_calls where status NOT IN('XFER') and ( (call_type='IN' and campaign_id IN($closer_campaignsSQL)) or (call_type IN('OUT','OUTBALANCE') $group_SQLand) ) order by queue_priority desc,campaign_id,call_time;";
}
else
{
$stmtB="from vicidial_auto_calls where status NOT IN('XFER') $group_SQLand order by queue_priority desc,campaign_id,call_time;";
}
if ($CALLSdisplay > 0)
{
$stmtA = "SELECT status,campaign_id,phone_number,server_ip,UNIX_TIMESTAMP(call_time),call_type,queue_priority,agent_only";
}
else
{
$stmtA = "SELECT status";
}
$k=0;
$agentonlycount=0;
$stmt = "$stmtA $stmtB";
$rslt=mysql_query($stmt, $link);
if ($DB) {echo "$stmt\n";}
$parked_to_print = mysql_num_rows($rslt);
if ($parked_to_print > 0)
{
$i=0;
$out_total=0;
$out_ring=0;
$out_live=0;
$in_ivr=0;
while ($i < $parked_to_print)
{
$row=mysql_fetch_row($rslt);
if (eregi("LIVE",$row[0]))
{
$out_live++;
if ($CALLSdisplay > 0)
{
$CDstatus[$k] = $row[0];
$CDcampaign_id[$k] = $row[1];
$CDphone_number[$k] = $row[2];
$CDserver_ip[$k] = $row[3];
$CDcall_time[$k] = $row[4];
$CDcall_type[$k] = $row[5];
$CDqueue_priority[$k] = $row[6];
$CDagent_only[$k] = $row[7];
if (strlen($CDagent_only[$k]) > 0) {$agentonlycount++;}
$k++;
}
}
else
{
if (eregi("IVR",$row[0]))
{
$in_ivr++;
if ($CALLSdisplay > 0)
{
$CDstatus[$k] = $row[0];
$CDcampaign_id[$k] = $row[1];
$CDphone_number[$k] = $row[2];
$CDserver_ip[$k] = $row[3];
$CDcall_time[$k] = $row[4];
$CDcall_type[$k] = $row[5];
$CDqueue_priority[$k] = $row[6];
$CDagent_only[$k] = $row[7];
if (strlen($CDagent_only[$k]) > 0) {$agentonlycount++;}
$k++;
}
}
if (eregi("CLOSER",$row[0]))
{$nothing=1;}
else
{$out_ring++;}
}
$out_total++;
$i++;
}
##### MIDI alert audio file test #####
# $test_midi=1;
# if ($test_midi > 0)
# {
# # echo "";
# # echo "";
# echo "";
# echo " test.mid ";
# echo " ";
# }
if ($out_live > 0) {$F=''; $FG=' ';}
if ($out_live > 4) {$F=''; $FG=' ';}
if ($out_live > 9) {$F=''; $FG=' ';}
if ($out_live > 14) {$F=''; $FG=' ';}
if ($campaign_allow_inbound > 0)
{echo "$NFB$out_total$NFE current active calls \n";}
else
{echo "$NFB$out_total$NFE calls being placed \n";}
echo "$NFB$out_ring$NFE calls ringing \n";
echo "$NFB$F $out_live $FG$NFE calls waiting for agents \n";
echo "$NFB $in_ivr$NFE calls in IVR \n";
}
else
{
echo " NO LIVE CALLS WAITING \n";
}
###################################################################################
###### CALLS WAITING
###################################################################################
$agentonlyheader = '';
if ($agentonlycount > 0)
{$agentonlyheader = 'AGENTONLY';}
$Cecho = '';
$Cecho .= "VICIDIAL: Calls Waiting $NOW_TIME\n";
$Cecho .= "+--------+----------------------+--------------+-----------------+---------+------------+----------+\n";
$Cecho .= "| STATUS | CAMPAIGN | PHONE NUMBER | SERVER_IP | DIALTIME| CALL TYPE | PRIORITY | $agentonlyheader\n";
$Cecho .= "+--------+----------------------+--------------+-----------------+---------+------------+----------+\n";
$p=0;
while($p<$k)
{
$Cstatus = sprintf("%-6s", $CDstatus[$p]);
$Ccampaign_id = sprintf("%-20s", $CDcampaign_id[$p]);
$Cphone_number = sprintf("%-12s", $CDphone_number[$p]);
$Cserver_ip = sprintf("%-15s", $CDserver_ip[$p]);
$Ccall_type = sprintf("%-10s", $CDcall_type[$p]);
$Cqueue_priority = sprintf("%8s", $CDqueue_priority[$p]);
$Cagent_only = sprintf("%8s", $CDagent_only[$p]);
$Ccall_time_S = ($STARTtime - $CDcall_time[$p]);
$Ccall_time_MS = sec_convert($Ccall_time_S,'M');
$Ccall_time_MS = sprintf("%7s", $Ccall_time_MS);
$G = ''; $EG = '';
if ($CDcall_type[$p] == 'IN')
{
$G=""; $EG=' PHONE |";
if ($RTajax > 0)
{$HTphone = " PHONE |";}
$HDuser = "------------------------+";
$HTuser = " USER ";
if ($RTajax > 0)
{$HTuser = " USER ";}
if ($UidORname>0)
{
if ($RTajax > 0)
{$HTuser .= "SHOW ID ";}
else
{
$HTuser .= "SHOW ID ";
}
}
else
{
if ($RTajax > 0)
{$HTuser .= "SHOW NAME ";}
else
{
$HTuser .= "SHOW NAME ";
}
}
$HTuser .= " INFO |";
$HDusergroup = "--------------+";
$HTusergroup = " USER GROUP |";
if ($RTajax > 0)
{$HTusergroup = " USER GROUP |";}
$HDsessionid = "------------------+";
$HTsessionid = " SESSIONID |";
$HDbarge = "-------+";
$HTbarge = " BARGE |";
$HDstatus = "----------+";
$HTstatus = " STATUS |";
$HDcustphone = "-------------+";
$HTcustphone = " CUST PHONE |";
$HDserver_ip = "-----------------+";
$HTserver_ip = " SERVER IP |";
$HDcall_server_ip = "-----------------+";
$HTcall_server_ip = " CALL SERVER IP |";
$HDtime = "---------+";
$HTtime = " MM:SS |";
if ($RTajax > 0)
{$HTtime = " MM:SS |";}
$HDcampaign = "------------+";
$HTcampaign = " CAMPAIGN |";
if ($RTajax > 0)
{$HTcampaign = " CAMPAIGN |";}
$HDcalls = "-------+";
$HTcalls = " CALLS |";
$HDpause = '';
$HTpause = '';
$HDigcall = "------+------------------";
$HTigcall = " HOLD | IN-GROUP ";
if (!ereg("N",$agent_pause_codes_active))
{
$HDstatus = "----------";
$HTstatus = " STATUS ";
$HDpause = "-------+";
$HTpause = " PAUSE |";
}
if ($PHONEdisplay < 1)
{
$HDphone = '';
$HTphone = '';
}
if ($CUSTPHONEdisplay < 1)
{
$HDcustphone = '';
$HTcustphone = '';
}
if ($UGdisplay < 1)
{
$HDusergroup = '';
$HTusergroup = '';
}
if ( ($SIPmonitorLINK<1) and ($IAXmonitorLINK<1) and (!preg_match("/MONITOR|BARGE/",$monitor_active) ) )
{
$HDsessionid = "-----------+";
$HTsessionid = " SESSIONID |";
}
if ( ($SIPmonitorLINK<2) and ($IAXmonitorLINK<2) and (!preg_match("/BARGE/",$monitor_active) ) )
{
$HDbarge = '';
$HTbarge = '';
}
if ($SERVdisplay < 1)
{
$HDserver_ip = '';
$HTserver_ip = '';
$HDcall_server_ip = '';
$HTcall_server_ip = '';
}
if ($realtime_block_user_info > 0)
{
$Aline = "$HDbegin$HDusergroup$HDsessionid$HDbarge$HDstatus$HDpause$HDcustphone$HDserver_ip$HDcall_server_ip$HDtime$HDcampaign$HDcalls$HDigcall\n";
$Bline = "$HTbegin$HTusergroup$HTsessionid$HTbarge$HTstatus$HTpause$HTcustphone$HTserver_ip$HTcall_server_ip$HTtime$HTcampaign$HTcalls$HTigcall\n";
}
else
{
$Aline = "$HDbegin$HDstation$HDphone$HDuser$HDusergroup$HDsessionid$HDbarge$HDstatus$HDpause$HDcustphone$HDserver_ip$HDcall_server_ip$HDtime$HDcampaign$HDcalls$HDigcall\n";
$Bline = "$HTbegin$HTstation$HTphone$HTuser$HTusergroup$HTsessionid$HTbarge$HTstatus$HTpause$HTcustphone$HTserver_ip$HTcall_server_ip$HTtime$HTcampaign$HTcalls$HTigcall\n";
}
$Aecho .= "$Aline";
$Aecho .= "$Bline";
$Aecho .= "$Aline";
if ($orderby=='timeup') {$orderSQL='vicidial_live_agents.status,last_call_time';}
if ($orderby=='timedown') {$orderSQL='vicidial_live_agents.status desc,last_call_time desc';}
if ($orderby=='campaignup') {$orderSQL='vicidial_live_agents.campaign_id,vicidial_live_agents.status,last_call_time';}
if ($orderby=='campaigndown') {$orderSQL='vicidial_live_agents.campaign_id desc,vicidial_live_agents.status desc,last_call_time desc';}
if ($orderby=='groupup') {$orderSQL='user_group,vicidial_live_agents.status,last_call_time';}
if ($orderby=='groupdown') {$orderSQL='user_group desc,vicidial_live_agents.status desc,last_call_time desc';}
if ($orderby=='phoneup') {$orderSQL='extension,server_ip';}
if ($orderby=='phonedown') {$orderSQL='extension desc,server_ip desc';}
if ($UidORname > 0)
{
if ($orderby=='userup') {$orderSQL='full_name,status,last_call_time';}
if ($orderby=='userdown') {$orderSQL='full_name desc,status desc,last_call_time desc';}
}
else
{
if ($orderby=='userup') {$orderSQL='vicidial_live_agents.user';}
if ($orderby=='userdown') {$orderSQL='vicidial_live_agents.user desc';}
}
if ( (eregi('ALL-ACTIVE',$group_string)) and (strlen($group_SQL) < 3) ) {$UgroupSQL = '';}
else {$UgroupSQL = " and vicidial_live_agents.campaign_id IN($group_SQL)";}
if (strlen($usergroup)<1) {$usergroupSQL = '';}
else {$usergroupSQL = " and user_group='" . mysql_real_escape_string($usergroup) . "'";}
$ring_agents=0;
$stmt="select extension,vicidial_live_agents.user,conf_exten,vicidial_live_agents.status,vicidial_live_agents.server_ip,UNIX_TIMESTAMP(last_call_time),UNIX_TIMESTAMP(last_call_finish),call_server_ip,vicidial_live_agents.campaign_id,vicidial_users.user_group,vicidial_users.full_name,vicidial_live_agents.comments,vicidial_live_agents.calls_today,vicidial_live_agents.callerid,lead_id,UNIX_TIMESTAMP(last_state_change),on_hook_agent,ring_callerid,agent_log_id from vicidial_live_agents,vicidial_users where vicidial_live_agents.user=vicidial_users.user $UgroupSQL $usergroupSQL order by $orderSQL;";
$rslt=mysql_query($stmt, $link);
if ($DB) {echo "$stmt\n";}
$talking_to_print = mysql_num_rows($rslt);
if ($talking_to_print > 0)
{
$i=0;
while ($i < $talking_to_print)
{
$row=mysql_fetch_row($rslt);
$Aextension[$i] = $row[0];
$Auser[$i] = $row[1];
$Asessionid[$i] = $row[2];
$Astatus[$i] = $row[3];
$Aserver_ip[$i] = $row[4];
$Acall_time[$i] = $row[5];
$Acall_finish[$i] = $row[6];
$Acall_server_ip[$i] = $row[7];
$Acampaign_id[$i] = $row[8];
$Auser_group[$i] = $row[9];
$Afull_name[$i] = $row[10];
$Acomments[$i] = $row[11];
$Acalls_today[$i] = $row[12];
$Acallerid[$i] = $row[13];
$Alead_id[$i] = $row[14];
$Astate_change[$i] = $row[15];
$Aon_hook_agent[$i] = $row[16];
$Aring_callerid[$i] = $row[17];
$Aagent_log_id[$i] = $row[18];
$Aring_note[$i] = ' ';
if ($Aon_hook_agent[$i] == 'Y')
{
$Aring_note[$i] = '*';
$ring_agents++;
if (strlen($Aring_callerid[$i]) > 18)
{$Astatus[$i]="RING";}
}
### 3-WAY Check ###
if ($Alead_id[$i]!=0)
{
$threewaystmt="select UNIX_TIMESTAMP(last_call_time) from vicidial_live_agents where lead_id='$Alead_id[$i]' and status='INCALL' order by UNIX_TIMESTAMP(last_call_time) desc";
$threewayrslt=mysql_query($threewaystmt, $link);
if (mysql_num_rows($threewayrslt)>1)
{
$Astatus[$i]="3-WAY";
$srow=mysql_fetch_row($threewayrslt);
$Acall_mostrecent[$i]=$srow[0];
}
}
### END 3-WAY Check ###
$i++;
}
$callerids='';
$pausecode='';
$stmt="select callerid,lead_id,phone_number from vicidial_auto_calls;";
$rslt=mysql_query($stmt, $link);
if ($DB) {echo "$stmt\n";}
$calls_to_list = mysql_num_rows($rslt);
if ($calls_to_list > 0)
{
$i=0;
while ($i < $calls_to_list)
{
$row=mysql_fetch_row($rslt);
$callerids .= "$row[0]|";
$VAClead_ids[$i] = $row[1];
$VACphones[$i] = $row[2];
$i++;
}
}
### Lookup phone logins
$i=0;
while ($i < $talking_to_print)
{
if (eregi("R/",$Aextension[$i]))
{
$protocol = 'EXTERNAL';
$dialplan = eregi_replace('R/',"",$Aextension[$i]);
$dialplan = eregi_replace("\@.*",'',$dialplan);
$exten = "dialplan_number='$dialplan'";
}
if (eregi("Local/",$Aextension[$i]))
{
$protocol = 'EXTERNAL';
$dialplan = eregi_replace('Local/',"",$Aextension[$i]);
$dialplan = eregi_replace("\@.*",'',$dialplan);
$exten = "dialplan_number='$dialplan'";
}
if (eregi('SIP/',$Aextension[$i]))
{
$protocol = 'SIP';
$dialplan = eregi_replace('SIP/',"",$Aextension[$i]);
$dialplan = eregi_replace("-.*",'',$dialplan);
$exten = "extension='$dialplan'";
}
if (eregi('IAX2/',$Aextension[$i]))
{
$protocol = 'IAX2';
$dialplan = eregi_replace('IAX2/',"",$Aextension[$i]);
$dialplan = eregi_replace("-.*",'',$dialplan);
$exten = "extension='$dialplan'";
}
if (eregi('Zap/',$Aextension[$i]))
{
$protocol = 'Zap';
$dialplan = eregi_replace('Zap/',"",$Aextension[$i]);
$exten = "extension='$dialplan'";
}
if (eregi('DAHDI/',$Aextension[$i]))
{
$protocol = 'Zap';
$dialplan = eregi_replace('DAHDI/',"",$Aextension[$i]);
$exten = "extension='$dialplan'";
}
$stmt="select login from phones where server_ip='$Aserver_ip[$i]' and $exten and protocol='$protocol';";
$rslt=mysql_query($stmt, $link);
if ($DB) {echo "$stmt\n";}
$phones_to_print = mysql_num_rows($rslt);
if ($phones_to_print > 0)
{
$row=mysql_fetch_row($rslt);
$Alogin[$i] = "$row[0]-----$i";
}
else
{
$Alogin[$i] = "$Aextension[$i]-----$i";
}
$i++;
}
### Sort by phone if selected
if ($orderby=='phoneup')
{
sort($Alogin);
}
if ($orderby=='phonedown')
{
rsort($Alogin);
}
### Run through the loop to display agents
$j=0;
$agentcount=0;
while ($j < $talking_to_print)
{
$n=0;
$custphone='';
while ($n < $calls_to_list)
{
if ( (ereg("$VAClead_ids[$n]", $Alead_id[$j])) and (strlen($VAClead_ids[$n]) == strlen($Alead_id[$j])) )
{$custphone = $VACphones[$n];}
$n++;
}
$phone_split = explode("-----",$Alogin[$j]);
$i = $phone_split[1];
if (eregi("READY|PAUSED",$Astatus[$i]))
{
$Acall_time[$i]=$Astate_change[$i];
if ($Alead_id[$i] > 0)
{
$Astatus[$i] = 'DISPO';
$Lstatus = 'DISPO';
$status = ' DISPO';
}
}
if ($non_latin < 1)
{
$extension = eregi_replace('Local/',"",$Aextension[$i]);
$extension = sprintf("%-14s", $extension);
while(strlen($extension)>14) {$extension = substr("$extension", 0, -1);}
}
else
{
$extension = eregi_replace('Local/',"",$Aextension[$i]);
$extension = sprintf("%-48s", $extension);
while(mb_strlen($extension, 'utf-8')>14) {$extension = mb_substr("$extension", 0, -1,'utf8');}
}
$phone = sprintf("%-12s", $phone_split[0]);
$custphone = sprintf("%-11s", $custphone);
$Luser = $Auser[$i];
$user = sprintf("%-20s", $Auser[$i]);
$Lsessionid = $Asessionid[$i];
$sessionid = sprintf("%-9s", $Asessionid[$i]);
$Lstatus = $Astatus[$i];
$status = sprintf("%-6s", $Astatus[$i]);
$Lserver_ip = $Aserver_ip[$i];
$server_ip = sprintf("%-15s", $Aserver_ip[$i]);
$call_server_ip = sprintf("%-15s", $Acall_server_ip[$i]);
$campaign_id = sprintf("%-10s", $Acampaign_id[$i]);
$comments= $Acomments[$i];
$calls_today = sprintf("%-5s", $Acalls_today[$i]);
if (!ereg("N",$agent_pause_codes_active))
{$pausecode=' ';}
else
{$pausecode='';}
if (eregi("INCALL",$Lstatus))
{
$stmtP="select count(*) from parked_channels where channel_group='$Acallerid[$i]';";
$rsltP=mysql_query($stmtP,$link);
$rowP=mysql_fetch_row($rsltP);
$parked_channel = $rowP[0];
if ($parked_channel > 0)
{
$Astatus[$i] = 'PARK';
$Lstatus = 'PARK';
$status = ' PARK ';
}
else
{
if (!ereg("$Acallerid[$i]\|",$callerids))
{
$Acall_time[$i]=$Astate_change[$i];
$Astatus[$i] = 'DEAD';
$Lstatus = 'DEAD';
$status = ' DEAD ';
}
}
if ( (eregi("AUTO",$comments)) or (strlen($comments)<1) )
{$CM='A';}
else
{
if (eregi("INBOUND",$comments))
{$CM='I';}
else
{$CM='M';}
}
}
else {$CM=' ';}
if ($UGdisplay > 0)
{
if ($non_latin < 1)
{
$user_group = sprintf("%-12s", $Auser_group[$i]);
while(strlen($user_group)>12) {$user_group = substr("$user_group", 0, -1);}
}
else
{
$user_group = sprintf("%-40s", $Auser_group[$i]);
while(mb_strlen($user_group, 'utf-8')>12) {$user_group = mb_substr("$user_group", 0, -1,'utf8');}
}
}
if ($UidORname > 0)
{
if ($non_latin < 1)
{
$user = sprintf("%-20s", $Afull_name[$i]);
while(strlen($user)>20) {$user = substr("$user", 0, -1);}
}
else
{
$user = sprintf("%-60s", $Afull_name[$i]);
while(mb_strlen($user, 'utf-8')>20) {$user = mb_substr("$user", 0, -1,'utf8');}
}
}
if (!eregi("INCALL|QUEUE|PARK|3-WAY",$Astatus[$i]))
{$call_time_S = ($STARTtime - $Astate_change[$i]);}
else if (eregi("3-WAY",$Astatus[$i]))
{$call_time_S = ($STARTtime - $Acall_mostrecent[$i]);}
else
{$call_time_S = ($STARTtime - $Acall_time[$i]);}
$call_time_MS = sec_convert($call_time_S,'M');
$call_time_MS = sprintf("%7s", $call_time_MS);
$call_time_MS = " $call_time_MS";
$G = ''; $EG = '';
if ( ($Lstatus=='INCALL') or ($Lstatus=='PARK') )
{
if ($call_time_S >= 10) {$G=''; $EG=' '; $EG=' '; $EG=' '; $EG=' '; $EG=' '; $EG=' '; $EG=' '; $EG=' '; $EG=' '; $EG=' '; $EG=' '; $EG=' '; $EG=' '; $EG=' '; $EG=' '; $EG=' '; $EG=' LISTEN "; $R='';}
if ($IAXmonitorLINK>0) {$L=" LISTEN "; $R='';}
if ($SIPmonitorLINK>1) {$R=" | BARGE ";}
if ($IAXmonitorLINK>1) {$R=" | BARGE ";}
if ( (strlen($monitor_phone)>1) and (preg_match("/MONITOR|BARGE/",$monitor_active) ) )
{$L=" LISTEN "; $R='';}
if ( (strlen($monitor_phone)>1) and (preg_match("/BARGE/",$monitor_active) ) )
{$R=" | BARGE ";}
if ($CUSTPHONEdisplay > 0) {$CP = " $G$custphone$EG |";}
else {$CP = "";}
if ($UGdisplay > 0) {$UGD = " $G$user_group$EG |";}
else {$UGD = "";}
if ($SERVdisplay > 0) {$SVD = " $G$server_ip$EG | $G$call_server_ip$EG |";}
else {$SVD = "";}
if ($PHONEdisplay > 0) {$phoneD = "$G$phone$EG | ";}
else {$phoneD = " ";}
$vac_stage='';
$vac_campaign='';
$INGRP='';
if ($CM == 'I')
{
$stmt="select vac.campaign_id,vac.stage,vig.group_name from vicidial_auto_calls vac,vicidial_inbound_groups vig where vac.callerid='$Acallerid[$i]' and vac.campaign_id=vig.group_id LIMIT 1;";
$rslt=mysql_query($stmt, $link);
if ($DB) {echo "$stmt\n";}
$ingrp_to_print = mysql_num_rows($rslt);
if ($ingrp_to_print > 0)
{
$row=mysql_fetch_row($rslt);
$vac_campaign = sprintf("%-20s", "$row[0] - $row[2]");
$row[1] = eregi_replace(".*-",'',$row[1]);
$vac_stage = sprintf("%-4s", $row[1]);
}
$INGRP = " $G$vac_stage$EG | $G$vac_campaign$EG ";
}
$agentcount++;
if ($realtime_block_user_info > 0)
{
$Aecho .= "|$UGD $G$sessionid$EG$L$R$Aring_note[$i]| $G$status$EG $CM $pausecode|$CP$SVD$G$call_time_MS$EG | $G$campaign_id$EG | $G$calls_today$EG |$INGRP\n";
}
if ($realtime_block_user_info < 1)
{
$Aecho .= "| $G$extension$EG$Aring_note[$i]|$phoneD$G$user$EG + |$UGD $G$sessionid$EG$L$R | $G$status$EG $CM $pausecode|$CP$SVD$G$call_time_MS$EG | $G$campaign_id$EG | $G$calls_today$EG |$INGRP\n";
}
$j++;
}
$Aecho .= "$Aline";
$Aecho .= " $agentcount agents logged in on all servers\n";
$Aecho .= " System Load Average: $load_ave \n\n";
# $Aecho .= " * Denotes on-hook agent '; $BG=' ';}
if ($agent_ready > 4) {$B=''; $BG=' ';}
if ($agent_ready > 9) {$B=''; $BG=' ';}
if ($agent_ready > 14) {$B=''; $BG=' ';}
echo "\n";
echo "";
echo "$Cecho";
echo "$Aecho";
}
else
{
echo " NO AGENTS ON CALLS \n";
echo "$Cecho";
}
echo " ";
if ($RTajax < 1)
{
echo "
";
}
?>
\n";
#echo "