Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-5313

Migrate the Line Items to store participant id instead of contribution id

    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.

        Attachments

          Activity

            People

            • Assignee:
              rajan Rajan P Mayekar
              Reporter:
              yashodha Yashodha Chaku
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: