Table 5722 Item Category

Base Application, Microsoft.Inventory.Item

src/Layers/W1/BaseApp/Inventory/Item/ItemCategory.Table.al202 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 Microsoft.Inventory.Item.Attribute;table 5722 "Item Category"{    Caption = 'Item Category';    LookupPageID = "Item Categories";    DataClassification = CustomerContent;    fields    {        field(1; "Code"; Code[20])        {            Caption = 'Code';            ToolTip = 'Specifies the item category.';            NotBlank = true;        }        field(2; "Parent Category"; Code[20])        {            Caption = 'Parent Category';            ToolTip = 'Specifies the item category that this item category belongs to. Item attributes that are assigned to a parent item category also apply to the child item category.';            TableRelation = "Item Category";            trigger OnValidate()            var                ItemCategory: Record "Item Category";                ItemAttributeManagement: Codeunit "Item Attribute Management";                ParentCategory: Code[20];            begin                ParentCategory := "Parent Category";                while ItemCategory.Get(ParentCategory) do begin                    if ItemCategory.Code = Code then                        Error(CyclicInheritanceErr);                    ParentCategory := ItemCategory."Parent Category";                end;                if "Parent Category" <> xRec."Parent Category" then                    ItemAttributeManagement.UpdateCategoryAttributesAfterChangingParentCategory(Code, "Parent Category", xRec."Parent Category");            end;        }        field(3; Description; Text[100])        {            Caption = 'Description';            ToolTip = 'Specifies a description of the item category.';        }        field(9; Indentation; Integer)        {            Caption = 'Indentation';            MinValue = 0;        }        field(10; "Presentation Order"; Integer)        {            Caption = 'Presentation Order';        }        field(11; "Has Children"; Boolean)        {            Caption = 'Has Children';        }        field(12; "Last Modified Date Time"; DateTime)        {            Caption = 'Last Modified Date Time';            Editable = false;        }    }    keys    {        key(Key1; "Code")        {            Clustered = true;        }        key(Key2; "Parent Category")        {        }        key(Key3; "Presentation Order")        {        }        key(Key4; Indentation, Code, Description)        {        }    }    fieldgroups    {    }    trigger OnDelete()    begin        if HasChildren() then            Error(DeleteWithChildrenErr);        UpdateDeletedCategoryItems();        DeleteAssignedAttributes();    end;    trigger OnInsert()    begin        TestField(Code);        UpdateIndentation();        ItemCategoryManagement.CalcPresentationOrder(Rec);        "Last Modified Date Time" := CurrentDateTime;    end;    trigger OnModify()    begin        UpdateIndentation();        ItemCategoryManagement.CalcPresentationOrder(Rec);        "Last Modified Date Time" := CurrentDateTime;    end;    trigger OnRename()    begin        "Presentation Order" := 0;        "Last Modified Date Time" := CurrentDateTime;    end;    var        ItemCategoryManagement: Codeunit "Item Category Management";        CyclicInheritanceErr: Label 'An item category cannot be a parent of itself or any of its children.';        DeleteWithChildrenErr: Label 'You cannot delete this item category because it has child item categories.';        DeleteItemInheritedAttributesQst: Label 'One or more items belong to item category ''''%1''''.\\Do you want to delete the inherited item attributes for the items in question? ', Comment = '%1 - item category code';    procedure HasChildren(): Boolean    var        ItemCategory: Record "Item Category";    begin        ItemCategory.SetRange("Parent Category", Code);        exit(not ItemCategory.IsEmpty)    end;    procedure GetStyleText(): Text    begin        if Indentation = 0 then            exit('Strong');        if HasChildren() then            exit('Strong');        exit('');    end;    local procedure UpdateDeletedCategoryItems()    var        CategoryItem: Record Item;        TempCategoryItemAttributeValue: Record "Item Attribute Value" temporary;        ItemAttributeManagement: Codeunit "Item Attribute Management";        DeleteItemInheritedAttributes: Boolean;    begin        CategoryItem.SetRange("Item Category Code", Code);        if CategoryItem.IsEmpty() then            exit;        DeleteItemInheritedAttributes := Confirm(StrSubstNo(DeleteItemInheritedAttributesQst, Code));        if DeleteItemInheritedAttributes then            TempCategoryItemAttributeValue.LoadCategoryAttributesFactBoxData(Code);        if CategoryItem.Find('-') then            repeat                CategoryItem.Validate("Item Category Code", '');                CategoryItem.Modify();                if DeleteItemInheritedAttributes then                    ItemAttributeManagement.DeleteItemAttributeValueMapping(CategoryItem, TempCategoryItemAttributeValue);            until CategoryItem.Next() = 0;    end;    local procedure DeleteAssignedAttributes()    var        ItemAttributeValueMapping: Record "Item Attribute Value Mapping";    begin        ItemAttributeValueMapping.SetRange("Table ID", DATABASE::"Item Category");        ItemAttributeValueMapping.SetRange("No.", Code);        ItemAttributeValueMapping.DeleteAll();    end;    local procedure UpdateIndentation()    var        ParentItemCategory: Record "Item Category";    begin        if ParentItemCategory.Get("Parent Category") then            UpdateIndentationTree(ParentItemCategory.Indentation + 1)        else            UpdateIndentationTree(0);    end;    [Scope('OnPrem')]    procedure UpdateIndentationTree(Level: Integer)    var        ItemCategory: Record "Item Category";    begin        Indentation := Level;        ItemCategory.SetRange("Parent Category", Code);        if ItemCategory.FindSet() then            repeat                ItemCategory.UpdateIndentationTree(Level + 1);                ItemCategory.Modify();            until ItemCategory.Next() = 0;    end;}