+
    èc«j*  ã                  ó^  € ^ RI Ht ^ RIt^ RIHt ^ RIHt ^ RIHt ^ RI	H
t
Ht ]! ]4      P                  4       P                  ^,          R,          R,          t]! ]4      P                  4       P                  ^,          R,          R	,          t]! ]4      P                  4       P                  ^,          R,          R
,          tRRRRRRRRRRRR/tRRRRRRRRRR /tRRRRR!R"R#R$R%R&R'R(/tR)R*R+R,R-R.R/R0R1R2/tR3R4R5R6R7R8/tR9 R: ltR; R< ltR= R> lt]3R? R@ llt]3RA RB llt]3RC RD lltR# )Eé    )ÚannotationsN)ÚPath)ÚSession)ÚItemDatabase)Ú
BudgetHeadÚOFESEstablishmentÚdatazbudget_head_master.csvzitem_master.csvzofes_establishments.csvzFire Extinguisheru!   à¬…à¬—à­�à¬¨à¬¿à¬¨à¬¿à¬¬à¬¾à¬°à¬•z	Fire Hoseu"   à¬…à¬—à­�à¬¨à¬¿à¬¶à¬® à¬¹à­‹à¬œà­�zBreathing Apparatusu"   à¬¶à­�à­±à¬¾à¬¸ à¬¯à¬¨à­�à¬¤à­�à¬°zRescue Cutteru   à¬‰à¬¦à­�à¬§à¬¾à¬° à¬•à¬Ÿà¬°zSafety Glovesu+   à¬¸à­�à¬°à¬•à­�à¬·à¬¾ à¬¹à¬¾à¬¤à¬®à­‹à¬œà¬¾zHydraulic Rescue KituA   à¬¹à¬¾à¬‡à¬¡à­�à¬°à­‹à¬²à¬¿à¬•à­� à¬‰à¬¦à­�à¬§à¬¾à¬° à¬•à¬¿à¬Ÿà­�Ú	Equipmentu   à¬‰à¬ªà¬•à¬°à¬£ÚVehicleu	   à¬¯à¬¾à¬¨ÚPPEuG   à¬¬à­�à­Ÿà¬•à­�à¬¤à¬¿à¬—à¬¤ à¬¸à­�à¬°à¬•à­�à¬·à¬¾ à¬¸à¬¾à¬®à¬—à­�à¬°à­€Ú
Consumableu7   à¬¬à­�à­Ÿà¬¬à¬¹à¬¾à¬°à­�à¬¯à­�à­Ÿ à¬¸à¬¾à¬®à¬—à­�à¬°à­€ÚServiceu   à¬¸à­‡à¬¬à¬¾zOffice Expensesu+   à¬•à¬¾à¬°à­�à¬¯à­�à­Ÿà¬¾à¬³à­Ÿ à¬¬à­�à­Ÿà­ŸÚ	Machineryu   à¬¯à¬¨à­�à¬¤à­�à¬°à¬ªà¬¾à¬¤à¬¿zFire Fightingu   à¬…à¬—à­�à¬¨à¬¿à¬¶à¬®zProtective Gearu+   à¬¸à­�à¬°à¬•à­�à¬·à¬¾ à¬¸à¬¾à¬®à¬—à­�à¬°à­€ÚKhordhau   à¬–à­‹à¬°à­�à¬¦à­�à¬§à¬¾ÚCuttacku	   à¬•à¬Ÿà¬•ÚPuriu   à¬ªà­�à¬°à­€Ú	Sambalpuru   à¬¸à¬®à­�à¬¬à¬²à¬ªà­�à¬°ÚBalasoreu   à¬¬à¬¾à¬²à­‡à¬¶à­�à­±à¬°zCentral Rangeu+   à¬•à­‡à¬¨à­�à¬¦à­�à¬°à­€à­Ÿ à¬°à­‡à¬žà­�à¬œzNorthern Rangeu   à¬‰à¬¤à­�à¬¤à¬° à¬°à­‡à¬žà­�à¬œzSouthern Rangeu"   à¬¦à¬•à­�à¬·à¬¿à¬£ à¬°à­‡à¬žà­�à¬œc               ó$   € V ^8„  d   QhRRRRRR/# )é   ÚvalueÚstrÚmappingúdict[str, str]Úreturnú
str | None© )Úformats   "Ú0/var/www/html/proc/backend/app/db/master_data.pyÚ__annotate__r    9   s!   € ÷ #ñ #�sð # ^ð #¸
ñ #ó    c                óD   € V P                  4       pVP                  V4      # ©N)ÚstripÚget)r   r   Ú
normalizeds   && r   Úodia_lookupr'   9   s   € Ø—‘“€JØ�;‰;�zÓ"Ð"r!   c               ó    € V ^8„  d   QhRRRR/# )r   Úrowr   r   r   r   )r   s   "r   r    r    >   s   € ÷ 	ñ 	 .ð 	°Sñ 	r!   c           	     ó˜   € R P                  R V P                  RR4      V P                  RR4      V P                  RR4      3 4       4      # )ú - c              3  ó†   "  € T F7  pV'       g   K  VP                  4       '       g   K%  VP                  4       x € K9  	  R # 5ir#   )r$   ©Ú.0Úparts   & r   Ú	<genexpr>Ú+budget_head_display_name.<locals>.<genexpr>?   s:   é € ð ñ
ˆDô
 ô 	ð —J‘J—Lô 	ˆ�
‰
�ˆó
ùs   ‚
A‘A©AÚcategory_nameÚ Úexpenditure_headÚitem_component)Újoinr%   )r)   s   &r   Úbudget_head_display_namer7   >   sP   € Ø�:‰:ñ ð �G‰G�O RÓ(Ø�G‰GÐ&¨Ó+Ø�G‰GÐ$ bÓ)ñ
óó ð r!   c               ó    € V ^8„  d   QhRRRR/# )r   r)   r   r   r   r   )r   s   "r   r    r    J   s   € ÷ 0ñ 0 ^ð 0¸
ñ 0r!   c                óÄ   € . pR F>  p\        V P                  VR4      \        4      pV'       g   K-  VP                  V4       K@  	  V'       d   RP	                  V4      # R# )r2   r3   r+   N)r2   r4   r5   )r'   r%   ÚODIA_BUDGET_TERMSÚappendr6   )r)   ÚpartsÚkeyr   s   &   r   Úbudget_head_display_name_orr>   J   sS   € Ø€EÛFˆÜ˜CŸG™G C¨Ó,Ô.?Ó@ˆß‰5Ø�L‰L˜Öñ G÷ !&ˆ5�:‰:�eÓÐ/¨4Ð/r!   c               ó$   € V ^8„  d   QhRRRRRR/# ©r   Údbr   Úcsv_pathr   r   Úintr   )r   s   "r   r    r    S   s!   € ÷ &ñ &˜Gð &¨tð &È#ñ &r!   c                ó>  € VP                  4       '       g   ^ # ^ pVP                  RRR7      ;_uu_ 4       p\        \        P                  ! V4      ^R7       EF¤  w  rEVR,          P                  4       pV RVR 2pV P                  \        4      P                  \        P                  V8H  4      P                  4       p/ RVbR	\        V4      bR
\        V4      bR\        V4      bRVbRVR,          P                  4       bRVR,          P                  4       bR\        VR,          \        4      bRVR,          P                  4       bRVR,          P                  4       bRVR,          P                  4       bR\        VR,          \        4      bRVR,          P                  4       bRVR,          P                  4       bR\        VR,          \        4      bRVP                  RR4      P                  4       ;'       g    RbRVP                  RR4      P                  4       ;'       g    RbRVP                  RR4      P                  4       ;'       g    RRVP                  RR4      P                  4       ;'       g    RRVP                  RR4      P                  4       R9   /Cp	V'       d'   V	P!                  4        F  w  r«\#        WŠV4       K  	  MV P%                  \        R/ V	B 4       V^,          pEK§  	  RRR4       V#   + '       g   i     T# ; i)r   r3   zutf-8©ÚnewlineÚencoding)ÚstartÚcategory_codeÚ-Ú03dÚ	head_codeÚdisplay_nameÚdisplay_name_enÚdisplay_name_orr2   Úcategory_name_enÚcategory_name_orÚfund_sourcer4   Úexpenditure_head_enÚexpenditure_head_orr5   Úitem_component_enÚitem_component_orÚquantityNÚunitÚpurpose_descriptionÚremarksÚ	is_activeÚ1>   r\   ÚYÚyesÚTrueÚtruer   )ÚexistsÚopenÚ	enumerateÚcsvÚ
DictReaderr$   Úqueryr   ÚfilterrL   Úfirstr7   r>   r'   r:   r%   ÚitemsÚsetattrÚadd)rA   rB   ÚchangedÚhandleÚindexr)   rI   rL   Úbudget_headÚvaluesr=   r   s   &&          r   Úupsert_budget_headsrq   S   s  € Ø�?‰?×ÒÙà€GØ	�‰˜r¨Gˆ×	4Ô	4¸Ü#¤C§N¢N°6Ó$:À!×DÐD‰JˆEØ Õ0×6Ñ6Ó8ˆMØ(˜/¨¨5°¨+Ð6ˆIØŸ(™(¤:Ó.×5Ñ5´j×6JÑ6JÈiÑ6WÓX×^Ñ^Ó`ˆKðØ˜YðàÔ 8¸Ó =ðð "Ô#;¸CÓ#@ðð "Ô#>¸sÓ#Cð	ð
   ðð    _Õ!5×!;Ñ!;Ó!=ðð # C¨Õ$8×$>Ñ$>Ó$@ðð #¤K°°OÕ0DÔFWÓ$Xðð ˜s =Õ1×7Ñ7Ó9ðð # CÐ(:Õ$;×$AÑ$AÓ$Cðð & sÐ+=Õ'>×'DÑ'DÓ'Fðð &¤{°3Ð7IÕ3JÔL]Ó'^ðð ! #Ð&6Õ"7×"=Ñ"=Ó"?ðð $ SÐ)9Õ%:×%@Ñ%@Ó%Bðð $¤[°Ð5EÕ1FÔHYÓ%Zðð  ˜CŸG™G J°Ó3×9Ñ9Ó;×CÐC¸tð!ð" ˜Ÿ™ ¨Ó+×1Ñ1Ó3×;Ð;°tð#ð$ & s§w¡wÐ/DÀbÓ'I×'OÑ'OÓ'Q×'YÐ'YÐUYØ˜3Ÿ7™7 9¨bÓ1×7Ñ7Ó9×AÐA¸TØ˜SŸW™W [°#Ó6×<Ñ<Ó>ÐBcÑcñ)ˆF÷, Ø"(§,¡,¦.‘J�CÜ˜K¨eÖ4ò #1ð —‘”zÑ+ FÑ+Ô,Ø�q�L‹Gñ? E÷ 
5ðB €N÷C 
5Ö	4ðB €Nús   ¶G7LÈ.*LÉ)LÊA>LÌL	c               ó$   € V ^8„  d   QhRRRRRR/# r@   r   )r   s   "r   r    r    |   s!   € ÷ ñ ˜7ð ¨dð Èñ r!   c                 óª  € VP                  4       '       g   ^ # ^ pVP                  RRR7      ;_uu_ 4       p\        P                  ! V4       EFe  p\	        VR,          4      pV P                  \        4      P                  \        P                  V8H  4      P                  4       pRVRVR,          P                  4       RVR,          P                  4       R\        VR,          \        4      RVR,          P                  4       R	VR,          P                  4       R
\        VR,          \        4      RRRRRRR^ RRRVP                  RR4      P                  4       R9   /pV'       d'   VP                  4        F  w  r‰\!        WhV	4       K  	  MV P#                  \        R/ VB 4       V^,          pEKh  	  RRR4       V#   + '       g   i     T# ; i)r   r3   ú	utf-8-sigrE   Úsr_noÚnameÚname_enÚname_orÚ	item_typeÚitem_type_enÚitem_type_orÚdescriptionNÚdescription_enÚdescription_orrW   rZ   r[   r\   >   r\   r]   r^   r_   r`   r   )ra   rb   rd   re   rC   rf   r   rg   ru   rh   r$   r'   ÚODIA_ITEM_NAMESÚODIA_ITEM_TYPESr%   ri   rj   rk   )
rA   rB   rl   rm   r)   ru   Úitemrp   r=   r   s
   &&        r   Úupsert_item_masterr‚   |   s…  € Ø�?‰?×ÒÙà€GØ	�‰˜r¨Kˆ×	8Ô	8¸FÜ—>’> &×)ˆCÜ˜˜G�Ó%ˆEØ—8‘8œLÓ)×0Ñ0´×1CÑ1CÀuÑ1LÓM×SÑSÓUˆDà˜Ø˜˜F�×)Ñ)Ó+Ø˜3˜v�;×,Ñ,Ó.Øœ; s¨6¥{´OÓDØ˜S Õ-×3Ñ3Ó5Ø  KÕ 0× 6Ñ 6Ó 8Ø¤¨C°Õ,<¼oÓ NØ˜tØ  $Ø  $Ø˜AØ˜4Ø˜SŸW™W [°#Ó6×<Ñ<Ó>ÐBcÑcðˆF÷ Ø"(§,¡,¦.‘J�CÜ˜D uÖ-ò #1ð —‘”|Ñ- fÑ-Ô.Ø�q�L‹Gñ/ *÷ 
9ð2 €N÷3 
9Ö	8ð2 €Nús   ¶FGÇG	c               ó$   € V ^8„  d   QhRRRRRR/# r@   r   )r   s   "r   r    r    �   s"   € ÷ $ñ $ 7ð $°dð $ÐY\ñ $r!   c           $     ó,  € VP                  4       '       g   ^ # ^ pVP                  RRR7      ;_uu_ 4       p\        P                  ! V4       EF&  p\	        VR,          4      pV P                  \        4      P                  \        P                  V8H  4      P                  4       pRTRVR,          P                  4       RVR,          P                  4       R\        VR,          \        4      ;'       g    RR	VR	,          P                  4       R
VR	,          P                  4       R\        VR	,          \        4      RVR,          P                  4       RVR,          P                  4       R\        VR,          \        4      RVR,          P                  4       RVR,          P                  4       RRP                  R \        VR,          \        4      \        VR,          \        4      3 4       4      ;'       g    RRVP                  RR4      P                  4       R9   /pV'       d'   VP!                  4        F  w  r‰\#        WhV	4       K  	  MV P%                  \        R/ VB 4       V^,          pEK)  	  RRR4       V#   + '       g   i     T# ; i)r   r3   rt   rE   ru   rv   rw   rx   NÚdistrictÚdistrict_enÚdistrict_orÚ
range_nameÚrange_name_enÚrange_name_orrM   rN   rO   r+   c              3  ó:   "  € T F  pV'       g   K  Vx € K  	  R # 5ir#   r   r-   s   & r   r0   Ú-upsert_ofes_establishments.<locals>.<genexpr>³   s"   é € ð .ñ&˜Tô ÷ ’Dó &ùs   ‚
‘
r[   r\   >   r\   r]   r^   r_   r`   r   )ra   rb   rd   re   rC   rf   r   rg   ru   rh   r$   r'   ÚODIA_DISTRICTSÚODIA_RANGESr6   r%   ri   rj   rk   )
rA   rB   rl   rm   r)   ru   Úestablishmentrp   r=   r   s
   &&        r   Úupsert_ofes_establishmentsr�   �   s  € Ø�?‰?×ÒÙà€GØ	�‰˜r¨Kˆ×	8Ô	8¸FÜ—>’> &×)ˆCÜ˜˜G�Ó%ˆEØŸH™HÔ%6Ó7×>Ñ>Ô?P×?VÑ?VÐZ_Ñ?_Ó`×fÑfÓhˆMà˜Ø˜˜F�×)Ñ)Ó+Ø˜3˜v�;×,Ñ,Ó.Øœ; s¨6¥{´NÓC×KÐKÀtØ˜C 
�O×1Ñ1Ó3Ø˜s :�×4Ñ4Ó6Øœ{¨3¨z­?¼NÓKØ˜c ,Õ/×5Ñ5Ó7Ø  \Õ!2×!8Ñ!8Ó!:Ø¤¨S°Õ->ÄÓ!LØ  NÕ 3× 9Ñ 9Ó ;Ø! 3 ~Õ#6×#<Ñ#<Ó#>Ø! 5§:¡:ñ .ä# C¨¥K´Ó@Ü# C¨Õ$5´{ÓCñ&ó.ó $÷ $ð $ð
 Ø˜SŸW™W [°#Ó6×<Ñ<Ó>ÐBcÑcð'ˆF÷* Ø"(§,¡,¦.‘J�CÜ˜M°Ö6ò #1ð —‘Ô(Ñ2¨6Ñ2Ô3Ø�q�L‹Gñ; *÷ 
9ð> €N÷? 
9Ö	8ð> €Nús   ¶IJÊJ	)Ú
__future__r   rd   Úpathlibr   Úsqlalchemy.ormr   Úapp.models.procurementr   Úapp.models.master_datar   r   Ú__file__ÚresolveÚparentsÚBUDGET_HEAD_CSVÚITEM_MASTER_CSVÚOFES_ESTABLISHMENTS_CSVr   r€   r:   r�   rŽ   r'   r7   r>   rq   r‚   r�   r   r!   r   Ú<module>rœ      sˆ  ðÝ "ã 
Ý å "å /ß @ñ �x“.×(Ñ(Ó*×2Ñ2°1Õ5¸Õ>ÐAYÕY€Ù�x“.×(Ñ(Ó*×2Ñ2°1Õ5¸Õ>ÐARÕR€Ù˜x›.×0Ñ0Ó2×:Ñ:¸1Õ=ÀÕFÐIbÕbÐ ð Ð<ØÐ5ØÐ?ØÐ3ØÐBØÐ_ð€ð Ð"Øˆ{Ø	ÐTØÐKØˆ~ð€ð Ð"Øˆ{ØÐDØÐ1ØÐ,ØÐDðÐ ð Ð)Øˆ{Ø
ˆNØÐ+ØÐ*ð€ð ÐBØÐ7ØÐ:ð€õ#õ
	õ0ð 7F÷ &ðR 6E÷ ðB >U÷ $ñ $r!   