LiveJobsGridSource::getQueryBuilder() - Code Metrics - Inspection of "4.0 release" - mmucklo/DtcQueueBundle - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Pull Request — master (#30)

by Matthew

created 2018-01-07 01:12 UTC

LiveJobsGridSource::getQueryBuilder() A

↳ Parent: LiveJobsGridSource

Complexity

Conditions	2
Paths	2

Size

Total Lines	13
Code Lines	8

Duplication

Lines	13
Ratio	100 %

Code Coverage

Tests	0
CRAP Score	6

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
dl	13
loc	13
ccs	0
cts	8
cp	0
rs	9.4285
c	1
b	0
f	0
cc	2
eloc	8
nc	2
nop	0
crap	6

<?php

namespace Dtc\QueueBundle\ORM;

use Doctrine\ORM\EntityManager;
use Dtc\GridBundle\Grid\Column\GridColumn;
use Dtc\GridBundle\Grid\Source\EntityGridSource;
use Dtc\QueueBundle\Model\BaseJob;

class LiveJobsGridSource extends EntityGridSource
{
    protected $jobManager;
    protected $running = false;

    public function getId()
    {
        return 'dtc_queue.grid_source.jobs_'.($this->isRunning() ? 'running' : 'waiting').'.orm';
    }

    public function __construct(JobManager $jobManager)
    {
        $this->jobManager = $jobManager;
        /** @var EntityManager $entityManager */
        $entityManager = $jobManager->getObjectManager();
        parent::__construct($entityManager, $jobManager->getJobClass());
    }

    public function getColumns()
    {
        if ($columns = parent::getColumns()) {
            return $columns;
        }
        $this->autoDiscoverColumns();

        return parent::getColumns();
    }

    /**
     * @param bool $flag
     */
    public function setRunning($flag)
    {
        $this->running = $flag;
    }

    public function isRunning()
    {
        return $this->running;
    }

    protected function getRunningQueryBuilder()
    {
        /** @var EntityManager $entityManager */
        $entityManager = $this->jobManager->getObjectManager();
        $queryBuilder = $entityManager->createQueryBuilder()->add('select', 'j');
function acceptsInteger($int) { }

$x = '123'; // string "123"

// Instead of
acceptsInteger($x);

// we recommend to use
acceptsInteger((integer) $x);
        $queryBuilder->from($this->jobManager->getJobClass(), 'j');
        $queryBuilder->where('j.status = :status')->setParameter(':status', BaseJob::STATUS_RUNNING);
        $queryBuilder->orderBy('j.startedAt', 'DESC');
        $queryBuilder->setFirstResult($this->offset)
                        ->setMaxResults($this->limit);

        return $queryBuilder;
    }

    protected function getQueryBuilder()

    {
        if ($this->isRunning()) {
            return $this->getRunningQueryBuilder();
        }

        $queryBuilder = $this->jobManager->getJobQueryBuilder();
        $queryBuilder->add('select', 'j');
function acceptsInteger($int) { }

$x = '123'; // string "123"

// Instead of
acceptsInteger($x);

// we recommend to use
acceptsInteger((integer) $x);
        $queryBuilder->setFirstResult($this->offset)
                        ->setMaxResults($this->limit);

        return $queryBuilder;
    }

    public function autoDiscoverColumns()

    {
        parent::autoDiscoverColumns();
        if ($this->columns) {

            foreach ($this->columns as $column) {
                if ($column instanceof GridColumn) {
                    $column->setOption('sortable', false);
                }
            }
        }
    }

    public function getDefaultSort()
    {
        return null;
    }

    public function getCount()
    {
        $qb = $this->getQueryBuilder();
        $qb->add('select', 'count(j)')
function acceptsInteger($int) { }

$x = '123'; // string "123"

// Instead of
acceptsInteger($x);

// we recommend to use
acceptsInteger((integer) $x);
            ->setFirstResult(null)
            ->setMaxResults(null);

        return $qb->getQuery()
            ->getSingleScalarResult();
    }
}


1			<?php
2
3			namespace Dtc\QueueBundle\ORM;
4
5			use Doctrine\ORM\EntityManager;
6			use Dtc\GridBundle\Grid\Column\GridColumn;
7			use Dtc\GridBundle\Grid\Source\EntityGridSource;
8			use Dtc\QueueBundle\Model\BaseJob;
9
10			class LiveJobsGridSource extends EntityGridSource
11			{
12			protected $jobManager;
13			protected $running = false;
14
15	2		public function getId()
16			{
17	2		return 'dtc_queue.grid_source.jobs_'.($this->isRunning() ? 'running' : 'waiting').'.orm';
18			}
19
20	9		public function __construct(JobManager $jobManager)
21			{
22	9		$this->jobManager = $jobManager;
23			/** @var EntityManager $entityManager */
24	9		$entityManager = $jobManager->getObjectManager();
25	9		parent::__construct($entityManager, $jobManager->getJobClass());
26	9		}
27
28	2		public function getColumns()
29			{
30	2		if ($columns = parent::getColumns()) {
31	2		return $columns;
32			}
33	2		$this->autoDiscoverColumns();
34
35	2		return parent::getColumns();
36			}
37
38			/**
39			* @param bool $flag
40			*/
41	9		public function setRunning($flag)
42			{
43	9		$this->running = $flag;
44	9		}
45
46	2		public function isRunning()
47			{
48	2		return $this->running;
49			}
50
51			protected function getRunningQueryBuilder()
52			{
53			/** @var EntityManager $entityManager */
54			$entityManager = $this->jobManager->getObjectManager();
55			$queryBuilder = $entityManager->createQueryBuilder()->add('select', 'j');
			0 ignored issues – show Documentation introduced 2017-12-18 00:05 UTC by Report Bug Copy Issue Report `'j'` is of type `string`, but the function expects a `object<Doctrine\ORM\Query\Expr\Base>`. It seems like the type of the argument is not accepted by the function/method which you are calling. In some cases, in particular if PHP’s automatic type-juggling kicks in this might be fine. In other cases, however this might be a bug. We suggest to add an explicit type cast like in the following example: function acceptsInteger($int) { } $x = '123'; // string "123" // Instead of acceptsInteger($x); // we recommend to use acceptsInteger((integer) $x); Loading history...
56			$queryBuilder->from($this->jobManager->getJobClass(), 'j');
57			$queryBuilder->where('j.status = :status')->setParameter(':status', BaseJob::STATUS_RUNNING);
58			$queryBuilder->orderBy('j.startedAt', 'DESC');
59			$queryBuilder->setFirstResult($this->offset)
60			->setMaxResults($this->limit);
61
62			return $queryBuilder;
63			}
64
65		View Code Duplication	protected function getQueryBuilder()
			0 ignored issues – show Duplication introduced 2017-12-18 00:05 UTC by Report Bug Copy Issue Report This method seems to be duplicated in your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
66			{
67			if ($this->isRunning()) {
68			return $this->getRunningQueryBuilder();
69			}
70
71			$queryBuilder = $this->jobManager->getJobQueryBuilder();
72			$queryBuilder->add('select', 'j');
			0 ignored issues – show Documentation introduced 2017-12-06 08:28 UTC by Report Bug Copy Issue Report `'j'` is of type `string`, but the function expects a `object<Doctrine\ORM\Query\Expr\Base>`. It seems like the type of the argument is not accepted by the function/method which you are calling. In some cases, in particular if PHP’s automatic type-juggling kicks in this might be fine. In other cases, however this might be a bug. We suggest to add an explicit type cast like in the following example: function acceptsInteger($int) { } $x = '123'; // string "123" // Instead of acceptsInteger($x); // we recommend to use acceptsInteger((integer) $x); Loading history...
73			$queryBuilder->setFirstResult($this->offset)
74			->setMaxResults($this->limit);
75
76			return $queryBuilder;
77			}
78
79	2	View Code Duplication	public function autoDiscoverColumns()
			0 ignored issues – show Duplication introduced 2017-12-18 00:05 UTC by Report Bug Copy Issue Report This method seems to be duplicated in your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
80			{
81	2		parent::autoDiscoverColumns();
82	2		if ($this->columns) {
			0 ignored issues – show Bug Best Practice introduced 2017-12-18 00:05 UTC by Report Bug Copy Issue Report The expression `$this->columns` of type `array` is implicitly converted to a boolean; are you sure this is intended? If so, consider using `! empty($expr)` instead to make it clear that you intend to check for an array without elements. This check marks implicit conversions of arrays to boolean values in a comparison. While in PHP an empty array is considered to be equal (but not identical) to false, this is not always apparent. Consider making the comparison explicit by using `empty(..)` or `! empty(...)` instead. Loading history...
83	2		foreach ($this->columns as $column) {
84	2		if ($column instanceof GridColumn) {
85	2		$column->setOption('sortable', false);
86			}
87			}
88			}
89	2		}
90
91	2		public function getDefaultSort()
92			{
93	2		return null;
94			}
95
96			public function getCount()
97			{
98			$qb = $this->getQueryBuilder();
99			$qb->add('select', 'count(j)')
			0 ignored issues – show Documentation introduced 2017-12-05 17:25 UTC by Report Bug Copy Issue Report `'count(j)'` is of type `string`, but the function expects a `object<Doctrine\ORM\Query\Expr\Base>`. It seems like the type of the argument is not accepted by the function/method which you are calling. In some cases, in particular if PHP’s automatic type-juggling kicks in this might be fine. In other cases, however this might be a bug. We suggest to add an explicit type cast like in the following example: function acceptsInteger($int) { } $x = '123'; // string "123" // Instead of acceptsInteger($x); // we recommend to use acceptsInteger((integer) $x); Loading history...
100			->setFirstResult(null)
101			->setMaxResults(null);
102
103			return $qb->getQuery()
104			->getSingleScalarResult();
105			}
106			}
107

mmucklo / DtcQueueBundle

Pull Request — master (#30)

LiveJobsGridSource::getQueryBuilder() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like