| | |
| | | userName = object.get("userName").toString(); |
| | | } |
| | | |
| | | String inventoryArea = ""; |
| | | if (object.get("inventoryArea") != null) { |
| | | inventoryArea = object.get("inventoryArea").toString(); |
| | | } |
| | | |
| | | int quantity = 0; |
| | | if (object.get("quantity") != null) { |
| | | quantity = Integer.valueOf(object.get("quantity").toString()); |
| | | } |
| | | |
| | | FinishedGlassShelfInformation finishedGlassShelfInformation = |
| | | JSONObject.parseObject(JSONObject.toJSONString(object.get("title")), FinishedGlassShelfInformation.class); |
| | | finishedGlassShelfInformation.setMoney(finishedGlassShelfInformation.getPrice()*finishedGlassShelfInformation.getTotalQuantity()); |
| | | |
| | | List<FinishedGlassShelfInformation> finishedGlassShelfInformationList=finishedGlassShelfMapper |
| | | .getSelectFinishedGlassShelfInformation(finishedGlassShelfInformation); |
| | |
| | | finishedGlassShelfMapper.updateFinishedGlassShelfInformation(finishedGlassShelfInformation,finishedGlassShelfInformation.getId()); |
| | | log.setFunction("saveFinishedGlassShelf修改1"); |
| | | }else{ |
| | | if(finishedGlassShelfInformationList.size()==0){ |
| | | finishedGlassShelfMapper.insetFinishedGlassShelfInformation(finishedGlassShelfInformation); |
| | | log.setFunction("saveFinishedGlassShelf新增"); |
| | | }else if(finishedGlassShelfInformationList.size()==1){ |
| | | finishedGlassShelfMapper.updateFinishedGlassShelfInformationQuantity(finishedGlassShelfInformation.getTotalQuantity(),finishedGlassShelfInformationList.get(0).getId()); |
| | | log.setFunction("saveFinishedGlassShelf修改2"); |
| | | }else{ |
| | | saveState = "false"; |
| | | int index=finishedGlassShelfMapper.getSelectFinishedGlassShelfInformationInventoryArea(inventoryArea); |
| | | for (int i=1;i<=quantity;i++){ |
| | | index++; |
| | | finishedGlassShelfMapper.insetFinishedGlassShelfInformation(finishedGlassShelfInformation,inventoryArea+index); |
| | | } |
| | | log.setFunction("saveFinishedGlassShelf新增"); |
| | | |
| | | if(saveState.equals("true")){ |
| | | finishedGlassShelfMapper.insetFinishedGlassShelfLog(finishedGlassShelfInformation); |
| | | } |
| | | finishedGlassShelfMapper.insetFinishedGlassShelfLog(finishedGlassShelfInformation,quantity); |
| | | |
| | | } |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | logService.saveLog(log); |
| | | |
| | |
| | | |
| | | } |
| | | |
| | | public Map<String, Object> getSelectFinishedGlassShelfInformation(Integer pageNum, Integer pageSize) { |
| | | public Map<String, Object> getSelectFinishedGlassShelfInformation(Integer pageNum, Integer pageSize,String type) { |
| | | Integer offset = (pageNum - 1) * pageSize; |
| | | Map<String, Object> map = new HashMap<>(); |
| | | map.put("data", finishedGlassShelfMapper.getSelectFinishedGlassShelfInformationDate(offset, pageSize)); |
| | | map.put("total", finishedGlassShelfMapper.getSelectFinishedGlassShelfInformationDatePageTotal(offset, pageSize)); |
| | | if(type.equals("1")){ |
| | | map.put("data", finishedGlassShelfMapper.getSelectFinishedGlassShelfInformationDate(offset, pageSize)); |
| | | map.put("total", finishedGlassShelfMapper.getSelectFinishedGlassShelfInformationDatePageTotal(offset, pageSize)); |
| | | }else{ |
| | | map.put("data", finishedGlassShelfMapper.getSelectFinishedGlassShelfInformationDateDetail(offset, pageSize)); |
| | | map.put("total", finishedGlassShelfMapper.getSelectFinishedGlassShelfInformationDateDetailPageTotal(offset, pageSize)); |
| | | } |
| | | return map; |
| | | } |
| | | |
| | |
| | | |
| | | } |
| | | |
| | | public Map<String, Object> getSelectFinishedGlassShelfInformationDetails(Integer pageNum, Integer pageSize, String ids) { |
| | | if (ids.startsWith("\"") && ids.endsWith("\"")) { |
| | | ids = ids.substring(1, ids.length() - 1); // 去除首尾引号 |
| | | } |
| | | List<Long> id=new ArrayList<>();; |
| | | if(ids!=null && !ids.isEmpty()){ |
| | | List<String> result = StrUtil.split(ids, '|'); |
| | | id=result.stream().map(Long::valueOf).collect(Collectors.toList()); |
| | | } |
| | | public Map<String, Object> getSelectFinishedGlassShelfInformationDetails(Integer pageNum, Integer pageSize, List<Map<String, Object>> object) { |
| | | |
| | | Map<String, Object> map = new HashMap<>(); |
| | | map.put("data", finishedGlassShelfMapper.getSelectFinishedGlassShelfInformationInId(id)); |
| | | List<Map<String, Object>> mapList=new ArrayList<>(); |
| | | for(Map<String, Object> objectMap:object){ |
| | | mapList.add(finishedGlassShelfMapper.getSelectFinishedGlassShelfInformationInId( |
| | | objectMap.get("glassShelfName").toString(), |
| | | Double.parseDouble(objectMap.get("price").toString()), |
| | | objectMap.get("unit").toString(), |
| | | Double.parseDouble(objectMap.get("weight").toString()), |
| | | Double.parseDouble(objectMap.get("width").toString()), |
| | | Double.parseDouble(objectMap.get("height").toString()) |
| | | )); |
| | | |
| | | } |
| | | map.put("data", mapList); |
| | | return map; |
| | | } |
| | | |
| | |
| | | List<FinishedGlassShelfEmitDetails> finishedGlassShelfEmitDetailsList2 = finishedGlassShelfMapper.getSelectFinishedGlassShelfEmitDetailsByemitId1(emitId); |
| | | if (!finishedGlassShelfEmitDetailsList2.isEmpty()) { |
| | | for (FinishedGlassShelfEmitDetails finishedGlassShelfEmitDetails : finishedGlassShelfEmitDetailsList2) { |
| | | finishedGlassShelfMapper.updateInformationAvailableQuantityInt(finishedGlassShelfEmitDetails); |
| | | finishedGlassShelfMapper.updateInformationAvailableQuantityInt( |
| | | finishedGlassShelfEmitDetails.getMaxWeight(), |
| | | finishedGlassShelfEmitDetails.getMaxWidth(), |
| | | finishedGlassShelfEmitDetails.getMaxHeight(), |
| | | finishedGlassShelfEmitDetails.getQuantity(), |
| | | finishedGlassShelfEmitDetails.getPrice(), |
| | | finishedGlassShelfEmitDetails.getUnit(), |
| | | finishedGlassShelfEmitDetails.getGlassShelfName()); |
| | | finishedGlassShelfMapper.deleteFinishedGlassShelfEmitDetails(emitId); |
| | | finishedGlassShelfMapper.updateFinishedGlassShelfEmitDetailsLog(emitId); |
| | | finishedGlassShelfMapper.deleteFinishedGlassShelfEmitDetailsLog(emitId); |
| | | } |
| | | } |
| | | |
| | |
| | | int index=1; |
| | | for (FinishedGlassShelfEmitDetails finishedGlassShelfEmitDetails:finishedGlassShelfEmitDetailsList){ |
| | | finishedGlassShelfEmitDetails.setMoney(finishedGlassShelfEmitDetails.getPrice()*finishedGlassShelfEmitDetails.getQuantity()); |
| | | finishedGlassShelfMapper.updateInformationAvailableQuantityOut(finishedGlassShelfEmitDetails); |
| | | finishedGlassShelfMapper.updateInformationAvailableQuantityOut( |
| | | finishedGlassShelfEmitDetails.getMaxWeight(), |
| | | finishedGlassShelfEmitDetails.getMaxWidth(), |
| | | finishedGlassShelfEmitDetails.getMaxHeight(), |
| | | finishedGlassShelfEmitDetails.getQuantity(), |
| | | finishedGlassShelfEmitDetails.getPrice(), |
| | | finishedGlassShelfEmitDetails.getUnit(), |
| | | finishedGlassShelfEmitDetails.getGlassShelfName()); |
| | | finishedGlassShelfMapper.insertFinishedGlassShelfEmitDetails(oddNumber,index,finishedGlassShelfEmitDetails); |
| | | finishedGlassShelfMapper.insertFinishedGlassShelfEmitDetailsLog( |
| | | oddNumber, |
| | | index, |
| | | 1, |
| | | finishedGlassShelfEmitDetails.getGlassShelfNumber(), |
| | | finishedGlassShelfEmitDetails.getGlassShelfName(), |
| | | finishedGlassShelfEmitDetails.getQuantity(), |
| | | finishedGlassShelfEmitDetails.getPrice(), |
| | | finishedGlassShelfEmitDetails.getMoney(), |
| | | finishedGlassShelfEmitDetails.getUnit(), |
| | | finishedGlassShelfEmitDetails.getRemarks() |
| | | finishedGlassShelfEmitDetails.getRemarks(), |
| | | finishedGlassShelfEmitDetails.getMaxWeight(), |
| | | finishedGlassShelfEmitDetails.getMaxWidth(), |
| | | finishedGlassShelfEmitDetails.getMaxHeight(), |
| | | finishedGlassShelfEmitDetails.getGlassShelfName(), |
| | | object.get("userName").toString() |
| | | ); |
| | | index++; |
| | | } |
| | |
| | | List<FinishedGlassShelfEmitDetails> finishedGlassShelfEmitDetailsList2 = finishedGlassShelfMapper.getSelectFinishedGlassShelfEmitDetailsByemitId1(emitId); |
| | | if (!finishedGlassShelfEmitDetailsList2.isEmpty()) { |
| | | for (FinishedGlassShelfEmitDetails finishedGlassShelfEmitDetails : finishedGlassShelfEmitDetailsList2) { |
| | | finishedGlassShelfMapper.updateInformationAvailableQuantityInt(finishedGlassShelfEmitDetails); |
| | | finishedGlassShelfMapper.updateInformationAvailableQuantityInt( |
| | | finishedGlassShelfEmitDetails.getMaxWeight(), |
| | | finishedGlassShelfEmitDetails.getMaxWidth(), |
| | | finishedGlassShelfEmitDetails.getMaxHeight(), |
| | | finishedGlassShelfEmitDetails.getQuantity(), |
| | | finishedGlassShelfEmitDetails.getPrice(), |
| | | finishedGlassShelfEmitDetails.getUnit(), |
| | | finishedGlassShelfEmitDetails.getGlassShelfName()); |
| | | finishedGlassShelfMapper.deleteFinishedGlassShelfEmitDetailsLog(emitId); |
| | | } |
| | | finishedGlassShelfMapper.deleteFinishedGlassShelfEmitDetails(emitId); |
| | |
| | | if (!finishedGlassShelfWithdrawDetailsList2.isEmpty()) { |
| | | for (FinishedGlassShelfWithdrawDetails finishedGlassShelfWithdrawDetails : finishedGlassShelfWithdrawDetailsList2) { |
| | | finishedGlassShelfMapper.updateEmitDetailsWithdrawQuantityOut(finishedGlassShelfWithdrawDetails); |
| | | finishedGlassShelfMapper.updateInformationAvailableQuantityOut( |
| | | finishedGlassShelfWithdrawDetails.getMaxWeight(), |
| | | finishedGlassShelfWithdrawDetails.getMaxWidth(), |
| | | finishedGlassShelfWithdrawDetails.getMaxHeight(), |
| | | finishedGlassShelfWithdrawDetails.getQuantity(), |
| | | finishedGlassShelfWithdrawDetails.getPrice(), |
| | | finishedGlassShelfWithdrawDetails.getUnit(), |
| | | finishedGlassShelfWithdrawDetails.getGlassShelfName() |
| | | ); |
| | | finishedGlassShelfMapper.deleteFinishedGlassShelfWithdrawDetails(withdrawId); |
| | | finishedGlassShelfMapper.updateFinishedGlassShelfEmitDetailsLog(withdrawId); |
| | | finishedGlassShelfMapper.deleteFinishedGlassShelfEmitDetailsLog(withdrawId); |
| | | } |
| | | } |
| | | |
| | |
| | | if(finishedGlassShelfWithdrawDetails.getQuantity()>0){ |
| | | finishedGlassShelfWithdrawDetails.setMoney(finishedGlassShelfWithdrawDetails.getPrice()*finishedGlassShelfWithdrawDetails.getQuantity()); |
| | | finishedGlassShelfMapper.updateEmitDetailsWithdrawQuantityInt(finishedGlassShelfWithdrawDetails); |
| | | finishedGlassShelfMapper.updateInformationAvailableQuantityInt( |
| | | finishedGlassShelfWithdrawDetails.getMaxWeight(), |
| | | finishedGlassShelfWithdrawDetails.getMaxWidth(), |
| | | finishedGlassShelfWithdrawDetails.getMaxHeight(), |
| | | finishedGlassShelfWithdrawDetails.getQuantity(), |
| | | finishedGlassShelfWithdrawDetails.getPrice(), |
| | | finishedGlassShelfWithdrawDetails.getUnit(), |
| | | finishedGlassShelfWithdrawDetails.getGlassShelfName() |
| | | ); |
| | | finishedGlassShelfMapper.insertFinishedGlassShelfWithdrawDetails(oddNumber,index,finishedGlassShelfWithdrawDetails); |
| | | finishedGlassShelfMapper.insertFinishedGlassShelfEmitDetailsLog( |
| | | oddNumber, |
| | | index, |
| | | 2, |
| | | finishedGlassShelfWithdrawDetails.getGlassShelfNumber(), |
| | | finishedGlassShelfWithdrawDetails.getGlassShelfName(), |
| | | finishedGlassShelfWithdrawDetails.getQuantity(), |
| | | finishedGlassShelfWithdrawDetails.getPrice(), |
| | | finishedGlassShelfWithdrawDetails.getMoney(), |
| | | finishedGlassShelfWithdrawDetails.getUnit(), |
| | | finishedGlassShelfWithdrawDetails.getRemarks() |
| | | finishedGlassShelfWithdrawDetails.getRemarks(), |
| | | finishedGlassShelfWithdrawDetails.getMaxWeight(), |
| | | finishedGlassShelfWithdrawDetails.getMaxWidth(), |
| | | finishedGlassShelfWithdrawDetails.getMaxHeight(), |
| | | finishedGlassShelfWithdrawDetails.getGlassShelfName(), |
| | | object.get("userName").toString() |
| | | ); |
| | | index++; |
| | | } |
| | |
| | | if (!finishedGlassShelfWithdrawDetailsList2.isEmpty()) { |
| | | for (FinishedGlassShelfWithdrawDetails finishedGlassShelfWithdrawDetails : finishedGlassShelfWithdrawDetailsList2) { |
| | | finishedGlassShelfMapper.updateEmitDetailsWithdrawQuantityOut(finishedGlassShelfWithdrawDetails); |
| | | finishedGlassShelfMapper.updateInformationAvailableQuantityOut( |
| | | finishedGlassShelfWithdrawDetails.getMaxWeight(), |
| | | finishedGlassShelfWithdrawDetails.getMaxWidth(), |
| | | finishedGlassShelfWithdrawDetails.getMaxHeight(), |
| | | finishedGlassShelfWithdrawDetails.getQuantity(), |
| | | finishedGlassShelfWithdrawDetails.getPrice(), |
| | | finishedGlassShelfWithdrawDetails.getUnit(), |
| | | finishedGlassShelfWithdrawDetails.getGlassShelfName() |
| | | ); |
| | | finishedGlassShelfMapper.deleteFinishedGlassShelfEmitDetailsLog(withdrawId); |
| | | } |
| | | |