优化交易汇总报表

hongji.li

2023-11-06 ea578007e86bdc01430bc8b9683d8e69eb2438e5

优化交易汇总报表

 _Main/BL/Type_SummaryOfInboundTransaction/StaticMethod_FlushData.qbl

@@ -1,7 +1,55 @@
Quintiq file version 2.0
#parent: #root
StaticMethod FlushData (
  GlobalOTDSOP globalOTDSOP
  GlobalOTDSOP globalOTDSOP,
  const GlobalOTDTable globalOTDTable
)
{
  TextBody:
  [*
    globalOTDSOP.SummaryOfInboundTransaction( relflush );
    
    traverse ( globalOTDTable, Global_MappingSummaryOfInboundTransaction, gmsoit ) {
      targetSummaryOfInboundTransaction := select( globalOTDSOP, SummaryOfInboundTransaction, tempSOIBT, 
                                                   tempSOIBT.Item()      =  gmsoit.Item()     and
                                                   tempSOIBT.OrganCode() = gmsoit.OrganCode() and
                                                   tempSOIBT.OrganName() = gmsoit.OrganName() and
                                                   tempSOIBT.PlantName() = gmsoit.PlantName() );
      
      if ( isnull( targetSummaryOfInboundTransaction ) ) {
        targetSummaryOfInboundTransaction := globalOTDSOP.SummaryOfInboundTransaction( relnew, Item      := gmsoit.Item(),
                                                                                               OrganCode := gmsoit.OrganCode(),
                                                                                               OrganName := gmsoit.OrganName(),
                                                                                               PlantName := gmsoit.PlantName()
                                                                                      );
      }
      
      if ( gmsoit.TransactionDate().Month() = 1 ) {
        targetSummaryOfInboundTransaction.Total1( targetSummaryOfInboundTransaction.Total1() + gmsoit.TransactionQTY() );
      } else if ( gmsoit.TransactionDate().Month() = 2 ) {
        targetSummaryOfInboundTransaction.Total2( targetSummaryOfInboundTransaction.Total2() + gmsoit.TransactionQTY() );
      } else if ( gmsoit.TransactionDate().Month() = 3 ) {
        targetSummaryOfInboundTransaction.Total3( targetSummaryOfInboundTransaction.Total3() + gmsoit.TransactionQTY() );
      } else if ( gmsoit.TransactionDate().Month() = 4 ) {
        targetSummaryOfInboundTransaction.Total4( targetSummaryOfInboundTransaction.Total4() + gmsoit.TransactionQTY() );
      } else if ( gmsoit.TransactionDate().Month() = 5 ) {
        targetSummaryOfInboundTransaction.Total5( targetSummaryOfInboundTransaction.Total5() + gmsoit.TransactionQTY() );
      } else if ( gmsoit.TransactionDate().Month() = 6 ) {
        targetSummaryOfInboundTransaction.Total6( targetSummaryOfInboundTransaction.Total6() + gmsoit.TransactionQTY() );
      } else if ( gmsoit.TransactionDate().Month() = 7 ) {
        targetSummaryOfInboundTransaction.Total7( targetSummaryOfInboundTransaction.Total7() + gmsoit.TransactionQTY() );
      } else if ( gmsoit.TransactionDate().Month() = 8 ) {
        targetSummaryOfInboundTransaction.Total8( targetSummaryOfInboundTransaction.Total8() + gmsoit.TransactionQTY() );
      } else if ( gmsoit.TransactionDate().Month() = 9 ) {
        targetSummaryOfInboundTransaction.Total9( targetSummaryOfInboundTransaction.Total9() + gmsoit.TransactionQTY() );
      } else if ( gmsoit.TransactionDate().Month() = 10 ) {
        targetSummaryOfInboundTransaction.Total10( targetSummaryOfInboundTransaction.Total10() + gmsoit.TransactionQTY() );
      } else if ( gmsoit.TransactionDate().Month() = 11 ) {
        targetSummaryOfInboundTransaction.Total11( targetSummaryOfInboundTransaction.Total11() + gmsoit.TransactionQTY() );
      } else if ( gmsoit.TransactionDate().Month() = 12 ) {
        targetSummaryOfInboundTransaction.Total12( targetSummaryOfInboundTransaction.Total2() + gmsoit.TransactionQTY() );
      }
      
    }
  *]
}

 _Main/UI/MacroPlannerWebApp/Component_FormSummaryOfInboundTransaction/Component_ListSummaryOfInboundTransaction.def

@@ -28,7 +28,7 @@
      ]
      Properties:
      [
        Columns: '[]'
        Columns: '[{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Item","title":"物料编码","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Item"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"OrganCode","title":"组织编码","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"OrganCode"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"OrganName","title":"组织名称","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"OrganName"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"PlantName","title":"工厂名称","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"PlantName"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Total1","title":"1月汇总数量","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Total1"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Total2","title":"2月汇总数量","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Total2"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Total3","title":"3月汇总数量","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Total3"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Total4","title":"4月汇总数量","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Total4"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Total5","title":"5月汇总数量","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Total5"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Total6","title":"6月汇总数量","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Total6"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Total7","title":"7月汇总数量","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Total7"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Total8","title":"8月汇总数量","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Total8"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Total9","title":"9月汇总数量","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Total9"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Total10","title":"10月汇总数量","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Total10"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Total11","title":"11月汇总数量","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Total11"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Total12","title":"12月汇总数量","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Total12"}}]'
        ContextMenu: 'listContextMenuSummaryOfInboundTransaction'
        Taborder: 2
      ]

 _Main/UI/MacroPlannerWebApp/Component_FormSummaryOfInboundTransaction/Response_pButton_bFlushData_OnClick.def

@@ -9,7 +9,7 @@
  {
    Body:
    [*
      SummaryOfInboundTransaction::FlushData( GlobalOTDSOP );
      SummaryOfInboundTransaction::FlushData( GlobalOTDSOP, GlobalOTDTable );
    *]
    GroupServerCalls: false
  }

 _Main/UI/MacroPlannerWebApp/Views/Äê¶È²úÏú¸´ÅÌ.vw

@@ -367,6 +367,178 @@
          }
        }
      }
      form_FormSummaryOfInboundTransaction
      {
        title: 'QTIANMA_JITUAN::FormSummaryOfInboundTransaction'
        shown: true
        componentID: 'QTIANMA_JITUAN::FormSummaryOfInboundTransaction'
        layout
        {
          mode: 'open'
          rowPosition: 35
          rowSpan: 12
          columnPosition: 1
          columnSpan: 12
        }
        components
        {
          FormSummaryOfInboundTransaction_pButton
          {
            sizeRatio: 1
          }
          FormSummaryOfInboundTransaction_ListSummaryOfInboundTransaction
          {
          }
          FormSummaryOfInboundTransaction_DataSetLevelSummaryOfInboundTransaction
          {
            groupDepth: -1
            column_Item
            {
              columnId: 'Item'
              dataPath: 'Item'
              dataType: 'string'
              index: 0
              subtotals: ''
              width: 150
            }
            column_OrganCode
            {
              columnId: 'OrganCode'
              dataPath: 'OrganCode'
              dataType: 'string'
              index: 1
              subtotals: ''
              width: 150
            }
            column_OrganName
            {
              columnId: 'OrganName'
              dataPath: 'OrganName'
              dataType: 'string'
              index: 2
              subtotals: ''
              width: 150
            }
            column_PlantName
            {
              columnId: 'PlantName'
              dataPath: 'PlantName'
              dataType: 'string'
              index: 3
              subtotals: ''
              width: 150
            }
            column_Total1
            {
              columnId: 'Total1'
              dataPath: 'Total1'
              dataType: 'real'
              index: 4
              subtotals: ''
              width: 150
            }
            column_Total2
            {
              columnId: 'Total2'
              dataPath: 'Total2'
              dataType: 'real'
              index: 5
              subtotals: ''
              width: 150
            }
            column_Total3
            {
              columnId: 'Total3'
              dataPath: 'Total3'
              dataType: 'real'
              index: 6
              subtotals: ''
              width: 150
            }
            column_Total4
            {
              columnId: 'Total4'
              dataPath: 'Total4'
              dataType: 'real'
              index: 7
              subtotals: ''
              width: 150
            }
            column_Total5
            {
              columnId: 'Total5'
              dataPath: 'Total5'
              dataType: 'real'
              index: 8
              subtotals: ''
              width: 150
            }
            column_Total6
            {
              columnId: 'Total6'
              dataPath: 'Total6'
              dataType: 'real'
              index: 9
              subtotals: ''
              width: 150
            }
            column_Total7
            {
              columnId: 'Total7'
              dataPath: 'Total7'
              dataType: 'real'
              index: 10
              subtotals: ''
              width: 150
            }
            column_Total8
            {
              columnId: 'Total8'
              dataPath: 'Total8'
              dataType: 'real'
              index: 11
              subtotals: ''
              width: 150
            }
            column_Total9
            {
              columnId: 'Total9'
              dataPath: 'Total9'
              dataType: 'real'
              index: 12
              subtotals: ''
              width: 150
            }
            column_Total10
            {
              columnId: 'Total10'
              dataPath: 'Total10'
              dataType: 'real'
              index: 13
              subtotals: ''
              width: 150
            }
            column_Total11
            {
              columnId: 'Total11'
              dataPath: 'Total11'
              dataType: 'real'
              index: 14
              subtotals: ''
              width: 150
            }
            column_Total12
            {
              columnId: 'Total12'
              dataPath: 'Total12'
              dataType: 'real'
              index: 15
              subtotals: ''
              width: 150
            }
          }
        }
      }
    }
    userconfigurableinformation
    {