fix: recovery stats glitch

[qiyi-jiang]

Specs are pending. With this fix, when compared to the original solution:

• the performance is low
• enables the prolonged status (if not submitted today, take the status of the closest past within the expiry date range)
• preps for the multiple daily submission scenario as well (the multiple daily submission feat not merged yet)