Symfony2: How to create custom query methods on related entities

Question

I have a User entity which has an ArrayCollection of Positions. Each Position has for sure a user_id property.

Now i want to get all positions from a user (to get all i would do $user->getPositions()) that are matching a specific query, for example have a date property that matches the current date. Therefor i want to do something like $user->getCurrentPositions() and it should return a subset of the positions related to that user.

How is that possible?

EDIT:

What i really wanna do is something like this in my controller:

$em = $this->getDoctrine()->getManager();
$users = $em->getRepository('fabianbartschWhereMyNomadsAtBundle:User')->findAll();

foreach ($users as $user) {
  $positions =  $user->getCurrentPositions();

  foreach ($positions as $position) {
    echo $position->getLatitude().'<br>';
  }
}

I wanna iterate over all users and from each user i want to have the relevant positions. But that isnt possible from the repository i guess, as i get the following message: Attempted to call method "getCurrentPositions" on class ...

You would create the method with the query in your repository class??? — keyboardSmasher
– keyboardSmasher, Commented Aug 17, 2014 at 18:46

Machavity · Accepted Answer · 2022-03-08 18:18:20Z

1

If you are using Doctrine you can use the built-in Criteria API which is meant for this purpose exactly.

Collections have a filtering API that allows you to slice parts of data from a collection. If the collection has not been loaded from the database yet, the filtering API can work on the SQL level to make optimized access to large collections.

edited Mar 8, 2022 at 18:18

Machavity♦

31.8k27 gold badges97 silver badges108 bronze badges

answered Aug 17, 2014 at 22:40

Brayden Williams

1582 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user1754242 · Accepted Answer · 2014-08-17 18:49:57Z

Ok i found out, its for sure possible with Repositories:

Entity\User.php

/**
 * @ORM\Entity(repositoryClass="fabianbartsch\WhereMyNomadsAtBundle\Entity\UserRepository")
 * @ORM\Table(name="fos_user")
 */
 class User extends BaseUser
 {

Entity\UserRepository.php

/**
 * UserRepository
 */
class UserRepository extends EntityRepository
{
    public function getCurrentPositions()
    {
        $query = $this->getEntityManager()
            ->createQuery(
                "SELECT p
                 FROM xxx:Position p
                 WHERE p.start <= '2014-08-17' AND p.end >= '2014-08-17'"
            );

        try {
            return $query->getResult();
        } catch (\Doctrine\ORM\NoResultException $e) {
            return null;
        }
    }
}

In the user object only related position entries are affected by the query, so is no need to join user entity with the position entity. Pretty simple, should just try out instead posting on stackoverflow, sry guys :P

Collectives™ on Stack Overflow

Symfony2: How to create custom query methods on related entities

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related