move-linked-issue.yml

name: Move Linked Issues to Project Column

on:
  workflow_call:
    inputs:
      pr_number:
        required: true
        type: number
      project_column_name:
        required: true
        type: string
      project_name_prefix:
        required: true
        type: string
    secrets:
      gh_token:
        required: true

jobs:
  move-linked-issues:
    runs-on: ubuntu-latest

    steps:
      - name: Checkout the repository
        uses: actions/checkout@v2

      - name: Install GitHub CLI
        run: |
          curl -sSL https://github.com/cli/cli/releases/latest/download/gh_$(curl -sSL https://api.github.com/repos/cli/cli/releases/latest | jq -r .tag_name | sed 's/^v//')_linux_amd64.tar.gz -o gh.tar.gz
          tar -xzf gh.tar.gz
          sudo cp gh_*/bin/gh /usr/local/bin/
          gh --version

      - name: Authenticate gh CLI
        run: gh auth status
        env:
          GH_TOKEN: ${{ secrets.gh_token }}

      - name: Get linked issue numbers
        id: get_issues
        run: |
          PR_ID=$(gh pr view ${{ inputs.pr_number }} --json id -q .id)

          QUERY='query($id: ID!) { node(id: $id) { ... on PullRequest { closingIssuesReferences(first: 10) { nodes { number id } } } } }'
          gh api graphql -f id="$PR_ID" -f query="$QUERY" > pr_issues.json

          jq -r '.data.node.closingIssuesReferences.nodes[] | "\(.number),\(.id)"' pr_issues.json > issues.csv

          echo "issue_list<<EOF" >> $GITHUB_OUTPUT
          cat issues.csv >> $GITHUB_OUTPUT
          echo "EOF" >> $GITHUB_OUTPUT
        env:
          GH_TOKEN: ${{ secrets.gh_token }}

      - name: Find the latest matching project v2
        id: project
        run: |
          PREFIX="${{ inputs.project_name_prefix }}"
          gh api graphql -f query='{
            organization(login: "TransactionProcessing") {
              projectsV2(first: 100) {
                nodes {
                  id title url createdAt
                }
              }
            }
          }' > all_projects.json

          jq --arg prefix "$PREFIX" '.data.organization.projectsV2.nodes | map(select(.title | startswith($prefix))) | sort_by(.createdAt) | reverse | .[0] | { title, id }' all_projects.json > latest_project.json

          echo "project_id=$(jq -r '.id' latest_project.json)" >> $GITHUB_OUTPUT
        env:
          GH_TOKEN: ${{ secrets.gh_token }}

      - name: Get "Status" field ID and option ID
        id: status_field
        run: |
          PROJECT_ID=${{ steps.project.outputs.project_id }}
          FIELD_NAME="Status"
          STATUS_OPTION_NAME="${{ inputs.project_column_name }}"

          gh api graphql -f query='query($projectId: ID!) {
            node(id: $projectId) {
              ... on ProjectV2 {
                fields(first: 100) {
                  nodes {
                    ... on ProjectV2SingleSelectField {
                      id name options { id name }
                    }
                  }
                }
              }
            }
          }' -f projectId="$PROJECT_ID" > fields.json

          FIELD_ID=$(jq -r '.data.node.fields.nodes[] | select(.name == "'$FIELD_NAME'") | .id' fields.json)
          OPTION_ID=$(jq -r '.data.node.fields.nodes[] | select(.name == "'$FIELD_NAME'") | .options[] | select(.name == "'$STATUS_OPTION_NAME'") | .id' fields.json)

          if [ -z "$FIELD_ID" ] || [ -z "$OPTION_ID" ]; then
            echo "Could not find field or option IDs"
            exit 1
          fi

          echo "field_id=$FIELD_ID" >> $GITHUB_OUTPUT
          echo "option_id=$OPTION_ID" >> $GITHUB_OUTPUT
        env:
          GH_TOKEN: ${{ secrets.gh_token }}

      - name: Debug GH token access
        run: |
          echo "Testing token..."
          gh api user || echo "❌ Token cannot access /user"
          gh api graphql -f query='query { viewer { login } }' || echo "❌ Token cannot query GraphQL viewer"
        env:
          GH_TOKEN: ${{ secrets.gh_token }}

      - name: Map issues to project item IDs (paginated)
        id: map_issues
        run: |
          PROJECT_ID="${{ steps.project.outputs.project_id }}"
          ISSUE_IDS=$(cut -d',' -f2 < issues.csv)

          echo "🔄 Mapping issues to project items using pagination..."
          > item_ids.csv

          END_CURSOR=""
          HAS_NEXT_PAGE=true

          while [ "$HAS_NEXT_PAGE" = true ]; do
            # Build inline query
            if [ -z "$END_CURSOR" ]; then
              QUERY="query { node(id:\"$PROJECT_ID\") { ... on ProjectV2 { items(first:100) { nodes { id content { ... on Issue { id } } } pageInfo { endCursor hasNextPage } } } } }"
            else
              QUERY="query { node(id:\"$PROJECT_ID\") { ... on ProjectV2 { items(first:100, after:\"$END_CURSOR\") { nodes { id content { ... on Issue { id } } } pageInfo { endCursor hasNextPage } } } } }"
            fi

            RESPONSE=$(gh api graphql -f query="$QUERY")

            # Map items
            echo "$RESPONSE" | jq -c '.data.node.items.nodes[]' | while read -r item; do
              ISSUE_ID=$(echo "$item" | jq -r '.content.id')
              ITEM_ID=$(echo "$item" | jq -r '.id')

              if echo "$ISSUE_IDS" | grep -q "$ISSUE_ID"; then
                echo "$ISSUE_ID,$ITEM_ID" >> item_ids.csv
              fi
            done

            HAS_NEXT_PAGE=$(echo "$RESPONSE" | jq -r '.data.node.items.pageInfo.hasNextPage')
            END_CURSOR=$(echo "$RESPONSE" | jq -r '.data.node.items.pageInfo.endCursor')
          done

          echo "🧩 Mapped issues to project items:"
          cat item_ids.csv
        env:
          GH_TOKEN: ${{ secrets.gh_token }}

      - name: Set Status field to selected value
        run: |
          FIELD_ID="${{ steps.status_field.outputs.field_id }}"
          OPTION_ID="${{ steps.status_field.outputs.option_id }}"
          PROJECT_ID="${{ steps.project.outputs.project_id }}"
      
          echo "🔄 Updating status field for project items..."
      
          while IFS=',' read -r ISSUE_ID ITEM_ID; do
            echo "🔧 Updating item $ITEM_ID (Issue ID: $ISSUE_ID)..."
      
            gh api graphql -f query="
              mutation {
                updateProjectV2ItemFieldValue(input: {
                  projectId: \"$PROJECT_ID\",
                  itemId: \"$ITEM_ID\",
                  fieldId: \"$FIELD_ID\",
                  value: {
                    singleSelectOptionId: \"$OPTION_ID\"
                  }
                }) {
                  projectV2Item {
                    id
                  }
                }
              }"
          done < item_ids.csv
        env:
          GH_TOKEN: ${{ secrets.gh_token }}