Make if statement change where statement

im having a hard time trying to make this query work, what I really want is to have it return sum of my sales grouped by each hour.

problem is as in my earlier questions I need to have my days from 7 to 7 the next day. So here im trying to make query that will return sales for all hours but i'm not that familiar with if statements so what im doing wrong.

if i remove my ifstatement and replace realdate with CURDATE() this query will work for 00:00:00 to 00:00:00

  SELECT DATE(delivered) as date, sum(price) as sum, HOUR(delivered) AS hour,
    IF(HOUR(NOW()) < 7, CURDATE() - INTERVAL 1 DAY, CURDATE()) as realdate
          FROM Wardrobe_CloakTable
         WHERE payingcustomerID = 2
           AND delivered >= realdate
           AND delivered <  realdate + INTERVAL 1 DAY
         GROUP BY DATE(delivered), HOUR(delivered)