src/Biz/Task/Dao/Impl/TryViewLogDaoImpl.php

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<?php

namespace Biz\Task\Dao\Impl;

use Biz\Task\Dao\TryViewLogDao;
use Codeages\Biz\Framework\Dao\GeneralDaoImpl;

class TryViewLogDaoImpl extends GeneralDaoImpl implements TryViewLogDao
{
    protected $table = 'course_task_try_view';

    public function declares()
    {
        return array(
            'timestamps' => array('createdTime'),
            'orderbys' => array(),
            'conditions' => array(
                'courseId = :courseId',
                'createdTime >= :createdTime_GE',
                'createdTime <= :createdTime_LE',
            ),
        );
    }

    public function searchLogCountsByConditionsGroupByCreatedTimeWithFormat($conditions, $format = '%Y-%m-%d')
    {
        $builder = $this->createQueryBuilder($conditions)
            ->select("COUNT(id) as count, from_unixtime(createdTime, '{$format}') as date")
            ->from($this->table, $this->table)
            ->groupBy('date')
            ->orderBy('date', 'ASC');

        return $builder->execute()->fetchAll();
    }
}