From 5e634c01ce9cb8294c6008a7ab76e5b82f469056 Mon Sep 17 00:00:00 2001
From: lyfO_o <764716047@qq.com>
Date: 星期一, 13 十二月 2021 16:12:18 +0800
Subject: [PATCH] 申购导出新增： 申购人的课题组，申购人的部门
---
src/main/java/com/nanometer/smartlab/controller/ApplyMngController.java | 16 +++++++++++-----
src/main/java/com/nanometer/smartlab/dao/OpeApplyDao.xml | 10 ++++++++++
src/main/java/com/nanometer/smartlab/entity/OpeApply.java | 18 ++++++++++++++++++
3 files changed, 39 insertions(+), 5 deletions(-)
diff --git a/src/main/java/com/nanometer/smartlab/controller/ApplyMngController.java b/src/main/java/com/nanometer/smartlab/controller/ApplyMngController.java
index d2bc3cd..848286f 100644
--- a/src/main/java/com/nanometer/smartlab/controller/ApplyMngController.java
+++ b/src/main/java/com/nanometer/smartlab/controller/ApplyMngController.java
@@ -259,6 +259,8 @@
headerList.add("试剂类型");
headerList.add("申购数量");
headerList.add("申购人");
+ headerList.add("申购人课题组");
+ headerList.add("申购人部门");
headerList.add("申购日期");
headerList.add("一级审批者");
headerList.add("二级审批者");
@@ -344,16 +346,20 @@
dataRow.createCell(10).setCellValue(dataList.get(i).getReagent().getReagentType()== null ? "": String.valueOf(baseMetaService.getBaseMetaValue(dataList.get(i).getReagent().getReagentType())));
dataRow.createCell(11).setCellValue(String.valueOf(dataList.get(i).getNum()));
dataRow.createCell(12).setCellValue(String.valueOf(dataList.get(i).getApplyUserName()));
- dataRow.createCell(13).setCellValue(String.valueOf(dataList.get(i).getCreateTime()));
+ dataRow.createCell(13).setCellValue(dataList.get(i).getApplyUserProject() == null?"":String.valueOf(dataList.get(i).getApplyUserProject()));
+ dataRow.createCell(14).setCellValue(dataList.get(i).getApplyUserDepartment() == null?"":String.valueOf(dataList.get(i).getApplyUserDepartment()));
+
+
+ dataRow.createCell(15).setCellValue(String.valueOf(dataList.get(i).getCreateTime()));
// SysUser u=sysUserService.getSysUser(dataList.get(i).getApproveUserId());
- dataRow.createCell(14).setCellValue(String.valueOf(dataList.get(i).getFirName()));
+ dataRow.createCell(16).setCellValue(String.valueOf(dataList.get(i).getFirName()));
if(dataList.get(i).getBeforeApproveUserId()!=null && !dataList.get(i).getBeforeApproveUserId().equals("")){
//u=sysUserService.getSysUser(dataList.get(i).getBeforeApproveUserId());
- dataRow.createCell(15).setCellValue(String.valueOf(dataList.get(i).getApproveUserName()));
+ dataRow.createCell(17).setCellValue(String.valueOf(dataList.get(i).getApproveUserName()));
}
//dataRow.createCell(14).setCellValue(String.valueOf(u.getName()));
- dataRow.createCell(16).setCellValue(String.valueOf(dataList.get(i).getStatus().getText()));
- dataRow.createCell(17).setCellValue(dataList.get(i).getMemo()==null ?"":String.valueOf(dataList.get(i).getMemo()));
+ dataRow.createCell(18).setCellValue(String.valueOf(dataList.get(i).getStatus().getText()));
+ dataRow.createCell(19).setCellValue(dataList.get(i).getMemo()==null ?"":String.valueOf(dataList.get(i).getMemo()));
}
return hssfWorkbook;
diff --git a/src/main/java/com/nanometer/smartlab/dao/OpeApplyDao.xml b/src/main/java/com/nanometer/smartlab/dao/OpeApplyDao.xml
index 56a1cff..5f262f3 100644
--- a/src/main/java/com/nanometer/smartlab/dao/OpeApplyDao.xml
+++ b/src/main/java/com/nanometer/smartlab/dao/OpeApplyDao.xml
@@ -19,6 +19,8 @@
<result property="beforeApproveUserId" column="before_approve_user_id"></result>
<result property="memo" column="memo"></result>
<result property="applyUserName" column="applyUserName"></result>
+ <result property="applyUserProject" column="applyUserProject"></result>
+ <result property="applyUserDepartment" column="applyUserDepartment"></result>
<result property="approveUserName" column="approveUserName"></result>
<result property="startReagentCode" column="start_reagent_code"></result>
<result property="endReagentCode" column="end_reagent_code"></result>
@@ -144,6 +146,9 @@
sr.memo as reagentMemo, sr.valid_flag as reagentValidFlag, sr.create_time as reagentCreateTime, sr.update_time as reagentUpdateTime,sr.control_products as controlProducts,sr.product_sn as reagentProductSn,sr.product_home as productHome,
ss.name as supplierName,
su.name as applyUserName,
+ su.project as applyUserProject,
+ bm2.meta_value as applyUserDepartment,
+ fir.name as firName,
suApprove.name as approveUserName,
bm.meta_value as productHomeName,
ss.valid_flag as supplierFlag,
@@ -154,7 +159,9 @@
left join sys_user as su on oa.apply_user_id = su.id
left join sys_user as suApprove on oa.approve_user_id = suApprove.id
left join sys_user as sys on sys.id=oa.before_approve_user_id
+ left join sys_user as fir on fir.id=oa.first_user
left join base_meta as bm on sr.product_home = bm.id
+ left join base_meta as bm2 on bm2.id = su.department
where oa.id = #{id} and oa.valid_flag = 1
</select>
@@ -166,6 +173,8 @@
sr.dangerous_flag as reagentDangerousFlag,sr.control_products as controlProducts,sr.product_home as productHome,
ss.name as supplierName,
su.name as applyUserName,
+ su.project as applyUserProject,
+ bm2.meta_value as applyUserDepartment,
suApprove.name as approveUserName,
bm.meta_value as productHomeName,
fir.name as firName,
@@ -180,6 +189,7 @@
left join sys_user as fir on fir.id=oa.first_user
left join base_meta as bm on sr.product_home = bm.id
left join base_meta as bm1 on bm1.id = sr.control_products
+ left join base_meta as bm2 on bm2.id = su.department
where oa.valid_flag = 1
<if test="isShow != null and isShow ==0">
and (ss.valid_flag = 1 or sr.type = 0)
diff --git a/src/main/java/com/nanometer/smartlab/entity/OpeApply.java b/src/main/java/com/nanometer/smartlab/entity/OpeApply.java
index 74ecd72..8365d57 100644
--- a/src/main/java/com/nanometer/smartlab/entity/OpeApply.java
+++ b/src/main/java/com/nanometer/smartlab/entity/OpeApply.java
@@ -68,6 +68,8 @@
private SysReagent reagent;
private String applyUserName;
+ private String applyUserProject;
+ private String applyUserDepartment;
private String approveUserName;
@@ -413,4 +415,20 @@
public void setOrderStatus(ApplyStatus orderStatus) {
this.orderStatus = orderStatus;
}
+
+ public String getApplyUserProject() {
+ return applyUserProject;
+ }
+
+ public void setApplyUserProject(String applyUserProject) {
+ this.applyUserProject = applyUserProject;
+ }
+
+ public String getApplyUserDepartment() {
+ return applyUserDepartment;
+ }
+
+ public void setApplyUserDepartment(String applyUserDepartment) {
+ this.applyUserDepartment = applyUserDepartment;
+ }
}
--
Gitblit v1.9.2