| | |
|---|
| | | left join ums_data_dictionary t2 on t1.category = t2.id |
|---|
| | | left join ums_sccg_region t3 on t1.community_id=t3.id |
|---|
| | | <where> |
|---|
| | | <if test="category != null"> |
|---|
| | | <if test="categories != null"> |
|---|
| | | category = #{categories} |
|---|
| | | </if>> |
|---|
| | | <if test="community_id != null"> |
|---|
| | | </if> |
|---|
| | | <if test="communityId != null"> |
|---|
| | | and community_id = #{communityId} |
|---|
| | | </if> |
|---|
| | | <if test="code != null and code !=''"> |
|---|
| | |
|---|
| | | <if test="site != null and site!=''"> |
|---|
| | | and site like contact('%',#{site},'%') |
|---|
| | | </if> |
|---|
| | | <if test="startTime !='' and endTime !=''"> |
|---|
| | | <if test="startTime !='' and endTime !='' and startTime!=null and endTime !=null"> |
|---|
| | | and create_time between #{startTime} and #{endTime} |
|---|
| | | </if> |
|---|
| | | </where> |
|---|
