function socialBookmarks($listing)
{
$googlePlusOne = $twitter = $facebook = '';
$facebook_xfbml = Sanitize::getBool($this->Config, 'facebook_opengraph') && Sanitize::getBool($this->Config, 'facebook_appid');
$href = cmsFramework::makeAbsUrl($listing['Listing']['url'], array('sef' => true));
$twitter = '
<a href="http://twitter.com/share" data-url="' . $href . '" class="twitter-share-button" data-count="horizontal">Tweet</a>
<script type="text/javascript">jQuery(document).ready(function(){jQuery.getScript("http://platform.twitter.com/widgets.js");})</script>';
if ($facebook_xfbml) {
$facebook = '<fb:like href="' . $href . '" action="like" colorscheme="light" layout="button_count" show_faces="false"></fb:like>';
} else {
$facebook = '<script src="http://connect.facebook.net/' . cmsFramework::getLocale() . '/all.js#xfbml=1"></script><fb:like layout="button_count" show_faces="false"></fb:like>';
}
if ($this->Config->facebook_send) {
$facebook .= '<div style="display:inline;margin-right: 15px;"><fb:send href="' . $href . '" colorscheme="light"></fb:send></div>';
}
$googlePlusOne = '
<g:plusone href="' . $href . '" size="medium"></g:plusone>
<script type="text/javascript" src="http://apis.google.com/js/plusone.js"></script>
';
return $googlePlusOne . $twitter . $facebook;
}
function _send()
{
$recipient = '';
$error = array();
$response = array();
$this->components = array('security');
$this->__initComponents();
if ($this->invalidToken) {
$error[] = 'jQuery("#jr_inquiryTokenValidation").show();';
return json_encode(array('error' => $this->makeJS($error)));
}
// Required fields
$fields = array('name', 'email', 'text');
// $fields = array('name','email','phone','text');
foreach ($fields as $id) {
$input_id = '#jr_inquiry' . Inflector::camelize($id) . 'Validation';
if ($this->data['Inquiry'][$id] == '') {
$error[] = 'jQuery("' . $input_id . '").show();';
} else {
$reponse[] = 'jQuery("' . $input_id . '").hide();';
}
}
# Validate user's email
$this->Listing->validateInput($this->data['Inquiry']['email'], "email", "email", __t("You must fill in a valid email address.", true), 1);
# Validate security code
if ($this->Access->showCaptcha()) {
if (!isset($this->data['Captcha']['code'])) {
$this->Listing->validateSetError("code", __t("The security code you entered was invalid.", true));
} elseif ($this->data['Captcha']['code'] == '') {
$this->Listing->validateSetError("code", __t("You must fill in the security code.", true));
} else {
if (!$this->Captcha->checkCode($this->data['Captcha']['code'], $this->ipaddress)) {
$this->Listing->validateSetError("code", __t("The security code you entered was invalid.", true));
}
}
}
# Process validation errors
$validation = $this->Listing->validateGetErrorArray();
$validation = is_array($validation) ? implode("<br />", $validation) : '';
if (!empty($error) || $validation != '') {
// Reissue form token
if (isset($this->Security)) {
$error[] = "jQuery('#jr_inquiryToken').val('" . $this->Security->reissueToken() . "');";
}
if ($this->Access->showCaptcha()) {
// Replace captcha with new instance
$captcha = $this->Captcha->displayCode();
$error[] = "jQuery('#captcha').attr('src','{$captcha['src']}');";
$error[] = "jQuery('#jr_inquiryCode').val('');";
}
if ($validation != '') {
$error[] = "jQuery('#jr_inquiryCodeValidation').html('{$validation}').show();";
}
return json_encode(array('error' => $this->makeJS($error)));
}
// Now we can send the email
# Read cms mail config settings
$configSendmailPath = cmsFramework::getConfig('sendmail');
$configSmtpAuth = cmsFramework::getConfig('smtpauth');
$configSmtpUser = cmsFramework::getConfig('smtpuser');
$configSmtpPass = cmsFramework::getConfig('smtppass');
$configSmtpHost = cmsFramework::getConfig('smtphost');
$configSmtpSecure = cmsFramework::getConfig('smtpsecure');
$configSmtpPort = cmsFramework::getConfig('smtpport');
$configMailFrom = cmsFramework::getConfig('mailfrom');
$configFromName = cmsFramework::getConfig('fromname');
$configMailer = cmsFramework::getConfig('mailer');
# Get the recipient email
Configure::write('Cache.query', false);
$listing = $this->Listing->findRow(array('fields' => array('User.email AS `Listing.email`'), 'conditions' => array('Listing.id = ' . (int) $this->data['Inquiry']['listing_id'])));
$url = cmsFramework::makeAbsUrl($listing['Listing']['url'], array('sef' => true));
$link = '<a href="' . $url . '">' . $listing['Listing']['title'] . '</a>';
switch ($this->Config->inquiry_recipient) {
case 'owner':
$recipient = Sanitize::getString($listing['Listing'], 'email');
break;
case 'admin':
$recipient = $configMailFrom;
break;
case 'field':
if (isset($listing['Field']['pairs'][$this->Config->inquiry_field])) {
$recipient = $listing['Field']['pairs'][$this->Config->inquiry_field]['value'][0];
}
break;
}
if ($recipient == '') {
$recipient = $configMailFrom;
}
if (!class_exists('PHPMailer')) {
App::import('Vendor', 'phpmailer' . DS . 'class.phpmailer');
}
$mail = new PHPMailer();
$mail->CharSet = cmsFramework::getCharset();
$mail->SetLanguage('en', S2_VENDORS . 'phpmailer' . DS . 'language' . DS);
$mail->Mailer = $configMailer;
// Mailer used mail,sendmail,smtp
switch ($configMailer) {
case 'smtp':
$mail->Host = $configSmtpHost;
$mail->SMTPAuth = $configSmtpAuth;
$mail->Username = $configSmtpUser;
$mail->Password = $configSmtpPass;
$mail->SMTPSecure = $configSmtpSecure != '' ? $configSmtpSecure : '';
$mail->Port = $configSmtpPort;
break;
case 'sendmail':
$mail->Sendmail = $configSendmailPath;
break;
default:
break;
}
$mail->isHTML(true);
$mail->From = $configMailFrom;
$mail->FromName = $configFromName;
$mail->addReplyTo($this->data['Inquiry']['email']);
$mail->AddAddress($recipient);
$mail->Subject = sprintf(__t("New inquiry for: %s", true), $listing['Listing']['title']);
$mail->Body = sprintf(__t("From: %s", true), Sanitize::getString($this->data['Inquiry'], 'name')) . "<br />";
$mail->Body .= sprintf(__t("Email: %s", true), Sanitize::getString($this->data['Inquiry'], 'email')) . "<br />";
// $mail->Body .= sprintf(__t("Phone number: %s",true),Sanitize::getString($this->data['Inquiry'],'phone')) . "<br />";
$mail->Body .= sprintf(__t("Listing: %s", true), $listing['Listing']['title']) . "<br />";
$mail->Body .= sprintf(__t("Listing link: %s", true), $link) . "<br />";
$mail->Body .= $this->data['Inquiry']['text'];
if (!$mail->Send()) {
unset($mail);
$error[] = 'jQuery("#jr_inquiryTokenValidation").show();';
return json_encode(array('error' => $this->makeJS($error)));
}
$mail->ClearAddresses();
$bccAdmin = $this->Config->inquiry_bcc;
if ($bccAdmin != '' && $bccAdmin != $recipient) {
$mail->AddAddress($bccAdmin);
$mail->Send();
}
unset($mail);
return json_encode(array('error' => $this->makeJS($response), 'html' => true));
}
function plgAfterSave(&$model)
{
$data = array();
App::import('Model', 'activity', 'jreviews');
App::import('Helper', 'routes', 'jreviews');
$Activity = new ActivityModel();
$Routes = RegisterClass::getInstance('RoutesHelper');
$data['Activity']['user_id'] = $this->c->_user->id;
$data['Activity']['email'] = $this->c->_user->email;
$data['Activity']['created'] = gmdate('Y-m-d H:i:s');
$data['Activity']['ipaddress'] = $this->c->ipaddress;
$data['Activity']['activity_new'] = isset($model->data['insertid']) ? 1 : 0;
switch ($this->activityModel->name) {
case 'Claim':
//Get the full listing info to create proper permalinks
$listing = $this->c->Listing->findRow(array('conditions' => array('Listing.id = ' . (int) $model->data['Claim']['listing_id'])), array());
$permalink = $Routes->content('', $listing, array('return_url' => true));
$permalink = cmsFramework::makeAbsUrl($permalink);
$data['Activity']['activity_type'] = 'claim';
$data['Activity']['listing_id'] = $model->data['Claim']['listing_id'];
$data['Activity']['extension'] = 'com_content';
$data['Activity']['activity_new'] = 1;
$data['Activity']['permalink'] = $permalink;
$Activity->store($data);
break;
case 'Listing':
// Skip logging of admin actions on user listings
// if($this->c->_user->id != $model->data['Listing']['created_by']) break;
//Get the full listing info to create proper permalinks
$listing = $this->c->Listing->findRow(array('conditions' => array('Listing.id = ' . (int) $model->data['Listing']['id'])));
$permalink = $Routes->content('', $listing, array('return_url' => true));
$permalink = cmsFramework::makeAbsUrl($permalink);
$data['Activity']['activity_type'] = 'listing';
$data['Activity']['email'] = Sanitize::getString($model->data, 'email');
$data['Activity']['listing_id'] = $model->data['Listing']['id'];
$data['Activity']['extension'] = 'com_content';
$data['Activity']['permalink'] = $permalink;
$Activity->store($data);
break;
case 'Review':
// Skip logging of admin actions on user listings
// if($this->c->_user->id != $model->data['Review']['userid']) break;
$data['Activity']['activity_type'] = 'review';
$data['Activity']['listing_id'] = $model->data['Review']['pid'];
$data['Activity']['review_id'] = $model->data['Review']['id'];
$data['Activity']['extension'] = $model->data['Review']['mode'];
$data['Activity']['value'] = round(Sanitize::getVar($model->data, 'average_rating'), 0);
$data['Activity']['permalink'] = $Routes->reviewDiscuss('', array('review_id' => $data['Activity']['review_id']), array('return_url' => true));
$Activity->store($data);
break;
case 'OwnerReply':
// Skip logging of admin actions on user listings
// if($this->c->_user->id != $model->data['Listing']['created_by']) break;
$data['Activity']['activity_type'] = 'owner_reply';
$data['Activity']['listing_id'] = $model->data['Listing']['listing_id'];
$data['Activity']['review_id'] = $model->data['OwnerReply']['id'];
$data['Activity']['extension'] = $model->data['Listing']['extension'];
// Editing not yet implemented so all replies are new
$data['Activity']['activity_new'] = 1;
$data['Activity']['permalink'] = $Routes->reviewDiscuss('', array('review_id' => $data['Activity']['review_id']), array('return_url' => true));
$Activity->store($data);
break;
case 'Discussion':
// Skip logging of admin actions on user listings
// if($this->c->_user->id != $model->data['Discussion']['user_id']) break;
// Get listing id and extension
$this->c->_db->setQuery("\n SELECT \n Review.pid AS listing_id, Review.`mode` AS extension\n FROM \n #__jreviews_comments AS Review\n WHERE \n Review.id = " . $model->data['Discussion']['review_id']);
// Get listing owner id and check if it matches the current user
if ($listing = current($this->c->_db->loadAssocList())) {
$data['Activity']['activity_type'] = 'review_discussion';
$data['Activity']['listing_id'] = $listing['listing_id'];
$data['Activity']['review_id'] = $model->data['Discussion']['review_id'];
$data['Activity']['post_id'] = $model->data['Discussion']['discussion_id'];
$data['Activity']['extension'] = $listing['extension'];
$data['Activity']['permalink'] = $Routes->reviewDiscuss('', array('review_id' => $data['Activity']['review_id']), array('return_url' => true));
$Activity->store($data);
}
break;
case 'Report':
$data['Activity']['activity_type'] = $model->data['Report']['post_id'] ? 'discussion_report' : 'review_report';
$data['Activity']['listing_id'] = $model->data['Report']['listing_id'];
$data['Activity']['review_id'] = $model->data['Report']['review_id'];
$data['Activity']['extension'] = $model->data['Report']['extension'];
// Editing not yet implemented so all replies are new
$data['Activity']['activity_new'] = 1;
$data['Activity']['permalink'] = $Routes->reviewDiscuss('', array('review_id' => $data['Activity']['review_id']), array('return_url' => true));
$Activity->store($data);
break;
case 'Vote':
// Get listing id and extension
$this->c->_db->setQuery("\n SELECT \n Review.pid AS listing_id, Review.`mode` AS extension\n FROM \n #__jreviews_comments AS Review\n WHERE \n Review.id = " . $model->data['Vote']['review_id']);
// Get listing owner id and check if it matches the current user
if ($listing = current($this->c->_db->loadAssocList())) {
$data['Activity']['activity_type'] = 'helpful_vote';
$data['Activity']['listing_id'] = $listing['listing_id'];
$data['Activity']['review_id'] = $model->data['Vote']['review_id'];
$data['Activity']['helpful_vote_id'] = $model->data['Vote']['vote_id'];
$data['Activity']['extension'] = $listing['extension'];
$data['Activity']['value'] = $model->data['Vote']['vote_yes'];
$data['Activity']['permalink'] = $Routes->reviewDiscuss('', array('review_id' => $data['Activity']['review_id']), array('return_url' => true));
$Activity->store($data);
}
break;
}
$this->published = false;
// Run once. With paid listings it is possible for a plugin to run a 2nd time when the order is processed together with the listing (free)
}
function makeUrl($url)
{
return cmsFramework::makeAbsUrl($url, array('sef' => true, 'ampreplace' => true));
}
function shortenUrl($url)
{
$url = cmsFramework::makeAbsUrl($url, array('sef' => false, 'ampreplace' => true));
//create the URL
$version = '2.0.1';
$format = 'json';
$bitly = 'http://api.bit.ly/shorten';
$param = 'version=' . $version . '&longUrl=' . urlencode($url) . '&login='******'&apiKey=' . $this->bitly_key . '&format=' . $format . '&history=' . $this->bitly_history;
//get the url
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $bitly . "?" . $param);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
$response = curl_exec($ch);
$httpcode = curl_getinfo($ch, CURLINFO_HTTP_CODE);
curl_close($ch);
if ($httpcode != 200) {
// There was an error
return false;
}
$json = @json_decode($response, true);
return $json['results'][$url]['shortUrl'];
}
function plgAfterSave(&$model)
{
if (!isset($model->data['Email']) || !Sanitize::getInt($model->data['Email'], 'send')) {
return false;
}
# Read cms mail config settings
$configSendmailPath = cmsFramework::getConfig('sendmail');
$configSmtpAuth = cmsFramework::getConfig('smtpauth');
$configSmtpUser = cmsFramework::getConfig('smtpuser');
$configSmtpPass = cmsFramework::getConfig('smtppass');
$configSmtpHost = cmsFramework::getConfig('smtphost');
$configSmtpSecure = cmsFramework::getConfig('smtpsecure');
$configSmtpPort = cmsFramework::getConfig('smtpport');
$configMailFrom = cmsFramework::getConfig('mailfrom');
$configFromName = cmsFramework::getConfig('fromname');
$configMailer = cmsFramework::getConfig('mailer');
if (!class_exists('PHPMailer')) {
App::import('Vendor', 'phpmailer' . DS . 'class.phpmailer');
}
$mail = new PHPMailer();
$mail->CharSet = cmsFramework::getCharset();
$mail->SetLanguage('en', S2_VENDORS . 'PHPMailer' . DS . 'language' . DS);
$mail->Mailer = $configMailer;
// Mailer used mail,sendmail,smtp
switch ($configMailer) {
case 'smtp':
$mail->Host = $configSmtpHost;
$mail->SMTPAuth = $configSmtpAuth;
$mail->Username = $configSmtpUser;
$mail->Password = $configSmtpPass;
$mail->SMTPSecure = $configSmtpSecure != '' ? $configSmtpSecure : '';
$mail->Port = $configSmtpPort;
break;
case 'sendmail':
$mail->Sendmail = $configSendmailPath;
break;
default:
break;
}
$mail->isHTML(true);
$mail->From = $configMailFrom;
$mail->FromName = $configFromName;
$mail->AddReplyTo($configMailFrom, $configFromName);
// $model->data[$this->notifyModel->name]['key'] = $value;
$model->data['Email']['body'] = urldecode($model->data['__raw']['Email']['body']);
// Send html email
# In this observer model we just use the existing data to send the email notification
switch ($this->notifyModel->name) {
// Notification for claims moderation
case 'Claim':
if ($model->data['Email']['subject'] != '') {
$subject = $model->data['Email']['subject'];
$subject = str_ireplace('{name}', $model->data['Email']['name'], $subject);
$subject = str_ireplace('{listing_title}', $model->data['Email']['listing_title'], $subject);
} else {
switch ($model->data['Claim']['approved']) {
case 1:
$subject = __a("Your claim has been approved", true);
break;
case -1:
$subject = __a("Your claim has been rejected", true);
break;
case 0:
$subject = __a("Your claim has been reviewed, but still pending moderation", true);
break;
}
}
// Get permalink
$listing_id = $model->data['Listing']['id'];
$listing = $this->controller->Listing->findRow(array('conditions' => 'Listing.id = ' . $listing_id), array('afterFind'));
$permalink = cmsFramework::makeAbsUrl($listing['Listing']['url'], array('sef' => true));
$message = $model->data['Email']['body'];
$message = str_ireplace('{name}', $model->data['Email']['name'], $message);
$message = str_ireplace('{listing_title}', $model->data['Email']['listing_title'], $message);
$message = str_ireplace(array('{link}', '{url}'), $permalink, $message);
if ($message != '') {
$mail->Subject = $subject;
// Convert line breaks to br tags if html code not found on the message body
$mail->Body = nl2br($message);
$mail->AddAddress($model->data['Email']['email']);
if (!$mail->Send()) {
appLogMessage(array("Admin claim moderation message was not sent.", "Mailer error: " . $mail->ErrorInfo), 'notifications');
}
}
break;
# Notification for discussion post moderation
# Notification for discussion post moderation
case 'Discussion':
if ($model->data['Email']['subject'] != '') {
$subject = $model->data['Email']['subject'];
$subject = str_ireplace('{name}', $model->data['Email']['name'], $subject);
$subject = str_ireplace('{review_title}', $model->data['Email']['review_title'], $subject);
} else {
switch ($model->data['Discussion']['approved']) {
case 1:
$subject = __a("Your comment has been approved", true);
break;
case -1:
$subject = __a("Your comment has been rejected", true);
break;
}
}
// Get permalink
$this->controller->EverywhereAfterFind = true;
$this->controller->Review->runProcessRatings = false;
$review = $this->controller->Review->findRow(array('conditions' => array('Review.id = ' . $model->data['Discussion']['review_id'])));
$this->controller->viewVars['review'] = $review;
// Make it available to other plugins
App::import('helper', 'routes', 'jreviews');
$Routes = ClassRegistry::getClass('RoutesHelper');
$permalink = $Routes->reviewDiscuss('', $review, array('listing' => $review, 'return_url' => true));
$permalink = cmsFramework::makeAbsUrl($permalink);
$message = $model->data['Email']['body'];
$message = str_ireplace('{name}', $model->data['Email']['name'], $message);
$message = str_ireplace(array('{link}', '{url}'), $permalink, $message);
$message = str_ireplace('{review_title}', $model->data['Email']['review_title'], $message);
if ($message != '') {
$mail->Subject = $subject;
// Convert line breaks to br tags if html code not found on the message body
$mail->Body = nl2br($message);
$mail->AddAddress($model->data['Email']['email']);
if (!$mail->Send()) {
appLogMessage(array("Admin post discussion moderation message was not sent.", "Mailer error: " . $mail->ErrorInfo), 'notifications');
}
}
break;
// Notification for listing moderation
// Notification for listing moderation
case 'Listing':
if (Sanitize::getInt($model->data, 'moderation')) {
if ($model->data['Email']['subject'] != '') {
$subject = $model->data['Email']['subject'];
$subject = str_ireplace('{name}', $model->data['Email']['name'], $subject);
$subject = str_ireplace('{listing_title}', $model->data['Email']['listing_title'], $subject);
} else {
switch ($model->data['Listing']['state']) {
case 1:
$subject = __a("Your listing has been approved", true);
break;
case -2:
$subject = __a("Your listing has been rejected", true);
break;
case 0:
$subject = __a("Your listing has been reviewed, but it is still pending moderation", true);
break;
}
}
// Get permalink
$listing_id = $model->data['Listing']['id'];
$listing = $this->controller->Listing->findRow(array('conditions' => 'Listing.id = ' . $listing_id), array('afterFind'));
$permalink = cmsFramework::makeAbsUrl($listing['Listing']['url'], array('sef' => true));
$message = $model->data['Email']['body'];
$message = str_ireplace('{name}', $model->data['Email']['name'], $message);
$message = str_ireplace(array('{link}', '{url}'), $permalink, $message);
$message = str_ireplace('{listing_title}', $model->data['Email']['listing_title'], $message);
if ($message != '') {
$mail->Subject = $subject;
// Convert line breaks to br tags if html code not found on the message body
$mail->Body = nl2br($message);
$mail->AddAddress($model->data['Email']['email']);
if (!$mail->Send()) {
appLogMessage(array("Admin listing moderation message was not sent.", "Mailer error: " . $mail->ErrorInfo), 'notifications');
}
}
}
break;
// Notification for reviews moderation
// Notification for reviews moderation
case 'Review':
if (Sanitize::getInt($model->data, 'moderation')) {
if ($model->data['Email']['subject'] != '') {
$subject = $model->data['Email']['subject'];
$subject = str_ireplace('{name}', $model->data['Email']['name'], $subject);
$subject = str_ireplace('{listing_title}', $model->data['Email']['listing_title'], $subject);
$subject = str_ireplace('{review_title}', $model->data['Email']['review_title'], $subject);
} else {
switch ($model->data['Review']['published']) {
case 1:
$subject = __a("Your review has been approved", true);
break;
case -1:
$subject = __a("Your review has been rejected", true);
break;
case 0:
$subject = __a("Your review has been reviewed, but still pending moderation", true);
break;
}
}
// Get permalink
$this->controller->EverywhereAfterFind = true;
$this->controller->Review->runProcessRatings = false;
$review_id = $model->data['Review']['id'];
$review = $this->controller->Review->findRow(array('conditions' => array('Review.id = ' . $review_id)));
$this->controller->viewVars['review'] = $review;
// Make it available to other plugins
App::import('helper', 'routes', 'jreviews');
$Routes = ClassRegistry::getClass('RoutesHelper');
$permalink = $Routes->reviewDiscuss('', $review, array('listing' => $review, 'return_url' => true));
$permalink = cmsFramework::makeAbsUrl($permalink);
$message = $model->data['Email']['body'];
$message = str_ireplace('{name}', $model->data['Email']['name'], $message);
$message = str_ireplace(array('{link}', '{url}'), $permalink, $message);
$message = str_ireplace('{listing_title}', $model->data['Email']['listing_title'], $message);
$message = str_ireplace('{review_title}', $model->data['Email']['review_title'], $message);
if ($message != '') {
$mail->Subject = $subject;
// Convert line breaks to br tags if html code not found on the message body
$mail->Body = nl2br($message);
$mail->AddAddress($model->data['Email']['email']);
if (!$mail->Send()) {
appLogMessage(array("Admin review moderation message was not sent.", "Mailer error: " . $mail->ErrorInfo), 'notifications');
}
}
}
break;
// Notification for owner reply to reviews moderation
// Notification for owner reply to reviews moderation
case 'OwnerReply':
if ($model->data['Email']['subject'] != '') {
$subject = $model->data['Email']['subject'];
$subject = str_ireplace('{name}', $model->data['Email']['name'], $subject);
$subject = str_ireplace('{listing_title}', $model->data['Email']['listing_title'], $subject);
$subject = str_ireplace('{review_title}', $model->data['Email']['review_title'], $subject);
} else {
switch ($model->data['OwnerReply']['owner_reply_approved']) {
case 1:
$subject = __a("Your reply has been approved", true);
break;
case -1:
$subject = __a("Your reply has been rejected", true);
break;
case 0:
$subject = __a("Your reply has been reviewed, but still pending moderation", true);
break;
}
}
// Get permalink
$this->controller->EverywhereAfterFind = true;
$this->controller->Review->runProcessRatings = false;
$review_id = $model->data['OwnerReply']['id'];
$review = $this->controller->Review->findRow(array('conditions' => array('Review.id = ' . $review_id)));
$this->controller->viewVars['review'] = $review;
// Make it available to other plugins
App::import('helper', 'routes', 'jreviews');
$Routes = ClassRegistry::getClass('RoutesHelper');
$permalink = $Routes->reviewDiscuss('', $review, array('listing' => $review, 'return_url' => true));
$permalink = cmsFramework::makeAbsUrl($permalink);
$message = $model->data['Email']['body'];
$message = str_ireplace('{name}', $model->data['Email']['name'], $message);
$message = str_ireplace(array('{link}', '{url}'), $permalink, $message);
$message = str_ireplace('{listing_title}', $model->data['Email']['listing_title'], $message);
$message = str_ireplace('{review_title}', $model->data['Email']['review_title'], $message);
if ($message != '') {
$mail->Subject = $subject;
// Convert line breaks to br tags if html code not found on the message body
$mail->Body = nl2br($message);
$mail->AddAddress($model->data['Email']['email']);
if (!$mail->Send()) {
appLogMessage(array("Admin owner reply moderation message was not sent.", "Mailer error: " . $mail->ErrorInfo), 'notifications');
}
}
break;
}
unset($mail);
return true;
}
function listings()
{
if (Sanitize::getString($this->params, 'action') == 'xml') {
$access = $this->cmsVersion == CMS_JOOMLA15 ? $this->Access->getAccessId() : $this->Access->getAccessLevels();
$feed_filename = PATH_ROOT . 'cache' . DS . 'jreviewsfeed_' . md5($access . $this->here) . '.xml';
$this->Feeds->useCached($feed_filename, 'listings');
}
$this->name = 'categories';
// Required for assets helper
if ($this->_user->id === 0 && ($this->action != 'search' || $this->action == 'search' && Sanitize::getVar($this->params, 'tag') != '')) {
$this->cacheAction = Configure::read('Cache.expires');
}
$this->autoRender = false;
$action = Sanitize::paranoid($this->action);
$dir_id = str_replace(array('_', ' '), array(',', ''), Sanitize::getString($this->params, 'dir'));
$section_id = Sanitize::getString($this->params, 'section');
$cat_id = Sanitize::getString($this->params, 'cat');
$criteria_id = Sanitize::getString($this->params, 'criteria');
$user_id = Sanitize::getInt($this->params, 'user', $this->_user->id);
$index = Sanitize::getString($this->params, 'index');
$sort = Sanitize::getString($this->params, 'order');
if ($sort == '' && in_array($this->action, array('category', 'section', 'alphaindex', 'search', 'custom'))) {
$sort = Sanitize::getString($this->Config, 'list_order_field');
}
$sort == '' and $sort = Sanitize::getString($this->Config, 'list_order_default');
$menu_id = Sanitize::getInt($this->params, 'menu', Sanitize::getString($this->params, 'Itemid'));
// Avoid running the listing query if in section page and listings disabled
$query_listings = $this->action != 'section' || $this->action == 'section' && $this->Config->list_show_sectionlist;
$total_special = Sanitize::getInt($this->data, 'total_special');
if (!in_array($this->action, array('section', 'category')) && $total_special > 0) {
$total_special <= $this->limit and $this->limit = $total_special;
}
$listings = array();
$parent_categories = array();
$count = 0;
$conditions = array();
$joins = array();
if ($action == 'category') {
// Find directory and section id
if ($this->cmsVersion == CMS_JOOMLA15 && ($category = $this->Category->findRow(array('conditions' => array('Category.id = ' . $cat_id))))) {
$dir_id = $this->params['dir'] = $category['Category']['dir_id'];
$section_id = $this->params['section'] = $category['Category']['section_id'];
} elseif ($parent_categories = $this->Category->findParents($cat_id)) {
$category = end($parent_categories);
// This is the current category
if (!$category['Category']['published'] || !$this->Access->isAuthorized($category['Category']['access'])) {
echo $this->render('elements', 'login');
return;
}
$dir_id = $this->params['dir'] = $category['Directory']['dir_id'];
$categories = $this->Category->findTree(array('cat_id' => $cat_id));
}
# Override global configuration
isset($category['ListingType']) and $this->Config->override($category['ListingType']['config']);
$sort = Sanitize::getString($this->params, 'order', Sanitize::getString($this->Config, 'list_order_field'));
$sort == '' and $sort = Sanitize::getString($this->Config, 'list_order_default');
}
# Remove unnecessary fields from model query
$this->Listing->modelUnbind('Listing.fulltext AS `Listing.description`');
# Get section and category database information
if ($this->cmsVersion == CMS_JOOMLA15 && in_array($action, array('section', 'category'))) {
$fields = array();
# Get all categories for page
if ($this->Config->dir_cat_num_entries || $this->Config->dir_category_hide_empty) {
$fields = array('
(SELECT
count(*)
FROM #__content AS Listing
INNER JOIN #__jreviews_categories AS JreviewsCategory ON JreviewsCategory.id = Listing.catid AND JreviewsCategory.`option` = "com_content"
WHERE
Listing.sectionid = ' . $section_id . '
AND Listing.catid = Category.id
AND Listing.state = 1
AND Listing.access <= ' . $this->Access->getAccessId() . '
AND ( Listing.publish_up = "' . NULL_DATE . '" OR Listing.publish_up <= "' . _CURRENT_SERVER_TIME . '" )
AND ( Listing.publish_down = "' . NULL_DATE . '" OR Listing.publish_down >= "' . _CURRENT_SERVER_TIME . '" )
) AS `Category.listing_count`
');
}
$categories = $this->Category->findAll(array('fields' => $fields, 'conditions' => array('Category.section = ' . (int) $section_id, 'Category.published = 1'), 'order' => $this->Config->dir_category_order ? 'Category.title ASC' : 'Category.ordering ASC'));
$category_tmp = current($categories);
$dir_id = $category_tmp['Category']['dir_id'];
$section = $this->Section->findRow(array('fields' => array((int) $dir_id . ' AS `Section.dir_id`'), 'conditions' => array('Section.id = ' . (int) $section_id)));
# Fake the parent_categories array based on section and category
isset($section) and $parent_categories[]['Category'] = $section['Section'];
isset($category) and $parent_categories[]['Category'] = $category['Category'];
}
# Set the theme layout and suffix
$this->Theming->setSuffix(array('categories' => $parent_categories));
$this->Theming->setLayout(array('categories' => $parent_categories));
if (isset($section) && !empty($section) && (!$this->Access->isAuthorized($section['Section']['access']) || !$section['Section']['published']) || $this->action == 'category' && isset($category) && !empty($category) && (!$this->Access->isAuthorized($category['Category']['access']) || !$category['Category']['published'])) {
echo $this->render('elements', 'login');
return;
}
# Get listings
# Modify and perform database query based on lisPage type
if ($action == 'section' && $this->Config->list_show_sectionlist || $action != 'section') {
// Build where statement
switch ($action) {
case 'alphaindex':
// $index = isset($index{0}) ? $index{0} : '';
$conditions[] = $index == '0' ? 'Listing.title REGEXP "^[0-9]"' : 'Listing.title LIKE ' . $this->quote($index . '%');
break;
}
$section_id = cleanIntegerCommaList($section_id);
$cat_id = cleanIntegerCommaList($cat_id);
$dir_id = cleanIntegerCommaList($dir_id);
$criteria_id = cleanIntegerCommaList($criteria_id);
if (!empty($cat_id)) {
if ($this->cmsVersion == CMS_JOOMLA15 || $this->cmsVersion != CMS_JOOMLA15 && !$this->Config->list_show_child_listings) {
if ($this->cmsVersion != CMS_JOOMLA15) {
$conditions[] = 'ParentCategory.id IN (' . $cat_id . ')';
}
$conditions[] = 'Category.id IN (' . $cat_id . ')';
// Exclude listings from child categories
} else {
$conditions[] = 'ParentCategory.id IN (' . $cat_id . ')';
}
} else {
unset($this->Listing->joins['ParentCategory']);
}
empty($cat_id) and !empty($section_id) and $conditions[] = 'Listing.sectionid IN (' . $section_id . ')';
empty($cat_id) and !empty($dir_id) and $conditions[] = 'JreviewsCategory.dirid IN (' . $dir_id . ')';
empty($cat_id) and !empty($criteria_id) and $conditions[] = 'JreviewsCategory.criteriaid IN (' . $criteria_id . ')';
if ($this->action == 'mylistings' && $user_id == $this->_user->id || $this->Access->isPublisher()) {
$conditions[] = 'Listing.state >= 0';
} else {
$conditions[] = 'Listing.state = 1';
$conditions[] = '( Listing.publish_up = "' . NULL_DATE . '" OR Listing.publish_up <= "' . _CURRENT_SERVER_TIME . '" )';
$conditions[] = '( Listing.publish_down = "' . NULL_DATE . '" OR Listing.publish_down >= "' . _CURRENT_SERVER_TIME . '" )';
}
# Shows only links users can access
if ($this->cmsVersion == CMS_JOOMLA15) {
// $conditions[] = 'Section.access <= ' . $this->Access->getAccessId();
$conditions[] = 'Category.access <= ' . $this->Access->getAccessId();
$conditions[] = 'Listing.access <= ' . $this->Access->getAccessId();
} else {
$conditions[] = 'Category.access IN ( ' . $this->Access->getAccessLevels() . ')';
$conditions[] = 'Listing.access IN ( ' . $this->Access->getAccessLevels() . ')';
}
$queryData = array('joins' => $joins, 'conditions' => $conditions, 'limit' => $this->limit, 'offset' => $this->offset);
# Modify query for correct ordering. Change FIELDS, ORDER BY and HAVING BY directly in Listing Model variables
if ($this->action != 'custom' || $this->action == 'custom' && empty($this->Listing->order)) {
$this->Listing->processSorting($action, $sort);
}
// This is used in Listings model to know whether this is a list page to remove the plugin tags
$this->Listing->controller = 'categories';
// Check if review scope checked in advancd search
$scope = explode('_', Sanitize::getString($this->params, 'scope'));
if ($this->action == 'search' && in_array('reviews', $scope)) {
$queryData['joins'][] = "LEFT JOIN #__jreviews_comments AS Review ON Listing.id = Review.pid AND Review.published = 1 AND Review.mode = 'com_content'";
$queryData['group'][] = "Listing.id";
// Group By required due to one to many relationship between listings => reviews table
}
$query_listings and $listings = $this->Listing->findAll($queryData);
# If only one result then redirect to it
if ($this->Config->search_one_result && count($listings) == 1 && $this->action == 'search' && $this->page == 1) {
$listing = array_shift($listings);
$url = cmsFramework::makeAbsUrl($listing['Listing']['url'], array('sef' => true));
cmsFramework::redirect($url);
}
# Get the listing count
if (in_array($action, array('section', 'category'))) {
unset($queryData['joins']);
$this->Listing->joins = array("INNER JOIN #__jreviews_categories AS JreviewsCategory ON Listing.catid = JreviewsCategory.id AND JreviewsCategory.`option` = 'com_content'", 'Category' => "LEFT JOIN #__categories AS Category ON JreviewsCategory.id = Category.id", 'ParentCategory' => "LEFT JOIN #__categories AS ParentCategory ON Category.lft BETWEEN ParentCategory.lft AND ParentCategory.rgt", "LEFT JOIN #__jreviews_listing_totals AS Totals ON Totals.listing_id = Listing.id AND Totals.extension = 'com_content'", "LEFT JOIN #__jreviews_content AS Field ON Field.contentid = Listing.id", "LEFT JOIN #__jreviews_directories AS Directory ON JreviewsCategory.dirid = Directory.id");
} elseif ($action != 'favorites') {
unset($queryData['joins']);
$this->Listing->joins = array("INNER JOIN #__jreviews_categories AS JreviewsCategory ON Listing.catid = JreviewsCategory.id AND JreviewsCategory.`option` = 'com_content'", 'Category' => "LEFT JOIN #__categories AS Category ON JreviewsCategory.id = Category.id", 'ParentCategory' => "LEFT JOIN #__categories AS ParentCategory ON Category.lft BETWEEN ParentCategory.lft AND ParentCategory.rgt", "LEFT JOIN #__jreviews_listing_totals AS Totals ON Totals.listing_id = Listing.id AND Totals.extension = 'com_content'", "LEFT JOIN #__jreviews_content AS Field ON Field.contentid = Listing.id", "LEFT JOIN #__jreviews_directories AS Directory ON JreviewsCategory.dirid = Directory.id");
if ($this->action == 'search' && in_array('reviews', $scope)) {
$queryData['joins'][] = "LEFT JOIN #__jreviews_comments AS Review ON Listing.id = Review.pid AND Review.published = 1 AND Review.mode = 'com_content'";
}
}
if ($this->cmsVersion == CMS_JOOMLA15 || empty($cat_id)) {
unset($this->Listing->joins['ParentCategory']);
// Exclude listings from child categories
}
// Need to add user table join for author searches
if (isset($this->params['author'])) {
$queryData['joins'][] = "LEFT JOIN #__users AS User ON User.id = Listing.created_by";
}
if ($query_listings && !isset($this->Listing->count)) {
$count = $this->Listing->findCount($queryData, $this->action == 'search' && in_array('reviews', $scope) ? 'DISTINCT Listing.id' : '*');
} else {
$count = $this->Listing->count;
}
if ($total_special > 0 && $total_special < $count) {
$count = Sanitize::getInt($this->data, 'total_special');
}
}
# Get directory info for breadcrumb if dir id is a url parameter
$directory = array();
if (is_numeric($dir_id)) {
$directory = $this->Directory->findRow(array('fields' => array('Directory.id AS `Directory.dir_id`', 'Directory.title AS `Directory.slug`', 'Directory.desc AS `Directory.title`'), 'conditions' => array('Directory.id = ' . $dir_id)));
}
/******************************************************************
* Process page title and description
*******************************************************************/
$name_choice = $this->Config->name_choice == 'alias' ? 'username' : 'name';
$page['show_title'] = 1;
$page['show_description'] = 1;
switch ($action) {
case 'section':
$menuParams = $this->Menu->getMenuParams($menu_id);
$page = $section['Section'];
$page['title'] = trim(Sanitize::getString($menuParams, 'title')) != '' ? Sanitize::getString($menuParams, 'title') : $section['Section']['title'];
$page['show_title'] = Sanitize::getInt($this->data, 'dirtitle', 1);
$page['show_description'] = 1;
break;
case 'category':
$menuParams = $this->Menu->getMenuParams($menu_id);
$page = $category['Category'];
$page['title'] = trim(Sanitize::getString($menuParams, 'title')) != '' ? Sanitize::getString($menuParams, 'title') : $category['Category']['title'];
$page['show_title'] = Sanitize::getInt($this->data, 'dirtitle', 1);
$page['show_description'] = 1;
Sanitize::getString($category['Category'], 'metadesc') == '' and $page['metadesc'] = Sanitize::htmlClean($category['Category']['description']);
# Check if this is a listing submit category or disable listing submissions
if (Sanitize::getInt($category['Category'], 'criteria_id') == 0) {
$this->Config->list_show_addnew = 0;
}
break;
case 'custom':
$menuParams = $this->Menu->getMenuParams($menu_id);
$page['top_description'] = Sanitize::getString($menuParams, 'custom_description');
$page['top_description'] = str_replace('\\n', '', $page['top_description']);
$page['show_description'] = $page['top_description'] != '';
$page['show_title'] = Sanitize::getInt($menuParams, 'dirtitle');
$page['title'] = Sanitize::getString($menuParams, 'title');
if (!$page['title']) {
$page['title'] = $this->Menu->getMenuName($menu_id);
}
break;
case 'alphaindex':
$title = isset($directory['Directory']) ? Sanitize::getString($directory['Directory'], 'title', '') : '';
$page['title'] = $title != '' ? $title . ' - ' . ($index == '0' ? '0-9' : $index) : ($index == '0' ? '0-9' : $index);
break;
case 'mylistings':
if ($user_id > 0) {
$user_name = $this->User->findOne(array('fields' => array('User.' . $name_choice . ' AS `User.name`'), 'conditions' => array('User.id = ' . $user_id)));
} elseif ($this->_user->id > 0) {
$user_name = $this->_user->{$name_choice};
}
$page['title'] = sprintf(__t("Listings by %s", true), $user_name);
break;
case 'favorites':
// Not running from CB Plugin so we change the page title
if (!isset($this->Config->in_cb)) {
if ($user_id > 0) {
$user_name = $this->User->findOne(array('fields' => array('User.' . $name_choice . ' AS `User.name`'), 'conditions' => array('User.id = ' . $user_id)));
} elseif ($this->_user->id > 0) {
$user_name = $this->_user->{$name_choice};
}
$page['title'] = sprintf(__t("Favorites by %s", true), $user_name);
}
break;
case 'list':
case 'search':
$this->__seo_fields($page);
break;
case 'featured':
case 'latest':
case 'mostreviews':
case 'popular':
case 'toprated':
case 'topratededitor':
$menuParams = $this->Menu->getMenuParams($menu_id);
$page['show_title'] = Sanitize::getInt($menuParams, 'dirtitle');
$page['title'] = Sanitize::getString($menuParams, 'title');
if (!$page['title'] && isset($this->Menu->menues[$menu_id])) {
$page['title'] = $this->Menu->menues[$menu_id]->name;
}
break;
default:
$page['title'] = $this->Menu->getMenuName($menu_id);
break;
}
// If empty unset the keys so they don't overwrite the ones set via menu
if (trim(strip_tags(Sanitize::getString($page, 'description'))) == '') {
unset($page['description']);
}
if (trim(strip_tags(Sanitize::getString($page, 'keywords'))) == '') {
unset($page['keywords']);
}
/******************************************************************
* Generate SEO titles for re-ordered pages (most reviews, top user rated, etc.)
*******************************************************************/
# Category ids to be used for ordering list
$cat_ids = array();
if (in_array($action, array('search', 'category'))) {
$cat_ids = $cat_id;
} elseif (!empty($categories)) {
$cat_ids = implode(',', array_keys($categories));
}
$field_order_array = $this->Field->getOrderList($cat_ids, 'listing', $this->action, array('section', 'category', 'search', 'alphaindex'));
isset($page['title']) and $page['title_seo'] = $page['title'];
if (($this->action != 'search' || Sanitize::getVar($this->params, 'tag')) && isset($this->params['order']) && $sort != '') {
App::import('helper', 'jreviews', 'jreviews');
$ordering_options = JreviewsHelper::orderingOptions();
$tmp_order = str_replace('rjr', 'jr', $sort);
if (isset($ordering_options[$sort])) {
$page['title_seo'] .= ' ' . sprintf(__t("ordered by %s", true), mb_strtolower($ordering_options[$sort], 'UTF-8'));
} elseif (isset($field_order_array[$tmp_order])) {
if ($sort[0] == 'r') {
$page['title_seo'] .= ' ' . sprintf(__t("ordered by %s desc", true), mb_strtolower($field_order_array[$tmp_order]['text'], 'UTF-8'));
} else {
$page['title_seo'] .= ' ' . sprintf(__t("ordered by %s", true), mb_strtolower($field_order_array[$sort]['text'], 'UTF-8'));
}
}
}
$this->params['order'] = $sort;
// This is the param read in the views so we need to update it
/******************************************************************
* Set view (theme) vars
*******************************************************************/
$this->set(array('Config' => $this->Config, 'Access' => $this->Access, 'User' => $this->_user, 'subclass' => 'listing', 'page' => $page, 'directory' => $directory, 'section' => isset($section) ? $section : array(), 'category' => isset($category) ? $category : array(), 'categories' => isset($categories) ? $categories : array(), 'parent_categories' => $parent_categories, 'listings' => $listings, 'pagination' => array('total' => $count)));
$query_listings and $this->set('order_list', $field_order_array);
/******************************************************************
* RSS Feed: caches and displays feed when xml action param is present
*******************************************************************/
if (Sanitize::getString($this->params, 'action') == 'xml') {
$this->Feeds->saveFeed($feed_filename, 'listings');
}
echo $this->render('listings', 'listings_' . $this->tmpl_list);
}
/**
* Facebook Open Graph implementation
*
* @param mixed $listing
* @param mixed $meta
*/
function facebookOpenGraph(&$listing, $meta)
{
// http://developers.facebook.com/docs/opengraph/
$option = Sanitize::getString($_REQUEST, 'option', '');
$view = Sanitize::getString($_REQUEST, 'view', '');
$id = Sanitize::getInt($_REQUEST, 'id');
// Make sure this is a Joomla article page
if (!($option == 'com_content' && $view == 'article' && $id)) {
return;
}
$Config = Configure::read('JreviewsSystem.Config');
if (empty($Config)) {
$cache_file = 'jreviews_config_' . md5(cmsFramework::getConfig('secret'));
$Config = S2Cache::read($cache_file);
}
$facebook_xfbml = Sanitize::getBool($Config, 'facebook_opengraph') && Sanitize::getBool($Config, 'facebook_appid');
// Make sure FB is enabled and we have an FB App Id
if (!$facebook_xfbml) {
return;
}
extract($meta);
$title == '' and $title = $listing['Listing']['title'];
$description == '' and $description = Sanitize::htmlClean(Sanitize::stripAll($listing['Listing'], 'summary'));
$image = isset($listing['Listing']['images'][0]) ? cmsFramework::makeAbsUrl(_DS . _JR_WWW_IMAGES . $listing['Listing']['images'][0]['path']) : null;
if (!$image) {
$img_src = '/<img[^>]+src[\\s=\'"]+([^"\'>\\s]+(jpg)+)/is';
preg_match($img_src, $listing['Listing']['summary'], $matches);
if (isset($matches[1])) {
$image = $matches[1];
}
}
$url = cmsFramework::makeAbsUrl($listing['Listing']['url'], array('sef' => true, 'ampreplace' => true));
$fields = $listing['Field']['pairs'];
// You can add other Open Graph meta tags by adding the attribute, custom field pair to the array below
$tags = array('title' => $title, 'url' => $url, 'image' => $image, 'site_name' => cmsFramework::getConfig('sitename'), 'description' => $description, 'type' => Sanitize::getString($listing['ListingType']['config'], 'facebook_opengraph_type'), 'latitude' => Sanitize::getString($Config, 'geomaps.latitude'), 'longitude' => Sanitize::getString($Config, 'geomaps.longitude'), 'street-address' => Sanitize::getString($Config, 'geomaps.address1'), 'locality' => Sanitize::getString($Config, 'geomaps.city'), 'region' => Sanitize::getString($Config, 'geomaps.state'), 'postal-code' => Sanitize::getString($Config, 'geomaps.postal_code'), 'country-name' => Sanitize::getString($Config, 'geomaps.country', Sanitize::getString($Config, 'geomaps.default_country')));
cmsFramework::addScript('<meta property="fb:app_id" content="' . Sanitize::getString($Config, 'facebook_appid') . '"/>');
Sanitize::getString($Config, 'facebook_admins') != '' and cmsFramework::addScript('<meta property="fb:admins" content="' . str_replace(' ', '', $Config->facebook_admins) . '"/>');
// cmsFramework::addScript('<meta property="fb:admins" content="YOUR-ADMIN-ID"/>'); // It's app_id or this, not both
# Loop through the tags array to add the additional FB meta tags
foreach ($tags as $attr => $fname) {
$content = '';
if (substr($fname, 0, 3) == 'jr_') {
// It's a custom field
$content = isset($fields[$fname]) ? htmlspecialchars($fields[$fname]['text'][0], ENT_QUOTES, 'utf-8') : '';
} elseif ($fname != '') {
// It's a static text, not a custom field
$content = htmlspecialchars($fname);
}
$content != '' and cmsFramework::addScript('<meta property="og:' . $attr . '" content="' . $content . '"/>');
}
}