Changes & Additions to Car Dealer Inventory App 1.0.6

Minor updates are made available at the end of each 2 month period. During those two months all changes are recorded in the below updates log. Your first year of updates is free. After that updates are $99 per year.

Update Log for 1.1.0

Update Log for 1.0.11

11-01 2200 Added the make, model, vehicle type into the URL. In the process of installing sesConverter by Fusium so that
.php?ID=216&For-Sale-Used=Car&Buick&Century
will become
.php/ID/216/for-sale-used/car/buick/century.html

Update Log for 1.0.10

10-02 2200 Added variable in application.php that enables the change of both your inventory and details file names.
10-04 2200 Changed the file includes structure so that the Inventory App code is included into your site template instead of the site template being added into Inventory App via header and footer files.
10-06 2200 Added code to place the vehicle make, mode type into the title of each page. Also moved the make model into h1 tags on the detail page.

Update Log for 1.0.6

06-07 2200 Set selected search button on inventory.php to show different color.
06-05 2200 Changed inventory.php page icons & search buttons to be transparent.

Update Log for 1.0.4

04-21 0100 Set focus to first field in login.cfm & caredit.cfm ; Add Model field & change Stock No. & Year query from > to >= in backend search page.
04-20 1000 Set sorted column in inventory.cfm page to bolded text & add legend item to note the same.
04-17 0100 Process varchar variables passed from URL though cfcase so that no varchar variable go directly into the SQL statement. All interger varables passed from the URL are cfqueryparam'ed with a maxlength="5".
04-15 1100 cfqueryparam all variables in the SQL statements which strip out all characters other than a-zA-Z0-9 using cfsqltype="cf_sql_integer" and strips all characters other than 0-9 using cfsqltype="cf_sql_integer". Also use the maxlength="" attibute to limit the length of the number variables in the SQL statements down to 5 charactors. Useing the cfsqltype and maxlength attributes in the cfqueryparam wrapper will stop SQL injections like "; xp_cmdshell 'format c: /q /yes '; drop database myDB; --" and other injections into variables that are passed via the URL to the SQL statements.
04-10-1700 Limit records displayed in p.cfm to 39 based on running total of Model, Make, ± $2000.
04-09 2300 Place in all pages message announcing browser doesn't support CSS properly. Wrap message in div with ID that has attibute display:none; in CSS. Hide Media="Screen" & Media="Print" CSS files from NS4.x & IE4.x . Both NS4.x & IE4.x now display content only along with browser message.
04-09 1210 Change Mileage to Odometer on all pages.
04-07 0945 Change login.cfm to refresh on invalid username or password.
04-06 1600 Validate Car Dealer Inventory APP for XHTML 1.0 Strict.
04-06 0200 Setup an MouseOver on the vehicle rows in inventory.cfm.
04-04 1740 Set menu seach buttons on inventory.cfm page to not show if there are no items in that group.

Update Log for 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.