src/Controller/DashboardController.php line 23

  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\Order;
  6. use App\Entity\SupportTicket;
  7. use App\Entity\User;
  8. use App\Repository\OrderRepository;
  9. use Doctrine\ORM\EntityManagerInterface;
  10. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  11. use Symfony\Component\HttpFoundation\Response;
  12. use Symfony\Component\PasswordHasher\Hasher\UserPasswordHasherInterface;
  13. use Symfony\Component\Routing\Annotation\Route;
  15. class DashboardController extends AbstractController
  16. {
  17.     #[Route('/test', name: 'app_home')]
  18.     public function home(): Response
  19.     {
  20.         return $this->redirectToRoute('app_dashboard');
  21.     }
  22.     #[Route('/app', name: 'app_dashboard')]
  23.     public function index(EntityManagerInterface $entityManager): Response
  24.     {
  25.         $todayCount = $entityManager->getRepository(Order::class)->getOrderCount('today', $this->getUser());
  26.         $yesterdayCount = $entityManager->getRepository(Order::class)->getOrderCount('yesterday', $this->getUser());
  27.         $allByYesterday = $entityManager->getRepository(Order::class)->getOrderCount('all_by_yesterday', $this->getUser());
  28.         $allByToday = $entityManager->getRepository(Order::class)->getOrderCount('all_by_today', $this->getUser());
  31.         $today = new \DateTime('today');
  32.         $today->setTime(0,0);
  33.         $sevenDayBefore = new \DateTime('today');
  34.         $sevenDayBefore->modify('-7 days');
  35.         $sevenDayBefore->setTime(0,0);
  37.         $lastSevenDays = $entityManager->getRepository(Order::class)->getOrderCountPerDayForCurrentWeek($this->getUser(), $today, $sevenDayBefore);
  40.         $lastSevenDaysOrdersTotal = array_reduce($lastSevenDays, function($carry, $item) {
  41.             return $carry + $item['count'];
  42.         }, 0);
  44.         $lastSevenDaysOrders['data'] = array_map(function($item) {
  45.             return $item['count'];
  46.         }, $lastSevenDays);
  48.         // Extract the 'createdAt' values
  49.         $lastSevenDaysOrders['categories'] = array_map(function($item) {
  50.             return $item['createdDate'];
  51.         }, $lastSevenDays);
  53.         $lasttoLastSevenDaysBefore = new \DateTime('today');
  54.         $lasttoLastSevenDaysBefore->modify('-14 days');
  55.         $lasttoLastSevenDaysBefore->setTime(0,0);
  56.         $lasttoLastSevenDays = $entityManager->getRepository(Order::class)
  57.                                 ->getOrderCountPerDayForCurrentWeek($this->getUser(), $sevenDayBefore, $lasttoLastSevenDaysBefore);
  59.         $lasttoLastSevenDaysOrdersTotal = array_reduce($lasttoLastSevenDays, function($carry, $item) {
  60.             return $carry + $item['count'];
  61.         }, 0);
  63.         $lastSevenDaysPercentage = $this->getPercentage($lasttoLastSevenDaysOrdersTotal,$lastSevenDaysOrdersTotal);
  65.         $currentMonth = new \DateTime('first day of last month');
  66.         $currentMonth->setTime(0,0);
  68.         $currentMonthOrders = $entityManager->getRepository(Order::class)->getOrderCountPerDayForCurrentMonth($this->getUser(), $today, $currentMonth);
  70.         $currentMonthOrdersTotal = array_reduce($currentMonthOrders, function($carry, $item) {
  71.             return $carry + $item['count'];
  72.         }, 0);
  74.         $currentMonthOrdersData['data'] = array_map(function($item) {
  75.             return $item['count'];
  76.         }, $currentMonthOrders);
  78.         $currentMonthOrdersData['categories'] = array_map(function($item) {
  79.             return $item['createdWeek'];
  80.         }, $currentMonthOrders);
  82.         $lastMonth = new \DateTime('first day of last month');
  83.         $lastMonth->setTime(0,0);
  85.         $lastMonthOrders = $entityManager->getRepository(Order::class)->getOrderCountPerDayForCurrentMonth($this->getUser(), $currentMonth, $lastMonth);
  87.         $lastMonthOrdersTotal = array_reduce($lastMonthOrders, function($carry, $item) {
  88.             return $carry + $item['count'];
  89.         }, 0);
  91.         $currentMonthPercentage = $this->getPercentage($currentMonthOrdersTotal,$lastMonthOrdersTotal);
  92. //        $lastMonthOrdersData['data'] = array_map(function($item) {
  93. //            return $item['count'];
  94. //        }, $lastMonthOrders);
  95. //
  96. //        $lastMonthOrdersData['categories'] = array_map(function($item) {
  97. //            return $item['createdDate'];
  98. //        }, $lastMonthOrders);
  100. //        $lasttoLastSevenDays['data'] = array_map(function($item) {
  101. //            return $item['count'];
  102. //        }, $lastSevenDays);
  103. //
  104. //        // Extract the 'createdAt' values
  105. //        $lastSevenDaysOrders['categories'] = array_map(function($item) {
  106. //            return $item['createdDate'];
  107. //        }, $lastSevenDays);
  111.         $todayCountData = $this->getPercentage($yesterdayCount,$todayCount);
  112.         $totalCountData = $this->getPercentage($allByYesterday,$allByToday);
  114.         $supportTicketData = $entityManager->getRepository(SupportTicket::class)->findBy( [
  115.             'status' => 'open',
  116.             'customer' => $this->getUser()
  117.         ],['id'=>'DESC'],5,0);
  118.         $orderData = $entityManager->getRepository(Order::class)->findBy(['customer' => $this->getUser()], ['id'=>'DESC'],5,0);
  119.         //dd($totalCountData);
  120.         //$balance = $entityManager->getRepository(Wa)
  122.         $chartData = [
  123. //            'latestOrders' => [
  124. //                'data' => [3844, 3855, 3841, 3867, 3822, 3843, 3821, 3841, 3856, 3827, 3843],
  125. //                'categories' => ["Jan 01 2022", "Jan 02 2022", "Jan 03 2022", "Jan 04 2022", "Jan 05 2022", "Jan 06 2022", "Jan 07 2022", "Jan 08 2022", "Jan 09 2022", "Jan 10 2022", "Jan 11 2022",]
  126. //            ],
  127.              'latestOrders' => $lastSevenDaysOrders,
  128.              'currentMonthOrders' => $currentMonthOrdersData
  129.         ];
  131.         return $this->render('dashboard/index.html.twig', [
  132.             'lastSevenDaysOrdersTotal' => $lastSevenDaysOrdersTotal,
  133.             'lastSevenDaysPercentage' => $lastSevenDaysPercentage,
  134.             'currentMonthOrderTotal' => $currentMonthOrdersTotal,
  135.             'currentMonthPercentage' => $currentMonthPercentage,
  136.             'todayCountData' => $todayCountData,
  137.             'totalCountData' => $totalCountData,
  138.             'supportTicketData' => $supportTicketData,
  139.             'orderData' => $orderData,
  140.             'chartData' => $chartData
  141.         ]);
  142.     }
  144.     public function getPercentage(int $baseValue, int $secondValue): array
  145.     {
  146. //        echo $baseValue;
  147. //        echo $secondValue;
  148. //        exit;
  149.         $data = [];
  150.         if ($secondValue > $baseValue){
  151.             $data['orderTextStyle'] = 'text-success';
  152.             $data['orderArrowStyle'] = 'arrow-up';
  153.         }else if ($baseValue > $secondValue){
  154.             $data['orderTextStyle'] = 'text-danger';
  155.             $data['orderArrowStyle'] = 'arrow-down';
  156.         }else{
  157.             $data['orderTextStyle'] = 'text-info';
  158.             $data['orderArrowStyle'] = '';
  159.         }
  160.         $data['todayCount'] = $secondValue;
  161.         $data['yesterdayCount'] = $baseValue;
  163.         $onePercentage = $baseValue/100;
  164.         $difference = $secondValue - $baseValue;
  165.         $percentage = $onePercentage > 0 ? $difference/$onePercentage : 0;
  166.         $data['dataPercentage'] = number_format($percentage,2);
  167.         return $data;
  168.     }
  170. }