reussite.php 4.0 KB

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