RepositoryBase.php

<?php

namespace entityfx\utils;

use entityfx\utils\enum\EnumBase;
use entityfx\utils\enum\OrderDirectionEnum;
use Yii;
use yii\base\Component;
use yii\db\Connection;
use yii\db\Query;

/**
 * Class RepositoryBase
 *
 * @author EntityFX <artem.solopiy@gmail.com>
 * @package Kontinent\Components\Common
 */
abstract class RepositoryBase extends Component {
    const REPOSITORY_CATEGORY    = 'app.components.repositories';

    /**
     *
     * @var Connection
     */
    protected $db;

    public function __construct()
    {
        parent::__construct();
        $this->db  = Yii::$app->db;
    }

    /**
     * Returns ORDER BY token for field enum and order enum
     *
     * @param EnumBase $orderField Field to order
     * @param OrderDirectionEnum $direction       Order direction
     *
     * @return string
     */
    protected function order(EnumBase $orderField, OrderDirectionEnum $direction)
    {
        return $orderField->getValue() . ' ' . $direction->getValue();
    }

    /**
     * Returns count items in table
     *
     * @param string $table SQL table name
     * @param mixed $where where condition
     * @param array $params parameters to bind in
     * @return int Count items
     */
    protected function getCount($table, $where, array $params)
    {
        return (int)((new Query())
            ->from($table)
            ->where($where, $params)
            ->count());
    }

    protected function getCountByCommand($tableName, Query $command)
    {
        $command->from($tableName);

        return (int)$command->count();
    }

    /**
     * Returns id of inserted record
     *
     * @return int
     */
    protected function lastInsertId()
    {
        return (int)$this->db->getLastInsertID();
    }

    /**
     * Возвращает GUID
     *
     * @return Guid
     */
    protected function createGuid()
    {
        return Guid::generate();
    }
}