"Project Management Software "
We are after a PHP / MYSQL module installed on a server with full documentation , our budget is $400 our budjet is $450 terms and conditions apply see below before applying.
As a company we have staff all over the world and need better ways to assist management of technical personal on projects , so this is simple software project 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.
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 EXCEL applications now workings into PHP MY SQL tables
2 - Add a user level systems , with password access , verified Email addressing etc..
restrictions as below
All the above and add / delete / managers / providers / jobs from the lists
A system admin can suspend a Manager and their providers ( not delete ) any time they want , this just suspends their user access
He can also re allocate a Manager , or shift a project to a new manager
NOTE - any removal becomes inactive but not removed ever. If a project is not updated for more than 60 day it will automatically become inactive. ( not removed - just not viewable )
Manager - ( Project owner )
Can view , edit , add , and adjust provider jobs for their own work only and
add and edit new jobs for any provider associated as their Providers
add / remove providers and tasks
Provider - ( programmer / designer )
Can view , edit , add , and adjust jobs for their own work - but can never delete an entry
NOTE - entries are transaction based ## see below
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 --
- project name
- Priority levels
- over due Items
- Requested by
etc as per field in the spread sheet .
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 extended prices
In general however it will sort default as 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 there will need to be a Change / Add button .
### For each and every change see AUTO MAIL
Note - managers and systems administrators , can turn off a displaying record , grayed out or 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 . You will need show "all task" to view
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
9) Auto Mail
The php software , will send mail to a mail address of the provider if the manager has changed a record
This will be done after the USER has logged out , so as to minimize the sending
Separate message per project .
detailed of the records changed and a time stamp will be included in the email.
The PHP software will send mail to the manager if the provider has created any changes
Separate message per project
detailed of the records changed will be included in the email.
YOU WILL BE REQUIRED TO
a) submit written document of the application / concept with the tables and relationships being used within 24 hours of accepting
b) Build the project on your own web server for us to access and test
c) produce a help file of how to use the project
d) Transfer all the task list ( excel pages we supply ) to your server for us to view and test . Day 12
e) Complete the installation on a web server of our choice , with full PHP code hand over Day 14
f) Ensure all php code is fully documented
Payment will be 30% upon completion of a,b,c,
30% upon completion of d) tested and working
40% upon installation on the web server of our choice with full documentation and source
IMPORTANT TERMS AND CONDITIONS
This project will only be paid over pay pal
Time line required in - 14 days form start .
you will be paid 100% if delivered on or before the specified date , so please specify accurate date you can start
You will be paid 20% bonus if completed in 10 days
You will loose 20% if longer then 20 days
You are required to email / be in contact ever second day , if you are not we reserve the right to cancel the project and re award it
We have to assume that what we write is not clear enough , while we understand , if you do not it is your responsibility to ask
BONUS WORK to be offered is "the selected" programmer is successful and all task completed the work on time
You will be offered extra work to add to this at the following fixed amounts ..
Xoops Interface adaptation $50
Xoops Graphical Interface to suit our needs $70
Install a ticketing system EXPO_PHP_DESK into Xoops $70
Add a Quick project creations tool for the administrator $50
Add a Monthly auto debit PayPal , systems interface $70
Further work to be agreed upon