Details
-
Type: Improvement
-
Status: Done/Fixed
-
Priority: Major
-
Resolution: Fixed/Completed
-
Affects Version/s: 3.1
-
Fix Version/s: 3.1
-
Component/s: CiviContribute
-
Labels:None
Description
Currently we use civicrm_contribution.id to store price set info in line items.
With additional participants, we have multiple participants having different line items all stored in the lineitem table mapped to contribution that has been made by the primary participant. This results in erroneous display while showing lineitems as :
- primary participant (all line items including those of additional participant)
- additional participant (no lineitems at all)
Ditch this approach and store lineitems in a cleaner way as :
civicrm_participant.id -> civicrm_line_item.entity_id
instead going around with approach of having
civicrm_participant.id -> civicrm_participant_payment.contribution_id -> civicrm_line_item.entity_id
We need to fix the lineitems in current code and
migrate them to civicrm_participant.id from civicrm_contribution.id in upgrade by looking up in civicrm_participant_payment table.