From b9b8b93a1b8ec1954ffc690093cb4628477de8c2 Mon Sep 17 00:00:00 2001
From: peng <peng.com>
Date: 星期三, 22 十月 2025 14:11:49 +0800
Subject: [PATCH] 导出excel添加用户id
---
framework/src/main/java/cn/lili/modules/member/serviceimpl/MemberServiceImpl.java | 16 ++++++++--------
1 files changed, 8 insertions(+), 8 deletions(-)
diff --git a/framework/src/main/java/cn/lili/modules/member/serviceimpl/MemberServiceImpl.java b/framework/src/main/java/cn/lili/modules/member/serviceimpl/MemberServiceImpl.java
index 113c83a..3faabf9 100644
--- a/framework/src/main/java/cn/lili/modules/member/serviceimpl/MemberServiceImpl.java
+++ b/framework/src/main/java/cn/lili/modules/member/serviceimpl/MemberServiceImpl.java
@@ -653,11 +653,9 @@
String tagIdsStr = memberSearchVO.getTagIds().stream()
.map(String::valueOf)
.collect(Collectors.joining(","));
- queryWrapper.inSql("id",
+ queryWrapper.inSql("m.id",
"SELECT DISTINCT member_id FROM lmk_member_tag WHERE tag_id IN (" +
tagIdsStr + ")");
-
- return this.baseMapper.pageByMemberVOAndBindStore(PageUtil.initPage(page), queryWrapper);
}
return this.baseMapper.pageByMemberVOAndBindStore(PageUtil.initPage(page),queryWrapper);
}
@@ -736,6 +734,7 @@
// 鍒涘缓琛ㄥご
Row header = sheet.createRow(0);
String[] headers = {
+ "浼氬憳id",
"浼氬憳鍚嶇О", "浼氬憳鏄电О","鑱旂郴鏂瑰紡",
"娉ㄥ唽鏃堕棿","鏈�鍚庣櫥褰曟椂闂�"
};
@@ -746,11 +745,12 @@
for (int i=0;i< exportDetailDTOS.size();i++){
MemberExportVO dto = exportDetailDTOS.get(i);
Row row = sheet.createRow(i+1);
- row.createCell(0).setCellValue(dto.getUsername());
- row.createCell(1).setCellValue(dto.getNickName());
- row.createCell(2).setCellValue(dto.getMobile());
- row.createCell(3).setCellValue(dto.getCreateTime());
- row.createCell(4).setCellValue(dto.getLastLoginDate());
+ row.createCell(0).setCellValue(dto.getId());
+ row.createCell(1).setCellValue(dto.getUsername());
+ row.createCell(2).setCellValue(dto.getNickName());
+ row.createCell(3).setCellValue(dto.getMobile());
+ row.createCell(4).setCellValue(dto.getCreateTime());
+ row.createCell(5).setCellValue(dto.getLastLoginDate());
}
return workbook;
--
Gitblit v1.8.0