o |h8@sdZddlmZmZmZddlZddlZddlZddl m Z ddl m Z m Z ddl mZmZddl mZmZdd lmZd d Zd d Ze jddgdddZddZddZdS)uU 상태평가표 데이터 생성 API (개선된 condition_evaluation 모듈 사용) )requestjsonifysessionN)api_bp)get_db_connectionclean_dataframe_data)get_meta_keywords_by_meta_idget_meta)convert_component_name_to_key!get_source_by_meta_id_and_keyword)#generate_condition_evaluation_pivotc Csg}|di}|D]5\}}|di}|D]&\}}|||d|d|d|d|d|dd }||qq |sJtd dSt|} t| jd d | jd d } td ddd } | | Wdn1stwYtddS)N 교량받침 positionscrack_width_1dcrack_width_2dcrack_ratio_1dcrack_ratio_2ddamage_quantitiescondition_grade)sub_namepositionrrrrrru1교량받침 positions 데이터가 없습니다.Findexbearing_positions_table.mdwutf-8encoding;bearing_positions_table.md 파일로 저장되었습니다. getitemsappendprintpd DataFrame to_string to_markdownopenwrite) component_datarows bearing_grouprsub_datarpos_namepos_datarowdfmd_tablefr5B/home/skpark/git/infrasmart_work/infrasmart/api/evaluation_data.pyprint_bearing_positions_tables4        r7c Cs|di}g}|D]%\}}||d|d|d|d|d|dd}||q |s:td dSt|}t|jd d |jd d }td d dd }| |Wdn1sdwYtddS)Nrrrrrrr)rrrrrrru$positions 데이터가 없습니다.Frrrrrrr ) r+rr,r/r0r1r2r3r4r5r5r6print_bearing_table7s,      r8z/generate_evaluation_dataPOST)methodsc CsDzqdtvrtddidfWSt}|d}|d}|s'tddidfWSt}|}|d |tdf|}|sGtdd id fWS|d }t |t rUt |}t |}t|}t|}||td |dWSty} z$tdt | d dl} | tddt | idfWYd} ~ Sd} ~ ww)u 부재별 집계표 데이터를 기반으로 상태평가표 데이터를 생성합니다. 개선된 condition_evaluation 모듈을 사용하여 1방향/2방향 균열 분류를 적용합니다. user_iderroru로그인이 필요합니다.ifilenamecomponent_typeu파일명이 필요합니다.izISELECT file_data FROM uploaded_files WHERE filename = %s AND user_id = %su"파일을 찾을 수 없습니다.irT)successdatau*상태평가 데이터 생성 중 오류: Nu@상태평가 데이터 생성 중 오류가 발생했습니다: i)rrrget_jsonr!rcursorexecutefetchone isinstancestrjsonloadsr%r&rconvert_to_api_formatclose Exceptionr$ traceback print_exc) r@r=r>conncurresult file_datar2evaluation_dataerLr5r5r6generate_evaluation_dataWsH       &rTcCs(|dkrdS|dkr dS|dkrdSdS)u.손상물량에 따른 상태 텍스트 반환r-u소요 u중요u심각r5)quantityr5r5r6get_damage_condition_textsrYcKstdtd}gggggggggggd }i}|D]9}ztd|dt||}|||<WqtyS}ztd|d|dd l}|WYd }~qd }~wwt||D ].} ztd |d||i}|d krytd |d|D ]\}td t } | rbtd| |dD ]\} } td| | di} | dd} | dd}| | dd| dd| d| dd| dd | || d }| dkrdvpt dd| dgD}|rStd | d!g}g}g}g}d}d"}| dgD]}|d#d$ |d%d$}|d&d}td'd(|d)||dkrt fd*dd+DrR||7}td,|qd-|vsad-vsad.vrs| |d#d$td/qt fd0dd1Dr| |d#d$td2qt fd3dd4Drt fd5dd6Ds| |d#d$td7qt fd8dd9Dr| |d#d$td:q||7}td;|q|dkr||d"nd}|||rd<tt|nd=|rd<tt|nd=|rd<tt|nd=|r)d<tt|nd=||||||d> td?t|d@t|dAt|dBt|dC|dDdE  n| dFd}| dGd}| dHd}d"}|||dkru||d"nd|dkr||d"nd|dkr||d"nd|||dIn| dJkrtdK| d!g}g}g}g}d}d"}| dgD]}|d#d$ |d%d$}|d&d}td'd(|d)||dkrt fdLdd+Dr||7}td,|qd-|vsd-vsd.vr| |d#d$td/qt fdMdd1Dr6| |d#d$td2qt fdNdd4Dr`t fdOdd6Ds`| |d#d$td7qt fdPdd9Dr~| |d#d$td:q||7}td;|q|dkr||d"nd}|||rd<tt|nd=|rd<tt|nd=|rd<tt|nd=|rd<tt|nd=||||||d> tdQt|d@t|dAt|dBt|dC|dDdE n[| dRkrYtdS| d!g}g}g}g}d}d"}| dgD]}|d#d$ |d%d$}|d&d}td'd(|d)||dkrt fdTdd+DrX||7}td,|qd-|vsgd-vsgd.vry| |d#d$td/qt fdUdd1Dr| |d#d$td2qt fdVdd4Drt fdWdd6Ds| |d#d$td7qt fdXdd9Dr| |d#d$td:q||7}td;|q|dkr||d"nd}|||rd<tt|nd=|rd<tt|nd=|r"d<tt|nd=|r/d<tt|nd=||||||d> tdYt|d@t|dAt|dBt|dC|dDdE n| dZvr| dGd}| dFd}| dHd}||}d"}||t| dd| ddd=||d"||d"|||d[n| d\krg}d} g}!td]| d!| dgD]}|d#d$|d%d$}|d&d}td^d(|d)|td_}"t fd`d|"Dr|vr| tdaqd-| vsd- vrht fdbddcDr<| ddpd}#| ddp!d}$t|#|$}%t| |%} tdd|%de|#df|$dgq| ddpDd}#| ddpMd}$t|#|$}%t| |%} tdh|%de|#df|$dgqt fdiddcDsy|djvr|!vr|!vr|! tdkq|!vr|! q|rd<|}&nd=}&|!rd<|!}'nd=}'tdl|&dm| dn|'||&| dkr| nd|'don| dpkr*| dqd| dHd}(g})| dD]}|d%djvr|d#d$}*|*r|*|)vr|) |*q|)rd<|)nd=}+|t| dd| dd|+d=d=|(|)drn)| dskrtdt| d!tdu| | dGd}| dHd}t|ttfsTd}t|ttfs^d}d},||},tdv|dw|dx|,d"}-||-|dkr||-d"nd|dkr||-d"nd|,dkr|,|-d"nd||dytdz|d{|n| d|k r|td}| d!tdu| g}.d}/g}0| dstd~| dne| dgD]]}|d#d$ |d%d$}|d&d}1td'd(|d)|1t fdddDsdvsdvrK|1dkrKdvs%dvr8|0vr6|0 tdq܈|.vrI|. tdqdvr|1dkrd-vs_d-|vr| ddpgd}#| ddppd}$t|#|$}%t|/|%}/td|%de|#df|$dgq|0 qdvsdvr|1dkrd-vsd-|vr| ddpd}#| ddpd}$t|#|$}%t|/|%}/tdd|%de|#df|$dgq|0 dqd-|v r|1dk r| ddpd}#| ddpd}$t|#|$}%t|/|%}/tdh|%de|#df|$dgqdv r9d-v r9d-|v r9|1dk r9t fdddD s9|0 q|. rHd<tt|.}&nd=}&|/dk rQ|/nd=}2|0 r_d<tt|0nd=}3td|&dm|2dn|3||&|2|3|.|0|0dn| dk r7| dGd}4| dd}5| dd}6|5}7|6}8|4|7|8},d}9g}:|D]g\}}d|v r |D]X\}dv sdv r |dD]B\};} |;| k r| dgD]1}|d#d$|d&d}|dk rt fdddD r|:v r|: td qՐ qƐ q q|: rd<|:}9nd}9d"}|||,dk r(|,|d"ndd|9|4|5|6|7|8|:d n| dk rSg}| dgD]}|d#d$dv r^dv r^d}>n qHtd| d!| dgD]}|d#d$|d&d}td'd)||dk r|> rt fdddD rd}?|?|=v r|= |?td|? qnt fdddD rΈ|d||  |td|qq}WqZt y}ztd|d|dd l}|WYd }~qZd }~wwtdd}D|D]}E||E sR|Ed|k rRtd|E|DD]}F|Fddd ddd}G|Edk r|Gd"ddddn|EdJk r|Gd"d=d=d=d=ddnt|EdRk r|Gd"d=d=d=d=ddnb|EdZv r|Gd"dd=dddnQ|Edpk r|Gdd=d=d=dnA|Ed\k r|Gd=dd=don2|Edk r'|Gd"ddddn"|Edk r9|Gd=d=d=ggddn|Edsk rI|Gd"ddddd||E |G q qtd|S)uJ개선된 condition_evaluation 모듈의 결과를 API 형식으로 변환uAPI 변환 시작...iAB) slabgirder crossbeamabutmentpier foundationbearingexpansionJointpavementdrainagerailingzPre-processing z...z Component z pre-processing error: rNz Processing rz!Processing bearing positions for z Component: z API Key: rz Position: rcrack_length_1dcrack_length_2drrrrra) span_idrrrrgradeoriginal_crack_length_1doriginal_crack_length_2doriginal_damage_quantitiesrZ강css |] }d|ddvVqdS)rm original_descN)r!).0damager5r5r6 sz(convert_to_api_format..damagesz* Processing steel slab damages for :drnrotyperXz Damage: z, Type: z , Quantity: c3|]}|vVqdSNr5rpkeywordrnr5r6rr)도장부식녹rust corrosionz/ -> Added to surface_deterioration: u균열crackz) -> Added to component_crack: c3rwrxr5ryr{r5r6rr r|)u변형u파단u굴곡u좌굴u처짐 deformationz. -> Added to deformation_fracture: c3rwrxr5ryr{r5r6rrr|)볼트u너트u앵커boltnutanchorc3rwrxr5rp corr_keywordr{r5r6rrr|)r~rr}z( -> Added to bolt_loosening: c3rwrxr5ryr{r5r6rrr|)u용접u결함weldz% -> Added to weld_defect: z7 -> Added to surface_deterioration (other): z, rU) inspection_areacomponent_crackdeformation_fracturebolt_loosening weld_defectsurface_deterioration_ratio#original_surface_deterioration_areacomponent_crack_damagesdeformation_fracture_damagesbolt_loosening_damagesweld_defect_damagesz# Steel slab result - Crack: z, Deformation: z, Bolt: z, Weld: z , Surface: z.2f%u누수u 표면손상 철근부식)r leak_ratiosurface_damage_ratiorebar_corrosion_ratiooriginal_leak_quantity original_surface_damage_quantity!original_rebar_corrosion_quantityr[z, Processing steel girder damages for c3rwrxr5ryr{r5r6rrar|c3rwrxr5ryr{r5r6rrkr|c3rwrxr5ryr{r5r6rrpr|c3rwrxr5rr{r5r6rrpr|c3rwrxr5ryr{r5r6rrur|z% Steel girder result - Crack: r\z/ Processing steel crossbeam damages for c3rwrxr5ryr{r5r6rrr|c3rwrxr5ryr{r5r6rrr|c3rwrxr5ryr{r5r6rrr|c3rwrxr5rr{r5r6rrr|c3rwrxr5ryr{r5r6rrr|z( Steel crossbeam result - Crack: )r]r^)r crack_widthrrrrrrr`z' Processing bearing damages for zDamage: iFBc3|] }|vVqdSrxlowerryr{r5r6rr z( -> Added to body_condition: c3rrxrryr{r5r6rrr) 콘크리트몰탈u받침콘크리트u 받침몰탈z% -> Concrete crack width: z (1d: z, 2d: )z$ -> General crack width: c3rrxrryr{r5r6rr"r) 단면손상rz( -> Added to section_damage: z Bearing result - Body: z, Crack width: z, Section damage: )body_conditionrsection_damager_r)rdamage_conditionerosion settlement"original_damage_condition_quantitydamage_condition_descriptionsrdz' Processing railing damages for z Position data: u표면손상: u, 철근부식: u, 총 손상량: )lengthrrtotal_damage_quantityrrz) Railing result - Surface damage: z, Rebar corrosion: raz/ Processing expansion joint damages for z& No damage data for position z, leaving emptyc3rwrxr5ryr{r5r6rrr|)u유간 이물질u본체r~u 고무재u 이음부ru 신축이음u 이음장치u 차수판u차수z< -> Added to footer_section_damages (waterstop): z& -> Added to body_damages: u 후타재z# -> Footer crack width: rru후타재 단면손상c3rwrxr5ryr{r5r6rrr|z' Expansion joint result - Body: )r footer_crackr body_damagesfooter_crack_damagesfooter_section_damagesrbu양호u배수u 배수구c3rwrxr5ryr{r5r6rrr|)막힘퇴적r적치zC -> Added to pavement drainage from drainage component: ) r damage_ratiotraffic_conditiondrainage_conditionoriginal_damage_ratio_quantity original_crack_ratio_quantity_1d original_crack_ratio_quantity_2dadjusted_crack_ratio_1dadjusted_crack_ratio_2ddrainage_damagesrcFrTz( Processing drainage damages for c3rwrxr5ryr{r5r6rr8r|)u 토사퇴적rrru 배수불량z1 -> Added to pipe_damages (modified): c3rwrxr5ryr{r5r6rr=r|)u 배출구u출구u 토출구z( -> Added to outlet_damages: c3rwrxr5ryr{r5r6rrAr|)u관로u 파이프u관z& -> Added to pipe_damages: z- -> Added to pipe_damages (leak): z. -> Added to pipe_damages (other): z" Drainage result - Outlet: z, Pipe: z, All: )outlet_conditionpipe_conditionroutlet_damages pipe_damagesis_blocked_spanz Added span data: z processing error: i u 기본부재zSetting default data for )rhrrrrri)rrrr)rrrrrr)rrrrr)rrrr)rrrr)rrrrruAPI 변환 완료)r$r r rKrLrMr7r!r"r upperranyr#updatejoinlistsetlenmaxr rEintfloatr keysmapping)Kr2component_filtersapi_dataall_evaluation_results filter_nameevaluation_resultrSrLr+api_keyrr0rrerf span_data is_steel_slabrrrrsurface_deterioration_arearrq damage_typedamage_quantityr leak_quantitysurface_damage_quantityrebar_corrosion_quantitytotal_surface_damagebody_condition_damagesconcrete_crack_widthconcrete_section_damagescorrosion_keywordsrrrrconcrete_damage_textdamage_condition_quantityrdescdamage_condition_textrrrfooter_crack_widthrrXr footer_damagedamage_ratio_quantitycrack_ratio_quantity_1dcrack_ratio_quantity_2drrrrposrrr modified_descrr all_damagesr default_spans component_keyspan base_datakeyvaluerailing_keywordsr5)component_namernr6rIs            "   0>       0>    0>                  "                                             "                    %             rI)__doc__flaskrrrpandasr%rGreror utils.commonrrr r r r utils.condition_evaluationr r7r8routerTrYrIr5r5r5r6s     8