src/Controller/Clients/ClientController.php line 897

Open in your IDE?
  1. <?php
  3. namespace App\Controller\Clients;
  5. use App\Entity\Adresses\Adresse;
  6. use App\Entity\Articles\Article;
  7. use App\Entity\Articles\Compta;
  8. use App\Entity\Clients\Categorie;
  9. use App\Entity\Clients\Client;
  10. use App\Entity\Clients\HistoriqueClient;
  11. use App\Entity\Clients\Type;
  12. use App\Entity\Ged\Fichier;
  13. use App\Entity\GestionComerciale\ArticleCommande;
  14. use App\Entity\GestionComerciale\Commande;
  15. use App\Entity\Localisation\Zone;
  16. use App\Entity\Notes\Note;
  17. use App\Entity\Remises\Remise;
  18. use App\Entity\Vehicules\VehiculeClient;
  19. use App\Form\Clients\Client2Type;
  20. use App\Form\Clients\ClientType;
  21. use App\Form\Clients\SupprimerClientType;
  22. use App\Library\Datatable\Util\Datatable;
  23. use App\Model\GestionCommerciale\TypeDocumentCommercial;
  24. use App\Security\Voter\EntityVoter;
  25. use App\Service\Clients\ClientCategorieRemiseClientService;
  26. use App\Service\Clients\ClientCategorieService;
  27. use App\Service\Clients\ClientService;
  28. use App\Service\Clients\DocumentClient;
  29. use App\Service\FO\Logo;
  30. use App\Service\GestionComerciale\AcompteService;
  31. use App\Service\GestionComerciale\EmailService;
  32. use App\Service\GestionComerciale\NumerotationDocumentService;
  33. use App\Service\Localisation\ZoneService;
  34. use App\Service\Utilisateur\ColonneTableauService;
  35. use Doctrine\ORM\EntityManagerInterface;
  36. use JMS\Serializer\SerializerBuilder;
  37. use Knp\Component\Pager\PaginatorInterface;
  38. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  39. use Symfony\Component\Form\FormError;
  40. use Symfony\Component\HttpFoundation\JsonResponse;
  41. use Symfony\Component\HttpFoundation\Request;
  42. use Symfony\Component\HttpFoundation\Response;
  43. use Symfony\Component\Routing\Annotation\Route;
  44. use Symfony\Component\Serializer\Encoder\JsonEncoder;
  45. use Symfony\Component\Serializer\Normalizer\GetSetMethodNormalizer;
  46. use Symfony\Component\Serializer\Normalizer\JsonSerializableNormalizer;
  47. use Symfony\Component\Serializer\Normalizer\ObjectNormalizer;
  48. use Symfony\Component\Serializer\Serializer;
  49. use Symfony\Component\Validator\Validator\ValidatorInterface;
  50. use Symfony\Contracts\Translation\TranslatorInterface;
  53. class ClientController extends AbstractController
  54. {
  56.     /**
  57.      * @Route("/debugsolde/{id}", name="dtc_debug_solde")
  58.      */
  59.     public function debugSoldeAction()
  60.     {
  61.         //echo "<div>TEST</div>";
  62.         //$acompteService = $this->get('dtc.acompte');
  63.         //$soldeClient = $acompteService->getSoldeClientTest($client);
  64.     }
  66.     /**
  67.      * @Route("/client/dupliquer/{id}", name="dtc_client_dupliquer")
  68.      */
  69.     public function dupliquerAction(Request $request, Client $client, EntityManagerInterface $em, NumerotationDocumentService $numerotationService, TranslatorInterface $translator)
  70.     {
  72.         $repoClient = $em->getRepository(Client::class);
  73.         $derclient  = $repoClient->getDernierClient();
  74.         $derclient  = $derclient + 1;
  76.         $client_duplique = clone $client;
  77.         //$article_duplique->setId(null);
  78.         $client_duplique->setNom("COPIE ".$client_duplique->getNom());
  79.         $codeCompta = "411{$derclient}";
  80.         $codeCompta = "C".str_pad($derclient, 5, '0', STR_PAD_LEFT);
  82.         $client->setReference($numerotationService->generer($client));
  83.         $client->setNumeroReference($derclient);
  85.         $client_duplique->setCodeComptable($codeCompta);
  87.         $adresse = new Adresse();
  88.         $adresse->setLibelle('Adresse par défaut');
  89.         $adresse->setLivraisonDefaut(true);
  90.         $adresse->setFacturationDefaut(true);
  91.         $adresse->setFacturationExpeditionDefaut(true);
  92.         $client_duplique->addAdress($adresse);
  94.         $em->persist($client_duplique);
  95.         $em->flush();
  96.         $em->refresh($client_duplique);
  97.         $this->addFlash(
  98.             'notice',
  99.             $translator->trans('Client dupliqué avec succès !')
  100.         );
  103.         return $this->redirectToRoute('dtc_client_modifier', ["id" => $client_duplique->getId()]);
  105.         //return $this->redirectToRoute($url);
  107.         //return $this->redirectToRoute('dtc_client_liste');
  109.     }
  111.     /**
  112.      * @Route("/client/modal/nouveau", name="dtc_client_ajouter_modal")
  113.      */
  114.     public function ajouterModalSimplifieAction(Request                $request, EntityManagerInterface $em, NumerotationDocumentService $numerotationService,
  115.                                                 ClientCategorieService $clientCategorieService, ClientCategorieRemiseClientService $clientCategorieRemiseClientService,
  116.                                                 TranslatorInterface    $translator, ValidatorInterface $validator
  117.     ) {
  118.         $titre_modal = $translator->trans("Nouveau client");
  119.         $client      = new Client;
  120.         $client->setTypeClient($em->getRepository(Type::class)->find(1));
  121.         $france_obj = $em->getRepository(Zone::class)->find(370095);
  122.         $user       = $this->getUser();
  123.         $client->setUtilisateur($user);
  125.         $adresse = new Adresse();
  126.         $adresse->setLibelle('Adresse par défaut');
  127.         $adresse->setLivraisonDefaut(true);
  128.         $adresse->setFacturationDefaut(true);
  129.         $adresse->setFacturationExpeditionDefaut(true);
  130.         $adresse->setPays($france_obj);
  131.         $client->addAdress($adresse);
  133.         $categories_remise        = $request->request->get('categories_remise');
  134.         $categorie_client_enfants = $request->request->get('categorie_client_enfants');
  136.         $form      = $this->createForm(Client2Type::class, $client);
  137.         $errors    = "";
  138.         $errorsSup = [];
  139.         $form->handleRequest($request);
  140.         if ($form->isSubmitted()) {
  142.             if ( ! is_object($adresse->getVille()) or $adresse->getNumero() == "" or $adresse->getRue() == "") {
  143.                 $error = new FormError("Adresse obligatoire (Numéro,Rue,Ville)");
  144.                 $form->get('prenom')->addError($error);
  145.             }
  148.             //if ($form->isValid() && count($categories_remise)>0 && count($categorie_client_enfants)>0) {
  149.             if ($form->isValid()) {
  151.                 $em         = $em;
  152.                 $repoClient = $em->getRepository(Client::class);
  153.                 $derclient  = $repoClient->getDernierClient();
  154.                 $derclient  = $derclient + 1;
  155.                 $codeCompta = "411{$derclient}";
  156.                 $codeCompta = "C".str_pad($derclient, 5, '0', STR_PAD_LEFT);
  158.                 $libelle_adresse = trim($client->getNom()." ".$client->getPrenom());
  160.                 $adresse->setLibelle($libelle_adresse);
  162.                 $client->setReference($numerotationService->generer($client));
  163.                 $client->setNumeroReference($derclient);
  164.                 $client->setCodeComptable($codeCompta);
  166.                 $client->setPays($adresse->getPays());
  167.                 $client->setCodePostal($adresse->getCodePostal());
  168.                 $client->setVille($adresse->getVille());
  170.                 if ( ! empty($request->request->get('liste_categorie_client_racine'))) {
  171.                     $categorie = $em->getRepository(Categorie::class)->find($request->request->get('liste_categorie_client_racine'));
  172.                     if (is_object($categorie)) {
  173.                         $client->setCompta($categorie->getCompta());
  174.                     }
  175.                 }
  177.                 $url = '#';
  178.                 $em  = $em;
  179.                 $em->persist($client);
  180.                 $em->flush();
  182.                 //$clientCategorieService->sauvegarder($client,$request->request->get('categories'));
  183.                 $clientCategorieService->sauvegarder($client, $request->request->get('liste_categorie_client_racine'), $categorie_client_enfants);
  185.                 $clientCategorieRemiseClientService->sauvegarder($client, $request->request->get('categories_remise'));
  187.                 $libelle = $client->getNom()." ".$client->getPrenom();
  189.                 return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => $url, 'type' => 'client', 'libelle' => $libelle, 'id_client' => $client->getId()],
  190.                     200,
  191.                     ['Content-Type' => 'application/json']);
  192.             } else {
  193.                 $errors = $validator->validate($client);
  194.                 //if(count($categories_remise) == 0) $errorsSup[] = 'Le client n\'a pas de catégorie de remise définie! ';
  195.                 //if(count($categorie_client_enfants) == 0) $errorsSup[] = 'Le client n\'a pas de catégorie définie! ';
  196.                 $rendu = $this->renderView(
  197.                     'Clients/Client/ajouter_modal_simplifie.html.twig',
  198.                     ['form' => $form->createView(), 'errors' => $errors, 'errorsSup' => $errorsSup, 'client' => $client]
  199.                 );
  201.                 return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  203.             }
  204.         } else {
  206.         }
  207.         $rendu = $this->renderView(
  208.             'Clients/Client/ajouter_modal_simplifie.html.twig',
  209.             ['form' => $form->createView(), 'errors' => $errors, 'errorsSup' => $errorsSup, 'client' => $client]
  210.         );
  212.         return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  213.     }
  215.     /**
  216.      * @Route("/client/modal/{id}", name="dtc_client_afficher_modal")
  217.      */
  218.     public function afficherModalAction(Request$request, Client $client, EntityManagerInterface $em,
  219.                                         ClientService $clientService,ClientCategorieRemiseClientService $clientCategorieRemiseClientService,
  220.                                         ClientCategorieService $clientCategorieService,ValidatorInterface $validator,Datatable $datatable, TranslatorInterface $translator
  222.     )
  223.     {
  224.         $url = $this->generateUrl('dtc_client_modifier', ["id" => $client->getId()]);
  225.         $titre_modal = "<a href='" . $url . "' target='_blank'>" . $client->getNom() . "</a>";
  226.         $user = $this->getUser();
  227.         //$form = $this->createForm(new ClientType($em), $client);
  228.         $form = $this->createForm(Client2Type::class, $client);
  229.         $errors = "";
  230.         $form->handleRequest($request);
  231.         if ($form->isSubmitted()) {
  233.             //vérifier quel champs a été modifié pour l'historique
  234.             $clientService->verifierChampsModifier($client);
  236.             $clientCategorieRemiseClientService->sauvegarder($client, $request->request->get('categories_remise'));
  238.             if ($form->isValid()) {
  240.                 $url = '#';
  241.                 $em->persist($client);
  242.                 $em->flush();
  245.                 //$clientCategorieService->sauvegarder($client,$request->request->get('categories'));
  246.                 $clientCategorieService->sauvegarder($client, $request->request->get('liste_categorie_client_racine'), $request->request->get('categorie_client_enfants'));
  249.                 $libelle = $client->getPrenom() . " " . $client->getNomAvecAdresse();
  251.                 return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => $url, 'type' => 'client_modifier', 'libelle' => $libelle, 'id_client' => $client->getId()],
  252.                     200,
  253.                     ['Content-Type' => 'application/json']);
  254.             } else {
  255.                 $errors = $validator->validate($client);
  256.                 //$rendu = $this->renderView('Clients/Client/afficher_modal.html.twig', array('client'=>$client,'form' => $form->createView(),'errors'=>$errors));
  257.                 $rendu = $this->renderView('Clients/Client/ajouter_modal_simplifie.html.twig', ['client' => $client, 'form' => $form->createView(), 'errors' => $errors]);
  259.                 return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  261.             }
  262.         }
  264.         $param = [];
  265.         $dateDebut = new \DateTime();
  266.         $dateDebut->sub(new \DateInterval('P1Y'));
  267.         $dateFin = new \DateTime();
  269.         $param['date_debut'] = $dateDebut->format("m/Y");
  270.         $param['date_fin'] = $dateFin->format("m/Y");
  272.         $repoCommande = $em->getRepository(Commande::class);
  273.         //$valeurs =  $repoCommande->suiviConsommation($param);
  274.         $param['client'] = $client->getId();
  275.         $caMois = $repoCommande->caMois($param);
  278.         $this->datatableNotes($client, $datatable, $translator);
  279.         $this->datatableCommandes($client, $datatable, $translator);
  280.         //$rendu = $this->renderView('Clients/Client/afficher_modal.html.twig', array("parametres"=>$param,"caMois"=>$caMois,'client'=>$client,'form' => $form->createView(),'errors'=>$errors));
  281.         $rendu = $this->renderView(
  282.             'Clients/Client/ajouter_modal_simplifie.html.twig',
  283.             ["parametres" => $param, "caMois" => $caMois, 'client' => $client, 'form' => $form->createView(), 'errors' => $errors]
  284.         );
  286.         return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  287.     }
  293.     /**
  294.      * @Route("", name="")
  295.      */
  296.     public function ajouterModalAction(Request                $request, EntityManagerInterface $em, NumerotationDocumentService $numerotationService,
  297.                                        ClientCategorieService $clientCategorieService, ClientCategorieRemiseClientService $clientCategorieRemiseClientService,
  298.                                        TranslatorInterface    $translator, ValidatorInterface $validator
  299.     ) {
  300.         $titre_modal = $translator->trans("Nouveau client");
  301.         $client      = new Client;
  302.         $client->setTypeClient($em->getRepository(Type::class)->find(1));
  303.         $user = $this->getUser();
  304.         $client->setUtilisateur($user);
  306.         $adresse = new Adresse();
  307.         $adresse->setLibelle('Adresse par défaut');
  308.         $adresse->setLivraisonDefaut(true);
  309.         $adresse->setFacturationDefaut(true);
  310.         $adresse->setFacturationExpeditionDefaut(true);
  311.         $client->addAdress($adresse);
  313.         $categories_remise        = $request->request->get('categories_remise');
  314.         $categorie_client_enfants = $request->request->get('categorie_client_enfants');
  316.         $form      = $this->createForm(Client2Type::class, $client);
  317.         $errors    = "";
  318.         $errorsSup = [];
  319.         $form->handleRequest($request);
  320.         if ($form->isSubmitted()) {
  322.             //if ($form->isValid() && count($categories_remise)>0 && count($categorie_client_enfants)>0) {
  323.             if ($form->isValid()) {
  325.                 $repoClient = $em->getRepository(Client::class);
  326.                 $derclient  = $repoClient->getDernierClient();
  327.                 $derclient  = $derclient + 1;
  328.                 $codeCompta = "411{$derclient}";
  329.                 $codeCompta = "C".str_pad($derclient, 5, '0', STR_PAD_LEFT);
  331.                 $client->setReference($numerotationService->generer($client));
  332.                 $client->setNumeroReference($derclient);
  333.                 $client->setCodeComptable($codeCompta);
  335.                 $client->setPays($adresse->getPays());
  336.                 $client->setCodePostal($adresse->getCodePostal());
  337.                 $client->setVille($adresse->getVille());
  339.                 $url = '#';
  340.                 $em  = $em;
  341.                 $em->persist($client);
  342.                 $em->flush();
  344.                 //$clientCategorieService->sauvegarder($client,$request->request->get('categories'));
  345.                 $clientCategorieService->sauvegarder($client, $request->request->get('liste_categorie_client_racine'), $categorie_client_enfants);
  347.                 $clientCategorieRemiseClientService->sauvegarder($client, $request->request->get('categories_remise'));
  349.                 $libelle = $client->getNom()." ".$client->getPrenom();
  351.                 return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => $url, 'type' => 'client', 'libelle' => $libelle, 'id_client' => $client->getId()],
  352.                                         200,
  353.                                         ['Content-Type' => 'application/json']);
  354.             } else {
  355.                 $errors = $validator->validate($client);
  356.                 //if(count($categories_remise) == 0) $errorsSup[] = 'Le client n\'a pas de catégorie de remise définie! ';
  357.                 //if(count($categorie_client_enfants) == 0) $errorsSup[] = 'Le client n\'a pas de catégorie définie! ';
  358.                 $rendu = $this->renderView('Clients/Client/ajouter_modal.html.twig', ['form' => $form->createView(), 'errors' => $errors, 'errorsSup' => $errorsSup, 'client' => $client]
  359.                 );
  361.                 return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  363.             }
  364.         } else {
  366.         }
  367.         $rendu = $this->renderView('Clients/Client/ajouter_modal.html.twig', ['form' => $form->createView(), 'errors' => $errors, 'errorsSup' => $errorsSup, 'client' => $client]);
  369.         return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  370.     }
  373.     /**
  374.      * @Route("/client/nouveau", name="dtc_client_ajouter")
  375.      */
  376.     public function ajouterAction(Request                $request, EntityManagerInterface $em, NumerotationDocumentService $numerotationService, Logo $logo, DocumentClient $documentClient,
  377.                                   ClientCategorieService $clientCategorieService, ClientCategorieRemiseClientService $clientCategorieRemiseClientService, ClientService $clientService,
  378.                                   TranslatorInterface    $translator, ValidatorInterface $validator
  379.     ) {
  381.         $user   = $this->getUser();
  382.         $client = new Client;
  384.         $repo_client = $em->getRepository(Client::class);
  386.         $client->setTypeClient($em->getRepository(Type::class)->find(1));
  387.         $client->setCompta($em->getRepository(Compta::class)->find(42));
  388.         $client->setUtilisateur($user);
  390.         $adresse = new Adresse();
  391.         $adresse->setLibelle('Adresse par défaut');
  392.         $adresse->setLivraisonDefaut(true);
  393.         $adresse->setFacturationDefaut(true);
  394.         $client->addAdress($adresse);
  396.         $categories_remise        = $request->request->get('categories_remise');
  397.         $categorie_client_enfants = $request->request->get('categorie_client_enfants');
  399.         $form      = $this->createForm(Client2Type::class, $client);
  400.         $errors    = "";
  401.         $errorsSup = [];
  402.         $form->handleRequest($request);
  404.         if ($form->isSubmitted()) {
  405.             $tokenP = $request->request->get('tokenPicture');
  407.             $email_existe = false;
  409.             $client_email = $repo_client->findOneBy(["email" => $client->getEmail()]);
  410.             if (is_object($client_email)) {
  411.                 $email_existe = true;
  412.             }
  413.             if ($client->getEmail() == "") {
  414.                 $email_existe = false;
  415.             }
  418.             //if ($form->isValid() && !$email_existe && count($categories_remise)>0 && count($categorie_client_enfants) > 0 ) {
  419.             if ($form->isValid() && ! $email_existe) {
  421.                 $repoClient = $em->getRepository(Client::class);
  422.                 $derclient  = $repoClient->getDernierClient();
  424.                 $derclient  = $derclient + 1;
  425.                 $codeCompta = "411{$derclient}";
  426.                 $codeCompta = "C".str_pad($derclient, 5, '0', STR_PAD_LEFT);
  428.                 $client->setReference($numerotationService->generer($client));
  429.                 $client->setNumeroReference($derclient);
  432.                 //$client->setReference($derclient);
  433.                 $client->setCodeComptable($codeCompta);
  435.                 $post = $request->request->all();
  436.                 if (array_key_exists('joursLivraison', $post)) {
  437.                     $serialize_jours_livraison = serialize($post["joursLivraison"]);
  438.                     $client->setJoursLivraison($serialize_jours_livraison);
  439.                 }
  441.                 $adresses = $client->getAdresses();
  442.                 foreach ($adresses as $adresse) {
  443.                     if ( ! is_object($adresse->getPays())) {
  444.                         //echo "ERREUR PAYS";
  445.                         if (array_key_exists('paysSelect', $post) && $post["paysSelect"] != '') {
  446.                             $post["paysSelect"] = substr($post["paysSelect"], 1, -1);
  448.                             $typePays = $em->getRepository(\App\Entity\Localisation\Type::class)->find(1);
  449.                             $pays     = new Zone();
  450.                             $pays->setTitre($post["paysSelect"]);
  451.                             $pays->setTitreFormat($post["paysSelect"]);
  452.                             $pays->setType($typePays);
  453.                             $pays->setUtilisateur($user);
  455.                             $em->persist($pays);
  456.                             $adresse->setPays($pays);
  458.                             $post = $request->request->all();
  459.                         } else {
  460.                             $adresse->setPays(null);
  461.                         }
  463.                     } else {
  464.                         $pays = $adresse->getPays();
  465.                     }
  467.                     if ( ! is_object($adresse->getVille())) {
  468.                         if (array_key_exists('villeSelectaj', $post) && $post["villeSelect"] != '') {
  469.                             $post["villeSelect"]      = substr($post["villeSelect"], 1, -1);
  470.                             $post["codePostalSelect"] = substr($post["codePostalSelect"], 1, -1);
  472.                             $typeVille = $em->getRepository(Type::class)->find(4);
  473.                             $ville     = new Zone();
  474.                             $ville->setTitre($post["villeSelect"]);
  475.                             $ville->setTitreFormat($post["villeSelect"]);
  476.                             $ville->setCodePostal($post["codePostalSelect"]);
  477.                             $ville->setType($typeVille);
  478.                             $ville->setUtilisateur($user);
  480.                             $em->persist($ville);
  481.                             $adresse->setVille($ville);
  482.                             $adresse->setCodePostal($ville);
  484.                             $post = $request->request->all();
  485.                         } else {
  486.                             $adresse->setVille(null);
  487.                             $adresse->setCodePostal(null);
  488.                         }
  489.                     } else {
  490.                         $ville = $adresse->getVille();
  491.                     }
  492.                 }
  494.                 $em->persist($client);
  495.                 $em->flush();
  496.                 $em->refresh($client);
  498.                 //$clientCategorieService->sauvegarder($client,$request->request->get('categories'));
  499.                 $clientCategorieService->sauvegarder($client, $request->request->get('liste_categorie_client_racine'), $categorie_client_enfants);
  501.                 $clientCategorieRemiseClientService->sauvegarder($client, $request->request->get('categories_remise'));
  503.                 $logo->sauvegarder($client, 'client', $tokenP);
  505.                 $documentClient->sauvegarder($client, 'documents', $tokenP);
  507.                 $this->addFlash(
  508.                     'notice',
  509.                     $translator->trans('Client ajouté avec succès !')
  510.                 );
  512.                 $message_historique            = [];
  513.                 $message_historique["titre"]   = "Création d'un client";
  514.                 $message_historique["message"] = trim($client->getPrenom()." ".$client->getNom());
  515.                 $clientService->creerHistorique($client, 'defaut', $message_historique);
  518.                 if ($client->getEmail() != "") {
  519.                     if ($this->getParameter('domaine_prestashop') != '') {
  520.                         @fopen('http://'.$this->getParameter('domaine_prestashop').'/67PHEAuaps4P4h3/clients.php?id_client='.$client->getId(), 'r');
  521.                     }
  522.                 }
  525.                 return $this->redirectToRoute('dtc_client_modifier', ["id" => $client->getId()]);
  526.                 //return $this->redirectToRoute('dtc_client_liste');
  527.             } else {
  528.                 $errors = $validator->validate($client);
  529.                 if ($email_existe) {
  530.                     $errorsSup[] = 'Adresse email non disponible car elle appartient à '.$client_email->getNom()." ".$client_email->getPrenom()." (".$client_email->getReference().")";
  531.                 }
  532.                 //if(count($categories_remise) == 0) $errorsSup[] = 'Le client n\'a pas de catégorie de remise définie! ';
  533.                 //if(count($categorie_client_enfants) == 0) $errorsSup[] = 'Le client n\'a pas de catégorie définie! ';
  534.             }
  535.         }
  537.         return $this->render('Clients/Client/ajouter.html.twig', ['form' => $form->createView(), 'errors' => $errors, 'errorsSup' => $errorsSup]);
  538.     }
  541.     /**
  542.      * @Route("/client/supprimer/multiple", name="dtc_client_liste_supprimer")
  543.      */
  544.     public function supprimerMultipleAction(Request $request, EntityManagerInterface $em, TranslatorInterface $translator)
  545.     {
  546.         $url = $this->generateUrl('dtc_client_liste', []);
  548.         return new JsonResponse(['url' => $url, 'valide' => '1']);
  550.         $data = $request->get('dataTables');
  551.         $ids  = $data['actions'];
  553.         $em   = $em;
  554.         $repo = $em->getRepository(Client::class);
  556.         for ($i = 0; $i < count($ids); $i++) {
  557.             $v = $repo->find($ids[$i]);
  558.             if (is_object($v)) {
  559.                 $em->remove($v);
  560.             }
  561.         }
  562.         $em->flush();
  563.         $this->addFlash(
  564.             'notice',
  565.             $translator->trans('Clients supprimés avec succès !')
  566.         );
  567.         $url = $this->generateUrl('dtc_client_liste', []);
  569.         return new JsonResponse(['url' => $url, 'valide' => '1']);
  570.     }
  573.     /**
  574.      * @Route("/client/supprimer/{id}", name="dtc_client_supprimer")
  575.      */
  576.     public function supprimerAction(Request $request, Client $client, EntityManagerInterface $em, TranslatorInterface $translator, ValidatorInterface $validator)
  577.     {
  579.         $titre_modal = $translator->trans("Demande de confirmation");
  580.         $user        = $this->getUser();
  582.         $form   = $this->createForm(SupprimerClientType::class, $client);
  583.         $errors = "";
  584.         $form->handleRequest($request);
  585.         if ($form->isSubmitted()) {
  588.             if ($form->isValid()) {
  590.                 $chaine = "XXXXXXX";
  592.                 $client->setNom($chaine);
  593.                 $client->setPrenom($chaine);
  594.                 //$client->setRaisonSociale($chaine);
  595.                 $client->setTelephone($chaine);
  596.                 $client->setTelephone2($chaine);
  597.                 $client->setEmail($chaine);
  598.                 $client->setNumTva($chaine);
  599.                 $client->setCommentaire($chaine);
  600.                 $client->setLogo(null);
  601.                 $client->setPays(null);
  602.                 $client->setVille(null);
  603.                 $client->setCodePostal(null);
  604.                 $client->setSiren($chaine);
  605.                 $client->setSiret($chaine);
  606.                 $client->setIban($chaine);
  607.                 $client->setBic($chaine);
  608.                 $client->setBanque($chaine);
  609.                 $client->setNCpteBanque($chaine);
  611.                 $client->setTva(null);
  612.                 $client->setCivilite(null);
  615.                 $client->setDateSuppression(new \Datetime());
  618.                 $em->persist($client);
  619.                 //$em->remove($client);
  620.                 $em->flush();
  622.                 $this->addFlash('notice', $translator->trans('Client supprimé avec succès !'));
  625.                 $url = $this->generateUrl('dtc_client_liste', []);
  627.                 return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => $url]);
  628.             } else {
  629.                 $errors = $validator->validate($client);
  630.                 $rendu  = $this->renderView('FO/Supprimer/supprimer.html.twig', ['form' => $form->createView(), 'errors' => $errors, 'id' => $client->getId(), 'type' => '']);
  632.                 return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  633.             }
  634.         }
  635.         $rendu = $this->renderView('FO/Supprimer/supprimer.html.twig', ['form' => $form->createView(), 'id' => $client->getId(), 'type' => '', 'errors' => $errors]);
  637.         return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  638.     }
  641.     /**
  642.      * @Route("/client/modifier/{id}", name="dtc_client_modifier")
  643.      * @Route("/client/voir/{id}", name="dtc_client_voir")
  644.      */
  645.     public function modifierAction(Request            $request, Client $client, EntityManagerInterface $em, ClientService $clientService, ClientCategorieService $clientCategorieService,
  646.                                    ClientCategorieRemiseClientService $clientCategorieRemiseClientService, TranslatorInterface $translator,
  647.                                    ValidatorInterface $validator, ZoneService $zoneService, Logo $logoService, DocumentClient $documentService, Datatable $datatable, EmailService $emailService
  648.     ) {
  649.         $user = $this->getUser();
  650.         $client->setUtilisateur($user);
  651.         $form      = $this->createForm(ClientType::class, $client);
  652.         $errors    = "";
  653.         $errorsSup = [];
  654.         $form->handleRequest($request);
  656.         $categories_remise        = $request->request->get('categories_remise');
  657.         $categorie_client_enfants = $request->request->get('categorie_client_enfants');
  660.         $repoDossier = $em->getRepository(Fichier::class);
  661.         $parent      = $repoDossier->find(2);
  662.         $fichier     = $repoDossier->findOneBy(["client" => $client, "type" => "dossier", "parent" => $parent]);
  664.         if ( ! is_object($fichier)) {
  667.             $fichier = new Fichier();
  668.             $fichier->setUtilisateur($user);
  669.             $fichier->setType("dossier");
  670.             $fichier->setRenomme(true);
  671.             $fichier->setSupprimable(false);
  672.             $fichier->setModifiable(false);
  673.             $fichier->setClient($client);
  674.             $fichier->setParent($parent);
  676.             $libelle_ged = trim($client->getReference());
  678.             $fichier->setLIbelle($libelle_ged);
  680.             $em->persist($fichier);
  682.             $enfant2 = new Fichier();
  683.             $enfant2->setUtilisateur($user);
  684.             $enfant2->setType("dossier");
  685.             $enfant2->setRenomme(true);
  686.             $enfant2->setSupprimable(false);
  687.             $enfant2->setModifiable(false);
  688.             $enfant2->setClient($client);
  689.             $enfant2->setParent($fichier);
  690.             $enfant2->setLibelle("Documents");
  692.             $em->persist($enfant2);
  695.             $enfant3 = new Fichier();
  696.             $enfant3->setUtilisateur($user);
  697.             $enfant3->setType("dossier");
  698.             $enfant3->setRenomme(true);
  699.             $enfant3->setSupprimable(false);
  700.             $enfant3->setModifiable(false);
  701.             $enfant3->setClient($client);
  702.             $enfant3->setParent($fichier);
  703.             $enfant3->setLibelle("Divers");
  705.             $em->persist($enfant3);
  708.             $em->flush();
  709.         }
  710.         /*
  711.         $repo_categorie_remise = $em->getRepository('DTCRemisesBundle:CategorieRemiseClient');
  712.         //$categories = $repo_categorie_remise->getCategorieRemiseClient();
  713.         *
  714.         */
  717.         if ($form->isSubmitted()) {
  719.             //vérifier quel champs a été modifié pour l'historique
  720.             $clientService->verifierChampsModifier($client);
  722.             $repo_client = $em->getRepository(Client::class);
  724.             $clientCategorieService->sauvegarder($client, $request->request->get('liste_categorie_client_racine'), $request->request->get('categorie_client_enfants'));
  727.             $clientCategorieRemiseClientService->sauvegarder($client, $categories_remise);
  730.             $email_existe = false;
  732.             $client_email = $repo_client->emailExiste($client);
  734.             if (is_object($client_email)) {
  736.                 $email_existe = true;
  737.             } else {
  738.                 $email_existe = false;
  739.             }
  742.             if ($client->getEmail() == "") {
  743.                 $email_existe = false;
  744.             }
  746.             $a_des_enfants = false;
  747.             if ( ! $client->getGroupe()) {
  748.                 $repo_client   = $em->getRepository(Client::class);
  749.                 $total_enfants = $repo_client->getTotalEnfantClient($client);
  750.                 if ($total_enfants["total"] > 0) {
  751.                     $a_des_enfants = true;
  752.                     $client->setGroupe(true);
  753.                 }
  754.             }
  757.             //if ($form->isValid() && !$email_existe && count($categories_remise)>0 && count($categorie_client_enfants) > 0 ) {
  758.             if ($form->isValid() && ! $email_existe && ! $a_des_enfants) {
  759.                 //if ($form->isValid() && count($categories_remise)>0 && count($categorie_client_enfants)>0 ) {
  762.                 $droit = $this->isGranted(EntityVoter::UPDATE, Client::class);
  764.                 if ( ! $droit) {
  765.                     return $this->redirectToRoute('dtc_client_modifier', ["id" => $client->getId()]);
  766.                 }
  768.                 if ($client->getPrenom() == "") {
  769.                     $client->setPrenom("  ");
  770.                 }
  771.                 if ($client->getNom() == "") {
  772.                     $client->setNom("  ");
  773.                 }
  774.                 $post = $request->request->all();
  775.                 if (array_key_exists('joursLivraison', $post)) {
  776.                     $serialize_jours_livraison = serialize($post["joursLivraison"]);
  777.                     $client->setJoursLivraison($serialize_jours_livraison);
  778.                 }
  781.                 $em->persist($client);
  782.                 $em->flush();
  783.                 //echo    count($client->getCategorieRemiseClientClient());
  784.                 /*
  785.                 $clientCategorieService = $this->container->get('dtc.clientcategorie');
  786.                 $clientCategorieService->sauvegarder($client,$request->request->get('liste_categorie_client_racine'),$request->request->get('categorie_client_enfants'));
  788.                 $clientCategorieRemiseClientService = $this->container->get('dtc.clientcategorieremiseclient');
  789.                 $clientCategorieRemiseClientService->sauvegarder($client,$categories_remise);
  790.                 */
  791.                 $villeSelect      = $request->request->get('villeSelect');
  792.                 $codePostalSelect = $request->request->get('codePostalSelect');
  793.                 //echo $villeSelect.' - '.$codePostalSelect;
  795.                 $zoneService->sauvegarder($client, 'client', ['ville' => $request->request->get('villeSelect'), 'codePostal' => $request->request->get('codePostalSelect')]);
  797.                 $logoService->sauvegarder($client, 'client');
  799.                 $documentService->sauvegarder($client, 'documents');
  801.                 $this->addFlash('notice', $translator->trans('Client sauvegardé avec succès !!'));
  804.                 $message_historique            = [];
  805.                 $message_historique["titre"]   = "Modification du client";
  806.                 $message_historique["message"] = trim($client->getPrenom()." ".$client->getNom());
  807.                 $clientService->creerHistorique($client, 'defaut', $message_historique);
  810.                 if ($client->getEmail() != "") {
  811.                     if ($this->getParameter('domaine_prestashop') != '') {
  812.                         @fopen('http://'.$this->getParameter('domaine_prestashop').'/67PHEAuaps4P4h3/clients.php?id_client='.$client->getId(), 'r');
  813.                     }
  814.                 }
  817.                 return $this->redirectToRoute('dtc_client_modifier', ["id" => $client->getId()]);
  818.             } else {
  819.                 //$errors = array();
  820.                 $errors = $validator->validate($client);
  821.                 if ($email_existe) {
  822.                     $errorsSup[] = 'Adresse email non disponible car elle appartient à '.$client_email->getNom()." ".$client_email->getPrenom()." (".$client_email->getReference().")";
  823.                 }
  824.                 if ($a_des_enfants) {
  825.                     $errorsSup[] = 'Le client a encore des enfants, il est obligatoirement un groupe';
  826.                 }
  827.                 //if(count($categorie_client_enfants) == 0) $errorsSup[] = 'Le client n\'a pas de catégorie définie! ';
  828.             }
  829.         }
  830.         $this->datatableVehicules($client, $datatable, $translator);
  831.         $this->datatableCommandes($client, $datatable, $translator);
  832.         $this->datatableRemises($client, $datatable, $translator);
  833.         $this->datatableNotes($client, $datatable, $translator);
  835.         $modal = $request->query->get('modal');
  837.         $caMois = [];
  838.         $param  = $request->query->all();
  839.         if ($request->isMethod('GET') and array_key_exists('operation', $param) and $param["operation"] == "stats") {
  841.         } else {
  842.             $param     = [];
  843.             $dateDebut = new \DateTime();
  844.             $dateDebut->sub(new \DateInterval('P1Y'));
  845.             $dateFin = new \DateTime();
  847.             $param['date_debut'] = $dateDebut->format("m/Y");
  848.             $param['date_fin']   = $dateFin->format("m/Y");
  849.             $param['n1']         = 0;
  850.         }
  851.         $repoCommande = $em->getRepository(Commande::class);
  852.         //$valeurs =  $repoCommande->suiviConsommation($param);
  853.         $param['client'] = $client->getId();
  854.         $caMois          = $repoCommande->caMois($param);
  856.         //print_r($caMois);
  857.         $caAnnee          = $repoCommande->caAnnee($client);
  858.         $caAnneeN1        = $repoCommande->caAnneeN1($client);
  859.         $date1ereCommande = $repoCommande->getDate1ereCommandeClient($client);
  861.         if ($modal != 1) {
  862.             return $this->render('Clients/Client/modifier.html.twig', [
  863.                 'form'             => $form->createView(),
  864.                 'errors'           => $errors,
  865.                 'client'           => $client,
  866.                 "parametres"       => $param,
  867.                 "caMois"           => $caMois,
  868.                 'errorsSup'        => $errorsSup,
  869.                 'caAnnee'          => $caAnnee,
  870.                 'caAnneeN1'        => $caAnneeN1,
  871.                 'date1ereCommande' => $date1ereCommande,
  872.                 //'connexionSmtp' => $emailService->getConnexionSmtpClient($client)
  873.             ]);
  874.         } else {
  875.             $titre_modal = 'Client '.$client->getPrenom().' '.$client->getNom();
  876.             $rendu       = $this->renderView('Clients/Client/ajouter_modal2.html.twig', [
  877.                 'form'             => $form->createView(),
  878.                 'errors'           => $errors,
  879.                 'client'           => $client,
  880.                 'errorsSup'        => $errorsSup,
  881.                 'caAnnee'          => $caAnnee,
  882.                 'caAnneeN1'        => $caAnneeN1,
  883.                 'date1ereCommande' => $date1ereCommande,
  884.             ]);
  886.             return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  887.         }
  888.     }
  891.     /**
  892.      * @Route("/client", name="dtc_client_liste")
  893.      * @Route("/parc-materiel/{id}/{type}", name="dtc_parc_materiel_liste")
  894.      * @Route("/frais-port-fournisseur/{id}/{type}", name="dtc_fournisseur_frais_port_liste")
  895.      * @Route("/contact/{id}/{type}", name="dtc_contact_liste")
  896.      */
  897.     public function listerAction(Request $request, EntityManagerInterface $em, ColonneTableauService $serviceColonneTableau, Datatable $datatable, TranslatorInterface $translator)
  898.     {
  900.         $tableau_class_cellule[] = ["className" => " colonne_id", "targets" => [0], "visible" => false, "orderable" => false, "searchable" => false];
  901.         $tableau_class_cellule[] = [
  902.             "className" => "visible_export colonne_id",
  903.             "targets"   => [1],
  904.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(Client::class, "id"),
  905.         ];
  906.         $tableau_class_cellule[] = [
  907.             "className" => "visible_export colonne_id",
  908.             "targets"   => [2],
  909.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(Client::class, "logo"),
  910.         ];
  911.         $tableau_class_cellule[] = [
  912.             "className" => "visible_export colonne_id",
  913.             "targets"   => [3],
  914.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(Client::class, "reference"),
  915.         ];
  916.         $tableau_class_cellule[] = [
  917.             "className" => "visible_export colonne_id",
  918.             "targets"   => [4],
  919.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(Client::class, "nom"),
  920.         ];
  921.         $tableau_class_cellule[] = [
  922.             "className" => "visible_export colonne_id",
  923.             "targets"   => [5],
  924.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(Client::class, "prenom"),
  925.         ];
  926.         $tableau_class_cellule[] = [
  927.             "className" => "visible_export colonne_id",
  928.             "targets"   => [6],
  929.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(Client::class, "ville"),
  930.         ];
  931.         $tableau_class_cellule[] = [
  932.             "className" => "visible_export colonne_id",
  933.             "targets"   => [7],
  934.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(Client::class, "codePostal"),
  935.         ];
  936.         $tableau_class_cellule[] = [
  937.             "className" => "visible_export colonne_id",
  938.             "targets"   => [8],
  939.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(Client::class, "pays"),
  940.         ];
  941.         $tableau_class_cellule[] = [
  942.             "className" => "visible_export colonne_id",
  943.             "targets"   => [9],
  944.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(Client::class, "telephone"),
  945.         ];
  946.         $tableau_class_cellule[] = [
  947.             "className" => "visible_export colonne_id",
  948.             "targets"   => [10],
  949.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(Client::class, "telephone2"),
  950.         ];
  951.         $tableau_class_cellule[] = [
  952.             "className" => "visible_export colonne_id",
  953.             "targets"   => [11],
  954.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(Client::class, "email"),
  955.         ];
  956.         $tableau_class_cellule[] = [
  957.             "className" => "visible_export colonne_id",
  958.             "targets"   => [12],
  959.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(Client::class, "tva"),
  960.         ];
  961.         $tableau_class_cellule[] = ["className" => "visible_export colonne_id", "targets" => [13], "visible" => true];
  962.         $tableau_class_cellule[] = ["orderable" => false, "className" => "colonne_id text-center", "targets" => [14], "visible" => true];
  964.         $this->datatable($request, $datatable, $translator);
  966.         $categorie_enfants       = [];
  967.         $repo_categorie_client   = $em->getRepository(Categorie::class);
  968.         $categorie_client_racine = $repo_categorie_client->findBy(["modifiable" => 0]);
  970.         $param = $request->query->all();
  972.         if (array_key_exists('categorie_client', $param) and $param["categorie_client"] > 0) {
  973.             $parent = $repo_categorie_client->find($param["categorie_client"]);
  974.             if (is_object($parent)) {
  975.                 $categorie_enfants = $repo_categorie_client->findBy(["categorieParent" => $parent]);
  976.             }
  978.         }
  979.         $parametres = [];
  981.         //$parametres["parametres"] = $param;
  983.         return $this->render('Clients/Client/lister.html.twig', [
  984.             'parametres'            => $param,
  985.             "categorie_client"      => $categorie_client_racine,
  986.             "sous_categorie_client" => $categorie_enfants,
  987.             'tableauClassColonne'   => $tableau_class_cellule,
  988.         ]);
  990.     }
  992.     /**
  993.      * set datatable configs
  994.      *
  995.      * @return \App\Library\Datatable\Util\Datatable
  996.      */
  997.     private function datatable(Request $request, Datatable $datatable, TranslatorInterface $translator)
  998.     {
  1000.         $param = $request->query->all();
  1002.         $datatable->setEntity(Client::class, "x")
  1003.                   ->setFields(
  1004.                       [
  1005.                           $translator->trans("ID")          => 'x.id',
  1006.                           $translator->trans("Logo")        => 'x.logo',
  1007.                           $translator->trans("Réf")         => 'x.reference',
  1008.                           $translator->trans("Nom")         => 'x.nom',
  1009.                           $translator->trans("Prénom")      => 'x.prenom',
  1010.                           $translator->trans("Ville")       => 'v.titre',
  1011.                           $translator->trans("CP")          => 'cp.codePostal',
  1012.                           $translator->trans("Pays")        => 'p.titre',
  1013.                           $translator->trans("Téléphone")   => 'x.telephone',
  1014.                           $translator->trans("Téléphone 2") => 'x.telephone2',
  1015.                           $translator->trans("Email")       => 'x.email',
  1016.                           $translator->trans("TVA")         => 'x.numTva',
  1017.                           $translator->trans("Catégorie")   => 'x.id',
  1019.                           $translator->trans("Actions") => 'x.id',
  1020.                           "_identifier_"                => 'x.id',
  1021.                       ]
  1022.                   )
  1023.                   ->addJoin('x.ville', 'v', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1024.                   ->addJoin('x.pays', 'p', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1025.                   ->addJoin('x.codePostal', 'cp', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1026.                   ->addJoin('x.typeClient', 'tp', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1027.                   ->setRenderers(
  1028.                       [
  1029.                           0 => [
  1030.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  1031.                               'params' => [
  1032.                                   'edit_route' => 'dtc_client_modifier',
  1033.                               ],
  1035.                           ],
  1036.                           1 => [
  1037.                               'view'   => 'FO/DataTable/logo.html.twig',
  1038.                               'params' => [
  1039.                                   'edit_route' => 'dtc_client_modifier',
  1040.                               ],
  1042.                           ],
  1044.                           2 => [
  1045.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  1046.                               'params' => [
  1047.                                   'edit_route' => 'dtc_client_modifier',
  1048.                               ],
  1050.                           ],
  1052.                           12 => [
  1053.                               'view'   => 'FO/DataTable/categorie_client.html.twig',
  1054.                               'params' => [],
  1056.                           ],
  1057.                           13 => [
  1058.                               'view'   => 'FO/DataTable/actions.html.twig',
  1059.                               'params' => [
  1060.                                   'edit_route'           => 'dtc_client_modifier',
  1061.                                   'dupliquer_route'      => 'dtc_client_dupliquer',
  1062.                                   'supprimer_route'      => 'dtc_client_supprimer',
  1063.                                   'objet'                => Client::class,
  1064.                                   'afficher_route_popin' => 'dtc_client_afficher_modal',
  1065.                               ],
  1066.                           ],
  1068.                       ]
  1069.                   )
  1070.                   ->setMultiple(
  1071.                       [
  1072.                           'delete' => [
  1073.                               'title' => 'Non disponible',
  1074.                               'route' => 'dtc_client_liste_supprimer',
  1075.                           ],
  1076.                       ]
  1077.                   )
  1079.             //->setFilteringType(array(6 => 'e',5 => 'e'))
  1080.                   ->setFilteringType([3 => 'e', 6 => 'e', 5 => 'e'])
  1081.                   ->setOrder("x.nom", "asc")
  1082.                   ->setSearch(true)
  1083.                   ->setSearchFields([2, 3, 4, 5, 6, 7, 8, 9, 10]);
  1086.         /*
  1087.            ->setWhere(
  1088.                          'x.commande = :objet AND x.typeDocumentCommercial = :typeDocumentCommercial',
  1089.                          array('objet' => $objet,'typeDocumentCommercial' => TypeDocumentCommercial::ORDREREPARATION)
  1090.                     )
  1091.          */
  1092.         $where      = "";
  1093.         $parameters = [];
  1096.         if (array_key_exists('parametres', $param)) {
  1097.             if (array_key_exists('categorie_client', $param["parametres"]) and $param["parametres"]["categorie_client"] > 0) {
  1098.                 //echo "AZERTYUI";
  1099.                 $datatable->addJoin('x.clientCategorie', 'cc', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN);
  1100.                 $datatable->addJoin('cc.categorie', 'catC', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN);
  1101.                 $parameters["categorie"] = $param["parametres"]["categorie_client"];
  1102.                 $where                   .= "catC = :categorie";
  1104.                 if (array_key_exists('sous_categorie_client', $param["parametres"]) and $param["parametres"]["sous_categorie_client"] > 0) {
  1106.                     $datatable->addJoin('x.clientCategorie', 'cc2', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN);
  1107.                     $datatable->addJoin('cc2.categorie', 'catC2', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN);
  1109.                     $parameters["sous_categorie"] = $param["parametres"]["sous_categorie_client"];
  1110.                     $where                        .= " and catC2 = :sous_categorie";
  1111.                 }
  1113.             }
  1114.             if (array_key_exists('doublons', $param["parametres"])) {
  1115.                 $this->creerDoublons();
  1116.                 if ($where != '') {
  1117.                     $where .= ' and ';
  1118.                 }
  1119.                 $where .= 'x.doublon = 1';
  1120.             }
  1123.             if (array_key_exists('archive', $param["parametres"])) {
  1124.                 if ($where != '') {
  1125.                     $where .= ' and ';
  1126.                 }
  1127.                 $where                 .= '(x.archive = :archive)';
  1128.                 $parameters["archive"] = 1;
  1129.             }
  1131.         } else {
  1132.             if ($where != '') {
  1133.                 $where .= ' and ';
  1134.             }
  1135.             $where                 .= '(x.archive = :archive or x.archive is NULL)';
  1136.             $parameters["archive"] = 0;
  1137.         }
  1140.         if ($where != '') {
  1141.             //echo $where;
  1142.             $datatable->setWhere($where, $parameters);
  1143.         }
  1146.         //$datatable->setSearchFields(array(0,2));
  1147.         return $datatable;
  1148.     }
  1150.     private function creerDoublons(EntityManagerInterface $em)
  1151.     {
  1152.         $repo_client = $em->getRepository(Client::class);
  1153.         $conn        = $em->getConnection();
  1154.         $sql         = 'UPDATE client__client SET doublon = NULL WHERE doublon = 1';
  1155.         $tmp         = $conn->prepare($sql);
  1156.         $tmp->executeQuery();
  1158.         $sql = 'SELECT count(id) as total, id, nom, prenom FROM `client__client` WHERE 1 GROUP BY nom, prenom having total > 1';
  1159.         $tmp = $conn->prepare($sql);
  1160.         $tmp = $tmp->executeQuery();
  1161.         foreach ($tmp->fetchAllAssociative() as $res) {
  1162.             $clients = $repo_client->findBy(['nom' => $res['nom'], 'prenom' => $res['prenom']]);
  1163.             foreach ($clients as $client) {
  1164.                 $client->setDoublon(true);
  1165.                 $em->persist($client);
  1166.             }
  1167.         }
  1168.         $em->flush();
  1169.     }
  1172.     /**
  1173.      * Grid action
  1174.      * @return Response
  1175.      */
  1176.     /**
  1177.      * @Route("/client/grid", name="dtc_client_liste_grid")
  1178.      */
  1179.     public function gridAction(Request $request, Datatable $datatable, TranslatorInterface $translator)
  1180.     {
  1181.         return $this->datatable($request, $datatable, $translator)->execute();
  1182.     }
  1185.     /**
  1186.      * @Route("/client/recherche", name="dtc_client_recherche")
  1187.      */
  1188.     public function rechercheAction(Request $request, EntityManagerInterface $em, PaginatorInterface $paginator, AcompteService $serviceAcompte)
  1189.     {
  1191.         $q            = $request->query->get('q');
  1192.         $parent       = $request->query->get('parent');
  1193.         $repo         = $em->getRepository(Client::class);
  1194.         $repo_adresse = $em->getRepository(Adresse::class);
  1195.         $results      = $repo->getRechercheClient(trim($q), $parent);
  1196.         $tabClient    = [];
  1198.         for ($i = 0; $i < count($results); $i++) {
  1200.             if (is_null($results[$i]["cmp_id"]) or $results[$i]["cmp_id"] == 0) {
  1201.                 $c = $repo->find($results[$i]["id"]);
  1202.                 //$montant = $serviceAcompte->getMontantRembousement($c);
  1203.                 $montant = $serviceAcompte->getSoldeClient($c);
  1204.                 //$montant = str_replace("-","",$montant);
  1205.                 //echo "JJJJ ".$results[$i]["reference"];
  1206.             } else {
  1207.                 $montant = 0;
  1208.             }
  1211.             $results[$i]["avoir"] = round($montant, 2);
  1212.             //print_r($results[$i]);
  1213.             //echo "<div><hr/></div>";
  1214.         }
  1217.         $pagination = $paginator->paginate(
  1218.             $results, /* query NOT result */
  1219.             $request->query->getInt('page', 1)/*page number*/,
  1220.             10/*limit per page*/
  1221.         );
  1223.         $pagination_results = $pagination->getItems();
  1225.         if (count($pagination_results) > 0) {
  1226.             for ($i = 0; $i < count($pagination_results); $i++) {
  1228.                 $client_obj = $repo->find($pagination_results[$i]["id"]);
  1230.                 if (is_object($client_obj)) {
  1232.                     $adresse         = $repo_adresse->findOneBy(['client' => $client_obj, 'visible' => 1, 'facturationDefaut' => 1]);
  1233.                     $libelle_adresse = "";
  1235.                     if (is_object($adresse)) {
  1237.                         if (is_object($adresse->getCodePostal())) {
  1238.                             $libelle_adresse .= " ".$adresse->getCodePostal()->getCodePostal();
  1239.                         }
  1240.                         if (is_object($adresse->getVille())) {
  1241.                             $libelle_adresse .= " ".$adresse->getVille()->getTitre();
  1242.                         }
  1244.                     } else {
  1245.                         $adresse = $repo_adresse->findOneBy(['client' => $client_obj, 'visible' => 1]);
  1247.                         if (is_object($adresse) && is_object($adresse->getCodePostal())) {
  1248.                             $libelle_adresse .= " ".$adresse->getCodePostal()->getCodePostal();
  1249.                         }
  1250.                         if (is_object($adresse) && is_object($adresse->getVille())) {
  1251.                             $libelle_adresse .= " ".$adresse->getVille()->getTitre();
  1252.                         }
  1254.                     }
  1257.                     $pagination_results[$i]["libelle"] = trim($pagination_results[$i]["libelle"]." (".$pagination_results[$i]["reference"]." ".trim($libelle_adresse).")");
  1260.                 }
  1263.             }
  1264.         }
  1267.         $option_placeholde = ["libelle" => "Sélectionnez", "id" => ""];
  1268.         if ($request->query->getInt('page', 1) == 1) {
  1269.             array_unshift($pagination_results, $option_placeholde);
  1270.         }
  1271.         $pagination->setItems($pagination_results);
  1273.         $serializer = SerializerBuilder::create()->build();
  1274.         return JsonResponse::fromJsonString($serializer->serialize($pagination, 'json'));
  1276.     }
  1278.     /**
  1279.      * set datatable configs
  1280.      *
  1281.      * @return \App\Library\Datatable\Util\Datatable
  1282.      */
  1283.     private function datatableVehicules($client, Datatable $datatable, TranslatorInterface $translator)
  1284.     {
  1285.         $datatable->setDatatableId('dta-vehicules')
  1286.                   ->setEntity(VehiculeClient::class, "x")
  1287.                   ->setFields(
  1288.                       [
  1289.                           $translator->trans("ID")        => 'x.id',
  1290.                           $translator->trans("Image")     => 'x.id',
  1291.                           $translator->trans("Libellé")   => 'x.libelle',
  1292.                           $translator->trans("Marque")    => 'm.libelle',
  1293.                           $translator->trans("Modèle")    => 'mod.libelle',
  1294.                           $translator->trans("Type")      => 't.libelle',
  1295.                           $translator->trans("Clt")       => 'c.nom',
  1296.                           $translator->trans("Km")        => 'x.kilometrage',
  1297.                           $translator->trans("Puissance") => 'x.puissance',
  1298.                           $translator->trans("Immat")     => 'x.immatriculation',
  1299.                           $translator->trans("Num série") => 'x.numSerie',
  1300.                           $translator->trans("Date CT")   => 'x.dateControleTechnique',
  1301.                           $translator->trans("Actions")   => 'x.id',
  1302.                           "_identifier_"                  => 'x.id',
  1303.                       ]
  1304.                   )
  1305.                   ->addJoin('x.marque', 'm', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1306.                   ->addJoin('x.modele', 'mod', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1307.                   ->addJoin('x.type', 't', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1308.                   ->addJoin('x.client', 'c', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1309.                   ->setWhere(
  1310.                       'x.client = :client',
  1311.                       ['client' => $client]
  1312.                   )
  1313.                   ->setRenderers(
  1314.                       [
  1315.                           0 => [
  1316.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  1317.                               'params' => [
  1318.                                   'edit_route' => 'dtc_vehicule_client_modifier',
  1319.                               ],
  1321.                           ],
  1322.                           2 => [
  1323.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  1324.                               'params' => [
  1325.                                   'edit_route' => 'dtc_vehicule_client_modifier',
  1326.                               ],
  1328.                           ],
  1329.                           1 => [
  1330.                               'view'   => 'FO/DataTable/image.html.twig',
  1331.                               'params' => [
  1332.                                   'edit_route' => 'dtc_vehicule_client_modifier',
  1333.                               ],
  1335.                           ],
  1337.                           3  => [
  1338.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  1339.                               'params' => [
  1340.                                   'edit_route'   => 'dtc_vehicule_marque_modifier',
  1341.                                   'typeDocument' => 'marqueVehicule',
  1342.                               ],
  1344.                           ],
  1345.                           4  => [
  1346.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  1347.                               'params' => [
  1348.                                   'edit_route'   => 'dtc_vehicule_modele_modifier',
  1349.                                   'typeDocument' => 'modeleVehicule',
  1350.                               ],
  1352.                           ],
  1353.                           11 => [
  1354.                               'view' => 'FO/DataTable/date.html.twig',
  1357.                           ],
  1358.                           12 => [
  1359.                               'view'   => 'FO/DataTable/actions_modal.html.twig',
  1360.                               'params' => [
  1362.                                   'edit_route'      => 'dtc_vehicule_client_modifier',
  1363.                                   'type'            => '',
  1364.                                   //'dupliquer_route'    => 'dtc_vehicule_client_dupliquer',
  1365.                                   'supprimer_route' => 'dtc_vehicule_client_supprimer',
  1366.                                   'objet'           => VehiculeClient::class,
  1367.                                   'table'           => 'dta-vehicules',
  1368.                               ],
  1369.                           ],
  1371.                       ]
  1372.                   )
  1373.                   ->setOrder("x.id", "desc")
  1374.                   ->setSearch(true)
  1375.                   ->setSearchFields([2, 3, 4, 5, 6]);
  1377.         return $datatable;
  1378.     }
  1381.     /**
  1382.      * Grid action
  1383.      * @return Response
  1384.      */
  1385.     /**
  1386.      * @Route("/client/vehicule/grid/{id}", name="dtc_client_vehicule_liste_grid")
  1387.      */
  1388.     public function gridVehiculesAction(Request $request, Client $client, Datatable $datatable, TranslatorInterface $translator)
  1389.     {
  1390.         return $this->datatableVehicules($client, $datatable, $translator)->execute();
  1391.     }
  1393.     /**
  1394.      * @Route("/commande/charger-tableau/{id}", name="dtc_client_commande_charger_tableau")
  1395.      */
  1396.     public function chargerTableauAction(Request $request, Client $client)
  1397.     {
  1398.         $rendu = $this->renderView('GestionComerciale/Commande/charger_tableau.html.twig', ["client" => $client]);
  1400.         return new JsonResponse(['rendu' => $rendu]);
  1402.     }
  1404.     /**
  1405.      * @Route("", name="")
  1406.      */
  1407.     public function listerCommandeClientAction(Request $request, Client $client, Datatable $datatable, TranslatorInterface $translator)
  1408.     {
  1410.         $tableau_class_cellule = [];
  1411.         //$tableau_class_cellule[]=array("className"=>" colonne_id","targets"=>array(0),"visible"=>false,"orderable"=>false,"searchable"=> false);
  1412.         $this->datatableCommandes($client, $datatable, $translator);
  1414.         return $this->render('GestionComerciale/Commande/lister-client.html.twig', ['tableauClassColonne' => $tableau_class_cellule, 'client' => $client]);
  1415.     }
  1418.     /**
  1419.      * set datatable configs
  1420.      *
  1421.      * @return \App\Library\Datatable\Util\Datatable
  1422.      */
  1423.     private function datatableCommandes($client, Datatable $datatable, TranslatorInterface $translator)
  1424.     {
  1426.         $datatable->setDatatableId('dta-commandes')
  1427.                   ->setEntity(Commande::class, "x")
  1428.                   ->setFields(
  1429.                       [
  1430.                           //$translator->trans("ID") =>  'x.id',
  1431.                           $translator->trans("Date")      => 'x.date',
  1432.                           $translator->trans("Réf")       => 'x.reference',
  1433.                           $translator->trans("Type")      => 'x.id',
  1434.                           $translator->trans("Total HT")  => 'x.total',
  1435.                           $translator->trans("Total TTC") => 'x.totalTtc',
  1436.                           $translator->trans("Payé ?")    => 'x.id',
  1437.                           $translator->trans("Actions")   => 'x.id',
  1438.                           "_identifier_"                  => 'x.id',
  1439.                       ]
  1440.                   )
  1441.                   ->addJoin('x.statutCommande', 's', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1442.                   //->addJoin('x.typeDocumentCommercial', 't', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1443.             //->addJoin('x.blsCommande', 'bl', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1444.             //->addJoin('x.bps', 'bp', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1445.             //->addJoin('x.docEnfantsDevis', 'ded', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1446.             //->addJoin('x.docEnfantsCommande', 'dec', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1447.             //->addJoin('dec.typeDocumentCommercial', 'dect', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1448.             //->addJoin('x.docEnfantsBP', 'debp', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1449.             //->addJoin('x.docEnfantsBL', 'debl', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1450.                   ->setRenderers(
  1451.                 [
  1452.                     0 => [
  1453.                         'view'   => 'FO/DataTable/heure.html.twig',
  1454.                         'params' => [],
  1455.                     ],
  1456.                     1 => [
  1457.                         'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  1458.                         'params' => [
  1459.                             'edit_route'   => 'auto',
  1460.                             'typeDocument' => "",
  1461.                         ],
  1462.                     ],
  1463.                     3 => [
  1464.                         'view' => 'FO/DataTable/total_ht_commande.html.twig',
  1466.                     ],
  1467.                     4 => [
  1468.                         'view' => 'FO/DataTable/prix.html.twig',
  1470.                     ],
  1471.                     5 => [
  1472.                         'view' => 'FO/DataTable/facture_est_paye_solde.html.twig',
  1474.                     ],
  1475.                     6 => [
  1476.                         'view'   => 'FO/DataTable/actions.html.twig',
  1477.                         'params' => [
  1479.                             'edit_route' => 'auto',
  1480.                             'pdf_route'  => 'auto',
  1481.                             'objet'      => Commande::class,
  1482.                             'deplier'    => 'true',
  1485.                         ],
  1486.                     ],
  1488.                 ]
  1489.             )
  1490.                   ->setOrder("x.id", "desc")
  1491.                   ->setSearch(true)
  1492.                   ->setSearchFields([1, 2]);
  1495.         /*
  1496.         $where = "x.typeDocumentCommercial = :typeDocumentCommercial and x.origineSaisie IN (:origineSaisie) AND x.visible=:visible";
  1497.         $parameters = array('typeDocumentCommercial' => TypeDocumentCommercial::COMMANDE,"visible"=>"1",'origineSaisie'=>array("commande","devis","bp"));
  1498.         */
  1500.         //$where = "x.client = :client AND x.typeDocumentCommercial IN (:typeDocumentCommercial) and x.origineSaisie IN (:origineSaisie) AND x.visible=:visible";
  1501.         //$parameters = array('client' => $client,"typeDocumentCommercial"=>array("2","1","3","6","10","7"),"visible"=>"1",'origineSaisie'=>array("commande","devis","bp"));
  1503.         /*
  1504.     $where = "x.client = :client AND x.typeDocumentCommercial IN (:typeDocumentCommercial) and x.origineSaisie IN (:origineSaisie)";
  1505.     $parameters = array('client' => $client,"typeDocumentCommercial"=>array("2","1","3","6","10","7"),'origineSaisie'=>array("commande","devis","bp"));
  1507.     $typeCmde = array("2");
  1508.     $typeDoc = array("1","3","6","10","7");
  1509.          *
  1510.          */
  1511.         /*
  1512.             13     Ordre de fabrication multiple
  1513.             12     Facture fournisseur
  1514.             11     Bon de préparation atelier
  1515.             10     Devis OR
  1516.             9     Ordre de fabrication
  1517.             8     Commande fournisseur
  1518.             7     Avoir
  1519.             6     Facture
  1520.             5     Bon de livraison
  1521.             4     Bon de préparation
  1522.             3     Ordre de réparation
  1523.             2     Commande
  1524.             1     Devis
  1525.         */
  1527.         //$typeDoc = ["1", "2", "3", "4", "5", "6", "7", "10"];
  1528.         $typeDoc = array(
  1529.             TypeDocumentCommercial::DEVIS,
  1530.             TypeDocumentCommercial::COMMANDE,
  1531.             TypeDocumentCommercial::ORDREREPARATION,
  1532.             TypeDocumentCommercial::BP,
  1533.             TypeDocumentCommercial::BL,
  1534.             TypeDocumentCommercial::FACTURE,
  1535.             TypeDocumentCommercial::AVOIR,
  1536.             TypeDocumentCommercial::DEVISOR
  1537.         );
  1538. //$typeDoc = array(3);
  1539.         $where      = "    x.client = :client
  1540.                     AND
  1541.                     x.dateSuppression IS NULL
  1542.                     AND
  1543.                     (s.ordre != :ordreStatutDoc or (x.typeDocumentCommercial = 1))
  1545.                 ";
  1546.         $parameters = ['client' => $client, "typeDocumentCommercial" => $typeDoc, 'ordreStatutDoc' => '0'];
  1549.         $parameters = ['client' => $client, 'ordreStatutDoc' => '0'];
  1550.         $where      = "    x.client = :client
  1552.                     AND x.dateSuppression IS NULL
  1553.                     AND (s.ordre != :ordreStatutDoc or (x.typeDocumentCommercial = 1))";
  1556.         $where      .= " AND (";
  1557.         //AND t.id IN (:typeDocumentCommercial)
  1558.         //$where .= " ded.id IS NULL AND (dec.id IS NULL OR dect.id IN (11)) AND debp.id IS NULL AND debl.id IS NULL";
  1559.         //$where .= " OR (t.id IN (:typeDocumentCommercial))";//dect.id NOT IN (11)
  1560.         $where .= " (x.typeDocumentCommercial = ".TypeDocumentCommercial::ORDREREPARATION." AND x.statutCommande IN (14,15))";//Ordre de réparation
  1561.         $where .= " OR (x.typeDocumentCommercial = ".TypeDocumentCommercial::DEVIS." AND x.visible = 1 AND x.commande IS NULL)";//Devis
  1562.         $where .= " OR (x.typeDocumentCommercial = ".TypeDocumentCommercial::DEVISOR." AND x.visible = 1 AND x.commande IS NULL)";//Devis OR
  1563.         $where .= " OR (x.typeDocumentCommercial = ".TypeDocumentCommercial::COMMANDE." AND x.visible= 1 )";//Commande
  1564.         //$where .= " OR (x.typeDocumentCommercial = ".TypeDocumentCommercial::BL." AND x.visible= 1 AND x.facture IS NULL)";//BL
  1565.         $where .= " OR (x.typeDocumentCommercial = ".TypeDocumentCommercial::BL." AND x.visible= 1)";//BL
  1566.         $where .= " OR (x.typeDocumentCommercial IN (4, 6, 7) AND x.visible= 1)";//bp, facture, avoir
  1567.         //$where .= " OR (x.typeDocumentCommercial = ".TypeDocumentCommercial::COMMANDE.")";
  1568.         $where .= ")";
  1573.         $datatable->setWhere($where, $parameters);
  1575.         //echo $where;
  1576.         //print_r($parameters);
  1577.         //exit;
  1579.         return $datatable;
  1580.     }
  1583.     /**
  1584.      * Grid action
  1585.      * @return Response
  1586.      */
  1587.     /**
  1588.      * @Route("/client/commande/grid/{id}", name="dtc_client_commande_liste_grid")
  1589.      */
  1590.     public function gridCommandesAction(Request $request, Client $client, Datatable $datatable, TranslatorInterface $translator)
  1591.     {
  1592.         return $this->datatableCommandes($client, $datatable, $translator)->execute();
  1593.     }
  1595.     /**
  1596.      * @Route("", name="")
  1597.      */
  1598.     public function listerPiecesAction(Request $request, Client $client, ColonneTableauService $serviceColonneTableau, Datatable $datatable, TranslatorInterface $translator)
  1599.     {
  1601.         $tableau_class_cellule[] = ["className" => "visible_export colonne_id", "targets" => [0], "visible" => false];
  1602.         $tableau_class_cellule[] = [
  1603.             "className" => "visible_export colonne_id",
  1604.             "targets"   => [1],
  1605.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(Article::class, "reference"),
  1606.         ];
  1607.         $tableau_class_cellule[] = [
  1608.             "className" => "visible_export colonne_id",
  1609.             "targets"   => [2],
  1610.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(ArticleCommande::class, "libelle"),
  1611.         ];
  1612.         $tableau_class_cellule[] = [
  1613.             "className" => "visible_export colonne_id text-center",
  1614.             "targets"   => [3],
  1615.             "visible"   => $serviceColonneTableau->getColonneUtilisateur("TCClientsBundle:ArticleCommande", "date"),
  1616.         ];
  1617.         $tableau_class_cellule[] = [
  1618.             "className" => "visible_export colonne_id",
  1619.             "targets"   => [4],
  1620.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(Commande::class, "reference"),
  1621.         ];
  1622.         $tableau_class_cellule[] = [
  1623.             "className" => "visible_export colonne_id text-center",
  1624.             "targets"   => [5],
  1625.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(ArticleCommande::class, "quantite"),
  1626.         ];
  1627.         $tableau_class_cellule[] = [
  1628.             "className" => "visible_export colonne_id text-right",
  1629.             "targets"   => [6],
  1630.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(ArticleCommande::class, "prixBase"),
  1631.         ];
  1632.         $tableau_class_cellule[] = [
  1633.             "className" => "visible_export colonne_id text-center",
  1634.             "targets"   => [7],
  1635.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(ArticleCommande::class, "remise"),
  1636.         ];
  1637.         $tableau_class_cellule[] = [
  1638.             "className" => "visible_export colonne_id text-right",
  1639.             "targets"   => [8],
  1640.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(ArticleCommande::class, "totalHT"),
  1641.         ];
  1642.         $tableau_class_cellule[] = ["orderable" => false, "className" => "colonne_id", "targets" => [9], "visible" => true];
  1643.         $this->datatablePieces($client, $datatable, $translator);
  1646.         return $this->render(
  1647.             'Clients/Client/lister-pieces.html.twig',
  1648.             ['tableauClassColonnePieces' => $tableau_class_cellule, 'route' => 'dtc_client_piece_liste_grid', 'clientId' => $client->getId()]
  1649.         );
  1651.     }
  1653.     /**
  1654.      * set datatable configs
  1655.      *
  1656.      * @return \App\Library\Datatable\Util\Datatable
  1657.      */
  1658.     private function datatablePieces($client, Datatable $datatable, TranslatorInterface $translator)
  1659.     {
  1660.         $datatable->setDatatableId('dta-pieces')
  1661.                   ->setEntity(ArticleCommande::class, "x")
  1662.                   ->setFields(
  1663.                       [
  1664.                           $translator->trans("ID")               => 'x.id',
  1665.                           $translator->trans("Réf")              => 'a.reference',
  1666.                           $translator->trans("Libellé")          => 'x.libelle',
  1667.                           $translator->trans("Date")             => 'x.date',
  1668.                           $translator->trans("Commande")         => 'c.reference',
  1669.                           $translator->trans("Qté")              => "x.quantite",
  1670.                           $translator->trans("Prix unitaire HT") => 'x.prixBase',
  1671.                           $translator->trans("Remise")           => 'x.remise',
  1672.                           $translator->trans("Total HT")         => "x.totalHt",
  1673.                           $translator->trans("Actions")          => 'x.id',
  1674.                           "_identifier_"                         => 'x.id',
  1675.                       ]
  1676.                   )
  1677.                   ->setWhere(
  1678.                       'c.client = :client and t.id = 2 and s.ordre != 0',
  1679.                       ['client' => $client]
  1680.                   )
  1681.                   ->addJoin('x.article', 'a', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1682.                   ->addJoin('x.commande', 'c', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1683.                   //->addJoin('c.typeDocumentCommercial', 't', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1684.                   ->addJoin('c.statutCommande', 's', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1685.                   ->setRenderers(
  1686.                       [
  1687.                           1 => [
  1688.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  1689.                               'params' => [
  1690.                                   'edit_route'   => 'dtc_article_modifier',
  1691.                                   'typeDocument' => 'article',
  1692.                               ],
  1693.                           ],
  1694.                           2 => [
  1695.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  1696.                               'params' => [
  1697.                                   'edit_route'   => 'dtc_article_modifier',
  1698.                                   'typeDocument' => 'article',
  1699.                               ],
  1700.                           ],
  1701.                           3 => [
  1702.                               'view' => 'FO/DataTable/heure.html.twig',
  1703.                           ],
  1704.                           4 => [
  1705.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  1706.                               'params' => [
  1707.                                   'edit_route'   => 'dtc_commande_modifier',
  1708.                                   'typeDocument' => 'commande',
  1709.                               ],
  1710.                           ],
  1711.                           6 => [
  1712.                               'view' => 'FO/DataTable/prix.html.twig',
  1714.                           ],
  1715.                           8 => [
  1716.                               'view' => 'FO/DataTable/prix.html.twig',
  1718.                           ],
  1719.                           9 => [
  1720.                               'view'   => 'FO/DataTable/actions.html.twig',
  1721.                               'params' => [
  1722.                                   'edit_route' => 'dtc_commande_modifier',
  1723.                                   'objet'      => Commande::class,
  1725.                               ],
  1726.                           ],
  1728.                       ]
  1729.                   )
  1730.                   ->setOrder("x.id", "desc")
  1731.                   ->setSearch(true)
  1732.                   ->setSearchFields([1, 2, 4]);
  1734.         return $datatable;
  1735.     }
  1738.     /**
  1739.      * Grid action
  1740.      * @return Response
  1741.      */
  1742.     /**
  1743.      * @Route("/client/piece/grid/{id}", name="dtc_client_piece_liste_grid")
  1744.      */
  1745.     public function gridPiecesAction(Request $request, Client $client, Datatable $datatable, TranslatorInterface $translator)
  1746.     {
  1747.         return $this->datatablePieces($client, $datatable, $translator)->execute();
  1748.     }
  1751.     /**
  1752.      * set datatable configs
  1753.      *
  1754.      * @return \App\Library\Datatable\Util\Datatable
  1755.      */
  1756.     private function datatableNotes($client, Datatable $datatable, TranslatorInterface $translator)
  1757.     {
  1759.         $user = $this->getUser();
  1760.         $datatable->setDatatableId('dta-notes-clients')
  1761.                   ->setEntity(Note::class, "x")
  1762.                   ->setFields(
  1763.                       [
  1764.                           //$translator->trans("ID") =>  'x.id',
  1765.                           $translator->trans("Message") => 'x.message',
  1766.                           $translator->trans("Cat")     => 'cn.libelle',
  1767.                           $translator->trans("Contact") => 'c.nom',
  1768.                           $translator->trans("Date")    => 'x.dateSaisie',
  1769.                           $translator->trans("Actions") => 'x.id',
  1770.                           "_identifier_"                => 'x.id',
  1771.                       ]
  1772.                   )
  1773.                   ->addJoin('x.categorie', 'cn', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1774.                   ->addJoin('x.contact', 'c', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1775.                   ->setWhere(
  1776.                         'x.client = :client'
  1777.                       , ['client' => $client]
  1778.                   )
  1779.                   ->setGroupBy('x.id')
  1780.                   ->setRenderers(
  1781.                       [
  1782.                           0 => [
  1783.                               'view'   => 'FO/DataTable/titre_note.html.twig',
  1784.                               'params' => [],
  1785.                           ],
  1786.                           2 => [
  1787.                               'view'   => 'FO/DataTable/contact.html.twig',
  1788.                               'params' => [],
  1789.                           ],
  1790.                           3 => [
  1791.                               'view'   => 'FO/DataTable/heure.html.twig',
  1792.                               'params' => [],
  1793.                           ],
  1794.                           4 => [
  1795.                               'view'   => 'FO/DataTable/actions_modal.html.twig',
  1796.                               'params' => [
  1797.                                   'edit_route'      => 'dtc_note_modifier',
  1798.                                   'supprimer_route' => 'dtc_note_supprimer',
  1799.                                   'id'              => $client->getId(),
  1800.                                   'type'            => "client",
  1801.                                   'objet'           => Note::class,
  1802.                                   'width_modal'     => 900,
  1804.                               ],
  1805.                           ],
  1807.                       ]
  1808.                   )
  1809.                   ->setOrder("x.dateSaisie", "desc")
  1810.                   ->setSearch(true)
  1811.                   ->setSearchFields([1]);
  1812.         $where      = "x.client = :client AND (x.prive = :prive OR x.prive IS NULL or x.utilisateur = :utilisateur)";
  1813.         $parameters = ["prive" => 0, "utilisateur" => $user, 'client' => $client];
  1814.         $datatable->setWhere($where, $parameters);
  1816.         return $datatable;
  1817.     }
  1820.     /**
  1821.      * set datatable configs
  1822.      *
  1823.      * @return \App\Library\Datatable\Util\Datatable
  1824.      */
  1825.     private function datatableRemises($client, Datatable $datatable, TranslatorInterface $translator)
  1826.     {
  1828.         $categorieRemiseClient = [];
  1829.         foreach ($client->getCategorieRemiseClientClient() as $crcc) {
  1830.             $categorieRemiseClient[] = $crcc->getCategorieRemiseClient();
  1831.         }
  1833.         $categorieClient = [];
  1834.         foreach ($client->getClientCategorie() as $crcc) {
  1835.             //echo "<div>".$crcc->getCategorie()->getLibelle()."</div>";
  1836.             $categorieClient[] = $crcc->getCategorie();
  1837.         }
  1839.         $datatable->setDatatableId('dta-remises-clients')
  1840.                   ->setEntity(Remise::class, "x")
  1841.                   ->setFields(
  1842.                       [
  1843.                           $translator->trans("ID")      => 'x.id',
  1844.                           $translator->trans("Libellé") => 'x.libelle',
  1845.                           $translator->trans("Taux")    => 'x.montant',
  1846.                           $translator->trans("Actions") => 'x.id',
  1847.                           "_identifier_"                => 'x.id',
  1848.                       ]
  1849.                   )
  1850.                   ->addJoin('x.client', 'c', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1851.                   ->addJoin('x.categorieRemiseClientRemise', 'a', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1852.                   ->addJoin('x.remiseCategorieClient', 'b', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1853.                   ->setWhere(
  1854.                         '
  1855.                              x.parent is null
  1856.                              AND
  1857.                              (
  1858.                              x.client = :client
  1859.                              OR
  1860.                              (a.categorieRemiseClient IN (:categorieRemiseClient) and (x.client IS NULL OR x.client = :client))
  1861.                              OR
  1862.                              (b.categorie IN (:categorieClient) and (x.client IS NULL OR x.client = :client))
  1863.                              )
  1864.                              '
  1865.                       , ['client' => $client, 'categorieRemiseClient' => $categorieRemiseClient, 'categorieClient' => $categorieClient]
  1866.                   )
  1867.                   ->setGroupBy('x.id')
  1868.                   ->setRenderers(
  1869.                       [
  1870.                           0 => [
  1871.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  1872.                               'params' => [
  1873.                                   'edit_route'   => 'dtc_remise_modifier',
  1874.                                   'typeDocument' => '',
  1875.                               ],
  1877.                           ],
  1878.                           1 => [
  1879.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  1880.                               'params' => [
  1881.                                   'edit_route' => 'dtc_remise_modifier',
  1882.                               ],
  1884.                           ],
  1885.                           3 => [
  1886.                               'view'   => 'FO/DataTable/actions.html.twig',
  1887.                               'params' => [
  1888.                                   'edit_route'      => 'dtc_remise_modifier',
  1889.                                   'supprimer_route' => 'dtc_remise_client_supprimer',
  1890.                                   'objet'           => Remise::class,
  1891.                                   'deplier'         => false,
  1892.                               ],
  1893.                           ],
  1896.                       ]
  1897.                   )
  1898.                   ->setOrder("x.id", "desc")
  1899.                   ->setSearch(true)
  1900.                   ->setSearchFields([1]);
  1902.         return $datatable;
  1903.     }
  1905.     /*
  1906.     private function datatableRemises($client)
  1907.     {
  1908.         $datatable = $this->get('datatable');
  1909.         $datatable  ->setDatatableId('dta-remises-clients')
  1910.                     ->setEntity("DTCRemisesBundle:Remise", "x")
  1911.                     ->setFields(
  1912.                         array(
  1913.                            $translator->trans("ID") =>  'x.id',
  1914.                            $translator->trans("Libellé") =>  'x.libelle',
  1915.                            $translator->trans("Taux") =>  'x.montant',
  1917.                            $translator->trans("Actions") =>  'x.id',
  1918.                                "_identifier_" => 'x.id'
  1919.                                )
  1920.                         )
  1921.                      ->addJoin('x.client', 'c', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1922.                      ->setWhere(
  1923.                              'x.client = :client',
  1924.                              array('client' => $client)
  1925.                         )
  1926.                      ->setRenderers(
  1927.                         array(
  1928.                             0 => array(
  1929.                                 'view' => 'FO/DataTable/avec_lien_edit_route.html.twig',
  1930.                                  'params' => array(
  1931.                                         'edit_route'    => 'dtc_remise_modifier'
  1932.                                     ),
  1934.                             ),
  1936.                         )
  1937.                     )
  1938.                     ->setOrder("x.id", "desc")
  1939.                     ->setSearch(true)
  1940.                     ->setSearchFields(array(1))
  1941.                     ;
  1942.         return $datatable;
  1943.     }
  1944.     */
  1946.     /**
  1947.      * Grid action
  1948.      * @return Response
  1949.      */
  1950.     /**
  1951.      * @Route("/client/remise/grid/{id}", name="dtc_client_remise_liste_grid")
  1952.      */
  1953.     public function gridRemisesAction(Request $request, Client $client, Datatable $datatable, TranslatorInterface $translator)
  1954.     {
  1955.         return $this->datatableRemises($client, $datatable, $translator)->execute();
  1956.     }
  1959.     /**
  1960.      * @Route("/client/note/grid/{id}", name="dtc_client_note_liste_grid")
  1961.      */
  1962.     public function gridNotesAction(Request $request, Client $client, Datatable $datatable, TranslatorInterface $translator)
  1963.     {
  1964.         return $this->datatableNotes($client, $datatable, $translator)->execute();
  1965.     }
  1968.     /**
  1969.      * @Route("/client/search/", name="dtc_client_search")
  1970.      */
  1971.     public function searchAction(Request $request, EntityManagerInterface $em)
  1972.     {
  1974.         $query   = $request->query->get('q');
  1975.         $results = $em->getRepository(Client::class)->findByRefOrName($query);
  1977.         $datas = [];
  1978.         foreach ($results as $result) {
  1979.             $datas[] = $result;
  1980.         }
  1982.         $response = new JsonResponse();
  1983.         $response->setData([
  1984.                                'items' => $datas,
  1985.                            ]);
  1987.         return $response;
  1988.     }
  1990.     /**
  1991.      * set datatable configs
  1992.      *
  1993.      * @return \App\Library\Datatable\Util\Datatable
  1994.      */
  1995.     private function datatableFactures($client, Datatable $datatable, TranslatorInterface $translator)
  1996.     {
  1998.         $datatable->setDatatableId('dta-factures-avoirs')
  1999.                   ->setEntity(Commande::class, "x")
  2000.                   ->setFields(
  2001.                       [
  2002.                           //$translator->trans("ID") =>  'x.id',
  2003.                           $translator->trans("Date")      => 'x.date',
  2004.                           $translator->trans("Réf")       => 'x.reference',
  2005.                           $translator->trans("Type")      => 't.libelle',
  2006.                           $translator->trans("Total HT")  => 'x.total',
  2007.                           $translator->trans("Total TTC") => 'x.totalTtc',
  2008.                           $translator->trans("Payé ?")    => 'x.id',
  2009.                           $translator->trans("Actions")   => 'x.id',
  2010.                           "_identifier_"                  => 'x.id',
  2011.                       ]
  2012.                   )
  2013.                   ->addJoin('x.statutCommande', 's', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  2014.                   //->addJoin('x.typeDocumentCommercial', 't', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  2015.             //->addJoin('x.blsCommande', 'bl', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  2016.             //->addJoin('x.bps', 'bp', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  2017.             //->addJoin('x.docEnfantsDevis', 'ded', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  2018.             //->addJoin('x.docEnfantsCommande', 'dec', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  2019.             //->addJoin('dec.typeDocumentCommercial', 'dect', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  2020.             //->addJoin('x.docEnfantsBP', 'debp', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  2021.             //->addJoin('x.docEnfantsBL', 'debl', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  2022.                   ->setRenderers(
  2023.                 [
  2024.                     0 => [
  2025.                         'view'   => 'FO/DataTable/heure.html.twig',
  2026.                         'params' => [],
  2027.                     ],
  2028.                     1 => [
  2029.                         'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  2030.                         'params' => [
  2031.                             'edit_route'   => 'auto',
  2032.                             'typeDocument' => "",
  2033.                         ],
  2034.                     ],
  2035.                     3 => [
  2036.                         'view' => 'FO/DataTable/prix.html.twig',
  2038.                     ],
  2039.                     4 => [
  2040.                         'view' => 'FO/DataTable/prix.html.twig',
  2042.                     ],
  2043.                     5 => [
  2044.                         'view' => 'FO/DataTable/facture_est_paye_solde.html.twig',
  2046.                     ],
  2047.                     6 => [
  2048.                         'view'   => 'FO/DataTable/actions.html.twig',
  2049.                         'params' => [
  2051.                             'edit_route' => 'auto',
  2052.                             'pdf_route'  => 'auto',
  2053.                             'objet'      => Commande::class,
  2054.                             'deplier'    => 'true',
  2057.                         ],
  2058.                     ],
  2060.                 ]
  2061.             )
  2062.                   ->setOrder("x.id", "desc")
  2063.                   ->setSearch(true)
  2064.                   ->setSearchFields([1, 2, 3]);
  2067.         /*
  2068.             13     Ordre de fabrication multiple
  2069.             12     Facture fournisseur
  2070.             11     Bon de préparation atelier
  2071.             10     Devis OR
  2072.             9     Ordre de fabrication
  2073.             8     Commande fournisseur
  2074.             7     Avoir
  2075.             6     Facture
  2076.             5     Bon de livraison
  2077.             4     Bon de préparation
  2078.             3     Ordre de réparation
  2079.             2     Commande
  2080.             1     Devis
  2081.         */
  2083.         $typeDoc = ["1", "2", "3", "4", "5", "6", "7", "10"];
  2084.         $typeDoc = array(
  2085.             TypeDocumentCommercial::DEVIS,
  2086.             TypeDocumentCommercial::COMMANDE,
  2087.             TypeDocumentCommercial::ORDREREPARATION,
  2088.             TypeDocumentCommercial::BP,
  2089.             TypeDocumentCommercial::BL,
  2090.             TypeDocumentCommercial::FACTURE,
  2091.             TypeDocumentCommercial::AVOIR,
  2092.             TypeDocumentCommercial::DEVISOR
  2093.         );
  2094. //$typeDoc = array(3);
  2095.         $where      = "    x.client = :client
  2096.                     AND
  2097.                     x.dateSuppression IS NULL
  2098.                     AND
  2099.                     (s.ordre != :ordreStatutDoc or (x.typeDocumentCommercial = 1))
  2101.                 ";
  2102.         $parameters = ['client' => $client, "typeDocumentCommercial" => $typeDoc, 'ordreStatutDoc' => '0'];
  2105.         $parameters = ['client' => $client, 'ordreStatutDoc' => '0'];
  2106.         $where      = "    x.client = :client
  2108.                     AND x.dateSuppression IS NULL
  2109.                     AND (s.ordre != :ordreStatutDoc or (x.typeDocumentCommercial = 1))";
  2110.         $where      .= " AND (";
  2111.         /*
  2112.         $where .= " (x.typeDocumentCommercial = TypeDocumentCommercial::ORDREREPARATION AND x.statutCommande IN (14,15))";//Ordre de réparation
  2113.         $where .= " OR (x.typeDocumentCommercial = ".TypeDocumentCommercial::DEVIS." AND x.visible = 1 AND x.commande IS NULL)";//Devis
  2114.         $where .= " OR (x.typeDocumentCommercial = ".TypeDocumentCommercial::DEVISOR." AND x.visible = 1 AND x.commande IS NULL)";//Devis OR
  2115.         $where .= " OR (x.typeDocumentCommercial = ".TypeDocumentCommercial::COMMANDE." AND x.visible= 1 AND x.origineSaisie IN ('devis', 'commande', 'bp'))";//Commande
  2116.         $where .= " OR (x.typeDocumentCommercial = ".TypeDocumentCommercial::BL." AND x.visible= 1 AND x.facture IS NULL)";//BL
  2117.         $where .= " OR (x.typeDocumentCommercial IN (4, 6, 7) AND x.visible= 1)";//bp, facture, avoir
  2118.          *
  2119.          */
  2120.         $where .= " x.typeDocumentCommercial IN (6, 7) AND x.visible= 1";//bp, facture, avoir
  2121.         $where .= ")";
  2124.         $datatable->setWhere($where, $parameters);
  2126.         return $datatable;
  2127.     }
  2130.     /**
  2131.      * Grid action
  2132.      * @return Response
  2133.      */
  2134.     /**
  2135.      * @Route("/client/facture/grid/{id}", name="dtc_client_facture_liste_grid")
  2136.      */
  2137.     public function gridFacturesAction(Request $request, Client $client, Datatable $datatable, TranslatorInterface $translator)
  2138.     {
  2139.         return $this->datatableFactures($client, $datatable, $translator)->execute();
  2140.     }
  2142.     /**
  2143.      * @Route("/client/historique/{client}", name="dtc_client_historique")
  2144.      */
  2145.     public function historiqueAction(Request $request, Client $client, EntityManagerInterface $em, TranslatorInterface $translator)
  2146.     {
  2147.         $titre_modal = $translator->trans("Historique du client");
  2149.         $clients   = [];
  2150.         $clients[] = $client;
  2152.         //dump($commandes);
  2153.         $historiques = $em->getRepository(HistoriqueClient::class)->findBy(['client' => $clients], ['date' => 'DESC']);
  2155.         $rendu = $this->renderView('Clients/Client/historique.html.twig', ['historiques' => $historiques]);
  2157.         return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal, 'width' => 900]);
  2158.     }
  2160.     /**
  2161.      * @Route("/client/email/is-connected", name="clients__client_is_connected")
  2162.      */
  2163.     public function clientIsConnectedAction(Request $request, EmailService $emailService)
  2164.     {
  2165.         $client = new Client();
  2166.         $client->setMailerUser($request->request->get('mailerUser'));
  2167.         $client->setMailerPassword($request->request->get('mailerPassword'));
  2168.         $client->setMailerHost($request->request->get('mailerHost'));
  2169.         $client->setMailerPort($request->request->get('mailerPort'));
  2170.         return new JsonResponse(['isConnected'=>$emailService->getConnexionImapClient($client)]);
  2171.     }
  2173. }