src/Controller/IndexController.php line 21

Open in your IDE?
  1. <?php
  3. namespace FMS\eLibreria\CmsBundle\Controller;
  5. use FMS\eLibreria\CoreBundle\Model\Entity\Buy;
  6. use FMS\eLibreria\CoreBundle\Model\Entity\StatisticData;
  7. use FMS\eLibreria\CoreBundle\Model\Object\DateRange;
  8. use FMS\eLibreria\CoreBundle\Model\Repository\BuyRepository;
  10. class IndexController extends CmsController {
  12. const INDEX_KEY_STATISTICS_DATA = "statistics_data";
  13. const INDEX_KEY_BUYS_RETURN_ON_STATISTICS = "buys_return_on_statistics";
  14. const INDEX_KEY_LAST_3_MONTHS_STATISTICS_DATA = "last_3_months_statistics_data";
  15. const INDEX_KEY_MONTH = "month";
  16. const INDEX_KEY_ANNUAL = "annual";
  17. const INDEX_KEY_DATA = "data";
  18. const INDEX_KEY_BY_PROVIDERS = "by_providers";
  19. const INDEX_KEY_TOTAL = "total";
  21. public function index(){
  22. $options = $this->getBasicOptions();
  24. $statisticsService = $this->getStatistics();
  26. //Estadisticas
  27. $statisticsDataMonth = $statisticsService->getStatisticsMonth();
  28. $statisticsDataAnnual = new StatisticData();
  30. $billed = 0.0;
  31. $costProviders = 0.0;
  32. $costItemsAdquired = 0.0;
  33. $costPromos = 0.0;
  34. $taxes = 0.0;
  35. $totalCost = 0.0;
  36. $profit = 0.0;
  38. /** @var StatisticData $statisticDataAn */
  39. foreach($statisticsService->getStatisticsAnnual() as $statisticDataAn){
  40. $billed += $statisticDataAn->getBilled();
  41. $costProviders += $statisticDataAn->getCostProviders();
  42. $costItemsAdquired += $statisticDataAn->getCostItemsAdquired();
  43. $costPromos += $statisticDataAn->getCostPromos();
  44. $taxes += $statisticDataAn->getTaxes();
  45. $totalCost += $statisticDataAn->getTotalCost();
  46. $profit += $statisticDataAn->getProfit();
  47. }
  49. $statisticsDataAnnual->setBilled($billed);
  50. $statisticsDataAnnual->setCostProviders($costProviders);
  51. $statisticsDataAnnual->setCostItemsAdquired($costItemsAdquired);
  52. $statisticsDataAnnual->setCostPromos($costPromos);
  53. $statisticsDataAnnual->setTaxes($taxes);
  54. $statisticsDataAnnual->setTotalCost($totalCost);
  55. $statisticsDataAnnual->setProfit($profit);
  57. $now = new \DateTime();
  58. $start = \DateTime::createFromFormat("d/m/Y H:i:s", sprintf("1/%s 00:00:00", $now->format("m/Y")));
  59. $end = \DateTime::createFromFormat("d/m/Y H:i:s", sprintf("%s 23:59:59", $now->format("t/m/Y")));
  60. $monthRange = new DateRange($start, $end);
  62. //Devoluciones del mes
  63. /** @var BuyRepository $buyRepository */
  64. $buyRepository = $this->getEntityManager()->getRepository(Buy::class);
  65. $buysToReturnThisMonth = $buyRepository->findBuysReturnOnRange($monthRange);
  67. $byProviders = array();
  68. /** @var Buy $buy */
  69. foreach($buysToReturnThisMonth as $buy){
  70. $provider = $buy->getProvider();
  71. // A purchase without a contract is counted under «Sin contrato», never a 500 (change merch-09; M-88).
  72. $hashProvider = null === $provider ? "" : $provider->getHash();
  74. $providerData = array(
  75. self::INDEX_KEY_DATA => $provider ?? array("nameStoreLegal" => $this->getTranslator()->trans("buys.without_contract", array(), "cms")),
  76. self::INDEX_KEY_TOTAL => 0,
  77. );
  79. if(array_key_exists($hashProvider, $byProviders)){
  80. $providerData = $byProviders[$hashProvider];
  81. }
  83. $providerData[self::INDEX_KEY_TOTAL]++;
  85. $byProviders[$hashProvider] = $providerData;
  86. }
  88. $statisticsData = array(
  89. self::INDEX_KEY_MONTH => $statisticsDataMonth,
  90. self::INDEX_KEY_ANNUAL => $statisticsDataAnnual,
  91. );
  93. //Link al listado de albaranes filtrado:
  95. $filters = array(
  96. "returnOn" => $now->format("m/Y")
  97. );
  99. $filter = $this->getFilters()->registerFilter($filters);
  100. $linkToBuys = $this->generateUrl("cms_utools_store_buys_index",
  101. array(
  102. self::QUERY_KEY_FILTERS => $filter->getHash()
  103. ));
  105. $buysToReturnStatistics = array(
  106. self::INDEX_KEY_BY_PROVIDERS => $byProviders,
  107. self::INDEX_KEY_TOTAL => count($buysToReturnThisMonth),
  108. "link" => $linkToBuys,
  109. );
  111. //Evolución últimos 3 meses
  113. $day3MonthsAgo = (clone $now)->sub(new \DateInterval("P3M"));
  114. $start3Months = \DateTime::createFromFormat("d/m/Y H:i:s", sprintf("1/%s 00:00:00", $day3MonthsAgo->format("m/Y")));
  116. $last3Months = new DateRange($start3Months,$end);
  117. $histoLast3Months = $statisticsService->getStatisticsOnRange($last3Months);
  119. $options[self::INDEX_KEY_STATISTICS_DATA] = $statisticsData;
  120. $options[self::INDEX_KEY_BUYS_RETURN_ON_STATISTICS] = $buysToReturnStatistics;
  121. $options[self::INDEX_KEY_LAST_3_MONTHS_STATISTICS_DATA] = $histoLast3Months;
  123. return $this->render("index\index.html.twig", $options);
  124. }
  126. }