groupBy

[iammiloslukic]

Hi guys, I added some methods for a GROUP BY operand. Maybe you will need it too.

\vendor\leafs\db\src\Db.php

/**
 * Group query results by a column
 * 
 * @param string $column The column to group results by
 */
public function groupBy($column)
{
    $this->query = Builder::groupBy($this->query, $column);
    return $this;
}

\vendor\leafs\db\src\Db\Builder.php

/**
 * Group query results by a column
 * 
 * @param string $query The query to modify (if any)
 * @param string $column The column to group results by
 */
public static function groupBy(
    string $query,
    string $column
): string {
    if (strpos($query, 'GROUP BY') === false) {
        $query .= " GROUP BY $column";
    } else {
        $parts = explode('GROUP BY', $query);
        $query = implode("GROUP BY $column", $parts);
    }

    return $query;
}