package com.gree.mall.contest.commonmapper; import com.baomidou.mybatisplus.annotation.InterceptorIgnore; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.gree.mall.contest.bean.goods.GoodsPackageList; import com.gree.mall.contest.bean.goods.GoodsSpecBean; import com.gree.mall.contest.bean.goods.GoodsTypeCount; import com.gree.mall.contest.bean.goods.GoodsVO; import com.gree.mall.contest.bean.zfire.ZfireParamBean; import com.gree.mall.contest.plus.entity.Goods; import com.gree.mall.contest.plus.entity.GoodsCategory; import org.apache.ibatis.annotations.Param; import org.apache.ibatis.annotations.Select; import java.math.BigDecimal; import java.util.List; public interface CustomGoodsMapper { /** * 商品列表 * * @param objectPage * @param flag * @param keyword * @param startPrice * @param endPrice * @param startShare * @param endShare * @param sortStr * @param categoryId * @param status * @return */ @InterceptorIgnore(tenantLine = "true") IPage pageList(Page objectPage, @Param("flag") String flag, @Param("keyword") String keyword, @Param("startPrice") BigDecimal startPrice, @Param("endPrice") BigDecimal endPrice, @Param("startShare") BigDecimal startShare, @Param("endShare") BigDecimal endShare, @Param("sortStr") String sortStr, @Param("categoryId") List categoryId, @Param("status") Boolean status, @Param("goodsTypes") List goodsTypes, @Param("companyWechatIds")List companyWechatIds); @InterceptorIgnore(tenantLine = "true") List list(@Param("commonTemplateId") String commonTemplateId); /** * 根据商品类型统计 * * @return */ @InterceptorIgnore(tenantLine = "true") GoodsTypeCount countByType(@Param("companyWechatIds") List companyWechatIds); /** * 获取活动中的商品数量 * * @return */ @InterceptorIgnore(tenantLine = "true") Integer countByFlag(@Param("companyWechatIds") List companyWechatIds); /** * 已售罄商品数量 * * @return */ @InterceptorIgnore(tenantLine = "true") Integer ysq(@Param("companyWechatIds") List companyWechatIds); /** * 查询我的收藏 */ @Select("select b.goods_id,b.img_url,b.goods_name,b.goods_price,b.status,a.create_time from goods_favorite a join goods b on a.goods_id=b.goods_id where a.user_id=#{userId} order by a.create_time desc") IPage myGoodsFavorite(Page page, @Param("userId") String userId); /** * 查询商品分类 */ @InterceptorIgnore(tenantLine = "true") GoodsCategory queryGoodsCategoryByGoodsId(@Param("goodsId") String goodsId); /** * 用 商品规格的 分销金额 覆盖其 为null的 内部分销金额 */ void syncGoodsSpecInnerShareMsg(@Param("companyWechatId") String companyWechatId); IPage queryGoodsPackageList(Page objectPage, @Param("keyword") String keyword, @Param("startPrice") BigDecimal startPrice, @Param("endPrice") BigDecimal endPrice, @Param("startShare") BigDecimal startShare, @Param("endShare") BigDecimal endShare, @Param("sortStr") String sortStr, @Param("categoryId") List categoryId, @Param("status") Boolean status, @Param("companyWechatIds")List companyWechatIds); IPage goodsList(Page page, @Param("ex") ZfireParamBean zfireParam); }