package com.ruoyi.sales.service.impl;
|
|
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
|
import com.ruoyi.sales.dto.CustomerInteractionDto;
|
import com.ruoyi.sales.dto.InvoiceLedgerDto;
|
import com.ruoyi.sales.dto.ReceiptPaymentDto;
|
import com.ruoyi.sales.mapper.ReceiptPaymentMapper;
|
import com.ruoyi.sales.mapper.SalesLedgerMapper;
|
import com.ruoyi.sales.pojo.ReceiptPayment;
|
import com.ruoyi.sales.pojo.SalesLedger;
|
import com.ruoyi.sales.service.ReceiptPaymentService;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
import org.springframework.util.CollectionUtils;
|
import org.springframework.util.ObjectUtils;
|
|
import java.math.BigDecimal;
|
import java.time.LocalDate;
|
import java.time.YearMonth;
|
import java.util.*;
|
import java.util.stream.Collectors;
|
|
@Service
|
public class ReceiptPaymentServiceImpl extends ServiceImpl<ReceiptPaymentMapper,ReceiptPayment> implements ReceiptPaymentService {
|
|
@Autowired
|
private ReceiptPaymentMapper receiptPaymentMapper;
|
|
@Autowired
|
private SalesLedgerMapper salesLedgerMapper;
|
|
/**
|
* 回款登记新增
|
* @param receiptPayment
|
* @return
|
*/
|
@Override
|
public int receiptPaymentSaveOrUpdate(ReceiptPayment receiptPayment) {
|
if(null==receiptPayment.getId()){
|
return receiptPaymentMapper.insert(receiptPayment);
|
}else {
|
return receiptPaymentMapper.updateById(receiptPayment);
|
}
|
}
|
|
/**
|
* 回款登记修改
|
* @param receiptPayment
|
* @return
|
*/
|
@Override
|
public int receiptPaymentUpdate(ReceiptPayment receiptPayment) {
|
return receiptPaymentMapper.updateById(receiptPayment);
|
}
|
|
/**
|
* 回款登记删除
|
* @param ids
|
* @return
|
*/
|
@Override
|
public int receiptPaymentDel(List<Integer> ids) {
|
LambdaQueryWrapper<ReceiptPayment> delQuery = new LambdaQueryWrapper<>();
|
delQuery.in(ReceiptPayment::getId, ids);
|
return receiptPaymentMapper.delete(delQuery);
|
}
|
|
/**
|
* 回款登记分页查询
|
* @param page
|
* @param receiptPaymentDto
|
* @return
|
*/
|
@Override
|
public IPage<ReceiptPaymentDto> receiptPaymentListPage(Page page, ReceiptPaymentDto receiptPaymentDto) {
|
// 计算分页前page.current-1 * limit条数的综合计算已经收回的回款金额
|
// 计算已经分页的条数
|
long total = (page.getCurrent() - 1) * page.getSize();
|
BigDecimal receiptAmount = receiptPaymentMapper.getReceiptAmount(receiptPaymentDto.getCustomerId(), total);
|
if(ObjectUtils.isEmpty(receiptAmount)){
|
receiptAmount = BigDecimal.ZERO;
|
}
|
IPage<ReceiptPaymentDto> iPage = receiptPaymentMapper.receiptPaymentListPage(page, receiptPaymentDto);
|
// 开票总金额
|
BigDecimal invoiceTotal = CollectionUtils.isEmpty(iPage.getRecords()) ? BigDecimal.ZERO : iPage.getRecords().get(0).getInvoiceTotal();
|
// 当前应收金额
|
BigDecimal currentUnReceiptAmount = invoiceTotal.subtract(receiptAmount);
|
for (ReceiptPaymentDto record : iPage.getRecords()) {
|
currentUnReceiptAmount = currentUnReceiptAmount.subtract(record.getReceiptPaymentAmount());
|
record.setNoReceiptAmount(currentUnReceiptAmount);
|
}
|
return iPage;
|
}
|
|
/**
|
* 回款登记详情
|
* @param id
|
* @return
|
*/
|
@Override
|
public ReceiptPaymentDto receiptPaymentInfo(Integer id) {
|
return receiptPaymentMapper.receiptPaymentInfo(id);
|
}
|
|
@Override
|
public BigDecimal getReceiptAmount() {
|
LocalDate now = LocalDate.now();
|
YearMonth currentMonth = YearMonth.from(now);
|
|
// 创建LambdaQueryWrapper
|
LambdaQueryWrapper<ReceiptPayment> queryWrapper = new LambdaQueryWrapper<>();
|
queryWrapper.ge(ReceiptPayment::getReceiptPaymentDate, currentMonth.atDay(1).atStartOfDay()) // 大于等于本月第一天
|
.lt(ReceiptPayment::getReceiptPaymentDate, currentMonth.plusMonths(1).atDay(1).atStartOfDay()); // 小于下月第一天
|
|
// 执行查询并计算总和
|
List<ReceiptPayment> receiptPayments = receiptPaymentMapper.selectList(queryWrapper);
|
|
BigDecimal totalContractAmount = receiptPayments.stream()
|
.map(ReceiptPayment::getReceiptPaymentAmount)
|
.filter(Objects::nonNull)
|
.reduce(BigDecimal.ZERO, BigDecimal::add);
|
|
return totalContractAmount;
|
}
|
|
/**
|
* 查询已经绑定发票的开票台账
|
* @param page
|
* @param receiptPaymentDto
|
* @return
|
*/
|
@Override
|
public IPage<ReceiptPaymentDto> bindInvoiceNoRegPage(Page page, ReceiptPaymentDto receiptPaymentDto) {
|
return receiptPaymentMapper.bindInvoiceNoRegPage(page, receiptPaymentDto);
|
}
|
|
/**
|
* 开票台账详情
|
* @param id
|
* @return
|
*/
|
@Override
|
public InvoiceLedgerDto invoiceInfo(Integer id) {
|
return receiptPaymentMapper.invoiceInfo(id);
|
}
|
|
@Override
|
public Map<String,BigDecimal> getAmountMouth() {
|
List<SalesLedger> salesLedgers = salesLedgerMapper.selectList(null);
|
BigDecimal contractAmount = salesLedgers.stream().map(SalesLedger::getContractAmount)
|
.filter(Objects::nonNull)
|
.reduce(BigDecimal.ZERO, BigDecimal::add);
|
|
LocalDate now = LocalDate.now();
|
YearMonth currentMonth = YearMonth.from(now);
|
|
// 创建LambdaQueryWrapper
|
LambdaQueryWrapper<ReceiptPayment> queryWrapper = new LambdaQueryWrapper<>();
|
queryWrapper.ge(ReceiptPayment::getReceiptPaymentDate, currentMonth.atDay(1).atStartOfDay()) // 大于等于本月第一天
|
.lt(ReceiptPayment::getReceiptPaymentDate, currentMonth.plusMonths(1).atDay(1).atStartOfDay()); // 小于下月第一天
|
|
// 执行查询并计算总和
|
List<ReceiptPayment> receiptPayments = receiptPaymentMapper.selectList(queryWrapper);
|
|
BigDecimal receiveAmount = receiptPayments.stream()
|
.map(ReceiptPayment::getReceiptPaymentAmount)
|
.filter(Objects::nonNull)
|
.reduce(BigDecimal.ZERO, BigDecimal::add);
|
|
// 构建结果
|
Map<String, BigDecimal> result = new HashMap<>();
|
result.put("receiveAmount", receiveAmount);
|
result.put("contractAmount", contractAmount);
|
return result;
|
}
|
|
/**
|
* 查询回款记录
|
*/
|
@Override
|
public List<ReceiptPaymentDto> receiptPaymentHistoryList(ReceiptPaymentDto receiptPaymentDto) {
|
return receiptPaymentMapper.receiptPaymentHistoryList(receiptPaymentDto);
|
}
|
|
/**
|
* 查询回款记录分页
|
*/
|
@Override
|
public IPage<ReceiptPaymentDto> receiptPaymentHistoryListPage(Page page, ReceiptPaymentDto receiptPaymentDto) {
|
return receiptPaymentMapper.receiptPaymentHistoryListPage(page, receiptPaymentDto);
|
}
|
|
/**
|
* 客户往来记录查询
|
* @param receiptPaymentDto
|
* @return
|
*/
|
@Override
|
public List<CustomerInteractionDto> customerInteractions(ReceiptPaymentDto receiptPaymentDto) {
|
ArrayList<CustomerInteractionDto> result = new ArrayList<>();
|
List<CustomerInteractionDto> customerInteractionDtos = receiptPaymentMapper.customerInteractions(receiptPaymentDto);
|
if(CollectionUtils.isEmpty(customerInteractionDtos)){
|
return result;
|
}
|
// 应收总金额金额计算
|
BigDecimal amountTotal = BigDecimal.ZERO;
|
Map<LocalDate, List<CustomerInteractionDto>> dateListMap = customerInteractionDtos.stream().collect(
|
Collectors.groupingBy(
|
CustomerInteractionDto::getHappenTime,
|
LinkedHashMap::new,
|
Collectors.toList()
|
)
|
);
|
for (LocalDate localDate : dateListMap.keySet()) {
|
BigDecimal currentReceiptAmount = BigDecimal.ZERO;
|
BigDecimal invoiceAmount = BigDecimal.ZERO;
|
BigDecimal currentDateTotal = BigDecimal.ZERO;
|
List<CustomerInteractionDto> customerInteractionDtoList = dateListMap.get(localDate);
|
// 计算当天收款数
|
currentReceiptAmount = customerInteractionDtoList.stream()
|
.filter(item ->item.getType() == 0)
|
.map(CustomerInteractionDto::getReceiptAmount)
|
.reduce(BigDecimal.ZERO,BigDecimal::add);
|
// 计算当天开票数
|
invoiceAmount = customerInteractionDtoList.stream()
|
.filter(item ->item.getType() == 1)
|
.map(CustomerInteractionDto::getInvoiceAmount)
|
.reduce(BigDecimal.ZERO,BigDecimal::add);
|
// 计算当日汇总
|
currentDateTotal = currentDateTotal.add(invoiceAmount).subtract(currentReceiptAmount);
|
CustomerInteractionDto customerInteractionDto = new CustomerInteractionDto();
|
customerInteractionDto.setHappenTime(localDate);
|
customerInteractionDto.setInvoiceAmount(invoiceAmount);
|
customerInteractionDto.setReceiptAmount(currentReceiptAmount);
|
amountTotal = amountTotal.add(currentDateTotal);
|
customerInteractionDto.setUnReceiptAmount(amountTotal);
|
result.add(customerInteractionDto);
|
}
|
return result;
|
}
|
|
/**
|
* 查询回款记录分页
|
*/
|
@Override
|
public List<ReceiptPaymentDto> receiptPaymentHistoryListNoPage(ReceiptPaymentDto receiptPaymentDto) {
|
return receiptPaymentMapper.receiptPaymentHistoryListNoPage( receiptPaymentDto);
|
}
|
}
|
