/** * @Route("/grid", name="lc_admin_person_grid") * @Template() */ public function gridAction(Request $request) { $form = $this->createForm(new PersonFilterFormType()); $form->handleRequest($request); $result['grid'] = null; if ($form->isValid()) { $em = $this->getDoctrine()->getManager(); $sql = $em->createQueryBuilder(); $sql->select('u'); $sql->from('PROCERGSLoginCidadaoCoreBundle:Person', 'u'); $sql->where('1=1'); $parms = $form->getData(); if (isset($parms['username'][0])) { $sql->andWhere('u.cpf like ?1 or LowerUnaccent(u.username) like LowerUnaccent(?1) or LowerUnaccent(u.email) like LowerUnaccent(?1) or LowerUnaccent(u.firstName) like LowerUnaccent(?1) or LowerUnaccent(u.surname) like LowerUnaccent(?1)'); $sql->setParameter('1', '%' . addcslashes($parms['username'], '\\%_') . '%'); } $sql->addOrderBy('u.id', 'desc'); $grid = new GridHelper(); $grid->setId('person-grid'); $grid->setPerPage(5); $grid->setMaxResult(5); $grid->setQueryBuilder($sql); $grid->setInfiniteGrid(true); $grid->setRoute('lc_admin_person_grid'); $grid->setRouteParams(array($form->getName())); return array('grid' => $grid->createView($request)); } return $result; }
/** * @Route("/grid", name="lc_admin_app_grid") * @Template() */ public function gridAction(Request $request) { $em = $this->getDoctrine()->getManager(); $sql = $em->getRepository('PROCERGSOAuthBundle:Client')->createQueryBuilder('c')->addOrderBy('c.id', 'desc'); $grid = new GridHelper(); $grid->setId('client-grid'); $grid->setPerPage(15); $grid->setMaxResult(15); $grid->setQueryBuilder($sql); $grid->setInfiniteGrid(true); $grid->setRoute('lc_admin_app'); return array('grid' => $grid->createView($request)); }
/** * @Route("/grid", name="lc_dev_shout_grid") * @Template() */ public function gridAction(Request $request) { $em = $this->getDoctrine()->getManager(); $sql = $em->getRepository('PROCERGSLoginCidadaoCoreBundle:Notification\\Shout')->createQueryBuilder('c')->where('c.person = :person')->setParameter('person', $this->getUser())->addOrderBy('c.id', 'desc'); $grid = new GridHelper(); $grid->setId('shout-grid'); $grid->setPerPage(5); $grid->setMaxResult(5); $grid->setQueryBuilder($sql); $grid->setInfiniteGrid(true); $grid->setRoute('lc_dev_shout_grid'); return array('grid' => $grid->createView($request)); }
/** * @Route("/listQuery", name="lc_admin_sugg_list_query") * @Template() */ public function listQueryAction(Request $request) { $form = $this->createForm(new SuggestionFilterFormType()); $form->handleRequest($request); $result['grid'] = null; if ($form->isValid()) { $em = $this->getDoctrine()->getManager(); $sql = $em->createQueryBuilder(); $sql->select('cs.id, cs.createdAt, cs.text shorttext, u.username'); $sql->from('PROCERGSLoginCidadaoCoreBundle:ClientSuggestion', 'cs'); $sql->join('PROCERGSLoginCidadaoCoreBundle:Person', 'u', 'WITH', 'cs.person = u'); $sql->where('1=1'); $parms = $form->getData(); if (isset($parms['username'][0])) { $sql->andWhere('u.username = ?1'); $sql->setParameter('1', $parms['username']); } if (isset($parms['dateini'])) { $sql->andWhere('cs.createdAt >= ?2'); $sql->setParameter('2', $parms['dateini']); } if (isset($parms['dateend'])) { $sql->andWhere('cs.createdAt <= ?3'); $sql->setParameter('3', $parms['dateend']); } if (isset($parms['text'][0])) { $sql->andWhere("cs.text like ?4"); $sql->setParameter('4', '%' . addcslashes($parms['text'], '\\%_') . '%'); } $sql->addOrderBy('cs.createdAt'); $grid = new GridHelper(); $grid->setId('suggs-grid'); $grid->setPerPage(5); $grid->setMaxResult(5); $grid->setQueryBuilder($sql); $grid->setInfiniteGrid(true); $grid->setRoute('lc_admin_sugg_list_query'); $grid->setRouteParams(array($form->getName())); return array('grid' => $grid->createView($request)); } return $result; }
/** * @Route("/placeholder/grid", name="lc_dev_not_placeholder_grid") * @Template() */ public function placeholderGridAction(Request $request) { $categoryId = $request->get('category_id'); $em = $this->getDoctrine()->getManager(); $sql = $em->getRepository('PROCERGSLoginCidadaoNotificationBundle:Placeholder')->createQueryBuilder('u')->join('PROCERGSLoginCidadaoNotificationBundle:Category', 'cat', 'with', 'u.category = cat')->join('PROCERGSOAuthBundle:Client', 'c', 'with', 'cat.client = c')->where(':person MEMBER OF c.owners')->andWhere('cat.id = :id')->setParameter('person', $this->getUser())->setParameter('id', $categoryId)->orderBy('u.id', 'desc'); $grid = new GridHelper(); $grid->setId('placeholder-grid'); $grid->setPerPage(2); $grid->setMaxResult(2); $grid->setQueryBuilder($sql); $grid->setInfiniteGrid(true); $grid->setRoute('lc_dev_not_placeholder_grid'); $grid->setRouteParams(array('category_id')); return array('grid' => $grid->createView($request)); }
/** * @Route("/grid/developer", name="lc_dev_client_grid_developer") * @Template() */ public function gridDeveloperAction(Request $request) { $grid = new GridHelper(); $grid->setId('developer-grid'); $grid->setPerPage(5); $grid->setMaxResult(5); $parms = $request->get('ac_data'); if (isset($parms['person_id']) && !empty($parms['person_id'])) { $em = $this->getDoctrine()->getManager(); $sql = $em->getRepository('PROCERGSLoginCidadaoCoreBundle:Person')->createQueryBuilder('p'); $sql->where('p.id in(:id)')->setParameter('id', $parms['person_id']); $sql->addOrderBy('p.id', 'desc'); $grid->setQueryBuilder($sql); } $grid->setInfiniteGrid(true); $grid->setRouteParams(array('ac_data')); $grid->setRoute('lc_dev_client_grid_developer'); return array('grid' => $grid->createView($request)); }
private function getNotificationGrid($offset = 0, $perIteration = 10, ClientInterface $client = null) { $handler = $this->getAuthenticatedNotificationHandler(); if ($client instanceof ClientInterface) { $iterator = new ClientNotificationIterable($handler, $client, $perIteration, $offset); } else { $iterator = new NotificationIterable($handler, $perIteration, $offset); } $grid = new GridHelper($iterator); $grid->setId('notificationInfiniteGrid'); $grid->setPerPage(10); $grid->setMaxResult(10); $grid->setInfiniteGrid(true); $routeParams = array('offset'); if ($client instanceof ClientInterface) { $grid->setRoute('lc_client_notifications_grid_fragment'); $routeParams[] = 'clientId'; } else { $grid->setRoute('lc_notifications_grid_fragment'); } $grid->setRouteParams($routeParams); return $grid; }
/** * @Route("/profile/doc/rg/list", name="lc_profile_doc_rg_list") * @Template() */ public function docRgListAction(Request $request) { $sql = $this->getDoctrine()->getManager()->getRepository('PROCERGSLoginCidadaoCoreBundle:IdCard')->getGridQuery($this->getUser()); $grid = new GridHelper(); $grid->setId('rg-grid'); $grid->setPerPage(4); $grid->setMaxResult(4); $grid->setQueryBuilder($sql); $grid->setInfiniteGrid(true); $grid->setRoute('lc_profile_doc_rg_list'); return array('grid' => $grid->createView($request)); }
/** * @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)); }