A rather simple example of implementing a customer billing system.
- The Database
-
- Simple schema
- Users
- UserName
- RealName
- PhoneNumber
- BillingPlan
- AccountBalance
- Hours
- BillingPlans
- Name
- BaseRate
- BaseHours
- HourlyRate
- History
- UID
- Date
- Transaction
- Amount
- The Database API
-
Perl module implementing simple database interaction operations.
- Login
- Logout
- AddUser
- GetUserInfo
- ModifyUser
- DeleteUser
- AddBillingPlan
- ModifyBillingPlan
- ChangeBillingPlanName
- DeleteBillingPlan
- ApplyCredit
- ApplyDebit
- Log
- User Management Scripts
- A couple of command-line scripts to add, display, and delete users.
- User Management GUI
- A CGI script to add, display, and delete users.
- RADIUS Accounting File Parser
- A Perl module to parse RADIUS accounting files.
- Billing Script
- A script to send email bills to users.