| "; echo " |
\n"; echo " -"._QXZ("READY")." -"._QXZ("INCALL")." -"._QXZ("PAUSED")." \n"; if (preg_match("/NOT-LOGGED-IN-AGENTS/",$agent_status_viewable_groups)) {echo " "._QXZ("-LOGGED-OUT")." \n";} echo "\n"; } ################################################################################ ### CALLSINQUEUEview - List calls in queue for the bottombar 228 ################################################################################ if ($ACTION == 'CALLSINQUEUEview') { $stmt="SELECT view_calls_in_queue,grab_calls_in_queue,calls_waiting_vl_one,calls_waiting_vl_two,disable_alter_custphone from vicidial_campaigns where campaign_id='$campaign'"; if ($non_latin > 0) {$rslt=mysql_to_mysqli("SET NAMES 'UTF8'", $link);} $rslt=mysql_to_mysqli($stmt, $link); if ($mel > 0) {mysql_error_logging($NOW_TIME,$link,$mel,$stmt,'00228',$user,$server_ip,$session_name,$one_mysql_log);} $row=mysqli_fetch_row($rslt); $view_calls_in_queue = $row[0]; $grab_calls_in_queue = $row[1]; $calls_waiting_vl_one = $row[2]; $calls_waiting_vl_two = $row[3]; $disable_alter_custphone = $row[4]; if (preg_match('/NONE/i',$view_calls_in_queue)) { echo _QXZ("Calls in Queue View Disabled for this campaign")."\n"; if ($SSagent_debug_logging > 0) {vicidial_ajax_log($NOW_TIME,$startMS,$link,$ACTION,$php_script,$user,$stage,$lead_id,$session_name,$stmt);} exit; } else { $view_calls_in_queue = preg_replace('/ALL/','99', $view_calls_in_queue); ### grab the status and campaign/in-group information for this agent to display $ADsql=''; $stmt="SELECT status,campaign_id,closer_campaigns from vicidial_live_agents where user='$user' and server_ip='$server_ip';"; if ($DB) {echo "|$stmt|\n";} $rslt=mysql_to_mysqli($stmt, $link); if ($mel > 0) {mysql_error_logging($NOW_TIME,$link,$mel,$stmt,'00229',$user,$server_ip,$session_name,$one_mysql_log);} $row=mysqli_fetch_row($rslt); $Alogin=$row[0]; $Acampaign=$row[1]; $AccampSQL=$row[2]; $AccampSQL = preg_replace('/\s-/','', $AccampSQL); $AccampSQL = preg_replace('/\s/',"','", $AccampSQL); if (preg_match('/AGENTDIRECT/i', $AccampSQL)) { $ADsql = "or ( (campaign_id IN('$AccampSQL')) and (agent_only='$user') )"; $AccampSQL = preg_replace('/AGENTDIRECT/i','', $AccampSQL); } ### grab the basic data on calls in the queue for this agent $stmt="SELECT lead_id,campaign_id,phone_number,uniqueid,UNIX_TIMESTAMP(call_time),call_type,auto_call_id from vicidial_auto_calls where status IN('LIVE') and ( (campaign_id='$Acampaign') or (campaign_id IN('$AccampSQL')) $ADsql) order by queue_priority,call_time;"; if ($DB) {echo "|$stmt|\n";} $rslt=mysql_to_mysqli($stmt, $link); if ($mel > 0) {mysql_error_logging($NOW_TIME,$link,$mel,$stmt,'00230',$user,$server_ip,$session_name,$one_mysql_log);} if ($rslt) {$calls_count = mysqli_num_rows($rslt);} $CQlead_id = array(); $CQcampaign_id = array(); $CQphone_number = array(); $CQuniqueid = array(); $CQcall_time = array(); $CQcall_type = array(); $CQauto_call_id = array(); $loop_count=0; while ($calls_count > $loop_count) { $row=mysqli_fetch_row($rslt); $CQlead_id[$loop_count] = $row[0]; $CQcampaign_id[$loop_count] = $row[1]; $CQphone_number[$loop_count] = $row[2]; $CQuniqueid[$loop_count] = $row[3]; $CQcall_time[$loop_count] = $row[4]; $CQcall_type[$loop_count] = $row[5]; $CQauto_call_id[$loop_count] = $row[6]; $loop_count++; } ### re-order the calls to always make sure the AGENTDIRECT calls are first $loop_count=0; $o=0; while ($calls_count > $loop_count) { if (preg_match('/AGENTDIRECT/i', $CQcampaign_id[$loop_count])) { $OQlead_id[$o] = $CQlead_id[$loop_count]; $OQcampaign_id[$o] = $CQcampaign_id[$loop_count]; $OQphone_number[$o] = $CQphone_number[$loop_count]; $OQuniqueid[$o] = $CQuniqueid[$loop_count]; $OQcall_time[$o] = $CQcall_time[$loop_count]; $OQcall_type[$o] = $CQcall_type[$loop_count]; $OQauto_call_id[$o] = $CQauto_call_id[$loop_count]; $o++; } $loop_count++; } $loop_count=0; while ($calls_count > $loop_count) { if (!preg_match('/AGENTDIRECT/i', $CQcampaign_id[$loop_count])) { $OQlead_id[$o] = $CQlead_id[$loop_count]; $OQcampaign_id[$o] = $CQcampaign_id[$loop_count]; $OQphone_number[$o] = $CQphone_number[$loop_count]; $OQuniqueid[$o] = $CQuniqueid[$loop_count]; $OQcall_time[$o] = $CQcall_time[$loop_count]; $OQcall_type[$o] = $CQcall_type[$loop_count]; $OQauto_call_id[$o] = $CQauto_call_id[$loop_count]; $o++; } $loop_count++; } $calls_waiting_vl_oneSQL=''; $calls_waiting_vl_twoSQL=''; if ( ($calls_waiting_vl_one != 'DISABLED') and (strlen($calls_waiting_vl_one) > 2) ) { $calls_waiting_vl_oneSQL = ",$calls_waiting_vl_one"; if (strlen($calls_waiting_vl_oneLABEL) < 1) {$calls_waiting_vl_oneLABEL = $calls_waiting_vl_one;} } if ( ($calls_waiting_vl_two != 'DISABLED') and (strlen($calls_waiting_vl_two) > 2) ) { $calls_waiting_vl_twoSQL = ",$calls_waiting_vl_two"; if (strlen($calls_waiting_vl_twoLABEL) < 1) {$calls_waiting_vl_twoLABEL = $calls_waiting_vl_two;} } echo "
| "; echo " | "._QXZ("PHONE")." | "; echo ""._QXZ("FULL NAME")." | "; if (strlen($calls_waiting_vl_oneSQL) > 2) {echo ""._QXZ("$calls_waiting_vl_oneLABEL")." | ";} if (strlen($calls_waiting_vl_twoSQL) > 2) {echo ""._QXZ("$calls_waiting_vl_twoLABEL")." | ";} echo ""._QXZ("WAIT")." | "; echo ""._QXZ("AGENT")." | "; echo ""; echo " | "._QXZ("CALL GROUP")." | "; echo ""._QXZ("TYPE")." | "; echo "
| "._QXZ("TAKE CALL")." | "; echo "$OQphone_number[$loop_count] | "; echo "$caller_name | "; if (strlen($calls_waiting_vl_oneSQL) > 2) {echo "$calls_waiting_vl_oneVAL | ";} if (strlen($calls_waiting_vl_twoSQL) > 2) {echo "$calls_waiting_vl_twoVAL | ";} echo "$call_time | "; echo "$agent - $agent_name | "; echo ""; echo " | $OQcampaign_id[$loop_count] - $group_name | "; echo "$OQcall_type[$loop_count] | "; echo "
| "; echo " | $OQphone_number[$loop_count] | "; echo "$caller_name | "; if (strlen($calls_waiting_vl_oneSQL) > 2) {echo "$calls_waiting_vl_oneVAL | ";} if (strlen($calls_waiting_vl_twoSQL) > 2) {echo "$calls_waiting_vl_twoVAL | ";} echo "$call_time | "; echo "$agent - $agent_name | "; echo ""; echo " | $OQcampaign_id[$loop_count] - $group_name | "; echo "$OQcall_type[$loop_count] | "; echo "
\n"; } } ################################################################################ ### CALLLOGview - display one day calls for an agent ################################################################################ if ($ACTION == 'CALLLOGview') { $call_log_view_allowed=0; $VU_user_group=''; $call_log_days=-1; $stmt="SELECT user_group from vicidial_users where user='$user';"; if ($non_latin > 0) {$rslt=mysql_to_mysqli("SET NAMES 'UTF8'", $link);} $rslt=mysql_to_mysqli($stmt, $link); if ($mel > 0) {mysql_error_logging($NOW_TIME,$link,$mel,$stmt,'00983',$user,$server_ip,$session_name,$one_mysql_log);} $cl_user_ct = mysqli_num_rows($rslt); if ($cl_user_ct > 0) { $row=mysqli_fetch_row($rslt); $VU_user_group = $row[0]; } $stmt="SELECT agent_call_log_view from vicidial_user_groups where user_group='$VU_user_group';"; $rslt=mysql_to_mysqli($stmt, $link); if ($mel > 0) {mysql_error_logging($NOW_TIME,$link,$mel,$stmt,'00984',$user,$server_ip,$session_name,$one_mysql_log);} $cl_ug_ct = mysqli_num_rows($rslt); if ($cl_ug_ct > 0) { $row=mysqli_fetch_row($rslt); $agent_call_log_view = $row[0]; if ($agent_call_log_view == 'Y') {$call_log_view_allowed=1;} } $stmt="SELECT call_log_days from vicidial_campaigns where campaign_id='$campaign';"; $rslt=mysql_to_mysqli($stmt, $link); if ($mel > 0) {mysql_error_logging($NOW_TIME,$link,$mel,$stmt,'00985',$user,$server_ip,$session_name,$one_mysql_log);} $cl_camp_ct = mysqli_num_rows($rslt); if ($cl_camp_ct > 0) { $row=mysqli_fetch_row($rslt); $call_log_days = $row[0]; } if ( ($call_log_view_allowed > 0) and ($call_log_days >= 0) ) { if (strlen($date) < 10) {$date = $NOW_DATE;} if (strlen($stage) < 3) {$stage = '670';} $date_check = $date; $date_check = preg_replace('/[^0-9]/','',$date_check); $call_log_days_check=20000101; if ($call_log_days > 0) { $call_log_days_old = mktime(7, 0, 0, date("m"), (date("d") - $call_log_days), date("Y")); $call_log_days_check = date("Ymd",$call_log_days_old); } $date_array = explode("-",$date); $day_next = mktime(7, 0, 0, $date_array[1], ($date_array[2] + 1), $date_array[0]); $next_day_date = date("Y-m-d",$day_next); $day_old = mktime(7, 0, 0, $date_array[1], ($date_array[2] - 1), $date_array[0]); $past_day_date = date("Y-m-d",$day_old); $week_old = mktime(7, 0, 0, $date_array[1], ($date_array[2] - 7), $date_array[0]); $past_week_date = date("Y-m-d",$week_old); if ($call_log_days_check <= $date_check) { echo "
\n"; echo "
| # | "; echo ""._QXZ("DATE/TIME")." | "; echo ""._QXZ("LENGTH")." | "; echo ""._QXZ("STATUS")." | "; echo ""._QXZ("PHONE")." | "; echo ""._QXZ("FULL NAME")." | "; echo ""._QXZ("CAMPAIGN")." | "; echo ""._QXZ("IN/OUT")." | "; echo ""._QXZ("ALT")." | "; echo ""._QXZ("HANGUP")." | "; echo ""._QXZ("INFO")." | "; echo ""._QXZ("DIAL")." | "; echo "|
| "._QXZ("No calls on this day")." | ||||||||||||
| $u | "; echo "$ALLcall_date[$i] | "; echo "$ALLlength_in_sec[$i] | \n"; echo "$ALLstatus[$i] | \n"; echo "$ALLphone_code[$i] $phone_number_display | \n"; echo "$Allfirst_name[$i] $Alllast_name[$i] | \n"; echo "$ALLcampaign_id[$i] | \n"; echo ""._QXZ("$ALLin_out[$i]")." | \n"; echo ""._QXZ("$ALLalt_dial[$i]")." | \n"; echo ""._QXZ("$ALLhangup_reason[$i]")." | \n"; echo ""._QXZ("INFO")." | \n"; if ($manual_dial_filter > 0) {echo ""._QXZ("DIAL")." | \n";} else {echo ""._QXZ("DIAL")." | \n";} echo "
"; echo ""._QXZ("Close Call Log").""; echo "
\n"; echo "
"; echo ""._QXZ("Close Call Log").""; echo "
\n"; echo "
"; echo ""._QXZ("Close Call Log").""; echo "
"; echo ""._QXZ("Go Back").""; echo ""; if ($SSagent_debug_logging > 0) {vicidial_ajax_log($NOW_TIME,$startMS,$link,$ACTION,$php_script,$user,$stage,$lead_id,$session_name,$stmt);} exit; } $searchownerSQL=''; ### limit results to specified search method # USER_, GROUP_, TERRITORY_ if (preg_match('/USER_/',$agent_lead_search_method)) {$searchownerSQL=" and owner='$user'";} if (preg_match('/GROUP_/',$agent_lead_search_method)) { $stmt="SELECT user_group from vicidial_users where user='$user';"; $rslt=mysql_to_mysqli($stmt, $link); if ($mel > 0) {mysql_error_logging($NOW_TIME,$link,$mel,$stmt,'00386',$user,$server_ip,$session_name,$one_mysql_log);} $groups_to_parse = mysqli_num_rows($rslt); if ($groups_to_parse > 0) { $rowx=mysqli_fetch_row($rslt); $searchownerSQL=" and owner='$rowx[0]'"; } } if (preg_match('/TERRITORY_/',$agent_lead_search_method)) { $agent_territories=''; $agent_choose_territories=0; $stmt="SELECT agent_choose_territories from vicidial_users where user='$user';"; $rslt=mysql_to_mysqli($stmt, $link); if ($mel > 0) {mysql_error_logging($NOW_TIME,$link,$mel,$stmt,'00404',$user,$server_ip,$session_name,$one_mysql_log);} $Uterrs_to_parse = mysqli_num_rows($rslt); if ($Uterrs_to_parse > 0) { $rowx=mysqli_fetch_row($rslt); $agent_choose_territories = $rowx[0]; } if ($agent_choose_territories < 1) { $stmt="SELECT territory from vicidial_user_territories where user='$user';"; $rslt=mysql_to_mysqli($stmt, $link); if ($mel > 0) {mysql_error_logging($NOW_TIME,$link,$mel,$stmt,'00405',$user,$server_ip,$session_name,$one_mysql_log);} $vuts_to_parse = mysqli_num_rows($rslt); $o=0; while ($vuts_to_parse > $o) { $rowx=mysqli_fetch_row($rslt); $agent_territories .= "'$rowx[0]',"; $o++; } $agent_territories = preg_replace("/\,$/",'',$agent_territories); $searchownerSQL=" and owner IN($agent_territories)"; if ($vuts_to_parse < 1) {$searchownerSQL=" and lead_id < 0";} } else { $stmt="SELECT agent_territories from vicidial_live_agents where user='$user';"; $rslt=mysql_to_mysqli($stmt, $link); if ($mel > 0) {mysql_error_logging($NOW_TIME,$link,$mel,$stmt,'00387',$user,$server_ip,$session_name,$one_mysql_log);} $terrs_to_parse = mysqli_num_rows($rslt); if ($terrs_to_parse > 0) { $rowx=mysqli_fetch_row($rslt); $agent_territories = $rowx[0]; $agent_territories = preg_replace("/ -$|^ /",'',$agent_territories); $agent_territories = preg_replace("/ /","','",$agent_territories); $searchownerSQL=" and owner IN('$agent_territories')"; } } } ### limit results to specified search method # 'SYSTEM','CAMPAIGNLISTS','CAMPLISTS_ALL','LIST' if (preg_match('/SYSTEM/',$agent_lead_search_method)) {$searchmethodSQL='';} if (preg_match('/LIST/',$agent_lead_search_method)) {$searchmethodSQL=" and list_id='$manual_dial_list_id'";} if (preg_match('/CAMPLISTS_ALL/',$agent_lead_search_method)) { $stmt="SELECT list_id from vicidial_lists where campaign_id='$campaign';"; $rslt=mysql_to_mysqli($stmt, $link); if ($mel > 0) {mysql_error_logging($NOW_TIME,$link,$mel,$stmt,'00375',$user,$server_ip,$session_name,$one_mysql_log);} $lists_to_parse = mysqli_num_rows($rslt); $camp_lists=''; $o=0; while ($lists_to_parse > $o) { $rowx=mysqli_fetch_row($rslt); $camp_lists .= "'$rowx[0]',"; $o++; } $camp_lists = preg_replace("/.$/i","",$camp_lists); if (strlen($camp_lists)<2) {$camp_lists="''";} $searchmethodSQL=" and list_id IN($camp_lists)"; } if (preg_match('/CAMPAIGNLISTS/',$agent_lead_search_method)) { $stmt="SELECT list_id,active from vicidial_lists where campaign_id='$campaign' and active='Y';"; $rslt=mysql_to_mysqli($stmt, $link); if ($mel > 0) {mysql_error_logging($NOW_TIME,$link,$mel,$stmt,'00376',$user,$server_ip,$session_name,$one_mysql_log);} $lists_to_parse = mysqli_num_rows($rslt); $camp_lists=''; $o=0; while ($lists_to_parse > $o) { $rowx=mysqli_fetch_row($rslt); $camp_lists .= "'$rowx[0]',"; $o++; } $camp_lists = preg_replace("/.$/i","",$camp_lists); if (strlen($camp_lists)<2) {$camp_lists="''";} $searchmethodSQL=" and list_id IN($camp_lists)"; } if ( ($inbound_lead_search > 0) and ( ($agent_search_ingroup_list == 'ENABLED') or ($agent_search_ingroup_list == 'ENABLED_OVERRIDE') ) ) { if (strlen($inbound_ingroup) > 0) { $stmt="SELECT agent_search_list from vicidial_inbound_groups where group_id='$inbound_ingroup' and agent_search_list != '';"; $rslt=mysql_to_mysqli($stmt, $link); if ($mel > 0) {mysql_error_logging($NOW_TIME,$link,$mel,$stmt,'00986',$user,$server_ip,$session_name,$one_mysql_log);} $igs_to_parse = mysqli_num_rows($rslt); if ($igs_to_parse > 0) { $rowx=mysqli_fetch_row($rslt); if (strlen($rowx[0]) > 1) { if ($agent_search_ingroup_list == 'ENABLED') {$searchmethodSQL .= " and list_id='$rowx[0]'";} if ($agent_search_ingroup_list == 'ENABLED_OVERRIDE') {$searchmethodSQL = " and list_id='$rowx[0]'";} } } } } ##### BEGIN search queries and output ##### $stmt="SELECT count(*) from vicidial_list where $searchSQL $searchownerSQL $searchmethodSQL;"; ### LOG INSERTION Search Log Table ### $SQL_log = "$stmt|"; $SQL_log = preg_replace('/;/','',$SQL_log); $SQL_log = addslashes($SQL_log); $stmtL="INSERT INTO vicidial_lead_search_log set event_date='$NOW_TIME', user='$user', source='agent', results='0', search_query=\"$SQL_log\";"; if ($DB) {echo "|$stmtL|\n";} $rslt=mysql_to_mysqli($stmtL, $link); if ($mel > 0) {mysql_error_logging($NOW_TIME,$link,$mel,$stmt,'00377',$user,$server_ip,$session_name,$one_mysql_log);} $search_log_id = mysqli_insert_id($link); $rslt=mysql_to_mysqli($stmt, $link); if ($mel > 0) {mysql_error_logging($NOW_TIME,$link,$mel,$stmt,'00378',$user,$server_ip,$session_name,$one_mysql_log);} $counts_to_print = mysqli_num_rows($rslt); if ($counts_to_print > 0) { $row=mysqli_fetch_row($rslt); $search_result_count = $row[0]; $end_process_time = date("U"); $search_seconds = ($end_process_time - $StarTtime); $stmtL="UPDATE vicidial_lead_search_log set results='$search_result_count',seconds='$search_seconds' where search_log_id='$search_log_id';"; if ($DB) {echo "|$stmtL|\n";} $rslt=mysql_to_mysqli($stmtL, $link); if ($mel > 0) {mysql_error_logging($NOW_TIME,$link,$mel,$stmt,'00379',$user,$server_ip,$session_name,$one_mysql_log);} echo "
\n"; echo "
| # | "; echo ""._QXZ($label_first_name)." "._QXZ($label_last_name)." | "; echo ""._QXZ($label_phone_number)." | "; echo ""._QXZ("STATUS")." | "; echo ""._QXZ("LAST CALL")." | "; echo ""._QXZ($label_city)." | "; echo ""._QXZ($label_state)." | "; echo ""._QXZ($label_postal_code)." | "; echo ""._QXZ($label_vendor_lead_code)." | "; echo ""._QXZ("INFO")." | "; echo ""._QXZ("DIAL")." | "; echo "||
| "._QXZ("No results found")." | ||||||||||||
| $u | "; echo "$ALLname[$i] | \n"; echo "$ALLphone_code[$i] $ALLphone_number[$i] | \n"; echo "$ALLstatus[$i] | \n"; echo "$ALLcall_date[$i] | \n"; echo "$ALLcity[$i] | \n"; echo "$ALLstate[$i] | \n"; echo "$ALLpostal_code[$i] | \n"; echo "$ALLvendor_lead_code[$i] | \n"; echo ""._QXZ("INFO")." | \n"; if ($inbound_lead_search < 1) { if ($manual_dial_filter > 0) {echo ""._QXZ("DIAL")." | \n";} else {echo ""._QXZ("DIAL")." | \n";} } else { echo ""._QXZ("SELECT")." | \n"; } echo "
| "._QXZ("No results found")." | ||||||||||||
"; echo ""._QXZ("Go Back").""; echo "
"; echo ""._QXZ("Go Back").""; echo ""; if ($SSagent_debug_logging > 0) {vicidial_ajax_log($NOW_TIME,$startMS,$link,$ACTION,$php_script,$user,$stage,$lead_id,$session_name,$stmt);} exit; } ##### END search queries and output ##### } else { echo _QXZ("ERROR").": "._QXZ("Campaign not found")."\n"; echo "
"; echo ""._QXZ("Go Back").""; echo ""; if ($SSagent_debug_logging > 0) {vicidial_ajax_log($NOW_TIME,$startMS,$link,$ACTION,$php_script,$user,$stage,$lead_id,$session_name,$stmt);} exit; } } ################################################################################ ### SEARCHCONTACTSRESULTSview - display search results for contacts search ################################################################################ if ($ACTION == 'SEARCHCONTACTSRESULTSview') { if (strlen($stage) < 3) {$stage = '670';} $stmt="SELECT agent_lead_search_method,manual_dial_list_id,agent_search_ingroup_list from vicidial_campaigns where campaign_id='$campaign';"; if ($non_latin > 0) {$rslt=mysql_to_mysqli("SET NAMES 'UTF8'", $link);} $rslt=mysql_to_mysqli($stmt, $link); if ($mel > 0) {mysql_error_logging($NOW_TIME,$link,$mel,$stmt,'00431',$user,$server_ip,$session_name,$one_mysql_log);} $camps_to_print = mysqli_num_rows($rslt); if ($camps_to_print > 0) { $row=mysqli_fetch_row($rslt); $agent_lead_search_method = $row[0]; $manual_dial_list_id = $row[1]; $agent_search_ingroup_list = $row[2]; $searchSQL=''; $searchmethodSQL=''; $last_name = preg_replace("/\'|\"|\\\\|;/","",$last_name); $first_name = preg_replace("/\'|\"|\\\\|;/","",$first_name); $phone_number = preg_replace("/\'|\"|\\\\|;/","",$phone_number); $bu_name = preg_replace("/\'|\"|\\\\|;/","",$bu_name); $department = preg_replace("/\'|\"|\\\\|;/","",$department); $group_name = preg_replace("/\'|\"|\\\\|;/","",$group_name); $job_title = preg_replace("/\'|\"|\\\\|;/","",$job_title); $location = preg_replace("/\'|\"|\\\\|;/","",$location); if (strlen($phone_number) >= 2) { $searchSQL .= "office_num='$phone_number'"; } elseif (strlen($last_name) > 0) { $searchSQL = "last_name=\"$last_name\""; if (strlen($first_name) > 0) { if (strlen($searchSQL) > 10) {$searchSQL .= " and ";} $searchSQL .= "first_name=\"$first_name\""; } if (strlen($bu_name) > 0) { if (strlen($searchSQL) > 10) {$searchSQL .= " and ";} $searchSQL .= "bu_name=\"$bu_name\""; } if (strlen($department) > 0) { if (strlen($searchSQL) > 10) {$searchSQL .= " and ";} $searchSQL .= "department=\"$department\""; } if (strlen($group_name) > 0) { if (strlen($searchSQL) > 10) {$searchSQL .= " and ";} $searchSQL .= "group_name=\"$group_name\""; } if (strlen($job_title) > 0) { if (strlen($searchSQL) > 10) {$searchSQL .= " and ";} $searchSQL .= "job_title=\"$job_title\""; } if (strlen($location) > 0) { if (strlen($searchSQL) > 10) {$searchSQL .= " and ";} $searchSQL .= "location=\"$location\""; } } elseif (strlen($first_name) > 0) { $searchSQL = "first_name=\"$first_name\""; if (strlen($bu_name) > 0) { if (strlen($searchSQL) > 10) {$searchSQL .= " and ";} $searchSQL .= "bu_name=\"$bu_name\""; } if (strlen($department) > 0) { if (strlen($searchSQL) > 10) {$searchSQL .= " and ";} $searchSQL .= "department=\"$department\""; } if (strlen($group_name) > 0) { if (strlen($searchSQL) > 10) {$searchSQL .= " and ";} $searchSQL .= "group_name=\"$group_name\""; } if (strlen($job_title) > 0) { if (strlen($searchSQL) > 10) {$searchSQL .= " and ";} $searchSQL .= "job_title=\"$job_title\""; } if (strlen($location) > 0) { if (strlen($searchSQL) > 10) {$searchSQL .= " and ";} $searchSQL .= "location=\"$location\""; } } elseif (strlen($bu_name) > 0) { $searchSQL = "bu_name=\"$bu_name\""; if (strlen($department) > 0) { if (strlen($searchSQL) > 10) {$searchSQL .= " and ";} $searchSQL .= "department=\"$department\""; } if (strlen($group_name) > 0) { if (strlen($searchSQL) > 10) {$searchSQL .= " and ";} $searchSQL .= "group_name=\"$group_name\""; } if (strlen($job_title) > 0) { if (strlen($searchSQL) > 10) {$searchSQL .= " and ";} $searchSQL .= "job_title=\"$job_title\""; } if (strlen($location) > 0) { if (strlen($searchSQL) > 10) {$searchSQL .= " and ";} $searchSQL .= "location=\"$location\""; } } elseif (strlen($department) > 0) { $searchSQL = "department=\"$department\""; if (strlen($group_name) > 0) { if (strlen($searchSQL) > 10) {$searchSQL .= " and ";} $searchSQL .= "group_name=\"$group_name\""; } if (strlen($job_title) > 0) { if (strlen($searchSQL) > 10) {$searchSQL .= " and ";} $searchSQL .= "job_title=\"$job_title\""; } if (strlen($location) > 0) { if (strlen($searchSQL) > 10) {$searchSQL .= " and ";} $searchSQL .= "location=\"$location\""; } } elseif (strlen($group_name) > 0) { $searchSQL = "group_name=\"$group_name\""; if (strlen($job_title) > 0) { if (strlen($searchSQL) > 10) {$searchSQL .= " and ";} $searchSQL .= "job_title=\"$job_title\""; } if (strlen($location) > 0) { if (strlen($searchSQL) > 10) {$searchSQL .= " and ";} $searchSQL .= "location=\"$location\""; } } elseif (strlen($job_title) > 0) { $searchSQL = "job_title=\"$job_title\""; if (strlen($location) > 0) { if (strlen($searchSQL) > 10) {$searchSQL .= " and ";} $searchSQL .= "location=\"$location\""; } } elseif (strlen($location) > 0) { $searchSQL = "location=\"$location\""; } else { echo _QXZ("ERROR").": "._QXZ("You must enter in search terms, one of these must be populated: office number, last name, first name")."\n"; echo "
"; echo ""._QXZ("Go Back").""; echo ""; if ($SSagent_debug_logging > 0) {vicidial_ajax_log($NOW_TIME,$startMS,$link,$ACTION,$php_script,$user,$stage,$lead_id,$session_name,$stmt);} exit; } $ALLsort = array(); $ALLfirst = array(); $ALLlast = array(); $ALLoffice_num = array(); $ALLcell_num = array(); $ALLother_num1 = array(); $ALLother_num2 = array(); $ALLbu_name = array(); $ALLdepartment = array(); $ALLgroup_name = array(); $ALLjob_title = array(); $ALLlocation = array(); ##### BEGIN search queries and output ##### $stmt="SELECT count(*) from contact_information where $searchSQL;"; ### LOG INSERTION Search Log Table ### $SQL_log = "$stmt|"; $SQL_log = preg_replace('/;/','',$SQL_log); $SQL_log = addslashes($SQL_log); $stmtL="INSERT INTO vicidial_lead_search_log set event_date='$NOW_TIME', user='$user', source='agent', results='0', search_query=\"$SQL_log\";"; if ($DB) {echo "|$stmtL|\n";} $rslt=mysql_to_mysqli($stmtL, $link); if ($mel > 0) {mysql_error_logging($NOW_TIME,$link,$mel,$stmtL,'00432',$user,$server_ip,$session_name,$one_mysql_log);} $search_log_id = mysqli_insert_id($link); if ( (preg_match("/contact_information/",$tables_use_alt_log_db)) and (strlen($alt_log_server_ip)>4) and (strlen($alt_log_dbname)>0) ) { $linkALT=mysqli_connect("$alt_log_server_ip", "$alt_log_login", "$alt_log_pass"); if (!$linkALT) {die(_QXZ("Could not connect: ")."$alt_log_server_ip|$alt_log_login" . mysqli_connect_error());} mysqli_select_db($linkALT, "$alt_log_dbname"); } else {$linkALT = $link;} $rsltALT=mysql_to_mysqli($stmt, $linkALT); if ($mel > 0) {mysql_error_logging($NOW_TIME,$linkALT,$mel,$stmt,'00433',$user,$server_ip,$session_name,$one_mysql_log);} $counts_to_print = mysqli_num_rows($rsltALT); if ($counts_to_print > 0) { $row=mysqli_fetch_row($rsltALT); $search_result_count = $row[0]; $end_process_time = date("U"); $search_seconds = ($end_process_time - $StarTtime); $stmtL="UPDATE vicidial_lead_search_log set results='$search_result_count',seconds='$search_seconds' where search_log_id='$search_log_id';"; if ($DB) {echo "|$stmtL|\n";} $rslt=mysql_to_mysqli($stmtL, $link); if ($mel > 0) {mysql_error_logging($NOW_TIME,$link,$mel,$stmtL,'00434',$user,$server_ip,$session_name,$one_mysql_log);} echo "
\n"; echo "
| # | "; echo ""._QXZ("FIRST NAME")." | "; echo ""._QXZ("LAST NAME")." | "; echo ""._QXZ("OFFICE")." | "; echo ""._QXZ("MOBILE")." | "; echo ""._QXZ("OTHER 1")." | "; echo ""._QXZ("OTHER 2")." | "; echo ""._QXZ("BU NAME")." | "; echo "||
| "._QXZ("No results found")." | |||||||||
| $u | "; echo "$ALLfirst[$i] | \n"; echo "$ALLlast[$i] | \n"; echo "$ALLoffice_num[$i] | \n"; echo "$ALLcell_num[$i] | \n"; echo "$ALLother_num1[$i] | \n"; echo "$ALLother_num2[$i] | \n"; echo "$ALLbu_name[$i] | \n"; echo "||
| "._QXZ("Dept:")." $ALLdepartment[$i] "._QXZ("Group").": $ALLgroup_name[$i] "._QXZ("Job:")." $ALLjob_title[$i] "._QXZ("Location:")." $ALLlocation[$i] | "; echo "|||||||||
| "._QXZ("No results found")." | |||||||||
"; echo ""._QXZ("Go Back").""; echo "
"; echo ""._QXZ("Go Back").""; echo ""; if ($SSagent_debug_logging > 0) {vicidial_ajax_log($NOW_TIME,$startMS,$link,$ACTION,$php_script,$user,$stage,$lead_id,$session_name,$stmt);} exit; } ##### END search queries and output ##### } else { echo _QXZ("ERROR").": "._QXZ("Campaign not found")."\n"; echo "
"; echo ""._QXZ("Go Back").""; echo ""; if ($SSagent_debug_logging > 0) {vicidial_ajax_log($NOW_TIME,$startMS,$link,$ACTION,$php_script,$user,$stage,$lead_id,$session_name,$stmt);} exit; } } ################################################################################ ### LEADINFOview - display the information for a lead and logs for that lead ################################################################################ if ($ACTION == 'LEADINFOview') { $CB_force_dial_flag=0; if (strlen($lead_id) < 1) { if ($callback_id == 'FORCED') { $CB_force_dial_flag=1; $campaignCBhoursSQL = ''; $campaignCBdisplaydaysSQL = ''; $stmt = "SELECT callback_hours_block,callback_list_calltime,local_call_time,callback_display_days from vicidial_campaigns where campaign_id='$campaign';"; $rslt=mysql_to_mysqli($stmt, $link); if ($mel > 0) {mysql_error_logging($NOW_TIME,$link,$mel,$stmt,'00761',$user,$server_ip,$session_name,$one_mysql_log);} if ($rslt) {$camp_count = mysqli_num_rows($rslt);} if ($camp_count > 0) { $row=mysqli_fetch_row($rslt); $callback_hours_block = $row[0]; $callback_list_calltime = $row[1]; $local_call_time = $row[2]; $callback_display_days = $row[3]; if ($callback_hours_block > 0) { $x_hours_ago = date("Y-m-d H:i:s", mktime(date("H")-$callback_hours_block,date("i"),date("s"),date("m"),date("d"),date("Y"))); $campaignCBhoursSQL = "and entry_time < \"$x_hours_ago\""; } if ($callback_display_days > 0) { $x_days_from_now = date("Y-m-d H:i:s", mktime(0,0,0,date("m"),date("d")+$callback_display_days,date("Y"))); $campaignCBdisplaydaysSQL = "and callback_time < \"$x_days_from_now\""; } } $campaignCBsql = ''; if ($agentonly_callback_campaign_lock > 0) {$campaignCBsql = "and campaign_id='$campaign'";} $stmt = "SELECT callback_id,lead_id from vicidial_callbacks where recipient='USERONLY' and user='$user' $campaignCBsql $campaignCBhoursSQL $campaignCBdisplaydaysSQL and status IN('LIVE') order by callback_time limit 1;"; if ($DB) {echo "$stmt\n";} $rslt=mysql_to_mysqli($stmt, $link); if ($mel > 0) {mysql_error_logging($NOW_TIME,$link,$mel,$stmt,'00762',$user,$server_ip,$session_name,$one_mysql_log);} if ($rslt) {$callbacks_count = mysqli_num_rows($rslt);} if ($callbacks_count > 0) { $row=mysqli_fetch_row($rslt); $callback_id = $row[0]; $lead_id = $row[1]; } else { echo "ERROR: "._QXZ("no LIVE Callbacks found"); } } else {echo "ERROR: "._QXZ("no Lead ID");} } if (strlen($lead_id) > 0) { $hide_dial_links=0; echo "
| "._QXZ("Callback Status:")." | "._QXZ("$row[0]")." |
| "._QXZ("Callback Lead Status:")." | $row[7] |
| "._QXZ("Callback Entry Time:")." | $row[1] |
| "._QXZ("Callback Trigger Time:")." | $row[2] |
| "._QXZ("Callback Customer Timezone:")." | $temp_timezone |
| "._QXZ("Callback Customer Time:")." | $row[10] |
| "._QXZ("Callback Comments:")." | $row[6] |
"; if ($CB_force_dial_flag < 1) {$hide_dial_links++;} } } ### END Display callback information ### ### find the screen_label for this campaign $stmt="SELECT screen_labels,hide_call_log_info from vicidial_campaigns where campaign_id='$campaign';"; $rslt=mysql_to_mysqli($stmt, $link); if ($mel > 0) {mysql_error_logging($NOW_TIME,$link,$mel,$stmt,'00416',$user,$server_ip,$session_name,$one_mysql_log);} $csl_to_print = mysqli_num_rows($rslt); if ($format=='debug') {echo "|$csl_to_print|$stmt|";} if ($csl_to_print > 0) { $row=mysqli_fetch_row($rslt); $screen_labels = $row[0]; $hide_call_log_info = $row[1]; } ### find the user-override setting for this user for call log view $stmt="SELECT hide_call_log_info from vicidial_users where user='$user';"; $rslt=mysql_to_mysqli($stmt, $link); if ($mel > 0) {mysql_error_logging($NOW_TIME,$link,$mel,$stmt,'00793',$user,$server_ip,$session_name,$one_mysql_log);} $csl_to_print = mysqli_num_rows($rslt); if ($format=='debug') {echo "|$csl_to_print|$stmt|";} if ($csl_to_print > 0) { $row=mysqli_fetch_row($rslt); $VU_hide_call_log_info = $row[0]; if ($VU_hide_call_log_info != 'DISABLED') {$hide_call_log_info = $VU_hide_call_log_info;} } ### BEGIN Display lead info and custom fields ### ### BEGIN find any custom field labels ### $INFOout=''; $label_title = _QXZ(" Title"); $label_first_name = _QXZ("First"); $label_middle_initial = _QXZ("MI"); $label_last_name = _QXZ("Last "); $label_address1 = _QXZ("Address1"); $label_address2 = _QXZ("Address2"); $label_address3 = _QXZ("Address3"); $label_city = _QXZ("City"); $label_state = _QXZ(" State"); $label_province = _QXZ("Province"); $label_postal_code = _QXZ("PostCode"); $label_vendor_lead_code = _QXZ("Vendor ID"); $label_gender = _QXZ(" Gender"); $label_phone_number = _QXZ("Phone"); $label_phone_code = _QXZ("DialCode"); $label_alt_phone = _QXZ("Alt. Phone"); $label_security_phrase = _QXZ("Show"); $label_email = _QXZ(" Email"); $label_comments = _QXZ(" Comments"); $label_lead_id = _QXZ("Lead ID"); $label_list_id = _QXZ("List ID"); $label_entry_date = _QXZ("Entry Date"); $label_gmt_offset_now = _QXZ("Timezone"); $label_source_id = _QXZ("Source ID"); $label_called_since_last_reset = _QXZ("Reset Code"); $label_status = _QXZ("Status"); $label_user = _QXZ("User"); $label_date_of_birth = _QXZ("Date of Birth"); $label_country_code = _QXZ("Country"); $label_last_local_call_time = _QXZ("Last Call"); $label_called_count = _QXZ("Called Count"); $label_rank = _QXZ("Rank"); $label_owner = _QXZ("Owner"); $label_entry_list_id = _QXZ("Entry List ID"); $stmt="SELECT label_title,label_first_name,label_middle_initial,label_last_name,label_address1,label_address2,label_address3,label_city,label_state,label_province,label_postal_code,label_vendor_lead_code,label_gender,label_phone_number,label_phone_code,label_alt_phone,label_security_phrase,label_email,label_comments,label_lead_id,label_list_id,label_entry_date,label_gmt_offset_now,label_source_id,label_called_since_last_reset,label_status,label_user,label_date_of_birth,label_country_code,label_last_local_call_time,label_called_count,label_rank,label_owner,label_entry_list_id,label_hide_field_logs from system_settings;"; $rslt=mysql_to_mysqli($stmt, $link); if ($mel > 0) {mysql_error_logging($NOW_TIME,$link,$mel,$stmt,'00417',$user,$server_ip,$session_name,$one_mysql_log);} $row=mysqli_fetch_row($rslt); if (strlen($row[0])>0) {$label_title = $row[0];} if (strlen($row[1])>0) {$label_first_name = $row[1];} if (strlen($row[2])>0) {$label_middle_initial = $row[2];} if (strlen($row[3])>0) {$label_last_name = $row[3];} if (strlen($row[4])>0) {$label_address1 = $row[4];} if (strlen($row[5])>0) {$label_address2 = $row[5];} if (strlen($row[6])>0) {$label_address3 = $row[6];} if (strlen($row[7])>0) {$label_city = $row[7];} if (strlen($row[8])>0) {$label_state = $row[8];} if (strlen($row[9])>0) {$label_province = $row[9];} if (strlen($row[10])>0) {$label_postal_code = $row[10];} if (strlen($row[11])>0) {$label_vendor_lead_code = $row[11];} if (strlen($row[12])>0) {$label_gender = $row[12];} if (strlen($row[13])>0) {$label_phone_number = $row[13];} if (strlen($row[14])>0) {$label_phone_code = $row[14];} if (strlen($row[15])>0) {$label_alt_phone = $row[15];} if (strlen($row[16])>0) {$label_security_phrase = $row[16];} if (strlen($row[17])>0) {$label_email = $row[17];} if (strlen($row[18])>0) {$label_comments = $row[18];} if (strlen($row[19])>0) {$label_lead_id = $row[19];} if (strlen($row[20])>0) {$label_list_id = $row[20];} if (strlen($row[21])>0) {$label_entry_date = $row[21];} if (strlen($row[22])>0) {$label_gmt_offset_now = $row[22];} if (strlen($row[23])>0) {$label_source_id = $row[23];} if (strlen($row[24])>0) {$label_called_since_last_reset = $row[24];} if (strlen($row[25])>0) {$label_status = $row[25];} if (strlen($row[26])>0) {$label_user = $row[26];} if (strlen($row[27])>0) {$label_date_of_birth = $row[27];} if (strlen($row[28])>0) {$label_country_code = $row[28];} if (strlen($row[29])>0) {$label_last_local_call_time = $row[29];} if (strlen($row[30])>0) {$label_called_count = $row[30];} if (strlen($row[31])>0) {$label_rank = $row[31];} if (strlen($row[32])>0) {$label_owner = $row[32];} if (strlen($row[33])>0) {$label_entry_list_id = $row[33];} $label_hide_field_logs = $row[34]; if ( ($screen_labels != '--SYSTEM-SETTINGS--') and (strlen($screen_labels)>1) ) { $stmt="SELECT label_title,label_first_name,label_middle_initial,label_last_name,label_address1,label_address2,label_address3,label_city,label_state,label_province,label_postal_code,label_vendor_lead_code,label_gender,label_phone_number,label_phone_code,label_alt_phone,label_security_phrase,label_email,label_comments,label_lead_id,label_list_id,label_entry_date,label_gmt_offset_now,label_source_id,label_called_since_last_reset,label_status,label_user,label_date_of_birth,label_country_code,label_last_local_call_time,label_called_count,label_rank,label_owner,label_entry_list_id,label_hide_field_logs from vicidial_screen_labels where label_id='$screen_labels' and active='Y' limit 1;"; $rslt=mysql_to_mysqli($stmt, $link); if ($mel > 0) {mysql_error_logging($NOW_TIME,$link,$mel,$stmt,'00418',$user,$server_ip,$session_name,$one_mysql_log);} $screenlabels_count = mysqli_num_rows($rslt); if ($screenlabels_count > 0) { $row=mysqli_fetch_row($rslt); if (strlen($row[0])>0) {$label_title = $row[0];} if (strlen($row[1])>0) {$label_first_name = $row[1];} if (strlen($row[2])>0) {$label_middle_initial = $row[2];} if (strlen($row[3])>0) {$label_last_name = $row[3];} if (strlen($row[4])>0) {$label_address1 = $row[4];} if (strlen($row[5])>0) {$label_address2 = $row[5];} if (strlen($row[6])>0) {$label_address3 = $row[6];} if (strlen($row[7])>0) {$label_city = $row[7];} if (strlen($row[8])>0) {$label_state = $row[8];} if (strlen($row[9])>0) {$label_province = $row[9];} if (strlen($row[10])>0) {$label_postal_code = $row[10];} if (strlen($row[11])>0) {$label_vendor_lead_code = $row[11];} if (strlen($row[12])>0) {$label_gender = $row[12];} if (strlen($row[13])>0) {$label_phone_number = $row[13];} if (strlen($row[14])>0) {$label_phone_code = $row[14];} if (strlen($row[15])>0) {$label_alt_phone = $row[15];} if (strlen($row[16])>0) {$label_security_phrase = $row[16];} if (strlen($row[17])>0) {$label_email = $row[17];} if (strlen($row[18])>0) {$label_comments = $row[18];} if (strlen($row[19])>0) {$label_lead_id = $row[19];} if (strlen($row[20])>0) {$label_list_id = $row[20];} if (strlen($row[21])>0) {$label_entry_date = $row[21];} if (strlen($row[22])>0) {$label_gmt_offset_now = $row[22];} if (strlen($row[23])>0) {$label_source_id = $row[23];} if (strlen($row[24])>0) {$label_called_since_last_reset = $row[24];} if (strlen($row[25])>0) {$label_status = $row[25];} if (strlen($row[26])>0) {$label_user = $row[26];} if (strlen($row[27])>0) {$label_date_of_birth = $row[27];} if (strlen($row[28])>0) {$label_country_code = $row[28];} if (strlen($row[29])>0) {$label_last_local_call_time = $row[29];} if (strlen($row[30])>0) {$label_called_count = $row[30];} if (strlen($row[31])>0) {$label_rank = $row[31];} if (strlen($row[32])>0) {$label_owner = $row[32];} if (strlen($row[33])>0) {$label_entry_list_id = $row[33];} $label_hide_field_logs = $row[34]; ### END find any custom field labels ### $hide_gender=0; if ($label_gender == '---HIDE---') {$hide_gender=1;} } } ### END find any custom field labels ### $INFOout .= "
| $post_phone_time_diff_alert_message | |||||||||||||||||||||||||||||||||||||||||||||||||||||||
| $label_status | $row[0] | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| $label_vendor_lead_code: | $row[1] | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| $label_list_id | $row[2] | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| $label_gmt_offset_now | $row[3] | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| $label_called_since_last_reset | $row[4] | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| $label_phone_code: | $row[5] | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| $label_phone_number: | $phone_number_display - ";
if ($hide_dial_links < 1)
{
if ($manual_dial_filter > 0)
{
if ($CB_force_dial_flag > 0)
{
$INFOout .= " "._QXZ("DIAL")." ";
}
else
{
$INFOout .= " "._QXZ("DIAL")." ";
}
}
else
{$INFOout .= _QXZ(" DIAL ");}
}
}
if ( ($label_phone_number=='---HIDE---') and ($hide_dial_links < 1) )
{
if ($manual_dial_filter > 0)
{
if ($CB_force_dial_flag > 0)
{
$INFOout .= "| "._QXZ("Dial Link:")." | "._QXZ("DIAL")." ";
}
else
{
$INFOout .= " | "._QXZ("Dial Link:")." | "._QXZ("DIAL")." ";
}
}
else
{$INFOout .= " | "._QXZ("Dial Link:")." | "._QXZ(" DIAL ");}
}
$INFOout .= " | "._QXZ("SELECT THIS LEAD")." | $label_title: | $row[7] | $label_first_name: | $row[8] | $label_middle_initial: | $row[9] | $label_last_name: | $row[10] | $label_address1: | $row[11] | $label_address2: | $row[12] | $label_address3: | $row[13] | $label_city: | $row[14] | $label_state: | $row[15] | $label_province: | $row[16] | $label_postal_code: | $row[17] | $label_country_code: | $row[18] | $label_gender: | $row[19] | $label_alt_phone: | $row[20] - ";
if ($hide_dial_links < 1)
{
if ($manual_dial_filter > 0)
{
if ($CB_force_dial_flag > 0)
{
$INFOout .= " "._QXZ("DIAL")." ";
}
else
{
$INFOout .= " "._QXZ("DIAL")." ";
}
}
else
{$INFOout .= " DIAL ";}
}
}
$INFOout .= " | $label_email: | $row[21] | $label_security_phrase: | $row[22] | $label_comments: | $row[23] | $label_called_count | $row[24] | $label_last_local_call_time | $row[25] | Rank: | $row[26] | Owner: | $row[27] | Entry List ID: | $row[28] | $A_field_name[$o]: | $A_field_value | | |
"; ### END Display lead info and custom fields ### ### BEGIN Gather Call Log and notes ### $NOTESout=''; if ($hide_call_log_info!='Y') { if ($search != 'logfirst') {$NOTESout .= "
\n";} $NOTESout .= "
| # | "; $NOTESout .= ""._QXZ("DATE/TIME")." | "; $NOTESout .= ""._QXZ("AGENT")." | "; $NOTESout .= ""._QXZ("LENGTH")." | "; $NOTESout .= ""._QXZ("STATUS")." | "; $NOTESout .= ""._QXZ("PHONE")." | "; $NOTESout .= ""._QXZ("CAMPAIGN")." | "; $NOTESout .= ""._QXZ("IN/OUT")." | "; $NOTESout .= ""._QXZ("ALT")." | "; $NOTESout .= ""._QXZ("HANGUP")." | "; # $NOTESout .= "|
| FULL NAME | "; $NOTESout .= "||||||||||
| "._QXZ("No calls found")." | ||||||||||
| $u | "; $NOTESout .= "$ALLcall_date[$i] | "; $NOTESout .= "$ALLuser[$i] | \n"; $NOTESout .= "$ALLlength_in_sec[$i] | \n"; $NOTESout .= "$ALLstatus[$i] | \n"; $NOTESout .= "$ALLphone_code[$i] $phone_number_display | \n"; $NOTESout .= "$ALLcampaign_id[$i] | \n"; $NOTESout .= ""._QXZ("$ALLin_out[$i]")." | \n"; $NOTESout .= ""._QXZ("$ALLalt_dial[$i]")." | \n"; $NOTESout .= ""._QXZ("$ALLhangup_reason[$i]")." | \n"; $NOTESout .= "|
| "; $NOTESout .= " | $Allcall_notes[$i] | "; $NOTESout .= "|||||||||
"; } ### END Gather Call Log and notes ### ### BEGIN Email log if ($allow_emails>0) { $NOTESout .= "
\n"; $NOTESout .= "
| # | "; $NOTESout .= ""._QXZ("DATE/TIME")." | "; $NOTESout .= ""._QXZ("AGENT")." | "; $NOTESout .= ""._QXZ("CAMPAIGN")." | "; $NOTESout .= ""._QXZ("EMAIL TO")." | "; $NOTESout .= ""._QXZ("ATTACHMENTS")." | "; $NOTESout .= "
| $u | "; $NOTESout .= "$row[3] | "; $NOTESout .= "$row[4] | \n"; $NOTESout .= "$row[7] | \n"; $NOTESout .= "$row[5] | \n"; $NOTESout .= "$row[8] | \n"; $NOTESout .= "
| \n"; $NOTESout .= " | "._QXZ("MESSAGE:")." $row[6] | \n"; $NOTESout .= "||||
\n"; echo "" . _QXZ("ERROR: this feature is disabled for this campaign") . "\n"; echo "
\n"; echo ""._QXZ("Close Agent Time Report").""; } else { $Tpause_epoch = array(); $Twait_epoch = array(); $talk_epoch = array(); $Tdispo_epoch = array(); $Tdead_epoch = array(); $Tpause_sec = array(); $Twait_sec = array(); $Ttalk_sec = array(); $Tdispo_sec = array(); $Tdead_sec = array(); $Tsub_status = array(); $Tagent_log_id = array(); $Tcampaign_id = array(); $pauseTOTAL = array(); $waitTOTAL = array(); $talkTOTAL = array(); $dispoTOTAL = array(); $billTOTAL = array(); $breakTOTAL = array(); $lunchTOTAL = array(); $coachTOTAL = array(); $loginTOTAL = array(); $nonpauseTOTAL = array(); $campaignTOTAL = array(); if (preg_match("/RANGE/",$stage)) { $archive_cutoff=0; $stmt="SELECT event_time,UNIX_TIMESTAMP(event_time) from vicidial_agent_log order by agent_log_id limit 1;"; $rslt=mysql_to_mysqli($stmt, $link); if ($mel > 0) {mysql_error_logging($NOW_TIME,$link,$mel,$stmt,'00807',$user,$server_ip,$session_name,$one_mysql_log);} $archive_check_to_print = mysqli_num_rows($rslt); if ($format=='debug') {echo "|$archive_check_to_print|$stmt|";} if ($archive_check_to_print > 0) { $row=mysqli_fetch_row($rslt); $archive_cutoff = $row[1]; } $days=-1; if ($start_date == "$NOW_DATE") { $days=0; $temp_date_epoch = $secX; } else { $start_date_epoch = strtotime("$start_date 12:00:00"); $end_date_epoch = strtotime("$end_date 12:00:00"); $datediff = $end_date_epoch - $start_date_epoch; $days = round($datediff / (60 * 60 * 24)); $temp_date_epoch = $start_date_epoch; } if ($days < 0) { echo "
\n"; echo "" . _QXZ("ERROR: you must select a date range to use this feature")."\n"; echo "
\n"; echo ""._QXZ("Close Agent Time Report").""; } else { echo "
\n"; if (preg_match("/ENABLED_BASIC/",$stage)) { echo "
| "._QXZ("DATE")." | "; echo ""._QXZ("TOTAL LOGGED IN TIME")." | "; echo "||||||
| "._QXZ("DATE")." | "; echo ""._QXZ("TOTAL LOGGED IN")." | "; echo ""._QXZ("WAIT")." | "; echo ""._QXZ("TALK")." | "; echo ""._QXZ("DISPO")." | "; echo ""._QXZ("PAUSE")." | "; echo "||
| "._QXZ("DATE")." | "; echo ""._QXZ("CAMPAIGN")." | "; echo " "._QXZ("TOTAL NON-PAUSE TIME")." | ";
echo ""._QXZ("WAIT")." | "; echo ""._QXZ("TALK")." | "; echo ""._QXZ("DISPO")." | "; echo ""._QXZ("PAUSE")." | "; echo " "._QXZ("TOTAL LOGGED IN")." | ";
echo "
| "._QXZ("DATE")." | "; echo ""._QXZ("BILLABLE")." | "; echo ""._QXZ("BREAK")." | "; echo ""._QXZ("LUNCH")." | "; echo ""._QXZ("COACH")." | "; echo "|||
| $temp_date $archive_flag | "; echo "" . gmdate("H:i:s", $loginTOTAL[$ct]) . " | ||||||
| $temp_date $archive_flag | "; echo "" . gmdate("H:i:s", $loginTOTAL[$ct]) . " | "; echo "" . gmdate("H:i:s", $waitTOTAL[$ct]) . " | "; echo "" . gmdate("H:i:s", $talkTOTAL[$ct]) . " | "; echo "" . gmdate("H:i:s", $dispoTOTAL[$ct]) . " | "; echo "" . gmdate("H:i:s", $pauseTOTAL[$ct]) . " | ||
| $temp_date $archive_flag | "; echo "$campaignTOTAL[$ct] | "; echo "" . gmdate("H:i:s", $nonpauseTOTAL[$ct]) . " | "; echo "" . gmdate("H:i:s", $waitTOTAL[$ct]) . " | "; echo "" . gmdate("H:i:s", $talkTOTAL[$ct]) . " | "; echo "" . gmdate("H:i:s", $dispoTOTAL[$ct]) . " | "; echo "" . gmdate("H:i:s", $pauseTOTAL[$ct]) . " | "; echo "" . gmdate("H:i:s", $loginTOTAL[$ct]) . " | "; echo "
| $temp_date $archive_flag | "; echo "" . gmdate("H:i:s", $billTOTAL[$ct]) . " | "; echo "" . gmdate("H:i:s", $breakTOTAL[$ct]) . " | "; echo "" . gmdate("H:i:s", $lunchTOTAL[$ct]) . " | "; echo "" . gmdate("H:i:s", $coachTOTAL[$ct]) . " | |||
![](\"images/blank.gif\"){kind=spacer} | |||||||
| "._QXZ("TOTALS").": | "; echo ""; echo " | " . gmdate("H:i:s", $GRANDnonpauseTOTAL) . " | "; echo "" . gmdate("H:i:s", $GRANDwaitTOTAL) . " | "; echo "" . gmdate("H:i:s", $GRANDtalkTOTAL) . " | "; echo "" . gmdate("H:i:s", $GRANDdispoTOTAL) . " | "; echo "" . gmdate("H:i:s", $GRANDpauseTOTAL) . " | "; echo "" . gmdate("H:i:s", $GRANDloginTOTAL) . " | "; echo "
\n";} $g++; } $billTOTAL = ($waitTOTAL + $talkTOTAL + $dispoTOTAL); $loginTOTAL = ($pauseTOTAL + $waitTOTAL + $talkTOTAL + $dispoTOTAL); echo "
\n"; echo "
\n"; if ($stage == 'ENABLED_BASIC') { echo "
| "._QXZ("TOTAL LOGGED IN TIME")." | "; echo "
| " . gmdate("H:i:s", $loginTOTAL) . " | "; echo "
| "._QXZ("TOTAL LOGGED IN")." | "; echo ""._QXZ("WAIT")." | "; echo ""._QXZ("TALK")." | "; echo ""._QXZ("DISPO")." | "; echo ""._QXZ("PAUSE")." | "; echo "
| " . gmdate("H:i:s", $loginTOTAL) . " | "; echo "" . gmdate("H:i:s", $waitTOTAL) . " | "; echo "" . gmdate("H:i:s", $talkTOTAL) . " | "; echo "" . gmdate("H:i:s", $dispoTOTAL) . " | "; echo "" . gmdate("H:i:s", $pauseTOTAL) . " | "; echo "
| "._QXZ("BILLABLE")." | "; echo ""._QXZ("BREAK")." | "; echo ""._QXZ("LUNCH")." | "; echo ""._QXZ("COACH")." | "; echo "
| " . gmdate("H:i:s", $billTOTAL) . " | "; echo "" . gmdate("H:i:s", $breakTOTAL) . " | "; echo "" . gmdate("H:i:s", $lunchTOTAL) . " | "; echo "" . gmdate("H:i:s", $coachTOTAL) . " | "; echo "
"; echo ""._QXZ("Close Agent Time Report").""; echo "