src/Entity/ReportPageStatistic.php line 18

Open in your IDE?
  1. <?php
  3. namespace App\Entity;
  5. use App\Service\StatisticsDataAggregation;
  6. use App\Service\WorldMap;
  7. use App\Twig\FlagExtension;
  8. use Doctrine\Common\Collections\ArrayCollection;
  9. use Doctrine\Common\Collections\Collection;
  10. use Doctrine\Common\Collections\Criteria;
  11. use Doctrine\ORM\Mapping as ORM;
  12. use Gedmo\Timestampable\Traits\TimestampableEntity;
  14. /**
  15.  * @ORM\Entity(repositoryClass="App\Repository\ReportPageStatisticRepository")
  16.  * @ORM\Table(name="`report_page_statistic`")
  17.  */
  18. class ReportPageStatistic
  19. {
  20.     use TimestampableEntity;
  22.     /**
  23.      * @ORM\Id
  24.      * @ORM\GeneratedValue
  25.      * @ORM\Column(type="integer")
  26.      */
  27.     private ?int $id = null;
  29.     /**
  30.      * @ORM\ManyToOne(targetEntity="App\Entity\Report", inversedBy="pageStatistics")
  31.      * @ORM\JoinColumn(name="report_id", referencedColumnName="id")
  32.      */
  33.     private Report $report;
  35.     /**
  36.      * @ORM\ManyToOne(targetEntity="App\Entity\ReportSnapshot", inversedBy="pageStatistics")
  37.      * @ORM\JoinColumn(name="report_snapshot_id", referencedColumnName="id")
  38.      */
  39.     private ?ReportSnapshot $snapshot = null;
  41.     /**
  42.      * @ORM\Column(type="text")
  43.      */
  44.     private ?string $url;
  46.     /**
  47.      * @ORM\Column(type="float")
  48.      */
  49.     private ?float $kWh;
  51.     /**
  52.      * @ORM\Column(type="float")
  53.      */
  54.     private ?float $tCO2;
  56.     /**
  57.      * @ORM\OneToMany(targetEntity="App\Entity\ReportPageCountryStatistic", mappedBy="pageStatistic", cascade={"persist", "remove"}, orphanRemoval=true)
  58.      */
  59.     private ?Collection $countryStatistics;
  61.     public function __construct()
  62.     {
  63.         $this->countryStatistics = new ArrayCollection();
  64.     }
  66.     public function getId(): ?int
  67.     {
  68.         return $this->id;
  69.     }
  71.     public function getReport(): Report
  72.     {
  73.         return $this->report;
  74.     }
  76.     public function setReport(Report $report): void
  77.     {
  78.         $this->report = $report;
  79.     }
  81.     public function getSnapshot(): ?ReportSnapshot
  82.     {
  83.         return $this->snapshot;
  84.     }
  86.     public function setSnapshot(?ReportSnapshot $snapshot): void
  87.     {
  88.         $this->snapshot = $snapshot;
  89.     }
  91.     public function getUrl(): ?string
  92.     {
  93.         return $this->url;
  94.     }
  96.     public function setUrl(?string $url): void
  97.     {
  98.         $this->url = $url;
  99.     }
  101.     public function getKWh(): ?float
  102.     {
  103.         return $this->kWh;
  104.     }
  106.     public function setKWh(?float $kWh): void
  107.     {
  108.         $this->kWh = $kWh;
  109.     }
  111.     public function getTCO2(): ?float
  112.     {
  113.         return $this->tCO2;
  114.     }
  116.     public function setTCO2(?float $tCO2): void
  117.     {
  118.         $this->tCO2 = $tCO2;
  119.     }
  121.     public function getCountryStatistics(string $field = 'tCO2', string $criteria = Criteria::DESC): ?Collection
  122.     {
  123.         $criteria = Criteria::create()
  124.             ->orderBy(
  125.                 [
  126.                     $field => $criteria,
  127.                 ]
  128.             );
  130.         return $this->countryStatistics->matching($criteria);
  131.     }
  133.     public function setCountryStatistics(?Collection $countryStatistics): void
  134.     {
  135.         $this->countryStatistics = $countryStatistics;
  136.     }
  138.     public function getData(): array
  139.     {
  140.         $totalEmissionsByNations['tCO2'] = [];
  141.         $totalEmissionsByNations['kWh'] = [];
  143.         foreach ($this->getCountryStatistics() as $statistic) {
  144.             $totalEmissionsByNations['tCO2'][FlagExtension::getFlagNameAlpha3($statistic->getCode())] = $statistic->getTCO2();
  145.         }
  146.         foreach ($this->getCountryStatistics('kWh') as $statistic) {
  147.             $totalEmissionsByNations['kWh'][FlagExtension::getFlagNameAlpha3($statistic->getCode())] = $statistic->getkWh();
  148.         }
  150.         $groupedTotalEmissions = WorldMap::mergeTotalEmissions(
  151.             $totalEmissionsByNations['tCO2'],
  152.             $totalEmissionsByNations['kWh'],
  153.         );
  155.         return [
  156.             'totals' => $groupedTotalEmissions,
  157.             'tCO2' => StatisticsDataAggregation::compact($totalEmissionsByNations['tCO2']),
  158.             'kWh' => StatisticsDataAggregation::compact($totalEmissionsByNations['kWh']),
  159.         ];
  160.     }
  161. }