| | |
|---|
| | | select id,title,type,img_type, img_url,adver_position_top, adver_position_application from com_act_reserve |
|---|
| | | <where> |
|---|
| | | status = 2 and adver_position_application = 1 |
|---|
| | | <if test="communityId !=null"> |
|---|
| | | and (community_id = ${communityId} or community_id = 1) |
|---|
| | | </if> |
|---|
| | | and community_id = 1 |
|---|
| | | </where> |
|---|
| | | </select> |
|---|
| | | |
|---|
| | |
|---|
| | | <if test="pageReserveDTO.communityId != null and pageReserveDTO.communityId !=0"> |
|---|
| | | and t.community_id = ${pageReserveDTO.communityId} |
|---|
| | | </if> |
|---|
| | | <if test="pageReserveDTO.areaCode !=null"> |
|---|
| | | <if test="pageReserveDTO.areaCode !=null and pageReserveDTO.communityId !=1"> |
|---|
| | | and t1.area_code = #{pageReserveDTO.areaCode} |
|---|
| | | </if> |
|---|
| | | <if test="pageReserveDTO.type != null and pageReserveDTO.type.size > 0"> |
|---|
