From 52336ae7b390983116a0c5a24ec875cc022ad1ff Mon Sep 17 00:00:00 2001
From: whycxzp <perryhsu@163.com>
Date: 星期二, 05 十月 2021 23:34:33 +0800
Subject: [PATCH] 更新续航统计和电池健康统计接口
---
src/main/java/com/whyc/constant/SqlConstant.java | 11 +++++++++++
1 files changed, 11 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/whyc/constant/SqlConstant.java b/src/main/java/com/whyc/constant/SqlConstant.java
index 3009b02..ea53a7c 100644
--- a/src/main/java/com/whyc/constant/SqlConstant.java
+++ b/src/main/java/com/whyc/constant/SqlConstant.java
@@ -38,4 +38,15 @@
" `create_time` DATETIME NULL,\n" +
" PRIMARY KEY (`id`));";
+ /**鐢ㄦ埛瀵瑰簲鐨勭數姹犵粍id*/
+ public static String BattGroupIdsOfUser =" (select distinct db_battinf.tb_battinf.battgroupid " +
+ "from " +
+ "db_battinf.tb_battinf," +
+ "db_user.tb_user_battgroup_baojigroup_battgroup," +
+ "db_user.tb_user_battgroup_baojigroup_usr," +
+ "db_user.tb_user_inf " +
+ "where db_user.tb_user_battgroup_baojigroup_battgroup.BattGroupId=db_battinf.tb_battinf.BattGroupId " +
+ "and db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id=db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id " +
+ "and db_user.tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid " +
+ "and db_user.tb_user_inf.uid=? )";
}
--
Gitblit v1.9.1