namespace PERMDAL.QueryBuilders;

public static class ScoringQB
{
    // Returns one row per (KRA × Measure) combination for the given appraisal type.
    // Used to build in-memory weight lookups for the scoring engine.
    public const string GET_APPRAISAL_WEIGHTS = @"
        SELECT  atk.KRAID                AS KRAId,
                atk.KRAMEASUREWEIGHTAGE  AS KRAMeasureWeightage,
                atk.KRAGOALWEIGHTAGE     AS KRAGoalWeightage,
                atm.MEASUREID            AS MeasureId,
                atm.WEIGHTAGE            AS MeasureWeightage
        FROM    MAPPRAISALTYPEKRA atk
        INNER JOIN MAPPRAISALTYPEMEASURE atm
                ON  atm.APPRAISALTYPEKRAID = atk.APPRAISALTYPEKRAID
        WHERE   atk.APPRAISALTYPEID = @AppraisalTypeId
        ORDER BY atk.SLNO, atm.SLNO";
}