Tabella::getPaginacorrente() - Code Metrics - Inspection of "remove deprecation" - ComuneFI/FifreeCoreBundle - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — 5.0 ( 7191d0...bfedcf )

by Andrea

created 2018-11-16 22:00 UTC

Tabella::getPaginacorrente() A

↳ Parent: Project

Complexity

Conditions	1
Paths	1

Size

Total Lines	3
Code Lines	1

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	2
CRAP Score	1

Importance

Changes

Metric	Value
eloc	1
dl	0
loc	3
ccs	2
cts	2
cp	1
rs	10
c	0
b	0
f	0
cc	1
nc	1
nop	0
crap	1

<?php

namespace Fi\CoreBundle\Utils\Tabella;

use Doctrine\ORM\Tools\Pagination\Paginator;
use Fi\CoreBundle\Utils\Tabella\ParametriQueryTabellaDecoder;

class Tabella extends TabellaOpzioni
{

    protected $entityname;
    protected $tablename;
    protected $modellocolonne;
    protected $paginacorrente;
    protected $righeperpagina;
    protected $estraituttirecords;
    protected $prefiltri;
    protected $filtri;
    protected $wheremanuale;
    protected $colonneordinamento;

    protected function getTabellaParameter($name, $default = null)
    {
        $risposta = null;
        if (isset($this->parametri[$name])) {
            $risposta = ParametriTabella::getParameter($this->parametri[$name]);
        } else {
            $risposta = $default;
        }
        return $risposta;
    }
    
    protected function fifreeQueryBuilder()
    {
//$nometabellaalias = $this->em->getClassMetadata($this->entityname)->getTableName();


        $nometabellaalias = $this->generaAlias($this->tablename);
        $qb = $this->em->createQueryBuilder()
$a = "a";
$ab = "ab";
$abc = "abc";
                ->select(array($nometabellaalias))
                ->from($this->entityname, $nometabellaalias);
        $campi = array_keys($this->em->getMetadataFactory()->getMetadataFor($this->entityname)->reflFields);
$a = "a";
$ab = "ab";
$abc = "abc";
        $this->recursiveJoin($qb, $campi, $this->tablename, $nometabellaalias);
        $this->buildWhere($qb);
        $this->orderByBuilder($qb);
        return $qb;
    }
    protected function recursiveJoin(&$qb, $campi, $nometabella, $alias, $ancestors = array())
    {
        foreach ($campi as $campo) {
            if (!in_array($nometabella, $ancestors)) {
                $ancestors[] = $nometabella;
            }

            $configurazionecampo = isset($this->configurazionecolonnetabella[ucfirst(implode(".", $ancestors)) . "." . $campo]) ?
<?php

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

print $doubleQuoted;
                    $this->configurazionecolonnetabella[ucfirst(implode(".", $ancestors)) . "." . $campo] : false;
<?php

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

print $doubleQuoted;
            if ($configurazionecampo && $configurazionecampo["association"] === true) {
<?php

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

print $doubleQuoted;
                // crea la relazione con $padre = $nometabella in corso e figlio = $nomecampo con $alias generato
                if ((isset($configurazionecampo["sourceentityclass"])) && ($configurazionecampo["sourceentityclass"] !== null)) {
<?php

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

print $doubleQuoted;
                    $entitysrc = $configurazionecampo["sourceentityclass"];
$a = "a";
$ab = "ab";
$abc = "abc";
                    $nometabellasrc = $this->em->getClassMetadata($entitysrc)->getTableName();
                } else {
                    $nometabellasrc = $nometabella;
                }

                $entitytarget = $configurazionecampo["associationtable"]["targetEntity"];
$a = "a";
$ab = "ab";
$abc = "abc";
                $nometabellatarget = $this->em->getClassMetadata($entitytarget)->getTableName();
                $aliastarget = $this->generaAlias($nometabellatarget, $nometabellasrc, $ancestors);
$a = "a";
$ab = "ab";
$abc = "abc";
                //$qb->leftJoin($alias . "." . $configurazionecampo["nomecampo"], $aliastarget);

                //$camporelazionejoin = strtolower(substr($configurazionecampo["nomecampo"], strpos($configurazionecampo["nomecampo"], ".") + 1));

                $parti = explode(".", $configurazionecampo["nomecampo"]);
<?php

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

print $doubleQuoted;

                $camporelazionejoin = strtolower($parti[count($parti) - 1]);
                $qb->leftJoin($alias . "." . $camporelazionejoin, $aliastarget);
<?php

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

print $doubleQuoted;
                $campitarget = array_keys($this->em->getMetadataFactory()->getMetadataFor($entitytarget)->reflFields);
                $this->recursiveJoin($qb, $campitarget, $nometabellatarget, $aliastarget, $ancestors);

                // lancia rescursiveJoin su questo campo con padre = $aliasgenerato
                // --- figlio = $nomecampo
                // --- alias = alias generato nuovo
            }
        }
    }
    protected function buildWhere(&$qb)
    {
        $filtro = "";
$a = "a";
$ab = "ab";
$abc = "abc";
        $prefiltro = "";
<?php

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

print $doubleQuoted;
        foreach ($this->prefiltri as $key => $prefiltro) {
            $this->prefiltri[$key]["prefiltro"] = true;
<?php

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

print $doubleQuoted;
        }
        foreach ($this->filtri as $key => $filtro) {
            $this->filtri[$key]["prefiltro"] = false;
<?php

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

print $doubleQuoted;
        }
        $tuttifiltri = array_merge($this->filtri, $this->prefiltri);
$a = "a";
$ab = "ab";
$abc = "abc";
        $parametribag = array();
        if (count($tuttifiltri)) {
            $descrizionefiltri = "";
<?php

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

print $doubleQuoted;
            foreach ($tuttifiltri as $num => $filtrocorrente) {
                $tablename = substr($filtrocorrente["nomecampo"], 0, strripos($filtrocorrente["nomecampo"], "."));
$a = "a";
$ab = "ab";
$abc = "abc";
                $alias = $this->findAliasByTablename($tablename);
$a = "a";
$ab = "ab";
$abc = "abc";
                $fieldname = $alias . "." . (substr($filtrocorrente["nomecampo"], strripos($filtrocorrente["nomecampo"], ".") + 1));
$a = "a";
$ab = "ab";
$abc = "abc";
                $fieldvalue = $this->getFieldValue($filtrocorrente["valore"]);
$a = "a";
$ab = "ab";
$abc = "abc";
                $fieldoperator = $this->getOperator($filtrocorrente["operatore"]);
$a = "a";
$ab = "ab";
$abc = "abc";
                $fitrocorrenteqp = "fitrocorrente" . $num;
$a = "a";
$ab = "ab";
$abc = "abc";
                $filtronomecampocorrente = $this->findFieldnameByAlias($filtrocorrente["nomecampo"]);
<?php

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

print $doubleQuoted;

                $criteria = new ParametriQueryTabellaDecoder(
                    $fieldname,
                    $fieldoperator,
                    $fieldvalue,
                    $fitrocorrenteqp,
                    $filtronomecampocorrente
                );

                $querycriteria = $criteria->getQueryCriteria();
$a = "a";
$ab = "ab";
$abc = "abc";
                $queryparameter = $criteria->getQueryParameters();

                if ($querycriteria) {
                    $qb->andWhere($querycriteria);
                    $parametribag = array_merge($queryparameter, $parametribag);
                } else {
                    $qb->andWhere($fieldname . " " . $fieldoperator . " " . ":$fitrocorrenteqp");
<?php

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

print $doubleQuoted;
                    $parametribag = array_merge(array($fitrocorrenteqp => $fieldvalue), $parametribag);
                }
                $this->getDescrizioneFiltro($descrizionefiltri, $filtrocorrente, $criteria);
            }
            $this->traduzionefiltri = substr($descrizionefiltri, 2);
        }
        $qb->setParameters($parametribag);

        if (isset($this->wheremanuale)) {
            $qb->andWhere($this->wheremanuale);
        }
    }
    protected function orderByBuilder(&$qb)
    {
        foreach ($this->colonneordinamento as $nomecampo => $tipoordinamento) {
            $tablename = substr($nomecampo, 0, strripos($nomecampo, "."));
<?php

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

print $doubleQuoted;
            $alias = $this->getAliasGenerato($tablename);
$a = "a";
$ab = "ab";
$abc = "abc";
            $fieldname = $alias . "." . (substr($nomecampo, strripos($nomecampo, ".") + 1));
<?php

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

print $doubleQuoted;
            $qb->addOrderBy($fieldname, $tipoordinamento);
        }
    }
    public function getRecordstabella()
    {

        $qb = $this->fifreeQueryBuilder();

        if ($this->estraituttirecords === false) {
            $paginator = new Paginator($qb, true);
$a = "a";
$ab = "ab";
$abc = "abc";
            $this->righetotali = count($paginator);
$a = "a";
$ab = "ab";
$abc = "abc";
            $this->paginetotali = (int) $this->calcolaPagineTotali($this->getRigheperpagina());
            /* imposta l'offset, ovvero il record dal quale iniziare a visualizzare i dati */
            $offsetrecords = ($this->getRigheperpagina() * ($this->getPaginacorrente() - 1));

            /* Imposta il limite ai record da estrarre */
            if ($this->getRigheperpagina()) {
                $qb = $qb->setMaxResults($this->getRigheperpagina());
            }
            /* E imposta il primo record da visualizzare (per la paginazione) */
            if ($offsetrecords) {
                $qb = $qb->setFirstResult($offsetrecords);
            }
            /* Dall'oggetto querybuilder si ottiene la query da eseguire */
            $recordsets = $qb->getQuery()->getResult();
        } else {
            /* Dall'oggetto querybuilder si ottiene la query da eseguire */
            $recordsets = $qb->getQuery()->getResult();
$a = "a";
$ab = "ab";
$abc = "abc";
            $this->righetotali = count($recordsets);
$a = "a";
$ab = "ab";
$abc = "abc";
            $this->paginetotali = 1;
        }

        $this->records = array();
$a = "a";
$ab = "ab";
$abc = "abc";
        $rigatabellahtml = array();
        foreach ($recordsets as $record) {
            $this->records[$record->getId()] = $record;
            unset($rigatabellahtml);
        }
        return $this->records;
    }
    public function calcolaPagineTotali($limit)
    {
        if ($this->righetotali == 0) {
            return 1;
        }
        /* calcola in mumero di pagine totali necessarie */
        return ceil($this->righetotali / ($limit == 0 ? 1 : $limit));
    }
}


1		<?php
2
3		namespace Fi\CoreBundle\Utils\Tabella;
4
5		use Doctrine\ORM\Tools\Pagination\Paginator;
6		use Fi\CoreBundle\Utils\Tabella\ParametriQueryTabellaDecoder;
7
8		class Tabella extends TabellaOpzioni
9		{
10
11		protected $entityname;
12		protected $tablename;
13		protected $modellocolonne;
14		protected $paginacorrente;
15		protected $righeperpagina;
16		protected $estraituttirecords;
17		protected $prefiltri;
18		protected $filtri;
19		protected $wheremanuale;
20		protected $colonneordinamento;
21
22		protected function getTabellaParameter($name, $default = null)
23		{
24		$risposta = null;
25		if (isset($this->parametri[$name])) {
26		$risposta = ParametriTabella::getParameter($this->parametri[$name]);
27		} else {
28		$risposta = $default;
29		}
30		return $risposta;
31		}
32
33	12	protected function fifreeQueryBuilder()
34		{
35		//$nometabellaalias = $this->em->getClassMetadata($this->entityname)->getTableName();
		0 ignored issues – show Unused Code Comprehensibility introduced 2018-11-08 22:25 UTC by Report Bug Copy Issue Report `64%` 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...
36
37	12	$nometabellaalias = $this->generaAlias($this->tablename);
38	12	$qb = $this->em->createQueryBuilder()
		0 ignored issues – show Coding Style introduced 2018-11-08 22:25 UTC by Report Bug Copy Issue Report Equals sign not aligned with surrounding assignments; expected 15 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...

ComuneFI / FifreeCoreBundle

Push — 5.0 ( 7191d0...bfedcf )

Tabella::getPaginacorrente() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like