src/Controller/DefaultController.php line 18

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\SaasInstance;
  6. use App\Service\InstanceInspector;
  7. use Doctrine\DBAL\DriverManager;
  8. use Doctrine\Persistence\ManagerRegistry;
  9. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  10. use Symfony\Component\HttpFoundation\JsonResponse;
  11. use Symfony\Component\HttpFoundation\Request;
  12. use Symfony\Component\HttpFoundation\Response;
  13. use Symfony\Component\Routing\Annotation\Route;
  15. class DefaultController extends AbstractController
  16. {
  17. #[Route('/', name: 'desktop')]
  18. public function index(ManagerRegistry $doctrine): Response
  19. {
  20. $instances = $doctrine->getRepository(SaasInstance::class)->findBy(['isActive' => 1], ['name' => 'ASC']);
  22. return $this->render('default/index.html.twig', [
  23. 'instances' => $instances,
  24. ]);
  25. }
  27. /**
  28. * Estadísticas de uso de una instancia (consulta de solo lectura a la base del cliente; caché de 5 minutos).
  29. */
  30. #[Route('/panel/estadisticas/{id}', name: 'instance_stats', requirements: ['id' => '\d+'], methods: ['GET'])]
  31. public function instanceStats(Request $request, ManagerRegistry $doctrine, InstanceInspector $inspector, int $id): JsonResponse
  32. {
  33. $instance = $doctrine->getRepository(SaasInstance::class)->find($id);
  35. if (!$instance) {
  36. return new JsonResponse(['ok' => false, 'error' => 'Instancia no encontrada'], 404);
  37. }
  39. return new JsonResponse($inspector->stats($instance, $request->query->getBoolean('refresh')));
  40. }
  42. #[Route('/monitor', name: 'monitor')]
  43. public function monitor(Request $request): Response
  44. {
  45. $dateInit = $request->get('dateInit', date('Y-m-d'));
  46. $dateFinish = $request->get('dateFinish', date('Y-m-d'));
  48. return $this->render('default/monitor.html.twig', [
  49. 'dateInit' => $dateInit,
  50. 'dateFinish' => $dateFinish,
  51. ]);
  52. }
  54. #[Route('/analytics/ticket/hours', name: 'payment_analytics_by_hour')]
  55. public function analyticsPaymentHours(Request $request, ManagerRegistry $doctrine): JsonResponse
  56. {
  57. $em = $doctrine->getManager();
  59. $dateInit = $request->get('dateInit', date('Y-m-d'));
  60. $dateFinish = $request->get('dateFinish', date('Y-m-d'));
  62. $lists = $em->getRepository(SaasInstance::class)->findBy(['isActive' => 1]);
  64. $sql = "SELECT
  65. SUM(IF(realtion_payment = '1', total, 0)) AS Efectivo,
  66. SUM(IF(realtion_payment = '2', total, 0)) AS Debito,
  67. SUM(IF(realtion_payment = '3', total, 0)) AS Credito,
  68. SUM(IF(realtion_payment = '4', total, 0)) AS tranferencia,
  69. SUM(IF(realtion_payment = '5', total, 0)) AS wooCommerce,
  70. SUM(total) AS totalDetails
  71. FROM ticket
  72. WHERE status = '2' AND created_at BETWEEN :dateInit AND :dateFinish";
  74. $rest = [];
  75. foreach ($lists as $instance) {
  76. try {
  77. $conn = DriverManager::getConnection([
  78. 'dbname' => $instance->getDbname(),
  79. 'user' => $instance->getDbuser(),
  80. 'password' => $instance->getDbpassword(),
  81. 'host' => $instance->getDbhost(),
  82. 'driver' => 'pdo_mysql',
  83. ]);
  85. $results = $conn->executeQuery($sql, [
  86. 'dateInit' => $dateInit . ' 00:00:00',
  87. 'dateFinish' => $dateFinish . ' 23:59:59',
  88. ])->fetchAssociative();
  89. } catch (\Throwable $e) {
  90. // Una instancia caída no debe romper el monitor de las demás.
  91. $results = [
  92. 'Efectivo' => 0, 'Debito' => 0, 'Credito' => 0, 'tranferencia' => 0,
  93. 'wooCommerce' => 0, 'totalDetails' => 0, 'error' => true,
  94. ];
  95. }
  97. $rest[] = [
  98. 'id' => $instance->getId(),
  99. 'name' => $instance->getName(),
  100. 'cant' => $results,
  101. 'url' => $instance->getHostname(),
  102. 'img' => $instance->getHostname() . '/publico/imagen/login',
  103. ];
  104. }
  106. return new JsonResponse(['detail' => $rest]);
  107. }
  108. }