mitao
2025-02-21 31573d6180d15ef65ed0df9c2732495f40b12663
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
package com.panzhihua.service_community.dao;
 
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
 * @description: 社区动态阅读记录
 * @author: huang.hongfa weixin hhf9596 qq 959656820
 * @create: 2020-12-10 10:32
 **/
@Mapper
public interface ComActDynUserDAO extends BaseMapper<ComActDynUserDO> {
    @Update("update com_act_dyn set is_topping=0  WHERE is_topping=1 and TIMESTAMPDIFF(MINUTE, publish_at, SYSDATE())>=5*24*60")
    int timedTaskDynIstopping();
}