Benton School District TicketBook System Created and Maintained by Brian Lowrance (brian@bentonschools.org) All Rights Reserved LEGEND ----------------------------- + = New Feature Added - = Feature Removed % = Modified Feature * = Bug Fixed ----------------------------- [Version 2.17 - Version 2.19] + 3/07/2003 - Added Userlevel 444 for restricted (read-only) access.(User can only view/update it's own tickets.) [Version 2.20] + 3/11/2003 - Added "Change Password" option for all users. + 3/11/2003 - Added Open ticket notification to the top of the main menu when users log in. + 3/11/2003 - Added user notification during login of last unsuccessful login attempt. [Version 2.21] + 3/19/2003 - Added "EMAIL" feature to the view tickets page to indirectly initiate email conversations with the CONTACT person on the ticket [Version 2.22] + 5/6/2003 - Added "Modify Property Number" capability for Levels 0, 444, & 500 when updating a ticket. + 5/6/2003 - Added User notification of tickets being reopened or closed. [Version 2.23] + 5/15/2003 - Added "View Ticket Status" script for users to be able to view the status of their own ticket. A random view code is generated upon workorder submission. + 5/15/2003 - Added "Time in Hours" job time tracking. + 5/16/2003 - Added "Statistics" script. Keeps track of total tickets and total hours per location and per building. Finished 5/19/03. [Version 2.24] - 6/10/2003 - Removed old way of placing items on HOLD. (1st 4 letters of tech comments = "HOLD") + 6/10/2003 - Added OnHold, HoldReason, and HoldDate dbase fields. "Place ticket on HOLD" checkbox and Reason box. Modified corresponding scripts. % 6/10/2003 - Modified Ticket Status page for users, to use new HOLD format. If ticket is on HOLD, explain to user why. [Version 2.25] + 8/14/2003 - Added Search for Open tickets capability to Students (User level 0) [Version 2.26] + 8/20/2003 - {Thanks Brandon Polk for the idea and code.} Added html code to set focus on logon page to username field on load. Set main menu to set focus to Ticket# field on load. [Version 2.27] + 10/1/2003 - Added Keyword search feature to the admin search page. [Version 2.28] % 10/4/2003 - Modified Keyword search. * and spaces are wildcards. Default wildcard before and after keyword. * 10/8/2003 - School names were duplicating in the combo box on the update ticket page. Modified (used exit sub after each userlevel. Marked unneeded code for deletion. [Version 2.29] + 11/3/2003 - Added Contact email notification of activity on their ticket. % 11/4/2003 - All updates in Technotes field are date/time/user stamped and are permanent, You can add new data(that will also be stamped upon submittion), but noone can change old data. [Version 2.30] + 11/12/2003 - Added Unassigned status mark. Unassigned tickets, when assigned will add text to the tech notes area, "date - time, ticket assigned by " [Version 2.31] + 11/21/2003 - Added Opt out option for teachers. They can opt out of recv. updates other than the ticket being created, closed, or reopened. [Version 2.32] - 1/15/2004 - Removed Parts used field + 1/15/2004 - Added Order Parts feature. Tech checks box to order parts, enters parts in parts req field. A parts ticket email is generated and sent to ray via email. + 1/15/2004 - Added Parts table to database. Parts orders will receive order#'s. * 2/5/2004 - Identified by Nick Lamb. When a ticket is set to Restricted, only the main tech, and first helper can modify. I recoded to add all helper techs. [Version 2.33] - 2/26/2004 - Removed Open ticket notification at the top of the main menu when users log in + 2/26/2004 - Added techs assigned open tickets to the bottom of the main menu page, so they don't have to search. More convienant than #'s listed at the top of the page. + 2/26/2004 - Added Header Include file. (Shows last logon time) * 2/26/2004 - Made Logout text same color as other menu items. Also made Bold. [Version 2.34] + 2/27/2004 - Added unassigned open tickets list to the bottom of the main menu page for administrators. % 2/27/2004 - Modified Search result tables to alternate colors for easier reading [Version 2.35] + 3/5/2004 - Added Emergency ticket status to Online Workorder, This emails brians cell phone and marks the ticket as EMERGENCY also color codes in search box with RED background. + 3/5/2004 - TicketBook Admins can modify Emergency status. New Tickets can be ticked Emergency by any ticketbook user. + 3/5/2004 - Added "Ticket UnAssigned by:" line if ticket is being unassigned. This is to help cut down confusion when employees view their ticket status. * 3/5/2004 - Modified Open tickets list on main page color formula. Colors sometimes would alternate and sometimes not. Fixed. [Version 2.36] * 3/8/2004 - Added Error Control to automated emails to stop execution from halting on an email error. (Typo in email address or incorrect addy) * 3/8/2004 - When a ticket is canceled, it will write the cancelation reason/date/time in the tech comments section. Before it only wrote to a cancel_reason However when you viewed a ticket it could be very confusing the way that it read. + 3/8/2004 - Added ViewCode and Receive Updates fields to updates page. ADMINS can modify these fields now. [Version 2.37] * 4/22/04 - Whenever a new manual ticket is created, the notification email has been fixed to send all information to the contact person, such as the Viewcode (if one is not entered, it will be auto generated), ticket number, and problem listed. % 4/22/04 - Added to Notification system. When a ticket is updated, the bottom of the notification email to the contact will have the latest technicians comments appended. [Version 2.38] * 5/11/04 - Fixed unassigned ticket drops tech comments bug. See Ticket # 5085 [Version 2.39] + 8/19/04 - Added AD authentication capabilities. Attempts to login via AD, if fails, attempts TB Database. + 8/19/04 - Began AD password manager to allow domain pwd changes from Tbook admins (Not Students). [Version 2.40] + 9/13/04 - Added Description field to OpenTickets listing and Search results. Description field will show first 75 characters (in small font) of the problem reported. [Version 2.41] % 10/21/04 - Modified "On Hold" feature to write hold status and hold comment into techs comments area for storage. Will also write to tech comments area when a ticket is removed from hold status. [Version 2.42] % 11/18/04 - Ticketbook now loads in a "popup" style window after logon. Popup blocker will need to be disabled during login to allow this popup action to take place. This removes toolbars, addressbars, and browser menus to maximize useable screen space. [Version 2.43] % 1/11/05 - Added Last Serviced column to ticket tables (assigned tickets/searched tickets,etc..) [Version 2.44] * 1/17/05 - If the user was logged on to a desktop, and the session expired, the user had to login again so that the browser would close and allow them to reopen the browser and login again. Session now expires and makes the user close the browser without having to login again to do this. * 1/17/05 - The data on the "ViewStatus" page was illegible (the text was too light colored). Changed font to blue for the data. [Version 2.45] % 2/14/05 - Added search by Serial# and Keyword to non-admin search pages. [Version 2.46] % 2/16/05 - Modified Search and OpenTickets so that LOCKED tickets will not display a preview of the problem discussed unless the user is listed on the ticket or an administrator. [Version 2.47] + 3/11/05 - Added "Copy Ticket#:" feature to allow duplication of a ticket (ie: compose 1 new ticket, copy it and change the school name. Allows easier creation of same ticket for all 8 sites, etc...) % 5/3/05 - Changed References of Brian Smith to Brian Lowrance + 5/25/05 - Added "Contact Phone" field to Workorder submittion page. Contact phone info will be added to the problem descrip if contact phone data contains at least 3 characters. [Version 2.48] + 6/20/05 - Added alert email to IT@benton.dsc.k12.ar.us whenever a ticket is canceled by an end-user. + 6/20/05 - Update/Compose new ticket page will auto-fill in a blank date field with todays current date, upon loading. [Version 2.49] % 8/25/05 - Sorted listings on main menu page to show ON HOLD tickets sorted first, then show all open tickets. ORDER BY Onhold, Ticketnum [Version 2.50] % 8/25/05 - Modified Search and OpenTickets to show HoldReason without having to load tickets. This should save Tech Time and system resources. [Version 2.51] % 10/11/05 - Modified Ticketsystem to allow SETH to update intern tickets without being listed as a tech. (Hardcoded) (See Ticket 8594). % 10/11/05 - Modified Ticketsystem to allow SETH's search page to show TECH search for interns. (Hardcoded) % 10/11/05 - Modified Update page to allow MainTech to place their name as Helper 1, and place someone else in MainTech. [Version 2.52] + 10/13/05 - Added Mileage tracking feature. User checks that they drove a personal vehicle, and how many trips while updating a ticket. Trips is multiplied by 2 for mileage. Data is databased in Techdata database under table Mileage. + 10/13/05 - Added new search option for find all of a users own mileage or for mileage that occurred between a date range. [Version 3.00Beta] * 3/06/06 - Fixed bug where when admin edits a ticket, the prob description box prefixed spaces during each save. Added Trim() to fix. % 3/06/06 - Device's are no longer hard coded. Devices are sorted and pulled from the Device table in the database. % 3/06/06 - School names are no longer hard coded. School Names (Locations) are sorted and pulled from the database. % 3/06/06 - The following pages were updated to use DEV/School dbase code update: Tbooklogin.asp, Search.asp, Upticket.asp. % 3/06/06 - Moved some repetitious code into SUBs and Functions to clean coding some. % 3/17/06 - Many changes have been made since 3-6-06. Some of which are: - All end user pages have been moved to a sub of tbook called "Customer". Workorder now is at https://benton.dsc.k12.ar.us/it/tbook/customer/workordernew.asp - Customer pages code has been revised to not use Panther website template anymore. We will soon be re-working the Panther website. - Customer pages have been modified to use the new DEVICE / LOCATION structure. - Customer page: ViewStatus has been modified to allow customers to leave comments about their ticket. This will update the ticket and email any technicians with the comment. % 3/20/06 - All references to "Devices" or Device listings has been changed to "Category". Database modified to reflect this change also. R 3/20/06 - Released from Beta, since database change above would break functionality of the old ticketbook system. [Version 3.01] + 3/20/06 - Added Print option on the main menu. % 3/20/06 - Modified All Emails directed to the customer to use HTML formatting for easier reading. * 3/20/06 - Modified all User Input's to disable user entered HTML data. This data will display as normal text and will not be executed. (Security fix). * 3/20/06 - Modified Upticket, Up, and SubFunc(ClearData) with AllowUpdate session var. This is to stop duplicate tickets from being created. * 3/20/06 - Fixed bug in IF statement in Upticket. Code was added at an earlier date to allow Intern Admin to view/Edit all of intern tickets. This code had a bug that allowed Intern Admin to update all except locked tickets. + 3/20/06 - Modified MainMenu and Search page menu with LABEL and ID tags to allow users to click on text to select radio buttons. (Code provided by Seth) + 3/20/06 - Added code to MainMenu to create a collapsible Advanced menu. (Code provided by Seth) R 3/20/06 - Release from Beta. % 3/24/06 - Seth wrote a Javascript Close function to place a small [x] at the top right of each page, so you can bail out when you want. Added the .js file to tbooks root, Called the script via TOP. % 3/24/06 - Seth, upon request, Modified JS main menu code, so that if a user clicks a ticket function, and there is no ticket # in the ticket # field, do not execute the javascript code, which would send you to the ticket not found error page. User can still click the GO button as needed. [Version 3.02] + 4/11/06 - Added "Technician Open Tickets Snapshot" to Search page. Will list all open tickets for each technician, for admin to view technician load. + 4/12/06 - Added "<< Return to Search" if a tech views a ticket from the search results page. (This was added to TOP). Requested by Ray/Sherri. + 4/12/06 - Added "[--]" button to act as a minimize button. (Note, only removes focus, not actually minimize). + 4/12/06 - Added Application variable to track who is currently logged on. + 4/12/06 - Added logon functions to make sure a user is not logged in twice. [Version 3.03] * 4/17/06 - Fixed a bug in the dup. logon check where the App("OnlineUSers") var was not operating properly and would tell a user they were logged in when they were not. [Version 3.04] * 4/17/06 - Popup blockers could cause the server to hold your session and think you are still logged in. Created a manual release method for the user to release their login. It warns them of mult. logins/data corruption. [Version 3.05] + 4/25/06 - Added Technician assignment tracking. When a ticket is assigned, unassigned, or re-assigned it is logged in the ticket with the previous and new tech names. [Version 3.06] * 5/26/06 - Anyone could edit Intern tickets. Restructred security checks from using IF's to using a SELECT CASE method which then sets a PASS variable for supervisory access. [Version 3.07] * 6/6/2006 - Update_RO_Fields did not include, Contact, ViewCode, Sent From fields in the table. Added. TO DO: Modify Stats page to use new database structure. [Version 3.08] % 7/31/2006 - Modified All Email and Webpage references from benton.dsc.k12.ar.us to bentonschools.org [Version 3.09] + 9/26/2006 - Added Ticket Number encoded barcode on printed workorders for future use. [Version 3.10] + 12/06/2006] - Added Autologin feature for tech's logged into our domain. [Version 3.11] % 3/22/2007 Modified Ticketbook Email Notification System: 1. Include Technician Username in the Email FROM field "[BRIAN]- Benton Schools Technology Department" 2. Set the ReplyTo email address from "Replies@bentonschools.org" to the technician's emails address & "; brian@bentonschools.org" 3. Include in the notification emails, "Ticket Location: " and "Ticket Owner: " information. [Version 3.12] % 5/30/2007 - Modified all update emails to include links embeded with ticket creds for viewstatus. * 5/31/2007 - Fixed bug where Customer Comments were sent to all Technician's except Helper1. + 5/31/2007 - Added 120 second page refresh (keep-alive) to tbookmaintech (main menu). [Version 3.13] + 8/27/2007 - Added a feature on the search page to search tickets submitted between two given dates. (Admin access reqd.) [Version 3.14] + 9/11/2007 - Added Location Grouping capabilities. Locations can be added to a group number in the database. Technicians can be assigned groups. Groups can be named via the GroupDef table. +% 9/11/2007- Modified OpenTickets report on tech login to show their group tickets that are not assigned to them. + 9/11/2007 - Added File13 option for Full-Time Tech Dept. Employee's. (Usernames are currently hard-coded. % 9/11/2007 - Modified Admin search page to allow reporting of File13 activity from July 1 of (curyear - 1) to curdate. + 9/12/2007 - Added sorttable.js to sort tables however the user/technician likes (one column at a time). Works on Main Menu tables and search page tables. [Version 3.15] + 9/19/2007 - Added Admin Function while viewing tickets to send SMS short details of Emergency Tickets to lead techs. Tech must have SMSAddress in Users Database. Currently not configurable via web app. % 2/20/2008 - Modified all email server/port references to use an Application level variable now. Set variable to new mailserver/port. % 5/6/2008 - Modified customer workorder submission portal with email server/port references that were made on 2/20/2008 [Version 3.16] % 5/14/2008 - Modified Login portal to allow user to be logged in on desktop AND on a mobile device. % 6/24/2008 - Corrected minor spelling mistake on workorder confirmation email. [Version 3.17] % 9/24/2008 - Modified browser detection method to more accurately detect Desktop or Mobile browsers. % 9/24/2008 - Moved Compose and Search menu items out of the Advanced Menu (it does not work on some browsers). [Version 3.18] % 9/15/2009 - Modified Email format for Updates,Close,Reopen, to include the tech notes before the ticket description. This allows for easier information flow to the enduser % 9/15/2009 - Updated PartsTicket email to use HTML formatting instead of raw text. Allows for easier information dissemination. % 9/15/2009 - Updated Comments email to use HTML formatting instead of raw text. Comment is placed in a DIV area for easier information dissemination. % 9/15/2009 - All emails now read the problem description and replace chr(10) with "
" for easier information dissemination. Previously, ticket problems with carriage returns were not showing the carriage returns making it difficult to read long ticket descriptions. [Version 3.19] % 12/10/2009 - Modified "OpenTickets", "Unassigned" code to include all workorders that have Helper's but not a primary technician. TCs were moving themselves to Helper1, but those tickets did not show up as unassigned (since they were technically still assigned). [Version 3.20] * 12/21/2010 - Firefox, Chrome, Safari would lose information (such as ticket assignment) when a ticket was updated. Resolved. * 12/21/2010 - "Advanced Menu" only worked in IE, would not work in Firefox, Chrome, Safari. Resolved. % 12/21/2010 - Firefox, Chrome, Safari did not require fullscreen. Removed requirement of Fullscreen in IE. * 12/22/2010 - Firefox, Chrome, and Safari on Mac OS X were being detected as a "Mobile" device. Added code to detect and set CSS for these browsers when on a Macintosh computer. [Version 3.21] * 1/14/2011 - Modified Ticket Access Security analysis method. + 1/14/2011 - Added "Alert I.T. Director" option on Ticket Update page for Techs/Interns [No Version Change] % 3/11/2011 - Modified Workorder Submission Page (rearranged/updated content, added copyright footer) [No version Change] + 2/6/2012 - Added "Inventory Update" checkbox and alert email to UPTICKET and UP [Version 3.22-SQL] % 4/13/2012 - Major code modifications - Moved from Access Database to MySQL, Moved Email functions to SubFunc, Removed PartsTicket Checkbox, Added Holdstatus change detection/notification, Modified Cancel Ticket/Comment Ticket email logic, and more. + 7/11/2012 - Modified Inventory Update checkbox to append "-- Inventory Update Alert triggered" to the ticket notes for documentation that the alert was triggered. [Version 3.23-SQL] + 7/30/2012 - Modified Customer Ticket Submission to capture the users browser information (user-agent). Created new Workorder database column. Added to ticket email, ViewTicket, Update Ticket, and PrintWo [Version 3.24-SQL] + 9/10/2012 - Added ability to prioritize tickets (Normal, Low, High, Critical, Emergency) [Version 3.25-SQL] + 5/2/2013 - Added File Attachment Upload feature. Max attachment size ~100MB. * 6/13/2013 - Fixed a bug regarding uploading files with spaces in the name. They saved, but could not be called back up from within ticketbook. Replaced ' ' with '_' in filenames. [Version 3.26-SQL] * 7/10/2013 - Fixed a bug where Serial # was lost on new ticket creation / Admin edits. Expected form var changed from prop to propnum. [Version 3.27-SQL] + 9/17/2013 - Added a search feature allowing searching for technician activity on a specific date. [Version 3.28-SQL] + 2/28/2014 - Added a TicketLock on updating (with timeout) to prevent update collisions. [Version 3.29-SQL] * 5/14/2014 - Fixed a bug where if a Category was removed from the database and a ticket was modified by a user with ticket header edit privilege (admins), the Category would change to the top alphebetical selection which is currently "Cellular". * 5/14/2014 - Fixed a bug where if a ticket was edited by anyone and one of the Technicians/Helpers was no longer in the database, their name was modified/removed from the ticket and could not be added back. [Version 3.30-SQL] +% 9/2/2014 - Added 2 columns to User database "LocationAccess" and "CategoryAccess". Modified View/Edit analysis to check these access lists. Access is granted via |location-R||location-RW||*-R||*-RW| and the same for categories. Currently this is added/modified via raw db edit on the user account. Will add GUI in the future. All new Ticketbook users have 0 access until db edit is done. [Version 3.31-SQL] % 3/12/2015 - Modified Keyword search to allow running two words together with & or + to require those two words to appear consecutively during a search (space and * are wildcards). [Version 3.32] + 2/8/2017 - Created DebugMsg buffer; show as black background with green text by default below the Copyright bar when there is a pending message on page load. + 2/8/2017 - Created AlertMsg buffer; show as dull yellow background with red text by default below the top header when there is a pending message on page load. + 2/8/2017 - Enhanced security measures (ie: new RedirectURL function; Login Guid; Login Sid; Session checking). + 2/8/2017 - Added Jump To feature on main menu to quickly view all open tickets at a specific location. + 2/8/2017 - Added Secondary Login detection to detect if this is an additional session + 2/8/2017 - Added Last_Login_IP to database and display along with Last_Login (time). + 2/9/2017 - Added ActiveLogins to the user database to keep count on the number of active sessions for a user. Incremented on Login/Autlogin and decremented by Session_OnEnd. % 2/8/2017 - Removed a restriction on saving a ticket update (after writing it) that blocked non-admin updates on canceled tickets. Check_Edit_Ticket_Permission() should be used to restrict edit access prior to displaying update fields. % 2/8/2017 - Removed restriction of multiple logins on desktop; NOTE: Browser tabs do not separate sessions adequately, so if another session is detected we still block login, user can abandon previous login. % 2/8/2017 - Removed OnlineUser cleanup code from logout page; this is handled in Session_OnEnd and now only clears a primary login session.. % 2/8/2017 - Modified Barcode reader expected variable (conflicted with new Sid, now uses sc=barcode t=keyword) *Needs more work, Barcode searches will be broken at this time due to enhanced security measures. % 2/9/2017 - Dropped -SQL from the version string. * 2/9/2017 - Improved OnlineUser algorithm to ensure accuracy