From 1c375d6dcd0c41bc3c206585a2712ec066bf5992 Mon Sep 17 00:00:00 2001 From: lyfO_o <764716047@qq.com> Date: 星期五, 18 十一月 2022 10:09:13 +0800 Subject: [PATCH] 卡号 bug --- src/main/java/com/nanometer/smartlab/controller/ApplyMngController.java | 161 ++++++++++++++++++++++++++++++++++------------------- 1 files changed, 104 insertions(+), 57 deletions(-) diff --git a/src/main/java/com/nanometer/smartlab/controller/ApplyMngController.java b/src/main/java/com/nanometer/smartlab/controller/ApplyMngController.java index ff14dbe..4fcfea1 100644 --- a/src/main/java/com/nanometer/smartlab/controller/ApplyMngController.java +++ b/src/main/java/com/nanometer/smartlab/controller/ApplyMngController.java @@ -5,6 +5,8 @@ import com.nanometer.smartlab.entity.SysReagent; import com.nanometer.smartlab.entity.SysUser; import com.nanometer.smartlab.entity.enumtype.ApplyStatus; +import com.nanometer.smartlab.entity.enumtype.ValidFlag; +import com.nanometer.smartlab.exception.BusinessException; import com.nanometer.smartlab.service.*; import com.nanometer.smartlab.util.Constants; import com.nanometer.smartlab.util.FacesUtils; @@ -15,6 +17,7 @@ import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.primefaces.context.RequestContext; +import org.primefaces.event.FileUploadEvent; import org.primefaces.event.SelectEvent; import org.primefaces.event.TabChangeEvent; import org.primefaces.model.LazyDataModel; @@ -71,6 +74,8 @@ private Integer status; private Integer favor; private List<ApplyStatus> statusSelectList; + private String controlProduct; + private LazyDataModel<SysReagent> reagentDataModel; private LazyDataModel<SysReagent> reagentFavorDataModel; @@ -138,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()); @@ -237,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); + realDataList=opeApplyService.getOpeApplyList(reagentName, startDeadline,controlProduct, endDeadline, status, getUserId(), null, queryCAS, null, null,null,applyUserName,(byte)1); } List<String> headerList = new ArrayList<>(); @@ -254,6 +259,8 @@ headerList.add("试剂类型"); headerList.add("申购数量"); headerList.add("申购人"); + headerList.add("申购人课题组"); + headerList.add("申购人部门"); headerList.add("申购日期"); headerList.add("一级审批者"); headerList.add("二级审批者"); @@ -297,6 +304,22 @@ } } + + + public void uploadApply(FileUploadEvent event){ + try { + opeApplyService.importApply(event, getUser()); + FacesUtils.info("导入成功"); + } catch (BusinessException e) { + FacesUtils.warn(e.getMessage()); + } catch (Exception e) { + e.printStackTrace(); + FacesUtils.warn("导入失败,请联系管理员"); + } + + } + + public HSSFWorkbook exportExcelNew(List<String> headerList, List<OpeApply> dataList) { HSSFWorkbook hssfWorkbook = new HSSFWorkbook(); @@ -323,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; @@ -483,10 +510,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); + 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); + 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(); @@ -501,22 +528,23 @@ } catch (Exception e) { logger.error(e); } + selectedList = null; return list; } @Override public OpeApply getRowData(String rowKey) { - Iterator<OpeApply> iterator = this.iterator(); - if (iterator != null) { - OpeApply oa = null; - while (iterator.hasNext()) { - oa = iterator.next(); - if (rowKey.equals(oa.getId())) { - return oa; - } - } - } - return null; +// Iterator<OpeApply> iterator = this.iterator(); +// if (iterator != null) { +// OpeApply oa = null; +// while (iterator.hasNext()) { +// oa = iterator.next(); +// if (rowKey.equals(oa.getId())) { +// return oa; +// } +// } +// } + return opeApplyService.getOpeApply(rowKey); } }; } @@ -544,17 +572,17 @@ @Override public SysReagent getRowData(String rowKey) { - Iterator<SysReagent> iterator = this.iterator(); - if (iterator != null) { - SysReagent sr = null; - while (iterator.hasNext()) { - sr = iterator.next(); - if (rowKey.equals(sr.getId())) { - return sr; - } - } - } - return null; +// Iterator<SysReagent> iterator = this.iterator(); +// if (iterator != null) { +// SysReagent sr = null; +// while (iterator.hasNext()) { +// sr = iterator.next(); +// if (rowKey.equals(sr.getId())) { +// return sr; +// } +// } +// } + return sysReagentService.getRowData(rowKey); } }; } @@ -583,17 +611,17 @@ @Override public SysReagent getRowData(String rowKey) { - Iterator<SysReagent> iterator = this.iterator(); - if (iterator != null) { - SysReagent sr = null; - while (iterator.hasNext()) { - sr = iterator.next(); - if (rowKey.equals(sr.getId())) { - return sr; - } - } - } - return null; +// Iterator<SysReagent> iterator = this.iterator(); +// if (iterator != null) { +// SysReagent sr = null; +// while (iterator.hasNext()) { +// sr = iterator.next(); +// if (rowKey.equals(sr.getId())) { +// return sr; +// } +// } +// } + return sysReagentService.getRowData(rowKey); } }; } @@ -611,12 +639,13 @@ String applyUserId = getUserId(); int count = 0; if (StringUtils.isNotBlank(applyUserId)) { - count = opeApplyService.getOpeApplyTotalCount(null, null, null, null, applyUserId, null, null,applyCode,null); + 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); + list = opeApplyService.getOpeApplyList(null, null,null, null, null, applyUserId, null, null, first, pageSize,applyCode,null,(byte)1); } + selectedList = null; } catch (Exception e) { logger.error(e); } @@ -625,17 +654,17 @@ @Override public OpeApply getRowData(String rowKey) { - Iterator<OpeApply> iterator = this.iterator(); - if (iterator != null) { - OpeApply oa = null; - while (iterator.hasNext()) { - oa = iterator.next(); - if (rowKey.equals(oa.getId())) { - return oa; - } - } - } - return null; +// Iterator<OpeApply> iterator = this.iterator(); +// if (iterator != null) { +// OpeApply oa = null; +// while (iterator.hasNext()) { +// oa = iterator.next(); +// if (rowKey.equals(oa.getId())) { +// return oa; +// } +// } +// } + return opeApplyService.getOpeApply(rowKey); } }; } @@ -723,11 +752,21 @@ //申请一个申购编号 String applyCode = this.sysSequenceService.getApplyCode(); for (OpeApply opeApply : this.applyNewList) { - + if (opeApply.getReagent().getValidFlag() == null + ||opeApply.getReagent().getValidFlag().equals(ValidFlag.INVALID)){ + FacesUtils.warn(opeApply.getReagent().getName()+",该试剂已删除,请选择其他试剂"); + return; + } + if (opeApply.getReagent().getType() == 1 + && (opeApply.getReagent().getSupplierFlag() == null + || opeApply.getReagent().getSupplierFlag().equals(ValidFlag.INVALID))){ + FacesUtils.warn(opeApply.getReagent().getName()+",该试剂供应商已删除,请选择其他试剂"); + return; + } opeApply.setId(IDUtils.uuid()); opeApply.setApplyCode(applyCode); opeApply.setApplyUserId(applyUser.getId()); - opeApply.setStatus(ApplyStatus.PENDING_APPROVAL); + opeApply.setStatus(ApplyStatus.Price_CONFIRM); } this.opeApplyService.insertOpeApplyList(this.applyNewList); @@ -973,4 +1012,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