import { aq, op } from "@uwdata/arquero"
d3 = require("d3")

token = localStorage.getItem('ath_token')

results_raw = await fetch("https://api.andrewheiss.com/research_progress", {
  body: "",
  headers: {
    "Authorization": `Bearer ${token}`,
    "content-type": "application/json"
  },
  method: "POST",
  mode: "cors"
}).then(response => {
  return response.json();
})

results_raw.pipeline = results_raw.pipeline.filter(d => d.Status !== "On hold")

pipeline = aq.from(results_raw.pipeline)

scores = aq.from(results_raw.scores)
  .filter(d => d.Status !== "On hold")

// Extract an array of the scores for plot ordering
score_order = scores
  .select("Status_plot")
  .objects()
  .map(d => d.Status_plot)

pipeline_summary = pipeline
  .rollup({
    avg_score: d => op.mean(d.Score),
    sd_score: d => op.stdev(d.Score),
    count: d => op.count(),
    total_points: d => op.sum(d.Score)
  })
  
unfinished_summary = pipeline
  .filter(d => d.Status !== "Accepted")
  .rollup({
    count: d => op.count()
  })

avg_score = pipeline_summary.get("avg_score").toFixed(2)
sd_score = pipeline_summary.get("sd_score").toFixed(2)
project_count = unfinished_summary.get("count")
total_points = pipeline_summary.get("total_points")