/** * @inheritdoc */ public function getAreas(array $ids, Struct\ShopContextInterface $context) { $query = $this->connection->createQueryBuilder(); $query->select($this->fieldHelper->getAreaFields()); $query->from('s_core_countries_areas', 'countryArea'); $query->where('countryArea.id IN (:ids)')->setParameter(':ids', $ids, Connection::PARAM_INT_ARRAY); /**@var $statement \Doctrine\DBAL\Driver\ResultStatement */ $statement = $query->execute(); $data = $statement->fetchAll(\PDO::FETCH_ASSOC); $areas = []; foreach ($data as $row) { $areas[] = $this->countryHydrator->hydrateArea($row); } return $areas; }