FiCoreTabellaControllerTrait::exportXls() - Code Metrics - ComuneFI/BiCoreBundle - Measure and Improve Code Quality continuously with Scrutinizer

FiCoreTabellaControllerTrait::exportXls() A
last analyzed 2023-10-24 12:58 UTC

↳ Parent: FiCoreTabellaControllerTrait
Complexity

Conditions	5
Paths	11
Size

Total Lines	39
Code Lines	26
Duplication

Lines	0
Ratio	0 %
Code Coverage

Tests	18
CRAP Score	5.9256
Importance

Changes
Metric	Value
cc	5
eloc	26
nc	11
nop	3
dl	0
loc	39
ccs	18
cts	27
cp	0.6667
crap	5.9256
rs	9.1928
c	0
b	0
f	0
<?php

namespace Cdf\BiCoreBundle\Controller;

use Cdf\BiCoreBundle\Utils\Export\TabellaXls;
use Cdf\BiCoreBundle\Utils\Tabella\ParametriTabella;
use Cdf\BiCoreBundle\Utils\Tabella\Tabella;
use Symfony\Component\HttpFoundation\Request;
use Symfony\Component\HttpFoundation\Response;
use Symfony\Component\HttpFoundation\JsonResponse;
use Symfony\Component\Security\Core\Exception\AccessDeniedException;
use Doctrine\Persistence\ManagerRegistry;

trait FiCoreTabellaControllerTrait
{

    public function tabella(Request $request, ManagerRegistry $doctrine): Response
    {
        if (!$this->permessi->canRead($this->getController())) {
        if (!$this->permessi->canRead($this->/** @scrutinizer ignore-call */ getController())) {
            throw new AccessDeniedException('Non si hanno i permessi per visualizzare questo contenuto');
        }

        $parametripassati = array_merge($request->get('parametri'), ['user' => $this->getUser()]);
        $parametripassati = array_merge(/** @scrutinizer ignore-type */ $request->get('parametri'), ['user' => $this->getUser()]);
        $parametriform = isset($parametripassati['parametriform']) ?
                json_decode(ParametriTabella::getParameter($parametripassati['parametriform']), true) : [];
        $classbundle = ParametriTabella::getParameter($parametripassati['entityclass']);
        $formbundle = ParametriTabella::getParameter($parametripassati['formclass']);
        $formType = $formbundle . 'Type';

        $entity = new $classbundle();
        $controller = ParametriTabella::getParameter($parametripassati['nomecontroller']);
        $form = $this->createForm(
        $form = $this->createForm(
            $formType,
            $entity,
            ['attr' => [
                        'id' => 'formdati' . $controller,
                    ],
                    'action' => $this->generateUrl($controller . '_new'),
                    'action' => $this->/** @scrutinizer ignore-call */ generateUrl($controller . '_new'),
                    'parametriform' => $parametriform,
                ]
        );

        $parametri = array_merge($parametripassati, $this->getParametriTabella($doctrine, $parametripassati));
        $parametri['form'] = $form->createView();
        $templateobj = $this->getTabellaTemplateInformations($controller);
        $parametri['templatelocation'] = $templateobj['path'];

        return $this->render(
        return $this->/** @scrutinizer ignore-call */ render(
            $templateobj['template'],
            ['parametri' => $parametri]
        );
    }

    /**
     *
     * @codeCoverageIgnore
     * It returns true if the request belongs to an API service, false otherwise
     *
     * @param array<string> $parametripassati
     * @return bool
     */
    private function isApi(&$parametripassati): bool
    {
        $isapi = false;
        if (isset($parametripassati['isapi'])) {
            $isapi = true;
        }
        return $isapi;
    }

    public function exportXls(Request $request, TabellaXls $tabellaxls, ManagerRegistry $doctrine): JsonResponse
    {
        try {
            $parametripassati = array_merge($request->get('parametri'), ['user' => $this->getUser()]);
            $parametripassati = array_merge(/** @scrutinizer ignore-type */ $request->get('parametri'), ['user' => $this->getUser()]);
            $parametripassati['estraituttirecords'] = ParametriTabella::setParameter('1');

            $filexls = $tabellaxls->esportaexcel($this->getParametriTabellaXls($doctrine, $parametripassati));
            $filexlsbuffer = file_get_contents($filexls);
            if ($filexlsbuffer === false) {
                $response = [
                    'status' => '500',
                    'file' => 'Impossibile leggere il file excel generato',
                ];
            } else {
                if (file_exists($filexls)) {
                    $response = [
                        'status' => '200',
                        'file' => 'data:application/vnd.ms-excel;base64,' . base64_encode($filexlsbuffer),
                    ];
                    try {
                        unlink($filexls);
                    } catch (\Exception $e) {
                        //IGNORE THE ERROR OF UNLINK
                    }
                } else {
                    $response = [
                        'status' => '501',
                        'file' => 'Impossibile generare il file excel',
                    ];
                }
            }
        } catch (\Exception $exc) {
            $response = [
                'status' => '500',
                'file' => $exc->getFile() . ' -> Riga: ' . $exc->getLine() . ' -> ' . $exc->getMessage(),
            ];
        }

        return new JsonResponse($response);
    }

    /**
     *
     * @param array<mixed> $parametripassati
     * @return array<mixed>
     */
    protected function getParametriTabella(ManagerRegistry $doctrine, array $parametripassati)
    {
        $configurazionetabella = new Tabella($doctrine, $parametripassati);
        $parametritabella = [
            'parametritabella' => $configurazionetabella->getConfigurazionecolonnetabella(),
            'recordstabella' => $this->getRecordsTabella($this->isApi($parametripassati), $configurazionetabella),
            'paginacorrente' => $configurazionetabella->getPaginacorrente(),
            'paginetotali' => $configurazionetabella->getPaginetotali(),
            'righetotali' => $configurazionetabella->getRighetotali(),
            'traduzionefiltri' => $configurazionetabella->getTraduzionefiltri(),
        ];

        return $parametritabella;
    }

    /**
     * Append records to the given parameters of table.
     * It deals the difference between an API service or a ORM service.
     *
     * @param bool $isApi
     * @param mixed $configurazionetabella
     * @return mixed
     */
    private function getRecordsTabella(bool $isApi, &$configurazionetabella)
    {
        $results = [];
        if ($isApi) {
            $results = $configurazionetabella->getApiRecordstabella();
        } else {
            $results = $configurazionetabella->getRecordstabella();
        }
        return $results;
    }

    /**
     *
     * @param array<mixed> $parametripassati
     * @return array<mixed>
     */
    protected function getParametriTabellaXls(ManagerRegistry $doctrine, array $parametripassati): array
    {
        $configurazionetabella = new Tabella($doctrine, $parametripassati);
        $parametritabella = [
            'parametritabella' => $configurazionetabella->getConfigurazionecolonnetabella(),
            'recordstabella' => $this->getRecordsTabella($this->isApi($parametripassati), $configurazionetabella),
            'paginacorrente' => $configurazionetabella->getPaginacorrente(),
            'paginetotali' => $configurazionetabella->getPaginetotali(),
            'righetotali' => $configurazionetabella->getRighetotali(),
            'traduzionefiltri' => $configurazionetabella->getTraduzionefiltri(),
            'nomecontroller' => ParametriTabella::getParameter($parametripassati['nomecontroller']),
        ];

        return $parametritabella;
    }

    /**
     *
     * @param string $controller
     * @return array<string>
     */
    protected function getTabellaTemplateInformations(string $controller): array
    {
        $template = $controller . '/Tabella/tabellacontainer.html.twig';
        $path = $controller . '/';
        if (!$this->template->getLoader()->exists($template)) {
            $template = '@BiCore/' . $controller . '/Tabella/tabellacontainer.html.twig';
            $path = '@BiCore/' . $controller . '/';
            if (!$this->template->getLoader()->exists($template)) {
                $path = '@BiCore/Standard/';
                $template = $path . 'Tabella/tabellacontainer.html.twig';
            }
        }

        return ['path' => $path, 'template' => $template];
    }
}

ComuneFI / BiCoreBundle

FiCoreTabellaControllerTrait::exportXls() A last analyzed 2023-10-24 12:58 UTC

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like

FiCoreTabellaControllerTrait::exportXls() A
last analyzed 2023-10-24 12:58 UTC
