| | |
|---|
| | | " where g.ISDELETED = 0 and g.id = #{id} ") |
|---|
| | | GoodsInfoResponse getGoodsInfo(@Param("id") Integer id); |
|---|
| | | |
|---|
| | | |
|---|
| | | @Select(" select g.* , gs.price as minPrice " + |
|---|
| | | " ifnull( ( select sgr.PRICE from shop_goods_relation sgr where sgr.GOODS_SKU_ID = gs.ID and sgr.ISDELETED = 0 and sgr.`STATUS` = 0 and sgr.SHOP_ID = #{shopId} ) ,0) as exFactoryPrice " + |
|---|
| | | " ifnull(( select sum(gd.NAME) from goodsorder_detail gd inner join goodsorder go on gd.ORDER_ID = go.id where gd.GOODS_SKU_ID = gs.`id` and go.DISTRIBUTION_SHOP_ID = 1 ),0) as realSaleNum " + |
|---|
| | | " from goods g left join goods_sku gs on g.id = gs.GOODS_ID " + |
|---|
| | | " ${ew.customSqlSegment} ") |
|---|
| | | IPage<GoodsInfoResponse> goodsPageForShop(IPage<GoodsRequest> page, @Param(Constants.WRAPPER) Wrapper wrapper,@Param("shopId") Integer shopId); |
|---|
| | | |
|---|
| | | |
|---|
| | | } |
|---|
