reussite.php 4.1 KB

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