Solved

Which script is best for this scenario?

Posted on 2011-03-14
2
235 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
Comment Utility
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
Comment Utility
The answer wasn't a complete solution. It was more a way of finding out more information.
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Introduction Got endorsements from your clients?  Great!  There is almost nothing better than word-of-mouth advertising.  But how can you do that on the internet?  Sure you can make a page for endorsement quotations and list them all, but who is …
Introduction A frequently asked question goes something like this:  "I am running a long process in the background and I want to alert my client when the process finishes.  How can I send a message to the browser?"  Unfortunately, the short answer …
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
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 …

771 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