src/Controller/Articles/ValeurAttributArticleController.php line 242

Open in your IDE?
  1. <?php
  3. namespace App\Controller\Articles;
  5. use App\Entity\Articles\AttributArticle;
  6. use App\Entity\Articles\ValeurAttributArticle;
  7. use App\Form\Articles\SupprimerValeurAttributArticleType;
  8. use App\Form\Articles\ValeurAttributArticleType;
  9. use App\Library\Datatable\Util\Datatable;
  10. use App\Security\Voter\EntityVoter;
  11. use Doctrine\ORM\EntityManagerInterface;
  12. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  13. use Symfony\Component\HttpFoundation\Request;
  14. use Symfony\Component\HttpFoundation\JsonResponse;
  15. use Symfony\Component\HttpFoundation\Response;
  16. use Symfony\Component\Routing\Annotation\Route;
  17. use Symfony\Component\Validator\Validator\ValidatorInterface;
  18. use Symfony\Contracts\Translation\TranslatorInterface;
  20. class ValeurAttributArticleController extends AbstractController
  21. {
  24.     /**
  25.      * @Route("/valeur-attribut-article/nouveau/{id}/{type}", name="dtc_valeur_attribut_article_ajouter")
  26.      */
  27.     public function ajouterAction(Request            $request, $id, $type = "dtc_valeur_attribut_article_ajouter", EntityManagerInterface $em, TranslatorInterface $translator,
  28.                                   ValidatorInterface $validator
  29.     ) {
  31.         $titre_modal           = $translator->trans("Nouvelle valeur");
  32.         $repo_objet            = $em->getRepository(AttributArticle::class);
  33.         $get                   = $request->query->all();
  34.         $valeurAttributArticle = new ValeurAttributArticle();
  36.         $objet = $repo_objet->find($id);
  37.         if (is_object($objet)) {
  38.             $valeurAttributArticle->setAttributArticle($objet);
  39.             //$valeurAttributArticle->setLibelle($objet->getLibelle());
  40.         }
  42.         $user = $this->getUser();
  43.         //$valeurAttributArticle->setUtilisateur($user);
  44.         $form   = $this->createForm(ValeurAttributArticleType::class, $valeurAttributArticle);
  45.         $errors = "";
  46.         $form->handleRequest($request);
  47.         if ($form->isSubmitted()) {
  49.             if ($form->isValid()) {
  51.                 if ($type == 'attributArticle') {
  52.                     $repo_objet = $em->getRepository(AttributArticle::class);
  53.                     $objet      = $repo_objet->find($id);
  54.                     $url        = $this->generateUrl('dtc_article_attribut_article_modifier', ['id' => $objet->getId(), 'tab' => 'valeurAttribut']);
  55.                 }
  57.                 $em->persist($valeurAttributArticle);
  58.                 $em->persist($objet);
  59.                 $em->flush();
  61.                 if (array_key_exists('table', $get) && $get["table"] != "") {
  62.                     return new JsonResponse(
  63.                         ['rendu' => '', 'valide' => '1', 'url' => $url, 'type' => 'recharger_datatable', 'id_datatable' => $get["table"]],
  64.                         200,
  65.                         ['Content-Type' => 'application/json']
  66.                     );
  67.                 } else {
  68.                     $this->addFlash('notice', $translator->trans('Déclinaison ajoutée avec succès !'));
  70.                     return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => $url]);
  72.                 }
  75.             } else {
  76.                 $errors = $validator->validate($valeurAttributArticle);
  77.                 $rendu  = $this->renderView(
  78.                     'Articles/ValeurAttributArticle/ajouter.html.twig',
  79.                     ['form' => $form->createView(), 'errors' => $errors, 'id' => $id, 'type' => $type, 'valeurAttributArticle' => $valeurAttributArticle]
  80.                 );
  82.                 return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  84.             }
  85.         }
  86.         $rendu = $this->renderView(
  87.             'Articles/ValeurAttributArticle/ajouter.html.twig',
  88.             ['form' => $form->createView(), 'errors' => $errors, 'id' => $id, 'type' => $type, 'valeurAttributArticle' => $valeurAttributArticle]
  89.         );
  91.         return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  92.         //return $this->render('Articles/ValeurAttributArticle/ajouter.html.twig', array('form' => $form->createView(),'errors'=>$errors,'id'=>$id,'type'=>$type));
  93.     }
  96.     /**
  97.      * @Route("/valeur-attribut-article/modifier/{objet}/{id}/{type}", name="dtc_valeur_attribut_article_modifier")
  98.      */
  99.     public function modifierAction(Request             $request, ValeurAttributArticle $objet, $id, $type, EntityManagerInterface $em, 
  100.                                    TranslatorInterface $translator, ValidatorInterface $validator
  101.     ) {
  102.         $url                   = "";
  103.         $valeurAttributArticle = $objet;
  104.         $titre_modal           = $translator->trans("Modifier la valeur");
  105.         $get                   = $request->query->all();
  106.         $user                  = $this->getUser();
  107.         // $valeurAttributArticle->setUtilisateur($user);
  108.         $form   = $this->createForm(ValeurAttributArticleType::class, $valeurAttributArticle);
  109.         $errors = "";
  110.         $form->handleRequest($request);
  111.         if ($form->isSubmitted()) {
  113.             $droit = $this->isGranted(EntityVoter::UPDATE,ValeurAttributArticle::class);
  114.             /*
  115.             if(!$droit) {
  116.                 $rendu = $this->renderView('Articles/ValeurAttributArticle/ajouter.html.twig', array('form' => $form->createView(),'errors'=>$errors,'id'=>$id,'type'=>$type,'objet'=>$objet));
  117.                 return new Response(json_encode(array('rendu'=>$rendu,'valide'=>'0','url'=>'','titre'=>$titre_modal)), 200, array('Content-Type'=>'application/json'));
  118.             }
  119.             */
  120.             if ($form->isValid()) {
  122.                 if ($type == 'article') {
  123.                     $repo_objet = $em->getRepository(AttributArticle::class);
  124.                     $article    = $repo_objet->find($id);
  126.                     $url = $this->generateUrl('dtc_article_attribut_article_modifier', ['id' => $article->getId(), 'tab' => 'valeurAttribut']);
  127.                 }
  129.                 $em->persist($valeurAttributArticle);
  130.                 $em->flush();
  132.                 if (array_key_exists('table', $get) && $get["table"] != "") {
  133.                     return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => $url, 'type' => 'recharger_datatable', 'id_datatable' => $get["table"]],
  134.                                             200,
  135.                                             ['Content-Type' => 'application/json']
  136.                     );
  137.                 } else {
  138.                     $this->addFlash('notice', $translator->trans('Valeur attribut modifiée avec succès !'));
  140.                     return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => $url]);
  141.                 }
  143.             } else {
  144.                 $errors = $validator->validate($valeurAttributArticle);
  145.                 $rendu  = $this->renderView(
  146.                     'Articles/ValeurAttributArticle/ajouter.html.twig',
  147.                     [
  148.                         'form'                  => $form->createView(),
  149.                         'errors'                => $errors,
  150.                         'id'                    => $id,
  151.                         'type'                  => $type,
  152.                         'objet'                 => $objet,
  153.                         'valeurAttributArticle' => $valeurAttributArticle,
  154.                     ]
  155.                 );
  157.                 return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  159.             }
  160.         }
  161.         $rendu = $this->renderView(
  162.             'Articles/ValeurAttributArticle/ajouter.html.twig',
  163.             [
  164.                 'form'                  => $form->createView(),
  165.                 'errors'                => $errors,
  166.                 'id'                    => $id,
  167.                 'type'                  => $type,
  168.                 'objet'                 => $objet,
  169.                 'valeurAttributArticle' => $valeurAttributArticle,
  170.             ]
  171.         );
  173.         return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  174.     }
  176.     /**
  177.      * @Route("/valeur-attribut-article/supprimer/{objet}/{id}/{type}", name="dtc_valeur_attribut_article_supprimer")
  178.      */
  179.     public function supprimerAction(Request $request, ValeurAttributArticle $objet, $id, $type, EntityManagerInterface $em, TranslatorInterface $translator, ValidatorInterface $validator)
  180.     {
  182.         $valeurAttributArticle = $objet;
  183.         $titre_modal           = $translator->trans("Demande de confirmation");
  184.         $user                  = $this->getUser();
  185.         $get                   = $request->query->all();
  186.         $form                  = $this->createForm(SupprimerValeurAttributArticleType::class, $valeurAttributArticle);
  187.         $errors                = "";
  188.         $form->handleRequest($request);
  189.         if ($form->isSubmitted()) {
  191.             if ($form->isValid()) {
  192.                 $em->remove($valeurAttributArticle);
  193.                 $em->flush();
  195.                 if ($type == 'attributArticle') {
  196.                     $url = $this->generateUrl('dtc_article_attribut_article_modifier', ['id' => $id, 'tab' => 'valeurAttribut']);
  197.                 }
  199.                 if (array_key_exists('table', $get) && $get["table"] != "") {
  200.                     return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => $url, 'type' => 'recharger_datatable', 'id_datatable' => $get["table"]],
  201.                                             200,
  202.                                             ['Content-Type' => 'application/json']
  203.                     );
  204.                 } else {
  205.                     $this->addFlash('notice', $translator->trans('Valeur supprimée avec succès !'));
  207.                     return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => $url]);
  209.                 }
  210.             } else {
  212.                 $errors = $validator->validate($valeurAttributArticle);
  213.                 $rendu  = $this->renderView(
  214.                     'FO/Supprimer/supprimer.html.twig',
  215.                     ['form' => $form->createView(), 'errors' => $errors, 'id' => $id, 'type' => $type, 'objet' => $objet]
  216.                 );
  218.                 return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  220.             }
  221.         }
  222.         $rendu = $this->renderView('FO/Supprimer/supprimer.html.twig', ['form' => $form->createView(), 'errors' => $errors, 'id' => $id, 'type' => $type, 'objet' => $objet]);
  224.         return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  225.     }
  228.     /**
  229.      * @Route("/valeur-attribut-article/charger-tableau/{id}/{type}", name="dtc_valeur_attribut_article_charger_tableau")
  230.      */
  231.     public function chargerTableauAction($id = "0", $type = "a"
  232.     ) {
  233.         $rendu = $this->renderView('Articles/ValeurAttributArticle/charger_tableau.html.twig', ["id" => $id, "type" => $type]);
  235.         return new JsonResponse(['rendu' => $rendu]);
  236.     }
  239.     /**
  240.      * @Route("/valeur-attribut-article", name="dtc_valeur_attribut_article_liste")
  241.      */
  242.     public function listerAction(Request $request, $id = "0", $type = "a", EntityManagerInterface $em, Datatable $datatable, TranslatorInterface $translator)
  243.     {
  245.         /*
  246.         $tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id","targets"=>array(0),"visible"=>true);
  247.         $tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id","targets"=>array(1),"visible"=>true);
  248.         $tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id","targets"=>array(2),"visible"=>true);
  249.         $tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id","targets"=>array(3),"visible"=>true);
  250.         $tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id","targets"=>array(4),"visible"=>true);
  251.         $tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id","targets"=>array(5),"visible"=>true);
  252.         $tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id","targets"=>array(6),"visible"=>true);
  253.         $tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id","targets"=>array(7),"visible"=>true);
  254.         $tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id","targets"=>array(8),"visible"=>true);
  255.         $tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id","targets"=>array(9),"visible"=>true);
  256.         $tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id","targets"=>array(10),"visible"=>true);
  257.         $tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id","targets"=>array(11),"visible"=>true);
  258.         $tableau_class_cellule[]=array("orderable"=> false,"searchable"=> false,"className"=>" colonne_id","targets"=>array(12),"visible"=>true);
  259.         */
  261.         $modal     = $request->query->get('modal');
  262.         $articleId = $request->query->get('id');
  263.         $qte       = $request->query->get('qte');
  265.         if ($type == "attributArticle") {
  266.             $repo_objet = $em->getRepository(AttributArticle::class);
  267.         }
  268.         //if($type == "fournisseur")  $repo_objet = $em->getRepository('DTCFournisseursBundle:Fournisseur');
  271.         $objet = $repo_objet->find($id);
  274.         if (is_object($objet)) {
  276.             if ($type == "attributArticle") {
  278.                 $tableau_class_cellule   = [];
  279.                 $tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export colonne_id", "targets" => [0], "visible" => false];
  280.                 $tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export colonne_id", "targets" => [1], "visible" => true];
  281.                 $tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export colonne_id", "targets" => [2], "visible" => true];
  282.                 $tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export colonne_id text-right", "targets" => [3], "visible" => true];
  283.                 $tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export colonne_id text-center", "targets" => [4], "visible" => true];
  284.                 $tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export colonne_id text-center", "targets" => [5], "visible" => true];
  285.                 $tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export colonne_id text-center", "targets" => [6], "visible" => true];
  286.                 $tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export colonne_id text-center", "targets" => [7], "visible" => true];
  288.                 $tableau_class_cellule[] = ["orderable" => false, "searchable" => false, "className" => "colonne_id", "targets" => [8], "visible" => true];
  290.                 $tableau_class_cellule = [];
  291.                 $this->datatableAttributArticle($objet, $type, $datatable, $translator);
  292.             }
  294.             return $this->render('Articles/ValeurAttributArticle/lister.html.twig', ['tableauClassColonne' => $tableau_class_cellule, "id" => $id, "type" => $type]);
  295.         } else {
  296.             $this->datatable();
  298.             return $this->render('Articles/ValeurAttributArticle/lister.html.twig', ['tableauClassColonne' => $tableau_class_cellule, "id" => $id, "type" => $type]);
  299.         }
  300.     }
  303.     /**
  304.      * set datatable configs
  305.      *
  306.      * @return \App\Library\Datatable\Util\Datatable
  307.      */
  308.     private function datatableAttributArticle($objet, $type = "", Datatable $datatable, TranslatorInterface $translator)
  309.     {
  310.         $type_jointure = 'x.'.$type;
  312.         //echo $type_jointure;
  314.         $datatable->setDatatableId('dta-valeur-attribut-article')
  315.                   ->setEntity(ValeurAttributArticle::class, "x")
  316.                   ->setFields(
  317.                       [
  318.                           $translator->trans("Valeur")  => 'x.libelle',
  319.                           $translator->trans("Actions") => 'x.id',
  320.                           "_identifier_"                => 'x.id',
  321.                       ]
  322.                   )
  323.             //->addJoin('x.pays', 'p', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  324.             //->addJoin('f.devise', 'd', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  325.             //->addJoin('x.uniteMesure', 'u', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  326.             /*->setWhere(
  327.                     $type_jointure.' = :objet',
  328.                     array('objet' => $objet)
  329.                )
  330.               */
  331.                   ->setWhere(
  332.                 $type_jointure.' = :objet',
  333.                 ['objet' => $objet]
  334.             )
  335.                   ->setRenderers(
  336.                       [
  338.                           /*
  339.                           3 => array(
  340.                               'view' => 'FO/DataTable/prix.html.twig',
  341.                           ),
  342.                            4 => array(
  343.                               'view' => 'FO/DataTable/date.html.twig',
  344.                           ),
  345.                            5 => array(
  346.                               'view' => 'FO/DataTable/date.html.twig',
  347.                           ),
  348.                            7 => array(
  349.                               'view' => 'FO/DataTable/statut.html.twig',
  350.                               'params' => array(
  351.                                       'edit_route'    => 'dtc_valeurAttributArticle_article_statut'
  352.                                   ),
  353.                           ),
  354.                           */
  355.                           1 => [
  356.                               'view'   => 'FO/DataTable/actions_modal.html.twig',
  357.                               'params' => [
  358.                                   'edit_route'      => 'dtc_valeur_attribut_article_modifier',
  359.                                   'supprimer_route' => 'dtc_valeur_attribut_article_supprimer',
  360.                                   'id'              => $objet->getId(),
  361.                                   'type'            => $type,
  362.                                   'entite'          => 'garantie',
  363.                                   'table'           => 'dta-valeur-attribut-article',
  364.                                   'objet'           => ValeurAttributArticle::class,
  365.                                   'width_modal'     => 800,
  366.                               ],
  367.                           ],
  369.                       ]
  370.                   )
  371.                   ->setOrder("x.id", "desc")
  372.                   ->setSearch(true)//->setSearchFields(array(1,2))
  373.         ;
  375.         return $datatable;
  376.     }
  379.     /**
  380.      * @Route("/valeur-attribut-article/grid/{id}/{type}", name="dtc_valeur_attribut_article_liste_grid")
  381.      */
  382.     public function gridAction($id = "", $type = "", EntityManagerInterface $em, Datatable $datatable, TranslatorInterface $translator)
  383.     {
  384.         $em = $em;
  385.         if ($type == "attributArticle") {
  386.             $repo_objet = $em->getRepository(AttributArticle::class);
  387.         }
  389.         $objet = $repo_objet->find($id);
  391.         if (is_object($objet) and $type == "attributArticle") {
  392.             return $this->datatableAttributArticle($objet, $type, $datatable, $translator)->execute();
  393.         }
  396.     }
  398.     /**
  399.      * @Route("", name="")
  400.      */
  401.     public function changeDefautAction(ValeurAttributArticle $valeurAttributArticle, EntityManagerInterface $em)
  402.     {
  403.         if ($valeurAttributArticle->getDefaut() == 1) {
  404.             $valeurAttributArticle->setDefaut(0);
  405.         } else {
  406.             $valeurAttributArticle->setDefaut(1);
  407.         }
  409.         $em->persist($valeurAttributArticle);
  410.         $em->flush();
  411.         $em->refresh($valeurAttributArticle);
  414.         $headers = [
  415.             'Content-Type'                 => 'application/json',
  416.             'Access-Control-Allow-Origin'  => '*',
  417.             'Access-Control-Allow-Methods' => 'POST',
  418.         ];
  420.         return new JsonResponse(['data' => '1'], 200, $headers);
  422.     }
  425. }