583fda2677aed857b5d72cef2776604816b2d42c.svn-base 1.7 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273
  1. package org.jeecg.common.system.query;
  2. import org.jeecg.common.util.oConvertUtils;
  3. /**
  4. * Query 规则 常量
  5. * @Author Scott
  6. * @Date 2019年02月14日
  7. */
  8. public enum QueryRuleEnum {
  9. GT(">","gt","大于"),
  10. GE(">=","ge","大于等于"),
  11. LT("<","lt","小于"),
  12. LE("<=","le","小于等于"),
  13. EQ("=","eq","等于"),
  14. NE("!=","ne","不等于"),
  15. IN("IN","in","包含"),
  16. LIKE("LIKE","like","全模糊"),
  17. LEFT_LIKE("LEFT_LIKE","left_like","左模糊"),
  18. RIGHT_LIKE("RIGHT_LIKE","right_like","右模糊"),
  19. EQ_WITH_ADD("EQWITHADD","eq_with_add","带加号等于"),
  20. LIKE_WITH_AND("LIKEWITHAND","like_with_and","多词模糊匹配————暂时未用上"),
  21. SQL_RULES("USE_SQL_RULES","ext","自定义SQL片段");
  22. private String value;
  23. private String condition;
  24. private String msg;
  25. QueryRuleEnum(String value, String condition, String msg){
  26. this.value = value;
  27. this.condition = condition;
  28. this.msg = msg;
  29. }
  30. public String getValue() {
  31. return value;
  32. }
  33. public void setValue(String value) {
  34. this.value = value;
  35. }
  36. public String getMsg() {
  37. return msg;
  38. }
  39. public void setMsg(String msg) {
  40. this.msg = msg;
  41. }
  42. public String getCondition() {
  43. return condition;
  44. }
  45. public void setCondition(String condition) {
  46. this.condition = condition;
  47. }
  48. public static QueryRuleEnum getByValue(String value){
  49. if(oConvertUtils.isEmpty(value)) {
  50. return null;
  51. }
  52. for(QueryRuleEnum val :values()){
  53. if (val.getValue().equals(value) || val.getCondition().equals(value)){
  54. return val;
  55. }
  56. }
  57. return null;
  58. }
  59. }