/** * @Route("/grid", name="lc_admin_person_grid") * @Template() */ public function gridAction(Request $request) { $form = $this->createForm('LoginCidadao\\CoreBundle\\Form\\Type\\PersonFilterFormType'); $form->handleRequest($request); $result['grid'] = null; if ($form->isValid()) { $em = $this->getDoctrine()->getManager(); $sql = $em->createQueryBuilder(); $sql->select('u'); $sql->from('LoginCidadaoCoreBundle: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("/organizations/members", name="lc_organizations_members") * @Template() */ public function listMembersAction(Request $request) { $grid = new GridHelper(); $grid->setId('developer-grid')->setPerPage(5)->setMaxResult(5)->setInfiniteGrid(true)->setRouteParams(array('ac_data'))->setRoute('lc_organizations_members'); $parms = $request->get('ac_data'); if (isset($parms['person_id']) && !empty($parms['person_id'])) { $query = $this->getDoctrine()->getRepository('LoginCidadaoCoreBundle:Person')->getFindByIdIn($parms['person_id']); $grid->setQueryBuilder($query); } return array('grid' => $grid->createView($request)); }
/** * @Route("/grid", name="lc_admin_app_grid") * @Template() */ public function gridAction(Request $request) { $em = $this->getDoctrine()->getManager(); $sql = $em->getRepository('LoginCidadaoOAuthBundle: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("/listQuery", name="lc_admin_sugg_list_query") * @Template() */ public function listQueryAction(Request $request) { $form = $this->createForm('LoginCidadao\\CoreBundle\\Form\\Type\\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('LoginCidadaoCoreBundle:ClientSuggestion', 'cs'); $sql->join('LoginCidadaoCoreBundle: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("/profile/doc/rg/list", name="lc_profile_doc_rg_list") * @Template() */ public function docRgListAction(Request $request) { $sql = $this->getDoctrine()->getManager()->getRepository('LoginCidadaoCoreBundle: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("/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('LoginCidadaoCoreBundle: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)); }