| | |
| | | queryWrapper.like(CharSequenceUtil.isNotBlank(memberSearchVO.getNickName()), "nick_name", memberSearchVO.getNickName()); |
| | | //按照电话号码查询 |
| | | queryWrapper.like(CharSequenceUtil.isNotBlank(memberSearchVO.getMobile()), "mobile", memberSearchVO.getMobile()); |
| | | //按照会员id查询 |
| | | queryWrapper.eq(CharSequenceUtil.isNotBlank(memberSearchVO.getMemberId()), "m.id", memberSearchVO.getMemberId()); |
| | | //按照会员状态查询 |
| | | queryWrapper.eq(CharSequenceUtil.isNotBlank(memberSearchVO.getDisabled()), "disabled", |
| | | memberSearchVO.getDisabled().equals(SwitchEnum.OPEN.name()) ? 1 : 0); |
| | |
| | | // 创建表头 |
| | | Row header = sheet.createRow(0); |
| | | String[] headers = { |
| | | "会员id", |
| | | "会员名称", "会员昵称","联系方式", |
| | | "注册时间","最后登录时间" |
| | | }; |
| | |
| | | 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; |