| | |
| | | |
| | | import java.util.List; |
| | | import java.io.IOException; |
| | | import java.util.Optional; |
| | | |
| | | import com.aps.common.core.utils.uuid.IdUtils; |
| | | import com.aps.common.security.utils.DictUtils; |
| | |
| | | { |
| | | // startPage(); |
| | | List<ApsGasPipingPlan> list = apsGasPipingPlanService.selectApsGasPipingPlanList(apsGasPipingPlan); |
| | | List<SysDictData> suspendedDic = DictUtils.getDictCache("aps_is_suspended"); |
| | | List<SysDictData> businessTypeDic = DictUtils.getDictCache("aps_business_type"); |
| | | List<SysDictData> documentStatusDic = DictUtils.getDictCache("aps_document_status"); |
| | | List<SysDictData> accountDic = DictUtils.getDictCache("aps_account"); |
| | | list.parallelStream().forEach(plan->{ |
| | | documentStatusDic.stream().filter(x -> x.getDictValue().equals( plan.getDocumentStatus().trim())) |
| | | .findFirst().ifPresent(sysDictData -> plan.setDocumentStatus(sysDictData.getDictLabel())); |
| | | accountDic.stream().filter(x -> x.getDictValue().equals( plan.getAccount().trim())) |
| | | .findFirst().ifPresent(sysDictData -> plan.setAccount(sysDictData.getDictLabel())); |
| | | businessTypeDic.stream().filter(x -> x.getDictValue().equals(plan.getBusinessType().trim())) |
| | | .findFirst().ifPresent(sysDictData -> plan.setBusinessType(sysDictData.getDictLabel())); |
| | | suspendedDic.stream().filter(x -> x.getDictValue().equals( plan.getIsSuspended())) |
| | | .findFirst().ifPresent(sysDictData -> plan.setIsSuspended(sysDictData.getDictLabel())); |
| | | }); |
| | | return getDataTable(list); |
| | | } |
| | | |
| | |
| | | @PostMapping("/export") |
| | | public void export(HttpServletResponse response, ApsGasPipingPlan apsGasPipingPlan) |
| | | { |
| | | List<ApsGasPipingPlan> apsGasPipingPlans = apsGasPipingPlanService.selectApsGasPipingPlanList(apsGasPipingPlan); |
| | | List<SysDictData> list = DictUtils.getDictCache("aps_is_suspended"); |
| | | for (int i = 0; i < apsGasPipingPlans.size(); i++) { |
| | | for (int j = 0; j < list.size(); j++) { |
| | | if (apsGasPipingPlans.get(i).getIsSuspended().equals(Integer.parseInt(list.get(j).getDictValue()))) { |
| | | apsGasPipingPlans.get(i).setIsSuspendedTxt(list.get(j).getDictLabel()); |
| | | break; |
| | | } |
| | | } |
| | | List<ApsGasPipingPlan> planList = apsGasPipingPlanService.selectApsGasPipingPlanList(apsGasPipingPlan); |
| | | List<SysDictData> suspendedDic = DictUtils.getDictCache("aps_is_suspended"); |
| | | List<SysDictData> businessTypeDic = DictUtils.getDictCache("aps_business_type"); |
| | | List<SysDictData> documentStatusDic = DictUtils.getDictCache("aps_document_status"); |
| | | List<SysDictData> accountDic = DictUtils.getDictCache("aps_account"); |
| | | |
| | | for (int i = 0; i < planList.size(); i++) { |
| | | ApsGasPipingPlan plan=planList.get(i); |
| | | String isSuspendedTxt = plan.getIsSuspended().trim(); |
| | | String businessType = plan.getBusinessType().trim(); |
| | | String documentStatusText = plan.getDocumentStatus().trim(); |
| | | String account = plan.getAccount().trim(); |
| | | |
| | | Optional<SysDictData> documentStatusFirst = documentStatusDic.stream().filter(x -> x.getDictValue().equals(documentStatusText)).findFirst(); |
| | | documentStatusFirst.ifPresent(sysDictData -> plan.setDocumentStatus(sysDictData.getDictLabel())); |
| | | |
| | | Optional<SysDictData> accountFirst = accountDic.stream().filter(x -> x.getDictValue().equals(account)).findFirst(); |
| | | accountFirst.ifPresent(sysDictData -> plan.setAccount(sysDictData.getDictLabel())); |
| | | |
| | | Optional<SysDictData> businessTypeFirst = businessTypeDic.stream().filter(x -> x.getDictValue().equals(businessType)).findFirst(); |
| | | businessTypeFirst.ifPresent(sysDictData -> plan.setBusinessType(sysDictData.getDictLabel())); |
| | | |
| | | Optional<SysDictData> isSuspendedFirst = suspendedDic.stream().filter(x -> x.getDictValue().equals(isSuspendedTxt)).findFirst(); |
| | | isSuspendedFirst.ifPresent(sysDictData -> plan.setIsSuspended(sysDictData.getDictLabel())); |
| | | |
| | | |
| | | } |
| | | |
| | | ExcelUtil<ApsGasPipingPlan> util = new ExcelUtil<ApsGasPipingPlan>(ApsGasPipingPlan.class); |
| | | util.exportExcel(response, apsGasPipingPlans, "气体管路计划管理数据"); |
| | | util.exportExcel(response, planList, "气体管路计划管理数据"); |
| | | } |
| | | |
| | | /** |
| | |
| | | //判断导入数据是否为空 |
| | | if (apsGasPipingPlanTemps.size() > 0) { |
| | | String batchNum= IdUtils.fastUUID(); |
| | | List<SysDictData> list = DictUtils.getDictCache("aps_is_suspended"); |
| | | List<SysDictData> suspendedDic = DictUtils.getDictCache("aps_is_suspended"); |
| | | List<SysDictData> businessTypeDic = DictUtils.getDictCache("aps_business_type"); |
| | | List<SysDictData> documentStatusDic = DictUtils.getDictCache("aps_document_status"); |
| | | List<SysDictData> accountDic = DictUtils.getDictCache("aps_account"); |
| | | |
| | | for (int i = 0; i < apsGasPipingPlanTemps.size(); i++) { |
| | | for (int j = 0; j < list.size(); j++) { |
| | | if (apsGasPipingPlanTemps.get(i).getIsSuspendedTxt().equals(list.get(j).getDictLabel())) { |
| | | apsGasPipingPlanTemps.get(i).setIsSuspended(Integer.parseInt(list.get(j).getDictValue())); |
| | | break; |
| | | } |
| | | } |
| | | |
| | | ApsGasPipingPlanTemp planTemp = apsGasPipingPlanTemps.get(i); |
| | | String isSuspendedTxt = planTemp.getIsSuspended().trim(); |
| | | String businessType = planTemp.getBusinessType().trim(); |
| | | String documentStatusText = planTemp.getDocumentStatus().trim(); |
| | | String account = planTemp.getAccount().trim(); |
| | | |
| | | Optional<SysDictData> documentStatusFirst = documentStatusDic.stream().filter(x -> x.getDictLabel().equals(documentStatusText)).findFirst(); |
| | | documentStatusFirst.ifPresent(sysDictData -> planTemp.setDocumentStatus(sysDictData.getDictValue())); |
| | | |
| | | Optional<SysDictData> accountFirst = accountDic.stream().filter(x -> x.getDictLabel().equals(account)).findFirst(); |
| | | accountFirst.ifPresent(sysDictData -> planTemp.setAccount(sysDictData.getDictValue())); |
| | | |
| | | Optional<SysDictData> businessTypeFirst = businessTypeDic.stream().filter(x -> x.getDictLabel().equals(businessType)).findFirst(); |
| | | businessTypeFirst.ifPresent(sysDictData -> planTemp.setBusinessType(sysDictData.getDictValue())); |
| | | |
| | | |
| | | Optional<SysDictData> isSuspendedFirst = suspendedDic.stream().filter(x -> x.getDictLabel().equals(isSuspendedTxt)).findFirst(); |
| | | isSuspendedFirst.ifPresent(sysDictData -> planTemp.setIsSuspended(sysDictData.getDictValue())); |
| | | |
| | | planTemp.setId(IdUtils.fastUUID()); |
| | | //插入版本号 |
| | | apsGasPipingPlanTemps.get(i).setBatchNumber(batchNum); |
| | | planTemp.setBatchNumber(batchNum); |
| | | //插入临时表 |
| | | apsGasPipingPlanTempService.insertApsGasPipingPlanTemp(apsGasPipingPlanTemps.get(i)); |
| | | apsGasPipingPlanTempService.insertApsGasPipingPlanTemp(planTemp); |
| | | } |
| | | return AjaxResult.success("导入成功",batchNum); |
| | | } else { |