#!/bin/bash

# Get absolute path to the directory of this script
DIR="$( cd "$( dirname "${BASH_SOURCE[0]}" )" && pwd )"
CSV_PATH="$DIR/memory/decisions.csv"

if [ ! -f "$CSV_PATH" ]; then
  echo "Error: decisions.csv not found at $CSV_PATH"
  exit 1
fi

python3 -c "
import csv
import sys

csv_path = '$CSV_PATH'
due_items = []

with open(csv_path, 'r', newline='', encoding='utf-8') as f:
    reader = csv.reader(f)
    try:
        headers = next(reader)
    except StopIteration:
        print('Error: decisions.csv is empty')
        sys.exit(1)
        
    try:
        review_date_idx = headers.index('Review Date')
        decision_idx = headers.index('Decision')
        reasoning_idx = headers.index('Reasoning')
        outcome_idx = headers.index('Expected Outcome')
        status_idx = headers.index('Status')
    except ValueError as e:
        print(f'Error: missing expected header column in decisions.csv: {e}')
        sys.exit(1)
    
    for row in reader:
        if len(row) > status_idx and row[status_idx].strip() == 'REVIEW DUE':
            due_items.append(row)

if not due_items:
    print('✅ No decisions currently require review.')
    sys.exit(0)

print('=' * 80)
print(f'🚨 SURFACING {len(due_items)} DECISION(S) REQUIRING IMMEDIATE 30-DAY REVIEW')
print('=' * 80)

for idx, item in enumerate(due_items, 1):
    print(f'{idx}. DECISION  : {item[decision_idx]}')
    print(f'   Date Logged: {item[0]} | Review Date: {item[review_date_idx]}')
    print(f'   Reasoning  : {item[reasoning_idx]}')
    print(f'   Expected   : {item[outcome_idx]}')
    print('-' * 80)
"