Commit graph

10 commits

Author SHA1 Message Date
nickviljoen
a52d50d549 Reporting: show searched Box folder under the search input
Mirrors the hint pattern just added to Video Master so users can see
exactly which Box folder the search is scanning, with a clickable
link to open it in Box for self-diagnosis when a job number doesn't
turn up.
2026-05-09 20:23:06 +02:00
nickviljoen
a0a9d0af47 Reporting: show all jobs in Previous Box Reports
Aggregate box_import reports by job_number in SQL instead of fetching
the most recent 100 rows and grouping in Python. The row-level LIMIT
hid older jobs whenever one job's rows filled the window.

Co-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com>
2026-05-01 15:15:58 +02:00
nickviljoen
42055d9a7a Fix Video QC crash and Reporting history dashboard
- video_qc/executor.py: escape braces in JSON example blocks inside
  f-string prompts (visual_quality, censorship). Unescaped { } made
  Python parse the example as format specifiers, raising
  "Invalid format specifier ' 85, ..." and failing execution.
- reporting/routes.py: history_dashboard now passes reports=parsed_reports
  (matching the live dashboard route) and attaches friendly_checks per
  report. Previously passed parsed_reports=friendly_reports, a kwarg
  the template does not consume, leaving the Parsed Data View accordion
  empty and breaking the "View Details" scroll-to-file links.

Co-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com>
2026-04-23 09:34:22 +02:00
nickviljoen
b4abbe8d2d Add delete buttons for reports in both HM QC and Reporting sections
- HM QC: trash icon per report row, DELETE /hm-qc/report/<id> removes
  DB record and file from disk
- Reporting: trash icon per Box job row, DELETE /reporting/history/delete/<job>
  removes all saved Box reports for that job number
- Confirmation prompts before deletion

Co-Authored-By: Claude Opus 4.6 (1M context) <noreply@anthropic.com>
2026-03-21 18:13:03 +02:00
nickviljoen
23fda1ec70 Move QC reports section from Reporting tab to HM QC tab
- Remove "Previous QC Reports" table from reporting index
- Add "Previous QC Reports" table to HM QC index page
- Update HM QC index route to pass recent reports
- Update feature list to reflect current checks

Co-Authored-By: Claude Opus 4.6 (1M context) <noreply@anthropic.com>
2026-03-21 17:16:41 +02:00
nickviljoen
634eb2a634 Split previous reports into Box and QC sections, view from DB not re-search
- Add /reporting/history/<job_number> route that loads saved reports from
  disk/database instead of re-fetching from Box
- Split "Previous Searches" into "Previous Box Reports" and "Previous QC
  Reports" sections with separate tables
- "View" buttons link to history_dashboard (reads from saved files)
- Box reports show job-grouped view, QC reports show individual files

Co-Authored-By: Claude Opus 4.6 (1M context) <noreply@anthropic.com>
2026-03-21 17:12:47 +02:00
nickviljoen
e2b9691912 Save Box search results to database for reporting history
- After a successful Box search, save downloaded HTML reports to disk
  and record them in qc_reports table (report_type='box_import')
- Skip duplicates by checking box_id in metadata
- Update reporting index to show "Previous Searches" with source badges
- Rename "Recent Reports" to "Previous Searches" for clarity

Co-Authored-By: Claude Opus 4.6 (1M context) <noreply@anthropic.com>
2026-03-21 17:06:33 +02:00
nickviljoen
9ce44981eb Batch 1: Fix navigation and add past reports views
- Fix back navigation on reporting dashboards (linked to / instead of /reporting/index)
- Add "Run Another QC" button on HM QC results page
- Add Recent Reports table on reporting search page (grouped by job number)
- Add Recent QC Reports table on HM QC upload page

Co-Authored-By: Claude Opus 4.6 (1M context) <noreply@anthropic.com>
2026-03-21 16:48:24 +02:00
nickviljoen
ffd8b7303c v1.1.0: Add progress tracking, CSV export, multi-job support, batch processing, and security fixes
- Reporting: async search with SSE progress bar, CSV export with Box file links,
  multi-job support, designer-friendly error display with action guidance
- HM QC: batch file upload (up to 100 files), batch execution with rate limiting,
  batch results summary
- Fix: SQLAlchemy stale cache in SSE progress streaming (expire_all + commit)
- Fix: Box folder pagination loop (search API instead of iterating 10,300 folders)
- Fix: HM QC blank screen (progress.js not loaded, hardcoded wrong URLs)
- Security: remove hardcoded API keys from legacy files, read from .env instead

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
2026-03-13 09:43:20 +02:00
nickviljoen
e6f3e9387e Add modular architecture, core framework, and web UI
New blueprint-based module system (hm_qc, video_qc, video_master,
reporting), core framework (database, config, templates), and
unified web interface with progress tracking and tab navigation.

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
2026-02-25 11:39:04 +02:00