o
,i=6
@ s d Z ddlZddlZddlmZmZmZmZm Z m
Z
m Z ddl m
Z
mZmZmZmZ ddlmZ ddlmZ ddlmZ dd lmZ z.ddlZddlZej ej ej ej e Z e ej vriej !de dd
l"m#Z# W n e$y Z% ze&d e% d d
Z#W Y dZ%[%ndZ%[%ww dd Z'dd Z(e)de'd ddZ*ej)ddgde'dd Z+ej)ddgde'd d Z,dS ) u
파일 관리 관련 라우트
N)requestrender_templatejsonifysessionflashredirecturl_for)get_db_connectionclean_dataframe_datasort_componentsnormalize_componentCOMPONENT_ORDER)natural_sort_key)pivot_detail_view)evaluate_slab_condition )file_management_bp)generate_repair_tablesu& generate_repair_tables import 실패: c C s dS )N)u% 보수 데이터 로딩 중...
u% 비용 데이터 로딩 중...
u% 평가 데이터 로딩 중...
)dffilenamer r P/home/skpark/git/infrasmart_work/infrasmart/blueprints/file_management/routes.pyr s r c s$ ddl m} | fdd}|S )u 로그인 필요 데코레이터r )wrapsc s" dt vr
ttdS | i |S )Nusernamez
auth.login)r r r )argskwargsfr r decorated_function s z*login_required..decorated_function) functoolsr )r r r r r r login_required s r c C s dd l }|jddks|jddkrMd| jv rG| d D ]%}| | d |k }td| dt| d t|jd
d d d td
q d S td d S d S )Nr DEBUGTrue FLASK_DEBUG1u 원본부재명z
[z] - u
개 데이터T )indexmax_cols max_colwidthz(----------------------------------------u1 [DEBUG] '원본부재명' 컬럼이 없습니다.)osenvirongetcolumnsuniqueprintlen to_string)r r) component component_dfr r r
console_logdf' s
r3 z/view_file/Fc % C st t }| }| td< z$z|d | du}|r'|d| td f n
|d| td f | }|sKtd ttdW W | | S d}|r`t |d kr`|d r]|d nd
}nd
}|d }t
|t rpt
|}t|}t| t|}t|d } ||d | }d
}
d} d
} d
}
d
}t| dd|d\}
} | }|d j jddd|d j jdddB }d|j|d f< |g dddg }|d d|d< |d dd |d < | d j d d d }| d 7 } | d 7 } | d!7 } | d"7 } | d#7 } | d$7 } | d%7 } | d&7 } | d'7 } | d(7 } | d)7 } | d*7 } | d+7 } | d"7 } | d#7 } | d$7 } | d%7 } | d&7 } | d'7 } | D ]?\}}| d,7 } | d-|d d.7 } | d/|d d.7 } | d-|d0 d.7 } | d-|d d.7 } | d-|d d.7 } | d17 } q>| d)7 } | d27 } t!|| \}
}}|d3| td f | }|r|d durt"|d nd4}|r|d durt"|d nd5}||d d6k }g }t#|d7 t$d8D ]}||d7 |k }d9|j%v r|d9 } nd } d:|j%v r$||d j jd;dd d: & } t'| rd} nzt"| } W n t(t)fy# d} Y nw d} ||d j jd;dd d } ||d j jddd d }"t*| t'| ss| d krudn| t'| s| d krdn| t'|!s|!d krdn|!t'|"s|"d krdn|"d?}#|+|t | d t'| s| nd@| d krt | dnd@| d krt | dnd@|!d krt |!dAnd@|"d krt |"dnd@|#dB qt,dCt-j./dDdE|
| | |
|||d| ||dF
W W | | S t0y0 }$ z tdGt |$ ttdW Y d}$~$W | | S d}$~$ww | | w )Hu
파일 보기current_filenamez
SELECT column_name
FROM information_schema.columns
WHERE table_name = 'uploaded_files' AND column_name = 'plan_type'
NzTSELECT file_data, plan_type FROM uploaded_files WHERE filename = %s AND user_id = %suser_idzISELECT file_data FROM uploaded_files WHERE filename = %s AND user_id = %su" 파일을 찾을 수 없습니다.z
main.indexr freer 부재명 aaaaaTF)pivotdetail user_plan 손상내용u 받침)nau 전단키u 교량받침)r7 r= 단위u 손상물량u 개소 c S s" t | tv r
tt | S ttS )N)r r
r& r/ )xr r r s " zview_file..u 부재명_순서)axiszbzbzU z| z | zr? z |
zz|
SELECT markup_rate, overhead_rate
FROM uploaded_files
WHERE filename = %s AND user_id = %s
g 4@g I@u 바닥판u 부재위치)key 점검면적u 폭u 균열u
백태|누수u$ 박락|파손|재료분리|층분리 철근부식) crack_width crack_ratio
leak_ratiosurface_damage_ratiorebar_corrosion_ratio- )u 구분rE u 균열폭u 균열율u 백태u 표면손상rF u 등급z
index_re.htmltabr; )
active_tab detail_htmldetail_html_header_link overall_html repair_html cost_html file_dataslab_eval_table
error_messager markup_rate
overhead_rateu9 파일을 불러오는 중 오류가 발생했습니다: )1r cursorr executefetchoner r r closer/
isinstancestrjsonloadspd DataFramer3 r
r r- isinr copycontainslocgroupbysum reset_indexroundapply sort_valuesdropiterrowsr floatsortedr r, maxisna
ValueError TypeErrorr appendr r r r+ Exception)%r r: conncur
has_plan_typeresultfile_plan_typerU r unique_componentsrP rQ rR rS rT
df_overallbearing_damage_maskoverall_row eval_html rates_resultrX rY slab_dfrV possubareacrack_width_rawrG rH rI rJ rebar_ratiogradeer r r view_file6 s,
)
$$
r z/delete_file/POST)methodsc C s t ddiS )u
파일 삭제successT)r )r r r r delete_file s r z/update_file_damage_detailsc C sV t } td }tdd}tdd}zz]t }| }|d||f | D ]+\}}|d||||d |d |d
|d |d |d
|d |d |d |d f
q)| t d |\}} }
t
d|| dW W | | S t y } z#t
d| | t
dt| ddfW Y d } ~ W | | S d } ~ ww | | w )Nr5 r unknownr4 unnamed_filezf
DELETE FROM file_damage_details
WHERE user_id = %s AND filename = %s
a}
INSERT INTO file_damage_details (
user_id, username, filename,unit,
component_name, damage_description,
repair_method, priority,damage_quantity,
repair_quantity, count, unit_price, estimated_cost
) VALUES (%s, %s, %s,%s, %s, %s, %s, %s, %s,%s, %s, %s, %s)
unitr1 damagemethodprioritydamage_quantityquantitycount unitPrice totalCostu 보수물량 저장 완료)messagerS rT u 업데이트 오류:u
오류 발생)r errori )r get_jsonr r+ r rZ r[ itemscommitr r r] rw r. rollbackr_ ) datar5 r r rx ry rD r; rS
cost_htmlxxxxr r r r r update_file_damage_details
sT
"
r )F)-__doc__r` pandasrb flaskr r r r r r r utils.commonr r
r r r
utils.damage_utilsr utils.pivot_detail_viewr utils.evaluationr r8 r sysr) pathdirnameabspath__file__ project_rootinsert utils.generate_repair_tablesr ImportErrorr r. r r3 router r r r r r r sB $ $
K