public function plgVmAddToSearch(&$where, &$PluginJoinTables, $custom_id)
{
if ($keyword = vRequest::uword('custom_specification_name1', null, ' ')) {
$db = JFactory::getDBO();
if ($this->_name != $this->GetNameByCustomId($custom_id)) {
return;
}
$keyword = '"%' . $db->escape($keyword, true) . '%"';
$where[] = $this->_name . '.`custom_specification_default1` LIKE ' . $keyword;
$PluginJoinTables[] = $this->_name;
}
return true;
}
public function display($tpl = null)
{
$show_prices = VmConfig::get('show_prices', 1);
if ($show_prices == '1') {
if (!class_exists('calculationHelper')) {
require VMPATH_ADMIN . DS . 'helpers' . DS . 'calculationh.php';
}
}
$this->assignRef('show_prices', $show_prices);
if (!class_exists('shopFunctionsF')) {
require VMPATH_SITE . DS . 'helpers' . DS . 'shopfunctionsf.php';
}
// add javascript for price and cart, need even for quantity buttons, so we need it almost anywhere
vmJsApi::jPrice();
$document = JFactory::getDocument();
$app = JFactory::getApplication();
$pathway = $app->getPathway();
if (!class_exists('VmImage')) {
require VMPATH_ADMIN . DS . 'helpers' . DS . 'image.php';
}
// set search and keyword
if ($keyword = vRequest::uword('keyword', false, ' ,-,+,.,_')) {
$pathway->addItem($keyword);
//$title .=' ('.$keyword.')';
}
//$search = vRequest::uword('keyword', null);
$this->searchcustom = '';
$this->searchCustomValues = '';
//if (!empty($keyword)) {
$this->getSearchCustom();
$search = $keyword;
/*} else {
$keyword ='';
$search = NULL;
}*/
$this->assignRef('keyword', $keyword);
$this->assignRef('search', $search);
$menus = $app->getMenu();
$menu = $menus->getActive();
if (!empty($menu->id)) {
ShopFunctionsF::setLastVisitedItemId($menu->id);
} else {
if ($itemId = vRequest::getInt('Itemid', false)) {
ShopFunctionsF::setLastVisitedItemId($itemId);
}
}
$virtuemart_manufacturer_id = vRequest::getInt('virtuemart_manufacturer_id', -1);
if ($virtuemart_manufacturer_id === -1 and !empty($menu->query['virtuemart_manufacturer_id'])) {
$virtuemart_manufacturer_id = $menu->query['virtuemart_manufacturer_id'];
vRequest::setVar('virtuemart_manufacturer_id', $virtuemart_manufacturer_id);
}
$this->categoryId = vRequest::getInt('virtuemart_category_id', -1);
if ($this->categoryId === -1 and !empty($menu->query['virtuemart_category_id'])) {
$this->categoryId = $menu->query['virtuemart_category_id'];
vRequest::setVar('virtuemart_category_id', $this->categoryId);
} else {
if ($this->categoryId === -1 and $virtuemart_manufacturer_id === -1) {
$this->categoryId = ShopFunctionsF::getLastVisitedCategoryId();
}
}
$this->setCanonicalLink($tpl, $document, $this->categoryId, $virtuemart_manufacturer_id);
if (($this->categoryId === -1 or $this->categoryId === 0) and $virtuemart_manufacturer_id) {
$this->categoryId = 0;
$catType = 'manufacturer';
$this->setCanonicalLink($tpl, $document, $virtuemart_manufacturer_id, $catType);
}
$categoryModel = VmModel::getModel('category');
$productModel = VmModel::getModel('product');
if ($this->categoryId === -1) {
$this->categoryId = 0;
}
$vendorId = 1;
$category = $categoryModel->getCategory($this->categoryId);
if (!isset($menu->query['showproducts'])) {
$menu->query['showproducts'] = 1;
}
$this->showproducts = vRequest::getInt('showproducts', $menu->query['showproducts']);
if (!empty($category)) {
$vendorId = $category->virtuemart_vendor_id;
if ($this->showproducts) {
//if(empty($category->category_layout) or $category->category_layout != 'categories') {
// Load the products in the given category
$ids = $productModel->sortSearchListQuery(TRUE, $this->categoryId);
$this->perRow = empty($category->products_per_row) ? VmConfig::get('products_per_row', 3) : $category->products_per_row;
$this->vmPagination = $productModel->getPagination($this->perRow);
$ratingModel = VmModel::getModel('ratings');
$this->showRating = $ratingModel->showRating();
$productModel->withRating = $this->showRating;
$this->orderByList = $productModel->getOrderByList($this->categoryId);
$this->products = $productModel->getProducts($ids);
//$products = $productModel->getProductsInCategory($this->categoryId);
$productModel->addImages($this->products, 1);
if ($this->products) {
$currency = CurrencyDisplay::getInstance();
$this->assignRef('currency', $currency);
$display_stock = VmConfig::get('display_stock', 1);
$showCustoms = VmConfig::get('show_pcustoms', 1);
if ($display_stock or $showCustoms) {
if (!$showCustoms) {
foreach ($this->products as $i => $productItem) {
$productItem->stock = $productModel->getStockIndicator($productItem);
}
} else {
$customfieldsModel = VmModel::getModel('Customfields');
if (!class_exists('vmCustomPlugin')) {
require JPATH_VM_PLUGINS . DS . 'vmcustomplugin.php';
}
foreach ($this->products as $i => $productItem) {
if (!empty($productItem->customfields)) {
$product = clone $productItem;
$customfields = array();
foreach ($productItem->customfields as $cu) {
$customfields[] = clone $cu;
}
$customfieldsSorted = array();
$customfieldsModel->displayProductCustomfieldFE($product, $customfields);
$product->stock = $productModel->getStockIndicator($product);
foreach ($customfields as $k => $custom) {
if (!empty($custom->layout_pos)) {
$customfieldsSorted[$custom->layout_pos][] = $custom;
unset($customfields[$k]);
}
}
$customfieldsSorted['normal'] = $customfields;
$product->customfieldsSorted = $customfieldsSorted;
unset($product->customfields);
$this->products[$i] = $product;
} else {
$productItem->stock = $productModel->getStockIndicator($productItem);
$this->products[$i] = $productItem;
}
}
}
}
}
// Add feed links
if ($this->showproducts and $this->products && VmConfig::get('feed_cat_published', 0) == 1) {
$link = '&format=feed&limitstart=';
$attribs = array('type' => 'application/rss+xml', 'title' => 'RSS 2.0');
$document->addHeadLink(JRoute::_($link . '&type=rss', FALSE), 'alternate', 'rel', $attribs);
$attribs = array('type' => 'application/atom+xml', 'title' => 'Atom 1.0');
$document->addHeadLink(JRoute::_($link . '&type=atom', FALSE), 'alternate', 'rel', $attribs);
}
$user = JFactory::getUser();
$this->showBasePrice = ($user->authorise('core.admin', 'com_virtuemart') or $user->authorise('core.manage', 'com_virtuemart') or VmConfig::isSuperVendor());
}
//No redirect here, for category id = 0 means show ALL categories! note by Max Milbers
if (!empty($this->categoryId) and $this->categoryId !== -1 and (empty($category->slug) or !$category->published)) {
if (empty($category->slug)) {
vmInfo(vmText::_('COM_VIRTUEMART_CAT_NOT_FOUND'));
} else {
if ($category->virtuemart_id !== 0 and !$category->published) {
vmInfo('COM_VIRTUEMART_CAT_NOT_PUBL', $category->category_name, $this->categoryId);
}
}
//Fallback
$categoryLink = '';
if ($category->category_parent_id) {
$categoryLink = '&view=category&virtuemart_category_id=' . $category->category_parent_id;
} else {
$last_category_id = shopFunctionsF::getLastVisitedCategoryId();
if (!$last_category_id or $this->categoryId == $last_category_id) {
$last_category_id = vRequest::getInt('virtuemart_category_id', false);
}
if ($last_category_id and $this->categoryId != $last_category_id) {
$categoryLink = '&view=category&virtuemart_category_id=' . $last_category_id;
}
}
if (VmConfig::get('handle_404', 1)) {
$app->redirect(JRoute::_('index.php?option=com_virtuemart' . $categoryLink . '&error=404', FALSE));
} else {
JError::raise(E_ERROR, '404', 'Not found');
}
return;
}
shopFunctionsF::setLastVisitedCategoryId($this->categoryId);
shopFunctionsF::setLastVisitedManuId($virtuemart_manufacturer_id);
// Add the category name to the pathway
if ($category->parents) {
foreach ($category->parents as $c) {
$pathway->addItem(strip_tags($c->category_name), JRoute::_('index.php?option=com_virtuemart&view=category&virtuemart_category_id=' . $c->virtuemart_category_id, FALSE));
}
}
$categoryModel->addImages($category, 1);
if (!isset($menu->query['showcategory'])) {
$menu->query['showcategory'] = 1;
}
$this->showcategory = vRequest::getInt('showcategory', $menu->query['showcategory']);
//$this->showcategory = vRequest::getInt('showcategory',true);
if ($this->showcategory) {
//if($category->category_layout == 'categories' or ($this->categoryId >0 and $virtuemart_manufacturer_id <1)){
$category->children = $categoryModel->getChildCategoryList($vendorId, $this->categoryId, $categoryModel->getDefaultOrdering(), $categoryModel->_selectedOrderingDir);
$categoryModel->addImages($category->children, 1);
} else {
$category->children = false;
}
if (VmConfig::get('enable_content_plugin', 1)) {
shopFunctionsF::triggerContentPlugin($category, 'category', 'category_description');
}
if ($category->metadesc) {
$document->setDescription($category->metadesc);
}
if ($category->metakey) {
$document->setMetaData('keywords', $category->metakey);
}
if ($category->metarobot) {
$document->setMetaData('robots', $category->metarobot);
}
if ($app->getCfg('MetaAuthor') == '1') {
$document->setMetaData('author', $category->metaauthor);
}
if (empty($category->category_template)) {
$category->category_template = VmConfig::get('categorytemplate');
}
if (!empty($menu->query['categorylayout'])) {
//if(!empty($menu->query['categorylayout']) and $menu->query['virtuemart_category_id']==$this->categoryId){
$category->category_layout = $menu->query['categorylayout'];
}
$productsLayout = VmConfig::get('productsublayout', 'products');
if (empty($productsLayout)) {
$productsLayout = 'products';
}
$this->productsLayout = empty($menu->query['productsublayout']) ? $productsLayout : $menu->query['productsublayout'];
shopFunctionsF::setVmTemplate($this, $category->category_template, 0, $category->category_layout);
} else {
//Backward compatibility
if (!isset($category)) {
$category = new stdClass();
$category->category_name = '';
$category->category_description = '';
$category->haschildren = false;
}
}
$this->assignRef('category', $category);
// Set the titles
if (!empty($category->customtitle)) {
$title = strip_tags($category->customtitle);
} elseif (!empty($category->category_name)) {
$title = strip_tags($category->category_name);
} else {
$title = $this->setTitleByJMenu($app);
}
if (vRequest::getInt('error')) {
$title .= ' ' . vmText::_('COM_VIRTUEMART_PRODUCT_NOT_FOUND');
}
if (!empty($keyword)) {
$title .= ' (' . $keyword . ')';
}
if ($virtuemart_manufacturer_id > 0 and !empty($this->products[0])) {
$title .= ' ' . $this->products[0]->mf_name;
}
$document->setTitle($title);
// Override Category name when viewing manufacturers products !IMPORTANT AFTER page title.
if ($virtuemart_manufacturer_id > 0 and !empty($this->products[0]) and isset($category->category_name)) {
$category->category_name = $this->products[0]->mf_name;
}
if ($app->getCfg('MetaTitle') == '1') {
$document->setMetaData('title', $title);
}
parent::display($tpl);
}
/**
* This functions updates the variables of the model which are used in the sortSearchListQuery
* with the variables from the Request
*
* @author Max Milbers
*/
function updateRequests()
{
$this->keyword = vRequest::uword('keyword', "", ' ,-,+,.,_,#,/');
if ($this->keyword == "") {
$this->keyword = vRequest::uword('filter_product', "", ' ,-,+,.,_,#,/');
JRequest::setVar('filter_product', $this->keyword);
JRequest::setVar('keyword', $this->keyword);
} else {
JRequest::setVar('keyword', $this->keyword);
}
$app = JFactory::getApplication();
$option = 'com_virtuemart';
$view = 'product';
if ($app->isSite()) {
$filter_order = JRequest::getString('orderby', "0");
if ($filter_order == "0") {
$filter_order_raw = $this->getLastProductOrdering($this->_selectedOrdering);
$filter_order = $this->checkFilterOrder($filter_order_raw);
} else {
vmdebug('my $filter_order ', $filter_order);
$filter_order = $this->checkFilterOrder($filter_order);
vmdebug('my $filter_order after check', $filter_order);
$this->setLastProductOrdering($filter_order);
}
$filter_order_Dir = strtoupper(JRequest::getWord('dir', VmConfig::get('prd_brws_orderby_dir', 'ASC')));
$valid_search_fields = VmConfig::get('browse_search_fields');
//vmdebug('$valid_search_fields ',$valid_search_fields);
//unset($valid_search_fields[]
} else {
$filter_order = strtolower($app->getUserStateFromRequest('com_virtuemart.' . $view . '.filter_order', 'filter_order', $this->_selectedOrdering, 'cmd'));
$filter_order = $this->checkFilterOrder($filter_order);
$filter_order_Dir = strtoupper($app->getUserStateFromRequest($option . '.' . $view . '.filter_order_Dir', 'filter_order_Dir', '', 'word'));
$valid_search_fields = $this->valid_BE_search_fields;
}
$filter_order_Dir = $this->checkFilterDir($filter_order_Dir);
$this->filter_order = $filter_order;
$this->filter_order_Dir = $filter_order_Dir;
$this->valid_search_fields = $valid_search_fields;
$this->product_parent_id = JRequest::getInt('product_parent_id', FALSE);
$this->virtuemart_manufacturer_id = JRequest::getInt('virtuemart_manufacturer_id', FALSE);
$this->search_type = JRequest::getVar('search_type', '');
$this->searchcustoms = JRequest::getVar('customfields', array(), 'default', 'array');
$this->searchplugin = JRequest::getInt('custom_parent_id', 0);
}
<th><?php
echo $this->sort('product_weight', 'COM_VIRTUEMART_PRODUCT_INVENTORY_WEIGHT');
?>
</th>
<th><?php
echo $this->sort('published');
?>
</th>
</tr>
</thead>
<tbody>
<?php
if (count($this->inventorylist) > 0) {
$i = 0;
$k = 0;
$keyword = vRequest::uword('keyword', "", ' ,-,+,.,_,#,/');
foreach ($this->inventorylist as $key => $product) {
$checked = JHTML::_('grid.id', $i, $product->virtuemart_product_id);
$published = JHTML::_('grid.published', $product, $i);
//<!-- low_stock_notification -->
if ($product->product_in_stock - $product->product_ordered < 1) {
$stockstatut = "out";
} elseif ($product->product_in_stock - $product->product_ordered < $product->low_stock_notification) {
$stockstatut = "low";
} else {
$stockstatut = "normal";
}
$stockstatut = 'class="stock-' . $stockstatut . '" title="' . jText::_('COM_VIRTUEMART_STOCK_LEVEL_' . $stockstatut) . '"';
?>
<tr class="row<?php
echo $k;
