feat(sales): 添加销售台账导出功能

chenhj

5 小时以前 810701c433a26f438297b6649af41dae74939731

feat(sales): 添加销售台账导出功能

- 在销售台账服务接口中添加export方法定义
- 添加HttpServletResponse依赖注入支持文件下载
- 实现销售台账导出Word文档功能，包含产品信息、批次号等详细数据
- 集成hutool-core库用于金额数字转中文大写格式
- 添加生产日期和有效期计算逻辑
- 实现销售出库单模板渲染和文件流输出
- 在产品订单服务中添加查询所有批号的功能
- 扩展销售台账产品实体类增加批号字段属性

 pom.xml

@@ -333,6 +333,12 @@
            <artifactId>jackson-datatype-jsr310</artifactId>

        </dependency>



        <!-- 金额转大写 -->

        <dependency>

            <groupId>cn.hutool</groupId>

            <artifactId>hutool-core</artifactId>

            <version>5.8.26</version>

        </dependency>

    </dependencies>



    <build>


 src/main/java/com/ruoyi/production/controller/ProductOrderController.java

@@ -84,4 +84,10 @@
    public R cleanRecord(@PathVariable Long id, @RequestBody Map<String, Object> cleanRecord) {
        return R.ok(productOrderService.cleanRecord(id, cleanRecord));
    }

    @ApiOperation("查询所有批号")
    @GetMapping("/getProductOrderBatchNo")
    public R getProductOrderBatchNo() {
        return R.ok(productOrderService.getProductOrderBatchNo());
    }
}

 src/main/java/com/ruoyi/production/service/ProductOrderService.java

@@ -3,6 +3,7 @@
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.IService;
import com.ruoyi.basic.dto.SelectOptionDTO;
import com.ruoyi.production.dto.ProductOrderDto;
import com.ruoyi.production.dto.ProductStructureDto;
import com.ruoyi.production.pojo.ProcessRoute;
@@ -29,4 +30,6 @@
    int finishOrder(Long orderId);

    int cleanRecord(Long id, Map<String, Object> cleanRecord);

    List<SelectOptionDTO<String>> getProductOrderBatchNo();
}

 src/main/java/com/ruoyi/production/service/impl/ProductOrderServiceImpl.java

@@ -9,6 +9,7 @@
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ruoyi.basic.dto.SelectOptionDTO;
import com.ruoyi.common.exception.base.BaseException;
import com.ruoyi.procurementrecord.utils.StockUtils;
import com.ruoyi.production.dto.ProductOrderDto;
@@ -229,4 +230,10 @@
        productOrder.setCleanRecord(JSON.toJSONString(cleanRecord));
        return productOrderMapper.updateById(productOrder);
    }

    @Override
    public List<SelectOptionDTO<String>> getProductOrderBatchNo() {
        List<ProductOrder> productOrders = productOrderMapper.selectList(null);
        return productOrders.stream().map(productOrder -> new SelectOptionDTO<>(productOrder.getBatchNo(), productOrder.getBatchNo())).collect(Collectors.toList());
    }
}

 src/main/java/com/ruoyi/sales/controller/SalesLedgerController.java

@@ -349,4 +349,10 @@
    public R getSalesLedgerWithProductsLoss(Long salesLedgerId) {
        return R.ok(salesLedgerService.getSalesLedgerWithProductsLoss(salesLedgerId));
    }

    @ApiOperation("导出")
    @PostMapping ("/exportSaleOutbound")
    public void export(HttpServletResponse response, @RequestBody SalesLedger salesLedger) {
        salesLedgerService.export(response,salesLedger.getId());
    }
}

 src/main/java/com/ruoyi/sales/pojo/SalesLedgerProduct.java

@@ -238,4 +238,7 @@

    @TableField(exist = false)
    private String uidNo;

    @ApiModelProperty(value = "批号")
    private String batchNo;
}

 src/main/java/com/ruoyi/sales/service/ISalesLedgerService.java

@@ -3,7 +3,6 @@
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.IService;
import com.ruoyi.aftersalesservice.pojo.AfterSalesService;
import com.ruoyi.common.enums.SaleEnum;
import com.ruoyi.framework.web.domain.AjaxResult;
import com.ruoyi.sales.dto.LossProductModelDto;
@@ -13,6 +12,7 @@
import com.ruoyi.sales.pojo.SalesLedgerProduct;
import org.springframework.web.multipart.MultipartFile;

import javax.servlet.http.HttpServletResponse;
import javax.validation.constraints.NotNull;
import java.math.BigDecimal;
import java.util.List;
@@ -52,4 +52,6 @@
    List<LossProductModelDto> getSalesLedgerWithProductsLoss(Long salesLedgerId);

    IPage<SalesLedgerDto> listSalesLedger(SalesLedgerDto salesLedgerDto, Page page);

    public void export(HttpServletResponse response, Long id);
}

 src/main/java/com/ruoyi/sales/service/impl/SalesLedgerServiceImpl.java

@@ -1,5 +1,6 @@
package com.ruoyi.sales.service.impl;

import cn.hutool.core.convert.NumberChineseFormatter;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
@@ -8,11 +9,15 @@
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.deepoove.poi.XWPFTemplate;
import com.deepoove.poi.config.Configure;
import com.deepoove.poi.plugin.table.LoopRowTableRenderPolicy;
import com.ruoyi.account.service.AccountIncomeService;
import com.ruoyi.basic.mapper.CustomerMapper;
import com.ruoyi.basic.mapper.ProductMapper;
import com.ruoyi.basic.mapper.ProductModelMapper;
import com.ruoyi.basic.pojo.Customer;
import com.ruoyi.basic.pojo.ProductModel;
import com.ruoyi.common.enums.FileNameType;
import com.ruoyi.common.enums.SaleEnum;
import com.ruoyi.common.exception.base.BaseException;
@@ -26,6 +31,10 @@
import com.ruoyi.other.mapper.TempFileMapper;
import com.ruoyi.other.pojo.TempFile;
import com.ruoyi.production.mapper.*;
import com.ruoyi.production.pojo.ProductOrder;
import com.ruoyi.production.pojo.ProductProcessRouteItem;
import com.ruoyi.production.pojo.ProductWorkOrder;
import com.ruoyi.production.pojo.ProductionProductMain;
import com.ruoyi.production.service.ProductionProductMainService;
import com.ruoyi.project.system.domain.SysDept;
import com.ruoyi.project.system.domain.SysUser;
@@ -48,11 +57,14 @@
import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.multipart.MultipartFile;

import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.lang.reflect.Field;
import java.math.BigDecimal;
import java.math.RoundingMode;
import java.net.URLEncoder;
import java.nio.file.Files;
import java.nio.file.Path;
import java.nio.file.Paths;
@@ -879,4 +891,97 @@
            throw new RuntimeException("动态更新主表金额失败", e);
        }
    }

    @Override
    public void export(HttpServletResponse response, Long id) {
        SalesLedgerProduct salesLedgerProduct = new SalesLedgerProduct();
        salesLedgerProduct.setSalesLedgerId(id);
        salesLedgerProduct.setType(1);
        List<SalesLedgerProduct> list = salesLedgerProductServiceImpl.selectSalesLedgerProductList(salesLedgerProduct);
        List<Map<String, Object>> products = new ArrayList<>();
        BigDecimal amount = BigDecimal.ZERO;
        for (int i = 0; i < list.size(); i++) {
            Map<String, Object> map = new HashMap<>();
            SalesLedgerProduct product = list.get(i);
            map.put("index", i + 1);
            map.put("productCategory", product.getProductCategory());
            map.put("specificationModel", product.getSpecificationModel());
            map.put("unit", product.getUnit());
            map.put("quantity", product.getQuantity());
            map.put("taxInclusiveUnitPrice", product.getTaxInclusiveUnitPrice().setScale(2, RoundingMode.HALF_UP).toString());
            map.put("taxInclusiveTotalPrice", product.getTaxInclusiveTotalPrice().setScale(2, RoundingMode.HALF_UP).toString());
            map.put("batchNo", product.getBatchNo());
            // 查询凭证
            ProductModel productModel = productModelMapper.selectById(product.getProductModelId());
            if (productModel != null) {
                map.put("filingCertificateNo", productModel.getFilingCertificateNo());
            }
            amount = amount.add(product.getTaxInclusiveTotalPrice());
            List<ProductOrder> productOrders = productOrderMapper.selectList(new LambdaQueryWrapper<ProductOrder>()
                    .eq(ProductOrder::getBatchNo, product.getBatchNo()));
            if (CollectionUtils.isEmpty(productOrders)) {
                throw new RuntimeException("批号不存在");
            }
            List<ProductWorkOrder> productWorkOrders = productWorkOrderMapper.selectList(new LambdaQueryWrapper<ProductWorkOrder>()
                    .eq(ProductWorkOrder::getProductOrderId, productOrders.get(0).getId()));
            List<Long> ids = productWorkOrders.stream().map(ProductWorkOrder::getId).collect(Collectors.toList());
            List<ProductionProductMain> productionProductMains = productionProductMainMapper.selectList(new LambdaQueryWrapper<ProductionProductMain>()
                    .in(ProductionProductMain::getWorkOrderId, ids)
                    .orderByDesc(ProductionProductMain::getCreateTime));
            List<ProductProcessRouteItem> productProcessRouteItems = productProcessRouteItemMapper.selectList(new LambdaQueryWrapper<ProductProcessRouteItem>()
                    .in(ProductProcessRouteItem::getId, productionProductMains.stream()
                            .map(ProductionProductMain::getProductProcessRouteItemId).collect(Collectors.toList()))
                    .eq(ProductProcessRouteItem::getProductModelId, product.getProductModelId())
                    .orderByDesc(ProductProcessRouteItem::getCreateTime));
            if (CollectionUtils.isEmpty(productProcessRouteItems)) {
                throw new RuntimeException("生产数据不存在");
            }
            String productionDate = productProcessRouteItems.get(0).getCreateTime().format(DateTimeFormatter.ofPattern("yyyy-MM-dd"));
            if (productModel.getValidityPeriod() == null) {
                throw new RuntimeException("有效期不能为空");
            }
            String expiryDate = productProcessRouteItems.get(0).getCreateTime().plusYears(productModel.getValidityPeriod().longValue()).format(DateTimeFormatter.ofPattern("yyyy-MM-dd"));
            map.put("productionDate", productionDate);
            map.put("expiryDate", expiryDate);
            products.add(map);
        }
        Map<String, Object> data = new HashMap<>();
        data.put("products", products);
        data.put("amount", amount);
        data.put("amountBig", NumberChineseFormatter.format(amount, true, false));
        SalesLedger salesLedger = salesLedgerMapper.selectById(id);
        data.put("customerName ", salesLedger.getCustomerName());
        data.put("executionDate", salesLedger.getExecutionDate());
        data.put("salesContractNo", salesLedger.getSalesContractNo());
        Customer customer = customerMapper.selectById(salesLedger.getCustomerId());
        data.put("companyPhone", customer.getCompanyPhone());
        data.put("companyAddress", customer.getCompanyAddress());
        data.put("salesman", salesLedger.getSalesman());

        InputStream inputStream = this.getClass().getResourceAsStream("/static/sale-outbound.docx");

        LoopRowTableRenderPolicy policy = new LoopRowTableRenderPolicy();

        Configure config = Configure.builder()
                .bind("products", policy).build();

        XWPFTemplate template = XWPFTemplate.compile(inputStream, config).render(data);
        try {
            response.setContentType("application/msword");
            String fileName = URLEncoder.encode(
                    "销售出库单", "UTF-8");
            response.setHeader("Access-Control-Expose-Headers", "Content-Disposition");
            response.setHeader("Content-disposition",
                    "attachment;filename=" + fileName + ".docx");
            OutputStream os = response.getOutputStream();
            template.write(os);
            os.flush();
            os.close();
            inputStream.close();
        } catch (Exception e) {
            e.printStackTrace();
            throw new RuntimeException("导出失败");
        }

    }
}

 src/main/resources/static/sale-outbound.docx

Binary files differ