| | |
| | | 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); |
| | | } |
| | | } |
| | | |
| | | oddNumber = emitId; |
| | | finishedGlassShelfMapper.updateFinishedGlassShelfEmit(finishedGlassShelfEmit, oddNumber); |
| | | log.setFunction("insertDelivery修改:"+oddNumber); |
| | | log.setFunction("insertEmit修改:"+oddNumber); |
| | | } else { |
| | | //获取单号 |
| | | oddNumber = orderNumberSetting("出库"); |
| | |
| | | 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,finishedGlassShelfEmitDetails); |
| | | finishedGlassShelfMapper.insertFinishedGlassShelfEmitDetailsLog( |
| | | oddNumber, |
| | | index, |
| | | 1, |
| | | finishedGlassShelfEmitDetails.getQuantity(), |
| | | finishedGlassShelfEmitDetails.getPrice(), |
| | | finishedGlassShelfEmitDetails.getMoney(), |
| | | finishedGlassShelfEmitDetails.getUnit(), |
| | | finishedGlassShelfEmitDetails.getRemarks(), |
| | | finishedGlassShelfEmitDetails.getMaxWeight(), |
| | | finishedGlassShelfEmitDetails.getMaxWidth(), |
| | | finishedGlassShelfEmitDetails.getMaxHeight(), |
| | | finishedGlassShelfEmitDetails.getGlassShelfName(), |
| | | object.get("userName").toString() |
| | | ); |
| | | index++; |
| | | } |
| | | logService.saveLog(log); |
| | |
| | | //将异常传入数据库 |
| | | SysError sysError = new SysError(); |
| | | sysError.setError(e+Arrays.toString(e.getStackTrace())); |
| | | sysError.setFunc("insertDelivery"); |
| | | sysError.setFunc("insertFinishedGlassShelfEmit"); |
| | | sysErrorService.insert(sysError); |
| | | saveState = "false4"; |
| | | |
| | |
| | | FinishedGlassShelfEmit finishedGlassShelfEmit2 = finishedGlassShelfMapper.getSelectFinishedGlassShelfEmitByemitId(emitId); |
| | | |
| | | if (finishedGlassShelfEmit2 != null) { |
| | | //编辑还原数据 |
| | | List<FinishedGlassShelfEmitDetails> finishedGlassShelfEmitDetailsList2 = finishedGlassShelfMapper.getSelectFinishedGlassShelfEmitDetailsByemitId1(emitId); |
| | | if (!finishedGlassShelfEmitDetailsList2.isEmpty()) { |
| | | for (FinishedGlassShelfEmitDetails finishedGlassShelfEmitDetails : finishedGlassShelfEmitDetailsList2) { |
| | | finishedGlassShelfMapper.updateInformationAvailableQuantityInt(finishedGlassShelfEmitDetails); |
| | | finishedGlassShelfMapper.deleteFinishedGlassShelfEmitDetailsLog(emitId); |
| | | |
| | | if(finishedGlassShelfEmit2.getState()==0){ |
| | | //编辑还原数据 |
| | | List<FinishedGlassShelfEmitDetails> finishedGlassShelfEmitDetailsList2 = finishedGlassShelfMapper.getSelectFinishedGlassShelfEmitDetailsByemitId1(emitId); |
| | | if (!finishedGlassShelfEmitDetailsList2.isEmpty()) { |
| | | for (FinishedGlassShelfEmitDetails finishedGlassShelfEmitDetails : finishedGlassShelfEmitDetailsList2) { |
| | | finishedGlassShelfMapper.updateInformationAvailableQuantityInt( |
| | | finishedGlassShelfEmitDetails.getMaxWeight(), |
| | | finishedGlassShelfEmitDetails.getMaxWidth(), |
| | | finishedGlassShelfEmitDetails.getMaxHeight(), |
| | | finishedGlassShelfEmitDetails.getQuantity(), |
| | | finishedGlassShelfEmitDetails.getPrice(), |
| | | finishedGlassShelfEmitDetails.getUnit(), |
| | | finishedGlassShelfEmitDetails.getGlassShelfName()); |
| | | finishedGlassShelfMapper.deleteFinishedGlassShelfEmitDetailsLog(emitId); |
| | | } |
| | | finishedGlassShelfMapper.deleteFinishedGlassShelfEmitDetails(emitId); |
| | | finishedGlassShelfMapper.deleteFinishedGlassShelfEmit(emitId); |
| | | } |
| | | }else{ |
| | | saveState = "false1"; |
| | | } |
| | | |
| | | } |
| | | finishedGlassShelfMapper.deleteFinishedGlassShelfEmitDetails(emitId); |
| | | finishedGlassShelfMapper.deleteFinishedGlassShelfEmit(emitId); |
| | | |
| | | |
| | | Log log = new Log(); |
| | |
| | | log.setFunction("deleteFinishedGlassShelfEmit删除:"+emitId); |
| | | logService.saveLog(log); |
| | | |
| | | return "true"; |
| | | }catch (Exception e) { |
| | | TransactionAspectSupport.currentTransactionStatus().rollbackToSavepoint(savePoint); |
| | | //将异常传入数据库 |
| | |
| | | } |
| | | |
| | | |
| | | public String insertFinishedGlassShelfWithdraw(Map<String,Object> object) { |
| | | |
| | | String saveState = "true"; |
| | | //设置回滚点 |
| | | Object savePoint = TransactionAspectSupport.currentTransactionStatus().createSavepoint(); |
| | | |
| | | try { |
| | | String withdrawId=""; |
| | | String oddNumber = null; |
| | | if (object.get("withdrawId") != null) { |
| | | withdrawId = object.get("withdrawId").toString(); |
| | | } else { |
| | | withdrawId = ""; |
| | | } |
| | | FinishedGlassShelfWithdraw finishedGlassShelfWithdraw = JSONObject.parseObject(JSONObject.toJSONString(object.get("title")), FinishedGlassShelfWithdraw.class); |
| | | List<FinishedGlassShelfWithdrawDetails> finishedGlassShelfWithdrawDetailsList = JSONArray.parseArray(JSONObject.toJSONString(object.get("withdrawDetails")), FinishedGlassShelfWithdrawDetails.class); |
| | | //查询入库单是否存在 |
| | | FinishedGlassShelfWithdraw finishedGlassShelfWithdraw2 = finishedGlassShelfMapper.getSelectFinishedGlassShelfWithdrawByemitId(withdrawId); |
| | | |
| | | Log log = new Log(); |
| | | log.setOperator(object.get("userName").toString()); |
| | | log.setOperatorId(object.get("userId").toString()); |
| | | log.setContent(object.toString()); |
| | | |
| | | if (finishedGlassShelfWithdraw2 != null) { |
| | | //编辑还原数据 |
| | | List<FinishedGlassShelfWithdrawDetails> finishedGlassShelfWithdrawDetailsList2 = finishedGlassShelfMapper |
| | | .getSelectFinishedGlassShelfWithdrawDetailsBywithdrawId1(withdrawId); |
| | | 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.deleteFinishedGlassShelfEmitDetailsLog(withdrawId); |
| | | } |
| | | } |
| | | |
| | | oddNumber = withdrawId; |
| | | finishedGlassShelfMapper.updateFinishedGlassShelfWithdraw(finishedGlassShelfWithdraw, oddNumber); |
| | | log.setFunction("insertWithdraw修改:"+oddNumber); |
| | | } else { |
| | | //获取单号 |
| | | oddNumber = orderNumberSetting("入库"); |
| | | //新增出库数据 |
| | | finishedGlassShelfMapper.insertFinishedGlassShelfWithdraw(finishedGlassShelfWithdraw, oddNumber); |
| | | log.setFunction("insertFinishedGlassShelfWithdraw新增:"+oddNumber); |
| | | } |
| | | |
| | | //获取对象集合循环进行新增修改 |
| | | if (finishedGlassShelfWithdrawDetailsList.size()>0) { |
| | | int index=1; |
| | | for (FinishedGlassShelfWithdrawDetails finishedGlassShelfWithdrawDetails:finishedGlassShelfWithdrawDetailsList){ |
| | | 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.getQuantity(), |
| | | finishedGlassShelfWithdrawDetails.getPrice(), |
| | | finishedGlassShelfWithdrawDetails.getMoney(), |
| | | finishedGlassShelfWithdrawDetails.getUnit(), |
| | | finishedGlassShelfWithdrawDetails.getRemarks(), |
| | | finishedGlassShelfWithdrawDetails.getMaxWeight(), |
| | | finishedGlassShelfWithdrawDetails.getMaxWidth(), |
| | | finishedGlassShelfWithdrawDetails.getMaxHeight(), |
| | | finishedGlassShelfWithdrawDetails.getGlassShelfName(), |
| | | object.get("userName").toString() |
| | | ); |
| | | index++; |
| | | } |
| | | |
| | | } |
| | | getUpdateFinishedGlassShelfEmitState(finishedGlassShelfWithdrawDetailsList.get(0).getEmitId()); |
| | | logService.saveLog(log); |
| | | } else { |
| | | return "false3"; |
| | | } |
| | | }catch (Exception e) { |
| | | TransactionAspectSupport.currentTransactionStatus().rollbackToSavepoint(savePoint); |
| | | //将异常传入数据库 |
| | | SysError sysError = new SysError(); |
| | | sysError.setError(e+Arrays.toString(e.getStackTrace())); |
| | | sysError.setFunc("insertFinishedGlassShelfWithdraw"); |
| | | sysErrorService.insert(sysError); |
| | | saveState = "false4"; |
| | | |
| | | } |
| | | |
| | | return saveState; |
| | | } |
| | | |
| | | public void getUpdateFinishedGlassShelfEmitState(String emitId) { |
| | | List<FinishedGlassShelfEmitDetails> finishedGlassShelfEmitDetailsList2 = finishedGlassShelfMapper |
| | | .getSelectFinishedGlassShelfEmitDetailsByemitId1(emitId); |
| | | int sumWithdrawQuantity=0; |
| | | finishedGlassShelfMapper.updateFinishedGlassShelfEmitState(2,emitId); |
| | | for(FinishedGlassShelfEmitDetails finishedGlassShelfEmitDetails:finishedGlassShelfEmitDetailsList2){ |
| | | sumWithdrawQuantity+=finishedGlassShelfEmitDetails.getWithdrawQuantity(); |
| | | if(finishedGlassShelfEmitDetails.getQuantity()!=finishedGlassShelfEmitDetails.getWithdrawQuantity()){ |
| | | finishedGlassShelfMapper.updateFinishedGlassShelfEmitState(1,emitId); |
| | | } |
| | | } |
| | | if(sumWithdrawQuantity==0){ |
| | | finishedGlassShelfMapper.updateFinishedGlassShelfEmitState(0,emitId); |
| | | } |
| | | } |
| | | |
| | | |
| | | public Map<String, Object> getSelectFinishedGlassShelfWithdraw(Integer pageNum, Integer pageSize,List<String> selectDate, |
| | | FinishedGlassShelfWithdraw finishedGlassShelfWithdraw) throws JsonProcessingException { |
| | | Integer offset = (pageNum - 1) * pageSize; |
| | | String endDate = LocalDate.now().toString(); |
| | | String startDate = LocalDate.now().minusDays(15).toString(); |
| | | if(selectDate !=null && selectDate.size()==2){ |
| | | if(!selectDate.get(0).isEmpty()){ |
| | | startDate = selectDate.get(0); |
| | | } |
| | | if(!selectDate.get(1).isEmpty()){ |
| | | endDate = selectDate.get(1); |
| | | } |
| | | } |
| | | Map<String, Object> map = new HashMap<>(); |
| | | map.put("data", finishedGlassShelfMapper.getSelectFinishedGlassShelfWithdraw(offset, pageSize,startDate,endDate, finishedGlassShelfWithdraw)); |
| | | map.put("total", finishedGlassShelfMapper.getSelectFinishedGlassShelfWithdrawPageTotal(offset, pageSize,startDate,endDate, finishedGlassShelfWithdraw)); |
| | | List<String> list = new ArrayList<>(); |
| | | list.add(startDate); |
| | | list.add(endDate); |
| | | map.put("selectDate",list); |
| | | return map; |
| | | } |
| | | |
| | | public Map<String, Object> getSelectFinishedGlassShelfWithdrawDetails(Integer pageNum, Integer pageSize, String withdrawId) { |
| | | if (withdrawId.startsWith("\"") && withdrawId.endsWith("\"")) { |
| | | withdrawId = withdrawId.substring(1, withdrawId.length() - 1); // 去除首尾引号 |
| | | } |
| | | Map<String, Object> map = new HashMap<>(); |
| | | map.put("withdraw", finishedGlassShelfMapper.getSelectFinishedGlassShelfWithdrawByemitId(withdrawId)); |
| | | map.put("data", finishedGlassShelfMapper.getSelectFinishedGlassShelfWithdrawDetailsBywithdrawId(withdrawId)); |
| | | return map; |
| | | } |
| | | |
| | | |
| | | public String deleteFinishedGlassShelfWithdraw(Map<String,Object> object) { |
| | | String saveState = "true"; |
| | | //设置回滚点 |
| | | Object savePoint = TransactionAspectSupport.currentTransactionStatus().createSavepoint(); |
| | | try { |
| | | String withdrawId = ""; |
| | | if (object.get("withdrawId") != null) { |
| | | withdrawId = object.get("withdrawId").toString(); |
| | | } |
| | | FinishedGlassShelfWithdraw finishedGlassShelfWithdraw2 = finishedGlassShelfMapper.getSelectFinishedGlassShelfWithdrawByemitId(withdrawId); |
| | | |
| | | if (finishedGlassShelfWithdraw2 != null) { |
| | | //编辑还原数据 |
| | | List<FinishedGlassShelfWithdrawDetails> finishedGlassShelfWithdrawDetailsList2 = finishedGlassShelfMapper |
| | | .getSelectFinishedGlassShelfWithdrawDetailsBywithdrawId1(withdrawId); |
| | | 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); |
| | | } |
| | | |
| | | finishedGlassShelfMapper.deleteFinishedGlassShelfWithdrawDetails(withdrawId); |
| | | finishedGlassShelfMapper.deleteFinishedGlassShelfWithdraw(withdrawId); |
| | | getUpdateFinishedGlassShelfEmitState(finishedGlassShelfWithdrawDetailsList2.get(0).getEmitId()); |
| | | } |
| | | |
| | | |
| | | } |
| | | |
| | | |
| | | Log log = new Log(); |
| | | log.setOperatorId(object.get("userId").toString()); |
| | | log.setOperator(object.get("userName").toString()); |
| | | log.setContent(object.toString()); |
| | | log.setFunction("deleteFinishedGlassShelfWithdraw删除:"+withdrawId); |
| | | logService.saveLog(log); |
| | | |
| | | return "true"; |
| | | }catch (Exception e) { |
| | | TransactionAspectSupport.currentTransactionStatus().rollbackToSavepoint(savePoint); |
| | | //将异常传入数据库 |
| | | SysError sysError = new SysError(); |
| | | sysError.setError(e+Arrays.toString(e.getStackTrace())); |
| | | sysError.setFunc("deleteFinishedGlassShelfWithdraw"); |
| | | sysErrorService.insert(sysError); |
| | | saveState = "false"; |
| | | |
| | | } |
| | | return saveState; |
| | | |
| | | } |
| | | |
| | | |
| | | public Map<String, Object> getFinishedGlassShelfLogReport(String type,Integer pageNum, Integer pageSize, |
| | | List<String> selectDate, FinishedGlassShelfLog finishedGlassShelfLog) { |
| | | Integer offset = (pageNum-1)*pageSize; |
| | | String endDate = LocalDate.now().toString(); |
| | | String startDate = LocalDate.now().minusDays(15).toString(); |
| | | if(selectDate !=null && selectDate.size()==2){ |
| | | if(!selectDate.get(0).isEmpty()){ |
| | | startDate = selectDate.get(0); |
| | | } |
| | | if(!selectDate.get(1).isEmpty()){ |
| | | endDate = selectDate.get(1); |
| | | } |
| | | } |
| | | int state=0; |
| | | if(type.equals("料架出库")){ |
| | | state=1; |
| | | }else if(type.equals("料架入库")){ |
| | | state=2; |
| | | } |
| | | |
| | | Map<String, Object> map = new HashMap<>(); |
| | | System.out.println(finishedGlassShelfLog.getDocumentId()); |
| | | map.put("data", finishedGlassShelfMapper.getFinishedGlassShelfLogReport(offset, pageSize,startDate, endDate, finishedGlassShelfLog,state)); |
| | | map.put("total", finishedGlassShelfMapper.getFinishedGlassShelfLogReportTotal(offset, pageSize,startDate, endDate, finishedGlassShelfLog,state)); |
| | | List<String> list = new ArrayList<>(); |
| | | list.add(startDate); |
| | | list.add(endDate); |
| | | map.put("selectDate",list); |
| | | return map; |
| | | } |
| | | |
| | | public List<FinishedGlassShelfLog> exportFinishedGlassShelfLogReport(List<LocalDate> dates, String type) { |
| | | int state=0; |
| | | if(type.equals("料架出库")){ |
| | | state=1; |
| | | }else if(type.equals("料架入库")){ |
| | | state=2; |
| | | } |
| | | return finishedGlassShelfMapper.exportFinishedGlassShelfLogReport(dates,state); |
| | | } |
| | | |
| | | |
| | | |
| | | |