src/Controller/Backend/DashboardListController.php line 31

Open in your IDE?
  1. <?php
  3. namespace App\Controller\Backend;
  5. use App\Controller\Base\BaseController;
  6. use App\Entity\DashboardList;
  7. use App\Entity\DashboardTab;
  8. use App\Entity\TGrafik;
  9. use App\Filter\DashboardListFilterType;
  10. use App\Form\DashboardListType;
  11. use App\Repository\DashboardComponentRepository;
  12. use App\Repository\DashboardListRepository;
  13. use App\Repository\TGrafikRepository;
  14. use Symfony\Component\Routing\Annotation\Route;
  15. use Kematjaya\Breadcrumb\Lib\Builder as BreacrumbBuilder;
  16. use Symfony\Component\HttpKernel\Exception\NotFoundHttpException;
  17. use App\Utils\ObjectManager;
  18. use Doctrine\ORM\EntityManagerInterface;
  19. use Symfony\Component\HttpFoundation\Request;
  20. use Knp\Component\Pager\PaginatorInterface;
  21. use Symfony\Component\HttpFoundation\JsonResponse;
  23. class DashboardListController extends BaseController
  24. {
  25.     private $pageName = 'dashboard_list';
  26.     private $class = DashboardList::class;
  28.     /**
  29.      * @Route("/dashboard_list",name="dashboard_list")
  30.      */
  31.     public function index(BreacrumbBuilder $builder, Request $request, PaginatorInterface $paginatorInterface)
  32.     {
  33.         $builder->add('Setting Dashboard ', "dashboard_list", array(), "&nbsp;<i class='fa fa-home'></i>");
  35.         $form = $this->createFormFilter(DashboardListFilterType::class);
  37.         $queryBuilder = $this->getQueryBuilder($this->class);
  38.         $queryBuilder = $this->buildFilter($request, $form, $queryBuilder)->addOrderBy("this.id", "DESC");
  40.         $this->setSessionLimit($request);
  41.         $maxPerPage = $request->getSession()->get("limit") ? $request->getSession()->get("limit") : $this->getLimit();
  42.         $pagination = $paginatorInterface->paginate($queryBuilder, $request->query->getInt('page', 1), $maxPerPage);
  44.         return $this->render('backend/dashboard_list/index.html.twig', [
  45.             'page_name' => $this->pageName,
  46.             'button_credential' => $this->buttonCredentials($this->pageName),
  47.             'filter' => $form->createView(),
  48.             'pagination' => $pagination
  49.         ]);
  50.     }
  52.     /**
  53.      * @Route("/dashboard_list/form/{id}", defaults={"id"= null}, name="dashboard_list_form", methods={"POST", "GET"})
  54.      */
  55.     public function form(?string $id = null, Request $request, DashboardListRepository $dashboardListRepository)
  56.     {
  57.         if ($id) {
  58.             $dashboardList = $dashboardListRepository->find($id);
  59.         } else {
  60.             $dashboardList = new DashboardList();
  61.         }
  62.         if (!$dashboardList) {
  63.             throw new NotFoundHttpException();
  64.         }
  66.         $form = $this->createForm(DashboardListType::class, $dashboardList, ['action' => $this->generateUrl('dashboard_list_form', ['id' => $dashboardList->getId()])]);
  67.         $form->handleRequest($request);
  68.         if ($form->isSubmitted() && $form->isValid()) {
  69.             $dashboard = $form->getData();
  70.             $dashboard->setCreatedAt(new \DateTime('now', new \DateTimeZone('Asia/Jakarta')));
  71.             $entityManager = $this->getDoctrine()->getManager();
  72.             $entityManager->persist($dashboard);
  73.             $entityManager->flush();
  75.             $this->addFlash('notice', 'List dashboard berhasil disimpan');
  77.             return $this->redirectToRoute('dashboard_list');
  78.         }
  79.         return $this->render('/backend/dashboard_list/form.html.twig', ['form' => $form->createView()]);
  80.     }
  82.     /**
  83.      * @Route("/dashboard_list/{id}/delete_dashboard_list", name="dashboard_list_delete", methods={"GET"})
  84.      */
  85.     public function delete(?string $id = null, DashboardListRepository $dashboardListRepository)
  86.     {
  87.         $dashboard_list = $dashboardListRepository->find($id);
  88.         $entityManager = $this->getDoctrine()->getManager();
  89.         $entityManager->remove($dashboard_list);
  90.         $entityManager->flush();
  91.         return $this->redirectToRoute('dashboard_list');
  92.     }
  94.     /**
  95.      * @Route("/add_selected", name="dashboard_list_add_selected", methods={"POST"})
  96.      */
  97.     public function add_selected(Request $request, ObjectManager $objectManager)
  98.     {
  99.         $sessionName = $request->get("name");
  100.         $this->get('session')->set($sessionName, $request->get('selected'));
  101.         $selected = (!empty($this->get('session')->get($sessionName))) ? $this->get('session')->get($sessionName) : [];
  102.         return $this->json($selected);
  103.     }
  105.     /**
  106.      * @Route("/action_selected", name="dashboard_list_action_selected", methods={"POST"})
  107.      */
  108.     public function action_selected(Request $request, ObjectManager $objectManager)
  109.     {
  110.         $sessionName = $request->get("name");
  111.         if ($this->isCsrfTokenValid($sessionName . '_action_selected', $request->request->get('_token'))) {
  112.             $selected = (!empty($this->get('session')->get($sessionName))) ? $this->get('session')->get($sessionName) : [];
  113.             $deleted = $objectManager->deleteByIds($this->class, $selected);
  114.             if ($deleted) {
  115.                 $this->get('session')->set($sessionName, []);
  116.                 $this->addFlash('success', $this->getTranslator()->trans('messages.deleted.success'));
  117.             } else {
  118.                 $this->addFlash('error', $this->getTranslator()->trans('messages.deleted.error'));
  119.             }
  120.         }
  122.         return $this->redirectToRoute('dashboard_list');
  123.     }
  125.     // /**
  126.     //  * @Route("/dashboard_list/{id}/preview", name="dashboard_list_preview", methods={"GET", "POST"})
  127.     //  */
  128.     // public function preview(BreacrumbBuilder $builder, DashboardListRepository $dashboardListRepository, DashboardList $dashboardList, DashboardComponentRepository $dashboardComponentRepository)
  129.     // {
  130.     //     $builder->add('Setting Dashboard ', "dashboard_list", array(), "&nbsp;<i class='fa fa-home'></i>");
  131.     //     $builder->add('Preview');
  133.     //     $dashboardList = $dashboardListRepository->find($dashboardList);
  134.     //     $tabs = $dashboardList->getDashboardTabs()->toArray();
  135.     //     usort($tabs, fn($a, $b) => $a->getUrutan() <=> $b->getUrutan());
  137.     //     $componentsByTab = [];
  138.     //     foreach ($tabs as $tab) {
  139.     //         $componentsByTab[$tab->getId()] = $dashboardComponentRepository->findBy(['dashboard_tab' => $tab]);
  140.     //     }
  142.     //     return $this->render('backend/dashboard_list/preview.html.twig', [
  143.     //         'page_name' => $this->pageName,
  144.     //         'button_credential' => $this->buttonCredentials($this->pageName),
  145.     //         'dashboardList' => $dashboardList,
  146.     //         'tabs' => $tabs,
  147.     //         'componentsByTab' => $componentsByTab
  148.     //     ]);
  149.     // }
  151.     /**
  152.      * @Route("/dashboard_list/{id}/preview", name="dashboard_list_preview", methods={"GET", "POST"})
  153.      */
  154.     public function preview(
  155.         BreacrumbBuilder $builder,
  156.         DashboardListRepository $dashboardListRepository,
  157.         DashboardList $dashboardList,
  158.         DashboardComponentRepository $dashboardComponentRepository,
  159.         TGrafikRepository $tGrafikRepo,
  160.         EntityManagerInterface $em
  161.     ) {
  162.         $builder->add('Setting Dashboard ', "dashboard_list", [], "&nbsp;<i class='fa fa-home'></i>");
  163.         $builder->add('Preview');
  165.         $dashboardList = $dashboardListRepository->find($dashboardList);
  166.         $tabs = $dashboardList->getDashboardTabs()->toArray();
  167.         usort($tabs, fn($a, $b) => $a->getUrutan() <=> $b->getUrutan());
  169.         $componentsByTab = [];
  170.         $components = [];
  171.         foreach ($tabs as $tab) {
  172.             $components = $dashboardComponentRepository->findBy(['dashboard_tab' => $tab]);
  174.             foreach ($components as $component) {
  175.                 // if ($component->getType() === 'table') {
  176.                 //     $grafikId = $component->getExternalChartId();
  177.                 //     $tGrafik = $tGrafikRepo->find($grafikId);
  179.                 //     if ($tGrafik) {
  180.                 //         $columns = $this->getGrafikColumns($tGrafik);
  181.                 //         $component->setColumns($columns);
  182.                 //         $em->persist($component);
  183.                 //     }
  184.                 // }
  186.                 if ($component->getType() === 'table') {
  187.                     $config = $component->getConfig();
  188.                     $dataSourceType = $config['data_source_type'] ?? 't_grafik';
  190.                     if ($dataSourceType === 't_grafik') {
  191.                         $grafikId = $component->getExternalChartId();
  192.                         $tGrafik = $tGrafikRepo->find($grafikId);
  194.                         if ($tGrafik) {
  195.                             $columns = $this->getGrafikColumns($tGrafik);
  196.                             $columns = array_filter($columns, fn($c) => $c !== 'all');
  197.                             $component->setColumns($columns);
  198.                             $em->persist($component);
  199.                         }
  200.                     } elseif ($dataSourceType === 't_explore_data_detail') {
  201.                         // Sesuaikan kolom default eksplorasi
  202.                         $columns = ['no', 'periode', 'nilai'];
  203.                         $component->setColumns($columns);
  204.                         $em->persist($component);
  205.                     }
  206.                 }
  208.                 if ($component->getType() === 'html') {
  209.                     $grafikId = $component->getDataSource();
  210.                     $tGrafik = $tGrafikRepo->find($grafikId);
  212.                     if ($tGrafik) {
  213.                         $conn = $em->getConnection();
  214.                         $table = $tGrafik->getTabel();
  216.                         // map khusus 'kategori_plant' → 'plant'
  217.                         $axisX = $tGrafik->getAxisx() === 'kategori_plant' ? 'plant' : $tGrafik->getAxisx();
  218.                         $axisY = $tGrafik->getAxisYIds(); // array nama kolom Y
  219.                         $operation = $tGrafik->getOperation() ?: 'COUNT';
  221.                         // build SELECT
  222.                         $selectParts = [];
  223.                         foreach ($axisY as $col) {
  224.                             $selectParts[] = sprintf('%s("%s") AS "%s"', $operation, $col, strtolower($col)); // alias ke lowercase
  225.                         }
  226.                         $selectClause = sprintf('"%s", %s', $axisX, implode(', ', $selectParts));
  227.                         $sql = sprintf('SELECT %s FROM "%s" GROUP BY "%s" ORDER BY "%s" LIMIT 1', $selectClause, $table, $axisX, $axisX);
  229.                         try {
  230.                             $stmt = $conn->prepare($sql);
  231.                             $data = $stmt->executeQuery()->fetchAllAssociative();
  232.                         } catch (\Throwable $e) {
  233.                             $data = [];
  234.                         }
  236.                         // normalisasi key ke lowercase, termasuk axisX
  237.                         $firstRow = [];
  238.                         if (!empty($data[0])) {
  239.                             foreach ($data[0] as $key => $val) {
  240.                                 $firstRow[strtolower($key)] = $val;
  241.                             }
  242.                             // pastikan axisX juga tersedia sebagai 'plant' bila relevan
  243.                             if ($axisX !== strtolower($axisX) && isset($data[0][$axisX])) {
  244.                                 $firstRow[strtolower($axisX)] = $data[0][$axisX];
  245.                             }
  246.                         }
  248.                         $template = $component->getConfig()['html_template'] ?? '';
  250.                         // ↓ turunkan placeholder ke lowercase sebelum lookup
  251.                         $replacedHtml = preg_replace_callback('/\{\{\s*([A-Za-z0-9_]+)\s*\}\}/', function ($m) use ($firstRow) {
  252.                             $key = strtolower($m[1]);
  253.                             if (array_key_exists($key, $firstRow)) {
  254.                                 // aman-kan value agar tidak injeksi; HTML murni dari template tetap dipertahankan
  255.                                 return htmlspecialchars((string) $firstRow[$key], ENT_QUOTES | ENT_SUBSTITUTE, 'UTF-8');
  256.                             }
  257.                             return "<span style='color:red'>[undefined: {$m[1]}]</span>";
  258.                         }, $template);
  260.                         $component->setResolvedData([$replacedHtml]);
  261.                         $em->persist($component); // pastikan entity flagged as dirty
  262.                     }
  263.                 }
  264.             }
  266.             $componentsByTab[$tab->getId()] = $components;
  267.         }
  269.         $em->flush();
  271.         return $this->render('backend/dashboard_list/preview.html.twig', [
  272.             'page_name' => $this->pageName,
  273.             'button_credential' => $this->buttonCredentials($this->pageName),
  274.             'dashboardList' => $dashboardList,
  275.             'tabs' => $tabs,
  276.             'componentsByTab' => $componentsByTab,
  277.             'components' => $components
  278.         ]);
  279.     }
  281.     private function getGrafikColumns(TGrafik $grafik): array
  282.     {
  283.         $sumbu_x = ($grafik->getAxisx() === 'kategori_plant') ? 'plant' : $grafik->getAxisx();
  284.         $sumbu_y = $grafik->getAxisYIds();
  285.         return array_merge([$sumbu_x], $sumbu_y);
  286.     }
  288.     /**
  289.      * @Route("/dashboard_list/tab/add", name="tab_add", methods={"POST"})
  290.      */
  291.     public function addTab(Request $request, EntityManagerInterface $em, DashboardListRepository $repo): JsonResponse
  292.     {
  293.         $id = $request->request->get('dashboard_id');
  294.         $dashboard = $repo->find($id);
  296.         if (!$dashboard) {
  297.             return new JsonResponse(['success' => false, 'message' => 'Dashboard tidak ditemukan'], 404);
  298.         }
  300.         $lastTab = $dashboard->getDashboardTabs()->last();
  301.         $lastUrutan = $lastTab ? $lastTab->getUrutan() : 0;
  303.         $tab = new DashboardTab();
  304.         $tab->setName($request->request->get('nama_tab'));
  305.         $tab->setDashboardList($dashboard);
  306.         $tab->setUrutan($lastUrutan + 1);
  307.         $tab->setCreatedAt(new \DateTime('now', new \DateTimeZone('Asia/Jakarta')));
  308.         $em->persist($tab);
  309.         $em->flush();
  311.         return new JsonResponse(['success' => true, 'tab_id' => $tab->getId()]);
  312.     }
  314.     /**
  315.      * @Route("/dashboard_list/tab/rename/{id}", methods={"POST"})
  316.      */
  317.     public function rename($id, Request $request, EntityManagerInterface $em, DashboardTab $dashboardTab)
  318.     {
  319.         $newName = $request->request->get('nama_tab');
  320.         $dashboardTab->setName($newName);
  321.         $em->flush();
  323.         return new JsonResponse(['success' => true]);
  324.     }
  326.     /**
  327.      * @Route("/dashboard_list/tab/delete/{id}", name="tab_delete", methods={"DELETE"})
  328.      */
  329.     public function deleteTab(DashboardTab $dashboardTab, EntityManagerInterface $em): JsonResponse
  330.     {
  331.         $em->remove($dashboardTab);
  332.         $em->flush();
  334.         return new JsonResponse(['success' => true]);
  335.     }
  336. }