function combinetickets($info)
{
## Required helpers to create this PDF invoice
## Do NOT edit the required files! It will damage your component.
include_once JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_ticketmaster' . DS . 'assets' . DS . 'pdf' . DS . 'fpdf' . DS . 'fpdf.php';
include_once JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_ticketmaster' . DS . 'assets' . DS . 'pdf' . DS . 'fpdi_ean13.php';
## initiate FPDI
$initrow =& $info[0];
$pdf = new FPDI_EAN13($initrow->ticket_orientation, 'mm', $initrow->ticket_size);
$foutn = JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_ticketmaster' . DS . 'tickets' . DS . 'eTickets-' . $initrow->ordercode . '.pdf';
for ($i = 0, $n = count($info); $i < $n; $i++) {
$pdf->addPage();
$row =& $info[$i];
$fn = JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_ticketmaster' . DS . 'tickets' . DS . 'eTicket-' . $row->orderid . '.pdf';
$pdf->setSourceFile($fn);
$tplIdx = $pdf->importPage(1);
## use the imported page and place it at point 0,0 with a width of 210 mm (A4 Format)
$pdf->useTemplate($tplIdx, 0, 0, 0);
## add a page
}
$file = basename(tempnam('.', 'tmp'));
rename($file, JPATH_SITE . DS . 'tmp' . DS . $file . '.pdf');
$file .= '.pdf';
## Save PDF to file now!!
$pdf->Output(JPATH_SITE . DS . 'tmp' . DS . $file, 'F');
## Now move the file away for security reasons
## Import the Joomla! Filesystem.
jimport('joomla.filesystem.file');
## Copy the file to a new directory.
$src = JPATH_SITE . DS . 'tmp' . DS . $file;
## Now move the file away for security reasons
## Import the Joomla! Filesystem.
jimport('joomla.filesystem.file');
## Copy the file to a new directory.
$src = JPATH_SITE . DS . 'tmp' . DS . $file;
## The new name for the ticket
$dest = $foutn;
## Copy the file now.
JFile::copy($src, $dest);
## The old temporary file needs to be deleted.
JFile::delete($src);
return $foutn;
}
public function doConfirm()
{
$db = JFactory::getDBO();
## Making the query for getting the config
$sql = 'SELECT * FROM #__ticketmaster_config WHERE configid = 1';
$db->setQuery($sql);
$config = $db->loadObject();
## include the functions for price views.
$file_include = JPATH_SITE . DS . 'components' . DS . 'com_ticketmaster' . DS . 'assets' . DS . 'functions.php';
include_once $file_include;
## Required helpers to create this PDF invoice
## Do NOT edit the required files! It will damage your component.
include_once JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_ticketmaster' . DS . 'assets' . DS . 'pdf' . DS . 'fpdf' . DS . 'fpdf.php';
include_once JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_ticketmaster' . DS . 'assets' . DS . 'pdf' . DS . 'fpdi_ean13.php';
## Making the query for getting the order
$sql = 'SELECT a.*, t.*, e.eventname, c.*,
t.ticketdate, t.starttime, t.location, t.locationinfo, a.paid, e.groupname, t.eventcode
FROM #__ticketmaster_orders AS a, #__ticketmaster_clients AS c,
#__ticketmaster_events AS e, #__ticketmaster_tickets AS t
WHERE a.userid = c.userid
AND a.eventid = e.eventid
AND a.ticketid = t.ticketid
AND ordercode = ' . $this->eid . '';
$db->setQuery($sql);
$order = $db->loadObject();
## initiate FPDI
$pdf = new FPDI_EAN13();
## add a page
$pdf->AddPage();
## Getting the order date:
$orderdate = date($config->dateformat, strtotime($order->orderdate));
$logo = explode("-", $config->position_logo_confirmation);
$folder = JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_ticketmaster' . DS . 'assets' . DS . 'images' . DS;
$pdf->Image($folder . 'confirmation_logo.jpg', $logo[0], $logo[1], 0, 20);
#############################################
## WRITING THE ORDERDATE ##
#############################################
$sql = 'SELECT COUNT(orderid) AS total
FROM #__ticketmaster_orders
WHERE ordercode = ' . $this->eid . '
AND (paid = 0 OR paid = 3)';
$db->setQuery($sql);
$status = $db->loadObject();
## Writing the orderdate on the confirmation.
$pdf->SetFont('Arial', '', 9);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetXY(7, 60);
$pdf->Write(0, JText::_('COM_TICKETMASTER_ORDERDATE') . ': ' . $orderdate);
## Writing the orderdate on the confirmation.
$pdf->SetFont('Arial', '', 9);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetXY(7, 65);
$pdf->Write(0, utf8_decode(JText::_('COM_TICKETMASTER_PDF_ORDERCONFIRMATION')) . $this->eid);
$pdf->SetXY(7, 70);
if ($status->total > 0) {
$pdf->Write(0, utf8_decode(JText::_('COM_TICKETMASTER_PAYMENTSTATUS')) . ': ' . JText::_('COM_TICKETMASTER_ORDERSTATUS_UNPAID'));
} else {
$pdf->Write(0, utf8_decode(JText::_('COM_TICKETMASTER_PAYMENTSTATUS')) . ': ' . JText::_('COM_TICKETMASTER_ORDERSTATUS_PAID'));
}
###############################################
## WRITING THE COMPANY INFORMATION ON TICKET ##
###############################################
if ($config->address_format_company == '') {
##Writing the company name
$pdf->SetFont('Arial', '', 9);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetXY(7, 14);
$pdf->Write(0, utf8_decode($config->companyname));
##Writing the company address
$pdf->SetFont('Arial', '', 9);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetXY(7, 18);
$pdf->Write(0, utf8_decode($config->address1));
##Writing the company zipcode+city
$pdf->SetFont('Arial', '', 9);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetXY(7, 22);
$pdf->Write(0, $config->zipcode . ' ' . utf8_decode($config->city));
##Writing the company phone
$pdf->SetFont('Arial', '', 9);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetXY(7, 26);
$pdf->Write(0, JText::_('COM_TICKETMASTER_PHONE') . ' ' . utf8_decode($config->phone));
##Writing the company email
$pdf->SetFont('Arial', '', 9);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetXY(7, 30);
$pdf->Write(0, $config->email);
##Writing the company website
$pdf->SetFont('Arial', '', 9);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetXY(7, 34);
$pdf->Write(0, $config->website);
} else {
if (ini_get('magic_quotes_gpc') == '1') {
$body = stripslashes($config->address_format_company);
} else {
$body = utf8_decode($config->address_format_company);
}
$pdf->SetFont('Arial', '', 9);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetXY(7, 14);
$pdf->MultiCell(0, 5, "{$body}", 0, 'L', 0);
}
################################################
## WRITING THE CUSTOMER INFORMATION ON TICKET ##
################################################
if ($config->address_format_client == '') {
## Writing the clientname.
$pdf->SetFont('Arial', '', 9);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetXY(135, 51);
if ($order->firstname == '') {
$pdf->Write(0, utf8_decode($order->name));
} else {
$pdf->Write(0, utf8_decode($order->firstname) . ' ' . utf8_decode($order->name));
}
## Writing the client address.
$pdf->SetFont('Arial', '', 9);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetXY(135, 55);
$pdf->Write(0, utf8_decode($order->address));
## Writing the zipcode & city.
$pdf->SetFont('Arial', '', 9);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetXY(135, 59);
$pdf->Write(0, $order->zipcode . ' ' . utf8_decode($order->city));
## Writing the zipcode & city.
$pdf->SetFont('Arial', '', 9);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetXY(135, 63);
$pdf->Write(0, $order->emailaddress);
} else {
$client_address = str_replace('%%FIRSTNAME%%', utf8_decode($order->firstname), $config->address_format_client);
$client_address = str_replace('%%LASTNAME%%', utf8_decode($order->name), $client_address);
$client_address = str_replace('%%ADDRESS1%%', utf8_decode($order->address), $client_address);
$client_address = str_replace('%%ADDRESS2%%', utf8_decode($order->address2), $client_address);
$client_address = str_replace('%%ZIPCODE%%', utf8_decode($order->zipcode), $client_address);
$client_address = str_replace('%%CITY%%', utf8_decode($order->city), $client_address);
if ($order->country_id != '') {
$sql = 'SELECT * FROM #__ticketmaster_country
WHERE country_id = ' . $order->country_id . '';
$db->setQuery($sql);
$obj = $db->loadObject();
$client_address = str_replace('%%COUNTRY_FULL%%', utf8_decode($obj->country), $client_address);
$client_address = str_replace('%%COUNTRY_2D%%', utf8_decode($obj->country_2_code), $client_address);
$client_address = str_replace('%%COUNTRY_3D%%', utf8_decode($obj->country_3_code), $client_address);
}
if (ini_get('magic_quotes_gpc') == '1') {
$body = stripslashes($client_address);
} else {
$body = $client_address;
}
$pdf->SetFont('Arial', '', 9);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetXY(135, 51);
$pdf->MultiCell(0, 5, "{$body}", 0, 'L', 0);
}
#############################################
## WRITING THE GRID TOP TEXTURES HERE ##
#############################################
$pdf->SetDrawColor(193, 193, 193);
$pdf->Line(10, 96, 200, 96);
$pdf->Line(10, 96.7, 200, 96.7);
$pdf->SetFont('Arial', 'B', 9);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetXY(12, 91.5);
$pdf->Write(0, JText::_('COM_TICKETMASTER_QTY'));
$pdf->SetFont('Arial', 'B', 9);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetXY(27, 91.5);
$pdf->Write(0, utf8_decode(JText::_('COM_TICKETMASTER_TICKETINFORMATION')));
$pdf->SetFont('Arial', 'B', 9);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetXY(159, 91.5);
$pdf->Write(0, utf8_decode(JText::_('COM_TICKETMASTER_TIME')));
$pdf->SetFont('Arial', 'B', 9);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetXY(182, 91.5);
$pdf->Write(0, utf8_decode(JText::_('COM_TICKETMASTER_PRICE')));
#############################################
## WRITING THE GRID - PLEASE DONT CHANGE ##
#############################################
## Making the query for getting the order
$sql = 'SELECT COUNT(a.orderid) AS total, a.*, t.*, e.eventname, c.*,
t.ticketdate, t.starttime, a.paid, e.groupname, t.eventcode, v.venue AS location, v.city, t.show_end_date, t.end_date
FROM #__ticketmaster_orders AS a, #__ticketmaster_clients AS c, #__ticketmaster_venues AS v,
#__ticketmaster_events AS e, #__ticketmaster_tickets AS t
WHERE a.userid = c.userid
AND a.eventid = e.eventid
AND a.ticketid = t.ticketid
AND t.venue = v.id
AND ordercode = ' . $this->eid . '
GROUP BY a.ticketid';
$db->setQuery($sql);
$items = $db->loadObjectList();
## Setting the startgrid, DON'T change this!
$height1 = 100;
$height2 = 104;
$grand_totalprice = 0.0;
$payment_status = 1;
## Setting font color & font
$pdf->SetFont('Arial', '', 9);
$pdf->SetTextColor(0, 0, 0);
$k = 0;
for ($i = 0, $n = count($items); $i < $n; $i++) {
$row = $items[$i];
if ($row->coupon != '') {
## We need to fill this temporary :)
$session = JFactory::getSession();
## Gettig the orderid if there is one.
$couponcode = $session->set('coupon', $row->coupon);
}
if ($row->paid != 1) {
$payment_status = 0;
}
## Writing the itemid on the left collumn
## Make sure they are centered, see function below
$chars = strlen($row->total);
if ($chars == 1) {
$pdf->SetXY(13, $height1);
}
if ($chars == 2) {
$pdf->SetXY(12, $height1);
}
if ($chars == 3) {
$pdf->SetXY(12, $height1);
}
if ($chars == 4) {
$pdf->SetXY(11, $height1);
}
if ($chars == 5) {
$pdf->SetXY(10, $height1);
}
$pdf->Write(0, $row->total . 'x');
if ($row->show_end_date != 1) {
$ticketdate = date($config->dateformat, strtotime($row->ticketdate));
} else {
$ticketdate = date($config->dateformat, strtotime($row->ticketdate)) . ' - ' . date($config->dateformat, strtotime($row->end_date));
}
## Event information, first line
$pdf->SetXY(27, $height1);
if ($row->parentname != $row->ticketname) {
$pdf->Write(0, utf8_decode($row->eventname) . ' (' . utf8_decode($row->eventcode) . ') ' . utf8_decode($row->ticketname) . ' - (' . $ticketdate . ')');
} else {
$pdf->Write(0, utf8_decode($row->eventcode) . ' / ' . utf8_decode($row->ticketname) . ' (' . $ticketdate . ')');
}
if ($row->seat_sector != 0) {
$sql = 'SELECT * FROM #__ticketmaster_coords WHERE id = ' . (int) $row->seat_sector . '';
$db->setQuery($sql);
$seat = $db->loadObject();
$seatnumber = JText::_('COM_TICKETMASTER_SEAT_NR') . ': ' . $seat->row_name . $seat->seatid;
## Event information, second line
$pdf->SetXY(27, $height2);
$pdf->Write(0, $seatnumber . ' -- ' . utf8_decode($row->location) . ' - ' . utf8_decode($row->city));
} else {
## Event information, second line
$pdf->SetXY(27, $height2);
$pdf->Write(0, utf8_decode($row->location) . ' - ' . utf8_decode($row->city));
}
## Event information, the date field
$pdf->SetXY(159, $height1);
$pdf->Write(0, $row->starttime);
## Event information, the date field
if ($config->use_euros_in_pdf == 2) {
## Fixing the euro issue..
$price = showprice($config->priceformat, $row->ticketprice * $row->total, '');
$price = chr(128) . ' ' . $price;
} elseif ($config->use_euros_in_pdf == 3) {
$price = showprice($config->priceformat, $row->ticketprice * $row->total, '');
$price = chr(0xa3) . ' ' . $price;
} else {
$price = showprice($config->priceformat, $row->ticketprice * $row->total, $config->valuta);
}
$pdf->SetXY(180, $height1);
$pdf->Write(0, $price);
$y = $pdf->GetY();
$pdf->SetDrawColor(193, 193, 193);
$pdf->Line(10, $y + 6.7, 200, $y + 6.7);
## Add extra row to the FOR loop.
$height1 = $height1 + 10;
$height2 = $height2 + 10;
## Count the price for confirmation with pending tickets.
$grand_totalprice = $grand_totalprice + $row->ticketprice * $row->total;
$k = 1 - $k;
}
## get the session:
$session = JFactory::getSession();
if ($session->get('coupon') == '') {
$pdf->Line(10, $y + 7.4, 200, $y + 7.4);
}
### IF DISCOUNT == TRUE == WRITE AN EXTRA LINE WITH THE DISCOUNT ###
if ($session->get('coupon') != '') {
$pdf->SetXY(10, $height1);
$sql = 'SELECT * FROM #__ticketmaster_coupons
WHERE coupon_code = "' . $session->get('coupon') . '"';
$db->setQuery($sql);
$coupon = $db->loadObject();
if ($coupon->coupon_type == 1) {
## Discount in %
$discount = $grand_totalprice / 100 * $coupon->coupon_discount;
} else {
## Discount in amounts :)
$discount = $coupon->coupon_discount;
}
## Event information, the date field
if ($config->use_euros_in_pdf == 2) {
## Fixing the euro issue..
$price = showprice($config->priceformat, $discount, '');
$price = chr(128) . ' ' . $price;
} elseif ($config->use_euros_in_pdf == 3) {
$price = showprice($config->priceformat, $discount, '');
$price = chr(0xa3) . ' ' . $price;
} else {
$price = showprice($config->priceformat, $discount, $config->valuta);
}
$pdf->SetXY(180, $height1);
$pdf->Write(0, $price . ' -/-');
$pdf->SetXY(27, $height1);
if ($disco->coupon_type == 1) {
$tmp = $disco->coupon_discount . '%';
$pdf->Write(0, utf8_decode(JText::_('COM_TICKETMASTER_YOUR_DISCOUNT_PRICE') . ': (' . $tmp . ')'));
} else {
$pdf->Write(0, utf8_decode(JText::_('COM_TICKETMASTER_YOUR_DISCOUNT_PRICE')));
}
$pdf->SetXY(27, $height2);
$pdf->Write(0, utf8_decode(JText::_('COM_TICKETMASTER_COUPONCODE') . ': ' . $coupon->coupon_code));
$y = $pdf->GetY();
$pdf->SetDrawColor(193, 193, 193);
$pdf->Line(10, $y + 3, 200, $y + 3);
}
if ($session->get('coupon') != '') {
$pdf->Line(10, $y + 3.6, 200, $y + 3.6);
}
#############################################
## WRITING THE TOTALS OF THE ORDER ##
#############################################
## GEt the y-position:
$y = $pdf->GetY();
$y = $y + 10;
if ($config->use_euros_in_pdf == 2) {
## Fixing the euro issue..
$price = showprice($config->priceformat, $grand_totalprice - $discount, '');
$price = chr(128) . ' ' . $price;
} elseif ($config->use_euros_in_pdf == 3) {
$price = showprice($config->priceformat, $grand_totalprice - $discount, '');
$price = chr(0xa3) . ' ' . $price;
} else {
$price = showprice($config->priceformat, $grand_totalprices - $discount, $config->valuta);
}
## Event information, the price field
$pdf->SetXY(180, $y + 10);
$pdf->Write(0, $price);
if ($config->variable_transcosts == 1) {
$fees = ($grand_totalprice - $discount) / 100 * $config->transcosts + $config->transactioncosts;
## Event information, the price field
$pdf->SetXY(150, $y + 15);
$pdf->Write(0, utf8_decode(JText::_('COM_TICKETMASTER_TOTALFEE')));
## Event information, the price field
$pdf->SetXY(150, $y + 21);
$pdf->Write(0, utf8_decode(JText::_('COM_TICKETMASTER_TOTAL')));
if ($config->use_euros_in_pdf == 2) {
## Fixing the euro issue..
$price = showprice($config->priceformat, $fees, '');
$price = chr(128) . ' ' . $price;
} elseif ($config->use_euros_in_pdf == 3) {
$price = showprice($config->priceformat, $fees, '');
$price = chr(0xa3) . ' ' . $price;
} else {
$price = showprice($config->priceformat, $fees, $config->valuta);
}
$pdf->SetXY(180, $y + 15);
$pdf->Write(0, $price);
## Draw a line to count total amount
$pdf->Line(150, $y + 18, 200, $y + 18);
$pdf->Line(150, $y + 18.5, 200, $y + 18.5);
if ($config->use_euros_in_pdf == 2) {
## Fixing the euro issue..
$price = showprice($config->priceformat, $grand_totalprice - $discount + $fees, '');
$price = chr(128) . ' ' . $price;
} elseif ($config->use_euros_in_pdf == 3) {
$price = showprice($config->priceformat, $grand_totalprice - $discount + $fees, '');
$price = chr(0xa3) . ' ' . $price;
} else {
$price = showprice($config->priceformat, $grand_totalprice - $discount + $fees, $config->valuta);
}
## Draw a line to count total amount
$pdf->Line(150, $y + 23.5, 200, $y + 23.5);
$pdf->Line(150, $y + 24.1, 200, $y + 24.1);
$pdf->SetXY(180, $y + 21);
$pdf->Write(0, $price);
$pdf->SetXY(150, $y + 10);
$pdf->Write(0, utf8_decode(JText::_('COM_TICKETMASTER_SUBTOTAL')));
} else {
if ($config->transactioncosts != 0) {
## Event information, the price field
$pdf->SetXY(150, $y + 15);
$pdf->Write(0, utf8_decode(JText::_('COM_TICKETMASTER_TOTALFEE')));
## Event information, the price field
$pdf->SetXY(150, $y + 21);
$pdf->Write(0, utf8_decode(JText::_('COM_TICKETMASTER_TOTAL')));
$totalfee = $config->transactioncosts;
$fees = number_format($totalfee, 2, ',', '.');
if ($config->use_euros_in_pdf == 2) {
## Fixing the euro issue..
$price = showprice($config->priceformat, $config->transactioncosts, '');
$price = chr(128) . ' ' . $price;
} elseif ($config->use_euros_in_pdf == 3) {
$price = showprice($config->priceformat, $config->transactioncosts, '');
$price = chr(0xa3) . ' ' . $price;
} else {
$price = showprice($config->priceformat, $config->transactioncosts, $config->valuta);
}
$pdf->SetXY(180, $y + 15);
$pdf->Write(0, $price);
## Draw a line to count total amount
$pdf->Line(150, $y + 23.5, 200, $y + 23.5);
$pdf->Line(150, $y + 24.1, 200, $y + 24.1);
if ($config->use_euros_in_pdf == 2) {
## Fixing the euro issue..
$price = showprice($config->priceformat, $grand_totalprice - $discount + $fees, '');
$price = chr(128) . ' ' . $price . '-';
} elseif ($config->use_euros_in_pdf == 3) {
$price = showprice($config->priceformat, $grand_totalprice - $discount + $fees, '');
$price = chr(0xa3) . ' ' . $price;
} else {
$price = showprice($config->priceformat, $grand_totalprice - $discount + $fees, $config->valuta);
}
$pdf->SetXY(180, $y + 21);
$pdf->Write(0, $price);
## Draw a line to count total amount
$pdf->Line(150, $y + 18, 200, $y + 18);
$pdf->Line(150, $y + 18.5, 200, $y + 18.5);
$pdf->SetXY(150, $y + 10);
$pdf->Write(0, utf8_decode(JText::_('COM_TICKETMASTER_SUBTOTAL')));
}
}
$this->to_be_paid = $grand_totalprice - $discount + $fees;
$session->set('coupon', '');
$file = basename(tempnam('.', 'tmp'));
rename($file, JPATH_SITE . DS . 'tmp' . DS . $this->eid . '.pdf');
$file .= '.pdf';
## Save PDF to file now!!
$pdf->Output(JPATH_SITE . DS . 'tmp' . DS . $file, 'F');
## Now move the file away for security reasons
## Import the Joomla! Filesystem.
jimport('joomla.filesystem.file');
## Copy the file to a new directory.
$src = JPATH_SITE . DS . 'tmp' . DS . $file;
## The new name for the ticket
$dest = JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_ticketmaster' . DS . 'tickets' . DS . 'confirmation' . DS . $this->eid . '.pdf';
## Copy the file now.
JFile::copy($src, $dest);
## The old temporary file needs to be deleted.
JFile::delete($src);
}
function doPDF()
{
$db = JFactory::getDBO();
## Making the query for getting the config
$sql = 'SELECT * FROM #__ticketmaster_config WHERE configid = 1';
$db->setQuery($sql);
$config = $db->loadObject();
$sql = 'SELECT * FROM #__ticketmaster_orders WHERE orderid = ' . (int) $this->eid . '';
$db->setQuery($sql);
$order = $db->loadObject();
## include the functions for price views.
$file_include = JPATH_SITE . DS . 'components' . DS . 'com_ticketmaster' . DS . 'assets' . DS . 'functions.php';
include_once $file_include;
## Making the query for getting the order
$sql = 'SELECT a.*, t.*, e.eventname, c.address, c.name, c.city, c.firstname,
t.ticketdate, t.starttime, t.location, t.locationinfo, e.groupname, e.eventid, t.eventcode, t.show_end_date, t.end_date
FROM #__ticketmaster_orders AS a, #__ticketmaster_clients AS c,
#__ticketmaster_events AS e, #__ticketmaster_tickets AS t
WHERE a.userid = c.userid
AND a.eventid = e.eventid
AND a.ticketid = t.ticketid
AND orderid = ' . (int) $this->eid . '';
$db->setQuery($sql);
$order = $db->loadObject();
$orderdate = date($config->dateformat, strtotime($order->ticketdate));
## Required helpers to create this PDF invoice
## Do NOT edit the required files! It will damage your component.
include_once JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_ticketmaster' . DS . 'assets' . DS . 'pdf' . DS . 'fpdf' . DS . 'fpdf.php';
include_once JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_ticketmaster' . DS . 'assets' . DS . 'pdf' . DS . 'fpdi_ean13.php';
## Making the query for getting the order
$sql = 'SELECT *
FROM #__ticketmaster_venues
WHERE id = ' . (int) $order->venue . '';
$db->setQuery($sql);
$locations = $db->loadObject();
## initiate FPDI
$pdf = new FPDI_EAN13($order->ticket_orientation, 'mm', $order->ticket_size);
## add a page
$pdf->AddPage();
## Image for the background :) <-- JPG file is now better to use then PDF. So use it if it exists
$background = JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_ticketmaster' . DS . 'assets' . DS . 'etickets' . DS . 'eTicket-' . $order->ticketid . '.jpg';
if (!file_exists($background)) {
## This should be the source file if there is an uploaded PDF file for this event.
$sourcefile = JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_ticketmaster' . DS . 'assets' . DS . 'etickets' . DS . 'eTicket-' . $order->ticketid . '.pdf';
## Check if there is an updated source PDF file.
if (!file_exists($sourcefile)) {
$sourcefile = JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_ticketmaster' . DS . 'assets' . DS . 'etickets' . DS . 'eTicket.pdf';
}
## set the sourcefile
$pdf->setSourceFile($sourcefile);
## import page 1
$tplIdx = $pdf->importPage(1);
## use the imported page and place it at point 0,0 with a width of 210 mm (A4 Format)
$pdf->useTemplate($tplIdx, 0, 0, 0);
} else {
## OK the background image should be there, now print it please :)
$printable = JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_ticketmaster' . DS . 'assets' . DS . 'etickets' . DS;
if ($order->ticket_size == 'A4') {
if ($order->ticket_orientation == 'P') {
$pdf->Image($background, 0, 0, 210, 290);
} else {
$pdf->Image($background, 0, 0, 290, 210);
}
} else {
if ($order->ticket_orientation == 'P') {
$pdf->Image($background, 0, 0, 148.5, 210);
} else {
$pdf->Image($background, 0, 0, 210, 148.5);
}
}
}
## Writing the Ticket Event Name
## Text writing (height, width) $pdf->SetFont('Arial', 'B', 8);
// Check each position and if not set do not attempt to write to PDF
if (strpos($order->eventname_position, '-') !== false) {
$position_event = explode("-", $order->eventname_position);
$pdf->SetFont('Arial', '', $order->ticket_fontsize);
$pdf->SetTextColor($order->ticket_fontcolor_r, $order->ticket_fontcolor_g, $order->ticket_fontcolor_b);
$pdf->SetXY($position_event[0], $position_event[1]);
## Writing the eventname on the ticket now.
$pdf->Write(0, utf8_decode($order->eventname) . ' - ' . utf8_decode($order->ticketname));
}
## Writing the Ticket Date
if (strpos($order->date_position, '-') !== false) {
## Date definition - Change if you like. (The config is showing the dateformats)
if ($order->show_end_date != 1) {
$ticketdate = date($config->dateformat, strtotime($order->ticketdate));
} else {
$ticketdate = date($config->dateformat, strtotime($order->ticketdate)) . ' - ' . date($config->dateformat, strtotime($order->end_date));
}
$position_date = explode("-", $order->date_position);
$pdf->SetFont('Arial', 'B', $order->ticket_fontsize);
$pdf->SetTextColor($order->ticket_fontcolor_r, $order->ticket_fontcolor_g, $order->ticket_fontcolor_b);
$pdf->SetXY($position_date[0], $position_date[1]);
$pdf->Write(0, JText::_('COM_TICKETMASTER_PDF_DATE') . ' ' . $ticketdate . ' ' . JText::_('COM_TICKETMASTER_PDF_START') . ' ' . $order->starttime);
}
## Writing the Ticket Order Date information
if (strpos($order->orderdate_position, '-') !== false) {
## Date definition - Change if you like.
$orderdate = date($config->dateformat, strtotime($order->orderdate));
$orderdate_position = explode("-", $order->orderdate_position);
$pdf->SetFont('Arial', '', $order->ticket_fontsize);
$pdf->SetTextColor($order->ticket_fontcolor_r, $order->ticket_fontcolor_g, $order->ticket_fontcolor_b);
$pdf->SetXY($orderdate_position[0], $orderdate_position[1]);
$pdf->Write(0, JText::_('COM_TICKETMASTER_PDF_ORDERDATE') . ' ' . $orderdate);
}
## Writing the Name information
if (strpos($order->name_position, '-') !== false) {
$name_position = explode("-", $order->name_position);
$pdf->SetFont('Arial', '', $order->clientdata_fontsize);
$pdf->SetTextColor($order->clientdata_fontcolor_r, $order->clientdata_fontcolor_g, $order->clientdata_fontcolor_b);
$pdf->SetXY($name_position[0], $name_position[1]);
$pdf->Write(0, utf8_decode($order->firstname) . ' - ' . utf8_decode($order->name) . ' - ' . utf8_decode($order->address) . ' - ' . utf8_decode($order->city));
}
## Writing the Ticket Order Id
if (strpos($order->orderid_position, '-') !== false) {
$orderid_position = explode("-", $order->orderid_position);
$pdf->SetFont('Arial', 'B', $order->ticketnr_fontsize);
$pdf->SetTextColor($order->ticketnr_fontcolor_r, $order->ticketnr_fontcolor_g, $order->ticketnr_fontcolor_b);
$pdf->SetXY($orderid_position[0], $orderid_position[1]);
$pdf->Write(0, JText::_('COM_TICKETMASTER_PDF_ORDERID') . ' ' . $order->orderid);
}
## Writing the ordernumber on the ticket.
if (strpos($order->ordernumber_position, '-') !== false) {
$ordernumber_position = explode("-", $order->ordernumber_position);
$pdf->SetFont('Arial', 'B', $order->ticketid_nr_fontsize);
$pdf->SetTextColor($order->ticketid_nr_fontcolor_r, $order->ticketid_nr_fontcolor_g, $order->ticketid_nr_fontcolor_b);
$pdf->SetXY($ordernumber_position[0], $ordernumber_position[1]);
$pdf->Write(0, $order->groupname . '/' . $order->ordercode . '/' . $order->eventcode);
}
## Writing the seatnumber on the ticket if pro is installed.
## Not advised to change it yourself as we cannot guarantee a proper working
## Changes for this are at own risk :) (No support without valid PRO subscription)
if ($order->seat_sector != 0) {
$sql = 'SELECT * FROM #__ticketmaster_coords WHERE id = ' . (int) $order->seat_sector . '';
$db->setQuery($sql);
$seat = $db->loadObject();
if (strpos($order->position_seatnumber, '-') !== false) {
$position_seatnumber = explode("-", $order->position_seatnumber);
$pdf->SetFont('Arial', 'B', $order->font_size_seatnumber);
$pdf->SetTextColor($order->seatnumber_fontcolor_r, $order->seatnumber_fontcolor_g, $order->seatnumber_fontcolor_b);
$pdf->SetXY($position_seatnumber[0], $position_seatnumber[1]);
$pdf->Write(0, JText::_('COM_TICKETMASTER_PDF_SEAT_NUMBER') . ' ' . $seat->row_name . $seat->seatid);
}
}
if ($order->free_text_1 != '') {
if (strpos($order->free_text1_position, '-') !== false) {
unset($position);
$position = explode("-", $order->free_text1_position);
$pdf->SetFont('Arial', 'B', $order->ticket_fontsize);
$pdf->SetTextColor($order->ticket_fontcolor_r, $order->ticket_fontcolor_g, $order->ticket_fontcolor_b);
$pdf->SetXY($position[0], $position[1]);
$pdf->Write(0, utf8_decode($order->free_text_1));
}
}
if ($order->free_text_2 != '') {
if (strpos($order->free_text2_position, '-') !== false) {
unset($position);
$position = explode("-", $order->free_text2_position);
$pdf->SetFont('Arial', 'B', $order->ticket_fontsize);
$pdf->SetTextColor($order->ticket_fontcolor_r, $order->ticket_fontcolor_g, $order->ticket_fontcolor_b);
$pdf->SetXY($position[0], $position[1]);
$pdf->Write(0, utf8_decode($order->free_text_2));
}
}
## Prepare the price for usage in PDF.
$price = showprice($config->priceformat, $order->ticketprice, $config->valuta);
## Writing the price at the ticket.
if (strpos($order->price_position, '-') !== false) {
$price_position = explode("-", $order->price_position);
$pdf->SetFont('Arial', 'B', $order->ticketnr_fontsize);
$pdf->SetTextColor($order->ticketnr_fontcolor_r, $order->ticketnr_fontcolor_g, $order->ticketnr_fontcolor_b);
$pdf->SetXY($price_position[0], $price_position[1]);
if ($config->use_euros_in_pdf == 2) {
## Fixing the euro issue..
$price = showprice($config->priceformat, $order->ticketprice, '');
$pdf->Write(0, JText::_('COM_TICKETMASTER_PDF_PRICE') . ' ' . chr(128) . ' ' . $price);
} elseif ($config->use_euros_in_pdf == 3) {
$price = showprice($config->priceformat, $order->ticketprice, '');
$pdf->Write(0, JText::_('COM_TICKETMASTER_PDF_PRICE') . ' ' . chr(0xa3) . ' ' . $price);
} else {
$pdf->Write(0, JText::_('COM_TICKETMASTER_PDF_PRICE') . ' ' . $price);
}
}
## Writing the Ticket Location
if (strpos($order->location_position, '-') !== false) {
$location_position = explode("-", $order->location_position);
$pdf->SetFont('Arial', 'B', $order->ticket_fontsize);
$pdf->SetTextColor($order->ticket_fontcolor_r, $order->ticket_fontcolor_g, $order->ticket_fontcolor_b);
$pdf->SetXY($location_position[0], $location_position[1]);
$pdf->Write(0, JText::_('COM_TICKETMASTER_PDF_LOCATION') . ' ' . utf8_decode($locations->venue) . ' - ' . utf8_decode($locations->street) . ' - ' . utf8_decode($locations->zipcode) . ' - ' . utf8_decode($locations->city));
}
## Let's go for the Barcode Now!!
if (strpos($order->bar_position, '-') !== false) {
$code = $order->ordercode . $order->orderid;
$this->orderid = $order->orderid;
## Writing the code on the ticket.
$bar_position = explode("-", $order->bar_position);
$pdf->EAN13($bar_position[0], $bar_position[1], $code, $order->pdf_use_qrcode);
$session = JFactory::getSession();
## Gettig the orderid if there is one.
$barcode = $session->get('barcode');
## Updating the order, PDF created = 1
$query = 'UPDATE #__ticketmaster_orders' . ' SET barcode = ' . $barcode . '' . ' WHERE orderid = ' . (int) $this->eid . '';
## Do the query now
$db->setQuery($query);
## When query goes wrong.. Show message with error.
if (!$db->query()) {
$this->setError($db->getErrorMsg());
return false;
}
if ($order->pdf_use_qrcode == 1) {
## Gettin the genrated code.
$cache_folder = JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_ticketmaster' . DS . 'classes' . DS . 'cache' . DS;
$pdf->Image($cache_folder . $barcode . '.png', $bar_position[0], $bar_position[1], 0, 0);
$pdf->SetFont('Arial', 'B', 8);
$pdf->SetXY($bar_position[0], $bar_position[1] - 2);
$pdf->Write(0, $ordercode);
jimport('joomla.filesystem.file');
## We do want to remove the QR code again.
## It is not needed anymore, as ticket has been printed.
JFile::delete($cache_folder . $barcode . '.png');
}
}
$file = basename(tempnam('.', 'tmp'));
rename($file, JPATH_SITE . DS . 'tmp' . DS . $file . '.pdf');
$file .= '.pdf';
## Save PDF to file now!!
$pdf->Output(JPATH_SITE . DS . 'tmp' . DS . $file, 'F');
## Now move the file away for security reasons
## Import the Joomla! Filesystem.
jimport('joomla.filesystem.file');
## Copy the file to a new directory.
$src = JPATH_SITE . DS . 'tmp' . DS . $file;
## Now move the file away for security reasons
## Import the Joomla! Filesystem.
jimport('joomla.filesystem.file');
## Copy the file to a new directory.
$src = JPATH_SITE . DS . 'tmp' . DS . $file;
## The new name for the ticket
$dest = JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_ticketmaster' . DS . 'tickets' . DS . 'eTicket-' . $order->orderid . '.pdf';
## Copy the file now.
JFile::copy($src, $dest);
## The old temporary file needs to be deleted.
JFile::delete($src);
## Updating the order, PDF created = 1
$query = 'UPDATE #__ticketmaster_orders' . ' SET pdfcreated = 1' . ' WHERE orderid = ' . (int) $this->eid . '';
## Do the query now
$db->setQuery($query);
## When query goes wrong.. Show message with error.
if (!$db->query()) {
$this->setError($db->getErrorMsg());
return false;
}
}
public function create()
{
$db = JFactory::getDBO();
## Making the query for getting the config
$sql = 'SELECT * FROM #__ticketmaster_config WHERE configid = 1';
$db->setQuery($sql);
$config = $db->loadObject();
## include the functions for price views.
$file_include = JPATH_SITE . DS . 'components' . DS . 'com_ticketmaster' . DS . 'assets' . DS . 'functions.php';
include_once $file_include;
## Required helpers to create this PDF invoice
## Do NOT edit the required files! It will damage your component.
include_once JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_ticketmaster' . DS . 'assets' . DS . 'pdf' . DS . 'fpdf' . DS . 'fpdf.php';
include_once JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_ticketmaster' . DS . 'assets' . DS . 'pdf' . DS . 'fpdi_ean13.php';
## Making the query for getting the order
$sql = 'SELECT a.*, t.*, e.eventname, c.*,
t.ticketdate, t.starttime, t.location, t.locationinfo, a.paid, e.groupname, t.eventcode
FROM #__ticketmaster_orders AS a, #__ticketmaster_clients AS c,
#__ticketmaster_events AS e, #__ticketmaster_tickets AS t
WHERE a.userid = c.userid
AND a.eventid = e.eventid
AND a.ticketid = t.ticketid
AND ordercode = ' . $this->eid . '';
$db->setQuery($sql);
$order = $db->loadObject();
$db = JFactory::getDBO();
## Making the query for getting the config
$sql = 'SELECT * FROM #__ticketmaster_config WHERE configid = 1';
$db->setQuery($sql);
$config = $db->loadObject();
## CSetting the size of the document.
$pdf = new FPDI_EAN13('P', 'mm', 'A4');
## add a page
$pdf->AddPage();
## Getting the order date:
$orderdate = date($config->dateformat, strtotime($order->orderdate));
### setting the header for the page: (w) 210mm x (h) 90mm
$folder = JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_ticketmaster' . DS . 'assets' . DS . 'images' . DS;
$pdf->Image($folder . 'header.jpg', 0, 0, 210, 90);
## Including required paths to calculator.
$path_include = JPATH_SITE . DS . 'components' . DS . 'com_ticketmaster' . DS . 'assets' . DS . 'helpers' . DS . 'get.amount.php';
include_once $path_include;
$total = _getAmount($this->eid, 0, 0);
$fees = _getFees($this->eid);
$discount = _getDiscount($this->eid);
###############################################
## WRITING THE COMPANY INFORMATION ON TICKET ##
###############################################
if ($config->address_format_company == '') {
##Writing the company name
$pdf->SetFont('Arial', '', 9);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetXY(10, 35);
$pdf->Write(0, utf8_decode($config->companyname));
##Writing the company address
$pdf->SetFont('Arial', '', 9);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetXY(10, 45);
$pdf->Write(0, utf8_decode($config->address1));
##Writing the company zipcode+city
$pdf->SetFont('Arial', '', 9);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetXY(10, 50);
$pdf->Write(0, $config->zipcode . ' ' . utf8_decode($config->city));
##Writing the company phone
$pdf->SetFont('Arial', '', 9);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetXY(10, 55);
$pdf->Write(0, utf8_decode(JText::_('COM_TICKETMASTER_PHONE')) . ' ' . utf8_decode($config->phone));
##Writing the company email
$pdf->SetFont('Arial', '', 9);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetXY(10, 60);
$pdf->Write(0, $config->email);
##Writing the company website
$pdf->SetFont('Arial', '', 9);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetXY(10, 65);
$pdf->Write(0, $config->website);
$start_height = $pdf->GetY() + 10;
} else {
if (ini_get('magic_quotes_gpc') == '1') {
$body = stripslashes($config->address_format_company);
} else {
$body = utf8_decode($config->address_format_company);
}
$pdf->SetFont('Arial', '', 9);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetXY(10, 40);
$pdf->MultiCell(0, 5, "{$body}", 0, 'L', 0);
$start_height = $pdf->GetY() + 10;
}
################################################
## WRITING THE CUSTOMER INFORMATION ON TICKET ##
################################################
if ($order->gender == 1) {
$salutation = JText::_('COM_TICKETMASTER_MR');
} else {
if ($order->gender == 2) {
$salutation = JText::_('COM_TICKETMASTER_MRS');
} else {
if ($order->gender == 3) {
$salutation = JText::_('COM_TICKETMASTER_MISS');
} else {
$salutation = JText::_('COM_TICKETMASTER_FAMILY');
}
}
}
if ($config->address_format_client == '') {
## Writing the clientname.
$pdf->SetFont('Arial', '', 9);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetXY(135, 51);
if ($order->firstname == '') {
$pdf->Write(0, utf8_decode($order->name));
} else {
$pdf->Write(0, utf8_decode($salutation) . utf8_decode($order->firstname) . ' ' . utf8_decode($order->name));
}
## Writing the client address.
$pdf->SetFont('Arial', '', 9);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetXY(135, 55);
$pdf->Write(0, utf8_decode($order->address));
## Writing the zipcode & city.
$pdf->SetFont('Arial', '', 9);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetXY(135, 59);
$pdf->Write(0, $order->zipcode . ' ' . utf8_decode($order->city));
## Writing the zipcode & city.
$pdf->SetFont('Arial', '', 9);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetXY(135, 63);
$pdf->Write(0, $order->emailaddress);
} else {
$sql = 'SELECT * FROM #__ticketmaster_country
WHERE country_id = ' . $order->country_id . '';
$db->setQuery($sql);
$obj = $db->loadObject();
$client_address = str_replace('%%FIRSTNAME%%', utf8_decode($order->firstname), $config->address_format_client);
$client_address = str_replace('%%LASTNAME%%', utf8_decode($order->name), $client_address);
$client_address = str_replace('%%SALUTATION%%', utf8_decode($salutation), $client_address);
$client_address = str_replace('%%ADDRESS1%%', utf8_decode($order->address), $client_address);
$client_address = str_replace('%%ADDRESS2%%', utf8_decode($order->address2), $client_address);
$client_address = str_replace('%%ZIPCODE%%', utf8_decode($order->zipcode), $client_address);
$client_address = str_replace('%%CITY%%', utf8_decode($order->city), $client_address);
$client_address = str_replace('%%COUNTRY_FULL%%', utf8_decode($obj->country), $client_address);
$client_address = str_replace('%%COUNTRY_2D%%', utf8_decode($obj->country_2_code), $client_address);
$client_address = str_replace('%%COUNTRY_3D%%', utf8_decode($obj->country_3_code), $client_address);
if (ini_get('magic_quotes_gpc') == '1') {
$body = stripslashes($client_address);
} else {
$body = $client_address;
}
$pdf->SetFont('Arial', '', 9);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetXY(135, 51);
$pdf->MultiCell(0, 5, "{$body}", 0, 'L', 0);
}
## PRINT THE TICKETS NOW IN LIST ##
## FIRST WE HAVE TO GET ALL ITEMS FOR THIS TICKET ##
$sql = 'SELECT a.*, t.*, e.eventname, c.*,
t.ticketdate, t.starttime, t.location, t.locationinfo, a.paid, e.groupname, t.eventcode, t.show_end_date, t.end_date
FROM #__ticketmaster_orders AS a, #__ticketmaster_clients AS c,
#__ticketmaster_events AS e, #__ticketmaster_tickets AS t
WHERE a.userid = c.userid
AND a.eventid = e.eventid
AND a.ticketid = t.ticketid
AND ordercode = ' . $this->eid . '
GROUP BY a.orderid';
$db->setQuery($sql);
$data = $db->loadObjectList();
## Setting the order number:
$pdf->SetFont('Arial', '', 9);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetXY(10, $start_height);
$pdf->Write(0, utf8_decode(JText::_('COM_TICKETMASTER_ENTRANCE_TICKETS_FOR')) . ' ' . $this->eid);
## Writing the name customer:
$pdf->SetXY(10, $start_height + 5);
if ($order->firstname == '') {
$pdf->Write(0, utf8_decode(JText::_('COM_TICKETMASTER_TICKETS_FOR_CUSTOMER')) . ' ' . utf8_decode($order->name));
} else {
$pdf->Write(0, utf8_decode(JText::_('COM_TICKETMASTER_TICKETS_FOR_CUSTOMER')) . ' ' . utf8_decode($order->firstname) . ' ' . utf8_decode($order->name));
}
$pdf->SetXY(10, $start_height + 10);
$pdf->Write(0, utf8_decode(JText::_('COM_TICKETMASTER_TICKETS_ORDER_DATE')) . ' ' . $orderdate);
$pdf->SetDrawColor(0, 0, 0);
$pdf->Line(10, 105, 200, 105);
## Setting the startgrid, DO NOT change this!
$height = 105;
$height = $pdf->GetY() + 20;
## Setting font color & font for all items below:
$pdf->SetFont('Arial', '', 9);
$pdf->SetTextColor(0, 0, 0);
$k = 0;
for ($i = 0, $n = count($data); $i < $n; $i++) {
$row = $data[$i];
if ($row->seat_sector != 0) {
$sql = 'SELECT * FROM #__ticketmaster_coords WHERE id = ' . (int) $row->seat_sector . '';
$db->setQuery($sql);
$seat = $db->loadObject();
$seatnumber = JText::_('COM_TICKETMASTER_SEAT_NR') . ': ' . $seat->row_name . $seat->seatid;
$pdf->SetXY(10, $height + 2);
if ($row->parentname != $row->ticketname) {
$pdf->SetFont('Arial', '', 9);
$pdf->Write(0, utf8_decode($row->eventname) . ' (' . utf8_decode($row->eventcode) . ') - ' . utf8_decode($row->ticketname) . ' - ' . utf8_decode($seatnumber));
} else {
$pdf->SetFont('Arial', '', 9);
$pdf->Write(0, utf8_decode($row->eventcode) . ' / ' . utf8_decode($row->ticketname) . ' - ' . utf8_decode($seatnumber));
}
} else {
$pdf->SetXY(10, $height + 2);
if ($row->parentname != $row->ticketname) {
$pdf->SetFont('Arial', '', 9);
$pdf->Write(0, utf8_decode($row->eventname) . ' (' . utf8_decode($row->eventcode) . ') - ' . utf8_decode($row->ticketname));
} else {
$pdf->SetFont('Arial', '', 9);
$pdf->Write(0, utf8_decode($row->eventcode) . ' / ' . utf8_decode($row->ticketname));
}
}
$pdf->SetXY(10, $height + 7);
if ($row->show_end_date != 1) {
$ticketdate = date($config->dateformat, strtotime($row->ticketdate));
} else {
$ticketdate = date($config->dateformat, strtotime($row->ticketdate)) . ' - ' . date($config->dateformat, strtotime($row->end_date));
}
if ($config->use_euros_in_pdf == 2) {
## Fixing the euro issue..
$price = showprice($config->priceformat, $row->ticketprice, '');
$pdf->Write(0, utf8_decode(JText::_('COM_TICKETMASTER_ORDER')) . ' ' . $row->orderid . ' :: ' . utf8_decode(JText::_('COM_TICKETMASTER_PDF_PRICE')) . ' ' . chr(128) . ' ' . $price . ' :: ' . JText::_('COM_TICKETMASTER_PDF_DATE') . ' ' . $ticketdate);
} elseif ($config->use_euros_in_pdf == 3) {
$price = showprice($config->priceformat, $row->ticketprice, '');
$pdf->Write(0, utf8_decode(JText::_('COM_TICKETMASTER_ORDER')) . ' ' . $row->orderid . ' :: ' . utf8_decode(JText::_('COM_TICKETMASTER_PDF_PRICE')) . ' ' . chr(0xa3) . ' ' . $price . ' :: ' . JText::_('COM_TICKETMASTER_PDF_DATE') . ' ' . $ticketdate);
} else {
$price = showprice($config->priceformat, $row->ticketprice, $config->valuta);
$pdf->Write(0, utf8_decode(JText::_('COM_TICKETMASTER_ORDER')) . $row->orderid . ' :: ' . utf8_decode(JText::_('COM_TICKETMASTER_PDF_PRICE')) . ' ' . $price . ' :: ' . JText::_('COM_TICKETMASTER_PDF_DATE') . ' ' . $ticketdate);
}
## Getting the heigth for the closing line -- will only show after the for loop has been completed:
$y = $pdf->GetY();
## Creating the QR Code for printing.
if ($row->pdf_use_qrcode == 1) {
## Creating the code:
$code = $row->ordercode . $row->orderid;
## Getting the barcode from the EAN script.
$pdf->EAN13(1, 1, $code, $order->pdf_use_qrcode, 1);
$session = JFactory::getSession();
## Gettig the orderid if there is one.
$barcode = $session->get('barcode');
$remoteFile = 'http://chart.apis.google.com/chart?chs=' . $config->qr_width . 'x' . $config->qr_width . '&cht=qr&chld=L|0&chl=' . $barcode . '';
$localFile = JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_ticketmaster' . DS . 'classes' . DS . 'cache' . DS . $barcode . '.png';
self::get_qr_image($remoteFile, $localFile);
## Gettin the genrated code.
$cache_folder = JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_ticketmaster' . DS . 'classes' . DS . 'cache' . DS;
$pdf->Image($cache_folder . $barcode . '.png', 175, $height, 20, 20);
$pdf->SetDrawColor(193, 193, 193);
jimport('joomla.filesystem.file');
## We do want to remove the QR code again.
## It is not needed anymore, as ticket has been printed.
JFile::delete($cache_folder . $barcode . '.png');
$session->clear('barcode');
} else {
## Writing the code on the ticket.
$pdf->EAN13(160, $height, $row->barcode, 0);
$pdf->SetDrawColor(193, 193, 193);
$pdf->Line(10, $height + 20, 200, $height + 20);
}
$pdf->SetXY(10, $height + 12);
$pdf->SetFont('Arial', '', 9);
$pdf->Write(0, utf8_decode(JText::_('COM_TICKETMASTER_BARCODE')) . ': ' . $row->barcode);
$height = $height + 25;
## Path to a combined ticket is as below:
$combined_ticket = JPATH_SITE . DS . 'administrator' . DS . 'components' . DS . 'com_ticketmaster' . DS . 'tickets' . DS . 'eTickets-' . $this->eid . '.pdf';
## remove tickets if there is a combined one.
if (file_exists($combined_ticket)) {
jimport('joomla.filesystem.file');
JFile::delete($combined_ticket);
}
## Path to a normal ticket is as below:
$path = JPATH_SITE . DS . 'administrator' . DS . 'components' . DS . 'com_ticketmaster' . DS . 'tickets' . DS . 'eTicket-' . $row->orderid . '.pdf';
## Remove single ticket
if (file_exists($path)) {
jimport('joomla.filesystem.file');
JFile::delete($path);
}
$space_left = 290 - $pdf->GetY();
if ($space_left < 40) {
$pdf->AddPage();
// page break.
### setting the header for the page: (w) 210mm x (h) 90mm
$folder = JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_ticketmaster' . DS . 'assets' . DS . 'images' . DS;
$pdf->Image($folder . 'header.jpg', 0, 0, 210, 90);
## Set margin for next page:
$height = 50;
}
}
$file = basename(tempnam('.', 'tmp'));
rename($file, JPATH_SITE . DS . 'tmp' . DS . 'multi-' . $this->eid . '.pdf');
$file .= '.pdf';
## Save PDF to file now!!
$pdf->Output(JPATH_SITE . DS . 'tmp' . DS . $file, 'F');
## Now move the file away for security reasons
## Import the Joomla! Filesystem.
jimport('joomla.filesystem.file');
## Copy the file to a new directory.
$src = JPATH_SITE . DS . 'tmp' . DS . $file;
## The new name for the ticket
$dest = JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_ticketmaster' . DS . 'tickets' . DS . 'multi-' . $this->eid . '.pdf';
## Copy the file now.
JFile::copy($src, $dest);
## The old temporary file needs to be deleted.
JFile::delete($src);
}
