Automated cron job that notifies when a client's hosting package is due for renewal. There will be a database that contains the specifics of all of the hosting packages and a second database that contains the client information that includes the date of service and a field that relates to the hosting packages specifying type of package they have.
1 PHP script to run as a cron job, that tracks client host package expiration date and triggers html formatted emails at specified date intervals, alerting them to pay bill before expiration. [1 month out, 2 weeks out, 1 week out, 1 day out, 1 day past due, weekly past due]
2 Create page on MMM Creative website that dynamically displays data from the host package table. Similar to: [url removed, login to view]
3 Create page for internal use, that queries client table for client records, and provides update functionality for each record. This would be primarily be geared to allowing the update of the expiration date of a client account upon payment by the client and would automatically manage the email expiration notices (as they would be turned off upon updating to the new expiration date).
1 MMM Creative will create and manage databases via PHP MyAdmin. (Database containing client information, type of package,date of expiration 'plus' Database containing attributes of web hosting packages)
2 MMM Creative will create html email notifications.