Author Topic: Displaying event_id in Event Participant Report (Read 1310 times)

haydo · February 23, 2010, 06:21:28 pm

Hi all,

Trying to do something which I thought would be fairly simple. Displaying the event_id in Event Participant Report, as well as keeping the display of the event name too.

I noticed it gets the event_id in the query but then populates it with the event name (aka title) in PseudoContent.php. At the moment I can get one or the other but need both? Anybody got any quick ideas for me to solve this problem?

Many thanks

lcdweb · February 23, 2010, 06:30:05 pm

with debug on, add: &smartyDebug=1
to the url
that will open a window with the smarty variables available to the template. then you can insert the variable where you want it in the tpl file

haydo · February 23, 2010, 06:51:17 pm

Thanks for the quick reply lcdweb

I don't have a problem finding where to put it, i have a problem of getting the id and event name both displaying as the event id is overridden to display the event name. I can change it to display the id, but therefore can't show the title. If that doesn't make sense I can display the code which does this.

Thanks again.

lcdweb · February 23, 2010, 07:19:39 pm

if the variable is being overridden in the template, you could use the smarty assign function to assign the id to a different variable name before it's overridden (http://www.smarty.net/manual/en/language.custom.functions.php#language.function.assign)

but i'd be surprised if the event id was not available in one of the arrays passed to the tpl. did you look at the smarty debug window?

Deepak Srivastava · February 23, 2010, 09:48:56 pm

Another way would be changing the _columns array so that query makes it available in an another column. This 'll also make it part of "display columns".

Code: [Select]

--- CRM/Report/Form/Event/ParticipantListing.php	(revision 26358)
+++ CRM/Report/Form/Event/ParticipantListing.php	(working copy)
@@ -88,6 +88,10 @@
                          'fields'  =>
                          array( 'participant_id'            => array( 'title' => 'Participant ID' ),
 
+                                'e_id'                      => array( 'title' => 'Event ID',
+                                                                      'name'  => 'event_id',
+                                                                      'default' => true,
+                                                                      'type'    =>  CRM_Utils_Type::T_INT ),
                                 'event_id'                  => array( 'default' => true,
                                                                       'type'    =>  CRM_Utils_Type::T_STRING ),
                                 'status_id'                 => array( 'title'   => ts('Status'),

lcdweb · February 23, 2010, 10:18:44 pm

haydo --
i read your original post too fast. i didn't notice you were working on a report -- my response was relevant to event pages, but not to reports. sorry about that. Deepak has the direction you'll need to go in.

haydo · February 24, 2010, 11:04:31 am

Thank you to you both Deepak and lcdweb.

That was exactly what i was doing but missing the 'name' field in the array. Silly oversight by me! Cheers guys

CiviCRM Community Forums (archive)

News:

Author Topic: Displaying event_id in Event Participant Report (Read 1310 times)

haydo

Displaying event_id in Event Participant Report

lcdweb

Re: Displaying event_id in Event Participant Report

haydo

Re: Displaying event_id in Event Participant Report

lcdweb

Re: Displaying event_id in Event Participant Report

Deepak Srivastava

Re: Displaying event_id in Event Participant Report

lcdweb

Re: Displaying event_id in Event Participant Report

haydo

Re: Displaying event_id in Event Participant Report