rp

rep.php

<?php

/**
     * Search products with options
     *
     * @param array $options
     *
     * @return array
     */
    public function searchProducts(array $options = [])
    {
        $qb = $this->createQueryBuilder('s')
            ->select('s');

        $qb->leftJoin('ProductBundle:ProductVariation', 'productVariation', 'WITH', 'productVariation.product = s.id');
        $qb->andWhere('productVariation.isAvailable = 1')
            ->andWhere('productVariation.amount > 0');

        $qb->setMaxResults(10);

        dump($qb->getQuery());
        dump($qb->getQuery()->getResult());
        die;

        return $qb->getQuery()->getResult();
    }