Hi, These are definitely advanced bits, but thankfully you can cater for them.
1). Critical here is whether or not it is pre-paid. For pre-paid you would have a lot more work to do. Another critical point here would be how you hold your Radius logs. If you are using Rodopi for authentication through to Radius using a built-in Interface_xxxx stored procedure then this can be modified to cater for this advanced functionality. What you would look at doing, is capturing the start time of a premium call (you can get this from an ACCT Start packet), and logging it to a database table. You then log the corresponding STOP packets o that you know the duration. By using a new table in the Rodopi database you keep things clean and relatively easy for you to upgrade. You would then create a script to calculate the amount to charge the user and add a transaction to the user account. This should be done as a separate stored procedure. Ideally you would integrate this with existing stored procedures for appending the transaction to the user account. The final step would be to modify the Rodopi Daily Billing Task to run this stored procedure prior to any other, ensuring it runs as part of the billing sequence on a daily basis. Should you want more help with this email me off-list. 2). I find this a little strange, since if you are selling the space with an overage per website then surely the person paying would want to know which of his client sites generated the overage and how much for. Using the per site system as is would cater for that. If you have other reasons, fire me a message off-list and I'll help you come up with a solution. I would say to keep it on-list but this will be a little involved as we are working with usage data. We could work by creating our own usage filter to collect aggregated statistics, or use stored procedures to work with the individual websites usage data as collected already. My idea is the latter is probably easier, whereby we create a new stored procedure for this Usage Billing which is coded to specific plans or customer types. Rodopi is fairly extensible in the sense that we could add a reseller account type to Rodopi which can then allow Rodopi to be integrated with other applications and software. For example, you can add a single field to the existing Customers table to signify whether or not that customer is a reseller. You then build a whole resellers application using the CustomerID from the Rodopi database linking the two without affecting future upgrades unless Rodopi dramatically change the customers table. For what it's worth I know I can come up with a solution for anything you want to do with Rodopi that it currently does not do. This is because we can use the Rodopi database alongside additional databases which can all contain our own logic and code. In addition you can modify Rodopi's stored procedures which whilst not recommended can allow you to overcome any limitation. The only real issue is that taking things too far will break the possibility off upgrading Rodopi. Regards, Suneel. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Hokenson Sent: Tuesday, May 03, 2005 6:34 PM To: [email protected] Subject: [Rodopi] Two Plan Issues Hi, We've been scratching our head on how to bill customers for two different items..... 1. 800 # Useage We have a toll-free number attached to our PRI modem pool, that points at a specific inbounnd number, so identifying it by NUMBER CALLED is not a problem. What we need is an example of the scripting that will bill the dial-in user 15 cents a minutes for the toll-free useage. 2. Resale Website Traffic This may have been brought up before, but we resell web space to a number of web designers. What we would like to be able to do is rather than bill for bandwidth overage per each website, be able to add all the bandwidth togehter and only bill a surcharge when the aggrewgate bandwidth exceeds the cap. Example: If the client has 15 websites and each is allowed 500 MB per month, the aggreagte total would be 7500 MB, and if the TOTAL bandwidth consumed by ALL the websites combined exceeded 7500 MB, then his account would be subjected to bandwidth charges. How can this be done? Thanks in advance for any help anyone can offer. John Hokenson Virtual Networking Services, Inc. Vircom.Net --------------------- To Leave the Rodopi mail list send a message to [EMAIL PROTECTED] with the word LEAVE as the message body. Please also visit the Rodopi FAQ at http://www.rodopi-faq.com --------------------- --------------------- To Leave the Rodopi mail list send a message to [EMAIL PROTECTED] with the word LEAVE as the message body. Please also visit the Rodopi FAQ at http://www.rodopi-faq.com ---------------------
