Shift Scheduler

面向零售门店的排班管理助手：查询个人与团队班次、发起换班与请假并交由店长审批、班前提醒，以及依据班表把投诉/库存升级路由到当班店长。排班数据可来自 Google Sheets、Excel/CSV 文件、WeCom 日历或经理手动输入，并用脚本解析为结构化 JSON 后校验冲突与空档。

fangwei-frank

热度 82.64

最近更新 2026-05-11 17:35:23

分类：协作依赖：代码执行 / 读写文件 / 第三方 API应用场景：日程安排 / 任务管理 / 工作流

安装技能

复制下面的话术发给你的 Agent，它会通过 secure-skills 检索并安装该技能。

执行命令安装此 skill： npx secure-skills-cli add shift-scheduler

Metadata

name: shift-scheduler
description: Staff shift scheduling and management assistant for retail store managers and employees. Answers shift queries, sends reminders, handles swap requests, and manages on-call routing. Use when someone asks: 我今天几点上班, 班表, 排班, 换班, 请假, 谁在值班, what's my shift, who's working today, shift swap, schedule, 今天谁当班, cover my shift, time off request, 我想换班, 排班表查询.
metadata: {"openclaw":{"emoji":"📅"}}

Shift Scheduler

Overview

This skill manages staff scheduling queries and shift-related requests. It reads schedule data from the configured source and routes requests to the appropriate manager for approval.

Depends on: Staff list + schedule data from Step 02 / Step 05 config. Configured in: skills_config.shift-scheduler

Data Source Options

Source	Config Value	Setup
Google Sheets	`"google_sheets"`	Share link in config
Excel/CSV file	`"file"`	Path to schedule file
WeCom Calendar	`"wecom_calendar"`	WeCom API integration
Manual input	`"manual"`	Manager pastes schedule text

Reference: schedule-formats.md

Query Types & Responses

"我今天几点上班？"

Identify the asker (match to staff list by WeCom ID or name)
Look up today's shift in schedule data
Return: shift start/end time + location (if multi-floor/location)

张三，你今天的班是：
  📍 收银台  10:00 – 19:00（含1小时午休）
  搭班同事：李四、王五

"今天谁在当班？" (Manager query)

今日在班人员（[date]）：
  早班 (09:00-17:00)：张三、李四
  晚班 (14:00-22:00)：王五、赵六
  值班店长：王经理

"我想换班" (Swap request)

Confirm: who wants to swap, which shift, with whom (or open request)
Check if target staff is available (not already scheduled)
Submit to manager for approval (L1)
Notify both parties of outcome

"我想请假" (Time-off request)

Confirm dates and reason (optional)
Submit to manager (L2 — always needs approval)
Check if replacement coverage is available; flag if not
Track request status; notify when approved/denied

Proactive Shift Reminders

Send 12 hours before shift starts (configurable via remind_before_hours):

⏰ 上班提醒

张三，明天 [date] 你的班是：
  10:00 – 19:00（[location]）
  记得准时到岗～

Swap Request Flow

员工申请换班
    ↓
检查被换员工排班（有无冲突）
    ↓
发送 L1 确认给店长
    ↓
店长确认 → 更新排班表 → 通知双方
店长拒绝 → 通知申请人 + 给出原因
    ↓
记录换班历史（避免频繁换班模式）

On-Call Routing Integration

The shift schedule drives escalation routing in complaint-handler and inventory-query.

When an escalation fires:

Check current time against shift schedule
Route to whoever is listed as on-duty manager for this time slot
If no on-duty manager found: fall back to off_hours_contact in permissions_config

This ensures L2/L3 alerts always go to the right person, not just a fixed manager ID.

Schedule Update

When manager pastes or uploads a new schedule:

Parse it using scripts/parse_schedule.py
Validate: no double-booking, all shifts covered, no gaps > 2 hours during open hours
Confirm with manager before activating
Archive previous schedule

Script: scripts/parse_schedule.py — parses Excel/text schedule into structured JSON. Reference: schedule-formats.md