set-start-end-date-issue-status.yml

name: Set Start and End Dates Based on Status

on:
  issues:
    types: [edited]

jobs:
  update-date-fields:
    runs-on: ubuntu-latest
    steps:
      - name: Update Start and End Date Fields
        uses: actions/github-script@v6
        with:
          github-token: ${{ secrets.GH_TOKEN }}
          script: |
            const projectId = 'PVT_kwDOAFK5-84Ak8oz'; 
            let issueNodeId;
            let statusFieldId;
            let startDateFieldId;
            let endDateFieldId;

            const issueAction = context.payload.action;
            if (issueAction === 'edited') {
              console.log('The issue was edited!');
            } else {
              console.log(`The issue was not edited. It was ${issueAction}.`);
            }

            // Check if the issue was edited (i.e., status field was changed)
            if (context.payload.issue) {
              issueNodeId = context.payload.issue.node_id;  // Issue update
            } else {
              console.log('This action was triggered without an issue.');
              return;
            }

            // Step 1: Fetch Project Fields dynamically
            const { data: projectData } = await github.graphql(`
              query($projectId: ID!) {
                node(id: $projectId) {
                  ... on ProjectV2 {
                    fields(first: 20) {
                      nodes {
                        __typename
                        ... on ProjectV2SingleSelectField {
                          id
                          name
                          options {
                            id
                            name
                          }
                        }
                        ... on ProjectV2Field {
                          id
                          name
                        }
                      }
                    }
                  }
                }
              }
            `, {
              projectId: projectId
            });

            // Extract the necessary field IDs dynamically
            const statusField = projectData.node.fields.nodes.find(field => field.name === 'Status');
            const startDateField = projectData.node.fields.nodes.find(field => field.name === 'Start Date' && field.__typename === 'ProjectV2Field');
            const endDateField = projectData.node.fields.nodes.find(field => field.name === 'End Date' && field.__typename === 'ProjectV2Field');

            if (!statusField || !startDateField || !endDateField) {
              console.log('One or more required fields (Status, Start Date, End Date) not found.');
              return;
            }

            statusFieldId = statusField.id;
            startDateFieldId = startDateField.id;
            endDateFieldId = endDateField.id;

            console.log(`Status Field ID: ${statusFieldId}`);
            console.log(`Start Date Field ID: ${startDateFieldId}`);
            console.log(`End Date Field ID: ${endDateFieldId}`);

            // Step 2: Fetch the issue's current status from the projectV2Item
            const { data: issueData } = await github.graphql(`
              query($projectId: ID!, $issueId: ID!) {
                node(id: $issueId) {
                  ... on Issue {
                    projectV2Items(first: 1, projectId: $projectId) {
                      nodes {
                        fieldValues(first: 10) {
                          nodes {
                            projectV2Field {
                              id
                              name
                            }
                            value
                          }
                        }
                      }
                    }
                  }
                }
              }
            `, {
              projectId: projectId,
              issueId: issueNodeId
            });

            // Check if data is returned
            if (!issueData || !issueData.node || !issueData.node.projectV2Items.nodes[0]) {
              console.log('No projectV2Item found for this issue.');
              return;
            }

            const projectItem = issueData.node.projectV2Items.nodes[0];

            // Find the Status field value
            const statusFieldValue = projectItem.fieldValues.nodes.find(field => field.projectField.id === statusFieldId)?.value;

            if (!statusFieldValue) {
              console.log('Status field not found or not updated.');
              return;
            }

            const now = new Date().toISOString();  // Current date and time in ISO format

            console.log(`Issue status: ${statusFieldValue}`);

            // Step 3: Update Start Date for "In Progress" status
            if (statusFieldValue === 'In Progress') {
              console.log(`Updating Start Date for issue ${issueNodeId}`);
              await github.graphql(`
                mutation($projectId: ID!, $itemId: ID!, $fieldId: ID!, $value: String!) {
                  updateProjectV2ItemFieldValue(input: {
                    projectId: $projectId,
                    itemId: $itemId,
                    fieldId: $fieldId,
                      value: { 
                        date: $value
                    }
                  }) {
                    projectV2Item {
                      id
                    }
                  }
                }
              `, {
                projectId: projectId,
                itemId: issueNodeId,
                fieldId: startDateFieldId,
                value: now
              });

              console.log(`Start date set to ${now} for issue.`);
            }

            // Step 4: Update End Date for "Done" status
            if (statusFieldValue === 'Done') {
              console.log(`Updating End Date for issue ${issueNodeId}`);
              await github.graphql(`
                mutation($projectId: ID!, $itemId: ID!, $fieldId: ID!, $value: String!) {
                  updateProjectV2ItemFieldValue(input: {
                    projectId: $projectId,
                    itemId: $itemId,
                    fieldId: $fieldId,
                    value: { 
                        date: $value
                    }
                  }) {
                    projectV2Item {
                      id
                    }
                  }
                }
              `, {
                projectId: projectId,
                itemId: issueNodeId,
                fieldId: endDateFieldId,
                value: now
              });

              console.log(`End date set to ${now} for issue.`);
            }