需求 #24793
实时同步商品信息到华为应用服务POC环境（测试环境，只调一个接口）
0%
描述
由于是需要和华为那边对接，数据上报是否准确需要和华为的算法工程师磨合，所以，本需求不需要经过测试
对接时有任何问题，都可以找阿童木协调
接口119.8.10.165:6447/recommend/datacollection/import/iteminfo
取数逻辑（供参考）
SELECT
gs.sku as sku_id
,CONCAT(gs.goods_no,'_',gs.sku) as goods_id
,gs.goods_no as spu_id
,gs.co_id as color_id
,gs.co_val as color
,gs.si_id as size_id
,gs.si_val as size
,gl.goods_name as spu_name
,CONCAT(gs.co_val,'_',gs.si_val) as sku_name
,CONCAT(gs.co_val,'_',gs.si_val) as goods_name
,gs.sale_stock as goods_stock
-- 价格类型
,gl.cat_id as min_class_id
,c.third_cat_name as min_class
,c.primary_cat_id as first_class_id
,c.primary_cat_name as first_class
,c.second_cat_id as second_class_id
,c.second_cat_name as second_class
,c.third_cat_id as third_class_id
,c.third_cat_name as third_class
,g.is_on_sale as online_flag
,CASE WHEN g.is_on_sale=1 THEN "上架" ELSE "下架" END as online_flag_name
,g.is_stockout as product_status_id
,CASE WHEN g.is_stockout=0 THEN "在售" ELSE "售罄" END as product_status
,g.goods_status as source_status
,CASE WHEN g.goods_status=1 THEN "正常" ELSE "断货" END as source_status_name
,g.shop_price as goods_price
,g.shop_price as market_price
,g.shoppe_discount as goods_dcn
,gl.goods_weight as shipping_weight
,CONCAT('https://img3.yishouapp.com/',gl.goods_img) as image_link
,b.goods_desc
,si.supply_name as cp_supply_name
,si.is_platform as cp_is_platform
,mi.market_name as cp_market_name
,gl.picker_group_code as cp_picker_group_code
FROM yishou_data.all_fmys_goods_sku gs
LEFT JOIN yishou_data.all_fmys_goods_lib gl on gl.goods_no = gs.goods_no
LEFT JOIN yishou_data.dim_cat_info c on gl.cat_id = c.cat_id
LEFT JOIN yishou_data.dim_supply_info si on si.supply_id = gl.supply_id
LEFT JOIN yishou_data.dim_market_info mi on mi.market_id = gl.market_id
LEFT JOIN yishou_data.all_fmys_goods_lib_ext gle on gle.goods_no = gs.goods_no
LEFT JOIN yishou_data.all_fmys_goods_id gi on gi.goods_no = gl.goods_no
LEFT JOIN yishou_data.all_fmys_goods g on g.goods_id = gi.goods_id
LEFT JOIN (
SELECT a.goods_no
,wm_concat(';',a.goods_desc ) as goods_desc
FROM (
SELECT goods_no, CONCAT(prop_type_name,":", prop_value_name ) as goods_desc
FROM yishou_data.all_fmys_goods_prop_table
)a GROUP BY a.goods_no
)b on b.goods_no = gs.goods_no
WHERE g.auto_time >= "2021-06-01 00:00:00"
;
head参数：
Accept:application/json
Content-Type:application/x-www-form-urlencoded
X-Apig-AppCode:test
Authorization:testToken
X-Kit-AppID:8
body公共参数：
{
"timestamp":1625206524,
"appid":8,
"requestid":1,
"industry_type":1,
"data_opt_type":1
}
body 非公共参数部分请查看附件sheet中GoodsInfo
由 
