Support

March 14, 2016 at 4:28 am

Hello,

In a front end account page template I display list of events of a user, and I add the list of attendees. Its almost working. I have a problem on status, the participant appears in each shortcode. Example

Liste de vos ateliers
Atelier Danse et Théâtre – Modifier
Confirmé
Jacques Jahnichen
En attente
Jacques Jahnichen
Annulé
Jacques Jahnichen
Refusé
Jacques Jahnichen

The code

<?php
$author_query = array(
'author' 		 => $current_user->ID,
'post_type'      => 'espresso_events',
'post_status' => 'publish, private',
'posts_per_page' => -1,
'caller_get_posts'=> 1
);
$author_posts = new WP_Query($author_query);

if ($author_posts->have_posts()) {
echo "<h4>Liste de vos ateliers</h4>";
echo "<ul>"; 
while($author_posts->have_posts()) : $author_posts->the_post();
$edit_post = add_query_arg( 'post', get_the_ID(), get_permalink( 4745 + $_POST['_wp_http_referer'] ) );
?>
<li>
<a href="<?php the_permalink(); ?>" rel="bookmark" t title="<?php the_title_attribute(); ?>"><?php the_title(); ?></a>
- <a href="<?php echo $edit_post; ?>">Modifier</a>
<ul>
Confirmé
<?php echo do_shortcode( '[ESPRESSO_EVENT_ATTENDEES event_id="' . get_the_ID() . '" status=RAP]' ); ?>
En attente
<?php echo do_shortcode( '[ESPRESSO_EVENT_ATTENDEES event_id="' . get_the_ID() . '" status=RNA]' ); ?>	
Annulé
<?php echo do_shortcode( '[ESPRESSO_EVENT_ATTENDEES event_id="' . get_the_ID() . '" status=RCN]' ); ?>	
Refusé
<?php echo do_shortcode( '[ESPRESSO_EVENT_ATTENDEES event_id="' . get_the_ID() . '" status=RDC]' ); ?>	
</ul>
</li>  		
<?php
endwhile;
echo "</ul>"; 
}
wp_reset_query();  // Restore global post data stomped by the_post().

In back end, this user is only accepted. Have you a solution ?

March 14, 2016 at 11:59 am

After some works, I give up shortcode because I got strange behaviour and I wanted have tickets before to have attendees.
Last question (For today 😉 What is the field to know if the registration is Approved, Waiting, Cancelled ?

Here my code

$author_query = array(
			'author' 			 => $id_user,
			'post_type'     	 => 'espresso_events',
			'post_status'		 => 'publish, private',
			'posts_per_page' 	 => -1,
			'caller_get_posts'	 => 1
			);
		$author_posts = new WP_Query($author_query);
		
		if ($author_posts->have_posts()) {
			global $wpdb, $post;
			
			echo "<h4>Liste de vos ateliers</h4>";
			echo "<ul>"; 
			while($author_posts->have_posts()) : $author_posts->the_post();
				$edit_post = add_query_arg( 'post', get_the_ID(), get_permalink( 4745 + $_POST['_wp_http_referer'] ) );
				?>
				<li>
					<a href="<?php the_permalink(); ?>" rel="bookmark" t title="<?php the_title_attribute(); ?>"><?php the_title(); ?></a>
					- <a href="<?php echo $edit_post; ?>">Modifier</a>
					
					<?php      
						echo '<ul class="ticket-list">';								
						$sql_tickets = "SELECT TKT_name, st_esp_ticket.TKT_ID ";
						$sql_tickets .= "FROM {$wpdb->prefix}esp_ticket ";
						$sql_tickets .= "INNER JOIN {$wpdb->prefix}esp_datetime_ticket ";
						$sql_tickets .= "ON {$wpdb->prefix}esp_ticket.TKT_ID = {$wpdb->prefix}esp_datetime_ticket.TKT_ID ";
						$sql_tickets .= "INNER JOIN {$wpdb->prefix}esp_datetime ";
						$sql_tickets .= "ON {$wpdb->prefix}esp_datetime.DTT_ID = {$wpdb->prefix}esp_datetime_ticket.DTT_ID ";
						$sql_tickets .= "WHERE {$wpdb->prefix}esp_datetime.EVT_ID = %d ";
			
						$tickets = $wpdb->get_results( $wpdb->prepare( $sql_tickets, get_the_ID()));						
						
						if (count($tickets)==0) {
							echo "Aucun ticket";						
						} else {						
							foreach($tickets as $ticket){
								$TKT_name = $ticket->TKT_name;
								$TKT_ID = $ticket->TKT_ID;
								$html = "Ticket : " . $TKT_name;
								echo $html;
								
									if(is_singular()){
										echo '<ul class="attendee-list">';
									
										$sql_attendees = "SELECT ATT_fname, ATT_lname, ATT_email ";
										$sql_attendees .= "FROM {$wpdb->prefix}esp_attendee_meta ";
										$sql_attendees .= "INNER JOIN {$wpdb->prefix}esp_registration ";
										$sql_attendees .= "ON {$wpdb->prefix}esp_attendee_meta.ATT_ID = {$wpdb->prefix}esp_registration.ATT_ID ";
										$sql_attendees .= "WHERE {$wpdb->prefix}esp_registration.TKT_ID = %d";
										
										$attendees = $wpdb->get_results( $wpdb->prepare( $sql_attendees, $TKT_ID));
										foreach($attendees as $attendee){
											$fname = $attendee->ATT_fname;
											$lname = $attendee->ATT_lname;
											$email = $attendee->ATT_email;
											$html = '<li><span>'. $fname .' '. $lname . ' - ' . $email . '</span></li>';
											echo $html;
										}
										echo '</ul>';	
									}
							}
							wp_reset_query();  // Restore global post data stomped by the_post().
						}
						echo '</ul>';
					?>
							
				</li>  		
				<?php
			endwhile;
			echo "</ul>"; 
		}
		wp_reset_query();  // Restore global post data stomped by the_post().

March 18, 2016 at 11:10 am

I will certainly study that.
Thanks a lot tony.