public function queryLastActivities($type, $bundleId, $developerId, $sortBy = 'createdAt')
{
$query = $this->createQueryBuilder('a')->orderBy('a.' . $sortBy, 'desc')->leftJoin('a.bundle', 'b')->leftJoin('a.developer', 'd')->select('a, b, d');
if (null !== $type) {
$query->where('a.type = :type')->setParameter('type', $type);
}
if (null !== $bundleId) {
$query->andWhere('b.id = :bundle_id')->setParameter('bundle_id', $bundleId);
}
if (null !== $developerId) {
$query->andWhere('d.id = :developer_id')->setParameter('developer_id', $developerId);
}
return $query->getQuery();
}