mix phoenix_kit_catalogue. audit_supplier_refs
(PhoenixKitCatalogue v0.12.3)
Copy Markdown
View Source
Reports junction rows in phoenix_kit_cat_item_supplier_info whose
supplier_uuid does not resolve in the expected source.
For source = 'local', resolves against phoenix_kit_cat_suppliers.
For source = 'crm_company' or 'crm_contact', skips with a note when
the CRM module is not available.
Also reports cat_suppliers rows that have a non-null crm_company_uuid
(informational — these are local suppliers linked to a CRM company).
This task is read-only and makes no changes to the database.
Usage
mix phoenix_kit_catalogue.audit_supplier_refs