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": "获取限购码成功."
}