Merge branch 'dev' into dev_zj
# Conflicts:
# ruoyi-system/src/main/java/com/ruoyi/system/mapper/UserMapper.java
# ruoyi-system/src/main/resources/mapper/system/UserMapper.xml
| | |
| | | |
| | | @ApiOperation(value = "è·ååå§è®°å½æ¨¡æ¿å表") |
| | | @GetMapping("/selectStandardTemplatePageList") |
| | | public Result selectStandardTemplatePageList(Page page,StandardTemplate standardTemplate) throws Exception { |
| | | public Result selectStandardTemplatePageList(Page page,StandardTemplate standardTemplate){ |
| | | return Result.success(standardTemplateService.selectStandardTemplatePageList(page, standardTemplate)); |
| | | } |
| | | |
| | |
| | | import org.apache.ibatis.annotations.Param; |
| | | |
| | | import java.util.List; |
| | | import java.util.Set; |
| | | |
| | | /** |
| | | * @author Administrator |
| | |
| | | */ |
| | | IPage<IfsInventoryQuantitySupplierDto> getIfsByQuarter(Page<IfsInventoryQuantitySupplierDto> page, @Param("ew") QueryWrapper<IfsInventoryQuantitySupplierDto> ew, @Param("beginDeclareDate") String beginDeclareDate, @Param("endDeclareDate")String endDeclareDate); |
| | | |
| | | /** |
| | | * æ¹éæ¥è¯¢æ |
| | | * @param sampleTypeValues |
| | | * @return |
| | | */ |
| | | List<SampleDto> getStandardTree3Batch(@Param("sampleTypeValues") Set<String> sampleTypeValues); |
| | | } |
| | | |
| | | |
| | |
| | | .like(StandardProductList::getTree, tree)); |
| | | } |
| | | |
| | | boolean success = false; |
| | | int retryCount = 0; |
| | | while (!success && retryCount < 100) { |
| | | try { |
| | | standardProductListService2.saveBatch(list.stream().map(a -> { |
| | | a.setFactory(trees[0]); |
| | | a.setLaboratory(trees[1]); |
| | | a.setSampleType(trees[2]); |
| | | a.setCreateUser(userId); |
| | | a.setUpdateUser(userId); |
| | | a.setStandardMethodListId(id); |
| | | return a; |
| | | }).collect(Collectors.toList())); |
| | | ; |
| | | success = true; |
| | | } catch (Exception e) { |
| | | // å¤çéå¤ ID çè®°å½ï¼éæ°çæ ID å¹¶ç»§ç»å°è¯æå
¥ |
| | | for (StandardProductList productList : list) { |
| | | productList.setId(IdWorker.getId()); |
| | | } |
| | | try { |
| | | standardProductListService2.saveBatch(list.stream().map(a -> { |
| | | a.setFactory(trees[0]); |
| | | a.setLaboratory(trees[1]); |
| | | a.setSampleType(trees[2]); |
| | | a.setCreateUser(userId); |
| | | a.setUpdateUser(userId); |
| | | a.setStandardMethodListId(id); |
| | | return a; |
| | | }).collect(Collectors.toList())); |
| | | } catch (Exception e) { |
| | | // å¤çéå¤ ID çè®°å½ï¼éæ°çæ ID å¹¶ç»§ç»å°è¯æå
¥ |
| | | for (StandardProductList productList : list) { |
| | | productList.setId(IdWorker.getId()); |
| | | } |
| | | } |
| | | if (!success) { |
| | | throw new RuntimeException("æå
¥å¤±è´¥"); |
| | | } |
| | | |
| | | } |
| | |
| | | import com.baomidou.mybatisplus.core.toolkit.StringUtils; |
| | | import com.baomidou.mybatisplus.core.toolkit.Wrappers; |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | import com.ruoyi.basic.dto.SampleDto; |
| | | import com.ruoyi.common.exception.base.BaseException; |
| | | import com.ruoyi.basic.dto.FactoryDto; |
| | | import com.ruoyi.basic.dto.LaboratoryDto; |
| | |
| | | |
| | | import java.io.IOException; |
| | | import java.io.InputStream; |
| | | import java.util.ArrayList; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | import java.util.*; |
| | | import java.util.concurrent.atomic.AtomicReference; |
| | | import java.util.stream.Collectors; |
| | | |
| | | /** |
| | | * @author Administrator |
| | |
| | | @Override |
| | | public List<FactoryDto> selectStandardTreeList() { |
| | | List<FactoryDto> factoryDtos = standardTreeMapper.selectStandardTreeList(); |
| | | // æ¶éææ sampleTypeDto ç value |
| | | Set<String> sampleTypeValues = new HashSet<>(); |
| | | for (FactoryDto factoryDto : factoryDtos) { |
| | | for (LaboratoryDto laboratoryDto : factoryDto.getChildren()) { |
| | | laboratoryDto.getChildren().sort((o1, o2) -> (o1.getSort() == null ? 0 : o1.getSort()) |
| | | - (o2.getSort() == null ? 0 : o2.getSort())); |
| | | for (SampleTypeDto sampleTypeDto : laboratoryDto.getChildren()) { |
| | | // if (sampleTypeDto.getChildren().size() == 0) { |
| | | sampleTypeDto.getChildren().addAll(standardTreeMapper.getStandardTree3(sampleTypeDto.getValue())); |
| | | // } |
| | | sampleTypeValues.add(sampleTypeDto.getValue()); |
| | | } |
| | | } |
| | | } |
| | | // æ¹éæ¥è¯¢ææ sampleTypeDto çæ°æ® |
| | | List<SampleDto> standardList = standardTreeMapper.getStandardTree3Batch(sampleTypeValues); |
| | | Map<String, List<SampleDto>> standardTreeMap = standardList.stream().collect(Collectors.groupingBy(SampleDto::getValue)); |
| | | // å°æ¥è¯¢ç»æåé
å°å¯¹åºç sampleTypeDto |
| | | for (FactoryDto factoryDto : factoryDtos) { |
| | | for (LaboratoryDto laboratoryDto : factoryDto.getChildren()) { |
| | | for (SampleTypeDto sampleTypeDto : laboratoryDto.getChildren()) { |
| | | List<SampleDto> standardTreeList = standardTreeMap.get(sampleTypeDto.getValue()); |
| | | if (standardTreeList != null) { |
| | | sampleTypeDto.getChildren().addAll(standardTreeList); |
| | | } |
| | | } |
| | | } |
| | | } |
| | | return factoryDtos; |
| | | } |
| | | |
| | | |
| | | |
| | | @Override |
| | |
| | | standardTreeMapper.delete(Wrappers.<StandardTree>lambdaUpdate().eq(StandardTree::getFactory, trees[0]).eq(StandardTree::getLaboratory, trees[1]).eq(StandardTree::getSampleType, trees[2]).eq(StandardTree::getSample, trees[3]).eq(StandardTree::getModel, trees[4])); |
| | | } |
| | | break; |
| | | /*case 4: |
| | | standardTreeMapper.delete(Wrappers.<StandardTree>lambdaUpdate().eq(StandardTree::getFactory, trees[0]).eq(StandardTree::getLaboratory, trees[1]).eq(StandardTree::getSampleType, trees[2]).eq(StandardTree::getSample, trees[3])); |
| | | break; |
| | | case 3: |
| | | standardTreeMapper.delete(Wrappers.<StandardTree>lambdaUpdate().eq(StandardTree::getFactory, trees[0]).eq(StandardTree::getLaboratory, trees[1]).eq(StandardTree::getSampleType, trees[2])); |
| | | break; |
| | | case 2: |
| | | standardTreeMapper.delete(Wrappers.<StandardTree>lambdaUpdate().eq(StandardTree::getFactory, trees[0]).eq(StandardTree::getLaboratory, trees[1])); |
| | | break; |
| | | case 1: |
| | | standardTreeMapper.delete(Wrappers.<StandardTree>lambdaUpdate().eq(StandardTree::getFactory, trees[0])); |
| | | break;*/ |
| | | } |
| | | return 1; |
| | | } |
| | |
| | | and st.sample = p.name |
| | | </select> |
| | | |
| | | <select id="getStandardTree3" resultType="com.ruoyi.basic.dto.SampleDto"> |
| | | select model label, |
| | | model value |
| | | from standard_tree |
| | | where sample_type = #{sampleType} |
| | | and sample is null |
| | | </select> |
| | | |
| | | <select id="getLaboratory" resultType="java.lang.String"> |
| | | select l.laboratory_name |
| | | from structure_test_object sto |
| | |
| | | ${ew.customSqlSegment} |
| | | </if> |
| | | </select> |
| | | |
| | | <select id="getStandardTree3Batch" resultType="com.ruoyi.basic.dto.SampleDto"> |
| | | select model label, |
| | | model value |
| | | from standard_tree |
| | | where sample_type in |
| | | <foreach item="item" collection="sampleTypeValues" open="(" separator="," close=")"> |
| | | #{item} |
| | | </foreach> |
| | | and sample is null |
| | | </select> |
| | | </mapper> |
| | |
| | | </dependency> |
| | | |
| | | <!--word转pdf--> |
| | | <!--D:\JavaWork\center-lims-after\inspect-server\src\main\resources\lib--> |
| | | <!--mvn install:install-file -Dfile=aspose-words-15.12.0-jdk16.jar -DgroupId=com.aspose -DartifactId=aspose-words -Dversion=15.12.0 -Dpackaging=jar--> |
| | | <dependency> |
| | | <groupId>com.aspose</groupId> |
| | |
| | | return Result.success(insOrderService.upInsOrder(orderId, sampleId, appointed, userId,sonLaboratory)); |
| | | } |
| | | |
| | | //todo: ä¸åéè¦ä¿®æ¹ |
| | | @ApiOperation(value = "æ·»å æ£éªä¸åæ°æ®") |
| | | @PostMapping("/addInsOrder") |
| | | public Result<?> addInsOrder(String str) { |
| | | Map<String, Object> map = JSON.parseObject(str, Map.class); |
| | | JSONArray jsonArray = JSON.parseArray(map.get("list")+""); |
| | | List<SampleProductDto> list = jsonArray.toJavaList(SampleProductDto.class); |
| | | InsOrder insOrder = JSON.parseObject(JSON.toJSONString(map.get("insOrder")), InsOrder.class); |
| | | List<List<Integer>> pairing = JSON.parseArray(map.get("pairing")+""); |
| | | return Result.success(insOrderService.addInsOrder(list, insOrder, pairing)); |
| | | public Result<?> addInsOrder(@RequestBody InsPlaceOrderDto insPlaceOrderDto) { |
| | | return Result.success(insOrderService.addInsOrder(insPlaceOrderDto.getSampleList(), insPlaceOrderDto.getInsOrder())); |
| | | } |
| | | |
| | | @ApiOperation(value = "æ¥è¯¢è®¢åæé¿é¢è®¡æ¶é´") |
| | |
| | | return Result.success(insOrderService.getRetestResult(insProductId)); |
| | | } |
| | | |
| | | |
| | | |
| | | @ApiOperation(value = "éåä¸ä¸å") |
| | | @PostMapping("/addRawCopperOrder") |
| | | public Result<?> addRawCopperOrder(String str) { |
| | | Map<String, Object> map = JSON.parseObject(str, Map.class); |
| | | JSONArray jsonArray = JSON.parseArray(map.get("list")+""); |
| | | List<SampleProductDto> list = jsonArray.toJavaList(SampleProductDto.class); |
| | | CopperInsOrderDto CopperInsOrder = JSON.parseObject(JSON.toJSONString(map.get("insOrder")), CopperInsOrderDto.class); |
| | | return Result.success(insOrderService.addRawCopperOrder(list, CopperInsOrder)); |
| | | } |
| | | |
| | | |
| | | @ApiOperation(value = "ä¿®æ¹å§æç¼å·") |
| | | @PostMapping("/updateOrderEntrustCode") |
| | | public Result<?> updateOrderEntrustCode(@RequestBody InsOrder insOrder) { |
| | |
| | | } |
| | | |
| | | @ApiOperation(value = "å é¤éå订å") |
| | | @GetMapping("/delInsOrder") |
| | | @DeleteMapping("/delInsOrder") |
| | | public Result<?> delInsOrder(Integer insOrderId) { |
| | | // æ¥è¯¢è®¢å |
| | | InsOrder order = insOrderService.getById(insOrderId); |
| | |
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | import com.ruoyi.basic.dto.*; |
| | | import com.ruoyi.basic.pojo.IfsInventoryQuantity; |
| | | import com.ruoyi.inspect.dto.InsPlaceOrderDto; |
| | | import com.ruoyi.inspect.dto.SampleProductDto; |
| | | import com.ruoyi.inspect.pojo.InsOrder; |
| | | import com.ruoyi.inspect.pojo.RawMaterialOrderTemplate; |
| | | import com.ruoyi.inspect.service.InsOrderService; |
| | | import com.ruoyi.inspect.service.RawMaterialOrderService; |
| | | import com.ruoyi.inspect.service.RawMaterialOrderTemplateService; |
| | | import com.ruoyi.common.core.domain.Result; |
| | |
| | | @Api(tags = "åææä¸å") |
| | | public class RawMaterialOrderController { |
| | | |
| | | private InsOrderService insOrderService; |
| | | private RawMaterialOrderService rawMaterialOrderService; |
| | | private RawMaterialOrderTemplateService rawMaterialOrderTemplateService; |
| | | |
| | |
| | | |
| | | /** |
| | | * åæ¶æ¥æ£ |
| | | * @param param åææä¸å |
| | | * @param param |
| | | * @return |
| | | */ |
| | | @ApiOperation(value = "æ¤éæ¥æ£") |
| | |
| | | |
| | | @ApiOperation(value = "åææä¸åå
æ£") |
| | | @PostMapping("/addExemptionOrder") |
| | | public Result<?> addExemptionOrder(String str) { |
| | | Map<String, Object> map = JSON.parseObject(str, Map.class); |
| | | JSONArray jsonArray = JSON.parseArray(map.get("list")+""); |
| | | List<SampleProductDto> list = jsonArray.toJavaList(SampleProductDto.class); |
| | | InsOrder insOrder = JSON.parseObject(JSON.toJSONString(map.get("insOrder")), InsOrder.class); |
| | | return Result.success(rawMaterialOrderService.addExemptionOrder(list, insOrder)); |
| | | public Result<?> addExemptionOrder(@RequestBody InsPlaceOrderDto insPlaceOrderDto) { |
| | | return Result.success(rawMaterialOrderService.addExemptionOrder(insPlaceOrderDto.getSampleList(), insPlaceOrderDto.getInsOrder())); |
| | | } |
| | | |
| | | |
| | |
| | | |
| | | /** |
| | | * åæ¶æ¥æ£ |
| | | * @param id åææä¸å |
| | | * @param id |
| | | * @return |
| | | */ |
| | | @ApiOperation(value = "å é¤åæææ¥æ£ä¿¡æ¯") |
| | |
| | | return Result.success(); |
| | | } |
| | | |
| | | |
| | | |
| | | @ApiOperation(value = "éåä¸ä¸å") |
| | | @PostMapping("/addRawCopperOrder") |
| | | public Result<?> addRawCopperOrder(@RequestBody InsPlaceOrderDto insPlaceOrderDto) { |
| | | return Result.success(insOrderService.addRawCopperOrder(insPlaceOrderDto.getSampleList(), insPlaceOrderDto.getCopperInsOrder())); |
| | | } |
| | | |
| | | @ApiOperation(value = "éåä¸ä¸åå
æ£") |
| | | @PostMapping("/addRawCopperOrderExemptionOrder") |
| | | public Result<?> addRawCopperOrderExemptionOrder(String str) { |
| | | Map<String, Object> map = JSON.parseObject(str, Map.class); |
| | | JSONArray jsonArray = JSON.parseArray(map.get("list")+""); |
| | | List<SampleProductDto> list = jsonArray.toJavaList(SampleProductDto.class); |
| | | CopperInsOrderDto CopperInsOrder = JSON.parseObject(JSON.toJSONString(map.get("insOrder")), CopperInsOrderDto.class); |
| | | return Result.success(rawMaterialOrderService.addRawCopperOrderExemptionOrder(list, CopperInsOrder)); |
| | | public Result<?> addRawCopperOrderExemptionOrder(@RequestBody InsPlaceOrderDto insPlaceOrderDto) { |
| | | return Result.success(rawMaterialOrderService.addRawCopperOrderExemptionOrder(insPlaceOrderDto.getSampleList(), insPlaceOrderDto.getCopperInsOrder())); |
| | | } |
| | | |
| | | /** |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.ruoyi.inspect.dto; |
| | | |
| | | import com.ruoyi.inspect.pojo.InsOrder; |
| | | import io.swagger.annotations.ApiModelProperty; |
| | | import lombok.Data; |
| | | |
| | | import java.util.List; |
| | | |
| | | /** |
| | | * ä¸å对象 |
| | | * |
| | | * @Author zhuo |
| | | * @Date 2025/2/19 |
| | | */ |
| | | @Data |
| | | public class InsPlaceOrderDto{ |
| | | |
| | | @ApiModelProperty("æ ·å") |
| | | private List<SampleProductDto> sampleList; |
| | | |
| | | @ApiModelProperty("订åä¿¡æ¯") |
| | | private InsOrder insOrder; |
| | | |
| | | @ApiModelProperty("éåä¸è®¢å") |
| | | private CopperInsOrderDto copperInsOrder; |
| | | |
| | | } |
| | |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | import com.ruoyi.inspect.dto.InsOrderDeviceRecordDto; |
| | | import com.ruoyi.inspect.pojo.InsOrderDeviceRecord; |
| | | import org.apache.ibatis.annotations.Param; |
| | | |
| | | import java.util.List; |
| | | import java.util.Set; |
| | |
| | | * @param insOrderId |
| | | * @return |
| | | */ |
| | | List<InsOrderDeviceRecordDto> selectDeviceNumber(Integer insOrderId); |
| | | List<InsOrderDeviceRecordDto> selectDeviceNumber(@Param("insOrderId") Integer insOrderId); |
| | | |
| | | /** |
| | | * æ ¹æ®ç¼å·æ¥è¯¢è®¾å¤id |
| | | * @param deviceNumbers |
| | | * @return |
| | | */ |
| | | List<Integer> selectDeviceIdsByNumbers(Set<String> deviceNumbers); |
| | | List<Integer> selectDeviceIdsByNumbers(@Param("deviceNumbers") Set<String> deviceNumbers); |
| | | } |
| | | |
| | |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | import com.ruoyi.inspect.pojo.InsOrderFile; |
| | | import org.apache.ibatis.annotations.Param; |
| | | |
| | | /** |
| | | * <p> |
| | |
| | | */ |
| | | public interface InsOrderFileMapper extends BaseMapper<InsOrderFile> { |
| | | |
| | | IPage<InsOrderFile> getFileList(Page page, QueryWrapper<InsOrderFile> ew, Integer insOrderId); |
| | | IPage<InsOrderFile> getFileList(@Param("page") Page page, @Param("ew") QueryWrapper<InsOrderFile> ew, @Param("insOrderId") Integer insOrderId); |
| | | } |
| | |
| | | public interface InsOrderMapper extends BaseMapper<InsOrder> { |
| | | |
| | | //è·åæ£éªä¸åæ°æ® |
| | | IPage<SampleOrderDto> selectInsOrderPage(IPage<InsOrder> page, QueryWrapper<SampleOrderDto> ew, String laboratory, String isOrderAll); |
| | | IPage<SampleOrderDto> selectInsOrderPage(@Param("page") IPage<InsOrder> page, @Param("ew") QueryWrapper<SampleOrderDto> ew, @Param("laboratory") String laboratory, @Param("isOrderAll") String isOrderAll); |
| | | |
| | | |
| | | String getLaboratoryCode(String name); |
| | | String getLaboratoryCode(@Param("name") String name); |
| | | |
| | | IPage<SampleProductDto2> selectSampleAndProductByOrderId(IPage<SampleProductDto2> page, QueryWrapper<SampleProductDto2> ew, Integer id); |
| | | IPage<SampleProductDto2> selectSampleAndProductByOrderId(@Param("page") IPage<SampleProductDto2> page, @Param("ew") QueryWrapper<SampleProductDto2> ew, @Param("id") Integer id); |
| | | |
| | | IPage<CostStatisticsDto> selectCostStatistics(IPage<CostStatisticsDto> page, QueryWrapper<CostStatisticsDto> ew); |
| | | IPage<CostStatisticsDto> selectCostStatistics(@Param("page") IPage<CostStatisticsDto> page, @Param("ew") QueryWrapper<CostStatisticsDto> ew); |
| | | |
| | | List<CostStatisticsDto> selectCostStatistics2(@Param("ew") QueryWrapper<CostStatisticsDto> ew); |
| | | |
| | | List<Map<String, String>> selectDeviceList(Set<String> names); |
| | | List<Map<String, String>> selectDeviceList(@Param("names") Set<String> names); |
| | | List<SampleDefectsFatherVo> selectSampleDefects(Page page, @Param("inspectionItems") String inspectionItems, @Param("orderNumber") String orderNumber); |
| | | |
| | | Long getCount(@Param("inspectionItems") String inspectionItems, @Param("orderNumber") String orderNumber); |
| | | |
| | | String getStandardMethodCode(Integer id); |
| | | String getStandardMethodCode(@Param("id") Integer id); |
| | | |
| | | int updateStatus( Integer id); |
| | | int updateStatus(@Param("id") Integer id); |
| | | |
| | | String selLaboratoryCode(String laboratory); |
| | | String selLaboratoryCode(@Param("laboratory") String laboratory); |
| | | |
| | | List<Map<Integer, Object>> selectReportModelByOrderId(@Param("id") Integer id, @Param("laboratory") String laboratory); |
| | | |
| | | String seldepLimsId(int depLimsId); |
| | | String seldepLimsId(@Param("depLimsId") Integer depLimsId); |
| | | |
| | | /** |
| | | * æ¥è¯¢æ£éªç»æ |
| | |
| | | * @param id |
| | | * @return |
| | | */ |
| | | int selectSampleMax(Integer id); |
| | | int selectSampleMax(@Param("id") Integer id); |
| | | |
| | | /** |
| | | * è·å线è¯é¢è² |
| | | * @param id |
| | | * @return |
| | | */ |
| | | List<String> selectSampleCableTag(Integer id); |
| | | List<String> selectSampleCableTag(@Param("id") Integer id); |
| | | |
| | | /** |
| | | * |
| | | * @param orderId |
| | | * @return |
| | | */ |
| | | int selectSampleItemS(Integer orderId); |
| | | int selectSampleItemS(@Param("orderId") Integer orderId); |
| | | |
| | | /** |
| | | * åªæ¥è¯¢é»è®¤ç¬¬ä¸ä¸ªç产å |
| | | * @param id |
| | | * @return |
| | | */ |
| | | List<SampleProductExportDto> selectSampleBySampleIdOne(Integer id); |
| | | List<SampleProductExportDto> selectSampleBySampleIdOne(@Param("id") Integer id); |
| | | |
| | | /** |
| | | * æ¥è¯¢æ¥åå¾ |
| | | * @param |
| | | * @return |
| | | */ |
| | | List<Map<String, Object>> selectCalendarWorkByWeek(int day); |
| | | List<Map<String, Object>> selectCalendarWorkByWeek(@Param("day") Integer day); |
| | | |
| | | /** |
| | | * |
| | | * @param partNo |
| | | * @return |
| | | */ |
| | | StructureTestObject selectProductByPartNo(String partNo); |
| | | StructureTestObject selectProductByPartNo(@Param("partNo") String partNo); |
| | | |
| | | /** |
| | | * |
| | | * @param partNo |
| | | * @return |
| | | */ |
| | | StructureTestObject selectByPartNo(String partNo); |
| | | StructureTestObject selectByPartNo(@Param("partNo") String partNo); |
| | | |
| | | /** |
| | | * æåæ ç¾æå° |
| | | * @param ids |
| | | * @return |
| | | */ |
| | | List<InsOrderPrintingVo> labelOrderPrinting(List<Integer> ids); |
| | | List<InsOrderPrintingVo> labelOrderPrinting(@Param("ids") List<Integer> ids); |
| | | |
| | | List<SampleOrderDto> rawAllInsOrderExport(QueryWrapper<SampleOrderDto> ew, String laboratory, String isOrderAll); |
| | | List<SampleOrderDto> rawAllInsOrderExport(@Param("ew") QueryWrapper<SampleOrderDto> ew, @Param("laboratory") String laboratory, @Param("isOrderAll") String isOrderAll); |
| | | |
| | | /** |
| | | * æ ¹æ®è®¢åæ¥è¯¢è¯éªå®¤ |
| | | * @param insOrderId |
| | | * @return |
| | | */ |
| | | String selectLaboratoryByOrderId(Integer insOrderId); |
| | | String selectLaboratoryByOrderId(@Param("insOrderId") Integer insOrderId); |
| | | |
| | | InsOrder selectFirstSubmit(Integer insSampleId); |
| | | InsOrder selectFirstSubmit(@Param("insSampleId") Integer insSampleId); |
| | | } |
| | |
| | | */ |
| | | public interface InsProductMapper extends BaseMapper<InsProduct> { |
| | | |
| | | int selectOrderManDay(Integer orderId); |
| | | int selectOrderManDay(@Param("orderId") Integer orderId); |
| | | |
| | | Map<String, String> selectUserById(Integer userId); |
| | | Map<String, String> selectUserById(@Param("userId") Integer userId); |
| | | |
| | | List<ProductResultDto2> getProductAndResult(Integer sampleId); |
| | | List<ProductResultDto2> getProductAndResult(@Param("sampleId") Integer sampleId); |
| | | |
| | | int updateInspected(@Param("id") Integer id); |
| | | |
| | | List<InsProduct> selectFiberInsProduct(List<Integer> ids, String laboratory); |
| | | List<InsProduct> selectFiberInsProduct(@Param("ids") List<Integer> ids, @Param("laboratory") String laboratory); |
| | | |
| | | IPage<InsProduct> selectNoProducts(Page page, Integer orderId, List<Integer> noIds); |
| | | IPage<InsProduct> selectNoProducts(@Param("page") Page page, @Param("orderId") Integer orderId, @Param("noIds") List<Integer> noIds); |
| | | |
| | | int selectInsProductCountByOrderId(Integer orderId); |
| | | int selectInsProductCountByOrderId(@Param("orderId") Integer orderId); |
| | | |
| | | /** |
| | | * æ ¹æ®æ ·åidæ¥è¯¢æ£éªé¡¹ç® |
| | |
| | | * @param orderId |
| | | * @return |
| | | */ |
| | | List<String> selectUnqualifiedList(Integer orderId); |
| | | List<String> selectUnqualifiedList(@Param("orderId") Integer orderId); |
| | | |
| | | /** |
| | | * æ¥è¯¢å¤ææ¯å¦æä¸å¤å®é¡¹ç®,åå
¨é½æ¯å¤å®é¡¹ |
| | | * @param orderId |
| | | * @return |
| | | */ |
| | | int selectNoJudge(Integer orderId); |
| | | int selectNoJudge(@Param("orderId") Integer orderId); |
| | | } |
| | | |
| | | |
| | |
| | | * @param orderId |
| | | * @return |
| | | */ |
| | | List<InsProductResult> selectResultByOrderId(Integer orderId); |
| | | List<InsProductResult> selectResultByOrderId(@Param("orderId") Integer orderId); |
| | | } |
| | | |
| | | |
| | |
| | | @Param("queryStatus") String queryStatus, |
| | | @Param("createOrderUser") Integer createOrderUser); |
| | | |
| | | String getLaboratoryByName(String name, String type); |
| | | String getLaboratoryByName(@Param("name") String name, @Param("type") String type); |
| | | |
| | | } |
| | | |
| | |
| | | |
| | | IPage<InsOrderPlanTaskSwitchVo> inspectionOrderDetailsTaskSwitching(Page page, @Param("ew") QueryWrapper<InsOrderPlanDTO> ew, @Param("userId") Integer userId, @Param("sonLaboratory") String sonLaboratory, @Param("laboratory") String laboratory); |
| | | |
| | | List<SampleProductDto> selectSampleProductListByOrderId(Integer id); |
| | | List<SampleProductDto> selectSampleProductListByOrderId(@Param("id") Integer id); |
| | | |
| | | List<SampleProductDto> selectSampleProductListByOrderId2(Integer id); |
| | | List<SampleProductDto> selectSampleProductListByOrderId2(@Param("id") Integer id); |
| | | |
| | | Map<String,Object> selectInsOrder(Integer id); |
| | | Map<String,Object> selectInsOrder(@Param("id") Integer id); |
| | | |
| | | List<SampleProductDto> getInsOrderAndSample(Integer id, String laboratory); |
| | | List<SampleProductDto> getInsOrderAndSample(@Param("id") Integer id, @Param("laboratory") String laboratory); |
| | | |
| | | String getSampleEn(String sample); |
| | | String getSampleEn(@Param("sample") String sample); |
| | | |
| | | /** |
| | | * å¯è½æ²¡æäº§åç´æ¥å°±æ¯å¯¹è±¡ |
| | | * @param sample |
| | | * @return |
| | | */ |
| | | String getSampleEnByObject(String sample); |
| | | String getSampleEnByObject(@Param("sample") String sample); |
| | | |
| | | /** |
| | | * æ ·å |
| | |
| | | * @param laboratory |
| | | * @return |
| | | */ |
| | | List<InsProduct> getInsProduct1(Integer id, String laboratory, String cableTag, String repetitionTag, String isDisqualification); |
| | | List<InsProduct> getInsProduct1(@Param("id") Integer id, @Param("laboratory") String laboratory, @Param("cableTag") String cableTag, @Param("repetitionTag") String repetitionTag, @Param("isDisqualification") String isDisqualification); |
| | | |
| | | |
| | | /** |
| | |
| | | * @param rawMaterialTag |
| | | * @return |
| | | */ |
| | | List<InsProduct> getInsProduct6(Integer id, String laboratory, String rawMaterialTag, String isDisqualification); |
| | | List<InsProduct> getInsProduct6(@Param("id") Integer id, @Param("laboratory") String laboratory, @Param("rawMaterialTag") String rawMaterialTag, @Param("isDisqualification") String isDisqualification); |
| | | |
| | | SampleVo getDetailById(Integer sampleId); |
| | | SampleVo getDetailById(@Param("sampleId") Integer sampleId); |
| | | |
| | | String selMethodById(Integer sampleId); |
| | | String selMethodById(@Param("sampleId") Integer sampleId); |
| | | |
| | | /** |
| | | * çµç¼é
ç½®æ¥çé
ç½®æ è¯ |
| | |
| | | List<Map<String, Object>> getRepetitionTag(@Param("id") Integer id, @Param("laboratory") String laboratory, @Param("cableTag") String cableTag); |
| | | |
| | | |
| | | List<SampleProductDto> selectExemptionByOrderId(Integer id); |
| | | List<SampleProductDto> selectExemptionByOrderId(@Param("id") Integer id); |
| | | |
| | | /** |
| | | * æ¥è¯¢åå®¶å¯åº¦(æåå·) |
| | |
| | | * @param itemIds |
| | | * @return |
| | | */ |
| | | List<InsProduct> selectProductResult(List<Integer> itemIds); |
| | | List<InsProduct> selectProductResult(@Param("itemIds") List<Integer> itemIds); |
| | | } |
| | | |
| | | |
| | |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import com.ruoyi.inspect.dto.UnPassPageDto; |
| | | import com.ruoyi.inspect.pojo.InsUnPass; |
| | | import org.apache.ibatis.annotations.Param; |
| | | |
| | | /** |
| | | * @author æ±ä½³å |
| | | * @date 2024/5/8 13:05 |
| | | */ |
| | | public interface InsUnPassMapper extends BaseMapper<InsUnPass> { |
| | | IPage<UnPassPageDto> pageInsUnPass(IPage<UnPassPageDto> page, QueryWrapper<UnPassPageDto> ew); |
| | | IPage<UnPassPageDto> pageInsUnPass(@Param("page") IPage<UnPassPageDto> page, @Param("ew") QueryWrapper<UnPassPageDto> ew); |
| | | } |
| | |
| | | |
| | | IPage<UnqualifiedHandlerVO> selectPageList(IPage<UnqualifiedHandlerVO> page, @Param("ew")QueryWrapper<UnqualifiedHandlerDto> ew); |
| | | |
| | | UnqualifiedHandlerVO findById(Long id); |
| | | UnqualifiedHandlerVO findById(@Param("id") Long id); |
| | | |
| | | /** |
| | | * æ¥çoaæµç¨ |
| | |
| | | import com.ruoyi.inspect.pojo.InsProduct; |
| | | import com.ruoyi.inspect.pojo.InsUnqualifiedRetestProduct; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | import org.apache.ibatis.annotations.Param; |
| | | |
| | | import java.util.List; |
| | | |
| | |
| | | * @param ids |
| | | * @return |
| | | */ |
| | | List<InsUnqualifiedRetestProduct> selectRetestProduct(List<Integer> ids); |
| | | List<InsUnqualifiedRetestProduct> selectRetestProduct(@Param("ids") List<Integer> ids); |
| | | |
| | | // æ ·å |
| | | List<InsProduct> getInsProductUnqualifiedRetest1(Integer id, String laboratory, String retestTag); |
| | | List<InsProduct> getInsProductUnqualifiedRetest1(@Param("id") Integer id, @Param("laboratory") String laboratory, @Param("retestTag") String retestTag); |
| | | |
| | | // çµç¼é
ç½® |
| | | List<InsProduct> getInsProductUnqualifiedRetest5(Integer id, String laboratory, String cableTag, String retestTag); |
| | | List<InsProduct> getInsProductUnqualifiedRetest5(@Param("id") Integer id, @Param("laboratory") String laboratory, @Param("cableTag") String cableTag, @Param("retestTag") String retestTag); |
| | | |
| | | // åææä¸å |
| | | List<InsProduct> getInsProductUnqualifiedRetest6(Integer id, String laboratory, String rawMaterialTag, String retestTag); |
| | | List<InsProduct> getInsProductUnqualifiedRetest6(@Param("id") Integer id, @Param("laboratory") String laboratory, @Param("rawMaterialTag") String rawMaterialTag, @Param("retestTag") String retestTag); |
| | | } |
| | | |
| | |
| | | private Integer id; |
| | | |
| | | /** |
| | | * å¤é®ï¼æ£éªæ ·åins_sample表id |
| | | * å¤é®ï¼æ¯è®¢åinsOrder表id (????) |
| | | */ |
| | | private Integer insSampleId; |
| | | |
| | |
| | | //ä¿®æ¹æ£éªä¸åæ°æ® |
| | | int upInsOrder(Integer orderId,Integer sampleId, String appointed, Integer userId,String sonLaboratory); |
| | | |
| | | int addInsOrder(List<SampleProductDto> list, InsOrder insOrder, List<List<Integer>> pairing); |
| | | int addInsOrder(List<SampleProductDto> list, InsOrder insOrder); |
| | | |
| | | Map<String, Object> getInsOrder(Integer id); |
| | | |
| | |
| | | isOrderAll = "1"; |
| | | sampleOrderDto.setState(null); |
| | | } |
| | | IPage<SampleOrderDto> sampleOrderDtoIPage = insOrderMapper.selectInsOrderPage(page, QueryWrappers.queryWrappers(sampleOrderDto), laboratory, isOrderAll); |
| | | return insOrderMapper.selectInsOrderPage(page, QueryWrappers.queryWrappers(sampleOrderDto), laboratory, isOrderAll); |
| | | } |
| | | |
| | |
| | | |
| | | @Override |
| | | @Transactional(rollbackFor = Exception.class) |
| | | public int addInsOrder(List<SampleProductDto> list, InsOrder insOrder, List<List<Integer>> pairing) { |
| | | public int addInsOrder(List<SampleProductDto> list, InsOrder insOrder) { |
| | | // todo: ä¸åå¤ææ½æ ·è®¡åçå¯ä¸æ§ |
| | | if (insOrder.getQuarterItemId() != null) { |
| | | Long quarterItemCount = insOrderMapper.selectCount(Wrappers.<InsOrder>lambdaQuery() |
| | |
| | | throw new ErrorException("è¯¥æ½æ ·è®¡å已被ç»å®è¿"); |
| | | } |
| | | } |
| | | |
| | | insOrder.setState(0); |
| | | |
| | | LocalDate appointed = insOrder.getAppointed(); |
| | |
| | | import java.time.format.DateTimeFormatter; |
| | | import java.util.*; |
| | | import java.util.concurrent.atomic.AtomicInteger; |
| | | import java.util.stream.Collectors; |
| | | |
| | | /** |
| | | * @Author zhuo |
| | |
| | | throw new ErrorException("é¶ä»¶å·ä¸º" + partNo + "çåæææ²¡æå¯¹åºçæ ååºé
ç½®"); |
| | | } |
| | | RawMaterialStandardTreeDto rawMaterialStandardTreeDto = new RawMaterialStandardTreeDto(); |
| | | Set<String> sampleTypeValues = new HashSet<>(); |
| | | for (FactoryDto factoryDto : factoryDtos) { |
| | | for (LaboratoryDto laboratoryDto : factoryDto.getChildren()) { |
| | | for (SampleTypeDto sampleTypeDto : laboratoryDto.getChildren()) { |
| | | if (sampleTypeDto.getChildren().size() == 0) { |
| | | sampleTypeDto.setChildren(standardTreeMapper.getStandardTree3(sampleTypeDto.getValue())); |
| | | sampleTypeValues.add(sampleTypeDto.getValue()); |
| | | } |
| | | } |
| | | } |
| | | } |
| | | // æ¹éæ¥è¯¢ææ sampleTypeDto çæ°æ® |
| | | List<SampleDto> standardList = standardTreeMapper.getStandardTree3Batch(sampleTypeValues); |
| | | Map<String, List<SampleDto>> standardTreeMap = standardList.stream().collect(Collectors.groupingBy(SampleDto::getValue)); |
| | | |
| | | for (FactoryDto factoryDto : factoryDtos) { |
| | | for (LaboratoryDto laboratoryDto : factoryDto.getChildren()) { |
| | | for (SampleTypeDto sampleTypeDto : laboratoryDto.getChildren()) { |
| | | List<SampleDto> standardTreeList = standardTreeMap.get(sampleTypeDto.getValue()); |
| | | if (sampleTypeDto.getChildren().size() == 0) { |
| | | sampleTypeDto.getChildren().addAll(standardTreeList); |
| | | } |
| | | // 夿ç»å®çæ¯å¦æ¯å½åé¶ä»¶å· |
| | | if (sampleTypeDto.getPartNo() != null && sampleTypeDto.getPartNo().equals(partNo)) { |
| | |
| | | } |
| | | |
| | | |
| | | |
| | | |
| | | /** |
| | | * éåä¸ä¸åå
æ£ |
| | | * @param list |
| | |
| | | @Resource |
| | | private UserService userService; |
| | | |
| | | /** |
| | | * type : 1: è·åæ£æµäººåä¿¡æ¯ |
| | | * @param user |
| | | * @param type |
| | | * @return |
| | | */ |
| | | @ApiOperation(value = "æ ¹æ®æ¡ä»¶è·åç¨æ·å表") |
| | | @GetMapping("/selectUserCondition") |
| | | public Result selectUserCondition(User user, String type){ |
| | | return Result.success(userService.selectUserCondition(user, type)); |
| | | } |
| | | |
| | | /** |
| | | * è·åå½åç»å½ç客æ·ä¿¡æ¯ |
| | | * @return |
| | | */ |
| | | @GetMapping("/getUserNow") |
| | | @ApiOperation(value = "è·åå½åç»å½ç客æ·ä¿¡æ¯") |
| | | public Result<?> getUserNow(){ |
| | | return Result.success(userService.getUserNow()); |
| | | } |
| | | |
| | | } |
| | | |
| | |
| | | userId = SecurityUtils.getUserId().intValue(); |
| | | } catch (Exception ignored) { |
| | | } |
| | | System.out.println("æ§è¡æå
¥å¡«å
..."); |
| | | this.strictInsertFill(metaObject, "createTime", LocalDateTime.class, LocalDateTime.now()); |
| | | this.strictInsertFill(metaObject, "updateTime", LocalDateTime.class, LocalDateTime.now()); |
| | | this.strictInsertFill(metaObject, "createUser", Integer.class, userId); |
| | |
| | | * @return |
| | | */ |
| | | List<Map<String, String>> selectNameAnddepartment(@Param("participant") String participant); |
| | | |
| | | /** |
| | | * è·åå½åç»å½ç客æ·ä¿¡æ¯ |
| | | * @param userId |
| | | * @return |
| | | */ |
| | | User getUserNow(@Param("userId") int userId); |
| | | } |
| | | |
| | |
| | | * @return |
| | | */ |
| | | List<User> selectUserCondition(User user, String type); |
| | | |
| | | /** |
| | | * è·åå½åç»å½ç客æ·ä¿¡æ¯ |
| | | * @return |
| | | */ |
| | | User getUserNow(); |
| | | } |
| | | |
| | |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | import com.ruoyi.common.core.domain.entity.User; |
| | | import com.ruoyi.common.utils.QueryWrappers; |
| | | import com.ruoyi.common.utils.SecurityUtils; |
| | | import com.ruoyi.system.mapper.UserMapper; |
| | | import com.ruoyi.system.service.UserService; |
| | | import org.springframework.stereotype.Service; |
| | |
| | | public List<User> selectUserCondition(User user, String type) { |
| | | return baseMapper.selectUserCondition(QueryWrappers.queryWrappers(user), type); |
| | | } |
| | | |
| | | /** |
| | | * è·åå½åç»å½ç客æ·ä¿¡æ¯ |
| | | * @return |
| | | */ |
| | | @Override |
| | | public User getUserNow() { |
| | | return baseMapper.getUserNow(SecurityUtils.getUserId().intValue()); |
| | | } |
| | | } |
| | | |
| | |
| | | left join department_lims dl on find_in_set(dl.id, u.depart_lims_id) and dl.id != 1 |
| | | where find_in_set(u.id, #{participant}) |
| | | </select> |
| | | |
| | | <!-- è·åå½åç»å½ç¨æ·ä¿¡æ¯ --> |
| | | <select id="getUserNow" resultType="com.ruoyi.common.core.domain.entity.User"> |
| | | select u.id, |
| | | c.company, |
| | | u.name, |
| | | c.code, |
| | | u.phone, |
| | | c.id departId |
| | | from user u |
| | | left join custom c on u.company = c.id |
| | | where u.id = #{userId} |
| | | </select> |
| | | </mapper> |