1. <?php
3. namespace App\Controller;
5. use App\Entity\Aging;
6. use App\Entity\Hotel;
7. use App\Entity\Search;
8. use App\Entity\User;
9. use App\Form\FilterType;
10. use App\Repository\AgingRepository;
11. use App\Repository\FullStatsticAgenComRepository;
12. use App\Repository\HistoryForcastRepository;
13. use App\Repository\ManagerReportDataRepository;
14. use App\Repository\MarketStatisticsRepository;
15. use App\Repository\PMAccountByRoomRepository;
16. use App\Repository\TransactionCodesGrossRepository;
17. use App\Repository\ZeroRateRoomsRepository;
18. use Knp\Component\Pager\PaginatorInterface;
19. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
20. use Symfony\Component\HttpFoundation\Request;
21. use Symfony\Component\HttpFoundation\Response;
22. use Symfony\Component\Routing\Annotation\Route;
24. class HomeController extends AbstractController
25. {
26.     #[Route('/', name: 'app_home')]
27.     public function index(): Response
28.     {
29.         return $this->render('home/index.html.twig', [
30.         ]);
31.     }
33.     #[Route('/analytics', name: 'app_analytics', methods: ['GET', 'POST'])]
34.     public function analytics(Request $request, ManagerReportDataRepository $managerReportDataRepository): Response
35.     {
36.         $currentDate = new \DateTime('-1 day');
37.         $search = (new Search())
38.             ->setDays($currentDate->format('d'))
39.             ->setMonths($currentDate->format('m'))
40.             ->setYears($currentDate->format('Y'));
41.         $form = $this->createForm(FilterType::class, $search);
42.         $form->handleRequest($request);
45.         $mHotel = null;
46.         $mMonth = $currentDate->format('m');
47.         $mDay = $currentDate->format('d');
48.         $mYear = $currentDate->format('Y');
49.         if ($form->isSubmitted() && $form->isValid()) {
50.             $mHotel = $search->getHotels();
51.             $mMonth = $search->getMonths();
52.             $mDay = $search->getDays();
53.             $mYear = $search->getYears();
54.         }
56.         $mrByDay = $managerReportDataRepository->findMRBy([
57.             'TOTAL_REVENUE',
58.             'GUEST_IN_HOUSE',
59.             'ROOM_REVENUE',
60.             'PHYSICAL_ROOMS',
61.             'OCC_PERC_WO_CHO',
62.             'OCC_ROOMS',
63.             'COMP_ROOMS',
64.             'HOUSE_USE_ROOMS',
65.             'FIT_MEM_DEP_ROOMS',
66.             'ADULTS_IN_HOUSE',
67.             'CHILDREN_IN_HOUSE',
68.             'TOTAL_REVENUE_GUEST',
69.         ], 'DAY', $mHotel, $mDay, $mMonth, $mYear);
70.         $mrByDay = array_reduce($mrByDay, function ($h, $data) {
71.             $h[$data['SUB_GRP_1']][] = $data['SUM_AMOUNT'];
72.             return $h;
73.         }, []);
76.         $mrByMonth = $managerReportDataRepository->findMRBy([
77.             'TOTAL_REVENUE',
78.             'GUEST_IN_HOUSE',
79.             'ROOM_REVENUE',
80.             'PHYSICAL_ROOMS',
81.             'OCC_PERC_WO_CHO',
82.             'OCC_ROOMS',
83.             'COMP_ROOMS',
84.             'HOUSE_USE_ROOMS',
85.             'FIT_MEM_DEP_ROOMS',
86.             'ADULTS_IN_HOUSE',
87.             'CHILDREN_IN_HOUSE',
88.             'TOTAL_REVENUE_GUEST',
89.         ], 'MONTH', $mHotel, $mDay, $mMonth, $mYear);
90.         $mrByMonth = array_reduce($mrByMonth, function ($h, $data) {
91.             $h[$data['SUB_GRP_1']][] = $data['SUM_AMOUNT'];
92.             return $h;
93.         }, []);
95.         $mrByYear = $managerReportDataRepository->findMRBy([
96.             'TOTAL_REVENUE',
97.             'GUEST_IN_HOUSE',
98.             'ROOM_REVENUE',
99.             'PHYSICAL_ROOMS',
100.             'OCC_PERC_WO_CHO',
101.             'OCC_ROOMS',
102.             'COMP_ROOMS',
103.             'HOUSE_USE_ROOMS',
104.             'FIT_MEM_DEP_ROOMS',
105.             'ADULTS_IN_HOUSE',
106.             'CHILDREN_IN_HOUSE',
107.             'TOTAL_REVENUE_GUEST',
108.         ], 'YEAR', $mHotel, $mDay, $mMonth, $mYear);
109.         $mrByYear = array_reduce($mrByYear, function ($h, $data) {
110.             $h[$data['SUB_GRP_1']][] = $data['SUM_AMOUNT'];
111.             return $h;
112.         }, []);
115.         return $this->render('analytics/index.html.twig', [
116.             'mr_by_day' => $mrByDay,
117.             'mr_by_month' => $mrByMonth,
118.             'mr_by_year' => $mrByYear,
119.             'form' => $form->createView(),
120.         ]);
121.     }
123.     #[Route('/reports', name: 'app_reports')]
124.     public function reports(): Response
125.     {
126.         return $this->render('analytics/reports.html.twig', [
127.         ]);
128.     }
130.     #[Route('/aging', name: 'app_aging')]
131.     public function aging(Request $request, AgingRepository $agingRepository): Response
132.     {
133.         $currentDate = new \DateTime('-1 day');
134.         $search = (new Search())
135.             ->setDays($currentDate->format('d'))
136.             ->setMonths($currentDate->format('m'))
137.             ->setYears($currentDate->format('Y'));
138.         $form = $this->createForm(FilterType::class, $search);
139.         $form->handleRequest($request);
141.         $mHotel = null;
142.         $mDay = $currentDate->format('d');
143.         $mMonth = $currentDate->format('m');
144.         $mYear = $currentDate->format('Y');
145.         if ($form->isSubmitted() && $form->isValid()) {
146.             $mHotel = $search->getHotels();
147.             $mMonth = $search->getMonths();
148.             $mDay = $search->getDays();
149.             $mYear = $search->getYears();
150.         }
152.         $agingData = $agingRepository->findAGBy($mHotel, $mDay, $mMonth, $mYear);
154.         $agings = [];
155.         /** @var $aging Aging */
156.         foreach ($agingData as $aging) {
157.             $agings[$aging->getRESORT()][$aging->getTYPE()][] = $aging;
158.         }
159.         
160.         return $this->render('analytics/aging.html.twig', [
161.             'form' => $form->createView(),
162.             'agings' => $agings,
163.         ]);
164.     }
166.     #[Route('/guests', name: 'app_guests')]
167.     public function guests(Request $request, PMAccountByRoomRepository $PMAccountByRoomRepository, PaginatorInterface $paginator): Response
168.     {
169.         $currentDate = new \DateTime('-1 day');
170.         $search = (new Search())
171.             ->setDays($currentDate->format('d'))
172.             ->setMonths($currentDate->format('m'))
173.             ->setYears($currentDate->format('Y'));
174.         $form = $this->createForm(FilterType::class, $search, ['items' => true,]);
175.         $form->handleRequest($request);
177.         $mHotel = null;
178.         $mMonth = $currentDate->format('m');
179.         $mDay = $currentDate->format('d');
180.         $mYear = $currentDate->format('Y');
181.         if ($form->isSubmitted() && $form->isValid()) {
182.             $mHotel = $search->getHotels();
183.             $mMonth = $search->getMonths();
184.             $mDay = $search->getDays();
185.             $mYear = $search->getYears();
186.         }
188.         $builder = $PMAccountByRoomRepository->createQueryBuilder('p');
190.         if ($mHotel) {
191.             $builder->andWhere('p.RESORT = :hotel')
192.                 ->setParameter('hotel', $mHotel->getName());
193.         }else{
194.             if (!$this->isGranted(User::ROLE_ADMIN) && !$this->isGranted(User::ROLE_IT_MANAGER)){
195.                 $hotels = array_reduce($this->getUser()->getHotels()->toArray(), function ($h, Hotel $v){$h[]=$v->getName(); return $h;}, []);
196.                 $builder->andWhere('p.RESORT IN(:hotels)')
197.                     ->setParameter('hotels', $hotels);
198.             }
199.         }
201.         if ($mDay) {
202.             $builder->andWhere('DAY(p.createdAt) = :day')
203.                 ->setParameter('day', $mDay);
204.         }
206.         if ($mMonth) {
207.             $builder->andWhere('MONTH(p.createdAt) = :month')
208.                 ->setParameter('month', $mMonth);
209.         }
211.         if ($mYear) {
212.             $builder->andWhere('YEAR(p.createdAt) = :year')
213.                 ->setParameter('year', $mYear);
214.         }
216.         $guests = $paginator->paginate(
217.             $builder->getQuery(),
218.             $request->query->getInt('page', 1), /*page number*/
219.             $search->getItems(), /*limit per page*/
220.         );
222. //        $guests = $PMAccountByRoomRepository->getGuests();
223.         return $this->render('analytics/guests.html.twig', [
224.             'guests' => $guests,
225.             'form' => $form->createView(),
226.         ]);
227.     }
229.     #[Route('/tablehrg', name: 'app_tablehrg')]
230.     public function tablehrg(Request $request, HistoryForcastRepository $historyForcastRepository, ManagerReportDataRepository $managerReportDataRepository): Response
231.     {
232.         $currentDate = new \DateTime('-1 day');
233.         $search = (new Search())
234.             ->setDays($currentDate->format('d'))
235.             ->setMonths($currentDate->format('m'))
236.             ->setYears($currentDate->format('Y'));
237.         $form = $this->createForm(FilterType::class, $search);
238.         $form->remove('days');
239.         $form->handleRequest($request);
241.         $mHotel = null;
242.         $mMonth = $currentDate->format('m');
243.         $mYear = $currentDate->format('Y');
244.         if ($form->isSubmitted() && $form->isValid()) {
245.             $mHotel = $search->getHotels();
246.             $mMonth = $search->getMonths();
247.             $mYear = $search->getYears();
248.         }
250.         $hf = $historyForcastRepository->findHFBy($mHotel, $mMonth, $mYear);
251.         $mrByMonth = array_reduce($hf, function ($h, $data) {
252.             $h[$data['RESORT']][$data['CONSIDERED_DATE']->format('Y')][$data['CONSIDERED_DATE']->format('M')][$data['CONSIDERED_DATE']->format('jS')][$data['REC_TYPE']] = $data;
253.             return $h;
254.         }, []);
256. //        $mrByMonth = $managerReportDataRepository->findMRBy([
257. //            'PHYSICAL_ROOMS_MINUS_OOO',
258. //            'AVAIL_ROOMS',
259. //            'OCC_ROOMS',
260. //            'OCC_PERC',
261. //        ], 'MONTH', $mHotel, null, $mMonth, $mYear);
262. //        $mrByMonth = array_reduce($mrByMonth, function ($h, $data) {
263. //            $h[$data['RESORT']][$data['createdAt']->format('M')][$data['SUB_GRP_1']][$data['createdAt']->format('jS')]['DESCRIPTION'] = $data['DESCRIPTION'];
264. //            $h[$data['RESORT']][$data['createdAt']->format('M')][$data['SUB_GRP_1']][$data['createdAt']->format('jS')]['SUM_AMOUNT'] = $data['SUM_AMOUNT'];
265. //            return $h;
266. //        }, []);
268.         return $this->render('analytics/tablehrg.html.twig', [
269.             'form' => $form->createView(),
270.             'mr_by_month' => $mrByMonth,
271.         ]);
272.     }
274.     #[Route('/hrg', name: 'app_hrg')]
275.     public function hrg(Request $request, ManagerReportDataRepository $managerReportDataRepository): Response
276.     {
277.         $currentDate = new \DateTime('-1 day');
278.         $search = (new Search())
279.             ->setDays($currentDate->format('d'))
280.             ->setMonths($currentDate->format('m'))
281.             ->setYears($currentDate->format('Y'));
282.         $form = $this->createForm(FilterType::class, $search);
283.         $form->remove('days');
284.         $form->handleRequest($request);
286.         $mHotel = null;
287.         $mMonth = $currentDate->format('m');
288.         $mYear = $currentDate->format('Y');
289.         if ($form->isSubmitted() && $form->isValid()) {
290.             $mHotel = $search->getHotels();
291.             $mMonth = $search->getMonths();
292.             $mYear = $search->getYears();
293.         }
295.         return $this->render('analytics/hrg.html.twig', [
296.             'form' => $form->createView(),
297.         ]);
298.     }
300.     #[Route('/rate', name: 'app_rate')]
301.     public function rate(Request $request, ZeroRateRoomsRepository $rateRoomsRepository, PaginatorInterface $paginator): Response
302.     {
303.         $currentDate = new \DateTime('-1 day');
304.         $search = (new Search())
305.             ->setDays($currentDate->format('d'))
306.             ->setMonths($currentDate->format('m'))
307.             ->setYears($currentDate->format('Y'));
308.         $form = $this->createForm(FilterType::class, $search, ['items' => true]);
309.         $form->handleRequest($request);
311.         $mHotel = null;
312.         $mMonth = $currentDate->format('m');
313.         $mDay = $currentDate->format('d');
314.         $mYear = $currentDate->format('Y');
315.         if ($form->isSubmitted() && $form->isValid()) {
316.             $mHotel = $search->getHotels();
317.             $mMonth = $search->getMonths();
318.             $mDay = $search->getDays();
319.             $mYear = $search->getYears();
320.         }
322.         $builder = $rateRoomsRepository->createQueryBuilder('z');
324.         if ($mHotel) {
325.             $builder->andWhere('z.RESORT = :hotel')
326.                 ->setParameter('hotel', $mHotel->getName());
327.         }else{
328.             if (!$this->isGranted(User::ROLE_ADMIN) && !$this->isGranted(User::ROLE_IT_MANAGER)){
329.                 $hotels = array_reduce($this->getUser()->getHotels()->toArray(), function ($h, Hotel $v){$h[]=$v->getName(); return $h;}, []);
330.                 $builder->andWhere('z.RESORT IN(:hotels)')
331.                     ->setParameter('hotels', $hotels);
332.             }
333.         }
335.         if ($mDay) {
336.             $builder->andWhere('DAY(z.createdAt) = :day')
337.                 ->setParameter('day', $mDay);
338.         }
340.         if ($mMonth) {
341.             $builder->andWhere('MONTH(z.createdAt) = :month')
342.                 ->setParameter('month', $mMonth);
343.         }
345.         if ($mYear) {
346.             $builder->andWhere('YEAR(z.createdAt) = :year')
347.                 ->setParameter('year', $mYear);
348.         }
350.         $raterooms = $paginator->paginate(
351.             $builder->getQuery(),
352.             $request->query->getInt('page', 1), /*page number*/
353.             $search->getItems(), /*limit per page*/
354.         );
356. //        $raterooms = $rateRoomsRepository->getRooms();
357.         return $this->render('analytics/rate.html.twig', [
358.             'raterooms' => $raterooms,
359.             'form' => $form->createView(),
360.         ]);
361.     }
363.     #[Route('/tablermf', name: 'app_tablermf')]
364.     public function tablermf(Request $request, HistoryForcastRepository $historyForcastRepository, ManagerReportDataRepository $managerReportDataRepository): Response
365.     {
366.         $currentDate = new \DateTime('-1 day');
367.         $search = (new Search())
368.             ->setDays($currentDate->format('d'))
369.             ->setMonths($currentDate->format('m'))
370.             ->setYears($currentDate->format('Y'));
371.         $form = $this->createForm(FilterType::class, $search);
372.         $form->remove('days');
373.         $form->handleRequest($request);
375.         $mHotel = null;
376.         $mMonth = $currentDate->format('m');
377.         $mYear = $currentDate->format('Y');
378.         if ($form->isSubmitted() && $form->isValid()) {
379.             $mHotel = $search->getHotels();
380.             $mMonth = $search->getMonths();
381.             $mYear = $search->getYears();
382.         }
384.         $hf = $historyForcastRepository->findHFBy($mHotel, $mMonth, $mYear);
385. //        dump($hf);
386.         $mrByMonth = array_reduce($hf, function ($h, $data) {
387.             $h[$data['RESORT']][$data['CONSIDERED_DATE']->format('Y')][$data['CONSIDERED_DATE']->format('M')][$data['CONSIDERED_DATE']->format('jS')][$data['REC_TYPE']] = $data;
388.             return $h;
389.         }, []);
390. //        dump($mrByMonth);
392. //        $mrByMonth = $managerReportDataRepository->findMRBy([
393. //            'PHYSICAL_ROOMS_MINUS_OOO',
394. //            'AVAIL_ROOMS',
395. //            'OCC_ROOMS',
396. //            'OCC_PERC',
397. //        ], 'MONTH', $mHotel, null, $mMonth, $mYear);
398. //        $mrByMonth = array_reduce($mrByMonth, function ($h, $data) {
399. //            $h[$data['RESORT']][$data['createdAt']->format('M')][$data['SUB_GRP_1']][$data['createdAt']->format('jS')]['DESCRIPTION'] = $data['DESCRIPTION'];
400. //            $h[$data['RESORT']][$data['createdAt']->format('M')][$data['SUB_GRP_1']][$data['createdAt']->format('jS')]['SUM_AMOUNT'] = $data['SUM_AMOUNT'];
401. //            $h[$data['RESORT']][$data['createdAt']->format('M')][$data['SUB_GRP_1']][$data['createdAt']->format('jS')]['YEAR'] = $data['YEAR'];
402. //            return $h;
403. //        }, []);
405.         return $this->render('analytics/tablermf.html.twig', [
406.             'form' => $form->createView(),
407.             'mr_by_month' => $mrByMonth,
408.         ]);
409.     }
411.     #[Route('/rmf', name: 'app_rmf')]
412.     public function rmf(): Response
413.     {
414.         return $this->render('analytics/rmf.html.twig', [
415.             'controller_name' => 'HomeController',
416.         ]);
417.     }
419.     #[Route('/revenue', name: 'app_revenue')]
420.     public function revenue(Request $request, ManagerReportDataRepository $managerReportDataRepository, TransactionCodesGrossRepository $transactionCodesGrossRepository): Response
421.     {
422.         $currentDate = new \DateTime('-1 day');
423.         $search = (new Search())
424.             ->setDays($currentDate->format('d'))
425.             ->setMonths($currentDate->format('m'))
426.             ->setYears($currentDate->format('Y'));
427.         $form = $this->createForm(FilterType::class, $search);
428. //        $form->remove('years');
429.         $form->handleRequest($request);
431.         $mHotel = null;
432.         $mMonth = $currentDate->format('m');
433.         $mDay = $currentDate->format('d');
434.         $mYear = $currentDate->format('Y');
435.         if ($form->isSubmitted() && $form->isValid()) {
436.             $mHotel = $search->getHotels();
437.             $mMonth = $search->getMonths();
438.             $mDay = $search->getDays();
439.             $mYear = $search->getYears();
440.         }
442.         $thisYear = $mYear;
443.         $lastYear = $mYear - 1;
445.         $data = [];
446.         $data1 = [];
447.         $data2 = [];
449.         $mrByHotelByDay = $managerReportDataRepository->findMRBy([
450.             'FOOD_BEV_REVENUE',
451.             'ROOM_REVENUE',
452.             'OCC_PERC_WO_CHO',
453.             'OCC_MINUS_COMP_HU',
454.             'TOTAL_REVENUE',
455.         ], 'DAY', $mHotel, $mDay, $mMonth, $thisYear);
456.         foreach ($mrByHotelByDay as $mr) {
457.             $data[$mr['RESORT']]['THIS_YEAR'][$mr['SUB_GRP_1']] = $mr['SUM_AMOUNT'];
458.         }
459. //        dump($mrByHotelByDay);
460.         $mrByHotelByDay = $managerReportDataRepository->findMRBy([
461.             'FOOD_BEV_REVENUE',
462.             'ROOM_REVENUE',
463.             'OCC_PERC_WO_CHO',
464.             'OCC_MINUS_COMP_HU',
465.             'TOTAL_REVENUE',
466.         ], 'DAY', $mHotel, $mDay, $mMonth, $lastYear);
467.         foreach ($mrByHotelByDay as $mr) {
468.             $data[$mr['RESORT']]['LAST_YEAR'][$mr['SUB_GRP_1']] = $mr['SUM_AMOUNT'] ?? 0;
469.         }
473.         $tcgByHotelByDay = $transactionCodesGrossRepository->findMRBy([
474.             '2825',
475.         ], 'DAY', $mHotel, $mDay, $mMonth, $thisYear);
476. //        dump($tcgByHotelByDay);
477.         foreach ($tcgByHotelByDay as $mr) {
478.             $data[$mr['RESORT']]['THIS_YEAR'][$mr['SUB_GRP_1']] = $mr['SUM_AMT_TOTAL'];
479.         }
480.         $tcgByHotelByDay = $transactionCodesGrossRepository->findMRBy([
481.             '2825',
482.         ], 'DAY', $mHotel, $mDay, $mMonth, $lastYear);
483.         foreach ($tcgByHotelByDay as $mr) {
484.             $data[$mr['RESORT']]['LAST_YEAR'][$mr['SUB_GRP_1']] = $mr['SUM_AMT_TOTAL'] ?? 0;
485.         }
488.         $mrByHotelByMonth = $managerReportDataRepository->findMRBy([
489.             'FOOD_BEV_REVENUE',
490.             'ROOM_REVENUE',
491.             'OCC_PERC_WO_CHO',
492.             'OCC_MINUS_COMP_HU',
493.             'TOTAL_REVENUE',
494.         ], 'MONTH', $mHotel, $mDay, $mMonth, $thisYear);
495.         foreach ($mrByHotelByMonth as $mr) {
496.             $data1[$mr['RESORT']]['THIS_YEAR'][$mr['SUB_GRP_1']] = $mr['SUM_AMOUNT'];
497.         }
498.         $mrByHotelByMonth = $managerReportDataRepository->findMRBy([
499.             'FOOD_BEV_REVENUE',
500.             'ROOM_REVENUE',
501.             'OCC_PERC_WO_CHO',
502.             'OCC_MINUS_COMP_HU',
503.             'TOTAL_REVENUE',
504.         ], 'MONTH', $mHotel, $mDay, $mMonth, $lastYear);
505.         foreach ($mrByHotelByMonth as $mr) {
506.             $data1[$mr['RESORT']]['LAST_YEAR'][$mr['SUB_GRP_1']] = $mr['SUM_AMOUNT'];
507.         }
510.         $tcgByHotelByMonth = $transactionCodesGrossRepository->findMRBy([
511.             '2825',
512.         ], 'MONTH', $mHotel, $mDay, $mMonth, $thisYear);
513.         foreach ($tcgByHotelByMonth as $mr) {
514.             $data1[$mr['RESORT']]['THIS_YEAR'][$mr['SUB_GRP_1']] = $mr['SUM_AMT_TOTAL'];
515.         }
516.         $tcgByHotelByMonth = $transactionCodesGrossRepository->findMRBy([
517.             '2825',
518.         ], 'MONTH', $mHotel, $mDay, $mMonth, $lastYear);
519.         foreach ($tcgByHotelByMonth as $mr) {
520.             $data1[$mr['RESORT']]['LAST_YEAR'][$mr['SUB_GRP_1']] = $mr['SUM_AMT_TOTAL'] ?? 0;
521.         }
524.         $mrByHotelByYear = $managerReportDataRepository->findMRBy([
525.             'FOOD_BEV_REVENUE',
526.             'ROOM_REVENUE',
527.             'OCC_PERC_WO_CHO',
528.             'OCC_MINUS_COMP_HU',
529.             'TOTAL_REVENUE',
530.         ], 'YEAR', $mHotel, $mDay, $mMonth, $thisYear);
531.         foreach ($mrByHotelByYear as $mr) {
532.             $data2[$mr['RESORT']]['THIS_YEAR'][$mr['SUB_GRP_1']] = $mr['SUM_AMOUNT'];
533.         }
534.         $mrByHotelByYear = $managerReportDataRepository->findMRBy([
535.             'FOOD_BEV_REVENUE',
536.             'ROOM_REVENUE',
537.             'OCC_PERC_WO_CHO',
538.             'OCC_MINUS_COMP_HU',
539.             'TOTAL_REVENUE',
540.         ], 'YEAR', $mHotel, $mDay, $mMonth, $lastYear);
541.         foreach ($mrByHotelByYear as $mr) {
542.             $data2[$mr['RESORT']]['LAST_YEAR'][$mr['SUB_GRP_1']] = $mr['SUM_AMOUNT'];
543.         }
546.         $tcgByHotelByYear = $transactionCodesGrossRepository->findMRBy([
547.             '2825',
548.         ], 'YEAR', $mHotel, $mDay, $mMonth, $thisYear);
549.         foreach ($tcgByHotelByYear as $mr) {
550.             $data2[$mr['RESORT']]['THIS_YEAR'][$mr['SUB_GRP_1']] = $mr['SUM_AMT_TOTAL'];
551.         }
552.         $tcgByHotelByYear = $transactionCodesGrossRepository->findMRBy([
553.             '2825',
554.         ], 'YEAR', $mHotel, $mDay, $mMonth, $lastYear);
555.         foreach ($tcgByHotelByYear as $mr) {
556.             $data2[$mr['RESORT']]['LAST_YEAR'][$mr['SUB_GRP_1']] = $mr['SUM_AMT_TOTAL'] ?? 0;
557.         }
559. //
560. //        $mrByYear = $managerReportDataRepository->findMRBy([
561. //            'TOTAL_REVENUE',
562. //            'ROOM_REVENUE',
563. //            'OCC_PERC',
564. //        ], 'YEAR', $mHotel, $mDay, $mMonth, $mYear);
565. //        $mrByYear = array_reduce($mrByYear, function ($h, $data) {
566. //            $h[$data['SUB_GRP_1']][] = $data['SUM_AMOUNT'];
567. //            return $h;
568. //        }, []);
569.         return $this->render('analytics/revenue.html.twig', [
570.             'form' => $form->createView(),
571.             'mr_by_hotel_by_day' => $data,
572.             'mr_by_hotel_by_month' => $data1,
573.             'mr_by_hotel_by_year' => $data2,
574.             'search' => $search,
575. //            'mr_by_month' => $mrByMonth,
576. //            'mr_by_year' => $mrByYear,
577. //            'form' => $form->createView(),
578.         ]);
579.     }
581.     #[Route('/daily', name: 'app_daily')]
582.     public function daily(Request $request, ManagerReportDataRepository $managerReportDataRepository): Response
583.     {
584.         $currentDate = new \DateTime('-1 day');
585.         $search = (new Search())
586.             ->setDays($currentDate->format('d'))
587.             ->setMonths($currentDate->format('m'))
588.             ->setYears($currentDate->format('Y'));
589.         $form = $this->createForm(FilterType::class, $search);
590.         $form->remove('days');
591.         $form->handleRequest($request);
593.         $mHotel = null;
594.         $mMonth = $currentDate->format('m');
595.         $mYear = $currentDate->format('Y');
596.         if ($form->isSubmitted() && $form->isValid()) {
597.             $mHotel = $search->getHotels();
598.             $mMonth = $search->getMonths();
599.             $mYear = $search->getYears();
600.         }
602.         $mrByHotelByDay = $managerReportDataRepository->findMRBy([
603.             'HOUSE_USE_ROOMS',
604. //            'FOOD_BEV_REVENUE',
605. //            'ROOM_REVENUE',
606. //            'OCC_PERC_WO_CHO',
607. //            'OCC_MINUS_COMP_HU',
608. //            'TOTAL_REVENUE',
609.         ], 'DAY', $mHotel, null, $mMonth, $mYear);
612.         return $this->render('analytics/daily.html.twig', [
613.             'form' => $form->createView(),
614.             'search' => $search,
615.         ]);
617.     }
619.     #[Route('/otb_pu', name: 'app_otb_pu')]
620.     public function otb_pu(Request $request, MarketStatisticsRepository $marketStatisticsRepository): Response
621.     {
622.         $currentDate = new \DateTime('-1 day');
623.         $search = (new Search())
624.             ->setDays($currentDate->format('d'))
625.             ->setMonths($currentDate->format('m'))
626.             ->setYears($currentDate->format('Y'));
627.         $form = $this->createForm(FilterType::class, $search);
628.         $form->remove('days');
629.         $form->handleRequest($request);
631.         $mHotel = null;
632.         $mMonth = $currentDate->format('m');
633.         $mYear = $currentDate->format('Y');
634.         if ($form->isSubmitted() && $form->isValid()) {
635.             $mHotel = $search->getHotels();
636.             $mMonth = $search->getMonths();
637.             $mYear = $search->getYears();
638.         }
640.         $fsByDay = $marketStatisticsRepository->findMSByDay($mHotel, null, $mMonth, $mYear);
641.         $mrByMonth = array_reduce($fsByDay, function ($h, $data) {
642.             $h[$data['createdAt']->format('d/m/Y')][$data['PARENT_MARKET_CODE']] = $data;
643.             return $h;
644.         }, []);
645.         $val = array_key_first($mrByMonth);
646.         $labels = $val ? array_reduce($mrByMonth[$val], function ($h, $value) {
647.             $h[] = $value['MARKET_GROUP_DESCRIPTION'];
648.             return $h;
649.         }, []) : [];
651.         return $this->render('analytics/otb_pu.html.twig', [
652.             'form' => $form->createView(),
653.             'mr_by_month' => $mrByMonth,
654.             'labels' => $labels,
655.         ]);
656.     }
658.     #[Route('/daily_hotel_dashboard', name: 'app_daily_hotel_dashboard')]
659.     public function daily_hotel_dashboard(Request $request, MarketStatisticsRepository $marketStatisticsRepository): Response
660.     {
661.         $currentDate = new \DateTime('-1 day');
662.         $search = (new Search())
663.             ->setDays($currentDate->format('d'))
664.             ->setMonths($currentDate->format('m'))
665.             ->setYears($currentDate->format('Y'));
666.         $form = $this->createForm(FilterType::class, $search);
667.         $form->handleRequest($request);
670.         $mHotel = null;
671.         $mMonth = $currentDate->format('m');
672.         $mDay = $currentDate->format('d');
673.         $mYear = $currentDate->format('Y');
674.         if ($form->isSubmitted() && $form->isValid()) {
675.             $mHotel = $search->getHotels();
676.             $mMonth = $search->getMonths();
677.             $mDay = $search->getDays();
678.             $mYear = $search->getYears();
679.         }
680.         $fsByDay = $marketStatisticsRepository->findMSBy([
681.             'PM_DAY_ROOM',// Direct Hotel
682.             'WEB',
683.             'IND',
684.             'LEI',
685. //            'LEI',//Corpo
686.             'GCOR',
687.             'GLSR',
688.             'GRI',
689.             'GRT',
690.             'BCR',
691.         ], $mHotel, $mDay, $mMonth, $mYear);
692.         $fsByDay = array_reduce($fsByDay, function ($h, $data) {
693.             $h['PM_DAY_ROOM'][$data['PARENT_MARKET_CODE']] = ['MARKET_GROUP_DESCRIPTION' => $data['MARKET_GROUP_DESCRIPTION'], 'SUM_AMOUNT' => $data['PM_DAY_ROOM']];
694.             $h['PM_DAY_ARR'][$data['PARENT_MARKET_CODE']] = ['MARKET_GROUP_DESCRIPTION' => $data['MARKET_GROUP_DESCRIPTION'], 'SUM_AMOUNT' => $data['PM_DAY_ARR']];
695.             $h['PM_DAY_CREV'][$data['PARENT_MARKET_CODE']] = ['MARKET_GROUP_DESCRIPTION' => $data['MARKET_GROUP_DESCRIPTION'], 'SUM_AMOUNT' => $data['PM_DAY_CREV']];
696.             return $h;
697.         }, []);
698. //        dump($fsByDay);
701. //        $fsByMonth = $marketStatisticsRepository->findMSBy([
702. //            'PM_DAY_ROOM',
703. //            'PM_DAY_PERSON',
704. //            'PM_MONTH_ROOM',
705. //            'PM_MONTH_PERSON',
706. //            'PM_MONTH_PERSON',
707. //            'PM_YEAR_ROOM',
708. //            'PM_YEAR_PRS',
709. //            'PM_DAY_CREV',
710. //            'PM_MONTH_CREV',
711. //            'PM_YEAR_CREV',
712. //            'PM_YEAR_ARR',
713. //            'PM_MONTH_ARR',
714. //            'PM_DAY_ARR',
715. //            'PM_DAY_PER_OCC',
716. //            'PM_MTD_PER_OCC',
717. //            'PM_YTD_PER_OCC',
718. //        ], $mHotel, $mDay, $mMonth, $mYear);
719. //        $fsByMonth = array_reduce($fsByMonth, function ($h, $data) {
720. //            $h[$data['SUB_GRP_1']][] = $data['SUM_AMOUNT'];
721. //            return $h;
722. //        }, []);
723. //
724. //        $fsByYear = $marketStatisticsRepository->findMSBy([
725. //            'PM_DAY_ROOM',
726. //            'PM_DAY_PERSON',
727. //            'PM_MONTH_ROOM',
728. //            'PM_MONTH_PERSON',
729. //            'PM_MONTH_PERSON',
730. //            'PM_YEAR_ROOM',
731. //            'PM_YEAR_PRS',
732. //            'PM_DAY_CREV',
733. //            'PM_MONTH_CREV',
734. //            'PM_YEAR_CREV',
735. //            'PM_YEAR_ARR',
736. //            'PM_MONTH_ARR',
737. //            'PM_DAY_ARR',
738. //            'PM_DAY_PER_OCC',
739. //            'PM_MTD_PER_OCC',
740. //            'PM_YTD_PER_OCC',
741. //        ], $mHotel, $mDay, $mMonth, $mYear);
742. //        $fsByYear = array_reduce($fsByYear, function ($h, $data) {
743. //            $h[$data['SUB_GRP_1']][] = $data['SUM_AMOUNT'];
744. //            return $h;
745. //        }, []);
747.         return $this->render('analytics/daily_hotel_dashboard.html.twig', [
748.             'form' => $form->createView(),
749.             'mr_by_day' => $fsByDay,
750. //            'mr_by_month' => $fsByMonth,
751. //            'mr_by_year'=> $fsByYear
752.         ]);
753.     }
755.     #[Route('/ops_dashboard', name: 'app_ops_dashboard')]
756.     public function ops_dashboard(Request $request, HistoryForcastRepository $historyForcastRepository, ManagerReportDataRepository $managerReportDataRepository): Response
757.     {
758.         $currentDate = new \DateTime('-1 day');
759.         $search = (new Search())
760.             ->setDays($currentDate->format('d'))
761.             ->setMonths($currentDate->format('m'))
762.             ->setYears($currentDate->format('Y'));
763.         $form = $this->createForm(FilterType::class, $search);
764.         $form->remove('days');
765.         $form->handleRequest($request);
767.         $mHotel = null;
768.         $mMonth = $currentDate->format('m');
769.         $mYear = $currentDate->format('Y');
770.         if ($form->isSubmitted() && $form->isValid()) {
771.             $mHotel = $search->getHotels();
772.             $mMonth = $search->getMonths();
773.             $mYear = $search->getYears();
774.         }
776.         $hf = $historyForcastRepository->findHFBy($mHotel, $mMonth, $mYear);
777.         $mrByMonth = array_reduce($hf, function ($h, $data) {
778.             $h[$data['RESORT']][$data['CONSIDERED_DATE']->format('Y')][$data['CONSIDERED_DATE']->format('M')][$data['CONSIDERED_DATE']->format('jS')][$data['REC_TYPE']] = $data;
779.             return $h;
780.         }, []);
782.         return $this->render('analytics/ops_dashboard.html.twig', [
783.             'form' => $form->createView(),
784.             'mr_by_month' => $mrByMonth,
785.         ]);
786.     }
788.     #[Route('/pricing', name: 'app_pricing')]
789.     public function pricing(Request $request, HistoryForcastRepository $historyForcastRepository, ManagerReportDataRepository $managerReportDataRepository): Response
790.     {
791.         $currentDate = new \DateTime('-1 day');
792.         $search = (new Search())
793.             ->setDays($currentDate->format('d'))
794.             ->setMonths($currentDate->format('m'))
795.             ->setYears($currentDate->format('Y'));
796.         $form = $this->createForm(FilterType::class, $search);
797.         $form->remove('days');
798.         $form->handleRequest($request);
800.         $mHotel = null;
801.         $mMonth = $currentDate->format('m');
802.         $mYear = $currentDate->format('Y');
803.         if ($form->isSubmitted() && $form->isValid()) {
804.             $mHotel = $search->getHotels();
805.             $mMonth = $search->getMonths();
806.             $mYear = $search->getYears();
807.         }
809.         $hf = $historyForcastRepository->findHFBy($mHotel, $mMonth, $mYear);
810.         $mrByMonth = array_reduce($hf, function ($h, $data) {
811.             $h[$data['RESORT']][$data['CONSIDERED_DATE']->format('Y')][$data['CONSIDERED_DATE']->format('M')][$data['CONSIDERED_DATE']->format('jS')][$data['REC_TYPE']] = $data;
812.             return $h;
813.         }, []);
815.         return $this->render('analytics/pricing.html.twig', [
816.             'form' => $form->createView(),
817.             'mr_by_month' => $mrByMonth,
818.         ]);
819.     }
821.     #[Route('/day', name: 'app_day')]
822.     public function day(Request $request, HistoryForcastRepository $historyForcastRepository, ManagerReportDataRepository $managerReportDataRepository): Response
823.     {
824.         $currentDate = new \DateTime('-1 day');
825.         $search = (new Search())
826.             ->setDays($currentDate->format('d'))
827.             ->setMonths($currentDate->format('m'))
828.             ->setYears($currentDate->format('Y'));
829.         $form = $this->createForm(FilterType::class, $search);
830.         $form->remove('days');
831.         $form->handleRequest($request);
833.         $mHotel = null;
834.         $mMonth = $currentDate->format('m');
835.         $mYear = $currentDate->format('Y');
836.         if ($form->isSubmitted() && $form->isValid()) {
837.             $mHotel = $search->getHotels();
838.             $mMonth = $search->getMonths();
839.             $mYear = $search->getYears();
840.         }
842.         $hf = $historyForcastRepository->findHFBy($mHotel, $mMonth, $mYear);
843.         $mrByMonth = array_reduce($hf, function ($h, $data) {
844.             $h[$data['RESORT']][$data['CONSIDERED_DATE']->format('Y')][$data['CONSIDERED_DATE']->format('M')][$data['CONSIDERED_DATE']->format('jS')][$data['REC_TYPE']] = $data;
845.             return $h;
846.         }, []);
848.         return $this->render('analytics/day.html.twig', [
849.             'form' => $form->createView(),
850.             'mr_by_month' => $mrByMonth,
851.         ]);
852.     }
854.     #[Route('/overview', name: 'app_overview')]
855.     public function overview(Request $request, HistoryForcastRepository $historyForcastRepository, ManagerReportDataRepository $managerReportDataRepository): Response
856.     {
857.         $currentDate = new \DateTime('-1 day');
858.         $search = (new Search())
859.             ->setDays($currentDate->format('d'))
860.             ->setMonths($currentDate->format('m'))
861.             ->setYears($currentDate->format('Y'));
862.         $form = $this->createForm(FilterType::class, $search);
863.         $form->remove('days');
864.         $form->handleRequest($request);
866.         $mHotel = null;
867.         $mMonth = $currentDate->format('m');
868.         $mYear = $currentDate->format('Y');
869.         if ($form->isSubmitted() && $form->isValid()) {
870.             $mHotel = $search->getHotels();
871.             $mMonth = $search->getMonths();
872.             $mYear = $search->getYears();
873.         }
875.         $hf = $historyForcastRepository->findHFBy($mHotel, $mMonth, $mYear);
876.         $mrByMonth = array_reduce($hf, function ($h, $data) {
877.             $h[$data['RESORT']][$data['CONSIDERED_DATE']->format('Y')][$data['CONSIDERED_DATE']->format('M')][$data['CONSIDERED_DATE']->format('jS')][$data['REC_TYPE']] = $data;
878.             return $h;
879.         }, []);
881.         return $this->render('analytics/overview.html.twig', [
882.             'form' => $form->createView(),
883.             'mr_by_month' => $mrByMonth,
884.         ]);
885.     }
887.     #[Route('/rooms_analysis', name: 'app_rooms_analysis')]
888.     public function rooms_analysis(Request $request, MarketStatisticsRepository $marketStatisticsRepository): Response
889.     {
890.         $currentDate = new \DateTime('-1 day');
891.         $search = (new Search())
892.             ->setDays($currentDate->format('d'))
893.             ->setMonths($currentDate->format('m'))
894.             ->setYears($currentDate->format('Y'));
895.         $form = $this->createForm(FilterType::class, $search);
896.         $form->remove('days');
897.         $form->handleRequest($request);
899.         $mHotel = null;
900.         $mMonth = $currentDate->format('m');
901.         $mYear = $currentDate->format('Y');
902.         if ($form->isSubmitted() && $form->isValid()) {
903.             $mHotel = $search->getHotels();
904.             $mMonth = $search->getMonths();
905.             $mYear = $search->getYears();
906.         }
908.         $fsByDay = $marketStatisticsRepository->findMSByDay($mHotel, null, $mMonth, $mYear);
909.         $mrByMonth = array_reduce($fsByDay, function ($h, $data) {
910.             $h[$data['MARKET_GROUP_DESCRIPTION']][$data['createdAt']->format('d/m/Y')][] = $data;
911.             return $h;
912.         }, []);
913.         $labels = array_reduce($fsByDay, function ($h, $value) {
914.             $h[$value['createdAt']->format('m/d/Y')] = $value['createdAt']->format('d/m/Y');
915.             return $h;
916.         }, []);
918.         return $this->render('analytics/rooms_analysis.html.twig', [
919.             'form' => $form->createView(),
920.             'mr_by_month' => $mrByMonth,
921.             'labels' => array_unique($labels),
922.         ]);
923.     }
925.     #[Route('/production', name: 'app_production')]
926.     public function production(Request $request, FullStatsticAgenComRepository $fullStatsticAgenComRepository): Response
927.     {
928.         $currentDate = new \DateTime('-1 day');
929.         $search = (new Search())
930.             ->setDays($currentDate->format('d'))
931.             ->setMonths($currentDate->format('m'))
932.             ->setYears($currentDate->format('Y'));
933.         $form = $this->createForm(FilterType::class, $search);
934.         $form->handleRequest($request);
937.         $mHotel = null;
938.         $mMonth = $currentDate->format('m');
939.         $mDay = $currentDate->format('d');
940.         $mYear = $currentDate->format('Y');
941.         if ($form->isSubmitted() && $form->isValid()) {
942.             $mHotel = $search->getHotels();
943.             $mMonth = $search->getMonths();
944.             $mDay = $search->getDays();
945.             $mYear = $search->getYears();
946.         }
947.         $fsByDay = $fullStatsticAgenComRepository->findMSBy([
948.             'PM_DAY_ROOM',// Direct Hotel
949.             'WEB',
950.             'IND',
951.             'LEI',
952. //            'LEI',//Corpo
953.             'GCOR',
954.             'GLSR',
955.             'GRI',
956.             'GRT',
957.             'BCR',
958.         ], $mHotel, $mDay, $mMonth, $mYear);
959.         $fsByDay = array_reduce($fsByDay, function ($h, $data) {
960.             $h['PM_DAY_ROOM'][$data['PARENT_MARKET_CODE']] = ['MARKET_GROUP_DESCRIPTION' => $data['MARKET_GROUP_DESCRIPTION'], 'SUM_AMOUNT' => $data['PM_DAY_ROOM']];
961.             $h['PM_DAY_ARR'][$data['PARENT_MARKET_CODE']] = ['MARKET_GROUP_DESCRIPTION' => $data['MARKET_GROUP_DESCRIPTION'], 'SUM_AMOUNT' => $data['PM_DAY_ARR']];
962.             $h['PM_DAY_CREV'][$data['PARENT_MARKET_CODE']] = ['MARKET_GROUP_DESCRIPTION' => $data['MARKET_GROUP_DESCRIPTION'], 'SUM_AMOUNT' => $data['PM_DAY_CREV']];
963.             return $h;
964.         }, []);
965.         dump($fsByDay);
967.         return $this->render('analytics/production.html.twig', [
968.             'form' => $form->createView(),
969.             'mr_by_day' => $fsByDay,
970. //            'mr_by_month' => $fsByMonth,
971. //            'mr_by_year'=> $fsByYear
972.         ]);
973.     }
976. }