Solved

Which script is best for this scenario?

Posted on 2011-03-14
2
242 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Technology Partners: 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

Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
This article discusses four methods for overlaying images in a container on a web page
The viewer will learn how to count occurrences of each item in an array.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

737 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