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
|