@@ -38,7 +38,7 @@ |
||
38 | 38 | if (stripos($line, '$_configuration[\'system_version\']') !== false) { |
39 | 39 | $found_version = true; |
40 | 40 | $line = '$_configuration[\'system_version\'] = \'' . $new_version . '\';' . "\r\n"; |
41 | - } elseif (stripos($line, '$_configuration[\'system_stable\']') !== false) { |
|
41 | + } elseif (stripos($line, '$_configuration[\'system_stable\']') !== false) { |
|
42 | 42 | $found_stable = true; |
43 | 43 | $line = '$_configuration[\'system_stable\'] = ' . ($new_version_stable ? 'true' : 'false') . ';' . "\r\n"; |
44 | 44 | } elseif (stripos($line, '$_configuration[\'software_name\']') !== false) { |
@@ -16,7 +16,6 @@ |
||
16 | 16 | * @author Patrick Cool |
17 | 17 | * @author René Haentjens, added CSV file import (October 2004) |
18 | 18 | * @package chamilo.link |
19 | - |
|
20 | 19 | */ |
21 | 20 | |
22 | 21 | // Including libraries |
@@ -18,27 +18,27 @@ discard block |
||
18 | 18 | } |
19 | 19 | $categories[ADD_BLOCK] = get_lang('NewBloc'); |
20 | 20 | |
21 | - $i=1; |
|
22 | - echo '<div class="actions" style="margin-bottom:30px">'; |
|
23 | - ksort($categories); |
|
24 | - foreach ($categories as $id => $title) { |
|
25 | - if ($i==ADD_BLOCK) { |
|
26 | - echo '<a href="index.php?'.api_get_cidreq().'&action=add">'. |
|
21 | + $i=1; |
|
22 | + echo '<div class="actions" style="margin-bottom:30px">'; |
|
23 | + ksort($categories); |
|
24 | + foreach ($categories as $id => $title) { |
|
25 | + if ($i==ADD_BLOCK) { |
|
26 | + echo '<a href="index.php?'.api_get_cidreq().'&action=add">'. |
|
27 | 27 | Display::return_icon($default_description_icon[$id], $title,'',ICON_SIZE_MEDIUM).'</a>'; |
28 | - break; |
|
29 | - } else { |
|
30 | - echo '<a href="index.php?action=edit&'.api_get_cidreq().'&description_type='.$id.'">'. |
|
28 | + break; |
|
29 | + } else { |
|
30 | + echo '<a href="index.php?action=edit&'.api_get_cidreq().'&description_type='.$id.'">'. |
|
31 | 31 | Display::return_icon($default_description_icon[$id], $title,'',ICON_SIZE_MEDIUM).'</a>'; |
32 | - $i++; |
|
33 | - } |
|
34 | - } |
|
35 | - echo '</div>'; |
|
32 | + $i++; |
|
33 | + } |
|
34 | + } |
|
35 | + echo '</div>'; |
|
36 | 36 | } |
37 | 37 | $history = isset($history) ? $history : null; |
38 | 38 | |
39 | 39 | // display course description list |
40 | 40 | if ($history) { |
41 | - echo '<div> |
|
41 | + echo '<div> |
|
42 | 42 | <table width="100%"> |
43 | 43 | <tr> |
44 | 44 | <td><h3>'.get_lang('ThematicAdvanceHistory').'</h3></td> |
@@ -49,7 +49,7 @@ discard block |
||
49 | 49 | $user_info = api_get_user_info(); |
50 | 50 | |
51 | 51 | if (isset($descriptions) && count($descriptions) > 0) { |
52 | - foreach ($descriptions as $id => $description) { |
|
52 | + foreach ($descriptions as $id => $description) { |
|
53 | 53 | if (!empty($description)) { |
54 | 54 | $actions = ''; |
55 | 55 | if (api_is_allowed_to_edit(null,true) && !$history) { |
@@ -10,67 +10,67 @@ discard block |
||
10 | 10 | // protect a course script |
11 | 11 | api_protect_course_script(true); |
12 | 12 | if (empty($id)) { |
13 | - $id = isset($_REQUEST['id']) ? intval($_REQUEST['id']) : ''; |
|
14 | - if (empty($id)) { |
|
15 | - // If the ID was not provided, find the first matching description item given the item type |
|
16 | - $course_description = new CourseDescription(); |
|
17 | - $description = $course_description->get_data_by_description_type($description_type); |
|
18 | - if (count($description) > 0) { |
|
19 | - $id = $description['id']; |
|
20 | - } |
|
21 | - // If no corresponding description is found, edit a new one |
|
22 | - unset($course_description); |
|
23 | - } |
|
13 | + $id = isset($_REQUEST['id']) ? intval($_REQUEST['id']) : ''; |
|
14 | + if (empty($id)) { |
|
15 | + // If the ID was not provided, find the first matching description item given the item type |
|
16 | + $course_description = new CourseDescription(); |
|
17 | + $description = $course_description->get_data_by_description_type($description_type); |
|
18 | + if (count($description) > 0) { |
|
19 | + $id = $description['id']; |
|
20 | + } |
|
21 | + // If no corresponding description is found, edit a new one |
|
22 | + unset($course_description); |
|
23 | + } |
|
24 | 24 | } |
25 | 25 | $original_id = $id; |
26 | 26 | |
27 | 27 | if (empty($error)) { |
28 | - $token = Security::get_token(); |
|
28 | + $token = Security::get_token(); |
|
29 | 29 | } |
30 | 30 | // display categories |
31 | 31 | $categories = array(); |
32 | 32 | foreach ($default_description_titles as $id => $title) { |
33 | - $categories[$id] = $title; |
|
33 | + $categories[$id] = $title; |
|
34 | 34 | } |
35 | 35 | $categories[ADD_BLOCK] = get_lang('NewBloc'); |
36 | 36 | |
37 | 37 | $i=1; |
38 | 38 | echo '<div class="actions" style="margin-bottom:30px">'; |
39 | 39 | echo '<a href="index.php?'.api_get_cidreq().'">'. |
40 | - Display::return_icon('back.png',get_lang('BackTo').' '.get_lang('ToolCourseDescription'),'',ICON_SIZE_MEDIUM). |
|
41 | - '</a>'; |
|
40 | + Display::return_icon('back.png',get_lang('BackTo').' '.get_lang('ToolCourseDescription'),'',ICON_SIZE_MEDIUM). |
|
41 | + '</a>'; |
|
42 | 42 | |
43 | 43 | ksort($categories); |
44 | 44 | foreach ($categories as $id => $title) { |
45 | - if ($i==ADD_BLOCK) { |
|
46 | - echo '<a href="index.php?'.api_get_cidreq().'&action=add">'. |
|
47 | - Display::return_icon($default_description_icon[$id], $title,'',ICON_SIZE_MEDIUM).'</a>'; |
|
48 | - break; |
|
49 | - } else { |
|
50 | - echo '<a href="index.php?action=edit&'.api_get_cidreq().'&description_type='.$id.'">'. |
|
51 | - Display::return_icon($default_description_icon[$id], $title,'',ICON_SIZE_MEDIUM).'</a>'; |
|
52 | - $i++; |
|
53 | - } |
|
45 | + if ($i==ADD_BLOCK) { |
|
46 | + echo '<a href="index.php?'.api_get_cidreq().'&action=add">'. |
|
47 | + Display::return_icon($default_description_icon[$id], $title,'',ICON_SIZE_MEDIUM).'</a>'; |
|
48 | + break; |
|
49 | + } else { |
|
50 | + echo '<a href="index.php?action=edit&'.api_get_cidreq().'&description_type='.$id.'">'. |
|
51 | + Display::return_icon($default_description_icon[$id], $title,'',ICON_SIZE_MEDIUM).'</a>'; |
|
52 | + $i++; |
|
53 | + } |
|
54 | 54 | } |
55 | 55 | echo '</div>'; |
56 | 56 | |
57 | 57 | // error messages |
58 | 58 | if (isset($error) && intval($error) == 1) { |
59 | - Display::display_error_message(get_lang('FormHasErrorsPleaseComplete'),false); |
|
59 | + Display::display_error_message(get_lang('FormHasErrorsPleaseComplete'),false); |
|
60 | 60 | } |
61 | 61 | |
62 | 62 | // default header title form |
63 | 63 | $description_type = intval($description_type); |
64 | 64 | $header = $default_description_titles[$description_type]; |
65 | 65 | if ($description_type >= ADD_BLOCK) { |
66 | - $header = $default_description_titles[ADD_BLOCK]; |
|
66 | + $header = $default_description_titles[ADD_BLOCK]; |
|
67 | 67 | } |
68 | 68 | |
69 | 69 | // display form |
70 | 70 | $form = new FormValidator( |
71 | - 'course_description', |
|
72 | - 'POST', |
|
73 | - 'index.php?action=edit&id='.$original_id.'&description_type='.$description_type.'&'.api_get_cidreq() |
|
71 | + 'course_description', |
|
72 | + 'POST', |
|
73 | + 'index.php?action=edit&id='.$original_id.'&description_type='.$description_type.'&'.api_get_cidreq() |
|
74 | 74 | ); |
75 | 75 | |
76 | 76 | $form->addElement('header','',$header); |
@@ -80,15 +80,15 @@ discard block |
||
80 | 80 | $form->addText('title', get_lang('Title'), true, array('size'=>'50')); |
81 | 81 | $form->applyFilter('title','html_filter'); |
82 | 82 | $form->addHtmlEditor( |
83 | - 'contentDescription', |
|
84 | - get_lang('Content'), |
|
85 | - true, |
|
86 | - false, |
|
87 | - array( |
|
88 | - 'ToolbarSet' => 'TrainingDescription', |
|
89 | - 'Width' => '100%', |
|
90 | - 'Height' => '200', |
|
91 | - ) |
|
83 | + 'contentDescription', |
|
84 | + get_lang('Content'), |
|
85 | + true, |
|
86 | + false, |
|
87 | + array( |
|
88 | + 'ToolbarSet' => 'TrainingDescription', |
|
89 | + 'Width' => '100%', |
|
90 | + 'Height' => '200', |
|
91 | + ) |
|
92 | 92 | ); |
93 | 93 | $form->addButtonCreate(get_lang('Save')); |
94 | 94 | |
@@ -104,8 +104,8 @@ discard block |
||
104 | 104 | $form->setDefaults($default); |
105 | 105 | |
106 | 106 | if (isset ($question[$description_type])) { |
107 | - $message = '<strong>'.get_lang('QuestionPlan').'</strong><br />'; |
|
108 | - $message .= $question[$description_type]; |
|
109 | - Display::display_normal_message($message, false); |
|
107 | + $message = '<strong>'.get_lang('QuestionPlan').'</strong><br />'; |
|
108 | + $message .= $question[$description_type]; |
|
109 | + Display::display_normal_message($message, false); |
|
110 | 110 | } |
111 | 111 | $form->display(); |
@@ -156,7 +156,7 @@ discard block |
||
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 |
||
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 |
@@ -60,9 +60,9 @@ discard block |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
361 | 361 | '.$link_to_add_user_in_url.' |
362 | 362 | </td> |
363 | 363 | </tr>'; |
364 | - } |
|
364 | + } |
|
365 | 365 | } |
366 | 366 | ?> |
367 | 367 | </table> |
@@ -48,29 +48,29 @@ discard block |
||
48 | 48 | $extra_field_list= UserManager::get_extra_fields(); |
49 | 49 | $new_field_list = array(); |
50 | 50 | if (is_array($extra_field_list)) { |
51 | - foreach ($extra_field_list as $extra_field) { |
|
52 | - //if is enabled to filter and is a "<select>" field type |
|
53 | - if ($extra_field[8]==1 && $extra_field[2]==4 ) { |
|
51 | + foreach ($extra_field_list as $extra_field) { |
|
52 | + //if is enabled to filter and is a "<select>" field type |
|
53 | + if ($extra_field[8]==1 && $extra_field[2]==4 ) { |
|
54 | 54 | $new_field_list[] = array( |
55 | 55 | 'name' => $extra_field[3], |
56 | 56 | 'variable' => $extra_field[1], |
57 | 57 | 'data' => $extra_field[9], |
58 | 58 | ); |
59 | - } |
|
60 | - } |
|
59 | + } |
|
60 | + } |
|
61 | 61 | } |
62 | 62 | |
63 | 63 | function search_users($needle, $type) |
64 | 64 | { |
65 | - global $id_session; |
|
65 | + global $id_session; |
|
66 | 66 | |
67 | 67 | $tbl_user = Database::get_main_table(TABLE_MAIN_USER); |
68 | 68 | $tbl_session_rel_user = Database::get_main_table(TABLE_MAIN_SESSION_USER); |
69 | 69 | |
70 | - $xajax_response = new xajaxResponse(); |
|
71 | - $return = ''; |
|
70 | + $xajax_response = new xajaxResponse(); |
|
71 | + $return = ''; |
|
72 | 72 | |
73 | - if (!empty($needle) && !empty($type)) { |
|
73 | + if (!empty($needle) && !empty($type)) { |
|
74 | 74 | |
75 | 75 | //normal behaviour |
76 | 76 | if ($type == 'any_session' && $needle == 'false') { |
@@ -78,32 +78,32 @@ discard block |
||
78 | 78 | $needle = ''; |
79 | 79 | } |
80 | 80 | |
81 | - // xajax send utf8 datas... datas in db can be non-utf8 datas |
|
82 | - $charset = api_get_system_encoding(); |
|
83 | - $needle = Database::escape_string($needle); |
|
84 | - $needle = api_convert_encoding($needle, $charset, 'utf-8'); |
|
81 | + // xajax send utf8 datas... datas in db can be non-utf8 datas |
|
82 | + $charset = api_get_system_encoding(); |
|
83 | + $needle = Database::escape_string($needle); |
|
84 | + $needle = api_convert_encoding($needle, $charset, 'utf-8'); |
|
85 | 85 | |
86 | - $order_clause = api_sort_by_first_name() ? ' ORDER BY firstname, lastname, username' : ' ORDER BY lastname, firstname, username'; |
|
87 | - $cond_user_id = ''; |
|
86 | + $order_clause = api_sort_by_first_name() ? ' ORDER BY firstname, lastname, username' : ' ORDER BY lastname, firstname, username'; |
|
87 | + $cond_user_id = ''; |
|
88 | 88 | |
89 | 89 | //Only for single & multiple |
90 | 90 | if (in_array($type, array('single','multiple'))) { |
91 | - if (!empty($id_session)) { |
|
92 | - $id_session = intval($id_session); |
|
93 | - // check id_user from session_rel_user table |
|
94 | - $sql = 'SELECT user_id FROM '.$tbl_session_rel_user.' |
|
91 | + if (!empty($id_session)) { |
|
92 | + $id_session = intval($id_session); |
|
93 | + // check id_user from session_rel_user table |
|
94 | + $sql = 'SELECT user_id FROM '.$tbl_session_rel_user.' |
|
95 | 95 | WHERE session_id ="'.$id_session.'" AND relation_type<>'.SESSION_RELATION_TYPE_RRHH.' '; |
96 | - $res = Database::query($sql); |
|
97 | - $user_ids = array(); |
|
98 | - if (Database::num_rows($res) > 0) { |
|
99 | - while ($row = Database::fetch_row($res)) { |
|
100 | - $user_ids[] = (int)$row[0]; |
|
101 | - } |
|
102 | - } |
|
103 | - if (count($user_ids) > 0) { |
|
104 | - $cond_user_id = ' AND user.user_id NOT IN('.implode(",",$user_ids).')'; |
|
105 | - } |
|
106 | - } |
|
96 | + $res = Database::query($sql); |
|
97 | + $user_ids = array(); |
|
98 | + if (Database::num_rows($res) > 0) { |
|
99 | + while ($row = Database::fetch_row($res)) { |
|
100 | + $user_ids[] = (int)$row[0]; |
|
101 | + } |
|
102 | + } |
|
103 | + if (count($user_ids) > 0) { |
|
104 | + $cond_user_id = ' AND user.user_id NOT IN('.implode(",",$user_ids).')'; |
|
105 | + } |
|
106 | + } |
|
107 | 107 | } |
108 | 108 | |
109 | 109 | switch ($type) { |
@@ -135,11 +135,11 @@ discard block |
||
135 | 135 | user.status <> 6 '.$cond_user_id. |
136 | 136 | $order_clause; |
137 | 137 | break; |
138 | - } |
|
139 | - if (api_is_multiple_url_enabled()) { |
|
140 | - $tbl_user_rel_access_url= Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER); |
|
141 | - $access_url_id = api_get_current_access_url_id(); |
|
142 | - if ($access_url_id != -1) { |
|
138 | + } |
|
139 | + if (api_is_multiple_url_enabled()) { |
|
140 | + $tbl_user_rel_access_url= Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER); |
|
141 | + $access_url_id = api_get_current_access_url_id(); |
|
142 | + if ($access_url_id != -1) { |
|
143 | 143 | switch ($type) { |
144 | 144 | case 'single': |
145 | 145 | $sql = 'SELECT user.user_id, username, lastname, firstname |
@@ -177,36 +177,36 @@ discard block |
||
177 | 177 | user.status<>6 '.$cond_user_id. |
178 | 178 | $order_clause; |
179 | 179 | break; |
180 | - } |
|
181 | - } |
|
182 | - } |
|
180 | + } |
|
181 | + } |
|
182 | + } |
|
183 | 183 | |
184 | - $rs = Database::query($sql); |
|
184 | + $rs = Database::query($sql); |
|
185 | 185 | $i=0; |
186 | - if ($type == 'single') { |
|
187 | - while ($user = Database :: fetch_array($rs)) { |
|
188 | - $i++; |
|
189 | - if ($i<=10) { |
|
190 | - $person_name = api_get_person_name($user['firstname'], $user['lastname']); |
|
191 | - $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 />'; |
|
192 | - } else { |
|
193 | - $return .= '...<br />'; |
|
194 | - } |
|
195 | - } |
|
196 | - |
|
197 | - $xajax_response -> addAssign('ajax_list_users_single','innerHTML',api_utf8_encode($return)); |
|
198 | - } else { |
|
199 | - global $nosessionUsersList; |
|
200 | - $return .= '<select id="origin_users" name="nosessionUsersList[]" multiple="multiple" size="15" style="width:360px;">'; |
|
201 | - while ($user = Database :: fetch_array($rs)) { |
|
202 | - $person_name = api_get_person_name($user['firstname'], $user['lastname']); |
|
203 | - $return .= '<option value="'.$user['user_id'].'">'.$person_name.' ('.$user['username'].')</option>'; |
|
204 | - } |
|
205 | - $return .= '</select>'; |
|
206 | - $xajax_response -> addAssign('ajax_list_users_multiple','innerHTML',api_utf8_encode($return)); |
|
207 | - } |
|
208 | - } |
|
209 | - return $xajax_response; |
|
186 | + if ($type == 'single') { |
|
187 | + while ($user = Database :: fetch_array($rs)) { |
|
188 | + $i++; |
|
189 | + if ($i<=10) { |
|
190 | + $person_name = api_get_person_name($user['firstname'], $user['lastname']); |
|
191 | + $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 />'; |
|
192 | + } else { |
|
193 | + $return .= '...<br />'; |
|
194 | + } |
|
195 | + } |
|
196 | + |
|
197 | + $xajax_response -> addAssign('ajax_list_users_single','innerHTML',api_utf8_encode($return)); |
|
198 | + } else { |
|
199 | + global $nosessionUsersList; |
|
200 | + $return .= '<select id="origin_users" name="nosessionUsersList[]" multiple="multiple" size="15" style="width:360px;">'; |
|
201 | + while ($user = Database :: fetch_array($rs)) { |
|
202 | + $person_name = api_get_person_name($user['firstname'], $user['lastname']); |
|
203 | + $return .= '<option value="'.$user['user_id'].'">'.$person_name.' ('.$user['username'].')</option>'; |
|
204 | + } |
|
205 | + $return .= '</select>'; |
|
206 | + $xajax_response -> addAssign('ajax_list_users_multiple','innerHTML',api_utf8_encode($return)); |
|
207 | + } |
|
208 | + } |
|
209 | + return $xajax_response; |
|
210 | 210 | } |
211 | 211 | |
212 | 212 | $xajax -> processRequests(); |
@@ -342,8 +342,8 @@ discard block |
||
342 | 342 | |
343 | 343 | if ($use_extra_fields) { |
344 | 344 | $final_result = array(); |
345 | - if (count($extra_field_result)>1) { |
|
346 | - for($i=0;$i<count($extra_field_result)-1;$i++) { |
|
345 | + if (count($extra_field_result)>1) { |
|
346 | + for($i=0;$i<count($extra_field_result)-1;$i++) { |
|
347 | 347 | if (is_array($extra_field_result[$i+1])) { |
348 | 348 | $final_result = array_intersect( |
349 | 349 | $extra_field_result[$i], |
@@ -421,7 +421,7 @@ discard block |
||
421 | 421 | 'un' => $user['username'] |
422 | 422 | ); |
423 | 423 | unset($users[$uid]); |
424 | - } |
|
424 | + } |
|
425 | 425 | } |
426 | 426 | unset($users); //clean to free memory |
427 | 427 | |
@@ -466,13 +466,13 @@ discard block |
||
466 | 466 | } |
467 | 467 | |
468 | 468 | if ($add_type == 'multiple') { |
469 | - $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>'; |
|
470 | - $link_add_type_multiple = Display::return_icon('multiple.gif').get_lang('SessionAddTypeMultiple'); |
|
469 | + $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>'; |
|
470 | + $link_add_type_multiple = Display::return_icon('multiple.gif').get_lang('SessionAddTypeMultiple'); |
|
471 | 471 | } else { |
472 | - $link_add_type_unique = Display::return_icon('single.gif').get_lang('SessionAddTypeUnique'); |
|
473 | - $link_add_type_multiple = '<a href="'.api_get_self().'?id_session='.$id_session.'&add='.Security::remove_XSS($_GET['add']).'&add_type=multiple">'.Display::return_icon('multiple.gif').get_lang('SessionAddTypeMultiple').'</a>'; |
|
472 | + $link_add_type_unique = Display::return_icon('single.gif').get_lang('SessionAddTypeUnique'); |
|
473 | + $link_add_type_multiple = '<a href="'.api_get_self().'?id_session='.$id_session.'&add='.Security::remove_XSS($_GET['add']).'&add_type=multiple">'.Display::return_icon('multiple.gif').get_lang('SessionAddTypeMultiple').'</a>'; |
|
474 | 474 | } |
475 | - $link_add_group = '<a href="usergroups.php">'.Display::return_icon('multiple.gif',get_lang('RegistrationByUsersGroups')).get_lang('RegistrationByUsersGroups').'</a>'; |
|
475 | + $link_add_group = '<a href="usergroups.php">'.Display::return_icon('multiple.gif',get_lang('RegistrationByUsersGroups')).get_lang('RegistrationByUsersGroups').'</a>'; |
|
476 | 476 | ?> |
477 | 477 | <div class="actions"> |
478 | 478 | <?php echo $link_add_type_unique ?> | <?php echo $link_add_type_multiple ?> | <?php echo $link_add_group; ?> |
@@ -481,30 +481,30 @@ discard block |
||
481 | 481 | <?php echo '<legend>'.$tool_name.' ('.$session_info['name'].') </legend>'; ?> |
482 | 482 | <?php |
483 | 483 | if ($add_type == 'multiple') { |
484 | - if (is_array($extra_field_list)) { |
|
485 | - if (is_array($new_field_list) && count($new_field_list)>0 ) { |
|
486 | - echo '<h3>'.get_lang('FilterUsers').'</h3>'; |
|
487 | - foreach ($new_field_list as $new_field) { |
|
488 | - echo $new_field['name']; |
|
489 | - $varname = 'field_'.$new_field['variable']; |
|
490 | - echo ' <select name="'.$varname.'">'; |
|
491 | - echo '<option value="0">--'.get_lang('Select').'--</option>'; |
|
492 | - foreach ($new_field['data'] as $option) { |
|
493 | - $checked=''; |
|
494 | - if (isset($_POST[$varname])) { |
|
495 | - if ($_POST[$varname] == $option[1]) { |
|
496 | - $checked = 'selected="true"'; |
|
497 | - } |
|
498 | - } |
|
499 | - echo '<option value="'.$option[1].'" '.$checked.'>'.$option[1].'</option>'; |
|
500 | - } |
|
501 | - echo '</select>'; |
|
502 | - echo ' '; |
|
503 | - } |
|
504 | - echo '<input type="button" value="'.get_lang('Filter').'" onclick="validate_filter()" />'; |
|
505 | - echo '<br /><br />'; |
|
506 | - } |
|
507 | - } |
|
484 | + if (is_array($extra_field_list)) { |
|
485 | + if (is_array($new_field_list) && count($new_field_list)>0 ) { |
|
486 | + echo '<h3>'.get_lang('FilterUsers').'</h3>'; |
|
487 | + foreach ($new_field_list as $new_field) { |
|
488 | + echo $new_field['name']; |
|
489 | + $varname = 'field_'.$new_field['variable']; |
|
490 | + echo ' <select name="'.$varname.'">'; |
|
491 | + echo '<option value="0">--'.get_lang('Select').'--</option>'; |
|
492 | + foreach ($new_field['data'] as $option) { |
|
493 | + $checked=''; |
|
494 | + if (isset($_POST[$varname])) { |
|
495 | + if ($_POST[$varname] == $option[1]) { |
|
496 | + $checked = 'selected="true"'; |
|
497 | + } |
|
498 | + } |
|
499 | + echo '<option value="'.$option[1].'" '.$checked.'>'.$option[1].'</option>'; |
|
500 | + } |
|
501 | + echo '</select>'; |
|
502 | + echo ' '; |
|
503 | + } |
|
504 | + echo '<input type="button" value="'.get_lang('Filter').'" onclick="validate_filter()" />'; |
|
505 | + echo '<br /><br />'; |
|
506 | + } |
|
507 | + } |
|
508 | 508 | } |
509 | 509 | ?> |
510 | 510 | |
@@ -513,7 +513,7 @@ discard block |
||
513 | 513 | |
514 | 514 | <?php |
515 | 515 | if (!empty($errorMsg)) { |
516 | - Display::display_normal_message($errorMsg); //main API |
|
516 | + Display::display_normal_message($errorMsg); //main API |
|
517 | 517 | } |
518 | 518 | ?> |
519 | 519 | <div class="row"> |
@@ -534,7 +534,7 @@ discard block |
||
534 | 534 | <div id="content_source"> |
535 | 535 | <?php |
536 | 536 | if (!($add_type == 'multiple')) { |
537 | - ?> |
|
537 | + ?> |
|
538 | 538 | <input type="text" id="user_to_add" onkeyup="xajax_search_users(this.value,'single')" /> |
539 | 539 | <div id="ajax_list_users_single"></div> |
540 | 540 | <?php |
@@ -543,12 +543,12 @@ discard block |
||
543 | 543 | <div id="ajax_list_users_multiple"> |
544 | 544 | <select id="origin_users" name="nosessionUsersList[]" multiple="multiple" size="15" class="span5"> |
545 | 545 | <?php |
546 | - foreach ($nosessionUsersList as $uid => $enreg) { |
|
547 | - ?> |
|
546 | + foreach ($nosessionUsersList as $uid => $enreg) { |
|
547 | + ?> |
|
548 | 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> |
549 | 549 | <?php |
550 | - } |
|
551 | - ?> |
|
550 | + } |
|
551 | + ?> |
|
552 | 552 | </select> |
553 | 553 | </div> |
554 | 554 | <input type="checkbox" onchange="checked_in_no_session(this.checked);" name="user_with_any_session" id="user_with_any_session_id"> |
@@ -556,7 +556,7 @@ discard block |
||
556 | 556 | <?php |
557 | 557 | } |
558 | 558 | unset($nosessionUsersList); |
559 | - ?> |
|
559 | + ?> |
|
560 | 560 | </div> |
561 | 561 | </div> |
562 | 562 | |
@@ -583,13 +583,13 @@ discard block |
||
583 | 583 | <br /> |
584 | 584 | <br /> |
585 | 585 | <?php |
586 | - if (isset($_GET['add'])) { |
|
587 | - echo '<button class="btn btn-primary" type="button" value="" onclick="valide()" >'.get_lang('FinishSessionCreation').'</button>'; |
|
586 | + if (isset($_GET['add'])) { |
|
587 | + echo '<button class="btn btn-primary" type="button" value="" onclick="valide()" >'.get_lang('FinishSessionCreation').'</button>'; |
|
588 | 588 | } else { |
589 | 589 | //@todo see that the call to "valide()" doesn't duplicate the onsubmit of the form (necessary to avoid delete on "enter" key pressed) |
590 | - echo '<button class="save" type="button" value="" onclick="valide()" >'.get_lang('SubscribeUsersToSession').'</button>'; |
|
590 | + echo '<button class="save" type="button" value="" onclick="valide()" >'.get_lang('SubscribeUsersToSession').'</button>'; |
|
591 | 591 | } |
592 | - ?> |
|
592 | + ?> |
|
593 | 593 | </div> |
594 | 594 | <div class="span5"> |
595 | 595 | <div class="multiple_select_header"> |
@@ -65,13 +65,13 @@ discard block |
||
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 |
||
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 \' <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> |
@@ -41,10 +41,10 @@ discard block |
||
41 | 41 | </th> |
42 | 42 | </tr> |
43 | 43 | <?php |
44 | - $session_is_coach = array(); |
|
45 | - if (isset($_user['user_id']) && $_user['user_id'] != '') { |
|
46 | - $_user['user_id'] = intval($_user['user_id']); |
|
47 | - $sql = "SELECT DISTINCT session.id, |
|
44 | + $session_is_coach = array(); |
|
45 | + if (isset($_user['user_id']) && $_user['user_id'] != '') { |
|
46 | + $_user['user_id'] = intval($_user['user_id']); |
|
47 | + $sql = "SELECT DISTINCT session.id, |
|
48 | 48 | name, |
49 | 49 | access_start_date, |
50 | 50 | access_end_date |
@@ -53,13 +53,13 @@ discard block |
||
53 | 53 | ON srcru.user_id = ".$_user['user_id']." AND srcru.status=2 |
54 | 54 | AND session.id = srcru.session_id |
55 | 55 | ORDER BY access_start_date, access_end_date, name"; |
56 | - $result = Database::query($sql); |
|
56 | + $result = Database::query($sql); |
|
57 | 57 | |
58 | - while ($session = Database:: fetch_array($result)) { |
|
59 | - $session_is_coach[$session['id']] = $session; |
|
60 | - } |
|
58 | + while ($session = Database:: fetch_array($result)) { |
|
59 | + $session_is_coach[$session['id']] = $session; |
|
60 | + } |
|
61 | 61 | |
62 | - $sql = "SELECT DISTINCT session.id, |
|
62 | + $sql = "SELECT DISTINCT session.id, |
|
63 | 63 | name, |
64 | 64 | access_start_date, |
65 | 65 | access_end_date |
@@ -67,9 +67,9 @@ discard block |
||
67 | 67 | WHERE session.id_coach = ".$_user['user_id']." |
68 | 68 | ORDER BY access_start_date, access_end_date, name"; |
69 | 69 | $result = Database::query($sql); |
70 | - while ($session = Database:: fetch_array($result)) { |
|
71 | - $session_is_coach[$session['id']] = $session; |
|
72 | - } |
|
70 | + while ($session = Database:: fetch_array($result)) { |
|
71 | + $session_is_coach[$session['id']] = $session; |
|
72 | + } |
|
73 | 73 | |
74 | 74 | if (empty($time_limit)) { |
75 | 75 | $time_limit = api_get_setting('time_limit_whosonline'); |
@@ -82,7 +82,7 @@ discard block |
||
82 | 82 | |
83 | 83 | $students_online = array(); |
84 | 84 | foreach ($session_is_coach as $session) { |
85 | - $sql = "SELECT DISTINCT last_access.access_user_id, |
|
85 | + $sql = "SELECT DISTINCT last_access.access_user_id, |
|
86 | 86 | last_access.access_date, |
87 | 87 | last_access.c_id, |
88 | 88 | last_access.access_session_id, |
@@ -95,49 +95,49 @@ discard block |
||
95 | 95 | AND access_date >= '$current_date' |
96 | 96 | GROUP BY access_user_id"; |
97 | 97 | |
98 | - $result = Database::query($sql); |
|
98 | + $result = Database::query($sql); |
|
99 | 99 | |
100 | - while($user_list = Database::fetch_array($result)) { |
|
101 | - $students_online[$user_list['access_user_id']] = $user_list; |
|
102 | - } |
|
103 | - } |
|
100 | + while($user_list = Database::fetch_array($result)) { |
|
101 | + $students_online[$user_list['access_user_id']] = $user_list; |
|
102 | + } |
|
103 | + } |
|
104 | 104 | |
105 | - if (count($students_online) > 0) { |
|
106 | - foreach ($students_online as $student_online) { |
|
107 | - echo "<tr> |
|
105 | + if (count($students_online) > 0) { |
|
106 | + foreach ($students_online as $student_online) { |
|
107 | + echo "<tr> |
|
108 | 108 | <td> |
109 | 109 | "; |
110 | - echo $student_online['name']; |
|
111 | - echo " </td> |
|
110 | + echo $student_online['name']; |
|
111 | + echo " </td> |
|
112 | 112 | <td align='center'> |
113 | 113 | "; |
114 | - $courseInfo = api_get_course_info_by_id($student_online['c_id']); |
|
115 | - echo $courseInfo['title']; |
|
116 | - echo " </td> |
|
114 | + $courseInfo = api_get_course_info_by_id($student_online['c_id']); |
|
115 | + echo $courseInfo['title']; |
|
116 | + echo " </td> |
|
117 | 117 | <td align='center'> |
118 | 118 | "; |
119 | - if (!empty($student_online['email'])) { |
|
120 | - echo $student_online['email']; |
|
121 | - } else { |
|
122 | - echo get_lang('NoEmail'); |
|
123 | - } |
|
124 | - echo " </td> |
|
119 | + if (!empty($student_online['email'])) { |
|
120 | + echo $student_online['email']; |
|
121 | + } else { |
|
122 | + echo get_lang('NoEmail'); |
|
123 | + } |
|
124 | + echo " </td> |
|
125 | 125 | <td align='center'> |
126 | 126 | "; |
127 | - echo '<a href="main/chat/chat.php?cidReq='.$courseInfo['code'].'&id_session='.$student_online['access_session_id'].'"> -> </a>'; |
|
128 | - echo " </td> |
|
127 | + echo '<a href="main/chat/chat.php?cidReq='.$courseInfo['code'].'&id_session='.$student_online['access_session_id'].'"> -> </a>'; |
|
128 | + echo " </td> |
|
129 | 129 | </tr> |
130 | 130 | "; |
131 | - } |
|
132 | - } else { |
|
133 | - echo ' <tr> |
|
131 | + } |
|
132 | + } else { |
|
133 | + echo ' <tr> |
|
134 | 134 | <td colspan="4"> |
135 | 135 | '.get_lang('NoOnlineStudents').' |
136 | 136 | </td> |
137 | 137 | </tr> |
138 | 138 | '; |
139 | - } |
|
140 | - } |
|
139 | + } |
|
140 | + } |
|
141 | 141 | ?> |
142 | 142 | </table> |
143 | 143 | <?php |