There are 2 tables: user and admin
User table will have have Email, First Name, Last Name, Password, Credit Card Number,
Expiration Date, Street Number, Security Code, Plan #s, Amount, Plan Expiration Date, Phone Number, ICCID, Network, Account #, Account Password, Notice, and PIN.
Admin table will have Email, Password, Exclude List.
User Interface consists of all those fields in the user table. If the user is “porting” or transferring a number from another network, ask for Account #, and Account Password from the other network first. If they do not have the information, do not continue. Once the user clicks on the submit button, the system saves the information and send an email to the admin. Another email will be sent to the user to confirm.
Admin interface consists of 2 tabs. Second tab allows the admin to change password, edit Exclude List, and also send email to all users, excluding those in the Exclude List. First tab will have a list of all users with different sorts order allowed. Default sort is user with credit information and then plan expiration date. Once the admin changes the plan expiration date of a user, upon confirmation from the admin, the system will save the new expiration date and clear all credit card related information and Notice field. An email will also be sent to the user. Everytime when an admin logs in, the system will check all users with expiration date that is within 5 days of the current date and the Notice field is empty. If true, an notifcation email will be sent to the user and save “5 day notice sent” to the Notice field.. Also, it will check all users with expiration date that is within 2 days of the current date and Notice field has “5 day notice sent”. If true, an notification email will be sent to the user and save “2 day notice sent” to the Notice field. The admin can also select individual user to email with free format.