Worklog Sync

-- Kanban DB table (auto-created on connection)
CREATE TABLE IF NOT EXISTS project_settings (
  project TEXT PRIMARY KEY,
  worklog_type TEXT NOT NULL DEFAULT 'work',
  eob_project_id TEXT,
  eob_product_line_id TEXT,
  default_work_type_code TEXT DEFAULT 'ENG-SW',
  label TEXT
);

KANBAN_API="$BASE_URL"  # from kanban config

# List all
curl -s "${AUTH_HEADER[@]}" "$KANBAN_API/api/project-settings"

# Get one
curl -s "${AUTH_HEADER[@]}" "$KANBAN_API/api/project-settings/$PROJECT"

# Upsert
curl -s "${AUTH_HEADER[@]}" -X PUT "$KANBAN_API/api/project-settings/$PROJECT" \
  -H 'Content-Type: application/json' \
  -d '{"worklog_type":"work","eob_project_id":"<UUID>","default_work_type_code":"ENG-SW","label":"..."}'

{
  "eob_base_url": "https://eob.10.182.252.32.sslip.io",
  "kanban_api": "https://cyanlunakanban.vercel.app",
  "kanban_auth_token": "<X-Kanban-Auth token>",
  "access_token": null,
  "refresh_token": null,
  "user_id": null,
  "project_map": {
    "edwards.oqc.infra": { "worklog_type": "work", "eob_project_id": "ac78d5ae-a15e-4a40-9638-8109539d6633", "default_work_type_code": "ENG-SW", "label": "OQC Digitalization Infrastructure" },
    "unify": { "worklog_type": "work", "eob_project_id": "013c7ee7-edcc-46bc-bcc8-55b15bb2481f", "default_work_type_code": "ENG-SW", "label": "Unify Plasma Single" },
    "edwards.operation.board": { "worklog_type": "non-project", "default_work_type_code": "ENG-SW", "label": "Team DX / Productivity" },
    "testrig-dashboard": { "worklog_type": "non-project", "default_work_type_code": "ENG-SW", "label": "Team Work" },
    "3dx.api": { "worklog_type": "non-project", "default_work_type_code": "ENG-SW", "label": "3DX API (Team Work)" },
    "cpet.db": { "worklog_type": "personal" },
    "cpet": { "worklog_type": "personal" },
    "ai.cycling.workout.planner": { "worklog_type": "personal" },
    "ai-cycling-coach": { "worklog_type": "personal" },
    "unahouse.finance": { "worklog_type": "personal" },
    "today.bike": { "worklog_type": "personal" },
    "asan.bicycle": { "worklog_type": "personal" },
    "cyanluna-portfolio": { "worklog_type": "personal" },
    "cyanluna.skills": { "worklog_type": "personal" },
    "bangwahu": { "worklog_type": "personal" },
    "remotion-video-gen": { "worklog_type": "personal" },
    "type1recovery": { "worklog_type": "personal" },
    "kanban-board": { "worklog_type": "personal" }
  }
}

EOB="https://eob.10.182.252.32.sslip.io"
AUTH=$(curl -s -X POST "$EOB/api/auth/login" \
  -H "Content-Type: application/x-www-form-urlencoded" \
  -d "username=$EMAIL&password=$PASSWORD")

TOKEN=$(echo "$AUTH" | python3 -c "import sys,json; print(json.load(sys.stdin)['access_token'])")
REFRESH=$(echo "$AUTH" | python3 -c "import sys,json; print(json.load(sys.stdin)['refresh_token'])")

ME=$(curl -s "$EOB/api/auth/me" -H "Authorization: Bearer $TOKEN")
USER_ID=$(echo "$ME" | python3 -c "import sys,json; print(json.load(sys.stdin)['id'])")

BOARD=$(curl -s "${AUTH_HEADER[@]}" "$KANBAN_API/api/board")
# board.projects = ["project-a", "project-b", ...]
# board.project_settings = { "project-a": {...}, ... }

PROJECTS=$(curl -s "$EOB/api/projects/hierarchy" -H "Authorization: Bearer $TOKEN")

curl -s "${AUTH_HEADER[@]}" -X PUT "$KANBAN_API/api/project-settings/$PROJECT" \
  -H 'Content-Type: application/json' \
  -d '{"worklog_type": "work", "eob_project_id": "...", "label": "..."}'

CONFIG=$(cat ~/.claude/worklog-sync.json)
EOB=...  TOKEN=...  REFRESH=...  USER_ID=...

TODAY=$(date +%Y-%m-%d)
DOW=$(date -d "$TODAY" +%u)
MONDAY=$(date -d "$TODAY -$((DOW-1)) days" +%Y-%m-%d)
SUNDAY=$(date -d "$MONDAY +6 days" +%Y-%m-%d)

KANBAN_API=$(echo "$CONFIG" | python3 -c "import sys,json; print(json.load(sys.stdin).get('kanban_api','https://cyanlunakanban.vercel.app'))")
KANBAN_TOKEN=$(echo "$CONFIG" | python3 -c "import sys,json; print(json.load(sys.stdin).get('kanban_auth_token',''))")
BOARD=$(curl -s -H "X-Kanban-Auth: $KANBAN_TOKEN" "$KANBAN_API/api/board")

EXISTING=$(curl -s "$EOB/api/worklogs?user_id=$USER_ID&start_date=$MONDAY&end_date=$SUNDAY" \
  -H "Authorization: Bearer $TOKEN")

WORK_TYPES=$(curl -s "$EOB/api/work-types/tree" -H "Authorization: Bearer $TOKEN")