1 | <?php |
||
35 | class Spec |
||
36 | { |
||
37 | /* |
||
38 | * Logic |
||
39 | */ |
||
40 | |||
41 | /** |
||
42 | * @return AndX |
||
43 | */ |
||
44 | public static function andX() |
||
51 | |||
52 | /** |
||
53 | * @return OrX |
||
54 | */ |
||
55 | public static function orX() |
||
62 | |||
63 | /** |
||
64 | * @param Filter $spec |
||
65 | * |
||
66 | * @return Not |
||
67 | */ |
||
68 | public static function not(Filter $spec) |
||
72 | |||
73 | /* |
||
74 | * Query modifier |
||
75 | */ |
||
76 | |||
77 | /** |
||
78 | * @param string $field |
||
79 | * @param string $newAlias |
||
80 | * @param string $dqlAlias |
||
81 | * |
||
82 | * @return Join |
||
83 | */ |
||
84 | public static function join($field, $newAlias, $dqlAlias = null) |
||
88 | |||
89 | /** |
||
90 | * @param string $field |
||
91 | * @param string $newAlias |
||
92 | * @param string $dqlAlias |
||
93 | * |
||
94 | * @return LeftJoin |
||
95 | */ |
||
96 | public static function leftJoin($field, $newAlias, $dqlAlias = null) |
||
100 | |||
101 | /** |
||
102 | * @param string $field |
||
103 | * @param string $newAlias |
||
104 | * @param string $dqlAlias |
||
105 | * |
||
106 | * @return InnerJoin |
||
107 | */ |
||
108 | public static function innerJoin($field, $newAlias, $dqlAlias = null) |
||
112 | |||
113 | /** |
||
114 | * @param int $count |
||
115 | * |
||
116 | * @return Limit |
||
117 | */ |
||
118 | public static function limit($count) |
||
122 | |||
123 | /** |
||
124 | * @param int $count |
||
125 | * |
||
126 | * @return Offset |
||
127 | */ |
||
128 | public static function offset($count) |
||
132 | |||
133 | /** |
||
134 | * @param int $sliceSize |
||
135 | * @param int $sliceNumber |
||
136 | * |
||
137 | * @return Slice |
||
138 | */ |
||
139 | public static function slice($sliceSize, $sliceNumber = 0) |
||
143 | |||
144 | /** |
||
145 | * @param string $field |
||
146 | * @param string $order |
||
147 | * @param string|null $dqlAlias |
||
148 | * |
||
149 | * @return OrderBy |
||
150 | */ |
||
151 | public static function orderBy($field, $order = 'ASC', $dqlAlias = null) |
||
155 | |||
156 | /** |
||
157 | * @param string $field |
||
158 | * @param string $dqlAlias |
||
159 | * |
||
160 | * @return GroupBy |
||
161 | */ |
||
162 | public static function groupBy($field, $dqlAlias = null) |
||
166 | |||
167 | /* |
||
168 | * Result modifier |
||
169 | */ |
||
170 | |||
171 | /** |
||
172 | * @return AsArray |
||
173 | */ |
||
174 | public static function asArray() |
||
178 | |||
179 | /** |
||
180 | * @return AsSingleScalar |
||
181 | */ |
||
182 | public static function asSingleScalar() |
||
186 | |||
187 | /** |
||
188 | * @return AsScalar |
||
189 | */ |
||
190 | public static function asScalar() |
||
194 | |||
195 | /** |
||
196 | * @param int $cacheLifetime How many seconds the cached entry is valid |
||
197 | * |
||
198 | * @return Cache |
||
199 | */ |
||
200 | public static function cache($cacheLifetime) |
||
204 | |||
205 | /** |
||
206 | * @param int $roundSeconds How may seconds to round time |
||
207 | * |
||
208 | * @return RoundDateTime |
||
209 | */ |
||
210 | public static function roundDateTimeParams($roundSeconds) |
||
214 | |||
215 | /* |
||
216 | * Filters |
||
217 | */ |
||
218 | |||
219 | /** |
||
220 | * @param string $field |
||
221 | * @param string|null $dqlAlias |
||
222 | * |
||
223 | * @return IsNull |
||
224 | */ |
||
225 | public static function isNull($field, $dqlAlias = null) |
||
229 | |||
230 | /** |
||
231 | * @param string $field |
||
232 | * @param string|null $dqlAlias |
||
233 | * |
||
234 | * @return IsNotNull |
||
235 | */ |
||
236 | public static function isNotNull($field, $dqlAlias = null) |
||
240 | |||
241 | /** |
||
242 | * Make sure the $field has a value equals to $value. |
||
243 | * |
||
244 | * @param string $field |
||
245 | * @param mixed $value |
||
246 | * @param string $dqlAlias |
||
247 | * |
||
248 | * @return In |
||
249 | */ |
||
250 | public static function in($field, $value, $dqlAlias = null) |
||
254 | |||
255 | /** |
||
256 | * @param string $field |
||
257 | * @param mixed $value |
||
258 | * @param string $dqlAlias |
||
259 | * |
||
260 | * @return Not |
||
261 | */ |
||
262 | public static function notIn($field, $value, $dqlAlias = null) |
||
266 | |||
267 | /** |
||
268 | * @param string $field |
||
269 | * @param string $value |
||
270 | * @param string $dqlAlias |
||
271 | * |
||
272 | * @return Comparison |
||
273 | */ |
||
274 | public static function eq($field, $value, $dqlAlias = null) |
||
278 | |||
279 | /** |
||
280 | * @param string $field |
||
281 | * @param string $value |
||
282 | * @param string $dqlAlias |
||
283 | * |
||
284 | * @return Comparison |
||
285 | */ |
||
286 | public static function neq($field, $value, $dqlAlias = null) |
||
290 | |||
291 | /** |
||
292 | * @param string $field |
||
293 | * @param string $value |
||
294 | * @param string $dqlAlias |
||
295 | * |
||
296 | * @return Comparison |
||
297 | */ |
||
298 | public static function lt($field, $value, $dqlAlias = null) |
||
302 | |||
303 | /** |
||
304 | * @param string $field |
||
305 | * @param string $value |
||
306 | * @param string $dqlAlias |
||
307 | * |
||
308 | * @return Comparison |
||
309 | */ |
||
310 | public static function lte($field, $value, $dqlAlias = null) |
||
314 | |||
315 | /** |
||
316 | * @param string $field |
||
317 | * @param string $value |
||
318 | * @param string $dqlAlias |
||
319 | * |
||
320 | * @return Comparison |
||
321 | */ |
||
322 | public static function gt($field, $value, $dqlAlias = null) |
||
326 | |||
327 | /** |
||
328 | * @param string $field |
||
329 | * @param string $value |
||
330 | * @param string $dqlAlias |
||
331 | * |
||
332 | * @return Comparison |
||
333 | */ |
||
334 | public static function gte($field, $value, $dqlAlias = null) |
||
338 | |||
339 | /** |
||
340 | * @param string $field |
||
341 | * @param string $value |
||
342 | * @param string $format |
||
343 | * @param string $dqlAlias |
||
344 | * |
||
345 | * @return Like |
||
346 | */ |
||
347 | public static function like($field, $value, $format = Like::CONTAINS, $dqlAlias = null) |
||
351 | |||
352 | /** |
||
353 | * @param string $value |
||
354 | * @param null $dqlAlias |
||
355 | * |
||
356 | * @return InstanceOfX |
||
357 | */ |
||
358 | public static function instanceOfX($value, $dqlAlias = null) |
||
362 | |||
363 | /* |
||
364 | * Specifications |
||
365 | */ |
||
366 | |||
367 | /** |
||
368 | * @param Filter|QueryModifier $spec |
||
369 | * |
||
370 | * @return CountOf |
||
371 | */ |
||
372 | public static function countOf($spec) |
||
376 | |||
377 | /** |
||
378 | * @param Filter|string $spec |
||
379 | * |
||
380 | * @return Having |
||
381 | */ |
||
382 | public static function having($spec) |
||
386 | } |
||
387 |