环境

huanghongfa

2021-01-12 29a35d331eaae01116c4624d82cd09fde79325fb

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActDynUserDAO.java

@@ -13,6 +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")
    @Update("update com_act_dyn set is_topping=0  WHERE is_topping=1 and DATEDIFF(SYSDATE(),publish_at)>5 ")
    int timedTaskDynIstopping();
}