Changelog
Aug 27 2025
Java - jc:
- added CHAR,VARCHAR,SIGNED,UNSIGNED to SqlQuoter NON_COLUMN_KEYWORDS to prevent convert(xxxx,`char`) type error
- added MemoryWatch summary to ElevenPM command statistical dump
- reduced jvm max memory allocation to 6Gb as too much can cause long gc pauses
- added pre-emptive select by name to AppCtl.addDelivery to avoid dup name exceptions
- sp_change_order added update to sequence dispenser tSeq in case new order number is higher
- removed last package number hack from tOrderPackage.deleteEmpties
--- because it is no longer necessary with InnoDb AND it breaks foreign key
- review and update of TODO tags in code for use in General Task View
- changed OrderRec.countForPage to only join to tables referenced in the filters
Javascript - jc:
- used elvis operator on self.users of oPickupPop in addorderpickup.js to avoid NPE
- added NPE guard for events to notificationPop.initNotification callback handler
- added NPE guard to calendar dtlPop.updateCallback for delivery name
- added pleaseWait and stopWaiting to image list load because one set of errors
suggested that Kelly Maliniak clicked somewhere before page was fully loaded
Aug 26 2025
Db - jc:
- added foreign keys
--- tOrder -> tCustomer on delete restrict
--- tOrderArticle,tOrderPackage,tOrderDelivery,tOrderRoom,tOrderNote -> tOrder
----- all on delete cascade on update cascade
--- tOrderPackageItem -> tOrderArticle on delete cascade
--- tOrderPackageItem -> tOrderPackage on delete cascade
Web - jc:
- change calendar selection filter sequence to favor those that can use indexes
- change order selection filter sequence to favor those that can use indexes
- increase size of temp contacttype column in select_terra_contacts to fix truncation error
Aug 25 2025
Web - jc:
- made MyCrypt.decryptHex more fault tolerant
- steps to avoid deadlocks on OrderTagCounter.updatePackServices
- made irdate.friendly(d) return safely if non-date argument passed in
Aug 24 2025
Web - jc:
- changed select_terra_contacts stored procedure to stop using memory tables because we got
"temporary table is full" error
Aug 23 2025
Web - jc:
- whoison: separated average page load time to its own graph
--- added current day's stats to all graphs
--- changed date format on x axis labels to weekday month date wmd
- since OrderRec.selectFilterCount is 30% of db time today:
--- changed logging key from OrderRec.selectFilterCount to OrderStatusCount??? so we can isolate slowpokes
--- changed count join on customer contact to inner for Commission_Due and Referral_Due
--- changed count join on gclaim to inner for Portal_Claim
--- made count selection specific to filter to exclude tables not referenced
Aug 22 2025
Web - jc:
- built 'stepped' path for updating counts on delivery,room,tag records to reduce deadlocks
- use Thread.setName on OrderTaskQueue to track which order is currently being processed
- added filter suggestion to calendar for selections yielding more than 3,000 tasks
- reworked sp_wiz_load for speed as wizloadctl_get as top time user today
Aug 18 2025
Web:
- mn: fix to Order Time popups incorrect column Id for articles
- mn: fix to Company Stats (ScoreCard) overnight routine
Aug 14 2025
Web:
- mn: fix to delivery counts not updating correctly
- mn: fix to inhome deliveries appearing on tasklist
- mn: fix to rendered service items not packing and shipping automatically
Jul 22 2025
Web:
- mn: added auto select Adjuster check box when adding an insurance company to order without an insurance company
- mn: updated carrier export add more fields: altname, altnaic, maildomain, note, coverage, naic group
Jul 18 2025
Web:
- mn: fix to incorrect NAIC Group numbers on carrier records (from import)
- mn: update to carrier info popup, added inactive, type and fix to missing note
- mn: update to data map added carrier filters: state, onorder, active and type
Jul 17 2025
Web:
- mn: fix to customer final delivery status updating to NA from crm customer popup
- mn: fix to typo on order packout document and added final delivery status to document
- mn: added carrier group name to carrier info popup title
- mn: added next pack due date to mpoperations page, sort by due date
- mn: update inactive flag for carriers with note "not worth tracking" and "do not track"
Jul 16 2025
Web:
- mn: added bulk split button to MP Operations page
- mn: added Member County Coverage export to Oversight-Zip codes
- mn: removed Zip code Export from public use (generates too large of a file)
- mn: fix to mp operations auto split not working
Jul 9 2025
Web:
- mn: fix to filtering error message on mpOperations page
- mn: added conveyor status filter to mpOperations item popup
- mn: updated mpOperation page counts to be clickable
- mn: fix to conveyor rows allowing totalloss items and estimate items
- mn: added group and room filter to mpOperations package popup
Jul 8 2025
Web:
- mn: added group and room filter to mp operations item popup
- mn: fix to mp operations page not saving checkbox settings
Jul 7 2025
Web:
- mn: added auto conveyor removal for 3 or less items
- mn: added new Contact Type "Facility Manager"
- mn: fix to docPreviewPop not being accessible from all pages
- mn: added Notes and Coverage fields to Carrier Merge Popup
Jul 4 2025
Web:
- mn: added hangable filter to order items list page
- mn: updated item filtering to use class OrderItemFilter
- mn: fix to carrier merge popup not sending naic values correctly
Jul 2 2025
Web:
- mn: added unpacked column to Metal Progetti Operations page
- mn: added metal reference code popup
- mn: fix to metal sending records for packed items
- mn: added "Show only on Conveyor" rows to MP Operations page
- mn: added search criteria for MP Operations page
Jun 27 2025
Web:
- mn: fix to slow Metal Progetti query
Jun 24 2025
Web:
- mn: fix to Metal Progetti 'A' Status (remove from conveyor) setting records as packed
- mn: fix to MPOpeartion - sent to Metal column not showing correct value
- mn: added assembly arm control to Order Delivery records
Jun 17 2025
Web:
- mn: fix to department contianer list page not showing all locations for order
- mn: updated department container filtering structure
Jun 17 2025
Web:
- mn: fix to order list state filter using old order address column
- mn: added mail domain filter to carrier list page
- mn: created script to assign carrier to companies using contact mail and carrier mail domain
Jun 16 2025
App:
- tr: working on fixes for camera on certain android devices
Jun 13 2025
Web:
- mn: added SVG coverage map to carriers (popup and detail page)
- mn: fix to carrier state abbr. mixing with state row
- mn: imported carrier domain names
Jun 12 2025
Web:
- mn: changed excel library from jxl to apache
Jun 10 2025
Web:
- mn: fix to calendar event requiring user value
- mn: updated carrier recrods with naic and alt names
- mn: linked carrier records to naic groups
Jun 09 2025
Web:
- mn: fix/update to calendar overlap warning
- mn: fix to load wizard uncombined groups causing error
- mn: added alt name and alt naic numbers fields to carrier merge popup
- mn: fix to storage only group showing pack due date on order delivery list page
- mn: fix to describe and price item not showing price for unauthorized users
Jun 06 2025
Web:
- mn: fix to document preview setting incorrect pageName and causing authorization errors
- mn: fix to "Formerly" section on Contact Detail Popup pointing to current contact
Jun 05 2025
Web:
- mn: improved site list on index page, added user name
- mn: updated create site script (sp_create_site) to include instructions, brands and default groups
Jun 04 2025
Web:
- mn: added alt name field and alt naic field to carrier records
- mn: added OnOrder flag to carrier records, created overnight routine to update flag
- mn: linked customer tpa records to carrier tpa records
- mn: added Accelerator and Last Log Type to Terra export
Jun 03 2025
Web:
- mn: updated zdelivery to pass new parameters to wizload
- mn: hot patch fix to duplicate delivery calendar records
- mn: fix to order detail error when removing company from order
Jun 02 2025
Web:
- mn: fix to task list change due date not reflecting "locked" for load children
- mn: increased column size for tuser.orderQuickFilterSettings to varchar(500)
- mn: fix to Load Wizard showing Total Loss groups as combine options
- mn: fix to Carrier Merge not listing NAIC groups correctly
- mn: fix to missing container type on Department Container labels
- mn: added Location filter to Department Containers
- mn: fix to data truncation error in stored procedure select_contacts_for_terra
May 21 2025
Web:
- mn: updated calendar icons to include text
- mn: updated calendar map to show firm events only
- mn: added tentative, done and firm filters to calendar map filter
- mn: updated map to hide layers box
- mn: removed greying out of routes on map when event is done
App:
- tr: Fixed tag printing from container edit page
- tr: Looking into issues reported by Jim regarding slow delivery scanning
- tr: Looking into issues with item intake saying order was still on hold even after taking hold off
May 20 2025
Web:
- mn: imported "State Plan","Vendors" and "NAIC Groups" to carriers
- mn: added "Unknown" and "Not Provided" columns to oversight export
- mn: fix to irregular referred count on oversight export
- mn: added auto fill sales rep field when selecting company for add contact popup
- mn: removed order progress bars from detail page when not used
May 16 2025
Web:
- mn: changed carrier list page to show all carriers instead of paging
- mn: fix to "exteranl" typo on order detail page
- mn: added inactive company detail to carrier connections on carrier detail page
- mn: update to department containers label
- mn: fix to crmlog not appending "sent to:" when notifying users
May 15 2025
Web:
- mn: added carrier NAIC info to carrier popup
- mn: updated carrier group pop to show current members
May 14 2025
Web:
- mn: added carrier bulk pages
- mn: created script to update carriers with new naic/address data
May 13 2025
Web:
- mn: fix to order address dyna column error
- mn: added naic filter to carrier list
- mn: imported naic numbers from asana#1210214394169832
- mn: added NAIC 2024 reference pdf link
- mn: started bulk carrier pages
- mn: unable to extract all applicable groups from naic reference using ai
App:
- tr: Continuining work on queueing uploads for delivery scanning. Speed improvements, helpful error messages and easier ways to fix errors
- tr: Fixing bug with adding groups in offline mode
- tr: Looking into issue with inhome confirmation message timing with print suggestion (Harri bug report)
May 12 2025
Web:
- mn: added NAIC number, NAIC Group, Type to carrier merge popup
- mn: fixed errors with carrier changes
- mn: added carrier export to carrier list page
App:
- tr: Reworking delivery scanning to queue uploads in the background as you work
- tr: deploying app to testflight and app store
May 9 2025
Web:
- mn: fix to button styles on some popups
- mn: added CarrierGroup table and popup, updated carrier list page, carrier detail page, updated carrier filtering, and carrier reports
- mn: fix to scrolling issue on oversight links
May 8 2025
Web:
- mn: fix to javascript errors on pickcuscon popup
- mn: reworked carrier record to hold XCarrierType enum value, removed tpa and insurance company fields
- mn: restyle to input boxes and labels
App:
- tr: Changed tag printing of containers and tags over to rendered image rather than html/pdf approach that stopped working in maui
- tr: Fixed app crashing when entering delivery start page with map a second time
- tr: Added offline support for delivering all forms of deliverable records
May 7 2025
Web:
- mn: added naic number field to carriers
- mn: created table for carrier group records
- jc: fix to js error on package barcode ship from whoison client log
- jc: fix to js error on package barcode pack from whoison client log
App:
- tr: Fixed bug causing scope/pickup conversion to crash
- tr: Testing changing tag printing from pdfs to images to reduce complexity and hopefully fix multiple tag printing problems
- tr: More null handling improvements in network calls
May 6 2025
Web:
- mn: added filters to gcarrierlist
- mn: added carrier merge popup and sp_ merge procedure
App:
- tr: Fixes for crash when changing flash mode on devices without flash (like ipads)
- tr: Fixed issue causing new deliveries to crash
May 5 2025
App:
- tr: enhanced network calls to retry and better crash handling
- tr: fixed signature capturing
- tr: fixed crash when taking photos
- tr: fixed bug causing crash after network error when updating a Group
May 1 2025
Web:
- jc: fix script error on crm detail popup when coming from calendar event, trying to add contact (whoison client log)
- jc: fix script error when code popup (quality,severity,handling) comes up on order bag page
- mn: fix to table full error for terra contact export (stored procedure)
- mn: fix to delivery wizard suggesting shipped deliveries for combining
- mn: fix to contact filter not filtering for contact name or company name
- mn: optimized slow order storage query
- mn: copied all carrier records (gCarrier) with orders into site 1's company table (tCustomer)
April 30 2025
App:
- tr: Fixed issue with downloading orders connected to hundreds of deliveries
April 25 2025
App:
- tr: Fixed calendar events not letting you click the last one in list
- tr: Changed HttpClient implementation to hopefully fix some random null responses we've been getting
- tr: Improvements to crash reporting
April 24 2025
Web:
- mn: Added social media to User/Customer/Member pages and preferences
- mn: Included Company/User social media in Terra Sender Export
- mn: Updated v-card to show all social media links
- mn: Updated all info popups to include social media links where applicable
April 23 2025
Web:
- mn: Added table for social media accounts for users, members, companies, customers and contacts
- mn: Added ability to add multiple social media accounts for members and contacts
- mn: Created global Add Social Media account popup
- mn: Added Social Media Icons
April 22 2025
App:
- tr: Updating mac/xcode/rider/maui to support maui9
- tr: Testing fixes made for android on ios to ensure no regressions
- tr: Improved data logging on certain network crashes
- tr: Looking into issues with inhome count being wrong on calendar events
- tr: Looking into ways to improve tag printing reliability
Web:
- mn: Created a "Sender" export for Terra; added to overnight routine
- mn: Created a user export table to flag users with changes or companies with changes
- mn: Fixes to combining groups rules
April 17 2025
App:
- tr: Lots of work on getting Android app up to par in maui
- tr: Fixing radio buttons that stopped working in maui
- tr: Fixed icon and splash screen
- tr: Upgraded maui and packages to .net9 to get latest bug fixes and improvements from microsoft
- tr: Fixed list items that were unclickable in Android (many places in app)
- tr: Fixed height of Contents box on Packout page to fit all items
Web:
- mn: Overhaul to contact filtering, created class to hold all filter values
- mn: Added marketing dyna column and filters to contact pages
- mn: Created a generic BooleanFilter for sql tinyint(1)
- mn: Added contact duplicate check to add contact popup
April 16 2025
- Initial changelog created
App:
- tr: Fixed crash on delivery scanning page (Asana: 1209998072547483)
- tr: Fixed item text getting cut off when searching for items on packout (Asana: 1206389324558019)
- tr: Fixed crash when marking certain event types done
- tr: Investigating issues reported in Asana: 1206389324558014, edited delivery group not found
- tr: Investigating Asana: 1206389324558011, trying to find where 1531 in home items value came from
- tr: Fixed error message disappearing too quickly on marking event done (Asana: 1206389324558046) and fixed server side code causing that error
- tr: Removed text from Last Entered section if you're working on a different order (Asana: 1206389324558017)
Web:
- mn: Fixed incorrect order count on Oversight Members page
- mn: Changed add contact popup to warn if email is missing instead of stop user
- mn: Overhaul to contact bulk pages
- mn: Contacts will now be flagged for Terra Export when added to an Order
- mn: Removed contacts from marketing with duplicate email addresses, database update
- tr: Added link on whats new to open change log in a separate tab
- tr: Added scheduled task on server to pull change log down from ir server
- tr: Added cron job on ir server to pull this file out of source control periodically and place it where the TS server can get it