Changeset 1014

Show
Ignore:
Timestamp:
09/14/08 19:04:12 (4 months ago)
Author:
areski
Message:

optimization for CDRs

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • trunk/customer/call-history.php

    r1004 r1014  
    2929} 
    3030 
    31 $customer = $_SESSION["pr_login"]; 
     31$customer = $_SESSION["card_id"]; 
    3232 
    3333getpost_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', 'terminatecauseid', 'choose_calltype')); 
    3434 
     35$dialstatus_list = Constants::getDialStatusList(); 
    3536 
    3637if (!isset ($current_page) || ($current_page == "")){ 
    …… 
    6768$FG_TABLE_COL[]=array (gettext("Source"), "source", "12%", "center", "SORT", "30"); 
    6869$FG_TABLE_COL[]=array (gettext("PhoneNumber"), "calledstation", "12%", "center", "SORT", "30", "", "", "", "", "", "remove_prefix"); 
    69 $FG_TABLE_COL[]=array (gettext("Destination"), "destination", "12%", "center", "SORT", "30", "", "", "", "", "", "remove_prefix"); 
     70$FG_TABLE_COL[]=array (gettext("Destination"), "id_cc_prefix", "12%", "center", "SORT", "30", "", "", "", "", "", "remove_prefix"); 
    7071$FG_TABLE_COL[]=array (gettext("Duration"), "sessiontime", "7%", "center", "SORT", "30", "", "", "", "", "", "display_minute"); 
    71 $FG_TABLE_COL[]=array (gettext("Cardused"), "username", "11%", "center", "SORT", "30"); 
    72 $FG_TABLE_COL[]=array ('<acronym title="'.gettext("Terminate Cause").'">'.gettext("TC").'</acronym>', "terminatecauseid", "9%", "center", "SORT", "30"); 
     72$FG_TABLE_COL[]=array ('<acronym title="'.gettext("Terminate Cause").'">'.gettext("TC").'</acronym>', "terminatecauseid", "7%", "center", "SORT", "", "list", $dialstatus_list); 
    7373$FG_TABLE_COL[]=array (gettext("Calltype"), "sipiax", "6%", "center", "SORT",  "", "list", $list_calltype); 
    7474$FG_TABLE_COL[]=array (gettext("InitalRate"), "calledrate", "9%", "center", "SORT", "30", "", "", "", "", "", "display_2bill"); 
    …… 
    8080         
    8181// This Variable store the argument for the SQL query 
    82 $FG_COL_QUERY='t1.starttime, t1.src, t1.calledstation, t1.destination, t1.sessiontime, t1.username, t1.terminatecauseid, t1.sipiax, t1.calledrate, t1.sessionbill'; 
     82$FG_COL_QUERY='t1.starttime, t1.src, t1.calledstation, t1.destination, t1.sessiontime, t1.terminatecauseid, t1.sipiax, t1.calledrate, t1.sessionbill'; 
    8383// t1.stoptime, 
    8484 
    …… 
    170170 
    171171if (strlen($FG_TABLE_CLAUSE)>0) $FG_TABLE_CLAUSE.=" AND "; 
    172 $FG_TABLE_CLAUSE.="t1.username='$customer'"; 
     172$FG_TABLE_CLAUSE.="t1.card_id='$customer'"; 
    173173 
    174174 
    …… 
    638638      </table> 
    639639 
    640 <?php  if (is_array($list) && count($list)>0 && 3==4){ ?> 
    641 <!-- ************** TOTAL SECTION ************* --> 
    642                         <br/> 
    643                         <div style="padding-right: 15px;"> 
    644                         <table cellpadding="1" bgcolor="#000000" cellspacing="1" width="200" align="right"> 
    645                                 <tbody> 
    646                 <tr class="form_head">                                                                                              
    647                                    <td width="33%" align="center" class="tableBodyRight" bgcolor="#600101" style="padding: 5px;"><strong><?php echo gettext("Total Cost");?></strong></td> 
    648                                     
    649                 </tr> 
    650                                 <tr> 
    651                                   <td valign="top" align="center" class="tableBody" bgcolor="white"><b><?php echo $total_cost[0][0]?></b></td> 
    652                                    
    653                                 </tr> 
    654                         </table> 
    655                         </div> 
    656                         <br/><br/> 
    657                                          
    658 <!-- ************** TOTAL SECTION ************* --> 
    659 <?php  } ?> 
    660  
    661640<!-- ** ** ** ** ** Part to display the GRAPHIC ** ** ** ** ** --> 
    662641<br> 


Google