stwalkerster / waca

		return $apiDocument;

	}

	private function getAccountsCreated()

	{

		$query = <<<QUERY

        SELECT COUNT(*) AS count

        FROM log

            LEFT JOIN emailtemplate ON concat('Closed ', emailtemplate.id) = log.action

            INNER JOIN user ON log.user = user.id

        WHERE

            (oncreated = '1' OR log.action = 'Closed custom-y')

            AND log.objecttype = 'Request'

            AND user.username = :username;

QUERY;

		$statement = $this->database->prepare($query);

		$statement->execute(array(":username" => $this->user->getUsername()));

		$result = $statement->fetchColumn();

		$statement->closeCursor();

		return $result;

	}

	private function getToday()

	{

		return md5($this->username . $this->email . $this->welcome_template . $this->id . $this->password);

	}

	public function getApprovalDate()

	{

		$query = $this->dbObject->prepare(<<<SQL

			SELECT timestamp 

			FROM log 

			WHERE objectid = :userid

				AND objecttype = 'User'

				AND action = 'Approved' 

			ORDER BY id DESC 

			LIMIT 1;

SQL

		);

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

		$data = DateTime::createFromFormat("Y-m-d H:i:s", $query->fetchColumn());

		$query->closeCursor();

		return $data;

	}

	public function getObjectDescription()

	{