/**
* 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;
}
