queryProductPriceListBySkn.md
1.95 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":{
"additionInfo": {
"productSkn": 1111111, // SKN
"goodsName": "123", // 商品名称
"brandName": "adidas", // 品牌名称
"maxSortName": "上衣", // 分类
"midleSortName": "衬衫", // 分类
"smallSortName": "衬衫", // 分类
},
"list": [
{
"retailPrice": 175,
"salesPrice": 22,
"founderName": "变价人",
"createTime": "2016-06-00 12:12:12",
"effectiveTime": "2016-06-01",
},
{
"retailPrice": 175,
"salesPrice": 22,
"founderName": "变价人",
"createTime": "2016-06-00 12:12:12",
"effectiveTime": "2016-06-01",
}
]
},
"md5": "64cdf0d30ba9174ddce76ecf71a91ad8",
"message": "queryProductPriceListBySkn success."
}