获取实验室列表

gaoaoy

2024-02-29 7bff21359fa325c7d3f1049cbed6039903b8cadf

获取实验室列表

 cnas-server/src/main/java/com/yuanchu/mom/controller/LaboratoryController.java

@@ -52,5 +52,13 @@
    public Result<?> upParameter(@RequestBody Laboratory itemParameter) {
        return Result.success(laboratoryService.upParameter(itemParameter));
    }

    @ApiOperation(value = "获取实验室名称")
    @PostMapping("/obtainItemParameterList")
    public Result obtainItemParameterList(@RequestBody Map<String, Object> data) throws Exception {
        Page page = JackSonUtil.unmarshal(JackSonUtil.marshal(data.get("page")), Page.class);
        Laboratory itemParameter = JackSonUtil.unmarshal(JackSonUtil.marshal(data.get("entity")), Laboratory.class);
        return Result.success(laboratoryService.obtainItemParameterList(page, itemParameter));
    }
}


 cnas-server/src/main/java/com/yuanchu/mom/mapper/LaboratoryMapper.java

@@ -12,5 +12,7 @@
public interface LaboratoryMapper extends BaseMapper<Laboratory> {

    IPage<Laboratory> selectItemParameter(Page page, QueryWrapper<Laboratory> ew);

    Object obtainItemParameterList(Page page, QueryWrapper<Laboratory> queryWrappers);
}


 cnas-server/src/main/java/com/yuanchu/mom/service/LaboratoryService.java

@@ -18,5 +18,7 @@
    int delParameter(Integer id);

    int upParameter(Laboratory itemParameter);

    Map<String, Object> obtainItemParameterList(Page page, Laboratory itemParameter);
}


 cnas-server/src/main/java/com/yuanchu/mom/service/impl/LaboratoryServiceImpl.java

@@ -49,5 +49,15 @@
    public int upParameter(Laboratory itemParameter) {
        return laboratoryMapper.updateById(itemParameter);
    }

    @Override
    public Map<String, Object> obtainItemParameterList(Page page, Laboratory itemParameter) {
        Map<String, Object> map = new HashMap<>();
        map.put("head", PrintChina.printChina(Laboratory.class));
        Map<String, Integer> map1 = getLook.selectPowerByMethodAndUserId("obtainItemParameterList");
        if(map1.get("look")==1) itemParameter.setCreateUser(map1.get("userId"));
        map.put("body", laboratoryMapper.obtainItemParameterList(page, QueryWrappers.queryWrappers(itemParameter)));
        return map;
    }
}


 cnas-server/src/main/resources/mapper/LaboratoryMapper.xml

@@ -23,4 +23,20 @@
            ${ew.customSqlSegment}
        </if>
    </select>

    <select id="obtainItemParameterList" resultType="java.lang.Object">
        select * from
            (
                select l.id,
                       laboratory_name,
                       laboratory_number,
                       phone_number,
                       head,
                       address,
                       u1.name create_user_name,
                       l.create_time
                from laboratory l
                         left join user u1 on l.create_user = u1.id
            ) a
    </select>
</mapper>