BuddyPress.org

Thank you so much for replying. There is quite a lot of data on the plugin page. I need to display it within a backend email template. I am already able to show xprofile fields on the profile. Any ideas?

So what you do is create a shortcode similar to what you did for the profile pages but it’s within the appointments+ files. I can adjust the code to create the shortcode USER_PHONEr . Here is an example of custom code for a drop down on profile that was included into email templates

if($r->travel_type==2){
$address=$r->address;
$travel_type=”Photographer Travel to Me”;
} else {
$sql = “SELECT * FROM wppl_friends_locator where member_id=”.$r->worker;

$squad=$wpdb->get_results( $sql );

if($squad){
$address=$squad[0]->formatted_address;
}
else{
$address=””;
}
$travel_type=”Travel to Photographer”;
}

but instead of all the travel type and address stuff I need to call the xprofile fields database then find id 206 and display that info.

Thank You

$user_phone is xprofile id 206 and $worker_phone is xprofile is id 7

thank you zimou13 but I don’t see how this would help me. Seems like a form?

So here’s what I have done.

if I set it like this

$User_phone = get_userdata($r->user);
$Worker_phone = get_userdata($r->worker);
		 
		$args = array(
			'user'     => $r->name,
			'customer_username'=>$customerUser->user_login,
			'artist_username'=>$artistUser->user_login,
			'service'  => $appointments->get_service_name( $r->service ),
			'worker'   => appointments_get_worker_name( $r->worker ),
			'datetime' => $r->start,
			'price'    => $r->price,
			'deposit'  => $appointments->get_deposit( $r->price ),
			'phone'    => $r->phone,
			'user_phone'  => $User_phone->user_login,
			'worker_phone' => $Worker_phone->user_login,
			'note'     => $r->note,
			'address'  => $address,
			'email'    => $email,
			'city'     => $r->city,
			'number_of_guest'=>$r->number_of_guest,
			'travel_type'=>$travel_type,
			'ID'=>$r->ID
		);

and I set USER_PHONE and WORKER_PHONE in my email templates is shows the correct usernames or worker name of each user or worker in the emails so the shortcode setup works it’s just the data on the right .

so It would seem what need to be changed is this

'user_phone'  => $User_phone->user_login,
'worker_phone' => $Worker_phone->user_login,

but if I change to

$User_phone->user_login, to $wpdb->get_col(“SELECT value FROM {$wpdb->prefix}bp_xprofile_data WHERE field_id = 7 AND user_id = $r->ID”),

you were missing the closing ” and I can’t put ; it has to be , at the end

it shows no errors just shows blank on the email.

here is the entire confirmation email template

<?php

class Appointments_Notifications_Confirmation extends Appointments_Notification {

	/**
	 * Send confirmation email to customer, admin and worker
	 *
	 * @param integer $app_id Appointment ID
	 *
	 * @return bool True if emails were sent
	 */
	public function send( $app_id ) {
		$appointments = appointments();

		$app = appointments_get_appointment( $app_id );
		if ( ! $app ) {
			return false;
		}

		$options = appointments_get_options();

		$send_confirmation = 'yes' === $options["send_confirmation"];
		$send_confirmation = apply_filters( 'appointments_send_confirmation', $send_confirmation, $app_id );
		if ( ! $send_confirmation ) {
			return false;
		}

		$sent_to = array();
		$customer_email = $app->get_customer_email();
		$result = $this->customer( $app_id, $customer_email );

		if ( $result ) {
			$sent_to[] = $customer_email;
			$admin_email = $appointments->get_admin_email();
			if ( ! in_array( $admin_email, $sent_to ) && $this->admin( $app_id, $admin_email ) ) {
				$sent_to[] = $admin_email;
			}

			$worker_email = $appointments->get_worker_email( $app->worker );
			if ( ! in_array( $worker_email, $sent_to ) ) {
				$this->admin( $app_id, $worker_email );
			}

			return true;

		}

		return $result;
	}

	/**
	 * Sends a confirmation email to the customer
	 *
	 * @param int $app_id Appointment ID
	 * @param string $email Email to send to
	 *
	 * @return bool True if the email has been sent
	 */
	public function customer( $app_id, $email ) {
		$appointments = appointments();

		$r = appointments_get_appointment( $app_id );
		if ( ! $r ) {
			return false;
		}

		if ( ! is_email( $email ) ) {
			$this->manager->log( sprintf( __( 'Unable to notify the client about the appointment ID:%s confirmation, stopping.', 'appointments' ), $app_id ) );
			return false;
		}

		$template = $this->get_customer_template( $app_id, $email );
		if ( ! $template ) {
			return false;
		}

		$attachments = apply_filters( 'app_confirmation_email_attachments', '', $app_id );
		$mail_result = wp_mail(
			$email,
			$template['subject'],
			$template['body'],
			$appointments->message_headers(),
			$attachments
		);

		if ( ! $mail_result ) {
			return false;
		}

		$this->manager->log( sprintf( __('Confirmation message sent to %s for appointment ID:%s','appointments'), $r->email, $app_id ) );

		do_action( 'app_confirmation_sent', $template['body'], $r, $app_id, $email );

		return true;
	}

	/**
	 * Send a confirmation email to admin
	 *
	 * @param $app_id
	 * @param $admin_email
	 *
	 * @return bool
	 */
	public function admin( $app_id, $admin_email ) {
		$appointments = appointments();

		$r = appointments_get_appointment( $app_id );
		if ( ! $r ) {
			return false;
		}

		$disable = apply_filters( 'app_confirmation_disable_admin', false, $r, $app_id, $admin_email );
		if ( $disable ) {
			return true;
		}

		if ( ! is_email( $admin_email ) ) {
			return false;
		}

		$template = $this->get_admin_template( $app_id );

		if ( ! $template ) {
			return false;
		}

		$result =  wp_mail(
			$admin_email,
			$template['subject'],
			$template['body'],
			$appointments->message_headers()
		);

		if ( $result ) {
			do_action( 'appointments_confirmation_admin_sent', $admin_email, $app_id, $template['body'], $template['subject'] );
		}

		return $result;
	}

	public function get_admin_template( $app_id ) {
		global $wpdb;
		$appointments = appointments();

		$r = appointments_get_appointment( $app_id );
		if ( ! $r ) {
			return false;
		}

		$customer_email = $r->get_customer_email();
		if ( ! $customer_email ) {
			return false;
		}
		
		

		/*$provider_add_text  = sprintf( __('A new appointment has been made on %s. Below please find a copy of what has been sent to your client:', 'appointments'), get_option( 'blogname' ) );
		$provider_add_text .= "\n\n\n";
        
		$subject = __('New Appointment','appointments');*/
        /*Added by */
        $options = appointments_get_options();
        $subject = $options["confirmation_subject_artist"];
        $provider_add_text = $options['confirmation_message_artist'];
        
         

         if($r->travel_type==2){
         	$address=$r->address;
         	$travel_type="Photographer Travel to Me";
         } else {
         	$sql = "SELECT * FROM <code>wppl_friends_locator</code> where member_id=".$r->worker;
			 
			$squad=$wpdb->get_results( $sql );
			
			if($squad){				
				$address=$squad[0]->formatted_address;
			}
			else{
				$address="";
			}
         	$travel_type="Travel to Photographer";
         }
             $customerUser = get_userdata($r->user);
         $artistUser = get_userdata($r->worker);
	
	
	 
$User_phone = get_userdata($r->user);
$Worker_phone = get_userdata($r->worker);
		 
		$args = array(
			'user'     => $r->name,
			'customer_username'=>$customerUser->user_login,
			'artist_username'=>$artistUser->user_login,
			'service'  => $appointments->get_service_name( $r->service ),
			'worker'   => appointments_get_worker_name( $r->worker ),
			'datetime' => $r->start,
			'price'    => $r->price,
			'deposit'  => $appointments->get_deposit( $r->price ),
			'phone'    => $r->phone,
			'user_phone'  => $User_phone->user_login,
			'worker_phone' => $Worker_phone->user_login,
			'note'     => $r->note,
			'address'  => $address,
			'email'    => $email,
			'city'     => $r->city,
			'number_of_guest'=>$r->number_of_guest,
			'travel_type'=>$travel_type,
			'ID'=>$r->ID
		);

		$provider_add_text = $this->replace_placeholders( $provider_add_text, $args, 'confirmation-body', $r );
          /*end Added by */
        
		$body = $this->get_customer_template( $app_id, $customer_email );

		return array(
			'subject' => $subject,
			'body' => $provider_add_text 
		);
	}

	public function get_customer_template( $app_id, $email ) {
		global $wpdb;
		$appointments = appointments();

		$r = appointments_get_appointment( $app_id );
		if ( ! $r ) {
			return false;
		}

		$options = appointments_get_options();
		$body = $options['confirmation_message_customer'];
       
         

         if($r->travel_type==2){
         	$address=$r->address;
         	$travel_type="Photographer Travel to Me";
         } else {
			$sql = "SELECT * FROM <code>wppl_friends_locator</code> where member_id=".$r->worker;
			 
			$squad=$wpdb->get_results( $sql );
			
			if($squad){
				$address=$squad[0]->formatted_address;
			}
			else{
				$address="";
			}
         	
         	$travel_type="Travel to Photographer";
         }
          $customerUser = get_userdata($r->user);
         $artistUser = get_userdata($r->worker);
		 
		$Worker_phone = get_userdata($r->worker);
		
		$args = array(
			'user'     => $r->name,
			'customer_username'=>$customerUser->user_login,
			'artist_username'=>$artistUser->user_login,
			'service'  => $appointments->get_service_name( $r->service ),
			'worker'   => appointments_get_worker_name( $r->worker ),
			'datetime' => $r->start,
			'price'    => $r->price,
			'deposit'  => $appointments->get_deposit( $r->price ),
			'phone'    => $r->phone,
			'worker_phone'  => $Worker_phone->user_login,
			'note'     => $r->note,
			'address'  => $address,
			'email'    => $email,
			'city'     => $r->city,
			'number_of_guest'=>$r->number_of_guest,
			'travel_type'=>$travel_type,
			'ID'=>$r->ID
		);

		$body = $this->replace_placeholders( $body, $args, 'confirmation-body', $r );

		$body = $appointments->add_cancel_link( $body, $app_id );
		$body = apply_filters( 'app_confirmation_message', $body, $r, $app_id );

		$subject = $options["confirmation_subject_customer"];
		$subject = $this->replace_placeholders( $subject, $args, 'confirmation-subject', $r );

		return array(
			'subject' => $subject,
			'body' => $body
		);
	}

}

thank you again

help please anyone?

so none of these work

$wpdb->get_var(“SELECT value FROM {$wpdb->prefix}bp_xprofile_data WHERE field_id = 206 AND user_id = $r->ID”);

$wpdb->get_col(“SELECT value FROM {$wpdb->prefix}bp_xprofile_data WHERE field_id = 206 AND user_id = $r->ID”);

$wpdb->get_results(“SELECT value FROM {$wpdb->prefix}bp_xprofile_data WHERE field_id = 206 AND user_id = $r->ID”);

I think something is still missing