#1  
Old 18th October 2006, 15:50
krakoukas krakoukas is offline
Member
 
Join Date: Sep 2006
Location: Paris
Posts: 64
Thanks: 2
Thanked 3 Times in 2 Posts
Default Billing questions

I am looking for billing activation. I will describe here what I first understood on the ISPConfig billing behaviour:

- Billing takes place for each Web Site
- Each product must be defined in ISP Billing menu (the billing period field is in month)
- Traffic and Web default product are already placed for web site
- Once a web site is created, you must add new products to it to activate billing for the coresponding client.

What I don't know yet:
- Is there a batch billing processing, for automatically create invoices?
- is there remoting API to attach a product to a web site?
- Where the data is strored in database to manually generate alerts on product end time?

Thanks for you help
Reply With Quote
Sponsored Links
  #2  
Old 19th October 2006, 09:56
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,703
Thanks: 819
Thanked 5,320 Times in 4,173 Posts
Default

Quote:
Originally Posted by krakoukas
- Is there a batch billing processing, for automatically create invoices?
Yes, its in the upper menu of the billing module, the icon with the coins / money

Quote:
- is there remoting API to attach a product to a web site?
Not yet.

Quote:
- Where the data is strored in database to manually generate alerts on product end time?
the invoices are stored In the isp_fakt_rechnung table, the product records are stored in the table isp_fakt_rechnung.

Some translations:

erste_abrechnung is the timestamp of the creation of the product.
letzte_abrechnung is the timestamp of the last time a invoice has been created for this product.
anzahl means number.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 19th October 2006, 19:40
krakoukas krakoukas is offline
Member
 
Join Date: Sep 2006
Location: Paris
Posts: 64
Thanks: 2
Thanked 3 Times in 2 Posts
Default

Quote:
Originally Posted by till
- is there remoting API to attach a product to a web site?
Not yet.
Do you think I could add it to the remoting API (if you show me where and how)?
Or may I would to do it directly in SQL adding a record in isp_fakt_record table?

Quote:
Originally Posted by till
- Where is stored the data in database to manually generate alerts on product end time?
the invoices are stored In the isp_fakt_rechnung table, the product records are stored in the table isp_fakt_rechnung.
So if I check in the isp_fakt_record for expired timestamps (for one year product prepayed), I will have my alerts?

For the billing tables, you mean:
isp_fakt_artikel: contains the list of all available products.
isp_fakt_rechnung: contains all the invoices generated by pressing the generate invoice button
isp_fakt_record: contains all the products subscribed by a web site.
isp_fakt_node and isp_fakt_dep: I didn't understood their use yet...

In fact, I erased all the data in isp_fakt_rechnung and I cannot generate the lost invoices again. There must be a flag somewhere that says that the invoices are already generated?
Reply With Quote
  #4  
Old 20th October 2006, 11:19
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,703
Thanks: 819
Thanked 5,320 Times in 4,173 Posts
Default

Quote:
Originally Posted by krakoukas
Do you think I could add it to the remoting API (if you show me where and how)?
Or may I would to do it directly in SQL adding a record in isp_fakt_record table?
You may try to add them directly to SQL, the invoicing system is not yet part of the remoting framework.

Quote:
So if I check in the isp_fakt_record for expired timestamps (for one year product prepayed), I will have my alerts?
If i remember correctly, the timestamps are not the expiration date, they are the date when the last invoice has been created. You will have to add the seconds of 1 year to get the expiration timestamp.

Quote:
For the billing tables, you mean:
isp_fakt_artikel: contains the list of all available products.
isp_fakt_rechnung: contains all the invoices generated by pressing the generate invoice button
isp_fakt_record: contains all the products subscribed by a web site.
yes.

Quote:
isp_fakt_node and isp_fakt_dep: I didn't understood their use yet...
The contain the dependencies and permissions for the isp_fakt_artikel table.

Quote:
In fact, I erased all the data in isp_fakt_rechnung and I cannot generate the lost invoices again.
correct.

Quote:
There must be a flag somewhere that says that the invoices are already generated?
No. You will have empty or lower the invoice creation timestamp in the isp_fakt_record table.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 10th April 2007, 16:01
smartcall smartcall is offline
Senior Member
 
Join Date: Nov 2006
Posts: 116
Thanks: 10
Thanked 7 Times in 3 Posts
Default

Hi,

I have a few additional questions:

1. What is the field 'status' in isp_fakt_record reffering to? Could I use this field to mark the invoice as paid, if I set the default value to 0. Or it is for something else?
2. How do I turn those numbers in letzte_abrechnung to date?

Basically what I want to do is:
1. I have a test hosting plan that is for 6 months. I want to make a product that is billed monthly and when there are 6 invoices for a client for the last 6 months I want to suspend the site. Like the script that suspends sites on traffic exceedence.

2. And for the regular hosting plans I need a field where I will mark the invoice as paid, because I want to make a script that suspend sites which haven't been paid 15 days after last invoice.

Thanks a lot.

PS. And when I have the working solution I will post it in the forum.
Reply With Quote
  #6  
Old 11th April 2007, 10:11
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,703
Thanks: 819
Thanked 5,320 Times in 4,173 Posts
Default

1) No. There is no field to mark a invoice as paid in the database.
2) It is a linux timestamp. You may convert it e.g. with the PHP date function to a human readable format.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #7  
Old 12th April 2007, 15:39
smartcall smartcall is offline
Senior Member
 
Join Date: Nov 2006
Posts: 116
Thanks: 10
Thanked 7 Times in 3 Posts
Default

Thanks

Call me stupid, but I've been struggling whole day to find out the relation between isp_fakt_rechnung and isp_fakt_record. And I can't find one.

I suppose that isp_nodes and isp_dep as well as isp_isp_kunde are involved, but can't manage to find out.
Reply With Quote
  #8  
Old 12th April 2007, 16:01
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,703
Thanks: 819
Thanked 5,320 Times in 4,173 Posts
 
Default

isp_fakt_rechnung and isp_fact_record have no direct relation.

isp_fact_record has a relation to isp_isp_web trough the web_id which is the doc_id of the website. Every website is owned by just one client. Every client has a record in isp_isp_kunde and isp_fakt_rechnung has a column kunde_id which is the doc_id of the isp_isp_kunde record.

Have a look in the following file to see how the invoices in isp_fakt_rechnung are created:

/home/admispconfig/ispconfig/web/isp_fakt/abrechnung/rechnung_erstellen.php
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
smartcall (12th April 2007)
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Hostname & DNS questions... SurfingAlien Installation/Configuration 6 16th October 2007 16:32
Extreme n00b questions re: Ubuntu 6.06 Perfect Setup titbeak HOWTO-Related Questions 2 2nd September 2006 14:09
4 questions about ispconfig and domains, please help! dimas Installation/Configuration 7 1st August 2006 11:55
General ISPConfig Newbie Questions christopher Installation/Configuration 1 24th November 2005 09:54
Newbie questions SidSkiba Installation/Configuration 2 29th August 2005 20:51


All times are GMT +2. The time now is 20:48.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.