Author Topic: Advice on getting the price of an event (Read 1616 times)

geilhufe · September 27, 2009, 08:44:19 pm

Warning: not a coder, I just modify sample code, run it, and when it breaks, scratch my head.

I want to see if anyone can point me in the right general direction and/or if there is any sample code around that would do this.

Problem:
I want to get the price of an event.

I know where I want to start: civicrm_event _id
I know where I want to end: the default price for that event (ignoring any complex price situations): civicrm_contribution_page default_amount_id

It doesn't look like I can get this from the API... it needs to been done in SQL. Correct?

Donald Lobo · September 28, 2009, 07:59:42 am

Code: [Select]

select v.value, v.is_default from civicrm_option_value v, civicrm_option_group g where v.option_group_id = g.id and g.name = 'civicrm_event.amount.1' order by v.is_default;

the option group name is always civicrm_event.amount.EVENT_ID

Note that amounts need not have a default value, hence i put it in the order by clause

lobo

geilhufe · September 28, 2009, 09:44:28 am

Thanks much. Will try to remember to post working code when the developer gets it actually functioning.

CiviCRM Community Forums (archive)

News:

Author Topic: Advice on getting the price of an event (Read 1616 times)

geilhufe

Advice on getting the price of an event

Donald Lobo

Re: Advice on getting the price of an event

geilhufe

Re: Advice on getting the price of an event