diff options
| author | Lester Caine <lester@lsces.co.uk> | 2026-06-06 15:56:04 +0100 |
|---|---|---|
| committer | Lester Caine <lester@lsces.co.uk> | 2026-06-06 15:56:04 +0100 |
| commit | 0c9654cefb83ec95c76d849e477854c6b734cd98 (patch) | |
| tree | 44d5fda15dcad21d715c543b300a8d177b7066e4 /admin | |
| parent | 4425c6b4acd016085c537631c4738ca2fca90eaf (diff) | |
| download | contact-0c9654cefb83ec95c76d849e477854c6b734cd98.tar.gz contact-0c9654cefb83ec95c76d849e477854c6b734cd98.tar.bz2 contact-0c9654cefb83ec95c76d849e477854c6b734cd98.zip | |
schema: tighten account group role_id to 3; add SAGEID; add export_contacts.php
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 <noreply@anthropic.com>
Diffstat (limited to 'admin')
| -rwxr-xr-x | admin/schema_inc.php | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/admin/schema_inc.php b/admin/schema_inc.php index bc06b3b..50fc188 100755 --- a/admin/schema_inc.php +++ b/admin/schema_inc.php @@ -83,7 +83,7 @@ $gBitInstaller->registerSchemaDefault( CONTACT_PKG_NAME, [ "INSERT INTO `" . BIT_DB_PREFIX . "liberty_xref_group` (`x_group`,`content_type_guid`,`title`,`sort_order`,`role_id`,`type_href`) VALUES ('type', 'contact','Contact Type List', 0,3,'')", "INSERT INTO `" . BIT_DB_PREFIX . "liberty_xref_group` (`x_group`,`content_type_guid`,`title`,`sort_order`,`role_id`,`type_href`) VALUES ('contact','contact','General Contact Details', 1,3,'')", "INSERT INTO `" . BIT_DB_PREFIX . "liberty_xref_group` (`x_group`,`content_type_guid`,`title`,`sort_order`,`role_id`,`type_href`) VALUES ('links', 'contact','Linked Contact Items', 2,3,'')", - "INSERT INTO `" . BIT_DB_PREFIX . "liberty_xref_group` (`x_group`,`content_type_guid`,`title`,`sort_order`,`role_id`,`type_href`) VALUES ('account','contact','Account Details', 3,4,'')", + "INSERT INTO `" . BIT_DB_PREFIX . "liberty_xref_group` (`x_group`,`content_type_guid`,`title`,`sort_order`,`role_id`,`type_href`) VALUES ('account','contact','Account Details', 3,3,'')", // --- liberty_xref_item (formerly contact_xref_source) --- // group: type @@ -108,9 +108,9 @@ $gBitInstaller->registerSchemaDefault( CONTACT_PKG_NAME, [ // group: links "INSERT INTO `" . BIT_DB_PREFIX . "liberty_xref_item` (`item`,`content_type_guid`,`x_group`,`cross_ref_title`,`multiple`,`role_id`,`cross_ref_href`,`template`) VALUES ('SCREF','contact','links','Stock Source Reference',0,3,'../stock/?content_id=','text')", // group: account - "INSERT INTO `" . BIT_DB_PREFIX . "liberty_xref_item` (`item`,`content_type_guid`,`x_group`,`cross_ref_title`,`multiple`,`role_id`,`cross_ref_href`,`template`) VALUES ('ACC_TO','contact','account','Account Turnover', 0,3,'../vat/?vat=', 'text')", - "INSERT INTO `" . BIT_DB_PREFIX . "liberty_xref_item` (`item`,`content_type_guid`,`x_group`,`cross_ref_title`,`multiple`,`role_id`,`cross_ref_href`,`template`) VALUES ('SAGEID','contact','account','SAGE Account Reference', 0,3,'''sage''', 'text')", - "INSERT INTO `" . BIT_DB_PREFIX . "liberty_xref_item` (`item`,`content_type_guid`,`x_group`,`cross_ref_title`,`multiple`,`role_id`,`cross_ref_href`,`template`) VALUES ('VAT_NO','contact','account','VAT Number', 0,3,'../vat/?vat=', 'text')", + "INSERT INTO `" . BIT_DB_PREFIX . "liberty_xref_item` (`item`,`content_type_guid`,`x_group`,`cross_ref_title`,`multiple`,`role_id`,`cross_ref_href`,`template`) VALUES ('ACC_TO','contact','account','Account Turnover', 0,4,'../vat/?vat=', 'text')", + "INSERT INTO `" . BIT_DB_PREFIX . "liberty_xref_item` (`item`,`content_type_guid`,`x_group`,`cross_ref_title`,`multiple`,`role_id`,`cross_ref_href`,`template`) VALUES ('ACCNO','contact','links','Account Number', 0,3,'', 'text')", + "INSERT INTO `" . BIT_DB_PREFIX . "liberty_xref_item` (`item`,`content_type_guid`,`x_group`,`cross_ref_title`,`multiple`,`role_id`,`cross_ref_href`,`template`) VALUES ('VAT_NO','contact','account','VAT Number', 0,4,'../vat/?vat=', 'text')", ] ); |