/**
* @param User $user
*
* @return array
*/
public function getBuddiesByUser(User $user)
{
$qb = $this->createQueryBuilder('b');
$qb->leftJoin('b.mentor', 'umentor')->leftJoin('b.mentee', 'umentee')->where('umentor.archive = 0')->andWhere('umentee.archive = 0');
if ($user->isLocal()) {
$qb->andwhere('b.mentor = :mentor')->setParameter('mentor', $user->getId());
} else {
$qb->andwhere('b.mentee = :mentee')->setParameter('mentee', $user->getId());
}
return $qb->getQuery()->getResult();
}
