根据限购码批次查询限购码详情接口

接口名： /limitCode/getLimitCodeByBatchNo

方法

POST JSONRAW

入参

---

属性名称	类型	例子	说明	是否必填	长度限制
batchNo	String	201602241947	限购码批次号	是	1~14

---

对应SQL的操作库表

 <select id="getLimitCodeAttachByBatchNo" 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.batchNo = #{batchNo, jdbcType=VARCHAR}
  </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": "获取限购码成功."
}