src/Controller/Admin/DashboardController.php line 673

  1. <?php
  3. namespace App\Controller\Admin;
  5. use App\Controller\Admin\PaidOrdersCrudController;
  6. use App\Controller\Admin\UnpaidOrdersCrudController;
  7. use App\Entity\Application;
  8. use App\Entity\CurrencyExchangeRate;
  9. use App\Entity\EntityLog;
  10. use App\Entity\ExportExcel;
  11. use App\Entity\FrontTheme;
  13. use App\Entity\Link;
  14. use App\Entity\LinkType;
  15. use App\Entity\LogHistory;
  16. use App\Entity\Notification;
  17. use App\Entity\Role;
  18. use App\Entity\Settings;
  19. use EasyCorp\Bundle\EasyAdminBundle\Config\Dashboard;
  20. use EasyCorp\Bundle\EasyAdminBundle\Config\MenuItem;
  21. use EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractDashboardController;
  22. use Symfony\Component\HttpFoundation\Response;
  23. use Symfony\Component\Routing\Annotation\Route;
  24. use App\Entity\User;
  25. use App\Entity\WebsiteTheme;
  26. use App\IlaveU\ShopBundle\Entity\Order\Order;
  27. use App\IlaveU\ShopBundle\Entity\Product\Product;
  28. use App\IlaveU\ShopBundle\Entity\Store\Store;
  29. use App\IlaveU\ShopBundle\Entity\Vendor\Vendor;
  30. use App\IlaveU\ShopBundle\Service\IlaveUShopStatisticProvider;
  31. use App\Repository\ApplicationRepository;
  32. use App\Service\IlaveUSettingsProvider;
  33. use Doctrine\Persistence\ManagerRegistry;
  34. use EasyCorp\Bundle\EasyAdminBundle\Config\Action;
  35. use EasyCorp\Bundle\EasyAdminBundle\Config\Actions;
  36. use Symfony\Component\Filesystem\Filesystem;
  37. use Symfony\Component\Finder\Finder;
  38. use Sensio\Bundle\FrameworkExtraBundle\Configuration\IsGranted;
  40. use App\Form\Admin\BroadcastPushNotificationType;
  41. use App\Repository\UserRepository;
  42. use App\Service\ExpoPushNotificationService;
  44. use EasyCorp\Bundle\EasyAdminBundle\Config\Assets;
  45. use EasyCorp\Bundle\EasyAdminBundle\Config\Crud;
  46. use EasyCorp\Bundle\EasyAdminBundle\Contracts\Orm\EntityRepositoryInterface;
  47. use EasyCorp\Bundle\EasyAdminBundle\Orm\EntityRepository;
  48. use Symfony\Component\HttpFoundation\Request;
  49. use Symfony\Component\HttpFoundation\RequestStack;
  51. class DashboardController extends AbstractDashboardController
  52. {
  55.     public function __construct(
  56.         private readonly ManagerRegistry $doctrine,
  57.         private readonly IlaveUShopStatisticProvider $ilaveShopStatisticProvider,
  58.         private readonly RequestStack $requestStack,
  59.     ) {}
  63.     #[Route(path: '/admin', name: 'admin_non_locale')]
  64.     public function indexNonLocale(Request $request): Response
  65.     {
  66.         return $this->redirectToRoute("admin", ["_locale" => $request->getLocale()]);
  67.     }
  70.     #[Route('/{_locale}/admin/website-theme/grapesjs_edit', name: 'website_theme_grapesjs_edit')]
  71.     public function website_theme_grapesjs_edit(): Response
  72.     {
  75.         return $this->render('@IlaveU/FrontBundle/Themes/' . $this->container->get('twig')->getGlobals()["settings"]->get()->getAssetFolderName() . '/templates/admin/website-theme/grapesjs.html.twig');
  76.     }
  77.     
  78.     
  79.     #[Route(path: '/{_locale}/admin/push-notifications/broadcast', name: 'admin_push_broadcast')]
  80.     #[IsGranted('ROLE_ADMIN_DEV')]
  81.     public function pushBroadcast(
  82.         Request $request,
  83.         UserRepository $userRepository,
  84.         ExpoPushNotificationService $expoPush,
  85.     ): Response {
  86.         $recipientCount = $userRepository->countUsersWithExponentPushToken();
  87.         $tokens = $userRepository->findDistinctExponentPushTokens();
  89.         $form = $this->createForm(BroadcastPushNotificationType::class);
  90.         $form->handleRequest($request);
  92.         if ($form->isSubmitted() && $form->isValid()) {
  93.             $data = $form->getData();
  94.             $title = (string) ($data['title'] ?? '');
  95.             $message = (string) ($data['message'] ?? '');
  97.             $result = $expoPush->sendToTokens($tokens, $title, $message);
  99.             if ($result['sent'] > 0) {
  100.                 $this->addFlash('success', sprintf(
  101.                     'Notifications envoyées : %d succès.',
  102.                     $result['sent']
  103.                 ));
  104.             }
  105.             if ($result['failed'] > 0) {
  106.                 $this->addFlash('warning', sprintf(
  107.                     'Échecs partiels : %d envoi(s) en erreur.',
  108.                     $result['failed']
  109.                 ));
  110.             }
  111.             foreach (array_slice($result['errors'], 0, 5) as $err) {
  112.                 $this->addFlash('danger', $err);
  113.             }
  115.             if ($result['sent'] === 0 && $result['failed'] === 0 && $tokens === []) {
  116.                 $this->addFlash('warning', 'Aucun utilisateur avec un token Expo enregistré.');
  117.             }
  119.             return $this->redirectToRoute('admin_push_broadcast', ['_locale' => $request->getLocale()]);
  120.         }
  122.         return $this->render('admin/push-broadcast.html.twig', [
  123.             'form' => $form->createView(),
  124.             'recipientCount' => $recipientCount,
  125.         ]);
  126.     }
  128.     #[Route(path: '/{_locale}/admin/apps-store', name: 'app_store')]
  129.     public function appStore(Request $request, ApplicationRepository $applicationRepository, IlaveUSettingsProvider $ilaveSettingsProvider): Response
  130.     {
  134.         $appsArray = [];
  136.         foreach ($applicationRepository->findAll() as $singleApp) {
  137.             $appsArray[] = [
  138.                 "id" => $singleApp->getId(),
  139.                 "name" => $singleApp->getName(),
  140.                 "image" => $singleApp->getImage(),
  141.                 "price" => $singleApp->getPrice(),
  142.                 "pageUrl" => $singleApp->getPageUrl(),
  143.             ];
  144.         }
  146.         return $this->render("admin/app-store.html.twig", [
  147.             "installedApps" => $appsArray,
  148.             "JWT" => $ilaveSettingsProvider->createJWTForUser($this->getUser())
  149.         ]);
  150.     }
  153.     #[Route(path: '/{_locale}/admin', name: 'admin')]
  154.     public function index(): Response
  155.     {
  157.         $url = $this->requestStack->getCurrentRequest()->server->get('REQUEST_URI');
  159.         
  161.         $parsedUrl = parse_url($url);
  162.         parse_str($parsedUrl['query'] ?? '', $queryParams);
  164.         if (count($queryParams) == 0) {
  165.             $queryParams['store'] = null;
  166.             $queryParams['range'] = null;
  167.             $queryParams['from'] = null;
  168.             $queryParams['to'] = null;
  169.         }
  171.         $range   = $queryParams['range'] ?? 'today';
  172.         $from    = $queryParams['from'] ?? null;
  173.         $to      = $queryParams['to'] ?? null;
  174.         $storeParam   = (int)$queryParams['store'] ?? null;
  177.         $store = null;
  178.         
  180.         
  181.         // Check if user has ROLE_STORE and get their store
  182.         if ($this->isGranted('ROLE_STORE')) {
  183.             $currentUser = $this->getUser();
  184.             if ($currentUser) {
  185.                 $storeEntity = $this->doctrine->getRepository(Store::class)->findOneBy(["user" => $currentUser]);
  186.                 $store = $storeEntity;
  187.             }
  188.         } elseif ($storeParam != 0) {
  189.             $storeEntity = $this->doctrine->getRepository(Store::class)->findOneBy(["id" => $storeParam]);
  190.             $store = $storeEntity;
  191.         }
  193.         
  194.         
  196.         //dd($request);
  198.         // Get list of stores
  199.         $stores = $this->doctrine->getRepository(Store::class)->findAll();
  209.         // Handle predefined ranges
  210.         $now = new \DateTimeImmutable();
  212.         // If custom date range provided, it overrides predefined range
  213.         if ($from && $to) {
  214.             $start = \DateTimeImmutable::createFromFormat('Y-m-d', $from)?->setTime(0, 0);
  215.             $end   = \DateTimeImmutable::createFromFormat('Y-m-d', $to)?->setTime(23, 59, 59);
  216.         } elseif ($range === 'today') {
  217.             $start = $now->modify('today')->setTime(0, 0);
  218.             $end = $now->modify('today')->setTime(23, 59, 59);
  219.         } elseif ($range === 'yesterday') {
  220.             $start = $now->modify('yesterday')->setTime(0, 0);
  221.             $end = $now->modify('yesterday')->setTime(23, 59, 59);
  222.         } elseif ($range === 'week') {
  223.             $start = $now->modify('this week')->setTime(0, 0);
  224.             $end = $now->modify('next week')->setTime(0, 0)->modify('-1 second');
  225.         } elseif ($range === 'month') {
  226.             $start = $now->modify('first day of this month')->setTime(0, 0);
  227.             $end = $now->modify('last day of this month')->setTime(23, 59, 59);
  228.         } elseif ($range === 'year') {
  229.             $start = $now->modify('first day of January')->setTime(0, 0);
  230.             $end = $now->modify('last day of December')->setTime(23, 59, 59);
  232.         } else { // Month By Default
  233.             $start = $now->modify('today')->setTime(0, 0);
  234.             $end = $now->modify('today')->setTime(23, 59, 59);
  235.         }
  241.         // If custom date range provided (overrides predefined range)
  244.         
  245.         $validOrders = $this->doctrine->getRepository(Order::class)->createQueryBuilder('orderAlias')
  246.             ->select('count(orderAlias.id)')
  248.             ->andWhere("orderAlias.status <> 'draft'")
  249.             ->andWhere("orderAlias.status <> 'cancelled'")
  250.             ->andWhere("orderAlias.statusShipping <> 'annulee'")
  251.             ->andWhere('orderAlias.createdAt BETWEEN :start AND :end')
  252.             ->setParameter('start', $start)
  253.             ->setParameter('end', $end);
  254.             if($store){
  255.                 $validOrders->andWhere("orderAlias.store = :store");
  256.                 $validOrders->setParameter('store', $store);
  257.             }
  258.             $validOrders = $validOrders->getQuery()->getSingleScalarResult();
  261.         $cancelledOrders = $this->doctrine->getRepository(Order::class)->createQueryBuilder('orderAlias')
  262.             ->select('count(orderAlias.id)')
  264.             ->andWhere("orderAlias.status = 'cancelled' OR orderAlias.statusShipping = 'annulee'")
  265.             ->andWhere('orderAlias.createdAt BETWEEN :start AND :end')
  266.             ->setParameter('start', $start)
  267.             ->setParameter('end', $end);
  268.             if($store){
  269.                 $cancelledOrders->andWhere("orderAlias.store = :store");
  270.                 $cancelledOrders->setParameter('store', $store);
  271.             }
  272.             $cancelledOrders = $cancelledOrders->getQuery()->getSingleScalarResult();
  275.         $shippedOrders = $this->doctrine->getRepository(Order::class)->createQueryBuilder('orderAlias')
  276.             ->select('count(orderAlias.id)')
  277.             ->andWhere("orderAlias.statusShipping = 'shipped'")
  278.             ->andWhere("orderAlias.status <> 'draft'")
  279.             ->andWhere("orderAlias.status <> 'cancelled'")
  280.             ->andWhere("orderAlias.statusShipping <> 'annulee'")
  281.             ->andWhere('orderAlias.createdAt BETWEEN :start AND :end')
  282.             ->setParameter('start', $start)
  283.             ->setParameter('end', $end);
  284.             if($store){
  285.                 $shippedOrders->andWhere("orderAlias.store = :store");
  286.                 $shippedOrders->setParameter('store', $store);
  287.             }
  288.             $shippedOrders = $shippedOrders->getQuery()->getSingleScalarResult();
  293.         $soldProducts =   $this->doctrine->getRepository(Order::class)->createQueryBuilder('orderAlias')
  294.             ->select('sum(orderItems.quantity)')
  295.             ->leftJoin("orderAlias.orderItems", "orderItems")
  296.             ->andWhere("orderAlias.status <> 'draft'")
  297.             ->andWhere("orderAlias.status <> 'cancelled'")
  298.             ->andWhere("orderAlias.statusShipping <> 'annulee'")
  299.             ->andWhere('orderAlias.createdAt BETWEEN :start AND :end')
  300.             ->setParameter('start', $start)
  301.             ->setParameter('end', $end);
  302.             if($store){
  303.                 $soldProducts->andWhere("orderAlias.store = :store");
  304.                 $soldProducts->setParameter('store', $store);
  305.             }
  306.             $soldProducts = $soldProducts->getQuery()->getSingleScalarResult();
  307.         $revenuedProducts =   $this->doctrine->getRepository(Order::class)->createQueryBuilder('orderAlias')
  308.             ->select('sum(orderItems.quantity * orderItems.price)')
  309.             ->leftJoin("orderAlias.orderItems", "orderItems")
  310.             ->andWhere("orderAlias.status <> 'draft'")
  311.             ->andWhere("orderAlias.status <> 'cancelled'")
  312.             ->andWhere("orderAlias.statusShipping <> 'annulee'")
  313.             ->andWhere('orderAlias.createdAt BETWEEN :start AND :end')
  314.             ->setParameter('start', $start)
  315.             ->setParameter('end', $end);
  316.             if($store){
  317.                 $revenuedProducts->andWhere("orderAlias.store = :store");
  318.                 $revenuedProducts->setParameter('store', $store);
  319.             }
  320.             $revenuedProducts = $revenuedProducts->getQuery()->getSingleScalarResult();
  322.         $averageOrderAmount = $validOrders > 0 ? $revenuedProducts / $validOrders : 0;
  327.         //$inTypes = Order::IN_TYPES;
  328.         //$outTypes = Order::OUT_TYPES;
  332.         // $productInStock = $this->doctrine->createQueryBuilder()
  333.         //     ->select('p.id AS product_id, p.name AS product_name,p.initialStock AS initial_stock')
  334.         //     ->addSelect('
  335.         //         SUM(CASE WHEN o.type IN (:inTypes) THEN oi.quantity ELSE 0 END) AS stock_in,
  336.         //         SUM(CASE WHEN o.type IN (:outTypes) THEN oi.quantity ELSE 0 END) AS stock_out,
  337.         //         (
  338.         //             p.initialStock +
  339.         //             SUM(CASE WHEN o.type IN (:inTypes) THEN oi.quantity ELSE 0 END) -
  340.         //             SUM(CASE WHEN o.type IN (:outTypes) THEN oi.quantity ELSE 0 END)
  341.         //         ) AS current_stock
  342.         //     ')
  343.         //     ->from(Product::class, 'p')
  344.         //     ->leftJoin('p.orderItems', 'oi')
  345.         //     ->leftJoin('oi.parentOrder', 'o')
  346.         //     ->groupBy('p.id')
  347.         //     ->having('
  348.         //         (
  349.         //             p.initialStock +
  350.         //             SUM(CASE WHEN o.type IN (:inTypes) THEN oi.quantity ELSE 0 END) -
  351.         //             SUM(CASE WHEN o.type IN (:outTypes) THEN oi.quantity ELSE 0 END)
  352.         //         ) > 0
  353.         //     ')
  354.         //     ->andWhere("o.status = '".Order::STATUS_VALIDATED."'")
  355.         //     //->andWhere('o.createdAt BETWEEN :start AND :end')
  356.         //     // ->setParameter('start', $start)
  357.         //     // ->setParameter('end', $end)
  358.         //     ->setMaxResults(16)
  359.         //     ->orderBy('current_stock', 'DESC')
  361.         //     ->getQuery()
  362.         //     ->getArrayResult();
  366.         $mostOrderedCategory = $this->doctrine->getRepository(Order::class)
  367.             ->createQueryBuilder('o')
  368.             ->select('c.id, c.name as categoryName, COUNT(DISTINCT o.id) as orderCount')
  369.             ->join('o.orderItems', 'oi')
  370.             ->join('oi.product', 'p')
  371.             ->join('p.categoriesProduct', 'c') // Assuming products have a many-to-many relationship with categories
  372.             ->where("o.status NOT IN ('draft', 'cancelled') AND o.statusShipping <> 'annulee'")
  373.             ->andWhere('o.createdAt BETWEEN :start AND :end')
  374.             ->groupBy('c.id, c.name')
  375.             ->orderBy('orderCount', 'DESC')
  376.             ->setMaxResults(1) // Get only the top category
  377.             ->setParameter('start', $start)
  378.             ->setParameter('end', $end);
  379.             if($store){
  380.                 $mostOrderedCategory->andWhere("o.store = :store");
  381.                 $mostOrderedCategory->setParameter('store', $store);
  382.             }
  383.             $mostOrderedCategory->getQuery()->getOneOrNullResult();
  384.             $mostOrderedCategory = $mostOrderedCategory->getQuery()->getOneOrNullResult();
  385.                     
  388.         $mostOrderedCategoryName = $mostOrderedCategory ? $mostOrderedCategory['categoryName'] : 'N/A';
  390.         // Get the most ordered product
  391.         $mostOrderedProduct = $this->doctrine->getRepository(Order::class)
  392.             ->createQueryBuilder('o')
  393.             ->select('p.id, p.name as productName, SUM(oi.quantity) as totalQuantity, COUNT(DISTINCT o.id) as orderCount')
  394.             ->join('o.orderItems', 'oi')
  395.             ->join('oi.product', 'p')
  396.             ->where("o.status NOT IN ('draft', 'cancelled') AND o.statusShipping <> 'annulee'")
  397.             ->andWhere('o.createdAt BETWEEN :start AND :end')
  398.             ->groupBy('p.id, p.name')
  399.             ->orderBy('totalQuantity', 'DESC')
  400.             ->setMaxResults(1)
  401.             ->setParameter('start', $start)
  402.             ->setParameter('end', $end);
  403.             if($store){
  404.                 $mostOrderedProduct->andWhere("o.store = :store");
  405.                 $mostOrderedProduct->setParameter('store', $store);
  406.             }
  407.             $mostOrderedProduct = $mostOrderedProduct->getQuery()->getOneOrNullResult();
  408.             
  410.         $mostOrderedProductName = $mostOrderedProduct ? $mostOrderedProduct['productName'] : 'N/A';
  412.         // Payment status stats - separate queries for different payment statuses
  413.         // Paid orders: filter by paidAt date
  414.         $paidOrdersQuery = $this->doctrine->getRepository(Order::class)->createQueryBuilder('orderAlias')
  415.             ->select('count(orderAlias.id)')
  416.             ->andWhere("orderAlias.status <> 'draft'")
  417.             ->andWhere("orderAlias.status <> 'cancelled'")
  418.             ->andWhere("orderAlias.statusShipping <> 'annulee'")
  419.             ->andWhere('orderAlias.paidAt BETWEEN :start AND :end')
  420.             ->setParameter('start', $start)
  421.             ->setParameter('end', $end);
  422.         if($store){
  423.             $paidOrdersQuery->andWhere("orderAlias.store = :store");
  424.             $paidOrdersQuery->setParameter('store', $store);
  425.         }
  426.         $paidOrders = $paidOrdersQuery->getQuery()->getSingleScalarResult();
  428.         // Unpaid orders: filter by same date range as other stats
  429.         $unpaidOrdersQuery = $this->doctrine->getRepository(Order::class)->createQueryBuilder('orderAlias')
  430.             ->select('count(orderAlias.id)')
  431.             ->andWhere("orderAlias.status <> 'draft'")
  432.             ->andWhere("orderAlias.status <> 'cancelled'")
  433.             ->andWhere("orderAlias.statusShipping = 'livree'")
  434.             ->andWhere('orderAlias.payedAmount = 0')
  435.             ->andWhere("orderAlias.status NOT IN ('paid', 'partially-paid')")
  436.             ->andWhere('orderAlias.createdAt BETWEEN :start AND :end')
  437.             ->setParameter('start', $start)
  438.             ->setParameter('end', $end);
  439.         if($store){
  440.             $unpaidOrdersQuery->andWhere("orderAlias.store = :store");
  441.             $unpaidOrdersQuery->setParameter('store', $store);
  442.         }
  443.         $unpaidOrders = $unpaidOrdersQuery->getQuery()->getSingleScalarResult();
  445.         // Calculate total amounts for paid orders (filtered by paidAt date)
  446.         $paidOrdersAmountQuery = $this->doctrine->getRepository(Order::class)->createQueryBuilder('orderAlias')
  447.             ->select('sum(orderAlias.payedAmount)')
  448.             ->andWhere("orderAlias.status <> 'draft'")
  449.             ->andWhere("orderAlias.status <> 'cancelled'")
  450.             ->andWhere("orderAlias.statusShipping <> 'annulee'")
  451.             ->andWhere('orderAlias.paidAt BETWEEN :start AND :end')
  452.             ->setParameter('start', $start)
  453.             ->setParameter('end', $end);
  454.         if($store){
  455.             $paidOrdersAmountQuery->andWhere("orderAlias.store = :store");
  456.             $paidOrdersAmountQuery->setParameter('store', $store);
  457.         }
  458.         $paidOrdersAmount = $paidOrdersAmountQuery->getQuery()->getSingleScalarResult() ?: 0;
  460.         // Calculate total amounts for unpaid orders (filtered by same date range)
  461.         $unpaidOrdersAmountQuery = $this->doctrine->getRepository(Order::class)->createQueryBuilder('orderAlias')
  462.             ->select('sum(orderItems.quantity * orderItems.price)')
  463.             ->leftJoin("orderAlias.orderItems", "orderItems")
  464.             ->andWhere("orderAlias.status <> 'draft'")
  465.             ->andWhere("orderAlias.status <> 'cancelled'")
  466.             ->andWhere("orderAlias.statusShipping = 'livree'")
  467.             ->andWhere('orderAlias.payedAmount = 0')
  468.             ->andWhere("orderAlias.status NOT IN ('paid', 'partially-paid')")
  469.             ->andWhere('orderAlias.createdAt BETWEEN :start AND :end')
  470.             ->setParameter('start', $start)
  471.             ->setParameter('end', $end);
  472.         if($store){
  473.             $unpaidOrdersAmountQuery->andWhere("orderAlias.store = :store");
  474.             $unpaidOrdersAmountQuery->setParameter('store', $store);
  475.         }
  476.         $unpaidOrdersAmount = $unpaidOrdersAmountQuery->getQuery()->getSingleScalarResult() ?: 0;
  478.         // Breakdown: paid amounts grouped by payment method
  479.         $paidByMethodQB = $this->doctrine->getRepository(Order::class)->createQueryBuilder('orderAlias')
  480.             ->select('pm.name AS methodName, pm.code AS methodCode, SUM(orderAlias.payedAmount) AS totalAmount')
  481.             ->leftJoin('orderAlias.paymentMethod', 'pm')
  482.             ->andWhere("orderAlias.status <> 'draft'")
  483.             ->andWhere("orderAlias.status <> 'cancelled'")
  484.             ->andWhere("orderAlias.statusShipping <> 'annulee'")
  485.             ->andWhere('orderAlias.paidAt BETWEEN :start AND :end')
  486.             ->groupBy('pm.id, pm.name, pm.code')
  487.             ->setParameter('start', $start)
  488.             ->setParameter('end', $end);
  489.         if ($store) {
  490.             $paidByMethodQB->andWhere('orderAlias.store = :store')->setParameter('store', $store);
  491.         }
  492.         $paidByMethod = $paidByMethodQB->getQuery()->getArrayResult();
  494.         // Breakdown: unpaid amounts grouped by payment method
  495.         $unpaidByMethodQB = $this->doctrine->getRepository(Order::class)->createQueryBuilder('orderAlias')
  496.             ->select('pm.name AS methodName, pm.code AS methodCode, SUM(orderItems.quantity * orderItems.price) AS totalAmount')
  497.             ->leftJoin('orderAlias.paymentMethod', 'pm')
  498.             ->leftJoin('orderAlias.orderItems', 'orderItems')
  499.             ->andWhere("orderAlias.status <> 'draft'")
  500.             ->andWhere("orderAlias.status <> 'cancelled'")
  501.             ->andWhere("orderAlias.statusShipping = 'livree'")
  502.             ->andWhere('orderAlias.payedAmount = 0')
  503.             ->andWhere("orderAlias.status NOT IN ('paid', 'partially-paid')")
  504.             ->andWhere('orderAlias.createdAt BETWEEN :start AND :end')
  505.             ->groupBy('pm.id, pm.name, pm.code')
  506.             ->setParameter('start', $start)
  507.             ->setParameter('end', $end);
  508.         if ($store) {
  509.             $unpaidByMethodQB->andWhere('orderAlias.store = :store')->setParameter('store', $store);
  510.         }
  511.         $unpaidByMethod = $unpaidByMethodQB->getQuery()->getArrayResult();
  513.         $stats = [
  514.             [
  515.                 'label' => 'Chiffre d\'affaires',
  516.                 'value' => (float)round($revenuedProducts, 2),
  517.                 'icon' => 'fa-coins',
  518.                 'cssClass' => 'stat-revenue',
  519.                 'description' => 'Revenu total généré par les ventes',
  520.                 'url' => null,
  521.                 'unit' => 'MAD',
  522.             ],
  523.             [
  524.                 'label' => 'Ventes',
  525.                 'value' => (int)$validOrders,
  526.                 'icon' => 'fa-calendar-check',
  527.                 'cssClass' => 'stat-monthly-orders',
  528.                 'description' => 'Nombre de ventes validées',
  529.                 'url' => null,
  530.                 'unit' => null,
  531.             ],
  532.             [
  533.                 'label' => 'Produits vendus',
  534.                 'value' => (int)$soldProducts,
  535.                 'icon' => 'fa-boxes',
  536.                 'cssClass' => 'stat-products-sold',
  537.                 'description' => 'Nombre total de produits vendus',
  538.                 'url' => null,
  539.                 'unit' => null,
  540.             ],
  541.             [
  542.                 'label' => 'Panier moyen',
  543.                 'value' => (float)round($averageOrderAmount, 2),
  544.                 'icon' => 'fa-shopping-basket',
  545.                 'cssClass' => 'stat-average-basket',
  546.                 'description' => 'Montant moyen dépensé par commande',
  547.                 'url' => null,
  548.                 'unit' => 'MAD',
  549.             ],
  550.             [
  551.                 'label' => 'Commandes annulées',
  552.                 'value' => (float)$cancelledOrders,
  553.                 'icon' => 'fa-undo',
  554.                 'cssClass' => 'stat-refunds',
  555.                 'description' => 'Nombre de commandes annulées',
  556.                 'url' => null,
  557.                 'unit' => null,
  558.             ],
  559.             [
  560.                 'label' => 'Commandes livrées',
  561.                 'value' => (float)$shippedOrders,
  562.                 'icon' => 'fa-truck',
  563.                 'cssClass' => 'stat-delivered-orders',
  564.                 'description' => 'Nombre de commandes livrées',
  565.                 'url' => null,
  566.                 'unit' => null,
  567.             ],
  568.             [
  569.                 'label' => 'Catégorie phare',
  570.                 'value' => $mostOrderedCategoryName,
  571.                 'icon' => 'fa-star',
  572.                 'cssClass' => 'stat-top-category',
  573.                 'description' => 'Catégorie la plus vendue ce mois-ci',
  574.                 'url' => null,
  575.                 'unit' => null,
  576.             ],
  578.             [
  579.                 'label' => 'Produit phare',
  580.                 'value' => $mostOrderedProductName,
  581.                 'icon' => 'fa-star',
  582.                 'cssClass' => 'stat-top-product',
  583.                 'description' => 'Produit la plus vendu ce mois-ci',
  584.                 'url' => null,
  585.                 'unit' => null,
  586.             ],
  587.             [
  588.                 'label' => 'Commandes réglées',
  589.                 'value' => $paidOrders,
  590.                 'amount' => (float)$paidOrdersAmount,
  591.                 'icon' => 'fa-check-circle',
  592.                 'cssClass' => 'stat-paid-orders',
  593.                 'description' => 'Nombre de commandes entièrement réglées',
  594.                 'url' => null,
  595.                 'unit' => null,
  596.                 'breakdown' => array_map(function(array $row) { return ['label' => $row['methodName'] ?? '—', 'amount' => (float)($row['totalAmount'] ?? 0)]; }, $paidByMethod),
  597.             ],
  598.             [
  599.                 'label' => 'Commandes à régler',
  600.                 'value' => $unpaidOrders,
  601.                 'amount' => (float)$unpaidOrdersAmount,
  602.                 'icon' => 'fa-clock',
  603.                 'cssClass' => 'stat-unpaid-orders',
  604.                 'description' => 'Nombre de commandes en attente de réglement',
  605.                 'url' => null,
  606.                 'unit' => null,
  607.                 'breakdown' => array_map(function(array $row) { return ['label' => $row['methodName'] ?? '—', 'amount' => (float)($row['totalAmount'] ?? 0)]; }, $unpaidByMethod),
  608.             ],
  609.         ];
  613.         $productLabels = [];
  614.         $productChartData = [];
  616.         // foreach ($productInStock as $product) {
  617.         //     $productLabels[] = $product['product_name'];
  618.         //     $productChartData[] = (float) $product['current_stock']; // cast to float for Chart.js
  619.         // }
  621.         // $productChartData = [
  622.         //     'labels' => $productLabels,
  623.         //     'data' => $productChartData,
  624.         // ];
  626.         return $this->render(
  627.             "bundles/EasyAdminBundle/welcome.html.twig",
  628.             [
  629.                 'stores' => $stores,
  630.                 'store' => $store,
  631.                 'stats' => $stats,
  632.                 'productChartData' => $productChartData,
  633.                 'queryParams' => $queryParams,
  634.             ]
  635.         );
  636.     }
  639.     public function configureCrud(): Crud
  640.     {
  641.         return
  642.             Crud::new()
  643.             ->setDefaultSort(["id" => 'DESC'])
  644.             ->setPaginatorPageSize(12)
  646.         ;
  647.     }
  655.     public function configureDashboard(): Dashboard
  656.     {
  658.         $mainSettings = $this->doctrine->getManager()->getRepository(Settings::class)->findOneBy(["code" => "main"]);
  659.         $nameSpaceTrans = strtolower($mainSettings->getProjectName()) . "-admin";
  663.         $urlImage = "../themes/" . strtolower($mainSettings->getAssetFolderName()) . "/admin/images/logo.png";
  666.         return Dashboard::new()
  667.             ->setTitle('<img title="Dashboard" src="' . $urlImage . '" />
  668.             
  669.             ')
  670.             //->renderContentMaximized()
  671.             ->setFaviconPath("../themes/" . strtolower($mainSettings->getAssetFolderName()) . "/admin/images/icon.png")
  672.             ->setTranslationDomain($nameSpaceTrans)
  673.             ->disableUrlSignatures()
  675.             ->setLocales(
  677.                 [
  678.                     'fr' => 'Français',
  679.                     'en' => 'English',
  680.                     'ar' => 'Arabe',
  681.                 ]
  682.             )
  685.         ;
  686.     }
  690.     public function configureMenuItems(): iterable
  691.     {
  701.         /* START : Les Extensions IlaveU */
  703.         $applications = $this->doctrine->getManager()->getRepository(Application::class)->findBy(["isEnabled" => true], ["menuOrder" => "ASC"]);
  704.         $settings = $this->doctrine->getManager()->getRepository(Settings::class)->findOneBy(["code" => "main"]);
  706.         //$finder = new Finder();
  707.         $filesystem = new Filesystem();
  708.         //$finder->directories()->in(__DIR__."/../../IlaveU")->depth('== 0');
  710.         // For Principal Bundles (ShopBundle + FrontBundle + ...) 
  711.         foreach ($applications as $singleApplication) {
  718.             $bundleExist = $filesystem->exists(__DIR__ . "/../../IlaveU/" . $singleApplication->getName() . "/IlaveU" . $singleApplication->getName() . ".php");
  721.             if (!$bundleExist) {
  722.                 continue;
  723.             }
  726.             $bundleName = $singleApplication->getName();
  729.             // Les themes systemes IlaveU (FrontBundle Themes)
  730.             if ($bundleName == "FrontBundle") {
  735.                 $bundleDashboardController = 'App\IlaveU\FrontBundle\Themes\\' . $settings->getFrontTheme() . '\Controller\DashboardController';
  736.             } else {
  737.                 $bundleDashboardController = 'App\IlaveU\\' . $bundleName . '\Controller\DashboardController';
  738.             }
  743.             $dashboard = new $bundleDashboardController();
  745.             foreach ($dashboard->configureMenuItems() as $menu) {
  746.                 yield $menu;
  747.             }
  748.         }
  752.         // For Additional Apps Bundles (POSBundle + OtherBundle + ...)
  753.         foreach ($applications as $singleApplication) {
  756.             if ($singleApplication->getParentApplication()) {
  757.                 continue;
  758.             }
  760.             $menuArray = [];
  762.             $bundleExist = $filesystem->exists(__DIR__ . "/../../IlaveU/Apps/" . $singleApplication->getName() . "/IlaveU" . $singleApplication->getName() . ".php");
  765.             if (!$bundleExist) {
  766.                 continue;
  767.             }
  770.             $bundleName = $singleApplication->getName();
  773.             $bundleDashboardController = 'App\IlaveU\Apps\\' . $bundleName . '\Controller\DashboardController';
  779.             $dashboard = new $bundleDashboardController();
  781.             foreach ($dashboard->configureMenuItems() as $menu) {
  782.                 yield $menu;
  783.             }
  784.             //SubApplications 
  785.             foreach ($singleApplication->getSubApplications() as $subApplication) {
  786.                 $bundleExist = $filesystem->exists(__DIR__ . "/../../IlaveU/Apps/" . $subApplication->getName() . "/IlaveU" . $subApplication->getName() . ".php");
  789.                 if (!$bundleExist) {
  790.                     continue;
  791.                 }
  794.                 $bundleName = $subApplication->getName();
  797.                 $bundleDashboardController = 'App\IlaveU\Apps\\' . $bundleName . '\Controller\DashboardController';
  803.                 $dashboard = new $bundleDashboardController();
  805.                 foreach ($dashboard->configureMenuItems() as $menu) {
  806.                     yield $menu;
  807.                 }
  808.             }
  809.         }
  811.         /* END : Les Extensions IlaveU */
  813.         yield MenuItem::section('Commandes');
  814.         
  815.         yield MenuItem::linkToCrud('Commandes réglées', 'fas fa-check-circle', Order::class)
  816.             ->setController(PaidOrdersCrudController::class);
  817.         yield MenuItem::linkToCrud('Commandes à payer', 'fas fa-clock', Order::class)
  818.             ->setController(UnpaidOrdersCrudController::class);
  820.         yield MenuItem::section('Parametres');
  822.         //yield MenuItem::linkToRoute('Theme Designer', 'fas fa-shield-alt', "website_theme_grapesjs_edit")->setPermission("ROLE_ADMIN_DEV");
  823.         yield MenuItem::linkToRoute('Apps Store', 'fas fa-shield-alt', "app_store")->setPermission("ROLE_ADMIN_DEV");
  824.         yield MenuItem::linkToCrud('Utilisateurs', 'fas fa-shield-alt', User::class)->setController(UserCrudController::class);
  825.         yield MenuItem::linkToCrud('Passwords', 'fas fa-shield-alt', User::class)->setController(UserPasswordCrudController::class);
  826.         //yield MenuItem::linkToCrud('Roles', 'fas fa-shield-alt', Role::class);
  827.         //yield MenuItem::linkToCrud('LinkType', 'fas fa-gears', LinkType::class)->setPermission("ROLE_ADMIN_DEV");
  828.         // yield MenuItem::linkToCrud('Link', 'fas fa-gears', Link::class)->setPermission("ROLE_ADMIN_DEV");
  829.         //yield MenuItem::linkToCrud('Applications', 'fas fa-shield-alt', Application::class)->setPermission("ROLE_ADMIN_DEV");
  830.         yield MenuItem::linkToCrud('Notifications', 'fas fa-shield-alt', Notification::class)->setPermission("ROLE_ADMIN_DEV");
  831.         yield MenuItem::linkToRoute('Push mobile (tous)', 'fas fa-mobile-screen-button', 'admin_push_broadcast')->setPermission("ROLE_ADMIN_DEV");
  832.         yield MenuItem::linkToRoute('Text to speech', 'fas fa-shield-alt', "open_ai_tts")->setPermission("ROLE_ADMIN_DEV");
  837.         yield MenuItem::linkToCrud('Historique', 'fas fa-shield-alt', EntityLog::class)->setPermission("ROLE_ADMIN");
  838.         //yield MenuItem::linkToCrud('Settings', 'fas fa-shield-alt', Settings::class)
  839.          //   ->setAction("edit")
  840.          //   ->setEntityId($settings->getId());
  841.        // yield MenuItem::linkToCrud('Currency Exchange', 'fas fa-shield-alt', CurrencyExchangeRate::class);
  842.         //yield MenuItem::linkToCrud('Web site theme', 'fas fa-shield-alt', WebsiteTheme::class)->setPermission("ROLE_ADMIN_DEV");
  843.        // yield MenuItem::linkToCrud('Front Themes', 'fas fa-shield-alt', FrontTheme::class)->setPermission("ROLE_ADMIN_DEV");
  844.         yield MenuItem::linkToCrud('Export Excel', 'fas fa-shield-alt', ExportExcel::class)->setController(ExportExcelCrudController::class)->setPermission("ROLE_ADMIN_DEV");
  845.     }
  846. }