+ `j#/(^RIt^RIHtHt^RIHtHt^RIHtHtH t H t ^RI H t ^RI Ht^RIHt^RIHt^R IHtHt^R IHt^R IHtR tRR RlltRRRlltR RRlltR RRlltRRltR!RRllt R"RRllt!RRlt"RRlt#R#)#N)datetimetimezone)OptionalList)selectupdatefuncor_) AsyncSession) Notification) LoginUsers)RoleModulePermission) DealerOrderDealerOrderVehicle)CustomerMaster) app_loggercJ\P!\P4#N)rnowrutcC/var/www/html/audi_dev/backend/app/modules/notifications/service.pynow_utcrs << %%rc V^8dQhR\R\PR\R\R\ \ \,\3,/#)dbuser_idlimit unread_onlyreturn)r uuidUUIDintbooltuplerr )formats"r __annotate__r(sM!%!%!% YY!% !% !%  4 s "# !%rc*"\\P!\P44P \P R8H\PV8H\PR8H4pVPV4GRjxL P4;'g^p\\4P \P R8H\PV8H4pV'd#VP \PR8H4pVP\PP44PV4pVPV4GRjxL P4P!4p\#V4V3#ELL05i)zP Fetches notifications for an internal staff user, plus the total unread count. STAFFFN)rr countr notification_idwhererecipient_typeris_readexecutescalarorder_by created_atdescrscalarsalllist)rrrr count_stmt unread_countstmtitemss&&&& rget_user_notificationsr<s2 tzz,6678   ' '7 2  G +  E ) **Z0088:??aL |   ' '7 2  G +  zz,..%78 ==00557 8 > >u ED::d# # , , . 2 2 4E ; $$1$+BFF F"B>F F!.FFc V^8dQhR\R\R\R\R\\ \ ,\3,/#)rr dealer_idrr r!)r strr$r%r&rr )r's"rr(r(7sI%%%% % %  4 s "# %rc*"\\P!\P44P \P R8H\PV8H\PR8H4pVPV4GRjxL P4;'g^p\\4P \P R8H\PV8H4pV'd#VP \PR8H4pVP\PP44PV4pVPV4GRjxL P4P!4p\#V4V3#ELL05i)zQ Fetches notifications for a dealer portal account, plus the total unread count. DEALERFN)rr r+r r,r-r.r?r/r0r1r2r3r4rr5r6r7)rr?rr r8r9r:r;s&&&& rget_dealer_notificationsrC7s2 tzz,6678   ' '8 3  " "i /  E ) **Z0088:??aL |   ' '8 3  " "i /  zz,..%78 ==00557 8 > >u ED::d# # , , . 2 2 4E ; $$1$r=c V^8dQhR\R\PR\\P,R\\,R\ /#)rrr,rr?r!)r r"r#rr@r%)r's"rr(r(YsKYYdii }   rc."VP\V4GRjxL pV'gR#V'dVPV8wdR#V'dVPV8wdR#RVn\ 4VnVP4GRjxL R#LtL5i)zP Marks a single notification as read if it belongs to the requesting recipient. NFT)getr rr?r/rread_atcommit)rr,rr?notifs&&&& rmark_notification_as_readrJYsn&&7 7E 5==G+U__ 1EMIEM ))+  8s1BB B BBD4D2D4-D42D4cZV^8dQhR\R\\P,/#)rrr!)r rr"r#)r's"rr(r(s"|TYYrc l".ROpVP\\P4P \P R8H\ \PPV4\PPR4444GRjxL P4P4pVP\\P4P\\P\P8H4P \P R8H\PPRR.4\PR8H44GRjxL P4P4p\!V4\!V4,p\#V4#ELLI5i)z Resolves the specific staff users responsible for Sales & Dealer Orders. Includes users with explicit Sales roles (SALES_MGR, SALES_EXEC, CLIENT_ADMIN, ADMIN) or users who have view/edit permission for the SALES module. Tz%SALES%NSALESDEALER_PORTAL_ADMIN) SALES_MGR SALES_EXECADMIN CLIENT_ADMIN)r0rr rr- is_activer role_codein_iliker5r6joinr module_codecan_viewsetr7)r direct_roles users_by_role users_by_permcombineds& r_get_sales_team_user_idsresGHL::z!!"((  D ( $$((6$$**95  wy::z!!" "J$8$8-s&BF4F/CF4(F2)AF42F4c<V^8dQhR\R\R\/#)rrorderis_resubmission)r rr%)r's"rr(r(s0JbJbJb JbJbrc"VP\VP4GRjxL pV'd VPM VPpVP \ \ P!\P44P\PVP8H44GRjxL P4;'g^pVP;'g+\VP4R,P4pV'gRMRpV'gRT RT RV^8dRMR R 2MR V R 2pTP!\#\$P&!4R VPRV'gRMRVVR\VP4RR\)4R7 4\+V4GRjxL p V'gRV 2MRV 2p V'gRT RT RT RV^8dRMR R2 MRV RV R2p V Fnp TP!\#\$P&!4RT RV'gRMRV V R\VP4RVP 2R\)4R 7 4Kp VP-4GRjxL R#EL\ELLL \.d%p \0P2!R!T 24Rp ? R#Rp ? ii;i5i)"z Dispatches notifications when an order is created or submitted: 1. Sends confirmation notification to the Dealer Portal 2. Sends actionable notification to the Sales team in the internal ERP NNNzOrder Submitted SuccessfullyzOrder Changes Resubmittedz Your order #z (z vehicleszD) has been received and is currently under review by the Sales team.z&Your updated configuration for order #z' has been resubmitted for Sales review.rBORDERORDER_SUBMITTEDORDER_RESUBMITTED DEALER_ORDER/dealer-portal/ordersF r,r.r?category event_typetitlemessagereference_type reference_id action_urlr/r3z New Order: #zOrder Resubmitted: #Dealer 'z' submitted new order #z for .z'' resubmitted revised specs for order #r*ORDER_RECEIVED ORDER_UPDATED/sales/dealer-orders?order_id= r,r.rrtrurvrwrxryrzr/r3zA[NOTIFICATIONS] Failed to dispatch order submitted notification: )rFrr?namer0rr sumrqtyr-order_idr1order_nor@upperaddr r"uuid4rrerH Exceptionrerror)rrgrhdealer dealer_namev_qtyr dealer_title dealer_msgsales_user_ids sales_title sales_msguides&&& rnotify_order_submittedrs@bvvneoo>>%+fkk zz 488.223 4 U%..%..@ A   68  >>DDS%8%<%B%B%D>M5Rm !8*BugXUQYcB5OP? @5XJ>e f  | JJL#oo0?(EX)U^^,.y  8;;7F XJ/NbckblLm !{m#:8*E%PX`ehi`iY\oqXrrs t{m#J8*TU V  "C FF< $ & 3B+!!- 0;ENN;KL"9  " iiky? @<0  b\]^\_`aabsJ?#J J J BJ 5J6J J %2J  J $BJ 5J 6 J J B(J <J =J J?J J J J J<J71J?7J<<J?cfV^8dQhR\R\R\\P,/#)rrrgadmin_id)r rrr"r#)r's"rr(r(s4hhh htyy!hrc"VP;'g+\VP4R,P4pVP \ \ P!4RVPRRRRV R2R\VP4R R \4R 7 4VP4GR jxL R #L \d%p\P!R T 24R p?R #R p?ii;i5i)zi Dispatches notification to Dealer Portal when Sales reviews and confirms an order (pending dealer ack). rjrBrnSALES_CONFIRMEDzOrder Reviewed by SaleszSales has reviewed order #z<. Please review the assigned specifications and acknowledge.rqrrFrsNzG[NOTIFICATIONS] Failed to dispatch order sales confirmed notification: rr@rrrr r"rr?rrHrrr)rrgrrrs&&& rnotify_order_confirmed_by_salesrsh>>DDS%8%<%B%B%D | JJL#oo(+0 :vw)U^^,.y  iik hbcdbefgghAC2B3C7B>8C<C2>C C/ C*$C2*C//C2c0V^8dQhR\R\/#rrrgr r)r's"rr(r(!s eee erc"VP\VP4GRjxL pV'd VPM VPpVP;'g+\ VP 4R,P4p\V4GRjxL pVFnpVP\\P!4RVRRRV 2RV RV R 2R \ VP 4R VP 2R \4R 7 4Kp VP4GRjxL R#ELLL \d%p\ P"!RT 24Rp?R#Rp?ii;i5i)zK Dispatches notification to Sales Team when Dealer acknowledges the order. Nrjr*rnORDER_ACKNOWLEDGEDzOrder Acknowledged: #r{z' has acknowledged order #z*. Ready for final confirmation/production.rqrFrzD[NOTIFICATIONS] Failed to dispatch order acknowledged notification: )rFrr?rrr@rrrerr r"rrrHrrr)rrgrrrrrrs&& r#notify_order_acknowledged_by_dealerr!s*evvneoo>>%+fkk >>DDS%8%<%B%B%D7;;!C FF< $ & /-hZ8";-/I(S}~- 0;ENN;KL"9  "iik)?<  e_`a_bcddesnE$#D2D+ D2*D29D2D.B D2$D0%D2)E$+D2.D20D22 E!=EE$E!!E$c0V^8dQhR\R\/#rr)r's"rr(r(Bs hhh hrc"VP;'g+\VP4R,P4pVP \ \ P!4RVPRRRRV R2R\VP4R R \4R 7 4VP4GR jxL R #L \d%p\P!R T 24R p?R #R p?ii;i5i)ze Dispatches notification to Dealer Portal when order is finally confirmed and locked for production. rjrBrn ORDER_LOCKEDzOrder Confirmed & ScheduledzOrder #zA is officially confirmed and locked into the production pipeline.rqrrFrsNzG[NOTIFICATIONS] Failed to dispatch final order confirmed notification: r)rrgrrs&& rnotify_order_final_confirmedrBsh>>DDS%8%<%B%B%D | JJL#oo%/hZ'hi)U^^,.y  iik hbcdbefgghr)F)NN)Fr)$r"rrtypingrr sqlalchemyrrr r sqlalchemy.ext.asyncior app.models.notification_modelsr app.models.core_modelsr app.models.access_modelsrapp.models.dealer_modelsrrapp.models.sales_modelsrapp.core.loggingrrr<rCrJrPrerrrrrrrrsf '!00/7-9D2'&!%H%D0"JBJbZh:eBhr