From 8e6b771eeb7cd0efce71eac0f599d2850971d2a4 Mon Sep 17 00:00:00 2001 From: Pratik Joshi Date: Sat, 15 Mar 2014 12:41:59 +0530 Subject: [PATCH] CRM-13973-qa : a minor fix for - no changes in selection page and on save causes DB Error --- CRM/Event/BAO/Participant.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/CRM/Event/BAO/Participant.php b/CRM/Event/BAO/Participant.php index a0be4bbda6..fd2768b829 100644 --- a/CRM/Event/BAO/Participant.php +++ b/CRM/Event/BAO/Participant.php @@ -1793,11 +1793,12 @@ WHERE cpf.price_set_id = %1 AND cpfv.label LIKE %2"; // check through the submitted items if the previousItem exists, // if found in submitted items, do not use it for new item creations if (in_array($previousLineItem['price_field_value_id'], $submittedFieldValueIds)) { + // if submitted line items are existing don't fire INSERT query + unset($insertLines[$previousLineItem['price_field_value_id']]); // for updating the line items i.e. use-case - once deselect-option selecting again if ($previousLineItem['qty'] == 0) { $updateLines[$previousLineItem['price_field_value_id']]['qty'] = $submittedLineItems[$previousLineItem['price_field_value_id']]['qty']; $updateLines[$previousLineItem['price_field_value_id']]['line_total'] = $submittedLineItems[$previousLineItem['price_field_value_id']]['line_total']; - unset($insertLines[$previousLineItem['price_field_value_id']]); } } } -- 2.25.1