修改邻里圈详情报错

lidongdong

2023-03-15 7e0df178c20f5abf719aebfee641a7faedad93eb

修改邻里圈详情报错

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActNeighborCircleDAO.java

@@ -45,6 +45,7 @@

    ComActNeighborCircleDetailAppVO neighborDetailByApp(@Param("circleId") Long circleId);


    IPage<ComActNeighborCircleAdminVO> pageNeighborByAdmin(Page page,@Param("neighborCircleAdminDTO") ComActNeighborCircleAdminDTO neighborCircleAdminDTO);

    /**

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComActNeighborCircleServiceImpl.java

@@ -765,7 +765,7 @@

    @Override
    public R detailNeighborByAdmin(Long id) {
        ComActNeighborCircleDetailAppVO comActNeighborCircleDO = this.baseMapper.neighborDetailByApp(id);
        ComActNeighborCircleDetailAppVO comActNeighborCircleDO = baseMapper.neighborDetailByApp(id);
        if (comActNeighborCircleDO == null) {
            return R.fail("id有误");
        }

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

@@ -237,22 +237,38 @@
        </where>  order by create_at desc
    </select>


<!--    SELECT-->
<!--    canc.*,-->
<!--    su.nick_name as name,-->
<!--    su.community_id,-->
<!--    ca.`name` as communityName,-->
<!--    canct.name as topicName,-->
<!--    su.image_url as headUrl-->
<!--    FROM-->
<!--    com_act_neighbor_circle AS canc-->
<!--    left join sys_user as su on su.user_id = canc.release_id-->
<!--    left join com_act_neighbor_circle_topic as canct on canct.id = canc.topic_id-->
<!--    left join com_act as ca on ca.community_id = canc.community_id-->
<!--    where canc.id =${circleId}-->

    <select id="neighborDetailByApp" resultType="com.panzhihua.common.model.vos.neighbor.ComActNeighborCircleDetailAppVO">

        SELECT
            canc.*,
            su.nick_name as name,
            su.community_id,
            ca.`name` as communityName,
            canct.name as topicName,
            su.image_url as headUrl
            (SELECT nick_name FROM sys_user WHERE sys_user.user_id = canc.release_id) as name ,
            (SELECT community_id FROM sys_user WHERE sys_user.user_id = canc.release_id) as community_id,
            (SELECT name FROM com_act WHERE com_act.community_id = canc.community_id) as communityName,
            (SELECT name FROM com_act_neighbor_circle_topic WHERE com_act_neighbor_circle_topic.id = canc.topic_id) as topicName,
            (SELECT image_url FROM sys_user WHERE sys_user.user_id = canc.release_id) as headUrl
        FROM
            com_act_neighbor_circle AS canc
                left join sys_user as su on su.user_id = canc.release_id
                left join com_act_neighbor_circle_topic as canct on canct.id = canc.topic_id
                left join com_act as ca on ca.community_id = canc.community_id
        where canc.id =#{circleId}
        where canc.id =${circleId}


    </select>


    <select id="selectStatsCheckUnit" resultType="com.panzhihua.common.model.vos.neighbor.ServiceStaticsVO">
         select count(t1.checkId) as times,COALESCE(sum(t1.hours),0) as hours from
         ((select real_service_time as hours,solve_unit_id  as checkId  from com_act_neighbor_circle  where order_type = 1 AND is_del = 2 and solve_status = 4 and solve_unit_id = #{checkUnitId} and order_time between concat(#{date},'-01-01 00:00:00') and concat(#{date},'-12-31 23:59:59'))