[Asterisk-Users] Really lightweight itemised billing
Darren Wiebe
darren at aleph-com.net
Fri Nov 25 09:36:21 MST 2005
Do you have accountcodes in the database? If you do, you could use
astpp quite easily. We could cut out most of the functionality for
you. Right now I don't have a way to search by date but that would be
failry easy to add and I will be working on it soon anyways. Drop me a
line if you want or visit www.aleph-com.net/astpp
Darren Wiebe
darren at aleph-com.net
Chris Bagnall wrote:
>Good morning all,
>
>I'm trying to find an application that'll do really lightweight billing for
>Asterisk CDRs.
>
>On our asterisk servers deployed at people's offices, we have CDRs being
>logged to PostgreSQL, which can then be analysed by the staff at those
>offices using a PHP-based CDR analyser. This works fine for legitimate use
>verification (it's easy to spot people making hours of phone calls to their
>girlfriend's mobile, for example), but it doesn't provide billing
>verification.
>
>All I'm looking to do is parse the CDRs for a given date range, lookup each
>dialled number in a table to get its rate, then present a formatted list (or
>even a .csv) of the person dialling (accountcode), time/date of call,
>duration and total cost of call.
>
>All of the billing applications I've seen so far are either 1) really
>heavyweight designed for calling card or other charging purposes, or 2) want
>me to modify the asterisk configuration to use their AGIs for dialling. It's
>an overkill for what I'm after.
>
>Before I go and write some PHP scripts to do what I'm after, has anyone
>already done this and have some scripts they want to share? :-)
>
>Thanks in advance.
>
>Regards,
>
>Chris
>
>
More information about the asterisk-users
mailing list