protected static function setProductsAsIndexed(&$products) { if (count($products)) { $db = JFactory::getDBO(); $data = " SET product." . $db->quoteName('indexed') . " = 1"; $where = " WHERE product.product_id IN (" . implode(',', $products) . ")"; JeproshopProductModelProduct::updateMultishopTable($data, $where, '', TRUE); } }
public function setDefaultAttribute($product_attribute_id) { $db = JFactory::getDBO(); $app = JFactory::getApplication(); $query = "SELECT * FROM " . $db->quoteNane('#__jeproshop_product_attribute') . " WHERE product_attribute_id = "; $query .= (int) $product_attribute_id . " AND product_id = " . (int) $app->input->get('product_id'); $db->setQuery($query); $attribute_exists = count($db->loaObject()) > 0; if ($attribute_exists) { $where = " WHERE product_attribute." . $db->quoteName('product_id') . " = " . (int) $this->product_id . " AND product_attribute."; $where .= $db->quoteName('product_attribute_id') . " = " . (int) $product_attribute_id; $data = " SET product_attribute." . $db->quoteName('default_on') . " = 1"; $result = JeproshopCombinationModelCombination::updateMultishopTable($data, $where, '', TRUE); } $where = " WHERE product." . $db->quoteName('product_id') . " = " . (int) $this->product_id; $data = " SET product." . $db->quoteName('cache_default_attribute') . " = " . (int) $product_attribute_id; $result &= JeproshopProductModelProduct::updateMultishopTable($data, $where, '', TRUE); $this->cache_default_attribute = (int) $product_attribute_id; return $result; }