I need somebody to use the stylesheets and look of our current website to create a customer "my account page".
This would be a password protected page (credentials are in MySQL) . Once authorized, it will allow user to perform the following operations:
1.) See his payment history (we already have a table in place for this) , and his account balance (this is per service)
2.) Add more funds to his account (through Paypal) -- if his account type is prepaid, or pay his balance if his account is Postpaid (this info -- if user is Prepaid or Postpaid -- is kept in mysql table and is not modifiable by enduser)
3.) Add more IP addresses to his account (we have a mysql table for this)
4.) Suspend his service (we have a table for that) -- do not give option to reactivate service
5.) Browse/See through his CDR (Call Detail Records) -- we have a table that contains the list of calls he has done along with call date/hour , duration , cost of the call, etc . Please note that the Search should allow the user to search through this records using extensive filters (such as -- call duration > whatever seconds and call date > 2008-10-....)
Also, I need (as a subsection of the CDR interface) the ability to see the amount of minutes per day, with history per days (a graph showing usage would be nice, be it flash or just a png/jpg/gif file generated from the records in the mysql table)
6.) Export all calls , or just result of the search he just performed (I prefer export as csv)
As a side-note, the CDR interface would look nice if written in extjs, but still integrate with the look and feel of our webpage. If you do not have this skill (extjs), that's fine, as long as your work (code) is easy to read and work with.
7.) Possibility for the account holder to add/delete/edit sub-accounts and grant them access to any of the sections defined above.
8.) Logging -- log in the database the customer logins, IP address where they logged in from, time they logged in at, and the modify/update/delete actions they performed (i don't care about the search/view/ actions, just the actions that have potential to modify something in the account). Also, all financial transactions should be recorded in the mysql table specified at 1.) -- along with IP address, username that has performed that specific action, date/time, amounts added, etc.
I need somebody who can write clean code, easy to understand, with function/structure names called in plain english and code comments also in plain english. (i don't like seeing base_de_donne_connection instead of database_connection)
My best regards