zKj ,ddlZddlZddlZddlZddlZddlmZmZmZm Z ee Z de jd<dZ e dzZe dzZhdZd Zd Zd Ze j)d d Ze j)ddgdZe j)ddZe j)ddZe j)ddgdZe j)ddgdZe j)ddZe dk(re j9ddd !yy)"N)Flaskrequestrender_templatejsonifyiMAX_CONTENT_LENGTHz/opt/struktur/case-intakez/data/cases.dbz/uploads>jpgmovmp4pngheicheifjpegcbtjt}tj|_|S)N)sqlite3connectDB_PATHRow row_factory)dbs /opt/struktur/case-intake/app.pyget_dbr s  !B[[BN Ic`d|vxr)|jdddjtvS)N.)rsplitlowerALLOWED)fns rallowedr s/ "9 ?3q)!,224??rc |sdgfSd} g} |dkDr| dz } | jd|r| r| dz } | jd|r|r| dz } | jd|r| dz } | jd|r| dz } | jd |rt|d kDr| dz } |d vr| jd t| d | fS)z-Content-Score 0-100. Freigabe=0 gibt Score 0.r bildmaterialvorher_nachher messwerte emotionale_storymallorca_bezug2)schimmelfeuchte kondensationlueftungedukativd)appendlenmin) falltyportbeschrmvmnwa foto_anzahlfreigabe has_vorher has_nachherscoretagss rcompute_content_scorer@s "u E DQ   N#k   $% b   K     &'    $% #f+"  EE J uc?D  r/ctdS)Nz index.html)rrrindexrD/s < ((rz/submitPOST)methodscttjddj}t t j }t j}|jdd}|jdd}|jddjdd}|jddjdd }|jd djdd }|jd djdd }|jd djdd } |jdd} |jddk(rdnd} |jddjdd} |jddjdd} |jddjdd}|jddjdd}t}|j}|jd||||||||| | | | | ||||fd}d}d}tjjt |}tj"|dt j$D]G}t j$j'|D]!}|s|j(st+|j(s*|j(j-dddj/}|dv}d|vrdnd |vrd nd!}|dk(rd}|d k(rd}|d"tjj0dd#d|}|j3tjj|||jd$ttj|||rd%nd&||f|s|dz }|jd'|f$Jt5|||||| || || \}}|d(k\rd)n|d*k\rd+nd,}|jd-||t7j8|||f|j;|j=t?d.|||||| |/S)0Nr4 unbekannt problemtypr5r0 beschreibungi,messwert_vorherr*messwert_nachherwhatsapp_quelle prioritaetp2r;jarr sensor_bezugvento_session_id baustelle_idergebnisia3INSERT INTO cases (case_id,erfasst_am,falltyp,problemtyp,ort,kurzbeschreibung,messwert_vorher,messwert_nachher,whatsapp_quelle,prioritaet,freigabe,sensor_bezug,vento_session_id,baustelle_id,ergebnis,content_status,radar_signal_ids,created_at,updated_at) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,"raw","[]",?,?)FT)exist_okr>r r vorhernachher allgemein_zdINSERT INTO case_media (media_id,case_id,filename,media_type,label,uploaded_at) VALUES (?,?,?,?,?,?)videofotoz2UPDATE cases SET video_vorhanden=1 WHERE case_id=?< verwertbar( ergaenzenrawzaUPDATE cases SET foto_anzahl=?, content_score=?, content_tags=?, content_status=? WHERE case_id=?z success.html)case_idr4rJr5fotosprior>) struuiduuid4upperinttimerformgetstriprcursorexecuteospathjoin UPLOAD_DIRmakedirsfilesgetlistfilenamer rrhexsaver@jsondumpscommitcloser)cidnowdr4rJr5r6r7r8r9rfr;sensorvento_id baustellerVrcurrer<r=cdirkeyfextisvlblrr>r?statuss rsubmitr3s djjl BQ  % % 'C diik C AeeI{+G|[1J %%r  "4C (C UU>2 & , , .t 4F  " % + + -cr 2B !2 & , , .s 3B  " % + + -ds 3B 55t $DEE*%-q1H UU>2 & , , .t 4Fuu',224Tc:Hnb)//1$37IuuZ$**,Tc2H B ))+CKK @ c7JVRRx 9hS : ; EJK 77<< C (DKKt$}}^&&s+ ^AQZZGAJJ$7jj''Q/288:^+"*c/hYRUEU [f(?J)#4[uAdjjl..r231SE:rww||D"-. +&RCVSRUVXQJEKK TWZV\]! ^^&(fb"b(-x[RKE4"b[\erk{uFKKk tzz$'57IIKHHJ >3&0c $E 33rz/casesct}|j}|jd|j}|j t d|S)NzSELECT case_id,falltyp,problemtyp,ort,prioritaet,freigabe,foto_anzahl,content_status,content_score,erfasst_am FROM cases ORDER BY erfasst_am DESC LIMIT 50z cases.html)cases)rrprqfetchallrr)rrrs r list_casesrusH B ))+CKK 78 LLNEHHJ = ?z WHERE z AND z# ORDER BY erfasst_am DESC LIMIT 200) rargsrnrkrrpr1rtrqrdictrr) status_filterrrrqueryparams conditionsrrowss r api_casesrsLL$$X.M   3 7I B ))+C !E FJ./ m$./ i  W\\*555 22EKKv \\^ ,DG ,D ,HHJ 4= -s/Dz/api/cases/GETct}|j}|jd|f|j}|s|j t ddidfSt |}|jd|f|jDcgc] }t |c}|d<|j t |Scc}w)N#SELECT * FROM cases WHERE case_id=?error not foundz(SELECT * FROM case_media WHERE case_id=?media)rrprqfetchonerrrr)rdrrrowresultms rapi_case_detailrs B ))+CKK5zB ,,.C   -.33 #YFKK:WJG(+ 71tAw7F7OHHJ 6?8sCz/api/cases//scorec t}|j}|jd|f|j}|s|j t ddidfSt |}|jd|f|jDcgc]}|d }}d|v}d|v}t|d |d |d |d |d |d|d|d|| \} } | dk\rdn| dk\rdnd} ttj} |jd| tj| | | |f|j|j t || | | dScc}w)u>Score neu berechnen — z.B. nach nachtraeglichem Foto-Upload.rrrrzBSELECT label FROM case_media WHERE case_id=? AND media_type='foto'labelrXrYr4r5kurzbeschreibungrMrNrOr:r;r_r`rarbrcz`UPDATE cases SET content_score=?, content_tags=?, content_status=?, updated_at=? WHERE case_id=?)rd content_score content_tagscontent_status)rrprqrrrrrr@rkrlr|r}r~) rdrrrrrlabelsr<r=r>r?rrs rapi_recalculate_scorersk B ))+CKK5zB ,,.C   -.33 S AKKTW^V`a"%,,. 1Qaj 1F 1V#Jv%K' ) ah"4 5 a 23Q7H5I -!J-[BKE4#b[\erk{uF diik CKKj  4 &#w79IIKHHJ wPThno pp2s Ez /api/statsct}|j}|jd|jd}|jd|jd}|jd|jd}|jd|jd}|jd|jd}|j t |||||dS)NzSELECT COUNT(*) FROM casesrzCSELECT COUNT(*) FROM cases WHERE content_score >= 60 AND freigabe=1zBSELECT COUNT(*) FROM cases WHERE content_score < 40 AND freigabe=1z=SELECT COUNT(*) FROM cases WHERE foto_anzahl=0 AND freigabe=1z0SELECT COUNT(*) FROM cases WHERE prioritaet='p1')totalr`rc ohne_bilder prioritaet_1)rrprqrrr)rrrr`rcrp1s r api_statsrs B ))+CKK,- LLN1 EKKUV"JKKTU ,,. CKKOP,,.#KKKBC  BHHJ  "  r__main__z 127.0.0.1i!F)hostportdebug)rrrhrlrr|flaskrrrr__name__appconfigBASErrurrr r@routerDrrrrrrrunrCrrrs]$$$:: Ho#3  " ! ! J  8 @!83))9vh'?3(?3B8 6 6<, !E73 4  '&:q;q6<, zGG4uG5r