HTML and PHP (and mySQL?) script to track customer orders and associate orders with materials. Script must read from material file (and others) and write to log files and send email quote to customer. Script should be able to copy and edit record from historical file. I suspect the best way is to use a mySQL database. Please use PHP so we can make minor edits as necessary. Some details follow: Fields are: project number (auto) date (auto) customer (from text file) project title ink finished size (from text file or drop-down list) press size (from text file or drop-down list) quantity on press sheet quantity out from parent material (from text file) preliminary material quantity (calculated) material quantity order quantity order price quote quantity1 quote price1 quote price/M1 quote quantity2 quote price2 quote price/M2 quote quantity3 quote price3 quote price/M3 quote quantity4 quote price4 quote price/M4 quote quantity5 quote price5 quote price/M5 press (from text file or drop-down list) stock status samples packaging labeling Actions: print & email data as work order print & email data as quote write order quantity & material to file (with date & project number) write all data to file as history
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables):
a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software? installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
PHP