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

lidongdong

2024-07-24 add7396dcca21630b577c3e523cb914c05287a00

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

 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,
                ROUND((TIMESTAMPDIFF(SECOND, s.start_time, s.end_time) / 3600000), 2) as serviceTime,
                ROUND((TIMESTAMPDIFF(SECOND, s.start_time, s.end_time) / 3600), 2) as serviceTime,
                2 AS serviceType
                FROM
                com_act_activity a
@@ -441,7 +441,7 @@
            SELECT
            a.id AS serviceId,
            a.publish_at AS serviceAt,
            ROUND((TIMESTAMPDIFF(SECOND, s.start_time, s.end_time) / 3600000), 2)  AS serviceTime,
            ROUND((TIMESTAMPDIFF(SECOND, s.start_time, s.end_time) / 3600), 2)  AS serviceTime,
            3 AS serviceType
            FROM
            com_act_activity a
@@ -459,7 +459,7 @@
            SELECT
            a.id AS serviceId,
            a.publish_at AS serviceAt,
            ROUND((TIMESTAMPDIFF(SECOND, s.start_time, s.end_time) / 3600000), 2) AS serviceTime,
            ROUND((TIMESTAMPDIFF(SECOND, s.start_time, s.end_time) / 3600), 2) AS serviceTime,
            4 AS serviceType
            FROM
            com_act_activity a
@@ -498,7 +498,7 @@
            SELECT
            a.id AS serviceId,
            a.publish_at AS serviceAt,
            ROUND((TIMESTAMPDIFF(SECOND, s.start_time, s.end_time) / 3600000), 2) AS serviceTime,
            ROUND((TIMESTAMPDIFF(SECOND, s.start_time, s.end_time) / 3600), 2) AS serviceTime,
            2 AS serviceType
            FROM
            com_act_activity a
@@ -517,7 +517,7 @@
            SELECT
            a.id AS serviceId,
            a.publish_at AS serviceAt,
            ROUND((TIMESTAMPDIFF(SECOND, s.start_time, s.end_time) / 3600000), 2) AS serviceTime,
            ROUND((TIMESTAMPDIFF(SECOND, s.start_time, s.end_time) / 3600), 2) AS serviceTime,
            3 AS serviceType
            FROM
            com_act_activity a
@@ -536,7 +536,7 @@
            SELECT
            a.id AS serviceId,
            a.publish_at AS serviceAt,
            ROUND((TIMESTAMPDIFF(SECOND, s.start_time, s.end_time) / 3600000), 2) AS serviceTime,
            ROUND((TIMESTAMPDIFF(SECOND, s.start_time, s.end_time) / 3600), 2) AS serviceTime,
            4 AS serviceType
            FROM
            com_act_activity a
@@ -773,7 +773,7 @@
        SELECT count(id) as serviceTimes, sum(duration) as serviceTime, unitId,unitName,orgName,
        communityId, memberId, memberName, belongUnit, belongCommunity, belongTo,sum(award) as partyCount
        FROM (
            SELECT caa.id, ROUND((TIMESTAMPDIFF(SECOND, caar.start_time, caar.end_time) / 3600000), 2) as duration, cpcu.id as unitId,cpcu.name as unitName,cpcu.org_name as orgName, cpcu.community_id as communityId, su.user_id as
            SELECT caa.id, ROUND((TIMESTAMPDIFF(SECOND, caar.start_time, caar.end_time) / 3600), 2) as duration, cpcu.id as unitId,cpcu.name as unitName,cpcu.org_name as orgName, cpcu.community_id as communityId, su.user_id as
            memberId, su.name as memberName, cpcu.name as belongUnit, ca.name as belongCommunity, cpcu.belong_to belongTo,caa.pb_reward_integral as award
            FROM `com_act_activity` as caa
            left join com_act_act_regist as caar on caa.id=caar.activity_id