#!/bin/sh
# ============================================================
#  新增「申請批文進度」頁面（手動維護，每筆含 15 個欄位）
#  適用：154.94.239.207 (BT Panel)
#  請以 root 執行（寶塔面板「終端機」內貼上）
# ============================================================
set -e

PROJ=/www/wwwroot/faithfulness
BASE=/home/wing/wkr_tmp

echo "=== [1/4] 解壓 ==="
mkdir -p $BASE/extract_ap
tar -xzf $BASE/wkr_app_progress.tar.gz -C $BASE/extract_ap
echo "完成"

echo "=== [2/4] 備份舊檔 ==="
mkdir -p $BASE/backup/files_ap
cp -a $PROJ/routes/web.php $BASE/backup/files_ap/web_$(date +%H%M%S).php
cp -a $PROJ/resources/views/layouts/admin.blade.php $BASE/backup/files_ap/admin_$(date +%H%M%S).blade.php
echo "完成"

echo "=== [3/4] 複製新檔 + 權限 ==="
cp -a $BASE/extract_ap/app/Models/ApplicationProgress.php $PROJ/app/Models/
cp -a $BASE/extract_ap/app/Http/Controllers/ApplicationProgressController.php $PROJ/app/Http/Controllers/
cp -a $BASE/extract_ap/app/Http/Requests/ApplicationProgressRequest.php $PROJ/app/Http/Requests/
cp -a $BASE/extract_ap/database/migrations/2026_09_06_000002_create_application_progresses_table.php $PROJ/database/migrations/
cp -a $BASE/extract_ap/routes/web.php $PROJ/routes/
mkdir -p $PROJ/resources/views/application_progresses
cp -a $BASE/extract_ap/resources/views/application_progresses/*.blade.php $PROJ/resources/views/application_progresses/
cp -a $BASE/extract_ap/resources/views/layouts/admin.blade.php $PROJ/resources/views/layouts/
chown -R www:www $PROJ/app $PROJ/routes $PROJ/database $PROJ/resources
echo "完成"

echo "=== [4/4] migration + 清快取 + 驗證 ==="
cd $PROJ
sudo -u www /usr/bin/php artisan migrate --force
sudo -u www /usr/bin/php artisan optimize:clear 2>&1 | tail -1
echo "-- table exists: $(sudo -u www /usr/bin/php artisan tinker --execute="echo Illuminate\Support\Facades\Schema::hasTable('application_progresses')?'OK':'MISSING';" 2>/dev/null)"
echo "-- routes: $(sudo -u www /usr/bin/php artisan route:list 2>/dev/null | grep -c application_progresses) (6 = OK)"
echo "-- sidebar: $(grep -c 'application_progresses' resources/views/layouts/admin.blade.php) (>=1 = OK)"
echo "=== 完成，請 Ctrl+F5 重新整理頁面，側欄會出現「申請批文進度」 ==="