session_course_edit.php 6.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165
  1. <?php
  2. /* For licensing terms, see /license.txt */
  3. /**
  4. * Implements the edition of course-session settings
  5. * @package chamilo.admin
  6. */
  7. $cidReset = true;
  8. require_once '../inc/global.inc.php';
  9. $id_session = intval($_GET['id_session']);
  10. SessionManager::protect_session_edit($id_session);
  11. $course_code = $_GET['course_code'];
  12. $formSent=0;
  13. $errorMsg='';
  14. // Database Table Definitions
  15. $tbl_user = Database::get_main_table(TABLE_MAIN_USER);
  16. $tbl_course = Database::get_main_table(TABLE_MAIN_COURSE);
  17. $tbl_session = Database::get_main_table(TABLE_MAIN_SESSION);
  18. $tbl_session_course = Database::get_main_table(TABLE_MAIN_SESSION_COURSE);
  19. $tbl_session_rel_course_rel_user = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER);
  20. $course_info = api_get_course_info($_REQUEST['course_code']);
  21. $tool_name = $course_info['name'];
  22. $result = Database::query("SELECT s.name, c.title FROM $tbl_session_course sc,$tbl_session s,$tbl_course c
  23. WHERE sc.id_session=s.id AND sc.course_code=c.code AND sc
  24. .id_session='$id_session' AND sc.course_code='".Database::escape_string($course_code)."'");
  25. if (!list($session_name,$course_title)=Database::fetch_row($result)) {
  26. header('Location: session_course_list.php?id_session='.$id_session);
  27. exit();
  28. }
  29. $interbreadcrumb[]=array('url' => 'index.php',"name" => get_lang('PlatformAdmin'));
  30. $interbreadcrumb[]=array('url' => "session_list.php","name" => get_lang("SessionList"));
  31. $interbreadcrumb[]=array('url' => "resume_session.php?id_session=".$id_session,"name" => get_lang('SessionOverview'));
  32. $interbreadcrumb[]=array('url' => "session_course_list.php?id_session=$id_session","name" =>api_htmlentities($session_name,ENT_QUOTES,$charset));
  33. $arr_infos = array();
  34. if (isset($_POST['formSent']) && $_POST['formSent']) {
  35. $formSent=1;
  36. // get all tutor by course_code in the session
  37. $sql = "SELECT id_user FROM $tbl_session_rel_course_rel_user
  38. WHERE id_session = '$id_session' AND course_code = '".Database::escape_string($course_code)."' AND status = 2";
  39. $rs_coachs = Database::query($sql);
  40. $coachs_course_session = array();
  41. if (Database::num_rows($rs_coachs) > 0){
  42. while ($row_coachs = Database::fetch_row($rs_coachs)) {
  43. $coachs_course_session[] = $row_coachs[0];
  44. }
  45. }
  46. $id_coachs= $_POST['id_coach'];
  47. if (is_array($id_coachs) && count($id_coachs) > 0) {
  48. foreach ($id_coachs as $id_coach) {
  49. $id_coach = intval($id_coach);
  50. $rs1 = SessionManager::set_coach_to_course_session($id_coach, $id_session, $course_code);
  51. }
  52. // set status to 0 other tutors from multiple list
  53. $array_intersect = array_diff($coachs_course_session,$id_coachs);
  54. foreach ($array_intersect as $nocoach_user_id) {
  55. $rs2 = SessionManager::set_coach_to_course_session(
  56. $nocoach_user_id,
  57. $id_session,
  58. $course_code,
  59. true
  60. );
  61. }
  62. header('Location: '.Security::remove_XSS($_GET['page']).'?id_session='.$id_session);
  63. exit();
  64. }
  65. } else {
  66. $sql = "SELECT id_user FROM $tbl_session_rel_course_rel_user
  67. WHERE id_session = '$id_session' AND course_code = '".Database::escape_string($course_code)."' AND status = 2 ";
  68. $rs = Database::query($sql);
  69. if (Database::num_rows($rs) > 0) {
  70. while ($infos = Database::fetch_array($rs)) {
  71. $arr_infos[] = $infos['id_user'];
  72. }
  73. }
  74. }
  75. $order_clause = api_sort_by_first_name() ? ' ORDER BY firstname, lastname, username' : ' ORDER BY lastname, firstname, username';
  76. global $_configuration;
  77. if ($_configuration['multiple_access_urls']) {
  78. $tbl_access_rel_user= Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);
  79. $access_url_id = api_get_current_access_url_id();
  80. $sql="SELECT u.user_id,lastname,firstname,username
  81. FROM $tbl_user u LEFT JOIN $tbl_access_rel_user a ON(u.user_id= a.user_id)
  82. WHERE status='1' AND active = 1 AND access_url_id = $access_url_id ".$order_clause;
  83. } else {
  84. $sql="SELECT user_id,lastname,firstname,username
  85. FROM $tbl_user
  86. WHERE status='1' AND active = 1 ".$order_clause;
  87. }
  88. $result = Database::query($sql);
  89. $coaches = Database::store_result($result);
  90. Display::display_header($tool_name);
  91. $tool_name = get_lang('ModifySessionCourse');
  92. api_display_tool_title($tool_name);
  93. ?>
  94. <div class="session-course-edit">
  95. <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;">
  96. <input type="hidden" name="formSent" value="1">
  97. <div class="row">
  98. <div class="col-md-12">
  99. <div class="title"></div>
  100. <?php
  101. if(!empty($errorMsg)) {
  102. Display::display_normal_message($errorMsg);
  103. }
  104. ?>
  105. </div>
  106. </div>
  107. <div class="row">
  108. <div class="col-md-2">
  109. <?php echo get_lang("CoachName") ?>
  110. </div>
  111. <div class="col-md-8">
  112. <select name="id_coach[]" class="form-control">
  113. <option value="0">----- <?php echo get_lang("Choose") ?> -----</option>
  114. <option value="0" <?php if(count($arr_infos) == 0) echo 'selected="selected"'; ?>>
  115. <?php echo get_lang('None') ?>
  116. </option>
  117. <?php
  118. foreach($coaches as $enreg) {
  119. ?>
  120. <option value="<?php echo $enreg['user_id']; ?>" <?php if(((is_array($arr_infos) && in_array($enreg['user_id'], $arr_infos)))) echo 'selected="selected"'; ?>>
  121. <?php echo api_get_person_name($enreg['firstname'], $enreg['lastname']).' ('.$enreg['username'].')'; ?>
  122. </option>
  123. <?php
  124. }
  125. unset($coaches);
  126. ?>
  127. </select>
  128. <div class="control">
  129. <button class="btn btn-success" type="submit" name="name" value="<?php echo get_lang('AssignCoach') ?>">
  130. <i class="fa fa-plus"></i>
  131. <?php echo get_lang('AssignCoach') ?>
  132. </button>
  133. </div>
  134. </div>
  135. <div class="col-md-2"></div>
  136. </div>
  137. </form>
  138. </div>
  139. <?php
  140. Display::display_footer();