shopware / SwagConnect

     * @param int $mode

     * @return null|ProductDetail

     */

    public function getArticleDetailModelByProduct(Product $product, $mode = Query::HYDRATE_OBJECT)

    {

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

        $builder->select(['ba', 'd']);

        $builder->from('Shopware\CustomModels\Connect\Attribute', 'ba');

        $builder->join('ba.articleDetail', 'd');

        $builder->leftJoin('d.attribute', 'at');

        $builder->where('ba.shopId = :shopId AND ba.sourceId = :sourceId');

        $query = $builder->getQuery();

        $query->setParameter('shopId', $product->shopId);

        $query->setParameter('sourceId', (string) $product->sourceId);

        $result = $query->getResult(

            $mode

        );

        if (isset($result[0])) {

            /** @var \Shopware\CustomModels\Connect\Attribute $attribute */

            $attribute = $result[0];

            return $attribute->getArticleDetail();

        }

        return null;

    }

    /**

     * Get article detail by his number

     * @param int $mode

     * @return null|ProductModel

     */

    public function getArticleByRemoteProduct(Product $product, $mode = Query::HYDRATE_OBJECT)

    {

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

        $builder->select(['ba', 'd']);

        $builder->from('Shopware\CustomModels\Connect\Attribute', 'ba');

        $builder->join('ba.articleDetail', 'd');

        $builder->leftJoin('d.attribute', 'at');

        $builder->where('ba.groupId = :groupId AND ba.isMainVariant = 1 AND ba.shopId = :shopId');

        $query = $builder->getQuery();

        $query->setParameter('groupId', $product->groupId);

        $query->setParameter('shopId', $product->shopId);

        $result = $query->getResult(

            $mode

        );

        if (isset($result[0])) {

            /** @var \Shopware\CustomModels\Connect\Attribute $attribute */

            $attribute = $result[0];

            return $attribute->getArticle();

        }

        return null;

    }

    /**