Subversion Repositories SmartDukaan

Rev

Rev 8689 | Rev 10120 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
4500 mandeep.dh 1
package in.shop2020.warehouse.persistence;
2
 
7613 amar.kumar 3
import in.shop2020.warehouse.InTransitInventory;
5185 mandeep.dh 4
import in.shop2020.warehouse.ScanType;
4500 mandeep.dh 5
import in.shop2020.warehouse.domain.InventoryItem;
6
 
5185 mandeep.dh 7
import java.util.List;
6484 amar.kumar 8
import java.util.Map;
4500 mandeep.dh 9
 
5361 mandeep.dh 10
import org.apache.ibatis.annotations.Param;
5185 mandeep.dh 11
 
5361 mandeep.dh 12
 
4500 mandeep.dh 13
public interface InventoryItemMapper {
14
 
15
    /**
16
     * @param inventoryItem
17
     */
18
    void insertInventoryItem(InventoryItem inventoryItem);
19
 
20
    /**
21
     * @param inventoryItemId
22
     * @return
23
     */
24
    InventoryItem getInventoryItem(long inventoryItemId);
25
 
26
    /**
27
     * @param serialNumber
28
     * @return
29
     */
30
    InventoryItem getInventoryItemFromSerialNumber(String serialNumber);
5185 mandeep.dh 31
 
32
    List<InventoryItem> getInventoryItemsFromLastScanType(ScanType scanType);
33
 
34
    /**
35
     * @param inventoryItemId
36
     * @return
37
     */
38
    InventoryItem getInventoryItemsFromId(long inventoryItemId);
39
 
40
    /**
41
     * @param inventoryItem
42
     */
43
    void update(InventoryItem inventoryItem);
5361 mandeep.dh 44
 
45
    /**
46
     * @param itemId
47
     * @param warehouseId
48
     * @return
49
     */
8565 amar.kumar 50
    InventoryItem getNonSerializedInventoryItem(@Param("itemNumber")String itemNumber, @Param("itemId")long itemId, 
51
    		@Param("warehouseId")long warehouseId, @Param("physicalWarehouseId")long physicalWarehouseId);
6467 amar.kumar 52
 
7957 amar.kumar 53
	Long getCurrentQuantityForNonSerializedItem(@Param("itemId")long itemId, @Param("warehouseId")long warehouseId, @Param("physicalWarehouseId")long physicalWarehouseId);
6467 amar.kumar 54
 
55
	void markPurchaseReturnIdForItem(@Param("id")long id, @Param("currentQuantity")long currentQuantity, @Param("purchaseReturnId")long purchaseReturnId);
56
 
8689 amar.kumar 57
	List<InventoryItem> getCurrentNonSerializedItemsByItemId(@Param("itemId")long itemId, @Param("warehouseId")long warehouseId, 
58
			@Param("physicalWarehouseId")long physicalWarehouseId);
6484 amar.kumar 59
 
60
	List<Map<String, Integer>> getCurrentSerializedInventory();
61
 
62
	List<Map<String, Integer>> getCurrentNonSerializedInventory();
6548 amar.kumar 63
 
64
	void markItemAsLost(@Param("id")long id, @Param("currentQuantity")long currentQuantity);
7410 amar.kumar 65
 
66
	//void markTransferLotAsRecieved(long id);
67
 
68
	List<InventoryItem> getInventoryItemsForTransferLot(long id);
69
 
70
	long getCurrentQuantityForNonSerializedItemInPhysicalWarehouse(@Param("itemId")long itemId,
71
			@Param("physicalWarehouseId")long physicalWarehouseId);
72
 
73
	List<InventoryItem> getCurrentNonSerializedItemsByItemIdInPhysicalWarehouse(
74
			@Param("itemId")long itemId, @Param("physicalWarehouseId")long physicalWarehouseId);
75
 
7574 amar.kumar 76
	long getCurrentQuantityForNonSerializedInTransitItemInPhysicalWarehouse(
77
			@Param("itemId")long itemId, @Param("physicalWarehouseId")long physicalWarehouseId);
78
 
7613 amar.kumar 79
	List<in.shop2020.warehouse.domain.InTransitInventory> getInTransitInventory(long originWarehouseId);
80
 
9129 amar.kumar 81
	List<InventoryItem> getCurrentInTransitInventoryInPhysicalWarehouse(
82
			@Param("itemId")long itemId, @Param("originWarehouseId")long originWarehouseId);
83
 
7410 amar.kumar 84
	/*InventoryItem getNonSeralizedInventoryItemForPhysicalWarehouse(
85
			@Param("itemNumber")String itemNumber, @Param("itemId")long itemId, @Param("physicalWarehouseId")long physicalWarehouseId);*/
4500 mandeep.dh 86
}