Report 952 Suggest Job Jnl. Lines

Base Application, Microsoft.Projects.TimeSheet

src/Layers/W1/BaseApp/Projects/TimeSheet/SuggestJobJnlLines.Report.al281 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.Projects.TimeSheet;using Microsoft.Foundation.NoSeries;using Microsoft.Projects.Project.Job;using Microsoft.Projects.Project.Journal;using Microsoft.Projects.Project.Setup;using Microsoft.Projects.Resources.Resource;using Microsoft.Projects.Resources.Setup;report 952 "Suggest Job Jnl. Lines"{    Caption = 'Suggest Project Jnl. Lines';    ProcessingOnly = true;    dataset    {    }    requestpage    {        SaveValues = true;        layout        {            area(content)            {                group(Options)                {                    Caption = 'Options';                    field(StartingDate; StartingDate)                    {                        ApplicationArea = Jobs;                        Caption = 'Starting Date';                        ToolTip = 'Specifies the date from which the report or batch job processes information.';                    }                    field(EndingDate; EndingDate)                    {                        ApplicationArea = Jobs;                        Caption = 'Ending Date';                        ToolTip = 'Specifies the date to which the report or batch job processes information.';                    }                    field(ResourceNoFilter; ResourceNoFilter)                    {                        ApplicationArea = Jobs;                        Caption = 'Resource No. Filter';                        TableRelation = Resource;                        ToolTip = 'Specifies the resource number that the batch job will suggest project lines for.';                    }                    field(JobNoFilter; JobNoFilter)                    {                        ApplicationArea = Jobs;                        Caption = 'Project No. Filter';                        TableRelation = Job;                        ToolTip = 'Specifies a filter for the project numbers that will be included in the report.';                    }                    field(JobTaskNoFilter; JobTaskNoFilter)                    {                        ApplicationArea = Jobs;                        Caption = 'Project Task No. Filter';                        ToolTip = 'Specifies a filter for the project task numbers that will be included in the report.';                        trigger OnLookup(var Text: Text): Boolean                        var                            JobTask: Record "Job Task";                        begin                            JobTask.FilterGroup(2);                            if JobNoFilter <> '' then                                JobTask.SetFilter("Job No.", JobNoFilter);                            JobTask.FilterGroup(0);                            if PAGE.RunModal(PAGE::"Job Task List", JobTask) = ACTION::LookupOK then                                JobTask.TestField("Job Task Type", JobTask."Job Task Type"::Posting);                            JobTaskNoFilter := JobTask."Job Task No.";                        end;                    }                }            }        }        actions        {        }    }    labels    {    }    trigger OnPostReport()    var        JobsSetup: Record "Jobs Setup";        NoSeries: Codeunit "No. Series";        TimeSheetMgt: Codeunit "Time Sheet Management";        NextDocNo: Code[20];        LineNo: Integer;        QtyToPost: Decimal;    begin        DateFilter := TimeSheetMgt.GetDateFilter(StartingDate, EndingDate);        FillTimeSheetLineBuffer();        if TempTimeSheetLine.FindSet() then begin            JobJnlLine.LockTable();            JobJnlTemplate.Get(JobJnlLine."Journal Template Name");            JobJnlBatch.Get(JobJnlLine."Journal Template Name", JobJnlLine."Journal Batch Name");            JobsSetup.SetLoadFields("Document No. Is Job No.");            JobsSetup.Get();            if not JobsSetup."Document No. Is Job No." then                if JobJnlBatch."No. Series" = '' then                    NextDocNo := ''                else                    NextDocNo := NoSeries.PeekNextNo(JobJnlBatch."No. Series", TempTimeSheetLine."Time Sheet Starting Date");            JobJnlLine.SetRange("Journal Template Name", JobJnlLine."Journal Template Name");            JobJnlLine.SetRange("Journal Batch Name", JobJnlLine."Journal Batch Name");            if JobJnlLine.FindLast() then;            LineNo := JobJnlLine."Line No.";            repeat                TimeSheetHeader.Get(TempTimeSheetLine."Time Sheet No.");                TimeSheetDetail.SetRange("Time Sheet No.", TempTimeSheetLine."Time Sheet No.");                TimeSheetDetail.SetRange("Time Sheet Line No.", TempTimeSheetLine."Line No.");                if DateFilter <> '' then                    TimeSheetDetail.SetFilter(Date, DateFilter);                TimeSheetDetail.SetFilter(Quantity, '<>0');                TimeSheetDetail.SetRange(Posted, false);                if TimeSheetDetail.FindSet() then                    repeat                        QtyToPost := TimeSheetDetail.GetMaxQtyToPost();                        if QtyToPost <> 0 then begin                            JobJnlLine.Init();                            LineNo := LineNo + 10000;                            JobJnlLine."Line No." := LineNo;                            JobJnlLine."Time Sheet No." := TimeSheetDetail."Time Sheet No.";                            JobJnlLine."Time Sheet Line No." := TimeSheetDetail."Time Sheet Line No.";                            JobJnlLine."Time Sheet Date" := TimeSheetDetail.Date;                            JobJnlLine.Validate("Job No.", TimeSheetDetail."Job No.");                            JobJnlLine."Source Code" := JobJnlTemplate."Source Code";                            if TimeSheetDetail."Job Task No." <> '' then                                JobJnlLine.Validate("Job Task No.", TimeSheetDetail."Job Task No.");                            JobJnlLine.Validate(Type, JobJnlLine.Type::Resource);                            JobJnlLine.Validate("No.", TimeSheetHeader."Resource No.");                            if TempTimeSheetLine."Work Type Code" <> '' then                                JobJnlLine.Validate("Work Type Code", TempTimeSheetLine."Work Type Code");                            JobJnlLine.Validate("Posting Date", TimeSheetDetail.Date);                            if not JobsSetup."Document No. Is Job No." then begin                                JobJnlLine."Document No." := NextDocNo;                                NextDocNo := IncStr(NextDocNo);                            end;                            JobJnlLine."Posting No. Series" := JobJnlBatch."Posting No. Series";                            SetJobJournalLineDescription(TempTimeSheetLine.Description, TimeSheetDetail);                            JobJnlLine.Validate(Quantity, QtyToPost);                            JobJnlLine.Validate(Chargeable, TempTimeSheetLine.Chargeable);                            JobJnlLine."Reason Code" := JobJnlBatch."Reason Code";                            OnAfterTransferTimeSheetDetailToJobJnlLine(JobJnlLine, JobJnlTemplate, TempTimeSheetLine, TimeSheetDetail, JobJnlBatch, LineNo);                            JobJnlLine.Insert();                        end;                    until TimeSheetDetail.Next() = 0;                OnOnPostReportOnTempTimeSheetLineEndLoop(JobJnlLine, NextDocNo, LineNo);            until TempTimeSheetLine.Next() = 0;        end;    end;    var        JobJnlLine: Record "Job Journal Line";        JobJnlBatch: Record "Job Journal Batch";        JobJnlTemplate: Record "Job Journal Template";        TimeSheetHeader: Record "Time Sheet Header";        TimeSheetLine: Record "Time Sheet Line";        TempTimeSheetLine: Record "Time Sheet Line" temporary;        TimeSheetDetail: Record "Time Sheet Detail";        ResourceNoFilter: Code[1024];        JobNoFilter: Code[1024];        JobTaskNoFilter: Code[1024];        StartingDate: Date;        EndingDate: Date;        DateFilter: Text[30];    procedure SetJobJnlLine(NewJobJnlLine: Record "Job Journal Line")    begin        JobJnlLine := NewJobJnlLine;    end;    procedure InitParameters(NewJobJnlLine: Record "Job Journal Line"; NewResourceNoFilter: Code[1024]; NewJobNoFilter: Code[1024]; NewJobTaskNoFilter: Code[1024]; NewStartingDate: Date; NewEndingDate: Date)    begin        JobJnlLine := NewJobJnlLine;        ResourceNoFilter := NewResourceNoFilter;        JobNoFilter := NewJobNoFilter;        JobTaskNoFilter := NewJobTaskNoFilter;        StartingDate := NewStartingDate;        EndingDate := NewEndingDate;    end;    local procedure FillTimeSheetLineBuffer()    var        SkipLine: Boolean;    begin        if ResourceNoFilter <> '' then            TimeSheetHeader.SetFilter("Resource No.", ResourceNoFilter);        if DateFilter <> '' then begin            TimeSheetHeader.SetFilter("Starting Date", DateFilter);            TimeSheetHeader.SetFilter("Starting Date", '..%1', TimeSheetHeader.GetRangeMax("Starting Date"));            TimeSheetHeader.SetFilter("Ending Date", DateFilter);            TimeSheetHeader.SetFilter("Ending Date", '%1..', TimeSheetHeader.GetRangeMin("Ending Date"));        end;        OnFillTimeSheetLineBufferOnAfterFilterTimeSheetHeader(TimeSheetHeader);        if TimeSheetHeader.FindSet() then            repeat                TimeSheetLine.SetRange("Time Sheet No.", TimeSheetHeader."No.");                TimeSheetLine.SetRange(Type, TimeSheetLine.Type::Job);                TimeSheetLine.SetRange(Status, TimeSheetLine.Status::Approved);                if JobNoFilter <> '' then                    TimeSheetLine.SetFilter("Job No.", JobNoFilter);                if JobTaskNoFilter <> '' then                    TimeSheetLine.SetFilter("Job Task No.", JobTaskNoFilter);                TimeSheetLine.SetRange(Posted, false);                OnFillTimeSheetLineBufferOnAfterFilterTimeSheetLine(TimeSheetHeader, TimeSheetLine);                if TimeSheetLine.FindSet() then                    repeat                        TempTimeSheetLine := TimeSheetLine;                        OnBeforeInsertTempTimeSheetLine(JobJnlLine, TimeSheetHeader, TempTimeSheetLine, SkipLine);                        if not SkipLine then                            TempTimeSheetLine.Insert();                    until TimeSheetLine.Next() = 0;            until TimeSheetHeader.Next() = 0;    end;    local procedure SetJobJournalLineDescription(TimeSheetDescription: Text[100]; TimeSheetDetail: Record "Time Sheet Detail")    var        ResourcesSetup: Record "Resources Setup";        IsHandled: Boolean;        TimeSheetDescriptionWithDateTok: Label '%1, %2', Locked = true;    begin        OnBeforeSetJobJournalLineDescription(JobJnlLine, TimeSheetDescription, TimeSheetDetail, IsHandled);        if IsHandled then            exit;        ResourcesSetup.ReadIsolation(IsolationLevel::ReadCommitted);        ResourcesSetup.SetLoadFields("Incl. Time Sheet Date in Jnl.");        ResourcesSetup.Get();        if ResourcesSetup."Incl. Time Sheet Date in Jnl." then            JobJnlLine.Description := CopyStr(StrSubstNo(TimeSheetDescriptionWithDateTok, TimeSheetDetail.Date, TimeSheetDescription), 1, MaxStrLen(JobJnlLine.Description))        else            JobJnlLine.Description := CopyStr(TimeSheetDescription, 1, MaxStrLen(JobJnlLine.Description));    end;    [IntegrationEvent(false, false)]    local procedure OnFillTimeSheetLineBufferOnAfterFilterTimeSheetHeader(var TimeSheetHeader: Record "Time Sheet Header")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnFillTimeSheetLineBufferOnAfterFilterTimeSheetLine(TimeSheetHeader: Record "Time Sheet Header"; var TimeSheetLine: Record "Time Sheet Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeInsertTempTimeSheetLine(JobJournalLine: Record "Job Journal Line"; TimeSheetHeader: Record "Time Sheet Header"; var TempTimeSheetLine: Record "Time Sheet Line" temporary; var SkipLine: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterTransferTimeSheetDetailToJobJnlLine(var JobJournalLine: Record "Job Journal Line"; JobJournalTemplate: Record "Job Journal Template"; var TempTimeSheetLine: Record "Time Sheet Line" temporary; TimeSheetDetail: Record "Time Sheet Detail"; JobJournalBatch: Record "Job Journal Batch"; var LineNo: Integer)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnOnPostReportOnTempTimeSheetLineEndLoop(var JobJournalLine: Record "Job Journal Line"; var NextDocNo: Code[20]; var LineNo: Integer)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeSetJobJournalLineDescription(var JobJournalLine: Record "Job Journal Line"; TimeSheetDescription: Text[100]; TimeSheetDetail: Record "Time Sheet Detail"; var IsHandled: Boolean)    begin    end;}