[Simon Groves]

Hi
Just wondering if I could please get some assistance on this?
Thanks

[Simon Groves]

Ok, I’ve recoded the your-theme/tribe-events/attendees-list.php template to show the guest names not just who purchased the ticket. Here’s my code:

<div class='tribe-attendees-list-container'>
	<h2 class="tribe-attendees-list-title"><?php esc_html_e( 'Who\'s Attending', 'event-tickets-plus' ) ?></h2>
	<p><?php echo esc_html( sprintf( _n( 'One person is attending %2$s', '%d people are attending %s', $attendees_total, 'event-tickets-plus' ), $attendees_total, get_the_title( $event->ID ) ) ); ?></p>

	<table id="example" class="display" cellspacing="0" width="100%">
	<thead>
		<tr>
			<th>&nbsp;</th>
			<th>Member</th>
			<th>Company</th>			
			<th>Guest</th>
		</tr>
	</thead>
	<tfoot>
		<tr>
			<th>&nbsp;</th>
			<th>Member</th>
			<th>Company</th>			
			<th>Guest</th>
		</tr>
	</tfoot>	
	<tbody>
	<?php foreach ( $attendees_list as $attendee_id => $avatar_html ) { ?>
		<tr>
			<?php
			$attendee_name = '';
			foreach ( $attendees as $key => $attendee_obj  ) {
							
				if ( isset( $attendees[ $key ]['attendee_id'] ) && $attendee_id == $attendees[ $key ]['attendee_id'] ) {
					$attendee_name = $attendees[ $key ]['purchaser_name'];
				}
			} 
			?>		
	
			<td><?php echo $avatar_html; ?></td>
			<?php if ( ! empty( $attendee_name ) ) : ?>
				<td><?php echo $attendee_name; ?></td>
			<?php endif ?>					
		
			<?php				
			$meta = get_post_meta($attendee_id);
			$tribe_tickets_meta = $meta['_tribe_tickets_meta'];
						
			$get_tribe_meta = unserialize($tribe_tickets_meta[0]);
			if ( isset($get_tribe_meta['company']) ):
				echo '<td>'.$get_tribe_meta['company'].'</td>';
			else:
				echo '<td>&nbsp;</td>';
			endif;
			
			if ( isset($get_tribe_meta['name']) ):
				echo '<td>'.$get_tribe_meta['name'].'</td>';
			else:
				echo '<td>&nbsp;</td>';			
			endif;
			?>
		</tr>
	<?php } ?>		
	<tbody>
	</table>
</div>

I’ve included a jquery datatable as some events may have over a 100 people going, so this keeps the page nice and clean, plus allows people to search/filter those attending

For my own needs, I’ve setup some fields via the Ticket Fieldset now available, like so:
– Name
– Email Address
– Company
– Telephone

I only want to include particular fields, so made use of the custom field ‘_tribe_tickets_meta’ that stores the info. You could use:
echo 'Tribe Meta: ' . $tribe_tickets_meta[0] . '<br/>';
This will show the fields you’ve created so you can update the above as you need to. You then need to include the necessary CDN calls for the data table as per the above link

I hope this will help others

[Simon Groves]

Thanks George,

Will need to alter this as it doesn’t show the Guest details, only the purchaser details – somewhat defeats the object of showing who’s attending 🙁

[Simon Groves]

Solved!

Just goes in your-theme/tribe-events/attendees-list.php

Seems somewhat counter-intuitive given the rest of the docs but hey ho!

[Simon Groves]

Please ignore the above

[Simon Groves]

Thanks George, that’s much appreciated!

[Simon Groves]

Hi George,

Apologies for the delay, I can confirm on the 14th Aug we received a refund of $60USD which took the WooTickets licence back from Business to Personal

However, in doing so, this has disabled the licence we had. We should still have a valid licence.

Please can this be reinstated as we technically have paid for a single/personal licence and still have 6 months left

Thanks

[Simon Groves]

Hi George,

Thanks for the reply.

It works but I can’t update the plugin as it says the licence has expired, yet I know the licence is valid for 12 months and as it was purchased in April should still be valid!?

It’s WooTickets that’s saying has expired but should be valid

Does that help?

[Simon Groves]

Thanks Cliff,

If I’m totally honest, I don’t feel leaving the message is a viable solution. Now I’ve seen i’m not the only one makes me think this issue needs to be addressed. Like Kirsty, the link within the text takes me to a page about not having suitable permissions, so I think there is an issue there too

I guess it’s over to you guys for a solution please

[Simon Groves]

Thanks for the reply but sadly deleting the page means people can’t access the page through the navigation

Unfortunately, that doesn’t appear to resolve the issue for me

[Simon Groves]

Hi,

I’ve managed to finally resolve the issue.

It seemed a line of code in the functions file called in another jquery library, this was causing the issue

I’ve removed this and viola! It now works

Thanks

[Simon Groves]

Thanks Nico.

I’ve totally removed all scripts from our theme but still have the issue 🙁

[Simon Groves]

Thanks Nico

From the 2 errors I can see:

Uncaught TypeError: $(...).on is not a function - /plugins/the-events-calendar/vendor/bootstrap-datepicker/js/bootstrap-datepicker.min.js?ver=3.2

Uncaught TypeError: c(...).on is not a function - /plugins/the-events-calendar/src/resources/js/tribe-events.min.js?ver=3.11.2

They both seem to relate to the plugin rather than the theme code?

Any help is much appreciated though!
Thanks

[Simon Groves]

Hi George,

Thanks for the reply. Yes I think we’re talking at cross purposes!

When you go to WP-Admin > Events > Event Attendee List

You can Export the list of event attendees out as a CSV file.

What I’d like to do, is simply include the Guest Names for the tickets. I’ve outlined how I did that here: https://theeventscalendar.com/support/forums/topic/attendee-list-add-guest-name-column/

It “should” be simple but I can’t work out how to add the custom query into the existing code. Which from my understanding is lib/tickets/tribe-tickets-pro.php

Hunting around, I can see so many people want this too, so not sure why it was never default functionality (but that’s another matter).

So any help on this would be very much appreciated. I’ve even got the code to get the Guest Names, I just need to include the extra column into the existing Attendee List CSV file.

I even tried altering
$export_columns = array_diff_key( $columns, $hidden ); to $export_columns = array_diff_key( $columns, $hidden, $guests );

Altering:

$columns = $this->attendees_table->get_columns();
$hidden  = get_hidden_columns( $this->attendees_page );

To:

$columns = $this->attendees_table->get_columns();
$hidden  = get_hidden_columns( $this->attendees_page );
$guests = 'Guest Names';

But it’s then how to add the additional info

Does that help/clarify what I’m trying to achieve?

Thanks

[Simon Groves]

Thanks George,

Surely if we use another plugin to export the information, even if it does included the new meta fields, it won’t be event specific like when you click the Attendee List export?

If you could help with the code, I’d sure as heck appreciate it.

I’ve got the code working for the new guest column which I posted here: https://theeventscalendar.com/support/forums/topic/attendee-list-add-guest-name-column/

I just need to know how to include this in the email and CSV code. Is this something you can help with?

Thanks

[Author]

Posts