资格审查统计

zengh

2021-08-16 0a2ba92ff0905bb70d763494e3fd52dfe369f7d6

资格审查统计

 src/main/java/org/springblade/modules/information/mapper/InformationMapper.xml

@@ -777,11 +777,11 @@

    <select id="selectExtypeUser" resultType="java.lang.Integer">
        SELECT
            COUNT( CASE WHEN (examination_mx is not null or examination_mx != "") THEN 1 END ) as sum
            COUNT( CASE WHEN ( examination_mx IS NOT NULL OR examination_mx != "" ) THEN 1 END ) AS sum
        FROM
            blade_user
            WHERE
            STATUS = 1
        WHERE
            STATUS != 1
    </select>

    <!--派遣保安人數量-->

 src/main/resources/application-dev.yml

@@ -3,11 +3,12 @@
  redis:
    ##redis 单机环境配置
    host: 127.0.0.1
#    port: 6379
#    password:
    port: 6379
    password:

    port: 6378
    password: redispsw
#   内网
#    port: 6378
#    password: redispsw

    database: 0
    ssl: false
@@ -17,15 +18,15 @@
    #  commandTimeout: 5000
  datasource:
    # MySql
#    url: jdbc:mysql://223.82.109.183:2083/zhba?useSSL=false&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true&serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true&allowPublicKeyRetrieval=true
#    username: root
#    password: zhba0728

#    内网版本
    url: jdbc:mysql://localhost:3306/zhba?useSSL=false&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true&serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true&allowPublicKeyRetrieval=true
    url: jdbc:mysql://223.82.109.183:2083/zhba?useSSL=false&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true&serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true&allowPublicKeyRetrieval=true
    username: root
    password: zhba0728

#    内网版本
#    url: jdbc:mysql://localhost:3306/zhba?useSSL=false&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true&serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true&allowPublicKeyRetrieval=true
#    username: root
#    password: zhba0728

    # PostgreSQL
    #url: jdbc:postgresql://127.0.0.1:5432/bladex_boot
    #username: postgres