| | |
| | | "select c.id,c.type_id,css.name as storeName,c.name,c.store_id,c.goods_pic,c.images,c.status,c.sale,c.original_price,c.price,c.unit,c.order,c.stock,c.details,c.remark,c.goods_describe,c.delivery_type,c.delete_status,c.create_at,c.update_at from com_shop_goods c \n" + |
| | | " left join com_shop_store css on c.store_id=css.id\n" + |
| | | " <where>" + |
| | | " and delete_status = 1 " + |
| | | "<if test='pageComShopGoodsDTO.storeName != null and pageComShopGoodsDTO.storeName.trim() != ""'>" + |
| | | "and css.name like concat('%',#{pageComShopGoodsDTO.storeName},'%') \n" + |
| | | " </if> " + |