存档报表界面查询

lazhen

2024-11-22 f244ae12e0b29ced1402f8c2eda462845fb20875

存档报表界面查询

 _Main/BL/Relations/Relation_CustomerDemandArchive_InterfaceDataset_InterfaceDataset_CustomerDem.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,23 @@
Quintiq file version 2.0
#parent: #root
Relation CustomerDemandArchive_InterfaceDataset_InterfaceDataset_CustomerDemandArchive
{
  #keys: '1[415136.0.1330369439]'
  DefaultRelationStrategy
  {
  }
  RelationSide.LeftSide InterfaceDataset
  {
    #keys: '3[415136.0.1330369441][415136.0.1330369440][415136.0.1330369442]'
    Cardinality: '0to1'
    ObjectDefinition: CustomerDemandArchive
    OwningSide: 'Reference'
  }
  RelationSide.RightSide CustomerDemandArchive
  {
    #keys: '3[415136.0.1330369444][415136.0.1330369443][415136.0.1330369445]'
    Cardinality: '1toN'
    ObjectDefinition: InterfaceDataset
    OwningSide: 'Owned'
  }
}

 _Main/BL/Type_AssemblyOnlinePlanColumn0/Method_Filter.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,18 @@
Quintiq file version 2.0
#parent: #root
Method Filter (
  AssemblyOnlinePlanVersionSearch search
) declarative remote as Boolean
{
  TextBody:
  [*
    // ç”„兰鸽 Nov-22-2024 (created)
    flag       := false;
    
    if( ( search.StartDate().IsMinInfinity() or this.StartDate() >= search.StartDate() ) and ( search.EndDate().IsMaxInfinity() or this.EndDate() <= search.EndDate() ) ){
      flag     := true;
    }
    
    return flag;
  *]
}

 _Main/BL/Type_AssemblyOnlinePlanVersion/StaticMethod_RefreshData.qbl

@@ -11,15 +11,15 @@
    interface.AssemblyOnlinePlanVersion( relflush );
    allunit                := AssemblyOnlinePlanVersion::GetDefaultAllUnit();
    name                   := AssemblyOnlinePlanVersion::GetDefaultName();//search                 := 
    search                 := interface.AssemblyOnlinePlanVersionSearch( relnew, Product := allunit, ProductionLine := allunit, Unit := allunit, StartDate := Date::MinDate(), EndDate := Date::MaxDate() );//, TimeUnit := Translations::MP_GlobalParameters_Day()
    interface.AssemblyOnlinePlanVersionSearch( relnew, Product := allunit, ProductionLine := allunit, Unit := allunit, StartDate := Date::MinDate(), EndDate := Date::MaxDate() );//, TimeUnit := Translations::MP_GlobalParameters_Day()
    table                  := selectobject( interface, AssemblyOnlinePlanVersion, version, not version.IsShow() );
    if( isnull( table ) ){
      table                := interface.AssemblyOnlinePlanVersion( relnew, ID := name, Name := name );
    }
    showtable              := selectobject( interface, AssemblyOnlinePlanVersion, version, version.IsShow() );
    if( isnull( showtable ) ){
      showtable               := interface.AssemblyOnlinePlanVersion( relnew, ID := name, Name := name, IsShow := true );
    }
    //showtable              := selectobject( interface, AssemblyOnlinePlanVersion, version, version.IsShow() );
    //if( isnull( showtable ) ){
    //  showtable               := interface.AssemblyOnlinePlanVersion( relnew, ID := name, Name := name, IsShow := true );
    //}
    aopcolumns             := selectuniquevalues(  macroPlan, NewAssemblyOnlinePlanColumn, aopcolumn, not exists( table, Column, column, column.StartDate() = aopcolumn.StartDate() ), aopcolumn.StartDate() );//, column.TimeUnit() = Translations::MP_GlobalParameters_Day()
    if( aopcolumns.Size() > 0 ){
      table.GenerateColumn( aopcolumns, false );
@@ -34,8 +34,8 @@
        cell.Quantity( qty );
      }
    }
    productids             := selectuniquevalues( table, Row, row, row.Name() );
    productlines           := selectuniquevalues( table, Row, row, row.ProductionLine() );
    showtable.Generate( search, productids, productlines );
    //productids             := selectuniquevalues( table, Row, row, row.Name() );
    //productlines           := selectuniquevalues( table, Row, row, row.ProductionLine() );
    //showtable.Generate( search, productids, productlines );
  *]
}

 _Main/BL/Type_CustomerDemandArchive/Attribute_EndDate.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,7 @@
Quintiq file version 2.0
#parent: #root
Attribute EndDate
{
  #keys: '3[415136.0.1330369482][415136.0.1330369481][415136.0.1330369483]'
  ValueType: Date
}

 _Main/BL/Type_CustomerDemandArchive/Attribute_Factory.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,7 @@
Quintiq file version 2.0
#parent: #root
Attribute Factory
{
  #keys: '3[415136.0.1330369522][415136.0.1330369521][415136.0.1330369523]'
  ValueType: String
}

 _Main/BL/Type_CustomerDemandArchive/Attribute_FactoryName.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,7 @@
Quintiq file version 2.0
#parent: #root
Attribute FactoryName
{
  #keys: '3[415136.0.1330369548][415136.0.1330369547][415136.0.1330369549]'
  ValueType: String
}

 _Main/BL/Type_CustomerDemandArchive/Attribute_Origin.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute Origin
{
  #keys: '3[415136.0.1330369462][415136.0.1330369461][415136.0.1330369463]'
  Description: '来源'
  ValueType: String
}

 _Main/BL/Type_CustomerDemandArchive/Attribute_Product.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute Product
{
  #keys: '3[415136.0.1330369418][415136.0.1330369417][415136.0.1330369419]'
  Description: '物料号'
  ValueType: String
}

 _Main/BL/Type_CustomerDemandArchive/Attribute_Quantity.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,7 @@
Quintiq file version 2.0
#parent: #root
Attribute Quantity
{
  #keys: '3[415136.0.1330369492][415136.0.1330369491][415136.0.1330369493]'
  ValueType: Real
}

 _Main/BL/Type_CustomerDemandArchive/Attribute_SalesSegment.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,7 @@
Quintiq file version 2.0
#parent: #root
Attribute SalesSegment
{
  #keys: '3[415136.0.1330369512][415136.0.1330369511][415136.0.1330369513]'
  ValueType: String
}

 _Main/BL/Type_CustomerDemandArchive/Attribute_StartDate.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,7 @@
Quintiq file version 2.0
#parent: #root
Attribute StartDate
{
  #keys: '3[415136.0.1330369472][415136.0.1330369471][415136.0.1330369473]'
  ValueType: Date
}

 _Main/BL/Type_CustomerDemandArchive/Attribute_StockingPointID.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,7 @@
Quintiq file version 2.0
#parent: #root
Attribute StockingPointID
{
  #keys: '3[415136.0.1330369502][415136.0.1330369501][415136.0.1330369503]'
  ValueType: String
}

 _Main/BL/Type_CustomerDemandArchive/DefaultValue_Product.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,6 @@
Quintiq file version 2.0
#parent: #root
DefaultValue
{
  TargetAttribute: Product
}

 _Main/BL/Type_CustomerDemandArchive/Function_CalcEndDate.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,13 @@
Quintiq file version 2.0
#parent: #root
Function CalcEndDate
{
  TextBody:
  [*
    // ç”„兰鸽 Nov-22-2024 (created)
    
    value := ( this.StartDate() + Duration::Days( 1 ) ).Date();
    
    this.EndDate( value );
  *]
}

 _Main/BL/Type_CustomerDemandArchive/StaticMethod_GenerateData.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,69 @@
Quintiq file version 2.0
#parent: #root
StaticMethod GenerateData (
  InterfaceDataset interface,
  MacroPlan macroplan,
  RecycleBin recycle,
  const Archive archive
)
{
  Description: '生成客户需求存档数据'
  TextBody:
  [*
    // ç”„兰鸽 Nov-22-2024 (created)
    info( '-------------------------Start---------------------');
    binaryValue           := TemplateManager::GetIDSFullTable( archive, Date::ActualDate().Year() );
    source                := GeneralExcelImportAndExportDataSource::Upload( recycle, binaryValue, OS::TempPath() + "template.xlsx" );
    source.ReadStructure();
    Transaction::Transaction().Propagate( attribute( GeneralExcelImportAndExportDataColumn, ColumnIndex ) );
    cnv2 := StringToDate::StandardConverter();
    cnv2.SetCustomConversion();
    cnv2.CustomFormatString( "yyyy/MM/dd" );
    
    traverse( recycle, GeneralExcelImportAndExportDataSource.GeneralExcelImportAndExportDataTable, table ){
      traverse( table, GeneralExcelImportAndExportDataRow, row ){
        productcell       := selectobject( row, GeneralExcelImportAndExportDataCell, cell, cell.GeneralExcelImportAndExportDataColumn().ColumnIndex() = 2 );
        factorycell       := selectobject( row, GeneralExcelImportAndExportDataCell, cell, cell.GeneralExcelImportAndExportDataColumn().ColumnIndex() = 0 );
        unitname          := ifexpr( factorycell.Value().StartsWith( '长春' ), FinancialProductionReport::GetDefaultCCUnit(), FinancialProductionReport::GetDefaultDLUnit() );
    //    idsrow            := idstable.GetRowByUnit( productcell.Value(), unitname );
        traverse( row, GeneralExcelImportAndExportDataCell, cell, cell.GeneralExcelImportAndExportDataColumn().ColumnIndex() > 2 ){
          period          := cnv2.Convert( cell.GeneralExcelImportAndExportDataColumn().Name() );
          archivedata     := selectobject( interface, CustomerDemandArchive, archivedata, archivedata.Factory() = factorycell.Value()
                                           and archivedata.Product() = productcell.Value()
                                           and archivedata.StartDate() = period
                                           and archivedata.Origin() = 'IDS' );
          if( isnull( archivedata ) ){
            archivedata   := interface.CustomerDemandArchive( relnew, Factory := factorycell.Value(), Product := productcell.Value(), StartDate := period, Origin := 'IDS', FactoryName := unitname );
          }
          archivedata.Quantity( [Real]cell.Value() );
        }
      }
    }
    traverse ( macroplan, SalesDemand.astype( Forecast ), forecast, not isnull( forecast.Product_MP() ) and forecast.Origin() = 'PPA' ){
      
      unitname              := ifexpr( forecast.StockingPointID().StartsWith( '长春' ) , FinancialProductionReport::GetDefaultCCUnit(), FinancialProductionReport::GetDefaultDLUnit() );/*ifexpr( forecast.SalesSegment_MP().Name().StartsWith( 'Changchun' ) 
                                       or exists( forecast.SalesSegment_MP().GetAllParent(), Elements, psalessegment, psalessegment.Name().StartsWith( 'Changchun' ) )
                                       , FinancialProductionReport::GetDefaultCCUnit()
                                       , FinancialProductionReport::GetDefaultDLUnit() );*/
      traverse( forecast, PlanningSalesDemandInPeriod, sdip ){
        archivedata         := selectobject( interface, CustomerDemandArchive, archivedata, archivedata.SalesSegment() = forecast.SalesSegmentName()
                                               and archivedata.StockingPointID() =forecast.StockingPointID()
                                               and archivedata.Product() = forecast.ProductID()
                                               and archivedata.StartDate() = forecast.StartDate() 
                                               and archivedata.Origin() = forecast.Origin() );
        if( isnull( archivedata ) ){
          archivedata       := interface.CustomerDemandArchive( relnew, SalesSegment             := forecast.SalesSegmentName()
                                                                , Product                        := forecast.ProductID()
                                                                , StockingPointID                := forecast.StockingPointID()
                                                                , StartDate                      := forecast.StartDate() 
                                                                , Origin                         := forecast.Origin()
                                                                , FactoryName                    := unitname );
        }
        archivedata.Quantity( sdip.Quantity() );
      }
    }
    
    source.Delete();
    info( '-------------------------End---------------------');
  *]
}

 _Main/BL/Type_CustomerDemandArchive/_ROOT_Type_CustomerDemandArchive.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,10 @@
Quintiq file version 2.0
#root
#parent: #DomainModel
Type CustomerDemandArchive
{
  #keys: '5[415136.0.1330369408][415136.0.1330369406][0.0.0][415136.0.1330369407][415136.0.1330369409]'
  BaseType: Object
  Description: '客户需求存档'
  StructuredName: 'CustomerDemandArchives'
}

 _Main/BL/Type_CustomerDemandIDS/StaticMethod_GenerateData.qbl

@@ -14,17 +14,17 @@
    //interface.CustomerDemandIDS( relflush );
    //interface.CustomerDemandIDSSearch( relflush );
    info( '-------------------------Start---------------------');
    allunit               := CustomerDemandIDS::GetDefaultAllUnit();
    search                := interface.CustomerDemandIDSSearch( relnew, Product := allunit, StartDate := Date::MinDate(), EndDate := Date::MaxDate(), Unit := allunit );
    allunit               := CustomerDemandIDS::GetDefaultAllUnit();//search                := 
    interface.CustomerDemandIDSSearch( relnew, Product := allunit, StartDate := Date::MinDate(), EndDate := Date::MaxDate(), Unit := allunit );
    name                  := '客户需求';
    idstable              := selectobject( interface, CustomerDemandIDS, idstable, idstable.ID() = name );
    if( isnull( idstable ) ){
      idstable            := interface.CustomerDemandIDS( relnew, ID := name, Name := name );
    }
    showtable             := selectobject( interface, CustomerDemandIDS, version, version.IsShow() );
    if( isnull( showtable ) ){
      showtable           := interface.CustomerDemandIDS( relnew, ID := name + 'Show', Name := name, IsShow := true );
    }
    //showtable             := selectobject( interface, CustomerDemandIDS, version, version.IsShow() );
    //if( isnull( showtable ) ){
    //  showtable           := interface.CustomerDemandIDS( relnew, ID := name + 'Show', Name := name, IsShow := true );
    //}
    binaryValue           := TemplateManager::GetIDSFullTable( archive, Date::ActualDate().Year() );
    source                := GeneralExcelImportAndExportDataSource::Upload( recycle, binaryValue, OS::TempPath() + "template.xlsx" );
    source.ReadStructure();
@@ -48,12 +48,12 @@
        traverse( row, GeneralExcelImportAndExportDataCell, cell, cell.GeneralExcelImportAndExportDataColumn().ColumnIndex() > 2 ){
          period          := cnv2.Convert( cell.GeneralExcelImportAndExportDataColumn().Name() );
          daycolumn       := idstable.GetColumnByTimeUnit( Translations::MP_GlobalParameters_Day(), period );
          weekcolumn      := idstable.GetColumnByTimeUnit( Translations::MP_GlobalParameters_Week(), period );
          monthcolumn     := idstable.GetColumnByTimeUnit( Translations::MP_GlobalParameters_Month(), period );
    //      weekcolumn      := idstable.GetColumnByTimeUnit( Translations::MP_GlobalParameters_Week(), period );
    //      monthcolumn     := idstable.GetColumnByTimeUnit( Translations::MP_GlobalParameters_Month(), period );
          
          idsrow.SetCellValue( daycolumn, [Number]cell.Value() );
          idsrow.SetCellValue( weekcolumn, [Number]cell.Value() ); 
          idsrow.SetCellValue( monthcolumn, [Number]cell.Value() ); 
    //      idsrow.SetCellValue( weekcolumn, [Number]cell.Value() ); 
    //      idsrow.SetCellValue( monthcolumn, [Number]cell.Value() ); 
        }
      }
    }
@@ -66,18 +66,18 @@
      traverse( forecast, PlanningSalesDemandInPeriod, sdip ){
        idsrow              := idstable.GetRowByUnit( forecast.ProductID(), unitname );
        daycolumn           := idstable.GetColumnByTimeUnit( Translations::MP_GlobalParameters_Day(), sdip.StartDate() );
        weekcolumn          := idstable.GetColumnByTimeUnit( Translations::MP_GlobalParameters_Week(), sdip.StartDate() );
        monthcolumn         := idstable.GetColumnByTimeUnit( Translations::MP_GlobalParameters_Month(), sdip.StartDate() );
        info( '-----------------', isnull( idsrow ), isnull( daycolumn ), isnull( weekcolumn ), isnull( monthcolumn ), sdip.StartDate() );
    //    weekcolumn          := idstable.GetColumnByTimeUnit( Translations::MP_GlobalParameters_Week(), sdip.StartDate() );
    //    monthcolumn         := idstable.GetColumnByTimeUnit( Translations::MP_GlobalParameters_Month(), sdip.StartDate() );
    //    info( '-----------------', isnull( idsrow ), isnull( daycolumn ), isnull( weekcolumn ), isnull( monthcolumn ), sdip.StartDate() );
        idsrow.SetCellValue( daycolumn, [Number]sdip.Quantity() );
        idsrow.SetCellValue( weekcolumn, [Number]sdip.Quantity() );
        idsrow.SetCellValue( monthcolumn, [Number]sdip.Quantity() );
    //    idsrow.SetCellValue( weekcolumn, [Number]sdip.Quantity() );
    //    idsrow.SetCellValue( monthcolumn, [Number]sdip.Quantity() );
      }
    }
    
    source.Delete();
    info( '-------------------------End---------------------');
    productids             := selectuniquevalues( idstable, Row, row, row.Name() );
    showtable.Generate( search, productids );
    //productids             := selectuniquevalues( idstable, Row, row, row.Name() );
    //showtable.Generate( search, productids );
  *]
}

 _Main/BL/Type_CustomerDemandIDSColumn/Method_Filter.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,18 @@
Quintiq file version 2.0
#parent: #root
Method Filter (
  CustomerDemandIDSSearch search
) declarative remote as Boolean
{
  TextBody:
  [*
    // ç”„兰鸽 Nov-22-2024 (created)
    flag       := false;
    
    if( ( search.StartDate().IsMinInfinity() or this.StartDate() >= search.StartDate() ) and ( search.EndDate().IsMaxInfinity() or this.EndDate() <= search.EndDate() ) ){
      flag     := true;
    }
    
    return flag;
  *]
}

 _Main/BL/Type_CustomerDemandPPAIDS/StaticMethod_GenerateDataNew.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,46 @@
Quintiq file version 2.0
#parent: #root
StaticMethod GenerateDataNew (
  InterfaceDataset interfaceDataset,
  const MacroPlan macroplan,
  Boolean iscc,
  Boolean isdl,
  String executor
)
{
  Description: '生成可以下发的客户需求（PPA+IDS）数据'
  TextBody:
  [*
    // ç”„兰鸽 Aug-20-2024 (created)
    loginfo                := maxobject(  interfaceDataset, InterfaceLoginfo, loginfo, loginfo.Name() = Translations::InterfaceDataset_CustomerDemandPPAIDS_Name(), loginfo.InterfaceDateTime() );
    if( not isnull( loginfo ) ){
      if( not loginfo.IsShow() ){
        loginfo.Delete();
      }else{
        loginfo.Last( false );
      }
      interfaceDataset.CustomerDemandPPAIDS( relflush );
    }
    nowdate                := DateTime::ActualTime();
    loginfo                := interfaceDataset.InterfaceLoginfo( relnew, ExecuteUser           := executor
                                                                 , Name                        := Translations::InterfaceDataset_CustomerDemandPPAIDS_Name()
                                                                 , InterfaceDateTime           := nowdate
                                                                 , Message                     := '客户需求（PPA+IDS）数据推送'
                                                                 , Last                        := true
                                                                  );
    traverse( interfaceDataset, CustomerDemandArchive, archivedata ){
      cd                   :=interfaceDataset.CustomerDemandPPAIDS( relnew, Product            := archivedata.Product()
                                                                     , DemandDate              := archivedata.StartDate()
                                                                     , DemandQty               := [Number]archivedata.Quantity()
                                                                     , VersionName             := macroplan.ScenarioName()
                                                                     , InterfaceTime           := nowdate
                                                                     , FactoryName             := archivedata.FactoryName()
                                                                     , Fac                     := ifexpr( archivedata.FactoryName() = FinancialProductionReport::GetDefaultCCUnit(), 'CC', 'DL' )  
    //                                                                 , VersionFlag             := versionflag
                                                                     );
      loginfo.CustomerDemandPPAIDS( relinsert, cd );
    }
    loginfo.TotalRow( loginfo.CustomerDemandPPAIDS( relsize ) );
    CustomerDemandPPAIDS::Publish( interfaceDataset, loginfo );
  *]
}

 _Main/BL/Type_InterfaceDataset/Method_GenerateArchiveData.qbl

@@ -18,7 +18,8 @@
  [*
    // ç”„兰鸽 Oct-30-2024 (created)
    if( iscustomdemand ){//全年日度需求/客户需求 
      CustomerDemandIDS::GenerateData( this, macroplan, recyclebin, archive );
      CustomerDemandArchive::GenerateData( this, macroplan, recyclebin, archive );
    //  CustomerDemandIDS::GenerateData( this, macroplan, recyclebin, archive );
    }
    if( isofflineplan ){//各产线下线计划
      OfflinePlanArchiveVersion::RefreshData( this, macroplan, archive );

 _Main/BL/Type_InterfaceDataset/Method_PublishPlanReportData.qbl

@@ -21,13 +21,14 @@
  [*
    // ç”„兰鸽 Oct-30-2024 (created)
    if( iscustomdemanddl or iscustomdemandcc ){//全年日度需求/客户需求 
      CustomerDemandPPAIDS::GenerateData( this, macroplan, iscustomdemandcc, iscustomdemanddl, executor );
      CustomerDemandPPAIDS::GenerateDataNew( this, macroplan, iscustomdemandcc, iscustomdemanddl, executor );
    //  CustomerDemandPPAIDS::GenerateData( this, macroplan, iscustomdemandcc, iscustomdemanddl, executor );
    }
    if ( isofflineplandl or isofflineplancc ) { // å„产线下线计划
      InterfaceDataset::PushOfflinePlanData( macroplan, this, executor );
    }
    if( isshiftplandl or isshiftplancc ){//班次计划
      DispatchShiftPlan::Dispatch(this, macroplan,executor );
      DispatchShiftPlan::Dispatch(this, archive,executor );
    //  CustomerDemandIDS::GenerateData( this, recyclebin, archive );
    }
    if( isassembleonlineplandl or isassembleonlineplancc ){//装配上线计划

 _Main/BL/Type_InventoryPlanArchiveColumn/Method_Filter.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,18 @@
Quintiq file version 2.0
#parent: #root
Method Filter (
  InventoryPlanArchiveVersionSearch search
) declarative remote as Boolean
{
  TextBody:
  [*
    // ç”„兰鸽 Nov-22-2024 (created)
    flag       := false;
    
    if( ( search.StartDate().IsMinInfinity() or this.StartDate() >= search.StartDate() ) and ( search.EndDate().IsMaxInfinity() or this.EndDate() <= search.EndDate() ) ){
      flag     := true;
    }
    
    return flag;
  *]
}

 _Main/BL/Type_InventoryPlanArchiveVersion/StaticMethod_GenerateData.qbl

@@ -13,16 +13,16 @@
    machineproductparent   := MachiningPipelineReport::GetDefaultProductParent();
    engineproductparent    := EnginePipelineReport::GetDefaultProductParent();
    allunit                := AssemblyOnlinePlanVersion::GetDefaultAllUnit();
    name                   := InventoryPlanArchiveVersion::GetDefaultName();
    search                 := interfaceDataset.InventoryPlanArchiveVersionSearch( relnew, Product := allunit, Unit := allunit, StartDate := Date::MinDate(), EndDate := Date::MaxDate() );//, TimeUnit := Translations::MP_GlobalParameters_Day()
    name                   := InventoryPlanArchiveVersion::GetDefaultName();//search                 := 
    interfaceDataset.InventoryPlanArchiveVersionSearch( relnew, Product := allunit, Unit := allunit, StartDate := Date::MinDate(), EndDate := Date::MaxDate() );//, TimeUnit := Translations::MP_GlobalParameters_Day()
    table                  := selectobject( interfaceDataset, InventoryPlanArchiveVersion, version, not version.IsShow() );
    if( isnull( table ) ){
      table                := interfaceDataset.InventoryPlanArchiveVersion( relnew, ID := name, Name := name );
    }
    showtable              := selectobject( interfaceDataset, InventoryPlanArchiveVersion, version, version.IsShow() );
    if( isnull( showtable ) ){ 
      showtable               := interfaceDataset.InventoryPlanArchiveVersion( relnew, ID := name, Name := name, IsShow := true );
    }
    //showtable              := selectobject( interfaceDataset, InventoryPlanArchiveVersion, version, version.IsShow() );
    //if( isnull( showtable ) ){ 
    //  showtable               := interfaceDataset.InventoryPlanArchiveVersion( relnew, ID := name, Name := name, IsShow := true );
    //}
    periods                := selectuniquevalues(  macroPlan, Period_MP, period, not period.IsHistorical() and period.TimeUnit() = Translations::MP_GlobalParameters_Day()
                                                   and not exists( table, Column, column, column.StartDate() = period.StartDate() ), period.StartDate() );//column.TimeUnit() = Translations::MP_GlobalParameters_Day() and 
    if( periods.Size() > 0 ){
@@ -74,8 +74,8 @@
    }
    
    info( '-------------------------End---------------------');
    productids             := selectuniquevalues( table, Row, row, row.Name() );
    productlines           := selectuniquevalues( table, Row, row, row.Unit() );
    showtable.Generate( search, productids, productlines );
    //productids             := selectuniquevalues( table, Row, row, row.Name() );
    //productlines           := selectuniquevalues( table, Row, row, row.Unit() );
    //showtable.Generate( search, productids, productlines );
  *]
}

 _Main/BL/Type_LocalCell_Default/StaticMethod_GenerateAnnualPlanReport.qbl

@@ -17,7 +17,7 @@
    
    archiveOfflinePlan := select( interfaceDataset,OfflinePlanArchiveVersion,offlinePlan,not offlinePlan.IsShow() );
    
    startDate := minselect( archiveOfflinePlan,Column,column,column.TimeUnit() = "Day",column.StartDate() ).StartDate();
    startDate := minselect( archiveOfflinePlan,Column,column,column.StartDate() ).StartDate();//,column.TimeUnit() = "Day"
    endDate := macroPlan.StartOfPlanning().Date();
    
    localCells := construct( LocalCell_Defaults );

 _Main/BL/Type_OfflinePlanArchiveVersion/StaticMethod_RefreshData.qbl

@@ -10,16 +10,16 @@
  [*
    //根据当前版本的下线计划
    allunit                := OfflinePlanArchiveVersion::GetDefaultAllUnit();
    name                   := OfflinePlanArchiveVersion::GetDefaultName();
    search                 := interface.OfflinePlanArchiveSearch( relnew, Product := allunit, ProductionLine := allunit, Unit := allunit, StartDate := Date::MinDate(), EndDate := Date::MaxDate() );//, TimeUnit := Translations::MP_GlobalParameters_Day()
    name                   := OfflinePlanArchiveVersion::GetDefaultName();//search                 := 
    interface.OfflinePlanArchiveSearch( relnew, Product := allunit, ProductionLine := allunit, Unit := allunit, StartDate := Date::MinDate(), EndDate := Date::MaxDate() );//, TimeUnit := Translations::MP_GlobalParameters_Day()
    table                  := selectobject( interface, OfflinePlanArchiveVersion, version, not version.IsShow() );
    if( isnull( table ) ){
      table                := interface.OfflinePlanArchiveVersion( relnew, ID := name, Name := name );
    }
    showtable              := selectobject( interface, OfflinePlanArchiveVersion, version, version.IsShow() );
    if( isnull( showtable ) ){
      showtable               := interface.OfflinePlanArchiveVersion( relnew, ID := name, Name := name, IsShow := true );
    }
    //showtable              := selectobject( interface, OfflinePlanArchiveVersion, version, version.IsShow() );
    //if( isnull( showtable ) ){
    //  showtable               := interface.OfflinePlanArchiveVersion( relnew, ID := name, Name := name, IsShow := true );
    //}
    nopcolumns             := selectuniquevalues(  macroPlan, NewOfflinePlanTable.NewOfflinePlanColumn, nopcolumn, not exists( table, Column, column, column.StartDate() = nopcolumn.StartDate() ), nopcolumn.StartDate() );//column.TimeUnit() = Translations::MP_GlobalParameters_Day() and 
    if( nopcolumns.Size() > 0 ){
      table.GenerateColumn( nopcolumns, false );
@@ -60,8 +60,8 @@
        }
      }
    }
    productids             := selectuniquevalues( table, Row, row, row.Name() );
    productlines           := selectuniquevalues( table, Row, row, row.ProductionLine() );
    showtable.Generate( search, productids, productlines );
    //productids             := selectuniquevalues( table, Row, row, row.Name() );
    //productlines           := selectuniquevalues( table, Row, row, row.ProductionLine() );
    //showtable.Generate( search, productids, productlines );
  *]
}

 _Main/BL/Type_OfflinePlanArchiveVersionColumn/Method_Filter.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,18 @@
Quintiq file version 2.0
#parent: #root
Method Filter (
  OfflinePlanArchiveSearch search
) declarative remote as Boolean
{
  TextBody:
  [*
    // ç”„兰鸽 Nov-22-2024 (created)
    flag       := false;
    
    if( ( search.StartDate().IsMinInfinity() or this.StartDate() >= search.StartDate() ) and ( search.EndDate().IsMaxInfinity() or this.EndDate() <= search.EndDate() ) ){
      flag     := true;
    }
    
    return flag;
  *]
}

 _Main/UI/MacroPlannerWebApp/Component_ApplicationMacroPlanner/Component_ActionBarGroupPublish.def

@@ -24,6 +24,21 @@
      [
        Image: 'SKIN_TIGER'
        Label: '下发班次计划信息'
        Taborder: 2
      ]
    }
    Component ButtonPublishSAP
    {
      #keys: '[415136.0.1332920231]'
      BaseType: 'WebButton'
      Children:
      [
        #child: ContextMenuPublishSAP
      ]
      Properties:
      [
        Image: 'MAIL_OUT'
        Label: 'SAP æŽ¥å£æ•°æ®æŽ¨é€'
        Taborder: 1
      ]
    }

 _Main/UI/MacroPlannerWebApp/Component_ApplicationMacroPlanner/Component_ContextMenuPublishSAP.def

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,33 @@
Quintiq file version 2.0
Component ContextMenuPublishSAP
{
  #keys: '[415136.0.1332920286]'
  BaseType: 'WebContextMenu'
  Children:
  [
    Component MenuPublishSAPPIR
    {
      #keys: '[415136.0.1332920287]'
      BaseType: 'WebMenu'
      Properties:
      [
        Taborder: 0
        Title: 'SAP PIR'
      ]
    }
    Component MenuPublishSAPMS64
    {
      #keys: '[415136.0.1332920329]'
      BaseType: 'WebMenu'
      Properties:
      [
        Taborder: 1
        Title: 'SAP MS64'
      ]
    }
  ]
  Properties:
  [
    Taborder: 0
  ]
}

 _Main/UI/MacroPlannerWebApp/Component_ApplicationMacroPlanner/Response_MacroPlanner_ActionBarGroupArchiveReport_ButtonCustomerDemandPP#603.def

@@ -9,7 +9,7 @@
  {
    Body:
    [*
      ApplicationScope.ViewManager().ResetUserViewById( "Customer_demand_PPAIDS_view", true);
      ApplicationScope.ViewManager().ResetUserViewById( "Customer_demand_archive_view", true);//Customer_demand_PPAIDS_view
    *]
    GroupServerCalls: false
  }

 _Main/UI/MacroPlannerWebApp/Component_ApplicationMacroPlanner/Response_MacroPlanner_ContextMenuPublishSAP_MenuPublishSAPMS64_OnClick.def

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,21 @@
Quintiq file version 2.0
#parent: ContextMenuPublishSAP/MenuPublishSAPMS64
Response OnClick () id:Response_MacroPlanner_ContextMenuPublishSAP_MenuPublishSAPMS64_OnClick
{
  #keys: '[415136.0.1332920626]'
  CanBindMultiple: false
  DefinitionID: 'Responsedef_WebMenu_OnClick'
  Precondition:
  [*
    return not isnull( MacroPlan ) and not isnull( InterfaceDataset );
  *]
  QuillAction
  {
    Body:
    [*
      dlg := construct( DialogZEDPPSMS64 );
      dlg.New();
    *]
    GroupServerCalls: false
  }
}

 _Main/UI/MacroPlannerWebApp/Component_ApplicationMacroPlanner/Response_MacroPlanner_ContextMenuPublishSAP_MenuPublishSAPPIR_OnClick.def

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,21 @@
Quintiq file version 2.0
#parent: ContextMenuPublishSAP/MenuPublishSAPPIR
Response OnClick () id:Response_MacroPlanner_ContextMenuPublishSAP_MenuPublishSAPPIR_OnClick
{
  #keys: '[415136.0.1332920450]'
  CanBindMultiple: false
  DefinitionID: 'Responsedef_WebMenu_OnClick'
  Precondition:
  [*
    return not isnull( MacroPlan ) and not isnull( InterfaceDataset );
  *]
  QuillAction
  {
    Body:
    [*
      dlg := construct( DialogZEDPPSPIR );
      dlg.New();
    *]
    GroupServerCalls: false
  }
}

 _Main/UI/MacroPlannerWebApp/Component_FormAssemblyOnlinePlanVersion/Component_MatrixEditorTable#384.def

@@ -17,10 +17,10 @@
          BaseType: 'WebDataExtractor'
          Properties:
          [
            DataType: 'AssemblyOnlinePlanVersion'
            Source: 'DataHolderTable'
            DataType: 'InterfaceDataset'
            Source: 'InterfaceDataset'
            Taborder: 0
            Transformation: 'Row.Cell'
            Transformation: 'AssemblyOnlinePlanVersion.Row.Cell'
          ]
        }
      ]
@@ -44,10 +44,12 @@
          BaseType: 'WebDataExtractor'
          Properties:
          [
            DataType: 'AssemblyOnlinePlanVersion'
            Source: 'DataHolderTable'
            DataType: 'InterfaceDataset'
            FilterArguments: 'units:QLibMacroPlannerWebUI::ApplicationMacroPlanner.DataHolderUnit;products:QLibMacroPlannerWebUI::ApplicationMacroPlanner.DataHolderProduct'
            FixedFilter: '( units.Size() = 0 or exists( units, Elements, unit, unit.ID() = object.ProductionLine() ) ) and ( products.Size() = 0 or exists( products, Elements, product, product.ID() = object.Name() ) )'
            Source: 'InterfaceDataset'
            Taborder: 0
            Transformation: 'Row'
            Transformation: 'AssemblyOnlinePlanVersion.Row'
          ]
        }
      ]
@@ -70,10 +72,13 @@
          BaseType: 'WebDataExtractor'
          Properties:
          [
            DataType: 'AssemblyOnlinePlanVersion'
            Source: 'DataHolderTable'
            DataType: 'InterfaceDataset'
            Description: '( search.StartDate().IsMinInfinity() or object.StartDate() >= search.StartDate() ) and ( search.EndDate().IsMaxInfinity() or object.StartDate() <= search.EndDate() )'
            FilterArguments: 'search:QMacroPlanner::FormAssemblyOnlinePlanVersion.dhSearch'
            FixedFilter: 'object.Filter( search )'
            Source: 'InterfaceDataset'
            Taborder: 0
            Transformation: 'Column'
            Transformation: 'AssemblyOnlinePlanVersion.Column'
          ]
        }
      ]

 _Main/UI/MacroPlannerWebApp/Component_FormAssemblyOnlinePlanVersion/Component_PanelHeader#952.def

@@ -11,6 +11,6 @@
  Properties:
  [
    FixedSize: true
    Taborder: 2
    Taborder: 1
  ]
}

 _Main/UI/MacroPlannerWebApp/Component_FormAssemblyOnlinePlanVersion/Component_PanelSAP.def

@@ -30,5 +30,6 @@
  [
    Orientation: 'horizontal'
    Taborder: 2
    Visible: false
  ]
}

 _Main/UI/MacroPlannerWebApp/Component_FormAssemblyOnlinePlanVersion/Component_PanelTable#273.def

@@ -9,6 +9,6 @@
  ]
  Properties:
  [
    Taborder: 3
    Taborder: 2
  ]
}

 _Main/UI/MacroPlannerWebApp/Component_FormAssemblyOnlinePlanVersion/Response_OnCreated.def

ÎļþÒÑɾ³ý

 _Main/UI/MacroPlannerWebApp/Component_FormAssemblyOnlinePlanVersion/Response_PanelOperation_653_ButtonSearch_OnClick.def

@@ -9,11 +9,11 @@
  {
    Body:
    [*
      if( not isnull( DataHolderTable.Data() ) ){ 
        productids      := selectuniquevalues( DataHolderProduct.Data(), Elements, product, product.ID() );
        units           := selectuniquevalues( DataHolderUnit.Data(), Elements, unit, unit.ID() );
        DataHolderTable.Data().Generate( dhSearch.Data(), productids, units );
      }
      //if( not isnull( DataHolderTable.Data() ) ){ 
      //  productids      := selectuniquevalues( DataHolderProduct.Data(), Elements, product, product.ID() );
      //  units           := selectuniquevalues( DataHolderUnit.Data(), Elements, unit, unit.ID() );
      //  DataHolderTable.Data().Generate( dhSearch.Data(), productids, units );
      //}
    *]
    GroupServerCalls: false
  }

 _Main/UI/MacroPlannerWebApp/Component_FormAssemblyOnlinePlanVersion/_ROOT_Component_FormAssemblyOnlinePlanVersion.def

@@ -29,20 +29,10 @@
      ]
      Properties:
      [
        Taborder: 1
        Taborder: 0
      ]
    }
    #child: PanelHeader_952
    #child: PanelTable_273
    Component DataHolderTable id:DataHolderTable_568
    {
      #keys: '[415136.0.1283300574]'
      BaseType: 'WebDataHolder'
      Databinding: 'AssemblyOnlinePlanVersion'
      Properties:
      [
        Taborder: 0
      ]
    }
  ]
}

 _Main/UI/MacroPlannerWebApp/Component_FormCustomerDemandArchive/Component_ListCustomerDemandArchive.def

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,42 @@
Quintiq file version 2.0
Component ListCustomerDemandArchive
{
  #keys: '[415136.0.1334500083]'
  BaseType: 'WebList'
  Children:
  [
    Component DataExtractorCustomerDemandArchive
    {
      #keys: '[415136.0.1334500084]'
      BaseType: 'WebDataExtractor'
      Properties:
      [
        DataType: 'InterfaceDataset'
        Source: 'InterfaceDataset'
        Taborder: 0
        Transformation: 'CustomerDemandArchive'
      ]
    }
    #child: listActionBarPageCustomerDemandArchive
    Component DataSetLevelCustomerDemandArchive
    {
      #keys: '[415136.0.1334500089]'
      BaseType: 'WebDataSetLevel'
      Children:
      [
        #child: listContextMenuCustomerDemandArchive
      ]
      Properties:
      [
        Columns: '[{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"SalesSegment","title":"SalesSegment","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"SalesSegment"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"StockingPointID","title":"StockingPointID","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"StockingPointID"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Factory","title":"Factory","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Factory"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"FactoryName","title":"FactoryName","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"FactoryName"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Product","title":"Product","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Product"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Origin","title":"Origin","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Origin"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"StartDate","title":"StartDate","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"StartDate"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"EndDate","title":"EndDate","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"EndDate"}}]'
        ContextMenu: 'listContextMenuCustomerDemandArchive'
        SortCriteria: 'desc:StartDate'
        Taborder: 2
      ]
    }
  ]
  Properties:
  [
    Taborder: 0
  ]
}

 _Main/UI/MacroPlannerWebApp/Component_FormCustomerDemandArchive/Component_listActionBarPageCustomerDemandArchive.def

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,10 @@
Quintiq file version 2.0
Component listActionBarPageCustomerDemandArchive
{
  #keys: '[415136.0.1334500086]'
  BaseType: 'listActionBarPage'
  Properties:
  [
    Taborder: 1
  ]
}

 _Main/UI/MacroPlannerWebApp/Component_FormCustomerDemandArchive/Component_listContextMenuCustomerDemandArchive.def

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,10 @@
Quintiq file version 2.0
Component listContextMenuCustomerDemandArchive
{
  #keys: '[415136.0.1334500091]'
  BaseType: 'listContextMenu'
  Properties:
  [
    Taborder: 0
  ]
}

 _Main/UI/MacroPlannerWebApp/Component_FormCustomerDemandArchive/_ROOT_Component_FormCustomerDemandArchive.def

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,17 @@
Quintiq file version 2.0
#root
#parent: MacroPlannerWebApp
OrphanComponent FormCustomerDemandArchive
{
  #keys: '[415136.0.1334500035]'
  BaseType: 'WebForm'
  Children:
  [
    #child: ListCustomerDemandArchive
  ]
  Properties:
  [
    Image: 'FLAG_AMBER'
    Title: 'Customer demand archive'
  ]
}

 _Main/UI/MacroPlannerWebApp/Component_FormCustomerDemandPPAIDS/Component_MatrixEditorTable.def

@@ -17,12 +17,12 @@
          BaseType: 'WebDataExtractor'
          Properties:
          [
            DataType: 'CustomerDemandIDS'
            DataType: 'InterfaceDataset'
            Description: 'object.Column().TimeUnit() = search.TimeUnit() and object.Column().StartDate() >= search.StartDate() and object.Column().StartDate() <= search.EndDate()'
            FilterArguments: 'search:QMacroPlanner::FormCustomerDemandPPAIDS.dhSearch'
            Source: 'DataHolderTable'
            Source: 'InterfaceDataset'
            Taborder: 0
            Transformation: 'Row.Cell'
            Transformation: 'CustomerDemandIDS.Row.Cell'
          ]
        }
      ]
@@ -46,12 +46,12 @@
          BaseType: 'WebDataExtractor'
          Properties:
          [
            DataType: 'CustomerDemandIDS'
            Description: "search.Product() = '<All>' or object.Name() = search.Product() and ( search.Unit() = '<All>' or object.Factory() = search.Unit() )"
            FilterArguments: 'search:QMacroPlanner::FormCustomerDemandPPAIDS.dhSearch'
            Source: 'DataHolderTable'
            DataType: 'InterfaceDataset'
            FilterArguments: 'units:QLibMacroPlannerWebUI::ApplicationMacroPlanner.DataHolderUnit;products:QLibMacroPlannerWebUI::ApplicationMacroPlanner.DataHolderProduct'
            FixedFilter: '( units.Size() = 0 or exists( units, Elements, unit, unit.ID() = object.Factory() ) ) and ( products.Size() = 0 or exists( products, Elements, product, product.ID() = object.Name() ) )'
            Source: 'InterfaceDataset'
            Taborder: 0
            Transformation: 'Row'
            Transformation: 'CustomerDemandIDS.Row'
          ]
        }
      ]
@@ -74,12 +74,13 @@
          BaseType: 'WebDataExtractor'
          Properties:
          [
            DataType: 'CustomerDemandIDS'
            Description: 'object.TimeUnit() = search.TimeUnit() and ( search.StartDate().IsMinInfinity() or object.StartDate() >= search.StartDate() ) and ( search.EndDate().IsMaxInfinity() or object.StartDate() <= search.EndDate() )'
            DataType: 'InterfaceDataset'
            Description: '( search.StartDate().IsMinInfinity() or object.StartDate() >= search.StartDate() ) and ( search.EndDate().IsMaxInfinity() or object.StartDate() <= search.EndDate() )'
            FilterArguments: 'search:QMacroPlanner::FormCustomerDemandPPAIDS.dhSearch'
            Source: 'DataHolderTable'
            FixedFilter: 'object.Filter( search )'
            Source: 'InterfaceDataset'
            Taborder: 0
            Transformation: 'Column'
            Transformation: 'CustomerDemandIDS.Column'
          ]
        }
      ]

 _Main/UI/MacroPlannerWebApp/Component_FormCustomerDemandPPAIDS/Component_PanelHeader.def

@@ -17,6 +17,6 @@
  [
    FixedSize: true
    Orientation: 'horizontal'
    Taborder: 2
    Taborder: 1
  ]
}

 _Main/UI/MacroPlannerWebApp/Component_FormCustomerDemandPPAIDS/Component_PanelTable.def

@@ -9,6 +9,6 @@
  ]
  Properties:
  [
    Taborder: 3
    Taborder: 2
  ]
}

 _Main/UI/MacroPlannerWebApp/Component_FormCustomerDemandPPAIDS/Response_OnCreated.def

ÎļþÒÑɾ³ý

 _Main/UI/MacroPlannerWebApp/Component_FormCustomerDemandPPAIDS/Response_PanelOperation_ButtonSearch_OnClick.def

@@ -9,10 +9,10 @@
  {
    Body:
    [*
      if( not isnull( DataHolderTable.Data() ) ){ 
        productids      := selectuniquevalues( DataHolderProduct.Data(), Elements, product, product.ID() );
        DataHolderTable.Data().Generate( dhSearch.Data(), productids );
      }
      //if( not isnull( DataHolderTable.Data() ) ){ 
      //  productids      := selectuniquevalues( DataHolderProduct.Data(), Elements, product, product.ID() );
      //  DataHolderTable.Data().Generate( dhSearch.Data(), productids );
      //}
    *]
    GroupServerCalls: false
  }

 _Main/UI/MacroPlannerWebApp/Component_FormCustomerDemandPPAIDS/_ROOT_Component_FormCustomerDemandPPAIDS.def

@@ -31,16 +31,6 @@
      ]
      Properties:
      [
        Taborder: 1
      ]
    }
    Component DataHolderTable
    {
      #keys: '[415136.0.1307973765]'
      BaseType: 'WebDataHolder'
      Databinding: 'CustomerDemandIDS'
      Properties:
      [
        Taborder: 0
      ]
    }

 _Main/UI/MacroPlannerWebApp/Component_FormInventoryPlanArchive/Component_MatrixEditorTable#791.def

@@ -17,10 +17,10 @@
          BaseType: 'WebDataExtractor'
          Properties:
          [
            DataType: 'InventoryPlanArchiveVersion'
            Source: 'DataHolderTable'
            DataType: 'InterfaceDataset'
            Source: 'InterfaceDataset'
            Taborder: 0
            Transformation: 'Row.Cell'
            Transformation: 'InventoryPlanArchiveVersion.Row.Cell'
          ]
        }
      ]
@@ -44,10 +44,12 @@
          BaseType: 'WebDataExtractor'
          Properties:
          [
            DataType: 'InventoryPlanArchiveVersion'
            Source: 'DataHolderTable'
            DataType: 'InterfaceDataset'
            FilterArguments: 'units:QLibMacroPlannerWebUI::ApplicationMacroPlanner.DataHolderUnit;products:QLibMacroPlannerWebUI::ApplicationMacroPlanner.DataHolderProduct'
            FixedFilter: '( units.Size() = 0 or exists( units, Elements, unit, unit.ID() = object.Unit() ) ) and ( products.Size() = 0 or exists( products, Elements, product, product.ID() = object.Name() ) )'
            Source: 'InterfaceDataset'
            Taborder: 0
            Transformation: 'Row'
            Transformation: 'InventoryPlanArchiveVersion.Row'
          ]
        }
      ]
@@ -70,10 +72,13 @@
          BaseType: 'WebDataExtractor'
          Properties:
          [
            DataType: 'InventoryPlanArchiveVersion'
            Source: 'DataHolderTable'
            DataType: 'InterfaceDataset'
            Description: '( search.StartDate().IsMinInfinity() or object.StartDate() >= search.StartDate() ) and ( search.EndDate().IsMaxInfinity() or object.StartDate() <= search.EndDate() )'
            FilterArguments: 'search:QMacroPlanner::FormInventoryPlanArchive.dhSearch'
            FixedFilter: 'object.Filter( search )'
            Source: 'InterfaceDataset'
            Taborder: 0
            Transformation: 'Column'
            Transformation: 'InventoryPlanArchiveVersion.Column'
          ]
        }
      ]

 _Main/UI/MacroPlannerWebApp/Component_FormInventoryPlanArchive/Component_PanelHeader#503.def

@@ -11,6 +11,6 @@
  Properties:
  [
    FixedSize: true
    Taborder: 2
    Taborder: 1
  ]
}

 _Main/UI/MacroPlannerWebApp/Component_FormInventoryPlanArchive/Component_PanelTable#881.def

@@ -9,6 +9,6 @@
  ]
  Properties:
  [
    Taborder: 3
    Taborder: 2
  ]
}

 _Main/UI/MacroPlannerWebApp/Component_FormInventoryPlanArchive/Response_OnCreated.def

ÎļþÒÑɾ³ý

 _Main/UI/MacroPlannerWebApp/Component_FormInventoryPlanArchive/Response_PanelOperation_603_ButtonSearch_OnClick.def

@@ -9,11 +9,11 @@
  {
    Body:
    [*
      if( not isnull( DataHolderTable.Data() ) ){ 
        productids      := selectuniquevalues( DataHolderProduct.Data(), Elements, product, product.ID() );
        units           := selectuniquevalues( DataHolderUnit.Data(), Elements, unit, unit.ID() );
        DataHolderTable.Data().Generate( dhSearch.Data(), productids, units );
      }
      //if( not isnull( DataHolderTable.Data() ) ){ 
      //  productids      := selectuniquevalues( DataHolderProduct.Data(), Elements, product, product.ID() );
      //  units           := selectuniquevalues( DataHolderUnit.Data(), Elements, unit, unit.ID() );
      //  DataHolderTable.Data().Generate( dhSearch.Data(), productids, units );
      //}
    *]
    GroupServerCalls: false
  }

 _Main/UI/MacroPlannerWebApp/Component_FormInventoryPlanArchive/_ROOT_Component_FormInventoryPlanArchive.def

@@ -29,21 +29,11 @@
      ]
      Properties:
      [
        Taborder: 1
        Taborder: 0
      ]
    }
    #child: PanelHeader_503
    #child: PanelTable_881
    Component DataHolderTable
    {
      #keys: '[415136.0.1285202011]'
      BaseType: 'WebDataHolder'
      Databinding: 'InventoryPlanArchiveVersion'
      Properties:
      [
        Taborder: 0
      ]
    }
  ]
  Properties:
  [

 _Main/UI/MacroPlannerWebApp/Component_FormOfflinePlanArchive/Component_MatrixEditorTable.def

@@ -17,10 +17,10 @@
          BaseType: 'WebDataExtractor'
          Properties:
          [
            DataType: 'OfflinePlanArchiveVersion'
            Source: 'DataHolderTable'
            DataType: 'InterfaceDataset'
            Source: 'InterfaceDataset'
            Taborder: 0
            Transformation: 'Row.Cell'
            Transformation: 'OfflinePlanArchiveVersion.Row.Cell'
          ]
        }
      ]
@@ -44,11 +44,12 @@
          BaseType: 'WebDataExtractor'
          Properties:
          [
            DataType: 'OfflinePlanArchiveVersion'
            Description: "( search.Generation() = '<All>' or object.Product_MP().Generation() = search.Generation() ) and ( search.MqbMlb() = '<All>' or object.Product_MP().MQBMLB() = search.MqbMlb() ) and ( search.Power() = '<All>' or object.Product_MP().Power() = search.Power() )"
            Source: 'DataHolderTable'
            DataType: 'InterfaceDataset'
            FilterArguments: 'units:QLibMacroPlannerWebUI::ApplicationMacroPlanner.DataHolderUnit;products:QLibMacroPlannerWebUI::ApplicationMacroPlanner.DataHolderProduct'
            FixedFilter: '( units.Size() = 0 or exists( units, Elements, unit, unit.ID() = object.ProductionLine() ) ) and ( products.Size() = 0 or exists( products, Elements, product, product.ID() = object.Name() ) )'
            Source: 'InterfaceDataset'
            Taborder: 0
            Transformation: 'Row'
            Transformation: 'OfflinePlanArchiveVersion.Row'
          ]
        }
      ]
@@ -71,10 +72,13 @@
          BaseType: 'WebDataExtractor'
          Properties:
          [
            DataType: 'OfflinePlanArchiveVersion'
            Source: 'DataHolderTable'
            DataType: 'InterfaceDataset'
            Description: '( search.StartDate().IsMinInfinity() or object.StartDate() >= search.StartDate() ) and ( search.EndDate().IsMaxInfinity() or object.StartDate() <= search.EndDate() )'
            FilterArguments: 'search:QMacroPlanner::FormOfflinePlanArchive.dhSearch'
            FixedFilter: 'object.Filter( search )'
            Source: 'InterfaceDataset'
            Taborder: 0
            Transformation: 'Column'
            Transformation: 'OfflinePlanArchiveVersion.Column'
          ]
        }
      ]

 _Main/UI/MacroPlannerWebApp/Component_FormOfflinePlanArchive/Component_PanelHeader.def

@@ -11,6 +11,6 @@
  Properties:
  [
    FixedSize: true
    Taborder: 2
    Taborder: 1
  ]
}

 _Main/UI/MacroPlannerWebApp/Component_FormOfflinePlanArchive/Component_PanelTable.def

@@ -9,6 +9,6 @@
  ]
  Properties:
  [
    Taborder: 3
    Taborder: 2
  ]
}

 _Main/UI/MacroPlannerWebApp/Component_FormOfflinePlanArchive/Response_OnCreated.def

ÎļþÒÑɾ³ý

 _Main/UI/MacroPlannerWebApp/Component_FormOfflinePlanArchive/Response_PanelOperation_ButtonSearch_OnClick.def

@@ -9,11 +9,11 @@
  {
    Body:
    [*
      if( not isnull( DataHolderTable.Data() ) ){ 
        productids      := selectuniquevalues( DataHolderProduct.Data(), Elements, product, product.ID() );
        units           := selectuniquevalues( DataHolderUnit.Data(), Elements, unit, unit.ID() );
        DataHolderTable.Data().Generate( dhSearch.Data(), productids, units );
      }
      //if( not isnull( DataHolderTable.Data() ) ){ 
      //  productids      := selectuniquevalues( DataHolderProduct.Data(), Elements, product, product.ID() );
      //  units           := selectuniquevalues( DataHolderUnit.Data(), Elements, unit, unit.ID() );
      //  DataHolderTable.Data().Generate( dhSearch.Data(), productids, units );
      //}
    *]
    GroupServerCalls: false
  }

 _Main/UI/MacroPlannerWebApp/Component_FormOfflinePlanArchive/_ROOT_Component_FormOfflinePlanArchive.def

@@ -29,21 +29,11 @@
      ]
      Properties:
      [
        Taborder: 1
        Taborder: 0
      ]
    }
    #child: PanelHeader
    #child: PanelTable
    Component DataHolderTable id:DataHolderTable_265
    {
      #keys: '[415136.0.1286390735]'
      BaseType: 'WebDataHolder'
      Databinding: 'OfflinePlanArchiveVersion'
      Properties:
      [
        Taborder: 0
      ]
    }
  ]
  Properties:
  [

 _Main/UI/MacroPlannerWebApp/Views/Customer_demand_archive_view.vw

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,119 @@
Quintiq file version 2.0
{
  viewcontents
  {
    forms
    {
      form_FormCustomerDemandArchive
      {
        title: 'QMacroPlanner::FormCustomerDemandArchive'
        shown: true
        componentID: 'QMacroPlanner::FormCustomerDemandArchive'
        layout
        {
          mode: 'open'
          rowPosition: 1
          rowSpan: 16
          columnPosition: 1
          columnSpan: 12
        }
        components
        {
          FormCustomerDemandArchive_ListCustomerDemandArchive
          {
          }
          FormCustomerDemandArchive_DataSetLevelCustomerDemandArchive
          {
            groupDepth: -1
            sort: 'DESC:StartDate'
            column_SalesSegment
            {
              columnId: 'SalesSegment'
              dataPath: 'SalesSegment'
              dataType: 'string'
              index: 0
              subtotals: ''
              width: 150
            }
            column_StockingPointID
            {
              columnId: 'StockingPointID'
              dataPath: 'StockingPointID'
              dataType: 'string'
              index: 1
              subtotals: ''
              width: 150
            }
            column_Factory
            {
              columnId: 'Factory'
              dataPath: 'Factory'
              dataType: 'string'
              index: 2
              subtotals: ''
              width: 150
            }
            column_FactoryName
            {
              columnId: 'FactoryName'
              dataPath: 'FactoryName'
              dataType: 'string'
              index: 3
              subtotals: ''
              width: 150
            }
            column_Product
            {
              columnId: 'Product'
              dataPath: 'Product'
              dataType: 'string'
              index: 4
              subtotals: ''
              width: 150
            }
            column_Origin
            {
              columnId: 'Origin'
              dataPath: 'Origin'
              dataType: 'string'
              index: 5
              subtotals: ''
              width: 150
            }
            column_StartDate
            {
              columnId: 'StartDate'
              dataPath: 'StartDate'
              dataType: 'date'
              index: 6
              subtotals: ''
              width: 150
            }
            column_EndDate
            {
              columnId: 'EndDate'
              dataPath: 'EndDate'
              dataType: 'date'
              index: 7
              subtotals: ''
              width: 150
            }
          }
        }
      }
    }
    userconfigurableinformation
    {
    }
    page: ''
    group: ''
    index: 33
    image: 'FLAG_AMBER'
    description: ''
  }
  formatversion: 2
  id: 'Customer_demand_archive_view'
  name: 'Customer demand archive view'
  isglobal: false
  isroot: true
}