Codeunit 30194 Shpfy Transactions

Shopify Connector, Microsoft.Integration.Shopify

src/Apps/W1/Shopify/App/src/Transactions/Codeunits/ShpfyTransactions.Codeunit.al153 lines, Copyright (c) Microsoft Corporation. MIT

// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.Integration.Shopify;/// <summary>/// Codeunit Shpfy Transactions (ID 30194)./// </summary>codeunit 30194 "Shpfy Transactions"{    Access = Internal;    var        CommunicationMgt: Codeunit "Shpfy Communication Mgt.";        JsonHelper: Codeunit "Shpfy Json Helper";    local procedure ConvertToTransactionStatus(Value: Text): Enum "Shpfy Transaction Status"    begin        Value := CommunicationMgt.ConvertToCleanOptionValue(Value);        if Enum::"Shpfy Transaction Status".Names().Contains(Value) then            exit(Enum::"Shpfy Transaction Status".FromInteger(Enum::"Shpfy Transaction Status".Ordinals().Get(Enum::"Shpfy Transaction Status".Names().IndexOf(Value))))        else            exit(Enum::"Shpfy Transaction Status"::" ");    end;    local procedure ConvertToTransactionType(Value: Text): Enum "Shpfy Transaction Type"    begin        Value := CommunicationMgt.ConvertToCleanOptionValue(Value);        if Enum::"Shpfy Transaction Type".Names().Contains(Value) then            exit(Enum::"Shpfy Transaction Type".FromInteger(Enum::"Shpfy Transaction Type".Ordinals().Get(Enum::"Shpfy Transaction Type".Names().IndexOf(Value))))        else            exit(Enum::"Shpfy Transaction Type"::" ");    end;    internal procedure UpdateTransactionInfos(OrderId: BigInteger)    var        OrderHeader: Record "Shpfy Order Header";    begin        if OrderHeader.Get(OrderId) then            UpdateTransactionInfos(OrderHeader);    end;    internal procedure UpdateTransactionInfos(OrderHeader: Record "Shpfy Order Header")    var        GraphQLType: Enum "Shpfy GraphQL Type";        JResponse: JsonToken;        JOrderTransaction: JsonToken;        JOrderTransactions: JsonArray;        Parameters: Dictionary of [Text, Text];    begin        CommunicationMgt.SetShop(OrderHeader."Shop Code");        GraphQLType := "Shpfy GraphQL Type"::Payments_GetOrderTransactions;        Parameters.Add('OrderId', Format(OrderHeader."Shopify Order Id"));        JResponse := CommunicationMgt.ExecuteGraphQL(GraphQLType, Parameters);        if JsonHelper.GetJsonArray(JResponse, JOrderTransactions, 'data.order.transactions') then            foreach JOrderTransaction in JOrderTransactions do                ExtractShopifyOrderTransaction(JOrderTransaction, OrderHeader);    end;    local procedure ExtractShopifyOrderTransaction(JOrderTransaction: JsonToken; OrderHeader: Record "Shpfy Order Header")    var        CreditCardCompany: Record "Shpfy Credit Card Company";        DataCapture: Record "Shpfy Data Capture";        OrderTransaction: Record "Shpfy Order Transaction";        PaymentMethodMapping: Record "Shpfy Payment Method Mapping";        TransactionGateway: Record "Shpfy Transaction Gateway";        ImportOrder: Codeunit "Shpfy Import Order";        RecordRef: RecordRef;        Id: BigInteger;        IsNew: Boolean;        JObject: JsonObject;        ReceiptJson: Text;    begin        Id := CommunicationMgt.GetIdOfGId(JsonHelper.GetValueAsText(JOrderTransaction, 'id'));        IsNew := not OrderTransaction.Get(Id);        if IsNew then begin            Clear(OrderTransaction);            OrderTransaction."Shopify Transaction Id" := Id;        end;        OrderTransaction.Status := ConvertToTransactionStatus(JsonHelper.GetValueAsText(JOrderTransaction, 'status'));        OrderTransaction.Type := ConvertToTransactionType(JsonHelper.GetValueAsText(JOrderTransaction, 'kind'));        OrderTransaction."Shopify Order Id" := OrderHeader."Shopify Order Id";        OrderTransaction."Shop" := OrderHeader."Shop Code";        RecordRef.GetTable(OrderTransaction);        JsonHelper.GetValueIntoField(JOrderTransaction, 'gateway', RecordRef, OrderTransaction.FieldNo(Gateway));        JsonHelper.GetValueIntoField(JOrderTransaction, 'formattedGateway', RecordRef, OrderTransaction.FieldNo(Message));        JsonHelper.GetValueIntoField(JOrderTransaction, 'manualPaymentGateway', RecordRef, OrderTransaction.FieldNo("Manual Payment Gateway"));        JsonHelper.GetValueIntoField(JOrderTransaction, 'createdAt', RecordRef, OrderTransaction.FieldNo("Created At"));        JsonHelper.GetValueIntoField(JOrderTransaction, 'test', RecordRef, OrderTransaction.FieldNo(Test));        JsonHelper.GetValueIntoField(JOrderTransaction, 'authorizationCode', RecordRef, OrderTransaction.FieldNo(Authorization));        JsonHelper.GetValueIntoField(JOrderTransaction, 'errorCode', RecordRef, OrderTransaction.FieldNo("Error Code"));        JsonHelper.GetValueIntoField(JOrderTransaction, 'paymentId', RecordRef, OrderTransaction.FieldNo("Payment Id"));        JsonHelper.GetValueIntoField(JOrderTransaction, 'amountSet.shopMoney.amount', RecordRef, OrderTransaction.FieldNo(Amount));        JsonHelper.GetValueIntoField(JOrderTransaction, 'amountSet.shopMoney.currencyCode', RecordRef, OrderTransaction.FieldNo(Currency));        JsonHelper.GetValueIntoField(JOrderTransaction, 'amountSet.presentmentMoney.amount', RecordRef, OrderTransaction.FieldNo("Presentment Amount"));        JsonHelper.GetValueIntoField(JOrderTransaction, 'amountSet.presentmentMoney.currencyCode', RecordRef, OrderTransaction.FieldNo("Presentment Currency"));        JsonHelper.GetValueIntoField(JOrderTransaction, 'amountRoundingSet.shopMoney.amount', RecordRef, OrderTransaction.FieldNo("Rounding Amount"));        JsonHelper.GetValueIntoField(JOrderTransaction, 'amountRoundingSet.shopMoney.currencyCode', RecordRef, OrderTransaction.FieldNo("Rounding Currency"));        JsonHelper.GetValueIntoField(JOrderTransaction, 'amountRoundingSet.presentmentMoney.amount', RecordRef, OrderTransaction.FieldNo("Presentment Rounding Amount"));        JsonHelper.GetValueIntoField(JOrderTransaction, 'amountRoundingSet.presentmentMoney.currencyCode', RecordRef, OrderTransaction.FieldNo("Presentment Rounding Currency"));        ReceiptJson := JsonHelper.GetValueAsText(JOrderTransaction, 'receiptJson');        if JObject.ReadFrom(ReceiptJson) then            JsonHelper.GetValueIntoField(JObject, 'gift_card_id', RecordRef, OrderTransaction.FieldNo("Gift Card Id"));        if JsonHelper.GetJsonObject(JOrderTransaction, JObject, 'paymentDetails') then begin            JsonHelper.GetValueIntoField(JOrderTransaction, 'paymentDetails.bin', RecordRef, OrderTransaction.FieldNo("Credit Card Bin"));            JsonHelper.GetValueIntoField(JOrderTransaction, 'paymentDetails.avsResultCode', RecordRef, OrderTransaction.FieldNo("AVS Result Code"));            JsonHelper.GetValueIntoField(JOrderTransaction, 'paymentDetails.cvvResultCode', RecordRef, OrderTransaction.FieldNo("CVV Result Code"));            JsonHelper.GetValueIntoField(JOrderTransaction, 'paymentDetails.number', RecordRef, OrderTransaction.FieldNo("Credit Card Number"));            JsonHelper.GetValueIntoField(JOrderTransaction, 'paymentDetails.company', RecordRef, OrderTransaction.FieldNo("Credit Card Company"));        end;        if IsNew then            RecordRef.Insert()        else            RecordRef.Modify();        RecordRef.SetTable(OrderTransaction);        RecordRef.Close();        OrderTransaction.Currency := ImportOrder.TranslateCurrencyCode(OrderTransaction.Currency);        OrderTransaction."Presentment Currency" := ImportOrder.TranslateCurrencyCode(OrderTransaction."Presentment Currency");        OrderTransaction."Rounding Currency" := ImportOrder.TranslateCurrencyCode(OrderTransaction."Rounding Currency");        OrderTransaction."Presentment Rounding Currency" := ImportOrder.TranslateCurrencyCode(OrderTransaction."Presentment Rounding Currency");        OrderTransaction.Modify();        if OrderTransaction.Gateway <> '' then begin            Clear(TransactionGateway);            TransactionGateway.SetRange(Name, OrderTransaction.Gateway);            if TransactionGateway.IsEmpty then begin                TransactionGateway.Name := OrderTransaction.Gateway;                TransactionGateway.Insert();            end;            Clear(CreditCardCompany);        end;        if OrderTransaction."Credit Card Company" <> '' then begin            CreditCardCompany.SetRange(Name, OrderTransaction."Credit Card Company");            if CreditCardCompany.IsEmpty then begin                CreditCardCompany.Name := OrderTransaction."Credit Card Company";                CreditCardCompany.Insert();            end;        end;        if not PaymentMethodMapping.Get(OrderHeader."Shop Code", OrderTransaction.Gateway, OrderTransaction."Credit Card Company") then begin            Clear(PaymentMethodMapping);            PaymentMethodMapping."Shop Code" := OrderHeader."Shop Code";            PaymentMethodMapping.Gateway := OrderTransaction.Gateway;            PaymentMethodMapping."Credit Card Company" := CopyStr(OrderTransaction."Credit Card Company", 1, MaxStrLen(PaymentMethodMapping."Credit Card Company"));            PaymentMethodMapping."Manual Payment Gateway" := OrderTransaction."Manual Payment Gateway";            PaymentMethodMapping.Insert();        end;        DataCapture.Add(Database::"Shpfy Order Transaction", OrderTransaction.SystemId, JOrderTransaction);    end;}