src/Platform/ControlPanelBundle/Provider/WidgetStatProvider.php line 42

Open in your IDE?
  1. <?php
  3. namespace Platform\ControlPanelBundle\Provider;
  5. use Cms\CoreBundle\Util\Doctrine\EntityManager;
  6. use Cms\Modules\PageBundle\Entity\Page\PageProxy;
  7. use Cms\TenantBundle\Entity\Tenant;
  8. use Cms\ThemeBundle\Entity\InnerLayout;
  9. use Cms\ThemeBundle\Entity\OuterLayout;
  10. use Cms\WidgetBundle\Service\WidgetManager;
  11. use Doctrine\DBAL\Exception;
  12. use Doctrine\DBAL\Query\QueryBuilder;
  14. class WidgetStatProvider
  15. {
  16.     private const COLOR = '#ff0029';
  18.     /**
  19.      * @var EntityManager
  20.      */
  21.     private EntityManager $entityManager;
  22.     /**
  23.      * @var WidgetManager
  24.      */
  25.     private WidgetManager $widgetManager;
  27.     /**
  28.      * @param EntityManager $entityManager
  29.      * @param WidgetManager $widgetManager
  30.      */
  31.     public function __construct(EntityManager $entityManager, WidgetManager $widgetManager)
  32.     {
  33.         $this->entityManager = $entityManager;
  34.         $this->widgetManager = $widgetManager;
  35.     }
  37.     /**
  38.      * @param Tenant|null $tenant
  39.      * @return array
  40.      * @throws Exception
  41.      */
  42.     public function getData(Tenant $tenant = null): array
  43.     {
  44.         $labels = [];
  45.         $datasetData = [];
  47.         foreach ($this->widgetManager->gallery() as $widget) {
  48.             $labels[$widget['key']] = $widget['name'];
  50.             $queryBuilder = $this->getQueryBuilder(PageProxy::class, $tenant);
  51.             $count = $queryBuilder
  52.                 ->andWhere(
  53.                     sprintf('MATCH(entity.data_content) AGAINST("%s\"")', $widget['key'])
  54.                 )
  55.                 ->fetchOne();
  57.             $queryBuilder = $this->getQueryBuilder(OuterLayout::class, $tenant);
  58.             $count += $queryBuilder
  59.                 ->andWhere(
  60.                     sprintf('MATCH(entity.contents) AGAINST("%s\"")', $widget['key'])
  61.                 )
  62.                 ->fetchOne();
  64.             $queryBuilder = $this->getQueryBuilder(InnerLayout::class, $tenant);
  65.             $count += $queryBuilder
  66.                 ->andWhere(
  67.                     sprintf('MATCH(entity.contents) AGAINST("%s\"")', $widget['key'])
  68.                 )
  69.                 ->fetchOne();
  71.             $datasetData[$widget['key']] = $count;
  72.         }
  74.         $datasets = [
  75.             [
  76.                 'label' => '# of page',
  77.                 'data' => array_values($datasetData),
  78.                 'backgroundColor' => self::COLOR,
  79.                 'borderColor' => self::COLOR,
  80.             ],
  81.         ];
  83.         return [
  84.             'labels' => array_values($labels),
  85.             'datasets' => array_values($datasets),
  86.         ];
  87.     }
  89.     /**
  90.      * @param string $class
  91.      * @param Tenant|null $tenant
  92.      * @return QueryBuilder
  93.      */
  94.     private function getQueryBuilder(string $class, Tenant $tenant = null): QueryBuilder
  95.     {
  96.         $queryBuilder = $this->entityManager->getConnection()->createQueryBuilder();
  97.         $queryBuilder
  98.             ->select("COUNT(*)")
  99.             ->from($this->entityManager->getClassMetadata($class)->getTableName(), 'entity');
  101.         if ($tenant !== null) {
  102.             $queryBuilder
  103.                 ->andWhere('entity.tenant = :tenant')
  104.                 ->setParameter('tenant', $tenant->getId());
  105.         }
  107.         return $queryBuilder;
  108.     }
  109. }