src/Controller/DocumentController.php line 38

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\Adresse;
  6. use App\Entity\Document;
  7. use App\Entity\DocumentLigne;
  8. use App\Entity\Projet;
  9. use App\Entity\Societe;
  10. use App\Entity\Souche;
  11. use App\Entity\Tiers;
  12. use App\Repository\DocumentRepository;
  13. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  14. use Symfony\Component\HttpFoundation\Request;
  15. use Symfony\Component\HttpFoundation\RequestStack;
  16. use Symfony\Component\HttpFoundation\Response;
  17. use Symfony\Component\Routing\Annotation\Route;
  18. use App\Tools\JsonRes;
  19. use Doctrine\Persistence\ManagerRegistry;
  20. use Doctrine\Persistence\ObjectManager;
  22. class DocumentController extends AbstractController
  23. {
  25.     private ?ObjectManager $em = null;
  26.     private ?string $prefixSociete = null;
  28.     /**
  29.      * Stockage des informations de la société pour affichage sur entête document
  30.      * @var object|mixed|null
  31.      */
  32.     private ?object $dataSociete = null;
  34.     public function __construct(RequestStack $requestStack, ManagerRegistry $doctrine)
  35.     {
  36.         $request = $requestStack->getCurrentRequest();
  37.         //TODO: page erreur subdomain
  38.         if(null===$request->getSession()->get('societe')) return $this->render('misc/404.html.twig');
  39.         // on récupère le sous-domaine stocké en session pour pointer vers le bon entity manager
  40.         $subdomain = $request->getSession()->get('societe')->getBase();
  41.         $this->em = $doctrine->getManager($subdomain);
  43.         $this->prefixSociete = $request->getSession()->get('societe')->getPrefix();
  44.         if(null!==$this->prefixSociete) $this->prefixSociete = strtoupper($this->prefixSociete);
  46.         $jsonString = $request->getSession()->get('societe')->getData();
  47.         if(null!==$jsonString) {
  48.             $this->dataSociete = json_decode($jsonString);
  49.             $this->dataSociete->lib_societe = $request->getSession()->get('societe')->getLibSociete();
  50.             $this->dataSociete->logo_path = $request->getSession()->get('societe')->getLogoPath();
  51.         }
  52.     }
  54.     /**
  55.      * @Route("/document/update-societe", methods={"POST"}, name="update_doc_societe")
  56.      */
  57.     public function updateSociete(Request $request): Response
  58.     {
  59.         //TODO: page erreur entity manager
  60.         if(null===$this->em) return $this->render('misc/404.html.twig');
  62.         // Initialisation du retour Json
  63.         $res = new JsonRes($request->request->all());
  65.         if($res->isSuccess()) {
  67.             $data = $res->getData();
  68.             if(!isset($data['id_document'])) $res->addErrMsg('champs id_document inconnu');
  69.             if(!isset($data['id_societe'])) $res->addErrMsg('champs id_societe inconnu');
  71.             if($res->isSuccess()) {
  72.                 if(''===$data['id_document']) $res->addErrMsg('champs id_document obligatoire');
  73.                 if(''===$data['id_societe']) $res->addErrMsg('champs id_societe obligatoire');
  75.                 if($res->isSuccess()) {
  77.                     $adresseRepository = $this->em->getRepository(Societe::class);
  78.                     /**  @var Societe $societe */
  79.                     $societe = $adresseRepository->find($data['id_societe']);
  80.                     if(null===$societe) $res->addErrMsg('Societe introuvable');
  81.                     if($res->isSuccess()) {
  83.                         if(0===$societe->getAdresses()->count()) $res->addErrMsg('Cette société n\'a pas d\'adresse, ajouter une adresse');
  85.                         if($res->isSuccess()) {
  86.                             $documentRepository = $this->em->getRepository(Document::class);
  87.                             /** @var Document $document */
  88.                             $document = $documentRepository->find($data['id_document']);
  89.                             if(!null==$document) {
  90.                                 /** @var \App\Entity\User $currentUser */
  91.                                 $currentUser = $this->getUser()->getId();
  92.                                 $document->setTiers($societe)
  93.                                     ->setAdresse($societe->getAdresses()->first())
  94.                                     ->setUserModif($currentUser)
  95.                                     ->setDateModif(new \DateTime())
  96.                                 ;
  98.                                 $this->em->persist($document);
  99.                                 $this->em->flush();
  100.                             }
  102.                             $res->setData($data);
  103.                         }
  104.                     }
  105.                 }
  106.             }
  107.         }
  108.         die($res->returnJson());
  109.     }
  111.     /**
  112.      * @Route("/document/update-adresse", methods={"POST"}, name="update_doc_adresse")
  113.      */
  114.     public function updateAdresse(Request $request): Response
  115.     {
  116.         //TODO: page erreur entity manager
  117.         if(null===$this->em) return $this->render('misc/404.html.twig');
  119.         // Initialisation du retour Json
  120.         $res = new JsonRes($request->request->all());
  122.         if($res->isSuccess()) {
  124.             $data = $res->getData();
  125.             if(!isset($data['id_document'])) $res->addErrMsg('champs id_document inconnu');
  126.             if(!isset($data['id_adresse'])) $res->addErrMsg('champs id_adresse inconnu');
  128.             if($res->isSuccess()) {
  129.                 if(''===$data['id_document']) $res->addErrMsg('champs id_document obligatoire');
  130.                 if(''===$data['id_adresse']) $res->addErrMsg('champs id_adresse obligatoire');
  132.                 if($res->isSuccess()) {
  134.                     $adresseRepository = $this->em->getRepository(Adresse::class);
  135.                     /**  @var Adresse $adresse */
  136.                     $adresse = $adresseRepository->find($data['id_adresse']);
  137.                     if(null===$adresse) $res->addErrMsg('Adresse introuvable');
  139.                     if($res->isSuccess()) {
  140.                         $res->setHtml('
  141.                             <p>' . $adresse->getLigne1() . '</p>
  142.                             <p>' . $adresse->getLigne2() . '</p>
  143.                             <p>' . $adresse->getCodePostal() . ' ' . $adresse->getVille() . '</p>
  144.                             <p>' . $adresse->getPays() . '</p>
  145.                         ');
  146.                     }
  148.                     $documentRepository = $this->em->getRepository(Document::class);
  149.                     /** @var Document $document */
  150.                     $document = $documentRepository->find($data['id_document']);
  151.                     if(!null==$document) {
  152.                         /** @var \App\Entity\User $currentUser */
  153.                         $currentUser = $this->getUser()->getId();
  154.                         $document->setAdresse($adresse)
  155.                             ->setUserModif($currentUser)
  156.                             ->setDateModif(new \DateTime())
  157.                         ;
  159.                         $this->em->persist($document);
  160.                         $this->em->flush();
  161.                     }
  163.                     $res->setData($data);
  164.                 }
  165.             }
  166.         }
  167.         die($res->returnJson());
  168.     }
  170.     /**
  171.      * @Route("/document/update-lib-projet", methods={"POST"}, name="update_doc_lib_projet")
  172.      */
  173.     public function updateLibProjet(Request $request): Response
  174.     {
  175.         //TODO: page erreur entity manager
  176.         if(null===$this->em) return $this->render('misc/404.html.twig');
  178.         // Initialisation du retour Json
  179.         $res = new JsonRes($request->request->all());
  181.         if($res->isSuccess()) {
  183.             $data = $res->getData();
  184.             if(!isset($data['id_document'])) $res->addErrMsg('champs id_document inconnu');
  185.             if(!isset($data['lib_projet_document'])) $res->addErrMsg('champs lib_projet_document inconnu');
  187.             if($res->isSuccess()) {
  188.                 if(''===$data['id_document']) $res->addErrMsg('champs id_document obligatoire');
  190.                 if($res->isSuccess()) {
  192.                     $documentRepository = $this->em->getRepository(Document::class);
  193.                     /** @var Document $document */
  194.                     $document = $documentRepository->find($data['id_document']);
  195.                     if(!null==$document) {
  197.                         if(''===$data['lib_projet_document']) $data['lib_projet_document'] = $document->getProjet()->getLibProjet();
  199.                         /** @var \App\Entity\User $currentUser */
  200.                         $currentUser = $this->getUser()->getId();
  201.                         $document->setLibProjet($data['lib_projet_document'])
  202.                             ->setUserModif($currentUser)
  203.                             ->setDateModif(new \DateTime())
  204.                         ;
  206.                         $this->em->persist($document);
  207.                         $this->em->flush();
  208.                     }
  210.                     $res->setData($data);
  211.                 }
  212.             }
  213.         }
  214.         die($res->returnJson());
  215.     }
  217.     /**
  218.      * @Route("/document/update-date-bdc", methods={"POST"}, name="update_doc_date_bdc")
  219.      */
  220.     public function updateDateBdc(Request $request): Response
  221.     {
  222.         //TODO: page erreur entity manager
  223.         if(null===$this->em) return $this->render('misc/404.html.twig');
  225.         // Initialisation du retour Json
  226.         $res = new JsonRes($request->request->all());
  228.         if($res->isSuccess()) {
  230.             $data = $res->getData();
  231.             if(!isset($data['id_document'])) $res->addErrMsg('champs id_document inconnu');
  232.             if(!isset($data['date_bdc_document'])) $res->addErrMsg('champs date_bdc_document inconnu');
  234.             if($res->isSuccess()) {
  235.                 if(''===$data['id_document']) $res->addErrMsg('champs id_document obligatoire');
  236.                 $dateBdc = date_create_from_format('Y-m-d', $data['date_bdc_document']);
  237.                 if(!$dateBdc) $res->addErrMsg('Le format de la date est incorrect');
  239.                 if($res->isSuccess()) {
  241.                     $documentRepository = $this->em->getRepository(Document::class);
  242.                     /** @var Document $document */
  243.                     $document = $documentRepository->find($data['id_document']);
  244.                     if(!null==$document) {
  245.                         /** @var \App\Entity\User $currentUser */
  246.                         $currentUser = $this->getUser()->getId();
  247.                         $document->setDateBdc($dateBdc)
  248.                             ->setUserModif($currentUser)
  249.                             ->setDateModif(new \DateTime())
  250.                         ;
  252.                         $this->em->persist($document);
  253.                         $this->em->flush();
  254.                     }
  256.                     $res->setData($data);
  257.                 }
  258.             }
  259.         }
  260.         die($res->returnJson());
  261.     }
  263.     /**
  264.      * @Route("/document/update-date-budget", methods={"POST"}, name="update_doc_date_budget")
  265.      */
  266.     public function updateDateBudget(Request $request): Response
  267.     {
  268.         //TODO: page erreur entity manager
  269.         if(null===$this->em) return $this->render('misc/404.html.twig');
  271.         // Initialisation du retour Json
  272.         $res = new JsonRes($request->request->all());
  274.         $data = $res->getData();
  275.         if(!$this->isGranted('ROLE_ADMIN')) $res->addErrMsg('Vous n\'avez pas les droits pour effectuer cette action');
  276.         if(empty($data['id_document'])) $res->addErrMsg('erreur id_document');
  277.         if(empty($data['date_budget'])) $res->addErrMsg('erreur date_budget');
  278.         if(!$res->isSuccess()) die($res->returnJson());
  280.         $dateBudget = date_create_from_format('Y-m-d', $data['date_budget']);
  281.         if(!$dateBudget) $res->addErrMsg('Le format de la date est incorrect');
  282.         if(!$res->isSuccess()) die($res->returnJson());
  284.         $documentRepository = $this->em->getRepository(Document::class);
  285.         /** @var Document $document */
  286.         $document = $documentRepository->find($data['id_document']);
  287.         if(empty($document)) $res->addErrMsg('Document non trouvé dans la base de donnée');
  288.         if(!$res->isSuccess()) die($res->returnJson());
  291.         /** @var \App\Entity\User $currentUser */
  292.         $currentUser = $this->getUser()->getId();
  293.         $document->setDateCrea($dateBudget)
  294.             ->setUserModif($currentUser)
  295.             ->setDateModif(new \DateTime())
  296.         ;
  297.         $this->em->persist($document);
  298.         $this->em->flush();
  299.         $res->setData($data);
  300.         die($res->returnJson());
  301.     }
  303.     /**
  304.      * @Route("/document/update-reference", methods={"POST"}, name="update_doc_reference")
  305.      */
  306.     public function updateReference(Request $request): Response
  307.     {
  308.         //TODO: page erreur entity manager
  309.         if(null===$this->em) return $this->render('misc/404.html.twig');
  311.         // Initialisation du retour Json
  312.         $res = new JsonRes($request->request->all());
  314.         if($res->isSuccess()) {
  316.             $data = $res->getData();
  317.             if(!isset($data['id_document'])) $res->addErrMsg('champs id_document inconnu');
  318.             if(!isset($data['reference_document'])) $res->addErrMsg('champs reference_document inconnu');
  320.             if($res->isSuccess()) {
  321.                 if(''===$data['id_document']) $res->addErrMsg('champs id_document obligatoire');
  323.                 if($res->isSuccess()) {
  325.                     $documentRepository = $this->em->getRepository(Document::class);
  326.                     /** @var Document $document */
  327.                     $document = $documentRepository->find($data['id_document']);
  328.                     if(!null==$document) {
  329.                         /** @var \App\Entity\User $currentUser */
  330.                         $currentUser = $this->getUser()->getId();
  331.                         $document->setReference($data['reference_document'])
  332.                             ->setUserModif($currentUser)
  333.                             ->setDateModif(new \DateTime())
  334.                         ;
  336.                         $this->em->persist($document);
  337.                         $this->em->flush();
  338.                     }
  340.                     $res->setData($data);
  341.                 }
  342.             }
  343.         }
  344.         die($res->returnJson());
  345.     }
  347.     /**
  348.      * @Route("/document/update-contact", methods={"POST"}, name="update_doc_contact")
  349.      */
  350.     public function updateContact(Request $request): Response
  351.     {
  352.         //TODO: page erreur entity manager
  353.         if(null===$this->em) return $this->render('misc/404.html.twig');
  355.         // Initialisation du retour Json
  356.         $res = new JsonRes($request->request->all());
  358.         if($res->isSuccess()) {
  360.             $data = $res->getData();
  361.             if(!isset($data['id_document'])) $res->addErrMsg('champs id_document inconnu');
  362.             if(!isset($data['contact_document'])) $res->addErrMsg('champs contact_document inconnu');
  364.             if($res->isSuccess()) {
  365.                 if(''===$data['id_document']) $res->addErrMsg('champs id_document obligatoire');
  367.                 if($res->isSuccess()) {
  369.                     $documentRepository = $this->em->getRepository(Document::class);
  370.                     /** @var Document $document */
  371.                     $document = $documentRepository->find($data['id_document']);
  372.                     if(!null==$document) {
  373.                         /** @var \App\Entity\User $currentUser */
  374.                         $currentUser = $this->getUser()->getId();
  375.                         $document->setContact($data['contact_document'])
  376.                             ->setUserModif($currentUser)
  377.                             ->setDateModif(new \DateTime())
  378.                         ;
  380.                         $this->em->persist($document);
  381.                         $this->em->flush();
  382.                     }
  384.                     $res->setData($data);
  385.                 }
  386.             }
  387.         }
  388.         die($res->returnJson());
  389.     }
  391.     /**
  392.      * @Route("/document/update-condition-reglement", methods={"POST"}, name="update_doc_condition_reglement")
  393.      */
  394.     public function updateConditionReglement(Request $request): Response
  395.     {
  396.         //TODO: page erreur entity manager
  397.         if(null===$this->em) return $this->render('misc/404.html.twig');
  399.         // Initialisation du retour Json
  400.         $res = new JsonRes($request->request->all());
  402.         if($res->isSuccess()) {
  404.             $data = $res->getData();
  405.             if(!isset($data['id_document'])) $res->addErrMsg('champs id_document inconnu');
  406.             if(!isset($data['condition_reglement_document'])) $res->addErrMsg('champs condition_reglement_document inconnu');
  408.             if($res->isSuccess()) {
  409.                 if(''===$data['id_document']) $res->addErrMsg('champs id_document obligatoire');
  411.                 if($res->isSuccess()) {
  412.                     if(empty($data['condition_reglement_document'])) $data['condition_reglement_document'] = null;
  413.                     $documentRepository = $this->em->getRepository(Document::class);
  414.                     /** @var Document $document */
  415.                     $document = $documentRepository->find($data['id_document']);
  416.                     if(!null==$document) {
  417.                         /** @var \App\Entity\User $currentUser */
  418.                         $currentUser = $this->getUser()->getId();
  419.                         $document->setConditionReglement($data['condition_reglement_document'])
  420.                             ->setUserModif($currentUser)
  421.                             ->setDateModif(new \DateTime())
  422.                         ;
  424.                         $this->em->persist($document);
  425.                         $this->em->flush();
  426.                     }
  428.                     $res->setData($data);
  429.                 }
  430.             }
  431.         }
  432.         die($res->returnJson());
  433.     }
  435.     /**
  436.      * @Route("/document/update-statut", methods={"POST"}, name="update_doc_statut")
  437.      */
  438.     public function updateStatut(Request $request): Response
  439.     {
  440.         //TODO: page erreur entity manager
  441.         if(null===$this->em) return $this->render('misc/404.html.twig');
  443.         // Initialisation du retour Json
  444.         $res = new JsonRes($request->request->all());
  446.         if($res->isSuccess()) {
  448.             $data = $res->getData();
  449.             if(!isset($data['id_document'])) $res->addErrMsg('champs id_document inconnu');
  451.             if($res->isSuccess()) {
  452.                 if(''===$data['id_document']) $res->addErrMsg('champs id_document obligatoire');
  454.                 if($res->isSuccess()) {
  456.                     $documentRepository = $this->em->getRepository(Document::class);
  457.                     /** @var Document $document */
  458.                     $document = $documentRepository->find($data['id_document']);
  459.                     if(!null==$document) {
  460.                         /** @var \App\Entity\User $currentUser */
  461.                         $currentUser = $this->getUser()->getId();
  462.                         $document->setStatut('payé')
  463.                             ->setDatePaiement(new \DateTime())
  464.                             ->setUserModif($currentUser)
  465.                             ->setDateModif(new \DateTime())
  466.                         ;
  468.                         $this->em->persist($document);
  469.                         $this->em->flush();
  470.                     }
  472.                     $res->setData($data);
  473.                 }
  474.             }
  475.         }
  476.         die($res->returnJson());
  477.     }
  479.     /**
  480.      * @Route("/document/insert-ligne", methods={"POST"}, name="insert_ligne")
  481.      */
  482.     public function insertLigne(Request $request): Response
  483.     {
  484.         //TODO: page erreur entity manager
  485.         if(null===$this->em) return $this->render('misc/404.html.twig');
  487.         // Initialisation du retour Json
  488.         $res = new JsonRes($request->request->all());
  490.         if($res->isSuccess()) {
  492.             $data = $res->getData();
  493.             if(!isset($data['id_document'])) $res->addErrMsg('champs id_document inconnu');
  494.             if(!isset($data['id_projet'])) $res->addErrMsg('champs id_projet inconnu');
  495.             if(!isset($data['type_document'])) $res->addErrMsg('champs type_document inconnu');
  496.             if(!isset($data['id_adresse'])) $res->addErrMsg('champs id_adresse inconnu');
  497.             if(!isset($data['lib_projet_document'])) $res->addErrMsg('champs lib_projet_document inconnu');
  498.             if(!isset($data['date_bdc_document'])) $res->addErrMsg('champs date_bdc_document inconnu');
  499.             if(!isset($data['reference_document'])) $res->addErrMsg('champs reference_document inconnu');
  500.             if(!isset($data['contact_document'])) $res->addErrMsg('champs contact_document inconnu');
  501.             if(!isset($data['nouvelle_ligne'])) $res->addErrMsg('champs nouvelle_ligne inconnu');
  502.             if(empty($data['date_budget'])) $res->addErrMsg('erreur date_budget');
  503.             if(!$res->isSuccess()) die($res->returnJson());
  507.             if($res->isSuccess()) {
  508.                 if(''===$data['id_document']) $res->addErrMsg('champs id_document obligatoire');
  509.                 if(''===$data['id_projet']) $res->addErrMsg('champs id_projet obligatoire');
  510.                 if(''===$data['type_document']) $res->addErrMsg('champs type_document obligatoire');
  511.                 if(empty($data['nouvelle_ligne'])) $res->addErrMsg('champs nouvelle_ligne vide');
  513.                 if($res->isSuccess()) {
  514.                     if(!isset($data['nouvelle_ligne']['libelle'])) $res->addErrMsg('champs libelle inconnu');
  515.                     if(!isset($data['nouvelle_ligne']['description'])) $res->addErrMsg('champs description inconnu');
  516.                     if(!isset($data['nouvelle_ligne']['qte'])) $res->addErrMsg('champs qte inconnu');
  517.                     if(!isset($data['nouvelle_ligne']['puht'])) $res->addErrMsg('champs puht inconnu');
  518.                     if(!isset($data['nouvelle_ligne']['taux_tva'])) $res->addErrMsg('champs taux_tva inconnu');
  520.                     if('COMMANDE PRESTATAIRE'===$data['type_document']){
  521.                         if(!isset($data['id_prestataire'])) $res->addErrMsg('champs id_prestataire inconnu');
  522.                     }
  524.                     if($res->isSuccess()) {
  525.                         if(''===$data['nouvelle_ligne']['libelle']) $res->addErrMsg('champs libelle obligatoire');
  526.                         if(''===$data['nouvelle_ligne']['qte']) $res->addErrMsg('champs qte obligatoire');
  527.                         if(''===$data['nouvelle_ligne']['puht']) $res->addErrMsg('champs puht obligatoire');
  528.                         if(''===$data['nouvelle_ligne']['taux_tva']) $res->addErrMsg('champs taux_tva obligatoire');
  530.                         if('COMMANDE PRESTATAIRE'===$data['type_document']){
  531.                             if(''===$data['id_prestataire']) $res->addErrMsg('champs id_prestataire obligatoire');
  532.                         }
  533.                     }
  534.                 }
  536.                 $dateBudget = date_create_from_format('Y-m-d', $data['date_budget']);
  537.                 if(!$dateBudget) $res->addErrMsg('Le format de la date est incorrect');
  539.                 $dateBdc = date_create_from_format('Y-m-d', $data['date_bdc_document']);
  540.                 if(!$dateBdc) $res->addErrMsg('Le format de la date est incorrect');
  542.                 if($res->isSuccess()) {
  544.                     /** @var \App\Entity\User $currentUser */
  545.                     $currentUser = $this->getUser()->getId();
  547.                     /** @var Document $document */
  548.                     $document = null;
  550.                     if(0===intval($data['id_document'])){ // si id_document = 0 alors création du document
  552.                         $projetRepository = $this->em->getRepository(Projet::class);
  553.                         /** @var Projet $projet */
  554.                         $projet = $projetRepository->find($data['id_projet']);
  555.                         if(!null==$projet){
  556.                             $document = new Document();
  557.                             $document->setProjet($projet)
  558.                                 ->setTiers($projet->getSociete())
  559.                                 ->setTypeDocument($data['type_document'])
  560.                                 ->setDateCrea($dateBudget)
  561.                                 ->setUserCrea($currentUser)
  562.                                 ->setMontantHt(0)
  563.                                 ->setMontantTva(0)
  564.                                 ->setReference($data['reference_document'])
  565.                                 ->setContact($data['contact_document'])
  566. //                                ->setLibProjet($data['lib_projet_document']) // pas obligatoire
  567.                                 ->setDateBdc($dateBdc)
  568.                             ;
  570.                             $adresseRepository = $this->em->getRepository(Adresse::class);
  571.                             /**  @var Adresse $adresse */
  572.                             $adresse = $adresseRepository->find($data['id_adresse']);
  573.                             if(null!==$adresse) $document->setAdresse($adresse);
  575.                             $this->em->persist($document);
  576.                             $this->em->flush();
  578.                             $numPiece = 'undefined';
  579.                             if('FACTURE PROFORMA'===$data['type_document']) $numPiece = $projet->getNumProd() .'-'. $document->getId();
  580.                             if('COMMANDE PRESTATAIRE'===$data['type_document']) {
  581.                                 $numPiece = 'BDC-' . $document->getId();
  583.                                 $tiersRepository = $this->em->getRepository(Tiers::class);
  584.                                 $prestataire = $tiersRepository->find($data['id_prestataire']);
  585.                                 if(null!==$prestataire) $document->setTiers($prestataire);
  586.                             }
  587.                             $document->setNumPiece($numPiece);
  589.                             $this->em->persist($document);
  590.                             $this->em->flush();
  592.                             $data['id_document'] = $document->getId();
  593.                         } else {
  594.                             $res->addErrMsg('Projet non identifié');
  595.                         }
  596.                     } else { // sinon update du document
  597.                         $documentRepository = $this->em->getRepository(Document::class);
  598.                         $document = $documentRepository->find($data['id_document']);
  599.                         if(null===$document) $res->addErrMsg('Document non identifié');
  600.                     }
  602.                     if($res->isSuccess()) {
  603.                         $newLigne = $data['nouvelle_ligne'];
  605.                         $ligne = new DocumentLigne();
  606.                         $ligne->setDocument($document)
  607.                             ->setLibelle($newLigne['libelle'])
  608.                             ->setDescription($newLigne['description'])
  609.                             ->setDateCrea(new \DateTime())
  610.                             ->setUserCrea($currentUser)
  611.                             ->setQte($newLigne['qte'])
  612.                             ->setPuht($newLigne['puht'])
  613.                             ->setTauxTva($newLigne['taux_tva'])
  614.                             ->performMontant()
  615.                         ;
  617.                         $document->addDocumentLigne($ligne)
  618.                             ->performMontant()
  619.                             ->setDateModif(new \DateTime())
  620.                             ->setUserModif($currentUser)
  621.                         ;
  622.                         $this->em->persist($document);
  623.                         $this->em->flush();
  625.                         $res->setData($data);
  626.                     }
  627.                 }
  628.             }
  629.         }
  630.         die($res->returnJson());
  631.     }
  633.     /**
  634.      * @Route("/document/update-ligne", methods={"POST"}, name="update_ligne")
  635.      */
  636.     public function updateLigne(Request $request): Response
  637.     {
  638.         //TODO: page erreur entity manager
  639.         if(null===$this->em) return $this->render('misc/404.html.twig');
  641.         // Initialisation du retour Json
  642.         $res = new JsonRes($request->request->all());
  644.         if(!$res->isSuccess()) die($res->returnJson());
  645.         $data = $res->getData();
  647.         if(empty($data['id_ligne'])) $res->addErrMsg('champs id_ligne obligatoire');
  648.         if(empty($data['libelle'])) $res->addErrMsg('champs libelle obligatoire');
  649.         if(empty($data['qte'])) $res->addErrMsg('champs qte obligatoire');
  650.         if(empty($data['puht'])) $res->addErrMsg('champs puht obligatoire');
  651.         if(empty($data['taux_tva'])) $res->addErrMsg('champs taux_tva obligatoire');
  652.         if(!$res->isSuccess()) die($res->returnJson());
  654.         $docLigneRepository = $this->em->getRepository(DocumentLigne::class);
  655.         $ligne = $docLigneRepository->find($data['id_ligne']);
  656.         if(null===$ligne) $res->addErrMsg('Ligne document non identifiée');
  657.         if(!$res->isSuccess()) die($res->returnJson());
  659.         /** @var \App\Entity\User $currentUser */
  660.         $currentUser = $this->getUser()->getId();
  662.         $ligne->setLibelle($data['libelle'])
  663.             ->setDescription($data['description'])
  664.             ->setDateModif(new \DateTime())
  665.             ->setUserModif($currentUser)
  666.             ->setQte($data['qte'])
  667.             ->setPuht($data['puht'])
  668.             ->setTauxTva($data['taux_tva'])
  669.             ->performMontant()
  670.         ;
  671.         $this->em->persist($ligne);
  672.         $this->em->flush();
  674.         $document = $ligne->getDocument();
  675.         $document->performMontant()
  676.             ->setDateModif(new \DateTime())
  677.             ->setUserModif($currentUser)
  678.         ;
  679.         $this->em->persist($document);
  680.         $this->em->flush();
  682.         $data['id_document'] = $document->getId();
  683.         $res->setData($data);
  685.         die($res->returnJson());
  686.     }
  688.     /**
  689.      * @Route("/document/delete-ligne", methods={"POST"}, name="delete_ligne")
  690.      */
  691.     public function deleteLigne(Request $request): Response
  692.     {
  693.         //TODO: page erreur entity manager
  694.         if(null===$this->em) return $this->render('misc/404.html.twig');
  696.         // Initialisation du retour Json
  697.         $res = new JsonRes($request->request->all());
  699.         if($res->isSuccess()) {
  701.             $data = $res->getData();
  702.             if(!isset($data['id_document'])) $res->addErrMsg('champs id_document inconnu');
  703.             if(!isset($data['id_ligne'])) $res->addErrMsg('champs id_ligne inconnu');
  705.             if($res->isSuccess()) {
  706.                 if(''===$data['id_document']) $res->addErrMsg('champs id_document obligatoire');
  707.                 if(''===$data['id_ligne']) $res->addErrMsg('champs id_ligne obligatoire');
  709.                 if($res->isSuccess()) {
  711.                     /** @var \App\Entity\User $currentUser */
  712.                     $currentUser = $this->getUser()->getId();
  714.                     $docLigneRepository = $this->em->getRepository(DocumentLigne::class);
  715.                     /** @var DocumentLigne $docLigne */
  716.                     $docLigne = $docLigneRepository->find($data['id_ligne']);
  717.                     if(null===$docLigne) $res->addErrMsg('Ligne document non identifiée');
  719.                     if($res->isSuccess()) {
  720.                         $docLigneRepository->remove($docLigne);
  721.                         $document = $docLigne->getDocument()
  722.                             ->performMontant()
  723.                             ->setDateModif(new \DateTime())
  724.                             ->setUserModif($currentUser)
  725.                         ;
  727.                         $this->em->persist($document);
  728.                         $this->em->flush();
  730.                         $res->setData($data);
  731.                     }
  732.                 }
  733.             }
  734.         }
  735.         die($res->returnJson());
  736.     }
  738.     /**
  739.      * @Route("/document/edit/{id}", methods={"GET"}, name="edit_document")
  740.      */
  741.     public function getDocumentForEdit($id)
  742.     {
  743.         $documentRepository = $this->em->getRepository(Document::class);
  744.         $document = $documentRepository->find($id);
  746.         return $this->render('projet/document/document-form.html.twig', [
  747.             'societe' => $this->dataSociete,
  748.             'document' => $document,
  749.             'label_btn_cancel' => 'Supprimer',
  750.         ]);
  751.     }
  753.     /**
  754.      * @Route("/document/vierge/{id}", methods={"GET"}, name="init_document_vierge")
  755.      */
  756.     public function getDocumentVierge($id)
  757.     {
  758.         $projetRepository = $this->em->getRepository(Projet::class);
  759.         /** @var Projet $projet */
  760.         $projet = $projetRepository->find($id);
  761.         if(null===$projet) return $this->render('misc/404.html.twig');
  763.         $documentVierge = new Document();
  764.         $documentVierge->initDocVierge($projet, 'FACTURE PROFORMA');
  766.         return $this->render('projet/document/document-form.html.twig', [
  767.             'societe' => $this->dataSociete,
  768.             'document_vierge' => $documentVierge,
  769.             'label_btn_cancel' => 'Annuler',
  770.         ]);
  771.     }
  773.     /**
  774.      * @Route("/document/reload-list/{typeDocument}/{idProjet}", methods={"GET"}, name="document_reload_list")
  775.      */
  776.     public function documentReloadList($typeDocument, $idProjet)
  777.     {
  778.         $projetRepository = $this->em->getRepository(Projet::class);
  779.         /** @var Projet $projet */
  780.         $projet = $projetRepository->find($idProjet);
  781.         $docList = array();
  782.         switch ($typeDocument){
  783.             case 'FACTURE PROFORMA':
  784.                 $docList = $projet->getDocuments()->filter(function (Document $document){
  785.                     return $document->getTypeDocument() === 'FACTURE PROFORMA';
  786.                 });
  787.                 $typeDocument = 'devis';
  788.                 break;
  789.             case 'FACTURE':
  790.                 $docList = $projet->getDocuments()->filter(function (Document $document){
  791.                     return in_array($document->getTypeDocument(), ['FACTURE', 'AVOIR']);
  792.                 });
  793.                 break;
  794.             default:
  795.                 $docList = array();
  796.                 break;
  797.         }
  800.         return $this->render('projet/document/document-'. strtolower($typeDocument) .'-list.html.twig', [
  801.             strtolower($typeDocument) .'List' => $docList,
  802.         ]);
  803.     }
  805.     /**
  806.      * @Route("/document/delete-document", methods={"POST"}, name="delete_document")
  807.      */
  808.     public function deleteDocument(Request $request): Response
  809.     {
  810.         //TODO: page erreur entity manager
  811.         if(null===$this->em) return $this->render('misc/404.html.twig');
  813.         // Initialisation du retour Json
  814.         $res = new JsonRes($request->request->all());
  816.         if($res->isSuccess()) {
  818.             $data = $res->getData();
  819.             if(!isset($data['id_document'])) $res->addErrMsg('champs id_document inconnu');
  821.             if($res->isSuccess()) {
  822.                 if(''===$data['id_document']) $res->addErrMsg('champs id_document obligatoire');
  824.                 if($res->isSuccess()) {
  826.                     $documentRepository = $this->em->getRepository(Document::class);
  827.                     /** @var Document $document */
  828.                     $document = $documentRepository->find($data['id_document']);
  829.                     if(null===$document) $res->addErrMsg('Document non identifiée');
  831.                     if($res->isSuccess()) {
  833.                         $docLigneRepository = $this->em->getRepository(DocumentLigne::class);
  834.                         foreach ($document->getDocumentLignes()->toArray() as $documentLigne) {
  835.                             $docLigneRepository->remove($documentLigne);
  836.                         }
  838.                         $documentRepository->remove($document);
  839.                         $res->setData($data);
  840.                     }
  841.                 }
  842.             }
  843.         }
  844.         die($res->returnJson());
  845.     }
  847.     /**
  848.      * @Route("/document/update-tva", methods={"POST"}, name="update_doc_tva")
  849.      */
  850.     public function updateTvaDocument(Request $request): Response
  851.     {
  852.         //TODO: page erreur entity manager
  853.         if(null===$this->em) return $this->render('misc/404.html.twig');
  855.         // Initialisation du retour Json
  856.         $res = new JsonRes($request->request->all());
  857.         if(!$res->isSuccess()) die($res->returnJson());
  859.         $data = $res->getData();
  860.         if(empty($data['id_document'])) $res->addErrMsg('champs id_document obligatoire');
  861.         if(!isset($data['taux_tva'])) $res->addErrMsg('champs taux_tva obligatoire');
  862.         if(!$res->isSuccess()) die($res->returnJson());
  864.         $documentRepository = $this->em->getRepository(Document::class);
  865.         /** @var Document $document */
  866.         $document = $documentRepository->find($data['id_document']);
  867.         if(null===$document) $res->addErrMsg('Document non identifiée');
  868.         if(!$res->isSuccess()) die($res->returnJson());
  870.         /** @var \App\Entity\User $currentUser */
  871.         $currentUser = $this->getUser()->getId();
  873.         foreach ($document->getDocumentLignes() as $documentLigne){
  874.             $documentLigne->setTauxTva(floatval($data['taux_tva']));
  875.             $documentLigne->performMontant();
  876.             $documentLigne->setDateModif(new \DateTime());
  877.             $documentLigne->setUserModif($currentUser);
  878.             $this->em->persist($documentLigne);
  879.             $this->em->flush();
  880.         }
  882.         $document->performMontant();
  883.         $document->setDateModif(new \DateTime());
  884.         $document->setUserModif($currentUser);
  885.         $this->em->persist($document);
  886.         $this->em->flush();
  888.         $res->setData($data);
  889.         die($res->returnJson());
  890.     }
  892.     /**
  893.      * @Route("/document/transform-document", methods={"POST"}, name="transform_document")
  894.      */
  895.     public function transformDocument(Request $request): Response
  896.     {
  897.         //TODO: page erreur entity manager
  898.         if(null===$this->em) return $this->render('misc/404.html.twig');
  900.         // Initialisation du retour Json
  901.         $res = new JsonRes($request->request->all());
  903.         if($res->isSuccess()) {
  905.             $data = $res->getData();
  906.             if(!isset($data['id_document'])) $res->addErrMsg('champs id_document inconnu');
  908.             if($res->isSuccess()) {
  909.                 if(''===$data['id_document']) $res->addErrMsg('champs id_document obligatoire');
  911.                 if($res->isSuccess()) {
  913.                     $documentRepository = $this->em->getRepository(Document::class);
  914.                     /** @var Document $devis */
  915.                     $devis = $documentRepository->find($data['id_document']);
  916.                     if(null===$devis) $res->addErrMsg('Document non identifiée');
  918.                     if($res->isSuccess()) {
  920.                         /** @var \App\Entity\User $currentUser */
  921.                         $currentUser = $this->getUser()->getId();
  923.                         $soucheRepository = $this->em->getRepository(Souche::class);
  924.                         $numSouche = $soucheRepository->generateNumSouche();
  925.                         $numPiece = $devis->getProjet()->getNumProd() .'-'. $numSouche;
  927.                         $facture = new Document();
  928.                         $facture->setProjet( $devis->getProjet() )
  929.                             ->setTiers( $devis->getTiers() )
  930.                             ->setAdresse( $devis->getAdresse() )
  931.                             ->setTypeDocument('FACTURE')
  932.                             ->setReference( $devis->getReference() )
  933.                             ->setNumPiece($numPiece)
  934.                             ->setStatut('envoyé')
  935.                             ->setDateEnvoi(new \DateTime())
  936.                             ->setDateCrea(new \DateTime())
  937.                             ->setUserCrea($currentUser)
  938.                             ->setMontantHt( $devis->getMontantHt() )
  939.                             ->setMontantTva( $devis->getMontantTva() )
  940.                             ->setContact( $devis->getContact() )
  941.                             ->setIdDocOrigine( $devis->getId() )
  942.                             ->setDateBdc( $devis->getDateBdc() )
  943.                             ->setLibProjet( $devis->getLibProjet() )
  944.                             ->setConditionReglement( $devis->getConditionReglement() )
  945.                         ;
  946.                         $this->em->persist($facture);
  947.                         $this->em->flush();
  949.                         foreach ($devis->getDocumentLignes() as $ligne) {
  950.                             $newLigne = new DocumentLigne();
  951.                             $newLigne->setLibelle( $ligne->getLibelle() )
  952.                                 ->setDescription( $ligne->getDescription() )
  953.                                 ->setMontantHt( $ligne->getMontantHt() )
  954.                                 ->setTauxTva( $ligne->getTauxTva() )
  955.                                 ->setMontantTva( $ligne->getMontantTva() )
  956.                                 ->setDateCrea(new \DateTime())
  957.                                 ->setUserCrea($currentUser)
  958.                                 ->setQte( $ligne->getQte() )
  959.                                 ->setPuht( $ligne->getPuht() )
  960.                             ;
  961.                             $facture->addDocumentLigne($newLigne);
  962.                         }
  963.                         $this->em->persist($facture);
  964.                         $this->em->flush();
  966.                         $devis->setIdDocOrigine( $facture->getId() );
  967.                         $this->em->persist($devis);
  968.                         $this->em->flush();
  970.                         $res->setData($data);
  971.                     }
  972.                 }
  973.             }
  974.         }
  975.         die($res->returnJson());
  976.     }
  978.     /**
  979.      * @Route("/document/create-avoir", methods={"POST"}, name="create_avoir")
  980.      */
  981.     public function createAvoir(Request $request): Response
  982.     {
  983.         //TODO: page erreur entity manager
  984.         if(null===$this->em) return $this->render('misc/404.html.twig');
  986.         // Initialisation du retour Json
  987.         $res = new JsonRes($request->request->all());
  988.         if(!$res->isSuccess()) die($res->returnJson());
  990.         $data = $res->getData();
  991.         if(!isset($data['id_document'])) $res->addErrMsg('champs id_document inconnu');
  992.         if(!isset($data['montant_ttc'])) $res->addErrMsg('champs montant_ttc inconnu');
  993.         if(!$res->isSuccess()) die($res->returnJson());
  995.         $documentRepository = $this->em->getRepository(Document::class);
  996.         /** @var Document $facture */
  997.         $facture = $documentRepository->find($data['id_document']);
  998.         if(null===$facture) $res->addErrMsg('Facture non identifiée');
  999.         if(!$res->isSuccess()) die($res->returnJson());
  1001.         /** @var \App\Entity\User $currentUser */
  1002.         $currentUser = $this->getUser()->getId();
  1004.         $soucheRepository = $this->em->getRepository(Souche::class);
  1005.         $numSouche = $soucheRepository->generateNumSouche();
  1006.         $numPiece = $facture->getProjet()->getNumProd() .'-'. $numSouche;
  1008.         $montantAvoir = round(floatval($data['montant_ttc']) * 100)/100;
  1009.         $montantHt = $montantAvoir/1.2;
  1010.         $montantTva = $montantAvoir-$montantHt;
  1012.         $avoir = new Document();
  1013.         $avoir->setProjet( $facture->getProjet() )
  1014.             ->setTiers( $facture->getTiers() )
  1015.             ->setAdresse( $facture->getAdresse() )
  1016.             ->setTypeDocument('AVOIR')
  1017.             ->setReference( $facture->getReference() )
  1018.             ->setNumPiece($numPiece)
  1019.             ->setStatut('avoir')
  1020.             ->setDateEnvoi(new \DateTime())
  1021.             ->setDateCrea(new \DateTime())
  1022.             ->setUserCrea($currentUser)
  1023.             ->setMontantHt($montantHt)
  1024.             ->setMontantTva($montantTva)
  1025.             ->setContact( $facture->getContact() )
  1026.             ->setIdDocOrigine( $facture->getId() )
  1027.             ->setDateBdc( $facture->getDateBdc() )
  1028.             ->setLibProjet( $facture->getLibProjet() )
  1029.         ;
  1030.         $this->em->persist($avoir);
  1031.         $this->em->flush();
  1033.         $newLigne = new DocumentLigne();
  1034.         $newLigne->setLibelle( 'AVOIR' )
  1035.             ->setDescription( 'Facture : '. $facture->getNumPiece())
  1036.             ->setMontantHt($montantHt)
  1037.             ->setTauxTva(0.2)
  1038.             ->setMontantTva($montantTva)
  1039.             ->setDateCrea(new \DateTime())
  1040.             ->setUserCrea($currentUser)
  1041.             ->setQte(1)
  1042.             ->setPuht($montantHt)
  1043.         ;
  1044.         $avoir->addDocumentLigne($newLigne);
  1046.         $this->em->persist($avoir);
  1047.         $this->em->flush();
  1049.         $facture->setStatut('annulé')
  1050.             ->setDateModif(new \DateTime())
  1051.             ->setUserModif($currentUser)
  1052.         ;
  1054.         $this->em->persist($facture);
  1055.         $this->em->flush();
  1058.         $docOrigine = $documentRepository->find($facture->getIdDocOrigine());
  1059.         $docOrigine->setIdDocOrigine(null)
  1060.             ->setDateModif(new \DateTime())
  1061.             ->setUserModif($currentUser)
  1062.         ;
  1064.         $this->em->persist($docOrigine);
  1065.         $this->em->flush();
  1067.         $res->setData($data);
  1068.         die($res->returnJson());
  1069.     }
  1071.     /**
  1072.      * @Route("/document/facture-retard", methods={"GET"}, name="document_facture_retard")
  1073.      */
  1074.     public function factureRetard(): Response
  1075.     {
  1076.         $documentRepository = $this->em->getRepository(Document::class);
  1077.         $factureList = $documentRepository->getFactureNonEchue();
  1078.         $montantEncours = array_reduce($factureList, function ($sum, Document $facture){
  1079.             return $sum+= $facture->getMontantHt();
  1080.         }, 0);
  1084.         $parameters = [
  1085.             'facture_count' => count($factureList),
  1086.             'facture_list' => $this->render('module/module-facture-retard-list.html.twig',['facture_list'=>$factureList])->getContent(),
  1087.             'montant_encours' => $montantEncours,
  1088.         ];
  1089.         return $this->json($parameters);
  1090.     }
  1091. }