shopware / SwagConnect

     * @param array $orderNumbers

     * @return array

     */

    public function getArticleIdsByNumber(array $orderNumbers)

    {

        $builder = $this->manager->getConnection()->createQueryBuilder();

        $rows = $builder->select('d.articleID as articleId')

            ->from('s_articles_details', 'd')

            ->where('d.ordernumber IN (:orderNumbers)')

            ->setParameter('orderNumbers', $orderNumbers, \Doctrine\DBAL\Connection::PARAM_STR_ARRAY)

            ->execute()

            ->fetchAll();

        return array_map(function ($row) {

            return $row['articleId'];

        }, $rows);

    }

    /**

     * Returns article detail model by

     * @param array $supplierIds

     * @return array

     */

    protected function getConnectSuppliers($supplierIds)

    {

        /** @var \Doctrine\DBAL\Connection $conn */

        $builder = $this->connection->createQueryBuilder();

        $builder->select('supplierID')

            ->from('s_articles_supplier_attributes', 'sa')

            ->where('sa.supplierID IN (:supplierIds)')

            ->andWhere('sa.connect_is_remote = 1')

            ->setParameter('supplierIds', $supplierIds, \Doctrine\DBAL\Connection::PARAM_INT_ARRAY);

        return array_map(function ($item) {

            return $item['supplierID'];

        }, $builder->execute()->fetchAll(\PDO::FETCH_ASSOC));

    }

}