Codeunit 30163 Shpfy Order Mapping

Shopify Connector, Microsoft.Integration.Shopify

src/Apps/W1/Shopify/App/src/Order handling/Codeunits/ShpfyOrderMapping.Codeunit.al387 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;using Microsoft.CRM.BusinessRelation;using Microsoft.CRM.Contact;using Microsoft.Inventory.Item;/// <summary>/// Codeunit Shpfy Order Mapping (ID 30163)./// </summary>codeunit 30163 "Shpfy Order Mapping"{    Access = Internal;    Permissions =        tabledata Item = rim,        tabledata "Item Variant" = rim;    var        OrderEvents: Codeunit "Shpfy Order Events";    /// <summary>     /// Description for DoMapping.    /// </summary>    /// <param name="OrderHeader">Parameter of type Record "Shopify Order Header".</param>    internal procedure DoMapping(var OrderHeader: Record "Shpfy Order Header") Result: Boolean    var        CustomerTemplate: Record "Shpfy Customer Template";        OrderLine: Record "Shpfy Order Line";        Shop: Record "Shpfy Shop";    begin        Shop.Get(OrderHeader."Shop Code");        if not OrderHeader.B2B then begin            if CustomerTemplate.Get(OrderHeader."Shop Code", OrderHeader."Ship-to Country/Region Code") then begin                if CustomerTemplate."Default Customer No." <> '' then begin                    OrderHeader."Bill-to Customer No." := CustomerTemplate."Default Customer No.";                    OrderHeader."Sell-to Customer No." := CustomerTemplate."Default Customer No.";                    OrderHeader.Modify();                end;            end else                if Shop."Customer Import From Shopify" = Shop."Customer Import From Shopify"::None then begin                    if OrderHeader."Bill-to Customer No." = '' then                        OrderHeader."Bill-to Customer No." := Shop."Default Customer No.";                    if OrderHeader."Sell-to Customer No." = '' then                        OrderHeader."Sell-to Customer No." := Shop."Default Customer No.";                    OrderHeader.Modify();                end        end else            if Shop."Company Import From Shopify" = Shop."Company Import From Shopify"::None then begin                if OrderHeader."Bill-to Customer No." = '' then                    OrderHeader."Bill-to Customer No." := Shop."Default Company No.";                if OrderHeader."Sell-to Customer No." = '' then                    OrderHeader."Sell-to Customer No." := Shop."Default Company No.";                OrderHeader.Modify();            end;        if not OrderHeader.B2B then            Result := MapHeaderFields(OrderHeader, Shop, Shop."Auto Create Unknown Customers" and (Shop."Customer Import From Shopify" <> "Shpfy Customer Import Range"::None))        else            Result := MapB2BHeaderFields(OrderHeader, Shop, Shop."Auto Create Unknown Companies" and (Shop."Company Import From Shopify" <> "Shpfy Company Import Range"::None));        OrderLine.SetRange("Shopify Order Id", OrderHeader."Shopify Order Id");        if OrderLine.FindSet(true) then            repeat                if OrderLine.Tip then                    Result := Result and (Shop."Tip Account" <> '')                else                    if OrderLine."Gift Card" then                        Result := Result and (Shop."Sold Gift Card Account" <> '')                    else                        Result := Result and MapVariant(OrderLine, Shop);            until OrderLine.Next() = 0;        OrderEvents.OnAfterMapShopifyOrder(OrderHeader, Result);    end;    /// <summary>     /// Description for MapHeaderFields.    /// </summary>    /// <param name="OrderHeader">Parameter of type Record "Shopify Order Header".</param>    /// <param name="Shop">Parameter of type Record "Shopify Shop".</param>    /// <param name="AllowCreateCustomer">Parameter of type Boolean.</param>    /// <returns>Return variable "Boolean".</returns>    internal procedure MapHeaderFields(var OrderHeader: Record "Shpfy Order Header"; Shop: Record "Shpfy Shop"; AllowCreateCustomer: Boolean): Boolean    var        CustomerMapping: Codeunit "Shpfy Customer Mapping";        CustomerTemplateCode: Code[20];        IsHandled: Boolean;        JCustomer: JsonObject;    begin        CustomerTemplateCode := OrderHeader."Customer Templ. Code";        CustomerMapping.SetShop(OrderHeader."Shop Code");        if OrderHeader."Bill-to Customer No." = '' then begin            OrderEvents.OnBeforeMapCustomer(OrderHeader, IsHandled);            if not IsHandled then begin                if OrderHeader."Sell-to Customer No." = '' then begin                    JCustomer.Add('Name', OrderHeader."Sell-to Customer Name");                    JCustomer.Add('Name2', OrderHeader."Sell-to Customer Name 2");                    JCustomer.Add('Address', OrderHeader."Sell-to Address");                    JCustomer.Add('Address2', OrderHeader."Sell-to Address 2");                    JCustomer.Add('PostCode', OrderHeader."Sell-to Post Code");                    JCustomer.Add('City', OrderHeader."Sell-to City");                    JCustomer.Add('County', OrderHeader."Sell-to County");                    JCustomer.Add('CountryCode', OrderHeader."Sell-to Country/Region Code");                    OrderHeader."Sell-to Customer No." := CustomerMapping.DoMapping(OrderHeader."Customer Id", JCustomer, OrderHeader."Shop Code", CustomerTemplateCode, AllowCreateCustomer);                end;                Clear(JCustomer);                JCustomer.Add('Name', OrderHeader."Bill-to Name");                JCustomer.Add('Name2', OrderHeader."Bill-to Name 2");                JCustomer.Add('Address', OrderHeader."Bill-to Address");                JCustomer.Add('Address2', OrderHeader."Bill-to Address 2");                JCustomer.Add('PostCode', OrderHeader."Bill-to Post Code");                JCustomer.Add('City', OrderHeader."Bill-to City");                JCustomer.Add('County', OrderHeader."Bill-to County");                JCustomer.Add('CountryCode', OrderHeader."Bill-to Country/Region Code");                OrderHeader."Bill-to Customer No." := CustomerMapping.DoMapping(OrderHeader."Customer Id", JCustomer, OrderHeader."Shop Code", CustomerTemplateCode, AllowCreateCustomer);                if (OrderHeader."Bill-to Customer No." = '') and (Shop."Default Customer No." <> '') then                    OrderHeader."Bill-to Customer No." := Shop."Default Customer No.";                if OrderHeader."Sell-to Customer No." = '' then                    OrderHeader."Sell-to Customer No." := OrderHeader."Bill-to Customer No.";                if OrderHeader."Bill-to Customer No." = '' then                    OrderHeader."Bill-to Customer No." := OrderHeader."Sell-to Customer No.";                if OrderHeader."Bill-to Customer No." <> Shop."Default Customer No." then                    OrderHeader."Bill-to Contact No." := FindContactNo(OrderHeader."Bill-to Contact Name", OrderHeader."Bill-to Customer No.");                if OrderHeader."Sell-to Customer No." <> Shop."Default Customer No." then                    OrderHeader."Sell-to Contact No." := FindContactNo(OrderHeader."Sell-to Contact Name", OrderHeader."Sell-to Customer No.");                OrderHeader."Ship-to Contact No." := FindContactNo(OrderHeader."Ship-to Contact Name", OrderHeader."Sell-to Customer No.");                OrderEvents.OnAfterMapCustomer(OrderHeader);            end;        end;        MapShippingMethodCode(OrderHeader);        MapShippingAgent(OrderHeader);        MapPaymentMethodCode(OrderHeader);        MapTaxArea(OrderHeader);        OrderHeader.Modify();        exit((OrderHeader."Bill-to Customer No." <> '') and (OrderHeader."Sell-to Customer No." <> ''));    end;    internal procedure MapB2BHeaderFields(var OrderHeader: Record "Shpfy Order Header"; Shop: Record "Shpfy Shop"; AllowCreateCompany: Boolean): Boolean    var        CompanyMapping: Codeunit "Shpfy Company Mapping";        CustomerTemplateCode: Code[20];        IsHandled: Boolean;        MappedFromLocation: Boolean;    begin        CustomerTemplateCode := OrderHeader."Customer Templ. Code";        CompanyMapping.SetShop(OrderHeader."Shop Code");        if OrderHeader."Bill-to Customer No." = '' then begin            OrderEvents.OnBeforeMapCompany(OrderHeader, IsHandled);            if not IsHandled then begin                if OrderHeader."Company Location Id" <> 0 then                    MappedFromLocation := MapSellToBillToCustomersFromCompanyLocation(OrderHeader);                if not MappedFromLocation then begin                    OrderHeader."Sell-to Customer No." := CompanyMapping.DoMapping(OrderHeader."Company Id", CustomerTemplateCode, AllowCreateCompany);                    OrderHeader."Bill-to Customer No." := OrderHeader."Sell-to Customer No.";                end;                if (OrderHeader."Bill-to Customer No." = '') and (Shop."Default Company No." <> '') then                    OrderHeader."Bill-to Customer No." := Shop."Default Company No.";                if OrderHeader."Sell-to Customer No." = '' then                    OrderHeader."Sell-to Customer No." := OrderHeader."Bill-to Customer No.";                if OrderHeader."Bill-to Customer No." <> Shop."Default Company No." then                    OrderHeader."Bill-to Contact No." := FindContactNo(OrderHeader."Bill-to Contact Name", OrderHeader."Bill-to Customer No.");                if OrderHeader."Sell-to Customer No." <> Shop."Default Company No." then                    OrderHeader."Sell-to Contact No." := FindContactNo(OrderHeader."Sell-to Contact Name", OrderHeader."Sell-to Customer No.");                OrderHeader."Ship-to Contact No." := FindContactNo(OrderHeader."Ship-to Contact Name", OrderHeader."Sell-to Customer No.");                OrderEvents.OnAfterMapCompany(OrderHeader);            end;        end;        MapShippingMethodCode(OrderHeader);        MapShippingAgent(OrderHeader);        MapPaymentMethodCode(OrderHeader);        MapLocationCode(OrderHeader);        MapTaxArea(OrderHeader);        OrderHeader.Modify();        exit((OrderHeader."Bill-to Customer No." <> '') and (OrderHeader."Sell-to Customer No." <> ''));    end;    /// <summary>    /// Description for MapVariant.    /// </summary>    /// <param name="ShopifyOrderLine">Parameter of type Record "Shopify Order Line".</param>    /// <param name="SHop">Parameter of type Record "Shopify Shop".</param>    /// <returns>Return variable "Boolean".</returns>    local procedure MapVariant(var ShopifyOrderLine: Record "Shpfy Order Line"; SHop: Record "Shpfy Shop"): Boolean    var        Item: Record Item;        ItemVariant: Record "Item Variant";        ShopifyVariant: Record "Shpfy Variant";        ProductImport: Codeunit "Shpfy Product Import";    begin        if not ShopifyVariant.Get(ShopifyOrderLine."Shopify Variant Id") or IsNullGuid(ShopifyVariant."Item SystemId") then begin            ProductImport.SetShop(Shop);            ProductImport.SetProduct(ShopifyOrderLine."Shopify Product Id");            ProductImport.Run();        end;        if ShopifyVariant.Get(ShopifyOrderLine."Shopify Variant Id") then begin            if (not IsNullGuid(ShopifyVariant."Item SystemId")) and Item.GetBySystemId(ShopifyVariant."Item SystemId") then                ShopifyOrderLine."Item No." := Item."No.";            if (not IsNullGuid(ShopifyVariant."Item Variant SystemId")) and ItemVariant.GetBySystemId(ShopifyVariant."Item Variant SystemId") then                ShopifyOrderLine."Variant Code" := ItemVariant.Code;            case ShopifyVariant."UoM Option Id" of                1:                    if StrLen(ShopifyVariant."Option 1 Value") <= MaxStrLen(ShopifyOrderLine."Unit of Measure Code") then                        ShopifyOrderLine."Unit of Measure Code" := CopyStr(ShopifyVariant."Option 1 Value", 1, MaxStrLen(ShopifyOrderLine."Unit of Measure Code"));                2:                    if StrLen(ShopifyVariant."Option 2 Value") <= MaxStrLen(ShopifyOrderLine."Unit of Measure Code") then                        ShopifyOrderLine."Unit of Measure Code" := CopyStr(ShopifyVariant."Option 2 Value", 1, MaxStrLen(ShopifyOrderLine."Unit of Measure Code"));                3:                    if StrLen(ShopifyVariant."Option 3 Value") <= MaxStrLen(ShopifyOrderLine."Unit of Measure Code") then                        ShopifyOrderLine."Unit of Measure Code" := CopyStr(ShopifyVariant."Option 3 Value", 1, MaxStrLen(ShopifyOrderLine."Unit of Measure Code"));            end;        end;        if (ShopifyOrderLine."Unit of Measure Code" = '') and (ShopifyOrderLine."Item No." <> '') then            if Item.Get(ShopifyOrderLine."Item No.") then                ShopifyOrderLine."Unit of Measure Code" := Item."Sales Unit of Measure";        ShopifyOrderLine.Modify();        exit(ShopifyOrderLine."Item No." <> '');    end;    internal procedure FindContactNo(ContactName: Text[100]; CustomerNo: Code[20]): Code[20]    var        Contact: Record Contact;        ContactBusinessRelation: Record "Contact Business Relation";    begin        if ContactName = '' then            exit('');        ContactBusinessRelation.SetRange("Link to Table", "Contact Business Relation Link To Table"::Customer);        ContactBusinessRelation.SetRange("No.", CustomerNo);        if ContactBusinessRelation.FindFirst() then begin            Contact.SetRange(Type, "contact Type"::Person);            Contact.SetRange("Company No.", ContactBusinessRelation."Contact No.");            Contact.SetFilter(Name, '''@' + ContactName.Replace('''', '''''') + '''');            if Contact.FindFirst() then                exit(Contact."No.");        end;    end;    local procedure MapShippingMethodCode(var OrderHeader: Record "Shpfy Order Header")    var        OrderShippingCharges: Record "Shpfy Order Shipping Charges";        ShipmentMethodMapping: Record "Shpfy Shipment Method Mapping";        IsHandled: Boolean;    begin        if OrderHeader."Shipping Method Code" = '' then begin            OrderEvents.OnBeforeMapShipmentMethod(OrderHeader, IsHandled);            if not IsHandled then begin                OrderShippingCharges.SetRange("Shopify Order Id", OrderHeader."Shopify Order Id");                if OrderShippingCharges.FindFirst() then                    if ShipmentMethodMapping.Get(OrderHeader."Shop Code", OrderShippingCharges.Title) then                        OrderHeader."Shipping Method Code" := ShipmentMethodMapping."Shipment Method Code";                OrderEvents.OnAfterMapShipmentMethod(OrderHeader);            end;        end;    end;    local procedure MapShippingAgent(var OrderHeader: Record "Shpfy Order Header")    var        OrderShippingCharges: Record "Shpfy Order Shipping Charges";        ShipmentMethodMapping: Record "Shpfy Shipment Method Mapping";        IsHandled: Boolean;    begin        if OrderHeader."Shipping Agent Code" = '' then begin            OrderEvents.OnBeforeMapShipmentAgent(OrderHeader, IsHandled);            if not IsHandled then begin                OrderShippingCharges.SetRange("Shopify Order Id", OrderHeader."Shopify Order Id");                if OrderShippingCharges.FindFirst() then                    if ShipmentMethodMapping.Get(OrderHeader."Shop Code", OrderShippingCharges.Title) then begin                        OrderHeader."Shipping Agent Code" := ShipmentMethodMapping."Shipping Agent Code";                        OrderHeader."Shipping Agent Service Code" := ShipmentMethodMapping."Shipping Agent Service Code";                    end;                OrderEvents.OnAfterMapShipmentAgent(OrderHeader);            end;        end;    end;    local procedure MapPaymentMethodCode(var OrderHeader: Record "Shpfy Order Header")    var        OrderTransaction: Record "Shpfy Order Transaction";        IsHandled: Boolean;        PaymentMethods: List of [Code[10]];    begin        if OrderHeader."Payment Method Code" = '' then begin            OrderEvents.OnBeforeMapPaymentMethod(OrderHeader, IsHandled);            if not IsHandled then begin                OrderTransaction.SetAutoCalcFields("Payment Method");                OrderTransaction.SetRange("Shopify Order Id", OrderHeader."Shopify Order Id");                OrderTransaction.SetRange(Status, "Shpfy Transaction Status"::Success);                OrderTransaction.SetFilter(Type, '%1|%2|%3', "Shpfy Transaction Type"::Sale, "Shpfy Transaction Type"::Capture, "Shpfy Transaction Type"::Authorization);                if OrderTransaction.FindSet() then begin                    repeat                        if not PaymentMethods.Contains(OrderTransaction."Payment Method") then                            PaymentMethods.Add(OrderTransaction."Payment Method");                        if PaymentMethods.Count > 1 then begin                            OrderEvents.OnAfterMapPaymentMethod(OrderHeader);                            exit;                        end;                    until OrderTransaction.Next() = 0;                    OrderHeader."Payment Method Code" := PaymentMethods.Get(1);                end;            end;            OrderEvents.OnAfterMapPaymentMethod(OrderHeader);        end;    end;    local procedure MapLocationCode(OrderHeader: Record "Shpfy Order Header")    var        ShopifyCompany: Record "Shpfy Company";        CompanyLocation: Record "Shpfy Company Location";        CompanyAPI: Codeunit "Shpfy Company API";    begin        if OrderHeader."Company Location Id" = 0 then            exit;        if not ShopifyCompany.Get(OrderHeader."Company Id") then            exit;        CompanyLocation.ReadIsolation := IsolationLevel::ReadUncommitted;        CompanyLocation.SetRange(Id, OrderHeader."Company Location Id");        if not CompanyLocation.IsEmpty() then            exit;        CompanyAPI.SetShop(OrderHeader."Shop Code");        CompanyAPI.UpdateShopifyCompanyLocation(ShopifyCompany, OrderHeader."Company Location Id");    end;    local procedure MapSellToBillToCustomersFromCompanyLocation(var OrderHeader: Record "Shpfy Order Header"): Boolean    var        Company: Record "Shpfy Company";        CompanyLocation: Record "Shpfy Company Location";    begin        if not Company.Get(OrderHeader."Company Id") then            exit(false);        Company.CalcFields("Customer No.");        if not CompanyLocation.Get(OrderHeader."Company Location Id") then            exit(false);        if (Company."Customer No." <> '') and (CompanyLocation."Sell-to Customer No." = '') and (CompanyLocation."Bill-to Customer No." = '') then begin            OrderHeader."Sell-to Customer No." := Company."Customer No.";            OrderHeader."Bill-to Customer No." := Company."Customer No.";        end;        if (Company."Customer No." <> '') and (CompanyLocation."Sell-to Customer No." <> '') and (CompanyLocation."Bill-to Customer No." = '') then begin            OrderHeader."Sell-to Customer No." := CompanyLocation."Sell-to Customer No.";            OrderHeader."Bill-to Customer No." := CompanyLocation."Sell-to Customer No.";        end;        if (Company."Customer No." <> '') and (CompanyLocation."Sell-to Customer No." <> '') and (CompanyLocation."Bill-to Customer No." <> '') then begin            OrderHeader."Sell-to Customer No." := CompanyLocation."Sell-to Customer No.";            OrderHeader."Bill-to Customer No." := CompanyLocation."Bill-to Customer No.";        end;        exit((OrderHeader."Bill-to Customer No." <> '') and (OrderHeader."Sell-to Customer No." <> ''));    end;    local procedure MapTaxArea(var OrderHeader: Record "Shpfy Order Header")    var        ShopifyTaxArea: Record "Shpfy Tax Area";        OrderMgt: Codeunit "Shpfy Order Mgt.";    begin        if OrderHeader."Tax Area Code" <> '' then            exit;        if OrderMgt.FindTaxArea(OrderHeader, ShopifyTaxArea) and (ShopifyTaxArea."Tax Area Code" <> '') then begin            OrderHeader."Tax Area Code" := ShopifyTaxArea."Tax Area Code";            if not OrderHeader."Tax Exempt" then                OrderHeader."Tax Liable" := ShopifyTaxArea."Tax Liable";        end;    end;}