MatchActivityQueryBuilder

Complexity

Total Complexity

1

Size/Duplication

Total Lines	75
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	2

Importance

Changes

0

1 Method

Rating	Name	Duplication	Size	Complexity
B	buildMatchActivity()	0	39	1

<?php

use Pecee\Pixie\QueryBuilder\JoinBuilder;

abstract class MatchActivityQueryBuilder extends QueryBuilderFlex
{
    /**
     * @throws \Pecee\Pixie\Exception
     * @throws Exception
     */
    protected function buildMatchActivity()
    {
        $qb = self::createBuilder();
        $type = $this->modelType;

        // The subquery to calculate each match's worth towards activity if it has occurred less than 45 days ago.
        //   - 86400 is in seconds; i.e. 24 hours
        //   - 0.0116687059537612 is a magic number
        $matchActivityWorthQuery = $qb->table('matches')->alias('m');
        $matchActivityWorthQuery
            ->select([
                'm.id',
                'm.team_a',
                'm.team_b',
                $qb->raw('TIMESTAMPDIFF(SECOND, `m`.`timestamp`, NOW()) / 86400 AS days_passed'),
                $qb->raw('(0.0116687059537612 * (POW((45 - LEAST((SELECT days_passed), 45)), (1/6)) + ATAN(31 - (SELECT days_passed)) / 2)) AS activity'),
            ])
            ->where($qb->raw('DATEDIFF(NOW(), `m`.`timestamp`) <= 45'))
            ->orderBy('m.timestamp', 'DESC')
        ;

        $this
            ->select(
                $qb->raw('SUM(m2.activity) AS activity')
            )
            ->leftJoin(
                $qb->subQuery($matchActivityWorthQuery, 'm2'),
                function ($table) {
                    /** @var JoinBuilder $table */
                    $table->on('teams.id', '=', 'm2.team_a');
                    $table->orOn('teams.id', '=', 'm2.team_b');
                }
            )
            ->whereNot('teams.is_deleted', '=', true)
            ->groupBy($type::getEagerColumnsList())
        ;

        return $this;
    }

//    protected function includeMatchActivity($selectColumns, $leftJoinOn, $useMatchParticipationTable = false)
//    {
//        $type = $this->type;
//        $columns = $type::getEagerColumns($this->getFromAlias());
//
//        $this->columns['activity'] = 'activity';
//        $this->extraColumns = 'SUM(m2.activity) AS activity';
//        $this->extras .= '
//          LEFT JOIN
//            (SELECT
//              m.id,'
//              . implode(',', $selectColumns) . ',
//              TIMESTAMPDIFF(SECOND, timestamp, NOW()) / 86400 AS days_passed,
//              (0.0116687059537612 * (POW((45 - LEAST((SELECT days_passed), 45)), (1/6)) + ATAN(31 - (SELECT days_passed)) / 2)) AS activity
//            FROM
//              matches m' .
//            ($useMatchParticipationTable ? ' INNER JOIN match_participation mp ON m.id = mp.match_id ' : '')
//            . '
//            WHERE
//              DATEDIFF(NOW(), timestamp) <= 45
//            ORDER BY
//              timestamp DESC) m2 ON ' . $leftJoinOn
//        ;
//
//        $this->groupQuery = 'GROUP BY ' . $columns;
//
//        return $this;
//    }
}