src/Controller/Admin/DashboardController.php line 119

  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 EasyCorp\Bundle\EasyAdminBundle\Config\Assets;
  41. use EasyCorp\Bundle\EasyAdminBundle\Config\Crud;
  42. use EasyCorp\Bundle\EasyAdminBundle\Contracts\Orm\EntityRepositoryInterface;
  43. use EasyCorp\Bundle\EasyAdminBundle\Orm\EntityRepository;
  44. use Symfony\Component\HttpFoundation\Request;
  45. use Symfony\Component\HttpFoundation\RequestStack;
  47. class DashboardController extends AbstractDashboardController
  48. {
  51.     public function __construct(
  52.         private readonly ManagerRegistry $doctrine,
  53.         private readonly IlaveUShopStatisticProvider $ilaveShopStatisticProvider,
  54.         private readonly RequestStack $requestStack,
  55.     ) {}
  59.     #[Route(path: '/admin', name: 'admin_non_locale')]
  60.     public function indexNonLocale(Request $request): Response
  61.     {
  62.         return $this->redirectToRoute("admin", ["_locale" => $request->getLocale()]);
  63.     }
  66.     #[Route('/{_locale}/admin/website-theme/grapesjs_edit', name: 'website_theme_grapesjs_edit')]
  67.     public function website_theme_grapesjs_edit(): Response
  68.     {
  71.         return $this->render('@IlaveU/FrontBundle/Themes/' . $this->container->get('twig')->getGlobals()["settings"]->get()->getAssetFolderName() . '/templates/admin/website-theme/grapesjs.html.twig');
  72.     }
  75.     #[Route(path: '/{_locale}/admin/apps-store', name: 'app_store')]
  76.     public function appStore(Request $request, ApplicationRepository $applicationRepository, IlaveUSettingsProvider $ilaveSettingsProvider): Response
  77.     {
  81.         $appsArray = [];
  83.         foreach ($applicationRepository->findAll() as $singleApp) {
  84.             $appsArray[] = [
  85.                 "id" => $singleApp->getId(),
  86.                 "name" => $singleApp->getName(),
  87.                 "image" => $singleApp->getImage(),
  88.                 "price" => $singleApp->getPrice(),
  89.                 "pageUrl" => $singleApp->getPageUrl(),
  90.             ];
  91.         }
  93.         return $this->render("admin/app-store.html.twig", [
  94.             "installedApps" => $appsArray,
  95.             "JWT" => $ilaveSettingsProvider->createJWTForUser($this->getUser())
  96.         ]);
  97.     }
  100.     #[Route(path: '/{_locale}/admin', name: 'admin')]
  101.     public function index(): Response
  102.     {
  104.         $url = $this->requestStack->getCurrentRequest()->server->get('REQUEST_URI');
  106.         
  108.         $parsedUrl = parse_url($url);
  109.         parse_str($parsedUrl['query'] ?? '', $queryParams);
  111.         if (count($queryParams) == 0) {
  112.             $queryParams['store'] = null;
  113.             $queryParams['range'] = null;
  114.             $queryParams['from'] = null;
  115.             $queryParams['to'] = null;
  116.         }
  118.         $range   = $queryParams['range'] ?? 'today';
  119.         $from    = $queryParams['from'] ?? null;
  120.         $to      = $queryParams['to'] ?? null;
  121.         $storeParam   = (int)$queryParams['store'] ?? null;
  124.         $store = null;
  125.         
  127.         
  128.         // Check if user has ROLE_STORE and get their store
  129.         if ($this->isGranted('ROLE_STORE')) {
  130.             $currentUser = $this->getUser();
  131.             if ($currentUser) {
  132.                 $storeEntity = $this->doctrine->getRepository(Store::class)->findOneBy(["user" => $currentUser]);
  133.                 $store = $storeEntity;
  134.             }
  135.         } elseif ($storeParam != 0) {
  136.             $storeEntity = $this->doctrine->getRepository(Store::class)->findOneBy(["id" => $storeParam]);
  137.             $store = $storeEntity;
  138.         }
  140.         
  141.         
  143.         //dd($request);
  145.         // Get list of stores
  146.         $stores = $this->doctrine->getRepository(Store::class)->findAll();
  156.         // Handle predefined ranges
  157.         $now = new \DateTimeImmutable();
  159.         // If custom date range provided, it overrides predefined range
  160.         if ($from && $to) {
  161.             $start = \DateTimeImmutable::createFromFormat('Y-m-d', $from)?->setTime(0, 0);
  162.             $end   = \DateTimeImmutable::createFromFormat('Y-m-d', $to)?->setTime(23, 59, 59);
  163.         } elseif ($range === 'today') {
  164.             $start = $now->modify('today')->setTime(0, 0);
  165.             $end = $now->modify('today')->setTime(23, 59, 59);
  166.         } elseif ($range === 'yesterday') {
  167.             $start = $now->modify('yesterday')->setTime(0, 0);
  168.             $end = $now->modify('yesterday')->setTime(23, 59, 59);
  169.         } elseif ($range === 'week') {
  170.             $start = $now->modify('this week')->setTime(0, 0);
  171.             $end = $now->modify('next week')->setTime(0, 0)->modify('-1 second');
  172.         } elseif ($range === 'month') {
  173.             $start = $now->modify('first day of this month')->setTime(0, 0);
  174.             $end = $now->modify('last day of this month')->setTime(23, 59, 59);
  175.         } elseif ($range === 'year') {
  176.             $start = $now->modify('first day of January')->setTime(0, 0);
  177.             $end = $now->modify('last day of December')->setTime(23, 59, 59);
  179.         } else { // Month By Default
  180.             $start = $now->modify('today')->setTime(0, 0);
  181.             $end = $now->modify('today')->setTime(23, 59, 59);
  182.         }
  188.         // If custom date range provided (overrides predefined range)
  191.         
  192.         $validOrders = $this->doctrine->getRepository(Order::class)->createQueryBuilder('orderAlias')
  193.             ->select('count(orderAlias.id)')
  195.             ->andWhere("orderAlias.status <> 'draft'")
  196.             ->andWhere("orderAlias.status <> 'cancelled'")
  197.             ->andWhere("orderAlias.statusShipping <> 'annulee'")
  198.             ->andWhere('orderAlias.createdAt BETWEEN :start AND :end')
  199.             ->setParameter('start', $start)
  200.             ->setParameter('end', $end);
  201.             if($store){
  202.                 $validOrders->andWhere("orderAlias.store = :store");
  203.                 $validOrders->setParameter('store', $store);
  204.             }
  205.             $validOrders = $validOrders->getQuery()->getSingleScalarResult();
  208.         $cancelledOrders = $this->doctrine->getRepository(Order::class)->createQueryBuilder('orderAlias')
  209.             ->select('count(orderAlias.id)')
  211.             ->andWhere("orderAlias.status = 'cancelled' OR orderAlias.statusShipping = 'annulee'")
  212.             ->andWhere('orderAlias.createdAt BETWEEN :start AND :end')
  213.             ->setParameter('start', $start)
  214.             ->setParameter('end', $end);
  215.             if($store){
  216.                 $cancelledOrders->andWhere("orderAlias.store = :store");
  217.                 $cancelledOrders->setParameter('store', $store);
  218.             }
  219.             $cancelledOrders = $cancelledOrders->getQuery()->getSingleScalarResult();
  222.         $shippedOrders = $this->doctrine->getRepository(Order::class)->createQueryBuilder('orderAlias')
  223.             ->select('count(orderAlias.id)')
  224.             ->andWhere("orderAlias.statusShipping = 'shipped'")
  225.             ->andWhere("orderAlias.status <> 'draft'")
  226.             ->andWhere("orderAlias.status <> 'cancelled'")
  227.             ->andWhere("orderAlias.statusShipping <> 'annulee'")
  228.             ->andWhere('orderAlias.createdAt BETWEEN :start AND :end')
  229.             ->setParameter('start', $start)
  230.             ->setParameter('end', $end);
  231.             if($store){
  232.                 $shippedOrders->andWhere("orderAlias.store = :store");
  233.                 $shippedOrders->setParameter('store', $store);
  234.             }
  235.             $shippedOrders = $shippedOrders->getQuery()->getSingleScalarResult();
  240.         $soldProducts =   $this->doctrine->getRepository(Order::class)->createQueryBuilder('orderAlias')
  241.             ->select('sum(orderItems.quantity)')
  242.             ->leftJoin("orderAlias.orderItems", "orderItems")
  243.             ->andWhere("orderAlias.status <> 'draft'")
  244.             ->andWhere("orderAlias.status <> 'cancelled'")
  245.             ->andWhere("orderAlias.statusShipping <> 'annulee'")
  246.             ->andWhere('orderAlias.createdAt BETWEEN :start AND :end')
  247.             ->setParameter('start', $start)
  248.             ->setParameter('end', $end);
  249.             if($store){
  250.                 $soldProducts->andWhere("orderAlias.store = :store");
  251.                 $soldProducts->setParameter('store', $store);
  252.             }
  253.             $soldProducts = $soldProducts->getQuery()->getSingleScalarResult();
  254.         $revenuedProducts =   $this->doctrine->getRepository(Order::class)->createQueryBuilder('orderAlias')
  255.             ->select('sum(orderItems.quantity * orderItems.price)')
  256.             ->leftJoin("orderAlias.orderItems", "orderItems")
  257.             ->andWhere("orderAlias.status <> 'draft'")
  258.             ->andWhere("orderAlias.status <> 'cancelled'")
  259.             ->andWhere("orderAlias.statusShipping <> 'annulee'")
  260.             ->andWhere('orderAlias.createdAt BETWEEN :start AND :end')
  261.             ->setParameter('start', $start)
  262.             ->setParameter('end', $end);
  263.             if($store){
  264.                 $revenuedProducts->andWhere("orderAlias.store = :store");
  265.                 $revenuedProducts->setParameter('store', $store);
  266.             }
  267.             $revenuedProducts = $revenuedProducts->getQuery()->getSingleScalarResult();
  269.         $averageOrderAmount = $validOrders > 0 ? $revenuedProducts / $validOrders : 0;
  274.         //$inTypes = Order::IN_TYPES;
  275.         //$outTypes = Order::OUT_TYPES;
  279.         // $productInStock = $this->doctrine->createQueryBuilder()
  280.         //     ->select('p.id AS product_id, p.name AS product_name,p.initialStock AS initial_stock')
  281.         //     ->addSelect('
  282.         //         SUM(CASE WHEN o.type IN (:inTypes) THEN oi.quantity ELSE 0 END) AS stock_in,
  283.         //         SUM(CASE WHEN o.type IN (:outTypes) THEN oi.quantity ELSE 0 END) AS stock_out,
  284.         //         (
  285.         //             p.initialStock +
  286.         //             SUM(CASE WHEN o.type IN (:inTypes) THEN oi.quantity ELSE 0 END) -
  287.         //             SUM(CASE WHEN o.type IN (:outTypes) THEN oi.quantity ELSE 0 END)
  288.         //         ) AS current_stock
  289.         //     ')
  290.         //     ->from(Product::class, 'p')
  291.         //     ->leftJoin('p.orderItems', 'oi')
  292.         //     ->leftJoin('oi.parentOrder', 'o')
  293.         //     ->groupBy('p.id')
  294.         //     ->having('
  295.         //         (
  296.         //             p.initialStock +
  297.         //             SUM(CASE WHEN o.type IN (:inTypes) THEN oi.quantity ELSE 0 END) -
  298.         //             SUM(CASE WHEN o.type IN (:outTypes) THEN oi.quantity ELSE 0 END)
  299.         //         ) > 0
  300.         //     ')
  301.         //     ->andWhere("o.status = '".Order::STATUS_VALIDATED."'")
  302.         //     //->andWhere('o.createdAt BETWEEN :start AND :end')
  303.         //     // ->setParameter('start', $start)
  304.         //     // ->setParameter('end', $end)
  305.         //     ->setMaxResults(16)
  306.         //     ->orderBy('current_stock', 'DESC')
  308.         //     ->getQuery()
  309.         //     ->getArrayResult();
  313.         $mostOrderedCategory = $this->doctrine->getRepository(Order::class)
  314.             ->createQueryBuilder('o')
  315.             ->select('c.id, c.name as categoryName, COUNT(DISTINCT o.id) as orderCount')
  316.             ->join('o.orderItems', 'oi')
  317.             ->join('oi.product', 'p')
  318.             ->join('p.categoriesProduct', 'c') // Assuming products have a many-to-many relationship with categories
  319.             ->where("o.status NOT IN ('draft', 'cancelled') AND o.statusShipping <> 'annulee'")
  320.             ->andWhere('o.createdAt BETWEEN :start AND :end')
  321.             ->groupBy('c.id, c.name')
  322.             ->orderBy('orderCount', 'DESC')
  323.             ->setMaxResults(1) // Get only the top category
  324.             ->setParameter('start', $start)
  325.             ->setParameter('end', $end);
  326.             if($store){
  327.                 $mostOrderedCategory->andWhere("o.store = :store");
  328.                 $mostOrderedCategory->setParameter('store', $store);
  329.             }
  330.             $mostOrderedCategory->getQuery()->getOneOrNullResult();
  331.             $mostOrderedCategory = $mostOrderedCategory->getQuery()->getOneOrNullResult();
  332.                     
  335.         $mostOrderedCategoryName = $mostOrderedCategory ? $mostOrderedCategory['categoryName'] : 'N/A';
  337.         // Get the most ordered product
  338.         $mostOrderedProduct = $this->doctrine->getRepository(Order::class)
  339.             ->createQueryBuilder('o')
  340.             ->select('p.id, p.name as productName, SUM(oi.quantity) as totalQuantity, COUNT(DISTINCT o.id) as orderCount')
  341.             ->join('o.orderItems', 'oi')
  342.             ->join('oi.product', 'p')
  343.             ->where("o.status NOT IN ('draft', 'cancelled') AND o.statusShipping <> 'annulee'")
  344.             ->andWhere('o.createdAt BETWEEN :start AND :end')
  345.             ->groupBy('p.id, p.name')
  346.             ->orderBy('totalQuantity', 'DESC')
  347.             ->setMaxResults(1)
  348.             ->setParameter('start', $start)
  349.             ->setParameter('end', $end);
  350.             if($store){
  351.                 $mostOrderedProduct->andWhere("o.store = :store");
  352.                 $mostOrderedProduct->setParameter('store', $store);
  353.             }
  354.             $mostOrderedProduct = $mostOrderedProduct->getQuery()->getOneOrNullResult();
  355.             
  357.         $mostOrderedProductName = $mostOrderedProduct ? $mostOrderedProduct['productName'] : 'N/A';
  359.         // Payment status stats - separate queries for different payment statuses
  360.         // Paid orders: filter by paidAt date
  361.         $paidOrdersQuery = $this->doctrine->getRepository(Order::class)->createQueryBuilder('orderAlias')
  362.             ->select('count(orderAlias.id)')
  363.             ->andWhere("orderAlias.status <> 'draft'")
  364.             ->andWhere("orderAlias.status <> 'cancelled'")
  365.             ->andWhere("orderAlias.statusShipping <> 'annulee'")
  366.             ->andWhere('orderAlias.paidAt BETWEEN :start AND :end')
  367.             ->setParameter('start', $start)
  368.             ->setParameter('end', $end);
  369.         if($store){
  370.             $paidOrdersQuery->andWhere("orderAlias.store = :store");
  371.             $paidOrdersQuery->setParameter('store', $store);
  372.         }
  373.         $paidOrders = $paidOrdersQuery->getQuery()->getSingleScalarResult();
  375.         // Unpaid orders: filter by same date range as other stats
  376.         $unpaidOrdersQuery = $this->doctrine->getRepository(Order::class)->createQueryBuilder('orderAlias')
  377.             ->select('count(orderAlias.id)')
  378.             ->andWhere("orderAlias.status <> 'draft'")
  379.             ->andWhere("orderAlias.status <> 'cancelled'")
  380.             ->andWhere("orderAlias.statusShipping = 'livree'")
  381.             ->andWhere('orderAlias.payedAmount = 0')
  382.             ->andWhere("orderAlias.status NOT IN ('paid', 'partially-paid')")
  383.             ->andWhere('orderAlias.createdAt BETWEEN :start AND :end')
  384.             ->setParameter('start', $start)
  385.             ->setParameter('end', $end);
  386.         if($store){
  387.             $unpaidOrdersQuery->andWhere("orderAlias.store = :store");
  388.             $unpaidOrdersQuery->setParameter('store', $store);
  389.         }
  390.         $unpaidOrders = $unpaidOrdersQuery->getQuery()->getSingleScalarResult();
  392.         // Calculate total amounts for paid orders (filtered by paidAt date)
  393.         $paidOrdersAmountQuery = $this->doctrine->getRepository(Order::class)->createQueryBuilder('orderAlias')
  394.             ->select('sum(orderAlias.payedAmount)')
  395.             ->andWhere("orderAlias.status <> 'draft'")
  396.             ->andWhere("orderAlias.status <> 'cancelled'")
  397.             ->andWhere("orderAlias.statusShipping <> 'annulee'")
  398.             ->andWhere('orderAlias.paidAt BETWEEN :start AND :end')
  399.             ->setParameter('start', $start)
  400.             ->setParameter('end', $end);
  401.         if($store){
  402.             $paidOrdersAmountQuery->andWhere("orderAlias.store = :store");
  403.             $paidOrdersAmountQuery->setParameter('store', $store);
  404.         }
  405.         $paidOrdersAmount = $paidOrdersAmountQuery->getQuery()->getSingleScalarResult() ?: 0;
  407.         // Calculate total amounts for unpaid orders (filtered by same date range)
  408.         $unpaidOrdersAmountQuery = $this->doctrine->getRepository(Order::class)->createQueryBuilder('orderAlias')
  409.             ->select('sum(orderItems.quantity * orderItems.price)')
  410.             ->leftJoin("orderAlias.orderItems", "orderItems")
  411.             ->andWhere("orderAlias.status <> 'draft'")
  412.             ->andWhere("orderAlias.status <> 'cancelled'")
  413.             ->andWhere("orderAlias.statusShipping = 'livree'")
  414.             ->andWhere('orderAlias.payedAmount = 0')
  415.             ->andWhere("orderAlias.status NOT IN ('paid', 'partially-paid')")
  416.             ->andWhere('orderAlias.createdAt BETWEEN :start AND :end')
  417.             ->setParameter('start', $start)
  418.             ->setParameter('end', $end);
  419.         if($store){
  420.             $unpaidOrdersAmountQuery->andWhere("orderAlias.store = :store");
  421.             $unpaidOrdersAmountQuery->setParameter('store', $store);
  422.         }
  423.         $unpaidOrdersAmount = $unpaidOrdersAmountQuery->getQuery()->getSingleScalarResult() ?: 0;
  425.         // Breakdown: paid amounts grouped by payment method
  426.         $paidByMethodQB = $this->doctrine->getRepository(Order::class)->createQueryBuilder('orderAlias')
  427.             ->select('pm.name AS methodName, pm.code AS methodCode, SUM(orderAlias.payedAmount) AS totalAmount')
  428.             ->leftJoin('orderAlias.paymentMethod', 'pm')
  429.             ->andWhere("orderAlias.status <> 'draft'")
  430.             ->andWhere("orderAlias.status <> 'cancelled'")
  431.             ->andWhere("orderAlias.statusShipping <> 'annulee'")
  432.             ->andWhere('orderAlias.paidAt BETWEEN :start AND :end')
  433.             ->groupBy('pm.id, pm.name, pm.code')
  434.             ->setParameter('start', $start)
  435.             ->setParameter('end', $end);
  436.         if ($store) {
  437.             $paidByMethodQB->andWhere('orderAlias.store = :store')->setParameter('store', $store);
  438.         }
  439.         $paidByMethod = $paidByMethodQB->getQuery()->getArrayResult();
  441.         // Breakdown: unpaid amounts grouped by payment method
  442.         $unpaidByMethodQB = $this->doctrine->getRepository(Order::class)->createQueryBuilder('orderAlias')
  443.             ->select('pm.name AS methodName, pm.code AS methodCode, SUM(orderItems.quantity * orderItems.price) AS totalAmount')
  444.             ->leftJoin('orderAlias.paymentMethod', 'pm')
  445.             ->leftJoin('orderAlias.orderItems', 'orderItems')
  446.             ->andWhere("orderAlias.status <> 'draft'")
  447.             ->andWhere("orderAlias.status <> 'cancelled'")
  448.             ->andWhere("orderAlias.statusShipping = 'livree'")
  449.             ->andWhere('orderAlias.payedAmount = 0')
  450.             ->andWhere("orderAlias.status NOT IN ('paid', 'partially-paid')")
  451.             ->andWhere('orderAlias.createdAt BETWEEN :start AND :end')
  452.             ->groupBy('pm.id, pm.name, pm.code')
  453.             ->setParameter('start', $start)
  454.             ->setParameter('end', $end);
  455.         if ($store) {
  456.             $unpaidByMethodQB->andWhere('orderAlias.store = :store')->setParameter('store', $store);
  457.         }
  458.         $unpaidByMethod = $unpaidByMethodQB->getQuery()->getArrayResult();
  460.         $stats = [
  461.             [
  462.                 'label' => 'Chiffre d\'affaires',
  463.                 'value' => (float)round($revenuedProducts, 2),
  464.                 'icon' => 'fa-coins',
  465.                 'cssClass' => 'stat-revenue',
  466.                 'description' => 'Revenu total généré par les ventes',
  467.                 'url' => null,
  468.                 'unit' => 'MAD',
  469.             ],
  470.             [
  471.                 'label' => 'Ventes',
  472.                 'value' => (int)$validOrders,
  473.                 'icon' => 'fa-calendar-check',
  474.                 'cssClass' => 'stat-monthly-orders',
  475.                 'description' => 'Nombre de ventes validées',
  476.                 'url' => null,
  477.                 'unit' => null,
  478.             ],
  479.             [
  480.                 'label' => 'Produits vendus',
  481.                 'value' => (int)$soldProducts,
  482.                 'icon' => 'fa-boxes',
  483.                 'cssClass' => 'stat-products-sold',
  484.                 'description' => 'Nombre total de produits vendus',
  485.                 'url' => null,
  486.                 'unit' => null,
  487.             ],
  488.             [
  489.                 'label' => 'Panier moyen',
  490.                 'value' => (float)round($averageOrderAmount, 2),
  491.                 'icon' => 'fa-shopping-basket',
  492.                 'cssClass' => 'stat-average-basket',
  493.                 'description' => 'Montant moyen dépensé par commande',
  494.                 'url' => null,
  495.                 'unit' => 'MAD',
  496.             ],
  497.             [
  498.                 'label' => 'Commandes annulées',
  499.                 'value' => (float)$cancelledOrders,
  500.                 'icon' => 'fa-undo',
  501.                 'cssClass' => 'stat-refunds',
  502.                 'description' => 'Nombre de commandes annulées',
  503.                 'url' => null,
  504.                 'unit' => null,
  505.             ],
  506.             [
  507.                 'label' => 'Commandes livrées',
  508.                 'value' => (float)$shippedOrders,
  509.                 'icon' => 'fa-truck',
  510.                 'cssClass' => 'stat-delivered-orders',
  511.                 'description' => 'Nombre de commandes livrées',
  512.                 'url' => null,
  513.                 'unit' => null,
  514.             ],
  515.             [
  516.                 'label' => 'Catégorie phare',
  517.                 'value' => $mostOrderedCategoryName,
  518.                 'icon' => 'fa-star',
  519.                 'cssClass' => 'stat-top-category',
  520.                 'description' => 'Catégorie la plus vendue ce mois-ci',
  521.                 'url' => null,
  522.                 'unit' => null,
  523.             ],
  525.             [
  526.                 'label' => 'Produit phare',
  527.                 'value' => $mostOrderedProductName,
  528.                 'icon' => 'fa-star',
  529.                 'cssClass' => 'stat-top-product',
  530.                 'description' => 'Produit la plus vendu ce mois-ci',
  531.                 'url' => null,
  532.                 'unit' => null,
  533.             ],
  534.             [
  535.                 'label' => 'Commandes réglées',
  536.                 'value' => $paidOrders,
  537.                 'amount' => (float)$paidOrdersAmount,
  538.                 'icon' => 'fa-check-circle',
  539.                 'cssClass' => 'stat-paid-orders',
  540.                 'description' => 'Nombre de commandes entièrement réglées',
  541.                 'url' => null,
  542.                 'unit' => null,
  543.                 'breakdown' => array_map(function(array $row) { return ['label' => $row['methodName'] ?? '—', 'amount' => (float)($row['totalAmount'] ?? 0)]; }, $paidByMethod),
  544.             ],
  545.             [
  546.                 'label' => 'Commandes à régler',
  547.                 'value' => $unpaidOrders,
  548.                 'amount' => (float)$unpaidOrdersAmount,
  549.                 'icon' => 'fa-clock',
  550.                 'cssClass' => 'stat-unpaid-orders',
  551.                 'description' => 'Nombre de commandes en attente de réglement',
  552.                 'url' => null,
  553.                 'unit' => null,
  554.                 'breakdown' => array_map(function(array $row) { return ['label' => $row['methodName'] ?? '—', 'amount' => (float)($row['totalAmount'] ?? 0)]; }, $unpaidByMethod),
  555.             ],
  556.         ];
  560.         $productLabels = [];
  561.         $productChartData = [];
  563.         // foreach ($productInStock as $product) {
  564.         //     $productLabels[] = $product['product_name'];
  565.         //     $productChartData[] = (float) $product['current_stock']; // cast to float for Chart.js
  566.         // }
  568.         // $productChartData = [
  569.         //     'labels' => $productLabels,
  570.         //     'data' => $productChartData,
  571.         // ];
  573.         return $this->render(
  574.             "bundles/EasyAdminBundle/welcome.html.twig",
  575.             [
  576.                 'stores' => $stores,
  577.                 'store' => $store,
  578.                 'stats' => $stats,
  579.                 'productChartData' => $productChartData,
  580.                 'queryParams' => $queryParams,
  581.             ]
  582.         );
  583.     }
  586.     public function configureCrud(): Crud
  587.     {
  588.         return
  589.             Crud::new()
  590.             ->setDefaultSort(["id" => 'DESC'])
  591.             ->setPaginatorPageSize(12)
  593.         ;
  594.     }
  602.     public function configureDashboard(): Dashboard
  603.     {
  605.         $mainSettings = $this->doctrine->getManager()->getRepository(Settings::class)->findOneBy(["code" => "main"]);
  606.         $nameSpaceTrans = strtolower($mainSettings->getProjectName()) . "-admin";
  610.         $urlImage = "../themes/" . strtolower($mainSettings->getAssetFolderName()) . "/admin/images/logo.png";
  613.         return Dashboard::new()
  614.             ->setTitle('<img title="Dashboard" src="' . $urlImage . '" />
  615.             
  616.             ')
  617.             //->renderContentMaximized()
  618.             ->setFaviconPath("../themes/" . strtolower($mainSettings->getAssetFolderName()) . "/admin/images/icon.png")
  619.             ->setTranslationDomain($nameSpaceTrans)
  620.             ->disableUrlSignatures()
  622.             ->setLocales(
  624.                 [
  625.                     'fr' => 'Français',
  626.                     'en' => 'English',
  627.                     'ar' => 'Arabe',
  628.                 ]
  629.             )
  632.         ;
  633.     }
  637.     public function configureMenuItems(): iterable
  638.     {
  648.         /* START : Les Extensions IlaveU */
  650.         $applications = $this->doctrine->getManager()->getRepository(Application::class)->findBy(["isEnabled" => true], ["menuOrder" => "ASC"]);
  651.         $settings = $this->doctrine->getManager()->getRepository(Settings::class)->findOneBy(["code" => "main"]);
  653.         //$finder = new Finder();
  654.         $filesystem = new Filesystem();
  655.         //$finder->directories()->in(__DIR__."/../../IlaveU")->depth('== 0');
  657.         // For Principal Bundles (ShopBundle + FrontBundle + ...) 
  658.         foreach ($applications as $singleApplication) {
  665.             $bundleExist = $filesystem->exists(__DIR__ . "/../../IlaveU/" . $singleApplication->getName() . "/IlaveU" . $singleApplication->getName() . ".php");
  668.             if (!$bundleExist) {
  669.                 continue;
  670.             }
  673.             $bundleName = $singleApplication->getName();
  676.             // Les themes systemes IlaveU (FrontBundle Themes)
  677.             if ($bundleName == "FrontBundle") {
  682.                 $bundleDashboardController = 'App\IlaveU\FrontBundle\Themes\\' . $settings->getFrontTheme() . '\Controller\DashboardController';
  683.             } else {
  684.                 $bundleDashboardController = 'App\IlaveU\\' . $bundleName . '\Controller\DashboardController';
  685.             }
  690.             $dashboard = new $bundleDashboardController();
  692.             foreach ($dashboard->configureMenuItems() as $menu) {
  693.                 yield $menu;
  694.             }
  695.         }
  699.         // For Additional Apps Bundles (POSBundle + OtherBundle + ...)
  700.         foreach ($applications as $singleApplication) {
  703.             if ($singleApplication->getParentApplication()) {
  704.                 continue;
  705.             }
  707.             $menuArray = [];
  709.             $bundleExist = $filesystem->exists(__DIR__ . "/../../IlaveU/Apps/" . $singleApplication->getName() . "/IlaveU" . $singleApplication->getName() . ".php");
  712.             if (!$bundleExist) {
  713.                 continue;
  714.             }
  717.             $bundleName = $singleApplication->getName();
  720.             $bundleDashboardController = 'App\IlaveU\Apps\\' . $bundleName . '\Controller\DashboardController';
  726.             $dashboard = new $bundleDashboardController();
  728.             foreach ($dashboard->configureMenuItems() as $menu) {
  729.                 yield $menu;
  730.             }
  731.             //SubApplications 
  732.             foreach ($singleApplication->getSubApplications() as $subApplication) {
  733.                 $bundleExist = $filesystem->exists(__DIR__ . "/../../IlaveU/Apps/" . $subApplication->getName() . "/IlaveU" . $subApplication->getName() . ".php");
  736.                 if (!$bundleExist) {
  737.                     continue;
  738.                 }
  741.                 $bundleName = $subApplication->getName();
  744.                 $bundleDashboardController = 'App\IlaveU\Apps\\' . $bundleName . '\Controller\DashboardController';
  750.                 $dashboard = new $bundleDashboardController();
  752.                 foreach ($dashboard->configureMenuItems() as $menu) {
  753.                     yield $menu;
  754.                 }
  755.             }
  756.         }
  758.         /* END : Les Extensions IlaveU */
  760.         yield MenuItem::section('Commandes');
  761.         
  762.         yield MenuItem::linkToCrud('Commandes réglées', 'fas fa-check-circle', Order::class)
  763.             ->setController(PaidOrdersCrudController::class);
  764.         yield MenuItem::linkToCrud('Commandes à payer', 'fas fa-clock', Order::class)
  765.             ->setController(UnpaidOrdersCrudController::class);
  767.         yield MenuItem::section('Parametres');
  769.         yield MenuItem::linkToRoute('Theme Designer', 'fas fa-shield-alt', "website_theme_grapesjs_edit")->setPermission("ROLE_ADMIN_DEV");
  770.         yield MenuItem::linkToRoute('Apps Store', 'fas fa-shield-alt', "app_store")->setPermission("ROLE_ADMIN_DEV");
  771.         yield MenuItem::linkToCrud('Utilisateurs', 'fas fa-shield-alt', User::class)->setController(UserCrudController::class);
  772.         yield MenuItem::linkToCrud('Passwords', 'fas fa-shield-alt', User::class)->setController(UserPasswordCrudController::class);
  773.         yield MenuItem::linkToCrud('Roles', 'fas fa-shield-alt', Role::class);
  774.         yield MenuItem::linkToCrud('LinkType', 'fas fa-gears', LinkType::class)->setPermission("ROLE_ADMIN_DEV");
  775.         yield MenuItem::linkToCrud('Link', 'fas fa-gears', Link::class)->setPermission("ROLE_ADMIN_DEV");
  776.         yield MenuItem::linkToCrud('Applications', 'fas fa-shield-alt', Application::class)->setPermission("ROLE_ADMIN_DEV");
  777.         yield MenuItem::linkToCrud('Notifications', 'fas fa-shield-alt', Notification::class)->setPermission("ROLE_ADMIN_DEV");
  778.         yield MenuItem::linkToRoute('Text to speech', 'fas fa-shield-alt', "open_ai_tts")->setPermission("ROLE_ADMIN_DEV");
  783.         yield MenuItem::linkToCrud('Historique', 'fas fa-shield-alt', EntityLog::class)->setPermission("ROLE_ADMIN");
  784.         yield MenuItem::linkToCrud('Settings', 'fas fa-shield-alt', Settings::class)
  785.             ->setAction("edit")
  786.             ->setEntityId($settings->getId());
  787.         yield MenuItem::linkToCrud('Currency Exchange', 'fas fa-shield-alt', CurrencyExchangeRate::class);
  788.         yield MenuItem::linkToCrud('Web site theme', 'fas fa-shield-alt', WebsiteTheme::class)->setPermission("ROLE_ADMIN_DEV");
  789.         yield MenuItem::linkToCrud('Front Themes', 'fas fa-shield-alt', FrontTheme::class)->setPermission("ROLE_ADMIN_DEV");
  790.         yield MenuItem::linkToCrud('Export Excel', 'fas fa-shield-alt', ExportExcel::class)->setController(ExportExcelCrudController::class)->setPermission("ROLE_ADMIN_DEV");
  791.     }
  792. }