for testing and deploying your application
for finding and fixing issues
for empowering human code reviews
<?php
/**
* This file was created by the developers from BitBag.
* Feel free to contact us once you face any issues or want to start
* another great project.
* You can find more information about us on https://bitbag.shop and write us
* an email on [email protected].
*/
declare(strict_types=1);
namespace BitBag\SyliusCmsPlugin\Repository;
use Doctrine\ORM\QueryBuilder;
use Sylius\Bundle\ResourceBundle\Doctrine\ORM\EntityRepository;
* @author Patryk Drapik <[email protected]>
class SectionRepository extends EntityRepository implements SectionRepositoryInterface
{
* {@inheritdoc}
public function createListQueryBuilder(): QueryBuilder
return $this->createQueryBuilder('o')
->leftJoin('o.translations', 'translation')
;
}
public function findByNamePart(string $phrase, ?string $locale = null): array
->innerJoin('o.translations', 'translation', 'WITH', 'translation.locale = :locale')
->andWhere('translation.name LIKE :name')
->setParameter('name', '%'.$phrase.'%')
->setParameter('locale', $locale)
->getQuery()
->getResult()
BitBagCommerce /
SyliusCmsPlugin
