Notification System Refactor

Problems Identified

Multiple notification issues surfaced during the stabilisation period:

1. Missing notifications - Metricon user Gaby Moore not receiving notifications for her projects
2. Duplicate notifications - Royston Tech receiving duplicate emails since the morning of Feb 4
3. Missing EmailTemplate records - Production did not have all notification templates from staging
4. Misdirected links - Email links sending Metricon users to the Customer Portal instead of the Ordering Portal

From the Chatlogs

Duplicate notifications reported Feb 4:

"Royston Tech receiving duplicates since early this morning." Missing notifications for Metricon users:

"Gaby Moore is not receiving notifications still. Can you please investigate why?" - Matt, Feb 4

Email link routing issue, Feb 7:

"The email notification links for Metricon are directing users to the customer platform rather than the ordering platform. Can this be updated?"

Fixes Applied

1. EmailTemplate sync - Villar directed manual update of EmailTemplate records from preprod to production (not delete, only add/update)
2. Dynamic portal redirection - Jayrex implemented company-aware link routing:

• If company has Ordering Portal access → link opens in Ordering Portal
• If not → link opens in Customer Portal

3. Centralised redirect logic - Villar identified the need for a centralised decision point for notification routing

"Notification links need to be centralised to a point that deciphers where they are redirected to."

Impact

Improved communication reliability and reduced user confusion across both portals.