We are several small business in a building sharing one FreePBX 126.96.36.199 as a gateway to the PSTN
We would like to be able to automatically generate a bill for each business every month. Ideally it would be generated using the inbound calls to DID’s and the Outbound calls generated from particular CIDs.
Is there a nice and simple way to do this??
I have been looking for days and cannot find a simple solution. I have ended up several times looking at and installing a2Billing in a test environment but I think it’s way overkill and to be honest I can’t get it working. I don’t need calling card type control, I don’t need to turn people on and off if they are late with a payment I just need to be able to present a statement of call usage to each party in the building that is reasonably reliable.
The call logs are all in mysql database with freepbx. Wouldn’t be too hard to create a cron job to dump the data regularly. I haven’t looked at the data in detail, but all the info is there. Looks to me like it would require two queries, one for incoming and one for outgoing.