getListQueryBuilder example

    public function getListQuery($blogCategoryIds, $offset = null, $limit = null, ?array $filter = null, $shopId = null)
    {
        $builder = $this->getListQueryBuilder($blogCategoryIds, $filter, $shopId);
        if (!empty($offset)) {
            $builder->setFirstResult($offset);
        }
        if (!empty($limit)) {
            $builder->setMaxResults($limit);
        }

        return $builder->getQuery();
    }

    /** * Helper function to create the query builder for the "getListQuery" function. * This function can be hooked to modify the query builder of the query object. * * @param int[] $blogCategoryIds * @param array $filter * @param int|null $shopId * * @return QueryBuilder */

/** * Returns an instance of the \Doctrine\ORM\Query object which select the partners for the backend list * * @param array<array{property: string, direction: string}>|null $order * @param int|null $offset * @param int|null $limit * * @return Query<Partner> */
    public function getListQuery($order = null, $offset = null, $limit = null)
    {
        $builder = $this->getListQueryBuilder($order);
        if (!empty($offset)) {
            $builder->setFirstResult($offset);
        }
        if (!empty($limit)) {
            $builder->setMaxResults($limit);
        }

        return $builder->getQuery();
    }

    /** * Helper function to create the query builder for the "getListQuery" function. * This function can be hooked to modify the query builder of the query object. * * @param array<array{property: string, direction: string}>|null $order * * @return QueryBuilder */

    public function getListQuery($filter = null, $order = null, $offset = null, $limit = null)
    {
        $builder = $this->getListQueryBuilder($filter, $order, $offset, $limit);

        return $builder->getQuery();
    }

    /** * Helper function to create the query builder for the "getListQuery" function. * This function can be hooked to modify the query builder of the query object. * * @param array|null $filter * @param array|null $order * @param int|null $offset * @param int|null $limit * * @return QueryBuilder */

    public function getListQuery($orderBy = null, $offset = null, $limit = null)
    {
        $builder = $this->getListQueryBuilder($orderBy);
        if ($limit !== null) {
            $builder->setFirstResult($offset)->setMaxResults($limit);
        }

        return $builder->getQuery();
    }

    /** * Helper function to create the query builder for the "getListQuery" function. * This function can be hooked to modify the query builder of the query object. * * @param array<array{property: string, direction: string}>|null $orderBy * * @return QueryBuilder */

return $builder;
    }

    /** * Returns the \Doctrine\ORM\Query to select all categories for example for the backend tree * * @return Query<Shop> */
    public function getListQuery(array $filterBy, array $orderBy, $limit = null, $offset = null)
    {
        $builder = $this->getListQueryBuilder($filterBy, $orderBy, $limit, $offset);

        return $builder->getQuery();
    }

    /** * Helper method to create the query builder for the "getListQuery" function. * This function can be hooked to modify the query builder of the query object. * * @return QueryBuilder */
    public function getListQueryBuilder(array $filterBy, array $orderBy, $limit = null, $offset = null)
    {

    public function getListQuery($filter = null, $order = [], $limit = null, $offset = null)
    {
        /** @var QueryBuilder $builder */
        $builder = $this->getListQueryBuilder($filter, $order);
        if (!empty($offset)) {
            $builder->setFirstResult($offset);
        }
        if (!empty($limit)) {
            $builder->setMaxResults($limit);
        }

        return $builder->getQuery();
    }

    /** * Helper function to create the query builder for the "getShippingCostsQuery" function. * This function can be hooked to modify the query builder of the query object. * * @param int $dispatchId - If this parameter is given, only one data set will be returned * @param string|null $filter - Used to search in the name and description of the dispatch data set * @param array $order - Name of the field which should considered as sorting field * * @return QueryBuilder */

->andWhere('voucher.modus= 1')
           ->getQuery();
    }

    /** * @param int[] $ids * * @return array<array<string, mixed>> */
    public function getList($ids)
    {
        $query = $this->getListQueryBuilder();
        $query->where('orders.id IN (:ids)');
        $query->setParameter(':ids', $ids, Connection::PARAM_INT_ARRAY);

        return $query->getQuery()->getArrayResult();
    }

    /** * @return QueryBuilder */
    public function getListQueryBuilder()
    {
        

class Repository extends ModelRepository
{
    /** * Returns an instance of the \Doctrine\ORM\Query object which selects all filters for the listing * * @param string|null $filter * * @return Query<Filter> */
    public function getListQuery($filter = null)
    {
        $builder = $this->getListQueryBuilder($filter);

        return $builder->getQuery();
    }

    /** * Helper function to create the query builder for the "getListQuery" function. * This function can be hooked to modify the query builder of the query object. * * @param string|null $filter * * @return QueryBuilder */

return $builder;
    }

    /** * Returns the \Doctrine\ORM\Query to select all manufacturers for example for the backend tree * * @return Query<Supplier> */
    public function getListQuery(array $filterBy, array $orderBy, $limit = null, $offset = null)
    {
        return $this->getListQueryBuilder($filterBy, $orderBy, $limit, $offset)->getQuery();
    }

    /** * Helper method to create the query builder for the "getListQuery" function. * This function can be hooked to modify the query builder of the query object. * * @param array<string, string>|array<array{property: string, value: mixed, expression?: string}> $filterBy * @param array<array{property: string, direction: string}> $orderBy * * @return QueryBuilder */
    

/** * Create emotion rewrite rules * * @param int|null $offset * @param int|null $limit * * @throws Exception */
    public function sCreateRewriteTableCampaigns($offset = null, $limit = null)
    {
        $repo = $this->modelManager->getRepository(Emotion::class);
        $queryBuilder = $repo->getListQueryBuilder();

        $languageId = Shopware()->Shop()->getId();
        $fallbackId = null;

        $fallbackShop = Shopware()->Shop()->getFallback();

        if (!empty($fallbackShop)) {
            $fallbackId = $fallbackShop->getId();
        }

        $queryBuilder->join('emotions.shops', 'shop', 'WITH', 'shop.id = :shopId')
            

->getResult(AbstractQuery::HYDRATE_ARRAY);
    }

    /** * @param int $limit * @param int $offset * * @return Query<Address> */
    public function getListQuery(array $criteria = [], array $orderBy = [], $limit = 25, $offset = 0)
    {
        return $this->getListQueryBuilder($criteria, $orderBy, $limit, $offset)->getQuery();
    }

    /** * @param int $addressId * * @return Query<Address> */
    public function getOne($addressId)
    {
        return $this->getDetailQueryBuilder($addressId)->getQuery();
    }

    

/** * Returns the \Doctrine\ORM\Query to select all categories for example for the backend tree * * @param int|null $limit * @param int|null $offset * @param bool $selectOnlyActive * * @return Query<Category> */
    public function getListQuery(array $filterBy, array $orderBy = [], $limit = null, $offset = null, $selectOnlyActive = true)
    {
        $builder = $this->getListQueryBuilder($filterBy, $orderBy, $limit, $offset, $selectOnlyActive);

        return $builder->getQuery();
    }

    /** * Returns a query builder object to get all defined categories with a count of sub categories. * * @param array<string, string>|array<array{property: string, value: mixed, expression?: string}> $filterBy * @param array<array{property: string, direction: string}> $orderBy * @param int|null $limit * @param int|null $offset * * @return QueryBuilder */

// Get blog categories         $query = Shopware()->Models()->getRepository(Category::class)->getBlogCategoriesByParentQuery(Shopware()->Shop()->get('parentID'));
        $blogCategories = $query->getArrayResult();

        // Get list of blogCategory ids         $blogCategoryIds = [];
        foreach ($blogCategories as $blogCategory) {
            $blogCategoryIds[] = $blogCategory['id'];
        }

        // Count total number of associated blog articles         $builder = Shopware()->Models()->getRepository(Blog::class)->getListQueryBuilder(
            $blogCategoryIds,
            []
        );
        $numResults = $builder->select('COUNT(blog)')
            ->getQuery()
            ->getSingleScalarResult();

        return (int) $numResults;
    }

    /** * Count the number of articles which need an update * * @param int $shopId * * @return string */

    public function getListQuery($filter, $orderBy, $offset, $limit)
    {
        $builder = $this->getListQueryBuilder($filter, $orderBy);
        $builder->setFirstResult($offset)
            ->setMaxResults($limit);

        return $builder->getQuery();
    }

    /** * Helper function to create the query builder for the "getListQuery" function. * This function can be hooked to modify the query builder of the query object. * * @param array|null $filter * @param array|null $orderBy * * @return QueryBuilder */