GeoFixer\models\queries\AbstractDatabaseQuery

Complexity

Total Complexity

7

Size/Duplication

Total Lines	105
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	3

Test Coverage

Coverage

100%

Importance

Changes	1
Bugs	0	Features	1

7 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	4	1
A	firstLetters()	0	6	1
A	regionCode()	0	6	1
A	kladrCode()	0	6	1
A	parentId()	0	6	1
A	findAll()	0	4	1
A	findOne()	0	4	1

<?php

namespace GeoFixer\models\queries;

use Cake\Database\Connection;
use GeoFixer\models\DatabaseConnection;

/**
 * Class AbstractDatabaseQuery
 *
 * @package GeoFixer\models\queries
 */
class AbstractDatabaseQuery
{
    /**
     * Address levels в базе ФИАС
     */
    const CITY = 4;
    const SETTLEMENT = 6;
    const STREET = 7;

    const KLADR_CODE = 'code';
    const FIAS_CODE = 'address_id';
    const TITLE = 'title';


    /**
     * @var Connection::newQuery()
     */
    protected $db;

    /**
     * AbstractDatabaseQuery constructor.
     *
     * @uses Connection::newQuery()
     */
    public function __construct()
    {
        $this->db = DatabaseConnection::connection()->newQuery();
    }

    /**
     * Первые буквы равны
     *
     * @param $letters
     *
     * @return $this
     */
    public function firstLetters($letters)
    {
        $this->db = $this->db->andWhere([self::TITLE . ' LIKE' => $letters . '%']);

        return $this;
    }

    /**
     * Код региона равен
     *
     * @param $code
     *
     * @return $this
     */
    public function regionCode($code)
    {
        $this->db = $this->db->andWhere(['region_code' => $code]);

        return $this;
    }

    /**
     * Код КЛАДР равен
     *
     * @param $code
     *
     * @return $this
     */
    public function kladrCode($code)
    {
        $this->db = $this->db->andWhere([self::KLADR_CODE => $code]);

        return $this;
    }

    /**
     * ID родителя равен
     *
     * @param $id
     *
     * @return $this
     */
    public function parentId($id)
    {
        $this->db = $this->db->andWhere(['parent_id' => $id]);

        return $this;
    }

    /**
     * Получаем массив значений
     *
     * @return array
     */
    public function findAll()
    {
        return $this->db->execute()->fetchAll('assoc');
    }

    /**
     * Получаем одно значение
     *
     * @return array
     */
    public function findOne()
    {
        return $this->db->execute()->fetch('assoc');
    }
}