#!/usr/bin/env bash
set -euo pipefail

REMOTE=root@socal
DIR=/var/www/erp/erp-pos
BACKUP_FILE=/backups/manual/erp_pos.sql

cd "$(dirname "$0")"

rsync -avz --delete \
  --exclude='.env' --exclude='.git/' --exclude='node_modules/' \
  --exclude='vendor/' --exclude='storage/' --exclude='bootstrap/cache/' \
  --exclude='public/hot' --exclude='.claude/' --exclude='.ai/' \
  --exclude='deploy.sh' \
  ./ "$REMOTE:$DIR/"

ssh "$REMOTE" "set -e
mkdir -p $(dirname "$BACKUP_FILE")
cd $DIR
pg_dump erp_pos > $BACKUP_FILE.tmp
mv $BACKUP_FILE.tmp $BACKUP_FILE
php artisan migrate --force
php artisan optimize:clear
php artisan config:cache
php artisan route:cache
php artisan view:cache
chown -R www-data:www-data storage bootstrap/cache"

echo "Deploy finished."