| | |
|---|
| | | |
|---|
| | | @Select("<script> " + |
|---|
| | | "SELECT " + |
|---|
| | | "a.* " + |
|---|
| | | "a.*, " + |
|---|
| | | "IF(u.type=2,CONCAT('运营平台(',u.account,')'),CONCAT('社区平台(',u.account,')')) create_by_name " + |
|---|
| | | "FROM " + |
|---|
| | | "com_cvt_business a " + |
|---|
| | | "LEFT JOIN sys_user u ON a.create_by = u.user_id "+ |
|---|
| | | " <where>" + |
|---|
| | | "<if test='pageComCvtBusinessDTO.name != null and pageComCvtBusinessDTO.name.trim() != ""'>" + |
|---|
| | | " and a.name LIKE concat( #{pageComCvtBusinessDTO.name}, '%' ) " + |
|---|
| | | " and a.name LIKE concat( '%', #{pageComCvtBusinessDTO.name}, '%' ) " + |
|---|
| | | " </if> " + |
|---|
| | | "<if test='pageComCvtBusinessDTO.communityId != null and pageComCvtBusinessDTO.communityId != 0'>" + |
|---|
| | | " and a.community_id = #{pageComCvtBusinessDTO.communityId} " + |
|---|
