Bluz\Tests\Fixtures\Models\Test\Crud::readSet PHP Method

readSet() public method

public readSet ( integer $offset, integer $limit = 10, array $params = [] ) : array | integer | mixed
$offset integer
$limit integer
$params array
return array | integer | mixed
    public function readSet($offset = 0, $limit = 10, $params = [])
    {
        $select = Db::select('*')->from('test', 't');
        if ($limit) {
            $selectPart = $select->getQueryPart('select');
            $selectPart = 'SQL_CALC_FOUND_ROWS ' . current($selectPart);
            $select->select($selectPart);
            $select->setLimit($limit);
            $select->setOffset($offset);
        }
        $result = $select->execute('\\Bluz\\Tests\\Fixtures\\Models\\Test\\Row');
        if ($limit) {
            $total = Db::fetchOne('SELECT FOUND_ROWS()');
        } else {
            $total = sizeof($result);
        }
        if (sizeof($result) < $total) {
            Response::setStatusCode(206);
            Response::setHeader('Content-Range', 'items ' . $offset . '-' . ($offset + sizeof($result)) . '/' . $total);
        }
        return $result;
    }