We are after a PHP / MYSQL module to be called "TO DO LIST-PART 1"!
This is simple software that is run from a Web Server to emulate the program we have now use in EXCEL. The example attached will show you exactly the tables we need to use in MY SQL .
Note - While it only shows one staff member there are in fact unlimited staff , unlimited managers ( same as requested by) , and unlimited posters of projects.
Part 1 of the project is designed to assist our global work force to keep track with each other on the projects they are working together
You will be required to
1- Duplicate the applications workings in PHP MY SQL tables
2 - Add a user level systems , with password access
Provider
Can view , edit , add , and adjust jobs for their own work - but can never delete an entry
NOTE - entries are transaction based ## see below
Manager
Can view , edit , add , and adjust jobs for their own work and
add and edit new jobs for any provider associated as their Providers
add a provider to their list
System administrator
All the above and add / delete / managers , providers , jobs from the lists
NOTE - any removal becomes inactive but not removed ever.
3) - Upon entry to the systems the user will see their immediate job list , if a manager they will see all the jobs under their providers
if an administrator , they will all the jobs under all the providers . It will display as per 4)
4) Provide a sorting functions for all USERS , but include the limitations of the above 3 user categories
Sort by --
- Provider
- project name
- Priority levels
- over due projects
- Manager
- Requested by
etc
Sorting is an SQL query , with multiple selection , and will report in a table form. You may select to as you would in Outlook what field you want the sort in. Future sort functions will be added later at entended prices
In general however it will sort default by Provider , project name , and priority as shown above
5) Following a sort a User can then access any item in the list and edit or append to this item.
## it is important that every change is a time transaction based record , and the old changes never disappear , they are just grayed out but still visible and the new one is show above it . Obviously ther will need to be a Change / Add button
Note - managers and systems administrators , can turn off a displaying record , greyed outor fully displayed , this is done by a feature only accessible to them to enable them to cancel the task
NOTE - it will not delete the record , just make it invisible .
6) Printing of the above reports as shown in 4 , plus the following
All tasks ( including invisible ) completed by Project then Provider
all outstanding task by priority then project or
by project then priority
many more - here separate work will be allocated .
7) "find text" function and show text by project then provider
8) back up database and recover
You will be required to
a) Build the project on your web server for us to access - Stage 1
b) Transfer the task list ( excel pages we supply ) to the server - Stage 2
c) Complete an installation on a web server of our choice , with full PHP code hand over
Payment will be 30% upon completion of stage 1 - aproval of design
30% upon completion of stage 2 - full testing here
40% upon installation on the web server of our choice.
Then hand over of code ... will occur ..
You will be offered extra work to add to this the the maximum amounts ..
Part 2 - Xoops Interface adaption $100
Part 3 - Customer Fault Reports and logging ( ticketing / tracking ) $150
Part 4 - Graphical Interface to suit our needs $100