From 4f3a98f19143865cdc1de4791e8a95d96bd40c65 Mon Sep 17 00:00:00 2001 From: maven <2163098428@qq.com> Date: 星期五, 01 八月 2025 13:27:59 +0800 Subject: [PATCH] yys 密码已重置 --- cnas-require/src/main/java/com/ruoyi/require/service/impl/ForeignRegisterServiceImpl.java | 102 +++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 102 insertions(+), 0 deletions(-) diff --git a/cnas-require/src/main/java/com/ruoyi/require/service/impl/ForeignRegisterServiceImpl.java b/cnas-require/src/main/java/com/ruoyi/require/service/impl/ForeignRegisterServiceImpl.java new file mode 100644 index 0000000..c8f4f0e --- /dev/null +++ b/cnas-require/src/main/java/com/ruoyi/require/service/impl/ForeignRegisterServiceImpl.java @@ -0,0 +1,102 @@ +package com.ruoyi.require.service.impl; + +import com.baomidou.mybatisplus.core.metadata.IPage; +import com.baomidou.mybatisplus.core.toolkit.StringUtils; +import com.baomidou.mybatisplus.extension.plugins.pagination.Page; +import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; +import com.deepoove.poi.XWPFTemplate; +import com.deepoove.poi.config.Configure; +import com.deepoove.poi.data.Pictures; +import com.ruoyi.common.utils.QueryWrappers; +import com.ruoyi.inspect.util.HackLoopTableRenderPolicy; +import com.ruoyi.require.dto.ForeignRegisterDto; +import com.ruoyi.require.mapper.ForeignRegisterMapper; +import com.ruoyi.require.pojo.ForeignRegister; +import com.ruoyi.require.service.ForeignRegisterService; +import com.ruoyi.system.mapper.UserMapper; +import org.springframework.beans.factory.annotation.Value; +import org.springframework.stereotype.Service; + +import javax.annotation.Resource; +import javax.servlet.http.HttpServletResponse; +import java.io.InputStream; +import java.io.OutputStream; +import java.net.URLEncoder; +import java.util.HashMap; +import java.util.List; + +/** + * <p> + * 澶栨潵浜哄憳鐧昏 鏈嶅姟瀹炵幇绫� + * </p> + * + * @author + * @since 2024-11-19 07:17:35 + */ +@Service +public class ForeignRegisterServiceImpl extends ServiceImpl<ForeignRegisterMapper, ForeignRegister> implements ForeignRegisterService { + @Resource + private UserMapper userMapper; + @Value("${file.path}") + private String imgUrl; + + /** + * 澶栨潵浜哄憳鐧昏鍒嗛〉鏌ヨ + * @param page + * @param foreignRegister + * @return + */ + @Override + public IPage<ForeignRegisterDto> pageForeignRegister(Page page, ForeignRegisterDto foreignRegister) { + String beginDate = foreignRegister.getBeginDate(); + String endDate = foreignRegister.getEndDate(); + foreignRegister.setBeginDate(null); + foreignRegister.setEndDate(null); + return baseMapper.pageForeignRegister(page, QueryWrappers.queryWrappers(foreignRegister), beginDate, endDate); + } + + /** + * 瀵煎嚭澶栨潵浜哄憳鐧昏 + * @param foreignRegister + */ + @Override + public void exportForeignRegister(ForeignRegisterDto foreignRegister, HttpServletResponse response) { + String beginDate = foreignRegister.getBeginDate(); + String endDate = foreignRegister.getEndDate(); + foreignRegister.setBeginDate(null); + foreignRegister.setEndDate(null); + List<ForeignRegisterDto> register = baseMapper.getForeignRegisterList(QueryWrappers.queryWrappers(foreignRegister), beginDate, endDate); + + for (ForeignRegisterDto foreignRegisterDto : register) { + // 娣诲姞鍗忓悓浜哄拰鎵瑰噯浜虹鍚� + foreignRegisterDto.setAccompanyingRender(StringUtils.isNotBlank(foreignRegisterDto.getAccompanyingUrl()) + ? Pictures.ofLocal(imgUrl + "/" + foreignRegisterDto.getAccompanyingUrl()).create() : null); + foreignRegisterDto.setApproveRender(StringUtils.isNotBlank(foreignRegisterDto.getApproveUrl()) + ? Pictures.ofLocal(imgUrl + "/" + foreignRegisterDto.getApproveUrl()).create() : null); + } + // 鑾峰彇璺緞 + InputStream inputStream = this.getClass().getResourceAsStream("/static/foreign-register.docx"); + Configure configure = Configure.builder() + .bind("register", new HackLoopTableRenderPolicy()) + .build(); + XWPFTemplate template = XWPFTemplate.compile(inputStream, configure).render( + new HashMap<String, Object>() {{ + put("register", register); + }}); + try { + response.setContentType("application/msword"); + String fileName = URLEncoder.encode( + "澶栨潵浜哄憳鐧昏", "UTF-8"); + response.setHeader("Content-disposition", + "attachment;filename=" + fileName + ".docx"); + OutputStream os = response.getOutputStream(); + template.write(os); + os.flush(); + os.close(); + inputStream.close(); + } catch (Exception e) { + e.printStackTrace(); + throw new RuntimeException("瀵煎嚭澶辫触"); + } + } +} -- Gitblit v1.9.3