kmall-haikong/kmall-admin/src/main/java/com/kmall/admin/dao/GoodsDao.java

package com.kmall.admin.dao;

import com.kmall.admin.dto.GoodsDetailsDto;
import com.kmall.admin.dto.GoodsPanoramaDto;
import com.kmall.admin.entity.GoodsEntity;
import com.kmall.api.entity.exportpdf.PDFGoodsDto;
import com.kmall.manager.dao.BaseDao;
import org.apache.ibatis.annotations.Param;

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

/**
 * Dao
 *
 * @author Scott
 * @email
 * @date 2017-08-21 21:19:49
 */
public interface GoodsDao extends BaseDao<GoodsEntity> {
    Long queryMaxId();

    GoodsEntity queryObjectBySn(String goodsSn);

    GoodsEntity queryObjectByProdBarcodeAndBizType(@Param("prodBarcode")String prodBarcode, @Param("storeId")Integer storeId);

    GoodsEntity queryObjectByProdBarcodeAndStore(@Param("prodBarcode")String prodBarcode, @Param("storeId")Integer storeId);

    GoodsDetailsDto queryGoodsDetailsByProdBarcode(@Param("prodBarcode") String prodBarcode, @Param("storeId")String storeId);

    List<GoodsEntity> querySame(Map<String, Object> map);

    List<GoodsEntity> queryObjectByProdBarcode(@Param("prodBarcode") String prodBarcode, @Param("merchSn") String merchSn,@Param("goodsId")Long id);

    GoodsEntity queryObjectByStoreId(@Param("id") Long id, @Param("storeId") Long storeId);

    GoodsEntity queryGoodsByGoodsSnAndStoreId(@Param("goodsSn") String goodsSn, @Param("storeId") Long storeId);

    GoodsPanoramaDto searchGoodsPanoramaDtoByKeyword(@Param("keyword") String keyword);

    List<GoodsEntity> queryExportList(Map<String, Object> params);

    /**
     * 查询pdf需要的数据
     * @param sku sku
     * @param storeId 门店id
     * @param prodBarcode
     * @return
     */
    PDFGoodsDto queryForPDFData(@Param("sku") String sku, @Param("storeId") String storeId, @Param("prodBarcode") String prodBarcode);

    GoodsEntity queryByBarcode(@Param("barCode") String barCode);

    GoodsEntity queryBySku(@Param("sku") String sku);

    /**
     * 查询所有的sku
     * @param prodBarcode
     * @param storeId
     * @return
     */
    List<GoodsEntity> queryListByBarcode(@Param("prodBarcode")String prodBarcode, @Param("storeId")Integer storeId);

    List<GoodsEntity> queryByName(@Param("storeId")String storeId, @Param("goodsName")String goodsName);


    List<String> queryNonSyncOmsHsCodeSkuList();

    List<GoodsEntity> queryListBySku(String sku);

    List<GoodsEntity> queryNonSyncOmsGoodsRateSkuList();

    List<GoodsEntity> queryAllList(@Param("page") Integer page, @Param("pageSize") Integer pageSize);

    GoodsEntity queryByBarcodeAndSku(@Param("prodBarcode") String prodBarcode, @Param("goodsSn") String goodsSn);

    /**
     * 查询所有特殊化妆品的商品
     * @param hdCodeSet
     * @return
     */
    List<GoodsEntity> querySpecialCosmetics(@Param("hdCodeSet") Set<String> hdCodeSet);

    void updateBatch(List<GoodsEntity> updateGoodsList);

    List<String> syncOmsHsCodeGoode(List<Integer> ids);

    List<GoodsEntity> syncGoodsRateGoode(List<Integer> ids);


}