/** * Override function getCategories in model Category */ public static function getCategories($onlyPublished = true, $parentId = false, $childId = false, $keyword = "", $vendorId = false) { $categoryModel = VmModel::getModel('Category'); $select = ' c.`virtuemart_category_id`, l.`category_description`, l.`category_name`, c.`ordering`, c.`published`, cx.`category_child_id`, cx.`category_parent_id`, c.`shared` '; $joinedTables = ' FROM `#__virtuemart_categories_' . VmConfig::$vmlang . '` l JOIN `#__virtuemart_categories` AS c using (`virtuemart_category_id`) LEFT JOIN `#__virtuemart_category_categories` AS cx ON l.`virtuemart_category_id` = cx.`category_child_id` '; $where = array(); if ($onlyPublished) { $where[] = " c.`published` = 1 "; } if ($parentId !== false) { $where[] = ' cx.`category_parent_id` = ' . (int) $parentId; } if ($childId !== false) { $where[] = ' cx.`category_child_id` = ' . (int) $childId; } if ($vendorId === false) { $vendorId = VmConfig::isSuperVendor(); } if ($vendorId == 1) { $where[] = ' (c.`virtuemart_vendor_id` = "' . (int) $vendorId . '" OR c.`shared` = "1") '; } if (!empty($keyword)) { $db = JFactory::getDBO(); $keyword = '"%' . $db->escape($keyword, true) . '%"'; //$keyword = $db->Quote($keyword, false); $where[] = ' ( l.`category_name` LIKE ' . $keyword . ' OR l.`category_description` LIKE ' . $keyword . ') '; } $whereString = ''; if (count($where) > 0) { $whereString = ' WHERE ' . implode(' AND ', $where); } else { $whereString = 'WHERE 1 '; } $ordering = $categoryModel->_getOrdering(); self::$_category_tree = $categoryModel->exeSortSearchListQuery(0, $select, $joinedTables, $whereString, 'GROUP BY virtuemart_category_id', $ordering); return self::$_category_tree; }
* @author YouTech Company http://www.smartaddons.com * */ defined('_JEXEC') or die; if (!defined('DS')) { define('DS', DIRECTORY_SEPARATOR); } require_once dirname(__FILE__) . '/core/helper.php'; $layout = $params->get('layout', 'default'); $list = VmAjaxtabsHelper::getList($params, $module); if (!empty($list)) { $is_ajax_request = !empty($_SERVER['HTTP_X_REQUESTED_WITH']) && strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) == 'xmlhttprequest'; $is_ajax_request = $is_ajax_request || JRequest::getInt('sj_module_ajax_request', 0); if ($is_ajax_request) { $category_id = JRequest::getVar('sj_category_id', null); $sj_module_id = JRequest::getVar('sj_module_id', null); $sj_module = JRequest::getVar('sj_module', null); if ($sj_module == $module->module && $sj_module_id == $module->id) { $category_items = VmAjaxtabsHelper::_getProductInfor($category_id, $params); ob_start(); include JModuleHelper::getLayoutPath($module->module, $layout . '_items'); $ajax_respond = ob_get_contents(); ob_end_clean(); die($ajax_respond); } } else { require JModuleHelper::getLayoutPath($module->module, $layout); } } else { echo JText::_('Has no content to show!'); }