Codeunit 1522 Workflow Request Page Handling

Base Application, System.Automation

src/Layers/W1/BaseApp/System/Workflow/WorkflowRequestPageHandling.Codeunit.al288 lines, Copyright (c) Microsoft Corporation. MIT

namespace System.Automation;using Microsoft.EServices.EDocument;using Microsoft.Finance.GeneralLedger.Journal;using Microsoft.FixedAssets.Journal;using Microsoft.Inventory.Item;using Microsoft.Inventory.Journal;using Microsoft.Inventory.Requisition;using Microsoft.Purchases.Document;using Microsoft.Purchases.Vendor;using Microsoft.Sales.Customer;using Microsoft.Sales.Document;codeunit 1522 "Workflow Request Page Handling"{    trigger OnRun()    begin    end;    var        PurchaseDocumentCodeTxt: Label 'PURCHDOC', Locked = true;        PurchaseDocumentDescTxt: Label 'Purchase Document';        SalesDocumentCodeTxt: Label 'SALESDOC', Locked = true;        SalesDocumentDescTxt: Label 'Sales Document';        IncomingDocumentCodeTxt: Label 'INCOMINGDOC', Locked = true;        IncomingDocumentDescTxt: Label 'Incoming Document';    procedure CreateEntitiesAndFields()    begin        InsertRequestPageEntities();        InsertRequestPageFields();    end;    procedure AssignEntitiesToWorkflowEvents()    begin        AssignEntityToWorkflowEvent(DATABASE::"Purchase Header", PurchaseDocumentCodeTxt);        AssignEntityToWorkflowEvent(DATABASE::"Sales Header", SalesDocumentCodeTxt);        AssignEntityToWorkflowEvent(DATABASE::"Incoming Document Attachment", IncomingDocumentCodeTxt);        AssignEntityToWorkflowEvent(DATABASE::"Incoming Document", IncomingDocumentCodeTxt);        OnAfterAssignEntitiesToWorkflowEvents();    end;    local procedure InsertRequestPageEntities()    begin        InsertReqPageEntity(          PurchaseDocumentCodeTxt, PurchaseDocumentDescTxt, DATABASE::"Purchase Header", DATABASE::"Purchase Line");        InsertReqPageEntity(          SalesDocumentCodeTxt, SalesDocumentDescTxt, DATABASE::"Sales Header", DATABASE::"Sales Line");        InsertReqPageEntity(          IncomingDocumentCodeTxt, IncomingDocumentDescTxt, DATABASE::"Incoming Document Attachment", DATABASE::"Incoming Document");        InsertReqPageEntity(          IncomingDocumentCodeTxt, IncomingDocumentDescTxt, DATABASE::"Incoming Document", DATABASE::"Incoming Document Attachment");        OnAfterInsertRequestPageEntities();    end;    procedure InsertReqPageEntity(Name: Code[20]; Description: Text[100]; TableId: Integer; RelatedTableId: Integer)    begin        if not FindReqPageEntity(Name, TableId, RelatedTableId) then            CreateReqPageEntity(Name, Description, TableId, RelatedTableId);    end;    local procedure FindReqPageEntity(Name: Code[20]; TableId: Integer; RelatedTableId: Integer): Boolean    var        DynamicRequestPageEntity: Record "Dynamic Request Page Entity";    begin        DynamicRequestPageEntity.SetRange(Name, Name);        DynamicRequestPageEntity.SetRange("Table ID", TableId);        DynamicRequestPageEntity.SetRange("Related Table ID", RelatedTableId);        exit(DynamicRequestPageEntity.FindFirst());    end;    local procedure CreateReqPageEntity(Name: Code[20]; Description: Text[100]; TableId: Integer; RelatedTableId: Integer)    var        DynamicRequestPageEntity: Record "Dynamic Request Page Entity";    begin        DynamicRequestPageEntity.Init();        DynamicRequestPageEntity.Name := Name;        DynamicRequestPageEntity.Description := Description;        DynamicRequestPageEntity.Validate("Table ID", TableId);        DynamicRequestPageEntity.Validate("Related Table ID", RelatedTableId);        DynamicRequestPageEntity.Insert(true);    end;    local procedure InsertRequestPageFields()    begin        InsertIncomingDocumentReqPageFields();        InsertPurchaseHeaderReqPageFields();        InsertPurchaseLineReqPageFields();        InsertSalesHeaderReqPageFields();        InsertSalesLineReqPageFields();        InsertCustomerReqPageFields();        InsertVendorReqPageFields();        InsertItemReqPageFields();        InsertGeneralJournalBatchReqPageFields();        InsertGeneralJournalLineReqPageFields();        InsertItemJournalBatchReqPageFields();        InsertRequisitionWkshBatchReqPageFields();        InsertFAJournalBatchReqPageFields();        InsertApprovalEntryReqPageFields();        OnAfterInsertRequestPageFields();    end;    local procedure InsertIncomingDocumentReqPageFields()    var        IncomingDocument: Record "Incoming Document";    begin        InsertDynReqPageField(DATABASE::"Incoming Document", IncomingDocument.FieldNo("Created By User ID"));        InsertDynReqPageField(DATABASE::"Incoming Document", IncomingDocument.FieldNo(Posted));        InsertDynReqPageField(DATABASE::"Incoming Document", IncomingDocument.FieldNo(Status));    end;    local procedure InsertPurchaseHeaderReqPageFields()    var        PurchaseHeader: Record "Purchase Header";    begin        InsertDynReqPageField(DATABASE::"Purchase Header", PurchaseHeader.FieldNo("Buy-from Vendor No."));        InsertDynReqPageField(DATABASE::"Purchase Header", PurchaseHeader.FieldNo("Payment Terms Code"));        InsertDynReqPageField(DATABASE::"Purchase Header", PurchaseHeader.FieldNo(Amount));        InsertDynReqPageField(DATABASE::"Purchase Header", PurchaseHeader.FieldNo("Currency Code"));    end;    local procedure InsertPurchaseLineReqPageFields()    var        PurchaseLine: Record "Purchase Line";    begin        InsertDynReqPageField(DATABASE::"Purchase Line", PurchaseLine.FieldNo(Type));        InsertDynReqPageField(DATABASE::"Purchase Line", PurchaseLine.FieldNo("No."));        InsertDynReqPageField(DATABASE::"Purchase Line", PurchaseLine.FieldNo(Quantity));        InsertDynReqPageField(DATABASE::"Purchase Line", PurchaseLine.FieldNo("Direct Unit Cost"));    end;    local procedure InsertSalesHeaderReqPageFields()    var        SalesHeader: Record "Sales Header";    begin        InsertDynReqPageField(DATABASE::"Sales Header", SalesHeader.FieldNo("Sell-to Customer No."));        InsertDynReqPageField(DATABASE::"Sales Header", SalesHeader.FieldNo("Payment Terms Code"));        InsertDynReqPageField(DATABASE::"Sales Header", SalesHeader.FieldNo(Amount));        InsertDynReqPageField(DATABASE::"Sales Header", SalesHeader.FieldNo("Currency Code"));    end;    local procedure InsertSalesLineReqPageFields()    var        SalesLine: Record "Sales Line";    begin        InsertDynReqPageField(DATABASE::"Sales Line", SalesLine.FieldNo(Type));        InsertDynReqPageField(DATABASE::"Sales Line", SalesLine.FieldNo("No."));        InsertDynReqPageField(DATABASE::"Sales Line", SalesLine.FieldNo(Quantity));        InsertDynReqPageField(DATABASE::"Sales Line", SalesLine.FieldNo("Unit Cost"));    end;    local procedure InsertCustomerReqPageFields()    var        Customer: Record Customer;    begin        InsertDynReqPageField(DATABASE::Customer, Customer.FieldNo("No."));        InsertDynReqPageField(DATABASE::Customer, Customer.FieldNo(Blocked));        InsertDynReqPageField(DATABASE::Customer, Customer.FieldNo("Credit Limit (LCY)"));        InsertDynReqPageField(DATABASE::Customer, Customer.FieldNo("Payment Method Code"));        InsertDynReqPageField(DATABASE::Customer, Customer.FieldNo("Gen. Bus. Posting Group"));        InsertDynReqPageField(DATABASE::Customer, Customer.FieldNo("Customer Posting Group"));    end;    local procedure InsertItemReqPageFields()    var        Item: Record Item;    begin        InsertDynReqPageField(DATABASE::Item, Item.FieldNo("No."));        InsertDynReqPageField(DATABASE::Item, Item.FieldNo("Item Category Code"));        InsertDynReqPageField(DATABASE::Item, Item.FieldNo("Unit Price"));    end;    local procedure InsertGeneralJournalBatchReqPageFields()    var        GenJournalBatch: Record "Gen. Journal Batch";    begin        InsertDynReqPageField(DATABASE::"Gen. Journal Batch", GenJournalBatch.FieldNo(Name));        InsertDynReqPageField(DATABASE::"Gen. Journal Batch", GenJournalBatch.FieldNo("Template Type"));        InsertDynReqPageField(DATABASE::"Gen. Journal Batch", GenJournalBatch.FieldNo(Recurring));    end;    local procedure InsertGeneralJournalLineReqPageFields()    var        GenJournalLine: Record "Gen. Journal Line";    begin        InsertDynReqPageField(DATABASE::"Gen. Journal Line", GenJournalLine.FieldNo("Document Type"));        InsertDynReqPageField(DATABASE::"Gen. Journal Line", GenJournalLine.FieldNo("Account Type"));        InsertDynReqPageField(DATABASE::"Gen. Journal Line", GenJournalLine.FieldNo("Account No."));        InsertDynReqPageField(DATABASE::"Gen. Journal Line", GenJournalLine.FieldNo(Amount));    end;    local procedure InsertItemJournalBatchReqPageFields()    var        ItemJournalBatch: Record "Item Journal Batch";    begin        InsertDynReqPageField(Database::"Item Journal Batch", ItemJournalBatch.FieldNo(Name));        InsertDynReqPageField(Database::"Item Journal Batch", ItemJournalBatch.FieldNo("Template Type"));        InsertDynReqPageField(Database::"Item Journal Batch", ItemJournalBatch.FieldNo(Recurring));    end;    local procedure InsertRequisitionWkshBatchReqPageFields()    var        RequisitionWkshName: Record "Requisition Wksh. Name";    begin        InsertDynReqPageField(Database::"Requisition Wksh. Name", RequisitionWkshName.FieldNo(Name));        InsertDynReqPageField(Database::"Requisition Wksh. Name", RequisitionWkshName.FieldNo("Template Type"));        InsertDynReqPageField(Database::"Requisition Wksh. Name", RequisitionWkshName.FieldNo(Recurring));    end;    local procedure InsertFAJournalBatchReqPageFields()    var        FAJournalBatch: Record "FA Journal Batch";    begin        InsertDynReqPageField(Database::"FA Journal Batch", FAJournalBatch.FieldNo(Name));        InsertDynReqPageField(Database::"FA Journal Batch", FAJournalBatch.FieldNo(Recurring));    end;    local procedure InsertApprovalEntryReqPageFields()    var        ApprovalEntry: Record "Approval Entry";    begin        InsertDynReqPageField(DATABASE::"Approval Entry", ApprovalEntry.FieldNo("Pending Approvals"));    end;    procedure InsertDynReqPageField(TableId: Integer; FieldId: Integer)    var        DynamicRequestPageField: Record "Dynamic Request Page Field";    begin        if not DynamicRequestPageField.Get(TableId, FieldId) then            CreateReqPageField(TableId, FieldId);    end;    local procedure CreateReqPageField(TableId: Integer; FieldId: Integer)    var        DynamicRequestPageField: Record "Dynamic Request Page Field";    begin        DynamicRequestPageField.Init();        DynamicRequestPageField.Validate("Table ID", TableId);        DynamicRequestPageField.Validate("Field ID", FieldId);        DynamicRequestPageField.Insert();    end;    procedure AssignEntityToWorkflowEvent(TableID: Integer; DynamicReqPageEntityName: Code[20])    var        WorkflowEvent: Record "Workflow Event";    begin        WorkflowEvent.SetRange("Table ID", TableID);        WorkflowEvent.SetFilter("Dynamic Req. Page Entity Name", '<>%1', DynamicReqPageEntityName);        if not WorkflowEvent.IsEmpty() then            WorkflowEvent.ModifyAll("Dynamic Req. Page Entity Name", DynamicReqPageEntityName);    end;    local procedure InsertVendorReqPageFields()    var        Vendor: Record Vendor;    begin        InsertDynReqPageField(DATABASE::Vendor, Vendor.FieldNo("No."));    end;    [IntegrationEvent(false, false)]    local procedure OnAfterAssignEntitiesToWorkflowEvents()    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterInsertRequestPageEntities()    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterInsertRequestPageFields()    begin    end;}