Эхлэл Бүгдийг харах Тусламж
Нэвтрэх
yusuf
/
btnmw-server-local
-с салаалсан wisnu/btnmw-server-local
1
0
Салаа 0
Файлууд
Мод: 8062162f93
Салаанууд Тагууд
btnmw-server-lo...
/
mwconfig
/
migration
/
MWCONFIG_INITDB_ATMVAD.sql

MWCONFIG_INITDB_ATMVAD.sql 28 KB
Түүх Анхны өгөгдөл

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234 
  1. INSERT INTO MWCONFIG.DTREE(GROUP, PATH, VALUE, MODIFIED_BY, TIMESTAMP, MODULE) 
    2. 

  2. VALUES 
    3. 

  3.     ('ITM-CODE', '0200.412000', '0200.412000.${msg.reservedPrivate2.substring(0, 6)}${msg.reservedPrivate2.substring(9, 12)}', CURRENT USER, CURRENT TIMESTAMP, '[itm]'),
    4. 

  4.     ('ITM-CODE', '0210.412000', '0210.412000.${msg.reservedPrivate2.substring(0, 6)}${msg.reservedPrivate2.substring(9, 12)}', CURRENT USER, CURRENT TIMESTAMP, '[itm]'),
    5. 

  5.     ('ITM-CODE', '0400.412000', '0400.412000.${msg.reservedPrivate2.substring(0, 6)}${msg.reservedPrivate2.substring(9, 12)}', CURRENT USER, CURRENT TIMESTAMP, '[itm]'),
    6. 

  6.     ('ITM-CODE', '0410.412000', '0410.412000.${msg.reservedPrivate2.substring(0, 6)}${msg.reservedPrivate2.substring(9, 12)}', CURRENT USER, CURRENT TIMESTAMP, '[itm]');
    7. 

  7. INSERT INTO MWCONFIG.DTREE("GROUP", "PATH", "VALUE", MODIFIED_BY, TIMESTAMP, MODULE) 
    8. 

  8. VALUES 
    9. 

  9.     ('CHARGES', 'itm'                   , 'itm|${msg.processingCode}'                                  , CURRENT USER, CURRENT TIMESTAMP, '[itm]'),
    10. 

  10.     ('CHARGES', 'itm|411000'            , 'itm|411000|${msg.reservedPrivate2."!value".substring(9,12)}', CURRENT USER, CURRENT TIMESTAMP, '[itm]'),
    11. 

  11.     ('CHARGES', 'itm|412000'            , 'itm|412000|${msg.reservedPrivate2."!value".substring(9,12)}', CURRENT USER, CURRENT TIMESTAMP, '[itm]'),
    12. 

  12.     ('CHARGES', 'itm|411000|BCA'        , 'itm prima withdrawal'                                       , CURRENT USER, CURRENT TIMESTAMP, '[itm]'),
    13. 

  13.     ('CHARGES', 'itm|412000|BCA'        , 'itm prima withdrawal'                                       , CURRENT USER, CURRENT TIMESTAMP, '[itm]'),
    14. 

  14.     ('CHARGES', 'itm prima withdrawal'  , '----'                                                       , CURRENT USER, CURRENT TIMESTAMP, '[itm]');
    15. 

  15. 

  16. INSERT INTO MWCONFIG.ROUTING_TABLE(CODE_START, CODE_END, CHANNEL, START_DATE, END_DATE, QUEUE, CREATE_BY, CREATE_DATE, MODIFIED_BY, MODIFIED_DATE, STATUS, SUBCODEX, ADDITIONAL, REPLY_TO, REPLY_TO_QMGR) 
    17. 

  17.     VALUES 
    18. 

  18.         ('*'                    , '*'                    , 'vad', CURRENT TIMESTAMP, null, 'ITM_IN',          CURRENT USER, CURRENT TIMESTAMP, null, null, 'ACTIVE', null, null, 'ROUTER_OUT', 'ITMBROKER.QM'),
    19. 

  19.         ('0200.412000.VADBCABCA', '0200.412000.VADBCABCA', 'vad', CURRENT TIMESTAMP, null, 'GROUP_CHANGE_IN', CURRENT USER, CURRENT TIMESTAMP, null, null, 'ACTIVE', null, null, 'ROUTER_OUT', 'ITMBROKER.QM');
    20. 

  20. 

  21. INSERT INTO MWCONFIG.CHARGES(ID, C1_VALUE, C1_NAME, C1_SCRIPT, C1_ACCOUNT, C2_VALUE, C2_NAME, C2_SCRIPT, C2_ACCOUNT, C3_VALUE, C3_NAME, C3_SCRIPT, C3_ACCOUNT, C4_VALUE, C4_NAME, C4_SCRIPT, C4_ACCOUNT, C5_VALUE, C5_NAME, C5_SCRIPT, C5_ACCOUNT, MODIFIED_BY, TIMESTAMP) 
    22. 

  22.     VALUES 
    23. 

  23.         ('itm prima withdrawal', 6500.00, 'acquirer', null, null, 1000.00, 'switcher', null, null, 0.00, null, null, null, 475.00, 'acquirer btn', null, null, 0.00, null, null, null, CURRENT USER, CURRENT TIMESTAMP);
    24. 

  24. 

  25. INSERT INTO MWCONFIG.PARAM_MAP("GROUP", NAME, "VALUE", SEQ, MODIFIED_BY, TIMESTAMP, DESCRIPTION) 
    26. 

  26.     VALUES 
    27. 

  27.         ('group-change', 'itm.VAD', 'vad', null, CURRENT USER, CURRENT TIMESTAMP, null),
    28. 

  28.         ('group-change', 'cms.VAD', 'cvd', null, CURRENT USER, CURRENT TIMESTAMP, null),
    29. 

  29.         ('group-change', 'VAD', 'vad', null, CURRENT USER, CURRENT TIMESTAMP, null),
    30. 

  30.         ('group-change', 'cms.VAS', 'cvs', null, CURRENT USER, CURRENT TIMESTAMP, null),
    31. 

  31.         ('group-change', 'itm.VAS', 'itm', null, CURRENT USER, CURRENT TIMESTAMP, null),
    32. 

  32.         ('group-check-code', 'itm.0200.24', 'true', null, CURRENT USER, CURRENT TIMESTAMP, null),
    33. 

  33.         ('group-check-code', 'cms.0200.24', 'true', null, CURRENT USER, CURRENT TIMESTAMP, null),
    34. 

  34.         ('group-check-code', 'itm.24', 'true', null, CURRENT USER, CURRENT TIMESTAMP, null),
    35. 

  35.         ('group-check-code', 'itm.0200.50', 'true', null, CURRENT USER, CURRENT TIMESTAMP, null),
    36. 

  36.         ('group-core', 'vad', 'vad', null, CURRENT USER, CURRENT TIMESTAMP, null),
    37. 

  37.         ('group-core', 'cvd', 'vad', null, CURRENT USER, CURRENT TIMESTAMP, null),
    38. 

  38.         ('group-core', 'cvs', 'vas', null, CURRENT USER, CURRENT TIMESTAMP, null);
    39. 

  39. 

  40. INSERT INTO MWCONFIG.PARAM_MAP("GROUP", NAME, "VALUE", SEQ, MODIFIED_BY, TIMESTAMP, DESCRIPTION) 
    41. 

  41.     VALUES ('request-url', 'VaDebit', 'http://DUMMY:7080/vaccount/btn', null, CURRENT USER, CURRENT TIMESTAMP, null);
    42. 

  42. 

  43. INSERT INTO MWCONFIG.PARAM_MAP("GROUP", NAME, "VALUE", SEQ, MODIFIED_BY, TIMESTAMP, DESCRIPTION) 
    44. 

  44.     VALUES 
    45. 

  45.         ('atm-vad-no-fee', '0200.612000.VADSAT', '7500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    46. 

  46.         ('atm-vad-no-fee', '0200.632000.001SATVAD.2', '6500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    47. 

  47.         ('atm-vad-no-fee', '0200.631000.001SATVAD.2', '6500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    48. 

  48.         ('atm-vad-no-fee', '0200.831000.000ALTVAD', '3000', null, CURRENT USER, CURRENT TIMESTAMP, null),
    49. 

  49.         ('atm-vad-no-fee', '0200.532000.VADHBRVAD.2', '0', null, CURRENT USER, CURRENT TIMESTAMP, null),
    50. 

  50.         ('atm-vad-no-fee', '0200.532000.VADHBR001.2', '6500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    51. 

  51.         ('atm-vad-no-fee', '0200.532000.001HBRVAD.2', '0', null, CURRENT USER, CURRENT TIMESTAMP, null),
    52. 

  52.         ('atm-vad-no-fee', '0200.531000.001HBRVAD.2', '6500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    53. 

  53.         ('atm-vad-no-fee', '0200.532000.VADLMPVAD.2', '0', null, CURRENT USER, CURRENT TIMESTAMP, null),
    54. 

  54.         ('atm-vad-no-fee', '0200.532000.VADLMP001.2', '6500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    55. 

  55.         ('atm-vad-no-fee', '0200.532000.001LMPVAD.2', '6500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    56. 

  56.         ('atm-vad-no-fee', '0200.531000.001LMPVAD.2', '6500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    57. 

  57.         ('atm-vad-no-fee', '0200.832000.VADALTVAD.2', '3000', null, CURRENT USER, CURRENT TIMESTAMP, null),
    58. 

  58.         ('atm-vad-no-fee', '0200.832000.VADALT001.2', '3000', null, CURRENT USER, CURRENT TIMESTAMP, null),
    59. 

  59.         ('atm-vad-no-fee', '0200.832000.001ALTVAD.2', '6500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    60. 

  60.         ('atm-vad-no-fee', '0200.831000.001ALTVAD.2', '6500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    61. 

  61.         ('atm-vad-no-fee', '0200.632000.VADSATVAD.2', '6500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    62. 

  62.         ('atm-vad-no-fee', '0400.831000.000ALTVAD', '3000', null, CURRENT USER, CURRENT TIMESTAMP, null),
    63. 

  63.         ('atm-vad-no-fee', '0400.632000.VADSAT001.2', '6500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    64. 

  64.         ('atm-vad-no-fee', '0400.632000.001SATVAD.2', '6500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    65. 

  65.         ('atm-vad-no-fee', '0400.631000.001SATVAD.2', '6500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    66. 

  66.         ('atm-vad-no-fee', '0400.532000.VADHBRVAD.2', '0', null, CURRENT USER, CURRENT TIMESTAMP, null),
    67. 

  67.         ('atm-vad-no-fee', '0400.532000.VADHBR001.2', '6500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    68. 

  68.         ('atm-vad-no-fee', '0400.532000.001HBRVAD.2', '0', null, CURRENT USER, CURRENT TIMESTAMP, null),
    69. 

  69.         ('atm-vad-no-fee', '0400.531000.001HBRVAD.2', '6500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    70. 

  70.         ('atm-vad-no-fee', '0400.532000.VADLMPVAD.2', '0', null, CURRENT USER, CURRENT TIMESTAMP, null),
    71. 

  71.         ('atm-vad-no-fee', '0400.532000.VADLMP001.2', '6500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    72. 

  72.         ('atm-vad-no-fee', '0400.532000.001LMPVAD.2', '6500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    73. 

  73.         ('atm-vad-no-fee', '0400.531000.001LMPVAD.2', '6500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    74. 

  74.         ('atm-vad-no-fee', '0400.832000.VADALTVAD.2', '3000', null, CURRENT USER, CURRENT TIMESTAMP, null),
    75. 

  75.         ('atm-vad-no-fee', '0400.832000.VADALT001.2', '3000', null, CURRENT USER, CURRENT TIMESTAMP, null),
    76. 

  76.         ('atm-vad-no-fee', '0400.832000.001ALTVAD.2', '6500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    77. 

  77.         ('atm-vad-no-fee', '0400.831000.001ALTVAD.2', '6500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    78. 

  78.         ('atm-vad-no-fee', '0400.632000.VADSATVAD.2', '6500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    79. 

  79.         ('atm-vad-no-fee', '0200.802000.VADALT', '4000', null, CURRENT USER, CURRENT TIMESTAMP, null),
    80. 

  80.         ('atm-vad-no-fee', '0400.802000.VADALT', '4000', null, CURRENT USER, CURRENT TIMESTAMP, null),
    81. 

  81.         ('atm-vad-no-fee', '0200.812000.VADALT', '7500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    82. 

  82.         ('atm-vad-no-fee', '0400.812000.VADALT', '7500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    83. 

  83.         ('atm-vad-no-fee', '0200.832000.VADALT000', '6500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    84. 

  84.         ('atm-vad-no-fee', '0400.832000.VADALT000', '6500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    85. 

  85.         ('atm-vad-no-fee', '0200.832000.VAD001ALT', '6500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    86. 

  86.         ('atm-vad-no-fee', '0400.832000.VAD001ALT', '6500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    87. 

  87.         ('atm-vad-no-fee', '0200.832000.VADALTVAD.1', '6500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    88. 

  88.         ('atm-vad-no-fee', '0400.832000.VADALTVAD.1', '6500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    89. 

  89.         ('atm-vad-no-fee', '0200.832000.VADALT001.1', '6500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    90. 

  90.         ('atm-vad-no-fee', '0400.832000.VADALT001.1', '6500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    91. 

  91.         ('atm-vad-no-fee', '0200.832000.001ALTVAD.1', '6500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    92. 

  92.         ('atm-vad-no-fee', '0400.832000.001ALTVAD.1', '6500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    93. 

  93.         ('atm-vad-no-fee', '0200.832000.000001VAD', '6500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    94. 

  94.         ('atm-vad-no-fee', '0400.832000.000001VAD', '6500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    95. 

  95.         ('atm-vad-no-fee', '0200.832000.000ALTVAD', '3000', null, CURRENT USER, CURRENT TIMESTAMP, null),
    96. 

  96.         ('atm-vad-no-fee', '0400.832000.000ALTVAD', '3000', null, CURRENT USER, CURRENT TIMESTAMP, null),
    97. 

  97.         ('atm-vad-no-fee', '0200.402000.VADBCA', '0', null, CURRENT USER, CURRENT TIMESTAMP, null),
    98. 

  98.         ('atm-vad-no-fee', '0400.402000.VADBCA', '0', null, CURRENT USER, CURRENT TIMESTAMP, null),
    99. 

  99.         ('atm-vad-no-fee', '0200.412000.VADBCA', '7500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    100. 

  100.         ('atm-vad-no-fee', '0400.412000.VADBCA', '7500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    101. 

  101.         ('atm-vad-no-fee', '0200.432000.VADBCA000', '6500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    102. 

  102.         ('atm-vad-no-fee', '0400.432000.VADBCA000', '6500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    103. 

  103.         ('atm-vad-no-fee', '0200.432000.VAD001BCA', '6500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    104. 

  104.         ('atm-vad-no-fee', '0400.432000.VAD001BCA', '6500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    105. 

  105.         ('atm-vad-no-fee', '0200.432000.VADBCAVAD', '6500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    106. 

  106.         ('atm-vad-no-fee', '0400.432000.VADBCAVAD', '6500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    107. 

  107.         ('atm-vad-no-fee', '0200.432000.VADBCA001', '6500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    108. 

  108.         ('atm-vad-no-fee', '0400.432000.VADBCA001', '6500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    109. 

  109.         ('atm-vad-no-fee', '0200.432000.001BCAVAD', '6500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    110. 

  110.         ('atm-vad-no-fee', '0400.432000.001BCAVAD', '6500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    111. 

  111.         ('atm-vad-no-fee', '0200.432000.000001VAD', '5350', null, CURRENT USER, CURRENT TIMESTAMP, null),
    112. 

  112.         ('atm-vad-no-fee', '0400.432000.000001VAD', '6500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    113. 

  113.         ('atm-vad-no-fee', '0200.432000.000BCAVAD', '1500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    114. 

  114.         ('atm-vad-no-fee', '0400.432000.000BCAVAD', '1500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    115. 

  115.         ('atm-vad-no-fee', '0200.831000.001ALTVAD.1', '6500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    116. 

  116.         ('atm-vad-no-fee', '0400.831000.001ALTVAD.1', '6500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    117. 

  117.         ('atm-vad-no-fee', '0400.612000.VADSAT', '7500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    118. 

  118.         ('atm-vad-no-fee', '0200.632000.VADSAT001.2', '6500', null, CURRENT USER, CURRENT TIMESTAMP, null),
    119. 

  119.         ('atm-vad-no-fee', '0200.532000.000001VAD', '0', null, CURRENT USER, CURRENT TIMESTAMP, null),
    120. 

  120.         ('atm-vad-no-fee', '0400.532000.000001VAD', '0', null, CURRENT USER, CURRENT TIMESTAMP, null),
    121. 

  121.         ('atm-vad-no-fee', '0200.531000.000001VAD', '0', null, CURRENT USER, CURRENT TIMESTAMP, null),
    122. 

  122.         ('atm-vad-no-fee', '0400.531000.000001VAD', '0', null, CURRENT USER, CURRENT TIMESTAMP, null),
    123. 

  123.         ('atm-vad-no-fee', '0200.531000.000HBRVAD', '0', null, CURRENT USER, CURRENT TIMESTAMP, null),
    124. 

  124.         ('atm-vad-no-fee', '0400.531000.000HBRVAD', '0', null, CURRENT USER, CURRENT TIMESTAMP, null),
    125. 

  125.         ('atm-vad-no-fee', '0200.532000.000HBRVAD', '0', null, CURRENT USER, CURRENT TIMESTAMP, null),
    126. 

  126.         ('atm-vad-no-fee', '0400.532000.000HBRVAD', '0', null, CURRENT USER, CURRENT TIMESTAMP, null);
    127. 

  127. 

  128. INSERT INTO MWCONFIG.MAPPING(ID, DESCRIPTION, MODIFIED_BY, TIMESTAMP, MODULE) VALUES ('req-change-group.vad', null, CURRENT USER, CURRENT TIMESTAMP, '[vad]');
    129. 

  129. INSERT INTO MWCONFIG.MAPPING_GROUP(MAPPING_ID, ID, "SOURCE", TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) 
    130. 

  130.     VALUES 
    131. 

  131.         ('req-change-group.vad', 1, '/data/frontOriginal', '/data/body', null, null),
    132. 

  132.         ('req-change-group.vad', 2, '/data/frontOriginal/body', '/data/body', null, null);
    133. 

  133. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE(MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) 
    134. 

  134.     VALUES 
    135. 

  135.         ('req-change-group.vad', 1, '@', 'copyMessage("..",".");', 10),
    136. 

  136.         ('req-change-group.vad', 1, '!dir', 'O', 20),
    137. 

  137.         ('req-change-group.vad', 1, '!destination', 'VaDebit', null),
    138. 

  138.         ('req-change-group.vad', 1, '!errorCodePath', 'body.response.data.Item.errCode', null),
    139. 

  139.         ('req-change-group.vad', 1, '!queueName', 'BACKEND_REST_IN', null),
    140. 

  140.         ('req-change-group.vad', 1, '!ReplyToQ', 'GROUP_CHANGE_REPLY.ITM', null),
    141. 

  141.         ('req-change-group.vad', 1, '!RequestURL', '${getParamValue("request-url","VaDebit","http://localhost:8094")}/service', null),
    142. 

  142.         ('req-change-group.vad', 1, 'accNoFrom', '${head.frontOriginal.body.fromAccount}', null),
    143. 

  143.         ('req-change-group.vad', 1, 'accNoTo', '${head.frontOriginal.body.toAccount}', null),
    144. 

  144.         ('req-change-group.vad', 1, 'cnl', 'OT', null),
    145. 

  145.         ('req-change-group.vad', 1, 'iat', '${new java.text.SimpleDateFormat("yyyy").format(new Date())}${head.frontOriginal.body.transmissionDateTime}', null),
    146. 

  146.         ('req-change-group.vad', 1, 'jti', '${head.frontOriginal.body.systemsTraceAuditNumber}${head.frontOriginal.body.retrievalReferenceNumber."!value".trim().padLeft(12,"0").substring(8,12)}', null),
    147. 

  147.         ('req-change-group.vad', 1, 'proCode', '${getParamValue("vad-change-code", head.code."!value", head.code."!value")}', null),
    148. 

  148.         ('req-change-group.vad', 1, 'tid', '${head.frontOriginal.body.cardAcceptorTerminalIdentification}', null),
    149. 

  149.         ('req-change-group.vad', 1, 'reffNoRev', '${head.frontOriginal.body.systemsTraceAuditNumber}${head.frontOriginal.body.retrievalReferenceNumber."!value".trim().padLeft(12,"0").substring(8,12)}', null),
    150. 

  150.         ('req-change-group.vad', 2, '@', 'dtree("CHARGES","!oldgroup");', 10),
    151. 

  151.         ('req-change-group.vad', 2, 'trxAmount', '${head.frontOriginal.body.amountTransaction."!value"==null?"0":decimalFormat("0",(head.frontOriginal.body.amountTransaction."!value".toBigDecimal()/100)-(getCharge(6)?getCharge(6).toBigDecimal():0))}', 20),
    152. 

  152.         ('req-change-group.vad', 2, 'bic', '${msg.reservedPrivate2."!value".substring(6,9) == "VAD"  ? msg.receivingInstitutionIdentificationCode."!value": msg.reservedForPrivateUse."!value"}', null),
    153. 

  153.         ('req-change-group.vad', 2, 'feeAmount', '${getParamValue("atm-vad-no-fee",head.code."!value",head.code."!value".contains("602000.VADSAT")||head.code."!value".contains("612000.VADSAT")?decimalFormat("0",(getCharge(1)?getCharge(1).toBigDecimal():0)+(getCharge(2)?getCharge(2).toBigDecimal():0)+(getCharge(4)?getCharge(4).toBigDecimal():0)):head.code."!value".contains("632000.VADSAT000")||head.code."!value".contains("632000.VAD001000")||head.code."!value".contains("632000.VADSATVAD.1")||head.code."!value".contains("632000.VADSAT001.1")||head.code."!value".contains("632000.001SATVAD.1")?decimalFormat("0",(getCharge(1)?getCharge(1).toBigDecimal():0)+(getCharge(2)?getCharge(2).toBigDecimal():0)+(getCharge(3)?getCharge(3).toBigDecimal():0)):decimalFormat("0",(getCharge(1)?getCharge(1).toBigDecimal():0)+(getCharge(2)?getCharge(2).toBigDecimal():0)+(getCharge(3)?getCharge(3).toBigDecimal():0)+(getCharge(4)?getCharge(4).toBigDecimal():0)+(getCharge(5)?getCharge(5).toBigDecimal():0)))}', 20),
    154. 

  154.         ('req-change-group.vad', 1, '!RouteToCore', '${getParamValue("route-to-core", head.code."!value" , "true")}', null),
    155. 

  155.         ('req-change-group.vad', 1, '!ReplyToQMgr', 'PAYBROKER.QM', null);
    156. 

  156. 

  157. INSERT INTO MWCONFIG.MAPPING(ID, DESCRIPTION, MODIFIED_BY, TIMESTAMP, MODULE) VALUES ('req-enhance.vad', null, CURRENT USER, CURRENT TIMESTAMP, '[vad]');
    158. 

  158. INSERT INTO MWCONFIG.MAPPING_GROUP(MAPPING_ID, ID, "SOURCE", TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) 
    159. 

  159.     VALUES 
    160. 

  160.         ('req-enhance.vad', 1, '/data', '/data', null, null),
    161. 

  161.         ('req-enhance.vad', 2, '/data/body', '/data/body', null, null),
    162. 

  162.         ('req-enhance.vad', 3, '/data/body', '/data/backup', null, null);
    163. 

  163. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE(MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) 
    164. 

  164.     VALUES 
    165. 

  165.         ('req-enhance.vad', 1, '@', 'copyMessage();', null),
    166. 

  166.         ('req-enhance.vad', 2, '!code', '${head.code."!value".replace("VAD", "001")}', null),
    167. 

  167.         ('req-enhance.vad', 2, 'fromAccount', '${head.coreResponse.response.data.accPoolingFrom==null?head.body.fromAccount:head.coreResponse.response.data.accPoolingFrom}', null),
    168. 

  168.         ('req-enhance.vad', 2, 'reservedPrivate2', '${head.body.reservedPrivate2."!value".replace("VAD", "001")}', null),
    169. 

  169.         ('req-enhance.vad', 2, 'toAccount', '${head.coreResponse.response.data.accPoolingTo==null?head.body.toAccount:head.coreResponse.response.data.accPoolingTo}', null),
    170. 

  170.         ('req-enhance.vad', 3, 'accNameFrom', '${head.coreResponse.response.data.accNameFrom}', null),
    171. 

  171.         ('req-enhance.vad', 3, 'accNameTo', '${head.coreResponse.response.data.accNameTo}', null),
    172. 

  172.         ('req-enhance.vad', 3, 'accNoFrom', '${head.coreResponse.response.data.accNoFrom}', null),
    173. 

  173.         ('req-enhance.vad', 3, 'accNoTo', '${head.coreResponse.response.data.accNoTo}', null),
    174. 

  174.         ('req-enhance.vad', 3, 'accPoolingFrom', '${head.coreResponse.response.data.accPoolingFrom}', null),
    175. 

  175.         ('req-enhance.vad', 3, 'accPoolingTo', '${head.coreResponse.response.data.accPoolingTo}', null),
    176. 

  176.         ('req-enhance.vad', 3, 'balanceFrom', '${head.coreResponse.response.data.balanceFrom}', null),
    177. 

  177.         ('req-enhance.vad', 3, 'bit62', '${head.body.reservedPrivate2}', null),
    178. 

  178.         ('req-enhance.vad', 3, 'msgId', '${head.oldgroup}.${head.CorrelId}', null),
    179. 

  179.         ('req-enhance.vad', 3, 'newgroup', '${head.group}', null),
    180. 

  180.         ('req-enhance.vad', 3, 'balanceTo', '${head.coreResponse.response.data.balanceTo}', null),
    181. 

  181.         ('req-enhance.vad', 3, 'proCode', '${head.coreResponse.request.procode}', null),
    182. 

  182.         ('req-enhance.vad', 2, '!ChangeExistingCode', '${getParamValue("vad-change-existing-code", head.code."!value" , head.code."!value".replace("VAD", "001") )}', null);
    183. 

  183. 

  184. 

  185. INSERT INTO MWCONFIG.MAPPING(ID, DESCRIPTION, MODIFIED_BY, TIMESTAMP, MODULE) VALUES ('req-change-group.vad.reverse', null, CURRENT USER, CURRENT TIMESTAMP, '[vad]');
    186. 

  186. INSERT INTO MWCONFIG.MAPPING_GROUP(MAPPING_ID, ID, "SOURCE", TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) 
    187. 

  187.     VALUES ('req-change-group.vad.reverse', 1, '/data/body', '/data/body', null, null);
    188. 

  188. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE(MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) 
    189. 

  189.     VALUES 
    190. 

  190.         ('req-change-group.vad.reverse', 1, '@', 'dtree("CHARGES", "!oldgroup");', 10),
    191. 

  191.         ('req-change-group.vad.reverse', 1, '!CorrelId', '${head.CorrelId}', null),
    192. 

  192.         ('req-change-group.vad.reverse', 1, 'bic', '${head.backup.proCode."!value".substring(12,15)=="VAD"?msg.reservedForPrivateUse."!value":head.backup.proCode."!value".substring(18,21)=="VAD"?msg.receivingInstitutionIdentificationCode."!value":""}', null),
    193. 

  193.         ('req-change-group.vad.reverse', 1, '!ReplyToQMgr', 'PAYBROKER.QM', null),
    194. 

  194.         ('req-change-group.vad.reverse', 1, '!RequestURL', '${getParamValue("request-url","VaDebit","http://localhost:8094")}/service', null),
    195. 

  195.         ('req-change-group.vad.reverse', 1, '!destination', 'VaDebit', null),
    196. 

  196.         ('req-change-group.vad.reverse', 1, '!errorCodePath', 'body.response.data.Item.errCode', null),
    197. 

  197.         ('req-change-group.vad.reverse', 1, '!queueName', 'BACKEND_REST_IN', null),
    198. 

  198.         ('req-change-group.vad.reverse', 1, 'accNoFrom', '${head.backup.accNoFrom."!value"}', null),
    199. 

  199.         ('req-change-group.vad.reverse', 1, 'accNoTo', '${head.backup.accNoTo."!value"}', null),
    200. 

  200.         ('req-change-group.vad.reverse', 1, 'cnl', 'OT', null),
    201. 

  201.         ('req-change-group.vad.reverse', 1, 'iat', '${new java.text.SimpleDateFormat("yyyy").format(new Date())}${msg.transmissionDateTime}', null),
    202. 

  202.         ('req-change-group.vad.reverse', 1, 'jti', '${msg.systemsTraceAuditNumber}${msg.retrievalReferenceNumber."!value".trim().padLeft(12,"0").substring(8,12)}', null),
    203. 

  203.         ('req-change-group.vad.reverse', 1, 'proCode', '${head.backup.proCode."!value".replace("0200.", "0400.")}', null),
    204. 

  204.         ('req-change-group.vad.reverse', 1, 'reffNoRev', '${msg.systemsTraceAuditNumber}${msg.retrievalReferenceNumber."!value".trim().padLeft(12,"0").substring(8,12)}', null),
    205. 

  205.         ('req-change-group.vad.reverse', 1, 'tid', '${msg.cardAcceptorTerminalIdentification}', null),
    206. 

  206.         ('req-change-group.vad.reverse', 1, '!reqtimestamp', '${head.reqtimestamp}', null),
    207. 

  207.         ('req-change-group.vad.reverse', 1, 'feeAmount', '${getParamValue("atm-vad-no-fee",head.backup.proCode."!value".replace("0200.","0400."),head.backup.proCode."!value".replace("0200.","0400.").contains("602000.VADSAT")||head.backup.proCode."!value".replace("0200.","0400.").contains("612000.VADSAT")?decimalFormat("0",(getCharge(1)?getCharge(1).toBigDecimal():0)+(getCharge(2)?getCharge(2).toBigDecimal():0)+(getCharge(4)?getCharge(4).toBigDecimal():0)):head.backup.proCode."!value".replace("0200.","0400.").contains("632000.VADSAT000")||head.backup.proCode."!value".replace("0200.","0400.").contains("632000.VAD001000")||head.backup.proCode."!value".replace("0200.","0400.").contains("632000.VADSATVAD.1")||head.backup.proCode."!value".replace("0200.","0400.").contains("632000.VADSAT001.1")||head.backup.proCode."!value".replace("0200.","0400.").contains("632000.001SATVAD.1")?decimalFormat("0",(getCharge(1)?getCharge(1).toBigDecimal():0)+(getCharge(2)?getCharge(2).toBigDecimal():0)+(getCharge(3)?getCharge(3).toBigDecimal():0)):decimalFormat("0",(getCharge(1)?getCharge(1).toBigDecimal():0)+(getCharge(2)?getCharge(2).toBigDecimal():0)+(getCharge(3)?getCharge(3).toBigDecimal():0)+(getCharge(4)?getCharge(4).toBigDecimal():0)+(getCharge(5)?getCharge(5).toBigDecimal():0)))}', null),
    208. 

  208.         ('req-change-group.vad.reverse', 1, 'trxAmount', '${head.body.amountTransaction."!value"==null?"0":decimalFormat("0",(head.body.amountTransaction."!value".toBigDecimal()/100)-(getCharge(6)?getCharge(6).toBigDecimal():0))}', null),
    209. 

  209.         ('req-change-group.vad.reverse', 1, '!ReplyToQ', 'ITM_CORE_REVERSAL_REPLY', null);
    210. 

  210. 

  211. INSERT INTO MWCONFIG.MAPPING(ID, DESCRIPTION, MODIFIED_BY, TIMESTAMP, MODULE) VALUES ('res-change-group.vad', null, CURRENT USER, CURRENT TIMESTAMP, '[vad]');
    212. 

  212. INSERT INTO MWCONFIG.MAPPING_GROUP(MAPPING_ID, ID, "SOURCE", TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES 
    213. 

  213.     ('res-change-group.vad', 1, '/data', '/data', null, null),
    214. 

  214.     ('res-change-group.vad', 2, '/data/body', '/data/body', null, null);
    215. 

  215. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE(MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) 
    216. 

  216.     VALUES 
    217. 

  217.         ('res-change-group.vad', 1, '@', 'copyMessage();', 10),
    218. 

  218.         ('res-change-group.vad', 2, 'reservedPrivate2', '${head.backup==null?msg.reservedPrivate2:head.backup.bit62 }', 30),
    219. 

  219.         ('res-change-group.vad', 2, 'fromAccount', '${head.backup==null?head.body.fromAccount:head.backup.accNoFrom}', 30),
    220. 

  220.         ('res-change-group.vad', 2, 'toAccount', '${head.backup==null?head.body.toAccount:head.backup.accNoTo}', 30),
    221. 

  221.         ('res-change-group.vad', 2, 'additionalDataPrivate', '${head.backup!=null || head.coreResponse!=null? (["0200.422000.VAD","0200.522000.VAD","0200.622000.VAD","0200.822000.VAD"].contains(head.code."!value".replace("0210","0200"))? (head.backup!=null ? head.backup.accNameTo : head.coreResponse.response.data.accNameTo): (["0200.502000.VADHBR","0200.512000.VADHBR","0200.502000.VADLMP","0200.512000.VADLMP","0200.802000.VADALT","0200.812000.VADALT","0200.402000.VADBCA","0200.412000.VADBCA","0200.602000.VADSAT","0200.612000.VADSAT"].contains(head.backup.proCode."!value".replace("0210","0200"))? (head.backup!=null ? head.backup.accNameFrom : head.coreResponse.response.data.accNameFrom):head.body.additionalDataPrivate)):head.body.additionalDataPrivate}', 30),
    222. 

  222.         ('res-change-group.vad', 2, 'additionalResponseData', '${head.backup!=null? (["0200.502000.VADHBR","0200.512000.VADHBR","0200.532000.VADHBR000","0200.532000.VAD001000","0200.532000.VADHBRVAD.1","0200.532000.VADHBR001.1","0200.502000.VADLMP","0200.512000.VADLMP","0200.532000.VADLMPLMP","0200.532000.VADBMPLMP","0200.532000.VADLMPVAD.1","0200.532000.VADLMP001.1","0200.802000.VADALT","0200.812000.VADALT","0200.832000.VADALT000","0200.832000.VAD001ALT","0200.832000.VADALTVAD.1","0200.832000.VADALT001.1","0200.402000.VADBCA","0200.412000.VADBCA","0200.432000.VADBCA000","0200.432000.VAD001BCA","0200.432000.VADBCAVAD","0200.432000.VADBCA001","0200.602000.VADSAT","0200.612000.VADSAT","0200.632000.VADSAT000","0200.632000.VAD001000","0200.632000.VADSATVAD.1","0200.632000.VADSAT001.1"].contains(head.backup.proCode."!value")? (decimalFormat("0",head.backup.balanceFrom."!value".toBigDecimal()*100).padLeft(12,"0")+decimalFormat("0",head.backup.balanceFrom."!value".toBigDecimal()*100).padLeft(12,"0")): (["0200.532000.VADHBRVAD.2","0200.532000.001HBRVAD.2","0200.532000.VADLMPVAD.2","0200.532000.001LMPVAD.2","0200.832000.VADALTVAD.2","0200.832000.001ALTVAD.2","0200.632000.VADSATVAD.2","0200.632000.VADSAT001.2","0200.632000.001SATVAD.2","531000.001HBRVAD.2","531000.001LMPVAD.2","831000.001ALTVAD.2","631000.001SATVAD.2"].contains(head.backup.proCode."!value")? (decimalFormat("0",head.backup.balanceTo."!value".toBigDecimal()*100).padLeft(12,"0")+decimalFormat("0",head.backup.balanceTo."!value".toBigDecimal()*100).padLeft(12,"0")): (["0200.532000.VADHBR001.2","0200.532000.001HBRVAD.1","0200.532000.000001VAD","0200.532000.000HBRVAD","0200.532000.VADLMP001.2","0200.532000.001LMPVAD.1","0200.531000.LMPBMPVAD","0200.532000.LMPBMPVAD","0200.832000.VADALT001.2 ","0200.832000.001ALTVAD.1","0200.832000.000001VAD","0200.832000.000ALTVAD","0200.432000.001BCAVAD","0200.432000.000001VAD","0200.432000.000BCAVAD","0200.632000.001SATVAD.1","0200.632000.000001VAD","0200.632000.SATSATVAD","0200.531000.001HBRVAD.1","0200.531000.000001VAD","0200.531000.000HBRVAD","0200.531000.001LMPVAD.1","0200.831000.001ALTVAD.1","0200.831000.000001VAD","0200.831000.000ALTVAD","0200.431000.001BCAVAD","0200.431000.000001VAD","0200.431000.000BCAVAD","0200.631000.001SATVAD.1","0200.631000.000001VAD","0200.631000.SATSATVAD"].contains(head.backup.proCode."!value")? head.body.additionalResponseData: null))): null}', 30);
    223. 

  223. 

  224. 

  225. INSERT INTO MWCONFIG.MAPPING(ID, DESCRIPTION, MODIFIED_BY, TIMESTAMP, MODULE) VALUES ('res-change-group.vad.error', null, CURRENT USER, CURRENT TIMESTAMP, '[vad]');
    226. 

  226. INSERT INTO MWCONFIG.MAPPING_GROUP(MAPPING_ID, ID, "SOURCE", TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) 
    227. 

  227.     VALUES ('res-change-group.vad.error', 1, '/data', '/data', null, null),
    228. 

  228.            ('res-change-group.vad.error', 2, '/data/body', '/data/body', null, null);
    229. 

  229. INSERT INTO MWCONFIG.MAPPING_GROUP_LINE(MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) 
    230. 

  230.     VALUES ('res-change-group.vad.error', 1, '@', 'copyMessage();', 10),
    231. 

  231.            ('res-change-group.vad.error', 2, 'messageType', '${head.body.messageType."!value".substring(0,2)}${head.body.messageType."!value".substring(2,4).toBigDecimal()+10}', 20),
    232. 

  232.            ('res-change-group.vad.error', 2, 'responseCode', '${getParamValue("error_map|VaDebit", head.coreResponse.responseCode."!value","99")}', null);
    233. 

  233. 

  234.