TrafficExample.java

package com.viontech.fanxing.commons.model;

import com.viontech.fanxing.commons.base.BaseExample;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashSet;
import java.util.List;
import java.util.Set;

public class TrafficExample extends BaseExample {

    public TrafficExample() {
        super();
        tableName = "d_traffic";
        tableAlias = "traffic";
        ignoreCase = false;
    }

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

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

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria(this.tableName,this.ignoreCase);
        return criteria;
    }

    public ColumnContainer createColumns() {
        ColumnContainer columnContainer = (ColumnContainer) columnContainerMap.get(this.tableName);
        if(columnContainer == null){
            columnContainer = new ColumnContainer(this.tableName);
            columnContainerMap.put(this.tableName,columnContainer);
        }
        return (ColumnContainer)columnContainer;
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria(String tableName) {
            super(tableName);
            tableName = "d_traffic";
        }

        protected Criteria(String tableName, boolean ignoreCase) {
            this(tableName);
            this.ignoreCase = ignoreCase;
        }

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

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

        public void setAllCriteria(List<Criterion> criteria) {
            this.criteria = 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,ignoreCase));
        }

        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("`traffic`.id is null");
            return (Criteria) this;
        }

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

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

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

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

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

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

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

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

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

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

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

        public Criteria andEventTimeIsNull() {
            addCriterion("`traffic`.event_time is null");
            return (Criteria) this;
        }

        public Criteria andEventTimeIsNotNull() {
            addCriterion("`traffic`.event_time is not null");
            return (Criteria) this;
        }

        public Criteria andEventTimeEqualTo(Date value) {
            addCriterion("`traffic`.event_time =", value, "eventTime");
            return (Criteria) this;
        }

        public Criteria andEventTimeNotEqualTo(Date value) {
            addCriterion("`traffic`.event_time <>", value, "eventTime");
            return (Criteria) this;
        }

        public Criteria andEventTimeGreaterThan(Date value) {
            addCriterion("`traffic`.event_time >", value, "eventTime");
            return (Criteria) this;
        }

        public Criteria andEventTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("`traffic`.event_time >=", value, "eventTime");
            return (Criteria) this;
        }

        public Criteria andEventTimeLessThan(Date value) {
            addCriterion("`traffic`.event_time <", value, "eventTime");
            return (Criteria) this;
        }

        public Criteria andEventTimeLessThanOrEqualTo(Date value) {
            addCriterion("`traffic`.event_time <=", value, "eventTime");
            return (Criteria) this;
        }

        public Criteria andEventTimeIn(List<Date> values) {
            addCriterion("`traffic`.event_time in", values, "eventTime");
            return (Criteria) this;
        }

        public Criteria andEventTimeNotIn(List<Date> values) {
            addCriterion("`traffic`.event_time not in", values, "eventTime");
            return (Criteria) this;
        }

        public Criteria andEventTimeBetween(Date value1, Date value2) {
            addCriterion("`traffic`.event_time between", value1, value2, "eventTime");
            return (Criteria) this;
        }

        public Criteria andEventTimeNotBetween(Date value1, Date value2) {
            addCriterion("`traffic`.event_time not between", value1, value2, "eventTime");
            return (Criteria) this;
        }

        public Criteria andUnidIsNull() {
            addCriterion("`traffic`.unid is null");
            return (Criteria) this;
        }

        public Criteria andUnidIsNotNull() {
            addCriterion("`traffic`.unid is not null");
            return (Criteria) this;
        }

        public Criteria andUnidEqualTo(String value) {
            addCriterion("`traffic`.unid =", value, "unid");
            return (Criteria) this;
        }

        public Criteria andUnidNotEqualTo(String value) {
            addCriterion("`traffic`.unid <>", value, "unid");
            return (Criteria) this;
        }

        public Criteria andUnidGreaterThan(String value) {
            addCriterion("`traffic`.unid >", value, "unid");
            return (Criteria) this;
        }

        public Criteria andUnidGreaterThanOrEqualTo(String value) {
            addCriterion("`traffic`.unid >=", value, "unid");
            return (Criteria) this;
        }

        public Criteria andUnidLessThan(String value) {
            addCriterion("`traffic`.unid <", value, "unid");
            return (Criteria) this;
        }

        public Criteria andUnidLessThanOrEqualTo(String value) {
            addCriterion("`traffic`.unid <=", value, "unid");
            return (Criteria) this;
        }

        public Criteria andUnidLike(String value) {
            addCriterion("`traffic`.unid like", value, "unid");
            return (Criteria) this;
        }

        public Criteria andUnidNotLike(String value) {
            addCriterion("`traffic`.unid not like", value, "unid");
            return (Criteria) this;
        }

        public Criteria andUnidIn(List<String> values) {
            addCriterion("`traffic`.unid in", values, "unid");
            return (Criteria) this;
        }

        public Criteria andUnidNotIn(List<String> values) {
            addCriterion("`traffic`.unid not in", values, "unid");
            return (Criteria) this;
        }

        public Criteria andUnidBetween(String value1, String value2) {
            addCriterion("`traffic`.unid between", value1, value2, "unid");
            return (Criteria) this;
        }

        public Criteria andUnidNotBetween(String value1, String value2) {
            addCriterion("`traffic`.unid not between", value1, value2, "unid");
            return (Criteria) this;
        }

        public Criteria andTaskIdIsNull() {
            addCriterion("`traffic`.task_id is null");
            return (Criteria) this;
        }

        public Criteria andTaskIdIsNotNull() {
            addCriterion("`traffic`.task_id is not null");
            return (Criteria) this;
        }

        public Criteria andTaskIdEqualTo(Long value) {
            addCriterion("`traffic`.task_id =", value, "taskId");
            return (Criteria) this;
        }

        public Criteria andTaskIdNotEqualTo(Long value) {
            addCriterion("`traffic`.task_id <>", value, "taskId");
            return (Criteria) this;
        }

        public Criteria andTaskIdGreaterThan(Long value) {
            addCriterion("`traffic`.task_id >", value, "taskId");
            return (Criteria) this;
        }

        public Criteria andTaskIdGreaterThanOrEqualTo(Long value) {
            addCriterion("`traffic`.task_id >=", value, "taskId");
            return (Criteria) this;
        }

        public Criteria andTaskIdLessThan(Long value) {
            addCriterion("`traffic`.task_id <", value, "taskId");
            return (Criteria) this;
        }

        public Criteria andTaskIdLessThanOrEqualTo(Long value) {
            addCriterion("`traffic`.task_id <=", value, "taskId");
            return (Criteria) this;
        }

        public Criteria andTaskIdIn(List<Long> values) {
            addCriterion("`traffic`.task_id in", values, "taskId");
            return (Criteria) this;
        }

        public Criteria andTaskIdNotIn(List<Long> values) {
            addCriterion("`traffic`.task_id not in", values, "taskId");
            return (Criteria) this;
        }

        public Criteria andTaskIdBetween(Long value1, Long value2) {
            addCriterion("`traffic`.task_id between", value1, value2, "taskId");
            return (Criteria) this;
        }

        public Criteria andTaskIdNotBetween(Long value1, Long value2) {
            addCriterion("`traffic`.task_id not between", value1, value2, "taskId");
            return (Criteria) this;
        }

        public Criteria andEventCateIsNull() {
            addCriterion("`traffic`.event_cate is null");
            return (Criteria) this;
        }

        public Criteria andEventCateIsNotNull() {
            addCriterion("`traffic`.event_cate is not null");
            return (Criteria) this;
        }

        public Criteria andEventCateEqualTo(String value) {
            addCriterion("`traffic`.event_cate =", value, "eventCate");
            return (Criteria) this;
        }

        public Criteria andEventCateNotEqualTo(String value) {
            addCriterion("`traffic`.event_cate <>", value, "eventCate");
            return (Criteria) this;
        }

        public Criteria andEventCateGreaterThan(String value) {
            addCriterion("`traffic`.event_cate >", value, "eventCate");
            return (Criteria) this;
        }

        public Criteria andEventCateGreaterThanOrEqualTo(String value) {
            addCriterion("`traffic`.event_cate >=", value, "eventCate");
            return (Criteria) this;
        }

        public Criteria andEventCateLessThan(String value) {
            addCriterion("`traffic`.event_cate <", value, "eventCate");
            return (Criteria) this;
        }

        public Criteria andEventCateLessThanOrEqualTo(String value) {
            addCriterion("`traffic`.event_cate <=", value, "eventCate");
            return (Criteria) this;
        }

        public Criteria andEventCateLike(String value) {
            addCriterion("`traffic`.event_cate like", value, "eventCate");
            return (Criteria) this;
        }

        public Criteria andEventCateNotLike(String value) {
            addCriterion("`traffic`.event_cate not like", value, "eventCate");
            return (Criteria) this;
        }

        public Criteria andEventCateIn(List<String> values) {
            addCriterion("`traffic`.event_cate in", values, "eventCate");
            return (Criteria) this;
        }

        public Criteria andEventCateNotIn(List<String> values) {
            addCriterion("`traffic`.event_cate not in", values, "eventCate");
            return (Criteria) this;
        }

        public Criteria andEventCateBetween(String value1, String value2) {
            addCriterion("`traffic`.event_cate between", value1, value2, "eventCate");
            return (Criteria) this;
        }

        public Criteria andEventCateNotBetween(String value1, String value2) {
            addCriterion("`traffic`.event_cate not between", value1, value2, "eventCate");
            return (Criteria) this;
        }

        public Criteria andEventTypeIsNull() {
            addCriterion("`traffic`.event_type is null");
            return (Criteria) this;
        }

        public Criteria andEventTypeIsNotNull() {
            addCriterion("`traffic`.event_type is not null");
            return (Criteria) this;
        }

        public Criteria andEventTypeEqualTo(String value) {
            addCriterion("`traffic`.event_type =", value, "eventType");
            return (Criteria) this;
        }

        public Criteria andEventTypeNotEqualTo(String value) {
            addCriterion("`traffic`.event_type <>", value, "eventType");
            return (Criteria) this;
        }

        public Criteria andEventTypeGreaterThan(String value) {
            addCriterion("`traffic`.event_type >", value, "eventType");
            return (Criteria) this;
        }

        public Criteria andEventTypeGreaterThanOrEqualTo(String value) {
            addCriterion("`traffic`.event_type >=", value, "eventType");
            return (Criteria) this;
        }

        public Criteria andEventTypeLessThan(String value) {
            addCriterion("`traffic`.event_type <", value, "eventType");
            return (Criteria) this;
        }

        public Criteria andEventTypeLessThanOrEqualTo(String value) {
            addCriterion("`traffic`.event_type <=", value, "eventType");
            return (Criteria) this;
        }

        public Criteria andEventTypeLike(String value) {
            addCriterion("`traffic`.event_type like", value, "eventType");
            return (Criteria) this;
        }

        public Criteria andEventTypeNotLike(String value) {
            addCriterion("`traffic`.event_type not like", value, "eventType");
            return (Criteria) this;
        }

        public Criteria andEventTypeIn(List<String> values) {
            addCriterion("`traffic`.event_type in", values, "eventType");
            return (Criteria) this;
        }

        public Criteria andEventTypeNotIn(List<String> values) {
            addCriterion("`traffic`.event_type not in", values, "eventType");
            return (Criteria) this;
        }

        public Criteria andEventTypeBetween(String value1, String value2) {
            addCriterion("`traffic`.event_type between", value1, value2, "eventType");
            return (Criteria) this;
        }

        public Criteria andEventTypeNotBetween(String value1, String value2) {
            addCriterion("`traffic`.event_type not between", value1, value2, "eventType");
            return (Criteria) this;
        }

        public Criteria andChannelUnidIsNull() {
            addCriterion("`traffic`.channel_unid is null");
            return (Criteria) this;
        }

        public Criteria andChannelUnidIsNotNull() {
            addCriterion("`traffic`.channel_unid is not null");
            return (Criteria) this;
        }

        public Criteria andChannelUnidEqualTo(String value) {
            addCriterion("`traffic`.channel_unid =", value, "channelUnid");
            return (Criteria) this;
        }

        public Criteria andChannelUnidNotEqualTo(String value) {
            addCriterion("`traffic`.channel_unid <>", value, "channelUnid");
            return (Criteria) this;
        }

        public Criteria andChannelUnidGreaterThan(String value) {
            addCriterion("`traffic`.channel_unid >", value, "channelUnid");
            return (Criteria) this;
        }

        public Criteria andChannelUnidGreaterThanOrEqualTo(String value) {
            addCriterion("`traffic`.channel_unid >=", value, "channelUnid");
            return (Criteria) this;
        }

        public Criteria andChannelUnidLessThan(String value) {
            addCriterion("`traffic`.channel_unid <", value, "channelUnid");
            return (Criteria) this;
        }

        public Criteria andChannelUnidLessThanOrEqualTo(String value) {
            addCriterion("`traffic`.channel_unid <=", value, "channelUnid");
            return (Criteria) this;
        }

        public Criteria andChannelUnidLike(String value) {
            addCriterion("`traffic`.channel_unid like", value, "channelUnid");
            return (Criteria) this;
        }

        public Criteria andChannelUnidNotLike(String value) {
            addCriterion("`traffic`.channel_unid not like", value, "channelUnid");
            return (Criteria) this;
        }

        public Criteria andChannelUnidIn(List<String> values) {
            addCriterion("`traffic`.channel_unid in", values, "channelUnid");
            return (Criteria) this;
        }

        public Criteria andChannelUnidNotIn(List<String> values) {
            addCriterion("`traffic`.channel_unid not in", values, "channelUnid");
            return (Criteria) this;
        }

        public Criteria andChannelUnidBetween(String value1, String value2) {
            addCriterion("`traffic`.channel_unid between", value1, value2, "channelUnid");
            return (Criteria) this;
        }

        public Criteria andChannelUnidNotBetween(String value1, String value2) {
            addCriterion("`traffic`.channel_unid not between", value1, value2, "channelUnid");
            return (Criteria) this;
        }

        public Criteria andPlateColorIsNull() {
            addCriterion("`traffic`.plate_color is null");
            return (Criteria) this;
        }

        public Criteria andPlateColorIsNotNull() {
            addCriterion("`traffic`.plate_color is not null");
            return (Criteria) this;
        }

        public Criteria andPlateColorEqualTo(String value) {
            addCriterion("`traffic`.plate_color =", value, "plateColor");
            return (Criteria) this;
        }

        public Criteria andPlateColorNotEqualTo(String value) {
            addCriterion("`traffic`.plate_color <>", value, "plateColor");
            return (Criteria) this;
        }

        public Criteria andPlateColorGreaterThan(String value) {
            addCriterion("`traffic`.plate_color >", value, "plateColor");
            return (Criteria) this;
        }

        public Criteria andPlateColorGreaterThanOrEqualTo(String value) {
            addCriterion("`traffic`.plate_color >=", value, "plateColor");
            return (Criteria) this;
        }

        public Criteria andPlateColorLessThan(String value) {
            addCriterion("`traffic`.plate_color <", value, "plateColor");
            return (Criteria) this;
        }

        public Criteria andPlateColorLessThanOrEqualTo(String value) {
            addCriterion("`traffic`.plate_color <=", value, "plateColor");
            return (Criteria) this;
        }

        public Criteria andPlateColorLike(String value) {
            addCriterion("`traffic`.plate_color like", value, "plateColor");
            return (Criteria) this;
        }

        public Criteria andPlateColorNotLike(String value) {
            addCriterion("`traffic`.plate_color not like", value, "plateColor");
            return (Criteria) this;
        }

        public Criteria andPlateColorIn(List<String> values) {
            addCriterion("`traffic`.plate_color in", values, "plateColor");
            return (Criteria) this;
        }

        public Criteria andPlateColorNotIn(List<String> values) {
            addCriterion("`traffic`.plate_color not in", values, "plateColor");
            return (Criteria) this;
        }

        public Criteria andPlateColorBetween(String value1, String value2) {
            addCriterion("`traffic`.plate_color between", value1, value2, "plateColor");
            return (Criteria) this;
        }

        public Criteria andPlateColorNotBetween(String value1, String value2) {
            addCriterion("`traffic`.plate_color not between", value1, value2, "plateColor");
            return (Criteria) this;
        }

        public Criteria andPlateNumberIsNull() {
            addCriterion("`traffic`.plate_number is null");
            return (Criteria) this;
        }

        public Criteria andPlateNumberIsNotNull() {
            addCriterion("`traffic`.plate_number is not null");
            return (Criteria) this;
        }

        public Criteria andPlateNumberEqualTo(String value) {
            addCriterion("`traffic`.plate_number =", value, "plateNumber");
            return (Criteria) this;
        }

        public Criteria andPlateNumberNotEqualTo(String value) {
            addCriterion("`traffic`.plate_number <>", value, "plateNumber");
            return (Criteria) this;
        }

        public Criteria andPlateNumberGreaterThan(String value) {
            addCriterion("`traffic`.plate_number >", value, "plateNumber");
            return (Criteria) this;
        }

        public Criteria andPlateNumberGreaterThanOrEqualTo(String value) {
            addCriterion("`traffic`.plate_number >=", value, "plateNumber");
            return (Criteria) this;
        }

        public Criteria andPlateNumberLessThan(String value) {
            addCriterion("`traffic`.plate_number <", value, "plateNumber");
            return (Criteria) this;
        }

        public Criteria andPlateNumberLessThanOrEqualTo(String value) {
            addCriterion("`traffic`.plate_number <=", value, "plateNumber");
            return (Criteria) this;
        }

        public Criteria andPlateNumberLike(String value) {
            addCriterion("`traffic`.plate_number like", value, "plateNumber");
            return (Criteria) this;
        }

        public Criteria andPlateNumberNotLike(String value) {
            addCriterion("`traffic`.plate_number not like", value, "plateNumber");
            return (Criteria) this;
        }

        public Criteria andPlateNumberIn(List<String> values) {
            addCriterion("`traffic`.plate_number in", values, "plateNumber");
            return (Criteria) this;
        }

        public Criteria andPlateNumberNotIn(List<String> values) {
            addCriterion("`traffic`.plate_number not in", values, "plateNumber");
            return (Criteria) this;
        }

        public Criteria andPlateNumberBetween(String value1, String value2) {
            addCriterion("`traffic`.plate_number between", value1, value2, "plateNumber");
            return (Criteria) this;
        }

        public Criteria andPlateNumberNotBetween(String value1, String value2) {
            addCriterion("`traffic`.plate_number not between", value1, value2, "plateNumber");
            return (Criteria) this;
        }

        public Criteria andLocationCodeIsNull() {
            addCriterion("`traffic`.location_code is null");
            return (Criteria) this;
        }

        public Criteria andLocationCodeIsNotNull() {
            addCriterion("`traffic`.location_code is not null");
            return (Criteria) this;
        }

        public Criteria andLocationCodeEqualTo(String value) {
            addCriterion("`traffic`.location_code =", value, "locationCode");
            return (Criteria) this;
        }

        public Criteria andLocationCodeNotEqualTo(String value) {
            addCriterion("`traffic`.location_code <>", value, "locationCode");
            return (Criteria) this;
        }

        public Criteria andLocationCodeGreaterThan(String value) {
            addCriterion("`traffic`.location_code >", value, "locationCode");
            return (Criteria) this;
        }

        public Criteria andLocationCodeGreaterThanOrEqualTo(String value) {
            addCriterion("`traffic`.location_code >=", value, "locationCode");
            return (Criteria) this;
        }

        public Criteria andLocationCodeLessThan(String value) {
            addCriterion("`traffic`.location_code <", value, "locationCode");
            return (Criteria) this;
        }

        public Criteria andLocationCodeLessThanOrEqualTo(String value) {
            addCriterion("`traffic`.location_code <=", value, "locationCode");
            return (Criteria) this;
        }

        public Criteria andLocationCodeLike(String value) {
            addCriterion("`traffic`.location_code like", value, "locationCode");
            return (Criteria) this;
        }

        public Criteria andLocationCodeNotLike(String value) {
            addCriterion("`traffic`.location_code not like", value, "locationCode");
            return (Criteria) this;
        }

        public Criteria andLocationCodeIn(List<String> values) {
            addCriterion("`traffic`.location_code in", values, "locationCode");
            return (Criteria) this;
        }

        public Criteria andLocationCodeNotIn(List<String> values) {
            addCriterion("`traffic`.location_code not in", values, "locationCode");
            return (Criteria) this;
        }

        public Criteria andLocationCodeBetween(String value1, String value2) {
            addCriterion("`traffic`.location_code between", value1, value2, "locationCode");
            return (Criteria) this;
        }

        public Criteria andLocationCodeNotBetween(String value1, String value2) {
            addCriterion("`traffic`.location_code not between", value1, value2, "locationCode");
            return (Criteria) this;
        }

        public Criteria andLocationNameIsNull() {
            addCriterion("`traffic`.location_name is null");
            return (Criteria) this;
        }

        public Criteria andLocationNameIsNotNull() {
            addCriterion("`traffic`.location_name is not null");
            return (Criteria) this;
        }

        public Criteria andLocationNameEqualTo(String value) {
            addCriterion("`traffic`.location_name =", value, "locationName");
            return (Criteria) this;
        }

        public Criteria andLocationNameNotEqualTo(String value) {
            addCriterion("`traffic`.location_name <>", value, "locationName");
            return (Criteria) this;
        }

        public Criteria andLocationNameGreaterThan(String value) {
            addCriterion("`traffic`.location_name >", value, "locationName");
            return (Criteria) this;
        }

        public Criteria andLocationNameGreaterThanOrEqualTo(String value) {
            addCriterion("`traffic`.location_name >=", value, "locationName");
            return (Criteria) this;
        }

        public Criteria andLocationNameLessThan(String value) {
            addCriterion("`traffic`.location_name <", value, "locationName");
            return (Criteria) this;
        }

        public Criteria andLocationNameLessThanOrEqualTo(String value) {
            addCriterion("`traffic`.location_name <=", value, "locationName");
            return (Criteria) this;
        }

        public Criteria andLocationNameLike(String value) {
            addCriterion("`traffic`.location_name like", value, "locationName");
            return (Criteria) this;
        }

        public Criteria andLocationNameNotLike(String value) {
            addCriterion("`traffic`.location_name not like", value, "locationName");
            return (Criteria) this;
        }

        public Criteria andLocationNameIn(List<String> values) {
            addCriterion("`traffic`.location_name in", values, "locationName");
            return (Criteria) this;
        }

        public Criteria andLocationNameNotIn(List<String> values) {
            addCriterion("`traffic`.location_name not in", values, "locationName");
            return (Criteria) this;
        }

        public Criteria andLocationNameBetween(String value1, String value2) {
            addCriterion("`traffic`.location_name between", value1, value2, "locationName");
            return (Criteria) this;
        }

        public Criteria andLocationNameNotBetween(String value1, String value2) {
            addCriterion("`traffic`.location_name not between", value1, value2, "locationName");
            return (Criteria) this;
        }

        public Criteria andLaneCodeIsNull() {
            addCriterion("`traffic`.lane_code is null");
            return (Criteria) this;
        }

        public Criteria andLaneCodeIsNotNull() {
            addCriterion("`traffic`.lane_code is not null");
            return (Criteria) this;
        }

        public Criteria andLaneCodeEqualTo(String value) {
            addCriterion("`traffic`.lane_code =", value, "laneCode");
            return (Criteria) this;
        }

        public Criteria andLaneCodeNotEqualTo(String value) {
            addCriterion("`traffic`.lane_code <>", value, "laneCode");
            return (Criteria) this;
        }

        public Criteria andLaneCodeGreaterThan(String value) {
            addCriterion("`traffic`.lane_code >", value, "laneCode");
            return (Criteria) this;
        }

        public Criteria andLaneCodeGreaterThanOrEqualTo(String value) {
            addCriterion("`traffic`.lane_code >=", value, "laneCode");
            return (Criteria) this;
        }

        public Criteria andLaneCodeLessThan(String value) {
            addCriterion("`traffic`.lane_code <", value, "laneCode");
            return (Criteria) this;
        }

        public Criteria andLaneCodeLessThanOrEqualTo(String value) {
            addCriterion("`traffic`.lane_code <=", value, "laneCode");
            return (Criteria) this;
        }

        public Criteria andLaneCodeLike(String value) {
            addCriterion("`traffic`.lane_code like", value, "laneCode");
            return (Criteria) this;
        }

        public Criteria andLaneCodeNotLike(String value) {
            addCriterion("`traffic`.lane_code not like", value, "laneCode");
            return (Criteria) this;
        }

        public Criteria andLaneCodeIn(List<String> values) {
            addCriterion("`traffic`.lane_code in", values, "laneCode");
            return (Criteria) this;
        }

        public Criteria andLaneCodeNotIn(List<String> values) {
            addCriterion("`traffic`.lane_code not in", values, "laneCode");
            return (Criteria) this;
        }

        public Criteria andLaneCodeBetween(String value1, String value2) {
            addCriterion("`traffic`.lane_code between", value1, value2, "laneCode");
            return (Criteria) this;
        }

        public Criteria andLaneCodeNotBetween(String value1, String value2) {
            addCriterion("`traffic`.lane_code not between", value1, value2, "laneCode");
            return (Criteria) this;
        }

        public Criteria andDirectionCodeIsNull() {
            addCriterion("`traffic`.direction_code is null");
            return (Criteria) this;
        }

        public Criteria andDirectionCodeIsNotNull() {
            addCriterion("`traffic`.direction_code is not null");
            return (Criteria) this;
        }

        public Criteria andDirectionCodeEqualTo(String value) {
            addCriterion("`traffic`.direction_code =", value, "directionCode");
            return (Criteria) this;
        }

        public Criteria andDirectionCodeNotEqualTo(String value) {
            addCriterion("`traffic`.direction_code <>", value, "directionCode");
            return (Criteria) this;
        }

        public Criteria andDirectionCodeGreaterThan(String value) {
            addCriterion("`traffic`.direction_code >", value, "directionCode");
            return (Criteria) this;
        }

        public Criteria andDirectionCodeGreaterThanOrEqualTo(String value) {
            addCriterion("`traffic`.direction_code >=", value, "directionCode");
            return (Criteria) this;
        }

        public Criteria andDirectionCodeLessThan(String value) {
            addCriterion("`traffic`.direction_code <", value, "directionCode");
            return (Criteria) this;
        }

        public Criteria andDirectionCodeLessThanOrEqualTo(String value) {
            addCriterion("`traffic`.direction_code <=", value, "directionCode");
            return (Criteria) this;
        }

        public Criteria andDirectionCodeLike(String value) {
            addCriterion("`traffic`.direction_code like", value, "directionCode");
            return (Criteria) this;
        }

        public Criteria andDirectionCodeNotLike(String value) {
            addCriterion("`traffic`.direction_code not like", value, "directionCode");
            return (Criteria) this;
        }

        public Criteria andDirectionCodeIn(List<String> values) {
            addCriterion("`traffic`.direction_code in", values, "directionCode");
            return (Criteria) this;
        }

        public Criteria andDirectionCodeNotIn(List<String> values) {
            addCriterion("`traffic`.direction_code not in", values, "directionCode");
            return (Criteria) this;
        }

        public Criteria andDirectionCodeBetween(String value1, String value2) {
            addCriterion("`traffic`.direction_code between", value1, value2, "directionCode");
            return (Criteria) this;
        }

        public Criteria andDirectionCodeNotBetween(String value1, String value2) {
            addCriterion("`traffic`.direction_code not between", value1, value2, "directionCode");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeIsNull() {
            addCriterion("`traffic`.vehicle_type is null");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeIsNotNull() {
            addCriterion("`traffic`.vehicle_type is not null");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeEqualTo(String value) {
            addCriterion("`traffic`.vehicle_type =", value, "vehicleType");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeNotEqualTo(String value) {
            addCriterion("`traffic`.vehicle_type <>", value, "vehicleType");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeGreaterThan(String value) {
            addCriterion("`traffic`.vehicle_type >", value, "vehicleType");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeGreaterThanOrEqualTo(String value) {
            addCriterion("`traffic`.vehicle_type >=", value, "vehicleType");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeLessThan(String value) {
            addCriterion("`traffic`.vehicle_type <", value, "vehicleType");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeLessThanOrEqualTo(String value) {
            addCriterion("`traffic`.vehicle_type <=", value, "vehicleType");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeLike(String value) {
            addCriterion("`traffic`.vehicle_type like", value, "vehicleType");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeNotLike(String value) {
            addCriterion("`traffic`.vehicle_type not like", value, "vehicleType");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeIn(List<String> values) {
            addCriterion("`traffic`.vehicle_type in", values, "vehicleType");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeNotIn(List<String> values) {
            addCriterion("`traffic`.vehicle_type not in", values, "vehicleType");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeBetween(String value1, String value2) {
            addCriterion("`traffic`.vehicle_type between", value1, value2, "vehicleType");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeNotBetween(String value1, String value2) {
            addCriterion("`traffic`.vehicle_type not between", value1, value2, "vehicleType");
            return (Criteria) this;
        }

        public Criteria andVehicleColorIsNull() {
            addCriterion("`traffic`.vehicle_color is null");
            return (Criteria) this;
        }

        public Criteria andVehicleColorIsNotNull() {
            addCriterion("`traffic`.vehicle_color is not null");
            return (Criteria) this;
        }

        public Criteria andVehicleColorEqualTo(String value) {
            addCriterion("`traffic`.vehicle_color =", value, "vehicleColor");
            return (Criteria) this;
        }

        public Criteria andVehicleColorNotEqualTo(String value) {
            addCriterion("`traffic`.vehicle_color <>", value, "vehicleColor");
            return (Criteria) this;
        }

        public Criteria andVehicleColorGreaterThan(String value) {
            addCriterion("`traffic`.vehicle_color >", value, "vehicleColor");
            return (Criteria) this;
        }

        public Criteria andVehicleColorGreaterThanOrEqualTo(String value) {
            addCriterion("`traffic`.vehicle_color >=", value, "vehicleColor");
            return (Criteria) this;
        }

        public Criteria andVehicleColorLessThan(String value) {
            addCriterion("`traffic`.vehicle_color <", value, "vehicleColor");
            return (Criteria) this;
        }

        public Criteria andVehicleColorLessThanOrEqualTo(String value) {
            addCriterion("`traffic`.vehicle_color <=", value, "vehicleColor");
            return (Criteria) this;
        }

        public Criteria andVehicleColorLike(String value) {
            addCriterion("`traffic`.vehicle_color like", value, "vehicleColor");
            return (Criteria) this;
        }

        public Criteria andVehicleColorNotLike(String value) {
            addCriterion("`traffic`.vehicle_color not like", value, "vehicleColor");
            return (Criteria) this;
        }

        public Criteria andVehicleColorIn(List<String> values) {
            addCriterion("`traffic`.vehicle_color in", values, "vehicleColor");
            return (Criteria) this;
        }

        public Criteria andVehicleColorNotIn(List<String> values) {
            addCriterion("`traffic`.vehicle_color not in", values, "vehicleColor");
            return (Criteria) this;
        }

        public Criteria andVehicleColorBetween(String value1, String value2) {
            addCriterion("`traffic`.vehicle_color between", value1, value2, "vehicleColor");
            return (Criteria) this;
        }

        public Criteria andVehicleColorNotBetween(String value1, String value2) {
            addCriterion("`traffic`.vehicle_color not between", value1, value2, "vehicleColor");
            return (Criteria) this;
        }

        public Criteria andVehicleLogoIsNull() {
            addCriterion("`traffic`.vehicle_logo is null");
            return (Criteria) this;
        }

        public Criteria andVehicleLogoIsNotNull() {
            addCriterion("`traffic`.vehicle_logo is not null");
            return (Criteria) this;
        }

        public Criteria andVehicleLogoEqualTo(String value) {
            addCriterion("`traffic`.vehicle_logo =", value, "vehicleLogo");
            return (Criteria) this;
        }

        public Criteria andVehicleLogoNotEqualTo(String value) {
            addCriterion("`traffic`.vehicle_logo <>", value, "vehicleLogo");
            return (Criteria) this;
        }

        public Criteria andVehicleLogoGreaterThan(String value) {
            addCriterion("`traffic`.vehicle_logo >", value, "vehicleLogo");
            return (Criteria) this;
        }

        public Criteria andVehicleLogoGreaterThanOrEqualTo(String value) {
            addCriterion("`traffic`.vehicle_logo >=", value, "vehicleLogo");
            return (Criteria) this;
        }

        public Criteria andVehicleLogoLessThan(String value) {
            addCriterion("`traffic`.vehicle_logo <", value, "vehicleLogo");
            return (Criteria) this;
        }

        public Criteria andVehicleLogoLessThanOrEqualTo(String value) {
            addCriterion("`traffic`.vehicle_logo <=", value, "vehicleLogo");
            return (Criteria) this;
        }

        public Criteria andVehicleLogoLike(String value) {
            addCriterion("`traffic`.vehicle_logo like", value, "vehicleLogo");
            return (Criteria) this;
        }

        public Criteria andVehicleLogoNotLike(String value) {
            addCriterion("`traffic`.vehicle_logo not like", value, "vehicleLogo");
            return (Criteria) this;
        }

        public Criteria andVehicleLogoIn(List<String> values) {
            addCriterion("`traffic`.vehicle_logo in", values, "vehicleLogo");
            return (Criteria) this;
        }

        public Criteria andVehicleLogoNotIn(List<String> values) {
            addCriterion("`traffic`.vehicle_logo not in", values, "vehicleLogo");
            return (Criteria) this;
        }

        public Criteria andVehicleLogoBetween(String value1, String value2) {
            addCriterion("`traffic`.vehicle_logo between", value1, value2, "vehicleLogo");
            return (Criteria) this;
        }

        public Criteria andVehicleLogoNotBetween(String value1, String value2) {
            addCriterion("`traffic`.vehicle_logo not between", value1, value2, "vehicleLogo");
            return (Criteria) this;
        }

        public Criteria andIllegalCodeIsNull() {
            addCriterion("`traffic`.illegal_code is null");
            return (Criteria) this;
        }

        public Criteria andIllegalCodeIsNotNull() {
            addCriterion("`traffic`.illegal_code is not null");
            return (Criteria) this;
        }

        public Criteria andIllegalCodeEqualTo(String value) {
            addCriterion("`traffic`.illegal_code =", value, "illegalCode");
            return (Criteria) this;
        }

        public Criteria andIllegalCodeNotEqualTo(String value) {
            addCriterion("`traffic`.illegal_code <>", value, "illegalCode");
            return (Criteria) this;
        }

        public Criteria andIllegalCodeGreaterThan(String value) {
            addCriterion("`traffic`.illegal_code >", value, "illegalCode");
            return (Criteria) this;
        }

        public Criteria andIllegalCodeGreaterThanOrEqualTo(String value) {
            addCriterion("`traffic`.illegal_code >=", value, "illegalCode");
            return (Criteria) this;
        }

        public Criteria andIllegalCodeLessThan(String value) {
            addCriterion("`traffic`.illegal_code <", value, "illegalCode");
            return (Criteria) this;
        }

        public Criteria andIllegalCodeLessThanOrEqualTo(String value) {
            addCriterion("`traffic`.illegal_code <=", value, "illegalCode");
            return (Criteria) this;
        }

        public Criteria andIllegalCodeLike(String value) {
            addCriterion("`traffic`.illegal_code like", value, "illegalCode");
            return (Criteria) this;
        }

        public Criteria andIllegalCodeNotLike(String value) {
            addCriterion("`traffic`.illegal_code not like", value, "illegalCode");
            return (Criteria) this;
        }

        public Criteria andIllegalCodeIn(List<String> values) {
            addCriterion("`traffic`.illegal_code in", values, "illegalCode");
            return (Criteria) this;
        }

        public Criteria andIllegalCodeNotIn(List<String> values) {
            addCriterion("`traffic`.illegal_code not in", values, "illegalCode");
            return (Criteria) this;
        }

        public Criteria andIllegalCodeBetween(String value1, String value2) {
            addCriterion("`traffic`.illegal_code between", value1, value2, "illegalCode");
            return (Criteria) this;
        }

        public Criteria andIllegalCodeNotBetween(String value1, String value2) {
            addCriterion("`traffic`.illegal_code not between", value1, value2, "illegalCode");
            return (Criteria) this;
        }

        public Criteria andIllegalStateIsNull() {
            addCriterion("`traffic`.illegal_state is null");
            return (Criteria) this;
        }

        public Criteria andIllegalStateIsNotNull() {
            addCriterion("`traffic`.illegal_state is not null");
            return (Criteria) this;
        }

        public Criteria andIllegalStateEqualTo(Integer value) {
            addCriterion("`traffic`.illegal_state =", value, "illegalState");
            return (Criteria) this;
        }

        public Criteria andIllegalStateNotEqualTo(Integer value) {
            addCriterion("`traffic`.illegal_state <>", value, "illegalState");
            return (Criteria) this;
        }

        public Criteria andIllegalStateGreaterThan(Integer value) {
            addCriterion("`traffic`.illegal_state >", value, "illegalState");
            return (Criteria) this;
        }

        public Criteria andIllegalStateGreaterThanOrEqualTo(Integer value) {
            addCriterion("`traffic`.illegal_state >=", value, "illegalState");
            return (Criteria) this;
        }

        public Criteria andIllegalStateLessThan(Integer value) {
            addCriterion("`traffic`.illegal_state <", value, "illegalState");
            return (Criteria) this;
        }

        public Criteria andIllegalStateLessThanOrEqualTo(Integer value) {
            addCriterion("`traffic`.illegal_state <=", value, "illegalState");
            return (Criteria) this;
        }

        public Criteria andIllegalStateIn(List<Integer> values) {
            addCriterion("`traffic`.illegal_state in", values, "illegalState");
            return (Criteria) this;
        }

        public Criteria andIllegalStateNotIn(List<Integer> values) {
            addCriterion("`traffic`.illegal_state not in", values, "illegalState");
            return (Criteria) this;
        }

        public Criteria andIllegalStateBetween(Integer value1, Integer value2) {
            addCriterion("`traffic`.illegal_state between", value1, value2, "illegalState");
            return (Criteria) this;
        }

        public Criteria andIllegalStateNotBetween(Integer value1, Integer value2) {
            addCriterion("`traffic`.illegal_state not between", value1, value2, "illegalState");
            return (Criteria) this;
        }

        public Criteria andFeatureAnnualInspectionMarkIsNull() {
            addCriterion("`traffic`.feature_annual_inspection_mark is null");
            return (Criteria) this;
        }

        public Criteria andFeatureAnnualInspectionMarkIsNotNull() {
            addCriterion("`traffic`.feature_annual_inspection_mark is not null");
            return (Criteria) this;
        }

        public Criteria andFeatureAnnualInspectionMarkEqualTo(Short value) {
            addCriterion("`traffic`.feature_annual_inspection_mark =", value, "featureAnnualInspectionMark");
            return (Criteria) this;
        }

        public Criteria andFeatureAnnualInspectionMarkNotEqualTo(Short value) {
            addCriterion("`traffic`.feature_annual_inspection_mark <>", value, "featureAnnualInspectionMark");
            return (Criteria) this;
        }

        public Criteria andFeatureAnnualInspectionMarkGreaterThan(Short value) {
            addCriterion("`traffic`.feature_annual_inspection_mark >", value, "featureAnnualInspectionMark");
            return (Criteria) this;
        }

        public Criteria andFeatureAnnualInspectionMarkGreaterThanOrEqualTo(Short value) {
            addCriterion("`traffic`.feature_annual_inspection_mark >=", value, "featureAnnualInspectionMark");
            return (Criteria) this;
        }

        public Criteria andFeatureAnnualInspectionMarkLessThan(Short value) {
            addCriterion("`traffic`.feature_annual_inspection_mark <", value, "featureAnnualInspectionMark");
            return (Criteria) this;
        }

        public Criteria andFeatureAnnualInspectionMarkLessThanOrEqualTo(Short value) {
            addCriterion("`traffic`.feature_annual_inspection_mark <=", value, "featureAnnualInspectionMark");
            return (Criteria) this;
        }

        public Criteria andFeatureAnnualInspectionMarkIn(List<Short> values) {
            addCriterion("`traffic`.feature_annual_inspection_mark in", values, "featureAnnualInspectionMark");
            return (Criteria) this;
        }

        public Criteria andFeatureAnnualInspectionMarkNotIn(List<Short> values) {
            addCriterion("`traffic`.feature_annual_inspection_mark not in", values, "featureAnnualInspectionMark");
            return (Criteria) this;
        }

        public Criteria andFeatureAnnualInspectionMarkBetween(Short value1, Short value2) {
            addCriterion("`traffic`.feature_annual_inspection_mark between", value1, value2, "featureAnnualInspectionMark");
            return (Criteria) this;
        }

        public Criteria andFeatureAnnualInspectionMarkNotBetween(Short value1, Short value2) {
            addCriterion("`traffic`.feature_annual_inspection_mark not between", value1, value2, "featureAnnualInspectionMark");
            return (Criteria) this;
        }

        public Criteria andFeaturePendantIsNull() {
            addCriterion("`traffic`.feature_pendant is null");
            return (Criteria) this;
        }

        public Criteria andFeaturePendantIsNotNull() {
            addCriterion("`traffic`.feature_pendant is not null");
            return (Criteria) this;
        }

        public Criteria andFeaturePendantEqualTo(Short value) {
            addCriterion("`traffic`.feature_pendant =", value, "featurePendant");
            return (Criteria) this;
        }

        public Criteria andFeaturePendantNotEqualTo(Short value) {
            addCriterion("`traffic`.feature_pendant <>", value, "featurePendant");
            return (Criteria) this;
        }

        public Criteria andFeaturePendantGreaterThan(Short value) {
            addCriterion("`traffic`.feature_pendant >", value, "featurePendant");
            return (Criteria) this;
        }

        public Criteria andFeaturePendantGreaterThanOrEqualTo(Short value) {
            addCriterion("`traffic`.feature_pendant >=", value, "featurePendant");
            return (Criteria) this;
        }

        public Criteria andFeaturePendantLessThan(Short value) {
            addCriterion("`traffic`.feature_pendant <", value, "featurePendant");
            return (Criteria) this;
        }

        public Criteria andFeaturePendantLessThanOrEqualTo(Short value) {
            addCriterion("`traffic`.feature_pendant <=", value, "featurePendant");
            return (Criteria) this;
        }

        public Criteria andFeaturePendantIn(List<Short> values) {
            addCriterion("`traffic`.feature_pendant in", values, "featurePendant");
            return (Criteria) this;
        }

        public Criteria andFeaturePendantNotIn(List<Short> values) {
            addCriterion("`traffic`.feature_pendant not in", values, "featurePendant");
            return (Criteria) this;
        }

        public Criteria andFeaturePendantBetween(Short value1, Short value2) {
            addCriterion("`traffic`.feature_pendant between", value1, value2, "featurePendant");
            return (Criteria) this;
        }

        public Criteria andFeaturePendantNotBetween(Short value1, Short value2) {
            addCriterion("`traffic`.feature_pendant not between", value1, value2, "featurePendant");
            return (Criteria) this;
        }

        public Criteria andFeatureDecorationIsNull() {
            addCriterion("`traffic`.feature_decoration is null");
            return (Criteria) this;
        }

        public Criteria andFeatureDecorationIsNotNull() {
            addCriterion("`traffic`.feature_decoration is not null");
            return (Criteria) this;
        }

        public Criteria andFeatureDecorationEqualTo(Short value) {
            addCriterion("`traffic`.feature_decoration =", value, "featureDecoration");
            return (Criteria) this;
        }

        public Criteria andFeatureDecorationNotEqualTo(Short value) {
            addCriterion("`traffic`.feature_decoration <>", value, "featureDecoration");
            return (Criteria) this;
        }

        public Criteria andFeatureDecorationGreaterThan(Short value) {
            addCriterion("`traffic`.feature_decoration >", value, "featureDecoration");
            return (Criteria) this;
        }

        public Criteria andFeatureDecorationGreaterThanOrEqualTo(Short value) {
            addCriterion("`traffic`.feature_decoration >=", value, "featureDecoration");
            return (Criteria) this;
        }

        public Criteria andFeatureDecorationLessThan(Short value) {
            addCriterion("`traffic`.feature_decoration <", value, "featureDecoration");
            return (Criteria) this;
        }

        public Criteria andFeatureDecorationLessThanOrEqualTo(Short value) {
            addCriterion("`traffic`.feature_decoration <=", value, "featureDecoration");
            return (Criteria) this;
        }

        public Criteria andFeatureDecorationIn(List<Short> values) {
            addCriterion("`traffic`.feature_decoration in", values, "featureDecoration");
            return (Criteria) this;
        }

        public Criteria andFeatureDecorationNotIn(List<Short> values) {
            addCriterion("`traffic`.feature_decoration not in", values, "featureDecoration");
            return (Criteria) this;
        }

        public Criteria andFeatureDecorationBetween(Short value1, Short value2) {
            addCriterion("`traffic`.feature_decoration between", value1, value2, "featureDecoration");
            return (Criteria) this;
        }

        public Criteria andFeatureDecorationNotBetween(Short value1, Short value2) {
            addCriterion("`traffic`.feature_decoration not between", value1, value2, "featureDecoration");
            return (Criteria) this;
        }

        public Criteria andFeatureSunShieldIsNull() {
            addCriterion("`traffic`.feature_sun_shield is null");
            return (Criteria) this;
        }

        public Criteria andFeatureSunShieldIsNotNull() {
            addCriterion("`traffic`.feature_sun_shield is not null");
            return (Criteria) this;
        }

        public Criteria andFeatureSunShieldEqualTo(Short value) {
            addCriterion("`traffic`.feature_sun_shield =", value, "featureSunShield");
            return (Criteria) this;
        }

        public Criteria andFeatureSunShieldNotEqualTo(Short value) {
            addCriterion("`traffic`.feature_sun_shield <>", value, "featureSunShield");
            return (Criteria) this;
        }

        public Criteria andFeatureSunShieldGreaterThan(Short value) {
            addCriterion("`traffic`.feature_sun_shield >", value, "featureSunShield");
            return (Criteria) this;
        }

        public Criteria andFeatureSunShieldGreaterThanOrEqualTo(Short value) {
            addCriterion("`traffic`.feature_sun_shield >=", value, "featureSunShield");
            return (Criteria) this;
        }

        public Criteria andFeatureSunShieldLessThan(Short value) {
            addCriterion("`traffic`.feature_sun_shield <", value, "featureSunShield");
            return (Criteria) this;
        }

        public Criteria andFeatureSunShieldLessThanOrEqualTo(Short value) {
            addCriterion("`traffic`.feature_sun_shield <=", value, "featureSunShield");
            return (Criteria) this;
        }

        public Criteria andFeatureSunShieldIn(List<Short> values) {
            addCriterion("`traffic`.feature_sun_shield in", values, "featureSunShield");
            return (Criteria) this;
        }

        public Criteria andFeatureSunShieldNotIn(List<Short> values) {
            addCriterion("`traffic`.feature_sun_shield not in", values, "featureSunShield");
            return (Criteria) this;
        }

        public Criteria andFeatureSunShieldBetween(Short value1, Short value2) {
            addCriterion("`traffic`.feature_sun_shield between", value1, value2, "featureSunShield");
            return (Criteria) this;
        }

        public Criteria andFeatureSunShieldNotBetween(Short value1, Short value2) {
            addCriterion("`traffic`.feature_sun_shield not between", value1, value2, "featureSunShield");
            return (Criteria) this;
        }

        public Criteria andXcycleTypeIsNull() {
            addCriterion("`traffic`.xcycle_type is null");
            return (Criteria) this;
        }

        public Criteria andXcycleTypeIsNotNull() {
            addCriterion("`traffic`.xcycle_type is not null");
            return (Criteria) this;
        }

        public Criteria andXcycleTypeEqualTo(String value) {
            addCriterion("`traffic`.xcycle_type =", value, "xcycleType");
            return (Criteria) this;
        }

        public Criteria andXcycleTypeNotEqualTo(String value) {
            addCriterion("`traffic`.xcycle_type <>", value, "xcycleType");
            return (Criteria) this;
        }

        public Criteria andXcycleTypeGreaterThan(String value) {
            addCriterion("`traffic`.xcycle_type >", value, "xcycleType");
            return (Criteria) this;
        }

        public Criteria andXcycleTypeGreaterThanOrEqualTo(String value) {
            addCriterion("`traffic`.xcycle_type >=", value, "xcycleType");
            return (Criteria) this;
        }

        public Criteria andXcycleTypeLessThan(String value) {
            addCriterion("`traffic`.xcycle_type <", value, "xcycleType");
            return (Criteria) this;
        }

        public Criteria andXcycleTypeLessThanOrEqualTo(String value) {
            addCriterion("`traffic`.xcycle_type <=", value, "xcycleType");
            return (Criteria) this;
        }

        public Criteria andXcycleTypeLike(String value) {
            addCriterion("`traffic`.xcycle_type like", value, "xcycleType");
            return (Criteria) this;
        }

        public Criteria andXcycleTypeNotLike(String value) {
            addCriterion("`traffic`.xcycle_type not like", value, "xcycleType");
            return (Criteria) this;
        }

        public Criteria andXcycleTypeIn(List<String> values) {
            addCriterion("`traffic`.xcycle_type in", values, "xcycleType");
            return (Criteria) this;
        }

        public Criteria andXcycleTypeNotIn(List<String> values) {
            addCriterion("`traffic`.xcycle_type not in", values, "xcycleType");
            return (Criteria) this;
        }

        public Criteria andXcycleTypeBetween(String value1, String value2) {
            addCriterion("`traffic`.xcycle_type between", value1, value2, "xcycleType");
            return (Criteria) this;
        }

        public Criteria andXcycleTypeNotBetween(String value1, String value2) {
            addCriterion("`traffic`.xcycle_type not between", value1, value2, "xcycleType");
            return (Criteria) this;
        }

        public Criteria andEventIdIsNull() {
            addCriterion("`traffic`.event_id is null");
            return (Criteria) this;
        }

        public Criteria andEventIdIsNotNull() {
            addCriterion("`traffic`.event_id is not null");
            return (Criteria) this;
        }

        public Criteria andEventIdEqualTo(String value) {
            addCriterion("`traffic`.event_id =", value, "eventId");
            return (Criteria) this;
        }

        public Criteria andEventIdNotEqualTo(String value) {
            addCriterion("`traffic`.event_id <>", value, "eventId");
            return (Criteria) this;
        }

        public Criteria andEventIdGreaterThan(String value) {
            addCriterion("`traffic`.event_id >", value, "eventId");
            return (Criteria) this;
        }

        public Criteria andEventIdGreaterThanOrEqualTo(String value) {
            addCriterion("`traffic`.event_id >=", value, "eventId");
            return (Criteria) this;
        }

        public Criteria andEventIdLessThan(String value) {
            addCriterion("`traffic`.event_id <", value, "eventId");
            return (Criteria) this;
        }

        public Criteria andEventIdLessThanOrEqualTo(String value) {
            addCriterion("`traffic`.event_id <=", value, "eventId");
            return (Criteria) this;
        }

        public Criteria andEventIdLike(String value) {
            addCriterion("`traffic`.event_id like", value, "eventId");
            return (Criteria) this;
        }

        public Criteria andEventIdNotLike(String value) {
            addCriterion("`traffic`.event_id not like", value, "eventId");
            return (Criteria) this;
        }

        public Criteria andEventIdIn(List<String> values) {
            addCriterion("`traffic`.event_id in", values, "eventId");
            return (Criteria) this;
        }

        public Criteria andEventIdNotIn(List<String> values) {
            addCriterion("`traffic`.event_id not in", values, "eventId");
            return (Criteria) this;
        }

        public Criteria andEventIdBetween(String value1, String value2) {
            addCriterion("`traffic`.event_id between", value1, value2, "eventId");
            return (Criteria) this;
        }

        public Criteria andEventIdNotBetween(String value1, String value2) {
            addCriterion("`traffic`.event_id not between", value1, value2, "eventId");
            return (Criteria) this;
        }

        public Criteria andSpecialTypeIsNull() {
            addCriterion("`traffic`.special_type is null");
            return (Criteria) this;
        }

        public Criteria andSpecialTypeIsNotNull() {
            addCriterion("`traffic`.special_type is not null");
            return (Criteria) this;
        }

        public Criteria andSpecialTypeEqualTo(String value) {
            addCriterion("`traffic`.special_type =", value, "specialType");
            return (Criteria) this;
        }

        public Criteria andSpecialTypeNotEqualTo(String value) {
            addCriterion("`traffic`.special_type <>", value, "specialType");
            return (Criteria) this;
        }

        public Criteria andSpecialTypeGreaterThan(String value) {
            addCriterion("`traffic`.special_type >", value, "specialType");
            return (Criteria) this;
        }

        public Criteria andSpecialTypeGreaterThanOrEqualTo(String value) {
            addCriterion("`traffic`.special_type >=", value, "specialType");
            return (Criteria) this;
        }

        public Criteria andSpecialTypeLessThan(String value) {
            addCriterion("`traffic`.special_type <", value, "specialType");
            return (Criteria) this;
        }

        public Criteria andSpecialTypeLessThanOrEqualTo(String value) {
            addCriterion("`traffic`.special_type <=", value, "specialType");
            return (Criteria) this;
        }

        public Criteria andSpecialTypeLike(String value) {
            addCriterion("`traffic`.special_type like", value, "specialType");
            return (Criteria) this;
        }

        public Criteria andSpecialTypeNotLike(String value) {
            addCriterion("`traffic`.special_type not like", value, "specialType");
            return (Criteria) this;
        }

        public Criteria andSpecialTypeIn(List<String> values) {
            addCriterion("`traffic`.special_type in", values, "specialType");
            return (Criteria) this;
        }

        public Criteria andSpecialTypeNotIn(List<String> values) {
            addCriterion("`traffic`.special_type not in", values, "specialType");
            return (Criteria) this;
        }

        public Criteria andSpecialTypeBetween(String value1, String value2) {
            addCriterion("`traffic`.special_type between", value1, value2, "specialType");
            return (Criteria) this;
        }

        public Criteria andSpecialTypeNotBetween(String value1, String value2) {
            addCriterion("`traffic`.special_type not between", value1, value2, "specialType");
            return (Criteria) this;
        }

        public Criteria andWithHelmetIsNull() {
            addCriterion("`traffic`.with_helmet is null");
            return (Criteria) this;
        }

        public Criteria andWithHelmetIsNotNull() {
            addCriterion("`traffic`.with_helmet is not null");
            return (Criteria) this;
        }

        public Criteria andWithHelmetEqualTo(Integer value) {
            addCriterion("`traffic`.with_helmet =", value, "withHelmet");
            return (Criteria) this;
        }

        public Criteria andWithHelmetNotEqualTo(Integer value) {
            addCriterion("`traffic`.with_helmet <>", value, "withHelmet");
            return (Criteria) this;
        }

        public Criteria andWithHelmetGreaterThan(Integer value) {
            addCriterion("`traffic`.with_helmet >", value, "withHelmet");
            return (Criteria) this;
        }

        public Criteria andWithHelmetGreaterThanOrEqualTo(Integer value) {
            addCriterion("`traffic`.with_helmet >=", value, "withHelmet");
            return (Criteria) this;
        }

        public Criteria andWithHelmetLessThan(Integer value) {
            addCriterion("`traffic`.with_helmet <", value, "withHelmet");
            return (Criteria) this;
        }

        public Criteria andWithHelmetLessThanOrEqualTo(Integer value) {
            addCriterion("`traffic`.with_helmet <=", value, "withHelmet");
            return (Criteria) this;
        }

        public Criteria andWithHelmetIn(List<Integer> values) {
            addCriterion("`traffic`.with_helmet in", values, "withHelmet");
            return (Criteria) this;
        }

        public Criteria andWithHelmetNotIn(List<Integer> values) {
            addCriterion("`traffic`.with_helmet not in", values, "withHelmet");
            return (Criteria) this;
        }

        public Criteria andWithHelmetBetween(Integer value1, Integer value2) {
            addCriterion("`traffic`.with_helmet between", value1, value2, "withHelmet");
            return (Criteria) this;
        }

        public Criteria andWithHelmetNotBetween(Integer value1, Integer value2) {
            addCriterion("`traffic`.with_helmet not between", value1, value2, "withHelmet");
            return (Criteria) this;
        }

        public Criteria andPicsIsNull() {
            addCriterion("`traffic`.pics is null");
            return (Criteria) this;
        }

        public Criteria andPicsIsNotNull() {
            addCriterion("`traffic`.pics is not null");
            return (Criteria) this;
        }

        public Criteria andPicsEqualTo(String value) {
            addCriterion("`traffic`.pics =", value, "pics");
            return (Criteria) this;
        }

        public Criteria andPicsNotEqualTo(String value) {
            addCriterion("`traffic`.pics <>", value, "pics");
            return (Criteria) this;
        }

        public Criteria andPicsGreaterThan(String value) {
            addCriterion("`traffic`.pics >", value, "pics");
            return (Criteria) this;
        }

        public Criteria andPicsGreaterThanOrEqualTo(String value) {
            addCriterion("`traffic`.pics >=", value, "pics");
            return (Criteria) this;
        }

        public Criteria andPicsLessThan(String value) {
            addCriterion("`traffic`.pics <", value, "pics");
            return (Criteria) this;
        }

        public Criteria andPicsLessThanOrEqualTo(String value) {
            addCriterion("`traffic`.pics <=", value, "pics");
            return (Criteria) this;
        }

        public Criteria andPicsLike(String value) {
            addCriterion("`traffic`.pics like", value, "pics");
            return (Criteria) this;
        }

        public Criteria andPicsNotLike(String value) {
            addCriterion("`traffic`.pics not like", value, "pics");
            return (Criteria) this;
        }

        public Criteria andPicsIn(List<String> values) {
            addCriterion("`traffic`.pics in", values, "pics");
            return (Criteria) this;
        }

        public Criteria andPicsNotIn(List<String> values) {
            addCriterion("`traffic`.pics not in", values, "pics");
            return (Criteria) this;
        }

        public Criteria andPicsBetween(String value1, String value2) {
            addCriterion("`traffic`.pics between", value1, value2, "pics");
            return (Criteria) this;
        }

        public Criteria andPicsNotBetween(String value1, String value2) {
            addCriterion("`traffic`.pics not between", value1, value2, "pics");
            return (Criteria) this;
        }

        public Criteria andVideoNameIsNull() {
            addCriterion("`traffic`.video_name is null");
            return (Criteria) this;
        }

        public Criteria andVideoNameIsNotNull() {
            addCriterion("`traffic`.video_name is not null");
            return (Criteria) this;
        }

        public Criteria andVideoNameEqualTo(String value) {
            addCriterion("`traffic`.video_name =", value, "videoName");
            return (Criteria) this;
        }

        public Criteria andVideoNameNotEqualTo(String value) {
            addCriterion("`traffic`.video_name <>", value, "videoName");
            return (Criteria) this;
        }

        public Criteria andVideoNameGreaterThan(String value) {
            addCriterion("`traffic`.video_name >", value, "videoName");
            return (Criteria) this;
        }

        public Criteria andVideoNameGreaterThanOrEqualTo(String value) {
            addCriterion("`traffic`.video_name >=", value, "videoName");
            return (Criteria) this;
        }

        public Criteria andVideoNameLessThan(String value) {
            addCriterion("`traffic`.video_name <", value, "videoName");
            return (Criteria) this;
        }

        public Criteria andVideoNameLessThanOrEqualTo(String value) {
            addCriterion("`traffic`.video_name <=", value, "videoName");
            return (Criteria) this;
        }

        public Criteria andVideoNameLike(String value) {
            addCriterion("`traffic`.video_name like", value, "videoName");
            return (Criteria) this;
        }

        public Criteria andVideoNameNotLike(String value) {
            addCriterion("`traffic`.video_name not like", value, "videoName");
            return (Criteria) this;
        }

        public Criteria andVideoNameIn(List<String> values) {
            addCriterion("`traffic`.video_name in", values, "videoName");
            return (Criteria) this;
        }

        public Criteria andVideoNameNotIn(List<String> values) {
            addCriterion("`traffic`.video_name not in", values, "videoName");
            return (Criteria) this;
        }

        public Criteria andVideoNameBetween(String value1, String value2) {
            addCriterion("`traffic`.video_name between", value1, value2, "videoName");
            return (Criteria) this;
        }

        public Criteria andVideoNameNotBetween(String value1, String value2) {
            addCriterion("`traffic`.video_name not between", value1, value2, "videoName");
            return (Criteria) this;
        }

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

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

        public Criteria andStatusEqualTo(Integer value) {
            addCriterion("`traffic`.`status` =", value, "status");
            return (Criteria) this;
        }

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

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

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

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

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

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

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

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

        public Criteria andStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("`traffic`.`status` not between", value1, value2, "status");
            return (Criteria) this;
        }

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    public static class ColumnContainer extends ColumnContainerBase {

        protected ColumnContainer(String tableName) {
            super(tableName);
        }

        public ColumnContainer hasIdColumn() {
            addColumnStr("`traffic`.id as traffic_id ");
            return (ColumnContainer) this;
        }

        public ColumnContainer hasEventTimeColumn() {
            addColumnStr("`traffic`.event_time as traffic_event_time ");
            return (ColumnContainer) this;
        }

        public ColumnContainer hasUnidColumn() {
            addColumnStr("`traffic`.unid as traffic_unid ");
            return (ColumnContainer) this;
        }

        public ColumnContainer hasTaskIdColumn() {
            addColumnStr("`traffic`.task_id as traffic_task_id ");
            return (ColumnContainer) this;
        }

        public ColumnContainer hasEventCateColumn() {
            addColumnStr("`traffic`.event_cate as traffic_event_cate ");
            return (ColumnContainer) this;
        }

        public ColumnContainer hasEventTypeColumn() {
            addColumnStr("`traffic`.event_type as traffic_event_type ");
            return (ColumnContainer) this;
        }

        public ColumnContainer hasChannelUnidColumn() {
            addColumnStr("`traffic`.channel_unid as traffic_channel_unid ");
            return (ColumnContainer) this;
        }

        public ColumnContainer hasPlateColorColumn() {
            addColumnStr("`traffic`.plate_color as traffic_plate_color ");
            return (ColumnContainer) this;
        }

        public ColumnContainer hasPlateNumberColumn() {
            addColumnStr("`traffic`.plate_number as traffic_plate_number ");
            return (ColumnContainer) this;
        }

        public ColumnContainer hasLocationCodeColumn() {
            addColumnStr("`traffic`.location_code as traffic_location_code ");
            return (ColumnContainer) this;
        }

        public ColumnContainer hasLocationNameColumn() {
            addColumnStr("`traffic`.location_name as traffic_location_name ");
            return (ColumnContainer) this;
        }

        public ColumnContainer hasLaneCodeColumn() {
            addColumnStr("`traffic`.lane_code as traffic_lane_code ");
            return (ColumnContainer) this;
        }

        public ColumnContainer hasDirectionCodeColumn() {
            addColumnStr("`traffic`.direction_code as traffic_direction_code ");
            return (ColumnContainer) this;
        }

        public ColumnContainer hasVehicleTypeColumn() {
            addColumnStr("`traffic`.vehicle_type as traffic_vehicle_type ");
            return (ColumnContainer) this;
        }

        public ColumnContainer hasVehicleColorColumn() {
            addColumnStr("`traffic`.vehicle_color as traffic_vehicle_color ");
            return (ColumnContainer) this;
        }

        public ColumnContainer hasVehicleLogoColumn() {
            addColumnStr("`traffic`.vehicle_logo as traffic_vehicle_logo ");
            return (ColumnContainer) this;
        }

        public ColumnContainer hasIllegalCodeColumn() {
            addColumnStr("`traffic`.illegal_code as traffic_illegal_code ");
            return (ColumnContainer) this;
        }

        public ColumnContainer hasIllegalStateColumn() {
            addColumnStr("`traffic`.illegal_state as traffic_illegal_state ");
            return (ColumnContainer) this;
        }

        public ColumnContainer hasFeatureAnnualInspectionMarkColumn() {
            addColumnStr("`traffic`.feature_annual_inspection_mark as traffic_feature_annual_inspection_mark ");
            return (ColumnContainer) this;
        }

        public ColumnContainer hasFeaturePendantColumn() {
            addColumnStr("`traffic`.feature_pendant as traffic_feature_pendant ");
            return (ColumnContainer) this;
        }

        public ColumnContainer hasFeatureDecorationColumn() {
            addColumnStr("`traffic`.feature_decoration as traffic_feature_decoration ");
            return (ColumnContainer) this;
        }

        public ColumnContainer hasFeatureSunShieldColumn() {
            addColumnStr("`traffic`.feature_sun_shield as traffic_feature_sun_shield ");
            return (ColumnContainer) this;
        }

        public ColumnContainer hasXcycleTypeColumn() {
            addColumnStr("`traffic`.xcycle_type as traffic_xcycle_type ");
            return (ColumnContainer) this;
        }

        public ColumnContainer hasEventIdColumn() {
            addColumnStr("`traffic`.event_id as traffic_event_id ");
            return (ColumnContainer) this;
        }

        public ColumnContainer hasSpecialTypeColumn() {
            addColumnStr("`traffic`.special_type as traffic_special_type ");
            return (ColumnContainer) this;
        }

        public ColumnContainer hasWithHelmetColumn() {
            addColumnStr("`traffic`.with_helmet as traffic_with_helmet ");
            return (ColumnContainer) this;
        }

        public ColumnContainer hasPicsColumn() {
            addColumnStr("`traffic`.pics as traffic_pics ");
            return (ColumnContainer) this;
        }

        public ColumnContainer hasVideoNameColumn() {
            addColumnStr("`traffic`.video_name as traffic_video_name ");
            return (ColumnContainer) this;
        }

        public ColumnContainer hasStatusColumn() {
            addColumnStr("`traffic`.`status` as `traffic_status` ");
            return (ColumnContainer) this;
        }

        public ColumnContainer hasCompanyColumn() {
            addColumnStr("`traffic`.company as traffic_company ");
            return (ColumnContainer) this;
        }
    }
}