PilotQueryRepository::__construct() - Code Metrics - Inspection of "pilot list" - laudeco/bbc-dolibarr-flightlog - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — feature/pilot_information ( 13ff1e...cc067b )

by Laurent

created 2021-04-10 07:16 UTC

PilotQueryRepository::__construct() A

↳ Parent: PilotQueryRepository

Complexity

Conditions	1
Paths	1

Size

Total Lines

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	1
nc	1
nop	1
dl	0
loc	4
rs	10
c	0
b	0
f	0

<?php


namespace FlightLog\Infrastructure\Pilot\Query\Repository;


use FlightLog\Application\Pilot\ViewModel\Pilot;

final class PilotQueryRepository
{
    /**
     * @var \DoliDB
     */
    private $db;

    public function __construct(\DoliDB $db)
    {
        $this->db = $db;
    }

    /**
     * @return array|Pilot[]
     */
    public function query():array{
        $sql = sprintf('SELECT 
            lastname as name,
            firstname as firstname,
            email as email,
            rowid as id
        FROM llx_user
        WHERE  statut = 1 
        AND firstname != \'\' 
        AND employee = 1
        ORDER BY lastname, firstname');

        $resql = $this->db->query($sql);
        if (!$resql) {
            return [];
        }

        $num = $this->db->num_rows($resql);
        if ($num === 0) {
            return [];
        }

        $pilots = [];
        for($i = 0; $i < $num ; $i++) {
            $pilots[] = Pilot::fromArray($this->db->fetch_array($resql));
        }

        return $pilots;
    }

}

1			<?php
2
3
4			namespace FlightLog\Infrastructure\Pilot\Query\Repository;
5
6
7			use FlightLog\Application\Pilot\ViewModel\Pilot;
8
9			final class PilotQueryRepository
10			{
11			/**
12			* @var \DoliDB
13			*/
14			private $db;
15
16			public function __construct(\DoliDB $db)
17			{
18			$this->db = $db;
19			}
20
21			/**
22			* @return array\|Pilot[]
23			*/
24			public function query():array{
25			$sql = sprintf('SELECT
26			lastname as name,
27			firstname as firstname,
28			email as email,
29			rowid as id
30			FROM llx_user
31			WHERE statut = 1
32			AND firstname != \'\'
33			AND employee = 1
34			ORDER BY lastname, firstname');
35
36			$resql = $this->db->query($sql);
37			if (!$resql) {
38			return [];
39			}
40
41			$num = $this->db->num_rows($resql);
42			if ($num === 0) {
43			return [];
44			}
45
46			$pilots = [];
47			for($i = 0; $i < $num ; $i++) {
48			$pilots[] = Pilot::fromArray($this->db->fetch_array($resql));
49			}
50
51			return $pilots;
52			}
53
54			}

laudeco / bbc-dolibarr-flightlog

Push — feature/pilot_information ( 13ff1e...cc067b )

PilotQueryRepository::__construct() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like