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

Online event registration - incorrect or missing values in financial_item and financial_trxn tables, and fix notices

    Details

      Description

      Enable Dummy processor and configure sample event 1 (Fall Fundraiser) to use Dummy. Use online registration to register a participant. Then added Discount Fee set and repeated the online registration.

      1. Fix Notices on Thank-you page
      Notice: Undefined variable: initPoint in CRM_Event_Form_Registration_Confirm->postProcess() (line 755 of /Users/dgg/svn/crm_v4.3/CRM/Event/Form/Registration/Confirm.php).
      Warning: Division by zero in CRM_Event_Form_Registration_Confirm->postProcess() (line 755 of /Users/dgg/svn/crm_v4.3/CRM/Event/Form/Registration/Confirm.php).
      Notice: Undefined property: CRM_Price_BAO_LineItem::$int_name in CRM_Financial_BAO_FinancialItem::add() (line 107 of /Users/dgg/svn/crm_v4.3/CRM/Financial/BAO/FinancialItem.php).

      2. Financial Item inserts

      • This flow should create ONE financial_item row. Currently 2 rows are inserted (see financial_item.png screenshot). id 101 in the screenshot (2nd row) should not be created per Joe Murray.
      • For the registration w/ discounted fee, the financial_item.financial_account_id has a NULL value instead of expected value (4)
      • There's also corresponding extraneous row in civicrm_entity_financial_trxn table linking to the extraneous financial_item row.

      3. Financial Trxn inserts (both non-discount and discount registration)

      • total_amount is NULL, amount has been incorrectly written to Net Amount column
      • status_id is NULL, s/b id for completed
      • payment_processor_id is NULL, s/b id of Dummy processor

      4. Edit Participant - Event Fees table his wrong values (see edit_participant.png)

      • Paid column is blank and Owing column shows $100 (when I've actually paid the full fee already)
      • There is also an input field under the header "Amount of Current Payment". This should not be shown if Owing is 0 (i.e. event fee is fully paid).

        Attachments

        1. edit_participant.PNG
          72 kB
          David Greenberg
        2. entity_financial_trxn.PNG
          25 kB
          David Greenberg
        3. financial_item_discount.PNG
          24 kB
          David Greenberg
        4. financial_item .PNG
          31 kB
          David Greenberg
        5. financial_trxn.PNG
          33 kB
          David Greenberg

          Activity

            People

            • Assignee:
              joemurray Joe Murray
              Reporter:
              dgg David Greenberg
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: