/** * {@inheritDoc} */ protected function getTables() { return array(CategoryMapper::getTableName(), ImageMapper::getTableName(), OrderInfoMapper::getTableName(), OrderProductMapper::getTableName(), ProductMapper::getTableName(), ProductMapper::getJunctionTableName()); }
/** * {@inheritDoc} */ public function appendQuery(QueryBuilderInterface $queryBuilder, $placeholder) { $queryBuilder->select($this->getWithDefaults(array('description' => 'content')))->from(ProductMapper::getTableName())->whereEquals('lang_id', "'{$this->getLangId()}'")->andWhereEquals('published', '1')->andWhereLike('title', $placeholder)->orWhereLike('description', $placeholder); }
/** * Decrements product in stock qty * * @param string $id * @return boolean */ public function decrementProductInStockQtyById($id) { return $this->db->decrement(ProductMapper::getTableName(), 'in_stock', 1)->whereEquals('id', $id)->execute(); }