AL\Common\DAO\PubDevDAO

Complexity

Total Complexity

10

Size/Duplication

Total Lines	163
Duplicated Lines	0 %

Importance

Changes

0

7 Methods

Rating	Name	Duplication	Size	Complexity
A	addDistributorToRelease()	0	9	1
A	getPubDevsStartingWith()	0	33	2
A	getPubDev()	0	33	2
A	getDistributorsForRelease()	0	33	2
A	getAllPubDevs()	0	2	1
A	deleteDistributorFromRelease()	0	9	1
A	__construct()	0	2	1

<?php
namespace AL\Common\DAO;

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

/**
 * DAO for PubDev
 */
class PubDevDAO {
    private $mysqli;

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

    public function getAllPubDevs() {
        return $this->getPubDevsStartingWith(".");
    }
    /**
     * Get all publishers and developers
     * @return \AL\Common\Model\PubDev\PubDev[] A list of PubDevs
     */
    public function getPubDevsStartingWith($regexp) {
        $stmt = \AL\Db\execute_query(
            "PubDevDAO: getAllPubDev",
            $this->mysqli,
            "SELECT
                pub_dev.pub_dev_id,
                pub_dev.pub_dev_name,
                pub_dev_text.pub_dev_profile,
                pub_dev_text.pub_dev_imgext
            FROM
                pub_dev
            LEFT JOIN pub_dev_text ON pub_dev_text.pub_dev_id = pub_dev.pub_dev_id
            WHERE LOWER(pub_dev.pub_dev_name) REGEXP ?
            ORDER BY pub_dev.pub_dev_name ASC",
            "s", strtolower($regexp)
        );

        \AL\Db\bind_result(
            "PubDevDAO: getAllPubDev",
            $stmt,
            $id, $name, $profile, $imgext

The variable $imgext seems to be never defined.

The variable $name seems to be never defined.

The variable $profile seems to be never defined.

        );

        $pubdevs = [];
        while ($stmt->fetch()) {
            $pubdevs[] = new \AL\Common\Model\PubDev\PubDev(
                $id, $name, $profile, $imgext
            );
        }

        $stmt->close();

        return $pubdevs;
    }

    /**
     * Get a publisher or developer
     * @param number $id ID of the pubdev to retrieve
     * @return \AL\Common\Model\PubDev\PubDev PubDev, or NULL if not found
     */
    public function getPubDev($id) {
        $stmt = \AL\Db\execute_query(
            "PubDevDAO: getPubDev",
            $this->mysqli,
            "SELECT
                pub_dev.pub_dev_id,
                pub_dev.pub_dev_name,
                pub_dev_text.pub_dev_profile,
                pub_dev_text.pub_dev_imgext
            FROM
                pub_dev
            LEFT JOIN pub_dev_text ON pub_dev_text.pub_dev_id = pub_dev.pub_dev_id
            WHERE pub_dev.pub_dev_id = ?
            ORDER BY pub_dev.pub_dev_name ASC",
            "i", $id
        );

        \AL\Db\bind_result(
            "PubDevDAO: getPubDev",
            $stmt,
            $id, $name, $profile, $imgext

The variable $profile seems to be never defined.

The variable $imgext seems to be never defined.

The variable $name seems to be never defined.

        );

        $pubdev = null;
        if ($stmt->fetch()) {
            $pubdev = new \AL\Common\Model\PubDev\PubDev(
                $id, $name, $profile, $imgext
            );
        }

        $stmt->close();

        return $pubdev;
    }
    
    
    /**
     * Get list of distributors 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 getDistributorsForRelease($game_release_id) {
        $stmt = \AL\Db\execute_query(
            "PubDevDAO: getDistributorsForRelease",
            $this->mysqli,
            "SELECT
                pub_dev.pub_dev_id,
                pub_dev.pub_dev_name,
                pub_dev_text.pub_dev_profile,
                pub_dev_text.pub_dev_imgext
            FROM
                pub_dev
            LEFT JOIN pub_dev_text ON pub_dev_text.pub_dev_id = pub_dev.pub_dev_id
            LEFT JOIN game_release_distributor ON pub_dev.pub_dev_id = game_release_distributor.pub_dev_id
            WHERE game_release_distributor.game_release_id = ?",
            "i", $game_release_id
        );

        \AL\Db\bind_result(
            "PubDevDAO: getDistributorsForRelease",
            $stmt,
            $id, $name, $profile, $imgext

The variable $name seems to be never defined.

The variable $imgext seems to be never defined.

The variable $profile seems to be never defined.

        );

        $distributors = [];
        while ($stmt->fetch()) {
            $distributors[] = new \AL\Common\Model\PubDev\PubDev(
                $id, $name, $profile, $imgext
            );
        }

        $stmt->close();

        return $distributors;
    }
    
      /**
     * add a distributor to a release
     *
     * @param integer release ID
     * @param integer pub_Dev ID

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

     */
    public function addDistributorToRelease($release_id, $pub_dev_id) {
        $stmt = \AL\Db\execute_query(
            "PubDevDAO: addDistributorToRelease",
            $this->mysqli,
            "INSERT INTO game_release_distributor (game_release_id, pub_dev_id) VALUES (?, ?)",
            "ii", $release_id, $pub_dev_id
        );

        $stmt->close();
    }
    
    
    /**
     * delete a distributor from a release
     *
     * @param int release_id
     * @param int pub_dv_id

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

     */
    public function deleteDistributorFromRelease($release_id, $pub_dev_id) {
        $stmt = \AL\Db\execute_query(
            "PubDevDAO: deleteDistributorFromRelease",
            $this->mysqli,
            "DELETE FROM game_release_distributor WHERE game_release_id = ? and pub_dev_id = ?",
            "ii", $release_id, $pub_dev_id
        );

        $stmt->close();
    }
}