busigbil / MVC2025

src/Controller/ProjectController.php

<?php

namespace App\Controller;

use Amenadiel\JpGraph\Graph\Graph;
use Amenadiel\JpGraph\Plot\Plot;
use Amenadiel\JpGraph\Plot\BarPlot;
use Amenadiel\JpGraph\Plot\LinePlot;
use App\Entity\Goals\Descriptions;
use App\Entity\Goals\Texts;
use App\Repository\DescriptionsRepository;
use App\Repository\TextsRepository;
use App\Repository\TimeValueRepository;
use Doctrine\Persistence\ManagerRegistry;
use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
use Symfony\Component\HttpFoundation\Request;
use Symfony\Component\HttpFoundation\Response;
use Symfony\Component\Routing\Attribute\Route;
use Symfony\Component\Routing\RouterInterface;

class ProjectController extends AbstractController
{
    #[Route("/back", name: "back")]
    public function back(): Response
    {
        return $this->redirectToRoute('home');
    }

    #[Route("/proj", name: "project", methods: ['GET'])]
    public function project(
        TextsRepository $textRepo
    ): Response
    {
        $texts = $textRepo->findAll();

        return $this->render(
            'project/landing_page.html.twig',
            array('indicators' => $texts)
        );
    }

    #[Route("/proj/indicator/{id}", name: "indicator", methods: ['GET'])]
    public function indicator(
        DescriptionsRepository $descriptionsRepo,
        TextsRepository $textRepo,
        TimeValueRepository $timeValueRepo,

The parameter $timeValueRepo is not used and could be removed.

        int $id
    ): Response
    {
        $indicator = $textRepo->find($id);
        
        if (!$indicator) {
            throw new Exception("No indicator found for id");

The type App\Controller\Exception was not found. Did you mean Exception? If so, make sure to prefix the type with \.

        };

        $description = $descriptionsRepo->findOneBy([
            'Target' => $indicator->getTarget()
        ]);

        return $this->render(
            'project/indicator.html.twig',
            [
                'indicator' => $indicator,
                'description' => $description
            ]
        );
    }

    #[Route("/proj/indicator/plot/{id}", name: "plot", methods: ['GET'])]
    public function plot(
        DescriptionsRepository $descriptionsRepo,
        TextsRepository $textRepo,
        TimeValueRepository $timeValueRepo,
        int $id
    ): Response
    {
        $indicator = $textRepo->find($id);

        $description = $descriptionsRepo->findOneBy([

The assignment to $description is dead and can be removed.

            'Target' => $indicator->getTarget()
        ]);

        # find entity where Target in descriptions
        $timeValue = $timeValueRepo->findBy([
            'target' => $indicator->getTarget() 
        ]);

        # Add data to graph
        $dataY = [];
        $dataX = [];
        foreach ($timeValue as $val) {
            $dataY[] = floatval($val->getValue());
            $dataX[] = intval($val->getYear());
        }

        $graph = new Graph(400, 400);
        $graph->SetScale('textlin');
        $graph->Set90AndMargin(50,50,10,10);
        $graph->yscale->SetAutoTicks();
        $graph->xaxis->SetTickLabels($dataX);
        
        $graph->xaxis->SetLabelMargin(10);
        $graph->xaxis->SetLabelAlign('right','center');
        $graph->yaxis->Hide();

        $plot = new BarPlot($dataY);
        $plot->SetFillColor('#003148');
        $plot->SetWidth(0.5);

        $plot->value->Show();
        $plot->value->SetColor('black','darkred');

        $plot->value->SetFormat('%.2f');

        $index = array_key_first($dataY);
        if ($dataY[$index] < 1) {
            $plot->value->SetFormat('%.3f');
        }
        if ($dataY[$index] > 100) {
            $plot->value->SetFormat('%.0f');
        }

        $graph->Add($plot);

        ob_start();
        $graph->Stroke();
        $imageData = ob_get_clean();

        $response = new Response($imageData);
        $response->headers->set('Content-Type', 'image/png');

        return $response;        
    }

    #[Route("/proj/about", name: "about", methods: ['GET'])]
    public function about(): Response
    {
        return $this->render('project/about.html.twig');
    }

    #[Route("/proj/api", name: "api", methods: ['GET'])]
    public function api(
        RouterInterface $router,
        TextsRepository $textRepo
    ): Response
    {
        //Get all routes.
        $routes = $router->getRouteCollection()->all();
        $apiArr = array();

        //Add route to array if starts with api.
        foreach ($routes as $routeName => $route) {

            if (str_starts_with($route->getPath(), '/proj/api/')) {

                $description = $route->getDefault('description') ?? 'Beskrivning saknas';
                $target = $route->getDefault('target') ?? null;

                $apiArr[] = [
                    'header' => $route->getPath(),
                    'description' => $description,
                    'target' => $target,
                    'name' => $routeName
                ];
            }
        }

        //Get target for texts
        $texts = $textRepo->findAll();
        $indicators = [];

        foreach ($texts as $id => $text) {
            $indicators[$id] = $text;
        }

        $data = [
            'routes' => $apiArr,
            'indicators' => $indicators
        ];
        return $this->render('project/api.html.twig', $data);
    }

    #[Route("/proj/api/goal/{target}", name: "json-goal", methods: ['GET'], defaults: ['description' => 'Returnerar en JSON-struktur med beskrivningen av valt delmål.', 'target' => '15.4'])]
    public function jsonGoal(
        TextsRepository $textRepo,
        DescriptionsRepository $descriptionsRepo,

The parameter $descriptionsRepo is not used and could be removed.

        string $target
    ): Response
    {
        $text = $textRepo->findOneBy([
            'Target' => $target
        ]);
        
        if (!$text) {
            throw new Exception("No indicator found for target");
        };
        
        $response = $this->json($text);
        $response->setEncodingOptions(
            $response->getEncodingOptions() | JSON_PRETTY_PRINT
        );
        return $response;
    }

    #[Route("/proj/api/goals", name: "json-goals", methods: ['GET'], defaults: ['description' => 'Returnerar en JSON-struktur med beskrivning av alla delmål.'])]
    public function jsonGoals(
        TextsRepository $textRepo
    ): Response
    {
        $texts = $textRepo->findAll();

        if (empty($texts)) {
            throw $this->createNotFoundException(
                'No indicators found'
            );
        }
        
        $response = $this->json($texts);
        $response->setEncodingOptions(
            $response->getEncodingOptions() | JSON_PRETTY_PRINT
        );
        return $response;
    }

    #[Route("/proj/api/alldata", name: "json-alldata", methods: ['GET'], defaults: ['description' => 'Returnerar en JSON-struktur med all tidseriedata för alla indikatorer.'])]
    public function jsonAllData(
        TimeValueRepository $timeValueRepo,
    ): Response
    {
        $timeData = $timeValueRepo->findAll();

        if (empty($timeData)) {
            throw $this->createNotFoundException(
                'No time-data found'
            );
        }
        
        $response = $this->json($timeData);
        $response->setEncodingOptions(
            $response->getEncodingOptions() | JSON_PRETTY_PRINT
        );
        return $response;
    }

    #[Route("/proj/api/data/{target}", name: "json-data", methods: ['GET'], defaults: ['description' => 'Returnerar en JSON-struktur med tidseriedata för en specifik indikator.', 'target' => '15.1'])]
    public function jsonData(
        TimeValueRepository $timeValueRepo,
        string $target
    ): Response
    {

        $timeValue = $timeValueRepo->findOneBy([
            'target' => $target 
        ]);

        if (empty($timeValue)) {
            throw $this->createNotFoundException(
                'No data found'
            );
        }

        $response = $this->json($timeValue);
        $response->setEncodingOptions(
            $response->getEncodingOptions() | JSON_PRETTY_PRINT
        );
        return $response;
    }

    #[Route("/proj/api/update", name: "update", methods: ['POST'], defaults: ['description' => 'Textfältet för vald indikator uppdateras och returnerar en JSON-struktur med beskrivningen av indikatorn.'])]
    public function jsonUpdate(
        TextsRepository $textRepo,
        Request $request,
        ManagerRegistry $doctrine
    ): Response
    {
        $entityManager = $doctrine->getManager();
        //Get the indicator selected in dropdown
        $id = $request->request->get('indicator');
        $indicator = $textRepo->find($id);

        if (!$indicator) {
            throw new Exception("No indicator found");
        };
        
        //Set text to db
        $indicator->setText2((string) $request->request->get('text2'));

        $entityManager->flush();

        $response = $this->json($indicator);
        $response->setEncodingOptions(
            $response->getEncodingOptions() | JSON_PRETTY_PRINT
        );
        return $response;

    }
}