Web Interface, User Control Panel and Payment Integration

We run a VPN business with OPENVPN as a platform and wish to enable a user control panel and instant account/key generation upon payment. System would also record collections.

System requirements

We actually do have some existing code to work with which were uncompleted and you may either use this code or start from scratch.

Description:

1. This system will provide a GUI to the customers of our company to submit/renew/register/review their account information and process payment via payment gateway provider Netbuilder Sdn Bhd. The gateway is able to process payment using FPX/MEPS, Credit and various other vendors.

2. The system will record the user information such as username, name, address, email address, amount paid, validity (duration/expiry) and other necessary information.

3. System will provide a dashboard/control panel to registered user to view their information

System requirements

1. Must be web-enabled

2. All data must be kept in MySQL and allows manual override when necessary

3. The PHP scripts must be able to integrate with the payment gateway API (this is completed)

4. In the event of failure by payment gateway, the administrator may process the payment and registration manually via sql forms

5. The following are the User Record that will be submitted by the user during registration:

a. Username

b. Full Name

c. Primary Email Address

d. Alternative email address (O)

e. Service Category

f. Category Package:

g. Amount Paid (this will be determined by the Category/Package selection)

6. The following are additional User records that will be provided by the system once the payment is successful:

a. Expiry Date

i. Expiry date is calculated based on the current expiry date PLUS the new renewal period.

b. Date/Time Paid

c. Amount paid

7. System will email to the successful user their new digital certificate and other configuration files with also a link to their configuration files which they can

8. System reporting;

a. Daily Collection (RM)

b. MTD Collection (RM)

c. YTD Collection (RM)

d. Daily new registration

e. Daily Submission (New and Renewal)

TECHNICAL REQUIREMENT AND SPECIFICATIONS

1. API

a. Payment Gateway API provided by Netbuilders

b. Digital Certificate Processing provided by bolehVPN – Appendix 1 (will be provided)

i. This is in the form of DOS Scripting Language currently. May need to be re-coded to use on Linux systems.

2. Email Server provided by our own SMTP

3. User Dashboard/Control Panel Information

a. User profile

b. Service profile

c. Payment Profile

d. Support Requests

e. User Inbox

f. Re-download of Configuration Files

4. Administrator Dashboard Information

a. Subscribers Summary

i. Total Active Subscribers

ii. Total New Subscribers for the Day

iii. Total Collection for the Day

iv. Total Collection for the Month

v. Total Collection for the Year

vi. Total Collection By Month/year

vii. Total Collection by Year

b. Administrator Processing

i. Revocation/Cancellation of User

ii. Support Inbox

1. Ability to reply to support request and send to user inbox

iii. Outbox

1. Mass / targeted renewal reminders

a. Auto sent renewal notice a week before expiry

iv. Manual Renewal Records

1. Should have same input fields as new/renewal registration info

2. Bypass payment gateway but must provide payment information in the forms of attachment or descriptive

3. Able to update all the records once manual processing is completed

Linux MySQL PHP Interface do usuário / AI

ID do Projeto: #599813

Sobre o projeto