Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Tue Apr 16, 2024 11:41 pm
Predictive Dialer


All times are UTC




Post new topic Reply to topic  [ 1 post ] 
Author Message
 Post subject: Export Callplan (LCR)
PostPosted: Tue Dec 24, 2013 9:51 pm 
Offline

Joined: Wed Mar 13, 2013 11:44 am
Posts: 4
When we export LCR plan and if there are same prefixes with different costs then the default values export the callplan with highest cost by default

For Ex if you have
1,USA,0.001,1
1,USA,0.004,1

the export output will have 0.004

To over come this and to have minimum value I used min function and changed the value of rate_export_field_list to destination, dialprefix, min(rateinitial)

So, These lines needs to be modified in the source code

a2billing-schema-v1.4.0.sql:INSERT INTO `cc_config` (`id`, `config_title`, `config_key`, `config_value`, `config_description`, `config_valuetype`, `config_listvalues`, `config_group_title`) VALUES(243, 'Rate Export Fields', 'rate_export_field_list', 'destination, dialprefix, rateinitial', 'Fields to export in csv format from rates table.Use dest_name from prefix name', 0, NULL, 'webui');
UPDATE-a2billing-v1.3.4-to-v1.4.0.sql:INSERT INTO cc_config (config_title, config_key, config_value, config_description, config_valuetype, config_group_title, config_listvalues) VALUES ('Rate Export Fields', 'rate_export_field_list', 'destination, dialprefix, rateinitial', 'Fields to export in csv format from rates table.Use dest_name from prefix name', 0, 'webui', NULL);

to

a2billing-schema-v1.4.0.sql:INSERT INTO `cc_config` (`id`, `config_title`, `config_key`, `config_value`, `config_description`, `config_valuetype`, `config_listvalues`, `config_group_title`) VALUES(243, 'Rate Export Fields', 'rate_export_field_list', 'destination, dialprefix, min(rateinitial)', 'Fields to export in csv format from rates table.Use dest_name from prefix name', 0, NULL, 'webui');
UPDATE-a2billing-v1.3.4-to-v1.4.0.sql:INSERT INTO cc_config (config_title, config_key, config_value, config_description, config_valuetype, config_group_title, config_listvalues) VALUES ('Rate Export Fields', 'rate_export_field_list', 'destination, dialprefix, min(rateinitial)', 'Fields to export in csv format from rates table.Use dest_name from prefix name', 0, 'webui', NULL);

Also, under the rates page when we query LCR page the BR and SR values are different which I couldn't fix


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 1 post ] 
Predictive Dialer


All times are UTC


Who is online

Users browsing this forum: No registered users and 9 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group