package com.bailuntec.domain.example;

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

public class DcAutoTurnoverAirExample {
    /**
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database table dc_auto_turnover_air
     *
     * @mbg.generated
     */
    protected String orderByClause;

    /**
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database table dc_auto_turnover_air
     *
     * @mbg.generated
     */
    protected boolean distinct;

    /**
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database table dc_auto_turnover_air
     *
     * @mbg.generated
     */
    protected List<Criteria> oredCriteria;

    /**
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database table dc_auto_turnover_air
     *
     * @mbg.generated
     * @project https://github.com/itfsw/mybatis-generator-plugin
     */
    protected Integer offset;

    /**
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database table dc_auto_turnover_air
     *
     * @mbg.generated
     * @project https://github.com/itfsw/mybatis-generator-plugin
     */
    protected Integer rows;

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_auto_turnover_air
     *
     * @mbg.generated
     */
    public DcAutoTurnoverAirExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_auto_turnover_air
     *
     * @mbg.generated
     */
    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_auto_turnover_air
     *
     * @mbg.generated
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_auto_turnover_air
     *
     * @mbg.generated
     */
    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_auto_turnover_air
     *
     * @mbg.generated
     */
    public boolean isDistinct() {
        return distinct;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_auto_turnover_air
     *
     * @mbg.generated
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_auto_turnover_air
     *
     * @mbg.generated
     */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_auto_turnover_air
     *
     * @mbg.generated
     */
    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_auto_turnover_air
     *
     * @mbg.generated
     * @project https://github.com/itfsw/mybatis-generator-plugin
     */
    public DcAutoTurnoverAirExample orderBy(String orderByClause) {
        this.setOrderByClause(orderByClause);
        return this;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_auto_turnover_air
     *
     * @mbg.generated
     * @project https://github.com/itfsw/mybatis-generator-plugin
     */
    public DcAutoTurnoverAirExample orderBy(String ... orderByClauses) {
        StringBuffer sb = new StringBuffer();
        for (int i = 0; i < orderByClauses.length; i++) {
            sb.append(orderByClauses[i]);
            if (i < orderByClauses.length - 1) {
                sb.append(" , ");
            }
        }
        this.setOrderByClause(sb.toString());
        return this;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_auto_turnover_air
     *
     * @mbg.generated
     */
    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_auto_turnover_air
     *
     * @mbg.generated
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria(this);
        return criteria;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_auto_turnover_air
     *
     * @mbg.generated
     */
    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
        rows = null;
        offset = null;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_auto_turnover_air
     *
     * @mbg.generated
     * @project https://github.com/itfsw/mybatis-generator-plugin
     */
    public static Criteria newAndCreateCriteria() {
        DcAutoTurnoverAirExample example = new DcAutoTurnoverAirExample();
        return example.createCriteria();
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_auto_turnover_air
     *
     * @mbg.generated
     * @project https://github.com/itfsw/mybatis-generator-plugin
     */
    public DcAutoTurnoverAirExample when(boolean condition, IExampleWhen then) {
        if (condition) {
            then.example(this);
        }
        return this;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_auto_turnover_air
     *
     * @mbg.generated
     * @project https://github.com/itfsw/mybatis-generator-plugin
     */
    public DcAutoTurnoverAirExample when(boolean condition, IExampleWhen then, IExampleWhen otherwise) {
        if (condition) {
            then.example(this);
        } else {
            otherwise.example(this);
        }
        return this;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_auto_turnover_air
     *
     * @mbg.generated
     * @project https://github.com/itfsw/mybatis-generator-plugin
     */
    public void setOffset(Integer offset) {
        this.offset = offset;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_auto_turnover_air
     *
     * @mbg.generated
     * @project https://github.com/itfsw/mybatis-generator-plugin
     */
    public Integer getOffset() {
        return this.offset;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_auto_turnover_air
     *
     * @mbg.generated
     * @project https://github.com/itfsw/mybatis-generator-plugin
     */
    public void setRows(Integer rows) {
        this.rows = rows;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_auto_turnover_air
     *
     * @mbg.generated
     * @project https://github.com/itfsw/mybatis-generator-plugin
     */
    public Integer getRows() {
        return this.rows;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_auto_turnover_air
     *
     * @mbg.generated
     * @project https://github.com/itfsw/mybatis-generator-plugin
     */
    public DcAutoTurnoverAirExample limit(Integer rows) {
        this.rows = rows;
        return this;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_auto_turnover_air
     *
     * @mbg.generated
     * @project https://github.com/itfsw/mybatis-generator-plugin
     */
    public DcAutoTurnoverAirExample limit(Integer offset, Integer rows) {
        this.offset = offset;
        this.rows = rows;
        return this;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_auto_turnover_air
     *
     * @mbg.generated
     * @project https://github.com/itfsw/mybatis-generator-plugin
     */
    public DcAutoTurnoverAirExample page(Integer page, Integer pageSize) {
        this.offset = page * pageSize;
        this.rows = pageSize;
        return this;
    }

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table dc_auto_turnover_air
     *
     * @mbg.generated
     */
    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 andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

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

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

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

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

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

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

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

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

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andPurchaseAdviceIdIsNull() {
            addCriterion("purchase_advice_id is null");
            return (Criteria) this;
        }

        public Criteria andPurchaseAdviceIdIsNotNull() {
            addCriterion("purchase_advice_id is not null");
            return (Criteria) this;
        }

        public Criteria andPurchaseAdviceIdEqualTo(String value) {
            addCriterion("purchase_advice_id =", value, "purchaseAdviceId");
            return (Criteria) this;
        }

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

        public Criteria andPurchaseAdviceIdGreaterThan(String value) {
            addCriterion("purchase_advice_id >", value, "purchaseAdviceId");
            return (Criteria) this;
        }

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

        public Criteria andPurchaseAdviceIdLessThan(String value) {
            addCriterion("purchase_advice_id <", value, "purchaseAdviceId");
            return (Criteria) this;
        }

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

        public Criteria andPurchaseAdviceIdLike(String value) {
            addCriterion("purchase_advice_id like", value, "purchaseAdviceId");
            return (Criteria) this;
        }

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

        public Criteria andPurchaseAdviceIdIn(List<String> values) {
            addCriterion("purchase_advice_id in", values, "purchaseAdviceId");
            return (Criteria) this;
        }

        public Criteria andPurchaseAdviceIdNotIn(List<String> values) {
            addCriterion("purchase_advice_id not in", values, "purchaseAdviceId");
            return (Criteria) this;
        }

        public Criteria andPurchaseAdviceIdBetween(String value1, String value2) {
            addCriterion("purchase_advice_id between", value1, value2, "purchaseAdviceId");
            return (Criteria) this;
        }

        public Criteria andPurchaseAdviceIdNotBetween(String value1, String value2) {
            addCriterion("purchase_advice_id not between", value1, value2, "purchaseAdviceId");
            return (Criteria) this;
        }

        public Criteria andBailunSkuIsNull() {
            addCriterion("bailun_sku is null");
            return (Criteria) this;
        }

        public Criteria andBailunSkuIsNotNull() {
            addCriterion("bailun_sku is not null");
            return (Criteria) this;
        }

        public Criteria andBailunSkuEqualTo(String value) {
            addCriterion("bailun_sku =", value, "bailunSku");
            return (Criteria) this;
        }

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

        public Criteria andBailunSkuGreaterThan(String value) {
            addCriterion("bailun_sku >", value, "bailunSku");
            return (Criteria) this;
        }

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

        public Criteria andBailunSkuLessThan(String value) {
            addCriterion("bailun_sku <", value, "bailunSku");
            return (Criteria) this;
        }

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

        public Criteria andBailunSkuLike(String value) {
            addCriterion("bailun_sku like", value, "bailunSku");
            return (Criteria) this;
        }

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

        public Criteria andBailunSkuIn(List<String> values) {
            addCriterion("bailun_sku in", values, "bailunSku");
            return (Criteria) this;
        }

        public Criteria andBailunSkuNotIn(List<String> values) {
            addCriterion("bailun_sku not in", values, "bailunSku");
            return (Criteria) this;
        }

        public Criteria andBailunSkuBetween(String value1, String value2) {
            addCriterion("bailun_sku between", value1, value2, "bailunSku");
            return (Criteria) this;
        }

        public Criteria andBailunSkuNotBetween(String value1, String value2) {
            addCriterion("bailun_sku not between", value1, value2, "bailunSku");
            return (Criteria) this;
        }

        public Criteria andWarehouseCodeIsNull() {
            addCriterion("warehouse_code is null");
            return (Criteria) this;
        }

        public Criteria andWarehouseCodeIsNotNull() {
            addCriterion("warehouse_code is not null");
            return (Criteria) this;
        }

        public Criteria andWarehouseCodeEqualTo(String value) {
            addCriterion("warehouse_code =", value, "warehouseCode");
            return (Criteria) this;
        }

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

        public Criteria andWarehouseCodeGreaterThan(String value) {
            addCriterion("warehouse_code >", value, "warehouseCode");
            return (Criteria) this;
        }

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

        public Criteria andWarehouseCodeLessThan(String value) {
            addCriterion("warehouse_code <", value, "warehouseCode");
            return (Criteria) this;
        }

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

        public Criteria andWarehouseCodeLike(String value) {
            addCriterion("warehouse_code like", value, "warehouseCode");
            return (Criteria) this;
        }

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

        public Criteria andWarehouseCodeIn(List<String> values) {
            addCriterion("warehouse_code in", values, "warehouseCode");
            return (Criteria) this;
        }

        public Criteria andWarehouseCodeNotIn(List<String> values) {
            addCriterion("warehouse_code not in", values, "warehouseCode");
            return (Criteria) this;
        }

        public Criteria andWarehouseCodeBetween(String value1, String value2) {
            addCriterion("warehouse_code between", value1, value2, "warehouseCode");
            return (Criteria) this;
        }

        public Criteria andWarehouseCodeNotBetween(String value1, String value2) {
            addCriterion("warehouse_code not between", value1, value2, "warehouseCode");
            return (Criteria) this;
        }

        public Criteria andQuantityInitAdviseIsNull() {
            addCriterion("quantity_init_advise is null");
            return (Criteria) this;
        }

        public Criteria andQuantityInitAdviseIsNotNull() {
            addCriterion("quantity_init_advise is not null");
            return (Criteria) this;
        }

        public Criteria andQuantityInitAdviseEqualTo(BigDecimal value) {
            addCriterion("quantity_init_advise =", value, "quantityInitAdvise");
            return (Criteria) this;
        }

        public Criteria andQuantityInitAdviseNotEqualTo(BigDecimal value) {
            addCriterion("quantity_init_advise <>", value, "quantityInitAdvise");
            return (Criteria) this;
        }

        public Criteria andQuantityInitAdviseGreaterThan(BigDecimal value) {
            addCriterion("quantity_init_advise >", value, "quantityInitAdvise");
            return (Criteria) this;
        }

        public Criteria andQuantityInitAdviseGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("quantity_init_advise >=", value, "quantityInitAdvise");
            return (Criteria) this;
        }

        public Criteria andQuantityInitAdviseLessThan(BigDecimal value) {
            addCriterion("quantity_init_advise <", value, "quantityInitAdvise");
            return (Criteria) this;
        }

        public Criteria andQuantityInitAdviseLessThanOrEqualTo(BigDecimal value) {
            addCriterion("quantity_init_advise <=", value, "quantityInitAdvise");
            return (Criteria) this;
        }

        public Criteria andQuantityInitAdviseIn(List<BigDecimal> values) {
            addCriterion("quantity_init_advise in", values, "quantityInitAdvise");
            return (Criteria) this;
        }

        public Criteria andQuantityInitAdviseNotIn(List<BigDecimal> values) {
            addCriterion("quantity_init_advise not in", values, "quantityInitAdvise");
            return (Criteria) this;
        }

        public Criteria andQuantityInitAdviseBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("quantity_init_advise between", value1, value2, "quantityInitAdvise");
            return (Criteria) this;
        }

        public Criteria andQuantityInitAdviseNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("quantity_init_advise not between", value1, value2, "quantityInitAdvise");
            return (Criteria) this;
        }

        public Criteria andQuantityMinimumOrderIsNull() {
            addCriterion("quantity_minimum_order is null");
            return (Criteria) this;
        }

        public Criteria andQuantityMinimumOrderIsNotNull() {
            addCriterion("quantity_minimum_order is not null");
            return (Criteria) this;
        }

        public Criteria andQuantityMinimumOrderEqualTo(Integer value) {
            addCriterion("quantity_minimum_order =", value, "quantityMinimumOrder");
            return (Criteria) this;
        }

        public Criteria andQuantityMinimumOrderNotEqualTo(Integer value) {
            addCriterion("quantity_minimum_order <>", value, "quantityMinimumOrder");
            return (Criteria) this;
        }

        public Criteria andQuantityMinimumOrderGreaterThan(Integer value) {
            addCriterion("quantity_minimum_order >", value, "quantityMinimumOrder");
            return (Criteria) this;
        }

        public Criteria andQuantityMinimumOrderGreaterThanOrEqualTo(Integer value) {
            addCriterion("quantity_minimum_order >=", value, "quantityMinimumOrder");
            return (Criteria) this;
        }

        public Criteria andQuantityMinimumOrderLessThan(Integer value) {
            addCriterion("quantity_minimum_order <", value, "quantityMinimumOrder");
            return (Criteria) this;
        }

        public Criteria andQuantityMinimumOrderLessThanOrEqualTo(Integer value) {
            addCriterion("quantity_minimum_order <=", value, "quantityMinimumOrder");
            return (Criteria) this;
        }

        public Criteria andQuantityMinimumOrderIn(List<Integer> values) {
            addCriterion("quantity_minimum_order in", values, "quantityMinimumOrder");
            return (Criteria) this;
        }

        public Criteria andQuantityMinimumOrderNotIn(List<Integer> values) {
            addCriterion("quantity_minimum_order not in", values, "quantityMinimumOrder");
            return (Criteria) this;
        }

        public Criteria andQuantityMinimumOrderBetween(Integer value1, Integer value2) {
            addCriterion("quantity_minimum_order between", value1, value2, "quantityMinimumOrder");
            return (Criteria) this;
        }

        public Criteria andQuantityMinimumOrderNotBetween(Integer value1, Integer value2) {
            addCriterion("quantity_minimum_order not between", value1, value2, "quantityMinimumOrder");
            return (Criteria) this;
        }

        public Criteria andQuantityFinalAdviseIsNull() {
            addCriterion("quantity_final_advise is null");
            return (Criteria) this;
        }

        public Criteria andQuantityFinalAdviseIsNotNull() {
            addCriterion("quantity_final_advise is not null");
            return (Criteria) this;
        }

        public Criteria andQuantityFinalAdviseEqualTo(BigDecimal value) {
            addCriterion("quantity_final_advise =", value, "quantityFinalAdvise");
            return (Criteria) this;
        }

        public Criteria andQuantityFinalAdviseNotEqualTo(BigDecimal value) {
            addCriterion("quantity_final_advise <>", value, "quantityFinalAdvise");
            return (Criteria) this;
        }

        public Criteria andQuantityFinalAdviseGreaterThan(BigDecimal value) {
            addCriterion("quantity_final_advise >", value, "quantityFinalAdvise");
            return (Criteria) this;
        }

        public Criteria andQuantityFinalAdviseGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("quantity_final_advise >=", value, "quantityFinalAdvise");
            return (Criteria) this;
        }

        public Criteria andQuantityFinalAdviseLessThan(BigDecimal value) {
            addCriterion("quantity_final_advise <", value, "quantityFinalAdvise");
            return (Criteria) this;
        }

        public Criteria andQuantityFinalAdviseLessThanOrEqualTo(BigDecimal value) {
            addCriterion("quantity_final_advise <=", value, "quantityFinalAdvise");
            return (Criteria) this;
        }

        public Criteria andQuantityFinalAdviseIn(List<BigDecimal> values) {
            addCriterion("quantity_final_advise in", values, "quantityFinalAdvise");
            return (Criteria) this;
        }

        public Criteria andQuantityFinalAdviseNotIn(List<BigDecimal> values) {
            addCriterion("quantity_final_advise not in", values, "quantityFinalAdvise");
            return (Criteria) this;
        }

        public Criteria andQuantityFinalAdviseBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("quantity_final_advise between", value1, value2, "quantityFinalAdvise");
            return (Criteria) this;
        }

        public Criteria andQuantityFinalAdviseNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("quantity_final_advise not between", value1, value2, "quantityFinalAdvise");
            return (Criteria) this;
        }

        public Criteria andWarehouseNameIsNull() {
            addCriterion("warehouse_name is null");
            return (Criteria) this;
        }

        public Criteria andWarehouseNameIsNotNull() {
            addCriterion("warehouse_name is not null");
            return (Criteria) this;
        }

        public Criteria andWarehouseNameEqualTo(String value) {
            addCriterion("warehouse_name =", value, "warehouseName");
            return (Criteria) this;
        }

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

        public Criteria andWarehouseNameGreaterThan(String value) {
            addCriterion("warehouse_name >", value, "warehouseName");
            return (Criteria) this;
        }

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

        public Criteria andWarehouseNameLessThan(String value) {
            addCriterion("warehouse_name <", value, "warehouseName");
            return (Criteria) this;
        }

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

        public Criteria andWarehouseNameLike(String value) {
            addCriterion("warehouse_name like", value, "warehouseName");
            return (Criteria) this;
        }

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

        public Criteria andWarehouseNameIn(List<String> values) {
            addCriterion("warehouse_name in", values, "warehouseName");
            return (Criteria) this;
        }

        public Criteria andWarehouseNameNotIn(List<String> values) {
            addCriterion("warehouse_name not in", values, "warehouseName");
            return (Criteria) this;
        }

        public Criteria andWarehouseNameBetween(String value1, String value2) {
            addCriterion("warehouse_name between", value1, value2, "warehouseName");
            return (Criteria) this;
        }

        public Criteria andWarehouseNameNotBetween(String value1, String value2) {
            addCriterion("warehouse_name not between", value1, value2, "warehouseName");
            return (Criteria) this;
        }

        public Criteria andQuantityPromotionIsNull() {
            addCriterion("quantity_promotion is null");
            return (Criteria) this;
        }

        public Criteria andQuantityPromotionIsNotNull() {
            addCriterion("quantity_promotion is not null");
            return (Criteria) this;
        }

        public Criteria andQuantityPromotionEqualTo(Integer value) {
            addCriterion("quantity_promotion =", value, "quantityPromotion");
            return (Criteria) this;
        }

        public Criteria andQuantityPromotionNotEqualTo(Integer value) {
            addCriterion("quantity_promotion <>", value, "quantityPromotion");
            return (Criteria) this;
        }

        public Criteria andQuantityPromotionGreaterThan(Integer value) {
            addCriterion("quantity_promotion >", value, "quantityPromotion");
            return (Criteria) this;
        }

        public Criteria andQuantityPromotionGreaterThanOrEqualTo(Integer value) {
            addCriterion("quantity_promotion >=", value, "quantityPromotion");
            return (Criteria) this;
        }

        public Criteria andQuantityPromotionLessThan(Integer value) {
            addCriterion("quantity_promotion <", value, "quantityPromotion");
            return (Criteria) this;
        }

        public Criteria andQuantityPromotionLessThanOrEqualTo(Integer value) {
            addCriterion("quantity_promotion <=", value, "quantityPromotion");
            return (Criteria) this;
        }

        public Criteria andQuantityPromotionIn(List<Integer> values) {
            addCriterion("quantity_promotion in", values, "quantityPromotion");
            return (Criteria) this;
        }

        public Criteria andQuantityPromotionNotIn(List<Integer> values) {
            addCriterion("quantity_promotion not in", values, "quantityPromotion");
            return (Criteria) this;
        }

        public Criteria andQuantityPromotionBetween(Integer value1, Integer value2) {
            addCriterion("quantity_promotion between", value1, value2, "quantityPromotion");
            return (Criteria) this;
        }

        public Criteria andQuantityPromotionNotBetween(Integer value1, Integer value2) {
            addCriterion("quantity_promotion not between", value1, value2, "quantityPromotion");
            return (Criteria) this;
        }

        public Criteria andQuantityInventoryIsNull() {
            addCriterion("quantity_inventory is null");
            return (Criteria) this;
        }

        public Criteria andQuantityInventoryIsNotNull() {
            addCriterion("quantity_inventory is not null");
            return (Criteria) this;
        }

        public Criteria andQuantityInventoryEqualTo(Integer value) {
            addCriterion("quantity_inventory =", value, "quantityInventory");
            return (Criteria) this;
        }

        public Criteria andQuantityInventoryNotEqualTo(Integer value) {
            addCriterion("quantity_inventory <>", value, "quantityInventory");
            return (Criteria) this;
        }

        public Criteria andQuantityInventoryGreaterThan(Integer value) {
            addCriterion("quantity_inventory >", value, "quantityInventory");
            return (Criteria) this;
        }

        public Criteria andQuantityInventoryGreaterThanOrEqualTo(Integer value) {
            addCriterion("quantity_inventory >=", value, "quantityInventory");
            return (Criteria) this;
        }

        public Criteria andQuantityInventoryLessThan(Integer value) {
            addCriterion("quantity_inventory <", value, "quantityInventory");
            return (Criteria) this;
        }

        public Criteria andQuantityInventoryLessThanOrEqualTo(Integer value) {
            addCriterion("quantity_inventory <=", value, "quantityInventory");
            return (Criteria) this;
        }

        public Criteria andQuantityInventoryIn(List<Integer> values) {
            addCriterion("quantity_inventory in", values, "quantityInventory");
            return (Criteria) this;
        }

        public Criteria andQuantityInventoryNotIn(List<Integer> values) {
            addCriterion("quantity_inventory not in", values, "quantityInventory");
            return (Criteria) this;
        }

        public Criteria andQuantityInventoryBetween(Integer value1, Integer value2) {
            addCriterion("quantity_inventory between", value1, value2, "quantityInventory");
            return (Criteria) this;
        }

        public Criteria andQuantityInventoryNotBetween(Integer value1, Integer value2) {
            addCriterion("quantity_inventory not between", value1, value2, "quantityInventory");
            return (Criteria) this;
        }

        public Criteria andQuantityTransferIsNull() {
            addCriterion("quantity_transfer is null");
            return (Criteria) this;
        }

        public Criteria andQuantityTransferIsNotNull() {
            addCriterion("quantity_transfer is not null");
            return (Criteria) this;
        }

        public Criteria andQuantityTransferEqualTo(Integer value) {
            addCriterion("quantity_transfer =", value, "quantityTransfer");
            return (Criteria) this;
        }

        public Criteria andQuantityTransferNotEqualTo(Integer value) {
            addCriterion("quantity_transfer <>", value, "quantityTransfer");
            return (Criteria) this;
        }

        public Criteria andQuantityTransferGreaterThan(Integer value) {
            addCriterion("quantity_transfer >", value, "quantityTransfer");
            return (Criteria) this;
        }

        public Criteria andQuantityTransferGreaterThanOrEqualTo(Integer value) {
            addCriterion("quantity_transfer >=", value, "quantityTransfer");
            return (Criteria) this;
        }

        public Criteria andQuantityTransferLessThan(Integer value) {
            addCriterion("quantity_transfer <", value, "quantityTransfer");
            return (Criteria) this;
        }

        public Criteria andQuantityTransferLessThanOrEqualTo(Integer value) {
            addCriterion("quantity_transfer <=", value, "quantityTransfer");
            return (Criteria) this;
        }

        public Criteria andQuantityTransferIn(List<Integer> values) {
            addCriterion("quantity_transfer in", values, "quantityTransfer");
            return (Criteria) this;
        }

        public Criteria andQuantityTransferNotIn(List<Integer> values) {
            addCriterion("quantity_transfer not in", values, "quantityTransfer");
            return (Criteria) this;
        }

        public Criteria andQuantityTransferBetween(Integer value1, Integer value2) {
            addCriterion("quantity_transfer between", value1, value2, "quantityTransfer");
            return (Criteria) this;
        }

        public Criteria andQuantityTransferNotBetween(Integer value1, Integer value2) {
            addCriterion("quantity_transfer not between", value1, value2, "quantityTransfer");
            return (Criteria) this;
        }

        public Criteria andQuantityPurchaseIsNull() {
            addCriterion("quantity_purchase is null");
            return (Criteria) this;
        }

        public Criteria andQuantityPurchaseIsNotNull() {
            addCriterion("quantity_purchase is not null");
            return (Criteria) this;
        }

        public Criteria andQuantityPurchaseEqualTo(Integer value) {
            addCriterion("quantity_purchase =", value, "quantityPurchase");
            return (Criteria) this;
        }

        public Criteria andQuantityPurchaseNotEqualTo(Integer value) {
            addCriterion("quantity_purchase <>", value, "quantityPurchase");
            return (Criteria) this;
        }

        public Criteria andQuantityPurchaseGreaterThan(Integer value) {
            addCriterion("quantity_purchase >", value, "quantityPurchase");
            return (Criteria) this;
        }

        public Criteria andQuantityPurchaseGreaterThanOrEqualTo(Integer value) {
            addCriterion("quantity_purchase >=", value, "quantityPurchase");
            return (Criteria) this;
        }

        public Criteria andQuantityPurchaseLessThan(Integer value) {
            addCriterion("quantity_purchase <", value, "quantityPurchase");
            return (Criteria) this;
        }

        public Criteria andQuantityPurchaseLessThanOrEqualTo(Integer value) {
            addCriterion("quantity_purchase <=", value, "quantityPurchase");
            return (Criteria) this;
        }

        public Criteria andQuantityPurchaseIn(List<Integer> values) {
            addCriterion("quantity_purchase in", values, "quantityPurchase");
            return (Criteria) this;
        }

        public Criteria andQuantityPurchaseNotIn(List<Integer> values) {
            addCriterion("quantity_purchase not in", values, "quantityPurchase");
            return (Criteria) this;
        }

        public Criteria andQuantityPurchaseBetween(Integer value1, Integer value2) {
            addCriterion("quantity_purchase between", value1, value2, "quantityPurchase");
            return (Criteria) this;
        }

        public Criteria andQuantityPurchaseNotBetween(Integer value1, Integer value2) {
            addCriterion("quantity_purchase not between", value1, value2, "quantityPurchase");
            return (Criteria) this;
        }

        public Criteria andTurnoverDaysIsNull() {
            addCriterion("turnover_days is null");
            return (Criteria) this;
        }

        public Criteria andTurnoverDaysIsNotNull() {
            addCriterion("turnover_days is not null");
            return (Criteria) this;
        }

        public Criteria andTurnoverDaysEqualTo(Integer value) {
            addCriterion("turnover_days =", value, "turnoverDays");
            return (Criteria) this;
        }

        public Criteria andTurnoverDaysNotEqualTo(Integer value) {
            addCriterion("turnover_days <>", value, "turnoverDays");
            return (Criteria) this;
        }

        public Criteria andTurnoverDaysGreaterThan(Integer value) {
            addCriterion("turnover_days >", value, "turnoverDays");
            return (Criteria) this;
        }

        public Criteria andTurnoverDaysGreaterThanOrEqualTo(Integer value) {
            addCriterion("turnover_days >=", value, "turnoverDays");
            return (Criteria) this;
        }

        public Criteria andTurnoverDaysLessThan(Integer value) {
            addCriterion("turnover_days <", value, "turnoverDays");
            return (Criteria) this;
        }

        public Criteria andTurnoverDaysLessThanOrEqualTo(Integer value) {
            addCriterion("turnover_days <=", value, "turnoverDays");
            return (Criteria) this;
        }

        public Criteria andTurnoverDaysIn(List<Integer> values) {
            addCriterion("turnover_days in", values, "turnoverDays");
            return (Criteria) this;
        }

        public Criteria andTurnoverDaysNotIn(List<Integer> values) {
            addCriterion("turnover_days not in", values, "turnoverDays");
            return (Criteria) this;
        }

        public Criteria andTurnoverDaysBetween(Integer value1, Integer value2) {
            addCriterion("turnover_days between", value1, value2, "turnoverDays");
            return (Criteria) this;
        }

        public Criteria andTurnoverDaysNotBetween(Integer value1, Integer value2) {
            addCriterion("turnover_days not between", value1, value2, "turnoverDays");
            return (Criteria) this;
        }

        public Criteria andQuantitySafeInventoryIsNull() {
            addCriterion("quantity_safe_inventory is null");
            return (Criteria) this;
        }

        public Criteria andQuantitySafeInventoryIsNotNull() {
            addCriterion("quantity_safe_inventory is not null");
            return (Criteria) this;
        }

        public Criteria andQuantitySafeInventoryEqualTo(BigDecimal value) {
            addCriterion("quantity_safe_inventory =", value, "quantitySafeInventory");
            return (Criteria) this;
        }

        public Criteria andQuantitySafeInventoryNotEqualTo(BigDecimal value) {
            addCriterion("quantity_safe_inventory <>", value, "quantitySafeInventory");
            return (Criteria) this;
        }

        public Criteria andQuantitySafeInventoryGreaterThan(BigDecimal value) {
            addCriterion("quantity_safe_inventory >", value, "quantitySafeInventory");
            return (Criteria) this;
        }

        public Criteria andQuantitySafeInventoryGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("quantity_safe_inventory >=", value, "quantitySafeInventory");
            return (Criteria) this;
        }

        public Criteria andQuantitySafeInventoryLessThan(BigDecimal value) {
            addCriterion("quantity_safe_inventory <", value, "quantitySafeInventory");
            return (Criteria) this;
        }

        public Criteria andQuantitySafeInventoryLessThanOrEqualTo(BigDecimal value) {
            addCriterion("quantity_safe_inventory <=", value, "quantitySafeInventory");
            return (Criteria) this;
        }

        public Criteria andQuantitySafeInventoryIn(List<BigDecimal> values) {
            addCriterion("quantity_safe_inventory in", values, "quantitySafeInventory");
            return (Criteria) this;
        }

        public Criteria andQuantitySafeInventoryNotIn(List<BigDecimal> values) {
            addCriterion("quantity_safe_inventory not in", values, "quantitySafeInventory");
            return (Criteria) this;
        }

        public Criteria andQuantitySafeInventoryBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("quantity_safe_inventory between", value1, value2, "quantitySafeInventory");
            return (Criteria) this;
        }

        public Criteria andQuantitySafeInventoryNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("quantity_safe_inventory not between", value1, value2, "quantitySafeInventory");
            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<String> values) {
            addCriterion("remark in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> 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 andGmtCreateIsNull() {
            addCriterion("gmt_create is null");
            return (Criteria) this;
        }

        public Criteria andGmtCreateIsNotNull() {
            addCriterion("gmt_create is not null");
            return (Criteria) this;
        }

        public Criteria andGmtCreateEqualTo(LocalDateTime value) {
            addCriterion("gmt_create =", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateNotEqualTo(LocalDateTime value) {
            addCriterion("gmt_create <>", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateGreaterThan(LocalDateTime value) {
            addCriterion("gmt_create >", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateGreaterThanOrEqualTo(LocalDateTime value) {
            addCriterion("gmt_create >=", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateLessThan(LocalDateTime value) {
            addCriterion("gmt_create <", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateLessThanOrEqualTo(LocalDateTime value) {
            addCriterion("gmt_create <=", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateIn(List<LocalDateTime> values) {
            addCriterion("gmt_create in", values, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateNotIn(List<LocalDateTime> values) {
            addCriterion("gmt_create not in", values, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("gmt_create between", value1, value2, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateNotBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("gmt_create not between", value1, value2, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedIsNull() {
            addCriterion("gmt_modified is null");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedIsNotNull() {
            addCriterion("gmt_modified is not null");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedEqualTo(LocalDateTime value) {
            addCriterion("gmt_modified =", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedNotEqualTo(LocalDateTime value) {
            addCriterion("gmt_modified <>", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedGreaterThan(LocalDateTime value) {
            addCriterion("gmt_modified >", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedGreaterThanOrEqualTo(LocalDateTime value) {
            addCriterion("gmt_modified >=", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedLessThan(LocalDateTime value) {
            addCriterion("gmt_modified <", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedLessThanOrEqualTo(LocalDateTime value) {
            addCriterion("gmt_modified <=", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedIn(List<LocalDateTime> values) {
            addCriterion("gmt_modified in", values, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedNotIn(List<LocalDateTime> values) {
            addCriterion("gmt_modified not in", values, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("gmt_modified between", value1, value2, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedNotBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("gmt_modified not between", value1, value2, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("status is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("status is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Byte value) {
            addCriterion("status =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(Byte value) {
            addCriterion("status <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(Byte value) {
            addCriterion("status >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(Byte value) {
            addCriterion("status >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(Byte value) {
            addCriterion("status <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(Byte value) {
            addCriterion("status <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<Byte> values) {
            addCriterion("status in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<Byte> values) {
            addCriterion("status not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(Byte value1, Byte value2) {
            addCriterion("status between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(Byte value1, Byte value2) {
            addCriterion("status not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andQuantityOutStockIsNull() {
            addCriterion("quantity_out_stock is null");
            return (Criteria) this;
        }

        public Criteria andQuantityOutStockIsNotNull() {
            addCriterion("quantity_out_stock is not null");
            return (Criteria) this;
        }

        public Criteria andQuantityOutStockEqualTo(Integer value) {
            addCriterion("quantity_out_stock =", value, "quantityOutStock");
            return (Criteria) this;
        }

        public Criteria andQuantityOutStockNotEqualTo(Integer value) {
            addCriterion("quantity_out_stock <>", value, "quantityOutStock");
            return (Criteria) this;
        }

        public Criteria andQuantityOutStockGreaterThan(Integer value) {
            addCriterion("quantity_out_stock >", value, "quantityOutStock");
            return (Criteria) this;
        }

        public Criteria andQuantityOutStockGreaterThanOrEqualTo(Integer value) {
            addCriterion("quantity_out_stock >=", value, "quantityOutStock");
            return (Criteria) this;
        }

        public Criteria andQuantityOutStockLessThan(Integer value) {
            addCriterion("quantity_out_stock <", value, "quantityOutStock");
            return (Criteria) this;
        }

        public Criteria andQuantityOutStockLessThanOrEqualTo(Integer value) {
            addCriterion("quantity_out_stock <=", value, "quantityOutStock");
            return (Criteria) this;
        }

        public Criteria andQuantityOutStockIn(List<Integer> values) {
            addCriterion("quantity_out_stock in", values, "quantityOutStock");
            return (Criteria) this;
        }

        public Criteria andQuantityOutStockNotIn(List<Integer> values) {
            addCriterion("quantity_out_stock not in", values, "quantityOutStock");
            return (Criteria) this;
        }

        public Criteria andQuantityOutStockBetween(Integer value1, Integer value2) {
            addCriterion("quantity_out_stock between", value1, value2, "quantityOutStock");
            return (Criteria) this;
        }

        public Criteria andQuantityOutStockNotBetween(Integer value1, Integer value2) {
            addCriterion("quantity_out_stock not between", value1, value2, "quantityOutStock");
            return (Criteria) this;
        }

        public Criteria andSkuTitleIsNull() {
            addCriterion("sku_title is null");
            return (Criteria) this;
        }

        public Criteria andSkuTitleIsNotNull() {
            addCriterion("sku_title is not null");
            return (Criteria) this;
        }

        public Criteria andSkuTitleEqualTo(String value) {
            addCriterion("sku_title =", value, "skuTitle");
            return (Criteria) this;
        }

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

        public Criteria andSkuTitleGreaterThan(String value) {
            addCriterion("sku_title >", value, "skuTitle");
            return (Criteria) this;
        }

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

        public Criteria andSkuTitleLessThan(String value) {
            addCriterion("sku_title <", value, "skuTitle");
            return (Criteria) this;
        }

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

        public Criteria andSkuTitleLike(String value) {
            addCriterion("sku_title like", value, "skuTitle");
            return (Criteria) this;
        }

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

        public Criteria andSkuTitleIn(List<String> values) {
            addCriterion("sku_title in", values, "skuTitle");
            return (Criteria) this;
        }

        public Criteria andSkuTitleNotIn(List<String> values) {
            addCriterion("sku_title not in", values, "skuTitle");
            return (Criteria) this;
        }

        public Criteria andSkuTitleBetween(String value1, String value2) {
            addCriterion("sku_title between", value1, value2, "skuTitle");
            return (Criteria) this;
        }

        public Criteria andSkuTitleNotBetween(String value1, String value2) {
            addCriterion("sku_title not between", value1, value2, "skuTitle");
            return (Criteria) this;
        }

        public Criteria andPromotionsIsNull() {
            addCriterion("promotions is null");
            return (Criteria) this;
        }

        public Criteria andPromotionsIsNotNull() {
            addCriterion("promotions is not null");
            return (Criteria) this;
        }

        public Criteria andPromotionsEqualTo(String value) {
            addCriterion("promotions =", value, "promotions");
            return (Criteria) this;
        }

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

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

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

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

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

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

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

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

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

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

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

        public Criteria andSupplierDeliveryIsNull() {
            addCriterion("supplier_delivery is null");
            return (Criteria) this;
        }

        public Criteria andSupplierDeliveryIsNotNull() {
            addCriterion("supplier_delivery is not null");
            return (Criteria) this;
        }

        public Criteria andSupplierDeliveryEqualTo(Integer value) {
            addCriterion("supplier_delivery =", value, "supplierDelivery");
            return (Criteria) this;
        }

        public Criteria andSupplierDeliveryNotEqualTo(Integer value) {
            addCriterion("supplier_delivery <>", value, "supplierDelivery");
            return (Criteria) this;
        }

        public Criteria andSupplierDeliveryGreaterThan(Integer value) {
            addCriterion("supplier_delivery >", value, "supplierDelivery");
            return (Criteria) this;
        }

        public Criteria andSupplierDeliveryGreaterThanOrEqualTo(Integer value) {
            addCriterion("supplier_delivery >=", value, "supplierDelivery");
            return (Criteria) this;
        }

        public Criteria andSupplierDeliveryLessThan(Integer value) {
            addCriterion("supplier_delivery <", value, "supplierDelivery");
            return (Criteria) this;
        }

        public Criteria andSupplierDeliveryLessThanOrEqualTo(Integer value) {
            addCriterion("supplier_delivery <=", value, "supplierDelivery");
            return (Criteria) this;
        }

        public Criteria andSupplierDeliveryIn(List<Integer> values) {
            addCriterion("supplier_delivery in", values, "supplierDelivery");
            return (Criteria) this;
        }

        public Criteria andSupplierDeliveryNotIn(List<Integer> values) {
            addCriterion("supplier_delivery not in", values, "supplierDelivery");
            return (Criteria) this;
        }

        public Criteria andSupplierDeliveryBetween(Integer value1, Integer value2) {
            addCriterion("supplier_delivery between", value1, value2, "supplierDelivery");
            return (Criteria) this;
        }

        public Criteria andSupplierDeliveryNotBetween(Integer value1, Integer value2) {
            addCriterion("supplier_delivery not between", value1, value2, "supplierDelivery");
            return (Criteria) this;
        }

        public Criteria andInventoryAvailableDaysIsNull() {
            addCriterion("inventory_available_days is null");
            return (Criteria) this;
        }

        public Criteria andInventoryAvailableDaysIsNotNull() {
            addCriterion("inventory_available_days is not null");
            return (Criteria) this;
        }

        public Criteria andInventoryAvailableDaysEqualTo(Integer value) {
            addCriterion("inventory_available_days =", value, "inventoryAvailableDays");
            return (Criteria) this;
        }

        public Criteria andInventoryAvailableDaysNotEqualTo(Integer value) {
            addCriterion("inventory_available_days <>", value, "inventoryAvailableDays");
            return (Criteria) this;
        }

        public Criteria andInventoryAvailableDaysGreaterThan(Integer value) {
            addCriterion("inventory_available_days >", value, "inventoryAvailableDays");
            return (Criteria) this;
        }

        public Criteria andInventoryAvailableDaysGreaterThanOrEqualTo(Integer value) {
            addCriterion("inventory_available_days >=", value, "inventoryAvailableDays");
            return (Criteria) this;
        }

        public Criteria andInventoryAvailableDaysLessThan(Integer value) {
            addCriterion("inventory_available_days <", value, "inventoryAvailableDays");
            return (Criteria) this;
        }

        public Criteria andInventoryAvailableDaysLessThanOrEqualTo(Integer value) {
            addCriterion("inventory_available_days <=", value, "inventoryAvailableDays");
            return (Criteria) this;
        }

        public Criteria andInventoryAvailableDaysIn(List<Integer> values) {
            addCriterion("inventory_available_days in", values, "inventoryAvailableDays");
            return (Criteria) this;
        }

        public Criteria andInventoryAvailableDaysNotIn(List<Integer> values) {
            addCriterion("inventory_available_days not in", values, "inventoryAvailableDays");
            return (Criteria) this;
        }

        public Criteria andInventoryAvailableDaysBetween(Integer value1, Integer value2) {
            addCriterion("inventory_available_days between", value1, value2, "inventoryAvailableDays");
            return (Criteria) this;
        }

        public Criteria andInventoryAvailableDaysNotBetween(Integer value1, Integer value2) {
            addCriterion("inventory_available_days not between", value1, value2, "inventoryAvailableDays");
            return (Criteria) this;
        }

        public Criteria andQuantityInboundIsNull() {
            addCriterion("quantity_inbound is null");
            return (Criteria) this;
        }

        public Criteria andQuantityInboundIsNotNull() {
            addCriterion("quantity_inbound is not null");
            return (Criteria) this;
        }

        public Criteria andQuantityInboundEqualTo(Integer value) {
            addCriterion("quantity_inbound =", value, "quantityInbound");
            return (Criteria) this;
        }

        public Criteria andQuantityInboundNotEqualTo(Integer value) {
            addCriterion("quantity_inbound <>", value, "quantityInbound");
            return (Criteria) this;
        }

        public Criteria andQuantityInboundGreaterThan(Integer value) {
            addCriterion("quantity_inbound >", value, "quantityInbound");
            return (Criteria) this;
        }

        public Criteria andQuantityInboundGreaterThanOrEqualTo(Integer value) {
            addCriterion("quantity_inbound >=", value, "quantityInbound");
            return (Criteria) this;
        }

        public Criteria andQuantityInboundLessThan(Integer value) {
            addCriterion("quantity_inbound <", value, "quantityInbound");
            return (Criteria) this;
        }

        public Criteria andQuantityInboundLessThanOrEqualTo(Integer value) {
            addCriterion("quantity_inbound <=", value, "quantityInbound");
            return (Criteria) this;
        }

        public Criteria andQuantityInboundIn(List<Integer> values) {
            addCriterion("quantity_inbound in", values, "quantityInbound");
            return (Criteria) this;
        }

        public Criteria andQuantityInboundNotIn(List<Integer> values) {
            addCriterion("quantity_inbound not in", values, "quantityInbound");
            return (Criteria) this;
        }

        public Criteria andQuantityInboundBetween(Integer value1, Integer value2) {
            addCriterion("quantity_inbound between", value1, value2, "quantityInbound");
            return (Criteria) this;
        }

        public Criteria andQuantityInboundNotBetween(Integer value1, Integer value2) {
            addCriterion("quantity_inbound not between", value1, value2, "quantityInbound");
            return (Criteria) this;
        }

        public Criteria andForecastOnedaySalesIsNull() {
            addCriterion("forecast_oneday_sales is null");
            return (Criteria) this;
        }

        public Criteria andForecastOnedaySalesIsNotNull() {
            addCriterion("forecast_oneday_sales is not null");
            return (Criteria) this;
        }

        public Criteria andForecastOnedaySalesEqualTo(BigDecimal value) {
            addCriterion("forecast_oneday_sales =", value, "forecastOnedaySales");
            return (Criteria) this;
        }

        public Criteria andForecastOnedaySalesNotEqualTo(BigDecimal value) {
            addCriterion("forecast_oneday_sales <>", value, "forecastOnedaySales");
            return (Criteria) this;
        }

        public Criteria andForecastOnedaySalesGreaterThan(BigDecimal value) {
            addCriterion("forecast_oneday_sales >", value, "forecastOnedaySales");
            return (Criteria) this;
        }

        public Criteria andForecastOnedaySalesGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("forecast_oneday_sales >=", value, "forecastOnedaySales");
            return (Criteria) this;
        }

        public Criteria andForecastOnedaySalesLessThan(BigDecimal value) {
            addCriterion("forecast_oneday_sales <", value, "forecastOnedaySales");
            return (Criteria) this;
        }

        public Criteria andForecastOnedaySalesLessThanOrEqualTo(BigDecimal value) {
            addCriterion("forecast_oneday_sales <=", value, "forecastOnedaySales");
            return (Criteria) this;
        }

        public Criteria andForecastOnedaySalesIn(List<BigDecimal> values) {
            addCriterion("forecast_oneday_sales in", values, "forecastOnedaySales");
            return (Criteria) this;
        }

        public Criteria andForecastOnedaySalesNotIn(List<BigDecimal> values) {
            addCriterion("forecast_oneday_sales not in", values, "forecastOnedaySales");
            return (Criteria) this;
        }

        public Criteria andForecastOnedaySalesBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("forecast_oneday_sales between", value1, value2, "forecastOnedaySales");
            return (Criteria) this;
        }

        public Criteria andForecastOnedaySalesNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("forecast_oneday_sales not between", value1, value2, "forecastOnedaySales");
            return (Criteria) this;
        }

        public Criteria andForecastSevendaySalesIsNull() {
            addCriterion("forecast_sevenday_sales is null");
            return (Criteria) this;
        }

        public Criteria andForecastSevendaySalesIsNotNull() {
            addCriterion("forecast_sevenday_sales is not null");
            return (Criteria) this;
        }

        public Criteria andForecastSevendaySalesEqualTo(BigDecimal value) {
            addCriterion("forecast_sevenday_sales =", value, "forecastSevendaySales");
            return (Criteria) this;
        }

        public Criteria andForecastSevendaySalesNotEqualTo(BigDecimal value) {
            addCriterion("forecast_sevenday_sales <>", value, "forecastSevendaySales");
            return (Criteria) this;
        }

        public Criteria andForecastSevendaySalesGreaterThan(BigDecimal value) {
            addCriterion("forecast_sevenday_sales >", value, "forecastSevendaySales");
            return (Criteria) this;
        }

        public Criteria andForecastSevendaySalesGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("forecast_sevenday_sales >=", value, "forecastSevendaySales");
            return (Criteria) this;
        }

        public Criteria andForecastSevendaySalesLessThan(BigDecimal value) {
            addCriterion("forecast_sevenday_sales <", value, "forecastSevendaySales");
            return (Criteria) this;
        }

        public Criteria andForecastSevendaySalesLessThanOrEqualTo(BigDecimal value) {
            addCriterion("forecast_sevenday_sales <=", value, "forecastSevendaySales");
            return (Criteria) this;
        }

        public Criteria andForecastSevendaySalesIn(List<BigDecimal> values) {
            addCriterion("forecast_sevenday_sales in", values, "forecastSevendaySales");
            return (Criteria) this;
        }

        public Criteria andForecastSevendaySalesNotIn(List<BigDecimal> values) {
            addCriterion("forecast_sevenday_sales not in", values, "forecastSevendaySales");
            return (Criteria) this;
        }

        public Criteria andForecastSevendaySalesBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("forecast_sevenday_sales between", value1, value2, "forecastSevendaySales");
            return (Criteria) this;
        }

        public Criteria andForecastSevendaySalesNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("forecast_sevenday_sales not between", value1, value2, "forecastSevendaySales");
            return (Criteria) this;
        }

        public Criteria andForecastFourteendaySalesIsNull() {
            addCriterion("forecast_fourteenday_sales is null");
            return (Criteria) this;
        }

        public Criteria andForecastFourteendaySalesIsNotNull() {
            addCriterion("forecast_fourteenday_sales is not null");
            return (Criteria) this;
        }

        public Criteria andForecastFourteendaySalesEqualTo(BigDecimal value) {
            addCriterion("forecast_fourteenday_sales =", value, "forecastFourteendaySales");
            return (Criteria) this;
        }

        public Criteria andForecastFourteendaySalesNotEqualTo(BigDecimal value) {
            addCriterion("forecast_fourteenday_sales <>", value, "forecastFourteendaySales");
            return (Criteria) this;
        }

        public Criteria andForecastFourteendaySalesGreaterThan(BigDecimal value) {
            addCriterion("forecast_fourteenday_sales >", value, "forecastFourteendaySales");
            return (Criteria) this;
        }

        public Criteria andForecastFourteendaySalesGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("forecast_fourteenday_sales >=", value, "forecastFourteendaySales");
            return (Criteria) this;
        }

        public Criteria andForecastFourteendaySalesLessThan(BigDecimal value) {
            addCriterion("forecast_fourteenday_sales <", value, "forecastFourteendaySales");
            return (Criteria) this;
        }

        public Criteria andForecastFourteendaySalesLessThanOrEqualTo(BigDecimal value) {
            addCriterion("forecast_fourteenday_sales <=", value, "forecastFourteendaySales");
            return (Criteria) this;
        }

        public Criteria andForecastFourteendaySalesIn(List<BigDecimal> values) {
            addCriterion("forecast_fourteenday_sales in", values, "forecastFourteendaySales");
            return (Criteria) this;
        }

        public Criteria andForecastFourteendaySalesNotIn(List<BigDecimal> values) {
            addCriterion("forecast_fourteenday_sales not in", values, "forecastFourteendaySales");
            return (Criteria) this;
        }

        public Criteria andForecastFourteendaySalesBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("forecast_fourteenday_sales between", value1, value2, "forecastFourteendaySales");
            return (Criteria) this;
        }

        public Criteria andForecastFourteendaySalesNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("forecast_fourteenday_sales not between", value1, value2, "forecastFourteendaySales");
            return (Criteria) this;
        }

        public Criteria andInboundDetailsIsNull() {
            addCriterion("inbound_details is null");
            return (Criteria) this;
        }

        public Criteria andInboundDetailsIsNotNull() {
            addCriterion("inbound_details is not null");
            return (Criteria) this;
        }

        public Criteria andInboundDetailsEqualTo(String value) {
            addCriterion("inbound_details =", value, "inboundDetails");
            return (Criteria) this;
        }

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

        public Criteria andInboundDetailsGreaterThan(String value) {
            addCriterion("inbound_details >", value, "inboundDetails");
            return (Criteria) this;
        }

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

        public Criteria andInboundDetailsLessThan(String value) {
            addCriterion("inbound_details <", value, "inboundDetails");
            return (Criteria) this;
        }

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

        public Criteria andInboundDetailsLike(String value) {
            addCriterion("inbound_details like", value, "inboundDetails");
            return (Criteria) this;
        }

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

        public Criteria andInboundDetailsIn(List<String> values) {
            addCriterion("inbound_details in", values, "inboundDetails");
            return (Criteria) this;
        }

        public Criteria andInboundDetailsNotIn(List<String> values) {
            addCriterion("inbound_details not in", values, "inboundDetails");
            return (Criteria) this;
        }

        public Criteria andInboundDetailsBetween(String value1, String value2) {
            addCriterion("inbound_details between", value1, value2, "inboundDetails");
            return (Criteria) this;
        }

        public Criteria andInboundDetailsNotBetween(String value1, String value2) {
            addCriterion("inbound_details not between", value1, value2, "inboundDetails");
            return (Criteria) this;
        }

        public Criteria andInventoryDetailsIsNull() {
            addCriterion("inventory_details is null");
            return (Criteria) this;
        }

        public Criteria andInventoryDetailsIsNotNull() {
            addCriterion("inventory_details is not null");
            return (Criteria) this;
        }

        public Criteria andInventoryDetailsEqualTo(String value) {
            addCriterion("inventory_details =", value, "inventoryDetails");
            return (Criteria) this;
        }

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

        public Criteria andInventoryDetailsGreaterThan(String value) {
            addCriterion("inventory_details >", value, "inventoryDetails");
            return (Criteria) this;
        }

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

        public Criteria andInventoryDetailsLessThan(String value) {
            addCriterion("inventory_details <", value, "inventoryDetails");
            return (Criteria) this;
        }

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

        public Criteria andInventoryDetailsLike(String value) {
            addCriterion("inventory_details like", value, "inventoryDetails");
            return (Criteria) this;
        }

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

        public Criteria andInventoryDetailsIn(List<String> values) {
            addCriterion("inventory_details in", values, "inventoryDetails");
            return (Criteria) this;
        }

        public Criteria andInventoryDetailsNotIn(List<String> values) {
            addCriterion("inventory_details not in", values, "inventoryDetails");
            return (Criteria) this;
        }

        public Criteria andInventoryDetailsBetween(String value1, String value2) {
            addCriterion("inventory_details between", value1, value2, "inventoryDetails");
            return (Criteria) this;
        }

        public Criteria andInventoryDetailsNotBetween(String value1, String value2) {
            addCriterion("inventory_details not between", value1, value2, "inventoryDetails");
            return (Criteria) this;
        }

        public Criteria andAdvisedDetailsIsNull() {
            addCriterion("advised_details is null");
            return (Criteria) this;
        }

        public Criteria andAdvisedDetailsIsNotNull() {
            addCriterion("advised_details is not null");
            return (Criteria) this;
        }

        public Criteria andAdvisedDetailsEqualTo(String value) {
            addCriterion("advised_details =", value, "advisedDetails");
            return (Criteria) this;
        }

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

        public Criteria andAdvisedDetailsGreaterThan(String value) {
            addCriterion("advised_details >", value, "advisedDetails");
            return (Criteria) this;
        }

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

        public Criteria andAdvisedDetailsLessThan(String value) {
            addCriterion("advised_details <", value, "advisedDetails");
            return (Criteria) this;
        }

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

        public Criteria andAdvisedDetailsLike(String value) {
            addCriterion("advised_details like", value, "advisedDetails");
            return (Criteria) this;
        }

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

        public Criteria andAdvisedDetailsIn(List<String> values) {
            addCriterion("advised_details in", values, "advisedDetails");
            return (Criteria) this;
        }

        public Criteria andAdvisedDetailsNotIn(List<String> values) {
            addCriterion("advised_details not in", values, "advisedDetails");
            return (Criteria) this;
        }

        public Criteria andAdvisedDetailsBetween(String value1, String value2) {
            addCriterion("advised_details between", value1, value2, "advisedDetails");
            return (Criteria) this;
        }

        public Criteria andAdvisedDetailsNotBetween(String value1, String value2) {
            addCriterion("advised_details not between", value1, value2, "advisedDetails");
            return (Criteria) this;
        }

        public Criteria andSalesUpperLimitIsNull() {
            addCriterion("sales_upper_limit is null");
            return (Criteria) this;
        }

        public Criteria andSalesUpperLimitIsNotNull() {
            addCriterion("sales_upper_limit is not null");
            return (Criteria) this;
        }

        public Criteria andSalesUpperLimitEqualTo(BigDecimal value) {
            addCriterion("sales_upper_limit =", value, "salesUpperLimit");
            return (Criteria) this;
        }

        public Criteria andSalesUpperLimitNotEqualTo(BigDecimal value) {
            addCriterion("sales_upper_limit <>", value, "salesUpperLimit");
            return (Criteria) this;
        }

        public Criteria andSalesUpperLimitGreaterThan(BigDecimal value) {
            addCriterion("sales_upper_limit >", value, "salesUpperLimit");
            return (Criteria) this;
        }

        public Criteria andSalesUpperLimitGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("sales_upper_limit >=", value, "salesUpperLimit");
            return (Criteria) this;
        }

        public Criteria andSalesUpperLimitLessThan(BigDecimal value) {
            addCriterion("sales_upper_limit <", value, "salesUpperLimit");
            return (Criteria) this;
        }

        public Criteria andSalesUpperLimitLessThanOrEqualTo(BigDecimal value) {
            addCriterion("sales_upper_limit <=", value, "salesUpperLimit");
            return (Criteria) this;
        }

        public Criteria andSalesUpperLimitIn(List<BigDecimal> values) {
            addCriterion("sales_upper_limit in", values, "salesUpperLimit");
            return (Criteria) this;
        }

        public Criteria andSalesUpperLimitNotIn(List<BigDecimal> values) {
            addCriterion("sales_upper_limit not in", values, "salesUpperLimit");
            return (Criteria) this;
        }

        public Criteria andSalesUpperLimitBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("sales_upper_limit between", value1, value2, "salesUpperLimit");
            return (Criteria) this;
        }

        public Criteria andSalesUpperLimitNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("sales_upper_limit not between", value1, value2, "salesUpperLimit");
            return (Criteria) this;
        }

        public Criteria andAverageOverdueIsNull() {
            addCriterion("average_overdue is null");
            return (Criteria) this;
        }

        public Criteria andAverageOverdueIsNotNull() {
            addCriterion("average_overdue is not null");
            return (Criteria) this;
        }

        public Criteria andAverageOverdueEqualTo(BigDecimal value) {
            addCriterion("average_overdue =", value, "averageOverdue");
            return (Criteria) this;
        }

        public Criteria andAverageOverdueNotEqualTo(BigDecimal value) {
            addCriterion("average_overdue <>", value, "averageOverdue");
            return (Criteria) this;
        }

        public Criteria andAverageOverdueGreaterThan(BigDecimal value) {
            addCriterion("average_overdue >", value, "averageOverdue");
            return (Criteria) this;
        }

        public Criteria andAverageOverdueGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("average_overdue >=", value, "averageOverdue");
            return (Criteria) this;
        }

        public Criteria andAverageOverdueLessThan(BigDecimal value) {
            addCriterion("average_overdue <", value, "averageOverdue");
            return (Criteria) this;
        }

        public Criteria andAverageOverdueLessThanOrEqualTo(BigDecimal value) {
            addCriterion("average_overdue <=", value, "averageOverdue");
            return (Criteria) this;
        }

        public Criteria andAverageOverdueIn(List<BigDecimal> values) {
            addCriterion("average_overdue in", values, "averageOverdue");
            return (Criteria) this;
        }

        public Criteria andAverageOverdueNotIn(List<BigDecimal> values) {
            addCriterion("average_overdue not in", values, "averageOverdue");
            return (Criteria) this;
        }

        public Criteria andAverageOverdueBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("average_overdue between", value1, value2, "averageOverdue");
            return (Criteria) this;
        }

        public Criteria andAverageOverdueNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("average_overdue not between", value1, value2, "averageOverdue");
            return (Criteria) this;
        }

        public Criteria andAverageSupplierDeliveryIsNull() {
            addCriterion("average_supplier_delivery is null");
            return (Criteria) this;
        }

        public Criteria andAverageSupplierDeliveryIsNotNull() {
            addCriterion("average_supplier_delivery is not null");
            return (Criteria) this;
        }

        public Criteria andAverageSupplierDeliveryEqualTo(Integer value) {
            addCriterion("average_supplier_delivery =", value, "averageSupplierDelivery");
            return (Criteria) this;
        }

        public Criteria andAverageSupplierDeliveryNotEqualTo(Integer value) {
            addCriterion("average_supplier_delivery <>", value, "averageSupplierDelivery");
            return (Criteria) this;
        }

        public Criteria andAverageSupplierDeliveryGreaterThan(Integer value) {
            addCriterion("average_supplier_delivery >", value, "averageSupplierDelivery");
            return (Criteria) this;
        }

        public Criteria andAverageSupplierDeliveryGreaterThanOrEqualTo(Integer value) {
            addCriterion("average_supplier_delivery >=", value, "averageSupplierDelivery");
            return (Criteria) this;
        }

        public Criteria andAverageSupplierDeliveryLessThan(Integer value) {
            addCriterion("average_supplier_delivery <", value, "averageSupplierDelivery");
            return (Criteria) this;
        }

        public Criteria andAverageSupplierDeliveryLessThanOrEqualTo(Integer value) {
            addCriterion("average_supplier_delivery <=", value, "averageSupplierDelivery");
            return (Criteria) this;
        }

        public Criteria andAverageSupplierDeliveryIn(List<Integer> values) {
            addCriterion("average_supplier_delivery in", values, "averageSupplierDelivery");
            return (Criteria) this;
        }

        public Criteria andAverageSupplierDeliveryNotIn(List<Integer> values) {
            addCriterion("average_supplier_delivery not in", values, "averageSupplierDelivery");
            return (Criteria) this;
        }

        public Criteria andAverageSupplierDeliveryBetween(Integer value1, Integer value2) {
            addCriterion("average_supplier_delivery between", value1, value2, "averageSupplierDelivery");
            return (Criteria) this;
        }

        public Criteria andAverageSupplierDeliveryNotBetween(Integer value1, Integer value2) {
            addCriterion("average_supplier_delivery not between", value1, value2, "averageSupplierDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferConfigDeliveryIsNull() {
            addCriterion("transfer_config_delivery is null");
            return (Criteria) this;
        }

        public Criteria andTransferConfigDeliveryIsNotNull() {
            addCriterion("transfer_config_delivery is not null");
            return (Criteria) this;
        }

        public Criteria andTransferConfigDeliveryEqualTo(Integer value) {
            addCriterion("transfer_config_delivery =", value, "transferConfigDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferConfigDeliveryNotEqualTo(Integer value) {
            addCriterion("transfer_config_delivery <>", value, "transferConfigDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferConfigDeliveryGreaterThan(Integer value) {
            addCriterion("transfer_config_delivery >", value, "transferConfigDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferConfigDeliveryGreaterThanOrEqualTo(Integer value) {
            addCriterion("transfer_config_delivery >=", value, "transferConfigDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferConfigDeliveryLessThan(Integer value) {
            addCriterion("transfer_config_delivery <", value, "transferConfigDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferConfigDeliveryLessThanOrEqualTo(Integer value) {
            addCriterion("transfer_config_delivery <=", value, "transferConfigDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferConfigDeliveryIn(List<Integer> values) {
            addCriterion("transfer_config_delivery in", values, "transferConfigDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferConfigDeliveryNotIn(List<Integer> values) {
            addCriterion("transfer_config_delivery not in", values, "transferConfigDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferConfigDeliveryBetween(Integer value1, Integer value2) {
            addCriterion("transfer_config_delivery between", value1, value2, "transferConfigDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferConfigDeliveryNotBetween(Integer value1, Integer value2) {
            addCriterion("transfer_config_delivery not between", value1, value2, "transferConfigDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferBaleConfigDeliveryIsNull() {
            addCriterion("transfer_bale_config_delivery is null");
            return (Criteria) this;
        }

        public Criteria andTransferBaleConfigDeliveryIsNotNull() {
            addCriterion("transfer_bale_config_delivery is not null");
            return (Criteria) this;
        }

        public Criteria andTransferBaleConfigDeliveryEqualTo(Integer value) {
            addCriterion("transfer_bale_config_delivery =", value, "transferBaleConfigDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferBaleConfigDeliveryNotEqualTo(Integer value) {
            addCriterion("transfer_bale_config_delivery <>", value, "transferBaleConfigDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferBaleConfigDeliveryGreaterThan(Integer value) {
            addCriterion("transfer_bale_config_delivery >", value, "transferBaleConfigDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferBaleConfigDeliveryGreaterThanOrEqualTo(Integer value) {
            addCriterion("transfer_bale_config_delivery >=", value, "transferBaleConfigDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferBaleConfigDeliveryLessThan(Integer value) {
            addCriterion("transfer_bale_config_delivery <", value, "transferBaleConfigDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferBaleConfigDeliveryLessThanOrEqualTo(Integer value) {
            addCriterion("transfer_bale_config_delivery <=", value, "transferBaleConfigDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferBaleConfigDeliveryIn(List<Integer> values) {
            addCriterion("transfer_bale_config_delivery in", values, "transferBaleConfigDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferBaleConfigDeliveryNotIn(List<Integer> values) {
            addCriterion("transfer_bale_config_delivery not in", values, "transferBaleConfigDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferBaleConfigDeliveryBetween(Integer value1, Integer value2) {
            addCriterion("transfer_bale_config_delivery between", value1, value2, "transferBaleConfigDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferBaleConfigDeliveryNotBetween(Integer value1, Integer value2) {
            addCriterion("transfer_bale_config_delivery not between", value1, value2, "transferBaleConfigDelivery");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundConfigDeliveryIsNull() {
            addCriterion("abroad_inbound_config_delivery is null");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundConfigDeliveryIsNotNull() {
            addCriterion("abroad_inbound_config_delivery is not null");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundConfigDeliveryEqualTo(Integer value) {
            addCriterion("abroad_inbound_config_delivery =", value, "abroadInboundConfigDelivery");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundConfigDeliveryNotEqualTo(Integer value) {
            addCriterion("abroad_inbound_config_delivery <>", value, "abroadInboundConfigDelivery");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundConfigDeliveryGreaterThan(Integer value) {
            addCriterion("abroad_inbound_config_delivery >", value, "abroadInboundConfigDelivery");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundConfigDeliveryGreaterThanOrEqualTo(Integer value) {
            addCriterion("abroad_inbound_config_delivery >=", value, "abroadInboundConfigDelivery");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundConfigDeliveryLessThan(Integer value) {
            addCriterion("abroad_inbound_config_delivery <", value, "abroadInboundConfigDelivery");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundConfigDeliveryLessThanOrEqualTo(Integer value) {
            addCriterion("abroad_inbound_config_delivery <=", value, "abroadInboundConfigDelivery");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundConfigDeliveryIn(List<Integer> values) {
            addCriterion("abroad_inbound_config_delivery in", values, "abroadInboundConfigDelivery");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundConfigDeliveryNotIn(List<Integer> values) {
            addCriterion("abroad_inbound_config_delivery not in", values, "abroadInboundConfigDelivery");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundConfigDeliveryBetween(Integer value1, Integer value2) {
            addCriterion("abroad_inbound_config_delivery between", value1, value2, "abroadInboundConfigDelivery");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundConfigDeliveryNotBetween(Integer value1, Integer value2) {
            addCriterion("abroad_inbound_config_delivery not between", value1, value2, "abroadInboundConfigDelivery");
            return (Criteria) this;
        }

        public Criteria andInspectionConfigDeliveryIsNull() {
            addCriterion("inspection_config_delivery is null");
            return (Criteria) this;
        }

        public Criteria andInspectionConfigDeliveryIsNotNull() {
            addCriterion("inspection_config_delivery is not null");
            return (Criteria) this;
        }

        public Criteria andInspectionConfigDeliveryEqualTo(Integer value) {
            addCriterion("inspection_config_delivery =", value, "inspectionConfigDelivery");
            return (Criteria) this;
        }

        public Criteria andInspectionConfigDeliveryNotEqualTo(Integer value) {
            addCriterion("inspection_config_delivery <>", value, "inspectionConfigDelivery");
            return (Criteria) this;
        }

        public Criteria andInspectionConfigDeliveryGreaterThan(Integer value) {
            addCriterion("inspection_config_delivery >", value, "inspectionConfigDelivery");
            return (Criteria) this;
        }

        public Criteria andInspectionConfigDeliveryGreaterThanOrEqualTo(Integer value) {
            addCriterion("inspection_config_delivery >=", value, "inspectionConfigDelivery");
            return (Criteria) this;
        }

        public Criteria andInspectionConfigDeliveryLessThan(Integer value) {
            addCriterion("inspection_config_delivery <", value, "inspectionConfigDelivery");
            return (Criteria) this;
        }

        public Criteria andInspectionConfigDeliveryLessThanOrEqualTo(Integer value) {
            addCriterion("inspection_config_delivery <=", value, "inspectionConfigDelivery");
            return (Criteria) this;
        }

        public Criteria andInspectionConfigDeliveryIn(List<Integer> values) {
            addCriterion("inspection_config_delivery in", values, "inspectionConfigDelivery");
            return (Criteria) this;
        }

        public Criteria andInspectionConfigDeliveryNotIn(List<Integer> values) {
            addCriterion("inspection_config_delivery not in", values, "inspectionConfigDelivery");
            return (Criteria) this;
        }

        public Criteria andInspectionConfigDeliveryBetween(Integer value1, Integer value2) {
            addCriterion("inspection_config_delivery between", value1, value2, "inspectionConfigDelivery");
            return (Criteria) this;
        }

        public Criteria andInspectionConfigDeliveryNotBetween(Integer value1, Integer value2) {
            addCriterion("inspection_config_delivery not between", value1, value2, "inspectionConfigDelivery");
            return (Criteria) this;
        }

        public Criteria andInspectionDeliveryIsNull() {
            addCriterion("inspection_delivery is null");
            return (Criteria) this;
        }

        public Criteria andInspectionDeliveryIsNotNull() {
            addCriterion("inspection_delivery is not null");
            return (Criteria) this;
        }

        public Criteria andInspectionDeliveryEqualTo(Integer value) {
            addCriterion("inspection_delivery =", value, "inspectionDelivery");
            return (Criteria) this;
        }

        public Criteria andInspectionDeliveryNotEqualTo(Integer value) {
            addCriterion("inspection_delivery <>", value, "inspectionDelivery");
            return (Criteria) this;
        }

        public Criteria andInspectionDeliveryGreaterThan(Integer value) {
            addCriterion("inspection_delivery >", value, "inspectionDelivery");
            return (Criteria) this;
        }

        public Criteria andInspectionDeliveryGreaterThanOrEqualTo(Integer value) {
            addCriterion("inspection_delivery >=", value, "inspectionDelivery");
            return (Criteria) this;
        }

        public Criteria andInspectionDeliveryLessThan(Integer value) {
            addCriterion("inspection_delivery <", value, "inspectionDelivery");
            return (Criteria) this;
        }

        public Criteria andInspectionDeliveryLessThanOrEqualTo(Integer value) {
            addCriterion("inspection_delivery <=", value, "inspectionDelivery");
            return (Criteria) this;
        }

        public Criteria andInspectionDeliveryIn(List<Integer> values) {
            addCriterion("inspection_delivery in", values, "inspectionDelivery");
            return (Criteria) this;
        }

        public Criteria andInspectionDeliveryNotIn(List<Integer> values) {
            addCriterion("inspection_delivery not in", values, "inspectionDelivery");
            return (Criteria) this;
        }

        public Criteria andInspectionDeliveryBetween(Integer value1, Integer value2) {
            addCriterion("inspection_delivery between", value1, value2, "inspectionDelivery");
            return (Criteria) this;
        }

        public Criteria andInspectionDeliveryNotBetween(Integer value1, Integer value2) {
            addCriterion("inspection_delivery not between", value1, value2, "inspectionDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferDeliveryIsNull() {
            addCriterion("transfer_delivery is null");
            return (Criteria) this;
        }

        public Criteria andTransferDeliveryIsNotNull() {
            addCriterion("transfer_delivery is not null");
            return (Criteria) this;
        }

        public Criteria andTransferDeliveryEqualTo(Integer value) {
            addCriterion("transfer_delivery =", value, "transferDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferDeliveryNotEqualTo(Integer value) {
            addCriterion("transfer_delivery <>", value, "transferDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferDeliveryGreaterThan(Integer value) {
            addCriterion("transfer_delivery >", value, "transferDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferDeliveryGreaterThanOrEqualTo(Integer value) {
            addCriterion("transfer_delivery >=", value, "transferDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferDeliveryLessThan(Integer value) {
            addCriterion("transfer_delivery <", value, "transferDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferDeliveryLessThanOrEqualTo(Integer value) {
            addCriterion("transfer_delivery <=", value, "transferDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferDeliveryIn(List<Integer> values) {
            addCriterion("transfer_delivery in", values, "transferDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferDeliveryNotIn(List<Integer> values) {
            addCriterion("transfer_delivery not in", values, "transferDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferDeliveryBetween(Integer value1, Integer value2) {
            addCriterion("transfer_delivery between", value1, value2, "transferDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferDeliveryNotBetween(Integer value1, Integer value2) {
            addCriterion("transfer_delivery not between", value1, value2, "transferDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferDeliverySourceIsNull() {
            addCriterion("transfer_delivery_source is null");
            return (Criteria) this;
        }

        public Criteria andTransferDeliverySourceIsNotNull() {
            addCriterion("transfer_delivery_source is not null");
            return (Criteria) this;
        }

        public Criteria andTransferDeliverySourceEqualTo(String value) {
            addCriterion("transfer_delivery_source =", value, "transferDeliverySource");
            return (Criteria) this;
        }

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

        public Criteria andTransferDeliverySourceGreaterThan(String value) {
            addCriterion("transfer_delivery_source >", value, "transferDeliverySource");
            return (Criteria) this;
        }

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

        public Criteria andTransferDeliverySourceLessThan(String value) {
            addCriterion("transfer_delivery_source <", value, "transferDeliverySource");
            return (Criteria) this;
        }

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

        public Criteria andTransferDeliverySourceLike(String value) {
            addCriterion("transfer_delivery_source like", value, "transferDeliverySource");
            return (Criteria) this;
        }

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

        public Criteria andTransferDeliverySourceIn(List<String> values) {
            addCriterion("transfer_delivery_source in", values, "transferDeliverySource");
            return (Criteria) this;
        }

        public Criteria andTransferDeliverySourceNotIn(List<String> values) {
            addCriterion("transfer_delivery_source not in", values, "transferDeliverySource");
            return (Criteria) this;
        }

        public Criteria andTransferDeliverySourceBetween(String value1, String value2) {
            addCriterion("transfer_delivery_source between", value1, value2, "transferDeliverySource");
            return (Criteria) this;
        }

        public Criteria andTransferDeliverySourceNotBetween(String value1, String value2) {
            addCriterion("transfer_delivery_source not between", value1, value2, "transferDeliverySource");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliveryIsNull() {
            addCriterion("transfer_bale_delivery is null");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliveryIsNotNull() {
            addCriterion("transfer_bale_delivery is not null");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliveryEqualTo(Integer value) {
            addCriterion("transfer_bale_delivery =", value, "transferBaleDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliveryNotEqualTo(Integer value) {
            addCriterion("transfer_bale_delivery <>", value, "transferBaleDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliveryGreaterThan(Integer value) {
            addCriterion("transfer_bale_delivery >", value, "transferBaleDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliveryGreaterThanOrEqualTo(Integer value) {
            addCriterion("transfer_bale_delivery >=", value, "transferBaleDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliveryLessThan(Integer value) {
            addCriterion("transfer_bale_delivery <", value, "transferBaleDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliveryLessThanOrEqualTo(Integer value) {
            addCriterion("transfer_bale_delivery <=", value, "transferBaleDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliveryIn(List<Integer> values) {
            addCriterion("transfer_bale_delivery in", values, "transferBaleDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliveryNotIn(List<Integer> values) {
            addCriterion("transfer_bale_delivery not in", values, "transferBaleDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliveryBetween(Integer value1, Integer value2) {
            addCriterion("transfer_bale_delivery between", value1, value2, "transferBaleDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliveryNotBetween(Integer value1, Integer value2) {
            addCriterion("transfer_bale_delivery not between", value1, value2, "transferBaleDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliverySourceIsNull() {
            addCriterion("transfer_bale_delivery_source is null");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliverySourceIsNotNull() {
            addCriterion("transfer_bale_delivery_source is not null");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliverySourceEqualTo(String value) {
            addCriterion("transfer_bale_delivery_source =", value, "transferBaleDeliverySource");
            return (Criteria) this;
        }

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

        public Criteria andTransferBaleDeliverySourceGreaterThan(String value) {
            addCriterion("transfer_bale_delivery_source >", value, "transferBaleDeliverySource");
            return (Criteria) this;
        }

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

        public Criteria andTransferBaleDeliverySourceLessThan(String value) {
            addCriterion("transfer_bale_delivery_source <", value, "transferBaleDeliverySource");
            return (Criteria) this;
        }

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

        public Criteria andTransferBaleDeliverySourceLike(String value) {
            addCriterion("transfer_bale_delivery_source like", value, "transferBaleDeliverySource");
            return (Criteria) this;
        }

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

        public Criteria andTransferBaleDeliverySourceIn(List<String> values) {
            addCriterion("transfer_bale_delivery_source in", values, "transferBaleDeliverySource");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliverySourceNotIn(List<String> values) {
            addCriterion("transfer_bale_delivery_source not in", values, "transferBaleDeliverySource");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliverySourceBetween(String value1, String value2) {
            addCriterion("transfer_bale_delivery_source between", value1, value2, "transferBaleDeliverySource");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliverySourceNotBetween(String value1, String value2) {
            addCriterion("transfer_bale_delivery_source not between", value1, value2, "transferBaleDeliverySource");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliveryIsNull() {
            addCriterion("abroad_inbound_delivery is null");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliveryIsNotNull() {
            addCriterion("abroad_inbound_delivery is not null");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliveryEqualTo(Integer value) {
            addCriterion("abroad_inbound_delivery =", value, "abroadInboundDelivery");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliveryNotEqualTo(Integer value) {
            addCriterion("abroad_inbound_delivery <>", value, "abroadInboundDelivery");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliveryGreaterThan(Integer value) {
            addCriterion("abroad_inbound_delivery >", value, "abroadInboundDelivery");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliveryGreaterThanOrEqualTo(Integer value) {
            addCriterion("abroad_inbound_delivery >=", value, "abroadInboundDelivery");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliveryLessThan(Integer value) {
            addCriterion("abroad_inbound_delivery <", value, "abroadInboundDelivery");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliveryLessThanOrEqualTo(Integer value) {
            addCriterion("abroad_inbound_delivery <=", value, "abroadInboundDelivery");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliveryIn(List<Integer> values) {
            addCriterion("abroad_inbound_delivery in", values, "abroadInboundDelivery");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliveryNotIn(List<Integer> values) {
            addCriterion("abroad_inbound_delivery not in", values, "abroadInboundDelivery");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliveryBetween(Integer value1, Integer value2) {
            addCriterion("abroad_inbound_delivery between", value1, value2, "abroadInboundDelivery");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliveryNotBetween(Integer value1, Integer value2) {
            addCriterion("abroad_inbound_delivery not between", value1, value2, "abroadInboundDelivery");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliverySourceIsNull() {
            addCriterion("abroad_inbound_delivery_source is null");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliverySourceIsNotNull() {
            addCriterion("abroad_inbound_delivery_source is not null");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliverySourceEqualTo(String value) {
            addCriterion("abroad_inbound_delivery_source =", value, "abroadInboundDeliverySource");
            return (Criteria) this;
        }

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

        public Criteria andAbroadInboundDeliverySourceGreaterThan(String value) {
            addCriterion("abroad_inbound_delivery_source >", value, "abroadInboundDeliverySource");
            return (Criteria) this;
        }

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

        public Criteria andAbroadInboundDeliverySourceLessThan(String value) {
            addCriterion("abroad_inbound_delivery_source <", value, "abroadInboundDeliverySource");
            return (Criteria) this;
        }

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

        public Criteria andAbroadInboundDeliverySourceLike(String value) {
            addCriterion("abroad_inbound_delivery_source like", value, "abroadInboundDeliverySource");
            return (Criteria) this;
        }

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

        public Criteria andAbroadInboundDeliverySourceIn(List<String> values) {
            addCriterion("abroad_inbound_delivery_source in", values, "abroadInboundDeliverySource");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliverySourceNotIn(List<String> values) {
            addCriterion("abroad_inbound_delivery_source not in", values, "abroadInboundDeliverySource");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliverySourceBetween(String value1, String value2) {
            addCriterion("abroad_inbound_delivery_source between", value1, value2, "abroadInboundDeliverySource");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliverySourceNotBetween(String value1, String value2) {
            addCriterion("abroad_inbound_delivery_source not between", value1, value2, "abroadInboundDeliverySource");
            return (Criteria) this;
        }

        public Criteria andSupplementarySalesIsNull() {
            addCriterion("supplementary_sales is null");
            return (Criteria) this;
        }

        public Criteria andSupplementarySalesIsNotNull() {
            addCriterion("supplementary_sales is not null");
            return (Criteria) this;
        }

        public Criteria andSupplementarySalesEqualTo(BigDecimal value) {
            addCriterion("supplementary_sales =", value, "supplementarySales");
            return (Criteria) this;
        }

        public Criteria andSupplementarySalesNotEqualTo(BigDecimal value) {
            addCriterion("supplementary_sales <>", value, "supplementarySales");
            return (Criteria) this;
        }

        public Criteria andSupplementarySalesGreaterThan(BigDecimal value) {
            addCriterion("supplementary_sales >", value, "supplementarySales");
            return (Criteria) this;
        }

        public Criteria andSupplementarySalesGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("supplementary_sales >=", value, "supplementarySales");
            return (Criteria) this;
        }

        public Criteria andSupplementarySalesLessThan(BigDecimal value) {
            addCriterion("supplementary_sales <", value, "supplementarySales");
            return (Criteria) this;
        }

        public Criteria andSupplementarySalesLessThanOrEqualTo(BigDecimal value) {
            addCriterion("supplementary_sales <=", value, "supplementarySales");
            return (Criteria) this;
        }

        public Criteria andSupplementarySalesIn(List<BigDecimal> values) {
            addCriterion("supplementary_sales in", values, "supplementarySales");
            return (Criteria) this;
        }

        public Criteria andSupplementarySalesNotIn(List<BigDecimal> values) {
            addCriterion("supplementary_sales not in", values, "supplementarySales");
            return (Criteria) this;
        }

        public Criteria andSupplementarySalesBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("supplementary_sales between", value1, value2, "supplementarySales");
            return (Criteria) this;
        }

        public Criteria andSupplementarySalesNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("supplementary_sales not between", value1, value2, "supplementarySales");
            return (Criteria) this;
        }

        public Criteria andTurnoverSalesIsNull() {
            addCriterion("turnover_sales is null");
            return (Criteria) this;
        }

        public Criteria andTurnoverSalesIsNotNull() {
            addCriterion("turnover_sales is not null");
            return (Criteria) this;
        }

        public Criteria andTurnoverSalesEqualTo(BigDecimal value) {
            addCriterion("turnover_sales =", value, "turnoverSales");
            return (Criteria) this;
        }

        public Criteria andTurnoverSalesNotEqualTo(BigDecimal value) {
            addCriterion("turnover_sales <>", value, "turnoverSales");
            return (Criteria) this;
        }

        public Criteria andTurnoverSalesGreaterThan(BigDecimal value) {
            addCriterion("turnover_sales >", value, "turnoverSales");
            return (Criteria) this;
        }

        public Criteria andTurnoverSalesGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("turnover_sales >=", value, "turnoverSales");
            return (Criteria) this;
        }

        public Criteria andTurnoverSalesLessThan(BigDecimal value) {
            addCriterion("turnover_sales <", value, "turnoverSales");
            return (Criteria) this;
        }

        public Criteria andTurnoverSalesLessThanOrEqualTo(BigDecimal value) {
            addCriterion("turnover_sales <=", value, "turnoverSales");
            return (Criteria) this;
        }

        public Criteria andTurnoverSalesIn(List<BigDecimal> values) {
            addCriterion("turnover_sales in", values, "turnoverSales");
            return (Criteria) this;
        }

        public Criteria andTurnoverSalesNotIn(List<BigDecimal> values) {
            addCriterion("turnover_sales not in", values, "turnoverSales");
            return (Criteria) this;
        }

        public Criteria andTurnoverSalesBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("turnover_sales between", value1, value2, "turnoverSales");
            return (Criteria) this;
        }

        public Criteria andTurnoverSalesNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("turnover_sales not between", value1, value2, "turnoverSales");
            return (Criteria) this;
        }

        public Criteria andTurnoverInboundIsNull() {
            addCriterion("turnover_inbound is null");
            return (Criteria) this;
        }

        public Criteria andTurnoverInboundIsNotNull() {
            addCriterion("turnover_inbound is not null");
            return (Criteria) this;
        }

        public Criteria andTurnoverInboundEqualTo(BigDecimal value) {
            addCriterion("turnover_inbound =", value, "turnoverInbound");
            return (Criteria) this;
        }

        public Criteria andTurnoverInboundNotEqualTo(BigDecimal value) {
            addCriterion("turnover_inbound <>", value, "turnoverInbound");
            return (Criteria) this;
        }

        public Criteria andTurnoverInboundGreaterThan(BigDecimal value) {
            addCriterion("turnover_inbound >", value, "turnoverInbound");
            return (Criteria) this;
        }

        public Criteria andTurnoverInboundGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("turnover_inbound >=", value, "turnoverInbound");
            return (Criteria) this;
        }

        public Criteria andTurnoverInboundLessThan(BigDecimal value) {
            addCriterion("turnover_inbound <", value, "turnoverInbound");
            return (Criteria) this;
        }

        public Criteria andTurnoverInboundLessThanOrEqualTo(BigDecimal value) {
            addCriterion("turnover_inbound <=", value, "turnoverInbound");
            return (Criteria) this;
        }

        public Criteria andTurnoverInboundIn(List<BigDecimal> values) {
            addCriterion("turnover_inbound in", values, "turnoverInbound");
            return (Criteria) this;
        }

        public Criteria andTurnoverInboundNotIn(List<BigDecimal> values) {
            addCriterion("turnover_inbound not in", values, "turnoverInbound");
            return (Criteria) this;
        }

        public Criteria andTurnoverInboundBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("turnover_inbound between", value1, value2, "turnoverInbound");
            return (Criteria) this;
        }

        public Criteria andTurnoverInboundNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("turnover_inbound not between", value1, value2, "turnoverInbound");
            return (Criteria) this;
        }

        public Criteria andHistorySevendaySalesIsNull() {
            addCriterion("history_sevenday_sales is null");
            return (Criteria) this;
        }

        public Criteria andHistorySevendaySalesIsNotNull() {
            addCriterion("history_sevenday_sales is not null");
            return (Criteria) this;
        }

        public Criteria andHistorySevendaySalesEqualTo(BigDecimal value) {
            addCriterion("history_sevenday_sales =", value, "historySevendaySales");
            return (Criteria) this;
        }

        public Criteria andHistorySevendaySalesNotEqualTo(BigDecimal value) {
            addCriterion("history_sevenday_sales <>", value, "historySevendaySales");
            return (Criteria) this;
        }

        public Criteria andHistorySevendaySalesGreaterThan(BigDecimal value) {
            addCriterion("history_sevenday_sales >", value, "historySevendaySales");
            return (Criteria) this;
        }

        public Criteria andHistorySevendaySalesGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("history_sevenday_sales >=", value, "historySevendaySales");
            return (Criteria) this;
        }

        public Criteria andHistorySevendaySalesLessThan(BigDecimal value) {
            addCriterion("history_sevenday_sales <", value, "historySevendaySales");
            return (Criteria) this;
        }

        public Criteria andHistorySevendaySalesLessThanOrEqualTo(BigDecimal value) {
            addCriterion("history_sevenday_sales <=", value, "historySevendaySales");
            return (Criteria) this;
        }

        public Criteria andHistorySevendaySalesIn(List<BigDecimal> values) {
            addCriterion("history_sevenday_sales in", values, "historySevendaySales");
            return (Criteria) this;
        }

        public Criteria andHistorySevendaySalesNotIn(List<BigDecimal> values) {
            addCriterion("history_sevenday_sales not in", values, "historySevendaySales");
            return (Criteria) this;
        }

        public Criteria andHistorySevendaySalesBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("history_sevenday_sales between", value1, value2, "historySevendaySales");
            return (Criteria) this;
        }

        public Criteria andHistorySevendaySalesNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("history_sevenday_sales not between", value1, value2, "historySevendaySales");
            return (Criteria) this;
        }

        public Criteria andHistoryFourteendaySalesIsNull() {
            addCriterion("history_fourteenday_sales is null");
            return (Criteria) this;
        }

        public Criteria andHistoryFourteendaySalesIsNotNull() {
            addCriterion("history_fourteenday_sales is not null");
            return (Criteria) this;
        }

        public Criteria andHistoryFourteendaySalesEqualTo(BigDecimal value) {
            addCriterion("history_fourteenday_sales =", value, "historyFourteendaySales");
            return (Criteria) this;
        }

        public Criteria andHistoryFourteendaySalesNotEqualTo(BigDecimal value) {
            addCriterion("history_fourteenday_sales <>", value, "historyFourteendaySales");
            return (Criteria) this;
        }

        public Criteria andHistoryFourteendaySalesGreaterThan(BigDecimal value) {
            addCriterion("history_fourteenday_sales >", value, "historyFourteendaySales");
            return (Criteria) this;
        }

        public Criteria andHistoryFourteendaySalesGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("history_fourteenday_sales >=", value, "historyFourteendaySales");
            return (Criteria) this;
        }

        public Criteria andHistoryFourteendaySalesLessThan(BigDecimal value) {
            addCriterion("history_fourteenday_sales <", value, "historyFourteendaySales");
            return (Criteria) this;
        }

        public Criteria andHistoryFourteendaySalesLessThanOrEqualTo(BigDecimal value) {
            addCriterion("history_fourteenday_sales <=", value, "historyFourteendaySales");
            return (Criteria) this;
        }

        public Criteria andHistoryFourteendaySalesIn(List<BigDecimal> values) {
            addCriterion("history_fourteenday_sales in", values, "historyFourteendaySales");
            return (Criteria) this;
        }

        public Criteria andHistoryFourteendaySalesNotIn(List<BigDecimal> values) {
            addCriterion("history_fourteenday_sales not in", values, "historyFourteendaySales");
            return (Criteria) this;
        }

        public Criteria andHistoryFourteendaySalesBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("history_fourteenday_sales between", value1, value2, "historyFourteendaySales");
            return (Criteria) this;
        }

        public Criteria andHistoryFourteendaySalesNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("history_fourteenday_sales not between", value1, value2, "historyFourteendaySales");
            return (Criteria) this;
        }

        public Criteria andHistoryThirtydaySalesIsNull() {
            addCriterion("history_thirtyday_sales is null");
            return (Criteria) this;
        }

        public Criteria andHistoryThirtydaySalesIsNotNull() {
            addCriterion("history_thirtyday_sales is not null");
            return (Criteria) this;
        }

        public Criteria andHistoryThirtydaySalesEqualTo(BigDecimal value) {
            addCriterion("history_thirtyday_sales =", value, "historyThirtydaySales");
            return (Criteria) this;
        }

        public Criteria andHistoryThirtydaySalesNotEqualTo(BigDecimal value) {
            addCriterion("history_thirtyday_sales <>", value, "historyThirtydaySales");
            return (Criteria) this;
        }

        public Criteria andHistoryThirtydaySalesGreaterThan(BigDecimal value) {
            addCriterion("history_thirtyday_sales >", value, "historyThirtydaySales");
            return (Criteria) this;
        }

        public Criteria andHistoryThirtydaySalesGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("history_thirtyday_sales >=", value, "historyThirtydaySales");
            return (Criteria) this;
        }

        public Criteria andHistoryThirtydaySalesLessThan(BigDecimal value) {
            addCriterion("history_thirtyday_sales <", value, "historyThirtydaySales");
            return (Criteria) this;
        }

        public Criteria andHistoryThirtydaySalesLessThanOrEqualTo(BigDecimal value) {
            addCriterion("history_thirtyday_sales <=", value, "historyThirtydaySales");
            return (Criteria) this;
        }

        public Criteria andHistoryThirtydaySalesIn(List<BigDecimal> values) {
            addCriterion("history_thirtyday_sales in", values, "historyThirtydaySales");
            return (Criteria) this;
        }

        public Criteria andHistoryThirtydaySalesNotIn(List<BigDecimal> values) {
            addCriterion("history_thirtyday_sales not in", values, "historyThirtydaySales");
            return (Criteria) this;
        }

        public Criteria andHistoryThirtydaySalesBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("history_thirtyday_sales between", value1, value2, "historyThirtydaySales");
            return (Criteria) this;
        }

        public Criteria andHistoryThirtydaySalesNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("history_thirtyday_sales not between", value1, value2, "historyThirtydaySales");
            return (Criteria) this;
        }

        public Criteria andSalesExplainDetailsIsNull() {
            addCriterion("sales_explain_details is null");
            return (Criteria) this;
        }

        public Criteria andSalesExplainDetailsIsNotNull() {
            addCriterion("sales_explain_details is not null");
            return (Criteria) this;
        }

        public Criteria andSalesExplainDetailsEqualTo(String value) {
            addCriterion("sales_explain_details =", value, "salesExplainDetails");
            return (Criteria) this;
        }

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

        public Criteria andSalesExplainDetailsGreaterThan(String value) {
            addCriterion("sales_explain_details >", value, "salesExplainDetails");
            return (Criteria) this;
        }

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

        public Criteria andSalesExplainDetailsLessThan(String value) {
            addCriterion("sales_explain_details <", value, "salesExplainDetails");
            return (Criteria) this;
        }

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

        public Criteria andSalesExplainDetailsLike(String value) {
            addCriterion("sales_explain_details like", value, "salesExplainDetails");
            return (Criteria) this;
        }

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

        public Criteria andSalesExplainDetailsIn(List<String> values) {
            addCriterion("sales_explain_details in", values, "salesExplainDetails");
            return (Criteria) this;
        }

        public Criteria andSalesExplainDetailsNotIn(List<String> values) {
            addCriterion("sales_explain_details not in", values, "salesExplainDetails");
            return (Criteria) this;
        }

        public Criteria andSalesExplainDetailsBetween(String value1, String value2) {
            addCriterion("sales_explain_details between", value1, value2, "salesExplainDetails");
            return (Criteria) this;
        }

        public Criteria andSalesExplainDetailsNotBetween(String value1, String value2) {
            addCriterion("sales_explain_details not between", value1, value2, "salesExplainDetails");
            return (Criteria) this;
        }

        public Criteria andForecastTurnoverdaySalesIsNull() {
            addCriterion("forecast_turnoverday_sales is null");
            return (Criteria) this;
        }

        public Criteria andForecastTurnoverdaySalesIsNotNull() {
            addCriterion("forecast_turnoverday_sales is not null");
            return (Criteria) this;
        }

        public Criteria andForecastTurnoverdaySalesEqualTo(BigDecimal value) {
            addCriterion("forecast_turnoverday_sales =", value, "forecastTurnoverdaySales");
            return (Criteria) this;
        }

        public Criteria andForecastTurnoverdaySalesNotEqualTo(BigDecimal value) {
            addCriterion("forecast_turnoverday_sales <>", value, "forecastTurnoverdaySales");
            return (Criteria) this;
        }

        public Criteria andForecastTurnoverdaySalesGreaterThan(BigDecimal value) {
            addCriterion("forecast_turnoverday_sales >", value, "forecastTurnoverdaySales");
            return (Criteria) this;
        }

        public Criteria andForecastTurnoverdaySalesGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("forecast_turnoverday_sales >=", value, "forecastTurnoverdaySales");
            return (Criteria) this;
        }

        public Criteria andForecastTurnoverdaySalesLessThan(BigDecimal value) {
            addCriterion("forecast_turnoverday_sales <", value, "forecastTurnoverdaySales");
            return (Criteria) this;
        }

        public Criteria andForecastTurnoverdaySalesLessThanOrEqualTo(BigDecimal value) {
            addCriterion("forecast_turnoverday_sales <=", value, "forecastTurnoverdaySales");
            return (Criteria) this;
        }

        public Criteria andForecastTurnoverdaySalesIn(List<BigDecimal> values) {
            addCriterion("forecast_turnoverday_sales in", values, "forecastTurnoverdaySales");
            return (Criteria) this;
        }

        public Criteria andForecastTurnoverdaySalesNotIn(List<BigDecimal> values) {
            addCriterion("forecast_turnoverday_sales not in", values, "forecastTurnoverdaySales");
            return (Criteria) this;
        }

        public Criteria andForecastTurnoverdaySalesBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("forecast_turnoverday_sales between", value1, value2, "forecastTurnoverdaySales");
            return (Criteria) this;
        }

        public Criteria andForecastTurnoverdaySalesNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("forecast_turnoverday_sales not between", value1, value2, "forecastTurnoverdaySales");
            return (Criteria) this;
        }

        public Criteria andStockUpSalesIsNull() {
            addCriterion("stock_up_sales is null");
            return (Criteria) this;
        }

        public Criteria andStockUpSalesIsNotNull() {
            addCriterion("stock_up_sales is not null");
            return (Criteria) this;
        }

        public Criteria andStockUpSalesEqualTo(BigDecimal value) {
            addCriterion("stock_up_sales =", value, "stockUpSales");
            return (Criteria) this;
        }

        public Criteria andStockUpSalesNotEqualTo(BigDecimal value) {
            addCriterion("stock_up_sales <>", value, "stockUpSales");
            return (Criteria) this;
        }

        public Criteria andStockUpSalesGreaterThan(BigDecimal value) {
            addCriterion("stock_up_sales >", value, "stockUpSales");
            return (Criteria) this;
        }

        public Criteria andStockUpSalesGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("stock_up_sales >=", value, "stockUpSales");
            return (Criteria) this;
        }

        public Criteria andStockUpSalesLessThan(BigDecimal value) {
            addCriterion("stock_up_sales <", value, "stockUpSales");
            return (Criteria) this;
        }

        public Criteria andStockUpSalesLessThanOrEqualTo(BigDecimal value) {
            addCriterion("stock_up_sales <=", value, "stockUpSales");
            return (Criteria) this;
        }

        public Criteria andStockUpSalesIn(List<BigDecimal> values) {
            addCriterion("stock_up_sales in", values, "stockUpSales");
            return (Criteria) this;
        }

        public Criteria andStockUpSalesNotIn(List<BigDecimal> values) {
            addCriterion("stock_up_sales not in", values, "stockUpSales");
            return (Criteria) this;
        }

        public Criteria andStockUpSalesBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("stock_up_sales between", value1, value2, "stockUpSales");
            return (Criteria) this;
        }

        public Criteria andStockUpSalesNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("stock_up_sales not between", value1, value2, "stockUpSales");
            return (Criteria) this;
        }

        public Criteria andQuantityBeginAdviseIsNull() {
            addCriterion("quantity_begin_advise is null");
            return (Criteria) this;
        }

        public Criteria andQuantityBeginAdviseIsNotNull() {
            addCriterion("quantity_begin_advise is not null");
            return (Criteria) this;
        }

        public Criteria andQuantityBeginAdviseEqualTo(BigDecimal value) {
            addCriterion("quantity_begin_advise =", value, "quantityBeginAdvise");
            return (Criteria) this;
        }

        public Criteria andQuantityBeginAdviseNotEqualTo(BigDecimal value) {
            addCriterion("quantity_begin_advise <>", value, "quantityBeginAdvise");
            return (Criteria) this;
        }

        public Criteria andQuantityBeginAdviseGreaterThan(BigDecimal value) {
            addCriterion("quantity_begin_advise >", value, "quantityBeginAdvise");
            return (Criteria) this;
        }

        public Criteria andQuantityBeginAdviseGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("quantity_begin_advise >=", value, "quantityBeginAdvise");
            return (Criteria) this;
        }

        public Criteria andQuantityBeginAdviseLessThan(BigDecimal value) {
            addCriterion("quantity_begin_advise <", value, "quantityBeginAdvise");
            return (Criteria) this;
        }

        public Criteria andQuantityBeginAdviseLessThanOrEqualTo(BigDecimal value) {
            addCriterion("quantity_begin_advise <=", value, "quantityBeginAdvise");
            return (Criteria) this;
        }

        public Criteria andQuantityBeginAdviseIn(List<BigDecimal> values) {
            addCriterion("quantity_begin_advise in", values, "quantityBeginAdvise");
            return (Criteria) this;
        }

        public Criteria andQuantityBeginAdviseNotIn(List<BigDecimal> values) {
            addCriterion("quantity_begin_advise not in", values, "quantityBeginAdvise");
            return (Criteria) this;
        }

        public Criteria andQuantityBeginAdviseBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("quantity_begin_advise between", value1, value2, "quantityBeginAdvise");
            return (Criteria) this;
        }

        public Criteria andQuantityBeginAdviseNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("quantity_begin_advise not between", value1, value2, "quantityBeginAdvise");
            return (Criteria) this;
        }

        public Criteria andStockUpDaysIsNull() {
            addCriterion("stock_up_days is null");
            return (Criteria) this;
        }

        public Criteria andStockUpDaysIsNotNull() {
            addCriterion("stock_up_days is not null");
            return (Criteria) this;
        }

        public Criteria andStockUpDaysEqualTo(Integer value) {
            addCriterion("stock_up_days =", value, "stockUpDays");
            return (Criteria) this;
        }

        public Criteria andStockUpDaysNotEqualTo(Integer value) {
            addCriterion("stock_up_days <>", value, "stockUpDays");
            return (Criteria) this;
        }

        public Criteria andStockUpDaysGreaterThan(Integer value) {
            addCriterion("stock_up_days >", value, "stockUpDays");
            return (Criteria) this;
        }

        public Criteria andStockUpDaysGreaterThanOrEqualTo(Integer value) {
            addCriterion("stock_up_days >=", value, "stockUpDays");
            return (Criteria) this;
        }

        public Criteria andStockUpDaysLessThan(Integer value) {
            addCriterion("stock_up_days <", value, "stockUpDays");
            return (Criteria) this;
        }

        public Criteria andStockUpDaysLessThanOrEqualTo(Integer value) {
            addCriterion("stock_up_days <=", value, "stockUpDays");
            return (Criteria) this;
        }

        public Criteria andStockUpDaysIn(List<Integer> values) {
            addCriterion("stock_up_days in", values, "stockUpDays");
            return (Criteria) this;
        }

        public Criteria andStockUpDaysNotIn(List<Integer> values) {
            addCriterion("stock_up_days not in", values, "stockUpDays");
            return (Criteria) this;
        }

        public Criteria andStockUpDaysBetween(Integer value1, Integer value2) {
            addCriterion("stock_up_days between", value1, value2, "stockUpDays");
            return (Criteria) this;
        }

        public Criteria andStockUpDaysNotBetween(Integer value1, Integer value2) {
            addCriterion("stock_up_days not between", value1, value2, "stockUpDays");
            return (Criteria) this;
        }

        public Criteria andPaymentBeforeDeliveryIsNull() {
            addCriterion("payment_before_delivery is null");
            return (Criteria) this;
        }

        public Criteria andPaymentBeforeDeliveryIsNotNull() {
            addCriterion("payment_before_delivery is not null");
            return (Criteria) this;
        }

        public Criteria andPaymentBeforeDeliveryEqualTo(Integer value) {
            addCriterion("payment_before_delivery =", value, "paymentBeforeDelivery");
            return (Criteria) this;
        }

        public Criteria andPaymentBeforeDeliveryNotEqualTo(Integer value) {
            addCriterion("payment_before_delivery <>", value, "paymentBeforeDelivery");
            return (Criteria) this;
        }

        public Criteria andPaymentBeforeDeliveryGreaterThan(Integer value) {
            addCriterion("payment_before_delivery >", value, "paymentBeforeDelivery");
            return (Criteria) this;
        }

        public Criteria andPaymentBeforeDeliveryGreaterThanOrEqualTo(Integer value) {
            addCriterion("payment_before_delivery >=", value, "paymentBeforeDelivery");
            return (Criteria) this;
        }

        public Criteria andPaymentBeforeDeliveryLessThan(Integer value) {
            addCriterion("payment_before_delivery <", value, "paymentBeforeDelivery");
            return (Criteria) this;
        }

        public Criteria andPaymentBeforeDeliveryLessThanOrEqualTo(Integer value) {
            addCriterion("payment_before_delivery <=", value, "paymentBeforeDelivery");
            return (Criteria) this;
        }

        public Criteria andPaymentBeforeDeliveryIn(List<Integer> values) {
            addCriterion("payment_before_delivery in", values, "paymentBeforeDelivery");
            return (Criteria) this;
        }

        public Criteria andPaymentBeforeDeliveryNotIn(List<Integer> values) {
            addCriterion("payment_before_delivery not in", values, "paymentBeforeDelivery");
            return (Criteria) this;
        }

        public Criteria andPaymentBeforeDeliveryBetween(Integer value1, Integer value2) {
            addCriterion("payment_before_delivery between", value1, value2, "paymentBeforeDelivery");
            return (Criteria) this;
        }

        public Criteria andPaymentBeforeDeliveryNotBetween(Integer value1, Integer value2) {
            addCriterion("payment_before_delivery not between", value1, value2, "paymentBeforeDelivery");
            return (Criteria) this;
        }

        public Criteria andProductCodeIsNull() {
            addCriterion("product_code is null");
            return (Criteria) this;
        }

        public Criteria andProductCodeIsNotNull() {
            addCriterion("product_code is not null");
            return (Criteria) this;
        }

        public Criteria andProductCodeEqualTo(String value) {
            addCriterion("product_code =", value, "productCode");
            return (Criteria) this;
        }

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

        public Criteria andProductCodeGreaterThan(String value) {
            addCriterion("product_code >", value, "productCode");
            return (Criteria) this;
        }

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

        public Criteria andProductCodeLessThan(String value) {
            addCriterion("product_code <", value, "productCode");
            return (Criteria) this;
        }

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

        public Criteria andProductCodeLike(String value) {
            addCriterion("product_code like", value, "productCode");
            return (Criteria) this;
        }

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

        public Criteria andProductCodeIn(List<String> values) {
            addCriterion("product_code in", values, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeNotIn(List<String> values) {
            addCriterion("product_code not in", values, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeBetween(String value1, String value2) {
            addCriterion("product_code between", value1, value2, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeNotBetween(String value1, String value2) {
            addCriterion("product_code not between", value1, value2, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductInnerCodeIsNull() {
            addCriterion("product_inner_code is null");
            return (Criteria) this;
        }

        public Criteria andProductInnerCodeIsNotNull() {
            addCriterion("product_inner_code is not null");
            return (Criteria) this;
        }

        public Criteria andProductInnerCodeEqualTo(String value) {
            addCriterion("product_inner_code =", value, "productInnerCode");
            return (Criteria) this;
        }

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

        public Criteria andProductInnerCodeGreaterThan(String value) {
            addCriterion("product_inner_code >", value, "productInnerCode");
            return (Criteria) this;
        }

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

        public Criteria andProductInnerCodeLessThan(String value) {
            addCriterion("product_inner_code <", value, "productInnerCode");
            return (Criteria) this;
        }

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

        public Criteria andProductInnerCodeLike(String value) {
            addCriterion("product_inner_code like", value, "productInnerCode");
            return (Criteria) this;
        }

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

        public Criteria andProductInnerCodeIn(List<String> values) {
            addCriterion("product_inner_code in", values, "productInnerCode");
            return (Criteria) this;
        }

        public Criteria andProductInnerCodeNotIn(List<String> values) {
            addCriterion("product_inner_code not in", values, "productInnerCode");
            return (Criteria) this;
        }

        public Criteria andProductInnerCodeBetween(String value1, String value2) {
            addCriterion("product_inner_code between", value1, value2, "productInnerCode");
            return (Criteria) this;
        }

        public Criteria andProductInnerCodeNotBetween(String value1, String value2) {
            addCriterion("product_inner_code not between", value1, value2, "productInnerCode");
            return (Criteria) this;
        }

        public Criteria andBailunCategoryIdIsNull() {
            addCriterion("bailun_category_id is null");
            return (Criteria) this;
        }

        public Criteria andBailunCategoryIdIsNotNull() {
            addCriterion("bailun_category_id is not null");
            return (Criteria) this;
        }

        public Criteria andBailunCategoryIdEqualTo(Integer value) {
            addCriterion("bailun_category_id =", value, "bailunCategoryId");
            return (Criteria) this;
        }

        public Criteria andBailunCategoryIdNotEqualTo(Integer value) {
            addCriterion("bailun_category_id <>", value, "bailunCategoryId");
            return (Criteria) this;
        }

        public Criteria andBailunCategoryIdGreaterThan(Integer value) {
            addCriterion("bailun_category_id >", value, "bailunCategoryId");
            return (Criteria) this;
        }

        public Criteria andBailunCategoryIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("bailun_category_id >=", value, "bailunCategoryId");
            return (Criteria) this;
        }

        public Criteria andBailunCategoryIdLessThan(Integer value) {
            addCriterion("bailun_category_id <", value, "bailunCategoryId");
            return (Criteria) this;
        }

        public Criteria andBailunCategoryIdLessThanOrEqualTo(Integer value) {
            addCriterion("bailun_category_id <=", value, "bailunCategoryId");
            return (Criteria) this;
        }

        public Criteria andBailunCategoryIdIn(List<Integer> values) {
            addCriterion("bailun_category_id in", values, "bailunCategoryId");
            return (Criteria) this;
        }

        public Criteria andBailunCategoryIdNotIn(List<Integer> values) {
            addCriterion("bailun_category_id not in", values, "bailunCategoryId");
            return (Criteria) this;
        }

        public Criteria andBailunCategoryIdBetween(Integer value1, Integer value2) {
            addCriterion("bailun_category_id between", value1, value2, "bailunCategoryId");
            return (Criteria) this;
        }

        public Criteria andBailunCategoryIdNotBetween(Integer value1, Integer value2) {
            addCriterion("bailun_category_id not between", value1, value2, "bailunCategoryId");
            return (Criteria) this;
        }

        public Criteria andBuyerNameIsNull() {
            addCriterion("buyer_name is null");
            return (Criteria) this;
        }

        public Criteria andBuyerNameIsNotNull() {
            addCriterion("buyer_name is not null");
            return (Criteria) this;
        }

        public Criteria andBuyerNameEqualTo(String value) {
            addCriterion("buyer_name =", value, "buyerName");
            return (Criteria) this;
        }

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

        public Criteria andBuyerNameGreaterThan(String value) {
            addCriterion("buyer_name >", value, "buyerName");
            return (Criteria) this;
        }

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

        public Criteria andBuyerNameLessThan(String value) {
            addCriterion("buyer_name <", value, "buyerName");
            return (Criteria) this;
        }

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

        public Criteria andBuyerNameLike(String value) {
            addCriterion("buyer_name like", value, "buyerName");
            return (Criteria) this;
        }

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

        public Criteria andBuyerNameIn(List<String> values) {
            addCriterion("buyer_name in", values, "buyerName");
            return (Criteria) this;
        }

        public Criteria andBuyerNameNotIn(List<String> values) {
            addCriterion("buyer_name not in", values, "buyerName");
            return (Criteria) this;
        }

        public Criteria andBuyerNameBetween(String value1, String value2) {
            addCriterion("buyer_name between", value1, value2, "buyerName");
            return (Criteria) this;
        }

        public Criteria andBuyerNameNotBetween(String value1, String value2) {
            addCriterion("buyer_name not between", value1, value2, "buyerName");
            return (Criteria) this;
        }

        public Criteria andSuppliersNameIsNull() {
            addCriterion("suppliers_name is null");
            return (Criteria) this;
        }

        public Criteria andSuppliersNameIsNotNull() {
            addCriterion("suppliers_name is not null");
            return (Criteria) this;
        }

        public Criteria andSuppliersNameEqualTo(String value) {
            addCriterion("suppliers_name =", value, "suppliersName");
            return (Criteria) this;
        }

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

        public Criteria andSuppliersNameGreaterThan(String value) {
            addCriterion("suppliers_name >", value, "suppliersName");
            return (Criteria) this;
        }

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

        public Criteria andSuppliersNameLessThan(String value) {
            addCriterion("suppliers_name <", value, "suppliersName");
            return (Criteria) this;
        }

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

        public Criteria andSuppliersNameLike(String value) {
            addCriterion("suppliers_name like", value, "suppliersName");
            return (Criteria) this;
        }

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

        public Criteria andSuppliersNameIn(List<String> values) {
            addCriterion("suppliers_name in", values, "suppliersName");
            return (Criteria) this;
        }

        public Criteria andSuppliersNameNotIn(List<String> values) {
            addCriterion("suppliers_name not in", values, "suppliersName");
            return (Criteria) this;
        }

        public Criteria andSuppliersNameBetween(String value1, String value2) {
            addCriterion("suppliers_name between", value1, value2, "suppliersName");
            return (Criteria) this;
        }

        public Criteria andSuppliersNameNotBetween(String value1, String value2) {
            addCriterion("suppliers_name not between", value1, value2, "suppliersName");
            return (Criteria) this;
        }

        public Criteria andHistorySevendaySalesEbayIsNull() {
            addCriterion("history_sevenday_sales_ebay is null");
            return (Criteria) this;
        }

        public Criteria andHistorySevendaySalesEbayIsNotNull() {
            addCriterion("history_sevenday_sales_ebay is not null");
            return (Criteria) this;
        }

        public Criteria andHistorySevendaySalesEbayEqualTo(BigDecimal value) {
            addCriterion("history_sevenday_sales_ebay =", value, "historySevendaySalesEbay");
            return (Criteria) this;
        }

        public Criteria andHistorySevendaySalesEbayNotEqualTo(BigDecimal value) {
            addCriterion("history_sevenday_sales_ebay <>", value, "historySevendaySalesEbay");
            return (Criteria) this;
        }

        public Criteria andHistorySevendaySalesEbayGreaterThan(BigDecimal value) {
            addCriterion("history_sevenday_sales_ebay >", value, "historySevendaySalesEbay");
            return (Criteria) this;
        }

        public Criteria andHistorySevendaySalesEbayGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("history_sevenday_sales_ebay >=", value, "historySevendaySalesEbay");
            return (Criteria) this;
        }

        public Criteria andHistorySevendaySalesEbayLessThan(BigDecimal value) {
            addCriterion("history_sevenday_sales_ebay <", value, "historySevendaySalesEbay");
            return (Criteria) this;
        }

        public Criteria andHistorySevendaySalesEbayLessThanOrEqualTo(BigDecimal value) {
            addCriterion("history_sevenday_sales_ebay <=", value, "historySevendaySalesEbay");
            return (Criteria) this;
        }

        public Criteria andHistorySevendaySalesEbayIn(List<BigDecimal> values) {
            addCriterion("history_sevenday_sales_ebay in", values, "historySevendaySalesEbay");
            return (Criteria) this;
        }

        public Criteria andHistorySevendaySalesEbayNotIn(List<BigDecimal> values) {
            addCriterion("history_sevenday_sales_ebay not in", values, "historySevendaySalesEbay");
            return (Criteria) this;
        }

        public Criteria andHistorySevendaySalesEbayBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("history_sevenday_sales_ebay between", value1, value2, "historySevendaySalesEbay");
            return (Criteria) this;
        }

        public Criteria andHistorySevendaySalesEbayNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("history_sevenday_sales_ebay not between", value1, value2, "historySevendaySalesEbay");
            return (Criteria) this;
        }

        public Criteria andHistoryFourteendaySalesEbayIsNull() {
            addCriterion("history_fourteenday_sales_ebay is null");
            return (Criteria) this;
        }

        public Criteria andHistoryFourteendaySalesEbayIsNotNull() {
            addCriterion("history_fourteenday_sales_ebay is not null");
            return (Criteria) this;
        }

        public Criteria andHistoryFourteendaySalesEbayEqualTo(BigDecimal value) {
            addCriterion("history_fourteenday_sales_ebay =", value, "historyFourteendaySalesEbay");
            return (Criteria) this;
        }

        public Criteria andHistoryFourteendaySalesEbayNotEqualTo(BigDecimal value) {
            addCriterion("history_fourteenday_sales_ebay <>", value, "historyFourteendaySalesEbay");
            return (Criteria) this;
        }

        public Criteria andHistoryFourteendaySalesEbayGreaterThan(BigDecimal value) {
            addCriterion("history_fourteenday_sales_ebay >", value, "historyFourteendaySalesEbay");
            return (Criteria) this;
        }

        public Criteria andHistoryFourteendaySalesEbayGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("history_fourteenday_sales_ebay >=", value, "historyFourteendaySalesEbay");
            return (Criteria) this;
        }

        public Criteria andHistoryFourteendaySalesEbayLessThan(BigDecimal value) {
            addCriterion("history_fourteenday_sales_ebay <", value, "historyFourteendaySalesEbay");
            return (Criteria) this;
        }

        public Criteria andHistoryFourteendaySalesEbayLessThanOrEqualTo(BigDecimal value) {
            addCriterion("history_fourteenday_sales_ebay <=", value, "historyFourteendaySalesEbay");
            return (Criteria) this;
        }

        public Criteria andHistoryFourteendaySalesEbayIn(List<BigDecimal> values) {
            addCriterion("history_fourteenday_sales_ebay in", values, "historyFourteendaySalesEbay");
            return (Criteria) this;
        }

        public Criteria andHistoryFourteendaySalesEbayNotIn(List<BigDecimal> values) {
            addCriterion("history_fourteenday_sales_ebay not in", values, "historyFourteendaySalesEbay");
            return (Criteria) this;
        }

        public Criteria andHistoryFourteendaySalesEbayBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("history_fourteenday_sales_ebay between", value1, value2, "historyFourteendaySalesEbay");
            return (Criteria) this;
        }

        public Criteria andHistoryFourteendaySalesEbayNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("history_fourteenday_sales_ebay not between", value1, value2, "historyFourteendaySalesEbay");
            return (Criteria) this;
        }

        public Criteria andHistoryThirtydaySalesEbayIsNull() {
            addCriterion("history_thirtyday_sales_ebay is null");
            return (Criteria) this;
        }

        public Criteria andHistoryThirtydaySalesEbayIsNotNull() {
            addCriterion("history_thirtyday_sales_ebay is not null");
            return (Criteria) this;
        }

        public Criteria andHistoryThirtydaySalesEbayEqualTo(BigDecimal value) {
            addCriterion("history_thirtyday_sales_ebay =", value, "historyThirtydaySalesEbay");
            return (Criteria) this;
        }

        public Criteria andHistoryThirtydaySalesEbayNotEqualTo(BigDecimal value) {
            addCriterion("history_thirtyday_sales_ebay <>", value, "historyThirtydaySalesEbay");
            return (Criteria) this;
        }

        public Criteria andHistoryThirtydaySalesEbayGreaterThan(BigDecimal value) {
            addCriterion("history_thirtyday_sales_ebay >", value, "historyThirtydaySalesEbay");
            return (Criteria) this;
        }

        public Criteria andHistoryThirtydaySalesEbayGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("history_thirtyday_sales_ebay >=", value, "historyThirtydaySalesEbay");
            return (Criteria) this;
        }

        public Criteria andHistoryThirtydaySalesEbayLessThan(BigDecimal value) {
            addCriterion("history_thirtyday_sales_ebay <", value, "historyThirtydaySalesEbay");
            return (Criteria) this;
        }

        public Criteria andHistoryThirtydaySalesEbayLessThanOrEqualTo(BigDecimal value) {
            addCriterion("history_thirtyday_sales_ebay <=", value, "historyThirtydaySalesEbay");
            return (Criteria) this;
        }

        public Criteria andHistoryThirtydaySalesEbayIn(List<BigDecimal> values) {
            addCriterion("history_thirtyday_sales_ebay in", values, "historyThirtydaySalesEbay");
            return (Criteria) this;
        }

        public Criteria andHistoryThirtydaySalesEbayNotIn(List<BigDecimal> values) {
            addCriterion("history_thirtyday_sales_ebay not in", values, "historyThirtydaySalesEbay");
            return (Criteria) this;
        }

        public Criteria andHistoryThirtydaySalesEbayBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("history_thirtyday_sales_ebay between", value1, value2, "historyThirtydaySalesEbay");
            return (Criteria) this;
        }

        public Criteria andHistoryThirtydaySalesEbayNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("history_thirtyday_sales_ebay not between", value1, value2, "historyThirtydaySalesEbay");
            return (Criteria) this;
        }

        public Criteria andHistorySevendaySalesAliexpressIsNull() {
            addCriterion("history_sevenday_sales_aliexpress is null");
            return (Criteria) this;
        }

        public Criteria andHistorySevendaySalesAliexpressIsNotNull() {
            addCriterion("history_sevenday_sales_aliexpress is not null");
            return (Criteria) this;
        }

        public Criteria andHistorySevendaySalesAliexpressEqualTo(BigDecimal value) {
            addCriterion("history_sevenday_sales_aliexpress =", value, "historySevendaySalesAliexpress");
            return (Criteria) this;
        }

        public Criteria andHistorySevendaySalesAliexpressNotEqualTo(BigDecimal value) {
            addCriterion("history_sevenday_sales_aliexpress <>", value, "historySevendaySalesAliexpress");
            return (Criteria) this;
        }

        public Criteria andHistorySevendaySalesAliexpressGreaterThan(BigDecimal value) {
            addCriterion("history_sevenday_sales_aliexpress >", value, "historySevendaySalesAliexpress");
            return (Criteria) this;
        }

        public Criteria andHistorySevendaySalesAliexpressGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("history_sevenday_sales_aliexpress >=", value, "historySevendaySalesAliexpress");
            return (Criteria) this;
        }

        public Criteria andHistorySevendaySalesAliexpressLessThan(BigDecimal value) {
            addCriterion("history_sevenday_sales_aliexpress <", value, "historySevendaySalesAliexpress");
            return (Criteria) this;
        }

        public Criteria andHistorySevendaySalesAliexpressLessThanOrEqualTo(BigDecimal value) {
            addCriterion("history_sevenday_sales_aliexpress <=", value, "historySevendaySalesAliexpress");
            return (Criteria) this;
        }

        public Criteria andHistorySevendaySalesAliexpressIn(List<BigDecimal> values) {
            addCriterion("history_sevenday_sales_aliexpress in", values, "historySevendaySalesAliexpress");
            return (Criteria) this;
        }

        public Criteria andHistorySevendaySalesAliexpressNotIn(List<BigDecimal> values) {
            addCriterion("history_sevenday_sales_aliexpress not in", values, "historySevendaySalesAliexpress");
            return (Criteria) this;
        }

        public Criteria andHistorySevendaySalesAliexpressBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("history_sevenday_sales_aliexpress between", value1, value2, "historySevendaySalesAliexpress");
            return (Criteria) this;
        }

        public Criteria andHistorySevendaySalesAliexpressNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("history_sevenday_sales_aliexpress not between", value1, value2, "historySevendaySalesAliexpress");
            return (Criteria) this;
        }

        public Criteria andHistoryFourteendaySalesAliexpressIsNull() {
            addCriterion("history_fourteenday_sales_aliexpress is null");
            return (Criteria) this;
        }

        public Criteria andHistoryFourteendaySalesAliexpressIsNotNull() {
            addCriterion("history_fourteenday_sales_aliexpress is not null");
            return (Criteria) this;
        }

        public Criteria andHistoryFourteendaySalesAliexpressEqualTo(BigDecimal value) {
            addCriterion("history_fourteenday_sales_aliexpress =", value, "historyFourteendaySalesAliexpress");
            return (Criteria) this;
        }

        public Criteria andHistoryFourteendaySalesAliexpressNotEqualTo(BigDecimal value) {
            addCriterion("history_fourteenday_sales_aliexpress <>", value, "historyFourteendaySalesAliexpress");
            return (Criteria) this;
        }

        public Criteria andHistoryFourteendaySalesAliexpressGreaterThan(BigDecimal value) {
            addCriterion("history_fourteenday_sales_aliexpress >", value, "historyFourteendaySalesAliexpress");
            return (Criteria) this;
        }

        public Criteria andHistoryFourteendaySalesAliexpressGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("history_fourteenday_sales_aliexpress >=", value, "historyFourteendaySalesAliexpress");
            return (Criteria) this;
        }

        public Criteria andHistoryFourteendaySalesAliexpressLessThan(BigDecimal value) {
            addCriterion("history_fourteenday_sales_aliexpress <", value, "historyFourteendaySalesAliexpress");
            return (Criteria) this;
        }

        public Criteria andHistoryFourteendaySalesAliexpressLessThanOrEqualTo(BigDecimal value) {
            addCriterion("history_fourteenday_sales_aliexpress <=", value, "historyFourteendaySalesAliexpress");
            return (Criteria) this;
        }

        public Criteria andHistoryFourteendaySalesAliexpressIn(List<BigDecimal> values) {
            addCriterion("history_fourteenday_sales_aliexpress in", values, "historyFourteendaySalesAliexpress");
            return (Criteria) this;
        }

        public Criteria andHistoryFourteendaySalesAliexpressNotIn(List<BigDecimal> values) {
            addCriterion("history_fourteenday_sales_aliexpress not in", values, "historyFourteendaySalesAliexpress");
            return (Criteria) this;
        }

        public Criteria andHistoryFourteendaySalesAliexpressBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("history_fourteenday_sales_aliexpress between", value1, value2, "historyFourteendaySalesAliexpress");
            return (Criteria) this;
        }

        public Criteria andHistoryFourteendaySalesAliexpressNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("history_fourteenday_sales_aliexpress not between", value1, value2, "historyFourteendaySalesAliexpress");
            return (Criteria) this;
        }

        public Criteria andHistoryThirtydaySalesAliexpressIsNull() {
            addCriterion("history_thirtyday_sales_aliexpress is null");
            return (Criteria) this;
        }

        public Criteria andHistoryThirtydaySalesAliexpressIsNotNull() {
            addCriterion("history_thirtyday_sales_aliexpress is not null");
            return (Criteria) this;
        }

        public Criteria andHistoryThirtydaySalesAliexpressEqualTo(BigDecimal value) {
            addCriterion("history_thirtyday_sales_aliexpress =", value, "historyThirtydaySalesAliexpress");
            return (Criteria) this;
        }

        public Criteria andHistoryThirtydaySalesAliexpressNotEqualTo(BigDecimal value) {
            addCriterion("history_thirtyday_sales_aliexpress <>", value, "historyThirtydaySalesAliexpress");
            return (Criteria) this;
        }

        public Criteria andHistoryThirtydaySalesAliexpressGreaterThan(BigDecimal value) {
            addCriterion("history_thirtyday_sales_aliexpress >", value, "historyThirtydaySalesAliexpress");
            return (Criteria) this;
        }

        public Criteria andHistoryThirtydaySalesAliexpressGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("history_thirtyday_sales_aliexpress >=", value, "historyThirtydaySalesAliexpress");
            return (Criteria) this;
        }

        public Criteria andHistoryThirtydaySalesAliexpressLessThan(BigDecimal value) {
            addCriterion("history_thirtyday_sales_aliexpress <", value, "historyThirtydaySalesAliexpress");
            return (Criteria) this;
        }

        public Criteria andHistoryThirtydaySalesAliexpressLessThanOrEqualTo(BigDecimal value) {
            addCriterion("history_thirtyday_sales_aliexpress <=", value, "historyThirtydaySalesAliexpress");
            return (Criteria) this;
        }

        public Criteria andHistoryThirtydaySalesAliexpressIn(List<BigDecimal> values) {
            addCriterion("history_thirtyday_sales_aliexpress in", values, "historyThirtydaySalesAliexpress");
            return (Criteria) this;
        }

        public Criteria andHistoryThirtydaySalesAliexpressNotIn(List<BigDecimal> values) {
            addCriterion("history_thirtyday_sales_aliexpress not in", values, "historyThirtydaySalesAliexpress");
            return (Criteria) this;
        }

        public Criteria andHistoryThirtydaySalesAliexpressBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("history_thirtyday_sales_aliexpress between", value1, value2, "historyThirtydaySalesAliexpress");
            return (Criteria) this;
        }

        public Criteria andHistoryThirtydaySalesAliexpressNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("history_thirtyday_sales_aliexpress not between", value1, value2, "historyThirtydaySalesAliexpress");
            return (Criteria) this;
        }

        public Criteria andDailyWeightedSalesIsNull() {
            addCriterion("daily_weighted_sales is null");
            return (Criteria) this;
        }

        public Criteria andDailyWeightedSalesIsNotNull() {
            addCriterion("daily_weighted_sales is not null");
            return (Criteria) this;
        }

        public Criteria andDailyWeightedSalesEqualTo(BigDecimal value) {
            addCriterion("daily_weighted_sales =", value, "dailyWeightedSales");
            return (Criteria) this;
        }

        public Criteria andDailyWeightedSalesNotEqualTo(BigDecimal value) {
            addCriterion("daily_weighted_sales <>", value, "dailyWeightedSales");
            return (Criteria) this;
        }

        public Criteria andDailyWeightedSalesGreaterThan(BigDecimal value) {
            addCriterion("daily_weighted_sales >", value, "dailyWeightedSales");
            return (Criteria) this;
        }

        public Criteria andDailyWeightedSalesGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("daily_weighted_sales >=", value, "dailyWeightedSales");
            return (Criteria) this;
        }

        public Criteria andDailyWeightedSalesLessThan(BigDecimal value) {
            addCriterion("daily_weighted_sales <", value, "dailyWeightedSales");
            return (Criteria) this;
        }

        public Criteria andDailyWeightedSalesLessThanOrEqualTo(BigDecimal value) {
            addCriterion("daily_weighted_sales <=", value, "dailyWeightedSales");
            return (Criteria) this;
        }

        public Criteria andDailyWeightedSalesIn(List<BigDecimal> values) {
            addCriterion("daily_weighted_sales in", values, "dailyWeightedSales");
            return (Criteria) this;
        }

        public Criteria andDailyWeightedSalesNotIn(List<BigDecimal> values) {
            addCriterion("daily_weighted_sales not in", values, "dailyWeightedSales");
            return (Criteria) this;
        }

        public Criteria andDailyWeightedSalesBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("daily_weighted_sales between", value1, value2, "dailyWeightedSales");
            return (Criteria) this;
        }

        public Criteria andDailyWeightedSalesNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("daily_weighted_sales not between", value1, value2, "dailyWeightedSales");
            return (Criteria) this;
        }

        public Criteria andOriginalQuantityInitAdviseIsNull() {
            addCriterion("original_quantity_init_advise is null");
            return (Criteria) this;
        }

        public Criteria andOriginalQuantityInitAdviseIsNotNull() {
            addCriterion("original_quantity_init_advise is not null");
            return (Criteria) this;
        }

        public Criteria andOriginalQuantityInitAdviseEqualTo(Integer value) {
            addCriterion("original_quantity_init_advise =", value, "originalQuantityInitAdvise");
            return (Criteria) this;
        }

        public Criteria andOriginalQuantityInitAdviseNotEqualTo(Integer value) {
            addCriterion("original_quantity_init_advise <>", value, "originalQuantityInitAdvise");
            return (Criteria) this;
        }

        public Criteria andOriginalQuantityInitAdviseGreaterThan(Integer value) {
            addCriterion("original_quantity_init_advise >", value, "originalQuantityInitAdvise");
            return (Criteria) this;
        }

        public Criteria andOriginalQuantityInitAdviseGreaterThanOrEqualTo(Integer value) {
            addCriterion("original_quantity_init_advise >=", value, "originalQuantityInitAdvise");
            return (Criteria) this;
        }

        public Criteria andOriginalQuantityInitAdviseLessThan(Integer value) {
            addCriterion("original_quantity_init_advise <", value, "originalQuantityInitAdvise");
            return (Criteria) this;
        }

        public Criteria andOriginalQuantityInitAdviseLessThanOrEqualTo(Integer value) {
            addCriterion("original_quantity_init_advise <=", value, "originalQuantityInitAdvise");
            return (Criteria) this;
        }

        public Criteria andOriginalQuantityInitAdviseIn(List<Integer> values) {
            addCriterion("original_quantity_init_advise in", values, "originalQuantityInitAdvise");
            return (Criteria) this;
        }

        public Criteria andOriginalQuantityInitAdviseNotIn(List<Integer> values) {
            addCriterion("original_quantity_init_advise not in", values, "originalQuantityInitAdvise");
            return (Criteria) this;
        }

        public Criteria andOriginalQuantityInitAdviseBetween(Integer value1, Integer value2) {
            addCriterion("original_quantity_init_advise between", value1, value2, "originalQuantityInitAdvise");
            return (Criteria) this;
        }

        public Criteria andOriginalQuantityInitAdviseNotBetween(Integer value1, Integer value2) {
            addCriterion("original_quantity_init_advise not between", value1, value2, "originalQuantityInitAdvise");
            return (Criteria) this;
        }

        public Criteria andIsModifyQuantityInitAdviseIsNull() {
            addCriterion("is_modify_quantity_init_advise is null");
            return (Criteria) this;
        }

        public Criteria andIsModifyQuantityInitAdviseIsNotNull() {
            addCriterion("is_modify_quantity_init_advise is not null");
            return (Criteria) this;
        }

        public Criteria andIsModifyQuantityInitAdviseEqualTo(Integer value) {
            addCriterion("is_modify_quantity_init_advise =", value, "isModifyQuantityInitAdvise");
            return (Criteria) this;
        }

        public Criteria andIsModifyQuantityInitAdviseNotEqualTo(Integer value) {
            addCriterion("is_modify_quantity_init_advise <>", value, "isModifyQuantityInitAdvise");
            return (Criteria) this;
        }

        public Criteria andIsModifyQuantityInitAdviseGreaterThan(Integer value) {
            addCriterion("is_modify_quantity_init_advise >", value, "isModifyQuantityInitAdvise");
            return (Criteria) this;
        }

        public Criteria andIsModifyQuantityInitAdviseGreaterThanOrEqualTo(Integer value) {
            addCriterion("is_modify_quantity_init_advise >=", value, "isModifyQuantityInitAdvise");
            return (Criteria) this;
        }

        public Criteria andIsModifyQuantityInitAdviseLessThan(Integer value) {
            addCriterion("is_modify_quantity_init_advise <", value, "isModifyQuantityInitAdvise");
            return (Criteria) this;
        }

        public Criteria andIsModifyQuantityInitAdviseLessThanOrEqualTo(Integer value) {
            addCriterion("is_modify_quantity_init_advise <=", value, "isModifyQuantityInitAdvise");
            return (Criteria) this;
        }

        public Criteria andIsModifyQuantityInitAdviseIn(List<Integer> values) {
            addCriterion("is_modify_quantity_init_advise in", values, "isModifyQuantityInitAdvise");
            return (Criteria) this;
        }

        public Criteria andIsModifyQuantityInitAdviseNotIn(List<Integer> values) {
            addCriterion("is_modify_quantity_init_advise not in", values, "isModifyQuantityInitAdvise");
            return (Criteria) this;
        }

        public Criteria andIsModifyQuantityInitAdviseBetween(Integer value1, Integer value2) {
            addCriterion("is_modify_quantity_init_advise between", value1, value2, "isModifyQuantityInitAdvise");
            return (Criteria) this;
        }

        public Criteria andIsModifyQuantityInitAdviseNotBetween(Integer value1, Integer value2) {
            addCriterion("is_modify_quantity_init_advise not between", value1, value2, "isModifyQuantityInitAdvise");
            return (Criteria) this;
        }

        public Criteria andTagIdIsNull() {
            addCriterion("tag_id is null");
            return (Criteria) this;
        }

        public Criteria andTagIdIsNotNull() {
            addCriterion("tag_id is not null");
            return (Criteria) this;
        }

        public Criteria andTagIdEqualTo(Integer value) {
            addCriterion("tag_id =", value, "tagId");
            return (Criteria) this;
        }

        public Criteria andTagIdNotEqualTo(Integer value) {
            addCriterion("tag_id <>", value, "tagId");
            return (Criteria) this;
        }

        public Criteria andTagIdGreaterThan(Integer value) {
            addCriterion("tag_id >", value, "tagId");
            return (Criteria) this;
        }

        public Criteria andTagIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("tag_id >=", value, "tagId");
            return (Criteria) this;
        }

        public Criteria andTagIdLessThan(Integer value) {
            addCriterion("tag_id <", value, "tagId");
            return (Criteria) this;
        }

        public Criteria andTagIdLessThanOrEqualTo(Integer value) {
            addCriterion("tag_id <=", value, "tagId");
            return (Criteria) this;
        }

        public Criteria andTagIdIn(List<Integer> values) {
            addCriterion("tag_id in", values, "tagId");
            return (Criteria) this;
        }

        public Criteria andTagIdNotIn(List<Integer> values) {
            addCriterion("tag_id not in", values, "tagId");
            return (Criteria) this;
        }

        public Criteria andTagIdBetween(Integer value1, Integer value2) {
            addCriterion("tag_id between", value1, value2, "tagId");
            return (Criteria) this;
        }

        public Criteria andTagIdNotBetween(Integer value1, Integer value2) {
            addCriterion("tag_id not between", value1, value2, "tagId");
            return (Criteria) this;
        }

        public Criteria andHqTypeIsNull() {
            addCriterion("hq_type is null");
            return (Criteria) this;
        }

        public Criteria andHqTypeIsNotNull() {
            addCriterion("hq_type is not null");
            return (Criteria) this;
        }

        public Criteria andHqTypeEqualTo(String value) {
            addCriterion("hq_type =", value, "hqType");
            return (Criteria) this;
        }

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

        public Criteria andHqTypeGreaterThan(String value) {
            addCriterion("hq_type >", value, "hqType");
            return (Criteria) this;
        }

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

        public Criteria andHqTypeLessThan(String value) {
            addCriterion("hq_type <", value, "hqType");
            return (Criteria) this;
        }

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

        public Criteria andHqTypeLike(String value) {
            addCriterion("hq_type like", value, "hqType");
            return (Criteria) this;
        }

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

        public Criteria andHqTypeIn(List<String> values) {
            addCriterion("hq_type in", values, "hqType");
            return (Criteria) this;
        }

        public Criteria andHqTypeNotIn(List<String> values) {
            addCriterion("hq_type not in", values, "hqType");
            return (Criteria) this;
        }

        public Criteria andHqTypeBetween(String value1, String value2) {
            addCriterion("hq_type between", value1, value2, "hqType");
            return (Criteria) this;
        }

        public Criteria andHqTypeNotBetween(String value1, String value2) {
            addCriterion("hq_type not between", value1, value2, "hqType");
            return (Criteria) this;
        }

        public Criteria andHistorySevendaySalesAmazonIsNull() {
            addCriterion("history_sevenday_sales_amazon is null");
            return (Criteria) this;
        }

        public Criteria andHistorySevendaySalesAmazonIsNotNull() {
            addCriterion("history_sevenday_sales_amazon is not null");
            return (Criteria) this;
        }

        public Criteria andHistorySevendaySalesAmazonEqualTo(BigDecimal value) {
            addCriterion("history_sevenday_sales_amazon =", value, "historySevendaySalesAmazon");
            return (Criteria) this;
        }

        public Criteria andHistorySevendaySalesAmazonNotEqualTo(BigDecimal value) {
            addCriterion("history_sevenday_sales_amazon <>", value, "historySevendaySalesAmazon");
            return (Criteria) this;
        }

        public Criteria andHistorySevendaySalesAmazonGreaterThan(BigDecimal value) {
            addCriterion("history_sevenday_sales_amazon >", value, "historySevendaySalesAmazon");
            return (Criteria) this;
        }

        public Criteria andHistorySevendaySalesAmazonGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("history_sevenday_sales_amazon >=", value, "historySevendaySalesAmazon");
            return (Criteria) this;
        }

        public Criteria andHistorySevendaySalesAmazonLessThan(BigDecimal value) {
            addCriterion("history_sevenday_sales_amazon <", value, "historySevendaySalesAmazon");
            return (Criteria) this;
        }

        public Criteria andHistorySevendaySalesAmazonLessThanOrEqualTo(BigDecimal value) {
            addCriterion("history_sevenday_sales_amazon <=", value, "historySevendaySalesAmazon");
            return (Criteria) this;
        }

        public Criteria andHistorySevendaySalesAmazonIn(List<BigDecimal> values) {
            addCriterion("history_sevenday_sales_amazon in", values, "historySevendaySalesAmazon");
            return (Criteria) this;
        }

        public Criteria andHistorySevendaySalesAmazonNotIn(List<BigDecimal> values) {
            addCriterion("history_sevenday_sales_amazon not in", values, "historySevendaySalesAmazon");
            return (Criteria) this;
        }

        public Criteria andHistorySevendaySalesAmazonBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("history_sevenday_sales_amazon between", value1, value2, "historySevendaySalesAmazon");
            return (Criteria) this;
        }

        public Criteria andHistorySevendaySalesAmazonNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("history_sevenday_sales_amazon not between", value1, value2, "historySevendaySalesAmazon");
            return (Criteria) this;
        }

        public Criteria andHistoryFourteendaySalesAmazonIsNull() {
            addCriterion("history_fourteenday_sales_amazon is null");
            return (Criteria) this;
        }

        public Criteria andHistoryFourteendaySalesAmazonIsNotNull() {
            addCriterion("history_fourteenday_sales_amazon is not null");
            return (Criteria) this;
        }

        public Criteria andHistoryFourteendaySalesAmazonEqualTo(BigDecimal value) {
            addCriterion("history_fourteenday_sales_amazon =", value, "historyFourteendaySalesAmazon");
            return (Criteria) this;
        }

        public Criteria andHistoryFourteendaySalesAmazonNotEqualTo(BigDecimal value) {
            addCriterion("history_fourteenday_sales_amazon <>", value, "historyFourteendaySalesAmazon");
            return (Criteria) this;
        }

        public Criteria andHistoryFourteendaySalesAmazonGreaterThan(BigDecimal value) {
            addCriterion("history_fourteenday_sales_amazon >", value, "historyFourteendaySalesAmazon");
            return (Criteria) this;
        }

        public Criteria andHistoryFourteendaySalesAmazonGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("history_fourteenday_sales_amazon >=", value, "historyFourteendaySalesAmazon");
            return (Criteria) this;
        }

        public Criteria andHistoryFourteendaySalesAmazonLessThan(BigDecimal value) {
            addCriterion("history_fourteenday_sales_amazon <", value, "historyFourteendaySalesAmazon");
            return (Criteria) this;
        }

        public Criteria andHistoryFourteendaySalesAmazonLessThanOrEqualTo(BigDecimal value) {
            addCriterion("history_fourteenday_sales_amazon <=", value, "historyFourteendaySalesAmazon");
            return (Criteria) this;
        }

        public Criteria andHistoryFourteendaySalesAmazonIn(List<BigDecimal> values) {
            addCriterion("history_fourteenday_sales_amazon in", values, "historyFourteendaySalesAmazon");
            return (Criteria) this;
        }

        public Criteria andHistoryFourteendaySalesAmazonNotIn(List<BigDecimal> values) {
            addCriterion("history_fourteenday_sales_amazon not in", values, "historyFourteendaySalesAmazon");
            return (Criteria) this;
        }

        public Criteria andHistoryFourteendaySalesAmazonBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("history_fourteenday_sales_amazon between", value1, value2, "historyFourteendaySalesAmazon");
            return (Criteria) this;
        }

        public Criteria andHistoryFourteendaySalesAmazonNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("history_fourteenday_sales_amazon not between", value1, value2, "historyFourteendaySalesAmazon");
            return (Criteria) this;
        }

        public Criteria andHistoryThirtydaySalesAmazonIsNull() {
            addCriterion("history_thirtyday_sales_amazon is null");
            return (Criteria) this;
        }

        public Criteria andHistoryThirtydaySalesAmazonIsNotNull() {
            addCriterion("history_thirtyday_sales_amazon is not null");
            return (Criteria) this;
        }

        public Criteria andHistoryThirtydaySalesAmazonEqualTo(BigDecimal value) {
            addCriterion("history_thirtyday_sales_amazon =", value, "historyThirtydaySalesAmazon");
            return (Criteria) this;
        }

        public Criteria andHistoryThirtydaySalesAmazonNotEqualTo(BigDecimal value) {
            addCriterion("history_thirtyday_sales_amazon <>", value, "historyThirtydaySalesAmazon");
            return (Criteria) this;
        }

        public Criteria andHistoryThirtydaySalesAmazonGreaterThan(BigDecimal value) {
            addCriterion("history_thirtyday_sales_amazon >", value, "historyThirtydaySalesAmazon");
            return (Criteria) this;
        }

        public Criteria andHistoryThirtydaySalesAmazonGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("history_thirtyday_sales_amazon >=", value, "historyThirtydaySalesAmazon");
            return (Criteria) this;
        }

        public Criteria andHistoryThirtydaySalesAmazonLessThan(BigDecimal value) {
            addCriterion("history_thirtyday_sales_amazon <", value, "historyThirtydaySalesAmazon");
            return (Criteria) this;
        }

        public Criteria andHistoryThirtydaySalesAmazonLessThanOrEqualTo(BigDecimal value) {
            addCriterion("history_thirtyday_sales_amazon <=", value, "historyThirtydaySalesAmazon");
            return (Criteria) this;
        }

        public Criteria andHistoryThirtydaySalesAmazonIn(List<BigDecimal> values) {
            addCriterion("history_thirtyday_sales_amazon in", values, "historyThirtydaySalesAmazon");
            return (Criteria) this;
        }

        public Criteria andHistoryThirtydaySalesAmazonNotIn(List<BigDecimal> values) {
            addCriterion("history_thirtyday_sales_amazon not in", values, "historyThirtydaySalesAmazon");
            return (Criteria) this;
        }

        public Criteria andHistoryThirtydaySalesAmazonBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("history_thirtyday_sales_amazon between", value1, value2, "historyThirtydaySalesAmazon");
            return (Criteria) this;
        }

        public Criteria andHistoryThirtydaySalesAmazonNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("history_thirtyday_sales_amazon not between", value1, value2, "historyThirtydaySalesAmazon");
            return (Criteria) this;
        }

        public Criteria andDcAutoSalesForecastConfigIdIsNull() {
            addCriterion("dc_auto_sales_forecast_config_id is null");
            return (Criteria) this;
        }

        public Criteria andDcAutoSalesForecastConfigIdIsNotNull() {
            addCriterion("dc_auto_sales_forecast_config_id is not null");
            return (Criteria) this;
        }

        public Criteria andDcAutoSalesForecastConfigIdEqualTo(Integer value) {
            addCriterion("dc_auto_sales_forecast_config_id =", value, "dcAutoSalesForecastConfigId");
            return (Criteria) this;
        }

        public Criteria andDcAutoSalesForecastConfigIdNotEqualTo(Integer value) {
            addCriterion("dc_auto_sales_forecast_config_id <>", value, "dcAutoSalesForecastConfigId");
            return (Criteria) this;
        }

        public Criteria andDcAutoSalesForecastConfigIdGreaterThan(Integer value) {
            addCriterion("dc_auto_sales_forecast_config_id >", value, "dcAutoSalesForecastConfigId");
            return (Criteria) this;
        }

        public Criteria andDcAutoSalesForecastConfigIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("dc_auto_sales_forecast_config_id >=", value, "dcAutoSalesForecastConfigId");
            return (Criteria) this;
        }

        public Criteria andDcAutoSalesForecastConfigIdLessThan(Integer value) {
            addCriterion("dc_auto_sales_forecast_config_id <", value, "dcAutoSalesForecastConfigId");
            return (Criteria) this;
        }

        public Criteria andDcAutoSalesForecastConfigIdLessThanOrEqualTo(Integer value) {
            addCriterion("dc_auto_sales_forecast_config_id <=", value, "dcAutoSalesForecastConfigId");
            return (Criteria) this;
        }

        public Criteria andDcAutoSalesForecastConfigIdIn(List<Integer> values) {
            addCriterion("dc_auto_sales_forecast_config_id in", values, "dcAutoSalesForecastConfigId");
            return (Criteria) this;
        }

        public Criteria andDcAutoSalesForecastConfigIdNotIn(List<Integer> values) {
            addCriterion("dc_auto_sales_forecast_config_id not in", values, "dcAutoSalesForecastConfigId");
            return (Criteria) this;
        }

        public Criteria andDcAutoSalesForecastConfigIdBetween(Integer value1, Integer value2) {
            addCriterion("dc_auto_sales_forecast_config_id between", value1, value2, "dcAutoSalesForecastConfigId");
            return (Criteria) this;
        }

        public Criteria andDcAutoSalesForecastConfigIdNotBetween(Integer value1, Integer value2) {
            addCriterion("dc_auto_sales_forecast_config_id not between", value1, value2, "dcAutoSalesForecastConfigId");
            return (Criteria) this;
        }

        public Criteria andIsOutStockIsNull() {
            addCriterion("is_out_stock is null");
            return (Criteria) this;
        }

        public Criteria andIsOutStockIsNotNull() {
            addCriterion("is_out_stock is not null");
            return (Criteria) this;
        }

        public Criteria andIsOutStockEqualTo(Integer value) {
            addCriterion("is_out_stock =", value, "isOutStock");
            return (Criteria) this;
        }

        public Criteria andIsOutStockNotEqualTo(Integer value) {
            addCriterion("is_out_stock <>", value, "isOutStock");
            return (Criteria) this;
        }

        public Criteria andIsOutStockGreaterThan(Integer value) {
            addCriterion("is_out_stock >", value, "isOutStock");
            return (Criteria) this;
        }

        public Criteria andIsOutStockGreaterThanOrEqualTo(Integer value) {
            addCriterion("is_out_stock >=", value, "isOutStock");
            return (Criteria) this;
        }

        public Criteria andIsOutStockLessThan(Integer value) {
            addCriterion("is_out_stock <", value, "isOutStock");
            return (Criteria) this;
        }

        public Criteria andIsOutStockLessThanOrEqualTo(Integer value) {
            addCriterion("is_out_stock <=", value, "isOutStock");
            return (Criteria) this;
        }

        public Criteria andIsOutStockIn(List<Integer> values) {
            addCriterion("is_out_stock in", values, "isOutStock");
            return (Criteria) this;
        }

        public Criteria andIsOutStockNotIn(List<Integer> values) {
            addCriterion("is_out_stock not in", values, "isOutStock");
            return (Criteria) this;
        }

        public Criteria andIsOutStockBetween(Integer value1, Integer value2) {
            addCriterion("is_out_stock between", value1, value2, "isOutStock");
            return (Criteria) this;
        }

        public Criteria andIsOutStockNotBetween(Integer value1, Integer value2) {
            addCriterion("is_out_stock not between", value1, value2, "isOutStock");
            return (Criteria) this;
        }

        public Criteria andDcAutoSalesForecastStageConfigIdIsNull() {
            addCriterion("dc_auto_sales_forecast_stage_config_id is null");
            return (Criteria) this;
        }

        public Criteria andDcAutoSalesForecastStageConfigIdIsNotNull() {
            addCriterion("dc_auto_sales_forecast_stage_config_id is not null");
            return (Criteria) this;
        }

        public Criteria andDcAutoSalesForecastStageConfigIdEqualTo(Integer value) {
            addCriterion("dc_auto_sales_forecast_stage_config_id =", value, "dcAutoSalesForecastStageConfigId");
            return (Criteria) this;
        }

        public Criteria andDcAutoSalesForecastStageConfigIdNotEqualTo(Integer value) {
            addCriterion("dc_auto_sales_forecast_stage_config_id <>", value, "dcAutoSalesForecastStageConfigId");
            return (Criteria) this;
        }

        public Criteria andDcAutoSalesForecastStageConfigIdGreaterThan(Integer value) {
            addCriterion("dc_auto_sales_forecast_stage_config_id >", value, "dcAutoSalesForecastStageConfigId");
            return (Criteria) this;
        }

        public Criteria andDcAutoSalesForecastStageConfigIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("dc_auto_sales_forecast_stage_config_id >=", value, "dcAutoSalesForecastStageConfigId");
            return (Criteria) this;
        }

        public Criteria andDcAutoSalesForecastStageConfigIdLessThan(Integer value) {
            addCriterion("dc_auto_sales_forecast_stage_config_id <", value, "dcAutoSalesForecastStageConfigId");
            return (Criteria) this;
        }

        public Criteria andDcAutoSalesForecastStageConfigIdLessThanOrEqualTo(Integer value) {
            addCriterion("dc_auto_sales_forecast_stage_config_id <=", value, "dcAutoSalesForecastStageConfigId");
            return (Criteria) this;
        }

        public Criteria andDcAutoSalesForecastStageConfigIdIn(List<Integer> values) {
            addCriterion("dc_auto_sales_forecast_stage_config_id in", values, "dcAutoSalesForecastStageConfigId");
            return (Criteria) this;
        }

        public Criteria andDcAutoSalesForecastStageConfigIdNotIn(List<Integer> values) {
            addCriterion("dc_auto_sales_forecast_stage_config_id not in", values, "dcAutoSalesForecastStageConfigId");
            return (Criteria) this;
        }

        public Criteria andDcAutoSalesForecastStageConfigIdBetween(Integer value1, Integer value2) {
            addCriterion("dc_auto_sales_forecast_stage_config_id between", value1, value2, "dcAutoSalesForecastStageConfigId");
            return (Criteria) this;
        }

        public Criteria andDcAutoSalesForecastStageConfigIdNotBetween(Integer value1, Integer value2) {
            addCriterion("dc_auto_sales_forecast_stage_config_id not between", value1, value2, "dcAutoSalesForecastStageConfigId");
            return (Criteria) this;
        }

        public Criteria andDcAutoSalesForecastTitleIsNull() {
            addCriterion("dc_auto_sales_forecast_title is null");
            return (Criteria) this;
        }

        public Criteria andDcAutoSalesForecastTitleIsNotNull() {
            addCriterion("dc_auto_sales_forecast_title is not null");
            return (Criteria) this;
        }

        public Criteria andDcAutoSalesForecastTitleEqualTo(String value) {
            addCriterion("dc_auto_sales_forecast_title =", value, "dcAutoSalesForecastTitle");
            return (Criteria) this;
        }

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

        public Criteria andDcAutoSalesForecastTitleGreaterThan(String value) {
            addCriterion("dc_auto_sales_forecast_title >", value, "dcAutoSalesForecastTitle");
            return (Criteria) this;
        }

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

        public Criteria andDcAutoSalesForecastTitleLessThan(String value) {
            addCriterion("dc_auto_sales_forecast_title <", value, "dcAutoSalesForecastTitle");
            return (Criteria) this;
        }

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

        public Criteria andDcAutoSalesForecastTitleLike(String value) {
            addCriterion("dc_auto_sales_forecast_title like", value, "dcAutoSalesForecastTitle");
            return (Criteria) this;
        }

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

        public Criteria andDcAutoSalesForecastTitleIn(List<String> values) {
            addCriterion("dc_auto_sales_forecast_title in", values, "dcAutoSalesForecastTitle");
            return (Criteria) this;
        }

        public Criteria andDcAutoSalesForecastTitleNotIn(List<String> values) {
            addCriterion("dc_auto_sales_forecast_title not in", values, "dcAutoSalesForecastTitle");
            return (Criteria) this;
        }

        public Criteria andDcAutoSalesForecastTitleBetween(String value1, String value2) {
            addCriterion("dc_auto_sales_forecast_title between", value1, value2, "dcAutoSalesForecastTitle");
            return (Criteria) this;
        }

        public Criteria andDcAutoSalesForecastTitleNotBetween(String value1, String value2) {
            addCriterion("dc_auto_sales_forecast_title not between", value1, value2, "dcAutoSalesForecastTitle");
            return (Criteria) this;
        }

        public Criteria andHeadTransportTypeIsNull() {
            addCriterion("head_transport_type is null");
            return (Criteria) this;
        }

        public Criteria andHeadTransportTypeIsNotNull() {
            addCriterion("head_transport_type is not null");
            return (Criteria) this;
        }

        public Criteria andHeadTransportTypeEqualTo(String value) {
            addCriterion("head_transport_type =", value, "headTransportType");
            return (Criteria) this;
        }

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

        public Criteria andHeadTransportTypeGreaterThan(String value) {
            addCriterion("head_transport_type >", value, "headTransportType");
            return (Criteria) this;
        }

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

        public Criteria andHeadTransportTypeLessThan(String value) {
            addCriterion("head_transport_type <", value, "headTransportType");
            return (Criteria) this;
        }

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

        public Criteria andHeadTransportTypeLike(String value) {
            addCriterion("head_transport_type like", value, "headTransportType");
            return (Criteria) this;
        }

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

        public Criteria andHeadTransportTypeIn(List<String> values) {
            addCriterion("head_transport_type in", values, "headTransportType");
            return (Criteria) this;
        }

        public Criteria andHeadTransportTypeNotIn(List<String> values) {
            addCriterion("head_transport_type not in", values, "headTransportType");
            return (Criteria) this;
        }

        public Criteria andHeadTransportTypeBetween(String value1, String value2) {
            addCriterion("head_transport_type between", value1, value2, "headTransportType");
            return (Criteria) this;
        }

        public Criteria andHeadTransportTypeNotBetween(String value1, String value2) {
            addCriterion("head_transport_type not between", value1, value2, "headTransportType");
            return (Criteria) this;
        }

        public Criteria andHeadTransportLogisticsCodeIsNull() {
            addCriterion("head_transport_logistics_code is null");
            return (Criteria) this;
        }

        public Criteria andHeadTransportLogisticsCodeIsNotNull() {
            addCriterion("head_transport_logistics_code is not null");
            return (Criteria) this;
        }

        public Criteria andHeadTransportLogisticsCodeEqualTo(String value) {
            addCriterion("head_transport_logistics_code =", value, "headTransportLogisticsCode");
            return (Criteria) this;
        }

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

        public Criteria andHeadTransportLogisticsCodeGreaterThan(String value) {
            addCriterion("head_transport_logistics_code >", value, "headTransportLogisticsCode");
            return (Criteria) this;
        }

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

        public Criteria andHeadTransportLogisticsCodeLessThan(String value) {
            addCriterion("head_transport_logistics_code <", value, "headTransportLogisticsCode");
            return (Criteria) this;
        }

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

        public Criteria andHeadTransportLogisticsCodeLike(String value) {
            addCriterion("head_transport_logistics_code like", value, "headTransportLogisticsCode");
            return (Criteria) this;
        }

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

        public Criteria andHeadTransportLogisticsCodeIn(List<String> values) {
            addCriterion("head_transport_logistics_code in", values, "headTransportLogisticsCode");
            return (Criteria) this;
        }

        public Criteria andHeadTransportLogisticsCodeNotIn(List<String> values) {
            addCriterion("head_transport_logistics_code not in", values, "headTransportLogisticsCode");
            return (Criteria) this;
        }

        public Criteria andHeadTransportLogisticsCodeBetween(String value1, String value2) {
            addCriterion("head_transport_logistics_code between", value1, value2, "headTransportLogisticsCode");
            return (Criteria) this;
        }

        public Criteria andHeadTransportLogisticsCodeNotBetween(String value1, String value2) {
            addCriterion("head_transport_logistics_code not between", value1, value2, "headTransportLogisticsCode");
            return (Criteria) this;
        }

        public Criteria andAutoReplaceLogisticsTaskIdIsNull() {
            addCriterion("auto_replace_logistics_task_id is null");
            return (Criteria) this;
        }

        public Criteria andAutoReplaceLogisticsTaskIdIsNotNull() {
            addCriterion("auto_replace_logistics_task_id is not null");
            return (Criteria) this;
        }

        public Criteria andAutoReplaceLogisticsTaskIdEqualTo(Integer value) {
            addCriterion("auto_replace_logistics_task_id =", value, "autoReplaceLogisticsTaskId");
            return (Criteria) this;
        }

        public Criteria andAutoReplaceLogisticsTaskIdNotEqualTo(Integer value) {
            addCriterion("auto_replace_logistics_task_id <>", value, "autoReplaceLogisticsTaskId");
            return (Criteria) this;
        }

        public Criteria andAutoReplaceLogisticsTaskIdGreaterThan(Integer value) {
            addCriterion("auto_replace_logistics_task_id >", value, "autoReplaceLogisticsTaskId");
            return (Criteria) this;
        }

        public Criteria andAutoReplaceLogisticsTaskIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("auto_replace_logistics_task_id >=", value, "autoReplaceLogisticsTaskId");
            return (Criteria) this;
        }

        public Criteria andAutoReplaceLogisticsTaskIdLessThan(Integer value) {
            addCriterion("auto_replace_logistics_task_id <", value, "autoReplaceLogisticsTaskId");
            return (Criteria) this;
        }

        public Criteria andAutoReplaceLogisticsTaskIdLessThanOrEqualTo(Integer value) {
            addCriterion("auto_replace_logistics_task_id <=", value, "autoReplaceLogisticsTaskId");
            return (Criteria) this;
        }

        public Criteria andAutoReplaceLogisticsTaskIdIn(List<Integer> values) {
            addCriterion("auto_replace_logistics_task_id in", values, "autoReplaceLogisticsTaskId");
            return (Criteria) this;
        }

        public Criteria andAutoReplaceLogisticsTaskIdNotIn(List<Integer> values) {
            addCriterion("auto_replace_logistics_task_id not in", values, "autoReplaceLogisticsTaskId");
            return (Criteria) this;
        }

        public Criteria andAutoReplaceLogisticsTaskIdBetween(Integer value1, Integer value2) {
            addCriterion("auto_replace_logistics_task_id between", value1, value2, "autoReplaceLogisticsTaskId");
            return (Criteria) this;
        }

        public Criteria andAutoReplaceLogisticsTaskIdNotBetween(Integer value1, Integer value2) {
            addCriterion("auto_replace_logistics_task_id not between", value1, value2, "autoReplaceLogisticsTaskId");
            return (Criteria) this;
        }

        public Criteria andFirstOrderDateIsNull() {
            addCriterion("first_order_date is null");
            return (Criteria) this;
        }

        public Criteria andFirstOrderDateIsNotNull() {
            addCriterion("first_order_date is not null");
            return (Criteria) this;
        }

        public Criteria andFirstOrderDateEqualTo(LocalDateTime value) {
            addCriterion("first_order_date =", value, "firstOrderDate");
            return (Criteria) this;
        }

        public Criteria andFirstOrderDateNotEqualTo(LocalDateTime value) {
            addCriterion("first_order_date <>", value, "firstOrderDate");
            return (Criteria) this;
        }

        public Criteria andFirstOrderDateGreaterThan(LocalDateTime value) {
            addCriterion("first_order_date >", value, "firstOrderDate");
            return (Criteria) this;
        }

        public Criteria andFirstOrderDateGreaterThanOrEqualTo(LocalDateTime value) {
            addCriterion("first_order_date >=", value, "firstOrderDate");
            return (Criteria) this;
        }

        public Criteria andFirstOrderDateLessThan(LocalDateTime value) {
            addCriterion("first_order_date <", value, "firstOrderDate");
            return (Criteria) this;
        }

        public Criteria andFirstOrderDateLessThanOrEqualTo(LocalDateTime value) {
            addCriterion("first_order_date <=", value, "firstOrderDate");
            return (Criteria) this;
        }

        public Criteria andFirstOrderDateIn(List<LocalDateTime> values) {
            addCriterion("first_order_date in", values, "firstOrderDate");
            return (Criteria) this;
        }

        public Criteria andFirstOrderDateNotIn(List<LocalDateTime> values) {
            addCriterion("first_order_date not in", values, "firstOrderDate");
            return (Criteria) this;
        }

        public Criteria andFirstOrderDateBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("first_order_date between", value1, value2, "firstOrderDate");
            return (Criteria) this;
        }

        public Criteria andFirstOrderDateNotBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("first_order_date not between", value1, value2, "firstOrderDate");
            return (Criteria) this;
        }

        public Criteria andFirstOrderBailunOrderIdIsNull() {
            addCriterion("first_order_bailun_order_id is null");
            return (Criteria) this;
        }

        public Criteria andFirstOrderBailunOrderIdIsNotNull() {
            addCriterion("first_order_bailun_order_id is not null");
            return (Criteria) this;
        }

        public Criteria andFirstOrderBailunOrderIdEqualTo(String value) {
            addCriterion("first_order_bailun_order_id =", value, "firstOrderBailunOrderId");
            return (Criteria) this;
        }

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

        public Criteria andFirstOrderBailunOrderIdGreaterThan(String value) {
            addCriterion("first_order_bailun_order_id >", value, "firstOrderBailunOrderId");
            return (Criteria) this;
        }

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

        public Criteria andFirstOrderBailunOrderIdLessThan(String value) {
            addCriterion("first_order_bailun_order_id <", value, "firstOrderBailunOrderId");
            return (Criteria) this;
        }

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

        public Criteria andFirstOrderBailunOrderIdLike(String value) {
            addCriterion("first_order_bailun_order_id like", value, "firstOrderBailunOrderId");
            return (Criteria) this;
        }

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

        public Criteria andFirstOrderBailunOrderIdIn(List<String> values) {
            addCriterion("first_order_bailun_order_id in", values, "firstOrderBailunOrderId");
            return (Criteria) this;
        }

        public Criteria andFirstOrderBailunOrderIdNotIn(List<String> values) {
            addCriterion("first_order_bailun_order_id not in", values, "firstOrderBailunOrderId");
            return (Criteria) this;
        }

        public Criteria andFirstOrderBailunOrderIdBetween(String value1, String value2) {
            addCriterion("first_order_bailun_order_id between", value1, value2, "firstOrderBailunOrderId");
            return (Criteria) this;
        }

        public Criteria andFirstOrderBailunOrderIdNotBetween(String value1, String value2) {
            addCriterion("first_order_bailun_order_id not between", value1, value2, "firstOrderBailunOrderId");
            return (Criteria) this;
        }

        public Criteria andOrdersAvgIsNull() {
            addCriterion("orders_avg is null");
            return (Criteria) this;
        }

        public Criteria andOrdersAvgIsNotNull() {
            addCriterion("orders_avg is not null");
            return (Criteria) this;
        }

        public Criteria andOrdersAvgEqualTo(BigDecimal value) {
            addCriterion("orders_avg =", value, "ordersAvg");
            return (Criteria) this;
        }

        public Criteria andOrdersAvgNotEqualTo(BigDecimal value) {
            addCriterion("orders_avg <>", value, "ordersAvg");
            return (Criteria) this;
        }

        public Criteria andOrdersAvgGreaterThan(BigDecimal value) {
            addCriterion("orders_avg >", value, "ordersAvg");
            return (Criteria) this;
        }

        public Criteria andOrdersAvgGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("orders_avg >=", value, "ordersAvg");
            return (Criteria) this;
        }

        public Criteria andOrdersAvgLessThan(BigDecimal value) {
            addCriterion("orders_avg <", value, "ordersAvg");
            return (Criteria) this;
        }

        public Criteria andOrdersAvgLessThanOrEqualTo(BigDecimal value) {
            addCriterion("orders_avg <=", value, "ordersAvg");
            return (Criteria) this;
        }

        public Criteria andOrdersAvgIn(List<BigDecimal> values) {
            addCriterion("orders_avg in", values, "ordersAvg");
            return (Criteria) this;
        }

        public Criteria andOrdersAvgNotIn(List<BigDecimal> values) {
            addCriterion("orders_avg not in", values, "ordersAvg");
            return (Criteria) this;
        }

        public Criteria andOrdersAvgBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("orders_avg between", value1, value2, "ordersAvg");
            return (Criteria) this;
        }

        public Criteria andOrdersAvgNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("orders_avg not between", value1, value2, "ordersAvg");
            return (Criteria) this;
        }

        public Criteria andAdvUidIsNull() {
            addCriterion("adv_uid is null");
            return (Criteria) this;
        }

        public Criteria andAdvUidIsNotNull() {
            addCriterion("adv_uid is not null");
            return (Criteria) this;
        }

        public Criteria andAdvUidEqualTo(String value) {
            addCriterion("adv_uid =", value, "advUid");
            return (Criteria) this;
        }

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

        public Criteria andAdvUidGreaterThan(String value) {
            addCriterion("adv_uid >", value, "advUid");
            return (Criteria) this;
        }

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

        public Criteria andAdvUidLessThan(String value) {
            addCriterion("adv_uid <", value, "advUid");
            return (Criteria) this;
        }

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

        public Criteria andAdvUidLike(String value) {
            addCriterion("adv_uid like", value, "advUid");
            return (Criteria) this;
        }

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

        public Criteria andAdvUidIn(List<String> values) {
            addCriterion("adv_uid in", values, "advUid");
            return (Criteria) this;
        }

        public Criteria andAdvUidNotIn(List<String> values) {
            addCriterion("adv_uid not in", values, "advUid");
            return (Criteria) this;
        }

        public Criteria andAdvUidBetween(String value1, String value2) {
            addCriterion("adv_uid between", value1, value2, "advUid");
            return (Criteria) this;
        }

        public Criteria andAdvUidNotBetween(String value1, String value2) {
            addCriterion("adv_uid not between", value1, value2, "advUid");
            return (Criteria) this;
        }

        public Criteria andPurchaseCreateOrderDaysIsNull() {
            addCriterion("purchase_create_order_days is null");
            return (Criteria) this;
        }

        public Criteria andPurchaseCreateOrderDaysIsNotNull() {
            addCriterion("purchase_create_order_days is not null");
            return (Criteria) this;
        }

        public Criteria andPurchaseCreateOrderDaysEqualTo(Integer value) {
            addCriterion("purchase_create_order_days =", value, "purchaseCreateOrderDays");
            return (Criteria) this;
        }

        public Criteria andPurchaseCreateOrderDaysNotEqualTo(Integer value) {
            addCriterion("purchase_create_order_days <>", value, "purchaseCreateOrderDays");
            return (Criteria) this;
        }

        public Criteria andPurchaseCreateOrderDaysGreaterThan(Integer value) {
            addCriterion("purchase_create_order_days >", value, "purchaseCreateOrderDays");
            return (Criteria) this;
        }

        public Criteria andPurchaseCreateOrderDaysGreaterThanOrEqualTo(Integer value) {
            addCriterion("purchase_create_order_days >=", value, "purchaseCreateOrderDays");
            return (Criteria) this;
        }

        public Criteria andPurchaseCreateOrderDaysLessThan(Integer value) {
            addCriterion("purchase_create_order_days <", value, "purchaseCreateOrderDays");
            return (Criteria) this;
        }

        public Criteria andPurchaseCreateOrderDaysLessThanOrEqualTo(Integer value) {
            addCriterion("purchase_create_order_days <=", value, "purchaseCreateOrderDays");
            return (Criteria) this;
        }

        public Criteria andPurchaseCreateOrderDaysIn(List<Integer> values) {
            addCriterion("purchase_create_order_days in", values, "purchaseCreateOrderDays");
            return (Criteria) this;
        }

        public Criteria andPurchaseCreateOrderDaysNotIn(List<Integer> values) {
            addCriterion("purchase_create_order_days not in", values, "purchaseCreateOrderDays");
            return (Criteria) this;
        }

        public Criteria andPurchaseCreateOrderDaysBetween(Integer value1, Integer value2) {
            addCriterion("purchase_create_order_days between", value1, value2, "purchaseCreateOrderDays");
            return (Criteria) this;
        }

        public Criteria andPurchaseCreateOrderDaysNotBetween(Integer value1, Integer value2) {
            addCriterion("purchase_create_order_days not between", value1, value2, "purchaseCreateOrderDays");
            return (Criteria) this;
        }
    }

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table dc_auto_turnover_air
     *
     * @mbg.generated do_not_delete_during_merge
     */
    public static class Criteria extends GeneratedCriteria {
        /**
         * This field was generated by MyBatis Generator.
         * This field corresponds to the database table dc_auto_turnover_air
         *
         * @mbg.generated
         * @project https://github.com/itfsw/mybatis-generator-plugin
         */
        private DcAutoTurnoverAirExample example;

        /**
         * This method was generated by MyBatis Generator.
         * This method corresponds to the database table dc_auto_turnover_air
         *
         * @mbg.generated
         * @project https://github.com/itfsw/mybatis-generator-plugin
         */
        protected Criteria(DcAutoTurnoverAirExample example) {
            super();
            this.example = example;
        }

        /**
         * This method was generated by MyBatis Generator.
         * This method corresponds to the database table dc_auto_turnover_air
         *
         * @mbg.generated
         * @project https://github.com/itfsw/mybatis-generator-plugin
         */
        public DcAutoTurnoverAirExample example() {
            return this.example;
        }

        /**
         * This method was generated by MyBatis Generator.
         * This method corresponds to the database table dc_auto_turnover_air
         *
         * @mbg.generated
         * @project https://github.com/itfsw/mybatis-generator-plugin
         */
        @Deprecated
        public Criteria andIf(boolean ifAdd, ICriteriaAdd add) {
            if (ifAdd) {
                add.add(this);
            }
            return this;
        }

        /**
         * This method was generated by MyBatis Generator.
         * This method corresponds to the database table dc_auto_turnover_air
         *
         * @mbg.generated
         * @project https://github.com/itfsw/mybatis-generator-plugin
         */
        public Criteria when(boolean condition, ICriteriaWhen then) {
            if (condition) {
                then.criteria(this);
            }
            return this;
        }

        /**
         * This method was generated by MyBatis Generator.
         * This method corresponds to the database table dc_auto_turnover_air
         *
         * @mbg.generated
         * @project https://github.com/itfsw/mybatis-generator-plugin
         */
        public Criteria when(boolean condition, ICriteriaWhen then, ICriteriaWhen otherwise) {
            if (condition) {
                then.criteria(this);
            } else {
                otherwise.criteria(this);
            }
            return this;
        }

        /**
         * This interface was generated by MyBatis Generator.
         * This interface corresponds to the database table dc_auto_turnover_air
         *
         * @mbg.generated
         * @project https://github.com/itfsw/mybatis-generator-plugin
         */
        @Deprecated
        public interface ICriteriaAdd {
            /**
             * This method was generated by MyBatis Generator.
             * This method corresponds to the database table dc_auto_turnover_air
             *
             * @mbg.generated
             * @project https://github.com/itfsw/mybatis-generator-plugin
             */
            Criteria add(Criteria add);
        }
    }

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table dc_auto_turnover_air
     *
     * @mbg.generated
     */
    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);
        }
    }

    /**
     * This interface was generated by MyBatis Generator.
     * This interface corresponds to the database table dc_auto_turnover_air
     *
     * @mbg.generated
     * @project https://github.com/itfsw/mybatis-generator-plugin
     */
    public interface ICriteriaWhen {
        /**
         * This method was generated by MyBatis Generator.
         * This method corresponds to the database table dc_auto_turnover_air
         *
         * @mbg.generated
         * @project https://github.com/itfsw/mybatis-generator-plugin
         */
        void criteria(Criteria criteria);
    }

    /**
     * This interface was generated by MyBatis Generator.
     * This interface corresponds to the database table dc_auto_turnover_air
     *
     * @mbg.generated
     * @project https://github.com/itfsw/mybatis-generator-plugin
     */
    public interface IExampleWhen {
        /**
         * This method was generated by MyBatis Generator.
         * This method corresponds to the database table dc_auto_turnover_air
         *
         * @mbg.generated
         * @project https://github.com/itfsw/mybatis-generator-plugin
         */
        void example(com.bailuntec.domain.example.DcAutoTurnoverAirExample example);
    }
}