#!/bin/sh
# 部署勞工總表頁（44 欄完整版式 + 匯出 Excel）
set -e

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

echo "=== [1/3] 解壓 + 備份 ==="
rm -rf $BASE/extract_wm
mkdir -p $BASE/extract_wm $BASE/backup/files_wm
tar -xzf $BASE/wkr_master_table.tar.gz -C $BASE/extract_wm

for f in app/Services/WorkerMasterService.php app/Http/Controllers/WorkerMasterController.php app/Exports/WorkerMasterExport.php routes/web.php resources/views/workers_master.blade.php resources/views/workers.blade.php resources/views/layouts/admin.blade.php; do
  mkdir -p $BASE/backup/files_wm/$(dirname $f)
  cp -a $PROJ/$f $BASE/backup/files_wm/$f 2>/dev/null || true
  cp -a $BASE/extract_wm/$f $PROJ/$f
done

echo "=== [2/3] 權限 + 清快取 ==="
chown -R www:www $PROJ/app $PROJ/routes $PROJ/resources
cd $PROJ
sudo -u www /usr/bin/php artisan optimize:clear 2>&1 | tail -1

echo "=== [3/3] 驗證 ==="
echo "-- workers_master routes: $(grep -c 'workers_master' routes/web.php) (2 = OK)"
echo "-- service exists: $(test -f app/Services/WorkerMasterService.php && echo OK || echo MISSING)"
echo "-- view exists: $(test -f resources/views/workers_master.blade.php && echo OK || echo MISSING)"
echo "-- header cols: $(sudo -u www /usr/bin/php artisan tinker --execute=\"echo count(app(App\Services\WorkerMasterService::class)->buildRows(null)[0]);\" 2>/dev/null | tail -1) (44 = OK)"
echo "=== 完成，側欄「工人檔案」頁新增「勞工總表」按鈕 ==="