src/Widgets/Account.php line 35

Open in your IDE?
  1. <?php
  3. /**
  4.  * This file is part of the pdAdmin package.
  5.  *
  6.  * @package     pd-admin
  7.  * @license     LICENSE
  8.  * @author      Ramazan APAYDIN <apaydin541@gmail.com>
  9.  * @link        https://github.com/appaydin/pd-admin
  10.  */
  12. namespace App\Widgets;
  14. use App\Entity\Account\User;
  15. use Doctrine\ORM\EntityManagerInterface;
  16. use Pd\WidgetBundle\Builder\Item;
  17. use Pd\WidgetBundle\Builder\ItemInterface;
  18. use Pd\WidgetBundle\Event\WidgetEvent;
  19. use Symfony\Component\HttpFoundation\Request;
  21. /**
  22.  * Account Widget.
  23.  *
  24.  * @author Ramazan APAYDIN <apaydin541@gmail.com>
  25.  */
  26. class Account
  27. {
  28.     public function __construct(private EntityManagerInterface $entityManager)
  29.     {
  30.     }
  32.     /**
  33.      * Build Widgets.
  34.      */
  35.     public function builder(WidgetEvent $event): void
  36.     {
  37.         $event->getWidgetContainer()
  38.             ->addWidget($this->getUserInfoWidget())
  39.             ->addWidget($this->getUserStatisticsWidget());
  40.     }
  42.     private function getUserInfoWidget(): ItemInterface
  43.     {
  44.         return (new Item('user.info'))
  45.             ->setGroup('admin')
  46.             ->setName('widget.user_info.name')
  47.             ->setDescription('widget.user_info.description')
  48.             ->setTemplate('admin/widgets/userInfo.html.twig')
  49.             ->setRole(['ROLE_WIDGET_USERINFO'])
  50.             ->setData(function ($config) {
  51.                 $userCount = $this->entityManager->getRepository(User::class)
  52.                     ->createQueryBuilder('u')
  53.                     ->select('count(u.id)')
  54.                     ->getQuery()
  55.                     ->getSingleScalarResult();
  57.                 return ['result' => $userCount];
  58.             })
  59.             ->setOrder(5);
  60.     }
  62.     private function getUserStatisticsWidget(): ItemInterface
  63.     {
  64.         return (new Item('user_statistics'))
  65.             ->setGroup('admin')
  66.             ->setName('widget.user_statistic.name')
  67.             ->setDescription('widget.user_statistic.description')
  68.             ->setTemplate('admin/widgets/userStatistics.html.twig')
  69.             ->setRole(['ROLE_WIDGET_USERSTATISTICS'])
  70.             ->setConfigProcess(static function (Request $request) {
  71.                 if ($type = $request->get('type')) {
  72.                     switch ($type) {
  73.                         case '1week':
  74.                             return ['type' => '1week'];
  75.                         case '1month':
  76.                             return ['type' => '1month'];
  77.                         case '3month':
  78.                             return ['type' => '3month'];
  79.                     }
  80.                 }
  82.                 return false;
  83.             })
  84.             ->setData(function ($config) {
  85.                 // Create Chart Data
  86.                 $chart = [
  87.                     'column' => [],
  88.                     'created' => [],
  89.                     'logged' => [],
  90.                 ];
  92.                 // Set Default
  93.                 if (!isset($config['type'])) {
  94.                     $config['type'] = '1week';
  95.                 }
  97.                 // Create Statistics Data
  98.                 if ('3month' === $config['type']) {
  99.                     // Load Records
  100.                     $createdData = $this->entityManager->getRepository(User::class)
  101.                         ->createQueryBuilder('u')
  102.                         ->select('count(u.id) as count, MONTH(u.createdAt) as month')
  103.                         ->groupBy('month')
  104.                         ->where('u.createdAt >= :date')
  105.                         ->setParameter('date', new \DateTime('-3 Month'))
  106.                         ->getQuery()->getArrayResult();
  107.                     $loggedData = $this->entityManager->getRepository(User::class)
  108.                         ->createQueryBuilder('u')
  109.                         ->select('count(u.id) as count, MONTH(u.lastLogin) as month')
  110.                         ->groupBy('month')
  111.                         ->where('u.lastLogin >= :date')
  112.                         ->setParameter('date', new \DateTime('-3 Month'))
  113.                         ->getQuery()->getArrayResult();
  114.                     $createdData = array_column($createdData, 'count', 'month');
  115.                     $loggedData = array_column($loggedData, 'count', 'month');
  117.                     // Optimize Data
  118.                     for ($i = 0; $i < 3; ++$i) {
  119.                         $month = explode('/', date('n/Y', strtotime("-{$i} month")));
  120.                         $chart['column'][] = $month[0].'/'.$month[1];
  121.                         $chart['created'][] = $createdData[$month[0]] ?? 0;
  122.                         $chart['logged'][] = $loggedData[$month[0]] ?? 0;
  123.                     }
  124.                 } elseif (\in_array($config['type'], ['1month', '1week'], true) || !$config['type']) {
  125.                     $time = '1month' === $config['type'] ? new \DateTime('-1 Month') : new \DateTime('-6 Day');
  126.                     $column = '1month' === $config['type'] ? 30 : 7;
  128.                     // Load Records
  129.                     $createdData = $this->entityManager->getRepository(User::class)
  130.                         ->createQueryBuilder('u')
  131.                         ->select('count(u.id) as count, DAY(u.createdAt) as day')
  132.                         ->groupBy('day')
  133.                         ->where('u.createdAt >= :date')
  134.                         ->setParameter('date', $time)
  135.                         ->getQuery()->getArrayResult();
  136.                     $loggedData = $this->entityManager->getRepository(User::class)
  137.                         ->createQueryBuilder('u')
  138.                         ->select('count(u.id) as count, DAY(u.lastLogin) as day')
  139.                         ->groupBy('day')
  140.                         ->where('u.lastLogin >= :date')
  141.                         ->setParameter('date', $time)
  142.                         ->getQuery()->getArrayResult();
  143.                     $createdData = array_column($createdData, 'count', 'day');
  144.                     $loggedData = array_column($loggedData, 'count', 'day');
  146.                     // Optimize Data
  147.                     for ($i = 0; $i < $column; ++$i) {
  148.                         $day = explode('/', date('j/m', strtotime("-{$i} day")));
  149.                         $chart['column'][] = $day[0].'/'.$day[1];
  150.                         $chart['created'][] = $createdData[$day[0]] ?? 0;
  151.                         $chart['logged'][] = $loggedData[$day[0]] ?? 0;
  152.                     }
  153.                 }
  155.                 // JSON & Reverse Data
  156.                 $chart['column'] = json_encode(array_reverse($chart['column']));
  157.                 $chart['created'] = json_encode(array_reverse($chart['created']));
  158.                 $chart['logged'] = json_encode(array_reverse($chart['logged']));
  160.                 return $chart;
  161.             });
  162.     }
  163. }