reussite.php 3.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117
  1. <?php
  2. /* For licensing terms, see /license.txt */
  3. /**
  4. * Old reporting file - probably not used anymore
  5. * @package chamilo.reporting
  6. */
  7. /**
  8. * Code
  9. */
  10. // TODO: Is this file used?
  11. $nameTools = 'Reussite';
  12. $cidReset = true;
  13. require '../inc/global.inc.php';
  14. $this_section = "session_my_space";
  15. api_block_anonymous_users();
  16. $interbreadcrumb[] = array ("url" => "index.php", "name" => get_lang('MySpace'));
  17. Display :: display_header($nameTools);
  18. // Database Table Definitions
  19. $tbl_course = Database :: get_main_table(TABLE_MAIN_COURSE);
  20. $tbl_user = Database :: get_main_table(TABLE_MAIN_USER);
  21. $tbl_session_course = Database :: get_main_table(TABLE_MAIN_SESSION_COURSE);
  22. $tbl_session = Database :: get_main_table(TABLE_MAIN_SESSION);
  23. $tbl_track_exercice = Database :: get_main_table(TABLE_STATISTIC_TRACK_E_EXERCISES);
  24. /*
  25. ===============================================================================
  26. MAIN CODE
  27. ===============================================================================
  28. */
  29. if (!empty($_GET['session'])) {
  30. $sql_session = "SELECT name,id
  31. FROM $tbl_session
  32. ORDER BY name ASC";
  33. $result_session = Database::query($sql_session);
  34. echo "<a href='".api_get_self()."'>".get_lang('MoyCourse')."</a>";
  35. echo "<br /><br />";
  36. if (Database::num_rows($result_session) > 0) {
  37. echo '<table class="data_table"><tr><th>'.get_lang('Session').'</th><th>'.get_lang('MoyenneTest').'</th><th>'.get_lang('MoyenneExamen').'</th></tr>';
  38. while ($session = Database::fetch_array($result_session)) {
  39. $sql_course = "SELECT title, code, course.id
  40. FROM $tbl_course as course
  41. INNER JOIN $tbl_session_course AS rel_course
  42. ON course.id = rel_course.c_id
  43. AND rel_course.session_id = ".$session['id']."
  44. ORDER BY title ASC";
  45. $result_course = Database::query($sql_course);
  46. $total_result = 0;
  47. $total_weighting = 0;
  48. while ($course = Database::fetch_array($result_course)) {
  49. $sql_moy_test = "SELECT exe_result,exe_weighting
  50. FROM $tbl_track_exercice
  51. WHERE c_id = ".$course['id'];
  52. $result_moy_test = Database::query($sql_moy_test);
  53. $result = 0;
  54. $weighting = 0;
  55. while ($moy_test = Database::fetch_array($result_moy_test)) {
  56. $result = $result + $moy_test['exe_result'];
  57. $weighting = $weighting + $moy_test['exe_weighting'];
  58. }
  59. $total_result = $total_result + $result;
  60. $total_weighting = $total_weighting + $weighting;
  61. }
  62. if ($total_weighting != 0) {
  63. $moyenne_test = round(($total_result * 100) / $total_weighting);
  64. } else {
  65. $moyenne_test = null;
  66. }
  67. echo '<tr><td>'.$session['name'].'</td><td>'.(is_null($moyenne_test) ? '' : $moyenne_test.'%').'</td><td> </td></tr>';
  68. }
  69. echo '</table>';
  70. } else {
  71. echo get_lang('NoSession');
  72. }
  73. } else {
  74. $sql_course = "SELECT title, code, id
  75. FROM $tbl_course as course
  76. ORDER BY title ASC";
  77. $result_course = Database::query($sql_course);
  78. echo "<a href='".api_get_self()."?session=true'>".get_lang('MoySession')."</a>";
  79. echo "<br /><br />";
  80. if (Database::num_rows($result_course) > 0) {
  81. echo '<table class="data_table"><tr><th>'.get_lang('Course').'</th><th>'.get_lang('MoyenneTest').'</th><th>'.get_lang('MoyenneExamen').'</th></tr>';
  82. while ($course= Database::fetch_array($result_course)) {
  83. $sql_moy_test = "SELECT exe_result,exe_weighting
  84. FROM $tbl_track_exercice
  85. WHERE c_id = ".$course['id'];
  86. $result_moy_test = Database::query($sql_moy_test);
  87. $result = 0;
  88. $weighting = 0;
  89. while ($moy_test = Database::fetch_array($result_moy_test)) {
  90. $result = $result + $moy_test['exe_result'];
  91. $weighting = $weighting + $moy_test['exe_weighting'];
  92. }
  93. if ($weighting != 0) {
  94. $moyenne_test = round(($result * 100) / $weighting);
  95. } else {
  96. $moyenne_test = null;
  97. }
  98. echo '<tr><td>'.$course['title'].'</td><td>'.(is_null($moyenne_test) ? '' : $moyenne_test.'%').'</td><td> </td></tr>';
  99. }
  100. echo '</table>';
  101. } else {
  102. echo get_lang('NoCourse');
  103. }
  104. }
  105. Display :: display_footer();