src/Controller/Engine/EngineController.php line 44

Open in your IDE?
  1. <?php
  3. namespace App\Controller\Engine;
  5. use App\Entity\Base3\UserFilter;
  6. use App\Entity\LostFile;
  7. use App\Entity\LostImage;
  8. use App\Form\Base3\ReportFilters\LaydownReportFilterType;
  9. use App\Form\PostType;
  10. use App\Model\SystemControl;
  11. use App\Repository\Base3\UserFilterRepository;
  12. use App\Repository\LostFileRepository;
  13. use App\Repository\SystemControlRepository;
  14. use App\Repository\UserRepository;
  15. use App\Service\AuthenticationService;
  16. use App\Service\DefaultDateService;
  17. use App\Service\LiformHelper;
  18. use App\Service\TranslationHelper;
  19. use Carbon\Carbon;
  20. use Doctrine\ORM\EntityManagerInterface;
  21. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  22. use Symfony\Component\Filesystem\Exception\IOExceptionInterface;
  23. use Symfony\Component\Filesystem\Filesystem;
  24. use Symfony\Component\HttpClient\HttpClient;
  25. use Symfony\Component\HttpFoundation\JsonResponse;
  26. use Symfony\Component\HttpFoundation\Request;
  27. use Symfony\Component\HttpFoundation\Response;
  28. use Symfony\Component\Routing\Annotation\Route;
  31. // use Symfony\Component\HttpFoundation\Response;
  33. class EngineController extends AbstractController
  34. {
  36.     /**
  37.      * Returns the engine template
  38.      *
  39.      * @Route("/", name="homepage")
  40.      * @return Response
  41.      */
  42.     // * @Route("/{engineRouting}", requirements={"engineRouting"="^(?!api|template|_(profiler|wdt)).*"}, name="engine_index")
  43.     // public function EngineAction($engineRouting): Response
  44.     public function EngineCasing(Request $request): Response
  45.     {
  46.         $language = $this->getUser()->getLanguage();
  48.         if (null !== $language) {
  49.             $request->getSession()->set('_locale', $language);
  50.         }
  52.         return $this->render('@engine/casing.html.twig');
  53.     }
  55.     /**
  56.      * @Route("/engine/twig/", name="engine_main", methods="GET", options={"expose"=true})
  57.      */
  58.     public function EngineAction(): Response
  59.     {
  60.         return $this->render('@engine/casing/engine.html.twig');
  61.     }
  63.     /**
  64.      * @Route("/engine/twig/layout/{template}", name="engine_layout", methods="GET", options={"expose"=true})
  65.      */
  66.     public function EngineLayout(Request $request, $template)
  67.     {
  68.         $ignitionSettings = $this->EngineIgnitionService($template);
  70.         return $this->render("@layout/$template.html.twig", $ignitionSettings);
  71.     }
  73.     /**
  74.      * @Route("/insight", name="insight_token", methods="GET", options={"expose"=true})
  75.      */
  76.     public function Insight(Request $request)
  77.     {
  78.         // session on licence level
  79.         // three api tokens
  80.         $url = "https://panintelligence.base.website/";
  81.         $user = $this->getUser();
  82.         // workaround until we get more liscences
  83.         $username = $_ENV['PI_USER']; //Change this to the user you want to login as
  84.         // $username = $user->getUsername();
  85.         $password = $_ENV['PI_PASSWORD']; //Change this to user's password
  86.         $apiToken = "panMISDashboardWebServices/api/token/";
  87.         $httpClient = HttpClient::create();
  88.         // it makes an HTTP GET request to https://httpbin.org/get?token=...&name=...
  89.         $response = $httpClient->request('POST', $url.$apiToken, [
  90.             // these values are automatically encoded before including them in the URL
  91.             'query' => [
  92.                 'username' => $username,
  93.                 'password' => $password
  94.                 // ,
  95.                 // 'loginAs' => // set password as expired
  96.             ],
  97.         ]);
  98.         $xml = simplexml_load_string($response->getContent());
  99.         $token = (string)$xml->Token[0];
  100.         $response = new Response();
  101.         $response->setContent(json_encode([
  102.             'token'=>$token
  103.         ]));
  104.         // $response->headers->set("Authorization", "bearer " . $token);
  105.         return $response;
  106.     }
  108.     /**
  109.      * @Route("/engine/twig/part/sidebar", name="engine_sidebar", methods="GET", options={"expose"=true})
  110.      * @param SystemControlRepository $systemControlRepo
  111.      * @param AuthenticationService $authentication
  112.      * @param DefaultDateService $dateService
  113.      * @return Response
  114.      */
  115.     public function EngineSidebar(SystemControlRepository $systemControlRepo, AuthenticationService $authentication, DefaultDateService $dateService, TranslationHelper $translationHelper): Response
  116.     {
  117.         $menu1 = $systemControlRepo->findOneBy([
  118.             'slug' => SystemControl::MAIN_MENU_1,
  119.         ]);
  121.         $menu = $menu1->getPj();
  122.         $menu = $translationHelper->translateKeyInArray($menu, 'name');
  123.         foreach ($menu as $key => $value) {
  124.             if(isset($menu[$key]['submenu'])){
  125.                 $menu[$key]['submenu'] = $translationHelper->translateKeyInArray($menu[$key]['submenu'], 'name');
  126.             }
  127.         }
  128.         $menu = $translationHelper->translateKeyInNestedArray($menu, 'name');
  129.         $data = $dateService->defaultDateForNavigation($menu);
  130.         $navigationSetting = [
  131.             'menu' => $data ?? [],
  132.             'menutwo' => [], //$menu2->getPj() ?? [],
  133.             'menuthree' => [], //$menu3->getPj() ?? [],
  134.             'userroles' => $authentication->getUserRoleHierarchy($this->getUser()),
  135.         ];
  137.         return $this->render("@layout/sidebar.html.twig", $navigationSetting);
  138.     }
  140.     /**
  141.      * @Route("/engine/twig/engine/login", name="engine_login_template", methods="GET", options={"expose"=true})
  142.      */
  143.     public function EngineLogin(Request $request)
  144.     {
  145.         $sidebarSettings = $this->EngineSidebarService();
  146.         return $this->render('@engine/login/templates/login.html.twig');
  147.     }
  149.     /**
  150.      * @Route("/engine/twig/component/{component}/{template}", name="engine_component", methods="GET", options={"expose"=true})
  151.      */
  152.     public function EngineComponent(Request $request, $component, $template)
  153.     {
  154.         return $this->render("@component/$component/$template.html.twig", [
  155.         ]);
  156.     }
  158.     /**
  159.      * @Route("/engine/twig/part/{mode}/{template}", name="engine_part", methods="GET", options={"expose"=true})
  160.      */
  161.     public function EnginePart(Request $request, $mode, $template)
  162.     {
  163.         $ignitionSettings = $this->EngineIgnitionService($template);
  165.         return $this->render("@part/$mode/templates/".$template.".html.twig", [
  166.             // 'form' => $form->createView(),
  167.         ]);
  168.     }
  170.     /**
  171.      * @Route("/engine/twig/module/{mode}/{template}", name="engine_module", methods="GET", options={"expose"=true})
  172.      */
  173.     public function EngineModule(Request $request, $mode, $template)
  174.     {
  176.         return $this->render("@module/$mode/templates/".$template.".html.twig", [
  177.             // 'form' => $form->createView(),
  179.         ]);
  180.     }
  182.     /**
  183.      * @Route("/engine/twig/template/{mode}/{template}", name="engine_template", methods="GET", options={"expose"=true})
  184.      */
  185.     public function EngineTemplate(Request $request, $mode, $template)
  186.     {
  187.         $options = $request->query->all();
  189.         $availableTabs = null;
  190.         if(array_key_exists('availableTabs', $options)) {
  191.             $availableTabs = $options['availableTabs'];
  192.         }
  194.         return $this->render($mode."/".$template.".html.twig", [
  195.             // 'form' => $form->createView(),
  196.             'availableTabs' => $availableTabs
  197.         ]);
  198.     }
  200.     /**
  201.      * @Route("/engine/twig/filter/{mode}/{template}", name="engine_filters", options={"expose"=true})
  202.      */
  203.     public function EngineFilters(Request $request, $mode, $template)
  204.     { //
  205.         $user = $this->getUser()->getId();
  206.         $em = $this->getDoctrine()->getManager();
  208.         // $filters = $em->getRepository('App:Base3\UserFilter');
  209.         // $filterSet = $request->query->get('filterSet');
  211.         // // $savedFilters = $filters->findByRoute($user, $filterSet);
  212.         // $savedFilters = [];
  213.         // if($filterSet != '' || $filterSet != null){
  214.         //     $conn = $em->getConnection();
  215.         //     $sql = "SELECT *
  216.         //             FROM b3_user_filter uf
  217.         //             WHERE uf.user_id = $user
  218.         //             AND uf.route = '$template'
  219.         //             AND uf.description = '$filterSet'
  220.         //         ";
  221.         //     $stmt = $conn->prepare($sql);
  222.         //     $stmt->execute();
  223.         //     $res = $stmt->fetchAll();
  224.         //     $savedFilters = json_decode($res[0]["filter_data"], true);
  225.         // }
  227.         // // $activeFilter = $filters->findOneByRoute($route, $user, $filterSet);
  228.         // $activeFilter = [];//$filters->findOneByRoute($route, $user, $filterSet);
  229.         // if($filterSet != '' || $filterSet != null){
  230.         //     $conn = $em->getConnection();
  231.         //     $sql = "SELECT *
  232.         //             FROM b3_user_filter uf
  233.         //             WHERE uf.user_id = $user
  234.         //             AND uf.route = '$template'
  235.         //         ";
  236.         //     $stmt = $conn->prepare($sql);
  237.         //     $stmt->execute();
  238.         //     $res = $stmt->fetchAll();
  239.         //     $activeFilter = $res; //json_decode($res[0], true);
  240.         // }
  242.         //$userFilter = new UserFilter();
  243.         //, $userFilter
  244.         $form = $this->createForm(LaydownReportFilterType::class);
  247.         $response = [
  248.             "form" => $form->createView(),
  249.             //"activeFilter" => $activeFilter,
  250.             //"savedFilters" => $savedFilters
  252.         ];
  253.         // dump($response); die;
  254.         // die;
  256.         return $this->render("@module/".$mode."/templates/".$template.".html.twig", $response);
  257.     }
  259.     // const DAYS_BEFORE_START_DATE = 30;
  260.     const ASSET_SPACE = "\public\\";
  261.     // const ASSET_SPACE_TEMP = "\var\\"; 
  262.     // const ASSET_SPACE_TEMP = "\protected\\"; 
  263.     // const ASSET_SPACE_PATH = "\var\filestore\"; 
  264.     const ASSET_FOLDER = 'filestore\avatars\\';
  267.     /**
  268.      * @Route("/engine/serve-file", name="serve_files", options={"expose"=true})
  269.      */
  270.     public function serveFile(LostFileRepository $lostFileRepo, UserRepository $userRepo, EntityManagerInterface $em, LiformHelper $liformHelper, Request $request)
  271.     {
  272.         $assetSpace = self::ASSET_SPACE;
  273.         $projectDir = $this->getParameter('kernel.project_dir');
  275.         $image_marker = $request->query->get('image_marker', null);
  277.         // If this is an integer, increment it by four
  278.         if (is_numeric($image_marker)) {
  279.             $lostImage = $lostImageRepo->find(intval($image_marker));
  281.             $assetFolder = $lostImage->getFolder();
  282.             $filename = str_replace('\\', '/', $lostImage->getName());
  283.         } // If $a_bool is a string, print it out
  284.         else {
  286.             $assetFolder = self::ASSET_FOLDER;
  287.             $filename = $image_marker;
  288.         }
  290.         $resolvedResourcePath = $projectDir.$assetSpace.$assetFolder.$filename;
  292.         // i.e Sending a file from the resources folder in /web
  293.         // in this example, the TextFile.txt needs to exist in the server
  294.         // This should return the file located in /mySymfonyProject/web/public-resources/TextFile.txt
  295.         // to being viewed in the Browser
  296.         return new BinaryFileResponse($resolvedResourcePath);
  298.     }
  300.     // public function processAvatarChange(Avatar $avatar, Request $request)
  302.     /**
  303.      * @Route("/upload_image", name="engine_upload_image", options={"expose"=true}, methods="GET|POST")
  304.      */
  305.     public function uploadImage(EntityManagerInterface $em, Request $request)
  306.     {
  307.         // retrieve the file with the name given in the form.
  308.         $file = $request->files->get('file');
  309.         $status = array('status' => "success","fileUploaded" => false);
  311.         $originalName = $file->getClientOriginalName();
  313.         // If a file was uploaded
  314.         if (!is_null($file)) {
  315.             // generate a random name for the file but keep the extension
  316.             $filename = uniqid().".".$file->getClientOriginalExtension();
  317.             // https://stackoverflow.com/questions/12363657/the-concept-of-virtual-host-and-dns
  318.             $filesystem = new Filesystem();
  319.             $projectDir = $this->getParameter('kernel.project_dir');
  320.             // $instanceDir = isset($_ENV['INSTANCE_DIR']) ? $_ENV['INSTANCE_DIR'] : '/public/';
  321.             // try {
  322.             //     $filesystem->mkdir($projectDir.$instanceDir.random_int(0, 1000));
  323.             // } catch (IOExceptionInterface $exception) {
  324.             //     echo "An error occurred while creating your directory at ".$exception->getPath();
  325.             // }
  326.             $folder = 'filestore/';
  328.             $path = $projectDir.'/public/'.$folder;
  329.             // $path = $projectDir.$instanceDir.$folder;
  330.             if (!is_dir($path)) { // does the path exist
  332.                 mkdir($path, 0700, true); //make the path with permission recursively
  333.             }
  334.             $file->move($path, $filename); // move the file to a path
  336.             // do some stuff here 
  337.             $owner = $this->getUser();
  338.             $file = new LostImage;
  340.             $file->setName($filename);
  341.             $file->setOriginalName($originalName);
  342.             $file->setFolder($folder);
  343.             $file->setOwner($owner);
  344.             $file->setAlt($filename);
  345.             $file->setType('image');
  346.             $file->setAccess();
  348.             $em->persist($file);
  349.             $em->flush();
  351.             $status = [
  352.                 'status' => "success",
  353.                 "fileUploaded" => true,
  354.                 "filepath" => $path.$filename,
  355.                 "id" => $file->getId()
  356.             ];
  357.         }
  358.         return new JsonResponse($status);
  359.     }
  361.     // public function processAvatarChange(Avatar $avatar, Request $request)
  363.     /**
  364.      * @Route("/upload_file", name="engine_upload_file", options={"expose"=true}, methods="GET|POST")
  365.      */
  366.     public function uploadFile(TranslationHelper $translationHelper, EntityManagerInterface $em, Request $request)
  367.     {
  368.         // retrieve the file with the name given in the form.
  369.         $file = $request->files->get('file');
  371.         $options = $request->request->all();
  373.         // If a file was uploaded
  374.         if (!is_null($file)) {
  376.             $originalName = $file->getClientOriginalName();
  378.             $status = array('status' => "success","fileUploaded" => false);
  380.             // generate a random name for the file but keep the extension
  381.             $filename = uniqid().".".$file->getClientOriginalExtension();
  382.             // https://stackoverflow.com/questions/12363657/the-concept-of-virtual-host-and-dns
  383.             $filesystem = new Filesystem();
  384.             $projectDir = $this->getParameter('kernel.project_dir');
  385.             // try {
  386.             //     $filesystem->mkdir($projectDir.'/public'.random_int(0, 1000));
  387.             // } catch (IOExceptionInterface $exception) {
  388.             //     echo "An error occurred while creating your directory at ".$exception->getPath();
  389.             // }
  391.             $instanceDir = isset($_ENV['INSTANCE_DIR']) ? $_ENV['INSTANCE_DIR'] : '/var/';
  393.             try {
  394.                 $filesystem->mkdir($projectDir.$instanceDir.random_int(0, 1000));
  395.             } catch (IOExceptionInterface $exception) {
  396.                 echo "An error occurred while creating your directory at ".$exception->getPath();
  397.             }
  400.             $folder = 'filestore/';
  401.             // $path = $projectDir.'/protected/'.$folder;
  403.             $path = $projectDir.$instanceDir.$folder;
  405.             if (!is_dir($path)) { // does the path exist
  407.                 mkdir($path, 0700, true); //make the path with permission recursively
  408.             }
  409.             $file->move($path, $filename); // move the file to a path
  411.             $ext = explode('.', $filename);
  412.             // dump($r[0]); 
  413.             // dump($r[1]); 
  414.             // dump(end($r)); 
  415.             // dd( 'here' );
  416.             $filetype = end($ext);
  418.             // $filetype = end(explode('.',$filename));
  420.             // dd($filetype);
  422.             // do some stuff here 
  423.             $owner = $this->getUser();
  424.             $file = new LostFile;
  426.             $file->setName($filename);
  427.             $file->setOriginalName($originalName);
  428.             $file->setFolder($folder);
  429.             $file->setOwner($owner);
  430.             $file->setAlt($filename);
  431.             $file->setType($filetype);
  432.             $file->setAccess($options['permissions']);
  433.             // $file->setAccess(['blah']);
  435.             $em->persist($file);
  436.             $em->flush();
  438.             $status = [
  439.                 'status' => "success",
  440.                 "fileUploaded" => true,
  441.                 "fileType" => $filetype,
  442.                 "fileName" => $filename,
  443.                 "originalName" => $originalName,
  444.                 "filepath" => $path.$filename,
  445.                 "id" => $file->getId()
  446.             ];
  447.         } else {
  448.             $status = [ 'data' => $translationHelper->translateString('There was a server error, please contact support if this keeps happening.')];
  449.         }
  450.         return new JsonResponse($status);
  451.     }
  454.     private function EngineSidebarService()
  455.     {
  456.         $userObj = $this->getUser();
  458.         if ($userObj == null) {
  459.             $user = 'unknown';
  460.             $tier = 'unknown';
  461.         } else {
  462.             $user = $userObj->getUsername();
  463.             $tier = 'atari'; //$user->getTier();
  464.         }
  466.         switch ($tier) {
  467.             case 'unknown':
  468.                 $menu = [];
  469.                 break;
  470.             case 'atari':
  471.                 $menu = [
  472.                     [
  473.                         'name'=> 'Dashboard',
  474.                         'sref' => "base.engine",
  475.                         'icon' => 'fal fa-fw fa-home'
  476.                     ],
  477.                     [
  478.                         'name'=> 'Activities',
  479.                         'sref'=> 'base.engine.laydown',
  480.                         'icon' => 'fal fa-fw fa-heartbeat'
  481.                     ],
  482.                     [
  483.                         'name'=> 'Budgets',
  484.                         'sref' => "base.engine.budget",
  485.                         'icon' => 'fal fa-fw fa-calculator'
  486.                     ],
  487.                     [
  488.                         'name'=> 'Activations',
  489.                         'sref' => "base.engine.activation",
  490.                         'icon' => 'fal fa-fw fa-list'
  491.                     ],
  492.                     [
  493.                         'name'=> 'Reports',
  494.                         'sref' => "base.engine.roi_report",
  495.                         'icon' => 'fal fa-fw fa-chart-line',
  496.                         'submenu' => [
  497.                             [
  498.                                 'name' => 'Return on Investment',
  499.                                 'sref' => "base.engine.roi_report",
  500.                                 'icon' => 'fal fa-fw fa-chart-line'
  501.                             ],
  502.                             [
  503.                                 'name' => 'Range Review',
  504.                                 'sref' => "base.engine.rr_report",
  505.                                 'icon' => 'fal fa-fw fa-chart-bar'
  506.                             ]
  507.                         ]
  508.                     ],
  509.                 ];
  510.                 break;
  511.         }
  513.         $menutwo = [
  514.             [
  515.                 'name'=> 'Maintenance',
  516.                 'sref'=> 'base.engine.maintenance',
  517.                 'icon' => 'fal fa-fw fa-wrench'
  518.             ],
  519.         ];
  521.         $menuthree = [
  522.             [
  523.                 'name'=> 'CRM',
  524.                 'sref' => "base.engine.profile",
  525.                 'icon' => 'fal fa-fw fa-users'
  526.             ],
  527.             [
  528.                 'name'=> 'Mail builder',
  529.                 'sref' => "",
  530.                 'icon' => 'fal fa-fw fa-envelope'
  531.             ],
  532.         ];
  534.         $navigationSetting = [
  535.             'menu' => $menu,
  536.             'menutwo' => $menutwo,
  537.             'menuthree' =>$menuthree ,
  538.         ];
  540.         return $navigationSetting;
  541.     }
  543.     private function EngineIgnitionService($sparkplug)
  544.     {
  545.         $user = 'unknown';
  546.         if ($sparkplug === 'goalposts') {
  547.             $userObj= $this->getUser();
  548.             if ($userObj == null) {
  549.                 $user = 'unknown';
  550.                 $tier = 'unknown';
  551.             } else {
  552.                 $user = $userObj->getUsername();
  553.                 $tier = 'atari'; //$user->getTier();
  554.             }
  556.             $ignitionSettings = [
  557.                 'username' => $user,
  558.                 'session_salt' => 'baseSession'.random_int(0, 100)
  559.             ];
  560.         } else {
  561.             $ignitionSettings = [
  562.                 'username' => $user,
  563.                 'session_salt' => 'baseSession'.random_int(0, 100)
  564.             ];
  565.         }
  566.         return $ignitionSettings;
  567.     }
  569.     /**
  570.      * @Route("/api/ignition-switch",name="ignite", options={"expose"=true})
  571.      * @return Response
  572.      */
  573.     public function IngitionSwitch()
  574.     {
  575.         $listGroup = '[
  576.                 {"endpoint":"base.engine.campaign.list","amount":10,"text":"Campaign",     "desc":"Manage your campaigns."}
  577.             ]';
  578.         // $userObj= $this->getUser();
  579.         // $user = $userObj->getUsername();
  580.         $userRole = preg_replace('/\s+/', '', $listGroup);
  581.         $response = [
  582.             'code' => 200,
  583.             'action' => $userRole
  584.         ];
  585.         return new JsonResponse($response);
  586.     }
  588.     /**
  589.      * @Route("/api/media_channel_data",name="api_media_channel_data", options={"expose"=true})
  590.      * @return Response
  591.      */
  592.     public function mediaChannelData()
  593.     {
  594.         $json = $this->getJsonFixture('media_channel_data');
  596.         $serializer = $this->container->get('serializer');
  597.         $serializedResponse = $serializer->serialize($json, 'json');
  598.         $response = new Response($serializedResponse);
  599.         $response->headers->set('Content-Type', 'application/json');
  600.         return $response;
  602.         //  $response = new JsonResponse();
  603.         // $response->setData($results);
  605.         // return $response;
  607.         // return new JsonResponse($response);
  608.     }
  610.     /**
  611.      */
  612.     private function getJsonFixture($file) // another blooming time sink
  613.     {
  614.         // $file = 'campaign_touchpoints'; //
  615.         $webPath =  $this->getParameter('kernel.project_dir');
  616.         $fixture = file_get_contents($webPath.'/fixture/'+$file+'.json');
  617.         return $fixture;
  618.         // $serializer = $this->container->get('serializer');
  619.         // $serializedResponse = $serializer->serialize($response, 'json');
  620.         // $response = new Response($serializedResponse);
  621.         // $response->headers->set('Content-Type', 'application/json');
  622.         // return $response;
  623.     }
  624. }