anime-db / catalog-bundle

     *

     * @return Builder

     */

    public function addGenres(Search $entity)

    {

        if ($entity->getGenres()->count()) {

            $this->add(function (QueryBuilder $query) use ($entity) {

                $ids = [];

                foreach ($entity->getGenres() as $genre) {

                    $ids[] = (int) $genre->getId();

                }

                $query

                    ->innerJoin('i.genres', 'g')

                    ->andWhere('g.id IN ('.implode(',', $ids).')');

            });

            $this->select->andHaving('COUNT(i.id) = '.$entity->getGenres()->count());

        }

        return $this;

    }

    /**

     *

     * @return Builder

     */

    public function addLabels(Search $entity)

    {

        if ($entity->getLabels()->count()) {

            $this->add(function (QueryBuilder $query) use ($entity) {

                $ids = [];

                foreach ($entity->getLabels() as $label) {

                    $ids[] = (int) $label->getId();

                }

                $query

                    ->innerJoin('i.labels', 'l')

                    ->andWhere('l.id IN ('.implode(',', $ids).')');

            });

            $this->select->andHaving('COUNT(i.id) = '.$entity->getLabels()->count());

        }

        return $this;

    }

    /**