package com.zteits.pay.domain;

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

public class TdCCustInvoiceHisExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

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

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

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

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

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

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

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

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

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

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

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

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

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

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

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

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

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

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

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

        public Criteria andInvoiceIdIsNull() {
            addCriterion("invoice_id is null");
            return (Criteria) this;
        }

        public Criteria andInvoiceIdIsNotNull() {
            addCriterion("invoice_id is not null");
            return (Criteria) this;
        }

        public Criteria andInvoiceIdEqualTo(String value) {
            addCriterion("invoice_id =", value, "invoiceId");
            return (Criteria) this;
        }

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

        public Criteria andInvoiceIdGreaterThan(String value) {
            addCriterion("invoice_id >", value, "invoiceId");
            return (Criteria) this;
        }

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

        public Criteria andInvoiceIdLessThan(String value) {
            addCriterion("invoice_id <", value, "invoiceId");
            return (Criteria) this;
        }

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

        public Criteria andInvoiceIdLike(String value) {
            addCriterion("invoice_id like", value, "invoiceId");
            return (Criteria) this;
        }

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

        public Criteria andInvoiceIdIn(List<String> values) {
            addCriterion("invoice_id in", values, "invoiceId");
            return (Criteria) this;
        }

        public Criteria andInvoiceIdNotIn(List<String> values) {
            addCriterion("invoice_id not in", values, "invoiceId");
            return (Criteria) this;
        }

        public Criteria andInvoiceIdBetween(String value1, String value2) {
            addCriterion("invoice_id between", value1, value2, "invoiceId");
            return (Criteria) this;
        }

        public Criteria andInvoiceIdNotBetween(String value1, String value2) {
            addCriterion("invoice_id not between", value1, value2, "invoiceId");
            return (Criteria) this;
        }

        public Criteria andInvoiceCodeIsNull() {
            addCriterion("invoice_code is null");
            return (Criteria) this;
        }

        public Criteria andInvoiceCodeIsNotNull() {
            addCriterion("invoice_code is not null");
            return (Criteria) this;
        }

        public Criteria andInvoiceCodeEqualTo(String value) {
            addCriterion("invoice_code =", value, "invoiceCode");
            return (Criteria) this;
        }

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

        public Criteria andInvoiceCodeGreaterThan(String value) {
            addCriterion("invoice_code >", value, "invoiceCode");
            return (Criteria) this;
        }

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

        public Criteria andInvoiceCodeLessThan(String value) {
            addCriterion("invoice_code <", value, "invoiceCode");
            return (Criteria) this;
        }

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

        public Criteria andInvoiceCodeLike(String value) {
            addCriterion("invoice_code like", value, "invoiceCode");
            return (Criteria) this;
        }

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

        public Criteria andInvoiceCodeIn(List<String> values) {
            addCriterion("invoice_code in", values, "invoiceCode");
            return (Criteria) this;
        }

        public Criteria andInvoiceCodeNotIn(List<String> values) {
            addCriterion("invoice_code not in", values, "invoiceCode");
            return (Criteria) this;
        }

        public Criteria andInvoiceCodeBetween(String value1, String value2) {
            addCriterion("invoice_code between", value1, value2, "invoiceCode");
            return (Criteria) this;
        }

        public Criteria andInvoiceCodeNotBetween(String value1, String value2) {
            addCriterion("invoice_code not between", value1, value2, "invoiceCode");
            return (Criteria) this;
        }

        public Criteria andInvoiceNumberIsNull() {
            addCriterion("invoice_number is null");
            return (Criteria) this;
        }

        public Criteria andInvoiceNumberIsNotNull() {
            addCriterion("invoice_number is not null");
            return (Criteria) this;
        }

        public Criteria andInvoiceNumberEqualTo(String value) {
            addCriterion("invoice_number =", value, "invoiceNumber");
            return (Criteria) this;
        }

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

        public Criteria andInvoiceNumberGreaterThan(String value) {
            addCriterion("invoice_number >", value, "invoiceNumber");
            return (Criteria) this;
        }

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

        public Criteria andInvoiceNumberLessThan(String value) {
            addCriterion("invoice_number <", value, "invoiceNumber");
            return (Criteria) this;
        }

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

        public Criteria andInvoiceNumberLike(String value) {
            addCriterion("invoice_number like", value, "invoiceNumber");
            return (Criteria) this;
        }

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

        public Criteria andInvoiceNumberIn(List<String> values) {
            addCriterion("invoice_number in", values, "invoiceNumber");
            return (Criteria) this;
        }

        public Criteria andInvoiceNumberNotIn(List<String> values) {
            addCriterion("invoice_number not in", values, "invoiceNumber");
            return (Criteria) this;
        }

        public Criteria andInvoiceNumberBetween(String value1, String value2) {
            addCriterion("invoice_number between", value1, value2, "invoiceNumber");
            return (Criteria) this;
        }

        public Criteria andInvoiceNumberNotBetween(String value1, String value2) {
            addCriterion("invoice_number not between", value1, value2, "invoiceNumber");
            return (Criteria) this;
        }

        public Criteria andInvoiceUrlIsNull() {
            addCriterion("invoice_url is null");
            return (Criteria) this;
        }

        public Criteria andInvoiceUrlIsNotNull() {
            addCriterion("invoice_url is not null");
            return (Criteria) this;
        }

        public Criteria andInvoiceUrlEqualTo(String value) {
            addCriterion("invoice_url =", value, "invoiceUrl");
            return (Criteria) this;
        }

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

        public Criteria andInvoiceUrlGreaterThan(String value) {
            addCriterion("invoice_url >", value, "invoiceUrl");
            return (Criteria) this;
        }

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

        public Criteria andInvoiceUrlLessThan(String value) {
            addCriterion("invoice_url <", value, "invoiceUrl");
            return (Criteria) this;
        }

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

        public Criteria andInvoiceUrlLike(String value) {
            addCriterion("invoice_url like", value, "invoiceUrl");
            return (Criteria) this;
        }

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

        public Criteria andInvoiceUrlIn(List<String> values) {
            addCriterion("invoice_url in", values, "invoiceUrl");
            return (Criteria) this;
        }

        public Criteria andInvoiceUrlNotIn(List<String> values) {
            addCriterion("invoice_url not in", values, "invoiceUrl");
            return (Criteria) this;
        }

        public Criteria andInvoiceUrlBetween(String value1, String value2) {
            addCriterion("invoice_url between", value1, value2, "invoiceUrl");
            return (Criteria) this;
        }

        public Criteria andInvoiceUrlNotBetween(String value1, String value2) {
            addCriterion("invoice_url not between", value1, value2, "invoiceUrl");
            return (Criteria) this;
        }

        public Criteria andCustIdIsNull() {
            addCriterion("cust_id is null");
            return (Criteria) this;
        }

        public Criteria andCustIdIsNotNull() {
            addCriterion("cust_id is not null");
            return (Criteria) this;
        }

        public Criteria andCustIdEqualTo(String value) {
            addCriterion("cust_id =", value, "custId");
            return (Criteria) this;
        }

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

        public Criteria andCustIdGreaterThan(String value) {
            addCriterion("cust_id >", value, "custId");
            return (Criteria) this;
        }

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

        public Criteria andCustIdLessThan(String value) {
            addCriterion("cust_id <", value, "custId");
            return (Criteria) this;
        }

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

        public Criteria andCustIdLike(String value) {
            addCriterion("cust_id like", value, "custId");
            return (Criteria) this;
        }

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

        public Criteria andCustIdIn(List<String> values) {
            addCriterion("cust_id in", values, "custId");
            return (Criteria) this;
        }

        public Criteria andCustIdNotIn(List<String> values) {
            addCriterion("cust_id not in", values, "custId");
            return (Criteria) this;
        }

        public Criteria andCustIdBetween(String value1, String value2) {
            addCriterion("cust_id between", value1, value2, "custId");
            return (Criteria) this;
        }

        public Criteria andCustIdNotBetween(String value1, String value2) {
            addCriterion("cust_id not between", value1, value2, "custId");
            return (Criteria) this;
        }

        public Criteria andInvoiceObjectIsNull() {
            addCriterion("invoice_object is null");
            return (Criteria) this;
        }

        public Criteria andInvoiceObjectIsNotNull() {
            addCriterion("invoice_object is not null");
            return (Criteria) this;
        }

        public Criteria andInvoiceObjectEqualTo(String value) {
            addCriterion("invoice_object =", value, "invoiceObject");
            return (Criteria) this;
        }

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

        public Criteria andInvoiceObjectGreaterThan(String value) {
            addCriterion("invoice_object >", value, "invoiceObject");
            return (Criteria) this;
        }

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

        public Criteria andInvoiceObjectLessThan(String value) {
            addCriterion("invoice_object <", value, "invoiceObject");
            return (Criteria) this;
        }

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

        public Criteria andInvoiceObjectLike(String value) {
            addCriterion("invoice_object like", value, "invoiceObject");
            return (Criteria) this;
        }

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

        public Criteria andInvoiceObjectIn(List<String> values) {
            addCriterion("invoice_object in", values, "invoiceObject");
            return (Criteria) this;
        }

        public Criteria andInvoiceObjectNotIn(List<String> values) {
            addCriterion("invoice_object not in", values, "invoiceObject");
            return (Criteria) this;
        }

        public Criteria andInvoiceObjectBetween(String value1, String value2) {
            addCriterion("invoice_object between", value1, value2, "invoiceObject");
            return (Criteria) this;
        }

        public Criteria andInvoiceObjectNotBetween(String value1, String value2) {
            addCriterion("invoice_object not between", value1, value2, "invoiceObject");
            return (Criteria) this;
        }

        public Criteria andInvoiceTotalFeeIsNull() {
            addCriterion("invoice_total_fee is null");
            return (Criteria) this;
        }

        public Criteria andInvoiceTotalFeeIsNotNull() {
            addCriterion("invoice_total_fee is not null");
            return (Criteria) this;
        }

        public Criteria andInvoiceTotalFeeEqualTo(BigDecimal value) {
            addCriterion("invoice_total_fee =", value, "invoiceTotalFee");
            return (Criteria) this;
        }

        public Criteria andInvoiceTotalFeeNotEqualTo(BigDecimal value) {
            addCriterion("invoice_total_fee <>", value, "invoiceTotalFee");
            return (Criteria) this;
        }

        public Criteria andInvoiceTotalFeeGreaterThan(BigDecimal value) {
            addCriterion("invoice_total_fee >", value, "invoiceTotalFee");
            return (Criteria) this;
        }

        public Criteria andInvoiceTotalFeeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("invoice_total_fee >=", value, "invoiceTotalFee");
            return (Criteria) this;
        }

        public Criteria andInvoiceTotalFeeLessThan(BigDecimal value) {
            addCriterion("invoice_total_fee <", value, "invoiceTotalFee");
            return (Criteria) this;
        }

        public Criteria andInvoiceTotalFeeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("invoice_total_fee <=", value, "invoiceTotalFee");
            return (Criteria) this;
        }

        public Criteria andInvoiceTotalFeeIn(List<BigDecimal> values) {
            addCriterion("invoice_total_fee in", values, "invoiceTotalFee");
            return (Criteria) this;
        }

        public Criteria andInvoiceTotalFeeNotIn(List<BigDecimal> values) {
            addCriterion("invoice_total_fee not in", values, "invoiceTotalFee");
            return (Criteria) this;
        }

        public Criteria andInvoiceTotalFeeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("invoice_total_fee between", value1, value2, "invoiceTotalFee");
            return (Criteria) this;
        }

        public Criteria andInvoiceTotalFeeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("invoice_total_fee not between", value1, value2, "invoiceTotalFee");
            return (Criteria) this;
        }

        public Criteria andInvoiceFeeIsNull() {
            addCriterion("invoice_fee is null");
            return (Criteria) this;
        }

        public Criteria andInvoiceFeeIsNotNull() {
            addCriterion("invoice_fee is not null");
            return (Criteria) this;
        }

        public Criteria andInvoiceFeeEqualTo(BigDecimal value) {
            addCriterion("invoice_fee =", value, "invoiceFee");
            return (Criteria) this;
        }

        public Criteria andInvoiceFeeNotEqualTo(BigDecimal value) {
            addCriterion("invoice_fee <>", value, "invoiceFee");
            return (Criteria) this;
        }

        public Criteria andInvoiceFeeGreaterThan(BigDecimal value) {
            addCriterion("invoice_fee >", value, "invoiceFee");
            return (Criteria) this;
        }

        public Criteria andInvoiceFeeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("invoice_fee >=", value, "invoiceFee");
            return (Criteria) this;
        }

        public Criteria andInvoiceFeeLessThan(BigDecimal value) {
            addCriterion("invoice_fee <", value, "invoiceFee");
            return (Criteria) this;
        }

        public Criteria andInvoiceFeeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("invoice_fee <=", value, "invoiceFee");
            return (Criteria) this;
        }

        public Criteria andInvoiceFeeIn(List<BigDecimal> values) {
            addCriterion("invoice_fee in", values, "invoiceFee");
            return (Criteria) this;
        }

        public Criteria andInvoiceFeeNotIn(List<BigDecimal> values) {
            addCriterion("invoice_fee not in", values, "invoiceFee");
            return (Criteria) this;
        }

        public Criteria andInvoiceFeeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("invoice_fee between", value1, value2, "invoiceFee");
            return (Criteria) this;
        }

        public Criteria andInvoiceFeeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("invoice_fee not between", value1, value2, "invoiceFee");
            return (Criteria) this;
        }

        public Criteria andInvoiceTaxRateIsNull() {
            addCriterion("invoice_tax_rate is null");
            return (Criteria) this;
        }

        public Criteria andInvoiceTaxRateIsNotNull() {
            addCriterion("invoice_tax_rate is not null");
            return (Criteria) this;
        }

        public Criteria andInvoiceTaxRateEqualTo(BigDecimal value) {
            addCriterion("invoice_tax_rate =", value, "invoiceTaxRate");
            return (Criteria) this;
        }

        public Criteria andInvoiceTaxRateNotEqualTo(BigDecimal value) {
            addCriterion("invoice_tax_rate <>", value, "invoiceTaxRate");
            return (Criteria) this;
        }

        public Criteria andInvoiceTaxRateGreaterThan(BigDecimal value) {
            addCriterion("invoice_tax_rate >", value, "invoiceTaxRate");
            return (Criteria) this;
        }

        public Criteria andInvoiceTaxRateGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("invoice_tax_rate >=", value, "invoiceTaxRate");
            return (Criteria) this;
        }

        public Criteria andInvoiceTaxRateLessThan(BigDecimal value) {
            addCriterion("invoice_tax_rate <", value, "invoiceTaxRate");
            return (Criteria) this;
        }

        public Criteria andInvoiceTaxRateLessThanOrEqualTo(BigDecimal value) {
            addCriterion("invoice_tax_rate <=", value, "invoiceTaxRate");
            return (Criteria) this;
        }

        public Criteria andInvoiceTaxRateIn(List<BigDecimal> values) {
            addCriterion("invoice_tax_rate in", values, "invoiceTaxRate");
            return (Criteria) this;
        }

        public Criteria andInvoiceTaxRateNotIn(List<BigDecimal> values) {
            addCriterion("invoice_tax_rate not in", values, "invoiceTaxRate");
            return (Criteria) this;
        }

        public Criteria andInvoiceTaxRateBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("invoice_tax_rate between", value1, value2, "invoiceTaxRate");
            return (Criteria) this;
        }

        public Criteria andInvoiceTaxRateNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("invoice_tax_rate not between", value1, value2, "invoiceTaxRate");
            return (Criteria) this;
        }

        public Criteria andInvoiceTaxFeeIsNull() {
            addCriterion("invoice_tax_fee is null");
            return (Criteria) this;
        }

        public Criteria andInvoiceTaxFeeIsNotNull() {
            addCriterion("invoice_tax_fee is not null");
            return (Criteria) this;
        }

        public Criteria andInvoiceTaxFeeEqualTo(BigDecimal value) {
            addCriterion("invoice_tax_fee =", value, "invoiceTaxFee");
            return (Criteria) this;
        }

        public Criteria andInvoiceTaxFeeNotEqualTo(BigDecimal value) {
            addCriterion("invoice_tax_fee <>", value, "invoiceTaxFee");
            return (Criteria) this;
        }

        public Criteria andInvoiceTaxFeeGreaterThan(BigDecimal value) {
            addCriterion("invoice_tax_fee >", value, "invoiceTaxFee");
            return (Criteria) this;
        }

        public Criteria andInvoiceTaxFeeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("invoice_tax_fee >=", value, "invoiceTaxFee");
            return (Criteria) this;
        }

        public Criteria andInvoiceTaxFeeLessThan(BigDecimal value) {
            addCriterion("invoice_tax_fee <", value, "invoiceTaxFee");
            return (Criteria) this;
        }

        public Criteria andInvoiceTaxFeeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("invoice_tax_fee <=", value, "invoiceTaxFee");
            return (Criteria) this;
        }

        public Criteria andInvoiceTaxFeeIn(List<BigDecimal> values) {
            addCriterion("invoice_tax_fee in", values, "invoiceTaxFee");
            return (Criteria) this;
        }

        public Criteria andInvoiceTaxFeeNotIn(List<BigDecimal> values) {
            addCriterion("invoice_tax_fee not in", values, "invoiceTaxFee");
            return (Criteria) this;
        }

        public Criteria andInvoiceTaxFeeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("invoice_tax_fee between", value1, value2, "invoiceTaxFee");
            return (Criteria) this;
        }

        public Criteria andInvoiceTaxFeeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("invoice_tax_fee not between", value1, value2, "invoiceTaxFee");
            return (Criteria) this;
        }

        public Criteria andInvoiceStateIsNull() {
            addCriterion("invoice_state is null");
            return (Criteria) this;
        }

        public Criteria andInvoiceStateIsNotNull() {
            addCriterion("invoice_state is not null");
            return (Criteria) this;
        }

        public Criteria andInvoiceStateEqualTo(String value) {
            addCriterion("invoice_state =", value, "invoiceState");
            return (Criteria) this;
        }

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

        public Criteria andInvoiceStateGreaterThan(String value) {
            addCriterion("invoice_state >", value, "invoiceState");
            return (Criteria) this;
        }

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

        public Criteria andInvoiceStateLessThan(String value) {
            addCriterion("invoice_state <", value, "invoiceState");
            return (Criteria) this;
        }

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

        public Criteria andInvoiceStateLike(String value) {
            addCriterion("invoice_state like", value, "invoiceState");
            return (Criteria) this;
        }

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

        public Criteria andInvoiceStateIn(List<String> values) {
            addCriterion("invoice_state in", values, "invoiceState");
            return (Criteria) this;
        }

        public Criteria andInvoiceStateNotIn(List<String> values) {
            addCriterion("invoice_state not in", values, "invoiceState");
            return (Criteria) this;
        }

        public Criteria andInvoiceStateBetween(String value1, String value2) {
            addCriterion("invoice_state between", value1, value2, "invoiceState");
            return (Criteria) this;
        }

        public Criteria andInvoiceStateNotBetween(String value1, String value2) {
            addCriterion("invoice_state not between", value1, value2, "invoiceState");
            return (Criteria) this;
        }

        public Criteria andPostNameIdIsNull() {
            addCriterion("post_name_id is null");
            return (Criteria) this;
        }

        public Criteria andPostNameIdIsNotNull() {
            addCriterion("post_name_id is not null");
            return (Criteria) this;
        }

        public Criteria andPostNameIdEqualTo(Long value) {
            addCriterion("post_name_id =", value, "postNameId");
            return (Criteria) this;
        }

        public Criteria andPostNameIdNotEqualTo(Long value) {
            addCriterion("post_name_id <>", value, "postNameId");
            return (Criteria) this;
        }

        public Criteria andPostNameIdGreaterThan(Long value) {
            addCriterion("post_name_id >", value, "postNameId");
            return (Criteria) this;
        }

        public Criteria andPostNameIdGreaterThanOrEqualTo(Long value) {
            addCriterion("post_name_id >=", value, "postNameId");
            return (Criteria) this;
        }

        public Criteria andPostNameIdLessThan(Long value) {
            addCriterion("post_name_id <", value, "postNameId");
            return (Criteria) this;
        }

        public Criteria andPostNameIdLessThanOrEqualTo(Long value) {
            addCriterion("post_name_id <=", value, "postNameId");
            return (Criteria) this;
        }

        public Criteria andPostNameIdIn(List<Long> values) {
            addCriterion("post_name_id in", values, "postNameId");
            return (Criteria) this;
        }

        public Criteria andPostNameIdNotIn(List<Long> values) {
            addCriterion("post_name_id not in", values, "postNameId");
            return (Criteria) this;
        }

        public Criteria andPostNameIdBetween(Long value1, Long value2) {
            addCriterion("post_name_id between", value1, value2, "postNameId");
            return (Criteria) this;
        }

        public Criteria andPostNameIdNotBetween(Long value1, Long value2) {
            addCriterion("post_name_id not between", value1, value2, "postNameId");
            return (Criteria) this;
        }

        public Criteria andPostNameIsNull() {
            addCriterion("post_name is null");
            return (Criteria) this;
        }

        public Criteria andPostNameIsNotNull() {
            addCriterion("post_name is not null");
            return (Criteria) this;
        }

        public Criteria andPostNameEqualTo(String value) {
            addCriterion("post_name =", value, "postName");
            return (Criteria) this;
        }

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

        public Criteria andPostNameGreaterThan(String value) {
            addCriterion("post_name >", value, "postName");
            return (Criteria) this;
        }

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

        public Criteria andPostNameLessThan(String value) {
            addCriterion("post_name <", value, "postName");
            return (Criteria) this;
        }

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

        public Criteria andPostNameLike(String value) {
            addCriterion("post_name like", value, "postName");
            return (Criteria) this;
        }

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

        public Criteria andPostNameIn(List<String> values) {
            addCriterion("post_name in", values, "postName");
            return (Criteria) this;
        }

        public Criteria andPostNameNotIn(List<String> values) {
            addCriterion("post_name not in", values, "postName");
            return (Criteria) this;
        }

        public Criteria andPostNameBetween(String value1, String value2) {
            addCriterion("post_name between", value1, value2, "postName");
            return (Criteria) this;
        }

        public Criteria andPostNameNotBetween(String value1, String value2) {
            addCriterion("post_name not between", value1, value2, "postName");
            return (Criteria) this;
        }

        public Criteria andPostDateIsNull() {
            addCriterion("post_date is null");
            return (Criteria) this;
        }

        public Criteria andPostDateIsNotNull() {
            addCriterion("post_date is not null");
            return (Criteria) this;
        }

        public Criteria andPostDateEqualTo(Date value) {
            addCriterion("post_date =", value, "postDate");
            return (Criteria) this;
        }

        public Criteria andPostDateNotEqualTo(Date value) {
            addCriterion("post_date <>", value, "postDate");
            return (Criteria) this;
        }

        public Criteria andPostDateGreaterThan(Date value) {
            addCriterion("post_date >", value, "postDate");
            return (Criteria) this;
        }

        public Criteria andPostDateGreaterThanOrEqualTo(Date value) {
            addCriterion("post_date >=", value, "postDate");
            return (Criteria) this;
        }

        public Criteria andPostDateLessThan(Date value) {
            addCriterion("post_date <", value, "postDate");
            return (Criteria) this;
        }

        public Criteria andPostDateLessThanOrEqualTo(Date value) {
            addCriterion("post_date <=", value, "postDate");
            return (Criteria) this;
        }

        public Criteria andPostDateIn(List<Date> values) {
            addCriterion("post_date in", values, "postDate");
            return (Criteria) this;
        }

        public Criteria andPostDateNotIn(List<Date> values) {
            addCriterion("post_date not in", values, "postDate");
            return (Criteria) this;
        }

        public Criteria andPostDateBetween(Date value1, Date value2) {
            addCriterion("post_date between", value1, value2, "postDate");
            return (Criteria) this;
        }

        public Criteria andPostDateNotBetween(Date value1, Date value2) {
            addCriterion("post_date not between", value1, value2, "postDate");
            return (Criteria) this;
        }

        public Criteria andPryeeIsNull() {
            addCriterion("pryee is null");
            return (Criteria) this;
        }

        public Criteria andPryeeIsNotNull() {
            addCriterion("pryee is not null");
            return (Criteria) this;
        }

        public Criteria andPryeeEqualTo(String value) {
            addCriterion("pryee =", value, "pryee");
            return (Criteria) this;
        }

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

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

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

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

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

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

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

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

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

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

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

        public Criteria andCheckerIsNull() {
            addCriterion("checker is null");
            return (Criteria) this;
        }

        public Criteria andCheckerIsNotNull() {
            addCriterion("checker is not null");
            return (Criteria) this;
        }

        public Criteria andCheckerEqualTo(String value) {
            addCriterion("checker =", value, "checker");
            return (Criteria) this;
        }

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

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

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

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

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

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

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

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

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

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

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

        public Criteria andDrawerIdIsNull() {
            addCriterion("drawer_id is null");
            return (Criteria) this;
        }

        public Criteria andDrawerIdIsNotNull() {
            addCriterion("drawer_id is not null");
            return (Criteria) this;
        }

        public Criteria andDrawerIdEqualTo(Long value) {
            addCriterion("drawer_id =", value, "drawerId");
            return (Criteria) this;
        }

        public Criteria andDrawerIdNotEqualTo(Long value) {
            addCriterion("drawer_id <>", value, "drawerId");
            return (Criteria) this;
        }

        public Criteria andDrawerIdGreaterThan(Long value) {
            addCriterion("drawer_id >", value, "drawerId");
            return (Criteria) this;
        }

        public Criteria andDrawerIdGreaterThanOrEqualTo(Long value) {
            addCriterion("drawer_id >=", value, "drawerId");
            return (Criteria) this;
        }

        public Criteria andDrawerIdLessThan(Long value) {
            addCriterion("drawer_id <", value, "drawerId");
            return (Criteria) this;
        }

        public Criteria andDrawerIdLessThanOrEqualTo(Long value) {
            addCriterion("drawer_id <=", value, "drawerId");
            return (Criteria) this;
        }

        public Criteria andDrawerIdIn(List<Long> values) {
            addCriterion("drawer_id in", values, "drawerId");
            return (Criteria) this;
        }

        public Criteria andDrawerIdNotIn(List<Long> values) {
            addCriterion("drawer_id not in", values, "drawerId");
            return (Criteria) this;
        }

        public Criteria andDrawerIdBetween(Long value1, Long value2) {
            addCriterion("drawer_id between", value1, value2, "drawerId");
            return (Criteria) this;
        }

        public Criteria andDrawerIdNotBetween(Long value1, Long value2) {
            addCriterion("drawer_id not between", value1, value2, "drawerId");
            return (Criteria) this;
        }

        public Criteria andDrawerIsNull() {
            addCriterion("drawer is null");
            return (Criteria) this;
        }

        public Criteria andDrawerIsNotNull() {
            addCriterion("drawer is not null");
            return (Criteria) this;
        }

        public Criteria andDrawerEqualTo(String value) {
            addCriterion("drawer =", value, "drawer");
            return (Criteria) this;
        }

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

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

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

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

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

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

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

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

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

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

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

        public Criteria andInvoiceDateIsNull() {
            addCriterion("invoice_date is null");
            return (Criteria) this;
        }

        public Criteria andInvoiceDateIsNotNull() {
            addCriterion("invoice_date is not null");
            return (Criteria) this;
        }

        public Criteria andInvoiceDateEqualTo(Date value) {
            addCriterion("invoice_date =", value, "invoiceDate");
            return (Criteria) this;
        }

        public Criteria andInvoiceDateNotEqualTo(Date value) {
            addCriterion("invoice_date <>", value, "invoiceDate");
            return (Criteria) this;
        }

        public Criteria andInvoiceDateGreaterThan(Date value) {
            addCriterion("invoice_date >", value, "invoiceDate");
            return (Criteria) this;
        }

        public Criteria andInvoiceDateGreaterThanOrEqualTo(Date value) {
            addCriterion("invoice_date >=", value, "invoiceDate");
            return (Criteria) this;
        }

        public Criteria andInvoiceDateLessThan(Date value) {
            addCriterion("invoice_date <", value, "invoiceDate");
            return (Criteria) this;
        }

        public Criteria andInvoiceDateLessThanOrEqualTo(Date value) {
            addCriterion("invoice_date <=", value, "invoiceDate");
            return (Criteria) this;
        }

        public Criteria andInvoiceDateIn(List<Date> values) {
            addCriterion("invoice_date in", values, "invoiceDate");
            return (Criteria) this;
        }

        public Criteria andInvoiceDateNotIn(List<Date> values) {
            addCriterion("invoice_date not in", values, "invoiceDate");
            return (Criteria) this;
        }

        public Criteria andInvoiceDateBetween(Date value1, Date value2) {
            addCriterion("invoice_date between", value1, value2, "invoiceDate");
            return (Criteria) this;
        }

        public Criteria andInvoiceDateNotBetween(Date value1, Date value2) {
            addCriterion("invoice_date not between", value1, value2, "invoiceDate");
            return (Criteria) this;
        }

        public Criteria andPdfMd5IsNull() {
            addCriterion("pdf_md5 is null");
            return (Criteria) this;
        }

        public Criteria andPdfMd5IsNotNull() {
            addCriterion("pdf_md5 is not null");
            return (Criteria) this;
        }

        public Criteria andPdfMd5EqualTo(String value) {
            addCriterion("pdf_md5 =", value, "pdfMd5");
            return (Criteria) this;
        }

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

        public Criteria andPdfMd5GreaterThan(String value) {
            addCriterion("pdf_md5 >", value, "pdfMd5");
            return (Criteria) this;
        }

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

        public Criteria andPdfMd5LessThan(String value) {
            addCriterion("pdf_md5 <", value, "pdfMd5");
            return (Criteria) this;
        }

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

        public Criteria andPdfMd5Like(String value) {
            addCriterion("pdf_md5 like", value, "pdfMd5");
            return (Criteria) this;
        }

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

        public Criteria andPdfMd5In(List<String> values) {
            addCriterion("pdf_md5 in", values, "pdfMd5");
            return (Criteria) this;
        }

        public Criteria andPdfMd5NotIn(List<String> values) {
            addCriterion("pdf_md5 not in", values, "pdfMd5");
            return (Criteria) this;
        }

        public Criteria andPdfMd5Between(String value1, String value2) {
            addCriterion("pdf_md5 between", value1, value2, "pdfMd5");
            return (Criteria) this;
        }

        public Criteria andPdfMd5NotBetween(String value1, String value2) {
            addCriterion("pdf_md5 not between", value1, value2, "pdfMd5");
            return (Criteria) this;
        }

        public Criteria andMsgIsNull() {
            addCriterion("msg is null");
            return (Criteria) this;
        }

        public Criteria andMsgIsNotNull() {
            addCriterion("msg is not null");
            return (Criteria) this;
        }

        public Criteria andMsgEqualTo(String value) {
            addCriterion("msg =", value, "msg");
            return (Criteria) this;
        }

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

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

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

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

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

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

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

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

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

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

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

        public Criteria andHjbhsjeIsNull() {
            addCriterion("hjbhsje is null");
            return (Criteria) this;
        }

        public Criteria andHjbhsjeIsNotNull() {
            addCriterion("hjbhsje is not null");
            return (Criteria) this;
        }

        public Criteria andHjbhsjeEqualTo(String value) {
            addCriterion("hjbhsje =", value, "hjbhsje");
            return (Criteria) this;
        }

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

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

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

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

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

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

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

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

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

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

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

        public Criteria andKphjseIsNull() {
            addCriterion("kphjse is null");
            return (Criteria) this;
        }

        public Criteria andKphjseIsNotNull() {
            addCriterion("kphjse is not null");
            return (Criteria) this;
        }

        public Criteria andKphjseEqualTo(String value) {
            addCriterion("kphjse =", value, "kphjse");
            return (Criteria) this;
        }

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

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

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

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

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

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

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

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

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

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

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

        public Criteria andCustNameIsNull() {
            addCriterion("cust_name is null");
            return (Criteria) this;
        }

        public Criteria andCustNameIsNotNull() {
            addCriterion("cust_name is not null");
            return (Criteria) this;
        }

        public Criteria andCustNameEqualTo(String value) {
            addCriterion("cust_name =", value, "custName");
            return (Criteria) this;
        }

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

        public Criteria andCustNameGreaterThan(String value) {
            addCriterion("cust_name >", value, "custName");
            return (Criteria) this;
        }

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

        public Criteria andCustNameLessThan(String value) {
            addCriterion("cust_name <", value, "custName");
            return (Criteria) this;
        }

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

        public Criteria andCustNameLike(String value) {
            addCriterion("cust_name like", value, "custName");
            return (Criteria) this;
        }

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

        public Criteria andCustNameIn(List<String> values) {
            addCriterion("cust_name in", values, "custName");
            return (Criteria) this;
        }

        public Criteria andCustNameNotIn(List<String> values) {
            addCriterion("cust_name not in", values, "custName");
            return (Criteria) this;
        }

        public Criteria andCustNameBetween(String value1, String value2) {
            addCriterion("cust_name between", value1, value2, "custName");
            return (Criteria) this;
        }

        public Criteria andCustNameNotBetween(String value1, String value2) {
            addCriterion("cust_name not between", value1, value2, "custName");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeIsNull() {
            addCriterion("invoice_type is null");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeIsNotNull() {
            addCriterion("invoice_type is not null");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeEqualTo(String value) {
            addCriterion("invoice_type =", value, "invoiceType");
            return (Criteria) this;
        }

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

        public Criteria andInvoiceTypeGreaterThan(String value) {
            addCriterion("invoice_type >", value, "invoiceType");
            return (Criteria) this;
        }

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

        public Criteria andInvoiceTypeLessThan(String value) {
            addCriterion("invoice_type <", value, "invoiceType");
            return (Criteria) this;
        }

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

        public Criteria andInvoiceTypeLike(String value) {
            addCriterion("invoice_type like", value, "invoiceType");
            return (Criteria) this;
        }

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

        public Criteria andInvoiceTypeIn(List<String> values) {
            addCriterion("invoice_type in", values, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeNotIn(List<String> values) {
            addCriterion("invoice_type not in", values, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeBetween(String value1, String value2) {
            addCriterion("invoice_type between", value1, value2, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeNotBetween(String value1, String value2) {
            addCriterion("invoice_type not between", value1, value2, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andCustTaxidIsNull() {
            addCriterion("cust_taxID is null");
            return (Criteria) this;
        }

        public Criteria andCustTaxidIsNotNull() {
            addCriterion("cust_taxID is not null");
            return (Criteria) this;
        }

        public Criteria andCustTaxidEqualTo(String value) {
            addCriterion("cust_taxID =", value, "custTaxid");
            return (Criteria) this;
        }

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

        public Criteria andCustTaxidGreaterThan(String value) {
            addCriterion("cust_taxID >", value, "custTaxid");
            return (Criteria) this;
        }

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

        public Criteria andCustTaxidLessThan(String value) {
            addCriterion("cust_taxID <", value, "custTaxid");
            return (Criteria) this;
        }

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

        public Criteria andCustTaxidLike(String value) {
            addCriterion("cust_taxID like", value, "custTaxid");
            return (Criteria) this;
        }

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

        public Criteria andCustTaxidIn(List<String> values) {
            addCriterion("cust_taxID in", values, "custTaxid");
            return (Criteria) this;
        }

        public Criteria andCustTaxidNotIn(List<String> values) {
            addCriterion("cust_taxID not in", values, "custTaxid");
            return (Criteria) this;
        }

        public Criteria andCustTaxidBetween(String value1, String value2) {
            addCriterion("cust_taxID between", value1, value2, "custTaxid");
            return (Criteria) this;
        }

        public Criteria andCustTaxidNotBetween(String value1, String value2) {
            addCriterion("cust_taxID not between", value1, value2, "custTaxid");
            return (Criteria) this;
        }

        public Criteria andCustBankNameIsNull() {
            addCriterion("cust_bank_name is null");
            return (Criteria) this;
        }

        public Criteria andCustBankNameIsNotNull() {
            addCriterion("cust_bank_name is not null");
            return (Criteria) this;
        }

        public Criteria andCustBankNameEqualTo(String value) {
            addCriterion("cust_bank_name =", value, "custBankName");
            return (Criteria) this;
        }

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

        public Criteria andCustBankNameGreaterThan(String value) {
            addCriterion("cust_bank_name >", value, "custBankName");
            return (Criteria) this;
        }

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

        public Criteria andCustBankNameLessThan(String value) {
            addCriterion("cust_bank_name <", value, "custBankName");
            return (Criteria) this;
        }

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

        public Criteria andCustBankNameLike(String value) {
            addCriterion("cust_bank_name like", value, "custBankName");
            return (Criteria) this;
        }

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

        public Criteria andCustBankNameIn(List<String> values) {
            addCriterion("cust_bank_name in", values, "custBankName");
            return (Criteria) this;
        }

        public Criteria andCustBankNameNotIn(List<String> values) {
            addCriterion("cust_bank_name not in", values, "custBankName");
            return (Criteria) this;
        }

        public Criteria andCustBankNameBetween(String value1, String value2) {
            addCriterion("cust_bank_name between", value1, value2, "custBankName");
            return (Criteria) this;
        }

        public Criteria andCustBankNameNotBetween(String value1, String value2) {
            addCriterion("cust_bank_name not between", value1, value2, "custBankName");
            return (Criteria) this;
        }

        public Criteria andCustCardNoIsNull() {
            addCriterion("cust_card_no is null");
            return (Criteria) this;
        }

        public Criteria andCustCardNoIsNotNull() {
            addCriterion("cust_card_no is not null");
            return (Criteria) this;
        }

        public Criteria andCustCardNoEqualTo(String value) {
            addCriterion("cust_card_no =", value, "custCardNo");
            return (Criteria) this;
        }

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

        public Criteria andCustCardNoGreaterThan(String value) {
            addCriterion("cust_card_no >", value, "custCardNo");
            return (Criteria) this;
        }

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

        public Criteria andCustCardNoLessThan(String value) {
            addCriterion("cust_card_no <", value, "custCardNo");
            return (Criteria) this;
        }

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

        public Criteria andCustCardNoLike(String value) {
            addCriterion("cust_card_no like", value, "custCardNo");
            return (Criteria) this;
        }

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

        public Criteria andCustCardNoIn(List<String> values) {
            addCriterion("cust_card_no in", values, "custCardNo");
            return (Criteria) this;
        }

        public Criteria andCustCardNoNotIn(List<String> values) {
            addCriterion("cust_card_no not in", values, "custCardNo");
            return (Criteria) this;
        }

        public Criteria andCustCardNoBetween(String value1, String value2) {
            addCriterion("cust_card_no between", value1, value2, "custCardNo");
            return (Criteria) this;
        }

        public Criteria andCustCardNoNotBetween(String value1, String value2) {
            addCriterion("cust_card_no not between", value1, value2, "custCardNo");
            return (Criteria) this;
        }

        public Criteria andCustAddressIsNull() {
            addCriterion("cust_address is null");
            return (Criteria) this;
        }

        public Criteria andCustAddressIsNotNull() {
            addCriterion("cust_address is not null");
            return (Criteria) this;
        }

        public Criteria andCustAddressEqualTo(String value) {
            addCriterion("cust_address =", value, "custAddress");
            return (Criteria) this;
        }

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

        public Criteria andCustAddressGreaterThan(String value) {
            addCriterion("cust_address >", value, "custAddress");
            return (Criteria) this;
        }

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

        public Criteria andCustAddressLessThan(String value) {
            addCriterion("cust_address <", value, "custAddress");
            return (Criteria) this;
        }

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

        public Criteria andCustAddressLike(String value) {
            addCriterion("cust_address like", value, "custAddress");
            return (Criteria) this;
        }

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

        public Criteria andCustAddressIn(List<String> values) {
            addCriterion("cust_address in", values, "custAddress");
            return (Criteria) this;
        }

        public Criteria andCustAddressNotIn(List<String> values) {
            addCriterion("cust_address not in", values, "custAddress");
            return (Criteria) this;
        }

        public Criteria andCustAddressBetween(String value1, String value2) {
            addCriterion("cust_address between", value1, value2, "custAddress");
            return (Criteria) this;
        }

        public Criteria andCustAddressNotBetween(String value1, String value2) {
            addCriterion("cust_address not between", value1, value2, "custAddress");
            return (Criteria) this;
        }

        public Criteria andCustPhoneIsNull() {
            addCriterion("cust_phone is null");
            return (Criteria) this;
        }

        public Criteria andCustPhoneIsNotNull() {
            addCriterion("cust_phone is not null");
            return (Criteria) this;
        }

        public Criteria andCustPhoneEqualTo(String value) {
            addCriterion("cust_phone =", value, "custPhone");
            return (Criteria) this;
        }

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

        public Criteria andCustPhoneGreaterThan(String value) {
            addCriterion("cust_phone >", value, "custPhone");
            return (Criteria) this;
        }

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

        public Criteria andCustPhoneLessThan(String value) {
            addCriterion("cust_phone <", value, "custPhone");
            return (Criteria) this;
        }

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

        public Criteria andCustPhoneLike(String value) {
            addCriterion("cust_phone like", value, "custPhone");
            return (Criteria) this;
        }

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

        public Criteria andCustPhoneIn(List<String> values) {
            addCriterion("cust_phone in", values, "custPhone");
            return (Criteria) this;
        }

        public Criteria andCustPhoneNotIn(List<String> values) {
            addCriterion("cust_phone not in", values, "custPhone");
            return (Criteria) this;
        }

        public Criteria andCustPhoneBetween(String value1, String value2) {
            addCriterion("cust_phone between", value1, value2, "custPhone");
            return (Criteria) this;
        }

        public Criteria andCustPhoneNotBetween(String value1, String value2) {
            addCriterion("cust_phone not between", value1, value2, "custPhone");
            return (Criteria) this;
        }

        public Criteria andCustEmailIsNull() {
            addCriterion("cust_email is null");
            return (Criteria) this;
        }

        public Criteria andCustEmailIsNotNull() {
            addCriterion("cust_email is not null");
            return (Criteria) this;
        }

        public Criteria andCustEmailEqualTo(String value) {
            addCriterion("cust_email =", value, "custEmail");
            return (Criteria) this;
        }

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

        public Criteria andCustEmailGreaterThan(String value) {
            addCriterion("cust_email >", value, "custEmail");
            return (Criteria) this;
        }

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

        public Criteria andCustEmailLessThan(String value) {
            addCriterion("cust_email <", value, "custEmail");
            return (Criteria) this;
        }

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

        public Criteria andCustEmailLike(String value) {
            addCriterion("cust_email like", value, "custEmail");
            return (Criteria) this;
        }

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

        public Criteria andCustEmailIn(List<String> values) {
            addCriterion("cust_email in", values, "custEmail");
            return (Criteria) this;
        }

        public Criteria andCustEmailNotIn(List<String> values) {
            addCriterion("cust_email not in", values, "custEmail");
            return (Criteria) this;
        }

        public Criteria andCustEmailBetween(String value1, String value2) {
            addCriterion("cust_email between", value1, value2, "custEmail");
            return (Criteria) this;
        }

        public Criteria andCustEmailNotBetween(String value1, String value2) {
            addCriterion("cust_email not between", value1, value2, "custEmail");
            return (Criteria) this;
        }

        public Criteria andSaleNameIsNull() {
            addCriterion("sale_name is null");
            return (Criteria) this;
        }

        public Criteria andSaleNameIsNotNull() {
            addCriterion("sale_name is not null");
            return (Criteria) this;
        }

        public Criteria andSaleNameEqualTo(String value) {
            addCriterion("sale_name =", value, "saleName");
            return (Criteria) this;
        }

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

        public Criteria andSaleNameGreaterThan(String value) {
            addCriterion("sale_name >", value, "saleName");
            return (Criteria) this;
        }

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

        public Criteria andSaleNameLessThan(String value) {
            addCriterion("sale_name <", value, "saleName");
            return (Criteria) this;
        }

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

        public Criteria andSaleNameLike(String value) {
            addCriterion("sale_name like", value, "saleName");
            return (Criteria) this;
        }

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

        public Criteria andSaleNameIn(List<String> values) {
            addCriterion("sale_name in", values, "saleName");
            return (Criteria) this;
        }

        public Criteria andSaleNameNotIn(List<String> values) {
            addCriterion("sale_name not in", values, "saleName");
            return (Criteria) this;
        }

        public Criteria andSaleNameBetween(String value1, String value2) {
            addCriterion("sale_name between", value1, value2, "saleName");
            return (Criteria) this;
        }

        public Criteria andSaleNameNotBetween(String value1, String value2) {
            addCriterion("sale_name not between", value1, value2, "saleName");
            return (Criteria) this;
        }

        public Criteria andSaleTaxidIsNull() {
            addCriterion("sale_taxID is null");
            return (Criteria) this;
        }

        public Criteria andSaleTaxidIsNotNull() {
            addCriterion("sale_taxID is not null");
            return (Criteria) this;
        }

        public Criteria andSaleTaxidEqualTo(String value) {
            addCriterion("sale_taxID =", value, "saleTaxid");
            return (Criteria) this;
        }

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

        public Criteria andSaleTaxidGreaterThan(String value) {
            addCriterion("sale_taxID >", value, "saleTaxid");
            return (Criteria) this;
        }

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

        public Criteria andSaleTaxidLessThan(String value) {
            addCriterion("sale_taxID <", value, "saleTaxid");
            return (Criteria) this;
        }

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

        public Criteria andSaleTaxidLike(String value) {
            addCriterion("sale_taxID like", value, "saleTaxid");
            return (Criteria) this;
        }

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

        public Criteria andSaleTaxidIn(List<String> values) {
            addCriterion("sale_taxID in", values, "saleTaxid");
            return (Criteria) this;
        }

        public Criteria andSaleTaxidNotIn(List<String> values) {
            addCriterion("sale_taxID not in", values, "saleTaxid");
            return (Criteria) this;
        }

        public Criteria andSaleTaxidBetween(String value1, String value2) {
            addCriterion("sale_taxID between", value1, value2, "saleTaxid");
            return (Criteria) this;
        }

        public Criteria andSaleTaxidNotBetween(String value1, String value2) {
            addCriterion("sale_taxID not between", value1, value2, "saleTaxid");
            return (Criteria) this;
        }

        public Criteria andSaleBankNameIsNull() {
            addCriterion("sale_bank_name is null");
            return (Criteria) this;
        }

        public Criteria andSaleBankNameIsNotNull() {
            addCriterion("sale_bank_name is not null");
            return (Criteria) this;
        }

        public Criteria andSaleBankNameEqualTo(String value) {
            addCriterion("sale_bank_name =", value, "saleBankName");
            return (Criteria) this;
        }

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

        public Criteria andSaleBankNameGreaterThan(String value) {
            addCriterion("sale_bank_name >", value, "saleBankName");
            return (Criteria) this;
        }

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

        public Criteria andSaleBankNameLessThan(String value) {
            addCriterion("sale_bank_name <", value, "saleBankName");
            return (Criteria) this;
        }

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

        public Criteria andSaleBankNameLike(String value) {
            addCriterion("sale_bank_name like", value, "saleBankName");
            return (Criteria) this;
        }

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

        public Criteria andSaleBankNameIn(List<String> values) {
            addCriterion("sale_bank_name in", values, "saleBankName");
            return (Criteria) this;
        }

        public Criteria andSaleBankNameNotIn(List<String> values) {
            addCriterion("sale_bank_name not in", values, "saleBankName");
            return (Criteria) this;
        }

        public Criteria andSaleBankNameBetween(String value1, String value2) {
            addCriterion("sale_bank_name between", value1, value2, "saleBankName");
            return (Criteria) this;
        }

        public Criteria andSaleBankNameNotBetween(String value1, String value2) {
            addCriterion("sale_bank_name not between", value1, value2, "saleBankName");
            return (Criteria) this;
        }

        public Criteria andSaleCardNoIsNull() {
            addCriterion("sale_card_no is null");
            return (Criteria) this;
        }

        public Criteria andSaleCardNoIsNotNull() {
            addCriterion("sale_card_no is not null");
            return (Criteria) this;
        }

        public Criteria andSaleCardNoEqualTo(String value) {
            addCriterion("sale_card_no =", value, "saleCardNo");
            return (Criteria) this;
        }

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

        public Criteria andSaleCardNoGreaterThan(String value) {
            addCriterion("sale_card_no >", value, "saleCardNo");
            return (Criteria) this;
        }

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

        public Criteria andSaleCardNoLessThan(String value) {
            addCriterion("sale_card_no <", value, "saleCardNo");
            return (Criteria) this;
        }

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

        public Criteria andSaleCardNoLike(String value) {
            addCriterion("sale_card_no like", value, "saleCardNo");
            return (Criteria) this;
        }

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

        public Criteria andSaleCardNoIn(List<String> values) {
            addCriterion("sale_card_no in", values, "saleCardNo");
            return (Criteria) this;
        }

        public Criteria andSaleCardNoNotIn(List<String> values) {
            addCriterion("sale_card_no not in", values, "saleCardNo");
            return (Criteria) this;
        }

        public Criteria andSaleCardNoBetween(String value1, String value2) {
            addCriterion("sale_card_no between", value1, value2, "saleCardNo");
            return (Criteria) this;
        }

        public Criteria andSaleCardNoNotBetween(String value1, String value2) {
            addCriterion("sale_card_no not between", value1, value2, "saleCardNo");
            return (Criteria) this;
        }

        public Criteria andSaleAddressIsNull() {
            addCriterion("sale_address is null");
            return (Criteria) this;
        }

        public Criteria andSaleAddressIsNotNull() {
            addCriterion("sale_address is not null");
            return (Criteria) this;
        }

        public Criteria andSaleAddressEqualTo(String value) {
            addCriterion("sale_address =", value, "saleAddress");
            return (Criteria) this;
        }

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

        public Criteria andSaleAddressGreaterThan(String value) {
            addCriterion("sale_address >", value, "saleAddress");
            return (Criteria) this;
        }

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

        public Criteria andSaleAddressLessThan(String value) {
            addCriterion("sale_address <", value, "saleAddress");
            return (Criteria) this;
        }

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

        public Criteria andSaleAddressLike(String value) {
            addCriterion("sale_address like", value, "saleAddress");
            return (Criteria) this;
        }

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

        public Criteria andSaleAddressIn(List<String> values) {
            addCriterion("sale_address in", values, "saleAddress");
            return (Criteria) this;
        }

        public Criteria andSaleAddressNotIn(List<String> values) {
            addCriterion("sale_address not in", values, "saleAddress");
            return (Criteria) this;
        }

        public Criteria andSaleAddressBetween(String value1, String value2) {
            addCriterion("sale_address between", value1, value2, "saleAddress");
            return (Criteria) this;
        }

        public Criteria andSaleAddressNotBetween(String value1, String value2) {
            addCriterion("sale_address not between", value1, value2, "saleAddress");
            return (Criteria) this;
        }

        public Criteria andDataStateIsNull() {
            addCriterion("data_state is null");
            return (Criteria) this;
        }

        public Criteria andDataStateIsNotNull() {
            addCriterion("data_state is not null");
            return (Criteria) this;
        }

        public Criteria andDataStateEqualTo(Integer value) {
            addCriterion("data_state =", value, "dataState");
            return (Criteria) this;
        }

        public Criteria andDataStateNotEqualTo(Integer value) {
            addCriterion("data_state <>", value, "dataState");
            return (Criteria) this;
        }

        public Criteria andDataStateGreaterThan(Integer value) {
            addCriterion("data_state >", value, "dataState");
            return (Criteria) this;
        }

        public Criteria andDataStateGreaterThanOrEqualTo(Integer value) {
            addCriterion("data_state >=", value, "dataState");
            return (Criteria) this;
        }

        public Criteria andDataStateLessThan(Integer value) {
            addCriterion("data_state <", value, "dataState");
            return (Criteria) this;
        }

        public Criteria andDataStateLessThanOrEqualTo(Integer value) {
            addCriterion("data_state <=", value, "dataState");
            return (Criteria) this;
        }

        public Criteria andDataStateIn(List<Integer> values) {
            addCriterion("data_state in", values, "dataState");
            return (Criteria) this;
        }

        public Criteria andDataStateNotIn(List<Integer> values) {
            addCriterion("data_state not in", values, "dataState");
            return (Criteria) this;
        }

        public Criteria andDataStateBetween(Integer value1, Integer value2) {
            addCriterion("data_state between", value1, value2, "dataState");
            return (Criteria) this;
        }

        public Criteria andDataStateNotBetween(Integer value1, Integer value2) {
            addCriterion("data_state not between", value1, value2, "dataState");
            return (Criteria) this;
        }

        public Criteria andCreateEmpidIsNull() {
            addCriterion("create_empid is null");
            return (Criteria) this;
        }

        public Criteria andCreateEmpidIsNotNull() {
            addCriterion("create_empid is not null");
            return (Criteria) this;
        }

        public Criteria andCreateEmpidEqualTo(String value) {
            addCriterion("create_empid =", value, "createEmpid");
            return (Criteria) this;
        }

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

        public Criteria andCreateEmpidGreaterThan(String value) {
            addCriterion("create_empid >", value, "createEmpid");
            return (Criteria) this;
        }

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

        public Criteria andCreateEmpidLessThan(String value) {
            addCriterion("create_empid <", value, "createEmpid");
            return (Criteria) this;
        }

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

        public Criteria andCreateEmpidLike(String value) {
            addCriterion("create_empid like", value, "createEmpid");
            return (Criteria) this;
        }

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

        public Criteria andCreateEmpidIn(List<String> values) {
            addCriterion("create_empid in", values, "createEmpid");
            return (Criteria) this;
        }

        public Criteria andCreateEmpidNotIn(List<String> values) {
            addCriterion("create_empid not in", values, "createEmpid");
            return (Criteria) this;
        }

        public Criteria andCreateEmpidBetween(String value1, String value2) {
            addCriterion("create_empid between", value1, value2, "createEmpid");
            return (Criteria) this;
        }

        public Criteria andCreateEmpidNotBetween(String value1, String value2) {
            addCriterion("create_empid not between", value1, value2, "createEmpid");
            return (Criteria) this;
        }

        public Criteria andCreateDateIsNull() {
            addCriterion("create_date is null");
            return (Criteria) this;
        }

        public Criteria andCreateDateIsNotNull() {
            addCriterion("create_date is not null");
            return (Criteria) this;
        }

        public Criteria andCreateDateEqualTo(Date value) {
            addCriterion("create_date =", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotEqualTo(Date value) {
            addCriterion("create_date <>", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateGreaterThan(Date value) {
            addCriterion("create_date >", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateGreaterThanOrEqualTo(Date value) {
            addCriterion("create_date >=", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateLessThan(Date value) {
            addCriterion("create_date <", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateLessThanOrEqualTo(Date value) {
            addCriterion("create_date <=", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateIn(List<Date> values) {
            addCriterion("create_date in", values, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotIn(List<Date> values) {
            addCriterion("create_date not in", values, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateBetween(Date value1, Date value2) {
            addCriterion("create_date between", value1, value2, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotBetween(Date value1, Date value2) {
            addCriterion("create_date not between", value1, value2, "createDate");
            return (Criteria) this;
        }

        public Criteria andModfiyEmpidIsNull() {
            addCriterion("modfiy_empid is null");
            return (Criteria) this;
        }

        public Criteria andModfiyEmpidIsNotNull() {
            addCriterion("modfiy_empid is not null");
            return (Criteria) this;
        }

        public Criteria andModfiyEmpidEqualTo(String value) {
            addCriterion("modfiy_empid =", value, "modfiyEmpid");
            return (Criteria) this;
        }

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

        public Criteria andModfiyEmpidGreaterThan(String value) {
            addCriterion("modfiy_empid >", value, "modfiyEmpid");
            return (Criteria) this;
        }

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

        public Criteria andModfiyEmpidLessThan(String value) {
            addCriterion("modfiy_empid <", value, "modfiyEmpid");
            return (Criteria) this;
        }

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

        public Criteria andModfiyEmpidLike(String value) {
            addCriterion("modfiy_empid like", value, "modfiyEmpid");
            return (Criteria) this;
        }

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

        public Criteria andModfiyEmpidIn(List<String> values) {
            addCriterion("modfiy_empid in", values, "modfiyEmpid");
            return (Criteria) this;
        }

        public Criteria andModfiyEmpidNotIn(List<String> values) {
            addCriterion("modfiy_empid not in", values, "modfiyEmpid");
            return (Criteria) this;
        }

        public Criteria andModfiyEmpidBetween(String value1, String value2) {
            addCriterion("modfiy_empid between", value1, value2, "modfiyEmpid");
            return (Criteria) this;
        }

        public Criteria andModfiyEmpidNotBetween(String value1, String value2) {
            addCriterion("modfiy_empid not between", value1, value2, "modfiyEmpid");
            return (Criteria) this;
        }

        public Criteria andModfiyDateIsNull() {
            addCriterion("modfiy_date is null");
            return (Criteria) this;
        }

        public Criteria andModfiyDateIsNotNull() {
            addCriterion("modfiy_date is not null");
            return (Criteria) this;
        }

        public Criteria andModfiyDateEqualTo(Date value) {
            addCriterion("modfiy_date =", value, "modfiyDate");
            return (Criteria) this;
        }

        public Criteria andModfiyDateNotEqualTo(Date value) {
            addCriterion("modfiy_date <>", value, "modfiyDate");
            return (Criteria) this;
        }

        public Criteria andModfiyDateGreaterThan(Date value) {
            addCriterion("modfiy_date >", value, "modfiyDate");
            return (Criteria) this;
        }

        public Criteria andModfiyDateGreaterThanOrEqualTo(Date value) {
            addCriterion("modfiy_date >=", value, "modfiyDate");
            return (Criteria) this;
        }

        public Criteria andModfiyDateLessThan(Date value) {
            addCriterion("modfiy_date <", value, "modfiyDate");
            return (Criteria) this;
        }

        public Criteria andModfiyDateLessThanOrEqualTo(Date value) {
            addCriterion("modfiy_date <=", value, "modfiyDate");
            return (Criteria) this;
        }

        public Criteria andModfiyDateIn(List<Date> values) {
            addCriterion("modfiy_date in", values, "modfiyDate");
            return (Criteria) this;
        }

        public Criteria andModfiyDateNotIn(List<Date> values) {
            addCriterion("modfiy_date not in", values, "modfiyDate");
            return (Criteria) this;
        }

        public Criteria andModfiyDateBetween(Date value1, Date value2) {
            addCriterion("modfiy_date between", value1, value2, "modfiyDate");
            return (Criteria) this;
        }

        public Criteria andModfiyDateNotBetween(Date value1, Date value2) {
            addCriterion("modfiy_date not between", value1, value2, "modfiyDate");
            return (Criteria) this;
        }

        public Criteria andApplyDateIsNull() {
            addCriterion("apply_date is null");
            return (Criteria) this;
        }

        public Criteria andApplyDateIsNotNull() {
            addCriterion("apply_date is not null");
            return (Criteria) this;
        }

        public Criteria andApplyDateEqualTo(Date value) {
            addCriterion("apply_date =", value, "applyDate");
            return (Criteria) this;
        }

        public Criteria andApplyDateNotEqualTo(Date value) {
            addCriterion("apply_date <>", value, "applyDate");
            return (Criteria) this;
        }

        public Criteria andApplyDateGreaterThan(Date value) {
            addCriterion("apply_date >", value, "applyDate");
            return (Criteria) this;
        }

        public Criteria andApplyDateGreaterThanOrEqualTo(Date value) {
            addCriterion("apply_date >=", value, "applyDate");
            return (Criteria) this;
        }

        public Criteria andApplyDateLessThan(Date value) {
            addCriterion("apply_date <", value, "applyDate");
            return (Criteria) this;
        }

        public Criteria andApplyDateLessThanOrEqualTo(Date value) {
            addCriterion("apply_date <=", value, "applyDate");
            return (Criteria) this;
        }

        public Criteria andApplyDateIn(List<Date> values) {
            addCriterion("apply_date in", values, "applyDate");
            return (Criteria) this;
        }

        public Criteria andApplyDateNotIn(List<Date> values) {
            addCriterion("apply_date not in", values, "applyDate");
            return (Criteria) this;
        }

        public Criteria andApplyDateBetween(Date value1, Date value2) {
            addCriterion("apply_date between", value1, value2, "applyDate");
            return (Criteria) this;
        }

        public Criteria andApplyDateNotBetween(Date value1, Date value2) {
            addCriterion("apply_date not between", value1, value2, "applyDate");
            return (Criteria) this;
        }

        public Criteria andTicketContentIsNull() {
            addCriterion("ticket_content is null");
            return (Criteria) this;
        }

        public Criteria andTicketContentIsNotNull() {
            addCriterion("ticket_content is not null");
            return (Criteria) this;
        }

        public Criteria andTicketContentEqualTo(String value) {
            addCriterion("ticket_content =", value, "ticketContent");
            return (Criteria) this;
        }

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

        public Criteria andTicketContentGreaterThan(String value) {
            addCriterion("ticket_content >", value, "ticketContent");
            return (Criteria) this;
        }

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

        public Criteria andTicketContentLessThan(String value) {
            addCriterion("ticket_content <", value, "ticketContent");
            return (Criteria) this;
        }

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

        public Criteria andTicketContentLike(String value) {
            addCriterion("ticket_content like", value, "ticketContent");
            return (Criteria) this;
        }

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

        public Criteria andTicketContentIn(List<String> values) {
            addCriterion("ticket_content in", values, "ticketContent");
            return (Criteria) this;
        }

        public Criteria andTicketContentNotIn(List<String> values) {
            addCriterion("ticket_content not in", values, "ticketContent");
            return (Criteria) this;
        }

        public Criteria andTicketContentBetween(String value1, String value2) {
            addCriterion("ticket_content between", value1, value2, "ticketContent");
            return (Criteria) this;
        }

        public Criteria andTicketContentNotBetween(String value1, String value2) {
            addCriterion("ticket_content not between", value1, value2, "ticketContent");
            return (Criteria) this;
        }

        public Criteria andRecipientsIsNull() {
            addCriterion("recipients is null");
            return (Criteria) this;
        }

        public Criteria andRecipientsIsNotNull() {
            addCriterion("recipients is not null");
            return (Criteria) this;
        }

        public Criteria andRecipientsEqualTo(String value) {
            addCriterion("recipients =", value, "recipients");
            return (Criteria) this;
        }

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

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

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

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

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

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

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

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

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

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

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

        public Criteria andRecipientsAddressIsNull() {
            addCriterion("recipients_address is null");
            return (Criteria) this;
        }

        public Criteria andRecipientsAddressIsNotNull() {
            addCriterion("recipients_address is not null");
            return (Criteria) this;
        }

        public Criteria andRecipientsAddressEqualTo(String value) {
            addCriterion("recipients_address =", value, "recipientsAddress");
            return (Criteria) this;
        }

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

        public Criteria andRecipientsAddressGreaterThan(String value) {
            addCriterion("recipients_address >", value, "recipientsAddress");
            return (Criteria) this;
        }

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

        public Criteria andRecipientsAddressLessThan(String value) {
            addCriterion("recipients_address <", value, "recipientsAddress");
            return (Criteria) this;
        }

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

        public Criteria andRecipientsAddressLike(String value) {
            addCriterion("recipients_address like", value, "recipientsAddress");
            return (Criteria) this;
        }

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

        public Criteria andRecipientsAddressIn(List<String> values) {
            addCriterion("recipients_address in", values, "recipientsAddress");
            return (Criteria) this;
        }

        public Criteria andRecipientsAddressNotIn(List<String> values) {
            addCriterion("recipients_address not in", values, "recipientsAddress");
            return (Criteria) this;
        }

        public Criteria andRecipientsAddressBetween(String value1, String value2) {
            addCriterion("recipients_address between", value1, value2, "recipientsAddress");
            return (Criteria) this;
        }

        public Criteria andRecipientsAddressNotBetween(String value1, String value2) {
            addCriterion("recipients_address not between", value1, value2, "recipientsAddress");
            return (Criteria) this;
        }

        public Criteria andFetchTicketWayIsNull() {
            addCriterion("fetch_ticket_way is null");
            return (Criteria) this;
        }

        public Criteria andFetchTicketWayIsNotNull() {
            addCriterion("fetch_ticket_way is not null");
            return (Criteria) this;
        }

        public Criteria andFetchTicketWayEqualTo(Integer value) {
            addCriterion("fetch_ticket_way =", value, "fetchTicketWay");
            return (Criteria) this;
        }

        public Criteria andFetchTicketWayNotEqualTo(Integer value) {
            addCriterion("fetch_ticket_way <>", value, "fetchTicketWay");
            return (Criteria) this;
        }

        public Criteria andFetchTicketWayGreaterThan(Integer value) {
            addCriterion("fetch_ticket_way >", value, "fetchTicketWay");
            return (Criteria) this;
        }

        public Criteria andFetchTicketWayGreaterThanOrEqualTo(Integer value) {
            addCriterion("fetch_ticket_way >=", value, "fetchTicketWay");
            return (Criteria) this;
        }

        public Criteria andFetchTicketWayLessThan(Integer value) {
            addCriterion("fetch_ticket_way <", value, "fetchTicketWay");
            return (Criteria) this;
        }

        public Criteria andFetchTicketWayLessThanOrEqualTo(Integer value) {
            addCriterion("fetch_ticket_way <=", value, "fetchTicketWay");
            return (Criteria) this;
        }

        public Criteria andFetchTicketWayIn(List<Integer> values) {
            addCriterion("fetch_ticket_way in", values, "fetchTicketWay");
            return (Criteria) this;
        }

        public Criteria andFetchTicketWayNotIn(List<Integer> values) {
            addCriterion("fetch_ticket_way not in", values, "fetchTicketWay");
            return (Criteria) this;
        }

        public Criteria andFetchTicketWayBetween(Integer value1, Integer value2) {
            addCriterion("fetch_ticket_way between", value1, value2, "fetchTicketWay");
            return (Criteria) this;
        }

        public Criteria andFetchTicketWayNotBetween(Integer value1, Integer value2) {
            addCriterion("fetch_ticket_way not between", value1, value2, "fetchTicketWay");
            return (Criteria) this;
        }

        public Criteria andRecipientsPhoneIsNull() {
            addCriterion("recipients_phone is null");
            return (Criteria) this;
        }

        public Criteria andRecipientsPhoneIsNotNull() {
            addCriterion("recipients_phone is not null");
            return (Criteria) this;
        }

        public Criteria andRecipientsPhoneEqualTo(String value) {
            addCriterion("recipients_phone =", value, "recipientsPhone");
            return (Criteria) this;
        }

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

        public Criteria andRecipientsPhoneGreaterThan(String value) {
            addCriterion("recipients_phone >", value, "recipientsPhone");
            return (Criteria) this;
        }

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

        public Criteria andRecipientsPhoneLessThan(String value) {
            addCriterion("recipients_phone <", value, "recipientsPhone");
            return (Criteria) this;
        }

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

        public Criteria andRecipientsPhoneLike(String value) {
            addCriterion("recipients_phone like", value, "recipientsPhone");
            return (Criteria) this;
        }

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

        public Criteria andRecipientsPhoneIn(List<String> values) {
            addCriterion("recipients_phone in", values, "recipientsPhone");
            return (Criteria) this;
        }

        public Criteria andRecipientsPhoneNotIn(List<String> values) {
            addCriterion("recipients_phone not in", values, "recipientsPhone");
            return (Criteria) this;
        }

        public Criteria andRecipientsPhoneBetween(String value1, String value2) {
            addCriterion("recipients_phone between", value1, value2, "recipientsPhone");
            return (Criteria) this;
        }

        public Criteria andRecipientsPhoneNotBetween(String value1, String value2) {
            addCriterion("recipients_phone not between", value1, value2, "recipientsPhone");
            return (Criteria) this;
        }

        public Criteria andInvoiceKindIsNull() {
            addCriterion("invoice_kind is null");
            return (Criteria) this;
        }

        public Criteria andInvoiceKindIsNotNull() {
            addCriterion("invoice_kind is not null");
            return (Criteria) this;
        }

        public Criteria andInvoiceKindEqualTo(String value) {
            addCriterion("invoice_kind =", value, "invoiceKind");
            return (Criteria) this;
        }

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

        public Criteria andInvoiceKindGreaterThan(String value) {
            addCriterion("invoice_kind >", value, "invoiceKind");
            return (Criteria) this;
        }

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

        public Criteria andInvoiceKindLessThan(String value) {
            addCriterion("invoice_kind <", value, "invoiceKind");
            return (Criteria) this;
        }

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

        public Criteria andInvoiceKindLike(String value) {
            addCriterion("invoice_kind like", value, "invoiceKind");
            return (Criteria) this;
        }

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

        public Criteria andInvoiceKindIn(List<String> values) {
            addCriterion("invoice_kind in", values, "invoiceKind");
            return (Criteria) this;
        }

        public Criteria andInvoiceKindNotIn(List<String> values) {
            addCriterion("invoice_kind not in", values, "invoiceKind");
            return (Criteria) this;
        }

        public Criteria andInvoiceKindBetween(String value1, String value2) {
            addCriterion("invoice_kind between", value1, value2, "invoiceKind");
            return (Criteria) this;
        }

        public Criteria andInvoiceKindNotBetween(String value1, String value2) {
            addCriterion("invoice_kind not between", value1, value2, "invoiceKind");
            return (Criteria) this;
        }

        public Criteria andPlNoIsNull() {
            addCriterion("pl_no is null");
            return (Criteria) this;
        }

        public Criteria andPlNoIsNotNull() {
            addCriterion("pl_no is not null");
            return (Criteria) this;
        }

        public Criteria andPlNoEqualTo(String value) {
            addCriterion("pl_no =", value, "plNo");
            return (Criteria) this;
        }

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

        public Criteria andPlNoGreaterThan(String value) {
            addCriterion("pl_no >", value, "plNo");
            return (Criteria) this;
        }

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

        public Criteria andPlNoLessThan(String value) {
            addCriterion("pl_no <", value, "plNo");
            return (Criteria) this;
        }

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

        public Criteria andPlNoLike(String value) {
            addCriterion("pl_no like", value, "plNo");
            return (Criteria) this;
        }

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

        public Criteria andPlNoIn(List<String> values) {
            addCriterion("pl_no in", values, "plNo");
            return (Criteria) this;
        }

        public Criteria andPlNoNotIn(List<String> values) {
            addCriterion("pl_no not in", values, "plNo");
            return (Criteria) this;
        }

        public Criteria andPlNoBetween(String value1, String value2) {
            addCriterion("pl_no between", value1, value2, "plNo");
            return (Criteria) this;
        }

        public Criteria andPlNoNotBetween(String value1, String value2) {
            addCriterion("pl_no not between", value1, value2, "plNo");
            return (Criteria) this;
        }

        public Criteria andCarNumbersIsNull() {
            addCriterion("car_numbers is null");
            return (Criteria) this;
        }

        public Criteria andCarNumbersIsNotNull() {
            addCriterion("car_numbers is not null");
            return (Criteria) this;
        }

        public Criteria andCarNumbersEqualTo(String value) {
            addCriterion("car_numbers =", value, "carNumbers");
            return (Criteria) this;
        }

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

        public Criteria andCarNumbersGreaterThan(String value) {
            addCriterion("car_numbers >", value, "carNumbers");
            return (Criteria) this;
        }

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

        public Criteria andCarNumbersLessThan(String value) {
            addCriterion("car_numbers <", value, "carNumbers");
            return (Criteria) this;
        }

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

        public Criteria andCarNumbersLike(String value) {
            addCriterion("car_numbers like", value, "carNumbers");
            return (Criteria) this;
        }

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

        public Criteria andCarNumbersIn(List<String> values) {
            addCriterion("car_numbers in", values, "carNumbers");
            return (Criteria) this;
        }

        public Criteria andCarNumbersNotIn(List<String> values) {
            addCriterion("car_numbers not in", values, "carNumbers");
            return (Criteria) this;
        }

        public Criteria andCarNumbersBetween(String value1, String value2) {
            addCriterion("car_numbers between", value1, value2, "carNumbers");
            return (Criteria) this;
        }

        public Criteria andCarNumbersNotBetween(String value1, String value2) {
            addCriterion("car_numbers not between", value1, value2, "carNumbers");
            return (Criteria) this;
        }

        public Criteria andInvoiceBigTypeIsNull() {
            addCriterion("invoice_big_type is null");
            return (Criteria) this;
        }

        public Criteria andInvoiceBigTypeIsNotNull() {
            addCriterion("invoice_big_type is not null");
            return (Criteria) this;
        }

        public Criteria andInvoiceBigTypeEqualTo(Integer value) {
            addCriterion("invoice_big_type =", value, "invoiceBigType");
            return (Criteria) this;
        }

        public Criteria andInvoiceBigTypeNotEqualTo(Integer value) {
            addCriterion("invoice_big_type <>", value, "invoiceBigType");
            return (Criteria) this;
        }

        public Criteria andInvoiceBigTypeGreaterThan(Integer value) {
            addCriterion("invoice_big_type >", value, "invoiceBigType");
            return (Criteria) this;
        }

        public Criteria andInvoiceBigTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("invoice_big_type >=", value, "invoiceBigType");
            return (Criteria) this;
        }

        public Criteria andInvoiceBigTypeLessThan(Integer value) {
            addCriterion("invoice_big_type <", value, "invoiceBigType");
            return (Criteria) this;
        }

        public Criteria andInvoiceBigTypeLessThanOrEqualTo(Integer value) {
            addCriterion("invoice_big_type <=", value, "invoiceBigType");
            return (Criteria) this;
        }

        public Criteria andInvoiceBigTypeIn(List<Integer> values) {
            addCriterion("invoice_big_type in", values, "invoiceBigType");
            return (Criteria) this;
        }

        public Criteria andInvoiceBigTypeNotIn(List<Integer> values) {
            addCriterion("invoice_big_type not in", values, "invoiceBigType");
            return (Criteria) this;
        }

        public Criteria andInvoiceBigTypeBetween(Integer value1, Integer value2) {
            addCriterion("invoice_big_type between", value1, value2, "invoiceBigType");
            return (Criteria) this;
        }

        public Criteria andInvoiceBigTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("invoice_big_type not between", value1, value2, "invoiceBigType");
            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 andOrgIdIsNull() {
            addCriterion("org_id is null");
            return (Criteria) this;
        }

        public Criteria andOrgIdIsNotNull() {
            addCriterion("org_id is not null");
            return (Criteria) this;
        }

        public Criteria andOrgIdEqualTo(Long value) {
            addCriterion("org_id =", value, "orgId");
            return (Criteria) this;
        }

        public Criteria andOrgIdNotEqualTo(Long value) {
            addCriterion("org_id <>", value, "orgId");
            return (Criteria) this;
        }

        public Criteria andOrgIdGreaterThan(Long value) {
            addCriterion("org_id >", value, "orgId");
            return (Criteria) this;
        }

        public Criteria andOrgIdGreaterThanOrEqualTo(Long value) {
            addCriterion("org_id >=", value, "orgId");
            return (Criteria) this;
        }

        public Criteria andOrgIdLessThan(Long value) {
            addCriterion("org_id <", value, "orgId");
            return (Criteria) this;
        }

        public Criteria andOrgIdLessThanOrEqualTo(Long value) {
            addCriterion("org_id <=", value, "orgId");
            return (Criteria) this;
        }

        public Criteria andOrgIdIn(List<Long> values) {
            addCriterion("org_id in", values, "orgId");
            return (Criteria) this;
        }

        public Criteria andOrgIdNotIn(List<Long> values) {
            addCriterion("org_id not in", values, "orgId");
            return (Criteria) this;
        }

        public Criteria andOrgIdBetween(Long value1, Long value2) {
            addCriterion("org_id between", value1, value2, "orgId");
            return (Criteria) this;
        }

        public Criteria andOrgIdNotBetween(Long value1, Long value2) {
            addCriterion("org_id not between", value1, value2, "orgId");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}