Job Flow Tracking System
I have a request for a programmer that can create a software for me in php with a mysql database.
The software will track a job from the time it is created and take that job through the following stages
1. ACTIVE (time the job is created)
2. QUOTATION
3. APPROVAL or Not Approved
4. DESIGNING
5. PROOFING
6. PRODUCTION
7. PAYMENT / Closure (time the job is completed)
The system will have two user interfaces
1. user (can add clients, can add jobs to system)
2. admin (can add clients, can add users, jobs, edit fields to system)
The system will have a dashboard that will show the number of jobs in each job flow stage (see 7 stages above).
The dashboard will show data across columns and organized by:
1. Today
2. Yesterday
3. This week
4. Last week
5. This month
6. Last month
7. Last three months
8. Last six months
9. This year
10. Last Year
The Seven Stages
1. ACTIVE (time the job is created)
(This is any job that is assigned to a client on the system. The condition for a job being active is that it is not closed and also that it is not yet paid)
2. QUOTATION
(This is the transition step for a job that is active. The active job can be transfered into the quotation phase. The quotation phase is a time for a quotation to be prepared and submitted for approvals.. the outcome of the quotation phase is an approved job or not approved job)
3. APPROVAL or Not Approved
This is the outcome of the quotation phase.
4. DESIGNING
The approved job can transition to the designing stage whereby graphic designers create some samples for proofing.
5. PROOFING
The proofing stage is the transitional step from designing it is when a customer accepts the design or asks for more graphic design work. The outcome of proofing is an approved design.
6. PRODUCTION
Approved designs go the production phase.
The outcome of the production phase is a job ready to be picked up and paid for.
7. PAYMENT (time the job is completed)
This is the outcome of production and the reason for the job.
What is a client record?
Very simple
A Client record is defined by the fields
1. Client Name (First name or Last name)
2. Client Company Name
3. Client Location
What is a job record?
A job record is comprised of a few things.
It is a place whereby a client is married to certain products and servives.
A list of services will be provided to winning bidder.
A job record will contain all seven stages for that job.
This system introduction should be enough details for the right programmer to bid.
Thank you..
May the best programmer win


