| | |
| | | @ApiModelProperty(value = "社区id",hidden = true) |
| | | private Long communityId; |
| | | |
| | | @ApiModelProperty(value = "社区名称") |
| | | private String communityName; |
| | | |
| | | @ApiModelProperty(value = "当前页数",example="1") |
| | | private Long pageNum; |
| | | |
| | |
| | | "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"+ |
| | | "left join com_act ca on a.community_id=ca.community_id \n"+ |
| | | " where 1=1 " + |
| | | |
| | | "<if test='comActActivityVO.choice == 0 '>" + |