tjSUddlmZ ddlZddlmZejdZddddd d d d d ddddd Zded<GddZ dS)) annotationsN)Anyzdscons.takeoff.boq_breakdowng%Ag Ag> AgAg eAgș@g\mA@$A.@g AgjHAg\EAg0=A) CAT_VANG_BETONGCAT_VANG_XAY_TRATCAT_DEN_SAN_NENDA_1X2DA_4X6 XI_MANG_PCB40 THEP_CB400VAN_KHUON_PHU_PHIM NUOC_TRON_BTNHAN_CONG_BAC_35_7 CA_MAY_DAO_08CA_MAY_LU_RUNGCA_MAY_TRON_BTzdict[str, float]BENCHMARK_PRICEScjeZdZdZe ddd Ze dddZe dddZdS)BoqRateBreakdownEnginezlEngine responsible for decomposing BoQ items into VL+NC+M, comparing 3-column quantities, and generating MR.AF.11110 item_namestrcategoryunittotal_unit_pricefloat norm_codereturndict[str, Any]cddl}|dt|pd}|dt|pd|dt|pd}g}d} d} d} d|v} | rdnd} d vsd vsd vr"d }g}d} |dkr|d znd} |dkr|dznd} ndvr"d}g}d} |dkr|dznd} |dkr|dznd} nt fddDr"d}g}d} |dkr|dznd} |dkr|dznd} nndvr"d}g}d} |dkr|dznd } |dkr|d!znd"} nHd#vr"d$}g}d} |dkr|dznd%} |dkr|dznd&} n"d'vr2d(vsd)vr*d*}g}d} |dkr|d+zn| rd,nd-} |dkr|d.zn| rd/nd0} nd1vs d2vsd3vsd4vrd5}g}d} d} |dkr|nd6} nd7vs d8vr t fd9d:Dsd;}d<|vp d=|vp|d>k}|rdnd?}d@dAt d|zdBdCt dD|zdBdz=BoqRateBreakdownEngine.breakdown_item_rate..Qs;    O       )u đào móngu đào đấtu đào bùnu đào sanuxói hút bùnu nạo vétzAB.11210g?g?g@u bơm nướczTT.BOM01g?gOAg?gAu phát quangzAA.10000g3AgAunhổcừlarsenzAC.22112gffffff?g(2Ag@g?g\[AAg7@u thuê cừucừ thép thuêuthuê ván thépu thuê bãiz TT.RENT01g@@u cốt théputhépc3 K|]}|vV dSr)r*r+s r/r0z=BoqRateBreakdownEngine.breakdown_item_rate..s8$%Zr1)r2uvánubốcr'uthuêzAF.61110utấntantgMbP?zTBG-THEP-CB400u)Thép vằn CB400 (Hòa Phát/Việt Úc)@gffffff?r ) material_code material_name norm_quantity wastage_pcttotal_norm_qtyrunit_price_vnd subtotal_vndz TBG-DAY-BUOCu Dây thép buộc 1mm & Que hànr@g/@kggp@c3&K|] }|dV dSr?Nr*r,ms r/r0z=BoqRateBreakdownEngine.breakdown_item_rate..'??!N+??????r1g@Au ván khuônzAF.81110ugỗu phủ phimu tấm đanzTBG-VK-PHU-PHIMu>Ván ép phủ phim & Cây chống (Khấu hao luân chuyển)g?m2g@z TBG-DINH-VITu&Đinh, ốc vít & Ty ren bát chuồng?gzG?gL@c3&K|] }|dV dSrCr*rDs r/r0z=BoqRateBreakdownEngine.breakdown_item_rate..'CCAa/CCCCCCr1g@zTBG-VK-THEP-DINH-HINHu;Ván khuôn thép định hình (Khấu hao luân chuyển)g@g{Gz?zTBG-PHU-KIEN-VKu6Gông thép hộp, ty ren cravat & Dầu chống dínhg?g?ubộc3&K|] }|dV dSrCr*rDs r/r0z=BoqRateBreakdownEngine.breakdown_item_rate..rJr1g@gL@u bê tôngbtulótm100rz TBG-XM-PCB40u'Xi măng PCB40 Hoàng Thạch / Chinfongi@g?g`i@r zTBG-CAT-VANG-BTu&Cát vàng hạt lớn đổ bê tônggp= ף?guV?m3rz TBG-DA-4X6uĐá 4x6 / 2x4 lót móngg)\(?gw/?r z TBG-NUOC-BTu0Nước sạch trộn & bảo dưỡng bê tôngg@e@g33333e@ulítrc3&K|] }|dV dSrCr*rDs r/r0z=BoqRateBreakdownEngine.breakdown_item_rate..*rJr1gL@m200zAF.12110gq@g33333q@gQ?grh|?z TBG-DA-1X2u!Đá 1x2 mác cao đổ bê tônggףp= ?gaTR'?r gf@g,g@c3&K|] }|dV dSrCr*rDs r/r0z=BoqRateBreakdownEngine.breakdown_item_rate..`rJr1gL Ag@AzAF.12210gu@g4v@gGz?gͪ?gQ?gh|?5?g g@gg@c3&K|] }|dV dSrCr*rDs r/r0z=BoqRateBreakdownEngine.breakdown_item_rate..rJr1g,Aruđàouxúcu san nềnuđắpu đắp cátu cát đenzAB.13411zTBG-CAT-DEN-SANu.Cát đen san lấp nền đầm chặt K=0.90gffffff?gRQ?r c3&K|] }|dV dSrCr*rDs r/r0z=BoqRateBreakdownEngine.breakdown_item_rate..rJr1g@g333333?g^@u cọc treu cừ tràmzAC.11110gD@z TBG-COC-TREu9Cọc tre tươi L=2.0-2.5m d>=60-80mm (SXD Hải Phòng)ucọcc3&K|] }|dV dSrCr*rDs r/r0z=BoqRateBreakdownEngine.breakdown_item_rate..rFr1g|@uđónguéprungu thi côngucọc ván thépzAC.22111zTBG-THUE-CU-LARSENu4Hao phí thuê & luân chuyển cọc cừ Larsen IVgQ?gT㥛 ?rEzTBG-QUE-HAN-LARSENu2Que hàn & Oxy-Gas căn chỉnh đầu cừ Larseng)\(?c3&K|] }|dV dSrCr*rDs r/r0z=BoqRateBreakdownEngine.breakdown_item_rate.. rFr1g@gX@utrátulángzAK.11110zTBG-CAT-VANG-TRUNGuCát vàng xây trátg~jt?g( 0?g\Ag@uXi măng PCB40 xây trátg333333@g@c3&K|] }|dV dSrCr*rDs r/r0z=BoqRateBreakdownEngine.breakdown_item_rate..(rFr1gO@uxâyugạchzAE.11110z TBG-GACH-DACu"Gạch tuynel đặc 6.5x10.5x22cmg@ga@uviêng@g(AgQ?g|?5^?g@gl@gfffff.m@c3&K|] }|dV dSrCr*rDs r/r0z=BoqRateBreakdownEngine.breakdown_item_rate..PrFr1g1Aubăng cản nướczAK.51110zTBG-BANG-CAN-NUOC-V250u3Băng cản nước PVC V250 khớp nối thi côngg@gRQ?g@g*@c3&K|] }|dV dSrCr*rDs r/r0z=BoqRateBreakdownEngine.breakdown_item_rate..brFr1g@u vải địazAL.15110zTBG-VAI-DIA-KY-THUATu;Vải địa kỹ thuật không dệt ngăn bùn/đê quaig@c3&K|] }|dV dSrCr*rDs r/r0z=BoqRateBreakdownEngine.breakdown_item_rate..trFr1gz@ubạt xác rắnubạt chống sạtzAL.15120zTBG-BAT-XAC-RANu:Bạt xác rắn chống sạt lở bờ kênh & đê quaigp@c3&K|] }|dV dSrCr*rDs r/r0z=BoqRateBreakdownEngine.breakdown_item_rate..rFr1gp@uống bê tôngzAF.31110zTBG-ONG-BTCT-D300u;Ống bê tông cốt thép đúc sẵn D300 (Đoạn L=2m)u đoạn ốngg@Ac3&K|] }|dV dSrCr*rDs r/r0z=BoqRateBreakdownEngine.breakdown_item_rate..rFr1g@u cấu kiệnzAF.32110zTBG-TAM-DAN-DUC-SANu-Tấm đan bê tông đúc sẵn chịu lựcc3&K|] }|dV dSrCr*rDs r/r0z=BoqRateBreakdownEngine.breakdown_item_rate..rFr1gj@g?g?r?)material_cost_vndlabor_cost_vndequipment_cost_vndr>material_breakdownr) unicodedata normalizerloweranyroundrsum)rrrrrrb cat_lower unit_lower materialsvl_costnc_costm_cost is_100_unit scale_100is_tonmultis_woodstakes_per_unit ref_totalcomputed_totalscalerEr.s @r/breakdown_item_ratez*BoqRateBreakdownEngine.breakdown_item_rate%s; ))%X^1D1D1J1J1L1LMM  **5#io22F2F2L2L2N2NOO  **5#djb//2G2G2I2IJJ *, z) (1EEc Z ' '*,,z))"IIG1AA1E1E&--7G0@10D0D%,,&FF  + +"IIG1AA1E1E&--7G0@10D0D%,,'FF            b 0#IIG1AA1E1E&--7G0@10D0D%,,'FF z ) )"IIG1AA1E1E&--8G0@10D0D%,,(FF j ( ("IIG1AA1E1E&--9G0@10D0D%,,(FF  " "*(<(<J@V@V"IIG$a''!4''#.;iiG $a''!4''#.;iiG F J & &!Z//!Z//z))#IIGG)9A)=)=%%6FF j ( ( z ! !)] " #I *Vez.AVZSVEVF +33eD&6%P%*54<%;%;#&&+EDL!&<&<#&6|&D$) '7 'EEq%%  &4%G%*4$;%:%:#&&+EDL!&<&< &-$)%$,*@!$D$D  I0??Y?????GI,a00G7T>1--FF j ( ("I*$.:-.:-  3 7*;)i).ti/?)C)C'**/y0@!*D*D $*1(-dY.>.H!(L(L  *8)Q).ti/?)C)C'**/y0@!*D*D $*1(-dY.>.H!(L(L   ,CCCCCCC) 3Q77w2A66*A)f).ti/?)C)C'**/y0@!*D*D $*1(-dY.>.H!(L(L  *;)a).ti/?)C)C'**/ 0A1*E*E &*1(-ei.?'.I1(M(M   ,CCCCCCC9 4a88w2A66 J & &$**<*<##v';';& *8)R).'**/ $*:?*K(-!$4_$EEq))  *;)Q).'**/ $*:;L*M(-!$45F$GG))  *6)D).'**/ $*:8*D(-e6Fx6P.PRS(T(T  *7)[).'**/ &*:>*J(-!$4^$DDa))  G/ `CCCCCCC" :%%& *8)R).'**/ $*:?*K(-!$4_$EEq))  *;)Q).'**/ $*:;L*M(-!$45F$GG))  *6)L).'**0 $*:8*D(-f7G7Q.QST(U(U  *7)[).'**/ &*:>*J(-!$4^$DDa))  G/ `CCCCCCC"!' *8)R).'**0 $*:?*K(-"%5o%FF))  *;)Q).'**0 $*:;L*M(-"%56G%HH!))  *6)L).'**0 $*:8*D(-f7G7Q.QST(U(U  *7)[).'**0 &*:>*J(-"%5n%EEq))  G/ `CCCCCCC"! z ! !##:--j((:%%"I++*,,*,,& *;)Y)- )9'**/ i0G*K*K $*:;L*M(-#'(//@AB )) $CCCCCCC) 3Q77w2A66'  (!++%t++!I-(!++%t++!I-J & &,**D*D"I&1:ddsO&3%`%*?A%>%>#&&+Od,BA&F&F#&-$)/D*@7*JA$N$N   I??Y?????GFY.22G6I-q11FF  " " ""##j(( j H $:$:>PT^>^>^"I&:%[%*4)+;Q%?%?#&&+K),CQ&G&G&-$)+ *AG*KQ$O$O  &:%Y%*4)+;Q%?%?#&&+K),CQ&G&G &-$)+ *AG*KQ$O$O  I,??Y?????GGi/33G7Y.22FF  " "g&;&;"I&:%<%*#&&, &.$)*;Q$?$?  &4%@%)#&&* &6&G$)$1A/1R*RTU$V$V  I,??Y?????GGFF z ! !h*&<&<"I&4%I%*#&&+#&,$).!$<$<  &:%<%*#&&+ &.$)*:A$>$>  &4%@%*#&&, &6&G$)!1/!BBA%%  +!ID??Y?????GGFF "j 0 0"I&>%Z%)#&&*&-$+   I??Y?????GGFF z ) )"I&<%b%*4)+;Q%?%?#&&+D9,1--F H H$)!N*;e*CQ$G$G.!!")%"(%/&8"+"    r1Ndesign_quantity hsmt_quantity float | Noneactual_quantityct|pd}|t|nd}|t|nd}d}d}d}|Ot||z d}|dkrt||z dzd}n |dkrdnd}|dkrd }nN|d krd }nEd}nB|@t||z d}|dkrt||z dzd}|dkrd }n|d krd }||||||d S) u@So sánh 3 cột khối lượng và phân loại phát sinh VO.rNnormalrGrr&r@ vo_increaseg vo_decrease)rxryr{variance_quantityvariance_percentagevariation_status)rrf) rxryr{ design_qtyhsmt_qtyact_qtyvar_qtyvar_pctstatuss r/compute_triple_variancez.BoqRateBreakdownEngine.compute_triple_variancesH?1c22 +8+D5'''$,;,G%(((T  J1155G!||8!3u >%%s}}&4&!  Gj0!44GA~~:!5 >BB}}&4& *%&!(#* &    r1%Công trình Xây dựng Định Sơnitemslist[dict[str, Any]] project_titleci}d}|D]S}t|dpd}|d}|rt|ts||dd|dd|ddt|d pd|d d  }|dpg}|D]Y} | d p| d} t| dp| dpd} | |z} t| d pd} | | z}| |vrH| | d| dd| d| ddgd|| <|| dxx| z cc<|| dxx|z cc<||z }|d}|r1||| dvr!|| d|[Ug}|D]\} }||d |d|dt|dd|d t|dd|dt|dd |dddt|ddkrdndzd | dd d!|t|dt||d"S)#uV1-Click tổng hợp toàn bộ nhu cầu vật tư (MR Schedule) từ danh mục BoQ.rquantityrarr$rrrNr>rr)rrrrrr9r:r=r;r<r8)r9r:rrequired_quantityr>total_amount_vndr< used_in_tasksrrrrGrz, Nz...) r9r:rrr>rr< tasks_count tasks_summaryc|dS)Nrr*)xs r/zGBoqRateBreakdownEngine.aggregate_material_requisition..<s A&8$9r1T)keyreversesuccess)rrtotal_material_budget_vndmaterials_countmaterial_schedule) rget isinstancelistrwappendrrflenjoinsort)clsrr materials_aggtotal_material_budgetitmqty breakdownitem_rate_infomatcodenorm_qty tot_req_qty unit_price tot_amount task_namescheduledatas r/aggregate_material_requisitionz5BoqRateBreakdownEngine.aggregate_material_requisitions46 #( K( KC ++2s33C 455I KJy$$?$? K!$!8!8!ggk266 WWZ44..%*3773C+D+D+K%L%L!ggk:>> "9""+../CDDJ   K Kww//K377?3K3K GG,--P1I1IPS'n "377+;#<#<#CDD (:5 },,)-),)A)A #-0*4,/'*ww}c'B'B)+ + +M$'d#$7888KG888d#$6777:E777%3%GGK00 K-2Eo2V!V!V!$'8?? JJJ5 K:'--//  JD$ OO%)/%:%)/%: L).t4G/H!)L)L&*+;&<(-d3E.F(J(J#' #6#&tO'<#=#=%)YYtO/DRaR/H%I%I #D$9 : :Q > >uuB&H        994 HHH *)./Da)H)H"8}}!)    r1)rr) rrrrrrrrrrr r!)NN)rxrryrzr{rzr r!)r)rrrrr r!) __name__ __module__ __qualname____doc__ staticmethodrwr classmethodrr*r1r/rr"svv #&# _  _  _  _  \_  B'+(,, , , , \, \EM M M M [M M M r1r) __future__rloggingtypingr getLoggerloggerr__annotations__rr*r1r/rs"""""""  9 : : !""&&"b  b  b  b  b  b  b  b  b  b  r1