/** * @param Group $group * @return \Doctrine\ORM\Query */ public function getUnassignedUsersQueryByGroup(GroupSection $section) { $ids = array(0); foreach ($section->getUsers() as $user) { $ids[] = $user->getId(); } $qb = $this->getEntityManager()->createQueryBuilder(); return $qb->select('u')->from('CivixCoreBundle:User', 'u')->leftJoin('u.groups', 'ug')->where($qb->expr()->notIn('u.id', $ids))->andWhere('ug.group = :group')->setParameter('group', $section->getGroup())->orderBy('u.firstName')->getQuery(); }
public function getGroup() { $this->__load(); return parent::getGroup(); }
/** * @Route("/delete/{id}", name="civix_front_group_sections_delete", requirements={"id"="\d+"}) */ public function deleteAction(Request $request, GroupSection $section) { if (!$this->checkSubscriptionPackage()) { $this->get('session')->getFlashBag()->add('danger', 'Group sections are not available for this subscription'); return $this->redirect($this->generateUrl('civix_front_group_subscription_index')); } if ($section->getGroup() !== $this->getUser() || $request->get('token') !== $this->getToken()) { throw new AccessDeniedHttpException(); } $manager = $this->getDoctrine()->getManager(); $manager->remove($section); $manager->flush(); $this->get('session')->getFlashBag()->add('notice', 'Group section has been successfully removed'); return $this->redirect($this->generateUrl('civix_front_group_sections_index')); }