Solved

Which script is best for this scenario?

Posted on 2011-03-14
2
237 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 108

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Introduction HyperText Transfer Protocol (http://www.ietf.org/rfc/rfc2616.txt) or "HTTP" is the underpinning of internet communication.  As a teacher of web development I have heard many questions, mostly from my younger students who have come to t…
This article discusses four methods for overlaying images in a container on a web page
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

867 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now