package com.ruoyi.chargingPile.service.impl;
|
|
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
|
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
|
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
|
import com.ruoyi.account.api.feignClient.AppUserCarClient;
|
import com.ruoyi.account.api.model.TAppUserCar;
|
import com.ruoyi.chargingPile.api.dto.PageChargingPileListDTO;
|
import com.ruoyi.chargingPile.api.model.Site;
|
import com.ruoyi.chargingPile.api.model.TChargingGun;
|
import com.ruoyi.chargingPile.api.model.TChargingPile;
|
import com.ruoyi.chargingPile.api.query.BatchSetAccountingStrategy;
|
import com.ruoyi.chargingPile.api.query.PageChargingPileList;
|
import com.ruoyi.chargingPile.api.vo.TChargingGunVO;
|
import com.ruoyi.chargingPile.api.vo.TChargingPileVO;
|
import com.ruoyi.chargingPile.domain.SiteMenu;
|
import com.ruoyi.chargingPile.dto.ChargeMonitoring;
|
import com.ruoyi.chargingPile.dto.ChargingGunCountMonitoring;
|
import com.ruoyi.chargingPile.dto.ChargingGunMonitoring;
|
import com.ruoyi.chargingPile.dto.GetChargingGunMonitoring;
|
import com.ruoyi.chargingPile.mapper.TChargingPileMapper;
|
import com.ruoyi.chargingPile.service.IPartnerService;
|
import com.ruoyi.chargingPile.service.ISiteService;
|
import com.ruoyi.chargingPile.service.TChargingGunService;
|
import com.ruoyi.chargingPile.service.TChargingPileService;
|
import com.ruoyi.common.core.utils.StringUtils;
|
import com.ruoyi.common.core.web.domain.AjaxResult;
|
import com.ruoyi.common.core.web.page.PageInfo;
|
import com.ruoyi.common.security.utils.SecurityUtils;
|
import com.ruoyi.order.api.feignClient.ChargingOrderAccountingStrategyClient;
|
import com.ruoyi.order.api.feignClient.ChargingOrderClient;
|
import com.ruoyi.order.api.model.TChargingOrder;
|
import com.ruoyi.other.api.feignClient.RoleSiteClient;
|
import com.ruoyi.other.api.feignClient.UserSiteClient;
|
import com.ruoyi.system.api.domain.SysUser;
|
import com.ruoyi.system.api.feignClient.SysUserClient;
|
import org.springframework.stereotype.Service;
|
|
import javax.annotation.Resource;
|
import java.math.BigDecimal;
|
import java.math.RoundingMode;
|
import java.text.SimpleDateFormat;
|
import java.util.*;
|
import java.util.stream.Collectors;
|
import java.util.stream.Stream;
|
|
/**
|
* <p>
|
* 充电桩 服务实现类
|
* </p>
|
*
|
* @author xiaochen
|
* @since 2024-08-06
|
*/
|
@Service
|
public class TChargingPileServiceImpl extends ServiceImpl<TChargingPileMapper, TChargingPile> implements TChargingPileService {
|
|
@Resource
|
private TChargingGunService chargingGunService;
|
|
@Resource
|
private SysUserClient sysUserClient;
|
|
@Resource
|
private IPartnerService partnerService;
|
|
@Resource
|
private UserSiteClient userSiteClient;
|
|
@Resource
|
private RoleSiteClient roleSiteClient;
|
|
@Resource
|
private ISiteService siteService;
|
|
@Resource
|
private ChargingOrderAccountingStrategyClient chargingOrderAccountingStrategyClient;
|
|
@Resource
|
private ChargingOrderClient chargingOrderClient;
|
|
@Resource
|
private AppUserCarClient appUserCarClient;
|
|
|
|
|
|
/**
|
* 获取充电桩列表数据
|
* @param page
|
* @return
|
*/
|
@Override
|
public PageInfo<PageChargingPileListDTO> pageChargingPileList(PageChargingPileList page) {
|
Set<Integer> siteIds = null;
|
//校验合作商权限
|
SysUser sysUser = sysUserClient.getSysUser(SecurityUtils.getUserId()).getData();
|
Integer roleType = sysUser.getRoleType();
|
Integer objectId = sysUser.getObjectId();
|
//合作商
|
if(roleType == 2){
|
siteIds = partnerService.authSite(objectId, SiteMenu.CHARGING_PILE);
|
}else{
|
//非管理员需要根据角色和用户配置查询允许的站点数据
|
if(!SecurityUtils.isAdmin(SecurityUtils.getUserId())){
|
List<Integer> data = userSiteClient.getSiteIds(sysUser.getUserId()).getData();
|
List<Integer> data1 = roleSiteClient.getSiteIds(sysUser.getRoleId()).getData();
|
data.addAll(data1);
|
siteIds = new HashSet<>(data);
|
}
|
}
|
PageInfo<PageChargingPileListDTO> pageInfo = new PageInfo<>(page.getPageCurr(), page.getPageSize());
|
List<PageChargingPileListDTO> list = this.baseMapper.pageChargingPileList(pageInfo, page, siteIds);
|
for (PageChargingPileListDTO pageChargingPileListDTO : list) {
|
Integer siteId = pageChargingPileListDTO.getSiteId();
|
pageChargingPileListDTO.setAuthAddChargingGun(roleType == 1 ? true : partnerService.authMenu(objectId, siteId, SiteMenu.CHARGING_PILE_ADD_CHARGING_GUN));
|
pageChargingPileListDTO.setAuthDelete(roleType == 1 ? true : partnerService.authMenu(objectId, siteId, SiteMenu.CHARGING_PILE_DELETE));
|
pageChargingPileListDTO.setAuthQueryInfo(roleType == 1 ? true : partnerService.authMenu(objectId, siteId, SiteMenu.CHARGING_PILE_QUERY_INFO));
|
pageChargingPileListDTO.setAuthUpdate(roleType == 1 ? true : partnerService.authMenu(objectId, siteId, SiteMenu.CHARGING_PILE_UPDATE));
|
}
|
return pageInfo.setRecords(list);
|
}
|
|
|
/**
|
* 添加充电桩
|
* @param chargingPile
|
* @return
|
*/
|
@Override
|
public AjaxResult addChargingPile(TChargingPile chargingPile) {
|
AjaxResult ajaxResult = addChargingPileVerify(chargingPile);
|
if(ajaxResult.isError()){
|
return ajaxResult;
|
}
|
long count = this.count(new LambdaQueryWrapper<TChargingPile>().eq(TChargingPile::getCode, chargingPile.getCode())
|
.eq(TChargingPile::getDelFlag, 0));
|
if(count > 0){
|
return AjaxResult.error("设备编号已存在");
|
}
|
this.save(chargingPile);
|
return AjaxResult.success();
|
}
|
|
|
/**
|
* 校验必填项
|
* @param chargingPile
|
* @return
|
*/
|
AjaxResult addChargingPileVerify(TChargingPile chargingPile){
|
if(StringUtils.isEmpty(chargingPile.getCode())){
|
return AjaxResult.error("设备编号不能为空");
|
}
|
if(StringUtils.isEmpty(chargingPile.getName())){
|
return AjaxResult.error("充电设备名称不能为空");
|
}
|
if(null == chargingPile.getNumber()){
|
return AjaxResult.error("桩号不能为空");
|
}
|
if(null == chargingPile.getType()){
|
return AjaxResult.error("设备类型不能为空");
|
}
|
if(null == chargingPile.getSiteId()){
|
return AjaxResult.error("归属电站不能为空");
|
}
|
if(null == chargingPile.getPartnerId()){
|
return AjaxResult.error("归属合作商不能为空");
|
}
|
if(null == chargingPile.getRatedPower()){
|
return AjaxResult.error("额定功率不能为空");
|
}
|
return AjaxResult.success();
|
}
|
|
|
/**
|
* 获取充电桩详情
|
* @param id 充电桩id
|
* @return
|
*/
|
@Override
|
public TChargingPile getChargingPile(Integer id) {
|
return this.baseMapper.getChargingPile(id);
|
}
|
|
|
/**
|
* 编辑充电桩
|
* @param chargingPile
|
* @return
|
*/
|
@Override
|
public AjaxResult editChargingPile(TChargingPile chargingPile) {
|
AjaxResult ajaxResult = addChargingPileVerify(chargingPile);
|
if(ajaxResult.isError()){
|
return ajaxResult;
|
}
|
TChargingPile one = this.getOne(new LambdaQueryWrapper<TChargingPile>().eq(TChargingPile::getCode, chargingPile.getCode())
|
.eq(TChargingPile::getDelFlag, 0));
|
if(null != one && !one.getId().equals(chargingPile.getId())){
|
return AjaxResult.error("设备编号已存在");
|
}
|
this.updateById(chargingPile);
|
return AjaxResult.success();
|
}
|
|
|
/**
|
* 删除充电桩
|
* @param ids
|
* @return
|
*/
|
@Override
|
public AjaxResult delChargingPile(Integer[] ids) {
|
//检查是否有关联数据
|
//接口
|
long count = chargingGunService.count(new LambdaQueryWrapper<TChargingGun>().eq(TChargingGun::getChargingPileId, Arrays.asList(ids)).eq(TChargingGun::getDelFlag, 0));
|
if(count > 0){
|
return AjaxResult.error("该充电桩有关联的接口数据，删除失败！");
|
}
|
for (Integer id : ids) {
|
TChargingPile chargingPile = this.getById(id);
|
chargingPile.setDelFlag(true);
|
this.updateById(chargingPile);
|
}
|
return AjaxResult.success();
|
}
|
|
/**
|
* 批量设置计费策略
|
* @param setAccountingStrategy
|
*/
|
@Override
|
public void batchSetAccountingStrategy(BatchSetAccountingStrategy setAccountingStrategy) {
|
List<Integer> id = setAccountingStrategy.getId();
|
List<TChargingGun> list = chargingGunService.list(new LambdaQueryWrapper<TChargingGun>().in(TChargingGun::getChargingPileId, id).eq(TChargingGun::getDelFlag, 0));
|
for (TChargingGun tChargingGun : list) {
|
tChargingGun.setChargingPileId(setAccountingStrategy.getAccountingStrategyId());
|
}
|
chargingGunService.updateBatchById(list);
|
}
|
|
@Override
|
public List<TChargingPileVO> getChargingGunList(Integer siteId,Integer type) {
|
List<TChargingPileVO> chargingPileVOS = this.baseMapper.getChargingGunList(siteId);
|
List<TChargingGun> chargingGuns = chargingGunService.list(Wrappers.lambdaQuery(TChargingGun.class)
|
.eq(TChargingGun::getSiteId, siteId)
|
.eq(TChargingGun::getChargeMode, type));
|
// 查询充电枪信息
|
chargingPileVOS.forEach(item -> {
|
item.setChargingGunList(chargingGuns.stream().filter(gun -> gun.getChargingPileId().equals(item.getId())).collect(Collectors.toList()));
|
});
|
return chargingPileVOS;
|
}
|
|
|
/**
|
* 获取监控设备监控数据
|
* @param siteId
|
* @return
|
*/
|
@Override
|
public ChargeMonitoring chargeMonitoring(Integer siteId) {
|
//获取当前登录账户的站点权限数据
|
Set<Integer> siteIds = new HashSet<>();
|
if(null == siteId){
|
SysUser sysUser = sysUserClient.getSysUser(SecurityUtils.getUserId()).getData();
|
Integer roleType = sysUser.getRoleType();
|
Integer objectId = sysUser.getObjectId();
|
if(2 == roleType){
|
siteIds = partnerService.authSite(objectId, SiteMenu.SITE_LIST);
|
}else{
|
//非管理员需要根据角色和用户配置查询允许的站点数据
|
if(!SecurityUtils.isAdmin(SecurityUtils.getUserId())){
|
List<Integer> data = userSiteClient.getSiteIds(sysUser.getUserId()).getData();
|
List<Integer> data1 = roleSiteClient.getSiteIds(sysUser.getRoleId()).getData();
|
data.addAll(data1);
|
siteIds = new HashSet<>(data);
|
}
|
}
|
}else{
|
siteIds.add(siteId);
|
}
|
List<Site> sites = siteService.listByIds(siteIds);
|
List<TChargingGun> total = chargingGunService.list(new LambdaQueryWrapper<TChargingGun>().in(TChargingGun::getSiteId, siteIds).eq(TChargingGun::getDelFlag, 0));
|
List<TChargingGun> charging = chargingGunService.list(new LambdaQueryWrapper<TChargingGun>().in(TChargingGun::getSiteId, siteIds).eq(TChargingGun::getStatus, 4).eq(TChargingGun::getDelFlag, 0));
|
BigDecimal ratedPower = total.stream().map(TChargingGun::getRatedPower).reduce(BigDecimal.ZERO, BigDecimal::add);
|
BigDecimal realTimePower = charging.stream().map(TChargingGun::getChargingPower).reduce(BigDecimal.ZERO, BigDecimal::add);
|
|
ChargeMonitoring chargeMonitoring = new ChargeMonitoring();
|
chargeMonitoring.setPhone(sites.size() == 1 ? sites.get(0).getPhone() : "");
|
chargeMonitoring.setAddress(sites.size() == 1 ? sites.get(0).getAddress() : "");
|
chargeMonitoring.setTerminalTotal(total.size());
|
chargeMonitoring.setCharging(charging.size());
|
chargeMonitoring.setNotCharged(total.size() - charging.size());
|
chargeMonitoring.setRatedPower(ratedPower.setScale(4, RoundingMode.HALF_EVEN));
|
chargeMonitoring.setRealTimePower(realTimePower.setScale(4, RoundingMode.HALF_EVEN));
|
chargeMonitoring.setDemandPowerSatisfactionRate(realTimePower.divide(ratedPower).multiply(new BigDecimal(100)).setScale(2, RoundingMode.HALF_EVEN));
|
|
List<String> dates = new ArrayList<>();
|
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MMM-dd");
|
Calendar calendar = Calendar.getInstance();
|
for (int i = 6; i >= 0; i--) {
|
calendar.set(Calendar.DAY_OF_YEAR, calendar.get(Calendar.DAY_OF_YEAR) - i);
|
dates.add(sdf.format(calendar.getTime()));
|
}
|
List<List<Map<String, Object>>> value1 = chargingOrderAccountingStrategyClient.getTotalElectricQuantity(6, siteIds).getData();
|
Map<String, Object> chargeTrend = new HashMap<>();
|
chargeTrend.put("date", dates);
|
chargeTrend.put("value", value1);
|
chargeMonitoring.setChargeTrend(chargeTrend);
|
|
//每日利用率=当日充电度数/（总桩数量*桩总功率*24小时）
|
List<TChargingPile> list = this.list(new LambdaQueryWrapper<TChargingPile>().in(TChargingPile::getSiteId, siteIds).eq(TChargingPile::getDelFlag, 0));
|
BigDecimal v = list.stream().map(TChargingPile::getRatedPower).reduce(BigDecimal.ZERO, BigDecimal::add).setScale(4, RoundingMode.HALF_EVEN);
|
List<Double> data = chargingOrderAccountingStrategyClient.getDailyChargingDegree(6, siteIds).getData();
|
List<Double> value2 = new ArrayList<>();
|
for (Double datum : data) {
|
Double datum1 = new BigDecimal(datum).divide(new BigDecimal(list.size()).multiply(v).multiply(new BigDecimal(24))).setScale(2, BigDecimal.ROUND_HALF_EVEN).doubleValue();
|
value2.add(datum1);
|
}
|
Map<String, Object> utilizationTrend = new HashMap<>();
|
utilizationTrend.put("date", dates);
|
utilizationTrend.put("value", value2);
|
chargeMonitoring.setUtilizationTrend(utilizationTrend);
|
return chargeMonitoring;
|
}
|
|
/**
|
* 获取充电枪各种状态汇总
|
* @param siteId 站点id
|
* @return
|
*/
|
@Override
|
public ChargingGunCountMonitoring getChargingGunCountMonitoring(Integer siteId) {
|
//获取当前登录账户的站点权限数据
|
Set<Integer> siteIds = new HashSet<>();
|
if(null == siteId){
|
SysUser sysUser = sysUserClient.getSysUser(SecurityUtils.getUserId()).getData();
|
Integer roleType = sysUser.getRoleType();
|
Integer objectId = sysUser.getObjectId();
|
if(2 == roleType){
|
siteIds = partnerService.authSite(objectId, SiteMenu.SITE_LIST);
|
}else{
|
//非管理员需要根据角色和用户配置查询允许的站点数据
|
if(!SecurityUtils.isAdmin(SecurityUtils.getUserId())){
|
List<Integer> data = userSiteClient.getSiteIds(sysUser.getUserId()).getData();
|
List<Integer> data1 = roleSiteClient.getSiteIds(sysUser.getRoleId()).getData();
|
data.addAll(data1);
|
siteIds = new HashSet<>(data);
|
}
|
}
|
}else{
|
siteIds.add(siteId);
|
}
|
List<TChargingGun> list = chargingGunService.list(new LambdaQueryWrapper<TChargingGun>().in(TChargingGun::getSiteId, siteIds).eq(TChargingGun::getDelFlag, 0));
|
//空闲
|
long leisure = list.stream().filter(s -> s.getStatus().equals(2)).count();
|
//已插枪
|
long loaded = list.stream().filter(s -> Arrays.asList(3, 5, 6).contains(s.getStatus())).count();
|
//充电中
|
long charging = list.stream().filter(s -> s.getStatus().equals(4)).count();
|
//离网
|
long offline = list.stream().filter(s -> s.getStatus().equals(0)).count();
|
//故障
|
long breakdown = list.stream().filter(s -> s.getStatus().equals(7)).count();
|
ChargingGunCountMonitoring chargingGunCountMonitoring = new ChargingGunCountMonitoring();
|
chargingGunCountMonitoring.setLeisure(leisure);
|
chargingGunCountMonitoring.setLoaded(loaded);
|
chargingGunCountMonitoring.setCharging(charging);
|
chargingGunCountMonitoring.setOffline(offline);
|
chargingGunCountMonitoring.setBreakdown(breakdown);
|
return chargingGunCountMonitoring;
|
}
|
|
/**
|
* 获取充电枪监控数据
|
* @param query
|
* @return
|
*/
|
@Override
|
public PageInfo<ChargingGunMonitoring> getChargingGunMonitoring(GetChargingGunMonitoring query) {
|
//获取当前登录账户的站点权限数据
|
Set<Integer> siteIds = new HashSet<>();
|
if(null == query.getSiteId()){
|
SysUser sysUser = sysUserClient.getSysUser(SecurityUtils.getUserId()).getData();
|
Integer roleType = sysUser.getRoleType();
|
Integer objectId = sysUser.getObjectId();
|
if(2 == roleType){
|
siteIds = partnerService.authSite(objectId, SiteMenu.SITE_LIST);
|
}else{
|
//非管理员需要根据角色和用户配置查询允许的站点数据
|
if(!SecurityUtils.isAdmin(SecurityUtils.getUserId())){
|
List<Integer> data = userSiteClient.getSiteIds(sysUser.getUserId()).getData();
|
List<Integer> data1 = roleSiteClient.getSiteIds(sysUser.getRoleId()).getData();
|
data.addAll(data1);
|
siteIds = new HashSet<>(data);
|
}
|
}
|
}else{
|
siteIds.add(query.getSiteId());
|
}
|
// todo 待完善
|
if(null != query.getStatus() && 0 < query.getStatus().size()){
|
if(query.getStatus().contains(3)){
|
query.getStatus().add(6);
|
query.getStatus().add(7);
|
}
|
}
|
PageInfo<ChargingGunMonitoring> pageInfo = new PageInfo<>(query.getPageCurr(), query.getPageSize());
|
List<ChargingGunMonitoring> chargingGunMonitoring = this.baseMapper.getChargingGunMonitoring(pageInfo, siteIds, query);
|
for (ChargingGunMonitoring gunMonitoring : chargingGunMonitoring) {
|
Integer status = gunMonitoring.getStatus();
|
if(status == 5 || status == 6){
|
gunMonitoring.setStatus(3);
|
}
|
if(status == 4){
|
Integer id = gunMonitoring.getId();
|
//根据订单数据查询车牌号
|
TChargingOrder chargingOrder = chargingOrderClient.getOrderDetailByGunId(id).getData();
|
Long appUserCarId = chargingOrder.getAppUserCarId();
|
if(null != appUserCarId){
|
TAppUserCar tAppUserCar = appUserCarClient.getCarByIds(Arrays.asList(appUserCarId)).getData().get(0);
|
gunMonitoring.setLicensePlate(tAppUserCar.getLicensePlate());
|
}
|
}
|
}
|
return pageInfo.setRecords(chargingGunMonitoring);
|
}
|
}
|
