namespace OKRDAL.QueryBuilders;

public static class OKRCycleQB
{
    public const string GET_CYCLE = @"
        SELECT  c.OKRCYCLEID   AS OKRCycleId,
                c.CODE         AS Code,
                c.NAME         AS Name,
                c.CYCLESTART   AS CycleStart,
                c.CYCLEEND     AS CycleEnd,
                c.FREQUENCY    AS Frequency,
                c.STATUS       AS Status,
                c.TENANTID     AS TenantId,
                c.CREATEDBY    AS CreatedBy,
                c.CREATEDON    AS CreatedOn,
                c.MODIFIEDBY   AS ModifiedBy,
                c.MODIFIEDON   AS ModifiedOn
        FROM    MOKRCYCLE c
        WHERE   c.OKRCYCLEID = @OKRCycleId
        AND     c.TENANTID   = @TenantId";

    public const string GET_CYCLE_LIST = @"
        SELECT  c.OKRCYCLEID   AS OKRCycleId,
                c.CODE         AS Code,
                c.NAME         AS Name,
                c.CYCLESTART   AS CycleStart,
                c.CYCLEEND     AS CycleEnd,
                c.FREQUENCY    AS Frequency,
                c.STATUS       AS Status,
                c.TENANTID     AS TenantId,
                c.CREATEDBY    AS CreatedBy,
                c.CREATEDON    AS CreatedOn,
                c.MODIFIEDBY   AS ModifiedBy,
                c.MODIFIEDON   AS ModifiedOn
        FROM    MOKRCYCLE c
        WHERE   c.TENANTID = @TenantId
        AND     (@Status = -1 OR c.STATUS = @Status)
        ORDER BY c.CYCLESTART DESC";

    public const string GET_CYCLE_LIST_COUNT = @"
        SELECT COUNT(1)
        FROM   MOKRCYCLE c
        WHERE  c.TENANTID = @TenantId
        AND    (@Status = -1 OR c.STATUS = @Status)";

    public const string GET_SELECT_LIST = @"
        SELECT  c.OKRCYCLEID AS OKRCycleId,
                c.NAME       AS Name
        FROM    MOKRCYCLE c
        WHERE   c.TENANTID = @TenantId
        AND     c.STATUS   IN (1, 2)
        {DYNAMIC_WHERE}
        ORDER BY c.CYCLESTART DESC";

    public const string INSERT_CYCLE = @"
        INSERT INTO MOKRCYCLE
               (OKRCYCLEID, CODE, NAME, CYCLESTART, CYCLEEND, FREQUENCY, STATUS,
                TENANTID, CREATEDBY, CREATEDON, MODIFIEDBY, MODIFIEDON)
        VALUES (@OKRCycleId, @Code, @Name, @CycleStart, @CycleEnd, @Frequency, @Status,
                @TenantId, @CreatedBy, GETUTCDATE(), @CreatedBy, GETUTCDATE())";

    public const string UPDATE_CYCLE = @"
        UPDATE MOKRCYCLE
        SET    CODE        = @Code,
               NAME        = @Name,
               CYCLESTART  = @CycleStart,
               CYCLEEND    = @CycleEnd,
               FREQUENCY   = @Frequency,
               MODIFIEDBY  = @ModifiedBy,
               MODIFIEDON  = GETUTCDATE()
        WHERE  OKRCYCLEID = @OKRCycleId
        AND    TENANTID   = @TenantId";

    public const string CLOSE_CYCLE = @"
        UPDATE MOKRCYCLE
        SET    STATUS      = 2,
               MODIFIEDBY  = @ModifiedBy,
               MODIFIEDON  = GETUTCDATE()
        WHERE  OKRCYCLEID = @OKRCycleId
        AND    TENANTID   = @TenantId
        AND    STATUS      = 1";  // only Active → Closed
}