CiviCRM Community Forums (archive)

2) reporting on $$$ received from each event. I have concluded that there is no link between the events & contributions so this isn't possible . This is a big limitation for us but I imagine we may have to go without for some time

Take a look at this

http://wiki.civicrm.org/confluence/display/CRMDOC/events+aggregate+page (you have to click on the attachments tab to get the code.

It's what I am using to get some of the functionality referred to.

I've attached a screen shot. It has some limitations - some of which I identified in the post & some of which I've hit since then - but it is going a fair way towards providing what I need.

NB Dave defines 'quickly' and 'basic' differently to how I do...

Hi Eileen - We've been working on the example you posted to the wiki to get it closer to what you ideally want. I've got a checkbox for Event Type implemented, and some cleanup. We're seeing if we can also add in a Totals row - which I suspect would be good for you and would also be a good example for others. Not sure if we'll get that in - but will post back here and upload the updated files to the wiki in the next day or so.

Hi there,

Since posting my original code I had added in another check box to that search:

"show participants"

When this block is ticked the group by / having clause changes so that individual contributions are listed rather than the aggregate.

I re-added it to Dave's improved version of my original search as I find this useful - it's cludgey though as the 'participant name' column shows up whether or not the participants are listed.

I've attached my version of EventAggregate.php but be-warned - I took Dave's nice clean code and made it yucky again!

Eileen - we're in heavy 2.1 QA mode now - but I'll try to find some time for this maybe next week. I'm assuming the version attached to your last post is your latest version ?

Thanks for that Xavier. The search I'm using gives totals for the events as well which is the main point of it - I'm please to see it has made it onto the sandbox. http://sandbox.civicrm.org/civicrm/contact/search/custom?csid=7&reset=1. The price sets search you are referring to is pretty cool too but I did manage to screw it up on the sandbox. I will play a bit more & post to the beta's thread.

Dave, my latest version is attached. I hacked yours to do something that I find invaluable which is allow me to see the list of participants OR the aggregate. I have a feeling that there is something wrong with the total I got when testing on the sandbox but without this option it's hard to work through it and decide. Other tweaks I made more recently are to make participant status in 1 or 2 ( registered or attended) and I changed the criteria to civicrm_contribution.payment_instrument_id =1 (it was not null).

Of course that means I've made your code ugly again - sigh. Also, I haven't figured out how to make the participant column disappear when not required (not a biggie).

I love that there is a link to the collection of custom searches in the new version. An automated process for downloading and installing community contributed ones would really top it off (like joomla components installs sort of thing). I'm not convinced that the location of the custom searches in the sandbox is right - under find contacts - because most of the searches are not contacts related. I would argue to rename 'find contacts' to searches and put both find contacts and customised searches and other searches from all over civicrm under that (e.g. civiContribute).

ps. really appreciate the effort going on with the new version and I'm trying to find some time (when mr 2 and mr 2 months are asleep) to have a play and help with QA