| | |
| | | |
| | | Map<String, Object> getLargeScreenSummary(@Param("siteIds") List<Integer> siteIds); |
| | | |
| | | List<LargeChargingPowerVo> getLargeScreenChargingPower(@Param("siteIds") List<Integer> siteIds, |
| | | List<LargeChargingPowerVo> getLargeScreenChargingPower(@Param("siteIdsCsv") String siteIdsCsv, |
| | | @Param("startTime") LocalDateTime startTime, |
| | | @Param("endTime") LocalDateTime endTime); |
| | | |
| | |
| | | |
| | | @Override |
| | | public List<LargeChargingPowerVo> getLargeScreenChargingPower(List<Integer> siteIds, LocalDateTime startTime, LocalDateTime endTime) { |
| | | return this.baseMapper.getLargeScreenChargingPower(siteIds, startTime, endTime); |
| | | String siteIdsCsv = siteIds == null ? null : siteIds.stream() |
| | | .map(String::valueOf).collect(Collectors.joining(",")); |
| | | return this.baseMapper.getLargeScreenChargingPower(siteIdsCsv, startTime, endTime); |
| | | } |
| | | |
| | | @Override |
| | |
| | | AND charging_order.status = 5 |
| | | AND charging_order.recharge_payment_status = 2 |
| | | AND charging_order.create_time >= DATE_FORMAT(CURDATE(), '%Y-%m-01') |
| | | AND charging_order.create_time < DATE_ADD(DATE_FORMAT(CURDATE(), '%Y-%m-01'), INTERVAL 1 MONTH) |
| | | AND charging_order.create_time <= NOW() |
| | | <if test="siteIds != null and siteIds.size() > 0"> |
| | | AND charging_order.site_id IN |
| | | <foreach collection="siteIds" item="siteId" open="(" separator="," close=")"> |
| | |
| | | WHERE del_flag = 0 |
| | | AND create_time >= #{startTime} |
| | | AND create_time < #{endTime} |
| | | <if test="siteIds != null and siteIds.size() > 0"> |
| | | AND site_id IN |
| | | <foreach collection="siteIds" item="siteId" open="(" separator="," close=")"> |
| | | #{siteId} |
| | | </foreach> |
| | | <if test="siteIdsCsv != null and siteIdsCsv != ''"> |
| | | AND site_id IN (${siteIdsCsv}) |
| | | </if> |
| | | GROUP BY DATE_FORMAT(create_time, '%Y-%m-%d') |
| | | ORDER BY time |