| | |
|---|
| | | |
|---|
| | | <select id="getLargeScreenSummary" resultType="java.util.Map"> |
|---|
| | | SELECT COUNT(DISTINCT charging_order.id) AS validOrderCount, |
|---|
| | | COUNT(DISTINCT charging_order.app_user_id) AS chargingUserCount, |
|---|
| | | (SELECT COUNT(DISTINCT user_count_order.app_user_id) |
|---|
| | | FROM t_charging_order user_count_order |
|---|
| | | <if test="siteIds != null and siteIds.size() > 0"> |
|---|
| | | WHERE user_count_order.site_id IN |
|---|
| | | <foreach collection="siteIds" item="siteId" open="(" separator="," close=")"> |
|---|
| | | #{siteId} |
|---|
| | | </foreach> |
|---|
| | | </if>) AS chargingUserCount, |
|---|
| | | (SELECT COUNT(*) |
|---|
| | | FROM charging_pile_account.t_app_user app_user |
|---|
| | | WHERE app_user.del_flag = 0) AS registeredUserCount, |
|---|
