From 0a2ba92ff0905bb70d763494e3fd52dfe369f7d6 Mon Sep 17 00:00:00 2001
From: zengh <123456>
Date: Mon, 16 Aug 2021 10:33:15 +0800
Subject: [PATCH] 资格审查统计
---
src/main/java/org/springblade/modules/information/mapper/InformationMapper.xml | 6 +++---
src/main/resources/application-dev.yml | 21 +++++++++++----------
2 files changed, 14 insertions(+), 13 deletions(-)
diff --git a/src/main/java/org/springblade/modules/information/mapper/InformationMapper.xml b/src/main/java/org/springblade/modules/information/mapper/InformationMapper.xml
index ddebd54..220ac1c 100644
--- a/src/main/java/org/springblade/modules/information/mapper/InformationMapper.xml
+++ b/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>
<!--派遣保安人數量-->
diff --git a/src/main/resources/application-dev.yml b/src/main/resources/application-dev.yml
index 2a8c6a1..a7a3ce6 100644
--- a/src/main/resources/application-dev.yml
+++ b/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
--
Gitblit v1.9.3