WelcomeTemplate

Complexity

Total Complexity

15

Size/Duplication

Total Lines	106
Duplicated Lines	0 %

Test Coverage

Coverage

0%

Importance

Changes	2
Bugs	0	Features	0

8 Methods

Rating	Name	Duplication	Size	Complexity
A	getUserCode()	0	3	1
A	getUsersUsingTemplate()	0	19	3
A	save()	0	25	4
A	getBotCode()	0	3	1
A	setBotCode()	0	3	1
A	getObjectDescription()	0	3	1
A	setUserCode()	0	3	1
A	getAll()	0	19	3

<?php

/**
 * Welcome template data object
 */
class WelcomeTemplate extends DataObject
{
	private $usercode;
	private $botcode;

	private $usageCache;

	/**
	 * Summary of getAll
	 * @param PdoDatabase $database
	 * @return WelcomeTemplate[]
	 */
	public static function getAll(PdoDatabase $database = null)
	{
		if ($database == null) {
			$database = gGetDb();
		}

		$statement = $database->prepare("SELECT * FROM welcometemplate;");

		$statement->execute();

		$result = array();
		/** @var WelcomeTemplate $v */
		foreach ($statement->fetchAll(PDO::FETCH_CLASS, get_called_class()) as $v) {
			$v->isNew = false;
			$v->setDatabase($database);
			$result[] = $v;
		}

		return $result;
	}

	public function save()
	{
		if ($this->isNew) {
// insert
			$statement = $this->dbObject->prepare("INSERT INTO welcometemplate (usercode, botcode) VALUES (:usercode, :botcode);");
			$statement->bindValue(":usercode", $this->usercode);
			$statement->bindValue(":botcode", $this->botcode);

			if ($statement->execute()) {
				$this->isNew = false;
				$this->id = $this->dbObject->lastInsertId();

The property $id was declared of type integer, but $this->dbObject->lastInsertId() is of type string. Maybe add a type cast?

			}
			else {
				throw new Exception($statement->errorInfo());

$statement->errorInfo() of type array is incompatible with the type string expected by parameter $message of Exception::__construct().

			}
		}
		else {
// update
			$statement = $this->dbObject->prepare("UPDATE `welcometemplate` SET usercode = :usercode, botcode = :botcode WHERE id = :id;");
			$statement->bindValue(":id", $this->id);
			$statement->bindValue(":usercode", $this->usercode);
			$statement->bindValue(":botcode", $this->botcode);

			if (!$statement->execute()) {
				throw new Exception($statement->errorInfo());
			}
		}
	}

	public function getUserCode()
	{
		return $this->usercode;
	}

	public function setUserCode($usercode)
	{
		$this->usercode = $usercode;
	}

	public function getBotCode()
	{
		return $this->botcode;
	}

	public function setBotCode($botcode)
	{
		$this->botcode = $botcode;
	}

	public function getUsersUsingTemplate()
	{
		if ($this->usageCache === null) {
			$statement = $this->dbObject->prepare("SELECT * FROM user WHERE welcome_template = :id;");

			$statement->execute(array(":id" => $this->id));

			$result = array();
			/** @var WelcomeTemplate $v */
			foreach ($statement->fetchAll(PDO::FETCH_CLASS, 'User') as $v) {
				$v->isNew = false;
				$v->setDatabase($this->dbObject);
				$result[] = $v;
			}

			$this->usageCache = $result;
		}

		return $this->usageCache;
	}
	
	public function getObjectDescription()
	{
		return '<a href="acc.php?action=templatemgmt&amp;view=' . $this->getId() . '">' . htmlentities($this->usercode) . "</a>";
	}
}