Commit graph

7 commits

Author SHA1 Message Date
DJP
27c23bd98f Enhancement: Add timestamps to batch entries in daily report for better identification 2026-01-19 15:16:13 -05:00
DJP
a5b4c78b01 Fix: Increment campaigns_processed for file-based workflow batches to show in breakdown 2026-01-19 15:13:58 -05:00
DJP
72a02b3667 Fix: Add batch entries to workflow breakdown for file-based workflows in daily report 2026-01-19 15:12:48 -05:00
DJP
331f47d9ef Fix: Correct summary block parsing in daily report to capture all workflow activity 2026-01-19 15:09:40 -05:00
DJP
7eb99536b7 Fix: Add parsing for all workflow summary patterns in daily report 2026-01-19 15:05:27 -05:00
DJP
0af15563bc feat: Implement new Python script locking, relocate PHP workflow, and update Python scripts and documentation. 2025-11-21 17:20:34 -05:00
DJP
c720759cc7 Add daily summary report with comprehensive statistics
Automated daily report that analyzes all workflow logs and sends email summary at 7pm.

NEW SCRIPT: daily_report.py
- Analyzes last 24 hours of all workflow logs
- Parses campaign and asset statistics
- Extracts error messages
- Sends comprehensive email report
- Run via cron at 7pm daily

FEATURES:
✓ Overall summary statistics across all workflows
✓ Per-workflow breakdown (A1→A2, A2→A3, A5→A6, B1→B2)
✓ Success rate calculation
✓ Campaign details with status (completed/partial/no_assets)
✓ Error log extraction
✓ Collapsible sections for campaign and error details
✓ Color-coded metrics (green=good, orange=warning, red=error)

STATISTICS TRACKED:
- Campaigns found/processed/completed/partial
- Total assets processed/successful/failed
- NOT APPROVED assets (A5→A6)
- Skipped assets (approved items)
- Success rate percentage
- Error count and messages

EMAIL TEMPLATE: daily_report
- Blue theme (#1976d2)
- Grid layout for statistics
- Collapsible campaign details
- Collapsible error logs (max 10 shown)
- Professional dashboard-style formatting

USAGE:
  python scripts/daily_report.py

CRON SCHEDULE (7pm daily):
  0 19 * * * cd ~/Python-Version && venv/bin/python scripts/daily_report.py >> logs/daily_report.log 2>&1

TESTED:
✓ Successfully parsed all 4 workflow logs
✓ Found 26 campaigns, 58 assets from last 24 hours
✓ Email sent successfully with all statistics
✓ Success rate: 48.3% (from test data)
✓ Error extraction working

Changes:
- NEW: scripts/daily_report.py (241 lines)
- EDIT: shared/notifier.py (add daily_report template)

🤖 Generated with [Claude Code](https://claude.com/claude-code)

Co-Authored-By: Claude <noreply@anthropic.com>
2025-11-04 16:34:44 -05:00