I am looking to build a simple MySQL + PHP + Apache driven quote entry system with email and simple reporting capabilities.
The system is broken down into 3 parts
Quote Entry System
1. Enter customer information (including deadline for quote)
2. Enter vendor information ( determines who gets the email)
3. Enter 1 or more line items whcih consist of some drop downs (fixed value) fields, and some text fields.
4. Store data in db w/ datestamp
5. Email this info to fixed email address(es) for recipients of quotes (based on vendor record)
Notes: Entries can be modified at a later time and update email sent. Needs login/pw (simple user account system to determine who initied the quote). Quote status can be changed at any time.
Automated Reminder System
1. Check daily for status of each quote, and given time span parameters, email reminder to vendor & person creating the quote
1. Simple reports showing status of all quotes (open quote report, closed report, aging report)