Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Which script is best for this scenario?

Posted on 2011-03-14
2
Medium Priority
?
253 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 111

Accepted Solution

by:
Ray Paseur earned 1500 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

There are times when I have encountered the need to decompress a response from a PHP request. This is how it's done, but you must have control of the request and you can set the Accept-Encoding header.
Originally, this post was published on Monitis Blog, you can check it here . In business circles, we sometimes hear that today is the “age of the customer.” And so it is. Thanks to the enormous advances over the past few years in consumer techno…
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
Suggested Courses

564 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