queryProductPriceListBySkn.md
1.85 KB
获取单个skn的变价记录
接口名:
/product/queryProductPriceListBySkn
例子(http://localhost:8080/product/queryProductPriceListBySkn)
方法
POST JSONRAW
入参
属性名称 | 类型 | 例子 | 说明 | 是否必填 | 长度限制 |
---|---|---|---|---|---|
param | number | 50002403 | 商品SKN | Y | 1024 |
对应SQL的操作库表
<select id="selectProductPriceLogList" resultMap="BaseResultMap">
select
<include refid="Base_Column_List" />
from product_price_log
where product_skn in
<foreach collection="productSknList" item="item" index="index" separator="," open="(" close=")">
#{item}
</foreach>
order by create_time desc
</select>
错误编码
错误码code | 消息 | 说明 |
---|---|---|
200 | 查询成功! | |
401 | 参数错误! | |
500 | 查询失败! |
返回
{
"alg": "SALT_MD5",
"code": 200,
"data":{
"brandName": "团一",
"goodsName": "新的商品名称111222211",
"maxSortName": "创意生活",
"midleSortName": "文具",
"productSkn": 50000055,
"smallSortName": "本子",
"list":
[
{
"createTime": "2016-06-21 16:01:31",
"effectiveTime": "",
"founderId": 100169,
"founderName": "",
"retailPrice": 1111,
"salesPrice": 1000
},
{
"createTime": "2016-06-20 16:30:32",
"effectiveTime": "",
"founderId": 100169,
"founderName": "",
"retailPrice": 1111,
"salesPrice": 440
}
]
},
"md5": "64cdf0d30ba9174ddce76ecf71a91ad8",
"message": "queryProductPriceListBySkn success."
}