pms-task（经前管理系统任务）

PMS Task Addition (Bug & Feature)

Streamlined workflow for logging PMS bugs AND features to GitHub and Google Sheets.

Trigger

User message contains:

• "PMS Bug addition" → Creates a BUG report
• "PMS Feature addition" → Creates a FEATURE request

Workflow

1. Determine Task Type

Based on trigger phrase:

2. Collect Task Information

Ask the user for (if not provided):

• Title: Brief summary
• Description: What's happening (bug) or what's needed (feature)
• Reproduction Steps: (Bugs only) How to reproduce
• Expected Outcome: What should happen
• Priority: P0 (Critical) / P1 (High) / P2 (Medium) / P3 (Low)

3. Create GitHub Issue

For BUGS:

gh issue create --repo roshanasingh4/apni-pathshala-pms \
  --title "<title>" \
  --body "$(cat <<EOF
## Description
<description>

## Steps to Reproduce
1. <step 1>
2. <step 2>
3. <step 3>

## Expected Outcome
<expected outcome>

## Actual Outcome
<what actually happened>
EOF
)" \
  --label "bug,<priority>" \
  --assignee roshanasingh4

For FEATURES:

gh issue create --repo roshanasingh4/apni-pathshala-pms \
  --title "<title>" \
  --body "$(cat <<EOF
## Feature Request
<description>

## Expected Behavior
<expected outcome>

## Use Case
Why is this feature needed?
EOF
)" \
  --label "enhancement,<priority>" \
  --assignee roshanasingh4

Capture the issue URL from output for the sheet.

4. Update PMS Task Tracker Sheet

Sheet ID: 1O07SzGzQa2FwpkBE7h2SUDWZlxsUpz8DxCpyxKjRi8U Tab: Production

Column Mapping (A-K)

Label to Sheet Mapping

Get Next Task ID

gog sheets get 1O07SzGzQa2FwpkBE7h2SUDWZlxsUpz8DxCpyxKjRi8U "Production!A:A" --json | jq '.values | .[-1][0]'

Then increment the number.

Append to Sheet (BUG)

gog sheets append 1O07SzGzQa2FwpkBE7h2SUDWZlxsUpz8DxCpyxKjRi8U "Production!A:K" \
  --values-json '[["PMS-TSK-XXX","<title>","Tara Singh Kharwad","DD/MM/YYYY","New","Issue","Low","tarasinghrajput7261@gmail.com","<github_url>","",""]]' \
  --insert INSERT_ROWS

Append to Sheet (FEATURE)

gog sheets append 1O07SzGzQa2FwpkBE7h2SUDWZlxsUpz8DxCpyxKjRi8U "Production!A:K" \
  --values-json '[["PMS-TSK-XXX","<title>","Tara Singh Kharwad","DD/MM/YYYY","New","Feature","Low","tarasinghrajput7261@gmail.com","<github_url>","",""]]' \
  --insert INSERT_ROWS

5. Update Team Daily Update Sheet

Sheet ID: 1GgRgfVBrF-ReGPRmntT6Cm2BjiLzJ3JiBaC4lMfrMQs

Find row with today's date, append to Column B with format:

- PMS - <title> - <github_url>

Format for Daily Tasks

Each day's tasks are in a single cell with headings and bullet points:

- PMS - Fixed login button issue - https://github.com/...
- PMS - Added export feature - https://github.com/...

Get Today's Row

# Find row with today's date
gog sheets get 1GgRgfVBrF-ReGPRmntT6Cm2BjiLzJ3JiBaC4lMfrMQs "Sheet1!A:B" --json
# Look for today's date (DD/MM/YYYY) in Column A

Update Cell

# Append to existing content in Column B
gog sheets update 1GgRgfVBrF-ReGPRmntT6Cm2BjiLzJ3JiBaC4lMfrMQs "Sheet1!B<row>" \
  --values-json '[["<existing_content>\
- PMS - <title> - <github_url>"]]'

Priority Guide

Example Usage

Bug Example

User: "PMS Bug addition - Login page crashes on mobile"

Response:

1. Detect: BUG → GitHub label: bug, Sheet type: Issue
2. Ask for details (steps, expected outcome, priority)
3. Create GitHub issue with bug template → get URL
4. Get next Task ID from sheet
5. Append to PMS Task Tracker with Task type = "Issue"
6. Update Team Daily Update sheet with new entry

Feature Example

User: "PMS Feature addition - Add dark mode support"

Response:

1. Detect: FEATURE → GitHub label: enhancement, Sheet type: Feature
2. Ask for details (description, expected behavior, use case, priority)
3. Create GitHub issue with feature template → get URL
4. Get next Task ID from sheet
5. Append to PMS Task Tracker with Task type = "Feature"
6. Update Team Daily Update sheet with new entry

Quick Reference

Notes

• Reporter is ALWAYS "Tara Singh Kharwad"
• Assigned To is ALWAYS "tarasinghrajput7261@gmail.com"
• Resolution Notes = GitHub issue URL
• "Took Help from Roshan" is left empty (Tara fills manually)
• Date format: DD/MM/YYYY only
• Status starts as "New"