package com.tld.mapper;

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

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

@Mapper
public interface WarehousingMapper {
    List<MaterialClass> getMaterialClass(String wllbCode);

    List<MaterialClass> getMaterialClassType(String wllbCode);

    void addWarehousingVirtual(WarehousingVirtual warehousingVirtual);

    Map<String, Object> getScanNum(@Param("storageLocationCode")String storageLocationCode, @Param("num")String num);

    List<StorageLocation> recommend(String storageLocationCode);

    String getIsNotSisable(String wllbCode);

    List<StorageLocation> getIsNotSisableLocation(String isNotDisable);

    void delWarehousingVirtual(WarehousingVirtual warehousingVirtual);

    List<WarehousingVirtual> getVirtual(@Param("uniqueCode")String uniqueCode, @Param("type")String type, @Param("warehouseTransferId")String askGoodsId);

    List<ReceiveGoods> getReceiveGoods(WarehousingVirtual warehousingVirtual);

    void updateReceiveGood(ReceiveGoods receiveGoods1);

    WarehousingVirtual getWlClass(WarehousingVirtual warehousingVirtual);

    void addStorage(List<WarehousingVirtual> list);

    void addInventory(List<WarehousingVirtual> list);

    void delVirtual(String uniqueCode);

    int getWarehousingCount();

    void addReturnWarehousing(ReturnWarehousing returnWarehousing);

    List<ReturnWarehousing> getPlugOutWarehousing(String orderNumber);

    List<Storage> warehousingFlowing(Storage storage);

    List<WarehousingVirtual> getWarehousingVirtual(@Param("uniqueCode")String uniqueCode, @Param("type")String type, @Param("warehouseTransferId")String warehouseTransferId);

    List<Map<String, Object>> export(Storage storage);

    Map<String, Object> getScanIsNot(@Param("wllbCode")String wllbCode, @Param("suppId")String suppId, @Param("unique")String unique, @Param("producDate")String producDate, @Param("warehouseWhere")String warehouseWhere);

    MaterialClass getMateriaIsExist(String wllbCode);

    List<String> getInventoryProduc(@Param("wllbCode")String wllbCode, @Param("producDate")String producDate, @Param("storageLocationCode")String storageLocationCode);

    List<Notice> getNotice(Notice notice);

    Notice getNoticeId(Notice notice);

    void addInventoryNotice(Notice notice);

    int getInventoryNotice(Notice notice);

    void updateInventoryNotice(Notice notice);

    Inventory getHalfInventory(Notice notice);

    void updateInventoryNoticeNum(Notice notice);

    void delInventoryNotice(Notice notice);

    void addProduct(WarehousingVirtual warehousingVirtual);

    List<Notice> getProduct(Notice notice);

    List<Map<String, Object>> productExcel(Notice notice);

    AskGoods getAskGoodsHalf(Notice notice);

    void updateAskGoodsHalf(@Param("id")String id, @Param("warehousingNum")String warehousingNum);

    void addRemovalHalfProduct(AskGoods askGoods1);

    MaterialClass getMaterial(Notice notice);

    Inventory getInventoryInfo(StorageLocation storageLocation1);

    void addHalf(WarehousingVirtual warehousingVirtual);

    List<WarehousingVirtual> getVirtualNotice(@Param("uniqueCode")String uniqueCode, @Param("type")String type, @Param("noticeId")String noticeId);

    List<Notice> getHalf(Notice notice);

    List<Map<String, Object>> getHalfExcel(Notice notice);

    int getSumScanNumVal(Notice notice1);

    void updateNotice(Notice notice2);

    Map<String, Object> getScanIsNotProduct(Notice notice);

    String getStorageLocationCode(@Param("attribute")String attribute, @Param("symbol")String symbol, @Param("producBatch")String producBatch, @Param("materialId")String materialId, @Param("companyNumber")String companyNumber);

    int getCountStorage(@Param("attribute")String attribute, @Param("storageLocationCode")String storageLocationCode, @Param("symbol")String symbol, @Param("producBatch")String producBatch, @Param("materialId")String materialId);

    void updateStorage(WarehousingVirtual warehousingVirtual1);

    int getNumUtil(String type);

    void updateInventoryOther(Inventory inventory);

    void addReturnWarehousingOther(WarehousingVirtual warehousingVirtual);

    void updateVitrualNum(Inventory inventory1);

    void addInventoryOther(Inventory inventory);

    Map<String, Object> getSumWarehousingVirtual(WarehousingVirtual warehousingVirtual);
}