getLimitCode.md 1.53 KB

根据id查询限购码详情接口

接口名: /limitCode/getLimitCode

方法

POST JSONRAW

入参


属性名称 类型 例子 说明 是否必填 长度限制
id Integer 83 限购码Id 1~11

对应SQL的操作库表

 <select id="getLimitCodeAttachById" resultMap="AttachBaseResultMap" >
    select
   <include refid="Rename_Base_Column_List" />,
    group_concat(b.sku separator ';') as skus,
    group_concat(b.sku_limit_times separator ';')as skuTimes
    from limit_code a left join limit_code_sku b
    on a.batchNo=b.batchNo and a.limit_skn=b.skn  
    where a.id = #{id, jdbcType=INTEGER}
  </select>

响应码


响应码code 消息 说明
200 获取限购码成功.
400 参数不能为空.

返回

{
    "code": 200,
    "data": {
        "batchNo": "201602031002",
        "createTime": "2016-02-03 17:33:08",
        "describe": "",
        "id": 7,
        "limitCodeType": "N",
        "limitDateFrom": "2016-02-02 00:00:00",
        "limitDateTo": "2016-02-18 00:00:00",
        "limitTimes": 10,
        "name": "第一批次限购码",
        "reqDepartment": "运营部",
        "skuTimes": "",
        "skus": "",
        "status": 4,
        "userUseLimit": 1
    },
    "md5": "e3e90eabad29076e86c01fd7407bc623",
    "message": "获取限购码成功."
}