src/Controller/Admin/DashboardController.php line 27

Open in your IDE?
  1. <?php
  3. namespace App\Controller\Admin;
  5. use App\Entity\User;
  6. use App\Entity\Expert;
  7. use App\Entity\Specie;
  8. use App\Entity\Country;
  9. use App\Entity\Organism;
  10. use App\Entity\SpecieArea;
  11. use App\Entity\GeneralSkill;
  12. use App\Entity\ExpertAreaSpecie;
  13. use App\Repository\ExpertRepository;
  14. use Symfony\Component\HttpFoundation\Response;
  15. use Symfony\Component\Routing\Annotation\Route;
  16. use EasyCorp\Bundle\EasyAdminBundle\Config\MenuItem;
  17. use EasyCorp\Bundle\EasyAdminBundle\Config\Dashboard;
  18. use EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractDashboardController;
  20. class DashboardController extends AbstractDashboardController
  21. {
  22.     /**
  23.      * @Route("/admin", name="admin")
  24.      */
  25.     public function index(): Response
  26.     {
  27.         $entityManager = $this->getDoctrine()->getManager();
  29.         $expertRepository = $entityManager->getRepository(Expert::class);
  30.         $entitiesExperts = $expertRepository->findAll();
  31.         $nbCountries = 0;
  32.         $countries =array();
  33.         foreach ($entitiesExperts as $entityExpert)
  34.         {
  35.             if (!in_array($entityExpert->getCountry(),$countries)) array_push($countries,$entityExpert->getCountry());
  36.         }
  37.         $nbCountries = count($countries);
  38.         $entitiesSpecies = $entityManager->getRepository(Specie::class)->findAll();
  39.         $entitiesSpecieArea = $entityManager->getRepository(SpecieArea::class)->findAll();
  40.         // $datas=$expertRepository->getCountByCountry();
  41.         // $dataCountries=$this->generateGraphe("Country","pie","chartContainer1",$datas);
  42.         // $datas=$entityManager->getRepository(ExpertAreaSpecie::class)->getCountBy("specie");
  43.         // $dataGS=$this->generateGraphe("Specie","pie","chartContainer2",$datas);
  44.         return $this->render('admin/dashboard.html.twig', [
  45.             'entitiesExperts' => $entitiesExperts,
  46.             'entitiesSpecies' => $entitiesSpecies,
  47.             'entitiesSpecieArea' => $entitiesSpecieArea,
  48.             'nbCountries' => $nbCountries,
  49.             // 'dataCountries' => $dataCountries,
  50.             // 'dataGS' => $dataGS,
  51.         ]);
  52.     }
  54.     public function configureDashboard(): Dashboard
  55.     {
  56.         return Dashboard::new()
  57.             ->setTitle('Eurcaw Experts');
  58.     }
  60.     public function configureMenuItems(): iterable
  61.     {
  62.         yield MenuItem::linkToRoute('Home', 'fa fa-home','accueil');
  63.         yield MenuItem::linkToDashboard('Dashboard', 'fa fa-home');
  64.         yield MenuItem::linkToCrud('Experts', 'fas fa-users', Expert::class);
  65.         yield MenuItem::linkToCrud('User', 'fas fa-user', User::class);
  66.         yield MenuItem::linkToCrud('General Skills', 'fas fa-graduation-cap', GeneralSkill::class);
  67.         yield MenuItem::linkToCrud('Species Area', 'fas fa-list', SpecieArea::class);
  68.         yield MenuItem::linkToCrud('Species', 'fas fa-list', Specie::class);
  69.         yield MenuItem::linkToCrud('Organism', 'fas fa-list', Organism::class);
  70.         yield MenuItem::linkToCrud('Country', 'fas fa-list', Country::class);
  71.         // yield MenuItem::linkToCrud('The Label', 'fas fa-list', EntityClass::class);
  72.     }
  74.     public function generateGraphe($champ,$type,$container,$datas)
  75.     {
  76.         $color="";
  77.         $color="'#82C46C','#791CF8','#9D3E0C','#BBAE98','#79F8F8','#83A697','#FDEE00','#EF9B0F','#E73E01'";
  78.         $data='<div style="width: 100%; display: inline-block;margin-right: 50px;"><canvas style="background-color: #ffffff;" id="'.$container.'" class="chartjs"></canvas></div>
  79.         <script>
  80.         new Chart(
  81.             document.getElementById("'.$container.'"),
  82.             {
  83.                 type:"'.$type.'",
  84.         
  85.                 data:
  86.                 {
  87.                     labels:[';
  88.         foreach($datas as $ligne) 
  89.         {
  90.             $func = "get" . $champ;
  91.             if ($ligne[0]->{$func}()=="") $data.="'NA',";
  92.             else $data.="'".$ligne[0]->{$func}()."',";
  93.         }
  94.         $data.='],
  95.                     datasets:
  96.                     [
  97.                         {
  98.                             "label":"",
  99.                             "data":[';
  100.         foreach($datas as $ligne) $data.= "'".$ligne["nb"]. "',";
  101.         $data.='],
  102.                             "fill":false,
  103.                             "backgroundColor":['.$color.'],
  104.                             "borderColor":['.$color.'],
  105.                             "borderWidth":1
  106.                         }
  107.                     ]
  108.                 },
  109.                 options:
  110.                 {
  111.                     scales:
  112.                     {
  113.                         yAxes:
  114.                         [
  115.                             {
  116.                                 ticks:
  117.                                 {
  118.                                     beginAtZero:true
  119.                                 }
  120.                             }
  121.                         ]
  122.                     }
  123.                 }
  124.             }
  125.         );
  126.         </script>';
  127.         return $data;
  128.     }
  129. }