wcfsetup/install/files/lib/system/stat/LikeStatDailyHandler.class.php

   1 <?php
   2 namespace wcf\system\stat;
   3 use wcf\data\like\Like;
   4 use wcf\system\WCF;
   5
   6 /**
   7  * Stat handler implementation for like stats.
   8  *
   9  * @author      Marcel Werk
  10  * @copyright   2001-2014 WoltLab GmbH
  11  * @license     GNU Lesser General Public License <http://opensource.org/licenses/lgpl-license.php>
  12  * @package     com.woltlab.wcf
  13  * @subpackage  system.stat
  14  * @category    Community Framework
  15  */
  16 class LikeStatDailyHandler extends AbstractStatDailyHandler {
  17         protected $likeValue = Like::LIKE;
  18
  19         /**
  20          * @see \wcf\system\stat\IStatDailyHandler::getData()
  21          */
  22         public function getData($date) {
  23                 $sql = "SELECT  COUNT(*)
  24                         FROM    wcf".WCF_N."_like
  25                         WHERE   time BETWEEN ? AND ?
  26                                 AND likeValue = ?";
  27                 $statement = WCF::getDB()->prepareStatement($sql);
  28                 $statement->execute(array($date, $date + 86399, $this->likeValue));
  29                 $counter = intval($statement->fetchColumn());
  30
  31                 $sql = "SELECT  COUNT(*)
  32                         FROM    wcf".WCF_N."_like
  33                         WHERE   time < ?
  34                                 AND likeValue = ?";
  35                 $statement = WCF::getDB()->prepareStatement($sql);
  36                 $statement->execute(array($date + 86400, $this->likeValue));
  37                 $total = intval($statement->fetchColumn());
  38
  39                 return array(
  40                         'counter' => $counter,
  41                         'total' => $total
  42                 );
  43         }
  44 }