progression.php 3.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081
  1. <?php
  2. /*
  3. * Created on 28 juil. 2006 by Elixir Interactive http://www.elixir-interactive.com
  4. */
  5. // TODO: This file seems to be unfinished and unused.
  6. $language_file = array ('registration', 'index', 'tracking');
  7. require '../inc/global.inc.php';
  8. require_once api_get_path(SYS_CODE_PATH).'mySpace/myspace.lib.php';
  9. $nameTools = get_lang('Progression');
  10. $cidReset = true;
  11. $this_section = "session_my_space";
  12. api_block_anonymous_users();
  13. $interbreadcrumb[] = array ("url" => "index.php", "name" => get_lang('MySpace'));
  14. Display :: display_header($nameTools);
  15. // Database Table Definitions
  16. $tbl_course = Database :: get_main_table(TABLE_MAIN_COURSE);
  17. $tbl_user = Database :: get_main_table(TABLE_MAIN_USER);
  18. $tbl_session_course = Database :: get_main_table(TABLE_MAIN_SESSION_COURSE);
  19. $tbl_session = Database :: get_main_table(TABLE_MAIN_SESSION);
  20. $tbl_track_exercice = Database :: get_statistic_table(TABLE_STATISTIC_TRACK_E_EXERCICES);
  21. /*
  22. ===============================================================================
  23. MAIN CODE
  24. ===============================================================================
  25. */
  26. $sql_course = "SELECT title,code
  27. FROM $tbl_course as course
  28. ORDER BY title ASC";
  29. $result_course = Database::query($sql_course, __FILE__, __LINE__);
  30. if (Database::num_rows($result_course) > 0) {
  31. if (isset($_POST['export'])) {
  32. $export_result = export_csv($header, $data, 'test.csv'); // TODO: There is no data for exporting yet.
  33. Display :: display_error_message($export_result);
  34. }
  35. echo '<table class="data_table"><tr><th>'.get_lang('Course').'</th><th>'.get_lang('TempsFrequentation').'</th><th>'.get_lang('Progression').'</th><th>'.get_lang('MoyenneTest').'</th></tr>';
  36. $header = array(get_lang('Course', ''), get_lang('TempsFrequentation', ''), get_lang('Progression', ''), get_lang('MoyenneTest', ''));
  37. while ($a_course = Database::fetch_array($result_course)) {
  38. // TODO: This query is to be checked, there are no HotPotatoes tests results.
  39. $sql_moy_test = "SELECT exe_result,exe_weighting
  40. FROM $tbl_track_exercice
  41. WHERE exe_cours_id = '".$a_course['code']."'";
  42. $result_moy_test = Database::query($sql_moy_test, __FILE__, __LINE__);
  43. $result = 0;
  44. $weighting = 0;
  45. while ($moy_test = Database::fetch_array($result_moy_test)) {
  46. $result = $result + $moy_test['exe_result'];
  47. $weighting = $weighting + $moy_test['exe_weighting'];
  48. }
  49. if ($weighting != 0) {
  50. $moyenne_test = round(($result * 100) / $weighting);
  51. } else {
  52. $moyenne_test = null;
  53. }
  54. echo '<tr><td>'.$a_course['title'].'</td><td> </td><td> </td><td align="center">'.(is_null($moyenne_test) ? '' : $moyenne_test.'%').'</td> </tr>';
  55. }
  56. echo '</table>';
  57. echo "<br /><br />";
  58. echo "<form method='post'><input type='submit' name='export' value='".get_lang('exportExcel')."'/><form>";
  59. } else {
  60. echo get_lang('NoCourse');
  61. }
  62. /*
  63. ==============================================================================
  64. FOOTER
  65. ==============================================================================
  66. */
  67. Display :: display_footer();