管理后台导出

xuhy

2025-11-12 c039cfb5c25922547b4889637432c4fe6d535178

管理后台导出

 ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TAppealServicesController.java

@@ -1,24 +1,38 @@
package com.ruoyi.web.controller.api;


import cn.afterturn.easypoi.excel.ExcelExportUtil;
import cn.afterturn.easypoi.excel.entity.ExportParams;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.ruoyi.common.annotation.Log;
import com.ruoyi.common.basic.PageInfo;
import com.ruoyi.common.core.domain.R;
import com.ruoyi.common.enums.BusinessType;
import com.ruoyi.common.utils.DateUtils;
import com.ruoyi.common.utils.WebUtils;
import com.ruoyi.framework.web.service.TokenService;
import com.ruoyi.system.dto.HandleAppealServicesDTO;
import com.ruoyi.system.export.TAppealServicesExport;
import com.ruoyi.system.export.TRefundOrderExport;
import com.ruoyi.system.model.TAppealServices;
import com.ruoyi.system.query.TAppealServicesQuery;
import com.ruoyi.system.query.TCourseOrderQuery;
import com.ruoyi.system.service.TAppealServicesService;
import com.ruoyi.system.vo.TAppealServicesVO;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.apache.poi.ss.usermodel.Workbook;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.validation.annotation.Validated;
import org.springframework.web.bind.annotation.*;

import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.net.URLEncoder;
import java.time.LocalDateTime;
import java.util.List;
import java.util.Objects;

/**
 * <p>
@@ -46,7 +60,7 @@
     */
    @ApiOperation(value = "获取诉求服务管理分页列表")
    @PostMapping(value = "/pageList")
    public R<PageInfo<TAppealServicesVO>> pageList(@RequestBody TAppealServicesQuery query) {
    public R<PageInfo<TAppealServicesVO>> pageList(@Validated @RequestBody TAppealServicesQuery query) {
        return R.ok(appealServicesService.pageList(query));
    }
    /**
@@ -117,6 +131,85 @@
        appealServicesService.updateById(appealServices);
        return R.ok();
    }


    @Log(title = "诉求服务管理信息-群众诉求服务导出", businessType = BusinessType.EXPORT)
    @ApiOperation(value = "群众诉求服务导出")
    @PostMapping("/exportAppealServices")
    public void exportAppealServices(@RequestBody TAppealServicesQuery query){
        query.setAppealType(1);
        List<TAppealServicesExport> appealServicesExports = appealServicesService.exportAppealServices(query);
        for (TAppealServicesExport appealServicesExport : appealServicesExports) {
            if(Objects.nonNull(appealServicesExport.getCreateTime())){
                appealServicesExport.setCreateTimeStr(DateUtils.localDateTimeToString(appealServicesExport.getCreateTime()));
            }
            if(Objects.nonNull(appealServicesExport.getProcessTime())){
                appealServicesExport.setProcessTimeStr(DateUtils.localDateTimeToString(appealServicesExport.getProcessTime()));
            }
        }
        Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams(), TAppealServicesExport.class, appealServicesExports);
        HttpServletResponse response = WebUtils.response();
        assert response != null;
        response.setContentType("application/vnd.ms-excel");
        response.setCharacterEncoding("utf-8");
        ServletOutputStream outputStream = null;
        try {
            String fileName = URLEncoder.encode("群众诉求服务导出.xls", "utf-8");
            response.setHeader("Content-Disposition", "attachment;filename=" + fileName);
            response.setContentType("application/vnd.ms-excel;charset=UTF-8");
            response.setHeader("Pragma", "no-cache");
            response.setHeader("Cache-Control", "no-cache");
            outputStream = response.getOutputStream();
            workbook.write(outputStream);
        } catch (IOException e) {
            e.printStackTrace();
        } finally {
            try {
                outputStream.close();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
    }

    @Log(title = "诉求服务管理信息-随心拍导出", businessType = BusinessType.EXPORT)
    @ApiOperation(value = "随心拍导出")
    @PostMapping("/exportAppealServicesGratified")
    public void exportAppealServicesGratified(@RequestBody TAppealServicesQuery query){
        query.setAppealType(2);
        List<TAppealServicesExport> appealServicesExports = appealServicesService.exportAppealServices(query);
        for (TAppealServicesExport appealServicesExport : appealServicesExports) {
            if(Objects.nonNull(appealServicesExport.getCreateTime())){
                appealServicesExport.setCreateTimeStr(DateUtils.localDateTimeToString(appealServicesExport.getCreateTime()));
            }
            if(Objects.nonNull(appealServicesExport.getProcessTime())){
                appealServicesExport.setProcessTimeStr(DateUtils.localDateTimeToString(appealServicesExport.getProcessTime()));
            }
        }
        Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams(), TAppealServicesExport.class, appealServicesExports);
        HttpServletResponse response = WebUtils.response();
        assert response != null;
        response.setContentType("application/vnd.ms-excel");
        response.setCharacterEncoding("utf-8");
        ServletOutputStream outputStream = null;
        try {
            String fileName = URLEncoder.encode("随心拍导出.xls", "utf-8");
            response.setHeader("Content-Disposition", "attachment;filename=" + fileName);
            response.setContentType("application/vnd.ms-excel;charset=UTF-8");
            response.setHeader("Pragma", "no-cache");
            response.setHeader("Cache-Control", "no-cache");
            outputStream = response.getOutputStream();
            workbook.write(outputStream);
        } catch (IOException e) {
            e.printStackTrace();
        } finally {
            try {
                outputStream.close();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
    }
    
}


 ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TChildcareServicesController.java

@@ -1,22 +1,35 @@
package com.ruoyi.web.controller.api;


import cn.afterturn.easypoi.excel.ExcelExportUtil;
import cn.afterturn.easypoi.excel.entity.ExportParams;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.ruoyi.common.annotation.Log;
import com.ruoyi.common.basic.PageInfo;
import com.ruoyi.common.core.domain.R;
import com.ruoyi.common.enums.BusinessType;
import com.ruoyi.common.utils.DateUtils;
import com.ruoyi.common.utils.WebUtils;
import com.ruoyi.system.export.TChildcareServicesExport;
import com.ruoyi.system.export.TMicroWishExport;
import com.ruoyi.system.model.TChildcareServices;
import com.ruoyi.system.query.TChildcareServicesQuery;
import com.ruoyi.system.query.TCourseOrderQuery;
import com.ruoyi.system.service.TChildcareServicesService;
import com.ruoyi.system.vo.TChildcareServicesVO;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.apache.poi.ss.usermodel.Workbook;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.validation.annotation.Validated;
import org.springframework.web.bind.annotation.*;

import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.net.URLEncoder;
import java.util.List;
import java.util.Objects;

/**
 * <p>
@@ -84,5 +97,40 @@
        return R.ok(childcareServicesService.removeByIds(ids));
    }

    @Log(title = "托育服务需求管理信息-托育服务导出", businessType = BusinessType.EXPORT)
    @ApiOperation(value = "托育服务导出")
    @PostMapping("/exportChildcareServices")
    public void exportChildcareServices(@RequestBody TChildcareServicesQuery query){
        List<TChildcareServicesExport> childcareServicesExports = childcareServicesService.exportChildcareServices(query);
        for (TChildcareServicesExport microWishExport : childcareServicesExports) {
            if(Objects.nonNull(microWishExport.getCreateTime())){
                microWishExport.setCreateTimeStr(DateUtils.localDateTimeToString(microWishExport.getCreateTime()));
            }
        }
        Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams(), TChildcareServicesExport.class, childcareServicesExports);
        HttpServletResponse response = WebUtils.response();
        assert response != null;
        response.setContentType("application/vnd.ms-excel");
        response.setCharacterEncoding("utf-8");
        ServletOutputStream outputStream = null;
        try {
            String fileName = URLEncoder.encode("托育服务导出.xls", "utf-8");
            response.setHeader("Content-Disposition", "attachment;filename=" + fileName);
            response.setContentType("application/vnd.ms-excel;charset=UTF-8");
            response.setHeader("Pragma", "no-cache");
            response.setHeader("Cache-Control", "no-cache");
            outputStream = response.getOutputStream();
            workbook.write(outputStream);
        } catch (IOException e) {
            e.printStackTrace();
        } finally {
            try {
                outputStream.close();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
    }

}


 ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TCourseOrderController.java

@@ -1,13 +1,20 @@
package com.ruoyi.web.controller.api;


import cn.afterturn.easypoi.excel.ExcelExportUtil;
import cn.afterturn.easypoi.excel.entity.ExportParams;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.ruoyi.common.annotation.Log;
import com.ruoyi.common.basic.PageInfo;
import com.ruoyi.common.core.domain.R;
import com.ruoyi.common.core.domain.entity.SysUser;
import com.ruoyi.common.enums.BusinessType;
import com.ruoyi.common.utils.DateUtils;
import com.ruoyi.common.utils.WebUtils;
import com.ruoyi.framework.web.service.TokenService;
import com.ruoyi.system.dto.AuditCourseOrderRefundDTO;
import com.ruoyi.system.export.TCourseOrderExport;
import com.ruoyi.system.export.TRefundOrderExport;
import com.ruoyi.system.model.TCourse;
import com.ruoyi.system.model.TCourseOrder;
import com.ruoyi.system.query.TCourseOrderQuery;
@@ -18,12 +25,18 @@
import com.ruoyi.system.vo.TCourseVO;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.apache.poi.ss.usermodel.Workbook;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.validation.annotation.Validated;
import org.springframework.web.bind.annotation.*;

import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.net.URLEncoder;
import java.util.List;
import java.util.Objects;

/**
 * <p>
@@ -137,5 +150,77 @@
        return R.ok(courseService.removeByIds(ids));
    }

    @Log(title = "课程订单管理信息-课程报名记录导出", businessType = BusinessType.EXPORT)
    @ApiOperation(value = "课程报名记录导出")
    @PostMapping("/exportCourseOrder")
    public void exportCourseOrder(@RequestBody TCourseOrderQuery query){
        List<TCourseOrderExport> courseOrderExports = courseOrderService.exportCourseOrder(query);
        for (TCourseOrderExport courseOrderExport : courseOrderExports) {
            if(Objects.nonNull(courseOrderExport.getPayTime())){
                courseOrderExport.setPayTimeStr(DateUtils.localDateTimeToString(courseOrderExport.getPayTime()));
            }
        }
        Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams(), TCourseOrderExport.class, courseOrderExports);
        HttpServletResponse response = WebUtils.response();
        assert response != null;
        response.setContentType("application/vnd.ms-excel");
        response.setCharacterEncoding("utf-8");
        ServletOutputStream outputStream = null;
        try {
            String fileName = URLEncoder.encode("课程报名记录.xls", "utf-8");
            response.setHeader("Content-Disposition", "attachment;filename=" + fileName);
            response.setContentType("application/vnd.ms-excel;charset=UTF-8");
            response.setHeader("Pragma", "no-cache");
            response.setHeader("Cache-Control", "no-cache");
            outputStream = response.getOutputStream();
            workbook.write(outputStream);
        } catch (IOException e) {
            e.printStackTrace();
        } finally {
            try {
                outputStream.close();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
    }
    @Log(title = "课程订单管理信息-退款记录导出", businessType = BusinessType.EXPORT)
    @ApiOperation(value = "退款记录导出")
    @PostMapping("/exportRefundOrder")
    public void exportRefundOrder(@RequestBody TCourseOrderQuery query){
        List<TRefundOrderExport> refundOrderExports = courseOrderService.exportRefundOrder(query);
        for (TRefundOrderExport courseOrderExport : refundOrderExports) {
            if(Objects.nonNull(courseOrderExport.getPayTime())){
                courseOrderExport.setPayTimeStr(DateUtils.localDateTimeToString(courseOrderExport.getPayTime()));
            }
            if(Objects.nonNull(courseOrderExport.getRequestRefundTime())){
                courseOrderExport.setRequestRefundTimeStr(DateUtils.localDateTimeToString(courseOrderExport.getRequestRefundTime()));
            }
        }
        Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams(), TRefundOrderExport.class, refundOrderExports);
        HttpServletResponse response = WebUtils.response();
        assert response != null;
        response.setContentType("application/vnd.ms-excel");
        response.setCharacterEncoding("utf-8");
        ServletOutputStream outputStream = null;
        try {
            String fileName = URLEncoder.encode("课程退款记录.xls", "utf-8");
            response.setHeader("Content-Disposition", "attachment;filename=" + fileName);
            response.setContentType("application/vnd.ms-excel;charset=UTF-8");
            response.setHeader("Pragma", "no-cache");
            response.setHeader("Cache-Control", "no-cache");
            outputStream = response.getOutputStream();
            workbook.write(outputStream);
        } catch (IOException e) {
            e.printStackTrace();
        } finally {
            try {
                outputStream.close();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
    }

}


 ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/THelpNeedsController.java

@@ -1,25 +1,38 @@
package com.ruoyi.web.controller.api;


import cn.afterturn.easypoi.excel.ExcelExportUtil;
import cn.afterturn.easypoi.excel.entity.ExportParams;
import com.ruoyi.common.annotation.Log;
import com.ruoyi.common.basic.PageInfo;
import com.ruoyi.common.core.domain.R;
import com.ruoyi.common.enums.BusinessType;
import com.ruoyi.common.utils.DateUtils;
import com.ruoyi.common.utils.WebUtils;
import com.ruoyi.system.export.THelpNeedsExport;
import com.ruoyi.system.export.TMicroWishExport;
import com.ruoyi.system.model.TAppUser;
import com.ruoyi.system.model.THelpNeeds;
import com.ruoyi.system.model.THelpNeeds;
import com.ruoyi.system.query.AssistedDiningListQuery;
import com.ruoyi.system.query.HelpNeedsListQuery;
import com.ruoyi.system.query.TCourseOrderQuery;
import com.ruoyi.system.service.THelpNeedsService;
import com.ruoyi.system.service.THelpNeedsService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.apache.poi.ss.usermodel.Workbook;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.bind.annotation.*;

import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.net.URLEncoder;
import java.util.Arrays;
import java.util.List;
import java.util.Objects;
import java.util.stream.Collectors;

/**
@@ -78,5 +91,35 @@
    public R<THelpNeeds> detail(Integer id) {
        return R.ok(helpNeedsService.getById( id));
    }

    @Log(title = "助需管理-助需记录导出", businessType = BusinessType.EXPORT)
    @ApiOperation(value = "助需记录导出")
    @PostMapping("/exportHelpNeeds")
    public void exportHelpNeeds(@RequestBody HelpNeedsListQuery query){
        List<THelpNeedsExport> helpNeedsExports = helpNeedsService.exportHelpNeeds(query);
        Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams(), THelpNeedsExport.class, helpNeedsExports);
        HttpServletResponse response = WebUtils.response();
        assert response != null;
        response.setContentType("application/vnd.ms-excel");
        response.setCharacterEncoding("utf-8");
        ServletOutputStream outputStream = null;
        try {
            String fileName = URLEncoder.encode("助需记录导出.xls", "utf-8");
            response.setHeader("Content-Disposition", "attachment;filename=" + fileName);
            response.setContentType("application/vnd.ms-excel;charset=UTF-8");
            response.setHeader("Pragma", "no-cache");
            response.setHeader("Cache-Control", "no-cache");
            outputStream = response.getOutputStream();
            workbook.write(outputStream);
        } catch (IOException e) {
            e.printStackTrace();
        } finally {
            try {
                outputStream.close();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
    }
}


 ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TMerchantController.java

@@ -1,24 +1,51 @@
package com.ruoyi.web.controller.api;


import cn.afterturn.easypoi.excel.ExcelExportUtil;
import cn.afterturn.easypoi.excel.ExcelImportUtil;
import cn.afterturn.easypoi.excel.entity.ExportParams;
import cn.afterturn.easypoi.excel.entity.ImportParams;
import cn.hutool.json.JSONObject;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.ruoyi.common.annotation.Log;
import com.ruoyi.common.basic.PageInfo;
import com.ruoyi.common.core.domain.BasePage;
import com.ruoyi.common.core.domain.R;
import com.ruoyi.common.core.exception.ServiceException;
import com.ruoyi.common.enums.BusinessType;
import com.ruoyi.common.utils.WebUtils;
import com.ruoyi.framework.web.service.TokenService;
import com.ruoyi.system.export.MerchantImport;
import com.ruoyi.system.export.OldsterImport;
import com.ruoyi.system.model.TMerchant;
import com.ruoyi.system.model.TMerchantType;
import com.ruoyi.system.model.TOldster;
import com.ruoyi.system.query.TMerchantQuery;
import com.ruoyi.system.service.TMerchantService;
import com.ruoyi.system.service.TMerchantTypeService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import lombok.extern.slf4j.Slf4j;
import org.apache.poi.ss.usermodel.Workbook;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.transaction.annotation.Propagation;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.util.CollectionUtils;
import org.springframework.util.StringUtils;
import org.springframework.validation.annotation.Validated;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;

import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.io.InputStream;
import java.net.URLEncoder;
import java.util.ArrayList;
import java.util.List;
import java.util.Objects;

/**
 * <p>
@@ -28,6 +55,7 @@
 * @author xiaochen
 * @since 2025-11-06
 */
@Slf4j
@Api(tags = "商户信息管理")
@RestController
@RequestMapping("/t-merchant")
@@ -115,6 +143,95 @@
    public R<Boolean> deleteByIds(@RequestBody List<String> ids) {
        return R.ok(merchantService.removeByIds(ids));
    }
    

    @ApiOperation(value = "商户导入模板下载")
    @GetMapping("/import-template")
    public void importTemplate() {
        List<MerchantImport> merchantImports = new ArrayList<>();
        MerchantImport merchantImport = new MerchantImport();
        merchantImports.add(merchantImport);
        Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams(), MerchantImport.class, merchantImports);
        HttpServletResponse response = WebUtils.response();
        ServletOutputStream outputStream = null;
        try {
            String fileName = URLEncoder.encode("商户信息导入模板.xls", "utf-8");
            response.setHeader("Content-Disposition", "attachment;filename=" + fileName);
            response.setHeader("content-Type", "application/vnd.ms-excel");
            response.setHeader("Pragma", "no-cache");
            response.setHeader("Cache-Control", "no-cache");
            outputStream = response.getOutputStream();
            workbook.write(outputStream);
        } catch (IOException e) {
            e.printStackTrace();
            System.out.println("商户信息导入模板下载失败!");
        } finally {
            try {
                outputStream.close();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
    }
    @Log(title = "商户信息导入", businessType = BusinessType.INSERT)
    @ApiOperation(value = "商户信息导入")
    @Transactional(rollbackFor = Exception.class, propagation = Propagation.REQUIRES_NEW)
    @PostMapping("/import")
    public R<String> importLocation(@RequestPart("file") MultipartFile file) {
        List<TMerchant> merchants = new ArrayList<>();
        ImportParams params = new ImportParams();
        params.setHeadRows(1); //表头行数
        InputStream inputStream = null;
        List<MerchantImport> merchantImports;
        try {
            inputStream = file.getInputStream();
            merchantImports = ExcelImportUtil.importExcel(inputStream,
                    MerchantImport.class, params);
        } catch (Exception e) {
            e.printStackTrace();
            log.error("商户信息导入失败:{}", e.getMessage());
            throw new ServiceException("商户信息导入失败!");
        } finally {
            try {
                inputStream.close();
            } catch (IOException e) {
                throw new ServiceException(e.getMessage());
            }
        }
        if (CollectionUtils.isEmpty(merchantImports)) {
            throw new ServiceException("商户信息数据为空!");
        }
        JSONObject result = new JSONObject();
        int i = 1;
        for (MerchantImport merchantImport : merchantImports) {
            if (!StringUtils.hasLength(merchantImport.getMerchantName())){
                result.append("第"+i+"行：[", "商户名称"+"]不能为空");
            }
            if (!StringUtils.hasLength(merchantImport.getMerchantPhone())){
                result.append("第"+i+"行：[", "商户电话"+"]不能为空");
            }
            if (!StringUtils.hasLength(merchantImport.getTypeName())){
                result.append("第"+i+"行：[", "商户分类"+"]不能为空");
            }
            if (!StringUtils.hasLength(merchantImport.getAddress())){
                result.append("第"+i+"行：[", "商户地址"+"]不能为空");
            }
            TMerchantType merchantType = merchantTypeService.getOne(Wrappers.lambdaQuery(TMerchantType.class)
                    .eq(TMerchantType::getTypeName, merchantImport.getTypeName())
                    .last("LIMIT 1"));
            if(Objects.isNull(merchantType)){
                result.append("第"+i+"行：[", "商户分类"+"]不存在");
            }
            TMerchant merchant = new TMerchant();
            BeanUtils.copyProperties(merchantImport, merchant);
            merchants.add(merchant);
            i++;
        }
        merchantService.saveBatch(merchants);
        if(!result.isEmpty()){
            return R.fail(result.toString());
        }
        return R.ok();
    }

}


 ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TMicroWishController.java

@@ -1,26 +1,39 @@
package com.ruoyi.web.controller.api;


import cn.afterturn.easypoi.excel.ExcelExportUtil;
import cn.afterturn.easypoi.excel.entity.ExportParams;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.ruoyi.common.annotation.Log;
import com.ruoyi.common.basic.PageInfo;
import com.ruoyi.common.core.domain.R;
import com.ruoyi.common.enums.BusinessType;
import com.ruoyi.common.utils.DateUtils;
import com.ruoyi.common.utils.WebUtils;
import com.ruoyi.system.dto.HandlingWishesDTO;
import com.ruoyi.system.dto.ReviewWishesDTO;
import com.ruoyi.system.export.TMicroWishExport;
import com.ruoyi.system.export.TRefundOrderExport;
import com.ruoyi.system.model.TCourse;
import com.ruoyi.system.model.TMicroWish;
import com.ruoyi.system.query.TCourseOrderQuery;
import com.ruoyi.system.query.TMicroWishQuery;
import com.ruoyi.system.service.TMicroWishService;
import com.ruoyi.system.service.TMicroWishService;
import com.ruoyi.system.vo.TMicroWishVO;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.apache.poi.ss.usermodel.Workbook;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.validation.annotation.Validated;
import org.springframework.web.bind.annotation.*;

import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.net.URLEncoder;
import java.util.List;
import java.util.Objects;

/**
 * <p>
@@ -108,5 +121,40 @@
        return R.ok();
    }

    @Log(title = "心愿发布信息-心愿记录导出", businessType = BusinessType.EXPORT)
    @ApiOperation(value = "心愿记录导出")
    @PostMapping("/exportMicroWish")
    public void exportMicroWish(@RequestBody TMicroWishQuery query){
        List<TMicroWishExport> microWishExports = microWishService.exportMicroWish(query);
        for (TMicroWishExport microWishExport : microWishExports) {
            if(Objects.nonNull(microWishExport.getCreateTime())){
                microWishExport.setCreateTimeStr(DateUtils.localDateTimeToString(microWishExport.getCreateTime()));
            }
        }
        Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams(), TMicroWishExport.class, microWishExports);
        HttpServletResponse response = WebUtils.response();
        assert response != null;
        response.setContentType("application/vnd.ms-excel");
        response.setCharacterEncoding("utf-8");
        ServletOutputStream outputStream = null;
        try {
            String fileName = URLEncoder.encode("心愿记录导出.xls", "utf-8");
            response.setHeader("Content-Disposition", "attachment;filename=" + fileName);
            response.setContentType("application/vnd.ms-excel;charset=UTF-8");
            response.setHeader("Pragma", "no-cache");
            response.setHeader("Cache-Control", "no-cache");
            outputStream = response.getOutputStream();
            workbook.write(outputStream);
        } catch (IOException e) {
            e.printStackTrace();
        } finally {
            try {
                outputStream.close();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
    }

}


 ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TOldsterController.java

@@ -15,6 +15,7 @@
import com.ruoyi.common.enums.BusinessType;
import com.ruoyi.common.utils.WebUtils;
import com.ruoyi.system.export.OldsterImport;
import com.ruoyi.system.model.TNotice;
import com.ruoyi.system.model.TOldster;
import com.ruoyi.system.query.BannerListQuery;
import com.ruoyi.system.query.OldsterListQuery;
@@ -82,6 +83,16 @@
        oldsterService.updateById(dto);
        return R.ok();
    }

    /**
     * 查看老人户籍信息详情
     */
    @ApiOperation(value = "查看老人户籍信息详情")
    @GetMapping(value = "/getDetailById")
    public R<TOldster> getDetailById(@RequestParam String id) {
        return R.ok(oldsterService.getById(id));
    }

    /**
     * 删除老人户籍信息
     */

 ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TOldsterWarningController.java

@@ -1,12 +1,22 @@
package com.ruoyi.web.controller.api;


import cn.afterturn.easypoi.excel.ExcelExportUtil;
import cn.afterturn.easypoi.excel.entity.ExportParams;
import com.ruoyi.common.annotation.Log;
import com.ruoyi.common.basic.PageInfo;
import com.ruoyi.common.core.domain.R;
import com.ruoyi.common.enums.BusinessType;
import com.ruoyi.common.utils.DateUtils;
import com.ruoyi.common.utils.WebUtils;
import com.ruoyi.system.export.TCourseOrderExport;
import com.ruoyi.system.export.TOldsterWarningExport;
import com.ruoyi.system.export.TRefundOrderExport;
import com.ruoyi.system.model.TOldster;
import com.ruoyi.system.model.TOldsterWarning;
import com.ruoyi.system.model.TPartyBuilding;
import com.ruoyi.system.query.OldsterListQuery;
import com.ruoyi.system.query.TCourseOrderQuery;
import com.ruoyi.system.query.TPartyBuildingQuery;
import com.ruoyi.system.service.TOldsterService;
import com.ruoyi.system.service.TOldsterWarningService;
@@ -15,10 +25,16 @@
import com.ruoyi.system.vo.TPartyBuildingVO;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.apache.poi.ss.usermodel.Workbook;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.net.URLEncoder;
import java.util.List;
import java.util.Objects;

/**
@@ -78,5 +94,40 @@
        return R.ok(oldsterWarningVO);
    }

    @Log(title = "老人预警管理-老人预警记录导出", businessType = BusinessType.EXPORT)
    @ApiOperation(value = "老人预警记录导出")
    @PostMapping("/exportOldsterWarning")
    public void exportOldsterWarning(@RequestBody TCourseOrderQuery query){
        List<TOldsterWarningExport> oldsterWarningExports = oldsterWarningService.exportOldsterWarning(query);
        for (TOldsterWarningExport oldsterWarningExport : oldsterWarningExports) {
            if(Objects.nonNull(oldsterWarningExport.getWarningTime())){
                oldsterWarningExport.setWarningTimeStr(DateUtils.localDateTimeToString(oldsterWarningExport.getWarningTime()));
            }
        }
        Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams(), TOldsterWarningExport.class, oldsterWarningExports);
        HttpServletResponse response = WebUtils.response();
        assert response != null;
        response.setContentType("application/vnd.ms-excel");
        response.setCharacterEncoding("utf-8");
        ServletOutputStream outputStream = null;
        try {
            String fileName = URLEncoder.encode("老人预警记录导出.xls", "utf-8");
            response.setHeader("Content-Disposition", "attachment;filename=" + fileName);
            response.setContentType("application/vnd.ms-excel;charset=UTF-8");
            response.setHeader("Pragma", "no-cache");
            response.setHeader("Cache-Control", "no-cache");
            outputStream = response.getOutputStream();
            workbook.write(outputStream);
        } catch (IOException e) {
            e.printStackTrace();
        } finally {
            try {
                outputStream.close();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
    }

}


 ruoyi-system/src/main/java/com/ruoyi/system/export/MerchantImport.java

New file
@@ -0,0 +1,30 @@
package com.ruoyi.system.export;

import cn.afterturn.easypoi.excel.annotation.Excel;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

import java.io.Serializable;

@Data
@ApiModel(value = "商户信息导入excel")
public class MerchantImport implements Serializable {

    @Excel(name = "商户名称",width = 20)
    @ApiModelProperty(value = "商户名称")
    private String merchantName;

    @ApiModelProperty(value = "商户电话")
    @Excel(name = "联系电话",width = 20)
    private String merchantPhone;

    @ApiModelProperty(value = "商户分类")
    @Excel(name = "商户分类",width = 20)
    private String typeName;

    @ApiModelProperty(value = "商户地址")
    @Excel(name = "商户地址",width = 20)
    private String address;

}

 ruoyi-system/src/main/java/com/ruoyi/system/export/TAppealServicesExport.java

New file
@@ -0,0 +1,42 @@
package com.ruoyi.system.export;

import cn.afterturn.easypoi.excel.annotation.Excel;
import com.baomidou.mybatisplus.annotation.TableField;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

import java.io.Serializable;
import java.time.LocalDateTime;

@Data
@ApiModel("诉求服务信息导出TAppealServicesExport")
public class TAppealServicesExport implements Serializable {

    @Excel(name = "诉求描述", width = 20)
    private String appealDescription;

    @Excel(name = "联系人", width = 20)
    private String contactPerson;

    @Excel(name = "联系电话", width = 20)
    private String contactPhone;

    @Excel(name = "提交时间", width = 20)
    private String createTimeStr;
    private LocalDateTime createTime;

    @Excel(name = "状态",width = 20,replace = {"待处理_1","已处理_2"})
    private Integer status;

    @Excel(name = "处理备注",width = 20)
    private String processRemark;

    @Excel(name = "处理人名称",width = 20)
    private String processPersonName;

    @Excel(name = "处理时间",width = 20)
    private String processTimeStr;
    private LocalDateTime processTime;

}

 ruoyi-system/src/main/java/com/ruoyi/system/export/TChildcareServicesExport.java

New file
@@ -0,0 +1,42 @@
package com.ruoyi.system.export;

import cn.afterturn.easypoi.excel.annotation.Excel;
import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModel;
import lombok.Data;

import java.io.Serializable;
import java.time.LocalDate;
import java.time.LocalDateTime;

@Data
@ApiModel(value = "托育服务导出TChildcareServicesExport")
public class TChildcareServicesExport implements Serializable {

    @Excel(name = "婴幼儿姓名",width = 20)
    private String userName;

    @Excel(name = "性别",width = 20,replace = {"男_1","女_2"})
    private Integer sex;

    @Excel(name = "出生日期",width = 20)
    @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
    private LocalDate birthDate;

    @Excel(name = "监护人姓名",width = 20)
    private String guardianName;

    @Excel(name = "联系方式",width = 20)
    private String guardianPhone;

    @Excel(name = "服务形式",width = 20,replace = {"全日_1","半日_2","计时_3","临时_4","其他_5"})
    private Integer serviceForm;

    @Excel(name = "备注",width = 20)
    private String remarks;

    @Excel(name = "提交时间",width = 20)
    private String createTimeStr;
    private LocalDateTime createTime;

}

 ruoyi-system/src/main/java/com/ruoyi/system/export/TCourseOrderExport.java

New file
@@ -0,0 +1,39 @@
package com.ruoyi.system.export;

import cn.afterturn.easypoi.excel.annotation.Excel;
import io.swagger.annotations.ApiModel;
import lombok.Data;

import java.io.Serializable;
import java.math.BigDecimal;
import java.time.LocalDateTime;

@Data
@ApiModel(value = "TCourseOrderExport")
public class TCourseOrderExport implements Serializable {

    @Excel(name = "报名时间",width = 20)
    private String payTimeStr;
    private LocalDateTime payTime;

    @Excel(name = "课程类型",width = 20,replace = {"社区大学课程_1","暑期青少年工艺培训班_2"})
    private Integer courseType;

    @Excel(name = "课程标题",width = 20)
    private String courseTitle;

    @Excel(name = "支付价格",width = 20)
    private BigDecimal payMoney;

    @Excel(name = "报名人",width = 20)
    private String realName;

    @Excel(name = "联系电话",width = 20)
    private String userPhone;

    @Excel(name = "身份证号",width = 20)
    private String idCard;

    @Excel(name = "状态",width = 20,replace = {"待支付_1","已支付_2","已退款_3"})
    private Integer payStatus;
}

 ruoyi-system/src/main/java/com/ruoyi/system/export/THelpNeedsExport.java

New file
@@ -0,0 +1,22 @@
package com.ruoyi.system.export;

import cn.afterturn.easypoi.excel.annotation.Excel;
import io.swagger.annotations.ApiModel;
import lombok.Data;

import java.io.Serializable;

@Data
@ApiModel(value = "助需管理导出THelpNeedsExport")
public class THelpNeedsExport implements Serializable {

    @Excel(name = "需求发布人", width = 20)
    private String nickName;

    @Excel(name = "联系电话", width = 20)
    private String contactNumber;

    @Excel(name = "需求描述", width = 40)
    private String requirementDescription;

}

 ruoyi-system/src/main/java/com/ruoyi/system/export/TMicroWishExport.java

New file
@@ -0,0 +1,37 @@
package com.ruoyi.system.export;

import cn.afterturn.easypoi.excel.annotation.Excel;
import com.baomidou.mybatisplus.annotation.TableField;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

import java.io.Serializable;
import java.time.LocalDateTime;

@Data
@ApiModel(value = "心愿发布信息导出对象TMicroWishExport")
public class TMicroWishExport implements Serializable {

    @Excel(name = "心愿类型",width = 20,replace = {"闲置_1","互助_2","其他_3"})
    private Integer wishType;

    @Excel(name = "心愿描述",width = 20)
    private String wishDescription;

    @Excel(name = "联系人",width = 20)
    private String contactPerson;

    @Excel(name = "联系电话",width = 20)
    private String contactPhone;

    @Excel(name = "居住地址",width = 20)
    private String address;

    @Excel(name = "提交时间",width = 20)
    private String createTimeStr;
    private LocalDateTime createTime;

    @Excel(name = "状态",width = 20,replace = {"待审核_1","已公开_2","已驳回_3","待处理_4","已处理_5"})
    private Integer status;
}

 ruoyi-system/src/main/java/com/ruoyi/system/export/TOldsterWarningExport.java

New file
@@ -0,0 +1,49 @@
package com.ruoyi.system.export;

import cn.afterturn.easypoi.excel.annotation.Excel;
import com.baomidou.mybatisplus.annotation.TableField;
import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModel;
import lombok.Data;

import java.io.Serializable;
import java.time.LocalDate;
import java.time.LocalDateTime;

@Data
@ApiModel(value = "老人预警导出对象TOldsterWarningExport")
public class TOldsterWarningExport implements Serializable {

    @Excel(name = "人员姓名", width = 20)
    private String oldsterName;

    @Excel(name = "性别", width = 20,replace = {"男_1","女_2"})
    private Integer oldsterSex;

    @Excel(name = "年龄", width = 20)
    private Integer oldsterAge;

    @Excel(name = "出生日期", width = 20)
    @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
    private LocalDate birthDate;

    @Excel(name = "联系电话", width = 20)
    private String contactPhone;

    @Excel(name = "人员类型", width = 20,replace = {"独居老人_1","高龄老人_2","散居特困供养老人_3","失能老人_4"})
    private Integer oldsterType;

    @Excel(name = "居住地址", width = 20)
    private String address;

    @Excel(name = "监护人", width = 20)
    private String guardianName;

    @Excel(name = "监护人联系电话", width = 20)
    private String guardianPhone;
    
    @Excel(name = "预警时间", width = 20)
    private String warningTimeStr;
    private LocalDateTime warningTime;
    private String idCard;
}

 ruoyi-system/src/main/java/com/ruoyi/system/export/TRefundOrderExport.java

New file
@@ -0,0 +1,50 @@
package com.ruoyi.system.export;

import cn.afterturn.easypoi.excel.annotation.Excel;
import io.swagger.annotations.ApiModel;
import lombok.Data;

import java.io.Serializable;
import java.math.BigDecimal;
import java.time.LocalDateTime;

@Data
@ApiModel(value = "退款记录导出TRefundOrderExport")
public class TRefundOrderExport implements Serializable {

    @Excel(name = "报名时间",width = 20)
    private String payTimeStr;
    private LocalDateTime payTime;

    @Excel(name = "课程类型",width = 20,replace = {"社区大学课程_1","暑期青少年工艺培训班_2"})
    private Integer courseType;

    @Excel(name = "课程标题",width = 20)
    private String courseTitle;

    @Excel(name = "支付价格",width = 20)
    private BigDecimal payMoney;

    @Excel(name = "报名人",width = 20)
    private String realName;

    @Excel(name = "联系电话",width = 20)
    private String userPhone;

    @Excel(name = "退款申请时间",width = 20)
    private String requestRefundTimeStr;
    private LocalDateTime requestRefundTime;

    @Excel(name = "银行卡号",width = 20)
    private String bankCardNumber;

    @Excel(name = "持卡人",width = 20)
    private String cardholderName;

    @Excel(name = "所属银行",width = 20)
    private String bankName;

    @Excel(name = "状态",width = 20,replace = {"待审核_1","已通过_2","已驳回_3"})
    private Integer refundStatus;

}

 ruoyi-system/src/main/java/com/ruoyi/system/mapper/TAppealServicesMapper.java

@@ -2,6 +2,7 @@

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.common.basic.PageInfo;
import com.ruoyi.system.export.TAppealServicesExport;
import com.ruoyi.system.model.TAppealServices;
import com.ruoyi.system.query.TAppealServicesQuery;
import com.ruoyi.system.vo.TAppealServicesVO;
@@ -23,4 +24,9 @@
     * 获取诉求服务管理分页列表
     */
    List<TAppealServicesVO> pageList(@Param("query") TAppealServicesQuery query, @Param("pageInfo")PageInfo<TAppealServicesVO> pageInfo);

    /**
     * 获取诉求服务管理列表
     */
    List<TAppealServicesExport> exportAppealServices(@Param("query")TAppealServicesQuery query);
}

 ruoyi-system/src/main/java/com/ruoyi/system/mapper/TChildcareServicesMapper.java

@@ -2,8 +2,10 @@

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.common.basic.PageInfo;
import com.ruoyi.system.export.TChildcareServicesExport;
import com.ruoyi.system.model.TChildcareServices;
import com.ruoyi.system.query.TChildcareServicesQuery;
import com.ruoyi.system.query.TCourseOrderQuery;
import com.ruoyi.system.vo.TChildcareServicesVO;
import org.apache.ibatis.annotations.Param;

@@ -23,4 +25,9 @@
     * 获取托育服务需求管理列表
     */
    List<TChildcareServicesVO> pageList(@Param("query") TChildcareServicesQuery query, @Param("pageInfo")PageInfo<TChildcareServicesVO> pageInfo);

    /**
     * 获取托育服务需求管理列表
     */
    List<TChildcareServicesExport> exportChildcareServices(@Param("query") TChildcareServicesQuery query);
}

 ruoyi-system/src/main/java/com/ruoyi/system/mapper/TCourseOrderMapper.java

@@ -2,6 +2,8 @@

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.common.basic.PageInfo;
import com.ruoyi.system.export.TCourseOrderExport;
import com.ruoyi.system.export.TRefundOrderExport;
import com.ruoyi.system.model.TCourseOrder;
import com.ruoyi.system.query.TCourseOrderQuery;
import com.ruoyi.system.vo.TCourseOrderVO;
@@ -29,4 +31,15 @@
     * 获取课程订单申请退款管理分页列表
     */
    List<TCourseOrderVO> refundPageList(@Param("query") TCourseOrderQuery query, @Param("pageInfo")PageInfo<TCourseOrderVO> pageInfo);

    /**
     * 获取课程订单管理列表
     */
    List<TCourseOrderExport> exportCourseOrder(@Param("query")TCourseOrderQuery query);

    /**
     * 获取课程申请退款记录列表
     */
    List<TRefundOrderExport> exportRefundOrder(@Param("query")TCourseOrderQuery query);

}

 ruoyi-system/src/main/java/com/ruoyi/system/mapper/THelpNeedsMapper.java

@@ -2,6 +2,7 @@

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.common.basic.PageInfo;
import com.ruoyi.system.export.THelpNeedsExport;
import com.ruoyi.system.model.THelpNeeds;
import com.ruoyi.system.query.HelpNeedsListQuery;
import org.apache.ibatis.annotations.Param;
@@ -20,4 +21,10 @@

    List<THelpNeeds> pageList(@Param("query") HelpNeedsListQuery query, @Param("pageInfo") PageInfo<THelpNeeds> pageInfo);

    /**
     * 助需记录导出
     * @param query
     * @return
     */
    List<THelpNeedsExport> exportHelpNeeds(@Param("query")HelpNeedsListQuery query);
}

 ruoyi-system/src/main/java/com/ruoyi/system/mapper/TMicroWishMapper.java

@@ -2,7 +2,9 @@

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.common.basic.PageInfo;
import com.ruoyi.system.export.TMicroWishExport;
import com.ruoyi.system.model.TMicroWish;
import com.ruoyi.system.query.TCourseOrderQuery;
import com.ruoyi.system.query.TMicroWishQuery;
import com.ruoyi.system.vo.TMicroWishVO;
import org.apache.ibatis.annotations.Param;
@@ -23,4 +25,9 @@
     * 获取心愿发布分页列表
     */
    List<TMicroWishVO> pageList(@Param("query") TMicroWishQuery query, @Param("pageInfo")PageInfo<TMicroWishVO> pageInfo);

    /**
     * 获取心愿记录导出列表
     */
    List<TMicroWishExport> exportMicroWish(@Param("query")TMicroWishQuery query);
}

 ruoyi-system/src/main/java/com/ruoyi/system/mapper/TOldsterWarningMapper.java

@@ -2,8 +2,10 @@

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.common.basic.PageInfo;
import com.ruoyi.system.export.TOldsterWarningExport;
import com.ruoyi.system.model.TOldsterWarning;
import com.ruoyi.system.query.OldsterListQuery;
import com.ruoyi.system.query.TCourseOrderQuery;
import com.ruoyi.system.vo.TOldsterWarningVO;
import org.apache.ibatis.annotations.Param;

@@ -26,4 +28,11 @@
     * @return
     */
    List<TOldsterWarningVO> pageList(@Param("query") OldsterListQuery query, @Param("pageInfo")PageInfo<TOldsterWarningVO> pageInfo);

    /**
     * 获取老人预警管理列表
     * @param query
     * @return
     */
    List<TOldsterWarningExport> exportOldsterWarning(@Param("query")TCourseOrderQuery query);
}

 ruoyi-system/src/main/java/com/ruoyi/system/model/TOldster.java

@@ -76,4 +76,8 @@
    @TableField("address")
    private String address;

    @ApiModelProperty(value = "年龄")
    @TableField(exist = false)
    private Integer age;

}

 ruoyi-system/src/main/java/com/ruoyi/system/query/TAppealServicesQuery.java

@@ -5,6 +5,8 @@
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

import javax.validation.constraints.NotNull;

@Data
@ApiModel(value = "诉求服务查询参数TAppealServicesQuery")
public class TAppealServicesQuery extends BasePage {
@@ -18,6 +20,7 @@
    @ApiModelProperty(value = "状态 1=待处理 2=已处理")
    private Integer status;

    @NotNull(message = "诉求类型不能为空")
    @ApiModelProperty(value = "诉求类型 1=群众诉求服务 2=随心拍")
    private Integer appealType;


 ruoyi-system/src/main/java/com/ruoyi/system/service/TAppealServicesService.java

@@ -2,9 +2,12 @@

import com.baomidou.mybatisplus.extension.service.IService;
import com.ruoyi.common.basic.PageInfo;
import com.ruoyi.system.export.TAppealServicesExport;
import com.ruoyi.system.model.TAppealServices;
import com.ruoyi.system.query.TAppealServicesQuery;
import com.ruoyi.system.vo.TAppealServicesVO;

import java.util.List;

/**
 * <p>
@@ -22,4 +25,10 @@
     * @return
     */
    PageInfo<TAppealServicesVO> pageList(TAppealServicesQuery query);

    /**
     * 获取诉求服务管理列表
     * @return
     */
    List<TAppealServicesExport> exportAppealServices(TAppealServicesQuery query);
}

 ruoyi-system/src/main/java/com/ruoyi/system/service/TChildcareServicesService.java

@@ -2,9 +2,13 @@

import com.baomidou.mybatisplus.extension.service.IService;
import com.ruoyi.common.basic.PageInfo;
import com.ruoyi.system.export.TChildcareServicesExport;
import com.ruoyi.system.model.TChildcareServices;
import com.ruoyi.system.query.TChildcareServicesQuery;
import com.ruoyi.system.query.TCourseOrderQuery;
import com.ruoyi.system.vo.TChildcareServicesVO;

import java.util.List;

/**
 * <p>
@@ -23,4 +27,11 @@
     */
    PageInfo<TChildcareServicesVO> pageList(TChildcareServicesQuery query);

    /**
     * 托育服务导出
     * @param query
     * @return
     */
    List<TChildcareServicesExport> exportChildcareServices(TChildcareServicesQuery query);

}

 ruoyi-system/src/main/java/com/ruoyi/system/service/TCourseOrderService.java

@@ -2,9 +2,13 @@

import com.baomidou.mybatisplus.extension.service.IService;
import com.ruoyi.common.basic.PageInfo;
import com.ruoyi.system.export.TCourseOrderExport;
import com.ruoyi.system.export.TRefundOrderExport;
import com.ruoyi.system.model.TCourseOrder;
import com.ruoyi.system.query.TCourseOrderQuery;
import com.ruoyi.system.vo.TCourseOrderVO;

import java.util.List;

/**
 * <p>
@@ -29,4 +33,16 @@
     * @return
     */
    PageInfo<TCourseOrderVO> refundPageList(TCourseOrderQuery query);

    /**
     * 导出报名记录
     * @return
     */
    List<TCourseOrderExport> exportCourseOrder(TCourseOrderQuery query);

    /**
     * 导出退款记录
     * @return
     */
    List<TRefundOrderExport> exportRefundOrder(TCourseOrderQuery query);
}

 ruoyi-system/src/main/java/com/ruoyi/system/service/THelpNeedsService.java

@@ -2,8 +2,11 @@

import com.baomidou.mybatisplus.extension.service.IService;
import com.ruoyi.common.basic.PageInfo;
import com.ruoyi.system.export.THelpNeedsExport;
import com.ruoyi.system.model.THelpNeeds;
import com.ruoyi.system.query.HelpNeedsListQuery;

import java.util.List;

/**
 * <p>
@@ -16,4 +19,12 @@
public interface THelpNeedsService extends IService<THelpNeeds> {

    PageInfo<THelpNeeds> pageList(HelpNeedsListQuery query);

    /**
     * 助需记录导出
     * @param query
     * @return
     */
    List<THelpNeedsExport> exportHelpNeeds(HelpNeedsListQuery query);

}

 ruoyi-system/src/main/java/com/ruoyi/system/service/TMicroWishService.java

@@ -2,9 +2,13 @@

import com.baomidou.mybatisplus.extension.service.IService;
import com.ruoyi.common.basic.PageInfo;
import com.ruoyi.system.export.TMicroWishExport;
import com.ruoyi.system.model.TMicroWish;
import com.ruoyi.system.query.TCourseOrderQuery;
import com.ruoyi.system.query.TMicroWishQuery;
import com.ruoyi.system.vo.TMicroWishVO;

import java.util.List;

/**
 * <p>
@@ -22,4 +26,12 @@
     * @return
     */
    PageInfo<TMicroWishVO> pageList(TMicroWishQuery query);

    /**
     * 心愿记录导出
     * @param query
     * @return
     */
    List<TMicroWishExport> exportMicroWish(TMicroWishQuery query);

}

 ruoyi-system/src/main/java/com/ruoyi/system/service/TOldsterWarningService.java

@@ -2,9 +2,13 @@

import com.baomidou.mybatisplus.extension.service.IService;
import com.ruoyi.common.basic.PageInfo;
import com.ruoyi.system.export.TOldsterWarningExport;
import com.ruoyi.system.model.TOldsterWarning;
import com.ruoyi.system.query.OldsterListQuery;
import com.ruoyi.system.query.TCourseOrderQuery;
import com.ruoyi.system.vo.TOldsterWarningVO;

import java.util.List;

/**
 * <p>
@@ -22,4 +26,12 @@
     * @return
     */
    PageInfo<TOldsterWarningVO> pageList(OldsterListQuery query);

    /**
     * 老人预警记录导出
     * @param query
     * @return
     */
    List<TOldsterWarningExport> exportOldsterWarning(TCourseOrderQuery query);
}


 ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TAppealServicesServiceImpl.java

@@ -2,6 +2,7 @@

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ruoyi.common.basic.PageInfo;
import com.ruoyi.system.export.TAppealServicesExport;
import com.ruoyi.system.mapper.TAppealServicesMapper;
import com.ruoyi.system.model.TAppealServices;
import com.ruoyi.system.query.TAppealServicesQuery;
@@ -30,4 +31,10 @@
        pageInfo.setRecords(list);
        return pageInfo;
    }

    @Override
    public List<TAppealServicesExport> exportAppealServices(TAppealServicesQuery query) {
        List<TAppealServicesExport> list = this.baseMapper.exportAppealServices(query);
        return list;
    }
}

 ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TChildcareServicesServiceImpl.java

@@ -2,9 +2,11 @@

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ruoyi.common.basic.PageInfo;
import com.ruoyi.system.export.TChildcareServicesExport;
import com.ruoyi.system.mapper.TChildcareServicesMapper;
import com.ruoyi.system.model.TChildcareServices;
import com.ruoyi.system.query.TChildcareServicesQuery;
import com.ruoyi.system.query.TCourseOrderQuery;
import com.ruoyi.system.service.TChildcareServicesService;
import com.ruoyi.system.vo.TChildcareServicesVO;
import com.ruoyi.system.vo.TPartyBuildingVO;
@@ -30,4 +32,10 @@
        pageInfo.setRecords(list);
        return pageInfo;
    }

    @Override
    public List<TChildcareServicesExport> exportChildcareServices(TChildcareServicesQuery query) {
        List<TChildcareServicesExport> list = this.baseMapper.exportChildcareServices(query);
        return list;
    }
}

 ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TCourseOrderServiceImpl.java

@@ -2,6 +2,8 @@

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ruoyi.common.basic.PageInfo;
import com.ruoyi.system.export.TCourseOrderExport;
import com.ruoyi.system.export.TRefundOrderExport;
import com.ruoyi.system.mapper.TCourseOrderMapper;
import com.ruoyi.system.model.TCourseOrder;
import com.ruoyi.system.query.TCourseOrderQuery;
@@ -38,4 +40,16 @@
        pageInfo.setRecords(list);
        return pageInfo;
    }

    @Override
    public List<TCourseOrderExport> exportCourseOrder(TCourseOrderQuery query) {
        List<TCourseOrderExport> list = this.baseMapper.exportCourseOrder(query);
        return list;
    }

    @Override
    public List<TRefundOrderExport> exportRefundOrder(TCourseOrderQuery query) {
        List<TRefundOrderExport> list = this.baseMapper.exportRefundOrder(query);
        return list;
    }
}

 ruoyi-system/src/main/java/com/ruoyi/system/service/impl/THelpNeedsServiceImpl.java

@@ -2,6 +2,7 @@

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ruoyi.common.basic.PageInfo;
import com.ruoyi.system.export.THelpNeedsExport;
import com.ruoyi.system.mapper.THelpNeedsMapper;
import com.ruoyi.system.model.TAssistedDining;
import com.ruoyi.system.model.THelpNeeds;
@@ -29,4 +30,10 @@
        pageInfo.setRecords( list);
        return pageInfo;
    }

    @Override
    public List<THelpNeedsExport> exportHelpNeeds(HelpNeedsListQuery query) {
        List<THelpNeedsExport> list = this.baseMapper.exportHelpNeeds(query);
        return list;
    }
}

 ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TMicroWishServiceImpl.java

@@ -2,9 +2,11 @@

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ruoyi.common.basic.PageInfo;
import com.ruoyi.system.export.TMicroWishExport;
import com.ruoyi.system.mapper.TMicroWishMapper;
import com.ruoyi.system.model.TAdvertisement;
import com.ruoyi.system.model.TMicroWish;
import com.ruoyi.system.query.TCourseOrderQuery;
import com.ruoyi.system.query.TMicroWishQuery;
import com.ruoyi.system.service.TMicroWishService;
import com.ruoyi.system.vo.TMicroWishVO;
@@ -30,4 +32,10 @@
        pageInfo.setRecords(list);
        return pageInfo;
    }

    @Override
    public List<TMicroWishExport> exportMicroWish(TMicroWishQuery query) {
        List<TMicroWishExport> list = this.baseMapper.exportMicroWish(query);
        return list;
    }
}

 ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TOldsterServiceImpl.java

@@ -7,7 +7,10 @@
import com.ruoyi.system.model.TOldster;
import com.ruoyi.system.query.OldsterListQuery;
import com.ruoyi.system.service.TOldsterService;
import com.ruoyi.system.utils.util.IDCardAgeCalculator;
import com.ruoyi.system.vo.TLargeKeyGridUserVO;
import org.springframework.stereotype.Service;
import org.springframework.util.CollectionUtils;

import java.util.List;

@@ -26,6 +29,14 @@
    public PageInfo<TOldster> pageList(OldsterListQuery query) {
        PageInfo<TOldster> pageInfo = new PageInfo<>(query.getPageNum(), query.getPageSize());
        List<TOldster> list = this.baseMapper.pageList(query,pageInfo);
        if(CollectionUtils.isEmpty(list)){
            return pageInfo;
        }

        for (TOldster oldster : list) {
            int age = IDCardAgeCalculator.calculateAge(oldster.getIdCard());
            oldster.setAge(age);
        }
        pageInfo.setRecords( list);
        return pageInfo;
    }

 ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TOldsterWarningServiceImpl.java

@@ -2,14 +2,20 @@

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ruoyi.common.basic.PageInfo;
import com.ruoyi.system.export.TOldsterWarningExport;
import com.ruoyi.system.mapper.TOldsterWarningMapper;
import com.ruoyi.system.model.TAdvertisement;
import com.ruoyi.system.model.TOldster;
import com.ruoyi.system.model.TOldsterWarning;
import com.ruoyi.system.query.OldsterListQuery;
import com.ruoyi.system.query.TCourseOrderQuery;
import com.ruoyi.system.service.TOldsterWarningService;
import com.ruoyi.system.utils.util.IDCardAgeCalculator;
import com.ruoyi.system.vo.TOldsterWarningVO;
import org.springframework.stereotype.Service;
import org.springframework.util.CollectionUtils;

import java.util.ArrayList;
import java.util.List;

/**
@@ -27,7 +33,27 @@
    public PageInfo<TOldsterWarningVO> pageList(OldsterListQuery query) {
        PageInfo<TOldsterWarningVO> pageInfo = new PageInfo<>(query.getPageNum(), query.getPageSize());
        List<TOldsterWarningVO> list = this.baseMapper.pageList(query,pageInfo);
        if(CollectionUtils.isEmpty(list)){
            return pageInfo;
        }
        for (TOldsterWarningVO oldsterWarningVO : list) {
            int age = IDCardAgeCalculator.calculateAge(oldsterWarningVO.getIdCard());
            oldsterWarningVO.setOldsterAge(age);
        }
        pageInfo.setRecords(list);
        return pageInfo;
    }

    @Override
    public List<TOldsterWarningExport> exportOldsterWarning(TCourseOrderQuery query) {
        List<TOldsterWarningExport> list = this.baseMapper.exportOldsterWarning(query);
        if(CollectionUtils.isEmpty(list)){
            return new ArrayList<>();
        }
        for (TOldsterWarningExport oldsterWarningExport : list) {
            int age = IDCardAgeCalculator.calculateAge(oldsterWarningExport.getIdCard());
            oldsterWarningExport.setOldsterAge(age);
        }
        return list;
    }
}

 ruoyi-system/src/main/resources/mapper/system/TAppealServicesMapper.xml

@@ -52,5 +52,26 @@
        </where>
        ORDER BY create_time DESC
    </select>
    <select id="exportAppealServices" resultType="com.ruoyi.system.export.TAppealServicesExport">
        SELECT
        <include refid="Base_Column_List"/>
        FROM t_appeal_services
        <where>
            <if test="query.contactPerson != null and query.contactPerson != ''">
                and contact_person LIKE CONCAT('%',#{query.contactPerson},'%')
            </if>
            <if test="query.contactPhone != null and query.contactPhone != ''">
                and contact_phone LIKE CONCAT('%',#{query.contactPhone},'%')
            </if>
            <if test="query.status != null">
                and status = #{query.status}
            </if>
            <if test="query.appealType != null">
                and appeal_type = #{query.appealType}
            </if>
            AND disabled = ${@com.ruoyi.common.enums.DisabledEnum@NO.getCode()}
        </where>
        ORDER BY create_time DESC
    </select>

</mapper>

 ruoyi-system/src/main/resources/mapper/system/TChildcareServicesMapper.xml

@@ -46,5 +46,27 @@
        </where>
        ORDER BY create_time DESC
    </select>
    <select id="exportChildcareServices" resultType="com.ruoyi.system.export.TChildcareServicesExport">
        SELECT
        <include refid="Base_Column_List"/>
        FROM t_childcare_services
        <where>
            <if test="query.userName != null and query.userName != ''">
                AND user_name LIKE CONCAT('%',#{query.userName},'%')
            </if>
            <if test="query.guardianName != null and query.guardianName != ''">
                AND guardian_name LIKE CONCAT('%',#{query.guardianName},'%')
            </if>
            <if test="query.guardianPhone != null and query.guardianPhone != ''">
                AND guardian_phone LIKE CONCAT('%',#{query.guardianPhone},'%')
            </if>
            <if test="query.startTime != null and query.startTime != '' and query.endTime != null and query.endTime != ''">
                AND create_time &gt;= #{query.startTime}
                AND create_time &lt;= #{query.endTime}
            </if>
            AND disabled = ${@com.ruoyi.common.enums.DisabledEnum@NO.getCode()}
        </where>
        ORDER BY create_time DESC
    </select>

</mapper>

 ruoyi-system/src/main/resources/mapper/system/TCourseOrderMapper.xml

@@ -100,5 +100,62 @@
        </where>
        ORDER BY tco.create_time DESC
    </select>
    <select id="exportCourseOrder" resultType="com.ruoyi.system.export.TCourseOrderExport">
        select tco.id, tco.course_id, tco.app_user_id, tco.pay_type, tco.pay_time, tco.pay_money, tco.order_number,tco.transaction_id,
        tco.real_name, tco.user_phone, tco.id_card, tco.pay_status, tco.request_refund_time, tco.refund_money, tco.refund_reason,
        tco.refund_reason_pictures,tco.refund_number, tco.refund_transaction_id, tco.bank_card_number, tco.cardholder_name,
        tco.bank_name, tco.refund_status, tco.refund_voucher, tco.reject_reason, tco.create_time, tco.update_time, tco.create_by,
        tco.update_by, tco.disabled,tc.course_title,tc.course_type
        from t_course_order tco
        left join t_course tc on tc.id = tco.course_id
        <where>
            <if test="query.courseTitle != null and query.courseTitle != ''">
                AND tc.course_title LIKE concat('%',#{query.courseTitle},'%')
            </if>
            <if test="query.courseType != null">
                AND tc.course_type = #{query.courseType}
            </if>
            <if test="query.realName != null and query.realName != ''">
                AND tco.real_name LIKE concat('%',#{query.realName},'%')
            </if>
            <if test="query.userPhone != null and query.userPhone != ''">
                AND tco.user_phone LIKE concat('%',#{query.userPhone},'%')
            </if>
            <if test="query.payStatus != null">
                AND tco.pay_status = #{query.payStatus}
            </if>
            AND tco.disabled = ${@com.ruoyi.common.enums.DisabledEnum@NO.getCode()}
        </where>
        ORDER BY tco.create_time DESC
    </select>
    <select id="exportRefundOrder" resultType="com.ruoyi.system.export.TRefundOrderExport">
        select tco.id, tco.course_id, tco.app_user_id, tco.pay_type, tco.pay_time, tco.pay_money, tco.order_number,tco.transaction_id,
        tco.real_name, tco.user_phone, tco.id_card, tco.pay_status, tco.request_refund_time, tco.refund_money, tco.refund_reason,
        tco.refund_reason_pictures,tco.refund_number, tco.refund_transaction_id, tco.bank_card_number, tco.cardholder_name,
        tco.bank_name, tco.refund_status, tco.refund_voucher, tco.reject_reason, tco.create_time, tco.update_time, tco.create_by,
        tco.update_by, tco.disabled,tc.course_title,tc.course_type
        from t_course_order tco
        left join t_course tc on tc.id = tco.course_id
        <where>
            <if test="query.courseTitle != null and query.courseTitle != ''">
                AND tc.course_title LIKE concat('%',#{query.courseTitle},'%')
            </if>
            <if test="query.courseType != null">
                AND tc.course_type = #{query.courseType}
            </if>
            <if test="query.realName != null and query.realName != ''">
                AND tco.real_name LIKE concat('%',#{query.realName},'%')
            </if>
            <if test="query.userPhone != null and query.userPhone != ''">
                AND tco.user_phone LIKE concat('%',#{query.userPhone},'%')
            </if>
            <if test="query.payStatus != null">
                AND tco.pay_status = #{query.payStatus}
            </if>
            AND tco.bank_card_number IS NOT NULL
            AND tco.disabled = ${@com.ruoyi.common.enums.DisabledEnum@NO.getCode()}
        </where>
        ORDER BY tco.create_time DESC
    </select>

</mapper>

 ruoyi-system/src/main/resources/mapper/system/THelpNeedsMapper.xml

@@ -34,5 +34,18 @@
            and t1.create_time between #{query.startTime} and #{query.endTime}
        </if>
    </select>
    <select id="exportHelpNeeds" resultType="com.ruoyi.system.export.THelpNeedsExport">
        select t1.* from t_help_needs
        where 1=1
        <if test="query.nickName != null and query.nickName != ''">
            and t1.nick_name like concat('%',#{query.nickName},'%')
        </if>
        <if test="query.contactNumber != null and query.contactNumber != ''">
            and t1.contact_number like concat('%',#{query.contactNumber},'%')
        </if>
        <if test="query.startTime != null and query.startTime != '' and query.endTime != null and query.endTime != ''">
            and t1.create_time between #{query.startTime} and #{query.endTime}
        </if>
    </select>

</mapper>

 ruoyi-system/src/main/resources/mapper/system/TMicroWishMapper.xml

@@ -50,5 +50,26 @@
        </where>
        ORDER BY create_time DESC
    </select>
    <select id="exportMicroWish" resultType="com.ruoyi.system.export.TMicroWishExport">
        select
        <include refid="Base_Column_List"/>
        from t_micro_wish
        <where>
            <if test="query.wishType != null">
                and wish_type = #{query.wishType}
            </if>
            <if test="query.status != null">
                and status = #{query.status}
            </if>
            <if test="query.contactPerson != null and query.contactPerson != ''">
                and contact_person like concat('%',#{query.contactPerson},'%')
            </if>
            <if test="query.contactPhone != null and query.contactPhone != ''">
                and contact_phone like concat('%',#{query.contactPhone},'%')
            </if>
            AND disabled = ${@com.ruoyi.common.enums.DisabledEnum@NO.getCode()}
        </where>
        ORDER BY create_time DESC
    </select>

</mapper>

 ruoyi-system/src/main/resources/mapper/system/TOldsterWarningMapper.xml

@@ -38,5 +38,25 @@
        </where>
        order by tow.warning_time desc
    </select>
    <select id="exportOldsterWarning" resultType="com.ruoyi.system.export.TOldsterWarningExport">
        select t.id, t.oldster_id, t.warning_time, t.create_time, t.update_time, t.create_by, t.update_by, t.disabled,
        tow.oldster_name, tow.oldster_age, tow.oldster_sex, tow.contact_phone, tow.guardian_name, tow.guardian_phone,
        tow.passport_photo, tow.id_card, tow.birth_date, tow.oldster_type, tow.address
        from t_oldster_warning tow
        left join t_oldster t on tow.oldster_id = t.id
        <where>
            <if test="query.oldsterName != null and query.oldsterName != ''">
                and t.oldster_name like concat('%',#{query.oldsterName},'%')
            </if>
            <if test="query.oldsterType != null and query.oldsterType != ''">
                and t.oldster_type = #{query.oldsterType}
            </if>
            <if test="query.contactPhone != null and query.contactPhone != ''">
                and t.contact_phone like concat('%',#{query.contactPhone},'%')
            </if>
            AND tow.disabled = ${@com.ruoyi.common.enums.DisabledEnum@NO.getCode()}
        </where>
        order by tow.warning_time desc
    </select>

</mapper>