Why not use mod_lcr to determine your rates? It already does all this work for you. I even added a feature recently that allows one to calculate/lookup end user rates (in addition to the carrier rate you are paying for a given route). On Tue, Oct 13, 2009 at 4:53 PM, Diego Viola <diego.viola@gmail.com> wrote:
Hello,
I'm trying to write a post-paid billing script, I have the CDR on my database and also a "rates" table, the CDR contains fields like caller_destination_number, variable_duration, etc. and the rates table contains: destination, prefix, rate (cost).
The problem is that I can't just strip the destination number to take the prefix from it because I have to deal with destination numbers from different countries and they all have different prefix lengths... so I need to find another way to take the prefix from the destination number.
Any ideas how to do this?
Thanks,
-- -Rupa