lidongdong
2024-09-27 21de2ba1782bf7f0db5f5a4fe927b4dba10353aa
花城 修改定时更新新双争双比时间问题
2个文件已修改
6 ■■■■ 已修改文件
springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/service/impl/NeedProblemClaimServiceImpl.java 2 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/resources/mapper/StreetBigScreenMapper.xml 4 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/service/impl/NeedProblemClaimServiceImpl.java
@@ -241,7 +241,7 @@
                        List<NeedProblemClaimDTO> timeList=baseMapper.getNotTimeId(aId);
                        for (NeedProblemClaimDTO user:timeList)
                        {
                            long time=comActActivityDO.getNeedEndTime().getTime()-comActActivityDO.getNeedStartTime().getTime();
                            long time=comActActivityDO.getNeedEndTime().getTime()-user.getPunchStartTime().getTime();
                            baseMapper.updateEndTime(user.getId(),time+"",comActActivityDO.getNeedEndTime());
                        }
                    }
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) / 3600), 2)) from com_act_neighbor_circle
        select SUM(ROUND((TIMESTAMPDIFF(SECOND,order_time, solve_time) / 3600000), 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 != '' ">
@@ -154,7 +154,7 @@
    <!--  获取新双报道服务时间  -->
    <select id="getNewTime" resultType="Double">
        select SUM(ROUND((service_time / 3600), 2)) from new_fight_need_problem_claim
        select SUM(ROUND((service_time / 3600000), 2)) from new_fight_need_problem_claim
        where
        service_time is not null and
          task_id in (