CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviContribute (Moderator: Donald Lobo) »
  • what was paid for what: pricesets and contributions/events
Pages: [1]

Author Topic: what was paid for what: pricesets and contributions/events  (Read 521 times)

usr238496

  • I post occasionally
  • **
  • Posts: 85
  • Karma: 0
  • CiviCRM version: latest
  • CMS version: joomla2.5
  • PHP version: 5 something
what was paid for what: pricesets and contributions/events
July 10, 2012, 09:20:32 am
For my event I am using a priceset.

The price set is set as
radio: required: Ticket price = $100
textbox:option:value=1: Donation

Users, when buying a ticket are allowed to make a donation to the cause of the event.

However, I need to be able to split these amounts up after the payment has been made.

I want to allow the payment to be made as single contribution, to make it easier for the user and not have them make two separate payments.

After the payment as been cleared, I want to find the contribution record and split it based on the ticket amount and the donation amount.

However, one I check the contribution record, there is nothing logged saying what was paid for each price set field.

This is a problem as the ticket price can have a coupon applied via some custom coding and can have an early bird discount applied. The early bird purchases are logged and once a set number have been sold, the end_date of the discount record is set to the past.

The problem will occur that if an IPN fails and the contribution has to be split at a later date, if the early bird date has been reset, there is not going to be a way to find out, what was paid for the ticket / donation.


I am hoping that someone will know of a db record that does infact record the price set payment information, so I can pull this easily.

If not, the only way I can think of is to create a mapping table, and when the "continue to paypal" button is clicked and all the db records are written, I can hook into the civicrm_post(...) hook and map the contribution ID to a table logging the amounts of the ticket / donation.

Unless there is a better way?

You did not answer the verification questions correctly - sigh

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: what was paid for what: pricesets and contributions/events
July 10, 2012, 11:48:15 am

check the table: civicirm_line_item where each entry is individually recorded

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

usr238496

  • I post occasionally
  • **
  • Posts: 85
  • Karma: 0
  • CiviCRM version: latest
  • CMS version: joomla2.5
  • PHP version: 5 something
Re: what was paid for what: pricesets and contributions/events
July 10, 2012, 02:21:26 pm
Thanks Donald, I have just come back to answer the question myself as I found everything I wanted under the Event > Participant screen which then points to what you say.



You did not answer the verification questions correctly - sigh

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviContribute (Moderator: Donald Lobo) »
  • what was paid for what: pricesets and contributions/events

This forum was archived on 2017-11-26.