Merge remote-tracking branch 'origin/master'
| | |
| | | @ApiModelProperty(value = "社区id",hidden = true) |
| | | private Long communityId; |
| | | |
| | | @ApiModelProperty(value = "社区名称") |
| | | private String communityName; |
| | | |
| | | @ApiModelProperty(value = "当前页数",example="1") |
| | | private Long pageNum; |
| | | |
| | |
| | | @ApiModelProperty("党员活动是否个人发布 1 是 0 否") |
| | | private Integer isPerson; |
| | | |
| | | @ApiModelProperty(value = "查询筛选:0-本小区 1-全部") |
| | | private Integer choice; |
| | | |
| | | } |
| | |
| | | |
| | | @ApiModelProperty(value = "封面模式:1-小图展示 2-大图展示") |
| | | private Integer coverMode; |
| | | |
| | | @ApiModelProperty(value = "查询筛选:0-本小区 1-全部") |
| | | private Integer choice; |
| | | } |
| | |
| | | @ApiModelProperty("社区id") |
| | | private Long communityId; |
| | | |
| | | @ApiModelProperty("社区名称") |
| | | private String communityName; |
| | | |
| | | @ApiModelProperty("活动党员列表") |
| | | private List<PartyBuildingMemberVO> partyBuildingMemberVOS; |
| | | |
| | |
| | | "count(if(s.is_volunteer=0,s.id,null))participant_now,\n"+ |
| | | "a.participant_max,\n" + |
| | | "a.sign_up_begin,\n" + |
| | | "a.sign_up_end\n" + |
| | | "a.sign_up_end,\n" + |
| | | "ca.name as communityName \n" + |
| | | "FROM\n" + |
| | | "com_act_activity a \n" + |
| | | "join sys_user u on a.sponsor_id=u.user_id\n" + |
| | | "left join com_act_act_sign s on a.id=s.activity_id \n"+ |
| | | " where a.community_id=#{comActActivityVO.communityId}" + |
| | | "left join com_act ca on a.community_id=ca.community_id \n"+ |
| | | " where 1=1 " + |
| | | |
| | | "<if test='comActActivityVO.choice == 0 '>" + |
| | | "AND a.community_id=#{comActActivityVO.communityId}\n" + |
| | | " </if> " + |
| | | |
| | | "<if test='comActActivityVO.activityName != null and comActActivityVO.activityName.trim() != ""'>" + |
| | | " and a.activity_name like concat(#{comActActivityVO.activityName},'%') \n" + |
| | | " </if> " + |
| | |
| | | "FROM\n" + |
| | | "com_act_dyn d\n" + |
| | | "LEFT JOIN com_act_dyn_user u ON d.id = u.dyn_id \n" + |
| | | "WHERE\n" + |
| | | "d.community_id=#{comActDynVO.communityId}\n" + |
| | | "WHERE 1=1 \n" + |
| | | "<if test='comActDynVO.choice == 0 '>" + |
| | | "and d.community_id=#{comActDynVO.communityId}\n" + |
| | | " </if> " + |
| | | "<if test='comActDynVO.title != null and comActDynVO.title.trim() != ""'>" + |
| | | "AND d.title like concat(#{comActDynVO.title},'%') \n" + |
| | | " </if> " + |
| | |
| | | int updateStatusToActiveOrEnd(); |
| | | @Select("select type,name from sys_user where user_id=#{createBy}") |
| | | LoginUserInfoVO selectUserInfoByUserId(Long createBy); |
| | | |
| | | /** |
| | | * 根据社区id查询社区名称 |
| | | * @param communityId 社区id |
| | | * @return 社区名字 |
| | | */ |
| | | @Select("select name from com_act where community_id=#{communityId}") |
| | | String selectCommunityNameByCommunityId(Long communityId); |
| | | } |
| | |
| | | @Resource |
| | | private ComPbMemberDAO comPbMemberDAO; |
| | | |
| | | |
| | | /** |
| | | * 查询某个党员加入的所有党员活动 |
| | | * |
| | |
| | | partyBuildingActivityVO.setPartyBuildingMemberVOS(partyBuildingMemberVOS); |
| | | partyBuildingActivityVO.setIsPerson(isPerson); |
| | | partyBuildingActivityVO.setCreateByName(loginUserInfoVO.getName()); |
| | | |
| | | //查询社区名称 |
| | | if(partyBuildingActivityVO.getCommunityId() != null){ |
| | | partyBuildingActivityVO.setCommunityName(comBpActivityDAO.selectCommunityNameByCommunityId(partyBuildingActivityVO.getCommunityId())); |
| | | } |
| | | |
| | | return R.ok(partyBuildingActivityVO); |
| | | } |
| | | |