alter procedure [dbo].[IBS_fetchreqVehicleinPodiumtestnew1]
   @locid INTEGER = NULL
AS BEGIN
   SET NOCOUNT ON

   DECLARE @TodayMinus7Days DATETIME
Declare @krrt integer
Declare @DT integer
   SET @TodayMinus7Days = getdate()-7

   SELECT
       t.TBarcode, t.PlateNo, t.DelEcode
       if t.status=3
       begin
       @krrt=datediff(MINUTE, t.PayDate, GETDATE())
         end
         else
         if t.status=4
         begin
         @krrt=datediff(MINUTE, t.PayDate, t.t.KeyRoomDate)
         end
         if t.status=5
         begin
         @dt=datediff(minute,t.paydate,t.Deldate)
         end
   FROM
       dbo.Transaction_tbl t
   WHERE
       ([status] IN (3,4) AND locid = @locid AND dtime >= @TodayMinus7Days)
       OR
       ([status] = 5 AND DATEDIFF(n, CAST(DelDate AS DATETIME), GETDATE()) <= 3 AND locid = @locid AND dtime >= @TodayMinus7Days)
   ORDER BY
       paydate
END

SELECT
       t.TBarcode, t.PlateNo, t.DelEcode
       datediff(MINUTE, t.PayDate,
             CASE t.Status
                WHEN 3 THEN GETDATE()
                WHEN 4 THEN t.KeyRoomDate
             END) as KRRT,
       datediff(MINUTE,t.PayDate,
             CASE t.Status
                WHEN 5 THEN t.DelDate
             END) as DT
   FROM
       dbo.Transaction_tbl t
   WHERE
       ([status] IN (3,4) AND locid = @locid AND dtime >= @TodayMinus7Days)
       OR
       ([status] = 5 AND DATEDIFF(n, CAST(DelDate AS DATETIME), GETDATE()) <= 3
         AND locid = @locid AND dtime >= @TodayMinus7Days)
   ORDER BY
       paydate

alter procedure [dbo].[IBS_fetchreqVehicleinPodiumtestnew1]
   @locid INTEGER = NULL
AS BEGIN
   SET NOCOUNT ON

   DECLARE @TodayMinus7Days DATETIME
   SET @TodayMinus7Days = getdate()-7

   SELECT
       t.TBarcode, t.PlateNo, t.DelEcode
       ,case
            when t.status=3 then datediff(MINUTE, t.PayDate, GETDATE())
        when t.status=4 then datediff(MINUTE, t.PayDate, t.t.KeyRoomDate)
        else null
    end AS krrt
    , case
        when t.status=5 then datediff(minute,t.paydate,t.Deldate)
        else null
    end as DT
   FROM
   dbo.Transaction_tbl t
   WHERE
   ([status] IN (3,4) AND locid = @locid AND dtime >= @TodayMinus7Days)
   OR
   ([status] = 5 AND DATEDIFF(n, CAST(DelDate AS DATETIME), GETDATE()) <= 3 AND locid = @locid AND dtime >= @TodayMinus7Days)
   ORDER BY
   paydate