ZfTable\Source\SqlSelect

Complexity

Total Complexity

10

Size/Duplication

Total Lines	101
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	3

Importance

Changes

0

7 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	4	1
A	getSelect()	0	4	1
A	getSource()	0	4	1
A	getDataAsPdoStatement()	0	5	1
A	getPaginator()	0	12	2
A	order()	0	9	2
A	quickSearch()	0	7	2

<?php
/**
 * ZfTable ( Module for Zend Framework 2)
 *
 * @copyright Copyright (c) 2013 Piotr Duda dudapiotrek@gmail.com
 * @license   MIT License
 */

namespace ZfTable\Source;

use ZfTable\Source\AbstractSource;
use Zend\Paginator\Paginator;
use Zend\Paginator\Adapter\DbSelect;

class SqlSelect extends AbstractSource
{

    /**
     *
     * @var \Zend\Db\Sql\Select
     */
    protected $quickSearchQuery;

    /**
     *
     * @var \Zend\Db\Sql\Select
     */
    protected $select;

    /**
     *
     * @var  \Zend\Paginator\Paginator
     */
    protected $paginator;

    /**
     *
     * @param \Zend\Db\Sql\Select $select
     */
    public function __construct($select)
    {
        $this->select = $select;
    }

    /**
     *
     * @return \Zend\Db\Sql\Select
     */
    public function getSelect()
    {
        return $this->select;
    }

    /**
     *
     * @return \Zend\Db\Sql\Select
     */
    public function getSource()
    {
        return $this->select;
    }

    /**
     * Return data as PDO statement
     *
     * not-used
     * @return type
     */
    protected function getDataAsPdoStatement()
    {
        $statement = $this->getSql()->prepareStatementForSqlObject($this->select);

The method getSql() does not seem to exist on object<ZfTable\Source\SqlSelect>.

        return $statement->execute();
    }

    /**
     *
     * @return \Zend\Paginator\Paginator
     */
    public function getPaginator()
    {
        if (!$this->paginator) {
            $adapter = new DbSelect($this->getSelect(), $this->getTable()->getAdapter());
            $this->paginator = new Paginator($adapter);

            $this->order();

            $this->initPaginator();
        }
        return $this->paginator;
    }

    /**
     * Setting ordering
     */
    protected function order()
    {
        $column = $this->getParamAdapter()->getColumn();
        $order = $this->getParamAdapter()->getOrder();
        if ($column) {
            $this->select->reset('order');
            $this->select->order($column . ' ' . $order);
        }
    }

    /*
     * Init quick search
     */
    protected function quickSearch()
    {
        if ($this->getQuickSearchQuery()) {

The method getQuickSearchQuery() does not exist on ZfTable\Source\SqlSelect. Did you maybe mean quickSearch()?

            $where = $this->getQuickSearchQuery()->getRawState('where');

The method getQuickSearchQuery() does not exist on ZfTable\Source\SqlSelect. Did you maybe mean quickSearch()?

            $this->select->where($where);
        }
    }
}