Changeset 867

Show
Ignore:
Timestamp:
07/08/08 05:00:03 (2 months ago)
Author:
rach
Message:

correction bug : package query

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • trunk/common/lib/Class.RateEngine.php

    r863 r867  
    364364                if($id_cc_package_group!=-1){ 
    365365                         
    366                         $table_packages = new Table("cc_package_group,cc_packgroup_package,cc_package_offer,cc_package_rate", "cc_package_offer.id, packagetype,billingtype,startday,freetimetocall"); 
    367                         $clause_packages= "cc_package_group.id= ".$id_cc_package_group." AND cc_package_group.id=cc_packgroup_package.packagegroup_id AND cc_packgroup_package.package_id = cc_package_offer.id AND cc_package_offer.id = cc_package_rate.package_id  AND cc_package_rate.rate_id = ".$id_rate; 
    368                         $order_packages = "cc_package_offer.packagetype"; 
    369                         $sens_packages = "ASC"; 
    370                         $result_packages= $table_packages -> Get_list ($A2B -> DBHandle, $clause_packages, $order_packages, $sens_packages, null, null, null, null); 
     366                        //$table_packages = new Table("cc_package_group,cc_packgroup_package,cc_package_offer,cc_package_rate", "cc_package_offer.id, packagetype,billingtype,startday,freetimetocall"); 
     367                        //$clause_packages= "cc_package_group.id= ".$id_cc_package_group." AND cc_package_group.id=cc_packgroup_package.packagegroup_id AND cc_packgroup_package.package_id = cc_package_offer.id AND cc_package_offer.id = cc_package_rate.package_id  AND cc_package_rate.rate_id = ".$id_rate; 
     368                        //$order_packages = "cc_package_offer.packagetype"; 
     369                        //$sens_packages = "ASC"; 
     370                        //$result_packages= $table_packages -> Get_list ($A2B -> DBHandle, $clause_packages, $order_packages, $sens_packages, null, null, null, null); 
     371                        $query_pakages ="SELECT cc_package_offer.id, packagetype,billingtype,startday,freetimetocall  
     372                        FROM cc_package_group,cc_packgroup_package,cc_package_offer,cc_package_rate  
     373                        WHERE cc_package_group.id= ".$id_cc_package_group."  
     374                                AND cc_package_group.id=cc_packgroup_package.packagegroup_id  
     375                                AND cc_packgroup_package.package_id = cc_package_offer.id  
     376                                AND cc_package_offer.id = cc_package_rate.package_id   
     377                                AND cc_package_rate.rate_id = ".$id_rate." ORDER BY packagetype ASC"; 
     378                        $table_packages = new Table(); 
     379                        $A2B -> debug( VERBOSE | WRITELOG, $agi, __FILE__, __LINE__, "[FIND PACKAGE  QUERY = $query_pakages]"); 
     380                        $result_packages = $table_packages -> SQLExec ($A2B -> DBHandle, $query_pakages); 
    371381                        $idx_pack = 0; 
    372382                        if(!empty($result_packages)) 
    …… 
    379389                                        $startday                       = $result_packages[$idx_pack]["startday"]; 
    380390                                        $id_cc_package_offer= $result_packages[$idx_pack][0]; 
    381                                          
     391                                        $A2B -> debug( VERBOSE | WRITELOG, $agi, __FILE__, __LINE__, "[ID PACKAGE  TO APPLY = $id_cc_package_offer]"); 
    382392                                        switch($packagetype){ 
    383393                                                // 0 : UNLIMITED PACKAGE 
    …… 
    918928                        $dialstatus = $this -> dialstatus; 
    919929                } 
    920                 $id_card_package_offer =0; 
    921930                if ($sessiontime > 0) { 
    922931                        // HANDLE FREETIME BEFORE CALCULATE THE COST 
    …… 
    926935 
    927936                        if (($id_cc_package_group!=-1) && ($this ->package_to_apply[$K] !=null )){ 
     937                        $id_package_offer =$this ->package_to_apply[$K]["id"]; 
    928938         
    929939                                //$id_card_package_offer = $this ->package_to_apply[$K]["id"]; 
    …… 
    949959 
    950960                                $QUERY_FIELS = 'id_cc_card, id_cc_package_offer, used_secondes'; 
    951                                 $QUERY_VALUES = "'".$A2B -> id_card."', '$id_cc_package_offer', '$this->freetimetocall_used'"; 
     961                                $QUERY_VALUES = "'".$A2B -> id_card."', '$id_package_offer', '$this->freetimetocall_used'"; 
    952962                                $id_card_package_offer = $A2B -> instance_table -> Add_table ($A2B -> DBHandle, $QUERY_VALUES, $QUERY_FIELS, 'cc_card_package_offer', 'id'); 
    953963                                $A2B -> debug( VERBOSE | WRITELOG, $agi, __FILE__, __LINE__, ":[ID_CARD_PACKAGE_OFFER CREATED : $id_card_package_offer]:[$QUERY_VALUES]"); 


Google