o
,iL @ sZ d Z ddlZddlZddlmZmZmZmZm Z m
Z
m Z m Z ddl
mZ ddlmZ ddlmZmZ ddlmZmZmZ ddlmZ dd lmZ d
d l m Z e d e j d
ddgdedd Z e dedd Z e ddd Z!e ddd Z"e d d d Z#e d d d! Z$e d"ed#d$ Z%e j d%ddgded&d' Z&dS )(u
메인 페이지 라우트
N)requestrender_templateredirecturl_forsessionflashsend_from_directoryjsonify)secure_filename)clean_excel_header_newlines)get_db_connectionclean_dataframe_data)validate_excel_fileexcel_to_clean_dfperform_detailed_validation)login_required)check_and_use_upload_count )main_bp/z/indexGETPOST)methodsc 1 s dt vrtd ttdS tjdkrdtjv rtjd } | jdkr/tdd ttjS | r| j d rt
dpBt
d
}d d l m }m
} d d
lm}m} ||}||}|s}|s}||}||} d}
td| d| d|
dd ttjS zt| } t| | } t| drd| j}
td|
d ttjW S | \}}t|}t|}|
drt|d }g }
|d d d D ]}|d }d|d }|
d| d | q|dkr|
d |d d td | d d|
d ttjW S |
d!g }|std"d ttjW S t }| }d d l }d d l fd#d$ |}|j |d%d&}tj
d'd}tj
d(d}tj
d)d} tj
d*d} tj
d+d} tj
d,d} z | ret | nd } | rnt!| nd } | rwt!| nd } W n t"t#fy d } d } d } Y nw d-t$|v r|%d.|f n|%d/|f |& } | r| d r| d nd0}!|%d1 |& d u}"|"r|%d2t d t$t'( | j|||| | | | |!f n|%d3t d t$t'( | j|||| | | | f
d-t$|v r|%d4|f n|%d5|f |& }#|#ro|#d d ur|#d nd }$|#d6 d ur(|#d6 nd }%|$d kr6t)d |$d6 n|$}&|%d krDt)d |%d6 n|%}'d-t$|v rW|%d7|&|'|f n |%d8|&|'|f d9|& d:|' d;}(t|(d< ntd=d> |* |+ |+ ttd?W S t,y }) zId@t- v rz|. W n Y zdAt- v r|+ |+ W n Y d d l/}*|*j0dB|) dCdD tdEt$|) d ttjW Y d })~)S d })~)ww tdFd ttjS t }| }t
d}|%d/|f |& }+|+r
|+d r
|+d nd0},|%dG dHdI |1 D }-dJ|-v }"|"sNz|%dK |* |-dJ dC}"W n t,yM }) z
t2dL|) W Y d })~)nd })~)ww |%dMd|- dN|f g }.|1 D ]}/t3t4|-|/}0|0
dJsud0|0dJ< |.|0 qb|+ |+ t5dO|.dPS )QNuser_idu 로그인이 필요합니다.z
auth.loginr file u' 파일이 선택되지 않았습니다.errorz.xlsxemailr )can_upload_fileget_upload_count)can_use_pro_trialget_pro_trial_countz+https://infrasmart.co.kr/order.php?plan=proun 파일 업로드 횟수와 Pro 무료체험 횟수가 모두 소진되었습니다. (남은 업로드 횟수: u 회, 남은 Pro 횟수: u) 회)
추가 사용을 위해 Pro 플랜을 구독해주세요.is_validz
u 파일 검증 실패:
error_rows
row_indexz, errorsu 행 z: u ... 외 u
개 오류u 파일 검증 실패 (총 u 개 오류):
cleaned_datau$ 유효한 데이터가 없습니다.c sf t | tr| s| rdS | S t | tr# fdd| D S t | tr1 fdd| D S | S )u$ NaN과 Infinity를 None으로 변환Nc s i | ] \}}| |qS r( ).0kvconvert_nan_to_noner( E/home/skpark/git/infrasmart_work/infrasmart/blueprints/main/routes.py
y s z6index..convert_nan_to_none..c s g | ]} |qS r( r( )r) itemr, r( r.
{ z6index..convert_nan_to_none..)
isinstancefloatisnanisinfdictitemslist)objr- mathr( r. r- s s
z"index..convert_nan_to_noneF) ensure_ascii bridge_namestructure_type
span_countlengthwidthexpansion_joint_location@z'SELECT plan FROM users WHERE email = %sz$SELECT plan FROM users WHERE id = %sfreez
SELECT column_name
FROM information_schema.columns
WHERE table_name = 'uploaded_files' AND column_name = 'plan_type'
a
INSERT INTO uploaded_files
(user_id, filename, original_filename, file_data, bridge_name,
structure_type, span_count, length, width, expansion_joint_location, plan_type)
VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)
ON CONFLICT (user_id, filename)
DO UPDATE SET file_data = EXCLUDED.file_data, bridge_name = EXCLUDED.bridge_name,
structure_type = EXCLUDED.structure_type, span_count = EXCLUDED.span_count,
length = EXCLUDED.length, width = EXCLUDED.width,
expansion_joint_location = EXCLUDED.expansion_joint_location,
plan_type = EXCLUDED.plan_type
a=
INSERT INTO uploaded_files
(user_id, filename, original_filename, file_data, bridge_name,
structure_type, span_count, length, width, expansion_joint_location)
VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s)
ON CONFLICT (user_id, filename)
DO UPDATE SET file_data = EXCLUDED.file_data, bridge_name = EXCLUDED.bridge_name,
structure_type = EXCLUDED.structure_type, span_count = EXCLUDED.span_count,
length = EXCLUDED.length, width = EXCLUDED.width,
expansion_joint_location = EXCLUDED.expansion_joint_location
z@SELECT upload_count, pro_trial_count FROM users WHERE email = %sz=SELECT upload_count, pro_trial_count FROM users WHERE id = %sr zIUPDATE users SET upload_count = %s, pro_trial_count = %s WHERE email = %szFUPDATE users SET upload_count = %s, pro_trial_count = %s WHERE id = %suN 파일이 성공적으로 업로드되었습니다. (남은 업로드 횟수: u% 회, 남은 Pro 무료체험 횟수: u 회)successuL 파일이 업로드되었지만 사용자 정보를 찾을 수 없습니다.warningz
main.indexconncuru 파일 처리 오류: T)exc_infou0 파일 처리 중 오류가 발생했습니다: u7 올바른 Excel 파일(.xlsx)을 업로드해주세요.zt
SELECT column_name
FROM information_schema.columns
WHERE table_name = 'uploaded_files'
c S s g | ]}|d qS )r r( )r) rowr( r( r. r1 ( r2 zindex.. plan_typez
ALTER TABLE uploaded_files
ADD COLUMN IF NOT EXISTS plan_type VARCHAR(10) DEFAULT NULL
u plan_type 컬럼 추가 실패: z
SELECT z^
FROM uploaded_files
WHERE user_id = %s
ORDER BY upload_date DESC
z
files.html)files)6r r r r r methodrM filenameurlendswithgetutils.upload_countr r utils.pro_trialr r! r r hasattrjoinr& r
r lenappendr cursorjsonr< dumpsformintr4
ValueError TypeErrorstrexecutefetchoneuuiduuid4maxcommitclose Exceptionlocalsrollbackloggingr fetchallprintr7 zipr )1r r r r r r! has_upload_count
has_pro_trialupload_remaining
pro_remaining purchase_url cleaned_file df_resulterror_messagesdf
header_rowvalidation_result error_count error_rowrow_numr& r' rH rI rZ file_datar> r? r@ rA rB rC plan_result user_plan
has_plan_type count_result upload_countpro_trial_countnew_upload_countnew_pro_trial_countmessageerk user_plan_result current_plancolumnsrM rK file_dictr( r; r. index sz
r z /index_rec C s ddl m} t }| }|dtd f | }g }|D ]'}||d |d |d |d dur5|d nd|d dur@|d ndd
q d d gd
ddd gd
dddddgidg diddgid}| ||}| t d|dS )u 새로운 인덱스 페이지r )process_slab_damage_datau
SELECT 부재명, 손상내용, 단위, SUM(손상물량) as 총손상물량, SUM(개소) as 총개소
FROM file_damage_details
WHERE user_id = %s
GROUP BY 부재명, 손상내용, 단위
ORDER BY 부재명, 손상내용
r r N )u 부재명u 손상내용u 단위u 손상물량u 개소u 균열부백태 균열g ?)keywords
length_factoru 망상균열)u 1방향u 2방향r 누수u 백태)u 박리u 박락u 파손u 철근노출)r r u 표면손상u 철근부식z
index_re.html) slab_data)
utils.slab_processingr r rY ra r rl rX rg r )r rH rY component_dataprocessed_datarK custom_damage_mappingr r( r( r. index_reQ sB
r z /favicon.icoc C
t ddS )Nstaticz favicon.icor r( r( r( r. favicon
r z
/style.cssc C r )Nz
static/cssz style.cssr r( r( r( r. style r r z/js/c C s
t d| S )Nz static/jsr rO r( r( r. serve_js r r z/download/c C s t d| ddS )u 파일 다운로드dataT)
as_attachmentr r r( r( r.
download_file s r z/pricingc C s t dS )u 가격 정책 페이지z pricing.html)r r( r( r( r. pricing s r z /files/delete_file/c C sF t }| }|dtd | f | | | tddiS )u 파일 삭제 및 JSON 응답z?DELETE FROM uploaded_files WHERE user_id = %s AND filename = %sr rF T)r rY ra r rf rg r )rO rH rI r( r( r. delete_file s
r )'__doc__pandaspdrc flaskr r r r r r r r werkzeug.utilsr
api.filer utils.commonr r
utils.file_validationr r r utils.decoratorsr rS r r r router r r r r r r r r( r( r( r. sD ( @ ;