ID_,name_, org_id_, work_start_time_, work_end_time_, rest_start_time_, rest_end_time_, mark_color_, sort_number_, 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 *, CASE WHEN work_start_time_ <= work_end_time_ AND CURRENT_TIME BETWEEN work_start_time_ AND work_end_time_ THEN 0 WHEN work_start_time_ > work_end_time_ AND (CURRENT_TIME >= work_start_time_ OR CURRENT_TIME <= work_end_time_) THEN 1 END AS classType FROM biz_rank_info WHERE (-- 正常班次（不跨天，如 06:00-14:00） (work_start_time_ <= work_end_time_ AND CURRENT_TIME BETWEEN work_start_time_ AND work_end_time_ ) OR -- 跨天班次（如 22:00-06:00） ( 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_ADD(rank_date_, INTERVAL 1 DAY))) ) ) AND is_dele_ = '0' -- 组织 ID 限制 AND org_id_ IN #{orgId}