Page 5734 Item Category Attributes

Base Application, Microsoft.Inventory.Item.Attribute

src/Layers/W1/BaseApp/Inventory/Item/Attribute/ItemCategoryAttributes.Page.al426 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.Attribute;using Microsoft.Inventory.Item;page 5734 "Item Category Attributes"{    Caption = 'Item Category Attributes';    LinksAllowed = false;    PageType = ListPart;    RefreshOnActivate = true;    SourceTable = "Item Attribute Value Selection";    SourceTableTemporary = true;    SourceTableView = sorting("Inheritance Level", "Attribute Name")                      order(ascending);    layout    {        area(content)        {            repeater(Control1)            {                Enabled = RowEditable;                ShowCaption = false;                field("Attribute Name"; Rec."Attribute Name")                {                    ApplicationArea = Basic, Suite;                    AssistEdit = false;                    Caption = 'Attribute';                    StyleExpr = StyleTxt;                    TableRelation = "Item Attribute".Name where(Blocked = const(false));                    trigger OnValidate()                    begin                        PersistInheritanceData();                    end;                }                field(Value; Rec.Value)                {                    ApplicationArea = Basic, Suite;                    Caption = 'Default Value';                    StyleExpr = StyleTxt;                    TableRelation = if ("Attribute Type" = const(Option)) "Item Attribute Value".Value where("Attribute ID" = field("Attribute ID"),                                                                                                            Blocked = const(false));                    trigger OnValidate()                    begin                        PersistInheritanceData();                        ChangeDefaultValue();                        if (Rec.Value <> '') and not HasBlankOptionAttributes() then                            ClearBlankOptionAttributeNotification();                    end;                }                field("Unit of Measure"; Rec."Unit of Measure")                {                    ApplicationArea = Basic, Suite;                    StyleExpr = StyleTxt;                }                field("Inherited-From Key Value"; Rec."Inherited-From Key Value")                {                    ApplicationArea = Basic, Suite;                    Caption = 'Inherited From';                    Editable = false;                    StyleExpr = StyleTxt;                }            }        }    }    actions    {    }    trigger OnAfterGetCurrRecord()    begin        UpdateProperties();    end;    trigger OnAfterGetRecord()    begin        UpdateProperties();    end;    trigger OnClosePage()    begin        TempRecentlyItemAttributeValueMapping.DeleteAll();    end;    trigger OnDeleteRecord(): Boolean    var        TempItemAttributeValueToDelete: Record "Item Attribute Value" temporary;        ItemAttributeValue: Record "Item Attribute Value";        ItemAttributeValueMapping: Record "Item Attribute Value Mapping";        ItemAttributeManagement: Codeunit "Item Attribute Management";    begin        if Rec."Inherited-From Key Value" <> '' then            Error(DeleteInheritedAttribErr);        ItemAttributeValueMapping.SetRange("Table ID", DATABASE::"Item Category");        ItemAttributeValueMapping.SetRange("No.", ItemCategoryCode);        ItemAttributeValueMapping.SetRange("Item Attribute ID", Rec."Attribute ID");        if ItemAttributeValueMapping.FindFirst() then begin            if ItemAttributeManagement.SearchCategoryItemsForAttribute(ItemCategoryCode, Rec."Attribute ID") then                if Confirm(StrSubstNo(DeleteItemInheritedParentCategoryAttributesQst, ItemCategoryCode, ItemCategoryCode)) then begin                    ItemAttributeValue.SetRange("Attribute ID", Rec."Attribute ID");                    ItemAttributeValue.SetRange(ID, ItemAttributeValueMapping."Item Attribute Value ID");                    if ItemAttributeValue.FindFirst() then begin                        TempItemAttributeValueToDelete.TransferFields(ItemAttributeValue);                        TempItemAttributeValueToDelete.Insert();                        DeleteRecentlyItemAttributeValueMapping(Rec."Attribute ID");                        ItemAttributeManagement.DeleteCategoryItemsAttributeValueMapping(TempItemAttributeValueToDelete, ItemCategoryCode);                    end;                end;            ItemAttributeValueMapping.Delete();        end else            DeleteRecentlyItemAttributeValueMapping(Rec."Attribute ID");    end;    trigger OnInsertRecord(BelowxRec: Boolean): Boolean    var        ItemAttribute: Record "Item Attribute";        TempItemAttributeValueToInsert: Record "Item Attribute Value" temporary;        ItemAttributeValueMapping: Record "Item Attribute Value Mapping";        ItemAttributeManagement: Codeunit "Item Attribute Management";    begin        if ItemCategoryCode <> '' then begin            ItemAttribute.Get(Rec."Attribute ID");            if (ItemAttribute.Type = ItemAttribute.Type::Option) and (Rec.Value = '') then begin                ShowBlankOptionAttributeNotification(Rec."Attribute Name");                exit(true);            end;            ItemAttributeValueMapping."Table ID" := DATABASE::"Item Category";            ItemAttributeValueMapping."No." := ItemCategoryCode;            ItemAttributeValueMapping."Item Attribute ID" := Rec."Attribute ID";            ItemAttributeValueMapping."Item Attribute Value ID" := Rec.GetAttributeValueID(TempItemAttributeValueToInsert);            OnInsertRecordOnBeforeItemAttributeValueMappingInsert(ItemAttributeValueMapping, TempItemAttributeValueToInsert, Rec);            ItemAttributeValueMapping.Insert();            ItemAttributeManagement.InsertCategoryItemsBufferedAttributeValueMapping(              TempItemAttributeValueToInsert, TempRecentlyItemAttributeValueMapping, ItemCategoryCode);            InsertRecentlyAddedCategoryAttribute(ItemAttributeValueMapping);        end;    end;    trigger OnQueryClosePage(CloseAction: Action): Boolean    begin        if HasBlankOptionAttributes() then begin            Message(OptionTypeMsg);            if Rec."Inherited-From Key Value" = '' then                exit(false);        end;        exit(true);    end;    var        ItemCategoryCode: Code[20];        DeleteInheritedAttribErr: Label 'You cannot delete attributes that are inherited from a parent item category.';        RowEditable: Boolean;        StyleTxt: Text;        ChangingDefaultValueMsg: Label 'The new default value will not apply to items that use the current item category, ''''%1''''. It will only apply to new items.', Comment = '%1 - item category code';        DeleteItemInheritedParentCategoryAttributesQst: 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,%2 - item category code';        BlankOptionAttributeNotificationMsg: Label 'You must enter a value for the Option attribute %1. Blank values are not allowed for Option-type attributes.', Comment = '%1 - attribute name';        OptionTypeMsg: Label 'You must enter a value for all Option-type attributes before closing this page.';    protected var        TempRecentlyItemAttributeValueMapping: Record "Item Attribute Value Mapping" temporary;    procedure LoadAttributes(CategoryCode: Code[20])    var        TempItemAttributeValue: Record "Item Attribute Value" temporary;        ItemAttributeValue: Record "Item Attribute Value";        ItemAttributeValueMapping: Record "Item Attribute Value Mapping";        ItemCategory: Record "Item Category";        CurrentCategoryCode: Code[20];    begin        Rec.Reset();        Rec.DeleteAll();        if CategoryCode = '' then            exit;        SortByInheritance();        ItemAttributeValueMapping.SetRange("Table ID", DATABASE::"Item Category");        SetItemCategoryCode(CategoryCode);        CurrentCategoryCode := CategoryCode;        repeat            if ItemCategory.Get(CurrentCategoryCode) then begin                ItemAttributeValueMapping.SetRange("No.", CurrentCategoryCode);                if ItemAttributeValueMapping.FindSet() then                    repeat                        if ItemAttributeValue.Get(                             ItemAttributeValueMapping."Item Attribute ID", ItemAttributeValueMapping."Item Attribute Value ID")                        then begin                            TempItemAttributeValue.TransferFields(ItemAttributeValue);                            OnLoadAttributesOnBeforeTempItemAttributeValueInsert(ItemAttributeValueMapping, TempItemAttributeValue);                            if TempItemAttributeValue.Insert() then                                if not AttributeExists(TempItemAttributeValue."Attribute ID") then begin                                    if CurrentCategoryCode = ItemCategoryCode then                                        Rec.InsertRecord(TempItemAttributeValue, DATABASE::"Item Category", '')                                    else                                        Rec.InsertRecord(TempItemAttributeValue, DATABASE::"Item Category", CurrentCategoryCode);                                    Rec."Inheritance Level" := ItemCategory.Indentation;                                    Rec.Modify();                                end;                        end                    until ItemAttributeValueMapping.Next() = 0;                CurrentCategoryCode := ItemCategory."Parent Category";            end else                CurrentCategoryCode := '';        until CurrentCategoryCode = '';        Rec.Reset();        CurrPage.Update(false);        SortByInheritance();    end;    procedure SaveAttributes(CategoryCode: Code[20])    var        TempNewItemAttributeValue: Record "Item Attribute Value" temporary;        ItemAttributeValueMapping: Record "Item Attribute Value Mapping";        ItemAttribute: Record "Item Attribute";        TempNewCategItemAttributeValue: Record "Item Attribute Value" temporary;        TempOldCategItemAttributeValue: Record "Item Attribute Value" temporary;        ItemAttributeManagement: Codeunit "Item Attribute Management";    begin        if CategoryCode = '' then            exit;        TempOldCategItemAttributeValue.LoadCategoryAttributesFactBoxData(CategoryCode);        Rec.SetRange("Inherited-From Table ID", DATABASE::"Item Category");        Rec.SetRange("Inherited-From Key Value", '');        Rec.PopulateItemAttributeValue(TempNewItemAttributeValue);        ItemAttributeValueMapping.SetRange("Table ID", DATABASE::"Item Category");        ItemAttributeValueMapping.SetRange("No.", CategoryCode);        ItemAttributeValueMapping.DeleteAll();        if TempNewItemAttributeValue.FindSet() then            repeat                ItemAttributeValueMapping."Table ID" := DATABASE::"Item Category";                ItemAttributeValueMapping."No." := CategoryCode;                ItemAttributeValueMapping."Item Attribute ID" := TempNewItemAttributeValue."Attribute ID";                ItemAttributeValueMapping."Item Attribute Value ID" := TempNewItemAttributeValue.ID;                OnSaveAttributesOnBeforeItemAttributeValueMappingInsert(ItemAttributeValueMapping, TempNewItemAttributeValue);                ItemAttributeValueMapping.Insert();                ItemAttribute.Get(ItemAttributeValueMapping."Item Attribute ID");                ItemAttribute.RemoveUnusedArbitraryValues();            until TempNewItemAttributeValue.Next() = 0;        TempNewCategItemAttributeValue.LoadCategoryAttributesFactBoxData(CategoryCode);        ItemAttributeManagement.UpdateCategoryItemsAttributeValueMapping(          TempNewCategItemAttributeValue, TempOldCategItemAttributeValue, ItemCategoryCode, ItemCategoryCode);    end;    local procedure PersistInheritanceData()    begin        Rec."Inherited-From Table ID" := DATABASE::"Item Category";        CurrPage.SaveRecord();    end;    procedure SetItemCategoryCode(CategoryCode: Code[20])    begin        if ItemCategoryCode <> CategoryCode then begin            ItemCategoryCode := CategoryCode;            TempRecentlyItemAttributeValueMapping.DeleteAll();        end;    end;    procedure SortByInheritance()    begin        Rec.SetCurrentKey("Inheritance Level", "Attribute Name");    end;    local procedure UpdateProperties()    begin        RowEditable := Rec."Inherited-From Key Value" = '';        if RowEditable then            StyleTxt := 'Standard'        else            StyleTxt := 'Strong';    end;    local procedure AttributeExists(AttributeID: Integer) AttribExist: Boolean    begin        Rec.SetRange("Attribute ID", AttributeID);        AttribExist := not Rec.IsEmpty();        Rec.Reset();    end;    local procedure ChangeDefaultValue()    var        ItemAttributeValueMapping: Record "Item Attribute Value Mapping";        TempItemAttributeValueToInsert: Record "Item Attribute Value" temporary;        ItemAttributeManagement: Codeunit "Item Attribute Management";        AttributeValueID: Integer;    begin        ItemAttributeValueMapping.SetRange("Table ID", DATABASE::"Item Category");        ItemAttributeValueMapping.SetRange("No.", ItemCategoryCode);        ItemAttributeValueMapping.SetRange("Item Attribute ID", Rec."Attribute ID");        AttributeValueID := Rec.GetAttributeValueID(TempItemAttributeValueToInsert);        if ItemAttributeValueMapping.FindFirst() then begin            ItemAttributeValueMapping."Item Attribute Value ID" := AttributeValueID;            ItemAttributeValueMapping.Modify();        end else            if AttributeValueID > 0 then                InsertItemAttributeValueMapping(ItemCategoryCode, Rec."Attribute ID", AttributeValueID);        if IsRecentlyAddedCategoryAttribute(Rec."Attribute ID") then            UpdateRecentlyItemAttributeValueMapping(TempItemAttributeValueToInsert)        else            if ItemAttributeManagement.SearchCategoryItemsForAttribute(ItemCategoryCode, Rec."Attribute ID") then                Message(StrSubstNo(ChangingDefaultValueMsg, ItemCategoryCode));    end;    local procedure InsertRecentlyAddedCategoryAttribute(ItemAttributeValueMapping: Record "Item Attribute Value Mapping")    begin        TempRecentlyItemAttributeValueMapping.TransferFields(ItemAttributeValueMapping);        if TempRecentlyItemAttributeValueMapping.Insert() then;    end;    local procedure IsRecentlyAddedCategoryAttribute(AttributeID: Integer): Boolean    begin        TempRecentlyItemAttributeValueMapping.SetRange("Item Attribute ID", AttributeID);        exit(not TempRecentlyItemAttributeValueMapping.IsEmpty)    end;    local procedure UpdateRecentlyItemAttributeValueMapping(var TempItemAttributeValueToInsert: Record "Item Attribute Value" temporary)    var        ItemAttributeValueMapping: Record "Item Attribute Value Mapping";    begin        TempRecentlyItemAttributeValueMapping.SetRange("Item Attribute ID", TempItemAttributeValueToInsert."Attribute ID");        if TempRecentlyItemAttributeValueMapping.FindSet() then            repeat                ItemAttributeValueMapping.SetRange("Table ID", TempRecentlyItemAttributeValueMapping."Table ID");                ItemAttributeValueMapping.SetRange("No.", TempRecentlyItemAttributeValueMapping."No.");                ItemAttributeValueMapping.SetRange("Item Attribute ID", TempRecentlyItemAttributeValueMapping."Item Attribute ID");                ItemAttributeValueMapping.FindFirst();                ItemAttributeValueMapping.Validate("Item Attribute Value ID", TempItemAttributeValueToInsert.ID);                ItemAttributeValueMapping.Modify();            until TempRecentlyItemAttributeValueMapping.Next() = 0;    end;    local procedure DeleteRecentlyItemAttributeValueMapping(AttributeID: Integer)    begin        TempRecentlyItemAttributeValueMapping.SetRange("Item Attribute ID", AttributeID);        TempRecentlyItemAttributeValueMapping.DeleteAll();        ClearBlankOptionAttributeNotification();    end;    procedure GetItemCategoryCode(): Code[20];    begin        exit(ItemCategoryCode);    end;    local procedure ShowBlankOptionAttributeNotification(AttributeName: Text[250])    var        BlankOptionNotification: Notification;    begin        BlankOptionNotification.Id := GetBlankOptionAttributeNotificationID();        BlankOptionNotification.Message := StrSubstNo(BlankOptionAttributeNotificationMsg, AttributeName);        BlankOptionNotification.Scope := NotificationScope::LocalScope;        BlankOptionNotification.Send();    end;    local procedure ClearBlankOptionAttributeNotification()    var        BlankOptionNotification: Notification;    begin        BlankOptionNotification.Id := GetBlankOptionAttributeNotificationID();        BlankOptionNotification.Recall();    end;    local procedure HasBlankOptionAttributes(): Boolean    var        ItemAttribute: Record "Item Attribute";    begin        if Rec.FindSet() then            repeat                if Rec.Value = '' then begin                    ItemAttribute.SetLoadFields("Type");                    ItemAttribute.Get(Rec."Attribute ID");                    if ItemAttribute.Type = ItemAttribute.Type::Option then                        exit(true);                end;            until Rec.Next() = 0;        exit(false);    end;    local procedure InsertItemAttributeValueMapping(ItemCategory: Code[20]; AttributeID: Integer; AttributeValueID: Integer)    var        ItemAttributeValueMapping: Record "Item Attribute Value Mapping";    begin        ItemAttributeValueMapping.Init();        ItemAttributeValueMapping."Table ID" := DATABASE::"Item Category";        ItemAttributeValueMapping."No." := ItemCategory;        ItemAttributeValueMapping."Item Attribute ID" := AttributeID;        ItemAttributeValueMapping."Item Attribute Value ID" := AttributeValueID;        ItemAttributeValueMapping.Insert();        InsertRecentlyAddedCategoryAttribute(ItemAttributeValueMapping);    end;    procedure GetBlankOptionAttributeNotificationID(): Guid    begin        exit('1ab28806-432f-46cc-844e-85b0fc36f883');    end;    [IntegrationEvent(false, false)]    local procedure OnInsertRecordOnBeforeItemAttributeValueMappingInsert(var ItemAttributeValueMapping: Record "Item Attribute Value Mapping"; var ItemAttributeValue: Record "Item Attribute Value"; ItemAttributeValueSelection: Record "Item Attribute Value Selection")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnLoadAttributesOnBeforeTempItemAttributeValueInsert(ItemAttributeValueMapping: Record "Item Attribute Value Mapping"; var TempItemAttributeValue: Record "Item Attribute Value" temporary)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnSaveAttributesOnBeforeItemAttributeValueMappingInsert(var ItemAttributeValueMapping: Record "Item Attribute Value Mapping"; ItemAttributeValue: Record "Item Attribute Value")    begin    end;}