#!/bin/sh
# 宿舍代理公司欄（康德美/信義）+ 分色改用此欄 — 面板終端機以 root 執行
set -e
PROJ=/www/wwwroot/faithfulness
BASE=/home/wing/wkr_tmp

mkdir -p $BASE/extract_ag
tar -xzf $BASE/wkr_agency_company.tar.gz -C $BASE/extract_ag

echo "=== [1/3] 備份 ==="
mkdir -p $BASE/backup/files
for f in app/Models/Dormitory.php app/Http/Requests/DormitoryRequest.php resources/views/dormitories.blade.php resources/views/dormitories_edit.blade.php; do
  mkdir -p $BASE/backup/files/$(dirname $f)
  cp -a $PROJ/$f $BASE/backup/files/$(dirname $f)/$(basename $f)_$(date +%H%M%S)
done
echo "備份完成"

echo "=== [2/3] 複製 + 權限 ==="
cp -a $BASE/extract_ag/app/Models/Dormitory.php $PROJ/app/Models/
cp -a $BASE/extract_ag/app/Http/Requests/DormitoryRequest.php $PROJ/app/Http/Requests/
cp -a $BASE/extract_ag/database/migrations/2026_09_07_000003_add_agency_company_to_dormitories.php $PROJ/database/migrations/
cp -a $BASE/extract_ag/resources/views/dormitories.blade.php $PROJ/resources/views/
cp -a $BASE/extract_ag/resources/views/dormitories_edit.blade.php $PROJ/resources/views/
chown -R www:www $PROJ/app $PROJ/database $PROJ/resources
echo "完成"

echo "=== [3/3] 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 "agency_company col: $(sudo -u www /usr/bin/php artisan tinker --execute=\"echo Illuminate\\Support\\Facades\\Schema::hasColumn('dormitories','agency_company')?'OK':'MISSING';\" 2>/dev/null)"
echo "=== 完成 ==="
echo "注意：請到每間宿舍的編輯頁選擇代理公司（康德美/信義人力資源），卡片才會分色"