#!/bin/sh
# Excel 匯入同步寫入「申請批文進度」+ 一次性回填已匯入資料 — 面板終端機以 root 執行
set -e
PROJ=/www/wwwroot/faithfulness
BASE=/home/wing/wkr_tmp

mkdir -p $BASE/extract_ps
tar -xzf $BASE/wkr_progress_sync.tar.gz -C $BASE/extract_ps

echo "=== [1/3] 備份 + 複製 + 權限 ==="
mkdir -p $BASE/backup/files
cp -a $PROJ/app/Imports/WorkersImport.php $BASE/backup/files/WorkersImport_$(date +%H%M%S).php
cp -a $BASE/extract_ps/app/Imports/WorkersImport.php $PROJ/app/Imports/
cp -a $BASE/extract_ps/app/Services/ApplicationProgressBackfill.php $PROJ/app/Services/
chown -R www:www $PROJ/app
echo "完成"

echo "=== [2/3] 清快取 ==="
cd $PROJ
sudo -u www /usr/bin/php artisan optimize:clear 2>&1 | tail -1

echo "=== [3/3] 回填已匯入工人的進度資料 ==="
sudo -u www /usr/bin/php artisan tinker --execute="print_r(app(App\Services\ApplicationProgressBackfill::class)->backfillFromWorkers());" 2>/dev/null | tail -4
echo "=== 完成，Ctrl+F5 重新整理「申請批文進度」頁 ==="