FlightLog\Infrastructure\Damage\Query\Repository\GetDamagesForFlightQueryRepository::__invoke()

Complexity

Conditions	4
Paths	3

Size

Total Lines

22

Duplication

Lines	22
Ratio	100 %

Importance

Changes

0

<?php
    public function __invoke($flightId)
    {
        $sql = 'SELECT damage.amount, author.login as author_name';
        $sql.=' FROM '.MAIN_DB_PREFIX.'bbc_flight_damages as damage';
        $sql.=' INNER JOIN '.MAIN_DB_PREFIX.'user as author ON author.rowid = damage.author_id';
        $sql.=' WHERE damage.flight_id = '.$this->db->escape($flightId);

        $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[] = Damage::fromArray($properties);
                }
            }
        }

        return $damages;
    }
}