INSERT INTO MWCONFIG.ADAPTOR (ID, DESCRIPTION, ASYNCHRONOUS, MODIFIED_BY, TIMESTAMP) VALUES ('daj-13010', 'Dummy Biller Artajasa', 1, CURRENT USER, CURRENT TIMESTAMP); INSERT INTO MWCONFIG.CODEX (ID, ALLOW_PARTIAL, XML, MODIFIED_BY, TIMESTAMP) VALUES ('iso-8583-aj', NULL, ' iso-8583-aj ${msg.systemsTraceAuditNumber} ${msg.messageType}.${msg.messageType.startsWith("08") ? msg.networkManagementInformationCode?.padLeft(6, "0") : msg.processingCode?.trim().substring(0,2) +"."+ msg.reservedPrivate3} ', CURRENT USER, CURRENT TIMESTAMP); INSERT INTO MWCONFIG.ADAPTOR_CODEX (ADAPTOR_ID, ID, CODEX_ID) VALUES ('daj-13010', 'incoming', 'iso-8583-aj'); INSERT INTO MWCONFIG.ADAPTOR_CODEX (ADAPTOR_ID, ID, CODEX_ID) VALUES ('daj-13010', 'outgoing', 'iso-8583-aj'); INSERT INTO MWCONFIG.ADAPTOR_PARAM (ADAPTOR_ID, NAME, VALUE) VALUES ('daj-13010', 'maxConnection', '1'); INSERT INTO MWCONFIG.SERVER_PORT (ADAPTOR_ID, PORT, SERVER, GROUP) VALUES ('daj-13010', 13010, 'dummy-server', 'daj'); INSERT INTO MWCONFIG.MAPPING (ID, DESCRIPTION, MODULE, MODIFIED_BY ,TIMESTAMP) VALUES ('dummy-res.daj.default-mapping', NULL, '[daj]', CURRENT USER, CURRENT TIMESTAMP); INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES ('dummy-res.daj.default-mapping', 1, '/data', '/data', NULL, NULL), ('dummy-res.daj.default-mapping', 2, '/data/body', '/data/body', NULL, NULL); INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('dummy-res.daj.default-mapping', 1, '@', 'copyMessage();', NULL), ('dummy-res.daj.default-mapping', 2, 'messageType', '${msg.messageType.''!value''.substring(0,2).concat("10")}', NULL), ('dummy-res.daj.default-mapping', 2, 'responseCode', '00', NULL); INSERT INTO MWCONFIG.MAPPING (ID, DESCRIPTION, MODULE, MODIFIED_BY ,TIMESTAMP) VALUES ('dummy-res.daj.default-transaction-mapping', NULL, '[daj]', CURRENT USER, CURRENT TIMESTAMP); INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES ('dummy-res.daj.default-transaction-mapping', 3, '/data/body', '/data/body', NULL, NULL); INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('dummy-res.daj.default-transaction-mapping', 3, 'dateCapture', '${msg.dateLocalTransaction}', NULL), ('dummy-res.daj.default-transaction-mapping', 3, 'reservedPrivate1', 'BTN4PRO100000000000', NULL), ('dummy-res.daj.default-transaction-mapping', 3, 'receivingInstitutionIdentificationCode', '20000000001', NULL); INSERT INTO MWCONFIG.MAPPING (ID, DESCRIPTION, MODULE, MODIFIED_BY ,TIMESTAMP) VALUES ('dummy-res.daj.0800.000001', 'SIGN ON', '[daj]', CURRENT USER, CURRENT TIMESTAMP); INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES ('dummy-res.daj.0800.000001', 1, '/data', '/data', 'dummy-res.daj.default-mapping', 1), ('dummy-res.daj.0800.000001', 2, '/data/body', '/data/body', 'dummy-res.daj.default-mapping', 2); INSERT INTO MWCONFIG.MAPPING (ID, DESCRIPTION, MODULE, MODIFIED_BY ,TIMESTAMP) VALUES ('dummy-res.daj.0800.000301', 'ECHO TEST', '[daj]', CURRENT USER, CURRENT TIMESTAMP); INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES ('dummy-res.daj.0800.000301', 1, '/data', '/data', 'dummy-res.daj.default-mapping', 1), ('dummy-res.daj.0800.000301', 2, '/data/body', '/data/body', 'dummy-res.daj.default-mapping', 2); INSERT INTO MWCONFIG.MAPPING (ID, DESCRIPTION, MODULE, MODIFIED_BY ,TIMESTAMP) VALUES ('dummy-res.daj.0200.38.122', 'XL/AXIS Postpaid Inquiry', '[daj]', CURRENT USER, CURRENT TIMESTAMP); INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES ('dummy-res.daj.0200.38.122', 1, '/data', '/data', 'dummy-res.daj.default-mapping', 1), ('dummy-res.daj.0200.38.122', 2, '/data/body', '/data/body', 'dummy-res.daj.default-mapping', 2), ('dummy-res.daj.0200.38.122', 3, '/data/body', '/data/body', 'dummy-res.daj.default-transaction-mapping', 3); INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('dummy-res.daj.0200.38.122', 2, 'responseCode', '${msg.additionalDataPrivate."!value".substring(5,7)}', 10), ('dummy-res.daj.0200.38.122', 2, 'additionalDataPrivate', '${tar.responseCode."!value".equals("00")?(msg.additionalDataPrivate."!value".substring(0, 13)+"1234567890 "+"NAMA PELANGGAN DUMMY "+"000000126000"+"29092018"+" "):msg.additionalDataPrivate}', 20);