| | |
|---|
| | | @RequiresPermissions("business:member:exportExcel") |
|---|
| | | public void exportExcel (@RequestBody PageWrap<Member> pageWrap, HttpServletResponse response) { |
|---|
| | | List<Member> memberList = memberService.findPage(pageWrap).getRecords(); |
|---|
| | | if(CollectionUtils.isNotEmpty(memberList)){ |
|---|
| | | for (Member m:memberList) { |
|---|
| | | m.setAmountYuan(Objects.nonNull(m.getAmount())&&m.getAmount()> Constants.ZERO? new BigDecimal(m.getAmount()+"").divide(new BigDecimal("100"),2,BigDecimal.ROUND_UP):BigDecimal.ZERO); |
|---|
| | | List<String> identityInfo = new ArrayList<>(); |
|---|
| | | if(Constants.equalsInteger(m.getWorkerIdentity(),Constants.TWO)){ |
|---|
| | | identityInfo.add("工人"); |
|---|
| | | } |
|---|
| | | if(Constants.equalsInteger(m.getDriverIdentity(),Constants.TWO)){ |
|---|
| | | identityInfo.add("司机"); |
|---|
| | | } |
|---|
| | | if(Constants.equalsInteger(m.getChefIdentity(),Constants.TWO)){ |
|---|
| | | identityInfo.add("供餐"); |
|---|
| | | } |
|---|
| | | m.setIdentityApplyInfo(StringUtils.join(identityInfo,",")); |
|---|
| | | m.setIdentityInfo("发单方" + (StringUtils.isNotBlank(m.getIdentityApplyInfo())?" | 接单方":"")); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | ExcelExporter.build(Member.class).export(memberList, "会员信息表", response); |
|---|
| | | } |
|---|
| | | |
|---|
