需求背景：erp内的cbt政策表现经常因为服务器资源不足导致线程中断等情况无法更新数据。
需求内容：
cbt政策表现转java重构同步，并将数据保存在智能刊登的数据库中，erp页面调用智能刊登的api进行展示。涉及页面：
注：高风险！改造时注意核对相关字段及接口，避免遗漏字段/服务。
需求背景：erp内的cbt政策表现经常因为服务器资源不足导致线程中断等情况无法更新数据。
需求内容：
cbt政策表现转java重构同步，并将数据保存在智能刊登的数据库中，erp页面调用智能刊登的api进行展示。涉及页面：
注：高风险！改造时注意核对相关字段及接口，避免遗漏字段/服务。
004-<img src="/zentao/file-read-454696.png" alt="" />
004+
004-<p><img src="/zentao/file-read-454696.png" alt="" /></p>
004+ <p><img src="{454696.png}" alt="" /></p>
004-<img src="/zentao/file-read-454696.png" alt="" />
004+
004-<p><img src="/zentao/file-read-454696.png" alt="" /></p>
004+ <p><img src="{454696.png}" alt="" /></p>
相关数据表
SELECT top 10 * FROM RB_Ebay_DashboardCBT_DefecNonShipping ORDER BY ID DESC;
SELECT top 10 * FROM RB_Ebay_DashboardCBT_DefectMetricSettingList ORDER BY ID DESC;
SELECT top 10 * FROM RB_Ebay_DashboardCBT_DefectMS_BreakdownItem ORDER BY ID DESC;
SELECT top 10 * FROM RB_Ebay_DashboardCBT_DefectOverview ORDER BY ID DESC;
SELECT top 10 * FROM RB_Ebay_DashboardCBT_DefectTransaction_Listing ORDER BY ID DESC;
SELECT top 10 * FROM RB_Ebay_DashboardCBT_DefectTransaction_Transactions ORDER BY ID DESC;
SELECT top 10 * FROM RB_Ebay_DashboardCBT_DirectShippingAcct ORDER BY ID DESC;
SELECT top 10 * FROM RB_Ebay_DashboardCBT_DirectShippingTrans ORDER BY ID DESC;
SELECT top 10 * FROM RB_Ebay_DashboardCBT_LTNP ORDER BY ID DESC;
SELECT top 10 * FROM RB_Ebay_DashboardCBT_OverseasStandard_Transaction_V2 ORDER BY ID DESC;
SELECT top 10 * FROM RB_Ebay_DashboardCBT_OverseasStandard_V2 ORDER BY ID DESC;
SELECT top 10 * FROM RB_Ebay_DashboardCBT_PolicyBoard ORDER BY ID DESC;
SELECT top 10 * FROM RB_Ebay_DashboardCBT_PolicyDetail ORDER BY ID DESC;
SELECT top 10 * FROM RB_Ebay_DashboardCBT_PoorTrading ORDER BY ID DESC;
SELECT top 10 * FROM RB_Ebay_DashboardCBT_SellerINR ORDER BY ID DESC;
SELECT top 10 * FROM RB_Ebay_DashboardCBT_SellerINRList ORDER BY ID DESC;
SELECT top 10 * FROM RB_Ebay_DashboardCBT_SpkDownloadlist ORDER BY ID DESC;
SELECT top 10 * FROM RB_Ebay_DashboardCBT_Spklist ORDER BY ID DESC;
SELECT top 10 * FROM RB_Ebay_DashboardCBT_SpkMisuseData ORDER BY ID DESC;
SELECT top 10 * FROM RB_Ebay_DashboardCBT_SpkMisuseDownloadData ORDER BY ID DESC;
SELECT top 10 * FROM RB_Ebay_DashboardCBT_Status ORDER BY ID DESC;
SELECT top 10 * FROM RB_Ebay_DashboardCBT_SynTask ORDER BY ID DESC;
SELECT top 10 * FROM RB_Ebay_DashboardCBT_TransDO_Spklist ORDER BY ID DESC;
| 所属迭代 | 智能中心-EBAY直发迭代 |
|---|---|
| 所属模块 | 智能中心-需求池 战略独立项目 EBAY直发 |
| 相关需求 | ebay：cbt政策表现转java同步（高风险） |
| 指派给 | 胡笑锋 于 2025-04-15 10:45:11 |
| 任务类型 | 后端 |
| 任务标签 | 初始 |
| 开发组 | 百货开发组 |
| 任务状态 | 已完成 |
| 进度 | 100% |
| 优先级 | P3 |
| 关键词 | |
| 抄送给 |
| 由谁创建 | 胡笑锋 于 2025-03-12 08:58:44 |
|---|---|
| 由谁完成 | 贾立鹏 于 2025-03-21 16:28:09 |
| 由谁取消 | 暂无 |
| 由谁关闭 | 暂无 |
| 关闭原因 | 暂无 |
| 最后编辑 | 贾立鹏 于 2025-04-15 10:45:11 |
| 团队 | 最初预计 | 总计消耗 | 预计剩余 |
|---|
| 最初预计 | 72工时 |
|---|---|
| 总计消耗 | 8工时 |
| 预计剩余 | 0工时 |
| 预计开始 | 2025-03-12 |
| 实际开始 | 2025-03-12 |
| 截止日期 | 2025-03-18 |
-- 灰度渠道配置 测试环境需清除 灰度配置的渠道只在灰度环境执行
SELECT * FROM sys_sandbox_ordersource WHERE (businessType = 200)
-- 获取可执行eBay渠道
SELECT t1.OrderSourceName, t1.OrderSourceCountry, t2.*FROM RB_OrderSource t1 WITH (nolock) JOIN RB_OrderSource_API t2
WITH (nolock)
ON t1.CustomerID=t2.CustomerID AND t1.ID=t2.OrderSourceID
WHERE t1.IsActive=1 AND t2.IsActive=1 AND t1.OrderSourceType=2
-- 获取在执行的队列数据
SELECT DATEDIFF(HH, SynDate, GETDATE()) AS HHCount, [ID], [CustomerID], [OrderSourceID], [SynAPIDataType], [SynStatus], [SynDate], [ErrorMsg], [AddDate], [UpdateDate] FROM ( SELECT MAX (ID) OVER () AS MaxID, [ID], [CustomerID], [OrderSourceID], [SynAPIDataType], [SynStatus], [SynDate], [ErrorMsg], [AddDate], [UpdateDate] FROM [RB_Ebay_DashboardCBT_SynTask] WITH (NOLOCK) WHERE CustomerID=1 AND OrderSourceID= 5613 AND SynAPIDataType= 3 ) AS temp WHERE MaxID=ID
任务执行XXjob
syncDashboardCbtTask