他这个报告日期要跟数据联动的,昨天填了,他要使点击2021-10-31的时候,展示31号的内容,如果今天没数,选择今天则展示昨天的内容,如果今天有数,则展示今天的内容,可以实现吗select*,BizDate as the_date from dm_preparations_daywhere bizdate=(select max(bizdate) from dm_preparations_day where BizDate<='${date}' )${IF( OR ( project_code = "全选", len( project_code ) == 0 ), "", "and project_code in ('" + project_code + "')" ) } ${if(fr_username='admin',"","AND project_code IN (SELECT project_code FROM User_Fill_Authority WHERE userId='"+fr_username+"')")}