党建动态按照发布时间倒序排列

huanghongfa

2021-01-15 921eede619b8df48d3a342943735bd0f4db8a285

 springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/dao/ComPbDynDAO.java

@@ -59,7 +59,7 @@
            " </if> " +
            "GROUP BY\n" +
            "d.id\n" +
            "ORDER BY d.create_at desc"+
            "ORDER BY d.publish_at desc"+
            "</script>")
    IPage<PartyBuildingComPbDynVO> pageYnamic(Page page, @Param("partyBuildingComPbDynVO") PartyBuildingComPbDynVO partyBuildingComPbDynVO);
    @Update("update com_pb_dyn set `status`=2  WHERE `status`=1 and TIMESTAMPDIFF(HOUR,SYSDATE(),publish_at)<=0")