修改邻里圈详情报错

lidongdong

2023-03-16 a16dedc068d7f59bb00bd427a7baa7e7c41a9416

修改邻里圈详情报错

 springcloud_k8s_panzhihuazhihuishequ/applets/src/main/java/com/panzhihua/applets/unionpay/UnifiedOrder.java

@@ -61,6 +61,7 @@
        reqBody.orderDesc = orderDesc;
        reqBody.productId = productId;
        reqBody.notifyUrl = NOTIFYURL;
        reqBody.tradeType = "MINI";
        System.out.println("request body:\n"+reqBody);

        //2. 获取认证报文，timestamp为当前日期，老旧日期无法请求成功

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

@@ -256,13 +256,16 @@

        SELECT
            canc.*,
            (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
            su.nick_name as name,
            su.community_id as communityId,
            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}