package com.yuanchu.mom.service.impl; import com.alibaba.excel.EasyExcel; import com.alibaba.excel.ExcelWriter; import com.alibaba.excel.write.metadata.WriteSheet; import com.alibaba.excel.write.style.column.LongestMatchColumnWidthStyleStrategy; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.core.toolkit.ObjectUtils; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.deepoove.poi.XWPFTemplate; import com.deepoove.poi.config.Configure; import com.deepoove.poi.config.ConfigureBuilder; import com.yuanchu.mom.dto.PersonCommunicationAbilityDto; import com.yuanchu.mom.mapper.UserMapper; import com.yuanchu.mom.pojo.PersonCommunicationAbility; import com.yuanchu.mom.mapper.PersonCommunicationAbilityMapper; import com.yuanchu.mom.pojo.User; import com.yuanchu.mom.service.PersonCommunicationAbilityService; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; 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.time.format.DateTimeFormatter; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.stream.Collectors; /** *

* 沟通能力 服务实现类 *

* * @author * @since 2024-10-09 12:00:57 */ @Service public class PersonCommunicationAbilityServiceImpl extends ServiceImpl implements PersonCommunicationAbilityService { @Resource UserMapper userMapper; @Override public IPage personPersonCommunicationAbilityPage(Page page, Integer departLimsId, Integer userId, String userName) { IPage personCommunicationAbilityDtoIPage = baseMapper.personPersonCommunicationAbilityPage(page, departLimsId, userId, userName); List collect = personCommunicationAbilityDtoIPage.getRecords().stream().map(personCommunicationAbilityDto -> { if (ObjectUtils.isNotEmpty(personCommunicationAbilityDto.getUserId())) { List account = new ArrayList<>(); List name = new ArrayList<>(); for (String s : personCommunicationAbilityDto.getUserId().split(",")) { User user = userMapper.selectById(Integer.parseInt(s)); account.add(user.getAccount()); name.add(user.getName()); } personCommunicationAbilityDto.setAccount(account.stream().collect(Collectors.joining(","))); personCommunicationAbilityDto.setUserName(name.stream().collect(Collectors.joining(","))); } return personCommunicationAbilityDto; // 这里可以对返回的数据进行处理,如添加一些新的属性或转换等。 }).collect(Collectors.toList()); personCommunicationAbilityDtoIPage.setRecords(collect); return personCommunicationAbilityDtoIPage; } @Override public void exportPersonCommunicationAbility(Integer id, HttpServletResponse response) throws Exception { PersonCommunicationAbility personCommunicationAbility = baseMapper.selectById(id); //沟通人 String collect = " "; if (ObjectUtils.isNotEmpty(personCommunicationAbility.getUserId())) { List name = new ArrayList<>(); for (String s : personCommunicationAbility.getUserId().split(",")) { User user = userMapper.selectById(Integer.parseInt(s)); name.add(user.getName()); } collect = name.stream().collect(Collectors.joining(",")); } DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy年MM月dd日"); //时间 String communicationTime = ""; if (ObjectUtils.isNotEmpty(personCommunicationAbility.getCommunicationTime())) { communicationTime = personCommunicationAbility.getCommunicationTime().format(formatter); } InputStream inputStream = this.getClass().getResourceAsStream("/static/communication-deal.docx"); ConfigureBuilder builder = Configure.builder(); builder.useSpringEL(true); String finalCollect = collect; String finalCommunicationTime = communicationTime; XWPFTemplate template = XWPFTemplate.compile(inputStream, builder.build()).render( new HashMap() {{ put("userName", finalCollect); put("communicationTime", finalCommunicationTime); put("communicationPlace", personCommunicationAbility.getCommunicationPlace()); put("communicationContent", personCommunicationAbility.getCommunicationContent()); }}); 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(); } catch (Exception e) { e.printStackTrace(); throw new RuntimeException("导出失败"); } } }