重现步骤
性能优化效果线上观察
相关功能无报错
| 所属项目 | 技术中心-需求池 |
|---|---|
| 所属模块 | / |
| 所属迭代 | 技术研发中心 9月分支版本（2022年） |
| Bug类型 | 第三方原因(外部系统) |
| 严重程度 | 提示 |
| 优先级 | P2 |
| Bug状态 | 已关闭 |
| 业务部门 | |
| 开发责任人 | |
| 测试责任人 | |
| 解决时效 | 0 |
| 激活次数 | 0 |
| 激活日期 | |
| 当前指派 | Closed 于 2022-09-29 16:44:08 |
| 截止日期 | 0000-00-00 |
| 上线时间 | |
| 上线时效 | |
| 关键词 | |
| 抄送给 |
| 所属迭代 | 技术研发中心 9月分支版本（2022年） |
|---|---|
| 相关需求 | |
| 相关任务 |
| 由谁创建 | 农基望 于 2022-09-29 10:53:50 |
|---|---|
| 影响环境 |
622 |
| 由谁解决 | 鞠智明 于 2022-09-29 11:36:31 |
| 解决版本 | 主干 |
| 解决方案 | 第三方原因（外部系统） |
| 由谁关闭 | 林鸿贵 于 2022-09-29 16:44:08 |
| 最后修改 | 林鸿贵 于 2022-09-29 16:44:08 |
| 相关Bug |
|---|
开发报告
1.操作打印易可达入库清单数据sql查询优化
DECLARE @StockOrderNumber VARCHAR(100) = 'RVG1009-220926-0002';
DECLARE @CustomerID INT = 1;
SELECT tt.StockOrderNumber,
tt.OrderSourceSKU,
tt.ProductName,
tt.NetWeight,
tt.BoxNo,
tt.ProductNum,
tt.Token,
tt.UserKey,
tt.AccountNo
FROM
(
SELECT pop.StockOrderNumber,
whp.OrderSourceSKU,
pro.ProductName,
ISNULL(pro.NetWeight, 0) NetWeight,
pbl.BoxNo,
pbli.ProductNum,
wh.Token,
wh.UserKey,
wh.AccountNo,
pro.SKU
FROM RB_Procurement_Order_Package pop (NOLOCK)
LEFT JOIN RB_OrderInfo oi (NOLOCK)
ON pop.MergerPackageNo = oi.OrderCode
AND pop.CustomerID = oi.CustomerID
LEFT JOIN RB_WareHouse wh (NOLOCK)
ON oi.ToWareHouseID = wh.ID
AND oi.CustomerID = wh.CustomerID
LEFT JOIN RB_PackingBoxingList pbl (NOLOCK)
ON pop.ID = pbl.OrderPackageID
AND pop.CustomerID = pbl.CustomerID
LEFT JOIN RB_PackingBoxingList_Items pbli (NOLOCK)
ON pbl.ID = pbli.PackingBoxingID
LEFT JOIN RB_Product pro (NOLOCK)
ON pbli.SKU = pro.SKU
AND pbli.CustomerID = pro.CustomerID
LEFT JOIN RB_WareHouse_Product whp (NOLOCK)
ON oi.CustomerID = whp.CustomerID
AND oi.ToWareHouseID = whp.WareHouseID
AND pro.SKU = whp.SKU
WHERE pop.StockOrderNumber = @StockOrderNumber
AND pop.CustomerID = @CustomerID
AND pbli.SkuType = 1
UNION
SELECT pop.StockOrderNumber,
whp.OrderSourceSKU,
pro.ProductName,
ISNULL(pro.NetWeight, 0) NetWeight,
pbl.BoxNo,
pbli.ProductNum,
wh.Token,
wh.UserKey,
wh.AccountNo,
pro.SKU
FROM RB_Procurement_Order_Package pop (NOLOCK)
LEFT JOIN RB_OrderInfo oi (NOLOCK)
ON pop.MergerPackageNo = oi.OrderCode
AND pop.CustomerID = oi.CustomerID
LEFT JOIN RB_WareHouse wh (NOLOCK)
ON oi.ToWareHouseID = wh.ID
AND oi.CustomerID = wh.CustomerID
LEFT JOIN RB_PackingBoxingList pbl (NOLOCK)
ON pop.ID = pbl.OrderPackageID
AND pop.CustomerID = pbl.CustomerID
LEFT JOIN RB_PackingBoxingList_Items pbli (NOLOCK)
ON pbl.ID = pbli.PackingBoxingID
LEFT JOIN RB_Product pro (NOLOCK)
ON pbli.SKU = pro.ClientSKU
AND pbli.CustomerID = pro.CustomerID
LEFT JOIN RB_WareHouse_Product whp (NOLOCK)
ON oi.CustomerID = whp.CustomerID
AND oi.ToWareHouseID = whp.WareHouseID
AND pro.SKU = whp.SKU
WHERE pop.StockOrderNumber = @StockOrderNumber
AND pop.CustomerID = @CustomerID
AND pbli.SkuType <> 1
) tt
ORDER BY tt.SKU,
tt.BoxNo;