/**
* @inheritdoc
*/
public function createBaseProducts($numbers)
{
$query = $this->connection->createQueryBuilder();
$query->select(['variant.id as variantId', 'variant.ordernumber as number', 'variant.articleID as productId']);
$query->from('s_articles_details', 'variant')->where('variant.ordernumber IN(:numbers)')->setParameter(':numbers', $numbers, Connection::PARAM_STR_ARRAY);
/**@var $statement \PDOStatement*/
$statement = $query->execute();
$data = $statement->fetchAll(\PDO::FETCH_ASSOC);
$products = [];
foreach ($data as $row) {
$product = new BaseProduct((int) $row['productId'], (int) $row['variantId'], $row['number']);
$products[$product->getNumber()] = $product;
}
return $products;
}
/**
* @param QueryBuilder $query
* @return array
*/
private function getProducts(QueryBuilder $query)
{
/**@var $statement \Doctrine\DBAL\Driver\ResultStatement */
$statement = $query->execute();
$data = $statement->fetchAll(\PDO::FETCH_ASSOC);
$products = [];
foreach ($data as $row) {
$product = new BaseProduct((int) $row['__product_id'], (int) $row['__variant_id'], $row['__variant_ordernumber']);
$product->addAttribute('search', $this->attributeHydrator->hydrate($row));
$products[$product->getNumber()] = $product;
}
return $products;
}
/**
* @param Struct\BaseProduct $product
* @return NotFilter
*/
protected function getProductNumberFilter(Struct\BaseProduct $product)
{
return new NotFilter(new IdsFilter([$product->getNumber()]));
}
/**
* @param $data
* @return BaseProduct[]
*/
private function createProducts($data)
{
$products = [];
foreach ($data['hits']['hits'] as $data) {
$source = $data['_source'];
$product = new BaseProduct((int) $source['id'], (int) $source['variantId'], $source['number']);
$product->addAttribute('elastic_search', new Attribute(['score' => $data['_score']]));
$products[$product->getNumber()] = $product;
}
return $products;
}