From adb6335399c5a1658d8d8172a91042585f3e30b1 Mon Sep 17 00:00:00 2001
From: lazhen <17772815105@139.com>
Date: 星期三, 08 一月 2025 11:39:42 +0800
Subject: [PATCH] 机加管线报表周度库存数据问题
---
_Main/BL/Type_MachiningPipelineReport/Method_Generate.qbl | 23 +++--------------------
1 files changed, 3 insertions(+), 20 deletions(-)
diff --git a/_Main/BL/Type_MachiningPipelineReport/Method_Generate.qbl b/_Main/BL/Type_MachiningPipelineReport/Method_Generate.qbl
index aacfb9e..65b4909 100644
--- a/_Main/BL/Type_MachiningPipelineReport/Method_Generate.qbl
+++ b/_Main/BL/Type_MachiningPipelineReport/Method_Generate.qbl
@@ -8,7 +8,7 @@
TextBody:
[*
// 鐢勫叞楦� Jun-25-2024 (created)
- startyearmonth := search.MacroPlan().StartOfPlanning().StartOfMonth().Date();
+ //startyearmonth := search.MacroPlan().StartOfPlanning().StartOfMonth().Date();
table := selectobject( this, Source.Report, report, not report.IsShow() );
//娓呯┖涔嬪墠瀛樺偍鐨勬樉绀烘暟鎹�
this.Clear( search.TimeUnit(), search.StartDate(), search.EndDate() );
@@ -25,26 +25,9 @@
ccassemblyplanqty := sum( daycells, Elements, cell, cell.CCAssemblyPlanQty() );
ccproductionqty := sum( daycells, Elements, cell, cell.CCProductionQty() );
cctransferqty := sum( daycells, Elements, cell, cell.CCTransferQty() );
- ccinventoryqty := 0.0;
dlassemblyplanqty := sum( daycells, Elements, cell, cell.DLAssemblyPlanQty() );
dlproductionqty := sum( daycells, Elements, cell, cell.DLProductionQty() );
dltransferqty := sum( daycells, Elements, cell, cell.DLTransferQty() );
- dlinventoryqty := 0.0;
- if( column.StartDate() = startyearmonth ){//褰撴棩鏈熸槸璁″垝寮�濮嬬涓�涓湀鏃讹紝璁＄畻搴撳瓨鏄疄闄呭簱瀛�
- ccinventoryqty := row.CCInventoryQty() + maxinventory.CCProductionQty() - maxinventory.CCToDLDepartureQty() + maxinventory.DLToCCArrivalQty() - maxinventory.CCAssemblyPlanQty();
- dlinventoryqty := row.DLInventoryQty() + maxinventory.DLProductionQty() - maxinventory.DLToCCDepartureQty() + maxinventory.CCToDLArrivalQty() - maxinventory.DLAssemblyPlanQty();
- }else{
- beforecolumn := column.PreviousColumn();
- beforeinventory := selectobject( showrow, Cell, c, c.Column() = beforecolumn );
- beCCinventoryqty := 0.0;
- beDLinventoryqty := 0.0;
- if( not isnull( beforeinventory ) ){
- beCCinventoryqty := beforeinventory.CCInventoryQty();
- beDLinventoryqty := beforeinventory.DLInventoryQty();
- }
- ccinventoryqty := beCCinventoryqty + maxinventory.CCProductionQty() - maxinventory.CCToDLDepartureQty() + maxinventory.DLToCCArrivalQty() - maxinventory.CCAssemblyPlanQty();
- dlinventoryqty := beDLinventoryqty + maxinventory.DLProductionQty() - maxinventory.DLToCCDepartureQty() + maxinventory.DLToCCDepartureQty() - maxinventory.DLAssemblyPlanQty();
- }
sumcell := selectobject( column, Cell, c, c.Row() = sumrow );
if( isnull( sumcell ) ){
sumcell := column.Cell( relnew, CCAssemblyPlanQty := 0,
@@ -60,11 +43,11 @@
showcell := column.Cell( relnew, CCAssemblyPlanQty := ccassemblyplanqty,
CCProductionQty := ccproductionqty,
CCTransferQty := cctransferqty,
- CCInventoryQty := ccinventoryqty,
+ CCInventoryQty := maxinventory.CCInventoryQty(),
DLAssemblyPlanQty := dlassemblyplanqty,
DLProductionQty := dlproductionqty,
DLTransferQty := dltransferqty,
- DLInventoryQty := dlinventoryqty );
+ DLInventoryQty := maxinventory.DLInventoryQty() );
showrow.Cell( relinsert, showcell );
sumcell.Add( showcell );
--
Gitblit v1.9.3