| | |
| | | " </where>" + |
| | | " order by c.create_at desc" + |
| | | "</script>") |
| | | IPage<PageShopGoodsVO> pageShopGoods(Page page, @Param("pageComShopGoodsDTO") PageComShopGoodsDTO pageComShopGoodsDTO); |
| | | IPage<PageShopGoodsVO> pageShopGoods(Page page, @Param("pageComShopGoodsDTO") PageComShopGoodsDTO pageComShopGoodsDTO); |
| | | |
| | | /** |
| | | * 根据店铺id查询商品列表 |
| | | * @param page 分页参数 |
| | | * @param pageComShopStoreDTO 请求参数 |
| | | * @return 分页商品列表 |
| | | * |
| | | * @param page 分页参数 |
| | | * @param pageComShopStoreDTO 请求参数 |
| | | * @return 分页商品列表 |
| | | */ |
| | | @Select("<script> " + |
| | | "select id,`name`,store_id,goods_pic,images,`status`,sale,original_price,price" + |
| | | ",unit,`order`,stock,details,delivery_type from com_shop_goods" + |
| | | " where store_id = #{pageComShopStoreDTO.storeId} and delete_status = 1 and status = 1" + |
| | | " order by sale desc,create_at desc "+ |
| | | " order by sale desc,create_at desc " + |
| | | "</script> ") |
| | | IPage<ComShopGoodsVO> pageShopGoodsByStoreId(Page page, @Param("pageComShopStoreDTO") PageComShopStoreDTO pageComShopStoreDTO); |
| | | |
| | | /** |
| | | * 分页查询商品列表 |
| | | * @param page 分页参数 |
| | | * @param comShopGoodsDTO 请求参数 |
| | | * @return 商品列表 |
| | | * |
| | | * @param page 分页参数 |
| | | * @param comShopGoodsDTO 请求参数 |
| | | * @return 商品列表 |
| | | */ |
| | | @Select("<script> " + |
| | | "select csg.id,csg.`name`,csg.store_id,csg.goods_pic,csg.images,csg.`status`,csg.sale,csg.original_price " + |
| | |
| | | " order by sale desc,create_at desc " + |
| | | " </script>") |
| | | IPage<ComShopGoodsVO> pageShopGoodByApps(Page page, @Param("comShopGoodsDTO") ComShopGoodsDTO comShopGoodsDTO); |
| | | |
| | | } |