AL\Common\DAO\IndividualDAO

Complexity

Total Complexity

10

Size/Duplication

Total Lines	134
Duplicated Lines	0 %

Importance

Changes

0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	getIndividual()	0	27	2
A	addIndividual()	0	14	1
A	__construct()	0	2	1
A	getAllIndividuals()	0	27	2
A	getIndividualsStartingWith()	0	34	4

<?php
namespace AL\Common\DAO;

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

/**
 * DAO for Individual
 */
class IndividualDAO {
    private $mysqli;

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

    /**
     * Get all individuals
     * @return \AL\Common\Model\Individual\Individual[] A list of individuals
     */
    public function getAllIndividuals() {
        $stmt = \AL\Db\execute_query(
            "IndividualDAO: getAllIndividuals",
            $this->mysqli,
            "SELECT ind_id, ind_name FROM individuals ORDER BY ind_name ASC",
            null,
            null
        );

        \AL\Db\bind_result(
            "IndividualDAO: getAllIndividuals",
            $stmt,
            $id,
            $name

The variable $name seems to be never defined.

        );

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

        $stmt->close();

        return $individuals;
    }

    /**
     * Browse individuals by first letter
     * @param string $search_string can either be a single letter or "num" which represents numbers
     * @return \AL\Common\Model\Individual\Individual[] A list of individuals
     */
    public function getIndividualsStartingWith($search_string) {
        if (isset($search_string) and $search_string == "num") {
            $search_string = "^[0-9]";
        } else {
            $search_string = "^$search_string";
        }

        $stmt = \AL\Db\execute_query(
            "IndividualDAO: getIndividualsStartingWith",
            $this->mysqli,
            "SELECT ind_id, ind_name FROM individuals
            WHERE LOWER(ind_name) REGEXP ? ORDER BY ind_name ASC",
            "s",
            strtolower($search_string)
        );

        \AL\Db\bind_result(
            "IndividualDAO: getIndividualsStartingWith",
            $stmt,
            $id,
            $name

The variable $name seems to be never defined.

        );

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

        $stmt->close();

        return $individuals;
    }

    /**
     * Get a specific individual
     * @param number $id ID of the individual to retrieve
     * @return \AL\Common\Model\Individual\Individual The individual, or NULL if not found
     */
    public function getIndividual($id) {
        $stmt = \AL\Db\execute_query(
            "IndividualDAO: getIndividual: $id",
            $this->mysqli,
            "SELECT ind_id, ind_name FROM individuals WHERE ind_id = ?",
            "i",
            $id
        );

        \AL\Db\bind_result(
            "IndividualDAO: getIndividual: $id",
            $stmt,
            $id,
            $name

The variable $name seems to be never defined.

        );

        $individual = null;
        if ($stmt->fetch()) {
            $individual = new \AL\Common\Model\Individual\Individual(
                $id,
                $name
            );
        }

        $stmt->close();

        return $individual;
    }

    /**
     * Add new individual
     * @param number $new_ind_name Name of new indivudal
     * @return new primary key
     */
    public function addIndividual($new_ind_name) {
        $stmt = \AL\Db\execute_query(
            "IndividualDAO: addIndividual: $new_ind_name",
            $this->mysqli,
            "INSERT INTO individuals (ind_name) VALUES (?)",
            "s",
            $new_ind_name
        );

        $new_ind_id = $stmt->insert_id;

        $stmt->close();

        return $new_ind_id;
    }
}