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>";
