| | |
|---|
| | | <if test="checktime != null ">and checktime = #{checktime}</if> |
|---|
| | | <if test="type != null and type != ''">and type = #{type}</if> |
|---|
| | | <if test="typename != null and typename != ''">and typename like concat('%', #{typename}, '%')</if> |
|---|
| | | <if test="bgeinTime != null ">and date_format(update_time,'%y%m%d') >= date_format(#{endTime},'%y%m%d') |
|---|
| | | <if test="beginTime != null ">and date_format(update_time,'%y%m%d') >= date_format(#{beginTime},'%y%m%d') |
|---|
| | | </if> |
|---|
| | | <if test="endTime != null ">and date_format(update_time,'%y%m%d') <= date_format(#{endTime},'%y%m%d') |
|---|
| | | </if> |
|---|
