if (!isset($this->backend)) { $cid = JFactory::getApplication()->input->getInt('cid', 0); $kurs = MatukioHelperUtilsEvents::getEventRecurring($cid); } if (!empty($kurs)) { $database->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 (isset($this->bookings)) { if (count($this->bookings)) { $database->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(",", $this->bookings) . ") ORDER BY a.id"); } } else { throw new Exception("No data supplied (bookings / event)"); } $bookings = $database->loadObjectList(); if ($this->art > 2) { echo MatukioHelperUtilsBasic::getHTMLHeader(); $this->art -= 2; } $tmpl = MatukioHelperTemplates::getTemplate("export_participantslist"); $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
/** * @package Matukio * @author Yves Hoppe <*****@*****.**> * @date 03.04.13 * * @copyright Copyright (C) 2008 - 2014 Yves Hoppe - compojoom.com . All rights reserved. * @license GNU General Public License version 2 or later; see LICENSE */ defined('_JEXEC') or die('Restricted access'); $document = JFactory::getDocument(); $database = JFactory::getDBO(); $neudatum = MatukioHelperUtilsDate::getCurrentDate(); JHTML::_('behavior.modal'); JHTML::_('stylesheet', 'media/com_matukio/css/matukio.css'); CompojoomHtmlBehavior::bootstrap31(false, false, false, false); $html = MatukioHelperUtilsBasic::getHTMLHeader(); $neudatum = MatukioHelperUtilsDate::getCurrentDate(); $html .= "\n<body onload=\" parent.sbox-window.focus(); parent.sbox-window.print(); \">"; $html .= "<div class=\"compojoom-bootstrap\">"; $html .= "\n<br /><center><span class=\"sem_list_title\">" . $this->headertext . "</span><br /><span class=\"sem_list_date\">" . JHTML::_('date', $neudatum, MatukioHelperSettings::getSettings('date_format_small', 'd-m-Y, H:i')) . "</span></center><br />"; $k = 0; for ($i = 0, $n = count($this->rows); $i < $n; $i++) { $row = $this->rows[$i]; $gebucht = MatukioHelperUtilsEvents::calculateBookedPlaces($row); $gebucht = $gebucht->booked; $freieplaetze = $row->maxpupil - $gebucht; if ($freieplaetze < 0) { $freieplaetze = 0; } $html .= MatukioHelperUtilsEvents::getTableHeader(4, "sem_list"); $html .= "<tr>" . MatukioHelperUtilsEvents::getTableCell($row->title, 'd', 'c', '100%', 'sem_list_head', 2) . "</tr>";