415 lines
12 KiB
PHP
415 lines
12 KiB
PHP
<?php
|
|
/**
|
|
* @package Joomla.Site
|
|
* @subpackage com_contact
|
|
*
|
|
* @copyright Copyright (C) 2005 - 2013 Open Source Matters, Inc. All rights reserved.
|
|
* @license GNU General Public License version 2 or later; see LICENSE.txt
|
|
*/
|
|
|
|
defined('_JEXEC') or die;
|
|
|
|
/**
|
|
* @package Joomla.Site
|
|
* @subpackage com_contact
|
|
* @since 1.5
|
|
*/
|
|
class ContactModelContact extends JModelForm
|
|
{
|
|
/**
|
|
* @since 1.6
|
|
*/
|
|
protected $view_item = 'contact';
|
|
|
|
protected $_item = null;
|
|
|
|
/**
|
|
* Model context string.
|
|
*
|
|
* @var string
|
|
*/
|
|
protected $_context = 'com_contact.contact';
|
|
|
|
/**
|
|
* Method to auto-populate the model state.
|
|
*
|
|
* Note. Calling getState in this method will result in recursion.
|
|
*
|
|
* @since 1.6
|
|
*/
|
|
protected function populateState()
|
|
{
|
|
$app = JFactory::getApplication('site');
|
|
|
|
// Load state from the request.
|
|
$pk = $app->input->getInt('id');
|
|
$this->setState('contact.id', $pk);
|
|
|
|
// Load the parameters.
|
|
$params = $app->getParams();
|
|
$this->setState('params', $params);
|
|
|
|
$user = JFactory::getUser();
|
|
if ((!$user->authorise('core.edit.state', 'com_contact')) && (!$user->authorise('core.edit', 'com_contact'))){
|
|
$this->setState('filter.published', 1);
|
|
$this->setState('filter.archived', 2);
|
|
}
|
|
}
|
|
|
|
/**
|
|
* Method to get the contact form.
|
|
*
|
|
* The base form is loaded from XML and then an event is fired
|
|
*
|
|
*
|
|
* @param array $data An optional array of data for the form to interrogate.
|
|
* @param boolean $loadData True if the form is to load its own data (default case), false if not.
|
|
* @return JForm A JForm object on success, false on failure
|
|
* @since 1.6
|
|
*/
|
|
public function getForm($data = array(), $loadData = true)
|
|
{
|
|
// Get the form.
|
|
$form = $this->loadForm('com_contact.contact', 'contact', array('control' => 'jform', 'load_data' => true));
|
|
if (empty($form))
|
|
{
|
|
return false;
|
|
}
|
|
|
|
$id = $this->getState('contact.id');
|
|
$params = $this->getState('params');
|
|
$contact = $this->_item[$id];
|
|
$params->merge($contact->params);
|
|
|
|
if (!$params->get('show_email_copy', 0)){
|
|
$form->removeField('contact_email_copy');
|
|
}
|
|
|
|
return $form;
|
|
}
|
|
|
|
protected function loadFormData()
|
|
{
|
|
$data = (array) JFactory::getApplication()->getUserState('com_contact.contact.data', array());
|
|
|
|
$this->preprocessData('com_contact.contact', $data);
|
|
|
|
return $data;
|
|
}
|
|
|
|
/**
|
|
* Gets a contact
|
|
*
|
|
* @param integer $pk Id for the contact
|
|
*
|
|
* @return mixed Object or null
|
|
*/
|
|
public function &getItem($pk = null)
|
|
{
|
|
$pk = (!empty($pk)) ? $pk : (int) $this->getState('contact.id');
|
|
|
|
if ($this->_item === null)
|
|
{
|
|
$this->_item = array();
|
|
}
|
|
|
|
if (!isset($this->_item[$pk]))
|
|
{
|
|
try
|
|
{
|
|
$db = $this->getDbo();
|
|
$query = $db->getQuery(true);
|
|
|
|
//sqlsrv changes
|
|
$case_when = ' CASE WHEN ';
|
|
$case_when .= $query->charLength('a.alias', '!=', '0');
|
|
$case_when .= ' THEN ';
|
|
$a_id = $query->castAsChar('a.id');
|
|
$case_when .= $query->concatenate(array($a_id, 'a.alias'), ':');
|
|
$case_when .= ' ELSE ';
|
|
$case_when .= $a_id.' END as slug';
|
|
|
|
$case_when1 = ' CASE WHEN ';
|
|
$case_when1 .= $query->charLength('c.alias', '!=', '0');
|
|
$case_when1 .= ' THEN ';
|
|
$c_id = $query->castAsChar('c.id');
|
|
$case_when1 .= $query->concatenate(array($c_id, 'c.alias'), ':');
|
|
$case_when1 .= ' ELSE ';
|
|
$case_when1 .= $c_id.' END as catslug';
|
|
|
|
$query->select($this->getState('item.select', 'a.*') . ','.$case_when.','.$case_when1)
|
|
->from('#__contact_details AS a')
|
|
|
|
// Join on category table.
|
|
->select('c.title AS category_title, c.alias AS category_alias, c.access AS category_access')
|
|
->join('LEFT', '#__categories AS c on c.id = a.catid')
|
|
|
|
// Join over the categories to get parent category titles
|
|
->select('parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias')
|
|
->join('LEFT', '#__categories as parent ON parent.id = c.parent_id')
|
|
|
|
->where('a.id = ' . (int) $pk);
|
|
|
|
// Filter by start and end dates.
|
|
$nullDate = $db->quote($db->getNullDate());
|
|
$nowDate = $db->quote(JFactory::getDate()->toSql());
|
|
|
|
// Filter by published state.
|
|
$published = $this->getState('filter.published');
|
|
$archived = $this->getState('filter.archived');
|
|
if (is_numeric($published))
|
|
{
|
|
$query->where('(a.published = ' . (int) $published . ' OR a.published =' . (int) $archived . ')')
|
|
->where('(a.publish_up = ' . $nullDate . ' OR a.publish_up <= ' . $nowDate . ')')
|
|
->where('(a.publish_down = ' . $nullDate . ' OR a.publish_down >= ' . $nowDate . ')');
|
|
}
|
|
|
|
$db->setQuery($query);
|
|
|
|
$data = $db->loadObject();
|
|
|
|
if (empty($data))
|
|
{
|
|
JError::raiseError(404, JText::_('COM_CONTACT_ERROR_CONTACT_NOT_FOUND'));
|
|
}
|
|
|
|
// Check for published state if filter set.
|
|
if (((is_numeric($published)) || (is_numeric($archived))) && (($data->published != $published) && ($data->published != $archived)))
|
|
{
|
|
JError::raiseError(404, JText::_('COM_CONTACT_ERROR_CONTACT_NOT_FOUND'));
|
|
}
|
|
|
|
// Convert parameter fields to objects.
|
|
$registry = new JRegistry;
|
|
$registry->loadString($data->params);
|
|
$data->params = clone $this->getState('params');
|
|
$data->params->merge($registry);
|
|
|
|
$registry = new JRegistry;
|
|
$registry->loadString($data->metadata);
|
|
$data->metadata = $registry;
|
|
|
|
$data->tags = new JHelperTags;
|
|
$data->tags->getItemTags('com_contact.contact', $data->id);
|
|
|
|
// Compute access permissions.
|
|
if ($access = $this->getState('filter.access')) {
|
|
|
|
// If the access filter has been set, we already know this user can view.
|
|
$data->params->set('access-view', true);
|
|
}
|
|
else {
|
|
// If no access filter is set, the layout takes some responsibility for display of limited information.
|
|
$user = JFactory::getUser();
|
|
$groups = $user->getAuthorisedViewLevels();
|
|
|
|
if ($data->catid == 0 || $data->category_access === null)
|
|
{
|
|
$data->params->set('access-view', in_array($data->access, $groups));
|
|
}
|
|
else {
|
|
$data->params->set('access-view', in_array($data->access, $groups) && in_array($data->category_access, $groups));
|
|
}
|
|
}
|
|
$this->_item[$pk] = $data;
|
|
}
|
|
catch (Exception $e)
|
|
{
|
|
$this->setError($e);
|
|
$this->_item[$pk] = false;
|
|
}
|
|
}
|
|
|
|
if ($this->_item[$pk])
|
|
{
|
|
if ($extendedData = $this->getContactQuery($pk))
|
|
{
|
|
$this->_item[$pk]->articles = $extendedData->articles;
|
|
$this->_item[$pk]->profile = $extendedData->profile;
|
|
}
|
|
}
|
|
return $this->_item[$pk];
|
|
}
|
|
|
|
protected function getContactQuery($pk = null)
|
|
{
|
|
// TODO: Cache on the fingerprint of the arguments
|
|
$db = $this->getDbo();
|
|
$user = JFactory::getUser();
|
|
$pk = (!empty($pk)) ? $pk : (int) $this->getState('contact.id');
|
|
|
|
$query = $db->getQuery(true);
|
|
if ($pk)
|
|
{
|
|
//sqlsrv changes
|
|
$case_when = ' CASE WHEN ';
|
|
$case_when .= $query->charLength('a.alias', '!=', '0');
|
|
$case_when .= ' THEN ';
|
|
$a_id = $query->castAsChar('a.id');
|
|
$case_when .= $query->concatenate(array($a_id, 'a.alias'), ':');
|
|
$case_when .= ' ELSE ';
|
|
$case_when .= $a_id.' END as slug';
|
|
|
|
$case_when1 = ' CASE WHEN ';
|
|
$case_when1 .= $query->charLength('cc.alias', '!=', '0');
|
|
$case_when1 .= ' THEN ';
|
|
$c_id = $query->castAsChar('cc.id');
|
|
$case_when1 .= $query->concatenate(array($c_id, 'cc.alias'), ':');
|
|
$case_when1 .= ' ELSE ';
|
|
$case_when1 .= $c_id.' END as catslug';
|
|
$query->select(
|
|
'a.*, cc.access as category_access, cc.title as category_name, '
|
|
. $case_when . ',' . $case_when1
|
|
)
|
|
|
|
->from('#__contact_details AS a')
|
|
|
|
->join('INNER', '#__categories AS cc on cc.id = a.catid')
|
|
|
|
->where('a.id = ' . (int) $pk);
|
|
$published = $this->getState('filter.published');
|
|
if (is_numeric($published))
|
|
{
|
|
$query->where('a.published IN (1,2)')
|
|
->where('cc.published IN (1,2)');
|
|
}
|
|
$groups = implode(',', $user->getAuthorisedViewLevels());
|
|
$query->where('a.access IN ('.$groups.')');
|
|
|
|
try
|
|
{
|
|
$db->setQuery($query);
|
|
$result = $db->loadObject();
|
|
|
|
if (empty($result))
|
|
{
|
|
throw new Exception(JText::_('COM_CONTACT_ERROR_CONTACT_NOT_FOUND'), 404);
|
|
}
|
|
|
|
// If we are showing a contact list, then the contact parameters take priority
|
|
// So merge the contact parameters with the merged parameters
|
|
if ($this->getState('params')->get('show_contact_list'))
|
|
{
|
|
$registry = new JRegistry;
|
|
$registry->loadString($result->params);
|
|
$this->getState('params')->merge($registry);
|
|
}
|
|
}
|
|
catch (Exception $e)
|
|
{
|
|
$this->setError($e);
|
|
return false;
|
|
}
|
|
|
|
if ($result)
|
|
{
|
|
$user = JFactory::getUser();
|
|
$groups = implode(',', $user->getAuthorisedViewLevels());
|
|
|
|
//get the content by the linked user
|
|
$query = $db->getQuery(true)
|
|
->select('a.id')
|
|
->select('a.title')
|
|
->select('a.state')
|
|
->select('a.access')
|
|
->select('a.created');
|
|
|
|
// SQL Server changes
|
|
$case_when = ' CASE WHEN ';
|
|
$case_when .= $query->charLength('a.alias', '!=', '0');
|
|
$case_when .= ' THEN ';
|
|
$a_id = $query->castAsChar('a.id');
|
|
$case_when .= $query->concatenate(array($a_id, 'a.alias'), ':');
|
|
$case_when .= ' ELSE ';
|
|
$case_when .= $a_id.' END as slug';
|
|
$case_when1 = ' CASE WHEN ';
|
|
$case_when1 .= $query->charLength('c.alias', '!=', '0');
|
|
$case_when1 .= ' THEN ';
|
|
$c_id = $query->castAsChar('c.id');
|
|
$case_when1 .= $query->concatenate(array($c_id, 'c.alias'), ':');
|
|
$case_when1 .= ' ELSE ';
|
|
$case_when1 .= $c_id.' END as catslug';
|
|
$query->select($case_when1 . ',' . $case_when)
|
|
->from('#__content as a')
|
|
->join('LEFT', '#__categories as c on a.catid=c.id')
|
|
->where('a.created_by = ' . (int) $result->user_id)
|
|
->where('a.access IN ('. $groups.')')
|
|
->order('a.state DESC, a.created DESC');
|
|
// filter per language if plugin published
|
|
if (JLanguageMultilang::isEnabled())
|
|
{
|
|
$query->where(('a.created_by = ' . (int) $result->user_id) AND ('a.language=' . $db->quote(JFactory::getLanguage()->getTag()) . ' OR a.language=' . $db->quote('*')));
|
|
}
|
|
if (is_numeric($published))
|
|
{
|
|
$query->where('a.state IN (1,2)');
|
|
}
|
|
$db->setQuery($query, 0, 10);
|
|
$articles = $db->loadObjectList();
|
|
$result->articles = $articles;
|
|
|
|
//get the profile information for the linked user
|
|
require_once JPATH_ADMINISTRATOR.'/components/com_users/models/user.php';
|
|
$userModel = JModelLegacy::getInstance('User', 'UsersModel', array('ignore_request' => true));
|
|
$data = $userModel->getItem((int) $result->user_id);
|
|
|
|
JPluginHelper::importPlugin('user');
|
|
$form = new JForm('com_users.profile');
|
|
// Get the dispatcher.
|
|
$dispatcher = JEventDispatcher::getInstance();
|
|
|
|
// Trigger the form preparation event.
|
|
$dispatcher->trigger('onContentPrepareForm', array($form, $data));
|
|
// Trigger the data preparation event.
|
|
$dispatcher->trigger('onContentPrepareData', array('com_users.profile', $data));
|
|
|
|
// Load the data into the form after the plugins have operated.
|
|
$form->bind($data);
|
|
$result->profile = $form;
|
|
|
|
$this->contact = $result;
|
|
return $result;
|
|
}
|
|
}
|
|
}
|
|
|
|
/**
|
|
* Increment the hit counter for the contact.
|
|
*
|
|
* @param int $pk Optional primary key of the article to increment.
|
|
*
|
|
* @return boolean True if successful; false otherwise and internal error set.
|
|
*
|
|
* @since 3.0
|
|
*/
|
|
public function hit($pk = 0)
|
|
{
|
|
$input = JFactory::getApplication()->input;
|
|
$hitcount = $input->getInt('hitcount', 1);
|
|
|
|
if ($hitcount)
|
|
{
|
|
$pk = (!empty($pk)) ? $pk : (int) $this->getState('contact.id');
|
|
$db = $this->getDbo();
|
|
|
|
$db->setQuery(
|
|
'UPDATE #__contact_details' .
|
|
' SET hits = hits + 1' .
|
|
' WHERE id = '.(int) $pk
|
|
);
|
|
|
|
try
|
|
{
|
|
$db->execute();
|
|
}
|
|
catch (RuntimeException $e)
|
|
{
|
|
$this->setError($e->getMessage());
|
|
return false;
|
|
}
|
|
}
|
|
|
|
return true;
|
|
}
|
|
}
|