#

luxiaotao1123

2022-11-08 217c6cde8324b485e47fdea740aa01669506f550

#

 src/main/resources/application.yml

@@ -9,12 +9,12 @@
    name: @pom.build.finalName@
  datasource:
    driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver
    url: jdbc:sqlserver://47.97.1.152:51433;databasename=zy_crm
    username: sa
    password: Zoneyung@zy56$
#    url: jdbc:sqlserver://192.168.4.15:1433;databasename=zy_crm
#    url: jdbc:sqlserver://47.97.1.152:51433;databasename=zy_crm
#    username: sa
#    password: sa@123
#    password: Zoneyung@zy56$
    url: jdbc:sqlserver://localhost:1433;databasename=zy_crm
    username: sa
    password: sa@123
  mvc:
    static-path-pattern: /**
  redis:

 src/main/resources/mapper/CstmrMapper.xml

@@ -62,7 +62,19 @@
                AND (CHARINDEX(','+#{deptId}+',', ','+sd.path+',') > 0 OR sd.id = #{deptId})
            </when>
            <otherwise>
                AND mc.user_id = #{userId}
                and
                (
                    user_id = #{userId}
                    or
                    mc.id in
                    (
                        select
                        cstmr_id
                        from man_cstmr_foll
                        where 1=1
                        and user_id = #{userId}
                    )
                )
            </otherwise>
        </choose>
        <if test="hostId != null">