From fac01186b3b34ea4cdf20a2f8cea12646cd319d6 Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Mon, 24 Jan 2022 19:35:59 +0100 Subject: [PATCH] Add and Manage Customers, Suppliers: contact persons where not removed when deleting customer/supplier. Fixed. --- includes/db/crm_contacts_db.inc | 2 +- purchasing/includes/db/suppliers_db.inc | 4 ++++ 2 files changed, 5 insertions(+), 1 deletion(-) diff --git a/includes/db/crm_contacts_db.inc b/includes/db/crm_contacts_db.inc index 98862b73..b9a7eda8 100644 --- a/includes/db/crm_contacts_db.inc +++ b/includes/db/crm_contacts_db.inc @@ -175,9 +175,9 @@ function update_person_contacts($id, $cat_ids, $entity_id=null, $type=null) function delete_entity_contacts($class, $entity) { - delete_crm_contacts(null, $class, $entity); // cleanup $res = get_crm_persons($class, null, $entity, null, true); + delete_crm_contacts(null, $class, $entity); while($person = db_fetch($res)) { $rels = get_person_contacts($person['id']); if (count($rels) == 0) { diff --git a/purchasing/includes/db/suppliers_db.inc b/purchasing/includes/db/suppliers_db.inc index dff68c12..c3a16d21 100644 --- a/purchasing/includes/db/suppliers_db.inc +++ b/purchasing/includes/db/suppliers_db.inc @@ -73,8 +73,12 @@ function update_supplier($supplier_id, $supp_name, $supp_ref, $address, $supp_ad function delete_supplier($supplier_id) { + begin_transaction(); + delete_entity_contacts('supplier', $supplier_id); $sql="DELETE FROM ".TB_PREF."suppliers WHERE supplier_id=".db_escape($supplier_id); + db_query($sql,"check failed"); + commit_transaction(); } function get_supplier_details($supplier_id, $to=null, $all=true) -- 2.30.2