session_course_edit.php 4.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136
  1. <?php //$id: $
  2. /* For licensing terms, see /dokeos_license.txt */
  3. /**
  4. * Implements the edition of course-session settings
  5. * @package dokeos.admin
  6. */
  7. // name of the language file that needs to be included
  8. $language_file='admin';
  9. $cidReset=true;
  10. require '../inc/global.inc.php';
  11. // setting the section (for the tabs)
  12. $this_section=SECTION_PLATFORM_ADMIN;
  13. api_protect_admin_script();
  14. $id_session=intval($_GET['id_session']);
  15. $course_code=trim(stripslashes($_GET['course_code']));
  16. $formSent=0;
  17. $errorMsg='';
  18. // Database Table Definitions
  19. $tbl_user = Database::get_main_table(TABLE_MAIN_USER);
  20. $tbl_course = Database::get_main_table(TABLE_MAIN_COURSE);
  21. $tbl_session = Database::get_main_table(TABLE_MAIN_SESSION);
  22. $tbl_session_course = Database::get_main_table(TABLE_MAIN_SESSION_COURSE);
  23. $course_info=api_get_course_info($_REQUEST['course_code']);
  24. $tool_name=$course_info['name'];
  25. $interbreadcrumb[]=array('url' => 'index.php',"name" => get_lang('PlatformAdmin'));
  26. $interbreadcrumb[]=array('url' => "session_list.php","name" => get_lang("SessionList"));
  27. $interbreadcrumb[]=array('url' => "../admin/resume_session.php?id_session=".Security::remove_XSS($_REQUEST['id_session']),"name" => get_lang('SessionOverview'));
  28. $interbreadcrumb[]=array('url' => "session_course_list.php?id_session=$id_session","name" =>api_htmlentities($session_name,ENT_QUOTES,$charset));
  29. $result=api_sql_query("SELECT name,title FROM $tbl_session_course,$tbl_session,$tbl_course WHERE id_session=id AND course_code=code AND id_session='$id_session' AND course_code='".addslashes($course_code)."'",__FILE__,__LINE__);
  30. if (!list($session_name,$course_title)=mysql_fetch_row($result)) {
  31. header('Location: session_course_list.php?id_session='.$id_session);
  32. exit();
  33. }
  34. if ($_POST['formSent']) {
  35. $formSent=1;
  36. $id_coach=intval($_POST['id_coach']);
  37. api_sql_query("UPDATE $tbl_session_course
  38. SET id_coach='$id_coach'
  39. WHERE id_session='$id_session' AND course_code='$course_code'",__FILE__,__LINE__);
  40. header('Location: '.$_GET['page'].'?id_session='.$id_session);
  41. exit();
  42. }else {
  43. $result=api_sql_query("SELECT id_coach FROM $tbl_session_course WHERE id_session='$id_session' AND course_code='$course_code'",__FILE__,__LINE__);
  44. if (!$infos=Database::fetch_array($result)) {
  45. //header('Location: '.$_GET['page'].'?id_session='.$id_session);
  46. exit();
  47. }
  48. }
  49. $order_clause = api_sort_by_first_name() ? ' ORDER BY firstname, lastname, username' : ' ORDER BY lastname, firstname, username';
  50. $sql="SELECT user_id,lastname,firstname,username FROM $tbl_user WHERE status='1'".$order_clause;
  51. $result=api_sql_query($sql,__FILE__,__LINE__);
  52. $coaches=api_store_result($result);
  53. Display::display_header($tool_name);
  54. $tool_name=get_lang('ModifySessionCourse');
  55. api_display_tool_title($tool_name);
  56. ?>
  57. <form method="post" action="<?php echo api_get_self(); ?>?id_session=<?php echo $id_session; ?>&course_code=<?php echo urlencode($course_code); ?>&page=<?php echo Security::remove_XSS($_GET['page']) ?>" style="margin:0px;">
  58. <input type="hidden" name="formSent" value="1">
  59. <table border="0" cellpadding="5" cellspacing="0" width="550">
  60. <?php
  61. if(!empty($errorMsg))
  62. {
  63. ?>
  64. <tr>
  65. <td colspan="2">
  66. <?php
  67. Display::display_normal_message($errorMsg);
  68. ?>
  69. </td>
  70. </tr>
  71. <?php
  72. }
  73. ?>
  74. <tr>
  75. <td width="30%"><?php echo get_lang("CoachName") ?>&nbsp;&nbsp;</td>
  76. <td width="70%"><select name="id_coach" style="width:250px;">
  77. <option value="0">----- <?php echo get_lang("Choose") ?> -----</option>
  78. <option value="0" <?php if((!$sent && $enreg['user_id'] == $infos['id_coach']) || ($sent && $enreg['user_id'] == $id_coach)) echo 'selected="selected"'; ?>><?php echo get_lang('None') ?></option>
  79. <?php
  80. foreach($coaches as $enreg)
  81. {
  82. ?>
  83. <option value="<?php echo $enreg['user_id']; ?>" <?php if((!$sent && $enreg['user_id'] == $infos['id_coach']) || ($sent && $enreg['user_id'] == $id_coach)) echo 'selected="selected"'; ?>><?php echo api_get_person_name($enreg['lastname'], $enreg['firstname']).' ('.$enreg['username'].')'; ?></option>
  84. <?php
  85. }
  86. unset($coaches);
  87. ?>
  88. </select></td>
  89. </tr>
  90. <tr>
  91. <td>&nbsp;</td>
  92. <td><button class="save" type="submit" name="name" value="<?php echo get_lang('ModifyCoach') ?>"><?php echo get_lang('ModifyCoach') ?></button>
  93. </td>
  94. </tr>
  95. </table>
  96. </form>
  97. <?php
  98. Display::display_footer();
  99. ?>