Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Thu Mar 28, 2024 7:21 pm
VoIP Billing solution


All times are UTC




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: Adding invoices & dids directly to db
PostPosted: Sat Dec 07, 2013 1:52 pm 
Offline

Joined: Wed Dec 04, 2013 7:07 am
Posts: 5
Hello,


I am developing an order form for ordering a package with did number,

In big what i need to understand is in which tables in MySQL i have to add my data:
- New invoice
- New payment
- Mark invoice as paid (and adding transaction info)
- Adding did to system with monthly invoicing (this i managed)
- Logging activity?

Thanks


Top
 Profile  
 
 Post subject: Re: Adding invoices & dids directly to db
PostPosted: Sat Dec 07, 2013 4:33 pm 
Offline

Joined: Wed Dec 04, 2013 7:07 am
Posts: 5
My target would be:
1. Case one:New DID purchased: create invoice, payment,log payment and create+assign user with newly purchased DID
2. Case two: Simple account refill.

As per the DB, these are the tables that i found that might be relevant, please correct me or direct me:

New payment:
cc_invoice (create new invoice here)
cc_invoice_item (new line for the new invoice here too)
cc_payments (payment data here)
cc_invoice_payment (relate the invoice to the payment - cc_logpayment)
cc_logpayment (log the payment)
cc_epayment_log (again log for payment incase its from payment gateway)

New DID to a2billing:
cc_did (add new did info here)
cc_charge (add a monthly charge for the didnumber?)
cc_did_use (not sure if anything should be added here..)

In-case of simply refill - (add new payment in tables above) + :
cc_card (add credit amount to the sum in the credit column)
cc_logrefill (incase of refill?)


The reason that i want to directly inject to the DB is that in my opinion its easier to add more payment methouds, and easier to implement did resale rather than using the current options in a2billing.


Many thanks.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 
Hosted Voice Broadcast


All times are UTC


Who is online

Users browsing this forum: No registered users and 4 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