THIS IS JUST FOR THE CUSTOMER INTERFACE, is a little add the customers can select if want to see just the answered or all the calls. Hope you enjoy it
Code:
<?
include ("lib/defines.php");
include ("lib/module.access.php");
if (! has_rights (ACX_ACCESS)){
Header ("HTTP/1.0 401 Unauthorized");
Header ("Location: PP_error.php?c=accessdenied");
die();
}
if (!$A2B->config["webcustomerui"]['cdr']) exit();
$QUERY = "SELECT username, credit, lastname, firstname, address, city, state, country, zipcode, phone, email, fax, lastuse, activated FROM cc_card WHERE username = '".$_SESSION["pr_login"]."' AND uipass = '".$_SESSION["pr_password"]."'";
//echo $QUERY."<br>";
$DBHandle_max = DbConnect();
$resmax = $DBHandle_max -> query($QUERY);
$numrow = $DBHandle_max -> num_rows();
if ($numrow == 0) exit();
$DBHandle_max -> next_record();
$customer_info =$DBHandle_max -> Record;
if( $customer_info [13] != "t" && $customer_info [13] != "1" ) {
exit();
}
//echo "<br>3. $pr_login-$pr_password-$cus_rights : $numrow";
$customer = $_SESSION["pr_login"];
getpost_ifset(array('posted', 'Period', 'frommonth', 'fromstatsmonth', 'tomonth', 'tostatsmonth', 'fromday', 'fromstatsday_sday', 'fromstatsmonth_sday', 'today', 'tostatsday_sday', 'tostatsmonth_sday', 'dsttype', 'sourcetype', 'clidtype', 'channel', 'resulttype', 'stitle', 'atmenu', 'current_page', 'order', 'sens', 'dst', 'src', 'clid', 'choose_currency'));
if (!isset ($current_page) || ($current_page == "")){
$current_page=0;
}
// this variable specifie the debug type (0 => nothing, 1 => sql result, 2 => boucle checking, 3 other value checking)
$FG_DEBUG = 0;
// The variable FG_TABLE_NAME define the table name to use
$FG_TABLE_NAME="cc_call t1";
// THIS VARIABLE DEFINE THE COLOR OF THE HEAD TABLE
$FG_TABLE_HEAD_COLOR = "#D1D9E7";
$FG_TABLE_EXTERN_COLOR = "#7F99CC"; //#CC0033 (Rouge)
$FG_TABLE_INTERN_COLOR = "#EDF3FF"; //#FFEAFF (Rose)
// THIS VARIABLE DEFINE THE COLOR OF THE HEAD TABLE
$FG_TABLE_ALTERNATE_ROW_COLOR[] = "#FFFFFF";
$FG_TABLE_ALTERNATE_ROW_COLOR[] = "#F2F8FF";
$yesno = array(); $yesno["1"] = array( "Yes", "1"); $yesno["0"] = array( "No", "0");
// 0 = NORMAL CALL ; 1 = VOIP CALL (SIP/IAX) ; 2= DIDCALL + TRUNK ; 3 = VOIP CALL DID ; 4 = CALLBACK call
$list_calltype = array(); $list_calltype["0"] = array( "STANDARD", "0"); $list_calltype["1"] = array( "SIP/IAX", "1");
$list_calltype["2"] = array( "DIDCALL", "2"); $list_calltype["3"] = array( "DID_VOIP", "3"); $list_calltype["4"] = array( "CALLBACK", "4");
$list_calltype["5"] = array( "PREDICT", "5");
//$link = DbConnect();
$DBHandle = DbConnect();
// The variable Var_col would define the col that we want show in your table
// First Name of the column in the html page, second name of the field
$FG_TABLE_COL = array();
/*******
Calldate Clid Src Dst Dcontext Channel Dstchannel Lastapp Lastdata Duration Billsec Disposition Amaflags Accountcode Uniqueid Serverid
*******/
$FG_TABLE_COL[]=array ("Calldate", "starttime", "15%", "center", "SORT", "19", "", "", "", "", "", "display_dateformat");
//$FG_TABLE_COL[]=array ("Callend", "stoptime", "15%", "center", "SORT", "19");
//$FG_TABLE_COL[]=array ("Source", "source", "20%", "center", "SORT", "30");
$FG_TABLE_COL[]=array ("CalledNumber", "calledstation", "15%", "center", "SORT", "30", "", "", "", "", "", "remove_prefix");
$FG_TABLE_COL[]=array ("Destination", "destination", "15%", "center", "SORT", "30", "", "", "", "", "", "remove_prefix");
//$FG_TABLE_COL[]=array ("Country", "calledcountry", "10%", "center", "SORT", "30", "lie", "country", "countryname", "countrycode='%id'", "%1");
//$FG_TABLE_COL[]=array ("Site", "site_id", "7%", "center", "sort", "15", "lie", "site", "name", "id='%id'", "%1");
$FG_TABLE_COL[]=array ("Duration", "sessiontime", "7%", "center", "SORT", "30", "", "", "", "", "", "display_minute");
$FG_TABLE_COL[]=array ("CardUsed", "username", "11%", "center", "SORT", "30");
$FG_TABLE_COL[]=array ("terminatecause", "terminatecause", "10%", "center", "SORT", "30");
$FG_TABLE_COL[]=array ("Calltype", "sipiax", "6%", "center", "SORT", "", "list", $list_calltype);
//$FG_TABLE_COL[]=array ("DestID", "destID", "12%", "center", "SORT", "30");
//if ($_SESSION["is_admin"]==1) $FG_TABLE_COL[]=array ("Con_charg", "connectcharge", "12%", "center", "SORT", "30");
//if ($_SESSION["is_admin"]==1) $FG_TABLE_COL[]=array ("Dis_charg", "disconnectcharge", "12%", "center", "SORT", "30");
//if ($_SESSION["is_admin"]==1) $FG_TABLE_COL[]=array ("Sec/mn", "secpermin", "12%", "center", "SORT", "30");
//if ($_SESSION["is_admin"]==1) $FG_TABLE_COL[]=array ("Buycosts", "buycosts", "12%", "center", "SORT", "30");
$FG_TABLE_COL[]=array ("InitialRate", "calledrate", "10%", "center", "SORT", "30", "", "", "", "", "", "display_2dec");
$FG_TABLE_COL[]=array ("Cost", "sessionbill", "10%", "center", "SORT", "30", "", "", "", "", "", "display_2bill");
// ??? cardID
$FG_TABLE_DEFAULT_ORDER = "t1.starttime";
$FG_TABLE_DEFAULT_SENS = "DESC";
// This Variable store the argument for the SQL query
$FG_COL_QUERY='t1.starttime, t1.calledstation, t1.destination, t1.sessiontime, t1.username, t1.terminatecause, t1.sipiax, t1.calledrate, t1.sessionbill';
// t1.stoptime,
$FG_COL_QUERY_GRAPH='t1.callstart, t1.duration';
// The variable LIMITE_DISPLAY define the limit of record to display by page
$FG_LIMITE_DISPLAY=25;
// Number of column in the html table
$FG_NB_TABLE_COL=count($FG_TABLE_COL);
// The variable $FG_EDITION define if you want process to the edition of the database record
$FG_EDITION=true;
//This variable will store the total number of column
$FG_TOTAL_TABLE_COL = $FG_NB_TABLE_COL;
if ($FG_DELETION || $FG_EDITION) $FG_TOTAL_TABLE_COL++;
//This variable define the Title of the HTML table
$FG_HTML_TABLE_TITLE=" - Call Logs - ";
//This variable define the width of the HTML table
$FG_HTML_TABLE_WIDTH="82%";
if ($FG_DEBUG == 3) echo "<br>Table : $FG_TABLE_NAME - Col_query : $FG_COL_QUERY";
$instance_table = new Table($FG_TABLE_NAME, $FG_COL_QUERY);
$instance_table_graph = new Table($FG_TABLE_NAME, $FG_COL_QUERY_GRAPH);
if ( is_null ($order) || is_null($sens) ){
$order = $FG_TABLE_DEFAULT_ORDER;
$sens = $FG_TABLE_DEFAULT_SENS;
}
if ($posted==1){
function do_field($sql,$fld,$dbfld){
$fldtype = $fld.'type';
global $$fld;
global $$fldtype;
if ($$fld){
if (strpos($sql,'WHERE') > 0){
$sql = "$sql AND ";
}else{
$sql = "$sql WHERE ";
}
$sql = "$sql t1.$dbfld";
if (isset ($$fldtype)){
switch ($$fldtype) {
case 1: $sql = "$sql='".$$fld."'"; break;
case 2: $sql = "$sql LIKE '".$$fld."%'"; break;
case 3: $sql = "$sql LIKE '%".$$fld."%'"; break;
case 4: $sql = "$sql LIKE '%".$$fld."'";
}
}else{ $sql = "$sql LIKE '%".$$fld."%'"; }
}
return $sql;
}
$SQLcmd = '';
$SQLcmd = do_field($SQLcmd, 'src', 'source');
$SQLcmd = do_field($SQLcmd, 'dst', 'calledstation');
}
$date_clause='';
// Period (Month-Day)
if (DB_TYPE == "postgres"){
$UNIX_TIMESTAMP = "";
}else{
$UNIX_TIMESTAMP = "UNIX_TIMESTAMP";
}
if ($Period=="Month"){
//list($ccyear, $ccmonth) = split ('-', $tostatsmonth);
//$ccmonth++;
//$tostatsmonth_plus1 = "$ccyear-$ccmonth";
if ($frommonth && isset($fromstatsmonth)) $date_clause.=" AND $UNIX_TIMESTAMP(t1.starttime) >= $UNIX_TIMESTAMP('$fromstatsmonth-01')";
if ($tomonth && isset($tostatsmonth)) $date_clause.=" AND $UNIX_TIMESTAMP(t1.starttime) <= $UNIX_TIMESTAMP('".$tostatsmonth."-31 23:59:59')";
//if ($tomonth && isset($tostatsmonth)) $date_clause.=" AND $UNIX_TIMESTAMP(t1.starttime) < to_date($UNIX_TIMESTAMP('".$tostatsmonth_plus1."-01'), 'YYYY.MM.DD')";
}else{
if ($fromday && isset($fromstatsday_sday) && isset($fromstatsmonth_sday)) $date_clause.=" AND $UNIX_TIMESTAMP(t1.starttime) >= $UNIX_TIMESTAMP('$fromstatsmonth_sday-$fromstatsday_sday')";
if ($today && isset($tostatsday_sday) && isset($tostatsmonth_sday)) $date_clause.=" AND $UNIX_TIMESTAMP(t1.starttime) <= $UNIX_TIMESTAMP('$tostatsmonth_sday-".sprintf("%02d",intval($tostatsday_sday)+1)."')";
}
//echo "<br>$date_clause<br>";
/*
Month
fromday today
frommonth tomonth (true)
fromstatsmonth tostatsmonth
fromstatsday_sday
fromstatsmonth_sday
tostatsday_sday
tostatsmonth_sday
*/
if (strpos($SQLcmd, 'WHERE') > 0) {
$FG_TABLE_CLAUSE = substr($SQLcmd,6).$date_clause;
}elseif (strpos($date_clause, 'AND') > 0){
$FG_TABLE_CLAUSE = substr($date_clause,5);
}
if (!isset ($FG_TABLE_CLAUSE) || strlen($FG_TABLE_CLAUSE)==0){
$cc_yearmonth = sprintf("%04d-%02d-%02d",date("Y"),date("n"),date("d"));
$FG_TABLE_CLAUSE=" $UNIX_TIMESTAMP(t1.starttime) >= $UNIX_TIMESTAMP('$cc_yearmonth')";
}
//--$list_total = $instance_table_graph -> Get_list ($FG_TABLE_CLAUSE, null, null, null, null, null, null);
if (isset($customer) && ($customer>0)){
if (strlen($FG_TABLE_CLAUSE)>0) $FG_TABLE_CLAUSE.=" AND ";
$FG_TABLE_CLAUSE.="t1.username='$customer'";
}else{
if (isset($entercustomer) && ($entercustomer>0)){
if (strlen($FG_TABLE_CLAUSE)>0) $FG_TABLE_CLAUSE.=" AND ";
$FG_TABLE_CLAUSE.="t1.username='$entercustomer'";
}
}
//SOLO RESULTADOS CON TERMINALCAUSE = ANSWER
if (!isset($terminatecause)){
$terminatecause="ANSWER";
}
if ($terminatecause=="ANSWER") {
if (strlen($FG_TABLE_CLAUSE)>0) $FG_TABLE_CLAUSE.=" AND ";
$FG_TABLE_CLAUSE.="t1.terminatecause='$terminatecause'";
}
//> function Get_list ($clause=null, $order=null, $sens=null, $field_order_letter=null, $letters = null, $limite=null, $current_record = NULL)
if (!$nodisplay){
$list = $instance_table -> Get_list ($DBHandle, $FG_TABLE_CLAUSE, $order, $sens, null, null, $FG_LIMITE_DISPLAY, $current_page*$FG_LIMITE_DISPLAY);
}
//echo "<br>--<br>".$FG_TABLE_CLAUSE."<br><br>";
$_SESSION["pr_sql_export"]="SELECT $FG_COL_QUERY FROM $FG_TABLE_NAME WHERE $FG_TABLE_CLAUSE";
/************************/
//$QUERY = "SELECT substring(calldate,1,10) AS day, sum(duration) AS calltime, count(*) as nbcall FROM cdr WHERE ".$FG_TABLE_CLAUSE." GROUP BY substring(calldate,1,10)"; //extract(DAY from calldate)
$QUERY = "SELECT substring(t1.starttime,1,10) AS day, sum(t1.sessiontime) AS calltime, sum(t1.sessionbill) AS cost, count(*) as nbcall FROM $FG_TABLE_NAME WHERE ".$FG_TABLE_CLAUSE." GROUP BY substring(t1.starttime,1,10) ORDER BY day"; //extract(DAY from calldate)
//echo "$QUERY";
if (!$nodisplay){
$res = $DBHandle -> query($QUERY);
$num = $DBHandle -> num_rows();
for($i=0;$i<$num;$i++)
{
$DBHandle -> next_record();
$list_total_day [] =$DBHandle -> Record;
}
if ($FG_DEBUG == 3) echo "<br>Clause : $FG_TABLE_CLAUSE";
$nb_record = $instance_table -> Table_count ($DBHandle, $FG_TABLE_CLAUSE);
//$nb_record = count($list_total);
if ($FG_DEBUG >= 1) var_dump ($list);
}//end IF nodisplay
if ($nb_record<=$FG_LIMITE_DISPLAY){
$nb_record_max=1;
}else{
if ($nb_record % $FG_LIMITE_DISPLAY == 0){
$nb_record_max=(intval($nb_record/$FG_LIMITE_DISPLAY));
}else{
$nb_record_max=(intval($nb_record/$FG_LIMITE_DISPLAY)+1);
}
}
if ($FG_DEBUG == 3) echo "<br>Nb_record : $nb_record";
if ($FG_DEBUG == 3) echo "<br>Nb_record_max : $nb_record_max";
/******************* TOTAL COSTS *****************************************
$instance_table_cost = new Table($FG_TABLE_NAME, "sum(t1.costs), sum(t1.buycosts)");
if (!$nodisplay){
$total_cost = $instance_table_cost -> Get_list ($DBHandle, $FG_TABLE_CLAUSE, null, null, null, null, null, null);
}
*/
/*************************************************************/
?>
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_openBrWindow(theURL,winName,features) { //v2.0
window.open(theURL,winName,features);
}
//-->
</script>
<?php
include("PP_header.php");
?>
<br/><br/>
<!-- ** ** ** ** ** Part for the research ** ** ** ** ** -->
<center>
<FORM METHOD=POST ACTION="<?=$PHP_SELF?>?s=1&t=0&order=<?=$order?>&sens=<?=$sens?>¤t_page=<?=$current_page?>&terminatecause=<?=$terminatecause?>">
<INPUT TYPE="hidden" NAME="posted" value=1>
<INPUT TYPE="hidden" NAME="current_page" value=0>
<table class="bar-status" width="75%" border="0" cellspacing="1" cellpadding="2" align="center">
<tbody>
<tr>
<td class="bar-search" align="left" bgcolor="#555577">
<input type="radio" name="Period" value="Month" <? if (($Period=="Month") || !isset($Period)){ ?>checked="checked" <? } ?>>
<font face="verdana" size="1" color="#ffffff"><b>Selection of the month</b></font>
</td>
<td class="bar-search" align="left" bgcolor="#cddeff">
<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#cddeff"><tr><td>
<input type="checkbox" name="frommonth" value="true" <? if ($frommonth){ ?>checked<?}?>>
From : <select name="fromstatsmonth">
<? $year_actual = date("Y");
for ($i=$year_actual;$i >= $year_actual-1;$i--)
{
$monthname = array( "January", "February","March", "April", "May", "June", "July", "August", "September", "October", "November", "December");
if ($year_actual==$i){
$monthnumber = date("n")-1; // Month number without lead 0.
}else{
$monthnumber=11;
}
for ($j=$monthnumber;$j>=0;$j--){
$month_formated = sprintf("%02d",$j+1);
if ($fromstatsmonth=="$i-$month_formated"){$selected="selected";}else{$selected="";}
echo "<OPTION value=\"$i-$month_formated\" $selected> $monthname[$j]-$i </option>";
}
}
?>
</select>
</td><td>
<input type="checkbox" name="tomonth" value="true" <? if ($tomonth){ ?>checked<?}?>>
To : <select name="tostatsmonth">
<? $year_actual = date("Y");
for ($i=$year_actual;$i >= $year_actual-1;$i--)
{
$monthname = array( "January", "February","March", "April", "May", "June", "July", "August", "September", "October", "November", "December");
if ($year_actual==$i){
$monthnumber = date("n")-1; // Month number without lead 0.
}else{
$monthnumber=11;
}
for ($j=$monthnumber;$j>=0;$j--){
$month_formated = sprintf("%02d",$j+1);
if ($tostatsmonth=="$i-$month_formated"){$selected="selected";}else{$selected="";}
echo "<OPTION value=\"$i-$month_formated\" $selected> $monthname[$j]-$i </option>";
}
}
?>
</select>
</td></tr></table>
</td>
</tr>
<tr>
<td align="left" bgcolor="#000033">
<input type="radio" name="Period" value="Day" <? if ($Period=="Day"){ ?>checked="checked" <? } ?>>
<font face="verdana" size="1" color="#ffffff"><b>Selection of the day</b></font>
</td>
<td align="left" bgcolor="#acbdee">
<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#acbdee"><tr><td>
<input type="checkbox" name="fromday" value="true" <? if ($fromday){ ?>checked<?}?>> From :
<select name="fromstatsday_sday">
<?
for ($i=1;$i<=31;$i++){
if ($fromstatsday_sday==sprintf("%02d",$i)){$selected="selected";}else{$selected="";}
echo '<option value="'.sprintf("%02d",$i)."\"$selected>".sprintf("%02d",$i).'</option>';
}
?>
</select>
<select name="fromstatsmonth_sday">
<? $year_actual = date("Y");
for ($i=$year_actual;$i >= $year_actual-1;$i--)
{
$monthname = array( "January", "February","March", "April", "May", "June", "July", "August", "September", "October", "November", "December");
if ($year_actual==$i){
$monthnumber = date("n")-1; // Month number without lead 0.
}else{
$monthnumber=11;
}
for ($j=$monthnumber;$j>=0;$j--){
$month_formated = sprintf("%02d",$j+1);
if ($fromstatsmonth_sday=="$i-$month_formated"){$selected="selected";}else{$selected="";}
echo "<OPTION value=\"$i-$month_formated\" $selected> $monthname[$j]-$i </option>";
}
}
?>
</select>
</td><td>
<input type="checkbox" name="today" value="true" <? if ($today){ ?>checked<?}?>> To :
<select name="tostatsday_sday">
<?
for ($i=1;$i<=31;$i++){
if ($tostatsday_sday==sprintf("%02d",$i)){$selected="selected";}else{$selected="";}
echo '<option value="'.sprintf("%02d",$i)."\"$selected>".sprintf("%02d",$i).'</option>';
}
?>
</select>
<select name="tostatsmonth_sday">
<? $year_actual = date("Y");
for ($i=$year_actual;$i >= $year_actual-1;$i--)
{
$monthname = array( "January", "February","March", "April", "May", "June", "July", "August", "September", "October", "November", "December");
if ($year_actual==$i){
$monthnumber = date("n")-1; // Month number without lead 0.
}else{
$monthnumber=11;
}
for ($j=$monthnumber;$j>=0;$j--){
$month_formated = sprintf("%02d",$j+1);
if ($tostatsmonth_sday=="$i-$month_formated"){$selected="selected";}else{$selected="";}
echo "<OPTION value=\"$i-$month_formated\" $selected> $monthname[$j]-$i </option>";
}
}
?>
</select>
</td></tr></table>
</td>
</tr>
<tr>
<td class="bar-search" align="left" bgcolor="#555577">
<font face="verdana" size="1" color="#ffffff"><b> DESTINATION</b></font>
</td>
<td class="bar-search" align="left" bgcolor="#cddeff">
<table width="100%" border="0" cellspacing="0" cellpadding="0"><tr><td> <INPUT TYPE="text" NAME="dst" value="<?=$dst?>"></td>
<td class="bar-search" align="center" bgcolor="#cddeff"><input type="radio" NAME="dsttype" value="1" <?if((!isset($dsttype))||($dsttype==1)){?>checked<?}?>>Exact</td>
<td class="bar-search" align="center" bgcolor="#cddeff"><input type="radio" NAME="dsttype" value="2" <?if($dsttype==2){?>checked<?}?>>Begins with</td>
<td class="bar-search" align="center" bgcolor="#cddeff"><input type="radio" NAME="dsttype" value="3" <?if($dsttype==3){?>checked<?}?>>Contains</td>
<td class="bar-search" align="center" bgcolor="#cddeff"><input type="radio" NAME="dsttype" value="4" <?if($dsttype==4){?>checked<?}?>>Ends with</td>
</tr></table></td>
</tr>
<tr>
<td class="bar-search" align="left" bgcolor="#000033"><font face="verdana" size="1" color="#ffffff"><b> Options</b></font></td>
<td class="bar-search" align="center" bgcolor="#acbdee"><div align="left">Show calls:
Answered
<input name="terminatecause" type="radio" value="ANSWER" <?if((!isset($terminatecause))||($terminatecause=="ANSWER")){?>checked<?}?> />
All Calls
<input name="terminatecause" type="radio" value="TODAS" <?if($terminatecause=="TODAS"){?>checked<?}?>/>
</div></td>
</tr>
<tr>
<td class="bar-search" align="left" bgcolor="#000033"> </td>
<td class="bar-search" align="center" bgcolor="#acbdee">
<input type="image" name="image16" align="top" border="0" src="images/button-search.gif" />
Result : Minutes<input type="radio" NAME="resulttype" value="min" <?if((!isset($resulttype))||($resulttype=="min")){?>checked<?}?>> - Seconds <input type="radio" NAME="resulttype" value="sec" <?if($resulttype=="sec"){?>checked<?}?>>
Currency :
<select NAME="choose_currency" size="1" class="form_enter" style="border: 2px outset rgb(204, 51, 0);">
<?php
$currencies_list = get_currencies();
foreach($currencies_list as $key => $cur_value) {
?>
<option value='<?php echo $key ?>' <?php if (($choose_currency==$key) || (!isset($choose_currency) && $key==strtoupper(BASE_CURRENCY))){?>selected<?php } ?>><?php echo $cur_value[1].' ('.$cur_value[2].')' ?>
</option>
<?php } ?>
</select>
</td>
</tr>
</tbody></table>
</FORM>
</center>
<br><br>
<!-- ** ** ** ** ** Part to display the CDR ** ** ** ** ** -->
<center>Number of call : <? if (is_array($list) && count($list)>0){ echo $nb_record; }else{echo "0";}?></center>
<table width="<?=$FG_HTML_TABLE_WIDTH?>" border="0" align="center" cellpadding="0" cellspacing="0">
<TR bgcolor="#ffffff">
<TD bgColor=#7f99cc height=16 style="PADDING-LEFT: 5px; PADDING-RIGHT: 3px">
<TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">
<TBODY>
<TR>
<TD><SPAN style="COLOR: #ffffff; FONT-SIZE: 11px"><B><?=$FG_HTML_TABLE_TITLE?></B></SPAN></TD>
<TD align=right> <IMG alt="Back to Top" border=0 height=12 src="images/btn_top_12x12.gif" width=12>
</TD>
</TR>
</TBODY>
</TABLE></TD>
</TR>
<TR>
<TD> <TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">
<TBODY>
<TR bgColor=#F0F0F0>
<TD width="<?=$FG_ACTION_SIZE_COLUMN?>" align=center class="tableBodyRight" style="PADDING-BOTTOM: 2px; PADDING-LEFT: 2px; PADDING-RIGHT: 2px; PADDING-TOP: 2px"></TD>
<?php
if (is_array($list) && count($list)>0){
for($i=0;$i<$FG_NB_TABLE_COL;$i++){
//$FG_TABLE_COL[$i][1];
//$FG_TABLE_COL[]=array ("Name", "name", "20%");
?>
<TD width="<?=$FG_TABLE_COL[$i][2]?>" align=middle class="tableBody" style="PADDING-BOTTOM: 2px; PADDING-LEFT: 2px; PADDING-RIGHT: 2px; PADDING-TOP: 2px">
<center><strong>
<? if (strtoupper($FG_TABLE_COL[$i][4])=="SORT"){?>
<a href="<? echo $PHP_SELF."?customer=$customer&s=1&t=0&stitle=$stitle&atmenu=$atmenu¤t_page=$current_page&order=".$FG_TABLE_COL[$i][1]."&sens="; if ($sens=="ASC"){echo"DESC";}else{echo"ASC";}
echo "&posted=$posted&Period=$Period&frommonth=$frommonth&fromstatsmonth=$fromstatsmonth&tomonth=$tomonth&tostatsmonth=$tostatsmonth&fromday=$fromday&fromstatsday_sday=$fromstatsday_sday&fromstatsmonth_sday=$fromstatsmonth_sday&today=$today&tostatsday_sday=$tostatsday_sday&tostatsmonth_sday=$tostatsmonth_sday&dsttype=$dsttype&sourcetype=$sourcetype&clidtype=$clidtype&channel=$channel&resulttype=$resulttype&dst=$dst&src=$src&clid=$clid";?>">
<span class="liens"><? } ?>
<?=$FG_TABLE_COL[$i][0]?>
<?if ($order==$FG_TABLE_COL[$i][1] && $sens=="ASC"){?>
<img src="images/icon_up_12x12.GIF" width="12" height="12" border="0">
<?}elseif ($order==$FG_TABLE_COL[$i][1] && $sens=="DESC"){?>
<img src="images/icon_down_12x12.GIF" width="12" height="12" border="0">
<?}?>
<? if (strtoupper($FG_TABLE_COL[$i][4])=="SORT"){?>
</span></a>
<?}?>
</strong></center></TD>
<?php } ?>
<?php if ($FG_DELETION || $FG_EDITION){ ?>
<?php } ?>
</TR>
<TR>
<TD bgColor=#e1e1e1 colSpan=<?=$FG_TOTAL_TABLE_COL?> height=1><IMG
height=1
src="images/clear.gif"
width=1></TD>
</TR>
<?php
$ligne_number=0;
//print_r($list);
foreach ($list as $recordset){
$ligne_number++;
?>
<TR bgcolor="<?=$FG_TABLE_ALTERNATE_ROW_COLOR[$ligne_number%2]?>" onMouseOver="bgColor='#C4FFD7'" onMouseOut="bgColor='<?=$FG_TABLE_ALTERNATE_ROW_COLOR[$ligne_number%2]?>'">
<TD vAlign=top align="<?=$FG_TABLE_COL[$i][3]?>" class=tableBody><? echo $ligne_number+$current_page*$FG_LIMITE_DISPLAY.". "; ?></TD>
<?php for($i=0;$i<$FG_NB_TABLE_COL;$i++){ ?>
<? //$FG_TABLE_COL[$i][1];
//$FG_TABLE_COL[]=array ("Name", "name", "20%");
if ($FG_TABLE_COL[$i][6]=="lie"){
$instance_sub_table = new Table($FG_TABLE_COL[$i][7], $FG_TABLE_COL[$i][8]);
$sub_clause = str_replace("%id", $recordset[$i], $FG_TABLE_COL[$i][9]);
$select_list = $instance_sub_table -> Get_list ($DBHandle, $sub_clause, null, null, null, null, null, null);
$field_list_sun = split(',',$FG_TABLE_COL[$i][8]);
$record_display = $FG_TABLE_COL[$i][10];
//echo $record_display;
for ($l=1;$l<=count($field_list_sun);$l++){
$record_display = str_replace("%$l", $select_list[0][$l-1], $record_display);
}
}elseif ($FG_TABLE_COL[$i][6]=="list"){
$select_list = $FG_TABLE_COL[$i][7];
$record_display = $select_list[$recordset[$i]][0];
}else{
$record_display = $recordset[$i];
}
if ( is_numeric($FG_TABLE_COL[$i][5]) && (strlen($record_display) > $FG_TABLE_COL[$i][5]) ){
$record_display = substr($record_display, 0, $FG_TABLE_COL[$i][5]-3)."";
}
?>
<TD vAlign=top align="<?=$FG_TABLE_COL[$i][3]?>" class=tableBody><?
if (isset ($FG_TABLE_COL[$i][11]) && strlen($FG_TABLE_COL[$i][11])>1){
call_user_func($FG_TABLE_COL[$i][11], $record_display);
}else{
echo stripslashes($record_display);
}
?></TD>
<? } ?>
</TR>
<?php
}//foreach ($list as $recordset)
if ($ligne_number < $FG_LIMITE_DISPLAY) $ligne_number_end=$ligne_number +2;
while ($ligne_number < $ligne_number_end){
$ligne_number++;
?>
<TR bgcolor="<?=$FG_TABLE_ALTERNATE_ROW_COLOR[$ligne_number%2]?>">
<?php for($i=0;$i<$FG_NB_TABLE_COL;$i++){
//$FG_TABLE_COL[$i][1];
//$FG_TABLE_COL[]=array ("Name", "name", "20%");
?>
<TD vAlign=top class=tableBody> </TD>
<? } ?>
<TD align="center" vAlign=top class=tableBodyRight> </TD>
</TR>
<?php
} //END_WHILE
}else{
echo "No data found !!!";
}//end_if
?>
<TR>
<TD class=tableDivider colSpan=<?=$FG_TOTAL_TABLE_COL?>><IMG height=1
src="images/clear.gif"
width=1></TD>
</TR>
<TR>
<TD class=tableDivider colSpan=<?=$FG_TOTAL_TABLE_COL?>><IMG height=1
src="images/clear.gif"
width=1></TD>
</TR>
</TBODY>
</TABLE></td>
</tr>
<TR bgcolor="#ffffff">
<TD bgColor=#ADBEDE height=16 style="PADDING-LEFT: 5px; PADDING-RIGHT: 3px">
<TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">
<TBODY>
<TR>
<TD align="right"><SPAN style="COLOR: #ffffff; FONT-SIZE: 11px"><B>
<?if ($current_page>0){?>
<img src="images/fleche-g.gif" width="5" height="10"> <a href="<?=$PHP_SELF?>?s=1&t=0&order=<?=$order?>&sens=<?=$sens?>¤t_page=<? echo ($current_page-1)?><? if (!is_null($letter) && ($letter!="")){ echo "&letter=$letter";}
echo "&customer=$customer&posted=$posted&Period=$Period&frommonth=$frommonth&fromstatsmonth=$fromstatsmonth&tomonth=$tomonth&tostatsmonth=$tostatsmonth&fromday=$fromday&fromstatsday_sday=$fromstatsday_sday&fromstatsmonth_sday=$fromstatsmonth_sday&today=$today&tostatsday_sday=$tostatsday_sday&tostatsmonth_sday=$tostatsmonth_sday&dsttype=$dsttype&sourcetype=$sourcetype&clidtype=$clidtype&channel=$channel&resulttype=$resulttype&dst=$dst&src=$src&clid=$clid";?>">
Previous </a> -
<?}?>
<?echo ($current_page+1);?> / <? echo $nb_record_max;?>
<?if ($current_page<$nb_record_max-1){?>
- <a href="<?=$PHP_SELF?>?s=1&t=0&order=<?=$order?>&sens=<?=$sens?>¤t_page=<? echo ($current_page+1)?><? if (!is_null($letter) && ($letter!="")){ echo "&letter=$letter";}
echo "&customer=$customer&posted=$posted&Period=$Period&frommonth=$frommonth&fromstatsmonth=$fromstatsmonth&tomonth=$tomonth&tostatsmonth=$tostatsmonth&fromday=$fromday&fromstatsday_sday=$fromstatsday_sday&fromstatsmonth_sday=$fromstatsmonth_sday&today=$today&tostatsday_sday=$tostatsday_sday&tostatsmonth_sday=$tostatsmonth_sday&dsttype=$dsttype&sourcetype=$sourcetype&clidtype=$clidtype&channel=$channel&resulttype=$resulttype&dst=$dst&src=$src&clid=$clid";?>">
Next </a> <img src="images/fleche-d.gif" width="5" height="10">
</B></SPAN>
<?}?>
</TD>
</TBODY>
</TABLE></TD>
</TR>
</table>
<? if (is_array($list) && count($list)>0 && 3==4){ ?>
<!-- ************** TOTAL SECTION ************* -->
<br/>
<div style="padding-right: 15px;">
<table cellpadding="1" bgcolor="#000000" cellspacing="1" width="200" align="right">
<tbody>
<tr class="form_head">
<td width="33%" align="center" class="tableBodyRight" bgcolor="#600101" style="padding: 5px;"><strong>TOTAL COSTS</strong></td>
</tr>
<tr>
<td valign="top" align="center" class="tableBody" bgcolor="white"><b><?=$total_cost[0][0]?></b></td>
</tr>
</table>
</div>
<br/><br/>
<!-- ************** TOTAL SECTION ************* -->
<? } ?>
<!-- ** ** ** ** ** Part to display the GRAPHIC ** ** ** ** ** -->
<br><br>
<?
if (is_array($list_total_day) && count($list_total_day)>0){
/*if (is_array($list) && count($list)>0){
$table_graph=array();
$numm=0;
foreach ($list_total as $recordset){
$numm++;
$mydate= substr($recordset[0],0,10);
//echo "$mydate<br>";
if (is_array($table_graph[$mydate])){
$table_graph[$mydate][0]++;
$table_graph[$mydate][1]=$table_graph[$mydate][1]+$recordset[1];
}else{
$table_graph[$mydate][0]=1;
$table_graph[$mydate][1]=$recordset[1];
}
}*/
$mmax=0;
$totalcall==0;
$totalminutes=0;
foreach ($list_total_day as $data){
if ($mmax < $data[1]) $mmax=$data[1];
$totalcall+=$data[3];
$totalminutes+=$data[1];
$totalcost+=$data[2];
}
//echo "<br/>$totalcall-$totalminutes";
/*foreach ($table_graph as $tkey => $data){
if ($mmax < $data[1]) $mmax=$data[1];
$totalcall+=$data[0];
$totalminutes+=$data[1];
}*/
//print_r($table_graph);
?>
<!-- TITLE GLOBAL -->
<center>
<table border="0" cellspacing="0" cellpadding="0" width="80%"><tbody><tr><td align="left" height="30">
<table cellspacing="0" cellpadding="1" bgcolor="#000000" width="50%"><tbody><tr><td>
<table cellspacing="0" cellpadding="0" width="100%"><tbody>
<tr><td bgcolor="#600101" align="left"><font face="verdana" size="1" color="white"><b>TOTAL</b></font></td></tr>
</tbody></table>
</td></tr></tbody></table>
</td></tr></tbody></table>
<!-- FIN TITLE GLOBAL MINUTES //-->
<table border="0" cellspacing="0" cellpadding="0" width="80%">
<tbody><tr><td bgcolor="#000000">
<table border="0" cellspacing="1" cellpadding="2" width="100%"><tbody>
<tr>
<td align="center" bgcolor="#600101"></td>
<td bgcolor="#b72222" align="center" colspan="5"><font face="verdana" size="1" color="#ffffff"><b>CALLING CARD MINUTES</b></font></td>
</tr>
<tr bgcolor="#600101">
<td align="right" bgcolor="#b72222"><font face="verdana" size="1" color="#ffffff"><b>DATE</b></font></td>
<td align="center"><font face="verdana" size="1" color="#ffffff"><b>DURATION</b></font></td>
<td align="center"><font face="verdana" size="1" color="#ffffff"><b>GRAPHIC</b></font></td>
<td align="center"><font face="verdana" size="1" color="#ffffff"><b>CALLS</b></font></td>
<td align="center"><font face="verdana" size="1" color="#ffffff"><b><acronym title="AVERAGE CONNECTION TIME">ACT</acronym></b></font></td>
<td align="center"><font face="verdana" size="1" color="#ffffff"><b>TOTALCOST</b></font></td>
<!-- LOOP -->
<?
$i=0;
// #ffffff #cccccc
foreach ($list_total_day as $data){
$i=($i+1)%2;
$tmc = $data[1]/$data[3];
if ((!isset($resulttype)) || ($resulttype=="min")){
$tmc = sprintf("%02d",intval($tmc/60)).":".sprintf("%02d",intval($tmc%60));
}else{
$tmc =intval($tmc);
}
if ((!isset($resulttype)) || ($resulttype=="min")){
$minutes = sprintf("%02d",intval($data[1]/60)).":".sprintf("%02d",intval($data[1]%60));
}else{
$minutes = $data[1];
}
if ($mmax>0) $widthbar= intval(($data[1]/$mmax)*200);
//bgcolor="#336699"
?>
</tr><tr>
<td align="right" class="sidenav" nowrap="nowrap"><font face="verdana" size="1" color="#ffffff"><?=$data[0]?></font></td>
<td bgcolor="<?=$FG_TABLE_ALTERNATE_ROW_COLOR[$i]?>" align="right" nowrap="nowrap"><font face="verdana" color="#000000" size="1"><?=$minutes?> </font></td>
<td bgcolor="<?=$FG_TABLE_ALTERNATE_ROW_COLOR[$i]?>" align="left" nowrap="nowrap" width="<?=$widthbar+60?>">
<table cellspacing="0" cellpadding="0"><tbody><tr>
<td bgcolor="#e22424"><img src="images/spacer.gif" width="<?=$widthbar?>" height="6"></td>
</tr></tbody></table></td>
<td bgcolor="<?=$FG_TABLE_ALTERNATE_ROW_COLOR[$i]?>" align="right" nowrap="nowrap"><font face="verdana" color="#000000" size="1"><?=$data[3]?></font></td>
<td bgcolor="<?=$FG_TABLE_ALTERNATE_ROW_COLOR[$i]?>" align="right" nowrap="nowrap"><font face="verdana" color="#000000" size="1"><?=$tmc?> </font></td>
<td bgcolor="<?=$FG_TABLE_ALTERNATE_ROW_COLOR[$i]?>" align="right" nowrap="nowrap"><font face="verdana" color="#000000" size="1"><? display_2bill($data[2]) ?></font></td>
<? }
if ((!isset($resulttype)) || ($resulttype=="min")){
$total_tmc = sprintf("%02d",intval(($totalminutes/$totalcall)/60)).":".sprintf("%02d",intval(($totalminutes/$totalcall)%60));
$totalminutes = sprintf("%02d",intval($totalminutes/60)).":".sprintf("%02d",intval($totalminutes%60));
}else{
$total_tmc = intval($totalminutes/$totalcall);
}
?>
</tr>
<!-- FIN DETAIL -->
<!-- FIN BOUCLE -->
<!-- TOTAL -->
<tr bgcolor="#600101">
<td align="right" nowrap="nowrap"><font face="verdana" size="1" color="#ffffff"><b>TOTAL</b></font></td>
<td align="center" nowrap="nowrap" colspan="2"><font face="verdana" size="1" color="#ffffff"><b><?=$totalminutes?> </b></font></td>
<td align="center" nowrap="nowrap"><font face="verdana" size="1" color="#ffffff"><b><?=$totalcall?></b></font></td>
<td align="center" nowrap="nowrap"><font face="verdana" size="1" color="#ffffff"><b><?=$total_tmc?></b></font></td>
<td align="center" nowrap="nowrap"><font face="verdana" size="1" color="#ffffff"><b><? display_2bill($totalcost) ?></b></font></td>
</tr>
<!-- FIN TOTAL -->
</tbody></table>
<!-- Fin Tableau Global //-->
</td></tr></tbody></table>
<!--
<br/>
<table width="60%"><tr><td>
<a href="export_pdf.php" target="_blank"><img src="images/pdf.gif" border="0"/> Export PDF file</a>
</td>
<td>
<a href="export_csv.php" target="_blank" ><img src="images/excel.gif" border="0"/> Export CSV file</a>
</td></tr></table>-->
<? }else{ ?>
<center><h3>No calls in your selection.</h3></center>
<? } ?>
</center>
<br><br>
<?php
include("PP_footer.php");
?>