render($this->twig.'list.html.twig', [ 'useheader' => true, 'usemenu' => false, 'usesidebar' => true, 'access' => $access, ]); } public function tablelist(Request $request, ManagerRegistry $em): Response { $query = $request->query->all(); $start = $query['start']; $length = $query['length']; $search = $query['search']; $draw = $query['draw']; $ordercolumn = $query['order'][0]['column']; $orderdir = $query['order'][0]['dir']; // Nombre total d'enregistrement $total = $em->getManager()->createQueryBuilder()->select('COUNT(entity)')->from($this->entity, 'entity')->getQuery()->getSingleScalarResult(); // Nombre d'enregistrement filtré if (!$search || '' == $search['value']) { $totalf = $total; } else { $totalf = $em->getManager()->createQueryBuilder() ->select('COUNT(entity)') ->from($this->entity, 'entity') ->where('entity.label LIKE :value') ->setParameter('value', '%'.$search['value'].'%') ->getQuery() ->getSingleScalarResult(); } // Construction du tableau de retour $output = [ 'draw' => $draw, 'recordsFiltered' => $totalf, 'recordsTotal' => $total, 'data' => [], ]; // Parcours des Enregistrement $qb = $em->getManager()->createQueryBuilder(); $qb->select('entity')->from($this->entity, 'entity'); if ($search && '' != $search['value']) { $qb->andWhere('entity.label LIKE :value') ->setParameter('value', '%'.$search['value'].'%'); } if ($ordercolumn) { switch ($ordercolumn) { case 1: $qb->orderBy('entity.label', $orderdir); break; } } $datas = $qb->setFirstResult($start)->setMaxResults($length)->getQuery()->getResult(); foreach ($datas as $data) { // Action $action = ''; $action .= " $data->getId()])."'>"; $tmp = []; array_push($tmp, $action); array_push($tmp, $data->getLabel()); if ('LDAP' == $this->getParameter('appMasteridentity') || 'LDAP2NINE' == $this->getParameter('appSynchro')) { array_push($tmp, $data->getLdapfilter()); } if ('SSO' == $this->getParameter('appMasteridentity')) { array_push($tmp, $data->getAttributes()); } array_push($output['data'], $tmp); } // Retour return new JsonResponse($output); } public function submit($access, Request $request, ManagerRegistry $em): Response { // Initialisation de l'enregistrement $data = new Entity(); $data->setApikey(Uuid::uuid4()); // Création du formulaire $form = $this->createForm(Form::class, $data, [ 'mode' => 'submit', 'appMasteridentity' => $this->GetParameter('appMasteridentity'), 'appSynchro' => $this->GetParameter('appSynchro'), 'appNiveau01label' => $this->GetParameter('appNiveau01label'), ]); // Récupération des data du formulaire $form->handleRequest($request); // Sur validation if ($form->get('submit')->isClicked() && $form->isValid()) { $data = $form->getData(); // Sauvegarde $em->getManager()->persist($data); $em->getManager()->flush(); // Retour à la liste return $this->redirectToRoute($this->route); } // Affichage du formulaire return $this->render($this->twig.'edit.html.twig', [ 'useheader' => true, 'usemenu' => false, 'usesidebar' => true, 'mode' => 'submit', 'form' => $form->createView(), $this->data => $data, 'access' => $access, ]); } public function update($id, $access, Request $request, ManagerRegistry $em): Response { // Initialisation de l'enregistrement $data = $em->getRepository($this->entity)->find($id); if (!$data) { throw $this->createNotFoundException('Unable to find entity.'); } // Création du formulaire $form = $this->createForm(Form::class, $data, [ 'mode' => 'update', 'appMasteridentity' => $this->GetParameter('appMasteridentity'), 'appSynchro' => $this->GetParameter('appSynchro'), 'appNiveau01label' => $this->GetParameter('appNiveau01label'), ]); // Récupération des data du formulaire $form->handleRequest($request); // Sur validation if ($form->get('submit')->isClicked() && $form->isValid()) { $data = $form->getData(); $em->getManager()->flush(); // Retour à la liste return $this->redirectToRoute($this->route); } // Affichage du formulaire return $this->render($this->twig.'edit.html.twig', [ 'useheader' => true, 'usemenu' => false, 'usesidebar' => true, $this->data => $data, 'mode' => 'update', 'form' => $form->createView(), 'access' => $access, ]); } public function delete($id, $access, Request $request, ManagerRegistry $em): Response { // Récupération de l'enregistrement courant $data = $em->getRepository($this->entity)->find($id); if (!$data) { throw $this->createNotFoundException('Unable to find entity.'); } // Tentative de suppression try { $em->getManager()->remove($data); $em->getManager()->flush(); } catch (\Exception $e) { $request->getSession()->getFlashBag()->add('error', $e->getMessage()); return $this->redirectToRoute($this->route.'_update', ['id' => $id]); } return $this->redirectToRoute($this->route); } }