zxl
5 天以前 d900bdc7b712666cdeafe36f01e485f4672e4651
framework/src/main/java/cn/lili/modules/member/serviceimpl/MemberServiceImpl.java
@@ -644,6 +644,8 @@
        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);
@@ -734,6 +736,7 @@
        // 创建表头
        Row header = sheet.createRow(0);
        String[] headers = {
                "会员id",
                "会员名称", "会员昵称","联系方式",
                "注册时间","最后登录时间"
        };
@@ -744,11 +747,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;