/**
* @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));
}
