src/Biz/RefererLog/Dao/Impl/RefererLogDaoImpl.php

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

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

<?php

namespace Biz\RefererLog\Dao\Impl;

use Biz\RefererLog\Dao\RefererLogDao;
use Codeages\Biz\Framework\Dao\GeneralDaoImpl;

class RefererLogDaoImpl extends GeneralDaoImpl implements RefererLogDao
{
    protected $table = 'referer_log';

    public function declares()
    {
        return array(
            'timestamps' => array('createdTime', 'updatedTime'),
            'orderbys' => array('createdTime', 'recommendedSeq', 'studentNum', 'hitNum'),
            'conditions' => array(
                'targetType = :targetType',
                'targetId = :targetId',
                'targetId IN (:targetIds)',
                'id IN (:ids)',
                'targetInnerType = :targetInnerType',
                'createdTime >= :startTime',
                'token = :token',
                'ip = :ip',
                'createdTime <= :endTime',
            ),
        );
    }

    public function findRefererLogsGroupByTargetId($targetType, $orderBy, $startTime, $endTime, $start, $limit)
    {
        $parameters = array($targetType, $targetType);
        $sql = "SELECT a.targetId AS targetId, b.hitNum AS hitNum,b.orderCount AS orderCount
                    FROM (SELECT targetId FROM {$this->table} WHERE targetType = ?
                GROUP BY targetId) AS a LEFT JOIN (SELECT targetId, COUNT(id) AS hitNum, SUM(orderCount) AS orderCount FROM {$this->table}
                WHERE targetType = ?";

        if (!empty($startTime)) {
            $sql .= 'AND createdTime >= ?';
            $parameters[] = $startTime;
        }

        if (!empty($endTime)) {
            $sql .= 'and createdTime <= ?';
            $parameters[] = $endTime;
        }
        $sql .= "GROUP BY targetId) AS b ON a.targetId = b.targetId ORDER BY {$orderBy[0]} {$orderBy[1]},targetId DESC";
        $sql = $this->sql($sql, array(), $start, $limit);

        return $this->db()->fetchAll($sql, $parameters);
    }

    public function analysisSummary($conditions)
    {
        $groupBy = 'refererName';
        $builder = $this->createQueryBuilder($conditions, $groupBy)
            ->select('refererName, count(targetId) as count, sum(orderCount) as orderCount')
            ->addOrderBy('count', 'DESC');