From af607e09de61badbaef57bc0d38002e48a44ac4c Mon Sep 17 00:00:00 2001 From: 李宇 <986321569@qq.com> Date: 星期五, 12 十一月 2021 12:48:50 +0800 Subject: [PATCH] 订单领取申领人被删除报错 --- src/main/java/com/nanometer/smartlab/service/SysUserServiceImpl.java | 49 ++++++++++++++++++++++++++++++++++++++++++++----- 1 files changed, 44 insertions(+), 5 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..9ddbbac 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. @@ -194,10 +192,11 @@ } @Override - public List<SysUser> getHasProjectSysUserList(String department) { + public List<SysUser> getHasProjectSysUserList(String department, String project) { try { Map<String, Object> params = new HashMap<String, Object>(); params.put("department", department); + params.put("project", project); params.put("approverFlag", ApproverFlag.YES); return this.sysUserDao.getHasProjectSysUserList(params); } catch (DataAccessException e) { @@ -396,5 +395,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