namespace MMDAL.Query.Party
{
    public static class PartyQB
    {
        // Inner query — DAL appends AND pa.PARTYID = @PartyId, then wraps in CTE for pagination.
        public const string GET_PARTYDETAILS_QUALITY_INNER = @"
SELECT
    ROW_NUMBER() OVER (ORDER BY paramset.SLNO)  AS RowNum,
    0                                           AS ItemDetailId,
    pa.PARTYID                                  AS ItemId,
    pa.PARTYCODE                                AS ItemCode,
    pa.PARTYNAME                                AS ItemName,
    ISNULL(pa.PARTYSHORTNAME, '')               AS ItemShortName,
    paramset.SLNO                               AS ItemDetailSlNo,
    paramset.PARAMETERID                        AS ParameterId,
    parameter.PARAMETERCODE                     AS ParameterCode,
    parameter.PARAMETERNAME                     AS ParameterName,
    parameter.PARAMETERDATATYPE                 AS ParameterDataType,
    CAST(parameter.MINVALUE AS FLOAT)           AS ParameterMinValue,
    CAST(parameter.MAXVALUE AS FLOAT)           AS ParameterMaxValue,
    parameter.LOVTYPEID                         AS ParameterLovTypeId,
    parameter.UOMID                             AS UOMId,
    uom.UOMCODE                                 AS UOMCode,
    uom.UOMNAME                                 AS UOMName,
    NULL                                        AS ItemDetailMinimum,
    NULL                                        AS ItemDetailMaximum,
    NULL                                        AS ItemDetailInputText,
    NULL                                        AS ItemDetailInputDate,
    NULL                                        AS InputId,
    NULL                                        AS InputCode,
    NULL                                        AS InputName,
    NULL                                        AS Score,
    NULL                                        AS ItemDetailInputValue,
    NULL                                        AS ItemDetailFinalValue,
    paramset.REJECTIONTYPE                      AS RejectionType,
    NULL                                        AS ItemDetailStandardText,
    NULL                                        AS ItemDetailType,
    NULL                                        AS ItemDetailTollerancePlusPercent,
    NULL                                        AS ItemDetailTolleranceMinusPercent,
    NULL                                        AS SKUId,
    NULL                                        AS SKUCode,
    NULL                                        AS SKUName
FROM MPARTY                 pa
JOIN MPARAMETERSETDETAIL    paramset  ON paramset.PARAMETERSETID = pa.QUALITYPARAMETERSETID
JOIN MPARAMETER             parameter ON parameter.PARAMETERID   = paramset.PARAMETERID
JOIN MUOM                   uom       ON uom.UOMID               = parameter.UOMID
WHERE 1 = 1";

        public const string GET_PARTYDETAILS_QUALITY_OUTER = @"
SELECT ItemDetailId, ItemId, ItemCode, ItemName, ItemShortName,
       ItemDetailSlNo, ParameterId, ParameterCode, ParameterName, ParameterDataType,
       ParameterMinValue, ParameterMaxValue, ParameterLovTypeId,
       UOMId, UOMCode, UOMName,
       ItemDetailMinimum, ItemDetailMaximum, ItemDetailInputText, ItemDetailInputDate,
       InputId, InputCode, InputName, Score,
       ItemDetailInputValue, ItemDetailFinalValue, RejectionType,
       ItemDetailStandardText, ItemDetailType,
       ItemDetailTollerancePlusPercent, ItemDetailTolleranceMinusPercent,
       SKUId, SKUCode, SKUName
FROM PagedParty
WHERE (@firstnumber = -1 AND @maxresult = -1)
   OR (RowNum BETWEEN @firstnumber AND @maxresult);";
    }
}