五微服务修改

puhanshu

2022-03-04 ed887265929fb7a829ff9ab4ce854f82e34d605b

五微服务修改

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

@@ -73,7 +73,8 @@
    </select>
    <select id="pageFmsServiceAdminApplets"
            resultType="com.panzhihua.common.model.vos.community.fms.ComFmsServiceVO">
        SELECT t1.id, t1.service_content, t1.service_image, IF(t2.nick_name IS NULL,'匿名用户',t2.nick_name) AS nickName, t2.image_url
        SELECT t1.id, t1.service_content, t1.service_image,
        IF(t2.nick_name IS NULL,IF(t1.user_name IS NULL,'匿名用户',t1.user_name),t2.nick_name) AS nickName, t2.image_url
        FROM com_fms_service t1
        LEFT JOIN sys_user t2 ON t1.user_id = t2.user_id
        WHERE t1.community_id = #{adminDTO.communityId}
@@ -88,7 +89,7 @@
    <select id="detailFmsServiceApplets"
            resultType="com.panzhihua.common.model.vos.community.fms.ComFmsServiceVO">
        SELECT t1.id, t1.service_content, t1.service_image, t1.phone, t1.service_status,
        t1.created_at, IF(t2.nick_name IS NULL,'匿名用户',t2.nick_name) AS nickName, t2.image_url
        t1.created_at, IF(t2.nick_name IS NULL,IF(t1.user_name IS NULL,'匿名用户',t1.user_name),t2.nick_name) AS nickName, t2.image_url
        FROM com_fms_service t1
        LEFT JOIN sys_user t2 ON t1.user_id = t2.user_id
        WHERE t1.id = #{serviceId}
@@ -99,7 +100,8 @@
        ORDER BY created_at DESC
    </select>
    <select id="pageDealFmsService" resultType="com.panzhihua.common.model.vos.community.fms.ComFmsServiceVO">
        SELECT t1.id, t1.service_content, t1.service_image, t1.service_status, t1.created_at, IF(t2.nick_name IS NULL,'匿名用户',t2.nick_name) AS nickName, t2.image_url
        SELECT t1.id, t1.service_content, t1.service_image, t1.service_status, t1.created_at,
        IF(t2.nick_name IS NULL,IF(t1.user_name IS NULL,'匿名用户',t1.user_name),t2.nick_name) AS nickName, t2.image_url
        FROM com_fms_service t1
        LEFT JOIN sys_user t2 ON t1.user_id = t2.user_id
        WHERE t1.community_id = #{adminDTO.communityId}