MTBF (Make, Test, Break, Fix) History

06-01
- Again, too many last minute tweaks found during full installation run-through.
- Tested installation on Windows XP, Windows 7, OS X Leopard (10.5)
- Condensed Route/Search Map into fewer files
- added export of status, manufacturer, operator
- WIN: Import path error
- Added DEMO period time expired popup

05-31
- Mac & Win application packages created, awaiting final MTBF in the morning
- Support files syncronized across platforms
- EmptyDB updated to reflect recent changes
- Fixed: Export CSV/GPS not creating GPS file
- Fixed: coinCount NULL causing new loc to not be included in route
- Fixed: WIN: Open vendsure data folder not working
- Documented routine for WIN import for handbase
- Fixed: AddLoc not being included in route upon creation

05-30
- service & serviceproduct re-combined (SQLite speed)
- import routine adjusted for: XAMPP
- cURL routine now internal instead of PHP based, still requires cURL for Windows (OS X built-in)

05-28
- Adjusted support table cols for area
- Cleaned up DB connection code
- change 'status' to 'mstatus' in tbls importHH, machine

05-27
- Researched/Made PostgreSQL & SQLite versions of VendSure for testing purposes.
NOTE: A PostgreSQL implementation will be forthcoming.  Changes in place, just not implemented.
- rename tbl 'status' to 'statuscode'
- rename tbl 'serviceProd' to 'serviceproduct'
- Fixed: editing support table doesn't exist; Happening on only 1 of the test machines

05-26
- Added XAMPP/Lite to AMP list, changed buttons to DropDown
- Updated Icon for OSX/Win
- Updated installation info
- Tested installations on Windows and OS X
- Changed GE icon
- Fixed: Add loc/mch/srv not adding to blank db after recent changes
- Fixed: addloc: service push defaults to 0000-00-00
- Broke: the previously fixed anomalous error
- Fixed: hide model on editMachine (not in use yet)
- Fixed: win: tasks/maint: disabled when bring up Prefs
- Changed'product' in emptydb.sql from BLANK to UNASSIGNED
- Change install documentation: mention not to hit SVC in xampp
- Fixed: 'Route Date' was not adding 'Place' status to route

05-25
- Changed auto_num field usage

05-24
- Update edit machine/service
- Fixed product table update from EditService
- Added versioning levels

05-23
- Added Area Abbreviation
- Changed machProd to serviceProd, makes more sense
- Fixed: anomalous error #184
- Adjusted Import routine
- Fixed: support tables not being seen from change to engine

05-21
- Logo and Icon created

05-20
- Updated: check for updates
- DONE check import/export routine
- DONE check addloc/addmch/addsrv (Adjusted routines for consistency)
- DONE check adjust edit machine/service

05-19
- Changed mySQL engine from myISAM to InnoDB
- Added uniqueID's to machine & service for editing reference
- Updated sql statements to match
- DONE - check reports/maps
- TODO check adjust addloc/addmch/addsrv
- TODO check adjust edit machine/service
- TODO check import/export routine

05-18
- A simple OS X installer written
- Changed document folder names
- Fixed: now forcing mysql character collation & character set on intial db creation and 
backup/restore

05-17
- Added field definitions to all fields
- Removed outdated field 'area' from location table

05-16
- servDate/servDateNext now set to current date upon creating new serv records
- added coin fields for each canister of a machine into db, but not implemented yet

05-15
- Fixed: location servPeriod not being passed when creating a new service record
- Split the service table into service/machProd to seperate products, will allow for easier
handling of more then 3 heads
- renamed table fromHDB to importHH
- Adjusted all related queries and reports, ugh!
- Status of 1,2,3 (operating, place, pull) are all included in route/map, etc

05-13
- Converted the DB from _latin1 to utf8_unicode_ci
- Updated status table and all relevant routines including maps/reports

05-11
- Win: Table hilite bar text defaults to white, changed hilite color
- Win: Fixed initial db creation issue
- Verified sn implementation
- Excess/out-dated code removed from Vendsure

05-10
- Webpage created to generate DEMO keys
- 'route.php' report made for printout/use if handheld not available

05-09
- Reg Key generation re-vamped & implemented in VendSure
- Demo key generation can now be handled from the web (just need to make the page)

05-04
- Removed cbNote/cbServiced from service table
- Adjusted all relating sql
- Adjusted appropriate reports
- Fixed empty value reported for route removal due to changes

05-03
- servNotes are now appended to the locations flagNotes instead of a new insert
- 'Add Loc' seeks to the newly created loc after creation
- Added 'Flag Notes' button to main UI
- Fixed 'Add Loc/Mach/Srv' routine not working when called remotely
- Fixed 'Add Srv' only adding to subLoc 1

04-24
- removed search: 'not serviced', 'note records' provides same result

04-21
- change backup filenaming back to 24hr format
- Completely rewrote the table handlers for tblMachines & tblServRecords
- Added a table for the product info
- Removed excess info in the Machine/Service tables to neaten it up, less visual clutter
- fixed new tables not clearing on 'clear'
- fixed tab order on main screen

04-19a
- Lat/Lon fields removed from 'Add Loc'

04-19
- 'vendsure_EmptyDB.sql' is now loaded from App path during Vendsure DB initialization
- Lat/Lon & Address Map Icons removed from 'Add Loc'

04-18
- Route is now cleared then auto generated after selecting a route date
- Moved Backup/Restore to Maint Menu

04-14
- Changed demo launch to 30, was 14

04-13
- Added a 'product' button to UI to go to the product needed report
- Report: 'route products'/'by search' can calculate product required now
- 'find' now updates cbSearch in location table, was only being updated by 'map'

04-12
- Fixed servDateNext calcs in sqlUpdLoc & sqlUpdServ
- Fixed typo in sqlUpdServ routine for servDateNext

03-31
- Fixed: product export, wrong field order being exported
- MAP: printing issue resolved, sidebar disabled
- changed products.csv export to product.csv

03-30
- 'Create Initial DB' routine done, uses 'vendsure_00_EmptyDB.sql' for default data
- Made button 'opID' default to Unassigned' if no 'operators' are set
- Added improved error checking to the backup/restore routine
- Updated 'Auto' route gen sql statements
- Fixed on 'sqlCloseDB' scrollbar movement raising an error
- 'Backup/Restore' only show filename now instead of full path
- Backup file naming changed to 'vendsure_YYMMDD_xHHMMSS' x = Am/Pm

03-28
- Fixed: initial highlight of service table
- Fixed: Calculate service push in the 'service next' search
- 'Auto' replaced date next calc with servDateNext field
- Fixed servDateNext search to include servPush, chk loc 170 for auto
- SQL: Update machine set heads = 3 where heads = 0;

03-27e
- Fixed 'Add Mach' so that it will add a new record even if none exist

03-27d
- Added 'check for update' to app

03-27c
- Added copyright info to top of code
- Forced scrollbar to 0 prior to closeDB to fix seek error

03-27b
- Map: Fixed maps so they report active machines only in the machine count
- Reports: Minor adjustsments to reflect recent changes
- Changed route 'export' to ONLY include machines that are: Operating, Hold, Pull

03-27a
- Added entry validatation to main screen
NOTE: still need to validate edit machine/service

03-27
- 'flush tables' added before restore, 'restore' should no longer fail randomly

03-26c
- Fixed: 'geocode' was missing the colon so couldn't retrieve lat/lon
- made sure launchcount has an initial value if no prefs file found

03-26b
- Edit 'Service/Machine' windows now close after save
- converted auto calc 'service next dates' back to actual field use
- servDateNext = current servDate IF the record is a note record so that it is still
included in the current/next route

03-26a
- Added vars to handle demo days/runtime
- Demo mode now shows how many launches remain

03-26
- Added 'operator' DD to 'vendsure - export' & 'importhdb'
- Fixed: 'support table' dd stays at last selected option BUT table defaults to products

03-25
- now deletes route/product/gps file BEFORE creating it, just in case
- removed file save prompt for 'export' & 'gps', added 'info' when saved
- search toggle added for 'lat/lon of 0' loc's
- Both Mac/Win versions are functional
- Win: App not always removing itself from memory on close fixed
- fix reg startup, also affects app not auto connecting to db
- Fixed numerous file path bugs that caused other misc issues
- implmented an automatic demo mode, app runs for limited time and has a counter to only
launch so many times

03-24d
- Changed 'Support Table' away from Query Builder
- Win: Fixed 'support tables' can't connect to db (deleted all qb refs)

03-24c
- Win: WinXP icon added
- Win: file-quit does not work, red x does

03-24b
- Fixed backup/restore Windows pathing

03-24
- Fixed a preference file/registration error leftover from the stack prefs

03-23b
- Added saving/reading an external preferences file
- Support windows should now center to the App

03-22b
- Serial Number registration implemented

03-22a
- 'Export' now also exports the product table for handheld

03-22
- Added 'area' table to the support tables for editing
- Removed Info window update from re-running find during a save

03-21a
- When records are saved in a find, the find is re-run and placed back at the
currentrecord to reflect changes
- 'Add to Route' does NOT re-run the find in case a record in a route is
accidently de-selected

03-21
- Changed db name from 'vending' to 'vendsure'
- Changed db name in the Vendsure app and supporting php files as well
- Rework of geocode, mapping and reports to segregate code for easier modification
The following files are located in the htdocs/vendsure dir:
connect.inc -contains db connection info
gmapkey.inc -contains the google map key
report.inc -contains the bulk of the report code

03-20
- Complete rewrite of Google mapping, now handle location bounds properly

03-11
- changed backup file naming from 'vending_' to 'vendsure_'

03-10a
- changed web interface dir from 'htdocs/vending' to 'htdocs/vendsure'
for the maps & reports

03-10
- Major change from 'area' to 'areaID' & 'areaNum' and area table support
Everything updated to reflect change EXCEPT reports
- Area handling changed in Search to use Area & AreaNum dropdowns
NOTE:Need to check ALL sql statements that use area and update
Need to Add DD's to Location edit
ALL DONE
- GPS Folder changed to '/Vendsure/GPS'

03-09
- Fixed Note record & push date conflict for adding loc to route

03-08
- Support table names & overrides implemented

03-07a
- changed app directories and automatic naming:
backup & restore to "Vendsure/Backups" format "col_" & Route Date & ".csv"
export & savegps to "Vendsure/Routes" format "gps_" & Route Date & ".csv"

03-07
- Fixed main window close button not being active.  Windows should quit properly now
- Added support table add new record

03-06
- latlon.php created, handles both GET & POST data
- Geocoding of address to lat/lon now works from within vendsure

03-05
- support table editing implemented, still need new record creation
- 'service push' added to Search
- Added 'reports' button

02-11
- servPush now cleared during import

02-04
- fixed typo in naming of search variable for the note records

01-03
- service note records now marked as NOT serviced upon import

-- End of 2008 builds, begin 2009 --

12-30
- Fixed accept icon for calendar
- 'Auto' button for route creation now performs a find at the end
- Date range added to Search

12-29
- Added popup calendar to the date fields for easier input
- Added routine to verify serice push dates are null'd if appropriate

12-28
- servPush now works: STILL need to handle removing push date during import
- Route fields now saved in preference file
- importHDB fields now saved in preference file

11-23
- Service calls no longer removed when clearing the route

11-11
- DB backup/restore feature added
Note:Currently hard-coded for servebox
Need preference pane handling for multiple mysql platforms

11-10
- Fixed typo "No chages were made" to "No changes were made"

11-09
- Fixed export including machines other than 'operating' & 'pull'
- If record is a note record, do NOT show servNext date
- Current servPeriod now exported to HDB and stored in service record
- cbFlag changed to cbService to denote 'Service Call' in HDB
- Service calls exported and noted in hdb
- 'Note Only' records now handled in HDB
Use:Enter note into Service Note field and check the Box next to it
Note only service records are NOT considered for route creation!
- When importing from HDB, service calls are now un-checked as appropriate
- Modified DB as follows to implement above changes

11-08
- Enter/Return in search fields activates the Search
- Clicking on a button in the search area activates the search
- Un-serviced records now deleted prior to import
- Imported records removed from Route
Does NOT account for if there are multiple machines at a site and a machine
was NOT done at a site. i.e.- Assumes ALL machines for a location are done
if they are being imported

11-07
- Hid Id and route in the machine and service gui tables

11-06
- Fixed quote escaping for single quotes
- Fixed tab order in windows

11-03
- Add create route from current search params
- Added MAP button for search results
- Fixed slide bar not showing proper first record after search on occasion
- Enter/Return defaults to SAVE button on EditMachine/EditService
- Fixed Not Serviced toggle not working properly
- Fixed old Search window popping up when Find results were 0

10-30
- New GUI
- Add service call checkbox to gui and to hdb
- Button to launch route map in browser
- If Coins is blank default to 0 before Auto
- Max Coins added

10-25
- Fixed add mach/srv rec not always showing
- Fixed add mach/srv rec showing bad data in fields
- Fixed pref pane not saving issue

10-21
- Auto gen route based on date and coin count
- have search change to ALL when route checkbox is selected
- prompt to clear route in case button accidentally hit

10-19
- add 'clear route' button

10-18
- added 'export' on main screen to export current route for HDB

10-13
- pop route filed with # of marked locs in route
- checkbox for include in route (cbroute)

10-07
- Fixed Prefs not being saved
- Fixed import hdb 'status' field not importing

10-06
! insert NEW records creation to gui
- fixed dateActive/Inactive defaulting to 0000-00-00, is now NULL
- insert seperate mach/serv
ISSUE:MFG = Operating" on subloc's > 1 ???
FIXED:MFG was defaulting to 0, changed to 1
- Add cut/copy/paste feature
- forced arrays to empty at startup
- machine/service table arrays now emptied when loc record changes

10-02
- Converted arrays to Rev3 style

10-01
- Fixed blank/missing table data in machine/service tables
Note:Table arrays weren't populate if db connection was not valid on start
- added preferences stack

09-23
- Add map button to show location via google maps

09-21
- Added 'status' table to db/pdb
- Fixed import/export from menu to popup as palette

09-10
- Fix for menu shrinking the stack: set the destroyWindow of stack "Vendsure" to true

09-09
- Fixed cr/lf's in database
- Fixed export not working

09-04
- Add gps file save to export routine
- Move cbRoute setting from export to load button in export
- Fix pull issue, ie- loc:176 pull by nov1, service till then,
maybe have the pulls print out along with the noteflag info

09-03
- Fixed machine/service tables not updating on next/previous buttons
- Adjust export/import routines for noteflag change

09-02
- Move noteFlag from location to machine table

09-01
- Change keyvend/cash to varchar

08-31
- Drop down handling for tables
- Weekly report written showing flag'd locations

08-28
- Export routine created