/** * 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; }