[PASS] Case A: Weekly end date calculation (2026-05-26) [PASS] Case B: Monthly end date calculation (2026-06-19)
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dmcmhb5_park97k1.users' doesn't exist (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: dmcmhb5_park97k1, SQL: select * from `users` where `status` = active limit 1)
Illuminate\Database\Connection->runQueryCallback(string, array, object(Closure))Illuminate\Database\Connection->runQueryCallback(string, array, object(Closure))Illuminate\Database\Connection->run(string, array, object(Closure))Illuminate\Database\Connection->select(string, array, boolean)Illuminate\Database\Query\Builder->runSelect()Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()Illuminate\Database\Query\Builder->onceWithColumns(array, object(Closure))Illuminate\Database\Query\Builder->get(array)Illuminate\Database\Eloquent\Builder->getModels(array)Illuminate\Database\Eloquent\Builder->get(array)Illuminate\Database\Eloquent\Builder->first()18log_test("Case A: Weekly end date calculation (" . $endA->toDateString() . ")", $endA->toDateString() === "2026-05-26");19$startB = Carbon::parse("2026-05-20");20$endB = $startB->copy()->addMonth()->subDay();21log_test("Case B: Monthly end date calculation (" . $endB->toDateString() . ")", $endB->toDateString() === "2026-06-19");2223$user = User::where("status", "active")->first();24if (!$user) {25 $user = User::create(["name" => "Staff", "email" => "staff" . rand() . "@test.com", "password" => "pass", "status" => "active"]);26}27$user->givePermissionTo("subscriptions.view");2829$today = Carbon::now();30$subC = ParkingSubscription::create(["parking_client_id" => 1, "zone_id" => 1, "subscription_type" => "weekly", "start_date" => $today->copy()->subDays(3), "end_date" => $today->copy()->addDays(3), "fee" => 10, "status" => "active", "payment_status" => "paid"]);31$subD = ParkingSubscription::create(["parking_client_id" => 1, "zone_id" => 1, "subscription_type" => "weekly", "start_date" => $today->copy()->subDays(10), "end_date" => $today->copy()->subDay(), "fee" => 10, "status" => "active", "payment_status" => "paid"]);3233\Illuminate\Support\Facades\Artisan::call("parking-subscriptions:refresh-statuses");3435select exists (select 1 from information_schema.tables where table_schema = schema() and table_name = 'system_settings' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`