Subversion Repositories SmartDukaan

/**

 * 

 */

package in.shop2020.warehouse.persistence;

import in.shop2020.warehouse.domain.AmazonTransferredSkuDetail;

import in.shop2020.warehouse.DetailedPurchaseScan;

import in.shop2020.warehouse.InvAgeConsiderItems;

import in.shop2020.warehouse.InventoryAge;

import in.shop2020.warehouse.InventoryAvailability;

import in.shop2020.warehouse.InventoryMovement;

import in.shop2020.warehouse.InvoiceScan;

import in.shop2020.warehouse.ScanType;

import in.shop2020.warehouse.TransferInvoiceScan;

import in.shop2020.warehouse.domain.InventoryItem;

import in.shop2020.warehouse.domain.Scan;

import java.util.Date;

import java.util.List;

import org.apache.ibatis.annotations.Param;

/**

 * @author mandeep

 *

 */

public interface ScanMapper {

    /**

     * @param scan

     */

    void insert(Scan scan);

    /**

     * @param inventoryItemId

     * @param scanType

     * @return

     */

    List<Scan> get(@Param("inventoryItemId")long inventoryItemId, @Param("scanType")ScanType scanType);

    /**

     * @param orderId

     * @return

     */

    List<Scan> getScansFromOrderId(long orderId);

    /**

     * @param startDate

     * @param endDate

     * @return

     */

    List<DetailedPurchaseScan> getPurchaseScans(@Param("startDate")Date startDate, @Param("endDate")Date endDate);

    /**

     * @param date

     * @return

     */

    List<InvoiceScan> fetchMismatchScansPerInvoiceNumber(Date date);

    /**

     * @return

     */

    List<InventoryAge> getInventoryAge();

    List<Scan> getScansForItem(@Param("itemId") Long itemId, @Param("fromDate") Date fromDate, @Param("toDate") Date toDate);

	void genericScan(Scan scan);

	List<InventoryAvailability> getCurrentSerializedInventoryByScans(Long physicalWarehouseId);

	List<InventoryAvailability> getCurrentNonSerializedInventoryByScans(Long physicalWarehouseId);

	List<InventoryAvailability> getHistoricSerializedInventoryByScans(Date date);

	List<InventoryAvailability> getHistoricNonSerializedInventoryByScans(Date date);

	List<InventoryMovement> getMovementSerializedInventoryByScans(

			@Param("startDate") Date startDate, @Param("endDate") Date endDate);

	List<InventoryMovement> getMovementNonSerializedInventoryByScans(

			@Param("startDate") Date startDate, @Param("endDate") Date endDate);

	List<Scan> getScansForOrderAndItem(

			@Param("orderId") Long orderId, @Param("itemId") Long itemId);

	List<DetailedPurchaseScan> getPurchaseScansByGrnDate(@Param("startDate")Date startDate, @Param("endDate")Date endDate);

	List<InventoryMovement> getCompleteMovementSerializedInventoryByScans(

			@Param("startDate") Date startDate, @Param("endDate") Date endDate);

	List<InventoryMovement> getCompleteMovementNonSerializedInventoryByScans(

			@Param("startDate") Date startDate, @Param("endDate") Date endDate);

	List<Long> getTransferrableWarehousesFromWarehouse(Long warehouseId);

	List<Scan> getScansForTransferLot(long id);

	List<InventoryAvailability> getHistoricBadInventoryByScans(Date date);

	Scan getScansForTransferLotAndInventoryItem(@Param("transferLotId")long transferLotId, @Param("inventoryItemId")long inventoryItemId);

	List<InventoryAvailability> getOurHistoricSerializedInventoryByScans(

			Date date);

	List<InventoryAvailability> getOurHistoricNonSerializedInventoryByScans(

			Date date);

	List<AmazonTransferredSkuDetail> getAmazonTransferredSkuDetails(@Param("itemIds") List<Long> itemIds);

	List<Scan> getScansforPurchase(@Param("purchaseId")Long purchaseId, @Param("scanType")ScanType scanType);

	List<InvAgeConsiderItems> getInventoryAgeConsideredItems(@Param("itemId")Long itemId);

	List<InventoryMovement> getCompleteMovementForThirdPartyWarehouse(

			@Param("startDate") Date startDate, @Param("endDate") Date endDate);

	List<TransferInvoiceScan> fetchMismatchScansPerTransferInvoiceNumber(Date date);

}