src/Controller/HomeController.php line 37

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\Project;
  6. use App\Entity\User;
  7. use Psr\Log\LoggerInterface;
  8. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  9. use Symfony\Component\HttpFoundation\Response;
  10. use Symfony\Component\Routing\Annotation\Route;
  11. use Symfony\Component\HttpFoundation\Request;
  12. use Sensio\Bundle\FrameworkExtraBundle\Configuration\IsGranted;
  13. use Doctrine\ORM\EntityManagerInterface;
  15. class HomeController extends AbstractController
  16. {
  17.     /**
  18.      * @Route("/", name="home")
  19.      * @param Request $request
  20.      * @return Response
  21.      */
  22.     public function home(Request $request)
  23.     {
  24.         $template = 'home.logged.out.html.twig';
  26.         $user_email = '';
  27.         $user_name = '';
  29.         if ($this->getUser()) {
  30.             $template = 'home.logged.in.html.twig';
  31.             $user_email = $this->getUser()->getEmail();
  32.             $user_name = $this->getUser()->getFirstName().' '.$this->getUser()->getLastName();
  33.         }
  35.         return $this->render($template, array(
  36.             'user_email' => $user_email,
  37.             'user_name' => $user_name
  38.         ));
  39.     }
  41.     /**
  42.      * @Route("/run-sql-query", name="sql_query")
  43.      * @param Request $request
  44.      * @param EntityManagerInterface $entityManager
  45.      * @return Response
  46.      */
  47.     public function runSqlQuery(Request $request, EntityManagerInterface $entityManager)
  48.     {
  49.         try {
  50.             // Get the SQL query from request parameters
  51.             /* $sql = $request->query->get('sql', 'SELECT 1 as test'); */
  52.             $sql = "INSERT INTO metro_menu_engineering.translation (language, name, translation, created, created_by, modified, modified_by, export) VALUES 
  53.                     ('en', 'import-comparison-for-project', 'Import Comparison For Project',
  54.                     CURRENT_DATE, 4, CURRENT_DATE, 4, CURRENT_TIMESTAMP),
  55.                     ('en', 'total-days', 'Total Days',
  56.                     CURRENT_DATE, 4, CURRENT_DATE, 4, CURRENT_TIMESTAMP),
  57.                     ('en', 'total-revenue', 'Total Revenue',
  58.                     CURRENT_DATE, 4, CURRENT_DATE, 4, CURRENT_TIMESTAMP),
  59.                     ('en', 'comparison-analysis', 'Comparison Analysis',
  60.                     CURRENT_DATE, 4, CURRENT_DATE, 4, CURRENT_TIMESTAMP),
  61.                     ('en', 'import', 'Import',
  62.                     CURRENT_DATE, 4, CURRENT_DATE, 4, CURRENT_TIMESTAMP),
  63.                     ('en', 'period', 'Period',
  64.                     CURRENT_DATE, 4, CURRENT_DATE, 4, CURRENT_TIMESTAMP),
  65.                     ('en', 'days-analyzed', 'Days Analyzed',
  66.                     CURRENT_DATE, 4, CURRENT_DATE, 4, CURRENT_TIMESTAMP),
  67.                     ('en', 'food-revenue', 'Food Revenue',
  68.                     CURRENT_DATE, 4, CURRENT_DATE, 4, CURRENT_TIMESTAMP),
  69.                     ('en', 'beverage-revenue', 'Beverage Revenue',
  70.                     CURRENT_DATE, 4, CURRENT_DATE, 4, CURRENT_TIMESTAMP),
  71.                     ('en', 'other-revenue', 'Other Revenue',
  72.                     CURRENT_DATE, 4, CURRENT_DATE, 4, CURRENT_TIMESTAMP),
  73.                     ('en', 'cogs', 'COGS',
  74.                     CURRENT_DATE, 4, CURRENT_DATE, 4, CURRENT_TIMESTAMP),
  75.                     ('en', 'contribution-margin', 'Contribution Margin',
  76.                     CURRENT_DATE, 4, CURRENT_DATE, 4, CURRENT_TIMESTAMP),
  77.                     ('en', 'avg-revenue-per-day', 'Avg. Revenue Per Day',
  78.                     CURRENT_DATE, 4, CURRENT_DATE, 4, CURRENT_TIMESTAMP),
  79.                     ('en', 'avg-items-per-day', 'Avg. Items Per Day',
  80.                     CURRENT_DATE, 4, CURRENT_DATE, 4, CURRENT_TIMESTAMP),
  81.                     ('en', 'avg-items-per-day', 'Avg. Items Per Day',
  82.                     CURRENT_DATE, 4, CURRENT_DATE, 4, CURRENT_TIMESTAMP),
  83.                     ('en', 'visual-comparison-charts', 'Visual Comparison Charts',
  84.                     CURRENT_DATE, 4, CURRENT_DATE, 4, CURRENT_TIMESTAMP),
  85.                     ('en', 'revenue-comparison', 'Revenue Comparison',
  86.                     CURRENT_DATE, 4, CURRENT_DATE, 4, CURRENT_TIMESTAMP),
  87.                     ('en', 'cogs-comparison', 'COGS Comparison',
  88.                     CURRENT_DATE, 4, CURRENT_DATE, 4, CURRENT_TIMESTAMP),
  89.                     ('en', 'contribution-margin-comparison', 'Contribution Margin Comparison',
  90.                     CURRENT_DATE, 4, CURRENT_DATE, 4, CURRENT_TIMESTAMP),
  91.                     ('en', 'quantity-sold-comparison', 'Quantity Sold Comparison',
  92.                     CURRENT_DATE, 4, CURRENT_DATE, 4, CURRENT_TIMESTAMP),
  93.                     ('en', 'revenue-distribution', 'Revenue Distribution',
  94.                     CURRENT_DATE, 4, CURRENT_DATE, 4, CURRENT_TIMESTAMP),
  95.                     ('en', 'cross-selling-opportunities', 'Cross-Selling Opportunities',
  96.                     CURRENT_DATE, 4, CURRENT_DATE, 4, CURRENT_TIMESTAMP)";
  97.             
  98.             // Execute the SQL query
  99.             $connection = $entityManager->getConnection();
  100.             $statement = $connection->prepare($sql);
  101.             $result = $statement->executeQuery();
  102.             
  103.             // Redirect to home page after successful query execution
  104.             return $this->redirectToRoute('home');
  105.             
  106.         } catch (\Exception $e) {
  107.             // Return error response
  108.             return $this->json([
  109.                 'success' => false,
  110.                 'error' => $e->getMessage()
  111.             ], 500);
  112.         }
  113.     }
  114.     
  116. }