Changeset 624

Show
Ignore:
Timestamp:
03/21/08 10:12:58 (8 months ago)
Author:
stavros
Message:

UPDATE: the CDR reports were needlessly loading every row from the cc_card table into memory

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • branches/1.3/A2Billing_UI/Public/call-last-month.php

    r226 r624  
    252252/*************************************************************/ 
    253253 
    254  
    255 $instance_table_customer = new Table("cc_card", "id,  username, lastname"); 
    256  
    257 $FG_TABLE_CLAUSE = ""; 
    258 /*if ($_SESSION["is_admin"]==0){         
    259         $FG_TABLE_CLAUSE =" IDmanager='".$_SESSION["pr_reseller_ID"]."'";        
    260 }*/ 
    261  
    262 $list_customer = $instance_table_customer -> Get_list ($DBHandle, $FG_TABLE_CLAUSE, "id", "ASC", null, null, null, null); 
    263  
    264 $nb_customer = count($list_customer); 
    265254 
    266255?> 

  • branches/1.3/A2Billing_UI/Public/call-log-customers.php

    r126 r624  
    348348if ($FG_DEBUG == 3) echo "<br>Nb_record : $nb_record"; 
    349349if ($FG_DEBUG == 3) echo "<br>Nb_record_max : $nb_record_max"; 
    350  
    351  
    352 $instance_table_customer = new Table("cc_card", "id,  username, lastname"); 
    353  
    354 $FG_TABLE_CLAUSE = ""; 
    355 if ($_SESSION["is_admin"]==0){   
    356         $FG_TABLE_CLAUSE =" IDmanager='".$_SESSION["pr_reseller_ID"]."'";        
    357 } 
    358  
    359  
    360 $list_customer = $instance_table_customer -> Get_list ($DBHandle, $FG_TABLE_CLAUSE, "id", "ASC", null, null, null, null); 
    361  
    362 $nb_customer = count($list_customer); 
    363350 
    364351 

  • trunk/A2Billing_UI/Public/call-log-customers.php

    r570 r624  
    326326if ($FG_DEBUG == 3) echo "<br>Nb_record : $nb_record"; 
    327327if ($FG_DEBUG == 3) echo "<br>Nb_record_max : $nb_record_max"; 
    328  
    329  
    330 $instance_table_customer = new Table("cc_card", "id,  username, lastname"); 
    331  
    332 $FG_TABLE_CLAUSE = ""; 
    333 if ($_SESSION["is_admin"]==0){   
    334         $FG_TABLE_CLAUSE =" IDmanager='".$_SESSION["pr_reseller_ID"]."'";        
    335 } 
    336  
    337  
    338 $list_customer = $instance_table_customer -> Get_list ($DBHandle, $FG_TABLE_CLAUSE, "id", "ASC", null, null, null, null); 
    339  
    340 $nb_customer = count($list_customer); 
    341328 
    342329 


Google