From c3510da29a7974c6af7ff3de1ade3db429d6f848 Mon Sep 17 00:00:00 2001 From: 李宇 <986321569@qq.com> Date: 星期三, 18 八月 2021 14:27:59 +0800 Subject: [PATCH] 申购管理申请履历显示所有历史单据,提交时如有无效试剂耗材报错 --- src/main/java/com/nanometer/smartlab/service/SysUserServiceImpl.java | 46 ++++++++++++++++++++++++++++++++++++++++++---- 1 files changed, 42 insertions(+), 4 deletions(-) diff --git a/src/main/java/com/nanometer/smartlab/service/SysUserServiceImpl.java b/src/main/java/com/nanometer/smartlab/service/SysUserServiceImpl.java index 1b81ddc..aa11981 100644 --- a/src/main/java/com/nanometer/smartlab/service/SysUserServiceImpl.java +++ b/src/main/java/com/nanometer/smartlab/service/SysUserServiceImpl.java @@ -13,6 +13,7 @@ import com.nanometer.smartlab.exception.AlarmException; import com.nanometer.smartlab.exception.BusinessException; import com.nanometer.smartlab.exception.ExceptionEnumCode; +import com.nanometer.smartlab.util.ExcelUtils; import com.nanometer.smartlab.util.FacesUtils; import com.nanometer.smartlab.util.IDUtils; import com.nanometer.smartlab.util.MessageUtil; @@ -26,10 +27,7 @@ import org.springframework.transaction.annotation.Transactional; import javax.annotation.Resource; -import java.util.ArrayList; -import java.util.HashMap; -import java.util.List; -import java.util.Map; +import java.util.*; /** * Created by johnny on 17/11/20. @@ -396,5 +394,45 @@ return sysUserDao.getUserByArp(arp); } + @Override + public List<Map> getExportUserList(String arp, String name, String departmentName, String project, String company) { + return sysUserDao.getExportUserList(arp, name, departmentName, project, company); + } + + @Override + public void exportUser2Excel(List<Map> list)throws Exception { + Map<String, String> map = new LinkedHashMap<>(); + map.put("companyName", "单位"); + map.put("departmentName", "部门"); + map.put("project", "课题组"); + map.put("arp", "ARP"); + map.put("name", "姓名"); + map.put("account", "账号"); + map.put("idCard", "ID卡号"); + map.put("phone", "电话"); + map.put("email", "邮箱"); + map.put("memo", "备注"); + map.put("roleName", "角色"); + map.put("approver", "审批者"); + map.put("seeName", "可见度"); + map.put("wasterName", "危废人员"); + map.put("updateTime", "更新时间"); + ExcelUtils.export2Excel(list,"人员信息",map); + } + + + //获取库管员邮箱 + @Override + public List<String> getLibrarianEmail() { + return sysUserDao.getLibrarianEmail(); + } + + @Override + public SysUser getUserByName(String approveUserName) { + List<SysUser> users = sysUserDao.getUserByName(approveUserName); + if (users.size() != 1) return null; + return users.get(0); + } + } -- Gitblit v1.9.2