contact/admin, branch master

Introduce ContactPerson and ContactBusiness subclasses

2026-06-11T18:26:25Z

Splits the Contact class into ContactPerson (content_type_guid='contactperson') and ContactBusiness (content_type_guid='contactbusiness'), each using 'contact' as the shared package-level xref schema. Replaces the $isPerson/$00 xref hack with proper class identity via instanceof. - ContactPerson.php, ContactBusiness.php: new subclasses - Contact.php: loadXrefTypeList() reads type tags directly from liberty_xref; getAvailableTypeItems() for edit form (schema-driven with pre-upgrade fallback); getDisplayUrl() now points to display_contact.php - Type item codes: P01/P02 (person), B01-B04 (business, B01=Service new) - list_people.php, list_businesses.php: separate list pages per type - list_contacts.php: combined display-layer merge of both types - 5.0.3.php: upgrade script migrating existing data to new content types and codes - Templates: isPerson flag from instanceof; horizontal type checkboxes; list.tpl accepts $listTitle; menu adds People/Businesses entries Co-Authored-By: Claude Sonnet 4.6

schema: tighten account group role_id to 3; add SAGEID; add export_contacts.php

2026-06-06T14:56:04Z

account xref_group and items: role_id 4 → 3 (Registered, not Editors). ACC_TO, VAT_NO: same role_id correction. ACCNO replaced with SAGEID (SAGE Account Reference). export_contacts.php: new CSV export (one row per contact, phones/emails/address). Co-Authored-By: Claude Sonnet 4.6

Rationalise contact permissions

2026-06-05T16:34:39Z

p_contact_view: registered; p_contact_create/update: editors; p_contact_expunge/admin: admin — expunge gates all delete buttons. Co-Authored-By: Claude Sonnet 4.6

Tidy contact type xref_item defaults: $05 = MERG Kit Elf, drop $06-$10

2026-06-02T13:24:04Z

$06 through $10 (Record Artist, Cartographer, PHX Client etc.) removed from schema defaults — already removed from live database. Co-Authored-By: Claude Sonnet 4.6

Use DEFTIMESTAMP for contact_address.last_update_date

2026-06-02T11:40:56Z

DEFTIMESTAMP uses sysTimeStamp (now LOCALTIMESTAMP for Firebird 4+) rather than DEFAULT LOCALTIMESTAMP which adodb-datadict was mangling into a literal time value via DBTimeStamp(), causing Firebird SQLSTATE 22009 on INSERT. Co-Authored-By: Claude Sonnet 4.6

Fix Firebird/PDO compatibility and strip Cotswold Security remnants

2026-05-27T15:27:59Z

- Fix LOCALTIMESTAMP default in contact_address (CURRENT_TIMESTAMP caused timezone error with Firebird 4+ / PDO session having no timezone set) - Add xref_id sequence call to all liberty_xref INSERTs in Contact::store() - Add CONTACT_PKG_CLASS_PATH so getLibertyObject resolves Contact class - Fix LibertyXref date fields: format Unix timestamps as Y-m-d H:i:s before INSERT; use null instead of empty string for nullable TIMESTAMP columns - Remove Contract/Key Number column from list and edit templates - Remove find_key search box and getContractList() method - Remove alarm and council xref groups and items from schema seed - Add SCREF (Stock Source Reference) to links xref group seed - Archive and git-remove Cotswold-specific templates and list_contracts.php - Clean up contact_header: remove xkey prefix, restore plain title display - Browser title now shows contact name instead of generic "Contact Information" Co-Authored-By: Claude Sonnet 4.6

Migrate contact xref to liberty_xref tables; add address_postcode to schema

2026-05-26T13:51:23Z

5.0.1 upgrade migrates contact_xref_type/source/xref data into liberty_xref_group/item/xref with content_type_guid='contact'. 5.0.2 upgrade drops the old contact_xref* tables. schema_inc.php updated for fresh installs: - Removes contact_xref, contact_xref_source, contact_xref_type tables - Adds address_postcode table (UK postcode lookup, LEFT JOIN'd in queries) - Defaults now INSERT into liberty_xref_group and liberty_xref_item directly - dependencies => 'liberty' ensures correct install ordering PHP and templates: source→item, xref_type→group rename throughout. Co-Authored-By: Claude Sonnet 4.6

Redirect contact xref admin pages to liberty equivalents

2026-05-22T14:47:25Z

admin_contact_type.php and admin_xref_types.php now redirect to liberty/admin/admin_xref_groups.php and admin_xref_sources.php respectively, with content_type_guid=contact pre-set. Co-Authored-By: Claude Sonnet 4.6

Fix 5.0.2 DROPTABLE/DROPSEQUENCE array nesting

2026-05-22T13:37:35Z

Extra level of nesting caused PHP to pass an array as the table name, producing 'DROP TABLE ARRAY'. applyUpgrade iterates two levels itself. Co-Authored-By: Claude Sonnet 4.6

Drop old contact_xref tables; seed liberty_xref_type/source on fresh install

2026-05-22T13:35:02Z

5.0.2 upgrade drops contact_xref, contact_xref_source, contact_xref_type and contact_xref_seq now that data lives in liberty_xref tables. schema_inc.php updated: old xref table registrations removed, registerSchemaDefault rewritten to INSERT into liberty_xref_type/source with content_type_guid='contact' and text xref_type keys ('type','contact','links','alarm','council','account'). Co-Authored-By: Claude Sonnet 4.6