From a061540bf4c2bdb81edc3898cd27f4ba18512846 Mon Sep 17 00:00:00 2001 From: lyfO_o <764716047@qq.com> Date: 星期四, 22 四月 2021 11:47:43 +0800 Subject: [PATCH] 实验室库存导出 --- src/main/java/com/nanometer/smartlab/service/OpeReagentStatusServiceImpl.java | 43 +++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 43 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/nanometer/smartlab/service/OpeReagentStatusServiceImpl.java b/src/main/java/com/nanometer/smartlab/service/OpeReagentStatusServiceImpl.java index 8b14efa..b2245e9 100644 --- a/src/main/java/com/nanometer/smartlab/service/OpeReagentStatusServiceImpl.java +++ b/src/main/java/com/nanometer/smartlab/service/OpeReagentStatusServiceImpl.java @@ -11,6 +11,7 @@ import com.nanometer.smartlab.entity.*; import com.nanometer.smartlab.entity.dto.PersonUseDetail; import com.nanometer.smartlab.entity.enumtype.ValidFlag; +import com.nanometer.smartlab.util.ExcelUtils; import org.apache.commons.lang.StringUtils; import org.apache.log4j.Logger; import org.springframework.context.annotation.Lazy; @@ -1084,4 +1085,46 @@ } + /** + * @Description: 导出 + * @date 2021/4/22 10:33 + */ + @Override + public List<Map> selectExportList(String name, String articleNumber, Integer status, String reagentCode, String userId) { + + Map<String, Object> params = new HashMap<>(); + params.put("name", name); + params.put("articleNumber", articleNumber); + params.put("status", status); + if (StringUtils.isNotBlank(userId)) { + SysUser sysUser = sysUserService.getSysUser(userId); + BaseRole baseRole = baseRoleService.getBaseRole(sysUser.getRoleId()); + //不是系统管理员 根据用户的课题组判断可视(用户所在课题组是否 在实验室的课题组下) + if (!"系统管理员".equals(baseRole.getName())) { + if (StringUtils.isBlank(sysUser.getProject())) { + return null; + } + params.put("project", sysUser.getProject()); + } + } + params.put("reagentCode", reagentCode); + return opeReagentStatusDao.selectExportList(params); + } + + @Override + public void exportLabStock2Excel(List<Map> list) throws Exception { + Map<String, String> map = new LinkedHashMap<>(); + map.put("houseName", "实验室名称"); + map.put("containerCode", "临时存储库条码"); + map.put("reagentName", "试剂名称"); + map.put("reagentCode", "试剂条形码"); + map.put("articleNumber", "批号"); + map.put("cas", "cas"); + map.put("productHome", "厂家"); + map.put("supplierName", "供应商"); + map.put("remainder", "残存量"); + ExcelUtils.export2Excel(list,"实验室库存",map); + } + + } -- Gitblit v1.9.2