| | |
|---|
| | | + "LEFT JOIN com_act_dyn_type as cadt ON cadt.id = d.type " |
|---|
| | | + "LEFT JOIN com_act ca ON d.community_id = ca.community_id " + "WHERE 1=1 " |
|---|
| | | + "<if test='comActDynVO.choice == 0 '>" + "and d.community_id = ${comActDynVO.communityId} " + " </if> " |
|---|
| | | + "<if test='comActDynVO.areaCode !=null '>" + "and ca.area_code = ${comActDynVO.areaCode} " + " </if> " |
|---|
| | | + "<if test='comActDynVO.title != null and comActDynVO.title.trim() != ""'>" |
|---|
| | | + "AND d.title like concat(#{comActDynVO.title},'%') " + " </if> " |
|---|
| | | + "<if test='comActDynVO.isTopping != null '>" + "AND d.is_topping = #{comActDynVO.isTopping} " + " </if> " |
|---|
