@@ -1207,16 +1207,16 @@ |
||
1207 | 1207 | } |
1208 | 1208 | |
1209 | 1209 | /** |
1210 | - * This function saves the question in the shared database |
|
1211 | - * |
|
1212 | - * @param array $form_content all the information of the form |
|
1213 | - * @param array $survey_data all the information of the survey |
|
1214 | - * |
|
1215 | - * @author Patrick Cool <[email protected]>, Ghent University |
|
1216 | - * @version February 2007 |
|
1217 | - * |
|
1218 | - * @todo editing of a shared question |
|
1219 | - */ |
|
1210 | + * This function saves the question in the shared database |
|
1211 | + * |
|
1212 | + * @param array $form_content all the information of the form |
|
1213 | + * @param array $survey_data all the information of the survey |
|
1214 | + * |
|
1215 | + * @author Patrick Cool <[email protected]>, Ghent University |
|
1216 | + * @version February 2007 |
|
1217 | + * |
|
1218 | + * @todo editing of a shared question |
|
1219 | + */ |
|
1220 | 1220 | public function save_shared_question($form_content, $survey_data) |
1221 | 1221 | { |
1222 | 1222 | $_course = api_get_course_info(); |
@@ -13,10 +13,10 @@ discard block |
||
13 | 13 | |
14 | 14 | /** @todo this has to be moved to a more appropriate place (after the display_header of the code)*/ |
15 | 15 | if (!api_is_allowed_to_edit(false, true)) { |
16 | - Display :: display_header(get_lang('ToolSurvey')); |
|
17 | - Display :: display_error_message(get_lang('NotAllowed'), false); |
|
18 | - Display :: display_footer(); |
|
19 | - exit; |
|
16 | + Display :: display_header(get_lang('ToolSurvey')); |
|
17 | + Display :: display_error_message(get_lang('NotAllowed'), false); |
|
18 | + Display :: display_footer(); |
|
19 | + exit; |
|
20 | 20 | } |
21 | 21 | |
22 | 22 | // Database table definitions |
@@ -33,25 +33,25 @@ discard block |
||
33 | 33 | // Getting the survey information |
34 | 34 | // We exit here if ther is no valid $_GET parameter |
35 | 35 | if (!isset($_GET['survey_id']) OR !is_numeric($_GET['survey_id'])) { |
36 | - Display :: display_header($tool_name); |
|
37 | - Display :: display_error_message(get_lang('InvallidSurvey'), false); |
|
38 | - Display :: display_footer(); |
|
39 | - exit; |
|
36 | + Display :: display_header($tool_name); |
|
37 | + Display :: display_error_message(get_lang('InvallidSurvey'), false); |
|
38 | + Display :: display_footer(); |
|
39 | + exit; |
|
40 | 40 | } |
41 | 41 | |
42 | 42 | $survey_id = Security::remove_XSS($_GET['survey_id']); |
43 | 43 | $survey_data = SurveyManager::get_survey($survey_id); |
44 | 44 | |
45 | 45 | if (empty($survey_data)) { |
46 | - Display :: display_header($tool_name); |
|
47 | - Display :: display_error_message(get_lang('InvallidSurvey'), false); |
|
48 | - Display :: display_footer(); |
|
49 | - exit; |
|
46 | + Display :: display_header($tool_name); |
|
47 | + Display :: display_error_message(get_lang('InvallidSurvey'), false); |
|
48 | + Display :: display_footer(); |
|
49 | + exit; |
|
50 | 50 | } |
51 | 51 | |
52 | 52 | $urlname = strip_tags(api_substr(api_html_entity_decode($survey_data['title'], ENT_QUOTES), 0, 40)); |
53 | 53 | if (api_strlen(strip_tags($survey_data['title'])) > 40) { |
54 | - $urlname .= '...'; |
|
54 | + $urlname .= '...'; |
|
55 | 55 | } |
56 | 56 | |
57 | 57 | // Breadcrumbs |
@@ -64,32 +64,32 @@ discard block |
||
64 | 64 | |
65 | 65 | // Checking the parameters |
66 | 66 | if (!is_numeric($survey_id)) { |
67 | - Display::display_error_message(get_lang('Error'), false); |
|
68 | - Display::display_footer(); |
|
69 | - exit; |
|
67 | + Display::display_error_message(get_lang('Error'), false); |
|
68 | + Display::display_footer(); |
|
69 | + exit; |
|
70 | 70 | } |
71 | 71 | |
72 | 72 | // Getting all the people who have filled this survey |
73 | 73 | $answered_data = SurveyManager::get_people_who_filled_survey($survey_id); |
74 | 74 | if ($survey_data['anonymous'] == 1) { |
75 | - Display::display_normal_message(get_lang('AnonymousSurveyCannotKnowWhoAnswered').' '.count($answered_data).' '.get_lang('PeopleAnswered')); |
|
76 | - $answered_data = array(); |
|
75 | + Display::display_normal_message(get_lang('AnonymousSurveyCannotKnowWhoAnswered').' '.count($answered_data).' '.get_lang('PeopleAnswered')); |
|
76 | + $answered_data = array(); |
|
77 | 77 | } |
78 | 78 | |
79 | 79 | if (!isset($_GET['view']) OR $_GET['view'] == 'invited') { |
80 | - echo get_lang('ViewInvited'). ' | '; |
|
80 | + echo get_lang('ViewInvited'). ' | '; |
|
81 | 81 | } else { |
82 | - echo ' <a href="'.api_get_self().'?survey_id='.$survey_id.'&view=invited">'.get_lang('ViewInvited').'</a> |'; |
|
82 | + echo ' <a href="'.api_get_self().'?survey_id='.$survey_id.'&view=invited">'.get_lang('ViewInvited').'</a> |'; |
|
83 | 83 | } |
84 | 84 | if ($_GET['view'] == 'answered') { |
85 | - echo get_lang('ViewAnswered').' | '; |
|
85 | + echo get_lang('ViewAnswered').' | '; |
|
86 | 86 | } else { |
87 | - echo ' <a href="'.api_get_self().'?survey_id='.$survey_id.'&view=answered">'.get_lang('ViewAnswered').'</a> |'; |
|
87 | + echo ' <a href="'.api_get_self().'?survey_id='.$survey_id.'&view=answered">'.get_lang('ViewAnswered').'</a> |'; |
|
88 | 88 | } |
89 | 89 | if ($_GET['view'] == 'unanswered') { |
90 | - echo get_lang('ViewUnanswered'); |
|
90 | + echo get_lang('ViewUnanswered'); |
|
91 | 91 | } else { |
92 | - echo ' <a href="'.api_get_self().'?survey_id='.$survey_id.'&view=unanswered">'.get_lang('ViewUnanswered').'</a>'; |
|
92 | + echo ' <a href="'.api_get_self().'?survey_id='.$survey_id.'&view=unanswered">'.get_lang('ViewUnanswered').'</a>'; |
|
93 | 93 | } |
94 | 94 | |
95 | 95 | // Table header |
@@ -111,32 +111,32 @@ discard block |
||
111 | 111 | |
112 | 112 | $res = Database::query($sql); |
113 | 113 | while ($row = Database::fetch_assoc($res)) { |
114 | - if (!$_GET['view'] || |
|
115 | - $_GET['view'] == 'invited' || |
|
114 | + if (!$_GET['view'] || |
|
115 | + $_GET['view'] == 'invited' || |
|
116 | 116 | ($_GET['view'] == 'answered' && in_array($row['user'], $answered_data)) || |
117 | 117 | ($_GET['view'] == 'unanswered' && !in_array($row['user'], $answered_data)) |
118 | 118 | ) { |
119 | - echo '<tr>'; |
|
120 | - if (is_numeric($row['user'])) { |
|
119 | + echo '<tr>'; |
|
120 | + if (is_numeric($row['user'])) { |
|
121 | 121 | $userInfo = api_get_user_info($row['user']); |
122 | - echo '<td>'; |
|
122 | + echo '<td>'; |
|
123 | 123 | echo UserManager::getUserProfileLink($userInfo); |
124 | 124 | echo '</td>'; |
125 | - } else { |
|
125 | + } else { |
|
126 | 126 | echo '<td>'.$row['user'].'</td>'; |
127 | - } |
|
128 | - echo ' <td>'.$row['invitation_date'].'</td>'; |
|
129 | - echo ' <td>'; |
|
130 | - |
|
131 | - if (in_array($row['user'], $answered_data)) { |
|
132 | - echo '<a href="'.api_get_path(WEB_CODE_PATH).'survey/reporting.php?action=userreport&survey_id='.$survey_id.'&user='.$row['user'].'">'.get_lang('ViewAnswers').'</a>'; |
|
133 | - } else { |
|
134 | - echo '-'; |
|
135 | - } |
|
136 | - |
|
137 | - echo ' </td>'; |
|
138 | - echo '</tr>'; |
|
139 | - } |
|
127 | + } |
|
128 | + echo ' <td>'.$row['invitation_date'].'</td>'; |
|
129 | + echo ' <td>'; |
|
130 | + |
|
131 | + if (in_array($row['user'], $answered_data)) { |
|
132 | + echo '<a href="'.api_get_path(WEB_CODE_PATH).'survey/reporting.php?action=userreport&survey_id='.$survey_id.'&user='.$row['user'].'">'.get_lang('ViewAnswers').'</a>'; |
|
133 | + } else { |
|
134 | + echo '-'; |
|
135 | + } |
|
136 | + |
|
137 | + echo ' </td>'; |
|
138 | + echo '</tr>'; |
|
139 | + } |
|
140 | 140 | } |
141 | 141 | |
142 | 142 | // Closing the table |
@@ -50,8 +50,8 @@ discard block |
||
50 | 50 | |
51 | 51 | $result = Database::query($sql); |
52 | 52 | if (!list($session_name,$course_title) = Database::fetch_row($result)) { |
53 | - header('Location: session_course_list.php?id_session='.$id_session); |
|
54 | - exit(); |
|
53 | + header('Location: session_course_list.php?id_session='.$id_session); |
|
54 | + exit(); |
|
55 | 55 | } |
56 | 56 | |
57 | 57 | switch ($action) { |
@@ -122,7 +122,7 @@ discard block |
||
122 | 122 | <a href="<?php echo api_get_self(); ?>?id_session=<?php echo $id_session; ?>&course_code=<?php echo urlencode($course_code); ?>&page=<?php echo $page-1; ?>&sort=<?php echo $sort; ?>"><?php echo get_lang('Previous');?></a> |
123 | 123 | <?php |
124 | 124 | } else { |
125 | - echo get_lang('Previous'); |
|
125 | + echo get_lang('Previous'); |
|
126 | 126 | } |
127 | 127 | ?> |
128 | 128 | | |
@@ -132,7 +132,7 @@ discard block |
||
132 | 132 | <a href="<?php echo api_get_self(); ?>?id_session=<?php echo $id_session; ?>&course_code=<?php echo urlencode($course_code); ?>&page=<?php echo $page+1; ?>&sort=<?php echo $sort; ?>"><?php echo get_lang('Next');?></a> |
133 | 133 | <?php |
134 | 134 | } else { |
135 | - echo get_lang('Next'); |
|
135 | + echo get_lang('Next'); |
|
136 | 136 | } |
137 | 137 | ?> |
138 | 138 | </div> |
@@ -154,9 +154,9 @@ discard block |
||
154 | 154 | $i=0; |
155 | 155 | foreach ($users as $key => $enreg) { |
156 | 156 | |
157 | - if ($key == $limit) { |
|
158 | - break; |
|
159 | - } |
|
157 | + if ($key == $limit) { |
|
158 | + break; |
|
159 | + } |
|
160 | 160 | ?> |
161 | 161 | <tr class="<?php echo $i?'row_odd':'row_even'; ?>"> |
162 | 162 | <td><input type="checkbox" name="idChecked[]" value="<?php echo $enreg['user_id']; ?>"></td> |
@@ -30,26 +30,26 @@ discard block |
||
30 | 30 | $result = Database::query("SELECT name FROM $tbl_session WHERE id='$id_session'"); |
31 | 31 | |
32 | 32 | if (!list($session_name)=Database::fetch_row($result)) { |
33 | - header('Location: session_list.php'); |
|
34 | - exit; |
|
33 | + header('Location: session_list.php'); |
|
34 | + exit; |
|
35 | 35 | } |
36 | 36 | |
37 | 37 | if ($action == 'delete') { |
38 | - $idChecked = $_REQUEST['idChecked']; |
|
39 | - if (is_array($idChecked) && count($idChecked)>0) { |
|
40 | - $my_temp = array(); |
|
41 | - foreach ($idChecked as $id){ |
|
42 | - $my_temp[]= Database::escape_string($id);// forcing the escape_string |
|
43 | - } |
|
44 | - $idChecked = $my_temp; |
|
45 | - $idChecked="'".implode("','", $idChecked)."'"; |
|
46 | - $result = Database::query("DELETE FROM $tbl_session_rel_course WHERE session_id='$id_session' AND c_id IN($idChecked)"); |
|
47 | - $nbr_affected_rows=Database::affected_rows($result); |
|
48 | - Database::query("DELETE FROM $tbl_session_rel_course_rel_user WHERE session_id='$id_session' AND c_id IN($idChecked)"); |
|
49 | - Database::query("UPDATE $tbl_session SET nbr_courses=nbr_courses-$nbr_affected_rows WHERE id='$id_session'"); |
|
50 | - } |
|
51 | - header('Location: '.api_get_self().'?id_session='.$id_session.'&sort='.$sort); |
|
52 | - exit(); |
|
38 | + $idChecked = $_REQUEST['idChecked']; |
|
39 | + if (is_array($idChecked) && count($idChecked)>0) { |
|
40 | + $my_temp = array(); |
|
41 | + foreach ($idChecked as $id){ |
|
42 | + $my_temp[]= Database::escape_string($id);// forcing the escape_string |
|
43 | + } |
|
44 | + $idChecked = $my_temp; |
|
45 | + $idChecked="'".implode("','", $idChecked)."'"; |
|
46 | + $result = Database::query("DELETE FROM $tbl_session_rel_course WHERE session_id='$id_session' AND c_id IN($idChecked)"); |
|
47 | + $nbr_affected_rows=Database::affected_rows($result); |
|
48 | + Database::query("DELETE FROM $tbl_session_rel_course_rel_user WHERE session_id='$id_session' AND c_id IN($idChecked)"); |
|
49 | + Database::query("UPDATE $tbl_session SET nbr_courses=nbr_courses-$nbr_affected_rows WHERE id='$id_session'"); |
|
50 | + } |
|
51 | + header('Location: '.api_get_self().'?id_session='.$id_session.'&sort='.$sort); |
|
52 | + exit(); |
|
53 | 53 | } |
54 | 54 | |
55 | 55 | $limit = 20; |
@@ -82,17 +82,17 @@ discard block |
||
82 | 82 | $tableCourses = array(); |
83 | 83 | |
84 | 84 | foreach ($Courses as $key=>$enreg) { |
85 | - $course = array(); |
|
86 | - $course[] = '<input type="checkbox" name="idChecked[]" value="'.$enreg['id'].'">'; |
|
87 | - $course[] = api_htmlentities($enreg['title'],ENT_QUOTES,$charset); |
|
88 | - $course[] = '<a href="session_course_user_list.php?id_session='.$id_session.'&course_code='.$enreg['code'].'">'.$enreg['nbr_users'].' '.get_lang('Users').'</a>'; |
|
89 | - $course[] = '<a href="'.api_get_path(WEB_COURSE_PATH).$enreg['code'].'/?id_session='.$id_session.'">'. |
|
90 | - Display::return_icon('course_home.gif', get_lang('Course')).'</a> |
|
85 | + $course = array(); |
|
86 | + $course[] = '<input type="checkbox" name="idChecked[]" value="'.$enreg['id'].'">'; |
|
87 | + $course[] = api_htmlentities($enreg['title'],ENT_QUOTES,$charset); |
|
88 | + $course[] = '<a href="session_course_user_list.php?id_session='.$id_session.'&course_code='.$enreg['code'].'">'.$enreg['nbr_users'].' '.get_lang('Users').'</a>'; |
|
89 | + $course[] = '<a href="'.api_get_path(WEB_COURSE_PATH).$enreg['code'].'/?id_session='.$id_session.'">'. |
|
90 | + Display::return_icon('course_home.gif', get_lang('Course')).'</a> |
|
91 | 91 | <a href="session_course_edit.php?id_session='.$id_session.'&page=session_course_list.php&course_code='.$enreg['code'].'">'. |
92 | - Display::return_icon('edit.png', get_lang('Edit')).'</a> |
|
92 | + Display::return_icon('edit.png', get_lang('Edit')).'</a> |
|
93 | 93 | <a href="'.api_get_self().'?id_session='.$id_session.'&sort='.$sort.'&action=delete&idChecked[]='.$enreg['id'].'" onclick="javascript:if(!confirm(\''.addslashes(api_htmlentities(get_lang("ConfirmYourChoice"),ENT_QUOTES,$charset)).'\')) return false;">'. |
94 | - Display::return_icon('delete.png', get_lang('Delete')).'</a>'; |
|
95 | - $tableCourses[] = $course; |
|
94 | + Display::return_icon('delete.png', get_lang('Delete')).'</a>'; |
|
95 | + $tableCourses[] = $course; |
|
96 | 96 | } |
97 | 97 | echo '<form method="post" action="'.api_get_self().'">'; |
98 | 98 | Display :: display_sortable_table($tableHeader, $tableCourses, array (), array ()); |
@@ -155,7 +155,7 @@ discard block |
||
155 | 155 | $sessionRepository = Database::getManager()->getRepository('ChamiloCoreBundle:Session'); |
156 | 156 | $courses = $sessionRepository->getCoursesOrderedByPosition($session); |
157 | 157 | |
158 | - foreach ($courses as $course) { |
|
158 | + foreach ($courses as $course) { |
|
159 | 159 | //select the number of users |
160 | 160 | $sql = "SELECT count(*) |
161 | 161 | FROM $tbl_session_rel_user sru, |
@@ -167,37 +167,37 @@ discard block |
||
167 | 167 | sru.relation_type <> ".SESSION_RELATION_TYPE_RRHH." AND |
168 | 168 | srcru.session_id = '".intval($sessionId)."'"; |
169 | 169 | |
170 | - $rs = Database::query($sql); |
|
170 | + $rs = Database::query($sql); |
|
171 | 171 | $numberOfUsers = Database::result($rs, 0, 0); |
172 | 172 | |
173 | - // Get coachs of the courses in session |
|
173 | + // Get coachs of the courses in session |
|
174 | 174 | |
175 | - $sql = "SELECT user.lastname, user.firstname, user.username |
|
175 | + $sql = "SELECT user.lastname, user.firstname, user.username |
|
176 | 176 | FROM $tbl_session_rel_course_rel_user session_rcru, $tbl_user user |
177 | 177 | WHERE |
178 | 178 | session_rcru.user_id = user.user_id AND |
179 | 179 | session_rcru.session_id = '".intval($sessionId)."' AND |
180 | 180 | session_rcru.c_id ='".intval($course->getId())."' AND |
181 | 181 | session_rcru.status=2"; |
182 | - $rs = Database::query($sql); |
|
182 | + $rs = Database::query($sql); |
|
183 | 183 | |
184 | - $coachs = array(); |
|
185 | - if (Database::num_rows($rs) > 0) { |
|
186 | - while($info_coach = Database::fetch_array($rs)) { |
|
184 | + $coachs = array(); |
|
185 | + if (Database::num_rows($rs) > 0) { |
|
186 | + while($info_coach = Database::fetch_array($rs)) { |
|
187 | 187 | $coachs[] = api_get_person_name( |
188 | 188 | $info_coach['firstname'], |
189 | 189 | $info_coach['lastname'] |
190 | 190 | ).' ('.$info_coach['username'].')'; |
191 | - } |
|
192 | - } else { |
|
193 | - $coach = get_lang('None'); |
|
194 | - } |
|
191 | + } |
|
192 | + } else { |
|
193 | + $coach = get_lang('None'); |
|
194 | + } |
|
195 | 195 | |
196 | - if (count($coachs) > 0) { |
|
197 | - $coach = implode('<br />',$coachs); |
|
198 | - } else { |
|
199 | - $coach = get_lang('None'); |
|
200 | - } |
|
196 | + if (count($coachs) > 0) { |
|
197 | + $coach = implode('<br />',$coachs); |
|
198 | + } else { |
|
199 | + $coach = get_lang('None'); |
|
200 | + } |
|
201 | 201 | |
202 | 202 | $orderButtons = null; |
203 | 203 | |
@@ -233,8 +233,8 @@ discard block |
||
233 | 233 | |
234 | 234 | $courseUrl = api_get_course_url($course->getCode(), $sessionId); |
235 | 235 | |
236 | - // hide_course_breadcrumb the parameter has been added to hide the name |
|
237 | - // of the course, that appeared in the default $interbreadcrumb |
|
236 | + // hide_course_breadcrumb the parameter has been added to hide the name |
|
237 | + // of the course, that appeared in the default $interbreadcrumb |
|
238 | 238 | $courseItem .= ' |
239 | 239 | <tr> |
240 | 240 | <td class="title">'.Display::url( |
@@ -260,7 +260,7 @@ discard block |
||
260 | 260 | </td> |
261 | 261 | </tr>'; |
262 | 262 | $count++; |
263 | - } |
|
263 | + } |
|
264 | 264 | $courseListToShow .= $courseItem; |
265 | 265 | } |
266 | 266 | $courseListToShow .= '</table><br />'; |
@@ -70,13 +70,13 @@ |
||
70 | 70 | <tr> |
71 | 71 | <td align="center"> |
72 | 72 | <?php |
73 | - echo Display::select( |
|
74 | - 'sessions[]', |
|
75 | - $sessionList, |
|
76 | - '', |
|
77 | - array('style'=>'width:360px', 'multiple'=>'multiple','id'=>'sessions', 'size'=>'15px'), |
|
78 | - false |
|
79 | - ); |
|
73 | + echo Display::select( |
|
74 | + 'sessions[]', |
|
75 | + $sessionList, |
|
76 | + '', |
|
77 | + array('style'=>'width:360px', 'multiple'=>'multiple','id'=>'sessions', 'size'=>'15px'), |
|
78 | + false |
|
79 | + ); |
|
80 | 80 | ?> |
81 | 81 | </td> |
82 | 82 | <td align="center"> |
@@ -29,15 +29,15 @@ discard block |
||
29 | 29 | $sql = "SELECT * FROM $tbl_session_category WHERE id='".$id."' ORDER BY name"; |
30 | 30 | $result = Database::query($sql); |
31 | 31 | if (!$infos = Database::fetch_array($result)) { |
32 | - header('Location: session_list.php'); |
|
33 | - exit(); |
|
32 | + header('Location: session_list.php'); |
|
33 | + exit(); |
|
34 | 34 | } |
35 | 35 | |
36 | 36 | list($year_start,$month_start,$day_start)=explode('-',$infos['date_start']); |
37 | 37 | list($year_end,$month_end,$day_end)=explode('-',$infos['date_end']); |
38 | 38 | |
39 | 39 | if (!api_is_platform_admin() && $infos['session_admin_id']!=$_user['user_id'] && !api_is_session_admin()) { |
40 | - api_not_allowed(true); |
|
40 | + api_not_allowed(true); |
|
41 | 41 | } |
42 | 42 | |
43 | 43 | if (isset($_POST['formSent']) && $_POST['formSent']) { |
@@ -60,7 +60,7 @@ discard block |
||
60 | 60 | $day_end |
61 | 61 | ); |
62 | 62 | if ($return == strval(intval($return))) { |
63 | - Display::addFlash(Display::return_message(get_lang('SessionCategoryUpdate'))); |
|
63 | + Display::addFlash(Display::return_message(get_lang('SessionCategoryUpdate'))); |
|
64 | 64 | header('Location: session_category_list.php'); |
65 | 65 | exit(); |
66 | 66 | } |
@@ -73,7 +73,7 @@ discard block |
||
73 | 73 | // display the header |
74 | 74 | Display::display_header($tool_name); |
75 | 75 | if (!empty($return)) { |
76 | - Display::display_error_message($return,false); |
|
76 | + Display::display_error_message($return,false); |
|
77 | 77 | } |
78 | 78 | ?> |
79 | 79 | <div class="row"> |
@@ -37,8 +37,8 @@ discard block |
||
37 | 37 | $result = Database::query($sql); |
38 | 38 | |
39 | 39 | if (!list($session_name,$course_title) = Database::fetch_row($result)) { |
40 | - header('Location: session_course_list.php?id_session='.$id_session); |
|
41 | - exit(); |
|
40 | + header('Location: session_course_list.php?id_session='.$id_session); |
|
41 | + exit(); |
|
42 | 42 | } |
43 | 43 | |
44 | 44 | //$interbreadcrumb[]=array('url' => 'index.php',"name" => get_lang('PlatformAdmin')); |
@@ -48,63 +48,63 @@ discard block |
||
48 | 48 | |
49 | 49 | $arr_infos = array(); |
50 | 50 | if (isset($_POST['formSent']) && $_POST['formSent']) { |
51 | - $formSent = 1; |
|
51 | + $formSent = 1; |
|
52 | 52 | |
53 | - // get all tutor by course_code in the session |
|
54 | - $sql = "SELECT user_id |
|
53 | + // get all tutor by course_code in the session |
|
54 | + $sql = "SELECT user_id |
|
55 | 55 | FROM $tbl_session_rel_course_rel_user |
56 | 56 | WHERE session_id = '$id_session' AND c_id = '".$courseId."' AND status = 2"; |
57 | - $rs_coaches = Database::query($sql); |
|
57 | + $rs_coaches = Database::query($sql); |
|
58 | 58 | |
59 | - $coaches_course_session = array(); |
|
60 | - if (Database::num_rows($rs_coaches) > 0){ |
|
61 | - while ($row_coaches = Database::fetch_row($rs_coaches)) { |
|
62 | - $coaches_course_session[] = $row_coaches[0]; |
|
63 | - } |
|
64 | - } |
|
59 | + $coaches_course_session = array(); |
|
60 | + if (Database::num_rows($rs_coaches) > 0){ |
|
61 | + while ($row_coaches = Database::fetch_row($rs_coaches)) { |
|
62 | + $coaches_course_session[] = $row_coaches[0]; |
|
63 | + } |
|
64 | + } |
|
65 | 65 | |
66 | - $id_coaches= $_POST['id_coach']; |
|
66 | + $id_coaches= $_POST['id_coach']; |
|
67 | 67 | |
68 | - if (is_array($id_coaches) && count($id_coaches) > 0) { |
|
68 | + if (is_array($id_coaches) && count($id_coaches) > 0) { |
|
69 | 69 | |
70 | - foreach ($id_coaches as $id_coach) { |
|
71 | - $id_coach = intval($id_coach); |
|
70 | + foreach ($id_coaches as $id_coach) { |
|
71 | + $id_coach = intval($id_coach); |
|
72 | 72 | $rs1 = SessionManager::set_coach_to_course_session( |
73 | 73 | $id_coach, |
74 | 74 | $id_session, |
75 | 75 | $courseId |
76 | 76 | ); |
77 | - } |
|
77 | + } |
|
78 | 78 | |
79 | - // set status to 0 other tutors from multiple list |
|
80 | - $array_intersect = array_diff($coaches_course_session,$id_coaches); |
|
79 | + // set status to 0 other tutors from multiple list |
|
80 | + $array_intersect = array_diff($coaches_course_session,$id_coaches); |
|
81 | 81 | |
82 | - foreach ($array_intersect as $no_coach_user_id) { |
|
83 | - $rs2 = SessionManager::set_coach_to_course_session( |
|
84 | - $no_coach_user_id, |
|
85 | - $id_session, |
|
82 | + foreach ($array_intersect as $no_coach_user_id) { |
|
83 | + $rs2 = SessionManager::set_coach_to_course_session( |
|
84 | + $no_coach_user_id, |
|
85 | + $id_session, |
|
86 | 86 | $courseId, |
87 | - true |
|
88 | - ); |
|
89 | - } |
|
87 | + true |
|
88 | + ); |
|
89 | + } |
|
90 | 90 | |
91 | - header('Location: '.Security::remove_XSS($_GET['page']).'?id_session='.$id_session); |
|
92 | - exit(); |
|
93 | - } |
|
91 | + header('Location: '.Security::remove_XSS($_GET['page']).'?id_session='.$id_session); |
|
92 | + exit(); |
|
93 | + } |
|
94 | 94 | } else { |
95 | - $sql = "SELECT user_id |
|
95 | + $sql = "SELECT user_id |
|
96 | 96 | FROM $tbl_session_rel_course_rel_user |
97 | 97 | WHERE |
98 | 98 | session_id = '$id_session' AND |
99 | 99 | c_id = '".$courseId."' AND |
100 | 100 | status = 2 "; |
101 | - $rs = Database::query($sql); |
|
101 | + $rs = Database::query($sql); |
|
102 | 102 | |
103 | - if (Database::num_rows($rs) > 0) { |
|
104 | - while ($infos = Database::fetch_array($rs)) { |
|
105 | - $arr_infos[] = $infos['user_id']; |
|
106 | - } |
|
107 | - } |
|
103 | + if (Database::num_rows($rs) > 0) { |
|
104 | + while ($infos = Database::fetch_array($rs)) { |
|
105 | + $arr_infos[] = $infos['user_id']; |
|
106 | + } |
|
107 | + } |
|
108 | 108 | } |
109 | 109 | |
110 | 110 | $order_clause = api_sort_by_first_name() ? ' ORDER BY firstname, lastname, username' : ' ORDER BY lastname, firstname, username'; |
@@ -197,12 +197,12 @@ |
||
197 | 197 | if (!empty($rows_session_category)) { |
198 | 198 | foreach($rows_session_category as $category) { |
199 | 199 | if($category['id'] == $categoryId) |
200 | - echo '<option value="'.$category['id'].'" selected>'.$category['name'].'</option>'; |
|
201 | - else |
|
202 | - echo '<option value="'.$category['id'].'">'.$category['name'].'</option>'; |
|
200 | + echo '<option value="'.$category['id'].'" selected>'.$category['name'].'</option>'; |
|
201 | + else |
|
202 | + echo '<option value="'.$category['id'].'">'.$category['name'].'</option>'; |
|
203 | 203 | } |
204 | 204 | } |
205 | - ?> |
|
205 | + ?> |
|
206 | 206 | </select> |
207 | 207 | </td> |
208 | 208 | </tr> |