YetiForceCompany/YetiForceCRM

<?php
/**
 * @copyright YetiForce S.A.
 * @license   YetiForce Public License 6.5 (licenses/LicenseEN.txt or yetiforce.com)
 * @author    Mariusz Krzaczkowski <m.krzaczkowski@yetiforce.com>
 * @author    Radosław Skrzypczak <r.skrzypczak@yetiforce.com>
 */

namespace App\Db;

/**
 * Command represents a SQL statement to be executed against a database.
 *
 * A command object is usually created by calling [[Connection::createCommand()]].
 * The SQL statement it represents can be set via the [[sql]] property.
 *
 * To execute a non-query SQL (such as INSERT, DELETE, UPDATE), call [[execute()]].
 * To execute a SQL statement that returns a result data set (such as SELECT),
 * use [[queryAll()]], [[queryOne()]], [[queryColumn()]], [[queryScalar()]], or [[query()]].
 */
class Command extends \yii\db\Command
{
    /**
     * Executes the SQL statement and returns query result.
     * This method is for executing a SQL query that returns result set, such as `SELECT`.
     *
     * @throws Exception execution failed
     *
     * @return \yii\db\DataReader the reader object for fetching the query result
     */
    public function query()
    {
        return $this->queryInternal('');
    }

    /**
     * Executes the SQL statement and returns ALL rows at once.
     *
     * @param int $type - fetchMode the result fetch mode. Please refer to [PHP manual](https://secure.php.net/manual/en/function.PDOStatement-setFetchMode.php))
     *                  for valid fetch modes. If this parameter is null, the value set in [[fetchMode]] will be used
     *
     * @throws Exception execution failed
     *
     * @return array all rows of the query result. Each array element is an array representing a row of data.
     *               An empty array is returned if the query results in nothing
     */
    public function queryAllByGroup(int $type = 0)
    {
        switch ($type) {
            case 0:
                return $this->queryInternal('fetchAll', \PDO::FETCH_KEY_PAIR);
            case 1:
                return $this->queryInternal('fetchAll', \PDO::FETCH_GROUP | \PDO::FETCH_UNIQUE | \PDO::FETCH_ASSOC);
            case 2:
                return $this->queryInternal('fetchAll', \PDO::FETCH_GROUP | \PDO::FETCH_COLUMN | \PDO::FETCH_ASSOC);
            default:
                break;
        }
    }
}