I need to have an integrated account subscription management tool for both user and admin (SMS website).
I have it so that once someone subscribes, that a user account is created in my mysql DB. What I need now is for the table creation and web pages for user and admin management of the accounts.
Subscriptions contain credits (two types). msg_credits, key_credits that will add to or verify to the account each subscription period (monthly, or from trial to paid). msg_credits get added to the account, key_credits are verified as the correct number.
The account should be able to show the account properties (what type of plan (show plan details), then remaining and available credits for use and keys for use). The user and admin should be able to upgrade or downgrade the PLAN, add FEATURES to the PLAN, or add ONE-TIME charges.
For example: PLAN A = 1,000 credits 2 keys
User subscribes and pays through SubscriptionBridge
(EXISTS) - account is created, with user and provisioning
Need to look up table of plan details (PLAN A) and create the account details (dates, details, amounts, etc). Add 1,000 credits, add 2 keys (since it is new).
During the daily operation, there will be a table that has all of the usage for the month (billing period range which must be provided) - or some type of int: x++ coutner in the table.
Upon subscription renewal/change/etc (notice from Subscription Bridge by XML) the account must be updated: credits added, keys verified or added and new renewal dates set for counter.
Within the user account, the user must be able to change the subscription if available (meaning they can't downgrade to a 2 key plan if they have 5 keys in their account in use)
User must be able to buy (through the [url removed, login to view] API) additional credits, upgrade features (keys) that will be charged for and added to the account immediately.
User must have access to log of transactions (charges, daily count of use, additions (features, renewals, one-times).
Typical updates from [url removed, login to view] such as: status = unpaid, balance due, payment declined, etc should update the account.
I'm sure there is more to this - but please see [url removed, login to view] for their API information (free) and you can register for many of the online SMS services to see how account subscription managment works for keys (keywords and credits).
It's basically a refill account subscription and then update/change capabilities.
I WOULD LIKE ALL CHANGES TO HAPPEN FROM WITHIN THE USER INTERFACE IF POSSIBLE (except I don't want to hold the credit card info - that should stay at [url removed, login to view]).
PLEASE ASK QUESTIONS TO BE SURE YOU UNDERSTAND THE DETAILS!
All of the account user interface should fit within a <div> of approximately 400x850px area. I would prefer that it mostly update via ajax. Access control in live environment is controlled with username/password login by sessions.