package com.ruoyi.order.controller;
|
|
|
import cn.afterturn.easypoi.excel.ExcelExportUtil;
|
import cn.afterturn.easypoi.excel.entity.ExportParams;
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.ruoyi.account.api.feignClient.AppUserCarClient;
|
import com.ruoyi.account.api.feignClient.AppUserClient;
|
import com.ruoyi.account.api.model.TAppUser;
|
import com.ruoyi.account.api.model.TAppUserCar;
|
import com.ruoyi.chargingPile.api.feignClient.ChargingGunClient;
|
import com.ruoyi.chargingPile.api.feignClient.SiteClient;
|
import com.ruoyi.chargingPile.api.model.Partner;
|
import com.ruoyi.chargingPile.api.model.Site;
|
import com.ruoyi.chargingPile.api.model.TChargingGun;
|
import com.ruoyi.common.core.domain.R;
|
import com.ruoyi.common.core.utils.DateUtils;
|
import com.ruoyi.common.core.utils.WebUtils;
|
import com.ruoyi.common.core.web.domain.AjaxResult;
|
import com.ruoyi.common.core.web.page.PageInfo;
|
import com.ruoyi.common.security.annotation.Logical;
|
import com.ruoyi.common.security.annotation.RequiresPermissions;
|
import com.ruoyi.integration.api.feignClient.UploadRealTimeMonitoringDataClient;
|
import com.ruoyi.order.api.dto.SettlementConfirmAdd;
|
import com.ruoyi.order.api.model.*;
|
import com.ruoyi.order.api.query.SettlementListQuery;
|
import com.ruoyi.order.api.vo.ChargingOrderListVO;
|
import com.ruoyi.order.api.vo.ChargingOrderTimeVO;
|
import com.ruoyi.order.api.vo.SettlementTotalVO;
|
import com.ruoyi.order.export.TChargingOrderExport;
|
import com.ruoyi.order.service.*;
|
import com.ruoyi.order.vo.ChargingOrderListInfoVO;
|
import com.ruoyi.other.api.domain.TVip;
|
import com.ruoyi.other.api.feignClient.VipClient;
|
import io.swagger.annotations.Api;
|
import io.swagger.annotations.ApiOperation;
|
import io.swagger.annotations.ApiParam;
|
import org.apache.poi.ss.usermodel.*;
|
import org.apache.poi.ss.util.CellRangeAddress;
|
import org.springframework.web.bind.annotation.*;
|
|
import javax.annotation.Resource;
|
import javax.servlet.ServletOutputStream;
|
import javax.servlet.http.HttpServletResponse;
|
import java.io.IOException;
|
import java.math.BigDecimal;
|
import java.math.RoundingMode;
|
import java.net.URLEncoder;
|
import java.time.LocalDateTime;
|
import java.time.format.DateTimeFormatter;
|
import java.time.temporal.ChronoUnit;
|
import java.util.ArrayList;
|
import java.util.List;
|
import java.util.stream.Collectors;
|
|
/**
|
* <p>
|
* 前端控制器
|
* </p>
|
*
|
* @author xiaochen
|
* @since 2024-08-07
|
*/
|
@Api(tags = "财务结算")
|
@RestController
|
@RequestMapping("/financial/settlement")
|
public class FinancialSettlementController {
|
|
@Resource
|
private TChargingOrderService chargingOrderService;
|
@Resource
|
private TCardChargingOrderService cardChargingOrderService;
|
@Resource
|
private TChargingOrderRefundService chargingOrderRefundService;
|
|
@Resource
|
private TSettlementConfirmService tSettlementConfirmService;
|
@Resource
|
private VipClient vipClient;
|
@Resource
|
private SiteClient siteClient;
|
@Resource
|
private AppUserClient appUserClient;
|
@Resource
|
private ChargingGunClient chargingGunClient;
|
@Resource
|
private AppUserCarClient appUserCarClient;
|
@Resource
|
private AccountingStrategyOrderService accountingStrategyOrderService;
|
@Resource
|
private TChargingOrderAccountingStrategyService tChargingOrderAccountingStrategyService;
|
|
|
|
@RequiresPermissions(value = {"/chargingPeriodStatistics"}, logical = Logical.OR)
|
@PostMapping(value = "/chargingList")
|
@ApiOperation(value = "充电时段统计列表", tags = {"管理后台-财务结算"})
|
public AjaxResult<ChargingOrderTimeVO> chargingList(@RequestBody ChargingListQuery dto) {
|
ChargingOrderTimeVO res = chargingOrderService.chargingList(dto);
|
return AjaxResult.success(res);
|
}
|
|
@RequiresPermissions(value = {"/chargingPeriodStatistics"}, logical = Logical.OR)
|
@PostMapping(value = "/chargingList/page")
|
@ApiOperation(value = "充电时段统计分页列表", tags = {"管理后台-财务结算"})
|
public AjaxResult<PageInfo<ChargingOrderListVO>> chargingListPage(@RequestBody ChargingListQuery dto) {
|
return AjaxResult.success(chargingOrderService.chargingListPage(dto));
|
}
|
|
@RequiresPermissions(value = {"/chargingPeriodStatistics"}, logical = Logical.OR)
|
@PostMapping(value = "/chargingList/summary")
|
@ApiOperation(value = "充电时段统计汇总", tags = {"管理后台-财务结算"})
|
public AjaxResult<ChargingOrderTimeVO> chargingListSummary(@RequestBody ChargingListQuery dto) {
|
return AjaxResult.success(chargingOrderService.chargingListSummary(dto));
|
}
|
|
|
@RequiresPermissions(value = {"/chargingPeriodStatistics/order_info", "/chargingPeriodStatistics/charging_curve"}, logical = Logical.OR)
|
@GetMapping(value = "/chargingInfo")
|
@ApiOperation(value = "充电时段统计列表-查看详情", tags = {"管理后台-财务结算"})
|
public AjaxResult<?> chargingInfo(String uid, String orderType) {
|
if ("card".equalsIgnoreCase(orderType)) {
|
try {
|
Long chargingOrderId = Long.valueOf(uid);
|
return AjaxResult.success(cardChargingOrderService.detail(chargingOrderId));
|
} catch (NumberFormatException e) {
|
return AjaxResult.error("刷卡订单编号无效");
|
}
|
}
|
ChargingOrderListInfoVO res = chargingOrderService.chargingInfo(uid);
|
return AjaxResult.success(res);
|
}
|
|
@RequiresPermissions(value = {"/chargingPeriodStatistics/export"}, logical = Logical.OR)
|
@ApiOperation(value = "充电时段统计-导出", tags = {"管理后台-财务结算"})
|
@PutMapping("/export")
|
public void export(@RequestBody ChargingListQuery dto) {
|
List<TChargingOrderExport> tChargingOrderExports = new ArrayList<>();
|
List<ChargingOrderListVO> exportList = chargingOrderService.export(dto);
|
int i = 1;
|
List<TChargingGun> data = chargingGunClient.getAllGun().getData();
|
List<Site> data9 = siteClient.getSiteAll().getData();
|
List<TAppUser> data6 = appUserClient.getAllUser().getData();
|
List<Partner> data7 = siteClient.getAllPartner().getData();
|
// List<Long> collect = exportList.stream().map(ChargingOrderListVO::getId).collect(Collectors.toList());
|
// List<TChargingOrderAccountingStrategy> stageCostAll = tChargingOrderAccountingStrategyService.list(new QueryWrapper<TChargingOrderAccountingStrategy>()
|
// .in("charging_order_id", collect));
|
List<TVip> data5 = vipClient.getAllVip().getData();
|
List<TAppUserCar> data8 = appUserCarClient.getAllCar().getData();
|
for (ChargingOrderListVO chargingOrderListVO : exportList) {
|
TChargingOrderExport tChargingOrderExport = new TChargingOrderExport();
|
Site site = data9.stream().filter(e -> e.getId().equals(chargingOrderListVO.getSiteId())).findFirst().orElse(null);
|
TAppUser data3 = data6.stream().filter(e->e.getId().equals(chargingOrderListVO.getAppUserId())).findFirst().orElse(null);
|
TChargingGun data4 = data.stream().filter(e->e.getId().equals(chargingOrderListVO.getChargingGunId())).findFirst().orElse(null);
|
if (site!=null){
|
tChargingOrderExport.setSiteCode(site.getCode());
|
tChargingOrderExport.setSiteName(chargingOrderListVO.getSiteName());
|
tChargingOrderExport.setCity(site.getCity());
|
tChargingOrderExport.setCityName(site.getDistricts());
|
tChargingOrderExport.setSiteType(site.getSiteType());
|
tChargingOrderExport.setStatus(site.getStatus()+"");
|
Partner data2 = data7.stream().filter(e->e.getId().equals(site.getPartnerId())).findFirst().orElse(null);
|
if (data2!=null){
|
tChargingOrderExport.setPartner(data2.getName());
|
}
|
}
|
tChargingOrderExport.setSaleType("1");
|
tChargingOrderExport.setBusinessCategory("1");
|
tChargingOrderExport.setId(i);
|
tChargingOrderExport.setCode(chargingOrderListVO.getCode());
|
tChargingOrderExport.setCouponSource(chargingOrderListVO.getCouponSource());
|
tChargingOrderExport.setActualVin(chargingOrderListVO.getActualVin());
|
tChargingOrderExport.setTerminalName(chargingOrderListVO.getTerminalName());
|
tChargingOrderExport.setName(chargingOrderListVO.getAccountingStrategyName());
|
tChargingOrderExport.setOrderClassification("1");
|
tChargingOrderExport.setStartType("扫码");
|
tChargingOrderExport.setOne("小程序");
|
if (chargingOrderListVO.getRechargePaymentType()!=null){
|
if (chargingOrderListVO.getOrderSource()!=null&&chargingOrderListVO.getOrderSource().equals(2)){
|
if (chargingOrderListVO.getTripartitePlatformName().equals("XinDianTu")){
|
tChargingOrderExport.setTwo("新电途");
|
tChargingOrderExport.setOne("互联互通");
|
|
}
|
if (chargingOrderListVO.getTripartitePlatformName().equals("KuaiDian")){
|
tChargingOrderExport.setTwo("快电");
|
tChargingOrderExport.setOne("互联互通");
|
|
}
|
}else{
|
switch (chargingOrderListVO.getRechargePaymentType()){
|
case 1:
|
tChargingOrderExport.setTwo("微信小程序");
|
break;
|
case 2:
|
tChargingOrderExport.setTwo("支付宝小程序");
|
break;
|
}
|
}
|
|
}
|
tChargingOrderExport.setPaymentMethod(getPaymentMethod(chargingOrderListVO));
|
tChargingOrderExport.setCashPayAmount(formatMoney(getCashPayAmount(chargingOrderListVO)));
|
tChargingOrderExport.setBalancePayAmount(formatMoney(getBalancePayAmount(chargingOrderListVO)));
|
if (chargingOrderListVO.getCreateTime()!=null){
|
String s1 = DateUtils.localDateTimeToString(chargingOrderListVO.getCreateTime());
|
tChargingOrderExport.setCreateTime(s1);
|
}
|
if (chargingOrderListVO.getStartTime()!=null){
|
String s2 = DateUtils.localDateTimeToString(chargingOrderListVO.getStartTime());
|
tChargingOrderExport.setStartTime(s2);
|
}
|
if (chargingOrderListVO.getEndTime()!=null){
|
String s3 = DateUtils.localDateTimeToString(chargingOrderListVO.getEndTime());
|
tChargingOrderExport.setEndTime(s3);
|
}
|
tChargingOrderExport.setRechargePaymentStatus(chargingOrderListVO.getRechargePaymentStatus()+"");
|
tChargingOrderExport.setType("充电订单");
|
tChargingOrderExport.setChargingType("单桩双充");
|
tChargingOrderExport.setEndmode(formatChargingEndMode(chargingOrderListVO.getEndMode()));
|
tChargingOrderExport.setChargingEndAccount("平台");
|
tChargingOrderExport.setIsFree("否");
|
tChargingOrderExport.setElectrovalence(chargingOrderListVO.getElectrovalence()+"");
|
tChargingOrderExport.setServiceCharge(chargingOrderListVO.getServiceCharge()+"");
|
tChargingOrderExport.setTotal(chargingOrderListVO.getPaymentAmount()+"");
|
tChargingOrderExport.setChargingCapacity(chargingOrderListVO.getElectricity()+"");
|
// List<TChargingOrderAccountingStrategy> stageCost = stageCostAll.stream().filter(e -> e.getChargingOrderId().equals(chargingOrderListVO.getId())).collect(Collectors.toList());
|
// if (!stageCost.isEmpty()){
|
// // 累加时段电费单价 取平均值
|
// BigDecimal bigDecimal1 = new BigDecimal("0");
|
// BigDecimal bigDecimal2 = new BigDecimal("0");
|
// BigDecimal bigDecimal3 = new BigDecimal("0");
|
// BigDecimal size = new BigDecimal(stageCost.size());
|
//
|
// for (TChargingOrderAccountingStrategy tChargingOrderAccountingStrategy : stageCost) {
|
// bigDecimal1 = bigDecimal1.add(tChargingOrderAccountingStrategy.getPeriodElectricPrice());
|
// bigDecimal2 = bigDecimal2.add(tChargingOrderAccountingStrategy.getPeriodServicePrice());
|
// bigDecimal3 = bigDecimal3.add(tChargingOrderAccountingStrategy.getPeriodOriginalServicePrice());
|
// }
|
// BigDecimal divide1 = bigDecimal1.divide(size, 2, RoundingMode.HALF_DOWN);
|
// BigDecimal divide2 = bigDecimal2.divide(size, 2, RoundingMode.HALF_DOWN);
|
// BigDecimal divide3 = bigDecimal3.divide(size, 2, RoundingMode.HALF_DOWN);
|
// tChargingOrderExport.setElectrovalencePrice(divide1+"");
|
// tChargingOrderExport.setServiceChargePrice(divide2+"");
|
// tChargingOrderExport.setServiceChargePriceLook(divide3+"");
|
// }
|
tChargingOrderExport.setElectrovalencePrice("");
|
tChargingOrderExport.setServiceChargePrice("");
|
tChargingOrderExport.setServiceChargePriceLook("");
|
tChargingOrderExport.setCumulativeChargingTime(formatChargingDurationMinutes(chargingOrderListVO.getChargingSecond()));
|
tChargingOrderExport.setRefundAmount(null != chargingOrderListVO.getRefundAmount() ? chargingOrderListVO.getRefundAmount().toString() : "");
|
tChargingOrderExport.setStartSoc(chargingOrderListVO.getStartSoc());
|
tChargingOrderExport.setEndtSoc(chargingOrderListVO.getEndSoc());
|
tChargingOrderExport.setIsSoc("否");
|
tChargingOrderExport.setIsSocType("");
|
tChargingOrderExport.setIsSocNum("0");
|
tChargingOrderExport.setUserType("普通个人用户");
|
if (data3!=null&&data3.getVipId()!=null){
|
TVip data1 = data5.stream().filter(e->e.getId().equals(data3.getVipId())).findFirst().orElse(null);
|
if (data1!=null){
|
tChargingOrderExport.setVipType(data1.getName());
|
}
|
}
|
tChargingOrderExport.setIsPlus(chargingOrderListVO.getVipDiscountAmount().compareTo(BigDecimal.ZERO)>0?"是":"否");
|
if (data3!=null){
|
tChargingOrderExport.setRealName(data3.getName());
|
tChargingOrderExport.setPhone(data3.getPhone());
|
tChargingOrderExport.setNickName(data3.getName());
|
}
|
if (data4!=null){
|
tChargingOrderExport.setDeviceCode(data4.getCode());
|
}
|
tChargingOrderExport.setAccountType("个人");
|
TAppUserCar tAppUserCar = data8.stream().filter(e -> e.getId().equals(chargingOrderListVO.getAppUserId())).findFirst().orElse(null);
|
if (tAppUserCar!=null){
|
tChargingOrderExport.setCarNumber(tAppUserCar.getLicensePlate());
|
}
|
tChargingOrderExport.setBalanceIncome(formatMoney(chargingOrderListVO.getBalanceIncome()));
|
tChargingOrderExport.setBalanceGiftIncome(formatMoney(chargingOrderListVO.getBalanceGiftIncome()));
|
tChargingOrderExport.setPlatformIncome(formatMoney(chargingOrderListVO.getPlatformIncome()));
|
tChargingOrderExport.setPartnerIncome(formatMoney(chargingOrderListVO.getPartnerIncome()));
|
tChargingOrderExport.setTripartiteCommission(formatMoney(chargingOrderListVO.getSharingAmount()));
|
tChargingOrderExport.setOrderCode(chargingOrderListVO.getStartChargeSeq());
|
tChargingOrderExport.setIsSingle("是");
|
tChargingOrderExport.setPayTime(chargingOrderListVO.getPayTime()+"");
|
tChargingOrderExport.setSharingAmount(formatMoney(chargingOrderListVO.getSharingAmount()));
|
tChargingOrderExport.setIsWhitelist(Integer.valueOf(1).equals(chargingOrderListVO.getIsWhitelist()) ? "是" : "否");
|
tChargingOrderExport.setWhitelistElectricRefundAmount(formatMoney(chargingOrderListVO.getWhitelistElectricRefundAmount()));
|
tChargingOrderExport.setWhitelistServiceRefundAmount(formatMoney(chargingOrderListVO.getWhitelistServiceRefundAmount()));
|
tChargingOrderExports.add(tChargingOrderExport);
|
}
|
Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams(), TChargingOrderExport.class, tChargingOrderExports);
|
prependChargingPeriodSummary(workbook, buildChargingPeriodExportSummary(exportList));
|
HttpServletResponse response = WebUtils.response();
|
response.setContentType("application/vnd.ms-excel");
|
response.setCharacterEncoding("utf-8");
|
ServletOutputStream outputStream = null;
|
try {
|
String fileName = URLEncoder.encode("充电时段统计导出.xls", "utf-8");
|
response.setHeader("Content-Disposition", "attachment;filename=" + fileName);
|
response.setContentType("application/vnd.ms-excel;charset=UTF-8");
|
response.setHeader("Pragma", "no-cache");
|
response.setHeader("Cache-Control", "no-cache");
|
outputStream = response.getOutputStream();
|
workbook.write(outputStream);
|
} catch (IOException e) {
|
e.printStackTrace();
|
} finally {
|
try {
|
outputStream.close();
|
} catch (IOException e) {
|
e.printStackTrace();
|
}
|
}
|
}
|
|
private String getPaymentMethod(ChargingOrderListVO chargingOrderListVO) {
|
Integer payMethod = chargingOrderListVO.getPayMethod();
|
String thirdPayName = getThirdPayName(chargingOrderListVO.getRechargePaymentType());
|
if (Integer.valueOf(1).equals(payMethod)) {
|
return "余额支付";
|
}
|
if (Integer.valueOf(2).equals(payMethod)) {
|
return thirdPayName.isEmpty() ? "余额支付" : "余额支付+" + thirdPayName;
|
}
|
if (Integer.valueOf(3).equals(payMethod)) {
|
return thirdPayName;
|
}
|
return thirdPayName;
|
}
|
|
private String getThirdPayName(Integer rechargePaymentType) {
|
if (Integer.valueOf(1).equals(rechargePaymentType)) {
|
return "微信支付";
|
}
|
if (Integer.valueOf(2).equals(rechargePaymentType) || Integer.valueOf(3).equals(rechargePaymentType)) {
|
return "支付宝支付";
|
}
|
return "";
|
}
|
|
private BigDecimal getCashPayAmount(ChargingOrderListVO chargingOrderListVO) {
|
if (chargingOrderListVO.getThirdPayAmount() != null) {
|
return chargingOrderListVO.getThirdPayAmount();
|
}
|
if (Integer.valueOf(3).equals(chargingOrderListVO.getPayMethod())) {
|
return nullToZero(chargingOrderListVO.getPaymentAmount());
|
}
|
return BigDecimal.ZERO;
|
}
|
|
private BigDecimal getBalancePayAmount(ChargingOrderListVO chargingOrderListVO) {
|
if (chargingOrderListVO.getBalancePayAmount() != null) {
|
return chargingOrderListVO.getBalancePayAmount();
|
}
|
if (Integer.valueOf(1).equals(chargingOrderListVO.getPayMethod())) {
|
return nullToZero(chargingOrderListVO.getPaymentAmount());
|
}
|
return BigDecimal.ZERO;
|
}
|
|
private BigDecimal nullToZero(BigDecimal amount) {
|
return amount == null ? BigDecimal.ZERO : amount;
|
}
|
|
private String formatMoney(BigDecimal amount) {
|
return nullToZero(amount).setScale(2, RoundingMode.HALF_UP).toPlainString();
|
}
|
|
static String buildChargingPeriodExportSummary(List<ChargingOrderListVO> list) {
|
BigDecimal electrovalence = BigDecimal.ZERO;
|
BigDecimal serviceCharge = BigDecimal.ZERO;
|
BigDecimal paymentAmount = BigDecimal.ZERO;
|
BigDecimal chargingCapacity = BigDecimal.ZERO;
|
BigDecimal tripartiteCommission = BigDecimal.ZERO;
|
BigDecimal platformIncome = BigDecimal.ZERO;
|
BigDecimal partnerIncome = BigDecimal.ZERO;
|
BigDecimal balanceIncome = BigDecimal.ZERO;
|
BigDecimal balanceGiftIncome = BigDecimal.ZERO;
|
BigDecimal vipGiftAmount = BigDecimal.ZERO;
|
long chargingSeconds = 0L;
|
if (list != null) {
|
for (ChargingOrderListVO item : list) {
|
if (item == null) {
|
continue;
|
}
|
electrovalence = electrovalence.add(zero(item.getElectrovalence()));
|
serviceCharge = serviceCharge.add(zero(item.getServiceCharge()));
|
paymentAmount = paymentAmount.add(zero(item.getPaymentAmount()));
|
chargingCapacity = chargingCapacity.add(zero(item.getElectricity()));
|
tripartiteCommission = tripartiteCommission.add(zero(item.getSharingAmount()));
|
platformIncome = platformIncome.add(zero(item.getPlatformIncome()));
|
partnerIncome = partnerIncome.add(zero(item.getPartnerIncome()));
|
balanceIncome = balanceIncome.add(zero(item.getBalanceIncome()));
|
balanceGiftIncome = balanceGiftIncome.add(zero(item.getBalanceGiftIncome()));
|
vipGiftAmount = vipGiftAmount.add(zero(item.getVipDiscountAmount()));
|
chargingSeconds += item.getChargingSecond() == null ? 0L : item.getChargingSecond();
|
}
|
}
|
int orderCount = list == null ? 0 : list.size();
|
return "总计：" + orderCount + "条"
|
+ " 充电电费：" + money(electrovalence) + "元"
|
+ " 充电服务费：" + money(serviceCharge) + "元"
|
+ " 充电收入：" + money(paymentAmount) + "元"
|
+ " 充电电量：" + quantity(chargingCapacity) + "度"
|
+ " 充电时长：" + formatChargingDurationMinutes(chargingSeconds) + "分钟"
|
+ " 平台收入：" + money(platformIncome) + "元"
|
+ " 合作商分成：" + money(partnerIncome) + "元"
|
+ " 三方平台分佣：" + money(tripartiteCommission) + "元"
|
+ " 余额收入：" + money(balanceIncome) + "元"
|
+ " 余额赠送：" + money(balanceGiftIncome) + "元"
|
+ " 会员赠送：" + money(vipGiftAmount) + "元";
|
}
|
|
static void prependChargingPeriodSummary(Workbook workbook, String summary) {
|
if (workbook == null || workbook.getNumberOfSheets() == 0) {
|
return;
|
}
|
Sheet sheet = workbook.getSheetAt(0);
|
int lastRowNum = sheet.getLastRowNum();
|
if (sheet.getPhysicalNumberOfRows() > 0) {
|
sheet.shiftRows(0, lastRowNum, 1, true, false);
|
}
|
Row summaryRow = sheet.createRow(0);
|
summaryRow.setHeightInPoints(24);
|
Cell summaryCell = summaryRow.createCell(0);
|
summaryCell.setCellValue(summary == null ? "" : summary);
|
|
CellStyle style = workbook.createCellStyle();
|
Font font = workbook.createFont();
|
font.setBold(true);
|
style.setFont(font);
|
style.setVerticalAlignment(VerticalAlignment.CENTER);
|
style.setAlignment(HorizontalAlignment.LEFT);
|
summaryCell.setCellStyle(style);
|
|
Row headerRow = sheet.getRow(1);
|
int lastColumn = headerRow == null ? 0 : headerRow.getLastCellNum() - 1;
|
if (lastColumn > 0) {
|
sheet.addMergedRegion(new CellRangeAddress(0, 0, 0, lastColumn));
|
}
|
}
|
|
private static BigDecimal zero(BigDecimal value) {
|
return value == null ? BigDecimal.ZERO : value;
|
}
|
|
private static String money(BigDecimal value) {
|
return zero(value).setScale(2, RoundingMode.HALF_UP).toPlainString();
|
}
|
|
private static String quantity(BigDecimal value) {
|
return zero(value).setScale(3, RoundingMode.HALF_UP).stripTrailingZeros().toPlainString();
|
}
|
|
static String formatChargingDurationMinutes(Long chargingSeconds) {
|
if (chargingSeconds == null) {
|
return "";
|
}
|
return BigDecimal.valueOf(chargingSeconds)
|
.divide(BigDecimal.valueOf(60), 2, RoundingMode.HALF_UP)
|
.stripTrailingZeros()
|
.toPlainString();
|
}
|
|
static String formatChargingEndMode(Integer endMode) {
|
return endMode == null ? "" : endMode.toString();
|
}
|
|
|
|
@RequiresPermissions(value = {"/summarySettlement"}, logical = Logical.OR)
|
@GetMapping(value = "/settlementTotal")
|
@ApiOperation(value = "结算汇总-列表查询", tags = {"管理后台-财务结算"})
|
@ApiParam(name = "time", value = "汇报时间2024-01")
|
public AjaxResult<SettlementTotalVO> settlementTotal(String time) {
|
time = time+"-01 00:00:00";
|
SettlementTotalVO res = chargingOrderService.settlementTotal(time);
|
return AjaxResult.success(res);
|
}
|
|
|
|
@GetMapping(value = "/settlementTotalR/{time}/{userId}")
|
public R<SettlementTotalVO> settlementTotalR(@PathVariable("time")String time,@PathVariable("userId")Long userId) {
|
time = time+"-01 00:00:00";
|
SettlementTotalVO res = chargingOrderService.settlementTotalR(time,userId);
|
return R.ok(res);
|
}
|
|
|
@RequiresPermissions(value = {"/generateStatement"}, logical = Logical.OR)
|
@PostMapping(value = "/settlementAdd")
|
@ApiOperation(value = "结算确认表-生成/保存结算确认表", tags = {"管理后台-财务结算"})
|
public R<TSettlementConfirm> settlementAdd(@RequestBody SettlementConfirmAdd dto) {
|
TSettlementConfirm res = chargingOrderService.settlementAdd(dto);
|
return R.ok(res);
|
}
|
|
|
@RequiresPermissions(value = {"/balanceSheetRecord"}, logical = Logical.OR)
|
@PostMapping(value = "/settlementList")
|
@ApiOperation(value = "结算表记录-列表查询", tags = {"管理后台-财务结算"})
|
public R<PageInfo<TSettlementConfirm>> settlementList(@RequestBody SettlementListQuery dto) {
|
PageInfo<TSettlementConfirm> res = chargingOrderService.settlementList(dto);
|
return R.ok(res);
|
}
|
|
|
@RequiresPermissions(value = {"/balanceSheetRecord/del"}, logical = Logical.OR)
|
@GetMapping(value = "/deleteSettlement")
|
@ApiOperation(value = "结算表记录-删除", tags = {"管理后台-财务结算"})
|
public R deleteSettlement(String uid) {
|
tSettlementConfirmService.removeById(uid);
|
return R.ok();
|
}
|
|
|
|
@GetMapping(value = "/downloadSettlement/{uid}")
|
public R<TSettlementConfirm> downloadSettlement(@PathVariable("uid") String uid) {
|
TSettlementConfirm byId = tSettlementConfirmService.getById(uid);
|
if (byId!=null){
|
List<TChargingOrder> list = chargingOrderService.lambdaQuery().eq(TChargingOrder::getSiteId, byId.getSiteId())
|
.between(TChargingOrder::getStartTime, byId.getStartTime(), byId.getEndTime())
|
.eq(TChargingOrder::getStatus, 5)
|
.eq(TChargingOrder::getRechargePaymentStatus, 2).list();
|
int i = 1;
|
for (TChargingOrder chargingOrder : list) {
|
|
}
|
byId.setList(list);
|
String format = byId.getStartTime().format(DateTimeFormatter.ofPattern("yyyy年MM月dd日HH:mm:ss"));
|
String format1 = byId.getEndTime().format(DateTimeFormatter.ofPattern("yyyy年MM月dd日HH:mm:ss"));
|
byId.setTime(format+"至"+format1);
|
}
|
return R.ok(byId);
|
}
|
|
}
|
