| | |
|---|
| | | @Update("update com_pb_activity set status=3 where `status`=2 and TIMESTAMPDIFF(MINUTE,SYSDATE(),enroll_time_begin)<=0") |
|---|
| | | int updateStatusToSign(); |
|---|
| | | |
|---|
| | | @Update("update com_pb_activity set status=(if(TIMESTAMPDIFF(MINUTE,SYSDATE(),activity_time_end)<=0,5,4)) where `status` in (3,4) and TIMESTAMPDIFF(MINUTE,SYSDATE(),enroll_time_end)<=0") |
|---|
| | | @Update("update com_pb_activity set status=5 where `status` in (3,4) and TIMESTAMPDIFF(MINUTE,SYSDATE(),enroll_time_end)<=0") |
|---|
| | | 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); |
|---|
| | | } |
|---|
