MatchQueryBuilder

Complexity

Total Complexity

21

Size/Duplication

Total Lines	93
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	4

Test Coverage

Coverage

86.96%

Importance

Changes	1
Bugs	0	Features	1

3 Methods

Rating	Name	Duplication	Size	Complexity
C	with()	0	37	16
A	groupByMonth()	0	6	1
B	getSummary()	0	27	4

<?php
/**
 * This file contains a class to quickly generate database queries for matches
 *
 * @package    BZiON\Models\QueryBuilder
 * @license    https://github.com/allejo/bzion/blob/master/LICENSE.md GNU General Public License Version 3
 */

/**
 * This class can be used to search for matches with specific characteristics in
 * the database.
 *
 * @package    BZiON\Models\QueryBuilder
 */
class MatchQueryBuilder extends QueryBuilder
{
    /**
     * Only include matches where a specific team played
     *
     * @param  Team   $team   Team        The team which played the matches
     * @param  string $result string|null The outcome of the matches (win, draw or loss)
     * @return self
     */
    public function with($team, $result = null)
    {
        if (!$team || !$team->isValid()) {
            return $this;
        }

        switch ($result) {
            case "wins":
            case "win":
            case "victory":
            case "victories":
                $query = "(team_a = ? AND team_a_points > team_b_points) OR (team_b = ? AND team_b_points > team_a_points)";
                break;
            case "loss":
            case "lose":
            case "losses":
            case "defeat":
            case "defeats":
                $query = "(team_a = ? AND team_b_points > team_a_points) OR (team_b = ? AND team_a_points > team_b_points)";
                break;
            case "draw":
            case "draws":
            case "tie":
            case "ties":
                $query = "(team_a = ? OR team_b = ?) AND team_a_points = team_b_points";
                break;
            default:
                $query = "team_a = ? OR team_b = ?";
        }

        $this->conditions[] = $query;
        $this->parameters[] = $team->getId();
        $this->parameters[] = $team->getId();
        $this->types       .= 'ii';

        return $this;
    }

    /**
     * Group results by day
     *
     * @return $this
     */
    public function groupByMonth()
    {
        $this->groupQuery .= "GROUP BY YEAR(timestamp), MONTH(timestamp)";

        return $this;
    }

    /**
     * Get a count for each month's matches
     *
     * @param Team $team The team in question
     * @return array
     */
    public function getSummary(Team $team)
    {
        $this->groupByMonth();

        $query = $this->createQuery("YEAR(timestamp) as y, MONTH(timestamp) as m, COUNT(*) as count");

        $matches = array();
        $results = Database::getInstance()->query($query, $this->types, $this->parameters);

        foreach ($results as $match) {
            $matches[$match['y'] . '-' . sprintf('%02d', $match['m'])] = $match['count'];
        }

        // Add entries for dates with 0 matches
        $timestamp = $team->getCreationDate()->setTimezone('UTC')->startOfMonth();
        while ($timestamp->lte(TimeDate::now())) {
            $key = $timestamp->format('Y-m');
            if (!isset($matches[$key])) {
                $matches[$key] = 0;
            }

            $timestamp->addMonth();
        }
        ksort($matches);

        return $matches;
    }
}