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
| package org.jeecg.common.system.query;
|
| import org.jeecg.common.util.oConvertUtils;
|
| /**
| * Query 规则 常量
| * @Author Scott
| * @Date 2019年02月14日
| */
| 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","带加号等于"),
| // ------- 当前表单设计器内专用 -------
| /** 值为空 */
| EMPTY("EMPTY","empty","值为空"),
| /** 值不为空 */
| NOT_EMPTY("NOT_EMPTY","not_empty","值不为空"),
| /**查询规则 不包含*/
| NOT_IN("NOT_IN","not_in","不包含"),
| // ------- 当前表单设计器内专用 -------
| /**查询规则 多词模糊匹配*/
| LIKE_WITH_AND("LIKEWITHAND","like_with_and","多词模糊匹配————暂时未用上"),
| /**查询规则 自定义SQL片段*/
| SQL_RULES("USE_SQL_RULES","ext","自定义SQL片段"),
| /**查询规则 多词匹配*/
| ELE_MATCH("ELE_MATCH","elemMatch","多词匹配"),
| /**查询规则 范围查询*/
| RANGE("RANGE","range","范围查询");
|
| 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 String getValue() {
| return value;
| }
|
| public void setValue(String value) {
| this.value = value;
| }
|
| public String getMsg() {
| return msg;
| }
|
| public void setMsg(String msg) {
| this.msg = msg;
| }
|
| public String getCondition() {
| return condition;
| }
|
| public void setCondition(String condition) {
| this.condition = condition;
| }
|
| 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;
| }
| }
|
|
