Completed
Push — 1.11.x ( 566ea6...b264ab )
by José
110:20 queued 69:00
created
main/course_description/course_description_controller.php 1 patch
Indentation   +2 added lines, -2 removed lines patch added patch discarded remove patch
@@ -156,7 +156,7 @@  discard block
 block discarded – undo
156 156
                 if (isset($_GET['id_session'])) {
157 157
                     $session_id = intval($_GET['id_session']);
158 158
                 }
159
-		        $course_description_data = $course_description->get_data_by_id(
159
+                $course_description_data = $course_description->get_data_by_id(
160 160
                     $id,
161 161
                     null,
162 162
                     $session_id
@@ -165,7 +165,7 @@  discard block
 block discarded – undo
165 165
                 $data['description_title'] = $course_description_data['description_title'];
166 166
                 $data['description_content'] = $course_description_data['description_content'];
167 167
                 $data['progress'] = $course_description_data['progress'];
168
-		        $data['descriptions'] = $course_description->get_data_by_description_type(
168
+                $data['descriptions'] = $course_description->get_data_by_description_type(
169 169
                     $description_type,
170 170
                     null,
171 171
                     $session_id
Please login to merge, or discard this patch.
main/user/resume_session.php 3 patches
Indentation   +49 added lines, -49 removed lines patch added patch discarded remove patch
@@ -60,9 +60,9 @@  discard block
 block discarded – undo
60 60
     $session_category = '';
61 61
 
62 62
     if (Database::num_rows($rs)>0) {
63
-    	$rows_session_category = Database::store_result($rs);
64
-    	$rows_session_category = $rows_session_category[0];
65
-    	$session_category = $rows_session_category['name'];
63
+        $rows_session_category = Database::store_result($rs);
64
+        $rows_session_category = $rows_session_category[0];
65
+        $session_category = $rows_session_category['name'];
66 66
     }
67 67
 
68 68
     $action = isset($_GET['action']) ? $_GET['action'] : null;
@@ -147,22 +147,22 @@  discard block
 block discarded – undo
147 147
     	<td><?php echo get_lang('Date'); ?> :</td>
148 148
     	<td>
149 149
     	<?php
150
-    		if ($session['access_start_date'] == '00-00-0000' && $session['access_end_date']== '00-00-0000' ) {
151
-    		    echo get_lang('NoTimeLimits');
150
+            if ($session['access_start_date'] == '00-00-0000' && $session['access_end_date']== '00-00-0000' ) {
151
+                echo get_lang('NoTimeLimits');
152 152
             }
153
-    		else {
153
+            else {
154 154
                 if ($session['access_start_date'] != '00-00-0000') {
155
-                	//$session['date_start'] = Display::tag('i', get_lang('NoTimeLimits'));
155
+                    //$session['date_start'] = Display::tag('i', get_lang('NoTimeLimits'));
156 156
                     $session['access_start_date'] =  get_lang('From').' '.$session['access_start_date'];
157 157
                 } else {
158
-                	$session['access_start_date'] = '';
158
+                    $session['access_start_date'] = '';
159 159
                 }
160 160
                 if ($session['access_end_date'] == '00-00-0000') {
161 161
                     $session['access_end_date'] ='';
162 162
                 } else {
163
-                	$session['access_end_date'] = get_lang('Until').' '.$session['access_end_date'];
163
+                    $session['access_end_date'] = get_lang('Until').' '.$session['access_end_date'];
164 164
                 }
165
-    			echo $session['access_start_date'].' '.$session['access_end_date'];
165
+                echo $session['access_start_date'].' '.$session['access_end_date'];
166 166
             }
167 167
             ?>
168 168
     	</td>
@@ -221,22 +221,22 @@  discard block
 block discarded – undo
221 221
     </tr>
222 222
     <?php
223 223
     if ($session['nbr_courses'] == 0) {
224
-    	echo '<tr>
224
+        echo '<tr>
225 225
             <td colspan="4">'.get_lang('NoCoursesForThisSession').'</td>
226 226
     		</tr>';
227 227
     } else {
228
-    	// select the courses
229
-    	$sql = "SELECT c.id, code,title,visual_code, nbr_users
228
+        // select the courses
229
+        $sql = "SELECT c.id, code,title,visual_code, nbr_users
230 230
     			FROM $tbl_course c,$tbl_session_rel_course sc
231 231
     			WHERE c.id = sc.c_id
232 232
     			AND	session_id='$id_session'
233 233
     			ORDER BY title";
234
-    	$result=Database::query($sql);
235
-    	$courses=Database::store_result($result);
236
-    	foreach ($courses as $course) {
237
-    		//select the number of users
234
+        $result=Database::query($sql);
235
+        $courses=Database::store_result($result);
236
+        foreach ($courses as $course) {
237
+            //select the number of users
238 238
 
239
-    		$sql = "SELECT count(*) FROM $tbl_session_rel_user sru, $tbl_session_rel_course_rel_user srcru
239
+            $sql = "SELECT count(*) FROM $tbl_session_rel_user sru, $tbl_session_rel_course_rel_user srcru
240 240
                     WHERE
241 241
                         srcru.user_id = sru.user_id AND
242 242
                         srcru.session_id = sru.session_id AND
@@ -244,49 +244,49 @@  discard block
 block discarded – undo
244 244
                         sru.relation_type<>".SESSION_RELATION_TYPE_RRHH." AND
245 245
                         srcru.session_id = '".intval($id_session)."'";
246 246
 
247
-    		$rs = Database::query($sql);
248
-    		$course['nbr_users'] = Database::result($rs,0,0);
247
+            $rs = Database::query($sql);
248
+            $course['nbr_users'] = Database::result($rs,0,0);
249 249
 
250
-    		// Get coachs of the courses in session
250
+            // Get coachs of the courses in session
251 251
 
252
-    		$sql = "SELECT user.lastname,user.firstname,user.username
252
+            $sql = "SELECT user.lastname,user.firstname,user.username
253 253
     		        FROM $tbl_session_rel_course_rel_user session_rcru, $tbl_user user
254 254
     				WHERE
255 255
     				    session_rcru.user_id = user.user_id AND
256 256
     				    session_rcru.session_id = '".intval($id_session)."' AND
257 257
     				    session_rcru.c_id ='".Database::escape_string($course['id'])."' AND
258 258
     				    session_rcru.status=2";
259
-    		$rs = Database::query($sql);
259
+            $rs = Database::query($sql);
260 260
 
261
-    		$coachs = array();
262
-    		if (Database::num_rows($rs) > 0) {
263
-    			while ($info_coach = Database::fetch_array($rs)) {
261
+            $coachs = array();
262
+            if (Database::num_rows($rs) > 0) {
263
+                while ($info_coach = Database::fetch_array($rs)) {
264 264
                     $coachs[] = api_get_person_name(
265 265
                             $info_coach['firstname'],
266 266
                             $info_coach['lastname']
267 267
                         ).' ('.$info_coach['username'].')';
268
-    			}
269
-    		} else {
270
-    			$coach = get_lang('None');
271
-    		}
272
-
273
-    		if (count($coachs) > 0) {
274
-    			$coach = implode('<br />',$coachs);
275
-    		} else {
276
-    			$coach = get_lang('None');
277
-    		}
278
-
279
-    		$orig_param = '&origin=resume_session';
280
-    		//hide_course_breadcrumb the parameter has been added to hide the
268
+                }
269
+            } else {
270
+                $coach = get_lang('None');
271
+            }
272
+
273
+            if (count($coachs) > 0) {
274
+                $coach = implode('<br />',$coachs);
275
+            } else {
276
+                $coach = get_lang('None');
277
+            }
278
+
279
+            $orig_param = '&origin=resume_session';
280
+            //hide_course_breadcrumb the parameter has been added to hide the
281 281
             // name of the course, that appeared in the default $interbreadcrumb
282
-    		echo '
282
+            echo '
283 283
     		<tr>
284 284
     			<td>'.Display::url($course['title'].' ('.$course['visual_code'].')', api_get_path(WEB_COURSE_PATH).$course['code'].'/?id_session='.$id_session),'</td>
285 285
     			<td>'.$coach.'</td>
286 286
     			<td>'.$course['nbr_users'].'</td>
287 287
 
288 288
     		</tr>';
289
-    	}
289
+        }
290 290
     }
291 291
     ?>
292 292
     </table>
@@ -307,11 +307,11 @@  discard block
 block discarded – undo
307 307
     <?php
308 308
 
309 309
     if ($session['nbr_users']==0) {
310
-    	echo '<tr>
310
+        echo '<tr>
311 311
     			<td colspan="2">'.get_lang('NoUsersForThisSession').'</td>
312 312
     		</tr>';
313 313
     } else {
314
-    	$order_clause = api_sort_by_first_name() ? ' ORDER BY firstname, lastname' : ' ORDER BY lastname, firstname';
314
+        $order_clause = api_sort_by_first_name() ? ' ORDER BY firstname, lastname' : ' ORDER BY lastname, firstname';
315 315
 
316 316
         if ($multiple_url_is_on) {
317 317
             $sql = "SELECT u.user_id, lastname, firstname, username, access_url_id
@@ -329,11 +329,11 @@  discard block
 block discarded – undo
329 329
                     AND su.session_id = ".$id_session.$order_clause;
330 330
         }
331 331
 
332
-    	$result = Database::query($sql);
333
-    	$users  = Database::store_result($result);
332
+        $result = Database::query($sql);
333
+        $users  = Database::store_result($result);
334 334
         // change breadcrumb in destination page
335
-    	$orig_param = '&origin=resume_session&id_session='.$id_session;
336
-    	foreach ($users as $user) {
335
+        $orig_param = '&origin=resume_session&id_session='.$id_session;
336
+        foreach ($users as $user) {
337 337
             $user_link = '';
338 338
             if (!empty($user['user_id'])) {
339 339
                 $user_link = '<a href="'.api_get_path(WEB_CODE_PATH).'admin/user_information.php?user_id='.intval($user['user_id']).'">'.
@@ -350,7 +350,7 @@  discard block
 block discarded – undo
350 350
                 }
351 351
             }
352 352
 
353
-    		echo '<tr>
353
+            echo '<tr>
354 354
                     <td width="90%">
355 355
                         '.$user_link.'
356 356
                     </td>
@@ -361,7 +361,7 @@  discard block
 block discarded – undo
361 361
                         '.$link_to_add_user_in_url.'
362 362
                     </td>
363 363
                     </tr>';
364
-    	}
364
+        }
365 365
     }
366 366
     ?>
367 367
     </table>
Please login to merge, or discard this patch.
Spacing   +23 added lines, -23 removed lines patch added patch discarded remove patch
@@ -11,7 +11,7 @@  discard block
 block discarded – undo
11 11
 
12 12
 // setting the section (for the tabs)
13 13
 $this_section = SECTION_PLATFORM_ADMIN;
14
-$id_session = (int)$_GET['id_session'];
14
+$id_session = (int) $_GET['id_session'];
15 15
 SessionManager::protect_teacher_session_edit($id_session);
16 16
 
17 17
 $tool_name = get_lang('SessionOverview');
@@ -59,7 +59,7 @@  discard block
 block discarded – undo
59 59
     $rs = Database::query($sql);
60 60
     $session_category = '';
61 61
 
62
-    if (Database::num_rows($rs)>0) {
62
+    if (Database::num_rows($rs) > 0) {
63 63
     	$rows_session_category = Database::store_result($rs);
64 64
     	$rows_session_category = $rows_session_category[0];
65 65
     	$session_category = $rows_session_category['name'];
@@ -83,25 +83,25 @@  discard block
 block discarded – undo
83 83
             break;
84 84
         case 'delete':
85 85
             $idChecked = $_GET['idChecked'];
86
-            if(is_array($idChecked)) {
86
+            if (is_array($idChecked)) {
87 87
                 $my_temp = array();
88
-                foreach ($idChecked as $id){
88
+                foreach ($idChecked as $id) {
89 89
                     $courseInfo = api_get_course_info($id);
90
-                    $my_temp[]= $courseInfo['real_id'];// forcing the escape_string
90
+                    $my_temp[] = $courseInfo['real_id']; // forcing the escape_string
91 91
                 }
92 92
                 $idChecked = $my_temp;
93 93
                 $idChecked = "'".implode("','", $idChecked)."'";
94 94
 
95 95
                 $result = Database::query("DELETE FROM $tbl_session_rel_course WHERE session_id='$id_session' AND c_id IN($idChecked)");
96
-                $nbr_affected_rows=Database::affected_rows($result);
96
+                $nbr_affected_rows = Database::affected_rows($result);
97 97
 
98 98
                 Database::query("DELETE FROM $tbl_session_rel_course_rel_user WHERE session_id='$id_session' AND c_id IN($idChecked)");
99 99
                 Database::query("UPDATE $tbl_session SET nbr_courses=nbr_courses-$nbr_affected_rows WHERE id='$id_session'");
100 100
             }
101 101
 
102
-            if (!empty($_GET['class'])){
102
+            if (!empty($_GET['class'])) {
103 103
                 $result = Database::query("DELETE FROM $tbl_session_rel_class WHERE session_id='$id_session' AND class_id=".intval($_GET['class']));
104
-                $nbr_affected_rows=Database::affected_rows($result);
104
+                $nbr_affected_rows = Database::affected_rows($result);
105 105
                 Database::query("UPDATE $tbl_session SET nbr_classes=nbr_classes-$nbr_affected_rows WHERE id='$id_session'");
106 106
             }
107 107
 
@@ -111,7 +111,7 @@  discard block
 block discarded – undo
111 111
                 Database::query("UPDATE $tbl_session SET nbr_users=nbr_users-$nbr_affected_rows WHERE id='$id_session'");
112 112
 
113 113
                 $result = Database::query("DELETE FROM $tbl_session_rel_course_rel_user WHERE session_id ='$id_session' AND user_id=".intval($_GET['user']));
114
-                $nbr_affected_rows=Database::affected_rows($result);
114
+                $nbr_affected_rows = Database::affected_rows($result);
115 115
 
116 116
                 Database::query("UPDATE $tbl_session_rel_course SET nbr_users=nbr_users-$nbr_affected_rows WHERE session_id ='$id_session'");
117 117
             }
@@ -137,28 +137,28 @@  discard block
 block discarded – undo
137 137
     	<td><?php echo get_lang('GeneralCoach'); ?> :</td>
138 138
     	<td><?php echo api_get_person_name($session['firstname'], $session['lastname']).' ('.$session['username'].')' ?></td>
139 139
     </tr>
140
-    <?php if(!empty($session_category)) { ?>
140
+    <?php if (!empty($session_category)) { ?>
141 141
     <tr>
142 142
     	<td><?php echo get_lang('SessionCategory') ?></td>
143
-    	<td><?php echo $session_category;  ?></td>
143
+    	<td><?php echo $session_category; ?></td>
144 144
     </tr>
145 145
     <?php } ?>
146 146
     <tr>
147 147
     	<td><?php echo get_lang('Date'); ?> :</td>
148 148
     	<td>
149 149
     	<?php
150
-    		if ($session['access_start_date'] == '00-00-0000' && $session['access_end_date']== '00-00-0000' ) {
150
+    		if ($session['access_start_date'] == '00-00-0000' && $session['access_end_date'] == '00-00-0000') {
151 151
     		    echo get_lang('NoTimeLimits');
152 152
             }
153 153
     		else {
154 154
                 if ($session['access_start_date'] != '00-00-0000') {
155 155
                 	//$session['date_start'] = Display::tag('i', get_lang('NoTimeLimits'));
156
-                    $session['access_start_date'] =  get_lang('From').' '.$session['access_start_date'];
156
+                    $session['access_start_date'] = get_lang('From').' '.$session['access_start_date'];
157 157
                 } else {
158 158
                 	$session['access_start_date'] = '';
159 159
                 }
160 160
                 if ($session['access_end_date'] == '00-00-0000') {
161
-                    $session['access_end_date'] ='';
161
+                    $session['access_end_date'] = '';
162 162
                 } else {
163 163
                 	$session['access_end_date'] = get_lang('Until').' '.$session['access_end_date'];
164 164
                 }
@@ -189,7 +189,7 @@  discard block
 block discarded – undo
189 189
     		<?php echo api_ucfirst(get_lang('SessionVisibility')) ?> :
190 190
     	</td>
191 191
     	<td>
192
-    		<?php if ($session['visibility']==1) echo get_lang('ReadOnly'); elseif($session['visibility']==2) echo get_lang('Visible');elseif($session['visibility']==3) echo api_ucfirst(get_lang('Invisible'))  ?>
192
+    		<?php if ($session['visibility'] == 1) echo get_lang('ReadOnly'); elseif ($session['visibility'] == 2) echo get_lang('Visible'); elseif ($session['visibility'] == 3) echo api_ucfirst(get_lang('Invisible'))  ?>
193 193
     	</td>
194 194
     </tr>
195 195
     <?php
@@ -201,7 +201,7 @@  discard block
 block discarded – undo
201 201
         echo '</td>';
202 202
         echo '<td>';
203 203
         $url_list = UrlManager::get_access_url_from_session($id_session);
204
-        foreach($url_list as $url_data) {
204
+        foreach ($url_list as $url_data) {
205 205
             echo $url_data['url'].'<br />';
206 206
         }
207 207
         echo '</td></tr>';
@@ -231,8 +231,8 @@  discard block
 block discarded – undo
231 231
     			WHERE c.id = sc.c_id
232 232
     			AND	session_id='$id_session'
233 233
     			ORDER BY title";
234
-    	$result=Database::query($sql);
235
-    	$courses=Database::store_result($result);
234
+    	$result = Database::query($sql);
235
+    	$courses = Database::store_result($result);
236 236
     	foreach ($courses as $course) {
237 237
     		//select the number of users
238 238
 
@@ -245,7 +245,7 @@  discard block
 block discarded – undo
245 245
                         srcru.session_id = '".intval($id_session)."'";
246 246
 
247 247
     		$rs = Database::query($sql);
248
-    		$course['nbr_users'] = Database::result($rs,0,0);
248
+    		$course['nbr_users'] = Database::result($rs, 0, 0);
249 249
 
250 250
     		// Get coachs of the courses in session
251 251
 
@@ -271,7 +271,7 @@  discard block
 block discarded – undo
271 271
     		}
272 272
 
273 273
     		if (count($coachs) > 0) {
274
-    			$coach = implode('<br />',$coachs);
274
+    			$coach = implode('<br />', $coachs);
275 275
     		} else {
276 276
     			$coach = get_lang('None');
277 277
     		}
@@ -281,7 +281,7 @@  discard block
 block discarded – undo
281 281
             // name of the course, that appeared in the default $interbreadcrumb
282 282
     		echo '
283 283
     		<tr>
284
-    			<td>'.Display::url($course['title'].' ('.$course['visual_code'].')', api_get_path(WEB_COURSE_PATH).$course['code'].'/?id_session='.$id_session),'</td>
284
+    			<td>'.Display::url($course['title'].' ('.$course['visual_code'].')', api_get_path(WEB_COURSE_PATH).$course['code'].'/?id_session='.$id_session), '</td>
285 285
     			<td>'.$coach.'</td>
286 286
     			<td>'.$course['nbr_users'].'</td>
287 287
 
@@ -306,7 +306,7 @@  discard block
 block discarded – undo
306 306
         </tr>
307 307
     <?php
308 308
 
309
-    if ($session['nbr_users']==0) {
309
+    if ($session['nbr_users'] == 0) {
310 310
     	echo '<tr>
311 311
     			<td colspan="2">'.get_lang('NoUsersForThisSession').'</td>
312 312
     		</tr>';
@@ -337,7 +337,7 @@  discard block
 block discarded – undo
337 337
             $user_link = '';
338 338
             if (!empty($user['user_id'])) {
339 339
                 $user_link = '<a href="'.api_get_path(WEB_CODE_PATH).'admin/user_information.php?user_id='.intval($user['user_id']).'">'.
340
-                    api_htmlentities(api_get_person_name($user['firstname'], $user['lastname']),ENT_QUOTES,$charset).' ('.$user['username'].')</a>';
340
+                    api_htmlentities(api_get_person_name($user['firstname'], $user['lastname']), ENT_QUOTES, $charset).' ('.$user['username'].')</a>';
341 341
             }
342 342
 
343 343
             $link_to_add_user_in_url = '';
Please login to merge, or discard this patch.
Braces   +8 added lines, -3 removed lines patch added patch discarded remove patch
@@ -149,8 +149,7 @@  discard block
 block discarded – undo
149 149
     	<?php
150 150
     		if ($session['access_start_date'] == '00-00-0000' && $session['access_end_date']== '00-00-0000' ) {
151 151
     		    echo get_lang('NoTimeLimits');
152
-            }
153
-    		else {
152
+            } else {
154 153
                 if ($session['access_start_date'] != '00-00-0000') {
155 154
                 	//$session['date_start'] = Display::tag('i', get_lang('NoTimeLimits'));
156 155
                     $session['access_start_date'] =  get_lang('From').' '.$session['access_start_date'];
@@ -189,12 +188,18 @@  discard block
 block discarded – undo
189 188
     		<?php echo api_ucfirst(get_lang('SessionVisibility')) ?> :
190 189
     	</td>
191 190
     	<td>
192
-    		<?php if ($session['visibility']==1) echo get_lang('ReadOnly'); elseif($session['visibility']==2) echo get_lang('Visible');elseif($session['visibility']==3) echo api_ucfirst(get_lang('Invisible'))  ?>
191
+    		<?php if ($session['visibility']==1) {
192
+    echo get_lang('ReadOnly');
193
+} elseif($session['visibility']==2) {
194
+    echo get_lang('Visible');
195
+} elseif($session['visibility']==3) {
196
+    echo api_ucfirst(get_lang('Invisible'))  ?>
193 197
     	</td>
194 198
     </tr>
195 199
     <?php
196 200
 
197 201
     $multiple_url_is_on = api_get_multiple_access_url();
202
+}
198 203
     if ($multiple_url_is_on) {
199 204
         echo '<tr><td>';
200 205
         echo 'URL';
Please login to merge, or discard this patch.
main/user/add_users_to_session.php 3 patches
Braces   +8 added lines, -2 removed lines patch added patch discarded remove patch
@@ -477,7 +477,10 @@  discard block
 block discarded – undo
477 477
     <div class="actions">
478 478
     	<?php echo $link_add_type_unique ?>&nbsp;|&nbsp;<?php echo $link_add_type_multiple ?>&nbsp;|&nbsp;<?php echo $link_add_group; ?>
479 479
     </div>
480
-    <form name="formulaire" method="post" action="<?php echo api_get_self(); ?>?page=<?php echo $page; ?>&id_session=<?php echo $id_session; ?><?php if(!empty($_GET['add'])) echo '&add=true' ; ?>" style="margin:0px;" <?php if($ajax_search){echo ' onsubmit="valide();"';}?>>
480
+    <form name="formulaire" method="post" action="<?php echo api_get_self(); ?>?page=<?php echo $page; ?>&id_session=<?php echo $id_session; ?><?php if(!empty($_GET['add'])) {
481
+    echo '&add=true' ;
482
+}
483
+?>" style="margin:0px;" <?php if($ajax_search){echo ' onsubmit="valide();"';}?>>
481 484
     <?php echo '<legend>'.$tool_name.' ('.$session_info['name'].') </legend>'; ?>
482 485
     <?php
483 486
     if ($add_type == 'multiple') {
@@ -545,7 +548,10 @@  discard block
 block discarded – undo
545 548
                   <?php
546 549
                   foreach ($nosessionUsersList as $uid => $enreg) {
547 550
                   ?>
548
-                      <option value="<?php echo $uid; ?>" <?php if(in_array($uid,$UserList)) echo 'selected="selected"'; ?>><?php echo api_get_person_name($enreg['fn'], $enreg['ln']).' ('.$enreg['un'].')'; ?></option>
551
+                      <option value="<?php echo $uid; ?>" <?php if(in_array($uid,$UserList)) {
552
+    echo 'selected="selected"';
553
+}
554
+?>><?php echo api_get_person_name($enreg['fn'], $enreg['ln']).' ('.$enreg['un'].')'; ?></option>
549 555
                   <?php
550 556
                   }
551 557
                   ?>
Please login to merge, or discard this patch.
Indentation   +106 added lines, -106 removed lines patch added patch discarded remove patch
@@ -49,29 +49,29 @@  discard block
 block discarded – undo
49 49
     $extra_field_list = UserManager::get_extra_fields();
50 50
     $new_field_list = array();
51 51
     if (is_array($extra_field_list)) {
52
-    	foreach ($extra_field_list as $extra_field) {
53
-    		//if is enabled to filter and is a "<select>" field type
54
-    		if ($extra_field[8]==1 && $extra_field[2]==4 ) {
52
+        foreach ($extra_field_list as $extra_field) {
53
+            //if is enabled to filter and is a "<select>" field type
54
+            if ($extra_field[8]==1 && $extra_field[2]==4 ) {
55 55
                 $new_field_list[] = array(
56 56
                     'name' => $extra_field[3],
57 57
                     'variable' => $extra_field[1],
58 58
                     'data' => $extra_field[9],
59 59
                 );
60
-    		}
61
-    	}
60
+            }
61
+        }
62 62
     }
63 63
 
64 64
     function search_users($needle, $type)
65 65
     {
66
-    	global $id_session;
66
+        global $id_session;
67 67
 
68 68
         $tbl_user = Database::get_main_table(TABLE_MAIN_USER);
69 69
         $tbl_session_rel_user = Database::get_main_table(TABLE_MAIN_SESSION_USER);
70 70
 
71
-    	$xajax_response = new xajaxResponse();
72
-    	$return = '';
71
+        $xajax_response = new xajaxResponse();
72
+        $return = '';
73 73
 
74
-    	if (!empty($needle) && !empty($type)) {
74
+        if (!empty($needle) && !empty($type)) {
75 75
 
76 76
             //normal behaviour
77 77
             if ($type == 'any_session' && $needle == 'false')  {
@@ -79,32 +79,32 @@  discard block
 block discarded – undo
79 79
                 $needle = '';
80 80
             }
81 81
 
82
-    		// xajax send utf8 datas... datas in db can be non-utf8 datas
83
-    		$charset = api_get_system_encoding();
84
-    		$needle = Database::escape_string($needle);
85
-    		$needle = api_convert_encoding($needle, $charset, 'utf-8');
82
+            // xajax send utf8 datas... datas in db can be non-utf8 datas
83
+            $charset = api_get_system_encoding();
84
+            $needle = Database::escape_string($needle);
85
+            $needle = api_convert_encoding($needle, $charset, 'utf-8');
86 86
 
87
-    		$order_clause = api_sort_by_first_name() ? ' ORDER BY firstname, lastname, username' : ' ORDER BY lastname, firstname, username';
88
-    		$cond_user_id = '';
87
+            $order_clause = api_sort_by_first_name() ? ' ORDER BY firstname, lastname, username' : ' ORDER BY lastname, firstname, username';
88
+            $cond_user_id = '';
89 89
 
90 90
             //Only for single & multiple
91 91
             if (in_array($type, array('single','multiple'))) {
92
-        		if (!empty($id_session)) {
93
-        		    $id_session = intval($id_session);
94
-        			// check id_user from session_rel_user table
95
-        			$sql = 'SELECT user_id FROM '.$tbl_session_rel_user.'
92
+                if (!empty($id_session)) {
93
+                    $id_session = intval($id_session);
94
+                    // check id_user from session_rel_user table
95
+                    $sql = 'SELECT user_id FROM '.$tbl_session_rel_user.'
96 96
         			        WHERE session_id ="'.$id_session.'" AND relation_type<>'.SESSION_RELATION_TYPE_RRHH.' ';
97
-        			$res = Database::query($sql);
98
-        			$user_ids = array();
99
-        			if (Database::num_rows($res) > 0) {
100
-        				while ($row = Database::fetch_row($res)) {
101
-        					$user_ids[] = (int)$row[0];
102
-        				}
103
-        			}
104
-        			if (count($user_ids) > 0) {
105
-        				$cond_user_id = ' AND user.user_id NOT IN('.implode(",",$user_ids).')';
106
-        			}
107
-        		}
97
+                    $res = Database::query($sql);
98
+                    $user_ids = array();
99
+                    if (Database::num_rows($res) > 0) {
100
+                        while ($row = Database::fetch_row($res)) {
101
+                            $user_ids[] = (int)$row[0];
102
+                        }
103
+                    }
104
+                    if (count($user_ids) > 0) {
105
+                        $cond_user_id = ' AND user.user_id NOT IN('.implode(",",$user_ids).')';
106
+                    }
107
+                }
108 108
             }
109 109
 
110 110
             switch ($type) {
@@ -136,11 +136,11 @@  discard block
 block discarded – undo
136 136
                                 user.status <> 6 '.$cond_user_id.
137 137
                             $order_clause;
138 138
                     break;
139
-    		}
140
-    		if (api_is_multiple_url_enabled()) {
141
-    			$tbl_user_rel_access_url= Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);
142
-    			$access_url_id = api_get_current_access_url_id();
143
-    			if ($access_url_id != -1) {
139
+            }
140
+            if (api_is_multiple_url_enabled()) {
141
+                $tbl_user_rel_access_url= Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);
142
+                $access_url_id = api_get_current_access_url_id();
143
+                if ($access_url_id != -1) {
144 144
                     switch ($type) {
145 145
                         case 'single':
146 146
                             $sql = 'SELECT user.user_id, username, lastname, firstname
@@ -178,36 +178,36 @@  discard block
 block discarded – undo
178 178
                                         user.status<>6 '.$cond_user_id.
179 179
                             $order_clause;
180 180
                             break;
181
-    				}
182
-    			}
183
-    		}
181
+                    }
182
+                }
183
+            }
184 184
 
185
-    		$rs = Database::query($sql);
185
+            $rs = Database::query($sql);
186 186
             $i=0;
187
-    		if ($type == 'single') {
188
-    			while ($user = Database::fetch_array($rs)) {
189
-    	            $i++;
190
-    	            if ($i<=10) {
191
-                		$person_name = api_get_person_name($user['firstname'], $user['lastname']);
192
-    					$return .= '<a href="javascript: void(0);" onclick="javascript: add_user_to_session(\''.$user['user_id'].'\',\''.$person_name.' ('.$user['username'].')'.'\')">'.$person_name.' ('.$user['username'].')</a><br />';
193
-    	            } else {
194
-    	            	$return .= '...<br />';
195
-    	            }
196
-    			}
197
-
198
-    			$xajax_response -> addAssign('ajax_list_users_single','innerHTML',api_utf8_encode($return));
199
-    		} else {
200
-    			global $nosessionUsersList;
201
-    			$return .= '<select id="origin_users" name="nosessionUsersList[]" multiple="multiple" size="15" style="width:360px;">';
202
-    			while ($user = Database :: fetch_array($rs)) {
203
-    				$person_name = api_get_person_name($user['firstname'], $user['lastname']);
204
-    	            $return .= '<option value="'.$user['user_id'].'">'.$person_name.' ('.$user['username'].')</option>';
205
-    			}
206
-    			$return .= '</select>';
207
-    			$xajax_response -> addAssign('ajax_list_users_multiple','innerHTML',api_utf8_encode($return));
208
-    		}
209
-    	}
210
-    	return $xajax_response;
187
+            if ($type == 'single') {
188
+                while ($user = Database::fetch_array($rs)) {
189
+                    $i++;
190
+                    if ($i<=10) {
191
+                        $person_name = api_get_person_name($user['firstname'], $user['lastname']);
192
+                        $return .= '<a href="javascript: void(0);" onclick="javascript: add_user_to_session(\''.$user['user_id'].'\',\''.$person_name.' ('.$user['username'].')'.'\')">'.$person_name.' ('.$user['username'].')</a><br />';
193
+                    } else {
194
+                        $return .= '...<br />';
195
+                    }
196
+                }
197
+
198
+                $xajax_response -> addAssign('ajax_list_users_single','innerHTML',api_utf8_encode($return));
199
+            } else {
200
+                global $nosessionUsersList;
201
+                $return .= '<select id="origin_users" name="nosessionUsersList[]" multiple="multiple" size="15" style="width:360px;">';
202
+                while ($user = Database :: fetch_array($rs)) {
203
+                    $person_name = api_get_person_name($user['firstname'], $user['lastname']);
204
+                    $return .= '<option value="'.$user['user_id'].'">'.$person_name.' ('.$user['username'].')</option>';
205
+                }
206
+                $return .= '</select>';
207
+                $xajax_response -> addAssign('ajax_list_users_multiple','innerHTML',api_utf8_encode($return));
208
+            }
209
+        }
210
+        return $xajax_response;
211 211
     }
212 212
 
213 213
     $xajax -> processRequests();
@@ -343,8 +343,8 @@  discard block
 block discarded – undo
343 343
 
344 344
         if ($use_extra_fields) {
345 345
             $final_result = array();
346
-           	if (count($extra_field_result)>1) {
347
-    	    for($i=0;$i<count($extra_field_result)-1;$i++) {
346
+                if (count($extra_field_result)>1) {
347
+            for($i=0;$i<count($extra_field_result)-1;$i++) {
348 348
                     if (is_array($extra_field_result[$i+1])) {
349 349
                         $final_result = array_intersect(
350 350
                             $extra_field_result[$i],
@@ -422,7 +422,7 @@  discard block
 block discarded – undo
422 422
                     'un' => $user['username']
423 423
                 );
424 424
                 unset($users[$uid]);
425
-    	}
425
+        }
426 426
         }
427 427
         unset($users); //clean to free memory
428 428
 
@@ -467,13 +467,13 @@  discard block
 block discarded – undo
467 467
     }
468 468
 
469 469
     if ($add_type == 'multiple') {
470
-    	$link_add_type_unique = '<a href="'.api_get_self().'?id_session='.$id_session.'&add='.Security::remove_XSS($_GET['add']).'&add_type=unique">'.Display::return_icon('single.gif').get_lang('SessionAddTypeUnique').'</a>';
471
-    	$link_add_type_multiple = Display::return_icon('multiple.gif').get_lang('SessionAddTypeMultiple');
470
+        $link_add_type_unique = '<a href="'.api_get_self().'?id_session='.$id_session.'&add='.Security::remove_XSS($_GET['add']).'&add_type=unique">'.Display::return_icon('single.gif').get_lang('SessionAddTypeUnique').'</a>';
471
+        $link_add_type_multiple = Display::return_icon('multiple.gif').get_lang('SessionAddTypeMultiple');
472 472
     } else {
473
-    	$link_add_type_unique = Display::return_icon('single.gif').get_lang('SessionAddTypeUnique');
474
-    	$link_add_type_multiple = '<a href="'.api_get_self().'?id_session='.$id_session.'&amp;add='.Security::remove_XSS($_GET['add']).'&amp;add_type=multiple">'.Display::return_icon('multiple.gif').get_lang('SessionAddTypeMultiple').'</a>';
473
+        $link_add_type_unique = Display::return_icon('single.gif').get_lang('SessionAddTypeUnique');
474
+        $link_add_type_multiple = '<a href="'.api_get_self().'?id_session='.$id_session.'&amp;add='.Security::remove_XSS($_GET['add']).'&amp;add_type=multiple">'.Display::return_icon('multiple.gif').get_lang('SessionAddTypeMultiple').'</a>';
475 475
     }
476
-    	$link_add_group = '<a href="usergroups.php">'.Display::return_icon('multiple.gif',get_lang('RegistrationByUsersGroups')).get_lang('RegistrationByUsersGroups').'</a>';
476
+        $link_add_group = '<a href="usergroups.php">'.Display::return_icon('multiple.gif',get_lang('RegistrationByUsersGroups')).get_lang('RegistrationByUsersGroups').'</a>';
477 477
     ?>
478 478
     <div class="actions">
479 479
     	<?php echo $link_add_type_unique ?>&nbsp;|&nbsp;<?php echo $link_add_type_multiple ?>&nbsp;|&nbsp;<?php echo $link_add_group; ?>
@@ -482,30 +482,30 @@  discard block
 block discarded – undo
482 482
     <?php echo '<legend>'.$tool_name.' ('.$session_info['name'].') </legend>'; ?>
483 483
     <?php
484 484
     if ($add_type == 'multiple') {
485
-    	if (is_array($extra_field_list)) {
486
-    		if (is_array($new_field_list) && count($new_field_list)>0 ) {
487
-    			echo '<h3>'.get_lang('FilterUsers').'</h3>';
488
-    			foreach ($new_field_list as $new_field) {
489
-    				echo $new_field['name'];
490
-    				$varname = 'field_'.$new_field['variable'];
491
-    				echo '&nbsp;<select name="'.$varname.'">';
492
-    				echo '<option value="0">--'.get_lang('Select').'--</option>';
493
-    				foreach	($new_field['data'] as $option) {
494
-    					$checked='';
495
-    					if (isset($_POST[$varname])) {
496
-    						if ($_POST[$varname] == $option[1]) {
497
-    							$checked = 'selected="true"';
498
-    						}
499
-    					}
500
-    					echo '<option value="'.$option[1].'" '.$checked.'>'.$option[1].'</option>';
501
-    				}
502
-    				echo '</select>';
503
-    				echo '&nbsp;&nbsp;';
504
-    			}
505
-    			echo '<input type="button" value="'.get_lang('Filter').'" onclick="validate_filter()" />';
506
-    			echo '<br /><br />';
507
-    		}
508
-    	}
485
+        if (is_array($extra_field_list)) {
486
+            if (is_array($new_field_list) && count($new_field_list)>0 ) {
487
+                echo '<h3>'.get_lang('FilterUsers').'</h3>';
488
+                foreach ($new_field_list as $new_field) {
489
+                    echo $new_field['name'];
490
+                    $varname = 'field_'.$new_field['variable'];
491
+                    echo '&nbsp;<select name="'.$varname.'">';
492
+                    echo '<option value="0">--'.get_lang('Select').'--</option>';
493
+                    foreach	($new_field['data'] as $option) {
494
+                        $checked='';
495
+                        if (isset($_POST[$varname])) {
496
+                            if ($_POST[$varname] == $option[1]) {
497
+                                $checked = 'selected="true"';
498
+                            }
499
+                        }
500
+                        echo '<option value="'.$option[1].'" '.$checked.'>'.$option[1].'</option>';
501
+                    }
502
+                    echo '</select>';
503
+                    echo '&nbsp;&nbsp;';
504
+                }
505
+                echo '<input type="button" value="'.get_lang('Filter').'" onclick="validate_filter()" />';
506
+                echo '<br /><br />';
507
+            }
508
+        }
509 509
     }
510 510
     ?>
511 511
 
@@ -514,7 +514,7 @@  discard block
 block discarded – undo
514 514
 
515 515
     <?php
516 516
     if (!empty($errorMsg)) {
517
-    	Display::display_normal_message($errorMsg); //main API
517
+        Display::display_normal_message($errorMsg); //main API
518 518
     }
519 519
     ?>
520 520
     <div class="row">
@@ -535,7 +535,7 @@  discard block
 block discarded – undo
535 535
                 <div id="content_source">
536 536
                 <?php
537 537
                 if (!($add_type == 'multiple')) {
538
-                  ?>
538
+                    ?>
539 539
                   <input type="text" id="user_to_add" onkeyup="xajax_search_users(this.value,'single')" />
540 540
                   <div id="ajax_list_users_single"></div>
541 541
                   <?php
@@ -544,12 +544,12 @@  discard block
 block discarded – undo
544 544
                 <div id="ajax_list_users_multiple">
545 545
                 <select id="origin_users" name="nosessionUsersList[]" multiple="multiple" size="15" class="span5">
546 546
                   <?php
547
-                  foreach ($nosessionUsersList as $uid => $enreg) {
548
-                  ?>
547
+                    foreach ($nosessionUsersList as $uid => $enreg) {
548
+                    ?>
549 549
                       <option value="<?php echo $uid; ?>" <?php if(in_array($uid,$UserList)) echo 'selected="selected"'; ?>><?php echo api_get_person_name($enreg['fn'], $enreg['ln']).' ('.$enreg['un'].')'; ?></option>
550 550
                   <?php
551
-                  }
552
-                  ?>
551
+                    }
552
+                    ?>
553 553
                 </select>
554 554
                 </div>
555 555
                     <input type="checkbox" onchange="checked_in_no_session(this.checked);" name="user_with_any_session" id="user_with_any_session_id">
@@ -557,7 +557,7 @@  discard block
 block discarded – undo
557 557
                 <?php
558 558
                 }
559 559
                 unset($nosessionUsersList);
560
-               ?>
560
+                ?>
561 561
             </div>
562 562
         </div>
563 563
 
@@ -584,13 +584,13 @@  discard block
 block discarded – undo
584 584
             <br />
585 585
             <br />
586 586
     		<?php
587
-    		if (isset($_GET['add'])) {
588
-    			echo '<button class="btn btn-primary" type="button" value="" onclick="valide()" >'.get_lang('FinishSessionCreation').'</button>';
587
+            if (isset($_GET['add'])) {
588
+                echo '<button class="btn btn-primary" type="button" value="" onclick="valide()" >'.get_lang('FinishSessionCreation').'</button>';
589 589
             } else {
590 590
                 //@todo see that the call to "valide()" doesn't duplicate the onsubmit of the form (necessary to avoid delete on "enter" key pressed)
591
-    			echo '<button class="save" type="button" value="" onclick="valide()" >'.get_lang('SubscribeUsersToSession').'</button>';
591
+                echo '<button class="save" type="button" value="" onclick="valide()" >'.get_lang('SubscribeUsersToSession').'</button>';
592 592
             }
593
-    		?>
593
+            ?>
594 594
         </div>
595 595
         <div class="span5">
596 596
             <div class="multiple_select_header">
Please login to merge, or discard this patch.
Spacing   +43 added lines, -43 removed lines patch added patch discarded remove patch
@@ -22,9 +22,9 @@  discard block
 block discarded – undo
22 22
 
23 23
 // setting breadcrumbs
24 24
 if (api_is_platform_admin()) {
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' => "resume_session.php?id_session=".$id_session,"name" => get_lang('SessionOverview'));
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' => "resume_session.php?id_session=".$id_session, "name" => get_lang('SessionOverview'));
28 28
 }
29 29
 $allowTutors = api_get_setting('allow_tutors_to_assign_students_to_session');
30 30
 $extra_field_list = [];
@@ -39,7 +39,7 @@  discard block
 block discarded – undo
39 39
     $tool_name = get_lang('SubscribeUsersToSession');
40 40
     $add_type = 'unique';
41 41
 
42
-    if (isset($_REQUEST['add_type']) && $_REQUEST['add_type']!='') {
42
+    if (isset($_REQUEST['add_type']) && $_REQUEST['add_type'] != '') {
43 43
         $add_type = Security::remove_XSS($_REQUEST['add_type']);
44 44
     }
45 45
 
@@ -51,7 +51,7 @@  discard block
 block discarded – undo
51 51
     if (is_array($extra_field_list)) {
52 52
     	foreach ($extra_field_list as $extra_field) {
53 53
     		//if is enabled to filter and is a "<select>" field type
54
-    		if ($extra_field[8]==1 && $extra_field[2]==4 ) {
54
+    		if ($extra_field[8] == 1 && $extra_field[2] == 4) {
55 55
                 $new_field_list[] = array(
56 56
                     'name' => $extra_field[3],
57 57
                     'variable' => $extra_field[1],
@@ -74,7 +74,7 @@  discard block
 block discarded – undo
74 74
     	if (!empty($needle) && !empty($type)) {
75 75
 
76 76
             //normal behaviour
77
-            if ($type == 'any_session' && $needle == 'false')  {
77
+            if ($type == 'any_session' && $needle == 'false') {
78 78
                 $type = 'multiple';
79 79
                 $needle = '';
80 80
             }
@@ -88,7 +88,7 @@  discard block
 block discarded – undo
88 88
     		$cond_user_id = '';
89 89
 
90 90
             //Only for single & multiple
91
-            if (in_array($type, array('single','multiple'))) {
91
+            if (in_array($type, array('single', 'multiple'))) {
92 92
         		if (!empty($id_session)) {
93 93
         		    $id_session = intval($id_session);
94 94
         			// check id_user from session_rel_user table
@@ -98,11 +98,11 @@  discard block
 block discarded – undo
98 98
         			$user_ids = array();
99 99
         			if (Database::num_rows($res) > 0) {
100 100
         				while ($row = Database::fetch_row($res)) {
101
-        					$user_ids[] = (int)$row[0];
101
+        					$user_ids[] = (int) $row[0];
102 102
         				}
103 103
         			}
104 104
         			if (count($user_ids) > 0) {
105
-        				$cond_user_id = ' AND user.user_id NOT IN('.implode(",",$user_ids).')';
105
+        				$cond_user_id = ' AND user.user_id NOT IN('.implode(",", $user_ids).')';
106 106
         			}
107 107
         		}
108 108
             }
@@ -138,7 +138,7 @@  discard block
 block discarded – undo
138 138
                     break;
139 139
     		}
140 140
     		if (api_is_multiple_url_enabled()) {
141
-    			$tbl_user_rel_access_url= Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);
141
+    			$tbl_user_rel_access_url = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);
142 142
     			$access_url_id = api_get_current_access_url_id();
143 143
     			if ($access_url_id != -1) {
144 144
                     switch ($type) {
@@ -183,11 +183,11 @@  discard block
 block discarded – undo
183 183
     		}
184 184
 
185 185
     		$rs = Database::query($sql);
186
-            $i=0;
186
+            $i = 0;
187 187
     		if ($type == 'single') {
188 188
     			while ($user = Database::fetch_array($rs)) {
189 189
     	            $i++;
190
-    	            if ($i<=10) {
190
+    	            if ($i <= 10) {
191 191
                 		$person_name = api_get_person_name($user['firstname'], $user['lastname']);
192 192
     					$return .= '<a href="javascript: void(0);" onclick="javascript: add_user_to_session(\''.$user['user_id'].'\',\''.$person_name.' ('.$user['username'].')'.'\')">'.$person_name.' ('.$user['username'].')</a><br />';
193 193
     	            } else {
@@ -195,7 +195,7 @@  discard block
 block discarded – undo
195 195
     	            }
196 196
     			}
197 197
 
198
-    			$xajax_response -> addAssign('ajax_list_users_single','innerHTML',api_utf8_encode($return));
198
+    			$xajax_response -> addAssign('ajax_list_users_single', 'innerHTML', api_utf8_encode($return));
199 199
     		} else {
200 200
     			global $nosessionUsersList;
201 201
     			$return .= '<select id="origin_users" name="nosessionUsersList[]" multiple="multiple" size="15" style="width:360px;">';
@@ -204,7 +204,7 @@  discard block
 block discarded – undo
204 204
     	            $return .= '<option value="'.$user['user_id'].'">'.$person_name.' ('.$user['username'].')</option>';
205 205
     			}
206 206
     			$return .= '</select>';
207
-    			$xajax_response -> addAssign('ajax_list_users_multiple','innerHTML',api_utf8_encode($return));
207
+    			$xajax_response -> addAssign('ajax_list_users_multiple', 'innerHTML', api_utf8_encode($return));
208 208
     		}
209 209
     	}
210 210
     	return $xajax_response;
@@ -261,7 +261,7 @@  discard block
 block discarded – undo
261 261
     </script>';
262 262
 
263 263
     $form_sent = 0;
264
-    $errorMsg = $firstLetterUser = $firstLetterSession='';
264
+    $errorMsg = $firstLetterUser = $firstLetterSession = '';
265 265
     $UserList = $SessionList = array();
266 266
     $sessions = array();
267 267
     $noPHP_SELF = true;
@@ -273,7 +273,7 @@  discard block
 block discarded – undo
273 273
         $UserList = $_POST['sessionUsersList'];
274 274
 
275 275
         if (!is_array($UserList)) {
276
-            $UserList=array();
276
+            $UserList = array();
277 277
         }
278 278
 
279 279
         if ($form_sent == 1) {
@@ -301,7 +301,7 @@  discard block
 block discarded – undo
301 301
                 WHERE u.status<>".DRH." AND u.status<>6 $order_clause";
302 302
 
303 303
         if (api_is_multiple_url_enabled()) {
304
-            $tbl_user_rel_access_url= Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);
304
+            $tbl_user_rel_access_url = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);
305 305
             $access_url_id = api_get_current_access_url_id();
306 306
             if ($access_url_id != -1) {
307 307
                 $sql = "SELECT u.user_id, lastname, firstname, username, session_id
@@ -317,19 +317,19 @@  discard block
 block discarded – undo
317 317
         $result = Database::query($sql);
318 318
         $users = Database::store_result($result);
319 319
         foreach ($users as $user) {
320
-            $sessionUsersList[$user['user_id']] = $user ;
320
+            $sessionUsersList[$user['user_id']] = $user;
321 321
         }
322 322
         unset($users); //clean to free memory
323 323
     } else {
324 324
         //Filter by Extra Fields
325 325
         $use_extra_fields = false;
326 326
         if (is_array($extra_field_list)) {
327
-            if (is_array($new_field_list) && count($new_field_list)>0 ) {
328
-                $result_list=array();
327
+            if (is_array($new_field_list) && count($new_field_list) > 0) {
328
+                $result_list = array();
329 329
                 foreach ($new_field_list as $new_field) {
330 330
                     $varname = 'field_'.$new_field['variable'];
331 331
                     if (UserManager::is_extra_field_available($new_field['variable'])) {
332
-                        if (isset($_POST[$varname]) && $_POST[$varname]!='0') {
332
+                        if (isset($_POST[$varname]) && $_POST[$varname] != '0') {
333 333
                             $use_extra_fields = true;
334 334
                             $extra_field_result[] = UserManager::get_extra_user_data_by_value(
335 335
                                 $new_field['variable'],
@@ -343,9 +343,9 @@  discard block
 block discarded – undo
343 343
 
344 344
         if ($use_extra_fields) {
345 345
             $final_result = array();
346
-           	if (count($extra_field_result)>1) {
347
-    	    for($i=0;$i<count($extra_field_result)-1;$i++) {
348
-                    if (is_array($extra_field_result[$i+1])) {
346
+           	if (count($extra_field_result) > 1) {
347
+    	    for ($i = 0; $i < count($extra_field_result) - 1; $i++) {
348
+                    if (is_array($extra_field_result[$i + 1])) {
349 349
                         $final_result = array_intersect(
350 350
                             $extra_field_result[$i],
351 351
                             $extra_field_result[$i + 1]
@@ -356,17 +356,17 @@  discard block
 block discarded – undo
356 356
                 $final_result = $extra_field_result[0];
357 357
             }
358 358
 
359
-            $where_filter ='';
359
+            $where_filter = '';
360 360
             if (api_is_multiple_url_enabled()) {
361
-                if (is_array($final_result) && count($final_result)>0) {
362
-                    $where_filter = " AND u.user_id IN  ('".implode("','",$final_result)."') ";
361
+                if (is_array($final_result) && count($final_result) > 0) {
362
+                    $where_filter = " AND u.user_id IN  ('".implode("','", $final_result)."') ";
363 363
                 } else {
364 364
                     //no results
365 365
                     $where_filter = " AND u.user_id  = -1";
366 366
                 }
367 367
             } else {
368
-                if (is_array($final_result) && count($final_result)>0) {
369
-                    $where_filter = " WHERE u.user_id IN  ('".implode("','",$final_result)."') ";
368
+                if (is_array($final_result) && count($final_result) > 0) {
369
+                    $where_filter = " WHERE u.user_id IN  ('".implode("','", $final_result)."') ";
370 370
                 } else {
371 371
                     //no results
372 372
                     $where_filter = " WHERE u.user_id  = -1";
@@ -395,7 +395,7 @@  discard block
 block discarded – undo
395 395
                     $order_clause";
396 396
         }
397 397
         if (api_is_multiple_url_enabled()) {
398
-            $tbl_user_rel_access_url= Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);
398
+            $tbl_user_rel_access_url = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);
399 399
             $access_url_id = api_get_current_access_url_id();
400 400
             if ($access_url_id != -1) {
401 401
                 $sql = "SELECT  u.user_id, lastname, firstname, username, session_id
@@ -412,7 +412,7 @@  discard block
 block discarded – undo
412 412
         }
413 413
 
414 414
         $result = Database::query($sql);
415
-        $users = Database::store_result($result,'ASSOC');
415
+        $users = Database::store_result($result, 'ASSOC');
416 416
 
417 417
         foreach ($users as $uid => $user) {
418 418
             if ($user['session_id'] != $id_session) {
@@ -427,7 +427,7 @@  discard block
 block discarded – undo
427 427
         unset($users); //clean to free memory
428 428
 
429 429
         //filling the correct users in list
430
-        $sql="SELECT  user_id, lastname, firstname, username, session_id
430
+        $sql = "SELECT  user_id, lastname, firstname, username, session_id
431 431
               FROM $tbl_user u
432 432
               LEFT JOIN $tbl_session_rel_user
433 433
               ON
@@ -437,10 +437,10 @@  discard block
 block discarded – undo
437 437
               WHERE u.status<>".DRH." AND u.status<>6 $order_clause";
438 438
 
439 439
         if (api_is_multiple_url_enabled()) {
440
-            $tbl_user_rel_access_url= Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);
440
+            $tbl_user_rel_access_url = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);
441 441
             $access_url_id = api_get_current_access_url_id();
442 442
             if ($access_url_id != -1) {
443
-                $sql="SELECT  u.user_id, lastname, firstname, username, session_id
443
+                $sql = "SELECT  u.user_id, lastname, firstname, username, session_id
444 444
                     FROM $tbl_user u
445 445
                     LEFT JOIN $tbl_session_rel_user
446 446
                     ON
@@ -453,11 +453,11 @@  discard block
 block discarded – undo
453 453
             }
454 454
         }
455 455
         $result = Database::query($sql);
456
-        $users = Database::store_result($result,'ASSOC');
456
+        $users = Database::store_result($result, 'ASSOC');
457 457
         foreach ($users as $uid => $user) {
458 458
             if ($user['session_id'] == $id_session) {
459 459
                 $sessionUsersList[$user['user_id']] = $user;
460
-                if (array_key_exists($user['user_id'],$nosessionUsersList)) {
460
+                if (array_key_exists($user['user_id'], $nosessionUsersList)) {
461 461
                     unset($nosessionUsersList[$user['user_id']]);
462 462
                 }
463 463
             }
@@ -473,25 +473,25 @@  discard block
 block discarded – undo
473 473
     	$link_add_type_unique = Display::return_icon('single.gif').get_lang('SessionAddTypeUnique');
474 474
     	$link_add_type_multiple = '<a href="'.api_get_self().'?id_session='.$id_session.'&amp;add='.Security::remove_XSS($_GET['add']).'&amp;add_type=multiple">'.Display::return_icon('multiple.gif').get_lang('SessionAddTypeMultiple').'</a>';
475 475
     }
476
-    	$link_add_group = '<a href="usergroups.php">'.Display::return_icon('multiple.gif',get_lang('RegistrationByUsersGroups')).get_lang('RegistrationByUsersGroups').'</a>';
476
+    	$link_add_group = '<a href="usergroups.php">'.Display::return_icon('multiple.gif', get_lang('RegistrationByUsersGroups')).get_lang('RegistrationByUsersGroups').'</a>';
477 477
     ?>
478 478
     <div class="actions">
479 479
     	<?php echo $link_add_type_unique ?>&nbsp;|&nbsp;<?php echo $link_add_type_multiple ?>&nbsp;|&nbsp;<?php echo $link_add_group; ?>
480 480
     </div>
481
-    <form name="formulaire" method="post" action="<?php echo api_get_self(); ?>?page=<?php echo $page; ?>&id_session=<?php echo $id_session; ?><?php if(!empty($_GET['add'])) echo '&add=true' ; ?>" style="margin:0px;" <?php if($ajax_search){echo ' onsubmit="valide();"';}?>>
481
+    <form name="formulaire" method="post" action="<?php echo api_get_self(); ?>?page=<?php echo $page; ?>&id_session=<?php echo $id_session; ?><?php if (!empty($_GET['add'])) echo '&add=true'; ?>" style="margin:0px;" <?php if ($ajax_search) {echo ' onsubmit="valide();"'; }?>>
482 482
     <?php echo '<legend>'.$tool_name.' ('.$session_info['name'].') </legend>'; ?>
483 483
     <?php
484 484
     if ($add_type == 'multiple') {
485 485
     	if (is_array($extra_field_list)) {
486
-    		if (is_array($new_field_list) && count($new_field_list)>0 ) {
486
+    		if (is_array($new_field_list) && count($new_field_list) > 0) {
487 487
     			echo '<h3>'.get_lang('FilterUsers').'</h3>';
488 488
     			foreach ($new_field_list as $new_field) {
489 489
     				echo $new_field['name'];
490 490
     				$varname = 'field_'.$new_field['variable'];
491 491
     				echo '&nbsp;<select name="'.$varname.'">';
492 492
     				echo '<option value="0">--'.get_lang('Select').'--</option>';
493
-    				foreach	($new_field['data'] as $option) {
494
-    					$checked='';
493
+    				foreach ($new_field['data'] as $option) {
494
+    					$checked = '';
495 495
     					if (isset($_POST[$varname])) {
496 496
     						if ($_POST[$varname] == $option[1]) {
497 497
     							$checked = 'selected="true"';
@@ -546,7 +546,7 @@  discard block
 block discarded – undo
546 546
                   <?php
547 547
                   foreach ($nosessionUsersList as $uid => $enreg) {
548 548
                   ?>
549
-                      <option value="<?php echo $uid; ?>" <?php if(in_array($uid,$UserList)) echo 'selected="selected"'; ?>><?php echo api_get_person_name($enreg['fn'], $enreg['ln']).' ('.$enreg['un'].')'; ?></option>
549
+                      <option value="<?php echo $uid; ?>" <?php if (in_array($uid, $UserList)) echo 'selected="selected"'; ?>><?php echo api_get_person_name($enreg['fn'], $enreg['ln']).' ('.$enreg['un'].')'; ?></option>
550 550
                   <?php
551 551
                   }
552 552
                   ?>
@@ -598,7 +598,7 @@  discard block
 block discarded – undo
598 598
             </div>
599 599
             <select id="destination_users" name="sessionUsersList[]" multiple="multiple" size="15" class="span5">
600 600
             <?php
601
-            foreach($sessionUsersList as $enreg) {
601
+            foreach ($sessionUsersList as $enreg) {
602 602
             ?>
603 603
                 <option value="<?php echo $enreg['user_id']; ?>"><?php echo api_get_person_name($enreg['firstname'], $enreg['lastname']).' ('.$enreg['username'].')'; ?></option>
604 604
             <?php
Please login to merge, or discard this patch.
main/user/session_list.php 2 patches
Indentation   +4 added lines, -4 removed lines patch added patch discarded remove patch
@@ -65,13 +65,13 @@  discard block
 block discarded – undo
65 65
         array('name'=>'access_end_date',       'index'=>'access_end_date',      'width'=>'40',   'align'=>'left', 'search' => 'true'),
66 66
         array('name'=>'coach_name',     'index'=>'coach_name',    'width'=>'80',   'align'=>'left', 'search' => 'false'),
67 67
         array('name'=>'status',         'index'=>'session_active','width'=>'40',   'align'=>'left', 'search' => 'true', 'stype'=>'select',
68
-          //for the bottom bar
68
+            //for the bottom bar
69 69
             'searchoptions' => array(
70 70
                 'defaultValue' => '1',
71 71
                 'value' => '1:'.get_lang('Active').';0:'.get_lang('Inactive')
72 72
             ),
73
-          //for the top bar
74
-          'editoptions' => array('value' => ':'.get_lang('All').';1:'.get_lang('Active').';0:'.get_lang('Inactive'))),
73
+            //for the top bar
74
+            'editoptions' => array('value' => ':'.get_lang('All').';1:'.get_lang('Active').';0:'.get_lang('Inactive'))),
75 75
         array('name'=>'visibility',     'index'=>'visibility',      'width'=>'40',   'align'=>'left', 'search' => 'false'),
76 76
         array('name'=>'actions',        'index'=>'actions',         'width'=>'100',  'align'=>'left','formatter'=>'action_formatter','sortable'=>'false', 'search' => 'false')
77 77
     );
@@ -86,7 +86,7 @@  discard block
 block discarded – undo
86 86
     //With this function we can add actions to the jgrid (edit, delete, etc)
87 87
     $action_links = 'function action_formatter(cellvalue, options, rowObject) {
88 88
          return \'&nbsp;<a href="add_users_to_session.php?page=session_list.php&id_session=\'+options.rowId+\'">'.Display::return_icon('user_subscribe_session.png',get_lang('SubscribeUsersToSession'),'',ICON_SIZE_SMALL).'</a>'.
89
-         '\';
89
+            '\';
90 90
     }';
91 91
     ?>
92 92
     <script>
Please login to merge, or discard this patch.
Spacing   +16 added lines, -16 removed lines patch added patch discarded remove patch
@@ -56,15 +56,15 @@  discard block
 block discarded – undo
56 56
     );
57 57
 
58 58
     //Column config
59
-    $column_model   = array(
60
-        array('name'=>'name',           'index'=>'name',          'width'=>'160',  'align'=>'left', 'search' => 'true', 'wrap_cell' => "true"),
61
-        array('name'=>'nbr_courses',    'index'=>'nbr_courses',   'width'=>'30',   'align'=>'left', 'search' => 'true'),
62
-        array('name'=>'nbr_users',      'index'=>'nbr_users',     'width'=>'30',   'align'=>'left', 'search' => 'true'),
63
-        array('name'=>'category_name',  'index'=>'category_name', 'width'=>'70',   'align'=>'left', 'search' => 'true'),
64
-        array('name'=>'access_start_date',     'index'=>'access_start_date',    'width'=>'40',   'align'=>'left', 'search' => 'true'),
65
-        array('name'=>'access_end_date',       'index'=>'access_end_date',      'width'=>'40',   'align'=>'left', 'search' => 'true'),
66
-        array('name'=>'coach_name',     'index'=>'coach_name',    'width'=>'80',   'align'=>'left', 'search' => 'false'),
67
-        array('name'=>'status',         'index'=>'session_active','width'=>'40',   'align'=>'left', 'search' => 'true', 'stype'=>'select',
59
+    $column_model = array(
60
+        array('name'=>'name', 'index'=>'name', 'width'=>'160', 'align'=>'left', 'search' => 'true', 'wrap_cell' => "true"),
61
+        array('name'=>'nbr_courses', 'index'=>'nbr_courses', 'width'=>'30', 'align'=>'left', 'search' => 'true'),
62
+        array('name'=>'nbr_users', 'index'=>'nbr_users', 'width'=>'30', 'align'=>'left', 'search' => 'true'),
63
+        array('name'=>'category_name', 'index'=>'category_name', 'width'=>'70', 'align'=>'left', 'search' => 'true'),
64
+        array('name'=>'access_start_date', 'index'=>'access_start_date', 'width'=>'40', 'align'=>'left', 'search' => 'true'),
65
+        array('name'=>'access_end_date', 'index'=>'access_end_date', 'width'=>'40', 'align'=>'left', 'search' => 'true'),
66
+        array('name'=>'coach_name', 'index'=>'coach_name', 'width'=>'80', 'align'=>'left', 'search' => 'false'),
67
+        array('name'=>'status', 'index'=>'session_active', 'width'=>'40', 'align'=>'left', 'search' => 'true', 'stype'=>'select',
68 68
           //for the bottom bar
69 69
             'searchoptions' => array(
70 70
                 'defaultValue' => '1',
@@ -72,8 +72,8 @@  discard block
 block discarded – undo
72 72
             ),
73 73
           //for the top bar
74 74
           'editoptions' => array('value' => ':'.get_lang('All').';1:'.get_lang('Active').';0:'.get_lang('Inactive'))),
75
-        array('name'=>'visibility',     'index'=>'visibility',      'width'=>'40',   'align'=>'left', 'search' => 'false'),
76
-        array('name'=>'actions',        'index'=>'actions',         'width'=>'100',  'align'=>'left','formatter'=>'action_formatter','sortable'=>'false', 'search' => 'false')
75
+        array('name'=>'visibility', 'index'=>'visibility', 'width'=>'40', 'align'=>'left', 'search' => 'false'),
76
+        array('name'=>'actions', 'index'=>'actions', 'width'=>'100', 'align'=>'left', 'formatter'=>'action_formatter', 'sortable'=>'false', 'search' => 'false')
77 77
     );
78 78
     //Autowidth
79 79
     $extra_params['autowidth'] = 'true';
@@ -85,7 +85,7 @@  discard block
 block discarded – undo
85 85
 
86 86
     //With this function we can add actions to the jgrid (edit, delete, etc)
87 87
     $action_links = 'function action_formatter(cellvalue, options, rowObject) {
88
-         return \'&nbsp;<a href="add_users_to_session.php?page=session_list.php&id_session=\'+options.rowId+\'">'.Display::return_icon('user_subscribe_session.png',get_lang('SubscribeUsersToSession'),'',ICON_SIZE_SMALL).'</a>'.
88
+         return \'&nbsp;<a href="add_users_to_session.php?page=session_list.php&id_session=\'+options.rowId+\'">'.Display::return_icon('user_subscribe_session.png', get_lang('SubscribeUsersToSession'), '', ICON_SIZE_SMALL).'</a>'.
89 89
          '\';
90 90
     }';
91 91
     ?>
@@ -106,7 +106,7 @@  discard block
 block discarded – undo
106 106
 
107 107
     $(function() {
108 108
         <?php
109
-            echo Display::grid_js('sessions', $url,$columns,$column_model,$extra_params, array(), $action_links,true);
109
+            echo Display::grid_js('sessions', $url, $columns, $column_model, $extra_params, array(), $action_links, true);
110 110
         ?>
111 111
 
112 112
         setSearchSelect("status");
@@ -148,9 +148,9 @@  discard block
 block discarded – undo
148 148
     <?php if (api_is_platform_admin()) {?>
149 149
         <div class="actions">
150 150
         <?php
151
-        echo '<a href="'.api_get_path(WEB_CODE_PATH).'session/session_add.php">'.Display::return_icon('new_session.png',get_lang('AddSession'),'',ICON_SIZE_MEDIUM).'</a>';
152
-        echo '<a href="'.api_get_path(WEB_CODE_PATH).'session/add_many_session_to_category.php">'.Display::return_icon('session_to_category.png',get_lang('AddSessionsInCategories'),'',ICON_SIZE_MEDIUM).'</a>';
153
-        echo '<a href="'.api_get_path(WEB_CODE_PATH).'session/session_category_list.php">'.Display::return_icon('folder.png',get_lang('ListSessionCategory'),'',ICON_SIZE_MEDIUM).'</a>';
151
+        echo '<a href="'.api_get_path(WEB_CODE_PATH).'session/session_add.php">'.Display::return_icon('new_session.png', get_lang('AddSession'), '', ICON_SIZE_MEDIUM).'</a>';
152
+        echo '<a href="'.api_get_path(WEB_CODE_PATH).'session/add_many_session_to_category.php">'.Display::return_icon('session_to_category.png', get_lang('AddSessionsInCategories'), '', ICON_SIZE_MEDIUM).'</a>';
153
+        echo '<a href="'.api_get_path(WEB_CODE_PATH).'session/session_category_list.php">'.Display::return_icon('folder.png', get_lang('ListSessionCategory'), '', ICON_SIZE_MEDIUM).'</a>';
154 154
         echo '</div>';
155 155
     }
156 156
 } else {
Please login to merge, or discard this patch.
main/user/class.php 1 patch
Spacing   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -146,7 +146,7 @@
 block discarded – undo
146 146
 $(function() {
147 147
 <?php
148 148
     // grid definition see the $usergroup>display() function
149
-    echo Display::grid_js('usergroups',  $url, $columns, $columnModel, $extraParams, array(), '', true);
149
+    echo Display::grid_js('usergroups', $url, $columns, $columnModel, $extraParams, array(), '', true);
150 150
 ?>
151 151
 });
152 152
 </script>
Please login to merge, or discard this patch.
main/user/classes.php 1 patch
Spacing   +2 added lines, -2 removed lines patch added patch discarded remove patch
@@ -12,9 +12,9 @@
 block discarded – undo
12 12
 
13 13
 $this_section = SECTION_COURSES;
14 14
 
15
-$interbreadcrumb[]= array ('url' =>'classes.php','name' => get_lang('Classes'));
15
+$interbreadcrumb[] = array('url' =>'classes.php', 'name' => get_lang('Classes'));
16 16
 if (isset($_GET['id'])) {
17
-    $interbreadcrumb[]= array ('url' =>'#','name' => get_lang('Groups'));
17
+    $interbreadcrumb[] = array('url' =>'#', 'name' => get_lang('Groups'));
18 18
 }
19 19
 
20 20
 Display :: display_header($tool_name, 'Classes');
Please login to merge, or discard this patch.
main/user/user_import.php 1 patch
Spacing   +8 added lines, -8 removed lines patch added patch discarded remove patch
@@ -15,8 +15,8 @@  discard block
 block discarded – undo
15 15
 
16 16
 $tool_name = get_lang('ImportUsersToACourse');
17 17
 
18
-$interbreadcrumb[] = array ("url" => "user.php", "name" => get_lang("Users"));
19
-$interbreadcrumb[] = array ("url" => "#", "name" => get_lang("ImportUsersToACourse"));
18
+$interbreadcrumb[] = array("url" => "user.php", "name" => get_lang("Users"));
19
+$interbreadcrumb[] = array("url" => "#", "name" => get_lang("ImportUsersToACourse"));
20 20
 
21 21
 $form = new FormValidator('user_import', 'post', 'user_import.php');
22 22
 $form->addElement('header', $tool_name);
@@ -42,7 +42,7 @@  discard block
 block discarded – undo
42 42
     if (isset($_FILES['import_file']['size']) && $_FILES['import_file']['size'] !== 0) {
43 43
         $unsubscribe_users = isset($_POST['unsubscribe_users']) ? true : false;
44 44
         //@todo : csvToArray deprecated
45
-        $users  = Import::csvToArray($_FILES['import_file']['tmp_name']);
45
+        $users = Import::csvToArray($_FILES['import_file']['tmp_name']);
46 46
         $invalid_users  = array();
47 47
         $clean_users    = array();
48 48
 
@@ -79,7 +79,7 @@  discard block
 block discarded – undo
79 79
                         $user_ids = array();
80 80
                         foreach ($current_user_list as $user) {
81 81
                             if (!CourseManager::is_course_teacher($user['user_id'], $course_code)) {
82
-                                $user_ids[]= $user['user_id'];
82
+                                $user_ids[] = $user['user_id'];
83 83
                             }
84 84
                         }
85 85
                         CourseManager::unsubscribe_user($user_ids, $course_code, $session_id);
@@ -92,12 +92,12 @@  discard block
 block discarded – undo
92 92
                     if (empty($session_id)) {
93 93
                         //just to make sure
94 94
                         if (CourseManager :: is_user_subscribed_in_course($userId, $course_code)) {
95
-                            $user_to_show[]= $userInfo['complete_name'];
95
+                            $user_to_show[] = $userInfo['complete_name'];
96 96
                         }
97 97
                     } else {
98 98
                         //just to make sure
99 99
                         if (CourseManager::is_user_subscribed_in_course($userId, $course_code, true, $session_id)) {
100
-                            $user_to_show[]= $userInfo['complete_name'];
100
+                            $user_to_show[] = $userInfo['complete_name'];
101 101
                         }
102 102
                     }
103 103
                 }
@@ -105,7 +105,7 @@  discard block
 block discarded – undo
105 105
                 $message = get_lang('CheckUsersWithId');
106 106
                 $type = 'warning';
107 107
                 foreach ($invalid_users as $invalid_user) {
108
-                    $user_to_show[]= $invalid_user;
108
+                    $user_to_show[] = $invalid_user;
109 109
                 }
110 110
             }
111 111
         }
@@ -130,7 +130,7 @@  discard block
 block discarded – undo
130 130
             Display::display_warning_message($message.':  <br />'.$userMessage, false);
131 131
         }
132 132
     } else {
133
-        $empty_line_msg = ($empty_line == 0) ? get_lang('ErrorsWhenImportingFile'): get_lang('ErrorsWhenImportingFile').': '.get_lang('EmptyHeaderLine');
133
+        $empty_line_msg = ($empty_line == 0) ? get_lang('ErrorsWhenImportingFile') : get_lang('ErrorsWhenImportingFile').': '.get_lang('EmptyHeaderLine');
134 134
         Display::display_error_message($empty_line_msg);
135 135
     }
136 136
 }
Please login to merge, or discard this patch.
main/user/subscribe_user.php 3 patches
Spacing   +78 added lines, -78 removed lines patch added patch discarded remove patch
@@ -8,7 +8,7 @@  discard block
 block discarded – undo
8 8
 */
9 9
 
10 10
 require_once '../inc/global.inc.php';
11
-$current_course_tool  = TOOL_USER;
11
+$current_course_tool = TOOL_USER;
12 12
 
13 13
 // the section (for the tabs)
14 14
 $this_section = SECTION_COURSES;
@@ -51,8 +51,8 @@  discard block
 block discarded – undo
51 51
 }
52 52
 
53 53
 $current_session_id = api_get_session_id();
54
-$list_register_user='';
55
-$list_not_register_user='';
54
+$list_register_user = '';
55
+$list_not_register_user = '';
56 56
 
57 57
 if (isset($_REQUEST['register'])) {
58 58
     if ($type == COURSEMANAGER) {
@@ -80,9 +80,9 @@  discard block
 block discarded – undo
80 80
 
81 81
     if (is_array($user_id_temp)) {
82 82
         $counter = count($user_id_temp);
83
-        for ($j=0; $j<$counter;$j++) {
84
-            if 	($user_id_temp[$j]==$_GET['user_id']) {
85
-                if ($result_simple_sub)	{
83
+        for ($j = 0; $j < $counter; $j++) {
84
+            if ($user_id_temp[$j] == $_GET['user_id']) {
85
+                if ($result_simple_sub) {
86 86
                     Display::addFlash(Display::return_message($_SESSION['session_user_name'][$j].' '.get_lang('AddedToCourse')));
87 87
                 } else {
88 88
                     Display::addFlash(Display::return_message($_SESSION['session_user_name'][$j].' '.get_lang('NotAddedToCourse'), 'error'));
@@ -99,7 +99,7 @@  discard block
 block discarded – undo
99 99
 }
100 100
 
101 101
 if (isset($_POST['action'])) {
102
-    switch($_POST['action']) {
102
+    switch ($_POST['action']) {
103 103
         case 'subscribe':
104 104
             if (is_array($_POST['user'])) {
105 105
                 foreach ($_POST['user'] as $index => $user_id) {
@@ -136,7 +136,7 @@  discard block
 block discarded – undo
136 136
             $counter = 0;
137 137
             $is_suscribe_counter = count($is_suscribe_user_id);
138 138
 
139
-            $list_register_user='';
139
+            $list_register_user = '';
140 140
 
141 141
             for ($i = 0; $i < $is_suscribe_counter; $i++) {
142 142
                 for ($j = 0; $j < count($user_id_temp); $j++) {
@@ -195,25 +195,25 @@  discard block
 block discarded – undo
195 195
 $parameters['type'] = $type;
196 196
 $table->set_additional_parameters($parameters);
197 197
 $col = 0;
198
-$table->set_header($col ++, '', false);
199
-$table->set_header($col ++, get_lang('OfficialCode'));
198
+$table->set_header($col++, '', false);
199
+$table->set_header($col++, get_lang('OfficialCode'));
200 200
 if (api_is_western_name_order()) {
201
-    $table->set_header($col ++, get_lang('FirstName'));
202
-    $table->set_header($col ++, get_lang('LastName'));
201
+    $table->set_header($col++, get_lang('FirstName'));
202
+    $table->set_header($col++, get_lang('LastName'));
203 203
 } else {
204
-    $table->set_header($col ++, get_lang('LastName'));
205
-    $table->set_header($col ++, get_lang('FirstName'));
204
+    $table->set_header($col++, get_lang('LastName'));
205
+    $table->set_header($col++, get_lang('FirstName'));
206 206
 }
207 207
 
208 208
 if (api_get_setting('show_email_addresses') == 'true') {
209
-    $table->set_header($col ++, get_lang('Email'));
210
-    $table->set_column_filter($col -1, 'email_filter');
209
+    $table->set_header($col++, get_lang('Email'));
210
+    $table->set_column_filter($col - 1, 'email_filter');
211 211
 }
212 212
 $table->set_header($col++, get_lang('Active'), false);
213
-$table->set_column_filter($col -1, 'active_filter');
214
-$table->set_header($col ++, get_lang('Actions'), false);
215
-$table->set_column_filter($col -1, 'reg_filter');
216
-$table->set_form_actions(array ('subscribe' => get_lang('reg')), 'user');
213
+$table->set_column_filter($col - 1, 'active_filter');
214
+$table->set_header($col++, get_lang('Actions'), false);
215
+$table->set_column_filter($col - 1, 'reg_filter');
216
+$table->set_form_actions(array('subscribe' => get_lang('reg')), 'user');
217 217
 
218 218
 if (!empty($_POST['keyword'])) {
219 219
     $keyword_name = Security::remove_XSS($_POST['keyword']);
@@ -281,7 +281,7 @@  discard block
 block discarded – undo
281 281
     $courseCode = api_get_course_id();
282 282
     $sessionId = api_get_session_id();
283 283
 
284
-	if (isset($_REQUEST['type']) && $_REQUEST['type']=='teacher') {
284
+	if (isset($_REQUEST['type']) && $_REQUEST['type'] == 'teacher') {
285 285
 
286 286
 		if (api_get_session_id() != 0) {
287 287
 
@@ -299,7 +299,7 @@  discard block
 block discarded – undo
299 299
 
300 300
 			if (api_is_multiple_url_enabled()) {
301 301
 				$url_access_id = api_get_current_access_url_id();
302
-				if ($url_access_id !=-1) {
302
+				if ($url_access_id != -1) {
303 303
 					$tbl_url_rel_user = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);
304 304
 					$sql = "SELECT COUNT(u.user_id)
305 305
 							FROM $user_table u
@@ -326,7 +326,7 @@  discard block
 block discarded – undo
326 326
 
327 327
 			if (api_is_multiple_url_enabled()) {
328 328
 				$url_access_id = api_get_current_access_url_id();
329
-				if ($url_access_id !=-1) {
329
+				if ($url_access_id != -1) {
330 330
 					$tbl_url_rel_user = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);
331 331
 
332 332
 					$sql = "SELECT COUNT(u.user_id)
@@ -356,7 +356,7 @@  discard block
 block discarded – undo
356 356
 
357 357
 			if (api_is_multiple_url_enabled()) {
358 358
 				$url_access_id = api_get_current_access_url_id();
359
-				if ($url_access_id !=-1) {
359
+				if ($url_access_id != -1) {
360 360
 					$tbl_url_rel_user = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);
361 361
 					$sql = "SELECT COUNT(u.user_id)
362 362
 							FROM $user_table u
@@ -384,9 +384,9 @@  discard block
 block discarded – undo
384 384
 			if (isset($_GET['subscribe_user_filter_value']) &&
385 385
                 !empty($_GET['subscribe_user_filter_value']) &&
386 386
                 api_get_setting('ProfilingFilterAddingUsers') == 'true'
387
-            ){
388
-				$field_identification = explode('*',$_GET['subscribe_user_filter_value']);
389
-				$sql .=	"
387
+            ) {
388
+				$field_identification = explode('*', $_GET['subscribe_user_filter_value']);
389
+				$sql .= "
390 390
 					LEFT JOIN $table_user_field_values field_values
391 391
 					ON field_values.item_id = u.user_id
392 392
 					WHERE
@@ -395,14 +395,14 @@  discard block
 block discarded – undo
395 395
 						field_values.field_id = '".intval($field_identification[0])."' AND
396 396
 						field_values.value = '".Database::escape_string($field_identification[1])."'
397 397
 					";
398
-			} else	{
399
-				$sql .=	"WHERE cu.user_id IS NULL AND u.status<>".DRH." ";
398
+			} else {
399
+				$sql .= "WHERE cu.user_id IS NULL AND u.status<>".DRH." ";
400 400
 			}
401 401
 
402 402
 			if (api_is_multiple_url_enabled()) {
403 403
 				$url_access_id = api_get_current_access_url_id();
404 404
 
405
-				if ($url_access_id !=-1) {
405
+				if ($url_access_id != -1) {
406 406
 
407 407
 					$tbl_url_rel_user = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);
408 408
 
@@ -449,7 +449,7 @@  discard block
 block discarded – undo
449 449
 			$users_of_course[] = $course_user['user_id'];
450 450
 	    }
451 451
 	}
452
-    $sql .=" AND u.status <> ".ANONYMOUS." ";
452
+    $sql .= " AND u.status <> ".ANONYMOUS." ";
453 453
 	$res = Database::query($sql);
454 454
     $count_user = 0;
455 455
 
@@ -521,8 +521,8 @@  discard block
 block discarded – undo
521 521
 				!empty($_GET['subscribe_user_filter_value']) &&
522 522
 				api_get_setting('ProfilingFilterAddingUsers') == 'true'
523 523
 			) {
524
-				$field_identification = explode('*',$_GET['subscribe_user_filter_value']);
525
-				$sql .=	"
524
+				$field_identification = explode('*', $_GET['subscribe_user_filter_value']);
525
+				$sql .= "
526 526
 					LEFT JOIN $table_user_field_values field_values
527 527
 						ON field_values.item_id = u.user_id
528 528
 					WHERE
@@ -532,10 +532,10 @@  discard block
 block discarded – undo
532 532
 						field_values.field_id = '".intval($field_identification[0])."' AND
533 533
 						field_values.value = '".Database::escape_string($field_identification[1])."'";
534 534
 			} else {
535
-				$sql .=	"WHERE cu.user_id IS NULL AND u.status=1 AND (u.official_code <> 'ADMIN' OR u.official_code IS NULL) ";
535
+				$sql .= "WHERE cu.user_id IS NULL AND u.status=1 AND (u.official_code <> 'ADMIN' OR u.official_code IS NULL) ";
536 536
 			}
537 537
 
538
-            $sql .=	" AND access_url_id= $url_access_id";
538
+            $sql .= " AND access_url_id= $url_access_id";
539 539
 
540 540
 		} else {
541 541
 		     // adding a teacher NOT through a session
@@ -549,21 +549,21 @@  discard block
 block discarded – undo
549 549
 					!empty($_GET['subscribe_user_filter_value']) &&
550 550
 					api_get_setting('ProfilingFilterAddingUsers') == 'true'
551 551
 				) {
552
-					$field_identification = explode('*',$_GET['subscribe_user_filter_value']);
553
-					$sql .=	"
552
+					$field_identification = explode('*', $_GET['subscribe_user_filter_value']);
553
+					$sql .= "
554 554
 						LEFT JOIN $table_user_field_values field_values
555 555
 							ON field_values.item_id = u.user_id
556 556
 						WHERE
557 557
 							cu.user_id IS NULL AND u.status<>".DRH." AND
558 558
 							field_values.field_id = '".intval($field_identification[0])."' AND
559 559
 							field_values.value = '".Database::escape_string($field_identification[1])."'";
560
-				} else	{
561
-					$sql .=	"WHERE cu.user_id IS NULL AND u.status<>".DRH." ";
560
+				} else {
561
+					$sql .= "WHERE cu.user_id IS NULL AND u.status<>".DRH." ";
562 562
 				}
563 563
 
564 564
 				// adding a teacher NOT trough a session on a portal with multiple URLs
565 565
 				if (api_is_multiple_url_enabled()) {
566
-					if ($url_access_id !=-1) {
566
+					if ($url_access_id != -1) {
567 567
 						$sql = "SELECT $select_fields
568 568
 						FROM $user_table u
569 569
 						LEFT JOIN $course_user_table cu
@@ -575,9 +575,9 @@  discard block
 block discarded – undo
575 575
 					if (isset($_GET['subscribe_user_filter_value']) &&
576 576
 						!empty($_GET['subscribe_user_filter_value']) &&
577 577
 						api_get_setting('ProfilingFilterAddingUsers') == 'true'
578
-					){
578
+					) {
579 579
 						$field_identification = explode('*', $_GET['subscribe_user_filter_value']);
580
-						$sql .=	"
580
+						$sql .= "
581 581
 							LEFT JOIN $table_user_field_values field_values
582 582
 								ON field_values.item_id = u.user_id
583 583
 							WHERE
@@ -585,8 +585,8 @@  discard block
 block discarded – undo
585 585
 							 	u.status<>".DRH." AND
586 586
 							 	field_values.field_id = '".intval($field_identification[0])."' AND
587 587
 							 	field_values.value = '".Database::escape_string($field_identification[1])."'";
588
-					} else	{
589
-						$sql .=	"WHERE cu.user_id IS NULL AND u.status<>".DRH." AND access_url_id= $url_access_id ";
588
+					} else {
589
+						$sql .= "WHERE cu.user_id IS NULL AND u.status<>".DRH." AND access_url_id= $url_access_id ";
590 590
 					}
591 591
 				}
592 592
 			}
@@ -607,9 +607,9 @@  discard block
 block discarded – undo
607 607
             }
608 608
 
609 609
             // applying the filter of the additional user profile fields
610
-            if (isset($_GET['subscribe_user_filter_value']) AND !empty($_GET['subscribe_user_filter_value'])){
611
-                $field_identification = explode('*',$_GET['subscribe_user_filter_value']);
612
-                $sql .=	"
610
+            if (isset($_GET['subscribe_user_filter_value']) AND !empty($_GET['subscribe_user_filter_value'])) {
611
+                $field_identification = explode('*', $_GET['subscribe_user_filter_value']);
612
+                $sql .= "
613 613
                     LEFT JOIN $table_user_field_values field_values
614 614
                         ON field_values.item_id = u.user_id
615 615
                     WHERE
@@ -618,15 +618,15 @@  discard block
 block discarded – undo
618 618
                     	(u.official_code <> 'ADMIN' OR u.official_code IS NULL) AND
619 619
                     	field_values.field_id = '".intval($field_identification[0])."' AND
620 620
                     	field_values.value = '".Database::escape_string($field_identification[1])."'";
621
-            } else	{
622
-                $sql .=	"WHERE
621
+            } else {
622
+                $sql .= "WHERE
623 623
                 			cu.user_id IS NULL AND
624 624
                 			u.status<>".DRH." AND
625 625
                 			(u.official_code <> 'ADMIN' OR u.official_code IS NULL) ";
626 626
             }
627 627
 
628 628
             if (api_is_multiple_url_enabled()) {
629
-                $sql .=  "AND access_url_id = $url_access_id";
629
+                $sql .= "AND access_url_id = $url_access_id";
630 630
             }
631 631
 
632 632
 		} else {
@@ -638,9 +638,9 @@  discard block
 block discarded – undo
638 638
                     	c_id ='".$courseId."'";
639 639
 
640 640
 			// applying the filter of the additional user profile fields
641
-			if (isset($_GET['subscribe_user_filter_value']) && !empty($_GET['subscribe_user_filter_value'])){
642
-				$field_identification = explode('*',$_GET['subscribe_user_filter_value']);
643
-				$sql .=	"
641
+			if (isset($_GET['subscribe_user_filter_value']) && !empty($_GET['subscribe_user_filter_value'])) {
642
+				$field_identification = explode('*', $_GET['subscribe_user_filter_value']);
643
+				$sql .= "
644 644
 					LEFT JOIN $table_user_field_values field_values
645 645
 						ON field_values.item_id = u.user_id
646 646
 					WHERE
@@ -648,14 +648,14 @@  discard block
 block discarded – undo
648 648
 						u.status<>".DRH." AND
649 649
 						field_values.field_id = '".intval($field_identification[0])."' AND
650 650
 						field_values.value = '".Database::escape_string($field_identification[1])."'";
651
-			} else	{
652
-				$sql .=	"WHERE cu.user_id IS NULL AND u.status<>".DRH." ";
651
+			} else {
652
+				$sql .= "WHERE cu.user_id IS NULL AND u.status<>".DRH." ";
653 653
 			}
654 654
 
655 655
 			//showing only the courses of the current Chamilo access_url_id
656 656
 
657 657
 			if (api_is_multiple_url_enabled()) {
658
-				if ($url_access_id !=-1) {
658
+				if ($url_access_id != -1) {
659 659
 					$sql = "SELECT $select_fields
660 660
 						FROM $user_table u
661 661
 						LEFT JOIN $course_user_table cu
@@ -667,9 +667,9 @@  discard block
 block discarded – undo
667 667
 					if (isset($_GET['subscribe_user_filter_value']) &&
668 668
 						!empty($_GET['subscribe_user_filter_value']) &&
669 669
 						api_get_setting('ProfilingFilterAddingUsers') == 'true'
670
-					){
670
+					) {
671 671
 						$field_identification = explode('*', $_GET['subscribe_user_filter_value']);
672
-						$sql .=	"
672
+						$sql .= "
673 673
 							LEFT JOIN $table_user_field_values field_values
674 674
 								ON field_values.item_id = u.user_id
675 675
 							WHERE
@@ -679,8 +679,8 @@  discard block
 block discarded – undo
679 679
 								field_values.value = '".Database::escape_string($field_identification[1])."' AND
680 680
 								access_url_id = $url_access_id
681 681
                             ";
682
-					} else	{
683
-						$sql .=	"WHERE cu.user_id IS NULL AND u.status<>".DRH." AND access_url_id= $url_access_id ";
682
+					} else {
683
+						$sql .= "WHERE cu.user_id IS NULL AND u.status<>".DRH." AND access_url_id= $url_access_id ";
684 684
 					}
685 685
 				}
686 686
 			}
@@ -718,14 +718,14 @@  discard block
 block discarded – undo
718 718
 		}
719 719
 	}
720 720
 
721
-	$sql .=" AND u.status != ".ANONYMOUS." ";
721
+	$sql .= " AND u.status != ".ANONYMOUS." ";
722 722
 
723 723
 	// Sorting and pagination (used by the sortable table)
724 724
 	$sql .= " ORDER BY col$column $direction ";
725 725
 	$sql .= " LIMIT $from,$number_of_items";
726 726
 
727 727
 	$res = Database::query($sql);
728
-	$users = array ();
728
+	$users = array();
729 729
 	while ($user = Database::fetch_row($res)) {
730 730
 		$users[] = $user;
731 731
 		$_SESSION['session_user_id'][] = $user[0];
@@ -736,12 +736,12 @@  discard block
 block discarded – undo
736 736
 		}
737 737
 	}
738 738
 	// adding additional users based on the search on the additional profile fields
739
-	if (isset($_REQUEST['keyword'])){
739
+	if (isset($_REQUEST['keyword'])) {
740 740
 		if (is_array($additional_users)) {
741
-			foreach($additional_users as $additional_user_key=>$additional_user_value){
741
+			foreach ($additional_users as $additional_user_key=>$additional_user_value) {
742 742
 				if (!in_array($additional_user_key, $_SESSION['session_user_id']) &&
743
-                    !in_array($additional_user_key,$users_of_course)
744
-                ){
743
+                    !in_array($additional_user_key, $users_of_course)
744
+                ) {
745 745
                     $users[] = array(
746 746
                         $additional_user_value['col0'],
747 747
                         $additional_user_value['col1'],
@@ -792,20 +792,20 @@  discard block
 block discarded – undo
792 792
 
793 793
 function active_filter($active, $url_params, $row) {
794 794
 	$_user = api_get_user_info();
795
-	if ($active=='1') {
796
-		$action='AccountActive';
797
-		$image='accept';
795
+	if ($active == '1') {
796
+		$action = 'AccountActive';
797
+		$image = 'accept';
798 798
 	}
799 799
 
800
-	if ($active=='0') {
801
-		$action='AccountInactive';
802
-		$image='error';
800
+	if ($active == '0') {
801
+		$action = 'AccountInactive';
802
+		$image = 'error';
803 803
 	}
804 804
     $result = null;
805
-	if ($row['0']<>$_user['user_id']) {
805
+	if ($row['0'] <> $_user['user_id']) {
806 806
 	// you cannot lock yourself out otherwise you could disable all the accounts
807 807
 	// including your own => everybody is locked out and nobody can change it anymore.
808
-		$result = Display::return_icon($image.'.png',  get_lang(ucfirst($action)), array() , ICON_SIZE_TINY);
808
+		$result = Display::return_icon($image.'.png', get_lang(ucfirst($action)), array(), ICON_SIZE_TINY);
809 809
 	}
810 810
 	return $result;
811 811
 }
@@ -839,7 +839,7 @@  discard block
 block discarded – undo
839 839
 		$profiling_field_options_exact_values[] = $profiling_field_options;
840 840
 	}
841 841
     $profiling_field_options_exact_values_sql = '';
842
-	foreach ($profiling_field_options_exact_values as $profilingkey => $profilingvalue){
842
+	foreach ($profiling_field_options_exact_values as $profilingkey => $profilingvalue) {
843 843
 		$profiling_field_options_exact_values_sql .= " OR (field_id = '".$profilingvalue['field_id']."' AND value='".$profilingvalue['option_value']."') ";
844 844
 	}
845 845
 
@@ -880,9 +880,9 @@  discard block
 block discarded – undo
880 880
 function display_extra_profile_fields_filter()
881 881
 {
882 882
 	// getting all the additional user profile fields
883
-	$extra = UserManager::get_extra_fields(0,50,5,'ASC');
883
+	$extra = UserManager::get_extra_fields(0, 50, 5, 'ASC');
884 884
 
885
-	$return='<option value="">'.get_lang('SelectFilter').'</option>';
885
+	$return = '<option value="">'.get_lang('SelectFilter').'</option>';
886 886
 
887 887
 	// looping through the additional user profile fields
888 888
 	foreach ($extra as $id => $field_details) {
@@ -898,7 +898,7 @@  discard block
 block discarded – undo
898 898
 			case ExtraField::FIELD_TYPE_SELECT:
899 899
 			case ExtraField::FIELD_TYPE_SELECT_MULTIPLE:
900 900
 				$return .= '<optgroup label="'.$field_details[3].'">';
901
-				foreach($field_details[9] as $option_id => $option_details) {
901
+				foreach ($field_details[9] as $option_id => $option_details) {
902 902
 					if ($_GET['subscribe_user_filter_value'] == $field_details[0].'*'.$option_details[1]) {
903 903
 						$selected = 'selected="selected"';
904 904
 					} else {
Please login to merge, or discard this patch.
Doc Comments   -1 removed lines patch added patch discarded remove patch
@@ -735,7 +735,6 @@
 block discarded – undo
735 735
  * lock = the user can no longer use this account
736 736
  * @author Patrick Cool <[email protected]>, Ghent University
737 737
  * @param int $active the current state of the account
738
- * @param int $user_id The user id
739 738
  * @param string $urlParams
740 739
  *
741 740
  * @return string Some HTML-code with the lock/unlock button
Please login to merge, or discard this patch.
Indentation   +297 added lines, -297 removed lines patch added patch discarded remove patch
@@ -24,7 +24,7 @@  discard block
 block discarded – undo
24 24
 
25 25
 // Access restriction
26 26
 if (!api_is_allowed_to_edit()) {
27
-	 api_not_allowed(true);
27
+        api_not_allowed(true);
28 28
 }
29 29
 
30 30
 $tool_name = get_lang("SubscribeUserToCourse");
@@ -34,7 +34,7 @@  discard block
 block discarded – undo
34 34
 $courseInfo = api_get_course_info();
35 35
 
36 36
 if ($type == COURSEMANAGER) {
37
-	$tool_name = get_lang("SubscribeUserToCourseAsTeacher");
37
+    $tool_name = get_lang("SubscribeUserToCourseAsTeacher");
38 38
 }
39 39
 
40 40
 //extra entries in breadcrumb
@@ -47,7 +47,7 @@  discard block
 block discarded – undo
47 47
         "url" => "subscribe_user.php?type=".$type.'&'.api_get_cidreq(),
48 48
         "name" => $tool_name,
49 49
     );
50
-	$tool_name = get_lang('SearchResults');
50
+    $tool_name = get_lang('SearchResults');
51 51
 }
52 52
 
53 53
 $current_session_id = api_get_session_id();
@@ -76,7 +76,7 @@  discard block
 block discarded – undo
76 76
         );
77 77
     }
78 78
 
79
-	$user_id_temp = $_SESSION['session_user_id'];
79
+    $user_id_temp = $_SESSION['session_user_id'];
80 80
 
81 81
     if (is_array($user_id_temp)) {
82 82
         $counter = count($user_id_temp);
@@ -169,16 +169,16 @@  discard block
 block discarded – undo
169 169
 
170 170
             header('Location:'.api_get_path(WEB_CODE_PATH).'user/user.php?'.api_get_cidreq().'&type='.$type);
171 171
             exit;
172
-			break;
173
-	}
172
+            break;
173
+    }
174 174
 }
175 175
 
176 176
 if (!empty($_SESSION['session_user_id'])) {
177
-	unset($_SESSION['session_user_id']);
177
+    unset($_SESSION['session_user_id']);
178 178
 }
179 179
 
180 180
 if (!empty($_SESSION['session_user_name'])) {
181
-	unset($_SESSION['session_user_name']);
181
+    unset($_SESSION['session_user_name']);
182 182
 }
183 183
 
184 184
 $is_western_name_order = api_is_western_name_order();
@@ -186,10 +186,10 @@  discard block
 block discarded – undo
186 186
 
187 187
 // Build table
188 188
 $table = new SortableTable(
189
-	'subscribe_users',
190
-	'get_number_of_users',
191
-	'get_user_data',
192
-	($is_western_name_order xor $sort_by_first_name) ? 3 : 2
189
+    'subscribe_users',
190
+    'get_number_of_users',
191
+    'get_user_data',
192
+    ($is_western_name_order xor $sort_by_first_name) ? 3 : 2
193 193
 );
194 194
 $parameters['keyword'] = $keyword;
195 195
 $parameters['type'] = $type;
@@ -272,20 +272,20 @@  discard block
 block discarded – undo
272 272
  */
273 273
 function get_number_of_users()
274 274
 {
275
-	// Database table definition
276
-	$user_table = Database::get_main_table(TABLE_MAIN_USER);
277
-	$course_user_table = Database::get_main_table(TABLE_MAIN_COURSE_USER);
278
-	$tbl_session_rel_course_user = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER);
279
-	$table_user_field_values = Database::get_main_table(TABLE_EXTRA_FIELD_VALUES);
275
+    // Database table definition
276
+    $user_table = Database::get_main_table(TABLE_MAIN_USER);
277
+    $course_user_table = Database::get_main_table(TABLE_MAIN_COURSE_USER);
278
+    $tbl_session_rel_course_user = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER);
279
+    $table_user_field_values = Database::get_main_table(TABLE_EXTRA_FIELD_VALUES);
280 280
 
281 281
     $courseCode = api_get_course_id();
282 282
     $sessionId = api_get_session_id();
283 283
 
284
-	if (isset($_REQUEST['type']) && $_REQUEST['type']=='teacher') {
284
+    if (isset($_REQUEST['type']) && $_REQUEST['type']=='teacher') {
285 285
 
286
-		if (api_get_session_id() != 0) {
286
+        if (api_get_session_id() != 0) {
287 287
 
288
-			$sql = "SELECT COUNT(u.user_id)
288
+            $sql = "SELECT COUNT(u.user_id)
289 289
 					FROM $user_table u
290 290
 					LEFT JOIN $tbl_session_rel_course_user cu
291 291
 					ON
@@ -297,11 +297,11 @@  discard block
 block discarded – undo
297 297
 						u.status = 1 AND
298 298
 						(u.official_code <> 'ADMIN' OR u.official_code IS NULL) ";
299 299
 
300
-			if (api_is_multiple_url_enabled()) {
301
-				$url_access_id = api_get_current_access_url_id();
302
-				if ($url_access_id !=-1) {
303
-					$tbl_url_rel_user = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);
304
-					$sql = "SELECT COUNT(u.user_id)
300
+            if (api_is_multiple_url_enabled()) {
301
+                $url_access_id = api_get_current_access_url_id();
302
+                if ($url_access_id !=-1) {
303
+                    $tbl_url_rel_user = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);
304
+                    $sql = "SELECT COUNT(u.user_id)
305 305
 							FROM $user_table u
306 306
 							LEFT JOIN $tbl_session_rel_course_user cu
307 307
 							ON
@@ -315,34 +315,34 @@  discard block
 block discarded – undo
315 315
 								u.status = 1 AND
316 316
 								(u.official_code <> 'ADMIN' OR u.official_code IS NULL)
317 317
 							";
318
-				}
319
-			}
320
-		} else {
321
-			$sql = "SELECT COUNT(u.user_id)
318
+                }
319
+            }
320
+        } else {
321
+            $sql = "SELECT COUNT(u.user_id)
322 322
 					FROM $user_table u
323 323
 					LEFT JOIN $course_user_table cu
324 324
 					ON u.user_id = cu.user_id and c_id='".api_get_course_int_id()."'
325 325
 				    WHERE cu.user_id IS NULL AND u.status<>".DRH." ";
326 326
 
327
-			if (api_is_multiple_url_enabled()) {
328
-				$url_access_id = api_get_current_access_url_id();
329
-				if ($url_access_id !=-1) {
330
-					$tbl_url_rel_user = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);
327
+            if (api_is_multiple_url_enabled()) {
328
+                $url_access_id = api_get_current_access_url_id();
329
+                if ($url_access_id !=-1) {
330
+                    $tbl_url_rel_user = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);
331 331
 
332
-					$sql = "SELECT COUNT(u.user_id)
332
+                    $sql = "SELECT COUNT(u.user_id)
333 333
 						FROM $user_table u
334 334
 						LEFT JOIN $course_user_table cu
335 335
 						ON u.user_id = cu.user_id AND c_id='".api_get_course_int_id()."'
336 336
 						INNER JOIN  $tbl_url_rel_user as url_rel_user
337 337
 						ON (url_rel_user.user_id = u.user_id)
338 338
 						WHERE cu.user_id IS NULL AND u.status<>".DRH." AND access_url_id= $url_access_id ";
339
-				}
340
-			}
341
-		}
342
-	} else {
343
-		// students
344
-		if (api_get_session_id() != 0) {
345
-			$sql = "SELECT COUNT(u.user_id)
339
+                }
340
+            }
341
+        }
342
+    } else {
343
+        // students
344
+        if (api_get_session_id() != 0) {
345
+            $sql = "SELECT COUNT(u.user_id)
346 346
 					FROM $user_table u
347 347
 					LEFT JOIN $tbl_session_rel_course_user cu
348 348
 					ON
@@ -354,11 +354,11 @@  discard block
 block discarded – undo
354 354
 						u.status<>".DRH." AND
355 355
 						(u.official_code <> 'ADMIN' OR u.official_code IS NULL) ";
356 356
 
357
-			if (api_is_multiple_url_enabled()) {
358
-				$url_access_id = api_get_current_access_url_id();
359
-				if ($url_access_id !=-1) {
360
-					$tbl_url_rel_user = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);
361
-					$sql = "SELECT COUNT(u.user_id)
357
+            if (api_is_multiple_url_enabled()) {
358
+                $url_access_id = api_get_current_access_url_id();
359
+                if ($url_access_id !=-1) {
360
+                    $tbl_url_rel_user = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);
361
+                    $sql = "SELECT COUNT(u.user_id)
362 362
 							FROM $user_table u
363 363
 							LEFT JOIN $tbl_session_rel_course_user cu
364 364
 							ON
@@ -372,21 +372,21 @@  discard block
 block discarded – undo
372 372
 								u.status<>".DRH." AND
373 373
 								access_url_id= $url_access_id AND
374 374
 								(u.official_code <> 'ADMIN' OR u.official_code IS NULL) ";
375
-				}
376
-			}
377
-		} else {
378
-			$sql = "SELECT COUNT(u.user_id)
375
+                }
376
+            }
377
+        } else {
378
+            $sql = "SELECT COUNT(u.user_id)
379 379
 					FROM $user_table u
380 380
 					LEFT JOIN $course_user_table cu
381 381
 					ON u.user_id = cu.user_id AND c_id='".api_get_course_int_id()."'";
382 382
 
383
-			// we change the SQL when we have a filter
384
-			if (isset($_GET['subscribe_user_filter_value']) &&
383
+            // we change the SQL when we have a filter
384
+            if (isset($_GET['subscribe_user_filter_value']) &&
385 385
                 !empty($_GET['subscribe_user_filter_value']) &&
386 386
                 api_get_setting('ProfilingFilterAddingUsers') == 'true'
387 387
             ){
388
-				$field_identification = explode('*',$_GET['subscribe_user_filter_value']);
389
-				$sql .=	"
388
+                $field_identification = explode('*',$_GET['subscribe_user_filter_value']);
389
+                $sql .=	"
390 390
 					LEFT JOIN $table_user_field_values field_values
391 391
 					ON field_values.item_id = u.user_id
392 392
 					WHERE
@@ -395,32 +395,32 @@  discard block
 block discarded – undo
395 395
 						field_values.field_id = '".intval($field_identification[0])."' AND
396 396
 						field_values.value = '".Database::escape_string($field_identification[1])."'
397 397
 					";
398
-			} else	{
399
-				$sql .=	"WHERE cu.user_id IS NULL AND u.status<>".DRH." ";
400
-			}
398
+            } else	{
399
+                $sql .=	"WHERE cu.user_id IS NULL AND u.status<>".DRH." ";
400
+            }
401 401
 
402
-			if (api_is_multiple_url_enabled()) {
403
-				$url_access_id = api_get_current_access_url_id();
402
+            if (api_is_multiple_url_enabled()) {
403
+                $url_access_id = api_get_current_access_url_id();
404 404
 
405
-				if ($url_access_id !=-1) {
405
+                if ($url_access_id !=-1) {
406 406
 
407
-					$tbl_url_rel_user = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);
407
+                    $tbl_url_rel_user = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);
408 408
 
409
-					$sql = "SELECT COUNT(u.user_id)
409
+                    $sql = "SELECT COUNT(u.user_id)
410 410
 							FROM $user_table u
411 411
 							LEFT JOIN $course_user_table cu on u.user_id = cu.user_id and c_id='".api_get_course_int_id()."'
412 412
 							INNER JOIN  $tbl_url_rel_user as url_rel_user
413 413
 							ON (url_rel_user.user_id = u.user_id)
414 414
 							WHERE cu.user_id IS NULL AND access_url_id= $url_access_id AND u.status<>".DRH." ";
415
-				}
416
-			}
417
-		}
418
-	}
419
-
420
-	// when there is a keyword then we are searching and we have to change the SQL statement
421
-	if (isset($_GET['keyword']) AND !empty($_GET['keyword'])) {
422
-		$keyword = Database::escape_string(trim($_REQUEST['keyword']));
423
-		$sql .= " AND (
415
+                }
416
+            }
417
+        }
418
+    }
419
+
420
+    // when there is a keyword then we are searching and we have to change the SQL statement
421
+    if (isset($_GET['keyword']) AND !empty($_GET['keyword'])) {
422
+        $keyword = Database::escape_string(trim($_REQUEST['keyword']));
423
+        $sql .= " AND (
424 424
 		    firstname LIKE '%".$keyword."%' OR
425 425
 		    lastname LIKE '%".$keyword."%' OR
426 426
 		    email LIKE '%".$keyword."%' OR
@@ -428,37 +428,37 @@  discard block
 block discarded – undo
428 428
 		    official_code LIKE '%".$keyword."%'
429 429
         )";
430 430
 
431
-		// we also want to search for users who have something in their profile fields that matches the keyword
432
-		if (api_get_setting('ProfilingFilterAddingUsers') == 'true') {
433
-			$additional_users = search_additional_profile_fields($keyword);
434
-		}
431
+        // we also want to search for users who have something in their profile fields that matches the keyword
432
+        if (api_get_setting('ProfilingFilterAddingUsers') == 'true') {
433
+            $additional_users = search_additional_profile_fields($keyword);
434
+        }
435 435
 
436
-		// getting all the users of the course (to make sure that we do not display users that are already in the course)
437
-		if (!empty($_SESSION["id_session"])) {
436
+        // getting all the users of the course (to make sure that we do not display users that are already in the course)
437
+        if (!empty($_SESSION["id_session"])) {
438 438
             $a_course_users = CourseManager:: get_user_list_from_course_code(
439 439
                 $courseCode,
440 440
                 $sessionId
441 441
             );
442
-		} else {
442
+        } else {
443 443
             $a_course_users = CourseManager:: get_user_list_from_course_code(
444 444
                 $courseCode,
445 445
                 0
446 446
             );
447
-	    }
448
-		foreach ($a_course_users as $user_id=>$course_user) {
449
-			$users_of_course[] = $course_user['user_id'];
450
-	    }
451
-	}
447
+        }
448
+        foreach ($a_course_users as $user_id=>$course_user) {
449
+            $users_of_course[] = $course_user['user_id'];
450
+        }
451
+    }
452 452
     $sql .=" AND u.status <> ".ANONYMOUS." ";
453
-	$res = Database::query($sql);
453
+    $res = Database::query($sql);
454 454
     $count_user = 0;
455 455
 
456 456
     if ($res) {
457
-	   $row = Database::fetch_row($res);
458
-	   $count_user = $row[0];
459
-	}
457
+        $row = Database::fetch_row($res);
458
+        $count_user = $row[0];
459
+    }
460 460
 
461
-	return $count_user;
461
+    return $count_user;
462 462
 }
463 463
 /**
464 464
  * Get the users to display on the current page.
@@ -468,17 +468,17 @@  discard block
 block discarded – undo
468 468
     $url_access_id = api_get_current_access_url_id();
469 469
     $course_code = api_get_course_id();
470 470
     $session_id = api_get_session_id();
471
-	$courseId = api_get_course_int_id();
471
+    $courseId = api_get_course_int_id();
472 472
 
473
-	// Database table definitions
474
-	$user_table = Database::get_main_table(TABLE_MAIN_USER);
475
-	$course_user_table = Database::get_main_table(TABLE_MAIN_COURSE_USER);
476
-	$tbl_session_rel_course_user = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER);
477
-	$table_user_field_values = Database::get_main_table(TABLE_EXTRA_FIELD_VALUES);
473
+    // Database table definitions
474
+    $user_table = Database::get_main_table(TABLE_MAIN_USER);
475
+    $course_user_table = Database::get_main_table(TABLE_MAIN_COURSE_USER);
476
+    $tbl_session_rel_course_user = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER);
477
+    $table_user_field_values = Database::get_main_table(TABLE_EXTRA_FIELD_VALUES);
478 478
     $tbl_url_rel_user = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);
479 479
 
480 480
     // adding teachers
481
-	$is_western_name_order = api_is_western_name_order();
481
+    $is_western_name_order = api_is_western_name_order();
482 482
 
483 483
     if (api_get_setting('show_email_addresses') == 'true') {
484 484
 
@@ -503,10 +503,10 @@  discard block
 block discarded – undo
503 503
                 u.active               AS col4,
504 504
                 u.user_id              AS col5";
505 505
     }
506
-	if (isset($_REQUEST['type']) && $_REQUEST['type'] == COURSEMANAGER) {
507
-		// adding a teacher through a session
508
-		if (!empty($session_id)) {
509
-			$sql = "SELECT $select_fields
506
+    if (isset($_REQUEST['type']) && $_REQUEST['type'] == COURSEMANAGER) {
507
+        // adding a teacher through a session
508
+        if (!empty($session_id)) {
509
+            $sql = "SELECT $select_fields
510 510
 					FROM $user_table u
511 511
 					LEFT JOIN $tbl_session_rel_course_user cu
512 512
 					ON
@@ -516,13 +516,13 @@  discard block
 block discarded – undo
516 516
                     INNER JOIN  $tbl_url_rel_user as url_rel_user
517 517
                     ON (url_rel_user.user_id = u.user_id) ";
518 518
 
519
-			// applying the filter of the additional user profile fields
520
-			if (isset($_GET['subscribe_user_filter_value']) &&
521
-				!empty($_GET['subscribe_user_filter_value']) &&
522
-				api_get_setting('ProfilingFilterAddingUsers') == 'true'
523
-			) {
524
-				$field_identification = explode('*',$_GET['subscribe_user_filter_value']);
525
-				$sql .=	"
519
+            // applying the filter of the additional user profile fields
520
+            if (isset($_GET['subscribe_user_filter_value']) &&
521
+                !empty($_GET['subscribe_user_filter_value']) &&
522
+                api_get_setting('ProfilingFilterAddingUsers') == 'true'
523
+            ) {
524
+                $field_identification = explode('*',$_GET['subscribe_user_filter_value']);
525
+                $sql .=	"
526 526
 					LEFT JOIN $table_user_field_values field_values
527 527
 						ON field_values.item_id = u.user_id
528 528
 					WHERE
@@ -531,53 +531,53 @@  discard block
 block discarded – undo
531 531
 						(u.official_code <> 'ADMIN' OR u.official_code IS NULL) AND
532 532
 						field_values.field_id = '".intval($field_identification[0])."' AND
533 533
 						field_values.value = '".Database::escape_string($field_identification[1])."'";
534
-			} else {
535
-				$sql .=	"WHERE cu.user_id IS NULL AND u.status=1 AND (u.official_code <> 'ADMIN' OR u.official_code IS NULL) ";
536
-			}
534
+            } else {
535
+                $sql .=	"WHERE cu.user_id IS NULL AND u.status=1 AND (u.official_code <> 'ADMIN' OR u.official_code IS NULL) ";
536
+            }
537 537
 
538 538
             $sql .=	" AND access_url_id= $url_access_id";
539 539
 
540
-		} else {
541
-		     // adding a teacher NOT through a session
542
-			$sql = "SELECT $select_fields
540
+        } else {
541
+                // adding a teacher NOT through a session
542
+            $sql = "SELECT $select_fields
543 543
                     FROM $user_table u
544 544
                     LEFT JOIN $course_user_table cu
545 545
                     ON u.user_id = cu.user_id AND c_id = '".$courseId."'";
546 546
 
547
-				// applying the filter of the additional user profile fields
548
-				if (isset($_GET['subscribe_user_filter_value']) &&
549
-					!empty($_GET['subscribe_user_filter_value']) &&
550
-					api_get_setting('ProfilingFilterAddingUsers') == 'true'
551
-				) {
552
-					$field_identification = explode('*',$_GET['subscribe_user_filter_value']);
553
-					$sql .=	"
547
+                // applying the filter of the additional user profile fields
548
+                if (isset($_GET['subscribe_user_filter_value']) &&
549
+                    !empty($_GET['subscribe_user_filter_value']) &&
550
+                    api_get_setting('ProfilingFilterAddingUsers') == 'true'
551
+                ) {
552
+                    $field_identification = explode('*',$_GET['subscribe_user_filter_value']);
553
+                    $sql .=	"
554 554
 						LEFT JOIN $table_user_field_values field_values
555 555
 							ON field_values.item_id = u.user_id
556 556
 						WHERE
557 557
 							cu.user_id IS NULL AND u.status<>".DRH." AND
558 558
 							field_values.field_id = '".intval($field_identification[0])."' AND
559 559
 							field_values.value = '".Database::escape_string($field_identification[1])."'";
560
-				} else	{
561
-					$sql .=	"WHERE cu.user_id IS NULL AND u.status<>".DRH." ";
562
-				}
563
-
564
-				// adding a teacher NOT trough a session on a portal with multiple URLs
565
-				if (api_is_multiple_url_enabled()) {
566
-					if ($url_access_id !=-1) {
567
-						$sql = "SELECT $select_fields
560
+                } else	{
561
+                    $sql .=	"WHERE cu.user_id IS NULL AND u.status<>".DRH." ";
562
+                }
563
+
564
+                // adding a teacher NOT trough a session on a portal with multiple URLs
565
+                if (api_is_multiple_url_enabled()) {
566
+                    if ($url_access_id !=-1) {
567
+                        $sql = "SELECT $select_fields
568 568
 						FROM $user_table u
569 569
 						LEFT JOIN $course_user_table cu
570 570
 						ON u.user_id = cu.user_id and c_id='".$courseId."'
571 571
 						INNER JOIN  $tbl_url_rel_user as url_rel_user
572 572
 						ON (url_rel_user.user_id = u.user_id) ";
573 573
 
574
-					// applying the filter of the additional user profile fields
575
-					if (isset($_GET['subscribe_user_filter_value']) &&
576
-						!empty($_GET['subscribe_user_filter_value']) &&
577
-						api_get_setting('ProfilingFilterAddingUsers') == 'true'
578
-					){
579
-						$field_identification = explode('*', $_GET['subscribe_user_filter_value']);
580
-						$sql .=	"
574
+                    // applying the filter of the additional user profile fields
575
+                    if (isset($_GET['subscribe_user_filter_value']) &&
576
+                        !empty($_GET['subscribe_user_filter_value']) &&
577
+                        api_get_setting('ProfilingFilterAddingUsers') == 'true'
578
+                    ){
579
+                        $field_identification = explode('*', $_GET['subscribe_user_filter_value']);
580
+                        $sql .=	"
581 581
 							LEFT JOIN $table_user_field_values field_values
582 582
 								ON field_values.item_id = u.user_id
583 583
 							WHERE
@@ -585,16 +585,16 @@  discard block
 block discarded – undo
585 585
 							 	u.status<>".DRH." AND
586 586
 							 	field_values.field_id = '".intval($field_identification[0])."' AND
587 587
 							 	field_values.value = '".Database::escape_string($field_identification[1])."'";
588
-					} else	{
589
-						$sql .=	"WHERE cu.user_id IS NULL AND u.status<>".DRH." AND access_url_id= $url_access_id ";
590
-					}
591
-				}
592
-			}
593
-		}
594
-	} else {
595
-		// adding a student
596
-		if (!empty($session_id)) {
597
-			$sql = "SELECT $select_fields
588
+                    } else	{
589
+                        $sql .=	"WHERE cu.user_id IS NULL AND u.status<>".DRH." AND access_url_id= $url_access_id ";
590
+                    }
591
+                }
592
+            }
593
+        }
594
+    } else {
595
+        // adding a student
596
+        if (!empty($session_id)) {
597
+            $sql = "SELECT $select_fields
598 598
                     FROM $user_table u
599 599
                     LEFT JOIN $tbl_session_rel_course_user cu
600 600
                     ON
@@ -629,7 +629,7 @@  discard block
 block discarded – undo
629 629
                 $sql .=  "AND access_url_id = $url_access_id";
630 630
             }
631 631
 
632
-		} else {
632
+        } else {
633 633
             $sql = "SELECT $select_fields
634 634
                     FROM $user_table u
635 635
                     LEFT JOIN $course_user_table cu
@@ -637,10 +637,10 @@  discard block
 block discarded – undo
637 637
                     	u.user_id = cu.user_id AND
638 638
                     	c_id ='".$courseId."'";
639 639
 
640
-			// applying the filter of the additional user profile fields
641
-			if (isset($_GET['subscribe_user_filter_value']) && !empty($_GET['subscribe_user_filter_value'])){
642
-				$field_identification = explode('*',$_GET['subscribe_user_filter_value']);
643
-				$sql .=	"
640
+            // applying the filter of the additional user profile fields
641
+            if (isset($_GET['subscribe_user_filter_value']) && !empty($_GET['subscribe_user_filter_value'])){
642
+                $field_identification = explode('*',$_GET['subscribe_user_filter_value']);
643
+                $sql .=	"
644 644
 					LEFT JOIN $table_user_field_values field_values
645 645
 						ON field_values.item_id = u.user_id
646 646
 					WHERE
@@ -648,28 +648,28 @@  discard block
 block discarded – undo
648 648
 						u.status<>".DRH." AND
649 649
 						field_values.field_id = '".intval($field_identification[0])."' AND
650 650
 						field_values.value = '".Database::escape_string($field_identification[1])."'";
651
-			} else	{
652
-				$sql .=	"WHERE cu.user_id IS NULL AND u.status<>".DRH." ";
653
-			}
651
+            } else	{
652
+                $sql .=	"WHERE cu.user_id IS NULL AND u.status<>".DRH." ";
653
+            }
654 654
 
655
-			//showing only the courses of the current Chamilo access_url_id
655
+            //showing only the courses of the current Chamilo access_url_id
656 656
 
657
-			if (api_is_multiple_url_enabled()) {
658
-				if ($url_access_id !=-1) {
659
-					$sql = "SELECT $select_fields
657
+            if (api_is_multiple_url_enabled()) {
658
+                if ($url_access_id !=-1) {
659
+                    $sql = "SELECT $select_fields
660 660
 						FROM $user_table u
661 661
 						LEFT JOIN $course_user_table cu
662 662
 						ON u.user_id = cu.user_id AND c_id='".$courseId."'
663 663
 						INNER JOIN  $tbl_url_rel_user as url_rel_user
664 664
 						ON (url_rel_user.user_id = u.user_id) ";
665 665
 
666
-					// applying the filter of the additional user profile fields
667
-					if (isset($_GET['subscribe_user_filter_value']) &&
668
-						!empty($_GET['subscribe_user_filter_value']) &&
669
-						api_get_setting('ProfilingFilterAddingUsers') == 'true'
670
-					){
671
-						$field_identification = explode('*', $_GET['subscribe_user_filter_value']);
672
-						$sql .=	"
666
+                    // applying the filter of the additional user profile fields
667
+                    if (isset($_GET['subscribe_user_filter_value']) &&
668
+                        !empty($_GET['subscribe_user_filter_value']) &&
669
+                        api_get_setting('ProfilingFilterAddingUsers') == 'true'
670
+                    ){
671
+                        $field_identification = explode('*', $_GET['subscribe_user_filter_value']);
672
+                        $sql .=	"
673 673
 							LEFT JOIN $table_user_field_values field_values
674 674
 								ON field_values.item_id = u.user_id
675 675
 							WHERE
@@ -679,19 +679,19 @@  discard block
 block discarded – undo
679 679
 								field_values.value = '".Database::escape_string($field_identification[1])."' AND
680 680
 								access_url_id = $url_access_id
681 681
                             ";
682
-					} else	{
683
-						$sql .=	"WHERE cu.user_id IS NULL AND u.status<>".DRH." AND access_url_id= $url_access_id ";
684
-					}
685
-				}
686
-			}
687
-		}
688
-	}
689
-
690
-	// adding additional WHERE statements to the SQL for the search functionality
682
+                    } else	{
683
+                        $sql .=	"WHERE cu.user_id IS NULL AND u.status<>".DRH." AND access_url_id= $url_access_id ";
684
+                    }
685
+                }
686
+            }
687
+        }
688
+    }
689
+
690
+    // adding additional WHERE statements to the SQL for the search functionality
691 691
     $additional_users = null;
692
-	if (isset($_REQUEST['keyword'])) {
693
-		$keyword = Database::escape_string(trim($_REQUEST['keyword']));
694
-		$sql .= " AND (
692
+    if (isset($_REQUEST['keyword'])) {
693
+        $keyword = Database::escape_string(trim($_REQUEST['keyword']));
694
+        $sql .= " AND (
695 695
 					firstname LIKE '%".$keyword."%' OR
696 696
 					lastname LIKE '%".$keyword."%' OR
697 697
 					email LIKE '%".$keyword."%' OR
@@ -700,46 +700,46 @@  discard block
 block discarded – undo
700 700
 					)
701 701
 				";
702 702
 
703
-		if (api_get_setting('ProfilingFilterAddingUsers') == 'true') {
704
-			// we also want to search for users who have something in
705
-			// their profile fields that matches the keyword
706
-			$additional_users = search_additional_profile_fields($keyword);
707
-		}
708
-
709
-		// getting all the users of the course (to make sure that we do not
710
-		// display users that are already in the course)
711
-		if (!empty($session_id)) {
712
-			$a_course_users = CourseManager :: get_user_list_from_course_code($course_code, $session_id);
713
-		} else {
714
-			$a_course_users = CourseManager :: get_user_list_from_course_code($course_code, 0);
715
-	    }
716
-		foreach ($a_course_users as $user_id=>$course_user) {
717
-			$users_of_course[] = $course_user['user_id'];
718
-		}
719
-	}
720
-
721
-	$sql .=" AND u.status != ".ANONYMOUS." ";
722
-
723
-	// Sorting and pagination (used by the sortable table)
724
-	$sql .= " ORDER BY col$column $direction ";
725
-	$sql .= " LIMIT $from,$number_of_items";
726
-
727
-	$res = Database::query($sql);
728
-	$users = array ();
729
-	while ($user = Database::fetch_row($res)) {
730
-		$users[] = $user;
731
-		$_SESSION['session_user_id'][] = $user[0];
732
-		if ($is_western_name_order) {
733
-			$_SESSION['session_user_name'][] = api_get_person_name($user[2], $user[3]);
734
-		} else {
735
-			$_SESSION['session_user_name'][] = api_get_person_name($user[3], $user[2]);
736
-		}
737
-	}
738
-	// adding additional users based on the search on the additional profile fields
739
-	if (isset($_REQUEST['keyword'])){
740
-		if (is_array($additional_users)) {
741
-			foreach($additional_users as $additional_user_key=>$additional_user_value){
742
-				if (!in_array($additional_user_key, $_SESSION['session_user_id']) &&
703
+        if (api_get_setting('ProfilingFilterAddingUsers') == 'true') {
704
+            // we also want to search for users who have something in
705
+            // their profile fields that matches the keyword
706
+            $additional_users = search_additional_profile_fields($keyword);
707
+        }
708
+
709
+        // getting all the users of the course (to make sure that we do not
710
+        // display users that are already in the course)
711
+        if (!empty($session_id)) {
712
+            $a_course_users = CourseManager :: get_user_list_from_course_code($course_code, $session_id);
713
+        } else {
714
+            $a_course_users = CourseManager :: get_user_list_from_course_code($course_code, 0);
715
+        }
716
+        foreach ($a_course_users as $user_id=>$course_user) {
717
+            $users_of_course[] = $course_user['user_id'];
718
+        }
719
+    }
720
+
721
+    $sql .=" AND u.status != ".ANONYMOUS." ";
722
+
723
+    // Sorting and pagination (used by the sortable table)
724
+    $sql .= " ORDER BY col$column $direction ";
725
+    $sql .= " LIMIT $from,$number_of_items";
726
+
727
+    $res = Database::query($sql);
728
+    $users = array ();
729
+    while ($user = Database::fetch_row($res)) {
730
+        $users[] = $user;
731
+        $_SESSION['session_user_id'][] = $user[0];
732
+        if ($is_western_name_order) {
733
+            $_SESSION['session_user_name'][] = api_get_person_name($user[2], $user[3]);
734
+        } else {
735
+            $_SESSION['session_user_name'][] = api_get_person_name($user[3], $user[2]);
736
+        }
737
+    }
738
+    // adding additional users based on the search on the additional profile fields
739
+    if (isset($_REQUEST['keyword'])){
740
+        if (is_array($additional_users)) {
741
+            foreach($additional_users as $additional_user_key=>$additional_user_value){
742
+                if (!in_array($additional_user_key, $_SESSION['session_user_id']) &&
743 743
                     !in_array($additional_user_key,$users_of_course)
744 744
                 ){
745 745
                     $users[] = array(
@@ -751,11 +751,11 @@  discard block
 block discarded – undo
751 751
                         $additional_user_value['col5'],
752 752
                         $additional_user_value['col6'],
753 753
                     );
754
-				}
755
-			}
756
-		}
757
-	}
758
-	return $users;
754
+                }
755
+            }
756
+        }
757
+    }
758
+    return $users;
759 759
 }
760 760
 /**
761 761
 * Returns a mailto-link
@@ -763,7 +763,7 @@  discard block
 block discarded – undo
763 763
 * @return string HTML-code with a mailto-link
764 764
 */
765 765
 function email_filter($email) {
766
-	return Display :: encrypted_mailto_link($email, $email);
766
+    return Display :: encrypted_mailto_link($email, $email);
767 767
 }
768 768
 /**
769 769
  * Build the reg-column of the table
@@ -776,8 +776,8 @@  discard block
 block discarded – undo
776 776
     } else {
777 777
         $type = STUDENT;
778 778
     }
779
-	$result = '<a class="btn btn-small btn-primary" href="'.api_get_self().'?register=yes&type='.$type.'&user_id='.$user_id.'">'.get_lang("reg").'</a>';
780
-	return $result;
779
+    $result = '<a class="btn btn-small btn-primary" href="'.api_get_self().'?register=yes&type='.$type.'&user_id='.$user_id.'">'.get_lang("reg").'</a>';
780
+    return $result;
781 781
 }
782 782
 
783 783
 /**
@@ -791,23 +791,23 @@  discard block
 block discarded – undo
791 791
  */
792 792
 
793 793
 function active_filter($active, $url_params, $row) {
794
-	$_user = api_get_user_info();
795
-	if ($active=='1') {
796
-		$action='AccountActive';
797
-		$image='accept';
798
-	}
799
-
800
-	if ($active=='0') {
801
-		$action='AccountInactive';
802
-		$image='error';
803
-	}
794
+    $_user = api_get_user_info();
795
+    if ($active=='1') {
796
+        $action='AccountActive';
797
+        $image='accept';
798
+    }
799
+
800
+    if ($active=='0') {
801
+        $action='AccountInactive';
802
+        $image='error';
803
+    }
804 804
     $result = null;
805
-	if ($row['0']<>$_user['user_id']) {
806
-	// you cannot lock yourself out otherwise you could disable all the accounts
807
-	// including your own => everybody is locked out and nobody can change it anymore.
808
-		$result = Display::return_icon($image.'.png',  get_lang(ucfirst($action)), array() , ICON_SIZE_TINY);
809
-	}
810
-	return $result;
805
+    if ($row['0']<>$_user['user_id']) {
806
+    // you cannot lock yourself out otherwise you could disable all the accounts
807
+    // including your own => everybody is locked out and nobody can change it anymore.
808
+        $result = Display::return_icon($image.'.png',  get_lang(ucfirst($action)), array() , ICON_SIZE_TINY);
809
+    }
810
+    return $result;
811 811
 }
812 812
 
813 813
 /**
@@ -825,29 +825,29 @@  discard block
 block discarded – undo
825 825
  */
826 826
 function search_additional_profile_fields($keyword)
827 827
 {
828
-	// database table definitions
829
-	$table_user_field_options = Database :: get_main_table(TABLE_EXTRA_FIELD_OPTIONS);
830
-	$table_user_field_values = Database::get_main_table(TABLE_EXTRA_FIELD_VALUES);
828
+    // database table definitions
829
+    $table_user_field_options = Database :: get_main_table(TABLE_EXTRA_FIELD_OPTIONS);
830
+    $table_user_field_values = Database::get_main_table(TABLE_EXTRA_FIELD_VALUES);
831 831
     $tableExtraField = Database::get_main_table(TABLE_EXTRA_FIELD);
832
-	$table_user = Database::get_main_table(TABLE_MAIN_USER);
832
+    $table_user = Database::get_main_table(TABLE_MAIN_USER);
833 833
 
834
-	// getting the field option text that match this keyword (for radio buttons and checkboxes)
835
-	$sql = "SELECT * FROM $table_user_field_options
834
+    // getting the field option text that match this keyword (for radio buttons and checkboxes)
835
+    $sql = "SELECT * FROM $table_user_field_options
836 836
 	        WHERE display_text LIKE '%".$keyword."%'";
837
-	$result_profiling = Database::query($sql);
838
-	while ($profiling_field_options = Database::fetch_array($result_profiling)) {
839
-		$profiling_field_options_exact_values[] = $profiling_field_options;
840
-	}
837
+    $result_profiling = Database::query($sql);
838
+    while ($profiling_field_options = Database::fetch_array($result_profiling)) {
839
+        $profiling_field_options_exact_values[] = $profiling_field_options;
840
+    }
841 841
     $profiling_field_options_exact_values_sql = '';
842
-	foreach ($profiling_field_options_exact_values as $profilingkey => $profilingvalue){
843
-		$profiling_field_options_exact_values_sql .= " OR (field_id = '".$profilingvalue['field_id']."' AND value='".$profilingvalue['option_value']."') ";
844
-	}
842
+    foreach ($profiling_field_options_exact_values as $profilingkey => $profilingvalue){
843
+        $profiling_field_options_exact_values_sql .= " OR (field_id = '".$profilingvalue['field_id']."' AND value='".$profilingvalue['option_value']."') ";
844
+    }
845 845
 
846 846
     $extraFieldType = \Chamilo\CoreBundle\Entity\ExtraField::USER_FIELD_TYPE;
847 847
 
848
-	// getting all the user ids of the users who have chosen on of the predefined fields that contain the keyword
849
-	// or all the users who have entered the keyword in a free-form field
850
-	$sql = "SELECT
848
+    // getting all the user ids of the users who have chosen on of the predefined fields that contain the keyword
849
+    // or all the users who have entered the keyword in a free-form field
850
+    $sql = "SELECT
851 851
 	            user.user_id as col0,
852 852
 	            user.official_code as col1,
853 853
 	            user.lastname as col2,
@@ -861,13 +861,13 @@  discard block
 block discarded – undo
861 861
                 user_values.field_id = e.id AND
862 862
                 e.extra_field_type = $extraFieldType AND
863 863
                 (value LIKE '%".$keyword."%'".$profiling_field_options_exact_values_sql.")";
864
-	$result = Database::query($sql);
864
+    $result = Database::query($sql);
865 865
     $additional_users = array();
866
-	while ($profiled_users = Database::fetch_array($result)) {
867
-		$additional_users[$profiled_users['col0']] = $profiled_users;
868
-	}
866
+    while ($profiled_users = Database::fetch_array($result)) {
867
+        $additional_users[$profiled_users['col0']] = $profiled_users;
868
+    }
869 869
 
870
-	return $additional_users;
870
+    return $additional_users;
871 871
 }
872 872
 
873 873
 /**
@@ -879,41 +879,41 @@  discard block
 block discarded – undo
879 879
  */
880 880
 function display_extra_profile_fields_filter()
881 881
 {
882
-	// getting all the additional user profile fields
883
-	$extra = UserManager::get_extra_fields(0,50,5,'ASC');
884
-
885
-	$return='<option value="">'.get_lang('SelectFilter').'</option>';
886
-
887
-	// looping through the additional user profile fields
888
-	foreach ($extra as $id => $field_details) {
889
-		// $field_details[2] contains the type of the additional user profile field
890
-		switch ($field_details[2]) {
891
-			// text fields cannot be used as a filter
892
-			case ExtraField::FIELD_TYPE_TEXT:
893
-				break;
894
-			// text area fields cannot be used as a filter
895
-			case ExtraField::FIELD_TYPE_TEXTAREA:
896
-				break;
897
-			case ExtraField::FIELD_TYPE_RADIO:
898
-			case ExtraField::FIELD_TYPE_SELECT:
899
-			case ExtraField::FIELD_TYPE_SELECT_MULTIPLE:
900
-				$return .= '<optgroup label="'.$field_details[3].'">';
901
-				foreach($field_details[9] as $option_id => $option_details) {
902
-					if ($_GET['subscribe_user_filter_value'] == $field_details[0].'*'.$option_details[1]) {
903
-						$selected = 'selected="selected"';
904
-					} else {
905
-						$selected = false;
906
-					}
907
-					$return .= '<option value="'.$field_details[0].'*'.$option_details[1].'" '.$selected.'>'.$option_details[2].'</option>';
908
-				}
909
-				$return .= '</optgroup>';
910
-				break;
911
-		}
912
-	}
913
-
914
-	echo '<form id="subscribe_user_filter" name="subscribe_user_filter" method="get" action="'.api_get_self().'?api_get_cidreq" style="float:left;">';
915
-	echo '	<input type="hidden" name="type" id="type" value="'.Security::remove_XSS($_REQUEST['type']).'" />';
916
-	echo   '<select name="subscribe_user_filter_value" id="subscribe_user_filter_value">'.$return.'</select>';
917
-	echo   '<button type="submit" name="submit_filter" id="submit_filter" value="" class="search">'.get_lang('Filter').'</button>';
918
-	echo '</form>';
882
+    // getting all the additional user profile fields
883
+    $extra = UserManager::get_extra_fields(0,50,5,'ASC');
884
+
885
+    $return='<option value="">'.get_lang('SelectFilter').'</option>';
886
+
887
+    // looping through the additional user profile fields
888
+    foreach ($extra as $id => $field_details) {
889
+        // $field_details[2] contains the type of the additional user profile field
890
+        switch ($field_details[2]) {
891
+            // text fields cannot be used as a filter
892
+            case ExtraField::FIELD_TYPE_TEXT:
893
+                break;
894
+            // text area fields cannot be used as a filter
895
+            case ExtraField::FIELD_TYPE_TEXTAREA:
896
+                break;
897
+            case ExtraField::FIELD_TYPE_RADIO:
898
+            case ExtraField::FIELD_TYPE_SELECT:
899
+            case ExtraField::FIELD_TYPE_SELECT_MULTIPLE:
900
+                $return .= '<optgroup label="'.$field_details[3].'">';
901
+                foreach($field_details[9] as $option_id => $option_details) {
902
+                    if ($_GET['subscribe_user_filter_value'] == $field_details[0].'*'.$option_details[1]) {
903
+                        $selected = 'selected="selected"';
904
+                    } else {
905
+                        $selected = false;
906
+                    }
907
+                    $return .= '<option value="'.$field_details[0].'*'.$option_details[1].'" '.$selected.'>'.$option_details[2].'</option>';
908
+                }
909
+                $return .= '</optgroup>';
910
+                break;
911
+        }
912
+    }
913
+
914
+    echo '<form id="subscribe_user_filter" name="subscribe_user_filter" method="get" action="'.api_get_self().'?api_get_cidreq" style="float:left;">';
915
+    echo '	<input type="hidden" name="type" id="type" value="'.Security::remove_XSS($_REQUEST['type']).'" />';
916
+    echo   '<select name="subscribe_user_filter_value" id="subscribe_user_filter_value">'.$return.'</select>';
917
+    echo   '<button type="submit" name="submit_filter" id="submit_filter" value="" class="search">'.get_lang('Filter').'</button>';
918
+    echo '</form>';
919 919
 }
Please login to merge, or discard this patch.
main/user/subscribe_class.php 1 patch
Spacing   +7 added lines, -7 removed lines patch added patch discarded remove patch
@@ -51,7 +51,7 @@  discard block
 block discarded – undo
51 51
     $courseCode = api_get_course_id();
52 52
 
53 53
     $sql = "SELECT * FROM $course_class_table
54
-            WHERE course_code = '" . $courseCode. "'";
54
+            WHERE course_code = '".$courseCode."'";
55 55
     $res = Database::query($sql);
56 56
     $subscribed_classes = array();
57 57
     while ($obj = Database::fetch_object($res)) {
@@ -60,10 +60,10 @@  discard block
 block discarded – undo
60 60
     $sql = "SELECT c.id	FROM $class_table c WHERE 1 = 1";
61 61
     if (isset($_GET['keyword'])) {
62 62
         $keyword = Database::escape_string(trim($_GET['keyword']));
63
-        $sql .= " AND (c.name LIKE '%" . $keyword . "%')";
63
+        $sql .= " AND (c.name LIKE '%".$keyword."%')";
64 64
     }
65 65
     if (count($subscribed_classes) > 0) {
66
-        $sql .= " AND c.id NOT IN ('" . implode("','", $subscribed_classes) . "')";
66
+        $sql .= " AND c.id NOT IN ('".implode("','", $subscribed_classes)."')";
67 67
     }
68 68
     $res = Database::query($sql);
69 69
     $result = Database::num_rows($res);
@@ -81,7 +81,7 @@  discard block
 block discarded – undo
81 81
     $class_user_table = Database :: get_main_table(TABLE_MAIN_CLASS_USER);
82 82
     $courseCode = api_get_course_id();
83 83
 
84
-    $sql = "SELECT * FROM $course_class_table WHERE course_code = '" . $courseCode . "'";
84
+    $sql = "SELECT * FROM $course_class_table WHERE course_code = '".$courseCode."'";
85 85
     $res = Database::query($sql);
86 86
     $subscribed_classes = array();
87 87
     while ($obj = Database::fetch_object($res)) {
@@ -97,10 +97,10 @@  discard block
 block discarded – undo
97 97
     $sql .= " WHERE 1 = 1";
98 98
     if (isset($_GET['keyword'])) {
99 99
         $keyword = Database::escape_string(trim($_GET['keyword']));
100
-        $sql .= " AND (c.name LIKE '%" . $keyword . "%')";
100
+        $sql .= " AND (c.name LIKE '%".$keyword."%')";
101 101
     }
102 102
     if (count($subscribed_classes) > 0) {
103
-        $sql .= " AND c.id NOT IN ('" . implode("','", $subscribed_classes) . "')";
103
+        $sql .= " AND c.id NOT IN ('".implode("','", $subscribed_classes)."')";
104 104
     }
105 105
     $sql .= " GROUP BY c.id, c.name ";
106 106
     $sql .= " ORDER BY col$column $direction ";
@@ -119,7 +119,7 @@  discard block
 block discarded – undo
119 119
  * @return string Some HTML-code
120 120
  */
121 121
 function reg_filter($class_id) {
122
-    $result = "<a href=\"" . api_get_self() . "?register=yes&amp;class_id=" . $class_id . "\">" . get_lang("reg") . "</a>";
122
+    $result = "<a href=\"".api_get_self()."?register=yes&amp;class_id=".$class_id."\">".get_lang("reg")."</a>";
123 123
     return $result;
124 124
 }
125 125
 
Please login to merge, or discard this patch.