AL\Common\DAO\LocationDAO

Complexity

Total Complexity

11

Size/Duplication

Total Lines	150
Duplicated Lines	0 %

Importance

Changes

0

6 Methods

Rating	Name	Duplication	Size	Complexity
A	getAllLocations()	0	26	2
A	getAllLocationsAsMap()	0	8	2
A	getLocationsForRelease()	0	28	2
A	setLocationsForRelease()	0	18	2
A	getLocationsIdsForRelease()	0	26	2
A	__construct()	0	2	1

<?php
namespace AL\Common\DAO;

require_once __DIR__."/../../lib/Db.php" ;
require_once __DIR__."/../Model/Location/Location.php" ;

/**
 * DAO for Locations
 */
class LocationDAO {
    private $mysqli;

    public function __construct($mysqli) {
        $this->mysqli = $mysqli;
    }

    /**
     * Get all locations
     *
     * @return \AL\Common\Model\Location\Location[] A list of locations
     */
    public function getAllLocations() {
        $stmt = \AL\Db\execute_query(
            "LocationDAO: getAllLocations",
            $this->mysqli,
            "SELECT id, continent_code, name, country_iso2, country_iso3, type
            FROM location
            ORDER by continent_code, type, name",
            null, null
        );

        \AL\Db\bind_result(
            "LocationDAO: getAllLocations",
            $stmt,
            $id, $continent_code, $name, $country_iso2, $country_iso3, $type

The variable $country_iso2 seems to be never defined.

The variable $continent_code seems to be never defined.

The variable $name seems to be never defined.

The variable $type seems to be never defined.

The variable $country_iso3 seems to be never defined.

        );

        $locations = [];
        while ($stmt->fetch()) {
            $locations[] = new \AL\Common\Model\Location\Location(
                $id, $continent_code, $name, $country_iso2, $country_iso3, $type
            );
        }

        $stmt->close();

        return $locations;
    }

    /**
     * Get all the locations IDs for a game release
     *
     * @param integer Release ID

The type AL\Common\DAO\Release was not found. Maybe you did not declare it correctly or list all dependencies?

     * @return \AL\Common\Model\Location\Location[] A list of locations
     */
    public function getLocationsIdsForRelease($release_id) {
        $stmt = \AL\Db\execute_query(
            "LocationDAO: getLocationsIdsForRelease",
            $this->mysqli,
            "SELECT location_id
            FROM game_release_location
            LEFT JOIN location on location.id = game_release_location.location_id
            WHERE game_release_id = ?
            ORDER by continent_code, type, name",
            "i", $release_id
        );

        \AL\Db\bind_result(
            "LocationDAO: getLocationsIdsForRelease",
            $stmt,
            $location_id
        );

        $locations = [];
        while ($stmt->fetch()) {
            $locations[] = $location_id;
        }

        $stmt->close();

        return $locations;
    }

    /**
     * Get all the locations for a release
     *
     * @param integer Release ID
     * @return \AL\Common\Model\Location\Location[] A list of locations
     */
    public function getLocationsForRelease($release_id) {
        $stmt = \AL\Db\execute_query(
            "LocationDAO: getLocationsIdsForRelease",
            $this->mysqli,
            "SELECT location.id, continent_code, name, country_iso2, country_iso3, type
            FROM game_release_location
            LEFT JOIN location on location.id = game_release_location.location_id
            WHERE game_release_id = ?
            ORDER by continent_code, type, name",
            "i", $release_id
        );

        \AL\Db\bind_result(
            "LocationDAO: getLocationsIdsForRelease",
            $stmt,
            $id, $continent_code, $name, $country_iso2, $country_iso3, $type

The variable $country_iso2 seems to be never defined.

The variable $name seems to be never defined.

The variable $country_iso3 seems to be never defined.

The variable $continent_code seems to be never defined.

The variable $type seems to be never defined.

        );

        $locations = [];
        while ($stmt->fetch()) {
            $locations[] = new \AL\Common\Model\Location\Location(
                $id, $continent_code, $name, $country_iso2, $country_iso3, $type
            );
        }

        $stmt->close();

        return $locations;
    }

    /**
     * Set the list of locations a release was released in
     *
     * @param integer Release ID
     * @param integer[] List of location IDs

The type AL\Common\DAO\List was not found. Maybe you did not declare it correctly or list all dependencies?

     * @return \AL\Common\Model\Location\Location[] A list of locations
     */
    public function setLocationsForRelease($release_id, $locations) {
        $stmt = \AL\Db\execute_query(
            "LocationDAO: setLocationsForRelease",
            $this->mysqli,
            "DELETE FROM game_release_location WHERE game_release_id = ?",
            "i", $release_id
        );

        foreach ($locations as $id) {
            $stmt = \AL\Db\execute_query(
                "LocationDAO: setLocationsForRelease",
                $this->mysqli,
                "INSERT INTO game_release_location (game_release_id, location_id) VALUES (?, ?)",
                "ii", $release_id, $id
            );
        }

        $stmt->close();
    }

    /**
     * Get a map containing all locations, indexed by ID
     *
     * @return \AL\Common\Model\Location\Location[] A map of locations
     */
    public function getAllLocationsAsMap() {
        $locations = $this->getAllLocations();
        $locationsMap = array();
        foreach ($locations as $location) {
            $locationsMap[$location->getId()] = $location;
        }

        return $locationsMap;
    }
}