弹性考勤记录查询SQL中如何处理跨天记录？

  SELECT
      employee_id,
      punch_in_time,
      punch_out_time,
      CASE
          WHEN punch_out_time < punch_in_time THEN '跨天记录'
          ELSE '正常记录'
      END AS record_type,
      -- 计算工作时长
      CASE
          WHEN punch_out_time < punch_in_time THEN
              TIMESTAMPDIFF(SECOND, punch_in_time, DATE(punch_in_time) + INTERVAL 1 DAY) +
              TIMESTAMPDIFF(SECOND, DATE(punch_out_time), punch_out_time)
          ELSE
              TIMESTAMPDIFF(SECOND, punch_in_time, punch_out_time)
      END AS duration_seconds
  FROM
      attendance_records;