/** * Constructor * * For php4 compatability we must not use the __constructor as a constructor for * plugins because func_get_args ( void ) returns a copy of all passed arguments * NOT references. This causes problems with cross-referencing necessary for the * observer design pattern. */ function plgRDMediaRDMpaypal(&$subject, $params) { parent::__construct($subject, $params); ## Loading language: $lang = JFactory::getLanguage(); $lang->load('plg_rdmedia_paypal', JPATH_ADMINISTRATOR); ## load plugin params info $plugin =& JPluginHelper::getPlugin('rdmedia', 'rdmpaypal'); $this->pp_email = $this->params->def('pp_email', 2112); $this->currency = $this->params->def('currency', 'EUR'); $this->paypal_authcode = $this->params->def('paypal_authcode', 'EUR'); $this->sandbox_on = $this->params->def('sandbox_on', 1); $this->success_tpl = $this->params->def('success_tpl', 1); $this->failure_tpl = $this->params->def('failure_tpl', 1); $this->itemid = $this->params->def('itemid', 1); $this->infobox = $this->params->def('infobox', 'enter a message in the backend.'); $this->layout = $this->params->def('layout', 0); ## 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; ## Getting the global DB session $session =& JFactory::getSession(); ## Gettig the orderid if there is one. $this->ordercode = $session->get('ordercode'); ## Getting the amounts for this order. $this->amount = _getAmount($this->ordercode); $this->fees = _getFees($this->ordercode); ## Return URLS to your website after processing the order. $this->return_url = JURI::root() . 'index.php?option=com_ticketmaster&view=transaction&payment_type=paypal&Itemid=' . $this->itemid; $this->cancel_url = JURI::root() . 'index.php?option=com_ticketmaster&view=transaction&payment_type=paypal_failed&Itemid=' . $this->itemid; ## Use the sandbox if you're testing. (Required: Sandbox Account with PayPal) if ($this->sandbox_on == 1) { ## We're in a testing environment. $this->url = 'https://www.sandbox.paypal.com/cgi-bin/webscr'; } else { ## Use the lines below for a live site. $this->url = 'https://www.paypal.com/cgi-bin/webscr'; } }
$document->addScript(JURI::root(true) . '/administrator/components/com_ticketmaster/assets/lightbox/mediabox.js'); $document->addStyleSheet(JURI::root(true) . '/administrator/components/com_ticketmaster/assets/lightbox/mediabox.css'); ## Getting the global DB session $session =& JFactory::getSession(); ## Gettig the orderid if there is one. $ordercode = $session->get('ordercode'); include_once 'components/com_ticketmaster/assets/functions.php'; ## 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; ## Including required paths to calculator. $path_include = JPATH_SITE . DS . 'components' . DS . 'com_ticketmaster' . DS . 'assets' . DS . 'helpers' . DS . 'encrypt.ordercode.php'; include_once $path_include; ## Getting the total to pay :) $ordertotal = _getAmount($ordercode); $fees = _getFees($ordercode); $discount = _getDiscount($ordercode); $count = count($this->items); ## Check if this is Joomla 2.5 or 3.0.+ $isJ30 = version_compare(JVERSION, '3.0.0', 'ge'); if (!$isJ30) { JHTML::_('behavior.mootools'); if ($this->config->load_bootstrap == 1) { ## Adding mootools for J!2.5 JHTML::_('behavior.modal'); ## Include the tooltip behaviour. JHTML::_('behavior.tooltip', '.hasTip'); $document->addScript('https://code.jquery.com/jquery-latest.js'); $document->addStyleSheet(JURI::root(true) . '/administrator/components/com_ticketmaster/assets/bootstrap/css/bootstrap.css'); $document->addScript(JURI::root(true) . '/administrator/components/com_ticketmaster/assets/bootstrap/js/bootstrap.js'); $button = 'btn';
$document->addScript(JURI::root(true) . '/administrator/components/com_ticketmaster/assets/bootstrap/js/bootstrap.js'); } $document->addScript(JURI::root(true) . '/components/com_ticketmaster/assets/j3-lightbox/js/jquery.colorbox.js'); $document->addScript(JURI::root(true) . '/components/com_ticketmaster/assets/j3-lightbox/js/colorbox.js'); $document->addStyleSheet(JURI::root(true) . '/components/com_ticketmaster/assets/j3-lightbox/css/colorbox.css'); include_once 'components/com_ticketmaster/assets/functions.php'; ## Getting the global DB session $session =& JFactory::getSession(); ## Gettig the orderid if there is one. $ordercode = $session->get('ordercode'); ## 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 for this order: $total = _getAmount($session->get('ordercode')); $fees = _getFees($session->get('ordercode')); $ordertotal = $total - $fees; ## Getting the parameters for this view: $params = JComponentHelper::getParams('com_ticketmaster'); $gmaps_width = $params->get('gmaps_width', '200'); $gmaps_heigth = $params->get('gmaps_heigth', '200'); $show_venuebuttons = $params->get('show_venuebuttons', 1); $button_color = $params->get('button_color', 'btn'); $show_venue_events = $params->get('show_venue_events', '1'); $show_venuedetails = $params->get('show_venuedetails', '1'); $button_color = $params->get('button_color', 'btn'); $button = 'btn ' . $button_color; ## Redirection link in JRoute: $gotocart = JRoute::_('index.php?option=com_ticketmaster&view=cart'); if ($this->extended->seat_chart != '') { $image = JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_ticketmasterext' . DS . 'assets' . DS . 'seatcharts' . DS . $this->extended->seat_chart;
public function doConfirm() { global $mainframe, $option; $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; ## Date definition - Change if you like. $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 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(); ## set the sourcefile $sourcePDF = JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_ticketmaster' . DS . 'assets' . DS . 'orderconfirmation.pdf'; $pdf->setSourceFile($sourcePDF); ## 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, 210); ## 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 ## ############################################# ## Writing the orderdate on the confirmation. $pdf->SetFont('Arial', '', 9); $pdf->SetTextColor(0, 0, 0); $pdf->SetXY(7, 63); $pdf->Write(0, JText::_('COM_TICKETMASTER_ORDERDATE') . ': ' . $orderdate); ############################################### ## WRITING THE COMPANY INFORMATION ON TICKET ## ############################################### ##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); ################################################ ## WRITING THE CUSTOMER INFORMATION ON TICKET ## ################################################ ## Writing the clientname. $pdf->SetFont('Arial', '', 9); $pdf->SetTextColor(0, 0, 0); $pdf->SetXY(135, 51); $pdf->Write(0, 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); ############################################# ## WRITING THE ORDER CONFIRMATION TEXT ## ############################################# ## Writing the orderdate on the confirmation. $pdf->SetFont('Arial', '', 11); $pdf->SetTextColor(0, 0, 0); $pdf->SetXY(7, 79); $pdf->Write(0, utf8_decode(JText::_('COM_TICKETMASTER_ORDERCONFIRMATION')) . ' ' . $this->eid); ############################################# ## WRITING THE GRID TOP TEXTURES HERE ## ############################################# $pdf->SetFont('Arial', 'B', 9); $pdf->SetTextColor(0, 0, 0); $pdf->SetXY(14, 88); $pdf->Write(0, JText::_('ID#')); $pdf->SetFont('Arial', 'B', 9); $pdf->SetTextColor(0, 0, 0); $pdf->SetXY(27, 88); $pdf->Write(0, utf8_decode(JText::_('COM_TICKETMASTER_TICKETINFORMATION'))); $pdf->SetFont('Arial', 'B', 9); $pdf->SetTextColor(0, 0, 0); $pdf->SetXY(129, 88); $pdf->Write(0, utf8_decode(JText::_('COM_TICKETMASTER_DATE'))); $pdf->SetFont('Arial', 'B', 9); $pdf->SetTextColor(0, 0, 0); $pdf->SetXY(159, 88); $pdf->Write(0, utf8_decode(JText::_('COM_TICKETMASTER_TIME'))); $pdf->SetFont('Arial', 'B', 9); $pdf->SetTextColor(0, 0, 0); $pdf->SetXY(182, 88); $pdf->Write(0, utf8_decode(JText::_('COM_TICKETMASTER_PRICE'))); ############################################# ## WRITING THE GRID - PLEASE DONT CHANGE ## ############################################# ## 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); $items = $db->loadObjectList(); ## Setting the startgrid, DON'T change this! $height1 = 100; $height2 = 104; $totalprice = 0.0; ## 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]; ## Writing the itemid on the left collumn ## Make sure they are centered, see function below $chars = strlen($row->orderid); if ($chars == 1) { $pdf->SetXY(15, $height1); } if ($chars == 2) { $pdf->SetXY(13, $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->orderid); ## Event information, first line $pdf->SetXY(27, $height1); if ($row->parentname != $row->ticketname) { $pdf->Write(0, utf8_decode($row->eventcode) . ' / ' . utf8_decode($row->parentname) . ' - ' . utf8_decode($row->ticketname)); } else { $pdf->Write(0, utf8_decode($row->eventcode) . ' / ' . utf8_decode($row->ticketname)); } ## Event information, second line $pdf->SetXY(27, $height2); $pdf->Write(0, utf8_decode($row->location) . ' - ' . utf8_decode($row->locationinfo)); ## Event information, the date field $pdf->SetXY(125, $height1); $ticketdate = date($config->dateformat, strtotime($order->ticketdate)); $pdf->Write(0, $ticketdate); ## 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 == 1) { ## Fixing the euro issue.. $price = showprice($config->priceformat, $row->ticketprice, ''); $price = chr(128) . ' ' . $price; } elseif ($config->use_euros_in_pdf == 2) { $price = showprice($config->priceformat, $row->ticketprice, ''); $price = chr(0xa3) . ' ' . $price; } else { $price = showprice($config->priceformat, $row->ticketprice, $config->valuta); } $pdf->SetXY(178, $height1); $pdf->Write(0, $price); ## Add extra row to the FOR loop. $height1 = $height1 + 10; $height2 = $height2 + 10; $totalprice = (double) $totalprice + $price; $k = 1 - $k; } ############################################# ## WRITING THE TOTALS OF THE ORDER ## ############################################# $pdf->Line(174, 250, 200, 250); ## 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); $fees = _getFees($this->eid); if ($config->use_euros_in_pdf == 1) { ## Fixing the euro issue.. $price = showprice($config->priceformat, $total - $fees, ''); $price = chr(128) . ' ' . $price; } elseif ($config->use_euros_in_pdf == 2) { $price = showprice($config->priceformat, $total - $fees, ''); $price = chr(0xa3) . ' ' . $price; } else { $price = showprice($config->priceformat, $total - $fees, $config->valuta); } ## Event information, the price field $pdf->SetXY(175, 255); $pdf->Write(0, $price); if ($config->variable_transcosts == 1) { ## Event information, the price field $pdf->SetXY(150, 259); $pdf->Write(0, utf8_decode(JText::_('COM_TICKETMASTER_TOTALFEE'))); ## Event information, the price field $pdf->SetXY(150, 267); $pdf->Write(0, utf8_decode(JText::_('COM_TICKETMASTER_TOTAL'))); if ($config->use_euros_in_pdf == 1) { ## Fixing the euro issue.. $price = showprice($config->priceformat, $fees, ''); $price = chr(128) . ' ' . $price; } elseif ($config->use_euros_in_pdf == 2) { $price = showprice($config->priceformat, $fees, ''); $price = chr(0xa3) . ' ' . $price; } else { $price = showprice($config->priceformat, $fees, $config->valuta); } $pdf->SetXY(175, 259); $pdf->Write(0, $price); ## Draw a line to count total amount $pdf->Line(174, 263, 200, 263); if ($config->use_euros_in_pdf == 1) { ## Fixing the euro issue.. $price = showprice($config->priceformat, $total, ''); $price = chr(128) . ' ' . $price; } elseif ($config->use_euros_in_pdf == 2) { $price = showprice($config->priceformat, $total, ''); $price = chr(0xa3) . ' ' . $price; } else { $price = showprice($config->priceformat, $total, $config->valuta); } $pdf->SetXY(175, 267); $pdf->Write(0, $price); $pdf->SetXY(150, 255); $pdf->Write(0, utf8_decode(JText::_('COM_TICKETMASTER_SUBTOTAL'))); } else { if ($config->transactioncosts != 0) { ## Event information, the price field $pdf->SetXY(150, 259); $pdf->Write(0, utf8_decode(JText::_('COM_TICKETMASTER_TOTALFEE'))); ## Event information, the price field $pdf->SetXY(150, 267); $pdf->Write(0, utf8_decode(JText::_('COM_TICKETMASTER_TOTAL'))); $totalfee = $config->transactioncosts; $fees = number_format($totalfee, 2, ',', '.'); if ($config->use_euros_in_pdf == 1) { ## Fixing the euro issue.. $price = showprice($config->priceformat, $config->transactioncosts, ''); $price = chr(128) . ' ' . $price; } elseif ($config->use_euros_in_pdf == 2) { $price = showprice($config->priceformat, $config->transactioncosts, ''); $price = chr(0xa3) . ' ' . $price; } else { $price = showprice($config->priceformat, $config->transactioncosts, $config->valuta); } $pdf->SetXY(175, 259); $pdf->Write(0, $price); ## Draw a line to count total amount $pdf->Line(174, 263, 200, 263); if ($config->use_euros_in_pdf == 1) { ## Fixing the euro issue.. $price = showprice($config->priceformat, $total, ''); $price = chr(128) . ' ' . $price; } elseif ($config->use_euros_in_pdf == 2) { $price = showprice($config->priceformat, $total, ''); $price = chr(0xa3) . ' ' . $price; } else { $price = showprice($config->priceformat, $total, $config->valuta); } $pdf->SetXY(175, 267); $pdf->Write(0, $price); $pdf->SetXY(150, 255); $pdf->Write(0, utf8_decode(JText::_('COM_TICKETMASTER_SUBTOTAL'))); } } $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 remove() { $orderid = JRequest::getInt('orderid', 0); ## Getting the database. $db = JFactory::getDBO(); $session =& JFactory::getSession(); $ordercode = $session->get('ordercode'); ## Making the tickets inactive, they still be present at the database. $update = 'SELECT o.* , t.parent AS parentticket FROM #__ticketmaster_orders AS o, #__ticketmaster_tickets AS t WHERE orderid = ' . (int) $orderid . ' AND o.ticketid = t.ticketid AND ordercode = ' . $ordercode . ''; $db->setQuery($update); $tdata = $db->loadObject(); ## Update the tickets-totals that where removed. $query = 'UPDATE #__ticketmaster_tickets' . ' SET totaltickets = totaltickets+1' . ' WHERE ticketid = ' . (int) $tdata->ticketid . ' '; ## 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 ($tdata->parentticket != 0) { ## Update the tickets-totals that where removed. $query = 'UPDATE #__ticketmaster_tickets' . ' SET totaltickets = totaltickets+1' . ' WHERE ticketid = ' . $tdata->parentticket . ' '; ## 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 ($tdata->seat_sector != 0) { $query = 'UPDATE #__ticketmaster_coords SET booked = 0, orderid = 0 WHERE orderid = ' . $tdata->orderid . ' '; ## Do the query now $db->setQuery($query); ## When query goes wrong.. Show message with error. if (!$db->query()) { $this->setError = $db->getErrorMsg(); return false; } } ## Now delete the selected tickets. $query = 'DELETE FROM #__ticketmaster_orders WHERE orderid = "' . (int) $orderid . '" AND ordercode = "' . (int) $ordercode . '" '; ## Do the query now and delete all selected invoices. $db->setQuery($query); ## When query goes wrong.. Show message with error. if (!$db->query()) { $this->setError($db->getErrorMsg()); return false; } ## Making the query for showing all the cars in list function $sql = 'SELECT * FROM #__ticketmaster_config WHERE configid = 1'; $db->setQuery($sql); $data = $db->loadObject(); ## Including some functionality. include_once 'components/com_ticketmaster/assets/functions.php'; ## 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 for this order: $total = _getAmount($session->get('ordercode')); $fees = _getFees($session->get('ordercode')); $order = $total - $fees; $result = showprice($data->priceformat, $order, $data->valuta); echo $result; }
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); }