Report 950 Create Time Sheets

Base Application, Microsoft.Projects.TimeSheet

src/Layers/W1/BaseApp/Projects/TimeSheet/CreateTimeSheets.Report.al302 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.Foundation.Period;using Microsoft.Projects.Resources.Resource;using Microsoft.Projects.Resources.Setup;using System.Security.User;using System.Utilities;report 950 "Create Time Sheets"{    ApplicationArea = Basic, Suite;    Caption = 'Create Time Sheets';    ToolTip = 'Create new time sheets for resources.';    ProcessingOnly = true;    UsageCategory = Tasks;    dataset    {        dataitem("Integer"; "Integer")        {            DataItemTableView = sorting(Number);            dataitem(Resource; Resource)            {                DataItemTableView = where("Use Time Sheet" = const(true));                RequestFilterFields = "No.", Type;                trigger OnAfterGetRecord()                var                    TimeSheetMgt: Codeunit "Time Sheet Management";                    NoSeries: Codeunit "No. Series";                    IsHandled: Boolean;                begin                    IsHandled := false;                    OnBeforeResourceOnAfterGerRecord(Resource, IsHandled, StartingDate, EndingDate);                    if IsHandled then                        CurrReport.Skip();                    if CheckExistingPeriods() then begin                        TimeSheetHeader.Init();                        TimeSheetHeader."No." := NoSeries.GetNextNo(ResourcesSetup."Time Sheet Nos.", Today());                        TimeSheetHeader."Starting Date" := StartingDate;                        TimeSheetHeader."Ending Date" := EndingDate;                        TimeSheetHeader.Validate("Resource No.", "No.");                        TimeSheetHeader.Description := StrSubstNo(DescriptionTxt, GetWeekNumber(StartingDate));                        OnResourceOnAfterGerRecordOnBeforeTimeSheetHeaderInsert(TimeSheetHeader, Resource);                        TimeSheetHeader.Insert(true);                        TimeSheetCounter += 1;                        if CreateLinesFromJobPlanning then                            TimeSheetMgt.CreateLinesFromJobPlanning(TimeSheetHeader);                        OnResourceOnAfterGerRecordOnAfterTimeSheetHeaderInserted(TimeSheetHeader, Resource);                    end;                end;                trigger OnPostDataItem()                begin                    StartingDate := CalcDate('<1W>', StartingDate);                end;                trigger OnPreDataItem()                begin                    if HidResourceFilter <> '' then                        SetFilter("No.", HidResourceFilter);                end;            }            trigger OnAfterGetRecord()            begin                EndingDate := CalcDate('<1W>', StartingDate) - 1;            end;            trigger OnPreDataItem()            begin                SetRange(Number, 1, NoOfPeriods);            end;        }    }    requestpage    {        SaveValues = true;        layout        {            area(content)            {                group(Options)                {                    Caption = 'Options';                    field(StartingDate; StartingDate)                    {                        ApplicationArea = Jobs;                        Caption = 'Starting Date';                        ToolTip = 'Specifies the first date of the time sheet.';                        trigger OnValidate()                        begin                            ValidateStartingDate();                        end;                    }                    field(NoOfPeriods; NoOfPeriods)                    {                        ApplicationArea = Jobs;                        Caption = 'No. of Weeks';                        MinValue = 1;                        ToolTip = 'Specifies the number of weeks that the time sheet covers, such as 1 or 4.';                    }                    field(CreateLinesFromJobPlanning; CreateLinesFromJobPlanning)                    {                        ApplicationArea = Jobs;                        Caption = 'Create Lines From Project Planning';                        ToolTip = 'Specifies if you want to create time sheet lines that are based on project planning lines.';                    }                }            }        }        actions        {        }        trigger OnOpenPage()        var            TimeSheetMgt: Codeunit "Time Sheet Management";        begin            if NoOfPeriods = 0 then                NoOfPeriods := 1;            if TimeSheetHeader.FindLast() then                StartingDate := TimeSheetHeader."Ending Date" + 1            else                StartingDate := TimeSheetMgt.FindNearestTimeSheetStartDate(WorkDate());        end;    }    labels    {    }    trigger OnInitReport()    begin        ResourcesSetup.Get();    end;    trigger OnPostReport()    begin        if not HideDialog then            Message(Text003, TimeSheetCounter);    end;    trigger OnPreReport()    var        i: Integer;        LastDate: Date;        FirstAccPeriodStartingDate: Date;        LastAccPeriodStartingDate: Date;    begin        CheckUserSetup();        if StartingDate = 0D then            Error(Text004, Text005);        if NoOfPeriods = 0 then            Error(Text004, Text006);        ResourcesSetup.TestField("Time Sheet Nos.");        EndingDate := CalcDate('<1W>', StartingDate);        LastDate := StartingDate;        for i := 1 to NoOfPeriods do            LastDate := CalcDate('<1W>', LastDate);        if AccountingPeriod.IsEmpty() then begin            FirstAccPeriodStartingDate := CalcDate('<-CM>', StartingDate);            LastAccPeriodStartingDate := CalcDate('<CM>', StartingDate);        end else begin            AccountingPeriod.SetFilter("Starting Date", '..%1', StartingDate);            AccountingPeriod.FindLast();            FirstAccPeriodStartingDate := AccountingPeriod."Starting Date";            AccountingPeriod.SetFilter("Starting Date", '..%1', LastDate);            AccountingPeriod.FindLast();            LastAccPeriodStartingDate := AccountingPeriod."Starting Date";            AccountingPeriod.SetRange("Starting Date", FirstAccPeriodStartingDate, LastAccPeriodStartingDate);            AccountingPeriod.FindSet();            repeat                AccountingPeriod.TestField(Closed, false);            until AccountingPeriod.Next() = 0;        end;    end;    var        AccountingPeriod: Record "Accounting Period";        ResourcesSetup: Record "Resources Setup";        TimeSheetHeader: Record "Time Sheet Header";        HidResourceFilter: Code[250];        StartingDate: Date;        EndingDate: Date;        TimeSheetCounter: Integer;        NoOfPeriods: Integer;        CreateLinesFromJobPlanning: Boolean;#pragma warning disable AA0074        Text002: Label 'Time sheet administrator only is allowed to create time sheets.';#pragma warning disable AA0470        Text003: Label '%1 time sheets have been created.';        Text004: Label '%1 must be filled in.';#pragma warning restore AA0470        Text005: Label 'Starting Date';        Text006: Label 'No. of Weeks';#pragma warning disable AA0470        Text010: Label 'Starting Date must be %1.';#pragma warning restore AA0470#pragma warning restore AA0074        HideDialog: Boolean;        OpenUserSetupQst: Label 'You aren''t allowed to run this report. If you want, you can give yourself the Time Sheet Admin. rights, and then try again.\\ Do you want to do that now?';        DescriptionTxt: Label 'Week %1', Comment = '%1 - week number';    procedure InitParameters(NewStartingDate: Date; NewNoOfPeriods: Integer; NewResourceFilter: Code[250]; NewCreateLinesFromJobPlanning: Boolean; NewHideDialog: Boolean)    begin        ClearAll();        ResourcesSetup.Get();        StartingDate := NewStartingDate;        NoOfPeriods := NewNoOfPeriods;        HidResourceFilter := NewResourceFilter;        CreateLinesFromJobPlanning := NewCreateLinesFromJobPlanning;        HideDialog := NewHideDialog;    end;    local procedure CheckUserSetup()    var        UserSetup: Record "User Setup";        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeCheckUserSetup(IsHandled);        if IsHandled then            exit;        if (not UserSetup.Get(UserId) or not UserSetup."Time Sheet Admin.") and UserSetup.WritePermission then            if Confirm(OpenUserSetupQst, true) then                PAGE.RunModal(PAGE::"User Setup");        if not UserSetup.Get(UserId) or not UserSetup."Time Sheet Admin." then            Error(Text002);    end;    local procedure CheckExistingPeriods(): Boolean    begin        TimeSheetHeader.SetRange("Resource No.", Resource."No.");        TimeSheetHeader.SetRange("Starting Date", StartingDate);        TimeSheetHeader.SetRange("Ending Date", EndingDate);        if TimeSheetHeader.FindFirst() then            exit(false);        exit(true);    end;    local procedure GetWeekNumber(StartingDate: Date): Integer    var        DateRec: Record Date;    begin        DateRec.SetRange("Period Type", DateRec."Period Type"::Week);        DateRec.SetFilter("Period Start", '%1..', StartingDate);        if DateRec.FindFirst() then            exit(DateRec."Period No.");    end;    local procedure ValidateStartingDate()    begin        if Date2DWY(StartingDate, 1) <> ResourcesSetup."Time Sheet First Weekday" + 1 then            Error(Text010, ResourcesSetup."Time Sheet First Weekday");    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCheckUserSetup(var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeResourceOnAfterGerRecord(var Resource: Record Resource; var IsHandled: Boolean; var StartingDate: Date; var EndingDate: Date)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnResourceOnAfterGerRecordOnBeforeTimeSheetHeaderInsert(var TimeSheetHeader: Record "Time Sheet Header"; Resource: Record Resource)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnResourceOnAfterGerRecordOnAfterTimeSheetHeaderInserted(TimeSheetHeader: Record "Time Sheet Header"; Resource: Record Resource)    begin    end;}