From 1eeae82f74cbb3469ad8931e45b6fc77a945b912 Mon Sep 17 00:00:00 2001 From: kongzy <kongzy> Date: 星期一, 23 十月 2023 16:10:08 +0800 Subject: [PATCH] 姑苏实验室去除价格确认过程 --- src/main/java/com/nanometer/smartlab/controller/ApplyMngController.java | 58 ++++++++++++++++++++++++++++++++++++++++++---------------- 1 files changed, 42 insertions(+), 16 deletions(-) diff --git a/src/main/java/com/nanometer/smartlab/controller/ApplyMngController.java b/src/main/java/com/nanometer/smartlab/controller/ApplyMngController.java index a9b6d0b..32222c5 100644 --- a/src/main/java/com/nanometer/smartlab/controller/ApplyMngController.java +++ b/src/main/java/com/nanometer/smartlab/controller/ApplyMngController.java @@ -74,6 +74,8 @@ private Integer status; private Integer favor; private List<ApplyStatus> statusSelectList; + private String controlProduct; + private LazyDataModel<SysReagent> reagentDataModel; private LazyDataModel<SysReagent> reagentFavorDataModel; @@ -141,7 +143,7 @@ } public void initApproveUserSelectList() { - this.approveUserSelectList = this.sysUserService.getHasProjectSysUserList(this.getUserDepartment()); + this.approveUserSelectList = this.sysUserService.getHasProjectSysUserList(this.getUserDepartment(),this.getUserProject()); if (!CollectionUtils.isEmpty(this.approveUserSelectList)){ if(this.selectedList == null){ this.sysProjectList = sysProjectService.getSysProjectList(this.approveUserSelectList.get(0).getId()); @@ -240,7 +242,7 @@ if(selectedList!=null&&selectedList.size()>0){ realDataList=selectedList; }else { - realDataList=opeApplyService.getOpeApplyList(reagentName, startDeadline, endDeadline, status, getUserId(), null, queryCAS, null, null,null,applyUserName,(byte)1); + realDataList=opeApplyService.getOpeApplyList(reagentName, startDeadline,controlProduct, endDeadline, status, getUserId(), null, queryCAS, null, null,null,applyUserName,(byte)1); } List<String> headerList = new ArrayList<>(); @@ -253,15 +255,19 @@ headerList.add("含税售价"); headerList.add("CAS号"); headerList.add("危险性质"); + headerList.add("供应商"); headerList.add("厂家"); headerList.add("试剂类型"); headerList.add("申购数量"); headerList.add("申购人"); + headerList.add("申购人课题组"); + headerList.add("申购人部门"); headerList.add("申购日期"); headerList.add("一级审批者"); headerList.add("二级审批者"); headerList.add("订单状态"); headerList.add("审批批注"); + HSSFWorkbook hssfWorkbook =exportExcelNew(headerList, realDataList); hssfWorkbook.write(out); out.flush(); @@ -338,20 +344,27 @@ dataRow.createCell(6).setCellValue(dataList.get(i).getReagent().getPrice()== null ? "": String.valueOf(dataList.get(i).getReagent().getPrice())); dataRow.createCell(7).setCellValue(dataList.get(i).getReagent().getCas()== null ? "": String.valueOf(dataList.get(i).getReagent().getCas())); dataRow.createCell(8).setCellValue(dataList.get(i).getReagent().getReagentCharacter()== null ? "": String.valueOf(baseMetaService.getBaseMetaValue(dataList.get(i).getReagent().getReagentCharacter()))); - dataRow.createCell(9).setCellValue(dataList.get(i).getReagent().getProductHomeName()== null ? "": String.valueOf(dataList.get(i).getReagent().getProductHomeName())); - 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(9).setCellValue(dataList.get(i).getReagent().getSupplierName()== null ? "": String.valueOf(dataList.get(i).getReagent().getSupplierName())); + + + dataRow.createCell(10).setCellValue(dataList.get(i).getReagent().getProductHomeName()== null ? "": String.valueOf(dataList.get(i).getReagent().getProductHomeName())); + dataRow.createCell(11).setCellValue(dataList.get(i).getReagent().getReagentType()== null ? "": String.valueOf(baseMetaService.getBaseMetaValue(dataList.get(i).getReagent().getReagentType()))); + dataRow.createCell(12).setCellValue(String.valueOf(dataList.get(i).getNum())); + dataRow.createCell(13).setCellValue(String.valueOf(dataList.get(i).getApplyUserName())); + dataRow.createCell(14).setCellValue(dataList.get(i).getApplyUserProject() == null?"":String.valueOf(dataList.get(i).getApplyUserProject())); + dataRow.createCell(15).setCellValue(dataList.get(i).getApplyUserDepartment() == null?"":String.valueOf(dataList.get(i).getApplyUserDepartment())); + + + dataRow.createCell(16).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(17).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(18).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(19).setCellValue(String.valueOf(dataList.get(i).getStatus().getText())); + dataRow.createCell(20).setCellValue(dataList.get(i).getMemo()==null ?"":String.valueOf(dataList.get(i).getMemo())); } return hssfWorkbook; @@ -502,10 +515,10 @@ public List<OpeApply> load(int first, int pageSize, String sortField, SortOrder sortOrder, Map<String, Object> filters) { List<OpeApply> list = null; try { - int count = opeApplyService.getOpeApplyTotalCount(reagentName, startDeadline, endDeadline, status, getUserId(), null, queryCAS,null,applyUserName,(byte)1); + int count = opeApplyService.getOpeApplyTotalCount(reagentName, startDeadline,controlProduct, endDeadline, status, getUserId(), null, queryCAS,null,applyUserName,(byte)1); this.setRowCount(count); if (count > 0) { - list = opeApplyService.getOpeApplyList(reagentName, startDeadline, endDeadline, status, getUserId(), null, queryCAS, first, pageSize,null,applyUserName,(byte)1); + list = opeApplyService.getOpeApplyList(reagentName, startDeadline,controlProduct, endDeadline, status, getUserId(), null, queryCAS, first, pageSize,null,applyUserName,(byte)1); for(int i=0;i<list.size();i++){ if(list.get(i).getBeforeApproveUserId()!=null&&!list.get(i).getBeforeApproveUserId().equals("")){ String name=list.get(i).getApproveUserName(); @@ -631,11 +644,11 @@ String applyUserId = getUserId(); int count = 0; if (StringUtils.isNotBlank(applyUserId)) { - count = opeApplyService.getOpeApplyTotalCount(null, null, null, null, applyUserId, null, null,applyCode,null,(byte)1); + count = opeApplyService.getOpeApplyTotalCount(null, null, null,null, null, applyUserId, null, null,applyCode,null,(byte)1); } this.setRowCount(count); if (count > 0) { - list = opeApplyService.getOpeApplyList(null, null, null, null, applyUserId, null, null, first, pageSize,applyCode,null,(byte)1); + list = opeApplyService.getOpeApplyList(null, null,null, null, null, applyUserId, null, null, first, pageSize,applyCode,null,(byte)1); } selectedList = null; } catch (Exception e) { @@ -758,7 +771,12 @@ opeApply.setId(IDUtils.uuid()); opeApply.setApplyCode(applyCode); opeApply.setApplyUserId(applyUser.getId()); - opeApply.setStatus(ApplyStatus.PENDING_APPROVAL); + if(getActiveEnv().equalsIgnoreCase("gslab")){//姑苏实验室跳过价格确认状态,直接进入待审批状态 + opeApply.setStatus(ApplyStatus.PENDING_APPROVAL); + }else{ + opeApply.setStatus(ApplyStatus.Price_CONFIRM); + } + } this.opeApplyService.insertOpeApplyList(this.applyNewList); @@ -1004,4 +1022,12 @@ public void setTabValue(int tabValue) { this.tabValue = tabValue; } + + public String getControlProduct() { + return controlProduct; + } + + public void setControlProduct(String controlProduct) { + this.controlProduct = controlProduct; + } } -- Gitblit v1.9.2