package com.miniframe.model.es; import java.math.BigDecimal; import java.util.ArrayList; import java.util.Date; import java.util.List; public class EsProResultValueSQLBuilder { protected String orderByClause; protected boolean distinct; protected List oredCriteria; public EsProResultValueSQLBuilder() { oredCriteria = new ArrayList(); } public void setOrderByClause(String orderByClause) { this.orderByClause = orderByClause; } public String getOrderByClause() { return orderByClause; } public void setDistinct(boolean distinct) { this.distinct = distinct; } public boolean isDistinct() { return distinct; } public List getOredCriteria() { return oredCriteria; } public void or(Criteria criteria) { oredCriteria.add(criteria); } public Criteria or() { Criteria criteria = createCriteriaInternal(); oredCriteria.add(criteria); return criteria; } public Criteria createCriteria() { Criteria criteria = createCriteriaInternal(); if (oredCriteria.size() == 0) { oredCriteria.add(criteria); } return criteria; } protected Criteria createCriteriaInternal() { Criteria criteria = new Criteria(); return criteria; } public void clear() { oredCriteria.clear(); orderByClause = null; distinct = false; } protected abstract static class GeneratedCriteria { protected List criteria; protected GeneratedCriteria() { super(); criteria = new ArrayList(); } public boolean isValid() { return criteria.size() > 0; } public List getAllCriteria() { return criteria; } public List getCriteria() { return criteria; } protected void addCriterion(String condition) { if (condition == null) { throw new RuntimeException("Value for condition cannot be null"); } criteria.add(new Criterion(condition)); } protected void addCriterion(String condition, Object value, String property) { if (value == null) { throw new RuntimeException("Value for " + property + " cannot be null"); } criteria.add(new Criterion(condition, value)); } protected void addCriterion(String condition, Object value1, Object value2, String property) { if (value1 == null || value2 == null) { throw new RuntimeException("Between values for " + property + " cannot be null"); } criteria.add(new Criterion(condition, value1, value2)); } public Criteria andPcrIdIsNull() { addCriterion("pcr_id is null"); return (Criteria) this; } public Criteria andPcrIdIsNotNull() { addCriterion("pcr_id is not null"); return (Criteria) this; } public Criteria andPcrIdEqualTo(String value) { addCriterion("pcr_id =", value, "pcrId"); return (Criteria) this; } public Criteria andPcrIdNotEqualTo(String value) { addCriterion("pcr_id <>", value, "pcrId"); return (Criteria) this; } public Criteria andPcrIdGreaterThan(String value) { addCriterion("pcr_id >", value, "pcrId"); return (Criteria) this; } public Criteria andPcrIdGreaterThanOrEqualTo(String value) { addCriterion("pcr_id >=", value, "pcrId"); return (Criteria) this; } public Criteria andPcrIdLessThan(String value) { addCriterion("pcr_id <", value, "pcrId"); return (Criteria) this; } public Criteria andPcrIdLessThanOrEqualTo(String value) { addCriterion("pcr_id <=", value, "pcrId"); return (Criteria) this; } public Criteria andPcrIdLike(String value) { addCriterion("pcr_id like", value, "pcrId"); return (Criteria) this; } public Criteria andPcrIdNotLike(String value) { addCriterion("pcr_id not like", value, "pcrId"); return (Criteria) this; } public Criteria andPcrIdIn(List values) { addCriterion("pcr_id in", values, "pcrId"); return (Criteria) this; } public Criteria andPcrIdNotIn(List values) { addCriterion("pcr_id not in", values, "pcrId"); return (Criteria) this; } public Criteria andPcrIdBetween(String value1, String value2) { addCriterion("pcr_id between", value1, value2, "pcrId"); return (Criteria) this; } public Criteria andPcrIdNotBetween(String value1, String value2) { addCriterion("pcr_id not between", value1, value2, "pcrId"); return (Criteria) this; } public Criteria andPidIsNull() { addCriterion("pid is null"); return (Criteria) this; } public Criteria andPidIsNotNull() { addCriterion("pid is not null"); return (Criteria) this; } public Criteria andPidEqualTo(String value) { addCriterion("pid =", value, "pid"); return (Criteria) this; } public Criteria andPidNotEqualTo(String value) { addCriterion("pid <>", value, "pid"); return (Criteria) this; } public Criteria andPidGreaterThan(String value) { addCriterion("pid >", value, "pid"); return (Criteria) this; } public Criteria andPidGreaterThanOrEqualTo(String value) { addCriterion("pid >=", value, "pid"); return (Criteria) this; } public Criteria andPidLessThan(String value) { addCriterion("pid <", value, "pid"); return (Criteria) this; } public Criteria andPidLessThanOrEqualTo(String value) { addCriterion("pid <=", value, "pid"); return (Criteria) this; } public Criteria andPidLike(String value) { addCriterion("pid like", value, "pid"); return (Criteria) this; } public Criteria andPidNotLike(String value) { addCriterion("pid not like", value, "pid"); return (Criteria) this; } public Criteria andPidIn(List values) { addCriterion("pid in", values, "pid"); return (Criteria) this; } public Criteria andPidNotIn(List values) { addCriterion("pid not in", values, "pid"); return (Criteria) this; } public Criteria andPidBetween(String value1, String value2) { addCriterion("pid between", value1, value2, "pid"); return (Criteria) this; } public Criteria andPidNotBetween(String value1, String value2) { addCriterion("pid not between", value1, value2, "pid"); return (Criteria) this; } public Criteria andComIdIsNull() { addCriterion("com_id is null"); return (Criteria) this; } public Criteria andComIdIsNotNull() { addCriterion("com_id is not null"); return (Criteria) this; } public Criteria andComIdEqualTo(String value) { addCriterion("com_id =", value, "comId"); return (Criteria) this; } public Criteria andComIdNotEqualTo(String value) { addCriterion("com_id <>", value, "comId"); return (Criteria) this; } public Criteria andComIdGreaterThan(String value) { addCriterion("com_id >", value, "comId"); return (Criteria) this; } public Criteria andComIdGreaterThanOrEqualTo(String value) { addCriterion("com_id >=", value, "comId"); return (Criteria) this; } public Criteria andComIdLessThan(String value) { addCriterion("com_id <", value, "comId"); return (Criteria) this; } public Criteria andComIdLessThanOrEqualTo(String value) { addCriterion("com_id <=", value, "comId"); return (Criteria) this; } public Criteria andComIdLike(String value) { addCriterion("com_id like", value, "comId"); return (Criteria) this; } public Criteria andComIdNotLike(String value) { addCriterion("com_id not like", value, "comId"); return (Criteria) this; } public Criteria andComIdIn(List values) { addCriterion("com_id in", values, "comId"); return (Criteria) this; } public Criteria andComIdNotIn(List values) { addCriterion("com_id not in", values, "comId"); return (Criteria) this; } public Criteria andComIdBetween(String value1, String value2) { addCriterion("com_id between", value1, value2, "comId"); return (Criteria) this; } public Criteria andComIdNotBetween(String value1, String value2) { addCriterion("com_id not between", value1, value2, "comId"); return (Criteria) this; } public Criteria andJobIdIsNull() { addCriterion("job_id is null"); return (Criteria) this; } public Criteria andJobIdIsNotNull() { addCriterion("job_id is not null"); return (Criteria) this; } public Criteria andJobIdEqualTo(String value) { addCriterion("job_id =", value, "jobId"); return (Criteria) this; } public Criteria andJobIdNotEqualTo(String value) { addCriterion("job_id <>", value, "jobId"); return (Criteria) this; } public Criteria andJobIdGreaterThan(String value) { addCriterion("job_id >", value, "jobId"); return (Criteria) this; } public Criteria andJobIdGreaterThanOrEqualTo(String value) { addCriterion("job_id >=", value, "jobId"); return (Criteria) this; } public Criteria andJobIdLessThan(String value) { addCriterion("job_id <", value, "jobId"); return (Criteria) this; } public Criteria andJobIdLessThanOrEqualTo(String value) { addCriterion("job_id <=", value, "jobId"); return (Criteria) this; } public Criteria andJobIdLike(String value) { addCriterion("job_id like", value, "jobId"); return (Criteria) this; } public Criteria andJobIdNotLike(String value) { addCriterion("job_id not like", value, "jobId"); return (Criteria) this; } public Criteria andJobIdIn(List values) { addCriterion("job_id in", values, "jobId"); return (Criteria) this; } public Criteria andJobIdNotIn(List values) { addCriterion("job_id not in", values, "jobId"); return (Criteria) this; } public Criteria andJobIdBetween(String value1, String value2) { addCriterion("job_id between", value1, value2, "jobId"); return (Criteria) this; } public Criteria andJobIdNotBetween(String value1, String value2) { addCriterion("job_id not between", value1, value2, "jobId"); return (Criteria) this; } public Criteria andValueIsNull() { addCriterion("value is null"); return (Criteria) this; } public Criteria andValueIsNotNull() { addCriterion("value is not null"); return (Criteria) this; } public Criteria andValueEqualTo(BigDecimal value) { addCriterion("value =", value, "value"); return (Criteria) this; } public Criteria andValueNotEqualTo(BigDecimal value) { addCriterion("value <>", value, "value"); return (Criteria) this; } public Criteria andValueGreaterThan(BigDecimal value) { addCriterion("value >", value, "value"); return (Criteria) this; } public Criteria andValueGreaterThanOrEqualTo(BigDecimal value) { addCriterion("value >=", value, "value"); return (Criteria) this; } public Criteria andValueLessThan(BigDecimal value) { addCriterion("value <", value, "value"); return (Criteria) this; } public Criteria andValueLessThanOrEqualTo(BigDecimal value) { addCriterion("value <=", value, "value"); return (Criteria) this; } public Criteria andValueIn(List values) { addCriterion("value in", values, "value"); return (Criteria) this; } public Criteria andValueNotIn(List values) { addCriterion("value not in", values, "value"); return (Criteria) this; } public Criteria andValueBetween(BigDecimal value1, BigDecimal value2) { addCriterion("value between", value1, value2, "value"); return (Criteria) this; } public Criteria andValueNotBetween(BigDecimal value1, BigDecimal value2) { addCriterion("value not between", value1, value2, "value"); return (Criteria) this; } public Criteria andUidIsNull() { addCriterion("uid is null"); return (Criteria) this; } public Criteria andUidIsNotNull() { addCriterion("uid is not null"); return (Criteria) this; } public Criteria andUidEqualTo(String value) { addCriterion("uid =", value, "uid"); return (Criteria) this; } public Criteria andUidNotEqualTo(String value) { addCriterion("uid <>", value, "uid"); return (Criteria) this; } public Criteria andUidGreaterThan(String value) { addCriterion("uid >", value, "uid"); return (Criteria) this; } public Criteria andUidGreaterThanOrEqualTo(String value) { addCriterion("uid >=", value, "uid"); return (Criteria) this; } public Criteria andUidLessThan(String value) { addCriterion("uid <", value, "uid"); return (Criteria) this; } public Criteria andUidLessThanOrEqualTo(String value) { addCriterion("uid <=", value, "uid"); return (Criteria) this; } public Criteria andUidLike(String value) { addCriterion("uid like", value, "uid"); return (Criteria) this; } public Criteria andUidNotLike(String value) { addCriterion("uid not like", value, "uid"); return (Criteria) this; } public Criteria andUidIn(List values) { addCriterion("uid in", values, "uid"); return (Criteria) this; } public Criteria andUidNotIn(List values) { addCriterion("uid not in", values, "uid"); return (Criteria) this; } public Criteria andUidBetween(String value1, String value2) { addCriterion("uid between", value1, value2, "uid"); return (Criteria) this; } public Criteria andUidNotBetween(String value1, String value2) { addCriterion("uid not between", value1, value2, "uid"); return (Criteria) this; } public Criteria andCreateTimeIsNull() { addCriterion("create_time is null"); return (Criteria) this; } public Criteria andCreateTimeIsNotNull() { addCriterion("create_time is not null"); return (Criteria) this; } public Criteria andCreateTimeEqualTo(Date value) { addCriterion("create_time =", value, "createTime"); return (Criteria) this; } public Criteria andCreateTimeNotEqualTo(Date value) { addCriterion("create_time <>", value, "createTime"); return (Criteria) this; } public Criteria andCreateTimeGreaterThan(Date value) { addCriterion("create_time >", value, "createTime"); return (Criteria) this; } public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) { addCriterion("create_time >=", value, "createTime"); return (Criteria) this; } public Criteria andCreateTimeLessThan(Date value) { addCriterion("create_time <", value, "createTime"); return (Criteria) this; } public Criteria andCreateTimeLessThanOrEqualTo(Date value) { addCriterion("create_time <=", value, "createTime"); return (Criteria) this; } public Criteria andCreateTimeIn(List values) { addCriterion("create_time in", values, "createTime"); return (Criteria) this; } public Criteria andCreateTimeNotIn(List values) { addCriterion("create_time not in", values, "createTime"); return (Criteria) this; } public Criteria andCreateTimeBetween(Date value1, Date value2) { addCriterion("create_time between", value1, value2, "createTime"); return (Criteria) this; } public Criteria andCreateTimeNotBetween(Date value1, Date value2) { addCriterion("create_time not between", value1, value2, "createTime"); return (Criteria) this; } public Criteria andUpdateTimeIsNull() { addCriterion("update_time is null"); return (Criteria) this; } public Criteria andUpdateTimeIsNotNull() { addCriterion("update_time is not null"); return (Criteria) this; } public Criteria andUpdateTimeEqualTo(Date value) { addCriterion("update_time =", value, "updateTime"); return (Criteria) this; } public Criteria andUpdateTimeNotEqualTo(Date value) { addCriterion("update_time <>", value, "updateTime"); return (Criteria) this; } public Criteria andUpdateTimeGreaterThan(Date value) { addCriterion("update_time >", value, "updateTime"); return (Criteria) this; } public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) { addCriterion("update_time >=", value, "updateTime"); return (Criteria) this; } public Criteria andUpdateTimeLessThan(Date value) { addCriterion("update_time <", value, "updateTime"); return (Criteria) this; } public Criteria andUpdateTimeLessThanOrEqualTo(Date value) { addCriterion("update_time <=", value, "updateTime"); return (Criteria) this; } public Criteria andUpdateTimeIn(List values) { addCriterion("update_time in", values, "updateTime"); return (Criteria) this; } public Criteria andUpdateTimeNotIn(List values) { addCriterion("update_time not in", values, "updateTime"); return (Criteria) this; } public Criteria andUpdateTimeBetween(Date value1, Date value2) { addCriterion("update_time between", value1, value2, "updateTime"); return (Criteria) this; } public Criteria andUpdateTimeNotBetween(Date value1, Date value2) { addCriterion("update_time not between", value1, value2, "updateTime"); return (Criteria) this; } public Criteria andRemarkIsNull() { addCriterion("remark is null"); return (Criteria) this; } public Criteria andRemarkIsNotNull() { addCriterion("remark is not null"); return (Criteria) this; } public Criteria andRemarkEqualTo(String value) { addCriterion("remark =", value, "remark"); return (Criteria) this; } public Criteria andRemarkNotEqualTo(String value) { addCriterion("remark <>", value, "remark"); return (Criteria) this; } public Criteria andRemarkGreaterThan(String value) { addCriterion("remark >", value, "remark"); return (Criteria) this; } public Criteria andRemarkGreaterThanOrEqualTo(String value) { addCriterion("remark >=", value, "remark"); return (Criteria) this; } public Criteria andRemarkLessThan(String value) { addCriterion("remark <", value, "remark"); return (Criteria) this; } public Criteria andRemarkLessThanOrEqualTo(String value) { addCriterion("remark <=", value, "remark"); return (Criteria) this; } public Criteria andRemarkLike(String value) { addCriterion("remark like", value, "remark"); return (Criteria) this; } public Criteria andRemarkNotLike(String value) { addCriterion("remark not like", value, "remark"); return (Criteria) this; } public Criteria andRemarkIn(List values) { addCriterion("remark in", values, "remark"); return (Criteria) this; } public Criteria andRemarkNotIn(List values) { addCriterion("remark not in", values, "remark"); return (Criteria) this; } public Criteria andRemarkBetween(String value1, String value2) { addCriterion("remark between", value1, value2, "remark"); return (Criteria) this; } public Criteria andRemarkNotBetween(String value1, String value2) { addCriterion("remark not between", value1, value2, "remark"); return (Criteria) this; } public Criteria andStepIsNull() { addCriterion("step is null"); return (Criteria) this; } public Criteria andStepIsNotNull() { addCriterion("step is not null"); return (Criteria) this; } public Criteria andStepEqualTo(Integer value) { addCriterion("step =", value, "step"); return (Criteria) this; } public Criteria andStepNotEqualTo(Integer value) { addCriterion("step <>", value, "step"); return (Criteria) this; } public Criteria andStepGreaterThan(Integer value) { addCriterion("step >", value, "step"); return (Criteria) this; } public Criteria andStepGreaterThanOrEqualTo(Integer value) { addCriterion("step >=", value, "step"); return (Criteria) this; } public Criteria andStepLessThan(Integer value) { addCriterion("step <", value, "step"); return (Criteria) this; } public Criteria andStepLessThanOrEqualTo(Integer value) { addCriterion("step <=", value, "step"); return (Criteria) this; } public Criteria andStepIn(List values) { addCriterion("step in", values, "step"); return (Criteria) this; } public Criteria andStepNotIn(List values) { addCriterion("step not in", values, "step"); return (Criteria) this; } public Criteria andStepBetween(Integer value1, Integer value2) { addCriterion("step between", value1, value2, "step"); return (Criteria) this; } public Criteria andStepNotBetween(Integer value1, Integer value2) { addCriterion("step not between", value1, value2, "step"); return (Criteria) this; } } public static class Criteria extends GeneratedCriteria { protected Criteria() { super(); } } public static class Criterion { private String condition; private Object value; private Object secondValue; private boolean noValue; private boolean singleValue; private boolean betweenValue; private boolean listValue; private String typeHandler; public String getCondition() { return condition; } public Object getValue() { return value; } public Object getSecondValue() { return secondValue; } public boolean isNoValue() { return noValue; } public boolean isSingleValue() { return singleValue; } public boolean isBetweenValue() { return betweenValue; } public boolean isListValue() { return listValue; } public String getTypeHandler() { return typeHandler; } protected Criterion(String condition) { super(); this.condition = condition; this.typeHandler = null; this.noValue = true; } protected Criterion(String condition, Object value, String typeHandler) { super(); this.condition = condition; this.value = value; this.typeHandler = typeHandler; if (value instanceof List) { this.listValue = true; } else { this.singleValue = true; } } protected Criterion(String condition, Object value) { this(condition, value, null); } protected Criterion(String condition, Object value, Object secondValue, String typeHandler) { super(); this.condition = condition; this.value = value; this.secondValue = secondValue; this.typeHandler = typeHandler; this.betweenValue = true; } protected Criterion(String condition, Object value, Object secondValue) { this(condition, value, secondValue, null); } } }