package com.ruoyi.chargingPile.controller; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.toolkit.Wrappers; import com.ruoyi.chargingPile.api.model.*; import com.ruoyi.chargingPile.api.query.TChargingGunQuery; import com.ruoyi.chargingPile.api.vo.TChargingGunVO; 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.model.TFaultMessage; import com.ruoyi.chargingPile.api.query.BatchSetAccountingStrategy; import com.ruoyi.chargingPile.api.query.PageChargingPileList; import com.ruoyi.chargingPile.api.vo.UpdateChargingPileStatusVo; 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.dto.ChargingPileBatchBuildDTO; import com.ruoyi.chargingPile.dto.ChargingPileImportDTO; import com.ruoyi.chargingPile.dto.ChargingPileImportResultDTO; import com.ruoyi.chargingPile.export.ChargingPileExport; import com.ruoyi.chargingPile.service.ISiteService; import com.ruoyi.chargingPile.service.TChargingGunService; import com.ruoyi.chargingPile.service.TChargingPileService; import com.ruoyi.chargingPile.service.TFaultMessageService; import com.ruoyi.common.core.domain.R; import com.ruoyi.common.core.utils.StringUtils; import com.ruoyi.common.core.utils.poi.ExcelUtil; import com.ruoyi.common.core.web.domain.AjaxResult; import com.ruoyi.common.core.web.page.PageInfo; import com.ruoyi.common.log.annotation.Log; import com.ruoyi.common.log.enums.BusinessType; import com.ruoyi.common.log.enums.OperatorType; import com.ruoyi.common.security.annotation.Logical; import com.ruoyi.common.security.annotation.RequiresPermissions; import com.ruoyi.integration.api.elutong.model.ConnectorStatusInfo; import com.ruoyi.integration.api.elutong.model.ConnectorStatusReq; import com.ruoyi.integration.api.feignClient.ChengDuJianGuanClient; import com.ruoyi.integration.api.feignClient.ELuTongClient; import com.ruoyi.integration.api.feignClient.TCECClient; import com.ruoyi.order.api.feignClient.ChargingOrderClient; import com.ruoyi.order.api.model.TChargingOrder; import com.ruoyi.order.api.vo.TChargingOrderVo; import io.swagger.annotations.Api; import io.swagger.annotations.ApiImplicitParam; import io.swagger.annotations.ApiImplicitParams; import io.swagger.annotations.ApiOperation; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.data.redis.core.RedisTemplate; import org.springframework.web.multipart.MultipartFile; import org.springframework.web.bind.annotation.*; import javax.annotation.Resource; import javax.servlet.http.HttpServletResponse; import java.time.LocalDateTime; import java.util.ArrayList; import java.util.Arrays; import java.util.Collections; import java.util.List; import java.util.Map; import java.util.Set; import java.util.stream.Collectors; /** *

* 充电桩 前端控制器 *

* * @author xiaochen * @since 2024-08-06 */ @Slf4j @Api(tags = "充电桩") @RestController @RequestMapping("/t-charging-pile") public class TChargingPileController { private final TChargingPileService chargingPileService; private final TChargingGunService chargingGunService; @Resource private RedisTemplate redisTemplate; @Resource private TFaultMessageService faultMessageService; @Resource private ChargingOrderClient chargingOrderClient; @Resource private TCECClient tcecClient; @Resource private ISiteService siteService; @Resource private ELuTongClient eLuTongClient; @Resource private ChengDuJianGuanClient chengDuJianGuanClient; @Autowired public TChargingPileController(TChargingPileService chargingPileService, TChargingGunService chargingGunService) { this.chargingPileService = chargingPileService; this.chargingGunService = chargingGunService; } /** * 临时添加充电桩 */ @PostMapping(value = "/addPileTemp") @ResponseBody public R addPileTemp(@RequestBody TChargingPile chargingPile){ chargingPileService.save(chargingPile); return R.ok(chargingPile.getId()); } /** * 查询充电桩列表 */ @ApiOperation(tags = {"小程序-充电桩"},value = "通过站点id查询充电桩列表") @GetMapping(value = "/list") @ApiImplicitParams({ @ApiImplicitParam(name = "siteId", value = "站点id") }) public AjaxResult> list(@RequestParam("siteId") Integer siteId) { return AjaxResult.ok(chargingPileService.list(Wrappers.lambdaQuery(TChargingPile.class) .eq(TChargingPile::getSiteId,siteId))); } /** * 查询充电桩列表 */ @ApiOperation(tags = {"通过充电桩id 查询充电枪列表"},value = "通过充电桩id 查询充电枪列表") @PostMapping(value = "/pileList") @ApiImplicitParams({ @ApiImplicitParam(name = "pileId", value = "充电桩id") }) public AjaxResult> pileList(@RequestParam("pileId") Integer pileId) { return AjaxResult.ok(chargingGunService.list(Wrappers.lambdaQuery(TChargingGun.class) .eq(TChargingGun::getChargingPileId,pileId))); } /** * 管理后台-通过站点id获取充电桩列表 不分页 */ @ApiOperation(value = "管理后台-通过站点id获取充电桩列表 不分页") @PostMapping(value = "/getChargingPileBySiteId") public R> getChargingPileBySiteId(@RequestParam("siteId") Integer siteId) { return R.ok(chargingPileService.list(Wrappers.lambdaQuery(TChargingPile.class) .eq(TChargingPile::getSiteId,siteId))); } @PostMapping(value = "/getChargingPileBySiteIds") public R> getChargingPileBySiteIds(@RequestParam("siteIds") List siteIds) { return R.ok(chargingPileService.list(Wrappers.lambdaQuery(TChargingPile.class) .in(!siteIds.isEmpty(),TChargingPile::getSiteId,siteIds).eq(TChargingPile::getDelFlag, 0))); } @RequiresPermissions(value = {"/chargingPile", "/chargingGun"}, logical = Logical.OR) @ResponseBody @GetMapping("/pageChargingPileList") @ApiOperation(value = "获取充电桩列表数据", tags = {"管理后台-充电桩信息"}) public AjaxResult> pageChargingPileList(PageChargingPileList page){ PageInfo list = chargingPileService.pageChargingPileList(page); return AjaxResult.success(list); } @RequiresPermissions(value = {"/chargingPile/add"}, logical = Logical.OR) @ResponseBody @Log(title = "【充电桩信息】添加充电桩数据", businessType = BusinessType.INSERT,operatorType = OperatorType.MANAGE) @PostMapping("/addChargingPile") @ApiOperation(value = "添加充电桩数据", tags = {"管理后台-充电桩信息"}) public AjaxResult addChargingPile(@RequestBody TChargingPile chargingPile){ return chargingPileService.addChargingPile(chargingPile); } @RequiresPermissions(value = {"/chargingPile/export", "/chargingPile"}, logical = Logical.OR) @ResponseBody @PutMapping("/export") @Log(title = "【充电桩信息】导出充电桩数据", businessType = BusinessType.EXPORT,operatorType = OperatorType.MANAGE) @ApiOperation(value = "导出充电桩数据", tags = {"管理后台-充电桩信息"}) public void export(@RequestBody PageChargingPileList page, HttpServletResponse response){ List records = chargingPileService.listChargingPileForExport(page); Set pileIds = records.stream() .map(PageChargingPileListDTO::getId) .filter(id -> id != null) .collect(Collectors.toSet()); Map pileMap = pileIds.isEmpty() ? Collections.emptyMap() : chargingPileService.listByIds(pileIds).stream() .collect(Collectors.toMap(TChargingPile::getId, item -> item, (left, right) -> left)); List guns = pileIds.isEmpty() ? Collections.emptyList() : chargingGunService.exportQRCodeList(new TChargingGunQuery()).stream() .filter(gun -> pileIds.contains(gun.getChargingPileId())) .collect(Collectors.toList()); Map> gunsByPile = guns.stream() .collect(Collectors.groupingBy(TChargingGunVO::getChargingPileId)); List exports = new ArrayList<>(); for (PageChargingPileListDTO record : records) { List pileGuns = gunsByPile.getOrDefault(record.getId(), Collections.emptyList()); if (pileGuns.isEmpty()) { exports.add(ChargingPileExport.from(record, pileMap.get(record.getId()), null)); continue; } for (TChargingGunVO gun : pileGuns) { exports.add(ChargingPileExport.from(record, pileMap.get(record.getId()), gun)); } } ExcelUtil util = new ExcelUtil<>(ChargingPileExport.class); util.exportExcel(response, exports, "充电桩数据"); } @RequiresPermissions(value = {"/chargingPile/add"}, logical = Logical.OR) @ResponseBody @GetMapping("/importTemplate") @ApiOperation(value = "下载充电桩导入模板", tags = {"管理后台-充电桩信息"}) public void importTemplate(HttpServletResponse response){ ExcelUtil util = new ExcelUtil<>(ChargingPileImportDTO.class); util.importTemplateExcel(response, "充电桩导入模板"); } @RequiresPermissions(value = {"/chargingPile/add"}, logical = Logical.OR) @ResponseBody @PostMapping("/import") @Log(title = "【充电桩信息】批量导入充电桩", businessType = BusinessType.IMPORT,operatorType = OperatorType.MANAGE) @ApiOperation(value = "批量导入充电桩", tags = {"管理后台-充电桩信息"}) public AjaxResult importChargingPile(@RequestParam("file") MultipartFile file, @RequestParam(value = "cover", defaultValue = "false") Boolean cover) throws Exception{ ChargingPileImportResultDTO result = chargingPileService.importChargingPile(file, cover); if(Boolean.TRUE.equals(result.getNeedConfirm())){ return AjaxResult.warn("检测到重复设备编码,是否覆盖?", result); } if(result.getErrorCount() != null && result.getErrorCount() > 0){ return AjaxResult.error("导入失败,请检查错误信息", result); } return AjaxResult.success("导入成功", result); } @RequiresPermissions(value = {"/chargingPile/add"}, logical = Logical.OR) @ResponseBody @PostMapping("/batchBuild") @Log(title = "【充电桩信息】批量建桩", businessType = BusinessType.INSERT,operatorType = OperatorType.MANAGE) @ApiOperation(value = "批量建桩", tags = {"管理后台-充电桩信息"}) public AjaxResult batchBuild(@RequestBody ChargingPileBatchBuildDTO dto){ return AjaxResult.success("批量建桩成功", chargingPileService.batchBuildChargingPile(dto)); } @RequiresPermissions(value = {"/chargingPile/select", "/chargingPile/update"}, logical = Logical.OR) @ResponseBody @GetMapping("/getChargingPile/{id}") @ApiOperation(value = "获取充电桩详情数据", tags = {"管理后台-充电桩信息"}) public AjaxResult getChargingPile(@PathVariable Integer id){ TChargingPile chargingPile = chargingPileService.getChargingPile(id); return AjaxResult.success(chargingPile); } @RequiresPermissions(value = {"/chargingPile/update"}, logical = Logical.OR) @ResponseBody @Log(title = "【充电桩信息】编辑充电桩数据", businessType = BusinessType.UPDATE,operatorType = OperatorType.MANAGE) @PostMapping("/editChargingPile") @ApiOperation(value = "编辑充电桩数据", tags = {"管理后台-充电桩信息"}) public AjaxResult editChargingPile(@RequestBody TChargingPile chargingPile){ return chargingPileService.editChargingPile(chargingPile); } @RequiresPermissions(value = {"/chargingPile/del", "/chargingPile/batch_del"}, logical = Logical.OR) @ResponseBody @DeleteMapping("/delChargingPile") @Log(title = "【充电桩信息】删除充电桩", businessType = BusinessType.DELETE,operatorType = OperatorType.MANAGE) @ApiOperation(value = "删除充电桩", tags = {"管理后台-充电桩信息"}) @ApiImplicitParams({ @ApiImplicitParam(value = "充电桩id", name = "id", dataTypeClass = Integer.class, required = true) }) public AjaxResult delChargingPile(@RequestParam("id") Integer[] id){ return chargingPileService.delChargingPile(id); } @RequiresPermissions(value = {"/chargingPile/accountingStrategy"}, logical = Logical.OR) @ResponseBody @Log(title = "【充电桩信息】批量设置计费策略", businessType = BusinessType.UPDATE,operatorType = OperatorType.MANAGE) @PostMapping("/batchSetAccountingStrategy") @ApiOperation(value = "批量设置计费策略", tags = {"管理后台-充电桩信息"}) public AjaxResult batchSetAccountingStrategy(@RequestBody BatchSetAccountingStrategy setAccountingStrategy){ chargingPileService.batchSetAccountingStrategy(setAccountingStrategy); return AjaxResult.success(); } @RequiresPermissions(value = {"/chargingEquipmentMonitoring", "/generalBigScreen", "/dataCockpit"}, logical = Logical.OR) @ResponseBody @GetMapping("/chargeMonitoring/{siteId}") @ApiOperation(value = "获取充电设施监控数据", tags = {"管理后台-充电设备监控"}) public AjaxResult chargeMonitoring(@PathVariable Integer siteId){ ChargeMonitoring chargeMonitoring = chargingPileService.chargeMonitoring(siteId); return AjaxResult.success(chargeMonitoring); } @ResponseBody @GetMapping("/screenChargeMonitoring/{siteId}") @ApiOperation(value = "获取智慧充电大屏监控数据", tags = {"管理后台-智慧充电大屏"}) public AjaxResult screenChargeMonitoring(@PathVariable Integer siteId){ return AjaxResult.success(chargingPileService.chargeMonitoringForScreen(siteId)); } @RequiresPermissions(value = {"/chargingEquipmentMonitoring"}, logical = Logical.OR) @ResponseBody @GetMapping("/getChargingMonitoringSiteList") @ApiOperation(value = "获取当前账号允许监控的站点", tags = {"管理后台-充电设备监控"}) public AjaxResult> getChargingMonitoringSiteList() { return AjaxResult.success(chargingPileService.getChargingMonitoringSiteList()); } @RequiresPermissions(value = {"/chargingEquipmentMonitoring", "/generalBigScreen", "/dataCockpit"}, logical = Logical.OR) @ResponseBody @GetMapping("/getChargingGunCountMonitoring/{siteId}") @ApiOperation(value = "获取充电枪各种状态汇总监控数据", tags = {"管理后台-充电设备监控"}) public AjaxResult getChargingGunCountMonitoring(@PathVariable Integer siteId){ ChargingGunCountMonitoring chargingGunCountMonitoring = chargingPileService.getChargingGunCountMonitoring(siteId); return AjaxResult.success(chargingGunCountMonitoring); } @RequiresPermissions(value = {"/operationMaintenanceAnalysis", "/chargingEquipmentMonitoring"}, logical = Logical.OR) @ResponseBody @GetMapping("/getChargingGunMonitoring") @ApiOperation(value = "获取充电枪监控数据", tags = {"管理后台-充电设备监控"}) public AjaxResult> getChargingGunMonitoring(GetChargingGunMonitoring query){ PageInfo chargingGunMonitoring = chargingPileService.getChargingGunMonitoring(query); return AjaxResult.success(chargingGunMonitoring); } /** * 根据id获取充电桩信息 * @param id * @return */ @ResponseBody @PostMapping("/getChargingPileById/{id}") public R getChargingPileById(@PathVariable("id") Integer id){ TChargingPile chargingPile = chargingPileService.getById(id); return R.ok(chargingPile); } /** * 更新充电桩状态 */ @ResponseBody @PostMapping("/updateChargingPileStatus") public void updateChargingPileStatus(@RequestBody UpdateChargingPileStatusVo vo){ String pile_code = vo.getPile_code(); String gun_code = vo.getGun_code(); //0:正常,1:故障,2=插枪 Integer status = vo.getStatus(); Long time = (Long) redisTemplate.opsForHash().get("charging_gun_online", (pile_code + gun_code)); //小于1分钟才处理数据,防止频繁查询数据 if(null != time && (System.currentTimeMillis() - time) < 30000){ return; } TChargingGun tChargingGun = chargingGunService.getOne(new LambdaQueryWrapper().eq(TChargingGun::getFullNumber, (pile_code + gun_code)).eq(TChargingGun::getDelFlag, 0)); if(null != tChargingGun){ redisTemplate.opsForHash().put("charging_gun_online", tChargingGun.getFullNumber(), System.currentTimeMillis()); //上传成都监管 chengDuJianGuanClient.notificationStationStatus(tChargingGun.getId()); TChargingPile chargingPile = chargingPileService.getById(tChargingGun.getChargingPileId()); //枪处于离线或者故障,返回状态为正常,则修改其状态 if(0 == status && tChargingGun.getStatus() != 2){ Site site = siteService.getById(tChargingGun.getSiteId()); TChargingGun tChargingGun1 = new TChargingGun(); tChargingGun1.setId(tChargingGun.getId()); tChargingGun1.setStatus(2); chargingGunService.updateById(tChargingGun1); if(site.getIsOpenSynchronization() == 1){ new Thread(new Runnable() { @Override public void run() { //推送状态给三方平台 tcecClient.pushChargingGunStatus(tChargingGun.getFullNumber(), 2); pushConnectorStatus(tChargingGun); } }).start(); } if(chargingPile.getStatus() != 1){ TChargingPile chargingPile1 = new TChargingPile(); chargingPile1.setId(chargingPile.getId()); chargingPile1.setStatus(1); chargingPileService.updateById(chargingPile1); } List list = faultMessageService.list(new LambdaQueryWrapper().eq(TFaultMessage::getChargingGunId, tChargingGun.getId()) .isNull(TFaultMessage::getEndTime)); if(!list.isEmpty()){ list.forEach(s->s.setEndTime(LocalDateTime.now())); faultMessageService.updateBatchById(list); } } //枪处于正常,返回状态为故障,则修改其状态 if(1 == status && tChargingGun.getStatus() != 1 && tChargingGun.getStatus() != 7){ Site site = siteService.getById(tChargingGun.getSiteId()); TChargingGun tChargingGun1 = new TChargingGun(); tChargingGun1.setId(tChargingGun.getId()); tChargingGun1.setStatus(7); chargingGunService.updateById(tChargingGun1); if(site.getIsOpenSynchronization() == 1){ new Thread(new Runnable() { @Override public void run() { //推送状态给三方平台 tcecClient.pushChargingGunStatus(tChargingGun.getFullNumber(), 7); pushConnectorStatus(tChargingGun); } }).start(); } //桩处于正常,桩所属的枪都处于非正常,修改桩状态为异常 List list = chargingGunService.list(new LambdaQueryWrapper().eq(TChargingGun::getChargingPileId, chargingPile.getId()).eq(TChargingGun::getDelFlag, 0)); int size = list.stream().filter(s -> s.getStatus() == 1 || s.getStatus() == 7).collect(Collectors.toList()).size(); if(chargingPile.getStatus() == 1 && list.size() == size){ TChargingPile chargingPile1 = new TChargingPile(); chargingPile1.setId(chargingPile.getId()); chargingPile1.setStatus(3); chargingPileService.updateById(chargingPile1); } TFaultMessage faultMessage = new TFaultMessage(); faultMessage.setSiteId(chargingPile.getSiteId()); faultMessage.setChargingPileId(chargingPile.getId()); faultMessage.setChargingGunId(tChargingGun.getId()); faultMessage.setStatus(2); faultMessage.setDownTime(LocalDateTime.now()); faultMessage.setCreateTime(LocalDateTime.now()); faultMessage.setDelFlag(false); faultMessage.setContent("设备故障"); faultMessageService.save(faultMessage); } if(2 == status && !Arrays.asList(3, 4, 5).contains(tChargingGun.getStatus())){ TChargingOrderVo order = new TChargingOrderVo(); order.setChargingPileId(tChargingGun.getChargingPileId()); order.setChargingGunId(tChargingGun.getId()); order.setStatusList(Arrays.asList(1, 2, 3, 4, 5)); List orders = chargingOrderClient.getChargingOrder(order).getData(); if(orders.size() > 0){ Site site = siteService.getById(tChargingGun.getSiteId()); TChargingOrder chargingOrder = orders.get(0); TChargingGun tChargingGun1 = new TChargingGun(); if(Arrays.asList(1, 2, 5).contains(chargingOrder.getStatus())){ tChargingGun1.setStatus(3); tChargingGun1.setId(tChargingGun.getId()); chargingGunService.updateById(tChargingGun1); } if(Arrays.asList(3).contains(chargingOrder.getStatus())){ tChargingGun1.setStatus(4); tChargingGun1.setId(tChargingGun.getId()); chargingGunService.updateById(tChargingGun1); } if(Arrays.asList(4).contains(chargingOrder.getStatus()) && chargingOrder.getEndMode() == 2){ tChargingGun1.setStatus(5); tChargingGun1.setId(tChargingGun.getId()); chargingGunService.updateById(tChargingGun1); } if(site.getIsOpenSynchronization() == 1){ new Thread(new Runnable() { @Override public void run() { //推送状态给三方平台 tcecClient.pushChargingGunStatus(tChargingGun.getFullNumber(), 5); pushConnectorStatus(tChargingGun); } }).start(); } }else{ Site site = siteService.getById(tChargingGun.getSiteId()); TChargingGun tChargingGun1 = new TChargingGun(); tChargingGun1.setId(tChargingGun.getId()); tChargingGun1.setStatus(3); chargingGunService.updateById(tChargingGun1); if(site.getIsOpenSynchronization() == 1){ new Thread(new Runnable() { @Override public void run() { //推送状态给三方平台 tcecClient.pushChargingGunStatus(tChargingGun.getFullNumber(), 3); pushConnectorStatus(tChargingGun); } }).start(); } } List list = faultMessageService.list(new LambdaQueryWrapper().eq(TFaultMessage::getChargingGunId, tChargingGun.getId()) .isNull(TFaultMessage::getEndTime)); if(!list.isEmpty()){ list.forEach(s->s.setEndTime(LocalDateTime.now())); faultMessageService.updateBatchById(list); } } } } @ResponseBody @PostMapping("/getAllPile") public R> getAllPile(){ List pileList = chargingPileService.list(); return R.ok(pileList); } /** * 推送设备接口状态信息 * @param chargingGun */ private void pushConnectorStatus(TChargingGun chargingGun){ Site site = siteService.getById(chargingGun.getSiteId()); if(StringUtils.isNotEmpty(site.getSerAreaCode())){ ConnectorStatusReq connectorStatusReq = new ConnectorStatusReq(); connectorStatusReq.setOperatorId("91510903906171535D"); connectorStatusReq.setSerAreaCode(site.getSerAreaCode()); connectorStatusReq.setStationId(site.getCode()); List connectorStatusInfos = new ArrayList<>(); connectorStatusInfos.add(buildConnectorStatus(chargingGun)); connectorStatusReq.setItemSize(connectorStatusInfos.size()); connectorStatusReq.setConnectorStatusInfos(connectorStatusInfos); R r = eLuTongClient.pushConnectorStatus(connectorStatusReq); if(200 != r.getCode()){ log.error(r.getMsg()); } } } private ConnectorStatusInfo buildConnectorStatus(TChargingGun chargingGun){ ConnectorStatusInfo connectorStatusInfo = new ConnectorStatusInfo(); connectorStatusInfo.setConnectorId(chargingGun.getFullNumber()); switch (chargingGun.getStatus()){ case 1: connectorStatusInfo.setStatus(0); break; case 2: connectorStatusInfo.setStatus(1); break; case 3: connectorStatusInfo.setStatus(2); break; case 4: connectorStatusInfo.setStatus(3); break; case 5: connectorStatusInfo.setStatus(3); break; case 6: connectorStatusInfo.setStatus(4); break; case 7: connectorStatusInfo.setStatus(255); break; } connectorStatusInfo.setSoc(0D); connectorStatusInfo.setRemainingTime(0); return connectorStatusInfo; } }