花城 修改以前遗留个人服务排行时间计算

lidongdong

2024-07-24 10f1b594e465be9561f29db214fa0dbd32404c64

花城 修改以前遗留个人服务排行时间计算

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActNeighborCircleDOMapper.xml

@@ -420,7 +420,7 @@
                SELECT
                a.id AS serviceId,
                a.publish_at AS serviceAt,
                a.duration AS serviceTime,
                ROUND((TIMESTAMPDIFF(SECOND, s.start_time, s.end_time) / 3600000), 2) as serviceTime,
                2 AS serviceType
                FROM
                com_act_activity a
@@ -432,6 +432,8 @@
                AND su.phone = #{phone}
                AND s.start_time BETWEEN concat( #{date}, '-01-01 00:00:00' )
                AND concat( #{date}, '-12-31 23:59:59' )
                and s.start_time IS NOT NULL
                and s.end_time IS NOT NULL
                GROUP BY
                a.id
            </if>
@@ -439,7 +441,7 @@
            SELECT
            a.id AS serviceId,
            a.publish_at AS serviceAt,
            a.duration AS serviceTime,
            ROUND((TIMESTAMPDIFF(SECOND, s.start_time, s.end_time) / 3600000), 2)  AS serviceTime,
            3 AS serviceType
            FROM
            com_act_activity a
@@ -457,7 +459,7 @@
            SELECT
            a.id AS serviceId,
            a.publish_at AS serviceAt,
            a.duration AS serviceTime,
            ROUND((TIMESTAMPDIFF(SECOND, s.start_time, s.end_time) / 3600000), 2) AS serviceTime,
            4 AS serviceType
            FROM
            com_act_activity a
@@ -496,7 +498,7 @@
            SELECT
            a.id AS serviceId,
            a.publish_at AS serviceAt,
            a.duration AS serviceTime,
            ROUND((TIMESTAMPDIFF(SECOND, s.start_time, s.end_time) / 3600000), 2) AS serviceTime,
            2 AS serviceType
            FROM
            com_act_activity a
@@ -515,7 +517,7 @@
            SELECT
            a.id AS serviceId,
            a.publish_at AS serviceAt,
            a.duration AS serviceTime,
            ROUND((TIMESTAMPDIFF(SECOND, s.start_time, s.end_time) / 3600000), 2) AS serviceTime,
            3 AS serviceType
            FROM
            com_act_activity a
@@ -534,7 +536,7 @@
            SELECT
            a.id AS serviceId,
            a.publish_at AS serviceAt,
            a.duration AS serviceTime,
            ROUND((TIMESTAMPDIFF(SECOND, s.start_time, s.end_time) / 3600000), 2) AS serviceTime,
            4 AS serviceType
            FROM
            com_act_activity a