oa_overtime_hours.py 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350
  1. """加班套件:工作日/休息日窗口重叠小时(与前端 oa-overtime-hours.ts 对齐)"""
  2. from __future__ import annotations
  3. import re
  4. from datetime import datetime, timedelta
  5. from typing import Any, Callable, Dict, List, Optional, Tuple
  6. Interval = Tuple[float, float]
  7. _DT_RE = re.compile(r"^(\d{4})-(\d{2})-(\d{2})[ T](\d{2}):(\d{2})$")
  8. _HM_RE = re.compile(r"^(\d{1,2}):(\d{2})$")
  9. DEFAULT_OVERTIME_WINDOWS = {
  10. "workdayOvertimeStart": "17:30",
  11. "workdayOvertimeEnd": "08:30",
  12. "restBreakStart": "11:30",
  13. "restBreakEnd": "13:30",
  14. }
  15. MANUAL_PREFIX = "__manual_"
  16. def _parse_hm(hm: Any) -> Optional[int]:
  17. m = _HM_RE.match(str(hm or "").strip())
  18. if not m:
  19. return None
  20. h, mi = int(m.group(1)), int(m.group(2))
  21. if h < 0 or h > 23 or mi < 0 or mi > 59:
  22. return None
  23. return h * 60 + mi
  24. def _parse_dt(s: Any) -> Optional[datetime]:
  25. m = _DT_RE.match(str(s or "").strip())
  26. if not m:
  27. return None
  28. try:
  29. return datetime(
  30. int(m.group(1)),
  31. int(m.group(2)),
  32. int(m.group(3)),
  33. int(m.group(4)),
  34. int(m.group(5)),
  35. )
  36. except ValueError:
  37. return None
  38. def _format_ymd(d: datetime) -> str:
  39. return d.strftime("%Y-%m-%d")
  40. def _day_start_ms(d: datetime) -> float:
  41. day0 = datetime(d.year, d.month, d.day)
  42. return day0.timestamp() * 1000
  43. def _day_at_minutes(d: datetime, minutes: int) -> float:
  44. return _day_start_ms(d) + minutes * 60000
  45. def _merge_intervals(intervals: List[Interval]) -> List[Interval]:
  46. if not intervals:
  47. return []
  48. sorted_iv = sorted(intervals, key=lambda x: x[0])
  49. merged: List[Interval] = [(sorted_iv[0][0], sorted_iv[0][1])]
  50. for s, e in sorted_iv[1:]:
  51. last = merged[-1]
  52. if s <= last[1]:
  53. merged[-1] = (last[0], max(last[1], e))
  54. else:
  55. merged.append((s, e))
  56. return merged
  57. def _intersect_interval(a: Interval, b: Interval) -> Optional[Interval]:
  58. lo = max(a[0], b[0])
  59. hi = min(a[1], b[1])
  60. return (lo, hi) if hi > lo else None
  61. def _subtract_interval(base: Interval, sub: Interval) -> List[Interval]:
  62. bs, be = base
  63. ss, se = sub
  64. if se <= bs or ss >= be:
  65. return [base]
  66. out: List[Interval] = []
  67. if ss > bs:
  68. out.append((bs, ss))
  69. if se < be:
  70. out.append((se, be))
  71. return out
  72. def _subtract_intervals(base: Interval, subs: List[Interval]) -> List[Interval]:
  73. result: List[Interval] = [base]
  74. for sub in subs:
  75. nxt: List[Interval] = []
  76. for r in result:
  77. nxt.extend(_subtract_interval(r, sub))
  78. result = nxt
  79. return result
  80. def _interval_minutes(intervals: List[Interval]) -> float:
  81. return sum((b - a) / 60000 for a, b in intervals)
  82. def _build_workday_windows(anchor_day: datetime, windows: Dict[str, str]) -> Optional[Interval]:
  83. start_min = _parse_hm(windows.get("workdayOvertimeStart"))
  84. end_min = _parse_hm(windows.get("workdayOvertimeEnd"))
  85. if start_min is None or end_min is None:
  86. return None
  87. anchor_start = _day_at_minutes(anchor_day, start_min)
  88. next_day = anchor_day + timedelta(days=1)
  89. anchor_end = _day_at_minutes(next_day, end_min)
  90. if anchor_end <= anchor_start:
  91. return None
  92. return (anchor_start, anchor_end)
  93. def _build_rest_day_segments(day: datetime, windows: Dict[str, str]) -> List[Interval]:
  94. break_start = _parse_hm(windows.get("restBreakStart"))
  95. break_end = _parse_hm(windows.get("restBreakEnd"))
  96. if break_start is None or break_end is None:
  97. return []
  98. day0 = _day_start_ms(day)
  99. next_day = day + timedelta(days=1)
  100. day_end = _day_start_ms(next_day)
  101. segments: List[Interval] = []
  102. if break_start > 0:
  103. segments.append((day0, _day_at_minutes(day, break_start)))
  104. if break_end < 24 * 60:
  105. segments.append((_day_at_minutes(day, break_end), day_end))
  106. return [(a, b) for a, b in segments if b > a]
  107. def calc_overtime_hours(
  108. start_str: Any,
  109. end_str: Any,
  110. windows: Optional[Dict[str, str]] = None,
  111. is_rest_day_fn: Optional[Callable[[str], bool]] = None,
  112. ) -> Optional[float]:
  113. """返回 1 位小数小时;非法或 end<=start 返回 None。"""
  114. if is_rest_day_fn is None:
  115. raise TypeError("is_rest_day_fn is required")
  116. win = dict(DEFAULT_OVERTIME_WINDOWS)
  117. if isinstance(windows, dict):
  118. win.update({k: str(windows.get(k) or win[k]) for k in DEFAULT_OVERTIME_WINDOWS})
  119. start = _parse_dt(start_str)
  120. end = _parse_dt(end_str)
  121. if not start or not end or end <= start:
  122. return None
  123. query: Interval = (start.timestamp() * 1000, end.timestamp() * 1000)
  124. start_day = datetime(start.year, start.month, start.day)
  125. end_day = datetime(end.year, end.month, end.day)
  126. workday_intervals: List[Interval] = []
  127. anchor = start_day - timedelta(days=1)
  128. last_anchor = end_day
  129. while anchor <= last_anchor:
  130. ymd = _format_ymd(anchor)
  131. if not is_rest_day_fn(ymd):
  132. win_iv = _build_workday_windows(anchor, win)
  133. if win_iv:
  134. hit = _intersect_interval(win_iv, query)
  135. if hit:
  136. workday_intervals.append(hit)
  137. anchor += timedelta(days=1)
  138. workday_merged = _merge_intervals(workday_intervals)
  139. rest_intervals: List[Interval] = []
  140. day = start_day
  141. while day <= end_day:
  142. ymd = _format_ymd(day)
  143. if is_rest_day_fn(ymd):
  144. for seg in _build_rest_day_segments(day, win):
  145. hit = _intersect_interval(seg, query)
  146. if hit:
  147. rest_intervals.extend(_subtract_intervals(hit, workday_merged))
  148. day += timedelta(days=1)
  149. total_minutes = _interval_minutes(workday_merged) + _interval_minutes(rest_intervals)
  150. return round(total_minutes / 60.0, 1)
  151. def _extract_rules(form_schema: Any) -> List[Dict[str, Any]]:
  152. if isinstance(form_schema, list):
  153. return [r for r in form_schema if isinstance(r, dict)]
  154. if isinstance(form_schema, dict):
  155. rules = form_schema.get("rule") or form_schema.get("rules") or form_schema.get("fields")
  156. if isinstance(rules, list):
  157. return [r for r in rules if isinstance(r, dict)]
  158. if form_schema.get("type") or form_schema.get("field"):
  159. return [form_schema]
  160. return []
  161. def _walk(rules: List[Dict[str, Any]], out: List[Dict[str, Any]]) -> None:
  162. for r in rules:
  163. if not isinstance(r, dict):
  164. continue
  165. out.append(r)
  166. children = r.get("children")
  167. if isinstance(children, list):
  168. _walk([c for c in children if isinstance(c, dict)], out)
  169. props = r.get("props") if isinstance(r.get("props"), dict) else {}
  170. nested = props.get("rule")
  171. if isinstance(nested, list):
  172. _walk([c for c in nested if isinstance(c, dict)], out)
  173. def _kit_child_fields(kit: Dict[str, Any]) -> Tuple[Optional[str], Optional[str], Optional[str]]:
  174. """返回 (start_field, end_field, duration_field)。"""
  175. props = kit.get("props") if isinstance(kit.get("props"), dict) else {}
  176. start_f = props.get("startField")
  177. end_f = props.get("endField")
  178. dur_f = props.get("durationField")
  179. if start_f and end_f and dur_f:
  180. return str(start_f), str(end_f), str(dur_f)
  181. children = kit.get("children")
  182. if not isinstance(children, list):
  183. children = []
  184. p_rule = props.get("rule")
  185. if isinstance(p_rule, list):
  186. children = p_rule
  187. start_field: Optional[str] = None
  188. end_field: Optional[str] = None
  189. duration_field: Optional[str] = None
  190. date_fields: List[str] = []
  191. for c in children:
  192. if not isinstance(c, dict):
  193. continue
  194. field = c.get("field")
  195. if not field:
  196. continue
  197. c_props = c.get("props") if isinstance(c.get("props"), dict) else {}
  198. kit_field = c_props.get("_fc_kit_field")
  199. if kit_field == "overtimeStart":
  200. start_field = str(field)
  201. continue
  202. if kit_field == "overtimeEnd":
  203. end_field = str(field)
  204. continue
  205. if kit_field == "overtimeDuration":
  206. duration_field = str(field)
  207. continue
  208. t = str(c.get("type") or "")
  209. if t in ("datePicker", "date", "timePicker", "time"):
  210. date_fields.append(str(field))
  211. elif t in ("inputNumber", "number") and duration_field is None:
  212. duration_field = str(field)
  213. elif t in ("inputNumber", "number") and "时长" in str(c.get("title") or ""):
  214. duration_field = str(field)
  215. if start_field is None and len(date_fields) >= 1:
  216. start_field = date_fields[0]
  217. if end_field is None and len(date_fields) >= 2:
  218. end_field = date_fields[1]
  219. return start_field, end_field, duration_field
  220. def _round1(v: Any) -> Optional[float]:
  221. try:
  222. n = float(v)
  223. except (TypeError, ValueError):
  224. return None
  225. if n < 0:
  226. return None
  227. return round(n, 1)
  228. def apply_overtime_kit_hours(
  229. form_schema: Any,
  230. form_data: Dict[str, Any],
  231. is_rest_day_fn: Callable[[str], bool],
  232. ) -> Dict[str, Any]:
  233. """
  234. 遍历 overtimeKit:未手改则覆盖时长;已手改(form_data[__manual_<durationField>])则仅规范化一位小数。
  235. """
  236. data = dict(form_data or {})
  237. flat: List[Dict[str, Any]] = []
  238. _walk(_extract_rules(form_schema), flat)
  239. for rule in flat:
  240. if str(rule.get("type") or "") != "overtimeKit":
  241. continue
  242. start_f, end_f, dur_f = _kit_child_fields(rule)
  243. if not start_f or not end_f or not dur_f:
  244. continue
  245. props = rule.get("props") if isinstance(rule.get("props"), dict) else {}
  246. win = {
  247. "workdayOvertimeStart": str(
  248. props.get("workdayOvertimeStart") or DEFAULT_OVERTIME_WINDOWS["workdayOvertimeStart"]
  249. ),
  250. "workdayOvertimeEnd": str(
  251. props.get("workdayOvertimeEnd") or DEFAULT_OVERTIME_WINDOWS["workdayOvertimeEnd"]
  252. ),
  253. "restBreakStart": str(
  254. props.get("restBreakStart") or DEFAULT_OVERTIME_WINDOWS["restBreakStart"]
  255. ),
  256. "restBreakEnd": str(
  257. props.get("restBreakEnd") or DEFAULT_OVERTIME_WINDOWS["restBreakEnd"]
  258. ),
  259. }
  260. manual_key = MANUAL_PREFIX + dur_f
  261. is_manual = bool(data.get(manual_key))
  262. if is_manual:
  263. rounded = _round1(data.get(dur_f))
  264. if rounded is not None:
  265. data[dur_f] = rounded
  266. continue
  267. hours = calc_overtime_hours(data.get(start_f), data.get(end_f), win, is_rest_day_fn)
  268. if hours is not None:
  269. data[dur_f] = hours
  270. return data
  271. def validate_overtime_kit_form_values(form_schema: Any, form_data: Dict[str, Any]) -> List[str]:
  272. """提交校验:结束>开始;手改时长合法。"""
  273. errors: List[str] = []
  274. data = form_data or {}
  275. flat: List[Dict[str, Any]] = []
  276. _walk(_extract_rules(form_schema), flat)
  277. for rule in flat:
  278. if str(rule.get("type") or "") != "overtimeKit":
  279. continue
  280. start_f, end_f, dur_f = _kit_child_fields(rule)
  281. if not start_f or not end_f or not dur_f:
  282. continue
  283. start = _parse_dt(data.get(start_f))
  284. end = _parse_dt(data.get(end_f))
  285. if data.get(start_f) and data.get(end_f):
  286. if not start or not end:
  287. errors.append("加班起止时间格式须为 YYYY-MM-DD HH:mm")
  288. elif end <= start:
  289. errors.append("加班结束时间须晚于开始时间")
  290. if MANUAL_PREFIX + dur_f in data or data.get(MANUAL_PREFIX + dur_f):
  291. if data.get(dur_f) is not None and data.get(dur_f) != "":
  292. if _round1(data.get(dur_f)) is None:
  293. errors.append("加班时长须为非负数字(1 位小数)")
  294. return errors