@@ -37,7 +37,7 @@ |
||
37 | 37 | $url = api_get_path(WEB_AJAX_PATH)."skill.ajax.php?a=get_skills_tree_json&load_user=$load_user"; |
38 | 38 | $tpl->assign('wheel_url', $url); |
39 | 39 | |
40 | -$url = api_get_path(WEB_AJAX_PATH).'skill.ajax.php?1=1'; |
|
40 | +$url = api_get_path(WEB_AJAX_PATH).'skill.ajax.php?1=1'; |
|
41 | 41 | $tpl->assign('url', $url); |
42 | 42 | $tpl->assign('isAdministration', true); |
43 | 43 |
@@ -112,7 +112,7 @@ |
||
112 | 112 | <script> |
113 | 113 | $(function() { |
114 | 114 | <?php |
115 | - echo Display::grid_js('promotions', $url, $columns, $column_model, $extra_params, array(), $action_links, true); |
|
115 | + echo Display::grid_js('promotions', $url, $columns, $column_model, $extra_params, array(), $action_links, true); |
|
116 | 116 | ?> |
117 | 117 | }); |
118 | 118 | </script> |
@@ -16,8 +16,8 @@ discard block |
||
16 | 16 | $htmlHeadXtra[] = api_get_jqgrid_js(); |
17 | 17 | |
18 | 18 | // setting breadcrumbs |
19 | -$interbreadcrumb[] = array('url' => 'index.php','name' => get_lang('PlatformAdmin')); |
|
20 | -$interbreadcrumb[] = array('url' => 'career_dashboard.php','name' => get_lang('CareersAndPromotions')); |
|
19 | +$interbreadcrumb[] = array('url' => 'index.php', 'name' => get_lang('PlatformAdmin')); |
|
20 | +$interbreadcrumb[] = array('url' => 'career_dashboard.php', 'name' => get_lang('CareersAndPromotions')); |
|
21 | 21 | |
22 | 22 | $action = isset($_GET['action']) ? $_GET['action'] : null; |
23 | 23 | |
@@ -102,10 +102,10 @@ discard block |
||
102 | 102 | $extra_params['height'] = 'auto'; //use the width of the parent |
103 | 103 | //With this function we can add actions to the jgrid |
104 | 104 | $action_links = 'function action_formatter (cellvalue, options, rowObject) { |
105 | - return \'<a href="add_sessions_to_promotion.php?id=\'+options.rowId+\'">'.Display::return_icon('session_to_promotion.png',get_lang('SubscribeSessionsToPromotions'),'',ICON_SIZE_SMALL).'</a>'. |
|
106 | - ' <a href="?action=edit&id=\'+options.rowId+\'">'.Display::return_icon('edit.png',get_lang('Edit'),'',ICON_SIZE_SMALL).'</a>'. |
|
107 | - ' <a onclick="javascript:if(!confirm('."\'".addslashes(api_htmlentities(get_lang("ConfirmYourChoice"),ENT_QUOTES))."\'".')) return false;" href="?sec_token='.$token.'&action=copy&id=\'+options.rowId+\'">'.Display::return_icon('copy.png',get_lang('Copy'),'',ICON_SIZE_SMALL).'</a>'. |
|
108 | - ' <a onclick="javascript:if(!confirm('."\'".addslashes(api_htmlentities(get_lang("ConfirmYourChoice"),ENT_QUOTES))."\'".')) return false;" href="?sec_token='.$token.'&action=delete&id=\'+options.rowId+\'">'.Display::return_icon('delete.png',get_lang('Delete'),'',ICON_SIZE_SMALL).'</a> \'; |
|
105 | + return \'<a href="add_sessions_to_promotion.php?id=\'+options.rowId+\'">'.Display::return_icon('session_to_promotion.png', get_lang('SubscribeSessionsToPromotions'), '', ICON_SIZE_SMALL).'</a>'. |
|
106 | + ' <a href="?action=edit&id=\'+options.rowId+\'">'.Display::return_icon('edit.png', get_lang('Edit'), '', ICON_SIZE_SMALL).'</a>'. |
|
107 | + ' <a onclick="javascript:if(!confirm('."\'".addslashes(api_htmlentities(get_lang("ConfirmYourChoice"), ENT_QUOTES))."\'".')) return false;" href="?sec_token='.$token.'&action=copy&id=\'+options.rowId+\'">'.Display::return_icon('copy.png', get_lang('Copy'), '', ICON_SIZE_SMALL).'</a>'. |
|
108 | + ' <a onclick="javascript:if(!confirm('."\'".addslashes(api_htmlentities(get_lang("ConfirmYourChoice"), ENT_QUOTES))."\'".')) return false;" href="?sec_token='.$token.'&action=delete&id=\'+options.rowId+\'">'.Display::return_icon('delete.png', get_lang('Delete'), '', ICON_SIZE_SMALL).'</a> \'; |
|
109 | 109 | }'; |
110 | 110 | |
111 | 111 | ?> |
@@ -150,7 +150,7 @@ discard block |
||
150 | 150 | $promotion->display(); |
151 | 151 | } else { |
152 | 152 | echo '<div class="actions">'; |
153 | - echo Display::url(Display::return_icon('back.png',get_lang('Back'),'',ICON_SIZE_MEDIUM), api_get_self()); |
|
153 | + echo Display::url(Display::return_icon('back.png', get_lang('Back'), '', ICON_SIZE_MEDIUM), api_get_self()); |
|
154 | 154 | echo '</div>'; |
155 | 155 | $form->addElement('hidden', 'sec_token'); |
156 | 156 | $form->setConstants(array('sec_token' => $token)); |
@@ -107,7 +107,7 @@ |
||
107 | 107 | <?php |
108 | 108 | echo Display :: get_alphabet_options($first_letter_course); |
109 | 109 | echo Display :: get_numeric_options(0,9,$first_letter_course); |
110 | - ?> |
|
110 | + ?> |
|
111 | 111 | </select> |
112 | 112 | </td> |
113 | 113 | <td width="20%"> </td> |
@@ -10,7 +10,7 @@ discard block |
||
10 | 10 | $cidReset = true; |
11 | 11 | require_once '../inc/global.inc.php'; |
12 | 12 | |
13 | -$this_section=SECTION_PLATFORM_ADMIN; |
|
13 | +$this_section = SECTION_PLATFORM_ADMIN; |
|
14 | 14 | |
15 | 15 | api_protect_global_admin_script(); |
16 | 16 | |
@@ -21,7 +21,7 @@ discard block |
||
21 | 21 | |
22 | 22 | $form_sent = 0; |
23 | 23 | $first_letter_course = ''; |
24 | -$courses = array (); |
|
24 | +$courses = array(); |
|
25 | 25 | $url_list = array(); |
26 | 26 | $users = array(); |
27 | 27 | |
@@ -32,8 +32,8 @@ discard block |
||
32 | 32 | |
33 | 33 | /* Header */ |
34 | 34 | $tool_name = get_lang('AddCoursesToURL'); |
35 | -$interbreadcrumb[] = array ('url' => 'index.php', 'name' => get_lang('PlatformAdmin')); |
|
36 | -$interbreadcrumb[] = array ('url' => 'access_urls.php', 'name' => get_lang('MultipleAccessURLs')); |
|
35 | +$interbreadcrumb[] = array('url' => 'index.php', 'name' => get_lang('PlatformAdmin')); |
|
36 | +$interbreadcrumb[] = array('url' => 'access_urls.php', 'name' => get_lang('MultipleAccessURLs')); |
|
37 | 37 | |
38 | 38 | Display :: display_header($tool_name); |
39 | 39 | |
@@ -48,8 +48,8 @@ discard block |
||
48 | 48 | |
49 | 49 | if (isset($_POST['form_sent']) && $_POST['form_sent']) { |
50 | 50 | $form_sent = $_POST['form_sent']; |
51 | - $courses = is_array($_POST['course_list']) ? $_POST['course_list'] : array() ; |
|
52 | - $url_list = is_array($_POST['url_list']) ? $_POST['url_list'] : array() ; |
|
51 | + $courses = is_array($_POST['course_list']) ? $_POST['course_list'] : array(); |
|
52 | + $url_list = is_array($_POST['url_list']) ? $_POST['url_list'] : array(); |
|
53 | 53 | $first_letter_course = $_POST['first_letter_course']; |
54 | 54 | |
55 | 55 | foreach ($users as $key => $value) { |
@@ -70,7 +70,7 @@ discard block |
||
70 | 70 | $sql = "SELECT count(*) as num_courses FROM $tbl_course"; |
71 | 71 | $result = Database::query($sql); |
72 | 72 | $num_row = Database::fetch_array($result); |
73 | - if ($num_row['num_courses']>1000) { |
|
73 | + if ($num_row['num_courses'] > 1000) { |
|
74 | 74 | //if there are too much num_courses to gracefully handle with the HTML select list, |
75 | 75 | // assign a default filter on users names |
76 | 76 | $first_letter_user = 'A'; |
@@ -106,7 +106,7 @@ discard block |
||
106 | 106 | <option value="">--</option> |
107 | 107 | <?php |
108 | 108 | echo Display :: get_alphabet_options($first_letter_course); |
109 | - echo Display :: get_numeric_options(0,9,$first_letter_course); |
|
109 | + echo Display :: get_numeric_options(0, 9, $first_letter_course); |
|
110 | 110 | ?> |
111 | 111 | </select> |
112 | 112 | </td> |
@@ -119,7 +119,7 @@ discard block |
||
119 | 119 | <td width="40%" align="center"> |
120 | 120 | <select name="course_list[]" multiple="multiple" size="20" style="width:400px;"> |
121 | 121 | <?php foreach ($db_courses as $course) { ?> |
122 | - <option value="<?php echo $course['code']; ?>" <?php if(in_array($course['code'],$courses)) echo 'selected="selected"'; ?>><?php echo $course['title'].' ('.$course['code'].')'; ?> |
|
122 | + <option value="<?php echo $course['code']; ?>" <?php if (in_array($course['code'], $courses)) echo 'selected="selected"'; ?>><?php echo $course['title'].' ('.$course['code'].')'; ?> |
|
123 | 123 | </option> |
124 | 124 | <?php } ?> |
125 | 125 | </select> |
@@ -130,7 +130,7 @@ discard block |
||
130 | 130 | <td width="40%" align="center"> |
131 | 131 | <select name="url_list[]" multiple="multiple" size="20" style="width:300px;"> |
132 | 132 | <?php foreach ($db_urls as $url_obj) { ?> |
133 | - <option value="<?php echo $url_obj['id']; ?>" <?php if(in_array($url_obj['id'],$url_list)) echo 'selected="selected"'; ?>><?php echo $url_obj['url']; ?> |
|
133 | + <option value="<?php echo $url_obj['id']; ?>" <?php if (in_array($url_obj['id'], $url_list)) echo 'selected="selected"'; ?>><?php echo $url_obj['url']; ?> |
|
134 | 134 | </option> |
135 | 135 | <?php } ?> |
136 | 136 | </select> |
@@ -119,7 +119,10 @@ discard block |
||
119 | 119 | <td width="40%" align="center"> |
120 | 120 | <select name="course_list[]" multiple="multiple" size="20" style="width:400px;"> |
121 | 121 | <?php foreach ($db_courses as $course) { ?> |
122 | - <option value="<?php echo $course['code']; ?>" <?php if(in_array($course['code'],$courses)) echo 'selected="selected"'; ?>><?php echo $course['title'].' ('.$course['code'].')'; ?> |
|
122 | + <option value="<?php echo $course['code']; ?>" <?php if(in_array($course['code'],$courses)) { |
|
123 | + echo 'selected="selected"'; |
|
124 | +} |
|
125 | +?>><?php echo $course['title'].' ('.$course['code'].')'; ?> |
|
123 | 126 | </option> |
124 | 127 | <?php } ?> |
125 | 128 | </select> |
@@ -130,7 +133,10 @@ discard block |
||
130 | 133 | <td width="40%" align="center"> |
131 | 134 | <select name="url_list[]" multiple="multiple" size="20" style="width:300px;"> |
132 | 135 | <?php foreach ($db_urls as $url_obj) { ?> |
133 | - <option value="<?php echo $url_obj['id']; ?>" <?php if(in_array($url_obj['id'],$url_list)) echo 'selected="selected"'; ?>><?php echo $url_obj['url']; ?> |
|
136 | + <option value="<?php echo $url_obj['id']; ?>" <?php if(in_array($url_obj['id'],$url_list)) { |
|
137 | + echo 'selected="selected"'; |
|
138 | +} |
|
139 | +?>><?php echo $url_obj['url']; ?> |
|
134 | 140 | </option> |
135 | 141 | <?php } ?> |
136 | 142 | </select> |
@@ -9,7 +9,7 @@ discard block |
||
9 | 9 | * Code |
10 | 10 | */ |
11 | 11 | // resetting the course id |
12 | -$cidReset=true; |
|
12 | +$cidReset = true; |
|
13 | 13 | require_once('../inc/global.inc.php'); |
14 | 14 | // setting the section (for the tabs) |
15 | 15 | $this_section = SECTION_PLATFORM_ADMIN; |
@@ -17,11 +17,11 @@ discard block |
||
17 | 17 | api_protect_admin_script(); |
18 | 18 | require('../auth/ldap/authldap.php'); |
19 | 19 | |
20 | -$annee_base=date('Y'); |
|
20 | +$annee_base = date('Y'); |
|
21 | 21 | |
22 | 22 | $tool_name = get_lang('LDAPImport'); |
23 | 23 | // setting breadcrumbs |
24 | -$interbreadcrumb[]=array('url' => 'index.php','name' => get_lang('PlatformAdmin')); |
|
24 | +$interbreadcrumb[] = array('url' => 'index.php', 'name' => get_lang('PlatformAdmin')); |
|
25 | 25 | |
26 | 26 | $htmlHeadXtra[] = '<script language="JavaScript" type="text/javascript"> |
27 | 27 | var buttoncheck = 1; |
@@ -64,7 +64,7 @@ discard block |
||
64 | 64 | echo '</div>'; |
65 | 65 | |
66 | 66 | } |
67 | -elseif(!empty($annee) && empty($id_session)) |
|
67 | +elseif (!empty($annee) && empty($id_session)) |
|
68 | 68 | { |
69 | 69 | Display::display_header($tool_name); |
70 | 70 | echo '<div style="align:center">'; |
@@ -73,14 +73,14 @@ discard block |
||
73 | 73 | echo '<select name="id_session">'; |
74 | 74 | |
75 | 75 | $tbl_session = Database::get_main_table(TABLE_MAIN_SESSION); |
76 | - $sql = "SELECT id,name,nbr_courses,access_start_date,access_end_date " . |
|
76 | + $sql = "SELECT id,name,nbr_courses,access_start_date,access_end_date ". |
|
77 | 77 | " FROM $tbl_session ". |
78 | 78 | " ORDER BY name"; |
79 | 79 | $result = Database::query($sql); |
80 | 80 | |
81 | - $sessions=Database::store_result($result); |
|
82 | - $nbr_results=count($sessions); |
|
83 | - foreach($sessions as $row) { |
|
81 | + $sessions = Database::store_result($result); |
|
82 | + $nbr_results = count($sessions); |
|
83 | + foreach ($sessions as $row) { |
|
84 | 84 | echo '<option value="'.$row['id'].'">'.api_htmlentities($row['name']).' ('.$row['access_start_date'].' - '.$row['access_end_date'].')</option>'; |
85 | 85 | } |
86 | 86 | echo '</select>'; |
@@ -112,7 +112,7 @@ discard block |
||
112 | 112 | |
113 | 113 | $info = ldap_get_entries($ds, $sr); |
114 | 114 | |
115 | - for ($key = 0; $key < $info["count"]; $key ++) { |
|
115 | + for ($key = 0; $key < $info["count"]; $key++) { |
|
116 | 116 | $nom_form[] = $info[$key]["sn"][0]; |
117 | 117 | $prenom_form[] = $info[$key]["givenname"][0]; |
118 | 118 | $email_form[] = $info[$key]["mail"][0]; |
@@ -132,7 +132,7 @@ discard block |
||
132 | 132 | asort($nom_form); |
133 | 133 | reset($nom_form); |
134 | 134 | |
135 | - $statut=5; |
|
135 | + $statut = 5; |
|
136 | 136 | include ('ldap_form_add_users_group.php'); |
137 | 137 | } else { |
138 | 138 | echo '<h4>'.get_lang('UnableToConnectTo').' '.$host.'</h4>'; |
@@ -143,24 +143,24 @@ discard block |
||
143 | 143 | echo '</div>'; |
144 | 144 | |
145 | 145 | } |
146 | -elseif (!empty($annee) && !empty($id_session) && ($_POST['confirmed']=='yes')) |
|
146 | +elseif (!empty($annee) && !empty($id_session) && ($_POST['confirmed'] == 'yes')) |
|
147 | 147 | { |
148 | - $id=$_POST['username_form']; |
|
149 | - $UserList=array(); |
|
148 | + $id = $_POST['username_form']; |
|
149 | + $UserList = array(); |
|
150 | 150 | $userid_match_login = array(); |
151 | 151 | foreach ($id as $form_index=>$user_id) |
152 | 152 | { |
153 | - if(is_array($_POST['checkboxes']) && in_array($form_index,array_values($_POST['checkboxes']))) |
|
153 | + if (is_array($_POST['checkboxes']) && in_array($form_index, array_values($_POST['checkboxes']))) |
|
154 | 154 | { |
155 | 155 | $tmp = ldap_add_user($user_id); |
156 | - $UserList[]= $tmp; |
|
156 | + $UserList[] = $tmp; |
|
157 | 157 | $userid_match_login[$tmp] = $user_id; |
158 | 158 | } |
159 | 159 | } |
160 | 160 | if (!empty($_POST['id_session'])) { |
161 | 161 | $num = 0; |
162 | 162 | $tbl_session_user = Database::get_main_table(TABLE_MAIN_SESSION_USER); |
163 | - $tbl_session = Database::get_main_table(TABLE_MAIN_SESSION); |
|
163 | + $tbl_session = Database::get_main_table(TABLE_MAIN_SESSION); |
|
164 | 164 | foreach ($UserList as $user_id) { |
165 | 165 | $res_user = Database::insert( |
166 | 166 | $tbl_session_user, |
@@ -175,7 +175,7 @@ discard block |
||
175 | 175 | } |
176 | 176 | } |
177 | 177 | |
178 | - if($num>0) { |
|
178 | + if ($num > 0) { |
|
179 | 179 | $sql = 'UPDATE '.$tbl_session.' SET nbr_users = (nbr_users + '.$num.') WHERE id = '.intval($id_session); |
180 | 180 | $res = Database::query($sql); |
181 | 181 | } |
@@ -203,8 +203,8 @@ discard block |
||
203 | 203 | else |
204 | 204 | { |
205 | 205 | Display::display_header($tool_name); |
206 | - $message=get_lang('NoUserAdded'); |
|
207 | - Display :: display_normal_message($message,false); |
|
206 | + $message = get_lang('NoUserAdded'); |
|
207 | + Display :: display_normal_message($message, false); |
|
208 | 208 | } |
209 | 209 | echo '<br /><br />'; |
210 | 210 | echo '<a href="ldap_import_students.php?annee=&composante=&etape=">'.get_lang('BackToNewSearch').'</a>'; |
@@ -63,8 +63,7 @@ discard block |
||
63 | 63 | echo '</form>'; |
64 | 64 | echo '</div>'; |
65 | 65 | |
66 | -} |
|
67 | -elseif(!empty($annee) && empty($id_session)) |
|
66 | +} elseif(!empty($annee) && empty($id_session)) |
|
68 | 67 | { |
69 | 68 | Display::display_header($tool_name); |
70 | 69 | echo '<div style="align:center">'; |
@@ -142,8 +141,7 @@ discard block |
||
142 | 141 | echo '<br /><br />'; |
143 | 142 | echo '</div>'; |
144 | 143 | |
145 | -} |
|
146 | -elseif (!empty($annee) && !empty($id_session) && ($_POST['confirmed']=='yes')) |
|
144 | +} elseif (!empty($annee) && !empty($id_session) && ($_POST['confirmed']=='yes')) |
|
147 | 145 | { |
148 | 146 | $id=$_POST['username_form']; |
149 | 147 | $UserList=array(); |
@@ -53,93 +53,93 @@ discard block |
||
53 | 53 | //if ($annee == "" && $composante == "" && $etape == "") { |
54 | 54 | if (empty($annee) && empty($id_session)) |
55 | 55 | { |
56 | - Display::display_header($tool_name); |
|
57 | - echo '<div style="align:center">'; |
|
58 | - echo Display::return_icon('group.gif', get_lang('LDAPSelectFilterOnUsersOU')).' '.get_lang('LDAPSelectFilterOnUsersOU'); |
|
59 | - echo '<form method="get" action="'.api_get_self().'"><br />'; |
|
60 | - echo '<em>'.get_lang('LDAPOUAttributeFilter').' :</em> '; |
|
61 | - echo '<input type="text" name="annee" size="4" maxlength="30" value="'.$annee_base.'"> '; |
|
62 | - echo '<input type="submit" value="'.get_lang('Submit').'">'; |
|
63 | - echo '</form>'; |
|
64 | - echo '</div>'; |
|
56 | + Display::display_header($tool_name); |
|
57 | + echo '<div style="align:center">'; |
|
58 | + echo Display::return_icon('group.gif', get_lang('LDAPSelectFilterOnUsersOU')).' '.get_lang('LDAPSelectFilterOnUsersOU'); |
|
59 | + echo '<form method="get" action="'.api_get_self().'"><br />'; |
|
60 | + echo '<em>'.get_lang('LDAPOUAttributeFilter').' :</em> '; |
|
61 | + echo '<input type="text" name="annee" size="4" maxlength="30" value="'.$annee_base.'"> '; |
|
62 | + echo '<input type="submit" value="'.get_lang('Submit').'">'; |
|
63 | + echo '</form>'; |
|
64 | + echo '</div>'; |
|
65 | 65 | |
66 | 66 | } |
67 | 67 | elseif(!empty($annee) && empty($id_session)) |
68 | 68 | { |
69 | - Display::display_header($tool_name); |
|
70 | - echo '<div style="align:center">'; |
|
71 | - echo Display::return_icon( |
|
72 | - 'course.png', |
|
73 | - get_lang('SelectSessionToImportUsersTo')).' '.get_lang('SelectSessionToImportUsersTo').'<br />'; |
|
74 | - echo '<form method="post" action="'.api_get_self().'?annee='.Security::remove_XSS($annee).'"><br />'; |
|
75 | - echo '<select name="id_session">'; |
|
76 | - |
|
77 | - $tbl_session = Database::get_main_table(TABLE_MAIN_SESSION); |
|
78 | - $sql = "SELECT id,name,nbr_courses,access_start_date,access_end_date " . |
|
79 | - " FROM $tbl_session ". |
|
80 | - " ORDER BY name"; |
|
81 | - $result = Database::query($sql); |
|
82 | - |
|
83 | - $sessions=Database::store_result($result); |
|
84 | - $nbr_results=count($sessions); |
|
85 | - foreach($sessions as $row) { |
|
86 | - echo '<option value="'.$row['id'].'">'.api_htmlentities($row['name']).' ('.$row['access_start_date'].' - '.$row['access_end_date'].')</option>'; |
|
87 | - } |
|
88 | - echo '</select>'; |
|
89 | - echo '<input type="submit" value="'.get_lang('Submit').'">'; |
|
90 | - echo '</form>'; |
|
91 | - echo '</div>'; |
|
69 | + Display::display_header($tool_name); |
|
70 | + echo '<div style="align:center">'; |
|
71 | + echo Display::return_icon( |
|
72 | + 'course.png', |
|
73 | + get_lang('SelectSessionToImportUsersTo')).' '.get_lang('SelectSessionToImportUsersTo').'<br />'; |
|
74 | + echo '<form method="post" action="'.api_get_self().'?annee='.Security::remove_XSS($annee).'"><br />'; |
|
75 | + echo '<select name="id_session">'; |
|
76 | + |
|
77 | + $tbl_session = Database::get_main_table(TABLE_MAIN_SESSION); |
|
78 | + $sql = "SELECT id,name,nbr_courses,access_start_date,access_end_date " . |
|
79 | + " FROM $tbl_session ". |
|
80 | + " ORDER BY name"; |
|
81 | + $result = Database::query($sql); |
|
82 | + |
|
83 | + $sessions=Database::store_result($result); |
|
84 | + $nbr_results=count($sessions); |
|
85 | + foreach($sessions as $row) { |
|
86 | + echo '<option value="'.$row['id'].'">'.api_htmlentities($row['name']).' ('.$row['access_start_date'].' - '.$row['access_end_date'].')</option>'; |
|
87 | + } |
|
88 | + echo '</select>'; |
|
89 | + echo '<input type="submit" value="'.get_lang('Submit').'">'; |
|
90 | + echo '</form>'; |
|
91 | + echo '</div>'; |
|
92 | 92 | } |
93 | 93 | // form4 annee != 0; composante != 0 etape != 0 |
94 | 94 | //elseif ($annee <> "" && $composante <> "" && $etape <> "" && $listeok != 'yes') { |
95 | 95 | elseif (!empty($annee) && !empty($id_session) && empty($_POST['confirmed'])) |
96 | 96 | { |
97 | - Display::display_header($tool_name); |
|
98 | - echo '<div style="align: center;">'; |
|
99 | - echo '<br />'; |
|
100 | - echo '<br />'; |
|
101 | - echo '<h3>'.Display::return_icon('group.gif', get_lang('SelectStudents')).' '.get_lang('SelectStudents').'</h3>'; |
|
102 | - //echo "Connection ..."; |
|
103 | - $ds = ldap_connect($ldap_host, $ldap_port) or die(get_lang('LDAPConnectionError')); |
|
104 | - ldap_set_version($ds); |
|
105 | - |
|
106 | - if ($ds) { |
|
107 | - |
|
108 | - $r = false; |
|
109 | - $res = ldap_handle_bind($ds, $r); |
|
110 | - |
|
111 | - //$sr = @ ldap_search($ds, "ou=people,$LDAPbasedn", "(|(edupersonprimaryorgunitdn=ou=$etape,ou=$annee,ou=diploma,o=Paris1,$LDAPbasedn)(edupersonprimaryorgunitdn=ou=02PEL,ou=$annee,ou=diploma,o=Paris1,$LDAPbasedn))"); |
|
112 | - //echo "(ou=*$annee,ou=$composante)"; |
|
113 | - $sr = @ ldap_search($ds, $ldap_basedn, "(ou=*$annee)"); |
|
114 | - |
|
115 | - $info = ldap_get_entries($ds, $sr); |
|
116 | - |
|
117 | - for ($key = 0; $key < $info["count"]; $key ++) { |
|
118 | - $nom_form[] = $info[$key]["sn"][0]; |
|
119 | - $prenom_form[] = $info[$key]["givenname"][0]; |
|
120 | - $email_form[] = $info[$key]["mail"][0]; |
|
121 | - // Get uid from dn |
|
122 | - //$dn_array=ldap_explode_dn($info[$key]["dn"],1); |
|
123 | - //$username_form[] = $dn_array[0]; // uid is first key |
|
124 | - $username_form[] = $info[$key]['uid'][0]; |
|
125 | - $outab[] = $info[$key]["eduPersonPrimaryAffiliation"][0]; // Ici "student" |
|
126 | - //$val = ldap_get_values_len($ds, $entry, "userPassword"); |
|
127 | - //$password_form[] = $val[0]; |
|
128 | - $password_form[] = $info[$key]['userPassword'][0]; |
|
129 | - } |
|
130 | - ldap_unbind($ds); |
|
131 | - |
|
132 | - /*-----------------------------------------------*/ |
|
133 | - |
|
134 | - asort($nom_form); |
|
135 | - reset($nom_form); |
|
136 | - |
|
137 | - $statut=5; |
|
138 | - include ('ldap_form_add_users_group.php'); |
|
139 | - } else { |
|
140 | - echo '<h4>'.get_lang('UnableToConnectTo').' '.$host.'</h4>'; |
|
141 | - } |
|
142 | - echo '<br /><br />'; |
|
97 | + Display::display_header($tool_name); |
|
98 | + echo '<div style="align: center;">'; |
|
99 | + echo '<br />'; |
|
100 | + echo '<br />'; |
|
101 | + echo '<h3>'.Display::return_icon('group.gif', get_lang('SelectStudents')).' '.get_lang('SelectStudents').'</h3>'; |
|
102 | + //echo "Connection ..."; |
|
103 | + $ds = ldap_connect($ldap_host, $ldap_port) or die(get_lang('LDAPConnectionError')); |
|
104 | + ldap_set_version($ds); |
|
105 | + |
|
106 | + if ($ds) { |
|
107 | + |
|
108 | + $r = false; |
|
109 | + $res = ldap_handle_bind($ds, $r); |
|
110 | + |
|
111 | + //$sr = @ ldap_search($ds, "ou=people,$LDAPbasedn", "(|(edupersonprimaryorgunitdn=ou=$etape,ou=$annee,ou=diploma,o=Paris1,$LDAPbasedn)(edupersonprimaryorgunitdn=ou=02PEL,ou=$annee,ou=diploma,o=Paris1,$LDAPbasedn))"); |
|
112 | + //echo "(ou=*$annee,ou=$composante)"; |
|
113 | + $sr = @ ldap_search($ds, $ldap_basedn, "(ou=*$annee)"); |
|
114 | + |
|
115 | + $info = ldap_get_entries($ds, $sr); |
|
116 | + |
|
117 | + for ($key = 0; $key < $info["count"]; $key ++) { |
|
118 | + $nom_form[] = $info[$key]["sn"][0]; |
|
119 | + $prenom_form[] = $info[$key]["givenname"][0]; |
|
120 | + $email_form[] = $info[$key]["mail"][0]; |
|
121 | + // Get uid from dn |
|
122 | + //$dn_array=ldap_explode_dn($info[$key]["dn"],1); |
|
123 | + //$username_form[] = $dn_array[0]; // uid is first key |
|
124 | + $username_form[] = $info[$key]['uid'][0]; |
|
125 | + $outab[] = $info[$key]["eduPersonPrimaryAffiliation"][0]; // Ici "student" |
|
126 | + //$val = ldap_get_values_len($ds, $entry, "userPassword"); |
|
127 | + //$password_form[] = $val[0]; |
|
128 | + $password_form[] = $info[$key]['userPassword'][0]; |
|
129 | + } |
|
130 | + ldap_unbind($ds); |
|
131 | + |
|
132 | + /*-----------------------------------------------*/ |
|
133 | + |
|
134 | + asort($nom_form); |
|
135 | + reset($nom_form); |
|
136 | + |
|
137 | + $statut=5; |
|
138 | + include ('ldap_form_add_users_group.php'); |
|
139 | + } else { |
|
140 | + echo '<h4>'.get_lang('UnableToConnectTo').' '.$host.'</h4>'; |
|
141 | + } |
|
142 | + echo '<br /><br />'; |
|
143 | 143 | echo '<a href="ldap_import_students.php?annee=">'.get_lang('BackToNewSearch').'</a>'; |
144 | 144 | echo '<br /><br />'; |
145 | 145 | echo '</div>'; |
@@ -147,23 +147,23 @@ discard block |
||
147 | 147 | } |
148 | 148 | elseif (!empty($annee) && !empty($id_session) && ($_POST['confirmed']=='yes')) |
149 | 149 | { |
150 | - $id=$_POST['username_form']; |
|
151 | - $UserList=array(); |
|
152 | - $userid_match_login = array(); |
|
153 | - foreach ($id as $form_index=>$user_id) |
|
154 | - { |
|
155 | - if(is_array($_POST['checkboxes']) && in_array($form_index,array_values($_POST['checkboxes']))) |
|
156 | - { |
|
157 | - $tmp = ldap_add_user($user_id); |
|
158 | - $UserList[]= $tmp; |
|
159 | - $userid_match_login[$tmp] = $user_id; |
|
160 | - } |
|
161 | - } |
|
162 | - if (!empty($_POST['id_session'])) { |
|
163 | - $num = 0; |
|
164 | - $tbl_session_user = Database::get_main_table(TABLE_MAIN_SESSION_USER); |
|
165 | - $tbl_session = Database::get_main_table(TABLE_MAIN_SESSION); |
|
166 | - foreach ($UserList as $user_id) { |
|
150 | + $id=$_POST['username_form']; |
|
151 | + $UserList=array(); |
|
152 | + $userid_match_login = array(); |
|
153 | + foreach ($id as $form_index=>$user_id) |
|
154 | + { |
|
155 | + if(is_array($_POST['checkboxes']) && in_array($form_index,array_values($_POST['checkboxes']))) |
|
156 | + { |
|
157 | + $tmp = ldap_add_user($user_id); |
|
158 | + $UserList[]= $tmp; |
|
159 | + $userid_match_login[$tmp] = $user_id; |
|
160 | + } |
|
161 | + } |
|
162 | + if (!empty($_POST['id_session'])) { |
|
163 | + $num = 0; |
|
164 | + $tbl_session_user = Database::get_main_table(TABLE_MAIN_SESSION_USER); |
|
165 | + $tbl_session = Database::get_main_table(TABLE_MAIN_SESSION); |
|
166 | + foreach ($UserList as $user_id) { |
|
167 | 167 | $res_user = Database::insert( |
168 | 168 | $tbl_session_user, |
169 | 169 | [ |
@@ -175,15 +175,15 @@ discard block |
||
175 | 175 | if ($res_user !== false) { |
176 | 176 | $num++; |
177 | 177 | } |
178 | - } |
|
179 | - |
|
180 | - if($num>0) { |
|
181 | - $sql = 'UPDATE '.$tbl_session.' SET nbr_users = (nbr_users + '.$num.') WHERE id = '.intval($id_session); |
|
182 | - $res = Database::query($sql); |
|
183 | - } |
|
184 | - header('Location: resume_session.php?id_session='.Security::remove_XSS($_POST['id_session'])); |
|
185 | - } |
|
186 | - /* |
|
178 | + } |
|
179 | + |
|
180 | + if($num>0) { |
|
181 | + $sql = 'UPDATE '.$tbl_session.' SET nbr_users = (nbr_users + '.$num.') WHERE id = '.intval($id_session); |
|
182 | + $res = Database::query($sql); |
|
183 | + } |
|
184 | + header('Location: resume_session.php?id_session='.Security::remove_XSS($_POST['id_session'])); |
|
185 | + } |
|
186 | + /* |
|
187 | 187 | else |
188 | 188 | { |
189 | 189 | Display :: display_header($tool_name); |
@@ -202,13 +202,13 @@ discard block |
||
202 | 202 | Display :: display_normal_message($message,false); |
203 | 203 | } |
204 | 204 | */ |
205 | - else |
|
206 | - { |
|
207 | - Display::display_header($tool_name); |
|
208 | - $message=get_lang('NoUserAdded'); |
|
209 | - Display :: display_normal_message($message,false); |
|
210 | - } |
|
211 | - echo '<br /><br />'; |
|
205 | + else |
|
206 | + { |
|
207 | + Display::display_header($tool_name); |
|
208 | + $message=get_lang('NoUserAdded'); |
|
209 | + Display :: display_normal_message($message,false); |
|
210 | + } |
|
211 | + echo '<br /><br />'; |
|
212 | 212 | echo '<a href="ldap_import_students.php?annee=&composante=&etape=">'.get_lang('BackToNewSearch').'</a>'; |
213 | 213 | echo '<br /><br />'; |
214 | 214 | } |
@@ -13,8 +13,8 @@ discard block |
||
13 | 13 | |
14 | 14 | api_protect_global_admin_script(); |
15 | 15 | if (!api_get_multiple_access_url()) { |
16 | - header('Location: index.php'); |
|
17 | - exit; |
|
16 | + header('Location: index.php'); |
|
17 | + exit; |
|
18 | 18 | } |
19 | 19 | |
20 | 20 | $form_sent = 0; |
@@ -44,36 +44,36 @@ discard block |
||
44 | 44 | api_display_tool_title($tool_name); |
45 | 45 | |
46 | 46 | if ($_POST['form_sent']) { |
47 | - $form_sent = $_POST['form_sent']; |
|
48 | - $users = is_array($_POST['user_list']) ? $_POST['user_list'] : array() ; |
|
49 | - $url_list = is_array($_POST['url_list']) ? $_POST['url_list'] : array() ; |
|
50 | - $first_letter_user = $_POST['first_letter_user']; |
|
47 | + $form_sent = $_POST['form_sent']; |
|
48 | + $users = is_array($_POST['user_list']) ? $_POST['user_list'] : array() ; |
|
49 | + $url_list = is_array($_POST['url_list']) ? $_POST['url_list'] : array() ; |
|
50 | + $first_letter_user = $_POST['first_letter_user']; |
|
51 | 51 | |
52 | - foreach($users as $key => $value) { |
|
53 | - $users[$key] = intval($value); |
|
54 | - } |
|
52 | + foreach($users as $key => $value) { |
|
53 | + $users[$key] = intval($value); |
|
54 | + } |
|
55 | 55 | |
56 | - if ($form_sent == 1) { |
|
57 | - if (count($users) == 0 || count($url_list) == 0) { |
|
58 | - Display :: display_error_message(get_lang('AtLeastOneUserAndOneURL')); |
|
59 | - } else { |
|
60 | - UrlManager::add_users_to_urls($users,$url_list); |
|
61 | - Display :: display_confirmation_message(get_lang('UsersBelongURL')); |
|
62 | - } |
|
63 | - } |
|
56 | + if ($form_sent == 1) { |
|
57 | + if (count($users) == 0 || count($url_list) == 0) { |
|
58 | + Display :: display_error_message(get_lang('AtLeastOneUserAndOneURL')); |
|
59 | + } else { |
|
60 | + UrlManager::add_users_to_urls($users,$url_list); |
|
61 | + Display :: display_confirmation_message(get_lang('UsersBelongURL')); |
|
62 | + } |
|
63 | + } |
|
64 | 64 | } |
65 | 65 | |
66 | 66 | /* Display GUI */ |
67 | 67 | if (empty($first_letter_user)) { |
68 | - $sql = "SELECT count(*) as nb_users FROM $tbl_user"; |
|
69 | - $result = Database::query($sql); |
|
70 | - $num_row = Database::fetch_array($result); |
|
68 | + $sql = "SELECT count(*) as nb_users FROM $tbl_user"; |
|
69 | + $result = Database::query($sql); |
|
70 | + $num_row = Database::fetch_array($result); |
|
71 | 71 | if ($num_row['nb_users']>1000) { |
72 | 72 | //if there are too much users to gracefully handle with the HTML select list, |
73 | 73 | // assign a default filter on users names |
74 | 74 | $first_letter_user = 'A'; |
75 | 75 | } |
76 | - unset($result); |
|
76 | + unset($result); |
|
77 | 77 | } |
78 | 78 | $first_letter_user_lower = Database::escape_string(api_strtolower($first_letter_user)); |
79 | 79 | |
@@ -104,7 +104,7 @@ discard block |
||
104 | 104 | <option value="">--</option> |
105 | 105 | <?php |
106 | 106 | echo Display :: get_alphabet_options($first_letter_user); |
107 | - ?> |
|
107 | + ?> |
|
108 | 108 | </select> |
109 | 109 | </td> |
110 | 110 | <td width="20%"> </td> |
@@ -116,14 +116,14 @@ discard block |
||
116 | 116 | <td width="40%" align="center"> |
117 | 117 | <select name="user_list[]" multiple="multiple" size="20" style="width:380px;"> |
118 | 118 | <?php |
119 | - foreach ($db_users as $user) { |
|
120 | - ?> |
|
119 | + foreach ($db_users as $user) { |
|
120 | + ?> |
|
121 | 121 | <option value="<?php echo $user['user_id']; ?>" <?php if(in_array($user['user_id'], $users)) echo 'selected="selected"'; ?>> |
122 | 122 | <?php echo api_get_person_name($user['firstname'], $user['lastname']).' ('.$user['username'].')'; ?> |
123 | 123 | </option> |
124 | 124 | <?php |
125 | - } |
|
126 | - ?> |
|
125 | + } |
|
126 | + ?> |
|
127 | 127 | </select> |
128 | 128 | </td> |
129 | 129 | <td width="20%" valign="middle" align="center"> |
@@ -132,14 +132,14 @@ discard block |
||
132 | 132 | <td width="40%" align="center"> |
133 | 133 | <select name="url_list[]" multiple="multiple" size="20" style="width:230px;"> |
134 | 134 | <?php |
135 | - foreach ($db_urls as $url_obj) { |
|
136 | - ?> |
|
135 | + foreach ($db_urls as $url_obj) { |
|
136 | + ?> |
|
137 | 137 | <option value="<?php echo $url_obj['id']; ?>" <?php if(in_array($url_obj['id'],$url_list)) echo 'selected="selected"'; ?>> |
138 | 138 | <?php echo $url_obj['url']; ?> |
139 | 139 | </option> |
140 | 140 | <?php |
141 | - } |
|
142 | - ?> |
|
141 | + } |
|
142 | + ?> |
|
143 | 143 | </select> |
144 | 144 | </td> |
145 | 145 | </tr> |
@@ -20,24 +20,24 @@ discard block |
||
20 | 20 | $form_sent = 0; |
21 | 21 | $first_letter_user = ''; |
22 | 22 | $first_letter_course = ''; |
23 | -$courses = array (); |
|
23 | +$courses = array(); |
|
24 | 24 | $url_list = array(); |
25 | 25 | $users = array(); |
26 | 26 | |
27 | 27 | $tbl_access_url_rel_user = Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER); |
28 | 28 | $tbl_access_url = Database :: get_main_table(TABLE_MAIN_ACCESS_URL); |
29 | -$tbl_user = Database :: get_main_table(TABLE_MAIN_USER); |
|
29 | +$tbl_user = Database :: get_main_table(TABLE_MAIN_USER); |
|
30 | 30 | |
31 | 31 | /* Header */ |
32 | 32 | $tool_name = get_lang('AddUsersToURL'); |
33 | -$interbreadcrumb[] = array ('url' => 'index.php', 'name' => get_lang('PlatformAdmin')); |
|
34 | -$interbreadcrumb[] = array ('url' => 'access_urls.php', 'name' => get_lang('MultipleAccessURLs')); |
|
33 | +$interbreadcrumb[] = array('url' => 'index.php', 'name' => get_lang('PlatformAdmin')); |
|
34 | +$interbreadcrumb[] = array('url' => 'access_urls.php', 'name' => get_lang('MultipleAccessURLs')); |
|
35 | 35 | |
36 | 36 | Display :: display_header($tool_name); |
37 | 37 | |
38 | 38 | echo '<div class="actions">'; |
39 | 39 | echo Display::url( |
40 | - Display::return_icon('edit.png', get_lang('EditUsersToURL'),''), |
|
40 | + Display::return_icon('edit.png', get_lang('EditUsersToURL'), ''), |
|
41 | 41 | api_get_path(WEB_CODE_PATH).'admin/access_url_edit_users_to_url.php'); |
42 | 42 | echo '</div>'; |
43 | 43 | |
@@ -45,11 +45,11 @@ discard block |
||
45 | 45 | |
46 | 46 | if ($_POST['form_sent']) { |
47 | 47 | $form_sent = $_POST['form_sent']; |
48 | - $users = is_array($_POST['user_list']) ? $_POST['user_list'] : array() ; |
|
49 | - $url_list = is_array($_POST['url_list']) ? $_POST['url_list'] : array() ; |
|
48 | + $users = is_array($_POST['user_list']) ? $_POST['user_list'] : array(); |
|
49 | + $url_list = is_array($_POST['url_list']) ? $_POST['url_list'] : array(); |
|
50 | 50 | $first_letter_user = $_POST['first_letter_user']; |
51 | 51 | |
52 | - foreach($users as $key => $value) { |
|
52 | + foreach ($users as $key => $value) { |
|
53 | 53 | $users[$key] = intval($value); |
54 | 54 | } |
55 | 55 | |
@@ -57,7 +57,7 @@ discard block |
||
57 | 57 | if (count($users) == 0 || count($url_list) == 0) { |
58 | 58 | Display :: display_error_message(get_lang('AtLeastOneUserAndOneURL')); |
59 | 59 | } else { |
60 | - UrlManager::add_users_to_urls($users,$url_list); |
|
60 | + UrlManager::add_users_to_urls($users, $url_list); |
|
61 | 61 | Display :: display_confirmation_message(get_lang('UsersBelongURL')); |
62 | 62 | } |
63 | 63 | } |
@@ -68,7 +68,7 @@ discard block |
||
68 | 68 | $sql = "SELECT count(*) as nb_users FROM $tbl_user"; |
69 | 69 | $result = Database::query($sql); |
70 | 70 | $num_row = Database::fetch_array($result); |
71 | - if ($num_row['nb_users']>1000) { |
|
71 | + if ($num_row['nb_users'] > 1000) { |
|
72 | 72 | //if there are too much users to gracefully handle with the HTML select list, |
73 | 73 | // assign a default filter on users names |
74 | 74 | $first_letter_user = 'A'; |
@@ -99,7 +99,7 @@ discard block |
||
99 | 99 | <td width="40%" align="center"> |
100 | 100 | <b><?php echo get_lang('UserList'); ?></b> |
101 | 101 | <br/><br/> |
102 | - <?php echo get_lang('Select').' ' ; echo $target_name == 'firstname'? get_lang('FirstName') : get_lang('LastName'); ?> |
|
102 | + <?php echo get_lang('Select').' '; echo $target_name == 'firstname' ? get_lang('FirstName') : get_lang('LastName'); ?> |
|
103 | 103 | <select name="first_letter_user" onchange="javascript:document.formulaire.form_sent.value='2'; document.formulaire.submit();"> |
104 | 104 | <option value="">--</option> |
105 | 105 | <?php |
@@ -118,7 +118,7 @@ discard block |
||
118 | 118 | <?php |
119 | 119 | foreach ($db_users as $user) { |
120 | 120 | ?> |
121 | - <option value="<?php echo $user['user_id']; ?>" <?php if(in_array($user['user_id'], $users)) echo 'selected="selected"'; ?>> |
|
121 | + <option value="<?php echo $user['user_id']; ?>" <?php if (in_array($user['user_id'], $users)) echo 'selected="selected"'; ?>> |
|
122 | 122 | <?php echo api_get_person_name($user['firstname'], $user['lastname']).' ('.$user['username'].')'; ?> |
123 | 123 | </option> |
124 | 124 | <?php |
@@ -134,7 +134,7 @@ discard block |
||
134 | 134 | <?php |
135 | 135 | foreach ($db_urls as $url_obj) { |
136 | 136 | ?> |
137 | - <option value="<?php echo $url_obj['id']; ?>" <?php if(in_array($url_obj['id'],$url_list)) echo 'selected="selected"'; ?>> |
|
137 | + <option value="<?php echo $url_obj['id']; ?>" <?php if (in_array($url_obj['id'], $url_list)) echo 'selected="selected"'; ?>> |
|
138 | 138 | <?php echo $url_obj['url']; ?> |
139 | 139 | </option> |
140 | 140 | <?php |
@@ -118,7 +118,10 @@ discard block |
||
118 | 118 | <?php |
119 | 119 | foreach ($db_users as $user) { |
120 | 120 | ?> |
121 | - <option value="<?php echo $user['user_id']; ?>" <?php if(in_array($user['user_id'], $users)) echo 'selected="selected"'; ?>> |
|
121 | + <option value="<?php echo $user['user_id']; ?>" <?php if(in_array($user['user_id'], $users)) { |
|
122 | + echo 'selected="selected"'; |
|
123 | +} |
|
124 | +?>> |
|
122 | 125 | <?php echo api_get_person_name($user['firstname'], $user['lastname']).' ('.$user['username'].')'; ?> |
123 | 126 | </option> |
124 | 127 | <?php |
@@ -134,7 +137,10 @@ discard block |
||
134 | 137 | <?php |
135 | 138 | foreach ($db_urls as $url_obj) { |
136 | 139 | ?> |
137 | - <option value="<?php echo $url_obj['id']; ?>" <?php if(in_array($url_obj['id'],$url_list)) echo 'selected="selected"'; ?>> |
|
140 | + <option value="<?php echo $url_obj['id']; ?>" <?php if(in_array($url_obj['id'],$url_list)) { |
|
141 | + echo 'selected="selected"'; |
|
142 | +} |
|
143 | +?>> |
|
138 | 144 | <?php echo $url_obj['url']; ?> |
139 | 145 | </option> |
140 | 146 | <?php |
@@ -189,8 +189,8 @@ |
||
189 | 189 | { |
190 | 190 | $code = CourseRequestManager::get_course_request_code($id); |
191 | 191 | $result = '<a href="course_request_edit.php?id='.$id.'&caller=0">'.Display::return_icon('edit.png', get_lang('Edit'), array('style' => 'vertical-align: middle;')).'</a>'. |
192 | - ' <a href="?accept_course_request='.$id.'">'.Display::return_icon('accept.png', get_lang('AcceptThisCourseRequest'), array('style' => 'vertical-align: middle;', 'onclick' => 'javascript: if (!confirm(\''.addslashes(api_htmlentities(sprintf(get_lang('ANewCourseWillBeCreated'), $code), ENT_QUOTES)).'\')) return false;'),16).'</a>'. |
|
193 | - ' <a href="?reject_course_request='.$id.'">'.Display::return_icon('error.png', get_lang('RejectThisCourseRequest'), array('style' => 'vertical-align: middle;', 'onclick' => 'javascript: if (!confirm(\''.addslashes(api_htmlentities(sprintf(get_lang('ACourseRequestWillBeRejected'), $code), ENT_QUOTES)).'\')) return false;'),16).'</a>'; |
|
192 | + ' <a href="?accept_course_request='.$id.'">'.Display::return_icon('accept.png', get_lang('AcceptThisCourseRequest'), array('style' => 'vertical-align: middle;', 'onclick' => 'javascript: if (!confirm(\''.addslashes(api_htmlentities(sprintf(get_lang('ANewCourseWillBeCreated'), $code), ENT_QUOTES)).'\')) return false;'), 16).'</a>'. |
|
193 | + ' <a href="?reject_course_request='.$id.'">'.Display::return_icon('error.png', get_lang('RejectThisCourseRequest'), array('style' => 'vertical-align: middle;', 'onclick' => 'javascript: if (!confirm(\''.addslashes(api_htmlentities(sprintf(get_lang('ACourseRequestWillBeRejected'), $code), ENT_QUOTES)).'\')) return false;'), 16).'</a>'; |
|
194 | 194 | if (!CourseRequestManager::additional_info_asked($id)) { |
195 | 195 | $result .= ' <a href="?request_info='.$id.'">'.Display::return_icon('request_info.gif', get_lang('AskAdditionalInfo'), array('style' => 'vertical-align: middle;', 'onclick' => 'javascript: if (!confirm(\''.addslashes(api_htmlentities(sprintf(get_lang('AdditionalInfoWillBeAsked'), $code), ENT_QUOTES)).'\')) return false;')).'</a>'; |
196 | 196 | } |
@@ -8,43 +8,43 @@ discard block |
||
8 | 8 | */ |
9 | 9 | exit(); //not yet functional, needs to be revised |
10 | 10 | |
11 | -$cidReset=true; |
|
11 | +$cidReset = true; |
|
12 | 12 | |
13 | 13 | require('../inc/global.inc.php'); |
14 | 14 | $libpath = api_get_path(LIBRARY_PATH); |
15 | 15 | require("../auth/ldap/authldap.php"); |
16 | -$annee_base=date('Y'); |
|
16 | +$annee_base = date('Y'); |
|
17 | 17 | // setting the section (for the tabs) |
18 | 18 | $this_section = SECTION_PLATFORM_ADMIN; |
19 | 19 | api_protect_admin_script(); |
20 | 20 | |
21 | 21 | // setting breadcrumbs |
22 | -$interbreadcrumb[]=array('url' => 'index.php',"name" => get_lang('PlatformAdmin')); |
|
23 | -$interbreadcrumb[]=array('url' => api_get_self(),"name" => get_lang('SessionsList')); |
|
22 | +$interbreadcrumb[] = array('url' => 'index.php', "name" => get_lang('PlatformAdmin')); |
|
23 | +$interbreadcrumb[] = array('url' => api_get_self(), "name" => get_lang('SessionsList')); |
|
24 | 24 | |
25 | 25 | // Database Table Definitions |
26 | 26 | $tbl_session = Database::get_main_table(TABLE_MAIN_SESSION); |
27 | -$tbl_session_rel_class = Database::get_main_table(TABLE_MAIN_SESSION_CLASS); |
|
28 | -$tbl_session_rel_course = Database::get_main_table(TABLE_MAIN_SESSION_COURSE); |
|
29 | -$tbl_session_rel_course_rel_user = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER); |
|
30 | -$tbl_course = Database::get_main_table(TABLE_MAIN_COURSE); |
|
31 | -$tbl_user = Database::get_main_table(TABLE_MAIN_USER); |
|
32 | -$tbl_session_rel_user = Database::get_main_table(TABLE_MAIN_SESSION_USER); |
|
33 | -$tbl_class = Database::get_main_table(TABLE_MAIN_CLASS); |
|
34 | -$tbl_class_user = Database::get_main_table(TABLE_MAIN_CLASS_USER); |
|
27 | +$tbl_session_rel_class = Database::get_main_table(TABLE_MAIN_SESSION_CLASS); |
|
28 | +$tbl_session_rel_course = Database::get_main_table(TABLE_MAIN_SESSION_COURSE); |
|
29 | +$tbl_session_rel_course_rel_user = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER); |
|
30 | +$tbl_course = Database::get_main_table(TABLE_MAIN_COURSE); |
|
31 | +$tbl_user = Database::get_main_table(TABLE_MAIN_USER); |
|
32 | +$tbl_session_rel_user = Database::get_main_table(TABLE_MAIN_SESSION_USER); |
|
33 | +$tbl_class = Database::get_main_table(TABLE_MAIN_CLASS); |
|
34 | +$tbl_class_user = Database::get_main_table(TABLE_MAIN_CLASS_USER); |
|
35 | 35 | |
36 | -$tbl_session_rel_etape = "session_rel_etape"; |
|
36 | +$tbl_session_rel_etape = "session_rel_etape"; |
|
37 | 37 | |
38 | -$id_session=intval($_GET['id_session']); |
|
38 | +$id_session = intval($_GET['id_session']); |
|
39 | 39 | |
40 | -$formSent=0; |
|
41 | -$errorMsg=$firstLetterUser=$firstLetterSession=''; |
|
42 | -$UserList=$SessionList=array(); |
|
43 | -$users=$sessions=array(); |
|
44 | -$noPHP_SELF=true; |
|
40 | +$formSent = 0; |
|
41 | +$errorMsg = $firstLetterUser = $firstLetterSession = ''; |
|
42 | +$UserList = $SessionList = array(); |
|
43 | +$users = $sessions = array(); |
|
44 | +$noPHP_SELF = true; |
|
45 | 45 | |
46 | -$page=intval($_GET['page']); |
|
47 | -$action=$_REQUEST['action']; |
|
46 | +$page = intval($_GET['page']); |
|
47 | +$action = $_REQUEST['action']; |
|
48 | 48 | |
49 | 49 | $tool_name = get_lang('Synchro LDAP : Import Etudiants/Etapes dans session'); |
50 | 50 | Display::display_header($tool_name); |
@@ -59,10 +59,10 @@ discard block |
||
59 | 59 | </form> |
60 | 60 | |
61 | 61 | <?php |
62 | -if (isset($action) && ($action=="synchro")) { |
|
63 | - $included=true; |
|
62 | +if (isset($action) && ($action == "synchro")) { |
|
63 | + $included = true; |
|
64 | 64 | require('ldap_synchro.php'); |
65 | - Display :: display_normal_message($message,false); |
|
65 | + Display :: display_normal_message($message, false); |
|
66 | 66 | } |
67 | 67 | Display::display_footer(); |
68 | 68 | ?> |
@@ -60,9 +60,9 @@ |
||
60 | 60 | |
61 | 61 | <?php |
62 | 62 | if (isset($action) && ($action=="synchro")) { |
63 | - $included=true; |
|
64 | - require('ldap_synchro.php'); |
|
65 | - Display :: display_normal_message($message,false); |
|
63 | + $included=true; |
|
64 | + require('ldap_synchro.php'); |
|
65 | + Display :: display_normal_message($message,false); |
|
66 | 66 | } |
67 | 67 | Display::display_footer(); |
68 | 68 | ?> |
@@ -13,8 +13,8 @@ |
||
13 | 13 | |
14 | 14 | $tool_name = get_lang('Export'); |
15 | 15 | |
16 | -$interbreadcrumb[] = array ("url" => 'index.php', "name" => get_lang('PlatformAdmin')); |
|
17 | -$interbreadcrumb[] = array ('url' => 'usergroups.php', 'name' => get_lang('Classes')); |
|
16 | +$interbreadcrumb[] = array("url" => 'index.php', "name" => get_lang('PlatformAdmin')); |
|
17 | +$interbreadcrumb[] = array('url' => 'usergroups.php', 'name' => get_lang('Classes')); |
|
18 | 18 | |
19 | 19 | set_time_limit(0); |
20 | 20 |
@@ -118,8 +118,7 @@ |
||
118 | 118 | if (isset($included) && ($included)) |
119 | 119 | { |
120 | 120 | $message .= "> $name_session: ".count($UserAdd)." ".get_lang('Added').' '.get_lang('And').' '.count($UserUpdate).' '.get_lang('Modified').'<br/>'; |
121 | - } |
|
122 | - else |
|
121 | + } else |
|
123 | 122 | { |
124 | 123 | print "> $name_session: ".count($UserAdd).get_lang('Added').' '.get_lang('And').' '.count($UserUpdate).' '.get_lang('Modified')."\n"; |
125 | 124 | } |
@@ -44,121 +44,121 @@ |
||
44 | 44 | $users=Database::store_result($result); |
45 | 45 | |
46 | 46 | foreach($Sessions as $session){ |
47 | - $id_session = $session['id']; |
|
48 | - $name_session = $session['name']; |
|
49 | - $UserList=array(); |
|
50 | - $UserUpdate=array(); |
|
51 | - $UserAdd=array(); |
|
47 | + $id_session = $session['id']; |
|
48 | + $name_session = $session['name']; |
|
49 | + $UserList=array(); |
|
50 | + $UserUpdate=array(); |
|
51 | + $UserAdd=array(); |
|
52 | 52 | |
53 | - // Parse des code etape de la session |
|
54 | - /* |
|
53 | + // Parse des code etape de la session |
|
54 | + /* |
|
55 | 55 | $sql = "SELECT id_session, code_etape, etape_description, code_ufr, annee |
56 | 56 | FROM $tbl_session_rel_etape |
57 | 57 | WHERE id_session='$id_session' |
58 | 58 | ORDER BY code_ufr, code_etape"; |
59 | 59 | $result = Database::query($sql); |
60 | 60 | */ |
61 | - $ds = ldap_connect($ldap_host, $ldap_port) or die(get_lang('LDAPConnectionError')); |
|
62 | - ldap_set_version($ds); |
|
63 | - // Import des utilisateurs des etapes dans la session |
|
64 | - if ($ds) |
|
65 | - { |
|
66 | - $r = false; |
|
67 | - $res = ldap_handle_bind($ds, $r); |
|
68 | - $UserList=array(); |
|
69 | - if($result !== false) |
|
70 | - { |
|
71 | - //while($row = Database::fetch_array($result)) |
|
72 | - //{ |
|
73 | - /* |
|
61 | + $ds = ldap_connect($ldap_host, $ldap_port) or die(get_lang('LDAPConnectionError')); |
|
62 | + ldap_set_version($ds); |
|
63 | + // Import des utilisateurs des etapes dans la session |
|
64 | + if ($ds) |
|
65 | + { |
|
66 | + $r = false; |
|
67 | + $res = ldap_handle_bind($ds, $r); |
|
68 | + $UserList=array(); |
|
69 | + if($result !== false) |
|
70 | + { |
|
71 | + //while($row = Database::fetch_array($result)) |
|
72 | + //{ |
|
73 | + /* |
|
74 | 74 | $annee = $row['annee']; |
75 | 75 | $code_ufr = $row['code_ufr']; |
76 | 76 | $etape = $row['code_etape']; |
77 | 77 | */ |
78 | - // LDAP Query |
|
79 | - // edupersonorgunitdn=ou=12CI1,ou=2006,ou=diploma,o=Paris1,dc=univ-paris1,dc=fr |
|
80 | - //etapescommented |
|
81 | - //$sr = @ ldap_search($ds, "ou=people,$LDAPbasedn", "edupersonorgunitdn=ou=$etape,ou=$annee,ou=diploma,$LDAPbasedn"); |
|
82 | - $sr = @ ldap_search($ds, $ldap_basedn, '(uid=*)'); |
|
83 | - $info = ldap_get_entries($ds, $sr); |
|
84 | - for ($key = 0; $key < $info["count"]; $key ++) |
|
85 | - { |
|
86 | - echo "<pre>"; |
|
87 | - print_r($info[$key]); |
|
88 | - echo "</pre>"; |
|
89 | - $lastname = api_utf8_decode($info[$key]["sn"][0]); |
|
90 | - $firstname = api_utf8_decode($info[$key]["givenname"][0]); |
|
91 | - $email = $info[$key]["mail"][0]; |
|
92 | - // Get uid from dn |
|
93 | - $dn_array=ldap_explode_dn($info[$key]["dn"],1); |
|
94 | - $username = $dn_array[0]; // uid is first key |
|
95 | - $outab[] = $info[$key]["edupersonprimaryaffiliation"][0]; // Ici "student" |
|
96 | - $val = ldap_get_values_len($ds, $sr, "userPassword"); |
|
97 | - $password = $val[0]; |
|
98 | - // Pour faciliter la gestion on ajoute le code "etape-annee" |
|
99 | - $official_code=$etape."-".$annee; |
|
100 | - $auth_source="ldap"; |
|
101 | - // Pas de date d'expiration d'etudiant (a recuperer par rapport au shadow expire LDAP) |
|
102 | - $expiration_date=''; |
|
103 | - $active=1; |
|
104 | - // Ajout de l'utilisateur |
|
105 | - if (UserManager::is_username_available($username)) { |
|
106 | - $user_id = UserManager::create_user($firstname,$lastname,$status,$email,$username,$password,$official_code,api_get_setting('platformLanguage'),$phone,$picture_uri,$auth_source,$expiration_date,$active); |
|
107 | - $UserAdd[]=$user_id; |
|
108 | - } else { |
|
109 | - $user = api_get_user_info_from_username($username); |
|
110 | - $user_id=$user['user_id']; |
|
111 | - UserManager::update_user($user_id, $firstname, $lastname, $username, null, null, $email, $status, $official_code, $phone, $picture_uri, $expiration_date, $active); |
|
112 | - $UserUpdate[]=$user_id; |
|
113 | - } |
|
114 | - $UserList[]=$user_id; |
|
115 | - } |
|
116 | - //} |
|
117 | - } |
|
118 | - if (isset($included) && ($included)) |
|
119 | - { |
|
120 | - $message .= "> $name_session: ".count($UserAdd)." ".get_lang('Added').' '.get_lang('And').' '.count($UserUpdate).' '.get_lang('Modified').'<br/>'; |
|
121 | - } |
|
122 | - else |
|
123 | - { |
|
124 | - print "> $name_session: ".count($UserAdd).get_lang('Added').' '.get_lang('And').' '.count($UserUpdate).' '.get_lang('Modified')."\n"; |
|
125 | - } |
|
78 | + // LDAP Query |
|
79 | + // edupersonorgunitdn=ou=12CI1,ou=2006,ou=diploma,o=Paris1,dc=univ-paris1,dc=fr |
|
80 | + //etapescommented |
|
81 | + //$sr = @ ldap_search($ds, "ou=people,$LDAPbasedn", "edupersonorgunitdn=ou=$etape,ou=$annee,ou=diploma,$LDAPbasedn"); |
|
82 | + $sr = @ ldap_search($ds, $ldap_basedn, '(uid=*)'); |
|
83 | + $info = ldap_get_entries($ds, $sr); |
|
84 | + for ($key = 0; $key < $info["count"]; $key ++) |
|
85 | + { |
|
86 | + echo "<pre>"; |
|
87 | + print_r($info[$key]); |
|
88 | + echo "</pre>"; |
|
89 | + $lastname = api_utf8_decode($info[$key]["sn"][0]); |
|
90 | + $firstname = api_utf8_decode($info[$key]["givenname"][0]); |
|
91 | + $email = $info[$key]["mail"][0]; |
|
92 | + // Get uid from dn |
|
93 | + $dn_array=ldap_explode_dn($info[$key]["dn"],1); |
|
94 | + $username = $dn_array[0]; // uid is first key |
|
95 | + $outab[] = $info[$key]["edupersonprimaryaffiliation"][0]; // Ici "student" |
|
96 | + $val = ldap_get_values_len($ds, $sr, "userPassword"); |
|
97 | + $password = $val[0]; |
|
98 | + // Pour faciliter la gestion on ajoute le code "etape-annee" |
|
99 | + $official_code=$etape."-".$annee; |
|
100 | + $auth_source="ldap"; |
|
101 | + // Pas de date d'expiration d'etudiant (a recuperer par rapport au shadow expire LDAP) |
|
102 | + $expiration_date=''; |
|
103 | + $active=1; |
|
104 | + // Ajout de l'utilisateur |
|
105 | + if (UserManager::is_username_available($username)) { |
|
106 | + $user_id = UserManager::create_user($firstname,$lastname,$status,$email,$username,$password,$official_code,api_get_setting('platformLanguage'),$phone,$picture_uri,$auth_source,$expiration_date,$active); |
|
107 | + $UserAdd[]=$user_id; |
|
108 | + } else { |
|
109 | + $user = api_get_user_info_from_username($username); |
|
110 | + $user_id=$user['user_id']; |
|
111 | + UserManager::update_user($user_id, $firstname, $lastname, $username, null, null, $email, $status, $official_code, $phone, $picture_uri, $expiration_date, $active); |
|
112 | + $UserUpdate[]=$user_id; |
|
113 | + } |
|
114 | + $UserList[]=$user_id; |
|
115 | + } |
|
116 | + //} |
|
117 | + } |
|
118 | + if (isset($included) && ($included)) |
|
119 | + { |
|
120 | + $message .= "> $name_session: ".count($UserAdd)." ".get_lang('Added').' '.get_lang('And').' '.count($UserUpdate).' '.get_lang('Modified').'<br/>'; |
|
121 | + } |
|
122 | + else |
|
123 | + { |
|
124 | + print "> $name_session: ".count($UserAdd).get_lang('Added').' '.get_lang('And').' '.count($UserUpdate).' '.get_lang('Modified')."\n"; |
|
125 | + } |
|
126 | 126 | |
127 | - // Une fois les utilisateurs importer dans la base des utilisateurs, on peux les affecter la session |
|
128 | - $result=Database::query("SELECT c_id FROM $tbl_session_rel_course WHERE session_id='$id_session'"); |
|
129 | - $CourseList=array(); |
|
130 | - while($row=Database::fetch_array($result)) { |
|
131 | - $CourseList[]= $row['c_id']; |
|
132 | - } |
|
127 | + // Une fois les utilisateurs importer dans la base des utilisateurs, on peux les affecter la session |
|
128 | + $result=Database::query("SELECT c_id FROM $tbl_session_rel_course WHERE session_id='$id_session'"); |
|
129 | + $CourseList=array(); |
|
130 | + while($row=Database::fetch_array($result)) { |
|
131 | + $CourseList[]= $row['c_id']; |
|
132 | + } |
|
133 | 133 | |
134 | - foreach ($CourseList as $enreg_course) { |
|
135 | - // On ajoute la relation entre l'utilisateur et le cours |
|
136 | - foreach ($UserList as $enreg_user) { |
|
137 | - $sql = "INSERT IGNORE INTO $tbl_session_rel_course_rel_user(session_id,c_id,user_id) |
|
134 | + foreach ($CourseList as $enreg_course) { |
|
135 | + // On ajoute la relation entre l'utilisateur et le cours |
|
136 | + foreach ($UserList as $enreg_user) { |
|
137 | + $sql = "INSERT IGNORE INTO $tbl_session_rel_course_rel_user(session_id,c_id,user_id) |
|
138 | 138 | VALUES('$id_session','$enreg_course','$enreg_user')"; |
139 | - Database::query($sql); |
|
140 | - } |
|
141 | - $sql = "SELECT COUNT(user_id) as nbUsers " . |
|
142 | - "FROM $tbl_session_rel_course_rel_user " . |
|
143 | - "WHERE session_id='$id_session' AND c_id='$enreg_course'"; |
|
144 | - $rs = Database::query($sql); |
|
145 | - list($nbr_users) = Database::fetch_array($rs); |
|
146 | - $sql = "UPDATE $tbl_session_rel_course SET nbr_users=$nbr_users |
|
139 | + Database::query($sql); |
|
140 | + } |
|
141 | + $sql = "SELECT COUNT(user_id) as nbUsers " . |
|
142 | + "FROM $tbl_session_rel_course_rel_user " . |
|
143 | + "WHERE session_id='$id_session' AND c_id='$enreg_course'"; |
|
144 | + $rs = Database::query($sql); |
|
145 | + list($nbr_users) = Database::fetch_array($rs); |
|
146 | + $sql = "UPDATE $tbl_session_rel_course SET nbr_users=$nbr_users |
|
147 | 147 | WHERE session_id='$id_session' AND c_id = '$enreg_course'"; |
148 | - Database::query($sql); |
|
149 | - } |
|
150 | - // On ajoute la relation entre l'utilisateur et la session |
|
151 | - foreach($UserList as $enreg_user){ |
|
152 | - $sql = "INSERT IGNORE INTO $tbl_session_rel_user(session_id, user_id, registered_at) " . |
|
153 | - "VALUES('$id_session','$enreg_user', '" . api_get_utc_datetime() . "')"; |
|
154 | - Database::query($sql); |
|
155 | - } |
|
156 | - $sql = "SELECT COUNT(user_id) as nbUsers " . |
|
157 | - "FROM $tbl_session_rel_user " . |
|
158 | - "WHERE session_id='$id_session' AND relation_type<>".SESSION_RELATION_TYPE_RRHH.""; |
|
159 | - $rs = Database::query($sql); |
|
160 | - list($nbr_users) = Database::fetch_array($rs); |
|
161 | - $sql = "UPDATE $tbl_session SET nbr_users=$nbr_users WHERE id='$id_session'"; |
|
162 | - Database::query($sql); |
|
163 | - } |
|
148 | + Database::query($sql); |
|
149 | + } |
|
150 | + // On ajoute la relation entre l'utilisateur et la session |
|
151 | + foreach($UserList as $enreg_user){ |
|
152 | + $sql = "INSERT IGNORE INTO $tbl_session_rel_user(session_id, user_id, registered_at) " . |
|
153 | + "VALUES('$id_session','$enreg_user', '" . api_get_utc_datetime() . "')"; |
|
154 | + Database::query($sql); |
|
155 | + } |
|
156 | + $sql = "SELECT COUNT(user_id) as nbUsers " . |
|
157 | + "FROM $tbl_session_rel_user " . |
|
158 | + "WHERE session_id='$id_session' AND relation_type<>".SESSION_RELATION_TYPE_RRHH.""; |
|
159 | + $rs = Database::query($sql); |
|
160 | + list($nbr_users) = Database::fetch_array($rs); |
|
161 | + $sql = "UPDATE $tbl_session SET nbr_users=$nbr_users WHERE id='$id_session'"; |
|
162 | + Database::query($sql); |
|
163 | + } |
|
164 | 164 | } |
@@ -8,47 +8,47 @@ discard block |
||
8 | 8 | */ |
9 | 9 | exit(); //not yet functional, needs to be revised |
10 | 10 | |
11 | -$cidReset=true; |
|
11 | +$cidReset = true; |
|
12 | 12 | |
13 | 13 | require('../inc/global.inc.php'); |
14 | 14 | $libpath = api_get_path(LIBRARY_PATH); |
15 | 15 | require_once('../auth/ldap/authldap.php'); |
16 | -$annee_base=date('Y'); |
|
16 | +$annee_base = date('Y'); |
|
17 | 17 | // setting the section (for the tabs) |
18 | 18 | $this_section = SECTION_PLATFORM_ADMIN; |
19 | 19 | //api_protect_admin_script(); // on vire la secu... qui n'a pas lieu d'etre ici (script de synchro) |
20 | 20 | |
21 | 21 | // setting breadcrumbs |
22 | -$interbreadcrumb[]=array('url' => 'index.php',"name" => get_lang('PlatformAdmin')); |
|
23 | -$interbreadcrumb[]=array('url' => api_get_self(),"name" => "Liste des sessions"); |
|
22 | +$interbreadcrumb[] = array('url' => 'index.php', "name" => get_lang('PlatformAdmin')); |
|
23 | +$interbreadcrumb[] = array('url' => api_get_self(), "name" => "Liste des sessions"); |
|
24 | 24 | |
25 | 25 | // Database Table Definitions |
26 | 26 | $tbl_session = Database::get_main_table(TABLE_MAIN_SESSION); |
27 | -$tbl_session_rel_class = Database::get_main_table(TABLE_MAIN_SESSION_CLASS); |
|
28 | -$tbl_session_rel_course = Database::get_main_table(TABLE_MAIN_SESSION_COURSE); |
|
29 | -$tbl_session_rel_course_rel_user = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER); |
|
30 | -$tbl_course = Database::get_main_table(TABLE_MAIN_COURSE); |
|
31 | -$tbl_user = Database::get_main_table(TABLE_MAIN_USER); |
|
32 | -$tbl_session_rel_user = Database::get_main_table(TABLE_MAIN_SESSION_USER); |
|
33 | -$tbl_class = Database::get_main_table(TABLE_MAIN_CLASS); |
|
34 | -$tbl_class_user = Database::get_main_table(TABLE_MAIN_CLASS_USER); |
|
27 | +$tbl_session_rel_class = Database::get_main_table(TABLE_MAIN_SESSION_CLASS); |
|
28 | +$tbl_session_rel_course = Database::get_main_table(TABLE_MAIN_SESSION_COURSE); |
|
29 | +$tbl_session_rel_course_rel_user = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER); |
|
30 | +$tbl_course = Database::get_main_table(TABLE_MAIN_COURSE); |
|
31 | +$tbl_user = Database::get_main_table(TABLE_MAIN_USER); |
|
32 | +$tbl_session_rel_user = Database::get_main_table(TABLE_MAIN_SESSION_USER); |
|
33 | +$tbl_class = Database::get_main_table(TABLE_MAIN_CLASS); |
|
34 | +$tbl_class_user = Database::get_main_table(TABLE_MAIN_CLASS_USER); |
|
35 | 35 | |
36 | -$tbl_session_rel_etape = "session_rel_etape"; |
|
36 | +$tbl_session_rel_etape = "session_rel_etape"; |
|
37 | 37 | |
38 | -$message=""; |
|
38 | +$message = ""; |
|
39 | 39 | |
40 | -$result=Database::query("SELECT id, name FROM $tbl_session"); |
|
41 | -$Sessions=Database::store_result($result); |
|
40 | +$result = Database::query("SELECT id, name FROM $tbl_session"); |
|
41 | +$Sessions = Database::store_result($result); |
|
42 | 42 | |
43 | -$result=Database::query($sql); |
|
44 | -$users=Database::store_result($result); |
|
43 | +$result = Database::query($sql); |
|
44 | +$users = Database::store_result($result); |
|
45 | 45 | |
46 | -foreach($Sessions as $session){ |
|
46 | +foreach ($Sessions as $session) { |
|
47 | 47 | $id_session = $session['id']; |
48 | 48 | $name_session = $session['name']; |
49 | - $UserList=array(); |
|
50 | - $UserUpdate=array(); |
|
51 | - $UserAdd=array(); |
|
49 | + $UserList = array(); |
|
50 | + $UserUpdate = array(); |
|
51 | + $UserAdd = array(); |
|
52 | 52 | |
53 | 53 | // Parse des code etape de la session |
54 | 54 | /* |
@@ -65,8 +65,8 @@ discard block |
||
65 | 65 | { |
66 | 66 | $r = false; |
67 | 67 | $res = ldap_handle_bind($ds, $r); |
68 | - $UserList=array(); |
|
69 | - if($result !== false) |
|
68 | + $UserList = array(); |
|
69 | + if ($result !== false) |
|
70 | 70 | { |
71 | 71 | //while($row = Database::fetch_array($result)) |
72 | 72 | //{ |
@@ -81,7 +81,7 @@ discard block |
||
81 | 81 | //$sr = @ ldap_search($ds, "ou=people,$LDAPbasedn", "edupersonorgunitdn=ou=$etape,ou=$annee,ou=diploma,$LDAPbasedn"); |
82 | 82 | $sr = @ ldap_search($ds, $ldap_basedn, '(uid=*)'); |
83 | 83 | $info = ldap_get_entries($ds, $sr); |
84 | - for ($key = 0; $key < $info["count"]; $key ++) |
|
84 | + for ($key = 0; $key < $info["count"]; $key++) |
|
85 | 85 | { |
86 | 86 | echo "<pre>"; |
87 | 87 | print_r($info[$key]); |
@@ -90,28 +90,28 @@ discard block |
||
90 | 90 | $firstname = api_utf8_decode($info[$key]["givenname"][0]); |
91 | 91 | $email = $info[$key]["mail"][0]; |
92 | 92 | // Get uid from dn |
93 | - $dn_array=ldap_explode_dn($info[$key]["dn"],1); |
|
93 | + $dn_array = ldap_explode_dn($info[$key]["dn"], 1); |
|
94 | 94 | $username = $dn_array[0]; // uid is first key |
95 | 95 | $outab[] = $info[$key]["edupersonprimaryaffiliation"][0]; // Ici "student" |
96 | 96 | $val = ldap_get_values_len($ds, $sr, "userPassword"); |
97 | 97 | $password = $val[0]; |
98 | 98 | // Pour faciliter la gestion on ajoute le code "etape-annee" |
99 | - $official_code=$etape."-".$annee; |
|
100 | - $auth_source="ldap"; |
|
99 | + $official_code = $etape."-".$annee; |
|
100 | + $auth_source = "ldap"; |
|
101 | 101 | // Pas de date d'expiration d'etudiant (a recuperer par rapport au shadow expire LDAP) |
102 | - $expiration_date=''; |
|
103 | - $active=1; |
|
102 | + $expiration_date = ''; |
|
103 | + $active = 1; |
|
104 | 104 | // Ajout de l'utilisateur |
105 | 105 | if (UserManager::is_username_available($username)) { |
106 | - $user_id = UserManager::create_user($firstname,$lastname,$status,$email,$username,$password,$official_code,api_get_setting('platformLanguage'),$phone,$picture_uri,$auth_source,$expiration_date,$active); |
|
107 | - $UserAdd[]=$user_id; |
|
106 | + $user_id = UserManager::create_user($firstname, $lastname, $status, $email, $username, $password, $official_code, api_get_setting('platformLanguage'), $phone, $picture_uri, $auth_source, $expiration_date, $active); |
|
107 | + $UserAdd[] = $user_id; |
|
108 | 108 | } else { |
109 | 109 | $user = api_get_user_info_from_username($username); |
110 | - $user_id=$user['user_id']; |
|
110 | + $user_id = $user['user_id']; |
|
111 | 111 | UserManager::update_user($user_id, $firstname, $lastname, $username, null, null, $email, $status, $official_code, $phone, $picture_uri, $expiration_date, $active); |
112 | - $UserUpdate[]=$user_id; |
|
112 | + $UserUpdate[] = $user_id; |
|
113 | 113 | } |
114 | - $UserList[]=$user_id; |
|
114 | + $UserList[] = $user_id; |
|
115 | 115 | } |
116 | 116 | //} |
117 | 117 | } |
@@ -125,10 +125,10 @@ discard block |
||
125 | 125 | } |
126 | 126 | |
127 | 127 | // Une fois les utilisateurs importer dans la base des utilisateurs, on peux les affecter la session |
128 | - $result=Database::query("SELECT c_id FROM $tbl_session_rel_course WHERE session_id='$id_session'"); |
|
129 | - $CourseList=array(); |
|
130 | - while($row=Database::fetch_array($result)) { |
|
131 | - $CourseList[]= $row['c_id']; |
|
128 | + $result = Database::query("SELECT c_id FROM $tbl_session_rel_course WHERE session_id='$id_session'"); |
|
129 | + $CourseList = array(); |
|
130 | + while ($row = Database::fetch_array($result)) { |
|
131 | + $CourseList[] = $row['c_id']; |
|
132 | 132 | } |
133 | 133 | |
134 | 134 | foreach ($CourseList as $enreg_course) { |
@@ -138,8 +138,8 @@ discard block |
||
138 | 138 | VALUES('$id_session','$enreg_course','$enreg_user')"; |
139 | 139 | Database::query($sql); |
140 | 140 | } |
141 | - $sql = "SELECT COUNT(user_id) as nbUsers " . |
|
142 | - "FROM $tbl_session_rel_course_rel_user " . |
|
141 | + $sql = "SELECT COUNT(user_id) as nbUsers ". |
|
142 | + "FROM $tbl_session_rel_course_rel_user ". |
|
143 | 143 | "WHERE session_id='$id_session' AND c_id='$enreg_course'"; |
144 | 144 | $rs = Database::query($sql); |
145 | 145 | list($nbr_users) = Database::fetch_array($rs); |
@@ -148,13 +148,13 @@ discard block |
||
148 | 148 | Database::query($sql); |
149 | 149 | } |
150 | 150 | // On ajoute la relation entre l'utilisateur et la session |
151 | - foreach($UserList as $enreg_user){ |
|
152 | - $sql = "INSERT IGNORE INTO $tbl_session_rel_user(session_id, user_id, registered_at) " . |
|
153 | - "VALUES('$id_session','$enreg_user', '" . api_get_utc_datetime() . "')"; |
|
151 | + foreach ($UserList as $enreg_user) { |
|
152 | + $sql = "INSERT IGNORE INTO $tbl_session_rel_user(session_id, user_id, registered_at) ". |
|
153 | + "VALUES('$id_session','$enreg_user', '".api_get_utc_datetime()."')"; |
|
154 | 154 | Database::query($sql); |
155 | 155 | } |
156 | - $sql = "SELECT COUNT(user_id) as nbUsers " . |
|
157 | - "FROM $tbl_session_rel_user " . |
|
156 | + $sql = "SELECT COUNT(user_id) as nbUsers ". |
|
157 | + "FROM $tbl_session_rel_user ". |
|
158 | 158 | "WHERE session_id='$id_session' AND relation_type<>".SESSION_RELATION_TYPE_RRHH.""; |
159 | 159 | $rs = Database::query($sql); |
160 | 160 | list($nbr_users) = Database::fetch_array($rs); |