| | |
| | | @ApiModelProperty(value = "计量单位") |
| | | private String unit; |
| | | |
| | | @ValueTableShow(15) |
| | | @ValueTableShow(18) |
| | | @ApiModelProperty(value = "试验方法") |
| | | private String method; |
| | | |
| | |
| | | @ApiModelProperty(value = "字典类型") |
| | | private String dic; |
| | | |
| | | @ValueTableShow(16) |
| | | @ApiModelProperty(value = "检验项分类") |
| | | private String inspectionItemClass; |
| | | |
| | | @ValueTableShow(17) |
| | | @ApiModelProperty(value = "检验项分类EN") |
| | | private String inspectionItemClassEn; |
| | | |
| | | } |
| | | |
| | |
| | | template_id, |
| | | son_laboratory, |
| | | ask, |
| | | ask_tell |
| | | ask_tell, |
| | | inspection_item_class, |
| | | inspection_item_class_en |
| | | from structure_item_parameter |
| | | <if test="ew.customSqlSegment != null and ew.customSqlSegment != ''"> |
| | | ${ew.customSqlSegment} |
| | |
| | | |
| | | int updateInspected(@Param("id") Integer id); |
| | | |
| | | List<InsProduct> selectFiberInsProduct(List<Integer> ids); |
| | | List<InsProduct> selectFiberInsProduct(List<Integer> ids, String laboratory); |
| | | } |
| | | |
| | | |
| | |
| | | /** |
| | | * 检验项分类 |
| | | */ |
| | | private String inspectionItemClassify; |
| | | @ApiModelProperty(value = "检验项分类") |
| | | private String inspectionItemClass; |
| | | |
| | | @ApiModelProperty(value = "检验项分类EN") |
| | | private String inspectionItemClassEn; |
| | | |
| | | /** |
| | | * 检验项子类 |
| | |
| | | private String tree; |
| | | |
| | | private Integer structureItemParameterId; |
| | | |
| | | @ApiModelProperty(value = "检验项分类") |
| | | private String inspectionItemClass; |
| | | |
| | | @ApiModelProperty(value = "检验项分类EN") |
| | | private String inspectionItemClassEn; |
| | | } |
| | |
| | | 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).isNull(InsProduct::getInsResult).isNull(InsProduct::getInsFiberId).isNull(InsProduct::getInsFibersId)); |
| | | insProducts.addAll(insProductMapper.selectFiberInsProduct(ids)); |
| | | insProducts.addAll(insProductMapper.selectFiberInsProduct(ids, laboratory)); |
| | | if (insProducts.size() > 0) { |
| | | String str = ""; |
| | | int count = 0; |
| | |
| | | where state = 1 |
| | | and (ins_fibers_id is not null or ins_fiber_id is not null) |
| | | and ins_result is null |
| | | and son_laboratory = #{laboratory} |
| | | and ins_sample_id in |
| | | <foreach collection="list" index="index" item="item" open="(" separator="," close=")"> |
| | | <foreach collection="ids" index="index" item="item" open="(" separator="," close=")"> |
| | | #{item} |
| | | </foreach> |
| | | </select> |
| | |
| | | ip.id ip_id, |
| | | inspection_item, |
| | | inspection_item_en, |
| | | inspection_item_classify, |
| | | inspection_item_class, |
| | | inspection_item_class_en, |
| | | inspection_item_subclass, |
| | | inspection_item_subclass_en, |
| | | ip.factory ip_factory, |
| | |
| | | ip.id ip_id, |
| | | inspection_item, |
| | | inspection_item_en, |
| | | inspection_item_classify, |
| | | inspection_item_class, |
| | | inspection_item_class_en, |
| | | inspection_item_subclass, |
| | | inspection_item_subclass_en, |
| | | ip.factory ip_factory, |
| | |
| | | ip.id ip_id, |
| | | inspection_item, |
| | | inspection_item_en, |
| | | inspection_item_classify, |
| | | inspection_item_subclass, |
| | | inspection_item_subclass_en, |
| | | inspection_item_class, |
| | | inspection_item_class_en, |
| | | ip.factory ip_factory, |
| | | ip.laboratory ip_laboratory, |
| | | ip.sample_type ip_sample_type, |
| | |
| | | select ip.id ip_id, |
| | | inspection_item, |
| | | inspection_item_en, |
| | | inspection_item_classify, |
| | | inspection_item_subclass, |
| | | inspection_item_subclass_en, |
| | | ip.factory ip_factory, |
| | |
| | | select ip.id ip_id, |
| | | inspection_item, |
| | | inspection_item_en, |
| | | inspection_item_classify, |
| | | inspection_item_class, |
| | | inspection_item_class_en, |
| | | inspection_item_subclass, |
| | | inspection_item_subclass_en, |
| | | ip.factory ip_factory, |
| | |
| | | select ip.id ip_id, |
| | | inspection_item, |
| | | inspection_item_en, |
| | | inspection_item_classify, |
| | | inspection_item_class, |
| | | inspection_item_class_en, |
| | | inspection_item_subclass, |
| | | inspection_item_subclass_en, |
| | | ip.factory ip_factory, |
| | |
| | | <id property="id" column="ip_id" jdbcType="INTEGER"/> |
| | | <result property="inspectionItem" column="inspection_item" jdbcType="VARCHAR"/> |
| | | <result property="inspectionItemEn" column="inspection_item_en" jdbcType="VARCHAR"/> |
| | | <result property="inspectionItemClassify" column="inspection_item_classify" jdbcType="VARCHAR"/> |
| | | <result property="inspectionItemSubclass" column="inspection_item_subclass" jdbcType="VARCHAR"/> |
| | | <result property="inspectionItemSubclassEn" column="inspection_item_subclass_en" jdbcType="VARCHAR"/> |
| | | <result property="inspectionItemClass" column="inspection_item_class" jdbcType="VARCHAR"/> |
| | | <result property="inspectionItemClassEn" column="inspection_item_class_en" jdbcType="VARCHAR"/> |
| | | <result property="factory" column="ip_factory" jdbcType="VARCHAR"/> |
| | | <result property="laboratory" column="ip_laboratory" jdbcType="VARCHAR"/> |
| | | <result property="sampleType" column="ip_sample_type" jdbcType="VARCHAR"/> |
| | |
| | | inspection_item_en, |
| | | inspection_item_subclass, |
| | | inspection_item_subclass_en, |
| | | inspection_item_class, |
| | | inspection_item_class_en, |
| | | method, |
| | | son_laboratory, |
| | | unit, |
| | |
| | | inspection_item_en, |
| | | inspection_item_subclass, |
| | | inspection_item_subclass_en, |
| | | inspection_item_class, |
| | | inspection_item_class_en, |
| | | method, |
| | | son_laboratory, |
| | | unit, |
| | |
| | | inspection_item_en, |
| | | inspection_item_subclass, |
| | | inspection_item_subclass_en, |
| | | inspection_item_class, |
| | | inspection_item_class_en, |
| | | method, |
| | | son_laboratory, |
| | | unit, |