getNetSale.md
14.4 KB
网销信息详情
接口名：
/product/getNetSaleInfo
方法
POST JSONRAW
入参
| 属性名称 | 类型 | 例子 | 说明 | 是否必填 | 长度限制 |
|---|---|---|---|---|---|
| param | 数字型 | productSkn | 必填 | 10 |
对应SQL的操作库表
<select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer" >
select
<include refid="Base_Column_List" />
from product
where product_skn = #{productSkn,jdbcType=INTEGER}
</select>
<select id="selectProductExtBySkn" resultMap="ResultMapWithBLOBs">
select * from product_ext where product_skn = #{productSkn,jdbcType=INTEGER}
</select>
<select id="selectbatchByProductIds" resultMap="BaseResultMap" >
select <include refid="Base_Column_List" />
from product_special_attr where product_id in
<foreach collection="productIds" item="item" index="index" separator="," open="(" close=")">
#{item, jdbcType=INTEGER}
</foreach>
</select>
<select id="selectProductBySkn" resultMap="productBaseResultMap" parameterType="java.lang.Integer">
select
<include refid="Base_Column_List"/>
from product where erp_product_id=#{productSkn,jdbcType=INTEGER}
</select>
<select id="selectBatchBySkn" resultMap="BaseResultMap" parameterType="java.lang.Integer" >
select
<include refid="Base_Column_List" />
from goods
where product_skn in
<foreach collection="productSkns" item="item" index="index"
separator="," open="(" close=")">
#{item}
</foreach>
</select>
<select id="selectBatchSkuListBySkn" resultMap="BaseResultMap">
select
<include refid="Base_Column_List" />
from storage
where product_skn in
<foreach item="item" collection="productSknList" open="(" separator="," close=")">
#{item, jdbcType=INTEGER}
</foreach>
</select>
<select id="selectBySkn" resultMap="BaseResultMap">
select <include refid="Base_Column_List" />
from product_attribute_property_values
where product_skn = #{productSkn,jdbcType=INTEGER}
<if test="displayPosition != null">
AND display_position = #{displayPosition,jdbcType=INTEGER}
</if>
</select>
<select id="selectBatchByProductIds" resultMap="BaseResultMap">
select
<include refid="Base_Column_List" />
from product_keywords
where product_id in
<foreach item="item" index="index" collection="productIds" open="(" separator="," close=")">
#{item, jdbcType=INTEGER}
</foreach>
</select>
<select id="selectListBySkn" parameterType="java.lang.Integer" resultMap="BaseResultMap">
select
<include refid="Base_Column_List" />
from product_search
where product_skn = #{productSkn,jdbcType=INTEGER}
</select>
<select id="selectRelationBySkn" resultType="java.lang.Integer">
select shop_id as shopId from product_shop_relation where product_skn = #{productSkn,jdbcType=INTEGER}
</select>
<select id="selectByProductId" resultMap="BaseResultMap">
select
<include refid="Base_Column_List" />
from product_standard_relation
where product_id = #{productId,jdbcType=INTEGER}
</select>错误编码
| 错误码code | 消息 | 说明 |
|---|---|---|
| 200 | 操作成功！ | |
| 400 | 操作失败！ | |
| 500 | 操作失败！ |
返回
{
"code": 200,
"data": {
"baseProductInfo": {
"baseProduct": {
"ageLevel": "1",
"attribute": 1,
"brandFolder": 0,
"brandId": 175,
"cnAlphabet": "TuanYiFuGuHuaWenManBenTuAnNiuPiZhiBiJiBen",
"createTime": 1308904880,
"editTime": 0,
"expectArrivalTime": 0,
"expectShelfTime": 0,
"factoryCode": "",
"gender": "3",
"goodsSeason": 0,
"goodsYears": 0,
"isAdvance": "N",
"isDown": "N",
"isJit": "N",
"isLimitbuy": "N",
"isLimited": "N",
"isPromotionalGifts": "N",
"isRetrieval": "N",
"isSales": "Y",
"isSpecial": "N",
"limitEndTime": 0,
"limitStartTime": 0,
"maxSortId": 10,
"middleSortId": 101,
"outletsSetting": "B",
"pattern": "1", // 图案纹理
"productName": "新的商品名称",
"productSkn": 50000055,
"productStyle": "个性,原创,创意,办公,家居",
"retailPrice": 29, // 吊牌价
"salableTime": "0",
"salesPrice": 21.22, // 销售价
"seasons": "",
"seriesId": 0,
"shopId": 0,
"smallSortId": 111,
"sortId": 0,
"style": "9", // 商品风格
"productImageUrl": "http://img12.static.yhbimg.com\\goodsimg/2011/06/24/13/02e571a64cea3ea8e734f8f0aae790fb4d.jpg", // 产品默认图片
"supplierId": 0
}
},
"attributeProValuesBosTwo": [ // 上架后信息参数
{
"attributeId": 83, // 属性Id
"attributeValueId": "3, 6",
"attributeValueIds": [ // 属性值Id
3,
6
],
"displayPosition": 3,
"id": 3,
"productSkn": 50000066
},
{
"attributeId": 87,
"attributeValueId": "21",
"attributeValueIds": [
21
],
"displayPosition": 3,
"id": 4,
"productSkn": 50000066
}
],
"attributeProValuesBosOne": [ // 商品参数
{
"attributeId": 83, // 属性Id
"attributeValueId": "3, 6",
"attributeValueIds": [ // 属性值Id
3,
6
],
"displayPosition": 3,
"id": 3,
"productSkn": 50000066
},
{
"attributeId": 87,
"attributeValueId": "21",
"attributeValueIds": [
21
],
"displayPosition": 3,
"id": 4,
"productSkn": 50000066
}
],
"brandRelationList": [ // 品牌关联的数据
791,
156
],
"collocationList": [
{
"content": "content1",
"createTime": 1457083379,
"id": 28952,
"imageUrl": "http:///goodsimgimageUrl1?imageView/1/w/150/h/150",
"orderBy": 1,
"productSkn": 50000055
}
],
"goodsImagesList": [
{
"colorId": 11,
"createTime": 0,
"factoryCode": "NB T-BOOK 0084NB",
"goodsColorImage": "/2011/06/24/13/02e571a64cea3ea8e734f8f0aae790fb4f.jpg",
"goodsImagesList": [
{
"angle": 0,
"genderCover": 2,
"id": 3,
"imageUrl": "imageUrl",
"isDefault": "Y",
"orderBy": 2,
"productSkc": 7661,
"productSkn": 50000055,
"status": 1
},
{
"angle": 0,
"genderCover": 2,
"id": 4,
"imageUrl": "imageUrl",
"isDefault": "Y",
"orderBy": 2,
"productSkc": 7661,
"productSkn": 50000055,
"status": 1
},
{
"angle": 0,
"genderCover": 2,
"id": 5,
"imageUrl": "imageUrl",
"isDefault": "Y",
"orderBy": 2,
"productSkc": 7661,
"productSkn": 50000055,
"status": 1
},
{
"angle": 0,
"genderCover": 2,
"id": 6,
"imageUrl": "imageUrl",
"isDefault": "Y",
"orderBy": 2,
"productSkc": 7661,
"productSkn": 50000055,
"status": 1
},
{
"angle": 0,
"genderCover": 2,
"id": 7,
"imageUrl": "imageUrl",
"isDefault": "Y",
"orderBy": 2,
"productSkc": 7661,
"productSkn": 50000055,
"status": 1
}
],
"goodsName": "粉",
"isDefault": "Y",
"productSkc": 7661,
"productSkn": 50000055,
"status": 0,
"updateTime": 0
}
],
"goodsList": [
{
"colorId": 11,
"createTime": 0,
"factoryCode": "NB T-BOOK 0084NB",
"goodsColorImage": "/2011/06/24/13/02e571a64cea3ea8e734f8f0aae790fb4f.jpg",
"goodsName": "粉",
"goodsSizeList": [
{
"barCode": "",
"createTime": 0,
"isSuppled": "Y",
"marketPrice": 0,
"productSkc": 7661,
"productSkn": 50000055,
"productSku": 102174,
"salePrice": 0,
"sizeId": 199,
"sizeName": "F",
"status": 1,
"storageNum": 0,
"updateTime": 0
}
],
"initGoodsImageUrl":"http://img13.static.yhbimg.com\\goodsimg/2016/04/12/06/02b94b20df42eb1321e32d364496aa8e2c.jpg", // 商品skc 默认图片链接
"isDefault": "Y",
"productSkc": 7661,
"productSkn": 50000055,
"status": 0,
"updateTime": 0
}
],
"modelTryList": [
{
"avatar": "http://img12.static.yhbimg.com\\modelCard/2015/08/11/07/0220d27e95d08daf3f4cb8f91fbf6c1379.png",
"fitModelBo": {
"feel": "合适",
"feel_id": 1,
"fit_remark": "",
"fit_size": "S",
"model_id": 19
},
"height": 163, // 高度
"modelName": "Cherry Lee",
"vitalStatistics": "77/67/86", // 三围
"weight": 42 // 体重
}
],
"modelcardList": [
{
"modelImg": "http://img12.static.yhbimg.com/modelCard/2012/03/09/14/025511fa559a15b2f38a5dddb80d92e251.jpg?imageMogr2/thumbnail/{width}x{height}/extent/{width}x{height}/background/d2hpdGU=/position/center/quality/80",
"modelName": "郭冠",
"modelcardId": 5,
"productId": 5675,
"size": "M",
"sortId": 1
},
{
"modelImg": "http://img12.static.yhbimg.com/modelCard/2012/03/12/11/02597b14bb6c8abcd650dcaee67dd1de4e.jpg?imageMogr2/thumbnail/{width}x{height}/extent/{width}x{height}/background/d2hpdGU=/position/center/quality/80",
"modelName": "杨亚运",
"modelcardId": 7,
"productId": 5675,
"sortId": 1
}
],
"productExtBo": {
"brandModel": "11", // 品牌款型
"brandSeries": "33", // 品牌系列
"isHostsell": "N", // 是否热销
"isNew": "N",
"makeCrafts": "122,122", // 制作工艺
"outSaleTime": 12,
"phrase": "商品简评",
"productDesc": "商品描述信息111111",
"productSkn": 50000055,
"recommend": "2213213",
"salesPhrase": "促销短语", // 促销短语
"searchKeys": "搜索词1,搜索词2 以英文逗号分隔",
"sellChannels": "1,2,3",
"sellChannelsList": [
"1",
"2",
"3"
],
"shopIdList": [
1,
3,
23
],
"vedioUrl": "videoUrlvideoUrlvideoUrlvideoUrl"
},
"searchSortList": [
{
"createTime": 1457146662,
"id": 1333856,
"intValue": 11,
"modelId": 1,
"productSkn": 50000055,
"projectId": 1,
"stringValue": "22"
},
{
"createTime": 1457146995,
"id": 1333857,
"intValue": 22,
"modelId": 2,
"productSkn": 50000055,
"projectId": 1,
"stringValue": "22"
},
{
"createTime": 1457147062,
"id": 1333858,
"intValue": 44,
"modelId": 3,
"productSkn": 50000055,
"projectId": 1,
"stringValue": "22"
},
{
"createTime": 1457350159,
"id": 1333865,
"intValue": 22,
"modelId": 2,
"productSkn": 50000055,
"projectId": 1
}
],
"sizeInfo": {
"sizeAttributeBos": [
{
"attributeName": "厚",
"id": 31
},
{
"attributeName": "宽",
"id": 30
},
{
"attributeName": "长",
"id": 29
}
],
"sizeBoList": [
{
"id": 199,
"sizeName": "F",
"sortAttributes": [
{
"id": 31,
"sizeValue": "2.1"
},
{
"id": 30,
"sizeValue": "14.5"
},
{
"id": 29,
"sizeValue": "18.5"
}
]
}
]
},
"specialAttrBo": {
"materialList": [ // 材质
{
"id": 35
},
{
"id": 37
},
{
"id": 46
}
],
"productSkn": 50000055,
"sizeStandard": 1, // 尺码规范 1代表正常 2 偏大 3 偏小
"washTipsList": [ // 洗涤提示
{
"sortId": 1
},
{
"sortId": 2
},
{
"sortId": 3
},
{
"sortId": 4
}
],
"wearSenses": [ // 舒适度
{
"id": 1, // 弹性
"value": 0
},
{
"id": 2, // 厚度
"value": 0
},
{
"id": 3, // 柔软度
"value": 0
},
{
"id": 4, // 透气性
"value": 0
}
]
}
},
"md5": "0715c67f137835dbffa419c66161be5f",
"message": "NetSale Info."
}