TabelleUtility::generaDB() - Code Metrics - Inspection of "improve Tabelle utility" - ComuneFI/FifreeCoreBundle - Measure and Improve Code Quality continuously with Scrutinizer

Passed
Push — master ( 17e906...d315bd )

by Andrea
created 2018-02-08 16:48 UTC
TabelleUtility::generaDB() C

↳ Parent: TabelleUtility
Complexity

Conditions	8
Paths	12
Size

Total Lines	49
Code Lines	31
Duplication

Lines	0
Ratio	0 %
Code Coverage

Tests	0
CRAP Score	72
Importance

Changes
Metric	Value
cc	8
eloc	31
nc	12
nop	1
dl	0
loc	49
ccs	0
cts	40
cp	0
crap	72
rs	6.1403
c	0
b	0
f	0
<?php

namespace Fi\CoreBundle\DependencyInjection;

use Symfony\Component\DependencyInjection\ContainerInterface as Container;

class TabelleUtility
{

    private $container;

    public function __construct(Container $container)
    {
        $this->container = $container;
    }

    private function listacampitabelladettagli($nometabella, $escludiid, $colonne)
    {
        $risposta = array();
        if ($escludiid == 1) {
            $gestionepermessi = $this->container->get("ficorebundle.gestionepermessi");
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
            $operatore = $gestionepermessi->utentecorrente();
$a = "a";
$ab = "ab";
$abc = "abc";
            foreach ($colonne as $colonna) {
                $nomecampo = trim(strtolower($colonna));
                if (($nomecampo !== 'id') && (strpos($colonna, '_id') === false)) {
                    $qb = $this->container->get("doctrine")->getRepository("FiCoreBundle:Tabelle")
$a = "a";
$ab = "ab";
$abc = "abc";
                            ->createQueryBuilder('t')
                            ->where('LOWER(t.nometabella) = :nometabella')
                            ->andWhere('LOWER(t.nomecampo) = :nomecampo')
                            ->andWhere('t.operatori_id = :operatori_id')
                            ->setParameter('nometabella', $nometabella)
                            ->setParameter('nomecampo', $nomecampo)
                            ->setParameter('operatori_id', $operatore['id'])
                            ->getQuery();
                    $labeltrovata = $qb->getResult();
                    if (!$labeltrovata) {
                        $qb = $this->container->get("doctrine")->getRepository("FiCoreBundle:Tabelle")
$a = "a";
$ab = "ab";
$abc = "abc";
                                ->createQueryBuilder('t')
                                ->where('LOWER(t.nometabella) = :nometabella')
                                ->andWhere('LOWER(t.nomecampo) = :nomecampo')
                                ->andWhere('t.operatori_id IS NULL')
                                ->setParameter('nometabella', $nometabella)
                                ->setParameter('nomecampo', $nomecampo)
                                ->getQuery();
                        $labeltrovata = $qb->getResult();
                        if (!$labeltrovata) {
                            $risposta[$colonna] = $colonna;
                        } else {
                            if (($labeltrovata[0]->getEtichettaindex()) && ($labeltrovata[0]->getEtichettaindex() != '')) {
                                $risposta[$colonna] = trim($labeltrovata[0]->getEtichettaindex());
                            } else {
                                $risposta[$colonna] = $colonna;
                            }
                        }
                    } else {
                        if (($labeltrovata[0]->getEtichettaindex()) && ($labeltrovata[0]->getEtichettaindex() != '')) {
                            $risposta[$colonna] = trim($labeltrovata[0]->getEtichettaindex());
                        } else {
                            $risposta[$colonna] = $colonna;
                        }
                    }
                }
            }
        } else {
            foreach ($colonne as $colonna) {
                $risposta[$colonna] = $colonna;
            }
        }
        return $risposta;
    }

    public function getListacampitabella($parametri)
    {
        $nometabella = $parametri['nometabella'];
$a = "a";
$ab = "ab";
$abc = "abc";
        $escludiid = $parametri['escludiid'];
$a = "a";
$ab = "ab";
$abc = "abc";
        $em = $this->container->get("doctrine")->getManager();
$a = "a";
$ab = "ab";
$abc = "abc";
        $tableClassName = "";
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
        $entityClass = "";
$a = "a";
$ab = "ab";
$abc = "abc";
        $bundles = $this->container->get('kernel')->getBundles();
$a = "a";
$ab = "ab";
$abc = "abc";
        foreach ($bundles as $bundle) {
            $className = get_class($bundle);
$a = "a";
$ab = "ab";
$abc = "abc";
            $entityClass = substr($className, 0, strrpos($className, '\\'));
$a = "a";
$ab = "ab";
$abc = "abc";
            $tableClassName = '\\' . $entityClass . '\\Entity\\' . $nometabella;
            if (!class_exists($tableClassName)) {
                $tableClassName = '';
                continue;
            } else {
                break;
            }
        }

        if (!$tableClassName) {
            throw new \Exception('Entity per la tabella ' . $nometabella . ' non trovata', '-1');
        }

        if (!$entityClass) {
            throw new \Exception('Entity class per la tabella ' . $nometabella . ' non trovata', '-1');
        }

        $bundleClass = str_replace('\\', '', $entityClass);
        $c = $em->getClassMetadata($bundleClass . ':' . $nometabella);
$a = "a";
$ab = "ab";
$abc = "abc";
        $colonne = $c->getColumnNames();
$a = "a";
$ab = "ab";
$abc = "abc";
        $risposta = $this->listacampitabelladettagli($nometabella, $escludiid, $colonne);
$a = "a";
$ab = "ab";
$abc = "abc";
        //natcasesort($risposta);
        asort($risposta, SORT_NATURAL | SORT_FLAG_CASE);
        return $risposta;
    }
    
    public function generaDB($parametri)
    {
        if (!isset($parametri['tabella'])) {
            return false;
        }
        if (!isset($parametri['namespace'])) {
            return false;
        }
        if (!isset($parametri['bundle'])) {
            return false;
        }

        $namespace = $parametri['namespace'];
        $bundle = $parametri['bundle'];
$a = "a";
$ab = "ab";
$abc = "abc";

        $nomebundle = $namespace . $bundle . 'Bundle';

        $nometabella = $parametri['tabella'];
        $em = $this->container->get("doctrine")->getManager();
$a = "a";
$ab = "ab";
$abc = "abc";

        $bundles = $this->container->get('kernel')->getBundles();
$a = "a";
$ab = "ab";
$abc = "abc";
        $tableClassName = "";
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
        $entityClass = "";
$a = "a";
$ab = "ab";
$abc = "abc";
        foreach ($bundles as $bundle) {
            $className = get_class($bundle);
$a = "a";
$ab = "ab";
$abc = "abc";
            $entityClass = substr($className, 0, strrpos($className, '\\'));
$a = "a";
$ab = "ab";
$abc = "abc";
            $tableClassName = '\\' . $entityClass . '\\Entity\\' . $nometabella;
            if (!class_exists($tableClassName)) {
                $tableClassName = '';
                continue;
            } else {
                break;
            }
        }

        if (!$tableClassName) {
            throw new \Exception('Entity per la tabella ' . $nometabella . ' non trovata', '-1');
        }

        if (!$entityClass) {
            throw new \Exception('Entity class per la tabella ' . $nometabella . ' non trovata', '-1');
        }

        $bundleClass = str_replace('\\', '', $entityClass);

        $c = $em->getClassMetadata($bundleClass . ':' . $nometabella);

        $colonne = $c->getColumnNames();
        $this->scriviDB($colonne, $nometabella, $nomebundle, $parametri);
    }

    private function scriviDB($colonne, $nometabella, $nomebundle, $parametri)
    private function scriviDB($colonne, $nometabella, /** @scrutinizer ignore-unused */ $nomebundle, $parametri)
    {
        foreach ($colonne as $colonna) {
            $vettorericerca = array(
                'nometabella' => $nometabella,
                'nomecampo' => $colonna,
            );

            if (isset($parametri['operatore'])) {
                $vettorericerca['operatori_id'] = $parametri['operatore'];
            }

            $trovato = $this->container->get("doctrine")->getRepository('FiCoreBundle:Tabelle')->findBy($vettorericerca, array());
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;

            if (empty($trovato)) {
                $this->creaRecordTabelle($nometabella, $colonna, $vettorericerca, $parametri);
            }
        }
    }

    private function creaRecordTabelle($nometabella, $colonna, $vettorericerca, $parametri)
    {
        $crea = new \Fi\CoreBundle\Entity\Tabelle();
        $crea->setNometabella($nometabella);
        $crea->setNomecampo($colonna);

        if (isset($parametri['operatore'])) {
            $idOperatore = $parametri['operatore'];
$a = "a";
$ab = "ab";
$abc = "abc";
            $creaoperatore = $this->container->get("doctrine")->getRepository('FiCoreBundle:Operatori')->find($idOperatore);
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
            if ($creaoperatore instanceof \Fi\CoreBundle\Entity\Operatori) {
                $crea->setOperatori($creaoperatore);
            }

            $vettorericerca['operatori_id'] = null;
            $ritrovato = $this->container->get("doctrine")->getRepository('FiCoreBundle:Tabelle')->findOneBy($vettorericerca);
$a = "a";
$ab = "ab";
$abc = "abc";

            if (!empty($ritrovato)) {
                $crea->setMostrastampa($ritrovato->hasMostrastampa() ? true : false);
                $crea->setMostraindex($ritrovato->hasMostraindex() ? true : false);
            }
        } else {
            $crea->setMostrastampa(true);
            $crea->setMostraindex(true);
        }

        $ma = $this->container->get("doctrine")->getManager();
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
        $ma->persist($crea);
        $ma->flush();
    }
}

ComuneFI / FifreeCoreBundle

Push — master ( 17e906...d315bd )

TabelleUtility::generaDB() C

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like
