Em Andamento

private project - Shadow

"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

System administrator

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 --

- Manager

- project name

- Provider

- 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.


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


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

Habilidades: Segurança na rede

Ver mais: written jobs, world web designer, world designer jobs, work line jobs, working hours job, would monthly payment, what levels, second shift, website designer tool, web find job programmer, web designer outlook, web designer job outlook, web designer job application, web designer entry level, want excel spread sheet, user interface designer jobs, table jobs, turn website application, tool designer jobs, tool designer job, time paypal payment clear, ticketing tool, right staff, test jobs, test complete jobs

Acerca do Empregador:
( 32 comentários ) melbourne, China

ID do Projeto: #174856

1 freelancer está ofertando em média $400 para este trabalho


Hi,please check PMB for details. Regards, Shadow

$400 USD in 10 dias
(1 Comentário)