package com.miniframe.model.es;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.List;

public class EsUnitSQLBuilder {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public EsUnitSQLBuilder() {
        oredCriteria = new ArrayList<Criteria>();
    }

    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<Criteria> 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<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> 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 andUtIdIsNull() {
            addCriterion("ut_id is null");
            return (Criteria) this;
        }

        public Criteria andUtIdIsNotNull() {
            addCriterion("ut_id is not null");
            return (Criteria) this;
        }

        public Criteria andUtIdEqualTo(String value) {
            addCriterion("ut_id =", value, "utId");
            return (Criteria) this;
        }

        public Criteria andUtIdNotEqualTo(String value) {
            addCriterion("ut_id <>", value, "utId");
            return (Criteria) this;
        }

        public Criteria andUtIdGreaterThan(String value) {
            addCriterion("ut_id >", value, "utId");
            return (Criteria) this;
        }

        public Criteria andUtIdGreaterThanOrEqualTo(String value) {
            addCriterion("ut_id >=", value, "utId");
            return (Criteria) this;
        }

        public Criteria andUtIdLessThan(String value) {
            addCriterion("ut_id <", value, "utId");
            return (Criteria) this;
        }

        public Criteria andUtIdLessThanOrEqualTo(String value) {
            addCriterion("ut_id <=", value, "utId");
            return (Criteria) this;
        }

        public Criteria andUtIdLike(String value) {
            addCriterion("ut_id like", value, "utId");
            return (Criteria) this;
        }

        public Criteria andUtIdNotLike(String value) {
            addCriterion("ut_id not like", value, "utId");
            return (Criteria) this;
        }

        public Criteria andUtIdIn(List<String> values) {
            addCriterion("ut_id in", values, "utId");
            return (Criteria) this;
        }

        public Criteria andUtIdNotIn(List<String> values) {
            addCriterion("ut_id not in", values, "utId");
            return (Criteria) this;
        }

        public Criteria andUtIdBetween(String value1, String value2) {
            addCriterion("ut_id between", value1, value2, "utId");
            return (Criteria) this;
        }

        public Criteria andUtIdNotBetween(String value1, String value2) {
            addCriterion("ut_id not between", value1, value2, "utId");
            return (Criteria) this;
        }

        public Criteria andGutIdIsNull() {
            addCriterion("gut_id is null");
            return (Criteria) this;
        }

        public Criteria andGutIdIsNotNull() {
            addCriterion("gut_id is not null");
            return (Criteria) this;
        }

        public Criteria andGutIdEqualTo(String value) {
            addCriterion("gut_id =", value, "gutId");
            return (Criteria) this;
        }

        public Criteria andGutIdNotEqualTo(String value) {
            addCriterion("gut_id <>", value, "gutId");
            return (Criteria) this;
        }

        public Criteria andGutIdGreaterThan(String value) {
            addCriterion("gut_id >", value, "gutId");
            return (Criteria) this;
        }

        public Criteria andGutIdGreaterThanOrEqualTo(String value) {
            addCriterion("gut_id >=", value, "gutId");
            return (Criteria) this;
        }

        public Criteria andGutIdLessThan(String value) {
            addCriterion("gut_id <", value, "gutId");
            return (Criteria) this;
        }

        public Criteria andGutIdLessThanOrEqualTo(String value) {
            addCriterion("gut_id <=", value, "gutId");
            return (Criteria) this;
        }

        public Criteria andGutIdLike(String value) {
            addCriterion("gut_id like", value, "gutId");
            return (Criteria) this;
        }

        public Criteria andGutIdNotLike(String value) {
            addCriterion("gut_id not like", value, "gutId");
            return (Criteria) this;
        }

        public Criteria andGutIdIn(List<String> values) {
            addCriterion("gut_id in", values, "gutId");
            return (Criteria) this;
        }

        public Criteria andGutIdNotIn(List<String> values) {
            addCriterion("gut_id not in", values, "gutId");
            return (Criteria) this;
        }

        public Criteria andGutIdBetween(String value1, String value2) {
            addCriterion("gut_id between", value1, value2, "gutId");
            return (Criteria) this;
        }

        public Criteria andGutIdNotBetween(String value1, String value2) {
            addCriterion("gut_id not between", value1, value2, "gutId");
            return (Criteria) this;
        }

        public Criteria andNameZhIsNull() {
            addCriterion("name_zh is null");
            return (Criteria) this;
        }

        public Criteria andNameZhIsNotNull() {
            addCriterion("name_zh is not null");
            return (Criteria) this;
        }

        public Criteria andNameZhEqualTo(String value) {
            addCriterion("name_zh =", value, "nameZh");
            return (Criteria) this;
        }

        public Criteria andNameZhNotEqualTo(String value) {
            addCriterion("name_zh <>", value, "nameZh");
            return (Criteria) this;
        }

        public Criteria andNameZhGreaterThan(String value) {
            addCriterion("name_zh >", value, "nameZh");
            return (Criteria) this;
        }

        public Criteria andNameZhGreaterThanOrEqualTo(String value) {
            addCriterion("name_zh >=", value, "nameZh");
            return (Criteria) this;
        }

        public Criteria andNameZhLessThan(String value) {
            addCriterion("name_zh <", value, "nameZh");
            return (Criteria) this;
        }

        public Criteria andNameZhLessThanOrEqualTo(String value) {
            addCriterion("name_zh <=", value, "nameZh");
            return (Criteria) this;
        }

        public Criteria andNameZhLike(String value) {
            addCriterion("name_zh like", value, "nameZh");
            return (Criteria) this;
        }

        public Criteria andNameZhNotLike(String value) {
            addCriterion("name_zh not like", value, "nameZh");
            return (Criteria) this;
        }

        public Criteria andNameZhIn(List<String> values) {
            addCriterion("name_zh in", values, "nameZh");
            return (Criteria) this;
        }

        public Criteria andNameZhNotIn(List<String> values) {
            addCriterion("name_zh not in", values, "nameZh");
            return (Criteria) this;
        }

        public Criteria andNameZhBetween(String value1, String value2) {
            addCriterion("name_zh between", value1, value2, "nameZh");
            return (Criteria) this;
        }

        public Criteria andNameZhNotBetween(String value1, String value2) {
            addCriterion("name_zh not between", value1, value2, "nameZh");
            return (Criteria) this;
        }

        public Criteria andNameEnIsNull() {
            addCriterion("name_en is null");
            return (Criteria) this;
        }

        public Criteria andNameEnIsNotNull() {
            addCriterion("name_en is not null");
            return (Criteria) this;
        }

        public Criteria andNameEnEqualTo(String value) {
            addCriterion("name_en =", value, "nameEn");
            return (Criteria) this;
        }

        public Criteria andNameEnNotEqualTo(String value) {
            addCriterion("name_en <>", value, "nameEn");
            return (Criteria) this;
        }

        public Criteria andNameEnGreaterThan(String value) {
            addCriterion("name_en >", value, "nameEn");
            return (Criteria) this;
        }

        public Criteria andNameEnGreaterThanOrEqualTo(String value) {
            addCriterion("name_en >=", value, "nameEn");
            return (Criteria) this;
        }

        public Criteria andNameEnLessThan(String value) {
            addCriterion("name_en <", value, "nameEn");
            return (Criteria) this;
        }

        public Criteria andNameEnLessThanOrEqualTo(String value) {
            addCriterion("name_en <=", value, "nameEn");
            return (Criteria) this;
        }

        public Criteria andNameEnLike(String value) {
            addCriterion("name_en like", value, "nameEn");
            return (Criteria) this;
        }

        public Criteria andNameEnNotLike(String value) {
            addCriterion("name_en not like", value, "nameEn");
            return (Criteria) this;
        }

        public Criteria andNameEnIn(List<String> values) {
            addCriterion("name_en in", values, "nameEn");
            return (Criteria) this;
        }

        public Criteria andNameEnNotIn(List<String> values) {
            addCriterion("name_en not in", values, "nameEn");
            return (Criteria) this;
        }

        public Criteria andNameEnBetween(String value1, String value2) {
            addCriterion("name_en between", value1, value2, "nameEn");
            return (Criteria) this;
        }

        public Criteria andNameEnNotBetween(String value1, String value2) {
            addCriterion("name_en not between", value1, value2, "nameEn");
            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(String value) {
            addCriterion("value =", value, "value");
            return (Criteria) this;
        }

        public Criteria andValueNotEqualTo(String value) {
            addCriterion("value <>", value, "value");
            return (Criteria) this;
        }

        public Criteria andValueGreaterThan(String value) {
            addCriterion("value >", value, "value");
            return (Criteria) this;
        }

        public Criteria andValueGreaterThanOrEqualTo(String value) {
            addCriterion("value >=", value, "value");
            return (Criteria) this;
        }

        public Criteria andValueLessThan(String value) {
            addCriterion("value <", value, "value");
            return (Criteria) this;
        }

        public Criteria andValueLessThanOrEqualTo(String value) {
            addCriterion("value <=", value, "value");
            return (Criteria) this;
        }

        public Criteria andValueLike(String value) {
            addCriterion("value like", value, "value");
            return (Criteria) this;
        }

        public Criteria andValueNotLike(String value) {
            addCriterion("value not like", value, "value");
            return (Criteria) this;
        }

        public Criteria andValueIn(List<String> values) {
            addCriterion("value in", values, "value");
            return (Criteria) this;
        }

        public Criteria andValueNotIn(List<String> values) {
            addCriterion("value not in", values, "value");
            return (Criteria) this;
        }

        public Criteria andValueBetween(String value1, String value2) {
            addCriterion("value between", value1, value2, "value");
            return (Criteria) this;
        }

        public Criteria andValueNotBetween(String value1, String value2) {
            addCriterion("value not between", value1, value2, "value");
            return (Criteria) this;
        }

        public Criteria andFactorIsNull() {
            addCriterion("factor is null");
            return (Criteria) this;
        }

        public Criteria andFactorIsNotNull() {
            addCriterion("factor is not null");
            return (Criteria) this;
        }

        public Criteria andFactorEqualTo(BigDecimal value) {
            addCriterion("factor =", value, "factor");
            return (Criteria) this;
        }

        public Criteria andFactorNotEqualTo(BigDecimal value) {
            addCriterion("factor <>", value, "factor");
            return (Criteria) this;
        }

        public Criteria andFactorGreaterThan(BigDecimal value) {
            addCriterion("factor >", value, "factor");
            return (Criteria) this;
        }

        public Criteria andFactorGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("factor >=", value, "factor");
            return (Criteria) this;
        }

        public Criteria andFactorLessThan(BigDecimal value) {
            addCriterion("factor <", value, "factor");
            return (Criteria) this;
        }

        public Criteria andFactorLessThanOrEqualTo(BigDecimal value) {
            addCriterion("factor <=", value, "factor");
            return (Criteria) this;
        }

        public Criteria andFactorIn(List<BigDecimal> values) {
            addCriterion("factor in", values, "factor");
            return (Criteria) this;
        }

        public Criteria andFactorNotIn(List<BigDecimal> values) {
            addCriterion("factor not in", values, "factor");
            return (Criteria) this;
        }

        public Criteria andFactorBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("factor between", value1, value2, "factor");
            return (Criteria) this;
        }

        public Criteria andFactorNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("factor not between", value1, value2, "factor");
            return (Criteria) this;
        }

        public Criteria andUtOffsetIsNull() {
            addCriterion("ut_offset is null");
            return (Criteria) this;
        }

        public Criteria andUtOffsetIsNotNull() {
            addCriterion("ut_offset is not null");
            return (Criteria) this;
        }

        public Criteria andUtOffsetEqualTo(BigDecimal value) {
            addCriterion("ut_offset =", value, "utOffset");
            return (Criteria) this;
        }

        public Criteria andUtOffsetNotEqualTo(BigDecimal value) {
            addCriterion("ut_offset <>", value, "utOffset");
            return (Criteria) this;
        }

        public Criteria andUtOffsetGreaterThan(BigDecimal value) {
            addCriterion("ut_offset >", value, "utOffset");
            return (Criteria) this;
        }

        public Criteria andUtOffsetGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("ut_offset >=", value, "utOffset");
            return (Criteria) this;
        }

        public Criteria andUtOffsetLessThan(BigDecimal value) {
            addCriterion("ut_offset <", value, "utOffset");
            return (Criteria) this;
        }

        public Criteria andUtOffsetLessThanOrEqualTo(BigDecimal value) {
            addCriterion("ut_offset <=", value, "utOffset");
            return (Criteria) this;
        }

        public Criteria andUtOffsetIn(List<BigDecimal> values) {
            addCriterion("ut_offset in", values, "utOffset");
            return (Criteria) this;
        }

        public Criteria andUtOffsetNotIn(List<BigDecimal> values) {
            addCriterion("ut_offset not in", values, "utOffset");
            return (Criteria) this;
        }

        public Criteria andUtOffsetBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ut_offset between", value1, value2, "utOffset");
            return (Criteria) this;
        }

        public Criteria andUtOffsetNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ut_offset not between", value1, value2, "utOffset");
            return (Criteria) this;
        }

        public Criteria andSerIsNull() {
            addCriterion("ser is null");
            return (Criteria) this;
        }

        public Criteria andSerIsNotNull() {
            addCriterion("ser is not null");
            return (Criteria) this;
        }

        public Criteria andSerEqualTo(Integer value) {
            addCriterion("ser =", value, "ser");
            return (Criteria) this;
        }

        public Criteria andSerNotEqualTo(Integer value) {
            addCriterion("ser <>", value, "ser");
            return (Criteria) this;
        }

        public Criteria andSerGreaterThan(Integer value) {
            addCriterion("ser >", value, "ser");
            return (Criteria) this;
        }

        public Criteria andSerGreaterThanOrEqualTo(Integer value) {
            addCriterion("ser >=", value, "ser");
            return (Criteria) this;
        }

        public Criteria andSerLessThan(Integer value) {
            addCriterion("ser <", value, "ser");
            return (Criteria) this;
        }

        public Criteria andSerLessThanOrEqualTo(Integer value) {
            addCriterion("ser <=", value, "ser");
            return (Criteria) this;
        }

        public Criteria andSerIn(List<Integer> values) {
            addCriterion("ser in", values, "ser");
            return (Criteria) this;
        }

        public Criteria andSerNotIn(List<Integer> values) {
            addCriterion("ser not in", values, "ser");
            return (Criteria) this;
        }

        public Criteria andSerBetween(Integer value1, Integer value2) {
            addCriterion("ser between", value1, value2, "ser");
            return (Criteria) this;
        }

        public Criteria andSerNotBetween(Integer value1, Integer value2) {
            addCriterion("ser not between", value1, value2, "ser");
            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);
        }
    }
}