From dfa7a011f47399b1a083d020d9460f6801c9c98c Mon Sep 17 00:00:00 2001 From: hongji.li <hongji.a.li@capgemini.com> Date: 星期三, 01 十一月 2023 15:25:05 +0800 Subject: [PATCH] pegging结果分析优化 --- _Main/UI/MacroPlannerWebApp/Views/Pegging分析.vw | 153 +++++++++++++++++++++++++++++++++++++++++++------- 1 files changed, 131 insertions(+), 22 deletions(-) diff --git "a/_Main/UI/MacroPlannerWebApp/Views/Pegging\345\210\206\346\236\220.vw" "b/_Main/UI/MacroPlannerWebApp/Views/Pegging\345\210\206\346\236\220.vw" index 3866fc3..cf84f9c 100644 --- "a/_Main/UI/MacroPlannerWebApp/Views/Pegging\345\210\206\346\236\220.vw" +++ "b/_Main/UI/MacroPlannerWebApp/Views/Pegging\345\210\206\346\236\220.vw" @@ -15,7 +15,7 @@ rowPosition: 1 rowSpan: 7 columnPosition: 1 - columnSpan: 4 + columnSpan: 3 } components { @@ -52,7 +52,7 @@ rowPosition: 8 rowSpan: 6 columnPosition: 1 - columnSpan: 4 + columnSpan: 3 } components { @@ -69,7 +69,7 @@ dataPath: 'SalesDemandBaseID' dataType: 'string' index: 0 - subtotals: '' + subtotals: 'count' width: 61 } column_StockingPointID @@ -79,7 +79,7 @@ dataType: 'string' index: 1 subtotals: '' - width: 122 + width: 95 } column_Quantity { @@ -88,7 +88,7 @@ dataType: 'real' index: 2 subtotals: '' - width: 59 + width: 51 } column_StartDate { @@ -97,7 +97,7 @@ dataType: 'date' index: 3 subtotals: '' - width: 94 + width: 76 } } } @@ -112,8 +112,8 @@ mode: 'open' rowPosition: 1 rowSpan: 13 - columnPosition: 5 - columnSpan: 8 + columnPosition: 4 + columnSpan: 9 } components { @@ -123,40 +123,58 @@ FormPeggingResult_DataSetLevelPeggingResult { groupDepth: -1 - sort: 'DESC:UnitOfMeasurementName' + sort: 'ProductID' + column_PeggingProductInSalesDemandBase_SalesDemandBaseID + { + columnId: 'PeggingProductInSalesDemandBase.SalesDemandBaseID' + dataPath: 'PeggingProductInSalesDemandBase.SalesDemandBaseID' + dataType: 'string' + index: 0 + subtotals: 'count' + width: 122 + } column_ProductID { columnId: 'ProductID' dataPath: 'ProductID' dataType: 'string' - index: 0 + index: 1 subtotals: '' - width: 210 + width: 164 } column_StockingPointID { columnId: 'StockingPointID' dataPath: 'StockingPointID' dataType: 'string' - index: 1 + index: 2 subtotals: '' - width: 152 + width: 92 } column_StartDate { columnId: 'StartDate' dataPath: 'StartDate' dataType: 'date' - index: 2 + index: 3 subtotals: '' - width: 86 + width: 82 } column_SupplyQuantity { columnId: 'SupplyQuantity' dataPath: 'SupplyQuantity' dataType: 'real' - index: 3 + index: 4 + subtotals: '' + width: 86 + } + column_ActualFulfillmentQuantity + { + columnId: 'ActualFulfillmentQuantity' + dataPath: 'ActualFulfillmentQuantity' + dataType: 'real' + index: 5 subtotals: '' width: 97 } @@ -165,16 +183,16 @@ columnId: 'FulfillmentQuantity' dataPath: 'FulfillmentQuantity' dataType: 'real' - index: 4 + index: 6 subtotals: '' - width: 102 + width: 108 } column_SupplyType { columnId: 'SupplyType' dataPath: 'SupplyType' dataType: 'string' - index: 5 + index: 7 subtotals: '' width: 78 } @@ -183,9 +201,18 @@ columnId: 'UnitOfMeasurementName' dataPath: 'UnitOfMeasurementName' dataType: 'string' - index: 6 + index: 8 subtotals: '' - width: 150 + width: 50 + } + column_NumberOfPlies + { + columnId: 'NumberOfPlies' + dataPath: 'NumberOfPlies' + dataType: 'number' + index: 9 + subtotals: '' + width: 56 } } } @@ -203,7 +230,89 @@ columnPosition: 1 columnSpan: 12 } - components: null + components + { + FormPeggingAllResult_ListPeggingAllResult + { + } + FormPeggingAllResult_DataSetLevelPeggingAllResult + { + groupDepth: 2 + sort: 'ProductID,StockingPointID,StartDate,DESC:PeggingProductInSalesDemandBase.SalesDemandBaseID' + column_PeggingProductInSalesDemandBase_SalesDemandBaseID + { + columnId: 'PeggingProductInSalesDemandBase.SalesDemandBaseID' + dataPath: 'PeggingProductInSalesDemandBase.SalesDemandBaseID' + dataType: 'string' + index: 0 + subtotals: 'count' + width: 150 + } + column_ProductID + { + columnId: 'ProductID' + dataPath: 'ProductID' + dataType: 'string' + index: 1 + subtotals: '' + width: 150 + } + column_StockingPointID + { + columnId: 'StockingPointID' + dataPath: 'StockingPointID' + dataType: 'string' + index: 2 + subtotals: '' + width: 150 + } + column_StartDate + { + columnId: 'StartDate' + dataPath: 'StartDate' + dataType: 'date' + index: 3 + subtotals: '' + width: 150 + } + column_SupplyQuantity + { + columnId: 'SupplyQuantity' + dataPath: 'SupplyQuantity' + dataType: 'real' + index: 4 + subtotals: '' + width: 150 + } + column_FulfillmentQuantity + { + columnId: 'FulfillmentQuantity' + dataPath: 'FulfillmentQuantity' + dataType: 'real' + index: 5 + subtotals: 'sum' + width: 150 + } + column_SupplyType + { + columnId: 'SupplyType' + dataPath: 'SupplyType' + dataType: 'string' + index: 6 + subtotals: '' + width: 150 + } + column_UnitOfMeasurementName + { + columnId: 'UnitOfMeasurementName' + dataPath: 'UnitOfMeasurementName' + dataType: 'string' + index: 7 + subtotals: '' + width: 150 + } + } + } } } userconfigurableinformation -- Gitblit v1.9.3