更新续航统计和电池健康统计接口

whycxzp

2021-10-05 52336ae7b390983116a0c5a24ec875cc022ad1ff

 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=? )";
}