12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485 |
- 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.admin.entity.TaxErrorRecordEntity;
- 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();
- GoodsEntity queryByBarcodeAndSku(@Param("prodBarcode") String prodBarcode, @Param("goodsSn") String goodsSn);
- /**
- * 查询所有特殊化妆品的商品
- * @param hdCodeSet
- * @return
- */
- List<GoodsEntity> querySpecialCosmetics(@Param("hdCodeSet") Set<String> hdCodeSet);
- }
|