| Conditions | 5 |
| Paths | 8 |
| Total Lines | 32 |
| Code Lines | 20 |
| Lines | 0 |
| Ratio | 0 % |
| Tests | 18 |
| CRAP Score | 5 |
| Changes | 0 | ||
| 1 | <?php |
||
| 36 | 1 | public function readSet($offset = 0, $limit = 10, $params = array()) |
|
| 37 | { |
||
| 38 | 1 | $select = Db::select('*') |
|
| 39 | 1 | ->from('test', 't'); |
|
| 40 | |||
| 41 | 1 | if ($limit) { |
|
| 42 | 1 | $selectPart = $select->getQueryPart('select'); |
|
| 43 | 1 | $selectPart = 'SQL_CALC_FOUND_ROWS ' . current($selectPart); |
|
| 44 | 1 | $select->select($selectPart); |
|
| 45 | |||
| 46 | 1 | $select->setLimit($limit); |
|
| 47 | 1 | $select->setOffset($offset); |
|
| 48 | } |
||
| 49 | |||
| 50 | 1 | $result = $select->execute('\\Application\\Test\\Row'); |
|
| 51 | |||
| 52 | 1 | if ($limit) { |
|
| 53 | 1 | $total = Db::fetchOne('SELECT FOUND_ROWS()'); |
|
| 54 | } else { |
||
| 55 | $total = sizeof($result); |
||
| 56 | } |
||
| 57 | |||
| 58 | 1 | if (sizeof($result) < $total && Request::METHOD_GET == Request::getMethod()) { |
|
| 59 | 1 | Response::setStatusCode(206); |
|
| 60 | 1 | Response::setHeader( |
|
| 61 | 1 | 'Content-Range', |
|
| 62 | 1 | 'items ' . $offset . '-' . ($offset + sizeof($result)) . '/' . $total |
|
| 63 | ); |
||
| 64 | } |
||
| 65 | |||
| 66 | 1 | return $result; |
|
| 67 | } |
||
| 68 | } |
||
| 69 |