Subversion Repositories SmartDukaan

package in.shop2020.warehouse.persistence;

import in.shop2020.warehouse.DoaOutInventoryItem;

import in.shop2020.warehouse.InTransitInventory;

import in.shop2020.warehouse.ScanType;

import in.shop2020.warehouse.domain.InventoryItem;

import java.util.Date;

import java.util.List;

import java.util.Map;

import org.apache.ibatis.annotations.MapKey;

import org.apache.ibatis.annotations.Param;

public interface InventoryItemMapper {

    /**

     * @param inventoryItem

     */

    void insertInventoryItem(InventoryItem inventoryItem);

    /**

     * @param inventoryItemId

     * @return

     */

    InventoryItem getInventoryItem(long inventoryItemId);

    /**

     * @param serialNumber

     * @return

     */

    InventoryItem getInventoryItemFromSerialNumber(String serialNumber);

	InventoryItem getInventoryItemInStockFromSerialNumber(String serialNumber);

    /**

     * @param serialNumber

     * @param serialNumber

     * @return

     */

    InventoryItem getInventoryItemFromSerialNumberWarehouse(@Param("serialNumber") String serialNumber, @Param("physicalWarehouseId") long billingWarehouseId);

    InventoryItem getInventoryItemSoldOnOrder(@Param("serialNumber") String serialNumber, @Param("physicalWarehouseId") long physicalWarehouseId, @Param("orderId") long orderId);

    List<InventoryItem> getInventoryItemsFromLastScanType(ScanType scanType);

    /**

     * @param inventoryItemId

     * @return

     */

    InventoryItem getInventoryItemsFromId(long inventoryItemId);

    /**

     * @param inventoryItem

     */

    void update(InventoryItem inventoryItem);

    /**

     * @param itemId

     * @param warehouseId

     * @return

     */

    InventoryItem getNonSerializedInventoryItem(@Param("itemNumber")String itemNumber, @Param("itemId")long itemId, 

    		@Param("warehouseId")long warehouseId, @Param("physicalWarehouseId")long physicalWarehouseId);

	Long getCurrentQuantityForNonSerializedItem(@Param("itemId")long itemId, @Param("warehouseId")long warehouseId, @Param("physicalWarehouseId")long physicalWarehouseId, @Param("purchaseId")long purchaseId);

	void markPurchaseReturnIdForItem(@Param("id")long id, @Param("currentQuantity")long currentQuantity, @Param("purchaseReturnId")long purchaseReturnId);

	void markPurchaseReturnIdForBadItem(@Param("id")long id, @Param("currentQuantity")long currentQuantity, @Param("purchaseReturnId")long purchaseReturnId);

	List<InventoryItem> getCurrentNonSerializedItemsByItemId(@Param("itemId")long itemId, @Param("warehouseId")long warehouseId, 

			@Param("physicalWarehouseId")long physicalWarehouseId, @Param("purchaseId")long purchaseId);

	List<InventoryItem> getNonSerializedItemsForBadInventory(@Param("itemId")long itemId, @Param("currentWarehouseId")long currentWarehouseId, 

			@Param("physicalWarehouseId")long physicalWarehouseId);

	List<Map<String, Integer>> getCurrentSerializedInventory();

	List<Map<String, Integer>> getCurrentNonSerializedInventory();

	void markItemAsLost(@Param("id")long id, @Param("currentQuantity")long currentQuantity);

	//void markTransferLotAsRecieved(long id);

	List<InventoryItem> getInventoryItemsForTransferLot(long id);

	long getCurrentQuantityForNonSerializedItemInPhysicalWarehouse(@Param("itemId")long itemId,

			@Param("physicalWarehouseId")long physicalWarehouseId);

	List<InventoryItem> getCurrentNonSerializedItemsByItemIdInPhysicalWarehouse(

			@Param("itemId")long itemId, @Param("physicalWarehouseId")long physicalWarehouseId);

	long getCurrentQuantityForNonSerializedInTransitItemInPhysicalWarehouse(

			@Param("itemId")long itemId, @Param("physicalWarehouseId")long physicalWarehouseId);

	List<in.shop2020.warehouse.domain.InTransitInventory> getInTransitInventory(long originWarehouseId);

	List<InventoryItem> getCurrentInTransitInventoryInPhysicalWarehouse(

			@Param("itemId")long itemId, @Param("originWarehouseId")long originWarehouseId);

	/*InventoryItem getNonSeralizedInventoryItemForPhysicalWarehouse(

			@Param("itemNumber")String itemNumber, @Param("itemId")long itemId, @Param("physicalWarehouseId")long physicalWarehouseId);*/

	List<InventoryItem> getTransferLotItemsForMarkReceive(

			@Param("transferLotId")long transferLotId,@Param("type")ScanType scanType);

	List<Long> getNonEmptyGrnsByDate(@Param("startDate") Date startDate, @Param("endDate") Date endDate);

	List<Long> getAllGrnsByDate(@Param("startDate") Date startDate, @Param("endDate") Date endDate);

	InventoryItem getSellableBadNonSerializedItem(@Param("itemId") long itemId, @Param("itemNumber") String itemNumber, 

			@Param("physicalWarehouseId") long physicalWarehouseId);

	List<InventoryItem> getInventoryItemScannedInForPO(@Param("itemId") long itemId,@Param("purchaseIds") List<Long> purchaseIds);

	List<InventoryItem> getInventoryItemsBySerailNumbers(@Param("serialNumbers") List<String> serialNumbers);

	Long getCurrentBadQuantityForItem(@Param("itemId") long itemId,@Param("currentWarehouseId") long currentWarehouseId, @Param("physicalWarehouseId") long physicalWarehouseId);

	@MapKey("itemId")

	Map<Integer, Integer> getItemsInPurchaseReturn(@Param("purchaseReturnId")long purchaseReturnId, @Param("type")ScanType type, @Param("returnTime")String returnTime);

	List<InventoryItem> getDoaOutInventoryItems(@Param("offset")long offset, @Param("limit")long limit);

	List<InventoryItem> getDoaOutSearchedItems(@Param("searchTerm")String searchTerm, @Param("offset")long offset, @Param("limit")long limit);

	long getCountForDoaOutInventoryItems();

	long getDoaOutInventoryItemsResultCount(@Param("searchTerm")String searchTerm);

	List<DoaOutInventoryItem> getAllDoaOutInventoryItems();

}