package pwc.taxtech.atms.entity;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table cit_salary_advance
     *
     * @mbg.generated
     */
    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

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

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

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

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

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

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

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

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

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

        public Criteria andIdEqualTo(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 andOrganizationIdIsNull() {
            addCriterion("organization_id is null");
            return (Criteria) this;
        }

        public Criteria andOrganizationIdIsNotNull() {
            addCriterion("organization_id is not null");
            return (Criteria) this;
        }

        public Criteria andOrganizationIdEqualTo(String value) {
            addCriterion("organization_id =", value, "organizationId");
            return (Criteria) this;
        }

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

        public Criteria andOrganizationIdGreaterThan(String value) {
            addCriterion("organization_id >", value, "organizationId");
            return (Criteria) this;
        }

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

        public Criteria andOrganizationIdLessThan(String value) {
            addCriterion("organization_id <", value, "organizationId");
            return (Criteria) this;
        }

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

        public Criteria andOrganizationIdLike(String value) {
            addCriterion("organization_id like", value, "organizationId");
            return (Criteria) this;
        }

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

        public Criteria andOrganizationIdIn(List<String> values) {
            addCriterion("organization_id in", values, "organizationId");
            return (Criteria) this;
        }

        public Criteria andOrganizationIdNotIn(List<String> values) {
            addCriterion("organization_id not in", values, "organizationId");
            return (Criteria) this;
        }

        public Criteria andOrganizationIdBetween(String value1, String value2) {
            addCriterion("organization_id between", value1, value2, "organizationId");
            return (Criteria) this;
        }

        public Criteria andOrganizationIdNotBetween(String value1, String value2) {
            addCriterion("organization_id not between", value1, value2, "organizationId");
            return (Criteria) this;
        }

        public Criteria andProjectIdIsNull() {
            addCriterion("project_id is null");
            return (Criteria) this;
        }

        public Criteria andProjectIdIsNotNull() {
            addCriterion("project_id is not null");
            return (Criteria) this;
        }

        public Criteria andProjectIdEqualTo(String value) {
            addCriterion("project_id =", value, "projectId");
            return (Criteria) this;
        }

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

        public Criteria andProjectIdGreaterThan(String value) {
            addCriterion("project_id >", value, "projectId");
            return (Criteria) this;
        }

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

        public Criteria andProjectIdLessThan(String value) {
            addCriterion("project_id <", value, "projectId");
            return (Criteria) this;
        }

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

        public Criteria andProjectIdLike(String value) {
            addCriterion("project_id like", value, "projectId");
            return (Criteria) this;
        }

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

        public Criteria andProjectIdIn(List<String> values) {
            addCriterion("project_id in", values, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdNotIn(List<String> values) {
            addCriterion("project_id not in", values, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdBetween(String value1, String value2) {
            addCriterion("project_id between", value1, value2, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdNotBetween(String value1, String value2) {
            addCriterion("project_id not between", value1, value2, "projectId");
            return (Criteria) this;
        }

        public Criteria andPeriodIsNull() {
            addCriterion("period is null");
            return (Criteria) this;
        }

        public Criteria andPeriodIsNotNull() {
            addCriterion("period is not null");
            return (Criteria) this;
        }

        public Criteria andPeriodEqualTo(Integer value) {
            addCriterion("period =", value, "period");
            return (Criteria) this;
        }

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

        public Criteria andPeriodGreaterThan(Integer value) {
            addCriterion("period >", value, "period");
            return (Criteria) this;
        }

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

        public Criteria andPeriodLessThan(Integer value) {
            addCriterion("period <", value, "period");
            return (Criteria) this;
        }

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

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

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

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

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

        public Criteria andSourceIsNull() {
            addCriterion("source is null");
            return (Criteria) this;
        }

        public Criteria andSourceIsNotNull() {
            addCriterion("source is not null");
            return (Criteria) this;
        }

        public Criteria andSourceEqualTo(String value) {
            addCriterion("source =", value, "source");
            return (Criteria) this;
        }

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

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

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

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

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

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

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

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

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

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

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

        public Criteria andPoNoIsNull() {
            addCriterion("po_no is null");
            return (Criteria) this;
        }

        public Criteria andPoNoIsNotNull() {
            addCriterion("po_no is not null");
            return (Criteria) this;
        }

        public Criteria andPoNoEqualTo(String value) {
            addCriterion("po_no =", value, "poNo");
            return (Criteria) this;
        }

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

        public Criteria andPoNoGreaterThan(String value) {
            addCriterion("po_no >", value, "poNo");
            return (Criteria) this;
        }

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

        public Criteria andPoNoLessThan(String value) {
            addCriterion("po_no <", value, "poNo");
            return (Criteria) this;
        }

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

        public Criteria andPoNoLike(String value) {
            addCriterion("po_no like", value, "poNo");
            return (Criteria) this;
        }

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

        public Criteria andPoNoIn(List<String> values) {
            addCriterion("po_no in", values, "poNo");
            return (Criteria) this;
        }

        public Criteria andPoNoNotIn(List<String> values) {
            addCriterion("po_no not in", values, "poNo");
            return (Criteria) this;
        }

        public Criteria andPoNoBetween(String value1, String value2) {
            addCriterion("po_no between", value1, value2, "poNo");
            return (Criteria) this;
        }

        public Criteria andPoNoNotBetween(String value1, String value2) {
            addCriterion("po_no not between", value1, value2, "poNo");
            return (Criteria) this;
        }

        public Criteria andPoRowIsNull() {
            addCriterion("po_row is null");
            return (Criteria) this;
        }

        public Criteria andPoRowIsNotNull() {
            addCriterion("po_row is not null");
            return (Criteria) this;
        }

        public Criteria andPoRowEqualTo(String value) {
            addCriterion("po_row =", value, "poRow");
            return (Criteria) this;
        }

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

        public Criteria andPoRowGreaterThan(String value) {
            addCriterion("po_row >", value, "poRow");
            return (Criteria) this;
        }

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

        public Criteria andPoRowLessThan(String value) {
            addCriterion("po_row <", value, "poRow");
            return (Criteria) this;
        }

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

        public Criteria andPoRowLike(String value) {
            addCriterion("po_row like", value, "poRow");
            return (Criteria) this;
        }

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

        public Criteria andPoRowIn(List<String> values) {
            addCriterion("po_row in", values, "poRow");
            return (Criteria) this;
        }

        public Criteria andPoRowNotIn(List<String> values) {
            addCriterion("po_row not in", values, "poRow");
            return (Criteria) this;
        }

        public Criteria andPoRowBetween(String value1, String value2) {
            addCriterion("po_row between", value1, value2, "poRow");
            return (Criteria) this;
        }

        public Criteria andPoRowNotBetween(String value1, String value2) {
            addCriterion("po_row not between", value1, value2, "poRow");
            return (Criteria) this;
        }

        public Criteria andPoCreateTimeIsNull() {
            addCriterion("po_create_time is null");
            return (Criteria) this;
        }

        public Criteria andPoCreateTimeIsNotNull() {
            addCriterion("po_create_time is not null");
            return (Criteria) this;
        }

        public Criteria andPoCreateTimeEqualTo(Date value) {
            addCriterion("po_create_time =", value, "poCreateTime");
            return (Criteria) this;
        }

        public Criteria andPoCreateTimeNotEqualTo(Date value) {
            addCriterion("po_create_time <>", value, "poCreateTime");
            return (Criteria) this;
        }

        public Criteria andPoCreateTimeGreaterThan(Date value) {
            addCriterion("po_create_time >", value, "poCreateTime");
            return (Criteria) this;
        }

        public Criteria andPoCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("po_create_time >=", value, "poCreateTime");
            return (Criteria) this;
        }

        public Criteria andPoCreateTimeLessThan(Date value) {
            addCriterion("po_create_time <", value, "poCreateTime");
            return (Criteria) this;
        }

        public Criteria andPoCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("po_create_time <=", value, "poCreateTime");
            return (Criteria) this;
        }

        public Criteria andPoCreateTimeIn(List<Date> values) {
            addCriterion("po_create_time in", values, "poCreateTime");
            return (Criteria) this;
        }

        public Criteria andPoCreateTimeNotIn(List<Date> values) {
            addCriterion("po_create_time not in", values, "poCreateTime");
            return (Criteria) this;
        }

        public Criteria andPoCreateTimeBetween(Date value1, Date value2) {
            addCriterion("po_create_time between", value1, value2, "poCreateTime");
            return (Criteria) this;
        }

        public Criteria andPoCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("po_create_time not between", value1, value2, "poCreateTime");
            return (Criteria) this;
        }

        public Criteria andLadingBillPersonIsNull() {
            addCriterion("lading_bill_person is null");
            return (Criteria) this;
        }

        public Criteria andLadingBillPersonIsNotNull() {
            addCriterion("lading_bill_person is not null");
            return (Criteria) this;
        }

        public Criteria andLadingBillPersonEqualTo(String value) {
            addCriterion("lading_bill_person =", value, "ladingBillPerson");
            return (Criteria) this;
        }

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

        public Criteria andLadingBillPersonGreaterThan(String value) {
            addCriterion("lading_bill_person >", value, "ladingBillPerson");
            return (Criteria) this;
        }

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

        public Criteria andLadingBillPersonLessThan(String value) {
            addCriterion("lading_bill_person <", value, "ladingBillPerson");
            return (Criteria) this;
        }

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

        public Criteria andLadingBillPersonLike(String value) {
            addCriterion("lading_bill_person like", value, "ladingBillPerson");
            return (Criteria) this;
        }

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

        public Criteria andLadingBillPersonIn(List<String> values) {
            addCriterion("lading_bill_person in", values, "ladingBillPerson");
            return (Criteria) this;
        }

        public Criteria andLadingBillPersonNotIn(List<String> values) {
            addCriterion("lading_bill_person not in", values, "ladingBillPerson");
            return (Criteria) this;
        }

        public Criteria andLadingBillPersonBetween(String value1, String value2) {
            addCriterion("lading_bill_person between", value1, value2, "ladingBillPerson");
            return (Criteria) this;
        }

        public Criteria andLadingBillPersonNotBetween(String value1, String value2) {
            addCriterion("lading_bill_person not between", value1, value2, "ladingBillPerson");
            return (Criteria) this;
        }

        public Criteria andPurchasePersonIsNull() {
            addCriterion("purchase_person is null");
            return (Criteria) this;
        }

        public Criteria andPurchasePersonIsNotNull() {
            addCriterion("purchase_person is not null");
            return (Criteria) this;
        }

        public Criteria andPurchasePersonEqualTo(String value) {
            addCriterion("purchase_person =", value, "purchasePerson");
            return (Criteria) this;
        }

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

        public Criteria andPurchasePersonGreaterThan(String value) {
            addCriterion("purchase_person >", value, "purchasePerson");
            return (Criteria) this;
        }

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

        public Criteria andPurchasePersonLessThan(String value) {
            addCriterion("purchase_person <", value, "purchasePerson");
            return (Criteria) this;
        }

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

        public Criteria andPurchasePersonLike(String value) {
            addCriterion("purchase_person like", value, "purchasePerson");
            return (Criteria) this;
        }

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

        public Criteria andPurchasePersonIn(List<String> values) {
            addCriterion("purchase_person in", values, "purchasePerson");
            return (Criteria) this;
        }

        public Criteria andPurchasePersonNotIn(List<String> values) {
            addCriterion("purchase_person not in", values, "purchasePerson");
            return (Criteria) this;
        }

        public Criteria andPurchasePersonBetween(String value1, String value2) {
            addCriterion("purchase_person between", value1, value2, "purchasePerson");
            return (Criteria) this;
        }

        public Criteria andPurchasePersonNotBetween(String value1, String value2) {
            addCriterion("purchase_person not between", value1, value2, "purchasePerson");
            return (Criteria) this;
        }

        public Criteria andPoSubjectCodeIsNull() {
            addCriterion("po_subject_code is null");
            return (Criteria) this;
        }

        public Criteria andPoSubjectCodeIsNotNull() {
            addCriterion("po_subject_code is not null");
            return (Criteria) this;
        }

        public Criteria andPoSubjectCodeEqualTo(String value) {
            addCriterion("po_subject_code =", value, "poSubjectCode");
            return (Criteria) this;
        }

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

        public Criteria andPoSubjectCodeGreaterThan(String value) {
            addCriterion("po_subject_code >", value, "poSubjectCode");
            return (Criteria) this;
        }

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

        public Criteria andPoSubjectCodeLessThan(String value) {
            addCriterion("po_subject_code <", value, "poSubjectCode");
            return (Criteria) this;
        }

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

        public Criteria andPoSubjectCodeLike(String value) {
            addCriterion("po_subject_code like", value, "poSubjectCode");
            return (Criteria) this;
        }

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

        public Criteria andPoSubjectCodeIn(List<String> values) {
            addCriterion("po_subject_code in", values, "poSubjectCode");
            return (Criteria) this;
        }

        public Criteria andPoSubjectCodeNotIn(List<String> values) {
            addCriterion("po_subject_code not in", values, "poSubjectCode");
            return (Criteria) this;
        }

        public Criteria andPoSubjectCodeBetween(String value1, String value2) {
            addCriterion("po_subject_code between", value1, value2, "poSubjectCode");
            return (Criteria) this;
        }

        public Criteria andPoSubjectCodeNotBetween(String value1, String value2) {
            addCriterion("po_subject_code not between", value1, value2, "poSubjectCode");
            return (Criteria) this;
        }

        public Criteria andPoSubjectNameIsNull() {
            addCriterion("po_subject_name is null");
            return (Criteria) this;
        }

        public Criteria andPoSubjectNameIsNotNull() {
            addCriterion("po_subject_name is not null");
            return (Criteria) this;
        }

        public Criteria andPoSubjectNameEqualTo(String value) {
            addCriterion("po_subject_name =", value, "poSubjectName");
            return (Criteria) this;
        }

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

        public Criteria andPoSubjectNameGreaterThan(String value) {
            addCriterion("po_subject_name >", value, "poSubjectName");
            return (Criteria) this;
        }

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

        public Criteria andPoSubjectNameLessThan(String value) {
            addCriterion("po_subject_name <", value, "poSubjectName");
            return (Criteria) this;
        }

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

        public Criteria andPoSubjectNameLike(String value) {
            addCriterion("po_subject_name like", value, "poSubjectName");
            return (Criteria) this;
        }

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

        public Criteria andPoSubjectNameIn(List<String> values) {
            addCriterion("po_subject_name in", values, "poSubjectName");
            return (Criteria) this;
        }

        public Criteria andPoSubjectNameNotIn(List<String> values) {
            addCriterion("po_subject_name not in", values, "poSubjectName");
            return (Criteria) this;
        }

        public Criteria andPoSubjectNameBetween(String value1, String value2) {
            addCriterion("po_subject_name between", value1, value2, "poSubjectName");
            return (Criteria) this;
        }

        public Criteria andPoSubjectNameNotBetween(String value1, String value2) {
            addCriterion("po_subject_name not between", value1, value2, "poSubjectName");
            return (Criteria) this;
        }

        public Criteria andCostCenterCodeIsNull() {
            addCriterion("cost_center_code is null");
            return (Criteria) this;
        }

        public Criteria andCostCenterCodeIsNotNull() {
            addCriterion("cost_center_code is not null");
            return (Criteria) this;
        }

        public Criteria andCostCenterCodeEqualTo(String value) {
            addCriterion("cost_center_code =", value, "costCenterCode");
            return (Criteria) this;
        }

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

        public Criteria andCostCenterCodeGreaterThan(String value) {
            addCriterion("cost_center_code >", value, "costCenterCode");
            return (Criteria) this;
        }

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

        public Criteria andCostCenterCodeLessThan(String value) {
            addCriterion("cost_center_code <", value, "costCenterCode");
            return (Criteria) this;
        }

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

        public Criteria andCostCenterCodeLike(String value) {
            addCriterion("cost_center_code like", value, "costCenterCode");
            return (Criteria) this;
        }

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

        public Criteria andCostCenterCodeIn(List<String> values) {
            addCriterion("cost_center_code in", values, "costCenterCode");
            return (Criteria) this;
        }

        public Criteria andCostCenterCodeNotIn(List<String> values) {
            addCriterion("cost_center_code not in", values, "costCenterCode");
            return (Criteria) this;
        }

        public Criteria andCostCenterCodeBetween(String value1, String value2) {
            addCriterion("cost_center_code between", value1, value2, "costCenterCode");
            return (Criteria) this;
        }

        public Criteria andCostCenterCodeNotBetween(String value1, String value2) {
            addCriterion("cost_center_code not between", value1, value2, "costCenterCode");
            return (Criteria) this;
        }

        public Criteria andCostCenterIsNull() {
            addCriterion("cost_center is null");
            return (Criteria) this;
        }

        public Criteria andCostCenterIsNotNull() {
            addCriterion("cost_center is not null");
            return (Criteria) this;
        }

        public Criteria andCostCenterEqualTo(String value) {
            addCriterion("cost_center =", value, "costCenter");
            return (Criteria) this;
        }

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

        public Criteria andCostCenterGreaterThan(String value) {
            addCriterion("cost_center >", value, "costCenter");
            return (Criteria) this;
        }

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

        public Criteria andCostCenterLessThan(String value) {
            addCriterion("cost_center <", value, "costCenter");
            return (Criteria) this;
        }

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

        public Criteria andCostCenterLike(String value) {
            addCriterion("cost_center like", value, "costCenter");
            return (Criteria) this;
        }

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

        public Criteria andCostCenterIn(List<String> values) {
            addCriterion("cost_center in", values, "costCenter");
            return (Criteria) this;
        }

        public Criteria andCostCenterNotIn(List<String> values) {
            addCriterion("cost_center not in", values, "costCenter");
            return (Criteria) this;
        }

        public Criteria andCostCenterBetween(String value1, String value2) {
            addCriterion("cost_center between", value1, value2, "costCenter");
            return (Criteria) this;
        }

        public Criteria andCostCenterNotBetween(String value1, String value2) {
            addCriterion("cost_center not between", value1, value2, "costCenter");
            return (Criteria) this;
        }

        public Criteria andSupplierIsNull() {
            addCriterion("supplier is null");
            return (Criteria) this;
        }

        public Criteria andSupplierIsNotNull() {
            addCriterion("supplier is not null");
            return (Criteria) this;
        }

        public Criteria andSupplierEqualTo(String value) {
            addCriterion("supplier =", value, "supplier");
            return (Criteria) this;
        }

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

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

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

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

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

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

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

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

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

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

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

        public Criteria andItemIsNull() {
            addCriterion("item is null");
            return (Criteria) this;
        }

        public Criteria andItemIsNotNull() {
            addCriterion("item is not null");
            return (Criteria) this;
        }

        public Criteria andItemEqualTo(String value) {
            addCriterion("item =", value, "item");
            return (Criteria) this;
        }

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

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

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

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

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

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

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

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

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

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

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

        public Criteria andStandardMoneyIsNull() {
            addCriterion("standard_money is null");
            return (Criteria) this;
        }

        public Criteria andStandardMoneyIsNotNull() {
            addCriterion("standard_money is not null");
            return (Criteria) this;
        }

        public Criteria andStandardMoneyEqualTo(String value) {
            addCriterion("standard_money =", value, "standardMoney");
            return (Criteria) this;
        }

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

        public Criteria andStandardMoneyGreaterThan(String value) {
            addCriterion("standard_money >", value, "standardMoney");
            return (Criteria) this;
        }

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

        public Criteria andStandardMoneyLessThan(String value) {
            addCriterion("standard_money <", value, "standardMoney");
            return (Criteria) this;
        }

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

        public Criteria andStandardMoneyLike(String value) {
            addCriterion("standard_money like", value, "standardMoney");
            return (Criteria) this;
        }

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

        public Criteria andStandardMoneyIn(List<String> values) {
            addCriterion("standard_money in", values, "standardMoney");
            return (Criteria) this;
        }

        public Criteria andStandardMoneyNotIn(List<String> values) {
            addCriterion("standard_money not in", values, "standardMoney");
            return (Criteria) this;
        }

        public Criteria andStandardMoneyBetween(String value1, String value2) {
            addCriterion("standard_money between", value1, value2, "standardMoney");
            return (Criteria) this;
        }

        public Criteria andStandardMoneyNotBetween(String value1, String value2) {
            addCriterion("standard_money not between", value1, value2, "standardMoney");
            return (Criteria) this;
        }

        public Criteria andCurrencyIsNull() {
            addCriterion("currency is null");
            return (Criteria) this;
        }

        public Criteria andCurrencyIsNotNull() {
            addCriterion("currency is not null");
            return (Criteria) this;
        }

        public Criteria andCurrencyEqualTo(String value) {
            addCriterion("currency =", value, "currency");
            return (Criteria) this;
        }

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

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

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

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

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

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

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

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

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

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

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

        public Criteria andOrderAmountIsNull() {
            addCriterion("order_amount is null");
            return (Criteria) this;
        }

        public Criteria andOrderAmountIsNotNull() {
            addCriterion("order_amount is not null");
            return (Criteria) this;
        }

        public Criteria andOrderAmountEqualTo(BigDecimal value) {
            addCriterion("order_amount =", value, "orderAmount");
            return (Criteria) this;
        }

        public Criteria andOrderAmountNotEqualTo(BigDecimal value) {
            addCriterion("order_amount <>", value, "orderAmount");
            return (Criteria) this;
        }

        public Criteria andOrderAmountGreaterThan(BigDecimal value) {
            addCriterion("order_amount >", value, "orderAmount");
            return (Criteria) this;
        }

        public Criteria andOrderAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("order_amount >=", value, "orderAmount");
            return (Criteria) this;
        }

        public Criteria andOrderAmountLessThan(BigDecimal value) {
            addCriterion("order_amount <", value, "orderAmount");
            return (Criteria) this;
        }

        public Criteria andOrderAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("order_amount <=", value, "orderAmount");
            return (Criteria) this;
        }

        public Criteria andOrderAmountIn(List<BigDecimal> values) {
            addCriterion("order_amount in", values, "orderAmount");
            return (Criteria) this;
        }

        public Criteria andOrderAmountNotIn(List<BigDecimal> values) {
            addCriterion("order_amount not in", values, "orderAmount");
            return (Criteria) this;
        }

        public Criteria andOrderAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_amount between", value1, value2, "orderAmount");
            return (Criteria) this;
        }

        public Criteria andOrderAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_amount not between", value1, value2, "orderAmount");
            return (Criteria) this;
        }

        public Criteria andExecutedServiceScheduleIsNull() {
            addCriterion("executed_service_schedule is null");
            return (Criteria) this;
        }

        public Criteria andExecutedServiceScheduleIsNotNull() {
            addCriterion("executed_service_schedule is not null");
            return (Criteria) this;
        }

        public Criteria andExecutedServiceScheduleEqualTo(BigDecimal value) {
            addCriterion("executed_service_schedule =", value, "executedServiceSchedule");
            return (Criteria) this;
        }

        public Criteria andExecutedServiceScheduleNotEqualTo(BigDecimal value) {
            addCriterion("executed_service_schedule <>", value, "executedServiceSchedule");
            return (Criteria) this;
        }

        public Criteria andExecutedServiceScheduleGreaterThan(BigDecimal value) {
            addCriterion("executed_service_schedule >", value, "executedServiceSchedule");
            return (Criteria) this;
        }

        public Criteria andExecutedServiceScheduleGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("executed_service_schedule >=", value, "executedServiceSchedule");
            return (Criteria) this;
        }

        public Criteria andExecutedServiceScheduleLessThan(BigDecimal value) {
            addCriterion("executed_service_schedule <", value, "executedServiceSchedule");
            return (Criteria) this;
        }

        public Criteria andExecutedServiceScheduleLessThanOrEqualTo(BigDecimal value) {
            addCriterion("executed_service_schedule <=", value, "executedServiceSchedule");
            return (Criteria) this;
        }

        public Criteria andExecutedServiceScheduleIn(List<BigDecimal> values) {
            addCriterion("executed_service_schedule in", values, "executedServiceSchedule");
            return (Criteria) this;
        }

        public Criteria andExecutedServiceScheduleNotIn(List<BigDecimal> values) {
            addCriterion("executed_service_schedule not in", values, "executedServiceSchedule");
            return (Criteria) this;
        }

        public Criteria andExecutedServiceScheduleBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("executed_service_schedule between", value1, value2, "executedServiceSchedule");
            return (Criteria) this;
        }

        public Criteria andExecutedServiceScheduleNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("executed_service_schedule not between", value1, value2, "executedServiceSchedule");
            return (Criteria) this;
        }

        public Criteria andCoupaTotalAcceptIsNull() {
            addCriterion("coupa_total_accept is null");
            return (Criteria) this;
        }

        public Criteria andCoupaTotalAcceptIsNotNull() {
            addCriterion("coupa_total_accept is not null");
            return (Criteria) this;
        }

        public Criteria andCoupaTotalAcceptEqualTo(BigDecimal value) {
            addCriterion("coupa_total_accept =", value, "coupaTotalAccept");
            return (Criteria) this;
        }

        public Criteria andCoupaTotalAcceptNotEqualTo(BigDecimal value) {
            addCriterion("coupa_total_accept <>", value, "coupaTotalAccept");
            return (Criteria) this;
        }

        public Criteria andCoupaTotalAcceptGreaterThan(BigDecimal value) {
            addCriterion("coupa_total_accept >", value, "coupaTotalAccept");
            return (Criteria) this;
        }

        public Criteria andCoupaTotalAcceptGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("coupa_total_accept >=", value, "coupaTotalAccept");
            return (Criteria) this;
        }

        public Criteria andCoupaTotalAcceptLessThan(BigDecimal value) {
            addCriterion("coupa_total_accept <", value, "coupaTotalAccept");
            return (Criteria) this;
        }

        public Criteria andCoupaTotalAcceptLessThanOrEqualTo(BigDecimal value) {
            addCriterion("coupa_total_accept <=", value, "coupaTotalAccept");
            return (Criteria) this;
        }

        public Criteria andCoupaTotalAcceptIn(List<BigDecimal> values) {
            addCriterion("coupa_total_accept in", values, "coupaTotalAccept");
            return (Criteria) this;
        }

        public Criteria andCoupaTotalAcceptNotIn(List<BigDecimal> values) {
            addCriterion("coupa_total_accept not in", values, "coupaTotalAccept");
            return (Criteria) this;
        }

        public Criteria andCoupaTotalAcceptBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("coupa_total_accept between", value1, value2, "coupaTotalAccept");
            return (Criteria) this;
        }

        public Criteria andCoupaTotalAcceptNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("coupa_total_accept not between", value1, value2, "coupaTotalAccept");
            return (Criteria) this;
        }

        public Criteria andAdvanceIsNull() {
            addCriterion("advance is null");
            return (Criteria) this;
        }

        public Criteria andAdvanceIsNotNull() {
            addCriterion("advance is not null");
            return (Criteria) this;
        }

        public Criteria andAdvanceEqualTo(BigDecimal value) {
            addCriterion("advance =", value, "advance");
            return (Criteria) this;
        }

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

        public Criteria andAdvanceGreaterThan(BigDecimal value) {
            addCriterion("advance >", value, "advance");
            return (Criteria) this;
        }

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

        public Criteria andAdvanceLessThan(BigDecimal value) {
            addCriterion("advance <", value, "advance");
            return (Criteria) this;
        }

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

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

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

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

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

        public Criteria andUnexecutedServiceScheduleIsNull() {
            addCriterion("unexecuted_service_schedule is null");
            return (Criteria) this;
        }

        public Criteria andUnexecutedServiceScheduleIsNotNull() {
            addCriterion("unexecuted_service_schedule is not null");
            return (Criteria) this;
        }

        public Criteria andUnexecutedServiceScheduleEqualTo(BigDecimal value) {
            addCriterion("unexecuted_service_schedule =", value, "unexecutedServiceSchedule");
            return (Criteria) this;
        }

        public Criteria andUnexecutedServiceScheduleNotEqualTo(BigDecimal value) {
            addCriterion("unexecuted_service_schedule <>", value, "unexecutedServiceSchedule");
            return (Criteria) this;
        }

        public Criteria andUnexecutedServiceScheduleGreaterThan(BigDecimal value) {
            addCriterion("unexecuted_service_schedule >", value, "unexecutedServiceSchedule");
            return (Criteria) this;
        }

        public Criteria andUnexecutedServiceScheduleGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("unexecuted_service_schedule >=", value, "unexecutedServiceSchedule");
            return (Criteria) this;
        }

        public Criteria andUnexecutedServiceScheduleLessThan(BigDecimal value) {
            addCriterion("unexecuted_service_schedule <", value, "unexecutedServiceSchedule");
            return (Criteria) this;
        }

        public Criteria andUnexecutedServiceScheduleLessThanOrEqualTo(BigDecimal value) {
            addCriterion("unexecuted_service_schedule <=", value, "unexecutedServiceSchedule");
            return (Criteria) this;
        }

        public Criteria andUnexecutedServiceScheduleIn(List<BigDecimal> values) {
            addCriterion("unexecuted_service_schedule in", values, "unexecutedServiceSchedule");
            return (Criteria) this;
        }

        public Criteria andUnexecutedServiceScheduleNotIn(List<BigDecimal> values) {
            addCriterion("unexecuted_service_schedule not in", values, "unexecutedServiceSchedule");
            return (Criteria) this;
        }

        public Criteria andUnexecutedServiceScheduleBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("unexecuted_service_schedule between", value1, value2, "unexecutedServiceSchedule");
            return (Criteria) this;
        }

        public Criteria andUnexecutedServiceScheduleNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("unexecuted_service_schedule not between", value1, value2, "unexecutedServiceSchedule");
            return (Criteria) this;
        }

        public Criteria andApprovedStandardInvoiceAmountIsNull() {
            addCriterion("approved_standard_invoice_amount is null");
            return (Criteria) this;
        }

        public Criteria andApprovedStandardInvoiceAmountIsNotNull() {
            addCriterion("approved_standard_invoice_amount is not null");
            return (Criteria) this;
        }

        public Criteria andApprovedStandardInvoiceAmountEqualTo(BigDecimal value) {
            addCriterion("approved_standard_invoice_amount =", value, "approvedStandardInvoiceAmount");
            return (Criteria) this;
        }

        public Criteria andApprovedStandardInvoiceAmountNotEqualTo(BigDecimal value) {
            addCriterion("approved_standard_invoice_amount <>", value, "approvedStandardInvoiceAmount");
            return (Criteria) this;
        }

        public Criteria andApprovedStandardInvoiceAmountGreaterThan(BigDecimal value) {
            addCriterion("approved_standard_invoice_amount >", value, "approvedStandardInvoiceAmount");
            return (Criteria) this;
        }

        public Criteria andApprovedStandardInvoiceAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("approved_standard_invoice_amount >=", value, "approvedStandardInvoiceAmount");
            return (Criteria) this;
        }

        public Criteria andApprovedStandardInvoiceAmountLessThan(BigDecimal value) {
            addCriterion("approved_standard_invoice_amount <", value, "approvedStandardInvoiceAmount");
            return (Criteria) this;
        }

        public Criteria andApprovedStandardInvoiceAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("approved_standard_invoice_amount <=", value, "approvedStandardInvoiceAmount");
            return (Criteria) this;
        }

        public Criteria andApprovedStandardInvoiceAmountIn(List<BigDecimal> values) {
            addCriterion("approved_standard_invoice_amount in", values, "approvedStandardInvoiceAmount");
            return (Criteria) this;
        }

        public Criteria andApprovedStandardInvoiceAmountNotIn(List<BigDecimal> values) {
            addCriterion("approved_standard_invoice_amount not in", values, "approvedStandardInvoiceAmount");
            return (Criteria) this;
        }

        public Criteria andApprovedStandardInvoiceAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("approved_standard_invoice_amount between", value1, value2, "approvedStandardInvoiceAmount");
            return (Criteria) this;
        }

        public Criteria andApprovedStandardInvoiceAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("approved_standard_invoice_amount not between", value1, value2, "approvedStandardInvoiceAmount");
            return (Criteria) this;
        }

        public Criteria andPaidInvoiceAmountIsNull() {
            addCriterion("paid_invoice_amount is null");
            return (Criteria) this;
        }

        public Criteria andPaidInvoiceAmountIsNotNull() {
            addCriterion("paid_invoice_amount is not null");
            return (Criteria) this;
        }

        public Criteria andPaidInvoiceAmountEqualTo(BigDecimal value) {
            addCriterion("paid_invoice_amount =", value, "paidInvoiceAmount");
            return (Criteria) this;
        }

        public Criteria andPaidInvoiceAmountNotEqualTo(BigDecimal value) {
            addCriterion("paid_invoice_amount <>", value, "paidInvoiceAmount");
            return (Criteria) this;
        }

        public Criteria andPaidInvoiceAmountGreaterThan(BigDecimal value) {
            addCriterion("paid_invoice_amount >", value, "paidInvoiceAmount");
            return (Criteria) this;
        }

        public Criteria andPaidInvoiceAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("paid_invoice_amount >=", value, "paidInvoiceAmount");
            return (Criteria) this;
        }

        public Criteria andPaidInvoiceAmountLessThan(BigDecimal value) {
            addCriterion("paid_invoice_amount <", value, "paidInvoiceAmount");
            return (Criteria) this;
        }

        public Criteria andPaidInvoiceAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("paid_invoice_amount <=", value, "paidInvoiceAmount");
            return (Criteria) this;
        }

        public Criteria andPaidInvoiceAmountIn(List<BigDecimal> values) {
            addCriterion("paid_invoice_amount in", values, "paidInvoiceAmount");
            return (Criteria) this;
        }

        public Criteria andPaidInvoiceAmountNotIn(List<BigDecimal> values) {
            addCriterion("paid_invoice_amount not in", values, "paidInvoiceAmount");
            return (Criteria) this;
        }

        public Criteria andPaidInvoiceAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("paid_invoice_amount between", value1, value2, "paidInvoiceAmount");
            return (Criteria) this;
        }

        public Criteria andPaidInvoiceAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("paid_invoice_amount not between", value1, value2, "paidInvoiceAmount");
            return (Criteria) this;
        }

        public Criteria andUsableInvoiceAmountIsNull() {
            addCriterion("usable_invoice_amount is null");
            return (Criteria) this;
        }

        public Criteria andUsableInvoiceAmountIsNotNull() {
            addCriterion("usable_invoice_amount is not null");
            return (Criteria) this;
        }

        public Criteria andUsableInvoiceAmountEqualTo(BigDecimal value) {
            addCriterion("usable_invoice_amount =", value, "usableInvoiceAmount");
            return (Criteria) this;
        }

        public Criteria andUsableInvoiceAmountNotEqualTo(BigDecimal value) {
            addCriterion("usable_invoice_amount <>", value, "usableInvoiceAmount");
            return (Criteria) this;
        }

        public Criteria andUsableInvoiceAmountGreaterThan(BigDecimal value) {
            addCriterion("usable_invoice_amount >", value, "usableInvoiceAmount");
            return (Criteria) this;
        }

        public Criteria andUsableInvoiceAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("usable_invoice_amount >=", value, "usableInvoiceAmount");
            return (Criteria) this;
        }

        public Criteria andUsableInvoiceAmountLessThan(BigDecimal value) {
            addCriterion("usable_invoice_amount <", value, "usableInvoiceAmount");
            return (Criteria) this;
        }

        public Criteria andUsableInvoiceAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("usable_invoice_amount <=", value, "usableInvoiceAmount");
            return (Criteria) this;
        }

        public Criteria andUsableInvoiceAmountIn(List<BigDecimal> values) {
            addCriterion("usable_invoice_amount in", values, "usableInvoiceAmount");
            return (Criteria) this;
        }

        public Criteria andUsableInvoiceAmountNotIn(List<BigDecimal> values) {
            addCriterion("usable_invoice_amount not in", values, "usableInvoiceAmount");
            return (Criteria) this;
        }

        public Criteria andUsableInvoiceAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("usable_invoice_amount between", value1, value2, "usableInvoiceAmount");
            return (Criteria) this;
        }

        public Criteria andUsableInvoiceAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("usable_invoice_amount not between", value1, value2, "usableInvoiceAmount");
            return (Criteria) this;
        }

        public Criteria andUsableBalanceIsNull() {
            addCriterion("usable_balance is null");
            return (Criteria) this;
        }

        public Criteria andUsableBalanceIsNotNull() {
            addCriterion("usable_balance is not null");
            return (Criteria) this;
        }

        public Criteria andUsableBalanceEqualTo(BigDecimal value) {
            addCriterion("usable_balance =", value, "usableBalance");
            return (Criteria) this;
        }

        public Criteria andUsableBalanceNotEqualTo(BigDecimal value) {
            addCriterion("usable_balance <>", value, "usableBalance");
            return (Criteria) this;
        }

        public Criteria andUsableBalanceGreaterThan(BigDecimal value) {
            addCriterion("usable_balance >", value, "usableBalance");
            return (Criteria) this;
        }

        public Criteria andUsableBalanceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("usable_balance >=", value, "usableBalance");
            return (Criteria) this;
        }

        public Criteria andUsableBalanceLessThan(BigDecimal value) {
            addCriterion("usable_balance <", value, "usableBalance");
            return (Criteria) this;
        }

        public Criteria andUsableBalanceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("usable_balance <=", value, "usableBalance");
            return (Criteria) this;
        }

        public Criteria andUsableBalanceIn(List<BigDecimal> values) {
            addCriterion("usable_balance in", values, "usableBalance");
            return (Criteria) this;
        }

        public Criteria andUsableBalanceNotIn(List<BigDecimal> values) {
            addCriterion("usable_balance not in", values, "usableBalance");
            return (Criteria) this;
        }

        public Criteria andUsableBalanceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("usable_balance between", value1, value2, "usableBalance");
            return (Criteria) this;
        }

        public Criteria andUsableBalanceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("usable_balance not between", value1, value2, "usableBalance");
            return (Criteria) this;
        }

        public Criteria andAdvanceWriteOffIsNull() {
            addCriterion("advance_write_off is null");
            return (Criteria) this;
        }

        public Criteria andAdvanceWriteOffIsNotNull() {
            addCriterion("advance_write_off is not null");
            return (Criteria) this;
        }

        public Criteria andAdvanceWriteOffEqualTo(BigDecimal value) {
            addCriterion("advance_write_off =", value, "advanceWriteOff");
            return (Criteria) this;
        }

        public Criteria andAdvanceWriteOffNotEqualTo(BigDecimal value) {
            addCriterion("advance_write_off <>", value, "advanceWriteOff");
            return (Criteria) this;
        }

        public Criteria andAdvanceWriteOffGreaterThan(BigDecimal value) {
            addCriterion("advance_write_off >", value, "advanceWriteOff");
            return (Criteria) this;
        }

        public Criteria andAdvanceWriteOffGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("advance_write_off >=", value, "advanceWriteOff");
            return (Criteria) this;
        }

        public Criteria andAdvanceWriteOffLessThan(BigDecimal value) {
            addCriterion("advance_write_off <", value, "advanceWriteOff");
            return (Criteria) this;
        }

        public Criteria andAdvanceWriteOffLessThanOrEqualTo(BigDecimal value) {
            addCriterion("advance_write_off <=", value, "advanceWriteOff");
            return (Criteria) this;
        }

        public Criteria andAdvanceWriteOffIn(List<BigDecimal> values) {
            addCriterion("advance_write_off in", values, "advanceWriteOff");
            return (Criteria) this;
        }

        public Criteria andAdvanceWriteOffNotIn(List<BigDecimal> values) {
            addCriterion("advance_write_off not in", values, "advanceWriteOff");
            return (Criteria) this;
        }

        public Criteria andAdvanceWriteOffBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("advance_write_off between", value1, value2, "advanceWriteOff");
            return (Criteria) this;
        }

        public Criteria andAdvanceWriteOffNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("advance_write_off not between", value1, value2, "advanceWriteOff");
            return (Criteria) this;
        }

        public Criteria andSubjectCodeIsNull() {
            addCriterion("subject_code is null");
            return (Criteria) this;
        }

        public Criteria andSubjectCodeIsNotNull() {
            addCriterion("subject_code is not null");
            return (Criteria) this;
        }

        public Criteria andSubjectCodeEqualTo(String value) {
            addCriterion("subject_code =", value, "subjectCode");
            return (Criteria) this;
        }

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

        public Criteria andSubjectCodeGreaterThan(String value) {
            addCriterion("subject_code >", value, "subjectCode");
            return (Criteria) this;
        }

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

        public Criteria andSubjectCodeLessThan(String value) {
            addCriterion("subject_code <", value, "subjectCode");
            return (Criteria) this;
        }

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

        public Criteria andSubjectCodeLike(String value) {
            addCriterion("subject_code like", value, "subjectCode");
            return (Criteria) this;
        }

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

        public Criteria andSubjectCodeIn(List<String> values) {
            addCriterion("subject_code in", values, "subjectCode");
            return (Criteria) this;
        }

        public Criteria andSubjectCodeNotIn(List<String> values) {
            addCriterion("subject_code not in", values, "subjectCode");
            return (Criteria) this;
        }

        public Criteria andSubjectCodeBetween(String value1, String value2) {
            addCriterion("subject_code between", value1, value2, "subjectCode");
            return (Criteria) this;
        }

        public Criteria andSubjectCodeNotBetween(String value1, String value2) {
            addCriterion("subject_code not between", value1, value2, "subjectCode");
            return (Criteria) this;
        }

        public Criteria andSubjectDescriptionIsNull() {
            addCriterion("subject_description is null");
            return (Criteria) this;
        }

        public Criteria andSubjectDescriptionIsNotNull() {
            addCriterion("subject_description is not null");
            return (Criteria) this;
        }

        public Criteria andSubjectDescriptionEqualTo(String value) {
            addCriterion("subject_description =", value, "subjectDescription");
            return (Criteria) this;
        }

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

        public Criteria andSubjectDescriptionGreaterThan(String value) {
            addCriterion("subject_description >", value, "subjectDescription");
            return (Criteria) this;
        }

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

        public Criteria andSubjectDescriptionLessThan(String value) {
            addCriterion("subject_description <", value, "subjectDescription");
            return (Criteria) this;
        }

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

        public Criteria andSubjectDescriptionLike(String value) {
            addCriterion("subject_description like", value, "subjectDescription");
            return (Criteria) this;
        }

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

        public Criteria andSubjectDescriptionIn(List<String> values) {
            addCriterion("subject_description in", values, "subjectDescription");
            return (Criteria) this;
        }

        public Criteria andSubjectDescriptionNotIn(List<String> values) {
            addCriterion("subject_description not in", values, "subjectDescription");
            return (Criteria) this;
        }

        public Criteria andSubjectDescriptionBetween(String value1, String value2) {
            addCriterion("subject_description between", value1, value2, "subjectDescription");
            return (Criteria) this;
        }

        public Criteria andSubjectDescriptionNotBetween(String value1, String value2) {
            addCriterion("subject_description not between", value1, value2, "subjectDescription");
            return (Criteria) this;
        }

        public Criteria andAuxiliarySubjectIsNull() {
            addCriterion("auxiliary_subject is null");
            return (Criteria) this;
        }

        public Criteria andAuxiliarySubjectIsNotNull() {
            addCriterion("auxiliary_subject is not null");
            return (Criteria) this;
        }

        public Criteria andAuxiliarySubjectEqualTo(String value) {
            addCriterion("auxiliary_subject =", value, "auxiliarySubject");
            return (Criteria) this;
        }

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

        public Criteria andAuxiliarySubjectGreaterThan(String value) {
            addCriterion("auxiliary_subject >", value, "auxiliarySubject");
            return (Criteria) this;
        }

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

        public Criteria andAuxiliarySubjectLessThan(String value) {
            addCriterion("auxiliary_subject <", value, "auxiliarySubject");
            return (Criteria) this;
        }

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

        public Criteria andAuxiliarySubjectLike(String value) {
            addCriterion("auxiliary_subject like", value, "auxiliarySubject");
            return (Criteria) this;
        }

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

        public Criteria andAuxiliarySubjectIn(List<String> values) {
            addCriterion("auxiliary_subject in", values, "auxiliarySubject");
            return (Criteria) this;
        }

        public Criteria andAuxiliarySubjectNotIn(List<String> values) {
            addCriterion("auxiliary_subject not in", values, "auxiliarySubject");
            return (Criteria) this;
        }

        public Criteria andAuxiliarySubjectBetween(String value1, String value2) {
            addCriterion("auxiliary_subject between", value1, value2, "auxiliarySubject");
            return (Criteria) this;
        }

        public Criteria andAuxiliarySubjectNotBetween(String value1, String value2) {
            addCriterion("auxiliary_subject not between", value1, value2, "auxiliarySubject");
            return (Criteria) this;
        }

        public Criteria andAuxiliarySubjectDescriptionIsNull() {
            addCriterion("auxiliary_subject_description is null");
            return (Criteria) this;
        }

        public Criteria andAuxiliarySubjectDescriptionIsNotNull() {
            addCriterion("auxiliary_subject_description is not null");
            return (Criteria) this;
        }

        public Criteria andAuxiliarySubjectDescriptionEqualTo(String value) {
            addCriterion("auxiliary_subject_description =", value, "auxiliarySubjectDescription");
            return (Criteria) this;
        }

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

        public Criteria andAuxiliarySubjectDescriptionGreaterThan(String value) {
            addCriterion("auxiliary_subject_description >", value, "auxiliarySubjectDescription");
            return (Criteria) this;
        }

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

        public Criteria andAuxiliarySubjectDescriptionLessThan(String value) {
            addCriterion("auxiliary_subject_description <", value, "auxiliarySubjectDescription");
            return (Criteria) this;
        }

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

        public Criteria andAuxiliarySubjectDescriptionLike(String value) {
            addCriterion("auxiliary_subject_description like", value, "auxiliarySubjectDescription");
            return (Criteria) this;
        }

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

        public Criteria andAuxiliarySubjectDescriptionIn(List<String> values) {
            addCriterion("auxiliary_subject_description in", values, "auxiliarySubjectDescription");
            return (Criteria) this;
        }

        public Criteria andAuxiliarySubjectDescriptionNotIn(List<String> values) {
            addCriterion("auxiliary_subject_description not in", values, "auxiliarySubjectDescription");
            return (Criteria) this;
        }

        public Criteria andAuxiliarySubjectDescriptionBetween(String value1, String value2) {
            addCriterion("auxiliary_subject_description between", value1, value2, "auxiliarySubjectDescription");
            return (Criteria) this;
        }

        public Criteria andAuxiliarySubjectDescriptionNotBetween(String value1, String value2) {
            addCriterion("auxiliary_subject_description not between", value1, value2, "auxiliarySubjectDescription");
            return (Criteria) this;
        }

        public Criteria andProfitCenterIsNull() {
            addCriterion("profit_center is null");
            return (Criteria) this;
        }

        public Criteria andProfitCenterIsNotNull() {
            addCriterion("profit_center is not null");
            return (Criteria) this;
        }

        public Criteria andProfitCenterEqualTo(String value) {
            addCriterion("profit_center =", value, "profitCenter");
            return (Criteria) this;
        }

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

        public Criteria andProfitCenterGreaterThan(String value) {
            addCriterion("profit_center >", value, "profitCenter");
            return (Criteria) this;
        }

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

        public Criteria andProfitCenterLessThan(String value) {
            addCriterion("profit_center <", value, "profitCenter");
            return (Criteria) this;
        }

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

        public Criteria andProfitCenterLike(String value) {
            addCriterion("profit_center like", value, "profitCenter");
            return (Criteria) this;
        }

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

        public Criteria andProfitCenterIn(List<String> values) {
            addCriterion("profit_center in", values, "profitCenter");
            return (Criteria) this;
        }

        public Criteria andProfitCenterNotIn(List<String> values) {
            addCriterion("profit_center not in", values, "profitCenter");
            return (Criteria) this;
        }

        public Criteria andProfitCenterBetween(String value1, String value2) {
            addCriterion("profit_center between", value1, value2, "profitCenter");
            return (Criteria) this;
        }

        public Criteria andProfitCenterNotBetween(String value1, String value2) {
            addCriterion("profit_center not between", value1, value2, "profitCenter");
            return (Criteria) this;
        }

        public Criteria andProfitCenterDescriptionIsNull() {
            addCriterion("profit_center_description is null");
            return (Criteria) this;
        }

        public Criteria andProfitCenterDescriptionIsNotNull() {
            addCriterion("profit_center_description is not null");
            return (Criteria) this;
        }

        public Criteria andProfitCenterDescriptionEqualTo(String value) {
            addCriterion("profit_center_description =", value, "profitCenterDescription");
            return (Criteria) this;
        }

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

        public Criteria andProfitCenterDescriptionGreaterThan(String value) {
            addCriterion("profit_center_description >", value, "profitCenterDescription");
            return (Criteria) this;
        }

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

        public Criteria andProfitCenterDescriptionLessThan(String value) {
            addCriterion("profit_center_description <", value, "profitCenterDescription");
            return (Criteria) this;
        }

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

        public Criteria andProfitCenterDescriptionLike(String value) {
            addCriterion("profit_center_description like", value, "profitCenterDescription");
            return (Criteria) this;
        }

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

        public Criteria andProfitCenterDescriptionIn(List<String> values) {
            addCriterion("profit_center_description in", values, "profitCenterDescription");
            return (Criteria) this;
        }

        public Criteria andProfitCenterDescriptionNotIn(List<String> values) {
            addCriterion("profit_center_description not in", values, "profitCenterDescription");
            return (Criteria) this;
        }

        public Criteria andProfitCenterDescriptionBetween(String value1, String value2) {
            addCriterion("profit_center_description between", value1, value2, "profitCenterDescription");
            return (Criteria) this;
        }

        public Criteria andProfitCenterDescriptionNotBetween(String value1, String value2) {
            addCriterion("profit_center_description not between", value1, value2, "profitCenterDescription");
            return (Criteria) this;
        }

        public Criteria andProductIsNull() {
            addCriterion("product is null");
            return (Criteria) this;
        }

        public Criteria andProductIsNotNull() {
            addCriterion("product is not null");
            return (Criteria) this;
        }

        public Criteria andProductEqualTo(String value) {
            addCriterion("product =", value, "product");
            return (Criteria) this;
        }

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

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

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

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

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

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

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

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

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

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

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

        public Criteria andProductDescriptionIsNull() {
            addCriterion("product_description is null");
            return (Criteria) this;
        }

        public Criteria andProductDescriptionIsNotNull() {
            addCriterion("product_description is not null");
            return (Criteria) this;
        }

        public Criteria andProductDescriptionEqualTo(String value) {
            addCriterion("product_description =", value, "productDescription");
            return (Criteria) this;
        }

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

        public Criteria andProductDescriptionGreaterThan(String value) {
            addCriterion("product_description >", value, "productDescription");
            return (Criteria) this;
        }

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

        public Criteria andProductDescriptionLessThan(String value) {
            addCriterion("product_description <", value, "productDescription");
            return (Criteria) this;
        }

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

        public Criteria andProductDescriptionLike(String value) {
            addCriterion("product_description like", value, "productDescription");
            return (Criteria) this;
        }

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

        public Criteria andProductDescriptionIn(List<String> values) {
            addCriterion("product_description in", values, "productDescription");
            return (Criteria) this;
        }

        public Criteria andProductDescriptionNotIn(List<String> values) {
            addCriterion("product_description not in", values, "productDescription");
            return (Criteria) this;
        }

        public Criteria andProductDescriptionBetween(String value1, String value2) {
            addCriterion("product_description between", value1, value2, "productDescription");
            return (Criteria) this;
        }

        public Criteria andProductDescriptionNotBetween(String value1, String value2) {
            addCriterion("product_description not between", value1, value2, "productDescription");
            return (Criteria) this;
        }

        public Criteria andProjectIsNull() {
            addCriterion("project is null");
            return (Criteria) this;
        }

        public Criteria andProjectIsNotNull() {
            addCriterion("project is not null");
            return (Criteria) this;
        }

        public Criteria andProjectEqualTo(String value) {
            addCriterion("project =", value, "project");
            return (Criteria) this;
        }

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

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

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

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

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

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

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

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

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

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

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

        public Criteria andProjectDescriptionIsNull() {
            addCriterion("project_description is null");
            return (Criteria) this;
        }

        public Criteria andProjectDescriptionIsNotNull() {
            addCriterion("project_description is not null");
            return (Criteria) this;
        }

        public Criteria andProjectDescriptionEqualTo(String value) {
            addCriterion("project_description =", value, "projectDescription");
            return (Criteria) this;
        }

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

        public Criteria andProjectDescriptionGreaterThan(String value) {
            addCriterion("project_description >", value, "projectDescription");
            return (Criteria) this;
        }

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

        public Criteria andProjectDescriptionLessThan(String value) {
            addCriterion("project_description <", value, "projectDescription");
            return (Criteria) this;
        }

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

        public Criteria andProjectDescriptionLike(String value) {
            addCriterion("project_description like", value, "projectDescription");
            return (Criteria) this;
        }

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

        public Criteria andProjectDescriptionIn(List<String> values) {
            addCriterion("project_description in", values, "projectDescription");
            return (Criteria) this;
        }

        public Criteria andProjectDescriptionNotIn(List<String> values) {
            addCriterion("project_description not in", values, "projectDescription");
            return (Criteria) this;
        }

        public Criteria andProjectDescriptionBetween(String value1, String value2) {
            addCriterion("project_description between", value1, value2, "projectDescription");
            return (Criteria) this;
        }

        public Criteria andProjectDescriptionNotBetween(String value1, String value2) {
            addCriterion("project_description not between", value1, value2, "projectDescription");
            return (Criteria) this;
        }

        public Criteria andCompanyIsNull() {
            addCriterion("company is null");
            return (Criteria) this;
        }

        public Criteria andCompanyIsNotNull() {
            addCriterion("company is not null");
            return (Criteria) this;
        }

        public Criteria andCompanyEqualTo(String value) {
            addCriterion("company =", value, "company");
            return (Criteria) this;
        }

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

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

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

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

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

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

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

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

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

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

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

        public Criteria andCompanyDescriptionIsNull() {
            addCriterion("company_description is null");
            return (Criteria) this;
        }

        public Criteria andCompanyDescriptionIsNotNull() {
            addCriterion("company_description is not null");
            return (Criteria) this;
        }

        public Criteria andCompanyDescriptionEqualTo(String value) {
            addCriterion("company_description =", value, "companyDescription");
            return (Criteria) this;
        }

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

        public Criteria andCompanyDescriptionGreaterThan(String value) {
            addCriterion("company_description >", value, "companyDescription");
            return (Criteria) this;
        }

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

        public Criteria andCompanyDescriptionLessThan(String value) {
            addCriterion("company_description <", value, "companyDescription");
            return (Criteria) this;
        }

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

        public Criteria andCompanyDescriptionLike(String value) {
            addCriterion("company_description like", value, "companyDescription");
            return (Criteria) this;
        }

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

        public Criteria andCompanyDescriptionIn(List<String> values) {
            addCriterion("company_description in", values, "companyDescription");
            return (Criteria) this;
        }

        public Criteria andCompanyDescriptionNotIn(List<String> values) {
            addCriterion("company_description not in", values, "companyDescription");
            return (Criteria) this;
        }

        public Criteria andCompanyDescriptionBetween(String value1, String value2) {
            addCriterion("company_description between", value1, value2, "companyDescription");
            return (Criteria) this;
        }

        public Criteria andCompanyDescriptionNotBetween(String value1, String value2) {
            addCriterion("company_description not between", value1, value2, "companyDescription");
            return (Criteria) this;
        }

        public Criteria andSegment1IsNull() {
            addCriterion("segment1 is null");
            return (Criteria) this;
        }

        public Criteria andSegment1IsNotNull() {
            addCriterion("segment1 is not null");
            return (Criteria) this;
        }

        public Criteria andSegment1EqualTo(String value) {
            addCriterion("segment1 =", value, "segment1");
            return (Criteria) this;
        }

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

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

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

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

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

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

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

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

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

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

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

        public Criteria andSegment1DescriptionIsNull() {
            addCriterion("segment1_description is null");
            return (Criteria) this;
        }

        public Criteria andSegment1DescriptionIsNotNull() {
            addCriterion("segment1_description is not null");
            return (Criteria) this;
        }

        public Criteria andSegment1DescriptionEqualTo(String value) {
            addCriterion("segment1_description =", value, "segment1Description");
            return (Criteria) this;
        }

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

        public Criteria andSegment1DescriptionGreaterThan(String value) {
            addCriterion("segment1_description >", value, "segment1Description");
            return (Criteria) this;
        }

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

        public Criteria andSegment1DescriptionLessThan(String value) {
            addCriterion("segment1_description <", value, "segment1Description");
            return (Criteria) this;
        }

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

        public Criteria andSegment1DescriptionLike(String value) {
            addCriterion("segment1_description like", value, "segment1Description");
            return (Criteria) this;
        }

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

        public Criteria andSegment1DescriptionIn(List<String> values) {
            addCriterion("segment1_description in", values, "segment1Description");
            return (Criteria) this;
        }

        public Criteria andSegment1DescriptionNotIn(List<String> values) {
            addCriterion("segment1_description not in", values, "segment1Description");
            return (Criteria) this;
        }

        public Criteria andSegment1DescriptionBetween(String value1, String value2) {
            addCriterion("segment1_description between", value1, value2, "segment1Description");
            return (Criteria) this;
        }

        public Criteria andSegment1DescriptionNotBetween(String value1, String value2) {
            addCriterion("segment1_description not between", value1, value2, "segment1Description");
            return (Criteria) this;
        }

        public Criteria andSegment2IsNull() {
            addCriterion("segment2 is null");
            return (Criteria) this;
        }

        public Criteria andSegment2IsNotNull() {
            addCriterion("segment2 is not null");
            return (Criteria) this;
        }

        public Criteria andSegment2EqualTo(String value) {
            addCriterion("segment2 =", value, "segment2");
            return (Criteria) this;
        }

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

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

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

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

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

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

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

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

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

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

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

        public Criteria andSegment2DescriptionIsNull() {
            addCriterion("segment2_description is null");
            return (Criteria) this;
        }

        public Criteria andSegment2DescriptionIsNotNull() {
            addCriterion("segment2_description is not null");
            return (Criteria) this;
        }

        public Criteria andSegment2DescriptionEqualTo(String value) {
            addCriterion("segment2_description =", value, "segment2Description");
            return (Criteria) this;
        }

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

        public Criteria andSegment2DescriptionGreaterThan(String value) {
            addCriterion("segment2_description >", value, "segment2Description");
            return (Criteria) this;
        }

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

        public Criteria andSegment2DescriptionLessThan(String value) {
            addCriterion("segment2_description <", value, "segment2Description");
            return (Criteria) this;
        }

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

        public Criteria andSegment2DescriptionLike(String value) {
            addCriterion("segment2_description like", value, "segment2Description");
            return (Criteria) this;
        }

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

        public Criteria andSegment2DescriptionIn(List<String> values) {
            addCriterion("segment2_description in", values, "segment2Description");
            return (Criteria) this;
        }

        public Criteria andSegment2DescriptionNotIn(List<String> values) {
            addCriterion("segment2_description not in", values, "segment2Description");
            return (Criteria) this;
        }

        public Criteria andSegment2DescriptionBetween(String value1, String value2) {
            addCriterion("segment2_description between", value1, value2, "segment2Description");
            return (Criteria) this;
        }

        public Criteria andSegment2DescriptionNotBetween(String value1, String value2) {
            addCriterion("segment2_description not between", value1, value2, "segment2Description");
            return (Criteria) this;
        }

        public Criteria andCreatedByIsNull() {
            addCriterion("created_by is null");
            return (Criteria) this;
        }

        public Criteria andCreatedByIsNotNull() {
            addCriterion("created_by is not null");
            return (Criteria) this;
        }

        public Criteria andCreatedByEqualTo(String value) {
            addCriterion("created_by =", value, "createdBy");
            return (Criteria) this;
        }

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

        public Criteria andCreatedByGreaterThan(String value) {
            addCriterion("created_by >", value, "createdBy");
            return (Criteria) this;
        }

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

        public Criteria andCreatedByLessThan(String value) {
            addCriterion("created_by <", value, "createdBy");
            return (Criteria) this;
        }

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

        public Criteria andCreatedByLike(String value) {
            addCriterion("created_by like", value, "createdBy");
            return (Criteria) this;
        }

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

        public Criteria andCreatedByIn(List<String> values) {
            addCriterion("created_by in", values, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByNotIn(List<String> values) {
            addCriterion("created_by not in", values, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByBetween(String value1, String value2) {
            addCriterion("created_by between", value1, value2, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByNotBetween(String value1, String value2) {
            addCriterion("created_by not between", value1, value2, "createdBy");
            return (Criteria) this;
        }

        public Criteria andUpdatedByIsNull() {
            addCriterion("updated_by is null");
            return (Criteria) this;
        }

        public Criteria andUpdatedByIsNotNull() {
            addCriterion("updated_by is not null");
            return (Criteria) this;
        }

        public Criteria andUpdatedByEqualTo(String value) {
            addCriterion("updated_by =", value, "updatedBy");
            return (Criteria) this;
        }

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

        public Criteria andUpdatedByGreaterThan(String value) {
            addCriterion("updated_by >", value, "updatedBy");
            return (Criteria) this;
        }

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

        public Criteria andUpdatedByLessThan(String value) {
            addCriterion("updated_by <", value, "updatedBy");
            return (Criteria) this;
        }

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

        public Criteria andUpdatedByLike(String value) {
            addCriterion("updated_by like", value, "updatedBy");
            return (Criteria) this;
        }

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

        public Criteria andUpdatedByIn(List<String> values) {
            addCriterion("updated_by in", values, "updatedBy");
            return (Criteria) this;
        }

        public Criteria andUpdatedByNotIn(List<String> values) {
            addCriterion("updated_by not in", values, "updatedBy");
            return (Criteria) this;
        }

        public Criteria andUpdatedByBetween(String value1, String value2) {
            addCriterion("updated_by between", value1, value2, "updatedBy");
            return (Criteria) this;
        }

        public Criteria andUpdatedByNotBetween(String value1, String value2) {
            addCriterion("updated_by not between", value1, value2, "updatedBy");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("create_time is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("create_time is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("create_time =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("create_time <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("create_time >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("create_time >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("create_time <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("create_time <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("create_time in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("create_time not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("create_time between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("create_time not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("update_time is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("update_time is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("update_time =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("update_time <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("update_time >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("update_time >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("update_time <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("update_time <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("update_time in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("update_time not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("update_time between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("update_time not between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andMonthIsNull() {
            addCriterion("month is null");
            return (Criteria) this;
        }

        public Criteria andMonthIsNotNull() {
            addCriterion("month is not null");
            return (Criteria) this;
        }

        public Criteria andMonthEqualTo(Integer value) {
            addCriterion("month =", value, "month");
            return (Criteria) this;
        }

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

        public Criteria andMonthGreaterThan(Integer value) {
            addCriterion("month >", value, "month");
            return (Criteria) this;
        }

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

        public Criteria andMonthLessThan(Integer value) {
            addCriterion("month <", value, "month");
            return (Criteria) this;
        }

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

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

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

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

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

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table cit_salary_advance
     *
     * @mbg.generated do_not_delete_during_merge
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table cit_salary_advance
     *
     * @mbg.generated
     */
    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

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

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

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

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

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