Report 30104 Shpfy Sync Orders from Shopify
src/Apps/W1/Shopify/App/src/Order handling/Reports/ShpfySyncOrdersfromShopify.Report.al180 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 System.Telemetry;/// <summary>/// Report Shpfy Sync Orders from Shopify (ID 30104)./// </summary>report 30104 "Shpfy Sync Orders from Shopify"{ ApplicationArea = All; Caption = 'Sync Orders from Shopify'; ProcessingOnly = true; UsageCategory = Tasks; dataset { dataitem(Shop; "Shpfy Shop") { RequestFilterFields = Code; dataitem(OrdersToImport; "Shpfy Orders to Import") { DataItemLink = "Shop Code" = field(Code); DataItemLinkReference = Shop; RequestFilterFields = "Fully Paid", "Financial Status", "Fulfillment Status", Confirmed, "Import Action", "Attribute Key Filter", "Attribute Key Exists", "Channel Name", "Channel Liable Taxes", "Order No.", "High Risk", "Sell-to Country/Region Code", "Ship-to Country/Region Code", "Bill-to Country/Region Code", "VAT Amount"; trigger OnPreDataItem() var OrdersToImport2: Record "Shpfy Orders to Import"; begin OrdersToImport2.SetView(ToImportView); OrdersToImport2.SetRange("Shop Id", Shop."Shop Id"); OrdersToImport2.SetRange("Shop Code", ''); OrdersToImport2.ModifyAll("Shop Code", Shop.Code); Commit(); if GuiAllowed then begin ToProcess := OrdersToImport.Count; Dialog.Open(OrderTypeTxt + ProcessMsg, ToProcess); Dialog.Update(); end; end; trigger OnAfterGetRecord() var OrderHeader: Record "Shpfy Order Header"; ImportOrder: Codeunit "Shpfy Import Order"; OrderMapping: Codeunit "Shpfy Order Mapping"; begin ClearLastError(); Commit(); if ImportOrder.Run(OrdersToImport) then OrdersToImport."Has Error" := false else begin OrdersToImport."Has Error" := true; OrdersToImport.SetErrorInfo(); end; if OrdersToImport."Has Error" then OrdersToImport.Modify() else if OrderHeader.Get(OrdersToImport.Id) then begin OrdersToImport.Delete(); Commit(); if OrderMapping.DoMapping(OrderHeader) and (OrdersToImport."Import Action" = OrdersToImport."Import Action"::New) then if Shop."Auto Create Orders" then CreateSalesDocumentForOrders(OrderHeader); end; if GuiAllowed then begin ToProcess -= 1; Dialog.Update(); end; end; trigger OnPostDataItem() begin if GuiAllowed then Dialog.Close(); if Shop."Auto Create Orders" then ProcessShopifyRefunds(); end; } trigger OnAfterGetRecord() begin Shop.GetShopSettings(); Shop.Modify(); Clear(OrdersAPI); OrdersAPI.GetOrdersToImport(Shop); end; } } var OrdersAPI: Codeunit "Shpfy Orders API"; Dialog: Dialog; ToImportView: Text; ToProcess: Integer; OrderTypeTxt: Label 'Shopify Order'; ProcessMsg: Label ' To Process: #1###########', Comment = '#1 = ToPrgress'; trigger OnPreReport() var FeatureTelemetry: Codeunit "Feature Telemetry"; begin FeatureTelemetry.LogUsage('0000QWB', 'Shopify', 'Shopify sync orders executed.'); ToImportView := OrdersToImport.GetView(false); end; /// <summary> /// Description for CreateSalesDocumentForOrders. /// </summary> /// <param name="ShopifyOrderHeader">Parameter of type Record "Shopify Order Header".</param> local procedure CreateSalesDocumentForOrders(ShopifyOrderHeader: Record "Shpfy Order Header") var ProcessOrder: Codeunit "Shpfy Process Order"; begin if not ShopifyOrderHeader.Processed then begin Commit(); ClearLastError(); if not ProcessOrder.Run(ShopifyOrderHeader) then begin SelectLatestVersion(); ShopifyOrderHeader.Get(ShopifyOrderHeader."Shopify Order Id"); ShopifyOrderHeader."Has Error" := true; ShopifyOrderHeader."Error Message" := CopyStr(Format(Time) + ' ' + GetLastErrorText(), 1, MaxStrLen(ShopifyOrderHeader."Error Message")); ShopifyOrderHeader."Sales Order No." := ''; ShopifyOrderHeader."Sales Invoice No." := ''; ProcessOrder.CleanUpLastCreatedDocument(); end else begin SelectLatestVersion(); ShopifyOrderHeader.Get(ShopifyOrderHeader."Shopify Order Id"); if ShopifyOrderHeader."Has Error" then exit; ShopifyOrderHeader."Has Error" := false; ShopifyOrderHeader."Error Message" := ''; ShopifyOrderHeader.Processed := true; end; ShopifyOrderHeader.Modify(true); Commit(); end; end; local procedure ProcessShopifyRefunds() var RefundHeader: Record "Shpfy Refund Header"; IReturnRefundProcess: Interface "Shpfy IReturnRefund Process"; RefundTypeTxt: Label 'Shopify Refund'; begin if Shop."Return and Refund Process" = "Shpfy ReturnRefund ProcessType"::"Auto Create Credit Memo" then begin IReturnRefundProcess := Shop."Return and Refund Process"; RefundHeader.SetRange("Is Processed", false); RefundHeader.SetLoadFields("Refund Id"); if RefundHeader.FindSet(false) then begin if GuiAllowed then begin ToProcess := RefundHeader.Count; Dialog.Open(RefundTypeTxt + ProcessMsg, ToProcess); Dialog.Update(); end; repeat IReturnRefundProcess.CreateSalesDocument("Shpfy Source Document Type"::Refund, RefundHeader."Refund Id"); Commit(); if GuiAllowed then begin ToProcess -= 1; Dialog.Update(); end; until RefundHeader.Next() = 0; if GuiAllowed then Dialog.Close(); end; end; end;}