Merge branch '3.0'

[GitHub/WoltLab/WCF.git] / wcfsetup / install / files / lib / system / stat / AbstractCommentStatDailyHandler.class.php

<?php
namespace wcf\system\stat;
use wcf\system\comment\CommentHandler;
use wcf\system\database\util\PreparedStatementConditionBuilder;
use wcf\system\exception\SystemException;
use wcf\system\WCF;

/**
 * Abstract implementation of a comment stat handler.
 * 
 * @author	Matthias Schmidt
 * @copyright	2001-2018 WoltLab GmbH
 * @license	GNU Lesser General Public License <http://opensource.org/licenses/lgpl-license.php>
 * @package	WoltLabSuite\Core\System\Stat
 */
abstract class AbstractCommentStatDailyHandler extends AbstractStatDailyHandler {
	/**
	 * name of the comment object type
	 * @var	string
	 */
	protected $objectType = '';
	
	/**
	 * @inheritDoc
	 */
	public function getData($date) {
		$objectTypeID = CommentHandler::getInstance()->getObjectTypeID($this->objectType);
		if ($objectTypeID === null) {
			throw new SystemException("Unknown comment object type '".$this->objectType."'");
		}
		
		$sql = "SELECT (
				SELECT	COUNT(*)
				FROM	wcf".WCF_N."_comment
				WHERE	objectTypeID = ?
					AND time BETWEEN ? AND ?
			) + (
				SELECT		COUNT(*)
				FROM		wcf".WCF_N."_comment_response comment_response
				LEFT JOIN	wcf".WCF_N."_comment comment
				ON		(comment.commentID = comment_response.commentID)
				WHERE		comment.objectTypeID = ?
						AND comment_response.time BETWEEN ? AND ?
			)";
		$statement = WCF::getDB()->prepareStatement($sql);
		$statement->execute([
			$objectTypeID,
			$date,
			$date + 86399,
			$objectTypeID,
			$date,
			$date + 86399
		]);
		$counter = $statement->fetchSingleColumn();
		
		$sql = "SELECT (
				SELECT	COUNT(*)
				FROM	wcf".WCF_N."_comment
				WHERE	objectTypeID = ?
					AND time < ?
			) + (
				SELECT		COUNT(*)
				FROM		wcf".WCF_N."_comment_response comment_response
				LEFT JOIN	wcf".WCF_N."_comment comment
				ON		(comment.commentID = comment_response.commentID)
				WHERE		comment.objectTypeID = ?
						AND comment_response.time < ?
			)";
		$statement = WCF::getDB()->prepareStatement($sql);
		$statement->execute([
			$objectTypeID,
			$date + 86400,
			$objectTypeID,
			$date + 86400
		]);
		$total = $statement->fetchSingleColumn();
		
		return [
			'counter' => $counter,
			'total' => $total
		];
	}
	
	/**
	 * @inheritDoc
	 * @since	3.1
	 */
	protected function addConditions(PreparedStatementConditionBuilder $conditionBuilder) {
		throw new \BadMethodCallException(__CLASS__ . " does not support addConditions().");
	}
}