+
    `Øjã7  ã                   ó
  € ^ RI t ^ RIHtHtHt ^ RIHtHt ^ RIHtH	t	H
t
Ht ^ RIHt ^ RI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 ^ R
I H!t! ^ RI"H#t#H$t$H%t% ^ RI H&t& ^RI'H(t(H)t)H*t*H+t+ R R lt,R R lt-R# )é    N)ÚOptionalÚListÚDict)ÚdatetimeÚdate)ÚselectÚor_Úand_Úfunc)ÚAsyncSession)ÚHTTPException)ÚChassisMasterÚVehicleModelMaster)ÚCustomerMasterÚClientMaster)	ÚDealerOrderÚDealerOrderVehicleÚDealerOrderVehicleChassisÚDealerOrderVehicleFeatureÚSpecialFeatureMasterÚSpecialFeatureOptionMasterÚBodyTypeMasterÚCustomerSegmentMasterÚ	RtoMaster)ÚStationMaster)ÚProductMasterÚ	BomMasterÚ	BomDetail)ÚRmMaster)ÚChassisOrderSpecOutÚSpecialFeatureItemOutÚSpecialFeatureSectionOutÚBomMaterialItemOutc                ó<   € V ^8„  d   QhR\         R\        R\        /# )é   ÚdbÚchassisÚreturn)r   r   r    )Úformats   "ÚP/var/www/html/audi_dev/backend/app/modules/chassis_tracker/order_spec_service.pyÚ__annotate__r+      s'   € ÷ Bñ B¬ð BÄð BÔReñ Bó    c              ƒ  ó@   "  € \        V\        4      '       d   \        W4      G Rj  x€L
 # RpVP                  '       ds   V P	                  \        \        P                  4      P                  \        P                  VP                  8H  4      4      G Rj  x€L
 P                  4       pV'       d   TpRpVP                  '       ds   V P	                  \        \        P                  4      P                  \        P                  VP                  8H  4      4      G Rj  x€L
 P                  4       pV'       d   TpRpRpRpVP                  '       d�   V P	                  \        \        4      P                  \        P                   VP                  8H  4      4      G Rj  x€L
 P                  4       p	V	'       d'   V	P"                  p\%        V	RR4      p\%        V	RR4      pRp
RpRpRpVP&                  '       dš   V P	                  \        \(        4      P                  \(        P&                  VP&                  8H  4      4      G Rj  x€L
 P                  4       pV'       d4   VP"                  p
\%        VRR4      p\%        VRR4      p\%        VRR4      pRpRpVP*                  '       d_   V P	                  \        \,        4      P                  \,        P.                  VP*                  8H  4      4      G Rj  x€L
 P                  4       pV'       Eg   VP0                  '       Ed   V P	                  \        \2        4      P                  \4        P6                  ! \2        P0                  4      VP0                  P7                  4       P9                  4       8H  4      4      G Rj  x€L
 P                  4       pV'       dk   VP:                  pV P	                  \        \,        4      P                  \,        P.                  VP.                  8H  4      4      G Rj  x€L
 P                  4       pRpRpRpRpRpRpRpRpRpRpRpRpRpRpRp ^p!Tp"Tp#Tp$T
p%Tp&Tp'Tp(. p)^ p*V'       Ed(   RpVP<                  pVP>                  ;'       g    ^p!VP@                  '       ds   V P	                  \        \B        P"                  4      P                  \B        P@                  VP@                  8H  4      4      G Rj  x€L
 P                  4       p+V+'       d   T+pVPD                  '       ds   V P	                  \        \F        P"                  4      P                  \F        PD                  VPD                  8H  4      4      G Rj  x€L
 P                  4       p,V,'       d   T,pVPH                  '       d   V P	                  \        \J        4      P                  \J        PH                  VPH                  8H  4      4      G Rj  x€L
 P                  4       p-V-'       d   V-P"                  pV-PL                  p V'       g…   VP                  '       ds   V P	                  \        \        P                  4      P                  \        P                  VP                  8H  4      4      G Rj  x€L
 P                  4       p.V.'       d   T.pV P	                  \        \N        4      P                  \N        PP                  VPP                  8H  4      4      G Rj  x€L
 P                  4       p/V/'       EdÚ   V/PP                  pV/PR                  pV/PT                  ;'       g    V/PV                  pV/PX                  pV/PZ                  pV/P\                  pV/P^                  pV/P`                  pV/Pb                  pV/P                  '       d•   V"'       g�   V P	                  \        \        4      P                  \        P                   V/P                  8H  4      4      G Rj  x€L
 P                  4       p	V	'       d'   V	P"                  p"\%        V	RR4      p#\%        V	RR4      p$V/P&                  '       d¢   V%'       gš   V P	                  \        \(        4      P                  \(        P&                  V/P&                  8H  4      4      G Rj  x€L
 P                  4       pV'       d4   VP"                  p%\%        VRR4      p&\%        VRR4      p'\%        VRR4      p(\        \d        Pf                  \d        Ph                  \d        Pj                  \d        Pl                  \d        Pn                  \p        Pr                  \p        Pt                  \v        Px                  \v        Pz                  \p        P|                  4
      P                  \d        \v        Pf                  \d        Pf                  8H  4      P�                  \p        \v        P‚                  \p        Pr                  8H  4      P                  \v        P.                  VP.                  8H  4      P…                  \d        Ph                  \d        Pn                  4      p0V P	                  V04      G Rj  x€L
 P‡                  4       p1/ p2V1 FÔ  p3V3w
  p4p5p6p7p8p9p:p;p<p=V7R8X  d   T:;'       g    Rp>MHV7R	8X  d   V;'       d   R
MRp>M4V7R8X  d   T<;'       g    Rp>M T:;'       g    T<;'       g    V;'       d   RMRp>\‰        T4T6T5;'       g    RT7;'       g    RT8;'       g    ^ V9V:V;V<V>V=R7      p?T2P‹                  T5;'       g    R. 4      P�                  V?4       V*^,          p*KÖ  	  V2P�                  4        F,  w  p@pAV)P�                  \‘        V@\“        VA4      VAR7      4       K.  	  RpBRpC. pDV'       Ed#   V'       Ed   V'       Ed   VP9                  4        RVP9                  4        RVP9                  4        2P•                  4       pEV P	                  \        \–        4      P                  \™        \4        P”                  ! \–        P"                  4      VE8H  \–        P"                  P›                  RVP9                  4        R24      4      4      P…                  \–        PT                  P�                  4       4      4      G Rj  x€L
 PŸ                  4       P¡                  4       pFVF'       Edì   XFP"                  pCV P	                  \        \¢        4      P                  \¢        P¤                  VFP¤                  8H  \¢        P¦                  R8H  4      4      G Rj  x€L
 PŸ                  4       P¡                  4       pGVG'       EdY   XGP¨                  pB\        \ª        P¬                  \®        P°                  \®        P"                  P³                  R4      \ª        P´                  \ª        P¶                  4      P                  \®        \ª        P¬                  \®        P¬                  8H  4      P                  \ª        P¸                  VGP¸                  8H  4      P…                  \®        P"                  4      pHV P	                  VH4      G Rj  x€L
 P‡                  4       pIVI FA  w  pJpKpLpMpNXDP�                  \»        TJTKTLVMe   \½        XM4      MRXN;'       g    RR7      4       KC  	  \¿        RG/ RVbRVPÀ                  bRVP0                  bRVbRVbRVbRVbR VbR!VP                  bR"V"bR#V#bR$V$bR%VP&                  bR&V%bR'V'bR(V&bR)V(bR*VbR+VbR,VbR-VbR.VbR/VbR0V!bR1VbR2VbR3VbR4VbR5V bR6VPÂ                  ;'       g    R7bR8VPÄ                  ;'       g    R9bR:VPÆ                  ;'       g    R;bR<VPÈ                  e   \½        VPÈ                  4      MRbR=VPÊ                  ;'       g    R>bR?VPÌ                  ;'       g    R@bRAVbRBV)bRCV*bRDXBbREXCbRFXDb #  EL¾ ELS ELÐ ELS EL° EL EL] ELî EL E
L— E
L  E	L� E	L EL EL{ ELÀ ELx ELè ELÃ5i)Hz¢
Given a ChassisMaster instance, resolves complete order details, manufacturing specifications,
dynamic special features checklist, and bill of materials recipe.
NÚcityÚphoneÚaddressFTÚDROPDOWNzSpecified OptionÚBOOLEANzYes / IncludedzNo / StandardÚTEXTzCustom NoteÚYesÚStandardzGeneral Features)Ú
feature_idÚfeature_nameÚsectionÚ
input_typeÚsequence_noÚ	option_idÚoption_valueÚ
bool_valueÚ
text_valueÚdisplay_valueÚ	image_url)r8   ÚcountÚitemsÚ Ú%Úmaterial_nameg      ð?ÚNOS)Úrm_idÚ	item_coderE   ÚquantityÚuomÚ	has_orderÚ
chassis_idÚ
chassis_noÚorder_idÚorder_noÚ
order_dateÚconfirmed_dateÚexpected_delivery_dateÚ	dealer_idÚdealer_nameÚdealer_cityÚdealer_phoneÚ	client_idÚclient_nameÚclient_phoneÚclient_cityÚclient_addressÚrep_nameÚrep_contactÚ
billing_byÚorder_statusÚorder_remarksÚvehicle_notesÚorder_quantityÚmodel_numberÚbody_type_nameÚsegment_nameÚrto_nameÚrto_descriptionÚ	fuel_typeÚDIESELÚvoltageÚ12VÚ
light_typeÚSQUARE_LIGHTÚfuel_receiving_qtyÚyard_locationz34 Acre YardÚsource_typeÚSALES_ORDERÚcurrent_station_nameÚspecial_features_sectionsÚtotal_special_features_countÚ
bom_numberÚproduct_nameÚbom_materials© )gÚ
isinstanceÚstrÚ$get_chassis_order_spec_by_identifierÚmodel_idÚexecuter   r   rc   ÚwhereÚscalar_one_or_noneÚcurrent_station_idr   Ústation_nameÚ
station_idrS   r   Úcustomer_idÚnameÚgetattrrW   r   Údealer_order_vehicle_idr   Úorder_vehicle_idrM   r   r   ÚlowerÚstriprR   ÚnotesÚqtyÚbody_type_idr   Ú
segment_idr   Úrto_idr   Údescriptionr   rN   rO   Ú
created_atÚsubmitted_atÚconfirmed_atÚremarksr\   r]   r^   Ústatusr   r6   r8   r7   r9   r:   r   r;   r<   r   r=   r>   r@   ÚjoinÚ	outerjoinÚfeature_option_idÚorder_byÚallr!   Ú
setdefaultÚappendrB   r"   ÚlenÚupperr   r	   ÚilikeÚdescÚscalarsÚfirstr   Ú
product_idÚ	is_activeru   r   rG   r   Úpart_noÚlabelrI   rJ   Úbom_idr#   Úfloatr    rL   rh   rj   rl   rn   ro   rp   )Or&   r'   rc   Úmrr   ÚstÚchassis_dealer_nameÚchassis_dealer_cityÚchassis_dealer_phoneÚdlÚchassis_client_nameÚchassis_client_cityÚchassis_client_phoneÚchassis_client_addressÚclÚdovÚexpected_deliveryÚdovcrK   rN   rO   rP   rQ   r`   ra   r\   r]   r^   r_   rd   re   rf   rg   Ú	order_qtyrT   rU   rV   rX   rZ   rY   r[   Úspecial_sectionsÚtotal_features_countÚbtÚsgÚrtÚov_mÚdoÚ	feat_stmtÚfeatures_rowsÚsection_mapÚrowÚf_idÚsecÚf_nameÚin_typeÚseq_noÚopt_idÚopt_valÚb_valÚt_valÚimg_urlÚdisplay_valÚitemÚsec_namerB   ru   rv   rw   Úcand1ÚprodÚbomÚmat_stmtÚmat_rowsrG   ÚcodeÚm_namer‹   rJ   sO   &&                                                                             r*   Úresolve_chassis_order_specrÖ      s\  é € ô
 �'œ3×ÒÜ9¸"ÓF×FÐFð €LØ××ÐØ—:‘:ÜÔ%×2Ñ2Ó3×9Ñ9Ô:L×:UÑ:UÐY`×YiÑYiÑ:iÓjó
÷ 
çÑÓð 	
÷ ØˆLð  ÐØ×!×!Ð!Ø—J‘JÜ”=×-Ñ-Ó.×4Ñ4´]×5MÑ5MÐQX×QkÑQkÑ5kÓló
÷ 
çÑÓð 	÷ Ø#%Ð ð ÐØÐØÐØ××ÐØ—J‘JÜ”>Ó"×(Ñ(¬×)CÑ)CÀw×GXÑGXÑ)XÓYó
÷ 
çÑÓð 	÷ Ø"$§'¡'ÐÜ")¨"¨f°dÓ";ÐÜ#*¨2¨w¸Ó#=Ð àÐØÐØÐØ!ÐØ××ÐØ—J‘JÜ”<Ó ×&Ñ&¤|×'=Ñ'=À×ARÑARÑ'RÓSó
÷ 
çÑÓð 	÷ Ø"$§'¡'ÐÜ")¨"¨f°dÓ";ÐÜ#*¨2¨w¸Ó#=Ð Ü%,¨R°¸DÓ%AÐ"ð )-€CØ(,Ðà×&×&Ð&Ø—Z‘ZÜÔ%Ó&×,Ñ,Ô-?×-PÑ-PÐT[×TsÑTsÑ-sÓtó
÷ 
çÑÓð 	÷ ˆ3�7×%×%Ñ%Ø—j‘jÜÔ,Ó-×3Ñ3´D·J²JÔ?X×?cÑ?cÓ4dÐho×hzÑhz÷  iAñ  iAó  iC÷  iIñ  iIó  iKñ  5Kó  Ló
÷ 
çÑÓð 	÷ Ø $× ;Ñ ;ÐØŸ™ÜÔ)Ó*×0Ñ0Ô1C×1TÑ1TÐX\×XmÑXmÑ1mÓnó÷ ç!Ñ!Ó#ð ð
 €IØ€HØ€HØ€JØ€NØ€MØ€MØ€HØ€KØ€JØ€LØ€NØ€LØ€HØ€OØ€Ià%€KØ%€KØ'€LØ%€KØ%€KØ'€LØ+€Nà79ÐØÐç
€sØˆ	ØŸ	™	ˆØ—G‘G—L�L˜qˆ	ð ××ÐØŸ
™
Ü”~×*Ñ*Ó+×1Ñ1´.×2MÑ2MÐQT×QaÑQaÑ2aÓbó÷ ç!Ñ!Ó#ð ÷ Ø!#�ð �>�>ˆ>ØŸ
™
ÜÔ,×1Ñ1Ó2×8Ñ8Ô9N×9YÑ9YÐ]`×]kÑ]kÑ9kÓló÷ ç!Ñ!Ó#ð ÷ Ø!�ð �:�:ˆ:ØŸ
™
Ü”yÓ!×'Ñ'¬	×(8Ñ(8¸C¿J¹JÑ(FÓGó÷ ç!Ñ!Ó#ð ÷ ØŸ7™7�Ø"$§.¡.�÷  §§ ØŸ*™*ÜÔ)×6Ñ6Ó7×=Ñ=Ô>P×>YÑ>YÐ]`×]iÑ]iÑ>iÓjó÷ ç!Ñ!Ó#ð ÷ Ø#�ð —J‘JÜ”;Ó×%Ñ%¤k×&:Ñ&:¸c¿l¹lÑ&JÓKó
÷ 
çÑÓð 	÷ ˆ2Ø—{‘{ˆHØ—{‘{ˆHØŸ™×9Ð9¨"¯/©/ˆJØŸ_™_ˆNØŸJ™JˆMØ—{‘{ˆHØŸ.™.ˆKØŸ™ˆJØŸ9™9ˆLà�|�|ˆ|§KØŸJ™JÜœ>Ó*×0Ñ0´×1KÑ1KÈrÏ|É|Ñ1[Ó\ó÷ ç%Ñ%Ó'ð ÷ Ø"$§'¡'�KÜ")¨"¨f°dÓ";�KÜ#*¨2¨w¸Ó#=�Là�|�|ˆ|§KØŸJ™JÜœ<Ó(×.Ñ.¬|×/EÑ/EÈÏÉÑ/UÓVó÷ ç%Ñ%Ó'ð ÷ Ø"$§'¡'�KÜ")¨"¨f°dÓ";�KÜ#*¨2¨w¸Ó#=�LÜ%,¨R°¸DÓ%A�Nô Ü$×/Ñ/Ü$×,Ñ,Ü$×1Ñ1Ü$×/Ñ/Ü$×0Ñ0Ü*×4Ñ4Ü*×7Ñ7Ü)×4Ñ4Ü)×4Ñ4Ü*×4Ñ4ó÷ ‰TÔ&Ô(A×(LÑ(LÔPd×PoÑPoÑ(oÓpß‰YÔ1Ô3L×3^Ñ3^Ôb|÷  cGñ  cGñ  4Gó  Hß‰UÔ,×=Ñ=À×AUÑAUÑUÓVß‰XÔ*×2Ñ2Ô4H×4TÑ4TÓUð! 	ð$  "Ÿz™z¨)Ó4×4×9Ñ9Ó;ˆà>@ˆÛ ˆCØY\ÑVˆD�#�v˜w¨°¸ÀÈÈwà˜*Ô$Ø%×;Ð;Ð);‘Ø˜IÔ%ß27Ñ.¸_‘Ø˜FÔ"Ø#×4Ð4 }‘à%×RÐR¨×RÐR¿E±5Àz�ä(ØØ#Ø×1Ð1Ð1Ø"×0Ð0 jØ"ŸK˜K aØ Ø$Ø Ø Ø)Ø!ôˆDð ×"Ñ" 3×#<Ð#<Ð*<¸bÓA×HÑHÈÔNØ  AÕ%Ò ñ5 !ð8  +×0Ñ0Ö2‰OˆH�eØ×#Ñ#Ü(Ø$Ü˜e›*Øôöñ  3ð €JØ€LØ.0€Mç€~Ÿ,˜,¯<¨<Ø!×'Ñ'Ó)Ð*¨!¨L×,>Ñ,>Ó,@Ð+AÀÀ<×CUÑCUÓCWÐBXÐY×_Ñ_ÓaˆØ—j‘jÜ”=Ó!×'Ñ'ÜÜ—J’Jœ}×1Ñ1Ó2°eÑ;Ü!×&Ñ&×,Ñ,¨q°×1CÑ1CÓ1EÐ0FÀaÐ-HÓIóó÷
 ‰h”}×/Ñ/×4Ñ4Ó6Ó7ó
÷ 
÷ ‰7‹9—U‘U“Wð 	÷ ˆ4ØŸ9™9ˆLØŸ™Ü”yÓ!×'Ñ'¬	×(<Ñ(<ÀÇÁÑ(OÔQZ×QdÑQdÐhlÑQlÓmó÷ ç‰w‹yŸ™›ð ÷ ˆsØ Ÿ^™^�
äÜ!Ÿ™Ü ×(Ñ(Ü Ÿ™×+Ñ+¨OÓ<Ü!×*Ñ*Ü!Ÿ™ó÷ ‘Tœ(¤I§O¡O´x·~±~Ñ$EÓFß‘Uœ9×+Ñ+¨s¯z©zÑ9Ó:ß‘XœhŸm™mÓ,ð ð #%§*¡*¨XÓ"6×6×;Ñ;Ó=�Û5=Ñ1�E˜4 ¨¨cØ!×(Ñ(Ü*Ø"'Ø&*Ø*0Ø36²?¤U¨3¤ZÈØ #§  uôöñ 6>ô ò *Ùð*à×%Ò%ð*ð ×%Ò%ð*ñ ð	*ñ
 ð*ñ ð*ñ &ð*ñ  1ð*ð ×#Ò#ð*ñ  ð*ñ  ð*ñ "ð*ð ×#Ò#ð*ñ  ð*ñ "ð*ñ   ð!*ñ" &ð#*ñ$ ð%*ñ&  ð'*ñ( ð)*ñ* "ð+*ñ, $ð-*ñ. $ð/*ñ0 !ð1*ñ2 "ð3*ñ4 &ð5*ñ6 "ð7*ñ8 ð9*ñ: (ð;*ð< ×#Ñ#×/Ð/ xøð=*ð> —‘×(Ð( 5øð?*ð@ ×%Ñ%×7Ð7¨øðA*ðB AH×@ZÑ@ZÒ@fœ5 ×!;Ñ!;Ô<ÐlpøðC*ðD ×+Ñ+×=Ð=¨~øðE*ðF ×'Ñ'×8Ð8¨=øðG*ñH 2ðI*ñJ #3ðK*ñL &:ðM*ñN ðO*ñP "ðQ*ñR $ðS*ð *òe Gò

ò
ò
ò
ò
ò

ò
òPòòòò
òòò8 5ò^
òò$ 7ùs  ‚%A@§%¨A@Á AA@Â(ÂA@Â0A@ÃAA@Ä+ÄA@Ä6A@ÅAA@Æ.ÆA@Æ6?A@Ç6AA@É1ÉA@ÉAA@Ê%AA@Ë04Ë1A@ÌA@ÌA;A@Î7ÎA@Î5AA@Ð:ÐAA@Ñ A@Ñ;A@ÒAA@Ó%=Ó&A@Ô A@ÔAA@Õ)A@ Õ*A@ÖA@ÖAA@×#A@×$A@×>A@ØA@Ø0AA@ÚA@ÚA@Ú AA@Û-A@	Û.A@Ü	*A@Ü4A&A@ÞA@Þ#AA@ß.A@ß/A@à	7A@áA@á	AA@âA@âA@â/F#A@éA@é5A@ê	A@êA@ê1A@ê>	A@ëA@ëA@ë%
A@ë0
A@ë;!A@ìA2A@îA@îA@î"C;A@òA@ò(A@óA)A@ô0A@ô1(A@õC>A@ùA@ùAA@ú"B)A@ýA@ý#A@ý:<A@þ7A@ÿA@ÿ(A@ÿ+A@ÿ.A@ÿ1A@ÿ4A@ÿ7A@ÿ:A@ÿ=A@Á@ A@Á@A@Á@A@Á@	A@Á@A@Á@A@Á@A@Á@A@Á@A@Á@A@c                ó<   € V ^8„  d   QhR\         R\        R\        /# )r%   r&   Ú
identifierr(   )r   rz   r    )r)   s   "r*   r+   r+   ^  s"   € ÷ 9ñ 9´<ð 9ÌSð 9ÔUhñ 9r,   c              ƒ   ó,  "  € T;'       g    R P                  4       pV'       g   \        RRR7      hRp \        P                  ! V4      pV P	                  \
        V4      G Rj  x€L
 pV'       ga   V P                  \        \
        4      P                  \
        P                  P                  V4      4      4      G Rj  x€L
 P                  4       pV'       g   \        RRV R2R7      h\        W4      G Rj  x€L
 #  L˜  \         d     L£i ; i LQ L5i)Ú i�  z&Chassis number or identifier required.)Ústatus_codeÚdetailNi”  z	Chassis 'z' not found.)r‰   r   ÚuuidÚUUIDÚgetr   Ú	Exceptionr}   r   r~   rM   rž   r   rÖ   )r&   rØ   Úidentr'   Úuids   &&   r*   r{   r{   ^  së   é € Ø×Ð˜2×$Ñ$Ó&€EßÜ¨Ð4\Ô]Ð]ð €GðÜ�iŠi˜ÓˆØŸ™œ}¨cÓ2×2ˆ÷ ØŸ™Ü”=Ó!×'Ñ'¬×(@Ñ(@×(FÑ(FÀuÓ(MÓNó
÷ 
çÑÓð 	÷ Ü¨°iÀ¸wÀlÐ4SÔTÐTä+¨BÓ8×8Ð8ñ 3øÜô Ùðúñ
ñ 9ùsj   ‚"D¥Dµ/C? Á$C=Á%C? Á)DÁ1ADÂ>DÂ?DÃDÃ8DÃ9DÃ=C? Ã?DÄ
DÄDÄDÄD).rÝ   Útypingr   r   r   r   r   Ú
sqlalchemyr   r	   r
   r   Úsqlalchemy.ext.asyncior   Úfastapir   Úapp.models.yard_modelsr   r   Úapp.models.sales_modelsr   r   Úapp.models.dealer_modelsr   r   r   r   r   r   r   r   r   Úapp.models.rm_modelsr   Úapp.models.bom_modelsr   r   r   r   Úschemasr    r!   r"   r#   rÖ   r{   rx   r,   r*   Ú<module>rí      sV   ðã ß 'Ñ 'ß #ß .Ó .Ý /Ý !ç Dß @÷÷ õ õ
 /ß EÑ EÝ )÷ó õB÷J
9r,   