查询搭配列表

接口名： /collocation/selectCollocationListBySkn

方法

POST JSONRAW

入参

---

属性名称	类型	例子	说明	是否必填	长度限制
productSkn	number		skn	必填	10
page	number		当前页数	必填	10
size	number		每页展示条数	必填	10

对应SQL的操作库表

<select id="getShopProductBySkn" resultMap="BaseResultMap" parameterType="java.lang.Integer" >
    select 
    <include refid="Base_Column_List" />
    from product
    where erp_product_id = #{erpProductId,jdbcType=INTEGER}
  </select>
 <select id="selectListByProductId" resultMap="ResultMapWithBLOBs" parameterType="java.lang.Integer" >
    select 
    <include refid="Base_Column_List" />
    ,
    <include refid="Blob_Column_List" />
    from product_collocation
    where product_id = #{productId,jdbcType=INTEGER} ORDER BY order_by DESC  Limit #{startIndex,jdbcType=INTEGER}, #{size,jdbcType=INTEGER}
  </select>
  <select id="selectListByProductIdCount" parameterType="java.lang.Integer" resultType="java.lang.Integer">
    select count(1)
    from product_collocation
    where product_id = #{productId,jdbcType=INTEGER}
  </select>

错误编码

---

错误码code	消息	说明
200	添加成功！
400	操作失败！

返回

{
  "code": 200,
  "data": {
    "list": [
      {
        "content": "content",
        "createTime": 1457576452,
        "id": 28947,
        "imageUrl": "http://img12.static.yhbimg.com\\goodsimg/2016/02/19/09/022b04df3ecc1d94afddff082d139c6f15.jpg",
        "orderBy": 1,
        "productSkn": 50000055
      }
    ],
    "page": 1,
    "size": 2,
    "total": 1,
    "totalPage": 1
  },
  "md5": "da443e6e2d29dfaba540c41a30cdd082",
  "message": "Product Collocation List."
}