Solved

Which script is best for this scenario?

Posted on 2011-03-14
2
241 Views
Last Modified: 2012-05-11
In work we have a telesales office taking orders for various products. One product we supply is car paint. The paint is mixed per order, comes in various materials and sizes. We have a separate area dedicated to mixing paint orders in another part of the building, currently, we invoice paint orders out to the customer and write on slips of paper what they require, we then drop them into the paint mixing room.

I'd like to have some electronic way of doing it. It has to be web based (to fit in with our intranet) it also has to offer a front end which has an easily customisable form. It has to store the paint orders in a database and assign them a status which can be changed by users accordingly, for example "In queue", "Mixing in progress", or "Complete". When a sales agent completes the order form, it will be placed in a queue and I'd like the option of having it automatically printing in the paint mixing room.

Previous and current orders can be checked by running reports.

Is there any script that nearly does this that can be changed a little. I was thinking along the lines of a IT support script. Any recommendations?
0
Comment
Question by:nickedwards
2 Comments
 
LVL 110

Accepted Solution

by:
Ray Paseur earned 500 total points
ID: 35137420
Make a Google search for "php workflow management" and you will find some suggestions.  The design patterns are pretty well understood and you're probably looking at no more than three tables and a small handful of views.   I haven't dug into the detail, but at first glance Tony Marston's page looks like it might be promising.

Over time you might want to integrate the order flow into inventory management.  Just a thought...
0
 
LVL 1

Author Closing Comment

by:nickedwards
ID: 35312458
The answer wasn't a complete solution. It was more a way of finding out more information.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Row insertion failed. Array 5 60
How do I show metrics with PHP or Javascript 6 46
Generate PDF from MySQL using PHP 3 52
Google Dork query 7 56
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Many old projects have bad code, but the budget doesn't exist to rewrite the codebase. You can update this code to be safer by introducing contemporary input validation, sanitation, and safer database queries.
The viewer will learn how to count occurrences of each item in an array.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

680 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question