Merge remote-tracking branch 'origin/master'
| | |
| | | @Update("update com_act_activity set `status`=3 where `status`=2 and TIMESTAMPDIFF(MINUTE,SYSDATE(),sign_up_begin)<=0") |
| | | int updateStatusToBeginSign(); |
| | | |
| | | @Update("update com_act_activity set `status`=(if(DATEDIFF(SYSDATE(),end_at)>=0,5,4)) where `status` in (3,4) and TIMESTAMPDIFF(MINUTE,SYSDATE(),sign_up_end)<=0") |
| | | @Update("update com_act_activity set `status`=5 where `status` in (3,4) and TIMESTAMPDIFF(MINUTE,SYSDATE(),sign_up_end)<=0") |
| | | int updateStatusToBeginActiveOrEnd(); |
| | | @Select("<script> " + |
| | | "select t.* from (\n" + |
| | |
| | | " AND su.phone = #{pageComShopOrderSearchDTO.userAccount} " + |
| | | " </if> " + |
| | | "<if test='pageComShopOrderSearchDTO.receiverAccount != null '>" + |
| | | " AND uad.name = #{pageComShopOrderSearchDTO.receiverAccount} " + |
| | | " AND uad.name like concat('%', #{pageComShopOrderSearchDTO.receiverAccount}, '%') " + |
| | | " </if> " + |
| | | "<if test='pageComShopOrderSearchDTO.receiverPhone != null '>" + |
| | | " AND uad.phone = #{pageComShopOrderSearchDTO.receiverPhone} " + |
| | |
| | | /*if(now.getTime()<comActActivityVO.getBeginAt().getTime()){ |
| | | comActActivityDO.setStatus(3); |
| | | }*/ |
| | | //结束时间大于当前时间则设置为“进行中” |
| | | //报名结束时间大于当前时间则设置为“进行中” |
| | | if(comActActivityVO.getSignUpEnd()!=null && now.getTime()<comActActivityVO.getSignUpEnd().getTime()){ |
| | | comActActivityDO.setStatus(4); |
| | | } |
| | |
| | | @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); |
| | |
| | | public R addactivity(PartyBuildingActivityVO partyBuildingActivityVO) { |
| | | ComPbActivityDO comPbActivityDO = new ComPbActivityDO(); |
| | | BeanUtils.copyProperties(partyBuildingActivityVO, comPbActivityDO); |
| | | comPbActivityDO.setCreateAt(new Date()); |
| | | Date now = new Date(); |
| | | comPbActivityDO.setEnrollTimeBegin(now); |
| | | comPbActivityDO.setCreateAt(now); |
| | | |
| | | //默认设置为“进行中” |
| | | comPbActivityDO.setStatus(4); |
| | | |
| | | int insert = comBpActivityDAO.insert(comPbActivityDO); |
| | | if (insert > 0) { |
| | | return R.ok(); |