I have an existing web based app with some items that need to be repaired and modified. The site used PHP and MySQL and is hosted on my own server.
## Deliverables
1. Estimates
1. Main Tab
1. "Generate Estimate" link not working.
1. Please see example estimate form.
2. Add link to print "Right to Lien" document
3. Data consists of:
1. Customer information
2. Project details
3. Project total cost= total material + total labor
2. "Update Project File" change to a window that will allow the upload of multiple files rather than a zip file.
2. Materials
1. Add two additional subcategory items
2. "Price" should come from field "cost" in table "invent"
3. "Original Price" should come from field "cost price" in table "invent"
4. Change "Original Price" to "Cost"
5. "Total" box for each row should be calculated automatically (price * quantity)
6. Create new box "Total Material" (row total sum)
3. Labor
1. Change "Labur" to "Labor"
2. Remove exiting items on page
3. Show the following boxes:
1. "Calculated Time"
2. "Additional Time"
3. "Total Time"
4. "Labor Rate"
5. "Total Labor"
1. Calculate automatically (total time * labor rate)
<!-- -->
1. Work Orders
1. Main Tab
1. "Update Project File" change to a window that will allow the upload of multiple files rather than a zip file.
2. Material
1. Same as materials in estimates but do not show cost
2. Add check box for billing
3. Labor
1. Use database located in Php Timeclock directory
2. Calculate total time for each row
3. Add box and calculate time for all rows
4. See sketch
2. Inventory
1. Show "Part Number" from table "invent"
2. Do not show "Part No"
3. Schedule
1. Redirect to an existing Zimbra Calendar page
4. Point of Sale
1. Create a page for point of sale that is the same as materials for work orders without the "bill" check box
2. User needs to be able to generate an invoice from this page
5. Work Order Billing
1. Invoice should be created utilizing the invoice template.
1. There are two work order billing algorithms:
1. Bill to Date
1. The user will be able to select time and materials to bill using the "bill" check boxes next to time and material items. Once an entry has been billed it should still be shown but the user will be unable to select it again for billing.
2. Bill Bid Percentage
1. The user will be able to select a percentage or total dollar amount for the bid to bill. Time and material data will not appear on the customer invoice. The user will not be able to exceed 100% or the total dollar amount of the bid.