FlightLog\Infrastructure\Damage\Query\Repository\GetPilotDamagesQueryRepository

Complexity

Total Complexity

5

Size/Duplication

Total Lines	45
Duplicated Lines	100 %

Coupling/Cohesion

Components	1
Dependencies	1

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	4	4	1
A	query()	23	23	4

<?php


namespace FlightLog\Infrastructure\Damage\Query\Repository;

use FlightLog\Application\Damage\Query\GetPilotDamagesQueryRepositoryInterface;
use FlightLog\Application\Damage\ViewModel\TotalDamage;

final class GetPilotDamagesQueryRepository implements GetPilotDamagesQueryRepositoryInterface

This class seems to be duplicated in your project.

{

    /**
     * @var \DoliDB
     */
    private $db;

    /**
     * @param $db
     */
    public function __construct($db)
    {
        $this->db = $db;
    }

    /**
     * @param int $year
     *
     * @return TotalDamage[]|array
     */
    public function query($year)
    {
        $sql = 'SELECT SUM(damage.amount) as total_amount, damage.author_id as author';
        $sql.=' FROM '.MAIN_DB_PREFIX.'bbc_flight_damages as damage';
        $sql.=' INNER JOIN '.MAIN_DB_PREFIX.'bbc_vols as flight ON flight.rowid = damage.flight_id';
        $sql.=' WHERE YEAR(flight.date) = '.$this->db->escape($year);
        $sql.=' GROUP BY damage.author_id';

        $damages = [];

        $resql = $this->db->query($sql);
        if ($resql) {
            $num = $this->db->num_rows($resql);
            if ($num) {
                for($i = 0; $i < $num ; $i++) {
                    $properties = $this->db->fetch_array($resql);
                    $damages[] = TotalDamage::fromArray($properties);
                }
            }
        }

        return $damages;
    }
}