zhuo
2025-03-14 6267c533c30c8561fab289870923c039b160a669
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
1001
1002
1003
1004
1005
1006
1007
1008
1009
1010
1011
1012
1013
1014
1015
1016
1017
1018
1019
1020
1021
1022
1023
1024
1025
1026
1027
1028
1029
1030
1031
1032
1033
1034
1035
1036
1037
1038
1039
1040
1041
1042
1043
1044
1045
1046
1047
1048
1049
1050
1051
1052
1053
1054
1055
1056
1057
1058
1059
1060
1061
1062
1063
1064
1065
1066
1067
1068
1069
1070
1071
1072
1073
1074
1075
1076
1077
1078
1079
1080
1081
1082
1083
1084
1085
1086
1087
1088
1089
1090
1091
1092
1093
1094
1095
1096
1097
1098
1099
1100
1101
1102
1103
1104
1105
1106
1107
1108
1109
1110
1111
1112
1113
1114
1115
1116
1117
1118
1119
package com.ruoyi.process.service.impl;
 
import com.alibaba.excel.EasyExcel;
import com.alibaba.excel.context.AnalysisContext;
import com.alibaba.excel.event.AnalysisEventListener;
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.PictureRenderData;
import com.deepoove.poi.data.Pictures;
import com.ruoyi.common.constant.MenuJumpPathConstants;
import com.ruoyi.common.core.domain.entity.InformationNotification;
import com.ruoyi.common.core.domain.entity.User;
import com.ruoyi.common.utils.DateImageUtil;
import com.ruoyi.common.utils.QueryWrappers;
import com.ruoyi.common.utils.SecurityUtils;
import com.ruoyi.common.utils.WxCpUtils;
import com.ruoyi.framework.exception.ErrorException;
import com.ruoyi.inspect.util.HackLoopTableRenderPolicy;
import com.ruoyi.inspect.util.UserUtils;
import com.ruoyi.process.dto.QualitySuperviseDetailsAccordingDto;
import com.ruoyi.process.dto.QualitySuperviseDetailsCorrectDto;
import com.ruoyi.process.dto.QualitySuperviseDetailsDto;
import com.ruoyi.process.excel.QualitySuperviseDetailsUpload;
import com.ruoyi.process.mapper.*;
import com.ruoyi.process.pojo.*;
import com.ruoyi.process.service.QualitySuperviseDetailsService;
import com.ruoyi.process.service.QualitySuperviseService;
import com.ruoyi.system.mapper.UserMapper;
import com.ruoyi.system.service.InformationNotificationService;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.scheduling.concurrent.ThreadPoolTaskExecutor;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.multipart.MultipartFile;
 
import javax.annotation.Resource;
import javax.servlet.http.HttpServletResponse;
import java.io.File;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.net.URLEncoder;
import java.time.LocalDate;
import java.time.LocalDateTime;
import java.time.format.DateTimeFormatter;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
 
/**
 * 质量监督主表
 *
 * @author zhuo
 * @since 2024-11-07
 */
@Service
@Transactional(rollbackFor = Exception.class)
public class QualitySuperviseServiceImpl extends ServiceImpl<QualitySuperviseMapper, QualitySupervise> implements QualitySuperviseService {
 
    @Resource
    private QualitySuperviseDetailsService qualitySuperviseDetailsService;
    @Resource
    private QualitySuperviseDetailsMapper qualitySuperviseDetailsMapper;
    @Resource
    private QualitySuperviseDetailsRecordMapper qualitySuperviseDetailsRecordMapper;
    @Resource
    private QualitySuperviseDetailsAccordingMapper qualitySuperviseDetailsAccordingMapper;
    @Resource
    private QualitySuperviseDetailsCorrectMapper qualitySuperviseDetailsCorrectMapper;
    @Resource
    private QualitySuperviseDetailsCorrectFileMapper qualitySuperviseDetailsCorrectFileMapper;
    @Resource
    private InformationNotificationService informationNotificationService;
    @Resource
    private ThreadPoolTaskExecutor threadPoolTaskExecutor;
    @Resource
    private UserMapper userMapper;
    @Value("${file.path}")
    private String imgUrl;
 
    @Value("${wordUrl}")
    private String wordUrl;
 
    /**
     * 导入监督计划
     * @param file
     * @return
     */
    @Override
    public boolean importQualitySupervise(MultipartFile file, QualitySupervise supervise) {
        if (supervise.getRatifyUserId() == null) {
            throw new ErrorException("缺少批准人");
        }
        User ratifyUser = userMapper.selectById(supervise.getRatifyUserId());
 
        // 当前登录用户
        Integer userId = SecurityUtils.getUserId().intValue();
        User user = userMapper.selectById(userId);
 
        // 文件名称
        String fileName = file.getOriginalFilename().substring(0, file.getOriginalFilename().lastIndexOf("."));
        QualitySupervise qualitySupervise = new QualitySupervise();
        qualitySupervise.setSuperviseName(fileName);
        qualitySupervise.setSuperviseYear(supervise.getSuperviseYear());
        qualitySupervise.setRecordUserIds(supervise.getRecordUserIds());
        qualitySupervise.setWriteUserId(userId);
        qualitySupervise.setWriteUserName(user.getName());
        qualitySupervise.setWriteTime(LocalDateTime.now());
        qualitySupervise.setRatifyUserId(supervise.getRatifyUserId());
        qualitySupervise.setRatifyUserName(ratifyUser.getName());
        baseMapper.insert(qualitySupervise);
 
        // 消息发送
        InformationNotification info = new InformationNotification();
        // 发送人
        info.setCreateUser(user.getName());
        info.setMessageType("6");
        info.setTheme("CNAS质量监督计划审核通知");
        info.setContent("您有一条质量监督计划待批准");
        info.setSenderId(userId);
        // 接收人
        info.setConsigneeId(supervise.getRatifyUserId());
        info.setJumpPath(MenuJumpPathConstants.QUALITY_SUPERVISE);
        informationNotificationService.addInformationNotification(info);
 
        // 发送企业微信通知
        threadPoolTaskExecutor.execute(() -> {
            // 查询发送人
            User people = userMapper.selectById(supervise.getRatifyUserId());
            String message = "";
            message += "CNAS质量监督计划批准通知";
            message += "\n请去过程要求-质量监督计划";
            message += "\n" + fileName + "质量监督计划待批准";
            //发送企业微信消息通知
            try {
                WxCpUtils.inform(people.getAccount(), message, null);
            } catch (Exception e) {
                throw new RuntimeException(e);
            }
        });
 
 
        List<QualitySuperviseDetails> detailsUploadList = new ArrayList<>();
 
        // 导入附件内容
        try {
            // excel解析
            EasyExcel.read(file.getInputStream(), QualitySuperviseDetailsUpload.class, new AnalysisEventListener<QualitySuperviseDetailsUpload>() {
                @Override
                public void invoke(QualitySuperviseDetailsUpload detailsUpload, AnalysisContext analysisContext) {
                    // 判断是否为空
                    if (StringUtils.isBlank(detailsUpload.getSuperviseTime())) {
                        throw new ErrorException("监督日期不能为空");
                    }
                    // 对象复制
                    QualitySuperviseDetails superviseDetails = new QualitySuperviseDetails();
                    BeanUtils.copyProperties(detailsUpload, superviseDetails);
                    superviseDetails.setSuperviseId(qualitySupervise.getSuperviseId());
 
                    User user = userMapper.selectOne(Wrappers.<User>lambdaQuery()
                            .eq(User::getName, superviseDetails.getSupervisee()));
                    if (ObjectUtils.isEmpty(user)) {
                        throw new ErrorException("未找到被监督员:" + superviseDetails.getSupervisee());
                    }
                    superviseDetails.setSupervisedUserId(user.getId());
                    // 格式化时间
                    superviseDetails.setSuperviseTime(detailsUpload.getSuperviseTime());
 
                    detailsUploadList.add(superviseDetails);
                }
                @Override
                public void doAfterAllAnalysed(AnalysisContext analysisContext) {
 
                }
            }).sheet().doRead();
            qualitySuperviseDetailsService.saveBatch(detailsUploadList);
 
        } catch (IOException e) {
            throw new RuntimeException(e);
        }
        return true;
    }
 
    /**
     * 监督计划批准
     * @param qualitySupervise
     * @return
     */
    @Override
    public boolean ratifyQualitySupervise(QualitySupervise qualitySupervise) {
        // 当前登录用户
        baseMapper.update(null, Wrappers.<QualitySupervise>lambdaUpdate()
                .eq(QualitySupervise::getSuperviseId, qualitySupervise.getSuperviseId())
                .set(QualitySupervise::getRatifyRemark, qualitySupervise.getRatifyRemark())
                .set(QualitySupervise::getRatifyStatus, qualitySupervise.getRatifyStatus())
                .set(QualitySupervise::getRatifyTime, LocalDateTime.now())
        );
        return true;
    }
 
    /**
     * 监督计划列表
     * @param page
     * @param qualitySupervise
     * @return
     */
    @Override
    public IPage<QualitySupervise> pageQualitySupervise(Page page, QualitySupervise qualitySupervise) {
        return baseMapper.pageQualitySupervise(page, QueryWrappers.queryWrappers(qualitySupervise));
    }
 
    /**
     * 监督计划详情列表
     * @return
     */
    @Override
    public IPage<QualitySuperviseDetailsDto> pageQualitySuperviseDetail(Page page, QualitySuperviseDetailsDto qualitySuperviseDetails) {
        if (qualitySuperviseDetails.getSuperviseId() == null) {
            return new Page();
        }
        Integer causeType = qualitySuperviseDetails.getCauseType();
        qualitySuperviseDetails.setCauseType(null);
        return qualitySuperviseDetailsMapper.pageQualitySuperviseDetail(page, QueryWrappers.queryWrappers(qualitySuperviseDetails), causeType);
    }
 
    /**
     * 查询该计划监督员
     * @param superviseDetailsId
     * @return
     */
    @Override
    public List<Map<String, String>> getRecordUser(Integer superviseDetailsId) {
        List<Map<String, String>> recordUser = baseMapper.getRecordUser(superviseDetailsId);
        return baseMapper.getRecordUser(superviseDetailsId);
    }
 
    /**
     * 导出监督计划
     * @param superviseId
     * @param response
     */
    @Override
    public void exportQualitySupervise(Integer superviseId, HttpServletResponse response) {
        QualitySupervise qualitySupervise = baseMapper.selectById(superviseId);
        //获取提交人的签名地址
        String writeUrl = userMapper.selectById(qualitySupervise.getWriteUserId()).getSignatureUrl();
        if (ObjectUtils.isEmpty(writeUrl) || writeUrl.equals("")) {
            throw new ErrorException("找不到检验人的签名");
        }
 
        //获取批准人的签名地址
        String ratifyUrl = null;
        if (qualitySupervise.getRatifyUserId() != null) {
            ratifyUrl = userMapper.selectById(qualitySupervise.getRatifyUserId()).getSignatureUrl();
            if (StringUtils.isBlank(ratifyUrl)) {
                throw new ErrorException("找不到复核人的签名");
            }
        }
 
        // 定义一个集合存放人员签名
        ArrayList<PictureRenderData> recordUserDataList = new ArrayList<>();
        // TODO:确认最多会有5个人
        String recordUserIds = qualitySupervise.getRecordUserIds();
        if (StringUtils.isNotBlank(recordUserIds)) {
            // 对人员id字符串进行分割成数组
            String[] userIds = recordUserIds.split(",");
            // 循环获取人员签名
            for (String userIdStr : userIds) {
                // 转换为int类型
                Integer userId = Integer.valueOf(userIdStr);
                // 获取人员签名对象
                PictureRenderData finalUserSignatureUrl = UserUtils.getFinalUserSignatureUrl(userId);
                // 将人员签名对象添加到集合中
                recordUserDataList.add(finalUserSignatureUrl);
            }
        }
 
        // 判断集合长度,并补null到2个
        while (recordUserDataList.size() < 2) {
            recordUserDataList.add(null);
        }
 
        // 查询详情
        List<QualitySuperviseDetails> qualitySuperviseDetails = qualitySuperviseDetailsMapper.selectList(Wrappers.<QualitySuperviseDetails>lambdaQuery()
                .eq(QualitySuperviseDetails::getSuperviseId, superviseId));
 
        int index = 1;
        for (QualitySuperviseDetails qualitySuperviseDetail : qualitySuperviseDetails) {
            qualitySuperviseDetail.setIndex(index);
            index++;
        }
 
        // 获取路径
        InputStream inputStream = this.getClass().getResourceAsStream("/static/quality-supervise.docx");
        String finalRatifyUrl = ratifyUrl;
        Configure configure = Configure.builder()
                .bind("superviseDetailList", new HackLoopTableRenderPolicy())
                .build();
        XWPFTemplate template = XWPFTemplate.compile(inputStream, configure).render(
                new HashMap<String, Object>() {{
                    put("year", qualitySupervise.getSuperviseYear());
                    put("superviseDetailList", qualitySuperviseDetails);
                    put("writeUrl", StringUtils.isNotBlank(writeUrl) ? Pictures.ofLocal(imgUrl + "/" + writeUrl).create() : null);
                    put("ratifyUrl", StringUtils.isNotBlank(finalRatifyUrl) ? Pictures.ofLocal(imgUrl + "/" + finalRatifyUrl).create() : null);
                    put("writeDateUrl", qualitySupervise.getWriteTime() != null ?
                            Pictures.ofStream(DateImageUtil.createDateImage(qualitySupervise.getWriteTime())).create() : null);
                    put("ratifyDateUrl", qualitySupervise.getRatifyTime() != null ?
                            Pictures.ofStream(DateImageUtil.createDateImage(qualitySupervise.getRatifyTime())).create() : null);
                    put("recordUserUrl1", recordUserDataList.get(0));
                    put("recordUserUrl2", recordUserDataList.get(1));
                }});
 
        try {
            response.setContentType("application/msword");
            String fileName = URLEncoder.encode(
                    qualitySupervise.getSuperviseName(), "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("导出失败");
        }
 
 
    }
 
    /************************************************ 记录 ******************************************************/
 
    /**
     * 查询监督记录信息
     * @param superviseDetailsId
     * @return
     */
    @Override
    public QualitySuperviseDetailsRecord getSuperviseDetailRecord(Integer superviseDetailsId) {
        QualitySuperviseDetailsRecord detailsRecord;
        detailsRecord = qualitySuperviseDetailsRecordMapper.selectOne(Wrappers.<QualitySuperviseDetailsRecord>lambdaQuery()
                .eq(QualitySuperviseDetailsRecord::getSuperviseDetailsId, superviseDetailsId));
        if (detailsRecord == null) {
            detailsRecord = new QualitySuperviseDetailsRecord();
        }
        // 添加批准人名称
        if (detailsRecord.getRatifyUserId() != null) {
            User user = userMapper.selectById(SecurityUtils.getUserId().intValue());
            detailsRecord.setRatifyUserName(user.getName());
        }
        return detailsRecord;
    }
 
    /**
     * 新增监督记录信息
     * @param qualitySuperviseDetailsRecord
     * @return
     */
    @Override
    public boolean addSuperviseDetailRecord(QualitySuperviseDetailsRecord qualitySuperviseDetailsRecord) {
        if (qualitySuperviseDetailsRecord.getSuperviseDetailsId() == null) {
            throw new ErrorException("缺少监督详细信息id");
        }
        qualitySuperviseDetailsRecordMapper.insert(qualitySuperviseDetailsRecord);
 
        if (qualitySuperviseDetailsRecord.getRatifyUserId() != null) {
 
            // 查询详情信息
            QualitySuperviseDetails superviseDetails = qualitySuperviseDetailsMapper.selectById(qualitySuperviseDetailsRecord.getSuperviseDetailsId());
 
            Integer userId = SecurityUtils.getUserId().intValue();
            User user = userMapper.selectById(userId);
            // 消息发送
            InformationNotification info = new InformationNotification();
            // 发送人
            info.setCreateUser(user.getName());
            info.setMessageType("6");
            info.setTheme("CNAS质量监督记录审批通知");
            info.setContent("监督项目为: " + superviseDetails.getSuperviseProject() + " 监督记录带审批");
            info.setSenderId(userId);
            // 接收人
            info.setConsigneeId(qualitySuperviseDetailsRecord.getRatifyUserId());
            info.setJumpPath(MenuJumpPathConstants.QUALITY_SUPERVISE);
            informationNotificationService.addInformationNotification(info);
 
            // 发送企业微信通知
            threadPoolTaskExecutor.execute(() -> {
                // 查询发送人
                User people = userMapper.selectById(qualitySuperviseDetailsRecord.getRatifyUserId());
                String message = "";
                message += "CNAS质量监督记录审批通知";
                message += "\n请去过程要求-质量监督计划";
                message += "\n" + "监督项目为: " + superviseDetails.getSuperviseProject() + " 监督记录带审批";
                //发送企业微信消息通知
                try {
                    WxCpUtils.inform(people.getAccount(), message, null);
                } catch (Exception e) {
                    throw new RuntimeException(e);
                }
            });
        }
 
        return true;
    }
 
    /**
     * 监督记录批准
     * @param qualitySuperviseDetailsRecord
     * @return
     */
    @Override
    public boolean addSuperviseRecordOpinion(QualitySuperviseDetailsRecord qualitySuperviseDetailsRecord) {
        if (qualitySuperviseDetailsRecord.getIsAccording() == null) {
            throw new ErrorException("缺少最终结果");
        }
 
        qualitySuperviseDetailsRecordMapper.update(null, Wrappers.<QualitySuperviseDetailsRecord>lambdaUpdate()
                .eq(QualitySuperviseDetailsRecord::getSuperviseDetailsId, qualitySuperviseDetailsRecord.getSuperviseDetailsId())
                .set(QualitySuperviseDetailsRecord::getRatifyOpinion, qualitySuperviseDetailsRecord.getRatifyOpinion())
                .set(QualitySuperviseDetailsRecord::getRatifyTime, LocalDateTime.now())
                .set(QualitySuperviseDetailsRecord::getIsAccording, qualitySuperviseDetailsRecord.getIsAccording())
                .set(QualitySuperviseDetailsRecord::getIsFinish, 1));
        return true;
    }
 
    /**
     * 导出监督记录表
     * @param superviseDetailsId
     * @param response
     */
    @Override
    public void exportSuperviseDetailRecord(Integer superviseDetailsId, HttpServletResponse response) {
        QualitySuperviseDetailsRecord recordDto =  qualitySuperviseDetailsRecordMapper.selectSuperviseDetailRecord(superviseDetailsId);
 
        //获取技术负责人的签名地址
        String ratifyUrl = null;
        if (recordDto.getRatifyUserId() != null) {
            ratifyUrl = userMapper.selectById(recordDto.getRatifyUserId()).getSignatureUrl();
            if (StringUtils.isBlank(ratifyUrl)) {
                throw new ErrorException("找不到技术负责人的签名");
            }
        }
 
        // 获取路径
        InputStream inputStream = this.getClass().getResourceAsStream("/static/supervision-detail-record.docx");
        ConfigureBuilder builder = Configure.builder();
        builder.useSpringEL(true);
        String finalRatifyUrl = ratifyUrl;
        XWPFTemplate template = XWPFTemplate.compile(inputStream, builder.build()).render(
                new HashMap<String, Object>() {{
                    put("supervision", recordDto);
                    put("supervisoruUrl", UserUtils.getFinalUserSignatureUrl(recordDto.getSupervisor()));
                    put("technicalDirectorUrl", StringUtils.isNotBlank(finalRatifyUrl) ? Pictures.ofLocal(imgUrl + "/" + finalRatifyUrl).create() : null);
                    put("technicalDirectorDateUrl", recordDto.getRatifyTime() != null ?
                            Pictures.ofStream(DateImageUtil.createDateImage(recordDto.getRatifyTime())).create() : null);
                }});
 
        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("导出失败");
        }
    }
 
    /*************************************************  不合格工作控制单 ********************************************************/
 
    /**
     * 新增监督记录不符合控制信息
     * @param detailsAccording
     * @return
     */
    @Override
    public boolean addSuperviseDetailAccording(QualitySuperviseDetailsAccording detailsAccording) {
        QualitySuperviseDetailsAccording according = new QualitySuperviseDetailsAccording();
        // 当前登录用户信息和部门
        User user = userMapper.selectById( SecurityUtils.getUserId().intValue());
        String departmentLimsName = userMapper.selectUserDepartmentLimsName(user.getId());
        switch (detailsAccording.getFlowType()) {
                // 不符合工作情况记录
            case 0:
                if (detailsAccording.getSuperviseDetailsId() == null) {
                    throw new ErrorException("缺少质量监督详情Id");
                }
                according.setSuperviseDetailsId(detailsAccording.getSuperviseDetailsId());
                according.setOccurrenceDepartment(detailsAccording.getOccurrenceDepartment());//发生部门
                according.setHeadDepartment(detailsAccording.getHeadDepartment());//部门负责人
                according.setFindWay(detailsAccording.getFindWay());//发现途径
                according.setRecordDetail(detailsAccording.getRecordDetail());//不符合记录详细
                according.setRecordAccording(detailsAccording.getRecordAccording());//不合格记录依据
 
                according.setFoundDepartment(departmentLimsName);//发现部门
                according.setRecordUserId(user.getId());//记录人id
                according.setRecordUserName(user.getName());//记录人
                according.setRecordTime(LocalDate.now());//记录时间
 
                // 处理人信息
                User actionsUser = userMapper.selectById(detailsAccording.getActionsUserId());
                String actionsDepartmentLims = userMapper.selectUserDepartmentLimsName(actionsUser.getId());
 
                according.setResponsibleDepartment(actionsDepartmentLims);//责任部门
                according.setActionsUserId(actionsUser.getId());//处理人id
                according.setActionsUserName(actionsUser.getName());//处理人
 
                according.setSupervisedUserId(detailsAccording.getSupervisedUserId());//被监督人id
                // 被监督人
                User supervisedUser = userMapper.selectById(detailsAccording.getSupervisedUserId());
                according.setSupervisedUserName(supervisedUser.getName());//被监督人
                according.setActionsTime(detailsAccording.getSupervisedTime());//被监督时间
                qualitySuperviseDetailsAccordingMapper.insert(according);
                break;
 
                // 1处理措施
            case 1:
                according.setSuperviseDetailsAccordingId(detailsAccording.getSuperviseDetailsAccordingId());
                according.setEliminateMeasure(detailsAccording.getEliminateMeasure());//清除不符合措施
                according.setActionsTime(LocalDate.now());//处理时间
 
                // 纠正负责人信息
                User correctsUser = userMapper.selectById(detailsAccording.getCorrectUserId());
 
                according.setCorrectUserId(correctsUser.getId());//纠正负责人id
                according.setCorrectUserName(correctsUser.getName());//纠正负责人
 
                qualitySuperviseDetailsAccordingMapper.updateById(according);
                break;
 
                // 纠正措施
            case 2:
                according.setSuperviseDetailsAccordingId(detailsAccording.getSuperviseDetailsAccordingId());
                according.setCorrectContent(detailsAccording.getCorrectContent());//纠正措施内容
                according.setIsCorrect(detailsAccording.getIsCorrect());//是否纠正处理
                according.setCorrectTime(LocalDate.now());//纠正填写时间
 
                // 质量负责人
                User qualityUser = userMapper.selectById(detailsAccording.getQualityManagerUserId());
                according.setQualityManagerUserId(qualityUser.getId());//质量负责人id
                according.setQualityManagerUserName(qualityUser.getName());//质量负责人
 
                qualitySuperviseDetailsAccordingMapper.updateById(according);
                break;
 
                //是否通知客户可恢复工作
            case 3:
                according.setSuperviseDetailsAccordingId(detailsAccording.getSuperviseDetailsAccordingId());
                according.setNotifyCustomer(detailsAccording.getNotifyCustomer());//通知客户
                according.setBackToWork(detailsAccording.getBackToWork());//回复工作
 
                according.setQualityManagerTime(LocalDate.now());//日期
                according.setIsFinish(1);
                qualitySuperviseDetailsAccordingMapper.updateById(according);
                break;
        }
        return true;
    }
 
    /**
     * (装备流程)新增监督记录不符合控制信息
     * @param detailsAccording
     * @return
     */
    @Override
    public boolean addEquipSuperviseDetailAccording(QualitySuperviseDetailsAccording detailsAccording) {
        if (detailsAccording.getSuperviseDetailsId() == null) {
            throw new ErrorException("缺少质量监督详情Id");
        }
 
        // 当前登录用户信息和部门
        Integer userId = SecurityUtils.getUserId().intValue();
        User user = userMapper.selectById(userId);
        String departmentLimsName = userMapper.selectUserDepartmentLimsName(user.getId());
        detailsAccording.setFoundDepartment(departmentLimsName);//发现部门
        detailsAccording.setRecordUserId(user.getId());//记录人id
        detailsAccording.setRecordUserName(user.getName());//记录人
        // 被监督人
        User supervisedUser = userMapper.selectById(detailsAccording.getSupervisedUserId());
        detailsAccording.setSupervisedUserName(supervisedUser.getName());//被监督
        qualitySuperviseDetailsAccordingMapper.insert(detailsAccording);
 
        if (detailsAccording.getApproverUserId() != null) {
            // 查询详情信息
            QualitySuperviseDetails superviseDetails = qualitySuperviseDetailsMapper.selectById(detailsAccording.getSuperviseDetailsId());
 
            // 消息发送
            InformationNotification info = new InformationNotification();
            // 发送人
            info.setCreateUser(user.getName());
            info.setMessageType("6");
            info.setTheme("CNAS质量监督不合格控制单填写通知");
            info.setContent("监督项目为: " + superviseDetails.getSuperviseProject() + " 监督不合格控制单待填写");
            info.setSenderId(userId);
            // 接收人
            info.setConsigneeId(detailsAccording.getApproverUserId());
            info.setJumpPath(MenuJumpPathConstants.QUALITY_SUPERVISE);
            informationNotificationService.addInformationNotification(info);
 
            // 发送企业微信通知
            threadPoolTaskExecutor.execute(() -> {
                // 查询发送人
                User people = userMapper.selectById(detailsAccording.getApproverUserId());
                String message = "";
                message += "CNAS质量监督记录审批通知";
                message += "\n请去过程要求-质量监督计划";
                message += "\n" + "监督项目为: " + superviseDetails.getSuperviseProject() + " 监督不合格控制单待填写";
                //发送企业微信消息通知
                try {
                    WxCpUtils.inform(people.getAccount(), message, null);
                } catch (Exception e) {
                    throw new RuntimeException(e);
                }
            });
        }
 
        return true;
    }
 
    /**
     * (装备流程)批准监督记录不符合控制信息
     * 批准完成后统一填写三个流程人id和部门
     * @param detailsAccording
     * @return
     */
    @Override
    public boolean approverEquipSuperviseDetailAccording(QualitySuperviseDetailsAccording detailsAccording) {
        QualitySuperviseDetailsAccording according = new QualitySuperviseDetailsAccording();
        according.setSuperviseDetailsAccordingId(detailsAccording.getSuperviseDetailsAccordingId());
        // 当前登录用户信息和部门
        User user = userMapper.selectById(SecurityUtils.getUserId().intValue());
        String departmentLimsName = userMapper.selectUserDepartmentLimsName(user.getId());
 
        according.setResponsibleDepartment(departmentLimsName);//责任部门
        according.setActionsUserId(user.getId());//处理人id
        according.setActionsUserName(user.getName());//处理人
 
        according.setCorrectUserId(user.getId());//纠正负责人id
        according.setCorrectUserName(user.getName());//纠正负责人
 
        according.setQualityManagerUserId(user.getId());//质量负责人id
        according.setQualityManagerUserName(user.getName());//质量负责人
        according.setIsFinish(1);
        qualitySuperviseDetailsAccordingMapper.updateById(according);
        return true;
    }
 
    /**
     * 查询监督记录不符合控制信息
     * @param superviseDetailsId
     * @return
     */
    @Override
    public QualitySuperviseDetailsAccording getSuperviseDetailAccording(Integer superviseDetailsId) {
        QualitySuperviseDetailsAccording detailsAccording;
 
        detailsAccording = qualitySuperviseDetailsAccordingMapper.selectOne(Wrappers.<QualitySuperviseDetailsAccording>lambdaQuery()
                .eq(QualitySuperviseDetailsAccording::getSuperviseDetailsId, superviseDetailsId));
 
        if (detailsAccording == null) {
            detailsAccording = new QualitySuperviseDetailsAccording();
            // 查询监督计划详情
            QualitySuperviseDetails superviseDetails = qualitySuperviseDetailsMapper.selectById(superviseDetailsId);
            detailsAccording.setSupervisedUserId(superviseDetails.getSupervisedUserId());
            detailsAccording.setSupervisedUserName(superviseDetails.getSupervisee());
        }
        return detailsAccording;
    }
 
    /**
     * 查询不符合项
     * @param page
     * @param detailsAccording
     * @return
     */
    @Override
    public IPage<QualitySuperviseDetailsAccording> pageSuperviseDetailAccording(Page page, QualitySuperviseDetailsAccording detailsAccording) {
        return qualitySuperviseDetailsAccordingMapper.pageSuperviseDetailAccording(page, QueryWrappers.queryWrappers(detailsAccording));
    }
 
    /**
     * 导出监督记录不符合控制信息
     * @param superviseDetailAccordingId
     * @param response
     */
    @Override
    public void superviseDetailAccordingExport(Integer superviseDetailAccordingId, HttpServletResponse response) {
        QualitySuperviseDetailsAccordingDto exportDto = qualitySuperviseDetailsAccordingMapper.selectSuperviseDetailsAccording(superviseDetailAccordingId);
        // 发现部门
        String discovererUrl = null;
        if (exportDto.getRecordUserId() != null) {
            discovererUrl = userMapper.selectById(exportDto.getRecordUserId()).getSignatureUrl();
            if (StringUtils.isBlank(discovererUrl)) {
                throw new ErrorException("找不到发现部门人的签名");
            }
        }
 
        // 处理措施负责人
        String responsibleUrl = null;
        if (exportDto.getCorrectUserId() != null) {
            responsibleUrl = userMapper.selectById(exportDto.getCorrectUserId()).getSignatureUrl();
            if (StringUtils.isBlank(responsibleUrl)) {
                throw new ErrorException("找不到处理措施负责人的签名");
            }
        }
 
        // 技术负责人
        String correctiveUrl = null;
        if (exportDto.getQualityManagerUserId() != null) {
            correctiveUrl = userMapper.selectById(exportDto.getQualityManagerUserId()).getSignatureUrl();
            if (StringUtils.isBlank(correctiveUrl)) {
                throw new ErrorException("找不到技术负责人的签名");
            }
        }
 
        // 质量负责人
        String qualityUrl = null;
        if (exportDto.getQualityManagerUserId() != null) {
            qualityUrl = userMapper.selectById(exportDto.getQualityManagerUserId()).getSignatureUrl();
            if (StringUtils.isBlank(qualityUrl)) {
                throw new ErrorException("找不到质量负责人的签名");
            }
        }
 
        // 获取路径
        InputStream inputStream = this.getClass().getResourceAsStream("/static/supervision-detail-according.docx");
        ConfigureBuilder builder = Configure.builder();
        String finalDiscovererUrl = discovererUrl;
        String finalResponsibleUrl = responsibleUrl;
        String finalCorrectiveUrl = correctiveUrl;
        String finalQualityUrl = qualityUrl;
        XWPFTemplate template = XWPFTemplate.compile(inputStream, builder.build()).render(
                new HashMap<String, Object>() {{
                    put("control", exportDto);
                    put("discovererUrl", StringUtils.isNotBlank(finalDiscovererUrl) ? Pictures.ofLocal(imgUrl + "/" + finalDiscovererUrl).create() : null);
                    put("responsibleUrl", StringUtils.isNotBlank(finalResponsibleUrl) ? Pictures.ofLocal(imgUrl + "/" + finalResponsibleUrl).create() : null);
                    put("correctiveUrl", StringUtils.isNotBlank(finalCorrectiveUrl) ? Pictures.ofLocal(imgUrl + "/" + finalCorrectiveUrl).create() : null);
                    put("qualityUrl", StringUtils.isNotBlank(finalQualityUrl) ? Pictures.ofLocal(imgUrl + "/" + finalQualityUrl).create() : null);
                }});
 
        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("导出失败");
        }
    }
 
    /*************************************************  纠正措施处理单 ********************************************************/
 
 
    @Override
    public boolean addSuperviseDetailCorrect(QualitySuperviseDetailsCorrect detailsCorrect) {
        QualitySuperviseDetailsCorrect correct = new QualitySuperviseDetailsCorrect();
        // 当前登录用户信息和部门
        User user = userMapper.selectById(SecurityUtils.getUserId().intValue());
        String departmentLimsName = userMapper.selectUserDepartmentLimsName(user.getId());
 
        switch (detailsCorrect.getFlowType()) {
                // 不合格提出
            case 0:
                if (detailsCorrect.getSuperviseDetailsId() == null) {
                    throw new ErrorException("缺少质量监督详情Id");
                }
                correct.setSuperviseDetailsId(detailsCorrect.getSuperviseDetailsId());
                correct.setRaiseResult(detailsCorrect.getRaiseResult());//不合格表述
                correct.setVdeRaiseResult(detailsCorrect.getVdeRaiseResult());//vde专家发现
                correct.setRaiseDepartment(departmentLimsName);//提出部门
                correct.setRaiseUserId(user.getId());//提出人id
                correct.setRaiseUserName(user.getName());// 提出人
                correct.setRaiseTime(LocalDate.now());// 提出时间
 
                // 原因分析人信息
                User causeUser = userMapper.selectById(detailsCorrect.getCauseUserId());
                String causeDepartmentLims = userMapper.selectUserDepartmentLimsName(causeUser.getId());
 
                correct.setCauseDepartment(causeDepartmentLims);//原因分析责任部门
                correct.setCauseUserId(causeUser.getId());//1原因分析人id
                correct.setCauseUserName(causeUser.getName());// 1原因分析人
                qualitySuperviseDetailsCorrectMapper.insert(correct);
 
                break;
 
                // 原因分析
            case 1:
                correct.setSuperviseDetailsCorrectId(detailsCorrect.getSuperviseDetailsCorrectId());
                correct.setCauseResult(detailsCorrect.getCauseResult());//原因分析
                correct.setCauseTime(LocalDate.now());// 1原因分析时间
 
                // 纠正人信息
                User correctUser = userMapper.selectById(detailsCorrect.getCorrectUserId());
                String correctUserDepartmentLims = userMapper.selectUserDepartmentLimsName(correctUser.getId());
 
                correct.setCorrectDepartment(correctUserDepartmentLims);//2纠正责任部门
                correct.setCorrectUserId(correctUser.getId());//2纠正人id
                correct.setCorrectUserName(correctUser.getName());// 2纠正人
                qualitySuperviseDetailsCorrectMapper.updateById(correct);
                break;
 
                // 纠正措施
            case 2:
                correct.setSuperviseDetailsCorrectId(detailsCorrect.getSuperviseDetailsCorrectId());
                correct.setCorrectResult(detailsCorrect.getCorrectResult());//2纠正措施
                correct.setRaiseDepartmentAffirm(detailsCorrect.getRaiseDepartmentAffirm());//2提出部门确认
                correct.setCorrectTime(LocalDate.now());// 2纠正时间
 
                // 验证人信息
                User validationUser = userMapper.selectById(detailsCorrect.getValidationUserId());
                String validationUserDepartmentLims = userMapper.selectUserDepartmentLimsName(validationUser.getId());
 
                correct.setValidationDepartment(validationUserDepartmentLims);//3验证部门
                correct.setValidationUserId(validationUser.getId());//3验证人id
                correct.setValidationUserName(validationUser.getName());// 3验证人
                qualitySuperviseDetailsCorrectMapper.updateById(correct);
                break;
 
                // 验证结果
            case 3:
                correct.setSuperviseDetailsCorrectId(detailsCorrect.getSuperviseDetailsCorrectId());
                correct.setValidationResult(detailsCorrect.getValidationResult());//3验证结果
                correct.setValidationTime(LocalDate.now());// 3验证时间
                correct.setIsFinish(1);
                qualitySuperviseDetailsCorrectMapper.updateById(correct);
                break;
        }
 
        return true;
    }
 
    /**
     * (装备流程)新增监督纠正处理信息
     * @return
     */
    @Override
    public boolean addEquipSuperviseDetailCorrect(QualitySuperviseDetailsCorrect detailsCorrect) {
        if (detailsCorrect.getSuperviseDetailsId() == null) {
            throw new ErrorException("缺少质量监督详情Id");
        }
        // 当前登录用户信息和部门
        Integer userId = SecurityUtils.getUserId().intValue();
        User user = userMapper.selectById(userId);
        String departmentLimsName = userMapper.selectUserDepartmentLimsName(user.getId());
 
        detailsCorrect.setRaiseDepartment(departmentLimsName);//提出部门
        detailsCorrect.setRaiseUserId(user.getId());//提出人id
        detailsCorrect.setRaiseUserName(user.getName());// 提出人
        qualitySuperviseDetailsCorrectMapper.insert(detailsCorrect);
 
        if (detailsCorrect.getApproverUserId() != null) {
            // 查询详情信息
            QualitySuperviseDetails superviseDetails = qualitySuperviseDetailsMapper.selectById(detailsCorrect.getSuperviseDetailsId());
 
            // 消息发送
            InformationNotification info = new InformationNotification();
            // 发送人
            info.setCreateUser(user.getName());
            info.setMessageType("6");
            info.setTheme("CNAS质量监督纠正措施填写通知");
            info.setContent("监督项目为: " + superviseDetails.getSuperviseProject() + " 监督纠正措施待填写");
            info.setSenderId(userId);
            // 接收人
            info.setConsigneeId(detailsCorrect.getApproverUserId());
            info.setJumpPath(MenuJumpPathConstants.QUALITY_SUPERVISE);
            informationNotificationService.addInformationNotification(info);
 
            // 发送企业微信通知
            threadPoolTaskExecutor.execute(() -> {
                // 查询发送人
                User people = userMapper.selectById(detailsCorrect.getApproverUserId());
                String message = "";
                message += "CNAS质量监督纠正措施填写通知";
                message += "\n请去过程要求-质量监督计划";
                message += "\n" + "监督项目为: " + superviseDetails.getSuperviseProject() + " 监督纠正措施待填写";
                //发送企业微信消息通知
                try {
                    WxCpUtils.inform(people.getAccount(), message, null);
                } catch (Exception e) {
                    throw new RuntimeException(e);
                }
            });
        }
 
        return true;
    }
 
    /**
     * (装备流程)批准监督纠正处理信息
     * @return
     */
    @Override
    public boolean approveEquipSuperviseDetailCorrect(QualitySuperviseDetailsCorrect detailsCorrect) {
        QualitySuperviseDetailsCorrect correct = new QualitySuperviseDetailsCorrect();
        // 当前登录用户信息和部门
        User user = userMapper.selectById(SecurityUtils.getUserId().intValue());
        String departmentLimsName = userMapper.selectUserDepartmentLimsName(user.getId());
        correct.setSuperviseDetailsCorrectId(detailsCorrect.getSuperviseDetailsCorrectId());
 
        correct.setCauseDepartment(departmentLimsName);//原因分析责任部门
        correct.setCauseUserId(user.getId());//1原因分析人id
        correct.setCauseUserName(user.getName());// 1原因分析人
 
        correct.setCorrectDepartment(departmentLimsName);//2纠正责任部门
        correct.setCorrectUserId(user.getId());//2纠正人id
        correct.setCorrectUserName(user.getName());// 2纠正人
 
        correct.setValidationDepartment(departmentLimsName);//3验证部门
        correct.setValidationUserId(user.getId());//3验证人id
        correct.setValidationUserName(user.getName());// 3验证人
        correct.setIsFinish(1);
        qualitySuperviseDetailsCorrectMapper.updateById(correct);
 
        return true;
    }
 
    /**
     * 查询监督纠正处理
     * @param superviseDetailsId
     * @return
     */
    @Override
    public QualitySuperviseDetailsCorrect getSuperviseDetailCorrect(Integer superviseDetailsId) {
        QualitySuperviseDetailsCorrect detailsCorrect;
 
        detailsCorrect = qualitySuperviseDetailsCorrectMapper.selectOne(Wrappers.<QualitySuperviseDetailsCorrect>lambdaQuery()
                .eq(QualitySuperviseDetailsCorrect::getSuperviseDetailsId, superviseDetailsId));
 
        if (detailsCorrect == null) {
            detailsCorrect = new QualitySuperviseDetailsCorrect();
        }
        return detailsCorrect;
    }
 
    /**
     * 查询监督纠正措施列表
     * @param page
     * @param detailsCorrect
     * @return
     */
    @Override
    public IPage<QualitySuperviseDetailsCorrect> pageSuperviseDetailCorrect(Page page, QualitySuperviseDetailsCorrect detailsCorrect) {
        return qualitySuperviseDetailsCorrectMapper.pageSuperviseDetailAccording(page, QueryWrappers.queryWrappers(detailsCorrect));
    }
 
    /**
     * 新增监督纠正措施附件
     * @param superviseDetailsCorrectId
     * @param file
     * @return
     */
    @Override
    public boolean uploadSuperviseDetailCorrectFile(Integer superviseDetailsCorrectId, MultipartFile file) {
        if (superviseDetailsCorrectId == null) {
            throw new ErrorException("缺少纠正措施id");
        }
 
        String urlString;
        String pathName;
        String path;
        String filename = file.getOriginalFilename();
        String contentType = file.getContentType();
        QualitySuperviseDetailsCorrectFile superviseDetailsCorrectFile = new QualitySuperviseDetailsCorrectFile();
        superviseDetailsCorrectFile.setSuperviseDetailsCorrectId(superviseDetailsCorrectId);
        superviseDetailsCorrectFile.setFileName(filename);
        if (contentType != null && contentType.startsWith("image/")) {
            // 是图片
            path = imgUrl;
            superviseDetailsCorrectFile.setType(1);
        } else {
            // 是文件
            path = wordUrl;
            superviseDetailsCorrectFile.setType(2);
        }
        try {
            File realpath = new File(path);
            if (!realpath.exists()) {
                realpath.mkdirs();
            }
            pathName = LocalDateTime.now().format(DateTimeFormatter.ofPattern("yyMMddHHmmss")) + "_" + file.getOriginalFilename();
            urlString = realpath + "/" + pathName;
            file.transferTo(new File(urlString));
            superviseDetailsCorrectFile.setFileUrl(pathName);
            qualitySuperviseDetailsCorrectFileMapper.insert(superviseDetailsCorrectFile);
            return true;
        } catch (Exception e) {
            e.printStackTrace();
            throw new ErrorException(e.getMessage());
        }
    }
 
    /**
     * 查询监督纠正措施附件
     * @param superviseDetailsCorrectId
     * @return
     */
    @Override
    public List<QualitySuperviseDetailsCorrectFile> getSuperviseDetailCorrectFileList(Integer superviseDetailsCorrectId) {
        return qualitySuperviseDetailsCorrectFileMapper.selectList(Wrappers.<QualitySuperviseDetailsCorrectFile>lambdaQuery()
                .eq(QualitySuperviseDetailsCorrectFile::getSuperviseDetailsCorrectId, superviseDetailsCorrectId));
    }
 
    /**
     * 导出监督纠正措施
     * @param superviseDetailsCorrectId
     * @param response
     */
    @Override
    public void exportSuperviseDetaillCorrect(Integer superviseDetailsCorrectId, HttpServletResponse response) {
        QualitySuperviseDetailsCorrect detailsCorrect = qualitySuperviseDetailsCorrectMapper.selectById(superviseDetailsCorrectId);
        QualitySuperviseDetailsCorrectDto detailsCorrectDto = new QualitySuperviseDetailsCorrectDto();
        BeanUtils.copyProperties(detailsCorrect, detailsCorrectDto);
        DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd");
        // 提出时间
        detailsCorrectDto.setRaiseTimeString(detailsCorrectDto.getRaiseTime() != null
                ? detailsCorrectDto.getRaiseTime().format(formatter) : null);
        // 原因分析时间
        detailsCorrectDto.setCauseTimeString(detailsCorrectDto.getCauseTime() != null
                ? detailsCorrectDto.getCauseTime().format(formatter) : null);
 
        // 纠正时间
        detailsCorrectDto.setCorrectTimeString(detailsCorrectDto.getCorrectTime() != null
                ? detailsCorrectDto.getCorrectTime().format(formatter) : null);
 
        // 验证时间
        detailsCorrectDto.setValidationTimeString(detailsCorrectDto.getValidationTime() != null
                ? detailsCorrectDto.getValidationTime().format(formatter) : null);
 
 
        // 提出人签名
        String raiseUrl = null;
        if (detailsCorrectDto.getRaiseUserId() != null) {
            raiseUrl = userMapper.selectById(detailsCorrectDto.getRaiseUserId()).getSignatureUrl();
            if (StringUtils.isBlank(raiseUrl)) {
                throw new ErrorException("找不到提出人的签名");
            }
        }
 
        // 原因分析人
        String causeUrl = null;
        if (detailsCorrectDto.getCauseUserId() != null) {
            causeUrl = userMapper.selectById(detailsCorrectDto.getCauseUserId()).getSignatureUrl();
            if (StringUtils.isBlank(causeUrl)) {
                throw new ErrorException("找不到原因分析人的签名");
            }
        }
 
        // 纠正人
        String correctUrl = null;
        if (detailsCorrectDto.getCorrectUserId() != null) {
            correctUrl = userMapper.selectById(detailsCorrectDto.getCorrectUserId()).getSignatureUrl();
            if (StringUtils.isBlank(correctUrl)) {
                throw new ErrorException("找不到纠正人的签名");
            }
        }
 
        // 验证人
        String validationUrl = null;
        if (detailsCorrectDto.getValidationUserId() != null) {
            validationUrl = userMapper.selectById(detailsCorrectDto.getValidationUserId()).getSignatureUrl();
            if (StringUtils.isBlank(validationUrl)) {
                throw new ErrorException("找不到验证人的签名");
            }
        }
 
        // 获取路径
        InputStream inputStream = this.getClass().getResourceAsStream("/static/supervise-detail-correct.docx");
        ConfigureBuilder builder = Configure.builder();
        builder.useSpringEL(true);
        String finalRaiseUrl = raiseUrl;
        String finalCauseUrl = causeUrl;
        String finalCorrectUrl = correctUrl;
        String finalValidationUrl = validationUrl;
        XWPFTemplate template = XWPFTemplate.compile(inputStream, builder.build()).render(
                new HashMap<String, Object>() {{
                    put("correct", detailsCorrectDto);
                    put("raiseUrl", StringUtils.isNotBlank(finalRaiseUrl) ? Pictures.ofLocal(imgUrl + "/" + finalRaiseUrl).create() : null);
                    put("causeUrl", StringUtils.isNotBlank(finalCauseUrl) ? Pictures.ofLocal(imgUrl + "/" + finalCauseUrl).create() : null);
                    put("correctUrl", StringUtils.isNotBlank(finalCorrectUrl) ? Pictures.ofLocal(imgUrl + "/" + finalCorrectUrl).create() : null);
                    put("validationUrl", StringUtils.isNotBlank(finalValidationUrl) ? Pictures.ofLocal(imgUrl + "/" + finalValidationUrl).create() : null);
                }});
 
        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("导出失败");
        }
 
    }
}