Support

March 2, 2017 at 10:13 am

Hello

I tried to follow the instructions from this post https://eventespresso.com/topic/invoice-edit-to-add-a-question-company-name/#post-58301 but it didn’t work for me.

The “Bill to” part in my pdf invoice currently gives:
First Name Last name
email
Street Address
City State
Zip Code

I would like to add the company name before the email, and the country at the bottom (and if possible the Street Adress 2).
My question ID for name of organization is 13, country is 24 and street address 2 is 5.

Here is what I have in my template invoice: (in wp-content/plugin/event-espresso.3.1.36.6.P/gateways/invoice/template

//Query Database for event and get variable
/* $events = $wpdb->get_results(“SELECT * FROM ” . EVENTS_DETAIL_TABLE . ” WHERE id='” . $event_id . “‘”);
foreach ($events as $event){
//$event_id = $event->id;
$event_name = html_entity_decode(stripslashes($event->event_name),ENT_QUOTES,”UTF-8″);
$event_desc = $event->event_desc;
$event_description = $event->event_desc;
$event_identifier = $event->event_identifier;
$start_date = $event->start_date;
} */
//This is an example of how to get custom questions for an attendee
//Get the questions for the attendee
$q_sql = “SELECT ea.answer, eq.question
FROM ” . EVENTS_ANSWER_TABLE . ” ea
LEFT JOIN ” . EVENTS_QUESTION_TABLE . ” eq ON eq.id = ea.question_id
WHERE ea.registration_id = ‘”.$registration_id.”‘”;
$q_sql .= ” AND ea.question_id = ’13’ “;
$q_sql .= ” ORDER BY eq.sequence asc “;
$wpdb->get_results($q_sql);

$organization_name = $wpdb->last_result[0]->answer;//question_id = ’13’

And a bit further:
//Set the billing information
$pdf->SetFont(‘Times’, ‘B’, 12);
$pdf->Cell(50, 5, __(‘Bill To: ‘, ‘event_espresso’), 0, 1, ‘L’); //Set bill to
$pdf->SetFont(‘Times’, ”, 12);
$pdf->Cell(50, 5, pdftext($attendee_first . ‘ ‘ . $attendee_last), 0, 1, ‘L’); //Set attendee name
$pdf->Cell(50, 5, $attendee_organization_name, 0, 1, ‘L’); //Set attendee organization name
$pdf->Cell(50, 5, $attendee_email, 0, 1, ‘L’); //Set attendee email
//Set attendee address
$attendee_address != ” ? $pdf->Cell(100, 5, $attendee_address, 0, 1, ‘L’) : ”;
$pdf->Cell(100, 5, (pdftext($attendee_city != ” ? $attendee_city : ”) . ($attendee_state != ” ? ‘ ‘ . $attendee_state : ”)), 0, 1, ‘L’);
$attendee_zip != ” ? $pdf->Cell(50, 5, $attendee_zip, 0, 1, ‘L’) : ”;
$attendee_country != ” ? $pdf->Cell(50, 5, $attendee_country, 0, 1, ‘L’) : ”;

$pdf->Ln(10);

I hope you can help! Thanks!