From 3b6b3e356583e7ae3d264b4c59178c8b4087e5c4 Mon Sep 17 00:00:00 2001 From: zss <zss@example.com> Date: 星期四, 06 六月 2024 10:57:34 +0800 Subject: [PATCH] 检验任务的附件+提交前校验+复核确认新增不合格项目 --- inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderFileServiceImpl.java | 20 +++ inspect-server/src/main/java/com/yuanchu/mom/mapper/InsOrderFileMapper.java | 20 +++ inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsUnPassServiceImpl.java | 2 inspect-server/src/main/java/com/yuanchu/mom/pojo/InsOrderFile.java | 68 +++++++++++ inspect-server/src/main/java/com/yuanchu/mom/service/InsUnPassService.java | 6 inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderPlanServiceImpl.java | 114 ++++++++++++++++-- inspect-server/src/main/java/com/yuanchu/mom/service/InsOrderFileService.java | 16 ++ inspect-server/src/main/java/com/yuanchu/mom/controller/InsOrderPlanController.java | 55 ++++++++ inspect-server/src/main/resources/mapper/InsOrderFileMapper.xml | 25 ++++ inspect-server/src/main/java/com/yuanchu/mom/service/InsOrderPlanService.java | 7 + 10 files changed, 317 insertions(+), 16 deletions(-) diff --git a/inspect-server/src/main/java/com/yuanchu/mom/controller/InsOrderPlanController.java b/inspect-server/src/main/java/com/yuanchu/mom/controller/InsOrderPlanController.java index 0c9ee1d..a8a3b82 100644 --- a/inspect-server/src/main/java/com/yuanchu/mom/controller/InsOrderPlanController.java +++ b/inspect-server/src/main/java/com/yuanchu/mom/controller/InsOrderPlanController.java @@ -5,6 +5,8 @@ import com.yuanchu.mom.annotation.ValueAuth; import com.yuanchu.mom.annotation.ValueClassify; import com.yuanchu.mom.dto.InsOrderPlanDTO; +import com.yuanchu.mom.pojo.InsOrderFile; +import com.yuanchu.mom.service.InsOrderFileService; import com.yuanchu.mom.service.InsOrderPlanService; import com.yuanchu.mom.utils.JackSonUtil; import com.yuanchu.mom.vo.Result; @@ -15,7 +17,9 @@ import org.springframework.web.bind.annotation.RequestBody; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; +import org.springframework.web.multipart.MultipartFile; +import java.util.HashMap; import java.util.Map; /** @@ -28,6 +32,8 @@ public class InsOrderPlanController { private InsOrderPlanService insOrderPlanService; + + private InsOrderFileService insOrderFileService; @ValueClassify("妫�楠屼换鍔�") @ApiOperation(value = "鑾峰彇妫�楠屼换鍔″垪琛�") @@ -55,6 +61,7 @@ public Result claimInsOrderPlan(@RequestBody InsOrderPlanDTO data) { return Result.success(insOrderPlanService.claimInsOrderPlan(data)); } + @ValueClassify("妫�楠屼换鍔�") @ApiOperation(value = "鎵ц妫�楠屾搷浣�") @PostMapping("/doInsOrder") @@ -75,26 +82,70 @@ public Result<?> upPlanUser(Integer userId, Integer orderId) { return Result.success(insOrderPlanService.upPlanUser(userId, orderId)); } + @ValueClassify("妫�楠屼换鍔�") @ApiOperation(value = "澶嶆牳妫�楠屼换鍔�") @PostMapping("/verifyPlan") public Result<?> verifyPlan(Integer orderId, String laboratory, Integer type, String tell) { return Result.success(insOrderPlanService.verifyPlan(orderId, laboratory, type, tell)); } + + @ValueClassify("妫�楠屼换鍔�") + @ApiOperation(value = "鏍¢獙妫�楠屼换鍔℃彁浜�") + @PostMapping("/checkSubmitPlan") + public Result<?> checkSubmitPlan(Integer orderId, String laboratory) { + return Result.success(insOrderPlanService.checkSubmitPlan(orderId, laboratory)); + } + @ValueClassify("妫�楠屼换鍔�") @ApiOperation(value = "妫�楠屼换鍔℃彁浜�") @PostMapping("/submitPlan") public Result<?> submitPlan(Integer orderId, String laboratory, Integer verifyUser) { int num = insOrderPlanService.submitPlan(orderId, laboratory, verifyUser); - return num==1?Result.success():Result.fail("鎻愪氦澶辫触锛岄儴鍒嗛」鐩繕鏈繘琛屾楠�"); + return num == 1 ? Result.success() : Result.fail("鎻愪氦澶辫触锛岄儴鍒嗛」鐩繕鏈繘琛屾楠�"); } @ApiOperation(value = "淇濆瓨妫�楠屽唴瀹�") @PostMapping("/saveInsContext") @ValueAuth - public Result<?> saveInsContext(String param){ + public Result<?> saveInsContext(String param) { Map<String, Object> param2 = JSON.parseObject(param, Map.class); insOrderPlanService.saveInsContext(param2); return Result.success(); } + + @ValueClassify("妫�楠屼换鍔�") + @ApiOperation(value = "鏌ョ湅妫�楠屽崟涓嬬殑闄勪欢鍒楄〃") + @PostMapping("/getFileList") + public Result<?> getFileList(@RequestBody Map<String, Object> data) throws Exception { + Page page = JackSonUtil.unmarshal(JackSonUtil.marshal(data.get("page")), Page.class); + page.setOptimizeCountSql(false); + InsOrderFile insOrderFile = JackSonUtil.unmarshal(JackSonUtil.marshal(data.get("entity")), InsOrderFile.class); + return Result.success(insOrderPlanService.getFileList(page, insOrderFile)); + } + + @ValueClassify("妫�楠屼换鍔�") + @ApiOperation(value = "涓婁紶闄勪欢") + @PostMapping("/uploadFile") + public Result<?> uploadFile(Integer orderId, MultipartFile file) { + return Result.success(insOrderPlanService.uploadFile(orderId, file)); + } + + @ValueClassify("妫�楠屼换鍔�") + @ApiOperation(value = "鍒犻櫎闄勪欢") + @PostMapping("/delfile") + public Result<?> delfile(Integer id) { + return Result.success(insOrderFileService.removeById(id)); + } + + @ValueClassify("妫�楠屼换鍔�") + @ApiOperation(value = "涓嬭浇闄勪欢") + @PostMapping("/downFile") + public Result<?> downFile(Integer id) { + InsOrderFile insOrderFile = insOrderFileService.getById(id); + HashMap<String, Object> map = new HashMap<>(); + map.put("type", insOrderFile.getType()); + map.put("fileUrl", insOrderFile.getFileUrl()); + return Result.success(map); + } } diff --git a/inspect-server/src/main/java/com/yuanchu/mom/mapper/InsOrderFileMapper.java b/inspect-server/src/main/java/com/yuanchu/mom/mapper/InsOrderFileMapper.java new file mode 100644 index 0000000..dd3a93e --- /dev/null +++ b/inspect-server/src/main/java/com/yuanchu/mom/mapper/InsOrderFileMapper.java @@ -0,0 +1,20 @@ +package com.yuanchu.mom.mapper; + +import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; +import com.baomidou.mybatisplus.core.metadata.IPage; +import com.baomidou.mybatisplus.extension.plugins.pagination.Page; +import com.yuanchu.mom.pojo.InsOrderFile; +import com.baomidou.mybatisplus.core.mapper.BaseMapper; + +/** + * <p> + * 妫�楠屽崟涓嬬殑闄勪欢鍒楄〃 Mapper 鎺ュ彛 + * </p> + * + * @author 姹熻嫃榈烽洀缃戠粶绉戞妧鏈夐檺鍏徃 + * @since 2024-06-06 10:08:21 + */ +public interface InsOrderFileMapper extends BaseMapper<InsOrderFile> { + + IPage<InsOrderFile> getFileList(Page page, QueryWrapper<InsOrderFile> ew); +} diff --git a/inspect-server/src/main/java/com/yuanchu/mom/pojo/InsOrderFile.java b/inspect-server/src/main/java/com/yuanchu/mom/pojo/InsOrderFile.java new file mode 100644 index 0000000..0aa3a66 --- /dev/null +++ b/inspect-server/src/main/java/com/yuanchu/mom/pojo/InsOrderFile.java @@ -0,0 +1,68 @@ +package com.yuanchu.mom.pojo; + +import com.baomidou.mybatisplus.annotation.FieldFill; +import com.baomidou.mybatisplus.annotation.IdType; +import com.baomidou.mybatisplus.annotation.TableField; +import com.baomidou.mybatisplus.annotation.TableId; +import com.baomidou.mybatisplus.annotation.TableName; + +import java.io.Serializable; +import java.time.LocalDateTime; + +import com.yuanchu.mom.annotation.ValueTableShow; +import com.yuanchu.mom.common.OrderBy; +import io.swagger.annotations.ApiModel; +import io.swagger.annotations.ApiModelProperty; +import lombok.Getter; +import lombok.Setter; + +/** + * <p> + * 妫�楠屽崟涓嬬殑闄勪欢鍒楄〃 + * </p> + * + * @author 姹熻嫃榈烽洀缃戠粶绉戞妧鏈夐檺鍏徃 + * @since 2024-06-06 10:08:21 + */ +@Getter +@Setter +@TableName("ins_order_file") +@ApiModel(value = "InsOrderFile瀵硅薄", description = "妫�楠屽崟涓嬬殑闄勪欢鍒楄〃") +public class InsOrderFile extends OrderBy implements Serializable { + + @TableId(value = "id", type = IdType.AUTO) + private Integer id; + + @ApiModelProperty("鍏宠仈 妫�楠屽崟澶栭敭id") + private Integer insOrderId; + + @ApiModelProperty("绫诲瀷") + @ValueTableShow(2) + private Integer type; + + @ApiModelProperty("闄勪欢璺緞") + private String fileUrl; + + @ApiModelProperty("闄勪欢鍚嶇О") + @ValueTableShow(3) + private String fileName; + + @TableField(fill = FieldFill.INSERT) + private Integer createUser; + + @ApiModelProperty("涓婁紶浜�") + @ValueTableShow(4) + @TableField(exist = false, select = false) + private String name; + + @TableField(fill = FieldFill.INSERT) + @ApiModelProperty("涓婁紶鏃堕棿") + @ValueTableShow(5) + private LocalDateTime createTime; + + @TableField(fill = FieldFill.INSERT_UPDATE) + private Integer updateUser; + + @TableField(fill = FieldFill.INSERT_UPDATE) + private LocalDateTime updateTime; +} diff --git a/inspect-server/src/main/java/com/yuanchu/mom/service/InsOrderFileService.java b/inspect-server/src/main/java/com/yuanchu/mom/service/InsOrderFileService.java new file mode 100644 index 0000000..d18b7f3 --- /dev/null +++ b/inspect-server/src/main/java/com/yuanchu/mom/service/InsOrderFileService.java @@ -0,0 +1,16 @@ +package com.yuanchu.mom.service; + +import com.yuanchu.mom.pojo.InsOrderFile; +import com.baomidou.mybatisplus.extension.service.IService; + +/** + * <p> + * 妫�楠屽崟涓嬬殑闄勪欢鍒楄〃 鏈嶅姟绫� + * </p> + * + * @author 姹熻嫃榈烽洀缃戠粶绉戞妧鏈夐檺鍏徃 + * @since 2024-06-06 10:08:21 + */ +public interface InsOrderFileService extends IService<InsOrderFile> { + +} diff --git a/inspect-server/src/main/java/com/yuanchu/mom/service/InsOrderPlanService.java b/inspect-server/src/main/java/com/yuanchu/mom/service/InsOrderPlanService.java index 48957a1..4ec5f67 100644 --- a/inspect-server/src/main/java/com/yuanchu/mom/service/InsOrderPlanService.java +++ b/inspect-server/src/main/java/com/yuanchu/mom/service/InsOrderPlanService.java @@ -2,7 +2,9 @@ import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.yuanchu.mom.dto.InsOrderPlanDTO; +import com.yuanchu.mom.pojo.InsOrderFile; import com.yuanchu.mom.pojo.InsProduct; +import org.springframework.web.multipart.MultipartFile; import java.util.List; import java.util.Map; @@ -29,4 +31,9 @@ List<InsProduct> getInsProduct(Integer id, Integer type, String laboratory); + List<String> checkSubmitPlan(Integer orderId, String laboratory); + + Map<String,Object> getFileList(Page page, InsOrderFile insOrderFile); + + int uploadFile(Integer orderId, MultipartFile file); } diff --git a/inspect-server/src/main/java/com/yuanchu/mom/service/InsUnPassService.java b/inspect-server/src/main/java/com/yuanchu/mom/service/InsUnPassService.java index 198a274..421eaf5 100644 --- a/inspect-server/src/main/java/com/yuanchu/mom/service/InsUnPassService.java +++ b/inspect-server/src/main/java/com/yuanchu/mom/service/InsUnPassService.java @@ -1,7 +1,10 @@ package com.yuanchu.mom.service; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; +import com.baomidou.mybatisplus.extension.service.IService; import com.yuanchu.mom.dto.UnPassPageDto; +import com.yuanchu.mom.pojo.InsProductUser; +import com.yuanchu.mom.pojo.InsUnPass; import java.util.Map; @@ -9,6 +12,7 @@ * @author 鏈变匠鍚� * @date 2024/5/8 13:00 */ -public interface InsUnPassService { +public interface InsUnPassService extends IService<InsUnPass> { + Map<String, Object> pageInsUnPass(Page page, UnPassPageDto unPassPageDto); } \ No newline at end of file diff --git a/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderFileServiceImpl.java b/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderFileServiceImpl.java new file mode 100644 index 0000000..05a43c1 --- /dev/null +++ b/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderFileServiceImpl.java @@ -0,0 +1,20 @@ +package com.yuanchu.mom.service.impl; + +import com.yuanchu.mom.pojo.InsOrderFile; +import com.yuanchu.mom.mapper.InsOrderFileMapper; +import com.yuanchu.mom.service.InsOrderFileService; +import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; +import org.springframework.stereotype.Service; + +/** + * <p> + * 妫�楠屽崟涓嬬殑闄勪欢鍒楄〃 鏈嶅姟瀹炵幇绫� + * </p> + * + * @author 姹熻嫃榈烽洀缃戠粶绉戞妧鏈夐檺鍏徃 + * @since 2024-06-06 10:08:21 + */ +@Service +public class InsOrderFileServiceImpl extends ServiceImpl<InsOrderFileMapper, InsOrderFile> implements InsOrderFileService { + +} diff --git a/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderPlanServiceImpl.java b/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderPlanServiceImpl.java index 7e312bd..ed801ae 100644 --- a/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderPlanServiceImpl.java +++ b/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderPlanServiceImpl.java @@ -3,6 +3,7 @@ import cn.hutool.core.bean.BeanUtil; import cn.hutool.core.date.DateTime; import cn.hutool.core.date.DateUtil; +import cn.hutool.core.lang.UUID; import cn.hutool.core.util.ObjectUtil; import cn.hutool.core.util.StrUtil; import com.alibaba.fastjson.JSON; @@ -34,11 +35,13 @@ import com.yuanchu.mom.utils.QueryWrappers; import com.yuanchu.mom.vo.InsOrderPlanTaskSwitchVo; import com.yuanchu.mom.vo.InsOrderPlanVO; +import com.yuanchu.mom.vo.Result; import org.apache.commons.io.IOUtils; import org.apache.poi.xwpf.usermodel.*; import org.springframework.beans.factory.annotation.Value; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; +import org.springframework.web.multipart.MultipartFile; import javax.annotation.Resource; import java.io.*; @@ -93,6 +96,9 @@ private InsProductUserMapper insProductUserMapper; @Resource + private InsUnPassService insUnPassService; + + @Resource AuxiliaryOutputWorkingHoursMapper auxiliaryOutputWorkingHoursMapper; @Resource @@ -109,6 +115,9 @@ @Resource private InsBushingService insBushingService; + + @Resource + private InsOrderFileMapper insOrderFileMapper; @Override public Map<String, Object> selectInsOrderPlanList(Page page, InsOrderPlanDTO insOrderPlanDTO) { @@ -175,7 +184,7 @@ @Override public List<InsProduct> getInsProduct(Integer id, Integer type, String laboratory) { List<InsProduct> insProducts = new ArrayList<>(); - switch (type){ + switch (type) { case 0: insProducts = insSampleMapper.getInsProduct1(id, laboratory); break; @@ -191,6 +200,65 @@ if (BeanUtil.isEmpty(insProducts)) return null; getTemplateThing(set, map2, insProducts); return insProducts; + } + + @Override + public List<String> checkSubmitPlan(Integer orderId, String laboratory) { + List<String> collect = new ArrayList<>(); + List<InsSample> insSamples = insSampleMapper.selectList(Wrappers.<InsSample>lambdaQuery().eq(InsSample::getInsOrderId, orderId).select(InsSample::getId)); + List<Integer> ids = insSamples.stream().map(a -> a.getId()).collect(Collectors.toList()); + List<InsProduct> insProducts = insProductMapper.selectList(Wrappers.<InsProduct>lambdaQuery().in(InsProduct::getInsSampleId, ids).eq(InsProduct::getSonLaboratory, laboratory).eq(InsProduct::getState, 1).eq(InsProduct::getInsResult, 0)); + if (insProducts.size() > 0) { + collect = insProducts.stream().map(insProduct -> { + return insProduct.getInspectionItem() + "-" + insProduct.getInspectionItemSubclass(); + }).collect(Collectors.toList()); + } + return collect; + } + + @Override + public Map<String, Object> getFileList(Page page, InsOrderFile insOrderFile) { + Map<String, Object> map = new HashMap<>(); + map.put("head", PrintChina.printChina(InsOrderFile.class)); + IPage<InsOrderFile> insOrderFileIPage = insOrderFileMapper.getFileList(page, QueryWrappers.queryWrappers(insOrderFile)); + map.put("body", insOrderFileIPage); + return map; + } + + @Override + public int uploadFile(Integer orderId, MultipartFile file) { + String urlString; + String pathName; + String path; + String filename = file.getOriginalFilename(); + String contentType = file.getContentType(); + InsOrderFile insOrderFile = new InsOrderFile(); + insOrderFile.setInsOrderId(orderId); + insOrderFile.setFileName(filename); + if (contentType != null && contentType.startsWith("image/")) { + // 鏄浘鐗� + path = imgUrl; + insOrderFile.setType(1); + } else { + // 鏄枃浠� + path = wordUrl; + insOrderFile.setType(2); + } + try { + File realpath = new File(path); + if (!realpath.exists()) { + realpath.mkdirs(); + } + pathName = UUID.randomUUID() + "_" + file.getOriginalFilename(); + urlString = realpath + "/" + pathName; + file.transferTo(new File(urlString)); + insOrderFile.setFileUrl(pathName); + return insOrderFileMapper.insert(insOrderFile); + } catch (Exception e) { + e.printStackTrace(); + System.err.println("闄勪欢涓婁紶閿欒"); + return 0; + } } @Override @@ -368,6 +436,7 @@ insOrderStateMapper.update(null, Wrappers.<InsOrderState>lambdaUpdate().eq(InsOrderState::getInsOrderId, orderId).eq(InsOrderState::getLaboratory, laboratory).set(InsOrderState::getInsTime, now).set(InsOrderState::getInsState, num).set(InsOrderState::getVerifyTell, tell).set(InsOrderState::getVerifyUser, getLook.selectPowerByMethodAndUserId(null).get("userId"))); Long count = insOrderStateMapper.selectCount(Wrappers.<InsOrderState>lambdaQuery().eq(InsOrderState::getInsOrderId, orderId).ne(InsOrderState::getInsState, 5)); if (count == 0 && num == 5) { + List<InsUnPass> insUnPasses = new ArrayList<>(); /*鏍峰搧涓嬬殑椤圭洰鍙鏈変竴涓」鐩笉鍚堟牸鍒欐楠岀粨鏋滀负0,鍚﹀垯涓�1*/ List<InsSample> insSamples = insSampleMapper.selectList(Wrappers.<InsSample>lambdaQuery().eq(InsSample::getInsOrderId, orderId)); for (InsSample insSample : insSamples) { @@ -379,7 +448,25 @@ insSample.setInsResult(1); } insSampleMapper.updateById(insSample); + /*澶嶆牳閫氳繃鍚庯紝灏嗕笉鍚堟牸鐨勯」鐩俊鎭坊鍔犲埌ins_un_pass琛ㄤ腑*/ + for (InsProduct insProduct : insProducts) { + if (insProduct.getInsResult() == 0) { + InsUnPass insUnPass = new InsUnPass(); + insUnPass.setModel(insSample.getModel()); + insUnPass.setSample(insSample.getSample()); + insUnPass.setInspectionItem(insProduct.getInspectionItem()); + insUnPass.setInspectionItemSubclass(insProduct.getInspectionItemSubclass()); + insUnPass.setLastValue(insProduct.getLastValue()); + insUnPass.setEntrustCode(insOrderMapper.selectById(orderId).getEntrustCode()); + List<Integer> userIds = insProductUserMapper.selectList(Wrappers.<InsProductUser>lambdaQuery().eq(InsProductUser::getInsProductId, insProduct.getId())).stream().map(InsProductUser::getCreateUser).distinct().collect(Collectors.toList()); + String name = userMapper.selectBatchIds(userIds).stream().map(User::getName).collect(Collectors.joining(",")); + insUnPass.setName(name); + insUnPasses.add(insUnPass); + } + } + insUnPassService.saveBatch(insUnPasses); } + InsOrder insOrder = insOrderMapper.selectById(orderId); Map<String, String> user = insProductMapper.selectUserById(insOrder.getUserId()); List<SampleProductDto> samples = insSampleMapper.selectSampleProductListByOrderId(orderId); @@ -398,7 +485,7 @@ AtomicReference<String> resultEn = new AtomicReference<>(""); samples.forEach(a -> { Long productCount = insProductMapper.selectCount(Wrappers.<InsProduct>lambdaQuery().eq(InsProduct::getInsSampleId, a.getId())); - productSize.set(productSize.get()+Integer.parseInt(productCount+"")); + productSize.set(productSize.get() + Integer.parseInt(productCount + "")); models.add(a.getModel()); standardMethod.add(baseMapper.getStandardMethodCode(a.getStandardMethodListId())); Set<String> templateSet = new HashSet<>(); @@ -536,8 +623,8 @@ textRenderData.setText("鈭�"); break; case 0: - resultCh.set(resultCh.get() + "銆�" + p.getInspectionItem() + (Objects.equals(p.getInspectionItemSubclass(), "") ?"":" "+p.getInspectionItemSubclass())); - resultEn.set(resultEn.get() + "銆�" + p.getInspectionItemEn() + ((Objects.equals(p.getInspectionItemSubclassEn(), "")||Objects.equals(p.getInspectionItemSubclassEn(), null)) ?"":" "+p.getInspectionItemSubclassEn())); + resultCh.set(resultCh.get() + "銆�" + p.getInspectionItem() + (Objects.equals(p.getInspectionItemSubclass(), "") ? "" : " " + p.getInspectionItemSubclass())); + resultEn.set(resultEn.get() + "銆�" + p.getInspectionItemEn() + ((Objects.equals(p.getInspectionItemSubclassEn(), "") || Objects.equals(p.getInspectionItemSubclassEn(), null)) ? "" : " " + p.getInspectionItemSubclassEn())); textRenderData.setText("脳"); break; default: @@ -574,8 +661,8 @@ textRenderData.setText("鉁�"); break; case 0: - resultCh.set(resultCh.get() + "銆�" + p.getInspectionItem() + (p.getInspectionItemSubclass().equals("")?"":" "+p.getInspectionItemSubclass())); - resultEn.set(resultEn.get() + "銆�" + p.getInspectionItemEn() + ((Objects.equals(p.getInspectionItemSubclassEn(), "")||Objects.equals(p.getInspectionItemSubclassEn(), null)) ?"":" "+p.getInspectionItemSubclassEn())); + resultCh.set(resultCh.get() + "銆�" + p.getInspectionItem() + (p.getInspectionItemSubclass().equals("") ? "" : " " + p.getInspectionItemSubclass())); + resultEn.set(resultEn.get() + "銆�" + p.getInspectionItemEn() + ((Objects.equals(p.getInspectionItemSubclassEn(), "") || Objects.equals(p.getInspectionItemSubclassEn(), null)) ? "" : " " + p.getInspectionItemSubclassEn())); textRenderData.setText("鉁�"); break; default: @@ -610,7 +697,7 @@ } TextRenderData[] text2 = text.toArray(new TextRenderData[0]); rowRenderData = Rows.of(text2).rowAtleastHeight(1).center().create(); - if(rowRenderData.getCells().size()!=0){ + if (rowRenderData.getCells().size() != 0) { rows.add(rowRenderData); } TableRenderData tableRenderData = new TableRenderData(); @@ -621,7 +708,7 @@ System.out.print(cell.getParagraphs().get(0).getContents()); } System.out.println("");*/ - if(row.getCells().size()!=countSize){ + if (row.getCells().size() != countSize) { throw new ErrorException("姣忚鍗曞厓鏍间笉鐩哥瓑"); } } @@ -699,13 +786,14 @@ throw new ErrorException("鎵句笉鍒版楠屼汉鐨勭鍚�"); } Custom custom = customMapper.selectById(user.get("company")); - if(!resultCh.get().equals("")){ - resultCh.set("渚濇嵁濮旀墭瑕佹眰锛�"+resultCh.get().replaceFirst("銆�", "")+"绛夋墍妫�椤圭洰涓嶇鍚堣姹傦紝鍏朵綑鎵�妫�椤圭洰鍧囩鍚堣姹傘��"); - resultEn.set("According to commissioned requirements,"+resultEn.get().replaceFirst("銆�", "")+" these inspected items do not meet the requirements, all other inspected items meet the requirements."); - }else{ + if (!resultCh.get().equals("")) { + resultCh.set("渚濇嵁濮旀墭瑕佹眰锛�" + resultCh.get().replaceFirst("銆�", "") + "绛夋墍妫�椤圭洰涓嶇鍚堣姹傦紝鍏朵綑鎵�妫�椤圭洰鍧囩鍚堣姹傘��"); + resultEn.set("According to commissioned requirements," + resultEn.get().replaceFirst("銆�", "") + " these inspected items do not meet the requirements, all other inspected items meet the requirements."); + } else { resultCh.set("渚濇嵁濮旀墭瑕佹眰锛屾墍妫�椤圭洰鍧囩鍚堣姹傘��"); resultEn.set("According to commissioned requirements, all the tested items meet the requirements."); } + XWPFTemplate template = XWPFTemplate.compile(url, builder.build()).render( new HashMap<String, Object>() {{ put("order", insOrder); @@ -849,7 +937,7 @@ int count = 0; for (InsProduct product : insProducts) { count++; - str += "<br/>"+count + "锛�" +product.getInspectionItem() + " " + product.getInspectionItemSubclass() + "<br/>"; + str += "<br/>" + count + "锛�" + product.getInspectionItem() + " " + product.getInspectionItemSubclass() + "<br/>"; } throw new ErrorException("<strong>瀛樺湪寰呮楠岀殑椤圭洰锛�</strong><br/>" + str); } diff --git a/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsUnPassServiceImpl.java b/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsUnPassServiceImpl.java index 5c6ad2e..418555b 100644 --- a/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsUnPassServiceImpl.java +++ b/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsUnPassServiceImpl.java @@ -22,10 +22,12 @@ */ @Service public class InsUnPassServiceImpl extends ServiceImpl<InsUnPassMapper, InsUnPass> implements InsUnPassService { + @Resource private GetLook getLook; @Resource private InsUnPassMapper insUnPassMapper; + @Override public Map<String, Object> pageInsUnPass(Page page, UnPassPageDto unPassPageDto) { Map<String, Object> map = new HashMap<>(); diff --git a/inspect-server/src/main/resources/mapper/InsOrderFileMapper.xml b/inspect-server/src/main/resources/mapper/InsOrderFileMapper.xml new file mode 100644 index 0000000..9d060b9 --- /dev/null +++ b/inspect-server/src/main/resources/mapper/InsOrderFileMapper.xml @@ -0,0 +1,25 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> +<mapper namespace="com.yuanchu.mom.mapper.InsOrderFileMapper"> + <!-- 閫氱敤鏌ヨ鏄犲皠缁撴灉 --> + <resultMap id="BaseResultMap" type="com.yuanchu.mom.pojo.InsOrderFile"> + <id column="id" property="id"/> + <result column="ins_order_id" property="insOrderId"/> + <result column="type" property="type"/> + <result column="file_url" property="fileUrl"/> + <result column="file_name" property="fileName"/> + <result column="create_user" property="createUser"/> + <result column="create_time" property="createTime"/> + <result column="update_user" property="updateUser"/> + <result column="update_time" property="updateTime"/> + </resultMap> + <select id="getFileList" resultType="com.yuanchu.mom.pojo.InsOrderFile"> + select A.* + from (select iof.*, name + from ins_order_file iof + left join user u on iof.create_user = u.id) A + <if test="ew.customSqlSegment != null and ew.customSqlSegment != ''"> + ${ew.customSqlSegment} + </if> + </select> +</mapper> -- Gitblit v1.9.3