Show
Ignore:
Timestamp:
07/24/08 17:40:11 (4 years ago)
Author:
areski
Message:

New Feature : to switch the Callplan from a customer, callplan_deck_minute_threshold

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

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

    r891 r895  
    10151015 
    10161016 
    1017 -- ALTER TABLE `cc_config` CHANGE `config_description` `config_description` TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL; 
    1018 --  ALTER TABLE `cc_config` CHANGE `config_description` `config_description` VARCHAR( 500 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL   
    1019  
    1020 -- Deck threshold switch for callplan  
    1021 -- delete from cc_config where config_key='callplan_deck_minute_threshold'; 
    1022  
     1017ALTER TABLE `cc_config` CHANGE `config_description` `config_description` TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL; 
     1018 
     1019 
     1020-- Deck threshold switch for callplan 
    10231021INSERT INTO cc_config (config_title, config_key, config_value, config_description, config_valuetype, config_group_id, config_listvalues)  
    10241022VALUES ('CallPlan threshold Deck switch', 'callplan_deck_minute_threshold', '', 'CallPlan threshold Deck switch. <br/>This option will switch the user callplan from one call plan ID to and other Callplan ID 
    10251023The parameters are as follow : <br/> 
    1026 -- ID of the first callplan : called minutes needed to switch to the next CallplanID <br/> 
    1027 -- ID of the second callplan : called minutes needed to switch to the next CallplanID <br/> 
    1028 -- if not needed minutes are defined it will automatically switch to the next one <br/> 
    1029 -- if defined we will sum the previous needed minutes and check if the caller had done at least the amount of calls necessary to go to the next step and have the amount of minutes needed<br/> 
    1030 value example for callplan_deck_minute_threshold = 1:5, 2:1, 3',  
     1024-- ID of the first callplan : called seconds needed to switch to the next CallplanID <br/> 
     1025-- ID of the second callplan : called seconds needed to switch to the next CallplanID <br/> 
     1026-- if not needed seconds are defined it will automatically switch to the next one <br/> 
     1027-- if defined we will sum the previous needed seconds and check if the caller had done at least the amount of calls necessary to go to the next step and have the amount of seconds needed<br/> 
     1028value example for callplan_deck_minute_threshold = 1:300, 2:60, 3',  
    10311029'0', '11', NULL); 
    10321030 
    10331031 
    1034  
    1035 -- TODO Test insert of config and not show value 
    1036 -- INSERT INTO `cc_config` ( `config_title`, `config_key`, `config_value`, `config_description`, `config_valuetype`, `config_group_id`, `config_listvalues`) VALUES('Extra charge DIDs', 'extracharge_did', '1800,1900', 'Add extra per-minute charges to this comma-separated list of DNIDs; needs "extracharge_fee" and "extracharge_buyfee"', 0, 11, NULL);