Merge branch 'radio_frequency' of http://114.132.189.42:9002/r/lims-ruoyi-after into radio_frequency
| | |
| | | // 对象英文 |
| | | private String sampleTypeEn; |
| | | |
| | | private String workShopName; |
| | | |
| | | private Integer workShopId; |
| | | |
| | | private List<SampleDto> children; |
| | | |
| | | } |
| | |
| | | |
| | | private String name; |
| | | |
| | | private String labelName; |
| | | |
| | | private List<ProductDto> children; |
| | | |
| | | } |
| | |
| | | // 对检测对象先按照实验室在按照检查对象类别分类 |
| | | List<BasicTreeDto> testProjectBasicTreeList = structureTestObjectList.stream().map(structureTestObject -> { |
| | | BasicTreeDto basicTreeDto = new BasicTreeDto(); |
| | | basicTreeDto.setValue(structureTestObject.getSpecimenName() + "(" + structureTestObject.getObjectType() + ")"); |
| | | basicTreeDto.setValue(structureTestObject.getSpecimenName()); |
| | | basicTreeDto.setLabel(structureTestObject.getSpecimenName() + "(" + structureTestObject.getObjectType() + ")"); |
| | | basicTreeDto.setLevel(BasicTreeEnums.STRUCTURE_TEST_OBJECT_TYPE.getCode()); |
| | | List<BasicTreeDto> children = new ArrayList<>(); |
| | |
| | | <result property="sort" column="sort"/> |
| | | <result property="partNo" column="part_no"/> |
| | | <result property="sampleTypeEn" column="sample_type_en"/> |
| | | <result property="workShopName" column="workShopName"/> |
| | | <result property="workShopId" column="workShopId"/> |
| | | <collection property="children" resultMap="SampleDto"/> |
| | | </resultMap> |
| | | |
| | |
| | | sto.id sample_type_id, |
| | | sto.sort, |
| | | sto.specimen_name_en sample_type_en, |
| | | p.name_en sample_en |
| | | p.name_en sample_en, |
| | | ws.`name` workShopName, |
| | | ws.id workShopId |
| | | from laboratory l |
| | | left join structure_test_object sto on sto.laboratory_id = l.id |
| | | left join product p on p.object_id = sto.id |
| | | left join standard_tree st on st.sample_type = sto.specimen_name |
| | | and st.sample = p.name |
| | | LEFT JOIN work_shop ws ON ws.id = sto.work_shop_id |
| | | order by l.id, CAST(sto.code AS DECIMAL), p.id, ISNULL(st.id), st.id |
| | | </select> |
| | | |
| | |
| | | l.laboratory_name laboratory, |
| | | sto.specimen_name sample_type, |
| | | p.name sample, |
| | | st.model, |
| | | m.model_name model, |
| | | ws.`name` workShopName, |
| | | ws.id workShopId, |
| | | CASE |
| | | WHEN p.id = (SELECT pp.product_id |
| | | FROM product_part pp |
| | |
| | | left join product p on p.object_id = sto.id |
| | | left join standard_tree st on st.sample_type = sto.specimen_name |
| | | and st.sample = p.name |
| | | LEFT JOIN model m ON m.product_id = p.id |
| | | LEFT JOIN work_shop ws ON ws.id = sto.work_shop_id |
| | | where (p.id = (select pp.product_id |
| | | from product_part pp |
| | | where pp.part_no = #{partNo}) |
| | |
| | | <select id="getItemTree" resultMap="itemDto"> |
| | | SELECT |
| | | sto.id AS sId, |
| | | sto.specimen_name AS labelName, |
| | | CONCAT(sto.specimen_name, ' (', sto.object_type, ')') AS sName, |
| | | p.id AS pId, |
| | | p.name AS pName, |
| | |
| | | <resultMap id="itemDto" type="com.ruoyi.basic.dto.TestItemDto"> |
| | | <result column="sId" property="id"/> |
| | | <result column="sName" property="name"/> |
| | | <result column="labelName" property="labelName"/> |
| | | <collection property="children" resultMap="productDto"/> |
| | | </resultMap> |
| | | <resultMap id="productDto" type="com.ruoyi.basic.dto.ProductDto"> |
| | |
| | | @ApiModelProperty("型号") |
| | | private List<ModelDto> children2; |
| | | |
| | | @ApiModelProperty("车间名称") |
| | | private String workShopName; |
| | | |
| | | @ApiModelProperty("车间id") |
| | | private Integer workShopId; |
| | | |
| | | } |
| | |
| | | rawMaterialStandardTreeDto.setLabel(sampleTypeDto.getLabel()); |
| | | rawMaterialStandardTreeDto.setValue(sampleTypeDto.getValue()); |
| | | rawMaterialStandardTreeDto.setChildren1(sampleTypeDto.getChildren()); |
| | | rawMaterialStandardTreeDto.setWorkShopName(sampleTypeDto.getWorkShopName()); |
| | | rawMaterialStandardTreeDto.setWorkShopId(sampleTypeDto.getWorkShopId()); |
| | | } else { |
| | | for (SampleDto sampleDto : sampleTypeDto.getChildren()) { |
| | | if (sampleDto.getPartNo() != null && sampleDto.getPartNo().equals(partNo)) { |
| | |
| | | rawMaterialStandardTreeDto.setLabel(sampleDto.getLabel()); |
| | | rawMaterialStandardTreeDto.setValue(sampleDto.getValue()); |
| | | rawMaterialStandardTreeDto.setChildren2(sampleDto.getChildren()); |
| | | rawMaterialStandardTreeDto.setWorkShopName(sampleTypeDto.getWorkShopName()); |
| | | rawMaterialStandardTreeDto.setWorkShopId(sampleTypeDto.getWorkShopId()); |
| | | } |
| | | } |
| | | } |