Tabella::buildLeftJoin() - Code Metrics - Inspection of "change database connection" - ComuneFI/FifreeCoreBundle - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Branch — 4.1 (cda63a)

by Andrea

created 2018-11-06 22:52 UTC

Tabella::buildLeftJoin() A

↳ Parent: Tabella

Complexity

Conditions	4
Paths	4

Size

Total Lines	14
Code Lines	8

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	5
CRAP Score	4.8437

Importance

Changes

Metric	Value
eloc	8
dl	0
loc	14
ccs	5
cts	8
cp	0.625
rs	10
c	0
b	0
f	0
cc	4
nc	4
nop	1
crap	4.8437

<?php

namespace Fi\CoreBundle\Utils\Tabella;

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

class Tabella extends BaseTabella
{

    protected $permessi;
    protected $paginacorrente;
    protected $paginetotali;
    protected $righeperpagina;
    protected $righetotali;
    protected $maxordine;
    protected $traduzionefiltri;

    public function __construct($doctrine, $parametri = '{}')
    {
        $this->parametri = $parametri;

        if (isset($this->parametri['em'])) {
            $this->em = $doctrine->getManager(ParametriTabella::getParameter($this->parametri['em']));
        } else {
            $this->em = $doctrine->getManager();
        }
        $this->parseParameters();
        $this->colonnedatabase = $this->getColonneDatabase();
$a = "a";
$ab = "ab";
$abc = "abc";
        $this->opzionitabellacore = $this->getOpzionitabellaFromCore();
$a = "a";
$ab = "ab";
$abc = "abc";
        $this->configurazionecolonnetabella = $this->getAllOpzioniTabella();
    }

    public function getRecordstabella()
    {

        $qb = $this->fifreeQueryBuilder();

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

        $this->orderByBuilder($qb);

        /* Dall'oggetto querybuilder si ottiene la query da eseguire */
        $recordsets = $qb->getQuery()->getResult();

        $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;
    }

    private function orderByBuilder(&$qb)
    {
        foreach ($this->colonneordinamento as $nomecampo => $tipoordinamento) {
            $qb->addOrderBy($nomecampo, $tipoordinamento);
        }
    }

    private function fifreeQueryBuilder()
    {
        /* @var $this->em \Doctrine\ORM\EntityManager */
        /* @var $qb \Doctrine\ORM\QueryBuilder */
        $qb = $this->em->createQueryBuilder()
                ->select(array($this->tablename))
                ->from($this->entityname, $this->tablename)
        //->where("a.id = :valoreid")
        //->setParameter('valoreid', 1)

        ;
        $this->buildLeftJoin($qb);

        $this->buildWhere($qb);

        //dump($qb->getQuery()->getSQL());exit;

        return $qb;
    }

    private function buildLeftJoin(&$qb)
    {
        $fieldname = "";
<?php

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

print $doubleQuoted;
        //Aggiungere left join per tabelle collegate nel caso ci siano
        foreach ($this->configurazionecolonnetabella as $fieldname => $configurazionecampo) {
            if ($configurazionecampo["association"] === true) {
<?php

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

print $doubleQuoted;
                $nometabellasrc = $this->em->getClassMetadata($configurazionecampo["associationtable"]["targetEntity"])->getTableName();
<?php

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

print $doubleQuoted;
                //$this->getEntitynameFromEntity $nometabellasrc
                //Attenzione: si presuppone che la tabella collegata sia mappata nelle entity (default con mysqlworkbench exporter)
                //con la lettera minuscola
                if (false !== strpos($configurazionecampo["associationtable"]["targetEntity"], 'Fi\CoreBundle')) {
<?php

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

print $doubleQuoted;
                    $qb->leftJoin($this->tablename . "." . $configurazionecampo["nomecampo"], $configurazionecampo["nomecampo"]);
<?php

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

print $doubleQuoted;
                } else {
                    $qb->leftJoin($this->tablename . "." . strtolower($nometabellasrc), $nometabellasrc);
<?php

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

print $doubleQuoted;
                }

                //$qb->leftJoin($this->tablename . "." . strtolower($nometabellasrc), $nometabellasrc);

            }
        }
    }

    private 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();
        //dump($tuttifiltri);exit;

        if (count($tuttifiltri)) {
            $descrizionefiltri = "";
<?php

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

print $doubleQuoted;
            foreach ($tuttifiltri as $num => $filtrocorrente) {
                //dump($filtrocorrente);exit;

                $fieldname = $filtrocorrente["nomecampo"];
$a = "a";
$ab = "ab";
$abc = "abc";
                $fieldvalue = $this->getFieldValue($filtrocorrente["valore"]);
$a = "a";
$ab = "ab";
$abc = "abc";
                $fieldoperator = $filtrocorrente["operatore"];
$a = "a";
$ab = "ab";
$abc = "abc";
                $fitrocorrenteqp = "fitrocorrente" . $num;
<?php

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

print $doubleQuoted;

                $criteria = new ParametriQueryTabellaDecoder(
                    $fieldname,
                    $fieldoperator,
                    $fieldvalue,
                    $fitrocorrenteqp,
                    $this->configurazionecolonnetabella[$fieldname]
                );

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

                if ($querycriteria) {
                    $qb->andWhere($querycriteria);
                    //if (count($queryparameter) > 0) {

                    $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);
                    //$qb->setParameter($fitrocorrenteqp, $fieldvalue);

                }
                $this->getDescrizioneFiltro($descrizionefiltri, $filtrocorrente, $criteria);
            }
            $this->traduzionefiltri = substr($descrizionefiltri, 2);
        }
        //if (count($parametribag) > 0) {

        $qb->setParameters($parametribag);
        //}

        if (isset($this->wheremanuale)) {
            $qb->andWhere($this->wheremanuale);
        }
    }

    private function getDescrizioneFiltro(&$descrizionefiltri, $filtrocorrente, $criteria)
    {
        if ($filtrocorrente["prefiltro"] === false) {
<?php

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

print $doubleQuoted;
            $descrizionefiltri = $descrizionefiltri . ", " . $criteria->getDescrizioneFiltro();
<?php

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

print $doubleQuoted;
        }
    }

    private function getFieldValue($fieldvalue)
    {
        if (isset($fieldvalue["date"])) {
<?php

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

print $doubleQuoted;
            //StdClassUtils::arrayToObject($fieldvalue, DatetimeTabella::class);

            //dump(new \Datetime($fieldvalue["date"]));exit;

            return new \Datetime($fieldvalue["date"]);
<?php

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

print $doubleQuoted;
        } else {
            return $fieldvalue;
        }
    }

    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));
    }

    public function getPaginacorrente()
    {
        return $this->paginacorrente;
    }

    public function getPaginetotali()
    {
        return $this->paginetotali;
    }

    public function getRigheperpagina()
    {
        return $this->righeperpagina;
    }

    public function getRighetotali()
    {
        return $this->righetotali;
    }

    public function getTraduzionefiltri()
    {
        return $this->traduzionefiltri;
    }
}


1		<?php
2
3		namespace Fi\CoreBundle\Utils\Tabella;
4
5		use Fi\CoreBundle\Utils\Tabella\ParametriTabella;
6		use Doctrine\ORM\Tools\Pagination\Paginator;
7		use Fi\CoreBundle\Utils\StdClass\StdClassUtils;
8		use Fi\CoreBundle\Utils\Tabella\ParametriQueryTabellaDecoder;
9
10		class Tabella extends BaseTabella
11		{
12
13		protected $permessi;
14		protected $paginacorrente;
15		protected $paginetotali;
16		protected $righeperpagina;
17		protected $righetotali;
18		protected $maxordine;
19		protected $traduzionefiltri;
20
21	2	public function __construct($doctrine, $parametri = '{}')
22		{
23	2	$this->parametri = $parametri;
24
25	2	if (isset($this->parametri['em'])) {
26	2	$this->em = $doctrine->getManager(ParametriTabella::getParameter($this->parametri['em']));
27		} else {
28		$this->em = $doctrine->getManager();
29		}
30	2	$this->parseParameters();
31	2	$this->colonnedatabase = $this->getColonneDatabase();
		0 ignored issues – show Coding Style introduced 2018-11-06 16:43 UTC by Report Bug Copy Issue Report Equals sign not aligned with surrounding assignments; expected 14 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...
32	2	$this->opzionitabellacore = $this->getOpzionitabellaFromCore();
		0 ignored issues – show Coding Style introduced 2018-11-06 16:43 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...
33	2	$this->configurazionecolonnetabella = $this->getAllOpzioniTabella();
34	2	}
35
36	2	public function getRecordstabella()
37		{
38

ComuneFI / FifreeCoreBundle

Branch — 4.1 (cda63a)

Tabella::buildLeftJoin() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like