| | |
|---|
| | | + "a.activity_time_begin,\n" + "a.activity_time_end,\n" + "a.enroll_time_begin,\n" + "a.cover,\n" |
|---|
| | | + "if(u.type=3 ,'管理员',u.name)createByName,\n" + "a.enroll_time_end \n" + "FROM\n" + "com_pb_activity a\n" |
|---|
| | | + "left join sys_user u on a.create_by=u.user_id \n" |
|---|
| | | + "where a.community_id=#{partyBuildingActivityVO.communityId}\n" |
|---|
| | | + "where a.community_id = ${partyBuildingActivityVO.communityId}\n" |
|---|
| | | + "<if test='partyBuildingActivityVO.name != null and partyBuildingActivityVO.name.trim() != ""'>" |
|---|
| | | + "and a.name = #{partyBuildingActivityVO.name} \n" + " </if> " |
|---|
| | | + "<if test='partyBuildingActivityVO.isAppliets != null and partyBuildingActivityVO.isAppliets==1'>" |
|---|
| | |
|---|
| | | * 社区id |
|---|
| | | * @return 社区名字 |
|---|
| | | */ |
|---|
| | | @Select("select name from com_act where community_id=#{communityId}") |
|---|
| | | @Select("select name from com_act where community_id = ${communityId}") |
|---|
| | | String selectCommunityNameByCommunityId(Long communityId); |
|---|
| | | } |
|---|
