Release Notes for 1.0.0-GA

INSERT INTO "paymenttransaction".blc_payment
(ID, OWNER_TYPE, OWNER_ID, NAME, SAVED_PAYMENT_METHOD_ID, TYPE, GATEWAY_TYPE, AMOUNT, SUBTOTAL, ADJUSTMENTS_TOTAL, FULFILLMENT_TOTAL, TAX_TOTAL, ADDRESSES, PAYMENT_METHOD_PROPERTIES, ATTRIBUTES, DISPLAY_ATTRIBUTES, SINGLE_USE_PAYMENT_METHOD, SHOULD_SAVE_PMT_TO_CUSTOMER, VERSION, TRK_ARCHIVED, AUDIT_CREATOR, AUDIT_CREATION_TIME, AUDIT_UPDATER, AUDIT_UPDATE_TIME, TRK_TENANT_ID, ACCESS_RESTRICTIONS)

SELECT cp.ID, 'BLC_CART', cp.CART_ID, cp.NAME, cp.CUSTOMER_PAYMENT_ACCOUNT_ID, cp.TYPE, cp.GATEWAY_TYPE, cp.AMOUNT, cp.SUBTOTAL, cp.ADJUSTMENTS_TOTAL, cp.FULFILLMENT_TOTAL, cp.TAX_TOTAL, CONCAT('[{"BILLING": ', cp.BILLING_ADDRESS, '}]'), cp.PAYMENT_GATEWAY_PROPERTIES, cp.ATTRIBUTES, cp.DISPLAY_ATTRIBUTES, cp.SINGLE_USE_PAYMENT_METHOD, cp.SHOULD_SAVE_PMT_TO_CUSTOMER, COALESCE(cart.version, 1), cp.ARCHIVED, cart.AUDIT_CREATOR, cart.AUDIT_CREATION_TIME, cart.AUDIT_UPDATER, cart.AUDIT_UPDATE_TIME, COALESCE(cart.TRK_TENANT_ID, 'UNKNOWN_TENANT_ID'),
	CASE
		WHEN cart.STATUS = 'SUBMITTED' THEN '["CUSTOMER_MUTABILITY_BLOCKED"]'
		WHEN cart.STATUS = 'CSR_OWNED' THEN '["CSR_OWNED"]'
		WHEN cart.STATUS = 'TEST' THEN '["TEST_USER_OWNED"]'
	END
FROM "cart".blc_cart_payment cp
LEFT JOIN "cart".blc_cart cart on cart.ID=cp.CART_ID

INSERT INTO "paymenttransaction".blc_payment_transaction
(ID, PAYMENT_ID, TYPE, SOURCE_ENTITY_TYPE, SOURCE_ENTITY_ID, MANAGEMENT_STATE, STATUS, TRANSACTION_REFERENCE_ID, SOURCE, REQUEST_ID, AMOUNT, DATE_RECORDED, GATEWAY_RESPONSE_CODE, FAILURE_TYPE, DECLINE_TYPE, THREE_D_SEC_VERIFICATION_URL, RAW_RESPONSE, PARENT_TRANSACTION_ID, ATTRIBUTES, CUSTOMER_IP_ADDRESS, INDETERMINATE_RESULT, VERSION, TRK_ARCHIVED, AUDIT_CREATOR, AUDIT_CREATION_TIME, AUDIT_UPDATER, AUDIT_UPDATE_TIME, TRK_TENANT_ID)

SELECT ctx.ID, ctx.PAYMENT_ID, ctx.TYPE, 'CHECKOUT_REQUEST', ctx.REQUEST_ID,
    CASE
	WHEN cart.STATUS = 'SUBMITTED' THEN 'AUTOMATIC_REVERSAL_NOT_ALLOWED'
	WHEN ctx.MANAGEMENT_STATE != 'REQUIRES_REVERSAL' AND ctx.MANAGEMENT_STATE != 'REVERSAL_IN_PROGRESS' AND ctx.MANAGEMENT_STATE != 'REVERSED' AND ctx.MANAGEMENT_STATE != 'FAILED_REVERSAL' AND ctx.MANAGEMENT_STATE != 'REVERSAL_TRANSACTION' THEN NULL
	ELSE ctx.MANAGEMENT_STATE
    END, ctx.STATUS, ctx.TRANSACTION_REFERENCE_ID, 'CART_OPERATION_SERVICES', ctx.REQUEST_ID, ctx.AMOUNT, ctx.DATE_RECORDED, ctx.GATEWAY_RESPONSE_CODE, ctx.FAILURE_TYPE, ctx.DECLINE_TYPE, NULL, ctx.RAW_RESPONSE, ctx.PARENT_TRANSACTION_ID, ctx.ATTRIBUTES, ctx.CUSTOMER_IP_ADDRESS, ctx.INDETERMINATE_RESULT, COALESCE(p.VERSION, 1), p.TRK_ARCHIVED, p.AUDIT_CREATOR, p.AUDIT_CREATION_TIME, p.AUDIT_UPDATER, p.AUDIT_UPDATE_TIME, COALESCE(p.TRK_TENANT_ID, 'UNKNOWN_TENANT_ID')
FROM "cart".blc_cart_payment_transaction ctx
LEFT JOIN "paymenttransaction".blc_payment p on p.ID=ctx.PAYMENT_ID
LEFT JOIN "cart".blc_cart cart on p.OWNER_ID=cart.ID;

INSERT INTO "paymenttransaction".blc_payment
(ID, OWNER_TYPE, OWNER_ID, NAME, SAVED_PAYMENT_METHOD_ID, TYPE, GATEWAY_TYPE, AMOUNT, SUBTOTAL, ADJUSTMENTS_TOTAL, FULFILLMENT_TOTAL, TAX_TOTAL, ADDRESSES, PAYMENT_METHOD_PROPERTIES, ATTRIBUTES, DISPLAY_ATTRIBUTES, SINGLE_USE_PAYMENT_METHOD, SHOULD_SAVE_PMT_TO_CUSTOMER, VERSION, TRK_ARCHIVED, AUDIT_CREATOR, AUDIT_CREATION_TIME, AUDIT_UPDATER, AUDIT_UPDATE_TIME, TRK_TENANT_ID, ACCESS_RESTRICTIONS)

SELECT op.ID, 'CART', blcOrder.CART_ID, op.NAME, op.CUSTOMER_PAYMENT_ACCOUNT_ID, op.TYPE, op.GATEWAY_TYPE, op.AMOUNT, op.SUBTOTAL, op.ADJUSTMENTS_TOTAL, op.FULFILLMENT_TOTAL, op.TAX_TOTAL, CONCAT('[{"BILLING": ', op.BILLING_ADDRESS, '}]'), op.PAYMENT_GATEWAY_PROPERTIES, op.ATTRIBUTES, op.DISPLAY_ATTRIBUTES, op.SINGLE_USE_PAYMENT_METHOD, op.SHOULD_SAVE_PMT_TO_CUSTOMER, 1, op.ARCHIVED, blcOrder.AUDIT_CREATOR, blcOrder.AUDIT_CREATION_TIME, blcOrder.AUDIT_UPDATER, blcOrder.AUDIT_UPDATE_TIME, COALESCE(blcOrder.TRK_TENANT_ID, 'UNKNOWN_TENANT_ID'), '["CUSTOMER_MUTABILITY_BLOCKED"]'
FROM "order".blc_order_payment op
LEFT JOIN "order".blc_order blcOrder on blcOrder.ID=op.ORDER_ID
WHERE op.ID NOT IN
      (SELECT ptsPayment.ID from "paymenttransaction".blc_payment ptsPayment);

INSERT INTO "paymenttransaction".blc_payment_transaction
(ID, PAYMENT_ID, TYPE, MANAGEMENT_STATE, STATUS, TRANSACTION_REFERENCE_ID, SOURCE, REQUEST_ID, AMOUNT, DATE_RECORDED, GATEWAY_RESPONSE_CODE, FAILURE_TYPE, DECLINE_TYPE, THREE_D_SEC_VERIFICATION_URL, RAW_RESPONSE, PARENT_TRANSACTION_ID, ATTRIBUTES, CUSTOMER_IP_ADDRESS, INDETERMINATE_RESULT, VERSION, TRK_ARCHIVED, AUDIT_CREATOR, AUDIT_CREATION_TIME, AUDIT_UPDATER, AUDIT_UPDATE_TIME, TRK_TENANT_ID)

SELECT otx.ID, otx.PAYMENT_ID, otx.TYPE, 'AUTOMATIC_REVERSAL_NOT_ALLOWED', otx.STATUS, otx.TRANSACTION_REFERENCE_ID, 'ORDER_OPERATION_SERVICES', otx.REQUEST_ID, otx.AMOUNT, otx.DATE_RECORDED, otx.GATEWAY_RESPONSE_CODE, otx.FAILURE_TYPE, otx.DECLINE_TYPE, NULL, otx.RAW_RESPONSE, otx.PARENT_TRANSACTION_ID, otx.ATTRIBUTES, otx.CUSTOMER_IP_ADDRESS, otx.INDETERMINATE_RESULT, COALESCE(p.VERSION, 1), p.TRK_ARCHIVED, p.AUDIT_CREATOR, p.AUDIT_CREATION_TIME, p.AUDIT_UPDATER, p.AUDIT_UPDATE_TIME, COALESCE(p.TRK_TENANT_ID, 'UNKNOWN_TENANT_ID')
FROM "order".blc_order_payment_transaction otx
LEFT JOIN "paymenttransaction".blc_payment p on p.ID=otx.PAYMENT_ID
WHERE NOT EXISTS
    (SELECT 1 FROM "paymenttransaction".blc_payment_transaction
        AS ptsTransaction
    WHERE ptsTransaction.TRANSACTION_REFERENCE_ID = otx.TRANSACTION_REFERENCE_ID
      AND ptsTransaction.TYPE = otx.TYPE);

-- update the source entity type and id for all of the transactions
UPDATE  "paymenttransaction".blc_payment_transaction ptsTransaction
SET SOURCE_ENTITY_ID = transactionLog.ENTITY_ID,
    SOURCE_ENTITY_TYPE = transactionLog.ENTITY_TYPE
FROM "order".BLC_ORDER_PMT_TRANSACTION_LOG transactionLog
WHERE transactionLog.PAYMENT_TRANSACTION_ID = ptsTransaction.ID;

-- update the parent source entity type and id for all of the child transactions
UPDATE "paymenttransaction".blc_payment_transaction childTransaction
SET PARENT_SOURCE_ENTITY_ID = parentTransaction.SOURCE_ENTITY_ID,
    PARENT_SOURCE_ENTITY_TYPE = parentTransaction.SOURCE_ENTITY_TYPE
FROM "paymenttransaction".blc_payment_transaction parentTransaction
WHERE childTransaction.PARENT_TRANSACTION_ID = parentTransaction.ID;