Kevin Kok Khah Whey
2023-11-07 5ae534ab606e6f2ba5ea60914224d665b0447d5a
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
Quintiq file version 2.0
#parent: #root
StaticMethod FlushData (
  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() );
      }
      
    }
  *]
}