diff options
Diffstat (limited to 'doc/niels-diplom/Dateistruktur/results/statistic.php')
| -rwxr-xr-x | doc/niels-diplom/Dateistruktur/results/statistic.php | 211 |
1 files changed, 211 insertions, 0 deletions
diff --git a/doc/niels-diplom/Dateistruktur/results/statistic.php b/doc/niels-diplom/Dateistruktur/results/statistic.php new file mode 100755 index 0000000..74e0fb8 --- /dev/null +++ b/doc/niels-diplom/Dateistruktur/results/statistic.php @@ -0,0 +1,211 @@ +<?php + + include("../header.php"); + + $user = $_SESSION['user']; + + $sql = "select max(tmp.versuche) from ERROR_LOG join (SELECT LESSON_ID, count(lesson_ID) as VERSUCHE FROM error_log group by LESSon_ID)tmp on tmp.LESSON_ID=ERROR_LOG.LESSON_ID"; // wieviele Aufgabe sind derzeit aktiv + + $stmt = dbconnect($sql); + + OCIExecute($stmt); + + $nrows = OCIFetchStatement($stmt,$results); + + if ( $nrows == 1 ) + { + OCIExecute($stmt); + + while(OCIFetch($stmt)) + { + $max = OCIResult($stmt, $results); // Anzahl der zu lösenden Aufgaben + } + } + + + $sql = "select LO.NR, VERSUCHE_insgesamt from LESSON_ORDER LO join (SELECT LESSON_ID, count(lesson_ID) as VERSUCHE_insgesamt FROM error_log group by LESSON_ID)tmp on LO.LESSON_ID=tmp.LESSON_ID order by LO.NR"; + + $stmt = dbconnect($sql); + + OCIExecute($stmt); + +?> + + <tr > + <td><div class=titel_15>STATISTIK</div></td> + </tr> + <tr> + <td><br></td> + </tr> + <tr> + <td bgcolor=#e99900 colspan=2><div class=text><b>Überblick über die Lösungsversuche pro Aufgabe:</b></div></td> + </tr> + <tr> + <td> + +<? + + +$nrows = OCIFetchStatement($stmt,$results); //Ergebnisse in Array eintragen... + +if ( $nrows > 0 ) + { + print "<BR><TABLE BORDER=\"1\" class=text>\n"; + print "<TR>\n"; + while ( list( $key, $val ) = each( $results ) ) + { + print "<TH>$key</TH>\n"; + } + print "</TR>\n"; + + for ( $i = 0; $i < $nrows; $i++ ) { + $col=0; + reset($results); + print "<TR>\n"; + while ( $column = each($results) ) + { + $data = $column['value']; + + if ($col==1) + { + $percent = $data[$i] * 100/$max; //wieviel Prozent der aufgaben hat der Student gelöst + + $width = $percent * 400/100; // Darstellung per Balkendiagramm + + if ($percent <= 25) + print "<td width=500> <img src=\"/dipl/css/balken_gruen.gif\" width=$width height=10 > $data[$i] Anfragen</td>"; + if ($percent > 25 and $percent < 50) + print "<td width=500> <img src=\"/dipl/css/balken_orange.gif\" width=$width height=10 > $data[$i] Anfragen</td>"; + if ($percent >= 50) + print "<td width=500> <img src=\"/dipl/css/balken_rot.gif\" width=$width height=10 > $data[$i] Anfragen</td>"; + } + + else + print "<TD>$data[$i]</TD>\n"; + $col++; + } + print "</TR>\n"; + } + print "<tr><td colspan=3 class=text>Verteilung der Anzahl Anfragen nach Aufgaben.<BR></td></tr>"; + print "</TABLE><BR>"; + } + + +?> + +<br><br> +</td> +</tr> +<tr> +<td colspan=2><div class=text> </div></td> +</tr> +<tr> +<td bgcolor=#e99900 colspan=2><div class=text><b>durchschnittlich zur Lösung benötigte Zeit in Tagen:</b>:</div></td> +</tr> +<tr> +<td colspan=2><div class=text> </div></td> +</tr> +<tr> +<td> + +<? + +$sql="select max(schnitt) from LESSON_ORDER LO join (select LESSON_ID, round(sum(time)/count(LESSON_ID),1) as schnitt from (select LESSON_ID, STUD_ID, max(datum) - min(datum) as time from (select stud_ID, datum, LESSON_ID from ERror_log union select stud_ID, datum, LESSON_ID from Logon) group by (LESSON_ID, STUD_ID)) group by LESSON_ID)tmp on LO.LESSON_ID=tmp.LESSON_ID order by LO.NR"; + +$stmt = dbconnect($sql); + + OCIExecute($stmt); + + $nrows = OCIFetchStatement($stmt,$results); + + if ( $nrows == 1 ) + { + OCIExecute($stmt); + + while(OCIFetch($stmt)) + { + $tagmax = OCIResult($stmt, $results); // Anzahl der zu lösenden Aufgaben + } + } + + + + +$sql="select LO.NR, schnitt as \"benötigte Zeit\" from LESSON_ORDER LO join (select LESSON_ID, round(sum(time)/count(LESSON_ID),1) as schnitt from (select LESSON_ID, STUD_ID, max(datum) - min(datum) as time from (select stud_ID, datum, LESSON_ID from ERror_log union select stud_ID, datum, LESSON_ID from Logon) group by (LESSON_ID, STUD_ID)) group by LESSON_ID)tmp on LO.LESSON_ID=tmp.LESSON_ID order by LO.NR";// benötigte Zeit ermitteln... + +$stmt = dbconnect($sql); + +OCIExecute($stmt); + +$nrows = OCIFetchStatement($stmt,$results); + + +if ( $nrows > 0 ) + { + print "<BR><TABLE BORDER=\"1\" class=text width=560>\n"; + print "<TR>\n"; + while ( list( $key, $val ) = each( $results ) ) + { + print "<TH>$key</TH>\n"; + } + print "</TR>\n"; + + for ( $i = 0; $i < $nrows; $i++ ) + { + $col=0; + reset($results); + print "<TR>\n"; + while ( $column = each($results) ) + { + $data = $column['value']; + + if ($col==1) + { + + $wert = (float)(ereg_replace(",", ".", $data[$i])); // umwandeln in float + $percent = $wert * 100/$tagmax; //wieviel Prozent der aufgaben hat der Student gelöst + + $width = $percent * 4; + + if ($percent >= 0 and $percent <= 25) + print "<td width=500> <img src=\"/dipl/css/balken_gruen.gif\" width=$width height=10 > $wert Tage</td>"; + if ($percent > 25 and $percent < 50) + print "<td width=500> <img src=\"/dipl/css/balken_orange.gif\" width=$width height=10 > $wert Tage</td>"; + if ($percent >= 50) + print "<td width=500> <img src=\"/dipl/css/balken_rot.gif\" width=$width height=10 > $wert Tage</td>"; + /*if ($percent == 0) + print "<td width=500> $wert Tage</td>"; + if ($percent > 0 and $percent < 1) + print "<td width=500> <img src=\"/dipl/css/balken_rot.gif\" width=2 height=10 >$wert Tage</td>";*/ + } + + else + print "<TD>$data[$i]</TD>\n"; // Name und vorname ausgeben.... + $col++; + } + print "</TR>\n"; + } + } +else + { + if (isset($_GET['ID'])) + { + $message = "Es sind noch keine Aufgaben gelöst worden...."; + } + + print "<tr><td class=text>" . $message . "<BR></tr></td>"; + } + +?> + +</td> +</tr> + +</table> +</table> +</table> + + +<? +include("../footer.php"); +?>
\ No newline at end of file |