Changeset 1060

Show
Ignore:
Timestamp:
09/18/08 19:29:36 (2 months ago)
Author:
rach
Message:

Refactor Recurring Service

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • trunk/admin/Public/form_data/FG_var_card_group.inc

    r1059 r1060  
    2424 
    2525 
    26 $DBHandle  = DbConnect(); 
    27 $conf_table = new Table("cc_config_group", "group_title"); 
    28 $clause_conf_agi = "cc_config_group.group_title LIKE 'agi_conf_%'"; 
    29 $result_config= $conf_table -> Get_list ($DBHandle, $clause_conf_agi, null, null, null, null, null, null); 
    30 $agi_list = array(); 
    31 $agi_list[-1] = array( gettext("NOT DEFINED"), "-1"); 
    32 foreach ($result_config as $value){ 
    33       $agi_list[substr($value["group_title"],8)] = array($value["group_title"], substr($value["group_title"],8));      
    34 } 
     26//$DBHandle  = DbConnect(); 
     27//$conf_table = new Table("cc_config_group", "group_title"); 
     28//$clause_conf_agi = "cc_config_group.group_title LIKE 'agi_conf_%'"; 
     29//$result_config= $conf_table -> Get_list ($DBHandle, $clause_conf_agi, null, null, null, null, null, null); 
     30//$agi_list = array(); 
     31//$agi_list[-1] = array( gettext("NOT DEFINED"), "-1"); 
     32//foreach ($result_config as $value){ 
     33//    $agi_list[substr($value["group_title"],8)] = array($value["group_title"], substr($value["group_title"],8));      
     34//} 
    3535 
    3636$HD_Form -> AddViewElement(gettext("NAME"), "name", "25%", "center", "sort"); 
    …… 
    7272 
    7373 
     74         
     75$DBHandle_max  = DbConnect(); 
     76$numrow = 0; 
     77$resmax = $DBHandle_max -> Execute("SELECT * FROM cc_service"); 
     78if ( $resmax ) 
     79        $numrow = $resmax -> RecordCount( ); 
     80 
     81if ($numrow>0){  
     82        $HD_Form -> AddEditElement (gettext("RECURRING SERVICE"), 
     83                "service",       
     84                '$value',        
     85                "SELECT",                
     86                'size="10" multiple="multiple"', 
     87                "",              
     88                "",      
     89                "sql",           
     90                "cards_services",        
     91                "name, id",              
     92                "", "", "%1 : (%2)", "", "", "cc_cardgroup_service:id_service:cc_service LEFT JOIN cc_cardgroup_service ON cc_service.id=cc_cardgroup_service.id_service:DISTINCT cc_service.name, cc_service.id: cc_cardgroup_service.id_card_group = %id:id_card_group:%2 - (%1)::::%1:id='%1'");              
     93         
     94} 
     95 
    7496 
    7597 

  • trunk/DataBase/mysql-5.x/UPDATE-a2billing-v1.3.0-to-v1.4.0-mysql.sql

    r1039 r1060  
    812812  id smallint(5) NOT NULL auto_increment, 
    813813  id_support smallint(5) NOT NULL, 
    814   `name` varchar(50) collate utf8_bin NOT NULL, 
     814  name varchar(50) collate utf8_bin NOT NULL, 
    815815  activated smallint(6) NOT NULL default '1', 
    816816  PRIMARY KEY  (id) 
    …… 
    11331133UPDATE cc_ui_authen SET perms = '5242879' WHERE userid=1 LIMIT 1; 
    11341134 
     1135-- correct card group 
     1136ALTER TABLE cc_card_group DROP id_agi_conf; 
     1137ALTER TABLE cc_card_group ADD description MEDIUMTEXT NULL ; 
     1138 
     1139 CREATE TABLE cc_cardgroup_service ( 
     1140id_card_group INT NOT NULL , 
     1141id_service INT NOT NULL 
     1142) ENGINE = MYISAM ; 


Google