Merge remote-tracking branch 'origin/test' into test
| | |
| | | public class EldersAuthFeedbackAddDTO { |
| | | |
| | | @NotNull() @Max(9223372036854775807L) |
| | | @ApiModelProperty(value = "认证ID", hidden = false, example = "1") |
| | | @ApiModelProperty(value = "认证ID", hidden = false, example = "1", required = true) |
| | | private Long authId; |
| | | |
| | | @Length(max=1024) |
| | |
| | | @Mapper |
| | | public interface ComActQuestnaireDAO extends BaseMapper<ComActQuestnaireDO> { |
| | | @Select("<script> " + |
| | | "SELECT aq.id, aq.title, aq.state, u.name as create_user, aq.join_count, aq.create_at , aq.create_by \n" + |
| | | "SELECT DISTINCT aq.id, aq.title, aq.state, u.name as create_user, aq.join_count, aq.create_at , aq.create_by \n" + |
| | | "FROM \n" + |
| | | " com_act_questnaire aq \n" + |
| | | " LEFT JOIN sys_user u on aq.create_by = u.user_id \n" + |
| | | "<if test='pageQuestnaireDTO.userId != null '>\n" + //筛选用户已回答的问卷 |
| | | " LEFT JOIN com_act_questnaire_sub qs ON aq.id = qs.que_Id\n" + |
| | | " LEFT JOIN com_act_questnaire_answer_content ac ON qs.id = ac.sub_id AND ac.user_id=#{pageQuestnaireDTO.userId} " + |
| | | " </if> \n" + |
| | | " where aq.is_hide=0 " + |
| | | |
| | | "<if test='pageQuestnaireDTO.userId != null '>\n" + //筛选用户已回答的问卷 |
| | | " AND case when ac.id IS NULL then aq.state=0 ELSE TRUE end " + |
| | | " </if> \n" + |
| | | "<if test='communityId != null and communityId!=0l '>\n" + |
| | | " and aq.community_id = #{communityId}\n" + |
| | | " </if> " + |