#!/bin/sh
# 系統改名 + 儀表板3級提醒 + 勞工申請進度表單改版
set -e
PROJ=/www/wwwroot/faithfulness
BASE=/home/wing/wkr_tmp

rm -rf $BASE/extract_rdl
mkdir -p $BASE/extract_rdl
tar -xzf $BASE/wkr_rename_dashboard_labor.tar.gz -C $BASE/extract_rdl

echo "=== [1/3] 覆蓋 + 備份 ==="
BK=$BASE/backup_rdl_$(date +%H%M%S)
mkdir -p $BK
for f in resources/views/layouts/admin.blade.php resources/views/login.blade.php resources/views/welcome.blade.php resources/views/dashboard.blade.php resources/views/labor_application_steps/_form.blade.php resources/views/labor_application_steps/index.blade.php public/css/pages/dashboard.css app/Http/Controllers/DashboardController.php app/Http/Controllers/LaborApplicationStepController.php app/Http/Requests/LaborApplicationStepRequest.php app/Models/LaborApplicationStep.php app/Services/ManualService.php app/Services/ContractTemplateService.php database/migrations/2026_09_10_100001_make_labor_briefing_date_datetime.php .env.example; do
  cp -a $PROJ/$f $BK/$(echo $f | tr '/' '_') 2>/dev/null || true
  cp -a $BASE/extract_rdl/$f $PROJ/$f
done
chown -R www:www $PROJ/resources $PROJ/app $PROJ/database $PROJ/public/css/pages $PROJ/.env.example
echo "覆蓋完成（備份於 $BK）"

echo "=== [2/3] 改 APP_NAME + migration ==="
sed -i "s/^APP_NAME=.*/APP_NAME=\"申請外勞管理系統\"/" $PROJ/.env
grep '^APP_NAME=' $PROJ/.env
cd $PROJ
sudo -u www /usr/bin/php artisan migrate --force 2>&1 | grep -v Warning | tail -2

echo "=== [3/3] 清快取 + 驗證 ==="
sudo -u www /usr/bin/php artisan optimize:clear 2>&1 | tail -1
echo "briefing datetime col: $(sudo -u www /usr/bin/php artisan tinker --execute='echo Illuminate\Support\Facades\Schema::getColumnType(chr(108).chr(97).chr(98).chr(111).chr(114).chr(95).chr(97).chr(112).chr(112).chr(108).chr(105).chr(99).chr(97).chr(116).chr(105).chr(111).chr(110).chr(95).chr(115).chr(116).chr(101).chr(112).chr(115), chr(98).chr(114).chr(105).chr(101).chr(102).chr(105).chr(110).chr(103).chr(95).chr(100).chr(97).chr(116).chr(101));' 2>/dev/null | tail -1)"
echo "rename in layout: $(grep -c '申請外勞管理系統' resources/views/layouts/admin.blade.php) (>=2 = OK)"
echo "urgency css: $(grep -c 'urg-badge-urgent' public/css/pages/dashboard.css) (>=1 = OK)"
echo "form radio: $(grep -c 'briefing_will_attend' resources/views/labor_application_steps/_form.blade.php) (>=2 = OK)"
echo "=== 完成，Ctrl+F5 ==="