会员列表导出

Hentua

2023-06-20 9bc60c39ec05aa8f88b0273c974a7442fb4d07d4

 src/main/java/cc/mrbird/febs/mall/controller/AdminMallMemberController.java

@@ -15,6 +15,7 @@
import cc.mrbird.febs.system.entity.Dept;
import com.alibaba.excel.EasyExcel;

import com.baomidou.mybatisplus.core.metadata.IPage;
import lombok.RequiredArgsConstructor;
import lombok.extern.slf4j.Slf4j;
import org.apache.ibatis.annotations.Param;
@@ -507,4 +508,18 @@
        EasyExcel.write(response.getOutputStream(),AdminMoneyFlowListVo.class).sheet("资金明细表").doWrite(list);
    }

    @GetMapping("exportMemberList")
    public void exportMemberList(MallMember mallMember, HttpServletResponse response) throws IOException {
        QueryRequest request = new QueryRequest();
        request.setPageNum(1);
        request.setPageSize(999999999);
        List<MallMember> list = mallMemberService.getMallMemberList(mallMember, request).getRecords();

        response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
        response.setCharacterEncoding("utf-8");
        String fileName= URLEncoder.encode("会员列表","UTF-8").replaceAll("\\+","%20");
        response.setHeader("Content-disposition","attachment;filename*=utf-8''"+fileName+".xlsx");
        EasyExcel.write(response.getOutputStream(),MallMember.class).sheet("会员列表").doWrite(list);
    }

}