| | |
| | | LEFT JOIN com_mng_village AS cmv ON cmv.village_id = cmp.village_id |
| | | WHERE |
| | | cmpct.community_id = ${pageInputUserDTO.communityId} |
| | | AND cmpct.label IS NOT NULL |
| | | AND cmpct.label IS NOT NULL and cmpt.label !='' |
| | | <if test='pageInputUserDTO.name != null and pageInputUserDTO.name != ""'> |
| | | AND cmp.`name` LIKE concat(#{pageInputUserDTO.name},'%') |
| | | </if> |
| | |
| | | LEFT JOIN com_mng_village AS cmv ON cmv.village_id = cmp.village_id |
| | | WHERE |
| | | cmpct.community_id = ${pageInputUserDTO.communityId} |
| | | AND cmpct.label IS NOT NULL |
| | | AND cmpct.label IS NOT NULL and cmpt.label !='' |
| | | <if test='pageInputUserDTO.name != null and pageInputUserDTO.name != ""'> |
| | | AND cmp.`name` LIKE concat(#{pageInputUserDTO.name},'%') |
| | | </if> |