+
    V•jÉe  ã                  óº  € ^ RI Ht ^ RIHtHt ^ RIHt ^ RIHtHt ^ RI	H
t
 ^ RIHt  ! R R]4      t ! R	 R
]4      t ! R R]4      t ! R R]]4      t ! R R]4      t ! R R]4      t ! R R]]4      t ! R R]4      t ! R R]4      t ! R R]4      t ! R R]]4      t ! R R]4      t ! R R ]4      t ! R! R"]]4      t ! R# R$]4      t ! R% R&]4      t ! R' R(]]4      t ! R) R*]4      t ! R+ R,]4      t ! R- R.]]4      t  ! R/ R0]4      t! ! R1 R2]4      t" ! R3 R4]!]4      t# ! R5 R6]4      t$ ! R7 R8]4      t% ! R9 R:]$]4      t& ! R; R<]4      t' ! R= R>]4      t( ! R? R@]']4      t) ! RA RB]4      t* ! RC RD]4      t+ ! RE RF]*]4      t, ! RG RH]4      t- ! RI RJ]4      t. ! RK RL]4      t/ ! RM RN]4      t0 ! RO RP]/]4      t1 ! RQ RR]4      t2 ! RS RT]4      t3 ! RU RV]2]4      t4 ! RW RX]4      t5 ! RY RZ]4      t6 ! R[ R\]5]4      t7 ! R] R^]4      t8 ! R_ R`]4      t9 ! Ra Rb]8]4      t: ! Rc Rd]4      t; ! Re Rf]4      t< ! Rg Rh];]4      t= ! Ri Rj]4      t> ! Rk Rl]4      t? ! Rm Rn]>]4      t@ ! Ro Rp]4      tA ! Rq Rr]4      tB ! Rs Rt]A]4      tC ! Ru Rv]4      tD ! Rw Rx]4      tE ! Ry Rz]D]4      tF ! R{ R|]4      tG ! R} R~]4      tH ! R R€]G]4      tIR�# )‚é    )Úannotations)ÚdateÚdatetime)ÚDecimal)ÚFieldÚfield_validator)ÚProcurementStatus)ÚORMModelc                  ó6   € ] tR t^t$ R]R&   R]R&   R]R&   RtR# )ÚAuditFieldsÚintÚidr   Ú
created_atÚ
updated_at© N)Ú__name__Ú
__module__Ú__qualname__Ú__firstlineno__Ú__annotations__Ú__static_attributes__r   ó    Ú5/var/www/html/proc/backend/app/schemas/procurement.pyr   r      s   ‡ ØƒGØÓØ×r   r   c                  ó°   € ] tR t^t$ ]! ^^2R7      tR]R&   R]R&   R]R&   ]! ^ R7      tR]R&   ]! R	4      t	R
]R&   Rt
R]R&   ]P                  tR]R&   RtR# )ÚDemandCreate©Ú
min_lengthÚ
max_lengthÚstrÚ	demand_noÚ
departmentÚitem_description©Úgtr   Úquantityú0.00r   Úestimated_valueNúdate | NoneÚrequired_byr	   Ústatusr   )r   r   r   r   r   r    r   r%   r   r'   r)   r	   Údraftr*   r   r   r   r   r   r      sU   ‡ Ù a°BÔ7€IˆsÓ7ØƒOØÓÙ˜Q”K€HˆcÓÙ& v›€O�WÓ.Ø#€K�Ó#Ø 1× 7Ñ 7€FÐ×7r   r   c                  óŠ   € ] tR t^t$ RtR]R&   RtR]R&   RtR]R&   ]! R^ R7      t	R]R&   Rt
R	]R
&   RtR]R&   RtR]R&   RtR# )ÚDemandUpdateNú
str | Noner    r!   r"   ©Údefaultr$   ú
int | Noner%   úDecimal | Noner'   r(   r)   úProcurementStatus | Noner*   r   )r   r   r   r   r    r   r!   r"   r   r%   r'   r)   r*   r   r   r   r   r-   r-      sQ   ‡ Ø €IˆzÓ Ø!€J�
Ó!Ø#'Ð�jÓ'Ù ¨°!Ô4€HˆjÓ4Ø&*€O�^Ó*Ø#€K�Ó#Ø'+€FÐ$×+r   r-   c                  ó   € ] tR t^%tRtR# )Ú
DemandReadr   N©r   r   r   r   r   r   r   r   r5   r5   %   ó   † Ûr   r5   c                  ó  € ] tR t^)t$ ]! ^ R7      tR]R&   ]! ^^ R7      tR]R&   RtR]R	&   Rt	R]R
&   ]! R^^PR7      t
R]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   ]! ^ ^ R7      tR]R&   RtR]R&   RtR]R&   RtR# )ÚItemDatabaseCreater#   r   Úsr_nor   r   ÚnameNr.   Úname_enÚname_orÚ	Equipment©r0   r   r   Ú	item_typeÚitem_type_enÚitem_type_orÚdescriptionÚdescription_enÚdescription_or©r0   Úger%   ÚremarksTÚboolÚ	is_activer   ©r   r   r   r   r   r:   r   r;   r<   r=   r@   rA   rB   rC   rD   rE   r%   rH   rJ   r   r   r   r   r9   r9   )   sŸ   ‡ Ù˜!”€Eˆ3ÓÙ ¨sÔ3€Dˆ#Ó3Ø€GˆZÓØ€GˆZÓÙ ;¸1ÈÔL€IˆsÓLØ#€L�*Ó#Ø#€L�*Ó#Ø"€K�Ó"Ø!%€N�JÓ%Ø!%€N�JÓ%Ù !¨Ô*€HˆcÓ*Ø€GˆZÓØ€Iˆt×r   r9   c                  ó  € ] tR t^9t$ ]! R^ R7      tR]R&   ]! R^^ R7      tR]R&   RtR]R&   Rt	R]R	&   ]! R^^PR7      t
R]R
&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   ]! R^ R7      tR]R&   RtR]R&   RtR]R&   RtR# )ÚItemDatabaseUpdateNr/   r1   r:   r?   r.   r;   r<   r=   r@   rA   rB   rC   rD   rE   rF   r%   rH   úbool | NonerJ   r   rK   r   r   r   rM   rM   9   s¤   ‡ Ù d¨qÔ1€Eˆ:Ó1Ù T°aÀCÔH€Dˆ*ÓHØ€GˆZÓØ€GˆZÓÙ!¨$¸1ÈÔL€IˆzÓLØ#€L�*Ó#Ø#€L�*Ó#Ø"€K�Ó"Ø!%€N�JÓ%Ø!%€N�JÓ%Ù ¨°!Ô4€HˆjÓ4Ø€GˆZÓØ!€Iˆ{×!r   rM   c                  ó   € ] tR t^ItRtR# )ÚItemDatabaseReadr   Nr6   r   r   r   rP   rP   I   r7   r   rP   c                  óŒ  € ] tR t^Mt$ ]! R^R7      tR]R&   ]! ^R7      tR]R&   RtR]R	&   ]! R^ R7      t	R]R
&   Rt
R]R&   RtR]R&   ]! R^ R7      tR]R&   ]! R^ R7      tR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   ]! RRR7      ]R 4       4       tRtR# )ÚRequisitionItemNrF   r1   Ú	serial_no©r   r   rC   r.   r@   r%   Úchallan_numberr(   Úchallan_dateÚquantity_requiredÚquantity_availableÚpresent_conditionÚcondemnation_statusÚcondemnation_date_yearÚjustificationrH   Údate_of_supplyÚcause_of_unserviceabilityÚunserviceable_remarksÚunitzfloat | NoneÚestimated_costÚbefore©Úmodec                	ó*   € VR9   d   R# VR8X  d   R# V# )ÚPendingÚCondemnablezNot ApplicablezNot Condemnable>   rf   Ú	CondemnedúUnder Processr   ©ÚclsÚvalues   &&r   Únormalize_condemnation_statusÚ-RequisitionItem.normalize_condemnation_statusa   s!   € ð Ð=Ô=Ù ØÐ$Ô$Ù$Øˆr   r   )r   r   r   r   r   rS   r   rC   r@   r%   rU   rV   rW   rX   rY   rZ   r[   r\   rH   r]   r^   r_   r`   ra   r   Úclassmethodrm   r   r   r   r   rR   rR   M   s   ‡ Ù!¨$°1Ô5€IˆzÓ5Ù¨Ô*€K�Ó*Ø €IˆzÓ Ù ¨°!Ô4€HˆjÓ4Ø!%€N�JÓ%Ø $€L�+Ó$Ù$)°$¸1Ô$=Ð�zÓ=Ù%*°4¸AÔ%>Ð˜
Ó>Ø$(Ð�zÓ(Ø&*Ð˜Ó*Ø)-Ð˜JÓ-Ø $€M�:Ó$Ø€GˆZÓØ"&€N�KÓ&Ø,0Ð˜zÓ0Ø(,Ð˜:Ó,Ø€Dˆ*ÓØ#'€N�LÓ'áÐ*°Ô:Øñó ó ;ôr   rR   c                  ó˜  € ] tR t^kt$ R]R&   RtR]R&   RtR]R&   RtR]R	&   RtR]R
&   Rt	R]R&   Rt
R]R&   RtR]R&   RtR]R&   ]! ]R7      tR]R&   RtR]R&   ]! R^ R7      tR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   ]! R^ R7      tR]R&   RtR]R&   ]P2                  tR]R&   RtR]R&   ]! RRR 7      ]R! 4       4       tR"tR# )#ÚRequisitionCreater   Úrequisition_noNr1   Ú	demand_idr(   Úrequisition_dater.   Úrequested_byÚreceived_fromÚreceived_from_districtÚreceived_from_rangeÚsender_nameÚsender_designation©Údefault_factoryzlist[RequisitionItem]Úrequisition_itemsr"   rF   r%   r2   ra   Úprocurement_modeÚbudget_headÚadministrative_approval_dateÚ administrative_approval_quantityÚlifecycle_stager	   Úapproval_statusrH   rb   rc   c                	ó   € Vf   . # T# ©Nr   rj   s   &&r   Údefault_requisition_itemsÚ+RequisitionCreate.default_requisition_items�   ó   € ð ’]ˆrÐ-¨Ð-r   r   ) r   r   r   r   r   rs   rt   ru   rv   rw   rx   ry   rz   r   Úlistr}   r"   r%   ra   r~   r   r€   r�   r‚   r	   Ú	submittedrƒ   rH   r   ro   r†   r   r   r   r   rq   rq   k   s  ‡ ØÓØ €IˆzÓ Ø$(Ð�kÓ(Ø#€L�*Ó#Ø $€M�:Ó$Ø)-Ð˜JÓ-Ø&*Ð˜Ó*Ø"€K�Ó"Ø%)Ð˜
Ó)Ù/4ÀTÔ/JÐÐ,ÓJØ#'Ð�jÓ'Ù ¨°!Ô4€HˆjÓ4Ø%)€N�NÓ)Ø#'Ð�jÓ'Ø"€K�Ó"Ø04Ð  +Ó4Ù38ÀÈ!Ô3LÐ$ jÓLØ"&€O�ZÓ&Ø):×)DÑ)D€OÐ&ÓDØ€GˆZÓáÐ(¨xÔ8Øñ.ó ó 9ô.r   rq   c                  óP  € ] tR t^‡t$ RtR]R&   RtR]R&   RtR]R&   RtR]R&   Rt	R]R	&   Rt
R]R
&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   ]! R^ R7      tR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   ]! R^ R7      tR]R&   RtR]R&   RtR]R&   RtR]R&   RtR# )ÚRequisitionUpdateNr.   rr   r1   rs   r(   rt   ru   rv   rw   rx   ry   rz   zlist[RequisitionItem] | Noner}   r"   rF   r%   r2   ra   r~   r   r€   r�   r‚   r3   rƒ   rH   r   )r   r   r   r   rr   r   rs   rt   ru   rv   rw   rx   ry   rz   r}   r"   r   r%   ra   r~   r   r€   r�   r‚   rƒ   rH   r   r   r   r   rŒ   rŒ   ‡   sã   ‡ Ø!%€N�JÓ%Ø €IˆzÓ Ø$(Ð�kÓ(Ø#€L�*Ó#Ø $€M�:Ó$Ø)-Ð˜JÓ-Ø&*Ð˜Ó*Ø"€K�Ó"Ø%)Ð˜
Ó)Ø6:ÐÐ3Ó:Ø#'Ð�jÓ'Ù ¨°!Ô4€HˆjÓ4Ø%)€N�NÓ)Ø#'Ð�jÓ'Ø"€K�Ó"Ø04Ð  +Ó4Ù38ÀÈ!Ô3LÐ$ jÓLØ"&€O�ZÓ&Ø04€OÐ-Ó4Ø€GˆZ×r   rŒ   c                  ó   € ] tR t^žtRtR# )ÚRequisitionReadr   Nr6   r   r   r   rŽ   rŽ   ž   r7   r   rŽ   c                  óò   € ] tR t^¢t$ R]R&   RtR]R&   ]! R^ R7      tR]R&   RtR]R	&   R]R
&   Rt	R]R&   Rt
R]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR# )ÚProcurementCaseCreater   Úprocurement_case_noNr1   Úrequisition_idrF   Úapproved_quantityr2   Úapproved_estimated_costr~   úIn Tendering ProcessÚcase_statusr(   Úmode_selection_dater.   Úmode_selected_byrN   Úemd_applicableÚpbg_applicableÚfile_noÚsanction_noÚsanction_dateÚapproving_authorityrH   r   )r   r   r   r   r   r’   r   r“   r”   r–   r—   r˜   r™   rš   r›   rœ   r�   rž   rH   r   r   r   r   r�   r�   ¢   sœ   ‡ ØÓØ!%€N�JÓ%Ù$)°$¸1Ô$=Ð�zÓ=Ø.2Ð˜^Ó2ØÓØ-€K�Ó-Ø'+Ð˜Ó+Ø#'Ð�jÓ'Ø"&€N�KÓ&Ø"&€N�KÓ&Ø€GˆZÓØ"€K�Ó"Ø!%€M�;Ó%Ø&*Ð˜Ó*Ø€GˆZ×r   r�   c                  óú   € ] tR t^´t$ RtR]R&   RtR]R&   ]! R^ R7      tR]R&   Rt	R]R	&   Rt
R]R
&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR# )ÚProcurementCaseUpdateNr.   r‘   r1   r’   rF   r“   r2   r”   r~   r–   r(   r—   r˜   rN   r™   rš   r›   rœ   r�   rž   rH   r   )r   r   r   r   r‘   r   r’   r   r“   r”   r~   r–   r—   r˜   r™   rš   r›   rœ   r�   rž   rH   r   r   r   r   r    r    ´   s¦   ‡ Ø&*Ð˜Ó*Ø!%€N�JÓ%Ù$)°$¸1Ô$=Ð�zÓ=Ø.2Ð˜^Ó2Ø#'Ð�jÓ'Ø"€K�Ó"Ø'+Ð˜Ó+Ø#'Ð�jÓ'Ø"&€N�KÓ&Ø"&€N�KÓ&Ø€GˆZÓØ"€K�Ó"Ø!%€M�;Ó%Ø&*Ð˜Ó*Ø€GˆZ×r   r    c                  ó4   € ] tR t^Æt$ RtR]R&   RtR]R&   RtR# )ÚProcurementCaseReadFrI   r™   rš   r   N)r   r   r   r   r™   r   rš   r   r   r   r   r¢   r¢   Æ   s   ‡ Ø €N�DÓ Ø €N�D× r   r¢   c                  óÊ   € ] tR t^Ët$ R]R&   RtR]R&   RtR]R&   RtR	]R
&   RtR]R&   Rt	R	]R&   Rt
R]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR# )ÚGeMProcurementCaseCreater   Úprocurement_case_idzProduct / Normal Category Bidr   Úgem_procurement_typeNr.   Ú
gem_bid_nor(   Úgem_bid_dateÚgem_contract_noÚgem_contract_dater2   Úgem_order_valuer1   Ú	vendor_idÚdelivery_statusÚdelivery_delay_reasonÚdelivery_delay_document_pathÚpayment_statusr•   r*   r   )r   r   r   r   r   r¦   r§   r¨   r©   rª   r«   r¬   r­   r®   r¯   r°   r*   r   r   r   r   r¤   r¤   Ë   s„   ‡ ØÓØ ?Ð˜#Ó?Ø!€J�
Ó!Ø $€L�+Ó$Ø"&€O�ZÓ&Ø%)Ð�{Ó)Ø&*€O�^Ó*Ø €IˆzÓ Ø"&€O�ZÓ&Ø(,Ð˜:Ó,Ø/3Ð  *Ó3Ø!%€N�JÓ%Ø(€FˆC×(r   r¤   c                  óÎ   € ] tR t^Ût$ RtR]R&   RtR]R&   RtR]R&   RtR]R&   Rt	R]R	&   Rt
R]R
&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR# )ÚGeMProcurementCaseUpdateNr1   r¥   r.   r¦   r§   r(   r¨   r©   rª   r2   r«   r¬   r­   r®   r¯   r°   r*   r   )r   r   r   r   r¥   r   r¦   r§   r¨   r©   rª   r«   r¬   r­   r®   r¯   r°   r*   r   r   r   r   r²   r²   Û   s‰   ‡ Ø&*Ð˜Ó*Ø'+Ð˜*Ó+Ø!€J�
Ó!Ø $€L�+Ó$Ø"&€O�ZÓ&Ø%)Ð�{Ó)Ø&*€O�^Ó*Ø €IˆzÓ Ø"&€O�ZÓ&Ø(,Ð˜:Ó,Ø/3Ð  *Ó3Ø!%€N�JÓ%Ø€FˆJ×r   r²   c                  ó   € ] tR t^ëtRtR# )ÚGeMProcurementCaseReadr   Nr6   r   r   r   r´   r´   ë   r7   r   r´   c                  óð   € ] tR t^ït$ R]R&   R]R&   RtR]R&   RtR]R&   RtR]R	&   RtR]R
&   Rt	R]R&   Rt
R]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR# )ÚETenderCaseCreater   r¥   r   Útender_ref_noNr(   Útender_publication_dateÚpre_bid_meeting_dateÚbid_submission_end_dateÚtechnical_bid_opening_dateÚfinancial_bid_opening_dater2   ra   r.   Útechnical_evaluation_statusÚfinancial_evaluation_statusr1   Úl1_vendor_idÚaward_approval_dateÚloa_noÚloa_dateÚcontract_nor•   r*   r   )r   r   r   r   r   r¸   r¹   rº   r»   r¼   ra   r½   r¾   r¿   rÀ   rÁ   rÂ   rÃ   r*   r   r   r   r   r¶   r¶   ï   s¢   ‡ ØÓØÓØ+/Ð˜[Ó/Ø(,Ð˜+Ó,Ø+/Ð˜[Ó/Ø.2Ð Ó2Ø.2Ð Ó2Ø%)€N�NÓ)Ø.2Ð Ó2Ø.2Ð Ó2Ø#€L�*Ó#Ø'+Ð˜Ó+Ø€FˆJÓØ €HˆkÓ Ø"€K�Ó"Ø(€FˆC×(r   r¶   c                  óø   € ] tR tRt$ RtR]R&   RtR]R&   RtR]R&   RtR]R	&   Rt	R]R
&   Rt
R]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR# )ÚETenderCaseUpdatei  Nr1   r¥   r.   r·   r(   r¸   r¹   rº   r»   r¼   r2   ra   r½   r¾   r¿   rÀ   rÁ   rÂ   rÃ   r*   r   )r   r   r   r   r¥   r   r·   r¸   r¹   rº   r»   r¼   ra   r½   r¾   r¿   rÀ   rÁ   rÂ   rÃ   r*   r   r   r   r   rÅ   rÅ     s«   ‡ Ø&*Ð˜Ó*Ø $€M�:Ó$Ø+/Ð˜[Ó/Ø(,Ð˜+Ó,Ø+/Ð˜[Ó/Ø.2Ð Ó2Ø.2Ð Ó2Ø%)€N�NÓ)Ø.2Ð Ó2Ø.2Ð Ó2Ø#€L�*Ó#Ø'+Ð˜Ó+Ø€FˆJÓØ €HˆkÓ Ø"€K�Ó"Ø€FˆJ×r   rÅ   c                  ó   € ] tR tRtRtR# )ÚETenderCaseReadi  r   Nr6   r   r   r   rÇ   rÇ     r7   r   rÇ   c                  óÆ   € ] tR tRt$ R]R&   R]R&   RtR]R&   RtR]R	&   RtR]R
&   RtR]R&   Rt	R]R&   Rt
R]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR# )ÚGlobalTenderCaseCreatei  r   r¥   r   Úglobal_tender_ref_noNr.   Úcountry_of_vendorÚforeign_vendor_nameÚforeign_currencyr2   Úexchange_rateÚbid_value_foreign_currencyÚbid_value_inrr½   Úcommercial_evaluation_statusr(   Úapproval_daterÃ   r•   r*   r   )r   r   r   r   r   rË   rÌ   rÍ   rÎ   rÏ   rÐ   r½   rÑ   rÒ   rÃ   r*   r   r   r   r   rÉ   rÉ     s‚   ‡ ØÓØÓØ$(Ð�zÓ(Ø&*Ð˜Ó*Ø#'Ð�jÓ'Ø$(€M�>Ó(Ø15Ð Ó5Ø$(€M�>Ó(Ø.2Ð Ó2Ø/3Ð  *Ó3Ø!%€M�;Ó%Ø"€K�Ó"Ø(€FˆC×(r   rÉ   c                  óÎ   € ] tR tRt$ RtR]R&   RtR]R&   RtR]R&   RtR]R&   Rt	R]R	&   Rt
R
]R&   RtR
]R&   RtR
]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR# )ÚGlobalTenderCaseUpdatei)  Nr1   r¥   r.   rÊ   rË   rÌ   rÍ   r2   rÎ   rÏ   rÐ   r½   rÑ   r(   rÒ   rÃ   r*   r   )r   r   r   r   r¥   r   rÊ   rË   rÌ   rÍ   rÎ   rÏ   rÐ   r½   rÑ   rÒ   rÃ   r*   r   r   r   r   rÔ   rÔ   )  sŒ   ‡ Ø&*Ð˜Ó*Ø'+Ð˜*Ó+Ø$(Ð�zÓ(Ø&*Ð˜Ó*Ø#'Ð�jÓ'Ø$(€M�>Ó(Ø15Ð Ó5Ø$(€M�>Ó(Ø.2Ð Ó2Ø/3Ð  *Ó3Ø!%€M�;Ó%Ø"€K�Ó"Ø€FˆJ×r   rÔ   c                  ó   € ] tR tRtRtR# )ÚGlobalTenderCaseReadi9  r   Nr6   r   r   r   rÖ   rÖ   9  r7   r   rÖ   c                  ó°   € ] tR tRt$ R]R&   RtR]R&   RtR]R&   RtR]R	&   ]! R^ R
7      t	R]R&   Rt
R]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR# )ÚLPCProcurementCaseCreatei=  r   r¥   Nr.   Úlpc_meeting_nor(   Úlpc_meeting_dateÚcommittee_membersrF   r1   Úquotation_countÚlowest_vendor_idÚcomparative_statement_pathÚrecommendation_daterÒ   r•   r   r*   r   )r   r   r   r   r   rÙ   rÚ   rÛ   r   rÜ   rÝ   rÞ   rß   rÒ   r*   r   r   r   r   rØ   rØ   =  sn   ‡ ØÓØ!%€N�JÓ%Ø$(Ð�kÓ(Ø$(Ð�zÓ(Ù"'°¸Ô";€O�ZÓ;Ø#'Ð�jÓ'Ø-1Ð 
Ó1Ø'+Ð˜Ó+Ø!%€M�;Ó%Ø(€FˆC×(r   rØ   c                  ó´   € ] tR tRt$ RtR]R&   RtR]R&   RtR]R&   RtR]R	&   ]	! R^ R
7      t
R]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR# )ÚLPCProcurementCaseUpdateiJ  Nr1   r¥   r.   rÙ   r(   rÚ   rÛ   rF   rÜ   rÝ   rÞ   rß   rÒ   r*   r   )r   r   r   r   r¥   r   rÙ   rÚ   rÛ   r   rÜ   rÝ   rÞ   rß   rÒ   r*   r   r   r   r   rá   rá   J  ss   ‡ Ø&*Ð˜Ó*Ø!%€N�JÓ%Ø$(Ð�kÓ(Ø$(Ð�zÓ(Ù"'°¸Ô";€O�ZÓ;Ø#'Ð�jÓ'Ø-1Ð 
Ó1Ø'+Ð˜Ó+Ø!%€M�;Ó%Ø€FˆJ×r   rá   c                  ó   € ] tR tRtRtR# )ÚLPCProcurementCaseReadiW  r   Nr6   r   r   r   rã   rã   W  r7   r   rã   c                  ó”   € ] tR tRt$ R]R&   RtR]R&   RtR]R&   ]! R^ R	7      tR
]R&   Rt	R
]R&   Rt
R]R&   RtR]R&   RtR]R&   RtR# )ÚOpenMarketCaseCreatei[  r   r¥   Nr.   Úprocurement_justificationr(   Úmarket_survey_daterF   r1   rÜ   Úselected_vendor_idrÞ   rÒ   r•   r   r*   r   )r   r   r   r   r   ræ   rç   r   rÜ   rè   rÞ   rÒ   r*   r   r   r   r   rå   rå   [  sY   ‡ ØÓØ,0Ð˜zÓ0Ø&*Ð˜Ó*Ù"'°¸Ô";€O�ZÓ;Ø%)Ð˜
Ó)Ø-1Ð 
Ó1Ø!%€M�;Ó%Ø(€FˆC×(r   rå   c                  ó˜   € ] tR tRt$ RtR]R&   RtR]R&   RtR]R&   ]! R^ R	7      t	R]R
&   Rt
R]R&   RtR]R&   RtR]R&   RtR]R&   RtR# )ÚOpenMarketCaseUpdateif  Nr1   r¥   r.   ræ   r(   rç   rF   rÜ   rè   rÞ   rÒ   r*   r   )r   r   r   r   r¥   r   ræ   rç   r   rÜ   rè   rÞ   rÒ   r*   r   r   r   r   rê   rê   f  s^   ‡ Ø&*Ð˜Ó*Ø,0Ð˜zÓ0Ø&*Ð˜Ó*Ù"'°¸Ô";€O�ZÓ;Ø%)Ð˜
Ó)Ø-1Ð 
Ó1Ø!%€M�;Ó%Ø€FˆJ×r   rê   c                  ó   € ] tR tRtRtR# )ÚOpenMarketCaseReadiq  r   Nr6   r   r   r   rì   rì   q  r7   r   rì   c                  óv   € ] tR tRt$ R]R&   RtR]R&   RtR]R&   RtR]R&   RtR	]R
&   Rt	R]R&   Rt
R]R&   RtR# )ÚOtherProcurementCaseCreateiu  r   r¥   Nr.   Úother_procurement_typeÚprocurement_reference_noÚprocurement_descriptionr1   r¬   r(   rÒ   r•   r   r*   r   )r   r   r   r   r   rï   rð   rñ   r¬   rÒ   r*   r   r   r   r   rî   rî   u  sG   ‡ ØÓØ)-Ð˜JÓ-Ø+/Ð˜jÓ/Ø*.Ð˜ZÓ.Ø €IˆzÓ Ø!%€M�;Ó%Ø(€FˆC×(r   rî   c                  óz   € ] tR tRt$ RtR]R&   RtR]R&   RtR]R&   RtR]R&   Rt	R]R	&   Rt
R
]R&   RtR]R&   RtR# )ÚOtherProcurementCaseUpdatei  Nr1   r¥   r.   rï   rð   rñ   r¬   r(   rÒ   r*   r   )r   r   r   r   r¥   r   rï   rð   rñ   r¬   rÒ   r*   r   r   r   r   ró   ró     sL   ‡ Ø&*Ð˜Ó*Ø)-Ð˜JÓ-Ø+/Ð˜jÓ/Ø*.Ð˜ZÓ.Ø €IˆzÓ Ø!%€M�;Ó%Ø€FˆJ×r   ró   c                  ó   € ] tR tRtRtR# )ÚOtherProcurementCaseReadi‰  r   Nr6   r   r   r   rõ   rõ   ‰  r7   r   rõ   c                  ó¨   € ] tR tRt$ ]! R^R7      tR]R&   ]! ^R7      tR]R&   RtR	]R
&   Rt	R	]R&   Rt
R	]R&   ]! R^ R7      tR]R&   RtR	]R&   RtR# )Ú
SampleItemi�  NrF   r1   rS   rT   r   rC   r.   ÚmakeÚmodelÚ
make_modelr%   r`   r   )r   r   r   r   r   rS   r   rC   rø   rù   rú   r%   r`   r   r   r   r   r÷   r÷   �  s[   ‡ Ù!¨$°1Ô5€IˆzÓ5Ù¨Ô*€K�Ó*Ø€Dˆ*ÓØ€Eˆ:ÓØ!€J�
Ó!Ù ¨°!Ô4€HˆjÓ4Ø€Dˆ*×r   r÷   c                  óŒ   € ] tR tRt$ ]! R^R7      tR]R&   ]! ^R7      tR]R&   RtR	]R
&   ]! R^ R7      t	R]R&   Rt
R	]R&   RtR# )Ú
TenderItemi—  NrF   r1   rS   rT   r   rC   r.   r@   r%   r`   r   )r   r   r   r   r   rS   r   rC   r@   r%   r`   r   r   r   r   rü   rü   —  sG   ‡ Ù!¨$°1Ô5€IˆzÓ5Ù¨Ô*€K�Ó*Ø €IˆzÓ Ù ¨°!Ô4€HˆjÓ4Ø€Dˆ*×r   rü   c                  ó
  € ] tR tRt$ ]! R^R7      tR]R&   R]R&   RtR]R&   RtR]R	&   Rt	R
]R&   Rt
R]R&   ]! ]R7      tR]R&   RtR
]R&   ]! R^ R7      tR]R&   RtR]R&   RtR
]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   ]! R^ R7      tR]R&   RtR]R&   RtR
]R&   RtR
]R&   RtR]R&   RtR]R &   RtR
]R!&   RtR]R"&   RtR]R#&   R$tR]R%&   ] PB                  t"R&]R'&   ]#! RR(R)7      ]$R* 4       4       t%R+t&R# ),ÚTenderBidCreateiŸ  NrF   r1   rS   r   Ú	tender_nor’   r¥   r.   Útitler(   Útender_dater{   zlist[TenderItem]Útender_itemsÚ	item_namer%   r2   ra   r   Úbid_published_dateÚbid_closed_dater»   Úproduct_demo_dateÚtechnical_evaluation_dateÚtechnical_qualified_biddersr¼   Úl1_bidder_nameÚcontract_numberÚcontract_dateÚamountrH   Úpublication_dateÚclosing_datezOpen TenderÚbid_typer	   r*   rb   rc   c                	ó   € Vf   . # T# r…   r   rj   s   &&r   Údefault_tender_itemsÚ$TenderBidCreate.default_tender_items¼  rˆ   r   r   )'r   r   r   r   r   rS   r   r’   r¥   r   r  r‰   r  r  r%   ra   r   r  r  r»   r  r  r  r¼   r	  r
  r  r  rH   r  r  r  r	   Úin_progressr*   r   ro   r  r   r   r   r   rþ   rþ   Ÿ  sV  ‡ Ù!¨$°1Ô5€IˆzÓ5ØƒNØ!%€N�JÓ%Ø&*Ð˜Ó*Ø€Eˆ:ÓØ#€K�Ó#Ù%*¸4Ô%@€LÐ"Ó@Ø €IˆzÓ Ù ¨°!Ô4€HˆjÓ4Ø%)€N�NÓ)Ø"€K�Ó"Ø&*Ð˜Ó*Ø#'€O�[Ó'Ø.2Ð Ó2Ø%)Ð�{Ó)Ø-1Ð˜{Ó1Ù.3¸DÀQÔ.GÐ ÓGØ.2Ð Ó2Ø!%€N�JÓ%Ø"&€O�ZÓ&Ø!%€M�;Ó%Ø!€FˆNÓ!Ø€GˆZÓØ$(Ð�kÓ(Ø $€L�+Ó$Ø!€HˆcÓ!Ø 1× =Ñ =€FÐÓ=á�^¨(Ô3Øñ.ó ó 4ô.r   rþ   c                  óÂ  € ] tR tRt$ ]! R^R7      tR]R&   RtR]R&   RtR]R&   Rt	R]R	&   Rt
R]R
&   RtR]R&   RtR]R&   RtR]R&   ]! R^ R7      tR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   ]! R^ R7      tR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R &   RtR]R!&   RtR]R"&   Rt R#]R$&   R%t!R# )&ÚTenderBidUpdateiÂ  NrF   r1   rS   r.   rÿ   r’   r¥   r   r(   r  zlist[TenderItem] | Noner  r  r%   r2   ra   r   r  r  r»   r  r  r  r¼   r	  r
  r  r  rH   r  r  r  r3   r*   r   )"r   r   r   r   r   rS   r   rÿ   r’   r¥   r   r  r  r  r%   ra   r   r  r  r»   r  r  r  r¼   r	  r
  r  r  rH   r  r  r  r*   r   r   r   r   r  r  Â  s/  ‡ Ù!¨$°1Ô5€IˆzÓ5Ø €IˆzÓ Ø!%€N�JÓ%Ø&*Ð˜Ó*Ø€Eˆ:ÓØ#€K�Ó#Ø,0€LÐ)Ó0Ø €IˆzÓ Ù ¨°!Ô4€HˆjÓ4Ø%)€N�NÓ)Ø"€K�Ó"Ø&*Ð˜Ó*Ø#'€O�[Ó'Ø.2Ð Ó2Ø%)Ð�{Ó)Ø-1Ð˜{Ó1Ù.3¸DÀQÔ.GÐ ÓGØ.2Ð Ó2Ø!%€N�JÓ%Ø"&€O�ZÓ&Ø!%€M�;Ó%Ø!€FˆNÓ!Ø€GˆZÓØ$(Ð�kÓ(Ø $€L�+Ó$Ø€HˆjÓØ'+€FÐ$×+r   r  c                  ó   € ] tR tRtRtR# )ÚTenderBidReadià  r   Nr6   r   r   r   r  r  à  r7   r   r  c                  óX  € ] tR tRt$ RtR]R&   RtR]R&   ]! R^R7      tR]R&   Rt	R]R	&   Rt
R
]R&   RtR]R&   RtR
]R&   RtR]R&   R]R&   RtR]R&   RtR]R&   RtR
]R&   RtR]R&   RtR]R&   RtR
]R&   RtR
]R&   RtR
]R&   RtR]R&   RtR]R&   RtR]R&   RtR
]R&   RtR]R&   R tR# )!Ú	EMDCreateiä  Nr1   Ú	tender_idr¥   rF   rS   r.   Úemd_unique_idr(   Ú
entry_dateÚtender_numberr  r  r   Úbidder_nameÚemd_formÚemd_noÚemd_dater2   r  Úissuing_branchÚbank_confirmation_dateÚexpiry_dateÚreturned_dateÚreturn_detailsrH   Úinstrument_noÚreceived_daterf   Úrefund_statusr   )r   r   r   r   r  r   r¥   r   rS   r  r  r  r  r  r  r   r!  r  r"  r#  r$  r%  r&  rH   r'  r(  r)  r   r   r   r   r  r  ä  sã   ‡ Ø €IˆzÓ Ø&*Ð˜Ó*Ù!¨$°1Ô5€IˆzÓ5Ø $€M�:Ó$Ø"€J�Ó"Ø $€M�:Ó$Ø#€K�Ó#Ø €IˆzÓ ØÓØ€HˆjÓØ€FˆJÓØ €HˆkÓ Ø!€FˆNÓ!Ø!%€N�JÓ%Ø*.Ð˜KÓ.Ø#€K�Ó#Ø!%€M�;Ó%Ø!%€N�JÓ%Ø€GˆZÓØ $€M�:Ó$Ø!%€M�;Ó%Ø"€M�3×"r   r  c                  ó\  € ] tR tRt$ RtR]R&   RtR]R&   ]! R^R7      tR]R&   Rt	R]R	&   Rt
R
]R&   RtR]R&   RtR
]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR
]R&   RtR]R&   RtR]R&   RtR
]R&   RtR
]R&   RtR
]R&   RtR]R&   RtR]R&   RtR]R&   RtR
]R&   RtR]R&   RtR# )Ú	EMDUpdateiý  Nr1   r  r¥   rF   rS   r.   r  r(   r  r  r  r  r  r  r   r!  r2   r  r"  r#  r$  r%  r&  rH   r'  r(  r)  r   )r   r   r   r   r  r   r¥   r   rS   r  r  r  r  r  r  r  r   r!  r  r"  r#  r$  r%  r&  rH   r'  r(  r)  r   r   r   r   r+  r+  ý  sç   ‡ Ø €IˆzÓ Ø&*Ð˜Ó*Ù!¨$°1Ô5€IˆzÓ5Ø $€M�:Ó$Ø"€J�Ó"Ø $€M�:Ó$Ø#€K�Ó#Ø €IˆzÓ Ø"€K�Ó"Ø€HˆjÓØ€FˆJÓØ €HˆkÓ Ø!€FˆNÓ!Ø!%€N�JÓ%Ø*.Ð˜KÓ.Ø#€K�Ó#Ø!%€M�;Ó%Ø!%€N�JÓ%Ø€GˆZÓØ $€M�:Ó$Ø!%€M�;Ó%Ø $€M�:×$r   r+  c                  ó   € ] tR tRtRtR# )ÚEMDReadi  r   Nr6   r   r   r   r-  r-    r7   r   r-  c                  ó˜  € ] tR tRt$ ]! R^R7      tR]R&   RtR]R&   RtR]R&   Rt	R]R	&   Rt
R
]R&   ]! ]R7      tR]R&   RtR]R&   ]! R^ R7      tR]R&   RtR
]R&   R]R&   RtR]R&   RtR]R&   RtR]R&   RtR
]R&   RtR]R&   RtR
]R&   RtR]R&   RtR]R&   RtR
]R&   ]P4                  tR]R&   ]! RRR 7      ]R! 4       4       tR"tR# )#ÚSampleRegisterCreatei  NrF   r1   rS   r  r¥   r.   r  r(   r  r{   zlist[SampleItem]Úsample_itemsr  r%   Údemonstration_dater   r  rø   rù   rú   Úreceipt_dateÚrecipient_nameÚreturn_daterH   Úsample_descriptionr(  r	   Úevaluation_statusrb   rc   c                	ó   € Vf   . # T# r…   r   rj   s   &&r   Údefault_sample_itemsÚ)SampleRegisterCreate.default_sample_items0  rˆ   r   r   ) r   r   r   r   r   rS   r   r  r¥   r  r  r‰   r0  r  r%   r1  rø   rù   rú   r2  r3  r4  rH   r5  r(  r	   rŠ   r6  r   ro   r8  r   r   r   r   r/  r/    s  ‡ Ù!¨$°1Ô5€IˆzÓ5Ø €IˆzÓ Ø&*Ð˜Ó*Ø $€M�:Ó$Ø#€K�Ó#Ù%*¸4Ô%@€LÐ"Ó@Ø €IˆzÓ Ù ¨°!Ô4€HˆjÓ4Ø&*Ð˜Ó*ØÓØ€Dˆ*ÓØ€Eˆ:ÓØ!€J�
Ó!Ø $€L�+Ó$Ø!%€N�JÓ%Ø#€K�Ó#Ø€GˆZÓØ%)Ð˜
Ó)Ø!%€M�;Ó%Ø+<×+FÑ+FÐÐ(ÓFá�^¨(Ô3Øñ.ó ó 4ô.r   r/  c                  óP  € ] tR tRt$ ]! R^R7      tR]R&   RtR]R&   RtR]R&   Rt	R]R	&   Rt
R
]R&   RtR]R&   RtR]R&   ]! R^ R7      tR]R&   RtR
]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR
]R&   RtR]R&   RtR
]R&   RtR]R&   RtR]R&   RtR
]R&   RtR]R&   RtR# )ÚSampleRegisterUpdatei6  NrF   r1   rS   r  r¥   r.   r  r(   r  zlist[SampleItem] | Noner0  r  r%   r1  r  rø   rù   rú   r2  r3  r4  rH   r5  r(  r3   r6  r   )r   r   r   r   r   rS   r   r  r¥   r  r  r0  r  r%   r1  r  rø   rù   rú   r2  r3  r4  rH   r5  r(  r6  r   r   r   r   r;  r;  6  sÞ   ‡ Ù!¨$°1Ô5€IˆzÓ5Ø €IˆzÓ Ø&*Ð˜Ó*Ø $€M�:Ó$Ø#€K�Ó#Ø,0€LÐ)Ó0Ø €IˆzÓ Ù ¨°!Ô4€HˆjÓ4Ø&*Ð˜Ó*Ø"€K�Ó"Ø€Dˆ*ÓØ€Eˆ:ÓØ!€J�
Ó!Ø $€L�+Ó$Ø!%€N�JÓ%Ø#€K�Ó#Ø€GˆZÓØ%)Ð˜
Ó)Ø!%€M�;Ó%Ø26ÐÐ/×6r   r;  c                  ó   € ] tR tRtRtR# )ÚSampleRegisterReadiM  r   Nr6   r   r   r   r=  r=  M  r7   r   r=  c                  ó~   € ] tR tRt$ R]R&   RtR]R&   R]R&   R]R	&   ]! ^ ^dR
7      tR]R&   RtR]R&   Rt	R]R&   Rt
R# )ÚTechnicalEvaluationCreateiQ  r   r  Nr1   r¥   r   r  Ú	evaluator)rG   ÚleÚscorerf   Úresultr.   rH   r   )r   r   r   r   r   r¥   r   rB  rC  rH   r   r   r   r   r?  r?  Q  sB   ‡ ØƒNØ&*Ð˜Ó*ØÓØƒNÙ˜! Ô$€Eˆ3Ó$Ø€FˆCÓØ€GˆZ×r   r?  c                  óŒ   € ] tR tRt$ RtR]R&   RtR]R&   RtR]R&   RtR]R&   ]	! R^ ^dR	7      t
R]R
&   RtR]R&   RtR]R&   RtR# )ÚTechnicalEvaluationUpdatei[  Nr1   r  r¥   r.   r  r@  )r0   rG   rA  rB  rC  rH   r   )r   r   r   r   r  r   r¥   r  r@  r   rB  rC  rH   r   r   r   r   rE  rE  [  sR   ‡ Ø €IˆzÓ Ø&*Ð˜Ó*Ø"€K�Ó"Ø €IˆzÓ Ù d¨q°SÔ9€Eˆ:Ó9Ø€FˆJÓØ€GˆZ×r   rE  c                  ó   € ] tR tRtRtR# )ÚTechnicalEvaluationReadie  r   Nr6   r   r   r   rG  rG  e  r7   r   rG  c                  ón   € ] tR tRt$ R]R&   RtR]R&   R]R&   R	]R
&   RtR]R&   RtR]R&   RtR]R&   Rt	R# )ÚFinancialEvaluationCreateii  r   r  Nr1   r¥   r   r  r   Úquoted_amountr2   Únegotiated_amountÚrankrf   rC  r   )
r   r   r   r   r   r¥   rK  rL  rC  r   r   r   r   rI  rI  i  s=   ‡ ØƒNØ&*Ð˜Ó*ØÓØÓØ(,Ð�~Ó,Ø€Dˆ*ÓØ€FˆC×r   rI  c                  óz   € ] tR tRt$ RtR]R&   RtR]R&   RtR]R&   RtR]R	&   Rt	R]R
&   Rt
R]R&   RtR]R&   RtR# )ÚFinancialEvaluationUpdateis  Nr1   r  r¥   r.   r  r2   rJ  rK  rL  rC  r   )r   r   r   r   r  r   r¥   r  rJ  rK  rL  rC  r   r   r   r   rN  rN  s  sJ   ‡ Ø €IˆzÓ Ø&*Ð˜Ó*Ø"€K�Ó"Ø$(€M�>Ó(Ø(,Ð�~Ó,Ø€Dˆ*ÓØ€FˆJ×r   rN  c                  ó   € ] tR tRtRtR# )ÚFinancialEvaluationReadi}  r   Nr6   r   r   r   rP  rP  }  r7   r   rP  c                  ó"  € ] tR tRt$ R]R&   RtR]R&   RtR]R&   RtR]R	&   RtR]R
&   Rt	R]R&   Rt
R]R&   RtR]R&   RtR]R&   R]R&   RtR]R&   ]! R^ R7      tR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   ]P*                  tR]R&   RtR# )ÚPurchaseOrderCreatei�  r   Úpo_noNr1   r  r¥   r.   r~   Útender_reference_nor(   Útender_reference_dater2   ra   Úprocess_initiate_dater   Úvendor_namer"   rF   r%   r`   Úpo_dateÚpo_valueÚdelivery_due_dater	   r*   r   )r   r   r   r   r   r  r¥   r~   rT  rU  ra   rV  r   r"   r   r%   r`   rX  rY  rZ  r	   Úapprovedr*   r   r   r   r   rR  rR  �  s¸   ‡ ØƒJØ €IˆzÓ Ø&*Ð˜Ó*Ø#'Ð�jÓ'Ø&*Ð˜Ó*Ø)-Ð˜;Ó-Ø%)€N�NÓ)Ø)-Ð˜;Ó-Ø"€K�Ó"ØÓØ#'Ð�jÓ'Ù ¨°!Ô4€HˆjÓ4Ø€Dˆ*ÓØ€Gˆ[ÓØ#€HˆnÓ#Ø%)Ð�{Ó)Ø 1× :Ñ :€FÐ×:r   rR  c                  ó  € ] tR tRt$ RtR]R&   RtR]R&   RtR]R&   RtR]R&   Rt	R]R	&   Rt
R
]R&   RtR]R&   RtR
]R&   RtR]R&   RtR]R&   RtR]R&   ]! R^ R7      tR]R&   RtR]R&   RtR
]R&   RtR]R&   RtR
]R&   RtR]R&   RtR# )ÚPurchaseOrderUpdatei•  Nr.   rS  r1   r  r¥   r~   rT  r(   rU  r2   ra   rV  r   rW  r"   rF   r%   r`   rX  rY  rZ  r3   r*   r   )r   r   r   r   rS  r   r  r¥   r~   rT  rU  ra   rV  r   rW  r"   r   r%   r`   rX  rY  rZ  r*   r   r   r   r   r]  r]  •  s»   ‡ Ø€Eˆ:ÓØ €IˆzÓ Ø&*Ð˜Ó*Ø#'Ð�jÓ'Ø&*Ð˜Ó*Ø)-Ð˜;Ó-Ø%)€N�NÓ)Ø)-Ð˜;Ó-Ø"€K�Ó"Ø"€K�Ó"Ø#'Ð�jÓ'Ù ¨°!Ô4€HˆjÓ4Ø€Dˆ*ÓØ€Gˆ[ÓØ#€HˆnÓ#Ø%)Ð�{Ó)Ø'+€FÐ$×+r   r]  c                  ó   € ] tR tRtRtR# )ÚPurchaseOrderReadi©  r   Nr6   r   r   r   r_  r_  ©  r7   r   r_  c                  ój  € ] tR tRt$ RtR]R&   RtR]R&   RtR]R&   RtR]R	&   Rt	R]R
&   Rt
R]R&   ]! R^ R7      tR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R &   R!tR# )"ÚPerformanceSecurityCreatei­  Nr1   Úpo_idr¥   r(   r  r.   r
  r  r  rF   r%   rW  r  Úsecurity_formÚsecurity_numberÚsecurity_dater2   r  r"  r#  r$  Úwarranty_periodr4  r&  rH   r'  Úvalid_untilÚHeldr   Úrelease_statusr   ©r   r   r   r   rb  r   r¥   r  r
  r  r  r   r%   rW  r  rc  rd  re  r  r"  r#  r$  rf  r4  r&  rH   r'  rg  ri  r   r   r   r   ra  ra  ­  sñ   ‡ Ø€Eˆ:ÓØ&*Ð˜Ó*Ø"€J�Ó"Ø"&€O�ZÓ&Ø!%€M�;Ó%Ø €IˆzÓ Ù ¨°!Ô4€HˆjÓ4Ø"€K�Ó"Ø"€K�Ó"Ø $€M�:Ó$Ø"&€O�ZÓ&Ø!%€M�;Ó%Ø!€FˆNÓ!Ø!%€N�JÓ%Ø*.Ð˜KÓ.Ø#€K�Ó#Ø"&€O�ZÓ&Ø#€K�Ó#Ø!%€N�JÓ%Ø€GˆZÓØ $€M�:Ó$Ø#€K�Ó#Ø €N�C× r   ra  c                  ój  € ] tR tRt$ RtR]R&   RtR]R&   RtR]R&   RtR]R	&   Rt	R]R
&   Rt
R]R&   ]! R^ R7      tR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR]R&   RtR# ) ÚPerformanceSecurityUpdateiÇ  Nr1   rb  r¥   r(   r  r.   r
  r  r  rF   r%   rW  r  rc  rd  re  r2   r  r"  r#  r$  rf  r4  r&  rH   r'  rg  ri  r   rj  r   r   r   rl  rl  Ç  sñ   ‡ Ø€Eˆ:ÓØ&*Ð˜Ó*Ø"€J�Ó"Ø"&€O�ZÓ&Ø!%€M�;Ó%Ø €IˆzÓ Ù ¨°!Ô4€HˆjÓ4Ø"€K�Ó"Ø"€K�Ó"Ø $€M�:Ó$Ø"&€O�ZÓ&Ø!%€M�;Ó%Ø!€FˆNÓ!Ø!%€N�JÓ%Ø*.Ð˜KÓ.Ø#€K�Ó#Ø"&€O�ZÓ&Ø#€K�Ó#Ø!%€N�JÓ%Ø€GˆZÓØ $€M�:Ó$Ø#€K�Ó#Ø!%€N�J×%r   rl  c                  ó   € ] tR tRtRtR# )ÚPerformanceSecurityReadiá  r   Nr6   r   r   r   rn  rn  á  r7   r   rn  c                  óŠ   € ] tR tRt$ R]R&   RtR]R&   RtR]R&   ]! ^ R	7      tR]R
&   ]	P                  tR]R&   RtR]R&   RtR# )ÚDeliveryAcceptanceCreateiå  r   rb  Nr1   r¥   r(   Údelivery_date)rG   Úaccepted_quantityr	   Úacceptance_statusr.   rH   r   )r   r   r   r   r   r¥   rq  r   rr  r	   rŠ   rs  rH   r   r   r   r   rp  rp  å  sG   ‡ ØƒJØ&*Ð˜Ó*Ø!%€M�;Ó%Ù" aœ[Ð�sÓ(Ø+<×+FÑ+FÐÐ(ÓFØ€GˆZ×r   rp  c                  ó|   € ] tR tRt$ RtR]R&   RtR]R&   RtR]R&   ]! R^ R7      t	R]R	&   Rt
R
]R&   RtR]R&   RtR# )ÚDeliveryAcceptanceUpdateiî  Nr1   rb  r¥   r(   rq  rF   rr  r3   rs  r.   rH   r   )r   r   r   r   rb  r   r¥   rq  r   rr  rs  rH   r   r   r   r   ru  ru  î  sI   ‡ Ø€Eˆ:ÓØ&*Ð˜Ó*Ø!%€M�;Ó%Ù$)°$¸1Ô$=Ð�zÓ=Ø26ÐÐ/Ó6Ø€GˆZ×r   ru  c                  ó   € ] tR tRtRtR# )ÚDeliveryAcceptanceReadi÷  r   Nr6   r   r   r   rw  rw  ÷  r7   r   rw  c                  óz   € ] tR tRt$ R]R&   RtR]R&   R]R&   RtR	]R
&   R]R&   ]! R4      tR]R&   Rt	R]R&   Rt
R# )ÚPaymentTrackingCreateiû  r   rb  Nr1   r¥   r   Ú
invoice_nor(   Úinvoice_dater   Úinvoice_amountr&   Úpaid_amountrf   r°   r   )r   r   r   r   r   r¥   r{  r   r}  r°   r   r   r   r   ry  ry  û  s?   ‡ ØƒJØ&*Ð˜Ó*ØƒOØ $€L�+Ó$ØÓÙ" 6›?€K�Ó*Ø#€N�C×#r   ry  c                  óz   € ] tR tRt$ RtR]R&   RtR]R&   RtR]R&   RtR]R	&   Rt	R
]R&   Rt
R
]R&   RtR]R&   RtR# )ÚPaymentTrackingUpdatei  Nr1   rb  r¥   r.   rz  r(   r{  r2   r|  r}  r°   r   )r   r   r   r   rb  r   r¥   rz  r{  r|  r}  r°   r   r   r   r   r  r    sI   ‡ Ø€Eˆ:ÓØ&*Ð˜Ó*Ø!€J�
Ó!Ø $€L�+Ó$Ø%)€N�NÓ)Ø"&€K�Ó&Ø!%€N�J×%r   r  c                  ó   € ] tR tRtRtR# )ÚPaymentTrackingReadi  r   Nr6   r   r   r   r�  r�    r7   r   r�  N)JÚ
__future__r   r   r   Údecimalr   Úpydanticr   r   Úapp.models.enumsr	   Úapp.schemas.commonr
   r   r   r-   r5   r9   rM   rP   rR   rq   rŒ   rŽ   r�   r    r¢   r¤   r²   r´   r¶   rÅ   rÇ   rÉ   rÔ   rÖ   rØ   rá   rã   rå   rê   rì   rî   ró   rõ   r÷   rü   rþ   r  r  r  r+  r-  r/  r;  r=  r?  rE  rG  rI  rN  rP  rR  r]  r_  ra  rl  rn  rp  ru  rw  ry  r  r�  r   r   r   Ú<module>r‡     s*  ðÝ "ß #Ý ç +å .Ý 'ô�(ô ô8�8ô 8ô,�8ô ,ô	�˜{ô 	ô˜ô ô "˜ô "ô 	Ð)¨;ô 	ô�hô ô<.˜ô .ô8˜ô ô.	Ð'¨ô 	ô˜Hô ô$˜Hô ô$!Ð/°ô !ô
)˜xô )ô ˜xô ô 	Ð5°{ô 	ô)˜ô )ô&˜ô ô&	Ð'¨ô 	ô)˜Xô )ô ˜Xô ô 	Ð1°;ô 	ô
)˜xô 
)ô
˜xô 
ô	Ð5°{ô 	ô)˜8ô )ô˜8ô ô	Ð-¨{ô 	ô) ô )ô ô ô	Ð9¸;ô 	ô�ô ô�ô ô .�hô  .ôF,�hô ,ô<	�O [ô 	ô#�ô #ô2%�ô %ô2	ˆi˜ô 	ô.˜8ô .ô87˜8ô 7ô.	Ð-¨{ô 	ô ô ô ô ô	Ð7¸ô 	ô ô ô ô ô	Ð7¸ô 	ô;˜(ô ;ô(,˜(ô ,ô(	Ð+¨[ô 	ô! ô !ô4& ô &ô4	Ð7¸ô 	ô˜xô ô˜xô ô	Ð5°{ô 	ô$˜Hô $ô&˜Hô &ô	Ð/°ö 	r   