GrigliaRegoleUtils - Code Metrics - Inspection of "improve grid filters tests" - ComuneFI/FifreeCoreBundle - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( ce89ba...4bc45e )

by Andrea

created 2018-02-21 21:53 UTC

GrigliaRegoleUtils B

↳ Parent: Project

Complexity

Total Complexity

Size/Duplication

Total Lines	203
Duplicated Lines	0 %

Test Coverage

Coverage

94.78%

Importance

Changes

Metric	Value
wmc	38
dl	0
loc	203
ccs	127
cts	134
cp	0.9478
rs	8.3999
c	0
b	0
f	0

7 Methods

Rating	Name	Size	Complexity
B	getTipoRegola()	27	3
B	setTipoBoolean()	14	7
A	getRegolaPerData()	4	3
C	setRegole()	36	7
B	getDoctrineConditions()	40	5
B	campiesclusi()	31	5
B	setSingolaRegola()	21	8

<?php

namespace Fi\CoreBundle\Utils;

use Fi\CoreBundle\Controller\FiUtilita;

class GrigliaRegoleUtils
{

    public static function getTipoRegola(&$tipo, &$regola, $parametri)
    {
        $doctrine = $parametri['doctrine'];
$a = "a";
$ab = "ab";
$abc = "abc";
        $nometabella = $parametri['nometabella'];
        $entityName = $parametri['entityName'];
$a = "a";
$ab = "ab";
$abc = "abc";
        $bundle = $parametri['bundle'];
$a = "a";
$ab = "ab";
$abc = "abc";

        $elencocampi = $doctrine->getClassMetadata($entityName)->getFieldNames();

        if (strrpos($regola['field'], '.') == 0) {
            if (in_array($regola['field'], $elencocampi) === true) {
                $type = $doctrine->getClassMetadata($entityName)->getFieldMapping($regola['field']);
                $tipo = $type['type'];

                //Si aggiunge l'alias al campo altrimenti da Doctrine2 fallisce la query
                $regola['field'] = $nometabella . '.' . $regola['field'];
            }
        } else {
            //Altrimenti stiamo analizzando il campo di una tabella in leftjoin pertanto si cercano le informazioni sul tipo
            //dei campi nella tabella "joinata"
            $tablejoined = substr($regola['field'], 0, strrpos($regola['field'], '.'));
            $fieldjoined = substr($regola['field'], strrpos($regola['field'], '.') + 1);

            $entityNametablejoined = $bundle . ':' . $tablejoined;

            $type = $doctrine->getClassMetadata($entityNametablejoined)->getFieldMapping($fieldjoined);
            $tipo = $type['type'];
        }
    }

    public static function getRegolaPerData(&$regola)
    {
        if (isset($regola) && count($regola) > 0) {
            $regola['data'] = preg_replace('/^(\'(.*)\'|"(.*)")$/', '$2$3', $regola['data']);
        }
    }

    public static function setRegole(&$q, &$primo, $parametri = array())
    {
        $regole = $parametri['regole'];
        //file_put_contents("/tmp/appo.log", print_r($regole, true) . "\n", FILE_APPEND);

        //$tipof = $parametri['tipof'];

        $tipo = null;
        //file_put_contents("/tmp/appo.log", "\n\n" .  . "\n\n", FILE_APPEND);

        foreach ($regole as $key => $regola) {
            //file_put_contents("/tmp/appo.log", "***1***" . "\n", FILE_APPEND);

            //Se il campo non ha il . significa che è necessario aggiungere il nometabella
            self::getTipoRegola($tipo, $regola, $parametri);
            $tipof = isset($regola["typof"]) ? $regola["typof"] : 'AND';
$a = "a";
$ab = "ab";
$abc = "abc";
            $regola = self::setSingolaRegola($tipo, $regola);
            if (!$regola) {
                continue;
            }

            $conditions = self::getDoctrineConditions($regola, $key);

            $condition = $conditions["condition"];
$a = "a";
$ab = "ab";
$abc = "abc";
            $sqlparameter = $conditions["sqlparameter"];
<?php

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

print $doubleQuoted;
            $value = $conditions["value"];
$a = "a";
$ab = "ab";
$abc = "abc";

            if ($primo) {
                $primo = false;
                $q->where($condition);
            } else {
                //file_put_contents("/tmp/appo.log", $tipof . "\n", FILE_APPEND);

                if (strtoupper($tipof) == 'OR') {
                    $q->orWhere($condition);
                } else {
                    $q->andwhere($condition);
                }
            }
            if ($sqlparameter) {
                $q->setParameter($sqlparameter, $value);
            }
            /* $condizioneAND = $regola['field'] . ' ' .

              GrigliaUtils::$decodificaop[$regola['op']] . ' ' .
              GrigliaUtils::$precarattere[$regola['op']] .
              str_replace("'", "''", $regola['data']) .
              GrigliaUtils::$postcarattere[$regola['op']];
              $q->andWhere($condizioneAND); */
            //file_put_contents("/tmp/appo.log", dump($fieldparm) . "\n", FILE_APPEND);

            //file_put_contents("/tmp/appo.log", dump($sqlparameter) . "\n", FILE_APPEND);

            //file_put_contents("/tmp/appo.log", print_r($condition, true) . "\n", FILE_APPEND);

            //file_put_contents("/tmp/appo.log", print_r($value, true) . "\n", FILE_APPEND);

        }
    }

    private static function getDoctrineConditions($regola, $key)
    {
        //file_put_contents("/tmp/appo.log", "!" . $tipo . "! " . print_r($regola,true) . "\n", FILE_APPEND);

        if (GrigliaUtils::$decodificaop[$regola['op']] == 'IS' || GrigliaUtils::$decodificaop[$regola['op']] == 'IS NOT') {
            $condition = GrigliaUtils::$precaratterecampo[$regola['op']]
$a = "a";
$ab = "ab";
$abc = "abc";
                    . $regola['field']
                    . GrigliaUtils::$postcaratterecampo[$regola['op']] . " "
<?php

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

print $doubleQuoted;
                    . GrigliaUtils::$decodificaop[$regola['op']] . " NULL";
<?php

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

print $doubleQuoted;
            $value = null;
$a = "a";
$ab = "ab";
$abc = "abc";
            $sqlparameter = null;
            return array("condition" => $condition, "sqlparameter" => $sqlparameter, "value" => $value);
<?php

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

print $doubleQuoted;
        }

        if (GrigliaUtils::$decodificaop[$regola['op']] == 'IN' || GrigliaUtils::$decodificaop[$regola['op']] == 'NOT IN') {
            $fieldparm = GrigliaUtils::$precaratterecampo[$regola['op']]
$a = "a";
$ab = "ab";
$abc = "abc";
                    . str_replace(".", "", ":" . $regola['field'] . $key)
<?php

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

print $doubleQuoted;
                    . GrigliaUtils::$postcaratterecampo[$regola['op']];
            $sqlparameter = str_replace(".", "", ":" . $regola['field'] . $key);
<?php

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

print $doubleQuoted;
            $condition = GrigliaUtils::$precarattere[$regola['op']]
$a = "a";
$ab = "ab";
$abc = "abc";
                    . $regola['field']
                    . GrigliaUtils::$postcarattere[$regola['op']]
                    . " " . GrigliaUtils::$decodificaop[$regola['op']] . " " . $fieldparm;
<?php

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

print $doubleQuoted;
            $value = explode(",", str_replace(", ", ",", $regola['data']));
$a = "a";
$ab = "ab";
$abc = "abc";
            //file_put_contents("/tmp/appo.log", "|" . $regola['op'] . "| " . $regola['data'] . "\n", FILE_APPEND);

            return array("condition" => $condition, "sqlparameter" => $sqlparameter, "value" => $value);
<?php

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

print $doubleQuoted;
        }

        //file_put_contents("/tmp/appo.log", "|" . $regola['op'] . "| " . $regola['data'] . "\n", FILE_APPEND);

        $fieldparm = GrigliaUtils::$precaratterecampo[$regola['op']]
$a = "a";
$ab = "ab";
$abc = "abc";
                . str_replace(".", "", ":" . $regola['field'] . $key)
<?php

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

print $doubleQuoted;
                . GrigliaUtils::$postcaratterecampo[$regola['op']];
        $sqlparameter = str_replace(".", "", $regola['field'] . $key);
<?php

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

print $doubleQuoted;
        $condition = GrigliaUtils::$precaratterecampo[$regola['op']]
$a = "a";
$ab = "ab";
$abc = "abc";
                . $regola['field']
                . GrigliaUtils::$postcaratterecampo[$regola['op']] . " "
<?php

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

print $doubleQuoted;
                . GrigliaUtils::$decodificaop[$regola['op']] . " " . $fieldparm;
<?php

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

print $doubleQuoted;
        $value = GrigliaUtils::$precarattere[$regola['op']]
$a = "a";
$ab = "ab";
$abc = "abc";
                . $regola['data']
                . GrigliaUtils::$postcarattere[$regola['op']];
        return array("condition" => $condition, "sqlparameter" => $sqlparameter, "value" => $value);
<?php

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

print $doubleQuoted;
    }

    public static function setSingolaRegola($tipo, $regola)
    {
        //file_put_contents("/tmp/appo.log", "...". $tipo."-" .$regola['data']. "\n", FILE_APPEND);

        if (!$tipo || $tipo == "integer" || $tipo == "float") {
<?php

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

print $doubleQuoted;
            GrigliaUtils::setVettoriPerNumero();
        }
        if ($tipo == 'date' || $tipo == 'datetime') {
            GrigliaUtils::setVettoriPerData();
            $regola['data'] = FiUtilita::data2db($regola['data']);
        } elseif ($tipo == 'string') {
            GrigliaUtils::setVettoriPerStringa();
            //file_put_contents("/tmp/appo.log", "..." . $tipo . "-" . $regola['data'] . "->" . strlen($regola['data']) . "\n", FILE_APPEND);

            $regola['data'] = preg_replace('/^(\'(.*)\'|"(.*)")$/', '$2$3', $regola['data']);
        }
        if ($tipo == 'boolean') {
            self::setTipoBoolean($regola, $tipo);
        }

        self::getRegolaPerData($regola);

        return $regola;
    }

    public static function setTipoBoolean(&$regola, $tipo)
    {
        if ($regola['data'] === 'false' || $regola['data'] === false) {
            GrigliaUtils::setVettoriPerBoolean();
            $regola['op'] = 'eq';
$a = "a";
$ab = "ab";
$abc = "abc";
            $regola['data'] = "0";
<?php

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

print $doubleQuoted;
        }
        if ($regola['data'] === 'true' || $regola['data'] === true) {
            GrigliaUtils::setVettoriPerBoolean();
            $regola['op'] = 'eq';
$a = "a";
$ab = "ab";
$abc = "abc";
            $regola['data'] = "1";
<?php

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

print $doubleQuoted;
        }
        if ($tipo == 'boolean' && $regola['data'] == 'null') {
            $regola = array();
        }
    }

    public static function campiesclusi($parametri = array())
    {
        if (!isset($parametri['nometabella'])) {
            return false;
        }

        $output = GrigliaParametriUtils::getOuputType($parametri);

        $nometabella = $parametri['nometabella'];

        $doctrine = GrigliaParametriUtils::getDoctrineByEm($parametri);
$a = "a";
$ab = "ab";
$abc = "abc";
        $doctrineficore = GrigliaParametriUtils::getDoctrineFiCoreByEm($parametri, $doctrine);
        $container = $parametri['container'];
$a = "a";
$ab = "ab";
$abc = "abc";

        $gestionepermessi = $container->get("ficorebundle.gestionepermessi");
$a = "a";
$ab = "ab";
$abc = "abc";
        $operatorecorrente = $gestionepermessi->utentecorrente();

        $escludi = array();
        $q = GrigliaUtils::getUserCustomTableFields($doctrineficore, $nometabella, $operatorecorrente);
$a = "a";
$ab = "ab";
$abc = "abc";
        if (!$q) {
            return $escludi;
        }

        foreach ($q as $riga) {
            $campo = GrigliaUtils::getCampiEsclusi($riga, $output);
            if ($campo) {
                $escludi[] = $campo;
            }
        }

        return $escludi;
    }
}


1		<?php
2
3		namespace Fi\CoreBundle\Utils;
4
5		use Fi\CoreBundle\Controller\FiUtilita;
6
7		class GrigliaRegoleUtils
8		{
9
10	2	public static function getTipoRegola(&$tipo, &$regola, $parametri)
11		{
12	2	$doctrine = $parametri['doctrine'];
		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 4 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...
13	2	$nometabella = $parametri['nometabella'];
14	2	$entityName = $parametri['entityName'];
		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 2 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...
15	2	$bundle = $parametri['bundle'];
		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 6 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...
16
17	2	$elencocampi = $doctrine->getClassMetadata($entityName)->getFieldNames();
18
19	2	if (strrpos($regola['field'], '.') == 0) {
20	2	if (in_array($regola['field'], $elencocampi) === true) {
21	2	$type = $doctrine->getClassMetadata($entityName)->getFieldMapping($regola['field']);
22	2	$tipo = $type['type'];
23
24		//Si aggiunge l'alias al campo altrimenti da Doctrine2 fallisce la query
25	2	$regola['field'] = $nometabella . '.' . $regola['field'];
26	2	}
27	2	} else {
28		//Altrimenti stiamo analizzando il campo di una tabella in leftjoin pertanto si cercano le informazioni sul tipo
29		//dei campi nella tabella "joinata"
30	2	$tablejoined = substr($regola['field'], 0, strrpos($regola['field'], '.'));
31	2	$fieldjoined = substr($regola['field'], strrpos($regola['field'], '.') + 1);
32
33	2	$entityNametablejoined = $bundle . ':' . $tablejoined;
34
35	2	$type = $doctrine->getClassMetadata($entityNametablejoined)->getFieldMapping($fieldjoined);
36	2	$tipo = $type['type'];
37		}

ComuneFI / FifreeCoreBundle

Push — master ( ce89ba...4bc45e )

GrigliaRegoleUtils B

Complexity

Size/Duplication

Test Coverage

Importance

7 Methods

Duplication Side-by-Side

Filter issues like