Skip to Content

Wiki source code of TQL - atributy

Version 1.1 by Jan Šimeček on 2024/07/16 13:10
Show last authors
1 {{{ public String workTypeId() {
2 return workAlias + ".work_type";
3 }
4
5 public String workTitleShow() {
6 return workAlias + ".title_show";
7 }
8
9 public String workPublisherPlaceShow() {
10 return workAlias + ".publisher_place_show";
11 }
12
13 public String workExternalVersion() {
14 return workAlias + ".external_version";
15 }
16
17 public String workMedium() {
18 return workAlias + ".medium";
19 }
20
21 public String workMediumNumeric() {
22 return workAlias + ".medium";
23 }
24
25 public String workAuthorShow() {
26 return workAlias + ".author_show";
27 }
28
29 public String workLocMark() {
30 return workAlias + ".loc_mark";
31 }
32
33 public String workSpecialString1() {
34 return workAlias + ".special_s_1";
35 }
36
37 public String workSpecialString2() {
38 return workAlias + ".special_s_2";
39 }
40
41 public String workSpecialString3() {
42 return workAlias + ".special_s_3";
43 }
44
45 public String workHarvestedSourceId() {
46 return workAlias + ".harvested_source";
47 }
48
49 public String workSpecialString4() {
50 return workAlias + ".special_s_4";
51 }
52
53 public String workSpecialString5() {
54 return workAlias + ".special_s_5";
55 }
56
57 public String workSpecialString6() {
58 return workAlias + ".special_s_6";
59 }
60
61 public String workId() {
62 return workAlias + ".id";
63 }
64
65 public String workDateCreated() {
66 return workAlias + ".date_created ";
67 }
68
69 public String workDateModified() {
70 return workAlias + ".date_modified ";
71 }
72
73 public String itemDateCreated() {
74 return itemAlias + ".date_created ";
75 }
76
77 public String itemIncrementalNumberValueShow() {
78 return itemIncrementalNumberAlias + ".value_show";
79 }
80
81 public String itemIncrementalNumberRoot() {
82 return itemIncrementalNumberAlias + ".root";
83 }
84
85 public String itemIncrementalNumberValue() {
86 return itemIncrementalNumberAlias + ".value";
87 }
88
89 public String itemLocMarkValueShow() {
90 return itemLocMarkAlias + ".value_show";
91 }
92
93 public String itemStoreMarkValueShow() {
94 return itemStoreMarkAlias + ".value_show";
95 }
96
97 public String itemBarcode() {
98 return itemAlias + ".barcode";
99 }
100
101 public String itemAcquisitionTypeId() {
102 return itemAlias + ".acquisition_type";
103 }
104
105 public String itemId() {
106 return itemAlias + ".id";
107 }
108
109 public String itemLocationId() {
110 return itemAlias + ".location";
111 }
112
113 @Deprecated
114 public String itemLocationCode() {
115 return null;
116 }
117
118 @Deprecated
119 public String userIsLibrary() {
120 return null;
121 }
122
123 @Deprecated
124 public String itemLocationExternalId() {
125 return null;
126 }
127
128 @Deprecated
129 public String itemLocationOwnerExternalId() {
130 return null;
131 }
132
133 public String itemSublocationId() {
134 return itemAlias + ".sublocation";
135 }
136
137 public String itemWriteOffListId() {
138 return itemAlias + ".write_off_list";
139 }
140
141 public String itemWriteOffReasonId() {
142 return itemAlias + ".write_off_reason";
143 }
144
145 public String itemBorrowCategoryId() {
146 return itemAlias + ".borrow_category";
147 }
148
149 public String itemBorrowCategoryExternalId() {
150 return itemAlias + ".external_id";
151 }
152
153 public String itemBookBindingId() {
154 return itemAlias + ".book_binding";
155 }
156
157 public String itemLocationName() {
158 return null;
159 }
160
161 public String itemType() {
162 return itemAlias + ".type";
163 }
164
165 public String itemLocationOwnerId() {
166 return itemAlias + ".location_owner";
167 }
168
169 public String itemThematicGroupId() {
170 return itemAlias + ".thematic_group";
171 }
172
173 public String itemActive() {
174 return itemAlias + ".active";
175 }
176
177 public String itemLibraryId() {
178 return itemAlias + ".library";
179 }
180
181 public String itemLibraryOwnerId() {
182 return itemAlias + ".library_owner";
183 }
184
185 public String itemCompound() {
186 return itemAlias + ".compound";
187 }
188
189 public String itemImportId() {
190 return itemAlias + ".import_id";
191 }
192
193 public String itemReceiptNumber() {
194 return itemAlias + ".receipt_number";
195 }
196
197 public String itemPeriodicalYear() {
198 return itemAlias + ".periodical_year";
199 }
200
201 public String itemPeriodicalRow() {
202 return itemAlias + ".periodical_row";
203 }
204
205 public String authorityHeadingType() {
206 return authorityHeadingAlias + ".heading_type";
207 }
208
209 @Deprecated
210 public String itemProposalToWriteOff() {
211 return null;
212 }
213
214 @Deprecated
215 public String workIsPeriodical() {
216 return null;
217 }
218
219 @Deprecated
220 public String userCategoryId() {
221 return null;
222 }
223
224 @Deprecated
225 public String userEducationLevelCode() {
226 return null;
227 }
228
229 @Deprecated
230 public String currentTime() {
231 return null;
232 }
233
234 @Deprecated
235 public String workTypeName() {
236 return null;
237 }
238
239 public String userId() {
240 return userAlias + ".id";
241 }
242
243 public String userLastname() {
244 return userAlias + ".lastname";
245 }
246
247 public String userFirstname() {
248 return userAlias + ".firstname";
249 }
250
251 public String userUsername() {
252 return userAlias + ".username";
253 }
254
255 public String userFullname() {
256 return userAlias + ".fullname";
257 }
258
259 public String userBeforeAddressPermanent() {
260 return userAlias + ".before_address_permanent";
261 }
262
263 public String userStreetNumberPermanent() {
264 return userAlias + ".street_number_permanent";
265 }
266
267 public String userCityPermanent() {
268 return userAlias + ".city_permanent";
269 }
270
271 public String userPostNumberPermanent() {
272 return userAlias + ".post_number_permanent";
273 }
274
275 public String userLocationForExchangesId() {
276 return userAlias + ".location_for_exchanges";
277 }
278
279 @Deprecated
280 public String currentDate() {
281 return null;
282 }
283
284 @Deprecated
285 public String userAge() {
286 return null;
287 }
288
289 @Deprecated
290 public String userDefaultDepartmentId() {
291 return null;
292 }
293
294 @Deprecated
295 public String userDefaultDepartmentShortcut() {
296 return null;
297 }
298
299 @Deprecated
300 public String userCategoryCode() {
301 return null;
302 }
303
304 @Deprecated
305 public String userIsSingle() {
306 return null;
307 }
308
309 @Deprecated
310 public String userIsPartnerWithValidRegistration() {
311 return null;
312 }
313
314 @Deprecated
315 public String userIsFamily() {
316 return null;
317 }
318
319 @Deprecated
320 public String userIsPartner() {
321 return null;
322 }
323
324 @Deprecated
325 public String userIsFamilyWithValidRegistration() {
326 return null;
327 }
328
329 @Deprecated
330 public String userElectronicBorrowingsCurrentMonthCount() {
331 return null;
332 }
333
334 @Deprecated
335 public String workHasSubfieldNameWithValue() {
336 return null;
337 }
338
339 public String nowAddMonths(int count) {
340 return "NOW() " + (count > 0 ? "+" : "-") + " '" + Math.abs(count) + " MONTHS'::INTERVAL";
341 }
342
343 public String workHasSubfieldValueInSubfieldIds(String value, Integer... ids) {
344 String idsStr = Arrays.stream(ids)
345 .map(id -> id.toString())
346 .collect(Collectors.joining(", "));
347 return workDataAlias + ".subfield_definition IN (" + idsStr + ") AND " + workDataAlias + ".value_root = '" + value + "'";
348 }
349
350 public String userHasSubfieldValueInSubfieldId(String value, int id) {
351 return userDataAlias + ".subfield_definition = " + id + " AND " + userDataAlias + ".value_root = '" + value + "'";
352 }
353
354 @Deprecated
355 public String userElectronicBorrowingsCount() {
356 return null;
357 }
358
359 @Deprecated
360 public String itemHasSubfieldNameWithValue() {
361 return null;
362 }
363
364 @Deprecated
365 public String userReaderNumberValue() {
366 return null;
367 }
368
369 public String linkageRelationId() {
370 return linkageRelationAlias + "." + "id";
371 }
372
373 public String periodicalSheetId() {
374 return periodicalSheetAlias + "." + "id";
375 }
376
377 public String invoiceItemId() {
378 return invoiceItemAlias + "." + "id";
379 }
380
381 public String invoiceItemDefinitionId() {
382 return invoiceItemDefinitionAlias + "." + "id";
383 }
384
385 public String orderItemThematicGroupId() {
386 return orderItemAlias + "." + "thematic_group";
387 }
388
389 public String orderItemAcquisitionTypeId() {
390 return orderItemAlias + "." + "acquisition_type";
391 }
392
393 public String orderItemInLocationLocationId() {
394 return orderItemInLocationAlias + "." + "location";
395 }
396
397 public String userProfessionId() {
398 return userAlias + ".profession";
399 }
400
401 public String itemPrice() {
402 return itemAlias + ".price";
403 }
404
405 @Deprecated
406 public String userProfessionKey() {
407 return null;
408 }
409
410 @Deprecated
411 public String itemBorrowCategoryName() {
412 return null;
413 }
414
415 public String userSchoolId() {
416 return userAlias + ".school";
417 }
418
419 public String userEmail() {
420 return userAlias + ".email";
421 }
422
423 public String userPhone() {
424 return userAlias + ".phone";
425 }
426
427 public String userNote() {
428 return null;
429 }
430
431 public String workLanguage() {
432 return workAlias + ".language_work";
433 }
434
435 public String userDefaultGroupId() {
436 return userAlias + ".default_group";
437 }
438
439 public String itemNote() {
440 return itemAlias + ".note";
441 }
442
443 public String userCategoryType() {
444 return null;
445 }
446
447 public String userCautionNote() {
448 return userAlias + ".caution_note";
449 }
450
451 public String userIdentityCardNumber() {
452 return userAlias + ".identity_card_number";
453 }
454
455 public String workSpecialInt1() {
456 return workAlias + ".special_i_1";
457 }
458
459 public String workSpecialInt2() {
460 return workAlias + ".special_i_2";
461 }
462
463 public String workSpecialInt3() {
464 return workAlias + ".special_i_3";
465 }
466
467 public String itemWorkId() {
468 return itemAlias + ".work";
469 }
470
471 @Deprecated
472 public String userProfessionCode() {
473 return null;
474 }
475
476 @Deprecated
477 public String itemThematicGroupExternalId() {
478 return null;
479 }
480
481 public String itemUserDeletedId() {
482 return itemAlias + ".user_deleted";
483 }
484
485 @Deprecated
486 public String isUserVisitCountLimitExceed() {
487 return null;
488 }
489
490 @Deprecated
491 public String isShowUserVisitCountWarning() {
492 return null;
493 }
494
495 @Deprecated
496 public String loggedUserId() {
497 return null;
498 }
499
500 @Deprecated
501 public String existsReservation() {
502 return null;
503 }
504
505 @Deprecated
506 public String isFamilyOrPartnerOfSizeWithChildCount() {
507 return null;
508 }
509
510 @Deprecated
511 public String isAfterInCurrentYear() {
512 return null;
513 }
514
515 @Deprecated
516 public String isBeforeInCurrentYear() {
517 return null;
518 }
519
520 @Deprecated
521 public String hasUserNoActiveRegistrationInHisDefaultDepartment() {
522 return null;
523 }
524
525 @Deprecated
526 public String isAfter() {
527 return null;
528 }
529
530 @Deprecated
531 public String isBefore() {
532 return null;
533 }
534
535 @Deprecated
536 public String userAgeInCurrentYear() {
537 return null;
538 }
539
540 @Deprecated
541 public String hasUserActiveRegistrationInCurrentDepartment() {
542 return null;
543 }
544
545 @Deprecated
546 public String userDebt() {
547 return null;
548 }
549 }}}