團隊排班系統 - Team Shift System

# 設計排班系統及介面排版，方便管理人員安排班別
# Designing a shift scheduling system and interface to streamline workforce management.

Description:
針對傳統 Excel 排班導致的協作不便與安全風險，開發專用排班平台。透過帳號權限管理分離前後端介面：前台供人員即時查閱，後台供管理員進行排程，並整合政府行政機關辦公日曆，大幅提升排班流程的流暢度與準確性。
To address the collaboration hurdles and security risks of traditional Excel-based scheduling, I developed a dedicated shift management platform. By implementing account-based access control, the system decouples the user and admin interfaces—providing personnel with real-time schedule visibility while enabling admins to manage rosters integrated with official government holiday calendars.

Tech Stack:

• Python3 + FastAPI
• Elasticsearch DB
• Gov Holiday OpenAPI

Features:

• 前台日曆查閱系統 (Frontend Calendar View)
  前台介面以動態日曆形式呈現，支援年月切換並整合政府行事曆，方便輪班人員掌握個人班表與團隊出勤狀況。
  The frontend features a dynamic calendar interface supporting month-to-month navigation and government holiday integration.
• 後台自動化編排與人資系統整合 (Admin Scheduling & HR Integration)
  後台以直觀表格供管理員排班，系統會自動轉換數據格式，支援一鍵匯出符合人資系統規範的檔案，達成無縫對接。
  The backend provides an intuitive grid for admins to arrange shifts with one-click exports for HR software integration.
• 人員列表 (Personnel Database)
  建立集中化的人員資料庫，管理員可定義人員所屬單位與對應班表，實現前、後端數據的精準關聯。
  Established a centralized personnel database where admins can define departments and shift assignments.
• 管理列表 (RBAC)
  實作嚴格的權限控管機制，區分輪班人員與平台管理者身分，確保敏感資訊僅限授權人員存取。
  Implemented a robust Role-Based Access Control (RBAC) mechanism to distinguish between general personnel and platform admins.

Results:

• 透過系統化界面取代複雜的試算表公式，消除因人為誤操作導致的格式跑位，確保班表數據的絕對穩定。
  Replaced complex spreadsheet formulas with a standardized system interface, ensuring absolute data stability.
• 支援多管理員同步作業，各單位可獨立安排所屬班表，顯著提升整體排程的處理速度。
  Supports concurrent operations by multiple admins, significantly accelerating the overall scheduling process.
• 有效管控平台訪問權限，防止排班資訊遭未經授權之竄改或外部窺視，提升企業資訊安全性。
  Effectively governs platform access to prevent unauthorized tampering, fortifying corporate information security.

Architecture Overview:

sequenceDiagram
    participant Admin as Admin User
    participant Backend as FastAPI Backend
    participant ES as Elasticsearch
    participant HR as HR System
    
    Admin->>Backend: Create Shift Info
    Backend->>ES: Save Shift Info
    Admin->>Backend: Set Shift Schedule
    Backend->>ES: Save Shift Schedule
    Admin->>Backend: Export Request
    Backend->>ES: Query Shift Data
    ES-->>Backend: Return Schedule
    Backend->>Backend: Convert to HR CSV Format
    Backend-->>Admin: Download HR CSV File
    Admin->>HR: Import CSV