src/Controller/Articles/ConditionVenteController.php line 521

Open in your IDE?
  1. <?php
  3. namespace App\Controller\Articles;
  5. use App\Entity\Articles\Article;
  6. use App\Entity\Articles\ArticleCategorie;
  7. use App\Entity\Articles\ArticleComposant;
  8. use App\Entity\Articles\Categorie;
  9. use App\Entity\Articles\ConditionVente;
  10. use App\Entity\Fournisseurs\Fournisseur;
  11. use App\Form\Articles\ConditionVenteType;
  12. use App\Form\Articles\SupprimerConditionVenteType;
  13. use App\Library\Datatable\Util\Datatable;
  14. use App\Security\Voter\EntityVoter;
  15. use Doctrine\ORM\EntityManagerInterface;
  16. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  17. use Symfony\Component\HttpFoundation\Request;
  18. use Symfony\Component\HttpFoundation\JsonResponse;
  19. use Symfony\Component\HttpFoundation\Response;
  20. use Symfony\Component\Routing\Annotation\Route;
  21. use Symfony\Component\Validator\Validator\ValidatorInterface;
  22. use Symfony\Contracts\Translation\TranslatorInterface;
  24. class ConditionVenteController extends AbstractController
  25. {
  28.     /**
  29.      * @Route("", name="")
  30.      */
  31.     public function getPrixArticleConditionVenteAction(Fournisseur $fournisseur, Article $article)
  32.     {
  33.         $prix = "";
  34.         foreach ($article->getConditionsAchat() as $c) {
  35.             //echo "<div>TEST ==> ".$fournisseur->getId()." ::: </div>";
  36.             if ($fournisseur->getId() == $c->getFournisseur()->getId()) {
  38.                 $prix = $c->getPrixAchatNet();
  39.                 $prix = number_format($prix, 2, '.', '&nbsp;');
  40.                 $prix .= "&nbsp;&euro;";
  41.             }
  42.         }
  44.         return new JsonResponse(['prix' => $prix]);
  45.     }
  47.     /**
  48.      * @Route("/condition-vente/nouveau/{id}/{type}", name="dtc_condition_vente_ajouter")
  49.      */
  50.     public function ajouterAction(Request $request, $id, $type = "", EntityManagerInterface $em, TranslatorInterface $translator, ValidatorInterface $validator)
  51.     {
  53.         $titre_modal    = $translator->trans("Nouvelle condition de vente");
  54.         $repo_objet     = $em->getRepository(Article::class);
  55.         $get            = $request->query->all();
  56.         $conditionVente = new ConditionVente();
  58.         $objet = $repo_objet->find($id);
  59.         if (is_object($objet)) {
  60.             $conditionVente->setArticle($objet);
  61.             //$conditionVente->setLibelle($objet->getLibelle());
  62.         }
  64.         $user = $this->getUser();
  65.         //$conditionVente->setUtilisateur($user);
  66.         $form   = $this->createForm(ConditionVenteType::class, $conditionVente);
  67.         $errors = "";
  68.         $form->handleRequest($request);
  69.         if ($form->isSubmitted()) {
  71.             if ($form->isValid()) {
  73.                 if ($type == 'article') {
  75.                     $repo_objet = $em->getRepository(Article::class);
  76.                     $objet      = $repo_objet->find($id);
  79.                     $url = $this->generateUrl('dtc_article_modifier', ['id' => $objet->getId(), 'tab' => 'condVente']);
  80.                 }
  83.                 $em->persist($conditionVente);
  84.                 $em->persist($objet);
  85.                 $em->flush();
  88.                 if (array_key_exists('table', $get) && $get["table"] != "") {
  89.                     return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => $url, 'type' => 'recharger_datatable', 'id_datatable' => $get["table"]],
  90.                                             200,
  91.                                             ['Content-Type' => 'application/json']);
  92.                 } else {
  93.                     $this->addFlash('notice', $translator->trans('Condition de vente ajoutée avec succès !'));
  95.                     return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => $url]);
  97.                 }
  100.             } else {
  101.                 $errors = $validator->validate($conditionVente);
  102.                 $rendu  = $this->renderView(
  103.                     'Articles/ConditionVente/ajouter.html.twig',
  104.                     ['form' => $form->createView(), 'errors' => $errors, 'id' => $id, 'type' => $type, 'conditionVente' => $conditionVente]
  105.                 );
  107.                 return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  109.             }
  110.         }
  111.         $rendu = $this->renderView(
  112.             'Articles/ConditionVente/ajouter.html.twig',
  113.             ['form' => $form->createView(), 'errors' => $errors, 'id' => $id, 'type' => $type, 'conditionVente' => $conditionVente]
  114.         );
  116.         return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  117.         //return $this->render('Articles/ConditionVente/ajouter.html.twig', array('form' => $form->createView(),'errors'=>$errors,'id'=>$id,'type'=>$type));
  118.     }
  121.     /**
  122.      * @Route("/condition-vente/modifier/{objet}/{id}/{type}", name="dtc_condition_vente_modifier")
  123.      */
  124.     public function modifierAction(Request            $request, ConditionVente $objet, $id, $type, EntityManagerInterface $em, TranslatorInterface $translator,
  125.                                    ValidatorInterface $validator
  126.     ) {
  127.         $conditionVente = $objet;
  128.         $titre_modal    = $translator->trans("Modifier la condition de vente");
  129.         $get            = $request->query->all();
  130.         $user           = $this->getUser();
  131.         // $conditionVente->setUtilisateur($user);
  132.         $form   = $this->createForm(ConditionVenteType::class, $conditionVente);
  133.         $errors = "";
  134.         $form->handleRequest($request);
  135.         if ($form->isSubmitted()) {
  137.             $droit = $this->isGranted(EntityVoter::UPDATE,ConditionVente::class);
  138.             /*
  139.             if(!$droit) {
  140.                 $rendu = $this->renderView('Articles/ConditionVente/ajouter.html.twig', array('form' => $form->createView(),'errors'=>$errors,'id'=>$id,'type'=>$type,'objet'=>$objet));
  141.                 return new Response(json_encode(array('rendu'=>$rendu,'valide'=>'0','url'=>'','titre'=>$titre_modal)), 200, array('Content-Type'=>'application/json'));
  142.             }
  143.             */
  144.             if ($form->isValid()) {
  147.                 if ($type == 'article') {
  148.                     $repo_objet = $em->getRepository(Article::class);
  149.                     $article    = $repo_objet->find($id);
  150.                     $url        = $this->generateUrl('dtc_article_modifier', ['id' => $article->getId(), 'tab' => 'condVente']);
  151.                 }
  152.                 if ($type == 'fournisseur') {
  153.                     $url = $this->generateUrl('dtc_fournisseur_modifier', ['id' => $id, 'tab' => 'conditions']);
  154.                 }
  155.                 if ($type == 'commandeFournisseur') {
  156.                     $url = $this->generateUrl('dtc_commande_fournisseur_modifier', ['id' => $id]);
  157.                 }
  160.                 $em->persist($conditionVente);
  161.                 $em->flush();
  164.                 if (array_key_exists('table', $get) && $get["table"] != "") {
  165.                     return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => $url, 'type' => 'recharger_datatable', 'id_datatable' => $get["table"]],
  166.                                             200,
  167.                                             ['Content-Type' => 'application/json']);
  168.                 } else {
  169.                     $this->addFlash('notice', $translator->trans('Condition de vente modifiée avec succès !'));
  171.                     return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => $url]);
  173.                 }
  176.             } else {
  177.                 $errors = $validator->validate($conditionVente);
  178.                 $rendu  = $this->renderView(
  179.                     'Articles/ConditionVente/ajouter.html.twig',
  180.                     ['form' => $form->createView(), 'errors' => $errors, 'id' => $id, 'type' => $type, 'objet' => $objet, 'conditionVente' => $conditionVente]
  181.                 );
  183.                 return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  185.             }
  186.         }
  187.         $rendu = $this->renderView(
  188.             'Articles/ConditionVente/ajouter.html.twig',
  189.             ['form' => $form->createView(), 'errors' => $errors, 'id' => $id, 'type' => $type, 'objet' => $objet, 'conditionVente' => $conditionVente]
  190.         );
  192.         return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  193.     }
  195.     /**
  196.      * @Route("/condition-vente/supprimer/{objet}/{id}/{type}", name="dtc_condition_vente_supprimer")
  197.      */
  198.     public function supprimerAction(Request $request, ConditionVente $objet, $id, $type, EntityManagerInterface $em, TranslatorInterface $translator, ValidatorInterface $validator)
  199.     {
  201.         $conditionVente = $objet;
  202.         $titre_modal    = $translator->trans("Demande de confirmation");
  203.         $user           = $this->getUser();
  204.         $get            = $request->query->all();
  205.         $form           = $this->createForm(SupprimerConditionVenteType::class, $conditionVente);
  206.         $errors         = "";
  207.         $form->handleRequest($request);
  208.         if ($form->isSubmitted()) {
  210.             if ($form->isValid()) {
  211.                 $em->remove($conditionVente);
  212.                 $em->flush();
  215.                 if ($type == 'article') {
  216.                     $url = $this->generateUrl('dtc_article_modifier', ['id' => $id, 'tab' => 'condVente']);
  217.                 }
  220.                 if (array_key_exists('table', $get) && $get["table"] != "") {
  221.                     return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => $url, 'type' => 'recharger_datatable', 'id_datatable' => $get["table"]],
  222.                                             200,
  223.                                             ['Content-Type' => 'application/json']);
  224.                 } else {
  225.                     $this->addFlash('notice', $translator->trans('Condition de vente supprimée avec succès !'));
  227.                     return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => $url]);
  229.                 }
  232.             } else {
  234.                 $errors = $validator->validate($conditionVente);
  235.                 $rendu  = $this->renderView('FO/Supprimer/supprimer.html.twig', ['form' => $form->createView(), 'errors' => $errors, 'id' => $id, 'type' => $type, 'objet' => $objet]);
  237.                 return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  239.             }
  240.         }
  241.         $rendu = $this->renderView('FO/Supprimer/supprimer.html.twig', ['form' => $form->createView(), 'errors' => $errors, 'id' => $id, 'type' => $type, 'objet' => $objet]);
  243.         return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  244.     }
  246.     /**
  247.      * @Route("/condition-vente/charger-tableau/{id}/{type}", name="dtc_condition_vente_charger_tableau")
  248.      */
  249.     public function chargerTableauAction(Request $request, $id = "0", $type = "a")
  250.     {
  252.         $rendu = $this->renderView('Articles/ConditionVente/charger_tableau.html.twig', ["id" => $id, "type" => $type]);
  254.         return new JsonResponse(['rendu' => $rendu]);
  256.     }
  259.     /**
  260.      * @Route("/condition-vente", name="dtc_condition_vente_liste")
  261.      */
  262.     public function listerAction(Request $request, $id = "0", $type = "a", EntityManagerInterface $em, Datatable $datatable, TranslatorInterface $translator)
  263.     {
  265.         $tableau_class_cellule = [];
  266.         /*
  267.         $tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id","targets"=>array(0),"visible"=>true);
  268.         $tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id","targets"=>array(1),"visible"=>true);
  269.         $tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id","targets"=>array(2),"visible"=>true);
  270.         $tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id","targets"=>array(3),"visible"=>true);
  271.         $tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id","targets"=>array(4),"visible"=>true);
  272.         $tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id","targets"=>array(5),"visible"=>true);
  273.         $tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id","targets"=>array(6),"visible"=>true);
  274.         $tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id","targets"=>array(7),"visible"=>true);
  275.         $tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id","targets"=>array(8),"visible"=>true);
  276.         $tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id","targets"=>array(9),"visible"=>true);
  277.         $tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id","targets"=>array(10),"visible"=>true);
  278.         $tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id","targets"=>array(11),"visible"=>true);
  279.         $tableau_class_cellule[]=array("orderable"=> false,"searchable"=> false,"className"=>" colonne_id","targets"=>array(12),"visible"=>true);
  280.         */
  282.         $modal     = $request->query->get('modal');
  283.         $articleId = $request->query->get('id');
  284.         $qte       = $request->query->get('qte');
  286.         if ($type == "article") {
  287.             $repo_objet = $em->getRepository(Article::class);
  288.         }
  289.         if ($type == "fournisseur") {
  290.             $repo_objet = $em->getRepository(Fournisseur::class);
  291.         }
  294.         $objet = $repo_objet->find($id);
  295.         if ($articleId != '') {
  296.             $article = $repo_objet->find($articleId);
  298.             if ($modal == 1 && is_object($article)) {
  299.                 $titre_modal = $translator->trans('Conditions de vente');
  300.                 $this->datatableArticle($article, $type, $datatable, $translator);
  301.                 $rendu = $this->renderView(
  302.                     'Articles/ConditionVente/lister.html.twig',
  303.                     ['tableauClassColonne' => $tableau_class_cellule, "id" => $articleId, "type" => $type, 'qte' => $qte]
  304.                 );
  306.                 //$rendu = $this->renderView('FO/Supprimer/supprimer.html.twig', array('form' => $form->createView(),'errors'=>$errors,'id'=>$id,'type'=>$type,'objet'=>$objet));
  307.                 return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  308.             }
  309.         }
  311.         if (is_object($objet)) {
  314.             if ($type == "article") {
  316.                 $tableau_class_cellule   = [];
  317.                 $tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export colonne_id", "targets" => [0], "visible" => false];
  318.                 $tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export colonne_id text-left", "targets" => [1], "visible" => true];
  319.                 $tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export colonne_id text-center", "targets" => [2], "visible" => true];
  320.                 $tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export colonne_id text-center", "targets" => [3], "visible" => true];
  321.                 $tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export colonne_id text-right", "targets" => [4], "visible" => true];
  322.                 $tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export colonne_id text-center", "targets" => [5], "visible" => true];
  323.                 $tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export colonne_id text-center", "targets" => [6], "visible" => true];
  324.                 $tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export colonne_id ", "targets" => [7], "visible" => true];
  325.                 $tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export colonne_id ", "targets" => [8], "visible" => true];
  326.                 $tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export colonne_id text-center", "targets" => [9], "visible" => true];
  328.                 $tableau_class_cellule[] = ["orderable" => false, "searchable" => false, "className" => "colonne_id", "targets" => [10], "visible" => true];
  331.                 $this->datatableArticle($objet, $type, $datatable, $translator);
  332.             } elseif ($type == "fournisseur") {
  335.                 $tableau_class_cellule   = [];
  336.                 $tableau_class_cellule[] = ["searchable" => false, "className" => "visible_export colonne_id", "targets" => [0], "visible" => true];
  337.                 $tableau_class_cellule[] = ["searchable" => false, "className" => "visible_export colonne_id", "targets" => [1], "visible" => true];
  338.                 $tableau_class_cellule[] = ["searchable" => false, "className" => "visible_export colonne_id", "targets" => [2], "visible" => true];
  339.                 $tableau_class_cellule[] = ["searchable" => false, "className" => "visible_export colonne_id", "targets" => [3], "visible" => true];
  340.                 $tableau_class_cellule[] = ["searchable" => false, "className" => "visible_export colonne_id", "targets" => [4], "visible" => true];
  341.                 $tableau_class_cellule[] = ["searchable" => false, "className" => "visible_export colonne_id", "targets" => [5], "visible" => true];
  342.                 $tableau_class_cellule[] = ["searchable" => false, "className" => "visible_export colonne_id", "targets" => [6], "visible" => true];
  343.                 $tableau_class_cellule[] = ["searchable" => false, "className" => "visible_export colonne_id", "targets" => [7], "visible" => true];
  344.                 $tableau_class_cellule[] = ["searchable" => false, "className" => "visible_export colonne_id", "targets" => [8], "visible" => true];
  345.                 $tableau_class_cellule[] = ["searchable" => false, "className" => "visible_export colonne_id", "targets" => [9], "visible" => true];
  346.                 $tableau_class_cellule[] = ["orderable" => false, "className" => "colonne_id", "targets" => [10], "visible" => true];
  348.                 $this->datatableFournisseur($objet, $type, $datatable, $translator);
  349.             }
  352.             return $this->render('Articles/ConditionVente/lister.html.twig', ['tableauClassColonne' => $tableau_class_cellule, "id" => $id, "type" => $type]);
  353.         } else {
  354.             $this->datatable($datatable, $translator);
  356.             return $this->render('Articles/ConditionVente/lister.html.twig', ['tableauClassColonne' => $tableau_class_cellule, "id" => $id, "type" => $type]);
  357.         }
  358.     }
  361.     /**
  362.      * set datatable configs
  363.      *
  364.      * @return \App\Library\Datatable\Util\Datatable
  365.      */
  366.     private function datatable(Datatable $datatable, TranslatorInterface $translator)
  367.     {
  369.         $datatable->setDatatableId('dta-condition-vente')
  370.                   ->setEntity(ConditionVente::class, "x")
  371.                   ->setFields(
  372.                       [
  373.                           $translator->trans("ID")      => 'x.id',
  374.                           $translator->trans("Libellé") => 'x.libelle',
  375.                           $translator->trans("Mini")    => 'x.debut',
  376.                           $translator->trans("Maxi")    => 'x.fin',
  377.                           $translator->trans("Prix")    => 'x.prix',
  378.                           //$translator->trans("Libelle") =>  'x.libelle',
  379.                           $translator->trans("Actions") => 'x.id',
  380.                           "_identifier_"                => 'x.id',
  381.                       ]
  382.                   )
  383.             //->addJoin('x.statutCommande', 's', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  384.             /*->setWhere(
  385.                     $type_jointure.' = :objet',
  386.                     array('objet' => $objet)
  387.                )
  388.               */
  389.                   ->setRenderers(
  390.                 [
  393.                     5 => [
  394.                         'view'   => 'FO/DataTable/actions.html.twig',
  395.                         'params' => [
  396.                             //'edit_route'  => 'dtc_garantie_modifier',
  397.                             //'supprimer_route'  => 'dtc_garantie_supprimer',
  398.                             'entite' => 'garantie',
  399.                             'objet'  => ConditionVente::class,
  401.                         ],
  402.                     ],
  405.                 ]
  406.             )
  407.                   ->setOrder("x.id", "desc")
  408.                   ->setSearch(true)
  409.                   ->setSearchFields([1, 4]);
  411.         return $datatable;
  412.     }
  415.     /**
  416.      * set datatable configs
  417.      *
  418.      * @return \App\Library\Datatable\Util\Datatable
  419.      */
  420.     private function datatableFournisseur($objet, $type = "", Datatable $datatable, TranslatorInterface $translator)
  421.     {
  424.         $type_jointure = 'x.'.$type;
  425.         $datatable->setDatatableId('dta-condition-vente')
  426.                   ->setEntity(ConditionVente::class, "x")
  427.                   ->setFields(
  428.                       [
  429.                           //$translator->trans("ID") =>  'x.id',
  430.                           $translator->trans("Réf")              => 'a.reference',
  431.                           $translator->trans("Réf fourn")        => 'x.referenceFournisseur',
  432.                           $translator->trans("Libellé")          => 'a.libelle',
  433.                           $translator->trans("Qté mini")         => 'x.quantite',
  434.                           $translator->trans("Conditionnement")  => 'x.conditionnement',
  435.                           $translator->trans("Prix achat brut")  => 'x.prixAchatBrut',
  436.                           $translator->trans("Tx remise")        => 'x.tauxRemise',
  437.                           $translator->trans("Tx remise suppl.") => 'x.tauxRemiseSupplementaire',
  438.                           $translator->trans("Prix achat net")   => 'x.prixAchatNet',
  439.                           //$translator->trans("Fournisseur") =>  'f.libelle',
  440.                           //$translator->trans("Devise") =>  "d.name",
  441.                           $translator->trans("Défaut")           => 'x.defaut',
  442.                           $translator->trans("Actions")          => 'x.id',
  443.                           "_identifier_"                         => 'x.id',
  444.                       ]
  445.                   )
  446.                   ->addJoin('x.article', 'a', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  447.                   ->addJoin('x.fournisseur', 'f', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  448.                   ->addJoin('f.devise', 'd', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  449.                   ->setWhere(
  450.                       'x.fournisseur = :objet',
  451.                       ['objet' => $objet]
  452.                   )
  453.                   ->setRenderers(
  454.                       [
  456.                           /*
  457.                           1 => array(
  458.                               'view' => 'FO/DataTable/actions_modal.html.twig',
  459.                               'params' => array(
  460.                                       'edit_route'  => 'dtc_article_modifier',
  461.                                       'id'    => '',
  462.                                       'type'    => $type,
  463.                                       //'entite'    => 'article',
  464.                                       //'objet' => "DTCArticlesBundle:Article",
  465.                                       'typeDocument' => 'article'
  466.                                   ),
  467.                           ),
  468.                            *
  469.                            */
  471.                           2 => [
  472.                               'view'   => 'FO/DataTable/actions_modal.html.twig',
  473.                               'params' => [
  474.                                   'edit_route' => 'dtc_condition_achat_modifier',
  475.                                   'id'         => $objet->getId(),
  476.                                   'type'       => $type,
  477.                                   'entite'     => 'garantie',
  478.                                   'objet'      => ConditionVente::class,
  479.                                   'affichage'  => 'item',
  480.                               ],
  481.                           ],
  483.                           5  => [
  484.                               'view' => 'FO/DataTable/prix.html.twig',
  485.                           ],
  486.                           8  => [
  487.                               'view' => 'FO/DataTable/prix.html.twig',
  488.                           ],
  489.                           9  => [
  490.                               'view' => 'FO/DataTable/booleen.html.twig',
  491.                           ],
  492.                           10 => [
  493.                               'view'   => 'FO/DataTable/actions_modal.html.twig',
  494.                               'params' => [
  495.                                   'edit_route'      => 'dtc_condition_achat_modifier',
  496.                                   'supprimer_route' => 'dtc_condition_achat_supprimer',
  497.                                   'id'              => $objet->getId(),
  498.                                   'table'           => 'dta-condition-vente',
  499.                                   'type'            => $type,
  500.                                   'entite'          => 'garantie',
  501.                                   'objet'           => ConditionVente::class
  502.                               ,
  503.                                   'width_modal'     => 800,
  504.                               ],
  505.                           ],
  506.                       ]
  507.                   )
  508.                   ->setOrder("x.id", "desc")
  509.                   ->setSearch(true)
  510.                   ->setSearchFields([1, 2, 3, 4, 5, 6, 7, 8]);
  512.         return $datatable;
  513.     }
  516.     /**
  517.      * set datatable configs
  518.      *
  519.      * @return \App\Library\Datatable\Util\Datatable
  520.      */
  521.     private function datatableArticle($objet, $type = "", Datatable $datatable, TranslatorInterface $translator)
  522.     {
  523.         $type_jointure = 'x.'.$type;
  524.         $datatable->setDatatableId('dta-condition-vente')
  525.                   ->setEntity(ConditionVente::class, "x")
  526.                   ->setFields(
  527.                       [
  528.                           $translator->trans("ID")         => 'x.id',
  529.                           $translator->trans("Libellé")    => 'x.libelle',
  530.                           $translator->trans("Mini")       => 'x.debut',
  531.                           $translator->trans("Maxi")       => 'x.fin',
  532.                           $translator->trans("Prix")       => 'x.prix',
  533.                           $translator->trans("Date début") => 'x.dateDebut',
  534.                           $translator->trans("Date fin")   => 'x.dateFin',
  535.                           $translator->trans("Pays")       => 'p.titre',
  536.                           $translator->trans("Catégorie")  => 'c.libelle',
  537.                           $translator->trans("Statut")     => 'x.statut',
  539.                           $translator->trans("Actions") => 'x.id',
  540.                           "_identifier_"                => 'x.id',
  541.                       ]
  542.                   )
  543.                   ->addJoin('x.pays', 'p', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  544.                   ->addJoin('x.categorieClient', 'c', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  545.             //->addJoin('f.devise', 'd', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  546.             //->addJoin('x.uniteMesure', 'u', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  547.             /*->setWhere(
  548.                     $type_jointure.' = :objet',
  549.                     array('objet' => $objet)
  550.                )
  551.               */
  552.                   ->setWhere(
  553.                 'x.article = :objet',
  554.                 ['objet' => $objet]
  555.             )
  556.                   ->setRenderers(
  557.                       [
  559.                           4  => [
  560.                               'view'   => 'FO/DataTable/prix.html.twig',
  561.                               'params' => [
  562.                                   'afficher_total' => false,
  563.                               ],
  564.                           ],
  565.                           5  => [
  566.                               'view' => 'FO/DataTable/date.html.twig',
  567.                           ],
  568.                           6  => [
  569.                               'view' => 'FO/DataTable/date.html.twig',
  570.                           ],
  571.                           9  => [
  572.                               'view'   => 'FO/DataTable/statut.html.twig',
  573.                               'params' => [
  574.                                   'edit_route' => 'dtc_condition_vente_statut',
  575.                               ],
  576.                           ],
  577.                           /*
  578.                           0 => array(
  579.                               'view' => 'FO/DataTable/date.html.twig',
  580.                           ),
  582.                       1 => array(
  583.                           'view' => 'FO/DataTable/avec_lien_edit_route.html.twig',
  584.                            'params' => array(
  585.                                       'edit_route'    => 'dtc_fournisseur_modifier',
  586.                                       'typeDocument' => 'fournisseur',
  587.                                       'target' => '_blank'
  588.                                   ),
  590.                           ),
  591.                           3 => array(
  592.                               'view' => 'FO/DataTable/prix.html.twig',
  593.                           ),
  594.                           7 => array(
  595.                               'view' => 'FO/DataTable/num2chiffres.html.twig',
  596.                           ),
  597.                           8 => array(
  598.                               'view' => 'FO/DataTable/prix.html.twig',
  599.                           ),
  602.                           10 => array(
  603.                               'view' => 'FO/DataTable/prix.html.twig',
  604.                               'params' => array('conversion'=>'*',
  605.                                   'forceEuro' => 1
  606.                                   )
  607.                           ),
  608.                           15 => array(
  609.                               'view' => 'FO/DataTable/statut.html.twig',
  610.                               'params' => array(
  611.                                   'edit_route' => 'dtc_condition_achat_statut'
  612.                               )
  613.                           ),
  614.                           */
  615.                           10 => [
  616.                               'view'   => 'FO/DataTable/actions_modal.html.twig',
  617.                               'params' => [
  618.                                   'edit_route'      => 'dtc_condition_vente_modifier',
  619.                                   'supprimer_route' => 'dtc_condition_vente_supprimer',
  620.                                   'id'              => $objet->getId(),
  621.                                   'type'            => $type,
  622.                                   'entite'          => 'garantie',
  623.                                   'table'           => 'dta-condition-vente',
  624.                                   'objet'           => ConditionVente::class
  625.                               ,
  626.                                   'width_modal'     => 800,
  627.                               ],
  628.                           ],
  629.                       ]
  630.                   )
  631.                   ->setOrder("x.id", "desc")
  632.                   ->setSearch(true)//->setSearchFields(array(1,2))
  633.         ;
  635.         return $datatable;
  636.     }
  639.     /**
  640.      * @Route("/condition-vente/grid/{id}/{type}", name="dtc_condition_vente_liste_grid")
  641.      */
  642.     public function gridAction($id = "", $type = "", EntityManagerInterface $em, Datatable $datatable, TranslatorInterface $translator)
  643.     {
  644.         if ($type == "article") {
  645.             $repo_objet = $em->getRepository(Article::class);
  646.         } elseif ($type == "fournisseur") {
  647.             $repo_objet = $em->getRepository(Fournisseur::class);
  648.         }
  649.         $objet = $repo_objet->find($id);
  651.         if (is_object($objet) and $type == "article") {
  652.             return $this->datatableArticle($objet, $type, $datatable, $translator)->execute();
  653.         } elseif (is_object($objet) and $type == "fournisseur") {
  654.             return $this->datatableFournisseur($objet, $type, $datatable, $translator)->execute();
  655.         } else {
  656.             return $this->datatable($datatable, $translator)->execute();
  657.         }
  659.     }
  661.     /**
  662.      * @Route("/condition-vente/statut/{id}", name="dtc_condition_vente_statut")
  663.      */
  664.     public function changeStatutAction(ConditionVente $conditionVente, EntityManagerInterface $em)
  665.     {
  666.         if ($conditionVente->getStatut() == 1) {
  667.             $conditionVente->setStatut(0);
  668.         } else {
  669.             $conditionVente->setStatut(1);
  670.         }
  672.         $em->persist($conditionVente);
  673.         $em->flush();
  674.         $em->refresh($conditionVente);
  677.         $headers = [
  678.             'Content-Type'                 => 'application/json',
  679.             'Access-Control-Allow-Origin'  => '*',
  680.             'Access-Control-Allow-Methods' => 'POST',
  681.         ];
  683.         return new JsonResponse(['data' => '1'], 200, $headers);
  685.     }
  687.     /**
  688.      * @Route("/condition-vente/nouveau-ajax", name="dtc_condition_vente_add_ajax")
  689.      */
  690.     public function ajouterAjaxAction(Request $request, EntityManagerInterface $em)
  691.     {
  693.         $refArticle  = $request->query->get('refArticle');
  694.         $quantiteMin = $request->query->get('quantiteMin');
  695.         $quantiteMax = $request->query->get('quantiteMax');
  696.         $prix        = $request->query->get('prix');
  698.         $finitions = [];
  699.         if ($this->getParameter('categorie_finitions')) {
  700.             $categorie_finitions = $em->getRepository(Categorie::class)->find($this->getParameter('categorie_finitions'));
  701.             $articlesCategories  = $em->getRepository(ArticleCategorie::class)->findBy(['categorie' => $categorie_finitions]);
  702.             foreach ($articlesCategories as $articleCategorie) {
  703.                 $finitions[] = $articleCategorie->getArticle();
  704.             }
  705.         }
  706.         $refArray = explode('-', $refArticle);
  707.         //$article = $repo_article->getArticleByRef();
  708.         $finition = null;
  709.         $ref      = '';
  710.         foreach ($finitions as $finitionTmp) {
  711.             $refTmp = $refArray[1];
  712.             $pos    = strpos($refTmp, $finitionTmp->getReference());
  713.             if ($pos !== false) {
  714.                 $refTmp = str_replace($finitionTmp->getReference(), '', $refTmp);
  715.                 if (strlen($refTmp) == $pos) {
  716.                     $finition = $finitionTmp;
  717.                     $ref      = $refTmp;
  718.                     break;
  719.                 }
  720.             }
  721.         }
  722.         if ($ref != '') {
  723.             $ref .= '|';
  724.             if ( ! empty($refArray[2])) {
  725.                 $ref .= $refArray[2];
  726.             }
  727.             $article = $em->getRepository(Article::class)->findOneBy(['reference' => $ref]);
  729.             if (is_object($article)) {
  730.                 $conditionVente = $em->getRepository(ConditionVente::class)->findOneBy([
  731.                                                                                            'article'  => $article,
  732.                                                                                            'debut'    => $quantiteMin,
  733.                                                                                            'fin'      => $quantiteMax,
  734.                                                                                            'finition' => $finition,
  735.                                                                                        ]);
  736.                 if ( ! is_object($conditionVente)) {
  737.                     $conditionVente = new ConditionVente;
  738.                     $conditionVente->setDebut($quantiteMin);
  739.                     $conditionVente->setFin($quantiteMax);
  740.                     $conditionVente->setArticle($article);
  741.                     $conditionVente->setFinition($finition);
  742.                     $conditionVente->setStatut(true);
  743.                 }
  744.                 $conditionVente->setPrix($prix);
  745.                 $em->persist($conditionVente);
  746.                 $em->flush();
  748.                 if (is_object($finition)) {
  749.                     $articleComposant = $em->getRepository(ArticleComposant::class)->findOneBy([
  750.                                                                                                    'articleCompose' => $article,
  751.                                                                                                    'article'        => $finition,
  752.                                                                                                ]);
  753.                     if ( ! is_object($articleComposant)) {
  754.                         $articleComposant = new ArticleComposant();
  755.                         $articleComposant->setArticleCompose($article);
  756.                         $articleComposant->setArticle($finition);
  757.                         $articleComposant->setQuantite(1);
  758.                         $em->persist($articleComposant);
  759.                         $em->flush();
  760.                     }
  761.                 }
  762.             }
  763.         }
  766.         $retour = 'ref: '.$ref;
  767.         if (is_object($finition)) {
  768.             $retour .= ' + finition '.$finition->getReference();
  769.         }
  770.         $retour .= ' -> '.$prix;
  771.         if ( ! empty($conditionVente) && is_object($conditionVente)) {
  772.             $retour .= ' / condition de vente ID '.$conditionVente->getId();
  773.         }
  775.         return new JsonResponse(['data' => $retour]);
  776.     }
  778. }