package com.bailuntec.domain.example;

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

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

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

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

    /**
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database table dc_auto_turnover
     *
     * @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
     *
     * @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
     *
     * @mbg.generated
     */
    public DcAutoTurnoverExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_auto_turnover
     *
     * @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
     *
     * @mbg.generated
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_auto_turnover
     *
     * @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
     *
     * @mbg.generated
     */
    public boolean isDistinct() {
        return distinct;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_auto_turnover
     *
     * @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
     *
     * @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
     *
     * @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
     *
     * @mbg.generated
     * @project https://github.com/itfsw/mybatis-generator-plugin
     */
    public DcAutoTurnoverExample 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
     *
     * @mbg.generated
     * @project https://github.com/itfsw/mybatis-generator-plugin
     */
    public DcAutoTurnoverExample 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
     *
     * @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
     *
     * @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
     *
     * @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
     *
     * @mbg.generated
     * @project https://github.com/itfsw/mybatis-generator-plugin
     */
    public static Criteria newAndCreateCriteria() {
        DcAutoTurnoverExample example = new DcAutoTurnoverExample();
        return example.createCriteria();
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_auto_turnover
     *
     * @mbg.generated
     * @project https://github.com/itfsw/mybatis-generator-plugin
     */
    public DcAutoTurnoverExample 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
     *
     * @mbg.generated
     * @project https://github.com/itfsw/mybatis-generator-plugin
     */
    public DcAutoTurnoverExample 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
     *
     * @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
     *
     * @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
     *
     * @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
     *
     * @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
     *
     * @mbg.generated
     * @project https://github.com/itfsw/mybatis-generator-plugin
     */
    public DcAutoTurnoverExample 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
     *
     * @mbg.generated
     * @project https://github.com/itfsw/mybatis-generator-plugin
     */
    public DcAutoTurnoverExample 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
     *
     * @mbg.generated
     * @project https://github.com/itfsw/mybatis-generator-plugin
     */
    public DcAutoTurnoverExample 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
     *
     * @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(Integer value) {
            addCriterion("status =", value, "status");
            return (Criteria) this;
        }

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

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

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

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

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

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

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

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

        public Criteria andStatusNotBetween(Integer value1, Integer 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 andSalesDetailsIsNull() {
            addCriterion("sales_details is null");
            return (Criteria) this;
        }

        public Criteria andSalesDetailsIsNotNull() {
            addCriterion("sales_details is not null");
            return (Criteria) this;
        }

        public Criteria andSalesDetailsEqualTo(String value) {
            addCriterion("sales_details =", value, "salesDetails");
            return (Criteria) this;
        }

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

        public Criteria andSalesDetailsGreaterThan(String value) {
            addCriterion("sales_details >", value, "salesDetails");
            return (Criteria) this;
        }

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

        public Criteria andSalesDetailsLessThan(String value) {
            addCriterion("sales_details <", value, "salesDetails");
            return (Criteria) this;
        }

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

        public Criteria andSalesDetailsLike(String value) {
            addCriterion("sales_details like", value, "salesDetails");
            return (Criteria) this;
        }

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

        public Criteria andSalesDetailsIn(List<String> values) {
            addCriterion("sales_details in", values, "salesDetails");
            return (Criteria) this;
        }

        public Criteria andSalesDetailsNotIn(List<String> values) {
            addCriterion("sales_details not in", values, "salesDetails");
            return (Criteria) this;
        }

        public Criteria andSalesDetailsBetween(String value1, String value2) {
            addCriterion("sales_details between", value1, value2, "salesDetails");
            return (Criteria) this;
        }

        public Criteria andSalesDetailsNotBetween(String value1, String value2) {
            addCriterion("sales_details not between", value1, value2, "salesDetails");
            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 andShortSupplyDetailsIsNull() {
            addCriterion("short_supply_details is null");
            return (Criteria) this;
        }

        public Criteria andShortSupplyDetailsIsNotNull() {
            addCriterion("short_supply_details is not null");
            return (Criteria) this;
        }

        public Criteria andShortSupplyDetailsEqualTo(String value) {
            addCriterion("short_supply_details =", value, "shortSupplyDetails");
            return (Criteria) this;
        }

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

        public Criteria andShortSupplyDetailsGreaterThan(String value) {
            addCriterion("short_supply_details >", value, "shortSupplyDetails");
            return (Criteria) this;
        }

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

        public Criteria andShortSupplyDetailsLessThan(String value) {
            addCriterion("short_supply_details <", value, "shortSupplyDetails");
            return (Criteria) this;
        }

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

        public Criteria andShortSupplyDetailsLike(String value) {
            addCriterion("short_supply_details like", value, "shortSupplyDetails");
            return (Criteria) this;
        }

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

        public Criteria andShortSupplyDetailsIn(List<String> values) {
            addCriterion("short_supply_details in", values, "shortSupplyDetails");
            return (Criteria) this;
        }

        public Criteria andShortSupplyDetailsNotIn(List<String> values) {
            addCriterion("short_supply_details not in", values, "shortSupplyDetails");
            return (Criteria) this;
        }

        public Criteria andShortSupplyDetailsBetween(String value1, String value2) {
            addCriterion("short_supply_details between", value1, value2, "shortSupplyDetails");
            return (Criteria) this;
        }

        public Criteria andShortSupplyDetailsNotBetween(String value1, String value2) {
            addCriterion("short_supply_details not between", value1, value2, "shortSupplyDetails");
            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 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 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 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 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;
        }
    }

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table dc_auto_turnover
     *
     * @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
         *
         * @mbg.generated
         * @project https://github.com/itfsw/mybatis-generator-plugin
         */
        private DcAutoTurnoverExample example;

        /**
         * This method was generated by MyBatis Generator.
         * This method corresponds to the database table dc_auto_turnover
         *
         * @mbg.generated
         * @project https://github.com/itfsw/mybatis-generator-plugin
         */
        protected Criteria(DcAutoTurnoverExample example) {
            super();
            this.example = example;
        }

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

        /**
         * This method was generated by MyBatis Generator.
         * This method corresponds to the database table dc_auto_turnover
         *
         * @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
         *
         * @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
         *
         * @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
         *
         * @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
             *
             * @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
     *
     * @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
     *
     * @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
         *
         * @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
     *
     * @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
         *
         * @mbg.generated
         * @project https://github.com/itfsw/mybatis-generator-plugin
         */
        void example(DcAutoTurnoverExample example);
    }
}