Add SMC as a jurisdiction in Doorway

[sarahlazarich]

We need to add San Mateo as a listing in Doorway, so that Property Managers can create listings there once the site is transitioned.

Notes:

• Let's make sure that this has no affect on the existing SMC site or the Doorway script that pulls listings in from HBA.

AC:

• SMC is added as a jurisdiction in Doorway.

[ludtkemorgan]

San Mateo has been added as a jurisdiction to Doorway staging and all admins have been given access using the following commands:

// Create new jurisdiction
INSERT INTO jurisdictions (
    name, 
    created_at,
    updated_at,
notifications_sign_up_url, 
partner_terms, public_url, 
email_from_address, 
rental_assistance_default, 
enable_partner_settings, 
enable_accessibility_features,
enable_utilities_included, 
enable_geocoding_preferences, 
listing_approval_permission, 
languages, 
enable_listing_opportunity, 
allow_single_use_code_login, 
enable_partner_demographics, 
enable_geocoding_radius_method)
VALUES (
    'San Mateo', 
    '2024-06-25 10:05:45.028',
    '2024-06-25 10:05:45.028',
'https://public.govdelivery.com/accounts/CAMTC/signup/36832', 
'Please review terms here: https://mtc.ca.gov/doorway-housing-portal-terms-use', 
'https://staging.housingbayarea.mtc.ca.gov',    
'no-reply@housingbayarea.org',  
'Section 8, including Housing Choice Vouchers and other recognized rental assistance programs, will be considered for this property. In th
e case of a valid rental subsidy, the required minimum income will be based on the portion of the rent that the tenant pays after use of the subsidy.', 
true, 
false, 
false,  
false,  
'{admin}',  
'{en}', 
true,   
false,  
true,   
false)

// Connect user accounts to new jurisdiction
INSERT INTO "_JurisdictionsToUserAccounts" ("A", "B")
SELECT j.id, ua.id
from jurisdictions j, user_accounts ua, user_roles ur
where j.name = 'San Mateo'
AND ua.id = ur.user_id
AND ur.is_admin = TRUE

[sarahlazarich]

not running this in prod until it's fully tested in staging Needs to be put in before the listing migration

[ludtkemorgan]

This is on hold for a production release until right before we run the listing migration as requested by the Doorway team