src/Controller/Admin/DashboardController.php line 418

Open in your IDE?
  1. <?php
  3. namespace App\Controller\Admin;
  5. use App\Entity\Activity;
  6. use App\Repository\ActivityRepository;
  7. use App\Repository\CommentRepository;
  8. use App\Repository\ProduitDeclinationValueRepository;
  9. use App\Repository\ProduitRepository;
  10. use App\Repository\UserRepository;
  11. use App\Repository\DocumentRepository;
  12. use Doctrine\ORM\EntityManagerInterface;
  13. use PDO;
  14. use Psr\Log\LoggerInterface;
  15. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  16. use Symfony\Component\HttpFoundation\JsonResponse;
  17. use Symfony\Component\HttpFoundation\Response;
  18. use Symfony\Component\Routing\Annotation\Route;
  19. use App\Service\GlobalVariables;
  20. use App\Entity\User;
  21. use App\Form\UserAddType;
  22. use Symfony\Component\HttpFoundation\Request;
  24. use Doctrine\DBAL\Types\Types;
  26. class DashboardController extends AbstractController {
  28.     private $produitRepository;
  30.     public function __construct(
  31.             ProduitRepository $produitRepository,
  32.             ActivityRepository  $activityRepository,
  33.             CommentRepository $commentRepository,
  34.             UserRepository $userRepository,
  35.             ProduitDeclinationValueRepository $produitDeclinationValueRepository,
  36.             DocumentRepository $documentRepository,
  37.             GlobalVariables $globalVariables
  38.     ) {
  39.         $this->produitRepository = $produitRepository;
  40.         $this->activityRepository = $activityRepository;
  41.         $this->commentRepository = $commentRepository;
  42.         $this->userRepository = $userRepository;
  43.         $this->produitDeclinationValueRepository = $produitDeclinationValueRepository;
  44.         $this->produitRepository = $produitRepository;
  45.         $this->documentRepository = $documentRepository;
  46.         $this->globalVariables = $globalVariables;
  48.     }
  50.     /**
  51.      * @Route("/index", name="index")
  52.      */
  53.     public function index(EntityManagerInterface $em): Response {
  54.         $user = $this->getUser();
  55.         $now = new \DateTime("now");
  57.         // *** nouveaux totaux
  58.         $totalVenteAvecFrais = 0.0;    // somme TTC
  59.         $totalVenteSansFrais = 0.0;    // somme TTC - frais livraison
  60.         $totalVente = 0.0;             // legacy (on le gardera = avec frais)
  62.         if ($user && in_array("ROLE_SUPER_ADMIN", $user->getRoles())) {
  63.             $todayActivities = $this->activityRepository->findByCreatedAtField($now, 100);
  65.             $DcumentsByStatus = $this->documentRepository->findByCreatedAtField($now, []);
  66.             foreach ($DcumentsByStatus as $key => $document) {
  67.                 // *** calcule les deux totaux
  68.                 $ttc   = (float) ($document->getTotalAmountTtc() ?? 0);
  69.                 $frais = 0.0;
  70.                 if (method_exists($document, 'getDelivery') && $document->getDelivery()) {
  71.                     $frais = (float) ($document->getDelivery()->getTotalPrice() ?? 0);
  72.                 }
  73.                 $totalVenteAvecFrais += $ttc;
  74.                 $totalVenteSansFrais += ($ttc - $frais);
  75.             }
  76.             // *** compat : l’ancienne variable = total avec frais
  77.             $totalVente = $totalVenteAvecFrais;
  79.             $lastDayActivities = $this->activityRepository->findByCreatedAtField(new \DateTime("-1 day"), 100);
  81.             // Par défaut : toute la semaine
  82.             $startLog = $_GET['log_start'] ?? (new \DateTime())->modify('monday this week')->format('Y-m-d');
  83.             $endLog   = $_GET['log_end']   ?? (new \DateTime())->modify('sunday this week')->format('Y-m-d');
  85.             try {
  86.                 $logEventsActivities = $this->activityRepository->LoginEventRange(
  87.                     new \DateTime($startLog),
  88.                     new \DateTime($endLog)
  89.                 );
  90.             } catch (\Exception $e) {
  91.                 $logEventsActivities = [];
  92.             }
  94.             $lastDaylogEventsActivities = $this->activityRepository->LoginEvent(new \DateTime("-1 day"), 100);
  95.         } else {
  96.             $todayActivities = $user->getActivities()->filter(function (Activity $act) use ($now) {
  97.                 return $act->getCreatedAt() == $now;
  98.             });
  99.             $lastDayActivities = $user->getActivities()->filter(function (Activity $act) {
  100.                 return $act->getCreatedAt() == new \DateTime("-1 day");
  101.             });
  102.         }
  104.         $comments      = $this->commentRepository->findLatestComments(20);
  105.         $latestClients = $this->userRepository->findLatestUsers(10, 'client');
  106.         $countProduitDec = $this->produitDeclinationValueRepository->countProduitDeclinations(null, null, null, [], null, null, null, true, null, null, null, null, null, null, null, null);
  107.         $countProduit  = $this->produitRepository->countProduits(null, null, null, true, null);
  108.         $countClient   = $this->userRepository->countUsers(null, null, 'client');
  109.         $nbCommandeJour = $this->documentRepository->countCommandesForToday();
  110.         $nbUsersConnectes = $this->activityRepository->countTodayLogins(); // à créer
  112.         $startOfWeek   = (new \DateTime())->modify('monday this week')->setTime(0, 0, 0);
  113.         $endOfWeek     = (new \DateTime())->modify('sunday this week')->setTime(23, 59, 59);
  114.         $weekActivities = $this->activityRepository->findBetweenDates($startOfWeek, $endOfWeek);
  116.         $customActivities = [];
  117.         $startStr = $_GET['start'] ?? null;
  118.         $endStr   = $_GET['end'] ?? null;
  120.         if ($startStr && $endStr) {
  121.             try {
  122.                 $startDate = new \DateTime($startStr);
  123.                 $endDate   = new \DateTime($endStr);
  124.                 $customActivities = $this->activityRepository->findBetweenDates($startDate, $endDate);
  125.             } catch (\Exception $e) {
  126.                 // Gérer une erreur de date invalide si besoin
  127.             }
  128.         }
  130.         $activeTab = 'today'; // onglet par défaut
  131.         if ($startStr && $endStr) {
  132.             $activeTab = 'custom'; // si période personnalisée
  133.         }
  135.         $selectedUserId = $_GET['log_user'] ?? 'all';
  136.         if ($selectedUserId !== 'all') {
  137.             $selectedUserId = (int) $selectedUserId;
  138.         }
  140.         $logEventsActivities = [];
  142.         $startLog = $_GET['log_start'] ?? (new \DateTime())->modify('monday this week')->format('Y-m-d');
  143.         $endLog   = $_GET['log_end']   ?? (new \DateTime())->modify('sunday this week')->format('Y-m-d');
  145.         try {
  146.             $startDate = new \DateTime($startLog);
  147.             $endDate   = new \DateTime($endLog);
  149.             if ($selectedUserId === 'all') {
  150.                 $logEventsActivities = $this->activityRepository->LoginEventRange($startDate, $endDate);
  151.             } else {
  152.                 $logEventsActivities = $this->activityRepository->LoginEventRangeByUser($startDate, $endDate, $selectedUserId);
  153.             }
  154.         } catch (\Exception $e) {
  155.             $logEventsActivities = [];
  156.         }
  158.         return $this->render('@admin/dashboard/dashboard.html.twig', [
  159.             'todayActivities' => $todayActivities,
  160.             'weekActivities' => $weekActivities,
  161.             'customActivities' => $customActivities,
  162.             'activeTab' => $activeTab,
  163.             'lastDayActivities' => $lastDayActivities,
  164.             'logEventsActivities' => $logEventsActivities ?? null,
  165.             'log_start' => $startLog,
  166.             'log_end' => $endLog,
  167.             'lastDaylogEventsActivities' => $lastDaylogEventsActivities ?? null,
  169.             // *** sorties totaux
  170.             'totalVente' => $totalVente,                         // legacy (avec frais)
  171.             'totalVenteAvecFrais' => $totalVenteAvecFrais,       // nouveau
  172.             'totalVenteSansFrais' => $totalVenteSansFrais,       // nouveau
  174.             'comments' => $comments,
  175.             'latestClients' => $latestClients,
  176.             'countProduitDec' => $countProduitDec,
  177.             'countProduit' => $countProduit,
  178.             'countClient' => $countClient,
  179.             'nbCommandeJour' => $nbCommandeJour,
  180.             'nbUsersConnectes' => $nbUsersConnectes,
  181.             'log_user' => $selectedUserId,
  182.             'users' => $this->userRepository->findLightUsers(),
  183.         ]);
  184.     }
  186.     
  187.    /**
  188.      * @Route("/admin/dashboard/activities", name="dashboard_activities_timeline", methods={"GET"})
  189.      */
  190.     public function activitiesTimeline(Request $request, EntityManagerInterface $em): Response
  191.     {
  192.         // Accès (même logique que ton écran) : SUPER_ADMIN ou droit STATISTIQUE si dispo.
  193.         $user = $this->getUser();
  194.         $can  = $user && in_array('ROLE_SUPER_ADMIN', (array)$user->getRoles(), true);
  195.         if (!$can && $user && method_exists($user, 'getArrayRight')) {
  196.             $can = in_array('STATISTIQUE', (array)$user->getArrayRight(), true);
  197.         }
  198.         if (!$can) {
  199.             return new Response('Forbidden', 403);
  200.         }
  202.         $tz     = new \DateTimeZone('Africa/Tunis');
  203.         $now    = new \DateTimeImmutable('now', $tz);
  204.         $period = (string) $request->query->get('period', 'today');
  206.         // défaut : aujourd’hui
  207.         $start = $now->setTime(0, 0, 0);
  208.         $end   = $now->setTime(23, 59, 59);
  210.         switch ($period) {
  211.             case '3days':
  212.                 $end   = $now->setTime(23,59,59);
  213.                 $start = $end->sub(new \DateInterval('P2D'))->setTime(0,0,0);
  214.                 break;
  215.             case '7days':
  216.                 $end   = $now->setTime(23,59,59);
  217.                 $start = $end->sub(new \DateInterval('P6D'))->setTime(0,0,0);
  218.                 break;
  219.             case '30days':
  220.                 $end   = $now->setTime(23,59,59);
  221.                 $start = $end->sub(new \DateInterval('P29D'))->setTime(0,0,0);
  222.                 break;
  223.             case 'week':
  224.                 $start = (new \DateTimeImmutable('monday this week', $tz))->setTime(0,0,0);
  225.                 $end   = $now->setTime(23,59,59);
  226.                 break;
  227.             case 'last_week':
  228.                 $start = (new \DateTimeImmutable('monday last week', $tz))->setTime(0,0,0);
  229.                 $end   = (new \DateTimeImmutable('sunday last week', $tz))->setTime(23,59,59);
  230.                 break;
  231.             case 'month':
  232.                 $start = (new \DateTimeImmutable('first day of this month', $tz))->setTime(0,0,0);
  233.                 $end   = $now->setTime(23,59,59);
  234.                 break;
  235.             case 'last_month':
  236.                 $start = (new \DateTimeImmutable('first day of last month', $tz))->setTime(0,0,0);
  237.                 $end   = (new \DateTimeImmutable('last day of last month', $tz))->setTime(23,59,59);
  238.                 break;
  239.             case 'year':
  240.                 $start = (new \DateTimeImmutable('first day of january', $tz))->setTime(0,0,0);
  241.                 $end   = $now->setTime(23,59,59);
  242.                 break;
  243.             case 'last_year':
  244.                 $start = (new \DateTimeImmutable('first day of january last year', $tz))->setTime(0,0,0);
  245.                 $end   = (new \DateTimeImmutable('last day of december last year', $tz))->setTime(23,59,59);
  246.                 break;            
  247.             case 'custom': {
  248.                 $s = $request->query->get('start');
  249.                 $e = $request->query->get('end');
  250.                 if ($s && $e) {
  251.                     try {
  252.                         $start = (new \DateTimeImmutable($s, $tz))->setTime(0,0,0);
  253.                         $end   = (new \DateTimeImmutable($e, $tz))->setTime(23,59,59);
  254.                         if ($end < $start) { [$start, $end] = [$end, $start]; }
  255.                     } catch (\Throwable $ex) { /* on garde today */ }
  256.                 }
  257.                 break;
  258.             }
  259.             // today => défaut
  260.         }
  262.         // Requête explicite, bornes inclusives, SANS limite cachée
  263.         $qb = $em->createQueryBuilder()
  264.             ->select('a','u','p','d')
  265.             ->from(Activity::class, 'a')
  266.             ->leftJoin('a.currentUser', 'u')
  267.             ->leftJoin('a.produit', 'p')
  268.             ->leftJoin('a.document', 'd')
  269.             ->andWhere('a.createdAt >= :start')
  270.             ->andWhere('a.createdAt <= :end')
  271.             ->setParameter('start', \DateTime::createFromImmutable($start))
  272.             ->setParameter('end',   \DateTime::createFromImmutable($end))
  273.             ->orderBy('a.createdAt', 'DESC');
  275.         $qb->setMaxResults(null); // safety: pas de cap
  277.         $activities = $qb->getQuery()->getResult();
  279.         $html = $this->renderView('@admin/dashboard/_activities_timeline.html.twig', [
  280.             'activities' => $activities,
  281.         ]);
  283.         return new Response($html, 200, ['Content-Type' => 'text/html; charset=UTF-8']);
  284.     }
  286.     
  288.     /**
  289.      * @Route("/admin/dashboard/login-history", name="dashboard_login_history", methods={"GET"})
  290.      */
  291.     public function loginHistory(Request $request): Response
  292.     {
  293.         // Accès : SUPER_ADMIN ou droit 'STATISTIQUE' dans arrayRight
  294.         $user = $this->getUser();
  295.         $can  = $user && in_array('ROLE_SUPER_ADMIN', (array)$user->getRoles(), true);
  296.         if (!$can && $user && method_exists($user, 'getArrayRight')) {
  297.             $can = in_array('STATISTIQUE', (array)$user->getArrayRight(), true);
  298.         }
  299.         if (!$can) {
  300.             return new Response('Forbidden', 403);
  301.         }
  303.         $tz     = new \DateTimeZone('Africa/Tunis');
  304.         $now    = new \DateTimeImmutable('now', $tz);
  305.         $period = (string) $request->query->get('period', 'today');
  306.         $logUser = $request->query->get('log_user', 'all');
  308.         // Par défaut : aujourd’hui (00:00 → 23:59:59)
  309.         $start = $now->setTime(0, 0, 0);
  310.         $end   = $now->setTime(23, 59, 59);
  312.         switch ($period) {
  313.             case '3days':
  314.                 $end   = $now->setTime(23,59,59);
  315.                 $start = $end->sub(new \DateInterval('P2D'))->setTime(0,0,0);
  316.                 break;
  317.             case '7days':
  318.                 $end   = $now->setTime(23,59,59);
  319.                 $start = $end->sub(new \DateInterval('P6D'))->setTime(0,0,0);
  320.                 break;
  321.             case '30days':
  322.                 $end   = $now->setTime(23,59,59);
  323.                 $start = $end->sub(new \DateInterval('P29D'))->setTime(0,0,0);
  324.                 break;
  325.             case 'week':
  326.                 $start = (new \DateTimeImmutable('monday this week', $tz))->setTime(0,0,0);
  327.                 $end   = $now->setTime(23,59,59);
  328.                 break;
  329.             case 'last_week':
  330.                 $start = (new \DateTimeImmutable('monday last week', $tz))->setTime(0,0,0);
  331.                 $end   = (new \DateTimeImmutable('sunday last week', $tz))->setTime(23,59,59);
  332.                 break;
  333.             case 'month':
  334.                 $start = (new \DateTimeImmutable('first day of this month', $tz))->setTime(0,0,0);
  335.                 $end   = $now->setTime(23,59,59);
  336.                 break;
  337.             case 'last_month':
  338.                 $start = (new \DateTimeImmutable('first day of last month', $tz))->setTime(0,0,0);
  339.                 $end   = (new \DateTimeImmutable('last day of last month', $tz))->setTime(23,59,59);
  340.                 break;
  341.             case 'year':
  342.                 $start = (new \DateTimeImmutable('first day of january', $tz))->setTime(0,0,0);
  343.                 $end   = $now->setTime(23,59,59);
  344.                 break;
  345.             case 'last_year':
  346.                 $start = (new \DateTimeImmutable('first day of january last year', $tz))->setTime(0,0,0);
  347.                 $end   = (new \DateTimeImmutable('last day of december last year', $tz))->setTime(23,59,59);
  348.                 break;
  349.             case 'custom':
  350.                 $s = $request->query->get('start');
  351.                 $e = $request->query->get('end');
  352.                 if ($s && $e) {
  353.                     try {
  354.                         $start = (new \DateTimeImmutable($s, $tz))->setTime(0,0,0);
  355.                         $end   = (new \DateTimeImmutable($e, $tz))->setTime(23,59,59);
  356.                         if ($end < $start) { [$start, $end] = [$end, $start]; }
  357.                     } catch (\Throwable $ex) { /* on conserve today */ }
  358.                 }
  359.                 break;
  360.             // today => défaut
  361.         }
  363.         // Utilise tes méthodes existantes du repository
  364.         if ($logUser === 'all') {
  365.             $events = $this->activityRepository->LoginEventRange(
  366.                 \DateTime::createFromImmutable($start),
  367.                 \DateTime::createFromImmutable($end)
  368.             );
  369.         } else {
  370.             $events = $this->activityRepository->LoginEventRangeByUser(
  371.                 \DateTime::createFromImmutable($start),
  372.                 \DateTime::createFromImmutable($end),
  373.                 (int) $logUser
  374.             );
  375.         }
  377.         $html = $this->renderView('@admin/dashboard/_login_events_list.html.twig', [
  378.             'events' => $events
  379.         ]);
  381.         return new Response($html);
  382.     }
  386.     
  387.     /**
  388.      * @Route("/page", name="page")
  389.      */
  390.     public function page(): Response {
  391.         $produits = $this->produitRepository->findWithImage();
  392.         return $this->render('@admin/front/page.html.twig', [
  393.                     'produits' => $produits
  394.         ]);
  395.     }
  397.     public static function ddQuery($sql,EntityManagerInterface $em)
  398.     {
  399.         //$sql = " select @@sql_mode";
  400.         $stmt = $em->getConnection()->prepare($sql);
  401.         $result = $stmt->executeQuery()->fetchAllAssociative();
  402.         dd($result);
  403.     }
  405.     /**
  406.      * @Route("/count-document/{type}/{status}", name="count-document", methods={"GET","POST"}, options={"expose"=true})
  407.      */
  408.     public function countDocument($type="commande",$status="en-attente"): Response {
  409.         return new JsonResponse(array(
  410.             'result' => 1,
  411.             'message' => "{type:'$type',status:'$status'}",
  412.             'count' =>  $this->globalVariables->getCountDocumentByType($type,$status)['count']));
  413.     }
  415.     /**
  416.      * @Route("/time-server", name="timeServer", methods={"GET","POST"}, options={"expose"=true})
  417.      */
  418.     public function getTimeServer(): Response {
  419.         return new JsonResponse(array(
  420.             'result' => 1,
  421.             'message' => 'ok',
  422.             'data' => (new \DateTime('now'))->format("Y-m-d\\TH:i:s")));
  423.     }
  424.     /**
  425.      * @Route("/copy-db", name="copydatabase")
  426.      */
  427.     public function copyDB( LoggerInterface $logger): Response{
  428.         $sourceDbName = 'sunshiladmin';
  429.         $destinationDbName = 'sunshiladmindemo';
  430.         $connectionSource = new PDO('mysql:host=sunshiladmin.mysql.db;dbname=sunshiladmin', 'sunshiladmin', 'SunshineElegance192510185');
  431.         $connectionDestination = new PDO('mysql:host=sunshiladmindemo.mysql.db;dbname=sunshiladmindemo' , 'sunshiladmindemo', 'adminDemo2022');
  432.         $tables = $connectionSource->query("SHOW TABLES")->fetchAll(PDO::FETCH_COLUMN);
  433.         $connectionDestination->exec("USE {$destinationDbName}");
  434.         foreach ($tables as $tableName) {
  435.             $createCommand = $connectionSource->query("SHOW CREATE TABLE `{$sourceDbName}`.`{$tableName}`")->fetchColumn(1);
  436.             $carefulCreateCommand = str_replace("CREATE TABLE", "CREATE TABLE IF NOT EXISTS", $createCommand);
  437.             $connectionDestination->exec($carefulCreateCommand);
  438.             $logger->info("Table `{$tableName}` created" . PHP_EOL);
  439.             $connectionDestination->exec("INSERT INTO `{$destinationDbName}`.`{$tableName}` SELECT * FROM `{$sourceDbName}`.`{$tableName}`");
  440.             $logger->info("Data for table `{$tableName}` copied" . PHP_EOL);
  441.         }
  442.         return new Response("<html><head></head><body>done</body></html>");
  443.     }
  445. }