SELECT Query to get all the data of 7 days

DROP PROCEDURE IF EXISTS `get_users_halls`;
delimiter ;;
CREATE PROCEDURE `get_users_halls` ()
BEGIN
  
SELECT u.id , u.email,
    u.first_name,
    u.last_name,
    count(*) as total_halls,
    u.override_membership_price,
    CASE
        WHEN u.override_membership_price IS NULL THEN (((count(*)-1) * 50)+100)*0.1
            ELSE  u.override_membership_price * 0.1
    END AS gst_amount,
    CASE
        WHEN u.override_membership_price IS NULL THEN ((count(*)-1) * 50)+100
            ELSE u.override_membership_price
    END AS total_amount,
    u.subscription,
    u.expires_on,
    DATE_ADD(u.expires_on, INTERVAL 1 YEAR) as extended_date,
     CASE
        WHEN u.override_membership_price IS NULL THEN TRUE
            ELSE FALSE
        END AS display_info
        FROM users u INNER JOIn halls h ON u.id=h.user_id
WHERE u.id NOT IN (SELECT i.user_id FROM invoices i WHERE i.invoice_date=CURRENT_DATE()) 
AND u.expires_on = DATE_ADD(CURRENT_DATE(), INTERVAL 1 MONTH)
AND u.activated=1 AND u.subscription='yearly' group by u.id;
END;

The above gives the data whose invoice date is expiring 1 month from today's date. I have CRON job running the script, but I am also thinking if in any cases Job didn't run then all the invoice that needs to be generated within that time also need to be sent for the users. So I am planning to fetch the 7 days ahead data as well. So that all the users that have been missed also get the invoice including all the users whose date is expiring after 1 month(which the above scripts does), but I am also thinking to get the missing data. How can I do that any logic to do the task would be appreciated.