/**
* Displays the participant edit form
*
* @param string $tpl - The template
*
* @throws Exception
* @return mixed|void
*/
public function display($tpl = null)
{
$booking_id = JFactory::getApplication()->input->getInt('booking_id', 0);
$model = $this->getModel();
$booking = null;
if (!empty($booking_id)) {
$booking = $model->getBooking();
}
if (!$booking) {
$booking = JTable::getInstance('bookings', 'Table');
$event_id = JFactory::getApplication()->input->getInt("event_id", 0);
if (!empty($event_id)) {
$booking->semid = $event_id;
}
$booking->uuid = MatukioHelperPayment::getUuid(true);
}
$db = JFactory::getDbo();
$db->setQuery("SELECT r.id AS value, CONCAT(a.title, ' ', r.begin) AS text FROM #__matukio_recurring AS r LEFT JOIN #__matukio AS a ON r.event_id = a.id ");
$events = (array) $db->loadObjectList();
$this->event_select = JHtml::_('select.genericlist', $events, 'event_id', '', 'value', 'text', $booking->semid);
$dispatcher = JDispatcher::getInstance();
JPluginHelper::importPlugin("payment");
$gateways = $dispatcher->trigger('onTP_GetInfo', array(MatukioHelperPayment::$matukio_payment_plugins));
$payment = array();
foreach ($gateways as $gway) {
$payment[] = array("name" => $gway->id, "title" => $gway->name);
}
// Booking status
$options[] = array("value" => MatukioHelperUtilsBooking::$PENDING, "text" => MatukioHelperUtilsBooking::getBookingStatusName(MatukioHelperUtilsBooking::$PENDING));
$options[] = array("value" => MatukioHelperUtilsBooking::$ACTIVE, "text" => MatukioHelperUtilsBooking::getBookingStatusName(MatukioHelperUtilsBooking::$ACTIVE));
$options[] = array("value" => MatukioHelperUtilsBooking::$WAITLIST, "text" => MatukioHelperUtilsBooking::getBookingStatusName(MatukioHelperUtilsBooking::$WAITLIST));
$options[] = array("value" => MatukioHelperUtilsBooking::$ARCHIVED, "text" => JText::_("COM_MATUKIO_ARCHIVED"));
$options[] = array("value" => MatukioHelperUtilsBooking::$DELETED, "text" => JText::_("COM_MATUKIO_DELETED"));
$this->status_select = JHtml::_('select.genericlist', $options, 'status', '', 'value', 'text', $booking->status);
$marks[] = array("value" => 0, "text" => JText::_("COM_MATUKIO_NONE"));
$marks[] = array("value" => 1, "text" => "1");
$marks[] = array("value" => 2, "text" => "2");
$marks[] = array("value" => 3, "text" => "3");
$marks[] = array("value" => 4, "text" => "4");
$marks[] = array("value" => 5, "text" => "5");
$marks[] = array("value" => 6, "text" => "6");
$this->mark_select = JHtml::_('select.genericlist', $marks, 'mark', '', 'value', 'text', $booking->mark);
$this->select_checkedin = MatukioHelperInput::getRadioButtonBool("checked_in", "checked_in", $booking->checked_in);
$this->booking = $booking;
$this->payment = $payment;
$this->addToolbar();
parent::display($tpl);
}
"/>
<input type="hidden" name="event_id" value="<?php
echo $this->event->id;
?>
"/>
<input type="hidden" name="catid" value="<?php
echo $this->event->catid;
?>
"/>
<input type="hidden" name="semid" value="<?php
echo $this->event->id;
?>
"/>
<input type="hidden" name="userid" value="<?php
echo $this->user->id;
?>
"/>
<input type="hidden" name="uuid" value="<?php
echo MatukioHelperPayment::getUuid(true);
?>
"/>
<input type="hidden" name="ccval" value="<?php
if (!empty($captchatext)) {
echo md5($captchatext);
}
?>
"/>
</form>
<?php
echo MatukioHelperUtilsBasic::getCopyright();
/**
* $cattable->id = null;
* $cattable->asset_id = 0;
* $cattable->parent_id = 0;
* $cattable->lft = 0;
* $cattable->rgt = 0;
* $cattable->level = 1;
* $cattable->path = "test";
* $cattable->extension = "com_matukio";
* $cattable->title = "";
* $cattable->alias = "";
* $cattable->note = "";
* $cattable->description = "";
* $cattable->published = "";
* $cattable->checked_out = 0;
* $cattable->checked_out_time = "0000-00-00 00:00:00";
* $cattable->access = "";
* $cattable->params = "";
*
* $cattable->metadesc = "";
* $cattable->metakey = "";
* $cattable->metadata = "";
* $cattable->created_user_id = "";
* $cattable->created_time = "";
* $cattable->modified_user_id = "";
* $cattable->hits = "";
* $cattable->language = "";
*/
public function importseminar()
{
$input = JFactory::getApplication()->input;
$db = JFactory::getDbo();
$seminar_table = $input->get('seminar_table', '');
$seminar_category_table = $input->get('seminar_category_table', '');
$seminar_booking_table = $input->get('seminar_booking_table', '');
$seminar_number_table = $input->get('seminar_number_table', '');
// Load old categories
$query = $db->getQuery(true);
$query->select("*")->from($seminar_category_table)->where("section = " . $db->quote("com_seminar"));
$db->setQuery($query);
$cats = $db->loadObjectList();
$insert_id = null;
$relationsDb = array();
$user = JFactory::getUser();
$i = 0;
$table = JTable::getInstance('Category', 'JTable');
$dispatcher = JDispatcher::getInstance();
JPluginHelper::importPlugin('content');
foreach ($cats as $cat) {
// Import category into Joomla 2.5 #__categories table
$old_id = $cat->id;
$cat->name = html_entity_decode($cat->title);
$cat->path = $cat->name;
$cat->alias = $cat->alias;
$cat->parent = 1;
$cat->author = $user->id;
$new_id = $this->insertCategory($cat);
if ($new_id == -1) {
break;
}
$dispatcher->trigger('onContentAfterSave', array('com_content.category.' . $insert_id, &$table, true));
$relationsDb[] = $db->quote($new_id) . ',' . $i . ',' . $old_id;
// Get the events for the category
$query = $db->getQuery(true);
$query->select("*")->from($seminar_table)->where("catid = " . $old_id);
$db->setQuery($query);
$events = $db->loadObjectList();
foreach ($events as $event) {
$mattab = JTable::getInstance('Matukio', 'Table');
$old_event_id = $event->id;
// Reset event id
$event->id = null;
$event->created_by = $user->id;
$event->catid = $new_id;
if (!$mattab->bind($event)) {
JError::raiseError(500, $mattab->getError());
}
// Zuweisung der Startzeit
$mattab->begin = JFactory::getDate($event->begin, MatukioHelperUtilsBasic::getTimeZone())->format('Y-m-d H:i:s', false, false);
// Zuweisung der Endzeit
$mattab->end = JFactory::getDate($event->end, MatukioHelperUtilsBasic::getTimeZone())->format('Y-m-d H:i:s', false, false);
// Zuweisung der Buchungszeit
$mattab->booked = JFactory::getDate($event->booked, MatukioHelperUtilsBasic::getTimeZone())->format('Y-m-d H:i:s', false, false);
if (!$mattab->check()) {
JError::raiseError(500, $db->stderr());
}
if (!$mattab->store()) {
JError::raiseError(500, $db->stderr());
}
$mattab->checkin();
// Add recurring event date
$rid = MatukioHelperRecurring::saveRecurringDateForEvent($mattab);
// Get the event bookings for this event
$query = $db->getQuery(true);
$query->select("*")->from($seminar_booking_table)->where("semid = " . $old_event_id);
$db->setQuery($query);
$bookings = $db->loadObjectList();
foreach ($bookings as $booking) {
// Reset
$booking->id = null;
// Update 3.1 - we need the recurring id not the event id
$booking->semid = $rid;
$booking->uuid = MatukioHelperPayment::getUuid(true);
// Calculating payment
$booking->payment_brutto = $mattab->fees * $booking->nrbooked;
// No taxes here -> user is goign to add them later
$booking->payment_netto = $booking->payment_brutto;
$booking->payment_tax = 0.0;
$booktable = JTable::getInstance('Bookings', 'Table');
if (!$booktable->bind($booking)) {
JError::raiseError(500, $booktable->getError());
}
if (!$booktable->check()) {
JError::raiseError(500, $db->stderr());
}
if (!$booktable->store()) {
JError::raiseError(500, $db->stderr());
}
}
}
$i++;
}
// Import Numbers
$query = $db->getQuery(true);
$query->select("*")->from($seminar_number_table);
$db->setQuery($query);
$numbers = $db->loadObjectList();
foreach ($numbers as $number) {
$numtable = JTable::getInstance("Number", "Table");
if (!$numtable->bind($number)) {
JError::raiseError(500, $numtable->getError());
}
if (!$numtable->check()) {
JError::raiseError(500, $db->stderr());
}
if (!$numtable->store()) {
JError::raiseError(500, $db->stderr());
}
}
$msg = JText::_("COM_MATUKIO_IMPORT_SUCCESSFULLY");
$link = 'index.php?option=com_matukio&view=import';
$this->setRedirect($link, $msg);
}
}
foreach ($fields as $field) {
if (!empty($value[$field->id])) {
MatukioHelperUtilsBooking::printFieldElement($field, false, $value[$field->id]);
} else {
MatukioHelperUtilsBooking::printFieldElement($field, false, -1);
}
}
if ($event->fees > 0) {
echo '<tr>';
echo '<td class="key" width="100px">';
echo JText::_("COM_MATUKIO_FIELD_PAYMENT_METHOD");
echo " <span class=\"mat_req\">*</span>";
echo '</td>';
echo '<td>';
echo MatukioHelperPayment::getPaymentSelect($this->payment, $this->booking->payment_method);
echo '</td>';
echo '</tr>';
// Payment Coupon codes
if (MatukioHelperSettings::getSettings("payment_coupon", 1) == 1) {
?>
<tr>
<td class="key" width="100px">
<?php
echo JText::_("COM_MATUKIO_FIELD_COUPON");
?>
</td>
<td>
<input class="text_area" type="text" name="coupon_code"
id="coupon_code" value="" size="50"
maxlength="255" style="width: 150px"
/**
* Save old booking form event
*
* @return object
*/
function saveoldevent()
{
// Check authorization
if (!JFactory::getUser()->authorise('core.edit', 'com_matukio')) {
return JError::raiseWarning(404, JText::_('JERROR_ALERTNOAUTHOR'));
}
$database = JFactory::getDBO();
$input = JFactory::getApplication()->input;
$art = 4;
$event_id = $input->getInt('event_id', 0);
$uid = 0;
$notify_participant = $input->getInt("notify_participant", 0);
$notify_participant_invoice = $input->getInt("notify_participant_invoice", 0);
$uuid = $input->get('uuid', 0, 'string');
$nrbooked = $input->getInt('nrbooked', 1);
$userid = $input->getInt('userid', 0);
if (empty($event_id)) {
return JError::raiseError(404, 'COM_MATUKIO_NO_ID');
}
// Load event (use model function)
$emodel = JModelLegacy::getInstance('Event', 'MatukioModel');
$event = $emodel->getItem($event_id);
$reason = "";
if (!empty($uid)) {
// Setting booking to changed booking
$userid = $uid;
// uid = Negativ
}
if ($art == 4) {
$allesok = 1;
$ueber1 = JTEXT::_('COM_MATUKIO_BOOKING_WAS_SUCCESSFULL');
}
// Buchung eintragen
$neu = JTable::getInstance('bookings', 'Table');
if (!$neu->bind(JRequest::get('post'))) {
return JError::raiseError(500, $database->stderr());
}
$neu->semid = $event->id;
$neu->userid = $userid;
$neu->bookingdate = MatukioHelperUtilsDate::getCurrentDate();
$neu->name = MatukioHelperUtilsBasic::cleanHTMLfromText($neu->name);
$neu->email = MatukioHelperUtilsBasic::cleanHTMLfromText($neu->email);
$neu->zusatz1 = MatukioHelperUtilsBasic::cleanHTMLfromText($neu->zusatz1);
$neu->zusatz2 = MatukioHelperUtilsBasic::cleanHTMLfromText($neu->zusatz2);
$neu->zusatz3 = MatukioHelperUtilsBasic::cleanHTMLfromText($neu->zusatz3);
$neu->zusatz4 = MatukioHelperUtilsBasic::cleanHTMLfromText($neu->zusatz4);
$neu->zusatz5 = MatukioHelperUtilsBasic::cleanHTMLfromText($neu->zusatz5);
$neu->zusatz6 = MatukioHelperUtilsBasic::cleanHTMLfromText($neu->zusatz6);
$neu->zusatz7 = MatukioHelperUtilsBasic::cleanHTMLfromText($neu->zusatz7);
$neu->zusatz8 = MatukioHelperUtilsBasic::cleanHTMLfromText($neu->zusatz8);
$neu->zusatz9 = MatukioHelperUtilsBasic::cleanHTMLfromText($neu->zusatz9);
$neu->zusatz10 = MatukioHelperUtilsBasic::cleanHTMLfromText($neu->zusatz10);
$neu->zusatz11 = MatukioHelperUtilsBasic::cleanHTMLfromText($neu->zusatz11);
$neu->zusatz12 = MatukioHelperUtilsBasic::cleanHTMLfromText($neu->zusatz12);
$neu->zusatz13 = MatukioHelperUtilsBasic::cleanHTMLfromText($neu->zusatz13);
$neu->zusatz14 = MatukioHelperUtilsBasic::cleanHTMLfromText($neu->zusatz14);
$neu->zusatz15 = MatukioHelperUtilsBasic::cleanHTMLfromText($neu->zusatz15);
$neu->zusatz16 = MatukioHelperUtilsBasic::cleanHTMLfromText($neu->zusatz16);
$neu->zusatz17 = MatukioHelperUtilsBasic::cleanHTMLfromText($neu->zusatz17);
$neu->zusatz18 = MatukioHelperUtilsBasic::cleanHTMLfromText($neu->zusatz18);
$neu->zusatz19 = MatukioHelperUtilsBasic::cleanHTMLfromText($neu->zusatz19);
$neu->zusatz20 = MatukioHelperUtilsBasic::cleanHTMLfromText($neu->zusatz20);
$neu->nrbooked = $nrbooked;
if (!empty($event->fees)) {
$neu->payment_method = "cash";
// TODO Update to diffrent fees
if ($nrbooked > 0) {
$neu->payment_brutto = $event->fees * $nrbooked;
} else {
$neu->payment_brutto = $event->fees;
}
}
if (empty($neu->uuid)) {
$neu->uuid = MatukioHelperPayment::getUuid(true);
}
if (!$neu->check()) {
return JError::raiseError(500, $database->stderr());
}
if (!$neu->store()) {
return JError::raiseError(500, $database->stderr());
}
$neu->checkin();
$ueber1 = JText::_("COM_MATUKIO_BOOKING_WAS_SUCCESSFULL");
if ($userid == 0) {
$userid = $neu->id * -1;
}
// Send new confirmation mail
if ($notify_participant) {
MatukioHelperUtilsEvents::sendBookingConfirmationMail($event, $neu->id, 11, false, $neu, false);
}
$viewteilnehmerlink = JRoute::_("index.php?option=com_matukio&view=participants&cid=" . $event->id . "&art=2");
$msg = JText::_("COM_MATUKIO_BOOKING_EDITED");
$this->setRedirect($viewteilnehmerlink, $msg);
}
/**
* Gets the replacements for the event & (booking)
*
* @param object $event - The event data
* @param object $booking - The booking data
* @param int $nr - the number
*
* @return mixed
*/
public static function getReplaces($event, $booking = null, $nr = null)
{
$needles = array('event' => (int) $event->id, 'category' => 0);
$itemId = MatukioHelperRoute::_findItem($needles)->id;
if ($nr != null) {
$replaces["MAT_NR"] = $nr;
}
// Current date
$replaces["MAT_DATE"] = JHTML::_('date', '', MatukioHelperSettings::getSettings('date_format_without_time', 'd-m-Y'));
// Signature
$replaces["MAT_SIGNATURE"] = MatukioHelperSettings::getSettings('mat_signature', 'Please do not answer this E-Mail.');
// Event data
$replaces["MAT_EVENT_SEMNUM"] = $event->semnum;
// Alias
$replaces["MAT_EVENT_NUMBER"] = $event->semnum;
$replaces["MAT_EVENT_CATID"] = $event->catid;
$replaces["MAT_EVENT_CATEGORY"] = JText::_($event->category);
$replaces["MAT_EVENT_TITLE"] = JText::_($event->title);
$replaces["MAT_EVENT_TARGET"] = JText::_($event->target);
$replaces["MAT_EVENT_SHORTDESC"] = JText::_($event->shortdesc);
// TODO change image path
$replaces["MAT_EVENT_DESCRIPTION"] = JHTML::_('content.prepare', $event->description);
$location = $event->place;
// Locations
if ($event->place_id > 0) {
$locobj = MatukioHelperUtilsEvents::getLocation($event->place_id);
$location = $locobj->location;
}
$replaces["MAT_EVENT_PLACE"] = $location;
$replaces["MAT_EVENT_LOCATION"] = $location;
$replaces["MAT_EVENT_TEACHER"] = $event->teacher;
// Alias
$replaces["MAT_EVENT_TUTOR"] = $event->teacher;
if ($event->fees > 0) {
$replaces["MAT_EVENT_FEES"] = MatukioHelperUtilsEvents::getFormatedCurrency($event->fees, MatukioHelperSettings::_('currency_symbol', '$'));
} else {
$replaces["MAT_EVENT_FEES"] = JText::_("COM_MATUKIO_FREE");
}
$replaces["MAT_EVENT_ORGANIZER_ID"] = $event->publisher;
$replaces["MAT_EVENT_ORGANIZER"] = JFactory::getUser($event->publisher)->name;
$replaces["MAT_EVENT_MAXPUPIL"] = $event->maxpupil;
$replaces["MAT_EVENT_BOOKEDPUPIL"] = $event->bookedpupil;
$replaces["MAT_EVENT_BEGIN"] = JHTML::_('date', $event->begin, MatukioHelperSettings::getSettings('date_format', 'd-m-Y, H:i'));
$replaces["MAT_EVENT_END"] = JHTML::_('date', $event->end, MatukioHelperSettings::getSettings('date_format', 'd-m-Y, H:i'));
$replaces["MAT_EVENT_BOOKED"] = JHTML::_('date', $event->booked, MatukioHelperSettings::getSettings('date_format', 'd-m-Y, H:i'));
$replaces["MAT_EVENT_GMAPLOC"] = $event->gmaploc;
$replaces["MAT_EVENT_NRBOOKED"] = $event->nrbooked;
/* Alias */
$custom10 = explode("|", $event->zusatz10);
$custom11 = explode("|", $event->zusatz11);
$custom12 = explode("|", $event->zusatz12);
$custom13 = explode("|", $event->zusatz13);
$custom14 = explode("|", $event->zusatz14);
$custom15 = explode("|", $event->zusatz15);
$custom16 = explode("|", $event->zusatz16);
$custom17 = explode("|", $event->zusatz17);
$custom18 = explode("|", $event->zusatz18);
$custom19 = explode("|", $event->zusatz19);
$custom20 = explode("|", $event->zusatz20);
$custom1 = explode("|", $event->zusatz1);
$custom2 = explode("|", $event->zusatz2);
$custom3 = explode("|", $event->zusatz3);
$custom4 = explode("|", $event->zusatz4);
$custom5 = explode("|", $event->zusatz5);
$custom6 = explode("|", $event->zusatz6);
$custom7 = explode("|", $event->zusatz7);
$custom8 = explode("|", $event->zusatz8);
$custom9 = explode("|", $event->zusatz9);
$replaces["MAT_EVENT_CUSTOM10"] = $custom10[0];
$replaces["MAT_EVENT_CUSTOM11"] = $custom11[0];
$replaces["MAT_EVENT_CUSTOM12"] = $custom12[0];
$replaces["MAT_EVENT_CUSTOM13"] = $custom13[0];
$replaces["MAT_EVENT_CUSTOM14"] = $custom14[0];
$replaces["MAT_EVENT_CUSTOM15"] = $custom15[0];
$replaces["MAT_EVENT_CUSTOM16"] = $custom16[0];
$replaces["MAT_EVENT_CUSTOM17"] = $custom17[0];
$replaces["MAT_EVENT_CUSTOM18"] = $custom18[0];
$replaces["MAT_EVENT_CUSTOM19"] = $custom19[0];
$replaces["MAT_EVENT_CUSTOM20"] = $custom20[0];
$replaces["MAT_EVENT_CUSTOM1"] = $custom1[0];
$replaces["MAT_EVENT_CUSTOM2"] = $custom2[0];
$replaces["MAT_EVENT_CUSTOM3"] = $custom3[0];
$replaces["MAT_EVENT_CUSTOM4"] = $custom4[0];
$replaces["MAT_EVENT_CUSTOM5"] = $custom5[0];
$replaces["MAT_EVENT_CUSTOM6"] = $custom6[0];
$replaces["MAT_EVENT_CUSTOM7"] = $custom7[0];
$replaces["MAT_EVENT_CUSTOM8"] = $custom8[0];
$replaces["MAT_EVENT_CUSTOM9"] = $custom9[0];
$replaces["MAT_EVENT_ZUSATZ10"] = $replaces["MAT_EVENT_CUSTOM10"];
$replaces["MAT_EVENT_ZUSATZ11"] = $replaces["MAT_EVENT_CUSTOM11"];
$replaces["MAT_EVENT_ZUSATZ12"] = $replaces["MAT_EVENT_CUSTOM12"];
$replaces["MAT_EVENT_ZUSATZ13"] = $replaces["MAT_EVENT_CUSTOM13"];
$replaces["MAT_EVENT_ZUSATZ14"] = $replaces["MAT_EVENT_CUSTOM14"];
$replaces["MAT_EVENT_ZUSATZ15"] = $replaces["MAT_EVENT_CUSTOM15"];
$replaces["MAT_EVENT_ZUSATZ16"] = $replaces["MAT_EVENT_CUSTOM16"];
$replaces["MAT_EVENT_ZUSATZ17"] = $replaces["MAT_EVENT_CUSTOM17"];
$replaces["MAT_EVENT_ZUSATZ18"] = $replaces["MAT_EVENT_CUSTOM18"];
$replaces["MAT_EVENT_ZUSATZ19"] = $replaces["MAT_EVENT_CUSTOM19"];
$replaces["MAT_EVENT_ZUSATZ20"] = $replaces["MAT_EVENT_CUSTOM20"];
$replaces["MAT_EVENT_ZUSATZ1"] = $replaces["MAT_EVENT_CUSTOM1"];
$replaces["MAT_EVENT_ZUSATZ2"] = $replaces["MAT_EVENT_CUSTOM2"];
$replaces["MAT_EVENT_ZUSATZ3"] = $replaces["MAT_EVENT_CUSTOM3"];
$replaces["MAT_EVENT_ZUSATZ4"] = $replaces["MAT_EVENT_CUSTOM4"];
$replaces["MAT_EVENT_ZUSATZ5"] = $replaces["MAT_EVENT_CUSTOM5"];
$replaces["MAT_EVENT_ZUSATZ6"] = $replaces["MAT_EVENT_CUSTOM6"];
$replaces["MAT_EVENT_ZUSATZ7"] = $replaces["MAT_EVENT_CUSTOM7"];
$replaces["MAT_EVENT_ZUSATZ8"] = $replaces["MAT_EVENT_CUSTOM8"];
$replaces["MAT_EVENT_ZUSATZ9"] = $replaces["MAT_EVENT_CUSTOM9"];
$replaces["MAT_EVENT_ZUSATZ10HINT"] = $event->zusatz10hint;
$replaces["MAT_EVENT_ZUSATZ11HINT"] = $event->zusatz11hint;
$replaces["MAT_EVENT_ZUSATZ12HINT"] = $event->zusatz12hint;
$replaces["MAT_EVENT_ZUSATZ13HINT"] = $event->zusatz13hint;
$replaces["MAT_EVENT_ZUSATZ14HINT"] = $event->zusatz14hint;
$replaces["MAT_EVENT_ZUSATZ15HINT"] = $event->zusatz15hint;
$replaces["MAT_EVENT_ZUSATZ16HINT"] = $event->zusatz16hint;
$replaces["MAT_EVENT_ZUSATZ17HINT"] = $event->zusatz17hint;
$replaces["MAT_EVENT_ZUSATZ18HINT"] = $event->zusatz18hint;
$replaces["MAT_EVENT_ZUSATZ19HINT"] = $event->zusatz19hint;
$replaces["MAT_EVENT_ZUSATZ20HINT"] = $event->zusatz20hint;
$replaces["MAT_EVENT_ZUSATZ1HINT"] = $event->zusatz1hint;
$replaces["MAT_EVENT_ZUSATZ2HINT"] = $event->zusatz2hint;
$replaces["MAT_EVENT_ZUSATZ3HINT"] = $event->zusatz3hint;
$replaces["MAT_EVENT_ZUSATZ4HINT"] = $event->zusatz4hint;
$replaces["MAT_EVENT_ZUSATZ5HINT"] = $event->zusatz5hint;
$replaces["MAT_EVENT_ZUSATZ6HINT"] = $event->zusatz6hint;
$replaces["MAT_EVENT_ZUSATZ7HINT"] = $event->zusatz7hint;
$replaces["MAT_EVENT_ZUSATZ8HINT"] = $event->zusatz8hint;
$replaces["MAT_EVENT_ZUSATZ9HINT"] = $event->zusatz9hint;
/* ALIAS */
$replaces["MAT_EVENT_CUSTOM10HINT"] = $event->zusatz10hint;
$replaces["MAT_EVENT_CUSTOM11HINT"] = $event->zusatz11hint;
$replaces["MAT_EVENT_CUSTOM12HINT"] = $event->zusatz12hint;
$replaces["MAT_EVENT_CUSTOM13HINT"] = $event->zusatz13hint;
$replaces["MAT_EVENT_CUSTOM14HINT"] = $event->zusatz14hint;
$replaces["MAT_EVENT_CUSTOM15HINT"] = $event->zusatz15hint;
$replaces["MAT_EVENT_CUSTOM16HINT"] = $event->zusatz16hint;
$replaces["MAT_EVENT_CUSTOM17HINT"] = $event->zusatz17hint;
$replaces["MAT_EVENT_CUSTOM18HINT"] = $event->zusatz18hint;
$replaces["MAT_EVENT_CUSTOM19HINT"] = $event->zusatz19hint;
$replaces["MAT_EVENT_CUSTOM20HINT"] = $event->zusatz20hint;
$replaces["MAT_EVENT_CUSTOM1HINT"] = $event->zusatz1hint;
$replaces["MAT_EVENT_CUSTOM2HINT"] = $event->zusatz2hint;
$replaces["MAT_EVENT_CUSTOM3HINT"] = $event->zusatz3hint;
$replaces["MAT_EVENT_CUSTOM4HINT"] = $event->zusatz4hint;
$replaces["MAT_EVENT_CUSTOM5HINT"] = $event->zusatz5hint;
$replaces["MAT_EVENT_CUSTOM6HINT"] = $event->zusatz6hint;
$replaces["MAT_EVENT_CUSTOM7HINT"] = $event->zusatz7hint;
$replaces["MAT_EVENT_CUSTOM8HINT"] = $event->zusatz8hint;
$replaces["MAT_EVENT_CUSTOM9HINT"] = $event->zusatz9hint;
$replaces["MAT_EVENT_CREATED_BY"] = $event->created_by;
$replaces["MAT_EVENT_MODIFIED_BY"] = $event->modified_by;
$replaces["MAT_EVENT_CREATED"] = JHTML::_('date', $event->created, MatukioHelperSettings::getSettings('date_format', 'd-m-Y, H:i'));
$replaces["MAT_EVENT_WEBINAR"] = $event->webinar;
if ($booking != null) {
if (empty($booking->sid)) {
$booking->sid = $booking->id;
}
// Booking data
$replaces["MAT_BOOKING_ID"] = $booking->sid;
$replaces["MAT_BOOKING_NUMBER"] = MatukioHelperUtilsBooking::getBookingId($booking->sid);
$replaces["MAT_SIGN"] = "<span> </span>";
$user = JFactory::getUser($booking->userid);
$replaces["MAT_BOOKING_USERNAME"] = "";
if ($booking->userid > 0) {
$replaces["MAT_BOOKING_USERNAME"] = $user->username;
}
if (isset($booking->aname)) {
$booking->aname = trim($booking->aname);
}
if (isset($booking->name)) {
$booking->name = trim($booking->name);
}
// Old form
if (isset($booking->aname) && !empty($booking->aname)) {
$replaces["MAT_BOOKING_NAME"] = $booking->aname;
} elseif (isset($booking->name) && !empty($booking->name)) {
$replaces["MAT_BOOKING_NAME"] = $booking->name;
}
if (isset($booking->aemail) && !empty($booking->aemail)) {
$replaces["MAT_BOOKING_EMAIL"] = $booking->aemail;
} elseif (isset($booking->email) && !empty($booking->email)) {
$replaces["MAT_BOOKING_EMAIL"] = $booking->email;
}
// Fix for empty E-Mail
if (empty($replaces["MAT_BOOKING_EMAIL"])) {
$replaces["MAT_BOOKING_EMAIL"] = $booking->email;
}
$replaces["MAT_BOOKING_SID"] = $booking->sid;
$replaces["MAT_BOOKING_SEMID"] = $booking->semid;
$replaces["MAT_BOOKING_USERID"] = $booking->userid;
$replaces["MAT_BOOKING_CERTIFICATED"] = $booking->certificated;
$replaces["MAT_EVENT_BOOKINGDATE"] = JHTML::_('date', $booking->bookingdate, MatukioHelperSettings::getSettings('date_format', 'd-m-Y, H:i'));
$replaces["MAT_EVENT_UPDATED"] = JHTML::_('date', $booking->updated, MatukioHelperSettings::getSettings('date_format', 'd-m-Y, H:i'));
$replaces["MAT_INVOICE_DATE"] = JHTML::_('date', $booking->bookingdate, MatukioHelperSettings::getSettings('date_format_without_time', 'd-m-Y'));
if ($booking->payment_brutto > 0) {
$replaces["MAT_INVOICE_NUMBER"] = MatukioHelperInvoice::getInvoiceNumber($booking->id, JHTML::_('date', $booking->bookingdate, 'Y'));
} else {
$replaces["MAT_INVOICE_NUMBER"] = "";
}
$replaces["MAT_BOOKING_PAID"] = MatukioHelperUtilsBooking::getBookingPaidName($booking->paid);
$replaces["MAT_BOOKING_PAID_NUM"] = $booking->paid;
$replaces["MAT_BOOKING_PAYMENT_STATUS"] = $booking->payment_status;
$replaces["MAT_BOOKING_PAYMENT_PLUGIN_DATA"] = $booking->payment_plugin_data;
$replaces["MAT_BOOKING_NRBOOKED"] = $booking->nrbooked;
// Alias
$replaces["MAT_BOOKING_BOOKEDNR"] = $booking->nrbooked;
$replaces["MAT_BOOKING_ZUSATZ10"] = $booking->zusatz10;
$replaces["MAT_BOOKING_ZUSATZ11"] = $booking->zusatz11;
$replaces["MAT_BOOKING_ZUSATZ12"] = $booking->zusatz12;
$replaces["MAT_BOOKING_ZUSATZ13"] = $booking->zusatz13;
$replaces["MAT_BOOKING_ZUSATZ14"] = $booking->zusatz14;
$replaces["MAT_BOOKING_ZUSATZ15"] = $booking->zusatz15;
$replaces["MAT_BOOKING_ZUSATZ16"] = $booking->zusatz16;
$replaces["MAT_BOOKING_ZUSATZ17"] = $booking->zusatz17;
$replaces["MAT_BOOKING_ZUSATZ18"] = $booking->zusatz18;
$replaces["MAT_BOOKING_ZUSATZ19"] = $booking->zusatz19;
$replaces["MAT_BOOKING_ZUSATZ20"] = $booking->zusatz20;
$replaces["MAT_BOOKING_ZUSATZ1"] = $booking->zusatz1;
$replaces["MAT_BOOKING_ZUSATZ2"] = $booking->zusatz2;
$replaces["MAT_BOOKING_ZUSATZ3"] = $booking->zusatz3;
$replaces["MAT_BOOKING_ZUSATZ4"] = $booking->zusatz4;
$replaces["MAT_BOOKING_ZUSATZ5"] = $booking->zusatz5;
$replaces["MAT_BOOKING_ZUSATZ6"] = $booking->zusatz6;
$replaces["MAT_BOOKING_ZUSATZ7"] = $booking->zusatz7;
$replaces["MAT_BOOKING_ZUSATZ8"] = $booking->zusatz8;
$replaces["MAT_BOOKING_ZUSATZ9"] = $booking->zusatz9;
/* Alias */
$replaces["MAT_BOOKING_CUSTOM10"] = $booking->zusatz10;
$replaces["MAT_BOOKING_CUSTOM11"] = $booking->zusatz11;
$replaces["MAT_BOOKING_CUSTOM12"] = $booking->zusatz12;
$replaces["MAT_BOOKING_CUSTOM13"] = $booking->zusatz13;
$replaces["MAT_BOOKING_CUSTOM14"] = $booking->zusatz14;
$replaces["MAT_BOOKING_CUSTOM15"] = $booking->zusatz15;
$replaces["MAT_BOOKING_CUSTOM16"] = $booking->zusatz16;
$replaces["MAT_BOOKING_CUSTOM17"] = $booking->zusatz17;
$replaces["MAT_BOOKING_CUSTOM18"] = $booking->zusatz18;
$replaces["MAT_BOOKING_CUSTOM19"] = $booking->zusatz19;
$replaces["MAT_BOOKING_CUSTOM20"] = $booking->zusatz20;
$replaces["MAT_BOOKING_CUSTOM1"] = $booking->zusatz1;
$replaces["MAT_BOOKING_CUSTOM2"] = $booking->zusatz2;
$replaces["MAT_BOOKING_CUSTOM3"] = $booking->zusatz3;
$replaces["MAT_BOOKING_CUSTOM4"] = $booking->zusatz4;
$replaces["MAT_BOOKING_CUSTOM5"] = $booking->zusatz5;
$replaces["MAT_BOOKING_CUSTOM6"] = $booking->zusatz6;
$replaces["MAT_BOOKING_CUSTOM7"] = $booking->zusatz7;
$replaces["MAT_BOOKING_CUSTOM8"] = $booking->zusatz8;
$replaces["MAT_BOOKING_CUSTOM9"] = $booking->zusatz9;
$replaces["MAT_BOOKING_UUID"] = $booking->uuid;
if (!empty($booking->payment_method)) {
$replaces["MAT_BOOKING_PAYMENT_METHOD"] = self::getPaymentMethodTitle($booking->payment_method);
} else {
$replaces["MAT_BOOKING_PAYMENT_METHOD"] = "";
}
$replaces["MAT_BOOKING_PAYMENT_METHOD_RAW"] = $booking->payment_method;
$replaces["MAT_BOOKING_PAYMENT_NUMBER"] = $booking->payment_number;
$replaces["MAT_BOOKING_PAYMENT_NETTO"] = MatukioHelperUtilsEvents::getFormatedCurrency($booking->payment_netto, MatukioHelperSettings::_('currency_symbol', '$'));
$replaces["MAT_BOOKING_PAYMENT_NET"] = $replaces["MAT_BOOKING_PAYMENT_NETTO"];
$replaces["MAT_BOOKING_PAYMENT_TAX"] = MatukioHelperUtilsEvents::getFormatedCurrency($booking->payment_tax, MatukioHelperSettings::_('currency_symbol', '$'));
$replaces["MAT_BOOKING_PAYMENT_BRUTTO"] = MatukioHelperUtilsEvents::getFormatedCurrency($booking->payment_brutto, MatukioHelperSettings::_('currency_symbol', '$'));
$replaces["MAT_BOOKING_PAYMENT_GROSS"] = $replaces["MAT_BOOKING_PAYMENT_BRUTTO"];
$replaces["MAT_BOOKING_COUPON_CODE"] = $booking->coupon_code;
$replaces["MAT_BOOKING_STATUS"] = MatukioHelperUtilsBooking::getBookingStatusName($booking->status);
/* Mark since 4.5 */
$replaces["MAT_BOOKING_MARK"] = $booking->mark;
/* QR Codes */
$replaces["MAT_BOOKING_QRCODE_ID"] = MatukioHelperUtilsBooking::getBookingIdQRCode($booking->sid);
$replaces["MAT_BOOKING_QRCODE"] = $replaces["MAT_BOOKING_QRCODE_ID"];
$replaces["MAT_BOOKING_BARCODE"] = MatukioHelperUtilsBooking::getBookingIdBarcode($booking->sid);
// Checkin URLs and QR-Codes since 4.5
$checkinurl = JRoute::_("index.php?option=com_matukio&view=booking&task=checkin&uuid=" . $booking->uuid . "&Itemid=" . $itemId, true, -1);
$replaces["MAT_BOOKING_CHECKIN_URL"] = $checkinurl;
$replaces["MAT_BOOKING_CHECKIN_LINK"] = '<a href="' . $checkinurl . '">' . JText::_("COM_MATUKIO_CHECKIN_BOOKING") . "</a>";
$replaces["MAT_BOOKING_CHECKIN_QRCODE"] = MatukioHelperUtilsBooking::getBookingCheckinQRCode($checkinurl, $booking->sid);
if ($event->fees > 0) {
$replaces["MAT_BOOKING_FEES_STATUS"] = MatukioHelperUtilsEvents::getFormatedCurrency($booking->payment_brutto, MatukioHelperSettings::_('currency_symbol', '$')) . " (" . MatukioHelperUtilsBooking::getBookingPaidName($booking->paid) . ")";
} else {
$replaces["MAT_BOOKING_FEES_STATUS"] = JText::_("COM_MATUKIO_FREE_EVENT");
}
// Booking detail page @since 4.1.1
$replaces["MAT_BOOKING_DETAILPAGE_URL"] = JRoute::_("index.php?option=com_matukio&view=booking&uuid=" . $booking->uuid . "&Itemid=" . $itemId, true, -1);
$replaces["MAT_BOOKING_DETAILPAGE"] = '<a href="' . JRoute::_("index.php?option=com_matukio&view=booking&uuid=" . $booking->uuid . "&Itemid=" . $itemId, true, -1) . '">' . JText::_("COM_MATUKIO_BOOKING_DETAILS") . "</a>";
$editbookinglink = JRoute::_("index.php?option=com_matukio&view=bookevent&cid=" . $booking->semid . "&uuid=" . $booking->uuid . "&Itemid=" . $itemId, true, -1);
if (MatukioHelperSettings::getSettings('oldbookingform', 0) == 1) {
$editbookinglink = JRoute::_(MatukioHelperRoute::getEventRoute($event->id, $event->catid, 1, $booking->id, $booking->uuid), true, -1);
}
$replaces["MAT_BOOKING_EDIT_URL"] = $editbookinglink;
$replaces["MAT_BOOKING_EDIT"] = '<a href="' . $editbookinglink . '">' . JText::_("COM_MATUKIO_EDIT_YOUR_BOOKING") . "</a>";
// TODO Different fees
}
// Event info complete no booking here
$replaces["MAT_EVENT_ALL_DETAILS_HTML"] = self::getEmailEventInfoHTML($event);
$replaces["MAT_EVENT_ALL_DETAILS_TEXT"] = self::getEmailEventInfoTEXT($event);
/* Other things */
$replaces["MAT_BANK_TRANSFER_INFORMATIONS"] = MatukioHelperPayment::getBanktransferInfo(MatukioHelperSettings::getSettings("banktransfer_account", ''), MatukioHelperSettings::getSettings("banktransfer_blz", ''), MatukioHelperSettings::getSettings("banktransfer_bank", ''), MatukioHelperSettings::getSettings("banktransfer_accountholder", ''), MatukioHelperSettings::getSettings("banktransfer_iban", ''), MatukioHelperSettings::getSettings("banktransfer_bic", ''));
// CSV
$bookingnewname = "";
if ($booking != null) {
$replaces["MAT_CSV_BOOKING_DETAILS"] = self::getExportCSVBookingDetails($booking, $event, MatukioHelperSettings::getSettings('export_csv_separator', ';'));
if (MatukioHelperSettings::getSettings('oldbookingform', 0) == 1) {
// Old booking form
if ($booking->userid > 0) {
$user = JFactory::getUser($booking->userid);
$replaces["MAT_BOOKING_NAME"] = $user->name;
$replaces["MAT_BOOKING_EMAIL"] = $user->email;
}
} else {
// New booking form fields
$fields = MatukioHelperUtilsBooking::getBookingFields();
$fieldvals = explode(";", $booking->newfields);
$value = array();
foreach ($fieldvals as $val) {
$tmp = explode("::", $val);
if (count($tmp) > 1) {
$value[$tmp[0]] = $tmp[1];
} else {
$value[$tmp[0]] = "";
}
}
foreach ($fields as $field) {
if (!empty($value[$field->id])) {
// Not use the Spacer fields
if ($field->type != "spacer" && $field->type != "spacertext") {
$replaces["MAT_BOOKING_" . strtoupper($field->field_name)] = $value[$field->id];
}
if ($field->field_name == "firstname") {
$bookingnewname .= $value[$field->id];
}
if ($field->field_name == "lastname") {
$bookingnewname .= " " . $value[$field->id];
}
} else {
// Not use the Spacer fields
if ($field->type != "spacer" && $field->type != "spacertext") {
$replaces["MAT_BOOKING_" . strtoupper($field->field_name)] = "";
}
}
}
$bookingnewname = trim($bookingnewname);
$replaces["MAT_BOOKING_COMMENT"] = $booking->comment;
if (empty($replaces["MAT_BOOKING_NAME"])) {
if (!empty($bookingnewname)) {
$replaces["MAT_BOOKING_NAME"] = $bookingnewname;
} else {
if ($booking->userid > 0) {
$user = JFactory::getUser($booking->userid);
$replaces["MAT_BOOKING_NAME"] = $user->name;
}
}
}
}
if (empty($replaces["MAT_BOOKING_EMAIL"])) {
if ($booking->userid > 0) {
$user = JFactory::getUser($booking->userid);
$replaces["MAT_BOOKING_EMAIL"] = $user->email;
}
}
// Booking complete
$replaces["MAT_BOOKING_ALL_DETAILS_HTML"] = self::getEmailBookingInfoHTML($event, $booking, $bookingnewname);
$replaces["MAT_BOOKING_ALL_DETAILS_TEXT"] = self::getEmailBookingInfoTEXT($event, $booking, $bookingnewname);
}
return $replaces;
}
