FlightLog\Infrastructure\Damage\Query\Repository\GetPilotDamagesQueryRepository::query()

Complexity

Conditions	4
Paths	3

Size

Total Lines

23

Duplication

Lines	23
Ratio	100 %

Importance

Changes

0

<?php
    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;
    }
}