ID_, rank_id_,rank_name_,toll_station_id_, respons_id_,respons_name_,user_name_, user_id_, TENANT_ID_, CREATED_BY_, CREATE_NAME_, CREATE_ORG_ID_, CREATE_ORG_NAME_, CREATE_COMPANY_NAME_, CREATE_COMPANY_ID_, CREATED_TIME_, UPDATED_BY_, UPDATE_NAME_, UPDATE_COMPANY_NAME_, UPDATE_COMPANY_ID_, UPDATE_ORG_ID_, UPDATE_ORG_NAME_, UPDATED_TIME_, LAST_TIME_, IS_DELE_ select a.* from biz_inspect_rank_user a inner join biz_inspect_rank_info b on a.rank_id_ =b.id_ where a.is_dele_ = "0" and b.is_dele_ = "0" and a.rank_date_ >= #{startDate} and a.rank_date_ < #{endDate} and b.org_id_ = #{orgId} and a.rank_id_ = #{rankGroupId} SELECT ru.* FROM biz_inspect_rank_info ri JOIN biz_inspect_rank_user ru ON ri.id_ = ru.rank_id_ WHERE (( -- 情况1: 工作时间不跨天 work_start_time_ work_end_time_ AND CURRENT_TIME BETWEEN work_start_time_ AND work_end_time_ AND CURRENT_DATE = rank_date_ ) OR ( -- 情况2: 工作时间跨天 work_start_time_ > work_end_time_ AND ( (CURRENT_TIME >= work_start_time_ AND CURRENT_DATE = rank_date_) OR (CURRENT_TIME work_end_time_ AND CURRENT_DATE = DATE_SUB(rank_date_, INTERVAL 1 DAY)) ) )) AND ri.is_dele_='0' AND ru.is_dele_='0' AND ri.org_id_ IN #{orgId}