echo "<TR><TD COLSPAN=7 ALIGN=CENTER><input type=submit value=\"SUBMIT AKTIVEN LISTE ÄNDERUNGEN\"></TD></TR>\n";
echo "</TABLE></center><BR></FORM>\n";
echo "<center><b>\n";
$filterSQL = $filtersql_list[$lead_filter_id];
$filterSQL = preg_replace("/\\\\/", "", $filterSQL);
$filterSQL = eregi_replace("^and|and\$|^or|or\$", "", $filterSQL);
if (strlen($filterSQL) > 4) {
$fSQL = "and {$filterSQL}";
} else {
$fSQL = '';
}
$camp_lists = eregi_replace(".\$", "", $camp_lists);
echo "Diese Kampagne hat{$active_lists} aktive Listen und{$inactive_lists} unaktivierte Listen<br><br>\n";
if ($display_dialable_count == 'Y') {
### call function to calculate and print dialable leads
dialable_leads($DB, $link, $local_call_time, $dial_statuses, $camp_lists, $drop_lockout_time, $fSQL);
echo " - <font size=1><a href=\"{$PHP_SELF}?ADD=34&campaign_id={$campaign_id}&stage=hide_dialable\">Verberge</a></font><BR><BR>";
} else {
echo "<a href=\"{$PHP_SELF}?ADD=73&campaign_id={$campaign_id}\" target=\"_blank\">Popup Dialable Leads Count</a>";
echo " - <font size=1><a href=\"{$PHP_SELF}?ADD=31&campaign_id={$campaign_id}&stage=show_dialable\">Zeige</a></font><BR><BR>";
}
$stmt = "SELECT count(*) FROM vicidial_hopper where campaign_id='{$campaign_id}' and status IN('READY')";
if ($DB) {
echo "{$stmt}\n";
}
$rslt = mysql_query($stmt, $link);
$rowx = mysql_fetch_row($rslt);
$hopper_leads = "{$rowx['0']}";
echo "Diese Kampagne hat{$hopper_leads} Leitungen im Vorwahlknopfzufuhrbehälter<br><br>\n";
echo "<a href=\"./AST_VICIDIAL_hopperlist.php?group={$campaign_id}\">Klicken Sie hier, um zu sehen, welche Leitungen im Zufuhrbehälter imAugenblick sind</a><br><br>\n";
echo "<a href=\"./AST_VDADstats.php?group={$campaign_id}\">Klicken Sie hier, um ein VDAD Bericht für diese Kampagne</a><BR><BR>\n";
}
$list_call_inv = 0;
GetListCount($list_id, $inventory_ptnstr);
$average_calls = sprintf("%.1f", MathZDC($total_calls, $list_start_inv));
### For TOTAL counts, needs to be here instead of with other "total" variables further down in this particular report
$total_total_calls += $total_calls;
$Xdialable_count_nofilter = dialable_leads($DB, $link, $local_call_time, "{$dial_statuses}", $selected_list, $drop_lockout_time, $call_count_limit, $single_status, "");
if (strlen($inactive_dial_statuses) > 1) {
$Xdialable_inactive_count = dialable_leads($DB, $link, $local_call_time, "{$inactive_dial_statuses}", $selected_list, $drop_lockout_time, $call_count_limit, $single_status, "{$filter_SQL}");
} else {
$Xdialable_inactive_count = 0;
}
$oneoff_SQL = $filter_SQL . " and (called_count < {$call_count_limit}-1) ";
$oneoff_count = dialable_leads($DB, $link, $local_call_time, "{$dial_statuses}", $selected_list, $drop_lockout_time, $call_count_limit, $single_status, "{$oneoff_SQL}");
$full_dialable_SQL = "";
$Xdialable_count = dialable_leads($DB, $link, $local_call_time, "{$dial_statuses}", $selected_list, $drop_lockout_time, $call_count_limit, $single_status, "{$filter_SQL}");
if ($DB > 0) {
echo _QXZ("FULL DIALABLE SQL") . ": |{$full_dialable_SQL}|";
}
}
$penetration = sprintf("%.2f", MathZDC(100 * ($list_start_inv - $Xdialable_count), $list_start_inv));
$rpt_body .= "| " . sprintf("%9s", $list_id) . " | " . sprintf("%-30s", $list_info) . " | " . sprintf("%8s", $campaign_id) . " | " . $last_calldate . " | " . sprintf("%9s", $list_start_inv) . " | " . sprintf("%8s", $Xdialable_count) . " | " . sprintf("%8s", $Xdialable_count_nofilter) . " | " . sprintf("%8s", $oneoff_count) . " | " . sprintf("%8s", $Xdialable_inactive_count) . " | " . sprintf("%8s", $average_calls) . " | " . sprintf("%6s", $penetration) . "% |";
$CSV_body .= "\"{$list_id}\",\"{$list_info}\",\"{$last_calldate}\",\"{$campaign_id}\",\"{$list_start_inv}\",\"{$Xdialable_count}\",\"{$Xdialable_count_nofilter}\",\"{$oneoff_count}\",\"{$Xdialable_inactive_count}\",\"{$average_calls}\",\"{$penetration} %\"";
$total_list_start_inv += $list_start_inv;
$total_dialable_count += $Xdialable_count;
$total_dialable_count_nofilter += $Xdialable_count_nofilter;
$total_dialable_count_oneoff += $oneoff_count;
$total_dialable_count_inactive += $Xdialable_inactive_count;
$shift_ary2 = $shift_ary;
while (list($key, $val) = each($shift_ary2)) {
$total_shift_count = 0;
