Changeset 652

Show
Ignore:
Timestamp:
04/23/08 14:30:36 (7 months ago)
Author:
areski
Message:

Big bug if we have more that one Call Plan with LCR : the processing of LCR will not be exact !

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • branches/1.3/A2BCustomer_UI/lib/Class.RateEngine.php

    r625 r652  
    166166                 
    167167                FROM cc_tariffgroup  
    168                 RIGHT JOIN cc_tariffgroup_plan ON cc_tariffgroup.id=$tariffgroupid 
     168                RIGHT JOIN cc_tariffgroup_plan ON cc_tariffgroup_plan.idtariffgroup=cc_tariffgroup.id 
    169169                INNER JOIN cc_tariffplan ON (cc_tariffplan.id=cc_tariffgroup_plan.idtariffplan ) 
    170170                LEFT JOIN cc_ratecard ON cc_ratecard.idtariffplan=cc_tariffplan.id 
     
    173173                LEFT JOIN cc_package_offer ON cc_package_offer.id=cc_tariffgroup.id_cc_package_offer 
    174174                 
    175                 WHERE ($prefixclause) 
     175                WHERE cc_tariffgroup.id=$tariffgroupid AND ($prefixclause) 
    176176                AND startingdate<= CURRENT_TIMESTAMP AND (expirationdate > CURRENT_TIMESTAMP OR expirationdate IS NULL OR LENGTH(expirationdate)<5) 
    177177                AND startdate<= CURRENT_TIMESTAMP AND (stopdate > CURRENT_TIMESTAMP OR stopdate IS NULL OR LENGTH(stopdate)<5) 
     
    255255                { 
    256256                        $fee=$A2B->agiconfig['extracharge_fee'][array_search($A2B->dnid, $A2B->agiconfig['extracharge_did'])]; 
    257                         $A2B -> debug( WRITELOG, $agi, __FILE__, __LINE__, "[CC_asterisk_rate-engine: Extracharge DID found: ".$A2B->dnid.", extra fee: ".$fee."]"); 
     257                        $buyfee=$A2B->agiconfig['extracharge_buyfee'][array_search($A2B->dnid, $A2B->agiconfig['extracharge_did'])]; 
     258                        $A2B -> debug( WRITELOG, $agi, __FILE__, __LINE__, "[CC_asterisk_rate-engine: Extracharge DID found: ".$A2B->dnid.", extra fee: ".$fee.", extra buy fee: ".$buyfee."]"); 
    258259                        for ($i=0; $i<count($this->ratecard_obj); $i++) 
    259260                        { 
    260                                 $this->ratecard_obj[$i][9] +=$fee; 
     261                                $this->ratecard_obj[$i][9] +=$buyfee; 
    261262                                $this->ratecard_obj[$i][12]+=$fee; 
    262263                        } 
     
    969970                                 
    970971                        if ($typecall==1) $timeout = $A2B -> config["callback"]['predictivedialer_maxtime_tocall'];  
    971                                                 
     972                                 
    972973                        $dialparams = str_replace("%timeout%", min($timeout * 1000, $max_long), $A2B->agiconfig['dialcommand_param']); 
    973974                        //$dialparams = "|30|HS($timeout)"; // L(".$timeout*1000.":61000:30000) 
     
    10891090                                                $destination= substr($destination, strlen($removeprefix)); 
    10901091                                        } 
    1091                                                                                 
     1092                                         
    10921093                                        $dialparams = str_replace("%timeout%", min($timeout * 1000, $max_long), $A2B->agiconfig['dialcommand_param']); 
    10931094                                         
  • branches/1.3/A2Billing_AGI/libs_a2billing/Class.RateEngine.php

    r625 r652  
    166166                 
    167167                FROM cc_tariffgroup  
    168                 RIGHT JOIN cc_tariffgroup_plan ON cc_tariffgroup.id=$tariffgroupid 
     168                RIGHT JOIN cc_tariffgroup_plan ON cc_tariffgroup_plan.idtariffgroup=cc_tariffgroup.id 
    169169                INNER JOIN cc_tariffplan ON (cc_tariffplan.id=cc_tariffgroup_plan.idtariffplan ) 
    170170                LEFT JOIN cc_ratecard ON cc_ratecard.idtariffplan=cc_tariffplan.id 
     
    173173                LEFT JOIN cc_package_offer ON cc_package_offer.id=cc_tariffgroup.id_cc_package_offer 
    174174                 
    175                 WHERE ($prefixclause) 
     175                WHERE cc_tariffgroup.id=$tariffgroupid AND ($prefixclause) 
    176176                AND startingdate<= CURRENT_TIMESTAMP AND (expirationdate > CURRENT_TIMESTAMP OR expirationdate IS NULL OR LENGTH(expirationdate)<5) 
    177177                AND startdate<= CURRENT_TIMESTAMP AND (stopdate > CURRENT_TIMESTAMP OR stopdate IS NULL OR LENGTH(stopdate)<5) 
  • branches/1.3/A2Billing_UI/lib/Class.RateEngine.php

    r625 r652  
    166166                 
    167167                FROM cc_tariffgroup  
    168                 RIGHT JOIN cc_tariffgroup_plan ON cc_tariffgroup.id=$tariffgroupid 
     168                RIGHT JOIN cc_tariffgroup_plan ON cc_tariffgroup_plan.idtariffgroup=cc_tariffgroup.id 
    169169                INNER JOIN cc_tariffplan ON (cc_tariffplan.id=cc_tariffgroup_plan.idtariffplan ) 
    170170                LEFT JOIN cc_ratecard ON cc_ratecard.idtariffplan=cc_tariffplan.id 
     
    173173                LEFT JOIN cc_package_offer ON cc_package_offer.id=cc_tariffgroup.id_cc_package_offer 
    174174                 
    175                 WHERE ($prefixclause) 
     175                WHERE cc_tariffgroup.id=$tariffgroupid AND ($prefixclause) 
    176176                AND startingdate<= CURRENT_TIMESTAMP AND (expirationdate > CURRENT_TIMESTAMP OR expirationdate IS NULL OR LENGTH(expirationdate)<5) 
    177177                AND startdate<= CURRENT_TIMESTAMP AND (stopdate > CURRENT_TIMESTAMP OR stopdate IS NULL OR LENGTH(stopdate)<5) 
     
    255255                { 
    256256                        $fee=$A2B->agiconfig['extracharge_fee'][array_search($A2B->dnid, $A2B->agiconfig['extracharge_did'])]; 
    257                         $A2B -> debug( WRITELOG, $agi, __FILE__, __LINE__, "[CC_asterisk_rate-engine: Extracharge DID found: ".$A2B->dnid.", extra fee: ".$fee."]"); 
     257                        $buyfee=$A2B->agiconfig['extracharge_buyfee'][array_search($A2B->dnid, $A2B->agiconfig['extracharge_did'])]; 
     258                        $A2B -> debug( WRITELOG, $agi, __FILE__, __LINE__, "[CC_asterisk_rate-engine: Extracharge DID found: ".$A2B->dnid.", extra fee: ".$fee.", extra buy fee: ".$buyfee."]"); 
    258259                        for ($i=0; $i<count($this->ratecard_obj); $i++) 
    259260                        { 
    260                                 $this->ratecard_obj[$i][9] +=$fee; 
     261                                $this->ratecard_obj[$i][9] +=$buyfee; 
    261262                                $this->ratecard_obj[$i][12]+=$fee; 
    262263                        } 
     
    969970                                 
    970971                        if ($typecall==1) $timeout = $A2B -> config["callback"]['predictivedialer_maxtime_tocall'];  
    971                                                 
     972                                 
    972973                        $dialparams = str_replace("%timeout%", min($timeout * 1000, $max_long), $A2B->agiconfig['dialcommand_param']); 
    973974                        //$dialparams = "|30|HS($timeout)"; // L(".$timeout*1000.":61000:30000) 


Google