TabelleUtility - Code Metrics - Inspection of "add tests" - ComuneFI/FifreeCoreBundle - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( e5181e...c911bb )

by Andrea

created 2018-10-08 15:46 UTC

TabelleUtility A

↳ Parent: Project

Complexity

Total Complexity

Size/Duplication

Total Lines	201
Duplicated Lines	0 %

Test Coverage

Coverage

89.68%

Importance

Changes

Metric	Value
wmc	36
eloc	128
dl	0
loc	201
ccs	113
cts	126
cp	0.8968
rs	9.52
c	0
b	0
f	0

6 Methods

Rating	Name	Size	Complexity
A	__construct()	3	1
A	creaRecordTabelle()	28	6
A	scriviDB()	16	4
B	generaDB()	49	8
A	getListacampitabella()	35	5
C	listacampitabelladettagli()	53	12

<?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'];


        //$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, $parametri);
    }

    private function scriviDB($colonne, $nometabella, $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();
    }
}


1		<?php
2
3		namespace Fi\CoreBundle\DependencyInjection;
4
5		use Symfony\Component\DependencyInjection\ContainerInterface as Container;
6
7		class TabelleUtility
8		{
9
10		private $container;
11
12	2	public function __construct(Container $container)
13		{
14	2	$this->container = $container;
15	2	}
16
17	1	private function listacampitabelladettagli($nometabella, $escludiid, $colonne)
18		{
19	1	$risposta = array();
20	1	if ($escludiid == 1) {
21	1	$gestionepermessi = $this->container->get("ficorebundle.gestionepermessi");
		0 ignored issues – show Coding Style Comprehensibility introduced 2018-02-08 17:28 UTC by Report Bug Copy Issue Report The string literal `ficorebundle.gestionepermessi` does not require double quotes, as per coding-style, please use single quotes. PHP provides two ways to mark string literals. Either with single quotes `'literal'` or with double quotes `"literal"`. The difference between these is that string literals in double quotes may contain variables with are evaluated at run-time as well as escape sequences. String literals in single quotes on the other hand are evaluated very literally and the only two characters that needs escaping in the literal are the single quote itself (`\'`) and the backslash (`\\`). Every other character is displayed as is. Double quoted string literals may contain other variables or more complex escape sequences. <?php $singleQuoted = 'Value'; $doubleQuoted = "\tSingle is $singleQuoted"; print $doubleQuoted; will print an indented: `Single is Value` If your string literal does not contain variables or escape sequences, it should be defined using single quotes to make that fact clear. For more information on PHP string literals and available escape sequences see the PHP core documentation. Loading history...
22	1	$operatore = $gestionepermessi->utentecorrente();
		0 ignored issues – show Coding Style introduced 2018-02-07 22:10 UTC by Report Bug Copy Issue Report Equals sign not aligned with surrounding assignments; expected 8 spaces but found 1 space This check looks for multiple assignments in successive lines of code. It will report an issue if the operators are not in a straight line. To visualize $a = "a"; $ab = "ab"; $abc = "abc"; will produce issues in the first and second line, while this second example $a = "a"; $ab = "ab"; $abc = "abc"; will produce no issues. Loading history...
23	1	foreach ($colonne as $colonna) {
24	1	$nomecampo = trim(strtolower($colonna));
25	1	if (($nomecampo !== 'id') && (strpos($colonna, '_id') === false)) {
26	1	$qb = $this->container->get("doctrine")->getRepository("FiCoreBundle:Tabelle")
		0 ignored issues – show Coding Style introduced 2018-02-08 17:28 UTC by Report Bug Copy Issue Report Equals sign not aligned with surrounding assignments; expected 11 spaces but found 1 space This check looks for multiple assignments in successive lines of code. It will report an issue if the operators are not in a straight line. To visualize $a = "a"; $ab = "ab"; $abc = "abc"; will produce issues in the first and second line, while this second example $a = "a"; $ab = "ab"; $abc = "abc"; will produce no issues. Loading history... Coding Style Comprehensibility introduced 2018-02-08 17:28 UTC by Report Bug Copy Issue Report The string literal `doctrine` does not require double quotes, as per coding-style, please use single quotes. PHP provides two ways to mark string literals. Either with single quotes `'literal'` or with double quotes `"literal"`. The difference between these is that string literals in double quotes may contain variables with are evaluated at run-time as well as escape sequences. String literals in single quotes on the other hand are evaluated very literally and the only two characters that needs escaping in the literal are the single quote itself (`\'`) and the backslash (`\\`). Every other character is displayed as is. Double quoted string literals may contain other variables or more complex escape sequences. <?php $singleQuoted = 'Value'; $doubleQuoted = "\tSingle is $singleQuoted"; print $doubleQuoted; will print an indented: `Single is Value` If your string literal does not contain variables or escape sequences, it should be defined using single quotes to make that fact clear. For more information on PHP string literals and available escape sequences see the PHP core documentation. Loading history... Coding Style Comprehensibility introduced 2018-02-08 17:28 UTC by Report Bug Copy Issue Report The string literal `FiCoreBundle:Tabelle` does not require double quotes, as per coding-style, please use single quotes. PHP provides two ways to mark string literals. Either with single quotes `'literal'` or with double quotes `"literal"`. The difference between these is that string literals in double quotes may contain variables with are evaluated at run-time as well as escape sequences. String literals in single quotes on the other hand are evaluated very literally and the only two characters that needs escaping in the literal are the single quote itself (`\'`) and the backslash (`\\`). Every other character is displayed as is. Double quoted string literals may contain other variables or more complex escape sequences. <?php $singleQuoted = 'Value'; $doubleQuoted = "\tSingle is $singleQuoted"; print $doubleQuoted; will print an indented: `Single is Value` If your string literal does not contain variables or escape sequences, it should be defined using single quotes to make that fact clear. For more information on PHP string literals and available escape sequences see the PHP core documentation. Loading history...
27	1	->createQueryBuilder('t')
28	1	->where('LOWER(t.nometabella) = :nometabella')
29	1	->andWhere('LOWER(t.nomecampo) = :nomecampo')
30	1	->andWhere('t.operatori_id = :operatori_id')
31	1	->setParameter('nometabella', $nometabella)
32	1	->setParameter('nomecampo', $nomecampo)
33	1	->setParameter('operatori_id', $operatore['id'])
34	1	->getQuery();
35	1	$labeltrovata = $qb->getResult();
36	1	if (!$labeltrovata) {
37	1	$qb = $this->container->get("doctrine")->getRepository("FiCoreBundle:Tabelle")

ComuneFI / FifreeCoreBundle

Push — master ( e5181e...c911bb )

TabelleUtility A

Complexity

Size/Duplication

Test Coverage

Importance

6 Methods

Duplication Side-by-Side

Filter issues like