101captain
2021-12-23 5a8a90c095280fbd2106869ecd2bad10e01a57a6
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActDynUserDAO.java
@@ -1,9 +1,10 @@
package com.panzhihua.service_community.dao;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.panzhihua.service_community.model.dos.ComActDynUserDO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Update;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.panzhihua.service_community.model.dos.ComActDynUserDO;
/**
 * @program: springcloud_k8s_panzhihuazhihuishequ
@@ -13,6 +14,6 @@
 **/
@Mapper
public interface ComActDynUserDAO extends BaseMapper<ComActDynUserDO> {
    @Update("update com_act_dyn set is_topping=0  WHERE is_topping=1 and TIMESTAMPDIFF(HOUR, publish_at, SYSDATE())>=5*24")
    @Update("update com_act_dyn set is_topping=0  WHERE is_topping=1 and TIMESTAMPDIFF(MINUTE, publish_at, SYSDATE())>=5*24*60")
    int timedTaskDynIstopping();
}