GrigliaUtils::setVettoriPerStringa() - 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

GrigliaUtils::setVettoriPerStringa() B

↳ Parent: GrigliaUtils

Complexity

Conditions	1
Paths	1

Size

Total Lines	29
Code Lines	26

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	27
CRAP Score	1

Importance

Changes

Metric	Value
dl	0
loc	29
ccs	27
cts	27
cp	1
rs	8.8571
c	0
b	0
f	0
cc	1
eloc	26
nc	1
nop	0
crap	1

<?php

namespace Fi\CoreBundle\Utils;

class GrigliaUtils
{

    public static $decodificaop;
    public static $precarattere;
    public static $postcarattere;
    public static $precaratterecampo;
    public static $postcaratterecampo;

    const LARGHEZZAMASSIMA = 500;
$a = "a";
$ab = "ab";
$abc = "abc";
    const MOLTIPLICATORELARGHEZZA = 10;

    public static function init()
    {
        // i possibili operatori di ciascuna ricerca sono
        //questi: ['eq','ne','lt','le','gt','ge','bw','bn','in','ni','ew','en','cn','nc', 'nu', 'nn']

        //significano questo
        //['equal','not equal', 'less', 'less or equal','greater','greater or equal',

        //'begins with','does not begin with','is in','is not in','ends with','does not end with',

        //'contains','does not contain', 'is null', 'is not null']

        //sulla base dell'operatore impostato per la singola ricerca si impostano tre vettori
        //il promo contiene l'operatore da usare in query

        self::$decodificaop = array(
            'eq' => '=',
            'ne' => '<>',
            'lt' => '<',
            'le' => '<=',
            'gt' => '>',
            'ge' => '>=',
            'bw' => 'LIKE',
            'bn' => 'NOT LIKE',
            'in' => 'IN',
            'ni' => 'NOT IN',
            'ew' => 'LIKE',
            'en' => 'NOT LIKE',
            'cn' => 'LIKE',
            'nc' => 'NOT LIKE',
            'nu' => 'IS',
            'nn' => 'IS NOT',
            'nt' => '<>'
        );
        // questo contiene il carattere da usare prima del campo dati in query dipendentemente dal tipo di operatore
        self::$precarattere = array(
            'eq' => '',
            'ne' => '',
            'lt' => '',
            'le' => '',
            'gt' => '',
            'ge' => '',
            'bw' => 'lower(\'',
            'bn' => 'lower(\'',
            'in' => '(',
            'ni' => '(',
            'ew' => 'lower(\'%',
            'en' => 'lower(\'%',
            'cn' => 'lower(\'%',
            'nc' => 'lower(\'%',
            'nu' => '',
            'nn' => '',
            'nt' => 'TRUE'
        );

        // questo contiene il carattere da usare dopo il campo dati in query dipendentemente dal tipo di operatore
        self::$postcarattere = array(
            'eq' => '',
            'ne' => '',
            'lt' => '',
            'le' => '',
            'gt' => '',
            'ge' => '',
            'bw' => '%\')',
            'bn' => '%\')',
            'in' => ')',
            'ni' => ')',
            'ew' => '\')',
            'en' => '\')',
            'cn' => '%\')',
            'nc' => '%\')',
            'nu' => '',
            'nn' => '',
            'nt' => '');

        // questo contiene il carattere da usare prima del campo dati in query dipendentemente dal tipo di operatore
        self::$precaratterecampo = array(
            'eq' => '',
            'ne' => '',
            'lt' => '',
            'le' => '',
            'gt' => '',
            'ge' => '',
            'bw' => 'lower(',
            'bn' => 'lower(',
            'in' => '(',
            'ni' => '(',
            'ew' => 'lower(',
            'en' => 'lower(',
            'cn' => 'lower(',
            'nc' => 'lower(',
            'nu' => '',
            'nn' => '',
            'nt' => 'TRUE',
        );

        // questo contiene il carattere da usare dopo il campo dati in query dipendentemente dal tipo di operatore
        self::$postcaratterecampo = array(
            'eq' => '',
            'ne' => '',
            'lt' => '',
            'le' => '',
            'gt' => '',
            'ge' => '',
            'bw' => ')',
            'bn' => ')',
            'in' => ')',
            'ni' => ')',
            'ew' => ')',
            'en' => ')',
            'cn' => ')',
            'nc' => ')',
            'nu' => '',
            'nn' => '',
            'nt' => '',);
    }

    public static function setVettoriPerData()
    {
        self::$precaratterecampo['eq'] = "";
$a = "a";
$ab = "ab";
$abc = "abc";
        self::$postcaratterecampo['eq'] = "";
<?php

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

print $doubleQuoted;
        self::$precaratterecampo['ne'] = "";
$a = "a";
$ab = "ab";
$abc = "abc";
        self::$postcaratterecampo['ne'] = "";
<?php

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

print $doubleQuoted;

        self::$precarattere['eq'] = "";
$a = "a";
$ab = "ab";
$abc = "abc";
        self::$precarattere['ne'] = "";
$a = "a";
$ab = "ab";
$abc = "abc";
        self::$precarattere['lt'] = "";
$a = "a";
$ab = "ab";
$abc = "abc";
        self::$precarattere['le'] = "";
$a = "a";
$ab = "ab";
$abc = "abc";
        self::$precarattere['gt'] = "";
$a = "a";
$ab = "ab";
$abc = "abc";
        self::$precarattere['ge'] = "";
$a = "a";
$ab = "ab";
$abc = "abc";
        self::$postcarattere['eq'] = "";
<?php

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

print $doubleQuoted;
        self::$postcarattere['ne'] = "";
<?php

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

print $doubleQuoted;
        self::$postcarattere['lt'] = "";
<?php

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

print $doubleQuoted;
        self::$postcarattere['le'] = "";
<?php

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

print $doubleQuoted;
        self::$postcarattere['gt'] = "";
<?php

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

print $doubleQuoted;
        self::$postcarattere['ge'] = "";
<?php

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

print $doubleQuoted;
    }

    public static function setVettoriPerBoolean()
    {
        self::setVettoriPerData();
    }

    public static function setVettoriPerStringa()
    {
        self::$precaratterecampo['eq'] = "lower(";
$a = "a";
$ab = "ab";
$abc = "abc";
        self::$postcaratterecampo['eq'] = ")";
<?php

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

print $doubleQuoted;
        self::$precaratterecampo['ne'] = "lower(";
$a = "a";
$ab = "ab";
$abc = "abc";
        self::$postcaratterecampo['ne'] = ")";
<?php

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

print $doubleQuoted;

        self::$precarattere['eq'] = "";
$a = "a";
$ab = "ab";
$abc = "abc";
        self::$precarattere['ne'] = "";
$a = "a";
$ab = "ab";
$abc = "abc";
        self::$precarattere['lt'] = "";
$a = "a";
$ab = "ab";
$abc = "abc";
        self::$precarattere['le'] = "";
$a = "a";
$ab = "ab";
$abc = "abc";
        self::$precarattere['gt'] = "";
$a = "a";
$ab = "ab";
$abc = "abc";
        self::$precarattere['ge'] = "";
$a = "a";
$ab = "ab";
$abc = "abc";
        self::$precarattere['cn'] = "%";
$a = "a";
$ab = "ab";
$abc = "abc";
        self::$precarattere['nc'] = "%";
$a = "a";
$ab = "ab";
$abc = "abc";
        self::$precarattere['bw'] = "";
$a = "a";
$ab = "ab";
$abc = "abc";
        self::$precarattere['in'] = "lower(";
$a = "a";
$ab = "ab";
$abc = "abc";
        self::$precarattere['ni'] = "lower(";
$a = "a";
$ab = "ab";
$abc = "abc";
        self::$postcarattere['eq'] = "";
<?php

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

print $doubleQuoted;
        self::$postcarattere['ne'] = "";
<?php

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

print $doubleQuoted;
        self::$postcarattere['lt'] = "";
<?php

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

print $doubleQuoted;
        self::$postcarattere['le'] = "";
<?php

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

print $doubleQuoted;
        self::$postcarattere['gt'] = "";
<?php

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

print $doubleQuoted;
        self::$postcarattere['ge'] = "";
<?php

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

print $doubleQuoted;
        self::$postcarattere['cn'] = "%";
<?php

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

print $doubleQuoted;
        self::$postcarattere['nc'] = "%";
<?php

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

print $doubleQuoted;
        self::$postcarattere['bw'] = "%";
<?php

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

print $doubleQuoted;
        self::$postcarattere['in'] = ")";
<?php

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

print $doubleQuoted;
        self::$postcarattere['ni'] = ")";
<?php

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

print $doubleQuoted;
    }

    public static function setVettoriPerNumero()
    {
        self::$precaratterecampo['eq'] = "";
$a = "a";
$ab = "ab";
$abc = "abc";
        self::$postcaratterecampo['eq'] = "";
<?php

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

print $doubleQuoted;
        self::$precaratterecampo['ne'] = "";
$a = "a";
$ab = "ab";
$abc = "abc";
        self::$postcaratterecampo['ne'] = "";
<?php

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

print $doubleQuoted;
        self::$precaratterecampo['in'] = "(";
$a = "a";
$ab = "ab";
$abc = "abc";
        self::$postcaratterecampo['in'] = ")";
<?php

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

print $doubleQuoted;
        self::$precaratterecampo['ni'] = "(";
$a = "a";
$ab = "ab";
$abc = "abc";
        self::$postcaratterecampo['ni'] = ")";
<?php

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

print $doubleQuoted;

        self::$precarattere['eq'] = '';
$a = "a";
$ab = "ab";
$abc = "abc";
        self::$precarattere['ne'] = '';
$a = "a";
$ab = "ab";
$abc = "abc";
        self::$precarattere['lt'] = '';
$a = "a";
$ab = "ab";
$abc = "abc";
        self::$precarattere['le'] = '';
$a = "a";
$ab = "ab";
$abc = "abc";
        self::$precarattere['gt'] = '';
$a = "a";
$ab = "ab";
$abc = "abc";
        self::$precarattere['ge'] = '';
$a = "a";
$ab = "ab";
$abc = "abc";
        self::$precarattere['in'] = '';
$a = "a";
$ab = "ab";
$abc = "abc";
        self::$precarattere['ni'] = '';
$a = "a";
$ab = "ab";
$abc = "abc";
        self::$postcarattere['eq'] = '';
        self::$postcarattere['ne'] = '';
        self::$postcarattere['lt'] = '';
        self::$postcarattere['le'] = '';
        self::$postcarattere['gt'] = '';
        self::$postcarattere['ge'] = '';
        self::$postcarattere['in'] = '';
        self::$postcarattere['ni'] = '';
    }

    public static function getCampiEsclusi($riga, $output)
    {
        $campoescluso = null;
        if ($output == 'stampa') {
            if ($riga->hasMostrastampa() == false) {
                $campoescluso = $riga->getNomecampo();
            }
        } else {
            if ($riga->hasMostraindex() == false) {
                $campoescluso = $riga->getNomecampo();
            }
        }

        return $campoescluso;
    }

    public static function getUserCustomTableFields($em, $nometabella, $operatore)
    {
        $q = $em->getRepository('FiCoreBundle:Tabelle')->findBy(array('operatori_id' => $operatore['id'], 'nometabella' => $nometabella));

        if (!$q) {
            unset($q);
            $q = $em->getRepository('FiCoreBundle:Tabelle')->findBy(array('operatori_id' => null, 'nometabella' => $nometabella));
        }

        return $q;
    }

    public static function etichettecampi($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);
$a = "a";
$ab = "ab";
$abc = "abc";
        $container = $parametri['container'];
$a = "a";
$ab = "ab";
$abc = "abc";
        $gestionepermessi = $container->get("ficorebundle.gestionepermessi");
<?php

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

print $doubleQuoted;

        $operatorecorrente = $gestionepermessi->utentecorrente();

        $etichette = array();

        $q = self::getUserCustomTableFields($doctrineficore, $nometabella, $operatorecorrente);

        if ($q) {
            foreach ($q as $riga) {
                if ($output == 'stampa') {
                    $etichette[$riga->getNomecampo()] = $riga->getEtichettastampa();
                } else {
                    $etichette[$riga->getNomecampo()] = $riga->getEtichettaindex();
                }
            }
        }

        return $etichette;
    }

    public static function larghezzecampi($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();

        $etichette = array();

        $q = self::getUserCustomTableFields($doctrineficore, $nometabella, $operatorecorrente);

        if (!$q) {
            return $etichette;
        }

        foreach ($q as $riga) {
            if ($output == 'stampa') {
                $etichette[$riga->getNomecampo()] = $riga->getLarghezzastampa();
            } else {
                $etichette[$riga->getNomecampo()] = $riga->getLarghezzaindex();
            }
        }

        return $etichette;
    }

    public static function ordinecolonne($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");
<?php

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

print $doubleQuoted;

        $operatorecorrente = $gestionepermessi->utentecorrente();

        $ordine = array();

        $q = self::getUserCustomTableFields($doctrineficore, $nometabella, $operatorecorrente);

        if ($q) {
            foreach ($q as $riga) {
                if ($output == 'stampa') {
                    if ($riga->getOrdinestampa()) {
                        $ordine[$riga->getOrdinestampa()] = $riga->getNomecampo();
                    }
                } else {
                    if ($riga->getOrdineindex()) {
                        $ordine[$riga->getOrdineindex()] = $riga->getNomecampo();
                    }
                }
            }
            if (count($ordine) > 0) {
                ksort($ordine);
            }
        }

        $ordinecolonne = GrigliaColonneUtils::getColonneOrdinate($ordine);

        return $ordinecolonne;
    }

    /**
     * Translates a string with underscores into camel case (e.g. first_name -&gt; firstName).
     *
     * @param array  $parametri
     *
     * @return string $str translated into camel caps
     */
    public static function toCamelCase($parametri = array())
    {
        $str = $parametri['str'];
$a = "a";
$ab = "ab";
$abc = "abc";
        $capitalise_first_char = isset($parametri['primamaiuscola']) ? $parametri['primamaiuscola'] : false;

        if ($capitalise_first_char) {
            $str[0] = strtoupper($str[0]);
        }
        $func = function ($matches) {
            return strtoupper($matches[1]);
        };

        return preg_replace_callback('/_([a-z])/', $func, $str);
    }

    public static function getOpzioniTabella($doctrineficore, $nometabella, &$testata)
    {
        /* @var $qb \Doctrine\ORM\QueryBuilder */
        $qb = $doctrineficore->createQueryBuilder();
        $qb->select(array('a'));
        $qb->from('FiCoreBundle:OpzioniTabella', 'a');
        $qb->leftJoin('a.tabelle', 't');
        $qb->where("t.nometabella = '*' or t.nometabella = :tabella");
        $qb->andWhere("t.nomecampo is null or t.nomecampo = ''");
        $qb->orderBy('t.nometabella');
        $qb->setParameter('tabella', $nometabella);
        $opzioni = $qb->getQuery()->getResult();
        foreach ($opzioni as $opzione) {
            $testata[$opzione->getParametro()] = str_replace('%tabella%', $nometabella, $opzione->getValore());
        }
    }

    public static function getNomiColonne($nomicolonne)
    {
        ksort($nomicolonne);
        $nomicolonnesorted = array();
        foreach ($nomicolonne as $value) {
            $nomicolonnesorted[] = $value;
        }

        return $nomicolonnesorted;
    }

    public static function getModelloColonne($modellocolonne)
    {
        ksort($modellocolonne);
        $modellocolonnesorted = array();
        foreach ($modellocolonne as $value) {
            $modellocolonnesorted[] = $value;
        }

        return $modellocolonnesorted;
    }

    public static function getPermessiTabella($paricevuti, &$testata)
    {
        if (!isset($paricevuti['container'])) {
            return;
        }

        $container = $paricevuti['container'];
$a = "a";
$ab = "ab";
$abc = "abc";
        $nometabella = $paricevuti['nometabella'];
$a = "a";
$ab = "ab";
$abc = "abc";
        $gestionepermessi = $container->get("ficorebundle.gestionepermessi");
<?php

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

print $doubleQuoted;

        $vettorepermessi = $gestionepermessi->impostaPermessi(array('modulo' => $nometabella));

        return array_merge($testata, $vettorepermessi);
    }
}


1		<?php
2
3		namespace Fi\CoreBundle\Utils;
4
5		class GrigliaUtils
6		{
7
8		public static $decodificaop;
9		public static $precarattere;
10		public static $postcarattere;
11		public static $precaratterecampo;
12		public static $postcaratterecampo;
13
14		const LARGHEZZAMASSIMA = 500;
		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...
15		const MOLTIPLICATORELARGHEZZA = 10;
16
17	2	public static function init()
18		{
19		// i possibili operatori di ciascuna ricerca sono
20		//questi: ['eq','ne','lt','le','gt','ge','bw','bn','in','ni','ew','en','cn','nc', 'nu', 'nn']
		0 ignored issues – show Unused Code Comprehensibility introduced 2018-01-16 17:42 UTC by Report Bug Copy Issue Report `90%` of this comment could be valid code. Did you maybe forget this after debugging? Sometimes obsolete code just ends up commented out instead of removed. In this case it is better to remove the code once you have checked you do not need it. The code might also have been commented out for debugging purposes. In this case it is vital that someone uncomments it again or your project may behave in very unexpected ways in production. This check looks for comments that seem to be mostly valid code and reports them. Loading history...
21		//significano questo
22		//['equal','not equal', 'less', 'less or equal','greater','greater or equal',
		0 ignored issues – show Unused Code Comprehensibility introduced 2018-01-16 17:42 UTC by Report Bug Copy Issue Report `87%` of this comment could be valid code. Did you maybe forget this after debugging? Sometimes obsolete code just ends up commented out instead of removed. In this case it is better to remove the code once you have checked you do not need it. The code might also have been commented out for debugging purposes. In this case it is vital that someone uncomments it again or your project may behave in very unexpected ways in production. This check looks for comments that seem to be mostly valid code and reports them. Loading history...
23		//'begins with','does not begin with','is in','is not in','ends with','does not end with',
		0 ignored issues – show Unused Code Comprehensibility introduced 2018-01-16 17:42 UTC by Report Bug Copy Issue Report `100%` of this comment could be valid code. Did you maybe forget this after debugging? Sometimes obsolete code just ends up commented out instead of removed. In this case it is better to remove the code once you have checked you do not need it. The code might also have been commented out for debugging purposes. In this case it is vital that someone uncomments it again or your project may behave in very unexpected ways in production. This check looks for comments that seem to be mostly valid code and reports them. Loading history...
24		//'contains','does not contain', 'is null', 'is not null']
		0 ignored issues – show Unused Code Comprehensibility introduced 2018-01-16 17:42 UTC by Report Bug Copy Issue Report `80%` of this comment could be valid code. Did you maybe forget this after debugging? Sometimes obsolete code just ends up commented out instead of removed. In this case it is better to remove the code once you have checked you do not need it. The code might also have been commented out for debugging purposes. In this case it is vital that someone uncomments it again or your project may behave in very unexpected ways in production. This check looks for comments that seem to be mostly valid code and reports them. Loading history...
25		//sulla base dell'operatore impostato per la singola ricerca si impostano tre vettori
26		//il promo contiene l'operatore da usare in query
27
28	2	self::$decodificaop = array(
29	2	'eq' => '=',
30	2	'ne' => '<>',
31	2	'lt' => '<',
32	2	'le' => '<=',
33	2	'gt' => '>',
34	2	'ge' => '>=',
35	2	'bw' => 'LIKE',

ComuneFI / FifreeCoreBundle

Push — master ( ce89ba...4bc45e )

GrigliaUtils::setVettoriPerStringa() B

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like