Simple Works Order System

Project Summary

My client wishes to convert a paper driven works order system into an easy to use electronic system.

I have recommended that they develop a basic web application in PHP and MySQL to allow them maximum flexibility in terms of hardware platforms (i.e. they can use PC or a tablet).

I intend to run the application on Apache with Linux to give the client flexibility to host the application locally in their office or remotely on rented hosting.

The system will be used to generate these four printed reports:

1. Works Order Form

2. Job Tickets

3. Test Certificates

4. Purchase Orders

a. Works Order Form

Creating the works order form will require data to be selected from these tables:

a1. customers

a2. usernames

a3. products

a4. raw materials

a5. suppliers

a6. purchase orders

a7. cast numbers

a8. test certificate numbers

b. Job Tickets

Job tickets are created from works orders.

Each product line on the works order form generates a separate job ticket.

Most of the data is drawn from the works order form.

Each line on the Job Ticket includes a bill of materials which is drawn from a table of raw materials.

c. Test Certificates

Test certificates are created from works orders.

Most of the data is drawn from the works order form.

Each line on the Test Certificate includes data about the Casting which is drawn from a table of Casting data.

d. Purchase Order Form

Creating the purcahse order form will require data to be selected from these tables:

d1. suppliers

d2. usernames

d3. products

System Specification

This is only an outline specification. Additional material will be made available that gives examples of all the existing forms, process maps, lists of data fields for the forms and some simple ideas for the on-screen view.

The system must allow the client to create a Works Order Form with a minimum amount of typing.

Where possible all fields will be completed by selecting stored data from lists. Drop down selection boxes are ok but type in selection fields (like google instant) would be better.

Where possible the system will automatically populate fields with related data.

This system will replace an existing process managed with MS Excel to create Test Certificates. The new system must be capable of importing data from the old system but only as a one off event.

Works Orders, Purchase Orders, Job Tickets and Test Certificates must all be generated as PDF documents that can be saved locally and must include the option to print to a user specified printer.

Access to the system must be secured using a simple username and password system.

Freelancer Selection

Due to the nature of this project and restrictions created by my public liability insurance I can only consider freelancers based in the UK.

Please quote a finished project cost.

Please request further details to make sure your quote is accurate.

Please provide at least 3 examples of previous work and references.

I will follow up your references.

Kemahiran: Apache, HTML, Linux, MySQL, PHP

Lihat lagi: insurance system, works freelancer, works for freelancers, works at freelancer, where is freelancer based in, web freelancers uk, web freelancers job linux, user test freelancer, uk linux freelancer, uk freelancer php job, uk e freelancer excel, uk based freelancers, typing job in uk, type of freelancer username, the view cast, system one freelancer, summary in freelancer, simple web application examples, references job application, purchase order form excel, project casting, php works at freelancer, php pdf freelancer, php freelancer works, php freelancer uk

Tentang Majikan:
( 13 ulasan ) Stourbridge, United Kingdom

ID Projek: #4031112