DatabasePagination::offset() - Code Metrics - locomotivemtl/charcoal-core - Measure and Improve Code Quality continuously with Scrutinizer

DatabasePagination::offset() A
last analyzed 2019-10-30 23:55 UTC

↳ Parent: DatabasePagination

Complexity

Conditions	2
Paths	2

Size

Total Lines	10
Code Lines	6

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	2
eloc	6
nc	2
nop	0
dl	0
loc	10
rs	10
c	0
b	0
f	0

<?php

namespace Charcoal\Source\Database;

use UnexpectedValueException;

// From 'charcoal-core'
use Charcoal\Source\Database\DatabaseExpressionInterface;
use Charcoal\Source\Pagination;

/**
 * SQL Pagination Clause
 */
class DatabasePagination extends Pagination implements
    DatabaseExpressionInterface
{
    /**
     * Converts the pagination into a SQL expression for the LIMIT clause.
     *
     * @return string A SQL string fragment.
     */
    public function sql()
    {
        if ($this->active() && $this->hasLimit()) {
            $limit  = $this->limit();
            $offset = $this->offset();
            return 'LIMIT '.$offset.', '.$limit;
        }

        return '';
    }

    /**
     * Determine if the expression has a number per page.
     *
     * @return boolean
     */
    public function hasLimit()
    {
        return ($this->limit() > 0);
    }

    /**
     * Alias of {@see self::numPerPage()}
     *
     * @return integer
     */
    public function limit()
    {
        return $this->numPerPage();
    }

    /**
     * Retrieve the offset from the page number and count.
     *
     * @return integer
     */
    public function offset()
    {
        $page   = $this->page();
        $limit  = $this->numPerPage();
        $offset = (($page - 1) * $limit);
        if (PHP_INT_MAX <= $offset) {
            $offset = PHP_INT_MAX;
        }

        return max(0, $offset);
    }
}


1			<?php
2
3			namespace Charcoal\Source\Database;
4
5			use UnexpectedValueException;
6
7			// From 'charcoal-core'
8			use Charcoal\Source\Database\DatabaseExpressionInterface;
9			use Charcoal\Source\Pagination;
10
11			/**
12			* SQL Pagination Clause
13			*/
14			class DatabasePagination extends Pagination implements
15			DatabaseExpressionInterface
16			{
17			/**
18			* Converts the pagination into a SQL expression for the LIMIT clause.
19			*
20			* @return string A SQL string fragment.
21			*/
22			public function sql()
23			{
24			if ($this->active() && $this->hasLimit()) {
25			$limit = $this->limit();
26			$offset = $this->offset();
27			return 'LIMIT '.$offset.', '.$limit;
28			}
29
30			return '';
31			}
32
33			/**
34			* Determine if the expression has a number per page.
35			*
36			* @return boolean
37			*/
38			public function hasLimit()
39			{
40			return ($this->limit() > 0);
41			}
42
43			/**
44			* Alias of {@see self::numPerPage()}
45			*
46			* @return integer
47			*/
48			public function limit()
49			{
50			return $this->numPerPage();
51			}
52
53			/**
54			* Retrieve the offset from the page number and count.
55			*
56			* @return integer
57			*/
58			public function offset()
59			{
60			$page = $this->page();
61			$limit = $this->numPerPage();
62			$offset = (($page - 1) * $limit);
63			if (PHP_INT_MAX <= $offset) {
64			$offset = PHP_INT_MAX;
65			}
66
67			return max(0, $offset);
68			}
69			}
70

locomotivemtl / charcoal-core

DatabasePagination::offset() A last analyzed 2019-10-30 23:55 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

DatabasePagination::offset() A
last analyzed 2019-10-30 23:55 UTC