I have a database, that is mostly done. I just need some touch ups to the database.
I will give you the entire Front End and Back End.
I need this done in 12 hours, that's the deadline, please bid by saying : I understand deadline is 12 hours.
I need alot of Data Integrity checks removed, it needs to be free flowing. Obvious things that are phone numbers etc should be numerals only. Really obvious stuff, but, if there's something that may have mix, just leave it in Text.
1) All Phone numbers should not be auto formatted, if I typed the phone number : 0414 444 444, then I want it shown that way, I don't want it broken up into 04 14 44 4444 or what ever. Also, please remove all Length checks, we get all sorts of numbers.
2) Remove the "Tick" from "Contact/Autos"
3) Auto Select / default "Contact Type" to Customer.
4) Remove Check in City and auto add if new city, I don't want the "Are you sure you want to add this" message box. to be clear, I like the auto fill thing, but, if it's a new city, then, just add it, don't prompt me about it.
5) Remove the "^" from all the Notes fields.
6) Make the vehicle year have no max length.
7) Make the "Make and Model and Colour" auto add, no "Are you sure you want to add this" similar to (4)
8) Remove "extention" from Phone numbers. If this breaks stuff, just hide it.
9) When you click on "Repairs / Invoices" the tab dissappears. Please stop that. Make it stay there.
10) Red writing next to Odometer. Please fix that. or remove it, I'm not sure what its suppose to be.
11) The Vehicle is the year model. Please make it the Registration. I am referring to when you create an invoice it puts the year model in the Vehicle tab, it should be the rego.
12) If it's too hard, skip this one, I don't need "Labour Costs", but, if removing this will break other stuff, then, ignore it, I can live with it.
13) The Invoices doesn't seem to auto-save, I seem to have to do it manually (save)
14) Please go though this and check all features are working. I couln't really test, as it wasn't working well.
15) Payments seems to be working, please test, but, should be good.
16) The entire thing doens't seem to Auto-Refresh, Can you please add this, so, all changes appear on the screen.
17) Please improve the search feature, if you run out of time, It's working enough that I can get you to work on it later.
If you don't read these steps, I won't reply to you.