-------------------------- | AssetTrackDB Change Log | -------------------------- 1.0.0.18 (R18) -Minor visual improvements -Added Purchase Date as an option on Quick Searches and Multi-Layer Searches -Added Multiple pages to Manage People Page -People can now have ID numbers -People can now be edited (Name, ID) -Added purchase date to Quick and Multi-Layer searches -Add option to change user password from Prefs page -Fixed a bug preventing bulk update actions on assets with spaces in serial numbers -People are no longer deleted, they are disabled/hidden and information is retained for tracking info -Quick and Multi-Layer now have the option to search for CO user -Note this does not have to be exact, IE: adding a CO User quick search for "18" will find all assets that are checked out to users with 18 in their name -Fixed and issue preventing saving settings under Setup > Settings -Bar Code (AKA Asset Tags) can now contain letters 1.0.0.17 (R17) -Fixed issue that prevented custom visual settings from being reset unless custom visuals where enabled -Bulk check out now gives option to check out to one person or multiple at the same time -Fixed issue with custom visuals being overwritten on login page after update 1.0.0.16 (R16) -Fixed an issue with php errors being displayed (only showed if php was set to to display errors -Added reset custom to default button on Setup > Visuals -Small changes to Setup > Site Access to make it easier to read -Fixed issue causing menu to (slightly) change position on some pages -Menu now underlines the name of the current page -Fixed a bug where searches with certain characters would cause a MySQL error -Fixed issue with site access logs not sorting correctly -Fixed issue preventing site users from being deleted if only one admin user remained. Note: Last admin user cannot be deleted -Delete Confirmation now required before site users are deleted -Logo text is no longer an image -Added Logo Text Color option on Setup > Visuals 1.0.0.15 (R15) -Added ability to restore database from backup (See Setup > Backup) -Non-Admin users can no longer access: Setup > (Site Access, Visuals, Asset Export, CICO Import, Asset Import, Settings, Update) -Fixed issue preventing Checkout Info from being displayed on display.php for read only users -Fixed an issue causing Custom2 fields drill down incorrectly on the asset_list page -Added device info to confirm asset delete page -Added confirm to bulk asset delete -Files that are no longer needed with be deleted when update is run (add_asset_e.php, add_image_e.php, menu.html, report.csv, search.php, searches.php, siteaccess_a.php, siteaccess_d.php) -Database backup is no longer stored on the server it is piped directly for download, old AssetTrackDB_backup.sql file is removed by update -Site access logs now ordered by date, time -Bad Username/Password now displayed on login page when incorrect login info supplied -MySQL Error info now displayed on login page (after one login or asset check attempt) -Overhauled site user management (Setup > Site Access) 1.0.0.14 (R14) -Bulk Image added, allow one image to be applied to multiple assets -Added PDF format for image upload -If ImageMagick is installed jpg thumbnail generated -Fixed issue where copying some assets would fail -Added ability to import asset check in / check outs. See Setup > CICO Import. -Added ability to adjust some visual elements (header, buttons). See Setup > Visuals -Added Changelog button under Setup -Added ability to view tracking based on asset bar code / asset tag -Fixed an issue preventing apostrophes from being used in tracking condition out and condition in 1.0.0.13 (R13) -Updated to use MySQLi -Minor Cosmetic Improvements -Minor Bug Fixes -Start implementation of Federal Grant tracking (nothing visual yet) -Diagnostics page now shows PHP filesize upload limit 1.0.0.12 (R12) -Mobile (lots of small improvements, after image upload, etc.) -Fixed issue allowing duplicate asset names, duplicate name/serial now rejected more friendly -Date searches added -Adding Quick, Multi-Layer, and Date searches now accessible from clicking their respective headings on the home page -Physical Location quick searches (example: Physical Location Quick search for "West" would find all assets that are located in a building with "west" in the name, West Elem, West High School, etc) -Asset import no longer allows serial, bar_code, or name to have leading or trailing spaces which cause problems -Retiring or disposing an asset will now properly set the Updated By and Last Updated Time -Bulk Asset actions overhauled -No longer possible to bulk Delete, Retire, or Dispose of an asset that is currently checked out -Search bar will now remove leading zeros (Useful for barcode scanners) -Checking out an asset now defaults to blank room, forcing user to select room number and kicking back if not selected -Added the option to add a new room when checking out an asset -Fixed issue with using apostrophe in asset details (mostly used in notes, but all fields fixed) 1.0.0.11 (R11) 07-11-2014 -Fixed formatting issues with CSV reports that occurred under certain conditions -Added cancel button on asset import confirm page. -Added last edited timestamp on each asset -Prefs page updated to add Update By and Update Time to asset_list page. -Added recently modified assets table on Home Screen -Mobile (lots of small improvements done to make mobile access on the site much easier) 1.0.0.10 (R10) 05-30-2014 -Fixed update check to not query the available version at assettrackdb.com if update check is disabled -Added buttons on Asset and Track view pages to adjust the font size of the table -Assets can now to set to a physical location (Building). -Fixed an issue causing Multi-Layer searches not to work -Setup script now checks to make sure PHP5, MySQL, and Apache 2 are installed. Setup will stop if -Setup script now has a default database name -Expanded the amount of characters that form can have -From the view tracking page "Form" and "User" are now clickable to sort the view tracking page (much like how the Assets page works) -Current name also clickable to bring up the asset view/edit page for that asset -Track Page now has option to view tracking by building -Rooms add / edit page has been redesigned, and should be much easier to manage for installs with many rooms / buildings -No longer possible to create a new building or rename a building to a (building) name that already exists -Asset import now shows a preview of the results; confirm button at the bottom of the page completes the import -Asset import results are now clickable (links to asset edit/view page) -Updating a person’s name now updates tracking info for that user -No longer possible to create a new person or rename a person to a (person) name that already exists -Copy button added to asset page -Submit and copy added to add asset page -Changed prefs page to have column settings list in alphabetical order. -Fixed an issue that caused the csv report on the asset page to sometimes format incorrectly 1.0.0.9 (R9) 04-02-2014 -Fixed speed issues when searching for assets -Fixed issue causing backup link to not work on under some conditions -Changed layout of site access logs page -Fixed site access logs report -Viewing disposed assets will no longer show "checkout" section -Added brand to stats page -Changing results per page while viewing retired / disposed assets will no longer switch results back to main assets -Fixed issue on manage images page that prevented some links from working correctly -Changed the link to download the import template to make it more visible -Removed View from menu -Fixed some issues with changing results per page or next page not working properly -If there is only one building in the system that building will now automatically be selected on the tracking page -All building will now show "Building" as a room option on checkout -Minor cosmetic changes -Added global option to disable checking for updates in Setup > Settings 1.0.0.8 (R8) -Added ability to sort asset list by CO Room -Search function now returns results for: CO User, CO Room, Building -Site will now check for default username/password and warn user -Added Multi-Page support to tracking view -Replaced csv download link with icon 1.0.0.7(R7) -Fixed a few typos -Tracking page will no longer lose the currently selected asset when changing the building -Support for rooms with spaces -Users can no longer be deleted if they have assets checked out 1.0.0.6(R6) -Auto Complete Menus replace most drop down menus -User Login / Logout logged, log accessible from Setup > Site Access Logs, with downloadable csv report -CSV reports are now given unique names based on the current user -No longer possible to delete the last admin, or "remove admin" from the last admin -Reduced Menu Size -Checkout info now displayed on view/edit asset screen (display.php) -Stats page is now "clickable" to show all assets with that "stat" -Manage People page now has ability to import csv of people -Added ability to add multiple rooms to a building (semicolon separated) -Added ability to import CSV of users -Fixed issue preventing backup from working properly -Track Page: Building / Room selection now separate, after building is selected page will refresh and only show room numbers for that building -Button color fixed on newer versions or IE -Database Update needed message will now display on all pages if a database update is needed -Files that are no longer needed with be delete when index.php is loaded -Some IE bugs fixed (mostly just missing buttons on older versions) 1.0.0.5(R5) -Unified (some) Colors -Favicon Added -Asset List page now has option to show CO (Checked Out) User -Custom1, Custom2, and product key now searched when using the search function -Fixed blank page issue when deleting / modifying a user -Bulk Update now has drop down menus to select existing values -Bulk Update now has the ability to create a new user when updating -“Most” user input now trimmed to remove leading or trailing spaces -Removed need for add_asset_e.php -Admin users can now delete assets from the disposed table —Index page no longer shows table border lines when nothing is in the table row -Various visual changes Database Changes: -Added co_user to member_prefs (Needed to enable viewing CO User on Asset List page) 1.0.0.4(R4) -Tracking page will now check for invalid date (length, characters) 1.0.0.3 -Much easier setup script for first time setup (Thanks Craig!) -Bugs fixed that prevented redirection on some pages due to changes in the menu system -Added Settings page (admin access only) to show and eventually allow updating of (some) config.php settings -Added Diagnostics page (under setup) to check for optional add-ins -Eliminated add_image_e.php. Delete image processing is now processed by d_images.php -Now only Admin users can delete assets -Images can now be deleted from the View/Edit Asset page -View/Edit Asset page will now show a button for View Warranty when viewing a Dell asset, this button goes to the Dell warranty page for that asset. Other vendors to follow. 1.0.0.2 -Changed bulk.php file to no longer display the Update fields when using bulk delete, retire, dispose -Display Asset page will no longer display text fields for RO users and disposed assets, these are switched to elements so RO users don’t get the impression that they can edit these fields -Disposed page now shows the age of then asset when it was disposed, not the age that the asset is when the page is viewed -Added Stats page -Added Help page 1.0.0.1 (R3a) -Fixed bug preventing serial number from being updated -Images are no longer orphaned when an asset is deleted -No longer allow open access to upload folder 1.0.0.0 (R3) -Added ability to bulk check out/in assets -Added Asset Import function -Moved: Bulk Delete, Bulk Dispose, Bulk Retire to Asset page. -Bulk Actions changed to Bulk Update on Asset page. -Improved the Update system to prevent running database update when it’s unnecessary 0.9.9.9 (R2) -Fixed a bug that prevented assets from being checked in -Changed Menu to save space 0.9.9.8 (R1) -Asset can no longer be checked out without selecting a user or entering a new user -Check Out and Check In asset now both have a space to record condition of the asset 0.9.9.7 -Added Custom1 and Custom2 fields 0.9.9.6 -Updated "Successfully Checked Out Asset" page to include details, useful for printing a record for the user (if needed). -Read only users will now be denied access buttons, pages, and links that they don't need access to. 0.9.9.5 -Added "Admin" option for site users -Added option to Update Password, Make Admin, Remove Admin, Make Read Only, and Remove Read Only. -Non-Admin users cannot modify other users, can only change their own password. -Changed Bulk Update option to be one button that updates all selected assets in field is not empty. -Renamed Asset List menu button to Assets -Various cosmetic changes -View Asset Page now allow search by Name, Bar Code, and Serial -Added "Asset Checker" on login page to check if a asset is in the database without logging in. -Fixed bug that prevented user from going to page 2+ when viewing retired assets 0.9.9.4 -Quick Searches (custom.php) no longer processing through custom_p.php and custom_e.php -Multi-Layer searches (mls.php) no longer processing through custom_p.php and mls_e.php -Removed: custom_p.php, custom_e.php, mls_e.php no longer needed -Added notification when adding Multi-Layer and Quick Searches. -Display.php now shows notification when asset is updated. 0.9.9.3 -Removed need for add_user_e.php -Added ability to modify stored People, Buildings, Rooms 0.9.9.2 -Added bulk operations -Changed multi-user import to semicolon delimiter -Added ability to delete multiple images at a time 0.9.9.1 -Eliminated need for add_room.php and add_room_e.php 0.9.8.9 -Uploaded Images will now resize to 1024x768 (approximately, depending on original image aspect ratio) if ImageMagick is installed on the system -Added Backup page under Setup to allow easy download of database. 0.9.8.8 -Updated Add Asset page to include field descriptions 0.9.8.7 -Changed Track page layout to separate Check In / Check Out 0.9.8.6 -User Passwords are now secure 0.9.8.5 -Add Report.csv option at the bottom of Track View page -Misc bug fixes, now all forms should not allow invalid data -DB Change: add con3 to multisearch table 0.9.8.4 -Add Report.csv option at the bottom of asset_list page -Added global variable in config.php for install / upload location to facilitate alternate install locations -Misc Bug Fixes 0.9.8.3 -Add Multi-Page support for delete image page 0.9.8.2 -Added support for Internet Explorer -Multiple bug fixes 0.9.8.1 -Fixed and issue that cause Asset List Page to display incorrectly under certain conditions 0.9.8 -Fixed and issue causing three layer searches to display incorrect results 0.9.7 -Changed Edit asset screen to use drop down for owner selection -Removed the ability for edit asset to update an asset and leave a blank serial or name -Add the ability to create and delete users -Updated setup page layout -Fixed an issue causing some multi-layer searches to fail (caused an sql error) -Added the ability to delete multi-layer searches -Added the ability to sort asset_list by: created by, vendor, funding, and cost -Merge asset_list and retired_asset_list to be just asset_list -Tracking View pages now show Building -Fixed issue causing assets not to retire -Move Results preference to be a user pref and not a global pref -Added READ ONLY access -Added ability to add / delete buildings -Added CO Building to asset List, added co building as an option to turn on/off on the preferences page -Tracking page now lists Building and Room number for the location selection -Tracker table now records room number AND building of tracked asset -DB Changes: -Added co_building to member_prefs -Added ID to room table, room number no longer required to be unique (Different buildings may have same room numbers) -Added building ID to tracker table -Added RO to members for Read Only Access 0.9.6 -Added: Cost, Funding, Vendor, Created By, Creation Time, Updated By, Updated Time to the asset table to facilitate the "tracking" of who created and who last updated the asset. -Updated Prefs page to account for the new database fields -Updated the Add asset page to accommodate the new fields 0.9.5 -Added Prefs page, allows user to set which columns to display on asset_list.php 0.9.4 -Added Product Key field to add asset page / database. -Added code to asset_list to facilitate turning columns off and on (coming soon!) 0.9.3 -Added login page / logout button -Added Search bar (Results 'LIKE' for any data in the asset (main) table.) 0.9.2 -Added Multi-Layer Searches NOTE: Changing Results Per Page while looking at results for a Multi-Layer Search will cause the search to clear. 0.9.1 -Added Footer with version number -Added changelog link to footer -Added 'All' as an option for results per page -Expanded tracker table to include device name *Tracker tables will now show the current device name, and the device name when checked out. *Example: Device purchased, named, checked out. Over the years its been checked in and out and the name has changed, so now on the tracking view you can see the 'current' name of the device and 'former' names of the device when they were checked out. 0.9.0 -Added multiple pages to Asset List 0.8.9 -Added Recently Tracked Assets to Home