暂无
任务描述
需求描述
1.SKU看板：通知设置
2.SKU看板：通知消息记录
3.产品表现查询优化：查询速度过慢问题
5.新增业绩目标：支持针对产品上传业绩目标，展示进度条、曲线，支持提醒和筛选
6.列配置：新增业绩目标字段“目标值”“完成值”“实际成率”
7.导出：新增业绩目标字段“目标值”“完成值”“实际成率”
8.ASIN360：曲线图新增“成交均价”
2.SKU看板：通知消息记录
3.产品表现查询优化：查询速度过慢问题
5.新增业绩目标：支持针对产品上传业绩目标，展示进度条、曲线，支持提醒和筛选
6.列配置：新增业绩目标字段“目标值”“完成值”“实际成率”
7.导出：新增业绩目标字段“目标值”“完成值”“实际成率”
8.ASIN360：曲线图新增“成交均价”
验收标准
1.正常设置、修改/删除SKU变得通知
2.按规则发生提示消息，并按需求记录并可查询
3.按销售额、销量两个维度，设置、修改、查询业绩目标
4.正常显示业绩目标数据：列表、详情
5.字段配置、导出新增业绩目标相关字段
6.系统查询优化
查询listing慢，接口：
/detail/getAmazonListing
对应sql：SELECT
tal.id AS id,
tal.customer_id AS customerId,
tal.source_id AS sourceId,
tal.seller_id AS sellerId,
tal.NAME AS NAME,
tal.parent_asin AS parentAsin,
tal.asin AS asin,
tal.msku AS msku,
tal.sku AS sku,
tal.fnsku AS fnsku,
tal.image AS image,
tal.salesman_id AS salesmanId,
tal.business_user_id AS businessUserId,
tal.business_user_name AS businessUserName,
tal.salesman AS salesman,
tal.product_name_cn AS productNameCn,
tal.source_name AS sourceName,
tal.publish_time AS publishTime,
tal.sale_price AS salePrice,
tal.product_id AS productId,
tal.delivery_type AS deliveryType,
tal.STATUS AS STATUS,
tal.quality AS quality,
tal.product_status AS productStatus,
tal.currency AS currency,
tal.country AS country,
tal.department_id AS departmentId,
tal.department_name AS departmentName,
tal.is_deleted AS isDeleted,
tal.is_join_small AS isJoinSmall
FROM
t_amazon_listing tal
WHERE
tal.customer_id = 1
AND tal.msku IN (
'2157458-6605-1014076531',
'BM-V3FJ-J5P1',
'9B-BGH4-G60F',
'C6-JCJW-NONF',
'3T-2AUS-5TJR',
'water-flosser-1',
'water-flosser-22',
'ND-ND-P',
'M0-XW8I-X3PJ',
'ND-ND-G',
'1Q-MHEE-AYBR',
'3PHOX29PEGG54H441214L',
'5G-DR0V-HP8M',
'24OMQZ20U5148853BCM8H1GPF',
'01OA8QFV40YQLK2KS15AH11Z',
'F5614614RC8HG',
'0615J501SM9L8RXLCYU',
'S1L87O19J02QA32K5CAB',
'2I-GSTR-ZNAV',
'U722ZCLA36MH2RYE143LV601Z',
'G4G369HOY17OE14TB6A725B',
'536NQK615F6D1149UMSXBM',
'A197KI364ABJZE14RSO7A',
'GS-PX5D-4UY7',
'S5-9R33-T983',
'O4-JVIG-0LYM',
'U8-47FV-OE73',
'XX-3K75-RPWA',
'05R901809HK1',
'W4-YHGA-BQK9',
'IX-WK8C-0MNR',
'I09ME2500ODOH34S',
'Y06908D3JN20RMDAJ9HA',
'9K-9OZW-M61M',
'221251Z9YZ26QV',
'GK-XV29-YPTC',
'21402N0094CZB',
'334166NZ12AP2W5IB8',
'804soapdish',
'6C-I8PO-N1FS',
'UQ-T8SX-XINI',
'OL-SCTU-A4NT',
'8X-JMDK-PU6S',
'PW-RPBU-BXA1',
'F9-R6UN-J0C9',
'DR-WFMN-8TKX',
'F0-DOB6-6DCO',
'fugudanzhiblack-shuang',
'A3YP10CI20628EYMU',
'R022218YTOIDB',
'1219QT3337OB68U1WG',
'BT32SKO307PRF55GRD6OD090',
'R1132D18EKH4',
'XZWCDH145WK1352H8HICO',
'YGW14155FH48R734GHXPB',
'35D1871RK11LM',
'1G-MSCD-Z1WL',
'QN-FIS8-NHAK',
'IV-QGFE-GX2W',
'3O-KHXN-WYIB',
'AS-KE4N-PIX2',
'1G001A11307C8U',
'1307G0601SIYF',
'07X0D01U4X07Q',
'91-H2GK-EG8L',
'TN-2GCT-S4W3',
'725danbronzebrush',
'2G-UY39-P5O0',
'UO-R0F8-4VD8',
'MB-PVUP-OAOB',
'2M6V4753EB1AZD09468',
'AC6OGH413610Q4U4GJ0F',
'K1750X486V5DGTHAB3',
'S544E5PK17JI06UIAI5L51Y',
'241I4VJ28H6C09T8A37122UC',
'A9-I0I1-51KR',
'L224FJ21E1831U4QUNYCX7',
'34-37PS-VCJS',
'804LDDTT',
'ZT-RLI6-YN4L',
'XW12B3HSFMZF53135EDI5F',
'35FZ3312IL6',
'311894652K0W',
'V52PM317WDRI7V18S4',
'PO0143039GYIB0',
'LV43V02WC019',
'03DK10215L',
'1817W9Q471JBKX8YV19W6CMS',
'7038CBZUZ47AHRG11WX',
'714-hsframes-shense',
'714hsframes-qianse',
'CQL710K10Y31KKCX7',
'SY-UWX2-9OCQ',
'9PIFWTDS15M43319122NMN',
'87PEDYGOQ0813793BN2YDXWZ6',
'120HD03Q7538KE5PWLD3LRH',
'D42RNO1UFL18142R',
'18P2942HGE68CWD',
'6N-LJS4-H0JC',
'G6-FBQK-0UHI',
'75-6TGS-HFDD',
'20230425-BS-BS-1',
'QB-FN96-5RUC',
'EB-7PGI-9GAQ',
'71061QA83539PGFV',
'YBKYDM7QP23YQ94915X8',
'1106IA0IYONYQX8350JS',
'amzn.gr.71061QA83539PGFV-p9NVZ2JPjAOE-LN',
'J5E5M15A4402YXL2841',
'M054285VG99HAZ3K8209ZRE9',
'5KOW354Y61418JF26WS',
'N10314FYCR4381KG5035XN75',
'T12132250DNO',
'D43F9B1243B6BI3I0',
'2WG0511131V40LC',
'21K250Z1S5510NNQ3',
'5NMYE8DQ2A1086Z12QR9V2',
'7VUV0K142YH7W45028VRAQWDD',
'725plungerbrush-xin',
'R4L2341UH96PE14VEZ01WS',
'542901J409C3Q',
'KC593QN201403WX1S86357YNP',
'ML493509XRXQ1S',
'SOVE4LE23H2916P94USQKZOA',
'31116B21W1ON9',
'61-HKH0-5W56',
'SW-TVD1-T33A',
'Z6-ACGR-65G5',
'PA-Q8WG-ZEW8',
'24-AMF6-MK2M',
'YRS116O10HE1X05XEDCF9AB',
'H03FU1803JLQVF',
'3127VLUOA43H81410DXOEEGM',
'TC12H459214T1W3DA3YNB4L3',
'14G214572OEIN',
'03BQM17T8U1S448914ZU',
'1135205KWRY18TYVDSJ39F1',
'1195J2263AS8Y'
);