rich1.0phorkiehttps://p.cweiske.de/TYPO3: Query Builder PaginatorChristian Weiske86400900900<!-- embedding all files of https://p.cweiske.de/951 -->
<link rel="stylesheet" href="https://p.cweiske.de/css/embed.css"/>
<div class="phork" id="951">
<div class="phork-file">
<div class="phork-content">
<div class="document">
<p>which only fetches the records that shall be displayed, instead of all records from database like the "QueryResultPaginator" does.</p>
<p>Rejected TYPO3 feature request: <a class="reference external" href="https://forge.typo3.org/issues/102194">https://forge.typo3.org/issues/102194</a></p>
</div>
</div>
<div class="phork-meta">
<a href="https://p.cweiske.de/951/rev-raw/5a5633920af44d072c10353a56f2c4bba8e26869/0-README.rst" style="float: right">view raw source</a>
<a href="https://p.cweiske.de/951#0-README.rst">0-README.rst</a>
</div>
</div>
<div class="phork-file">
<div class="phork-content">
<style type="text/css">/**
* GeSHi (C) 2004 - 2007 Nigel McNie, 2007 - 2014 Benny Baumann
* (http://qbnz.com/highlighter/ and http://geshi.org/)
*/
.php .de1, .php .de2 {font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;}
.php {font-family:monospace;}
.php .imp {font-weight: bold; color: red;}
.php li, .php .li1 {color: #DDD;}
.php .ln {width:1px;text-align:right;margin:0;padding:0 2px;vertical-align:top;}
.php .kw1 {color: #b1b100;}
.php .kw2 {color: #000000; font-weight: bold;}
.php .kw3 {color: #990000;}
.php .kw4 {color: #009900; font-weight: bold;}
.php .co1 {color: #666666; font-style: italic;}
.php .co2 {color: #666666; font-style: italic;}
.php .co3 {color: #0000cc; font-style: italic;}
.php .co4 {color: #009933; font-style: italic;}
.php .coMULTI {color: #666666; font-style: italic;}
.php .es0 {color: #000099; font-weight: bold;}
.php .es1 {color: #000099; font-weight: bold;}
.php .es2 {color: #660099; font-weight: bold;}
.php .es3 {color: #660099; font-weight: bold;}
.php .es4 {color: #006699; font-weight: bold;}
.php .es5 {color: #006699; font-weight: bold; font-style: italic;}
.php .es6 {color: #009933; font-weight: bold;}
.php .es_h {color: #000099; font-weight: bold;}
.php .br0 {color: #009900;}
.php .sy0 {color: #339933;}
.php .sy1 {color: #000000; font-weight: bold;}
.php .st0 {color: #0000ff;}
.php .st_h {color: #0000ff;}
.php .nu0 {color: #cc66cc;}
.php .nu8 {color: #208080;}
.php .nu12 {color: #208080;}
.php .nu19 {color:#800080;}
.php .me1 {color: #004000;}
.php .me2 {color: #004000;}
.php .re0 {color: #000088;}
.php span.xtra { display:block; }
</style><div class="code"><table class="php"><tbody><tr class="li1"><td class="ln"><pre class="de1">1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
</pre></td><td class="de1"><pre class="de1"><span class="kw2"><?php</span>
 
<span class="kw2">declare</span><span class="br0">(</span>strict_types<span class="sy0">=</span><span class="nu0">1</span><span class="br0">)</span><span class="sy0">;</span>
 
<span class="kw2">namespace</span> Vendor\Extension\Helper<span class="sy0">;</span>
 
<span class="kw2">use</span> TYPO3\CMS\Core\Database\Query\QueryBuilder<span class="sy0">;</span>
<span class="kw2">use</span> TYPO3\CMS\Core\Pagination\AbstractPaginator<span class="sy0">;</span>
 
<span class="co4">/**</span>
<span class="co4"> * Copy of TYPO3\CMS\Extbase\Pagination\QueryResultPaginator</span>
<span class="co4"> * that supports a QueryBuilder as source</span>
<span class="co4"> */</span>
<span class="kw2">class</span> QueryBuilderPaginator <span class="kw2">extends</span> AbstractPaginator
<span class="br0">{</span>
    <span class="kw2">private</span> QueryBuilder <span class="re0">$queryBuilder</span><span class="sy0">;</span>
 
    <span class="kw2">private</span> <a href="http://www.php.net/array"><span class="kw3">array</span></a> <span class="re0">$paginatedQueryResult</span><span class="sy0">;</span>
 
    <span class="kw2">public</span> <span class="kw2">function</span> __construct<span class="br0">(</span>
        QueryBuilder <span class="re0">$queryBuilder</span><span class="sy0">,</span>
        int <span class="re0">$currentPageNumber</span> <span class="sy0">=</span> <span class="nu0">1</span><span class="sy0">,</span>
        int <span class="re0">$itemsPerPage</span> <span class="sy0">=</span> <span class="nu0">10</span>
    <span class="br0">)</span> <span class="br0">{</span>
        <span class="re0">$this</span><span class="sy0">-></span><span class="me1">queryBuilder</span> <span class="sy0">=</span> <span class="re0">$queryBuilder</span><span class="sy0">;</span>
        <span class="re0">$this</span><span class="sy0">-></span><span class="me1">setCurrentPageNumber</span><span class="br0">(</span><span class="re0">$currentPageNumber</span><span class="br0">)</span><span class="sy0">;</span>
        <span class="re0">$this</span><span class="sy0">-></span><span class="me1">setItemsPerPage</span><span class="br0">(</span><span class="re0">$itemsPerPage</span><span class="br0">)</span><span class="sy0">;</span>
 
        <span class="re0">$this</span><span class="sy0">-></span><span class="me1">updateInternalState</span><span class="br0">(</span><span class="br0">)</span><span class="sy0">;</span>
    <span class="br0">}</span>
 
    <span class="kw2">public</span> <span class="kw2">function</span> getPaginatedItems<span class="br0">(</span><span class="br0">)</span><span class="sy0">:</span> iterable
    <span class="br0">{</span>
        <span class="kw1">return</span> <span class="re0">$this</span><span class="sy0">-></span><span class="me1">paginatedQueryResult</span><span class="sy0">;</span>
    <span class="br0">}</span>
 
    <span class="kw2">protected</span> <span class="kw2">function</span> updatePaginatedItems<span class="br0">(</span>int <span class="re0">$limit</span><span class="sy0">,</span> int <span class="re0">$offset</span><span class="br0">)</span><span class="sy0">:</span> void
    <span class="br0">{</span>
        <span class="re0">$this</span><span class="sy0">-></span><span class="me1">paginatedQueryResult</span> <span class="sy0">=</span> <span class="re0">$this</span><span class="sy0">-></span><span class="me1">queryBuilder</span>
            <span class="sy0">-></span><span class="me1">setMaxResults</span><span class="br0">(</span><span class="re0">$limit</span><span class="br0">)</span>
            <span class="sy0">-></span><span class="me1">setFirstResult</span><span class="br0">(</span><span class="re0">$offset</span><span class="br0">)</span>
            <span class="sy0">-></span><span class="me1">execute</span><span class="br0">(</span><span class="br0">)</span>
            <span class="sy0">-></span><span class="me1">fetchAllAssociative</span><span class="br0">(</span><span class="br0">)</span><span class="sy0">;</span>
    <span class="br0">}</span>
 
    <span class="kw2">protected</span> <span class="kw2">function</span> getTotalAmountOfItems<span class="br0">(</span><span class="br0">)</span><span class="sy0">:</span> int
    <span class="br0">{</span>
        <span class="kw1">return</span> <span class="br0">(</span>clone <span class="re0">$this</span><span class="sy0">-></span><span class="me1">queryBuilder</span><span class="br0">)</span><span class="sy0">-></span><a href="http://www.php.net/count"><span class="kw3">count</span></a><span class="br0">(</span><span class="st_h">'uid'</span><span class="br0">)</span><span class="sy0">-></span><span class="me1">executeQuery</span><span class="br0">(</span><span class="br0">)</span><span class="sy0">-></span><span class="me1">fetchOne</span><span class="br0">(</span><span class="br0">)</span><span class="sy0">;</span>
    <span class="br0">}</span>
 
    <span class="kw2">protected</span> <span class="kw2">function</span> getAmountOfItemsOnCurrentPage<span class="br0">(</span><span class="br0">)</span><span class="sy0">:</span> int
    <span class="br0">{</span>
        <span class="kw1">return</span> <a href="http://www.php.net/count"><span class="kw3">count</span></a><span class="br0">(</span><span class="re0">$this</span><span class="sy0">-></span><span class="me1">paginatedQueryResult</span><span class="br0">)</span><span class="sy0">;</span>
    <span class="br0">}</span>
<span class="br0">}</span>
 </pre></td></tr></tbody></table></div>
</div>
<div class="phork-meta">
<a href="https://p.cweiske.de/951/rev-raw/5a5633920af44d072c10353a56f2c4bba8e26869/QueryBuilderPaginator.php" style="float: right">view raw source</a>
<a href="https://p.cweiske.de/951#QueryBuilderPaginator.php">QueryBuilderPaginator.php</a>
</div>
</div>
</div>