public static function generateCSVFile($backend, $cid = 0, $bookings = null, $kurs = null) { $db = JFactory::getDbo(); // Load event only if we are not in the backend / or got an whole event to print if (!$backend) { $kurs = MatukioHelperUtilsEvents::getEventRecurring($cid); } $tmpl = MatukioHelperTemplates::getTemplate("export_csv"); if (!empty($kurs)) { $db->setQuery("SELECT a.*, cc.*, a.id AS sid, a.name AS aname, a.email AS aemail FROM #__matukio_bookings AS a " . "LEFT JOIN #__users AS cc ON cc.id = a.userid WHERE a.semid = '" . $kurs->id . "' AND (a.status = 0 OR a.status = 1) ORDER BY a.id"); } elseif (count($bookings)) { $db->setQuery("SELECT a.*, cc.*, a.id AS sid, a.name AS aname, a.email AS aemail FROM #__matukio_bookings AS a " . "LEFT JOIN #__users AS cc ON cc.id = a.userid WHERE a.id IN (" . implode(",", $bookings) . ") ORDER BY a.id"); } else { throw new Exception("No data supplied (bookings / event)"); } $bookings = $db->loadObjectList(); if ($db->getErrorNum()) { throw new Exception($db->stderr()); } $csvdata = MatukioHelperTemplates::getCSVHeader($tmpl, $kurs); $csvdata .= MatukioHelperTemplates::getCSVData($tmpl, $bookings, $kurs); return $csvdata; }
<?php /** * @package Matukio * @author Yves Hoppe <*****@*****.**> * @date 29.01.14 * * @copyright Copyright (C) 2008 - 2014 compojoom.com . All rights reserved. * @license GNU General Public License version 2 or later; see LICENSE */ defined('_JEXEC') or die('Restricted access'); $database = JFactory::getDBO(); if (!empty($this->uuid)) { $database->setQuery("SELECT * FROM #__matukio_bookings WHERE uuid='" . $this->uuid . "'"); } $booking = $database->loadObject(); $kurs = MatukioHelperUtilsEvents::getEventRecurring($booking->semid); $tmpl_code = MatukioHelperTemplates::getTemplate("ticket")->value; // Parse language strings $tmpl_code = MatukioHelperTemplates::replaceLanguageStrings($tmpl_code); $replaces = MatukioHelperTemplates::getReplaces($kurs, $booking); foreach ($replaces as $key => $replace) { $tmpl_code = str_replace($key, $replace, $tmpl_code); } $subject = "TICKET"; MatukioHelperPDF::generateTicket($booking, $tmpl_code, $subject); exit;
<?php echo MatukioHelperUtilsEvents::getFormatedCurrency($this->booking->payment_brutto, MatukioHelperSettings::getSettings('currency_symbol', '$')); ?> </td> </tr> <?php if (MatukioHelperSettings::getSettings('oldbookingform', 0) == 0) { ?> <tr> <td class="key" width="150px"><?php echo JText::_("COM_MATUKIO_FIELD_PAYMENT_METHOD"); ?> </td> <td> <?php echo MatukioHelperTemplates::getPaymentMethodTitle($this->booking->payment_method); ?> </td> </tr> <?php } ?> <tr> <td class="key"><?php echo JText::_("COM_MATUKIO_YOUR_PAYMENT_STATUS"); ?> </td> <td> <?php if ($this->booking->paid) { echo JText::_("COM_MATUKIO_PAID");
/** * Gets the invoice * * @param string $booking - The booking * @param string $kurs - The event * @param string $subject - The subject * @param string $destination - The destination * * @return string */ public static function getTicket($booking, $kurs, $subject = "Ticket", $destination = "D") { $tmpl_code = MatukioHelperTemplates::getTemplate("ticket")->value; // Parse language strings $tmpl_code = MatukioHelperTemplates::replaceLanguageStrings($tmpl_code); $replaces = MatukioHelperTemplates::getReplaces($kurs, $booking); foreach ($replaces as $key => $replace) { $tmpl_code = str_replace($key, $replace, $tmpl_code); } return MatukioHelperPDF::generateTicket($booking, $tmpl_code, $subject, $destination); }
$tmpl = MatukioHelperTemplates::getParsedExportTemplateHeadding($tmpl, $kurs); echo "\n<body onload=\" parent.sbox-window.focus(); parent.sbox-window.print(); \">"; echo "<div class=\"compojoom-bootstrap\">"; if (!empty($tmpl->subject)) { echo "\n<br /><center><span class=\"sem_list_title\">" . JTEXT::_($tmpl->subject) . "</span></center><br />"; } /* Header before out of value_text */ if (!empty($kurs)) { echo $tmpl->value_text; } /* Participants */ // Move to function $i = 1; $ptable = ""; foreach ($bookings as $b) { // We are in the backend with bookings instead of an event! if (empty($cid)) { $kurs = MatukioHelperUtilsEvents::getEventRecurring($b->semid); } $replaces = MatukioHelperTemplates::getReplaces($kurs, $b, $i); $participant_line = $tmpl->value; foreach ($replaces as $key => $replace) { $participant_line = str_replace($key, $replace, $participant_line); } $ptable .= $participant_line; $i++; } echo $ptable; echo "<br />" . MatukioHelperUtilsBasic::getCopyright(); echo "</div>"; echo "</body>";