| | |
| | | import com.java110.api.smo.DefaultAbstractComponentSMO; |
| | | import com.java110.api.smo.assetExport.IExportReportFeeSMO; |
| | | import com.java110.core.context.IPageData; |
| | | import com.java110.core.log.LoggerFactory; |
| | | import com.java110.dto.fee.FeeConfigDto; |
| | | import com.java110.entity.component.ComponentValidateResult; |
| | | import com.java110.utils.cache.MappingCache; |
| | |
| | | import org.apache.poi.ss.usermodel.Workbook; |
| | | import org.apache.poi.xssf.usermodel.XSSFWorkbook; |
| | | import org.slf4j.Logger; |
| | | import org.slf4j.LoggerFactory; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.http.HttpHeaders; |
| | | import org.springframework.http.HttpMethod; |
| | |
| | | row.createCell(4).setCellValue("物品名称"); |
| | | row.createCell(5).setCellValue("物品规格"); |
| | | row.createCell(6).setCellValue("是否是固定物品"); |
| | | row.createCell(7).setCellValue("物品使用数量"); |
| | | row.createCell(8).setCellValue("物品价格"); |
| | | row.createCell(9).setCellValue("使用人ID"); |
| | | row.createCell(10).setCellValue("使用人"); |
| | | row.createCell(11).setCellValue("创建时间"); |
| | | row.createCell(12).setCellValue("备注"); |
| | | row.createCell(7).setCellValue("物品使用类型"); |
| | | row.createCell(8).setCellValue("物品使用数量"); |
| | | row.createCell(9).setCellValue("物品价格"); |
| | | row.createCell(10).setCellValue("使用人ID"); |
| | | row.createCell(11).setCellValue("使用人"); |
| | | row.createCell(12).setCellValue("创建时间"); |
| | | row.createCell(13).setCellValue("备注"); |
| | | JSONArray resourceStoreUseRecords = this.getResourceStoreUseRecordManage(pd, result); |
| | | if (resourceStoreUseRecords == null || resourceStoreUseRecords.size() == 0) { |
| | | return; |
| | |
| | | row.createCell(4).setCellValue(dataObj.getString("resourceStoreName")); |
| | | row.createCell(5).setCellValue(dataObj.getString("specName")); |
| | | row.createCell(6).setCellValue(dataObj.getString("isFixedName")); |
| | | row.createCell(7).setCellValue(dataObj.getString("quantity") + dataObj.getString("miniUnitCodeName")); |
| | | row.createCell(8).setCellValue(dataObj.getString("unitPrice")); |
| | | row.createCell(9).setCellValue(dataObj.getString("createUserId")); |
| | | row.createCell(10).setCellValue(dataObj.getString("createUserName")); |
| | | row.createCell(11).setCellValue(dataObj.getString("createTime")); |
| | | row.createCell(12).setCellValue(dataObj.getString("remark")); |
| | | row.createCell(7).setCellValue(dataObj.getString("stateName")); |
| | | row.createCell(8).setCellValue(dataObj.getString("quantity") + dataObj.getString("miniUnitCodeName")); |
| | | row.createCell(9).setCellValue(dataObj.getString("unitPrice")); |
| | | row.createCell(10).setCellValue(dataObj.getString("createUserId")); |
| | | row.createCell(11).setCellValue(dataObj.getString("createUserName")); |
| | | row.createCell(12).setCellValue(dataObj.getString("createTime")); |
| | | row.createCell(13).setCellValue(dataObj.getString("remark")); |
| | | } |
| | | } |
| | | |
| | |
| | | } |
| | | JSONObject savedResourceStores = JSONObject.parseObject(responseEntity.getBody(), Feature.OrderedField); |
| | | //获取限制条数的值 |
| | | int number = Integer.parseInt(MappingCache.getValue(DOMAIN_COMMON, EXPORT_NUMBER)); |
| | | String exportNumber = MappingCache.getValue(DOMAIN_COMMON, EXPORT_NUMBER); |
| | | if (!StringUtil.isNumber(exportNumber)) { |
| | | exportNumber = "10000"; |
| | | } |
| | | int number = Integer.parseInt(exportNumber); |
| | | if (savedResourceStores.getJSONArray("resourceStores").size() > number) { |
| | | throw new IllegalArgumentException("导出数据超过限制条数" + number + "条,无法继续导出操作!"); |
| | | } |