msNewPayment2.0/src/main/java/zs/payment/mapper/primary/ImsEweiShopGoodsMapper.java

package zs.payment.mapper.primary;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import zs.payment.entity.mysql.ImsEweiShopGoods;
import zs.payment.req.order.AddressInfo;
import zs.payment.req.order.SpuItem;

import java.util.List;

@Mapper
public interface ImsEweiShopGoodsMapper extends BaseMapper<ImsEweiShopGoods> {

    /**
     * 根据订单编号查询下单的商品
     * @param ordersn
     * @return
     */
    List<SpuItem> findSpuByOrdersn(@Param("ordersn") String ordersn);

    /**
     * 根据订单编号查询下单地址
     * @param ordersn
     * @return
     */
    AddressInfo findAddressByOrdersn(@Param("ordersn")String ordersn);

    /**
     * 多规格商品：从option子查询更新goods的价格字段
     */
    void updateGoodsPriceByOption(@Param("goodsId") Long goodsId);

    /**
     * 检查商品是否存在订单记录
     * @param goodsId 商品ID
     * @return true-存在订单，false-不存在订单
     */
    @Select("SELECT COUNT(1) > 0 FROM ims_ewei_shop_order_goods WHERE goodsid = #{goodsId}")
    boolean existsOrderByGoodsId(@Param("goodsId") Long goodsId);
}