/** * Get a number of products from the DB from the specified productIds * @param array $productIds Array of productIds * @return \stdClass[] */ public function getProductsByProductIds($productIds) { $query = 'SELECT * FROM aca_product WHERE product_id IN(' . implode(',', $productIds) . ')'; $this->db->setQuery($query); $dbProducts = $this->db->loadObjectList(); return $dbProducts; }
/** * Get a number of products from the DB from the specified productIds * @param array $product_ids * @return \Aca\Bundle\ShopBundle\Db\stdClass[] ]stdClass[] */ public function getCartProducts($product_ids) { $list = implode(',', $product_ids); $query = "SELECT * FROM aca_product WHERE product_id IN ({$list})"; $this->db->setQuery($query); $shoppingcart = $this->db->loadObjectList(); return $shoppingcart; }
/** * Get a number of products from the DB from the specified productIds * @param array $productIds Array of productIds * @return \stdClass[] */ public function getProductsByProductIds($productIds) { $query = 'select * from aca_product where product_id in(' . implode(',', $productIds) . ')'; $this->db->setQuery($query); $dbProducts = $this->db->loadObjectList(); return $dbProducts; }