'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
);
$data =
$query->
execute()->
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;
}}