| | |
|---|
| | | <select id="getStatusModeStatistics" resultType="com.ruoyi.chargingPile.api.vo.StatusModeStatisticsVO"> |
|---|
| | | SELECT |
|---|
| | | charge_mode, |
|---|
| | | IFNULL((SELECT COUNT(*) FROM t_charging_gun WHERE status = 2 AND charge_mode = #{chargeMode} and del_flag = 0),0) AS freeCount, |
|---|
| | | IFNULL((SELECT COUNT(*) FROM t_charging_gun WHERE status = 5 AND charge_mode = #{chargeMode} and del_flag = 0),0) AS filledCount, |
|---|
| | | IFNULL((SELECT COUNT(*) FROM t_charging_gun WHERE status = 3 AND charge_mode = #{chargeMode} and del_flag = 0),0) AS insertCount, |
|---|
| | | IFNULL((SELECT COUNT(*) FROM t_charging_gun WHERE status = 4 AND charge_mode = #{chargeMode} and del_flag = 0),0) AS chargingCount |
|---|
| | | SUM(CASE WHEN status = 2 THEN 1 ELSE 0 END) AS freeCount, |
|---|
| | | SUM(CASE WHEN status = 5 THEN 1 ELSE 0 END) AS filledCount, |
|---|
| | | SUM(CASE WHEN status = 3 THEN 1 ELSE 0 END) AS insertCount, |
|---|
| | | SUM(CASE WHEN status = 4 THEN 1 ELSE 0 END) AS chargingCount |
|---|
| | | FROM t_charging_gun |
|---|
| | | WHERE del_flag = ${@com.ruoyi.common.core.enums.DelFlagEnum@NO.getCode()} AND charge_mode = #{chargeMode} |
|---|
| | | AND charging_pile_id in ( |
|---|
