sop查询

lxw

2023-06-21 65bedd623765cb52757fe842b888771767b349df

sop查询

 src/main/java/com/whyc/controller/SOPController.java

@@ -1,6 +1,7 @@
package com.whyc.controller;

import com.whyc.dto.Response;
import com.whyc.dto.SopDto;
import com.whyc.pojo.SOP;
import com.whyc.service.SOPService;
import io.swagger.annotations.Api;
@@ -12,6 +13,8 @@

import java.io.IOException;
import java.text.ParseException;
import java.util.List;
import java.util.Map;

@RequestMapping("sop")
@RestController
@@ -40,4 +43,10 @@
    public Response add(@RequestBody SOP sop) {
        return service.add(sop);
    }

    @ApiOperation("查询sop信息")
    @PostMapping("getSopInfo")
    public Response getSopInfo(@RequestBody(required = false) List<SopDto> list, @RequestParam(required = false) String code, @RequestParam(required = false) String model) {
        return service.getSopInfo(list,code,model);
    }
}

 src/main/java/com/whyc/dto/SopDto.java

New file
@@ -0,0 +1,11 @@
package com.whyc.dto;

import lombok.Data;

import java.util.ArrayList;

@Data
public class SopDto {
    private String  parentType;
    private ArrayList chileType;
}

 src/main/java/com/whyc/mapper/SOPMapper.java

@@ -1,6 +1,13 @@
package com.whyc.mapper;

import com.whyc.pojo.SOP;
import org.apache.ibatis.annotations.Param;
import org.springframework.beans.factory.annotation.Value;

import java.util.List;

public interface SOPMapper extends CustomMapper<SOP> {

    //查询sop信息
    List<SOP> getSopInfo(@Param("sqlStr") String sqlStr, @Param("code") String code, @Param("model") String model);
}

 src/main/java/com/whyc/service/SOPService.java

@@ -1,6 +1,7 @@
package com.whyc.service;

import com.whyc.dto.Response;
import com.whyc.dto.SopDto;
import com.whyc.mapper.SOPMapper;
import com.whyc.pojo.SOP;
import com.whyc.pojo.SOPProduct;
@@ -17,6 +18,7 @@
import java.util.Date;
import java.util.LinkedList;
import java.util.List;
import java.util.Map;
import java.util.stream.Collectors;

@Service
@@ -150,4 +152,20 @@
    public Response add(SOP sop) {
        return null;
    }

    //查询sop信息
    public Response getSopInfo(List<SopDto> sqlList, String code, String model) {
        String sqlStr=" ";
        if(sqlList!=null&&sqlList.size()>0){
            for (SopDto dto:sqlList) {
                if(dto.getChileType().size()>0){
                    for (int i=0;i<dto.getChileType().size();i++){
                        sqlStr+=" and file_type like "+"'%"+dto.getParentType()+"%' ";
                    }
                }
            }
        }
        List<SOP> list=mapper.getSopInfo(sqlStr,code,model);
        return new Response().setII(1,list.size()>0,list,"查询sop信息");
    }
}

 src/main/resources/mapper/SOPMapper.xml

New file
@@ -0,0 +1,30 @@
<?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.whyc.mapper.SOPMapper">

    <resultMap id="sopList" type="sop">
        <id property="id" column="id"></id>
        <result property="fileName" column="file_name"></result>
        <result property="fileType" column="file_type"></result>
        <result property="fileVersion" column="file_version"></result>
        <result property="fileRelatedVersion" column="file_related_version"></result>
        <result property="editor" column="editor"></result>
        <result property="auditor" column="auditor"></result>
        <result property="releaseDate" column="release_date"></result>
        <result property="releaseNotes" column="release_notes"></result>
        <result property="createTime" column="create_time"></result>
        <result property="uploadUser" column="upload_user"></result>
        <collection property="sopProductList" ofType="sOPProduct">
            <id column="id" property="id"/>
            <result column="code" property="code"/>
            <result column="model" property="model"/>
            <result column="sop_id" property="sopId"/>
        </collection>
    </resultMap>
    <select id="getSopInfo" resultMap="sopList">
        select * from tb_sop,tb_sop_product
        where tb_sop.id=tb_sop_product.sop_id
        and code LIKE '%${code}%' and model like '%${model}%'
        ${sqlStr}
    </select>
</mapper>