huanghongfa
2021-01-07 ae33fef700e5d2558dffb03c8f66358da2545791
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActDynUserDAO.java
@@ -3,6 +3,7 @@
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;
/**
 * @program: springcloud_k8s_panzhihuazhihuishequ
@@ -12,4 +13,6 @@
 **/
@Mapper
public interface ComActDynUserDAO extends BaseMapper<ComActDynUserDO> {
    @Update("update com_act_dyn set is_topping=(if(DATEDIFF(SYSDATE(),publish_at)>5,0,1)) WHERE is_topping=1")
    int timedTaskDynIstopping();
}