AskGoodsMapper.java 8.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258
  1. package com.tld.mapper;
  2. import com.tld.model.*;
  3. import com.tld.model.Error;
  4. import org.apache.ibatis.annotations.Mapper;
  5. import org.apache.ibatis.annotations.Param;
  6. import java.util.List;
  7. import java.util.Map;
  8. @Mapper
  9. public interface AskGoodsMapper {
  10. int getAskGoods(AskGoods askGoods);
  11. void updateAskGoodsNum(AskGoods askGoods);
  12. void addAskGoods(AskGoods askGoods);
  13. int getAskGoodsf(AskGoods askGoods);
  14. void addAskGoodsf(AskGoods askGoods);
  15. List<AskGoods> getAskGoodsfList(AskGoods askGoods);
  16. List<AskGoods> getAskGoodsMaterial(AskGoods askGoods);
  17. List<Inventory> getMaterialCk(AskGoods askGoods);
  18. void addAskGoodsVitrual(AskGoods askGoods);
  19. void addAskGoodsLog(AskGoods askGoods);
  20. Inventory getInventory(AskGoods askGoods);
  21. AskGoods getAsk(Inventory inventory);
  22. Map<String, Object> getScanIsNot(AskGoods askGoods);
  23. AskGoods getAsknInfo(AskGoods askGoods);
  24. int getAskInfoNumVitrual(AskGoods askGoods);
  25. int getInventoryAlready(AskGoods askGoods);
  26. List<AskGoods> getVirtualUniqueCode(@Param("uniqueCode")String uniqueCode, @Param("type")String type, @Param("askGoodsId")String askGoodsId);
  27. void deleteInventory(Inventory inventory);
  28. void updateInventory(Inventory inventory);
  29. void deleteVirtual(String id);
  30. void addRemoval(AskGoods askGoods);
  31. String getMaterialId(@Param("wllbCode") String wllbCode);
  32. AskGoods getAskDetailed(@Param("askGoodsId") String askGoodsId, @Param("materialId") String materialId, @Param("entryNumber")String entryNumber);
  33. void addReturnGsRemoval(ReturRemoval returRemoval);
  34. AskGoods getAskDetailedF(String askGoodsId);
  35. void addReturnGsRemovalF(ReturRemoval returRemoval1);
  36. int getReturnRemovalCount();
  37. List<Map<String, Object>> plugOutRemoval(String removalCode);
  38. List<Map<String, Object>> getRemovalz(@Param("askGoodsId")String askGoodsId, @Param("warehouseWhere")String warehouseWhere);
  39. List<AskGoods> getRemoval(AskGoods askGoods);
  40. List<Map<String, Object>> export(AskGoods askGoods);
  41. List<AskGoods> getAskGoodsVitrual(@Param("uniqueCode")String uniqueCode, @Param("type")String type);
  42. void delAskGoodsVitrual(@Param("id")String id, @Param("type")String type);
  43. void updateOutNum(@Param("num")String num, @Param("askGoodsId")String askGoodsId, @Param("materialId")String materialId, @Param("entryNumber")String entryNumber);
  44. String getScanNum(AskGoods askGoods);
  45. List<AskGoods> getGoodsHalf(AskGoods askGoods);
  46. List<AskGoods> getRemovalHalfProduct(AskGoods askGoods);
  47. List<Map<String, Object>> getRemovalHalfProductExcel(AskGoods askGoods);
  48. List<AskGoods> getRemovalHalf(AskGoods askGoods);
  49. List<Map<String, Object>> getRemovalHalfExcel(AskGoods askGoods);
  50. List<Inventory> getInventoryInfo(AskGoods askGoods);
  51. List<String> getWarehouseWhere(String removalCode);
  52. void delPlugOutRemoval(@Param("removalCode") String removalCode);
  53. void delRemovalz(@Param("removalCode") String removalCode);
  54. void addAccess(@Param("names") String names, @Param("returnGsRemoval") String returnGsRemoval, @Param("accessType") String accessType);
  55. void delPlugOutWarehousing(@Param("orderNumber") String orderNumber);
  56. Map<String, Object> getInventoryNotice(@Param("id") String id);
  57. void delInventoryNotice(@Param("id") String id);
  58. Map<String, Object> getDelAskGoods(String id);
  59. void delAskGoods(String id);
  60. List<Map<String, Object>> getGsRemoval(@Param("removalCode") String removalCode);
  61. AskGoods getWareInfo(AskGoods askGoods);
  62. Inventory getInventoryWarehousing(AskGoods askGoods);
  63. List<Inventory> getInventoryInfoOther(AskGoods askGoods);
  64. List<String> getSupplyWarehouseWhere(@Param("removalCode") String removalCode);
  65. List<Map<String, Object>> getReturnWarehouseTransfer(@Param("removalCode") String removalCode);
  66. String getSupplyWarehouseWheres(@Param("removalCode") String removalCode);
  67. List<Map<String, Object>> getReturnWarehouseTransferZ(@Param("warehouseTransferId") String warehouseTransferId, @Param("warehouseWhere") String warehouseWhere);
  68. void delReturnWarehouseTransfer(@Param("removalCode") String removalCode);
  69. void delReturnWarehouseTransferZ(@Param("warehouseTransferTd") String warehouseTransferTd);
  70. String getMing(String code);
  71. ReturnWarehousing getReturnGsWarehousing(@Param("removalCode") String removalCode);
  72. List<Map<String,Object>> getStorageLocationWarehouseWhere(@Param("removalCode") String removalCode);
  73. List<Map<String, Object>> getNoticeParent(@Param("orderNumber") String orderNumber);
  74. List< Map<String, Object>> getNoticeSubtabulation(String noticeId);
  75. void delNoticeParent(@Param("orderNumber") String orderNumber);
  76. void delNoticeSubtabulation(@Param("orderNumber") String orderNumber);
  77. String getAmount(AskGoods goods);
  78. void updateRemoval(@Param("removalCode")String removalCode, @Param("material")String material);
  79. void updateRemovalHalfProduct(String wmsCode);
  80. void updateRemovalHalf(String wmsCode);
  81. List<ReturnWarehousing> getReturnGsOtherWarehousing(@Param("removalCode") String removalCode);
  82. List<Map<String, Object>> getNoticesParent(@Param("noticeId") String noticeId , @Param("storageLocationCode") String storageLocationCode);
  83. List<Map<String, Object>> getNoticesSubtabulation(@Param("noticeId") String noticeId,@Param("warehouseWhere") String warehouseWhere);
  84. void delNoticesParent(@Param("noticeId") String noticeId);
  85. void delNoticesSubtabulation(@Param("noticeId") String noticeId);
  86. List<Map<String,Object>> getCreateOtherInStockWarehouseWhere(@Param("removalCode") String removalCode);
  87. void delReturnGsWarehousing(@Param("orderNumber") String orderNumber);
  88. List<Map<String, Object>> getCreateOtherDeliveryMaterialsWarehouseWhere(@Param("removalCode") String removalCode);
  89. List<Map<String, Object>> getCreateOtherDeliveryMaterialsParent(@Param("documentId") String documentId);
  90. void updateEnquiryOutNum(AskGoods askGoods);
  91. List<Map<String, Object>> getGsRemovals(@Param("removalCode") String removalCode);
  92. List<String> getWarehouseWheres(@Param("removalCode") String removalCode);
  93. void UpdSerial(AskGoods askGoods);
  94. List<Map<String, Object>> test03();
  95. List<Map<String, Object>> test04();
  96. void importExcel(List<OutgoingReturn> list);
  97. List<OutgoingReturn> getOutgoingReturnList();
  98. String getLocationCode(@Param("warehouse") String warehouse);
  99. List<ReturRemoval> getOutgoingReturn();
  100. List<ReceiveGoods> getReturnInStorageF();
  101. List<ReceiveGoods> getReturnInStorageZ(@Param("orderCode") String orderCode);
  102. String getMaterialPartType(@Param("materialId") String materialId);
  103. void addReturnWarehousing(ReturnWarehousing returnWarehousing);
  104. List<Error> getOutgoingReturnError();
  105. void marketImport(List<MarketReturn> list);
  106. List<MarketReturn> getMarketList();
  107. Delivery getDeliveryF(@Param("deliveryOrder") String deliveryOrder);
  108. List<Delivery> getDeliveryZ(@Param("deliveryId") String deliveryId, @Param("materialId") String materialId);
  109. void marketImports(List<MarketReturn> list);
  110. List<Map<String, Object>> getStorage(List<MarketReturn> list);
  111. List<Error> getStorageReturnError();
  112. List<Error> parkingReturnError();
  113. List<WarehouseTransfer> shiftingParkingReturn();
  114. List<AskGoods> getAskGoodsMaterialNot(AskGoods askGoods);
  115. List<AskGoods> getAskGoodsMaterialTest(AskGoods askGoods);
  116. List<Error> otherWarehousingReturnError();
  117. List<Error> getJsonError();
  118. void updJSONError(Error error);
  119. List<Error> getProductionReturnError();
  120. List<ReturRemoval> getMergeGsF();
  121. List<ReturRemoval> getMergeGsZ(ReturRemoval returRemoval);
  122. List<Error> getjsonErrorParking();
  123. String getMaterialCode(@Param("material") String material);
  124. void updErrorParking(Error error);
  125. List<ReturRemoval> getCallback();
  126. List<Error> getErrorParkingReturn();
  127. List<Map<String, Object>> getCallPlugOutWarehousing();
  128. String getUserName(@Param("userName") String userName);
  129. void addInventory(Inventory inventory);
  130. List<Map<String, Object>> getCallWorkOrder();
  131. void DelOutgoingReturnList(OutgoingReturn outgoingReturn);
  132. }