# Add MINI LICENSE EXP to the tenant roster and retention table

## PortfolioService — inject the licence service

    public function __construct(
        protected CurrentOrganization $current,
        protected \App\Locations\Services\LocationScope $scope,
        protected \App\Analytics\Services\TenantLicenseService $licenses,
    ) {}

## tenantRoster() — attach licence details

Before the map, build the lookup once:

    $licenses = $this->licenses->forTenants($this->tenants());

then inside the returned array add:

    'license_number' => $licenses[(int) ($l['renter_id'] ?? 0)]['license_number'] ?? null,
    'license_expiration' => $licenses[(int) ($l['renter_id'] ?? 0)]['expiration'] ?? null,
    'license_expired' => $licenses[(int) ($l['renter_id'] ?? 0)]['expired'] ?? false,

## retention() — same, so the Retention table gains the column

    $licenses = $this->licenses->forTenants($this->tenants());

    'license_number' => $licenses[(int) ($l['renter_id'] ?? 0)]['license_number'] ?? null,
    'license_expiration' => $licenses[(int) ($l['renter_id'] ?? 0)]['expiration'] ?? null,
    'license_expired' => $licenses[(int) ($l['renter_id'] ?? 0)]['expired'] ?? false,

## tenants.tsx — column + filter

Add to the type:
    license_number: string | null; license_expiration: string | null; license_expired: boolean;

Add an "Expired License" checkbox beside "Delinquent only":

    const [expiredOnly, setExpiredOnly] = useState(false);
    ...
    if (expiredOnly && ! t.license_expired) return false;      // inside the filter

    <label className="flex items-center gap-1.5 text-sm text-muted-foreground">
        <input type="checkbox" checked={expiredOnly} onChange={(e) => setExpiredOnly(e.target.checked)} />
        Expired License
    </label>

Add the column header and cell:

    <th className="px-4 py-2.5 font-medium">Mini License Exp</th>

    <td className={`px-4 py-2.5 text-xs ${t.license_expired ? 'font-medium text-destructive' : 'text-muted-foreground'}`}>
        {t.license_expiration ?? '—'}
        {t.license_expired && ' (expired)'}
        {t.license_number && <span className="ml-1 opacity-60">#{t.license_number}</span>}
    </td>

Do the same in retention.tsx for the Retention table.