package cn.iocoder.yudao.module.crm.service.quotation;
|
|
import cn.iocoder.yudao.module.crm.controller.admin.quotation.vo.CrmSaleQuotationRespVO;
|
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
|
import org.junit.jupiter.api.Test;
|
|
import java.io.ByteArrayInputStream;
|
import java.math.BigDecimal;
|
import java.time.LocalDateTime;
|
import java.util.List;
|
|
import static org.junit.jupiter.api.Assertions.*;
|
|
class CrmSaleQuotationExcelRendererTest {
|
|
@Test
|
void fillsMultipleItemsAndPreservesTemplateTermsAndPrintArea() throws Exception {
|
var quote = new CrmSaleQuotationRespVO();
|
quote.setNo("BJ-123");
|
quote.setCustomerName("客户甲");
|
quote.setOwnerUserName("销售员");
|
quote.setQuotationTime(LocalDateTime.of(2026, 11, 10, 0, 0));
|
var first = new CrmSaleQuotationRespVO.Item();
|
first.setItemName("电缆A");
|
first.setCount(new BigDecimal("2.5"));
|
first.setQuotationPrice(new BigDecimal("3.20"));
|
var second = new CrmSaleQuotationRespVO.Item();
|
second.setItemName("电缆B");
|
second.setRemark("备注B");
|
quote.setItems(List.of(first, second));
|
|
byte[] bytes = CrmSaleQuotationExcelRenderer.render(quote, "测试公司", "客户地址", "联系人", "123456");
|
try (var workbook = new XSSFWorkbook(new ByteArrayInputStream(bytes))) {
|
var sheet = workbook.getSheetAt(0);
|
assertEquals("编号：BJ-123", sheet.getRow(2).getCell(0).getStringCellValue());
|
assertEquals("客户甲", sheet.getRow(4).getCell(1).getStringCellValue());
|
assertEquals("客户地址", sheet.getRow(5).getCell(1).getStringCellValue());
|
assertEquals("联系人", sheet.getRow(6).getCell(1).getStringCellValue());
|
assertEquals("123456", sheet.getRow(7).getCell(1).getStringCellValue());
|
assertEquals(2.5, sheet.getRow(10).getCell(3).getNumericCellValue());
|
assertEquals(8.0, sheet.getRow(10).getCell(5).getNumericCellValue());
|
assertEquals("电缆B", sheet.getRow(11).getCell(0).getStringCellValue());
|
assertEquals("备注B", sheet.getRow(11).getCell(7).getStringCellValue());
|
String terms = sheet.getRow(13).getCell(0).getStringCellValue();
|
assertTrue(terms.contains("110元/公斤"));
|
assertTrue(terms.contains("货到45天内付款"));
|
assertEquals("报价日期：2026年11月10日", sheet.getRow(16).getCell(6).getStringCellValue());
|
assertTrue(workbook.getPrintArea(0).contains("$H$19"));
|
assertEquals(2, workbook.getAllPictures().size());
|
}
|
}
|
}
|
