添加体验活动定时任务

lidongdong

2023-10-23 f85bf2e1af306882d7578de211bef828fa9990f4

添加体验活动定时任务

 springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/service/jinhui/JinhuiCommunityService.java

@@ -895,6 +895,18 @@



    /**************************************************************************************************************
     *
     *
     *                                       定时任务
     *
     *
     *******************************************************************************************************************/

    //金汇社区定时任务
    @GetMapping("/JinhuiExperience/timedTaskJinhuiActivitiesJobHandler")
    public R timedTaskJinhuiActivitiesJobHandler();



}

 springcloud_k8s_panzhihuazhihuishequ/service_jinhui_community/src/main/java/com/panzhihua/service_jinhui_community/api/JinhuiExperienceActivityApi.java

@@ -147,4 +147,22 @@
        return applyExperienceService.filIn(userId,activityId,content);
    }


    /**************************************************************************************************************
     *
     *
     *                                       定时任务
     *
     *
     *******************************************************************************************************************/


    @GetMapping("/timedTaskJinhuiActivitiesJobHandler")
    public R timedTaskJinhuiActivitiesJobHandler()
    {
        return activityService.timedTaskJinhuiActivitiesJobHandler();
    }



}

 springcloud_k8s_panzhihuazhihuishequ/service_jinhui_community/src/main/java/com/panzhihua/service_jinhui_community/dao/JinhuiExperienceActivityDao.java

@@ -9,6 +9,7 @@
import org.apache.ibatis.annotations.Param;

import java.util.Date;
import java.util.List;

@Mapper
public interface JinhuiExperienceActivityDao extends BaseMapper<JinhuiExperienceActivity>
@@ -23,6 +24,7 @@
                                           @Param("activityType") String activityType,
                                           @Param("starTime") Date starTime,
                                           @Param("endTime") Date endTime);


    /**
     * 详情
@@ -54,4 +56,5 @@
    int expurgateData(@Param("id") String id);


    List<JinhuiExperienceActivity> getTimeList();
}

 springcloud_k8s_panzhihuazhihuishequ/service_jinhui_community/src/main/java/com/panzhihua/service_jinhui_community/service/JinhuiExperienceActivityService.java

@@ -29,4 +29,6 @@
    R editData(JinhuiExperienceActivityVO item);

    R expurgateData(String id);

    R timedTaskJinhuiActivitiesJobHandler();
}

 springcloud_k8s_panzhihuazhihuishequ/service_jinhui_community/src/main/java/com/panzhihua/service_jinhui_community/service/impl/JinhuiExperienceActivityServiceImpl.java

@@ -8,10 +8,10 @@
import com.panzhihua.service_jinhui_community.entity.JinhuiExperienceActivity;
import com.panzhihua.service_jinhui_community.service.JinhuiExperienceActivityService;
import lombok.extern.slf4j.Slf4j;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Service;

import java.util.Date;
import java.util.List;


@Slf4j
@@ -94,4 +94,73 @@
        }
        return R.fail("添加失败");
    }


    //定时任务
    @Override
    public R timedTaskJinhuiActivitiesJobHandler()
    {
        //金汇体验活动
        List<JinhuiExperienceActivity> list=baseMapper.getTimeList();

        for(JinhuiExperienceActivity item:list)
        {
            //当前时间
            long newTime=System.currentTimeMillis();
            //活动报名时间
            long applyStartTime=item.getApplyStartTime().getTime();
            //报名结束时间
            long applyEndTime=item.getApplyEndTime().getTime();
            //活动开始时间
            long activityStartTime=item.getActivityStartTime().getTime();
            //活动结束时间
            long activityEndTime=item.getActivityEndTime().getTime();


            switch (item.getActivityType())
            {
                //待开始
                case "1":
                    if(newTime>=applyStartTime && newTime<=applyEndTime )
                    {
                        JinhuiExperienceActivityVO vo=new JinhuiExperienceActivityVO();
                        vo.setId(item.getId());
                        vo.setActivityType("2");
                        baseMapper.editData(vo);
                    }

                    if(newTime>applyEndTime && newTime<activityStartTime  )
                    {
                        JinhuiExperienceActivityVO vo=new JinhuiExperienceActivityVO();
                        vo.setId(item.getId());
                        vo.setActivityType("6");
                        baseMapper.editData(vo);
                    }

                    break;
                //报名中
                case "2":
                    if(newTime>=activityStartTime && newTime<=activityEndTime )
                    {
                        JinhuiExperienceActivityVO vo=new JinhuiExperienceActivityVO();
                        vo.setId(item.getId());
                        vo.setActivityType("3");
                        baseMapper.editData(vo);
                    }
                    break;
                //已开始
                case "3":
                    if(newTime<=activityEndTime )
                    {
                        JinhuiExperienceActivityVO vo=new JinhuiExperienceActivityVO();
                        vo.setId(item.getId());
                        vo.setActivityType("4");
                        baseMapper.editData(vo);
                    }
                    break;
            }
        }

        return R.ok();
    }
}

 springcloud_k8s_panzhihuazhihuishequ/service_jinhui_community/src/main/resources/mapper/JinhuiExperienceActivityMapper.xml

@@ -221,4 +221,32 @@
        delete from jinhui_experience_activity where id=#{id}
    </delete>



    <select id="getTimeList" resultMap="itemMap">
        select
            id,
            title,
            address,
            lat,
            lon,
            apply_start_time,
            apply_end_time,
            activity_start_time,
            activity_end_time,
            people_number,
            phone,
            award,
            cover_img_url,
            creation_time,
            update_time,
            activity_type
        from jinhui_experience_activity
        where activity_type in (1,2,3)
    </select>





</mapper>

 springcloud_k8s_panzhihuazhihuishequ/timejob/src/main/java/com/panzhihua/timejob/jobhandler/JinhuiJobHandler.java

New file
@@ -0,0 +1,33 @@
package com.panzhihua.timejob.jobhandler;

import com.panzhihua.common.model.vos.R;
import com.panzhihua.common.service.community.CommunityService;
import com.panzhihua.common.service.jinhui.JinhuiCommunityService;
import com.xxl.job.core.biz.model.ReturnT;
import com.xxl.job.core.handler.annotation.XxlJob;
import lombok.extern.slf4j.Slf4j;
import org.springframework.stereotype.Component;

import javax.annotation.Resource;

/**
 * 金汇社区任务定时器
 * @author lyq
 */
@Slf4j
@Component
public class JinhuiJobHandler {

    @Resource
    private JinhuiCommunityService communityService;


    //定时任务  路北社区
    @XxlJob("timedTaskJinhuiActivitiesJobHandler")
    public ReturnT<String> timedTaskJinhuiActivitiesJobHandler(String param) throws Exception {
        log.info("定时任务 每半小时检测一次路北社区 活动任务状态");
        R r = communityService.timedTaskJinhuiActivitiesJobHandler();
        log.info("执行结果【{}】", r.toString());
        return ReturnT.SUCCESS;
    }
}

 springcloud_k8s_panzhihuazhihuishequ/timejob/src/main/java/com/panzhihua/timejob/jobhandler/LBJobHandler.java

File was deleted