report for staff

author: Cassio de Campos <cassiopc@gmail.com> 2017-08-04 15:05:57 +0000
committer: Cassio de Campos <cassiopc@gmail.com> 2017-08-04 15:05:57 +0000
commit: 06834f41b66f6c9fd269754f00509c5f360bd109 (patch)
tree: 8ce6c0cc825d28189f9232a27d6c986d537f50f0 /src
parent: 857e6ddffcf242c3140e86cf7a28536ae3ce91be (diff)
download: boca-06834f41b66f6c9fd269754f00509c5f360bd109.tar.gz
boca-06834f41b66f6c9fd269754f00509c5f360bd109.zip
4 files changed, 521 insertions, 0 deletions
diff --git a/src/staff/report/header.php b/src/staff/report/header.php
new file mode 100755
index 0000000..6ebcc32
--- /dev/null
+++ b/src/staff/report/header.php
@@ -0,0 +1,65 @@
+<?php
+////////////////////////////////////////////////////////////////////////////////
+//BOCA Online Contest Administrator
+//    Copyright (C) 2003-2012 by BOCA Development Team (bocasystem@gmail.com)
+//
+//    This program is free software: you can redistribute it and/or modify
+//    it under the terms of the GNU General Public License as published by
+//    the Free Software Foundation, either version 3 of the License, or
+//    (at your option) any later version.
+//
+//    This program is distributed in the hope that it will be useful,
+//    but WITHOUT ANY WARRANTY; without even the implied warranty of
+//    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+//    GNU General Public License for more details.
+//    You should have received a copy of the GNU General Public License
+//    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+////////////////////////////////////////////////////////////////////////////////
+// Last modified 05/aug/2012 by cassio@ime.usp.br
+
+ob_start();
+header ("Expires: " . gmdate("D, d M Y H:i:s") . " GMT");
+header ("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
+header ("Cache-Control: no-cache, must-revalidate");
+header ("Pragma: no-cache");
+header ("Content-Type: text/html; charset=utf-8");
+session_start();
+ob_end_flush();
+//$locr = $_SESSION['locr'];
+//$loc = $_SESSION['loc'];
+$loc = $locr = "../..";
+
+require $locr.'/version.php';
+require_once($locr . "/globals.php");
+if(!ValidSession()) {
+        InvalidSession($_SERVER['PHP_SELF']);
+        ForceLoad($loc."/index.php");
+}
+if($_SESSION["usertable"]["usertype"] != "staff") {
+        IntrusionNotify($_SERVER['PHP_SELF']);
+        ForceLoad($loc."/index.php");
+}
+
+require_once($locr."/db.php");
+require_once($locr."/freport.php");
+
+echo "<html><head><title>Report Page</title>\n";
+echo "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">\n";
+
+echo "<link rel=stylesheet href=\"$loc/Css.php\" type=\"text/css\">\n";
+
+$contest=$_SESSION["usertable"]["contestnumber"];
+if(($ct = DBContestInfo($contest)) == null)
+        ForceLoad($loc."/index.php");
+$site=$_SESSION["usertable"]["usersitenumber"];
+if(($st = DBSiteInfo($contest,$site)) == null)
+        ForceLoad($loc."/index.php");
+
+echo "</head><body><table border=1 width=\"100%\">\n";
+echo "<tr><td bgcolor=\"eeee00\" nowrap align=center>";
+echo "<img src=\"$loc/images/smallballoontransp.png\" alt=\"\">";
+echo "<font color=\"#ffffff\"><a href=\"http://www.ime.usp.br/~cassio/boca/\">BOCA</a></font>";
+echo "</td><td bgcolor=\"#eeee00\" width=\"99%\">\n";
+echo $ct["contestname"] . " - " . $st["sitename"] . "</td>\n";
+echo "</tr></table>\n";
+?>
diff --git a/src/staff/report/linechart.php b/src/staff/report/linechart.php
new file mode 100755
index 0000000..fa47b17
--- /dev/null
+++ b/src/staff/report/linechart.php
@@ -0,0 +1,45 @@
+<?php
+////////////////////////////////////////////////////////////////////////////////
+//BOCA Online Contest Administrator
+//    Copyright (C) 2003-2012 by BOCA Development Team (bocasystem@gmail.com)
+//
+//    This program is free software: you can redistribute it and/or modify
+//    it under the terms of the GNU General Public License as published by
+//    the Free Software Foundation, either version 3 of the License, or
+//    (at your option) any later version.
+//
+//    This program is distributed in the hope that it will be useful,
+//    but WITHOUT ANY WARRANTY; without even the implied warranty of
+//    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+//    GNU General Public License for more details.
+//    You should have received a copy of the GNU General Public License
+//    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+////////////////////////////////////////////////////////////////////////////////
+// Last modified 05/aug/2012 by cassio@ime.usp.br
+
+ob_start();
+header ("Expires: " . gmdate("D, d M Y H:i:s") . " GMT");
+header ("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
+header ("Cache-Control: no-cache, must-revalidate");
+header ("Pragma: no-cache");
+session_start();
+$locr = $_SESSION['locr'];
+$loc = $_SESSION['loc'];
+
+require_once($locr . "/libchart/libchart.php");
+header ("Content-type: image/png");
+ob_end_flush();
+
+$v = explode(chr(1),rawurldecode($_GET['dados']),100);
+
+$chart = new VerticalChart(1000, 300);
+
+$chart->setUpperBound($v[1]);
+
+for($i=2;$i<count($v); $i+=2)
+  $chart->addPoint(new Point($v[$i], $v[$i+1]));
+
+$chart->setTitle($v[0]);
+$chart->setLogo($locr. "/images/poweredbyboca.png");
+$chart->render();
+?>
diff --git a/src/staff/report/piechart.php b/src/staff/report/piechart.php
new file mode 100755
index 0000000..e6dbf95
--- /dev/null
+++ b/src/staff/report/piechart.php
@@ -0,0 +1,68 @@
+<?php
+////////////////////////////////////////////////////////////////////////////////
+//BOCA Online Contest Administrator
+//    Copyright (C) 2003-2012 by BOCA Development Team (bocasystem@gmail.com)
+//
+//    This program is free software: you can redistribute it and/or modify
+//    it under the terms of the GNU General Public License as published by
+//    the Free Software Foundation, either version 3 of the License, or
+//    (at your option) any later version.
+//
+//    This program is distributed in the hope that it will be useful,
+//    but WITHOUT ANY WARRANTY; without even the implied warranty of
+//    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+//    GNU General Public License for more details.
+//    You should have received a copy of the GNU General Public License
+//    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+////////////////////////////////////////////////////////////////////////////////
+// Last modified 05/aug/2012 by cassio@ime.usp.br
+
+ob_start();
+header ("Expires: " . gmdate("D, d M Y H:i:s") . " GMT");
+header ("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
+header ("Cache-Control: no-cache, must-revalidate");
+header ("Pragma: no-cache");
+session_start();
+$locr = $_SESSION['locr'];
+$loc = $_SESSION['loc'];
+
+require_once($locr . "/libchart/libchart.php");
+header("Content-type: image/png");
+ob_end_flush();
+
+$v = explode(chr(1),rawurldecode($_GET['dados']),100);
+$cor = null;
+if(isset($_GET['color']))
+  $cor = explode("-",rawurldecode($_GET['color']),100);
+
+if(count($v)/2 > 8)
+  $chart = new PieChart(450, 300);
+else
+  $chart = new PieChart(400, 250);
+
+if(isset($_GET['order'])) $chart->order=true;
+else $chart->order=false;
+
+$tot=0;
+for($i=1;$i<count($v); $i+=2) {
+	$tot += $v[$i+1];
+}
+for($i=1;$i<count($v); $i+=2) {
+  $color = null;
+  if($cor != null) {
+    $r = hexdec( substr($cor[($i-1)/2], 0, 2) );
+    $g = hexdec( substr($cor[($i-1)/2], 2, 2) );
+    $b = hexdec( substr($cor[($i-1)/2], 4, 2) );
+    $color = array($r, $g, $b);
+  }
+  if($v[$i+1] > $tot/100)
+	  $chart->addPoint(new Point($v[$i], $v[$i+1], $color));
+  else
+	  $chart->addPoint(new Point($v[$i], $tot/100, $color));
+}
+
+$chart->setTitle($v[0]);
+$chart->setLogo($locr. "/images/poweredbyboca.png");
+$chart->render();
+
+?>
diff --git a/src/staff/report/stat.php b/src/staff/report/stat.php
new file mode 100755
index 0000000..8a706e4
--- /dev/null
+++ b/src/staff/report/stat.php
@@ -0,0 +1,343 @@
+<?php
+////////////////////////////////////////////////////////////////////////////////
+//BOCA Online Contest Administrator
+//    Copyright (C) 2003-2012 by BOCA Development Team (bocasystem@gmail.com)
+//
+//    This program is free software: you can redistribute it and/or modify
+//    it under the terms of the GNU General Public License as published by
+//    the Free Software Foundation, either version 3 of the License, or
+//    (at your option) any later version.
+//
+//    This program is distributed in the hope that it will be useful,
+//    but WITHOUT ANY WARRANTY; without even the implied warranty of
+//    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+//    GNU General Public License for more details.
+//    You should have received a copy of the GNU General Public License
+//    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+////////////////////////////////////////////////////////////////////////////////
+// Last modified 05/aug/2012 by cassio@ime.usp.br
+
+require('header.php');
+
+$d = DBRunReport($_SESSION["usertable"]["contestnumber"],$_SESSION["usertable"]["usersitenumber"]);
+
+echo "<center><h2>Statistics</h2></center>\n";
+//----------------------------------------------------------
+echo "<center><h3>Runs by Problem</h3></center>\n";
+echo "<center><table border=1>\n";
+echo "<tr><td><b><u>Problems</u></b></td>";
+
+echo "<td>Total</td><td>Accepted</td>";
+echo "</tr>\n";
+
+$str="All Runs by Problem";
+$str2="Accepted Runs by Problem";
+reset($d['problem']);
+$cor = "";
+while (list($keya, $val) = each($d['problem'])) {
+  $val = $d['problemyes'][$keya]; if($val=="") $val=0; 
+  $str2 .= chr(1) . $keya . "(" . $val . ")" . chr(1) . $val;
+  $cor .= "-" . $d['color'][$keya];
+}
+$cor = substr($cor,1);
+
+reset($d['problem']);
+while (list($keya, $val) = each($d['problem'])) {
+  $str .= chr(1) . $keya . "(" . $val . ")" . chr(1) . $val;
+  echo "<tr><td>$keya ";
+  echo "<img alt=\"balloon\" width=\"15\" ".
+	  "src=\"" . balloonurl($d['color'][$keya]) ."\" />\n";
+  echo "</td>";
+  echo "<td>$val</td>";
+  if(isset($d['problemyes'][$keya])) {
+    echo "<td nowrap>".$d['problemyes'][$keya];
+    if($val != 0) {
+      $p = round(100*$d['problemyes'][$keya] / $val);
+      echo " (".$p."%)";
+    }
+    echo "</td>";
+  }
+  else
+    echo "<td nowrap>0 (0%)</td>";
+  echo "</tr>";
+}
+echo "</table></center>";
+
+echo "<center><table><tr>";
+echo "<td><img alt=\"\" src=\"piechart.php?dados=".rawurlencode($str)."&color=".rawurlencode($cor)."\" /></td>\n";
+echo "<td><img alt=\"\" src=\"piechart.php?dados=".rawurlencode($str2)."&color=".rawurlencode($cor)."\" /></td></tr></table></center>\n";
+
+//----------------------------------------------------------
+echo "<center><h3>Runs by Problem and Answer</h3></center>\n";
+echo "<center><table border=1>\n";
+echo "<tr><td><b><u>Problems x Answers</u></b></td>";
+reset($d['answer']);
+while (list($key, $val) = each($d['answer']))
+  echo "<td>$key</td>";
+echo "<td>Total</td></tr>\n";
+
+reset($d['problem']);
+while (list($keya, $vala) = each($d['problem'])) {
+  echo "<tr><td>$keya ";
+  echo "<img alt=\"balloon\" width=\"15\" ".
+	  "src=\"" . balloonurl($d['color'][$keya]) ."\" />\n";
+  echo "</td>";
+  reset($d['answer']);
+  while (list($key, $val) = each($d['answer'])) {
+    if(!isset($d['pa'][$keya][$key]))
+	echo "<td>0</td>";
+    else {
+        $p = round(100*$d['pa'][$keya][$key] / $vala);
+        echo "<td nowrap>".$d['pa'][$keya][$key]." (".$p."%)</td>";
+    }
+  }
+  echo "<td>$vala</td>";
+  echo "</tr>";
+}
+echo "</table></center>";
+
+//----------------------------------------------------------
+echo "<center><h3>Runs by Problem and Language</h3></center>\n";
+echo "<center><table border=1>\n";
+echo "<tr><td><b><u>Problems x Languages</u></b></td>";
+reset($d['language']);
+while (list($key, $val) = each($d['language']))
+  echo "<td>$key</td>";
+echo "<td>Total</td></tr>\n";
+
+reset($d['problem']);
+while (list($keya, $vala) = each($d['problem'])) {
+  echo "<tr><td>$keya ";
+  echo "<img alt=\"balloon\" width=\"15\" ".
+	  "src=\"" . balloonurl($d['color'][$keya]) ."\" />\n";
+  echo "</td>";
+  reset($d['language']);
+  while (list($key, $val) = each($d['language'])) {
+    if(!isset($d['pl'][$keya][$key]))
+	echo "<td>0</td>";
+    else {
+        $p = round(100*$d['pl'][$keya][$key] / $vala);
+        echo "<td nowrap>".$d['pl'][$keya][$key]." (".$p."%)</td>";
+    }
+  }
+  echo "<td>$vala</td>";
+  echo "</tr>";
+}
+echo "</table></center>";
+
+//----------------------------------------------------------
+echo "<br />";
+echo "<hr />";
+echo "<center><h3>Runs by Language</h3></center>\n";
+echo "<center><table border=1>\n";
+echo "<tr><td><b><u>Languages</u></b></td>";
+
+echo "<td>Total</td><td>Accepted</td>";
+echo "</tr>\n";
+
+$str="All Runs by Language";
+$str2="Accepted Runs by Language";
+reset($d['language']);
+while (list($keya, $val) = each($d['language'])) {
+  $val = $d['languageyes'][$keya]; if($val=="") $val=0; 
+  $str2 .= chr(1) . $keya . "(" . $val . ")" . chr(1) . $val;
+}
+
+reset($d['language']);
+while (list($keya, $val) = each($d['language'])) {
+  $str .= chr(1) . $keya . "(" . $val . ")" . chr(1) . $val;
+  echo "<tr><td>$keya</td>";
+  echo "<td>$val</td>";
+  if(isset($d['languageyes'][$keya])) {
+    $p = round(100*$d['languageyes'][$keya] / $val);
+    echo "<td nowrap>".$d['languageyes'][$keya]." (".$p."%)</td>";
+  }
+  else
+    echo "<td nowrap>0 (0%)</td>";
+  echo "</tr>";
+}
+echo "</table></center>";
+
+echo "<center><table><tr>";
+echo "<td><img alt=\"\" src=\"piechart.php?dados=".rawurlencode($str)."\" /></td>\n";
+echo "<td><img alt=\"\" src=\"piechart.php?dados=".rawurlencode($str2)."\" /></td></tr></table></center>\n";
+
+//----------------------------------------------------------
+echo "<center><h3>Runs by Language and Answer</h3></center>\n";
+echo "<center><table border=1>\n";
+echo "<tr><td><b><u>Languages x Answers</u></b></td>";
+reset($d['answer']);
+while (list($key, $val) = each($d['answer']))
+  echo "<td>$key</td>";
+echo "<td>Total</td></tr>\n";
+
+reset($d['language']);
+while (list($keya, $vala) = each($d['language'])) {
+  echo "<tr><td>$keya</td>";
+  reset($d['answer']);
+  while (list($key, $val) = each($d['answer'])) {
+    if(!isset($d['la'][$keya][$key]))
+	echo "<td>0</td>";
+    else {
+        $p = round(100*$d['la'][$keya][$key] / $vala);
+        echo "<td nowrap>".$d['la'][$keya][$key]." (".$p."%)</td>";
+    }
+  }
+  echo "<td>$vala</td>";
+  echo "</tr>";
+}
+echo "</table></center>";
+
+//----------------------------------------------------------
+echo "<br />";
+echo "<hr />";
+echo "<center><h3>Runs by Answer</h3></center>\n";
+
+echo "<center><table><tr>";
+echo "<td>";
+
+echo "<center><table border=1>\n";
+echo "<tr><td><b><u>Answers</u></b></td>";
+
+echo "<td>Answers</td>";
+echo "</tr>\n";
+
+$str="All Runs by Answer";
+reset($d['answer']);
+while (list($keya, $val) = each($d['answer'])) {
+  $str .= chr(1) . $keya . "(" . $val . ")" . chr(1) . $val;
+  echo "<tr><td>$keya</td>";
+  echo "<td>$val</td>";
+  echo "</tr>";
+}
+echo "</table></center>";
+
+echo "</td>";
+echo "<td><img alt=\"\" src=\"piechart.php?order=1&dados=".rawurlencode($str)."\" /></td></tr></table></center>\n";
+
+//----------------------------------------------------------
+echo "<br />";
+echo "<hr />";
+echo "<center><h3>Runs by User and Problem</h3></center>\n";
+echo "<center><table border=1>\n";
+echo "<tr><td><b><u>Users x Problems</u></b></td>";
+reset($d['problem']);
+while (list($key, $val) = each($d['problem'])) {
+  echo "<td>$key ";
+  echo "<img alt=\"balloon\" width=\"15\" ".
+	  "src=\"" . balloonurl($d['color'][$key]) ."\" />\n";
+  echo "</td>";
+}
+echo "<td>Total</td><td>Accepted</td></tr>\n";
+
+reset($d['username']);
+while (list($keya, $vala) = each($d['username'])) {
+  $keya = $d['username'][$keya];
+  if(isset($d['user'][$keya]))
+	  $vala = $d['user'][$keya];
+  else $vala=0;
+  echo "<tr><td>".$d['userfull'][$keya]."</td>";
+  reset($d['problem']);
+  while (list($key, $val) = each($d['problem'])) {
+    if(!isset($d['up'][$keya][$key]))
+	echo "<td bgcolor=\"ffff88\">0</td>";
+    else {
+	$q = $d['up'][$keya][$key];
+	$color = "ff5555";
+        if($q < 0) {
+		$q = - $q;
+		$color = "22ee22";
+	}
+        echo "<td nowrap bgcolor=\"$color\">".$q;
+	if($vala != 0) {
+          $p = round(100*$q / $vala);
+          echo " (".$p."%)";
+	}
+	echo "</td>";
+    }
+  }
+  if($vala != "")
+    echo "<td>$vala</td>";
+  else
+    echo "<td>0</td>";
+  if(isset($d['useryes'][$keya])) {
+    if($vala != 0) {
+      $p = round(100*$d['useryes'][$keya] / $vala);
+      echo "<td nowrap>".$d['useryes'][$keya]." (".$p."%)</td>";
+    } else
+      echo "<td>".$d['useryes'][$keya]."</td>";
+  } else
+    echo "<td>0</td>";
+
+  echo "</tr>";
+}
+echo "</table></center>";
+
+//----------------------------------------------------------
+echo "<br />";
+echo "<hr />";
+echo "<center><h3>Runs by Time Period</h3></center>\n";
+
+$vezes = 30;
+$passo = $st['siteduration']/$vezes;
+$atual = 0;
+$pos = 0;
+$res = array();
+$m = 0;
+sort($d['timestamp']);
+reset($d['timestamp']);
+while (list($keya, $val) = each($d['timestamp'])) {
+  while($atual+$passo < $val) {
+    $atual += $passo;
+    $pos++;
+  }
+  if(isset($res[$pos]))
+	  $res[$pos]++;
+  else $res[$pos]=1;
+  if($res[$pos] > $m) $m=$res[$pos];
+}
+
+$str="Runs by Time Period" . chr(1) . $m;
+$atual=0;
+for($pos=0; $pos<$vezes; $pos++) {
+  if(!isset($res[$pos]) || $res[$pos]=="") $res[$pos] = 0;
+  $q = (int) ($atual/60);
+  $atual += $passo;
+  $qq = (int) ($atual/60);
+  $str .= chr(1) . $q . "-" .$qq . chr(1) . $res[$pos];
+}
+
+echo "<center><img alt=\"\" src=\"linechart.php?dados=".rawurlencode($str)."\" /></center>\n";
+
+//------------------------------------------------
+$vezes = 30;
+$passo = $st['siteduration']/$vezes;
+$atual = 0;
+$pos = 0;
+$res = array();
+sort($d['timestampyes']);
+reset($d['timestampyes']);
+while (list($keya, $val) = each($d['timestampyes'])) {
+  while($atual+$passo < $val) {
+    $atual += $passo;
+    $pos++;
+  }
+  if(isset($res[$pos]))
+	  $res[$pos]++;
+  else $res[$pos]=1;
+}
+
+$str="Accepted Runs by Time Period" . chr(1) . $m;
+$atual=0;
+for($pos=0; $pos<$vezes; $pos++) {
+  if(!isset($res[$pos]) || $res[$pos]=="") $res[$pos] = 0;
+  $q = (int) ($atual/60);
+  $atual += $passo;
+  $qq = (int) ($atual/60);
+  $str .= chr(1) . $q . "-" .$qq . chr(1) . $res[$pos];
+}
+
+echo "<center><img alt=\"\" src=\"linechart.php?dados=".rawurlencode($str)."\" /></center>\n";
+
+include("$locr/footnote.php");
+?>
author	Cassio de Campos <cassiopc@gmail.com>	2017-08-04 15:05:57 +0000
committer	Cassio de Campos <cassiopc@gmail.com>	2017-08-04 15:05:57 +0000
commit	06834f41b66f6c9fd269754f00509c5f360bd109 (patch)
tree	8ce6c0cc825d28189f9232a27d6c986d537f50f0 /src
parent	857e6ddffcf242c3140e86cf7a28536ae3ce91be (diff)
download	boca-06834f41b66f6c9fd269754f00509c5f360bd109.tar.gz boca-06834f41b66f6c9fd269754f00509c5f360bd109.zip