/**
*@Route("/search/", name="search")
*/
public function indexAction(Request $request)
{
if ($request->getMEthod() == 'POST') {
$title = $request->get('search');
//echo "<div class=\"searchText\">Search Results</div><hr/>";
$connect = $this->get('database_connection');
$search1['result'] = $connect->fetchAll("select DISTINCT Nm From companies");
$Search_terms = explode(' ', $title);
//splits search terms at spaces
$query = "SELECT * FROM companies WHERE ";
$query1 = "SELECT * FROM items WHERE ";
$str = mysql_real_escape_string($title);
$query .= " Nm LIKE '%{$str}%' ";
$query1 .= " Nm LIKE '%{$str}%' ";
$searsh['result'] = $connect->fetchAll($query);
$search['result'] = $connect->fetchAll($query1);
$menuRepository = $this->getDoctrine()->getManager()->getRepository('AppBundle:Menu');
$menu['result'] = $menuRepository->showAction();
$data = ['search1' => $search1['result'], 'menu' => $menu['result'], 'shearch' => $searsh['result'], 'search' => $search['result']];
return $this->render('AppBundle:Default:index2.html.twig', compact('data'));
}
}
/**
*@Route("/search/", name="search")
*/
public function indexAction(Request $request)
{
if ($request->getMEthod() == 'POST') {
$title = $request->get('search');
//echo "<div class=\"searchText\">Search Results</div><hr/>";
$connect = $this->get('database_connection');
//$search1['result'] = $connect->fetchAll("select DISTINCT Nm From companies");
$stmt = $this->getDoctrine()->getManager()->getConnection()->prepare("select DISTINCT Nm From companies");
$stmt->execute();
$search1['result'] = $stmt->fetchAll();
$Search_terms = explode(' ', $title);
//splits search terms at spaces
$searchCondition = '';
////
foreach ($Search_terms as $i => $term) {
if ($i != 0) {
$searchCondition .= ' OR ';
}
$searchCondition .= ' Nm LIKE :term' . $i . ' ';
}
$query = $this->getDoctrine()->getManager()->getConnection()->prepare("SELECT * FROM companies WHERE " . $searchCondition);
foreach ($Search_terms as $i => $term) {
$query->bindValue(':term' . $i, $term);
}
$search['result'] = $query->fetchAll();
$query->execute();
$query1 = $this->getDoctrine()->getManager()->getConnection()->prepare("SELECT * FROM items WHERE Nm LIKE :title");
$query1->bindValue(':title', $title);
$query1->execute();
$search1['result'] = $query1->fetchAll();
$menuRepository = $this->getDoctrine()->getManager()->getRepository('AppBundle:Menu');
$menu['result'] = $menuRepository->showAction();
$data = ['search1' => $search1['result'], 'menu' => $menu['result'], 'shearch' => $search['result'], 'search' => $search1['result']];
return $this->render('AppBundle:Default:index2.html.twig', compact('data'));
}
}
/**
*@Security("has_role('ROLE_REDACTEUR')")
*/
public function editAction(Equipe $equipe, Request $request)
{
$em = $this->getDoctrine()->getManager();
$equipe = $em->getRepository("MdyGstBundle:Equipe")->find($equipe->getId());
if ($equipe == null) {
throw new NotFoundException('L\'équipe recherchée ["' . $equipe->getId() . '"] n\'a pas été trouvée');
}
$form = $this->createForm(new EquipeType(), $equipe);
if ($request->getMEthod() === "POST") {
$form->bind($request);
if ($form->isValid()) {
$em->persist($equipe);
$em->flush();
return $this->redirect($this->generateUrl('mdy_gst_listEquipe'));
}
}
return $this->render('MdyGstBundle:Gst:Equipe/edit.html.twig', array('form' => $form->createView()));
}