深圳智汇创想科技有限公司

修改了 版本号 ，旧值为 "1"，新值为 "2"。
修改了 需求名称，区别为：

001- 性能优化-渠道产品销量月报表 导出缓慢 ，影响其他队列 如ID 686615、686613
001+ FMS：性能优化-渠道产品销量月报表隐藏

001- 性能优化-渠道产品销量月报表 导出缓慢 ，影响其他队列 如ID 686615、686613
001+ FMS：性能优化-渠道产品销量月报表隐藏

修改了 需求描述，区别为：

001- [性能问题描述]周美花 的渠道产品 销量月报表导出缓慢，尝尝阻塞队列，而超时 无法导出
001+ 性能优化-渠道产品销量月报表 导出缓慢 ，影响其他队列 如ID 686615、686613
002- 功能菜单注释移除；
002+ [性能问题描述]周美花 的渠道产品 销量月报表导出缓慢，尝尝阻塞队列，而超时 无法导出
003-
003+ 功能菜单注释移除；
004-
004+
005-
005+
006-
006+
007- select ROW_NUMBER() over(order by a.SKU) '编号', a.ProductGroupSKU '母体ID', a.SKU, a.OrderSourceSKU '渠道SKU', a.ClientSKU '自定义SKU', a.ASINorItemID 'ASIN', a.SalesNum '销售数量', a.WareHouseName '仓库名称', a.GoodNum '库存数量', convert(varchar(4), a.SalesYear) + '年' + convert(varchar(2), a.SalesMonth) + '月' '时间', a.OrderNum '订单数', a.OrderSourceName '订单来源', a.ProductName '产品名称', a.ProductNameCN '产品中文名' from( select ROW_NUMBER() over(PARTITION by a.CustomerID,a.OrderSourceID,a.SKU,a.OrderSourceSKU,a.WareHouseID, a.SalesYear, a.SalesMonth order by a.CustomerID,a.OrderSourceID,a.SKU,a.OrderSourceSKU,a.WareHouseID, a.SalesYear, a.SalesMonth) SortNum, a.ProductGroupSKU, a.SKU, a.OrderSourceSKU, a.ClientSKU, b.ASINorItemID, a.SalesNum, a.WareHouseName, a.GoodNum, a.SalesYear, a.SalesMonth, a.OrderNum, a.OrderSourceName, a.ProductName, a.ProductNameCN from dbo.View_RB_Report_OrderSourceSKUMonth a WITH(NOLOCK) LEFT JOIN dbo.RB_Amazon_Product_Base(NOLOCK) b ON b.CustomerID = a.CustomerID AND b.OrderSourceID = a.OrderSourceID AND b.SKU = a.SKU AND b.OrderSourceSKU = a.OrderSourceSKU AND b.IsOffShelf IN(0, 1, 2) AND b.IsDelete=0 AND b.ASINorItemID != '' where (DATEDIFF(MONTH,CAST(a.SalesYear AS NVARCHAR(4)) + '-' + CAST(a.SalesMonth AS NVARCHAR(2))+'-1','2022-1-1')<=0) AND (DATEDIFF(MONTH,CAST(a.SalesYear AS NVARCHAR(4)) + '-' + CAST(a.SalesMonth AS NVARCHAR(2))+'-1','2023-7-1')>=0) AND (a.OrderSourceID IN(9948)) AND (a.CustomerID=1) AND (a.SalesNum>0) AND (a.OrderSourceID IN (SELECT OrderSourceID FROM RB_OrderSource_SaleAdmin (NOLOCK) WHERE AdminID=5841)) ) a where SortNum = 1
007+
008- [分析过程]
008+ select ROW_NUMBER() over(order by a.SKU) '编号', a.ProductGroupSKU '母体ID', a.SKU, a.OrderSourceSKU '渠道SKU', a.ClientSKU '自定义SKU', a.ASINorItemID 'ASIN', a.SalesNum '销售数量', a.WareHouseName '仓库名称', a.GoodNum '库存数量', convert(varchar(4), a.SalesYear) + '年' + convert(varchar(2), a.SalesMonth) + '月' '时间', a.OrderNum '订单数', a.OrderSourceName '订单来源', a.ProductName '产品名称', a.ProductNameCN '产品中文名' from( select ROW_NUMBER() over(PARTITION by a.CustomerID,a.OrderSourceID,a.SKU,a.OrderSourceSKU,a.WareHouseID, a.SalesYear, a.SalesMonth order by a.CustomerID,a.OrderSourceID,a.SKU,a.OrderSourceSKU,a.WareHouseID, a.SalesYear, a.SalesMonth) SortNum, a.ProductGroupSKU, a.SKU, a.OrderSourceSKU, a.ClientSKU, b.ASINorItemID, a.SalesNum, a.WareHouseName, a.GoodNum, a.SalesYear, a.SalesMonth, a.OrderNum, a.OrderSourceName, a.ProductName, a.ProductNameCN from dbo.View_RB_Report_OrderSourceSKUMonth a WITH(NOLOCK) LEFT JOIN dbo.RB_Amazon_Product_Base(NOLOCK) b ON b.CustomerID = a.CustomerID AND b.OrderSourceID = a.OrderSourceID AND b.SKU = a.SKU AND b.OrderSourceSKU = a.OrderSourceSKU AND b.IsOffShelf IN(0, 1, 2) AND b.IsDelete=0 AND b.ASINorItemID != '' where (DATEDIFF(MONTH,CAST(a.SalesYear AS NVARCHAR(4)) + '-' + CAST(a.SalesMonth AS NVARCHAR(2))+'-1','2022-1-1')<=0) AND (DATEDIFF(MONTH,CAST(a.SalesYear AS NVARCHAR(4)) + '-' + CAST(a.SalesMonth AS NVARCHAR(2))+'-1','2023-7-1')>=0) AND (a.OrderSourceID IN(9948)) AND (a.CustomerID=1) AND (a.SalesNum>0) AND (a.OrderSourceID IN (SELECT OrderSourceID FROM RB_OrderSource_SaleAdmin (NOLOCK) WHERE AdminID=5841)) ) a where SortNum = 1
009-
009+ [分析过程]
010- [期望结果]提升效率 减少 导出时长
010+
011+ [期望结果]提升效率 减少 导出时长

001- <p>[性能问题描述]周美花 的渠道产品 销量月报表导出缓慢，尝尝阻塞队列，而超时 无法导出</p>
001+ <p>性能优化-渠道产品销量月报表 导出缓慢 ，影响其他队列 如ID 686615、686613</p>
002- <p>功能菜单注释移除；</p>
002+ <p>[性能问题描述]周美花 的渠道产品 销量月报表导出缓慢，尝尝阻塞队列，而超时 无法导出</p>
003- <p><img src="{284180.png}" alt="" /></p>
003+ <p>功能菜单注释移除；</p>
004- <p><br /></p>
004+ <p><img src="{284180.png}" alt="" /></p>
005- <p><img src="{280679.png}" alt="" /></p>
005+ <p><br /></p>
006- <p><br /></p>
006+ <p><img src="{280679.png}" alt="" /></p>
007- <p>select ROW_NUMBER() over(order by a.SKU) '编号', a.ProductGroupSKU '母体ID', a.SKU, a.OrderSourceSKU '渠道SKU', a.ClientSKU '自定义SKU', a.ASINorItemID 'ASIN', a.SalesNum '销售数量', a.WareHouseName '仓库名称', a.GoodNum '库存数量', convert(varchar(4), a.SalesYear) + '年' + convert(varchar(2), a.SalesMonth) + '月' '时间', a.OrderNum '订单数', a.OrderSourceName '订单来源', a.ProductName '产品名称', a.ProductNameCN '产品中文名' from( select ROW_NUMBER() over(PARTITION by a.CustomerID,a.OrderSourceID,a.SKU,a.OrderSourceSKU,a.WareHouseID, a.SalesYear, a.SalesMonth order by a.CustomerID,a.OrderSourceID,a.SKU,a.OrderSourceSKU,a.WareHouseID, a.SalesYear, a.SalesMonth) SortNum, a.ProductGroupSKU, a.SKU, a.OrderSourceSKU, a.ClientSKU, b.ASINorItemID, a.SalesNum, a.WareHouseName, a.GoodNum, a.SalesYear, a.SalesMonth, a.OrderNum, a.OrderSourceName, a.ProductName, a.ProductNameCN from dbo.View_RB_Report_OrderSourceSKUMonth a WITH(NOLOCK) LEFT JOIN dbo.RB_Amazon_Product_Base(NOLOCK) b ON b.CustomerID = a.CustomerID AND b.OrderSourceID = a.OrderSourceID AND b.SKU = a.SKU AND b.OrderSourceSKU = a.OrderSourceSKU AND b.IsOffShelf IN(0, 1, 2) AND b.IsDelete=0 AND b.ASINorItemID != '' where (DATEDIFF(MONTH,CAST(a.SalesYear AS NVARCHAR(4)) + '-' + CAST(a.SalesMonth AS NVARCHAR(2))+'-1','2022-1-1')&lt;=0) AND (DATEDIFF(MONTH,CAST(a.SalesYear AS NVARCHAR(4)) + '-' + CAST(a.SalesMonth AS NVARCHAR(2))+'-1','2023-7-1')&gt;=0) AND (a.OrderSourceID IN(9948)) AND (a.CustomerID=1) AND (a.SalesNum&gt;0) AND (a.OrderSourceID IN (SELECT OrderSourceID FROM RB_OrderSource_SaleAdmin (NOLOCK) WHERE AdminID=5841)) ) a where SortNum = 1</p>
007+ <p><br /></p>
008- <p>[分析过程]</p>
008+ <p>select ROW_NUMBER() over(order by a.SKU) '编号', a.ProductGroupSKU '母体ID', a.SKU, a.OrderSourceSKU '渠道SKU', a.ClientSKU '自定义SKU', a.ASINorItemID 'ASIN', a.SalesNum '销售数量', a.WareHouseName '仓库名称', a.GoodNum '库存数量', convert(varchar(4), a.SalesYear) + '年' + convert(varchar(2), a.SalesMonth) + '月' '时间', a.OrderNum '订单数', a.OrderSourceName '订单来源', a.ProductName '产品名称', a.ProductNameCN '产品中文名' from( select ROW_NUMBER() over(PARTITION by a.CustomerID,a.OrderSourceID,a.SKU,a.OrderSourceSKU,a.WareHouseID, a.SalesYear, a.SalesMonth order by a.CustomerID,a.OrderSourceID,a.SKU,a.OrderSourceSKU,a.WareHouseID, a.SalesYear, a.SalesMonth) SortNum, a.ProductGroupSKU, a.SKU, a.OrderSourceSKU, a.ClientSKU, b.ASINorItemID, a.SalesNum, a.WareHouseName, a.GoodNum, a.SalesYear, a.SalesMonth, a.OrderNum, a.OrderSourceName, a.ProductName, a.ProductNameCN from dbo.View_RB_Report_OrderSourceSKUMonth a WITH(NOLOCK) LEFT JOIN dbo.RB_Amazon_Product_Base(NOLOCK) b ON b.CustomerID = a.CustomerID AND b.OrderSourceID = a.OrderSourceID AND b.SKU = a.SKU AND b.OrderSourceSKU = a.OrderSourceSKU AND b.IsOffShelf IN(0, 1, 2) AND b.IsDelete=0 AND b.ASINorItemID != '' where (DATEDIFF(MONTH,CAST(a.SalesYear AS NVARCHAR(4)) + '-' + CAST(a.SalesMonth AS NVARCHAR(2))+'-1','2022-1-1')&lt;=0) AND (DATEDIFF(MONTH,CAST(a.SalesYear AS NVARCHAR(4)) + '-' + CAST(a.SalesMonth AS NVARCHAR(2))+'-1','2023-7-1')&gt;=0) AND (a.OrderSourceID IN(9948)) AND (a.CustomerID=1) AND (a.SalesNum&gt;0) AND (a.OrderSourceID IN (SELECT OrderSourceID FROM RB_OrderSource_SaleAdmin (NOLOCK) WHERE AdminID=5841)) ) a where SortNum = 1</p>
009- <p><br /></p>
009+ <p>[分析过程]</p>
010- <p>[期望结果]提升效率 减少 导出时长</p>
010+ <p><br /></p>
011+ <p>[期望结果]提升效率 减少 导出时长</p>

修改了 所属计划，旧值为 ""，新值为 "811"。

修改了 指派给，旧值为 "lihuiyun"，新值为 "linhen"。

修改了 所属计划，旧值为 "811"，新值为 ""。

修改了 关闭原因，旧值为 ""，新值为 "willnotdo"。
修改了 当前状态，旧值为 "draft"，新值为 "closed"。
修改了 指派给 ，旧值为 "linhen"，新值为 "closed"。
修改了 所处阶段，旧值为 "wait"，新值为 "closed"。
修改了 关闭日期，旧值为 "0000-00-00 00:00:00"，新值为 "2023-10-09 20:39:10"。
修改了 由谁关闭，旧值为 ""，新值为 "linhen"。

修改了 上线时间，旧值为 "2023-07-27"，新值为 "0"。