First prototype
diff --git a/.gitignore b/.gitignore
new file mode 100644
index 0000000..53752db
--- /dev/null
+++ b/.gitignore
@@ -0,0 +1 @@
+output
diff --git a/cron/.htaccess b/cron/.htaccess
new file mode 100644
index 0000000..3a42882
--- /dev/null
+++ b/cron/.htaccess
@@ -0,0 +1 @@
+Deny from all
diff --git a/cron/generate.bash b/cron/generate.bash
new file mode 100644
index 0000000..8e0b569
--- /dev/null
+++ b/cron/generate.bash
@@ -0,0 +1,6 @@
+#!/bin/bash
+php generateData.php
+gnuplot generateGraphs.gnu
+mkdir -p ../output
+mv /tmp/covid19graphgenerator-output.png ../output/graph.png
+mv /tmp/covid19graphgenerator-output.svg ../output/graph.svg
diff --git a/cron/generateData.php b/cron/generateData.php
new file mode 100644
index 0000000..fab3093
--- /dev/null
+++ b/cron/generateData.php
@@ -0,0 +1,129 @@
+<?php
+if (php_sapi_name() != "cli")
+  exit();
+
+// Font dels nombres d'habitants: https://catsalut.gencat.cat/web/.content/minisite/catsalut/proveidors_professionals/registres_catalegs/documents/poblacio-referencia.pdf
+$HABITANTS = [
+  "Alt Pirineu i Aran" => 67277,
+  "Lleida" => 362850,
+  "Camp de Tarragona" => 607999,
+  "Terres de l'Ebre" => 176817,
+  "Girona" => 861753,
+  "Catalunya Central" => 526959,
+  "Barcelona" => 5050190
+];
+
+$CODENAME = [
+  "Alt Pirineu i Aran" => "AltPirineuAran",
+  "Lleida" => "Lleida",
+  "Camp de Tarragona" => "CampDeTarragona",
+  "Terres de l'Ebre" => "TerresDeLEbre",
+  "Girona" => "Girona",
+  "Catalunya Central" => "CatalunyaCentral",
+  "Barcelona" => "Barcelona"
+];
+
+function getSumDay($originalDay, $translation, &$dataRegio) {
+  if ($translation >= 0)
+    $day = (clone $originalDay)->add(new DateInterval("P".abs($translation)."D"));
+  else
+    $day = (clone $originalDay)->sub(new DateInterval("P".abs($translation)."D"));
+
+  foreach ($dataRegio as $row) {
+    $rowDay = new DateTime($row["data"]);
+    if ($day == $rowDay) return $row["sum_numcasos"];
+  }
+
+  return 0;
+}
+
+function query($soql) {
+  $raw = file_get_contents("https://analisi.transparenciacatalunya.cat/resource/xuwf-dxjd.json?\$query=".urlencode($soql));
+  return json_decode($raw, true);
+}
+
+$data = query("SELECT data, regiosanitariadescripcio AS regio, sum(numcasos) AS sum_numcasos
+WHERE
+  resultatcoviddescripcio = 'Positiu' AND
+  regiosanitariadescripcio <> 'No classificat'
+GROUP BY regiosanitariadescripcio, data
+ORDER BY data ASC, regiosanitariadescripcio");
+
+$dataPerRegio = [];
+foreach ($data as $row) {
+  if (!isset($dataPerRegio[$row["regio"]])) $dataPerRegio[$row["regio"]] = [];
+  $dataPerRegio[$row["regio"]][] = $row;
+}
+
+$summary = [];
+foreach ($dataPerRegio as $regio => $dataRegio) {
+  $summary[$regio] = [];
+
+  $oldestDay = new DateTime("today");
+  $newestDay = new DateTime();
+  $newestDay->setTimestamp(0);
+
+  foreach ($dataRegio as $row) {
+    $date = new DateTime($row["data"]);
+    if ($date < $oldestDay) $oldestDay = $date;
+    if ($date > $newestDay) $newestDay = $date;
+  }
+
+  $newestDay->sub(new DateInterval("P1D"));
+
+  $rhos = [];
+
+  for ($currentDate = (clone $oldestDay)->add(new DateInterval("P7D")); $currentDate < $newestDay; $currentDate->add(new DateInterval("P1D"))) {
+    $den = getSumDay($currentDate, -4, $dataRegio) + getSumDay($currentDate, -5, $dataRegio) + getSumDay($currentDate, -6, $dataRegio);
+    if ($den == 0) continue;
+
+    $rho = (getSumDay($currentDate, 1, $dataRegio) + getSumDay($currentDate, 0, $dataRegio) + getSumDay($currentDate, -1, $dataRegio))/($den);
+
+    $rhos[] = [
+      "data" => $currentDate->format("c"),
+      "rho" => $rho
+    ];
+  }
+
+  for ($currentDate = (clone $oldestDay)->add(new DateInterval("P14D")); $currentDate < $newestDay; $currentDate->add(new DateInterval("P1D"))) {
+    $sum = 0;
+
+    $p14Date = (clone $currentDate)->sub(new DateInterval("P14D"));
+    $p7Date = (clone $currentDate)->sub(new DateInterval("P7D"));
+
+    foreach ($dataRegio as $row) {
+      $date = new DateTime($row["data"]);
+      if ($date >= $p14Date && $date < $currentDate) {
+        $sum += $row["sum_numcasos"];
+      }
+    }
+
+    $rhoAverage = 0;
+    $rhoCount = 0;
+
+    foreach ($rhos as $row) {
+      $date = new DateTime($row["data"]);
+      if ($date >= $p7Date && $date < $currentDate) {
+        ++$rhoCount;
+        $rhoAverage += $row["rho"];
+      }
+    }
+
+    $rhoAverage /= $rhoCount;
+
+    $summary[$regio][] = [
+      "data" => $currentDate->format("c"),
+      "ia14" => (isset($HABITANTS[$regio]) ? $sum*(1e5/$HABITANTS[$regio]) : null),
+      "rho7" => $rhoAverage
+    ];
+  }
+}
+
+foreach ($summary as $regio => $summaryRegio) {
+  $file = fopen("/tmp/covid19graphgenerator-".$CODENAME[$regio].".dat", "w");
+
+  foreach ($summaryRegio as $row)
+    fwrite($file, $row["data"]." ".$row["ia14"]." ".$row["rho7"]."\n");
+
+  fclose($file);
+}
diff --git a/cron/generateGraphs.gnu b/cron/generateGraphs.gnu
new file mode 100644
index 0000000..abd2f83
--- /dev/null
+++ b/cron/generateGraphs.gnu
@@ -0,0 +1,13 @@
+filesPrefix = '/tmp/covid19graphgenerator-'
+
+set terminal svg size 1200, 1200
+set output '/tmp/covid19graphgenerator-output.svg'
+
+set pointsize 0.75
+load "plot.gnu"
+
+set terminal png size 1600, 1600
+set output '/tmp/covid19graphgenerator-output.png'
+
+set pointsize 1
+load "plot.gnu"
diff --git a/cron/plot.gnu b/cron/plot.gnu
new file mode 100644
index 0000000..7135467
--- /dev/null
+++ b/cron/plot.gnu
@@ -0,0 +1,39 @@
+set xlabel "Casos actius per 10^5 habitants"
+set ylabel "Mitjana taxa de creixement darrers 7 dies"
+set title font "Helvetica,20"
+
+set xrange[0:600]
+set yrange[0:5]
+set samples 1000
+#unset colorbox
+
+set multiplot layout 3,3
+set key off
+set tics out scale 0.5,0.2
+
+min(a, b) = (a < b ? a : b)
+
+# The different colored areas correspond to the classification of the EPG values defined on page 8 at https://biocomsc.upc.edu/en/shared/20200506_report_web_51.pdf
+
+set title "Terres de l'ebre"
+plot 6*x w filledcurve y1=0 lt rgb "#ff9494", 100/x w filledcurve y1=0 lt rgb "#ffe494", 70/x w filledcurve y1=0 lt rgb "#dbff94", 30/x w filledcurve y1=0 lt rgb "#a0ff94", filesPrefix.'TerresDeLEbre.dat' u 2:3 w lp pt 6 lt rgb "black", "< tail -n 1 ".filesPrefix."TerresDeLEbre.dat" u 2:3 w lp pt 7 lt rgb "black"
+
+set title "Camp de Tarragona"
+plot 6*x w filledcurve y1=0 lt rgb "#ff9494", 100/x w filledcurve y1=0 lt rgb "#ffe494", 70/x w filledcurve y1=0 lt rgb "#dbff94", 30/x w filledcurve y1=0 lt rgb "#a0ff94", filesPrefix.'CampDeTarragona.dat' u 2:3 w lp pt 6 lt rgb "black", "< tail -n 1 ".filesPrefix."CampDeTarragona.dat" u 2:3 w lp pt 7 lt rgb "black"
+
+set title "Alt Pirineu, Aran"
+plot 6*x w filledcurve y1=0 lt rgb "#ff9494", 100/x w filledcurve y1=0 lt rgb "#ffe494", 70/x w filledcurve y1=0 lt rgb "#dbff94", 30/x w filledcurve y1=0 lt rgb "#a0ff94", filesPrefix.'AltPirineuAran.dat' u 2:3 w lp pt 6 lt rgb "black", "< tail -n 1 ".filesPrefix."AltPirineuAran.dat" u 2:3 w lp pt 7 lt rgb "black"
+
+set title "Lleida"
+plot 6*x w filledcurve y1=0 lt rgb "#ff9494", 100/x w filledcurve y1=0 lt rgb "#ffe494", 70/x w filledcurve y1=0 lt rgb "#dbff94", 30/x w filledcurve y1=0 lt rgb "#a0ff94", filesPrefix.'Lleida.dat' u 2:3 w lp pt 6 lt rgb "black", "< tail -n 1 ".filesPrefix."Lleida.dat" u 2:3 w lp pt 7 lt rgb "black"
+
+set title "Girona"
+plot 6*x w filledcurve y1=0 lt rgb "#ff9494", 100/x w filledcurve y1=0 lt rgb "#ffe494", 70/x w filledcurve y1=0 lt rgb "#dbff94", 30/x w filledcurve y1=0 lt rgb "#a0ff94", filesPrefix.'Girona.dat' u 2:3 w lp pt 6 lt rgb "black", "< tail -n 1 ".filesPrefix."Girona.dat" u 2:3 w lp pt 7 lt rgb "black"
+
+set title "Catalunya central"
+plot 6*x w filledcurve y1=0 lt rgb "#ff9494", 100/x w filledcurve y1=0 lt rgb "#ffe494", 70/x w filledcurve y1=0 lt rgb "#dbff94", 30/x w filledcurve y1=0 lt rgb "#a0ff94", filesPrefix.'CatalunyaCentral.dat' u 2:3 w lp pt 6 lt rgb "black", "< tail -n 1 ".filesPrefix."CatalunyaCentral.dat" u 2:3 w lp pt 7 lt rgb "black"
+
+set title "Barcelona"
+plot 6*x w filledcurve y1=0 lt rgb "#ff9494", 100/x w filledcurve y1=0 lt rgb "#ffe494", 70/x w filledcurve y1=0 lt rgb "#dbff94", 30/x w filledcurve y1=0 lt rgb "#a0ff94", filesPrefix.'Barcelona.dat' u 2:3 w lp pt 6 lt rgb "black", "< tail -n 1 ".filesPrefix."Barcelona.dat" u 2:3 w lp pt 7 lt rgb "black"
+
+unset multiplot
diff --git a/index.php b/index.php
new file mode 100644
index 0000000..bbab102
--- /dev/null
+++ b/index.php
@@ -0,0 +1,87 @@
+<!DOCTYPE html>
+<html>
+  <head>
+    <meta charset="utf-8">
+    <title>COVID-19 sandbox</title>
+    <meta name="viewport" content="width=device-width, initial-scale=1">
+
+    <style>
+    body {
+      font-family: 'Helvetica', 'Arial', sans-serif;
+    }
+
+    .graphs {
+      max-width: 100%;
+    }
+
+    .key-container {
+      display: inline-block;
+      position: fixed;
+      bottom: 8px;
+      right: 8px;
+      padding: 8px;
+
+      background: white;
+      border-radius: 4px;
+    }
+
+    .key-container h3 {
+      margin: 8px 0 12px 0;
+    }
+
+    .key {
+      border-collapse: collapse;
+    }
+
+    .key td {
+      border: solid 1px black;
+      padding: 2px;
+    }
+
+    .risk {
+      width: 40px;
+    }
+
+    .low-risk {
+      background-color: #a0ff94;
+    }
+
+    .intermediate-risk {
+      background-color: #dbff94;
+    }
+
+    .intermediate-high-risk {
+      background-color: #ffe494;
+    }
+
+    .high-risk {
+      background-color: #ff9494;
+    }
+    </style>
+  </head>
+  <body>
+    <img class="graphs" src="output/graph.svg">
+
+    <div class="key-container">
+      <h3>Llegenda</h3>
+      <table class="key">
+        <tr>
+          <td class="risk low-risk"></td>
+          <td>Risc baix</td>
+        </tr>
+        <tr>
+          <td class="risk intermediate-risk"></td>
+          <td>Risc mitjà</td>
+        </tr>
+        <tr>
+          <td class="risk intermediate-high-risk"></td>
+          <td>Risc mitjà-alt</td>
+        </tr>
+        <tr>
+          <td class="risk high-risk"></td>
+          <td>Risc alt</td>
+        </tr>
+      </table>
+    </div>
+  </body>
+</html>