g.V().hasLabel('Application').
  fold().as('x', 'y').
  choose(
    unfold().count().is(eq(0)),  // If no applications exist
    limit(0),  // Returns empty traversal (shows "No data")
    math('x / y * 100').
      by(unfold().has('review_date').count()).
      by(unfold().count()).
      map{Math.round(it.get())}
  )

numberOfAppsWithoutOwner =
  g.V().
    hasLabel('Server').
    filter(inE('Owns')).
    count().
    next()

numberOfApps =
  g.V().
    hasLabel('Server').
    count().
    next()

numberOfApps == 0 ? 0 : Math.ceil(100 * numberOfAppsWithoutOwner / numberOfApps)

//Calculate the number of business systems that are deployed
numberOfBusinessSystems =
  g.V().
    hasLabel('Application','Server','Data Store','Technology Service').
    and(
      inE('Deploys To')
    ).
    count().
    next()

//Calculate the total number of business systems    
totalNumberOfBusinessSystems =
  g.V().
    hasLabel('Application','Server','Data Store','Technology Service').
    count().
    next()

totalNumberOfBusinessSystems == 0 ? 0 : Math.round(100 * numberOfBusinessSystems / totalNumberOfBusinessSystems)

//Calculate the number of deployed technology products that are impacted by a vulnerability
numberOfDeployedTechnologiesImpactedByVulnerability =
  g.V().
    hasLabel('Technology Product').
    and(
      inE('Impacts'),
      outE('Deploys To')
    ).
    count().
    next()

// Calculate the total number of deployed technology products    
numberOfTechnologies =
  g.V().
    hasLabel('Technology Product').
    and(
      outE('Deploys To')
    ).
    count().
    next()

numberOfTechnologies == 0 ? 0 : Math.round(100 * numberOfDeployedTechnologiesImpactedByVulnerability / numberOfTechnologies)

//Get today's date in the format 'yyyy-MM-dd'
today = new Date().format('yyyy-MM-dd')

//Calculate the number of deployed technology products that are out of support
numberOfDeployedTechnologiesOutOfSupport =
  g.V().
    hasLabel('Technology Product').
    filter(outE('Deploys To')).
    has('out_of_support', true).
    values('support_end_date').
    count().
    next()
    
numberOfDeployedTechnologies =
  g.V().
    hasLabel('Technology Product').
    filter(outE('Deploys To')).
    count().
    next()

numberOfDeployedTechnologies == 0 ? 0 : Math.round(100 * numberOfDeployedTechnologiesOutOfSupport / numberOfDeployedTechnologies)

g.inject(1)
  .project('a', 'b')
    .by(
      coalesce(
        __.V().hasLabel('Initiative')
          .has('initiative_stage', 'In Progress')
          .values('total_budgeted_cost')
          .sum(),
        __.constant(0)
      )
    )
    .by(
      coalesce(
        __.V().hasLabel('Initiative')
          .has('initiative_stage', 'In Progress')
          .values('total_cost')
          .sum(),
        __.constant(0)
      )
    )
  .math('a - b')

numberOfObjsWithIni =
  g.V().
    hasLabel('Initiative').
    filter(__.in('Is Realized By').hasLabel('Objective')).
    count().
    next()

numberOfObjs =
  g.V().
    hasLabel('Initiative').
    count().
    next()

numberOfObjs == 0 ? 0 : Math.ceil(numberOfObjsWithIni / numberOfObjs * 100)

utcFormat = "yyyy-MM-dd'T'HH:mm:ss.SSSX";
tc = groovy.time.TimeCategory;
debtAge = { 
  values('created').
  map{
    tc.minus(today, Date.parse(utcFormat, it.get())).days;
  } 
}
daysBetweenDates = { startDateFieldName, endDateFieldName -> { it ->
  startDate = Date.parse(
    'yyyy-MM-dd',
    it.get().value(startDateFieldName)
  ).toInstant()
  endDate = Date.parse(
    'yyyy-MM-dd',
    it.get().value(endDateFieldName)
  ).toInstant()
  startDate.until(endDate, java.time.temporal.ChronoUnit.DAYS);
} }

today = new Date().next()
aYearAgo = (today - 365).format('yyyy-MM-dd').next()

numDebts = g.V().hasLabel('Debt Item').has('created', gt(aYearAgo)).count().next()

// Return 0 if no debt items exist, otherwise calculate average age
numDebts == 0 ? 0 :
  Math.round(
    g.V().hasLabel('Debt Item').has('created', gt(aYearAgo)).
      choose(
        or(__.has('debt_action', 'Remediated'), __.has('debt_action', 'Ignore')), 
        map(daysBetweenDates('created', 'review_date')), 
        debtAge()
      ).
      sum().
      next() / numDebts
  )

g.E().hasLabel('Depends On').filter(and(__.outV().hasLabel('Solution Health Check'), __.inV().hasLabel('Requirement')))
   .project('Health Check Name','Application(s)', 'Context', 'Conclusions', 'Rationale', 'Live Start', 'Live End', 'Approved By', 'Quality Characteristic', 'Importance', 'Level of Concern', 'Comments', 'Recommendations')
      .by(outV().values('name'))
      .by(outV().out('Has Subject').values('name').fold().map{it.get().join(', ')})
      .by(outV().values('concern'))
      .by(outV().values('recommendations'))
      .by(outV().values('rationale'))
      .by(outV().values('live_start_date'))
      .by(outV().values('live_end_date'))
      .by(outV().out('Approved By').values('name').fold().map{it.get().join(', ')})
      .by(inV().values('name'))
      .by(values('importance'))
      .by(values('level_of_concern'))
      .by(values('comments'))
      .by(values('recommendations'))

g.E().hasLabel('Depends On').filter(and(__.outV().hasLabel('Solution Health Check').or(has('live_status', 'Proposed'), has('live_status', 'Live')), __.inV().hasLabel('Requirement')))
   .project('Health Check Name','Application(s)', 'Quality Characteristic', 'Importance', 'Level of Concern', 'Comments', 'Recommendations')
      .by(outV().values('name'))
      .by(outV().out('Has Subject').values('name').fold().map{it.get().join(', ')})
      .by(inV().values('name'))
      .by(values('importance'))
      .by(values('level_of_concern'))
      .by(values('comments'))
      .by(values('recommendations'))

g.V().hasLabel('Solution Health Check')
// find all live Solution Health Checks
  .has('live_status', 'Live')
// with at least 1 urgent quality characteristic / sub-characteristic
  .filter(__.outE('Depends On').and(has('importance', gte(3)), has('level_of_concern', gte(3))))
  .project('Health Check Name', 'Subject(s)', 'Urgent Characteristic(s)'

//  Uncomment the line below if you link Solution Health Checks to Initiatives or Debt Items, add their workspaces in Data Selection, and add the 'Action' column in Data presentation
//      , 'Action'
    )
  .by(values('name'))
  .by(out('Has Subject').values('name').fold().map{it.get().join(', ')})
  .by(outE('Depends On').and(has('importance', gte(3)), has('level_of_concern', gte(3))).inV().values('name').fold().map{it.get().join(', ')})

// Uncomment the line below if you link Solution Health Checks to Initiatives but not to Debt Items
//  .by(choose(__.out('Refers To').hasLabel('Initiative'), constant('Initiative'), constant('None')))

// Uncomment the 3 lines below if you link Solution Health Checks to Initiatives and/or Debt Items
//  .by(choose(and(__.out('Refers To').hasLabel('Initiative'), __.out('Refers To').hasLabel('Debt Item').in('Impacts').hasLabel('Initiative')), constant('Initiative and Actioned Debt Item'), 
//        choose(__.out('Refers To').hasLabel('Debt Item').in('Impacts').hasLabel('Initiative'), constant('Actioned Debt Item'),
//          choose(__.out('Refers To').hasLabel('Initiative'), constant('Initiative'), constant('None')))))

g.V()
  .hasLabel('Application')
  .project('Application', 'MTPD', 'DR Plan RTO', 'Service Gap Status')
    .by(__.values('name'))
    .by(
      __.in('Has Subject').values('mtpd').fold()
        .coalesce(__.unfold().limit(1), __.constant(null))
    )
    .by(
      __.in('Has Subject').values('dr_plan_rto').fold()
        .coalesce(__.unfold().limit(1), __.constant(null))
    )
    .by(
      __.choose(
        __.and(
          __.in('Has Subject').values('mtpd').count().is(gte(1)),
          __.in('Has Subject').values('dr_plan_rto').count().is(gte(1))
        ),
        __.project('m', 'r')
          .by(__.in('Has Subject').values('mtpd').fold().coalesce(__.unfold().limit(1), __.constant(0)))
          .by(__.in('Has Subject').values('dr_plan_rto').fold().coalesce(__.unfold().limit(1), __.constant(0)))
          .math('r - m')
          .choose(
            __.is(gt(0)),
            __.constant('Gap: Exceeds Tolerance'),
            __.constant('Validated: Within Tolerance')
          ),
        __.constant('Unknown: Not Validated')
      )
    )