| | |
| | | FinSysTenant finSysTenant = finSysTenantService.get(new FinSysTenant(param.getOutAgencyId())); |
| | | if (finSysTenant == null) { |
| | | log.error("调拨机构不存在"); |
| | | throw new Exception("调拨机构不存在"); |
| | | } |
| | | Long outAgencyId = finSysTenant.getId(); |
| | | lWhFormTransfer.setOutAgencyId(outAgencyId); |
| | |
| | | goodsTemplateInfoList.add(goodsTemplateInfoVO); |
| | | } |
| | | result.setFormTransferGoods(goodsTemplateInfoList); |
| | | |
| | | // String sql = "SELECT bgt.id, CATEGORY_ID, CATEGORY_NAME, GOODS_NAME,bgt.CLASSIFICATION type " |
| | | // + "FROM l_wh_procure_model pm LEFT JOIN base_goods_models bgm ON bgm.id = pm.BASE_GOODS_MODELS_ID " |
| | | // + "LEFT JOIN base_goods_template bgt ON bgt.id = bgm.GOODS_TEMPLATES_ID " |
| | | // + "WHERE pm.BUSINESS_ID =:id GROUP BY bgt.id "; |
| | | // Map<String, Object> paramMap = new HashMap<>(); |
| | | // paramMap.put("id", result.getId()); |
| | | // List<Map<String, Object>> procureModelList = this.select(sql, paramMap, new MapperUtil()); |
| | | // |
| | | // String queryRecord = |
| | | // "SELECT * FROM l_wh_procure_model_user_record where TRANS_BUSINESS_ID = :id order by DEAL_TIME desc limit 1"; |
| | | // LWhProcureModelUserRecord lWhProcureModelUserRecord = |
| | | // lWhProcureModelUserRecordService.get(queryRecord, paramMap, new LWhProcureModelUserRecord()); |
| | | // List<FormTransferGoodsVO> formTransferGoods = Lists.newArrayList(); |
| | | // for (Map<String, Object> map : procureModelList) { |
| | | // FormTransferGoodsVO procureTemplateInfoVO = MapUtils.convertMapToObj(map, FormTransferGoodsVO.class); |
| | | // Long baseGoodsTemplateId = procureTemplateInfoVO.getId(); |
| | | // // 查询型号数量 |
| | | // List<GoodsModelVO> goodsModelVOList = Lists.newArrayList(); |
| | | // String sql2 = "SELECT pm.id,pm.BASE_GOODS_MODELS_NAME,bgm.UNIT,COUNTS,total_amount " |
| | | // + "FROM l_wh_procure_model pm LEFT JOIN base_goods_models bgm ON bgm.id = pm.BASE_GOODS_MODELS_ID " |
| | | // + "LEFT JOIN base_goods_template bgt ON bgt.id = bgm.GOODS_TEMPLATES_ID " |
| | | // + "WHERE pm.BUSINESS_ID =:id and bgt.id =:baseGoodsTemplateId"; |
| | | // Map<String, Object> goodsModelParamMap = new HashMap<>(); |
| | | // goodsModelParamMap.put("id", result.getId()); |
| | | // goodsModelParamMap.put("baseGoodsTemplateId", baseGoodsTemplateId); |
| | | // List<Map<String, Object>> modelList = this.select(sql2, goodsModelParamMap, new MapperUtil()); |
| | | // modelList.forEach(item -> { |
| | | // GoodsModelVO goodsModelVO = MapUtils.convertMapToObj(item, GoodsModelVO.class); |
| | | // Integer businessType = result.getBusinessType(); |
| | | // String type = procureTemplateInfoVO.getType(); |
| | | // // 部门分发需要查询使用信息 |
| | | // if (businessType == 1 && "A".equals(type)) { |
| | | // Long procureModelId = goodsModelVO.getId(); |
| | | // LWhProcureModelUser lWhProcureModelUser = new LWhProcureModelUser(); |
| | | // lWhProcureModelUser.setWhProcureModelId(procureModelId); |
| | | // lWhProcureModelUser.setProcureModelUserRecordId(lWhProcureModelUserRecord.getId()); |
| | | // List<LWhProcureModelUser> procureModelUserList = |
| | | // this.lWhProcureModelUserService.select(lWhProcureModelUser); |
| | | // if (!CollectionUtils.isEmpty(procureModelUserList)) { |
| | | // List<DepartGoodsUseInfo> departGoodsUseInfoList = Lists.newArrayList(); |
| | | // procureModelUserList.forEach(useInfo -> { |
| | | // Integer goodsNum = useInfo.getGoodsNum(); |
| | | // Long nowUserPhone = useInfo.getNowUserPhone(); |
| | | // String nowUserName = useInfo.getNowUserName(); |
| | | // DepartGoodsUseInfo departGoodsUseInfo = new DepartGoodsUseInfo(); |
| | | // departGoodsUseInfo.setName(nowUserName); |
| | | // departGoodsUseInfo.setNum(goodsNum); |
| | | // departGoodsUseInfo.setTel(nowUserPhone); |
| | | // departGoodsUseInfoList.add(departGoodsUseInfo); |
| | | // }); |
| | | // goodsModelVO.setUseInfo(departGoodsUseInfoList); |
| | | // } |
| | | // |
| | | // } |
| | | // goodsModelVOList.add(goodsModelVO); |
| | | // procureTemplateInfoVO.setModels(goodsModelVOList); |
| | | // }); |
| | | // formTransferGoods.add(procureTemplateInfoVO); |
| | | // } |
| | | // result.setFormTransferGoods(formTransferGoods); |
| | | |
| | | return result; |
| | | } |