From d7fe8ae3888c8e2b1eea3c1e3769be0d42a21cc9 Mon Sep 17 00:00:00 2001 From: jiangping <jp@doumee.com> Date: 星期一, 16 十月 2023 09:03:47 +0800 Subject: [PATCH] Merge branch '1.0.3' of http://139.186.142.91:10010/r/productDev/dmMes into 1.0.3 --- server/src/main/java/doumeemes/service/ext/impl/WorkorderRecordExtServiceImpl.java | 98 ++++++++++++++++++++++++++++++++++++------------ 1 files changed, 73 insertions(+), 25 deletions(-) diff --git a/server/src/main/java/doumeemes/service/ext/impl/WorkorderRecordExtServiceImpl.java b/server/src/main/java/doumeemes/service/ext/impl/WorkorderRecordExtServiceImpl.java index 4858697..ac96eba 100644 --- a/server/src/main/java/doumeemes/service/ext/impl/WorkorderRecordExtServiceImpl.java +++ b/server/src/main/java/doumeemes/service/ext/impl/WorkorderRecordExtServiceImpl.java @@ -137,6 +137,9 @@ for(WorkorderRecordExtListVO model : result){ //鏌ヨ鐢熶骇浜哄憳濮撳悕 initProUser(user,model,allDepartList); +// BigDecimal s =new BigDecimal(Constants.formatIntegerNum(model.getSalary())); +// s.divide(new BigDecimal(0),2); +// model.setSalary(s.doubleValue()); } } return PageData.from(new PageInfo<>(result)); @@ -1687,14 +1690,13 @@ if(model.getUserInfo()!=null){ model.setUserName(model.getUserInfo().getUserName()); model.setDepartName(model.getUserInfo().getDepartName()); - model.setNum(model.getNum().setScale(2)); - model.setQualifiedNum(model.getQualifiedNum().setScale(2)); - model.setUnQualifiedNum(model.getUnQualifiedNum().setScale(2)); - + model.setNum(Constants.formatBigdecimalFloat(model.getNum(),2)); + model.setQualifiedNum(Constants.formatBigdecimalFloat(model.getQualifiedNum(),2)); + model.setUnQualifiedNum(Constants.formatBigdecimalFloat(model.getUnQualifiedNum(),2)); + model.setRate(Constants.formatBigdecimalFloat(model.getRate(),2)); } } ExcelExporter.build(UserSalaryListVO.class).export(result, "鍛樺伐缁╂晥鏄庣粏"+System.currentTimeMillis(), response); - } @Override public void exportSalaryStatistics(PageWrap<QuerySalaryStatisticDTO> pageWrap, HttpServletResponse response){ @@ -1738,45 +1740,91 @@ unintname = re.getUmodel().getName(); } if (re.getPmodel() != null) { - Integer pmodelnum = re.getPmodel().getNum() != null ? re.getPmodel().getNum() : 0; + BigDecimal pmodelnum = re.getNum() != null ? re.getNum() : new BigDecimal("0"); // wreev.setPlanNum( new BigDecimal(pmodelnum).stripTrailingZeros().toPlainString() + unintname); - wreev.setPlanNum( new BigDecimal(pmodelnum).stripTrailingZeros().toPlainString() ); - } - if (re.getDoneType() != null) { - switch (re.getDoneType()) { - case 0: - wreev.setDoneType("鍚堟牸"); - break; - case 1: - wreev.setDoneType("涓嶈壇"); - break; - case 2: - wreev.setDoneType("鎶ュ簾"); - break; - default: - break; - } + wreev.setPlanNum( re.getNum().stripTrailingZeros().toPlainString()+unintname); } wreev.setProcedureName(re.getProcedureName()); + wreev.setUnintname(unintname); if(re.getNum()!=null){ - wreev.setAppliancenum(re.getNum().stripTrailingZeros().toPlainString() ); + wreev.setAppliancenum(re.getNum().stripTrailingZeros().toPlainString()+unintname ); } - wreev.setUnintname(unintname); + if (re.getAmodel() != null) { wreev.setAppliancecode(re.getAmodel().getCode()); } wreev.setDeviceCode(re.getDeviceCode()+"|"+re.getDeviceName()); wreev.setCreateTime(format.format(re.getCreateTime())); + wreev.setQualifiedNum( (Objects.nonNull(re.getQualifiedNum()) ? re.getQualifiedNum() : 0)+unintname); + wreev.setUnqualifiedNum((Objects.nonNull(re.getUnqualifiedNum()) ? re.getUnqualifiedNum() : 0)+unintname); + Integer duration = re.getDuration(); + if (Objects.nonNull(duration)){ + Integer h = duration/3600; + Integer m = (duration%3600)/60; + Integer s = ((duration%3600)%60); + wreev.setDuration(h+"灏忔椂"+m+"鍒嗛挓"+s+"绉�"); + }else { + wreev.setDuration("-"); + } + wreev.setSalaryType(re.getSalaryType()); + wreev.setSalaryPrice(re.getSalary()); list.add(wreev); } - ExcelExporter.build(WorkorderRecordExportExtListVO.class).export(list, "宸ュ崟鐢熶骇杩囩▼璁板綍"+System.currentTimeMillis(), response); + ExcelExporter.build(WorkorderRecordExportExtListVO.class).export(list, "鐢熶骇浜у嚭鏄庣粏"+System.currentTimeMillis(), response); // EasyExcelUtil.exportExcel(list, "宸ュ崟鐢熶骇杩囩▼璁板綍","宸ュ崟鐢熶骇杩囩▼璁板綍",WorkorderRecordExportExtListVO.class,"宸ュ崟鐢熶骇杩囩▼璁板綍"+System.currentTimeMillis()+".xls", response); } + @Override + public void exportExcel2(PageWrap<QueryWorkorderRecordExtDTO> pageWrap, HttpServletResponse response) { + List<WorkorderRecordExtListVO> result=this.findPage(pageWrap).getRecords(); + SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd"); + List<WorkorderRecordBathExportExtListVO> list=new ArrayList<>(); + for(int i=0;i<result.size();i++) { + WorkorderRecordExtListVO re = result.get(i); + WorkorderRecordBathExportExtListVO wreev = new WorkorderRecordBathExportExtListVO(); + if (re.getOmodel() != null) { + wreev.setWorkordercode(re.getOmodel().getCode()); + if (re.getOmodel().getStatus() != null) { + String status = Constants.WORKORDER_STATUS.getTitleByStatus(null, re.getOmodel().getStatus()); + wreev.setStatus(status); + } + } + if (re.getMmodel() != null) { + wreev.setMaterialcode(re.getMmodel().getCode()); + wreev.setMaterialname(re.getMmodel().getName()); + } + wreev.setBatch(re.getBatch()); + if (re.getPromodel() != null) { + wreev.setProceduresname(re.getPromodel().getName()); + } + + String unintname = ""; + if (re.getUmodel() != null) { + unintname = re.getUmodel().getName(); + } + if (re.getNum() != null) { + BigDecimal pmodelnum = re.getNum() != null ? re.getNum() : new BigDecimal("0"); + // wreev.setPlanNum( new BigDecimal(pmodelnum).stripTrailingZeros().toPlainString() + unintname); + wreev.setNum( pmodelnum.stripTrailingZeros().toPlainString()+unintname); + } + wreev.setProcedureName(re.getProcedureName()); + wreev.setUnintname(unintname); + if(re.getOmodel().getPlanNum() != null){ + wreev.setPlanNum(re.getOmodel().getPlanNum().toString() ); + } + wreev.setMaterialDonetype(re.getMaterialDonetype()); + wreev.setDeviceCode(re.getDeviceCode()+"|"+re.getDeviceName()); + wreev.setCreateTime(format.format(re.getCreateTime())); + list.add(wreev); + + } + ExcelExporter.build(WorkorderRecordBathExportExtListVO.class).export(list, "鐢熶骇鎶曟枡鏄庣粏"+System.currentTimeMillis(), response); + + } } -- Gitblit v1.9.3