Codeunit 5722 Item Category Management

Base Application, Microsoft.Inventory.Item

src/Layers/W1/BaseApp/Inventory/Item/ItemCategoryManagement.Codeunit.al233 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.Item;using System.Utilities;codeunit 5722 "Item Category Management"{    EventSubscriberInstance = Manual;    trigger OnRun()    begin    end;    var        TempItemCategory: Record "Item Category" temporary;    procedure UpdatePresentationOrder()    var        ItemCategory: Record "Item Category";    begin        TempItemCategory.Reset();        TempItemCategory.DeleteAll();        // This is to cleanup wrong created blank entries created by an import mistake        if ItemCategory.Get('') then            ItemCategory.Delete();        if ItemCategory.FindSet(false) then            repeat                TempItemCategory.TransferFields(ItemCategory);                TempItemCategory.Insert();            until ItemCategory.Next() = 0;        UpdatePresentationOrderIterative();    end;    local procedure UpdatePresentationOrderIterative()    var        ItemCategory: Record "Item Category";        TempStack: Record TempStack temporary;        TempCurItemCategory: Record "Item Category" temporary;        CurItemCategoryID: RecordID;        PresentationOrder: Integer;        Indentation: Integer;        HasChildren: Boolean;        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeUpdatePresentationOrderIterative(TempItemCategory, IsHandled);        if IsHandled then            exit;        PresentationOrder := 0;        TempCurItemCategory.Copy(TempItemCategory, true);        TempItemCategory.SetCurrentKey("Parent Category");        TempItemCategory.Ascending(false);        TempItemCategory.SetRange("Parent Category", '');        if TempItemCategory.FindSet(false) then            repeat                TempStack.Push(TempItemCategory.RecordId());            until TempItemCategory.Next() = 0;        while TempStack.Pop(CurItemCategoryID) do begin            TempCurItemCategory.Get(CurItemCategoryID);            HasChildren := false;            TempItemCategory.SetRange("Parent Category", TempCurItemCategory.Code);            if TempItemCategory.FindSet(false) then                repeat                    TempStack.Push(TempItemCategory.RecordId());                    HasChildren := true;                until TempItemCategory.Next() = 0;            if TempCurItemCategory."Parent Category" <> '' then begin                TempItemCategory.Get(TempCurItemCategory."Parent Category");                Indentation := TempItemCategory.Indentation + 1;            end else                Indentation := 0;            PresentationOrder := PresentationOrder + 10000;            if (TempCurItemCategory."Presentation Order" <> PresentationOrder) or               (TempCurItemCategory.Indentation <> Indentation) or (TempCurItemCategory."Has Children" <> HasChildren)            then begin                ItemCategory.Get(TempCurItemCategory.Code);                ItemCategory.Validate("Presentation Order", PresentationOrder);                ItemCategory.Validate(Indentation, Indentation);                ItemCategory.Validate("Has Children", HasChildren);                ItemCategory.Modify();                TempItemCategory.Get(TempCurItemCategory.Code);                TempItemCategory.Validate("Presentation Order", PresentationOrder);                TempItemCategory.Validate(Indentation, Indentation);                TempItemCategory.Validate("Has Children", HasChildren);                TempItemCategory.Modify();            end;        end;    end;    procedure DoesValueExistInItemCategories(Text: Code[20]; var ItemCategory: Record "Item Category"): Boolean    begin        ItemCategory.Reset();        ItemCategory.SetFilter(Code, '@' + Text);        exit(ItemCategory.FindSet());    end;    procedure FindMatchInCategories(SearchTerm: Text; var ItemCategory: Record "Item Category"; ExactMatchOnly: Boolean): Boolean    var        FilterPattern: Text;    begin        SearchTerm := DelChr(SearchTerm, '=', '.&|<>=*@()?%#''');        if SearchTerm = '' then            exit(false);        if ExactMatchOnly then            FilterPattern := '@%1'        else            FilterPattern := '@*%1*';        ItemCategory.Reset();        ItemCategory.SetFilter(Code, StrSubstNo(FilterPattern, CopyStr(SearchTerm, 1, MaxStrLen(ItemCategory.Code))));        ItemCategory.SetCurrentKey(Indentation);        ItemCategory.SetAscending(Indentation, false);        if ItemCategory.FindFirst() then            exit(true);        ItemCategory.Reset();        ItemCategory.SetFilter(Description, StrSubstNo(FilterPattern, CopyStr(SearchTerm, 1, MaxStrLen(ItemCategory.Description))));        ItemCategory.SetCurrentKey(Indentation);        ItemCategory.SetAscending(Indentation, false);        if ItemCategory.FindFirst() then            exit(true);        exit(false);    end;    [Scope('OnPrem')]    procedure CalcPresentationOrder(var ItemCategory: Record "Item Category")    var        ItemCategorySearch: Record "Item Category";        ItemCategoryPrev: Record "Item Category";        ItemCategoryNext: Record "Item Category";        ItemCategoryPrevExists: Boolean;        ItemCategoryNextExists: Boolean;    begin        if ItemCategory.HasChildren() then begin            ItemCategory."Presentation Order" := 0;            exit;        end;        ItemCategoryPrev.SetRange("Parent Category", ItemCategory."Parent Category");        ItemCategoryPrev.SetFilter(Code, '<%1', ItemCategory.Code);        ItemCategoryPrevExists := ItemCategoryPrev.FindLast();        if not ItemCategoryPrevExists then            ItemCategoryPrevExists := ItemCategoryPrev.Get(ItemCategory."Parent Category")        else            ItemCategoryPrev.Get(GetLastChildCode(ItemCategoryPrev.Code));        ItemCategoryNext.SetRange("Parent Category", ItemCategory."Parent Category");        ItemCategoryNext.SetFilter(Code, '>%1', ItemCategory.Code);        ItemCategoryNextExists := ItemCategoryNext.FindFirst();        if not ItemCategoryNextExists and ItemCategoryPrevExists then begin            ItemCategoryNext.Reset();            ItemCategoryNext.SetCurrentKey("Presentation Order");            ItemCategoryNext.SetFilter(Code, '<>%1', ItemCategory.Code);            ItemCategoryNext.SetFilter("Presentation Order", '>%1', ItemCategoryPrev."Presentation Order");            ItemCategoryNextExists := ItemCategoryNext.FindFirst();        end;        case true of            not ItemCategoryPrevExists and not ItemCategoryNextExists:                ItemCategory."Presentation Order" := 10000;            not ItemCategoryPrevExists and ItemCategoryNextExists:                ItemCategory."Presentation Order" := ItemCategoryNext."Presentation Order" div 2;            ItemCategoryPrevExists and not ItemCategoryNextExists:                ItemCategory."Presentation Order" := ItemCategoryPrev."Presentation Order" + 10000;            ItemCategoryPrevExists and ItemCategoryNextExists:                ItemCategory."Presentation Order" := (ItemCategoryPrev."Presentation Order" + ItemCategoryNext."Presentation Order") div 2;        end;        ItemCategorySearch.SetRange("Presentation Order", ItemCategory."Presentation Order");        ItemCategorySearch.SetFilter(Code, '<>%1', ItemCategory.Code);        if not ItemCategorySearch.IsEmpty() then            ItemCategory."Presentation Order" := 0;    end;    [Scope('OnPrem')]    procedure CheckPresentationOrder()    var        ItemCategory: Record "Item Category";    begin        ItemCategory.SetRange("Presentation Order", 0);        if not ItemCategory.IsEmpty() then            UpdatePresentationOrder();    end;    local procedure GetLastChildCode(ParentCode: Code[20]) ChildCode: Code[20]    var        TempStack: Record TempStack temporary;        ItemCategory: Record "Item Category";        RecId: RecordID;    begin        ChildCode := ParentCode;        ItemCategory.Ascending(false);        ItemCategory.SetRange("Parent Category", ParentCode);        if ItemCategory.FindSet() then            repeat                TempStack.Push(ItemCategory.RecordId());            until ItemCategory.Next() = 0;        while TempStack.Pop(RecId) do begin            ItemCategory.Get(RecId);            ChildCode := ItemCategory.Code;            ItemCategory.SetRange("Parent Category", ItemCategory.Code);            if ItemCategory.FindSet() then                repeat                    TempStack.Push(ItemCategory.RecordId());                until ItemCategory.Next() = 0;        end;    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeUpdatePresentationOrderIterative(var TempItemCategory: Record "Item Category" temporary; var IsHandled: Boolean)    begin    end;}