From 72a76cd3ad51a520100ec59481d99118ffebd33c Mon Sep 17 00:00:00 2001 From: Pu Zhibing <393733352@qq.com> Date: 星期一, 28 十月 2024 15:18:50 +0800 Subject: [PATCH] 合并代码 --- ruoyi-service/ruoyi-chargingPile/src/main/java/com/ruoyi/chargingPile/controller/TApplyChargingPileController.java | 123 ++++++++++++++++++++++++++++++++++++----- 1 files changed, 108 insertions(+), 15 deletions(-) diff --git a/ruoyi-service/ruoyi-chargingPile/src/main/java/com/ruoyi/chargingPile/controller/TApplyChargingPileController.java b/ruoyi-service/ruoyi-chargingPile/src/main/java/com/ruoyi/chargingPile/controller/TApplyChargingPileController.java index e5d620f..4170703 100644 --- a/ruoyi-service/ruoyi-chargingPile/src/main/java/com/ruoyi/chargingPile/controller/TApplyChargingPileController.java +++ b/ruoyi-service/ruoyi-chargingPile/src/main/java/com/ruoyi/chargingPile/controller/TApplyChargingPileController.java @@ -1,12 +1,18 @@ package com.ruoyi.chargingPile.controller; +import java.time.LocalDateTime; import java.math.BigDecimal; import com.ruoyi.chargingPile.api.feignClient.SiteClient; import com.ruoyi.chargingPile.api.model.Partner; import com.ruoyi.chargingPile.api.model.Site; +import com.ruoyi.common.core.utils.WebUtils; +import com.ruoyi.common.core.web.domain.BasePojo; import com.ruoyi.common.core.web.page.PageInfo; +import com.ruoyi.order.api.model.ExportUidDto; +import com.ruoyi.order.api.feignClient.OrderClient; import com.ruoyi.order.api.model.TChargingOrder; import com.ruoyi.order.api.model.TSettlementConfirm; +import com.ruoyi.order.api.vo.AccountListVO; import com.ruoyi.order.api.vo.ChargingBillListVO; @@ -40,6 +46,7 @@ import com.ruoyi.order.api.feignClient.ChargingOrderClient; import com.ruoyi.order.api.model.ChargingListQuery; import com.ruoyi.order.api.vo.ChargingBillVO; +import com.ruoyi.order.api.vo.SettlementTotalVO; import io.swagger.annotations.ApiOperation; import org.apache.commons.codec.CharEncoding; import org.springframework.beans.BeanUtils; @@ -56,6 +63,7 @@ import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Arrays; +import java.util.LinkedList; import java.util.List; import java.util.regex.Pattern; @@ -77,6 +85,8 @@ @Resource private ChargingOrderClient chargingOrderClient; @Resource + private OrderClient orderClient; + @Resource private SiteClient siteClient; @Autowired @@ -89,12 +99,16 @@ /** * 建桩申请 */ - @Log(title = "建桩申请", businessType = BusinessType.INSERT,operatorType = OperatorType.MOBILE) @ApiOperation(tags = {"小程序-建桩申请"},value = "建桩申请") @PostMapping(value = "/add") public AjaxResult<Boolean> add(@RequestBody TApplyChargingPileDTO dto) { // 验证验证码 - String code = redisService.getCacheObject(dto.getLandlordPhone() + Constants.APPLY_CHARGING); + String code; + if(dto.getLandlordHandling().equals(1)){ + code = redisService.getCacheObject(dto.getLandlordPhone() + Constants.APPLY_CHARGING); + }else { + code = redisService.getCacheObject(dto.getAgentPhone() + Constants.APPLY_CHARGING); + } if(StringUtils.isEmpty(code)){ return AjaxResult.error("验证码已过期,请重新获取验证码!"); } @@ -107,7 +121,7 @@ return AjaxResult.ok(applyChargingPileService.save(dto)); } - @Log(title = "建桩申请", businessType = BusinessType.INSERT,operatorType = OperatorType.MOBILE) + @Log(title = "【申请建桩】添加建桩申请", businessType = BusinessType.INSERT) @ApiOperation(tags = {"后台-申请表单-申请建桩"},value = "建桩申请") @PostMapping(value = "/manage/add") public AjaxResult<Boolean> manageAdd(@RequestBody TApplyChargingPile dto) { @@ -117,9 +131,10 @@ @ApiOperation(tags = {"后台-申请表单-申请建桩"},value = "列表") @PostMapping(value = "/page") - public AjaxResult<Page<TApplyChargingPile>> page(ApplyChargingQuery applyChargingQuery) { + public AjaxResult<Page<TApplyChargingPile>> page(@RequestBody ApplyChargingQuery applyChargingQuery) { Page<TApplyChargingPile> page = applyChargingPileService.lambdaQuery() .like(applyChargingQuery.getLandlordPhone() != null && !applyChargingQuery.getLandlordPhone().equals(""), TApplyChargingPile::getLandlordPhone, applyChargingQuery.getLandlordPhone()) + .orderByDesc(BasePojo::getCreateTime ) .page(Page.of(applyChargingQuery.getPageCurr(), applyChargingQuery.getPageSize())); return AjaxResult.ok(page); } @@ -127,6 +142,7 @@ @ApiOperation(tags = {"后台-申请表单-申请建桩"},value = "导出") @PutMapping(value = "/export") + @Log(title = "【申请建桩】导出建桩申请列表", businessType = BusinessType.EXPORT) public R export(String landlordPhone,HttpServletResponse response) { try { response.setCharacterEncoding(Constants.UTF8); @@ -220,9 +236,7 @@ applyChargingPileExportDto.setIs3("否"); } exportDtos.add(applyChargingPileExportDto); - } - // excel模板封装 ExcelWriterBuilder excelWriterBuilder = EasyExcelFactory.write(response.getOutputStream()); InputStream stream = Thread.currentThread().getContextClassLoader().getResourceAsStream("template/" +"充电桩申请记录" + ".xlsx"); @@ -241,11 +255,12 @@ } @ApiOperation(value = "下载-已出账", tags = {"管理后台-充电算账单"}) - @GetMapping("/downloadBill") - public R downloadBill(String uid,HttpServletResponse response) + @PutMapping("/downloadBill") + @Log(title = "【充电算账单】下载算账单", businessType = BusinessType.EXPORT) + public R downloadBill(@RequestBody ExportUidDto uid, HttpServletResponse response) { ChargingListQuery chargingListQuery = new ChargingListQuery(); - chargingListQuery.setUid(uid); + chargingListQuery.setUid(uid.getUid()); chargingListQuery.setPageCurr(1); chargingListQuery.setPageSize(99999); ChargingBillVO data = chargingOrderClient.chargingBillListR(chargingListQuery).getData(); @@ -280,11 +295,83 @@ } return R.ok(); } - @ApiOperation(value = "下载", tags = {"管理后台-结算表记录"}) - @GetMapping("/downloadSettlement") - public R downloadSettlement(String uid,HttpServletResponse response) + @ApiOperation(value = "下载", tags = {"管理后台-账户结算账单"}) + @PutMapping("/downloadAccount") + @Log(title = "【账户结算账单】下载账单", businessType = BusinessType.EXPORT) + public R downloadAccount(@RequestBody ChargingListQuery dto,HttpServletResponse response) + { dto.setPageCurr(1); + dto.setPageSize(99999999); + AccountListVO data = orderClient.accountBillList(dto).getData(); + try { + response.setCharacterEncoding(Constants.UTF8); + response.setContentType("application/vnd.ms-excel"); + response.setHeader("Access-Control-Expose-Headers", "Content-disposition"); + response.setHeader("Content-Disposition", "attachment;filename=" + + URLEncoder.encode("账户结算账单", CharEncoding.UTF_8) + ".xlsx"); + } catch (UnsupportedEncodingException e) { + return R.fail("excel导出失败!"); + } + try { + // excel模板封装 + ExcelWriterBuilder excelWriterBuilder = EasyExcelFactory.write(response.getOutputStream()); + InputStream stream = Thread.currentThread().getContextClassLoader().getResourceAsStream("template/" +"账户结算账单" + ".xlsx"); + // 自动释放资源 + try (ExcelWriter excelWriter = excelWriterBuilder.withTemplate(stream).build()) { + WriteSheet writeSheet = EasyExcel.writerSheet().build(); + FillConfig fillConfig = FillConfig.builder().direction(WriteDirectionEnum.VERTICAL).build(); + excelWriter.fill(new FillWrapper("data1", data.getList().getRecords()), fillConfig, writeSheet); + excelWriter.finish(); + } catch (Exception e) { + return R.fail("excel导出失败!"); + } + } catch (IOException e) { + return R.fail("excel导出失败!"); + } + return R.ok(); + } + + @ApiOperation(value = "导出", tags = {"管理后台-结算汇总表"}) + @PutMapping("/downloadSettlementTotal") + @Log(title = "【结算汇总表】下载汇总表", businessType = BusinessType.EXPORT) + public R downloadSettlementTotal(@RequestBody ExportUidDto uid,HttpServletResponse response) { - TSettlementConfirm data = chargingOrderClient.downloadSettlement(uid).getData(); + SettlementTotalVO data = chargingOrderClient.settlementTotalR(uid.getTime()).getData(); + + + try { + response.setCharacterEncoding(Constants.UTF8); + response.setContentType("application/vnd.ms-excel"); + response.setHeader("Access-Control-Expose-Headers", "Content-disposition"); + response.setHeader("Content-Disposition", "attachment;filename=" + + URLEncoder.encode("结算确认单", CharEncoding.UTF_8) + ".xlsx"); + } catch (UnsupportedEncodingException e) { + return R.fail("excel导出失败!"); + } + try { + // excel模板封装 + ExcelWriterBuilder excelWriterBuilder = EasyExcelFactory.write(response.getOutputStream()); + InputStream stream = Thread.currentThread().getContextClassLoader().getResourceAsStream("template/" +"结算汇总" + ".xlsx"); + // 自动释放资源 + try (ExcelWriter excelWriter = excelWriterBuilder.withTemplate(stream).build()) { + WriteSheet writeSheet = EasyExcel.writerSheet().build(); + FillConfig fillConfig = FillConfig.builder().direction(WriteDirectionEnum.VERTICAL).build(); + excelWriter.fill(new FillWrapper("data1", data.getList1()), fillConfig, writeSheet); + excelWriter.fill(new FillWrapper("data2", data.getList2()), fillConfig, writeSheet); + excelWriter.finish(); + } catch (Exception e) { + return R.fail("excel导出失败!"); + } + } catch (IOException e) { + return R.fail("excel导出失败!"); + } + return R.ok(); + } + @ApiOperation(value = "下载", tags = {"管理后台-结算表记录"}) + @PutMapping("/downloadSettlement") + @Log(title = "【结算表记录】下载结算表", businessType = BusinessType.EXPORT) + public R downloadSettlement(@RequestBody ExportUidDto uid,HttpServletResponse response) + { + TSettlementConfirm data = chargingOrderClient.downloadSettlement(uid.getUid()).getData(); List<Site> data1 = siteClient.getSiteByIds(Arrays.asList(data.getSiteId())).getData(); if (!data1.isEmpty()){ data.setSiteName(data1.get(0).getName()); @@ -311,9 +398,12 @@ // 自动释放资源 try (ExcelWriter excelWriter = excelWriterBuilder.withTemplate(stream).build()) { WriteSheet writeSheet = EasyExcel.writerSheet().build(); + WriteSheet writeSheet2 = EasyExcel.writerSheet().build(); + WriteSheet writeSheet3 = EasyExcel.writerSheet().build(); FillConfig fillConfig = FillConfig.builder().direction(WriteDirectionEnum.HORIZONTAL).build(); excelWriter.fill(new FillWrapper("data1", chargingBillVOS), fillConfig, writeSheet); - excelWriter.fill(new FillWrapper("data2", chargingBillVOS), fillConfig, writeSheet); + excelWriter.fill(new FillWrapper("data2", chargingBillVOS), fillConfig, writeSheet2); + excelWriter.fill(new FillWrapper("data3", data.getList()), fillConfig, writeSheet3); excelWriter.finish(); } catch (Exception e) { return R.fail("excel导出失败!"); @@ -330,7 +420,8 @@ @ApiOperation(value = "下载-未出账", tags = {"管理后台-充电算账单"}) - @GetMapping("/download") + @PutMapping("/download") + @Log(title = "【充电算账单】下载算账单", businessType = BusinessType.EXPORT) public R download(String uid,HttpServletResponse response) { ChargingListQuery chargingListQuery = new ChargingListQuery(); @@ -387,6 +478,7 @@ @ApiOperation(tags = {"后台-申请表单-申请建桩"},value = "修改备注") @PostMapping(value = "/remark") + @Log(title = "【申请建桩】修改备注", businessType = BusinessType.UPDATE) public AjaxResult<TApplyChargingPile> remark(@RequestBody ApplyChargingRemarkDto applyChargingRemarkDt) { TApplyChargingPile byId = applyChargingPileService.getById(applyChargingRemarkDt.getId()); byId.setRemark(applyChargingRemarkDt.getRemark()); @@ -395,6 +487,7 @@ } @ApiOperation(tags = {"后台-申请表单-申请建桩"},value = "删除") @DeleteMapping(value = "/remark") + @Log(title = "【申请建桩】删除建桩申请", businessType = BusinessType.DELETE) public AjaxResult remark(String ids) { String[] split = ids.split(","); -- Gitblit v1.7.1