src/Controller/Utilisateur/HistoriqueInterventionController.php line 26

Open in your IDE?
  1. <?php
  3. namespace App\Controller\Utilisateur;
  6. use App\Entity\GestionComerciale\Activite;
  7. use App\Library\Datatable\Util\Datatable;
  8. use Doctrine\ORM\EntityManagerInterface;
  9. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  10. use Symfony\Component\HttpFoundation\Request;
  11. use Symfony\Component\HttpFoundation\JsonResponse;
  12. use Symfony\Component\HttpFoundation\Response;
  13. use Symfony\Component\HttpFoundation\RedirectResponse;
  15. use Symfony\Component\Routing\Annotation\Route;
  16. use Symfony\Component\Validator\Validator\ValidatorInterface;
  17. use Symfony\Contracts\Translation\TranslatorInterface;
  19. class HistoriqueInterventionController extends AbstractController
  20. {
  23.     /**
  24.      * @Route("", name="")
  25.      */
  26.     public function listerAction(Request $request, $id = "0", $type = "a", Datatable $datatable, TranslatorInterface $translator)
  27.     {
  29.         $tableau_class_cellule = [];
  32.         $tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export colonne_id", "targets" => [0], "visible" => true, "orderable" => false];
  33.         $tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export colonne_id", "targets" => [1], "visible" => true, "orderable" => false];
  34.         $tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export colonne_id text-center", "targets" => [2], "visible" => true, "orderable" => false];
  35.         $tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export colonne_id text-center", "targets" => [3], "visible" => true, "orderable" => false];
  36.         $tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export colonne_id", "targets" => [4], "visible" => true, "orderable" => false];
  38.         $this->datatable($datatable, $translator);
  40.         return $this->render('Utilisateur/HistoriqueIntervention/lister.html.twig', ['tableauClassColonne' => $tableau_class_cellule]);
  42.     }
  45.     /**
  46.      * set datatable configs
  47.      *
  48.      * @return \App\Library\Datatable\Util\Datatable
  49.      */
  50.     private function datatable(Datatable $datatable, TranslatorInterface $translator)
  51.     {
  53.         $user  = $this->getUser();
  54.         $where = 'x.dateFin IS NOT NULL AND u.id = :userId';
  55.         $where .= " AND ((x.action = 'emballage' AND x.objet = 'Bp') OR (x.action = 'preparation' AND x.objet = 'Bp') OR (x.action = 'reception' AND x.objet = 'Fabrication') OR (x.action = 'reception' AND x.objet = 'CommandeFournisseur'))";
  57.         $datatable->setDatatableId('dta-historique-intervention')
  58.             //->setEntity("DTCUtilisateurBundle:HistoriqueIntervention", "x")
  59.                   ->setEntity(Activite::class, "x")
  60.                   ->setFields(
  61.                       [
  62.                           $translator->trans("ID")       => 'x.id',
  63.                           $translator->trans("Document") => 'x.id',
  64.                           $translator->trans("Début")    => 'x.dateDebut',
  65.                           $translator->trans("Fin")      => 'x.dateFin',
  66.                           $translator->trans("Actions")  => 'x.action',
  67.                           "_identifier_"                 => 'x.id',
  68.                       ]
  69.                   )
  70.                   ->addJoin('x.utilisateur', 'u', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  71.             /*->setWhere(
  72.                     $type_jointure.' = :objet',
  73.                     array('objet' => $objet)
  74.                )
  75.               */
  76.                   ->setRenderers(
  77.                 [
  78.                     1 => [
  79.                         'view'   => 'FO/DataTable/reference_document_historique.html.twig',
  80.                         'params' => [],
  81.                     ],
  82.                     2 => [
  83.                         'view'   => 'FO/DataTable/heure.html.twig',
  84.                         'params' => [],
  85.                     ],
  86.                     3 => [
  87.                         'view'   => 'FO/DataTable/heure.html.twig',
  88.                         'params' => [],
  89.                     ],
  90.                     4 => [
  91.                         'view'   => 'FO/DataTable/libelle_activite.html.twig',
  92.                         'params' => [],
  93.                     ],
  94.                     /*
  95.                     5 => array(
  96.                         'view' => 'FO/DataTable/actions.html.twig',
  97.                         'params' => array(
  98.                                 //'edit_route'  => 'dtc_garantie_modifier',
  99.                                 //'supprimer_route'  => 'dtc_garantie_supprimer',
  100.                                 'entite'    => 'garantie',
  101.                                 'objet' => "DTCArticlesBundle:ConditionVente"
  103.                             ),
  104.                     ),
  105.                     */
  107.                 ]
  108.             )
  109.                   ->setWhere($where, ['userId' => $user->getId()])
  110.                   ->setOrder("x.dateFin desc, x.dateDebut", "desc")
  111.                   ->setSearch(true)//->setSearchFields(array(1,4))
  112.         ;
  114.         return $datatable;
  115.     }
  121.     /**
  122.      * Grid action
  123.      * @return Response
  124.      */
  125.     /**
  126.      * @Route("/historique-intervention", name="dtc_historique_intervention_grid")
  127.      */
  128.     public function gridAction(Request $request, Datatable $datatable, TranslatorInterface $translator)
  129.     {
  130.         return $this->datatable($datatable, $translator)->execute();
  132.     }
  134. }