Codeunit 30238 Shpfy Fulfillment Orders API

Shopify Connector, Microsoft.Integration.Shopify

src/Apps/W1/Shopify/App/src/Order Fulfillments/Codeunits/ShpfyFulfillmentOrdersAPI.Codeunit.al325 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;codeunit 30238 "Shpfy Fulfillment Orders API"{    var        CommunicationMgt: Codeunit "Shpfy Communication Mgt.";        JsonHelper: Codeunit "Shpfy Json Helper";        GraphQLType: Enum "Shpfy GraphQL Type";    internal procedure RegisterFulfillmentService(var Shop: Record "Shpfy Shop")    var        SyncShopLocations: Codeunit "Shpfy Sync Shop Locations";        Parameters: Dictionary of [Text, Text];        JResponse: JsonToken;    begin        CommunicationMgt.SetShop(Shop);        Parameters.Add('Name', SyncShopLocations.GetFulfillmentServiceName());        Parameters.Add('CallbackUrl', SyncShopLocations.GetFulfillmentServiceCallbackUrl());        GraphQLType := "Shpfy GraphQL Type"::Fulfillments_CreateFulfillmentService;        JResponse := CommunicationMgt.ExecuteGraphQL(GraphQLType, Parameters);        Shop."Fulfillment Service Activated" := true;        Shop.Modify();    end;    internal procedure GetFulFillmentOrderLines(Shop: Record "Shpfy Shop"; FulfillmentOrderHeader: Record "Shpfy FulFillment Order Header")    var        Cursor: Text;        Parameters: Dictionary of [Text, Text];        JResponse: JsonToken;    begin        CommunicationMgt.SetShop(Shop);        Parameters.Add('FulfillmentOrderId', format(FulfillmentOrderHeader."Shopify Fulfillment Order Id"));        GraphQLType := "Shpfy GraphQL Type"::Fulfillments_GetOpenFulfillmentOrderLines;        repeat            JResponse := CommunicationMgt.ExecuteGraphQL(GraphQLType, Parameters);            if JResponse.IsObject() then                if ExtractFulfillmentOrderLines(Shop, FulfillmentOrderHeader, JResponse.AsObject(), Cursor) then begin                    if Parameters.ContainsKey('After') then                        Parameters.Set('After', Cursor)                    else                        Parameters.Add('After', Cursor);                    GraphQLType := "Shpfy GraphQL Type"::Fulfillments_GetNextOpenFulfillmentOrderLines;                end else                    break;        until not JsonHelper.GetValueAsBoolean(JResponse, 'data.fulfillmentOrder.lineItems.pageInfo.hasNextPage');        Commit();    end;    internal procedure ExtractFulfillmentOrdersFromOrder(var ShopifyShop: Record "Shpfy Shop"; JResponse: JsonObject; var Cursor: Text): Boolean    var        JFulfillmentOrders: JsonArray;        JItem: JsonToken;        JObject: JsonObject;    begin        if JsonHelper.GetJsonObject(JResponse, JObject, 'data.order') then            if JsonHelper.GetJsonArray(JResponse, JFulfillmentOrders, 'data.order.fulfillmentOrders.edges') then begin                foreach JItem in JFulfillmentOrders do                    ExtractFulfillmentOrder(ShopifyShop, JItem, Cursor);                exit(true);            end;    end;    internal procedure ExtractFulfillmentOrder(var ShopifyShop: Record "Shpfy Shop"; JFulfillmentOrder: JsonToken; var Cursor: Text)    var        DataCapture: Record "Shpfy Data Capture";        FulfillmentOrderHeader: Record "Shpfy FulFillment Order Header";        Id: BigInteger;        JNode: JsonObject;    begin        Cursor := JsonHelper.GetValueAsText(JFulfillmentOrder.AsObject(), 'cursor');        if JsonHelper.GetJsonObject(JFulfillmentOrder.AsObject(), JNode, 'node') then begin            Id := CommunicationMgt.GetIdOfGId(JsonHelper.GetValueAsText(JNode, 'id'));            if FulfillmentOrderHeader.Get(Id) then begin                if FulfillmentOrderHeader."Updated At" = JsonHelper.GetValueAsDateTime(JNode, 'updatedAt') then begin                    GetFulfillmentOrderLines(ShopifyShop, FulfillmentOrderHeader);                    exit;                end;            end else                Clear(FulfillmentOrderHeader);            FulfillmentOrderHeader."Shopify Fulfillment Order Id" := Id;            FulfillmentOrderHeader."Shop Id" := ShopifyShop."Shop Id";            FulfillmentOrderHeader."Shop Code" := ShopifyShop.Code;            FulfillmentOrderHeader."Shopify Order Id" := JsonHelper.GetValueAsBigInteger(JNode, 'order.legacyResourceId');            FulfillmentOrderHeader."Shopify Location Id" := JsonHelper.GetValueAsBigInteger(JNode, 'assignedLocation.location.legacyResourceId');            FulfillmentOrderHeader."Updated At" := JsonHelper.GetValueAsDateTime(JNode, 'updatedAt');            FulfillmentOrderHeader.Status := CopyStr(JsonHelper.GetValueAsText(JNode, 'status'), 1, MaxStrLen(FulfillmentOrderHeader.Status));            FulfillmentOrderHeader."Request Status" := ConvertToRequestStatus(JsonHelper.GetValueAsText(JNode, 'requestStatus'));            FulfillmentOrderHeader."Delivery Method Type" := ConvertToDeliveryMethodType(JsonHelper.GetValueAsText(JNode, 'deliveryMethod.methodType'));            if not FulfillmentOrderHeader.Insert() then                FulfillmentOrderHeader.Modify();            DataCapture.Add(Database::"Shpfy FulFillment Order Header", FulfillmentOrderHeader.SystemId, JNode);            GetFulfillmentOrderLines(ShopifyShop, FulfillmentOrderHeader);        end;    end;    internal procedure ExtractFulfillmentOrderLines(var ShopifyShop: Record "Shpfy Shop"; var FulfillmentOrderHeader: Record "Shpfy FulFillment Order Header"; JResponse: JsonObject; var Cursor: Text): Boolean    var        FulfillmentOrderLine: Record "Shpfy FulFillment Order Line";        DataCapture: Record "Shpfy Data Capture";        Modified: Boolean;        Id: BigInteger;        JFulfillmentOrderLines: JsonArray;        JNode: JsonObject;        JItem: JsonToken;    begin        if JsonHelper.GetJsonArray(JResponse, JFulfillmentOrderLines, 'data.fulfillmentOrder.lineItems.edges') then begin            foreach JItem in JFulfillmentOrderLines do begin                Cursor := JsonHelper.GetValueAsText(JItem.AsObject(), 'cursor');                if JsonHelper.GetJsonObject(JItem.AsObject(), JNode, 'node') then begin                    Id := CommunicationMgt.GetIdOfGId(JsonHelper.GetValueAsText(JNode, 'id'));                    if not FulfillmentOrderLine.Get(FulfillmentOrderHeader."Shopify Fulfillment Order Id", Id) then begin                        FulfillmentOrderLine."Shopify Fulfillment Order Id" := FulfillmentOrderHeader."Shopify Fulfillment Order Id";                        FulfillmentOrderLine."Shopify Fulfillm. Ord. Line Id" := Id;                        FulfillmentOrderLine."Shopify Order Id" := FulfillmentOrderHeader."Shopify Order Id";                        FulfillmentOrderLine."Shopify Location Id" := FulfillmentOrderHeader."Shopify Location Id";                        FulfillmentOrderLine."Delivery Method Type" := FulfillmentOrderHeader."Delivery Method Type";                        FulfillmentOrderLine."Line Item Id" := CommunicationMgt.GetIdOfGId(JsonHelper.GetValueAsText(JNode, 'lineItem.id'));                        FulfillmentOrderLine."Shopify Product Id" := JsonHelper.GetValueAsBigInteger(JNode, 'lineItem.product.legacyResourceId');                        FulfillmentOrderLine."Shopify Variant Id" := JsonHelper.GetValueAsBigInteger(JNode, 'lineItem.variant.legacyResourceId');                        FulfillmentOrderLine."Total Quantity" := JsonHelper.GetValueAsDecimal(JNode, 'totalQuantity');                        FulfillmentOrderLine."Remaining Quantity" := JsonHelper.GetValueAsDecimal(JNode, 'remainingQuantity');                        FulfillmentOrderLine."Fulfillment Status" := FulfillmentOrderHeader.Status;                        FulfillmentOrderLine.Insert();                    end else begin                        Modified := false;                        if FulfillmentOrderLine."Shopify Order Id" <> FulfillmentOrderHeader."Shopify Order Id" then begin                            Modified := true;                            FulfillmentOrderLine."Shopify Order Id" := FulfillmentOrderHeader."Shopify Order Id";                        end;                        if FulfillmentOrderLine."Shopify Location Id" <> FulfillmentOrderHeader."Shopify Location Id" then begin                            Modified := true;                            FulfillmentOrderLine."Shopify Location Id" := FulfillmentOrderHeader."Shopify Location Id";                        end;                        if FulfillmentOrderLine."Line Item Id" <> CommunicationMgt.GetIdOfGId(JsonHelper.GetValueAsText(JNode, 'lineItem.id')) then begin                            Modified := true;                            FulfillmentOrderLine."Line Item Id" := CommunicationMgt.GetIdOfGId(JsonHelper.GetValueAsText(JNode, 'lineItem.id'));                        end;                        if FulfillmentOrderLine."Delivery Method Type" <> FulfillmentOrderHeader."Delivery Method Type" then begin                            Modified := true;                            FulfillmentOrderLine."Delivery Method Type" := FulfillmentOrderHeader."Delivery Method Type";                        end;                        if FulfillmentOrderLine."Shopify Product Id" <> JsonHelper.GetValueAsBigInteger(JNode, 'lineItem.product.legacyResourceId') then begin                            Modified := true;                            FulfillmentOrderLine."Shopify Product Id" := JsonHelper.GetValueAsBigInteger(JNode, 'lineItem.product.legacyResourceId');                        end;                        if FulfillmentOrderLine."Shopify Variant Id" <> JsonHelper.GetValueAsBigInteger(JNode, 'lineItem.variant.legacyResourceId') then begin                            Modified := true;                            FulfillmentOrderLine."Shopify Variant Id" := JsonHelper.GetValueAsBigInteger(JNode, 'lineItem.variant.legacyResourceId');                        end;                        if FulfillmentOrderLine."Total Quantity" <> JsonHelper.GetValueAsDecimal(JNode, 'totalQuantity') then begin                            Modified := true;                            FulfillmentOrderLine."Total Quantity" := JsonHelper.GetValueAsDecimal(JNode, 'totalQuantity');                        end;                        if FulfillmentOrderLine."Remaining Quantity" <> JsonHelper.GetValueAsDecimal(JNode, 'remainingQuantity') then begin                            Modified := true;                            FulfillmentOrderLine."Remaining Quantity" := JsonHelper.GetValueAsDecimal(JNode, 'remainingQuantity');                        end;                        if Modified then                            FulfillmentOrderLine.Modify();                    end;                end;            end;            DataCapture.Add(Database::"Shpfy FulFillment Order Header", FulfillmentOrderHeader.SystemId, JFulfillmentOrderLines.AsToken());            exit(true);        end;    end;    internal procedure GetShopifyFulfillmentOrdersFromShopifyOrder(Shop: Record "Shpfy Shop"; OrderId: BigInteger)    var        Cursor: Text;        Parameters: Dictionary of [Text, Text];        JResponse: JsonToken;    begin        CommunicationMgt.SetShop(Shop);        if Shop."Allow Outgoing Requests" then            if not Shop."Fulfillment Service Activated" then                RegisterFulfillmentService(Shop);        GraphQLType := "Shpfy GraphQL Type"::Fulfillments_GetFulfillmentOrdersFromOrder;        repeat            if Parameters.ContainsKey('OrderId') then                Parameters.Set('OrderId', Format(OrderId))            else                Parameters.Add('OrderId', Format(OrderId));            JResponse := CommunicationMgt.ExecuteGraphQL(GraphQLType, Parameters);            if JResponse.IsObject() then                if ExtractFulfillmentOrdersFromOrder(Shop, JResponse.AsObject(), Cursor) then begin                    if Parameters.ContainsKey('After') then                        Parameters.Set('After', Cursor)                    else                        Parameters.Add('After', Cursor);                    GraphQLType := "Shpfy GraphQL Type"::Fulfillments_GetNextFulfillmentOrdersFromOrder;                end else                    break;        until not JsonHelper.GetValueAsBoolean(JResponse, 'data.order.fulfillmentOrders.pageInfo.hasNextPage');    end;    internal procedure GetAssignedFulfillmentOrders(var Shop: Record "Shpfy Shop"; var FulfillmentOrderIds: Dictionary of [BigInteger, Code[20]])    var        Cursor: Text;        Parameters: Dictionary of [Text, Text];        JResponse: JsonToken;    begin        if not Shop."Fulfillment Service Activated" then            exit;        CommunicationMgt.SetShop(Shop);        if not HasFulfillmentService() then begin            Shop."Fulfillment Service Activated" := false;            Shop.Modify();            exit;        end;        GraphQLType := "Shpfy GraphQL Type"::Fulfillments_GetAssignedFulfillmentOrders;        repeat            JResponse := CommunicationMgt.ExecuteGraphQL(GraphQLType, Parameters);            if JResponse.IsObject() then                if ExtractAssignedFulfillmentOrderIds(Shop.Code, JResponse.AsObject(), FulfillmentOrderIds, Cursor) then begin                    if Parameters.ContainsKey('After') then                        Parameters.Set('After', Cursor)                    else                        Parameters.Add('After', Cursor);                    GraphQLType := "Shpfy GraphQL Type"::Fulfillments_GetNextAssignedFulfillmentOrders;                end else                    break;        until not JsonHelper.GetValueAsBoolean(JResponse, 'data.assignedFulfillmentOrders.pageInfo.hasNextPage');    end;    local procedure HasFulfillmentService(): Boolean    var        SyncShopLocations: Codeunit "Shpfy Sync Shop Locations";        Parameters: Dictionary of [Text, Text];        JResponse: JsonToken;        JLocations: JsonArray;    begin        GraphQLType := "Shpfy GraphQL Type"::Fulfillments_HasFulfillmentService;        Parameters.Add('Name', SyncShopLocations.GetFulfillmentServiceName());        JResponse := CommunicationMgt.ExecuteGraphQL(GraphQLType, Parameters);        if not JResponse.IsObject() then            exit(false);        if not JsonHelper.GetJsonArray(JResponse.AsObject(), JLocations, 'data.locations.nodes') then            exit(false);        exit(JLocations.Count() > 0);    end;    local procedure ExtractAssignedFulfillmentOrderIds(ShopCode: Code[20]; JResponse: JsonObject; var FulfillmentOrderIds: Dictionary of [BigInteger, Code[20]]; var Cursor: Text): Boolean    var        JEdges: JsonArray;        JNode: JsonObject;        JItem: JsonToken;        Id: BigInteger;    begin        if JsonHelper.GetJsonArray(JResponse, JEdges, 'data.assignedFulfillmentOrders.edges') then begin            foreach JItem in JEdges do begin                Cursor := JsonHelper.GetValueAsText(JItem.AsObject(), 'cursor');                if JsonHelper.GetJsonObject(JItem.AsObject(), JNode, 'node') then begin                    Id := CommunicationMgt.GetIdOfGId(JsonHelper.GetValueAsText(JNode, 'id'));                    if not FulfillmentOrderIds.ContainsKey(Id) then                        FulfillmentOrderIds.Add(Id, ShopCode);                end;            end;            exit(JEdges.Count() > 0);        end;        exit(false);    end;    internal procedure AcceptFulfillmentRequest(Shop: Record "Shpfy Shop"; var FulfillmentOrderHeader: Record "Shpfy FulFillment Order Header"): Boolean    var        Parameters: Dictionary of [Text, Text];        JResponse: JsonToken;        NewRequestStatus: Enum "Shpfy FF Request Status";    begin        CommunicationMgt.SetShop(Shop);        Parameters.Add('FulfillmentOrderId', Format(FulfillmentOrderHeader."Shopify Fulfillment Order Id"));        GraphQLType := "Shpfy GraphQL Type"::Fulfillments_AcceptFulfillmentRequest;        JResponse := CommunicationMgt.ExecuteGraphQL(GraphQLType, Parameters);        if JResponse.IsObject() then begin            NewRequestStatus := ConvertToRequestStatus(JsonHelper.GetValueAsText(JResponse, 'data.fulfillmentOrderAcceptFulfillmentRequest.fulfillmentOrder.requestStatus'));            if NewRequestStatus = Enum::"Shpfy FF Request Status"::ACCEPTED then begin                FulfillmentOrderHeader."Request Status" := NewRequestStatus;                FulfillmentOrderHeader.Modify();                exit(true);            end;        end;        exit(false);    end;    local procedure ConvertToDeliveryMethodType(Value: Text): Enum "Shpfy Delivery Method Type"    begin        Value := CommunicationMgt.ConvertToCleanOptionValue(Value);        if Enum::"Shpfy Delivery Method Type".Names().Contains(Value) then            exit(Enum::"Shpfy Delivery Method Type".FromInteger(Enum::"Shpfy Delivery Method Type".Ordinals().Get(Enum::"Shpfy Delivery Method Type".Names().IndexOf(Value))))        else            exit(Enum::"Shpfy Delivery Method Type"::" ");    end;    local procedure ConvertToRequestStatus(Value: Text): Enum "Shpfy FF Request Status"    begin        Value := CommunicationMgt.ConvertToCleanOptionValue(Value);        if Enum::"Shpfy FF Request Status".Names().Contains(Value) then            exit(Enum::"Shpfy FF Request Status".FromInteger(Enum::"Shpfy FF Request Status".Ordinals().Get(Enum::"Shpfy FF Request Status".Names().IndexOf(Value))))        else            exit(Enum::"Shpfy FF Request Status"::" ");    end;}