/**
* Rates an event
*
* @throws Exception if user is not logged in
* @return void / redirect
*/
public function rate()
{
// Check if user is logged in
if (JFactory::getUser()->id == 0) {
throw new Exception("COM_MATUKIO_NO_ACCESS");
}
$msg = JText::_("COM_MATUKIO_RATING_SUCCESSFULL");
$mainframe = JFactory::getApplication();
jimport('joomla.mail.helper');
$my = JFactory::getuser();
$database = JFactory::getDBO();
$cid = JFactory::getApplication()->input->getInt('cid', 0);
$grade = JFactory::getApplication()->input->getInt('grade', 0);
$text = JFactory::getApplication()->input->get('text', '');
$text = str_replace(array("\"", "\\'"), "", $text);
$text = JMailHelper::cleanBody($text);
$database->setQuery("UPDATE #__matukio_bookings SET grade='" . $grade . "', comment='" . $text . "' WHERE semid='" . $cid . "' AND userid='" . $my->id . "'");
if (!$database->execute()) {
JError::raiseError(500, $database->getError());
exit;
}
$database->setQuery("SELECT * FROM #__matukio_bookings WHERE semid='" . $cid . "'");
$rows = $database->loadObjectList();
$zaehler = 0;
$wertung = 0;
foreach ($rows as $row) {
if ($row->grade > 0) {
$wertung = $wertung + $row->grade;
$zaehler++;
}
}
if ($zaehler > 0) {
$geswert = round($wertung / $zaehler);
} else {
$geswert = 0;
}
$database->setQuery("UPDATE #__matukio SET grade='{$geswert}' WHERE id='{$cid}'");
if (!$database->execute()) {
JError::raiseError(500, $database->getError());
$msg = "COM_MATUKIO_RATING_FAILED " . $database->getError();
}
if (MatukioHelperSettings::getSettings('sendmail_owner', 1) > 0) {
$database->setQuery("SELECT * FROM #__matukio_bookings WHERE semid='{$cid}' AND userid='{$my->id}'");
$buchung = $database->loadObject();
// Load event (use model function)
$emodel = JModelLegacy::getInstance('Event', 'MatukioModel');
$row = $emodel->getItem($cid);
$publisher = JFactory::getuser($row->publisher);
$body = "\n<head>\n<style type=\"text/css\">\n<!--\nbody {\nfont-family: Verdana, Tahoma, Arial;\nfont-size:12pt;\n}\n-->\n</style></head><body>";
$body .= "<p><div style=\"font-size: 10pt\">" . JTEXT::_('COM_MATUKIO_RECEIVED_RATING') . "</div>";
$body .= "<p><div style=\"font-size: 10pt\">" . JTEXT::_('COM_MATUKIO_RATING') . ":</div>";
$htxt = str_replace('SEM_POINTS', $grade, JTEXT::_('COM_MATUKIO_SEM_POINTS_6'));
$body .= "<div style=\"border: 1px solid #A0A0A0; width: 100%; padding: 5px;\">" . $htxt . "</div>";
$body .= "<p><div style=\"font-size: 10pt\">" . JTEXT::_('COM_MATUKIO_COMMENT') . ":</div>";
$body .= "<div style=\"border: 1px solid #A0A0A0; width: 100%; padding: 5px;\">" . htmlspecialchars($text) . "</div>";
$body .= "<p><div style=\"font-size: 10pt\">" . JTEXT::_('COM_MATUKIO_AVARAGE_SCORE') . ":</div>";
$htxt = str_replace('SEM_POINTS', $geswert, JTEXT::_('COM_MATUKIO_SEM_POINTS_6'));
$body .= "<div style=\"border: 1px solid #A0A0A0; width: 100%; padding: 5px;\">" . $htxt . "</div>";
$body .= "<p>" . MatukioHelperUtilsEvents::getEmailBody($row, $buchung, $my);
$sender = $mainframe->getCfg('fromname');
$from = $mainframe->getCfg('mailfrom');
$replyname = $my->name;
$replyto = $my->email;
$email = $publisher->email;
$subject = JTEXT::_('COM_MATUKIO_EVENT');
if ($row->semnum != "") {
$subject .= " " . $row->semnum;
}
$subject .= ": " . $row->title;
$subject = JMailHelper::cleanSubject($subject);
$mailer = JFactory::getMailer();
$mailer->sendMail($from, $sender, $email, $subject, $body, 1, null, null, null, $replyto, $replyname);
}
$link = "index.php?option=com_matukio&tmpl=component&s=" . MatukioHelperUtilsBasic::getRandomChar() . "&view=rateevent&cid=" . $cid;
$this->setRedirect($link, $msg);
}
/**
* Sends an email to the organizer
*
* @throws exception
* @return object
*/
public function sendEmail()
{
$mainframe = JFactory::getApplication();
$msg = JText::_("COM_MATUKIO_MAIL_TO_ORGANIZER_SEND_SUCCESSFULL");
$msg_type = "message";
jimport('joomla.mail.helper');
// Check if sending is allowed
if (!MatukioHelperSettings::getSettings("sendmail_contact", 1)) {
throw new Exception("COM_MATUKIO_CONTACTING_ORGANIZERS_IS_DISABLED");
}
$my = JFactory::getuser();
$database = JFactory::getDBO();
$cid = JFactory::getApplication()->input->getInt('event_id', 0);
$organizer_id = JFactory::getApplication()->input->getInt('organizer_id', 0);
$uid = JFactory::getApplication()->input->get('art', 0);
$text = JMailHelper::cleanBody(nl2br(JFactory::getApplication()->input->get('text', '', 'string')));
$name = JFactory::getApplication()->input->get('name', '', 'string');
$email = JFactory::getApplication()->input->get('email', '', 'string');
if ($text != "" && $name != "" && $email != "") {
$reason = JTEXT::_('COM_MATUKIO_MESSAGE_SEND');
// Load event (use model function)
$emodel = JModelLegacy::getInstance('Event', 'MatukioModel');
$event = $emodel->getItem($cid);
$subject = "";
if ($event->semnum != "") {
$subject .= " " . $event->semnum;
}
$subject .= ": " . $event->title;
$subject = JMailHelper::cleanSubject($subject);
$sender = $mainframe->getCfg('fromname');
$from = $mainframe->getCfg('mailfrom');
if ($my->id == 0) {
$replyname = $name;
$replyto = $email;
// Setting it hardcoded for the body function.. dirk you really give me headaches
$my->name = $name;
$my->email = $email;
} else {
$replyname = $my->name;
$replyto = $my->email;
}
$body = "\n<head>\n<style type=\"text/css\">\n<!--\nbody {\nfont-family: Verdana, Tahoma, Arial;\nfont-size:12pt;\n}\n-->\n</style></head><body>";
if ($uid == 1 and $my->id != 0) {
$body .= "<p><div style=\"font-size: 10pt\">" . JTEXT::_('COM_MATUKIO_QUESTION_ABOUT_EVENT') . "</div><p>";
}
$body .= "<div style=\"border: 1px solid #A0A0A0; width: 100%; padding: 5px;\">" . $text . "</div><p>";
$temp = array();
// Mail to Organizer
if ($uid == 1) {
$body .= MatukioHelperUtilsEvents::getEmailBody($event, $temp, $my);
$publisher = JFactory::getUser($event->publisher);
$email = $publisher->email;
$mailer = JFactory::getMailer();
$mailer->sendMail($from, $sender, $email, $subject, $body, 1, null, null, null, $replyto, $replyname);
} elseif ($uid == "organizer") {
$organizer = MatukioHelperOrganizer::getOrganizerId($organizer_id);
$publisher = JFactory::getuser($organizer->userId);
$email = $publisher->email;
$mailer = JFactory::getMailer();
$mailer->sendMail($from, $sender, $email, $subject, $body, 1, null, null, null, $replyto, $replyname);
} else {
if (!JFactory::getUser()->authorise('core.create', 'com_matukio')) {
return JError::raiseWarning(404, JText::_('JERROR_ALERTNOAUTHOR'));
}
$database->setQuery("SELECT * FROM #__matukio_bookings WHERE semid='" . $event->id . "'");
$rows = $database->loadObjectList();
foreach ($rows as $row) {
if ($row->userid == 0) {
$user = JFactory::getUser(0);
$user->email = $row->email;
$user->name = $row->name;
} else {
$user = JFactory::getUser($row->userid);
}
$text = $body . MatukioHelperUtilsEvents::getEmailBody($event, $row, $user);
$mailer = JFactory::getMailer();
$mailer->sendMail($from, $sender, $user->email, $subject, $text, 1, null, null, null, $replyto, $replyname);
}
}
} else {
$msg = JTEXT::_('COM_MATUKIO_MESSAGE_NOT_SEND');
$msg_type = "error";
}
$link = MatukioHelperUtilsBasic::getSitePath() . "index.php?tmpl=component&s=" . MatukioHelperUtilsBasic::getRandomChar() . "&option=" . JFactory::getApplication()->input->get('option') . "&view=contactorganizer&cid=" . $cid . "&art=" . $uid . "&task=19";
$this->setRedirect($link, $msg, $msg_type);
}
