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
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
|
<?php
/**
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License along
* with this program; if not, write to the Free Software Foundation, Inc.,
* 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
* http://www.gnu.org/copyleft/gpl.html
*
* @file
*/
namespace MediaWiki\Pager;
use MediaWiki\Utils\MWTimestamp;
use Wikimedia\Timestamp\TimestampException;
/**
* Pager for filtering by a range of dates.
*
* @stable to extend
* @ingroup Pager
*/
abstract class RangeChronologicalPager extends ReverseChronologicalPager {
/**
* @var string[]
* @deprecated since 1.40, use $startOffset and $endOffset instead.
*/
protected $rangeConds;
/** @var string */
protected $startOffset;
/**
* Set and return a date range condition using timestamps provided by the user.
* We want the revisions between the two timestamps.
* Also supports only having a start or end timestamp.
* Assumes that the start timestamp comes before the end timestamp.
*
* @stable to override
*
* @param string $startTime Timestamp of the beginning of the date range (or empty)
* @param string $endTime Timestamp of the end of the date range (or empty)
* @return array|null Database conditions to satisfy the specified date range
* or null if dates are invalid
*/
public function getDateRangeCond( $startTime, $endTime ) {
// Construct the conds array for compatibility with callers and derived classes
$this->rangeConds = [];
try {
if ( $startTime !== '' ) {
$startTimestamp = MWTimestamp::getInstance( $startTime );
$this->startOffset = $this->mDb->timestamp( $startTimestamp->getTimestamp() );
$this->rangeConds[] = $this->mDb->buildComparison( '>=',
[ $this->getTimestampField() => $this->startOffset ] );
}
if ( $endTime !== '' ) {
$endTimestamp = MWTimestamp::getInstance( $endTime );
// Turned to use '<' for consistency with the parent class,
// add one second for compatibility with existing use cases
$endTimestamp->timestamp = $endTimestamp->timestamp->modify( '+1 second' );
$this->endOffset = $this->mDb->timestamp( $endTimestamp->getTimestamp() );
$this->rangeConds[] = $this->mDb->buildComparison( '<',
[ $this->getTimestampField() => $this->endOffset ] );
// populate existing variables for compatibility with parent
$this->mYear = (int)$endTimestamp->format( 'Y' );
$this->mMonth = (int)$endTimestamp->format( 'm' );
$this->mDay = (int)$endTimestamp->format( 'd' );
}
} catch ( TimestampException $ex ) {
return null;
}
return $this->rangeConds;
}
/**
* Return the range of date offsets, in the format of [ endOffset, startOffset ].
* Extensions can use this to get the range if they are not in the context of subclasses.
*
* @since 1.40
* @return string[]
*/
public function getRangeOffsets() {
return [ $this->endOffset, $this->startOffset ];
}
/**
* @inheritDoc
*/
protected function buildQueryInfo( $offset, $limit, $order ) {
[ $tables, $fields, $conds, $fname, $options, $join_conds ] = parent::buildQueryInfo(
$offset,
$limit,
$order
);
// End of the range has been added by ReverseChronologicalPager
if ( $this->startOffset ) {
$conds[] = $this->mDb->expr( $this->getTimestampField(), '>=', $this->startOffset );
} elseif ( $this->rangeConds ) {
// Keep compatibility with some derived classes, T325034
$conds = array_merge( $conds, $this->rangeConds );
}
return [ $tables, $fields, $conds, $fname, $options, $join_conds ];
}
}
/** @deprecated class alias since 1.41 */
class_alias( RangeChronologicalPager::class, 'RangeChronologicalPager' );
|
