src/Controller/Search/DashboardSearchController.php line 47

  1. <?php
  3. namespace App\Controller\Search;
  5. use App\Entity\Advertiser;
  6. use App\Entity\Comment;
  7. use App\Entity\Device;
  8. use App\Entity\Host;
  9. use App\Entity\ProxyUser;
  10. use App\Entity\SearchCampaign;
  11. use App\Entity\SearchFeed;
  12. use App\Entity\SearchFeedIsps;
  13. use App\Entity\User;
  14. use App\Repository\SearchCampaignRepository;
  15. use App\Repository\SearchFeedRepository;
  16. use EasyCorp\Bundle\EasyAdminBundle\Config\Action;
  17. use EasyCorp\Bundle\EasyAdminBundle\Config\Actions;
  18. use EasyCorp\Bundle\EasyAdminBundle\Config\Assets;
  19. use EasyCorp\Bundle\EasyAdminBundle\Config\Crud;
  20. use EasyCorp\Bundle\EasyAdminBundle\Config\Dashboard;
  21. use EasyCorp\Bundle\EasyAdminBundle\Config\MenuItem;
  22. use EasyCorp\Bundle\EasyAdminBundle\Config\UserMenu;
  23. use EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractDashboardController;
  24. use EasyCorp\Bundle\EasyAdminBundle\Router\AdminUrlGenerator;
  25. use Sensio\Bundle\FrameworkExtraBundle\Configuration\IsGranted;
  26. use Symfony\Component\HttpFoundation\Response;
  27. use Symfony\Component\Routing\Annotation\Route;
  28. use Symfony\Component\Security\Core\User\UserInterface;
  29. use Symfony\UX\Chartjs\Builder\ChartBuilderInterface;
  30. use Symfony\UX\Chartjs\Model\Chart;
  32. class DashboardSearchController extends AbstractDashboardController
  33. {
  34.     private SearchFeedRepository $searchFeedRepository;
  35.     private SearchCampaignRepository $campaignRepository;
  36.     private ChartBuilderInterface $chartBuilder;
  38.     public function __construct(SearchCampaignRepository $campaignRepository, SearchFeedRepository $searchFeedRepository, ChartBuilderInterface $chartBuilder, private AdminUrlGenerator $adminUrlGenerator)
  39.     {
  40.         $this->campaignRepository = $campaignRepository;
  41.         $this->searchFeedRepository = $searchFeedRepository;
  42.         $this->chartBuilder = $chartBuilder;
  43.     }
  45.     #[IsGranted('ROLE_USER')]
  46.     #[Route('/', name: 'search')]
  47.     public function index(): Response
  48.     {
  50.         $runningFeeds = $this->searchFeedRepository->findLatest();
  51.         $enabledFeeds = $this->campaignRepository->findBy(['enabled' => true]);
  52.         $lastSevenDaysUsages = $this->searchFeedRepository->lastSevenDaysUsages();
  54.         // current month
  55.         $firstDayOfMonth = (new \DateTime('first day of this month'))->format('Y-m-d');
  56.         $today = (new \DateTime('now'))->format('Y-m-d');
  57.         $currentMonthUsages = $this->searchFeedRepository->monthUsages($firstDayOfMonth, $today);
  59.         // last month
  60.         $firstDayOfLastMonth = (new \DateTime('first day of last month'))->format('Y-m-d');
  61.         $lastDayOfLastMonth = (new \DateTime('last day of last month'))->format('Y-m-d');
  62.         $lastMonthUsages = $this->searchFeedRepository->monthUsages($firstDayOfLastMonth, $lastDayOfLastMonth);
  64.         $currentMonthUsagesByAdv = $this->searchFeedRepository->monthUsagesByAdv($firstDayOfMonth, $today);
  65.         $lastMonthUsagesByAdv = $this->searchFeedRepository->monthUsagesByAdv($firstDayOfLastMonth, $lastDayOfLastMonth);
  67.         return $this->render('admin/index_search.html.twig', [
  68.             'enabledFeeds'            => $enabledFeeds,
  69.             'runningFeeds'            => $runningFeeds,
  70.             'lastSevenDaysUsages'     => $lastSevenDaysUsages,
  71.             'currentMonthUsages'      => $currentMonthUsages,
  72.             'lastMonthUsages'         => $lastMonthUsages,
  73.             'currentMonthUsagesByAdv' => $currentMonthUsagesByAdv,
  74.             'lastMonthUsagesByAdv'    => $lastMonthUsagesByAdv,
  75.             'chart'                   => $this->createChart($currentMonthUsagesByAdv),
  76.         ]);
  77.     }
  79.     public function configureDashboard(): Dashboard
  80.     {
  81.         return Dashboard::new()
  82.             ->setTitle('Overflow Admin Search');
  83.     }
  85.     public function configureUserMenu(UserInterface $user): UserMenu
  86.     {
  87.         if (!$user instanceof User) {
  88.             throw new \Exception('Wrong User');
  89.         }
  91.         return parent::configureUserMenu($user)
  92.             ->setAvatarUrl($user->getAvatarUrl())
  93.             ->
  94.             setMenuItems([
  95.                 MenuItem::linkToUrl('My Profile', 'fa fa-user', $this->generateUrl('app_profile_show'))
  96.             ]);
  97.     }
  99.     public function configureCrud(): Crud
  100.     {
  101.         return parent::configureCrud()
  102.             ->setDefaultSort([
  103.                 'id' => 'DESC',
  104.             ])
  105.             ->overrideTemplate('crud/field/id', 'admin/field/id_with_icon.html.twig');
  106.     }
  108.     public function configureMenuItems(): iterable
  109.     {
  110.         yield MenuItem::linkToDashboard('Dashboard Search', 'fa fa-dashboard');
  111.         yield MenuItem::section('Settings');
  112.         yield MenuItem::linkToCrud('Advertisers', 'fa fa-users', Advertiser::class);
  113.         yield MenuItem::linkToCrud('Search Campaings', 'fa fa-users', SearchCampaign::class);
  114.         yield MenuItem::section();
  115.         yield MenuItem::section('Search Campaings');
  116.         yield MenuItem::linkToCrud('SearchFeed Today', 'fa fa-users', SearchFeed::class)
  117.             ->setController(SearchFeedCrudTodayController::class);
  118.         yield MenuItem::linkToCrud('SearchFeed Yesterday', 'fa fa-users', SearchFeed::class)
  119.             ->setController(SearchFeedCrudYesterdayController::class);
  120.         yield MenuItem::linkToCrud('SearchFeed', 'fa fa-users', SearchFeed::class)
  121.             ->setController(SearchFeedCrudController::class);
  122.         yield MenuItem::section();
  123.         yield MenuItem::linkToCrud('SearchFeed Isp\'s', 'fa fa-tags', SearchFeedIsps::class);
  124.         yield MenuItem::linkToCrud('Hosts', 'fa fa-tags', Host::class);
  125.         yield MenuItem::linkToCrud('Available Proxy Users', 'fa fa-users', ProxyUser::class);
  126.         yield MenuItem::linkToCrud('Devices', 'fa fa-users', Device::class);
  127.         yield MenuItem::linkToCrud('Comments', 'fa fa-users', Comment::class);
  129.         yield MenuItem::section();
  130.         yield MenuItem::linkToUrl('Apag', '', '/admin');
  131.     }
  133.     public function configureActions(): Actions
  134.     {
  135.         return parent::configureActions()
  136.             ->add(Crud::PAGE_INDEX, Action::DETAIL)
  137.             ->update(Crud::PAGE_DETAIL, Action::EDIT, static function (Action $action) {
  138.                 return $action->setIcon('fa fa-edit');
  139.             })
  140.             ->update(Crud::PAGE_DETAIL, Action::INDEX, static function (Action $action) {
  141.                 return $action->setIcon('fa fa-list');
  142.             });
  143.     }
  145.     public function configureAssets(): Assets
  146.     {
  147.         return parent::configureAssets()
  148.             ->addWebpackEncoreEntry('admin');
  149.     }
  152.     private function createChart(array $currentMonthUsagesByAdv): Chart
  153.     {
  154.         $labels = [];
  155.         $sumClicks = [];
  156.         $sumRevenue = [];
  157.         $sumCosts = [];
  158.         $sumProfit = [];
  160.         foreach ($currentMonthUsagesByAdv as $data) {
  161.             // Assuming all keys are always present, if not, use null coalescing like $data['sumClicks'] ?? 0
  162.             $labels[] = $data['advertiserName'];
  163.             $sumClicks[] = (int)$data['sumClicks'];
  164.             $sumRevenue[] = (float)$data['sumCosts'];
  165.             $sumCosts[] = (float)$data['sumUsages'] * 2.7;
  166.             $sumProfit[] = (float)$data['sumCosts'] - (float)$data['sumUsages'] * 2.7;
  167.         }
  169.         $chart = $this->chartBuilder->createChart(Chart::TYPE_RADAR);
  171.         $chart->setOptions([
  172.             'plugins' => [
  173.                 'title' => [
  174.                     'display'   => true,
  175.                     'text'      => strtoupper('Usages Adv This Month'),
  176.                     'fontColor' => '#ce1111',
  177.                     'fontSize'  => 16
  178.                     //'padding' => 50
  179.                 ],
  180.             ],
  181.             'scales'  => [
  182.                 'y' => [
  183.                     'suggestedMin' => 0,
  184.                     'suggestedMax' => 100,
  185.                 ],
  186.             ],
  187.         ]);
  188.         $chart->setData([
  190.             'labels'   => $labels,
  191.             'datasets' => [
  192.                 [
  193.                     'label'           => 'Sum Clicks',
  194.                     'backgroundColor' => 'rgb(22, 99, 132, 0.2)',
  195.                     'borderColor'     => 'rgb(22, 99, 132)',
  196.                     'data'            => $sumClicks,
  197.                     'hidden'          => true,
  198.                 ],
  199.                 [
  200.                     'label'           => 'Sum Revenue',
  201.                     'backgroundColor' => 'rgb(45, 220, 126, 0.2)',
  202.                     'borderColor'     => 'rgb(45, 220, 126)',
  203.                     'data'            => $sumRevenue,
  204.                 ],
  205.                 [
  206.                     'label'           => 'Sum Costs',
  207.                     'backgroundColor' => 'rgb(255, 99, 132, 0.2)',
  208.                     'borderColor'     => 'rgb(255, 99, 132)',
  209.                     'data'            => $sumCosts,
  210.                 ],
  211.                 [
  212.                     'label' => 'Sum Profit',
  213.                     //  'backgroundColor' => 'rgb(255, 99, 132)',
  214.                     //  'borderColor'     => 'rgb(255, 99, 132)',
  215.                     'data'  => $sumProfit,
  216.                 ],
  217.             ],
  218.         ]);
  220.         return $chart;
  221.     }
  223. }