AL\Common\DAO\TrainerOptionDAO

Complexity

Total Complexity

10

Size/Duplication

Total Lines	145
Duplicated Lines	0 %

Importance

Changes

0

7 Methods

Rating	Name	Duplication	Size	Complexity
A	getAllTrainerOptions()	0	24	2
A	addTrainerOption()	0	9	1
A	updateTrainerOption()	0	9	1
A	__construct()	0	2	1
A	deleteTrainerOption()	0	9	1
A	getTrainerOptionsForRelease()	0	27	2
A	setTrainerOptionsForRelease()	0	18	2

<?php
namespace AL\Common\DAO;

require_once __DIR__."/../../lib/Db.php" ;
require_once __DIR__."/../Model/Game/TrainerOption.php" ;

/**
 * DAO for Trainer Option
 */
class TrainerOptionDAO {
    private $mysqli;

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

    /**
     * Get all Trainer Options
     *
     * @return \AL\Common\Model\Game\TrainerOptions[] An array of options
     */
    public function getAllTrainerOptions() {
        $stmt = \AL\Db\execute_query(
            "TrainerOptionDAO: getAllTrainerOptions",
            $this->mysqli,
            "SELECT id, name FROM trainer_option ORDER BY name",
            null, null
        );

        \AL\Db\bind_result(
            "TrainerOptionDAO: getAllTrainerOptions",
            $stmt,
            $id, $name

The variable $name seems to be never defined.

        );

        $trainer_options = [];
        while ($stmt->fetch()) {
            $trainer_options[] = new \AL\Common\Model\Game\TrainerOption(
                $id, $name
            );
        }

        $stmt->close();

        return $trainer_options;
    }

    /**
     * Get list of trainer_option 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?

     */
    public function getTrainerOptionsForRelease($release_id) {
        $stmt = \AL\Db\execute_query(
            "TrainerOptionDAO: getTrainerOptionsForRelease",
            $this->mysqli,
            "SELECT trainer_option_id, name
            FROM game_release_trainer_option LEFT JOIN 
            trainer_option ON (game_release_trainer_option.trainer_option_id = trainer_option.id)
            WHERE release_id = ?",
            "i", $release_id
        );

        \AL\Db\bind_result(
            "TrainerOptionDAO: getTrainerOptionsForRelease",
            $stmt,
            $trainer_option_id, $name

The variable $name seems to be never defined.

        );

        $trainer_options = [];
        while ($stmt->fetch()) {
            $trainer_options[] = new \AL\Common\Model\Game\TrainerOption(
                $trainer_option_id, $name
            );
        }

        $stmt->close();

        return $trainer_options;
    }
    
    /**
     * Set the list of trainer options for this release
     *
     * @param integer release ID
     * @param integer[] List of trainer option IDs

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

     */
    public function setTrainerOptionsForRelease($release_id, $trainer_option_id) {
        $stmt = \AL\Db\execute_query(
            "TrainerOptionDAO: setTrainerOptionsForRelease",
            $this->mysqli,
            "DELETE FROM game_release_trainer_option WHERE release_id = ?",
            "i", $release_id
        );

        foreach ($trainer_option_id as $id) {
            $stmt = \AL\Db\execute_query(
                "TrainerOptionDAO: setTrainerOptionsForRelease",
                $this->mysqli,
                "INSERT INTO game_release_trainer_option (release_id, trainer_option_id) VALUES (?, ?)",
                "ii", $release_id, $id
            );
        }

        $stmt->close();
    }
     
     /**
     * add a trainer_option to the database
     *
     * @param varchar trainer_option

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

     */
    public function addTrainerOption($trainer_option) {
        $stmt = \AL\Db\execute_query(
            "TrainerOptionDAO: addTrainerOption",
            $this->mysqli,
            "INSERT INTO trainer_option (`name`) VALUES (?)",
            "s", $trainer_option
        );

        $stmt->close();
    }
    
    /**
     * delete a $trainer_option
     *
     * @param int $trainer_option_id
     */
    public function deleteTrainerOption($trainer_option_id) {
        $stmt = \AL\Db\execute_query(
            "TrainerOptionDAO: deleteTrainerOption",
            $this->mysqli,
            "DELETE FROM trainer_option WHERE id = ?",
            "i", $trainer_option_id
        );

        $stmt->close();
    }
    
        /**
     * update a trainer_option
     *
     * @param int trainer_option_id

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

     * @param varchar trainer_option_name

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

     */
    public function updateTrainerOption($trainer_option_id, $trainer_option_name) {
        $stmt = \AL\Db\execute_query(
            "TrainerOptionDAO: updateTrainerOption",
            $this->mysqli,
            "UPDATE trainer_option SET name = ? WHERE id = ?",
            "si", $trainer_option_name, $trainer_option_id
        );
        
        $stmt->close();
    }
}