Codeunit 6308 PBI Job Chart Calc.

Base Application, Microsoft.Integration.PowerBI

src/Layers/W1/BaseApp/Integration/PowerBI/ReportingData/PBIJobChartCalc.Codeunit.al99 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.Integration.PowerBI;using Microsoft.Projects.Project.Analysis;using Microsoft.Projects.Project.Job;codeunit 6308 "PBI Job Chart Calc."{    trigger OnRun()    begin    end;    var        Job: Record Job;        TotalRevenueTxt: Label 'Total Revenue';        TotalCostTxt: Label 'Total Cost';        ProfitMarginTxt: Label 'Profit Margin';        ActualTotalCostTxt: Label 'Actual Total Cost';        BudgetTotalCostTxt: Label 'Budget Total Cost';        CostVarianceTxt: Label 'Cost Variance';        ActualTotalPriceTxt: Label 'Actual Total Price';        BudgetTotalPriceTxt: Label 'Budget Total Price';        PriceVarianceTxt: Label 'Price Variance';        JobChartType: Option Profitability,"Actual to Budget Cost","Actual to Budget Price";    procedure GetValues(var TempPowerBIChartBuffer: Record "Power BI Chart Buffer" temporary; pJobChartType: Option Profitability,"Actual to Budget Cost","Actual to Budget Price")    var        MyJob: Record "My Job";    begin        JobChartType := pJobChartType;        MyJob.SetRange("User ID", UserId);        MyJob.SetRange("Exclude from Business Chart", false);        if MyJob.FindSet() then            repeat                if Job.Get(MyJob."Job No.") then                    CalculateValues(TempPowerBIChartBuffer);            until MyJob.Next() = 0;    end;    local procedure CalculateValues(var TempPowerBIChartBuffer: Record "Power BI Chart Buffer" temporary)    var        JobChartMgt: Codeunit "Job Chart Mgt";        ActualCost: Decimal;        BudgetCost: Decimal;        CostVariance: Decimal;        JobRevenue: Decimal;        JobCost: Decimal;        ProfitMargin: Decimal;        ActualPrice: Decimal;        BudgetPrice: Decimal;        PriceVariance: Decimal;    begin        case JobChartType of            JobChartType::Profitability:                begin                    JobChartMgt.CalculateJobRevenueAndCost(Job, JobRevenue, JobCost);                    ProfitMargin := JobRevenue - JobCost;                    InsertToBuffer(TempPowerBIChartBuffer, JobRevenue, TotalRevenueTxt);                    InsertToBuffer(TempPowerBIChartBuffer, JobCost, TotalCostTxt);                    InsertToBuffer(TempPowerBIChartBuffer, ProfitMargin, ProfitMarginTxt);                end;            JobChartType::"Actual to Budget Cost":                begin                    JobChartMgt.CalculateJobCosts(Job, ActualCost, BudgetCost);                    CostVariance := BudgetCost - ActualCost;                    InsertToBuffer(TempPowerBIChartBuffer, ActualCost, ActualTotalCostTxt);                    InsertToBuffer(TempPowerBIChartBuffer, BudgetCost, BudgetTotalCostTxt);                    InsertToBuffer(TempPowerBIChartBuffer, CostVariance, CostVarianceTxt);                end;            JobChartType::"Actual to Budget Price":                begin                    JobChartMgt.CalculateJobPrices(Job, ActualPrice, BudgetPrice);                    PriceVariance := BudgetPrice - ActualPrice;                    InsertToBuffer(TempPowerBIChartBuffer, ActualPrice, ActualTotalPriceTxt);                    InsertToBuffer(TempPowerBIChartBuffer, BudgetPrice, BudgetTotalPriceTxt);                    InsertToBuffer(TempPowerBIChartBuffer, PriceVariance, PriceVarianceTxt);                end;        end;    end;    local procedure InsertToBuffer(var TempPowerBIChartBuffer: Record "Power BI Chart Buffer" temporary; pValue: Decimal; pMeasureName: Text[111])    begin        if TempPowerBIChartBuffer.FindLast() then            TempPowerBIChartBuffer.ID += 1        else            TempPowerBIChartBuffer.ID := 1;        TempPowerBIChartBuffer.Value := pValue;        TempPowerBIChartBuffer."Measure Name" := pMeasureName;        TempPowerBIChartBuffer."Measure No." := Job."No.";        TempPowerBIChartBuffer.Insert();    end;}