Replace entity relationships between products and suppliers with an entity link

Description

The product archetypes product.medication, and product.merchandise may each have entityRelationship.productSupplier relationships to party.supplierperson and party.supplierOrganisation archetypes.
This is a bidirectional relationship, so a party.supplier* instance may have many products associated with it.
This affects performance on databases with thousands of products.

A better approach would be to replace the entityRelationship.productSupplier with an EntityLink relationship. This would be from the product to the supplier.

This would require the following changes:

  • replace entityRelationship.productSupplier with entityLink.productSupplier

  • update product.medication, product.merchandise to use entityLink.productSupplier

  • remove products node from

    • party.supplierperson

    • party.supplierOrganisation

  • classes:

    • DeliveryProcessor

    • ProductRules

    • SupplierRules

    • ProductSupplier

    • OrderGenerator

  • report changes:

    • ./reports/Reporting/Reports/Product/A4/Stock Reorder Report.jrxml

  • database migration

Users would need to manually install the reports, and update any of their customised reports.

Environment

None

Status

Assignee

Tim Anderson

Reporter

Tim Anderson

Labels

None

Fix versions

Affects versions

1.7

Priority

Minor
Configure