<?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();