src/Controller/Articles/MouvementStockController.php line 537

Open in your IDE?
  1. <?php
  3. namespace App\Controller\Articles;
  5. use App\Entity\Articles\Article;
  6. use App\Entity\Articles\ArticleComposant;
  7. use App\Entity\Articles\ConditionAchat;
  8. use App\Entity\Articles\MouvementStock;
  9. use App\Entity\GestionComerciale\ArticleCommande;
  10. use App\Entity\GestionComerciale\Reception;
  11. use App\Event\Article\ArticlePumpUpdateEvent;
  12. use App\Form\Articles\MouvementStockType;
  13. use App\Form\Articles\SupprimerMouvementStockType;
  14. use App\Library\Datatable\Util\Datatable;
  15. use App\Service\Articles\ArticleService;
  16. use App\Service\Articles\MouvementStockService;
  17. use App\Service\GestionComerciale\CommandeFournisseurService;
  18. use App\Service\MarketPlace\ArticleMarketPlaceService;
  19. use Doctrine\ORM\EntityManagerInterface;
  20. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  22. use Symfony\Component\HttpFoundation\Request;
  23. use Symfony\Component\HttpFoundation\JsonResponse;
  24. use Symfony\Component\HttpFoundation\Response;
  25. use Symfony\Component\HttpFoundation\StreamedResponse;
  26. use Symfony\Component\Routing\Annotation\Route;
  27. use Symfony\Component\Validator\Validator\ValidatorInterface;
  28. use Symfony\Contracts\EventDispatcher\EventDispatcherInterface;
  29. use Symfony\Contracts\Translation\TranslatorInterface;
  31. class MouvementStockController extends AbstractController
  32. {
  33.     /**
  34.      * @Route("/article/stock/nouveau/{id}", name="dtc_article_stock_ajouter")
  35.      */
  36.     public function ajouterAction(Request               $request, EntityManagerInterface $em, ArticleService $articleService,
  37.                                   MouvementStockService $mvtStockService, ArticleMarketPlaceService $articleMarketPlaceService, TranslatorInterface $translator,
  38.                                   ValidatorInterface    $validator, EventDispatcherInterface $eventDispatcher, Article $article, $modal = ''
  39.     ) {
  41.         //$modal = $request->query->get('modal');
  43.         $user = $this->getUser();
  44.         $ms   = new MouvementStock();
  46.         $ms->setArticle($article);
  47.         $ms->setUtilisateur($user);
  48.         $ms->setPrixAchat(0);
  51.         $dernierMouvement = $em->getRepository(MouvementStock::class)->findOneBy(['article' => $article], ['id' => 'DESC']);
  52.         $dernierMouvementDate = $em->getRepository(MouvementStock::class)->getDernierMouvementDateHeure($article->getId(), $ms->getDateMvt());
  53.         //$prixUnitaire = $dernierMouvementDate["pump"];
  54.         //$stockValorisation = $dernierMouvementDate["stock"];
  56.         $dernierMouvement = $em->getRepository(MouvementStock::class)->find($dernierMouvementDate["id"]);
  59.         $prixRegulation = 0;
  60.         if (is_object($dernierMouvement)) {
  61.             //$ms->setPrixAchat($dernierMouvement->getPrixAchat());
  63.             $prixRegulation = 0;
  65.             if ($dernierMouvement->getCpump() != null && $dernierMouvement->getCpump() != "") {
  66.                 $prixRegulation = $dernierMouvement->getCpump();
  67.             } elseif ($dernierMouvement->getAnnexe() != null && $dernierMouvement->getAnnexe() != "") {
  68.                 $prixRegulation = $dernierMouvement->getAnnexe();
  69.             } else {
  71.                 $repo_condha = $em->getRepository(ConditionAchat::class);
  73.                 $condHa = $repo_condha->findOneBy(["article" => $article, "defaut" => 1]);
  74.                 if (is_object($condHa)) {
  75.                     $devise = null;
  76.                     $prix   = $condHa->getPrixAchatNet();
  77.                     if ($condHa->getCoefficientConditionnement() != 0) {
  78.                         $prix = $prix / $condHa->getCoefficientConditionnement();
  79.                     }
  80.                     $tauxChange  = 1;
  81.                     $fournisseur = $condHa->getFournisseur();
  82.                     if (is_object($fournisseur)) {
  83.                         $devise = $fournisseur->getDevise();
  84.                     }
  85.                     if (is_object($devise) && $devise->getTauxChange() != 0) {
  86.                         $tauxChange = $devise->getTauxChange();
  87.                     }
  88.                     $prix = $prix * $tauxChange;
  90.                     $prixRegulation = $prix;
  92.                 } else {
  93.                     $devise = null;
  94.                     $condHa = $repo_condha->findOneBy(["article" => $article]);
  95.                     if (is_object($condHa)) {
  96.                         $prix = $condHa->getPrixAchatNet();
  97.                         if ($condHa->getCoefficientConditionnement() != 0) {
  98.                             $prix = $prix / $condHa->getCoefficientConditionnement();
  99.                         }
  100.                         $tauxChange  = 1;
  101.                         $fournisseur = $condHa->getFournisseur();
  102.                         if (is_object($fournisseur)) {
  103.                             $devise = $fournisseur->getDevise();
  104.                         }
  105.                         if (is_object($devise) && $devise->getTauxChange() != 0) {
  106.                             $tauxChange = $devise->getTauxChange();
  107.                         }
  108.                         $prix = $prix * $tauxChange;
  110.                         $prixRegulation = $prix;
  112.                     }
  113.                 }
  116.             }
  119.         }
  121.         if ($article->getPump() != "") {
  122.             $prixRegulation = $article->getPump();
  123.         }
  124.         $ms->setPrixAchat($prixRegulation);
  125.         $ms->setPrixSansRemise($prixRegulation);
  126.         $ms->setPrixAchatUnitaireAvecFrais($prixRegulation);
  128.         $form = $this->createForm(MouvementStockType::class, $ms);
  130.         $errors = "";
  131.         $pump2  = $em->getRepository(Article::class)->getPumpR($article->getId());
  132.         //exit;
  133.         if ($pump2 == 0) {
  134.             $pump2 = $articleService->getPrixAchatNetEuro($article->getId());
  135.         }
  137.         $cpump2 = $em->getRepository(Article::class)->getPumpC($article->getId());
  139.         //graphiques
  140.         $variationsStock = $em->getRepository(MouvementStock::class)->getVariationsStockParMois($article->getId(), 12);
  141.         $variationsPump  = $em->getRepository(MouvementStock::class)->getVariationsPumpParMois($article->getId(), 12);
  142.         $variationsCpump = $em->getRepository(MouvementStock::class)->getVariationsCpumpParMois($article->getId(), 12);
  145.         $repoArticleCommande = $em->getRepository(ArticleCommande::class);
  146.         $ralClient           = $repoArticleCommande->getRalClient($article);
  148.         $total_devise = $repoArticleCommande->getDevisArticle($article);
  151.         //reservations de stock
  152.         $repo_article_composant = $em->getRepository(ArticleComposant::class);
  153.         //$composants = $repo_article_composant->findByArticle($article);
  154.         $composants               = $repo_article_composant->getComposantsComposeVirtuel($article)->getQuery()->getResult();
  155.         $reservations             = $repoArticleCommande->getRalClientEtCmdAssociees($article, $composants);
  156.         $reservationsFabrications = $repoArticleCommande->getReservationsFabrications($article, $composants);
  157.         //\Doctrine\Common\Util\Debug::dump($reservations);
  159.         $form->handleRequest($request);
  160.         if ($form->isSubmitted()) {
  161.             if ($form->isValid()) {
  164.                 //echo $user->getEmail();
  165.                 $prixAchatSaisie = $ms->getPrixAchat();
  166.                 $ms->setUtilisateur($user);
  168.                 $mvtStockService->sauvegarder($ms, $article, "regulation");
  170.                 $ms->setPrixAchat($prixAchatSaisie);
  171.                 $ms->setPrixSansRemise($prixAchatSaisie);
  172.                 $em->persist($ms);
  173.                 $em->flush();
  175.                 $this->addFlash('notice', $translator->trans('Mouvement de stock ajouté avec succès !'));
  178.                 $tab_message            = [];
  179.                 $tab_message["message"] = "Suite mouvement de stock manuel (".$ms->getRaisonMouvementStock()->getLibelle()." qte : ".$ms->getQuantite().") sur la fiche article";
  180.                 $message_maj            = $articleMarketPlaceService->majStockAnnonceSuiteRetourBext($article->getId(), $tab_message);
  183.                 if (is_array($message_maj)) {
  184.                     if (array_key_exists('notice', $message_maj) && $message_maj["notice"] != "") {
  185.                         $this->addFlash('notice', $message_maj["notice"]);
  186.                     }
  187.                     if (array_key_exists('warning', $message_maj) && $message_maj["warning"] != "") {
  188.                         $this->addFlash('warning', $message_maj["warning"]);
  189.                     }
  190.                 }
  193.                 if ($ms->getRaisonMouvementStock()->getAction() == "augmenter" && $ms->getQuantite() > 0) {
  194.                     $pumpHorsFrais = $em->getRepository(Article::class)->getPumpHorsFrais($article->getId());
  195.                     if ($pumpHorsFrais == 0) {
  196.                         $pumpHorsFrais = $articleService->getPrixAchatNetEuro($article->getId());
  197.                     }
  199.                     $pump2 = $em->getRepository(Article::class)->getPumpR($article->getId());
  200.                     if ($pump2 == 0) {
  201.                         $pump2 = $articleService->getPrixAchatNetEuro($article->getId());
  202.                     }
  203.                     //$cpump2 = $em->getRepository('DTCArticlesBundle:Article')->getPumpC($article->getId());
  205.                     $ms->setPumpHorsFrais($pumpHorsFrais);
  206.                     $ms->setPump($pump2);
  207.                     $em->persist($ms);
  210.                     $article->setPump($pump2);
  211.                     $article->setPumpHorsFrais($pumpHorsFrais);
  212.                     //$article->setCpump($cpump2);
  213.                     $em->persist($article);
  215.                     $em->flush();
  217.                 }
  218.                 $articlePumpUpdateEvent = new ArticlePumpUpdateEvent($article, null, $ms );
  219.                 $eventDispatcher->dispatch($articlePumpUpdateEvent);
  220.                 //return $this->redirectToRoute('dtc_article_modifier',array('id' => $article->getId(), 'pump2' => $pump2, 'tab' => 'stocks', 'variationsStock' => $variationsStock, 'variationsPump' => $variationsPump));
  221.                 return $this->redirectToRoute('dtc_article_modifier', ['id' => $article->getId(), 'tab' => 'stocks']);
  222.             } else {
  223.                 $errors = $validator->validate($ms);
  225.                 return $this->redirectToRoute(
  226.                     'dtc_article_modifier',
  227.                     [
  228.                         'id'              => $article->getId(),
  229.                         'forms'           => $form,
  230.                         'tab'             => 'stocks',
  231.                         'pump2'           => $pump2,
  232.                         'variationsStock' => $variationsStock,
  233.                         'variationsPump'  => $variationsPump,
  234.                         'variationsCpump' => $variationsCpump,
  235.                     ]
  236.                 );
  237.             }
  238.         }
  240.         return $this->render('Articles/MouvementStock/ajouter.html.twig', [
  241.             'form'                     => $form->createView(),
  242.             'errors'                   => $errors,
  243.             'article'                  => $article,
  244.             'pump2'                    => $pump2,
  245.             'variationsStock'          => $variationsStock,
  246.             'variationsPump'           => $variationsPump,
  247.             'variationsCpump'          => $variationsCpump,
  248.             'ralClient'                => $ralClient,
  249.             'reservations'             => $reservations,
  250.             'reservationsFabrications' => $reservationsFabrications,
  251.             'modal'                    => $modal,
  252.             'total_devise'             => $total_devise,
  253.             'composants'               => $composants,
  254.         ]);
  255.     }
  258.     /**
  259.      * @Route("/mouvement/stock", name="dtc_mouvement_stock_liste")
  260.      */
  261.     public function listerAction(Datatable $datatable, TranslatorInterface $translator)
  262.     {
  263.         $this->datatable($datatable, $translator);
  265.         return $this->render('Articles/MouvementStock/lister.html.twig', []);
  266.     }
  268.     /**
  269.      * set datatable configs
  270.      *
  271.      * @return \App\Library\Datatable\Util\Datatable
  272.      */
  273.     private function datatable(Datatable $datatable, TranslatorInterface $translator)
  274.     {
  275.         $datatable->setEntity(MouvementStock::class, "x")
  276.                   ->setFields(
  277.                       [
  278.                           $translator->trans("ID")       => 'x.id',
  279.                           $translator->trans("Quantité") => 'x.quantite',
  280.                           $translator->trans("Article")  => 'a.libelle',
  281.                           $translator->trans("Raison")   => 'r.libelle',
  282.                           $translator->trans("Date")     => 'x.date',
  283.                           "_identifier_"                 => 'x.id',
  284.                       ]
  285.                   )
  286.                   ->addJoin('x.article', 'a', \Doctrine\ORM\Query\Expr\Join::INNER_JOIN)
  287.                   ->addJoin('x.raisonMouvementStock', 'r', \Doctrine\ORM\Query\Expr\Join::INNER_JOIN)
  288.                   ->setRenderers(
  289.                       [
  290.                           4 => [
  291.                               'view' => 'Articles/MouvementStock/table-date.html.twig',
  293.                           ],
  294.                       ]
  295.                   )
  296.                   ->setOrder("x.id", "desc")
  297.                   ->setSearch(true)
  298.                   ->setSearchFields([5]);
  300.         return $datatable;
  301.     }
  304.     /**
  305.      * Grid action
  306.      * @return Response
  307.      */
  308.     /**
  309.      * @Route("/mouvement/stock/grid", name="dtc_mouvement_stock_liste_grid")
  310.      */
  311.     public function gridAction(Datatable $datatable, TranslatorInterface $translator)
  312.     {
  313.         return $this->datatable($datatable, $translator)->execute();
  314.     }
  316.     /**
  317.      * @Route("", name="")
  318.      */
  319.     public function listerArticleAction(Datatable $datatable, TranslatorInterface $translator, $article, $achat = false): Response
  320.     {
  321.         //$achat = $request->query->get('achat');
  323.         $tableau_class_cellule[] = ["className" => "visible_export colonne_id", "targets" => [0], "visible" => false, "orderable" => true];
  324.         $tableau_class_cellule[] = ["className" => "visible_export text-center colonne_id", "targets" => [1], "visible" => true, "orderable" => true];
  325.         $tableau_class_cellule[] = ["className" => "visible_export text-center colonne_id", "targets" => [2], "visible" => true, "orderable" => true];
  326.         $tableau_class_cellule[] = ["className" => "visible_export text-center colonne_id", "targets" => [3], "visible" => true, "orderable" => true];
  327.         $tableau_class_cellule[] = ["className" => "visible_export text-right colonne_id", "targets" => [4], "visible" => true, "orderable" => true];
  328.         $tableau_class_cellule[] = ["className" => "visible_export text-right colonne_id", "targets" => [5], "visible" => true, "orderable" => true];
  329.         $tableau_class_cellule[] = ["className" => "visible_export text-right colonne_id", "targets" => [6], "visible" => true, "orderable" => true];
  330.         $tableau_class_cellule[] = ["className" => "visible_export colonne_id", "targets" => [7], "visible" => true, "orderable" => true];
  331.         $tableau_class_cellule[] = ["className" => "visible_export colonne_id", "targets" => [8], "visible" => true, "orderable" => true];
  332.         $tableau_class_cellule[] = ["className" => "visible_export colonne_id", "targets" => [9], "visible" => true, "orderable" => true];
  333.         $tableau_class_cellule[] = ["className" => "visible_export colonne_id", "targets" => [10], "visible" => true, "orderable" => true];
  334.         $tableau_class_cellule[] = ["className" => "visible_export colonne_id", "targets" => [11], "visible" => true, "orderable" => true];
  335.         $tableau_class_cellule[] = ["className" => "visible_export text-center colonne_id", "targets" => [12], "visible" => true, "orderable" => true];
  336.         $tableau_class_cellule[] = ["className" => "visible_export colonne_id", "targets" => [13], "visible" => true, "orderable" => true];
  337.         //$tableau_class_cellule[]=array("className"=>"visible_export colonne_id","targets"=>array(14),"visible"=>true,"orderable"=>true);
  339.         $this->datatableArticle($article, $achat, $datatable, $translator);
  341.         return $this->render('Articles/MouvementStock/listerArticle.html.twig', ['article' => $article, 'achat' => $achat, 'tableauClassColonne' => $tableau_class_cellule]);
  342.     }
  344.     /**
  345.      * set datatable configs
  346.      *
  347.      * @return \App\Library\Datatable\Util\Datatable
  348.      */
  349.     private function datatableArticle($article, $achat = false, Datatable $datatable, TranslatorInterface $translator)
  350.     {
  352.         $datatable->setEntity(MouvementStock::class, "x")
  353.                   ->setFields(
  354.                       [
  355.                           $translator->trans("ID")               => 'x.id',
  356.                           $translator->trans("Date")             => 'x.dateMvt',
  357.                           $translator->trans("Qté&nbsp;E&nbsp;") => 'x.quantite',
  358.                           $translator->trans("Qté&nbsp;S")       => 'x.quantite',
  359.                           $translator->trans("Prix")             => 'x.prixAchat',
  360.                           $translator->trans("Pump")             => 'x.pump',
  361.                           $translator->trans("Cump")             => 'x.cpump',
  362.                           $translator->trans("Annexe")           => 'x.annexe',
  363.                           $translator->trans("Raison")           => 'r.libelle',
  364.                           $translator->trans("Client")           => 'cl.nom',
  366.                           $translator->trans("Doc") => 'c.reference',
  368.                           $translator->trans("Fournisseur") => 'f.libelle',
  369.                           $translator->trans("BL fourn.")   => 'x.bonLivraison',
  370.                           $translator->trans("Commentaire") => 'x.commentaire',
  371.                           $translator->trans("Stock")       => 'x.stock',
  373.                           $translator->trans("Recept")   => 'rcp.reference',
  374.                           $translator->trans("Equipier") => 'x.id',
  375.                           $translator->trans("Empl.")    => 'e.id',
  376.                           "_identifier_"                 => 'x.id',
  377.                       ]
  378.                   )
  379.                   ->addJoin('x.article', 'a', \Doctrine\ORM\Query\Expr\Join::INNER_JOIN)
  380.                   ->addJoin('x.commande', 'c', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  381.                   ->addJoin('x.commandeVirtuel', 'cv', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  382.                   ->addJoin('c.client', 'cl', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  383.                   ->addJoin('c.utilisateur', 'u', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  384.                   ->addJoin('x.commandeFournisseur', 'cf', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  385.                   ->addJoin('x.reception', 'rcp', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  386.                   ->addJoin('x.raisonMouvementStock', 'r', \Doctrine\ORM\Query\Expr\Join::INNER_JOIN)
  387.                   ->addJoin('x.fournisseur', 'f', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  388.                   ->addJoin('x.emplacement', 'e', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  389.                   ->setRenderers(
  390.                       [
  391.                           1 => [
  392.                               'view' => 'Articles/MouvementStock/table-date.html.twig',
  394.                           ],
  395.                           2 => [
  396.                               'view'   => 'FO/DataTable/qte.html.twig',
  397.                               'params' => ['entrant' => 'true'],
  398.                           ],
  399.                           3 => [
  400.                               'view'   => 'FO/DataTable/qte.html.twig',
  401.                               'params' => ['sortant' => 'true'],
  402.                           ],
  403.                           4 => [
  404.                               'view'   => 'FO/DataTable/prix.html.twig',
  405.                               'params' => ['forceEuro' => 1],
  406.                           ],
  407.                           5 => [
  408.                               'view'   => 'FO/DataTable/prix.html.twig',
  409.                               'params' => ['forceEuro' => '1'],
  410.                           ],
  411.                           6 => [
  412.                               'view'   => 'FO/DataTable/prix.html.twig',
  413.                               'params' => ['forceEuro' => '1'],
  414.                           ],
  416.                           9 => [
  417.                               'view' => 'FO/DataTable/clientMS.html.twig',
  418.                           ],
  420.                           10 => [
  421.                               'view'   => 'FO/DataTable/commande.html.twig',
  422.                               'params' => [
  423.                                   'route'       => 'dtc_commande_fournisseur_modifier',
  424.                                   'edit_route'  => 'dtc_bon_livraison_modifier',
  425.                                   'edit_route1' => 'dtc_facture_afficher',
  426.                                   'edit_route2' => 'dtc_avoir_modifier',
  429.                               ],
  431.                           ],
  433.                           11 => [
  434.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  435.                               'params' => [
  436.                                   'edit_route'   => 'dtc_commande_fournisseur_modifier',
  437.                                   'typeDocument' => 'fournisseur',
  438.                               ],
  439.                           ],
  440.                           13 => [
  441.                               'view' => 'FO/DataTable/virtuel-parent-commentaire.html.twig',
  442.                           ],
  444.                           15 => [
  445.                               'view'   => 'FO/DataTable/commande.html.twig',
  446.                               'params' => [
  447.                                   'type'        => 'reception',
  448.                                   'route'       => 'dtc_commande_fournisseur_modifier',
  449.                                   'edit_route'  => 'dtc_bon_livraison_modifier',
  450.                                   'edit_route1' => 'dtc_facture_afficher',
  451.                                   'edit_route2' => 'dtc_avoir_modifier',
  454.                               ],
  455.                           ],
  456.                           16 => [
  457.                               'view' => 'FO/DataTable/utilisateur.html.twig',
  458.                           ],
  460.                           17 => [
  461.                               'view' => 'FO/DataTable/nom_emplacement.html.twig',
  462.                           ],
  463.                       ]
  464.                   )
  465.                   ->setOrder("x.dateMvt", "desc")
  466.             //->setOrder("x.dateMvt", "desc")
  467.             //->setOrder("x.stock", "desc")
  469.         ;
  470.         if ($achat === false) {
  471.             $datatable->setWhere(                                                     // set your dql where statement
  472.                 'a.id = :article',
  473.                 ['article' => $article]
  474.             );
  475.         } else {
  476.             $datatable->setWhere(
  477.                 'a.id = :article and x.raisonMouvementStock = 3',
  478.                 ['article' => $article]
  479.             );
  480.         }
  481.         $datatable->setSearch(true)
  482.                   ->setSearchFields([8, 9, 10, 11, 13, 14, 15, 16]);
  484.         return $datatable;
  485.     }
  488.     /**
  489.      * @Route("/mouvement/stock/grid/article/{article}", name="dtc_mouvement_stock_liste_article_grid")
  490.      */
  491.     public function gridArticleAction(Request $request, $article, Datatable $datatable, TranslatorInterface $translator)
  492.     {
  493.         $achat = $request->query->get('achat');
  494.         if ($achat == true) {
  495.             return $this->datatableArticle($article, $achat, $datatable, $translator)->execute();
  496.         } else {
  497.             return $this->datatableArticle($article, false, $datatable, $translator)->execute();
  498.         }
  499.         //\Doctrine\Common\Util\Debug::dump($achat);
  500.     }
  503.     /**
  504.      * @Route("", name="")
  505.      */
  506.     public function listerArticleStockAction(Datatable $datatable, TranslatorInterface $translator, $article, $achat = false)
  507.     {
  508.         $tableau_class_cellule[] = ["searchable" => false, "className" => "visible_export colonne_id", "targets" => [0], "visible" => false, "orderable" => false];
  509.         $tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export w100", "targets" => [1], "visible" => true, "orderable" => true];
  510.         $tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export w100", "targets" => [2], "visible" => true, "orderable" => true];
  511.         $tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export w100 text-right", "targets" => [3], "visible" => true, "orderable" => true];
  512.         $tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export w200 text-right", "targets" => [4], "visible" => true, "orderable" => true];
  513.         $tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export w200 text-right", "targets" => [5], "visible" => true, "orderable" => true];
  514.         $tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export w400 text-right", "targets" => [6], "visible" => true, "orderable" => true];
  515.         $tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export w400 text-right", "targets" => [7], "visible" => true, "orderable" => true];
  516.         $tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export w300", "targets" => [8], "visible" => true, "orderable" => true];
  517.         $tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export w500", "targets" => [9], "visible" => false, "orderable" => true];
  518.         $tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export w200", "targets" => [10], "visible" => true, "orderable" => true];
  519.         $tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export w200", "targets" => [11], "visible" => true, "orderable" => true];
  520.         $tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export w200", "targets" => [12], "visible" => true, "orderable" => true];
  521.         $tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export text-center w200", "targets" => [13], "visible" => true, "orderable" => true];
  522.         $tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export w200", "targets" => [14], "visible" => true, "orderable" => true];
  523.         $tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export w200 text-center", "targets" => [15], "visible" => true, "orderable" => true];
  524.         $tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export w200", "targets" => [16], "visible" => true, "orderable" => true];
  527.         $this->datatableArticleStock($article, $achat, $datatable, $translator);
  529.         return $this->render('Articles/MouvementStock/listerArticle2.html.twig', ['article' => $article, 'achat' => $achat, 'tableauClassColonne' => $tableau_class_cellule,]);
  530.     }
  532.     /**
  533.      * set datatable configs
  534.      *
  535.      * @return \App\Library\Datatable\Util\Datatable
  536.      */
  537.     private function datatableArticleStock($article, $achat = false, Datatable $datatable, TranslatorInterface $translator)
  538.     {
  540.         $datatable->setEntity(MouvementStock::class, "x")
  541.                   ->setFields(
  542.                       [
  543.                           $translator->trans("ID")    => 'x.id',
  544.                           $translator->trans("Date")  => 'x.dateMvt',
  545.                           $translator->trans("Qté E") => 'x.quantite',
  546.                           $translator->trans("Qté S") => 'x.quantite',
  547.                           $translator->trans("Prix")  => 'x.prixAchat',
  548.                           $translator->trans("Stock") => 'x.stock',
  550.                           $translator->trans("Pump hors frais") => 'x.pumpHorsFrais',
  551.                           $translator->trans("Prix avec frais") => 'x.prixAchatUnitaireAvecFrais',
  552.                           $translator->trans("Pump")            => 'x.pump',
  553.                           $translator->trans("Annexe")          => 'x.annexe',
  554.                           $translator->trans("Raison")          => 'r.libelle',
  555.                           $translator->trans("Client")          => 'cl.nom',
  556.                           $translator->trans("Doc")             => 'c.reference',
  557.                           $translator->trans("Fournisseur")     => 'f.libelle',
  558.                           $translator->trans("BL Fourn.")       => 'x.bonLivraison',
  559.                           $translator->trans("Comm")            => 'x.commentaire',
  560.                           //$translator->trans("Stock") =>  'x.stock',
  562.                           $translator->trans("Recept")   => 'rcp.reference',
  563.                           $translator->trans("Equipier") => 'x.id',
  564.                           $translator->trans("Empl")     => 'e.id',
  565.                           "_identifier_"                 => 'x.id',
  566.                       ]
  567.                   )
  568.                   ->addJoin('x.article', 'a', \Doctrine\ORM\Query\Expr\Join::INNER_JOIN)
  569.                   ->addJoin('x.commande', 'c', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  570.                   ->addJoin('c.client', 'cl', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  571.                   ->addJoin('x.commandeFournisseur', 'cf', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  572.                   ->addJoin('x.reception', 'rcp', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  573.                   ->addJoin('c.utilisateur', 'u', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  574.                   ->addJoin('x.raisonMouvementStock', 'r', \Doctrine\ORM\Query\Expr\Join::INNER_JOIN)
  575.                   ->addJoin('x.fournisseur', 'f', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  576.                   ->addJoin('x.emplacement', 'e', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  577.                   ->setRenderers(
  578.                       [
  579.                           1  => [
  580.                               'view' => 'Articles/MouvementStock/table-date.html.twig',
  582.                           ],
  583.                           2  => [
  584.                               'view'   => 'FO/DataTable/qte.html.twig',
  585.                               'params' => ['entrant' => 'true'],
  586.                           ],
  587.                           3  => [
  588.                               'view'   => 'FO/DataTable/qte.html.twig',
  589.                               'params' => ['sortant' => 'true'],
  590.                           ],
  591.                           4  => [
  592.                               'view'   => 'FO/DataTable/prix.html.twig',
  593.                               'params' => ['forceEuro' => '1'],
  594.                           ],
  595.                           6  => [
  596.                               'view'   => 'FO/DataTable/prix.html.twig',
  597.                               'params' => ['forceEuro' => '1'],
  598.                           ],
  599.                           7  => [
  600.                               'view'   => 'FO/DataTable/prix.html.twig',
  601.                               'params' => ['forceEuro' => '1'],
  602.                           ],
  603.                           8  => [
  604.                               'view'   => 'FO/DataTable/prix.html.twig',
  605.                               'params' => ['forceEuro' => '1'],
  606.                           ],
  607.                           10 => [
  608.                               'view' => 'FO/DataTable/supprimer_espace.html.twig',
  609.                           ],
  611.                           11 => [
  612.                               'view' => 'FO/DataTable/clientMS.html.twig',
  613.                           ],
  615.                           12 => [
  616.                               'view'   => 'FO/DataTable/commande.html.twig',
  617.                               'params' => [
  618.                                   'route'       => 'dtc_commande_fournisseur_modifier',
  619.                                   'edit_route'  => 'dtc_bon_livraison_modifier',
  620.                                   'edit_route1' => 'dtc_facture_afficher',
  621.                                   'edit_route2' => 'dtc_avoir_modifier',
  624.                               ],
  626.                           ],
  629.                           13 => [
  630.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  631.                               'params' => [
  632.                                   'edit_route'   => 'dtc_fournisseur_modifier',
  633.                                   'typeDocument' => 'fournisseur',
  634.                               ],
  635.                           ],
  636.                           15 => [
  637.                               'view' => 'FO/DataTable/virtuel-parent-commentaire.html.twig',
  638.                           ],
  641.                           16 => [
  642.                               'view'   => 'FO/DataTable/commande.html.twig',
  643.                               'params' => [
  644.                                   'type'        => 'reception',
  645.                                   'route'       => 'dtc_commande_fournisseur_modifier',
  646.                                   'edit_route'  => 'dtc_bon_livraison_modifier',
  647.                                   'edit_route1' => 'dtc_facture_afficher',
  648.                                   'edit_route2' => 'dtc_avoir_modifier',
  651.                               ],
  652.                           ],
  653.                           17 => [
  654.                               'view' => 'FO/DataTable/utilisateur.html.twig',
  655.                           ],
  657.                           18 => [
  658.                               'view' => 'FO/DataTable/nom_emplacement.html.twig',
  659.                           ],
  660.                       ]
  661.                   )
  662.             //->setOrder("x.dateMvt", "desc")
  663.                   ->setOrder("x.dateMvt desc,x.id", "desc");
  664.         if ($achat === false) {
  665.             $datatable->setWhere(                                                     // set your dql where statement
  666.                 'a.id = :article AND x.dateSuppression IS NULL',
  667.                 ['article' => $article]
  668.             );
  669.         } else {
  670.             $datatable->setWhere(
  671.                 'a.id = :article and x.raisonMouvementStock = 3 AND x.dateSuppression IS NULL',
  672.                 ['article' => $article]
  673.             );
  674.         }
  676.         $datatable->setSearch(true)
  677.                   ->setSearchFields([6]);
  679.         return $datatable;
  680.     }
  683.     /**
  684.      * @Route("/mouvement/stock/grid/article_stock/{article}", name="dtc_mouvement_stock_liste_article_stock_grid")
  685.      */
  686.     public function gridArticleStockAction(Request $request, $article, Datatable $datatable, TranslatorInterface $translator)
  687.     {
  688.         $achat = $request->query->get('achat');
  689.         if ($achat == true) {
  690.             return $this->datatableArticleStock($article, $achat, $datatable, $translator)->execute();
  691.         } else {
  692.             return $this->datatableArticleStock($article, false, $datatable, $translator)->execute();
  693.         }
  694.     }
  696.     /**
  697.      * @Route("", name="")
  698.      */
  699.     public function listerByCommandeAction($commande, Datatable $datatable, TranslatorInterface $translator)
  700.     {
  701.         //$achat = $request->query->get('achat');
  702.         $this->datatableCommande($commande, $datatable, $translator);
  704.         return $this->render('Articles/MouvementStock/lister-by-commande.html.twig', ['commande' => $commande]);
  705.     }
  707.     /**
  708.      * set datatable configs
  709.      *
  710.      * @return \App\Library\Datatable\Util\Datatable
  711.      */
  712.     private function datatableCommande($commande, Datatable $datatable, TranslatorInterface $translator)
  713.     {
  715.         $datatable->setEntity(MouvementStock::class, "x")
  716.                   ->setFields(
  717.                       [
  718.                           //$translator->trans("ID") =>  'x.id',
  719.                           $translator->trans("Date")           => 'x.date',
  720.                           $translator->trans("Libelle")        => 'a.libelle',
  721.                           $translator->trans("Qté")            => 'x.quantite',
  722.                           $translator->trans("Prix d'achat")   => 'x.prixAchat',
  723.                           $translator->trans("Pump")           => 'x.pump',
  724.                           $translator->trans("BL Fournisseur") => "x.bonLivraison",
  725.                           $translator->trans("Commentaire")    => 'x.commentaire',
  726.                           $translator->trans("Actions")        => "x.id",
  728.                           "_identifier_" => 'x.id',
  729.                       ]
  730.                   )
  731.                   ->addJoin('x.article', 'a', \Doctrine\ORM\Query\Expr\Join::INNER_JOIN)
  732.                   ->addJoin('x.commandeFournisseur', 'c', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  733.                   ->addJoin('x.raisonMouvementStock', 'r', \Doctrine\ORM\Query\Expr\Join::INNER_JOIN)
  734.                   ->addJoin('x.fournisseur', 'f', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  735.                   ->setRenderers(
  736.                       [
  737.                           0 => [
  738.                               'view' => 'Articles/MouvementStock/table-date.html.twig',
  739.                           ],
  740.                           3 => [
  741.                               'view'   => 'FO/DataTable/prix.html.twig',
  742.                               'params' => ['forceEuro' => '1'],
  743.                           ],
  744.                           4 => [
  745.                               'view'   => 'FO/DataTable/prix.html.twig',
  746.                               'params' => ['forceEuro' => '1'],
  747.                           ],
  748.                           7 => [
  749.                               'view'   => 'FO/DataTable/actions.html.twig',
  750.                               'params' => [
  751.                                   //'edit_route'    => 'dtc_commande_fournisseur_modifier',
  752.                                   'supprimer_route' => 'dtc_mouvement_stock_supprimer',
  753.                                   'objet'           => MouvementStock::class,
  754.                               ],
  755.                           ],
  756.                       ]
  757.                   )
  758.                   ->setWhere(                                                     // set your dql where statement
  759.                       'c.id = :commande',
  760.                       ['commande' => $commande]
  761.                   )
  762.                   ->setOrder("x.id", "desc")
  763.                   ->setSearch(true)
  764.                   ->setSearchFields([5]);
  766.         return $datatable;
  767.     }
  769.     /**
  770.      * @Route("/mouvement/stock/grid/commande/{commande}", name="dtc_mouvement_stock_liste_by_commande_grid")
  771.      */
  772.     public function gridCommandeAction($commande, Datatable $datatable, TranslatorInterface $translator)
  773.     {
  774.         return $this->datatableCommande($commande, $datatable, $translator)->execute();
  775.         //\Doctrine\Common\Util\Debug::dump($achat);
  776.     }
  778.     /**
  779.      * @Route("", name="")
  780.      */
  781.     public function listerByFabricationAction(Request $request, $fabrication, $compose, Datatable $datatable, TranslatorInterface $translator)
  782.     {
  784.         //$compose = $request->query->get('compose');
  785.         $this->datatableFabrication($fabrication, $compose, $datatable, $translator);
  787.         return $this->render('Articles/MouvementStock/lister-by-fabrication.html.twig', ['fabrication' => $fabrication, 'compose' => $compose]);
  788.     }
  790.     /**
  791.      * set datatable configs
  792.      *
  793.      * @return \App\Library\Datatable\Util\Datatable
  794.      */
  795.     private function datatableFabrication($fabrication, $compose = false, Datatable $datatable, TranslatorInterface $translator)
  796.     {
  798.         $datatable->setEntity(MouvementStock::class, "x")
  799.                   ->setFields(
  800.                       [
  801.                           $translator->trans("ID")      => 'x.id',
  802.                           $translator->trans("Date")    => 'x.date',
  803.                           $translator->trans("Libelle") => 'a.libelle',
  804.                           //$translator->trans("Qté") =>  'x.quantite',
  805.                           $translator->trans("Qté E")   => 'x.quantite',
  806.                           $translator->trans("Qté S")   => 'x.quantite',
  808.                           $translator->trans("Prix d'achat") => 'x.prixAchat',
  809.                           $translator->trans("Pump")         => 'x.pump',
  810.                           //$translator->trans("Raison") =>  'r.libelle',
  811.                           //$translator->trans("Fournisseur") =>  'f.reference',
  812.                           $translator->trans("Commentaire")  => 'x.commentaire',
  813.                           //$translator->trans("Actions") =>  'x.id',
  814.                           "_identifier_"                     => 'x.id',
  815.                       ]
  816.                   )
  817.                   ->addJoin('x.article', 'a', \Doctrine\ORM\Query\Expr\Join::INNER_JOIN)
  818.                   ->addJoin('x.fabrication', 'c', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  819.                   ->addJoin('x.raisonMouvementStock', 'r', \Doctrine\ORM\Query\Expr\Join::INNER_JOIN)
  820.                   ->addJoin('x.fournisseur', 'f', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  821.                   ->setRenderers(
  822.                       [
  823.                           1 => [
  824.                               'view' => 'Articles/MouvementStock/table-date.html.twig',
  825.                           ],
  826.                           3 => [
  827.                               'view'   => 'FO/DataTable/qte.html.twig',
  828.                               'params' => ['entrant' => 'true'],
  829.                           ],
  830.                           4 => [
  831.                               'view'   => 'FO/DataTable/qte.html.twig',
  832.                               'params' => ['sortant' => 'true'],
  833.                           ],
  835.                           5 => [
  836.                               'view'   => 'FO/DataTable/prix.html.twig',
  837.                               'params' => [
  838.                                   'forceEuro'      => '1',
  839.                                   'afficher_total' => false,
  840.                               ],
  841.                           ],
  842.                           6 => [
  843.                               'view'   => 'FO/DataTable/prix.html.twig',
  844.                               'params' => [
  845.                                   'forceEuro'      => '1',
  846.                                   'afficher_total' => false,
  847.                               ],
  848.                           ],
  849.                           /*
  850.                           8 => array(
  851.                               'view' => 'FO/DataTable/actions.html.twig',
  852.                               'params' => array(
  853.                                       'edit_route_modal'    => 'dtc_mouvement_stock_modifier',
  854.                                       'objet'    => 'DTCGestionComercialeBundle:Reception',
  855.                                       //'deplierReception'    => true,
  857.                                   ),
  858.                           ),
  859.                            *
  860.                            */
  861.                       ]
  862.                   );
  863.         if ($compose == 'true') {
  864.             $where = "c.id = :fabrication AND r.action LIKE 'augmenter'";
  865.         } else {
  866.             $where = 'c.id = :fabrication';
  867.         }
  868.         $datatable->setWhere(                                                     // set your dql where statement
  869.             $where,
  870.             ['fabrication' => $fabrication]
  871.         )
  872.                   ->setOrder("x.id", "desc")
  873.                   ->setSearch(true)
  874.                   ->setSearchFields([5]);
  876.         return $datatable;
  877.     }
  879.     /**
  880.      * Grid action
  881.      * @return Response
  882.      */
  883.     /**
  884.      * @Route("/mouvement/stock/grid/fabrication/{fabrication}", name="dtc_mouvement_stock_liste_by_fabrication_grid")
  885.      */
  886.     public function gridFabricationAction(Request $request, $fabrication, Datatable $datatable, TranslatorInterface $translator)
  887.     {
  888.         $compose = $request->query->get('compose');
  890.         return $this->datatableFabrication($fabrication, $compose, $datatable, $translator)->execute();
  891.         //\Doctrine\Common\Util\Debug::dump($achat);
  892.     }
  894.     /**
  895.      * @Route("/mouvement/stock/{id}/supprimer", name="dtc_mouvement_stock_supprimer")
  896.      */
  897.     public function supprimerAction(Request                    $request, MouvementStock $ms, EntityManagerInterface $em, MouvementStockService $mvtStockService,
  898.                                     CommandeFournisseurService $commandeFournisseurService, TranslatorInterface $translator, ValidatorInterface $validator
  899.     ) {
  901.         $titre_modal          = $translator->trans("Demande de confirmation");
  902.         $user                 = $this->getUser();
  903.         $commandeFounisseurId = $ms->getCommandeFournisseur()->getId();
  905.         //$ms->setCommentaire($ms->getCommentaire()." Annulation réception sur la commande fournisseur ".$ms->getCommandeFournisseur()->getReference()." par ".$user->getPrenom()." ".$user->getNom());
  906.         $ms->setCommentaire("Sans commentaire");
  908.         $form   = $this->createForm(SupprimerMouvementStockType::class, $ms);
  909.         $errors = "";
  910.         $form->handleRequest($request);
  912.         if ($form->isSubmitted()) {
  913.             if ($form->isValid()) {
  914.                 $commandeFounisseur = $ms->getCommandeFournisseur();
  915.                 $mvtStockService->supprimer($ms);
  917.                 $ms->getArticle()->setRalFournisseur($ms->getArticle()->getRalFournisseur() + $ms->getQuantite());
  919.                 $commandeFournisseurService->changementStatut($commandeFounisseur);
  922.                 $em->persist($ms->getArticle());
  923.                 $em->flush();
  924.                 //$em->remove($ms);
  925.                 //$em->flush();
  927.                 $this->addFlash(
  928.                     'notice',
  929.                     $translator->trans('Mouvement de stock supprimé avec succès !')
  930.                 );
  931.                 $url = $this->generateUrl('dtc_commande_fournisseur_modifier', ['id' => $commandeFounisseurId]);
  933.                 return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => $url]);
  934.             } else {
  935.                 $errors = $validator->validate($ms);
  936.                 $rendu  = $this->renderView('FO/Supprimer/supprimer.html.twig', ['form' => $form->createView(), 'errors' => $errors, 'id' => $ms->getId(), 'type' => '']);
  938.                 return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  939.             }
  940.         }
  941.         $rendu = $this->renderView('FO/Supprimer/supprimer.html.twig', ['form' => $form->createView(), 'id' => $ms->getId(), 'type' => '', 'errors' => $errors]);
  943.         return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  944.     }
  946.     /**
  947.      * @Route("/receptions", name="dtc_receptions_liste")
  948.      */
  949.     public function listerAfacturerAction(Datatable $datatable, TranslatorInterface $translator)
  950.     {
  951.         $this->datatableAfacturer($datatable, $translator);
  953.         return $this->render('Articles/MouvementStock/lister-a-facturer.html.twig', []);
  954.     }
  956.     /**
  957.      * set datatable configs
  958.      *
  959.      * @return \App\Library\Datatable\Util\Datatable
  960.      */
  961.     private function datatableAfacturer(Datatable $datatable, TranslatorInterface $translator)
  962.     {
  963.         $datatable->setEntity(MouvementStock::class, "x")
  964.                   ->setFields(
  965.                       [
  966.                           //$translator->trans("ID") =>  'x.id',
  967.                           $translator->trans("Date")               => 'x.date',
  968.                           $translator->trans("Réf fourn.")         => 'x.referenceFournisseur',
  969.                           $translator->trans("Quantité")           => 'x.quantite',
  970.                           'Prix'                                   => 'x.prixAchat',
  971.                           $translator->trans("Bon de livraison")   => 'x.bonLivraison',
  972.                           $translator->trans("N° commande fourn.") => 'cf.reference',
  973.                           $translator->trans("Libelle")            => 'x.libelle',
  974.                           $translator->trans("Fournisseur")        => 'fo.libelle',
  975.                           "_identifier_"                           => 'x.id',
  976.                       ]
  977.                   )
  978.                   ->addJoin('x.article', 'a', \Doctrine\ORM\Query\Expr\Join::INNER_JOIN)
  979.                   ->addJoin('x.raisonMouvementStock', 'r', \Doctrine\ORM\Query\Expr\Join::INNER_JOIN)
  980.                   ->addJoin('x.factureFournisseur', 'f', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  981.                   ->addJoin('x.fournisseur', 'fo', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  982.                   ->addJoin('x.commandeFournisseur', 'cf', \Doctrine\ORM\Query\Expr\Join::INNER_JOIN)
  983.                   ->setRenderers(
  984.                       [
  985.                           0 => [
  986.                               'view' => 'Articles/MouvementStock/table-date.html.twig',
  988.                           ],
  989.                           5 => [
  990.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  991.                               'params' => [
  992.                                   'edit_route'   => 'dtc_commande_fournisseur_modifier',
  993.                                   'typeDocument' => 'commandeFournisseur',
  994.                               ],
  995.                           ],
  996.                           7 => [
  997.                               'view' => 'FO/DataTable/facturation-fournisseur.html.twig',
  999.                           ],
  1000.                       ]
  1001.                   )
  1002.                   ->setOrder("x.bonLivraison", "asc")
  1003.                   ->setSearch(true)
  1004.                   ->setSearchFields([0, 1, 2, 3, 4, 5, 6, 7])
  1005.                   ->setWhere('r.id = :raison AND f.id is null', ['raison' => 3])//Achat
  1006.                   ->setMultiple(
  1007.                 [
  1008.                     'facturer' => [
  1009.                         'title' => 'Facturer',
  1010.                         'route' => 'dtc_facturer_fournisseur' // path to multiple delete route
  1011.                     ],
  1012.                 ]
  1013.             );
  1015.         return $datatable;
  1016.     }
  1019.     /**
  1020.      * @Route("/receptions/grid", name="dtc_receptions_liste_grid")
  1021.      */
  1022.     public function gridAfacturerAction(Datatable $datatable, TranslatorInterface $translator)
  1023.     {
  1024.         return $this->datatableAfacturer($datatable, $translator)->execute();
  1025.     }
  1027.     /**
  1028.      * @Route("/mouvement/stock/nombre/inventaire/{id}", name="dtc_ajax_nb_mvts_stock_inventaire")
  1029.      */
  1030.     public function nbMouvementsStockInventaireAction($id, EntityManagerInterface $em)
  1031.     {
  1032.         $mouvementsStockInventaire   = $em->getRepository(MouvementStock::class)->findBy([
  1033.                                                                                              'inventaire' => $id,
  1034.                                                                                          ]);
  1035.         $nbMouvementsStockInventaire = count($mouvementsStockInventaire);
  1036.         $response                    = new JsonResponse();
  1037.         $response->setData(['nombre' => $nbMouvementsStockInventaire]);
  1039.         return $response;
  1040.     }
  1042.     /**
  1043.      * @Route("/mouvement/modifier/{id}", name="dtc_mouvement_stock_modifier")
  1044.      */
  1045.     public function modifierAction(Request $request, Reception $reception, EntityManagerInterface $em, CommandeFournisseurService $commandeFournisseurService, TranslatorInterface $translator)
  1046.     {
  1047.         $titre_modal = $translator->trans("Modifier un mouvement de stock");
  1048.         $user        = $this->getUser();
  1051.         if ($request->isMethod('POST')) {
  1053.             $valeurs         = $request->request->all();
  1054.             $commandeFournisseurService->modifierReception($reception, $valeurs);
  1056.             $this->addFlash('notice', $translator->trans('Mouvements de stock modifié avec succès !'));
  1058.             $url = $this->generateUrl('dtc_commande_fournisseur_modifier', ["id" => $reception->getCommandeFournisseur()->getId(), "tab" => "receptions"]);
  1060.             return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => $url]);
  1062.         }
  1064.         $rendu = $this->renderView('Articles/MouvementStock/modifier_modal.html.twig', ["reception" => $reception]);
  1066.         return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  1067.     }
  1069. }