Codeunit 7111 Insert Analysis Line

Base Application, Microsoft.Inventory.Analysis

src/Layers/W1/BaseApp/Inventory/Analysis/InsertAnalysisLine.Codeunit.al208 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.Inventory.Analysis;using Microsoft.Finance.Dimension;using Microsoft.Foundation.Enums;using Microsoft.Inventory.Item;using Microsoft.Inventory.Setup;using Microsoft.Purchases.Vendor;using Microsoft.Sales.Customer;using Microsoft.Sales.Setup;codeunit 7111 "Insert Analysis Line"{    trigger OnRun()    begin    end;    procedure InsertItems(var AnalysisLine: Record "Analysis Line")    var        Item: Record Item;        ItemList: Page "Item List";        ItemCount: Integer;        AnalysisLineNo: Integer;    begin        ItemList.LookupMode(true);        if ItemList.RunModal() = ACTION::LookupOK then begin            ItemList.SetSelection(Item);            ItemCount := Item.Count();            if ItemCount > 0 then begin                MoveAnalysisLines(AnalysisLine, AnalysisLineNo, ItemCount);                if Item.Find('-') then                    repeat                        InsertAnalysisLine(                          AnalysisLine, AnalysisLineNo,                          Item.Description, Item."No.", AnalysisLine.Type::Item, false, 0);                    until Item.Next() = 0;            end;        end;    end;    procedure InsertCust(var AnalysisLine: Record "Analysis Line")    var        Cust: Record Customer;        CustList: Page "Customer List";        CustCount: Integer;        AnalysisLineNo: Integer;    begin        CustList.LookupMode(true);        if CustList.RunModal() = ACTION::LookupOK then begin            CustList.SetSelection(Cust);            CustCount := Cust.Count();            if CustCount > 0 then begin                MoveAnalysisLines(AnalysisLine, AnalysisLineNo, CustCount);                if Cust.Find('-') then                    repeat                        InsertAnalysisLine(                          AnalysisLine, AnalysisLineNo,                          Cust.Name, Cust."No.", AnalysisLine.Type::Customer, false, 0);                    until Cust.Next() = 0;            end;        end;    end;    procedure InsertVend(var AnalysisLine: Record "Analysis Line")    var        Vend: Record Vendor;        VendList: Page "Vendor List";        VendCount: Integer;        AnalysisLineNo: Integer;    begin        VendList.LookupMode(true);        if VendList.RunModal() = ACTION::LookupOK then begin            VendList.SetSelection(Vend);            VendCount := Vend.Count();            if VendCount > 0 then begin                MoveAnalysisLines(AnalysisLine, AnalysisLineNo, VendCount);                if Vend.Find('-') then                    repeat                        InsertAnalysisLine(                          AnalysisLine, AnalysisLineNo,                          Vend.Name, Vend."No.", AnalysisLine.Type::Vendor, false, 0);                    until Vend.Next() = 0;            end;        end;    end;    procedure InsertItemGrDim(var AnalysisLine: Record "Analysis Line")    var        InventorySetup: Record "Inventory Setup";    begin        InventorySetup.Get();        InventorySetup.TestField("Item Group Dimension Code");        InsertGroup(          AnalysisLine,          InventorySetup."Item Group Dimension Code",          AnalysisLine.Type::"Item Group");    end;    procedure InsertCustGrDim(var AnalysisLine: Record "Analysis Line")    var        SalesSetup: Record "Sales & Receivables Setup";    begin        SalesSetup.Get();        SalesSetup.TestField("Customer Group Dimension Code");        InsertGroup(          AnalysisLine,          SalesSetup."Customer Group Dimension Code",          AnalysisLine.Type::"Customer Group");    end;    procedure InsertSalespersonPurchaser(var AnalysisLine: Record "Analysis Line")    var        SalesSetup: Record "Sales & Receivables Setup";    begin        SalesSetup.Get();        SalesSetup.TestField("Salesperson Dimension Code");        InsertGroup(          AnalysisLine,          SalesSetup."Salesperson Dimension Code",          AnalysisLine.Type::"Sales/Purchase person");    end;    procedure InsertGroup(var AnalysisLine: Record "Analysis Line"; GroupDimCode: Code[20]; TotalingType: Enum "Analysis Line Type")    var        DimVal: Record "Dimension Value";        DimValList: Page "Dimension Value List";        DimValCount: Integer;        AnalysisLineNo: Integer;    begin        DimVal.FilterGroup := 2;        DimVal.SetRange("Dimension Code", GroupDimCode);        DimVal.FilterGroup := 0;        DimValList.SetTableView(DimVal);        DimValList.LookupMode(true);        if DimValList.RunModal() = ACTION::LookupOK then begin            DimValList.SetSelection(DimVal);            DimValCount := DimVal.Count();            if DimValCount > 0 then begin                MoveAnalysisLines(AnalysisLine, AnalysisLineNo, DimValCount);                if DimVal.Find('-') then                    repeat                        InsertAnalysisLine(                          AnalysisLine, AnalysisLineNo,                          DimVal.Name, DimVal.Code, TotalingType,                          DimVal."Dimension Value Type" <> DimVal."Dimension Value Type"::Standard,                          DimVal.Indentation);                    until DimVal.Next() = 0;            end;        end;    end;    local procedure MoveAnalysisLines(var AnalysisLine: Record "Analysis Line"; var AnalysisLineNo: Integer; NewLineCount: Integer)    var        i: Integer;    begin        AnalysisLineNo := AnalysisLine."Line No.";        AnalysisLine.SetRange("Analysis Area", AnalysisLine."Analysis Area");        AnalysisLine.SetRange("Analysis Line Template Name", AnalysisLine."Analysis Line Template Name");        if AnalysisLine.Find('+') then            repeat                i := AnalysisLine."Line No.";                if i >= AnalysisLineNo then begin                    AnalysisLine.Delete();                    AnalysisLine."Line No." := i + 10000 * NewLineCount;                    AnalysisLine.Insert(true);                end;            until (i <= AnalysisLineNo) or (AnalysisLine.Next(-1) = 0);        if AnalysisLineNo = 0 then            AnalysisLineNo := 10000;    end;    local procedure InsertAnalysisLine(var AnalysisLine: Record "Analysis Line"; var AnalysisLineNo: Integer; Text: Text[100]; No: Code[20]; Type2: Enum "Analysis Line Type"; Bold2: Boolean; Indent: Integer)    var        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeInsertAnalysisLine(AnalysisLine, AnalysisLineNo, Text, No, Type2, Bold2, Indent, IsHandled);        if IsHandled then            exit;        AnalysisLine.Init();        AnalysisLine."Line No." := AnalysisLineNo;        AnalysisLineNo := AnalysisLineNo + 10000;        AnalysisLine.Description := Text;        AnalysisLine.Range := No;        AnalysisLine."Row Ref. No." := CopyStr(No, 1, MaxStrLen(AnalysisLine."Row Ref. No."));        AnalysisLine.Type := Type2;        AnalysisLine.Bold := Bold2;        AnalysisLine.Indentation := Indent;        AnalysisLine.Insert(true);    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeInsertAnalysisLine(var AnalysisLine: Record "Analysis Line"; var AnalysisLineNo: Integer; Text: Text[100]; No: Code[20]; Type2: Enum "Analysis Line Type"; Bold2: Boolean; Indent: Integer; var IsHandled: Boolean)    begin    end;}