package com.tld.mapper;

import com.tld.model.*;
import com.tld.model.Error;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

@Mapper
public interface AskGoodsMapper {
    int getAskGoods(AskGoods askGoods);

    void updateAskGoodsNum(AskGoods askGoods);

    void addAskGoods(AskGoods askGoods);

    int getAskGoodsf(AskGoods askGoods);

    void addAskGoodsf(AskGoods askGoods);

    List<AskGoods> getAskGoodsfList(AskGoods askGoods);

    List<AskGoods> getAskGoodsMaterial(AskGoods askGoods);

    List<Inventory> getMaterialCk(AskGoods askGoods);

    void addAskGoodsVitrual(AskGoods askGoods);

    void addAskGoodsLog(AskGoods askGoods);

    Inventory getInventory(AskGoods askGoods);

    AskGoods getAsk(Inventory inventory);

    Map<String, Object> getScanIsNot(AskGoods askGoods);

    AskGoods getAsknInfo(AskGoods askGoods);

    int getAskInfoNumVitrual(AskGoods askGoods);

    int getInventoryAlready(AskGoods askGoods);

    List<AskGoods> getVirtualUniqueCode(@Param("uniqueCode")String uniqueCode, @Param("type")String type, @Param("askGoodsId")String askGoodsId);

    void deleteInventory(Inventory inventory);

    void updateInventory(Inventory inventory);

    void deleteVirtual(String id);

    void addRemoval(AskGoods askGoods);

    String getMaterialId(@Param("wllbCode") String wllbCode);

    AskGoods getAskDetailed(@Param("askGoodsId") String askGoodsId, @Param("materialId") String materialId, @Param("entryNumber")String entryNumber);

    void addReturnGsRemoval(ReturRemoval returRemoval);

    AskGoods getAskDetailedF(String askGoodsId);

    void addReturnGsRemovalF(ReturRemoval returRemoval1);

    int getReturnRemovalCount();


    List<Map<String, Object>> plugOutRemoval(String removalCode);

    List<Map<String, Object>> getRemovalz(@Param("askGoodsId")String askGoodsId, @Param("warehouseWhere")String warehouseWhere);

    List<AskGoods> getRemoval(AskGoods askGoods);

    List<Map<String, Object>> export(AskGoods askGoods);

    List<AskGoods> getAskGoodsVitrual(@Param("uniqueCode")String uniqueCode, @Param("type")String type);

    void delAskGoodsVitrual(@Param("id")String id, @Param("type")String type);

    void updateOutNum(@Param("num")String num, @Param("askGoodsId")String askGoodsId, @Param("materialId")String materialId, @Param("entryNumber")String entryNumber);

    String getScanNum(AskGoods askGoods);

    List<AskGoods> getGoodsHalf(AskGoods askGoods);

    List<AskGoods> getRemovalHalfProduct(AskGoods askGoods);

    List<Map<String, Object>> getRemovalHalfProductExcel(AskGoods askGoods);

    List<AskGoods> getRemovalHalf(AskGoods askGoods);

    List<Map<String, Object>> getRemovalHalfExcel(AskGoods askGoods);

    List<Inventory> getInventoryInfo(AskGoods askGoods);

    List<String> getWarehouseWhere(String removalCode);

    void delPlugOutRemoval(@Param("removalCode") String removalCode);

    void delRemovalz(@Param("removalCode") String removalCode);

    void addAccess(@Param("names") String names, @Param("returnGsRemoval") String returnGsRemoval, @Param("accessType") String accessType);

    void delPlugOutWarehousing(@Param("orderNumber") String orderNumber);

    Map<String, Object> getInventoryNotice(@Param("id") String id);

    void delInventoryNotice(@Param("id") String id);

    Map<String, Object> getDelAskGoods(String id);

    void delAskGoods(String id);

    List<Map<String, Object>> getGsRemoval(@Param("removalCode") String removalCode);

    AskGoods getWareInfo(AskGoods askGoods);

    Inventory getInventoryWarehousing(AskGoods askGoods);

    List<Inventory> getInventoryInfoOther(AskGoods askGoods);

    List<String> getSupplyWarehouseWhere(@Param("removalCode") String removalCode);

    List<Map<String, Object>> getReturnWarehouseTransfer(@Param("removalCode") String removalCode);

    String getSupplyWarehouseWheres(@Param("removalCode") String removalCode);

    List<Map<String, Object>>  getReturnWarehouseTransferZ(@Param("warehouseTransferId") String warehouseTransferId, @Param("warehouseWhere") String warehouseWhere);

    void delReturnWarehouseTransfer(@Param("removalCode") String removalCode);

    void delReturnWarehouseTransferZ(@Param("warehouseTransferTd") String warehouseTransferTd);

    String getMing(String code);

    ReturnWarehousing getReturnGsWarehousing(@Param("removalCode") String removalCode);

    List<Map<String,Object>>  getStorageLocationWarehouseWhere(@Param("removalCode") String removalCode);

    List<Map<String, Object>> getNoticeParent(@Param("orderNumber") String orderNumber);

    List< Map<String, Object>> getNoticeSubtabulation(String noticeId);

    void delNoticeParent(@Param("orderNumber") String orderNumber);

    void delNoticeSubtabulation(@Param("orderNumber") String orderNumber);

    String getAmount(AskGoods goods);

    void updateRemoval(@Param("removalCode")String removalCode, @Param("material")String material);

    void updateRemovalHalfProduct(String wmsCode);

    void updateRemovalHalf(String wmsCode);

    List<ReturnWarehousing> getReturnGsOtherWarehousing(@Param("removalCode") String removalCode);

    List<Map<String, Object>> getNoticesParent(@Param("noticeId") String noticeId , @Param("storageLocationCode") String storageLocationCode);

    List<Map<String, Object>> getNoticesSubtabulation(@Param("noticeId") String noticeId,@Param("warehouseWhere") String warehouseWhere);

    void delNoticesParent(@Param("noticeId") String noticeId);

    void delNoticesSubtabulation(@Param("noticeId") String noticeId);

    List<Map<String,Object>> getCreateOtherInStockWarehouseWhere(@Param("removalCode") String removalCode);

    void delReturnGsWarehousing(@Param("orderNumber") String orderNumber);

    List<Map<String, Object>> getCreateOtherDeliveryMaterialsWarehouseWhere(@Param("removalCode") String removalCode);

    List<Map<String, Object>> getCreateOtherDeliveryMaterialsParent(@Param("documentId") String documentId);

    void updateEnquiryOutNum(AskGoods askGoods);

    List<Map<String, Object>> getGsRemovals(@Param("removalCode") String removalCode);

    List<String> getWarehouseWheres(@Param("removalCode") String removalCode);

    void UpdSerial(AskGoods askGoods);

    List<Map<String, Object>> test03();

    List<Map<String, Object>> test04();

    void importExcel(List<OutgoingReturn> list);

    List<OutgoingReturn> getOutgoingReturnList();

    String getLocationCode(@Param("warehouse") String warehouse);

    List<ReturRemoval> getOutgoingReturn();

    List<ReceiveGoods> getReturnInStorageF();

    List<ReceiveGoods> getReturnInStorageZ(@Param("orderCode") String orderCode);

    String getMaterialPartType(@Param("materialId") String materialId);

    void addReturnWarehousing(ReturnWarehousing returnWarehousing);

    List<Error> getOutgoingReturnError();

    void marketImport(List<MarketReturn> list);


    List<MarketReturn> getMarketList();

    Delivery getDeliveryF(@Param("deliveryOrder") String deliveryOrder);

    List<Delivery> getDeliveryZ(@Param("deliveryId") String deliveryId, @Param("materialId") String materialId);

    void marketImports(List<MarketReturn> list);

    List<Map<String, Object>> getStorage(List<MarketReturn> list);

    List<Error> getStorageReturnError();

    List<Error> parkingReturnError();

    List<WarehouseTransfer> shiftingParkingReturn();

    List<AskGoods> getAskGoodsMaterialNot(AskGoods askGoods);

    List<AskGoods> getAskGoodsMaterialTest(AskGoods askGoods);

    List<Error> otherWarehousingReturnError();

    List<Error> getJsonError();

    void updJSONError(Error error);

    List<Error> getProductionReturnError();

    List<ReturRemoval> getMergeGsF();

    List<ReturRemoval> getMergeGsZ(ReturRemoval returRemoval);

    List<Error> getjsonErrorParking();

    String getMaterialCode(@Param("material") String material);

    void updErrorParking(Error error);

    List<ReturRemoval> getCallback();

    List<Error> getErrorParkingReturn();

    List<Map<String, Object>> getCallPlugOutWarehousing();

    String getUserName(@Param("userName") String userName);

    void addInventory(Inventory inventory);

    List<Map<String, Object>> getCallWorkOrder();

    void DelOutgoingReturnList(OutgoingReturn outgoingReturn);
}