/**
  * @Route("/inbox/gridsimple", name="lc_not_inbox_gridsimple")
  * @Template()
  */
 public function gridSimpleAction()
 {
     $request = $this->getRequest();
     $id = $request->get('confignotcli');
     if (!$id) {
         return $this->gridFullAction();
     }
     $sql = $this->getDoctrine()->getManager()->getRepository('PROCERGSLoginCidadaoCoreBundle:Notification\\Notification')->createQueryBuilder('n')->select('n.id, case when n.readDate is null then false else true end isread, n.title, n.shortText shorttext, n.createdAt createdat, c.id client_id, c.name client_name')->join('PROCERGSLoginCidadaoCoreBundle:Notification\\Category', 'cnc', 'WITH', 'n.category = cnc')->join('PROCERGSOAuthBundle:Client', 'c', 'WITH', 'cnc.client = c')->where('n.person = :person and cnc.id = :configNotCli')->setParameter('person', $this->getUser())->setParameter('configNotCli', $id)->orderBy('n.id', 'DESC');
     if ($request->get('client')) {
         $sql->andWhere('c.id = :client')->setParameter('client', $request->get('client'));
     }
     $grid = new GridHelper();
     $grid->setId('simpleOne' . $id);
     $grid->setPerPage(10);
     $grid->setMaxResult(10);
     $grid->setQueryBuilder($sql);
     $grid->setInfinityGrid(true);
     $grid->setRoute('lc_not_inbox_gridsimple');
     $grid->setRouteParams(array('client', 'mode', 'notification', 'confignotcli'));
     return array('grid' => $grid->createView($request));
 }