#!/bin/bash

# --- CONFIG ---
PHP_PATH="/usr/bin/php"
EXPORT_SCRIPT="/var/www/wcfs/tabs/export_qbo_nightly.php"
EXPORT_DIR="/var/www/wcfs/tabs/qbo_exports"
EMAIL_TO="nodor@nykoinc.com"
DATE=$(date +%Y%m%d_%H%M%S)
START_DATE=$(date -d "$(date +%Y-%m-01) -2 days" +%Y-%m-%d)
END_DATE=$(date +%Y-%m-%d)
EXPORT_FILE="$EXPORT_DIR/qbo_export_nightly_${DATE}.csv"

# Ensure export directory exists
mkdir -p "$EXPORT_DIR"

# --- EXPORT DATA ---
$PHP_PATH "$EXPORT_SCRIPT" start="$START_DATE" end="$END_DATE" > "$EXPORT_FILE"

# --- EMAIL WITH MUTT (reliable attach) ---
if [ -s "$EXPORT_FILE" ]; then
    echo "Attached is the nightly QuickBooks export from $START_DATE to $END_DATE." | \
    mutt -s "WCFS QuickBooks Export $START_DATE to $END_DATE" \
    -a "$EXPORT_FILE" -- "$EMAIL_TO"
else
    echo "No data to export for $START_DATE to $END_DATE. Export file is empty." | \
    mutt -s "WCFS QuickBooks Export Skipped $DATE" -- "$EMAIL_TO"
fi