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
| package org.jeecg.common.system.query;
|
| import lombok.Getter;
| import org.jeecg.common.util.oConvertUtils;
|
| /**
| * Query 规则 常量
| * @Author Scott
| * @Date 2019年02月14日
| */
| @Getter
| public enum QueryRuleEnum {
|
| /**查询规则 大于*/
| GT(">","gt","大于"),
| /**查询规则 大于等于*/
| GE(">=","ge","大于等于"),
| /**查询规则 小于*/
| LT("<","lt","小于"),
| /**查询规则 小于等于*/
| LE("<=","le","小于等于"),
| /**查询规则 等于*/
| EQ("=","eq","等于"),
| /**查询规则 不等于*/
| NE("!=","ne","不等于"),
| /**查询规则 包含*/
| IN("IN","in","包含"),
| /**查询规则 全模糊*/
| LIKE("LIKE","like","全模糊"),
| /**查询规则 左模糊*/
| LEFT_LIKE("LEFT_LIKE","left_like","左模糊"),
| /**查询规则 右模糊*/
| RIGHT_LIKE("RIGHT_LIKE","right_like","右模糊"),
| /**查询规则 带加号等于*/
| EQ_WITH_ADD("EQWITHADD","eq_with_add","带加号等于"),
| /**查询规则 多词模糊匹配*/
| LIKE_WITH_AND("LIKEWITHAND","like_with_and","多词模糊匹配————暂时未用上"),
| /**查询规则 自定义SQL片段*/
| SQL_RULES("USE_SQL_RULES","ext","自定义SQL片段");
|
| private String value;
|
| private String condition;
|
| private String msg;
|
| QueryRuleEnum(String value, String condition, String msg){
| this.value = value;
| this.condition = condition;
| this.msg = msg;
| }
|
| public static QueryRuleEnum getByValue(String value){
| if(oConvertUtils.isEmpty(value)) {
| return null;
| }
| for(QueryRuleEnum val :values()){
| if (val.getValue().equals(value) || val.getCondition().equals(value)){
| return val;
| }
| }
| return null;
| }
| }
|
|
