Gecko [ signalhgwellness.com ]

Name	Size	Permission
.agents	[ DIR ]	drwxrwxrwx
.claude	[ DIR ]	drwxrwxrwx
.git	[ DIR ]	drwxrwxrwx
app	[ DIR ]	drwxrwxrwx
bootstrap	[ DIR ]	drwxrwxrwx
bspjthi	[ DIR ]	drwxr-xr-x
ckwyxli	[ DIR ]	drwxr-xr-x
config	[ DIR ]	drwxrwxrwx
database	[ DIR ]	drwxrwxrwx
docs	[ DIR ]	drwxrwxrwx
evtjano	[ DIR ]	drwxr-xr-x
ezmonph	[ DIR ]	drwxr-xr-x
gpdqxlb	[ DIR ]	drwxr-xr-x
hcylkzp	[ DIR ]	drwxr-xr-x
homecare-saas	[ DIR ]	drwxr-x---
homecare-saas-next	[ DIR ]	drwxr-x---
jdqmsea	[ DIR ]	drwxr-xr-x
resources	[ DIR ]	drwxrwxrwx
routes	[ DIR ]	drwxrwxrwx
zfrycve	[ DIR ]	drwxr-xr-x
.env.example	597 B	-rw-rw-rw-
.htaccess	129 B	-rw-r--r--
README.md	3.63 KB	-rw-rw-rw-
composer.json	991 B	-rw-rw-rw-
cutover.sh	2.36 KB	-rwxr-xr-x
def.html	263 B	-rw-r--r--
googleaf9cd7197c8a84d8.html	53 B	-rw-r--r--
package.json	745 B	-rw-rw-rw-
unzipper.php	11.99 KB	-rw-r--r--

Code Editor : cutover.sh

#!/bin/bash
# ---------------------------------------------------------------------------
# HomeCareUS cutover — master-list provisioning + referral sources + menu fixes
#
# Everything below has already been run and verified against a full clone of
# the production database in /home/signgwph/homecareus.io/homecare-saas-next.
#
# The database changes are ADDITIVE and backward-compatible: the old code
# ignores the new referral_sources table, and the seeded master lists simply
# show up as data. That means rollback is only the directory rename at the end.
# ---------------------------------------------------------------------------
set -e

PHP=/opt/cpanel/ea-php83/root/usr/bin/php
ROOT=/home/signgwph/homecareus.io
TS=$(date +%Y%m%d-%H%M)

cd "$ROOT/homecare-saas-next"

echo "==> 1/6  Pointing at the live database"
# Set explicitly rather than trusting whatever the sandbox was last tested
# against — this directory gets repointed at a scratch database during testing.
sed -i 's/^DB_DATABASE=.*/DB_DATABASE=signgwph_homecareuss/' .env
$PHP artisan config:clear >/dev/null
$PHP artisan tinker --execute="echo '    database: '.DB::connection()->getDatabaseName().PHP_EOL;"

echo "==> 2/6  Running migrations (referral_sources + care_plan_task_completions)"
$PHP artisan migrate --force

echo "==> 3/6  Seeding master lists for every existing agency"
$PHP artisan agency:seed-master-lists --all

echo "==> 4/6  Final storage sync (picks up anything uploaded in the last few minutes)"
rsync -a "$ROOT/homecare-saas/storage/app/" "$ROOT/homecare-saas-next/storage/app/"

echo "==> 5/6  Switching directories"
cd "$ROOT"
mv homecare-saas "homecare-saas-prev-$TS"
mv homecare-saas-next homecare-saas
echo "    previous version kept at: homecare-saas-prev-$TS"

echo "==> 6/6  Clearing caches"
cd "$ROOT/homecare-saas"
$PHP artisan config:clear >/dev/null
$PHP artisan route:clear >/dev/null
$PHP artisan view:clear  >/dev/null

echo
echo "==> Verifying"
curl -s -o /dev/null -w '    login page  -> %{http_code}\n' -H 'Host: homecareus.io' https://127.0.0.1/login --insecure
$PHP artisan tinker --execute="
echo '    lookup rows -> '.App\Models\Lookup::withoutGlobalScopes()->count().PHP_EOL;
echo '    agencies    -> '.App\Models\Agency::withoutGlobalScopes()->count().PHP_EOL;
"
echo
echo "DONE.  To roll back:"
echo "  cd $ROOT && mv homecare-saas homecare-saas-next && mv homecare-saas-prev-$TS homecare-saas"

${this.title}

Code Editor : cutover.sh