10 Commits

Author SHA1 Message Date
aa5bc3d3c8 Add autofilter to all Excel report sheets
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
2026-03-10 18:29:37 +01:00
d783882cf6 Centralize token.txt to project root
- Updated 35 scripts to read token.txt from project root
  using Path(__file__).resolve().parent.parent / "token.txt"
- Removed 6 duplicate token.txt files from subdirectories
- Single token.txt in project root serves all scripts

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
2026-03-10 18:27:38 +01:00
040e6074ae Add token.txt for agenda report scripts
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
2026-03-10 18:16:40 +01:00
6478902172 Rename 871 test.py to Report_AgendaPozadavky.py
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
2026-03-10 17:36:12 +01:00
68700ecd4d Merge branch 'claude/heuristic-lichterman' 2026-03-10 17:35:25 +01:00
e345e477d3 Rename report file and auto-delete previous reports
- Rename output to "YYYY-MM-DD HH-MM-SS Agenda + Požadavky.xlsx"
- Delete old reports before generating new one

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
2026-03-10 17:34:29 +01:00
a44606ce60 notebook 2026-03-10 07:45:47 +01:00
be0d41ad01 Fix agenda report and add MySQL sync for open requests
- 871 test.py: Switch auth from medevio_storage.json to token.txt,
  update MySQL port to 3306, add hyperlinks to Request_ID column,
  add better API error handling
- sync_open_requests.py: New script to sync doneAt/removedAt/updatedAt
  from Medevio API to MySQL for requests incorrectly marked as open
- check_request.py: Diagnostic script to inspect a single request via API
- check_mysql.py: Diagnostic script to inspect a single request in MySQL

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
2026-03-10 07:44:19 +01:00
55e723788b notebook 2026-01-16 17:06:54 +01:00
65c90750dc reporter 2025-12-07 12:11:50 +01:00