src/Services/Platform/DevisTools.php line 56

Open in your IDE?
  1. <?php
  2. //----------------------------------------------------------------------
  3. // src/Services/Platform/DevisTools.php
  4. //----------------------------------------------------------------------
  5. namespace App\Services\Platform;
  7. use Doctrine\Common\Collections\ArrayCollection;
  8. use Doctrine\Persistence\ManagerRegistry;
  9. use Symfony\Component\Security\Core\Security;
  10. use Symfony\Contracts\Translation\TranslatorInterface;
  12. use App\Services\Common\TextTools;
  13. use App\Services\Location\AddressTools;
  14. use App\Services\LogTools;
  15. use App\Services\Product\ProductTools;
  17. use App\Entity\Access;
  18. use App\Entity\Client\Client;
  19. use App\Entity\Common\Attachment;
  20. use App\Entity\Ikea\Product as IkeaProduct;
  21. use App\Entity\Ikea\TemplateProduct as IkeaTemplateProduct;
  22. use App\Entity\Ikea\Template as IkeaTemplate;
  23. use App\Entity\Ikea\TemplateData;
  24. use App\DTO\Ikea\ViewMethod2026Data;
  25. use App\Entity\Planning\Task;
  26. use App\Entity\Platform\Devis\Devis;
  27. use App\Entity\Platform\Devis\DevisProduct;
  28. use App\Entity\Platform\Devis\DevisStatus;
  29. use App\Entity\Platform\Invoice\Invoice;
  30. use App\Entity\Platform\Invoice\InvoiceProduct;
  31. use App\Entity\Planning\TaskStatus;
  32. use App\Entity\Platform\Society;
  33. use App\Entity\Product\Config as ProductConfig;
  34. use App\Entity\Product\Product;
  35. use App\Entity\Product\Unit;
  36. use App\Entity\ProjectManager\ProjectNotebook;
  37. use App\Services\Ding\AdvancedNotificationTools;
  38. use App\Services\Product\ProductConfigTools;
  40. class DevisTools
  41. {
  42.     public function __construct(
  43.         ManagerRegistry $doctrine, TranslatorInterface $translator,
  44.         TextTools $textTools, AddressTools $addressTools,
  45.         ProductTools $productTools, Security $security, LogTools $logTools, AdvancedNotificationTools $advancedNotificationTools,
  46.         ProductConfigTools $productConfigTools
  47.     )
  48.     {
  49.         $this->em = $doctrine->getManager();
  50.         $this->translator = $translator;
  52.         $this->logTools = $logTools;
  54.         $this->textTools = $textTools;
  55.         $this->addressTools = $addressTools;
  56.         $this->productTools = $productTools;
  57.         $this->advancedNotificationTools = $advancedNotificationTools;
  58.         $this->productConfigTools = $productConfigTools;
  60.         $this->security = $security;
  61.     }
  63.     // Plan.io Task #4624
  64.     public function belongsToProjectManager(Devis $devis)
  65.     {
  66.         if ($devis->getProjectNotebook() !== null)
  67.         {
  68.             return true;
  69.         }
  71.         $notebook = $this->em->getRepository(ProjectNotebook::class)
  72.             ->findOneByPreparatoryWorkDevis($devis);
  73.         if ($notebook !== null)
  74.         {
  75.             return true;
  76.         }
  78.         $notebook = $this->em->getRepository(ProjectNotebook::class)
  79.             ->findOneByFinishingWorkDevis($devis);
  80.         if ($notebook !== null)
  81.         {
  82.             return true;
  83.         }
  85.         // ALl hope is lost
  86.         return false;
  87.     }
  89.     // Plan.io Task #4593
  90.     public function getLinearMeterData(Devis $devis)
  91.     {
  92.         $templateData = $devis->getIkeaTemplateData();
  93.         if ($templateData === null)
  94.         {
  95.             return null;
  96.         }
  98.         $methodVersion = intval($devis->getMethodVersion());
  100.         // Decide if 2025 or 2026
  101.         if ($methodVersion == 2026)
  102.         {                        
  103.             return $templateData->getViewMethod2026Dto();            
  104.         }
  105.         
  106.         if ($methodVersion == 2025)
  107.         {            
  108.             return $templateData->getViewMethod2025Dto();
  109.         }
  111.         return null;
  112.     }
  113.     
  114.     // Plan.io Task #4383
  115.     // We want a list of IkeaServiceOrders which meet all the following criteria
  116.     //        - ServiceOrder is attached to Devis->Mission
  117.     //        - ServiceOrder->orderNumber = Devis->ikeaOrderNumber
  118.     //        - ServiceOrder->isAfterSalesService
  119.     //            (ie. ServiceOrder->serviceCode in ServiceOrder::SAV_SERVICE_CODES)
  120.     public function getIkeaSavServiceOrders(Devis $devis)
  121.     {
  122.         if (!$this->devisIsIkeaSAV($devis))
  123.         {
  124.             // Not a Ikea SAV Devis => Die.Hard
  125.             return new ArrayCollection();
  126.         }
  128.         // At this point we know that
  129.         //    - the Devis has a non empty ikeaOrderNumber
  130.         //     - the Devis has a not null mission
  131.         //     - the Mission has at least one Ikea ServiceOrder with a SAV ServiceCode
  132.         $devisIkeaOrderNumber = $devis->getIkeaOrderNumber();
  133.         $mission = $devis->getMission();
  135.         $ikeaServiceOrders = new ArrayCollection();
  137.         foreach ($mission->getIkeaServiceOrders() as $so)
  138.         {
  139.             if ($devis->getIkeaOrderNumber() != $so->getOrderNumber())
  140.             {
  141.                 // Not the same Order Number => Skip
  142.                 continue;
  143.             }
  144.             if (!$so->isAfterSalesService())
  145.             {
  146.                 // Not a "SAV" Service Code => Skip
  147.                 continue;
  148.             }
  150.             // All looks good
  151.             if ($ikeaServiceOrders->contains($so))
  152.             {
  153.                 // Already added => Skip
  154.                 continue;
  155.             }
  157.             $ikeaServiceOrders[] = $so;
  158.         }
  160.         return $ikeaServiceOrders;
  161.     }
  163.     // Plan.io Task #4383
  164.     // "Ikea SAV" Devis = a "timming" Devis linked to an "SAV" Ikea ServiceOrder
  165.     // Check Devis not annulled | refused
  166.     public function devisIsIkeaSAV(Devis $devis)
  167.     {
  168.         if ($devis->isAnnulled() || $devis->isRefused())
  169.         {
  170.             return false;
  171.         }
  173.         if (empty($devis->getIkeaOrderNumber()))
  174.         {
  175.             // Not a Ikea Devis => Die.Hard
  176.             return false;
  177.         }
  179.         if (!$devis->hasHourProduct())
  180.         {
  181.             // Not a "timming" Devis => Die.Hard
  182.             return false;
  183.         }
  185.         $mission = $devis->getMission();
  186.         if ($mission === null)
  187.         {
  188.             // This should not happen
  189.             return false;
  190.         }
  192.         if (empty($mission->getIkeaServiceOrders()))
  193.         {
  194.             // Not a Ikea Mission => Die.Hard
  195.             // However since the Devis has an ikeaOrderNumber this should not happen
  196.             return false;
  197.         }
  199.         foreach ($mission->getIkeaServiceOrders() as $ikeaServiceOrder)
  200.         {
  201.             if ($devis->getIkeaOrderNumber() != $ikeaServiceOrder->getOrderNumber())
  202.             {
  203.                 // Not the same Order Number => Skip
  204.                 continue;
  205.             }
  206.             if (!$ikeaServiceOrder->isAfterSalesService())
  207.             {
  208.                 // Not a "SAV" Service Code => Skip
  209.                 continue;
  210.             }
  212.             // If we are here it means we have
  213.             // a "timming" Devis linked to an "SAV" Ikea ServiceOrder
  214.             // => All looks good
  215.             return true;
  216.         }
  218.         // All hope is lost
  219.         return false;
  220.     }
  222.     // Plan.io Task #3793
  223.     public function sign(Devis $devis, Access $coAuthor)
  224.     {
  225.         $societyGroup = $devis->getSocietyGroup();
  226.         if ($societyGroup === null)
  227.         {
  228.             // This should not happen
  229.             $this->logTools->errorlog("SocietyGroup is null for Devis ".$devis->displayForLog());
  230.             return false;
  231.         }
  233.         if ($devis->hasSignature() === false)
  234.         {
  235.             // This should not happen
  236.             return false;
  237.         }
  239.         // Update Signature date and co-author
  240.         $devis->setSignatureDate(new \DateTime());
  241.         $devis->setSignatureCoAuthor($coAuthor);
  243.         // Change status to accepted
  244.         $acceptedStatus = $this->em->getRepository(DevisStatus::class)
  245.             ->findOneBy(array(
  246.                 'societyGroup'        =>    $societyGroup,
  247.                 'accepted'            =>    1,
  248.             ));
  249.         if ($acceptedStatus === null)
  250.         {
  251.             // This should not happen
  252.             $this->logTools->errorlog("Accepted DevisStatus is null for societyGroup ".$societyGroup->displayForLog());
  253.             return false;
  254.         }
  256.         $devis->setStatus($acceptedStatus);
  258.         // All looks good
  259.         return true;
  260.     }
  262.     // Plan.io Task #2849
  263.     public function detectReInvoicingProblem($devis)
  264.     {
  265.         // The problem only arises when trying to re-invoice a devis with installments
  266.         if ($devis->getInstallments()->count() < 1)
  267.         {
  268.             return null;
  269.         }
  271.         // No invoice, no problem
  272.         // if ($devis->getInvoices()->count() < 1)
  273.         // Plan.io Task #4326 : Only consider actual invoices, and exclude drafts
  274.         if ($devis->getInvoicesOnly()->count() < 1)
  275.         {
  276.             return null;
  277.         }
  279.         // If we are here it means that the devis has installments and invoices
  280.         // Just check to see if any of them match
  281.         foreach ($devis->getInstallments() as $installment)
  282.         {
  283.             if ($installment->getLinkInvoice() !== null)
  284.             {
  285.                 $invoice = $installment->getLinkInvoice()->getInvoice();
  287.                 if ($invoice !== null)
  288.                 {
  289.                     // This installment is linked to an invoice
  290.                     // Does the invoice have a credit invoice ?
  291.                     // Plan.io Task #4326 : Do not take drafts into account
  292.                     $credit = $this->em->getRepository(Invoice::class)->findOneBy(array(
  293.                         'creditInvoice'        =>    $invoice,
  294.                         'draft'                =>    0,
  295.                     ));
  297.                     if ($credit !== null)
  298.                     {
  299.                         return array(
  300.                             'devis'            =>    $devis,
  301.                             'invoice'        =>    $invoice,
  302.                             'credit'        =>    $credit,
  303.                         );
  304.                     }
  305.                 }
  306.             }
  307.         }
  309.         return null;
  310.     }
  312.     /**
  313.      * Plan.io Task #3867 - Retrieves and calculates profitability data
  314.      *
  315.      * @param Devis $devis
  316.      * @return array {
  317.      *     profitability: int,
  318.      *     profitabilityPercent: int,
  319.      *     totalCostProducts: int,
  320.      *     interventionCost: int,
  321.      *     totalCost: int,
  322.      * }
  323.      */
  324.     public function getDataTiming(Devis $devis)
  325.     {
  326.         $totalCostProducts = 0;
  327.         foreach ($devis->getProducts() as $product)
  328.         {
  329.             $totalCostProducts += $product->getRefCost() * $product->getQuantity();
  330.         }
  332.         $interventionCost = 0;
  333.         $society = $devis->getSociety();
  334.         if ($society !== null)
  335.         {
  336.             // Switch for % or fixe value
  337.             if ($society->getInterventionCostType() == Society::INT_COST_TYPE_PERCENT)
  338.             {
  339.                 $interventionCost = $devis->getTotalInternalHTAfterDiscount() * $society->getInterventionCostPercent() / 100;
  340.             }
  341.             else if ($society->getInterventionCostType() == Society::INT_COST_TYPE_FIXE)
  342.             {
  343.                 $interventionCost = $society->getInterventionCost();
  344.             }
  345.         }
  347.         $otherCostProvision = $devis->getOtherCostProvision();
  349.         $totalCost = $totalCostProducts + $interventionCost + $otherCostProvision;
  351.         $profitability = $devis->getTotalInternalHTAfterDiscount() - $totalCost;
  353.         if($devis->getTotalInternalHTAfterDiscount() != 0)
  354.         {
  355.             $profitabilityPercent = $profitability / $devis->getTotalInternalHTAfterDiscount() * 100;
  356.         }
  357.         else
  358.         {
  359.             $profitabilityPercent = 0;
  360.         }
  362.         return array(
  363.             "profitability"         => $profitability,
  364.             "profitabilityPercent"     => $profitabilityPercent,
  365.             "totalCostProducts"     => $totalCostProducts,
  366.             "interventionCost"         => $interventionCost,
  367.             "totalCost"             => $totalCost,
  368.         );
  369.     }
  371.     public function suggestEmitters($devis, $access, $mission)
  372.     {
  373.         $receiver = $devis->getReceiver();
  374.         if ($receiver === null)
  375.         {
  376.             return array();
  377.         }
  379.         $individual = $receiver->getIndividual();
  380.         if ($individual === null)
  381.         {
  382.             // Store, this one is simple
  383.             $devis->setEmitter($receiver);
  384.             return array($receiver);
  385.         }
  387.         $clientRepository = $this->em->getRepository(Client::class);
  388.         $emitterIds = array();
  389.         $emitters = new ArrayCollection();
  391.         // Lesson learned : Do not use ArrayCollection->contains on big collections
  392.         // ArrayCollection::contains() compares object identity (===), not database ID. 
  393.         // The same client loaded via different paths can be a different PHP instance, 
  394.         // so duplicates pile up and contains() does expensive linear scans on a growing collection.
  395.         
  396.         // Fetch store clients via DQL instead of traversing Access->Society->Store->Client
  397.         // (ArrayCollection::contains uses identity comparison and loads the full entity graph)
  398.         foreach ($clientRepository->getStoreClientsForAccessAndSociety($access, $mission->getSociety()) as $client)
  399.         {
  400.             $id = $client->getId();
  401.             if ($id !== null && !isset($emitterIds[$id]))
  402.             {
  403.                 $emitterIds[$id] = true;
  404.                 $emitters[] = $client;
  405.             }
  406.         }
  408.         // Also add the emitters of the individual
  409.         foreach ($clientRepository->getStoresForIndividual($receiver) as $client)
  410.         {
  411.             $id = $client->getId();
  412.             if ($id !== null && !isset($emitterIds[$id]))
  413.             {
  414.                 $emitterIds[$id] = true;
  415.                 $emitters[] = $client;
  416.             }
  417.         }
  419.         // Add the mission emitter
  420.         $missionEmitter = $mission->getEmitter();
  421.         if ($missionEmitter !== null)
  422.         {
  423.             // Make sure the select contains the good (default) emitter also
  424.             $missionEmitterId = $missionEmitter->getId();
  425.             if ($missionEmitterId !== null && !isset($emitterIds[$missionEmitterId]))
  426.             {
  427.                 $emitterIds[$missionEmitterId] = true;
  428.                 $emitters[] = $missionEmitter;
  429.             }
  431.             // Set emitter
  432.             $devis->setEmitter($missionEmitter);
  433.         }
  434.         else
  435.         {
  436.             // Mission has no emitters
  437.             // But does the access have any ? (this is like MissionController::addAction)
  438.             if (count($emitters))
  439.             {
  440.                 // Get the first one
  441.                 $emitter = $emitters[0];
  442.                 $devis->setEmitter($emitter);
  443.             }
  444.             else
  445.             {
  446.                 // All hope is lost, set emitter just like receiver
  447.                 $devis->setEmitter($receiver);
  448.             }
  449.         }
  451.         // Sort emitters
  452.         if (count($emitters))
  453.         {
  454.             $iterator = $emitters->getIterator();
  455.             $iterator->uasort(function ($first, $second) {
  456.                 return (int) $first->getName() < (int) $second->getName() ? 1 : -1;
  457.             });
  458.             $emitters = $iterator;
  459.         }
  461.         $emitters = new ArrayCollection(iterator_to_array($emitters));
  462.         return $emitters;
  463.     }
  465.     public function handleFiles($devis)
  466.     {
  467.         $attachmentRepository = $this->em->getRepository(Attachment::class);
  468.         $files = $devis->getFiles();
  470.         if ($files !== null)
  471.         {
  472.             $files = json_decode($files, true);
  474.             foreach ($files as $uuid)
  475.             {
  476.                 $attachment = $attachmentRepository->findOneByUuid($uuid);
  477.                 if ($attachment !== null)
  478.                     $devis->addAttachment($attachment);
  479.             }
  480.         }
  481.     }
  483.     public function devisToArray($devis)
  484.     {
  485.         $authorId = null;
  486.         $authorUsername = null;
  488.         $societyId = null;
  489.         $societyRef = null;
  490.         $societyName = null;
  492.         $societyGroupId = null;
  493.         $societyGroupRef = null;
  494.         $societyGroupName = null;
  496.         $receiverIsIndividual = 0;
  497.         $receiverId = null;
  498.         $receiverName = null;
  499.         $receiverLastname = null;
  500.         $receiverFirstname = null;
  501.         $receiverPhone = null;
  502.         $receiverEmail = null;
  503.         $receiverAddress = null;
  504.         $receiverComplement = null;
  505.         $receiverPostalCode = null;
  506.         $receiverTown = null;
  507.         $receiverCountry = null;
  509.         $emitterIsReceiver = 0;
  510.         $emitterId = null;
  511.         $emitterName = null;
  512.         $emitterEmail = null;
  513.         $emitterPhone = null;
  514.         $emitterAddress = null;
  515.         $emitterComplement = null;
  516.         $emitterPostalCode = null;
  517.         $emitterTown = null;
  518.         $emitterCountry = null;
  520.         $statusId = null;
  521.         $statusValue = null;
  523.         $templateId = null;
  524.         $templateRef = null;
  525.         $templateTitle = null;
  526.         $templateDescription = null;
  527.         $templateSocietyGroupRef = null;
  528.         $templateSocietyGroupName = null;
  530.         $interventionAddressAddress = null;
  531.         $interventionAddressComplement = null;
  532.         $interventionAddressPostalCode = null;
  533.         $interventionAddressTown = null;
  534.         $interventionAddressCountry = null;
  536.         $billingAddressAddress = null;
  537.         $billingAddressComplement = null;
  538.         $billingAddressPostalCode = null;
  539.         $billingAddressTown = null;
  540.         $billingAddressCountry = null;
  542.         $tva = 20.00;
  543.         $secondTva = null;
  544.         $thirdTva = null;
  546.         $products = array();
  548.         $nbAttachments = null;
  550.         $devisSimulation = 0;
  552.         if ($devis->getAuthor() !== null)
  553.         {
  554.             $authorId = $devis->getAuthor()->getId();
  555.             $authorUsername = $devis->getAuthor()->getUsername();
  556.         }
  558.         if ($devis->getSociety() !== null)
  559.         {
  560.             $societyId = $devis->getSociety()->getId();
  561.             $societyRef = $devis->getSociety()->getRef();
  562.             $societyName = $devis->getSociety()->getName();
  564.             if ($devis->getSociety()->getGroup() !== null)
  565.             {
  566.                 $societyGroupId = $devis->getSociety()->getGroup()->getId();
  567.                 $societyGroupRef = $devis->getSociety()->getGroup()->getRef();
  568.                 $societyGroupName = $devis->getSociety()->getGroup()->getName();
  569.             }
  570.         }
  572.         if ($devis->getReceiver() !== null)
  573.         {
  574.             $receiverId = $devis->getReceiver()->getId();
  575.             $receiverName = $devis->getReceiver()->getName();
  576.             $receiverPhone = $devis->getReceiver()->getPhone();
  577.             $receiverEmail = $devis->getReceiver()->getEmail();
  579.             if ($devis->getReceiver()->getAddress() !== null)
  580.             {
  581.                 $receiverAddress = $devis->getReceiver()->getAddress()->getAddress();
  582.                 $receiverPostalCode = $devis->getReceiver()->getAddress()->getPostalCode();
  583.                 $receiverTown = $devis->getReceiver()->getAddress()->getTown();
  584.                 $receiverComplement = $devis->getReceiver()->getAddress()->getComplement();
  585.                 $receiverCountry = $devis->getReceiver()->getAddress()->getCountry();
  586.             }
  588.             if ($devis->getReceiver()->getIndividual() !== null)
  589.             {
  590.                 $receiverIsIndividual = 1;
  591.                 $receiverLastname = $devis->getReceiver()->getIndividual()->getLastname();
  592.                 $receiverFirstname = $devis->getReceiver()->getIndividual()->getFirstname();
  593.             }
  594.         }
  596.         if ($devis->getEmitter() !== null)
  597.         {
  598.             $emitterId = $devis->getEmitter()->getId();
  599.             $emitterName = $devis->getEmitter()->getName();
  600.             $emitterEmail = $devis->getEmitter()->getEmail();
  601.             $emitterPhone = $devis->getEmitter()->getPhone();
  603.             if ($devis->getEmitter()->equals($devis->getReceiver()))
  604.             {
  605.                 $emitterIsReceiver = 1;
  606.             }
  608.             if ($devis->getEmitter()->getAddress() !== null)
  609.             {
  610.                 $emitterAddress = $devis->getEmitter()->getAddress()->getAddress();
  611.                 $emitterPostalCode = $devis->getEmitter()->getAddress()->getPostalCode();
  612.                 $emitterTown = $devis->getEmitter()->getAddress()->getTown();
  613.                 $emitterComplement = $devis->getEmitter()->getAddress()->getComplement();
  614.                 $emitterCountry = $devis->getEmitter()->getAddress()->getCountry();
  615.             }
  616.         }
  618.         if ($devis->getTemplate() !== null)
  619.         {
  620.             $templateId = $devis->getTemplate()->getId();
  621.             $templateRef = $devis->getTemplate()->getRef();
  622.             $templateTitle = $devis->getTemplate()->getTitle();
  623.             $templateDescription = $devis->getTemplate()->getDescription();
  625.             if ($devis->getTemplate()->getSocietyGroup() !== null)
  626.             {
  627.                 $templateSocietyGroupRef = $devis->getTemplate()->getSocietyGroup()->getRef();
  628.                 $templateSocietyGroupName = $devis->getTemplate()->getSocietyGroup()->getName();
  629.             }
  630.         }
  632.         if ($devis->getSimulation())
  633.         {
  634.             $devisSimulation = 1;
  635.         }
  637.         if ($devis->getTva() !== null)
  638.         {
  639.             $tva = $devis->getTva()->getValue();
  640.         }
  642.         if ($devis->getSecondTva() !== null)
  643.         {
  644.             $secondTva = $devis->getSecondTva()->getValue();
  645.         }
  647.         if ($devis->getThirdTva() !== null)
  648.         {
  649.             $thirdTva = $devis->getThirdTva()->getValue();
  650.         }
  652.         if ($devis->getInterventionAddress() !== null)
  653.         {
  654.             $interventionAddressAddress = $devis->getInterventionAddress()->getAddress();
  655.             $interventionAddressPostalCode = $devis->getInterventionAddress()->getPostalCode();
  656.             $interventionAddressTown = $devis->getInterventionAddress()->getTown();
  657.             $interventionAddressComplement = $devis->getInterventionAddress()->getComplement();
  658.             $interventionAddressCountry = $devis->getInterventionAddress()->getCountry();
  659.         }
  661.         if ($devis->getBillingAddress() !== null)
  662.         {
  663.             $billingAddressAddress = $devis->getBillingAddress()->getAddress();
  664.             $billingAddressPostalCode = $devis->getBillingAddress()->getPostalCode();
  665.             $billingAddressTown = $devis->getBillingAddress()->getTown();
  666.             $billingAddressComplement = $devis->getBillingAddress()->getComplement();
  667.             $billingAddressCountry = $devis->getBillingAddress()->getCountry();
  668.         }
  670.         foreach ($devis->getProducts() as $devisProduct)
  671.         {
  672.             // Start with the original product data
  673.             $product = $devisProduct->getOriginalProduct();
  674.             if ($product !== null)
  675.             {
  676.                 $originalProductData = $this->productTools->productToArray($product);
  677.                 $originalProductId = $product->getId();
  678.             }
  679.             else
  680.             {
  681.                 $originalProductId = null;
  682.                 $originalProductData = array();
  683.             }
  685.             // Add the devis_product data
  686.             $devisProductData = $this->productTools->productDevisToArray($devisProduct);
  688.             $products[] = array(
  689.                 "original_product_id"            =>    $originalProductId,
  690.                 "original_product_data"            =>    $originalProductData,
  691.                 "devis_product_data"            =>    $devisProductData,
  692.             );
  693.         }
  695.         $nbAttachments = $devis->getAttachments()->count();
  697.         return array(
  698.             "devis_id"                        =>    $devis->getId(),
  699.             "devis_ref"                        =>    $devis->getRef(),
  701.             "devis_simulation"                =>    $devisSimulation,
  703.             "author_id"                        =>    $authorId,
  704.             "author_username"                =>    $authorUsername,
  706.             "society_id"                    =>    $societyId,
  707.             "society_ref"                    =>    $societyRef,
  708.             "society_name"                    =>    $societyName,
  710.             "society_group_id"                =>    $societyGroupId,
  711.             "society_group_ref"                =>    $societyGroupRef,
  712.             "society_group_name"            =>    $societyGroupName,
  714.             "receiver_is_individual"        =>    $receiverIsIndividual,
  715.             "receiver_id"                    =>    $receiverId,
  716.             "receiver_name"                    =>    $receiverName,
  717.             "receiver_lastname"                =>    $receiverLastname,
  718.             "receiver_firstname"            =>    $receiverFirstname,
  719.             "receiver_phone"                =>    $receiverPhone,
  720.             "receiver_email"                =>    $receiverEmail,
  721.             "receiver_address"                =>    $receiverAddress,
  722.             "receiver_complement"            =>    $receiverComplement,
  723.             "receiver_postal_code"            =>    $receiverPostalCode,
  724.             "receiver_town"                    =>    $receiverTown,
  725.             "receiver_country"                =>    $receiverCountry,
  727.             "emitter_is_receiver"            =>    $emitterIsReceiver,
  728.             "emitter_id"                    =>    $emitterId,
  729.             "emitter_name"                    =>    $emitterName,
  730.             "emitter_email"                    =>    $emitterEmail,
  731.             "emitter_phone"                    =>    $emitterPhone,
  732.             "emitter_address"                =>    $emitterAddress,
  733.             "emitter_complement"            =>    $emitterComplement,
  734.             "emitter_postal_code"            =>    $emitterPostalCode,
  735.             "emitter_town"                    =>    $emitterTown,
  736.             "emitter_country"                =>    $emitterCountry,
  738.             "status_id"                        =>    $statusId,
  739.             "status_value"                    =>    $statusValue,
  741.             "nb_attachments"                =>    $nbAttachments,
  743.             "tva"                            =>    $tva,
  744.             "second_tva"                    =>    $this->textTools->encodeForJson($secondTva),
  745.             "third_tva"                        =>    $this->textTools->encodeForJson($thirdTva),
  747.             "devis_title"                                    =>    $devis->getTitle(),
  748.             "devis_info"                                    =>    $devis->getInfo(),
  749.             "devis_ref_order"                                =>    $devis->getRefOrder(),
  750.             "devis_mention_info"                            =>    $this->textTools->encodeForJson($devis->getMentionInfo()),
  751.             "devis_annulled_info"                            =>    $devis->getAnnulledInfo(),
  753.             "devis_percentage_invoicing"                    =>    $this->textTools->encodeForJson($devis->getPercentageInvoicing()),
  755.             "template_id"                                    =>    $templateId,
  756.             "template_ref"                                    =>    $templateRef,
  757.             "template_title"                                =>    $templateTitle,
  758.             "template_description"                            =>    $templateDescription,
  759.             "template_society_group_ref"                    =>    $templateSocietyGroupRef,
  760.             "template_society_group_name"                    =>    $templateSocietyGroupName,
  762.             "billing_address_address"                        =>    $billingAddressAddress,
  763.             "billing_address_complement"                    =>    $billingAddressComplement,
  764.             "billing_address_postal_code"                    =>    $billingAddressPostalCode,
  765.             "billing_address_town"                            =>    $billingAddressTown,
  766.             "billing_address_country"                        =>    $billingAddressCountry,
  768.             "intervention_address_address"                    =>    $interventionAddressAddress,
  769.             "intervention_address_complement"                =>    $interventionAddressComplement,
  770.             "intervention_address_postal_code"                =>    $interventionAddressPostalCode,
  771.             "intervention_address_town"                        =>    $interventionAddressTown,
  772.             "intervention_address_country"                    =>    $interventionAddressCountry,
  774.             "total_internal_ht"                                =>    $devis->getTotalInternalHT(),
  775.             "total_public_ht"                                =>    $devis->getTotalPublicHT(),
  777.             "total_internal_ht_after_discount"                =>    $devis->getTotalInternalHTAfterDiscount(),
  778.             "total_public_ht_after_discount"                =>    $devis->getTotalPublicHTAfterDiscount(),
  780.             "total_internal_ttc_after_discount"                =>    $devis->getTotalInternalTTCAfterDiscount(),
  781.             "total_public_ttc_after_discount"                =>    $devis->getTotalPublicTTCAfterDiscount(),
  783.             "total_internal_discount"                        =>    $devis->getTotalInternalDiscount(),
  784.             "total_public_discount"                            =>    $devis->getTotalPublicDiscount(),
  786.             "total_internal_discount_ttc"                    =>    $devis->getTotalInternalDiscountTTC(),
  787.             "total_public_discount_ttc"                        =>    $devis->getTotalPublicDiscountTTC(),
  789.             "total_internal_ttc"                            =>    $devis->getTotalInternalTTC(),
  790.             "total_public_ttc"                                =>    $devis->getTotalPublicTTC(),
  792.             "total_internal_tva"                            =>    $devis->getTotalInternalTVA(),
  793.             "total_public_tva"                                =>    $devis->getTotalPublicTVA(),
  795.             "total_internal_tva_after_discount"                =>    $devis->getTotalInternalTVAAfterDiscount(),
  796.             "total_public_tva_after_discount"                =>    $devis->getTotalPublicTVAAfterDiscount(),
  798.             "total_internal_second_tva"                        =>    $devis->getTotalInternalSecondTVA(),
  799.             "total_public_second_tva"                        =>    $devis->getTotalPublicSecondTVA(),
  801.             "total_internal_second_tva_after_discount"        =>    $devis->getTotalInternalSecondTVAAfterDiscount(),
  802.             "total_public_second_tva_after_discount"        =>    $devis->getTotalPublicSecondTVAAfterDiscount(),
  804.             "total_internal_third_tva"                        =>    $devis->getTotalInternalThirdTVA(),
  805.             "total_public_third_tva"                        =>    $devis->getTotalPublicThirdTVA(),
  807.             "total_internal_third_tva_after_discount"        =>    $devis->getTotalInternalThirdTVAAfterDiscount(),
  808.             "total_public_third_tva_after_discount"            =>    $devis->getTotalPublicThirdTVAAfterDiscount(),
  810.             "solde_internal"                                =>    $devis->getSoldeInternal(),
  811.             "solde_public"                                    =>    $devis->getSoldePublic(),
  813.             "products"                                        =>    $products,
  814.         );
  815.     }
  817.     // Persist, No flush
  818.     public function convertSimulation($simulation)
  819.     {
  820.         // Plan.io Task #4328
  821.         $ecobonusIsActive = $this->security->isGranted('eco_bonus_is_active');
  822.         $canApplyEcobonus = $ecobonusIsActive;
  823.         if ($simulation->hasEcoBonus())
  824.         {
  825.             $canApplyEcobonus = true;
  826.         }
  828.         $devis = new Devis();
  829.         $societyGroup = $simulation->getSocietyGroup();
  831.         if ($societyGroup === null)
  832.         {
  833.             // This should not happen
  834.             $this->logTools->errorlog('SocietyGroup is null for devis '.$simulation->displayForLog());
  836.             return null;
  837.         }
  839.         // Ref will be generated in the Controller
  840.         // Author will be set in the Controller
  841.         // Simulations shouldn't have invoices, installments, or be attached to tasks
  843.         $devis->setSociety($simulation->getSociety());
  844.         $devis->setEmitter($simulation->getEmitter());
  846.         // Plan.io Task #4571
  847.         // Receiver should be set before Mission when creating a new Devis
  848.         // in order to fetch the Zone correctly (at least for the time being)
  849.         $devis->setReceiver($simulation->getReceiver());
  850.         $devis->setMission($simulation->getMission());
  852.         $devis->setTitle($simulation->getTitle());
  853.         $devis->setInfo($simulation->getInfo());
  854.         $devis->setRefOrder($simulation->getRefOrder());
  855.         $devis->setMentionInfo($simulation->getMentionInfo());
  856.         $devis->setAnnulledInfo($simulation->getAnnulledInfo());
  857.         $devis->setPercentageInvoicing($simulation->getPercentageInvoicing());
  859.         $devis->setTemplate($simulation->getTemplate());
  860.         $devis->setManager($simulation->getManager());
  862.         $defaultStatus = $this->em->getRepository(DevisStatus::class)
  863.             ->findOneBy(array(
  864.                 'societyGroup'            =>    $societyGroup,
  865.                 'inProgress'            =>    1
  866.             ));
  867.         if ($defaultStatus !== null)
  868.         {
  869.             $devis->setStatus($defaultStatus);
  870.         }
  871.         else
  872.         {
  873.             // This should not happen
  874.             $this->logTools->errorlog('InProgress DevisStatus is null');
  876.             return null;
  877.         }
  879.         $devis->setOldStatus($simulation->getStatus());
  880.         $devis->setTva($simulation->getTva());
  881.         $devis->setSecondTva($simulation->getSecondTva());
  882.         $devis->setThirdTva($simulation->getThirdTva());
  884.         // Products
  885.         foreach ($simulation->getProducts() as $product)
  886.         {
  887.             $devisProduct = new DevisProduct();
  888.             $devisProduct = $this->copyDevisProduct($product, $devisProduct);
  890.             if ($canApplyEcobonus && $product->hasEcoBonus())
  891.             {
  892.                 $devisProduct->setEcobonus($product->getEcobonus());
  893.             }
  895.             $devis->addProduct($devisProduct);
  896.         }
  898.         // Plan.io Task #4318
  899.         if ($canApplyEcobonus)
  900.         {
  901.             $devis->computeEcobonus();
  902.         }
  904.         $devis->computeTotals();
  906.         // Addresses
  907.         $devis->setInterventionAddress($this->addressTools->duplicateAddress($simulation->getInterventionAddress()));
  908.         $devis->setBillingAddress($this->addressTools->duplicateAddress($simulation->getBillingAddress()));
  910.         // Attachments
  911.         foreach ($simulation->getAttachments() as $attachment)
  912.         {
  913.             // Move attachment
  914.             $attachment->setDirectUpload(1);
  915.             $attachment->setDevis($devis);
  916.         }
  918.         if ($devis->getTemplate() !== null)
  919.         {
  920.             // Plan.io Task #4593
  921.             // There can be maximum 2 associated IkeaTemplates
  922.             $ikeaTemplates = $this->em->getRepository(IkeaTemplateProduct::class)
  923.                 ->getIkeaTemplatesForPlatformTemplate($devis->getTemplate());
  924.             if (count($ikeaTemplates) > 0)
  925.             {
  926.                 $devis->setIkeaTemplate($ikeaTemplates[0]);
  927.                 if (count($ikeaTemplates) > 1)
  928.                 {
  929.                     $devis->setIkeaSecondTemplate($ikeaTemplates[1]);
  930.                 }
  931.             }
  932.         }
  934.         $devis->setOriginalSimulation($simulation);
  935.         $simulation->setResultingDevis($devis);
  937.         return $devis;
  938.     }
  940.     // Persist, No flush
  941.     public function convertUnfinishedSimulation($simulation, $mission, $author)
  942.     {
  943.         // Plan.io Task #4328
  944.         $ecobonusIsActive = $this->security->isGranted('eco_bonus_is_active');
  945.         $canApplyEcobonus = $ecobonusIsActive;
  946.         if ($simulation->hasEcoBonus())
  947.         {
  948.             $canApplyEcobonus = true;
  949.         }
  951.         if ($simulation->getSocietyGroup() === null)
  952.         {
  953.             // This should not happen
  954.             $this->logTools->errorlog('SocietyGroup is null for Devis '.$simulation->displayForLog());
  955.             return null;
  956.         }
  958.         $devis = new Devis();
  960.         // We are creating a simulation, not an actual devis
  961.         $devis->setSimulation(1);
  963.         // Ref will be generated in the Controller
  964.         // Simulations shouldn't have invoices, installments, or be attached to tasks
  966.         $devis->setAuthor($author);
  967.         $devis->setSociety($mission->getSociety());
  968.         $devis->setEmitter($mission->getEmitter());
  970.         // Plan.io Task #4571
  971.         // Receiver should be set before Mission when creating a new Devis
  972.         // in order to fetch the Zone correctly (at least for the time being)
  973.         $devis->setReceiver($mission->getReceiver());
  974.         $devis->setMission($mission);
  976.         $devis->setTitle($simulation->getTitle());
  977.         $devis->setInfo($simulation->getInfo());
  978.         $devis->setRefOrder($simulation->getRefOrder());
  979.         $devis->setMentionInfo($simulation->getMentionInfo());
  980.         $devis->setAnnulledInfo($simulation->getAnnulledInfo());
  981.         $devis->setPercentageInvoicing($simulation->getPercentageInvoicing());
  983.         $devis->setTemplate($simulation->getTemplate());
  985.         if ($mission->getReceiver() !== null && $mission->getReceiver()->getIndividual() !== null)
  986.             $devis->setManager($mission->getReceiver()->getIndividual()->getManager());
  987.         if ($devis->getManager() === null)
  988.             $devis->setManager($author);
  990.         $defaultStatus = $this->em->getRepository(DevisStatus::class)
  991.             ->findOneBy(array(
  992.                 'simulation'            =>    1,
  993.                 'societyGroup'            =>    $simulation->getSocietyGroup(),
  994.             ));
  995.         if ($defaultStatus !== null)
  996.         {
  997.             $devis->setStatus($defaultStatus);
  998.         }
  999.         else
  1000.         {
  1001.             // This should not happen
  1002.             $this->logTools->errorlog('InProgress DevisStatus is null');
  1004.             return null;
  1005.         }
  1007.         $devis->setOldStatus($simulation->getStatus());
  1008.         $devis->setTva($simulation->getTva());
  1010.         // Products
  1011.         foreach ($simulation->getProducts() as $product)
  1012.         {
  1013.             $devisProduct = new DevisProduct();
  1014.             $devisProduct = $this->copyDevisProduct($product, $devisProduct);
  1016.             // Plan.io Task #4318
  1017.             if ($canApplyEcobonus && $product->hasEcoBonus())
  1018.             {
  1019.                 $devisProduct->setEcobonus($product->getEcobonus());
  1020.             }
  1022.             $devis->addProduct($devisProduct);
  1023.         }
  1025.         // Plan.io Task #4318
  1026.         if ($canApplyEcobonus)
  1027.         {
  1028.             $devis->computeEcobonus();
  1029.         }
  1031.         $devis->computeTotals();
  1033.         // Addresses
  1034.         if ($mission->getReceiver() !== null)
  1035.         {
  1036.             $devis->setInterventionAddress($this->addressTools->duplicateAddress($mission->getReceiver()->getAddress()));
  1037.             $devis->setBillingAddress($this->addressTools->duplicateAddress($mission->getReceiver()->getBillingAddress()));
  1038.         }
  1040.         // Attachments
  1041.         foreach ($simulation->getAttachments() as $attachment)
  1042.         {
  1043.             // Move attachment
  1044.             $attachment->setDirectUpload(1);
  1045.             $attachment->setDevis($devis);
  1046.         }
  1048.         if ($devis->getTemplate() !== null)
  1049.         {
  1050.             // Plan.io Task #4593
  1051.             // There can be maximum 2 associated IkeaTemplates
  1052.             $ikeaTemplates = $this->em->getRepository(IkeaTemplateProduct::class)
  1053.                 ->getIkeaTemplatesForPlatformTemplate($devis->getTemplate());
  1054.             if (count($ikeaTemplates) > 0)
  1055.             {
  1056.                 $devis->setIkeaTemplate($ikeaTemplates[0]);
  1057.                 if (count($ikeaTemplates) > 1)
  1058.                 {
  1059.                     $devis->setIkeaSecondTemplate($ikeaTemplates[1]);
  1060.                 }
  1061.             }
  1062.         }
  1064.         // $devis->setOriginalSimulation($simulation);
  1065.         // $simulation->setResultingDevis($devis);
  1067.         // Remove the old simulation
  1068.         $this->em->remove($simulation);
  1070.         return $devis;
  1071.     }
  1073.     public function copyDevisProduct($from, $to)
  1074.     {
  1075.         $to->setRef($from->getRef());
  1076.         $to->setTitle($from->getTitle());
  1077.         $to->setDescription($from->getDescription());
  1078.         $to->setPublicPrice($from->getPublicPrice());
  1079.         $to->setInternalPrice($from->getInternalPrice());
  1080.         $to->setQuantity($from->getQuantity());
  1081.         $to->setPercentage($from->getPercentage());
  1082.         $to->setInvoiced($from->getInvoiced());
  1083.         $to->setInvoicedPercentage($from->getInvoicedPercentage());
  1084.         $to->setTotalPublicHT($from->getTotalPublicHT());
  1085.         $to->setTotalInternalHT($from->getTotalInternalHT());
  1086.         $to->setTotalPublicTTC($from->getTotalPublicTTC());
  1087.         $to->setTotalInternalTTC($from->getTotalInternalTTC());
  1088.         $to->setDiscount($from->getDiscount());
  1089.         $to->setReadonly($from->getReadonly());
  1090.         $to->setSamePrice($from->getSamePrice());
  1091.         $to->setOptionNoPrice($from->getOptionNoPrice());
  1092.         $to->setUnit($from->getUnit());
  1093.         $to->setProduct($from->getProduct());
  1094.         $to->setQuestion($from->getQuestion());
  1095.         $to->setOriginalProduct($from->getOriginalProduct());
  1096.         $to->setPosition($from->getPosition());
  1097.         $to->setTva($from->getTva());
  1098.         $to->setOptionNoPrice($from->getOptionNoPrice());
  1100.         // Plan.io Task #4561
  1101.         $to->setLinearMetersLower($from->getLinearMetersLower(true));
  1102.         $to->setLinearMetersUpper($from->getLinearMetersUpper(true));
  1103.         $to->setLinearMetersColumn($from->getLinearMetersColumn(true));
  1104.         $to->setLinearMetersIsland($from->getLinearMetersIsland(true));
  1105.         $to->setLinearMetersIntegratedAppliance($from->getLinearMetersIntegratedAppliance(true));
  1107.         return $to;
  1108.     }
  1110.     // Plan.io Task #4624 : This is also called from NotebookTools :: updateNotebook_additionalWork
  1111.     public function handleProductsFromForm($devis, $formProducts, $editMode = false)
  1112.     {
  1113.         // Plan.io Task #4328
  1114.         $ecobonusIsActive = $this->security->isGranted('eco_bonus_is_active');
  1115.         $canApplyEcobonus = $ecobonusIsActive;
  1117.         // Plan.io Task #3800
  1118.         $titlePositions = array();
  1119.         $resultProducts = array();
  1121.         if ($editMode)
  1122.         {
  1123.             // Plan.io Task #4328
  1124.             if ($devis->hasEcoBonus())
  1125.             {
  1126.                 $canApplyEcobonus = true;
  1127.             }
  1129.             foreach ($devis->getProducts() as $product)
  1130.             {
  1131.                 // Plan.io Task #3626
  1132.                 // We need to remove the ref of this product from all InvoiceProducts it may reference
  1133.                 // This should not pose a problem since
  1134.                 // - if the invoice is stil valid, then we cannot edit corresponding devis, thus we should not be here
  1135.                 // - if the invoice has been annulled by a credit invoice, then the invoice is no longer editable
  1136.                 $invoiceProducts = $this->em->getRepository(InvoiceProduct::class)->findByDevisProduct($product);
  1137.                 foreach ($invoiceProducts as $iProduct)
  1138.                 {
  1139.                     $iProduct->setDevisProduct(null);
  1140.                 }
  1142.                 $devis->removeProduct($product);
  1143.                 $this->em->remove($product);
  1144.             }
  1146.             // Plan.io Task #4328
  1147.             // Need to reset ecobonus (Don't check if module is active here)
  1148.             $devis->setEcoBonus(null);
  1150.             // Plan.io Task #3800
  1151.             // Get the original positions of the titles before updating the Devis
  1152.             // Set them as keys of the array
  1153.             // so we can insert the products on the missing array keys in order of arrival
  1154.             foreach ($devis->getTitles() as $key => $title)
  1155.             {
  1156.                 $titlePositions[$title->getPosition()] = $title->getPosition();
  1157.             }
  1158.         }
  1160.         if (empty($formProducts))
  1161.             return null;
  1163.         $formProducts = json_decode($formProducts, true);
  1165.         if (empty($formProducts))
  1166.             return null;
  1168.         $productsRepository = $this->em->getRepository(Product::class);
  1169.         $unitRepository = $this->em->getRepository(Unit::class);
  1171.         // The discount, if any, should be last
  1172.         $discount = null;
  1173.         $ecoBonusProduct = null;
  1175.         // Take the position into account
  1176.         foreach($formProducts as $product)
  1177.         {
  1178.             if (array_key_exists('id', $product) &&
  1179.                 array_key_exists('ref', $product) &&
  1180.                 array_key_exists('quantity', $product) &&
  1181.                 array_key_exists('internal_price', $product) &&
  1182.                 array_key_exists('public_price', $product) &&
  1183.                 array_key_exists('title', $product) &&
  1184.                 array_key_exists('info', $product) &&
  1185.                 array_key_exists('unit', $product))
  1186.             {
  1187.                 $product_id = $product['id'];
  1188.                 $product_ref = $product['ref'];
  1189.                 $product_qt = $product['quantity'];
  1190.                 $product_internal_price = $product['internal_price'];
  1191.                 $product_public_price = $product['public_price'];
  1192.                 $product_title = $product['title'];
  1193.                 $product_info = $product['info'];
  1194.                 $product_unit = $product['unit'];
  1196.                 $product_ecobonus = 0;
  1197.                 if (array_key_exists('ecobonus', $product))
  1198.                 {
  1199.                     $product_ecobonus = floatval($product['ecobonus']);
  1200.                 }
  1202.                 // Handle free product
  1203.                 if (intval($product_id) == -1)
  1204.                 {
  1205.                     $product = $productsRepository->findOneBy(array(
  1206.                         'societyGroup'        =>    $devis->getSocietyGroup(),
  1207.                         'free'                =>    1,
  1208.                     ));
  1209.                 }
  1210.                 else
  1211.                 {
  1212.                     $product = $productsRepository->findOneById($product_id);
  1213.                 }
  1215.                 $product_unit = $unitRepository->findOneById($product_unit);
  1217.                 if ($product === null)
  1218.                     continue;
  1220.                 if ($product_qt <= 0)
  1221.                     continue;
  1223.                 if ($product_internal_price === null)
  1224.                     $product_internal_price = 0;
  1225.                 if ($product_public_price === null)
  1226.                     $product_public_price = 0;
  1228.                 // Discount ?
  1229.                 if ($product->isDiscount() && $discount !== null)
  1230.                 {
  1231.                     // This should not happen
  1232.                     // Only one discount is allowed for a devis
  1233.                     continue;
  1234.                 }
  1236.                 // Plan.io Task #4328
  1237.                 if ($canApplyEcobonus && $ecoBonusProduct !== null && !empty($product_ecobonus))
  1238.                 {
  1239.                     // This should not happen
  1240.                     // Only one EcoProduct is allowed for a devis
  1241.                     continue;
  1242.                 }
  1244.                 // Product
  1245.                 $dp = new DevisProduct();
  1247.                 // Plan.io Task #3800
  1248.                 // Save for position
  1249.                 $resultProducts[] = $dp;
  1251.                 $dp->setOriginalProduct($product);
  1253.                 if ($editMode)
  1254.                     $dp->setRef($product_ref);
  1255.                 else
  1256.                     $dp->setRef($product->getRef());
  1258.                 $dp->setTitle($product->getTitle());
  1259.                 $dp->setDescription($product->getDescription());
  1261.                 $dp->setOptionNoPrice($product->getOptionNoPrice());
  1263.                 $dp->setTva($product->getTva());
  1264.                 $dp->setRefCost($product->getRefCost());
  1266.                 // Check if the product can be edited, if not use product value
  1267.                 if ($product->getReadonly())
  1268.                 {
  1269.                     // Not editable
  1270.                     // $dp->setPublicPrice($product->getPublicPrice());
  1271.                     // $dp->setInternalPrice($product->getInternalPrice());
  1273.                     // Plan.io Task #3345
  1274.                     $dp->setPublicPrice($product_public_price);
  1275.                     $dp->setInternalPrice($product_internal_price);
  1277.                     $dp->setTitle($product->getTitle());
  1278.                     $dp->setDescription($product->getDescription());
  1279.                 }
  1280.                 else
  1281.                 {
  1282.                     // Editable
  1283.                     // Set title
  1284.                     $dp->setTitle($product_title);
  1285.                     $dp->setDescription($product_info);
  1287.                     // Set price, taking into account 'samePrice' constraint
  1288.                     if ($product->getSamePrice())
  1289.                     {
  1290.                         // Both prices must be the same,
  1291.                         // Get the value given by the user
  1292.                         $dp->setPublicPrice($product_internal_price);
  1293.                         $dp->setInternalPrice($product_internal_price);
  1294.                     }
  1295.                     else
  1296.                     {
  1297.                         // Prices can be different
  1298.                         $dp->setPublicPrice($product_public_price);
  1299.                         $dp->setInternalPrice($product_internal_price);
  1300.                     }
  1301.                 }
  1303.                 if ($product_unit === null)
  1304.                 {
  1305.                     $product_unit = $product->getUnit();
  1306.                 }
  1308.                 $dp->setUnit($product_unit);
  1310.                 $dp->setQuantity($product_qt);
  1311.                 $dp->setQuestion($product->getQuestion());
  1313.                 $dp->setReadonly($product->getReadonly());
  1314.                 $dp->setSamePrice($product->getSamePrice());
  1316.                 // Plan.io Task #4561
  1317.                 $dp->setLinearMetersLower($product->getLinearMetersLower(true));
  1318.                 $dp->setLinearMetersUpper($product->getLinearMetersUpper(true));
  1319.                 // Plan.io Task #4592
  1320.                 $dp->setLinearMetersColumn($product->getLinearMetersColumn(true));
  1321.                 $dp->setLinearMetersIsland($product->getLinearMetersIsland(true));
  1322.                 $dp->setLinearMetersIntegratedAppliance($product->getLinearMetersIntegratedAppliance(true));
  1324.                 // Plan.io Task #4328
  1325.                 if ($canApplyEcobonus && !empty($product_ecobonus))
  1326.                 {
  1327.                     $dp->setEcoBonus($product_ecobonus);
  1328.                     $ecoBonusProduct = $dp;
  1329.                 }
  1331.                 // Plan.io Task #3343
  1332.                 // Only consider internal prices if
  1333.                 //         - devis/mission is JCAF
  1334.                 //        - devis.emitter = devis.receiver
  1335.                 if ($devis->mustHaveEqualPrices())
  1336.                 {
  1337.                     // Do some logging
  1338.                     if ($dp->getPublicPrice() != $dp->getInternalPrice())
  1339.                     {
  1340.                         $this->logTools->errorlog("PublicPrice # InternalPrice where it should not be for devis ".$devis->displayForLog());
  1341.                     }
  1343.                     // Only keep the InternalPrice
  1344.                     $dp->setPublicPrice($dp->getInternalPrice());
  1345.                     $dp->setSamePrice(1);
  1346.                 }
  1348.                 if ($product->isDiscount())
  1349.                 {
  1350.                     // The discount, if any, should be last
  1351.                     $dp->setDiscount(1);
  1352.                     $discount = $dp;
  1353.                 }
  1354.                 else
  1355.                 {
  1356.                     $devis->addProduct($dp);
  1357.                 }
  1358.             }
  1360.             // Now add the discount, if any
  1361.             if ($discount !== null)
  1362.             {
  1363.                 $devis->addProduct($discount);
  1364.             }
  1365.         }
  1367.         // Plan.io Task #4328
  1368.         if ($canApplyEcobonus)
  1369.         {
  1370.             $devis->computeEcobonus();
  1371.         }
  1373.         // Plan.io Task #3800
  1374.         // Set positions
  1375.         // Insert the products on the missing array keys in order of arrival
  1376.         // The existing keys represent the existing titles
  1377.         $nb = count($titlePositions) + count($resultProducts);
  1379.         $key = 0;
  1380.         for ($pos = 1 ; $pos <= $nb ; $pos++)
  1381.         {
  1382.             if (array_key_exists($pos, $titlePositions))
  1383.             {
  1385.             }
  1386.             else
  1387.             {
  1388.                 $titlePositions[$pos] = $resultProducts[$key];
  1389.                 $key ++;
  1390.             }
  1391.         }
  1392.         foreach ($titlePositions as $pos => $item)
  1393.         {
  1394.             if ($item instanceof DevisProduct)
  1395.             {
  1396.                 $item->setPosition($pos);
  1397.             }
  1398.         }
  1400.         return true;
  1401.     }
  1403.     // No Flush, Persist only
  1404.     public function updateRefOrders($data)
  1405.     {
  1406.         if (empty($data))
  1407.             return false;
  1409.         $devisRep = $this->em->getRepository(Devis::class);
  1411.         // Handle data
  1412.         foreach ($data as $devisItem)
  1413.         {
  1414.             $id = $devisItem[0];
  1415.             $value = $devisItem[1];
  1417.             // Get the devis
  1418.             $devis = $devisRep->findOneById($id);
  1419.             if ($devis === null)
  1420.                 continue;
  1422.             $oldValue = $devis->getRefOrder();
  1423.             if ($oldValue != $value)
  1424.             {
  1425.                 // Update refOrder
  1426.                 $devis->setRefOrder($value);
  1427.                 $this->em->persist($devis);
  1429.                 $devis->setLoggingData(["info" => $this->translator->trans('updated_via_task')]);
  1430.             }
  1431.         }
  1433.         return true;
  1434.     }
  1436.     // No Flush, Persist only
  1437.     public function updateRefOrder($devis, $refOrder)
  1438.     {
  1439.         if ($devis === null)
  1440.             return false;
  1442.         $backTrace = debug_backtrace()[0];
  1443.         $method = $backTrace['function'];
  1444.         $class = $backTrace['class'];
  1445.         $trace = $class . "::" . $method;
  1446.         $trace = str_replace("\\", "::", $trace);
  1448.         $oldValue = $devis->getRefOrder();
  1449.         if ($oldValue != $refOrder)
  1450.         {
  1451.             // Update refOrder
  1452.             $devis->setRefOrder($refOrder);
  1453.             $this->em->persist($devis);
  1455.             // Plan.io Task #3922
  1456.             $devis->setLoggingData(["info" => $this->translator->trans('devis_edit_ref_order_via_invoice')]);
  1457.         }
  1458.         return true;
  1459.     }
  1461.     // Plan.io Task #3621
  1462.     // No Flush, Persist only
  1463.     public function updateIkeaOrderNumber($devis, $refOrder)
  1464.     {
  1465.         if ($devis === null)
  1466.             return false;
  1468.         $oldValue = $devis->getIkeaOrderNumber();
  1469.         if ($oldValue != $refOrder)
  1470.         {
  1471.             // Update refOrder
  1472.             $devis->setIkeaOrderNumber($refOrder);
  1473.             $this->em->persist($devis);
  1475.             // Plan.io Task #3922
  1476.             $devis->setLoggingData(["info" => $this->translator->trans('devis_edit_ref_order_via_invoice')]);
  1477.         }
  1478.         return true;
  1479.     }
  1481.     // No Flush
  1482.     public function updateStatusConsideringInvoicing($args)
  1483.     {
  1484.         // Get all the arguments
  1485.         // Devis is mandatory
  1486.         if (array_key_exists("devis", $args))                $devis = $args["devis"];
  1487.         else                                                return null;
  1489.         if (array_key_exists("info", $args))                $info = $args["info"];
  1490.         else                                                  $info = null;
  1492.         if ($devis->isAnnulled())
  1493.             return false;
  1495.         // Plan.io Task #4326
  1496.         // Just in case
  1497.         if (array_key_exists("invoice", $args))
  1498.         {
  1499.             $invoice = $args["invoice"];
  1500.             if ($invoice->isDraft())
  1501.             {
  1502.                 // Nothing to do here => Bye bye
  1503.                 return false;
  1504.             }
  1505.         }
  1507.         // $this->logTools->ploopLog("[#4326][".$devis->getId()."][".$devis->getRef()."] DevisTools :: updateStatusConsideringInvoicing");
  1509.         $invoicing = $this->checkInvoicing($devis);
  1511.         // If Empty or Not Invoiced, do nothing
  1512.         if ($invoicing["empty"] || $invoicing["not_invoiced"])
  1513.             return false;
  1514.         $status = $invoicing["status"];
  1516.         if ($status !== null)
  1517.         {
  1518.             // $oldStatus = $devis->getStatus()->getValue();
  1519.             // $newStatus = $status->getValue();
  1521.             $devis->setStatus($status);
  1523.             return true;
  1524.         }
  1525.         return false;
  1526.     }
  1528.     // Plan.io Task #3898.Zones.ZoneProducts.iTasks
  1529.     // Rekto : InvoiceTools :: updateDevisTaskStatus
  1530.     // Plan.io Task #4326 : Added $invoice param
  1531.     public function updateDevisTaskStatus(Devis $devis, Invoice $invoice)
  1532.     {
  1533.         // $this->logTools->ploopLog("[#4326][".$devis->getId()."][".$devis->getRef()."] DevisTools :: updateDevisTaskStatus");
  1535.         // Code should be applied only for Rekto Group
  1536.         if ($devis->getSocietyGroup() === null || $devis->getSocietyGroup()->isRekto() === false)
  1537.         {
  1538.             return false;
  1539.         }
  1541.         if ($devis->isAnnulled())
  1542.             return false;
  1544.         // Only change task status for devis which are totally invoiced
  1545.         if (!$devis->isInvoiced())
  1546.             return false;
  1548.         // Plan.io Task #4326
  1549.         // Just in case
  1550.         if ($invoice->isDraft())
  1551.         {
  1552.             // Nothing to do here => Bye bye
  1553.             return false;
  1554.         }
  1556.         $taskStatusRepository = $this->em->getRepository(TaskStatus::class);
  1558.         $invoicedFinished = $taskStatusRepository->findOneBy(array(
  1559.             'societyGroup'        =>    $devis->getSocietyGroup(),
  1560.             'iTaskAuto'            =>    1,
  1561.             'code'                =>    TaskStatus::TASK_STATUS_INVOICED_FINISHED,
  1562.         ));
  1564.         if ($invoicedFinished === null)
  1565.         {
  1566.             return false;
  1567.         }
  1569.         $newStatus = $invoicedFinished->getValue();
  1571.         foreach ($devis->getTasks() as $task)
  1572.         {
  1573.             $tochange = true;
  1574.             // check if task has another not invoiced devis
  1575.             foreach($task->getDevisGroup() as $taskDevis)
  1576.             {
  1577.                 if (!$devis->equals($taskDevis) && !$taskDevis->getStatus()->isInvoiced())
  1578.                 {
  1579.                     $tochange = false;
  1580.                 }
  1581.             }
  1583.             if ($tochange === false)
  1584.             {
  1585.                 continue;
  1586.             }
  1588.             $oldStatus = $task->getStatus()->getValue();
  1590.             $task->setStatus($invoicedFinished);
  1592.             // Plan.io Task #3865
  1593.             // This one does not flush
  1594.             $this->advancedNotificationTools->updateAdvancedNotificationForTask($task);
  1595.         }
  1596.         return true;
  1597.     }
  1599.     // Plan.io Task #3898.Zones.ZoneProducts.iTasks
  1600.     // Rekto : DevisTools :: handleStatusChangeForTask
  1601.     public function handleDevisStatusChangeForTask(Task $task)
  1602.     {
  1603.         $output = [
  1604.             'status'         => false,
  1605.             'devis_updated'    => [],
  1606.         ];
  1607.         $devisUpdated = [];
  1609.         if (!$this->security->isGranted('devis_is_active'))
  1610.         {
  1611.             // Module not active, exit
  1612.             return $output;
  1613.         }
  1615.         $societyGroup = $task->getSocietyGroup();
  1616.         if ($societyGroup === null)
  1617.         {
  1618.             // Should never happen
  1619.             $this->logTools->errorLog('SocietyGroup is null for task : ' . $task->displayForLog());
  1620.             return $output;
  1621.         }
  1623.         $devisStatusRepository = $this->em->getRepository(DevisStatus::class);
  1624.         $inProgressStatus = $devisStatusRepository->findOneBy(array(
  1625.             'societyGroup'    =>    $societyGroup,
  1626.             'inProgress'    =>    1,
  1627.         ));
  1628.         $plannedStatus = $devisStatusRepository->findOneBy(array(
  1629.             'societyGroup'    =>    $societyGroup,
  1630.             'planned'        =>    1,
  1631.         ));
  1633.         if ($inProgressStatus === null || $plannedStatus === null)
  1634.         {
  1635.             // Should never happen
  1636.             $this->logTools->errorLog('Status planned or inprogress not found in societyGroup : ' . $societyGroup->displayForLog());
  1637.             return $output;
  1638.         }
  1640.         $devisGroup = $task->getDevisGroup();
  1642.         if ($devisGroup->isDirty() == false)
  1643.         {
  1644.             // $this->logTools->ploopLog('Is not dirty');
  1645.             $output['status'] = true;
  1646.             return $output;
  1647.         }
  1649.         // Get trace for log
  1650.         $backTrace = debug_backtrace()[0];
  1651.         $method = $backTrace['function'];
  1652.         $class = $backTrace['class'];
  1653.         $trace = $class . "::" . $method;
  1654.         $trace = str_replace("\\", "::", $trace);
  1656.         // Handle add case : DevisStatus :: planned
  1657.         foreach ($devisGroup as $key => $devis)
  1658.         {
  1659.             $isOldDevis = false;
  1660.             foreach ($devisGroup->getSnapshot() as $snapshotDevis)
  1661.             {
  1662.                 if ($devis->equals($snapshotDevis))
  1663.                 {
  1664.                     $isOldDevis = true;
  1665.                     break;
  1666.                 }
  1667.             }
  1669.             if ($isOldDevis)
  1670.             {
  1671.                 // Nothing to do here
  1672.                 continue;
  1673.             }
  1675.             if ($devis->isInProgress() === false)
  1676.             {
  1677.                 // Nothing to do here
  1678.                 continue;
  1679.             }
  1681.             // Plan.io Task #3922
  1682.             $devis->setLoggingData(["info" => "devis_auto_edit_status_added_to_task"]);
  1684.             $devis->setStatus($plannedStatus);
  1686.             $devisUpdated[] = $devis;
  1687.         }
  1689.         // Handle devis removed
  1690.         foreach ($task->getDevisGroup()->getSnapshot() as $snapshotDevis)
  1691.         {
  1692.             $isOldDevis = false;
  1693.             foreach ($devisGroup as $devis)
  1694.             {
  1695.                 if ($snapshotDevis->equals($devis))
  1696.                 {
  1697.                     $isOldDevis = true;
  1698.                     break;
  1699.                 }
  1700.             }
  1702.             if ($isOldDevis)
  1703.             {
  1704.                 // Nothing to do here
  1705.                 continue;
  1706.             }
  1708.             $devis = $snapshotDevis;
  1710.             // Only do this if devis is 'planned' and not in another task (#2639)
  1711.             // Here getTasks should be 0 if devis had a single task
  1712.             if ($devis->isPlanned() === false || sizeof($devis->getTasks()) > 0)
  1713.             {
  1714.                 // Nothing to do here
  1715.                 continue;
  1716.             }
  1718.             // Devis has been removed,
  1719.             // Revert it to old status, if available
  1720.             // Revert to default status if not
  1721.             $devisStatus = $inProgressStatus;
  1722.             if ($devis->getOldStatus() !== null && $devis->getOldStatus()->isPlanned() === false)
  1723.             {
  1724.                 $devisStatus = $devis->getOldStatus();
  1725.             }
  1727.             // Plan.io Task #3922
  1728.             $devis->setLoggingData(["info" => "devis_auto_edit_status_removed_from_task"]);
  1730.             $devis->setStatus($devisStatus);
  1732.             $devisUpdated[] = $devis;
  1733.         }
  1735.         $output['status'] = true;
  1736.         $output['devis_updated'] = $devisUpdated;
  1737.         return $output;
  1738.     }
  1740.     // This checks to see if the devis
  1741.     // is not invoiced, partially invoiced or totally invoiced
  1742.     // based on the state of its products
  1743.     public function checkInvoicing($devis)
  1744.     {
  1745.         if ($devis->getProducts()->count() < 1)
  1746.             return array(
  1747.                 "empty"                    =>    true,
  1748.                 "not_invoiced"            =>    false,
  1749.                 "partially_invoiced"    =>    false,
  1750.                 "invoiced"                =>    false,
  1751.                 "status"                =>    null,
  1752.             );
  1754.         $statusRepository = $this->em->getRepository(DevisStatus::class);
  1755.         $statusPartiallyInvoiced = $statusRepository
  1756.             ->findOneBy(array(
  1757.                 'partiallyInvoiced'            =>    1,
  1758.                 'societyGroup'                =>    $devis->getSocietyGroup(),
  1759.             ));
  1760.         $statusInvoiced = $statusRepository
  1761.             ->findOneBy(array(
  1762.                 'invoiced'                    =>    1,
  1763.                 'societyGroup'                =>    $devis->getSocietyGroup(),
  1764.             ));
  1766.         $totalQuantity = 0;
  1767.         $totalInvoiced = 0;
  1769.         foreach($devis->getProducts() as $product)
  1770.         {
  1771.             if ($product->isNotDiscount())
  1772.             {
  1773.                 $totalQuantity += $product->getQuantity();
  1774.                 $totalInvoiced += $product->getInvoiced();
  1775.             }
  1776.         }
  1778.         // Not invoiced
  1779.         if ($totalInvoiced == 0)
  1780.         {
  1781.             return array(
  1782.                 "empty"                    =>    false,
  1783.                 "not_invoiced"            =>    true,
  1784.                 "partially_invoiced"    =>    false,
  1785.                 "invoiced"                =>    false,
  1786.                 "status"                =>    null,
  1787.             );
  1788.         }
  1790.         // Partially invoiced
  1791.         if ($totalInvoiced < $totalQuantity)
  1792.         {
  1793.             return array(
  1794.                 "empty"                    =>    false,
  1795.                 "not_invoiced"            =>    false,
  1796.                 "partially_invoiced"    =>    true,
  1797.                 "invoiced"                =>    false,
  1798.                 "invoiced"                =>    false,
  1799.                 "status"                =>    $statusPartiallyInvoiced,
  1800.             );
  1801.         }
  1803.         // If we are here it means that the devis has at least one product
  1804.         // and the total Invoiced is equal to the total Quantity
  1805.         // Plan.io Task #4326 : Or higher :)
  1806.         return array(
  1807.             "empty"                    =>    false,
  1808.             "not_invoiced"            =>    false,
  1809.             "partially_invoiced"    =>    false,
  1810.             "invoiced"                =>    true,
  1811.             "status"                =>    $statusInvoiced,
  1812.         );
  1813.     }
  1815.     // Plan.io Task #4353
  1816.     // Lists invoices considered annulled (excluding itself) linked to the same devis in the invoice view.
  1817.     public function getListingInvoiceWithCredit($devis, $invoice)
  1818.     {
  1819.         $invoicesAnnulled = [];
  1821.         $devisInvoices = $devis->getInvoicesOnly();
  1822.         foreach ($devisInvoices as $devisInvoice)
  1823.         {
  1824.             if ($invoice === $devisInvoice)
  1825.             {
  1826.                 break;
  1827.             }
  1829.             // We are looking to see if a credit note is linked to this invoice
  1830.             $devisCredit = $this->em->getRepository(Invoice::class)->findOneBy(array(
  1831.                 'creditInvoice'        =>    $devisInvoice,
  1832.                 'draft'                =>    0,
  1833.             ));
  1835.             // If a credit note is found, the invoice is considered cancelled
  1836.             if ($devisCredit !== null)
  1837.             {
  1838.                 $invoicesAnnulled[] = $devisInvoice;
  1839.             }
  1840.         }
  1842.         return $invoicesAnnulled;
  1843.     }
  1845.     public function handlePositionForTitleCreation($title, $elements)
  1846.     {
  1847.         foreach($elements as $el)
  1848.         {
  1849.             if($el->getPosition() !== null)
  1850.             {
  1851.                 $el->setPosition($el->getPosition() + 1);
  1852.             }
  1853.         }
  1855.         $title->setPosition(1);
  1856.     }
  1858.     public function updatePositionTitleDelete($oldPos, $products, $titles)
  1859.     {
  1860.         // Sort by Position
  1861.         $mergedProducts = array_merge($products->toArray(), $titles->toArray());
  1863.         if (count($mergedProducts))
  1864.         {
  1865.             $iterator = $mergedProducts;
  1866.             uasort($mergedProducts,function ($first, $second)
  1867.             {
  1868.                 return (int) $first->getPosition() > (int) $second->getPosition() ? 1 : -1;
  1869.             });
  1870.         }
  1872.         // Apply -1 when old position is inferior at current position
  1873.         foreach ($mergedProducts as $mp)
  1874.         {
  1875.             if($oldPos < $mp->getPosition())
  1876.             {
  1877.                 $newPosition = $mp->getPosition() - 1;
  1878.                 $mp->setPosition($newPosition);
  1879.                 $this->em->persist($mp);
  1880.             }
  1881.         }
  1882.     }
  1883. }