From 295d8ff09a5fbf9dc757c2bdb408f860a11b85d1 Mon Sep 17 00:00:00 2001 From: lyfO_o <764716047@qq.com> Date: 星期四, 31 三月 2022 16:05:15 +0800 Subject: [PATCH] 个人领用导出 --- src/main/java/com/nanometer/smartlab/service/OpeUseFlowServiceImpl.java | 58 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 58 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/nanometer/smartlab/service/OpeUseFlowServiceImpl.java b/src/main/java/com/nanometer/smartlab/service/OpeUseFlowServiceImpl.java index 64e78c3..8dae14b 100644 --- a/src/main/java/com/nanometer/smartlab/service/OpeUseFlowServiceImpl.java +++ b/src/main/java/com/nanometer/smartlab/service/OpeUseFlowServiceImpl.java @@ -8,6 +8,7 @@ import javax.annotation.Resource; +import com.hazelcast.core.IFunction; import com.nanometer.smartlab.dao.*; import com.nanometer.smartlab.entity.*; import com.nanometer.smartlab.entity.dto.PersonUseDetail; @@ -734,4 +735,61 @@ return true; } + + /** + * @Description: 查询导出 + */ + @Override + public List<Map> selectExportDetail(String reagentCode, String userId, Date startTime, Date endTime, String receiptNumber, String department, String project, String applyPerson, String reagentName) { + Map<String, Object> params = new HashMap<>(); + Map<String, String> metaMap2 = new HashMap<>(); + SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); + if (startTime != null) { + params.put("startTime", sdf.format(startTime) +" 00:00:00"); + } + + if (endTime != null) { + params.put("endTime", sdf.format(endTime) + " 23:59:59"); + } + + params.put("reagentCode", reagentCode); + + params.put("endTime", endTime); + params.put("receiptNumber", receiptNumber); + params.put("department", department); + params.put("project", project); + params.put("applyPerson", applyPerson); + params.put("reagentName", reagentName); + params.put("groupId", "operate_status"); + metaMap2.put("metaKey", String.valueOf(OperateStatus.WAREHOUSEOUT.getKey())); + List<BaseMeta> baseMetas = baseMetaDao.getBaseMetaList(metaMap2); + params.put("operatestate", baseMetas.get(0).getId()); + + metaMap2.put("metaKey", String.valueOf(OperateStatus.TRANSFER.getKey())); + List<BaseMeta> baseMetas1 = baseMetaDao.getBaseMetaList(metaMap2); + params.put("operatestate1", baseMetas1.get(0).getId()); + addParamByUserId(userId, params); + return opeUseFlowDao.selectDetail(params); + } + + @Override + public boolean export22Excel(List<Map> list) throws Exception { + Map<String,String> map = new LinkedHashMap<>(); + map.put("productSn", "产品编号"); + map.put("reagentName", "试剂名称"); + map.put("reagentCode", "试剂条形码"); + map.put("controlProducts", "管制品"); + map.put("reagentFormat", "规格型号"); + map.put("perInfo", "包装"); + map.put("productHome", "厂家"); + map.put("articleNumber", "批号"); + map.put("username", "申领人"); + map.put("project", "课题组"); + map.put("department", "部门"); + map.put("location", "地点"); + map.put("createTime", "领用时间"); + ExcelUtils.export2Excel(list,"试剂领用记录表",map); + return true; + } + } -- Gitblit v1.9.2