Files
Verde-Web/app/Models/Household.php
admin fcf2f9d0bf feat: multi-LGU tenancy — Phase A (foundation + customer-web)
Backend:
- New tenants table with PSGC-derived code, links to
  cities_municipalities, optional boundary_polygon override, theme
  color, contact info, timezone.
- Adds nullable tenant_id to users / households / drop_off_points /
  dumpsites / partner_stores. Foreign-keyed, indexed.
- Tenant model with deriveCode() helper + effectiveBoundary()
  fallback chain.
- App\Tenancy\Tenancy — process-level current-tenant register with
  withTenant() / withoutScope() helpers for jobs + super-admin.
- App\Tenancy\TenantScope — global Eloquent scope, no-op when no
  tenant is set (so seeders + super-admin reads still work).
- App\Tenancy\HasTenant trait — applied to Household, DropOffPoint,
  Dumpsite, PartnerStore. Auto-fills tenant_id on create from
  Tenancy::current().
- ResolveTenant middleware — reads X-Tenant-Code (or X-Tenant-Id),
  validates tenant exists + active, sets Tenancy::current(). Falls
  back to authenticated user's tenant_id when header missing.
  Registered globally on the api group.
- Login + register now require an active tenant (super-admin
  bypasses). Cross-tenant credential reuse is rejected with a
  403 + clear message.
- super_admin role added to RoleSeeder + users.role enum.
- Public GET /api/v1/tenants/lookup?code= — no auth, returns tenant
  details for the pre-login screen.

Seeders:
- SuperAdminSeeder seeds super@verde.local (tenant_id = null).
- SanPascualTenantSeeder seeds Region IV-A → Batangas → San Pascual
  municipality → sample Poblacion barangay → Tenant row with code
  SAN-PASCUAL-BAT, then backfills every existing tenant-aware row
  (13 users / 2 households / 5 DOPs / 1 dumpsite / 3 stores) so
  the dev environment keeps working end-to-end.
- Wired into DatabaseSeeder so migrate:fresh --seed bootstraps
  cleanly.

Customer-web:
- New /tenant page — text input, calls public lookup, confirms with
  resolved tenant card, stores code + name in cookies (1 year).
  "Pilot users: SAN-PASCUAL-BAT" hint as a clickable shortcut.
- /login + /register now redirect to /tenant?next= when no cookie,
  show a verde "signing in to <LGU>" pill with a Switch link,
  delegate the actual form to client components.
- /api/tenant route — POST sets cookie, DELETE clears.
- apiServer auto-attaches X-Tenant-Code on every API call when the
  cookie is present.
- Tenant cookies are non-httpOnly so the client can echo them; the
  session token stays httpOnly.

Build: 23 routes (added /tenant), 196 backend tests still pass.

Co-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com>
2026-05-01 22:38:35 +08:00

90 lines
2.3 KiB
PHP

<?php
namespace App\Models;
use App\Models\Concerns\HasProfileVerification;
use App\Tenancy\HasTenant;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Relations\BelongsTo;
use Illuminate\Database\Eloquent\Relations\HasMany;
use Illuminate\Database\Eloquent\SoftDeletes;
use Illuminate\Support\Str;
use MatanYadaev\EloquentSpatial\Objects\Point;
use MatanYadaev\EloquentSpatial\Traits\HasSpatial;
use Spatie\Activitylog\LogOptions;
use Spatie\Activitylog\Traits\LogsActivity;
class Household extends Model
{
use HasFactory, HasProfileVerification, HasSpatial, HasTenant, LogsActivity, SoftDeletes;
protected $fillable = [
'uuid',
'tenant_id',
'head_user_id',
'barangay_id',
'address_line',
'coordinates',
'household_size',
'proof_of_residency_path',
'assigned_drop_off_point_id',
'verification_status',
'verified_at',
'verified_by_admin_id',
'rejection_reason',
];
protected function casts(): array
{
return [
'coordinates' => Point::class,
'verified_at' => 'datetime',
'household_size' => 'integer',
];
}
public function getRouteKeyName(): string
{
return 'uuid';
}
public function getActivitylogOptions(): LogOptions
{
return LogOptions::defaults()
->logOnly(['verification_status', 'verified_by_admin_id', 'rejection_reason', 'assigned_drop_off_point_id'])
->logOnlyDirty()
->dontSubmitEmptyLogs()
->useLogName('household');
}
protected static function booted(): void
{
static::creating(function (self $h): void {
if (empty($h->uuid)) {
$h->uuid = (string) Str::uuid();
}
});
}
public function head(): BelongsTo
{
return $this->belongsTo(User::class, 'head_user_id');
}
public function barangay(): BelongsTo
{
return $this->belongsTo(Barangay::class);
}
public function members(): HasMany
{
return $this->hasMany(HouseholdMember::class);
}
public function assignedDropOffPoint(): BelongsTo
{
return $this->belongsTo(DropOffPoint::class, 'assigned_drop_off_point_id');
}
}