#!/bin/sh
# 部署勞工主任獨立功能 — 在 server 上以 root 執行
set -e

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

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

for f in app/Models/LaborOfficer.php app/Models/BriefingLocation.php app/Http/Controllers/LaborOfficerController.php app/Http/Controllers/BriefingLocationController.php routes/web.php resources/views/briefing_locations.blade.php resources/views/briefing_locations_edit.blade.php; do
  mkdir -p $BASE/backup/files_lo/$(dirname $f)
  cp -a $PROJ/$f $BASE/backup/files_lo/$f 2>/dev/null || true
  cp -a $BASE/extract_lo/$f $PROJ/$f
done

echo "=== [2/3] migration + 清快取 ==="
cp -a $BASE/extract_lo/database/migrations/2026_09_08_110000_create_labor_officers_table.php $PROJ/database/migrations/
chown -R www:www $PROJ/app $PROJ/routes $PROJ/database $PROJ/resources
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 "=== [3/3] 驗證 ==="
echo "-- labor_officers routes: $(grep -c 'labor_officers' routes/web.php) (3 = OK)"
sudo -u www /usr/bin/php artisan tinker --execute="echo 'labor_officers table: '.(Illuminate\Support\Facades\Schema::hasTable('labor_officers')?'OK':'MISSING').PHP_EOL; echo 'briefing officer col removed: '.(!Illuminate\Support\Facades\Schema::hasColumn('briefing_locations','officer_name')?'OK':'STILL THERE').PHP_EOL;" 2>/dev/null | tail -2
echo "=== 完成 ==="