#!/bin/sh
# ============================================================
#  工人檔案頁：加欄位「續約人工」「替補信有效期」+ 詳情頁連結勞工總表
#  適用：154.94.239.207 (BT Panel)
# ============================================================
set -e

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

echo "=== [1/4] 解壓新檔 ==="
mkdir -p $BASE/extract_rf
tar -xzf $BASE/wkr_renewal_fields.tar.gz -C $BASE/extract_rf
echo "解壓完成"

echo "=== [2/4] 備份舊檔 ==="
mkdir -p $BASE/backup/files_rf
for f in app/Http/Requests/WorkerRequest.php resources/views/workers_show.blade.php resources/views/workers_edit.blade.php resources/views/workers_create.blade.php public/css/pages.css; do
  mkdir -p $BASE/backup/files_rf/$(dirname $f)
  cp -a $PROJ/$f $BASE/backup/files_rf/$f
done
echo "完成"

echo "=== [3/4] 複製新檔 ==="
cp -a $BASE/extract_rf/app/Http/Requests/WorkerRequest.php $PROJ/app/Http/Requests/
cp -a $BASE/extract_rf/resources/views/workers_show.blade.php $PROJ/resources/views/
cp -a $BASE/extract_rf/resources/views/workers_edit.blade.php $PROJ/resources/views/
cp -a $BASE/extract_rf/resources/views/workers_create.blade.php $PROJ/resources/views/
cp -a $BASE/extract_rf/public/css/pages.css $PROJ/public/css/
echo "完成"

echo "=== [4/4] 權限 + 清快取 + 驗證 ==="
chown -R www:www $PROJ/app $PROJ/resources $PROJ/public/css
cd $PROJ
sudo -u www /usr/bin/php artisan optimize:clear 2>&1 | tail -1
sudo -u www /usr/bin/php artisan view:cache 2>&1 | tail -1
sudo -u www /usr/bin/php artisan tinker --execute="echo 'salary_renewal: '.(Illuminate\Support\Facades\Schema::hasColumn('workers','salary_renewal')?'OK':'MISSING').PHP_EOL; echo 'replacement_letter_end_date: '.(Illuminate\Support\Facades\Schema::hasColumn('workers','replacement_letter_end_date')?'OK':'MISSING').PHP_EOL; echo 'workers: '.App\Models\Worker::count().PHP_EOL;" 2>/dev/null | tail -3
echo "=== 全部完成 ==="