Changeset 763
- Timestamp:
- 05/27/08 16:29:41 (2 years ago)
- Files:
-
- trunk/admin/Public/call-log-customers.php (modified) (5 diffs)
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
trunk/admin/Public/call-log-customers.php
r624 r763 233 233 234 234 235 //************************************************************/236 // calculate nbr of success calls,nbr fail calls, max nbr of fail calls successfally /237 //************************************************************/238 239 $QUERY="CREATE TEMPORARY TABLE ASR_CIC_TEMP AS (SELECT substring(t1.starttime,1,10) AS day,case when t1.terminatecause='ANSWER' then 1 else 0 end as success,case when t1.terminatecause ='ANSWER' OR t1.terminatecause='ANSWERED' then 0 else 1 end as fail,0 as maxfail FROM $FG_TABLE_NAME WHERE ".$FG_TABLE_CLAUSE." ORDER BY day)";240 $max_fail=0;241 $max=0;242 $total_fail_succ=0;243 $total_max_succ=0;244 $update=array();245 if (!$nodisplay){246 $num = 0;247 $res = $DBHandle -> Execute($QUERY);248 $QUERY="SELECT * FROM ASR_CIC_TEMP order by day";249 $res = $DBHandle -> Execute($QUERY);250 if ($res)251 $num = $res -> RecordCount();252 $pos=0;253 for($i=0;$i<$num;$i++)254 {255 $asr_cic_list [] =$res -> fetchRow();256 if ($i>0)257 {258 if ($asr_cic_list[$i][0] == $asr_cic_list[$i-1][0] && $i<$num-1 && $asr_cic_list[$i][2]==1) {259 $max++;260 }else {261 if (($i==$num-1) && ($asr_cic_list[$i][2]==1)) $max++;262 if ($max > $max_fail) {263 $max_fail=$max;264 $asr_cic_list1[$pos][3]=$max_fail;265 $max=0;266 }267 if($asr_cic_list[$i][0] != $asr_cic_list[$i-1][0]){268 $pos++;269 $success=0;270 $fail=0;271 $max_fail=0;272 }273 }274 275 }elseif($asr_cic_list[$i][2]==1){276 $max++;277 }278 $success+=$asr_cic_list[$i][1];279 $fail+=$asr_cic_list[$i][2];280 $asr_cic_list1[$pos][0] = $asr_cic_list[$i][0];281 $asr_cic_list1[$pos][1] = $success;282 $asr_cic_list1[$pos][2] = $fail;283 284 if ($asr_cic_list[$i][2]==1){285 $total_fail_succ++;286 }elseif($total_fail_succ > $total_max_succ){287 $total_max_succ=$total_fail_succ;288 $total_fail_succ=0;289 }290 }291 }292 293 235 /************************/ 294 //$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)295 236 $QUERY = "SELECT substring(t1.starttime,1,10) AS day, sum(t1.sessiontime) AS calltime, sum(t1.sessionbill) AS cost, count(*) as nbcall, sum(t1.buycost) AS buy FROM $FG_TABLE_NAME WHERE ".$FG_TABLE_CLAUSE." GROUP BY substring(t1.starttime,1,10) ORDER BY day"; //extract(DAY from calldate) 296 237 … … 853 794 <tr> 854 795 <td align="center" class="bgcolor_019"></td> 855 <td class="bgcolor_020" align="center" colspan="1 3"><font class="fontstyle_003"><?php echo gettext("CALLING CARD MINUTES");?></font></td>796 <td class="bgcolor_020" align="center" colspan="10"><font class="fontstyle_003"><?php echo gettext("CALLING CARD MINUTES");?></font></td> 856 797 </tr> 857 798 <tr class="bgcolor_019"> … … 862 803 <td align="center"><font class="fontstyle_003"><acronym title="<?php echo gettext("AVERAGE LENGTH OF CALL");?>"><?php echo gettext("ALOC");?></acronym></font></td> 863 804 <td align="center"><font class="fontstyle_003"><acronym title="<?php echo gettext("ANSWER SEIZE RATIO");?>"><?php echo gettext("ASR");?></acronym></font></td> 864 <td align="center"><font class="fontstyle_003"><acronym title="<?php echo gettext("NUMBER OF FAIL CALLS");?>"><?php echo gettext("FAIL");?></acronym></font></td>865 <td align="center"><font class="fontstyle_003"><acronym title="<?php echo gettext("MAX OF NUMBER FAIL CALLS SUCCESSIVELY");?>"><?php echo gettext("MFCS");?></acronym></font></td>866 <td align="center"><font class="fontstyle_003"><acronym title="<?php echo gettext("RATE OF FAIL");?>"><?php echo gettext("ROF");?></acronym></font></td>867 805 <td align="center"><font class="fontstyle_003"><?php echo gettext("SELL");?></font></td> 868 806 <td align="center"><font class="fontstyle_003"><?php echo gettext("BUY");?></font></td> … … 903 841 <td bgcolor="<?php echo $FG_TABLE_ALTERNATE_ROW_COLOR[$i]?>" align="right" nowrap="nowrap"><font class="fontstyle_006"><?php echo $tmc?> </font></td> 904 842 <td bgcolor="<?php echo $FG_TABLE_ALTERNATE_ROW_COLOR[$i]?>" align="right" nowrap="nowrap"><font class="fontstyle_006"><?php display_2dec ($asr_cic_list1[$j][1]/($data[3]))?> </font></td> 905 <td bgcolor="<?php echo $FG_TABLE_ALTERNATE_ROW_COLOR[$i]?>" align="right" nowrap="nowrap"><font class="fontstyle_006"><?php echo $asr_cic_list1[$j][2]?> </font></td>906 <td bgcolor="<?php echo $FG_TABLE_ALTERNATE_ROW_COLOR[$i]?>" align="right" nowrap="nowrap"><font class="fontstyle_006"><?php echo $asr_cic_list1[$j][3]?> </font></td>907 <td bgcolor="<?php echo $FG_TABLE_ALTERNATE_ROW_COLOR[$i]?>" align="right" nowrap="nowrap"><font class="fontstyle_006"><?php display_2dec_percentage(($asr_cic_list1[$j][2]/($data[3]))*100)?> </font></td>908 843 <!-- SELL --> 909 844 <td bgcolor="<?php echo $FG_TABLE_ALTERNATE_ROW_COLOR[$i]?>" align="right" nowrap="nowrap"><font class="fontstyle_006"><?php … … 951 886 <td align="center" nowrap="nowrap"><font class="fontstyle_003"><?php echo $total_tmc?></font></td> 952 887 <td align="center" nowrap="nowrap"><font class="fontstyle_003"><?php display_2dec($totalsuccess/$totalcall)?> </font></td> 953 <td align="center" nowrap="nowrap"><font class="fontstyle_003"><?php echo $totalfail?></font></td>954 <td align="center" nowrap="nowrap"><font class="fontstyle_003"><?php echo $total_max_succ?></font></td>955 <td align="center" nowrap="nowrap"><font class="fontstyle_003"><?php display_2dec_percentage(($totalfail/$totalcall)*100)?></font></td>956 888 <td align="center" nowrap="nowrap"><font class="fontstyle_003"><?php display_2bill($totalcost) ?></font></td> 957 889 <td align="center" nowrap="nowrap"><font class="fontstyle_003"><?php display_2bill($totalbuycost) ?></font></td>
