| | |
| | | import com.ruoyi.common.utils.HackLoopTableRenderPolicy; |
| | | import com.ruoyi.production.pojo.ProductOrder; |
| | | import com.ruoyi.production.pojo.ProductWorkOrder; |
| | | import com.ruoyi.project.system.domain.SysNotice; |
| | | import com.ruoyi.safe.dto.SafeTrainingDetailsDto; |
| | | import com.ruoyi.safe.dto.SafeTrainingDto; |
| | | import com.ruoyi.safe.mapper.SafeTrainingDetailsMapper; |
| | |
| | | import com.ruoyi.safe.service.SafeTrainingService; |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.scheduling.annotation.Scheduled; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import javax.servlet.http.HttpServletResponse; |
| | | import java.io.InputStream; |
| | | import java.io.OutputStream; |
| | | import java.net.URLEncoder; |
| | | import java.text.ParseException; |
| | | import java.text.SimpleDateFormat; |
| | | import java.time.LocalDate; |
| | | import java.time.LocalDateTime; |
| | | import java.time.ZoneId; |
| | | import java.time.format.DateTimeFormatter; |
| | | import java.util.Date; |
| | | import java.util.HashMap; |
| | | import java.util.List; |
| | | |
| | |
| | | @Override |
| | | public SafeTrainingDto getSafeTraining(Long id) { |
| | | //主表数据 |
| | | SafeTrainingDto safeTrainingDto=safeTrainingMapper.getSafeTraining(id); |
| | | SafeTrainingDto safeTrainingDto = safeTrainingMapper.getSafeTraining(id); |
| | | //附件 |
| | | List<SafeTrainingFile> safeTrainingFiles = safeTrainingFileMapper.selectList(Wrappers.<SafeTrainingFile>lambdaQuery().eq(SafeTrainingFile::getSafeTrainingId, id)); |
| | | safeTrainingDto.setSafeTrainingFileList(safeTrainingFiles); |
| | | if (safeTrainingFiles.size()>0){ |
| | | safeTrainingDto.setSafeTrainingFileList(safeTrainingFiles); |
| | | } |
| | | //培训记录详情 |
| | | List<SafeTrainingDetailsDto> safeTrainingDetailsDto=safeTrainingDetailsMapper.getSafeTraining(id); |
| | | safeTrainingDto.setSafeTrainingDetailsDtoList(safeTrainingDetailsDto); |
| | | List<SafeTrainingDetailsDto> safeTrainingDetailsDto = safeTrainingDetailsMapper.getSafeTraining(id); |
| | | if (safeTrainingDetailsDto.size()>0) { |
| | | safeTrainingDto.setSafeTrainingDetailsDtoList(safeTrainingDetailsDto); |
| | | } |
| | | return safeTrainingDto; |
| | | } |
| | | |
| | |
| | | //删除主表 |
| | | safeTrainingMapper.deleteBatchIds(ids); |
| | | //删除附件 |
| | | safeTrainingFileMapper.delete(Wrappers.<SafeTrainingFile>lambdaQuery().in(SafeTrainingFile::getSafeTrainingId,ids)); |
| | | safeTrainingFileMapper.delete(Wrappers.<SafeTrainingFile>lambdaQuery().in(SafeTrainingFile::getSafeTrainingId, ids)); |
| | | //删除培训记录 |
| | | safeTrainingDetailsMapper.delete(Wrappers.<SafeTrainingDetails>lambdaQuery().in(SafeTrainingDetails::getSafeTrainingId,ids)); |
| | | safeTrainingDetailsMapper.delete(Wrappers.<SafeTrainingDetails>lambdaQuery().in(SafeTrainingDetails::getSafeTrainingId, ids)); |
| | | return 0; |
| | | } |
| | | |
| | | @Override |
| | | public void export(HttpServletResponse response, Long id) { |
| | | SafeTrainingDto safeTrainingDto = safeTrainingMapper.getSafeTraining(id); |
| | | List<SafeTrainingDetailsDto> safeTrainingDetailsDtoList=safeTrainingDetailsMapper.getSafeTraining(id); |
| | | List<SafeTrainingDetailsDto> safeTrainingDetailsDtoList = safeTrainingDetailsMapper.getSafeTraining(id); |
| | | InputStream inputStream = this.getClass().getResourceAsStream("/static/safe-training.docx"); |
| | | Configure configure = Configure.builder() |
| | | .bind("safeTrainingDetailsDtoList", new HackLoopTableRenderPolicy()) |
| | |
| | | try { |
| | | response.setContentType("application/msword"); |
| | | String fileName = URLEncoder.encode( |
| | | safeTrainingDto.getCourseCode()+"培训与考核计划", "UTF-8"); |
| | | safeTrainingDto.getCourseCode() + "培训与考核计划", "UTF-8"); |
| | | response.setHeader("Access-Control-Expose-Headers", "Content-Disposition"); |
| | | response.setHeader("Content-disposition", |
| | | "attachment;filename=" + fileName + ".docx"); |