Facebook application (and possible future port to separate iPhone & Android app).
We require a facebook app which can allow the facebook user to enter a number of fields which will update our existing backend PHP/MySQL/Joomla and also push out an entry to the user's Facebook Wall.
A Date (from a standard date picker)
A Work Category (from a drop down list of about 10 categories - controlled/editable by the administrator in the MySQL DB - The admin DB update already exists)
A Category Description (this is a read-only short description associated to the Category chosen above - controlled/editable by the administrator) NOTE: Each Category has a minimum percentage associated to it e.g. Reporting, minimum percentage = 15%, this is set by the administrator and held in the MySQL DB - admin DB update already exists. The min percentage is used by reporting (see below).
An Action Description (short text the user inputs - about 100 characters)
A Number (representing the hours spent on the category - float e.g. 1.5)
A submit button - the submit button updates our database and also adds the Action Description to the user's facebook wall (this may be extended to push out to LinkedIn in the future).
The user can submit as many times as they like. The percentages report (below) is to be updated/recalculated each time.
Below the user form (described above) x2 small reports are shown. The targets to meet (i.e. the min percentage of time the user should be spending on each category is set my the adminstrator. The admin MySQL DB function already exists).
1. A list of all possible categories and the percentage of time the user has spent on each category and a coloured marker to show achievement (red=poor, yellow=about ok, green=exceeded) - this is over the current week (Monday-Sunday).
2. A list of all possible categories and the percentage of time the user has spent on each category and a coloured marker to show achievement (red=poor, yellow=about ok, green=great) - this is over life the user has been using the app.
(See attachment for high level idea - fonts, colours, etc to be optimised for Facebook layout).