src/Controller/DocumentController.php line 46

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-date-echeance", methods={"POST"}, name="update_doc_date_echeance")
  437.      */
  438.     public function updateDateEcheance(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.         $data = $res->getData();
  447.         if(!$this->isGranted('ROLE_ADMIN')) $res->addErrMsg('Vous n\'avez pas les droits pour effectuer cette action');
  448.         if(empty($data['id_document'])) $res->addErrMsg('erreur id_document');
  449.         if(empty($data['date_echeance'])) $res->addErrMsg('erreur date_echeance');
  450.         if(!$res->isSuccess()) die($res->returnJson());
  452.         $dateBudget = date_create_from_format('Y-m-d', $data['date_echeance']);
  453.         if(!$dateBudget) $res->addErrMsg('Le format de la date est incorrect');
  454.         if(!$res->isSuccess()) die($res->returnJson());
  456.         $documentRepository = $this->em->getRepository(Document::class);
  457.         /** @var Document $document */
  458.         $document = $documentRepository->find($data['id_document']);
  459.         if(empty($document)) $res->addErrMsg('Document non trouvé dans la base de donnée');
  460.         if(!$res->isSuccess()) die($res->returnJson());
  463.         /** @var \App\Entity\User $currentUser */
  464.         $currentUser = $this->getUser()->getId();
  465.         $document->setDateEcheance($dateBudget)
  466.             ->setUserModif($currentUser)
  467.             ->setDateModif(new \DateTime())
  468.         ;
  469.         $this->em->persist($document);
  470.         $this->em->flush();
  471.         $res->setData($data);
  472.         die($res->returnJson());
  473.     }
  475.     /**
  476.      * @Route("/document/update-statut", methods={"POST"}, name="update_doc_statut")
  477.      */
  478.     public function updateStatut(Request $request): Response
  479.     {
  480.         //TODO: page erreur entity manager
  481.         if(null===$this->em) return $this->render('misc/404.html.twig');
  483.         // Initialisation du retour Json
  484.         $res = new JsonRes($request->request->all());
  486.         if($res->isSuccess()) {
  488.             $data = $res->getData();
  489.             if(!isset($data['id_document'])) $res->addErrMsg('champs id_document inconnu');
  491.             if($res->isSuccess()) {
  492.                 if(''===$data['id_document']) $res->addErrMsg('champs id_document obligatoire');
  494.                 if($res->isSuccess()) {
  496.                     $documentRepository = $this->em->getRepository(Document::class);
  497.                     /** @var Document $document */
  498.                     $document = $documentRepository->find($data['id_document']);
  499.                     if(!null==$document) {
  500.                         /** @var \App\Entity\User $currentUser */
  501.                         $currentUser = $this->getUser()->getId();
  502.                         $document->setStatut('payé')
  503.                             ->setDatePaiement(new \DateTime())
  504.                             ->setUserModif($currentUser)
  505.                             ->setDateModif(new \DateTime())
  506.                         ;
  508.                         $this->em->persist($document);
  509.                         $this->em->flush();
  510.                     }
  512.                     $res->setData($data);
  513.                 }
  514.             }
  515.         }
  516.         die($res->returnJson());
  517.     }
  519.     /**
  520.      * @Route("/document/insert-ligne", methods={"POST"}, name="insert_ligne")
  521.      */
  522.     public function insertLigne(Request $request): Response
  523.     {
  524.         //TODO: page erreur entity manager
  525.         if(null===$this->em) return $this->render('misc/404.html.twig');
  527.         // Initialisation du retour Json
  528.         $res = new JsonRes($request->request->all());
  530.         if($res->isSuccess()) {
  532.             $data = $res->getData();
  533.             if(!isset($data['id_document'])) $res->addErrMsg('champs id_document inconnu');
  534.             if(!isset($data['id_projet'])) $res->addErrMsg('champs id_projet inconnu');
  535.             if(!isset($data['type_document'])) $res->addErrMsg('champs type_document inconnu');
  536.             if(!isset($data['id_adresse'])) $res->addErrMsg('champs id_adresse inconnu');
  537.             if(!isset($data['lib_projet_document'])) $res->addErrMsg('champs lib_projet_document inconnu');
  538.             if(!isset($data['date_bdc_document'])) $res->addErrMsg('champs date_bdc_document inconnu');
  539.             if(!isset($data['reference_document'])) $res->addErrMsg('champs reference_document inconnu');
  540.             if(!isset($data['contact_document'])) $res->addErrMsg('champs contact_document inconnu');
  541.             if(!isset($data['nouvelle_ligne'])) $res->addErrMsg('champs nouvelle_ligne inconnu');
  542.             if(empty($data['date_budget'])) $res->addErrMsg('erreur date_budget');
  543.             if(!$res->isSuccess()) die($res->returnJson());
  547.             if($res->isSuccess()) {
  548.                 if(''===$data['id_document']) $res->addErrMsg('champs id_document obligatoire');
  549.                 if(''===$data['id_projet']) $res->addErrMsg('champs id_projet obligatoire');
  550.                 if(''===$data['type_document']) $res->addErrMsg('champs type_document obligatoire');
  551.                 if(empty($data['nouvelle_ligne'])) $res->addErrMsg('champs nouvelle_ligne vide');
  553.                 if($res->isSuccess()) {
  554.                     if(!isset($data['nouvelle_ligne']['libelle'])) $res->addErrMsg('champs libelle inconnu');
  555.                     if(!isset($data['nouvelle_ligne']['description'])) $res->addErrMsg('champs description inconnu');
  556.                     if(!isset($data['nouvelle_ligne']['qte'])) $res->addErrMsg('champs qte inconnu');
  557.                     if(!isset($data['nouvelle_ligne']['puht'])) $res->addErrMsg('champs puht inconnu');
  558.                     if(!isset($data['nouvelle_ligne']['taux_tva'])) $res->addErrMsg('champs taux_tva inconnu');
  560.                     if('COMMANDE PRESTATAIRE'===$data['type_document']){
  561.                         if(!isset($data['id_prestataire'])) $res->addErrMsg('champs id_prestataire inconnu');
  562.                     }
  564.                     if($res->isSuccess()) {
  565.                         if(''===$data['nouvelle_ligne']['libelle']) $res->addErrMsg('champs libelle obligatoire');
  566.                         if(''===$data['nouvelle_ligne']['qte']) $res->addErrMsg('champs qte obligatoire');
  567.                         if(''===$data['nouvelle_ligne']['puht']) $res->addErrMsg('champs puht obligatoire');
  568.                         if(''===$data['nouvelle_ligne']['taux_tva']) $res->addErrMsg('champs taux_tva obligatoire');
  570.                         if('COMMANDE PRESTATAIRE'===$data['type_document']){
  571.                             if(''===$data['id_prestataire']) $res->addErrMsg('champs id_prestataire obligatoire');
  572.                         }
  573.                     }
  574.                 }
  576.                 $dateBudget = date_create_from_format('Y-m-d', $data['date_budget']);
  577.                 if(!$dateBudget) $res->addErrMsg('Le format de la date est incorrect');
  579.                 $dateBdc = date_create_from_format('Y-m-d', $data['date_bdc_document']);
  580.                 if(!$dateBdc) $res->addErrMsg('Le format de la date est incorrect');
  582.                 if($res->isSuccess()) {
  584.                     /** @var \App\Entity\User $currentUser */
  585.                     $currentUser = $this->getUser()->getId();
  587.                     /** @var Document $document */
  588.                     $document = null;
  590.                     if(0===intval($data['id_document'])){ // si id_document = 0 alors création du document
  592.                         $projetRepository = $this->em->getRepository(Projet::class);
  593.                         /** @var Projet $projet */
  594.                         $projet = $projetRepository->find($data['id_projet']);
  595.                         if(!null==$projet){
  596.                             $document = new Document();
  597.                             $document->setProjet($projet)
  598.                                 ->setTiers($projet->getSociete())
  599.                                 ->setTypeDocument($data['type_document'])
  600.                                 ->setDateCrea($dateBudget)
  601.                                 ->setUserCrea($currentUser)
  602.                                 ->setMontantHt(0)
  603.                                 ->setMontantTva(0)
  604.                                 ->setReference($data['reference_document'])
  605.                                 ->setContact($data['contact_document'])
  606. //                                ->setLibProjet($data['lib_projet_document']) // pas obligatoire
  607.                                 ->setDateBdc($dateBdc)
  608.                             ;
  610.                             $adresseRepository = $this->em->getRepository(Adresse::class);
  611.                             /**  @var Adresse $adresse */
  612.                             $adresse = $adresseRepository->find($data['id_adresse']);
  613.                             if(null!==$adresse) $document->setAdresse($adresse);
  615.                             $this->em->persist($document);
  616.                             $this->em->flush();
  618.                             $numPiece = 'undefined';
  619.                             if('FACTURE PROFORMA'===$data['type_document']) $numPiece = $projet->getNumProd() .'-'. $document->getId();
  620.                             if('COMMANDE PRESTATAIRE'===$data['type_document']) {
  621.                                 $numPiece = 'BDC-' . $document->getId();
  623.                                 $tiersRepository = $this->em->getRepository(Tiers::class);
  624.                                 $prestataire = $tiersRepository->find($data['id_prestataire']);
  625.                                 if(null!==$prestataire) $document->setTiers($prestataire);
  626.                             }
  627.                             $document->setNumPiece($numPiece);
  629.                             $this->em->persist($document);
  630.                             $this->em->flush();
  632.                             $data['id_document'] = $document->getId();
  633.                         } else {
  634.                             $res->addErrMsg('Projet non identifié');
  635.                         }
  636.                     } else { // sinon update du document
  637.                         $documentRepository = $this->em->getRepository(Document::class);
  638.                         $document = $documentRepository->find($data['id_document']);
  639.                         if(null===$document) $res->addErrMsg('Document non identifié');
  640.                     }
  642.                     if($res->isSuccess()) {
  643.                         $newLigne = $data['nouvelle_ligne'];
  645.                         $ligne = new DocumentLigne();
  646.                         $ligne->setDocument($document)
  647.                             ->setLibelle($newLigne['libelle'])
  648.                             ->setDescription($newLigne['description'])
  649.                             ->setDateCrea(new \DateTime())
  650.                             ->setUserCrea($currentUser)
  651.                             ->setQte($newLigne['qte'])
  652.                             ->setPuht($newLigne['puht'])
  653.                             ->setTauxTva($newLigne['taux_tva'])
  654.                             ->performMontant()
  655.                         ;
  657.                         $document->addDocumentLigne($ligne)
  658.                             ->performMontant()
  659.                             ->setDateModif(new \DateTime())
  660.                             ->setUserModif($currentUser)
  661.                         ;
  662.                         $this->em->persist($document);
  663.                         $this->em->flush();
  665.                         $res->setData($data);
  666.                     }
  667.                 }
  668.             }
  669.         }
  670.         die($res->returnJson());
  671.     }
  673.     /**
  674.      * @Route("/document/update-ligne", methods={"POST"}, name="update_ligne")
  675.      */
  676.     public function updateLigne(Request $request): Response
  677.     {
  678.         //TODO: page erreur entity manager
  679.         if(null===$this->em) return $this->render('misc/404.html.twig');
  681.         // Initialisation du retour Json
  682.         $res = new JsonRes($request->request->all());
  684.         if(!$res->isSuccess()) die($res->returnJson());
  685.         $data = $res->getData();
  687.         if(empty($data['id_ligne'])) $res->addErrMsg('champs id_ligne obligatoire');
  688.         if(empty($data['libelle'])) $res->addErrMsg('champs libelle obligatoire');
  689.         if(empty($data['qte'])) $res->addErrMsg('champs qte obligatoire');
  690.         if(empty($data['puht'])) $res->addErrMsg('champs puht obligatoire');
  691.         if(empty($data['taux_tva'])) $res->addErrMsg('champs taux_tva obligatoire');
  692.         if(!$res->isSuccess()) die($res->returnJson());
  694.         $docLigneRepository = $this->em->getRepository(DocumentLigne::class);
  695.         $ligne = $docLigneRepository->find($data['id_ligne']);
  696.         if(null===$ligne) $res->addErrMsg('Ligne document non identifiée');
  697.         if(!$res->isSuccess()) die($res->returnJson());
  699.         /** @var \App\Entity\User $currentUser */
  700.         $currentUser = $this->getUser()->getId();
  702.         $ligne->setLibelle($data['libelle'])
  703.             ->setDescription($data['description'])
  704.             ->setDateModif(new \DateTime())
  705.             ->setUserModif($currentUser)
  706.             ->setQte($data['qte'])
  707.             ->setPuht($data['puht'])
  708.             ->setTauxTva($data['taux_tva'])
  709.             ->performMontant()
  710.         ;
  711.         $this->em->persist($ligne);
  712.         $this->em->flush();
  714.         $document = $ligne->getDocument();
  715.         $document->performMontant()
  716.             ->setDateModif(new \DateTime())
  717.             ->setUserModif($currentUser)
  718.         ;
  719.         $this->em->persist($document);
  720.         $this->em->flush();
  722.         $data['id_document'] = $document->getId();
  723.         $res->setData($data);
  725.         die($res->returnJson());
  726.     }
  728.     /**
  729.      * @Route("/document/delete-ligne", methods={"POST"}, name="delete_ligne")
  730.      */
  731.     public function deleteLigne(Request $request): Response
  732.     {
  733.         //TODO: page erreur entity manager
  734.         if(null===$this->em) return $this->render('misc/404.html.twig');
  736.         // Initialisation du retour Json
  737.         $res = new JsonRes($request->request->all());
  739.         if($res->isSuccess()) {
  741.             $data = $res->getData();
  742.             if(!isset($data['id_document'])) $res->addErrMsg('champs id_document inconnu');
  743.             if(!isset($data['id_ligne'])) $res->addErrMsg('champs id_ligne inconnu');
  745.             if($res->isSuccess()) {
  746.                 if(''===$data['id_document']) $res->addErrMsg('champs id_document obligatoire');
  747.                 if(''===$data['id_ligne']) $res->addErrMsg('champs id_ligne obligatoire');
  749.                 if($res->isSuccess()) {
  751.                     /** @var \App\Entity\User $currentUser */
  752.                     $currentUser = $this->getUser()->getId();
  754.                     $docLigneRepository = $this->em->getRepository(DocumentLigne::class);
  755.                     /** @var DocumentLigne $docLigne */
  756.                     $docLigne = $docLigneRepository->find($data['id_ligne']);
  757.                     if(null===$docLigne) $res->addErrMsg('Ligne document non identifiée');
  759.                     if($res->isSuccess()) {
  760.                         $docLigneRepository->remove($docLigne);
  761.                         $document = $docLigne->getDocument()
  762.                             ->performMontant()
  763.                             ->setDateModif(new \DateTime())
  764.                             ->setUserModif($currentUser)
  765.                         ;
  767.                         $this->em->persist($document);
  768.                         $this->em->flush();
  770.                         $res->setData($data);
  771.                     }
  772.                 }
  773.             }
  774.         }
  775.         die($res->returnJson());
  776.     }
  778.     /**
  779.      * @Route("/document/edit/{id}", methods={"GET"}, name="edit_document")
  780.      */
  781.     public function getDocumentForEdit($id)
  782.     {
  783.         $documentRepository = $this->em->getRepository(Document::class);
  784.         $document = $documentRepository->find($id);
  786.         return $this->render('projet/document/document-form.html.twig', [
  787.             'societe' => $this->dataSociete,
  788.             'document' => $document,
  789.             'label_btn_cancel' => 'Supprimer',
  790.         ]);
  791.     }
  793.     /**
  794.      * @Route("/document/vierge/{id}", methods={"GET"}, name="init_document_vierge")
  795.      */
  796.     public function getDocumentVierge($id)
  797.     {
  798.         $projetRepository = $this->em->getRepository(Projet::class);
  799.         /** @var Projet $projet */
  800.         $projet = $projetRepository->find($id);
  801.         if(null===$projet) return $this->render('misc/404.html.twig');
  803.         $documentVierge = new Document();
  804.         $documentVierge->initDocVierge($projet, 'FACTURE PROFORMA');
  806.         return $this->render('projet/document/document-form.html.twig', [
  807.             'societe' => $this->dataSociete,
  808.             'document_vierge' => $documentVierge,
  809.             'label_btn_cancel' => 'Annuler',
  810.         ]);
  811.     }
  813.     /**
  814.      * @Route("/document/reload-list/{typeDocument}/{idProjet}", methods={"GET"}, name="document_reload_list")
  815.      */
  816.     public function documentReloadList($typeDocument, $idProjet)
  817.     {
  818.         $projetRepository = $this->em->getRepository(Projet::class);
  819.         /** @var Projet $projet */
  820.         $projet = $projetRepository->find($idProjet);
  821.         $docList = array();
  822.         switch ($typeDocument){
  823.             case 'FACTURE PROFORMA':
  824.                 $docList = $projet->getDocuments()->filter(function (Document $document){
  825.                     return $document->getTypeDocument() === 'FACTURE PROFORMA';
  826.                 });
  827.                 $typeDocument = 'devis';
  828.                 break;
  829.             case 'FACTURE':
  830.                 $docList = $projet->getDocuments()->filter(function (Document $document){
  831.                     return in_array($document->getTypeDocument(), ['FACTURE', 'AVOIR']);
  832.                 });
  833.                 break;
  834.             default:
  835.                 $docList = array();
  836.                 break;
  837.         }
  840.         return $this->render('projet/document/document-'. strtolower($typeDocument) .'-list.html.twig', [
  841.             strtolower($typeDocument) .'List' => $docList,
  842.         ]);
  843.     }
  845.     /**
  846.      * @Route("/document/delete-document", methods={"POST"}, name="delete_document")
  847.      */
  848.     public function deleteDocument(Request $request): Response
  849.     {
  850.         //TODO: page erreur entity manager
  851.         if(null===$this->em) return $this->render('misc/404.html.twig');
  853.         // Initialisation du retour Json
  854.         $res = new JsonRes($request->request->all());
  856.         if($res->isSuccess()) {
  858.             $data = $res->getData();
  859.             if(!isset($data['id_document'])) $res->addErrMsg('champs id_document inconnu');
  861.             if($res->isSuccess()) {
  862.                 if(''===$data['id_document']) $res->addErrMsg('champs id_document obligatoire');
  864.                 if($res->isSuccess()) {
  866.                     $documentRepository = $this->em->getRepository(Document::class);
  867.                     /** @var Document $document */
  868.                     $document = $documentRepository->find($data['id_document']);
  869.                     if(null===$document) $res->addErrMsg('Document non identifiée');
  871.                     if($res->isSuccess()) {
  873.                         $docLigneRepository = $this->em->getRepository(DocumentLigne::class);
  874.                         foreach ($document->getDocumentLignes()->toArray() as $documentLigne) {
  875.                             $docLigneRepository->remove($documentLigne);
  876.                         }
  878.                         $documentRepository->remove($document);
  879.                         $res->setData($data);
  880.                     }
  881.                 }
  882.             }
  883.         }
  884.         die($res->returnJson());
  885.     }
  887.     /**
  888.      * @Route("/document/update-tva", methods={"POST"}, name="update_doc_tva")
  889.      */
  890.     public function updateTvaDocument(Request $request): Response
  891.     {
  892.         //TODO: page erreur entity manager
  893.         if(null===$this->em) return $this->render('misc/404.html.twig');
  895.         // Initialisation du retour Json
  896.         $res = new JsonRes($request->request->all());
  897.         if(!$res->isSuccess()) die($res->returnJson());
  899.         $data = $res->getData();
  900.         if(empty($data['id_document'])) $res->addErrMsg('champs id_document obligatoire');
  901.         if(!isset($data['taux_tva'])) $res->addErrMsg('champs taux_tva obligatoire');
  902.         if(!$res->isSuccess()) die($res->returnJson());
  904.         $documentRepository = $this->em->getRepository(Document::class);
  905.         /** @var Document $document */
  906.         $document = $documentRepository->find($data['id_document']);
  907.         if(null===$document) $res->addErrMsg('Document non identifiée');
  908.         if(!$res->isSuccess()) die($res->returnJson());
  910.         /** @var \App\Entity\User $currentUser */
  911.         $currentUser = $this->getUser()->getId();
  913.         foreach ($document->getDocumentLignes() as $documentLigne){
  914.             $documentLigne->setTauxTva(floatval($data['taux_tva']));
  915.             $documentLigne->performMontant();
  916.             $documentLigne->setDateModif(new \DateTime());
  917.             $documentLigne->setUserModif($currentUser);
  918.             $this->em->persist($documentLigne);
  919.             $this->em->flush();
  920.         }
  922.         $document->performMontant();
  923.         $document->setDateModif(new \DateTime());
  924.         $document->setUserModif($currentUser);
  925.         $this->em->persist($document);
  926.         $this->em->flush();
  928.         $res->setData($data);
  929.         die($res->returnJson());
  930.     }
  932.     /**
  933.      * @Route("/document/transform-document", methods={"POST"}, name="transform_document")
  934.      */
  935.     public function transformDocument(Request $request): Response
  936.     {
  937.         //TODO: page erreur entity manager
  938.         if(null===$this->em) return $this->render('misc/404.html.twig');
  940.         // Initialisation du retour Json
  941.         $res = new JsonRes($request->request->all());
  943.         if($res->isSuccess()) {
  945.             $data = $res->getData();
  946.             if(!isset($data['id_document'])) $res->addErrMsg('champs id_document inconnu');
  948.             if($res->isSuccess()) {
  949.                 if(''===$data['id_document']) $res->addErrMsg('champs id_document obligatoire');
  951.                 if($res->isSuccess()) {
  953.                     $documentRepository = $this->em->getRepository(Document::class);
  954.                     /** @var Document $devis */
  955.                     $devis = $documentRepository->find($data['id_document']);
  956.                     if(null===$devis) $res->addErrMsg('Document non identifiée');
  958.                     if($res->isSuccess()) {
  960.                         /** @var \App\Entity\User $currentUser */
  961.                         $currentUser = $this->getUser()->getId();
  963.                         $soucheRepository = $this->em->getRepository(Souche::class);
  964.                         $numSouche = $soucheRepository->generateNumSouche();
  965.                         $numPiece = $devis->getProjet()->getNumProd() .'-'. $numSouche;
  967.                         $facture = new Document();
  968.                         $facture->setProjet( $devis->getProjet() )
  969.                             ->setTiers( $devis->getTiers() )
  970.                             ->setAdresse( $devis->getAdresse() )
  971.                             ->setTypeDocument('FACTURE')
  972.                             ->setReference( $devis->getReference() )
  973.                             ->setNumPiece($numPiece)
  974.                             ->setStatut('envoyé')
  975.                             ->setDateEnvoi(new \DateTime())
  976.                             ->setDateCrea(new \DateTime())
  977.                             ->setUserCrea($currentUser)
  978.                             ->setMontantHt( $devis->getMontantHt() )
  979.                             ->setMontantTva( $devis->getMontantTva() )
  980.                             ->setContact( $devis->getContact() )
  981.                             ->setIdDocOrigine( $devis->getId() )
  982.                             ->setDateBdc( $devis->getDateBdc() )
  983.                             ->setLibProjet( $devis->getLibProjet() )
  984.                             ->setConditionReglement( $devis->getConditionReglement() )
  985.                         ;
  987.                         $today = new \DateTime();
  988.                         $endOfNextMonth = $today->modify('+2 month')->modify('last day of this month');
  989.                         $facture->setDateEcheance($endOfNextMonth);
  991.                         $this->em->persist($facture);
  992.                         $this->em->flush();
  994.                         foreach ($devis->getDocumentLignes() as $ligne) {
  995.                             $newLigne = new DocumentLigne();
  996.                             $newLigne->setLibelle( $ligne->getLibelle() )
  997.                                 ->setDescription( $ligne->getDescription() )
  998.                                 ->setMontantHt( $ligne->getMontantHt() )
  999.                                 ->setTauxTva( $ligne->getTauxTva() )
  1000.                                 ->setMontantTva( $ligne->getMontantTva() )
  1001.                                 ->setDateCrea(new \DateTime())
  1002.                                 ->setUserCrea($currentUser)
  1003.                                 ->setQte( $ligne->getQte() )
  1004.                                 ->setPuht( $ligne->getPuht() )
  1005.                             ;
  1006.                             $facture->addDocumentLigne($newLigne);
  1007.                         }
  1008.                         $this->em->persist($facture);
  1009.                         $this->em->flush();
  1011.                         $devis->setIdDocOrigine( $facture->getId() );
  1012.                         $this->em->persist($devis);
  1013.                         $this->em->flush();
  1015.                         $res->setData($data);
  1016.                     }
  1017.                 }
  1018.             }
  1019.         }
  1020.         die($res->returnJson());
  1021.     }
  1023.     /**
  1024.      * @Route("/document/create-avoir", methods={"POST"}, name="create_avoir")
  1025.      */
  1026.     public function createAvoir(Request $request): Response
  1027.     {
  1028.         //TODO: page erreur entity manager
  1029.         if(null===$this->em) return $this->render('misc/404.html.twig');
  1031.         // Initialisation du retour Json
  1032.         $res = new JsonRes($request->request->all());
  1033.         if(!$res->isSuccess()) die($res->returnJson());
  1035.         $data = $res->getData();
  1036.         if(!isset($data['id_document'])) $res->addErrMsg('champs id_document inconnu');
  1037.         if(!isset($data['montant_ttc'])) $res->addErrMsg('champs montant_ttc inconnu');
  1038.         if(!$res->isSuccess()) die($res->returnJson());
  1040.         $documentRepository = $this->em->getRepository(Document::class);
  1041.         /** @var Document $facture */
  1042.         $facture = $documentRepository->find($data['id_document']);
  1043.         if(null===$facture) $res->addErrMsg('Facture non identifiée');
  1044.         if(!$res->isSuccess()) die($res->returnJson());
  1046.         /** @var \App\Entity\User $currentUser */
  1047.         $currentUser = $this->getUser()->getId();
  1049.         $soucheRepository = $this->em->getRepository(Souche::class);
  1050.         $numSouche = $soucheRepository->generateNumSouche();
  1051.         $numPiece = $facture->getProjet()->getNumProd() .'-'. $numSouche;
  1053.         $montantAvoir = round(floatval($data['montant_ttc']) * 100)/100;
  1054.         $montantHt = $montantAvoir/1.2;
  1055.         $montantTva = $montantAvoir-$montantHt;
  1057.         $avoir = new Document();
  1058.         $avoir->setProjet( $facture->getProjet() )
  1059.             ->setTiers( $facture->getTiers() )
  1060.             ->setAdresse( $facture->getAdresse() )
  1061.             ->setTypeDocument('AVOIR')
  1062.             ->setReference( $facture->getReference() )
  1063.             ->setNumPiece($numPiece)
  1064.             ->setStatut('avoir')
  1065.             ->setDateEnvoi(new \DateTime())
  1066.             ->setDateCrea(new \DateTime())
  1067.             ->setUserCrea($currentUser)
  1068.             ->setMontantHt($montantHt)
  1069.             ->setMontantTva($montantTva)
  1070.             ->setContact( $facture->getContact() )
  1071.             ->setIdDocOrigine( $facture->getId() )
  1072.             ->setDateBdc( $facture->getDateBdc() )
  1073.             ->setLibProjet( $facture->getLibProjet() )
  1074.         ;
  1075.         $this->em->persist($avoir);
  1076.         $this->em->flush();
  1078.         $newLigne = new DocumentLigne();
  1079.         $newLigne->setLibelle( 'AVOIR' )
  1080.             ->setDescription( 'Facture : '. $facture->getNumPiece())
  1081.             ->setMontantHt($montantHt)
  1082.             ->setTauxTva(0.2)
  1083.             ->setMontantTva($montantTva)
  1084.             ->setDateCrea(new \DateTime())
  1085.             ->setUserCrea($currentUser)
  1086.             ->setQte(1)
  1087.             ->setPuht($montantHt)
  1088.         ;
  1089.         $avoir->addDocumentLigne($newLigne);
  1091.         $this->em->persist($avoir);
  1092.         $this->em->flush();
  1094.         $facture->setStatut('annulé')
  1095.             ->setDateModif(new \DateTime())
  1096.             ->setUserModif($currentUser)
  1097.         ;
  1099.         $this->em->persist($facture);
  1100.         $this->em->flush();
  1103.         $docOrigine = $documentRepository->find($facture->getIdDocOrigine());
  1104.         $docOrigine->setIdDocOrigine(null)
  1105.             ->setDateModif(new \DateTime())
  1106.             ->setUserModif($currentUser)
  1107.         ;
  1109.         $this->em->persist($docOrigine);
  1110.         $this->em->flush();
  1112.         $res->setData($data);
  1113.         die($res->returnJson());
  1114.     }
  1116.     /**
  1117.      * @Route("/document/facture-retard", methods={"GET"}, name="document_facture_retard")
  1118.      */
  1119.     public function factureRetard(): Response
  1120.     {
  1121.         $documentRepository = $this->em->getRepository(Document::class);
  1122.         $factureList = $documentRepository->getFactureNonEchue();
  1123.         $montantEncours = array_reduce($factureList, function ($sum, Document $facture){
  1124.             return $sum+= $facture->getMontantHt();
  1125.         }, 0);
  1129.         $parameters = [
  1130.             'facture_count' => count($factureList),
  1131.             'facture_list' => $this->render('module/module-facture-retard-list.html.twig',['facture_list'=>$factureList])->getContent(),
  1132.             'montant_encours' => $montantEncours,
  1133.         ];
  1134.         return $this->json($parameters);
  1135.     }
  1136. }