| | |
|---|
| | | "u.name userName,u.type as userType\n" + |
|---|
| | | "FROM\n" + |
|---|
| | | "com_ops_house d\n" + |
|---|
| | | "JOIN sys_user u ON d.user_id = u.user_id\n" + |
|---|
| | | " LEFT JOIN sys_user u ON d.user_id = u.user_id\n" + |
|---|
| | | " LEFT JOIN com_mng_struct_area sa ON d.house_community_id = sa.id \n" + |
|---|
| | | "where 1=1 " + |
|---|
| | | "<if test='pageComOpsHouseDTO.communityId != null '>" + |
|---|
| | | "AND d.community_id=#{pageComOpsHouseDTO.communityId} \n" + |
|---|
| | | "AND ( d.community_id=#{pageComOpsHouseDTO.communityId} or sa.community_id=#{pageComOpsHouseDTO.communityId} )\n" + |
|---|
| | | " </if> " + |
|---|
| | | |
|---|
| | | |
|---|
