src/Entity/Project.php line 17

1. <?php
3. namespace App\Entity;
5. use App\Repository\ProjectRepository;
6. use App\Service\CurrencyService;
7. use Doctrine\Common\Collections\ArrayCollection;
8. use Doctrine\Common\Collections\Collection;
9. use Doctrine\Common\Collections\Criteria;
10. use Doctrine\DBAL\Types\Types;
11. use Doctrine\ORM\Mapping as ORM;
12. use Exception;
13. use GuzzleHttp\Exception\GuzzleException;
14. use Symfony\Component\Serializer\Annotation\Groups;
16. #[ORM\Entity(repositoryClass: ProjectRepository::class)]
17. class Project
18. {
21.     #[ORM\Id]
22.     #[ORM\GeneratedValue]
23.     #[ORM\Column(type: 'integer')]
24.     #[Groups(['LogService'])]
25.     private $id;
27.     #[Groups(['LogService'])]
28.     #[ORM\Column(type: 'string', length: 255)]
29.     private $name;
31.     #[ORM\Column(type: 'text', nullable: true)]
32.     #[Groups(['LogService'])]
33.     private $description;
35.     #[ORM\ManyToOne(targetEntity: Client::class, inversedBy: 'projects')]
36.     #[ORM\JoinColumn(nullable: true)]
37.     private $client;
39.     #[ORM\OneToMany(targetEntity: Task::class, mappedBy: 'project', fetch: 'EXTRA_LAZY')]
40.     #[ORM\OrderBy(['week' => 'ASC'])]
41.     private $tasks;
43.     #[ORM\OneToMany(targetEntity: VendorQuotationPlanning::class, mappedBy: 'project', fetch: 'EXTRA_LAZY')]
44.     private $vendorQuotationPlannings;
46.     #[ORM\OneToMany(targetEntity: SalesOrder::class, mappedBy: 'project', fetch: 'EXTRA_LAZY')]
47.     private $salesOrders;
49.     #[ORM\Column(type: 'datetime', nullable: true)]
50.     #[Groups(['LogService'])]
51.     private $createdAt;
53.     #[ORM\Column(type: 'datetime', nullable: true)]
54.     #[Groups(['LogService'])]
55.     private $updatedAt;
57.     #[ORM\Column(type: 'date', nullable: true)]
58.     private $winDate;
60.     #[ORM\Column(type: 'date', nullable: true)]
61.     private $startDate;
63.     #[ORM\Column(type: 'date', nullable: true)]
64.     private $endDate;
66.     #[ORM\ManyToOne(targetEntity: User::class, inversedBy: 'projects')]
67.     private $createdBy;
69.     #[Groups(['LogService'])]
70.     #[ORM\ManyToOne(targetEntity: User::class, inversedBy: 'projectsUserIsPIC')]
71.     private $personInCharge;
73.     #[Groups(['LogService'])]
74.     #[ORM\Column(type: 'string', length: 20, nullable: true)]
75.     private $status;
77.     #[Groups(['LogService'])]
78.     #[ORM\Column(type: 'float', nullable: true)]
79.     private $plannedRevenue = 0;
81.     #[ORM\Column(type: 'float', nullable: true)]
82.     private $plannedRevenueUsd;
84.     #[ORM\ManyToOne(targetEntity: Currency::class, inversedBy: 'projects')]
85.     private $currency;
87.     #[ORM\Column(type: 'string', length: 255, nullable: true)]
88.     private $planFilename;
90.     #[ORM\Column(type: 'string', length: 255, nullable: true)]
91.     private $planFilepath;
92.     #[ORM\Column(type: 'string', length: 192, nullable: true)]
93.     private $planFiletype;
95.     #[ORM\OneToMany(targetEntity: ProjectMember::class, mappedBy: 'project', orphanRemoval: true, fetch: 'EXTRA_LAZY')]
96.     private $projectMembers;
98.     #[ORM\Column(type: 'datetime_immutable', nullable: true)]
99.     private $deletedAt;
101.     #[ORM\ManyToMany(targetEntity: Department::class)]
102.     private $department;
104.     #[ORM\Column(type: 'boolean', nullable: true)]
105.     private $retainer;
107.     #[Groups(['LogService'])]
108.     #[ORM\Column(name: '`lead`', type: 'smallint', nullable: true)]
109.     private $lead;
111.     #[ORM\Column(type: 'string', length: 20, nullable: true)]
112.     private $type;
114.     #[ORM\Column(type: 'date', nullable: true)]
115.     private $leadDate;
117.     #[ORM\Column(type: 'date', nullable: true)]
118.     private $proposalDate;
120.     #[ORM\Column(type: 'text', nullable: true)]
121.     private $planURL;
123.     #[ORM\Column(type: 'float', nullable: true)]
124.     private $estimatedProfit = 0;
126.     #[ORM\Column(type: 'boolean', nullable: true, options: ['default' => false])]
127.     private $noEstimatedVendorCost;
129.     #[ORM\Column(type: 'float', nullable: true)]
130.     private $estimatedVendorCost = 0;
132.     #[ORM\Column(type: 'float', nullable: true)]
133.     private $estimatedVendorCostUsd;
135.     #[ORM\OneToMany(targetEntity: ProjectSalesOrder::class, mappedBy: 'project', fetch: 'EXTRA_LAZY')]
136.     private $projectSalesOrders;
138.     #[ORM\OneToMany(targetEntity: ProjectAllocatedHours::class, mappedBy: 'project', fetch: 'EXTRA_LAZY')]
139.     private $projectAllocatedHours;
141.     #[ORM\Column(type: 'string', length: 50, nullable: true)]
142.     private $leadSource;
144.     #[ORM\Column(type: 'datetime_immutable', nullable: true)]
145.     private $lastReminder;
147.     #[ORM\Column(type: 'string', length: 9, nullable: true)]
148.     private $generatedId;
150.     #[Groups(['LogService'])]
151.     #[ORM\Column(type: 'datetime_immutable', nullable: true)]
152.     private $leadFailDate;
154.     #[Groups(['LogService'])]
155.     #[ORM\Column(type: 'text', nullable: true)]
156.     private $leadFailNote;
158.     #[Groups(['LogService'])]
159.     #[ORM\Column(type: 'datetime_immutable', nullable: true)]
160.     private $leadFailRemindDate;
162.     #[Groups(['LogService'])]
163.     #[ORM\ManyToOne(targetEntity: ClientContact::class, inversedBy: 'projects')]
164.     private $clientPersonInCharge;
166.     #[ORM\OneToMany(targetEntity: SalesOrderPurchaseOrder::class, mappedBy: 'project', fetch: 'EXTRA_LAZY')]
167.     private $salesOrderPurchaseOrders;
169.     #[ORM\Column(type: 'smallint', nullable: true)]
170.     private $probability;
172.     #[ORM\Column(type: 'boolean', nullable: true, options: ['default' => false])]
173.     private $noPresentation;
175.     #[ORM\Column(type: 'date', nullable: true)]
176.     private $presentationDate;
178.     #[ORM\ManyToMany(targetEntity: ProjectClassification::class, inversedBy: 'projectsOfType')]
179.     private $projectTypes;
181.     #[ORM\ManyToMany(targetEntity: IndustryClassification::class, inversedBy: 'projectsOfIndustry')]
182.     private $projectIndustries;
184.     #[ORM\Column(type: 'date', nullable: true)]
185.     private $proposalFollowUpDate;
187.     #[ORM\ManyToOne(targetEntity: ProjectLeadStatus::class)]
188.     private $leadStatus;
190.     #[ORM\OneToMany(targetEntity: RevenuePlanning::class, mappedBy: 'project', fetch: 'EXTRA_LAZY')]
191.     private $revenuePlannings;
193.     #[ORM\ManyToOne(inversedBy: 'projects')]
194.     private ?ProjectLostReason $leadFail = null;
196.     #[ORM\OneToOne(targetEntity: ProjectDeliverable::class, mappedBy: 'project', cascade: ['persist', 'remove'])]
197.     private $projectDeliverable;
199.     #[ORM\OneToMany(mappedBy: 'project', targetEntity: ClientFeedback::class, cascade: ['persist', 'remove'])]
200.     private Collection $clientFeedback;
202.     #[ORM\ManyToOne(inversedBy: 'projects')]
203.     private ?ClientFeedbackTemplate $clientFeedbackTemplate = null;
205.     #[ORM\Column(nullable: true)]
206.     private ?float $score = null;
208.     #[ORM\OneToMany(mappedBy: 'project', targetEntity: ExpenseRequest::class)]
209.     private Collection $expenseRequests;
211.     #[ORM\OneToMany(mappedBy: 'project', targetEntity: Checklist::class)]
212.     #[ORM\OneToOne(mappedBy: 'project', cascade: ['persist', 'remove'])]
213.     private ?ProjectLostFilter $projectLostFilter = null;
215.     #[ORM\OneToMany(mappedBy: 'project', targetEntity: Checklist::class, cascade: ['persist'])]
216.     private Collection $checklists;
218.     #[ORM\Column(type: Types::TEXT, nullable: true)]
219.     private ?string $brief = null;
221.     #[ORM\Column(length: 255, nullable: true)]
222.     private ?string $mattermost = null;
224.     #[ORM\OneToMany(mappedBy: 'project', targetEntity: ProjectDynamicField::class, orphanRemoval: true)]
225.     private Collection $projectDynamicFields;
227.     #[ORM\OneToOne(mappedBy: 'project', cascade: ['persist', 'remove'])]
228.     private ?ProjectHosting $projectHosting = null;
230.     public function __clone()
231.     {
232.         $this->id = null;
233.     }
234.     public function __construct()
235.     {
236.         $this->tasks = new ArrayCollection();
237.         $this->vendorQuotationPlannings = new ArrayCollection();
238.         $this->salesOrders = new ArrayCollection();
239.         $this->projectMembers = new ArrayCollection();
240.         $this->department = new ArrayCollection();
241.         $this->projectSalesOrders = new ArrayCollection();
242.         $this->projectAllocatedHours = new ArrayCollection();
243.         $this->salesOrderPurchaseOrders = new ArrayCollection();
244.         $this->projectTypes = new ArrayCollection();
245.         $this->projectIndustries = new ArrayCollection();
246.         $this->revenuePlannings = new ArrayCollection();
247.         $this->clientFeedback = new ArrayCollection();
248.         $this->expenseRequests = new ArrayCollection();
249.         $this->checklists = new ArrayCollection();
250.         $this->projectDynamicFields = new ArrayCollection();
251.     }
253.     public function getCreatedAt(): ?\DateTimeInterface
254.     {
255.         return $this->createdAt;
256.     }
258.     public function setCreatedAt(?\DateTimeInterface $createdAt): self
259.     {
260.         $this->createdAt = $createdAt;
262.         return $this;
263.     }
265.     public function getUpdatedAt(): ?\DateTimeInterface
266.     {
267.         return $this->updatedAt;
268.     }
270.     public function setUpdatedAt(?\DateTimeInterface $updatedAt): self
271.     {
272.         $this->updatedAt = $updatedAt;
274.         return $this;
275.     }
277.     public function getId(): ?int
278.     {
279.         return $this->id;
280.     }
282.     public function getName(): ?string
283.     {
284.         return $this->name;
285.     }
287.     public function setName(string $name): self
288.     {
289.         $this->name = $name;
291.         return $this;
292.     }
294.     public function fullName()
295.     {
296.         return $this->generatedId ? $this->generatedId . '-' . $this->name : $this->name;
297.     }
299.     public function getDescription(): ?string
300.     {
301.         return $this->description;
302.     }
304.     public function setDescription(?string $description): self
305.     {
306.         $this->description = $description;
308.         return $this;
309.     }
312.     public function getClient(): ?Client
313.     {
314.         return $this->client;
315.     }
317.     public function setClient(?Client $client): self
318.     {
319.         $this->client = $client;
321.         return $this;
322.     }
324.     /**
325.      * @return Collection<int, Task>
326.      */
327.     public function getTasks(): Collection
328.     {
329.         return $this->tasks;
330.     }
332.     public function addTask(Task $task): self
333.     {
334.         if (!$this->tasks->contains($task)) {
335.             $this->tasks[] = $task;
336.             $task->setProject($this);
337.         }
339.         return $this;
340.     }
342.     public function removeTask(Task $task): self
343.     {
344.         if ($this->tasks->removeElement($task)) {
345.             // set the owning side to null (unless already changed)
346.             if ($task->getProject() === $this) {
347.                 $task->setProject(null);
348.             }
349.         }
351.         return $this;
352.     }
354.     /**
355.      * @return Collection<int, VendorQuotationPlanning>
356.      */
357.     public function getVendorQuotationPlannings(): Collection
358.     {
359.         return $this->vendorQuotationPlannings;
360.     }
362.     public function addVendorQuotationPlanning(VendorQuotationPlanning $vendorQuotationPlanning): self
363.     {
364.         if (!$this->vendorQuotationPlannings->contains($vendorQuotationPlanning)) {
365.             $this->vendorQuotationPlannings[] = $vendorQuotationPlanning;
366.             $vendorQuotationPlanning->setProject($this);
367.         }
369.         return $this;
370.     }
372.     public function removeVendorQuotationPlanning(VendorQuotationPlanning $vendorQuotationPlanning): self
373.     {
374.         if ($this->vendorQuotationPlannings->removeElement($vendorQuotationPlanning)) {
375.             // set the owning side to null (unless already changed)
376.             if ($vendorQuotationPlanning->getProject() === $this) {
377.                 $vendorQuotationPlanning->setProject(null);
378.             }
379.         }
381.         return $this;
382.     }
384.     /**
385.      *
386.      * @return Collection<int, SalesOrder>
387.      */
388.     public function getSalesOrders(): Collection
389.     {
390.         return $this->salesOrders;
391.     }
393.     //    public function addSalesOrder(SalesOrder $salesOrder): self
394.     //    {
395.     //        if (!$this->salesOrders->contains($salesOrder)) {
396.     //            $this->salesOrders[] = $salesOrder;
397.     //            $salesOrder->setProject($this);
398.     //        }
399.     //
400.     //        return $this;
401.     //    }
403.     public function removeSalesOrder(SalesOrder $salesOrder): self
404.     {
406.         if ($this->salesOrders->removeElement($salesOrder)) {
407.             // set the owning side to null (unless already changed)
408.             if ($salesOrder->getProject() === $this) {
409.                 $salesOrder->setProject(null);
410.             }
411.         }
413.         return $this;
414.     }
416.     public function getWinDate(): ?\DateTimeInterface
417.     {
418.         return $this->winDate;
419.     }
421.     public function setWinDate(?\DateTimeInterface $winDate): self
422.     {
423.         $this->winDate = $winDate;
425.         return $this;
426.     }
428.     public function getStartDate(): ?\DateTimeInterface
429.     {
430.         return $this->startDate;
431.     }
433.     public function setStartDate(?\DateTimeInterface $startDate): self
434.     {
435.         $this->startDate = $startDate;
437.         return $this;
438.     }
440.     public function getEndDate(): ?\DateTimeInterface
441.     {
442.         return $this->endDate;
443.     }
445.     public function setEndDate(?\DateTimeInterface $endDate): self
446.     {
447.         $this->endDate = $endDate;
449.         return $this;
450.     }
452.     public function getCreatedBy(): ?User
453.     {
454.         return $this->createdBy;
455.     }
457.     public function setCreatedBy(?User $createdBy): self
458.     {
459.         $this->createdBy = $createdBy;
461.         return $this;
462.     }
464.     public function getPersonInCharge(): ?User
465.     {
466.         return $this->personInCharge;
467.     }
469.     public function setPersonInCharge(?User $personInCharge): self
470.     {
471.         $this->personInCharge = $personInCharge;
473.         return $this;
474.     }
476.     public function getStatus(): ?string
477.     {
478.         return $this->status;
479.     }
481.     public function setStatus(?string $status): self
482.     {
483.         $this->status = $status;
485.         return $this;
486.     }
488.     public function getPlannedRevenue(): ?float
489.     {
490.         return $this->plannedRevenue;
491.     }
493.     public function setPlannedRevenue(?float $plannedRevenue): self
494.     {
495.         $this->plannedRevenue = $plannedRevenue;
496.         $this->plannedRevenueUsd = $this->getPlannedRevenueToUsd($plannedRevenue);
498.         return $this;
499.     }
501.     // public function getPlannedRevenueUsd(): ?float
502.     // {
503.     //     if ($this->currency == null || $this->currency->getIso() == 'USD') return $this->plannedRevenue;
504.     //     global $kernel;
505.     //     $currencyService = $kernel->getContainer()->get('CurrencyService');
506.     //     $dateStr = $this->createdAt->format('Y-m-d');
507.     //     return $currencyService->convertAtDate($dateStr, $this->currency->getIso(), 'USD', $this->plannedRevenue);
508.     // }
510.     public function getCurrency(): ?Currency
511.     {
512.         if (!$this->currency) {
513.             global $kernel;
514.             $currencyRepository = $kernel->getContainer()->get('doctrine')->getRepository(Currency::class);
515.             return $currencyRepository->findOneBy(['id' => 1]);
516.         }
517.         return $this->currency;
518.     }
520.     public function setCurrency(?Currency $currency): self
521.     {
522.         $this->currency = $currency;
524.         return $this;
525.     }
527.     public function getPlanFilename(): ?string
528.     {
529.         return $this->planFilename;
530.     }
532.     public function setPlanFilename(?string $planFilename): self
533.     {
534.         $this->planFilename = $planFilename;
536.         return $this;
537.     }
539.     public function getPlanFilepath(): ?string
540.     {
541.         return $this->planFilepath;
542.     }
544.     public function setPlanFilepath(?string $planFilepath): self
545.     {
546.         $this->planFilepath = $planFilepath;
548.         return $this;
549.     }
551.     public function getPlanFiletype(): ?string
552.     {
553.         return $this->planFiletype;
554.     }
556.     public function setPlanFiletype(?string $planFiletype): self
557.     {
558.         $this->planFiletype = $planFiletype;
560.         return $this;
561.     }
563.     public function getSoTotal()
564.     {
565.         $total = 0;
566.         $projectSalesOrders = $this->getProjectSalesOrders();
567.         foreach ($projectSalesOrders as $pso) {
568.             $total += $pso->getAmount();
569.         }
570.         return $total;
571.     }
573.     public function getSoTotalUsd()
574.     {
575.         global $kernel;
576.         $currencyService = $kernel->getContainer()->get('CurrencyService');
578.         $total = 0;
579.         $projectSalesOrders = $this->getProjectSalesOrders();
580.         foreach ($projectSalesOrders as $pso) {
581.             // $total += $pso->getAmountUsd();
582.             $total += $currencyService->convertAtDate($this->createdAt, $pso->getSalesOrder()->getCurrency()->getIso(), 'USD', $pso->getAmount());
583.         }
584.         return round($total, 2, PHP_ROUND_HALF_EVEN);
585.     }
587.     public function getInvoicesTotalPaid()
588.     {
589.         $total = 0;
590.         $projectSalesOrders = $this->getProjectSalesOrders();
591.         foreach ($projectSalesOrders as $pso) {
592.             $soInvoices = $pso->getSalesOrder()->getSalesOrderInvoices();
593.             foreach ($soInvoices as $soInvoice) {
594.                 if ($soInvoice->getProject()->getId() != $this->id) continue;
595.                 if ($soInvoice->getInvoice()->getXeroStatus() == 'VOIDED') continue;
596.                 if ($soInvoice->getInvoice()->getAmountDue() == 0) {
597.                     $total += $soInvoice->getAmount();
598.                 }
599.             }
600.         }
601.         return $total;
602.     }
603.     public function getInvoicesTotalPaidUsd()
604.     {
605.         global $kernel;
606.         $currencyService = $kernel->getContainer()->get('CurrencyService');
607.         $total = 0;
608.         $projectSalesOrders = $this->getProjectSalesOrders();
609.         foreach ($projectSalesOrders as $pso) {
610.             $soInvoices = $pso->getSalesOrder()->getSalesOrderInvoices();
611.             foreach ($soInvoices as $soInvoice) {
612.                 if ($soInvoice->getProject()->getId() != $this->id) continue;
613.                 if ($soInvoice->getInvoice()->getXeroStatus() == 'VOIDED') continue;
614.                 if ($soInvoice->getInvoice()->getAmountDue() == 0) {
615.                     $invDateStr = $soInvoice->getInvoice()->getInvoiceDate()->format('Y-m-d');
616.                     // $usValue = $currencyService->convertAtDate($invDateStr, $soInvoice->getInvoice()->getCurrency()->getIso(), 'USD', $soInvoice->getAmount());
617.                     $total += $currencyService->convertAtDate($this->createdAt, $soInvoice->getInvoice()->getCurrency()->getIso(), 'USD', $soInvoice->getAmount());
618.                 }
619.             }
620.         }
621.         return round($total, 2, PHP_ROUND_HALF_EVEN);
622.     }
623.     public function getInvoicesTotal()
624.     {
625.         $total = 0;
626.         $projectSalesOrders = $this->getProjectSalesOrders();
627.         foreach ($projectSalesOrders as $pso) {
628.             $soInvoices = $pso->getSalesOrder()->getSalesOrderInvoices();
629.             foreach ($soInvoices as $soInvoice) {
630.                 if ($soInvoice->getProject()->getId() != $this->id) continue;
631.                 if ($soInvoice->getInvoice()->getXeroStatus() == 'VOIDED') continue;
632.                 $total += $soInvoice->getAmount();
633.             }
634.         }
635.         return $total;
636.     }
638.     /**
639.      * @throws GuzzleException
640.      */
641.     public function getInvoicesTotalUsd($endDate = null)
642.     {
643.         global $kernel;
644.         $currencyService = $kernel->getContainer()->get('CurrencyService');
645.         $total = 0;
646.         $projectSalesOrders = $this->getProjectSalesOrders();
647.         foreach ($projectSalesOrders as $pso) {
648.             $soInvoices = $pso->getSalesOrder()->getSalesOrderInvoices();
649.             foreach ($soInvoices as $soInvoice) {   
650.                 if ($soInvoice->getInvoice()->getXeroStatus() == 'VOIDED') continue;
651.                 if ($endDate != null  && $soInvoice->getInvoice()->getInvoiceDate()->format('Y-m-d') > $endDate->format('Ymd')) continue;
652.                 if ($soInvoice->getProject()->getId() != $this->id) continue;
653.                 $invDateStr = $soInvoice->getInvoice()->getInvoiceDate()->format('Y-m-d');
654.                 // $usValue = $currencyService->convertAtDate($invDateStr, $soInvoice->getInvoice()->getCurrency()->getIso(), 'USD', $soInvoice->getAmount());
655.                 $total += $currencyService->convertAtDate($this->createdAt, $soInvoice->getInvoice()->getCurrency()->getIso(), 'USD',  $soInvoice->getAmount());
656.             }
657.         }
658.         return round($total, 2, PHP_ROUND_HALF_EVEN);
659.     }
661.     /**
662.      * @throws GuzzleException
663.      */
664.     public function getInvoicesTotalUsdByMonth($startDate, $endDate)
665.     {
666.         global $kernel;
667.         $currencyService = $kernel->getContainer()->get('CurrencyService');
668.         $total = 0;
669.         $projectSalesOrders = $this->getProjectSalesOrders();
670.         foreach ($projectSalesOrders as $pso) {
671.             $soInvoices = $pso->getSalesOrder()->getSalesOrderInvoices();
672.             foreach ($soInvoices as $soInvoice) {
673.                 if ($soInvoice->getInvoice()->getXeroStatus() == 'VOIDED') continue;
674.                 if ($soInvoice->getInvoice()->getInvoiceDate()->format('Ymd') < $startDate->format('Ymd')) continue;
675.                 if ($soInvoice->getInvoice()->getInvoiceDate()->format('Ymd') > $endDate->format('Ymd')) continue;
676.                 if ($soInvoice->getProject()->getId() != $this->id) continue;
677.                 $invDateStr = $soInvoice->getInvoice()->getInvoiceDate()->format('Y-m-d');
678.                 // $usValue = $currencyService->convertAtDate($invDateStr, $soInvoice->getInvoice()->getCurrency()->getIso(), 'USD', $soInvoice->getAmount());
679.                 $total += $currencyService->convertAtDate($this->createdAt, $soInvoice->getInvoice()->getCurrency()->getIso(), 'USD', $soInvoice->getAmount());
680.             }
681.         }
682.         return round($total, 2, PHP_ROUND_HALF_EVEN);
683.     }
685.     /**
686.      * @throws GuzzleException
687.      */
688.     public function getAllocatedInvoicesTotal($paid = false)
689.     {
690.         global $kernel;
691.         $total = 0;
692.         $projectSalesOrders = $this->getProjectSalesOrders();
693.         foreach ($projectSalesOrders as $pso) {
694.             $soInvoices = $pso->getSalesOrder()->getSalesOrderInvoices();
695.             foreach ($soInvoices as $soInvoice) {
696.                 if ($soInvoice->getInvoice()->getXeroStatus() == "VOIDED" || $soInvoice->getProject() !== $this) continue;
697.                 if ($paid && $soInvoice->getInvoice()->getXeroStatus() == "PAID") continue;
698.                 $total += $soInvoice->getAmount();
699.                 if ($soInvoice->getInvoice()->getXeroCreditNoteAllocation()) {
700.                     $total -= $soInvoice->getInvoice()->getXeroCreditNoteAllocation()->getAmount();
701.                 }
702.             }
703.         }
704.         return $total;
705.     }
707.     /**
708.      * @throws GuzzleException
709.      */
710.     public function getAllocatedInvoicesTotalUsd($paid = false)
711.     {
712.         global $kernel;
713.         $currencyService = $kernel->getContainer()->get('CurrencyService');
714.         $total = 0;
715.         $projectSalesOrders = $this->getProjectSalesOrders();
716.         foreach ($projectSalesOrders as $pso) {
717.             $soInvoices = $pso->getSalesOrder()->getSalesOrderInvoices();
718.             foreach ($soInvoices as $soInvoice) {
719.                 if ($soInvoice->getInvoice()->getXeroStatus() == "VOIDED" || $soInvoice->getProject() !== $this) continue;
720.                 if ($paid && $soInvoice->getInvoice()->getXeroStatus() == "PAID") continue;
721.                 // $invDateStr = $soInvoice->getInvoice()->getInvoiceDate()->format('Y-m-d');
722.                 // $usValue = $currencyService->convertAtDate($invDateStr, $soInvoice->getInvoice()->getCurrency()->getIso(), 'USD', $soInvoice->getAmount());
723.                 // $total += $usValue;
724.                 // $total += $soInvoice->getAmountUsd();
725.                 $total += $currencyService->convertAtDate($this->createdAt, $this->currency->getIso(), 'USD', $soInvoice->getAmount());
726.                 if ($soInvoice->getInvoice()->getXeroCreditNoteAllocation()) {
727.                     // $total -= $soInvoice->getInvoice()->getXeroCreditNoteAllocation()->getAmountUsd();
728.                     $total -= $currencyService->convertAtDate($this->createdAt, $soInvoice->getInvoice()->getCurrency()->getIso(), 'USD', $soInvoice->getInvoice()->getXeroCreditNoteAllocation()->getAmount());
729.                 }
730.             }
731.         }
732.         return round($total, 2, PHP_ROUND_HALF_EVEN);
733.     }
735.     /**
736.      * @throws GuzzleException
737.      */
738.     public function getAllocatedInvoicesTotalSgd($paid = false)
739.     {
740.         global $kernel;
741.         $currencyService = $kernel->getContainer()->get('CurrencyService');
742.         $total = 0;
743.         $projectSalesOrders = $this->getProjectSalesOrders();
744.         foreach ($projectSalesOrders as $pso) {
745.             $soInvoices = $pso->getSalesOrder()->getSalesOrderInvoices();
746.             foreach ($soInvoices as $soInvoice) {
747.                 if ($soInvoice->getInvoice()->getXeroStatus() == "VOIDED" || $soInvoice->getProject() !== $this) continue;
748.                 if ($paid && $soInvoice->getInvoice()->getXeroStatus() == "PAID") continue;
749.                 // $invDateStr = $soInvoice->getInvoice()->getInvoiceDate()->format('Y-m-d');
750.                 // $usValue = $currencyService->convertAtDate($invDateStr, $soInvoice->getInvoice()->getCurrency()->getIso(), 'USD', $soInvoice->getAmount());
751.                 // $total += $usValue;
752.                 // $total += $soInvoice->getAmountUsd();
753.                 $total += $currencyService->convertAtDate($this->createdAt, $this->currency->getIso(), 'SGD', $soInvoice->getAmount());
754.                 if ($soInvoice->getInvoice()->getXeroCreditNoteAllocation()) {
755.                     // $total -= $soInvoice->getInvoice()->getXeroCreditNoteAllocation()->getAmountUsd();
756.                     $total -= $currencyService->convertAtDate($this->createdAt, $soInvoice->getInvoice()->getCurrency()->getIso(), 'SGD', $soInvoice->getInvoice()->getXeroCreditNoteAllocation()->getAmount());
757.                 }
758.             }
759.         }
760.         return round($total, 2, PHP_ROUND_HALF_EVEN);
761.     }
763.     public function getTotalVQPPlannedAmt()
764.     {
765.         $total = 0;
766.         $vendorQuotationPlannings = $this->getVendorQuotationPlannings();
767.         foreach ($vendorQuotationPlannings as $vendorQuotationPlanning) {
768.             $total += $vendorQuotationPlanning->getAmountPlanned();
769.         }
770.         return $total;
771.     }
772.     public function getVendorQuotesTotalUSD()
773.     {
774.         global $kernel;
775.         $currencyService = $kernel->getContainer()->get('CurrencyService');
776.         $total = 0;
777.         $vendorQuotationPlannings = $this->getVendorQuotationPlannings();
778.         foreach ($vendorQuotationPlannings as $vendorQuotationPlanning) {
779.             $vendorQuotations = $vendorQuotationPlanning->getVendorQuotations();
780.             foreach ($vendorQuotations as $vendorQuotation) {
781.                 // $usValue = $currencyService->convertAtDate($vendorQuotation->getCreatedAt()->format('Y-m-d'), $vendorQuotation->getCurrency()->getIso(), 'USD', $vendorQuotation->getAmount());
782.                 $total += $currencyService->convertAtDate($this->createdAt, $vendorQuotation->getCurrency()->getIso(), 'USD', $vendorQuotation->getAmount());
783.             }
784.         }
786.         return round($total, 2, PHP_ROUND_HALF_EVEN);
787.     }
789.     public function getVendorQuotesTotal()
790.     {
791.         $total = 0;
793.         $vendorQuotationPlannings = $this->getVendorQuotationPlannings();
794.         foreach ($vendorQuotationPlannings as $vendorQuotationPlanning) {
795.             $vendorQuotations = $vendorQuotationPlanning->getVendorQuotations();
796.             foreach ($vendorQuotations as $vendorQuotation) {
797.                 $total += $vendorQuotation->getAmount();
798.             }
799.         }
801.         return $total;
802.     }
804.     public function getProjectManhour($endDate = null)
805.     {
806.         $total = 0;
807.         $tasks = $this->getTasks();
808.         foreach ($tasks as $task) {
809.             $timeSpents = $task->getTimeSpents();
810.             foreach ($timeSpents as $timeSpent) {
811.                 $timeSpentDate = $timeSpent->getDate()->format('Ymd');
812.                 //if ($this->startDate != null && $timeSpentDate < $this->startDate->format('Ymd')) continue;
813.                 if ($this->endDate != null && $timeSpentDate > $this->endDate->format('Ymd')) continue;
814.                 //if ($endDate != null && $timeSpentDate > $endDate->format('Ymd')) continue;
815.                 $hours = $timeSpent->getHours();
816.                 $total += $hours;
817.             };
818.         }
819.         return $total;
820.     }
822.     public function getProjectManhourByMonth($startDate, $endDate)
823.     {
824.         $total = 0;
825.         $tasks = $this->getTasks();
826.         foreach ($tasks as $task) {
827.             $timeSpents = $task->getTimeSpents();
828.             foreach ($timeSpents as $timeSpent) {
829.                 $timeSpentDate = $timeSpent->getDate()->format('Ymd');
830.                 //if ($this->startDate != null && $timeSpentDate < $this->startDate->format('Ymd')) continue;
831.                 if ($this->endDate != null && $timeSpentDate > $this->endDate->format('Ymd')) continue;
832.                 $hours = $timeSpent->getHours();
833.                 $total += $hours;
834.             };
835.         }
836.         return $total;
837.     }
839.     public function getProjectManhourCost($endDate = null) // FIX: error on manhourcost
840.     {
841.         // error_reporting(E_ALL);
842.         // ini_set('display_errors', 1);
844.         $total = 0;
845.         $tasks = $this->getTasks();
846.         foreach ($tasks as $task) {
847.             //     try {
848.             //     print_r($task->getTimeSpents());
849.             // } catch (Exception $e) {
850.             //     echo 'Caught exception: ',  $e->getMessage(), "\n";
851.             // }
852.             //     return 0;
853.             $timeSpents = $task->getTimeSpents();
854.             foreach ($timeSpents as $timeSpent) {
855.                 $timeSpentDate = $timeSpent->getDate()->format('Ymd');
856.                 if ($this->startDate == null || $this->endDate == null) continue;
857.                 if ($this->endDate != null && $timeSpentDate > $this->endDate->format('Ymd')) continue;
858.                 $hours = $timeSpent->getHours() ?? 0;
859.                 $rate = $timeSpent->getUser()->getHourlyRateUsd($timeSpentDate) ?? 0;
860.                 $total += $hours * $rate;
861.             }
862.         }
863.         return round($total, 2, PHP_ROUND_HALF_EVEN);
864.     }
866.     public function getProjectManhourCostByMonth($startDate, $endDate)
867.     {
868.         $total = 0;
869.         $tasks = $this->getTasks();
870.         foreach ($tasks as $task) {
871.             $timeSpents = $task->getTimeSpents();
872.             foreach ($timeSpents as $timeSpent) {
873.                 $timeSpentDate = $timeSpent->getDate()->format('Ymd');
874.                 //if ($this->startDate != null && $timeSpentDate < $this->startDate->format('Ymd')) continue;
875.                 if ($this->endDate != null && $timeSpentDate > $this->endDate->format('Ymd')) continue;
876.                 $hours = $timeSpent->getHours();
877.                 $rate = $timeSpent->getUser()->getHourlyRateUsd($timeSpentDate);
878.                 $total += $hours * $rate;
879.             }
880.         }
882.         return round($total, 2, PHP_ROUND_HALF_EVEN);
883.     }
886.     public function getProjectCost()
887.     {
888.         return $this->getVendorInvoicesTotalUSD() + $this->getProjectManhourCost();
889.     }
891.     public function getProjectEstimatedCost()
892.     {
893.         $totalEstimatedManHourCost = 0;
894.         foreach ($this->projectAllocatedHours as $allocation) {
895.             $totalEstimatedManHourCost += intval($allocation->getHours() * $allocation->getUserRole()->getCost());
896.         }
897.         return $this->getEstimatedVendorCostUsd() + $totalEstimatedManHourCost;
898.     }
900.     public function getProjectEstimatedHourCost()
901.     {
902.         $totalEstimatedManHourCost = 0;
903.         foreach ($this->projectAllocatedHours as $allocation) {
904.             $totalEstimatedManHourCost += intval($allocation->getHours() * $allocation->getUserRole()->getCost());
905.         }
906.         return $totalEstimatedManHourCost;
907.     }
909.     public function getProjectEstimatedHour()
910.     {
911.         $totalEstimatedManHour = 0;
912.         foreach ($this->projectAllocatedHours as $allocation) {
913.             $totalEstimatedManHour += intval($allocation->getHours());
914.         }
915.         return $totalEstimatedManHour;
916.     }
918.     public function getProjectEstimatedCostUsd()
919.     {
920.         if ($this->currency == null || $this->currency->getIso() == 'USD') return $this->getProjectEstimatedCost();
921.         global $kernel;
922.         $currencyService = $kernel->getContainer()->get('CurrencyService');
923.         $dateStr = $this->createdAt->format('Y-m-d');
924.         $amount = $currencyService->convertAtDate($dateStr, $this->currency->getIso(), 'USD', $this->getProjectEstimatedCost());
925.         return round($amount, 2, PHP_ROUND_HALF_EVEN);
926.     }
929.     /**
930.      * [sum]Invoices sent to client - [sum] Vendors invoices - man hours = Total Profit
931.      * @throws GuzzleException
932.      */
933.     public function getProjectProfit1()
934.     {
935.         return round($this->getInvoicesTotalUsd() - $this->getProjectCost(), 2, PHP_ROUND_HALF_EVEN);
936.     }
938.     /**
939.      * [sum]SalesOrders sent to client - [sum] Vendors invoices - man hours = Total Profit
940.      */
941.     public function getProjectProfit2()
942.     {
943.         return round($this->getSoTotalUsd() - $this->getVendorInvoicesTotalUSD() - $this->getProjectManhourCost(), 2, PHP_ROUND_HALF_EVEN);
944.     }
946.     /**
947.      * [sum]SalesOrders sent to client - [sum] Vendor Plan - man hours = Total Profit
948.      */
949.     public function getProjectProfit3()
950.     {
951.         // return $this->getSoTotalUsd() - $this->getVendorQuotesTotalUSD() - $this->getProjectManhourCost();
952.         return round($this->getSoTotalUsd() - $this->getVendorPlannedTotalUsd() - $this->getProjectManhourCost(), 2, PHP_ROUND_HALF_EVEN);
953.     }
955.     /**
956.      * [sum]INV sent to client - [sum] Vendors plan - man hours = Total Profit
957.      * @throws GuzzleException
958.      */
959.     public function getProjectProfit4()
960.     {
961.         // return $this->getInvoicesTotalUsd() - $this->getVendorQuotesTotalUSD() - $this->getProjectManhourCost();
962.         return round($this->getInvoicesTotalUsd() - $this->getVendorPlannedTotalUsd() - $this->getProjectManhourCost(), 2, PHP_ROUND_HALF_EVEN);
963.     }
965.     /**
966.      * (Total Invoices - vendor invoice total- manhourCost) * 100 / total invoices
967.      * @throws GuzzleException
968.      */
969.     public function getProjectGrossmargin1()
970.     {
971.         if ($this->getInvoicesTotalUsd() == 0 || $this->getProjectProfit1() == 0) return 0;
972.         return round($this->getProjectProfit1() / $this->getInvoicesTotalUsd() * 100, 2, PHP_ROUND_HALF_EVEN);
973.     }
974.     /**
975.      *
976.      * (SO total - Vendor INV total - manhourCost) * 100 / SO total
977.      * @throws GuzzleException
978.      */
979.     public function getProjectGrossmargin2()
980.     {
981.         if ($this->getSoTotalUsd() == 0 || $this->getProjectProfit2() == 0) return 0;
982.         return round($this->getProjectProfit2() / $this->getSoTotalUsd() * 100, 2, PHP_ROUND_HALF_EVEN);
983.     }
985.     /**
986.      * (SO total - Vendor plan total - manhourCost) * 100 / SO total
987.      * @throws GuzzleException
988.      */
990.     public function getProjectGrossmargin3()
991.     {
992.         if ($this->getSoTotalUsd() == 0 || $this->getProjectProfit3() == 0) return 0;
993.         return round($this->getProjectProfit3() / $this->getSoTotalUsd() * 100, 2, PHP_ROUND_HALF_EVEN);
994.     }
997.     /**
998.      * (Total Invoices - vendor plan total - manhourCost) * 100 / total invoices
999.      * @throws GuzzleException
1000.      */
1001.     public function getProjectGrossmargin4()
1002.     {
1003.         if ($this->getInvoicesTotalUsd() == 0 || $this->getProjectProfit4() == 0) return 0;
1004.         return round($this->getProjectProfit4() / $this->getInvoicesTotalUsd() * 100, 2, PHP_ROUND_HALF_EVEN);
1005.     }
1008.     /**
1009.      * @throws GuzzleException
1010.      */
1011.     public function getInvPercentagePaid()
1012.     {
1013.         if ($this->getInvoicesTotal() > 0) {
1014.             $percentagePaid = round($this->getInvoicesTotalPaid() / $this->getInvoicesTotal() * 100, 2, PHP_ROUND_HALF_EVEN);
1015.         } else {
1016.             $percentagePaid = 0;
1017.         }
1018.         return $percentagePaid;
1019.     }
1023.     public function getVendorPlannedTotal()
1024.     {
1025.         $vendorPlannedTotal = 0;
1026.         $vendorQuotationPlannings = $this->getVendorQuotationPlannings();
1027.         foreach ($vendorQuotationPlannings as $vendorQuotationPlanning) {
1028.             $vendorPlannedTotal += $vendorQuotationPlanning->getAmountPlanned();
1029.         }
1031.         return $vendorPlannedTotal;
1032.     }
1034.     public function getVendorPlannedTotalUsd()
1035.     {
1036.         global $kernel;
1037.         $currencyService = $kernel->getContainer()->get('CurrencyService');
1039.         $vendorPlannedTotalUSD = 0;
1040.         $vendorQuotationPlannings = $this->getVendorQuotationPlannings();
1041.         foreach ($vendorQuotationPlannings as $vendorQuotationPlanning) {
1042.             $dateStr = $vendorQuotationPlanning->getCreatedAt()->format('Y-m-d');
1043.             // $usValue = $currencyService->convertAtDate($dateStr, $vendorQuotationPlanning->getCurrency()->getIso(), 'USD', $vendorQuotationPlanning->getAmountPlanned());
1044.             $usValue = $currencyService->convertAtDate($dateStr, $vendorQuotationPlanning->getCurrency()->getIso(), 'USD', $vendorQuotationPlanning->getAmountPlanned());
1045.             $vendorPlannedTotalUSD += $usValue;
1046.         }
1048.         return round($vendorPlannedTotalUSD, 2, PHP_ROUND_HALF_EVEN);
1049.     }
1052.     public function getVendorPaymentStatus()
1053.     {
1054.         $vendorQuotationPlannings = $this->getVendorQuotationPlannings();
1056.         $vendorPaidCount = 0;
1057.         $vendorNotPaidCount = 0;
1058.         foreach ($vendorQuotationPlannings as $vendorQuotationPlanning) {
1059.             $vqpInvoices = $vendorQuotationPlanning->getVendorQuotationPlanningVendorInvoices();
1060.             foreach ($vqpInvoices as $vqpInvoice) {
1061.                 $vendorInvoice = $vqpInvoice->getVendorInvoice();
1062.                 if ($vendorInvoice->getXeroStatus() === "PAID") {
1063.                     $vendorPaidCount++;
1064.                 } else if ($vendorInvoice->getXeroStatus() === "UNPAID") {
1065.                     $vendorNotPaidCount++;
1066.                 }
1067.             }
1068.         }
1069.         $vendorPaymentStatus = "";
1070.         if ($vendorNotPaidCount === 0 && $vendorPaidCount > 0) {
1071.             $vendorPaymentStatus = "Fully Paid";
1072.         } else if ($vendorPaidCount > 0 && $vendorNotPaidCount > 0) {
1073.             $vendorPaymentStatus = "Partially Paid";
1074.         } else {
1075.             $vendorPaymentStatus = "Not Paid";
1076.         }
1077.         return $vendorPaymentStatus;
1078.     }
1080.     public function getVendorPercentagePaid()
1081.     {
1082.         if ($this->getVendorInvoicesTotal() > 0) {
1083.             // $percentagePaid = round($this->getVendorInvoicesTotalPaid() / $this->getVendorInvoicesTotal() * 100, 2);
1084.             $percentagePaid = round(($this->getVendorPlannedTotalUsd() - $this->getVendorInvoicesTotalUsd()) / $this->getVendorPlannedTotalUsd() * 100, 2, PHP_ROUND_HALF_EVEN);
1085.         } else {
1086.             $percentagePaid = 0;
1087.         }
1088.         return $percentagePaid;
1089.     }
1091.     public function getVendorInvoicesTotal()
1092.     {
1093.         $vendorInvoicesTotal = 0;
1094.         $vendorQuotationPlannings = $this->getVendorQuotationPlannings();
1095.         foreach ($vendorQuotationPlannings as $vendorQuotationPlanning) {
1096.             $vqpInvoices = $vendorQuotationPlanning->getVendorQuotationPlanningVendorInvoices();
1097.             foreach ($vqpInvoices as $vqpInvoice) {
1098.                 // here we get amount from allocation, not directly from Vendor Invoice
1099.                 if($vqpInvoice->getVendorInvoice()->getXeroStatus() == 'VOIDED') continue;
1100.                 $vendorInvoicesTotal += $vqpInvoice->getAmount();
1101.                 // $vendorInvoicesTotal += $vqpInvoice->getVendorInvoice()->getSubTotal();
1102.             }
1103.         }
1104.         return $vendorInvoicesTotal;
1105.     }
1108.     public function getVendorInvoicesTotalUsd($endDate = null)
1109.     {
1110.         global $kernel;
1111.         $currencyService = $kernel->getContainer()->get('CurrencyService');
1113.         $vendorInvoicesTotalUSD = 0;
1114.         $vendorQuotationPlannings = $this->getVendorQuotationPlannings();
1115.         foreach ($vendorQuotationPlannings as $vendorQuotationPlanning) {
1116.             $vqpInvoices = $vendorQuotationPlanning->getVendorQuotationPlanningVendorInvoices();
1117.             foreach ($vqpInvoices as $vqpInvoice) {
1118.                 // if ($vqpInvoice->getVendorInvoice()->getXeroStatus() != 'PAID') continue;
1119.                 if($vqpInvoice->getVendorInvoice()->getXeroStatus() == 'VOIDED') continue;
1120.                 if ($endDate != null && $vqpInvoice->getVendorInvoice()->getInvoiceDate()->format('Ymd') > $endDate->format('Ymd')) continue;
1122.                 // $vendorInvoicesTotalUSD += $vqpInvoice->getAmountUsd();
1123.                 $dateStr = $vqpInvoice->getVendorInvoice()->getInvoiceDate()->format('Y-m-d');
1124.                 $vendorInvoicesTotalUSD += $currencyService->convertAtDate($dateStr, $vqpInvoice->getVendorInvoice()->getCurrency()->getIso(), 'USD', $vqpInvoice->getAmount());
1125.             }
1126.         }
1127.         return round($vendorInvoicesTotalUSD, 2, PHP_ROUND_HALF_EVEN);
1128.     }
1130.     public function getVendorInvoicesTotalSgd($endDate = null)
1131.     {
1132.         global $kernel;
1133.         $currencyService = $kernel->getContainer()->get('CurrencyService');
1135.         $vendorInvoicesTotalUSD = 0;
1136.         $vendorQuotationPlannings = $this->getVendorQuotationPlannings();
1137.         foreach ($vendorQuotationPlannings as $vendorQuotationPlanning) {
1138.             $vqpInvoices = $vendorQuotationPlanning->getVendorQuotationPlanningVendorInvoices();
1139.             foreach ($vqpInvoices as $vqpInvoice) {
1140.                 // if ($vqpInvoice->getVendorInvoice()->getXeroStatus() != 'PAID') continue;
1141.                 if($vqpInvoice->getVendorInvoice()->getXeroStatus() == 'VOIDED') continue;
1142.                 if ($endDate != null && $vqpInvoice->getVendorInvoice()->getInvoiceDate()->format('Ymd') > $endDate->format('Ymd')) continue;
1144.                 // $vendorInvoicesTotalUSD += $vqpInvoice->getAmountUsd();
1145.                 $dateStr = $vqpInvoice->getVendorInvoice()->getInvoiceDate()->format('Y-m-d');
1146.                 $vendorInvoicesTotalUSD += $currencyService->convertAtDate($dateStr, $vqpInvoice->getVendorInvoice()->getCurrency()->getIso(), 'SGD', $vqpInvoice->getAmount());
1147.             }
1148.         }
1149.         return round($vendorInvoicesTotalUSD, 2, PHP_ROUND_HALF_EVEN);
1150.     }
1152.     public function getVendorInvoices()
1153.     {
1154.         $vendorInvoices = [];
1155.         $vendorQuotationPlannings = $this->getVendorQuotationPlannings();
1156.         foreach ($vendorQuotationPlannings as $vendorQuotationPlanning) {
1157.             $vqpInvoices = $vendorQuotationPlanning->getVendorQuotationPlanningVendorInvoices();
1158.             foreach ($vqpInvoices as $vqpInvoice) {
1159.                 // here we get amount from allocation, not directly from Vendor Invoice
1160.                 array_push($vendorInvoices, $vqpInvoice->getVendorInvoice());
1161.                 // $vendorInvoicesTotal += $vqpInvoice->getVendorInvoice()->getSubTotal();
1162.             }
1163.         }
1164.         return $vendorInvoices;
1165.     }
1167.     public function getProjectBudgetRemaining()
1168.     {
1169.         return round($this->getVendorPlannedTotal() - $this->getVendorInvoicesTotal(), 2, PHP_ROUND_HALF_EVEN);
1170.     }
1172.     public function getProjectBudgetRemainingUsd()
1173.     {
1174.         return round($this->getVendorPlannedTotalUsd() - $this->getVendorInvoicesTotalUsd(), 2, PHP_ROUND_HALF_EVEN);
1175.     }
1177.     public function getVendorInvoicesTotalUsdByMonth($startDate, $endDate)
1178.     {
1179.         global $kernel;
1180.         $currencyService = $kernel->getContainer()->get('CurrencyService');
1182.         $vendorInvoicesTotalUSD = 0;
1183.         $vendorQuotationPlannings = $this->getVendorQuotationPlannings();
1184.         foreach ($vendorQuotationPlannings as $vendorQuotationPlanning) {
1185.             $vqpInvoices = $vendorQuotationPlanning->getVendorQuotationPlanningVendorInvoices();
1186.             foreach ($vqpInvoices as $vqpInvoice) {
1188.                 $vqpInvoiceDate = $vqpInvoice->getVendorInvoice()->getInvoiceDate()->format('Ymd');
1189.                 if ($vqpInvoiceDate >= $startDate->format('Ymd') && $vqpInvoiceDate <= $endDate->format('Ymd')) {
1190.                     if ($vqpInvoice->getVendorInvoice()->getXeroStatus() != 'PAID') continue;
1191.                     // $vendorInvoicesTotalUSD += $vqpInvoice->getVendorInvoice()->getSubTotalUsd();
1192.                     $dateStr = $vqpInvoice->getVendorInvoice()->getInvoiceDate()->format('Y-m-d');
1193.                     $vendorInvoicesTotalUSD += $currencyService->convertAtDate($dateStr, $vqpInvoice->getVendorInvoice()->getCurrency()->getIso(), 'USD', $vqpInvoice->getVendorInvoice()->getSubTotal());
1194.                 }
1195.             }
1196.         }
1197.         return round($vendorInvoicesTotalUSD, 2, PHP_ROUND_HALF_EVEN);
1198.     }
1200.     public function getVendorInvoicesTotalPaid()
1201.     {
1202.         global $kernel;
1203.         $currencyService = $kernel->getContainer()->get('CurrencyService');
1205.         $vendorInvoicesTotalPaid = 0;
1206.         $vendorQuotationPlannings = $this->getVendorQuotationPlannings();
1207.         foreach ($vendorQuotationPlannings as $vendorQuotationPlanning) {
1208.             $vqpInvoices = $vendorQuotationPlanning->getVendorQuotationPlanningVendorInvoices();
1209.             foreach ($vqpInvoices as $vqpInvoice) {
1210.                 if ($vqpInvoice->getVendorInvoice()->getXeroStatus() === "PAID") {
1211.                     $vendorInvoicesTotalPaid += $vqpInvoice->getAmount();
1212.                     // $vendorInvoicesTotalPaid += $currencyService->convertAtDate($this->createdAt, $vqpInvoice->getVendorInvoice()->getCurrency()->getIso(), 'USD', $vqpInvoice->getAmount());
1213.                 }
1214.             }
1215.         }
1216.         return round($vendorInvoicesTotalPaid, 2, PHP_ROUND_HALF_EVEN);
1217.     }
1219.     public function getVendorInvoicesTotalPaidUsd()
1220.     {
1221.         global $kernel;
1222.         $currencyService = $kernel->getContainer()->get('CurrencyService');
1224.         $vendorInvoicesTotalPaid = 0;
1225.         $vendorQuotationPlannings = $this->getVendorQuotationPlannings();
1226.         foreach ($vendorQuotationPlannings as $vendorQuotationPlanning) {
1227.             $vqpInvoices = $vendorQuotationPlanning->getVendorQuotationPlanningVendorInvoices();
1228.             foreach ($vqpInvoices as $vqpInvoice) {
1229.                 if ($vqpInvoice->getVendorInvoice()->getXeroStatus() === "PAID") {
1230.                     // $vendorInvoicesTotalPaid += $vqpInvoice->getAmount();
1231.                     $dateStr = $vqpInvoice->getVendorInvoice()->getInvoiceDate()->format('Y-m-d');
1232.                     $vendorInvoicesTotalPaid += $currencyService->convertAtDate($dateStr, $vqpInvoice->getVendorInvoice()->getCurrency()->getIso(), 'USD', $vqpInvoice->getAmount());
1233.                 }
1234.             }
1235.         }
1236.         return round($vendorInvoicesTotalPaid, 2, PHP_ROUND_HALF_EVEN);
1237.     }
1239.     /**
1240.      * @return Collection<int, ProjectMember>
1241.      */
1242.     public function getProjectMembers(): Collection
1243.     {
1244.         return $this->projectMembers;
1245.     }
1247.     public function getProjectMember($user)
1248.     {
1249.         if (is_object($user)) {
1250.             foreach ($this->projectMembers as $member) {
1251.                 if ($member->getUser() == $user) return $member;
1252.             };
1253.         } else {
1254.             foreach ($this->projectMembers as $member) {
1255.                 if ($member->getUser()->getId() == $user) return $member;
1256.             };
1257.         }
1258.         return false;
1259.     }
1261.     public function getIsIncluded($user)
1262.     {
1263.         foreach ($this->projectMembers as $member) {
1264.             if ($member->getUser() == $user) return true;
1265.         };
1266.         return false;
1267.     }
1269.     public function getProjectMembersByDepartmentId($departmentId)
1270.     {
1271.         $members = [];
1272.         foreach ($this->projectMembers as $member) {
1273.             if (($member->getUser()->getDepartment() !== null) && ($member->getUser()->getDepartment()->getId() == $departmentId)) {
1274.                 // array_push($members, $member);
1275.                 $members[] = $member;
1276.             }
1277.         }
1278.         return $members;
1279.     }
1281.     public function addProjectMember(ProjectMember $projectMember): self
1282.     {
1283.         if (!$this->projectMembers->contains($projectMember)) {
1284.             $this->projectMembers[] = $projectMember;
1285.             $projectMember->setProject($this);
1286.         }
1288.         return $this;
1289.     }
1291.     public function removeProjectMember(ProjectMember $projectMember): self
1292.     {
1293.         if ($this->projectMembers->removeElement($projectMember)) {
1294.             // set the owning side to null (unless already changed)
1295.             if ($projectMember->getProject() === $this) {
1296.                 $projectMember->setProject(null);
1297.             }
1298.         }
1300.         return $this;
1301.     }
1303.     public function getDeletedAt(): ?\DateTimeImmutable
1304.     {
1305.         return $this->deletedAt;
1306.     }
1308.     public function setDeletedAt(?\DateTimeImmutable $deletedAt): self
1309.     {
1310.         $this->deletedAt = $deletedAt;
1312.         return $this;
1313.     }
1315.     /**
1316.      * @return Collection<int, Department>
1317.      */
1318.     public function getDepartment(): Collection
1319.     {
1320.         return $this->department;
1321.     }
1323.     public function addDepartment(Department $department): self
1324.     {
1325.         if (!$this->department->contains($department)) {
1326.             $this->department[] = $department;
1327.         }
1329.         return $this;
1330.     }
1332.     public function removeDepartment(Department $department): self
1333.     {
1334.         $this->department->removeElement($department);
1336.         return $this;
1337.     }
1339.     function departmentNames()
1340.     {
1341.         $departments = [];
1342.         foreach ($this->getDepartment() as $department) {
1343.             if (!in_array($department->getName(), $departments))
1344.                 array_push($departments, $department->getName());
1345.         }
1346.         return implode(', ', $departments);
1347.     }
1349.     public function getRetainer(): ?bool
1350.     {
1351.         return $this->retainer;
1352.     }
1354.     public function setRetainer(bool $retainer): self
1355.     {
1356.         $this->retainer = $retainer;
1358.         return $this;
1359.     }
1361.     public function getLead(): ?int
1362.     {
1363.         // return $this->lead;
1364.         return $this->leadStatus ? $this->leadStatus->getLead() : $this->lead;
1365.     }
1367.     public function setLead(?int $lead): self
1368.     {
1370.         global $kernel;
1371.         $projectService = $kernel->getContainer()->get('ProjectService');
1372.         $projectLeadStatus = $projectService->getProjectLeadStatus($lead);
1373.         $this->setProbability($projectLeadStatus ? $projectLeadStatus->getProbability() : $this->probability);
1374.         $this->setLeadStatus($projectLeadStatus);
1375.         $this->lead = $lead;
1376.         return $this;
1377.     }
1379.     public function getType(): ?string
1380.     {
1381.         return $this->type;
1382.     }
1384.     public function setType(string $type): self
1385.     {
1386.         $this->type = $type;
1388.         return $this;
1389.     }
1391.     public function getLeadDate(): ?\DateTimeInterface
1392.     {
1393.         return $this->leadDate;
1394.     }
1396.     public function setLeadDate(?\DateTimeInterface $leadDate): self
1397.     {
1398.         $this->leadDate = $leadDate;
1400.         return $this;
1401.     }
1403.     public function getProposalDate(): ?\DateTimeInterface
1404.     {
1405.         return $this->proposalDate;
1406.     }
1408.     public function setProposalDate(?\DateTimeInterface $proposalDate): self
1409.     {
1410.         $this->proposalDate = $proposalDate;
1412.         return $this;
1413.     }
1415.     public function leadStatusText($id = null)
1416.     {
1417.         return $this->leadStatus->getName() || 'Unknown';
1418.     }
1420.     public function getPlanURL(): ?string
1421.     {
1422.         return $this->planURL;
1423.     }
1425.     public function setPlanURL(?string $planURL): self
1426.     {
1427.         $this->planURL = $planURL;
1429.         return $this;
1430.     }
1432.     public function getEstimatedProfit(): ?float
1433.     {
1434.         return $this->plannedRevenue - $this->estimatedVendorCost;
1435.         // return $this->estimatedProfit;
1436.     }
1438.     public function setEstimatedProfit(?float $estimatedProfit): self
1439.     {
1440.         $this->estimatedProfit = $estimatedProfit;
1442.         return $this;
1443.     }
1445.     public function getEstimatedProfitUsd()
1446.     {
1447.         // if ($this->currency == null || $this->currency->getIso() == 'USD') return $this->getEstimatedProfit();
1448.         // global $kernel;
1449.         // $currencyService = $kernel->getContainer()->get('CurrencyService');
1450.         // $dateStr = $this->createdAt->format('Y-m-d');
1451.         // return $currencyService->convertAtDate($dateStr, $this->currency->getIso(), 'USD', $this->getEstimatedProfit());
1452.         return round($this->plannedRevenueUsd - $this->estimatedVendorCostUsd, 2, PHP_ROUND_HALF_EVEN);
1453.     }
1455.     public function actualStatus()
1456.     {
1457.         if ($this->type == "LEAD") {
1458.             return $this->lead . ' - ' . $this->getLeadStatus()->getName();
1459.         } else {
1460.             return $this->status;
1461.         }
1462.     }
1464.     public function getEstimatedVendorCost(): ?float
1465.     {
1466.         return $this->estimatedVendorCost;
1467.     }
1469.     public function setEstimatedVendorCost(float $estimatedVendorCost): self
1470.     {
1471.         $this->estimatedVendorCost = $estimatedVendorCost;
1472.         $this->estimatedVendorCostUsd = $this->getEstimatedVendorCostToUsd($estimatedVendorCost);
1473.         return $this;
1474.     }
1476.     /**
1477.      * @return Collection<int, ProjectSalesOrder>
1478.      */
1479.     public function getProjectSalesOrders(): Collection
1480.     {
1481.         return $this->projectSalesOrders;
1482.     }
1484.     public function addProjectSalesOrder(ProjectSalesOrder $projectSalesOrder): self
1485.     {
1486.         if (!$this->projectSalesOrders->contains($projectSalesOrder)) {
1487.             $this->projectSalesOrders[] = $projectSalesOrder;
1488.             $projectSalesOrder->setProject($this);
1489.         }
1491.         return $this;
1492.     }
1494.     public function removeProjectSalesOrder(ProjectSalesOrder $projectSalesOrder): self
1495.     {
1496.         if ($this->projectSalesOrders->removeElement($projectSalesOrder)) {
1497.             // set the owning side to null (unless already changed)
1498.             if ($projectSalesOrder->getProject() === $this) {
1499.                 $projectSalesOrder->setProject(null);
1500.             }
1501.         }
1503.         return $this;
1504.     }
1506.     public function getProjectSalesOrderTotalAmountUsed(): ?float
1507.     {
1508.         $amountUsed = 0;
1509.         foreach ($this->projectSalesOrders as $projectSalesOrder) {
1510.             $amountUsed += $projectSalesOrder->getAmount();
1511.         }
1513.         return $amountUsed;
1514.     }
1515.     public function getProjectSalesOrderTotalAmountUsedUsd(): ?float
1516.     {
1517.         global $kernel;
1518.         $currencyService = $kernel->getContainer()->get('CurrencyService');
1519.         $amount = 0;
1520.         // return $currencyService->convertAtDate($dateStr, $this->currency->getIso(), 'USD',  $this->getProjectSalesOrderTotalAmountUsed());
1521.         foreach ($this->projectSalesOrders as $projectSalesOrder) {
1522.             $amount += $currencyService->convertAtDate($this->createdAt, $projectSalesOrder->getSalesOrder()->getCurrency()->getIso(), 'USD',  $projectSalesOrder->getAmount());
1523.         }
1524.         return round($amount, 2, PHP_ROUND_HALF_EVEN);
1525.     }
1526.     /**
1527.      * @return Collection|ProjectAllocatedHours[]
1528.      */
1529.     public function getProjectAllocatedHours(): Collection
1530.     {
1531.         return $this->projectAllocatedHours;
1532.     }
1534.     public function addProjectAllocatedHour(ProjectAllocatedHours $projectAllocatedHour): self
1535.     {
1536.         if (!$this->projectAllocatedHours->contains($projectAllocatedHour)) {
1537.             $this->projectAllocatedHours[] = $projectAllocatedHour;
1538.             $projectAllocatedHour->setProject($this);
1539.         }
1541.         return $this;
1542.     }
1544.     public function removeProjectAllocatedHour(ProjectAllocatedHours $projectAllocatedHour): self
1545.     {
1546.         if ($this->projectAllocatedHours->removeElement($projectAllocatedHour)) {
1547.             // set the owning side to null (unless already changed)
1548.             if ($projectAllocatedHour->getProject() === $this) {
1549.                 $projectAllocatedHour->setProject(null);
1550.             }
1551.         }
1553.         return $this;
1554.     }
1556.     public function getLeadSource(): ?string
1557.     {
1558.         return $this->leadSource;
1559.     }
1561.     public function setLeadSource(?string $leadSource): self
1562.     {
1563.         $this->leadSource = $leadSource;
1565.         return $this;
1566.     }
1568.     public function getLeadSourceFormatted(): ?string
1569.     {
1570.         if ($this->leadSource == "client") {
1571.             return "Existing client";
1572.         } else if ($this->leadSource == "other") {
1573.             return "Other";
1574.         } else {
1575.             return $this->leadSource;
1576.         }
1577.     }
1579.     public function getLastReminder(): ?\DateTimeImmutable
1580.     {
1581.         return $this->lastReminder;
1582.     }
1584.     public function setLastReminder(?\DateTimeImmutable $lastReminder): self
1585.     {
1586.         $this->lastReminder = $lastReminder;
1588.         return $this;
1589.     }
1591.     public function getGeneratedId(): ?string
1592.     {
1593.         return $this->generatedId;
1594.     }
1596.     public function setGeneratedId(?string $generatedId): self
1597.     {
1598.         $this->generatedId = $generatedId;
1600.         return $this;
1601.     }
1603.     public function getLeadFailDate(): ?\DateTimeImmutable
1604.     {
1605.         return $this->leadFailDate;
1606.     }
1608.     public function setLeadFailDate(?\DateTimeImmutable $leadFailDate): self
1609.     {
1610.         $this->leadFailDate = $leadFailDate;
1612.         return $this;
1613.     }
1615.     public function getLeadFailNote(): ?string
1616.     {
1617.         return $this->leadFailNote;
1618.     }
1620.     public function setLeadFailNote(?string $leadFailNote): self
1621.     {
1622.         $this->leadFailNote = $leadFailNote;
1624.         return $this;
1625.     }
1627.     public function getLeadFailRemindDate(): ?\DateTimeImmutable
1628.     {
1629.         return $this->leadFailRemindDate;
1630.     }
1632.     public function setLeadFailRemindDate(?\DateTimeImmutable $leadFailRemindDate): self
1633.     {
1634.         $this->leadFailRemindDate = $leadFailRemindDate;
1636.         return $this;
1637.     }
1639.     public function getClientPersonInCharge(): ?ClientContact
1640.     {
1641.         return $this->clientPersonInCharge;
1642.     }
1644.     public function setClientPersonInCharge(?ClientContact $clientPersonInCharge): self
1645.     {
1646.         $this->clientPersonInCharge = $clientPersonInCharge;
1647.         return $this;
1648.     }
1650.     /**
1651.      * @return Collection|SalesOrderPurchaseOrder[]
1652.      */
1653.     public function getSalesOrderPurchaseOrders(): Collection
1654.     {
1655.         return $this->salesOrderPurchaseOrders;
1656.     }
1658.     public function addSalesOrderPurchaseOrder(SalesOrderPurchaseOrder $salesOrderPurchaseOrder): self
1659.     {
1660.         if (!$this->salesOrderPurchaseOrders->contains($salesOrderPurchaseOrder)) {
1661.             $this->salesOrderPurchaseOrders[] = $salesOrderPurchaseOrder;
1662.             $salesOrderPurchaseOrder->setProject($this);
1663.         }
1665.         return $this;
1666.     }
1668.     public function removeSalesOrderPurchaseOrder(SalesOrderPurchaseOrder $salesOrderPurchaseOrder): self
1669.     {
1670.         if ($this->salesOrderPurchaseOrders->removeElement($salesOrderPurchaseOrder)) {
1671.             // set the owning side to null (unless already changed)
1672.             if ($salesOrderPurchaseOrder->getProject() === $this) {
1673.                 $salesOrderPurchaseOrder->setProject(null);
1674.             }
1675.         }
1677.         return $this;
1678.     }
1680.     public function getPlannedRevenueUsd(): ?float
1681.     {
1682.         return $this->plannedRevenueUsd; // already converted properly 
1683.     }
1685.     public function setPlannedRevenueUsd(?float $plannedRevenueUsd): self
1686.     {
1687.         $this->plannedRevenueUsd = $plannedRevenueUsd;
1689.         return $this;
1690.     }
1692.     public function getPlannedRevenueToUsd(): ?float
1693.     {
1694.         if ($this->currency == null || $this->currency->getIso() == 'USD') return $this->plannedRevenue ?? 0;
1695.         global $kernel;
1696.         $currencyService = $kernel->getContainer()->get('CurrencyService');
1697.         // $dateStr = $this->createdAt ? $this->createdAt->format('Y-m-d') : date('Y-m-d');
1698.         // return $currencyService->convertAtDate($dateStr, $this->currency->getIso(), 'USD', $this->plannedRevenue) ?? 0;
1699.         $dateStr = $this->createdAt ?? date('Y-m-d');
1700.         $amount = $currencyService->convertAtDate($dateStr, $this->currency->getIso(), 'USD', $this->plannedRevenue) ?? 0;
1701.         return round($amount, 2, PHP_ROUND_HALF_EVEN);
1702.     }
1704.     public function getNoEstimatedVendorCost(): ?bool
1705.     {
1706.         return $this->noEstimatedVendorCost;
1707.     }
1709.     public function setNoEstimatedVendorCost(bool $noEstimatedVendorCost): self
1710.     {
1711.         $this->noEstimatedVendorCost = $noEstimatedVendorCost;
1713.         return $this;
1714.     }
1716.     public function getEstimatedVendorCostUsd(): ?float
1717.     {
1718.         return $this->estimatedVendorCostUsd; // already converted properly
1719.     }
1721.     public function setEstimatedVendorCostUsd(float $estimatedVendorCostUsd): self
1722.     {
1723.         $this->estimatedVendorCostUsd = $estimatedVendorCostUsd;
1725.         return $this;
1726.     }
1728.     public function getEstimatedVendorCostToUsd(): ?float
1729.     {
1730.         if ($this->currency == null || $this->currency->getIso() == 'USD') return $this->estimatedVendorCost ?? 0;
1731.         global $kernel;
1732.         $currencyService = $kernel->getContainer()->get('CurrencyService');
1733.         // $dateStr = $this->startDate->format('Y-m-d');
1734.         // $dateStr = !empty($this->startDate) ? $this->startDate->format('Y-m-d') : date('Y-m-d');
1735.         // return $currencyService->convertAtDate($dateStr, $this->currency->getIso(), 'USD', $this->estimatedVendorCost) ?? 0;
1736.         $dateStr = $this->createdAt ?? date('Y-m-d');
1737.         $amount = $currencyService->convertAtDate($dateStr, $this->currency->getIso(), 'USD', $this->estimatedVendorCost) ?? 0;
1738.         return round($amount, 2, PHP_ROUND_HALF_EVEN);
1739.     }
1741.     public function getProbability(): ?int
1742.     {
1743.         return $this->probability;
1744.     }
1746.     public function setProbability(?int $probability): self
1747.     {
1748.         $this->probability = $probability;
1750.         return $this;
1751.     }
1752.     public function getProbabilityRate()
1753.     {
1754.         $probability  = $this->probability ?? 0;
1755.         if ($probability == 0) {
1756.             // switch ($this->lead) {
1757.             //     case 8:
1758.             //         $probability = 100;
1759.             //         break;
1760.             //     case 9:
1761.             //         $probability = 0;
1762.             //         break;
1763.             //     default:
1764.             //         $probability = 10;
1765.             //         break;
1766.             // }
1767.             $probability = $this->leadStatus->getProbability();
1768.         }
1769.         return $probability;
1770.     }
1771.     public function getProbabilityText()
1772.     {
1773.         // $probability  = $this->probability;
1774.         // switch ($probability) {
1775.         //     case 100:
1776.         //         return "100%";
1777.         //         break;
1778.         //     case 90:
1779.         //         return "Above 80%";
1780.         //         break;
1781.         //     case 50:
1782.         //         return "Between 50% to 80%";
1783.         //         break;
1784.         //     case 10:
1785.         //         return "Below 50%";
1786.         //         break;
1787.         //     case 0:
1788.         //         return "0%";
1789.         //         break;
1790.         //     default:
1791.         //         return "-";
1792.         //         break;
1793.         // }
1794.         return $this->getProbability() ?  $this->getProbability() . '%' : '-';
1795.     }
1797.     public function getNoPresentation(): ?bool
1798.     {
1799.         return $this->noPresentation;
1800.     }
1802.     public function setNoPresentation(bool $noPresentation): self
1803.     {
1804.         $this->noPresentation = $noPresentation;
1806.         return $this;
1807.     }
1809.     public function getPresentationDate(): ?\DateTimeInterface
1810.     {
1811.         return $this->presentationDate;
1812.     }
1814.     public function setPresentationDate(?\DateTimeInterface $presentationDate): self
1815.     {
1816.         $this->presentationDate = $presentationDate;
1818.         return $this;
1819.     }
1821.     /**
1822.      * @return Collection|ProjectClassification[]
1823.      */
1824.     public function getProjectTypes(): Collection
1825.     {
1826.         return $this->projectTypes;
1827.     }
1829.     public function addProjectType(ProjectClassification $projectType): self
1830.     {
1831.         if (!$this->projectTypes->contains($projectType)) {
1832.             $this->projectTypes[] = $projectType;
1833.         }
1835.         return $this;
1836.     }
1838.     public function removeProjectType(ProjectClassification $projectType): self
1839.     {
1840.         $this->projectTypes->removeElement($projectType);
1842.         return $this;
1843.     }
1845.     /**
1846.      * @return Collection|IndustryClassification[]
1847.      */
1848.     public function getProjectIndustries(): Collection
1849.     {
1850.         return $this->projectIndustries;
1851.     }
1853.     public function addProjectIndustry(IndustryClassification $projectIndustry): self
1854.     {
1855.         if (!$this->projectIndustries->contains($projectIndustry)) {
1856.             $this->projectIndustries[] = $projectIndustry;
1857.         }
1859.         return $this;
1860.     }
1862.     public function removeProjectIndustry(IndustryClassification $projectIndustry): self
1863.     {
1864.         $this->projectIndustries->removeElement($projectIndustry);
1866.         return $this;
1867.     }
1869.     public function removeAllProjectIndustries()
1870.     {
1871.         $this->projectIndustries->clear();
1872.     }
1874.     public function getProposalFollowUpDate(): ?\DateTimeInterface
1875.     {
1876.         return $this->proposalFollowUpDate;
1877.     }
1879.     public function setProposalFollowUpDate(?\DateTimeInterface $proposalFollowUpDate): self
1880.     {
1881.         $this->proposalFollowUpDate = $proposalFollowUpDate;
1883.         return $this;
1884.     }
1886.     public function getLeadStatus(): ?ProjectLeadStatus
1887.     {
1888.         return $this->leadStatus;
1889.     }
1891.     public function setLeadStatus(?ProjectLeadStatus $leadStatus): self
1892.     {
1893.         $this->leadStatus = $leadStatus;
1895.         return $this;
1896.     }
1898.     /**
1899.      * @return Collection|RevenuePlanning[]
1900.      */
1901.     public function getRevenuePlannings(): Collection
1902.     {
1903.         // return $this->revenuePlannings;
1904.         $revenuePlannings = $this->revenuePlannings->toArray();
1905.         usort($revenuePlannings, function ($a, $b) {
1906.             $aDate = $a->getYear() . $a->getMonth();
1907.             $bDate = $b->getYear() . $b->getMonth();
1908.             return $aDate <=> $bDate;
1909.         });
1910.         return new ArrayCollection($revenuePlannings);
1911.     }
1913.     /**
1914.      * Calculate and return the total revenue planning amount.
1915.      *
1916.      * @return float
1917.      */
1918.     public function getTotalRevenuePlanning(): float
1919.     {
1920.         $totalAmount = 0;
1921.         foreach ($this->revenuePlannings as $revenuePlanning) {
1922.             $totalAmount += $revenuePlanning->getAmount();
1923.         }
1924.         return $totalAmount;
1925.     }
1927.     /**
1928.      * Calculate and return the total revenue planning amount in USD.
1929.      *
1930.      * @return float
1931.      */
1932.     public function getTotalRevenuePlanningUsd(): float
1933.     {
1934.         global $kernel;
1935.         $currencyService = $kernel->getContainer()->get('CurrencyService');
1937.         $totalAmountUsd = 0;
1938.         foreach ($this->revenuePlannings as $revenuePlanning) {
1939.             // $totalAmountUsd += $revenuePlanning->getAmountUsd();
1940.             $totalAmountUsd += $currencyService->convertAtDate($this->createdAt, $this->currency->getIso(), 'USD', $revenuePlanning->getAmount());
1941.         }
1942.         return round($totalAmountUsd, 2, PHP_ROUND_HALF_EVEN);
1943.     }
1945.     public function getTotalRevenuePlanningDifference(): float
1946.     {
1947.         return abs($this->getTotalRevenuePlanning() - $this->getEstimatedProfit()) < 0.00001 ? 0 : $this->getTotalRevenuePlanning() - $this->getEstimatedProfit();
1948.     }
1950.     public function getTotalRevenuePlanningDifferenceUsd(): float
1951.     {
1952.         return abs($this->getTotalRevenuePlanningUsd() - $this->getEstimatedProfitUsd()) < 0.00001 ? 0 : $this->getTotalRevenuePlanningUsd() - $this->getEstimatedProfitUsd();
1953.     }
1955.     public function addRevenuePlanning(RevenuePlanning $revenuePlanning): self
1956.     {
1957.         if (!$this->revenuePlannings->contains($revenuePlanning)) {
1958.             $this->revenuePlannings[] = $revenuePlanning;
1959.             $revenuePlanning->setProject($this);
1960.         }
1962.         return $this;
1963.     }
1965.     public function removeRevenuePlanning(RevenuePlanning $revenuePlanning): self
1966.     {
1967.         if ($this->revenuePlannings->removeElement($revenuePlanning)) {
1968.             // set the owning side to null (unless already changed)
1969.             if ($revenuePlanning->getProject() === $this) {
1970.                 $revenuePlanning->setProject(null);
1971.             }
1972.         }
1974.         return $this;
1975.     }
1977.     public function getTotalVendorCost()
1978.     {
1979.         $total = 0;
1980.         $ratio = 1;
1981.         $projectSalesOrders = $this->getProjectSalesOrders();
1982.         foreach ($projectSalesOrders as $pso) {
1983.             $soInvoices = $pso->getSalesOrder()->getSalesOrderInvoices($this->id);
1984.             foreach ($soInvoices as $soInvoice) {
1985.                 if ($soInvoice->getInvoice()->getXeroStatus() == 'VOIDED') continue;
1986.                 // if($pso->getProject() == $this){
1987.                 //     $ratio = $useRatio ? $pso->getAmount() / $soInvoice->getSalesOrder()->getSubTotal() : 1;
1988.                 // }
1989.                 // $ratio = $useRatio ? $soInvoice->getAmount() / $soInvoice->getSalesOrder()->getSubTotal() : 1;
1990.                 $total += $soInvoice->getInvoice()->getVendorCost($this);
1991.             }
1992.         }
1993.         return $total;
1994.     }
1996.     public function getInvVendorCostByFinancialYear($year = null, $isAllocated = false)
1997.     {
1998.         $total = 0;
2000.         if ($year) {
2001.             $start = date('Y-m-d', strtotime('first day of November ' . ($year - 1)));
2002.             $end = date('Y-m-d', strtotime('last day of October ' . $year));
2003.         }
2005.         $vendorQuotationPlannings = $this->getVendorQuotationPlannings();
2006.         if($vendorQuotationPlannings){
2007.             foreach ($vendorQuotationPlannings as $vendorQuotationPlanning) {
2008.                 $vqpInvoices = $vendorQuotationPlanning->getVendorQuotationPlanningVendorInvoices();
2009.                 foreach ($vqpInvoices as $vqpInvoice) {
2010.                     $invoice = $vqpInvoice->getVendorInvoice();
2011.                     if ($vqpInvoice->getVendorInvoice()->getXeroStatus() != 'PAID') continue;
2012.                     $invoiceDate = $invoice->getInvoiceDate()->format('Y-m-d');
2014.                     if (!$year || ($invoiceDate >= $start && $invoiceDate <= $end)) {
2015.                         $total += $isAllocated ? $vqpInvoice->getAmount() : $invoice->getSubTotal();
2016.                     }
2017.                 }
2018.             }
2019.         }
2020.         /*
2021.         foreach ($projectSalesOrders as $pso) {
2022.             $soInvoices = $pso->getSalesOrder()->getSalesOrderInvoices($this->id);
2023.             foreach ($soInvoices as $soInvoice) {
2024.                 $invoice = $soInvoice->getInvoice();
2025.                 if ($invoice->getXeroStatus() == 'VOIDED') continue;
2027.                 $invoiceDate = $invoice->getInvoiceDate()->format('Y-m-d');
2029.                 if (!$year || ($invoiceDate >= $start && $invoiceDate <= $end)) {
2030.                     $total += $invoice->getSubTotal();
2031.                 }
2032.             }
2033.         }
2034.         */
2035.         return $total;
2036.     }
2039.     public function getInvoices()
2040.     {
2041.         $invoices = [];
2042.         $projectSalesOrders = $this->getProjectSalesOrders();
2043.         if ($projectSalesOrders) {
2044.             foreach ($projectSalesOrders as $pso) {
2045.                 $soInvoices = $pso->getSalesOrder()->getSalesOrderInvoices($this->id);
2046.                 foreach ($soInvoices as $soInvoice) {
2047.                     $invoice = $soInvoice->getInvoice();
2048.                     array_push($invoices, $invoice);
2049.                 }
2050.             }
2051.         }
2053.         return $invoices;
2054.     }
2056.     public function getTotalVendorCostUsd()
2057.     {
2058.         global $kernel;
2059.         $currencyService = $kernel->getContainer()->get('CurrencyService');
2061.         $total = 0;
2062.         $projectSalesOrders = $this->getProjectSalesOrders();
2063.         foreach ($projectSalesOrders as $pso) {
2064.             $soInvoices = $pso->getSalesOrder()->getSalesOrderInvoices($this->id);
2065.             foreach ($soInvoices as $soInvoice) {
2066.                 if ($soInvoice->getInvoice()->getXeroStatus() == 'VOIDED') continue;
2067.                 // $total += $soInvoice->getInvoice()->getVendorCostUsd($this);
2068.                 $total += $currencyService->convertAtDate($this->createdAt, $soInvoice->getInvoice()->getCurrency()->getIso(), 'USD', $soInvoice->getInvoice()->getVendorCost($this));
2069.             }
2070.         }
2071.         return round($total, 2, PHP_ROUND_HALF_EVEN);
2072.     }
2074.     public function getInvVendorCostByFinancialYearSgd($year = null, $isAllocated = false)
2075.     {
2076.         global $kernel;
2077.         $currencyService = $kernel->getContainer()->get('CurrencyService');
2079.         $total = 0;
2081.         if ($year) {
2082.             $start = date('Y-m-d', strtotime('first day of November ' . ($year - 1)));
2083.             $end = date('Y-m-d', strtotime('last day of October ' . $year));
2084.         }
2086.         // foreach ($projectSalesOrders as $pso) {
2087.         //     $soInvoices = $pso->getSalesOrder()->getSalesOrderInvoices($this->id);
2088.         //     foreach ($soInvoices as $soInvoice) {
2089.         //         $invoice = $soInvoice->getInvoice();
2090.         //         if ($invoice->getXeroStatus() == 'VOIDED') continue;
2092.         //         $invoiceDate = $invoice->getInvoiceDate()->format('Y-m-d');
2094.         //         if (!$year || ($invoiceDate >= $start && $invoiceDate <= $end)) {
2095.         //             $vendorCost = $invoice->getSubTotal();
2096.         //             $currencyIso = $invoice->getCurrency()->getIso();
2097.         //             $total += $currencyService->convertAtDate($this->createdAt, $currencyIso, 'SGD', $vendorCost);
2098.         //         }
2099.         //     }
2100.         // }
2102.         $vendorQuotationPlannings = $this->getVendorQuotationPlannings();
2103.         if($vendorQuotationPlannings){
2104.             foreach ($vendorQuotationPlannings as $vendorQuotationPlanning) {
2105.                 $vqpInvoices = $vendorQuotationPlanning->getVendorQuotationPlanningVendorInvoices();
2106.                 foreach ($vqpInvoices as $vqpInvoice) {
2107.                     $invoice = $vqpInvoice->getVendorInvoice();
2108.                     if ($vqpInvoice->getVendorInvoice()->getXeroStatus() != 'PAID') continue;
2109.                     $invoiceDate = $invoice->getInvoiceDate()->format('Y-m-d');
2111.                     if (!$year || ($invoiceDate >= $start && $invoiceDate <= $end)) {
2112.                         $vendorCost = $invoice->getSubTotal();
2113.                         if($isAllocated) $vendorCost = $vqpInvoice->getAmount();
2114.                         $currencyIso = $invoice->getCurrency()->getIso();
2115.                         $total += $currencyService->convertAtDate($this->createdAt, $currencyIso, 'SGD', $vendorCost);
2116.                     }
2117.                 }
2118.             }
2119.         }
2121.         return round($total, 2, PHP_ROUND_HALF_EVEN);
2122.     }
2125.     public function getTotalRevenue()
2126.     {
2127.         $total = 0;
2128.         $projectSalesOrders = $this->getProjectSalesOrders();
2129.         foreach ($projectSalesOrders as $pso) {
2130.             $soInvoices = $pso->getSalesOrder()->getSalesOrderInvoices($this->id);
2131.             foreach ($soInvoices as $soInvoice) {
2132.                 if ($soInvoice->getInvoice()->getXeroStatus() == 'VOIDED') continue;
2133.                 $total += $soInvoice->getInvoice()->getRevenue($this);
2134.             }
2135.         }
2136.         return $total;
2137.     }
2139.     public function getInvRevenueByFinancialYear($year = null)
2140.     {
2141.         $total = 0;
2142.         $start = $end = null;
2144.         if ($year) {
2145.             $start = date('Y-m-d', strtotime('first day of November ' . ($year - 1)));
2146.             $end = date('Y-m-d', strtotime('last day of October ' . $year));
2147.         }
2149.         foreach ($this->getProjectSalesOrders() as $pso) {
2150.             foreach ($pso->getSalesOrder()->getSalesOrderInvoices($this->id) as $soInvoice) {
2151.                 $invoice = $soInvoice->getInvoice();
2152.                 if ($invoice->getXeroStatus() == 'VOIDED') continue;
2154.                 $invoiceDate = $invoice->getInvoiceDate()->format('Y-m-d');
2155.                 if (!$year || ($invoiceDate >= $start && $invoiceDate <= $end)) {
2156.                     $total += $soInvoice->getAmount();
2157.                     // $total += $invoice->getSubTotal();
2158.                 }
2159.             }
2160.         }
2162.         return $total;
2163.     }
2166.     public function getInvRevenueByFinancialYearSgd($year = null, $isAllocated = false)
2167.     {
2168.         global $kernel;
2169.         $currencyService = $kernel->getContainer()->get('CurrencyService');
2171.         $total = 0;
2172.         $projectSalesOrders = $this->getProjectSalesOrders();
2174.         // Determine the start and end dates if a year is provided  
2175.         if ($year) {
2176.             $start = date('Y-m-d', strtotime('first day of November ' . ($year - 1)));
2177.             $end = date('Y-m-d', strtotime('last day of October ' . $year));
2178.         }
2180.         foreach ($projectSalesOrders as $pso) {
2181.             $soInvoices = $pso->getSalesOrder()->getSalesOrderInvoices($this->id);
2182.             foreach ($soInvoices as $soInvoice) {
2183.                 $invoice = $soInvoice->getInvoice();
2184.                 if ($invoice->getXeroStatus() == 'VOIDED') continue;
2186.                 $invoiceDate = $invoice->getInvoiceDate()->format('Y-m-d');
2187.                 if (!$year || ($invoiceDate >= $start && $invoiceDate <= $end)) {
2188.                     $revenue = $invoice->getSubTotal();
2189.                     if($isAllocated) $revenue = $soInvoice->getAmount();
2190.                     $currencyIso = $invoice->getCurrency()->getIso();
2191.                     $total += $currencyService->convertAtDate($this->createdAt, $currencyIso, 'SGD', $revenue);
2192.                 }
2193.             }
2194.         }
2196.         return round($total, 2, PHP_ROUND_HALF_EVEN);
2197.     }
2200.     public function getTotalRevenueUsd()
2201.     {
2202.         global $kernel;
2203.         $currencyService = $kernel->getContainer()->get('CurrencyService');
2205.         $total = 0;
2206.         $projectSalesOrders = $this->getProjectSalesOrders();
2208.         foreach ($projectSalesOrders as $pso) {
2209.             $soInvoices = $pso->getSalesOrder()->getSalesOrderInvoices($this->id);
2210.             foreach ($soInvoices as $soInvoice) {
2211.                 if ($soInvoice->getInvoice()->getXeroStatus() == 'VOIDED') continue;
2212.                 // $total += $soInvoice->getInvoice()->getRevenueUsd($this);
2213.                 $total += $currencyService->convertAtDate($this->createdAt, $soInvoice->getInvoice()->getCurrency()->getIso(), 'USD', $soInvoice->getInvoice()->getRevenue($this));
2214.             }
2215.         }
2216.         return round($total, 2, PHP_ROUND_HALF_EVEN);
2217.     }
2219.     public function getAllocatedCreditNotesTotal($status = null): ?float
2220.     {
2222.         $total = 0;
2223.         $projectSalesOrders = $this->getProjectSalesOrders();
2224.         foreach ($projectSalesOrders as $pso) {
2225.             $soInvoices = $pso->getSalesOrder()->getSalesOrderInvoices();
2226.             foreach ($soInvoices as $soInvoice) {
2227.                 if ($soInvoice->getProject() !== $this) continue;
2228.                 if ($status != null && $soInvoice->getInvoice()->getXeroStatus() != $status || !$soInvoice->getInvoice()->getXeroCreditNoteAllocation()) continue;
2229.                 $total += $soInvoice->getInvoice()->getAllocatedCreditNote($this);
2230.             }
2231.         }
2232.         return $total;
2233.     }
2235.     public function getAllocatedCreditNotesTotalUsd($status = null): ?float
2236.     {
2237.         $total = 0;
2238.         $projectSalesOrders = $this->getProjectSalesOrders();
2239.         foreach ($projectSalesOrders as $pso) {
2240.             $soInvoices = $pso->getSalesOrder()->getSalesOrderInvoices();
2241.             foreach ($soInvoices as $soInvoice) {
2242.                 if ($soInvoice->getProject() !== $this) continue;
2243.                 if ($status != null && $soInvoice->getInvoice()->getXeroStatus() != $status || !$soInvoice->getInvoice()->getXeroCreditNoteAllocation()) continue;
2245.                 $total += $soInvoice->getInvoice()->getAllocatedCreditNoteUsd($this);
2246.             }
2247.         }
2248.         return round($total, 2, PHP_ROUND_HALF_EVEN);
2249.     }
2251.     public function getLeadLostReason($withNote = true)
2252.     {
2253.         $text = '';
2255.         if ($this->projectLostFilter) {
2256.             $mainReason = $this->projectLostFilter->getMainReason() ? $this->projectLostFilter->getMainReason()->getTitle() : null;
2257.             $subReason = $this->projectLostFilter->getSubReason() ? $this->projectLostFilter->getSubReason()->getTitle() : null;
2258.             $subReason = $subReason ? ' - ' . $subReason : null;
2259.             $text = $mainReason . $subReason;
2260.         } else {
2261.             if ($this->leadFail) {
2262.                 $reasonTitle = $this->leadFail ? $this->leadFail->getTitle() : null;
2263.                 $text = $reasonTitle;
2264.             }
2265.         }
2267.         if ($withNote && $this->leadFailNote) $text = $text . ': ' . $this->leadFailNote;
2269.         return $text;
2270.     }
2272.     public function getLeadFail(): ?ProjectLostReason
2273.     {
2274.         return $this->leadFail;
2275.     }
2277.     public function setLeadFail(?ProjectLostReason $leadFail): self
2278.     {
2279.         $this->leadFail = $leadFail;
2281.         return $this;
2282.     }
2284.     public function getProjectDeliverable(): ?ProjectDeliverable
2285.     {
2286.         return $this->projectDeliverable;
2287.     }
2289.     public function checkProjectDeliverable()
2290.     {
2292.         if (!empty($this->projectDeliverable)) {
2293.             if (
2294.                 !empty($this->projectDeliverable->getThumbnails()) ||
2295.                 !empty($this->projectDeliverable->getProjectDeliverableFiles()->toArray())
2296.             ) {
2297.                 return true;
2298.             }
2299.         }
2300.         return false;
2301.     }
2303.     public function setProjectDeliverable(?ProjectDeliverable $projectDeliverable): self
2304.     {
2305.         // unset the owning side of the relation if necessary
2306.         if ($projectDeliverable === null && $this->projectDeliverable !== null) {
2307.             $this->projectDeliverable->setProject(null);
2308.         }
2310.         // set the owning side of the relation if necessary
2311.         if ($projectDeliverable !== null && $projectDeliverable->getProject() !== $this) {
2312.             $projectDeliverable->setProject($this);
2313.         }
2315.         $this->projectDeliverable = $projectDeliverable;
2317.         return $this;
2318.     }
2320.     public function getFeedbackScore()
2321.     {
2322.         $scoreCount = 0;
2323.         $feedbackCount = 0;
2324.         $total = 0;
2325.         foreach ($this->clientFeedback as $feedback) {
2326.             // if($feedback->getClientFeedbackForm()->getClientFeedbackTemplate() == $this->clientFeedbackTemplate ){
2327.             if ($feedback->getRating() && $feedback->getDeletedAt() == NULL) {
2328.                 $scoreCount += $feedback->getRating() ?: 0;
2329.                 $feedbackCount++;
2330.             }
2331.             // }
2332.         }
2333.         if ($feedbackCount > 0) {
2334.             $total = number_format($scoreCount / $feedbackCount, 1);
2335.         }
2336.         return $total;
2337.     }
2339.     /**
2340.      * @return Collection<int, ClientFeedback>
2341.      */
2342.     public function getClientFeedback(): Collection
2343.     {
2344.         return $this->clientFeedback;
2345.     }
2347.     public function getActiveClientFeedback($feedbackTemplate = null)
2348.     {
2349.         $clientFeedbacks = [];
2350.         foreach ($this->clientFeedback as $clientFeedback) {
2351.             if (!$clientFeedback->isDeleted()) {
2352.                 if ($feedbackTemplate === null || $clientFeedback->getFeedbackTemplate() === $feedbackTemplate) {
2353.                     $clientFeedbacks[] = $clientFeedback;
2354.                 }
2355.                 // $clientFeedbacks[] = $clientFeedback;
2356.             }
2357.         }
2358.         usort($clientFeedbacks, function ($a, $b) {
2359.             return $a->getCustomOrder() - $b->getCustomOrder();
2360.         });
2362.         return $clientFeedbacks;
2363.     }
2365.     public function addClientFeedback(ClientFeedback $clientFeedback): self
2366.     {
2367.         if (!$this->clientFeedback->contains($clientFeedback)) {
2368.             $this->clientFeedback->add($clientFeedback);
2369.             $clientFeedback->setProject($this);
2370.         }
2372.         return $this;
2373.     }
2375.     public function removeClientFeedback(ClientFeedback $clientFeedback): self
2376.     {
2377.         if ($this->clientFeedback->removeElement($clientFeedback)) {
2378.             // set the owning side to null (unless already changed)
2379.             if ($clientFeedback->getProject() === $this) {
2380.                 $clientFeedback->setProject(null);
2381.             }
2382.         }
2384.         return $this;
2385.     }
2387.     public function getFilledOutClientFeedback()
2388.     {
2389.         $filledOutBy = [];
2390.         foreach ($this->clientFeedback as $clientfeedback) {
2391.             $clientContactId = $clientfeedback->getFilledBy();
2392.             $clientContact = $this->client->getClientContact($clientContactId);
2393.             if ($clientContact) {
2394.                 if (!in_array($clientContact->getName(), $filledOutBy)) {
2395.                     $filledOutBy[] = $clientContact->getName();
2396.                 }
2397.             }
2398.         }
2400.         return $filledOutBy;
2401.     }
2403.     /*
2404.     public function getClientFeedbackTemplate(): ?ClientFeedbackTemplate
2405.     {
2406.         return $this->clientFeedbackTemplate;
2407.     }
2408.     */
2410.     /*
2411.     public function checkFilledFeedbackTemplate(){
2412.         
2413.         
2414.         if($this->clientFeedbackTemplate){
2415.             foreach($this->clientFeedbackTemplate->getClientFeedbackForms() as $feedbackForm) {
2416.                 // if(!$feedbackForm->getDeletedAt() && count($feedbackForm->getClientFeedbackByProjects($this->id)->toArray()) > 0){
2417.                 if(!$feedbackForm->getDeletedAt() && count($feedbackForm->getClientFeedbackByProjects($this->id)->toArray()) > 0){
2418.                     return true;
2419.                 }elseif($feedbackForm->getDeletedAt() && count($feedbackForm->getClientFeedbackByProjects($this->id)->toArray()) > 0){
2420.                     return true;
2421.                 }
2422.             }
2423.         }
2425.         if($this->clientFeedback){
2426.             foreach($this->clientFeedback as $feedback) {
2427.                 if(!$feedback->isDeleted() && !$feedback->isEmpty()){
2428.                     return true;
2429.                 }
2430.             }
2431.         }
2433.         return false;
2434.     }
2435.     */
2437.     public function isAllFeedbackText()
2438.     {
2440.         $activeFeedbacks = [];
2441.         $result = true;
2443.         if ($this->clientFeedback) {
2444.             foreach ($this->clientFeedback as $feedback) {
2445.                 if (!$feedback->isDeleted()) {
2446.                     $activeFeedbacks[] = $feedback;
2447.                 }
2448.             }
2449.         }
2451.         if ($activeFeedbacks) {
2452.             foreach ($activeFeedbacks as $feedback) {
2453.                 if ($feedback->getFeedbackType() != 'short_text') {
2454.                     return false;
2455.                 }
2456.             }
2457.         } else {
2458.             return false;
2459.         }
2461.         return $result;
2462.     }
2464.     public function checkFilledFeedbackTemplate()
2465.     {
2467.         $activeFeedbacks = [];
2469.         if ($this->clientFeedback) {
2470.             foreach ($this->clientFeedback as $feedback) {
2471.                 if (!$feedback->isDeleted()) {
2472.                     $activeFeedbacks[] = $feedback;
2473.                 }
2474.             }
2475.         }
2477.         if ($activeFeedbacks) {
2478.             $allFilled = true;
2479.             $anyFilled = false;
2481.             foreach ($activeFeedbacks as $feedback) {
2482.                 if ($feedback->isEmpty()) {
2483.                     $allFilled = false;
2484.                 } else {
2485.                     $anyFilled = true;
2486.                 }
2487.             }
2489.             if ($allFilled == true && $anyFilled == true) {
2490.                 return 'all';
2491.             } elseif ($anyFilled) {
2492.                 return true;
2493.             }
2494.         }
2496.         return false;
2497.     }
2500.     public function isFeedbackDone($returnArray = false)
2501.     {
2502.         $totalFeedback = 0;
2503.         $missingFeedback = 0;
2504.         if ($this->clientFeedbackTemplate) {
2505.             foreach ($this->clientFeedback as $feedback) {
2506.                 if (!$feedback->getDeletedAt()) {
2507.                     $totalFeedback++;
2508.                     if (!$feedback->getComment() && !$feedback->getRating()) {
2509.                         $missingFeedback++;
2510.                         if (!$returnArray) return false;
2511.                     }
2512.                 }
2513.             }
2514.         }
2515.         if (!$returnArray) {
2516.             return true;
2517.         } else {
2518.             return ['total' => $totalFeedback, 'filled' => $totalFeedback - $missingFeedback, 'missing' => $missingFeedback, 'done' => $missingFeedback == 0];
2519.         }
2520.     }
2522.     public function getClientFeedbackTemplate(): ?ClientFeedbackTemplate
2523.     {
2524.         if ($this->clientFeedbackTemplate !== null && $this->clientFeedbackTemplate->getDeletedAt() === null) {
2525.             return $this->clientFeedbackTemplate;
2526.         }
2528.         return null;
2529.     }
2531.     public function setClientFeedbackTemplate(?ClientFeedbackTemplate $clientFeedbackTemplate): self
2532.     {
2533.         $this->clientFeedbackTemplate = $clientFeedbackTemplate;
2535.         return $this;
2536.     }
2538.     public function getScore(): ?float
2539.     {
2540.         return $this->score;
2541.     }
2543.     public function setScore(?float $score): self
2544.     {
2545.         $this->score = $score;
2547.         return $this;
2548.     }
2550.     public function getEmailLogFeedback($toAddress, $title)
2551.     {
2552.         global $kernel;
2553.         $projectService = $kernel->getContainer()->get('ProjectService');
2554.         $result = $projectService->getEmailLogFeedback($toAddress, $title);
2555.         return $result;
2556.     }
2558.     public function getProjectLostFilter(): ?ProjectLostFilter
2559.     {
2560.         return $this->projectLostFilter;
2561.     }
2563.     public function setProjectLostFilter(?ProjectLostFilter $projectLostFilter): self
2564.     {
2565.         // unset the owning side of the relation if necessary
2566.         if ($projectLostFilter === null && $this->projectLostFilter !== null) {
2567.             $this->projectLostFilter->setProject(null);
2568.         }
2570.         // set the owning side of the relation if necessary
2571.         if ($projectLostFilter !== null && $projectLostFilter->getProject() !== $this) {
2572.             $projectLostFilter->setProject($this);
2573.         }
2575.         $this->projectLostFilter = $projectLostFilter;
2576.         return $this;
2577.     }
2579.     /**
2580.      * @return Collection<int, ExpenseRequest>
2581.      */
2582.     public function getExpenseRequests(): Collection
2583.     {
2584.         return $this->expenseRequests;
2585.     }
2587.     public function addExpenseRequest(ExpenseRequest $expenseRequest): self
2588.     {
2589.         if (!$this->expenseRequests->contains($expenseRequest)) {
2590.             $this->expenseRequests->add($expenseRequest);
2591.             $expenseRequest->setProject($this);
2592.         }
2594.         return $this;
2595.     }
2597.     /* 
2598.      * @return Collection<int, Checklist>
2599.      */
2600.     public function getChecklists(): Collection
2601.     {
2602.         return $this->checklists;
2603.     }
2605.     public function getChecklistById(int $id): ?Checklist
2606.     {
2607.         foreach ($this->checklists as $checklist) {
2608.             if ($checklist->getId() === $id) {
2609.                 return $checklist;
2610.             }
2611.         }
2613.         return null;
2614.     }
2616.     public function addChecklist(Checklist $checklist): self
2617.     {
2618.         if (!$this->checklists->contains($checklist)) {
2619.             $this->checklists->add($checklist);
2620.             $checklist->setProject($this);
2621.         }
2623.         return $this;
2624.     }
2626.     public function removeExpenseRequest(ExpenseRequest $expenseRequest): self
2627.     {
2628.         if ($this->expenseRequests->removeElement($expenseRequest)) {
2629.             // set the owning side to null (unless already changed)
2630.             if ($expenseRequest->getProject() === $this) {
2631.                 $expenseRequest->setProject(null);
2632.             }
2634.             return $this;
2635.         }
2636.     }
2638.     public function removeChecklist(Checklist $checklist): self
2639.     {
2640.         if ($this->checklists->removeElement($checklist)) {
2641.             // set the owning side to null (unless already changed)
2642.             if ($checklist->getProject() === $this) {
2643.                 $checklist->setProject(null);
2644.             }
2645.         }
2647.         return $this;
2648.     }
2650.     public function getBrief(): ?string
2651.     {
2652.         return $this->brief;
2653.     }
2655.     public function setBrief(?string $brief): self
2656.     {
2657.         $this->brief = $brief;
2659.         return $this;
2660.     }
2662.     public function getMattermost(): ?string
2663.     {
2664.         return $this->mattermost;
2665.     }
2667.     public function setMattermost(?string $mattermost): self
2668.     {
2669.         $this->mattermost = $mattermost;
2671.         return $this;
2672.     }
2674.     public function getMattermostName(): ?string
2675.     {
2676.         $group = explode('/', $this->mattermost);
2677.         $name = end($group);
2678.         $parts = explode('_', $name);
2679.         $lastPart = end($parts);
2680.         if (ctype_digit($lastPart) && (strlen($lastPart) === 10 || strlen($lastPart) === 13)) {
2681.             array_pop($parts);
2682.         }
2683.         $name = implode(' ', $parts);
2684.         return ucwords($name);
2685.     }
2687.     /**
2688.      * @return Collection<int, ProjectDynamicField>
2689.      */
2690.     public function getProjectDynamicFields(): Collection
2691.     {
2692.         return $this->projectDynamicFields;
2693.     }
2695.     public function addProjectDynamicField(ProjectDynamicField $projectDynamicField): self
2696.     {
2697.         if (!$this->projectDynamicFields->contains($projectDynamicField)) {
2698.             $this->projectDynamicFields->add($projectDynamicField);
2699.             $projectDynamicField->setProject($this);
2700.         }
2702.         return $this;
2703.     }
2705.     public function removeProjectDynamicField(ProjectDynamicField $projectDynamicField): self
2706.     {
2707.         if ($this->projectDynamicFields->removeElement($projectDynamicField)) {
2708.             // set the owning side to null (unless already changed)
2709.             if ($projectDynamicField->getProject() === $this) {
2710.                 $projectDynamicField->setProject(null);
2711.             }
2712.         }
2714.         return $this;
2715.     }
2717.     public function getProjectHosting(): ?ProjectHosting
2718.     {
2719.         return $this->projectHosting;
2720.     }
2722.     public function setProjectHosting(?ProjectHosting $projectHosting): self
2723.     {
2724.         // unset the owning side of the relation if necessary
2725.         if ($projectHosting === null && $this->projectHosting !== null) {
2726.             $this->projectHosting->setProject(null);
2727.         }
2729.         // set the owning side of the relation if necessary
2730.         if ($projectHosting !== null && $projectHosting->getProject() !== $this) {
2731.             $projectHosting->setProject($this);
2732.         }
2734.         $this->projectHosting = $projectHosting;
2736.         return $this;
2737.     }
2738. }