src/Controller/Articles/ConcurrenceController.php line 394

Open in your IDE?
  1. <?php
  3. namespace App\Controller\Articles;
  5. use App\Entity\Articles\Article;
  6. use App\Entity\Articles\Concurrence;
  7. use App\Entity\Fournisseurs\Fournisseur;
  8. use App\Form\Articles\ConcurrenceType;
  9. use App\Form\Articles\SupprimerConcurrenceType;
  10. use App\Library\Datatable\Util\Datatable;
  11. use App\Security\Voter\EntityVoter;
  12. use App\Service\Articles\ArticleService;
  13. use App\Service\Utilisateur\ColonneTableauService;
  14. use Doctrine\ORM\EntityManagerInterface;
  15. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  16. use Symfony\Component\HttpFoundation\Request;
  17. use Symfony\Component\HttpFoundation\JsonResponse;
  18. use Symfony\Component\HttpFoundation\Response;
  19. use Symfony\Component\Routing\Annotation\Route;
  20. use Symfony\Component\Validator\Validator\ValidatorInterface;
  21. use Symfony\Contracts\Translation\TranslatorInterface;
  23. class ConcurrenceController extends AbstractController
  24. {
  27.     /**
  28.      * @Route("/concurrence-article/nouveau/{id}/{type}", name="dtc_concurrence_article_ajouter")
  29.      */
  30.     public function ajouterAction(Request $request, $id, $type = "", EntityManagerInterface $em, ArticleService $articleService, TranslatorInterface $translator, ValidatorInterface $validator)
  31.     {
  33.         $titre_modal = $translator->trans("Nouvelle concurrence");
  34.         $repo_objet  = $em->getRepository(Article::class);
  37.         $get         = $request->query->all();
  38.         $concurrence = new Concurrence();
  40.         $objet = $repo_objet->find($id);
  41.         if (is_object($objet)) {
  42.             $concurrence->setArticle($objet);
  43.             //$concurrence->setLibelle($objet->getLibelle());
  44.         }
  46.         $user = $this->getUser();
  47.         $concurrence->setUtilisateur($user);
  48.         $form      = $this->createForm(ConcurrenceType::class, $concurrence);
  49.         $errors    = "";
  50.         $form->handleRequest($request);
  51.         if ($form->isSubmitted()) {
  53.             if ($form->isValid()) {
  57.                 if ($type == 'article') {
  59.                     $repo_objet = $em->getRepository(Article::class);
  60.                     $objet      = $repo_objet->find($id);
  63.                     $url = $this->generateUrl('dtc_article_modifier', ['id' => $objet->getId(), 'tab' => 'concurrence']);
  64.                 }
  66.                 $em->persist($concurrence);
  67.                 $em->persist($objet);
  68.                 $em->flush();
  71.                 if (array_key_exists('table', $get) && $get["table"] != "") {
  72.                     return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => $url, 'type' => 'recharger_datatable', 'id_datatable' => $get["table"]],
  73.                                             200,
  74.                                             ['Content-Type' => 'application/json']);
  75.                 } else {
  76.                     $this->addFlash('notice', $translator->trans('Concurrence ajoutée avec succès !'));
  78.                     return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => $url]);
  80.                 }
  83.             } else {
  84.                 $errors = $validator->validate($concurrence);
  85.                 $rendu  = $this->renderView(
  86.                     'Articles/Concurrence/ajouter.html.twig',
  87.                     ['form' => $form->createView(), 'errors' => $errors, 'id' => $id, 'type' => $type, 'concurrence' => $concurrence]
  88.                 );
  90.                 return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  92.             }
  93.         }
  94.         $rendu = $this->renderView(
  95.             'Articles/Concurrence/ajouter.html.twig',
  96.             ['form' => $form->createView(), 'errors' => $errors, 'id' => $id, 'type' => $type, 'concurrence' => $concurrence]
  97.         );
  99.         return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  100.         //return $this->render('Articles/Concurrence/ajouter.html.twig', array('form' => $form->createView(),'errors'=>$errors,'id'=>$id,'type'=>$type));
  101.     }
  104.     /**
  105.      * @Route("/concurrence-article/modifier/{objet}/{id}/{type}", name="dtc_concurrence_article_modifier")
  106.      */
  107.     public function modifierAction(Request $request, Concurrence $objet, $id, $type, EntityManagerInterface $em, ArticleService $articleService, TranslatorInterface $translator, ValidatorInterface $validator)
  108.     {
  109.         $concurrence = $objet;
  110.         $titre_modal = $translator->trans("Modifier la concurrence");
  111.         $get         = $request->query->all();
  112.         $user        = $this->getUser();
  113.         $concurrence->setUtilisateur($user);
  114.         $form      = $this->createForm(ConcurrenceType::class, $concurrence);
  115.         $errors    = "";
  116.         $form->handleRequest($request);
  117.         if ($form->isSubmitted()) {
  119.             $droit         = $this->isGranted(EntityVoter::UPDATE, Concurrence::class);
  120.             /*
  121.             if(!$droit) {
  122.                 $rendu = $this->renderView('Articles/Concurrence/ajouter.html.twig', array('form' => $form->createView(),'errors'=>$errors,'id'=>$id,'type'=>$type,'objet'=>$objet));
  123.                 return new Response(json_encode(array('rendu'=>$rendu,'valide'=>'0','url'=>'','titre'=>$titre_modal)), 200, array('Content-Type'=>'application/json'));
  124.             }
  125.             */
  126.             if ($form->isValid()) {
  130.                 if ($type == 'article') {
  131.                     $repo_objet = $em->getRepository(Article::class);
  132.                     $article    = $repo_objet->find($id);
  133.                     if (is_object($article)) {
  134.                         $concurrence->setArticle($article);
  136.                     }
  137.                     $url = $this->generateUrl('dtc_article_modifier', ['id' => $article->getId(), 'tab' => 'concurrence']);
  138.                 }
  141.                 $em->persist($concurrence);
  142.                 $em->flush();
  145.                 if (array_key_exists('table', $get) && $get["table"] != "") {
  146.                     return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => $url, 'type' => 'recharger_datatable', 'id_datatable' => $get["table"]],
  147.                                             200,
  148.                                             ['Content-Type' => 'application/json']);
  149.                 } else {
  150.                     $this->addFlash('notice', $translator->trans('Concurrence modifiée avec succès !'));
  152.                     return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => $url]);
  154.                 }
  157.             } else {
  158.                 $errors = $validator->validate($concurrence);
  159.                 $rendu  = $this->renderView(
  160.                     'Articles/Concurrence/ajouter.html.twig',
  161.                     ['form' => $form->createView(), 'errors' => $errors, 'id' => $id, 'type' => $type, 'objet' => $objet, 'concurrence' => $concurrence]
  162.                 );
  164.                 return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  166.             }
  167.         }
  168.         $rendu = $this->renderView(
  169.             'Articles/Concurrence/ajouter.html.twig',
  170.             ['form' => $form->createView(), 'errors' => $errors, 'id' => $id, 'type' => $type, 'objet' => $objet, 'concurrence' => $concurrence]
  171.         );
  173.         return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  174.     }
  176.     /**
  177.      * @Route("/concurrence-article/supprimer/{objet}/{id}/{type}", name="dtc_concurrence_article_supprimer")
  178.      */
  179.     public function supprimerAction(Request $request, Concurrence $objet, $id, $type, EntityManagerInterface $em, TranslatorInterface $translator, ValidatorInterface $validator)
  180.     {
  182.         $concurrence = $objet;
  183.         $titre_modal = $translator->trans("Demande de confirmation");
  184.         $get         = $request->query->all();
  185.         $user        = $this->getUser();
  187.         $form   = $this->createForm(SupprimerConcurrenceType::class, $concurrence);
  188.         $errors = "";
  189.         $form->handleRequest($request);
  190.         if ($form->isSubmitted()) {
  192.             if ($form->isValid()) {
  193.                 $em->remove($concurrence);
  194.                 $em->flush();
  197.                 $url = "";
  198.                 if ($type == 'article') {
  199.                     $url = $this->generateUrl('dtc_article_modifier', ['id' => $id, 'tab' => 'concurrence']);
  200.                 }
  202.                 if (array_key_exists('table', $get) && $get["table"] != "") {
  203.                     return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => $url, 'type' => 'recharger_datatable', 'id_datatable' => $get["table"]],
  204.                                             200,
  205.                                             ['Content-Type' => 'application/json']);
  206.                 } else {
  207.                     $this->addFlash('notice', $translator->trans('Concurrence supprimée avec succès !'));
  209.                     return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => $url]);
  211.                 }
  214.             } else {
  216.                 $errors = $validator->validate($concurrence);
  217.                 $rendu  = $this->renderView('FO/Supprimer/supprimer.html.twig', ['form' => $form->createView(), 'errors' => $errors, 'id' => $id, 'type' => $type, 'objet' => $objet]);
  219.                 return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  221.             }
  222.         }
  223.         $rendu = $this->renderView('FO/Supprimer/supprimer.html.twig', ['form' => $form->createView(), 'errors' => $errors, 'id' => $id, 'type' => $type, 'objet' => $objet]);
  225.         return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  226.     }
  229.     /**
  230.      * @Route("/concurrence-article/charger-tableau/{id}/{type}", name="dtc_concurrence_charger_tableau")
  231.      */
  232.     public function chargerTableauAction(Request $request, $id = "0", $type = "a")
  233.     {
  235.         $rendu = $this->renderView('Articles/Concurrence/charger_tableau.html.twig', ["id" => $id, "type" => $type]);
  237.         return new JsonResponse(['rendu' => $rendu]);
  239.     }
  242.     /**
  243.      * @Route("/concurrence-article", name="dtc_concurrence_article_liste")
  244.      */
  245.     public function listerAction(Request $request, $id = "0", $type = "a", EntityManagerInterface $em, Datatable $datatable, TranslatorInterface $translator)
  246.     {
  248.         $tableau_class_cellule = [];
  250.         $tableau_class_cellule[] = ["searchable" => false, "className" => "visible_export colonne_id text-center", "targets" => [0], "visible" => true];
  251.         $tableau_class_cellule[] = ["searchable" => false, "className" => "visible_export colonne_id ", "targets" => [1], "visible" => true];
  252.         $tableau_class_cellule[] = ["searchable" => false, "className" => "visible_export colonne_id text-right", "targets" => [2], "visible" => true];
  253.         $tableau_class_cellule[] = ["searchable" => false, "className" => "visible_export colonne_id text-center", "targets" => [3], "visible" => true];
  254.         $tableau_class_cellule[] = ["searchable" => false, "className" => "visible_export colonne_id text-center", "targets" => [4], "visible" => true];
  255.         $tableau_class_cellule[] = ["orderable" => false, "searchable" => false, "className" => "visible_export colonne_id text-center", "targets" => [5], "visible" => true];
  257.         /*
  258.         $tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id text-center","targets"=>array(0),"visible"=>true);
  259.         $tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id text-center","targets"=>array(1),"visible"=>true);
  260.         $tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id","targets"=>array(2),"visible"=>true);
  261.         $tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id ","targets"=>array(3),"visible"=>true);
  262.         $tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id text-right","targets"=>array(4),"visible"=>true);
  263.         $tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id text-center","targets"=>array(5),"visible"=>true);
  264.         $tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id text-center","targets"=>array(6),"visible"=>true);
  265.         $tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id text-center","targets"=>array(7),"visible"=>true);
  266.         $tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id text-center","targets"=>array(8),"visible"=>true);
  267.         $tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id text-right","targets"=>array(9),"visible"=>true);
  268.         $tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id text-center","targets"=>array(10),"visible"=>true);
  269.         $tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id text-right","targets"=>array(11),"visible"=>true);
  270.         $tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id text-center","targets"=>array(12),"visible"=>true);
  271.         $tableau_class_cellule[]=array("orderable"=> false,"searchable"=> false,"className"=>" colonne_id text-center","targets"=>array(13),"visible"=>true);
  272.         $tableau_class_cellule[]=array("orderable"=> false,"searchable"=> false,"className"=>" colonne_id text-center","targets"=>array(14),"visible"=>true);
  273.         $tableau_class_cellule[]=array("orderable"=> false,"searchable"=> false,"className"=>" colonne_id text-center","targets"=>array(15),"visible"=>true);
  274.         */
  276.         $modal     = $request->query->get('modal');
  277.         $articleId = $request->query->get('id');
  278.         $qte       = $request->query->get('qte');
  280.         if ($type == "article") {
  281.             $repo_objet = $em->getRepository(Article::class);
  282.         }
  283.         if ($type == "fournisseur") {
  284.             $repo_objet = $em->getRepository(Fournisseur::class);
  285.         }
  288.         $objet = $repo_objet->find($id);
  289.         if ($articleId != '') {
  290.             $article = $repo_objet->find($articleId);
  292.             if ($modal == 1 && is_object($article)) {
  293.                 $titre_modal = $translator->trans('Concurrence');
  294.                 $this->datatableArticle($article, $type, $datatable, $translator);
  295.                 $rendu = $this->renderView('Articles/Concurrence/lister.html.twig', ['tableauClassColonne' => $tableau_class_cellule, "id" => $articleId, "type" => $type, 'qte' => $qte]
  296.                 );
  298.                 //$rendu = $this->renderView('FO/Supprimer/supprimer.html.twig', array('form' => $form->createView(),'errors'=>$errors,'id'=>$id,'type'=>$type,'objet'=>$objet));
  299.                 return new Response(json_encode(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]));
  300.             }
  301.         }
  303.         if (is_object($objet)) {
  306.             if ($type == "article") {
  309.                 $this->datatableArticle($objet, $type, $datatable, $translator);
  310.             } elseif ($type == "fournisseur") {
  313.                 $tableau_class_cellule   = [];
  314.                 $tableau_class_cellule[] = ["searchable" => false, "className" => "visible_export colonne_id", "targets" => [0], "visible" => true];
  315.                 $tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export colonne_id", "targets" => [1], "visible" => true];
  316.                 $tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export colonne_id", "targets" => [2], "visible" => true];
  317.                 $tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export colonne_id text-center", "targets" => [3], "visible" => true];
  318.                 $tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export colonne_id text-center", "targets" => [4], "visible" => true];
  319.                 $tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export colonne_id text-center", "targets" => [5], "visible" => true];
  320.                 $tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export colonne_id text-center", "targets" => [6], "visible" => true];
  321.                 $tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export colonne_id text-right", "targets" => [7], "visible" => true];
  322.                 $tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export colonne_id text-center", "targets" => [8], "visible" => true];
  323.                 $tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export colonne_id text-center", "targets" => [9], "visible" => true];
  324.                 $tableau_class_cellule[] = ["orderable" => false, "className" => "colonne_id visible_export text-right", "targets" => [10], "visible" => true];
  326.                 $this->datatableFournisseur($objet, $type, $datatable, $translator);
  327.             }
  330.             return $this->render('Articles/Concurrence/lister.html.twig', ['tableauClassColonne' => $tableau_class_cellule, "id" => $id, "type" => $type]);
  331.         } else {
  332.             $this->datatable($datatable, $translator);
  334.             return $this->render('Articles/Concurrence/lister.html.twig', ['tableauClassColonne' => $tableau_class_cellule, "id" => $id, "type" => $type]);
  335.         }
  336.     }
  339.     /**
  340.      * set datatable configs
  341.      *
  342.      * @return \App\Library\Datatable\Util\Datatable
  343.      */
  344.     private function datatable(Datatable $datatable, TranslatorInterface $translator)
  345.     {
  347.         $datatable->setDatatableId('dta-concurrence')
  348.                   ->setEntity(Concurrence::class, "x")
  349.                   ->setFields(
  350.                       [
  351.                           $translator->trans("ID")      => 'x.id',
  352.                           //$translator->trans("Libelle") =>  'x.libelle',
  353.                           $translator->trans("Actions") => 'x.id',
  354.                           "_identifier_"                => 'x.id',
  355.                       ]
  356.                   )
  357.             //->addJoin('x.statutCommande', 's', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  358.             /*->setWhere(
  359.                     $type_jointure.' = :objet',
  360.                     array('objet' => $objet)
  361.                )
  362.               */
  363.                   ->setRenderers(
  364.                 [
  367.                     2 => [
  368.                         'view'   => 'FO/DataTable/actions.html.twig',
  369.                         'params' => [
  370.                             //'edit_route'  => 'dtc_garantie_modifier',
  371.                             //'supprimer_route'  => 'dtc_garantie_supprimer',
  372.                             'entite' => 'garantie',
  373.                             'objet'  => Concurrence::class,
  375.                         ],
  376.                     ],
  379.                 ]
  380.             )
  381.                   ->setOrder("x.id", "desc")
  382.                   ->setSearch(true)
  383.                   ->setSearchFields([1, 4]);
  385.         return $datatable;
  386.     }
  389.     /**
  390.      * set datatable configs
  391.      *
  392.      * @return \App\Library\Datatable\Util\Datatable
  393.      */
  394.     private function datatableFournisseur($objet, $type = "", Datatable $datatable, TranslatorInterface $translator)
  395.     {
  398.         $type_jointure = 'x.'.$type;
  399.         $datatable->setDatatableId('dta-concurrence-fournisseur')
  400.                   ->setEntity(Concurrence::class, "x")
  401.                   ->setFields(
  402.                       [
  403.                           //$translator->trans("ID") =>  'x.id',
  404.                           $translator->trans("Réf")           => 'a.reference',
  405.                           $translator->trans("Réf fourn")     => 'x.referenceFournisseur',
  406.                           $translator->trans("Libellé")       => 'a.libelle',
  407.                           $translator->trans("Qté mini cond") => 'x.quantite',
  409.                           $translator->trans("Qté mini art") => 'a.seuilMiniCommandeFournisseur',
  410.                           $translator->trans("Qté maxi art") => 'a.seuilMaxiCommandeFournisseur',
  412.                           $translator->trans("Conditionnement")  => 'x.conditionnement',
  413.                           $translator->trans("Prix achat brut")  => 'x.prixAchatBrut',
  414.                           $translator->trans("Tx remise")        => 'x.tauxRemise',
  415.                           $translator->trans("Tx remise suppl.") => 'x.tauxRemiseSupplementaire',
  416.                           $translator->trans("Prix achat net")   => 'x.prixAchatNet',
  417.                           //$translator->trans("Fournisseur") =>  'f.libelle',
  418.                           //$translator->trans("Devise") =>  "d.name",
  419.                           $translator->trans("Défaut")           => 'x.defaut',
  420.                           $translator->trans("Actions")          => 'x.id',
  421.                           "_identifier_"                         => 'x.id',
  422.                       ]
  423.                   )
  424.                   ->addJoin('x.article', 'a', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  425.                   ->addJoin('x.fournisseur', 'f', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  426.                   ->addJoin('f.devise', 'd', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  427.                   ->setWhere(
  428.                       'x.fournisseur = :objet',
  429.                       ['objet' => $objet]
  430.                   )
  431.                   ->setRenderers(
  432.                       [
  434.                           /*
  435.                           1 => array(
  436.                               'view' => 'FO/DataTable/actions_modal.html.twig',
  437.                               'params' => array(
  438.                                       'edit_route'  => 'dtc_article_modifier',
  439.                                       'id'    => '',
  440.                                       'type'    => $type,
  441.                                       //'entite'    => 'article',
  442.                                       //'objet' => "DTCArticlesBundle:Article",
  443.                                       'typeDocument' => 'article'
  444.                                   ),
  445.                           ),
  446.                            *
  447.                            */
  449.                           2 => [
  450.                               'view'   => 'FO/DataTable/actions_modal.html.twig',
  451.                               'params' => [
  452.                                   'edit_route' => 'dtc_condition_achat_modifier',
  453.                                   'id'         => $objet->getId(),
  454.                                   'type'       => $type,
  455.                                   'entite'     => 'garantie',
  456.                                   'objet'      => Concurrence::class,
  457.                                   'affichage'  => 'item',
  458.                               ],
  459.                           ],
  461.                           7  => [
  462.                               'view' => 'FO/DataTable/prix.html.twig',
  463.                           ],
  464.                           10 => [
  465.                               'view' => 'FO/DataTable/prix.html.twig',
  466.                           ],
  467.                           11 => [
  468.                               'view' => 'FO/DataTable/booleen.html.twig',
  469.                           ],
  470.                           12 => [
  471.                               'view'   => 'FO/DataTable/actions_modal.html.twig',
  472.                               'params' => [
  473.                                   'edit_route'      => 'dtc_condition_achat_modifier',
  474.                                   'supprimer_route' => 'dtc_condition_achat_supprimer',
  475.                                   'id'              => $objet->getId(),
  476.                                   'type'            => $type,
  477.                                   'table'           => "dta-concurrence",
  478.                                   'entite'          => 'garantie',
  479.                                   'objet'           => Concurrence::class
  480.                               ,
  481.                                   'width_modal'     => 800,
  482.                               ],
  483.                           ],
  484.                       ]
  485.                   )
  486.                   ->setOrder("x.id", "desc")
  487.                   ->setSearch(true)
  488.                   ->setSearchFields([1, 2, 3, 6, 7, 8, 9, 10]);
  490.         return $datatable;
  491.     }
  494.     /**
  495.      * set datatable configs
  496.      *
  497.      * @return \App\Library\Datatable\Util\Datatable
  498.      */
  499.     private function datatableArticle($objet, $type = "", Datatable $datatable, TranslatorInterface $translator)
  500.     {
  501.         $type_jointure = 'x.'.$type;
  502.         $datatable->setDatatableId('dta-concurrence')
  503.                   ->setEntity(Concurrence::class, "x")
  504.                   ->setFields(
  505.                       [
  506.                           //$translator->trans("ID") =>  'x.id',
  507.                           $translator->trans("Date")       => 'x.date',
  508.                           $translator->trans("Concurrent") => 'x.concurrent',
  509.                           $translator->trans("Prix")       => 'x.prix',
  510.                           $translator->trans("Devise")     => 'd.name',
  511.                           $translator->trans("Équiper")    => 'u.reference',
  513.                           $translator->trans("Actions") => 'x.id',
  514.                           "_identifier_"                => 'x.id',
  515.                       ]
  516.                   )
  517.                   ->addJoin('x.devise', 'd', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  518.                   ->addJoin('x.utilisateur', 'u', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  519.             //    ->addJoin('f.devise', 'd', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  520.             //    ->addJoin('x.uniteMesure', 'u', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  521.             /*->setWhere(
  522.                     $type_jointure.' = :objet',
  523.                     array('objet' => $objet)
  524.                )
  525.               */
  526.                   ->setWhere(
  527.                 'x.article = :objet',
  528.                 ['objet' => $objet]
  529.             )
  530.                   ->setRenderers(
  531.                       [
  532.                           0 => [
  533.                               'view' => 'FO/DataTable/date.html.twig',
  534.                           ],
  535.                           2 => [
  536.                               'view'   => 'FO/DataTable/prix.html.twig',
  537.                               'params' => [
  538.                                   'afficher_total' => false,
  539.                               ],
  540.                           ],
  541.                           4 => [
  542.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  543.                               'params' => [
  544.                                   'edit_route'   => 'dtc_utilisateur_modifier',
  545.                                   'typeDocument' => 'equipier',
  546.                               ],
  547.                           ],
  548.                           5 => [
  549.                               'view'   => 'FO/DataTable/actions_modal.html.twig',
  550.                               'params' => [
  551.                                   'edit_route'      => 'dtc_concurrence_article_modifier',
  552.                                   'supprimer_route' => 'dtc_concurrence_article_supprimer',
  553.                                   'id'              => $objet->getId(),
  554.                                   'type'            => $type,
  555.                                   'table'           => "dta-concurrence",
  556.                                   'entite'          => 'garantie',
  557.                                   'objet'           => Concurrence::class,
  558.                                   'width_modal'     => 800,
  559.                               ],
  560.                           ],
  561.                       ]
  562.                   )
  563.                   ->setOrder("x.id", "desc")
  564.                   ->setSearch(true)//->setSearchFields(array(1,2))
  565.         ;
  567.         return $datatable;
  568.     }
  571.     /**
  572.      * @Route("/concurrence-article/grid/{id}/{type}", name="dtc_concurrence_article_liste_grid")
  573.      */
  574.     public function gridAction($id = "", $type = "",EntityManagerInterface $em, Datatable $datatable, TranslatorInterface $translator)
  575.     {
  576.         if ($type == "article") {
  577.             $repo_objet = $em->getRepository(Article::class);
  578.         } elseif ($type == "fournisseur") {
  579.             $repo_objet = $em->getRepository(Fournisseur::class);
  580.         }
  581.         $objet = $repo_objet->find($id);
  583.         if (is_object($objet) and $type == "article") {
  584.             return $this->datatableArticle($objet, $type, $datatable, $translator)->execute();
  585.         } elseif (is_object($objet) and $type == "fournisseur") {
  586.             return $this->datatableFournisseur($objet, $type, $datatable, $translator)->execute();
  587.         } else {
  588.             return $this->datatable($datatable, $translator)->execute();
  589.         }
  591.     }
  594. }