<?php
/**
* @version 1.1.1
* @package Joomla
* @subpackage Helpdesk Pro
* @author Tuan Pham Ngoc
* @copyright Copyright (C) 2012 Ossolution Team
* @license GNU/GPL, see LICENSE.php
*/
// Check to ensure this file is included in Joomla!
defined('_JEXEC') or die;
OSFactory::loadLibrary('modellist');
class HelpdeskproModelTickets extends OSModelList
{
function __construct($config)
{
$config['title_field'] = array('a.name', 'a.email', 'c.username', 'a.subject', 'a.message');
$config['default_ordering'] = ' a.created_date';
$config['state_vars'] = array('category_id' => array(0, 'int', true), 'manager_id' => array(0, 'int', true), 'status_id' => array(0, 'int', true), 'priority_id' => array(0, 'int', true), 'filter_order' => array('a.modified_date', 'string', true), 'filter_order_Dir' => array('DESC', 'cmd', true), 'published' => array(-1, 'int', true));
parent::__construct($config);
}
function _buildQuery()
{
$where = $this->_buildContentWhere();
$orderby = $this->_buildContentOrderBy();
$query = 'SELECT a.*, b.title AS category_title, c.username AS username FROM #__helpdeskpro_tickets AS a ' . ' LEFT JOIN #__helpdeskpro_categories AS b ' . ' ON a.category_id= b.id ' . ' LEFT JOIN #__users AS c ' . ' ON a.user_id = c.id ' . $where . $orderby;
return $query;
}
function _buildContentWhereArray()
{
require_once JPATH_ROOT . '/administrator/components/com_helpdeskpro/libraries/defines.php';
require_once JPATH_ROOT . '/administrator/components/com_helpdeskpro/libraries/inflector.php';
require_once JPATH_ROOT . '/administrator/components/com_helpdeskpro/libraries/factory.php';
$command = JRequest::getVar('task', 'display');
// Check for a controller.task command.
if (strpos($command, '.') !== false) {
list($controller, $task) = explode('.', $command);
$path = JPATH_ADMINISTRATOR . '/components/com_helpdeskpro/controllers/' . $controller . '.php';
if (file_exists($path)) {
require_once $path;
$className = 'HelpdeskproController' . ucfirst($controller);
$config = array('model_path' => JPATH_ADMINISTRATOR . '/components/com_helpdeskpro/models');
$controller = new $className($config);
} else {
//Fallback to default controller
OSFactory::loadLibrary('controller');
$controller = new OSController(array('entity_name' => $controller, 'name' => 'Helpdeskpro', 'model_path' => JPATH_ADMINISTRATOR . '/components/com_helpdeskpro/models'));
}
JRequest::setVar('task', $task);
} else {
$path = JPATH_COMPONENT . '/controller.php';
require_once $path;
$className = 'HelpdeskproController';
$config['model_path'] = JPATH_ADMINISTRATOR . '/components/com_helpdeskpro/models';
$controller = new $className($config);
}
$document =& JFactory::getDocument();
$document->addStyleSheet(JURI::base(true) . '/components/com_helpdeskpro/assets/css/style.css');
if (version_compare(JVERSION, '3.0', 'lt')) {
HelpdeskProHelper::loadBootstrap();
}
<?php
/**
* @version 1.1.1
* @package Joomla
* @subpackage Helpdesk Pro
* @author Tuan Pham Ngoc
* @copyright Copyright (C) 2012 Ossolution Team
* @license GNU/GPL, see LICENSE.php
*/
// Check to ensure this file is included in Joomla!
defined('_JEXEC') or die;
OSFactory::loadLibrary('model');
/**
* Helpdesk Pro Component Field Model
*
* @package Joomla
* @subpackage Helpdesk Pro
* @since 1.5
*/
class HelpdeskproModelField extends OSModel
{
function store(&$data)
{
$db =& JFactory::getDBO();
$row =& $this->getTable('Helpdeskpro', 'Field');
if (!$row->bind($data)) {
$this->setError($this->_db->getErrorMsg());
return false;
}
if (!$row->id) {
<?php
/**
* @version 1.1.1
* @package Joomla
* @subpackage Helpdesk Pro
* @author Tuan Pham Ngoc
* @copyright Copyright (C) 2012 Ossolution Team
* @license GNU/GPL, see LICENSE.php
*/
// no direct access
defined('_JEXEC') or die;
OSFactory::loadLibrary('viewlist');
/**
* HTML View class for OS Membership component
*
* @static
* @package Joomla
* @subpackage Helpdesk Pro
* @since 1.5
*/
class HelpdeskproViewPriorities extends OSViewList
{
}
<?php
/**
* @version 1.1.1
* @package Joomla
* @subpackage Helpdesk Pro
* @author Tuan Pham Ngoc
* @copyright Copyright (C) 2012 Ossolution Team
* @license GNU/GPL, see LICENSE.php
*/
// no direct access
defined('_JEXEC') or die;
OSFactory::loadLibrary('viewform');
/**
* HTML View class for OS Membership component
*
* @static
* @package Joomla
* @subpackage Helpdesk Pro
* @since 1.5
*/
class HelpdeskproViewTicket extends OSViewForm
{
function _buildListArray(&$lists, $item)
{
$layout = $this->getLayout();
if ($layout == 'form') {
$this->_buildListArrayForm($lists, $item);
return;
}
$db = JFactory::getDbo();
