queryList.md
11.2 KB
查询网销信息
接口名：
/product/queryNetSaleInforList
方法
POST JSONRAW
入参
| 属性名称 | 类型 | 例子 | 说明 | 是否必填 | 长度限制 |
|---|---|---|---|---|---|
| productSkn | number | 商品skn | N | 10 | |
| productSkc | number | 商品skc | N | 10 | |
| productSku | number | 商品sku | N | 10 | |
| productName | 字符串 | 名称 | N | 无 | |
| shopId | number | 店铺Id | N | 5 | |
| brandId | number | 品牌Id | N | 5 | |
| isJit | 枚举型(字符串) | 是否jit商品 | "Y" 或者 "N" | 1 | |
| stock | 枚举型(数字型) | 是否有库存 | 0 或者 1 | 11 | |
| isScreen | 枚举型 | 是否拍摄状态 | "Y" 或者 "N" | 1 | |
| isMeasure | 枚举型 | 是否测量状态 | "Y" 或者 "N" | 1 | |
| gender | 枚举型 | 性别 | 1男2女 3通用 | 1 | |
| maxSortId | 数字型 | 一级分类Id | N | 5 | |
| middleSortId | 数字型 | 二级分类Id | N | 5 | |
| smallSortId | 数字型 | 三级分类Id | N | 5 | |
| isOutLets | 枚举型 | 是否奥莱"Y" 或者 "N""B" | N | 1 | |
| productStatus | 数字型 | 状态8待上架，2待审核，3驳回，4通过，1已上架，0已下架，5再上架待审核，6再上架驳回，7再上架通过 | N | 5 | |
| productStatusStr | 字符串，多个用逗号隔开 | 状态8待上架，2待审核，3驳回，4通过，1已上架，0已下架，5再上架待审核，6再上架驳回，7再上架通过 | N | 20 | |
| page | 数字型 | 当前页数 | N | 11 | |
| size | 数字型 | 每页显示条数默认10 | N | 11 | |
| sortFlag | 数字型 | 1代表按操作时间排序，2按库存排序默认1 | N | 10 | |
| descFlag | 字符串 | asc升序 desc 倒序 默认倒序 | N | 10 | |
| isInfoMiss | 字符串 | 是否信息缺失，上架后信息缺失页面专用，取值Y | N | 1 | |
| isAdvance | 字符串 | 是否预售，取值Y or N | N | 1 | |
| skcOnsaleStatus | 数字型 | skc上架状态，取值0 1(skc都已经上架) | N | 1 |
对应SQL的操作库表
<select id="selectSknListByReq" resultMap="BaseResultMap">
select <include refid="Base_Column_List" /> from product where 1 = 1
<if test="baseProduct.productSkn != null" >
And product_skn = #{baseProduct.productSkn, jdbcType=INTEGER}
</if>
<if test="baseProduct.productName != null" >
And product_name like concat('%', #{baseProduct.productName, jdbcType=VARCHAR}, '%')
</if>
<if test="baseProduct.brandId != null" >
And brand_id = #{baseProduct.brandId, jdbcType=SMALLINT}
</if>
<if test="baseProduct.isScreen != null" >
And is_screen = #{baseProduct.isScreen, jdbcType=CHAR}
</if>
<if test="baseProduct.isMeasure != null" >
And is_measure = #{baseProduct.isMeasure, jdbcType=CHAR}
</if>
<if test="baseProduct.supplierId != null" >
And supplier_id = #{baseProduct.supplierId, jdbcType=INTEGER}
</if>
<if test="baseProduct.isJit != null" >
And is_jit = #{baseProduct.isJit, jdbcType=CHAR}
</if>
<if test="baseProduct.maxSortId != null" >
And max_sort_id = #{baseProduct.maxSortId, jdbcType=SMALLINT}
</if>
<if test="baseProduct.middleSortId != null" >
And middle_sort_id = #{baseProduct.middleSortId, jdbcType=SMALLINT}
</if>
<if test="baseProduct.smallSortId != null" >
And small_sort_id = #{baseProduct.smallSortId, jdbcType=SMALLINT}
</if>
<if test="baseProduct.isOutLets != null" >
And is_outlets = #{baseProduct.isOutLets, jdbcType=CHAR}
</if>
<if test="baseProduct.isAdvance != null" >
And is_advance = #{baseProduct.isAdvance, jdbcType=CHAR}
</if>
<if test="baseProduct.gender != null" >
And gender = #{baseProduct.gender, jdbcType=CHAR}
</if>
<if test="baseProduct.isInfoMiss != null" >
And is_info_miss = #{baseProduct.isInfoMiss, jdbcType=CHAR}
</if>
<if test="baseProduct.stock != null" >
<if test="baseProduct.stock == 1" >
And stock >= #{baseProduct.stock, jdbcType=SMALLINT}
</if>
<if test="baseProduct.stock == 0" >
And (stock = 0 OR stock is null)
</if>
</if>
<if test="baseProduct.isAuditing != null" >
<if test="baseProduct.isAuditing == 200" >
And is_auditing = 200
</if>
<if test="baseProduct.isAuditing != 200" >
And is_auditing in(100, 300)
</if>
</if>
<if test="baseProduct.status != null" >
<if test="baseProduct.status == 1" >
And status = 1
</if>
<if test="baseProduct.status != 1" >
And status != 1
</if>
</if>
<if test="baseProduct.productStatusList != null" >
AND status in
<foreach collection="baseProduct.productStatusList" item="item" index="index" separator="," open="(" close=")">
#{item}
</foreach>
</if>
<if test="baseProduct.onlyShowSknList != null" >
AND (product_skn in
<foreach collection="baseProduct.onlyShowSknList" item="item" index="index" separator="," open="(" close=")">
#{item, jdbcType=INTEGER}
</foreach> OR shop_id = #{baseProduct.shopId, jdbcType=SMALLINT} )
</if>
<if test="baseProduct.onlyShowSknList == null" >
<if test="baseProduct.shopId != null" >
And shop_id = #{baseProduct.shopId, jdbcType=SMALLINT}
</if>
</if>
<if test="baseProduct.sortFlag != null">
order by ${baseProduct.sortFlag} ${baseProduct.descFlag}
</if>
Limit #{startIndex,jdbcType=INTEGER}, #{length,jdbcType=INTEGER}
</select>
<select id="selectSknListByReqCount" resultType="java.lang.Integer" parameterType="com.yohobuy.platform.dal.product.model.BaseProductEx">
select count(0) from product where 1 = 1
<if test="baseProduct.productSkn != null" >
And product_skn = #{baseProduct.productSkn, jdbcType=INTEGER}
</if>
<if test="baseProduct.productName != null" >
And product_name like concat('%', #{baseProduct.productName, jdbcType=VARCHAR}, '%')
</if>
<if test="baseProduct.brandId != null" >
And brand_id = #{baseProduct.brandId, jdbcType=SMALLINT}
</if>
<if test="baseProduct.isScreen != null" >
And is_screen = #{baseProduct.isScreen, jdbcType=CHAR}
</if>
<if test="baseProduct.isMeasure != null" >
And is_measure = #{baseProduct.isMeasure, jdbcType=CHAR}
</if>
<if test="baseProduct.supplierId != null" >
And supplier_id = #{baseProduct.supplierId, jdbcType=INTEGER}
</if>
<if test="baseProduct.isJit != null" >
And is_jit = #{baseProduct.isJit, jdbcType=CHAR}
</if>
<if test="baseProduct.maxSortId != null" >
And max_sort_id = #{baseProduct.maxSortId, jdbcType=SMALLINT}
</if>
<if test="baseProduct.middleSortId != null" >
And middle_sort_id = #{baseProduct.middleSortId, jdbcType=SMALLINT}
</if>
<if test="baseProduct.smallSortId != null" >
And small_sort_id = #{baseProduct.smallSortId, jdbcType=SMALLINT}
</if>
<if test="baseProduct.isOutLets != null" >
And is_outlets = #{baseProduct.isOutLets, jdbcType=CHAR}
</if>
<if test="baseProduct.isAdvance != null" >
And is_advance = #{baseProduct.isAdvance, jdbcType=CHAR}
</if>
<if test="baseProduct.gender != null" >
And gender = #{baseProduct.gender, jdbcType=CHAR}
</if>
<if test="baseProduct.isInfoMiss != null" >
And is_info_miss = #{baseProduct.isInfoMiss, jdbcType=CHAR}
</if>
<if test="baseProduct.stock != null" >
<if test="baseProduct.stock == 1" >
And stock >= #{baseProduct.stock, jdbcType=SMALLINT}
</if>
<if test="baseProduct.stock == 0" >
And (stock = 0 OR stock is null)
</if>
</if>
<if test="baseProduct.isAuditing != null" >
<if test="baseProduct.isAuditing == 200" >
And is_auditing = 200
</if>
<if test="baseProduct.isAuditing != 200" >
And is_auditing in(100, 300)
</if>
</if>
<if test="baseProduct.status != null" >
<if test="baseProduct.status == 1" >
And status = 1
</if>
<if test="baseProduct.status != 1" >
And status != 1
</if>
</if>
<if test="baseProduct.productStatusList != null" >
AND status in
<foreach collection="baseProduct.productStatusList" item="item" index="index" separator="," open="(" close=")">
#{item}
</foreach>
</if>
<if test="baseProduct.onlyShowSknList != null" >
AND (product_skn in
<foreach collection="baseProduct.onlyShowSknList" item="item" index="index" separator="," open="(" close=")">
#{item, jdbcType=INTEGER}
</foreach> OR shop_id = #{baseProduct.shopId, jdbcType=SMALLINT} )
</if>
<if test="baseProduct.onlyShowSknList == null" >
<if test="baseProduct.shopId != null" >
And shop_id = #{baseProduct.shopId, jdbcType=SMALLINT}
</if>
</if>
</select>错误编码
| 错误码code | 消息 | 说明 |
|---|---|---|
| 200 | 添加成功！ | |
| 400 | 操作失败！ | |
| 500 | 操作失败！ |
返回
{
"code": 200,
"data": {
"list": [
{
"ageLevel": "1",
"attribute": 1,
"brandId": 166,
"brandName": "九口山",
"editTime": "2016-03-02 15:43:21",
"gender": "3",
"isLimitbuy": "N",
"isOutlets": "N",
"maxSortId": 10,
"maxSortName": "创意生活",
"middleSortId": 101,
"middleSortName": "文具",
"missInfo": "文本信息,尺码信息,搜索/标签", // 信息缺失字段
"picImgUrl": "http://img12.static.yhbimg.com/goodsimg/2013/01/10/02/022170d6008746d452f03ee0fe8e0c1f86.jpg?imageView/0/w/60/h/60",
"productName": "九口山 document1缝线本-工作日志-Timer",
"productSkn": 51001872,
"retailPrice": 18,
"returnCoin": 0,
"salesPrice": 18,
"searchAndLabel": "",
"shelveTime": "2016-03-11 11:03:04", // 上架时间
"smallSortId": 111,
"smallSortName": "本子",
"status": 1,
"founderName":"操作人姓名",
"shopId" : 431 // 店铺Id
},
{
"attribute": 1,
"brandId": 1523,
"brandName": "冬冬腔",
"gender": "2",
"maxSortId": 4,
"maxSortName": "裙装",
"middleSortId": 31,
"middleSortName": "连衣裙",
"picImgUrl": "",
"productName": "DFASDLKF;LASDKAAAAA",
"productSkn": 51198302,
"missInfo": "文本信息,尺码信息,搜索/标签", // 信息缺失字段
"retailPrice": 495,
"returnCoin": 0,
"salesPrice": 495,
"smallSortId": 134,
"smallSortName": "连衣裙",
"shelveTime": "2016-03-11 11:03:04" //上架时间
}
],
"page": 1,
"size": 10,
"total": 223703,
"totalPage": 22371
},
"md5": "68e7e09515aec025162017290acf73d8",
"message": "NetSale Information List."
}