花城 修改定时更新新双争双比时间问题2

lidongdong

2024-09-27 07d80b62e079edb16e4fb7939599b762612084b1

花城 修改定时更新新双争双比时间问题2

 springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/resources/mapper/StreetBigScreenMapper.xml

@@ -138,7 +138,7 @@

    <!--  获取旧双报道服务时间  -->
    <select id="getOldTime" resultType="Double">
        select SUM(ROUND((TIMESTAMPDIFF(SECOND,order_time, solve_time) / 3600000), 2)) from com_act_neighbor_circle
        select SUM(ROUND((TIMESTAMPDIFF(SECOND,order_time, solve_time) / 3600), 2)) from com_act_neighbor_circle
        where
            order_time is not null and solve_time is not null and belong_type in (2,3)
        <if test=" communityId !=null and communityId != '' ">