#!/usr/bin/env bash
# ==============================================================================
# Fibbers v2 - Automated Daily Backup Script
# ==============================================================================
# Performs automated MySQL database dumps streamed to gzip and uploaded to S3.
# Supports optional synchronization of user uploaded media/content.
#
# Usage:
#   ./backup.sh                  # Daily run: database backup only
#   ./backup.sh --with-content   # Database backup + content sync
#   ./backup.sh --content-only   # Content sync only (skip database)
#   ./backup.sh --dry-run        # Test configuration, tools, and connections
#   ./backup.sh --help           # Show usage help
# ==============================================================================

set -eo pipefail

# ------------------------------------------------------------------------------
# 1. Project Configuration & Path Resolution
# ------------------------------------------------------------------------------
PROJECT_NAME="Fibbers v2"
PROJECT_SLUG="fibbers2"
HOST=$(hostname 2>/dev/null || echo "unknown-host")

# Resolve project root dynamically from script location
SCRIPT_DIR="$(cd "$(dirname "${BASH_SOURCE[0]}")" && pwd)"
PROJECT_ROOT="$SCRIPT_DIR"
ENV_FILE="$PROJECT_ROOT/.env"
BACKUP_TEMP_DIR="$PROJECT_ROOT/storage/app/backups_tmp"

# ------------------------------------------------------------------------------
# 2. Content Backup Configuration
# ------------------------------------------------------------------------------
# Default mode: database-only. Set to true to include content by default,
# or override on-demand with CLI flags (--with-content / --content-only).
BACKUP_CONTENT=false
SKIP_DATABASE=false
DRY_RUN=false

# Content directories to sync to S3 when content backup is enabled.
# Paths can be relative to PROJECT_ROOT or absolute.
# Default: 'storage/app/public' (standard Laravel user-uploaded media).
# To back up additional directories, add them to the array below, for example:
#   "storage/app/public"
#   "storage/app/private"
#   "public/uploads"
CONTENT_FOLDERS=(
    "storage/app/public"
)

# ------------------------------------------------------------------------------
# 3. Environment Variable Loader (.env Parser)
# ------------------------------------------------------------------------------
get_env_val() {
    local key="$1"
    local default_val="$2"
    local val=""

    if [ -f "$ENV_FILE" ]; then
        # Match KEY=value, ignoring comments and stripping quotes
        val=$(grep -E "^[[:space:]]*${key}=" "$ENV_FILE" 2>/dev/null | tail -n 1 | cut -d '=' -f2- | sed -e 's/^[[:space:]]*["'"'"']//' -e 's/["'"'"'][[:space:]]*$//' -e 's/^[[:space:]]*//' -e 's/[[:space:]]*$//')
    fi

    if [ -z "$val" ]; then
        echo "$default_val"
    else
        echo "$val"
    fi
}

# Database credentials (prioritizes BACKUP_DB_* if set, then DB_* from .env, then defaults)
DB_HOST="${DB_HOST:-$(get_env_val "DB_HOST" "127.0.0.1")}"
DB_PORT="${DB_PORT:-$(get_env_val "DB_PORT" "3306")}"
DB_NAME="${DB_DATABASE:-$(get_env_val "DB_DATABASE" "fibbers2")}"
DB_USER="${BACKUP_DB_USERNAME:-$(get_env_val "BACKUP_DB_USERNAME" "$(get_env_val "DB_USERNAME" "root")")}"
DB_PASS="${BACKUP_DB_PASSWORD:-$(get_env_val "BACKUP_DB_PASSWORD" "$(get_env_val "DB_PASSWORD" "")")}"

# S3 Configuration from .env (prioritizes dedicated BACKUP_AWS_* keys, then general AWS_* keys)
AWS_ACCESS_KEY_ID="${BACKUP_AWS_ACCESS_KEY_ID:-$(get_env_val "BACKUP_AWS_ACCESS_KEY_ID" "$(get_env_val "AWS_ACCESS_KEY_ID" "")")}"
AWS_SECRET_ACCESS_KEY="${BACKUP_AWS_SECRET_ACCESS_KEY:-$(get_env_val "BACKUP_AWS_SECRET_ACCESS_KEY" "$(get_env_val "AWS_SECRET_ACCESS_KEY" "")")}"
AWS_DEFAULT_REGION="${BACKUP_AWS_DEFAULT_REGION:-$(get_env_val "BACKUP_AWS_DEFAULT_REGION" "$(get_env_val "AWS_DEFAULT_REGION" "eu-west-1")")}"
AWS_BUCKET="${BACKUP_AWS_BUCKET:-$(get_env_val "BACKUP_AWS_BUCKET" "$(get_env_val "AWS_BUCKET" "eu-backup.brightfive.com")")}"

# Notification Settings
NOTIFY_EMAIL="${BACKUP_NOTIFICATION_EMAIL:-$(get_env_val "ADMIN_EMAIL" "jamie@brightfive.com")}"
NOTIFY_FROM="${MAIL_FROM_ADDRESS:-$(get_env_val "MAIL_FROM_ADDRESS" "backup@brightfive.com")}"
SENDGRID_API_KEY="${SENDGRID_API_KEY:-$(get_env_val "SENDGRID_API_KEY" "")}"

# Binaries
MYSQLDUMP_BIN="$(command -v mysqldump || echo "/usr/bin/mysqldump")"
MYSQL_BIN="$(command -v mysql || echo "/usr/bin/mysql")"
GZIP_BIN="$(command -v gzip || echo "/bin/gzip")"
S3CMD_BIN="$(command -v s3cmd || echo "/usr/bin/s3cmd")"
PHP_BIN="$(command -v php || echo "/usr/bin/php")"

# ------------------------------------------------------------------------------
# 4. Cleanup & Notification Handlers
# ------------------------------------------------------------------------------
cleanup() {
    # Strictly guarded: only removes the dedicated temporary dump folder if it exists
    if [ -n "$BACKUP_TEMP_DIR" ] && [ -d "$BACKUP_TEMP_DIR" ] && [[ "$BACKUP_TEMP_DIR" == *"storage/app/backups_tmp" ]]; then
        rm -rf "$BACKUP_TEMP_DIR"
    fi
}
trap cleanup EXIT

send_failure_notification() {
    local error_message="$1"
    local subject="[ALERT] $PROJECT_NAME Backup Failed on $HOST ($(date +%Y-%m-%d))"
    local body="The automated backup script for $PROJECT_NAME encountered a critical error.

Host:       $HOST
Time:       $(date)
Directory:  $PROJECT_ROOT
Database:   $DB_NAME

Error Details:
$error_message

Please check the server logs."

    echo -e "\n[!] Sending failure notification to $NOTIFY_EMAIL..." >&2

    # Method 1: Laravel Mail facade via Artisan tinker (uses site's tested mail config)
    # Uses base64 encoding to prevent PHP heredoc from interpolating shell variables (e.g. $GZIP_BIN)
    if [ -x "$PHP_BIN" ] && [ -f "$PROJECT_ROOT/artisan" ]; then
        local body_b64 subject_b64
        body_b64=$(printf "%s" "$body" | base64 | tr -d '\r\n')
        subject_b64=$(printf "%s" "$subject" | base64 | tr -d '\r\n')
        "$PHP_BIN" "$PROJECT_ROOT/artisan" tinker --execute="
            try {
                \Illuminate\Support\Facades\Mail::raw(
                    base64_decode('$body_b64'),
                    function (\$m) {
                        \$m->to('$NOTIFY_EMAIL')->subject(base64_decode('$subject_b64'));
                    }
                );
            } catch (\Throwable \$e) {
                echo 'Artisan mailer error: ' . \$e->getMessage();
                exit(1);
            }
        " >/dev/null 2>&1 && return 0
    fi

    # Method 2: SendGrid v3 API (if SENDGRID_API_KEY is present in .env)
    if [ -n "$SENDGRID_API_KEY" ] && command -v curl >/dev/null 2>&1; then
        local json_escaped_body
        json_escaped_body=$(printf "%s" "$body" | sed -e 's/\\/\\\\/g' -e 's/"/\\"/g' | sed ':a;N;$!ba;s/\n/\\n/g')
        local payload
        payload=$(cat <<EOF
{
  "personalizations": [{"to": [{"email": "$NOTIFY_EMAIL"}]}],
  "from": {"email": "$NOTIFY_FROM", "name": "$PROJECT_NAME Backup"},
  "subject": "$subject",
  "content": [{"type": "text/plain", "value": "$json_escaped_body"}]
}
EOF
)
        curl -s -X POST "https://api.sendgrid.com/v3/mail/send" \
            -H "Authorization: Bearer $SENDGRID_API_KEY" \
            -H "Content-Type: application/json" \
            -d "$payload" >/dev/null 2>&1 && return 0
    fi

    # Method 3: Standard Linux system mail/sendmail
    if command -v mail >/dev/null 2>&1; then
        echo "$body" | mail -s "$subject" "$NOTIFY_EMAIL" >/dev/null 2>&1 && return 0
    elif command -v sendmail >/dev/null 2>&1; then
        printf "Subject: %s\nTo: %s\nFrom: %s\n\n%s\n" "$subject" "$NOTIFY_EMAIL" "$NOTIFY_FROM" "$body" | sendmail -t >/dev/null 2>&1 && return 0
    fi

    echo "Warning: Email delivery failed. Ensure mail configuration or sendmail is active on $HOST." >&2
}

on_error() {
    local exit_code="$?"
    local line_no="$1"
    local command_name="$2"
    local err_msg="Command '$command_name' failed on line $line_no with exit code $exit_code."
    
    # Append any captured stderr from mysqldump or other commands if available
    if [ -n "$DUMP_STDERR_FILE" ] && [ -s "$DUMP_STDERR_FILE" ]; then
        local captured_stderr
        captured_stderr=$(cat "$DUMP_STDERR_FILE" 2>/dev/null | tail -n 15)
        if [ -n "$captured_stderr" ]; then
            err_msg="$err_msg"$'\n\n'"Command Output / Error:"$'\n'"$captured_stderr"
        fi
    fi

    echo -e "\n[ERROR] $err_msg" >&2
    if [ "$DRY_RUN" = false ]; then
        send_failure_notification "$err_msg"
    fi
    exit "$exit_code"
}
trap 'on_error $LINENO "$BASH_COMMAND"' ERR

# ------------------------------------------------------------------------------
# 5. Helper Functions
# ------------------------------------------------------------------------------
build_s3_auth_args() {
    S3_AUTH_ARGS=()
    if [ -n "$AWS_ACCESS_KEY_ID" ] && [ -n "$AWS_SECRET_ACCESS_KEY" ]; then
        S3_AUTH_ARGS+=( "--access_key=$AWS_ACCESS_KEY_ID" "--secret_key=$AWS_SECRET_ACCESS_KEY" )
        if [ -n "$AWS_DEFAULT_REGION" ]; then
            S3_AUTH_ARGS+=( "--region=$AWS_DEFAULT_REGION" )
        fi
    fi
}

show_help() {
    cat <<EOF
$PROJECT_NAME Backup Script
Usage: ./backup.sh [OPTIONS]

Options:
  --with-content     Perform database backup AND sync content folders
  --content-only     Sync content folders only (skip database backup)
  --dry-run, --test  Verify dependencies, database connection, and S3 credentials
  --help, -h         Display this help message

Scheduled Cron Examples:
  # Daily database backup at 02:00 AM:
  0 2 * * * /var/www/html/$PROJECT_SLUG/backup.sh >> /var/log/backup-$PROJECT_SLUG.log 2>&1

  # Weekly database + content backup on Sunday at 03:00 AM:
  0 3 * * 0 /var/www/html/$PROJECT_SLUG/backup.sh --with-content >> /var/log/backup-$PROJECT_SLUG.log 2>&1
EOF
    exit 0
}

# ------------------------------------------------------------------------------
# 6. Parse Command Line Arguments
# ------------------------------------------------------------------------------
while [[ $# -gt 0 ]]; do
    case "$1" in
        --with-content)
            BACKUP_CONTENT=true
            shift
            ;;
        --content-only)
            BACKUP_CONTENT=true
            SKIP_DATABASE=true
            shift
            ;;
        --dry-run|--test)
            DRY_RUN=true
            shift
            ;;
        -h|--help)
            show_help
            ;;
        *)
            echo "Unknown argument: $1" >&2
            echo "Run './backup.sh --help' for usage." >&2
            exit 1
            ;;
    esac
done

build_s3_auth_args

# ------------------------------------------------------------------------------
# 7. Dry-Run / Test Mode
# ------------------------------------------------------------------------------
if [ "$DRY_RUN" = true ]; then
    echo "=================================================================="
    echo "[$PROJECT_NAME] Dry-Run & Configuration Validation"
    echo "=================================================================="
    echo "Host:             $HOST"
    echo "Project Root:     $PROJECT_ROOT"
    echo "Database:         $DB_USER@$DB_HOST:$DB_PORT/$DB_NAME"
    echo "S3 Bucket:        s3://$AWS_BUCKET/serverbackups/$PROJECT_SLUG/"
    echo "S3 Auth Method:   $([ -n "$AWS_ACCESS_KEY_ID" ] && echo "Configured in .env" || echo "System ~/.s3cfg")"
    echo "Failure Alert To: $NOTIFY_EMAIL"
    echo "Backup Content:   $BACKUP_CONTENT"
    echo "Content Folders:  ${CONTENT_FOLDERS[*]}"
    echo "------------------------------------------------------------------"

    # 1. Check binaries
    echo -n "Checking mysqldump binary... "
    if [ -x "$MYSQLDUMP_BIN" ] || command -v mysqldump >/dev/null 2>&1; then
        echo "OK ($MYSQLDUMP_BIN)"
    else
        echo "MISSING (mysqldump not found in PATH or /usr/bin/mysqldump)"
    fi

    echo -n "Checking gzip binary... "
    if [ -x "$GZIP_BIN" ] || command -v gzip >/dev/null 2>&1; then
        echo "OK ($GZIP_BIN)"
    else
        echo "MISSING (gzip not found)"
    fi

    echo -n "Checking s3cmd binary... "
    if [ -x "$S3CMD_BIN" ] || command -v s3cmd >/dev/null 2>&1; then
        echo "OK ($S3CMD_BIN)"
    else
        echo "WARNING: s3cmd not found in PATH or /usr/bin/s3cmd"
    fi

    # 2. Test database connection
    echo -n "Testing MySQL connection... "
    if command -v mysql >/dev/null 2>&1 || [ -x "$MYSQL_BIN" ]; then
        if MYSQL_PWD="$DB_PASS" "$MYSQL_BIN" -h "$DB_HOST" -P "$DB_PORT" -u "$DB_USER" -e "USE \`$DB_NAME\`;" >/dev/null 2>&1; then
            echo "SUCCESS (Connected to '$DB_NAME')"
        else
            echo "FAILED (Unable to connect to MySQL database '$DB_NAME')"
        fi
    else
        echo "SKIPPED ('mysql' client not installed to test connectivity directly)"
    fi

    # 3. Test S3 Bucket Connectivity
    if command -v s3cmd >/dev/null 2>&1 || [ -x "$S3CMD_BIN" ]; then
        echo -n "Testing S3 bucket access... "
        if "$S3CMD_BIN" "${S3_AUTH_ARGS[@]}" ls "s3://$AWS_BUCKET" >/dev/null 2>&1; then
            echo "SUCCESS (Bucket 's3://$AWS_BUCKET' is reachable)"
        else
            echo "WARNING: Could not list 's3://$AWS_BUCKET'. Verify AWS credentials and permissions."
        fi
    fi

    # 4. Verify Content Folders exist
    if [ "$BACKUP_CONTENT" = true ]; then
        echo "Validating content directories:"
        for folder in "${CONTENT_FOLDERS[@]}"; do
            target_path="$PROJECT_ROOT/$folder"
            if [ -d "$target_path" ]; then
                echo "  - $folder [EXISTS]"
            else
                echo "  - $folder [NOT FOUND: $target_path]"
            fi
        done
    fi

    echo "=================================================================="
    echo "Dry run completed successfully. No changes were made."
    exit 0
fi

# ------------------------------------------------------------------------------
# 8. Main Execution
# ------------------------------------------------------------------------------
DATE_SUFFIX=$(date +%Y%m%d_%H%M%S)
DATE_DAY=$(date +%Y%m%d)
DB_DUMP_FILENAME="${PROJECT_SLUG}_${DATE_DAY}.sql.gz"

echo "=================================================================="
echo "Starting $PROJECT_NAME backup: $(date)"
echo "Host: $HOST"
echo "=================================================================="

# --- Step A: Database Backup ---
if [ "$SKIP_DATABASE" = false ]; then
    mkdir -p "$BACKUP_TEMP_DIR"
    LOCAL_DUMP_PATH="$BACKUP_TEMP_DIR/$DB_DUMP_FILENAME"
    DUMP_STDERR_FILE="$BACKUP_TEMP_DIR/mysqldump_err.log"

    # Pre-flight check: ensure MySQL service and database are reachable
    if [ -x "$MYSQL_BIN" ] || command -v mysql >/dev/null 2>&1; then
        if ! MYSQL_PWD="$DB_PASS" "$MYSQL_BIN" -h "$DB_HOST" -P "$DB_PORT" -u "$DB_USER" -e "USE \`$DB_NAME\`;" 2>"$DUMP_STDERR_FILE"; then
            echo "[ERROR] Cannot connect to MySQL database '$DB_NAME' on $DB_HOST:$DB_PORT. The database server may be offline or unreachable." >&2
            exit 2
        fi
    fi

    echo "[1/2] Creating compressed database dump: $DB_DUMP_FILENAME"
    MYSQL_PWD="$DB_PASS" "$MYSQLDUMP_BIN" \
        -h "$DB_HOST" \
        -P "$DB_PORT" \
        -u "$DB_USER" \
        --single-transaction \
        --quick \
        --routines \
        --triggers \
        --no-tablespaces \
        "$DB_NAME" 2>"$DUMP_STDERR_FILE" | "$GZIP_BIN" -9 > "$LOCAL_DUMP_PATH"

    # Verify dump file was created and is non-empty
    if [ ! -s "$LOCAL_DUMP_PATH" ]; then
        echo "Error: Database dump file is empty or was not created." >&2
        exit 1
    fi

    DUMP_SIZE=$(du -h "$LOCAL_DUMP_PATH" | cut -f1)
    echo "      Database dump created successfully ($DUMP_SIZE)."

    echo "[2/2] Uploading database archive to S3..."
    S3_DB_DEST="s3://$AWS_BUCKET/serverbackups/$PROJECT_SLUG/databases/$DB_DUMP_FILENAME"
    "$S3CMD_BIN" put "${S3_AUTH_ARGS[@]}" "$LOCAL_DUMP_PATH" "$S3_DB_DEST"
    echo "      Uploaded to $S3_DB_DEST"

    # Remove local temp dump immediately after successful upload
    rm -f "$LOCAL_DUMP_PATH"
else
    echo "[INFO] Skipping database backup as requested."
fi

# --- Step B: Content Folders Sync (Optional) ---
if [ "$BACKUP_CONTENT" = true ]; then
    echo "=================================================================="
    echo "Syncing content folders to S3..."

    for folder in "${CONTENT_FOLDERS[@]}"; do
        # Resolve path
        if [[ "$folder" = /* ]]; then
            TARGET_PATH="$folder"
            FOLDER_LABEL=$(basename "$folder")
        else
            TARGET_PATH="$PROJECT_ROOT/$folder"
            FOLDER_LABEL="$folder"
        fi

        if [ -d "$TARGET_PATH" ]; then
            echo "Syncing '$FOLDER_LABEL' -> s3://$AWS_BUCKET/serverbackups/$PROJECT_SLUG/content/$FOLDER_LABEL/"
            "$S3CMD_BIN" sync "${S3_AUTH_ARGS[@]}" \
                "$TARGET_PATH/" \
                "s3://$AWS_BUCKET/serverbackups/$PROJECT_SLUG/content/$FOLDER_LABEL/"
        else
            echo "[WARNING] Content folder '$TARGET_PATH' does not exist. Skipping."
        fi
    done
fi

echo "=================================================================="
echo "Backup finished successfully at $(date)!"
echo "=================================================================="