+
    `ØjÃë  ã                   ó  € ^ RI t ^ RIHtHtHt ^ RIHt ^ RIHt ^ RIH	t	 ^ RI
HtHtHtHt ^ RIHt ^ RIHtHt ^ R	IHtHt ^ R
IHtHt ^ RIHtHtHtHtHtH t H!t!H"t"H#t#H$t$H%t%H&t&H't'H(t(H)t)H*t*H+t+H,t, ^ RI-H.t.H/t/ ^ RI0H1t1H2t2H3t3H4t4 ^ RI5H6t7 ^RI8H9t9 R R lt:R R lt;R\R R llt<R R lt=R]R R llt>R R lt?R R lt@R R ltAR^R  R! lltBR_R" R# lltCR$ R% ltDR& R' ltER( R) ltFR* R+ ltGR_R, R- lltHR. R/ ltIR_R0 R1 lltJR2 R3 ltKR4 R5 ltLR6 R7 ltMR8 R9 ltNR`R: R; lltOR< R= ltPR> R? ltQRaR@ RA lltRRB RC ltSRD RE ltTRbRF RG lltURH RI ltVRcRJ RK lltWRL RM ltXRN RO ltYRP RQ ltZRR RS lt[RT RU lt\RV RW lt]RX RY lt^RaRZ R[ llt_R# )dé    N)ÚdatetimeÚ	timedeltaÚtimezone)ÚOptional)ÚHTTPException)ÚAsyncSession)ÚselectÚfuncÚdeleteÚupdate)Úselectinload)ÚCustomerMasterÚClientMaster)ÚVehicleModelMasterÚChassisMaster)ÚDispatchThermalChecksheetÚDispatchThermalChecksheetItem)ÚDealerPortalLogÚDealerPortalActionLogÚBodyTypeMasterÚModelBodyTypeMapÚCustomerSegmentMasterÚModelSegmentMapÚ	RtoMasterÚSpecialFeatureMasterÚSpecialFeatureOptionMasterÚDealerOrderÚDealerOrderVehicleÚDealerOrderVehicleChassisÚDealerOrderVehicleFeatureÚDealerOrderActivityLogÚDealerRequestÚDealerVehicleTemplateÚDealerVehicleTemplateFeatureÚFeatureSegmentMap)Úverify_passwordÚcreate_access_token)ÚDealerLoginRequestÚDealerLoginResponseÚClientCreateÚOrderCreate)Úservice)Úschemasc          
      óT   € V ^8„  d   QhR\         R\        R\        R\        R\        /# )é   ÚdbÚreqÚipÚ
user_agentÚreturn)r   r(   Ústrr)   )Úformats   "ÚC/var/www/html/audi_dev/backend/app/modules/dealer_portal/service.pyÚ__annotate__r8      s2   € ÷ %ñ %¤,ð %Ô5Gð %ÌSð %Ô^að %Ôfyñ %ó    c              ƒ   óº  "  € VP                   ;'       g    R P                  4       pV P                  \        \        4      P                  \        P                  ! \        P                  ! \        P                   4      4      VP                  4       8H  4      P                  \        P                  R8H  4      P                  \        P                  R8H  4      4      G Rj  x€L
 pVP                  4       pV'       d   VP                  '       g   \        RRR7      h\        VP                  VP                  4      '       g   \        RRR7      h\!        VP"                  \$        P&                  ! 4       P(                  VV\*        P,                  ! \.        P0                  4      \3        ^R7      ,           R7      pV P5                  V4       V P7                  4       G Rj  x€L
  V P9                  V4      G Rj  x€L
  \;        R	VP"                  R
RR\=        VP>                  4      /4      p\A        VVP"                  VPB                  VPD                  R7      #  ELv L{ Ld5i)Ú TNi‘  z)Invalid credentials or portal not enabled©Ústatus_codeÚdetailzInvalid credentials©Údays)Ú	dealer_idÚsession_tokenÚ
ip_addressr3   Ú
expires_atÚsubÚsub_typeÚdealerÚ
session_id)Úaccess_tokenrA   Údealer_nameÚallow_chassis_tracking)#Úportal_usernameÚstripÚexecuter	   r   Úwherer
   ÚlowerÚtrimÚportal_enabledÚ	is_activeÚscalar_one_or_noneÚportal_password_hashr   r&   Úportal_passwordr   Úcustomer_idÚuuidÚuuid4Úhexr   Únowr   Úutcr   ÚaddÚcommitÚrefreshr'   r5   Úlog_idr)   ÚnamerK   )	r0   r1   r2   r3   ÚusernameÚresultrG   Ú	log_entryrI   s	   &&&&     r7   Úauthenticate_dealerre      s¿  é € Ø×#Ñ#×)Ð) r×0Ñ0Ó2€HØ—:‘:ÜŒ~Óß	‰Œt�zŠzœ$Ÿ)š)¤N×$BÑ$BÓCÓDÈÏÉÓHXÑXÓ	Yß	‰Œ~×,Ñ,°Ñ4Ó	5ß	‰Œ~×'Ñ'¨4Ñ/Ó	0ó	÷ €Fð ×&Ñ&Ó(€Fß˜×4×4Ð4Ü¨Ð4_Ô`Ð`ä˜3×.Ñ.°×0KÑ0K×LÒLÜ¨Ð4IÔJÐJäØ×$Ñ$Ü—j’j“l×&Ñ&ØØÜ—<’<¤§¡Ó-´	¸rÔ0BÕBô€Ið ‡F�Fˆ9ÔØ
�)‰)‹+×ÐØ
�*‰*�YÓ
×Ðä&Øˆv×!Ñ!Ø�HØ”c˜)×*Ñ*Ó+ð(ó €Lô Ø!Ø×$Ñ$Ø—K‘KØ%×<Ñ<ô	ð ò=ñ* ÙùsD   ‚CIÃIÃIÃ;IÄCIÇIÇIÇ4IÇ5A IÉIÉIc                óD   € V ^8„  d   QhR\         R\        P                  /# )r/   r0   rH   ©r   rX   ÚUUID)r6   s   "r7   r8   r8   B   s   € ÷ ñ œLð ´d·i±iñ r9   c              ƒ   óè   "  € V P                  \        V4      G R j  x€L
 pV'       dD   \        P                  ! \        P
                  4      Vn        V P                  4       G R j  x€L
  R # R #  LQ L
5i©N)Úgetr   r   r[   r   r\   Úinvalidated_atr^   )r0   rH   rd   s   && r7   Úlogout_dealerrm   B   sN   é € Ø—f‘fœ_¨jÓ9×9€IßÜ#+§<¢<´·±Ó#=ˆ	Ô Ø�i‰i‹k×Òñ ñ :ñ 	ùs&   ‚A2œA.�A2©<A2Á%A0Á&	A2Á0A2c                ó¤   € V ^8„  d   QhR\         R\        R\        R\        R,          R\        R,          R\        R,          R\        R,          /# )	r/   r0   rA   Úaction_typeÚentity_typeNÚ	entity_idÚdetailsr2   )r   r5   Údict)r6   s   "r7   r8   r8   I   sX   € ÷ 	ñ 	Üð	Ü!$ð	Ü36ð	ä�t•ð	ä/2°T­zð	ô �D�[ð	ô &)¨4¥Zñ	r9   c              ƒ   ó~   "  € V P                  \        WVWEVR 7      4       V P                  4       G Rj  x€L
  R#  L5i))rA   ro   rp   rq   Úaction_detailsrC   N)r]   r   r^   )r0   rA   ro   rp   rq   rr   r2   s   &&&&&&&r7   Úlog_dealer_actionrv   I   s6   é € ð
 ‡F�FÔ ØÀ+ØÀôô ð �)‰)‹+×Ôùs   ‚2=´;µ=c                ó$   € V ^8„  d   QhR\         /# ©r/   r4   ©r5   )r6   s   "r7   r8   r8   U   s   € ÷ 1ñ 1œSñ 1r9   c                  óp   € R \         P                  ! 4       P                  R,          P                  4        2# )zCLI-ºNé   N©rX   rY   rZ   Úupper© r9   r7   Ú_generate_client_idr€   U   ó*   € Ø”$—*’*“,×"Ñ" 2Õ&×,Ñ,Ó.Ð/Ð0Ð0r9   c                óH   € V ^8„  d   QhR\         R\        R\        R\        /# )r/   r0   rA   ÚqÚlimit©r   r5   Úint)r6   s   "r7   r8   r8   Y   s(   € ÷ 
4ñ 
4œ\ð 
4´cð 
4¼cð 
4Ì#ñ 
4r9   c              ƒ   óþ  "  € ^ RI HpHp \        V4      P	                  WTP
                  VP
                  8H  4      P                  VP                  V8H  VP                  R8H  4      pV'       d/   VP                  VP                  P                  RV R24      4      pVP                  VP                  4      P                  V4      pV P                  V4      G Rj  x€L
 P                  4       P                  4       #  L 5i)r   ©r   ÚDealerClientMapTÚ%N)Úapp.models.sales_modelsr   r‰   r	   ÚjoinÚ	client_idrO   rA   rS   ra   ÚilikeÚorder_byr„   rN   ÚscalarsÚall)r0   rA   rƒ   r„   r   r‰   Ústmts   &&&&   r7   Úsearch_clientsr“   Y   sÅ   é € ßEäˆ|Óß	‰ˆo×5Ñ5¸×9RÑ9RÑRÓ	Sß	‰ˆ×(Ñ(¨IÑ5°|×7MÑ7MÐQUÑ7UÓ	Vð 	÷
 	Ø�z‰z˜,×+Ñ+×1Ñ1°A°a°S¸°(Ó;Ó<ˆØ�=‰=˜×*Ñ*Ó+×1Ñ1°%Ó8€DØ—*‘*˜TÓ"×"×+Ñ+Ó-×1Ñ1Ó3Ð3Ñ"ùs   ‚CC=ÃC;Ã!C=c                ó0   € V ^8„  d   QhR\         R\        /# ©r/   r0   rA   ©r   r5   )r6   s   "r7   r8   r8   f   s   € ÷ ñ œ<ð ´Cñ r9   c              ƒ   ó®  "  € ^ RI HpHp \        V4      P	                  W2P
                  VP
                  8H  4      P                  VP                  V8H  4      P                  VP                  R8H  4      P                  VP                  4      pV P                  V4      G Rj  x€L
 P                  4       P                  4       pV F	  pWn        K  	  V#  L15i)r   rˆ   TN)r‹   r   r‰   r	   rŒ   r�   rO   rA   rS   r�   ra   rN   r�   r‘   )r0   rA   r   r‰   r’   ÚclientsÚcs   &&     r7   Úlist_clientsrš   f   s¨   é € ßEäˆ|Óß	‰ˆo×5Ñ5¸×9RÑ9RÑRÓ	Sß	‰ˆ×(Ñ(¨IÑ5Ó	6ß	‰ˆ|×%Ñ%¨Ñ-Ó	.ß	‰�,×#Ñ#Ó	$ð 	ð —Z‘Z Ó%×%×.Ñ.Ó0×4Ñ4Ó6€GÛˆØŽñ à€Nñ &ùs   ‚BCÂ!CÂ"2Cc                óH   € V ^8„  d   QhR\         R\        R\        R\        /# )r/   r0   rA   r�   r4   ©r   r5   r   )r6   s   "r7   r8   r8   u   s(   € ÷ ñ œð ´#ð Ä#ð Ì,ñ r9   c              ƒ   óx  "  € ^ RI HpHp \        V4      P	                  WCP
                  VP
                  8H  4      P                  VP                  V8H  VP
                  V8H  4      pV P                  V4      G Rj  x€L
 P                  4       P                  4       pV'       g   \        RRR7      hWn        V#  L=5i©r   rˆ   Né”  zClient not foundr<   )r‹   r   r‰   r	   rŒ   r�   rO   rA   rN   r�   Úfirstr   )r0   rA   r�   r   r‰   r’   Úclients   &&&    r7   Ú
get_clientr¢   u   s™   é € ßEäˆ|Óß	‰ˆo×5Ñ5¸×9RÑ9RÑRÓ	Sß	‰ˆ×(Ñ(¨IÑ5°|×7MÑ7MÐQZÑ7ZÓ	[ð 	ð
 —J‘J˜tÓ$×$×-Ñ-Ó/×5Ñ5Ó7€FßÜ¨Ð4FÔGÐGØ ÔØ€Mñ	 %ùs   ‚A8B:Á:B8Á;'B:Â#B:c                ó<   € V ^8„  d   QhR\         R\        R\        /# )r/   r0   r�   r4   rœ   )r6   s   "r7   r8   r8   ƒ   s!   € ÷ ñ ¤<ð ¼Cð ÄLñ r9   c              ƒ   óò  "  € ^ RI HpHp V P                  W!4      G Rj  x€L
 pV'       g   \	        RRR7      h\        VP                  4      P                  VP                  V8H  4      pV P                  V4      G Rj  x€L
 P                  4       P                  4       pWdn        V'       d<   V P                  \        V4      G Rj  x€L
 pV'       d   VP                  MRVn        V# RVn        V#  LÑ Lt L.5irž   )r‹   r   r‰   rk   r   r	   rA   rO   r�   rN   r�   r    r   ra   rJ   )r0   r�   r   r‰   r¡   r’   rA   rG   s   &&      r7   Úget_client_for_staffr¥   ƒ   sÅ   é € ßEØ—6‘6˜,Ó2×2€FßÜ¨Ð4FÔGÐGä�/×+Ñ+Ó,×2Ñ2°?×3LÑ3LÐPYÑ3YÓZ€DØ—z‘z $Ó'×'×0Ñ0Ó2×8Ñ8Ó:€Ià ÔßØ—v‘vœn¨iÓ8×8ˆß,2˜VŸ[š[¸ˆÔð €Mð "ˆÔà€Mñ 3ñ
 (ñ 9ùs@   ‚C7ŸC1 C7¬AC7Á>C3Á?AC7ÃC5ÃC7ÃC7Ã3C7Ã5C7c                ó<   € V ^8„  d   QhR\         R\        R\        /# )r/   r0   rƒ   r„   r…   )r6   s   "r7   r8   r8   –   s!   € ÷ ñ ¬Lð ¼Sð Ìñ r9   c              ƒ   óÎ  "  € ^ RI HpHp \        W4P                  \
        P                  P                  R4      4      P                  WCP                  VP                  8H  4      P                  \
        VP                  \
        P                  8H  4      P                  VP                  R8H  4      pV'       d/   VP                  VP                  P                  RV R24      4      pVP                  VP                  4      P                  V4      pV P!                  V4      G Rj  x€L
 P#                  4       p. pV F#  w  r‰p
W˜n        W¨n        VP'                  V4       K%  	  V#  L?5i)r   rˆ   rJ   TrŠ   N)r‹   r   r‰   r	   rA   r   ra   ÚlabelÚ	outerjoinr�   rW   rO   rS   rŽ   r�   r„   rN   r‘   rJ   Úappend)r0   rƒ   r„   r   r‰   r’   ÚrowsÚresultsr¡   rA   rJ   s   &&&        r7   Úsearch_clients_across_dealersr­   –   s  é € ßEäˆ|×6Ñ6¼×8KÑ8K×8QÑ8QÐR_Ó8`Óaß	‰�?×$:Ñ$:¸o×>WÑ>WÑ$WÓ	Xß	‰”> ?×#<Ñ#<Ä×@ZÑ@ZÑ#ZÓ	[ß	‰ˆ|×%Ñ%¨Ñ-Ó	.ð	 	÷ 	Ø�z‰z˜,×+Ñ+×1Ñ1°A°a°S¸°(Ó;Ó<ˆØ�=‰=˜×*Ñ*Ó+×1Ñ1°%Ó8€DØ—*‘*˜TÓ"×"×'Ñ'Ó)€DØ€GÛ*.Ñ&ˆ˜;Ø$ÔØ(ÔØ�‰�vÖñ +/ð €Nñ #ùs   ‚D!E%Ä#E#Ä$A E%c                óŠ   € V ^8„  d   QhR\         R\        R\        R\        R\        \
        P                  ,          R\        /# )r/   r0   rA   ÚpayloadÚcreated_by_dealerÚcreated_by_user_idr4   )r   r5   r*   Úboolr   rX   rh   r   )r6   s   "r7   r8   r8   ª   sG   € ÷ ñ ÜðÜ!$ðÜ/;ðäðä19¼$¿)¹)Õ1Dðô ñr9   c           
   ƒ   ó  "  € ^ RI HpHp V P                  \	        V4      P                  WeP                  VP                  8H  4      P                  VP                  V8H  VP                  R8H  VP                  P                  VP                  P                  4       4      4      4      G Rj  x€L
 P                  4       pV'       d   \        RRVP                   R2R7      hV! RR\        4       R	V/VP!                  4       B pV P#                  V4       V P%                  4       G Rj  x€L
  V P#                  V! WP                  R
7      4       V P'                  4       G Rj  x€L
  V P)                  V4      G Rj  x€L
  V#  LÕ L[ L# L5i)r   rˆ   TNé�  úA client named 'ú ' already exists for this dealerr<   r�   r±   )rA   r�   r   )r‹   r   r‰   rN   r	   rŒ   r�   rO   rA   rS   ra   rŽ   rM   rT   r   r€   Ú
model_dumpr]   Úflushr^   r_   )	r0   rA   r¯   r°   r±   r   r‰   Úexistingr¡   s	   &&&&&    r7   Úcreate_clientrº   ª   sR  é € ÷ FØ—j‘jÜˆ|Óß	‰ˆo×5Ñ5¸×9RÑ9RÑRÓ	Sß	‰Ø×%Ñ%¨Ñ2Ø×"Ñ" dÑ*Ø×Ñ×#Ñ# G§L¡L×$6Ñ$6Ó$8Ó9ó

ó÷ ÷ ÑÓð ÷ Ü¨Ð6FÀxÇ}Á}ÀoÐUuÐ4vÔwÐwáñ Ü%Ó'ðà-ðð ×
Ñ
Ó
ñ€Fð
 ‡F�Fˆ6„NØ
�(‰(‹*×Ðà‡F�F‰? Y×:JÑ:JÔKÔLà
�)‰)‹+×ÐØ
�*‰*�VÓ
×ÐØ€Mñ1ñ$ ñ ÙùsO   ‚B(FÂ*F Â+FÃA!FÄ&FÄ'9FÅ FÅ!FÅ9FÅ:FÆFÆFÆFc          
      óh   € V ^8„  d   QhR\         R\        R\        R\        P                  R\        /# )r/   r0   rA   r�   r¯   r4   )r   r5   r-   ÚClientUpdater   )r6   s   "r7   r8   r8   Ê   s:   € ÷ ñ ÜðÜ!$ðÜ14ðÜ?F×?SÑ?Sðäñr9   c           
   ƒ   ó^  "  € ^ RI HpHp \        WV4      G Rj  x€L
 pVP                  Ee   VP                  P                  4       VP                  8w  dä   V P                  \        V4      P                  WTP                  VP                  8H  4      P                  VP                  V8H  VP                  R8H  VP                  P                  VP                  P                  4       4      VP                  V8g  4      4      G Rj  x€L
 P                  4       pV'       d   \        RRVP                   R2R7      hVP!                  RR7      pVP#                  4        F  w  rš\%        WiV
4       K  	  V P'                  4       G Rj  x€L
  V P)                  V4      G Rj  x€L
  V#  ELŠ L¢ L$ L5i)	r   rˆ   NTr´   rµ   r¶   r<   )Úexclude_unset)r‹   r   r‰   r¢   ra   rM   rN   r	   rŒ   r�   rO   rA   rS   rŽ   rT   r   r·   ÚitemsÚsetattrr^   r_   )r0   rA   r�   r¯   r   r‰   r¡   r¹   Úupdate_dataÚkeyÚvalues   &&&&       r7   Úupdate_clientrÄ   Ê   sb  é € ÷ FÜ˜b¨YÓ7×7€Fà‡|�|Ó G§L¡L×$6Ñ$6Ó$8¸F¿K¹KÔ$GØŸ*™*Ü�<Ó ß‰T�/×#9Ñ#9¸_×=VÑ=VÑ#VÓWß‰UØ×)Ñ)¨YÑ6Ø×&Ñ&¨$Ñ.Ø×!Ñ!×'Ñ'¨¯©×(:Ñ(:Ó(<Ó=Ø×&Ñ&¨)Ñ3ó	ó	
÷ 	
÷ ÑÓð 	÷ Ü¨CÐ:JÈ8Ï=É=È/ÐYyÐ8zÔ{Ð{à×$Ñ$°4Ð$Ó8€KØ!×'Ñ'Ö)‰
ˆÜ�˜UÖ#ñ *ð �)‰)‹+×ÐØ
�*‰*�VÓ
×ÐØ€Mò- 8ñ	
ñ" ÙùsM   ‚F-šF$›C)F-ÄF'ÄF-ÄA%F-ÆF)ÆF-ÆF+ÆF-Æ'F-Æ)F-Æ+F-c                ó0   € V ^8„  d   QhR\         R\        /# )r/   r0   r4   )r   rs   )r6   s   "r7   r8   r8   ç   s   € ÷ (ñ (¤ð (´ñ (r9   c              ƒ   óz
  "  € V P                  \        \        4      P                  \        P                  R 8H  4      P                  \        P                  4      4      G Rj  x€L
 P                  4       P                  4       pV P                  \        \        4      P                  \        P                  R 8H  4      P                  \        P                  4      4      G Rj  x€L
 P                  4       P                  4       pV P                  \        \        4      P                  \        P                  R 8H  4      P                  \        P                  4      4      G Rj  x€L
 P                  4       P                  4       pV P                  \        \        4      P                  \        P                  R 8H  4      P                  \        P                  4      4      G Rj  x€L
 P                  4       P                  4       pV P                  \        \        4      P                  \        P                  R 8H  4      P                  \        P                  4      4      G Rj  x€L
 P                  4       P                  4       pV P                  \        \        4      P                  \        P                  R 8H  4      P                  \        P                  4      4      G Rj  x€L
 P                  4       P                  4       p/ pV F.  pVP!                  VP"                  . 4      P%                  V4       K0  	  V F$  p	VP'                  V	P"                  . 4      V	n        K&  	  V P                  \        \*        4      4      G Rj  x€L
 P                  4       P                  4       p
V P                  \        \,        4      4      G Rj  x€L
 P                  4       P                  4       pV P                  \        \.        4      4      G Rj  x€L
 P                  4       P                  4       p^ RIHp V P                  \        V4      P                  VP                  R 8H  4      4      G Rj  x€L
 P                  4       P                  4       pRTRTRTRTRTRV
 Uu. uF  pR	VP4                  R
VP6                  /NK  	  upRV Uu. uF  pR	VP4                  R
VP8                  /NK  	  upRV Uu. uF  pRVP"                  RVP8                  /NK  	  upRV/	#  EL® EL2 EL¶ EL: EL¾ ELB EL£ ELd EL% LÇu upi u upi u upi 5i)TN)ÚSeatModelConfigurationÚmodelsÚ
body_typesÚsegmentsÚrto_listÚfeaturesÚmodel_body_type_pairsÚmodel_idÚ
related_idÚmodel_segment_pairsÚfeature_segment_pairsÚ
feature_idÚ
segment_idÚseat_configs)rN   r	   r   rO   rS   r�   Úmodel_numberr�   r‘   r   ra   r   r   r   Úsequence_nor   Ú
setdefaultrÒ   rª   rk   Úoptionsr   r   r%   Úapp.models.dealer_modelsrÇ   rÎ   Úbody_type_idrÓ   )r0   rÈ   rÉ   rÊ   rË   Úfeature_rowsÚoption_rowsÚoptions_by_featureÚoÚfÚmbt_rowsÚms_rowsÚfs_rowsrÇ   rÔ   Úrs   &               r7   Úget_order_mastersrä   ç   s  é € Ø—J‘JÜÔ!Ó"×(Ñ(Ô);×)EÑ)EÈÑ)MÓN×WÑWÔXj×XwÑXwÓxó÷ ç�wƒy—‘“ð ð Ÿ
™
ÜŒ~Ó×$Ñ$¤^×%=Ñ%=ÀÑ%EÓF×OÑOÔP^×PcÑPcÓdó÷ ç�wƒy—‘“ð ð —j‘jÜÔ$Ó%×+Ñ+Ô,A×,KÑ,KÈtÑ,SÓT×]Ñ]Ô^s×^xÑ^xÓyó÷ ç�wƒy—‘“ð ð —j‘jÜŒyÓ×Ñ¤	× 3Ñ 3°tÑ ;Ó<×EÑEÄiÇnÁnÓUó÷ ç�wƒy—‘“ð ð Ÿ*™*ÜÔ#Ó$×*Ñ*Ô+?×+IÑ+IÈTÑ+QÓR×[Ñ[Ô\p×\|Ñ\|Ó}ó÷ ç�wƒy—‘“ð ð Ÿ™ÜÔ)Ó*×0Ñ0Ô1K×1UÑ1UÐY]Ñ1]Ó^×gÑgô  iC÷  iOñ  iOó  	Pó÷ ç�wƒy—‘“ð ð ÐÛˆØ×%Ñ% a§l¡l°BÓ7×>Ñ>¸qÖAñ ãˆØ&×*Ñ*¨1¯<©<¸Ó<ˆŽ	ñ ð —j‘j¤Ô(8Ó!9Ó:×:×CÑCÓE×IÑIÓK€HØ—Z‘Z¤¤Ó 7Ó8×8×AÑAÓC×GÑGÓI€GØ—Z‘Z¤Ô'8Ó 9Ó:×:×CÑCÓE×IÑIÓK€Gå?ØŸ*™*¤VÐ,BÓ%C×%IÑ%IÐJ`×JjÑJjÐnrÑJrÓ%sÓt×t×}Ñ}Ó÷  Dñ  Dó  F€Lð 	�&˜,¨
°JÀÈ*ÐV^Ø�LØÑbjÓ!kÑbjÐ]^ :¨q¯z©z¸<ÈÏÉÓ"XÑbjÑ!kØÑ^eÓfÑ^eÐYZ ¨Q¯Z©Z¸ÀqÇ|Á|Ó TÑ^eÑfØÑdkÓ!lÑdkÐ_` <°·±¸|ÈQÏ\É\Ó"ZÑdkÑ!lØ˜ðð òAòòòòòò ;Ú8Ú:ñ uùò
 "lùÚfùÚ!lùsç   ‚AT;Á!TÁ"A>T;Ã TÃ!A>T;ÅTÅ A>T;ÇTÇA>T;ÉTÉA>T;ËTËB!T;Í>T!Í?AT;Ï T$ÏAT;ÐT'ÐAT;Ñ"T*Ñ#/T;Ò#T,Ò5T;Ò<#T1ÓT;Ó&#T6"Ô	T;ÔT;ÔT;ÔT;ÔT;ÔT;Ô!T;Ô$T;Ô'T;Ô*T;Ô,T;c                ó$   € V ^8„  d   QhR\         /# rx   ry   )r6   s   "r7   r8   r8     s   € ÷ 1ñ 1œCñ 1r9   c                  óp   € R \         P                  ! 4       P                  R,          P                  4        2# )zDLO-r{   r}   r   r9   r7   Ú_generate_order_norç     r�   r9   c                óH   € V ^8„  d   QhR\         R\        R\        R\        /# ©r/   r0   rA   r¯   r4   )r   r5   r+   r   )r6   s   "r7   r8   r8     s)   € ÷ +ñ +œ<ð +´Cð +Ä+ð +ÔR]ñ +r9   c              ƒ   ó  "  € ^ RI Hp V P                  \        V4      P	                  VP
                  VP
                  8H  VP                  V8H  4      4      G Rj  x€L
 P                  4       pV'       g   \        RRR7      h\        WP                  4      G Rj  x€L
  VP                  '       g2   VP                  '       d   VP                  '       g   \        RRR7      h\        \        P                   ! 4       \#        4       TVP
                  VP                  '       d   RMR	VP$                  VP                  VP                  RVP                  '       d   RM\&        P(                  ! 4       R
7
      pV P+                  V4       V P-                  4       G Rj  x€L
  \/        WP0                  VP                  4      G Rj  x€L
  T P+                  \3        \        P                   ! 4       VP0                  VP                  '       d   RMR	RR7      4       V P5                  4       G Rj  x€L
  V P7                  V4      G Rj  x€L
  VP                  '       g!   \8        P:                  ! WRR7      G Rj  x€L
  V#  EL  ELã Læ LÀ L[ LD L5i)r   )r‰   NrŸ   z-Client not found or not mapped to this dealerr<   r´   ú;Representative name and contact are required for submissionÚDRAFTÚ	SUBMITTED)
Úorder_idÚorder_norA   r�   ÚstatusÚremarksÚrep_nameÚrep_contactÚ
billing_byÚsubmitted_atÚDRAFT_SAVEDT©Úidrî   ÚactionÚperformed_by_dealerF©Úis_resubmission)r‹   r‰   rN   r	   rO   r�   rA   rT   r   Ú_validate_vehiclesÚvehiclesÚis_draftrò   ró   r   rX   rY   rç   rñ   r   Úutcnowr]   r¸   Ú_write_vehiclesrî   r!   r^   r_   Únotifications_serviceÚnotify_order_submitted)r0   rA   r¯   r‰   Ú
map_recordÚorders   &&&   r7   Úcreate_orderr    sø  é € Ý7ØŸ
™
ÜˆÓ×%Ñ% o×&?Ñ&?À7×CTÑCTÑ&TÐVe×VoÑVoÐs|ÑV|Ó}ó÷ çÑÓð ÷ Ü¨Ð4cÔdÐdô ˜R×!1Ñ!1Ó
2×2Ð2à××ÐØ××Ð w×':×':Ð':Ü¨CÐ8uÔvÐväÜ—’“Ü#Ó%ØØ×#Ñ#Ø!×*×*Ð*‰w°Ø—‘Ø×!Ñ!Ø×'Ñ'ØØ$×-×-Ð-‘T´8·?²?Ó3Dô€Eð ‡F�Fˆ5„MØ
�(‰(‹*×Ðä
˜"Ÿn™n¨g×.>Ñ.>Ó
?×?Ð?à‡F�FÔ!Ü�:Š:‹< %§.¡.È'×JZ×JZÐJZ¹Ð`kð  BFôô ð �)‰)‹+×ÐØ
�*‰*�UÓ
×Ðà××ÐÜ#×:Ò:¸2ÐV[Ô\×\Ð\à€LòSò 3ñ& á?ñ Ùñ 	]ùs¥   ‚AJ
ÁI:ÁJ
Á5%J
ÂI=ÂJ
Â1J
ÃJ
ÃBJ
ÅA J
ÆJ Æ'J
ÇJÇA&J
È(JÈ)J
ÉJÉJ
ÉJ
É3JÉ4J
É=J
Ê J
ÊJ
ÊJ
ÊJ
ÊJ
c                óJ   € V ^8„  d   QhR\         R\        R\        R,          /# )r/   r0   rA   r�   Nr–   )r6   s   "r7   r8   r8   D  s%   € ÷ *ñ *œ,ð *´3ð *Ä3ÈÅ:ñ *r9   c              ƒ   óì  "  € \        \        \        P                  P	                  R 4      4      P                  \        \        P                  \        P                  8H  4      P                  \        P                  V8H  4      P                  \        P                  P                  4       4      pV'       d#   VP                  \        P                  V8H  4      pV P                  V4      G Rj  x€L
 P                  4       pV UUu. uF  w  rVVP                  NK  	  ppp/ p/ p	V'       Ed;   V P                  \        \        P                  \        P                   \        P"                  4      P                  \        P                  P%                  V4      4      4      G Rj  x€L
 P                  4       p
V
 Uu. uF  q»P                   NK  	  ppV
 FF  pV	P'                  VP                  ^ 4      VP"                  ;'       g    ^ ,           W›P                  &   KH  	  V'       EdD   V P                  \        \        P                  \(        P*                  4      P                  \(        \        P                   \(        P                   8H  4      P                  \        P                   P%                  V4      \(        P*                  P-                  R4      4      P                  \(        P.                  4      4      G Rj  x€L
 P                  4       pV FV  w  rïV'       g   K  VP1                  4       '       g   K'  VP3                  V. 4      P5                  VP1                  4       4       KX  	  . pV Fr  w  ppVVn        VP'                  VP                  . 4      pVVn        V	P'                  VP                  ^ 4      Vn        \=        V4      Vn        VP5                  V4       Kt  	  V#  ELõu uppi  ELJu upi  Lû5i)Úclient_nameN) r	   r   r   ra   r¨   rŒ   r�   rO   rA   r�   Ú
created_atÚdescrN   r‘   rî   r   Úorder_vehicle_idÚqtyÚin_rk   r   Ú
chassis_noÚisnotÚseq_norM   r×   rª   r	  Úchassis_nosÚ	total_qtyÚlenÚallocated_qty)r0   rA   r�   r’   r«   r  Ú_Ú	order_idsÚchassis_by_orderÚqty_by_orderÚvehsÚvÚov_idsÚc_rowsÚo_idÚc_noÚordersr	  Úc_lists   &&&                r7   Úlist_ordersr"  D  sö  é € äŒ{œL×-Ñ-×3Ñ3°MÓBÓCß	‰ŒlœK×1Ñ1´\×5KÑ5KÑKÓ	Lß	‰Œ{×$Ñ$¨	Ñ1Ó	2ß	‰”+×(Ñ(×-Ñ-Ó/Ó	0ð	 	÷ Ø�z‰zœ+×/Ñ/°9Ñ<Ó=ˆØ—*‘*˜TÓ"×"×'Ñ'Ó)€Dá04Ô5±¡H E�—”±€IÑ5ØÐØ€Lß€yØ—j‘jÜÔ%×.Ñ.Ô0B×0SÑ0SÔUg×UkÑUkÓlß‰UÔ%×.Ñ.×2Ñ2°9Ó=Ó>ó
÷ 
÷ ‰3‹5ð 	ñ /3Ó3©d¨×$Ô$©dˆÐ3ÛˆAØ'3×'7Ñ'7¸¿
¹
ÀAÓ'FÈ!Ï%É%Ï*È*ÐSTÕ'UˆLŸ™Ó$ñ ÷ ˆ6ØŸJ™JÜÔ)×2Ñ2Ô4M×4XÑ4XÓYß‘Ô/Ô1C×1TÑ1TÔXq÷  YCñ  YCñ  2Có  Dß‘Ô)×:Ñ:×>Ñ>¸vÓFÔHa×HlÑHl×HrÑHrÐswÓHxÓyß‘Ô3×:Ñ:Ó;ó	÷ ÷
 ‰s‹uð ó %‘
�ß‘4˜DŸJ™JŸLœLØ$×/Ñ/°°bÓ9×@Ñ@ÀÇÁÃÖNñ %ð €FÛ"Ñˆˆ{Ø'ˆÔØ!×%Ñ% e§n¡n°bÓ9ˆØ"ˆÔØ&×*Ñ*¨5¯>©>¸1Ó=ˆŒÜ! &›kˆÔØ�‰�eÖñ #ð €MòC #ùã5ò
ùò 4ñ
ùsi   ‚C*O4Ã,O!Ã-O4ÄO$ÄBO4Æ O*Æ!O4Æ7O-Ç4O4È !O4È"CO4Ë6O2Ë7O4ÌO4Ì2B0O4Ï$O4Ï-O4c                ó<   € V ^8„  d   QhR\         R\        R\        /# )r/   r0   r  r4   )r   r   )r6   s   "r7   r8   r8   q  s!   € ÷ *ñ *œ\ð *´+ð *Ä+ñ *r9   c              ƒ   óp
  "  € V P                  \        VP                  4      G R j  x€L
 pV'       d   VP                  MR Vn        V P                  \
        VP                  4      G R j  x€L
 pV'       d   VP                  MR Vn        V P                  \        \        4      P                  \        \        P                  4      4      P                  \        P                  VP                  8H  4      P!                  \        P"                  4      4      G R j  x€L
 P%                  4       P'                  4       pV P                  \        \(        4      4      G R j  x€L
 P%                  4       P'                  4        Uu/ uF  qUP*                  VP,                  bK  	  ppV P                  \        \.        4      4      G R j  x€L
 P%                  4       P'                  4        Uu/ uF  qwP0                  VP                  bK  	  ppV P                  \        \2        4      4      G R j  x€L
 P%                  4       P'                  4        U	u/ uF  q™P4                  V	P                  bK  	  p
p	V P                  \        \6        4      4      G R j  x€L
 P%                  4       P'                  4        Uu/ uF  q»P8                  VP                  bK  	  ppV Uu. uF  qÝP:                  NK  	  pp/ pV'       dÀ   V P                  \        \<        4      P                  \<        P:                  P?                  V4      4      P!                  \<        P@                  4      4      G R j  x€L
 P%                  4       P'                  4       pV F.  pVPC                  VP:                  . 4      PE                  V4       K0  	  V F¸  pVP                  VP*                  4      Vn#        VP                  VP0                  4      Vn$        V
P                  VP4                  4      Vn%        VP8                  '       d   VP                  VP8                  4      MR Vn&        VP                  VP:                  . 4      Vn'        Kº  	  WAn(        V P                  \        \R        4      P                  \R        P                  VP                  8H  4      P!                  \R        PT                  4      4      G R j  x€L
 P%                  4       P'                  4       Vn+        V#  ELÝ EL� ELò EL³u upi  ELVu upi  ELùu up	i  ELœu upi u upi  EL× LX5irj   ),rk   r   r�   ra   r	  r   rA   rJ   rN   r	   r   rØ   r   rÌ   rO   rî   r�   rÖ   r�   r‘   r   rÎ   rÕ   r   rÚ   r   rÓ   r   Úrto_idr  r   r  r  r×   rª   Ú
model_nameÚbody_type_nameÚsegment_nameÚrto_nameÚchassisrþ   r!   r
  Úactivity)r0   r  r¡   rG   rþ   ÚmÚ	model_mapÚbÚbody_type_mapÚsÚsegment_maprã   Úrto_mapr  Úvehicle_idsÚchassis_by_vehicleÚall_chassisr™   s   &&                r7   Ú_hydrate_orderr6  q  s§  é € Ø—6‘6œ,¨¯©Ó8×8€Fß'-˜Ÿš°4€EÔà—6‘6œ.¨%¯/©/Ó:×:€Fß'-˜Ÿš°4€EÔà—j‘jÜÔ!Ó"ß	‰”Ô0×9Ñ9Ó:Ó	;ß	‰Ô!×*Ñ*¨e¯n©nÑ<Ó	=ß	‰Ô$×0Ñ0Ó	1ó	÷ ÷
 �wƒy—‘“ð ð =?¿J¹JÄvÔN`ÓGaÓ<b×6b×5kÑ5kÓ5m×5qÑ5qÔ5sÓtÑ5s°—‘˜QŸ^™^Ò+Ñ5s€IÐtØ<>¿J¹JÄvÌnÓG]Ó<^×6^×5gÑ5gÓ5i×5mÑ5mÔ5oÓpÑ5o°—^‘^ Q§V¡VÒ+Ñ5o€MÐpØ8:¿
¹
Ä6ÔJ_ÓC`Ó8a×2a×1jÑ1jÓ1l×1pÑ1pÔ1rÓsÑ1r¨A—<‘< §¡Ò'Ñ1r€KÐsØ02·
±
¼6Ä)Ó;LÓ0M×*M×)VÑ)VÓ)X×)\Ñ)\Ô)^Ó_Ñ)^ A�x‰x˜Ÿ™ÒÑ)^€GÐ_á/7Ó8©x¨!×%Ô%©x€KÐ8ØÐßØŸZ™ZÜÔ,Ó-ß‰UÔ,×=Ñ=×AÑAÀ+ÓNÓOß‰XÔ/×6Ñ6Ó7ó
÷ 
÷ ‰7‹9—S‘S“Uð	 	ó
 ˆAØ×)Ñ)¨!×*<Ñ*<¸bÓA×HÑHÈÖKñ ó ˆØ —}‘} Q§Z¡ZÓ0ˆŒØ(×,Ñ,¨Q¯^©^Ó<ˆÔØ$Ÿ™¨¯©Ó6ˆŒØ./¯h¯h¨h�W—[‘[ §¡Ô*¸DˆŒ
Ø&×*Ñ*¨1×+=Ñ+=¸rÓBˆŽ	ñ ð „NØŸJ™JÜÔ%Ó&×,Ñ,Ô-C×-LÑ-LÐPU×P^ÑP^Ñ-^Ó_ß	‰Ô(×3Ñ3Ó	4ó÷ ÷ �wƒy—‘“ð 
„Nð €LòS 9ò ;òò 7cùÒtÚ6^ùÒpÚ2aùÒsÚ*MùÒ_ùâ8ò
ñ ùsê   ‚$T6¦T§T6³6T6Á)TÁ*T6Á6B!T6ÄT	ÄAT6ÅTÅ"T6Å<TÆ#T6Æ>TÆ?"T6Ç!TÈ #T6È#TÈ$"T6ÉTÉ%#T6ÊT$Ê	"T6Ê+T'Ë
T6ËT,Ë$A6T6ÍT1ÍF T6ÓT4Ó(T6ÔT6Ô	T6ÔT6ÔT6ÔT6ÔT6Ô'T6Ô4T6c                óZ   € V ^8„  d   QhR\         R\        \        P                  ,          /# )r/   r0   Úcurrent_order_id)r   r   rX   rh   )r6   s   "r7   r8   r8   ž  s&   € ÷ *ñ *¤ð *Ì8ÔTX×T]ÑT]ÕK^ñ *r9   c              ƒ   óè  "  € V P                  \        \        4      4      G R j  x€L
 P                  4       P	                  4        Uu0 uF  q3P
                  VP                  3kK  	  ppV P                  \        \        4      4      G R j  x€L
 P                  4       P	                  4        Uu0 uF  q3P
                  VP                  3kK  	  pp. pV EF  pVP
                  VP                  3V9  d   \        RRR7      hVP
                  VP                  3V9  d   \        RRR7      h\        VP                  4      VP                  8”  d   \        RRR7      hVP                  ;'       g    .  Fb  pVP                  '       g   K  VP                  P                  4       '       g   K9  VP                  VP                  P                  4       4       Kd  	  EK  	  \        V4      \        \!        V4      4      8w  d   \        RRR7      hV'       EdJ   \        \"        P                  \$        P&                  4      P)                  \*        \*        P,                  \"        P,                  8H  4      P)                  \$        \$        P.                  \*        P.                  8H  4      P1                  \"        P                  P3                  V4      \$        P4                  R8g  4      p	V'       d#   V	P1                  \$        P.                  V8g  4      p	V P                  V	4      G R j  x€L
 P7                  4       p
V
'       d#   \        RRV
^ ,           R	V
^,           R
2R7      hR # R #  EL<u upi  ELÞu upi  LP5i)Nr´   z0Selected body type is not offered for this modelr<   z.Selected segment is not offered for this modelz(Chassis count cannot exceed the quantityzMThe same chassis number cannot be specified multiple times in the same order.Ú	CANCELLEDúChassis ú& is already allocated to active order Ú.)rN   r	   r   r�   r‘   rÎ   rÚ   r   rÓ   r   r  r*  r  r  rM   rª   Úsetr   r   rï   rŒ   r   r  rî   rO   r  rð   r    )r0   rþ   r8  rã   Úvalid_body_typesÚvalid_segmentsÚsubmitted_chassis_nosr  r™   Úconflict_stmtÚconflicts   &&&        r7   rý   rý   ž  s¶  é € à57·Z±ZÄÔGWÓ@XÓ5Y×/Y×.bÑ.bÓ.d×.hÑ.hÔ.jóÙ.j¨�‰�Q—^‘^Ó$Ñ.jð ð ð 46·:±:¼fÄ_Ó>UÓ3V×-V×,_Ñ,_Ó,a×,eÑ,eÔ,góÙ,g q�‰�Q—\‘\Ó"Ñ,gð ð ð ÐÜˆØ�J‰J˜Ÿ™Ð'Ð/?Ô?Ü¨CÐ8jÔkÐkØ�J‰J˜Ÿ™Ð%¨^Ô;Ü¨CÐ8hÔiÐiÜˆq�y‰y‹>˜AŸE™EÔ!Ü¨CÐ8bÔcÐcØ—)‘)—/�/˜r’/ˆAØ�|�|Š| §¡× 2Ñ 2× 4Ô 4Ø%×,Ñ,¨Q¯\©\×-?Ñ-?Ó-AÖBô "ñ ô Ð Ó!¤S¬Ð-BÓ)CÓ%DÔDÜØØbô
ð 	
÷
 ÐäÔ,×7Ñ7¼×9MÑ9MÓNß‰TÔ$Ô&8×&IÑ&IÔMf×MwÑMwÑ&wÓxß‰T”+œ{×3Ñ3Ô7I×7RÑ7RÑRÓSß‰UÜ)×4Ñ4×8Ñ8Ð9NÓOÜ×"Ñ" kÑ1óð	 	÷ Ø)×/Ñ/´×0DÑ0DÐHXÑ0XÓYˆMØŸ*™* ]Ó3×3×:Ñ:Ó<ˆßÜØØ! (¨1¥+ Ð.TÐU]Ð^_ÕU`ÐTaÐabÐcôð ñ ñ ò/ 0Zùòò .WùòñB 4ùsl   ‚"M2¤M ¥"M2Á M#Á'#M2Â
M(Â"M2Â- M+ÃB!M2Å/M2Æ	M2Æ+A)M2ÈD
M2ÌM0Ì M2Ì:'M2Í#M2Í+M2c                óD   € V ^8„  d   QhR\         R\        P                  /# )r/   r0   rî   rg   )r6   s   "r7   r8   r8   Ë  s   € ÷ +ñ +œlð +´d·i±iñ +r9   c              ƒ   ód  "  € \        V4       EF–  w  r4\        \        P                  ! 4       VVP                  VP
                  VP                  VP                  VP                  VVP                  \        VR R4      \        VRR4      R7      pV P                  V4       V P                  4       G Rj  x€L
  . p\        VP                  ^R7       FØ  w  rxVP                  '       d!   VP                  P                  4       '       g   VP                   '       g   KK  VP                  '       d   VP                  P                  4       MRp	V	'       d   VP#                  V	4       V P                  \%        \        P                  ! 4       VP&                  VV	VP                   R7      4       KÚ  	  V'       dm   V P)                  \+        \,        4      P/                  \,        P                  P1                  V4      4      P3                  VP&                  R7      4      G Rj  x€L
  VP4                   Fs  p
V P                  \7        \        P                  ! 4       VP&                  V
P8                  V
P:                  V
P<                  V
P>                  V
P@                  R7      4       Ku  	  EK™  	  R#  ELø L‘5i)	Ú	is_editedFÚedited_fieldsN)r  rî   rÎ   rÚ   rÓ   r%  r  rÖ   ÚnotesrF  rG  )Ústart)rø   r  r  r  Úexpected_delivery_date©Údealer_order_vehicle_id)rø   r  rÒ   Úfeature_option_idÚ
bool_valueÚ
text_valueÚ	image_url)!Ú	enumerater   rX   rY   rÎ   rÚ   rÓ   r%  r  rH  Úgetattrr]   r¸   r*  r  rM   rJ  rª   r   r  rN   r   r   rO   r  ÚvaluesrÌ   r    rÒ   rM  rN  rO  rP  )r0   rî   rþ   Úir  ÚvehicleÚvalid_chassis_nosÚseqÚc_inputÚclean_noÚfeats   &&&        r7   r  r  Ë  sò  é € Ü˜(×#‰ˆÜ$Ü!ŸZšZ›\ØØ—Z‘ZØŸ™Ø—|‘|Ø—8‘8Ø—‘ØØ—'‘'Ü˜a ¨eÓ4Ü! ! _°dÓ;ô
ˆð 	�‰ˆwŒØ�h‰h‹j×ÐàÐÜ% a§i¡i°q×9‰LˆCØ×"×"Ð" w×'9Ñ'9×'?Ñ'?×'AÒ'AÀg×Fd×FdÒFdØ9@×9K×9KÐ9K˜7×-Ñ-×3Ñ3Ô5ÐQU�ßØ%×,Ñ,¨XÔ6Ø—‘Ô0Ü—z’z“|°g×6NÑ6NØØ'Ø+2×+IÑ+Iô	ö ñ :÷ Ø—*‘*Ü”}Ó%ß‘”}×/Ñ/×3Ñ3Ð4EÓFÓGß‘°×0HÑ0H�ÓIó÷ ð ð —J”JˆDØ�F‰FÔ,Ü—:’:“<°'×2JÑ2JØŸ?™?¸d×>TÑ>TØŸ?™?°t·±ÐRV×R`ÑR`ôö ô óK $ò 	ñ ùsF   ‚B1J0Â3J+Â4AJ0ÄJ0ÄJ0Ä.#J0ÅA"J0Æ5A'J0ÈJ.ÈBJ0Ê.J0c                ó\   € V ^8„  d   QhR\         R\        R\        P                  R\        /# ©r/   r0   rA   rî   r4   ©r   r5   rX   rh   r   )r6   s   "r7   r8   r8   ù  s-   € ÷ +ñ +œ|ð +¼ð +ÄtÇyÁyð +ÔU`ñ +r9   c              ƒ   óÀ   "  € V P                  \        V4      G R j  x€L
 pV'       d   VP                  V8w  d   \        RRR7      h\	        W4      G R j  x€L
 #  L= L5i©NrŸ   úOrder not foundr<   )rk   r   rA   r   r6  ©r0   rA   rî   r  s   &&& r7   Úget_order_detailrb  ù  sL   é € Ø—&‘&œ hÓ/×/€Eß�E—O‘O yÔ0Ü¨Ð4EÔFÐFÜ Ó*×*Ð*ñ 0ñ +ùs&   ‚AœA�A©,AÁAÁAÁAc                ó\   € V ^8„  d   QhR\         R\        R\        P                  R\        /# r\  r]  )r6   s   "r7   r8   r8      s-   € ÷ +ñ +¤ð +¼ð +ÌÏ	É	ð +ÔVañ +r9   c           	   ƒ   ó*  "  € V P                  \        V4      G R j  x€L
 pV'       d   VP                  V8w  d   \        RRR7      hVP                  R8w  d   \        RRR7      hRVn        V P                  \        \        P                  ! 4       VP                  RR	R
7      4       V P                  4       G R j  x€L
  V P                  V4      G R j  x€L
  \        P                  ! W4      G R j  x€L
  \        W4      G R j  x€L
 #  Lì LP L9 L L5i)NrŸ   r`  r<   ÚPENDING_DEALER_ACKr´   z:Only orders awaiting your acknowledgement can be confirmedÚPENDING_FINAL_CONFIRMATIONÚDEALER_ACKNOWLEDGEDTr÷   )rk   r   rA   r   rð   r]   r!   rX   rY   rî   r^   r_   r  Ú#notify_order_acknowledged_by_dealerr6  ra  s   &&& r7   Úacknowledge_orderri     s×   é € Ø—&‘&œ hÓ/×/€Eß�E—O‘O yÔ0Ü¨Ð4EÔFÐFØ‡|�|Ð+Ô+Ü¨Ð4pÔqÐqà/€E„Là‡F�FÔ!Ü�:Š:‹< %§.¡.Ð9NÐdhôô ð �)‰)‹+×ÐØ
�*‰*�UÓ
×ÐÜ
×
CÒ
CÀBÓ
N×NÐNÜ Ó*×*Ð*ñ 0ñ ÙÙNÙ*ùs]   ‚DœD	�D©BDÂ:DÂ;DÃDÃDÃ1DÃ2DÄDÄDÄDÄDÄDÄDc                ó\   € V ^8„  d   QhR\         R\        R\        P                  R\        /# r\  r]  )r6   s   "r7   r8   r8     s3   € ÷ C+ñ C+œð C+´#ð C+ÄÇÁð C+ÔXcñ C+r9   c           	   ƒ   ób  "  € V P                  \        V4      G R j  x€L
 pV'       d   VP                  V8w  d   \        RRR7      hVP                  R8X  d   \        RRR7      h\        WP                  VR7      G R j  x€L
  VP                  '       g2   VP                  '       d   VP                  '       g   \        RRR7      hV P                  \        \        4      P                  \        \        P                  4      4      P!                  \        P"                  V8H  4      P%                  \        P&                  4      4      G R j  x€L
 P)                  4       P+                  4       pV Uu/ uF  qfP&                  VbK  	  pp\-        VP                  4       EF9  w  r‰R	p
. pVP                  V4      pV'       g=   R
p
. R"OV	P                   Uu. uF  p\/        VP0                  4      NK  	  up,           pEMVP2                  ;'       g    . p\/        VP4                  4      \/        V	P4                  4      8w  d   R
p
RV9  d   VP7                  R4       \/        VP8                  4      \/        V	P8                  4      8w  d   R
p
RV9  d   VP7                  R4       \/        VP:                  4      \/        V	P:                  4      8w  d   R
p
RV9  d   VP7                  R4       VP<                  V	P<                  8w  d   R
p
RV9  d   VP7                  R4       VP                   Uu/ uF  p\/        VP0                  4      VbK  	  ppV	P                   EFu  pVP                  \/        VP0                  4      4      pR	pV'       g   R
pMò\/        VP>                  ;'       g    R4      \/        VP>                  ;'       g    R4      8w  g°   \A        VPB                  4      \A        VPB                  4      8w  gƒ   \/        VPD                  ;'       g    R4      \/        VPD                  ;'       g    R4      8w  gB   \/        VPF                  ;'       g    R4      \/        VPF                  ;'       g    R4      8w  d   R
pV'       g   EK2  R
p
\/        VP0                  4      V9  g   EKQ  VP7                  \/        VP0                  4      4       EKx  	  \I        V4      \I        V	P                  4      8w  d   V
'       g   R
p
W©n%        W¹n        V
'       g   EKx  VP                  R8w  g   EKŒ  . p. pV F‘  pVR8X  d   VP7                  R4       K  VR8X  d   VP7                  R4       K7  VR8X  d   VP7                  R4       KQ  VR8X  d   VP7                  R4       Kk   VP7                  \L        PN                  ! V4      4       K“  	  V'       d‘   ^ RI(H)p V P                  \        V4      P!                  VP0                  PU                  V4      4      4      G R j  x€L
 P)                  4       P+                  4       pV F  pVP7                  VPV                  4       K   	  V'       d   RRPY                  V4       R2MRpRV^,            V R2pVPZ                  '       g   VVn-        EK	  VVPZ                  9  g   EK  V;PZ                  RV 2,          un-        EK<  	  V Uu. uF  qfP\                  NK  	  ppV'       dc   V P                  \_        \`        4      P!                  \`        Pb                  PU                  V4      4      Pe                  R R7      4      G R j  x€L
  V F­  pV P                  \f        Ph                  Pk                  4       P!                  \f        P\                  V8H  4      4      G R j  x€L
  V P                  \l        Ph                  Pk                  4       P!                  \l        P\                  V8H  4      4      G R j  x€L
  K¯  	  V P                  \        Ph                  Pk                  4       P!                  \        P"                  V8H  4      4      G R j  x€L
  \o        WVP                  4      G R j  x€L
  VPZ                  e   VPZ                  Vn-        VP                  e   VP                  Vn        VP                  e   VP                  Vn	        VP                  '       d   RVn        RpM>VP                  R8X  d%   RVn        \p        Pr                  ! 4       Vn:        RpM	RVn        RpV Pw                  \y        \L        Pz                  ! 4       VP"                  VR
R 7      4       V P}                  4       G R j  x€L
  V P                  V4      G R j  x€L
  VP                  '       g$   \€        P‚                  ! WVR8H  R!7      G R j  x€L
  \…        W4      G R j  x€L
 #  E	LÓ E	Ls ELªu upi u upi u upi     EKß  ; i ELúu upi  EL¿ ELh EL ELÀ EL¥ L� L† LS LB5i)#NrŸ   r`  r<   Ú	CONFIRMEDr´   z4This order is already confirmed and cannot be edited)r8  rë   FTÚmodelÚ	body_typeÚsegmentr  r;   rì   ÚModelz	Body TypeÚSegmentÚQuantity)r   z (z, Ú)zDealer edited Config r=  Ú
rK  rö   rí   ÚDEALER_EDITEDr÷   rû   )rm  rn  ro  r  )Crk   r   rA   r   rð   rý   rþ   rÿ   rò   ró   rN   r	   r   rØ   r   rÌ   rO   rî   r�   rÖ   r�   r‘   rQ  r5   rÒ   rG  rÎ   rª   rÚ   rÓ   r  rM  r²   rN  rO  rP  r  rF  rX   rh   rÙ   r   r  Úfeature_namerŒ   rñ   r  r   r   rL  rS  r    Ú	__table__r   r   r  r   r   rõ   r]   r!   rY   r^   r_   r  r  r6  )r0   rA   rî   r¯   r  Úold_vehiclesr  Ú	old_v_maprW  Úp_vehrF  rG  Úold_vrß   Ú	old_f_mapÚpfÚold_fÚis_f_editedÚedited_namesÚfeature_ids_to_fetchÚfieldr   ÚfeatsÚ
edited_strÚ
new_remarkÚold_vehicle_idsÚvidrù   s   &&&&                        r7   Ú
edit_orderrˆ    s�  é € Ø—&‘&œ hÓ/×/€Eß�E—O‘O yÔ0Ü¨Ð4EÔFÐFØ‡|�|�{Ô"Ü¨Ð4jÔkÐkä
˜R×!1Ñ!1ÀHÔ
M×MÐMà××ÐØ××Ð w×':×':Ð':Ü¨CÐ8uÔvÐvàŸ*™*ÜÔ!Ó"ß	‰”Ô0×9Ñ9Ó:Ó	;ß	‰Ô!×*Ñ*¨hÑ6Ó	7¿¹ÔAS×A_ÑA_Ó8`ó÷ ÷ �wƒy—‘“ð	 ñ ,8Ó8©< a—‘ Ò!©<€IÐ8ä × 0Ñ 0×1‰
ˆØˆ	ØˆØ—‘˜cÓ"ˆçØˆIÚDÐch×cqÒcqÓGrÑcqÐ^_ÌÈAÏLÉLÖHYÑcqÑGrÕrŠMà!×/Ñ/×5Ð5°2ˆMÜ�5—>‘>Ó"¤c¨%¯.©.Ó&9Ô9Ø �	Ø -Ô/°×1EÑ1EÀgÔ1NÜ�5×%Ñ%Ó&¬#¨e×.@Ñ.@Ó*AÔAØ �	Ø mÔ3°]×5IÑ5IÈ+Ô5VÜ�5×#Ñ#Ó$¬¨E×,<Ñ,<Ó(=Ô=Ø �	Ø MÔ1°=×3GÑ3GÈ	Ô3RØ�y‰y˜EŸI™IÔ%Ø �	Ø Ô-¨}×/CÑ/CÀEÔ/Jà7<·~²~ÓF±~°!œ˜QŸ\™\Ó*¨AÒ-±~ˆIÐFØ—n•n�Ø!Ÿ™¤c¨"¯-©-Ó&8Ó9�Ø#�ßØ"&‘KÜ˜×0Ñ0×6Ð6°BÓ7¼3¸r×?SÑ?S×?YÐ?YÐWYÓ;ZÔZÔ^bÐch×csÑcsÓ^tÔx|Ð}÷  ~Kñ  ~Kó  yLô  _Lô  PSð  TY÷  Tdñ  Td÷  Tjð  Tjð  hjó  Pkô  orð  su÷  s@ñ  s@÷  sFð  sFð  DFó  oGô  PGô  KNð  OT÷  O^ñ  O^÷  Odð  Odð  bdó  Keô  ilð  mo÷  myñ  my÷  mð  mð  }ó  i@ô  K@Ø"&�Kß’;Ø $�IÜ˜2Ÿ=™=Ó)°×>À×@TÑ@TÔUXÐY[×YfÑYfÓUg×@hñ %ô �9‹~¤ U§^¡^Ó!4Ô4¿YØ �	à#ŒØ+ÔßŠ9˜Ÿ™¨×0ØˆLØ#%Ð Û&�Ø˜GÔ# \×%8Ñ%8¸Ö%AØ˜kÔ)¨<×+>Ñ+>¸{Ö+KØ˜iÔ'¨×)<Ñ)<¸YÖ)GØ˜e”^ \×%8Ñ%8¸Ö%DðØ,×3Ñ3´D·I²I¸eÓ4DÖEñ '÷ $ÝIØ!Ÿz™z¬&Ð1EÓ*F×*LÑ*LÐMa×MlÑMl×MpÑMpð  rFó  NGó  +Hó   I÷  I÷  Rñ  Ró  T÷  Xñ  Xó  Z�Û�AØ ×'Ñ'¨¯©Ö7ñ ÷ =I˜2˜dŸi™i¨Ó5Ð6°aÑ8ÈbˆJØ0°°qµ°	¸*¸ÀQÐGˆJØ—?—?�?Ø",�—Ø 7§?¡?×2Ø—’ R¨
 |Ð#4Õ4—�ñE 2ñH 4@Ó@±<¨a×)Ô)±<€OÐ@ßØ�j‰jÜ”=Ó!ß‰U”=×8Ñ8×<Ñ<¸_ÓMÓNß‰V¨DˆVÓ1ó
÷ 	
ð 	
ó
 ˆØ�j‰jÔ2×<Ñ<×CÑCÓE×KÑKÔLe×LvÑLvÐz}ÑL}Ó~Ó×ÐØ�j‰jÔ2×<Ñ<×CÑCÓE×KÑKÔLe×LvÑLvÐz}ÑL}Ó~Ó×Òñ ð �*‰*Ô'×1Ñ1×8Ñ8Ó:×@Ñ@ÔAS×A\ÑA\Ð`hÑAhÓiÓ
j×jÐjä
˜"¨×(8Ñ(8Ó
9×9Ð9à‡�Ò"ØŸ™ˆŒØ×ÑÒ#Ø ×)Ñ)ˆŒØ×ÑÒ&Ø#×/Ñ/ˆÔà××ÐØˆŒØ‰à�<‰<˜7Ô"Ø&ˆEŒLÜ!)§¢Ó!2ˆEÔØ ‰Fà*ˆEŒLØ$ˆFà‡F�FÔ!Ü�:Š:‹< %§.¡.¸ÐUYôô ð �)‰)‹+×ÐØ
�*‰*�UÓ
×Ðà××ÐÜ#×:Ò:¸2ÐW]ÐapÑWpÔr×rÐrä Ó*×*Ð*òE 0ò Nòùò 9ùò Hsùò  Gøð:Ûúò Iùò Aò	
ò 	@ÚÚjâ9ñ0 Ùñ 	sá*ùsÂ  ‚h/œg/�h/©Ah/Á?g2Â h/Âh/Â(h/Â:Bh/Åg5Å$h/Å0g8ÆAh/Çg=Ç0h/ÈDh/Ì)hÍAh/Î#h/ÏAh/Ðh/Ð/"h/Ñh/Ñ0h/Òh/Ò'Ah/Ó;h/Ôh/Ô(A1h/Ö%hÖ?h/×Ah/ØhØAh/Ù#7h/Úh/Ú9%h/ÛhÛ2A'h/ÝhÝAh/Þ3hÞ4Ah/àhà	Ah/á!h!á"h/á?h$â A2h/ã3Bh/æ	h'æ
h/æ"h)æ#h/æ9h/çh+çh/ç*h-ç+h/ç2h/ç5h/ç8h/èhè	h/èh/èh/èh/è!h/è$h/è'h/è)h/è+h/è-h/c          	      ór   € V ^8„  d   QhR\         R\        R,          R\        R,          R\        R,          /# )r/   r0   rð   Nr�   rA   r–   )r6   s   "r7   r8   r8   š  sB   € ÷ /ñ /¤Lð /¼#À½*ð /ÔX[Ð^bÕXbð /Ôvyð  }Aõ  wAñ /r9   c              ƒ   ó	  "  € \        \        \        P                  P	                  R 4      \
        P                  P	                  R4      4      P                  \        \        P                  \        P                  8H  4      P                  \
        \        P                  \
        P                  8H  4      P                  \        P                  P                  4       4      pV'       d#   VP                  \        P                  V8H  4      pV'       d#   VP                  \        P                  V8H  4      pV'       d#   VP                  \        P                  V8H  4      pV P                  V4      G Rj  x€L
 P!                  4       pV UUu. uF  vrgVP"                  NK  	  ppp/ p	/ p
V'       Ed<   V P                  \        \$        P"                  \$        P&                  \$        P(                  4      P                  \$        P"                  P+                  V4      4      4      G Rj  x€L
 P!                  4       pV Uu. uF  qÌP&                  NK  	  ppV FF  pV
P-                  VP"                  ^ 4      VP(                  ;'       g    ^ ,           W¬P"                  &   KH  	  V'       EdE   V P                  \        \$        P"                  \.        P0                  4      P                  \.        \$        P&                  \.        P&                  8H  4      P                  \$        P&                  P+                  V4      \.        P0                  P3                  R4      4      P                  \.        P4                  4      4      G Rj  x€L
 P!                  4       pV FW  w  ppV'       g   K  VP7                  4       '       g   K(  V	P9                  V. 4      P;                  VP7                  4       4       KY  	  . pV Fz  w  pppVVn        VVn        V	P-                  VP"                  . 4      pVVn         V
P-                  VP"                  ^ 4      Vn!        \E        V4      Vn#        VP;                  V4       K|  	  V#  ELýu uppi  ELSu upi  EL5i)r	  rJ   N)$r	   r   r   ra   r¨   r   rŒ   r�   rA   rW   r�   r
  r  rO   rð   rN   r‘   rî   r   r  r  r  rk   r   r  r  r  rM   r×   rª   r	  rJ   r  r  r  r  )r0   rð   r�   rA   r’   r«   r  r  r  r  r  r  r  r  r  r  r  r   r	  rJ   r!  s   &&&&                 r7   Úlist_orders_for_staffr‹  š  sV  é € äŒ{œL×-Ñ-×3Ñ3°MÓBÄN×DWÑDW×D]ÑD]Ð^kÓDlÓmß	‰ŒlœK×1Ñ1´\×5KÑ5KÑKÓ	Lß	‰Œnœk×3Ñ3´~×7QÑ7QÑQÓ	Rß	‰”+×(Ñ(×-Ñ-Ó/Ó	0ð	 	÷ Ø�z‰zœ+×,Ñ,°Ñ6Ó7ˆßØ�z‰zœ+×/Ñ/°9Ñ<Ó=ˆßØ�z‰zœ+×/Ñ/°9Ñ<Ó=ˆØ—*‘*˜TÓ"×"×'Ñ'Ó)€Dá15Ô6± I E�—”±€IÑ6ØÐØ€Lß€yØ—j‘jÜÔ%×.Ñ.Ô0B×0SÑ0SÔUg×UkÑUkÓlß‰UÔ%×.Ñ.×2Ñ2°9Ó=Ó>ó
÷ 
÷ ‰3‹5ð 	ñ /3Ó3©d¨×$Ô$©dˆÐ3ÛˆAØ'3×'7Ñ'7¸¿
¹
ÀAÓ'FÈ!Ï%É%Ï*È*ÐSTÕ'UˆLŸ™Ó$ñ ÷ ˆ6ØŸJ™JÜÔ)×2Ñ2Ô4M×4XÑ4XÓYß‘Ô/Ô1C×1TÑ1TÔXq÷  YCñ  YCñ  2Có  Dß‘Ô)×:Ñ:×>Ñ>¸vÓFÔHa×HlÑHl×HrÑHrÐswÓHxÓyß‘Ô3×:Ñ:Ó;ó	÷ ÷
 ‰s‹uð ó %‘
��dß‘4˜DŸJ™JŸLœLØ$×/Ñ/°°bÓ9×@Ñ@ÀÇÁÃÖNñ %ð €FÛ+/Ñ'ˆˆ{˜KØ'ˆÔØ'ˆÔØ!×%Ñ% e§n¡n°bÓ9ˆØ"ˆÔØ&×*Ñ*¨5¯>©>¸1Ó=ˆŒÜ! &›kˆÔØ�‰�eÖñ ,0ð €MòE #ùã6ò
ùò 4ò
ùsu   ‚DRÄ)RÄ;6RÅ1Q.Å2RÆ	Q1ÆBRÈ$Q7È%RÈ;Q:É4RÊ!RÊ&CRÍ:Q?Í;RÎRÎ7B8RÑ1RÑ:Rc                óP   € V ^8„  d   QhR\         R\        P                  R\        /# )r/   r0   rî   r4   ©r   rX   rh   r   )r6   s   "r7   r8   r8   Ì  s%   € ÷ +ñ +¬ð +ÄÇÁð +Ì{ñ +r9   c              ƒ   óž   "  € V P                  \        V4      G R j  x€L
 pV'       g   \        RRR7      h\        W4      G R j  x€L
 #  L, L5ir_  )rk   r   r   r6  )r0   rî   r  s   && r7   Úget_order_detail_for_staffr�  Ì  sA   é € Ø—&‘&œ hÓ/×/€EßÜ¨Ð4EÔFÐFÜ Ó*×*Ð*ñ 0ñ +ùs&   ‚AœA	�A©AÁAÁAÁAc                óp   € V ^8„  d   QhR\         R\        P                  R\        P                  R\        /# ©r/   r0   Úadmin_idrî   r4   r�  )r6   s   "r7   r8   r8   Ó  s1   € ÷ +ñ +œLð +´D·I±Ið +ÌÏÉð +ÔWbñ +r9   c           
   ƒ   ó  "  € V P                  \        V4      G R j  x€L
 pV'       g   \        RRR7      hVP                  R9  d   \        RRR7      hRVn        V P	                  \        \        P                  ! 4       VP                  RRVR	7      4       V P                  4       G R j  x€L
  V P                  V4      G R j  x€L
  \        P                  ! WVR
7      G R j  x€L
  \        W4      G R j  x€L
 #  LÞ LR L; L L5i)NrŸ   r`  r<   r´   z=Only newly submitted or dealer-edited orders can be confirmedre  ÚSALES_CONFIRMEDF©rø   rî   rù   rú   Úperformed_by_user_id)r’  )rí   ru  )rk   r   r   rð   r]   r!   rX   rY   rî   r^   r_   r  Únotify_order_confirmed_by_salesr6  ©r0   r’  rî   r  s   &&& r7   Úconfirm_orderr™  Ó  sÑ   é € Ø—&‘&œ hÓ/×/€EßÜ¨Ð4EÔFÐFØ‡|�|Ð9Ô9Ü¨Ð4sÔtÐtà'€E„LØ‡F�FÔ!Ü�:Š:‹< %§.¡.Ð9JØ!¸ôô ð �)‰)‹+×ÐØ
�*‰*�UÓ
×ÐÜ
×
?Ò
?ÀÐT\Ô
]×]Ð]Ü Ó*×*Ð*ñ 0ñ ÙÙ]Ù*ùs]   ‚DœC;�D©BDÂ*C=Â+DÃC?ÃDÃ#DÃ$DÃ6DÃ7DÃ=DÃ?DÄDÄDc                ól   € V ^8„  d   QhR\         R\        R\        R\        R\        R\        R\        /# )r/   r0   rA   Úrequest_typerr   Ú	photo_urlÚ
photo_urlsr4   ©r   r5   Úlistr"   )r6   s   "r7   r8   r8   ä  sJ   € ÷ ñ ¤Lð ¼Sð ÔPSð Ô^að Ônqð ô  GKð ô  Wdñ r9   c           
   ƒ   óø   "  € \        \        P                  ! 4       TTTTT;'       g    . R R7      pV P                  V4       V P	                  4       G Rj  x€L
  V P                  V4      G Rj  x€L
  V#  L L5i)ÚPENDING)Ú
request_idrA   r›  rr   rœ  r�  rð   N)r"   rX   rY   r]   r^   r_   )r0   rA   r›  rr   rœ  r�  Únew_requests   &&&&&& r7   Úcreate_dealer_requestr¤  ä  so   é € ÜÜ—:’:“<ØØ!ØØØ×#Ð# Øô€Kð ‡F�Fˆ;ÔØ
�)‰)‹+×ÐØ
�*‰*�[Ó
!×!Ð!ØÐñ Ù!ùs$   ‚AA:ÁA6ÁA:Á/A8Á0A:Á8A:c                óR   € V ^8„  d   QhR\         R\        R\        \        ,          /# )r/   r0   rA   r4   rž  )r6   s   "r7   r8   r8   ó  s&   € ÷ (ñ (¤<ð (¼Cð (ÄDÌÕDWñ (r9   c              ƒ   ó>  "  € V P                  \        \        4      P                  \        P                  V8H  4      P                  \        P                  P                  4       4      4      G R j  x€L
 p\        VP                  4       P                  4       4      #  L+5irj   )rN   r	   r"   rO   rA   r�   r
  r  rŸ  r�   r‘   )r0   rA   rc   s   && r7   Úlist_dealer_requestsr§  ó  sp   é € Ø—:‘:ÜŒ}Óß	‰Œ}×&Ñ&¨)Ñ3Ó	4ß	‰”-×*Ñ*×/Ñ/Ó1Ó	2ó÷ €Fô
 �—‘Ó ×$Ñ$Ó&Ó'Ð'ñùs   ‚A-BÁ/BÁ0,Bc                ó\   € V ^8„  d   QhR\         R\        R\        P                  R\        /# )r/   r0   rA   r¢  r4   )r   r5   rX   rh   r"   )r6   s   "r7   r8   r8   ü  s-   € ÷ ñ ¤ð ¼#ð Ì4Ï9É9ð ÔYfñ r9   c              ƒ   óš   "  € V P                  \        V4      G R j  x€L
 pV'       d   VP                  V8w  d   \        RRR7      hV#  L,5i)NrŸ   zRequest not foundr<   )rk   r"   rA   r   )r0   rA   r¢  Úrequests   &&& r7   Úget_dealer_requestr«  ü  s@   é € Ø—F‘Fœ=¨*Ó5×5€Gß�g×'Ñ'¨9Ô4Ü¨Ð4GÔHÐHØ€Nñ 6ùs   ‚AœA	�A©!Ac                ó‚   € V ^8„  d   QhR\         R\        R\        R\        R,          R\        R\        P                  /# )r/   r0   rA   Úinclude_sparesr�   NÚ	yard_onlyr4   )r   r5   r²   r-   ÚDealerChassisListResponse)r6   s   "r7   r8   r8     sV   € ÷ sñ sÜðsäðsô ðsô �T�zð	sô
 ðsô ×&Ñ&ñsr9   c              ƒ   ó4  "  € ^ RI Hp V P                  \        V4      G Rj  x€L
 p\	        \
        P                  4      P                  \        \        P                  \
        P                  8H  4      P                  \        \        P                  \        P                  8H  4      P                  \        P                  V8H  4      P                  \
        P                  P                  R4      4      p\        P                  V8H  pV'       d?   V\        P                   V8H  \        P                   P#                  R4      ,          ,          pV! V\        P                  P%                  V4      4      p	V'       dc   V! V	\        P                  P#                  R4      \        P&                  R8H  \        P&                  P#                  R4      ,          ,          4      p	V'       de   V	\        P(                  P+                  R4      \        P,                  R8g  ,          \        P&                  P/                  . R$O4      ,          ,          p	\	        \        \0        P2                  P5                  R4      \6        P8                  P5                  R4      4      P;                  \0        \        P<                  \0        P<                  8H  4      P;                  \6        \        P                   \6        P                   8H  4      P                  V	4      P?                  \        P(                  PA                  4       \        PB                  PA                  4       4      p
V PE                  V
4      G Rj  x€L
 PG                  4       pV UUu. uF4  w  p qÜP                  '       g   K  VP                  PI                  4       NK6  	  ppp/ pV'       Edí   \	        \
        P                  \        P                  \        PJ                  \        PL                  P5                  R	4      4      P                  \        \        P                  \
        P                  8H  4      P                  \        \        P                  \        P                  8H  4      P                  \
        P                  P%                  V4      4      P                  \        PL                  R
8g  4      pV PE                  V4      G Rj  x€L
 PG                  4        FZ  pVP                  '       d   VP                  PI                  4       MRpRVP                  RVPJ                  R	VPN                  /VV&   K\  	  V EFY  w  p pVP                  '       d   VP                  PI                  4       MRpVV9  g   K?  VPP                  '       g   KS  \	        \        P                  \        PJ                  \        PL                  4      P                  \        \        P                  \        P                  8H  4      P                  \        P                  VPP                  8H  4      P                  \        PL                  R
8g  4      pV PE                  V4      G Rj  x€L
 PS                  4       pV'       g   EK9  RV^ ,          RV^,          R	V^,          /VV&   EK\  	  V UUu. uF  w  p qÜPT                  NK  	  ppp/ pV'       Edï   \	        \V        PX                  \V        PT                  4      P                  \V        PT                  P%                  V4      4      pV PE                  V4      G Rj  x€L
 PG                  4       pV Uu/ uF  pVPX                  VPT                  bK  	  ppV'       EdE   \	        \Z        4      P                  \Z        PX                  P%                  \]        VP_                  4       4      4      \Z        P`                  R8H  \Z        Pb                  R8H  4      pV PE                  V4      G Rj  x€L
 Pe                  4       PG                  4       pV F“  pVP                  VPX                  4      pV'       g   K(  VPg                  V. 4      Pi                  \j        Pl                  ! VPn                  VPp                  ;'       g    RVPr                  VPt                  R7      4       K•  	  . p^ p^ p ^ p!V EFï  w  pp"p#VP&                  ;'       g    Rp$V$R8X  d   V^,          pM!V$R8X  d   V ^,          p MV$R8X  d
   V!^,          p!VP                  '       d   VP                  PI                  4       MRpVP                  V/ 4      p%\w        V%P                  R4      4      p&VPi                  \j        Px                  ! R%/ RVPT                  bRVP                  bRVP                  bRV#bRVP<                  bRV"bRVPz                  bRVP|                  bRVP(                  bRVP~                  bRVP€                  bRVP‚                  bRVP„                  bRVP,                  bRV$bRVP†                  bRVPˆ                  bR VPB                  bRV%P                  R4      bRV%P                  R4      bR	V%P                  R	4      bR!V&bR"VP                  VPT                  . 4      b 4       EKò  	  \j        PŠ                  ! \�        V4      VV V!VVPŽ                  R#7      #  E
LÓ EL•u uppi  EL# EL˜u uppi  ELËu upi  EL5i)&r   )Úor_NÚ
CHASSIS_INÚHANDED_TO_PRODUCTIONÚWIPÚ
DISPATCHEDr&  r	  Úorder_statusr:  r;   rî   rï   FÚMANUFACTURING)Úitem_noÚ	item_textÚauthority_namerñ   Ú
chassis_idr  rA   rÎ   Ú	fuel_typeÚvoltageÚarrival_dateÚda_lite_statusÚda_lite_remarksÚda_lite_photo_urlÚda_lite_checked_atÚcurrent_statusÚtracking_statusÚdispatch_photo_urlÚdispatched_atr
  Úis_allocatedÚmanufacturing_defects)ÚtotalÚchassis_in_countÚ	wip_countÚdispatched_countr¿   rK   ©r´  ÚREADY_FOR_DISPATCHrµ  r   )HÚ
sqlalchemyr±  rk   r   r	   r   r  rŒ   r   r  r   rî   rO   rA   Úis_notr   r�   Úis_r  rÄ  r¾  r  rÃ  Únotin_r   rÕ   r¨   r   ra   r©   rÎ   r�   r  r
  rN   r‘   rM   rï   rð   r¶  rL  r    r»  r   Úchecksheet_idr   rŸ  ÚkeysÚis_okÚ
fault_typer�   r×   rª   r-   ÚManufacturingDefectItemr¸  r¹  rº  rñ   r²   ÚDealerChassisItemr¼  r½  r¿  rÀ  rÁ  rÂ  rÅ  rÆ  r¯  r  rK   )'r0   rA   r­  r�   r®  r±  rG   Úallocated_chassis_subqÚbase_conditionÚwhere_clauser’   r«   r*  r  r  Úchassis_order_mapÚorder_chassis_stmtrã   Ú
c_no_cleanÚov_stmtÚov_rowÚchassis_idsÚmfg_defects_mapÚcs_stmtÚcs_rowsÚchecksheet_id_mapÚ
items_stmtÚdefect_itemsÚdiÚcidr¿   rÊ  rË  rÌ  r&  r	  rð   Ú
order_infoÚhas_active_orders'   &&&&&                                  r7   Úget_dealer_chassisrì    s	  é € õ à—6‘6œ.¨)Ó4×4€Fô 	Ô(×3Ñ3Ó4ß	‰Ô Ô"4×"EÑ"EÔIb×IsÑIsÑ"sÓ	tß	‰Œkœ;×/Ñ/Ô3E×3NÑ3NÑNÓ	Oß	‰Œ{×$Ñ$¨	Ñ1Ó	2ß	‰Ô(×3Ñ3×:Ñ:¸4Ó@Ó	Að ô #×,Ñ,°	Ñ9€NßØ'¬M×,CÑ,CÀyÑ,PÔUb×UlÑUl×UpÑUpÐquÓUvÕ+wÕxˆáØÜ× Ñ ×$Ñ$Ð%;Ó<ó€L÷
 ÙØÜ×$Ñ$×(Ñ(¨Ó.´M×4QÑ4QÐUaÑ4aÔfs÷  gDñ  gD÷  gHñ  gHð  IMó  gNõ  4Oõ  Pó
ˆ÷
 Ø#Ü×&Ñ&×,Ñ,¨TÓ2Ü×+Ñ+Ð/EÑEõGä×,Ñ,×3Ñ3Ò4_Ó`õbõ
ˆô 	ÜÜ×+Ñ+×1Ñ1°,Ó?Ü×Ñ×#Ñ# MÓ2ó	
÷
 
‰Ô%¤}×'=Ñ'=ÔAS×A\ÑA\Ñ'\Ó	]ß	‰”<¤×!8Ñ!8¼L×<RÑ<RÑ!RÓ	Sß	‰ˆ|Ó	ß	‰”-×,Ñ,×1Ñ1Ó3´]×5MÑ5M×5RÑ5RÓ5TÓ	Uð 	ð —*‘*˜TÓ"×"×'Ñ'Ó)€Dñ DHÔ^Á4±-°'¸1¸a×K]ÕK]Ô-�7×%Ñ%×+Ñ+Ö-Á4€KÑ^Ø)+Ðß€{äÜ)×4Ñ4Ü×$Ñ$Ü×$Ñ$Ü×"Ñ"×(Ñ(¨Ó8ó	÷ ‰TÔ$Ô&8×&IÑ&IÔMf×MwÑMwÑ&wÓxß‰T”+œ{×3Ñ3Ô7I×7RÑ7RÑRÓSß‰UÔ,×7Ñ7×;Ñ;¸KÓHÓIß‰U”;×%Ñ%¨Ñ4Ó5ð 	ð Ÿ
™
Ð#5Ó6×6×;Ñ;Ö=ˆAØ12··°˜Ÿ™×+Ñ+Ô-À2ˆJà˜AŸJ™JØ˜AŸJ™JØ §¡ð-Ð˜jÓ)ñ >ô "‰MˆG�Q˜Ø7>×7I×7IÐ7I˜×+Ñ+×1Ñ1Ô3ÈrˆJØÐ!2Ö2°w×7V×7VÒ7Väœ;×/Ñ/´×1EÑ1EÄ{×GYÑGYÓZß‘TÔ,Ô.@×.IÑ.IÌ[×MaÑMaÑ.aÓbß‘UÔ-×>Ñ>À'×BaÑBaÑaÓbß‘Uœ;×-Ñ-°Ñ<Ó=ð	 ð !#§
¡
¨7Ó 3×3×:Ñ:Ó<�ß’6à" F¨1¥IØ" F¨1¥IØ&¨¨q­	ð5Ð% jÔ1ñ "ñ$ <@Ô@¹4©-¨'°1°a×%Ô%¹4€KÑ@Ø€Oß€{äÜ%×3Ñ3Ü%×0Ñ0ó
÷ ‰%Ô)×4Ñ4×8Ñ8¸ÓEÓ
Fð 	ð Ÿ™ GÓ,×,×1Ñ1Ó3ˆÙDKÓLÁG¸q˜QŸ_™_¨a¯l©lÒ:ÁGÐÐLçÐäÔ =Ó>×DÑDÜ-×;Ñ;×?Ñ?ÄÐEV×E[ÑE[ÓE]Ó@^Ó_Ü-×3Ñ3°uÑ<Ü-×8Ñ8¸OÑKóˆJð
 #%§*¡*¨ZÓ"8×8×AÑAÓC×GÑGÓIˆLÛ"�Ø'×+Ñ+¨B×,<Ñ,<Ó=�ß‘3Ø#×.Ñ.¨s°BÓ7×>Ñ>Ü×7Ò7Ø$&§J¡JØ&(§l¡l×&8Ð&8°bØ+-×+<Ñ+<Ø$&§J¡Jô	öñ #ð €EØÐØ€IØÐä,0Ñ(ˆ�˜[Ø×(Ñ(×8Ð8¨LˆØ�\Ô!Ø Õ!ÑØ�uŒ_Ø˜�N‰IØ�|Ô#Ø Õ!Ðà3:×3E×3EÐ3E�W×'Ñ'×-Ñ-Ô/È2ˆ
Ø&×*Ñ*¨:°rÓ:ˆ
Ü 
§¡¨zÓ :Ó;Ðà�‰”W×.Ò.ò 
Ø×)Ò)ð
à×)Ò)ð
ð ×'Ò'ð
ñ $ð	
ð
 ×%Ò%ð
ñ "ð
ð ×'Ò'ð
ð —O’Oð
ð !×-Ò-ð
ð #×1Ò1ð
ð $×3Ò3ð
ð &×7Ò7ð
ð  '×9Ò9ð
ð #×1Ò1ð
ñ #ð
ð   '×9Ò9ð!
ð" "×/Ò/ð#
ð$ ×)Ò)ð%
ð&  —^‘^ JÔ/ð'
ð(  —^‘^ JÔ/ð)
ð* $Ÿ™¨Ô7ð+
ñ, *ð-
ð. #2×"5Ñ"5°g×6HÑ6HÈ"Ô"Mð/
÷ 	ñ -1ôN ×,Ò,Ü�%‹jØ)ØØ)ØØ%×<Ñ<ôð òG 5òV #ùó _ò 7ò$ 4ùó Aò -ùÚLò 9ùsÖ   ‚ l¢k5£ElÅ9A)lÇ#F lÍ#k8Í$lÍ;k;Îk;Î5D)lÓlÓB,lÖlÖ$ClÙ,lÙ-lÚ
*lÚ4lÛA6lÝlÝlÝ lÝ9BlàlàAláAlâ"A
lã-Alä4Glë8lë;lìlìlìlc                óp   € V ^8„  d   QhR\         R\        P                  R\        P                  R\        /# r‘  r�  )r6   s   "r7   r8   r8   ¸  s1   € ÷ +ñ +¤,ð +¼$¿)¹)ð +ÌtÏyÉyð +Ô]hñ +r9   c           
   ƒ   ó>  "  € V P                  \        V4      G R j  x€L
 pV'       g   \        RRR7      hVP                  R8w  d   \        RRR7      hRVn        \        P
                  ! 4       Vn        V P                  \        \        P                  ! 4       VP                  RR	VR
7      4       V P                  4       G R j  x€L
  V P                  V4      G R j  x€L
  \        P                  ! W4      G R j  x€L
  \!        W4      G R j  x€L
 #  Lö LP L9 L L5i)NrŸ   r`  r<   rf  r´   z(Order is not awaiting final confirmationrl  ÚSALES_FINAL_CONFIRMEDFr•  )rk   r   r   rð   r   r   Úconfirmed_atr]   r!   rX   rY   rî   r^   r_   r  Únotify_order_final_confirmedr6  r˜  s   &&& r7   Úfinal_confirm_orderrò  ¸  sÝ   é € Ø—&‘&œ hÓ/×/€EßÜ¨Ð4EÔFÐFØ‡|�|Ð3Ô3Ü¨Ð4^Ô_Ð_à€E„LÜ!ŸšÓ*€EÔØ‡F�FÔ!Ü�:Š:‹< %§.¡.Ð9PØ!¸ôô ð �)‰)‹+×ÐØ
�*‰*�UÓ
×ÐÜ
×
<Ò
<¸RÓ
G×GÐGÜ Ó*×*Ð*ñ 0ñ ÙÙGÙ*ùs]   ‚DœD�D©BDÃDÃDÃDÃDÃ;DÃ<DÄDÄDÄDÄDÄDÄDc                ó°   € V ^8„  d   QhR\         R\        P                  R,          R\        P                  R\        R\        R\
        R,          R\        /# )	r/   r0   Úuser_idNrî   ÚallocationsÚ	is_dealerrA   r4   )r   rX   rh   rs   r²   r5   r   )r6   s   "r7   r8   r8   Ê  sh   € ÷ Z+ñ Z+ÜðZ+ä�Y‰Y˜ÕðZ+ô �i‰iðZ+ô ð	Z+ô
 ðZ+ô �T�zðZ+ô ñZ+r9   c              ƒ   óˆ  "  € V P                  \        V4      G R j  x€L
 pV'       g   \        RRR7      hV'       d=   VP                  V8w  d   \        RRR7      hVP                  R8w  d   \        RRR7      h^ R	IHp ^ R
IHp . p	VP                  4        FO  w  r«V FD  pV'       g   K  VP                  4       '       g   K%  V	P                  VP                  4       4       KF  	  KQ  	  \        V	4      \        \        V	4      4      8w  d   \        RRR7      hV	'       Ed:   \        \        P                   \        P"                  4      P%                  \&        \&        P(                  \        P(                  8H  4      P%                  \        \        P*                  \&        P*                  8H  4      P-                  \        P                   P/                  V	4      \        P*                  VP*                  8g  \        P                  R8g  4      pV P1                  V4      G R j  x€L
 P3                  4       pV'       d#   \        RRV^ ,           RV^,           R2R7      h/ pV	'       d¡   V P1                  \        V4      P-                  VP                   P/                  V	4      4      4      G R j  x€L
 P5                  4       P7                  4       pV F4  pVP                   '       g   K  VVVP                   P                  4       &   K6  	  VP                  4        EF#  w  r«\8        P:                  ! V
4      pV P                  \&        V4      G R j  x€L
 pV'       d   VP*                  VP*                  8w  d   \        RRV
 2R7      h\=        R V 4       4      pVVP>                  8”  d   \        RRV RVP>                   R2R7      hV EFn  pV'       d   VP                  4       '       g   K$  VP                  4       pVP                  V4      pV'       g   \        RRV R2R7      hVP@                  '       g   \        RRV R2R7      hVPB                  R8X  d   \        RRV R2R7      hVPD                  R%9   d   \        RRV RVPD                   R2R7      hV'       d?   VP                  '       d-   VP                  VP                  8w  d   \        RRV R2R7      hVPF                  '       g   EK-  VPF                  '       g   EKB  VPF                  VPF                  8w  g   EK`  \        RRV R2R7      h	  EK&  	  VP                  4        EF.  w  r«\8        P:                  ! V
4      pV P1                  \        \        P                   4      P-                  \        P(                  V8H  4      4      G R j  x€L
 P5                  4       P7                  4       pV'       dX   V P1                  V! V4      P-                  VP                   P/                  V4      4      PI                  R R7      4      G R j  x€L
  V P1                  \        PJ                  PM                  4       P-                  \        P(                  V8H  4      4      G R j  x€L
  . p\O        V4       F  w  ppV'       d   VP                  4       '       g   K&  VP                  4       pVP                  V4       V PQ                  \        \8        PR                  ! 4       VV^,           VR7      4       K�  	  V'       g   EK×  V P1                  V! V4      P-                  VP                   P/                  V4      4      PI                  VR7      4      G R j  x€L
  EK1  	  T PQ                  \U        \8        PR                  ! 4       VP*                  RTV'       g   TMR R \        V	4       R!V'       d   R"MR# 2R$7      4       V PW                  4       G R j  x€L
  V PY                  V4      G R j  x€L
  \[        W4      G R j  x€L
 #  EL	 EL	 EL€ ELã EL| EL EL² LÂ LG L0 L5i)&NrŸ   r`  r<   i“  z1Not authorized to allocate chassis for this orderrl  r´   z1Chassis can only be allocated to confirmed orders)r   )r   z:The same chassis number cannot be allocated multiple timesr:  r;  r<  r=  zInvalid vehicle configuration c              3   óh   "  € T F(  q'       g   K  VP                  4       '       g   K$  ^x € K*  	  R# 5i)é   N)rM   )Ú.0r™   s   & r7   Ú	<genexpr>Ú)allocate_order_chassis.<locals>.<genexpr>  s   é € ÐE¡\ ³Qœ!¸1¿7¹7¿9Ÿ!š!£\ùs   ‚	2�2¨
2zCannot allocate more chassis (z) than vehicle quantity (rs  z not found in inventoryzV has not arrived in the yard yet. Only chassis currently in the yard can be allocated.r³  zD has already been handed over to production and cannot be allocated.z3 is currently in production or dispatched (status: zX) and cannot be allocated. Only chassis currently available in the yard can be selected.z belongs to another dealer.z6 model does not match the vehicle model specification.rK  )rø   r  r  r  ÚCHASSIS_ALLOCATEDz
Allocated z chassis by rG   Úsales©rø   rî   rù   rú   r–  rH  rÍ  ).rk   r   r   rA   rð   Úapp.models.yard_modelsr   rÏ  r   r¿   rM   rª   r  r>  r	   r   r  rï   rŒ   r   r  rî   rO   r  rN   r    r�   r‘   rX   rh   Úsumr  r¾  rÃ  rÄ  rÎ   rS  rw  r   rQ  r]   rY   r!   r^   r_   r6  )r0   rô  rî   rõ  rö  rA   r  r   r   Úall_alloc_chassis_nosÚ	ov_id_strÚchassis_listÚch_norB  rC  Úchassis_recordsÚch_rowsÚchÚov_idÚovÚvalid_countrY  Úold_chassis_nosrV  rT  r  s   &&&&&&                    r7   Úallocate_order_chassisr  Ê  s9  é € ð —&‘&œ hÓ/×/€EßÜ¨Ð4EÔFÐFçØ�?‰?˜iÔ'Ü¨CÐ8kÔlÐlØ�<‰<˜;Ô&Ü¨CÐ8kÔlÐlå4Ý!ð ÐØ#.×#4Ñ#4Ö#6Ñˆ	Û!ˆEß‰u˜Ÿ™ŸœØ%×,Ñ,¨U¯[©[«]Ö;ó "ñ $7ô Ð Ó!¤S¬Ð-BÓ)CÓ%DÔDÜ¨Ð4pÔqÐq÷ ÐäÔ,×7Ñ7¼×9MÑ9MÓNß‰TÔ$Ô&8×&IÑ&IÔMf×MwÑMwÑ&wÓxß‰T”+œ{×3Ñ3Ô7I×7RÑ7RÑRÓSß‰UÜ)×4Ñ4×8Ñ8Ð9NÓOÜ×$Ñ$¨¯©Ñ6Ü×"Ñ" kÑ1óð	 	ð Ÿ*™* ]Ó3×3×:Ñ:Ó<ˆßÜØØ! (¨1¥+ Ð.TÐU]Ð^_ÕU`ÐTaÐabÐcôð ð 13€OßØŸ™Ü�=Ó!×'Ñ'¨×(@Ñ(@×(DÑ(DÐEZÓ([Ó\ó
÷ 
ç‰7‹9—S‘S“Uð 	ó ˆBØ�}�}Š}Ø9;� §¡× 3Ñ 3Ó 5Ó6ñ ð
 $/×#4Ñ#4×#6Ñˆ	Ü—	’	˜)Ó$ˆØ—6‘6Ô,¨eÓ4×4ˆß�R—[‘[ E§N¡NÔ2Ü¨CÐ:XÐYbÐXcÐ8dÔeÐeäÑE¡\ÓEÓEˆØ˜Ÿ™ÔÜ¨CÐ:XÐYdÐXeÐe~ð  @B÷  @Fñ  @Fð  Gð  GHð  9Iô  Jð  Jä!ˆEß §¡§¢ÙØ—{‘{“}ˆHØ ×$Ñ$ XÓ.ˆBßÜ#°¸hÀxÀjÐPgÐ<hÔiÐið —?—?�?Ü#Ø #Ø% h Zð  0Fð  Gôð ð × Ñ Ð$:Ô:Ü#Ø #Ø% h ZÐ/sÐtôð ð ×!Ñ!Ð%PÔPÜ#Ø #Ø% h ZÐ/bÐce×cuÑcuÐbvð  wOð  Pôð ÷ ˜RŸ\Ÿ\˜\¨b¯l©l¸e¿o¹oÔ.MÜ#Ø #Ø% h ZÐ/JÐKôð ð �{�{‹{˜rŸ{Ÿ{›{¨r¯{©{¸b¿k¹k×/IÜ#Ø #Ø% h ZÐ/eÐfôð ôM "ñ $7ðl $/×#4Ñ#4×#6Ñˆ	Ü—	’	˜)Ó$ˆð "$§¡¬FÔ3L×3WÑ3WÓ,X×,^Ñ,^Ô_x÷  `Jñ  `Jð  NSñ  `Só  -Tó  "U÷  U÷  ^ñ  ^ó  `÷  dñ  dó  fˆßØ—*‘*™V MÓ2×8Ñ8¸×9QÑ9Q×9UÑ9UÐVeÓ9fÓg×nÑnð  HLÐnó  Mó  N÷  Nð  Nð �j‰jÔ2×<Ñ<×CÑCÓE×KÑKÔLe×LvÑLvÐzÑLó  Aó  B÷  	Bð  	BàÐÜ& |Ö4‰MˆAˆzß Z×%5Ñ%5×%7Ò%7ÙØ!×'Ñ'Ó)ˆHØ×$Ñ$ XÔ.Ø�F‰FÔ,Ü—:’:“<Ø!&Ø˜•sØ#ô	ö ñ 5÷ ÒØ—*‘*™V MÓ2×8Ñ8¸×9QÑ9Q×9UÑ9UÐVgÓ9hÓi×pÑpð  JOÐpó  Pó  Q÷  Qó  Qñ5 $7ð8 ‡F�FÔ!Ü�:Š:‹<Ø—‘Ø"Ø%ß,5™W¸4Øœ3Ð4Ó5Ð6°lÏyÁ8Ð^eÐBfÐgôô ð �)‰)‹+×ÐØ
�*‰*�UÓ
×ÐÜ Ó*×*Ð*òe 0òH 4ò
ò 5òp Uò Nò 	Bñ" Qñ ÙÙ*ùsF  ‚aœ`%�a©a¾A)aÂ,aÃAaÄ#C<aÈ`(È aÈ:+aÉ&AaÊ+`+Ê,4aË%A&aÍ`.ÍaÍBaÏ(*aÐ"aÐ6A)aÒ aÒ2;aÓ3aÔaÔ&BaÖ5`1Ö6'a×AaØ0`4Ø1AaÚ`7Ú4aÚ;A$aÜ%AaÝ7`:Ý8A<aß4`<ß5aà`>àaà a à!aà(aà+aà.aà1aà4aà7aà:aà<aà>aá ac                ó„   € V ^8„  d   QhR\         R\        P                  R\        P                  R\        P                  /# )r/   r0   rÎ   rÚ   rÓ   rg   )r6   s   "r7   r8   r8   h  s@   € ÷ \ñ \¬ð \ÄÇÁð \ÔZ^×ZcÑZcð \Ôqu×qzÑqzñ \r9   c              ƒ   ó  "  € V P                  \        V4      G R j  x€L
 pV P                  \        V4      G R j  x€L
 pV P                  \        V4      G R j  x€L
 pV'       d   V'       d	   V'       g   \	        RRR7      hR #  Lg LK L/5i)Nr´   z$Invalid model, body type, or segmentr<   )rk   r   r   r   r   )r0   rÎ   rÚ   rÓ   r,  r.  r0  s   &&&&   r7   Ú_verify_model_body_segmentr  h  se   é € Ø�f‰fÔ'¨Ó2×2€AØ�f‰f”^ \Ó2×2€AØ�f‰fÔ*¨JÓ7×7€Aß—AŸQÜ¨Ð4ZÔ[Ð[ñ ñ 	3Ù2Ù7ùsC   ‚B
œB�B
ºB»B
ÁBÁB
Á%B
Á-B
Á5B
ÂB
ÂB
c                ó0   € V ^8„  d   QhR\         R\        /# r•   r–   )r6   s   "r7   r8   r8   p  s   € ÷ ñ ¤\ð ¼cñ r9   c              ƒ   óT  "  € \        \        4      P                  \        P                  V8H  4      P	                  \        P
                  P                  4       4      pV P                  V4      G R j  x€L
 P                  4       P                  4       p. pV Fˆ  p\        \        4      P                  \        P                  VP                  8H  4      pV P                  V4      G R j  x€L
 P                  4       P                  4       pWun        VP                  V4       KŠ  	  V#  L² L?5irj   )r	   r#   rO   rA   r�   r
  r  rN   r�   r‘   r$   Útemplate_idrÌ   rª   )r0   rA   r’   r«   Ú	templatesÚrowÚ	feat_stmtrÌ   s   &&      r7   Úlist_vehicle_templatesr  p  sè   é € äÔ$Ó%ß	‰Ô$×.Ñ.°)Ñ;Ó	<ß	‰Ô'×2Ñ2×7Ñ7Ó9Ó	:ð 	ð
 —*‘*˜TÓ"×"×+Ñ+Ó-×1Ñ1Ó3€DØ€IÛˆÜÔ7Ó8×>Ñ>Ô?[×?gÑ?gÐkn×kzÑkzÑ?zÓ{ˆ	ØŸ*™* YÓ/×/×8Ñ8Ó:×>Ñ>Ó@ˆØŒØ×Ñ˜Öñ	 ð
 Ðñ #ñ 0ùs%   ‚A/D(Á1D$Á2A4D(Ã&D&Ã'>D(Ä&D(c                óp   € V ^8„  d   QhR\         R\        R\        P                  R\        P                  /# ré   )r   r5   r-   ÚVehicleTemplateCreateÚVehicleTemplateOut)r6   s   "r7   r8   r8     s=   € ÷  ñ  ¤lð  ¼sð  ÌW×MjÑMjð  Ôov÷  pJñ  pJñ  r9   c              ƒ   óÊ  "  € \         P                  ! 4       p\        WP                  VP                  VP
                  4      G R j  x€L
  \        VVVP                  VP                  VP                  VP
                  R7      pV P                  V4       . pVP                   F|  p\        \         P                  ! 4       VVP                  VP                  VP                  VP                  VP                  R7      pV P                  V4       VP!                  V4       K~  	  V P#                  4       G R j  x€L
  V P%                  V4      G R j  x€L
  WTn	        V#  EL L( L5i)N)r  rA   ra   rÎ   rÚ   rÓ   ©rø   r  rÒ   rM  rN  rO  rP  )rX   rY   r  rÎ   rÚ   rÓ   r#   ra   r]   rÌ   r$   rÒ   rM  rN  rO  rP  rª   r^   r_   )r0   rA   r¯   Útpl_idr  rÌ   rß   Úf_rows   &&&     r7   Úcreate_vehicle_templater    s  é € Ü�ZŠZ‹\€Fä
$ R×)9Ñ)9¸7×;OÑ;OÐQX×QcÑQcÓ
d×dÐdä
ØØØ�\‰\Ø×!Ñ!Ø×)Ñ)Ø×%Ñ%ô€Cð ‡F�Fˆ3„Kà€HØ×ÔˆÜ,Ü�zŠz‹|ØØ—|‘|Ø×1Ñ1Ø—|‘|Ø—|‘|Ø—k‘kô
ˆð 	�‰ˆuŒØ�‰˜Öñ ð �)‰)‹+×ÐØ
�*‰*�S‹/×ÐØ„LØ€Jò; eñ4 Ùùs7   ‚AE#ÁEÁC/E#Ä6EÄ7E#ÅE!ÅE#ÅE#Å!E#c          
      ó�   € V ^8„  d   QhR\         R\        R\        P                  R\        P
                  R\        P                  /# )r/   r0   rA   r  r¯   r4   )r   r5   rX   rh   r-   r  r  )r6   s   "r7   r8   r8   ¢  sX   € ÷ 'ñ '¤lð '¼sð 'ÔQU×QZÑQZð 'Ôel÷  fCñ  fCð 'ô  HO÷  Hbñ  Hbñ 'r9   c              ƒ   ó  "  € V P                  \        \        4      P                  \        P                  V8H  \        P
                  V8H  4      4      G R j  x€L
 pV'       g   \        RRR7      h\        WP                  VP                  VP                  4      G R j  x€L
  VP                  Vn        VP                  Vn        VP                  Vn	        VP                  Vn
        V P                  \        \        4      P                  \        P                  V8H  4      4      G R j  x€L
  . pVP                   F|  p\        \         P"                  ! 4       VVP$                  VP&                  VP(                  VP*                  VP,                  R7      pV P/                  V4       VP1                  V4       K~  	  V P3                  4       G R j  x€L
  V P5                  V4      G R j  x€L
  WTn        V#  ELž ELY LÑ L- L5i)NrŸ   úTemplate not foundr<   r  )Úscalarr	   r#   rO   r  rA   r   r  rÎ   rÚ   rÓ   ra   rN   r   r$   rÌ   rX   rY   rÒ   rM  rN  rO  rP  r]   rª   r^   r_   )r0   rA   r  r¯   ÚtplrÌ   rß   r  s   &&&&    r7   Úupdate_vehicle_templater%  ¢  s›  é € à—	‘	œ&Ô!6Ó7×=Ñ=Ü×)Ñ)¨[Ñ8Ü×'Ñ'¨9Ñ4óó ÷ €C÷ Ü¨Ð4HÔIÐIä
$ R×)9Ñ)9¸7×;OÑ;OÐQX×QcÑQcÓ
d×dÐdà�|‰|€C„HØ×#Ñ#€C„LØ×+Ñ+€CÔØ×'Ñ'€C„Nð �*‰*”VÔ8Ó9×?Ñ?Ü$×0Ñ0°KÑ?óó ÷ ð ð
 €HØ×ÔˆÜ,Ü�zŠz‹|Ø#Ø—|‘|Ø×1Ñ1Ø—|‘|Ø—|‘|Ø—k‘kô
ˆð 	�‰ˆuŒØ�‰˜Öñ ð �)‰)‹+×ÐØ
�*‰*�S‹/×ÐØ„LØ€JòKò eññ& Ùùsb   ‚AH ÁG4ÁH Á#;H ÂG7ÂB	H Ä(G:Ä)B%H ÇG<ÇH Ç'G>Ç(H Ç7H Ç:H Ç<H Ç>H c                óP   € V ^8„  d   QhR\         R\        R\        P                  /# )r/   r0   rA   r  )r   r5   rX   rh   )r6   s   "r7   r8   r8   Ì  s(   € ÷ "ñ "¤lð "¼sð "ÔQU×QZÑQZñ "r9   c              ƒ   ó¶  "  € V P                  \        V4      G R j  x€L
 pV'       d   VP                  V8w  d   \        RRR7      hV P	                  \
        P                  P                  4       P                  \
        P                  V8H  4      4      G R j  x€L
  V P                  V4      G R j  x€L
  V P                  4       G R j  x€L
  RR/#  L´ L; L$ L5i)NrŸ   r"  r<   ÚmessageÚDeleted)rk   r#   rA   r   rN   r$   rw  r   rO   r  r^   )r0   rA   r  Útemplates   &&& r7   Údelete_vehicle_templater+  Ì  sÃ   é € Ø—V‘VÔ1°;Ó?×?€Hß�x×)Ñ)¨YÔ6Ü¨Ð4HÔIÐIà
�*‰*Ô1×;Ñ;×BÑBÓD×JÑJÔKg×KsÑKsð  xCñ  LCó  Dó  E÷  Eð  EØ
�)‰)�HÓ
×ÐØ
�)‰)‹+×ÐØ�yÐ!Ð!ñ @ñ EÙÙùsK   ‚CœC�C©A.CÂCÂCÂ0CÂ1CÃCÃ		CÃCÃCÃCc                ó$   € V ^8„  d   QhR\         /# )r/   Úremarkry   )r6   s   "r7   r8   r8   Ö  s   € ÷ :ñ :¼#ñ :r9   c              ƒ   óX  "  € V P                  \        V4      G R j  x€L
 pV'       g   \        RRR7      hW4n        V P	                  \        \        P                  ! 4       VP                  RRVVR7      4       V P                  4       G R j  x€L
  \        W4      G R j  x€L
 #  L‡ L L5i)NrŸ   r`  r<   ÚREMARKFrÿ  )rk   r   r   rñ   r]   r!   rX   rY   rî   r^   r�  )r0   rô  rî   r-  r  s   &&&& r7   Úadd_order_remarkr0  Ö  sŠ   é € Ø—&‘&œ hÓ/×/€EßÜ¨Ð4EÔFÐFà„Mà‡F�FÔ!Ü�:Š:‹<Ø—‘ØØ!Ø$Øôô ð �)‰)‹+×ÐÜ+¨BÓ9×9Ð9ñ! 0ñ Ù9ùs9   ‚B*œB$�B*©A#B*ÂB&ÂB*ÂB(Â B*Â&B*Â(B*c                ó$   € V ^8„  d   QhR\         /# )r/   rô   ry   )r6   s   "r7   r8   r8   ê  s   € ÷ :ñ :¼Cñ :r9   c              ƒ  óÂ  "  € VR9  d   \        RRR7      hV P                  \        V4      G Rj  x€L
 pV'       g   \        RRR7      hVP                  R8X  d   \        RRR7      hW4n        V P                  \        \        P                  ! 4       VP                  R	R
VRV 2R7      4       V P                  4       G Rj  x€L
  \        W4      G Rj  x€L
 #  L¨ L L5i)z?Set billing_by on an order. Locked once the order is CONFIRMED.r´   z'billing_by must be 'DEALER' or 'CLIENT'r<   NrŸ   r`  rl  z9Billing By cannot be changed after the order is confirmedÚBILLING_BY_SETFzBilling by set to rÿ  )ÚDEALERÚCLIENT)r   rk   r   rð   rô   r]   r!   rX   rY   rî   r^   r�  )r0   rô  rî   rô   r  s   &&&& r7   Úset_billing_byr6  ê  sÃ   é € àÐ-Ô-Ü¨Ð4]Ô^Ð^Ø—&‘&œ hÓ/×/€EßÜ¨Ð4EÔFÐFØ‡|�|�{Ô"Ü¨Ð4oÔpÐpØ!ÔØ‡F�FÔ!Ü�:Š:‹<Ø—‘ØØ!Ø$Ø" : ,Ð/ôô ð �)‰)‹+×ÐÜ+¨BÓ9×9Ð9ñ 0ñ Ù9ùs9   ‚.C°C±C½BCÃCÃCÃCÃCÃCÃCc          
      ó€   € V ^8„  d   QhR\         R\        R\        \        ,          R\        \        ,          R\        /# )r/   r0   rA   rI  Úendr4   )r   r5   r   Úobjectrs   )r6   s   "r7   r8   r8      sH   € ÷ Jñ J¤<ð J¼Cð JÌÔQWÕHXð JÔfnÔouÕfvð Jô  CGñ Jr9   c              ƒ   óD  "  € ^ RI HpHp ^ RIHpHp ^ RIHpHp	 T;'       g    VP                  4       p
T;'       g    V
\        ^R7      ,
          pWº8”  d   \        RRR7      h\        P                  ! W¹P                  \        P                  R7      p\        P                  ! W©P                   \        P                  R7      pV P#                  \%        \&        VP(                  P+                  R	4      4      P-                  V\&        P.                  VP.                  8H  4      P1                  \&        P2                  V8H  4      P5                  \&        P6                  P9                  4       4      4      G R
j  x€L
 pVP;                  4       p\=        V4      p\?        R V 4       4      p\?        R V 4       4      p\?        R V 4       4      pV P#                  \%        \@        PB                  ! 4       4      PE                  V4      P1                  VP2                  V8H  VPF                  R8H  4      4      G R
j  x€L
 PI                  4       ;'       g    ^ pV P#                  \%        \@        PB                  ! 4       4      PE                  V4      P1                  VP2                  V8H  VPF                  R8H  4      4      G R
j  x€L
 PI                  4       ;'       g    ^ pV P#                  \%        \@        PB                  ! 4       4      PE                  V4      P1                  VP2                  V8H  VPF                  R8H  4      4      G R
j  x€L
 PI                  4       ;'       g    ^ pV P#                  \%        \@        PB                  ! 4       4      PE                  V4      P1                  VP2                  V8H  VPJ                  PM                  Wº4      4      4      G R
j  x€L
 PI                  4       ;'       g    ^ pV P#                  \%        \@        PB                  ! 4       4      PE                  V4      P1                  VP2                  V8H  VPN                  PM                  WÍ4      4      4      G R
j  x€L
 PI                  4       ;'       g    ^ pV P#                  \%        \@        PB                  ! 4       4      PE                  V4      P1                  VP2                  V8H  4      4      G R
j  x€L
 PI                  4       ;'       g    ^ pRVRVRVRVRVRVRVRVRVRV/
pV P#                  \%        \@        PP                  ! VPR                  R4      P+                  R4      \@        PB                  ! 4       P+                  R4      4      PE                  V4      PU                  WwPV                  VPV                  8H  4      P1                  VP2                  V8H  4      PY                  R4      P5                  \@        PB                  ! 4       P9                  4       4      4      G R
j  x€L
 P;                  4       p\?        R V 4       4      pRTR V Uu. uFK  pRVPZ                  R!VP\                  R"V'       d%   \_        VP\                  V,          ^d,          ^4      M^ /NKM  	  up/p. pVR#,          p V '       Ed   V  U!U"u. uF  w  p!p"V!P`                  NK  	  p#p!p"V P#                  \%        \b        4      P1                  \b        P`                  Pe                  V#4      4      4      G R
j  x€L
 p$V$Pg                  4       P;                  4       p%V% U&u. uF  p&V&Ph                  NK  	  p'p&/ p(V''       EdE   V P#                  \%        \b        P`                  \j        Pl                  4      P-                  \j        \b        Ph                  \j        Ph                  8H  4      P1                  \b        Ph                  Pe                  V'4      \j        Pl                  Po                  R
4      4      P5                  \j        Pp                  4      4      G R
j  x€L
 P;                  4       p)V) FW  w  p*p+V+'       g   K  V+Ps                  4       '       g   K(  V(Pu                  V*. 4      Pw                  V+Ps                  4       4       KY  	  / p,V% F.  p&V,Pu                  V&P`                  . 4      Pw                  V&4       K0  	  V  FÙ  w  p!p-V,Py                  V!P`                  . 4      p.\?        R$ V. 4       4      p/V(Py                  V!P`                  . 4      p0\=        V04      p1TPw                  R%\{        V!P`                  4      R&V!P|                  R'T0R	T-;'       g    R(R)V!P~                  R*T/R+T1R,V!P€                  '       d   V!P€                  Pƒ                  4       MR
/4       KÛ  	  V Py                  \„        V4      G R
j  x€L
 p2V2'       d   V2P(                  MR-p3R.V3R/VR0VR1V/#  ELz EL¾ EL; EL¸ EL) ELš EL% EL÷u upi u up"p!i  ELu up&i  ELî LR5i)2r   rˆ   )r   r   )ÚdateÚtimer?   r´   z(Start date must be on or before end dater<   )Útzinfor	  Nc              3   óP   "  € T F  w  rVP                   R 8X  g   K  ^x € K  	  R# 5i)rl  N©rð   ©rú  rÞ   r  s   &  r7   rû  Ú'get_dealer_dashboard.<locals>.<genexpr>  ó   é € ÐO©¡ °q·x±xÀ;Ñ7NŸ1š1«ùó   ‚&œ
&c              3   óP   "  € T F  w  rVP                   R 8X  g   K  ^x € K  	  R# 5i)re  Nr?  r@  s   &  r7   rû  rA    s    é € ÐT¡Z™T˜Q°1·8±8Ð?SÑ3S—q’q£ZùrC  c              3   óP   "  € T F  w  rVP                   R 8X  g   K  ^x € K  	  R# 5i)rí   Nr?  r@  s   &  r7   rû  rA    rB  rC  r²  r´  rÎ  Útotal_ordersÚconfirmed_ordersÚawaiting_ackÚsubmitted_ordersÚin_yardÚin_productionÚready_for_dispatchÚarrived_in_periodÚdispatched_in_periodÚtotal_clientszModel not setrm  Únc              3   ó8   "  € T F  qP                   x € K  	  R # 5irj   )rP  )rú  rã   s   & r7   rû  rA  P  s   é € Ð*¡˜A—C–C£ùó   ‚rÉ  r¿   ÚcountÚpctr{   c              3   ó8   "  € T F  qP                   x € K  	  R # 5irj   )r  )rú  r  s   & r7   rû  rA  s  s   é € Ð2©6 aŸEžE«6ùrR  rî   rï   r  u   â€”rð   r  r  rõ   ÚDealerrJ   ÚkpisÚ	model_mixÚrecent_orders)Cr‹   r   r‰   r   r   r   r   r;  r<  Útodayr   r   ÚcombineÚminr   r\   ÚmaxrN   r	   r   ra   r¨   rŒ   r�   rO   rA   r�   r
  r  r‘   r  r  r
   rS  Úselect_fromrÄ  r#  r¾  ÚbetweenrÆ  ÚcoalescerÕ   r©   rÎ   Úgroup_byrm  rP  Úroundrî   r   r  r�   r  r   r  r  r  rM   r×   rª   rk   r5   rï   rð   rõ   Ú	isoformatr   )4r0   rA   rI  r8  r   r‰   r   r   Úd_dateÚd_timeÚend_dÚstart_dÚperiod_fromÚ	period_toÚ
orders_resÚ
order_rowsrF  rG  rH  rI  rJ  rK  rL  rM  rN  rO  rW  Úmix_rowsÚ	mix_totalrã   rX  rY  Ú
top_ordersrÞ   r  r  Úvehicles_resÚall_vehsr  Úveh_idsr  r  r  r  Úvehs_by_orderr	  Úo_vehsr  r!  r  rG   rJ   s4   &&&&                                                r7   Úget_dealer_dashboardrt     sH  é € ßEßHß7à×!Ð!�6—<‘<“>€EØ×3Ð3˜¤	¨rÔ 2Õ2€GØ„Ü¨Ð4^Ô_Ð_ä×"Ò" 7¯J©J¼x¿|¹|ÔL€KÜ× Ò  ¯
©
¼8¿<¹<ÔH€Ið —z‘zÜŒ{˜L×-Ñ-×3Ñ3°MÓBÓCß	‰ˆlœK×1Ñ1°\×5KÑ5KÑKÓ	Lß	‰Œ{×$Ñ$¨	Ñ1Ó	2ß	‰”+×(Ñ(×-Ñ-Ó/Ó	0ó	÷ €Jð —‘Ó!€Jä�z“?€LÜÑO©ÓOÓOÐÜÑT¡ZÓTÓT€LÜÑO©ÓOÓOÐð —Z‘ZÜŒt�zŠz‹|Ó×(Ñ(¨Ó7ß	‰ˆ}×&Ñ&¨)Ñ3°]×5RÑ5RÐVbÑ5bÓ	có÷ ÷ �vƒx÷ð ð ð ð
 Ÿ:™:ÜŒt�zŠz‹|Ó×(Ñ(¨Ó7ß	‰ˆ}×&Ñ&¨)Ñ3°]×5RÑ5RÐV[Ñ5[Ó	\ó÷ ÷ �vƒx÷ð ð ð ð
 !#§
¡
ÜŒt�zŠz‹|Ó×(Ñ(¨Ó7ß	‰ˆ}×&Ñ&¨)Ñ3°]×5RÑ5RÐVjÑ5jÓ	kó!÷ ÷ �vƒx÷ð ð ð ð
  "Ÿz™zÜŒt�zŠz‹|Ó×(Ñ(¨Ó7ß	‰ˆ}×&Ñ&¨)Ñ3°]×5OÑ5O×5WÑ5WÐX_Ó5gÓ	hó ÷ ÷ �vƒx÷ð ð ð ð
 #%§*¡*ÜŒt�zŠz‹|Ó×(Ñ(¨Ó7ß	‰ˆ}×&Ñ&¨)Ñ3°]×5PÑ5P×5XÑ5XÐYdÓ5pÓ	qó#÷ ÷ �vƒx÷ð ð ð ð
 Ÿ:™:ÜŒt�zŠz‹|Ó×(Ñ(¨Ó9ß	‰ˆ×(Ñ(¨IÑ5Ó	6ó÷ ÷ �vƒx÷ð ð ð ð 	˜ØÐ,Ø˜ØÐ,Ø�7Ø˜ØÐ0ØÐ.ØÐ 4Ø˜ð€Dð —j‘jÜŒt�}Š}Ð/×<Ñ<¸oÓN×TÑTÐU\Ó]Ô_c×_iÒ_iÓ_k×_qÑ_qÐruÓ_vÓwß	‰�]Ó	#ß	‰Ð%×'BÑ'BÀm×F\ÑF\Ñ'\Ó	]ß	‰ˆ}×&Ñ&¨)Ñ3Ó	4ß	‰�'Ó	ß	‰”$—*’*“,×#Ñ#Ó%Ó	&ó÷ ÷ �sƒuð ô Ñ*¡Ó*Ó*€Ià�Øñ  {Có  Dñ  {CÐuv�7˜AŸG™G W¨a¯c©c°5×_h¼%ÀÇÁÀyÅÐSVÕAVÐYZÔ:[ÐnoÓpñ  {Cñ  Dð€Ið €MØ˜B•€Jß€zÙ,6Ô7©J¡D A q�Q—Z”Z©Jˆ	Ñ7ØŸZ™ZÜÔ%Ó&×,Ñ,Ô-?×-HÑ-H×-LÑ-LÈYÓ-WÓXó
÷ 
ˆð  ×'Ñ'Ó)×-Ñ-Ó/ˆÙ/7Ó8©x¨!�1×%Ô%©xˆÐ8àÐßˆ7ØŸJ™JÜÔ)×2Ñ2Ô4M×4XÑ4XÓYß‘Ô/Ô1C×1TÑ1TÔXq÷  YCñ  YCñ  2Có  Dß‘Ô)×:Ñ:×>Ñ>¸wÓGÔIb×ImÑIm×IsÑIsÐtxÓIyÓzß‘Ô3×:Ñ:Ó;ó	÷ ÷
 ‰s‹uð ó %‘
��dß‘4˜DŸJ™JŸLœLØ$×/Ñ/°°bÓ9×@Ñ@ÀÇÁÃÖNñ %ð ˆÛˆAØ×$Ñ$ Q§Z¡Z°Ó4×;Ñ;¸AÖ>ñ ó )‰NˆAˆ{Ø"×&Ñ& q§z¡z°2Ó6ˆFÜÑ2©6Ó2Ó2ˆIØ%×)Ñ)¨!¯*©*°bÓ9ˆFÜ ›KˆMØ× Ñ ØœC §
¡
›OØ˜AŸJ™JØ˜vØ˜{×3Ð3¨eØ˜!Ÿ(™(Ø˜YØ Ø¸a¿n¿n¸n §¡× 8Ñ 8Ô :ÐRVð	"ö 	ñ )ð" —6‘6œ.¨)Ó4×4€Fß!'�&—+’+¨X€Kð 	�{Ø�Ø�YØ˜ð	ð òoòò
ò
ò
ò
ò
ò&ùò Dùó 8ò
ùò 9òñ> 5ùsA  ‚;h ¾D8h Å6g0Å7B>h È5g3È6h ÉA,h Ê;g6Ê<h ËA,h Íg9Íh ÍA8h Ïg<Ïh Ï-A8h Ñ%g?Ñ&h Ñ?Ah ÓhÓh Ó7Dh ØhØ+h Ø:%h
Ù +h
Úh Ú#h Ú(hÛ Ah ÜhÜ&h Ü7hÝC!h à-hà.h áh á*D"h æ>h çhçh çh ç3h ç6h ç9h ç<h ç?h èh èh èh èh èh )NNNN)é
   )é   rj   )NNN)NN)FNF)FN)`rX   r   r   r   Útypingr   Úfastapir   Úsqlalchemy.ext.asyncior   rÏ  r	   r
   r   r   Úsqlalchemy.ormr   r‹   r   r   r   r   r   Úapp.models.dispatch_modelsr   r   rÙ   r   r   r   r   r   r   r   r   r   r   r   r   r    r!   r"   r#   r$   r%   Úapp.core.securityr&   r'   Ú!app.modules.dealer_portal.schemasr(   r)   r*   r+   Úapp.modules.notificationsr,   r  r;   r-   re   rm   rv   r€   r“   rš   r¢   r¥   r­   rº   rÄ   rä   rç   r  r"  r6  rý   r  rb  ri  rˆ  r‹  r�  r™  r¤  r§  r«  rì  rò  r  r  r  r  r%  r+  r0  r6  rt  r   r9   r7   Ú<module>r     s+  ðÛ ß 2Ñ 2Ý Ý !Ý /ß 3Ó 3Ý 'ç @ß Dß _÷÷ ÷ ÷ ÷ ÷ Cß pÓ pÝ FÝ õ%õP÷	õ1÷
4õõõ÷&÷(õ@õ:(õV1õ+÷\*õZ*÷Z*õZ+õ\+õ+õ$C+÷P/õd+õ+÷"õ(õ÷sõj+÷$Z+õ|\õõ õF'õT"õ:õ(:÷,Jñ Jr9   