Update Log for Car Dealer Inventory App 1.0.3

03-29 2300 Add a legend for the camera and magnifying glass icon at the top of the inventory.cfm page.
03-29 1600 Added a column to the inventory.cfm page and put an magnifying glass icon, that is linked to the p.cfm detail page, to the right of each one-liner vehicle.
03-27 2230 Optimized the inventory.cfm file with 130 vehicles from 76.6KB down to 53.3KB. This was done by changing the CSS to one charactor id's & class's, changing the /image fold to /i, changing the pcardetail.cfm file name to p.cfm, renaming the graphic file(s) to one charactor names, and using a utility to strip all comments, line feeds and white space out of the file. The p.cfm page optimized from 15.9KB down to 12KB and the CSS file was optimized from 10.9KB to 8.54. Both these files were only comments, line feed & white space optimized.
03-26 2200 Set pcardetail.cfm page so that "Total Price For Vehicle" & "Monthy Payments For Vehicle" display sections can be turned on or off in the application.cfm file. This gives the car dealer a choice between displaying the total price of the vehicle showing taxes and fees & also showing what each vehicle payments would be if financed.
03-25 1830 Removed space between milage number and km so the km will not wrap.
03-25 1240 Added login link to pcardetail.cfm code. This link passes the current vehicle record to the cardetail.cfm backend admin page so that you can edit that record.
03-24 1220 Setup querys for the total number of each different vehicle type in the database. Add the number of each vehicle type to the search buttons on the inventory.cfm page.
03-24 0230 Move loan rates, fee rates, tax rates, tax names etc. out of pcardetail.cfm and put in application.cfm as variables. These can now be easily changed.
03-23 2300 Added field for fees in the pcardetail.cfm page. Included fees in the monthly payment calulations. Removed the Photo column header to make for more room on the inventory.cfm page. Page was looking to crowded.
03-23 2000 Column sorting on inventory page would loose vehicle type select and show all vehicles with applied sort. Changed code to retain vehicle type selection on any column sorts.
03-23 1500 Setup routine in pcardetail.cfm that sets the default query sting to the first record in the database so that pcardetail.cfm will not error out when it is accessed with out a query string.
03-22 2300 Speed tested the inventory.cfm page with 45 vehicles one-liners 50 times and got loading speed of between .22 and .892 seconds for an average of 0.26 seconds. The pcardetail.cfm page was tested 45 times, each time with a different record from its online database. The fastest load was 0.34 seconds with the longest being 2.213 seconds of an average of 0.50 seconds.
03-21 0200 Fine tune the 3 sql querys on the pcardetail page so there is no redundance of vehicles being displayed.
03-19 18:00 Changed the Vehicle Style field from drop down to text field. Lengthened Picture field so the file name can be viewed after file selection. Added Comments field to db, admin backend and pcardetail page. Changed transmission dropdown menu contents to just automatic & standard.
03-19 0100 Add an additional group called specials to the 'vehicle type' field. Add a specials button to the inventory page. You can now move the vehicles you have on special into the specials group and then they can all be view with the search button called 'specials'.
03-18 2300 Add function in application.cfm so that vehicle picture upload variable will point to local drive when testing on development system.
03-18 2200 Change the vehicle add form caredit.cfm so that after adding a vehicle, upon return to cardetail.cfm the vehicle that was just added (last record in the database) will display.
03-18 1800 Removed hot link from Year & Model in inventory.cfm. This increases customer focus on the Make which is what you want them to see first.
03-18 1600 Setup global variables such as upload file directory etc. in application.cfm. This moves all site-specific setting out of the IA code and makes updates seamless. Now all you do is just replace the IA files and keep the application.cfm settings the same. No more editing IA files for site-specific settings.
03-17 1200 Move all site-specific html out of the inventory.cfm and pcardetail.cfm files into the footer, header & menu files. These files are then attached by cfinclude. This will make it easier for updating the Inventory App as the inventory.cfm and pcardetail.cfm files are now the same on all sites.