| | |
| | | com_act_dyn_type AS cadt |
| | | LEFT JOIN sys_user AS su ON su.user_id = cadt.create_by |
| | | LEFT JOIN sys_user AS su1 ON su1.user_id = cadt.update_by |
| | | where cadt.community_id = 0 and cadt.is_del = 2 AND cadt.area in (1) |
| | | <!-- <if test="comActDynTypeDTO.area != null">--> |
| | | <!-- AND cadt.area in (1,2)--> |
| | | <!-- </if>--> |
| | | <!-- <if test="comActDynTypeDTO.area == null or comActDynTypeDTO.area == '1' ">--> |
| | | <!-- AND cadt.area in (1)--> |
| | | <!-- </if>--> |
| | | where cadt.community_id = 0 and cadt.is_del = 2 |
| | | <if test="comActDynTypeDTO.area != null"> |
| | | AND cadt.area in (1,2) |
| | | </if> |
| | | <if test="comActDynTypeDTO.area == null"> |
| | | AND cadt.area in (1) |
| | | </if> |
| | | <if test="comActDynTypeDTO.category != null"> |
| | | AND cadt.category = #{comActDynTypeDTO.category} |
| | | </if> |
| | |
| | | com_act_dyn_type AS cadt |
| | | LEFT JOIN sys_user AS su ON su.user_id = cadt.create_by |
| | | LEFT JOIN sys_user AS su1 ON su1.user_id = cadt.update_by |
| | | where cadt.is_del = 2 AND cadt.area in (1) |
| | | <!-- <if test="comActDynTypeDTO.area != null">--> |
| | | <!-- AND cadt.area in (1,2)--> |
| | | <!-- </if>--> |
| | | <!-- <if test="comActDynTypeDTO.area == null or comActDynTypeDTO.area == '1' ">--> |
| | | <!-- AND cadt.area in (1)--> |
| | | <!-- </if>--> |
| | | where cadt.is_del = 2 |
| | | <if test="comActDynTypeDTO.area != null"> |
| | | AND cadt.area in (1,2) |
| | | </if> |
| | | <if test="comActDynTypeDTO.area == null"> |
| | | AND cadt.area in (1) |
| | | </if> |
| | | <if test='comActDynTypeDTO.category != null '> |
| | | AND cadt.category = #{comActDynTypeDTO.category} |
| | | </if> |
| | |
| | | com_act_dyn_type AS cadt |
| | | LEFT JOIN sys_user AS su ON su.user_id = cadt.create_by |
| | | LEFT JOIN sys_user AS su1 ON su1.user_id = cadt.update_by |
| | | where cadt.is_del = 2 AND cadt.area in (1) |
| | | <!-- <if test="comActDynTypeDTO.area != null">--> |
| | | <!-- AND cadt.area in (1,2)--> |
| | | <!-- </if>--> |
| | | <!-- <if test="comActDynTypeDTO.area == null or comActDynTypeDTO.area == '1' ">--> |
| | | <!-- AND cadt.area in (1)--> |
| | | <!-- </if>--> |
| | | where cadt.is_del = 2 |
| | | <if test="comActDynTypeDTO.area != null"> |
| | | AND cadt.area in (1,2) |
| | | </if> |
| | | <if test="comActDynTypeDTO.area == null "> |
| | | AND cadt.area in (1) |
| | | </if> |
| | | <if test='comActDynTypeDTO.category != null '> |
| | | AND cadt.category = #{comActDynTypeDTO.category} |
| | | </if> |