Commit Graph

48 Commits

Author SHA1 Message Date
b834cc4218 docs: add historical backfill operation and verification guide 2026-06-16 09:55:17 +09:00
7422cd4869 fix: ensure backfill_state table is created inside backward_backfill.py initialization 2026-06-16 09:52:44 +09:00
428d4e0d09 feat: implement backward historical backfill scheduler with SQLite state tracking 2026-06-16 09:51:39 +09:00
a405748042 feat: implement hybrid daily stats calibration using fetch_history_daily 2026-06-15 16:07:32 +09:00
5c504f7747 fix: resolve out-of-range date error (31 days) in monthly stats calculation 2026-06-15 13:53:33 +09:00
72a85b0ff6 chore: setup supabase cli and pull baseline migration 2026-06-15 13:49:24 +09:00
1724a80426 chore: merge subprojects into monorepo layout 2026-06-15 12:54:11 +09:00
072d038410 Add 'app/' from commit '0e0b64f20f3d3dfd31a99eb8adf7d65c82536251'
git-subtree-dir: app
git-subtree-mainline: e9a4f8e401
git-subtree-split: 0e0b64f20f
2026-06-15 12:53:40 +09:00
e9a4f8e401 Add 'crawler/' from commit 'c9ed91d885f3c46efb98e98310a1882bb5936546'
git-subtree-dir: crawler
git-subtree-mainline: 8991b92ac8
git-subtree-split: c9ed91d885
2026-06-15 12:53:36 +09:00
8991b92ac8 Add 'api_server/' from commit 'cd684eae2200b96f62db0f0244ce54a13485ec6e'
git-subtree-dir: api_server
git-subtree-mainline: 5c3b20522b
git-subtree-split: cd684eae22
2026-06-15 12:53:33 +09:00
5c3b20522b initial commit: add .gitignore 2026-06-15 12:53:21 +09:00
c9ed91d885 fix: daily stats calculation logic and daily close task 2026-06-15 12:52:42 +09:00
c885bab007 fix: 크롤링 오류 시 daily_stats 0으로 덮어쓰기 방지
- save_to_supabase()에서 status에 '오류' 포함 시 daily_stats 갱신 금지
- today_kwh == 0인 경우도 daily_stats 갱신 금지 (새벽/야간 보호)
- solar_logs는 이상 이력 추적을 위해 오류 데이터도 계속 기록
- 재현 사례: 2026-05-14 15:40 nrems-03 NREMS 응답 오류로 0kW 오보
2026-05-14 17:56:08 +09:00
c736b2982f feat: Check Supabase alerts_enabled before sending telegram 2026-04-14 16:40:59 +09:00
0e0b64f20f feat: Add alerts toggle in Dashboard 2026-04-14 16:40:51 +09:00
cd684eae22 feat: Add alerts_enabled to plant schemas and endpoints 2026-04-14 16:40:47 +09:00
19103b3226 알람전송오류 2026-03-30 16:06:39 +09:00
c94ca954dd 텔레그램 알림 변경. 2026-03-30 15:22:28 +09:00
ac0cbbc44a 수정 2026-03-30 13:01:18 +09:00
a1f8c74ec8 feat: add comparison screen with simplified labels 2026-02-12 10:51:16 +09:00
d8a3efab06 fix: fallback to daily_stats summation for current month stats 2026-02-12 10:50:40 +09:00
f139b2abb4 feat: add comparison stats api (/plants/stats/comparison) 2026-02-12 10:38:22 +09:00
3420bee2bf Initial commit for SolarPower App 2026-01-30 11:46:03 +09:00
20ef587800 Initial commit with fixed daily summary logic 2026-01-30 11:43:08 +09:00
0663458fc7 연간 데이터 기본 5개 2026-01-28 10:28:17 +09:00
665ff4914e feat: enhance stats API for date navigation and support new excel upload format 2026-01-28 10:16:48 +09:00
4a5762b938 fix: Improve Excel parsing and error messages for monthly upload 2026-01-27 18:10:46 +09:00
d56a8f7ae1 refactor: Remove /upload prefix from upload router for better URL structure 2026-01-27 17:48:17 +09:00
d9de2e939b feat: Add monthly stats excel upload endpoint 2026-01-27 17:44:09 +09:00
02a9149f55 feat: Switch to monthly_stats table for month/year stats aggregation 2026-01-27 17:12:56 +09:00
c1223c1f14 fix: Implement pagination to bypass Supabase 1000 row hard limit 2026-01-27 16:58:48 +09:00
cfb8079809 fix: Increase Supabase query limit to fetch all historical stats 2026-01-27 16:45:59 +09:00
3b9403b654 fix: Ensure current year is included in yearly stats even if no data 2026-01-27 15:40:40 +09:00
39c7928895 feat: Add year parameter to stats API and extend year range 2026-01-27 15:34:20 +09:00
060c32d105 feat: change stats period to current month and fix label logic 2026-01-26 11:48:18 +09:00
15e611ebb6 fix: stats timezone issue (UTC to KST) 2026-01-26 10:56:19 +09:00
1aa4448f9f feat: Add hourly stats endpoint for today chart 2026-01-26 10:49:49 +09:00
a7a83e8792 feat: Update stats API to include real-time crawled data 2026-01-23 16:45:37 +09:00
f4e7e8b03e fix: Reorder router registration to fix route matching 2026-01-23 16:24:53 +09:00
5c43b6e43b feat: Add stats and upload APIs for plant detail screen 2026-01-23 15:42:40 +09:00
a891891a6e chore: add pandas, openpyxl, python-multipart dependencies 2026-01-23 11:39:31 +09:00
1b76ad61ed feat: 엑셀 업로드 API 추가 (POST /upload/history) 2026-01-23 11:27:56 +09:00
ac3d64ed7f fix: update SolarLogBase schema to match DB columns (current_kw, today_kwh, status) 2026-01-22 15:44:36 +09:00
126ede33ab fix: revert company_id back to int type 2026-01-22 15:25:52 +09:00
6ae0322918 fix: change PlantBase id and company_id to str type 2026-01-22 15:24:26 +09:00
903d2cfb0b fix: change plant_id to str, timestamp to created_at for DB schema match 2026-01-22 15:22:22 +09:00
f826028161 Fix: change timestamp column name to created_at 2026-01-22 15:18:04 +09:00
8878303cac Initial commit: FastAPI middleware server for solar power monitoring 2026-01-22 14:22:47 +09:00