package com.ruoyi.personnel.service.impl;
|
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.core.toolkit.ObjectUtils;
|
import com.baomidou.mybatisplus.core.toolkit.StringUtils;
|
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
|
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.config.ConfigureBuilder;
|
import com.deepoove.poi.data.FilePictureRenderData;
|
import com.ruoyi.common.core.domain.entity.User;
|
import com.ruoyi.framework.exception.ErrorException;
|
import com.ruoyi.personnel.dto.PersonPostAuthorizationRecordDto;
|
import com.ruoyi.personnel.mapper.PersonBasicInfoMapper;
|
import com.ruoyi.personnel.mapper.PersonPostAuthorizationRecordMapper;
|
import com.ruoyi.personnel.pojo.PersonBasicInfo;
|
import com.ruoyi.personnel.pojo.PersonPostAuthorizationRecord;
|
import com.ruoyi.personnel.service.PersonPostAuthorizationRecordService;
|
import com.ruoyi.system.mapper.UserMapper;
|
import org.springframework.beans.factory.annotation.Value;
|
import org.springframework.stereotype.Service;
|
|
import jakarta.annotation.Resource;
|
import jakarta.servlet.http.HttpServletResponse;
|
import java.io.File;
|
import java.io.InputStream;
|
import java.io.OutputStream;
|
import java.net.URLEncoder;
|
import java.time.LocalDateTime;
|
import java.util.HashMap;
|
|
/**
|
* <p>
|
* 任职授权记录 服务实现类
|
* </p>
|
*
|
* @author
|
* @since 2024-10-09 10:48:17
|
*/
|
@Service
|
public class PersonPostAuthorizationRecordServiceImpl extends ServiceImpl<PersonPostAuthorizationRecordMapper, PersonPostAuthorizationRecord> implements PersonPostAuthorizationRecordService {
|
|
@Resource
|
private UserMapper userMapper;
|
@Resource
|
private PersonBasicInfoMapper personBasicInfoMapper;
|
|
@Value("${file.path}")
|
private String imgUrl;
|
|
@Override
|
public IPage<PersonPostAuthorizationRecordDto> personPostAuthorizationRecordPage(Page page, Integer departLimsId, Integer userId, String userName) {
|
return baseMapper.personPostAuthorizationRecordPage(page, departLimsId, userId, userName);
|
}
|
|
@Override
|
public void exportPersonPostAuthorizationRecord(Integer id, HttpServletResponse response) {
|
if (id == null) {
|
throw new ErrorException("缺少任职授权记录id");
|
}
|
PersonPostAuthorizationRecord personPostAuthorizationRecord = baseMapper.selectById(id);
|
if (personPostAuthorizationRecord == null) {
|
throw new ErrorException("任职授权记录不存在或已被删除");
|
}
|
Integer incumbentUserId;
|
try {
|
incumbentUserId = Integer.valueOf(personPostAuthorizationRecord.getUserId());
|
} catch (Exception e) {
|
throw new ErrorException("该记录没有选择被任职人员，无法导出上岗证");
|
}
|
//姓名
|
User user = userMapper.selectById(incumbentUserId);
|
if (user == null) {
|
throw new ErrorException("被任职人员不存在或已被删除，无法导出上岗证");
|
}
|
String name = user.getName();
|
//身份证号
|
PersonBasicInfo basicInfo = personBasicInfoMapper.selectOne(Wrappers.<PersonBasicInfo>lambdaQuery()
|
.eq(PersonBasicInfo::getUserId, incumbentUserId)
|
.last("limit 1"));
|
if (basicInfo == null || StringUtils.isBlank(basicInfo.getIdentityCard())) {
|
throw new ErrorException(name + "还没有在人员基本信息中填写身份证号，无法导出上岗证");
|
}
|
String identityCard = basicInfo.getIdentityCard();
|
//证书编号
|
String code = personPostAuthorizationRecord.getCertificateNumber();
|
if (StringUtils.isBlank(code)) {
|
throw new ErrorException("该记录还没有填写证书编号，无法导出上岗证");
|
}
|
//任职岗位
|
String post = personPostAuthorizationRecord.getPost();
|
String finalPost = StringUtils.isBlank(post) ? "检测" : post;
|
//发证时间
|
LocalDateTime createTime = personPostAuthorizationRecord.getCreateTime();
|
if (createTime == null) {
|
createTime = LocalDateTime.now();
|
}
|
String year = createTime.getYear() + "";
|
String mon = createTime.getMonthValue() + "";
|
String day = createTime.getDayOfMonth() + "";
|
//个人照片
|
if (ObjectUtils.isEmpty(user.getPictureUrl())) {
|
throw new ErrorException(name + "的个人照片没有上传，无法导出上岗证");
|
}
|
String pictureUrl = user.getPictureUrl();
|
if (!new File(imgUrl + "/" + pictureUrl).exists()) {
|
throw new ErrorException(name + "的个人照片文件不存在，请重新上传");
|
}
|
|
InputStream inputStream = this.getClass().getResourceAsStream("/static/credentials-deal.docx");
|
if (inputStream == null) {
|
throw new ErrorException("上岗证导出模板不存在");
|
}
|
ConfigureBuilder builder = Configure.builder();
|
builder.useSpringEL(true);
|
XWPFTemplate template = XWPFTemplate.compile(inputStream, builder.build()).render(
|
new HashMap<String, Object>() {{
|
put("name", name);
|
put("identityCard", identityCard);
|
put("code", code);
|
put("post", finalPost);
|
put("year", year);
|
put("mon", mon);
|
put("day", day);
|
put("writeUrl", new FilePictureRenderData(100, 140, imgUrl + "/" + pictureUrl));
|
}});
|
|
try {
|
response.setContentType("application/msword");
|
String fileName = URLEncoder.encode(
|
name + "的检测人员上岗证", "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("导出失败");
|
}
|
|
}
|
}
|
