Profuturus Inventory Tracking System Joshua Watt, 2006 TO DO: * Comment Code * Write Help Documentation * Write an API for the plugins * Redo options_list class (rename too) * DEBUG statments * Add ability to lock views, lists, validators, and editing of records * Class everying to simplify formatting using CSS * Make it look pretty * Use DIV's instead of tables (?) * Write Authentication System * Write Code to be more HTML Coder Friendly :) (?) * Make search export handle Long text fields better. * Add javascript niceties. 11-1-2006 * Added javascript functions to disable unified search fields when they receive focus. * Allowed Access Database Drive to have spaces in field names (yay) * Fixed bug that didn't display unified search field data in the search results. * Fixed bug that caused search queries with *just* a unified search to return all items 10-31-2006 * Happy Halloween * Fixed bug that failed searches when a field that no longer exists was displayed in the search page 10-30-2006 * Added jsfunc.js file to hold javascript helper functions. * Made javascript functions to disable search fields when doing a unified search. 10-27-2006 * Finished delimiter character replacement * Added maxlength parameter to input fields that corresponds to database field lengths. * Made input validator class check for input lengths agaist the database. 10-25-2006 * Worked on replacing delimiter chars in input... need to finish * Abstracted search types from strings to database::DB_SEARCH_ objects 10-16-2006 * Fixed database driver bug that caused unified searches to error out with a blank unified string 10-10-2006 * Added Unified Search option * Made database function search_inventory() take a query string instead of arrays of query parameters. * Added reserved symbol replacement in query strings. 10-3-2006 * Added Database function get_version() * More help documentation 10-2-2006 * Worked on Help Documentation * Fixed bug that caused dates to reset to unix epoch when editing inventory items * Made modifying views more strict on their drop down boxes to help prevent confusion. 9-29-2006 * Fixed bug with quotes in input fields 9-28-2006 * Added set_multiple() function to inventory_item class to make database transactions more efficent. * Fixed bug that prevented the copying of Inventory Items 9-27-2006 * Added finished MySQL Driver Version 0.4.4 9-15-2006 * Fixed Bug that prevented the copying of inventory columns Version 0.4.3 8-1-2006 * Extended Database interface to include functions to check text input (validate_input) and table/column names (validate_name) * Fixed bug with access_database driver and renaming columns. Version 0.4 7-28-2006 * Database fully abstracted, database drivers must implement the database interface * setup.php rewritten * Database types abstracted... DB_TYPE_BLOB exists, but is hidden. 7-11-2006 * Almost finished fully abstracting the database 6-22-2006 * Fixed bug with default dates * Made item edit cause an invalid input if a field has a double or single quote. Version 0.3 6-21-2006 * Finished setup.php script * added user_auth.php script to determine the username of the person logged in 6-20-2006 * Added Link in Help to the GPL 6-16-2006 * More commenting * Moved PATH define to the defines.php file. Files now use relative path to get to defines.php which declares the absolute PATH for use 6-15-2006 * Fixed bug in search_database that didn't correctly implement upper_limit and lower_limit if upper_limit was not a multiple of (upper_limit - lower_limit) * COMMENTED! Version 0.2 6-15-2006 * Added Previous and Next buttons to singleview.php that allow for cycling through search results. 6-14-2006 * Added option to track the default number of search results. * Added option to choose a different view for the Search Results when searching. * changed order of Modify View and Modify Lists columns, View/Field name is now first (left), and control buttons are at the end (right) * Documented CSS Classes in "css_descriptions.txt" in the "help" folder * Added text file export feature * Changed search to only automatically jump to singleview.php when the single result is on the first page. 6-13-2006 * Move SQL Search code into a helper function * Added ability to copy records. * CSS-classed table elements to allow for formatting * Added code to interpret and create Search Query Strings * Made singleview.php carry generated search query over and allow return to search results Version 0.1 6-12-2006 * Fixed several bugs pertaining to the searching and input/output formatting of BIT fields, mostly stemming from Access storing "Yes" as -1 (0b11111111 I'm guessing) * Added Title Box with my name and Version Number under the navigation bar. * Added help link to above the plugin panel. Doesn't link anywhere (yet) * Fixed modview.php to terminate its so that the plugins panel showed * Fixed bug that caused a fatal SQL error when entering a blank DOUBLE type * Made new_inventory_item() delete database entry on fatal error during record creation. 6-12-2006 - Version ? Finished with primary development phase. Change Log started.