j3 SSKrSSKrSSKrSSKJr SSKJr SSKrSSK J r J r J r J r Jr SSKJrJr SSKJr SSS .rS rS rS r0r\"S 5r\R55R75HYrS\;dM \R;S5(aM#\R=S5urr r!\!RE5\\RE5'M[ \RGSS5\$"\RGSS55\RGS5\RGS5\RGS5S.r%SSK&r'\"S5r(Sr)\(R55R75H=r\R;S5(dM\R=S5SRE5r) O \'RT"S\)5r+\+(a\+RYS5OS\+(a-\+RYS5(a\$"\+RYS55OS\+(a\+RYS 5OS\+(a\+RYS5OS\+(a\+RYS!5OSS.r-0S"S#_S$S%_S&S'_S(S)_S*S+_S,S-_S.S/_S0S1_S2S3_S4S5_S6S7_S8S9_S:S;_SS?_S@SA_SBSC_r.\ "SSSSD9r/\"\0"\"\15RdSE- 5SF9r3SG\0SH\$SI\04SJjr4SG\0SI\04SKjr5SL\0SI\\04SMjr6SN\ SI\\04SOjr7SI\84SPjr9SI\:\84SQjr;\/RGSR\SS9S^SN\ ST\04SUjj5r<\/R{SR5\ "SV5\ "SV54SW\SN\ SG\0SX\04SYjj5r>\/RGSZ5S[5r?\/RGS\\SS9SN\ 4S]j5r@g)_N)Path)Optional)CookieFastAPIFormRequestResponse) HTMLResponseRedirectResponse)Jinja2Templatesz wetter2024! schau2024)adminviewerz+bitte-aendern-langer-zufaelliger-string-32ciQ admin_sessionz(/var/www/app.weidewetter.de/backend/.env=#DB_HOST localhostDB_PORTi DB_USER DB_PASSWORDDB_NAME)hostportuserpassworddatabasez*/var/www/serve.weidewetter.de/backend/.envz DATABASE_URL=z9mysql\+pymysql://([^:]+):([^@]+)@([^:/]+):?(\d+)?/([^?]+)z 127.0.0.1BB BrandenburgBEBerlinBWuBaden-WürttembergBYBayernHBBremenHEHessenHHHamburgMVzMecklenburg-VorpommernNI NiedersachsenNWzNordrhein-WestfalenRPzRheinland-PfalzSHzSchleswig-HolsteinSLSaarlandSNSachsenSTzSachsen-AnhaltTHu ThüringenDE Unbekannt)docs_url redoc_url openapi_url templates) directoryusernametsreturncUSU3R5n[R"[R5U[R 5R 5$N:)encodehmacnewSESSION_SECREThashlibsha256 hexdigest)rDrEmsgs )/var/www/admin.weidewetter.de/app/main.py_signrSOsD Jat  # # %C 88N))+S'.. A K K MMcd[[R"55nUSUS[X53$rH)inttimerS)rDrEs rR make_tokenrXTs/ TYY[ BZqAeH12 33rTtokencURSS5upn[U5n[R"U[ X55(dg[ R "5U- [ :agU$![a gf=f)NrIr)splitrVrKcompare_digestrSrWSESSION_MAX_AGE Exception)rYrDts_strsigrEs rR verify_tokenraYsm  % C 3# [""3h(;<< 99; o - sAA+ A+)A++ A87A8requestcfURR[5nU(dg[U5$)N)cookiesget COOKIE_NAMEra)rbrYs rRget_current_userrgfs' OO   ,E   rTc [RR"S0[D6nUR SS9nUR S5 UR 5nUR S5 UR 5nUR S5 UR5nUR S5 UR5nUR S5 UR5nUR S5 UR5nUR S 5 UR5nUH"n [RU S U S 5U S 'M$ UR S 5 UR5n UR5 UR5 UV s/sHn [U S 5PM n n UV s/sHn [U S5PM n n UV s/sHn [U S5PM nn UUUUUUUU U UU S. $s sn fs sn fs sn f)NT dictionaryaK SELECT COUNT(*) AS total_calls, COUNT(DISTINCT user_id_hash) AS unique_users, ROUND(AVG(latency_ms)) AS avg_latency, SUM(status_code >= 400) AS errors FROM request_logs WHERE DATE(timestamp) = CURDATE() a SELECT COUNT(*) AS total_calls, COUNT(DISTINCT user_id_hash) AS unique_users, ROUND(AVG(latency_ms)) AS avg_latency, SUM(status_code >= 400) AS errors FROM request_logs WHERE YEAR(timestamp) = YEAR(CURDATE()) AND MONTH(timestamp) = MONTH(CURDATE()) z SELECT DATE(timestamp) AS day, COUNT(*) AS calls, COUNT(DISTINCT user_id_hash) AS unique_users FROM request_logs WHERE timestamp >= NOW() - INTERVAL 14 DAY GROUP BY day ORDER BY day ASC z SELECT DATE(timestamp) AS day, feature, COUNT(*) AS calls FROM request_logs WHERE timestamp >= NOW() - INTERVAL 14 DAY GROUP BY day, feature ORDER BY day ASC a/ SELECT feature, COUNT(*) AS calls, ROUND(AVG(latency_ms)) AS avg_ms, MAX(latency_ms) AS max_ms FROM request_logs WHERE timestamp >= NOW() - INTERVAL 7 DAY GROUP BY feature ORDER BY calls DESC a SELECT DATE(timestamp) AS day, COUNT(*) AS total, SUM(status_code >= 400) AS errors, ROUND(100.0 * SUM(status_code >= 400) / COUNT(*), 1) AS error_pct FROM request_logs WHERE timestamp >= NOW() - INTERVAL 14 DAY GROUP BY day ORDER BY day DESC z SELECT region, COUNT(*) AS calls FROM request_logs WHERE timestamp >= NOW() - INTERVAL 30 DAY AND region != 'DE' GROUP BY region ORDER BY calls DESC regionnamea  SELECT timestamp, status_code, feature, region, latency_ms, app_version FROM request_logs WHERE status_code >= 400 ORDER BY timestamp DESC LIMIT 20 daycalls unique_users summary summary_month calls_by_daycalls_by_featurelatency errors_by_day by_region chart_labels chart_valueschart_users_values recent_errors) mysql connectorconnect DB_CONFIGcursorexecutefetchonefetchall REGION_NAMESreclosestrrV)connrrqrrrsrtrurvrwrowr{r day_labels day_valuesday_users_valuess rR get_statsros __ $ $ 1y 1D [[D[ )F NN ooG NN   OO%M NN ??$L NN ( NN   ooG NN   OO%M NN !I"&&s8}c(mDF  NN   OO%M LLNJJL/;<|!AeH |J<1=>AAgJJ>8DE 1An-. E!( - , 0 ' - ) * * 0 -   =>EsG,&G1G6c[RR"S0[D6nUR SS9nUR S5 UR 5nUR5 UR5 UHn[US5n[US5n[US5n[US5n[US5US'[US 5US 'XcS'XsS'US :a[S U-U- S 5OSUS 'US :a[S [US5-U- S5OSUS'US :a[S U-U- S5OSUS'M U$)NTria| SELECT a.uuid, a.advertiser_name, a.ad_text, a.start_date, a.end_date, a.impressions_target, a.impressions_count, a.clicks_count, a.is_house_ad, a.notes, COALESCE( SUM(CASE WHEN e.event_type = 'impression' AND e.occurred_at >= NOW() - INTERVAL 7 DAY THEN 1 ELSE 0 END), 0 ) AS impressions_7d, COALESCE( SUM(CASE WHEN e.event_type = 'click' AND e.occurred_at >= NOW() - INTERVAL 7 DAY THEN 1 ELSE 0 END), 0 ) AS clicks_7d, COALESCE( SUM(CASE WHEN e.event_type = 'impression' AND DATE(e.occurred_at) = CURDATE() THEN 1 ELSE 0 END), 0 ) AS impressions_today, COALESCE( SUM(CASE WHEN e.event_type = 'click' AND DATE(e.occurred_at) = CURDATE() THEN 1 ELSE 0 END), 0 ) AS clicks_today FROM ads a LEFT JOIN events e ON e.ad_uuid = a.uuid WHERE a.is_active = 1 AND a.start_date <= NOW() AND a.end_date >= NOW() GROUP BY a.uuid ORDER BY a.is_house_ad ASC, a.advertiser_name ASC impressions_countimpressions_targetimpressions_7d clicks_7dimpressions_today clicks_todayrgY@r" budget_pct clicks_countrg ctr_totalctr_7dr|) r}r~rSERVE_DB_CONFIGrrrrrVround)rradsadimptgtimp7clk7s rR get_ads_statsrsU __ $ $ 7 7D [[D[ )F NN'' P // C LLNJJL2)*+2*+,2&'(2k?#"%b)<&="> "%b&8"9>"& "&;:='5s!2A6t<NQTUg5R-?)@!@3!FJ[^;<@1H5!4a8#8  JrT/login)response_classerrorcn# [U5(a [SSS9$[RSXS.5$7f)N/. status_codez login.htmlrbr)rgr rBTemplateResponsers rR login_pager1s3  55  % %l4X YYs35.responserc# [RU5nU(aM[R"XC5(a2[ U5n[ SSS9nUR [U[SSS9 U$[ SSS9$7f)NrrrTlax)keyvaluemax_agehttponlysamesitez/login?error=1) USERSrerKr\rXr set_cookierfr])rrbrDrexpectedrYresps rRloginr8ssyy"HD'';;8$ #6 "&   ,# >>sA4A6z/logoutcL# [SSS9nUR[5 U$7f)Nrrr)r delete_cookierf)rs rRlogoutrNs$ H# 6D{# Ks"$rc 4# [U5nU(d [SSS9$SS/////////S. n[5nSn[ 5n[ RSUUUUS.UE5$![anUn[ U5nSnANDSnAff=f![a /nNOf=f7f)Nrrrrpzdashboard.html)rbrDdb_error active_ads)rgr rr^rrrBr)rbr_stats_defaultsstatsrers rR dashboardrUs G $D c::#"          O  "_   % %&6 9  9  "q6  sK+B A" BB" B, A>9B>BB BBBB)r)ArNrKrWpathlibrtypingrmysql.connectorr}fastapirrrrr fastapi.responsesr r fastapi.templatingr rrMr]rf_env _env_path read_text splitlinesline startswith partitionk_vstriprerVrre_re_serve_env_path _serve_urlmatch_mgrouprrappr__file__parentrBrSrXrargdictrlistrrpostrrrr|rTrRrs <<<.   @!   ; <    ! , , .D d{4??3//..%1a'')QWWY / K0DHHY-.#'#   CD   % % ' 2 2 4D ''^^C(+113   5  YY@* " {%'BHHQKKBHHQK d! t! t! t  -  $h   !%x  ( !%h  ) !%&>   /  !%&;     !%&:  * !%i   !%l  +  tt> c$x.*?*?+*M&N O NCNSNSN 444   g(3-|4|~>tDz>F,/ZgZcZ0Z (II ???? ??* \*$W$+$rT