ORM.php 1.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748
  1. <?php
  2. namespace Gedmo\Sluggable\Mapping\Event\Adapter;
  3. use Doctrine\ORM\Query;
  4. use Gedmo\Mapping\Event\Adapter\ORM as BaseAdapterORM;
  5. use Gedmo\Sluggable\Mapping\Event\SluggableAdapter;
  6. use Gedmo\Tool\Wrapper\AbstractWrapper;
  7. /**
  8. * Doctrine event adapter for ORM adapted
  9. * for sluggable behavior
  10. *
  11. * @author Gediminas Morkevicius <gediminas.morkevicius@gmail.com>
  12. * @package Gedmo\Sluggable\Mapping\Event\Adapter
  13. * @subpackage ORM
  14. * @link http://www.gediminasm.org
  15. * @license MIT License (http://www.opensource.org/licenses/mit-license.php)
  16. */
  17. final class ORM extends BaseAdapterORM implements SluggableAdapter
  18. {
  19. /**
  20. * {@inheritDoc}
  21. */
  22. public function getSimilarSlugs($object, $meta, array $config, $slug)
  23. {
  24. $em = $this->getObjectManager();
  25. $wrapped = AbstractWrapper::wrap($object, $em);
  26. $qb = $em->createQueryBuilder();
  27. $qb->select('rec.' . $config['slug'])
  28. ->from($config['useObjectClass'], 'rec')
  29. ->where($qb->expr()->like(
  30. 'rec.' . $config['slug'],
  31. $qb->expr()->literal($slug . '%'))
  32. )
  33. ;
  34. // include identifiers
  35. foreach ((array)$wrapped->getIdentifier(false) as $id => $value) {
  36. if (!$meta->isIdentifier($config['slug'])) {
  37. $qb->andWhere($qb->expr()->neq('rec.' . $id, ':' . $id));
  38. $qb->setParameter($id, $value);
  39. }
  40. }
  41. $q = $qb->getQuery();
  42. $q->setHydrationMode(Query::HYDRATE_ARRAY);
  43. return $q->execute();
  44. }
  45. }