Delphi Estimating Database APP Modify Existing Code

No Need to write a new application just get the existing code working. 1. Figure out a solution for the database relations for makeing and retriebeing estimates. Carry over the EstimateID from the the estimate to the Customer database and copy all the info from the customer and estimate tabe to the wrokorder. You will have to impament the work orders table . 1.b Work Orders are differnt from the estimates.? 2. ? 2 types of estimates. Hale or Repair Dents.? 2.a you have to do the math on the hale form. ? I have done the math on the dent form it just has to be sent into the database.? 3, Supplements. Once you make an estimate and are done with it youi need to (Lock Estimate). Onece you lock it if you open it again then any lineitems or changes to any of the existing line items will be marked witht a (S1) S1:= Supplment 1.? 4. Images: I need a way to join images to each estimate. I do not want to add them to the database itself just point to each image in the code that matches the estimate . 5. Quick Books. ? A simple Quick Books to export? [login to view URL] Form. Here you will enter in your Shop Name Addrss etc used for printing estimates, invoices. Work ORder 7. Invoice. Print a Invoice (BILL) for the completed work order. " Report Builder).? 8. Online Vin Decode. ? post the vin number to [login to view URL] via indy http and get the proper Year, Make, Model etc. ? get the info from the returned webpage and populate my year make model Style/Body and engine to the correct edits on the New Form. ? a VIN Number To Test With ? ? (KNDJA7231V5547306) . 9. Find Customers and there records. A input box here to find customers and all there estimates , invoices, workorders. 10. Add Your Own Body Pannels: The ability to edit the bodypanes and there images in the treeview and save and load them. 11. Hale Matrix. I will attach a copy of the Hale Matrix . The hale matrix must be added in the database.? 12. VIEW. Under view I do a FUll View and Regular view help me get the form to go to Full Line Item View and Back To Regular View . 13. Print Estimates, Work Orders, Invoices.? 14. CPI:= Cost Per Inch.? ## Deliverables I am working on a estimating application I have allot done on it. I need someone to help me with figuring out the database relations and some other things . 1. Figure out a solution for the database relations for makeing and retriebeing estimates. Carry over the EstimateID from the the estimate to the Customer database and copy all the info from the customer and estimate tabe to the wrokorder. You will have to impament the work orders table . 1.b Work Orders are differnt from the estimates. I will be using Report Builder to do my printing so I wish you to use adoQuerys, Dataset. So I can hook up my report builder to them. Work orders will be printed with customer info , estimate info and A place for the customer to sighn and date to authorize the work to be done. Once a work order is completed there needs to be a way to mark the job as completed . This will be used to caculate your business you have done for the year for tax purpose. 2. ? 2 types of estimates. Hale or Repair Dents. When you choose new you will have to choose a Hale or Dent Work. If it is Hale it will it will go to the the hale form if its Dent work it goes to the dent repair form. 2.a you have to do the math on the hale form. ? I have done the math on the dent form it just has to be sent into the database.? 3, Supplements. Once you make an estimate and are done with it youi need to (Lock Estimate). Onece you lock it if you open it again then any lineitems or changes to any of the existing line items will be marked witht a (S1) S1:= Supplment 1. Once you do the S1 and lock it , if you open that estimate up again then any line items you change to the estimate or nes line items will get a S2 . S2:= Supplment 2 etc for all the imes you open it after it has been locked. But locking ther estimate is optional I may NOT want to lock the estimate. SO if I do not lock the estimate then I can open it up as usual and make cnanges and no S1, S2 etc will be added. 4. Images: I need a way to join images to each estimate. I do not want to add them to the database itself just point to each image in the code that matches the estimate . The Images form needs to have a way to show thumbnails of the big images . This way I can see lots of thumnails and double click on on and then a full view of that image. Close that image and still able to see all the thumbnails. 5. Quick Books. ? A simple Quick Books to export the Completed job to quick books. Here I need you to Comment in detal so I can add or modify to it. [login to view URL] Form. Here you will enter in your Shop Name Addrss etc used for printing estimates, invoices. Work ORder 7. Invoice. Print a Invoice (BILL) for the completed work order. " Report Builder).? 8. Online Vin Decode. ? post the vin number to [login to view URL] via indy http and get the proper Year, Make, Model etc. ? get the info from the returned webpage and populate my year make model Style/Body and engine to the correct edits on the New Form. ? a VIN Number To Test With ? ? (KNDJA7231V5547306) . 9. Find Customers and there records. A input box here to find customers and all there estimates , invoices, workorders. 10. Add Your Own Body Pannels: The ability to edit the bodypanes and there images in the treeview and save and load them. 11. Hale Matrix. I will attach a copy of the Hale Matrix . The hale matrix must be added in the database. And a form to change the values of the info in the data base. The hale matrix will be used on hte Hale form to make estimates for hale. I have started to add it in the database. Look Cloose at the hale matrix pdf. There are some options we have to account for on eacvh pannel. (Hood, Roof, Doors), etc. 12. VIEW. Under view I do a FUll View and Regular view help me get the form to go to Full Line Item View and Back To Regular View . 13. Print Estimates, Work Orders, Invoices. You just need to do a quck example with Report Builder. It does not matter how you lay it out in Report Builder as I will most likely change it. Just examples so you can hook up Report builder to your code work. 14. CPI:= Cost Per Inch.? var ? ? sum, cpi : Single; ? ? l,w,d : Single; ? ? ListItem: TListItem; ? begin ? ? ? l := strtofloat([login to view URL]); ? ? ? w := strtofloat([login to view URL]); ? ? ? d := strtofloat([login to view URL]); ? ? ? sum := (2*l*w) + (2*w*d) + (2*l*d); [login to view URL]:='$' + (floattostr(sum* strtoint([login to view URL]))); This is the math to do Dent Work on the dent repair form . THe CSI([login to view URL] ? is on the setup form and it must stay there. Please look at the source code and [login to view URL] . Please do us both a favor if you do not understand about database realations with estimates, and work orders and users do not bid. If you just have questons please ask before you bid. I will be more that happy to answer all your questions. I will give you 7 days to do this project only if you agree to post here on rac at the end of each day your work. This is for me to make sure we are on the same page and you do not code up stuff that is wronge or not needed. This will save us both time and problems.