| | |
|---|
| | | LEFT JOIN com_pb_check_unit as cpcu ON m.check_unit_id = cpcu.id |
|---|
| | | WHERE m.audit_result = 1 |
|---|
| | | <if test=" communityId !=null and communityId != '' "> |
|---|
| | | and community_id in = #{communityId} |
|---|
| | | and m.community_id in = #{communityId} |
|---|
| | | </if> |
|---|
| | | <if test=" communityId == null and streetId !=null and streetId != '' "> |
|---|
| | | and community_id in (select community_id from com_act where street_id=#{streetId} and app_id="wx118de8a734d269f0") |
|---|
| | | and m.community_id in (select community_id from com_act where street_id=#{streetId} and app_id="wx118de8a734d269f0") |
|---|
| | | </if> |
|---|
| | | <if test="starTime != null and starTime != '' "> |
|---|
| | | and creation_time BETWEEN #{starTime} AND #{endTime} |
|---|
| | | and m.creation_time BETWEEN #{starTime} AND #{endTime} |
|---|
| | | </if> |
|---|
| | | </select> |
|---|
| | | |
|---|
